"All-in-One" Known Issues and Fixes

GREE

DECAGAMES Forum - Powered by vBulletin
Results 1 to 11 of 11

Thread: "All-in-One" Known Issues and Fixes

  1. #1
    Articulate Author white frog's Avatar
    Member Since
    Dec 2011
    Location
    Kansas City
    Post Count
    494

    "All-in-One" Known Issues and Fixes

    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
    Last edited by white frog; 06-11-2012 at 05:49 AM.
    CC "All-In-One" Spreadsheet version 4.0
    Tutorial on "Selling Low Level Buildings:"
    Part 1
    Part 2

  2. #2
    Articulate Author Spartacus's Avatar
    Member Since
    May 2012
    Post Count
    355
    My Tycoon IpH is a bit off but that's probably my fault. Great job White Frog!

  3. #3
    Articulate Author white frog's Avatar
    Member Since
    Dec 2011
    Location
    Kansas City
    Post Count
    494
    Quote Originally Posted by Spartacus View Post
    My Tycoon IpH is a bit off but that's probably my fault. Great job White Frog!
    Yeah.. so is mine. But this has always been the case. For some reason, the game has a unique way of adding up the hourly income. For example, the Level 1 NC Tycoon income is $192,501. Where the heck did the extra $1 come from???
    CC "All-In-One" Spreadsheet version 4.0
    Tutorial on "Selling Low Level Buildings:"
    Part 1
    Part 2

  4. #4
    Verbose Veteran Feng1234's Avatar
    Member Since
    Apr 2012
    Post Count
    628
    Bump. Are these fixed in the download spreadsheet? Or do we have to manually do it?
    Join The Politicians - An active and diverse group of players from around the world. Come and join the family and see the difference for yourself!

    Syndicate code: 613832871

    My personal invite code: 111765313

  5. #5
    Articulate Author white frog's Avatar
    Member Since
    Dec 2011
    Location
    Kansas City
    Post Count
    494
    These are the manual fixes if you've already input your information... I didn't want you to have to do it twice. I haven't gotten the fixed version uploaded yet though! I've been working all day on my book!
    CC "All-In-One" Spreadsheet version 4.0
    Tutorial on "Selling Low Level Buildings:"
    Part 1
    Part 2

  6. #6
    Verbose Veteran Feng1234's Avatar
    Member Since
    Apr 2012
    Post Count
    628
    Cool man. Youve so so much so we can wait a bit longer.
    Join The Politicians - An active and diverse group of players from around the world. Come and join the family and see the difference for yourself!

    Syndicate code: 613832871

    My personal invite code: 111765313

  7. #7
    Lurker
    Member Since
    Nov 2012
    Post Count
    3

    Question how to add items?

    Thanks for the awesome work on your spreadsheet. How do I add equipment items to it in order to keep it up to date? I added in a Close Combat MG (60/40)to the Guns sheet, but it doesn't change my attack total. Where is 'Equipment Summary'!D5 ?

  8. #8
    Articulate Author white frog's Avatar
    Member Since
    Dec 2011
    Location
    Kansas City
    Post Count
    494
    The Equipment Summary is between the "Goal Calculator" and the "Guns" worksheet. There are instructions on this page on how to add items. If you can't figure it out, PM me and I'll try to help!
    CC "All-In-One" Spreadsheet version 4.0
    Tutorial on "Selling Low Level Buildings:"
    Part 1
    Part 2

  9. #9
    Prominent Poet Nighteg's Avatar
    Member Since
    Jul 2012
    Post Count
    1,367

    Refresh

    Hi.
    Since for some reason i can't post a new thread, I'll ask here:
    I'm playing on Galaxy S2.
    I have a problem with refresh. I open the "rivals" window, see a certain list, press the "refresh", and still see the same list (even though the refresh worked, cause if i attack someone on that list i see a different name in the "fight results" window). It's very frustrating, considering that lately i get crazy rivals lists (i have 400 mafia and i get lists of people with 3000 mafia and 3 times my defence). I've tried to uninstall, reinstall. Nothing works..
    Any suggestions?
    Thanks.

  10. #10
    Supreme Scholar Dipstik's Avatar
    Member Since
    Jan 2012
    Post Count
    8,520
    How did this become the designated "I can't make a new thread so I'll just post my question anywhere" thread?
    Quote Originally Posted by murf View Post
    Dippy, may be a little harsh in this thread, but he's right...
    Still mad at Bostick.

    I'll be back when the moderation is reasonable. Enjoy the forum you created, Gree.

  11. #11
    Lurker
    Member Since
    Nov 2012
    Post Count
    3

    thanks!

    Quote Originally Posted by white frog View Post
    The Equipment Summary is between the "Goal Calculator" and the "Guns" worksheet. There are instructions on this page on how to add items. If you can't figure it out, PM me and I'll try to help!
    Ahh, I didn't scroll down enough to have that catch my eye. Good instructions. My gun add worked.
    Cheers!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •