Microsoft Excel applications must be compatible with:
- Microsoft Windows 10
- Microsoft Office 365 - Contact SQA to discuss testing and support for previous Office version (e.g. Office 2016, etc.)
Spreadsheet applications must meet applicable EPRI product requirements (e.g., EPRI corporate, software documentation, test cases, etc.).
Additional requirements:
- The "About" worksheet of the spreadsheet needs to include:
- EPRI logo
- Software name, version, and EPRI product ID #
- EPRI copyright
- Ordering information
- Disclaimer notice (see EPRI Notice of Copyright, Availability of Subject Matter and Disclaimer for EPRI Software (105 KB))
- If a preproduction spreadsheet application, the Preproduction Software Acceptance Splash Screen worksheet must be the first worksheet opened.
- A separate worksheet(s) provides test cases (or tutorial) covering the main functions of the spreadsheet. This worksheet is not required if this information is provided in a software manual.
- Lock cells containing formulas or instructions to prevent accidental changes to the intended calculation.
- Range checking must be implemented on all input fields to verify that user input meets the expected input criteria. Error messages for rejected input must assist the user in making an appropriate entry.