Yellow fields are for user input. Starting data illustrate how scores are calculated. Overwrite them with real organization data.
Light purple fields are auto-calculated based on the content of yellow fields.
White fields are used for instructions, explanations, or labels for adjacent fields.
Light-blue fields with a "?" have explanations for adjacent fields. Mouse-over the "?" to reveal the guidance.
This online version was created using SpreadsheetConverter (SSC) from a special SSC-ready version of the BSAT Excel workbook. Its master copy is hosted in the SSC cloud. When you access it and use it, you actually work with a copy of it in your browser, not with the master copy in the SSC cloud. All your input and changes are stored in your browser, magically and automatically. You may need help from colleagues with answers to some questions. That collaboration can be accomplished several ways:
- Email: Send screen captures or copies of the questions with which you need help to your appropriate colleagues, with guidance on where you would like their help. Then, consolidate their replies into your master copy.
- Zoom: Share your master copy of this workbook on your screen in a Zoom call with your colleagues and update it with them, live. Or, do separate 1-on-1 calls with them, focusing on the areas where you need their help.
- Meet with them: COVID-19 protocols permitting, this approach still works, too.☺
- Online collaboration: If you want to share this SSC-created online versin of BSAT with colleagues, you need to create a unique version of the tool in the SSC cloud. Then, you and your colleagues can access it and yourcombined changes are automatically stored in your shared unique version. Think of it as an SSC version of Google Sheets. Instructions on how to create and share a unique copy of this online tool are available at the SSC link, below. The referenced "Real-time Sync" has already been activated, as indicated by the Real-time Sync button in the right-hand corner of the toolbar at the bottom of all screens.