I miss the great WitpExcel042 File

Matrix Games Forums

Forums Register Login Photo Gallery Member List Search Calendars FAQ

My Profile Inbox Address Book My Subscription My Forums Log Out

I miss the great WitpExcel042 File

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [New Releases from Matrix Games] >> War in the Pacific: Admiral's Edition >> Scenario Design and Modding >> I miss the great WitpExcel042 File

Page: [1]

Message

<< Older Topic Newer Topic >>

I miss the great WitpExcel042 File - 5/28/2020 6:39:26 PM

morphin

Posts: 572
Joined: 4/26/2002
From: Switzerland
Status: offline

I really miss the the great Excel File WitpExcel04 from Aawulf (see
https://www.matrixgames.com/forums/tm.asp?m=911291&mpage=1&key=󞞻)

It is a great Tool for mass changes of a scenario (Import, Change and export) but also for Planing

Download here:
http://mathubert.free.fr/witp_files/WitpExcel042.zip

I once managed to make it work with WitpAE also, but i lost the version and i'm overhelmed with the complexity of the code.
So at the moment i can only import the datafiles, but the Summary Tab is not filling with data..

It's a pity so a great Tool.

It would be helpful to have an Utility that helps to (mass) change a Scenario like this one

(Good old time of the WITP game time )

Post #: 1

RE: I miss the great WitpExcel042 File - 5/28/2020 6:46:07 PM

LargeSlowTarget

Posts: 4443
Joined: 9/23/2000
From: Hessen, Germany - now living in France
Status: offline

The SCEN folder contains a file called witploadAE.exe which is a tool to dump the scenario files into .csv files for Excel and to convert them back into scenario files.

You need to use the DOS window of Windows - use "Windows key + r" to open the "execute" box and enter

cmd.exe /K "cd c:\matrix games\war in the pacific admiral's edition\scen\"

You need to modify the path if you have not installed the game in the default path.

In the scenario folder path, you enter the following commands - with xx being the scenario number:

To export scenario #xx in the current directory
WITPLOADAE.exe /e /s0xx

To import scenario #xx in the current directory
WITPLOADAE.exe /s0xx

In fact, there are two versions of witploadAE.exe, the original 2009 release and an enhanced 2013 version with more data columns available.

I attach the 2013 version for your convenience.

Attachment (1)

< Message edited by LargeSlowTarget -- 5/28/2020 7:04:15 PM >

_____________________________

AE Mod "Bottlenecks" UPDATED 01/2022

(in reply to morphin)

Post #: 2

RE: I miss the great WitpExcel042 File - 5/28/2020 7:00:24 PM

morphin

Posts: 572
Joined: 4/26/2002
From: Switzerland
Status: offline

Yes. I know i often use these tool. Thank's

It is the same as all the tools use in the background. It would be nice to import all the CSV into Excel, resolve the references. Make mass changes of the scenario and export again to CSV. I have once startet to make one, but limited time and Excel-Knowledge i didn't continue.

(in reply to LargeSlowTarget)

Post #: 3

RE: I miss the great WitpExcel042 File - 5/28/2020 7:35:42 PM

Aawulf

Posts: 116
Joined: 7/14/2005
Status: offline

Thanks for the shout out.

That was a very long time ago. Originally Rich Dionne produced an Excel editor for PacWar and contacted him about the ideas I had to expand upon what he had done at the time. The challenges then were the fixed pieces of data that didn't fit well where they were stored and having to identify what just couldn't be altered without making a big mess.

With WitPAE, the challenge has been huge ranges and my less nimble mind. I used to be able to crunch the numbers in my head, but my kids call me "boomer" now for a reason.

That said, I have been slowly working through both WitPAE and War In the East for mass editing. I found though that by adding a macro, the "load" process was a less painful way than finding all of the ranges to go about reaching many of the same capabilities. I too miss the summaries from WitPExcel though.

(in reply to morphin)

Post #: 4

RE: I miss the great WitpExcel042 File - 5/28/2020 7:45:14 PM

morphin

Posts: 572
Joined: 4/26/2002
From: Switzerland
Status: offline

Great Michael to see you back.

After 3 years i'm consider to start again.....

Are you on board again?

(in reply to Aawulf)

Post #: 5

RE: I miss the great WitpExcel042 File - 5/28/2020 8:09:26 PM

Aawulf

Posts: 116
Joined: 7/14/2005
Status: offline

I find myself drawn back from time to time. As much as I love the Grigsby games and the thousands of hours I have committed to them, I have honestly never finished a full campaign. I think I enjoy the chase of trying to figure out faster ways to create scenarios and manage a game as much as I do playing the game. And then there is real life as a father that I have to dabble in too. Well, now that my youngest is 17, I have to beg them to take up my time these days. Whenever I want a deep dive gaming experience, there is no real alternative to the WitP's for a combined arms theater experience.

(in reply to morphin)

Post #: 6

Page: [1]

All Forums >> [New Releases from Matrix Games] >> War in the Pacific: Admiral's Edition >> Scenario Design and Modding >> I miss the great WitpExcel042 File

Page: [1]