Technology Spreadsheet

Post all other topics which do not belong to any other category.
Post Reply
User avatar
metzyn
Long Handed Inserter
Long Handed Inserter
Posts: 96
Joined: Tue Mar 19, 2013 10:49 pm
Contact:

Technology Spreadsheet

Post by metzyn »

In the case anyone is interested, I compiled all of the technologies from the JSON files into a single spreadsheet.

https://docs.google.com/spreadsheet/ccc ... sp=sharing

Total required science packs:

Pack 1 (Red): 42,195
Pack 2 (Green): 41,325
Pack 3 (Blue): 33,775
Alien (Purple): 30,100

If using only 1 lab without upgrades or modules it would take nearly 18 days to research every technology.
Factorio Modder
Solar Expansion

drs9999
Filter Inserter
Filter Inserter
Posts: 831
Joined: Wed Mar 06, 2013 11:16 pm
Contact:

Re: Technology Spreadsheet

Post by drs9999 »

Oh thats a lot :D

I just started to create a similar post, but here might be a better place for it.
I made the Techtree, it is attached as pdf ( I made it with open office and I am not sure why but if I try to export it as jpeg it would be >300Mb, so pdf with 70kb was "a bit" more efficient)
Attachments
techTree_V0_9_1.zip
(66.55 KiB) Downloaded 1938 times

slpwnd
Factorio Staff
Factorio Staff
Posts: 1835
Joined: Sun Feb 03, 2013 2:51 pm
Contact:

Re: Technology Spreadsheet

Post by slpwnd »

@metzyn Nice overview. I never realized it is that much :) I think the Follower Robot Count kind of screws the statistics because it is not so much needed and it is very expensive.

Gammro
Filter Inserter
Filter Inserter
Posts: 360
Joined: Wed Oct 09, 2013 1:45 pm
Contact:

Re: Technology Spreadsheet

Post by Gammro »

That are a lot of packs :P

But I agree with slpwnd, the robot follower count research increases it a lot. If you only go as far as level 5 of that tech, you only need:
Red: 23 195
Green: 22 325
Blue: 14 775
Alien: 11 100


And the needed time goes from 1,5 million seconds to 1 million seconds, which is 11 days and 19 hours. So it will save you 1/3rd of your time not going that route :P
Ignore this

User avatar
Zourin
Fast Inserter
Fast Inserter
Posts: 246
Joined: Tue Feb 11, 2014 2:15 am
Contact:

Re: Technology Spreadsheet

Post by Zourin »

That's still quite a bit.

What if you omit any of the damage/weapon upgrades requiring alien artifacts (Reserving artifacts for missile defense req techs and Mk 2 armor and equipment)

User avatar
ssilk
Global Moderator
Global Moderator
Posts: 12888
Joined: Tue Apr 16, 2013 10:35 pm
Contact:

Re: Technology Spreadsheet

Post by ssilk »

slpwnd wrote:@metzyn Nice overview. I never realized it is that much :) I think the Follower Robot Count kind of screws the statistics because it is not so much needed and it is very expensive.
Recommendation: Shrinking the upgrade-stuff to one box "[1-X]". In a normal game it would also be made like so.
Cool suggestion: Eatable MOUSE-pointers.
Have you used the Advanced Search today?
Need help, question? FAQ - Wiki - Forum help
I still like small signatures...

Lee_newsum
Filter Inserter
Filter Inserter
Posts: 436
Joined: Wed Jan 15, 2014 9:41 am
Contact:

Re: Technology Spreadsheet

Post by Lee_newsum »

you did not add in Lab efficiency 1-4

Level, Lab speed Bonus, Cumulative
1 20% 20%
2 30% 50%
3 40% 90%
4 50% 140%
from wiki ;)

Post Reply

Return to “General discussion”