white frog
06-09-2012, 04:55 AM
I've noticed, and been told about, a couple of issues with the new release, and wanted to have a single place to list them and their solutions. If more issues are found, check back on this original post for the solution, as I will just edit this post to include them.
Here is the list as of this morning:
Issue:
Tycoon values on "Defense Buildings" not rounding up properly
Solution:
1. Go to the "Defense Building" page
2. Unprotect the sheet by going to the "Format" tab at the top and choosing "Unprotect Sheet"
3. Highlight the cell for the Tycoon defense for the level 1 Abandoned Building (J5)
4. Click in the formula bar, delete what's there, and change it to: =ROUNDUP(I5*1.1,0) Hit "Enter"
5. Highlight the cell again, click and hold the little + sign in the lower right, and drag all the way to the bottom of the page, highlighting every cell in the Tycoon column.
Fixed in downloadable file as of 6/11
Issue:
Incorrect value for Level 7 Machine Gun Turret
Solution:
1. On the "Defense Building" page, go to "Format" at the top
2. Select "unprotect sheet"
3. Change the value from 73 to 72
Fixed in downloadable file as of 6/11
Issue:
Some of the weapons (mostly top level) are not being added to the equipment total #s
Solution:
1. Unprotect the "Attack" page using the above method
2. Highlight the cell that totals the # of Guns owned (cell B405 in the unchanged version)
3. click into the formula bar (***be very careful here not to mess up the formula)
4. Scroll to the very top... you will probably see that the top few guns are not in the highlighted bracket
5. Click and hold the little + sign in the "highlight" and drag it up to include these top guns, or simply change the formula to start with the top cell (final formula should be = SUM(B4:B403) unless you've added more weapons)
6. Repeat this process for the different weapons (I believe that Guns and Melee were the only ones with this issue, but I can't be sure)
Fixed in downloadable file as of 6/11
Here is the list as of this morning:
Issue:
Tycoon values on "Defense Buildings" not rounding up properly
Solution:
1. Go to the "Defense Building" page
2. Unprotect the sheet by going to the "Format" tab at the top and choosing "Unprotect Sheet"
3. Highlight the cell for the Tycoon defense for the level 1 Abandoned Building (J5)
4. Click in the formula bar, delete what's there, and change it to: =ROUNDUP(I5*1.1,0) Hit "Enter"
5. Highlight the cell again, click and hold the little + sign in the lower right, and drag all the way to the bottom of the page, highlighting every cell in the Tycoon column.
Fixed in downloadable file as of 6/11
Issue:
Incorrect value for Level 7 Machine Gun Turret
Solution:
1. On the "Defense Building" page, go to "Format" at the top
2. Select "unprotect sheet"
3. Change the value from 73 to 72
Fixed in downloadable file as of 6/11
Issue:
Some of the weapons (mostly top level) are not being added to the equipment total #s
Solution:
1. Unprotect the "Attack" page using the above method
2. Highlight the cell that totals the # of Guns owned (cell B405 in the unchanged version)
3. click into the formula bar (***be very careful here not to mess up the formula)
4. Scroll to the very top... you will probably see that the top few guns are not in the highlighted bracket
5. Click and hold the little + sign in the "highlight" and drag it up to include these top guns, or simply change the formula to start with the top cell (final formula should be = SUM(B4:B403) unless you've added more weapons)
6. Repeat this process for the different weapons (I believe that Guns and Melee were the only ones with this issue, but I can't be sure)
Fixed in downloadable file as of 6/11