Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet-application by Microsoft. Some features include calculation, graphing tools, pivot tables and a macro programming language called VBA (Visual Basic for Applications). It is used by accountants, financial planners, scientists, or just about anyone who want to perform multiple calculations on multiple data items simultaneously. The power of Excel makes it perfect for air flow computations and analysis, especially for flow benches.
Flow Performance FPcom software has the ability to send your flow rate data directly into Excel, in real time, as you flow test. This gives you the ability to process your flow data in many different ways, including graphing and storage. For instance, if you would like your data to be displayed in metric units of measure, Excel can perform the calculations and display your metric data instantly, as you flow test. In fact, we will show you how to do just that in the examples below.
We will show you some very basic examples of Excel programming using Excel 97. You can find used versions of Excel at several sources like Ebay, Craig's list, garage and business sales.
This is how Excel looks. It is a grid of cells arranged in rows and columns. You can enter data items or labels in each of any cells. You can also program cells to process the data in other cells. When you want the contents of a cell to process data, you precede the contents of the cell with an equal (=) sign, as you will see in the example adding machine application below.
Excel Programming Examples
In the following example, we will program Excel to convert the flow data in cells A1 through D1, to metric units, and place the metric data into cells A4 through D4.
Sometimes Excel does not display your numerical data in a format that is appropriate for your data. You can tell Excel how to format your numerical data, for instance, we will tell Excel to display our metric data with only one decimal places to the right of the decimal point.