Saved game .gam

Norm Koger's The Operational Art of War III is the next game in the award-winning Operational Art of War game series. TOAW3 is updated and enhanced version of the TOAW: Century of Warfare game series. TOAW3 is a turn based game covering operational warfare from 1850-2015. Game scale is from 2.5km to 50km and half day to full week turns. TOAW3 scenarios have been designed by over 70 designers and included over 130 scenarios. TOAW3 comes complete with a full game editor.

Moderators: JAMiAM, ralphtricky

Post Reply
figabo
Posts: 58
Joined: Tue Nov 02, 2004 10:42 am

Saved game .gam

Post by figabo »

I saw that in .gam files I make with a saved game, there is no information concerning the losses of units you had during a game (seems the information disappeared in the .gam file)
 
So when I make some modifications in my .gam file, and I convert it into a scenario file, all the loss are put to zero. Someone knows if there is a way to
keep the losses information you have during a game in a .gam (or another way to do it if I can edit the informations before creating again a scen file…)
 
Thanks !
 
User avatar
Telumar
Posts: 2196
Joined: Tue Jan 03, 2006 12:43 am
Location: niflheim

RE: Saved game .gam

Post by Telumar »

A late answer is better than none.

How do you make a .gam file out of a saved game? IIRC you can only export a scenario file as a .gam (xml) file. Do you rename the save game from .sal to .sce and load it into the editor to export it then as a .gam file?

Apart from that, a scenario always starts with no losses, so i would think there is no way to conserve losses data no matter how you come to your .sce file.
figabo
Posts: 58
Joined: Tue Nov 02, 2004 10:42 am

RE: Saved game .gam

Post by figabo »

Hello

yes i rename from .sal to .sce.

you are right, seems there is no way to keep losses (as current day of the scenario as
when you load again the saved game, it take the first day of the scenario).

The only way i found (but not verify completely if all is right or not), is to
count each time in the log file in saved game directory, the lost for each fight for each unit type.
User avatar
Telumar
Posts: 2196
Joined: Tue Jan 03, 2006 12:43 am
Location: niflheim

RE: Saved game .gam

Post by Telumar »

The game produces a csv file for each turn. You can load this into excel and sort the data.

EDIT: Column F are losses. You have to mark columns B to F, then sort, to keep the data linked.

Image
Attachments
csvsort.jpg
csvsort.jpg (192.21 KiB) Viewed 88 times
User avatar
Telumar
Posts: 2196
Joined: Tue Jan 03, 2006 12:43 am
Location: niflheim

RE: Saved game .gam

Post by Telumar »

Or look here: fb.asp?m=2484483

a Java application that reads the sitreplog.csv files and produces a loss charter per turn in html format.
figabo
Posts: 58
Joined: Tue Nov 02, 2004 10:42 am

RE: Saved game .gam

Post by figabo »

Hello Telumar

Thanks a lot, i have downloaded the tool. Really interresting. I think i will go with this.

John T_MatrixForum
Posts: 83
Joined: Mon Aug 07, 2000 8:00 am
Location: Stockholm Sweden

Load files

Post by John T_MatrixForum »

You can load all the logfiles into Excel and do pivotal table and graphs on it too.
So losses Per gameturn (alas US dateformat doesn't sort OK, yet)

Image
Attachments
LossesPerTurn.jpg
LossesPerTurn.jpg (52.54 KiB) Viewed 87 times
/John T
John T_MatrixForum
Posts: 83
Joined: Mon Aug 07, 2000 8:00 am
Location: Stockholm Sweden

RE: Load files

Post by John T_MatrixForum »

And As of now I haven't bothered with mapping hexes to maps but
I did a quick fix and divided hex position by 10 and gave those with combat a name
So here we got losses per area: (top 20 areas)


Image
Attachments
LossesPerMegaHex.jpg
LossesPerMegaHex.jpg (61.71 KiB) Viewed 88 times
/John T
John T_MatrixForum
Posts: 83
Joined: Mon Aug 07, 2000 8:00 am
Location: Stockholm Sweden

RE: Load files

Post by John T_MatrixForum »

And last
by selecting Tanks only and German force got Tank lossses per gameturn:

It would be really nice to access formations and unit Supply and readiness too..

Cheers


Image
Attachments
Germantan..ssesTime.jpg
Germantan..ssesTime.jpg (48.64 KiB) Viewed 87 times
/John T
User avatar
Telumar
Posts: 2196
Joined: Tue Jan 03, 2006 12:43 am
Location: niflheim

RE: Load files

Post by Telumar »

[&o]

Great stuff. A short "How To" wouldn't hurt...
User avatar
golden delicious
Posts: 4114
Joined: Tue Sep 05, 2000 8:00 am
Location: London, Surrey, United Kingdom

RE: Load files

Post by golden delicious »

ORIGINAL: John T

And As of now I haven't bothered with mapping hexes to maps but
I did a quick fix and divided hex position by 10 and gave those with combat a name
So here we got losses per area: (top 20 areas)

Very interesting! For bonus points, do a bubble graph and then overlay over the map itself....
"What did you read at university?"
"War Studies"
"War? Huh. What is it good for?"
"Absolutely nothing."
John T_MatrixForum
Posts: 83
Joined: Mon Aug 07, 2000 8:00 am
Location: Stockholm Sweden

RE: Load files

Post by John T_MatrixForum »

ORIGINAL: Telumar

[&o]

Great stuff. A short "How To" wouldn't hurt...


There is a bunch of utilities who makes one file out of many but the "simplest way":
First copy all log-files to a new directory Like C:\temp1
Then open a command window and use cd command to get to that directory
now just write copy *.csv OneFile.csv

Then open OneFile.csv in Excel

Add column headers on top of each column.

mark the whole area and "Insert" - "New Pivotal graph"

(As you notice I added some extra columns to the right)

Image
Attachments
Excel1.jpg
Excel1.jpg (44.68 KiB) Viewed 88 times
/John T
John T_MatrixForum
Posts: 83
Joined: Mon Aug 07, 2000 8:00 am
Location: Stockholm Sweden

RE: Load files

Post by John T_MatrixForum »

After choosing "new pivotal graph"
the screen looks like this:

Image
Attachments
Excel3.jpg
Excel3.jpg (195.6 KiB) Viewed 87 times
/John T
John T_MatrixForum
Posts: 83
Joined: Mon Aug 07, 2000 8:00 am
Location: Stockholm Sweden

RE: Load files

Post by John T_MatrixForum »

and then from the area to the Right "PivotTable filed list"
Drag down the fields (column names) in the boxes below.
The value field has a bad tendency to get counted (number of rows) rather than summed (sum of number in field) so Check it says Sum of values and not count of values!


Image
Attachments
Excel3b.jpg
Excel3b.jpg (114.13 KiB) Viewed 87 times
/John T
John T_MatrixForum
Posts: 83
Joined: Mon Aug 07, 2000 8:00 am
Location: Stockholm Sweden

RE: Load files

Post by John T_MatrixForum »

Check it says Sum of values and not count of values!

If it's count click on the field and change to Sum


Image
Attachments
Excel5.jpg
Excel5.jpg (10.07 KiB) Viewed 87 times
/John T
John T_MatrixForum
Posts: 83
Joined: Mon Aug 07, 2000 8:00 am
Location: Stockholm Sweden

RE: Load files

Post by John T_MatrixForum »

ORIGINAL: golden delicious

Very interesting! For bonus points, do a bubble graph and then overlay over the map itself....

Do you have a clever way to convert a hex to Long-Lat ?

Mr Le May made a small basic utility that generated LongLat for a map but I need the algorithm
(Most probably out there in the net) And if someone got a clever way to generate Hex shaped polygons in a Geospatial format I could start doing funny things.

Point is I need to play around with Microsoft BI suite (SSAS/SSIS/Reporting Services) to test things I have not done professional life.
but I can't waste that much time on inventing clever code that's game specific.

/John T
User avatar
Telumar
Posts: 2196
Joined: Tue Jan 03, 2006 12:43 am
Location: niflheim

RE: Load files

Post by Telumar »

Thanks for the info, especially how to simply merge several csv files into one file with the command line. Didn't know that this was possible.[:)]

I have no problem with creating pivot tables, diagrams etc. However your guide is very helpful. But you might want to list which column is which data... especially column H. See the screenshot from an imported .csv file in LibreOffice:

Image

EDIT: Forget about the 0 before Hex x/y - it's a typo..
Attachments
cb44.jpg
cb44.jpg (190.6 KiB) Viewed 87 times
ogar
Posts: 297
Joined: Sun Sep 06, 2009 8:31 pm

RE: Load files

Post by ogar »

It's in Ralph's replies to Larry F. in the thread about Larry's CSV utility.

As I recall, it's the weight of the eqp_item. The few eqp_items I've checked match up. Dunno why it's there, but if Ralph says so, I believe it.
User avatar
Telumar
Posts: 2196
Joined: Tue Jan 03, 2006 12:43 am
Location: niflheim

RE: Load files

Post by Telumar »

ORIGINAL: ogar

It's in Ralph's replies to Larry F. in the thread about Larry's CSV utility.

As I recall, it's the weight of the eqp_item. The few eqp_items I've checked match up. Dunno why it's there, but if Ralph says so, I believe it.

It's here in the Autumn Fog thread: fb.asp?m=2339711 and it's icon. Equipment icon.
ogar
Posts: 297
Joined: Sun Sep 06, 2009 8:31 pm

RE: Load files

Post by ogar »

Thanks.

Guess this means that I shouldn't quit my day-job.
Post Reply

Return to “Norm Koger's The Operational Art Of War III”