Skip to content

probability-management/ChanceCalc

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

ChanceCalc

Stochastic modeling tools for Excel

Installation

  • download and run the install package for your system
  • Activate the ChanceCalc add-in as follows:
  • Start Excel
  • Open the Excel Add-ins manager
    • On Windows
      • Open or create an Excel workbook
      • Press Alt-T-I
    • On Macintosh
      • Click Tools on the menu
      • Click Excel Add-ins... on the Tools sub-menu
  • The Add-ins manager displays a list of available and installed add-ins
  • Remove any existing ChanceCalc or SIPmath add-ins
    • if any add-ins in the list named ChanceCalc or SIPmath are checked, uncheck them
  • Press the Browse... button
    • Browse to the folder where the ChanceCalc files were installed
    • Find and select the file Beta_ChanceCalc_Plus.xlam
    • Press OK to close the Browse dialog
  • The ChanceCalc add-in should be checked in the list of available add-ins
  • Press OK to close the add-ins manager.

Using ChanceCalc

Title

Contents

Introduction

ChanceCalc Tab

ChanceCalc Ribbon

SIP Input dialog

Graphs

Chance of Whatever

Average, Std Dev, Percent

Tail Risk

Save as CSV

Trial Info

Settings | Simulation

Settings | Formatting & Diagnostic

Settings | Advanced

Metalog Tab

Metalog Ribbon

Metalog Interface

Metalog Interface - cont'd

SIPmath mode, to Clipboard button

SIPmath mode, to File button

to Excel mode, Paste to Excel

to Excel mode, Link to Excel

Monte Carlo Tab

Monte Carlo Ribbon

Appendix 1: Troubleshooting

Appendix 2: Lambda Functions

Lambda Functions, cont'd

HDR and M.SPT_u functions

About

Stochastic modeling tools for Excel

Resources

License

Stars

Watchers

Forks

Packages

 
 
 

Contributors