GREATools

Actuarial Shareware

Home

GREATools Menu Commands

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

GREATTOOLS
 ReexecuteReexecute
 Setup WizardcbRegSetup
 ListAllcbRegListAllModels
 RefreshcbRegRefresh
 Persist RangecbPersistRange
 DePersist RangecbDePersistRange
 Duplicate formulas, formats, and valuescbCopyExact
 Remove local $sNiceDeAbs
 Swap formula and commentcbSwapFormulaAndComment
 Document Row Formulae (highlight first row of formulae)DocumentRowFormulae
 Shade CellscbShadeCells
 Format ColumnscbParLines
 Format RowscbFormatRows
 Colorize FormulascolorFormulae
 Toggle ColorcbToggleColor
 Surface Plot of RangecbkPlot3d
 2D Histogramcbk2dHist
 Scatter XY PlotcbXYChartScatter
 Lines XY PlotcbXYChartWithLine
 Line PlotcbXYLineChart
 Sanitize PlotcbSanitizePlot
 Toggle Log ScalescbScalesToLog
 Toggle tight scalescbScalesToTight
 Common PositioncbGotoCommonRangeInSheets
 Common Position - optionscbGotoCommonOptions
 Common Position - with extended optionscbGotoCommonRangeInSheetsEx
 Beginning'cbclick -10000'
 Back'cbclick -1'
 Next'cbClick 1'
 End'cbclick 10000'
 Add to clicker and selectclickAddAndSelect
 Iterate: selection.value=range(tb).valueclickIterate
 Precedents'clickPrecIt CommandBars(BARNAME).Controls("Clicker Cell Name")'
 Dependents'clickDepIt CommandBars(BARNAME).Controls("Clicker Cell Name")'
 Names modeclickerNameMode
 Clear ClickerclearClicker

Details

GREATTOOLS
 ReexecuteReexecute
  Reexecute the current (last) task. Controlled by the TPM. 
 Setup WizardcbRegSetup
  Regression set up call back. 
 ListAllcbRegListAllModels
  List all regression models. 
 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. 
 Persist RangecbPersistRange
  Persist selected range to a mapped file. User prompted for filename. 
 DePersist RangecbDePersistRange
  Read file persist with cbPersistRange to selection. User prompted for filename. 
 Duplicate formulas, formats, and valuescbCopyExact
  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 local $sNiceDeAbs
  Makes local cells non-absolute while keeping distant cells absolute. Useful for making changes to templates produced by Distributions etc. 
 Swap formula and commentcbSwapFormulaAndComment
  Swaps the formula and comment. If range has no comment one is created. 
 Document Row Formulae (highlight first row of formulae)DocumentRowFormulae
  Documents formulas in input range. Can be a single row or single column Assumes the following input structure
        (1)         (2)         <== created by this macro         .          '=(1)       <== created by this macro      Heading1      Heading2    <== input by user      =formula1     =formula2   <== input by user and selected prior to running this macro  
 
 Shade CellscbShadeCells
  Solid shade cells a reasonable color, that can subsequently be toggled. 
 Format ColumnscbParLines
  Add vertical parallel lines, reasonable color, that can subsequently be toggled. 
 Format RowscbFormatRows
  Thick/thin formatting of rows. 
 Colorize FormulascolorFormulae
  Color cells with formulas blue. Otherwise color black. 
 Toggle ColorcbToggleColor
  Toggle private colors to highlight input cells etc. 
 Surface Plot of RangecbkPlot3d
  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.
 
 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. 
 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. 
 Sanitize PlotcbSanitizePlot
  Apply Tufte-standard formatting to plot, as near as possible! 
 Toggle Log ScalescbScalesToLog
  Toggles axes on a chart: both log, x log, y log, neither log. 
 Toggle tight scalescbScalesToTight
  Toggles the scales from automatic, to tight xy, tight x, tight y, where tight is based on the actual max/min of the series in the chart. For xy plots only. 
 Common PositioncbGotoCommonRangeInSheets
  Moves the cursor to the same place in each worksheet of the active workbook. 
 Common Position - optionscbGotoCommonOptions
  Set options for advanced "common position" function. 
 Common Position - with extended optionscbGotoCommonRangeInSheetsEx
  Moves the cursor to the same place in each worksheet of the active workbook, with extended options set using cbGotoCommonOptions 
 Beginning'cbclick -10000'
 Back'cbclick -1'
 Next'cbClick 1'
 End'cbclick 10000'
 Add to clicker and selectclickAddAndSelect
  Add the selected range to the clicker drop down, select it into the drop down and set to clicker mode. 
 Iterate: selection.value=range(tb).valueclickIterate
  Iterates: selection.value = range(combo box range).value. 
 Precedents'clickPrecIt CommandBars(BARNAME).Controls("Clicker Cell Name")'
 Dependents'clickDepIt CommandBars(BARNAME).Controls("Clicker Cell Name")'
 Names modeclickerNameMode
  
 Clear ClickerclearClicker