|
|
|
|
 |
June 19th, 2002, 09:11 PM
|
|
Second Lieutenant
|
|
Join Date: Mar 2001
Location: Elk River, MN, USA
Posts: 472
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Excel workbook for AI\'s
I uploaded an excel workbook to put together simple AI's. Just fill in the first worksheet, and the information is used to fill out the AI files. Once done with the worksheet, just copy the 'A' column and past into wordpad or notepad.
1024513290.zip |
June 19th, 2002, 09:26 PM
|
 |
National Security Advisor
|
|
Join Date: Jan 2001
Location: Ohio
Posts: 8,450
Thanks: 0
Thanked 4 Times in 1 Post
|
|
Re: Excel workbook for AI\'s
Interesting.
What effect does changing the fields at the bottom of the worksheet have. Is that where you get the entires for the design creation sheet?
Geoschmo
__________________
I used to be somebody but now I am somebody else
Who I'll be tomorrow is anybody's guess
|
June 19th, 2002, 09:53 PM
|
|
Colonel
|
|
Join Date: Apr 2002
Location: Near Paris, France
Posts: 1,566
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Re: Excel workbook for AI\'s
It doesn't work with my French Excel Version  , cause of some unexported encryption schemes... Can you post a non-protected (remove password...) Version for us ?
Thx  |
June 21st, 2002, 01:06 AM
|
|
Second Lieutenant
|
|
Join Date: Mar 2001
Location: Elk River, MN, USA
Posts: 472
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Re: Excel workbook for AI\'s
I reposted the file without passwording, but left the sheet protection on to prevent inadvertently changing formulas. Hope it solves your problem.
Geoschmo - The fields at the bottom are used in multiple places. For which techs to research, DesignCreation, if PPB's are used as primary weapon some additional radioactives extraction is constructed, to some extent the weapons will effect the movement strategies in the strategies file.
If you want to make changes in something (or see how it works), most of the working information is in the 'BA' through 'CA' columns of the first worksheet, and the actual lines in the data files are Concatenate formulas with 'if' or 'choose' formulas inside. Working on one for the AI speech file (think of those old Mad Libs from the 80's), but that one is a lot more work to finish.
|
June 21st, 2002, 04:17 PM
|
|
Colonel
|
|
Join Date: Apr 2002
Location: Near Paris, France
Posts: 1,566
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Re: Excel workbook for AI\'s
Fine, that's just what I needed to script AIs ! 
However I don't understand yet how I can make it work for mods that have different techs/facilities...
I've seen where the base data are, but everything being in the same sheet it's a hassle to modify, with base data in different sheets (one for techs, one for facilities, etc...) it would be quite easier ! 
However if I try anything I just ruin all, can you help ? |
June 21st, 2002, 11:17 PM
|
 |
Shrapnel Fanatic
|
|
Join Date: Dec 2000
Location: USA
Posts: 15,630
Thanks: 0
Thanked 30 Times in 18 Posts
|
|
Re: Excel workbook for AI\'s
God I love Excel. Next, Access.
__________________
Creator of the Star Trek Mod - AST Mod - 78 Ship Sets - Conquest Mod - Atrocities Star Wars Mod - Galaxy Reborn Mod - and Subterfuge Mod.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is On
|
|
|
|
|
Hybrid Mode