Spreadsheet Conditional Formatting Illuminates Investigations into Modular Arithmetic

Modular arithmetic has often been regarded as something of a mathematical curiosity, at least by those unfamiliar with its importance to both abstract algebra and number theory, and with its numerous applications. However, with the ubiquity of fast digital computers, and the need for reliable digital security systems such as RSA, this important branch of mathematics is now considered essential knowledge for many professionals. Indeed, computer arithmetic itself is, ipso facto, modular. This chapter describes how the modern graphical spreadsheet may be used to clearly illustrate the basics of modular arithmetic, and to solve certain classes of problems. Students may then gain structural insight and the foundations laid for applications to such areas as hashing, random number generation, and public-key cryptography.

Field validation of controlled Monte Carlo data generation for statistical damage identification employing Mahalanobis squared distance

This article presents the field applications and validations for the controlled Monte Carlo data generation scheme. This scheme was previously derived to assist the Mahalanobis squared distance–based damage identification method to cope with data-shortage problems which often cause inadequate data multinormality and unreliable identification outcome. To do so, real-vibration datasets from two actual civil engineering structures with such data (and identification) problems are selected as the test objects which are then shown to be in need of enhancement to consolidate their conditions. By utilizing the robust probability measures of the data condition indices in controlled Monte Carlo data generation and statistical sensitivity analysis of the Mahalanobis squared distance computational system, well-conditioned synthetic data generated by an optimal controlled Monte Carlo data generation configurations can be unbiasedly evaluated against those generated by other set-ups and against the original data. The analysis results reconfirm that controlled Monte Carlo data generation is able to overcome the shortage of observations, improve the data multinormality and enhance the reliability of the Mahalanobis squared distance–based damage identification method particularly with respect to false-positive errors. The results also highlight the dynamic structure of controlled Monte Carlo data generation that makes this scheme well adaptive to any type of input data with any (original) distributional condition.

Multivariate statistical analysis of hydrochemical data to assess alluvial aquifer–stream connectivity during drought and flood : Cressbrook Creek, southeast Queensland, Australia

A catchment-scale multivariate statistical analysis of hydrochemistry enabled assessment of interactions between alluvial groundwater and Cressbrook Creek, an intermittent drainage system in southeast Queensland, Australia. Hierarchical cluster analyses and principal component analysis were applied to time-series data to evaluate the hydrochemical evolution of groundwater during periods of extreme drought and severe flooding. A simple three-dimensional geological model was developed to conceptualise the catchment morphology and the stratigraphic framework of the alluvium. The alluvium forms a two-layer system with a basal coarse-grained layer overlain by a clay-rich low-permeability unit. In the upper and middle catchment, alluvial groundwater is chemically similar to streamwater, particularly near the creek (reflected by high HCO3/Cl and K/Na ratios and low salinities), indicating a high degree of connectivity. In the lower catchment, groundwater is more saline with lower HCO3/Cl and K/Na ratios, notably during dry periods. Groundwater salinity substantially decreased following severe flooding in 2011, notably in the lower catchment, confirming that flooding is an important mechanism for both recharge and maintaining groundwater quality. The integrated approach used in this study enabled effective interpretation of hydrological processes and can be applied to a variety of hydrological settings to synthesise and evaluate large hydrochemical datasets.

A statistical approach to quantify the impact on voltage quality caused by PV generators

A probabilistic method is proposed to evaluate voltage quality of grid-connected photovoltaic (PV) power systems. The random behavior of solar irradiation is described in statistical terms and the resulting voltage fluctuation probability distribution is then derived. Reactive power capabilities of the PV generators are then analyzed and their operation under constant power factor mode is examined. By utilizing the reactive power capability of the PV-generators to the full, it is shown that network voltage quality can be greatly enhanced.

Further investigations of framing effects on cooperative choices in a provision point mechanism

We investigate whether framing effects of voluntary contributions are significant in a provision point mechanism. Our results show that framing significantly affects individuals of the same type: cooperative individuals appear to be more cooperative in the public bads game than in the public goods game, whereas individualistic subjects appear to be less cooperative in the public bads game than in the public goods game. At the aggregate level of pooling all individuals, the data suggests that framing effects are negligible, which is in contrast with the established result.

Investigations of dielectric monitoring on an energised transformer oil–paper insulation system

Frequency domain spectroscopy (FDS) is being used to assess the insulation condition of oil–paper power transformers. However, it has to date only been implemented on de-energised transformers, which requires the transformers to be shut down for an extended period and may cause significant costs. To solve this issue, a newly improved monitoring method based on the FDS principle is proposed to implement the dielectric measurement on energised transformers. Moreover, a chirp waveform excitation and its novel processing method are introduced. Compared with the conventional FDS results, dielectric results from the energised insulation system have higher tanδ values because of the increased losses. To further understand the insulation ageing process, the effects of the geometric capacitance are removed from the measured imaginary admittance of the insulation system to enhance the ageing signature. The resulting imaginary admittance is then shown to correlate well with the central time constant in return voltage measurements results. The proposed methods address the issues on techniques used on energised transformers and provide a clue for on-line FDS diagnostic application.

Australian health and safety inspectors’ perceptions and actions in relation to changed work arrangements

Extensive international research points to an association between changed work arrangements, especially those commonly labelled as contingent work, with adverse occupational health and safety (OHS) outcomes. Research also indicates these work arrangements have weakened or bypassed existing OHS and workers’ compensation regulatory regimes. However, there has been little if any research into how OHS inspectors perceive these issues and how they address them during workplace visits or investigations. Between 2003 and 2007 research was undertaken that entailed detailed documentary and statistical analysis, extended interviews with 170 regulatory managers and inspectors, and observational data collected while accompanying inspectors on 118 ‘typical’ workplace visits. Key findings are that inspectors responsible for a range of industries see altered work arrangements as a serious challenge, especially labour hire (agency work) and subcontracting. Though the law imposes clear obligations, inspectors identified misunderstanding/blameshifting and poor compliance amongst parties to these arrangements. The complexity of these work arrangements also posed logistical challenges to inspectorates.

In vitro investigations on the effect of dermal fibroblasts on keratinocyte responses to ultraviolet B radiation

Exposure to ultraviolet radiation is closely linked to the development of skin cancers in humans. The ultraviolet B (UVB) radiation wavelength (280-320 nm), in particular, causes DNA damage in epidermal keratinocytes, which are linked to the generation of signature premalignant mutations. Interactions between dermal fibroblasts and keratinocytes play a role in epidermal repair and regeneration after UVB-induced damage. To investigate these processes, established two and three-dimensional culture models were utilized to study the impact of fibroblast-keratinocyte crosstalk during the acute UVB response. Using a coculture system it was observed that fibroblasts enhanced keratinocyte survival and the repair of cyclobutane pyrimidine dimers (CPDs) after UVB radiation exposure. These findings were also mirrored in irradiated human skin coculture models employed in this study. Fibroblast coculture was shown to play a role in the expression and activation of members of the apoptotic cascade, including caspase-3 and Bad. Interestingly, the expression and phosphorylation of p53, a key player in the regulation of keratinocyte cell fate postirradiation, was also shown to be influenced by fibroblast-produced factors. This study highlights the importance of synergistic interactions between fibroblasts and keratinocytes in maintaining a functional epidermis while promoting repair and regeneration following UVB radiation-induced damage.

Conceptual and statistical framework for a water quality component of the integrated report card for the Great Barrier Reef catchments

This report presents the final deliverable from the project titled Conceptual and statistical framework for a water quality component of an integrated report card’ funded by the Marine and Tropical Sciences Research Facility (MTSRF; Project 3.7.7). The key management driver of this, and a number of other MTSRF projects concerned with indicator development, is the requirement for state and federal government authorities and other stakeholders to provide robust assessments of the present ‘state’ or ‘health’ of regional ecosystems in the Great Barrier Reef (GBR) catchments and adjacent marine waters. An integrated report card format, that encompasses both biophysical and socioeconomic factors, is an appropriate framework through which to deliver these assessments and meet a variety of reporting requirements. It is now well recognised that a ‘report card’ format for environmental reporting is very effective for community and stakeholder communication and engagement, and can be a key driver in galvanising community and political commitment and action. Although a report card it needs to be understandable by all levels of the community, it also needs to be underpinned by sound, quality-assured science. In this regard this project was to develop approaches to address the statistical issues that arise from amalgamation or integration of sets of discrete indicators into a final score or assessment of the state of the system. In brief, the two main issues are (1) selecting, measuring and interpreting specific indicators that vary both in space and time, and (2) integrating a range of indicators in such a way as to provide a succinct but robust overview of the state of the system. Although there is considerable research and knowledge of the use of indicators to inform the management of ecological, social and economic systems, methods on how to best to integrate multiple disparate indicators remain poorly developed. Therefore the objective of this project was to (i) focus on statistical approaches aimed at ensuring that estimates of individual indicators are as robust as possible, and (ii) present methods that can be used to report on the overall state of the system by integrating estimates of individual indicators. It was agreed at the outset, that this project was to focus on developing methods for a water quality report card. This was driven largely by the requirements of Reef Water Quality Protection Plan (RWQPP) and led to strong partner engagement with the Reef Water Quality Partnership.