How can I make spreadsheets out of AE edit?

Share your gameplay tips, secret tactics and fabulous strategies with fellow gamers here.

Moderators: wdolson, MOD_War-in-the-Pacific-Admirals-Edition

Post Reply
Freedom205
Posts: 306
Joined: Mon Dec 04, 2000 10:00 am
Location: Michigan USA

How can I make spreadsheets out of AE edit?

Post by Freedom205 »

I have read the editor manual and browsed through the AE editor, and it is loaded with great information that I would love to be able to print out and read side by side. ( aircraft dats, leaders etc. ) Sadly it seems that I lack the smarts to figure out how to transfer that data to an easy to read format that can printed. [&:]

Thanks in advance for the help!
User avatar
Graymane
Posts: 584
Joined: Wed Mar 30, 2005 11:21 pm
Location: Bellevue, NE

RE: How can I make spreadsheets out of AE edit?

Post by Graymane »

witploadae.exe in the SCEN directory.
A computer without COBOL and Fortran is like a piece of chocolate cake without ketchup and mustard.
Freedom205
Posts: 306
Joined: Mon Dec 04, 2000 10:00 am
Location: Michigan USA

RE: How can I make spreadsheets out of AE edit?

Post by Freedom205 »

I cant seem to get it to open, tried right clicking and selecting "open" and double clicking.
User avatar
Dutch_slith
Posts: 336
Joined: Thu Jul 21, 2005 8:21 am
Location: the Netherlands

RE: How can I make spreadsheets out of AE edit?

Post by Dutch_slith »

You have to use the DOS-Box...

something like this:

cd Games\War in the Pacific Admiral's Edition\SCEN
witpload /e /s01

/e means export
/s01 means scenario 001

You'll find several csv-files in the SCEN-directory...
Image
User avatar
wdolson
Posts: 7689
Joined: Tue Jun 27, 2006 9:56 pm
Location: Near Portland, OR

RE: How can I make spreadsheets out of AE edit?

Post by wdolson »

witploadae.exe works from the command prompt.  Go to Start->Run and type cmd into the box, then click OK.  You will get a window that looks like an old DOS prompt.  You will have to navigate through the directories to your SCEN folder, then you can run witploadae and extract the data from the scenario files which you can open with Excel.

Bill
WIS Development Team
User avatar
Hanzberger
Posts: 925
Joined: Wed Apr 26, 2006 12:16 pm
Location: SE Pennsylvania
Contact:

RE: How can I make spreadsheets out of AE edit?

Post by Hanzberger »

Follow up.  I tried this and have trouble with the path I suppose.
Outside of Dos this is how I get to the folder.
My computer, Local Disk, Matrix games, WITPAE, SCEN    How would I write the cmd to get to this?
Playing Scen 2 vs Ai currently

Japan AC wire chart here
tm.asp?m=2769286&mpage=1&key=?
User avatar
n01487477
Posts: 4764
Joined: Tue Feb 21, 2006 12:00 am

RE: How can I make spreadsheets out of AE edit?

Post by n01487477 »

ORIGINAL: Hanzberger

Follow up.  I tried this and have trouble with the path I suppose.
Outside of Dos this is how I get to the folder.
My computer, Local Disk, Matrix games, WITPAE, SCEN    How would I write the cmd to get to this?
In Dos

cd\
Prompt will show c:\>
cd Matrix Games\War In The Pacific Admiral's Edition\SCEN
Prompt will show c:\Matrix Games\War In The Pacific Admiral's Edition\SCEN

--Damian--
User avatar
Hanzberger
Posts: 925
Joined: Wed Apr 26, 2006 12:16 pm
Location: SE Pennsylvania
Contact:

RE: How can I make spreadsheets out of AE edit?

Post by Hanzberger »

Thanks D, do I need to type cd or not  [:'(]
Playing Scen 2 vs Ai currently

Japan AC wire chart here
tm.asp?m=2769286&mpage=1&key=?
User avatar
Dutch_slith
Posts: 336
Joined: Thu Jul 21, 2005 8:21 am
Location: the Netherlands

RE: How can I make spreadsheets out of AE edit?

Post by Dutch_slith »

cd is obligatory (means change directory)
Image
Post Reply

Return to “The War Room”