To make the custom standings page which the spreadsheet is formatted for:

1) Go to Reports->Standard,customized, memorized
2) Select League standings/DMB league standings
3) Click Generate
4) Select Major League Baseball (Org) in the For org or league: pulldown
5) Select Full Name in the Sort division standings by: pulldown
6) Under sections I removed Wildcard, Expanded1, and Expanded2
7) Hit OK, then click Customize
8) Remove Year, Overall Winning pct, Games behind, <blank>, Last ten games, Current streak, Recent results, and magic #
This should leave: Full name, Wins, Losses, Runs for, Runs against, and Run margin
9) Go to close it, and you'll get prompted that it's been customized, and do you wish to save it.  Save it with a unique name.

When I finish a season, I do a report, pick the customized one i just created, and select to output to a file in text format.  I append a number at the end, then restart and re-run.

You can then copy and paste the text file onto one of the worksheets on the spreadsheet, do a text to columns to convert it to data, then put a 1 next to the teams that won the division in column G, and a 1 next to the wild card winner column H.  I break ties with Run Mgn, not the cleanest way but saves time.

I have created a macro to speed up the importing of these text files into the spreadsheet.
In order to use them:

1)You must give the files the name "DMB league standings sorted by nameXX.txt", where XX is the season # 1-100.
2)The files must be saved into the folder"C:\dmb9\2005 ZiPS"

If you know how to edit macros in Excel, you can change these to whatever you are calling them.  


In order to run the macro, go to Tools->Macros->Macros, and run ImportSeasons.


It will work for fewer than 100 seasons, but you'll get an error when You hit the last file.  You will still have to manually update the Division and Wild Card columns until I figure out how to automate those.



