Some sample programs

Several sample programs (excel workbooks) are listed and described below. They give a good idea of what can be achieved using excel programming. You can download them as workbooks and then run using excel, or you can run some of them right now in your browser itself, using links below. If they do not run properly in the browser, possibly due to some version conflict, you will have to download and run them. Here are some useful points :
 
Process capability calculator
run in browser
download
Beta risk calculator
run in browser download
Cooling of a sphere
run in browser download
Editing outliars in data

download
Generating word report

download

1. Process capability calculator

This calculator calculates process capability for user-specified process characteristics (such as mean, sigma and process specification limits), for two processes simultaneously. It shows process characteristics graphically, along with the underlying normal distributions, and you can read the normal distributions just by moving your mouse.

  top      Run in browser

2. Beta risk calculator

This calculator calculates the beta risk for user-specified process requirements and alpha risk. The two normal curves with appropriate tail areas are shown graphically.

  top      Run in browser

3. Cooling of a sphere

This program simulates the process of cooling a sphere. The sphere is at a uniform high temperature to begin with, and it is suddenly placed in a lower temperature surroundings. The sphere wall cools faster, while its center cools slowly. The temperature profile inside the sphere changes with time, and is shown graphically. You can change the two temperatures and sphere size, and see the effect on time required for cooling.

  top      Run in browser

4. Editing outliars in a data set

This program has a reasonably large data sheet, which refers to a plant running under steady controlled conditions. The sheet has some blank cells and some outliars. These have arisen probably due to typing or copying errors. This program permits you to mark outliars and blanks with one click of a button. It also presents the outliars and blanks to you, one by one, so that you can give correct values.

  top   Download 

5. Generating a word report

This program uses an excel sheet which calculates the settling velocity of a sphere in water. It then generates a word report automatically, using the calculated results.

  top   Download 





How to download sample workbooks

 Click here to download a file named xlprograms.zip (approx. size 690 KB). Unzip the file to extract five excel workbooks into any folder of your choice. These can be run with excel. You can check them with your favorite virus checking program before running them, if you so desire. These sample programs were developed using Microsoft® Excel 2003. Even if you have an earlier version, I expect most of the functionality to work. However, it is possible that some functionality may not be available in earlier versions.

  top