Link to original post: https://www.reddit.com/r/factorio/comme ... alculator/
Tl;dr: This is a spreadsheet with custom calculations which tell you how much production you need to make something in a certain time. It also calculates ratios and has a few more useful functions. Now updated to
Google Sheets link (see how to make a copy below): https://docs.google.com/spreadsheets/d/ ... sp=sharing
I had been a big fan of this very clever spreadsheet for a while but it had been getting out of date. Trawling back through update logs, I have updated the changed recipes and added all the new items.
However, there are probably a few things I missed - please let me know so I can update it!
- Probably more due to the large number of new 0.15 itemsWhat the spreadsheet does
Basically, you select an item you wish to produce, specify the quantity and time needed to make them and it calculates how many items you need to craft this. It also tells you how many assemblers etc. you need to craft this many in the time specified and the total amount of ingredients at the bottom. It is very detailed and tells you the exact numbers as well as lots of other information.
Another useful function is the ratios between products and ingredients (and ingredients of them etc. ). You can also change which tier of assembler or furnace is used (which will affect time) - there is a column for time bonus which can be altered for speed modules too.
If you wish to use it with a mod, it is easy to add modded items or ingredients using the format of the vanilla ones. For example, you could enter in all the Bob's mods items and their recipes... but someone else can do that.
It can be used for many production set-ups (Maybe even a rocket a minute...) - see examples below.
How to use it
The link will take you to a Google sheets spreadsheet. In order to use it, you will need a free Google account (which you most likely already have )
1. Near the top of this page, choose File > Make a copy... to copy this spreadsheet into your own Google account. If this option is grayed out, first sign in to Google (top right).
2. You should now be able to make changes to your own copy of this Spreadsheet. Click the "Items" tab at the bottom. This is a sheet of all crafting recipes in the game. Click the "Instructions" tab to come back here.
3. In the "Items" sheet, click on an item you want to assemble, such as "Sience Pack 2". This will select it.
4. Near the top, choose the menu Factorio > Assembly for Selected Item. You will need to give the script permission to run. (Note: all it needs to do is change the content of the spreadsheet to print out the results)
5. Fill out the information such as how many you want to make in how much time. Leave it blank for the defaults.
6. This will take you to a new sheet called "Calculations" and break down all of the requirements to make that item in the given time. This will also tell you how many Machines each one will take.
Here is an example: In the spreadsheet, this is properly indented
Production required to make 3 Basic Accumulators in 1 minute
Time to make: 60 seconds
3 x Basic Accumulator (0.4 x Assembling Machine 3)
6 x Iron Plate (0.18 x Electric Furnace)
6 x Iron Ore (0.18 x Electric Mining Drill)
15 x Battery (1 x Chemical plant)
15 x Iron Plate (0.44 x Electric Furnace)
15 x Iron Ore (0.44 x Electric Mining Drill)
15 x Copper Plate (0.44 x Electric Furnace)
15 x Copper Ore (0.44 x Electric Mining Drill)
30 x Sulfuric Acid (0.08 x Chemical plant)
6 x Iron Plate (0.18 x Electric Furnace)
6 x Iron Ore (0.18 x Electric Mining Drill)
30 x Sulfur (0.2 x Chemical plant)
45 x Water (0.01 x Offshore Pump)
45 x Petroleum Gas (0.68 x Advanced Oil processing)
40.91 x Water (0.01 x Offshore Pump)
81.82 x Crude Oil (1.36 x Pumpjack 1.0/s)
60 x Water (0.01 x Offshore Pump)
Total:
3 x Basic Accumulator (0.4 x Assembling Machine 3)
27 x Iron Plate (0.79 x Electric Furnace)
27 x Iron Ore (0.79 x Electric Mining Drill)
15 x Battery (1 x Chemical plant)
15 x Copper Plate (0.44 x Electric Furnace)
15 x Copper Ore (0.44 x Electric Mining Drill)
30 x Sulfuric Acid (0.08 x Chemical plant)
30 x Sulfur (0.2 x Chemical plant)
145.91 x Water (0.02 x Offshore Pump)
45 x Petroleum Gas (0.68 x Advanced Oil processing)
81.82 x Crude Oil (1.36 x Pumpjack 1.0/s)
