Dbank

Time Series Data Management
For Windows Desktops and Servers.

Using Microsoft Excel

Automating Excel Spreadsheets

Reading Dbank

Updating Dbank

Univariate Statistical Functions

Statistical Array-Formulae

 

 

 

Automating Excel Spreadsheets

Automating Excel Spreadsheets (Pdf Manual)

Dbank can produce Microsoft Excel spreadsheets that read Dbank time series directly. The specific approach, implemented using Dbank’s time series object model, allows Excel to access time series stored in a Dbank database without actually invoking Dbank’s graphical user interface. “Automated” spreadsheets can hot-link any cell an Excel spreadsheet to any time series observations and metadata stored in a Dbank database. The link is implemented using a Visual Basic for Applications (VBA) macro that calls Dbank’s Time Series Engine from Excel.

Automated spreadsheets provide the basis for sophisticated management reports that use all the power of Microsoft Excel for formatting time series information. Moreover, automated spreadsheets will automatically re-read the data stored in the Dbank database(s) whenever the spreadsheet recalculates. Since each Dbank database can be up to two gigabytes in size, hot-linked spreadsheets provide a means of sharing very large time series databases online with Excel users. Excel’s memory usage is keep to a minimum because only those observations needed to recalculate the spreadsheet are actually “pulled” into the spreadsheet by Dbank’s XLA.

 

| Copyright © 1994-2011 | TSDM Pte Ltd | Time Series Data Management for Windows | Contact TSDM |