Excel Style Guide - Inconsistent Formulas
Excel Style Guide - Inconsistent Formulas
Inconsistent Formula
The spreadsheet should contain contiguous columns of formulas, and not have variations of those formulas injected into formula columns. This is often caused by dragging cells around on a spreadsheet, which results in many unexpected formula changes. In another scenario, a “special case” is found in the data [...]
Posted by vega on January 19th, 2009 in Blog with No Responses
Excel Style Guide - Formulas in Data Ranges
Excel Style Guide - Formulas in Data Ranges
Formula in Data Range
The spreadsheet should contain contiguous columns of data cells, and not have cells with formulas injected into data columns. If those formulas are necessary due to special cases, these should be pulled out of the block of data as to highlight their existence. Placing formulas [...]
Posted by vega on January 15th, 2009 in Blog with No Responses
Excel Style Guide - Currency and Conversions in Excel - Detect 1.3
Excel Style Guide - Currency and Conversions in Excel
Currency Errors
The spreadsheet should be free of currency errors. These errors appear when cells are incorrectly combined. For example, if Euros and US Dollars are combined. Care must be taken to correctly format each monetary unit in order to provide not only comments [...]
Posted by vega on January 15th, 2009 in Blog with No Responses
Excel Style Guide - Error Cells - Detect 1.3
Here is the section on #Error Cells of the general Excel style guide that Detect 1.3 can be used to enforce.
Error Cells
The spreadsheet should be free of Error cells. Error cells are a sign of poor design. Formulas should not divide by zero, nor should they have #REF’s in them due to [...]
Posted by vega on January 14th, 2009 in Blog with One Response
Spreadsheet Style Guide for Excel
Spreadsheet Style Guide for Excel
When your company uses spreadsheets on a day to day basis to make important decisions, those spreadsheets must be carefully controlled. Decision makers need to be able to trust the spreadsheets that they base their decisions on. I would like to propose a process in which a company can [...]
Posted by vega on January 14th, 2009 in Blog with 2 Responses
Audit Training: Introduction To Regions
Newly added to the Training Section of this website at: training.
Audit Training: Introduction To Regions
This lesson covers the RedRover’s Audit product and how it shows like formulas. This lesson is relevant to both the 2003 and 2007 version of Excel. This example shows a view of an excel 2003 workbook with and without Audit [...]
Posted by vega on January 12th, 2009 in Blog with No Responses
Where does RedRover store the license files for Audit/Detect/Navigate?
Newly added to the FAQ section on this website at: FAQ
Where does RedRover store the license files for Audit/Detect/Navigate?
The license files are stored in the ‘Application Data’ directory in the ‘All Users’ area. Occasionally, during a support call you may be asked to remove files from these directories, and then to re-activate your [...]
Posted by vega on January 8th, 2009 in Blog with No Responses
Spreadsheet Errors and Troubleshooting
Have you ever had an value in your spreadsheet that just didn’t add up?
If you have, you’re not alone. It seems that every Excel user who writes formulas, or checks spreadsheets for correctness have seen these cases. Cases where the spreadsheet is broken in one way or another. It could take countless [...]
Posted by vega on January 7th, 2009 in Blog with No Responses
Detect tests available in RedRover Detect 1.3
Detect tests available in RedRover Detect 1.3
There are four sections of the options menu in Detect 1.3. These correspond to four different categories of tests. I will give an overview of each category here, leaving the details of each test for another post.
Formula Errors
First, let us take a look at the Formula Error [...]
Posted by vega on January 6th, 2009 in Blog with No Responses
Missing or Corrupt License File
Missing or Corrupt License File in RedRover’s Audit, Detect, or Navigate Software
If the directory of your license file has been moved or renamed from the standard:
C:\Documents and Settings\All Users\Application Data\RedRover Software\Licensing\[product]
Than you may find that you are on this screen when trying to start Audit or Detect.
The next step is to re-enter your license key, [...]