Model Audit
 

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

Model Audit
 

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

-----Original Message-----
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

.

Model Audit
 

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
--
Regards,
Tom Ogilvy



"ExcelMonkey" wrote in message
...
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