This page provides a link to each download file on the site.
| Download Link | Description | Link to Entry |
| Formula Trace Tool Add-In | This utility allows the auditor to click on precedent or dependent cell references in a listbox as opposed to clicking on audit arrows or performing a manual search. |
Link to Entry 1 Link to Entry 2 Link to Entry 3 |
| Healthcare Waterfall Chart | A variation on the waterfall charting techniques as illustrated at the PeltierTech site - applied to Healthcare. | Link to Entry |
| Breakeven Chart with Dynamic Label | A dynamic chart that shows a breakeven point. | Link to Entry |
| Chart Range Between Values | Charts a range of values between a minimum and maximum. | Link to Entry |
| Calculating Healthcare Payer Mix Changes | Show the components of volume as applied to healthcare. | Link to Entry |
| Microcharts | A VBA technique for creating very small in-cell charts. | Link to Entry |
| Bar Chart - Exclude Zeros | A bar chart based on an array range that excludes zero values. | Link to Entry |
| Proportional Axes Calculations | Illustrates how to calculate the minimum, maximum, and incremental values for a proportional dual-axis chart. | Link to Entry |
| Non-Contiguous Named Ranges as Chart Sources | A chart based on non-contiguous ranges. | Link to Entry |
| Pie Chart - No Zeros | A pie chart based on an array range that excludes zero values. | Link to Entry |
| Auto-Sort Chart | A chart based on an array range that automatically sorts values from high to low. | Link to Entry |
| Salary Forecasting and Spread Model | A salary forecasting model that ties out the components of salary change by month. | Link to Entry |
| Variance Examples | Illustrates the mathematical components of compounding for two, three, and four component variances. |
Link to Entry 1 Link to Entry 2 Link to Entry 3 |
