Excellent spreadsheet!!Seems it would have taken a lot longer than a few hours to make. Just typing in all the info would take forever. I bet you had these items in another spreadsheet. :) Only thing I noticed is that the column size is locked and I couldn't widen it to see all the costs in the Special Buildings tab. Thanks for posting.

Thanks for letting me know :) The sheets are protected so that you can't accidentally mess up the calculations. I've updated it with a wider column, hopefully that sorts it out.

This is very awesome of you to do for everyone! I was *literally* right in the middle of trying to figure this stuff out. You are a life saver :mrgreen: :mrgreen:

Arlandria606 wrote:Thanks for letting me know :) The sheets are protected so that you can't accidentally mess up the calculations. I've updated it with a wider column, hopefully that sorts it out.Whilst I understand the desire to protect your formulae, it's kind of annoying :-)How well the information formats is dependant upon the user's screen resolution, the program used to read the file, and various custom and default layout information which can be different from one user to another. Not everybody is on the same version of Excel (if they're using Excel at all ... some people might be using Google or other non-MS products that read xls files).For those of you on Excel 2007, go to the Review tab and click 'unprotect worksheet' and/or 'unprotect workbook' to unlock all the functions that the OP locked. Other versions of Excel should have a similar button, use Help if you can't find it easily. Oh, and you have to click 'unprotect sheet' on each tab in the workbook.Cheers :-D

muleheadjoe wrote:Arlandria606 wrote:Thanks for letting me know :) The sheets are protected so that you can't accidentally mess up the calculations. I've updated it with a wider column, hopefully that sorts it out.Whilst I understand the desire to protect your formulae, it's kind of annoying :-)Clearly I protected it for a reason, and it wasn't to just "protect my formulae". It's kinda rude of you to just go ahead and decide to tell everyone else to unprotect it.If you find my spreadsheet annoying, you're more than welcome to make your own.

It looks really awesome. I can tell you put a lot of work into it and I think you did a great job :D

The Ultimate TSTO Spreadsheet | EA Forums

MuleHeadJoe
12 years ago
Arlandria606 wrote:
If you want to point out actual errors/omissions or suggest improvements, great.

Suggestion: add "XP Received" columns in Revenue Calculation, Special Buildings, and Squidport Tiles worksheets.
Arlandria606
12 years ago
muleheadjoe wrote:
Arlandria606 wrote:
If you want to point out actual errors/omissions or suggest improvements, great.

Suggestion: add "XP Received" columns in Revenue Calculation, Special Buildings, and Squidport Tiles worksheets.

I considered doing that, but decided not to for a few reasons. With the Christmas update expected any day now I don't want to start on something else, so it's shelved for the time being. I'll look at it again after the Christmas update.
ultimate1979
12 years ago
Arlandria606, not sure if it was intentional or not, but I don't think your formula are quite correct. For "Indolence", you have SUM(L3:L29) but there are actually things down to L30. If you change that formula and all of the formulas for Indolence, Consumerism, Public Buildings, Gluttony to just the Column, then it will sum the entire column for you and you don't have to change the formulas as you add more things...

Indolence : =SUM(L:L)
Consumerism : =SUM(R:R)
Public Buildings : =SUM(X:X)
Gluttony : =SUM(AD:AD)

Also, the "Buildings" sum is only using the Indolence Total column instead of summing D10:D13

Another thing, would it be possibly to add another sheet that had Krustyland Payout information?

Thank you. The spreadsheet is very helpful for me to see what I should get next.
KrystynaM
11 years ago
Just checking if it's just me: can anyone still access this spreadsheet? I get a 404 error.
Thanks
roshigoth1
11 years ago
KrystynaM wrote:
Just checking if it's just me: can anyone still access this spreadsheet? I get a 404 error.
Thanks

Well, it's nearly a year old, and even if it was still available it would be hopelessly out of date.
KrystynaM
11 years ago
roshigoth1 wrote:
KrystynaM wrote:
Just checking if it's just me: can anyone still access this spreadsheet? I get a 404 error.
Thanks

Well, it's nearly a year old, and even if it was still available it would be hopelessly out of date.

Yes I can read the date :-)
Thanks for letting me know it's not just me, appreciate it.

Cheers
snowyriver32
11 years ago
I can still download it just fine.
No 404 error for me.
jasondecrae
11 years ago
For me it gives me a 404 error as well (both when signed in to DB and when not).

Forum Discussion

The Ultimate TSTO Spreadsheet

About TSTO Tips & Guides

Related Posts

Ultimate Journey

Ultimate Journey

GL Ahsoka Ultimate Ability

Jabba ultimate

Ultimate journey event difficulty

Recent Discussions

Frankie the Squealer

Common Tapped Out Game Issues and Solutions

Splash Screens Set 6

Character List by Date

Splash Screens Set 5