unit stats

Post Reply
JaM2013
Master Sergeant - U-boat
Master Sergeant - U-boat
Posts: 539
Joined: Fri Mar 29, 2013 1:02 pm

unit stats

Post by JaM2013 » Fri Oct 13, 2017 6:57 pm

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)
Image

rbodleyscott
Field of Glory 2
Field of Glory 2
Posts: 21959
Joined: Sun Dec 04, 2005 6:25 pm

Re: unit stats

Post by rbodleyscott » Fri Oct 13, 2017 7:35 pm

JaM2013 wrote: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.
Richard Bodley Scott

Image

JaM2013
Master Sergeant - U-boat
Master Sergeant - U-boat
Posts: 539
Joined: Fri Mar 29, 2013 1:02 pm

Re: unit stats

Post by JaM2013 » Fri Oct 13, 2017 8:47 pm

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?
Image

rbodleyscott
Field of Glory 2
Field of Glory 2
Posts: 21959
Joined: Sun Dec 04, 2005 6:25 pm

Re: unit stats

Post by rbodleyscott » Fri Oct 13, 2017 9:59 pm

JaM2013 wrote: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.
Richard Bodley Scott

Image

JaM2013
Master Sergeant - U-boat
Master Sergeant - U-boat
Posts: 539
Joined: Fri Mar 29, 2013 1:02 pm

Re: unit stats

Post by JaM2013 » Mon Oct 16, 2017 5:31 pm

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..
Image

rbodleyscott
Field of Glory 2
Field of Glory 2
Posts: 21959
Joined: Sun Dec 04, 2005 6:25 pm

Re: unit stats

Post by rbodleyscott » Mon Oct 16, 2017 5:44 pm

JaM2013 wrote: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.
Richard Bodley Scott

Image

JaM2013
Master Sergeant - U-boat
Master Sergeant - U-boat
Posts: 539
Joined: Fri Mar 29, 2013 1:02 pm

Re: unit stats

Post by JaM2013 » Mon Oct 16, 2017 10:59 pm

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

Post Reply

Return to “Field of Glory II: Modding”