Hi, wanted to give this a try with mods. What version of lua are you using exactly nowadays? /.../ It uses Lua 5.3, just like the game itself I believe. Hope it works out with your mods! Note that the sheet is dimensioned to 250 items or recipes atm. Enlarging that might be a bit of trial and error...

Thank you zeebo404, it's fixed now.

Put out a first version of the sheets for 0.17 - links in the original post. The main calculations with recipes etc should all be fine, but I haven't gone through all the details yet. For instance, I'm not at all sure the throughput values for inserters still are accurate, and the belt throughputs p...

Interesting optimisations, but when reading FFFs like this I can't help but think "why don't they ever release 1.0 and start working on an expansion?" Your Steam EA has been extremely successful, but the backside of that is that you probably shouldn't expect the majority of sales of this g...

Small update: I fixed the rocket silo calculation to take the fixed 42 second launch time into account. For completeness, I should also mention that I updated the facility combo costs which were a bit too high for some items since some rebalancing change in early 0.16. This only affected the relativ...

Nomadic Steppe wrote:I'm bored of fighting and I will stop improving my base.

Use artillery? Once you have overlapping artillery ranges along the perimeter you'll hardly see a biter again. Just plomp them out, ensure they're defended and supplied with shells, and just sit back until the area is clean. Rinse and repeat.

Sactorio: Thanks, it's a detail but you have a point. Changed.

/.../ but the resource needed remains constant while the time needed *decreases* when adding prod mods. That seems backwards somehow... Agreed, that's confusing. I've fixed the "Resources needed" column to take prod modules into account, just like "Items to manufacture". (Howeve...

First - amazing sheet work, ignatio! Cool, I'm glad you find it useful! Is there a way to put productivity modules in the mining drills? I had overlooked that mining drills (and pumpjacks) can take productivity modules. Fixed now - please give it a go and check that it gives the results you expect....

Is there a way to put productivity modules into rocket launch calculations? /.../ The PMs should go into the "Rocket part" production goal - it's what most closely corresponds to the rocket silo facility. "Satellite launch" is a combo goal to easily select 1 satellite and 100 ro...

EDIT New copy of calculator. Want - 40 - Advanced circuits. Items to manufacture - 400 - Copper cable :?: Correct items to manufacture 160 copper cable. I take it that's without any productivity modules anywhere. The reason for the 400 is that it includes both direct and indirect requirements: You ...

I disagree I think the belt-compression was an intuitive problem. You could watch how the things on the belts and the inserters move, and figure out that the belt couldn't compress due to caps that is to small for one item to fit. The solution with undergrounds didn't on the other side feel intuiti...

Fixed a bug when using "Optimise for max count" with pumpjacks - it didn't take the yield into account so calculated too high counts. The values given in the pumpjack columns were correct though.

The thing that makes bots unbalanced is that they scale indefinitely for getting things in and out of chests. Inserters have a limited throughput, and one can only place so many of them around a chest or machine. Why doesn't bots have a similar limitation? It seems reasonable that only one or a few ...

Is there some easy way to use filter to reduce the amount of rows shown in the main view? It doesn't like merge cells so when I try to use it I end up getting the filter on the "accumulator" row, The "Active items" filter does that (Data -> Filter views... -> Active items), exce...

This is an awesome sheet. Thanks! :) For crafting 100 accumulators it recommends 100/3 assembly 1 machines. If my calculations are correct it should take 2000 machines which is more than the 33 recommended. An older version that I have been using recommends using 2000 as well so you probably have a...

In the attached savegame, remove the small electric pole at the player. Crashes consistently.

In 0.16.x, I every so often get stuck items. E.g. in the picture below, the underground entrance under the player is intended to let through the electronic circuits coming out on the right belt lane from the blue splitter. Here you can see it doesn't, and the belt going left is empty. Removing the u...

how about, if there's at least "half" of the size needed for inserted to drop the item - it drops the item on the belt and anything that was there on the other half of the belt (or less) gets to hold up for split of a second That would make almost all compression problems go away. I think...

Yes, I think the "each" (yellow star) option is fairly obvious for the interface. As I touched on in the OP, I have been able to work around the problem using the "reverse pick" trick: If I want, let's say, 50 splitters in the train and it currently has 46, then I have one insert...