mapping spreadsheets

sann0638 · May 21st, 2002, 09:41 AM

Does anyone know the name of the software (or simply how to do it) that allows one to 'map' a spreadsheet, showing which columns are copies, where new formulae start, and dependencies?

_________________
Regards, Mike.

[ This Message was edited by: sann0638 on 2002-05-21 08:48 ]

[ This Message was edited by: sann0638 on 2002-05-22 01:46 ]

sann0638 · May 22nd, 2002, 02:49 AM

Hello again,
I might not have made myself clear. What I am looking for is an audit tool for those coming to a spreadsheet created by someone else. The spreadsheet could repeat a calculation over a number of years, or a number of categories, and the auditor needs to know which columns are simply copies of the furthest left column (for example), and where the formula changes form. Any recognition that someone has come across something like this would be good!

_________________
Regards, Mike.

[ This Message was edited by: sann0638 on 2002-05-22 02:05 ]

Ian Mac · May 22nd, 2002, 05:52 AM

Quote:

On 2002-05-22 01:49, sann0638 wrote:
Hello again,
I might not have made myself clear. What I am looking for is an audit tool for those coming to a spreadsheet created by someone else. The spreadsheet could repeat a calculation over a number of years, or a number of categories, and the auditor needs to know which columns are simply copies of the furthest left column (for example), and where the formula changes form. Any recognition that someone has come across something like this would be good!

_________________
Regards, Mike.

[ This Message was edited by: sann0638 on 2002-05-22 02:05 ]

What about Excels 'Track Changes' found under Tools

sann0638 · May 22nd, 2002, 06:41 AM

Hi Ian,
I've now found what I'm looking for, at http://www.uq.net.au/detective. It's called spreadsheet detective, and will be of use to anyone who has had to take over or debug a large (nonVBA) spreadsheet from someone else.

May 22nd, 2002, 06:41 AM	#4
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	Hi Ian, I've now found what I'm looking for, at http://www.uq.net.au/detective. It's called spreadsheet detective, and will be of use to anyone who has had to take over or debug a large (nonVBA) spreadsheet from someone else. __________________ Regards, Mike.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 09:41 AM	#1
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	Does anyone know the name of the software (or simply how to do it) that allows one to 'map' a spreadsheet, showing which columns are copies, where new formulae start, and dependencies? _________________ Regards, Mike. [ This Message was edited by: sann0638 on 2002-05-21 08:48 ] [ This Message was edited by: sann0638 on 2002-05-22 01:46 ]

May 22nd, 2002, 02:49 AM	#2
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	Hello again, I might not have made myself clear. What I am looking for is an audit tool for those coming to a spreadsheet created by someone else. The spreadsheet could repeat a calculation over a number of years, or a number of categories, and the auditor needs to know which columns are simply copies of the furthest left column (for example), and where the formula changes form. Any recognition that someone has come across something like this would be good! _________________ Regards, Mike. [ This Message was edited by: sann0638 on 2002-05-22 02:05 ]