|
||||
|
|
OOTP 14 - New to the Game? If you have basic questions about the game, please come here! |
|
Thread Tools |
01-02-2014, 07:51 PM | #21 |
Minors (Rookie Ball)
Join Date: Dec 2013
Posts: 42
|
I know how to export rosters.
I don't, but need to, know how to export standings. I don't, but need to, know how to export a schedule. I don't, but need to, know how to export a list of game results. |
01-02-2014, 08:22 PM | #22 |
Hall Of Famer
Join Date: Mar 2008
Location: Tampa Bay
Posts: 6,407
|
2. Schedules are in a text file. It is a simple job to copy the text files to Excel. If you have elementary skills with "text to columns" and "concatenate" it is real easy to manipulate. Schedules are here:
As long as you stick to the naming convention you can load your altered schedules here: Also note that you can export 2 separate xml reports in this same menu. Good for checking that you didn't screw up the schedule.
__________________
PBA Quickstart for OOTP Background Images Collection All PBA games broadcast live on Steam. Last edited by Honorable_Pawn; 01-02-2014 at 08:41 PM. |
01-02-2014, 08:31 PM | #23 |
Hall Of Famer
Join Date: Mar 2008
Location: Tampa Bay
Posts: 6,407
|
3. Game results.
First go here: This will happen: Then go here and open this file: Here is your data:
__________________
PBA Quickstart for OOTP Background Images Collection All PBA games broadcast live on Steam. |
01-02-2014, 08:37 PM | #24 |
Hall Of Famer
Join Date: Mar 2008
Location: Tampa Bay
Posts: 6,407
|
1. I dont see a good way to export standings but if you are handy with excel you could probably come up with a way to rebuild the standings directly from the data in the game results spreadsheet.
It would take a little bit of work but it is totally doable. If you are comfortable with recording macros you would only have to do it once. Then you just run the macro every time going forward. I'm not sure if you know but you can see past current year standings here:
__________________
PBA Quickstart for OOTP Background Images Collection All PBA games broadcast live on Steam. Last edited by Honorable_Pawn; 01-02-2014 at 08:44 PM. |
01-02-2014, 08:40 PM | #25 |
Hall Of Famer
Join Date: Mar 2008
Location: Tampa Bay
Posts: 6,407
|
I don't know how good you are with excel but I can show you a VLook-up formula and how to use it so that you can replace Team ID Numbers with actual team names and how to replace Player ID Numbers with actual player names.
__________________
PBA Quickstart for OOTP Background Images Collection All PBA games broadcast live on Steam. |
01-02-2014, 09:42 PM | #26 |
Minors (Rookie Ball)
Join Date: Dec 2013
Posts: 42
|
Wow, that's so helpful. I have a baseball world in handy little files now.
This VLook-Up thing would be very helpful. |
01-02-2014, 10:26 PM | #27 |
Hall Of Famer
Join Date: Mar 2008
Location: Tampa Bay
Posts: 6,407
|
Ok, I'll show you how it works tomorrow evening. It's pretty easy once you use it a few times.
__________________
PBA Quickstart for OOTP Background Images Collection All PBA games broadcast live on Steam. |
01-02-2014, 10:52 PM | #28 |
Hall Of Famer
|
For standings you can look at the Team_Record.csv. There are a couple of other pieces of information you will need, although depending on whether you change the structure you probably would need to only get those once from the team_relations.csv (based on the team_id), and the team name/nickname from the teams.csv (based on the team_id). I've found it best to concatenate the league_id, sub_league_id, and division_id (all from team_relations) with the pos (from team_record). That would give you a column to sort by that would produce the correct order per division.
Just as a sample I was producing these standings using that method: http://www.ootpdevelopments.com/boar...ml#post3615722 I did switch to access and excel to automate it better, but I can help answer any questions too. And I've also got a sample spreadsheet that I can show you with some sample formulas as well if you are interested. Last edited by NYY #23; 01-02-2014 at 10:59 PM. |
01-07-2014, 05:26 PM | #29 |
Hall Of Famer
Join Date: Mar 2008
Location: Tampa Bay
Posts: 6,407
|
So are you good with all this?
Anything else you can think of?
__________________
PBA Quickstart for OOTP Background Images Collection All PBA games broadcast live on Steam. |
Bookmarks |
|
|