Very nice work congrats only one problem the spreadsheet does not have any points for heavy weapon, the drop down box allows you to select it but it does not add in any points for that melee weapon. eg
men at arms HF/ Arm/ sup/ heavy weapon by your spreadsheet 11 points but the army list book it is listed as 13 points
As Heavy weapons are also impact, the point for them are added when you choose them in the impact drop down box.
your men at arm are effectively HF/ Arm/ Sup/ -/ HW/ HW
The font size in a drop down can't be changed. You can write some code to change the zoom when the cell is selected, or put a combo box over it, but it would be easier for the user to zoom in.
I have made three useful changes to the version I use.
* Added a movable text box across the bottom right below the total bases cell (added that too in the bases column) in which I describe the reason for the army structure and order of march, deployment strategy overall and by deployment group, alternative troop mixes, etc. so it's all on one page.
* Copy the total points number to the upper left on the last commander line so I can increase the zoom and get the unit sums off screen but keep the total visible at all times. As I don't have a giant screen this makes the screen more readable.
* In addition to order of march, I have a deployment group column right after that with 1st, 2nd, 3 or 4 to make it easy to see the groups - of course if I manually cut and past to put everything in the right order this is not necessary.
1) Choose your army book in the dropdown menu in the cell "Book name"
2) Write the page number under the cell "Page number" ( page number are found in the index of each army book)
Olivier