Excel worksheets

Note that the EXCEL engine specification is optional, because SAS would read the .xls extension in the physical filename and assume it indicates a Microsoft Excel file. Also note that the xlsfile libref refers to the entire Excel workbook. In the subsequent PROC PRINT, the normal ranges must be specified so SAS will know which Excel worksheet to read. The data set/worksheet name in the PROC PRINT looks odd because of the existence of a special character, which is normally not allowed as part of a data set name. 

After you click Next, a Select Table window pops up, allowing you to enter a name for your Excel worksheet. We call the worksheet DM in this example, as follows ... 

In this work the cases in the database are stored on their own MS-Excel worksheets. The stored cases are copied on a retrieval calculation data sheet during the retrieval phase. All retrieval parameters in this application are textual string parameters. Thus the comparison between casebase and input problem is simple. When the input value is equal with the case value, the distance is 1, otherwise the distance is 0. The weighted suitability of parameters is then calculated by Equation 9. The weighting factors are introduced by the user. Overall suitability is calculated by Equation 10. Cases are ranked according to their overall suitability and the five nearest cases are shown for the user on an output worksheet. 

We give only a short description of the three supply chain configurations and their simulation models for details we refer to Persson and Olhager (2002). At the start of our sequential bifurcation, we have three simulation models programmed in the Taylor II simulation software for discrete event simulations see Incontrol (2003). We conduct our sequential bifurcation via Microsoft Excel, using the batch run mode in Taylor II. We store input-output data in Excel worksheets. This set-up facilitates the analysis of the simulation input-output data, but it constrains the setup of the experiment. For instance, we cannot control the pseudorandom numbers in the batch mode of Taylor II. Hence, we cannot apply common pseudorandom numbers nor can we guarantee absence of overlap in the pseudorandom numbers we conjecture that the probability of overlap is negligible in practice. 

Table 11.2. Excel worksheet and matrix for determining Fig. 11.3 s 820 K (level L) gas quantities. In refers to feed, out refers to level L. The results are the only quantities that satisfy all the equations in the matrix. Cell H17 contains the equation above and beside it. The matrix has been solved as described in Appendix H. After an initial solving, a change in any matrix cell value causes automatic calculation of a new matrix result. 

The calculations are done in Excel worksheet Table D.l. The calculation sequence is ... 

This appendix shows how 3-catalyst-bed converter calculations are done. Three areas in the same Excel worksheet are used, Tables S.l, S.2 and S.3. The 3 beds are linked by kg-mole SO3, S02, 02, N2 and C02 passing between beds 1 and 2 and beds 2 and 3. 

Table U.l. Excel worksheet for calculating after-H2S04-making heatup path/equilibrium curve intercept with S03 and CO, in innnt one... 

An Excel worksheet consists of 256 columns (labeled A, B, C,. .. IV) and 65,536 rows (labeled 1, 2, 3,. ..). The rows and columns define cells (A1, H27, etc.), which constitute the worksheet. Information can be entered into a cell from the keyboard after the cell has been selected, usually with the mouse pointer. Data can also be entered into a cell, or many cells, by calculation. The Excel 2000 for Windows document window is shown in Figure 1-1. Depending on your monitor, your screen may show a different number of rows or columns. 

This chapter demonstrates how to create and use a database on an Excel worksheet. Although database software such as Filemaker or Access is superior to Excel, it is sometimes useful to be able to combine the features of a database with Excel s superior calculation and data analysis features. 

A rectangular range of data in an Excel worksheet can be used as a list or database. A database consists of a number of records, each of which can contain a number of fields. For example, a compilation of physical properties of organic compounds, such as the one in the CRC Handbook of Chemistry and Physics, is a database the row of data for a particular compound is a record and the values for the melting point, boiling point, solubility, etc. are the data fields within the record. In Excel, a list or database must be arranged in tabular form, with row or column labels that s the only requirement. 

There are 12 database functions that return information about the records in a database DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR and DVARP. Some of these are particularly useful and are described here. See Microsoft Excel Worksheet Function R erence or Excel s On-Line Help for further information. 

Since you use Excel largely for the analysis of experimental data, the problem of how to get that data into Excel is crucial. Certainly you don t want to spend time transcribing data from a piece of paper into an Excel worksheet. There are several ways of transferring data to Excel. In order of decreasing preference, they are ... 

Macro programming was introduced in Excel 4.0. A macro written in Excel 4.0 Macro Language (XLM) is a series of statements or commands cn an Excel macro sheet, which looks much like an Excel worksheet, with rows and columns. Macro statements in XLM can use any of Excel s worksheet functions, but in addition there are over 400 macro functions that can be used. Macros written in XLM can still be run in Excel 2000. 

In an Excel worksheet, you have to use Define Name or Create Name to assign a name to a variable, but variable names in VBA are automatically assigned as you type the VBA code in a module. There are just a few rules for naming variables or arguments ... 

VBA supports If...Then and If...Then...Else or Elself structures, very similar to the Excel worksheet function IF. In addition, VBA provides the Select Case decision structure, similar to the ON value GOTO statement in BASIC. 

Modify the Excel worksheet of Figure 3-15 to compute the molar mass of compounds containing (a) three elements and (b) five elements. 

An example of a VBA code that retrieves the status of a record and writes it to a cell in a Microsoft Excel worksheet may look like the following ... 

The code declares and instantiates an SDK object (sdk), defines its Transmission Control Protocol (TCP)/1P communication port (8288), retrieves the record number from cell A2 in the Excel worksheet, calls the SDK function with this parameter to retrieve the status of the corresponding record, and writes it to cell B2. 

Exporting data. The numerical data that give origin to a map can be exported as an Excel worksheet. This will include raw data and residuals data of all map layouts,... 

Image and data exporting. As with genomic maps, any part of the gene view layout can be selected and copied into another application. Also, numerical data associated with filtered ORFs can be exported as Excel worksheet by clicking on the ORF set at the Tab Filtered window with the right mouse button. 

Free (wash) solution was removed from the filter with filter paper, positions A12 and HI marked with ball point (not a felt pen ). The filter was placed in a closely fitting box, 10 ml of substrate solution was added and incubated for 1 min. The filter was wrapped, straight from the substrate in plastic, without air bubbles. Liquid pressed out, the filter transferred in plastic into the luminometer cassette and placed in the luminometer. Luminescence was measured according to the required program. Data were collected in a file and for each sample the level of N7-HETE-dG/107 nucleotides was calculated (in an Excel worksheet). 

Write an Excel worksheet that will convert a list of distance measurements in meters to miles, feet, and inches. If the length in meters is typed into a cell in column A, let the corresponding length in miles appear on the same line in column B, the length in feet in column C, and the length in inches in column... 

---