Slitherine

quote:

Here

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

quote:

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

quote:

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

Cobra Aus

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

quote:

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

quote:

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.
I just checked manual again Allied slots rang from 3000 to 9999
I have created russian ships in the range 9818 to 9997 these now apprear in game and are working ok so the last 25 slots are ok to use


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

quote:

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

quote:

I have found the missing line is the last line on the Japanese ship sheet instead of the first line on the Allied sheet

Cobra Aus

quote:

You never did say whether or not removing the Protection allowed you to do the Compare and Merge or not.

quote:

first report on 1.3
problem 1
locations - only showing locations 216 to 931 should be 1 to 3999 which is breaking location
reporting in other sheets (I am just wondering if the sheet you where working on had the location sheet filtered to only a few location and not all)(I have tried refiltering to show all bbut on the above mentioned slots appear)
problem 2
Allied ships and formulas sheet
you need to copy down from slot 6980 to 7004 the TYPE,LOCATION,BITMAP formulas
the same for the Formula sheet columns Q,R,S

now this may relate to problem 1
in both the Japanese and Allied Air groups there are strange location slot numbers appearing
in the ranges of 4000 to 8000 which are not in editor database and are of course not reporting locations

these problems are common to all sheets created from original excel 1.3 sheet

cant test much further until these are fixed

I just wondering if we just work together on this until we get it right before sending to Spookies again ??

Cobra Aus

quote:

I have been extensive use of the editor, and I find it a lot easier to use than the tools provided with the game. I have one quick question, for I do not wish to mess up many hours worth of work. If I add a row in the LCU worksheet will it have any adverse effects? I was going to add a slot for US Airborne Div., but if doing so would create major problems then I am not going to pursue it.

quote:

Before I delve deeper into the missing locations issue, I need to know if you Synchronized Bases (from the toolbar menu) after loading a new scenario?

quote:

sorry mate but this is what I am trying to get my head around
in the allied air groups sheet if you look at slot 1812 it = Ag VF-2 and in colomn G has a loc of 7001 which when calulated shows a location of IJA SQR Infantry (returned by Formula Y30)
VF-2 as per WITP Editor is located on CV Lexington LOC 3001
1st question is looking down from slot 1812 colomn G locs are all in the 7000+ range which is pulled in with the Get Function WHAT IS THIS 7000 RANGE MEAN IN TERMS OF AIR GROUPS LOCATION IN GAME this is not making scence should not the GET Function return 3001 etc as in the example above ???
IJA SQR Infantry can be found in the LOC Sheet at slot 930

Hope this makes sence as I am getting lost trying to work this out

Cobra Aus

quote:

I see now. Y30 of the Formulas sheet should be:

quote:

beauty newc that fixed all that up now only the LOC SHEET needs looking at

Cobra Aus

quote:

I can't find any problems in the Loc sheet. Did you ever Synchronize Bases? If you do not do that after loading a scenario, the locations could be completely screwed up. The synchronizing matches up the bases to the hexes and you can imagine how different those match ups are between a CHS scenario and a standard scenario.

quote:

By loading scenario I take it that means loading in the spreadsheet, set pathing up do a Get All THEN SYNC the LOCS if it is, then I will do that BUT matchups is not what I mean as they seem alright but in the WITP Editor there are 3999 slots to put Locations into but in the spreadsheet there is only slots 216 to 931 (unless the original sheet was filtered to show only those slots and we just cant see the others) we are missing nealy 3200 slots, my problem. is say if you were to save a Scenario back to an totally empty Dat file only slots 216 to 931 would appear in it, or put in a new location via the editor into a slot outside the spreadsheets range the Get Data would not pull the new location into the spread sheet

Cobra Aus

quote:

Just downloaded version 1.3, as I told you I´m very interested in editing huge numbers of pilots - saw the new tab - hit the "get pilots" button, but............ old pilots remain!!! Not a single one from my modified scenario has been loaded!!! Same problem when using the "put pilots" button.
What am I doing wrong or missing? Thank you for the great work!

Used the sync airplanes with airgroups feature and it works beautifully, also used the find leaders command and was succesful, except for some Russian leaders I have assigned to base force LCU´s and that are assigned for sure under the LCU tab, but not under the leader tab.

< Message edited by Bubi Hartmann

quote:

WitPExcel breaks the wpl.dat into pieces to make it easier to work with.