# Can I please get the link to the spreadsheet that tells you what to spend GP on?

6 posts

 I used to play multiple years ago. There is a spreadsheet in google docs to help you decide on buying Creation Count, Creation Speed, Build Speed, etc... Tried googling and I see links to lots of spreadsheets, but not that one. I asked in chat and no one knew about it. Used to be common knowledge. Would my spreadsheet be the one you're thinking of? https://docs.google.com/spreadsheets/d/18Op2OdrlKFR5kMq41eNSHZ-MVVB3s3IfrqeN4ej9Bww/edit#gid=1349761365 Am I just using this wrong or does it just REALLY love making new clones over buildspeed. played around with that one tab some and if you have only 90 build speed with 1 million clones, it still recommends building clones. Did he just edit it? Because I see your numbers filled in and the last box displaying "build speed". Anyway, I tend to just do my own thing and don't really care if I'm not making the most efficient upgrades or whatever, but I'm kind of curious where the spreadsheet's formula could be coming from. > =IF(B2 >= CEILING((B1 + 100%) * (20/175) * 100000), "Build Speed", "Clone Cap") So you're multipyling "build speed + 100" by 20/175 and by 100k (or "build speed + 100" multiplied by about 11,428.57) and the result is rounded up and then compared against "clone cap". Why those numbers? Where does any of that come from? Also, how relevant even is this for "efficiency" since the addition of crystal power offered a source for create and build speed that doesn't cost any GP? Like for me right now my GP-bought build speed is roughly 2/3 of my actual build speed, assuming no currently equipped crystals (and it can be closer to 1/3 of my total build speed when I do have crystals equipped and leveled). I don't really get how he set his multipliers either. But it seems to work based on the numbers given on the Wiki. "After this it is recommended you keep a ratio of 175% build speed to every 20,000 clones. Keep in mind you have a base 100% build speed that isn't included in the build speed on the GP screen. This means you must first buy 775% build speed (giving you 875% total) to match your initial 100k clones." This was under the God Power tab. I tested his spreadsheet and at 775% build speed with 100,000 clones, it said build speed, but changing it to 776% build speed had the clones on top. So it seems accurate for that. And for Cyclops398... I'm pretty sure you forgot to leave the % in your numbers. So you're telling it that you have 9000% build speed by saying 90. I think that's what's throwing off the numbers for you. > *Originally posted by **[koryuucialce](/forums/2874/topics/886170?page=1#11765499)**:* > And for Cyclops398... I'm pretty sure you forgot to leave the % in your numbers. So you're telling it that you have 9000% build speed by saying 90. I think that's what's throwing off the numbers for you. Ah I see. That was it, knew something had to be up :) Thanks