BMO Spreadsheet Sign-off Summary Report (Cells (Functions (Function…
BMO Spreadsheet Sign-off Summary Report
New instances of cells that evaluate to an error value such as #N/A, #VALUE!, #DIV/0!
Existing function changed to a different function, e.g. SUMIF replaced by SUM.
Function Argument Changed
At least one argument change.
E.g. VLOOKUP(A1, $D$1:$E$10, 2, TRUE)
to VLOOKUP(A1, $D$1:$E$10, 2, FALSE)
Function To Data
Function replaced with data.
Function deleted and replaced with neither another function nor data.
New function created in an empty cell.
Data To Function
A value replaced by a function.
Change of constant
A change to an in-cell calculation (e.g. = 1/1.61) from either data or another in-cell calculation.
New, deleted or amended VBA code
VBA Reference Libraries
Those that have been added, removed or changed.
Added & Deleted
Worksheets that have been added or removed.
Changes to the protection status of worksheets.
The connections to external data sources (e.g. SQL databases) that have been added, removed or changed
the links to other files that have been added or removed
BMO Spreadsheet Control Policy, BMA-009 (Change Control)
A process is in place to track, authorise (e.g. formal sign-off) and evidence (e.g. audit log) changes for BMAs.