Just like any other software program the degree and scope of validation or qualification depends entirely on the risk or possibility that the application can affect product quality, efficacy or records.
Regulators expect you to be able to demonstrate that your spreadsheets are functioning correctly and consistently produce accurate data.
You don't need to worry about whatever the Data box shows, as that's disabled with the Custom option.
If you cannot show with documented test evidence that this is the case, then your regulators or auditors can stop you using your spreadsheets or worse still stop your operations until the situation is resolved.
Validation Online offer a complete suite of spreadsheet validation documents, from the Validation Plan (VP) to the User Requirements Specification (URS) to the Validation Risk Assessment (VRA) and culminating in a combined Installation / Qualification / Performance Qualification (CSQ) protocol.
The same debaters might suggest that Excel will round up calculations, and has limitations as to its mathematical abilities. However it is very much up to the spreadsheet designer (and reviewer) to ensure that if number rounding is allowed; it does not meaningfully affect the accuracy of the spreadsheet calculations.
Similarly the same persons must validate that the formula calculation is within the capabilities of the Excel software design.
Then use our spreadsheet validation qualification pack to validate them. On one audit, where the client stated they had four critical spreadsheets to be validated, their network was searched and 212 spreadsheets were found.
One spreadsheet had 62 versions, all of which were active.
We have just launched our brand new SOP for Spreadsheet Creation to cover these and other known target points that the regulators consistently hone into as soon as they find that spreadsheets are being used.
Use this Spreadsheet Creation SOP to ensure that you create spreadsheets that are validatable. (Issue-1) -- 5.00 Spread sheets are a potential source for the classical disaster. Erroneous quality and efficacy statistics are produced and sometimes even stock levels are totally incorrect.
The standard operating system used throughout industry for spreadsheet applications is Excel.