View Single Post
  #6  
Old February 17th, 2001, 02:01 AM
geoschmo's Avatar

geoschmo geoschmo is offline
National Security Advisor
 
Join Date: Jan 2001
Location: Ohio
Posts: 8,450
Thanks: 0
Thanked 4 Times in 1 Post
geoschmo is on a distinguished road
Default Re: Tech Levels in Excell Spreadsheet format...

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).]
__________________
I used to be somebody but now I am somebody else
Who I'll be tomorrow is anybody's guess
Reply With Quote