Spreadsheet to calculate power requirements of a production unit.

Calculate optimal ratios for feeding recipes, search through the research-tree, specialized tools to view game-information.
Post Reply
Trebor
Filter Inserter
Filter Inserter
Posts: 288
Joined: Sun Apr 30, 2017 1:39 pm
Contact:

Spreadsheet to calculate power requirements of a production unit.

Post by Trebor »

Here is a Numbers (Mac) spreadsheet to calculate the power requirements of a production unit. It determines how many solar panels, steam engines or steam turbines are required. It does not give any information about nuclear reactors because they do not generate or use electricity. For solar panels it gives you how many you need if running just during daylight or how many are needed to charge accumulators to run at night and the number of accumulators needed at night. It takes into consideration modules and beacons.

This was developed for determining power requirements for a single production unit, because of that there is a limit on the complexity that it can handle, mostly because of modules. An example of what it can handle is a row of electric furnaces where the middle furnaces have x beacons covering them and the ends have y beacons. Or if your green circuit unit uses different modules in the wire assemblers then the assemblers for the actual circuit board. It can handle two different configurations of anything that has modules. However adding additional configurations should not prove difficult.

However if you don't use modules or if you always use the same two configurations for everything, then you can plug in the counts for all entities and it should tell you the power requirements for your whole factory.

Here is a made up example for a row of 6 beaconed miners with more beacons on the ends (5 beacons on each side with 2 more on each end [total 14]). What is not shown in the screen shot but is in the calculation are the 14 beacons.
Screen Shot 2018-11-29 at 8.06.19 PM.png
Screen Shot 2018-11-29 at 8.06.19 PM.png (823.61 KiB) Viewed 2773 times

There is also a bonus tab to calculate some minor train depo information.

Note the forum forced me to add .txt to the file name. Do not open it as a text file, it is a Numbers spreadsheet.
Attachments
Factorio Power&Deoo.numbers.txt
(717.7 KiB) Downloaded 164 times

Trebor
Filter Inserter
Filter Inserter
Posts: 288
Joined: Sun Apr 30, 2017 1:39 pm
Contact:

Re: Spreadsheet to calculate power requirements of a production unit.

Post by Trebor »

Updated to include pollution.
Attachments
Factorio Power&Deop.numbers.txt
(729.02 KiB) Downloaded 144 times

Trebor
Filter Inserter
Filter Inserter
Posts: 288
Joined: Sun Apr 30, 2017 1:39 pm
Contact:

Re: Spreadsheet to calculate power requirements of a production unit.

Post by Trebor »

Updated to match wiki (17.30).

(Remember to remove .txt)
Attachments
Factorio Power&Depo.numbers.txt
(720.63 KiB) Downloaded 138 times

Post Reply

Return to “Cheatsheets / Calculators / Viewers”