Thread: Model Audit
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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

.