Selection Worksheets

Selecting an optimal material for a given product must obviously be based on analysis of the requirements to be met. A simplified approach involves comparing the specific service requirements to the potential properties of a plastic. What follows is a simplified but practical material-selection approach. This longhand system is a basis of the fastest computerized databases. 

It follows these steps (1) select the design criteria from a worksheet [Table 7-18(a)] and check off only the major criteria across the worksheet, keeping it simple but realistic (2) refer to the selection chart [Table 7-18(b)] and transfer the bold-faced numerical rating in each selected criteria column to the worksheet, for example, if toughness is one criterion, list 6,4,1, 2, 4, and 2 on the worksheet from top to bottom in the toughness column (3) add up the numbers across the worksheet 

Material Characteristics Strength and Stiffness Toughness Short-Term Heal Resistance Long-Term Heal Resistance Environ- mental Resistance Dimensional Accuracy in Molding Dimensions Stability Wear and Frictionat Properties Point Subtotal Cost Point Total 

Other Crystalline Resins Nylons 6 6/6 6/10.6/12 Polyester Polyacctal  

G/R Criteria Slrength Short-Term Long-Term Environ- Dimensional Wear and  

---

We want to make the worksheet easier to look at by separating the columns for the variables by vertical lines. Therefore we have first to insert columns. Move the cell pointer to appear in cell J6 select / Worksheet Insert Column. 

Appendix A lists selected worksheet functions in the Database, Date Time, Information, Logical, Lookup Reference, Math Trig, Statistical, Lookup Reference, and Text categories. Appendix B provides an alphabetical list of these worksheet functions along with the required syntax, some comments on the required and optional arguments, one or more examples and a list of related functions. 

Excel 2000 provides more than 300 worksheet functions, in 11 categories Engineering, Financial, Date Time, Information, Math Trig, Statistical, Lookup Reference, Database, Text, Logical, External. This book uses functions from seven of those categories. This appendix lists selected worksheet functions by category. In Appendix B, the functions are listed alphabetically, with comments, examples and related functions. 

Appendix B Alphabetical List of Selected Worksheet Functions... 

---