Excel workbook for AI's

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

God I love Excel. Next, Access.

Rollo · #2 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 · #3 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 · #4 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 · #5 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.

solops · #6 September 4th, 2002, 04:23 PM

This is great! Now, all I have to do is figure out the stuff at the bottom. Is there a writeup on AI design somewhere? I have questions about what happens when "Primary" weapons tech is not available initially and what the effect of the "Secondary" weapon setting is. The same goes for other of the primary/secondary selections. And does there need to be a "special" manual adjustment to get the AI to use trait-specific techs like the Talisman or Subverter?

[ September 04, 2002, 15:24: Message edited by: solops ]

Atraikius · #7 September 4th, 2002, 04:58 PM

There are areas for both an initial and final primary and secondary weapon on the race worksheet. The inital primary weapon is researched at the top of the research file. If there is no secondary weapon researched, the ship will be designed with only the primary weapon, and a ship will be designed with CSM I's until the initial primary weapon is researched. I tried to set up the files so that any special racial tech items will be used.

The files that you will get from this aren't going to give you a challenging AI, but they give you a full set of workable AI files (that some additional variation in the anger and politics files based on your demeanor, happiness type, and Culture) to start from. Just adjust the appropriate files to improve or optimize thenm to what you are looking for.