Matrix Games Forums

 Forums  Register  Login  Photo Gallery  Member List  Search  Calendars  FAQ 

My Profile  Inbox  Address Book  My Subscription  My Forums  Log Out

WitPExcel editor is ready

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

Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [Current Games From Matrix.] >> [World War II] >> War In The Pacific - Struggle Against Japan 1941 - 1945 >> Scenario Design >> WitPExcel editor is ready Page: [1] 2 3   next >   >>
Login
Message << Older Topic   Newer Topic >>
WitPExcel editor is ready - 7/28/2005 5:18:08 AM   
Aawulf

 

Posts: 116
Joined: 7/14/2005
Status: offline 		I have finished (at least enough to use) my WitPExcel editor. If you used Rich Dionne's PacWar editor or my WiRExcel editor, then you will find this one easy to use and then some.

If you only change a few items here and there, then the game's built-in editor is still your best option.

If you make sweeping changes, design scenerios, desire a more informative interface, want 50 Abn divisions or just want to see all of your LCUs or ships at a given location all together for planning, then you might like this tool.

I have also included production summaries with a production worksheet for planning and designing and an auditor that automatically shows you which HQ's, LCUs, ships and air groups that your leaders are assigned (Easy fix for the leader being overworked with multiple commands).

Edits and manages:
1. Devices
2. HQs
3. LCUs
4. Bases
5. TFs
6. Ship Classes
7. Ships
8. Aircraft
9. Air Groups
10. Leaders
11. Production
12. Pilots
13. Map hexes

Version 1.4 is available for download by Spooky's generosity.

The editor uses Microsoft Excel (designed on XP version of Office, so not sure if older versions of Excel will work or not). Even though I reqularly scan for viruses and spybots, I still encourage the end user to exercise caution and scan first. Macros must be enabled.

m.fleshman@verizon.net

Regards,
Michael Fleshman

< Message edited by Aawulf -- 9/18/2005 5:29:30 AM >

_____________________________

Never ever ever ever let a day pass without remembering that we are fighting a war for our survival. God bless our troops.
Post #: 1
RE: WitPExcel editor is ready - 7/28/2005 5:43:47 AM   
CobraAus


Posts: 2322
Joined: 8/23/2004
From: Geelong Australia
Status: offline 		please send
to cobra49492000@yahoo.com.au

mucho thanks

Cobra Aus

(in reply to Aawulf)
Post #: 2
RE: WitPExcel editor is ready - 7/28/2005 6:29:21 AM   
Alikchi2

 

Posts: 1785
Joined: 5/14/2004
Status: offline 		I'd definitely like to see this

alikchi@gmail.com - many thanks!

_____________________________


(in reply to CobraAus)
Post #: 3
RE: WitPExcel editor is ready - 7/28/2005 4:34:32 PM   
Herrbear


Posts: 883
Joined: 7/26/2004
From: Glendora, CA
Status: offline 		I would also like to see it.

herrbear@hotmail.com

Thank you

(in reply to Aawulf)
Post #: 4
RE: WitPExcel editor is ready - 7/28/2005 5:04:47 PM   
ancient doctor

 

Posts: 152
Joined: 9/21/2004
Status: offline 		How about this Spooky(?) site that has so many other user made things for the game?
Anyway send it to me if you can also.
nik_medic@hotmail.com

Cheers

(in reply to Herrbear)
Post #: 5
RE: WitPExcel editor is ready - 7/28/2005 7:31:20 PM   
scout1


Posts: 2899
Joined: 8/24/2004
From: South Bend, In
Status: offline 		Spooky's would be a good site to post this. Just send him a request, I'd bet he'd be happy to post it for you.

Is this an editor tool (similar to witpload for extraction/importing) turn 0 database information or is it something more ???/

(in reply to ancient doctor)
Post #: 6
RE: WitPExcel editor is ready - 7/28/2005 8:15:38 PM   
Aawulf

 

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

Is this an editor tool (similar to witpload for extraction/importing) turn 0 database information or is it something more ???/

It is an editing tool. It does extract and import the same data that any kind of editor would have to do if one desires to edit scenerios for WitP. The goal was to provide a means to turn the imported data into information that is easily understood and managable.

Whether this tool is "less" or "more" depends on individual needs and wants. It is definitely a different approach to editing WitP than anything I have seen if that is what you want to know. Of course, there are people who can fulfill their needs by walking everywhere they go while others require an automobile. It does more, but the potential user really needs to ask if they need or want more and that is only relevant if they have and are comfortable with Excel.

Regards,
Michael Fleshman

_____________________________

Never ever ever ever let a day pass without remembering that we are fighting a war for our survival. God bless our troops.

(in reply to scout1)
Post #: 7
RE: WitPExcel editor is ready - 7/28/2005 8:35:55 PM   
treespider


Posts: 9796
Joined: 1/30/2005
From: Edgewater, MD
Status: offline 		I noticed line 1 of several of the worksheets is essentially the descriptive version of the numeric designators for a given slot (I asume you used lookup functions). What is the easiest way to convert to the slot you would like to see?

For example when I first open the Japanese ships sheet, Kaga is displayed in line 1. If I scroll down and click on line 36, line 1 remains the same. However if I double click then click on a new cell, Line 1 will display the Line 36 info...is there another way to do this?

Edit: Never mind ....F9

< Message edited by treespider -- 7/28/2005 8:40:30 PM >

_____________________________

Here's a link to:
Treespider's Grand Campaign of DBB

"It is not the critic who counts, .... The credit belongs to the man who is actually in the arena..." T. Roosevelt, Paris, 1910

(in reply to Aawulf)
Post #: 8
RE: WitPExcel editor is ready - 7/29/2005 3:11:56 AM   
CobraAus


Posts: 2322
Joined: 8/23/2004
From: Geelong Australia
Status: offline 		observations and problems

pathing.. novice users of excell will need some documentaion on how to path to the SEN dir and the Sen DAT file they want to look at/change
this is going to be excelent for comparing one sen with another and bulk cut and past from one Sen to another using the Window/Compare tool.
Rule ONE before user start touse this BACKUP THE SEN DIR
RULE 2 DONT use original WIPTEXCel Sheet rename to SEN you want to work with
eg rename to WITP155-102.0.xls (the .0. tells you what version of WITPEXCEL the sheet came from) to work with CHS 1.02 when new version of sen mod come out create from original sheet a new sheet renamed to WITP155-1xx.0.xls use compare to look at changes allways keep orginal to create new sheet from.

Now the problems I am having (all good thinks bring pain to begin with)
1 using get/open with devices seems to work (no errors but I dont get the Panel (will take a couple of min's will beep ok))
2 using get/open aircraft has problem getting data it is pulling device info and names in columns + no panel pops up
2 using get/open on shipclass.airgroups.leaders.locations.jap ship and allied ship file all produce a VB error of 1004 (on these I get the POPUP time warning beep panel)the end result in sheet is no data at all or scrambled Device info

see sample panel below

AAWulf any clues its been years since I programed in excel and have not used VB at all
I am using Excel out the Microsoft office 2003 Pakage
Cobra Aus










Attachment (1)

< Message edited by CobraAus -- 7/29/2005 3:48:16 AM >

(in reply to treespider)
Post #: 9
RE: WitPExcel editor is ready - 7/29/2005 4:39:30 AM   
Aawulf

 

Posts: 116
Joined: 7/14/2005
Status: offline 		Cobra, it appears that you have the wpd0xx file listed in the slot where the wpc0xx file should be listed. And, the wpd0xx file listed in the slot where the wpa0xx should be. I had considered automating that process whereby only the directory and scenerio number was needed, but in the end I scratched that in favor of leaving the flexibility to the user to work on any piece of a scenerio independently of the other files. [I hope that is your problem; otherwise it would mean something screwy happened like the macros for the buttons may have been somehow scrambled when the file was zipped and unzipped]

I agree. I do need to make documentation for people to at least get started.

I just received an email from Spooky wherein he offered to provide the DL service from his site. Very much appreciated. Before I send it to him, I will put together a simple "how to" set of instructions.

_____________________________

Never ever ever ever let a day pass without remembering that we are fighting a war for our survival. God bless our troops.

(in reply to CobraAus)
Post #: 10
RE: WitPExcel editor is ready - 7/29/2005 4:49:59 AM   
CobraAus


Posts: 2322
Joined: 8/23/2004
From: Geelong Australia
Status: offline
quote:

Cobra, it appears that you have the wpd0xx file listed in the slot where the wpc0xx file should be listed. And, the wpd0xx file listed in the slot where the wpa0xx

I am an apsolute clot (plus it was lat and I was tired) I changed the path for the first
reference then just cut and pased down the list (Dumb move) will fix and report back
now working ok and starting to look at abilties
Cobra Aus

< Message edited by CobraAus -- 7/29/2005 5:36:55 AM >

(in reply to Aawulf)
Post #: 11
RE: WitPExcel editor is ready - 7/29/2005 6:47:11 AM   
CobraAus


Posts: 2322
Joined: 8/23/2004
From: Geelong Australia
Status: offline 		what could be wrong here - see sample screen

just testing at this stage
when cut and past from 1 sheet to another in allied ship data
the type calc is not pick up the type of ship it is picking up location ok

the cut and past is working fine in the ship class area already done several tests

now a query on what could a potential winner.. the compare and merge function in tools area I would like to test but is greyed out if we could get this to work would save a lot of cut and pasting


PS still getting 1004 error if using get all buttion is this because some funtions not completed
cobra aus




Attachment (1)

< Message edited by CobraAus -- 7/29/2005 7:30:22 AM >

(in reply to CobraAus)
Post #: 12
RE: WitPExcel editor is ready - 7/29/2005 7:35:19 AM   
Aawulf

 

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

what could be wrong here - see sample screen

From what I see, it looks like scen158 has the Ship Classes already updated to include the 1906 while scen155 has no entry in that row in Ship Classes. Also, I see that Base #282 is not named in your Locations file in your scen158.

The only things not functioning should be PWHex and Pilots. PWHex isn't functional because I don't know what the 12 columns define and I simply haven't decided if spending time and increasing the file size even more is worth it for the ability to edit pilots.

That "Get All Files" is returning an error for you concerns me greatly. Email me your scen158 and I will examine it. In the mean time, I will test to see what affect renaming the file may have on button macros. I suspect that I might have an absolute filename tag on that macro.

Thank you for the feedback.

Regards,
Michael Fleshman

_____________________________

Never ever ever ever let a day pass without remembering that we are fighting a war for our survival. God bless our troops.

(in reply to CobraAus)
Post #: 13
RE: WitPExcel editor is ready - 7/29/2005 7:50:29 AM   
CobraAus


Posts: 2322
Joined: 8/23/2004
From: Geelong Australia
Status: offline
quote:

PWHex isn't functional because I don't know what the 12 columns define

Andrew Brown has done a lot of work in the PWHex area and should be able to help there

and you just gave me a clue to look at

and error for get all is runtime error 1004 macro 'CALCNO' cannot be found

(in reply to Aawulf)
Post #: 14
RE: WitPExcel editor is ready - 7/29/2005 8:01:00 AM   
Aawulf

 

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

and error for get all is runtime error 1004 macro 'CALCNO' cannot be found

Aha! Renaming the file changed it to "[workbookname]calcno.calcno". I am stumped at the moment, but will solve in the next hour or so.

Regards,
Michael Fleshman

_____________________________

Never ever ever ever let a day pass without remembering that we are fighting a war for our survival. God bless our troops.

(in reply to CobraAus)
Post #: 15
RE: WitPExcel editor is ready - 7/29/2005 1:36:08 PM   
CobraAus


Posts: 2322
Joined: 8/23/2004
From: Geelong Australia
Status: offline
quote:

Aha! Renaming the file changed it to "[workbookname]calcno.calcno". I am stumped at the moment, but will solve in the next hour or s

thats interesting why do it to that function and not the individual get button function which are working fine
I have just about got this sucker worked out and it will be the bees knees for sen mods
another problem bites the dust
the clue you gave me solved the type lable problem I did not relise you had cross linked
macros which means that you gave to apply data same as you do in data editor
input or cut and past the ship class data first then input or cut and past the ships data
which now bring up an interesting question
when you are modding and reverse enginerring (eg you only have a ship name you dont know if its in game yet or not and you need to know which bitmap/slot the ship class data is going to refer to or do you have to create a new class and art)normally you would have a list printed of ships/bitmaps/slot obtained from a utility such as WITPexporter and look it up and this brings me to..
in the actual ship name sheet.. would it be possible to have a column pulling data from the ship class sheet showing bit map used,for referance only. the column would not be part of the save function

Cobra Aus

(in reply to Aawulf)
Post #: 16
RE: WitPExcel editor is ready - 7/29/2005 5:40:19 PM   
Aawulf

 

Posts: 116
Joined: 7/14/2005
Status: offline 		I left at least one free column that is unused and unprotected on each sheet. The equation would be simple enough since there is a Bitmap column on the Ship Class sheet.

"=vlookup(c5,ShipClass,'Ship Class'!$q$3)" typed in Q5 of the ship sheets and copy/pasted down the range of the column will fulfill that need.

I discovered the cause of the button macro problem was that I created the macro with two different named versions of WitPExcel open, hence the name of the macro being automatically changed to include the name of the workbook. My apologies for not thinking about the consequences of doing that. The problem wasn't revealed in my testing because I had the named macro. I had to delete all of the modules and macros to fix the name issue. I can send it to you now or you might wait until I finish adding a few new functions today (a tool bar menu to activate anything from any sheet, auto syncronize button for LCUs to their formation type, auto synchronize button for ships to Class, auto syncronize button for air groups to aircraft and the Misc page will automatically fill the rest of the file locations once you fill in the Device file location).

Thanks again for feedback.

Regards,

Michael Fleshman

_____________________________

Never ever ever ever let a day pass without remembering that we are fighting a war for our survival. God bless our troops.

(in reply to CobraAus)
Post #: 17
RE: WitPExcel editor is ready - 7/30/2005 6:48:24 AM   
CobraAus


Posts: 2322
Joined: 8/23/2004
From: Geelong Australia
Status: offline 		the utility is now posted at Spookies I would recomend anybody working in sen mods download and learn to use - the is the missing link for data base editing and is ongoing project from a new member whom I welcome to the Forum

Cobra Aus

(in reply to Aawulf)
Post #: 18
RE: WitPExcel editor is ready - 7/30/2005 7:10:44 AM   
CobraAus


Posts: 2322
Joined: 8/23/2004
From: Geelong Australia
Status: offline 		sorry to keep coming up with these but here is new problem which will upset the saving of the data back you can try this self if you have the CHS102 sen downloaded
I have tried the get data of Allied ships twice now with the same result
using the WITPExcel1.0 sheet as referance and WITP155.xls (CHS1.02) as the work sheet
note the first line of data is a dummy heading for CV's which is correct when lokking at sen with the editor..but when data get is finished the first line is for the Lexington in slot
3000 should be in slot 3001 and should be CV header if you look further down the sheet (not in sample) it is picking up other headers such as CVL's ok now if you save this back every thing will be out of plase by 1 slot number..see sample below.. solution needed
japanese ships seem ok
Cobra Aus




Attachment (1)

< Message edited by CobraAus -- 7/30/2005 7:14:31 AM >

(in reply to CobraAus)
Post #: 19
RE: WitPExcel editor is ready - 7/30/2005 7:42:16 AM   
CobraAus


Posts: 2322
Joined: 8/23/2004
From: Geelong Australia
Status: offline 		another request
this can be a very confusing area for moders
aircraft data sheet there is a missing column that is needed to indicate which Bitmap the aircraft slot is using most of the slot/bitmaps line up eg slot one = bitmap 1
but from slot 200 onwards you will find in one case 3 slots are using the same bit map
for slots 246 to 249 the are no matching bitmaps available so you have to refer to bitmaps other than the slot number - so could we have a column added to pull in the bitmap data which is in the database

Cobra Aus

(in reply to CobraAus)
Post #: 20
RE: WitPExcel editor is ready - 7/30/2005 8:21:39 AM   
Herrbear


Posts: 883
Joined: 7/26/2004
From: Glendora, CA
Status: offline 		I assume that your editor, like the one in the game, will not impact existing games when changes are made and saved to the file. You would have to restart to have the changes take effect.

Am I correct?

(in reply to Aawulf)
Post #: 21
RE: WitPExcel editor is ready - 7/30/2005 3:29:52 PM   
morphin

 

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

I have also the error 1004 when loading airgroup with WITPExcel V1.1 (Blank scenario 35 from pry)

Andy

(in reply to Herrbear)
Post #: 22
RE: WitPExcel editor is ready - 7/30/2005 4:45:09 PM   
michaelm75au


Posts: 13500
Joined: 5/5/2001
From: Melbourne, Australia
Status: offline 		Hi
all data from the scenario files is loaded when a scenario is first started. From then on, it is stored in the save file.

So changing the OOB files will not impact the save files.

Michael

(in reply to Herrbear)
Post #: 23
RE: WitPExcel editor is ready - 7/30/2005 9:48:33 PM   
Aawulf

 

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

...have tried the get data of Allied ships twice now with the same result
using the WITPExcel1.0 sheet as referance and WITP155.xls (CHS1.02) as the work sheet
note the first line of data is a dummy heading for CV's which is correct when lokking at sen with the editor..but when data get is finished the first line is for the Lexington in slot
3000 should be in slot 3001...

I will DL CHS and try to isolate potential causes. I am curious if that problem persists using version 1.1 .

Regards,

Michael Fleshman

(in reply to CobraAus)
Post #: 24
RE: WitPExcel editor is ready - 7/30/2005 9:54:23 PM   
Aawulf

 

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

another request
this can be a very confusing area for moders
aircraft data sheet there is a missing column that is needed to indicate which Bitmap the aircraft slot is using most of the slot/bitmaps line up eg slot one = bitmap 1
but from slot 200 onwards you will find in one case 3 slots are using the same bit map
for slots 246 to 249 the are no matching bitmaps available so you have to refer to bitmaps other than the slot number - so could we have a column added to pull in the bitmap data which is in the database

Cobra Aus

I will add that to the next update. In fact, I originally had it in and then removed it because I figured the in-game editor was effective enough at handling the micro editing. But I now see the value in being able to quickly change the bitmap for all associated air groups. Good idea.

Regards,

Michael Fleshman

(in reply to CobraAus)
Post #: 25
RE: WitPExcel editor is ready - 7/30/2005 9:57:45 PM   
Aawulf

 

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

I assume that your editor, like the one in the game, will not impact existing games when changes are made and saved to the file. You would have to restart to have the changes take effect.

Am I correct?

You are correct. I wish I could edit save game files though to create scenerios from them. Oh the joy it would be to have Turn 1 moves aleady done at the start of the scenerio rather than redoing them again and again and again.

Regards,

Michael Fleshman

(in reply to Herrbear)
Post #: 26
RE: WitPExcel editor is ready - 7/30/2005 10:08:11 PM   
Aawulf

 

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

I have also the error 1004 when loading airgroup with WITPExcel V1.1 (Blank scenario 35 from pry)

Andy

Hi Andy.

I believe that was caused by locked cells below the "Name" column. As odd as that sounds, the changes in version 1.1 seem to have corrected that issue.

Regards,

Michael Fleshman

(in reply to morphin)
Post #: 27
RE: WitPExcel editor is ready - 7/30/2005 11:30:58 PM   
morphin

 

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

It is still here, error 1004, but only with Scenario 35 from pry. Scenario 155 is working fine....

Andy

(in reply to Aawulf)
Post #: 28
RE: WitPExcel editor is ready - 8/1/2005 2:33:02 AM   
CobraAus


Posts: 2322
Joined: 8/23/2004
From: Geelong Australia
Status: offline
quote:

I have also the error 1004 when loading airgroup with WITPExcel V1.1 (Blank scenario 35 from pry)


I also getting 1004 eror loading airgroup with 1.1 sen 33 from pry

Cobra Aus

(in reply to morphin)
Post #: 29
RE: WitPExcel editor is ready - 8/1/2005 5:27:22 AM   
Aawulf

 

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

I also getting 1004 eror loading airgroup with 1.1 sen 33 from pry

Cobra Aus

Where can I DL Pry's scenarios so I can look at the wpg database?

_____________________________

Never ever ever ever let a day pass without remembering that we are fighting a war for our survival. God bless our troops.

(in reply to CobraAus)
Post #: 30
Page:   [1] 2 3   next >   >>
All Forums >> [Current Games From Matrix.] >> [World War II] >> War In The Pacific - Struggle Against Japan 1941 - 1945 >> Scenario Design >> WitPExcel editor is ready Page: [1] 2 3   next >   >>
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

2.297