WitPExcel editor is ready

[Herrbear]

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?

[morphin]

Hi

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

Andy

[michaelm75au]

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

[Aawulf]

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

[Aawulf]

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

[Aawulf]

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

[Aawulf]

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

[morphin]

Hi Michael

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

Andy

[CobraAus]

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

[Aawulf]

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?

[morphin]

Here

http://www.bur.st/%7Eakbrown/witp/scenarios.html

[Aawulf]

Here

http://www.bur.st/%7Eakbrown/witp/scenarios.html

Thank you.

Change the "B" columns (where the names go) on both air group sheets to text format. Looks like the "=" symbols were what was different.

Regards,

Michael Fleshman

[morphin]

Great Michael
Thank's

Andy

[CobraAus]

air groups now working ok - question what is create menu button for - when pressed nothing happens

Cobra Aus

[morphin]

Cobra,
It creates an additional Menu "WitPExcel" with Menu-Entries for Loading, Putting,etc.

Andy

[CobraAus]

It creates an additional Menu "WitPExcel" with Menu-Entries for Loading, Putting,etc.

thanks mate it works

[Aawulf]

question what is create menu button for - when pressed nothing happens

Cobra Aus

It doesn't create a "WitPExcel" menu on the toolbar? It should create a temporary menu where is usually between the "Windows" and "Help" menus.

Edit: Nevermind [:)]

Regards,

Michael Fleshman

[Aawulf]

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 added this to version 1.2 which I just sent to Spooky. Also removed Protection from the database worksheets so "Merge and Compare" should now work. 1.2 includes all of the fixes to the oddities that you all have discovered and the bells and whistles you have asked for to date.

Regards,

Michael Fleshman

[CobraAus]

ok now using 1.2 the only problem I have now relates to when using get all get all allied ship data stops at row 6974/slot9969 instead of gong through to 10000 - when you look at the allied ship sheet you also seemed to have stopped copying formulas at 6973 so you have to extend the formulas for type.location.bitmap down to 10000 as in CHS sen 155 1.02 I now using this range for Russian ships but not picking up the dat to save back - also still havibg probelem in first line missing the CV header as previous reported
Cobra Aus

[Aawulf]

ok now using 1.2 the only problem I have now relates to when using get all get all allied ship data stops at row 6974/slot9969 instead of gong through to 10000 - when you look at the allied ship sheet you also seemed to have stopped copying formulas at 6973 so you have to extend the formulas for type.location.bitmap down to 10000 as in CHS sen 155 1.02 I now using this range for Russian ships but not picking up the dat to save back - also still havibg probelem in first line missing the CV header as previous reported
Cobra Aus

< Message edited by CobraAus

I did that intentionally because the last 25 or so slots had data in some of the columns. If you are certain those slots are fair game for us to edit and that data was refuge, then I can easily extend the range to 9999.

Which scenarios are resulting in the ships being shifted a slot?

Regards,

Michael Fleshman