Factorio Assembly Calculator

Calculate optimal ratios for feeding recipes, search through the research-tree, specialized tools to view game-information.
Post Reply
Jonathan88
Fast Inserter
Fast Inserter
Posts: 179
Joined: Tue Jan 20, 2015 7:49 pm
Contact:

Factorio Assembly Calculator

Post by Jonathan88 »

This spreadsheet was not made by me - I have updated a version that was over a year old.
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 0.13 0.15 - That took a while! Thanks devs for adding so much new content!

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! :D - Probably more due to the large number of new 0.15 items


What 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. :lol:

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)
Last edited by Jonathan88 on Tue Apr 25, 2017 9:43 pm, edited 3 times in total.
FactoriOh No: when it's accidentally 2am, again

Koub
Global Moderator
Global Moderator
Posts: 7175
Joined: Fri May 30, 2014 8:54 am
Contact:

Re: Factorio Assembly Calculator

Post by Koub »

I can confirm
Koub - Please consider English is not my native language.

Jonathan88
Fast Inserter
Fast Inserter
Posts: 179
Joined: Tue Jan 20, 2015 7:49 pm
Contact:

Re: Factorio Assembly Calculator

Post by Jonathan88 »

Koub wrote:
I can confirm
That works too I guess... :D
What is it from? It looks good but not quite as much detailed information
FactoriOh No: when it's accidentally 2am, again

Koub
Global Moderator
Global Moderator
Posts: 7175
Joined: Fri May 30, 2014 8:54 am
Contact:

Re: Factorio Assembly Calculator

Post by Koub »

Koub - Please consider English is not my native language.

Jonathan88
Fast Inserter
Fast Inserter
Posts: 179
Joined: Tue Jan 20, 2015 7:49 pm
Contact:

Re: Factorio Assembly Calculator

Post by Jonathan88 »

Ah yes but my one works on Linux ;)
It would be great if Foreman did as well...
FactoriOh No: when it's accidentally 2am, again

nonstickfrypan
Long Handed Inserter
Long Handed Inserter
Posts: 53
Joined: Fri Apr 15, 2016 9:02 am
Contact:

Re: Factorio Assembly Calculator

Post by nonstickfrypan »

I prefer this one (for Linux support) as well :)

I guess I could write a Foreman like thing using C++, Qt and graphiz but *shrug*

Jonathan88
Fast Inserter
Fast Inserter
Posts: 179
Joined: Tue Jan 20, 2015 7:49 pm
Contact:

Re: Factorio Assembly Calculator

Post by Jonathan88 »

THIS HAS NOW BEEN UPDATED TO 0.13!!! :D :D :D
FactoriOh No: when it's accidentally 2am, again

Jonathan88
Fast Inserter
Fast Inserter
Posts: 179
Joined: Tue Jan 20, 2015 7:49 pm
Contact:

Re: Factorio Assembly Calculator

Post by Jonathan88 »

ALSO UPDATED TO 0.15 TOO :D
FactoriOh No: when it's accidentally 2am, again

Jonathan88
Fast Inserter
Fast Inserter
Posts: 179
Joined: Tue Jan 20, 2015 7:49 pm
Contact:

Re: Factorio Assembly Calculator

Post by Jonathan88 »

Changes for 0.15.7
FactoriOh No: when it's accidentally 2am, again

Aervanath
Inserter
Inserter
Posts: 25
Joined: Mon Jun 27, 2016 3:32 pm
Contact:

Re: Factorio Assembly Calculator

Post by Aervanath »

Uranium-238 should be .993 for 10 uranium ore, not .997 for 11.
Very useful spreadsheet!

Jonathan88
Fast Inserter
Fast Inserter
Posts: 179
Joined: Tue Jan 20, 2015 7:49 pm
Contact:

Re: Factorio Assembly Calculator

Post by Jonathan88 »

Thanks! Now I looked at it, the maths didn't quite add up ;)

Not many people use it, but it's quite handy nonetheless.
FactoriOh No: when it's accidentally 2am, again

Mister_Dawg
Manual Inserter
Manual Inserter
Posts: 4
Joined: Fri Apr 21, 2017 1:54 pm
Contact:

Re: Factorio Assembly Calculator

Post by Mister_Dawg »

Anxiously awaiting a .16 update :D

DaHai
Manual Inserter
Manual Inserter
Posts: 1
Joined: Mon Oct 29, 2018 7:40 am
Contact:

Re: Factorio Assembly Calculator

Post by DaHai »

Hey Guys
I need help please. Maybe i am to stupid but i can not find the menu for Factorio > Assembly for Selected Item. Can you please show me where i can find it?
Thanks

Post Reply

Return to “Cheatsheets / Calculators / Viewers”