The issues w2ith Adept Powers not showing up is do to the fact that the Adept Powers Drop Down is not linked to the Valid Data where as Complex forms and other lists are
To fix this for myself I used the drop down next to the formula bar to go to Table 10 which is the adept power list, I then added a new Table name for that selection in the same drop down area by tying in the field and set it as AdeptPowerList
Then back on the Magic-resonance page I selected fields B5 - B20. I selected the Data tab above, and then Data Validation, Data Validation.
Change Allow to: List
Change Source to =AdeptPowerList
This then let me select the drop down powers.
The formulas are already there. As for the Levels Bought I am putting those in manually and letting the sheet do the math as designed.