Some unusual applications of the `Error-bar` feature in Excel spreadsheets

This paper demonstrates how the "error-bar" feature can be used to extend the utility of "worldware" spreadsheet packages in producing high-quality graphs for university teaching and learning, and for research. To further utilize the advantages of spreadsheets in university education, this paper seeks to overcome some of the earlier reservations about the lack of scientific plotting capabilities of spreadsheet applications. Specific examples of educational material in the areas of enzyme kinetics, vibrational spectroscopy, vibronic spectroscopy, and mass spectrometry are discussed. It is argued that, where practical, university educators should use "worldware" packages to prepare teaching aids, since these would better prepare their students for future employment. The use of software features for purposes that were not envisioned by the programmers has additional educational benefits in fostering flexibility and innovation. Other graphing packages can also use the "error-bar" feature in a manner similar to that described here for Excel.

The salt wedge position in a bar-blocked estuary subject to pulsed inflows

A series of laboratory experiments were carried out to investigate the response of a bar-blocked, saltwedge estuary to the imposition of both steady freshwater inflows and transient inflows that simulate storm events in the catchment area or the regular water releases from upstream reservoirs. The trapped salt water forms a wedge within the estuary, which migrates downstream under the influence of the freshwater inflow. The experiments show that the wedge migration occurs in two stages, namely (i) an initial phase characterized by intense shear-induced mixing at the nose of the wedge, followed by (ii) a relatively quiescent phase with significantly reduced mixing in which the wedge migrates more slowly downstream.

Provided that the transition time t_T between these two regimes satisfies t_T>g′h⁴L/q³α, as was the case for all our experiments and is likely to be the case for most estuaries, then the transition occurs at time t_T=1.2(gα³L⁶/g′³q²)^1/6, where g′=gΔρ/ρ0 is the reduced gravity, g the acceleration due to gravity, Δρ the density excess of the saline water over the density ρ₀ of the freshwater, q the river inflow rate per unit width, and L and α are the length and bottom slope of the estuary, respectively.

A simple model, based on conversion of the kinetic energy of the freshwater inflow into potential energy to mix the salt layer, was developed to predict the displacement xw over time t of the saltwedge nose from its initial position. For continuous inflows subject to t<t_T, the model predicts the saltwedge displacement as x_w/h=1.1 (t/τ)^1/3, where the normalizing length and time scales are h=(q²/g)^1/3 and τ=g′α²h4L/q³, respectively. For continuous inflows subject to t>tT, the model predicts the displacement as xw/h=0.45N1/6(t/τ)1/6/α, where N=q²/g′h²L is a non-dimensional number for the problem. This model shows very good agreement with the experiments. For repeated, pulsed discharges subject to t<t_T, the saltwedge displacement is given by (xw/h)3−(x0/h)(xw/h)2=1.3t/τ, where x₀ is the initial displacement following one discharge event but prior to the next event. For pulsed discharges subject to t>t_T, the displacement is given by (xw/h)⁶−(x0/h)(xw/h)⁵=0.008N(t/τ)/α⁶. This model shows very good agreement with the experiments for the initial discharge event but does systematically underestimate the wedge position for the subsequent pulses. However, the positional error is less than 15%.

Numerical investigation of austenite grain size distribution in square-diamond pass hot bar rolling

In this study, the austenite grain size (AGS) for hot bar rolling of AISI4135 steel was predicted based on two different AGS evolution models available in the literature. In order to predict the AGS more accurately, both models were integrated with a three-dimensional non-isothermal finite element program by implementing a modified additivity rule. The predicted results based on two models for the square-diamond (S-D) and round-oval (R-O) pass bar rolling processes were compared with the experimental data available in the literature. Then, numerical predictions depending on various process parameters such as interpass time, temperature, and roll speed were made to compare both models and investigate the effect of these parameters on the AGS distributions. Such numerical results were found to be beneficial to understand the effect of the microstructure evolution model on the rolling processes better and control the processes more accurately.

Analytical model of pass-by-pass strain in rod (or bar) rolling and its applications to prediction of austenite grain size

Rod rolling is a process where the deformation state of the workpiece between the work rolls is quite different from the strip rolling process. However, in most microstructure evolution models, the simple area strains (natural logarithm of the area reduction ratio) multiplied by a constant have been used to compute pass-by-pass evolution of austenite grain size (AGS) in rod (or bar) rolling, without any verification. The strains at a given pass play a crucial role in determining the recrystallization behavior (static or dynamic). In this study, an analytical model that calculates the pass-by-pass strain and strain rate in rod rolling has been developed and verified by conducting four-pass (oval–round) bar and plate rolling experiments. Numerical simulations have then been carried out for the four-pass rolling sequence using the area strain model and the new analytical model, focusing on the effect of the method for calculating the strain on the recrystallization behavior and evolution of AGS. The AGS predicted was compared with those obtained from hot torsion tests. It is shown that the analytical model developed in this study is more appropriate in the analysis of bar (or rod) rolling. It was found that the recrystallization behavior and evolution of AGS during this process were influenced significantly by the calculation method for the deformation parameters (strain and strain rate). The pass-by-pass strain obtained from the simple area strain model is inadequate to be used as an input to the equations for recrystallization and AGS evolution under these rolling conditions.

Integrated model for thermo-mechanical controlled process in rod (or bar) rolling

This study presents an integrated model for computing the thermo-mechanical parameters (cross-sectional shape of workpiece, the pass-by-pass strain and strain rate and the temperature variation during rolling and cooling between inter-stands) and metallurgical parameters (recrystallisation behaviour and austenite grain size—AGS), to assess the potential for developing “Thermo-Mechanical Controlled Process” technology in rod (or bar) rolling, which has been a well-known technical terminology in strip (or plate) rolling since 1970s.

The advantage of this model is that metallurgical and mechanical parameters are obtained simultaneously in a short computation time compared with other models. The model has been applied to a rod mill to predict the exit cross-sectional shape, area and AGS per pass by incorporating the equations for AGS evolution being used in strip rolling. At the finishing train of rod mills, the strain rates reach as high as 1000–3000 s−1 and the inter-pass times are around 10–60 ms.

The results show that the proposed model is an efficient tool for evaluating the effects of process-related parameters on product quality and dimensional tolerance of the products in rod (or bar) rolling. The results of the simulation demonstrated that the equation for AGS evolution being used in strip rolling might have limitations when applied directly to rod rolling at a high strain rate.

A comparative study of microstructures and mechanical properties obtained by bar and plate rolling

Microstructures and mechanical properties of a low carbon steel were studied after plate rolling and bar rolling. Plate rolling is characterized as a monotonic compressive loading, while bar rolling is characterized as a cross-compressive loading. A four-pass plate rolling and bar rolling experiment was designed so that the material experiences the same amount of strain at each pass during rolling. The rolling experiment was performed at moderately high temperatures (450, 550 and 650 °C). The microstructures and mechanical properties of the low carbon steel acquired from the two types of rolling experiments were compared. The results revealed that differences of loading path attributed by monotonic loading (plate rolling) and cross loading (bar rolling) significantly influenced the microstructures and mechanical properties such as yield stress, ultimate tensile stress, strain hardening exponent and elongation of the low carbon steel.

Local Austenite grain size distribution in hot bar rolling of AISI 4135 Steel

In this paper, the local distribution of austenite grain size (AGS) was experimentally determined by conducting single round-oval and square-diamond pass hot bar rolling experiments of AISI4135 steel. The rolling experiments were carried out using the laboratory mill. The local distribution of AGS was also determined numerically. In order to predict AGS distribution, the AGS evolution model was combined with three dimensional non-isothermal finite element analyses by adopting a modified additivity rule. AGS evolution model was experimentally determined from hot torsion test according to Hodgson's model. The predicted results were in a reasonably good agreement with experimental results.

Microstructure evolution modeling of square-diamond pass hot bar rolling of AISI 4135 steel

In this study, kinetics of the static (SRX) and metadynamic recrystallization (MDRX) of AISI4135 steel was investigated using hot torsion tests. Continuous torsion tests were carried out to determine the critical strain for dynamic recrystallization (DRX). The times for 50% recrystallization of SRX and MDRX were determined, respectively, by means of interrupted torsion tests. Furthermore, austenite grain size (AGS) evolution due to recrystallization (RX) was measured by optical microscopy. With the help of the evolution model established, the AGS for hot bar rolling of AISI4135 steel was predicted numerically. The predicted AGS values were compared with the results using the other model available in the literature and experimental results to verify its validity. Then, numerical predictions depending on various process parameters such as interpass time, temperature, and roll speed were made to investigate the effect of these parameters on AGS distributions for square-diamond pass rolling. Such numerical results were found to be beneficial in understanding the effect of processing conditions on the microstructure evolution better and control the rolling processes more accurately.

Heavy tools manipulation by low powered direct-drive five-bar parallel robot

This paper presents a simple and available system for manipulation of heavy tools by low powered manipulator for industrial applications. In the heavy manufacturing industries, sometimes, heavy tools are employed for different types of work. But the application of robots with heavy tools is not possible due to the limited torque limits of actuators. Suspended tool systems (STS) have been proposed to manipulate heavy tools by low powered robot-arm for this purpose. A low powered five-bar direct-drive parallel manipulator is designed and constructed to manipulate heavy tools suspended from a spring balancer. The validity, usefulness, and effectiveness of the suspended tool system are shown by experimental results.

Sensory specific satiety and intake : the difference between nibble- and bar-size snacks

The present study investigated (1) whether consumption of a nibble-size snack, as compared to a bar-size snack, leads to more sensory specific satiety (SSS) and a lower intake; and (2) whether attention to consumption, as compared to usual consumption, leads to more SSS and a lower intake. Subjects (N=59) tested two snack foods which differed in size, nibbles and bars, in two consumption conditions. In the attention condition, the instruction to chew the food well was given. In the control condition no such instruction was given. For each of the four SSS sessions ad libitum intake was measured and SSS scores were calculated. Mean intake of the nibbles was 12% lower than of the bars in the control condition, but not in the attention condition. Although non-significantly, attention to consumption tended to reduce intake of the bars but not of the nibbles. SSS scores were slightly higher for the bars than for the nibbles. Our results suggest that a smaller food size results in a lower intake. The data do not clearly support the idea that attention to consumption decreases intake. Hypothetically consumption of small foods and attentive consumption prolong the oral sensory stimulation, which results in a lower intake.

Analysis of the current distribution in an aluminum electrolysis cell with copper collector-bar cathode assembly

Understanding the magneto-hydrodynamic forces generated due to the external magnetic field and current density distribution within the cell (current in cell linings) is important in the optimization of cell dynamics. It is well documented that these factors play a crucial role in establishing the metal-pad stability of the cell. Conventional cells use the cathode-collector-bar assembly to carry the current through molten aluminium, the cathode and the steel collector-bar to nearest external bus. The electrical conductivity of the steel is so poor relative to the molten aluminium that the outer third of the collector bar carries the maximum load, which in turn increases the horizontal components of the current within the cell. Previous studies have modelled improvement in the cell instability through external magnetic compensation by redistributing current in the cathode busbar. Very little to date has been published on work to improve the current distribution within the cell. In this work, the current distribution in an aluminium electrolysis cell with copper collector-bar was predicted using finite element modelling. A 2D cross-section of a commercial cell was used under steady conditions of electrical fields in anode, electrolyte, molten aluminium and copper cathode-assembly. Different shapes and sizes of the cathode assembly are also considered to optimise the distribution of current throughout the cathode lining. The findings indicated that the copper-bar of similar size to steel could save voltage up to 150 mV. There is a reduction of more than 70% in peak current density value due to the copper inserts. The predicted trends of current distribution show a good agreement with previously published data.

Reducing intoxication among bar patrons: some lessons from prevention of drinking and driving

Intoxication in and around licensed premises continues to be common, despite widespread training in the responsible service of alcohol and laws prohibiting service to intoxicated individuals. However, research suggests that training and the existence of laws are unlikely to have an impact on intoxication without enforcement, and evidence from a number of countries indicates that laws prohibiting service to intoxicated individuals are rarely enforced. Enforcement is currently hampered by the lack of a standardized validated measure for defining intoxication clearly, a systematic approach to enforcement and the political will to address intoxication. We argue that adoption of key principles from successful interventions to prevent driving while intoxicated could be used to develop a model of consistent and sustainable enforcement. These principles include: applying validated and widely accepted criteria for defining when a person is ‘intoxicated’; adopting a structure of enforceable consequences for violations; implementing procedures of unbiased enforcement; using publicity to ensure that there is a perceived high risk of being caught and punished; and developing the political will to support ongoing enforcement. Research can play a critical role in this process by: developing and validating criteria for defining intoxication based on observable behaviour; documenting the harms arising from intoxication, including risk curves associated with different levels of intoxication; estimating the policing, medical and social costs from intoxicated bar patrons; and conducting studies of the cost-effectiveness of different interventions to reduce intoxication.