We still did not get a response that would explain why it was taken down. Our best guess from the limited response which was a vague form letter was something to do with malicious traffic.
When we tried to rebuild the spreadsheet from the most recent back-up there were some corrupted cells so we did it from scratch.
To be safe moving forward every time we update the spreadsheet it will be a separate page. So if you
to get to the spreadsheet and just save that link it will be deactivated with the next update. We will update the link right here on this page so you'll have access to the most up to date spreadsheet but the out of date spreadsheets will be removed. So just come click that big link. We're currently building-out some of the stuff that's missing like the QI settlement conversion tool and individual tabs for events. We probably won't add it all back as all the buildings are there now.
Moving forward all the values will be in SAD age and presumed motivated/polished.
The first noticeable change is the three value tabs. The first one is the legacy formula.
- 10 FP equals
- 40 goods
- 1,500 pop
- 1,500 happy
- 200 troops
- 1 Quantum Action
- 10 fight boost (base, GE or GbG)
- 1 fight boost QI
The problem with that is not all things are created equal and for a large portion of the player base GE boosts are irrelevant to a building's overall value.
Also while all players need red and blue attack and defense base value and GbG they do not need both for QI.
So the next two value tabs eliminates all GE boosts and the red or blue QI boosts.
That means if you're a red QI fighter that also does not need GE boosts the second value tab is for you.
If you're a blue QI fighter that also does not need GE boosts then that third tab is for you.
If you notice an error please comment so we can fix it. The four of us did our best but I'm sure there will be transposition errors. We caught a bunch before publishing. It's real easy to lose concentration after doing it for a long time so pointing it out will help us and your fellow players.
9/25/2026 Updated to add Halloween Event buildings
10/24/2020 updated to add newest QI buildings and Winter Event buildings
Thanks for rebuilding the spreadsheet. Huge undertaking I am sure. The 'Combined Values' column does not include GBG stats. I assume that is an oversight?
ReplyDeleteI can't find where it's not included. Please let us know what tab and what building if you have time so we can fix it.
DeleteIt should which tab and which building?
ReplyDeleteWe're aware that some of the values in the happiness column are corrupted and will be resolved over the weekend.
ReplyDeleteHappiness has been corrected please let us know if you find anything else.
ReplyDeleteHi, sorry it has been a few days to get back to you. The formula for the 'Combined Values' does not include the 'AM' and 'AQ' columns. This is the formula from the Eternal Market Golden Horizon - =AK184+AL184+AN184+
ReplyDeleteAO184+AP184+AR184+AS184+AT184+AU184+AV184+AW184+(BF184/H184). This seems to be consistent for all the buildings that I looked at.
Thank you so much for some reason the copy formula command didn’t work so it was wrong on all the tabs. It’s fixed now. Feel free to give your player name or guild a shout-out. You made it better and in turn have helped other players.
DeleteOk, so I just made a copy of the spreadsheet to adjust the formula and the formula for the Abandoned Asylum appears to be correct but the formulas below that are as noted in my last comment.
ReplyDeleteWith the separate blue and red value tabs do we even need the combined tab?
ReplyDeleteWhile the majority of the users of this site are experienced or long-time players there are a lot of new or newish players that use it. These folks may need GE boosts or have cities that don’t specialize in red or blue QI. They just place as many good buildings as possible.
DeleteLeave no forger behind.
If you go to the Halloween tab we posted all the buildings twice on that one page. First sorted by red QI no GE then by blue QI no GE.
DeleteThat should make it easier to see what to go for in events.
There are two sets of Globe Fountains posted. I believe the ones with the combined values of 74.7(lvl1) and 94.0(lvl2) are correct
ReplyDeleteFixed in the alphabetical tab thank you. Will update for the rest of the tabs when we input some of the new buildings about to come out. It's easier just doing it all at the same time.
DeleteThank you for this.
Hi, new to this spreadsheet - but love it already💪
ReplyDeleteI think I found some wrong (SAD)values:
Forgotten temple, Blue att/def should be 50% and all 4 GBG values should be 155%
Ramen Nook lvl 2 seems to have been nerfed. Red att/def should be 260%,(lvl1-180%) Red&Blue GE 210%, (lvl1-0%) Red BGB 240%,(lvl1-190%). Spreadsheet also says 4% and 2% FP collection, but Ramen Nook has no such bonus.
Roofline Express is misspelled - the ingame name of that building is Rootline Express + Blue att/def 240% is missing in spreadsheet.
Forgotten temple values are for SAT which is when it was introduced. In the last year or so we started adding the age of when the values were captured so that building pre-dated that. Column AI shows the age but it's mostly blank as we've only been putting that in for the newer buildings.
ReplyDeleteRamen Nook stats were captured in testing and we did not adjust for when it came to beta and live server. Nice catch thank you we are correcting it.
Same for rootline express. The spelling error was mine but the value difference changed from beta.
We need to do a better job capturing the changes from beta to live when they happen. Once again good catch and thank you.
I might be dumb, but I don't see Lindworm Keep anywhere in the sheet. I think it is spelled wrong as Lindwood Keep
ReplyDeleteI am the dumb one. Thank you and it's fixed now
Delete