|
||||
|
|
Earlier versions of OOTP: General Discussions General chat about the game... |
|
Thread Tools |
08-05-2012, 01:39 AM | #1 |
Minors (Triple A)
Join Date: Feb 2007
Posts: 232
|
Excel usable reports
Is there any way that outputting the various reports into an excel friendly format (CSV seems easiest) would be possible?
Thanks. Sent from my keyboard using my fingers.
__________________
You insist that there is something a machine cannot do. If you will tell me precisely what it is that a machine cannot do, then I can always make a machine which will do just that! -J. von Neumann Last edited by ohms_law; 08-05-2012 at 01:40 AM. |
08-05-2012, 02:18 AM | #2 |
Minors (Triple A)
Join Date: Mar 2003
Location: Newcastle, Australia
Posts: 299
|
There is an option to output data to csv format.
Out of the Park Baseball Manual You can also open most game reports in an external browser and then copy & paste the information into Excel. |
08-05-2012, 07:16 AM | #3 | |
Hall Of Famer
Join Date: Jul 2004
Location: The big smoke
Posts: 15,628
|
Quote:
__________________
Cheers RichW If you’re looking for a good cause to donate money to please consider a Donation to Parkinson’s Canada. It may help me have a better future and if not me, someone else. Thanks. “Conservatism consists of exactly one proposition …There must be in-groups whom the law protects but does not bind, alongside out-groups whom the law binds but does not protect.” Frank Wilhoit |
|
08-05-2012, 09:01 AM | #4 |
Minors (Triple A)
Join Date: Mar 2003
Location: Newcastle, Australia
Posts: 299
|
I was talking about the html pages.
|
08-05-2012, 10:56 AM | #5 | |
Hall Of Famer
Join Date: Aug 2006
Location: Yankee Stadium, back in 1998.
Posts: 8,645
|
Quote:
Then, open the page in Excel. You may have to select Files of Type: "All Web Pages *htm, *html, etc." in order to see the saved page to be opened. Then, you will have some formatting work to do (for example, the font may be white against a white background, but the numbers are there, just camouflaged) but the good news is that you do have labels and numbers arranged as a spreadsheet, ready for manipulating, analysis, and review. By the way, thanks for this: "Sent from my keyboard using my fingers." I really am tired of seeing this or that message was sent by somebody's Blackberry (oh, sorry, that model's already obsolete, isn't it?) or some other smart phone. Who cares? Long live the computer and keyboard. Last edited by 1998 Yankees; 08-05-2012 at 11:05 AM. |
|
08-05-2012, 12:40 PM | #6 | |
Hall Of Famer
Join Date: Dec 2001
Location: Milwaukee, WI
Posts: 2,435
|
Quote:
I use the below macro to just paste the "values" without any other formatting. Despite its name, numbers are pasted as numbers (does the same thing as Paste Special... paste as Text). Code:
Sub pasteText() ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:=False End Sub
__________________
Roll out the barrel! |
|
08-05-2012, 12:57 PM | #7 | |
Hall Of Famer
Join Date: Aug 2006
Location: Yankee Stadium, back in 1998.
Posts: 8,645
|
Quote:
|
|
08-05-2012, 06:01 PM | #8 |
Hall Of Famer
Join Date: Jul 2004
Location: The big smoke
Posts: 15,628
|
This would be great but the HTML reports don't contain all the stats I need. Thanks for the tip but I'll have to keep using the csv files.
Boy I'm whiney today.
__________________
Cheers RichW If you’re looking for a good cause to donate money to please consider a Donation to Parkinson’s Canada. It may help me have a better future and if not me, someone else. Thanks. “Conservatism consists of exactly one proposition …There must be in-groups whom the law protects but does not bind, alongside out-groups whom the law binds but does not protect.” Frank Wilhoit |
08-05-2012, 10:28 PM | #9 |
Minors (Triple A)
Join Date: Feb 2007
Posts: 232
|
Thanks for the tips, I'm sure some people reading this will be happy to learn about them (I already knew how to do all that and more, but feel free to keep posting how too's. Plenty of people will see this thread for months to come.)
Anyway, yea, 1998 Yankees is correct: I was talking about the in game reports that are only exportable (apparently) through the use of HTML... er, reports. Maybe I'm missing something, but as far as I can tell the reports that are exportable through the import/export functions don't include the same information that the in game reports do (especially the roster screens, with all of the individual ratings).
__________________
You insist that there is something a machine cannot do. If you will tell me precisely what it is that a machine cannot do, then I can always make a machine which will do just that! -J. von Neumann |
Bookmarks |
|
|