Spreadsheet Basic (spBasic) - Example Programs
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


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.

 

 

 

 

 

 

 

 



   Copyright © 2007-2010,  Reportdata.com                                                                                                       Contact Us