Page 1 of 1

Technology Spreadsheet

Posted: Tue Feb 18, 2014 10:38 pm
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.

Re: Technology Spreadsheet

Posted: Tue Feb 18, 2014 11:06 pm
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)

Re: Technology Spreadsheet

Posted: Wed Feb 19, 2014 1:38 pm
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.

Re: Technology Spreadsheet

Posted: Wed Feb 19, 2014 2:33 pm
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

Re: Technology Spreadsheet

Posted: Wed Feb 19, 2014 3:23 pm
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)

Re: Technology Spreadsheet

Posted: Wed Feb 19, 2014 4:54 pm
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.

Re: Technology Spreadsheet

Posted: Wed Feb 19, 2014 7:16 pm
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 ;)