OOTP Developments Forums - View Single Post

Bigrod · 03-27-2014, 03:13 PM

Update 2/27: New link in post 1.
Found a couple of bugs and fixed them and will up v1.1 and post it in Post 1 later tonight..
1. When copy pasting from the setup sheet to the template sheet it wiped out the conditional formatting so I applied conditional formatting to the Setup sheet as well. Now you can cut/copy paste from the Setup sheet to the template sheet and not lose the formatting. (Thanks to oman19 for finding this)
2. For some reason that i cannot figure out, when you delete the data I left in the sheets, it caused the Total number of games and games needed to be incorrect in the first teams cells and the Grid so I had to change the way formulas worked. It now resets correctly if you delete the matchups.
3. V1.1 and on will no longer have any data filled in. That should help avoid any possible accidental deletion of import data or formatting. I'll leave the 1.0 that folks can use to get a feel of how to enter the data and see how it works.
4. Added a few more comments...still a work in progress.

03-27-2014, 03:13 PM	#36
Bigrod OOTP Stats Master Join Date: Mar 2009 Location: Maine Posts: 3,075	Update 2/27: New link in post 1. Found a couple of bugs and fixed them and will up v1.1 and post it in Post 1 later tonight.. 1. When copy pasting from the setup sheet to the template sheet it wiped out the conditional formatting so I applied conditional formatting to the Setup sheet as well. Now you can cut/copy paste from the Setup sheet to the template sheet and not lose the formatting. (Thanks to oman19 for finding this) 2. For some reason that i cannot figure out, when you delete the data I left in the sheets, it caused the Total number of games and games needed to be incorrect in the first teams cells and the Grid so I had to change the way formulas worked. It now resets correctly if you delete the matchups. 3. V1.1 and on will no longer have any data filled in. That should help avoid any possible accidental deletion of import data or formatting. I'll leave the 1.0 that folks can use to get a feel of how to enter the data and see how it works. 4. Added a few more comments...still a work in progress. Last edited by Bigrod; 03-27-2014 at 06:42 PM.