Tech Levels in Excell Spreadsheet format...

raynor · #1 February 17th, 2001, 02:22 AM

Wow! Very impressive.

Great job!

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

geoschmo · #2 February 17th, 2001, 02:36 AM

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

raynor · #3 February 17th, 2001, 05:48 AM

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 · #4 February 17th, 2001, 06:18 AM

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)

Nethog · #5 February 27th, 2001, 07:15 PM

I was wondering if anyone in this thread has updated the spreadsheet with the 1.27b data files as well as research point cost? If so could you please repost it here?

Thanks!

WhiteHojo · #6 February 27th, 2001, 07:23 PM

I haven't done any updating since the 1.27 patch - dang work is gettin in the way - but if someone else wants to use my original file feel free to update it.

------------------
Character is best defined as that which you do when you believe nobody is watching.

Spyder · #7 February 27th, 2001, 07:29 PM

quote:
Originally posted by geoschmo:
For a Low Tech Cost Game:
The multiplier is simply tech level.....

Geo...in my travels while trying to graphically map out the tech tree, I noticed a WHOLE LOT of 666,666 and 333,333 numbers...this tells me that there is a '3' in the formula somewhere. Now, I did all my research at the medium cost level....

Spyder, Chairman of the Arachnid Consortium