Tech Levels in Excell Spreadsheet format...

[SunDevil]

I do.

I figured this out back in the day.

I have it written down, I'll post it on Tuesday.

They way I figured it out was this:

Start a game by yourself, and just go through the research tree.

With each level, it's a modified increase. A modified increase is straight increase X a percent. As you rise in the levels of a research topic, that percent is less and less.

Example:

Ship Construction level 1 := 10,000
Ship Construction level 2 := 20,000
Ship Construction level 3 := 45,000
Ship Construction level 4 := 80,000

So the third level is 20,000 X 2.25%
The fourth level is 45,000 X 1.7777%

Formula Current Project total/Previous Total

80,000/45,000 := 1.777777%

This is the pattern, so if you want you could just go through the research tree and figure out the percent each level increase.
Hope this helps.


Hope this helps.

[raynor]

As a followup to SunDevil's post, it is extremely easy to change the output of a Research Lab I up to around a million or so. Last night, I researched all the standard techs plus Organic, Temporal and Religous. Tonite, I'll put them in an Excel spreadsheet, double check them and post them if anyone else is interested in helping calculate the multipliers?

[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).]

[raynor]

Wow! Very impressive.

Great job!

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

[geoschmo]

ACK! You are correct Raynor. I will fix that now.

[raynor]

I wrote a quick program to read in the techarea.txt file and generate a new file with all the tech levels and their cost using the formula Geoschmo provided. I attached the text file in case anyone is interested.

Edit->The file is just med tech cost.

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

[raynor]

quote:

---

Originally posted by WhiteHojo:
ps - Taterbill - nice work... one question I have is how do I link other columns to each row when using the your sort buttons? I added some info to column D but when the sort buttons are used, the new Column D info did not stay adjacent to its correct unit description.

---

I hope Taterbill won't mind if I go ahead and answer this question. Thanks to both WhiteHojo and Taterbill for this excellent job.

1. On the View Menu, go down to ToolBars and put a check next to the Visual Basic toolbar.

2. On the Visual Basic Toolbar, you should see three icons in the middle. The third from the left says 'Design Mode'. Click on this one. Excel should display a small window with an identical icon in the middle of your spreadsheet.

3. Right click on one of the three sort buttons and select 'View Code' from the menu.

You should see the code for the three buttons. Look for lines that look like this in all three of them:

Range("A2:C771").Select

4. Change the C to a D so that it applies the Select operation to columns A through D instead of just A through C.

5. (Close the Visual Basic Window and click the Design Mode icon in the middle of your screen to go back to normal view)