Matrix Games Forums

 Forums  Register  Login  Photo Gallery  Member List  Search  Calendars  FAQ 

My Profile  Inbox  Address Book  My Subscription  My Forums  Log Out

RE: 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 >> RE: WitPExcel editor is ready Page: <<   < prev  1 2 [3]
Login
Message << Older Topic   Newer Topic >>
RE: WitPExcel editor is ready - 8/7/2005 10:45:04 PM   
CobraAus


Posts: 2322
Joined: 8/23/2004
From: Geelong Australia
Status: offline 		new request
I am playing around in the japanes and allied ship sheets
if you have a look at formula columns O and R if either of the conditions are met it will insert the ships location if not met it will insert a blank. There is another condition that could be set and that is if a ship is delayed (is a location in editor) the formula inserts Delayed into location

Now unfortunatly 000 indicateds Delayed and works fine in the formula but they there are KNOWN slots that would need diferrant return of Respawn instead of Delay if condition is 0
I am going to set this up in the Gold (final) version of the sheets you may want to do this
yourself

Cobra Aus

< Message edited by CobraAus -- 8/7/2005 10:48:49 PM >

(in reply to CobraAus)
Post #: 61
RE: WitPExcel editor is ready - 8/8/2005 12:38:31 AM   
Aawulf

 

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

new request
I am playing around in the japanes and allied ship sheets
if you have a look at formula columns O and R if either of the conditions are met it will insert the ships location if not met it will insert a blank. There is another condition that could be set and that is if a ship is delayed (is a location in editor) the formula inserts Delayed into location

Sure. That will be easy enough to do.

Regards,

Michael Fleshman

(in reply to CobraAus)
Post #: 62
RE: WitPExcel editor is ready - 8/8/2005 2:26:03 AM   
HerzKaraya


Posts: 195
Joined: 1/19/2005
From: Madrid, Spain
Status: offline 		I see, I´ll move the leaders down to slots 7146+ to get it right then.
About the pilots - neither the get option from the misc sheet, nor the get all from the miscelaneous sheet/toolbar menu are working. Pressing the get pilots on the toolbar menu (has a lock next to it), brings up a message "this is a do-nothing macro". Sorry, but I didn´t see it clearly from your previous post, is the pilot editor working?
Regards,


_____________________________

Vista, suerte y al toro!

(in reply to Aawulf)
Post #: 63
RE: WitPExcel editor is ready - 8/8/2005 9:52:08 PM   
Aawulf

 

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

About the pilots - neither the get option from the misc sheet, nor the get all from the miscelaneous sheet/toolbar menu are working. Pressing the get pilots on the toolbar menu (has a lock next to it), brings up a message "this is a do-nothing macro". Sorry, but I didn´t see it clearly from your previous post, is the pilot editor working?
Regards,

What is your email so I can send you the update.

I know why the Get button didn't work in 1.3 (I never reassigned the macro after enabling the feature). I don't know why your menu is still using the map from 1.2. Did you make the menu permanent in your registry? Because that would render it obsolete to updates and add-ins such as the Pilot and PWHex editors.

Regards,

Michael Fleshman

(in reply to HerzKaraya)
Post #: 64
RE: WitPExcel editor is ready - 8/10/2005 1:36:54 AM   
CobraAus


Posts: 2322
Joined: 8/23/2004
From: Geelong Australia
Status: offline 		A sugeston ... a lot of requests for a totally empty data base's so modders could start building a scenario from scratch have have been made over time - would it be possible to have a DELETE all button(function) like the GET button(function) to produce such a database
color red with caution

Cobra Aus

(in reply to Aawulf)
Post #: 65
RE: WitPExcel editor is ready - 8/12/2005 6:31:59 PM   
Apollo11


Posts: 24082
Joined: 6/7/2001
From: Zagreb, Croatia
Status: offline 		Hi all,

quote:

ORIGINAL: Aawulf

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


WOW!

I just saw this thread (I know... I know... I should have visited this sub-forum more frequently) and saw that something I wanted to do 1 year ago is now already done - _THANKS_ !!!

I did Excel editor for Falcon4 and I planned to do it for WitP (and I and others even talked about this here long long long ago) but it never materialized... and now I saw that this is already accomplished...


Leo "Apollo11"

_____________________________



Prior Preparation & Planning Prevents Pathetically Poor Performance!

A & B: WitW, WitE, WbtS, GGWaW, GGWaW2-AWD, HttR, CotA, BftB, CF
P: UV, WitP, WitP-AE

(in reply to Aawulf)
Post #: 66
RE: WitPExcel editor is ready - 8/14/2005 5:49:45 PM   
Herrbear


Posts: 883
Joined: 7/26/2004
From: Glendora, CA
Status: offline 		I still assume that you cannot yet edit the PWhex.dat file with your editor yet?

Thanks.

(in reply to Aawulf)
Post #: 67
RE: WitPExcel editor is ready - 8/18/2005 5:04:23 PM   
Aawulf

 

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

I still assume that you cannot yet edit the PWhex.dat file with your editor yet?

There have been a handful of copies out for the last week or two with the PWHex editor. I was hoping to solve or learn from someone else what the mystery columns are before sending 4.0 to Spooky's, but I won't hold up the PWHex editor anymore for what would fundamentally be cosmetic changes.

In short, we can edit PWHex.dat now with WitPExcel 4.0 and I will send it to Spooky's today or tomorrow.

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 Herrbear)
Post #: 68
RE: WitPExcel editor is ready - 8/23/2005 2:36:52 AM   
CobraAus


Posts: 2322
Joined: 8/23/2004
From: Geelong Australia
Status: offline 		some major questions

1 Editor One of the biggest time consuming problems with the normal editor is that when you make a change in a ship class 9 (any change) you have to step through all the ships related
to that ship class - relate it to any other class then bring back to correct class to pick up
the change that has been made to that class
2 In the excel sheets any changes to devices is taken care of by Sync ship to class
thats fine but what happens if you change any other pointers such as speed , capacity, delay etc - will the Sync pick up those changes if not can it be made to do so ??
3 In an excersie I am carrying out at the moment all Allied AK's have had 3 refits set up
in 42,43,44 the was to reduce capacity in 41 then gradually increase over the 3 refits. (Large amount of change - by hand) then saved back to Scenario worked fine)
but now I have to look at the ship relation to the new data - do I have to step though each ship using the Editor or can the Excell sheet do it - if not (and this may be outside the scope of the sheets)can this be made to happen would be a real BOON
4 I think this would be impossible but you never kown without asking
In carring out the above task a number of ship class's prior to 420900 (first refit)
had their orginal class number changed to either remove no long needed or to tidy up
the database or to group same type class's together in data base which leads to
How will the spread sheet cope (class to ship association) with class slot number changes - will you have to do by hand or get sheet to to do it...


This may be all Pie in Sky stuff and there are work arounds but very time consuming



now something simple - in doing the above tasks I found that in the ship class section a new column the sorts on nation would be very very helpfull when working on 1 nations ship class's can that be done ??

Cobra Aus


< Message edited by CobraAus -- 8/23/2005 2:40:48 AM >

(in reply to Aawulf)
Post #: 69
RE: WitPExcel editor is ready - 8/23/2005 2:42:24 AM   
treespider


Posts: 9796
Joined: 1/30/2005
From: Edgewater, MD
Status: offline
quote:

now something simple - in doing the above tasks I found that in the ship class section a new column the sorts on nation would be very very helpfull when working on 1 nations ship class's can that be done ??


I reworked China by filtering out every other nation ... at least on the LCU page it works...Its also really handy to sort by Nation then LCUFormationID

_____________________________

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 CobraAus)
Post #: 70
RE: WitPExcel editor is ready - 8/23/2005 2:59:27 AM   
CobraAus


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

I reworked China by filtering out every other nation ... at least on the LCU page it works...Its also really handy to sort by Nation then LCUFormationID

unfortunatly there is no nation filter in ship class sheets

Cobra Aus

(in reply to treespider)
Post #: 71
RE: WitPExcel editor is ready - 8/23/2005 3:32:46 AM   
treespider


Posts: 9796
Joined: 1/30/2005
From: Edgewater, MD
Status: offline
quote:

ORIGINAL: CobraAus

quote:

I reworked China by filtering out every other nation ... at least on the LCU page it works...Its also really handy to sort by Nation then LCUFormationID

unfortunatly there is no nation filter in ship class sheets

Cobra Aus



lol...WELL D*MMIT !!! WHY NOT???...

I haven't messed around with the ships yet...

_____________________________

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 CobraAus)
Post #: 72
RE: WitPExcel editor is ready - 8/24/2005 7:11:53 AM   
CobraAus


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

2 In the excel sheets any changes to devices is taken care of by Sync ship to class
thats fine but what happens if you change any other pointers such as speed , capacity, delay etc - will the Sync pick up those changes if not can it be made to do so ??


Very interesting and I give up I dont know how the sheet can be doing this but
yesterday I changed the speed for all allied AK's in the database (which promted the questions above) I saved the spreadsheet did a sync allied ships to class and did a put
save back to DAT file.
Now I was doing another test this morning on something else and noticed the new speeds I had put into the ship class's were now the ships speed (I had not gone into editor yet which I was going to do later today to step through all the cargo ships to reset the the new speeds)
So obviously the SYNC function is doing more than I thought but I dont know how

Cobra AUs

(in reply to CobraAus)
Post #: 73
RE: WitPExcel editor is ready - 8/24/2005 6:39:26 PM   
dereck


Posts: 2800
Joined: 9/7/2004
From: Romulus, MI
Status: offline
quote:

ORIGINAL: Herrbear

I still assume that you cannot yet edit the PWhex.dat file with your editor yet?

Thanks.


This may be a dumb question but what does the PWhex.dat file do?

_____________________________

PO2 US Navy (1980-1986);
USS Midway CV-41 (1981-1984)
Whidbey Island, WA (1984-1986)
Naval Reserve (1986-1992)

(in reply to Herrbear)
Post #: 74
RE: WitPExcel editor is ready - 8/24/2005 7:53:28 PM   
treespider


Posts: 9796
Joined: 1/30/2005
From: Edgewater, MD
Status: offline 		Its the actual map....the pretty .bmps are just nice covers for the actual structure which is the pwhex.dat.

< Message edited by treespider -- 8/24/2005 8:41:18 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 dereck)
Post #: 75
RE: WitPExcel editor is ready - 8/24/2005 9:36:57 PM   
Aawulf

 

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

ORIGINAL: CobraAus

some major questions

1 Editor One of the biggest time consuming problems with the normal editor is that when you make a change in a ship class 9 (any change) you have to step through all the ships related
to that ship class - relate it to any other class then bring back to correct class to pick up
the change that has been made to that class
2 In the excel sheets any changes to devices is taken care of by Sync ship to class
thats fine but what happens if you change any other pointers such as speed , capacity, delay etc - will the Sync pick up those changes if not can it be made to do so ??
3 In an excersie I am carrying out at the moment all Allied AK's have had 3 refits set up
in 42,43,44 the was to reduce capacity in 41 then gradually increase over the 3 refits. (Large amount of change - by hand) then saved back to Scenario worked fine)
but now I have to look at the ship relation to the new data - do I have to step though each ship using the Editor or can the Excell sheet do it - if not (and this may be outside the scope of the sheets)can this be made to happen would be a real BOON
4 I think this would be impossible but you never kown without asking
In carring out the above task a number of ship class's prior to 420900 (first refit)
had their orginal class number changed to either remove no long needed or to tidy up
the database or to group same type class's together in data base which leads to
How will the spread sheet cope (class to ship association) with class slot number changes - will you have to do by hand or get sheet to to do it...


This may be all Pie in Sky stuff and there are work arounds but very time consuming



now something simple - in doing the above tasks I found that in the ship class section a new column the sorts on nation would be very very helpfull when working on 1 nations ship class's can that be done ??

Cobra Aus


In no particular order:

1. Added new "User Field" (column EJ) to Ship Classes for the user to input the nation if so desired. In that "Nation" isn't a database item and wouldn't be the same for any given slot among the many scenarios, this task would best be handled entering the nation code for each type which would allow sorting and filtering.

2. The Sync should cover all database fields of a ship class.

3. I could enable the Sync feature to adjust the slot number changes by assigning serial numbers to each class that are independent of the class numbers (much like the LCU Sync uses "Formation" to fill the units. The problems in doing this would be that my time is currently very limited for leisure and the size of the editor is already on the excessive side. It is a great idea though and when I have the time I will work on a solution for revision 1.5.

Regards,

Michael Fleshman

(in reply to CobraAus)
Post #: 76
RE: WitPExcel editor is ready - 8/24/2005 9:43:45 PM   
Aawulf

 

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

Now I was doing another test this morning on something else and noticed the new speeds I had put into the ship class's were now the ships speed (I had not gone into editor yet which I was going to do later today to step through all the cargo ships to reset the the new speeds)
So obviously the SYNC function is doing more than I thought but I dont know how

Cobra AUs

It would take a manual for me to detail everything the editor does and I really do not care to write a manual. Shame on me for not documenting everything for you as I should.

Regards,

Michael Fleshman

(in reply to CobraAus)
Post #: 77
RE: WitPExcel editor is ready - 8/24/2005 10:02:39 PM   
Aawulf

 

Posts: 116
Joined: 7/14/2005
Status: offline 		WitPExcel 1.4 (24AUG05)

I just sent to Spooky what is hopefully the last major revision of the editor and I can't imagine having to do a another version unless a game patch requires it.

I was hoping that the mystery fields in the PWHex.dat would have been defined by now, but c'est la vie.

Because the toolbar menu doesn't invade your registry, it has to be created with the button on the Misc sheet every time you reopen the editor.

Tip of the week: When wanting to apply changes to a range of like items, it is sometimes better to use the autofilter and sort a key field by ascending or descending order and when done and before saving changesresort column "A" in ascending order. This enables you to copy and paste ranges that cannot be done with filtering.

Regards,

Michael Fleshman

(in reply to Aawulf)
Post #: 78
RE: WitPExcel editor is ready - 8/25/2005 2:04:27 AM   
treespider


Posts: 9796
Joined: 1/30/2005
From: Edgewater, MD
Status: offline 		What is the "_size" column? What is the "Base Pool=221" column?

_____________________________

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 #: 79
RE: WitPExcel editor is ready - 8/25/2005 4:45:37 AM   
Aawulf

 

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

ORIGINAL: treespider

What is the "_size" column? What is the "Base Pool=221" column?

As best as I can determine from examining it's use in the standard scenarios, it is an additional modifier for the formation. It is my theory that you could create a unit without entering any of the unit elements and the unit would begin the game as a "_size" formation and be reinforced and replaced as whatever the actual Unit Formation is. Typically, I just copy the formations into the _size columns so they match.

Regards,

Michael Fleshman

(in reply to treespider)
Post #: 80
RE: WitPExcel editor is ready - 9/11/2005 2:13:56 AM   
CobraAus


Posts: 2322
Joined: 8/23/2004
From: Geelong Australia
Status: offline 		I have a confusion to clear up when looking in both aircraft and air group sheets
the TYPE numbers (eg in editor 9=transport in spread sheet 8=Transport) seem to be 1 less
in all cases also in airgroup sheet Type numbers (eg in editor 4=Daitai in spreadsheet 3=Daitai) 1 number less in all cases
there must be a coversion reason for this that works just wondering why ??

Cobra Aus

(in reply to Aawulf)
Post #: 81
RE: WitPExcel editor is ready - 9/12/2005 3:53:54 AM   
Aawulf

 

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

ORIGINAL: CobraAus

I have a confusion to clear up when looking in both aircraft and air group sheets
the TYPE numbers (eg in editor 9=transport in spread sheet 8=Transport) seem to be 1 less
in all cases also in airgroup sheet Type numbers (eg in editor 4=Daitai in spreadsheet 3=Daitai) 1 number less in all cases
there must be a coversion reason for this that works just wondering why ??

Cobra Aus


The spreadsheets in WitPExcel use the actual numbers used in the databases, whereas the integrated editor uses modified numbers.

As you discovered, the integrated editor converts those numbers into the database values in the end so the final output is read or saved by either and the game with no problems.

< Message edited by Aawulf -- 9/12/2005 3:56:12 AM >

(in reply to CobraAus)
Post #: 82
RE: WitPExcel editor is ready - 9/16/2005 8:12:28 AM   
treespider


Posts: 9796
Joined: 1/30/2005
From: Edgewater, MD
Status: offline 		Just noticed this...In the CHS scenarios the Akagi is placed into Ship Slot 1. However after I tell the editor to get the ships for that scenario the Akagi is missing? Also I noticed that the date sunk entry seems to have shifted for each ship in the database... I'm not sure what is happening here..


I just read through the entire thread again. I think your fix for the Allied ships has caused the program to exclude Japanese Ship Slot 1. In the Standard Scenario Ship Slot one is blank so it would n't be a problem, However CHS makes use of Ship Slot 1.

< Message edited by treespider -- 9/16/2005 2:28:17 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 #: 83
RE: WitPExcel editor is ready - 9/16/2005 2:51:32 PM   
treespider


Posts: 9796
Joined: 1/30/2005
From: Edgewater, MD
Status: offline 		In playing around with this some more It appears when the Japanese Ship list is PUT (Save) the ship the occupies line 5 in the excel program is being placed into Ship Slot 2. Unfortunately in the editor all of the Airgroups remain pointing to the ship they were on.

So for example if I put Kaga into line 6 it bumps to Slot 3 in the game editor but the air groups still point to slot two.

_____________________________

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 treespider)
Post #: 84
RE: WitPExcel editor is ready - 9/18/2005 2:00:25 AM   
Aawulf

 

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

ORIGINAL: treespider

Just noticed this...In the CHS scenarios the Akagi is placed into Ship Slot 1. However after I tell the editor to get the ships for that scenario the Akagi is missing? Also I noticed that the date sunk entry seems to have shifted for each ship in the database... I'm not sure what is happening here..


I just read through the entire thread again. I think your fix for the Allied ships has caused the program to exclude Japanese Ship Slot 1. In the Standard Scenario Ship Slot one is blank so it would n't be a problem, However CHS makes use of Ship Slot 1.

Jap ships' slot #1
It has always excluded Jap ship slot #1. I didn't include that slot because the designers didn't use it and my best guess was that they knew better than me. The first column should reflect this by starting with a "2" at cell A5 for the Kaga. I will likely add Jap Ship slot #1 in the next revision since it appears that it can be done without problems.

If you played PacWar, then you might remember that the first ship slot was buggy. Recalling that played some part in influencing my decision to follow the designers' lead and not use that first slot.

Air Groups
Air groups shouldn't be negatively affected by the absence of slot #1 at all. Ship slots are not shifted, so there is no opportunity for mismatching.

Date Sunk
These could very well be off. In all honesty, I have never even looked at the data for this field to verify it was correct. I think I have it on my "to do" list somewhere between evaluating the tint of the column header highlights and redoing the formula page to be more visually pleasing.

Allied Ships' Nationality
Fixing tonight. BIG OOPS. Thank you treespider.

HQ Planning
Adding the field.

< Message edited by Aawulf -- 9/18/2005 2:59:38 AM >

(in reply to treespider)
Post #: 85
RE: WitPExcel editor is ready - 10/4/2005 9:47:06 PM   
Aawulf

 

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

Could you explain to me how to synchronize. As I am using Excel 2000 maybe there is option that I am not seeing? And btw, thanks for creating such a useful tool...

Thanks

On the "Misc" sheet is a button to create a toolbar menu called "Create Menu". Click this button each time you open the editor because it is by intent that I made the toolbar menu temporary rather than resident. From the new toolbar menu, you can do everything including synchronizing your ships to your ship classes, your LCU's to your formation types, your air groups to your aircraft and your bases to the PWHex editor sheet. This synchronizing feature is a powerful time saver, but not as useful to the modder who seeks to be certain that all of the details are precisely accurate to history and without any abstraction (which is an impossible goal because, among many reasons, the devices are in themselves an abstraction).

(in reply to Aawulf)
Post #: 86
How to sort leaders in WitPExcel - 10/5/2005 12:59:25 AM   
Aawulf

 

Posts: 116
Joined: 7/14/2005
Status: offline 		Objective:
To keep the leaders as they are already assigned in a scenerio, but still want to be able to quickly see who is assigned where and to verify that you don't have leaders with multiple assignments.

Obstacle:
In many scenerios, the leaders are not thoroughly sorted by nationality or even by for which side they fight. Because of the size of the data files, the choice to spend less time loading and saving and the goal of keeping the data managable, the original data files are read and written to in piecemeal according to which data the user is editing.

In hindsight, I should created two sheets for Leaders; one for the Allies and one for the Japs. At the time, I chose not to because I wanted to leave the flexibility to the user to decide how many slots to allocate to either side.

In order for the "Find Leaders" feature to work, the leaders have to be sorted by side, with the Japs using the 1-7145 slots and the Allies using the 7146-19999 slots. It is easy enough to just sort the leaders ina scenerio by Nationality to achieve this mix, but any sorting of the leaders alters their assignments as those are determined on the HQ, TF, LCU, Ship and Air Group sheets.

Solution:
For those who have no aspirations about manipulating the minute details of the assignments of the 19999 leaders', there is a solution where one can maintain the leaders' assignments while still being able to make use of the "Find Leaders" feature found in WitPExcel.

1. On the Leader sheet, paste the values 1-19999 on the unused blue column "T" (cells T5:T20003) on the far right of the sheet, starting on row 5 (Leader Slot #1). These cells should mirror column "A" when you do this. DO NOT use a reference formula to achieve this; either copy and paste the values or use the series function of Excel.

2. Pick an unused column on the HQ sheet such as an unused "User Field" or even the blue column "AC" and type into the first slot cell (row 5) =VLOOKUP(N5,Leaders!$T$5:$U$20003,20)

I entered =VLOOKUP(N5,Leaders!$T$5:$U$20003,20) in cell "W5".

3. Copy the cell with the formula you just entered and paste it to all of the slots in that column.

I pasted it to "W6:W219".

4. Repeat steps #2 and #3 for each of the following sheets, using the corresponding formulae in the row 5 cells for pasting down:


  • TF =VLOOKUP(M5,Leaders!$T$5:$U$20003,20)
  • Jap LCUs =VLOOKUP(o5,Leaders!$T$5:$U$20003,20)
  • Ally LCUs =VLOOKUP(o5,Leaders!$T$5:$U$20003,20)
  • Jap Air Grps =VLOOKUP(E5,Leaders!$T$5:$U$20003,20)
  • Ally Air Grps =VLOOKUP(E5,Leaders!$T$5:$U$20003,20)
  • Jap Ships =VLOOKUP(N5,Leaders!$T$5:$U$20003,20)
  • Ally Ships =VLOOKUP(N5,Leaders!$T$5:$U$20003,20)


5. Go to cell "U5" on the Leaders sheet and unhide that column. Do this exact same to this column as you to it's neighboring column "T" in step #1.

6. Sort the leaders (Leaders!$b$5:$T$20003) to your heart's content.

7. Select Leaders!$T$5:$U$20003 and sort that selection by the "T" column, ascending.

9. On each of the above sheets copy and paste the values from the columns where you entered the formulae to the respective columns where the leaders are assigned. Be sure to paste them as values and not formulae.

10. Repeat steps #1 and #5 (no need to unhide the column now) so that you can sort more later and only have to do steps #6-#9 to retain your ongoing leaders assignments.

*This should work. I must admit that I haven't tested it as yet. If any Excel guru's see a flaw in my logic or if it fails in practice, then please let me know on this forum. Since I am only able to grab a few minutes a day for leisure, I only come to the forums every few days.

---OR---


I will include an optional macro button that resets the leader assignments after sorting in the next revision and you could wait it out until then.

(in reply to Aawulf)
Post #: 87
RE: WitPExcel editor is ready - 10/6/2005 11:05:28 AM   
George Patton


Posts: 1238
Joined: 7/12/2005
From: Lugano, Switzerland
Status: offline 		I would be pleased to see it.
Please send it to: patton1968@libero.it

(in reply to Aawulf)
Post #: 88
RE: WitPExcel editor is ready - 10/15/2005 2:36:49 AM   
el cid again

 

Posts: 16922
Joined: 10/10/2005
Status: offline 		Please send to

trevethans@aol.com

I have a comprehensive set of Japanese databases for ships, planes and vehciles in Excel if you are interested.



(in reply to Aawulf)
Post #: 89
Page:   <<   < prev  1 2 [3]
All Forums >> [Current Games From Matrix.] >> [World War II] >> War In The Pacific - Struggle Against Japan 1941 - 1945 >> Scenario Design >> RE: WitPExcel editor is ready Page: <<   < prev  1 2 [3]
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

1.892