Army Builder - Autocomplete or manual fields?

Started by Plantagenet, September 08, 2020, 04:00:17 PM

Previous topic - Next topic

Plantagenet

Just want to check I'm not doing something wrong here.  Not sure if there is a document version of instructions / explanation about using the army builder (I know there's a video but it's not easy stabbing around on the play progress bar trying to find the part that might cover it) but when you fill in the spreadsheet in Libre Office, should the UG section under the MeG logo populate automatically as you add TUG lines or is that manual?  When I click the cell it shows '=N71' but I'm not sure after filling in which cell exactly on a TUG line that it should pick up the added one and bump it up to 9 from the default 8.  Now matter how many lines I add, even if I get up to 14 TUGs it still says 8 and 3 so I'm starting to wonder if it's self populating field at all?

Just thought I'd check before I sling this bloody Mac Book up the wall.  I'll be glad when this laptop dies so I can go back to Windows and software that works properly.

ShrubMiK

Are you filling in the "UG No" column sensibly? Each TuG row should have a separate number (except where you are representing different troop types in the the same UG); each SuG row should have a different number.

Plantagenet

#2
I'm filling in the left most UG column with a number, just as is used in the sheet when I open it from fresh, it seemed the most 'sensible', dare I say blatantly obvious way to fill it in.  As an aside, if I fill in 9, 10, 11 & 12 in the column below it does correctly calculate the TUGs to break in red, The UGs under the Meg Logo don't change though.  I'm using the latest version downloaded from the MeG site.

Plantagenet

Sorted it.  I just downloaded another 'clean' version of the sheet from the site.  Same problem.  I found that entering the password then re-entering =N71 in the problem cell fixed at, as it did for the cell below it.