unit stats

[JaM2013]

Can somebody explain how to modify unit stats? do I need to edit both squads.xlsx and squads.csv or just one of them? I tried to save edited xlsx as csv, but then got some strange results (unit icons got waaay too small)

[rbodleyscott]

Can somebody explain how to modify unit stats? do I need to edit both squads.xlsx and squads.csv or just one of them? I tried to save edited xlsx as csv, but then got some strange results (unit icons got waaay too small)

Squads.csv is the one actually used by the program.

Personally I edit the .xlsx because it is formatted, so easier to read, and then make a .csv version for the game.

If you mean the unit models, we had a problem with MAX that the models are made in, in that it sometimes exported the models at a different size and we were unable to figure out why. Hence, as a workaround, the squads file has a scaling factor to adjust the size of any models that don't match up with the others. This is the "UnitScaling" column in column BI.

IIRC correctly a value of 0 means don't scale, which is equivalent to a value of 1000 when compared with the non-zero values.

[JaM2013]

hmm, strange, seem like excel does something weird to the file once i save it.. i only changed armor values, but instead, units got changed into some weird stuff. legionaries with pikes, tall as 2 buildings and elephants blobbed together.. what editor is safe to use?

[rbodleyscott]

hmm, strange, seem like excel does something weird to the file once i save it.. i only changed armor values, but instead, units got changed into some weird stuff. legionaries with pikes, tall as 2 buildings and elephants blobbed together.. what editor is safe to use?

Excel

Are you sure you are saving it as a standard .CSV file? - the save as thing usually gives several .csv options.

Also, in order for your squads file to replace the vanilla file, and not try to concatenate with it, you need to put

#REPLACE

in the top left cell.

That is probably what the problem is.

[JaM2013]

is there any problem with using sorting on these files? thats the other thing i did the last time (sorted out armored units from unarmored).. but when i saved it ( edited the csv, as default) i got units with anomalies..

[rbodleyscott]

is there any problem with using sorting on these files? thats the other thing i did the last time (sorted out armored units from unarmored).. but when i saved it ( edited the csv, as default) i got units with anomalies..

I have never tried sorting them. Your experience suggests that there probably is a problem with doing so, unless you accidentally sorted only some of the columns.

[JaM2013]

Fyi - sorting the file was the culprit, without it, everything works fine. thanks.