Please enable JavaScript.
Coggle requires JavaScript to display documents.
BMO Spreadsheet Sign-off Summary Report (Cells (Functions (Function…
BMO Spreadsheet Sign-off Summary Report
Cells
Errors
New instances of cells that evaluate to an error value such as #N/A, #VALUE!, #DIV/0!
Functions
Function Changed
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
Function deleted and replaced with neither another function nor data.
Function Added
New function created in an empty cell.
Data To Function
A value replaced by a function.
Constants
Change of constant
A change to an in-cell calculation (e.g. = 1/1.61) from either data or another in-cell calculation.
VBA
VBA Code
New, deleted or amended VBA code.
VBA Reference Libraries
Libraries that have been added, removed or changed.
Workbook
Worksheets
Added & Deleted
Worksheets that have been added or removed.
Worksheet Protection
Changes to the protection status of worksheets.
External Data
Data Connections
The connections to external data sources (e.g. SQL databases) that have been added, removed or changed.
Links
the links to other files that have been added or removed
BMO Spreadsheet Control Policy, BMA-009 (Change Control)
requires that,
A process is in place to track, authorise (e.g. formal sign-off) and evidence (e.g. audit log) changes for BMAs.