|
|
Spreadsheet Basic
-
Version
1.1.9
Spreadsheet Basic (spBasic) is a Computer Programming
Language used in Microsoft's Excel spreadsheets....It
is an Excel Add-In which is much simpler to use than
Excel's programming language, VBA (Visual Basic for
Applications)....It is designed for those who want to
do VBA type procedures without having to deal with
VBA's complexity....You can use Spreadsheet Basic for
calculations which are too complex to fit in a cell
formulas and for complex logic and looping over a
range of cells....To use spBasic, you write a series
of spBasic 'statements' just as in any programming
language (Visual Basic, etc.), except in spBasic you
can use worksheet cell values
as 'variables'....SpBasic uses it's own program edit
window and has all the familiar programming
statements, 'If', 'For-Next', 'Do While', etc., and
many others....SpBasic can use all the Functions
available in Excel (SUM, AVERAGE, etc.) which VBA
cannot do, plus it can use any custom functions and
subroutines you may want to write in VBA....It also
has an extensive 'Help' facility where you can add
custom help for any functions and subroutines you
add....Spreadsheet Basic also makes it easy to
collect and analyze data....In addition to being used
for regular worksheets 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....Also, the language has built-in
functions to control digital multimeters and hardware
such as power supplies, and is expandable to control
any other instrument or hardware device you may
have....Applications can range from the simplest
program to complex hardware and instrumentation
control. Both simple and complex program examples are
included in the free fully functional
download....Whether you just use regular worksheets
or want to control hardware, spBasic is definitely an
Add-In you want to add to your software tools....Try
spBasic, you'll like it!
|