Model Audit

[ExcelMonkey]

I have two excel models which I am reviewing for the
purposes of stating whether or not model #2 is a
derivative of model #1. A forensic investigation if you
will. Does anybody know of any tests that I can perform
on these two separate files to tell if they have
similarities? I know that I can check:

1) who authored them
2) attempt to look at the structure and layout

I am assuming I can also compare formulas to see if they
appear #1 and in #2.


Can anyone recommend any other tests that I can do
(including use of VBA), and/or available software products
that would help me ascertain how similar these model are?

Thanks

 

[Guest]

hi,
see this site
http://www.cpearson.com/excel/duplicat.htm#InOneNotOther

 

[Tom Ogilvy]

Builtindocumentproperties
formatting

The excel/office files hold a lot of hidden information. I don't know how
to retrieve it, but recognition of that fact created a bit of a fuss awhile
ago. There are articles on the knowledge base about removing that
information - they might provide some insight what to look for perhaps with
a hex editor.


http://support.microsoft.com