GREATools

Actuarial Shareware

Home

GREATools Menu Commands

Updated: 2/8/2003 3:07:04 PM

GREATTOOLSMENU
 Task
 Edit TasksEditWorkspace
 Define/Run ProjectProjectWorkspace
 New Task Wizard
 GLMNewWizard1
 LinRegNewWizard2
 PrintNewWizard3
 ProjectNewWizard4
 Create from Existing Range
 GLMCreateWizard1
 LinRegCreateWizard2
 PrintCreateWizard3
 ProjectCreateWizard4
 Blank Headings
 GLMHeadings1
 LinRegHeadings2
 PrintHeadings3
 ProjectHeadings4
 Dump Database
 GLMDump1
 LinRegDump2
 PrintDump3
 ProjectDump4
 LoadLoadTasks
 Meta
 New Task BlankNewTaskBlank
 Create New TaskCreateNewTask
 Workspace
 New Access WorkspacenewMDBWorkspace
 Create Workspace in Existing DBcreateWorkspaceDB
 Open Existing WorkspaceopenWorkspace
 Show Current WorkspaceShowCurrentWorkspace
 Utilities
 Triangles
 DevelopmentmakeTrgFormula
 Averages Below TriangletrgAvgsOnly
 Delete Lower Half of TrgdeleteLowerHalf
 Delete Above Diag of TrgdeleteUpperHalf
 AS to Std FormatAStoStd
 Diagonal to RowDiagToRow
 Diagonal to ColumnDiagToColumn
 CumulatecbCumulate
 DecumulatecbDecumulate
 General Design Matrix from Triangle (3 ranges)regMakeTrgDesignMatrix
 Halliwell Design Matrix from Trg (3 ranges)regHalliwellDesignMatrix
 Setup VORVOR_Setup
 Simulate VORVOR_Simulate
 Distributions
 Frequency Distributions
 PoissonPoissonParam
 Neg Bin (VM->r,p)NBVMParam
 Neg Bin (Ctg->r,p)NBCtgParam
 Neg Bin (VM->r,beta)NBVMbetaParam
 Neg Bin (ctg->r,beta)NBCtgbetaParam
 PIG ParamsPIGParam
 Poisson PascalPoissonPascalParam
 Severity Distributions
 LognormalLognormalParam
 Shifted LognormalTruncLognormalParam
 GammaGammaParam
 Shifted GammaShiftedGammaParam
 Transformed GammaTransfGammaParam
 Transformed BetaTransfBetaParam
 ParetoParetoParam
 Aggregate Distributions
 Aggregate 7Agg7
 Aggregate 8Agg8
 Aggregate 9Agg9
 Aggregate 10Agg10
 Aggregate 11Agg11
 Aggregate 12Agg12
 Aggregate 13Agg13
 Statistics
 Stats onlyStatsOnly
 Stats, Fit OnlyStatsFitOnly
 Stats, HeadingsStatsHeadings
 Stats, Fit HeadingsStatsFitHeadings
 HistogramgrtHistogram
 Old HistogramgrtHistogramOLD
 2D Histogramcbk2dHist
 Pct Count, Pct LosspctCountPctLoss
 Correlation MatrixcbMakeCovMat
 Display SADCo Param FilecbDisplayParamFile
 Set SADCo Param FilecbSetParamFile
 Regression
 Make Design MatrixregBuildDesignMatrix
 SetupcbRegSetup
 RefreshcbRegRefresh
 Set Current/List AllcbRegListAllModels
 Describe CurrentcbRegDescCurrent
 Principal Component AnalysiscbPrincCompAnal
 Delete Lower Half of Correl MatrixcbDeleleteLowerHalf
 Delete Diag and Below of Correl MatrixcbDeleteDiagAndBelow
 Zero Lower Half of Symmetric MatrixcbZeroLowerHalf
 Ones on Diag, Zero below DiagcbOnesOnDiagZerosBelow
 Labelled x,y plotcbLabelXYPlot
 FastVariantMapth
 Persist RangecbPersistRange
 De-Persist RangecbDePersistRange
 List FilenamescbGetFVMFileName
 File DetailscbListDirFVM
 Close AllcbCloseAllFile
 TeX
 TeX TableTeXify
 TeX PMatrixTeXPMatrix
 TeX BMatrixTeXBMatrix
 TeX MatrixTeXMatrix
 TeX VMatrixTeXVMatrix
 TeX VVMatrixTeXVVMatrix
 Images
 Insert BlankcbWriteImagePlotBlank
 Execute Image BlankcbExecuteImagePlot
 Display Image HTML filecbDisplayImagePlot
 List all BMP filescbListDirBMP
 Insert imagescbInsertImage
 Postscript process imagecbImageToEPS
 Name Management
 List Names at SelectionlistNamesAtActiveCell
 Delete Selection NamedeleteActiveName
 Delete All NamesdeleteAllNames
 Delete All Names (This Worksheet)deleteAllNamesThisWorksheet
 Delete Invalid NamesremoveInvalidNames
 Range
 Copy ExactcbCopyExact
 Remove $sremoveDollars
 Remove local $sNiceDeAbs
 Frequency of Unique ElementscbkUniqueFreq
 Copy subheadingscbkCopyItemsDownColumn
 Delete Empty RowsdeleteBlankRows
 Shuffle Rangeshuffle
 Colorize FormulascolorFormulae
 Find Non-MatchesfindNonMatch
 DocumentRange (1-3)-->(4-6)cbDocRange13_46
 Name RangescbNameRanges
 Suck ValuescbSuckValues
 Set ValuescbSetValues
 Save to XMLcbkRangeToXML
 Sheet
 Make All Sheets VisiblecbkVisible
 List Sheet NamescbkSheetNames
 Set all print ranges to lettercbkLetter
 VBA Helpers
 VBA Module ContentsrunVBSpy
 DB Tables and QueriestableInfo
 Database Explorer (Oracle/SQLServer)dbInfoOS
 Queries and Caches DialogrunQueriesAndCaches
 Query Info at Active CelldataElementsM
 Graphics
 Scatter XY PlotcbXYChartScatter
 Lines XY PlotcbXYChartWithLine
 Line PlotcbXYLineChart
 Labelled x,y plotcbLabelXYPlot
 2D Histogramcbk2dHist
 3D PlotcbkPlot3d
 Cat VisualizationcbkCatVis
 Bivariate DistributionscbkBivDist
 DemonstrationscbkDemos
 Utilties
 Who am I?whoami
 Who am I->SelectionwhoamiSel
 Reinstall GREAT ToolbarcbReinstall
 My Perfect MenusetupMyPerfectMenuBars
 Document GREATMakeGREATDocumentation
 Document SCAREMakeSCAREDocumentation
 List of Button ImagescbMakeDisplayOfButtonImages
 Restore Mouse CursorrestoreMouse
 Goto Common PositioncbGotoCommonRangeInSheets
 Consolidate StringscbkConsolidateStrings
 Show Revision NumbercbShowRevisionNumber
 Help
 HelpshowHelp
 View ErrorsshowErrors
 AboutshowAbout
 Show Open WorkbookscbShowOpenWorkbooks
 Save all workbookscbSaveAllWorkbooks
 Insert BMP BlankcbWriteImagePlotBlank
 Execute BMP BlankcbExecuteImagePlot
 Display image HTML filecbDisplayImagePlot
 Insert image plotcbInsertImageAndDecs

Details

GREATTOOLSMENU
 Task
 Edit TasksEditWorkspace
  
 Define/Run ProjectProjectWorkspace
  
 New Task Wizard
 GLMNewWizard1
  
 LinRegNewWizard2
  
 PrintNewWizard3
  
 ProjectNewWizard4
  
 Create from Existing Range
 GLMCreateWizard1
  
 LinRegCreateWizard2
  
 PrintCreateWizard3
  
 ProjectCreateWizard4
  
 Blank Headings
 GLMHeadings1
  
 LinRegHeadings2
  
 PrintHeadings3
  
 ProjectHeadings4
  
 Dump Database
 GLMDump1
  
 LinRegDump2
  
 PrintDump3
  
 ProjectDump4
  
 LoadLoadTasks
  Load to the database from the current selection. Uses data in format provided by "create headings" menu item. 
 Meta
 New Task BlankNewTaskBlank
  ' blank for creating a new task 
 Create New TaskCreateNewTask
  
 Workspace
 New Access WorkspacenewMDBWorkspace
  Creates an empty MDB database, sets it as the workspace and builds default entries. Convenience for users who do not have Access. 
 Create Workspace in Existing DBcreateWorkspaceDB
  Creates a workspace database. The user is prompted to make a connection to the database where the workspace will live and for the template file (default provided). The database must already exist. If it doesn't the user can use newMDBWorkspace to create a new Access database or newSQLWorkspace to create a database in SQL Server. For other database platforms (Oracle, DB2 etc.) you shoud contact your database administrator. Unlucky you!
The new database is not selected as the current workspace. Use openWorkspace to select the new database as the current workspace.
 
 Open Existing WorkspaceopenWorkspace
  Prompt user for a new TPM workspace database. 
 Show Current WorkspaceShowCurrentWorkspace
  Display the current workspace connection string. 
 Utilities
 Triangles
 DevelopmentmakeTrgFormula
  Highlight a loss development triangle (rows years, columns development), excluding the row and column headers, and click development. Will produce a triangle of link ratios (using formulas), the usual averages, a row for your selections, and a blank for you to input exposures or premium, and your selected ultimate. Will over-write whatever is below the triangle, so be careful! Incredibly useful. 
 Averages Below TriangletrgAvgsOnly
  Highlight a triangle, e.g. of loss development factors. Will just put the block of averages from the Development command below the triangle. Like development, but only adds averages to a triangle of ratios. 
 Delete Lower Half of TrgdeleteLowerHalf
  Deletes the lower half of a square range. Useful when dealing with triangles. 
 Delete Above Diag of TrgdeleteUpperHalf
  Deletes the lower half of a square range. Useful when dealing with triangles. 
 AS to Std FormatAStoStd
  Converts an AS format triangle to a standard format triangle in the same range. Uses selection as the input and the output. 
 Diagonal to RowDiagToRow
  Diagonal of triangle into row; both ranges taken from selection. Triangle part must be square. 
 Diagonal to ColumnDiagToColumn
  Diagonal of triangle into row; both ranges taken from selection. Triangle part must be square 
 CumulatecbCumulate
  
 DecumulatecbDecumulate
  
 General Design Matrix from Triangle (3 ranges)regMakeTrgDesignMatrix
  ' makes a generic design matrix out of a triangle 
 Halliwell Design Matrix from Trg (3 ranges)regHalliwellDesignMatrix
  ' Halliwell design matrix, as above ' From PCAS LXXXIII PAPER ' three area input: trg, exps, output base 
 Setup VORVOR_Setup
  Set up Variability of Reserve analysis. As development, except it expands the set up to include bootstrap re-sampling off the triangle of link ratios. Allows you to determine rudimentary confidence intervals for ultimates. VOR = variability of reserves. 
 Simulate VORVOR_Simulate
  Complete the bootstrapping simulation. Perform after you have made your selections (in orange). Will simulate an entire run-off from the triangle, with user input correlation between the accident years. 
 Distributions
 Frequency Distributions
 PoissonPoissonParam
  Sets up a blank where you input the mean, it computes the parameters (in this case just equal to the mean) and sets up formulas for computing Pr(X=0), Pr(X=1), and so forth. 
 Neg Bin (VM->r,p)NBVMParam
  
 Neg Bin (Ctg->r,p)NBCtgParam
  
 Neg Bin (VM->r,beta)NBVMbetaParam
  
 Neg Bin (ctg->r,beta)NBCtgbetaParam
  
 PIG ParamsPIGParam
  
 Poisson PascalPoissonPascalParam
  A Poisson-stopped sum (mean theta) of negative binoimials, P, k. 
 Severity Distributions
 LognormalLognormalParam
  Sets up a blank, inputs mean and CV, outputs lognormal mu and sigma parameters. Shows you skewness. Blank includes f(x), F(x), LEV(x), Expense(x) = expected excess cost, and ME(x) = mean residual lifetime = conditional execess cost. 
 Shifted LognormalTruncLognormalParam
  As above for shifted lognormal, T+LN(mu, sigma), where T is a constant shift. Using three parameters allows you to match the mean, CV and skewness. This is typically a very good fit to the true aggregate, once the claim count is above 20 or so. Highly recommended approach, combined with the various tools for estimating the moments of an aggregate distribution. 
 GammaGammaParam
  As for lognormal and shifted logormal, only for the shifted gamma distribution. Like the shifted lognormal distribution, the shifted gamma allows you to match the first three moments of a distribution. Closed form solution for parameters. Recommended in Actuarial Math book as a good approximation to aggregate distributions. Uses the Klugman, Panjer, Willmot parameterization. 
 Shifted GammaShiftedGammaParam
  
 Transformed GammaTransfGammaParam
  Severity blank for the transformed gamma distribution, a three parameter distribution without a shifting parameter (hence four parameter with a shifting distribution). Needs mathFunctions.dll. KPW param. 
 Transformed BetaTransfBetaParam
  
 ParetoParetoParam
  
 Aggregate Distributions
 Aggregate 7Agg7
  
 Aggregate 8Agg8
  
 Aggregate 9Agg9
  
 Aggregate 10Agg10
  
 Aggregate 11Agg11
  
 Aggregate 12Agg12
  
 Aggregate 13Agg13
  
 Statistics
 Stats onlyStatsOnly
  
 Stats, Fit OnlyStatsFitOnly
  
 Stats, HeadingsStatsHeadings
  
 Stats, Fit HeadingsStatsFitHeadings
  
 HistogramgrtHistogram
  Very useful function. Select a column of large losses (in any order), and another shorter n x 1 column range. Tool will create a histogram using n buckets (it computes a resaonable size for each bucket from the input data. Also adds a chart to the worksheet plotting out the histogram points. Data is input as values, not formulas, so the histogram is static and will not recompute.

New version guesses a reasonable n, computes mean, cv and skewness of input sample, and provides a shifted lognormal fit.

 
 Old HistogramgrtHistogramOLD
  Deprecated version of grtHistogram 
 2D Histogramcbk2dHist
  Call back to run 2-d histogram function. Select range of (x,y), each weighted equally or (x,y,wt) to produce a weighted histogram. 
 Pct Count, Pct LosspctCountPctLoss
  Select a column of losses and execute. Adds percent of claim counts and percent of total losses to the right and a plot of these. Allows you to answer questions like "what percentage of total losses comes from the 5% largest counts?". 
 Correlation MatrixcbMakeCovMat
  Makes a covariance matrix out of the selected cells. Cells(2,1).value is used as default. 
 Display SADCo Param FilecbDisplayParamFile
  Display current SADCo parameter file. Menu callback. 
 Set SADCo Param FilecbSetParamFile
  Set a new default parameter file. Menu callback. 
 Regression
 Make Design MatrixregBuildDesignMatrix
  Makes a design matrix from input range, adds and intercept, and makes class variables full rank by deleting columns. Assumes input is
   Var Name        |Var Name        | etc.   Class or Var    |Class or Var    |   data            |data            |   ...             |...             |   data            |data            |  
 
 SetupcbRegSetup
  Regression set up call back. 
 RefreshcbRegRefresh
  Refresh/recalc call back. If there is a current, execute it. If not, is there a reg_ name on the current sheet? If not query for model. 
 Set Current/List AllcbRegListAllModels
  List all regression models. 
 Describe CurrentcbRegDescCurrent
  Describe the current regression model. 
 Principal Component AnalysiscbPrincCompAnal
  Runs the principal component analysis. 
 Delete Lower Half of Correl MatrixcbDeleleteLowerHalf
  Delete the lower half (below diagonal) of a correlation matrix. 
 Delete Diag and Below of Correl MatrixcbDeleteDiagAndBelow
  Delete the lower half (including diagonal) of a correlation matrix. 
 Zero Lower Half of Symmetric MatrixcbZeroLowerHalf
  Set out the lower half of a matrix. 
 Ones on Diag, Zero below DiagcbOnesOnDiagZerosBelow
  Put ones along the diagonal and zeros below on a matrix. 
 Labelled x,y plotcbLabelXYPlot
  Call back to produce a labelled x-y plot. Highlight a range of (label, x, y) , sorted by label. Makes a graph of x,y points colored by label values. Only accepts n x 3 input. 
 FastVariantMapth
 Persist RangecbPersistRange
  Persist selected range to a mapped file. User prompted for filename. 
 De-Persist RangecbDePersistRange
  Read file persist with cbPersistRange to selection. User prompted for filename. 
 List FilenamescbGetFVMFileName
  Allows the user to navigate to a file. Returns full name with path in selection. Convenience function. 
 File DetailscbListDirFVM
  List contents (rows and columns) of all FVM files in selected directory. 
 Close AllcbCloseAllFile
  Close all open mappings. 
 TeX
 TeX TableTeXify
  Makes a tex string command out of the selection table. Assumes the data is mostly numbers and hence right justifies. Middle vertical lines and all horizontal lines. Answer output to clipboard. Input is Caption Row of l, r, c to determine alignments Heading row data data data Version 1.0, Stephen Mildenhall, January 2003. 
 TeX PMatrixTeXPMatrix
  
 TeX BMatrixTeXBMatrix
  
 TeX MatrixTeXMatrix
  
 TeX VMatrixTeXVMatrix
  
 TeX VVMatrixTeXVVMatrix
  
 Images
 Insert BlankcbWriteImagePlotBlank
  Write an Image Plot blank to Excel with all inputs and defaults. 
 Execute Image BlankcbExecuteImagePlot
  Make image plot HTML file from blank (above). 
 Display Image HTML filecbDisplayImagePlot
  Show above file in HTML browser 
 List all BMP filescbListDirBMP
  List contents of all BMPs files in selected directory. 
 Insert imagescbInsertImage
  
 Postscript process imagecbImageToEPS
  
 Name Management
 List Names at SelectionlistNamesAtActiveCell
  List all range names at the active cell. 
 Delete Selection NamedeleteActiveName
  Deletes the name of the selected range. Shortcut for Insert->Name->Define, select ->Delete. Very convenient. 
 Delete All NamesdeleteAllNames
  Deletes all names in the active workbook. 
 Delete All Names (This Worksheet)deleteAllNamesThisWorksheet
  Deletes all names in the activeworksheet. 
 Delete Invalid NamesremoveInvalidNames
  Deletes (and lists) all invalid names in the active workbook. Invalid ranges appear when the range they refer to is deleted. This is a very useful function. 
 Range
 Copy ExactcbCopyExact
  Copies the values, formulas and number formats of a region into a cache. On second call the contents is written to the destination cells as a duplicate. Thus cell references are not moved as in a usual copy and paste operation. 
 Remove $sremoveDollars
  Makes all references relative by removing $s. 
 Remove local $sNiceDeAbs
  Makes local cells non-absolute while keeping distant cells absolute. Useful for making changes to templates produced by Distributions etc. 
 Frequency of Unique ElementscbkUniqueFreq
  Call KR word count routine, per C Programming Language p. 140. 
 Copy subheadingscbkCopyItemsDownColumn
  Input column of selected values, the macro goes down the column and copies row headings to each row. For example:
   A  1      2      3   B  1   C  1      2  
will be replaced by
   A  1   A  2   A  3   B  1   C  1   C  2  
 
 Delete Empty RowsdeleteBlankRows
  Highlight a column. Goes down each cell in the column and deletes the entire row if that cell is empty. This is useful for getting rid of hard coded sub-total rows, for example. 
 Shuffle Rangeshuffle
  Applies a random shuffle to the range. Useful for performing a cheap-man's convolution: get two samples and shuffle them. Then add. Uses algorithm from Knuth, Seminumerical Algorithms. 
 Colorize FormulascolorFormulae
  Color cells with formulas blue. Otherwise color black. 
 Find Non-MatchesfindNonMatch
  Highlight range and compare formulas with the next column over. 
 DocumentRange (1-3)-->(4-6)cbDocRange13_46
  
 Name RangescbNameRanges
  Names cells the value to the left (for use in creating an option table). 
 Suck ValuescbSuckValues
  Creates VBA code to read in values of variables as created by cbNameRanges. 
 Set ValuescbSetValues
  Creates VBA code to set var = Range, using variables as created by cbNameRanges. 
 Save to XMLcbkRangeToXML
  Call back to save the selection to an XML file. Somewhat picky about column headings. Needs further development before prime time! 
 Sheet
 Make All Sheets VisiblecbkVisible
  Make all the sheets in the active workbook visible. 
 List Sheet NamescbkSheetNames
  Lists all worksheet names at the selection. 
 Set all print ranges to lettercbkLetter
  Make all print ranges letter format and fit to one sheet. 
 VBA Helpers
 VBA Module ContentsrunVBSpy
  Call back to run VBSpy dialog. 
 DB Tables and QueriestableInfo
  Call back to get table information on the selected Access database. 
 Database Explorer (Oracle/SQLServer)dbInfoOS
  Show frmDatabase, to query for table definitions etc. Only available for Oracle and SQL Server Databases. 
 Queries and Caches DialogrunQueriesAndCaches
  Call back to run the queries and caches dialog. 
 Query Info at Active CelldataElementsM
  Puts query table and pivot table information into spreadsheet at the active cell. 
 Graphics
 Scatter XY PlotcbXYChartScatter
  Generic XY chart format, scatter plot. Sensible font sizes. Highlight range and execute. 
 Lines XY PlotcbXYChartWithLine
  Generic XY chart format, series joined with lines. Sensible font sizes. Highlight range and execute. 
 Line PlotcbXYLineChart
  Generic XY chart format, series joined with lines. Sensible font sizes. Highlight range and execute. 
 Labelled x,y plotcbLabelXYPlot
  Call back to produce a labelled x-y plot. Highlight a range of (label, x, y) , sorted by label. Makes a graph of x,y points colored by label values. Only accepts n x 3 input. 
 2D Histogramcbk2dHist
  Call back to run 2-d histogram function. Select range of (x,y), each weighted equally or (x,y,wt) to produce a weighted histogram. 
 3D PlotcbkPlot3d
  Select an m x n input range and click 3D Plot to activate a beautiful 3-D graphic of the selected range. Minimal scaling options on the x and y axis and generic labelling, but great coloring, contouring and interactive features. Ability to take a "snapshot" of the graphics, which is inserted into the spreadsheet (at the top left hand corner of the selected range) as a JPG file. Controls in the graphics window include:
  • left mouse - rotate image
  • right mouse - zoom in (upper half of image) and out (lower half)
  • w - toggle to wireframe view
  • s - toggle back to surface view
  • j - joystick mode
  • t - track ball mode
Some graphics cards aren't really upto this control; you need very good OpenGL support.
 
 Cat VisualizationcbkCatVis
  Call back to run Catastrophe Visualization in VTK. 
 Bivariate DistributionscbkBivDist
  Call back to run VTK bivariate distribution maker and viewer. 
 DemonstrationscbkDemos
  Call back to run VTK demos. 
 Utilties
 Who am I?whoami
  Display active workbook full name in a message box. 
 Who am I->SelectionwhoamiSel
  Write active workbook full name to the active cell 
 Reinstall GREAT ToolbarcbReinstall
  Call back to reinstall GREATools menu bar. 
 My Perfect MenusetupMyPerfectMenuBars
  Sets up "my perfect menus": those built in menu command I find most useful. 
 Document GREATMakeGREATDocumentation
  Run auto-documentation creation. Creates a file like the one you are reading from comments in the VBA source of your selected workbook. Module comments are generated from the first comments in each module (until the first new line). Function and Subroutine comments are the comments immediately following the declaration until the first non-comment line.
The comments can include HTML markup. It is copied verbatim into the documentation file. Change the base directory name and module name as appropriate to run on your project. Make sure that >, < and & are appropriately HTMLized!
 
 Document SCAREMakeSCAREDocumentation
  Makes SCARE documentation. See MakeGreatDocumentation for more information. 
 List of Button ImagescbMakeDisplayOfButtonImages
  Makes a list of all built in button images with their numbers. Useful for making custom menu bar buttons. 
 Restore Mouse CursorrestoreMouse
  Restores the mouse cursor and status bar to their default values. 
 Goto Common PositioncbGotoCommonRangeInSheets
  Moves the cursor to the same place in each worksheet of the active workbook. 
 Consolidate StringscbkConsolidateStrings
  Consolidates string values of all cells from the active cell to the next empty cell into the active cell and deletes the contents of the remaining cells. 
 Show Revision NumbercbShowRevisionNumber
  
 Help
 HelpshowHelp
  View help HTML file from the website. 
 View ErrorsshowErrors
  Shows the current list of logged errors. Logging is done inconsistently, so this is really for future use. 
 AboutshowAbout
  Shows the about file. 
 Show Open WorkbookscbShowOpenWorkbooks
  
 Save all workbookscbSaveAllWorkbooks
  Dim wk As Workbook, s As String, v ' As VBProject 
 Insert BMP BlankcbWriteImagePlotBlank
  Write an Image Plot blank to Excel with all inputs and defaults. 
 Execute BMP BlankcbExecuteImagePlot
  Make image plot HTML file from blank (above). 
 Display image HTML filecbDisplayImagePlot
  Show above file in HTML browser 
 Insert image plotcbInsertImageAndDecs
  As above with all the frills