Extractor & Evaluator

Description

ROV EXTRACTOR & ROV EVALUATOR software is brought to you by Real Options Valuation, Inc. and is meant to work with Excel 2007 and later. This software is meant to be used inside of Microsoft Excel 2007 to extract an existing model into pure mathematical relationships and code such that the model can be run outside of Excel. By running the extracted model, several items are accomplished, namely:

• All of the business intelligence and relationships are maintained but will no longer be visible to the end-user, allowing the model creator to safely and securely distribute the model without losing control of any intellectual property or company secrets.
• A large model that can take a long time to run in Excel can now be run at extremely fast speeds in the lifted model.
• Large-scale Monte Carlo Risk Simulations with a large number of trials can be performed at very high speeds.
• The extracted model can be locked using an RSA 1028 encryption (military-strength protection) and can only be accessible using the correct password.
• Large models with many irrelevant parts are identified, and you can identify the main key inputs and outputs you wish to have modeled. For instance, in a model such as A+B+C=D, B+E=F, and if F is chosen as the key output, only B and E are relevant. This ability decreases the computational time for the model by identifying critical inputs, and the model can then be optimized to run even faster once the model thread is identified.
• The large Excel model can now be turned into a calculator-like environment, where all the end user has to do is enter in the inputs and obtain the outputs. Imagine it as akin to creating a very large Visual Basic function in Excel, but instead of a simple function with several lines of computations, this function is an entire Excel workbook with many interconnected worksheets.
• The extracted model cannot be changed by the end user and this restriction maintains a strict quality control and prevents malicious tampering or accidental breakage of the model (e.g., equations and functions with broken links, wrong functions and calculations, etc).
• The extracted file can also be used by third-party software applications in a Component Based Modeling environment. For instance, the end user might have his or her own software or database with predefined calculations. The extracted file is linked into and is a part of this existing proprietary system. This proprietary system simply obtains the inputs to link into the extracted file and the extracted model will perform the computations at high speed and return the required outputs.