||EXCEL SUPPORT IN DPL 7
Excel use is ubiquitous among financial professionals, and DPL's extensive support for Excel linking
and Excel spreadsheet conversion reflects that fact.
DPL 7 provides three ways to establish links to Excel.
Click on any of the images below to see a larger image.
- Model | Create Model from Excel
Build an Excel linked DPL influence diagram all at once, selecting the named cells for which nodes
should be created. DPL scans the dependencies in your spreadsheet, creating not only the nodes,
but also the influence arcs.
- Node | Create Linked Values | From Excel
Use this feature to add several value nodes to an existing model. Just specify the path to the
spreadsheet and choose from a list of named cells.
- Node | Edit Definition | Links
You can choose from a list of cells. DPL
shows you the sheet location of each one, and if you're still not sure, you can click "Go to Cell"
and DPL will activate that cell in your spreadsheet.
DPL's Model Links dialog makes it easy to manage spreadsheet links as your model
evolves. Now you can see a list of the linked nodes/cells, jumping to the spreadsheet cell or
the Node Definition box by clicking a button.
New Initialization Links
With DPL's initialization links, it's easy to store your probabilities and values in Excel. Just
define the range names in Excel, tell DPL where the spreadsheet is, and pick them from the list in
Node | Definition | Data.
Arrays and Series
New in DPL 7, you can now link either individual cells, rows or 2-D ranges to similarly
dimensioned value nodes. Working with time-dependent uncertainties or metrics is now as
easy as working with scalars.
Converting your Spreadsheet
For game-changing runtime performance, you can convert your spreadsheet to code. This typically results
in a speed increase of 10-100 times vs. the same Excel linked model.
It's also easy to go back, for when you are making
changes and want "live" links.
To see an example with the new initialization links, or just to take a look at spreadsheet support
in general, open the example file delivered with DPL -- DrugDevelopment.da. For each of the chance nodes,
the Node Definition Links tab tells DPL that the node data is stored in the same workbook that is used
for calculations, and the
specific reference is in the Data tab. Note that the calculation and initialization links can't refer
to the same sheet, but can refer to different sheets in the same workbook.
|Copyright © 2004-2010 Syncopation Software