Hey @BarryWuzHere, wonderful spreadsheet, I use it a lot. I’m a bit confused tho (sorry if you answered it already- thread is long)- just moved onto the last Gad/Drone Missions and trying to pick the best to farm WHILE always needing recruits and not much else (as usual).
IF you’re thinking strictly recruits (according to your spreadsheet data):
26-8: 2772 WE, 6468R
25-1: 2250 WE, 2250R, and the remaining energy on 8-7: 522 WE, 1566R (3.00R/WE) = 3816R, way less than going just straight 26-8. Granted, I do understand the 522 WE on 8-7 would produce other valuable mats.
Chronically short on Fine Steel and Midnight Roots. Playing dozens of games in the “increased chance” provinces for these materials usualy gives me none of them. Even on hard for 2nd season. Growing frustrated.
More that it is nearly worthless than actually broken I suspect.
Odds of any crafting material being a 3* mat are quite low, which means that when randomness is added you get bursts of nothing and bursts of good luck quite frequently.
“Increased chances” aren’t as impressive as they sound. For normal levels, that is twice the odds … at the expense of other 3* crafting items and hard levels are triple … again at the expense of other 3* items.
Pulling examples from my farming sheet:
S1:5-8 – Baseline good farming – you can expect to spend 27WE / 9 runs there and get one of each 3* crafting item, including fine steel and midnight roots
S2:12-6H – Best midnight root farming: you can expect to spend 14.6WE / 1.33 runs to get one root … but 43.7WE / 3.97 runs for one fine steel
S2:4-3H – Best fine steel farming: you can expect to spend 14.1WE / 1.41 runs to get one steel … but 42.2WE / 4.22 runs to get one root.
And in any of those cases, you will see big variations from those average numbers if you only do that much farming. If you tabulate it over say, 500-1000WE (a week or two of farming all your spare WE), you really should see something close to those averages.
For so much effort put into a feature, worthless and broken could be the same thing. Or, this many revisions into the product it may have a percieved $ value to not fix the issue and incentivize more paying.
@Kerpen, There isn’t currently a sheet with exactly what you want, because in most circumstances, people want to farm efficiently which means getting the best farming per world energy flag.
I did have at least one person ask for that during Atlantis Rises so they could get the best loot per run so they could beat use limited loot tickets, as apparently they had an excess of WE flasks in inventory, so I made a tab with that information in one of my sheets for them. See AR Data per Run (Loot Ticket) tab of this sheet
If you want to know about a specific level outside Atlantis Rises, I recommend doing multiplication like @Gryphonknight suggested.
If there is a real reason you need the data for all levels, it is a simple calculation and I can make a sheet for that someplace.