Spreadsheet Basic 1.1.1

Spreadsheet Basic offers you a very effective product which is a computer programming language used in Excel spreadsheets. It is an Excel add-in designed for those who want to do VBA type procedures without dealing with VBA's complexity. Using SpBasic, you can perform complex calculations which are too involved to fit in a cell formulas, and run VBA-type procedures, such as complex logic and looping structures.

SpBasic has all the familiar programming statements, 'If', 'For-Next', 'Do While', and many others. SpBasic can use all the Functions available in Excel (SUM, AVERAGE) which VBA cannot do, plus it can use any custom functions you may want to write in VBA.

In addition to being used for regular worksheet applications, spBasic also provides a 'Script' language to control hardware and instrumentation through PC interfaces, and allows you to collect and display data measurements on charts and graphs. SpBasic is definitely an add-in you want to add to your software tools.

To use spBasic, you write a spBasic Program using the spBasic Edit Window. The program is a series of spBasic 'statements'. For example, the program 'SimpleProgram' is shown below. The first line defines the program name, 'SimpleProgram'. Then cell d1 is set to 1, and cell d2 is set to 4*d1 + 8, which is 12. 'End' defines the end of the program.