Experiences in using a contingency factor-based validation methodology for spreadsheet DSS

The use of spreadsheets has become routine in all aspects of business with usage growing across a range of functional areas and a continuing trend towards end user spreadsheet development. However, several studies have raised concerns about the accuracy of spreadsheet models in general, and of end user developed applications in particular, raising the risk element for users. High error rates have been discovered, even though the users/developers were confident that their spreadsheets were correct. The lack of an easy to use, context-sensitive validation methodology has been highlighted as a significant contributor to the problems of accuracy. This paper describes experiences in using a practical, contingency factor-based methodology for validation of spreadsheet-based DSS. Because the end user is often both the system developer and a stakeholder, the contingency factor-based validation methodology may need to be used in more than one way. The methodology can also be extended to encompass other DSS.

Decision support system for inspection and maintenance:a case of oil pipelines

The existing method of pipeline health monitoring, which requires an entire pipeline to be inspected periodically, is unproductive. A risk-based decision support system (DSS) that reduces the amount of time spent on inspection has been presented. The risk-based DSS uses the analytic hierarchy process (AHP), a multiple attribute decision-making technique, to identify the factors that influence failure on specific segments and analyzes their effects by determining probability of occurrence of these risk factors. The severity of failure is determined through consequence analysis. From this, the effect of a failure caused by each risk factor can be established in terms of cost and the cumulative effect of failure is determined through probability analysis. The model optimizes the cost of pipeline operations by reducing subjectivity in selecting a specific inspection method, identifying and prioritizing the right pipeline segment for inspection and maintenance, deriving budget allocation, providing guidance to deploy the right mix labor for inspection and maintenance, planning emergency preparation, and deriving logical insurance plan. The proposed methodology also helps derive inspection and maintenance policy for the entire pipeline system, suggest design, operational philosophy, and construction methodology for new pipelines.

Construction risk management:a quantitative approach

Conventional project management techniques are not always sufficient for ensuring time, cost and quality achievement of large-scale construction projects due to complexity in planning and implementation processes. The main reasons for project non-achievement are changes in scope and design, changes in Government policies and regulations, unforeseen inflation) under-estimation and improper estimation. Projects that are exposed to such an uncertain environment can be effectively managed with the application of risk numagement throughout project life cycle. However, the effectiveness of risk management depends on the technique in which the effects of risk factors are analysed and! or quantified. This study proposes Analytic Hierarchy Process (AHP), a multiple attribute decision-making technique as a tool for risk analysis because it can handle subjective as well as objective factors in decision model that are conflicting in nature. This provides a decision support system (DSS) to project managenumt for making the right decision at the right time for ensuring project success in line with organisation policy, project objectives and competitive business environment. The whole methodology is explained through a case study of a cross-country petroleum pipeline project in India and its effectiveness in project1nana.gement is demonstrated.

Risk based decision support system for effective implementation of projects

Conventional project management techniques are not always sufficient to ensure time, cost and quality achievement of large-scale construction projects due to complexity in planning, design and implementation processes. The main reasons for project non-achievement are changes in scope and design, changes in government policies and regulations, unforeseen inflation, underestimation and improper estimation. Projects that are exposed to such an uncertain environment can be effectively managed with the application of risk management throughout the project's life cycle. However, the effectiveness of risk management depends on the technique through which the effects of risk factors are analysed/quantified. This study proposes the Analytic Hierarchy Process (AHP), a multiple attribute decision making technique, as a tool for risk analysis because it can handle subjective as well as objective factors in a decision model that are conflicting in nature. This provides a decision support system (DSS) to project management for making the right decision at the right time for ensuring project success in line with organisation policy, project objectives and a competitive business environment. The whole methodology is explained through a case application of a cross-country petroleum pipeline project in India and its effectiveness in project management is demonstrated.

Organisational learning - a critical systems thinking discipline

Original Paper European Journal of Information Systems (2001) 10, 135–146; doi:10.1057/palgrave.ejis.3000394 Organisational learning—a critical systems thinking discipline P Panagiotidis1,3 and J S Edwards2,4 1Deloitte and Touche, Athens, Greece 2Aston Business School, Aston University, Aston Triangle, Birmingham, B4 7ET, UK Correspondence: Dr J S Edwards, Aston Business School, Aston University, Aston Triangle, Birmingham, B4 7ET, UK. E-mail: j.s.edwards@aston.ac.uk 3Petros Panagiotidis is Manager responsible for the Process and Systems Integrity Services of Deloitte and Touche in Athens, Greece. He has a BSc in Business Administration and an MSc in Management Information Systems from Western International University, Phoenix, Arizona, USA; an MSc in Business Systems Analysis and Design from City University, London, UK; and a PhD degree from Aston University, Birmingham, UK. His doctorate was in Business Systems Analysis and Design. His principal interests now are in the ERP/DSS field, where he serves as project leader and project risk managment leader in the implementation of SAP and JD Edwards/Cognos in various major clients in the telecommunications and manufacturing sectors. In addition, he is responsible for the development and application of knowledge management systems and activity-based costing systems. 4John S Edwards is Senior Lecturer in Operational Research and Systems at Aston Business School, Birmingham, UK. He holds MA and PhD degrees (in mathematics and operational research respectively) from Cambridge University. His principal research interests are in knowledge management and decision support, especially methods and processes for system development. He has written more than 30 research papers on these topics, and two books, Building Knowledge-based Systems and Decision Making with Computers, both published by Pitman. Current research work includes the effect of scale of operations on knowledge management, interfacing expert systems with simulation models, process modelling in law and legal services, and a study of the use of artifical intelligence techniques in management accounting. Top of pageAbstract This paper deals with the application of critical systems thinking in the domain of organisational learning and knowledge management. Its viewpoint is that deep organisational learning only takes place when the business systems' stakeholders reflect on their actions and thus inquire about their purpose(s) in relation to the business system and the other stakeholders they perceive to exist. This is done by reflecting both on the sources of motivation and/or deception that are contained in their purpose, and also on the sources of collective motivation and/or deception that are contained in the business system's purpose. The development of an organisational information system that captures, manages and institutionalises meaningful information—a knowledge management system—cannot be separated from organisational learning practices, since it should be the result of these very practices. Although Senge's five disciplines provide a useful starting-point in looking at organisational learning, we argue for a critical systems approach, instead of an uncritical Systems Dynamics one that concentrates only on the organisational learning practices. We proceed to outline a methodology called Business Systems Purpose Analysis (BSPA) that offers a participatory structure for team and organisational learning, upon which the stakeholders can take legitimate action that is based on the force of the better argument. In addition, the organisational learning process in BSPA leads to the development of an intrinsically motivated information organisational system that allows for the institutionalisation of the learning process itself in the form of an organisational knowledge management system. This could be a specific application, or something as wide-ranging as an Enterprise Resource Planning (ERP) implementation. Examples of the use of BSPA in two ERP implementations are presented.

Designing a safety management support system using open architecture databases: the requirements of information representation in the support of managers' risk-related decision-making

This research was conducted at the Space Research and Technology Centre o the European Space Agency at Noordvijk in the Netherlands. ESA is an international organisation that brings together a range of scientists, engineers and managers from 14 European member states. The motivation for the work was to enable decision-makers, in a culturally and technologically diverse organisation, to share information for the purpose of making decisions that are well informed about the risk-related aspects of the situations they seek to address. The research examined the use of decision support system DSS) technology to facilitate decision-making of this type. This involved identifying the technology available and its application to risk management. Decision-making is a complex activity that does not lend itself to exact measurement or precise understanding at a detailed level. In view of this, a prototype DSS was developed through which to understand the practical issues to be accommodated and to evaluate alternative approaches to supporting decision-making of this type. The problem of measuring the effect upon the quality of decisions has been approached through expert evaluation of the software developed. The practical orientation of this work was informed by a review of the relevant literature in decision-making, risk management, decision support and information technology. Communication and information technology unite the major the,es of this work. This allows correlation of the interests of the research with European public policy. The principles of communication were also considered in the topic of information visualisation - this emerging technology exploits flexible modes of human computer interaction (HCI) to improve the cognition of complex data. Risk management is itself an area characterised by complexity and risk visualisation is advocated for application in this field of endeavour. The thesis provides recommendations for future work in the fields of decision=making, DSS technology and risk management.

Studies on the chromosomal bets-lactamase of pseudomonas aeruginosa

The chromosomal ß-lactamase of Pseudomonas aeruginosa SAlconst (a derepressed laboratory strain) was isolated and purified. Two peaks of activity were observed on gel permeation chromatography (one major peak mol. wt. 45 kD and one minor peak of 54 kD). Preparations from 12 clinical derepressed strains showed identical results. Chromosomal ß-lactamase production in both normal and derepressed P. aeruginosa strains was induced both by iron restricted growth conditions and by penicillin G. The majority of the enzyme (80-90%) was found in the periplasm and cytoplasm but a significant amount (2-20%) was associated with the outer membrane (OM). The growth conditions did not affect the distribution of the enzyme between subcellular fractions although higher activity was found in the cells grown under iron limitation and/ or in the presence of ß-lactams. The penicillanate sulphone inhibitor, tazobactam, displayed irreversible kinetics whilst cloxacillin, cefotaxime, ampicillin and penicillin G were all competitive inhibitors of the enzyme. Similar results were obtained for the Enterobacter cloacae P99 [ß-lactamase, but tazobactam displayed a non-classical kinetic pattern for the Staphylococcus aureus PC1 ß-lactamase. The residues involved in ß-lactam hydrolysis by the P aeruginosa SAlconst enzyme were detennined by affinity labelling with tazobactam. A tryptic digestion fragment of the inhibited enzyme contained the amino acids D, T, S, E, P, G, A, C, V, M, I, Y, F, H, K, R. This suggests the involvement of the conserved SVSK, DAE and KTG motifs found in all penicillin sensitive proteins. A model of the 3-D structure of the active site of the P aeruginosa SAlconst chromosomal ß-!actamase was constructed from the published amino acid sequence of P aeruginosa chromosomal ß-lactamase and the a-carbon coordinates of the S. aureus PCI ß-lactamase by homology modelling and energy minimisation. The crystal structure of tazobactam was determined and energy minimised. Computer graphics docking identified Ser 72 as a possible residue involved in a secondary attack on the C5 position of tazobactam after initial ß-lactam hydrolysis by serine 70. The enhanced activity of tazobactam over sulbactam might be explained by the triazole substituent which might participate in favourable hydrogen bonding between N3 and active site residues.

A methodology for implementing a decision support system:a small company case study

The importance of non-technical factors in the design and implementation of information systems has been increasingly recognised by both researchers and practitioners, and recent literature highlights the need for new tools and techniques with an organisational, rather than technical, focus. The gap between what is technically possible and what is generally practised, is particularly wide in the sales and marketing field. This research describes the design and implementation of a decision support system (DSS) for marketing planning and control in a small, but complex company and examines the nature of the difficulties encountered. An intermediary with functional, rather than technical, expertise is used as a strategy for overcoming these by taking control of the whole of the systems design and implementation cycle. Given the practical nature of the research, an action research approach is adopted with the researcher undertaking this role. This approach provides a detailed case study of what actually happens during the DSS development cycle, allowing the influence of organisational factors to be captured. The findings of the research show how the main focus of the intermediary's role needs to be adapted over the systems development cycle; from coordination and liaison in the pre-design and design stages, to systems champion during the first part of the implementation stage, and finally to catalyst to ensure that the DSS is integrated into the decision-making process. Two practical marketing exercises are undertaken which illustrate the nature of the gap between the provision of information and its use. The lack of a formal approach to planning and control is shown to have a significant effect on the way the DSS is used and the role of the intermediary is extended successfully to accommodate this factor. This leads to the conclusion that for the DSS to play a fully effective role, small firms may need to introduce more structure into their marketing planning, and that the role of the intermediary, or Information Coordinator, should include the responsibility for introducing new techniques and ideas to aid with this.

Decision support system for spare parts warehousing

Spare parts warehousing decision-making plays an important role in today's manufacturing industry as it derives an optimum inventory policy for the organizations. Previous research on spare parts warehousing decision-making did not deal with the problem holistically considering all the subjective and objective criteria of operational and strategic needs of the manufacturing companies in the process industry. This study reviews current relevant literature and develops a conceptual framework (an integrated group decision support system) for selecting the most effective warehousing option for the process industry using the analytic hierarchy process (AHP). The framework has been applied to a multinational cement manufacturing company in the UK. Three site visits, eight formal interviews, and several discussions have been undertaken with personnel of the organization, many of which have more than 20 years of experience, in order to apply the proposed decision support system (DSS). Subsequently, the DSS has been validated through a questionnaire survey in order to establish its usefulness, effectiveness for warehousing decision-making, and the possibility of adoption. The proposed DSS is an integrated framework for selecting the best warehousing option for business excellence in any manufacturing organization.

Decision support for lifecycle planning and risk management of small-scale biomass combined heat and power (bCHP) projects in the UK

Biomass is projected to account for approximately half of the new energy production required to achieve the 2020 primary energy target in the UK. Combined heat and power (CHP) bioenergy systems are not only a highly efficient method of energy conversion, at smaller-scales a significant proportion of the heat produced can be effectively utilised for hot water, space heating or industrial heating purposes. However, there are many barriers to project development and this has greatly inhibited deployment in the UK. Project viability is highly subjective to changes in policy, regulation, the finance market and the low cost incumbent; a high carbon centralised energy system. Unidentified or unmitigated barriers occurring during the project lifecycle may not only negatively impact on the project but could ultimately lead to project failure. The research develops a decision support system (DSS) for small-scale (500 kWe to 10 MWe) biomass combustion CHP project development and risk management in the early stages of a potential project’s lifecycle. By supporting developers in the early stages of project development with financial, scheduling and risk management analysis, the research aims to reduce the barriers identified and streamline decision-making. A fuzzy methodology is also applied throughout the developed DSS to support developers in handling the uncertain or approximate information often held at the early stages of the project lifecycle. The DSS is applied to a case study of a recently failed (2011) small-scale biomass CHP project to demonstrate its applicability and benefits. The application highlights that the proposed development within the case study was not viable. Moreover, further analysis of the possible barriers with the DSS confirmed that some possible modifications to be project could have improved this, such as a possible change of feedstock to a waste or residue, addressing the unnecessary land lease cost or by increasing heat utilisation onsite. This analysis is further supported by a practitioner evaluation survey that confirms the research contribution and objectives are achieved.

Bioenergy decision support systems:worth the effort?

The purpose of this research is to explore the disparity between the existing model-orientated bioenergy decision support system (DSS) functions and what is desired by practitioners, in particular bioenergy project developers. This research has compiled the published bioenergy project development models, to highlight the characteristics emphasised by academics. When contrasted against a UK practitioner’s perspective through the administration of a Likert style questionnaire, it is clear that the general DSS issues still persist. Finally, the research suggests how this ’theory-practice’ divide could be addressed. The research contribute

36 monocyte subpopulations counts and associations with global longitudinal strain in st-elevation myocardial infarction patients with normal ejection fraction

Introduction - Monocytes, with 3 different subsets, are implicated in the initiation and progression of the atherosclerotic plaque contributing to plaque instability and rupture. Mon1 are the “classical” monocytes with inflammatory action, whilst Mon3 are considered reparative with fibroblast deposition ability. The function of the newly described Mon2 subset is yet to be fully described. In PCI era, fewer patients have globally reduced left ventricular ejection fraction post infarction, hence the importance of studying regional wall motion abnormalities and deformation at segmental levels using longitudinal strain. Little is known of the role for the 3 monocyte subpopulations in determining global strain in ST elevation myocardial infarction patients (STEMI). Conclusion In patients with normal or mildly impaired EF post infarction, higher counts of Mon1 and Mon2 are correlated with GLS within 7 days and at 6 months of remodelling post infarction. Adverse clinical outcomes in patients with reduced convalescent GLS were predicted with Mon1 and Mon2 suggestive of an inflammatory role for the newly identified Mon2 subpopulation. These results imply an important role for monocytes in myocardial healing when assessed by subclinical ventricular function indices. Methodology - STEMI patients (n = 101, mean age 64 ± 13 years; 69% male) treated with percutaneous revascularisation were recruited within 24 h post-infarction. Peripheral blood monocyte subpopulations were enumerated and characterised using flow cytometry after staining for CD14, CD16 and CCR2. Phenotypically, monocyte subpopulations are defined as: CD14++CD16-CCR2+ (Mon1), CD14++CD16+CCR2+ (Mon2) and CD14+CD16++CCR2- (Mon3). Phagocytic activity of monocytes was measured using flow cytometry and Ecoli commercial kit. Transthoracic 2D echocardiography was performed within 7 days and at 6 months post infarct to assess global longitudinal strain (GLS) via speckle tracking. MACE was defined as recurrent acute coronary syndrome and death. Results - STEMI patients with EF ≥50% by Simpson’s biplane (n = 52) had GLS assessed. Using multivariate regression analysis higher counts of Mon1 and Mon 2 and phagocytic activity of Mon2 were significantly associated with GLS (after adjusting for age, time to hospital presentation, and peak troponin levels) (Table 1). At 6 months, the convalescent GLS remained associated with higher counts of Mon1, Mon 2. At one year follow up, using multivariate Cox regression analysis, Mon1 and Mon2 counts were an independent predictor of MACE in patients with a reduced GLS (n = 21)

Decision support system for pipeline route selection

Presents information on a study which proposed a decision support system (DSS) for a petroleum pipeline route selection with the application of analytical hierarchy process. Factors governing route-selection for cross-country petroleum pipelines; Application of the DSS from an Indian perspective; Cost benefit comparison of the shortest route and the optimal route; Results and findings.

Corrosion mechanisms of duplex stainless steels in the petrochemical industry

The recent search for new sources of hydrocarbons has led to production from very severe environments which can contain considerable amounts of carbon dioxide, hydrogen sulphide, and chloride ions, combined with temperatures which can exceed 100°C. Oil and gas production from such wells requires highly corrosion-resistant materials. The traditional solution of using carbon steel with additional protection is generally inadequate in these very-aggressive environments. Duplex stainless steels (DSS) are attractive candidates because of their high strength, good general corrosion resistance, excellent resistance to chloride-induced stress corrosion cracking, and good weldability. Although duplex stainless steels have a very good reputation in both subsea and topsides pipework, it is recognized that the tolerance of these materials to variations in microstructure and chemical composition are still not fully understood. The object of this paper is to review the corrosion behaviour of duplex stainless steels in the petrochemical industry, with particular emphasis on microstructures and the effect of changes in chemical composition.