Spreadsheet Basic

Spreadsheet Basic (spBasic) is an Excel Add-In that provides a simplified programming language for Microsoft Excel spreadsheets. This language is much easier to use than Excel's native programming language, VBA (Visual Basic for Applications). The target audience for spBasic is users who want to execute VBA-type procedures without having to deal with VBA's complexity.

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!