Tech Levels in Excell Spreadsheet format... - Page 3

raynor · #21 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 · #22 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 · #23 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 · #24 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

Atrocities · #25 August 15th, 2001, 10:36 AM

Captin · #26 September 14th, 2001, 05:20 PM

taterbill · #27 November 22nd, 2001, 10:02 AM

Bump, since there's been mention of it in the beg. guide thread.

tesco samoa · #28 November 22nd, 2001, 04:23 PM

I will put a chart and attach a database with the numbers and formulas etc... in the beginners guide. I will post the chart and database here for verification purposes.

Once it is approved then I will use it in the manual.

p.s. This post will occur during the week of Dec. 3rd.

Any preference for the database.

------------------
Utinam logica falsa tuam philosophiam totam suffodiant!