Excel with process variables

For statistical samples of small volume, an increase in the order of the polynomial regression of variables can produce a serious increase in the residual variance. We can reduce the number of the coefficients from the model but then we must introduce a transcendental regression relationship for the variables of the process. From the general theory of statistical process modelling (relations (5.1)-(5.9)) we can claim that the use of these types of relationships between dependent and independent process variables is possible. However, when using these relationships between the variables of the process, it is important to obtain an excellent ensemble of statistical data (i.e. with small residual and relative variances). 

On some control loops, a variable-speed drive on a pump, fan, or blower may be used as the final element connecting the controller output to the process. Variable-speed drives provide fast and linear response with little or no hysteresis and are therefore an excellent choice with respect to control performance. As the initial cost of variable-speed drives continues to decrease, their use should become a more widespread practice. 

In vitro models are probably the most widely used method of studying the de- and remineralisation of enamel. Their main strength is that experimental conditions can be very well defined and subsequently controlled throughout the duration of a study, e.g. pH, flow-rate, or solution composition. As such, they are particularly well suited to experiments whose objective is to study a single process in isolation, where a more complex situation with many variables may confound the data. An obvious disadvantage is that they cannot easily simulate the complex situation in vivo. However, the use of in vitro models for such studies is widely accepted and although further discussion is beyond the scope of this review, the topic is addressed by several excellent papers [1,2]. 

The models can be scaled to various sizes to fit the needs of the experiment. For example, a very small-scale nanofiltration system, such as a Planova P-15 hollow-fiber cartridge with O.OOl-m surface area (Asahi Kasei Corporation, Japan), can be used to study virus retention capabilities of a virus reduction step in a biological manufacturing process, whereas a scaled-up version of the same system with a surface area of 0.01 m provides an excellent way to study the nanofiltration process variables. In a nanofiltration validation study, a feed sample is typically spiked with a known quantity of a model virus. The mixture is filtered under the expected process... 

Some generally accepted rules, determined from experimental data, relate the CpK value with robustness. For example, a CpK of less than 0.8 is an indication that the process is not capable, as the acceptance criteria cannot be met routinely. Further work will need to be done to develop a more robust process. CpK values between 0.9 to 1.0 indicate a marginal process, between 1.0 and 1.25 are satisfactory, between 1.25 to 1.5 are good, and values greater than 1.5 are excellent. Using these measurements, it is possible to evaluate process variables and identify which variable has the least or most effect. However, a possible pitfall is to obtain excellent CpK values, but not to have an acceptable process because the mean value is not on target. The process developed needs to be reliable and consistently meet product specifications, to demonstrate it is manufacturable. Another pitfall is to aim for a CpK value much higher than 1.5, which is probably a waste of effort. The process does not have to be bombproof . 

Figure 21 Distribution Curves for Viscosity Variance before and after Quality Circle Project. Reducing variance (noise) is an excellent quality-improvement technique because the effects of various changes are seen much more clearly for processes with little variability. (From R. Cole, Work, Mobility, and Participation A Comparative Study of American and Japanese Industry. Copyright 1979 The Regents of the University of California. By permission)...

With this process it is possible to screen a very large number of variables to discover which have the greatest effect and then fine tune those with the greatest influence on the final properties with a more detailed experiment. This technique has been used with great effect to optimise compound properties and cure conditions in the development of all new components over a period of more than 10 years in the author s last place of employment. Coupled with similar techniques in mould design it has allowed the company to maintain a reputation for excellence with customers in the quality automotive field. 

As discussed, emulsion polymerization is an important indnstrial process. Miniemulsion polymerization is a rapidly anerging technology. Conversion of monomer to polymer is one of the most important process variables in batch or semibatch polymerization. This is affected by a series of variables among which impurities, oxygen in the system and poor inifiator (free radical) are typical ones. Attenuated total reflection (ATR)-UV spectroscopy was evaluated as a method for monitoring emulsion and miniemulsion polymerization of acrylates with excellent results [23]. 

Figure 6.27 shows that we crushed a fly with a steam-roller processed variable Cost in Excel using a special format of electronic worksheet which inserts thousands spacer, white space between three numbers, into numbers and thus, simplifying its reading. However, one can crush earnestly, for example, to access those Excel functions that Mathcad does not have (calendar functions) or to make Excel plot in Mathcad (pie chart). Besides, to enter data in Excel table is more convenient and quicker one can use special Excel features - AutoFit and others. 

Most induction ac motors are fixed-speed. However, a large number of motor applications would benefit if the motor speed could be adjusted to match process requirements. Motor speed controls are the devices which, when properly applied, can tap most of the potential energy savings in motor systems. Motor speed controls are particularly attractive in applications where there is variable fluid flow. In many centrifugal pump, fan, and compressor applications mechanical power grows roughly with the cube of the fluid flow. To move 80 percent of the nominal flow only half of the power is required. Centrifugal loads are therefore excellent candidates for motor speed control. Other loads that may benefit from the use of motor speed controls include conveyers, traction drives, winders, machine tools and robotics. 

In most natural situations, physical and chemical parameters are not defined by a unique deterministic value. Due to our limited comprehension of the natural processes and imperfect analytical procedures (notwithstanding the interaction of the measurement itself with the process investigated), measurements of concentrations, isotopic ratios and other geochemical parameters must be considered as samples taken from an infinite reservoir or population of attainable values. Defining random variables in a rigorous way would require a rather lengthy development of probability spaces and the measure theory which is beyond the scope of this book. For that purpose, the reader is referred to any of the many excellent standard textbooks on probability and statistics (e.g., Hamilton, 1964 Hoel et al., 1971 Lloyd, 1980 Papoulis, 1984 Dudewicz and Mishra, 1988). For most practical purposes, the statistical analysis of geochemical parameters will be restricted to the field of continuous random variables. 

---