Data in 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. 

To use worksheet functions, enter the tablet erythromycin contents from Table 2.4 into the first two columns of an Excel spread-sheet (assume titles in A1 and B1 and the two sets of data in A2 A11 and B2 B11), and then enter the following formulae into A12 A14 and B12 B14 ... 

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. 

In addition, it is possible to reference data in another spreadsheet file, for example [First.xls]Result A3 refers to die address of cell A3 in worksheet Result and file First. This might be potentially useful, for example, if the file First consists of a series of spectra or a chromatogram whereas the current file consists of the results of processing die data, such as graphs or statistics. This dexibility comes with a price, as all files have to be available simultaneously, and is somewhat elaborate especially in cases where files are regularly reorganised and backed up. 

Sometimes you ll want to protect data in a worksheet, either from changes by other users, or changes entered accidentally by yourself. 

Although only one worksheet at a time can be the active window. Excel provides a number of ways to examine data in several different worksheets, or different areas of the same worksheet, at the same time,... 

As your worksheets get larger and more complicated, it becomes impossible to view all of a single worksheet at one time, or even all cells in one row or column at one time. Excel provides several convenient ways to display separate portions of a single worksheet on the screen at the same time, so that you can view one part while entering or changing data in another part. 

There are two ways to create a chart either as a separate chart sheet in a workbook, or as a chart embedded in a worksheet, so that you can see both the data and the chart at the same time. An embedded chart is useful if you want to see how a curve changes as you change its parameters. As you change the values in worksheet cells, the chart will update automatically. 

The column headings were copied and pasted into row 1 of another worksheet. In this second worksheet, the table of data was sorted by means of the following formulas, using the data in column J as the "sortkey". 

Any text element in a chart Ccin be linked to a worksheet cell, causing the text in the worksheet to be displayed in the chart. (Some of this can be done automatically, as, for example, category labels.) But chart titles or unattached text boxes can also be linked to the worksheet. In this way titles can be generated automatically, or explanatory notes in text boxes can include information that will change as the data in the worksheet is modified. 

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. 

A convenient way to edit existing records or enter new data in a database is by using Excel s Data Form. The database range must already have been defined, either by using Set Database or by selecting a cell within the block of cells that comprise the database. Choose Form... from the Data menu. The Data Form dialog box will appear, with the name of the worksheet in the title bar, as in Figure 6-9. 

The data in the worksheet on page 52 are based on the performance of a sample of the examinees who took this test in November 2000. This sample was selected to represent the total population of GRE Chemistry Test examinees tested between October 1998 and September 2001. The numbers in the column labeled P+ on the worksheet indicate the percentages of examinees in this sample who answered each question correctly. You may use these numbers as a guide for evaluating your performance on each test question. 

With the definition given in Equation 5-2, we can now use Excel to determine the deviation from the mean of each of the data in our worksheet. Click on cell C2 and type... 

We have now constructed a general-purpose spreadsheet that you may use to make basic statistical calculations. To complete this part of the exercise, select a convenient location, construct a formula to display the number of degrees of freedom, and then add a label in an adjacent cell to identify this important variable. Save the file for future use in problems and laboratory calculations. Use the spreadsheet now to check the calculations in Example 6-1. To clear the data from your worksheet, just click and drag to highlight cells B2 B7, and. strike [Delete]. Alternatively, you may simply click on B2, and begin typing the data. Terminate each piece of data with [ J]. Be sure to delete the data in cells B7 D7. 

The Remedial Action Priority System (RAPS) and Multimedia Environmental Pollutant Assessment System (MEPAS) are different names for an objective exposure pathway evaluation system developed by Pacific Northwest Laboratory to rank chemical and radioactive releases according to their potential human health impacts. Constituent migration and impact are simulated using air, groundwater, overland, surface water, and exposure components based on standard assessment principles and techniques. A shell allows interactive description of the environmental problem to be evaluated, defines required data in the form of problem-specific worksheets, and allows data input. The assessment methodology uses an extensive constituent database as a consistent source of chemical, physical, and health-related parameters. 

The user can either print copies of blank worksheets or start interactively entering the required data. Completed worksheets also can be printed. In the Environmental Survey, these data sheets are being used for data accuracy site reviews and, upon completion, as file copies. 

An example of a data template/worksheet is shown in Figure 4. In addition to a line description of each datum required, several other characteristics should be noted. The first line tells the user the... 

Using the Visual Basic computer program described in Appendix B.1-2, the DOS-ba.sed program PRl described in Appendix B.II-I. the MATHCAD worksheet described in Appendix B.lll, or the MATLAB program described in Appendix B.JV and the data in Table 4.6-1, we obtain the following ... 

Run the Herman-Skillman program for the boron atom using the atomic data in Table 1.3. Then transfer the output mesh and rR r) data for each atomic orbital to a new worksheet in a new spreadsheet. Paste the data, as text, into columns A and B starting from cell A 9 as in Figure 1.19. Parse the text data into individual columns of r and rR r) values. 

---