Compiled and executable method

• US 9,389,840 B2
• Filed: 03/11/2014
• Issued: 07/12/2016
• Est. Priority Date: 02/11/2009
• Status: Active Grant

• Current Assignee: Johnathan Mun
• Original Assignee: Johnathan Mun
• Inventors: Mun, Johnathan
• Primary Examiner(s): Dao, Thuy
• Assistant Examiner(s): Nguyen, Mongbao
• Application Number:
  US14/205,288
• Publication Number:
  US 20150317136A1
• Time in Patent Office: 854 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 21/125 by manipulating the program code, e.g. source code, compiled code, interpreted code, machine code
• CPC Class Codes: G06F 8/35 model driven
• CPC Class Codes: G06F 8/41 Compilation
• CPC Class Codes: G06F 8/44 Encoding
• CPC Class Codes: G06F 8/70 Software maintenance or management

Abstract

A method and software system allowing the ability to use an existing Excel model and extract the business intelligence, relationships, computations and model into pure mathematical relationships and codes such that the business intelligence in the original model is completely protected and the model can be run at extremely high speed and advanced simulations of hundreds of thousands to millions of trials can be run.

Claims

1. A computer implemented method for converting spreadsheet models into mathematical code that is executable by a computer machine independent of the source application used to generate said models, said system comprising the steps of:

installing a Real Option Valuation (ROV) compiler on said computer,

said ROV compiler compiling a selected spreadsheet file generated in a source application, said spreadsheet file comprising at least one model, wherein said compiling is performed by extracting from the spreadsheet file;

(1) all formulas, variables, and variable interrelationships of said at least one model, and (2) selected inputs and outputs for said model, into an export file (.exp file) using an ROV Extractor module, and generating an encrypted executable file (.exe file), such that said formulas are hidden from a user who executes said executable file;

linking said executable file to any additional files, including said export file, used by said at least one model,

wherein said executable file can be run in a different application from the source application or from a command line prompt in said computer,

wherein said export file is configured by said ROV Extractor to be openable only by an ROV Evaluator module in accordance with an encryption template;

sending the compiled executable file to the user for execution on their computer,

wherein upon opening said executable file the at least one model is displayed along with the selected inputs and outputs;

said ROV Extractor accepting different input values from said user and executing said formulas using said different input values; and

said ROV Evaluator reporting the outputs of said execution to the user.

2. The method of claim 1, wherein a Monte Carlo simulation is applied to said at least one model.

3. The method of claim 1, wherein said model can be lifted from said source application and compiled into an optimized file, the file able to be linked with a second file, wherein said files can link with other files to form components of a much larger complex web of models, wherein outputs of one component file can become inputs of a second component file, and this linking of files can be continued without limit.

4. The method of claim 1, wherein a password is required to access and run said executable file.

5. The method of claim 1, wherein said spreadsheet file is converted into mathematical code that is protected by a license with a use restriction.

6. The method of claim 5, wherein said license utilizes hardware identification protection.

7. The method of claim 5, wherein said use restriction is a total number of uses.

8. The method of claim 5, wherein said use restriction is a number of days before the license expires.

9. The method of claim 5, wherein said use restriction is a specific license expiration date.

10. The method of claim 5, wherein said use restriction is a limited number of users.

11. The method of claim 5, wherein said use restriction limits use to a specific computer.

12. The method of claim 1, wherein multiple export files are linked together to create a more complex model.

13. The method of claim 1, further comprising the step of sending the export file to the user, wherein said export file is opened using said ROV evaluator tool.

14. The method of claim 13, wherein said ROV evaluator is configured to allow a user to change any of the input values for the formulas in said export file by manually overriding said values.

15. The method of claim 1, wherein said ROV evaluator is configured to provide user changeable settings for running a Monte Carlo simulation on said at least one model.

16. A system to convert spreadsheet models into mathematical code that is executable by a computer machine independent of the source application used to generate said models, said system comprising:

a Real Options Valuation (ROV) extractor module stored in a memory and executing on said computer machine, configured to extract mathematical data from said spread sheet;

an ROV compiler executing on said computing machine to convert at least one model in a spreadsheet file into mathematical code using said ROV extractor module to extract;

(1) all formulas, variables, and variable interrelationships of said at least one model, and (2) selected inputs and outputs for said model, into an export file, and generating an encrypted executable file, such that said formulas are hidden from a user who executes said executable file,

wherein said executable file is linked to any additional files, including said export file, used by said at least one model,

wherein said executable file can be run in a different application from the source application or from a command line prompt in said computer machine,

wherein said executable file is sent to the user for execution on their computer;

an ROV Evaluator module executing on said computer machine, wherein said export file is configured to be openable only by said ROV Evaluator module in accordance with an encryption template;

wherein upon opening said executable file the at least one model is displayed along with the selected inputs and outputs,

wherein said ROV Extractor accepts different input values from said user and executes said formulas using said different input values,

wherein said ROV Evaluator reports the outputs of said execution to the user.

17. The system of claim 16, wherein multiple export files are linked together to create a more complex model.

18. The system of claim 16, wherein said export file is sent to the user and said export file is opened using said ROV evaluator tool.

19. The system of claim 18, wherein said ROV evaluator is configured to allow a user to change any of the input values for the formulas in said export file by manually overriding said values.

20. The system of claim 16, wherein said ROV evaluator is configured to provide user changeable simulation settings for running a Monte Carlo simulation on said at least one model.

21. The system of claim 20, wherein a Monte Carlo simulation is applied to said at least one model.