Spread sheet

This folder contains three files bnlgener.xls, bnlgener.wql, and referen.txt. The database, bnlgener is an eclectic collection of 1,311 failure rates from 31 references. The database is provided as a spread sheet in the Microsoft Excel 4 format (xls) and in Corel Quatro-Pro format (wql). Tbis information is not provided in ASCII because of format... 

The SMAC data format is identical for all programs numbers are written with decimal points and are separated by commas the format can be imported into word-processing and spread-sheet programs under the. dat or the. txt option. 

Purpose Create a new SMAC data file or edit/modify an existing one import (parts of) an existing Excel spread sheet and convert to SMAC format. 

MASSBAL EXAMPLE USING SPREAD SHEET AS-EASY-AS TO SOLVE EQUATIONS... 

Step 9 Change the values of the appropriate split fractions, or fresh feeds, in the primary table, Figure 4.15, and observe the changes to the calculated values which will carry through the spread sheet automatically. Iterate on the values until the desired result is obtained. 

Solve the equations using a suitable spread-sheet. 

This sequence was then repeated with a different titer composition as many times as necessary to cover the required range of amphiphile/water compositions. An MS-DOS desk-top computer with 640K of random-access memory (RAM) was used to control the calorimeter and to collect thermistor voltages at the fixed time intervals. Spread-sheet macros running on this same computer were used to make various plots, including thermistor voltage y . time and corrected heat ys time. 

Although the process to determine KlA and K is possible with a spread sheet, it is cumbersome for commercial specifications. The guidehne for the testing of commercial aeration devices has been well developed and is generally available (American Society of Civil Engineers, 1992). There is no requirement to measure total dissolved gas pressure or estimate dissolved nitrogen concentration, and an... 

Export data into an Excel spread sheet and determine the signal-to-noise/area under the curve for each oligomeric species (see Note 11). 

There are many HAZOP report shells which are sold to do this job, but they are easy to generate in a word processor or spread sheet. A typical page is shown in Figure 3. Make sure that hazards and actions are uniquely identified by a numbering system, so that they can be referenced by future reports and rapidly retrieved if required. 

With mixtures of substances, thick spread sheets may persist for a very long time (Hardy, Proc. Ray. Soc. A, 88, 316 (1913)). This is familiar when paraffin oil is spilt on puddles, and is of vital importance in killing mosquito larvae on water. 

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

The appropriate means, medians and standard deviations will be displayed. (You might also want to try setting up a spread-sheet to perform the full calculations for the SD as shown in Table 2.4, just to reinforce exactly how this is derived.)... 

Probably the commonest way to collect data and perform simple manipulations is within a Microsoft XL spread-sheet. Consequently, the most obvious way to carry out statistical analyses of such data would seem to lie within XL itself. Let me give you my first piece of advice. Do not even consider it The data analysis procedures within XL are rubbish - a very poor selection of procedures, badly implemented (apart from that, they are OK). If anybody in the Microsoft Corporation had a clue, they could have cleaned up in this area years ago. The opposition is pretty feeble and a decent statistical analysis package built into XL would have been unstoppable. 

A Solve the following set of linear equations using a spread sheet program, MathCad, Matlab, or a related package ... 

C Create an x-y graph for the following data points, labeling the axes properly, via a spread sheet, MathCad, or a related program... 

Spread-sheet software has become an indispensible tool to engineers because of the availability on personal computers, ease of use, and adaptability to many types of problems. An example of spread-sheet application to a problem typical of chemical process design is presented later in this chapter. 

Spread-sheet software has achieved great popularity because of its availability for microcomputers at reasonable cost, the ease of learning and using the software, and its flexible application to many problems. Solutions for many engineering problems can be obtained more rapidly by spread sheet than by writing a language code program, such as FORTRAN or BASIC. 

The term spread sheet refers to the row and column organizational form of the input and output of the software. Key features of spread-sheet software that are necessary or desirable for engineering problem solving include ... 

ASCII data files (for easy transportability of data into and out of the spread sheet)... 

Iteration (repeat of the calculations automatically or under user control) Multiple buffers (accommodation of several spread sheets at once)... 

Mass balances are to be solved for this process. Perfect separation between methanol and the reactants is assumed. Unreacted reactants are recycled to the reactor to improve their utilization. The recycle stream within the process complicates solving the mass balances, for there is a circularity in the logic of the solution. The mass balance equations must be solved simultaneously rather than singly, or solved iteratively, as is done with a spread sheet. 

It is recommended that the spread-sheet solution be built up by increments rather than trying to solve the complete problem in a single step. As an illustration, this example will be solved first without the complication of the recycle, then the recycle will be added... 

Spread-sheet columns are labeled with lowercase letters and rows by numbers. A combination of a lowercase letter and a number identifies a cell in the spread sheet and represents the number stored in that cell e.g., b3 indicates the cell at the intersection of column b and row 3, and when used in an equation, b3 stands for the numerical value stored in that cell. The spread-sheet location is used here to represent unknown quantities. 

The data and equations are entered into locations in the spread sheet as follows The first five rows are used for labels and constants the first column is used for labels and stream numbers. Each location that will contain a number is initialized to zero. The value 100, the carbon monoxide feed rate in mol/h,... 

---