Spreadsheet formula mass

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

Prepare a spreadsheet similar to the one shown in Figure 3-7 for the gravimetric determination of nickel using dimethylglyoxime. See Section 37B-3 for details. Use the worksheet from Problem 3-9 to calculate the molar mass of Ni(DMG)2 if it is available. 3-4. Write an Excel formula using the FIND and MID functions to eliminate the square brackets and the uncertainty from the atomic mass of lithium in the lUPAC table and display the numeric characters of the atomic weight. 

Compound name and location in a 96-well plate are provided in the form of an Excel spreadsheet. The software then accesses the corporate database and retrieves the empirical formula for each compound (Figure 13.2). Expected mass-to-charge ratio miz) values for the [M -+ H]+ or [M — HJ ions are calculated and take into account that the formula may represent a salt form. Sample information along with the list of expected m/z values... 

From the way in which you designed the spreadsheet, the atomic masses are listed in column C in order of increasing atomic number. Thus, Cl contains the atomic mass of H, C6, that of C, and so forth. If you start to remember the atomic numbers of most of the elements, say, A1 is 13, then obviously you recognize that its atomic mass value is in cell C13. The calculation of the molecular mass of NaCl can be obtained Ifom the formula +C11 + C17. 

Figure 6.11 illustrates an Excel spreadsheet that we develop to do the mass balance calculations. We have included all of the Excel spreadsheets mentioned in the DVD accompanying this book. Although we have developed the spreadsheet and the formulas for a specific HCR process, the reader can generalize the steps described above and apply the spreadsheet to do mass balance of any HCR process with only minor changes. 

---