>>83737
> the steps of character creation along two possible paths
The simplest is just to have 2 generators and reuse raw data.
> Nationality -> Ability Scores -> Archetype -> Life Path
If you want to select from fixed list, a form with proper drop list is required, one way or another.
If any lesser equivalent (enter number of an option in the list above, mark an option in the separate column next to it, manual pseudo- dropdown of all constant values in this column on the current sheet) will do, just a table will suffice.
> Ability Scores would check if there's no value >8 or the sum of the rolls is <60. If either or both is true, the user can reroll if they wish
> outcomes and warnings to tell the user they're allowed to reroll if they're making a PC or a Major NPC using the rules for making PCs.
=IF( AND (OR( [herp1] >8, [derp1] >8, etc etc...), SUM( [first herp:last derp] )>=60), "Looks good enough"&T(STYLE("Good")), "Uh, maybe reroll this?"&T(STYLE("Bad")) )
...or if you want to do it the ''cool'' way:
=IF( AND (SUMIF( [first herp:last derp], ">8")>0, SUM( [first herp:last derp] )>=60), "Looks good enough"&T(STYLE("Good")), "Uh, maybe reroll this?"&T(STYLE("Bad")) )
If you use this kind of prompts for pass/reroll anyway, you don’t really need to actually automate the same decision, only indicate whether other criteria are met or not.
Once you gathered and processed all data you want, may as well make clean blocks of end results in a nice charsheet format on another sheet, ready to be copy-pasted elsewhere.
> While adjusting Attribute Levels and Skill Levels, the user would be able to judge how well they'd be able to pilot various units.
Once you have conditions worked out, may just as well place the result next to inputs.
Of course, it sounds like a sPost too long. Click here to view the full text.