I have created a Sheet which imports data from exported Ground Elements CSV and Device CSV and SUMs them together to generate an Ammo Use (AU) for modified/new
Squads. So it is only intended for "normal" Squads, so it is not designed to work with Artillery, Tanks and other larger calibers.
I hope I cought all Rifles, SA-Rifles, SMGs and LMGs (Columns AB-AE), if somone finds some missing, let me know!
Same goes for other arms I may have overlooked.
Access to the Sheet (it is
read only access) - so you need to download/copy it for yourself.
- You can tweak the amount of "weight" each weapon type/category "consumes"/requests in Ammo in Line 2.
- You can Filter for Countries in Cell C3.
- You can Filter for Types in Cell D3.
- You can add Ground Element Types to be searched for in Cell A10.
- You can read final "correct" AUs in Couumns X and Z(rounded up).
Note: If you decide to import a new CSV sheet of a new game version you may need to delete the old sheet, if you then add a new sheet and name it exactly the same the automation may not be able to recognize it. If this happens you need to go into each Cell of an row once (so cells which contain automation) and "Enter" the content for it to recognize the new Sheet. Then draw the formulas into the cells below.
