Tech Levels in Excell Spreadsheet format...

Spyder · #1 February 15th, 2001, 02:57 AM

Yes, it is very helpful. I am greating a graphical depiction of the research tree in PowerPoint and will publish it when done. I also am creating some tabular information for each of the Facilities, Modules, Weapons, etc, in Excel which I will publish at the same time.

Paul E. Mason
Senior VMS Systems Administrator

WhiteHojo · #2 February 14th, 2001, 07:42 PM

I've finally been published. What the hell do those law review editors know anyway? (will only make sense to anyone who has toiled thru 3 years of law school - yuck)

Atrocities, went to your site and I must say, I'm blushing.

Nice site by the way. Very up-to-date and informative.

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

Tampa_Gamer · #3 February 16th, 2001, 02:12 AM

WhiteHojo - as someone who's maquiladora article got trashed after 200+ hours of working on it (b/c the Mexican Congress modified it in a late session) I understand!!

WhiteHojo · #4 February 15th, 2001, 08:59 PM

Tampa - I feel your pain - 200+ hours? WOW

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

raynor · #5 February 15th, 2001, 11:27 PM

Wow! I was definitely not expecting hyperlinks in Excel. Great job!

Now... since it's in Excel already, I wonder if someone could make it do the math to calculate how many research points each tech field costs?

Maybe one of our resident mathematicians such as DirectorTsaarx or Zantris?

taterbill · #6 February 16th, 2001, 07:58 AM

I have updated WhiteHojo's most excellent spreadsheet, changing the worksheet name and all related hyperlinks as he suggested. I also added three buttons to sort the techs by various criteria.

Security Notice: The sort buttons make use of Excel macros. If you are wary of macros in downloaded files (you probably should be), you can disable macros when loading this file and everything will still work except for the sort buttons. The downloaded Zip file should be exactly 230,801 bytes. The enclosed .XLS file should be exactly 1,159,168 bytes. If either of these have changed, I can no longer vouch for the contents.

Paranoia aside, Happy SE4ing!

WhiteHojo · #7 February 16th, 2001, 11:22 PM

Someone below mentioned they would like to see the research cost of each tech added to the spreadsheet. This got me to snoopin and I found that, with my present information or lack thereof, I am not able to figure the research cost of any tech above it's initial level 1 cost.

In the TechArea data file, it lists all the techs, the max # of levels and the initial cost of a level. Under the definition of Levle cost the file lists the following: Level Cost:
The cost to increase one level in this tech area. The cost increases by the game setup factor as the levels get higher.

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. But w/o knowing the formula that the game uses to increase the cost of each successive level of tech, it will be impossible to compute the research cost for each level of tech in the game.

any help would be appreciated.

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.

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