Excel workbook for AI's

Atraikius · #1 June 19th, 2002, 09:11 PM

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

geoschmo · #2 June 19th, 2002, 09:26 PM

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

PDF · #3 June 19th, 2002, 09:53 PM

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

Atraikius · #4 June 21st, 2002, 01:06 AM

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.

PDF · #5 June 21st, 2002, 04:17 PM

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 ?

Atrocities · #6 June 21st, 2002, 11:17 PM

God I love Excel. Next, Access.

Rollo · #7 June 21st, 2002, 11:32 PM

This looks really good Atraikius. Great job

.

You are not trying to make us AI modders obsolete, do you?

Rollo

Atraikius · #8 June 25th, 2002, 01:05 AM

Rollo - No, just making it easier for the people who aren't as obsessed about it as us to keep thier AI's up to date

Atrocities - Access would have been so much easier, but thought more people would have excel available to them.

PDF - What specifically do you want to add? if it is just an additional tech or tech levels that provide facilities that would get built by the Construct Facilities file because of thier abilities, you only have to insert the tech into the Research file somewhere. If you are adding new weapons, there is some more work in adding the weapons to the list of weapons and adding them to several formulas. If you are adding racial abilities it is a real headache.

BrotherAlpha · #9 September 1st, 2002, 11:55 PM

This is great help, but I'm making a mod that does have new cultures, happiness types, racial abilities, ect. Is there a program out there that looks at the mod files? I really need help automating the AI creation process.

Atraikius · #10 September 3rd, 2002, 12:49 PM

If you are familiar with excel, most of the information is in the AQ through BZ columns on the first sheet, with aditional information in Concatenate formulas in the other sheets. Just modify the different areas to include your changes.