Click on the links below to view some example programs written in spBasic. These programs are included in the 'C:\Program Files\spBasic\Examples\' directory.

Financial

Loan Payment Table Generator - This example generates a table of loan payments for a range of loan amounts and interest rates. The spBasic programs uses the Excel PMT, DATE, YEAR, MONTH, and DAY functions.

Loan Balance Calculation - This example generates a table of loan balance vs. dates. The spBasic programs uses the Excel PMT, IPMT, PPMT, DATE, YEAR, MONTH, and DAY functions.

Math

Normal Distribution Calculation - This example generates a chart of normal distribution Y values as a function of X values. The spBasic program uses the Excel SQRT, EXP, AVERAGE, and STDEV functions.

Random Number Calculation - This example generates a chart of random numbers (Y) with an average computed from all previous values (Average), and a running average computed from the last 'numRunningAvg' points. The spBasic program uses the Excel RAND and AVERAGE functions.

 Live Excel Help!

Free initial talk time, no charge until you're convinced that the expert can help you!

Expert Excel Help!
Powered by LivePerson