# Spreadsheet Assessment

Version 1.0 | CSVtoCSA practitioner template | Updated 12 September 2026

## Purpose

Assess the GxP use, formulas, data, protection, independent verification, change control, and periodic review of a spreadsheet.

## When to use

For new, changed, inventoried, or periodically reviewed spreadsheets used in regulated work.

## Instructions

- Define the specific system, service, change, population, and intended use.
- Complete each field from available records and accountable interviews; record unknowns rather than guessing.
- Link conclusions to affected GxP functions, failure scenarios, controls, evidence, and approval.
- Adapt the structure to the organization’s approved procedures and document-control process.

## Blank template

1. Workbook and owner

   Response: 

2. Intended use

   Response: 

3. GxP record or decision

   Response: 

4. Inputs and sources

   Response: 

5. Calculations and rules

   Response: 

6. Outputs and acceptance limits

   Response: 

7. Formula and input protection

   Response: 

8. Access and version control

   Response: 

9. Independent verification

   Response: 

10. Boundary and error testing

   Response: 

11. Change control and incidents

   Response: 

12. Conclusion and periodic review

   Response: 

## Completed fictional example

The example below is teaching material, not an executed or approved validation record.

1. Workbook and owner

   Fictional Product Acceptance Calculator; Quality Control

2. Intended use

   Calculate a finished-product result for batch review

3. GxP record or decision

   Result supports batch disposition

4. Inputs and sources

   Three approved laboratory values and product range

5. Calculations and rules

   Weighted calculation with final-step rounding

6. Outputs and acceptance limits

   Pass or fail with retained full-precision result

7. Formula and input protection

   Locked formula and lookup cells; controlled input ranges

8. Access and version control

   Approved read-only template location with edit-owner restriction

9. Independent verification

   Second analyst calculation for each release result

10. Boundary and error testing

   Known-answer, below/at/above limit, blank, invalid, unit, and precision cases

11. Change control and incidents

   Formula, range, unit, platform, or protection changes require assessment

12. Conclusion and periodic review

   Released after rounding correction; annual or event-driven review

## Use and limitations

Adapt this template to the applicable regulation, approved validation procedure, document-control process, risk method, and approval roles. CSVtoCSA does not present this template as a universally required validation record.