Thread: Model Audit
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey[_190_] ExcelMonkey[_190_] is offline
external usenet poster
 
Posts: 172
Default 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