I think you'd be surprised by how long I followed the exact same strategy, 'ahhh, that'll do'. I had pieces of the right calculation on paper but it wasn't until the big SPM factory that I finally fully nailed this down. The spreadsheet kinda forced me into a corner where I needed to figure it out or the SPM wasn't going to work. I should have made the spreadsheet a long time ago, it's going to be really useful going forward, at least for me and you anyway.
Several thousand hours into factorio, have to say I love both your play style and your presentation! It was the sexy blocks video that caught me, just in time to influence how I'm about to scale out of my space exploration starter base. You deserve more views, keep on doing what you seem to love!
kudos on the hard work. I usually use kirkmcdonald's calculator. In-game you can use factory planner. Your spreadsheet works fine but doesn't factor in if I have speed modules or current productivity level. Still neat. Thumbs up!
I don't really use modules or beacons so the spreadsheet is perfect for me!! Besides, the idea of including them in the spreadsheet scares the bejesus out of me, every process, every assembly machine would need to be detailed somewhere in there. It's possible but a heck of a lot of work
@@theotherbigfoot It's simple: for p productivity 3 modules, divide the required number of materials by 1 + 0.1*p. For most assemblers, this means multiplying by 5/7. For chemical plants, it means multiplying by 10/13. See? Nice and simple p̵̲̃r̷̨̈i̸͉̓m̷͉̒ē̵̱ ratios. 🙃 As someone who also likes trying to do things with perfect ratios, _abandon all hope ye who enter._ Things just get even more complicated when beacons get involved, or specific recipes that don't accept productivity modules. That said, the difference that it makes is pretty crazy to the point that it almost justifies the resulting error in the ratios involved.
Be still my data nerd heart. So, to make sure I understood in the example of 465 SPM the sheet is saying I need to generate 565.17 green chips PER SECOND? If that's correct, I gotta go work on my 5 SPM factory.
This sure beats my usual style of "just keep building refineries until other stuff stops running out"
I think you'd be surprised by how long I followed the exact same strategy, 'ahhh, that'll do'. I had pieces of the right calculation on paper but it wasn't until the big SPM factory that I finally fully nailed this down. The spreadsheet kinda forced me into a corner where I needed to figure it out or the SPM wasn't going to work. I should have made the spreadsheet a long time ago, it's going to be really useful going forward, at least for me and you anyway.
@@theotherbigfoot you are a legend, ive really been avoiding figuring it out by calculation these past years, but ill give it a go
Several thousand hours into factorio, have to say I love both your play style and your presentation!
It was the sexy blocks video that caught me, just in time to influence how I'm about to scale out of my space exploration starter base. You deserve more views, keep on doing what you seem to love!
Cheers dude, I'm nowhere near done yet
kudos on the hard work. I usually use kirkmcdonald's calculator. In-game you can use factory planner. Your spreadsheet works fine but doesn't factor in if I have speed modules or current productivity level. Still neat. Thumbs up!
I don't really use modules or beacons so the spreadsheet is perfect for me!! Besides, the idea of including them in the spreadsheet scares the bejesus out of me, every process, every assembly machine would need to be detailed somewhere in there. It's possible but a heck of a lot of work
@@theotherbigfoot It's simple: for p productivity 3 modules, divide the required number of materials by 1 + 0.1*p. For most assemblers, this means multiplying by 5/7. For chemical plants, it means multiplying by 10/13. See? Nice and simple p̵̲̃r̷̨̈i̸͉̓m̷͉̒ē̵̱ ratios. 🙃
As someone who also likes trying to do things with perfect ratios, _abandon all hope ye who enter._ Things just get even more complicated when beacons get involved, or specific recipes that don't accept productivity modules. That said, the difference that it makes is pretty crazy to the point that it almost justifies the resulting error in the ratios involved.
Be still my data nerd heart. So, to make sure I understood in the example of 465 SPM the sheet is saying I need to generate 565.17 green chips PER SECOND? If that's correct, I gotta go work on my 5 SPM factory.
You got it.
Assuming no modules or beacons.