menu icon Clever Thinking
Tel +44 (0) 1482 626400

ROV Extractor & ROV Evaluator

ROV EXTRACTOR & ROV EVALUATOR software is meant to be used inside of Microsoft Excel 2007 (or newer versions) to extract an existing model into pure mathematical relationships and code such that the model can be run outside of Excel. With this software, 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.

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.

The system requirements for the software include:

  • Windows XP, Windows Vista, Windows 7
  • Excel 2010 or 2007 (older versions of Excel are not supported)
  • 300MB free hard drive space
  • 1GB RAM minimum
  • Others: Microsoft .NET 3.5 Framework or later, VS Runtime, Microsoft Installer, and so forth

Please note that the .NET Framework 3.5 is included in the installation setup file, where the installer will first check your system, identify any missing prerequisites (e.g., .NET Framework 3.5, Microsoft Installer, VS Runtime, and other components), and automatically install them before installing the ROV Extractor and Evaluator software.

The ROV Extractor and ROV Evaluator software allows you to extract the model into a file that runs completely outside of Excel (extracted into EXP files) where all of its calculations are hidden and protected. This ROV Extractor and Evaluator software complements the ROV Compiler software such that a large model that can take a long time to run in Excel can now be run at extremely fast speeds in the lifted EXP model. Large scale Monte Carlo Risk Simulations with large numbers of trials can be performed at very high speed.

If you wish to extract the model into a self-executable (EXE) file that runs inside Excel but has all of its calculations hidden and protected and that can be licensed as its own software application, please use the ROV Compiler software instead. The ROV Compiler software complements this ROV Extractor and Evaluator software and is built by the same company.

ROV Extractor and Evaluator can be downloaded immediately from our website with a default 10 day trial license. Our philosophy is that you get to try before you buy. Once you use it, we are convinced you will fall in love with the simplicity and the power of the tool, and it will become an indispensible part of your modeling toolbox.

How do I install the software?

Make sure that you have administrative rights to install the software, and that your system requirements match or exceed those required in Item 1 above. In addition, make sure you have .NET Framework 2.0, 3.0, 3.5 or later already installed on your computer. Then, simply download the trial or full version of the software, double click on the exe file, and follow the instructions. Make sure to first uninstall any older versions of Risk Simulator before attempting to install a new version.

Resolution Issues

In WIN7 and Vista, users have the option to change the screen resolutions by “zooming in/out” and not just using a regular resolution change. When changing resolutions the regular approach (e.g., changing from 1280 x 800 to 1080 x 680) will not affect ROV software look and feel. However, using the zoom function does mess up some visuals (this is true of all software out there, and Windows actually even provides a warning message explaining this). The first two figures illustrate some effects of this zoom view.
Solution: Click on Start > Control Panel > Appearance and Personalization > Display and you see the user interface (see the third figure below). Change the view back to “Smaller 100% (Default)” then log-off and log-on to take effect and the RS/SLS software will display normally and correctly.

Expertise

Real Options Valuations and his CEO/Chairman Dr. Johnathan Mun are the software’s creator. These products including consulting and training activities have delivered and implemented in many Fortune 500 firms (from 3M, Airbus, and Boeing to GE and Motorola) and the government (Department of Defense, State and Federal Agencies, Central Banks, Regulators) on risk analysis, valuation, and real options. Dr. Johnathan Mun and his worldwide collaborators (risk managers, specialists and researchers) have written many books and peer-reviewed papers on the risk management and decision making, including Real Options Analysis: Tools and Techniques, 1st and 2nd Edition (Wiley Finance, 2002, 2005); Real Options Analysis Course: Business Cases (Wiley Finance, 2003); Applied Risk Analysis: Moving Beyond Uncertainty in Business (Wiley, 2003); Valuing Employee Stock Options Under 2004 FAS 123 (Wiley Finance, 2004); Modeling Risk: Applying Monte Carlo Simulation, Real Options Analysis, Forecasting and Optimization (Wiley, 2006); Advanced Analytical Models: 800 Functions and 300 Models from Basel II to Wall Street and Beyond (Wiley 2008); The Banker’s Handbook on Credit Risk: Implementing Basel II (Elsevier Academic Press 2008); and others. Real Options Valuation, Inc. develops advanced analytical software products and IT solutions, consulting, and training services in a joint venture with OSL Risk Management, Ltd.