|
Post by Michael Miller on Oct 10, 2014 2:49:31 GMT
As you note in your message of 27 September Tony, we will need some mechanism in the land spreadsheet to add new tabs representing either reinforcements or ad hoc battlegroups.
And if I was really lazy, some links from the "Commands" tab back to the detail tab for each unit would be helpful.
Neither of these issues seems to be critical to start, but we need to address them soon afterward.
|
|
|
Post by tim on Oct 10, 2014 5:02:30 GMT
As you note in your message of 27 September Tony, we will need some mechanism in the land spreadsheet to add new tabs representing either reinforcements or ad hoc battlegroups. And if I was really lazy, some links from the "Commands" tab back to the detail tab for each unit would be helpful. Neither of these issues seems to be critical to start, but we need to address them soon afterward. One can't use the built in Copy Tab function? As an aside, for the Axis Admin totals to work, added tabs need to be entered before the last tab (MeGar).
|
|
|
Post by tim on Oct 10, 2014 6:00:06 GMT
Supply and Admin worksheet - on the Truck Convoy tab the cargo capacity of Heavy Trucks are off in two columns. For Ammo and Water, Heavy Truck capacity and utilization are calculated using the Medium Truck capacity. Ammo should be 8, not 4, and Water 200 not 100. I spot-checked the other truck type rows and supply type columns and they seem to be working fine. Note: This is a low priority item. There is no impact on fuel cost calcs or anything other than the # of needed trucks for a given amount of supplies. Attachments:Axis Supply Admin.xlsx (97.29 KB)
|
|
|
Post by Michael Miller on Oct 11, 2014 4:26:46 GMT
I went through the process of adding a tab to the land forces workbook, with the following results and observations: - You need to do a "Move or Copy...", rather than an "Insert..." Creating a Copy is required to transfer all the hidden machinery that Tony has built.
- As Tim noted, "For the Axis Admin totals to work, added tabs need to be entered before the last tab (MeGar)." Such exclusion from the logistics summarization info might in fact be useful under some circumstances, e.g., to allow reference to units arriving soon.
- One annoying side effect of copying to create a new tab is that the displayed counter image is copied as well, leaving a duplicate/wrong image, with no apparent ability to edit.
- A minor bug noted in the process: My example used an artillery unit, type 'kk'. This has max TOE of 12 overall, but with two different equipment types assigned ('a6' and 'aa1'), the table shows each with max TOE of 12, rather than 12 for the entire unit. Maybe there's a way around this, but the same glitch is seen in at least two of the initially deployed units.
|
|
|
Post by Michael Miller on Oct 24, 2014 19:38:57 GMT
Non-critical issues noted here for routine fixes as time allows.
1. Tobruk garrison shows the 30th GaF counter image, which should be at Bardia. Should be perhaps 31st or 32nd GaF. 2. Bardia garrison shows V CD Arty unit instead of 30th GaF.
|
|
|
Post by Michael Miller on Oct 24, 2014 19:40:05 GMT
I just ran across an apparently serious issue: Heavy Trucks seem to have the same infantry motorization capacity as Mediums.
|
|
|
Post by Michael Miller on Oct 27, 2014 0:37:39 GMT
I have noticed, later than I would have liked, that the Axis Air Force spreadsheet has some inaccurate carrying capacities for the 1st Line Trucks, as follows:
Ammo – All truck types show capacity of 2, (should be 2L, 4M, 8H). Fuel – All values correct (50L, 120M, 250H) Stores – All values correct (6L, 15M, 30H) Water – Light correct, Medium shows 40, Heavy shows 100 (should be 40L, 100M, 200H)
Spreadsheet sent via email. Also note Tim's post of Oct. 10 regarding truck capacity issues in the Logistics sheets.
|
|
|
Post by ATD on Oct 27, 2014 16:06:03 GMT
All done!
|
|
|
Post by Slothtoo on Nov 30, 2014 1:17:13 GMT
The TEC on the shared tables has a mistake in it. Road CPA cost is 1/2 for motorised units and 1/2 for Breakdown.
|
|
|
Post by Michael Miller on Dec 1, 2014 1:02:05 GMT
Confirmed on the Road Motorized CPA cost and breakdown points accumulated should be ½. Good catch.
|
|