Spreadsheet Audit Software

  • Thread starter Thread starter SB
  • Start date Start date
S

SB

I posted the following message on a Lotus 123 newsgroup but received
no responses - I hope some of you out there can help...

I am looking for some software which would allow me to produce a
worksheet map for Lotus 123 files (ie a colour coded graphical map of
the worksheet that shows the contents of each cell - value, text,
unique formula, copied formula). It would also be extremely useful if
the software had shortcut keys set so that the reviewer (ie me!) can
cycle through all the precedents of the cell/formula being audited.

Can anyone out there suggest a good program to buy?

Thanks in advance
 
You might try this:

http://www.j-walk.com/ss/

John Walkenbach has a product called PUP. In it is a
feature called a Worksheet Map. Here's what it does:

Worksheet Map
The Worksheet Map utility creates a handy, color-coded
map that summarizes the contents of a worksheet. A
worksheet map can help you spot errors in your worksheet -
- for example, a non-formula among a group of formulas.
You can generate a worksheet map for a single worksheet,
or for each worksheet in a workbook.

A worksheet map uses the following codes:

Map Code Description
Green, with "F" The cell contains a formula
Green, with a numeric value The cell contains a formula.
The value indicates the relative complexity of the
formula
Yellow, with "V" The cell contains a numeric value or a
date
Red, with "E" The cell contains an error
Black, with "T" The cell contains text
Gray, with "L" The cell contains a logical value (TRUE or
FALSE)
White, with "-" The cell is empty


Karen
 
I posted the following message on a Lotus 123 newsgroup but received
no responses - I hope some of you out there can help...

I am looking for some software which would allow me to produce a
worksheet map for Lotus 123 files (ie a colour coded graphical map of
the worksheet that shows the contents of each cell - value, text,
unique formula, copied formula). It would also be extremely useful if
the software had shortcut keys set so that the reviewer (ie me!) can
cycle through all the precedents of the cell/formula being audited.

Can anyone out there suggest a good program to buy?

Thanks in advance
Click to expand...


Look at Visual StrongType http://www.visualstrongtype.com

This program evaluates cell formulas with *units*.
Dimension checking of formulas reveals errors fast!
 
Back
Top