MS Office/Excel Controls – Use of Checksums
{"Image DocumentName": "MS Office/Excel Controls \u2013 Use of Checksums", "Image ImageDescription": "DataSafeXL August 2010 white paper Excel Hell: How Simple Checksums Can Ease The Pain of Financial Modeling provides a good primer on one approach to managing checksums. Cell-based modeling is a root cause of some of the issues including: Simple errors in formula construction, returning error values such as: #VALUE! ; #REF! ; #NAME? ; #N/A; etc. Errors in formulas dependent on other feeder cells that only become apparent later on, usually in different tabs to the tab you are currently working on, but missed because you cannot see them or are not alerted to them. Changing the spreadsheet structure which frequently creates errors containing the notation #REF! which ripples through financial statement rollups, thus making them unreadable.", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}