A Competitive GW (Solo) Scenario by the Numbers.

[rkr1958]

Turn 18. July/August 1942. Allied #9. Med Theater.

Italian Coast.

09-AL-Med-It-Coast-NC-1-CL.png (26.47 KiB) Viewed 199 times

09-AL-Med-It-Coast-NC-1.png (194.01 KiB) Viewed 199 times

09-AL-Med-It-Coast-NC-1b.png (100.47 KiB) Viewed 199 times

09-AL-Med-It-Coast-NC-1c.png (354.2 KiB) Viewed 199 times

[rkr1958]

Turn 18. July/August 1942. Allied #9. Pacific Theater.

China Sea. Round 1 (1/2).

09-AL-Pacific-China-Sea-NC-1-CL.png (23.34 KiB) Viewed 193 times

09-AL-Pacific-China-Sea-NC-1.png (200.44 KiB) Viewed 193 times

09-AL-Pacific-China-Sea-NC-1b.png (133.29 KiB) Viewed 193 times

09-AL-Pacific-China-Sea-NC-1c.png (180.34 KiB) Viewed 193 times

[rkr1958]

Turn 18. July/August 1942. Allied #9. Pacific Theater.

China Sea. Round 1 (2/2).

09-AL-Pacific-China-Sea-NC-1e.png (163.67 KiB) Viewed 192 times

09-AL-Pacific-China-Sea-NC-1d.png (216.95 KiB) Viewed 192 times

China Sea. Round 2.

09-AL-Pacific-China-Sea-NC-2-CL.png (8.47 KiB) Viewed 192 times

09-AL-Pacific-China-Sea-NC-2b.png (126.14 KiB) Viewed 192 times

[rkr1958]

Turn 18. July/August 1942. Allied #9. Pacific Theater.

South China Sea. Round 1.

09-AL-Pacific-South-China-Sea-NC-1-CL.png (8.93 KiB) Viewed 192 times

09-AL-Pacific-South-China-Sea-NC-1.png (277 KiB) Viewed 192 times

09-AL-Pacific-South-China-Sea-NC-1b.png (122.55 KiB) Viewed 192 times

[rkr1958]

Turn 18. July/August 1942. Allied #9. Eastern Front.

Baltic Sea.

09-AL-Eastern-Baltic-NC-1-CL.png (17.8 KiB) Viewed 192 times

Naval Air.

09-AL-Eastern-RAF-NavAir-Baltic.png (118.42 KiB) Viewed 192 times

Naval Search.

09-AL-Eastern-Baltic-NC-1.png (269.04 KiB) Viewed 192 times

09-AL-Eastern-Baltic-NC-1b.png (103.25 KiB) Viewed 192 times

[rkr1958]

Turn 18. July/August 1942. Allied #9. Med Theater.

Strategic Bombing. Rome, Italy.

09-AL-Med-STRAT-Rome-CL.png (22.17 KiB) Viewed 190 times

09-AL-Med-STRAT-Rome.png (254.17 KiB) Viewed 190 times

[rkr1958]

Turn 18. July/August 1942. Allied #9. Med Theater.

Western Allied. Land Moves.
Combat Logs.

09-AL-Med-LM-CL.png (84.07 KiB) Viewed 178 times

Overrun (Italian Supply Unit).

09-AL-Med-Overrun-Supply-Unit.png (166 KiB) Viewed 178 times

Land Commands.

09-AL-Med-CMDs.png (76.87 KiB) Viewed 178 times

Map.

09-AL-Med-LM-Map.png (1.21 MiB) Viewed 178 times

[rkr1958]

Turn 18. July/August 1942. Allied #9. Med Theater.

Land Combat. Tripoli, Libya.

09-AL-Med-LC-Tripoli-CL.png (15.51 KiB) Viewed 178 times

09-AL-Med-LC-CRT-Tripoli.png (169.24 KiB) Viewed 178 times

09-AL-Med-LC-Tripoli.png (217.87 KiB) Viewed 178 times

09-AL-Med-LC-Map.png (344.07 KiB) Viewed 178 times

[rkr1958]

Turn 18. July/August 1942. Allied #9. Pacific Theater.

RAF Air Rebase.

09-AL-Pacific-Air-Rebase-CL.png (6.28 KiB) Viewed 176 times

09-AL-Pacific-Air-Rebase.png (1.81 MiB) Viewed 176 times

[rkr1958]

Turn 18. July/August 1942. Allied #9. East Africa.

09-AL-East-Africa-CL.png (19.31 KiB) Viewed 175 times

09-AL-East-Africa-LND-CMD.png (17.88 KiB) Viewed 175 times

09-AL-East-Africa.png (1.81 MiB) Viewed 175 times

[rkr1958]

Turn 18. July/August 1942. Allied #9. Asian Theater.

China.

09-AL-Asian-CCP-CL.png (17.92 KiB) Viewed 175 times

09-AL-Asian-CCP-LND.png (20.47 KiB) Viewed 175 times

09-AL-Asian-CCP.png (1.56 MiB) Viewed 175 times

[rkr1958]

Turn 18. July/August 1942. Allied #9. Eastern Front.

Combat Logs.

09-AL-Eastern-Front-CL.png (38.83 KiB) Viewed 173 times

Northern Front. Land Command.

09-AL-Eastern-North-Front-LND.png (35.49 KiB) Viewed 173 times

Southern Front. Land Command.

09-AL-Eastern-Southern-Front-LND.png (43.42 KiB) Viewed 173 times

Map.

09-AL-Eastern-Front.png (1.84 MiB) Viewed 173 times

[rkr1958]

Turn 18. July/August 1942. Allied #9. Asian Theater.

Soviet Asia.
Combat Logs.

09-AL-Asian-Soviet-CL.png (45.05 KiB) Viewed 173 times

Factory Rail.

09-AL-Eastern-Rail-Krusk-Blue-Factory.png (960.43 KiB) Viewed 173 times

Transfer Deport.

09-AL-Asian-Soviet-Transfer-Depot.png (26.59 KiB) Viewed 173 times

Map.

09-AL-Asian-Soviet.png (1.74 MiB) Viewed 173 times

[rkr1958]

Turn 18. July/August 1942. Allied #9. Soviet Sep/Oct Badly Needed Reinforcements.[/u]

09-AL-Soviet-SO-Reinforcements.png (102.61 KiB) Viewed 173 times

[rkr1958]

Turn 18. July/August 1942. End of Turn.

Turn Ends.

99-Partisans-CL.png (42.37 KiB) Viewed 162 times

Partisans.

99-Partisans.png (56.44 KiB) Viewed 162 times

Soviet-Japanese Neutrality Pact.

99-Asian-Soviet-Asian-Pact.png (28.41 KiB) Viewed 162 times

Weather & Actions Summary.

99-Weather-Actions.png (45.19 KiB) Viewed 162 times

[Falken]

Hi Ronnie,

Been getting the itch to go back in to MWIF. Two quick questions. I got your Excel spreadsheet (AAR Template) a while ago, and it was Release 11. Is that still the latest?

Second, and because you have played so many different versions, should I use v8 (non-beta), or stick to 3.2?
I would like to use v8, but i'm not good at editing the game files, and worried about the eventual slow-down.

Thanks Ronnie. Even though i haven't played in a while, still read your AARs.
Dave...

[rkr1958]

Hi Ronnie,

Been getting the itch to go back in to MWIF. Two quick questions. I got your Excel spreadsheet (AAR Template) a while ago, and it was Release 11. Is that still the latest?

Second, and because you have played so many different versions, should I use v8 (non-beta), or stick to 3.2?
I would like to use v8, but i'm not good at editing the game files, and worried about the eventual slow-down.

Thanks Ronnie. Even though i haven't played in a while, still read your AARs.
Dave...

Hey Falken good to hear from you.

Have time now for a brief response. If interested will provide a more detailed response later when I have the time with my latest spreadsheets attached and flowchart of my current and evolving methodology if you or anyone else is interested.

Release 11 of my AAR template is not the latest. In fact I'm always modifying, refining and "improving". In fact, the way I've configured the spreadsheet is to make it highly customizable through the MK tab on AAR log entries in the CL tab. So, once you have it you may customize it to your taste

Also, note I said spreadsheets. I have a suite of additional and supporting spreadsheets. Magic_EXCEL, Magic_Dust, 2D10_CRT, AP (LC and ground strike attack planning), BOA (for both Atlantic and Pacific) threat and risk analysis. A number of these spreadsheets are feed by csv outputs from my, also ever evolving/improving, Python based MAGIC tool which is exportable in execution form, which means you can run without having to install Python. I tried building into my Magic_Excel through VBA modules the functionality and game file processing that's in my Python MAGIC tool but that was a total bust. Not because I couldn't program the logic in VBA but because of runtime. For example, a csv file that I use for input into Magic_Excel takes less than a second to generate through Python; but took over 900 seconds through VBA and often locked my machine up requiring a reboot. After dealing with that for a week or two, I decided to leave the heavy game file processing to Python (MAGIC). Also, this eliminated the need for any VBA modules in Excel.

In regards to which MWIF version to use; my recommendation is to use the latest official or public beta version. That is, which ever one you're most comfortable with.

Then and only then if the game unbearably slows down retrograde one time to 3.2 and stick with that version untill you finish. You'd need to only made 1 minor game file edit to retrograde. However; the cost would be in latest bug fixes and additional optional rules.

[Falken]

of course interested ... When I play, must use your spreadsheets. Once you start to use them, I can't even imagine playing without them. If you can, and want, I would love a newer version than 11, even if it's not latest. But never feel obliged. They are your spreadsheets, so if you don't want to, no worries whatsoever.

And thanks for the note on the build. I'll start building for v8 (Public), but ensure I have a 3.2 version in case it's needed.

Thanks Ronnie (as always...)

[rkr1958]

of course interested ... When I play, must use your spreadsheets. Once you start to use them, I can't even imagine playing without them. If you can, and want, I would love a newer version than 11, even if it's not latest. But never feel obliged. They are your spreadsheets, so if you don't want to, no worries whatsoever.

And thanks for the note on the build. I'll start building for v8 (Public), but ensure I have a 3.2 version in case it's needed.

Thanks Ronnie (as always...)

Provide as-is & filled-in for current AAR. You'll need to "clean" the various fields for your own use. Be careful not to "clean" out columns that make calculations from other column entries. I know it's confusing; but if you take the time you should be able to figure out how I generate the various reports that I post to my AAR. MAGIC_EXCEL does require counters.csv for sheet 0 & 1, which is generated by MAGIC (Python). Also, MAGIC_EXCEL is linked to MAGIC_DUST, which if you explore you'll see why.

FYI, all attached spreadsheets current as to my last posting.

GW-CF-5.XLS -> AAR spreadsheet
FYI - MK headers have changed/evolved over past entries; so the headers will often not make sense for earlier combat log (CL) entries.

GW-CF-5.zip

(1.96 MiB) Downloaded 3 times

MAGIC_EXCEL-GW-CF-5.XLS

MAGIC_EXCEL-GW-CF-5.zip

(560.19 KiB) Downloaded 4 times

MAGIC_DUST.XLS

MAGIC_DUST.zip

(315.38 KiB) Downloaded 3 times

AP-CF-5.XLS (LC & Ground Strike Attack Planner)

AP-CF-5.zip

(1.25 MiB) Downloaded 5 times

[rkr1958]

2D10_Calculator_v12.XLS

2D10_Calculator_v12.zip

(36.67 KiB) Downloaded 4 times

Sub-Risk-Analaysis-5.XLS

Sub-Risk-Analysis-5.zip

(14.81 KiB) Downloaded 4 times

WARNING - I started this AAR & game back in October 2024; ~20 months ago; and have "evolved" all above spreadsheets over that time. I've just finished turn 18 (i.e., half way through with my game & AAR).

My informal vision is to develop a set of tools, algorithms, even flow-charts that I, or others if interested, could use for "competitive" solitary play. I certainty wouldn't mind sharing this informal vision & potential journey with any other like minded folks that would be willing to "substantially" join such a journey.

I do occasionally enjoy non-solitary play; but to be honest I feel SELF pressure to turn around reactions & my impulse. I wish to be clear that I've never faced this pressure from any opponent that I've played; just from myself. What I enjoy about solitary play is that I can take my time & go down whatever rabbit holes I wish as illustrated by my current game & AAR that's taken 20-months to complete 18 turns. This doesn't mean that I don't or won't play against another person(s) in the future; but currently I'm enjoying slogging through my solitary play. The downside is that I believe, and have experienced, that one can only get better by play against superior opponents & that doesn't happen in solo play.

But; that's why I'm an avid follower of folks (especially AARs) on this forum and over at the WIF section of boardgeeks.

Also, I strongly encourage those following my AAR to chime in when they don't understand something I've done or they feel I've made a daft move/decision. I love those discussions here or anywhere (as long as they're constructive and civil).