WATER RESOURCES PLANNING MODELING FOR EFFICIENT MANAGEMENT OF IRRIGATION CANAL

In the last years the spreadsheet-based models are widely applied for water resources planning and management. In this report, a model for planning water allocation from irrigation canal is presented. Algorithm based on the water balance which allows for allocation of available water resources of the source according to water requirements of crops in irrigated area, considering current technological constraints was developed and implemented in Excel environment. An existing canal was as a case study. The spreadsheet-based model provides support for efficient management of the irrigation canal

Hazards and incident investigation at palm oil mill industry

Occupational Safety and Health Act (OSHA) is a discipline with broad scope involving many specialized fields. This research was conducted to determine the relationship between the hazards occurring and the control measures to overcome the hazards occur in the Palm Oil Mill located at Ulu Keratong, Segamat, Johor. Nowadays, the workers are lack of safety and health practice from their companies based on the statistics that have shown the number of fatality and permanent disablement cases due to the accident in the palm oil mill. Which causes the accidents and injuries happened due to management control that does not emphasized on the safe practise of workers. Information and data collection were carried out by using HIRARC Form and Preliminary Hazard Analysis (PHA) in the Palm Oil Mill RISDA which will be further discuss in the methodology part. The main objective of this study is to promote adaptable occupational environment and suggest some countermeasures to solve the potential hazard and the consequent responsibilities relevant to professional engineering practice. There were seven hazards have been identified such as crash by rotating machine, struck by heavy palm fruit and slippery floor, excessive heat, excessive pressure of tractor tire, chemical spillage and noise hazard. From the result and findings, the hazards and control measures identified are able to determine improvements in knowledge and risk perceptions among the workers and visitors towards health policies and essential interventions for hazard prevention. Effective job safety and health programs help reduce worker injuries and illness in the long term

Towards Evaluating the Quality of a Spreadsheet: The Case of the Analytical Spreadsheet Model

We consider the challenge of creating guidelines to evaluate the quality of a spreadsheet model. We suggest four principles. First, state the domain-the spreadsheets to which the guidelines apply. Second, distinguish between the process by which a spreadsheet is constructed from the resulting spreadsheet artifact. Third, guidelines should be written in terms of the artifact, independent of the process. Fourth, the meaning of "quality" must be defined. We illustrate these principles with an example. We define the domain of "analytical spreadsheet models", which are used in business, finance, engineering, and science. We propose for discussion a framework and terminology for evaluating the quality of analytical spreadsheet models. This framework categorizes and generalizes the findings of previous work on the more narrow domain of financial spreadsheet models. We suggest that the ultimate goal is a set of guidelines for an evaluator, and a checklist for a developer.Comment: Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2011 ISBN 978-0-9566256-9-

A new database program installed at the SUERC radiocarbon laboratory

The SUERC Radiocarbon Dating Laboratory has recently replaced its spreadsheet-based record keeping with a new database program, custom designed to help laboratory staff manage the high throughput of nearly 5000 cathodes in the past year. The system can accept data from a variety of sources in addition to manual entry; experimental results can be uploaded from spreadsheets, while integration with graphitisation lines means that graphite yields are automatically recorded. The system is able to pass radiocarbon results directly to OxCal 4 for calibration, with the resulting plots incorporated into the dating certificates issued to submitters. There are also benefits to submitters, with electronic sample submission both eliminating transcription errors and speeding up the logging-in process which keeps turnaround times down. For bone samples, data on collagen yields are now stored electronically and are more readily obtainable from the laboratory. The new SUERC Radiocarbon Dating Laboratory database will make a significant contribution to maintaining the high quality of results produced by the laboratory, aiding staff in tracking sample progress and monitoring quality assurance (QA) samples going through the laboratory, eliminating transcription errors and making communication easier between laboratory staff and sample submitters