Mark Fisher’s Organizational Spreadsheets

German Charts

Russian Charts

Example of organizational spreadsheet in use.

Spreadsheet Explanation

These spreadsheets are meant to replace all the off-map Army and Strategic Charts used in CAC. In addition, players can keep track of individual unit SP losses for all units on the spreadsheet (which reduces counter density on the game map).

Three spreadsheets are presented as PDF files. The first contains two pages and is for the German player. The second contains three pages and is for the Russian player. The third file contains an example of how the attachment table will look when filled out during the game.

The first table on the first page of each nation's spreadsheet is the "command table" (labeled "German Command" or "Russian Command"). This table is used to identify formation attachments, record mission orders, track air and balloon unit attachments (and use) and record ammunition use. The idea is that each Corps/Divisional HQ with an attachment limit goes in a line of this table underneath the Army HQ to which it is attached. The formations that are attached to the HQ are then identified in the second column. The pdf called "example" shows how the German and Russian command tables might be filled out during a game.

Below the command tables on the first page are a number of small tables that track replacements, RR points, Victory Points, army mission requirements, fortress units and detachments. (The Russian detachment table is actually at the end of the third page.)

The second page for the German player and the second and third pages for the Russian player are the "formation tables" (labeled German Formations and Russian Formations). Each primary formation (i.e., each set of units with a single morale level) is identified on a line of this table. The table also allows one to track SP losses. I have put the formations for each army roughly in the following order: HQs, cavalry formations, 1st line inf div, 2nd line inf div, 3rd line inf div, bds and misc. units. Morale is tracked in the third column and the SPs of the formation's units are tracked in 4th through 6th columns, as appropriate. The charts also contain information about a unit's barrage strength, MG factors etc. to facilitate calculating attack and defense strengths in combat. The last column of the chart is labeled HHB for Headquarters Holding Box (HQHB). The intention is that when units are in the HQHB of a corps HQ, this fact can be noted here. (It can be noted on the corps HQ's line itself, the individual unit's line or both -- in practice, it is usually pretty obvious which units are in each HQHB because all of the unit counters that are in HQHBs are stacked next to the map.) One small point, there are one or two instances where two units in the game are identical (i.e. two cavalry or artillery units have exactly the same counters), for these units it may be necessary to track SP losses on the counter or otherwise note which unit is which on the table.

Spreadsheets - Excel File Version

The spreadsheets offered in PDF form are duplicated here in an Excel File. It was noticed that the PDFs make some of the gridlines look a little thicker so, for those with Excel, I would recommend printing out this file.