Monbvol,
Having built an spreadsheet for advanced units (sorry it's an internal CGL dev resource right now) I've got great respect for what you've done. Keep up the good work.
Couple of questions/issues:
Note- maybe I'm just missing something obvious on some of these. If so, thanks for the pointers.
Module 3 to 10 have blank pull downs: If you go to data validation and fix the cell range to not include the blank cells at the end, this fixes the problem.
Fields have a blank pull down: Same fix as above
F100- Age adjustment confusing: Only after I read this thread did I see the note that this is a variable XP field and not the age adjustment over/under 21. Might help to make the comment more clear.
Module Age: Stage 2 covers late childhood, which is ages 11 to 16. Cell H3 says the age is ten.
Using the Modules, especially for older characters: Trying to make a 47 year old character who was a lifer military. If I put in Military Basic, Military Advanced and then Tour of Duty for the rest, I only get a 37 year old. Any suggestions?
Fields: Not sure how to use these in relation to character generation. Disclaimer, been a long time since I worked on AToW and that section I only reviewed, so I may just be missing something obvious. Even us writers can't know all the rules.
Thanks,
Welshman