Tech Levels in Excell Spreadsheet format...

[geoschmo]

quote:

---

My question is does anyone know what these cost increase multipliers are? I assume it has some link to the tech level cost option (low, med and high) that can be set in the initial game setup.

---

For a Low Tech Cost Game:
The multiplier is simply tech level. It is linear.
For Example, Ship construction
Level Cost = 10000
Level 2 cost is 10000 X 2 = 20000
Level 3 cost is 10000 X 3 = 30000
Level 4 cost is 10000 X 4 = 40000

For a Med Tech Game:
The multiplier is the result of Tech Level rasied to the power of 2 and then divided by 2.

For example, Ship Construction again
Level 2 cost is 10000 X 2(2 to the power of 2 is four divided by 2 is 2) = 20000
Level 3 cost is 10000 X 4.5(3 to the power of 2 is 9 divided by 2 is 4.5) = 45000
Level 4 cost is 10000 X 8(4 to the power of 2 is 16 divided by 2 is 8) = 80000


For a High Tech cost game the multiplier is
Tech level raised to the power of 2

Ship Construction again
Level 2 cost is 10000 X 4(2 to the power of 2 is 4) = 40000
Level 3 cost is 10000 X 9(3 to the power of 2 is 9) = 90000
Level 4 cost is 10000 X 16(4 to the power of 2 is 16) = 160000


Whitehojo, you should be able to plug those into your spreadsheet to automatically calculate the reseaerch cost for a component.

The only place the formula breaks down is calculating the level 1 cost for any tech in a medium cost game. Then you get 1 to the power of 2 divided by 2 results in .5 as a multiplier, and clearly that is incorrect. You could get around that by simply putting the level cost as the research cost for any tech level 1 component.


[This message has been edited by geoschmo (edited 17 February 2001).]

[This message has been edited by geoschmo (edited 17 February 2001).]