rmmwilg
Posts: 228
Joined: 5/2/2018 Status: offline
|
Hey all, I've decided to catalogue *nearly* all the scenarios and CG's that have been posted herein as well as the originals included in the games. This spreadsheet differs from Paullus' list at the front in that I've listed the numbers of (half-)squads, AFV's, Ordinance, OBA, Reinforcements and game turns involved and then created a complexity/difficulty of play rating from those stats. I have no doubt there'll be debate about the colour-coding and ratings I gave, but consider it more of a guide than gospel! I've also included the LOS for each one, since that has such a bearing at the moment on playability. Both tabs (scenarios and CG's) are filtered, so that one can re-sort the list by complexity, name, designer, etc., etc., and yes, I made separate tabs for actual scenarios v's CG's. Turns out there are actually 16 CG's out there, not just the official 5 in the games! So why *nearly* all? In some cases there are numerous iterations or versions of the same, but I have kept the same multiple versions of the scenario when there were different designers. To the right of each worksheet list is the colour-coding used. It's the same for both scenarios and CG's. Again, one may disagree, but since I built it, I got to define it ! Also, you'll see where the AI was listed as preferred for a particular side, plus the couple of scenarios that are only playable as one side (ie. one side is locked to the AI). Plus, where you see a '(P)', that means pre-setup; ie. all of that side's units are already setup as opposed to your being able to setup yourself. Finally I've posted it as a Dropbox link, since the Hailstone manufacturing plant in particular continues to produce, and I'll do my best to update accordingly! NB: I have changed some of the original scenario names, particularly if the designer's name was in it, since I have made a separate column for that instead, the same for TotH numbers for the same reason. So if you can't, initially find the title, either do a word search or look for the first word of the actual scenario title. Ok, so turns out a Dropbox addendum is necessary: It's not xferring certain Excel functions such as frozen columns and rows, nor the sorting/filtering that is such a key feature If you want the fully functioning spreadsheet, particularly so that you can sort/filter by complexity, you'll need to download the file. Then it will have all the features. Also, the numbering system for complexity is a sum of the cell colours to the left of that column (ie. not incl. the LOS), and the colours are defined as: - Green = 0 - Yellow = 1 - Light red = 2 - Dark red = 3 - Black w/red digits = 4 In general, I found that if the complexity rating gets into double digits, you're getting into longer playing times (ie. more than one sitting) and/or the game may struggle to manage. https://www.dropbox.com/s/jf1gv2trgqsecz2/Scenario%20List.xlsx?dl=0
< Message edited by rmmwilg -- 5/16/2020 5:36:03 PM >
|