Ultimate Black and Blue Friday event spreadsheet

[Jimbly]

https://docs.google.com/spreadsheets/d/1dajM2192nHVpYh1ZIOhBGs-TMb4J0zHUjkgdXjFcCQM/edit?usp=sharing

Automatically takes into consideration upgrades, achievements, angels, and current levels to determine the most efficient upgrade.

Similar spreadsheets for some of the other AdVentures coming soon!

[DaveKap]

I think the only thing missing from the instructions is a "how do I use this to my benefit" bit for people who are fresh to these kinds of games and aren't sure how to use this spreadsheet to guide their purchase decisions.

[Jimbly]

Good point, updated the instructions, thanks.

[ace-mos]

how do i use this as in change the numbers it wont let me alter anything

[William]

Not sure if doing something wrong, but the figures for Door Crashers and Power Tools appear to be way under that of what I am getting in game yet the rest of it is correct,

e.g I'm getting 12.7b per batch with 40 but the sheets show that it should be 28m per batch?

(Just realised that it's probably the vacuum boosts but I can't see an option for that anywhere)

[horseplayer]

I don't get it. There's a bunch of empty cyan cells and I don't know what I am supposed to put in them

[Cheesey]

Wow, great work! That's a huge file, but damn! Thank you!! =)

Only thing I don't understand are "Shop Multiplier" and "Flux Capacitor". What am I supposed to do with them? (What is the Flux Capacitor in this game anyway?)

Great work, thank you!

[Jimbly]

Forgot to mention you need to save a copy of your own to be able to edit it, instructions updated.

Sorry, Flux Capacitors are not used in Black and Blue, only on the Moon (but I like to be able to copy all of the formulas back and forth between sheets if I fix something, so it's still there). Shop multiplier is if you buy multipliers in the Gold shop, which I don't recommend doing for this event, but, if you really want to send money to the devs, why not!

[Jimbly]

Originally posted by Shoar:

Not sure if doing something wrong, but the figures for Door Crashers and Power Tools appear to be way under that of what I am getting in game yet the rest of it is correct,

e.g I'm getting 12.7b per batch with 40 but the sheets show that it should be 28m per batch?

(Just realised that it's probably the vacuum boosts but I can't see an option for that anywhere)

Have you entered in the numbers for how many Sucky Vacuums, etc you have? E.g. if you put in 6 for all of them, it should apply the Everything unlock that gives a 50x multiplier to Door Crashers.

I'm not particularly far along, since I reset just to get some exact numbers for the spreadsheet, so it's possibly I've missed something, but so far things are matching for me.

[Jimbly]

Originally posted by Jimbly:

Originally posted by Shoar:

Not sure if doing something wrong, but the figures for Door Crashers and Power Tools appear to be way under that of what I am getting in game yet the rest of it is correct,

e.g I'm getting 12.7b per batch with 40 but the sheets show that it should be 28m per batch?

(Just realised that it's probably the vacuum boosts but I can't see an option for that anywhere)

Have you entered in the numbers for how many Sucky Vacuums, etc you have? E.g. if you put in 6 for all of them, it should apply the Everything unlock that gives a 50x multiplier to Door Crashers.

I'm not particularly far along, since I reset just to get some exact numbers for the spreadsheet, so it's possibly I've missed something, but so far things are matching for me.

Oops, sorry, had something wrong in the achievement tables, it is now fixed (it was not applying the Everything unlock), spreadsheet version now "1.2". Thanks.

[William]

Originally posted by Jimbly:

Originally posted by Jimbly:

Have you entered in the numbers for how many Sucky Vacuums, etc you have? E.g. if you put in 6 for all of them, it should apply the Everything unlock that gives a 50x multiplier to Door Crashers.

I'm not particularly far along, since I reset just to get some exact numbers for the spreadsheet, so it's possibly I've missed something, but so far things are matching for me.

Oops, sorry, had something wrong in the achievement tables, it is now fixed (it was not applying the Everything unlock), spreadsheet version now "1.2". Thanks.

Thanks! :)

[majikthise.uk]

Can't get it to download in ods only in xlxs which breaks cell B16 in summary

Error - Array result was not expanded because it would overwrite data in C16

Opening the xlxs in OpenOffice just bricks the tables and uploading it back to googledocs breaks B16

[Jimbly]

You need to use it in Google Sheets (if you choose File -> Make a Copy, not File -> Download, it should keep it in Google Sheets instead of downloading); I don't think either of those formats support all of the weird Google Docs query/formula stuff it's using.

[majikthise.uk]

Ah ok kinda wanted an offline copy rather then having to use it in Google docs

[Gibe Moni Plox]

I'm looking at the spreadsheet, and it has mutiplier bonuses up to 17, but the game has x18? Am I reading this wrong or is it missing?

[majikthise.uk]

No you are right it is missing. Personally I just edited the doc to add the *18 the cost should be 1.00E+39 if I'm not mistaken

Also Jimbly I wouldn't say no to the Earth and Moon spreadsheets