Paste List

The Paste List command is useful for worksheet auditing and error tracing. It produces a list of all names used in the worksheet, with their references. 

Select the upper-left comer of the range in which you want the list to appear make sure that nothing will be over-written by the list. Choose Name... from the Insert menu and choose Paste... from the submenu, then press the Paste List button. 

Figure 3-24 shows an example of a list of names produced by Paste List. Inspection of the list shows that the names log pcKw and pcKw are duplicates. Of course, it s permissible to assign more than one name to the same reference, but in general it s not good programming practice. 

Figure 3-24. Using Paste List to audit a worksheet.

The procedure employed for developing the new list is different than previous methods. Candidate chemicals and hazardous substances other than oil were not taken from all known spill priority lists but only from materials known to have been spilled in the past 15 years. This was done to eliminate the possibility that chemicals that have never been spilled or have a low spill potential might be present on the new priority list, as occurred in the past list. The problem is that many lists contain materials that have no spill history. This is because these chemicals may not be transported or consumed in the form noted on the particular priority list, they may be a degradation or reaction product, or they may not be used commercially at the present time. Furthermore, there is an extensive spill history at this time, as evidenced by a sizeable database, and substances that have a potential for spillage are likely to be listed. Few new chemicals appear to be produced in high volumes. 

There are several types of basis functions listed below. Over the past several decades, most basis sets have been optimized to describe individual atoms at the EIF level of theory. These basis sets work very well, although not optimally, for other types of calculations. The atomic natural orbital, ANO, basis sets use primitive exponents from older EIF basis sets with coefficients obtained from the natural orbitals of correlated atom calculations to give a basis that is a bit better for correlated calculations. The correlation-consistent basis sets have been completely optimized for use with correlated calculations. Compared to ANO basis sets, correlation consistent sets give a comparable accuracy with significantly fewer primitives and thus require less CPU time. 

Aniline prices in the past have been sensitive to the balance between supply and demand in the industry and this trend is likely to continue in the next decade. List prices in the early 1980s began at 0.97/kg, but declined to a low of 0.64/kg as a result of industry overcapacity. By the end of 1987, prices had reached 1.30/kg, and the price has remained firm due to strong demand for aniline. 

Formulator s Dilemma. The regulatory discussion included a listing of solvents designated as HAP compounds. Emissions of these solvents are to be significantly reduced. For many appHcations this means that less is to be allowed. In a situation where the allowed VOC emission levels are also being reduced, the formulator would like to use the most effective solvents available. In the past, MEK and MIBK were frequently used as active solvents and aromatic hydrocarbons as diluents. These solvents have been popular because they are cost-effective. 

The type of evaporator to be used and the materials of construc tion are generally selected on the basis of past experience with the material to be concentrated. The method of feeding can usually be decided on the basis of known feed temperature and the properties of feed and produc t. However, few of the listed variables are completely independent. For instance, if a large number of effects is to be used, with a consequent low temperature drop per effect, it is impractical to use a natural-circiilation evaporator. It expensive materials of construction are desirable, it may be found that the forced-circulation evaporator is the cheapest and that only a few effec ts are justifiable. 

In 1974, the Harmonized Monitoring Programme was set up by the Department of the Environment (DoE). The objective was to provide a network of sites at the lower end of catchments, where water quality data could be collected and analysed in a nationally consistent manner, allowing the loads of materials carried through river catchments into estuaries to be estimated and long-term trends in river quality to be assessed. The complete list of substances to be monitored is diverse and specifies about 115 substances. The pesticides aldrin, dieldrin, y-HCH, heptachlor, p,p -DDT and p,p -DDE are included. Figures 1 and 2 show the downward trend of y-HCH and dieldrin over the past 20 years at the Harmonized Monitoring Sites. This confirms that reductions in environmental concentrations have been achieved, particularly over the past 10 years. 

Can they provide a list of solid wastes generated from operations within the past year ... 

Listed below are eompanies that have provided hardware, serviees, information, or data used by the authors in eonjunetion with work involving turboexpanders. Their past and present eontributions are gratefully aeknowledged. 

Reporting Is required to provide the public with information on the releases of listed toxic chemicals from your facility to the environment during the past calendar year. Facilities must report the quantities of both routine and accidental releases of listed chemicals, as well as the maximum anrx>unt of the listed chemical on-site during the calendar year and the amount contained in wastes transferred off-site. 

Against this background of the changed economics of plant performance, we consider some of the many new gas turbine plants that have been proposed over the past few years. In this section, we first formulate a list and classify these plants (and the cycles on which they are based), as in Tables 8.1A-D, noting that most but not all use natural gas as a fuel. 

Because of their central importance in chemistry, atomic weights have been continually refined and improved since the first tabulations by Dalton (1803 -5). By 1808 Dalton had included 20 elements in his list and these results were substantially extended and improved by Berzelius during the following decades. An illustration of the dramatic and continuing improvement in accuracy and precision during the past 100 y is given in Table 1.3. In 1874 no atomic weight was quoted to better than one part in 200, but by 1903 33 elements had values quoted to one part in 10 and 2 of these (silver and... 

During the past 20 y numerous other highly coloured halogen cations have been characterized by Raman spectroscopy. X-ray crystallography, and other techniques, as summarized in Table 17.18. Typical preparative routes involve direct oxidation of the halogen (a) in the absence of solvent, (b) in a solvent which is itself the oxidant (e.g. AsFs) or (c) in a non-reactive solvent (e.g. SO2). Some examples are listed below ... 

Each era of medicinal chemistry has been marked by intensive concentration on some structural type in a large number of laboratories. One need only look back in this book to the tables of sulfonamides, barbiturates, and thiazide diuretics, noting the small time span covered by the references to each list. The benzodiazepines have provided such a focus for the past decade. 

The atmospheric corrosion data in Table 4.34 (and also Table 13.8) is related to historic environments. Current use in the industrial areas listed with acidic pollution would show much lower corrosion rates as the corrosion of zinc in the atmosphere is essentially related to the SOj content (and the time of wetness) and in many countries the sulphurous pollution has been greatly reduced in the past 20 years. Zinc also benefits from rainwater washing to remove corrosive poultices thus, although initial corrosion rates are usually not very different on upper and lower surfaces, the latter tend —with time—to become encrusted with corrosion products and deposits and these are not always protective. 

---