|
|
Spreadsheet Basic
|
Description of Spreadsheet Basic
:
Spreadsheet Basic (spBasic) is a computer language designed to be used in Microsoft's Excel spreadsheets. It is modeled after the easy to use 'Basic' language which has been around for 40+ years and is familiar to many people. SpBasic makes it easy to write programs to create, analyze, and display data in Excel. The data can be formatted and displayed on worksheets, Charts, and Graphs using Excel's many resources.
The main purpose of spBasic is to make it easy for the user to create and display information, and also to collect and analyze data and display results. It's also used to control hardware and instrumentation through PC interfaces to collect and display data measurements on charts and graphs.
To use spBasic, you write a spBasic Program using the spBasic Edit Window. The program is a series of spBasic 'statements'. A simple example is,
if d3 > 1 then
d1 = d3
d2 = 4*d1 + 8
end if
The first statement is a conditional 'If'. If worksheet cell 'D3' value is greater than 1, then all the statements below it will be executed until the 'End If' is reached. The statement 'd1 = d3' sets the worksheet cell 'D1' value to cell 'D3' value, and the statement 'd2 = 4*d1 + 8' sets worksheet cell 'D2' to 4*d1 + 8. When you run this program, if cell 'D3' = 2, then cell 'D1' is set to 2, and cell 'D2' is set to 16. This is a simple example, the programs can get as complex as you need, much more complex than you can fit in a Excel cell formula.
SpBasic uses it's own program edit window and is much simpler to use than Visual Basic for Applications (VBA). It also has all the familiar Basic statements, 'If', 'For-Next', 'Do', 'Do While', etc., and may others. It can use all the Functions available in Excel, plus any custom functions and subroutines you may want to write in VBA. It also has an extensive 'Help' facility where you29.95 |
Related Software
 Christmas Paradise Screensaver - This terrific christmas screensaver will help you feel the magic of the Christmas Holiday. You will find yourself in a quiet winter forest with a few cottages scattered around. |
| outlookEMLandMSGconverter - Convert existing EML or MSG files to EML, MSG, HTML,TNEF, TXT using your current Outlook. |
| Fairy Christmas Day 3D Screensaver - Let this fabulous animated 3D screensaver take you away to a magic winter forest on Christmas Eve. Feel the holiday atmosphere in the air. Enjoy a gorgeous Christmas tree decorated with shimmering lights. |
| MyWindowsDoctor - MyWindowsDoctor Spy/Ad Process Wiper Free Version is an enhanced task manager that provides advanced information about programs and processes running on the computer. |
| Christmas Land 3D ScreenSaver - Far away in a forest there is a sacred land where Santa takes a little rest before going on his Christmas journey. The true Christmas spirits arise there at this time. |
| A123 Health AAC1 - Health AAC is software which can protect your hearing. It can improve the timbre with the higher sound effects of 192kbps, which can bring you the pleasant and attractive audio. |
| MING Chat Spy - MING Chat Spy is a simple and affordable software solution for companies who want to control, block, monitor, and archive unlimited IM traffic on the company network, including: AOL, MSN, Yahoo, ICQ and QQ. |
| Website on a box: eTarot site script - Open a professional online tarot practice to do internet readings for your customers. Our application will help you manage, contact, and market your services from one easily manageable application. |
| Unit Converter Pro - You will receive information electronically immediately after ordering! You will be able to download the product immediately after... |
| Apt Video Converter 1.20 - Apt Video Converter is apt and powerful media converter which can convert video file between all popular video formats such as converting WMV to AVI, WMV to MPEG, AVI to 3GP, converting H.264 video. |
| TV Pro Xmas Edition - TV Pro watch 300 plus tv channels on your... |
| JumpLock - Lock and unlock your PC with any removable... |
| Shell-and-Tube Heat Exchanger - Shell-and-Tube Heat Exchanger - is a user friendly program which for a given heat exchanger initial conditions and geometry predicts outlet temperatures of both shell-side and tube-side fluids, heat exchanged... |
| dbOrchestra-MySQL - dbOrchestra - MySQL is an all-in-one SQL database development tool, that includes a database object browser and a SQL query tool. |
| Seattle Sonnets - Laugh, cringe, cry, nod, as Charles Deemer's twenty-three sonnets of love and lust trace the cycle of a passionate love affair; a cycle most of us know all too well. |
|
|
