Spreadsheet program

The dBASEIV (ordBASEIIT) form of th e parameter sets come in ld( /filcs analogous to the Tt,v( files. Th ese dbf files are bin ary files, so yon can t read them directly. They arenot retpiired for the product and are provided only as an option. In most situations where there is no exten sive use of database operation s on parameter sets, the text form is probably more convenient to use. Many spreadsheet programs, including Microsoft Excel, are also capable of reading files. 

A typical plot of x vs./(x) is considered to have one coordinate dimension, the X, and one data dimension,/(x). These data sets are plotted as line graphs, bar graphs, and so forth. These types of plots are readily made with most spreadsheet programs as well as dedicated graphing programs. Figure 13.1 shows two graphs that are considered to have a one-dimensional data space. 

Donato, H. Metz, G. A Direct Method for the Propagation of Error Using a Personal Gomputer Spreadsheet Program, ... 

Spray-up process Spreading Spreading agents Spreadsheet programs Sprengel mixture SprintNet... 

Spreadsheet programs were originally developed for bookkeeping and business-planning appHcations over time, many additional features were added. Visica/c, which appeared in the early 1980s, was the first spreadsheet program it was developed for Apple computers. 

A spreadsheet program is intuitive in its operation and can immediately show the effect of any one change throughout the whole spreadsheet. It is thus a subtie form of data vaHdation an error may be spotted immediately. Furthermore, when a material balance is set up, the total effect caused by a change in one variable may be seen at once. 

Current spreadsheet programs contain many advanced capabiUties and enhancements that an engineer might want to use they also offer improved performance, interfaces to data base and word-processing programs and have a host of other features. A good overview that describes the features and presents what is available in each of the latest spreadsheet packages on the market is available (78). 

To develop the skills of in-house personnel, as mueh repair work as possible should utilize plant personnel. Eneouraging the partieipation of the maehinist in the solution of diffieult problems often results in the maehinist seeking information on his own. Referenees to API and ASME speeifieations should not be uneommon on the shop floor. Today s maehinist and meehanie must be eomputer literate. Internet training must be provided with some basie training on word proeessing and spreadsheet programs. 

The Mierosoft Exeel spreadsheet program REACTOR.xls was used to eompute the volumes of the CFSTR, plug flow reaetors, and the ratio of the volumes for fraetional eonversions of 20%, 30%, 40%, 50%, 60%, 70%, 80%, 90%, and 95% for a first order reaetion. Table 5-14 shows the volumes of the CFSTR, plug flow reaetors, and the ratio of the volumes at given eonversion levels. 

An Excel spreadsheet program (Example6-2.xls) was developed for this example. 

An Exeel spreadsheet program (PACKED.xls) was developed to determine APs of paeked beds with known parameters. 

An Excel spreadsheet program (Example 7-l.xls) was developed to determine the theoretical power of any agitator type with given fluid physical properties and tank geometry. 

This shows that a much larger initial charge will he required. An Excel spreadsheet program (EXAMPLE12-l.xls) was developed for this example. 

The heat balance exercise provides a tool for in-depth analysis of the unit operation. Heat balance surveys determine catalyst circulation rate, delta coke, and heat of reaction. The procedures described in this chapter can be easily programmed into a spreadsheet program to calculate the balances on a routine basis. 

Has trending and reporting ability. Data can be dumped to a spreadsheet program and variables plotted against one another. 

STRATEGY We need to plot the natural logarithm of the reactant concentration as a function of t. If we get a straight line, the reaction is first order and the slope of the graph is —k. We could use a spreadsheet program or the Living Graph Determination of Rate Constant (first-order rate law) on the Weh site for this book to make the plot. 

Here again, no precise instructions can be given because each situation will demand a tailored approach. Note Numerical simulation in many ways resembles the what-if scenario technique available in spreadsheets programs. Several programs supplied with this book allow the reader to play with functions and noise levels.)... 

The amounts of sulfentrazone, SCA (analyzed as DMS), and HMS were quantitated by an external standard calibration method. A computer spreadsheet program (Microsoft Excel) was used for calculation and reporting. 

Most of the algorithms and formulae discussed in this chapter can be implemented as expressions in computer spreadsheets, and the rest as simple computer programs. Most are also incorporated into the Microsoft Excel spreadsheet program by the Isoplot add-in (Ludwig 1999, in press) as user-available functions and graphical routines (Appendix III). 

A) Measure the positions and amplitudes of all the lines in the spectrum and list them in order in a table (a spreadsheet program is convenient for this purpose). A well-defined measure of position in a complex spectrum is the x-axis point halfway between the maximum and minimum of the first-derivative line. The amplitude is the difference in height between the maximum and minimum. If convenient, measure the line positions in gauss if this is inconvenient, use arbitrary units such as inches, centimeters, or recorder chart boxes measured from an arbitrary zero. In your table, also provide headings for the quantum numbers (m1 m2, etc.) for each of the line positions, for the coupling constants (a, a2, etc.), and for the theoretical intensity (degeneracy) of each peak. 

Computer Methods These methods are easily programmed in a spreadsheet program such as Microsoft Excel. In MATLAB, the trapezoid rule can be calculated by using the command trapz(x,y), where x is a vector of x values and y is a vector of values /(%.). Alternatively, use the commands... 

---