1 / 14

Excel Translator™

Excel Translator™ eliminates the time-consuming and expensive process of converting Excel models into programs. It enables rapid adaptation to changing market conditions by instantly converting Excel models into executable machine code components.

johncook
Download Presentation

Excel Translator™

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel Translator™ Ultimate Risk Solutions, Inc.: 1 201 220 3015

  2. Formulation of the Problem • Financial Analysts often do fast repeating calculations, usually prototyped as Excel models. • Excel models are then converted into programs, a time-consuming, labor-intensive and expensive process. • Excel Translator™ eliminates such painful program development process, instantly converting Excel models into programs, and doing even much more than that...

  3. Formulation of the Problem • Microsoft Excel is a feature-rich modeling environment, giving analysts flexibility to react quickly to the rapidly changing business and economic conditions. • Businesses succeed of fail, depending on how quickly they adapt to change. • Excel Translator™ enables companies to rapidly react to new market conditions by changing their Excel models and compiling them into fast running executable machine code components independent of Excel.

  4. Existing Solutions • Analysts currently have 2 options: • Write specialized software applications in various programming languages to process the calculations • Advantage: fast calculation speed • Drawback: software is rigid and requires long and expensive reprogramming every time the structure changes • Create Excel spreadsheets to process the calculations • Advantage: flexibility in changing the structure of the calculations, Excel makes modeling easier • Drawback: unacceptably slow calculation speed, inability to model portfolio of transactions, potential exposure of proprietary algorithms to prying eyes of competitors

  5. Ultimate Solution from Ultimate Risk Solutions • Speed AND Flexibility – you no longer have to choose between them • Create your typical Excel spreadsheet and TRANSLATE it into fast machine code using Excel Translator™ • Advantages: • Large savings - No need to spend thousands of man-hours on constantly reprogramming the software • Better use of resources - Let analysts do their work of analyzing the structures (rather than programming). • Adaptability - Easily change the structures on-the-fly, translate and use them • Profitability - Be faster and better than your competition

  6. Excel Translator™ CONVENTIONS: • Designate certain cells in your spreadsheet to be used as Input Cells • Designate certain other cells in your spreadsheet to be used as Output Cells • Input and Output of the structures are usually known in advance • Use all and any of the remaining cells on any sheet in your spreadsheet as calculation or Logic Cells • There are no restrictions on the number of logic cells or sheets or on the formulas you want to use • There are no restrictions on using external Add-Ins and VBA Macros. Use them as you usually do

  7. Structure of Spreadsheet File

  8. Formatting Spreadsheet File • Define any number of Input and Output variables • Matrix variables (ranges) or Single-Cell variables can be used as Input or Output variables • Define logic of your model that can contain Excel formulas and/or VBA macros • Connect entry-point cells in the logic to input cells via formulas • Connect output cells to exit-point cells in the logic, also via formulas • You can easily utilize your existing models by defining cells to be used by Input and Output variables

  9. Excel Translator™ – Translated DLL • Ideas behind Excel Translator™ are patent pending • Excel spreadsheets, even the most complex, are translated into a single-function DLL • DLL contains all calculation logic (formulas) you defined in your spreadsheet, but in the form of fast machine code • Spreadsheet’s Input Cells become Input Parameters for the DLL • Output Cells become Output Parameters

  10. Excel Translator™ – Lightning Fast Calculations • DLL has a single function that • Takes input parameters • Runs all calculations you specified in your Excel spreadsheet • Produces output parameters • This function can now be called in a fast repeating mode, say 100,000 times, with different input parameters each time, thus, returning different output values • Typically, output values are accumulated to be subsequently analyzed

  11. Testing Translated DLLs • DLL Testerincluded in the package automates Quality Assurance: it verifies that translated DLL and its original Excel model produce the same calculated results • This gives users confidence that translated DLL does the same calculations as original Excel model, only much faster • When you run DLL Tester, it will: • Let you specify the DLL and Excel files • Load DLL and open Excel file • Populate both DLL and Excel file with the same input values • Run both DLL and Excel calculations • Retrieve and compare DLL and Excel output • If there are discrepancies between any respective DLL and Excel output values, the detailed information about each such discrepancy and its cause is provided • DLL Tester can be programmatically run over all possible sets of input values to ensure the proper performance of translated DLL over the entire spectrum of inputs

  12. Producing Input and Accumulating Output Values • With URS’s auxiliary software tool, Model Builder, you can build sophisticated, complex, yet elegant models, using previously created DLLs as building blocks. Model Builder can: • Generate values of input parameters • Via Stochastic Simulations, or • By reading them from external file, or • As a result of Correlations/Dependencies on other input variables • Run DLLs produced by URS Translator in a fast repeating mode, with a new set of inputs each time • Accumulate output values • In the form of empirical distributions (histograms), or • By saving output values to be subsequently imported to Excel for further analysis

  13. Automating Process with Excel Translator™ and URS Model Builder

  14. Excel Translator™ – Proven Technology • Ideas behind Excel Translator™ are patent pending • The product is highly evolved and has been successfully used by large insurance and financial firms • It saves much time, effort and money on program development and maintenance • It works as a tiger-team of programming experts, does the job instantly, and never takes vacations or lunch breaks • Allows rapid model development and deployment • Provides additional statistical distribution functions, speeds-up and enables sophisticated modeling with Model Builder, and much more…

More Related