My excel file Contribution

[MadArkael]

I spent a good while with this, so I hope some of you enjoy it.

All you really need to do to get the most out of this tool, is make sure your buildings in the data tab are accurate, the angels in the data tab, and make sure you have the correct upgrades checked in the Upgrades tab.

With this you can:
- use the geometrics tab and put in desired amount of x business and based on how many you have, how many you want, and your current money per second it will tell you how much time in hours it will take to achieve this.
- See how long it will take in hours based on your current money per second to achieve x2-x10 angels

The unlocks tab is completely automatic, you can go here to look at the formulas, see whats going on, but you should never have to change anything here. It is entirely based of your business amounts, and appears to be 100% accurate up to the point I am at currently in the game.

The way I cleaned up the numbers on the data tab is kinda hacky, if someone would enlighten me to a better way, I'd appreciate the feedback. Currently its a series of nested if statements.

https://docs.google.com/spreadsheets/d/1UQMWv-3dvreEl9vVlpQ7Yk2Lba9Q7_CGp4efpQOV_9s/edit?usp=sharing

Good luck to all in your endeavors to become ridiculously rich :)

Edit: Realized all the check boxes from excel didn't transfer to google sheets, changed all upgrades to use Data Validation. True or False.

[blueinfinity]

Better than the dev oh wait the devs didnt even test the game....

[Crunchy[Daz]]

Originally posted by Blue Infinity:

Better than the dev oh wait the devs didnt even test the game....

And you wonder why people would ban you.....lol

[MadArkael]

Salzig, Salt. So much salt.

Originally posted by Blue Infinity:

Better than the dev oh wait the devs didnt even test the game....

[Sequestered Carbon]

Good job on the spreadsheet.
It's accurate and useful for planing next purchase.

It would be nice if column B was narrower so the number was closer to the label.
Would have to move "Total Profit Multiplier" and angle counts.

+- buttons for amount of business would be nice, but are not easy to do with Google sheets,

[MadArkael]

I'll look into the buttons appreciate it :)

Edit 1: When you get into later game, your numbers tend to be 100's and 50's so just adding one or two isnt as useful, but i'll look into it for sure

[MadArkael]

I had the formulas already done for a better way to display what number your dealing with. Converting digits to names essentially. It now pulls from a table on the right side of the Data sheet. I played with the idea of a + and - buttons but I need to create a graphic first and its late. So possibly if I have time i'll hop on that tomorrow.

[forSeth.at]

Love the Sheet, i just get on Error and that is the Profit of Newspapers is off, it calulates 1.998 Septillions and ingame i get 3.995, i've been looking through it and the calculation should be sound and everything else calculates correctly(i get the correct result when i multiply Data!29 by 2 - i just dont have a clue why :D), not the biggest problem as newspapers seem to be the pain in the arse of the game anyway but maybe you can find whats wrong

[archmag]

Originally posted by MadArkael:

I spent a good while with this, so I hope some of you enjoy it.
...
https://docs.google.com/spreadsheets/d/1UQMWv-3dvreEl9vVlpQ7Yk2Lba9Q7_CGp4efpQOV_9s/edit?usp=sharing

Really good work, thanks for the sheet! That's some excel magic.

Some mistakes:
1. (DATA!M2:M11): 99.999% decrease in cost does not result in 0.001 multiplier, but in 0.00001
2. (DATA!D28:D37): when counting raw Cost for next it does not take into consideration bonuses to business that you can buy with angels (they don't increase cost, so they should be substracted from total amount of businesses that we input)
3. (DATA!B29): you forgot to multiply income from newspapers by total bonus Unlocks!AR46

Remaining problems:
Donuts: 2.112 in Excel, 1.41 actual, x1.5 difference
Shrimps: 8.393 in Excel, 5.595 actual, x1.5 difference
Hockey: 213.15 in Excel, 165.786 actual, x1.3 difference
Movies: 82.254 in Excel, 73.116 actual, x1.125 difference
All other businesses show very precise value. Not sure what's wrong with these ones. Maybe initial time is wrong, will check at next reset.

Anyway thanks again for spreadsheet, "played" for two hours with it. Enjoyed it as much as the game.

[forSeth.at]

ah nice find

interesting with those differences i get none of those, mine are all on point now that newspaper is fixed

did you check the upgrade page completly? because you might not have one of the angel upgrades unlocked that are already on true from the creators entries(looks to me like on of the investor% increases)

[archmag]

I'm almost at an end, so I am only missing two gold upgrades and three money upgrades, so I just put everything else to True:
https://docs.google.com/spreadsheets/d/1Uo9p7-CkWI_dnYL6Zz8PeTrhCErGG9AorKbaq6wMWCM/edit#gid=561770605

There should be an extra table with upgrades that you get for angels that give extra amount of businesses. But I can't find it. As a result Cost to next calculations give numbers about x10 more than I have in game (x10 times for lemons, x10^7 for newspapers). Maybe you don't notice a difference yet because you only have +10 and that's a very little increase?

Ahh, wait, you were talking about remaining problems.... Sorry, misinterpreted your post. I am not sure what could make such difference, there are no upgrades that give x1.5. Unless there is a mistake in one upgrade/unlock and it provides x3 instead of x2. Hmm, that can be an issue actually. For Hockey it will be x4 instead of x3 and for movies x9 instead of x8. Will check that list after next reset by buying all upgrades one after another and comparing to this upgrades list. Maybe you don't have this problem upgrades/unlocks yet, so you don't have this problem. That means it's somewhere in the latter part of a list.

[MadArkael]

Hey Guys, yeah I haven't touched the game for a while, I got frustrated after dumped almost 100 hours in lol. Glad the spreadsheet could give you some satisfaction. I never actually got to test the final upgrades, it's quite possible the numbers could have been skewed.

Also, you guys should check the game itself to see if the money you make per second is what it should be. For a while there all the businesses, that after upgraded, their timers were so short that the logic in game was actually wrong for computing money per frame. I wrote a ticket into these guys explaining it twice and how while offline you made the correct money, but online the money per frame was about half of what it should of been, they responded promptly twice, but never updated me on it.

If this is the case and you're still really into the game, complain! The squeaky wheel gets the grease.

[MadArkael]

Originally posted by archmag:

I'm almost at an end, so I am only missing two gold upgrades and three money upgrades, so I just put everything else to True:
https://docs.google.com/spreadsheets/d/1Uo9p7-CkWI_dnYL6Zz8PeTrhCErGG9AorKbaq6wMWCM/edit#gid=561770605

There should be an extra table with upgrades that you get for angels that give extra amount of businesses. But I can't find it.

That's because it never existed, It wouldn't be all that hard to calculate the subtracted value of the businesses in the geometrics tab, I apologize, but with kiddos on the way I hardly have any time on the computer right now.

So unfortunately after you get the +business upgrades with angels, the geometrics tab and the cost will become inaccurate :S.

Edit: I fixed the .001 to .00001, giant brain fart on my part, I also multiplied the newspapers by the all profit unlocks under the total profit multiplier. Thanks for the corrections.

Archmag, if you have an interest in adding in the +business angel upgrades, get in contact with me on steam and we'll work out a way to share it with you so you can edit this original. I do see several people still using it, so just let me know.

[archmag]

For Hockey it's Upgrades:X23 - should be 14 instead of 18, now it's correct. Don't know where other three mistakes are (Donuts, Shrimps, Movies), it's hard to check when not all upgrades are displayed in a list.

Archmag, if you have an interest in adding in the +business angel upgrades, get in contact with me on steam and we'll work out a way to share it with you so you can edit this original. I do see several people still using it, so just let me know.

Nah, I had my fun looking for what was wrong, now I know, that's enough for me. Fixing would require too much time with the way upgrades are displaying now.

[MadArkael]

Yeah, Its not the prettiest thing for sure. I haven't touched Excel in over 10 years. I literally was like hey I am a programmer, excel should be easy, and dove in.

Hockey's 23rd upgrade is now correctly x14. Thanks.