Spreadsheet Basic simplifies programming in Excel compared to VBA. It doubles as a script language for data acquisition from hardware, analysis, and presentation.
With spBasic, users can perform calculations that are too complex to fit in cell formulas, and execute complex logic and looping operations over cell ranges. Like any programming language, you write a series of spBasic 'statements' using its own program edit window. You can use worksheet cell values as 'variables' in spBasic.
Using spBasic is easy, as it features familiar programming statements like "If", "For-Next", "Do While", and more. Additionally, it supports all the functions available in Excel, unlike VBA which cannot, including SUM and AVERAGE. The software also supports custom functions and subroutines written in VBA, and it has an extensive 'Help' facility where you can add custom help for any functions and subroutines you add.
Spreadsheet Basic makes it simple to collect and analyze data, with a Script language to control hardware and instrumentation through PC interfaces. It also allows you to collect and display data measurements on charts and graphs. spBasic 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.
With both simple and complex program examples included in the free fully functional download, Spreadsheet Basic is an essential tool both for regular worksheet applications and hardware control. Whether you're a beginner or an experienced programmer, Spreadsheet Basic is an Add-In worth considering. Try spBasic, you'll like it!
Version 1.2.0: N/A
Version 1.1.9: N/A