I came across an Excel form that had some interesting functionality behind it: Expert Review Checkpoints
What is the basic approach to how this is accomplished in Excel? Some discrete features in it that I wasn't sure how to accomplish are:
- "Locking" all but some cells so that they could not be edited
- Restricting input to specified acceptable values
- Determining when a tab has been completed and making a calculation (on the "results" tab) only after it has been completed
- Determining how many cells in a given column have been filled in
- Making a calculation across tabs
- Generating a multi-axis chart on the "results" tab from the calculations