Spreadsheets templates

Spreadsheet template that calculates expected VOC emissions from use of paints, inks, and coatings. Prints out I PA data forms. 

Validation also applies to software. In a simple example, you could create an Excel spreadsheet template with fixed formulae to calculate the mean and standard deviation of a range of data. To validate this template you would enter a set of sample data and verify the template-calculated results against the manually calculated results. In order to be confident that the template could be used for further data sets you would password-protect the cell formulae and verify that they cannot be altered without it. 

A Microsoft Excel (Version 5.0 or higher) spreadsheet template form has been developed which allows the calculation of the complete reaction mass efficiency (RME) according to equation (4.1) and raw material cost (RMC) for any chemical transformation. Lines are numbered and line instructions are embedded in the same manner as a personal income tax form. Green metrics are evaluated to determine the greermess of the experiment in a rigorous quantitative way and to determine the bottom line cost of carrying out the experiment. Formula entries are inserted in appropriate cells to facilitate computation. Any... 

Many times, hand calculations are performed with the aid of calculators, spreadsheet templates, or a basic computer program to make the process easier. For example, the hand calculations in Chapter 5 have been computerized for easier use (Hughes Associates, 2002). 

Once process design is complete and each of the process steps characterized, the process is ready for scale-up to pilot or manufacturing scale. A spreadsheet template for scale-up calculations is important and provides a mass balance of buffer volumes, column volumes, priming volumes, product volumes, and waste volumes as well as the tank size and column size. Product volumes can be expressed relative to column volume or can be calculated from a constant concentration, depending on the process step. In addition, starting volumes and titers of conditioned medium as well as step yields and gel or membrane capacity are necessary to cal-... 

The intent of this book is not simply to provide a series of templates that can be applied to particular situations (although there are lots of useful spreadsheet templates, macros and other tools on the disk that accompanies this book), but to show how you can create your own spreadsheets or macros to solve completely different chemical problems. 

The problem table to find the minimum utility requirements and the pinch temperature can be built in a spreadsheet. The calculations in each cell are repetitive, and the formula can be copied from cell to cell using the cell copy commands. A spreadsheet template for the problem table algorithm is available in MS Excel format in the online material at http //books.elsevier.com/companions. The use of the spreadsheet is illustrated in Eigure 3.31 and described here. 

Most cost-estimating and economic analysis calculations are easily carried out using spreadsheets. Templates are introduced in the examples throughout the chapter. Blank templates are given in Appendix G and in the online material at http //books. elsevier.com/companions. The more sophisticated software that is used in industry for preliminary estimating is discussed in Section 6.3. 

Many of the calculations described in the book can be performed using spreadsheets. Templates of spreadsheet calculations and equipment specification sheets are available in Microsoft Excel format online and can be downloaded by all readers of this book from http //books.elsevier.com/companions. 

Some computer exercises will be discussed briefly in this section. They serve as laboratory exercises for the second semester of physical chemistry sequence when quantum chemistry is taught. These computer exercises are also used in the lecture demonstration format. Sometimes they are given as extended problem assignments. Four software packages are used to various degrees in these exercises BASIC programs, spreadsheet templates, Mathematica, and Mathcad. 

QuickBASIC programs, spreadsheet templates, and Mathcad documents have been prepared for all of the exercises.Figures 17, 18, and 19 show the user interfaces for the BASIC, spreadsheet, and Mathcad environments. Because the programming is easier on spreadsheets and with Mathcad, these appear to be most promising in this application. 

A single spreadsheet template or Mathcad document can be used for all one-dimensional problems. One simply re-programs the cells containing the potential energy in the spreadsheet template or edits the equation for the... 

B. l Construction of spreadsheet templates to manipulate the coded information. 

In the present case, the qneaddieet is prepared by using Lotus 1-2-3. No computer programming skills are requited to prepare a spreadsheet template like the one shown in Fig. 7.1. The figure is a shortened version listing three of the polymers contained in the actual worksheet. A step-by-st procedure for preparing this spreadsheet demonstrates the ease with whidi it can be done, those completely unfamiliar with spreadsheet enviromnents, it is teomunended that the user s reference manual be consulted.)... 

---