Open Access. Powered by Scholars. Published by Universities.®

Technology and Innovation Commons

Open Access. Powered by Scholars. Published by Universities.®

Management Sciences and Quantitative Methods

Series

Institution
Keyword
Publication Year
Publication

Articles 1 - 30 of 46

Full-Text Articles in Technology and Innovation

The Effect Of Firm-Controlled Store Type Touchpoints On Customer’S Discrete Emotions: An Exploratory Study On Physical Store & Online Store, Jyro B. Triviño Jun 2023

The Effect Of Firm-Controlled Store Type Touchpoints On Customer’S Discrete Emotions: An Exploratory Study On Physical Store & Online Store, Jyro B. Triviño

Leadership and Strategy Faculty Publications

Customer experience is a broad and multi-dimensional phenomenon, which currently divides academic scholars in terms of constructs and measurement. This study aims to examine some acceptable yet under-measured customer experience constructs already developed. The comparative exploration of the physical store and online store firm-controlled touchpoints seeks to identify differences or similarities in customers’ perceived affective response, which can help firms improve their current touchpoint design. Set in a business-to-customer context in the Philippines during a Covid-19 community quarantine, a total sample of 338 respondents evaluated their recent interaction during the purchase stage. A causal-comparative exploratory research design was utilized using …


The Managerial Factors Influencing The Retention Of Firms' It Capability, With Some Global Implications, Jinho Kim, Kayoung Park, Timothy Komarek, Li Xu Jan 2023

The Managerial Factors Influencing The Retention Of Firms' It Capability, With Some Global Implications, Jinho Kim, Kayoung Park, Timothy Komarek, Li Xu

Mathematics & Statistics Faculty Publications

Researchers have explored firms’ IT capability and its effects on business performance, yet the factors influencing the long-term retention of this capability have not been fully investigated. Therefore, our study examines what managerial and financial factors influence the retention of firms’ IT capability by utilizing survival analysis. The results show that IT executives’ managerial power does not contribute to retaining the firms’ IT capability. However, the change of IT managers can introduce fresh insights and expertise to an organization, enabling firms to maintain their IT capability, and the degree of retaining IT competency in firms can vary based on industry-specific …


An Ethical Discussion About The Responsibility For Protection Of Minors In The Digital Environment: A State-Of-The-Art Review, Charles Alves De Castro, Aiden Carthy, Isobel Oreilly Dr May 2022

An Ethical Discussion About The Responsibility For Protection Of Minors In The Digital Environment: A State-Of-The-Art Review, Charles Alves De Castro, Aiden Carthy, Isobel Oreilly Dr

Articles

Many ethical questions have been raised regarding the use of social media and the internet, mainly related to the protection of young people in the digital environment. In order to critically address the research question "who is responsible for ethically protecting minors in the digital environment?", this paper will review the main literature available to understand the role of parents, the government, and companies in protecting young people within the digital environment. We employed a holistic process that covers a state-of-the-art review and desk research. The article is divided into four sessions; (1) Government Policies from the European Union (EU) …


Covid‑19 Vaccine Distribution: Exploring Strategic Alternatives For The Greater Good, Arben Asllani, Silvana Trimi Apr 2022

Covid‑19 Vaccine Distribution: Exploring Strategic Alternatives For The Greater Good, Arben Asllani, Silvana Trimi

Department of Supply Chain Management and Analytics: Faculty and Staff Publications

The dire state of the COVID-19 pandemic crisis symbolized the urgency for efficient distribution and administration of vaccines to combat the virus as the most urgent public health service. This paper presents a prototype multi-criteria decision support model based on goal programming that can effectively support vaccination plans for the greater good of society. The optimization goals of the model include minimizing the number of fatalities and risk of spreading the disease, while complying with government health agency’s priority guidelines for vaccination. This study applied the model to a real-world dataset to demonstrate how it can be effectively applied as …


Smart Manufacturing And Its Implications For Singapore's Smes, Thomas Menkhoff, Surianarayanan Gopalakrishnan Nov 2021

Smart Manufacturing And Its Implications For Singapore's Smes, Thomas Menkhoff, Surianarayanan Gopalakrishnan

Research Collection Lee Kong Chian School Of Business

While Covid-19 and the climate catastrophe continue to make headlines, local small and medium-sized enterprises (SMEs) are quietly setting the gears of Smart Manufacturing in motion with a strategic focus on digitising and automating production processes powered by "Industry 4.0" (I4.0) ready business models. A shared view among several interviewees we talked to recently in the context of an ongoing study on the impact of I4.0 on the business models of local manufacturers is that Industrial Internet-of-Things (IIoT), machine learning, visual computing, automation and digital twining are deemed of great importance for the long-term competitiveness of Singapore's manufacturing ecosystem on …


A Systematic Literature Review : The Influence Of Information Technology And Organizational Learning On Performance, Merlin Apriliyanti, Ilham M, Dian Ekowati, Tanti Handriana Jan 2021

A Systematic Literature Review : The Influence Of Information Technology And Organizational Learning On Performance, Merlin Apriliyanti, Ilham M, Dian Ekowati, Tanti Handriana

Library Philosophy and Practice (e-journal)

This Study is to discuss about literature review of Information technology enabler is a strategic asset in creating competitive advantage. The contribution of information technology investment to company performance does not appear immediately, but is independent in supporting business activities. The ability and mastery of information technology is not necessarily effective in contributing to company performance. Organizational learning plays a role in mediating the relationship between Information Technology enablers and company performance. This study aims to conduct a systematic literature review of research in the field of Information Technology Enabler and learning organization and performance with data from all international …


Exploring Growth And Impact Of Research Productivity For Prince Of Songkla University (Psu) On Scopus Database: A Bibliometric Analysis, Pachisa Kulkanjanapiban, Tipawan Silwattananusarn Jan 2021

Exploring Growth And Impact Of Research Productivity For Prince Of Songkla University (Psu) On Scopus Database: A Bibliometric Analysis, Pachisa Kulkanjanapiban, Tipawan Silwattananusarn

Library Philosophy and Practice (e-journal)

This paper presents a Bibliometric analysis of Prince of Songkla University (PSU) based on the Scopus database for 1978-2021. The study aimed to explore the current state, the trends, characteristics of Prince of Songkla University (PSU), i.e., growth of research output, collaboration trends, authorship pattern, citation patterns, contributing countries, and organizations. A total of 14,644 publications consulted of PSU published during the year 1978-2021 retrieved from the Scopus database, and these articles had a total of 10,257 cited items. The method used to display the research pattern and research activity on a particular topic is the bibliometric analysis commonly used …


Tree-Based Algorithm For Stable And Efficient Data Clustering, Hasan Aljabbouli, Abdullah Albizri, Antoine Harfouche Sep 2020

Tree-Based Algorithm For Stable And Efficient Data Clustering, Hasan Aljabbouli, Abdullah Albizri, Antoine Harfouche

Department of Information Management and Business Analytics Faculty Scholarship and Creative Works

The K-means algorithm is a well-known and widely used clustering algorithm due to its simplicity and convergence properties. However, one of the drawbacks of the algorithm is its instability. This paper presents improvements to the K-means algorithm using a K-dimensional tree (Kd-tree) data structure. The proposed Kd-tree is utilized as a data structure to enhance the choice of initial centers of the clusters and to reduce the number of the nearest neighbor searches required by the algorithm. The developed framework also includes an efficient center insertion technique leading to an incremental operation that overcomes the instability problem of the K-means …


Inventory Sharing And Demand-Side Underweighting, Hui Zhao, Liang Xu, Enno Siemsen Jan 2020

Inventory Sharing And Demand-Side Underweighting, Hui Zhao, Liang Xu, Enno Siemsen

Department of Supply Chain Management and Analytics: Faculty and Staff Publications

Problem definition: Transshipment/inventory sharing has been used in practice because of its risk-pooling potential. However, human decision makers play a critical role in making inventory decisions in an inventory sharing system, which may affect its benefits. We investigate whether the opportunity to transship inventory influences decision makers’ inventory decisions and whether, as a result, the intended risk-pooling benefits materialize.

Academic/practical relevance: Previous research in transshipment, which is focused on finding optimal stocking and sharing decisions, assumes rational decision making without any systematic bias. As one of the first to study inventory sharing from a behavioral perspective, …


Inducing Compliance With Post-Market Studies For Drugs Under Fda’S Accelerated Approval Pathway, Liang Xu, Hui Zhao, Nicholas C. Petruzzi Jan 2020

Inducing Compliance With Post-Market Studies For Drugs Under Fda’S Accelerated Approval Pathway, Liang Xu, Hui Zhao, Nicholas C. Petruzzi

Department of Supply Chain Management and Analytics: Faculty and Staff Publications

Problem definition: In 1992, FDA instituted the accelerated approval pathway (AP) to allow promising drugs to enter the market based on limited evidence of efficacy, thereby permitting manufacturers to verify true clinical benefits through post-market studies. However, most postmarket studies have not been completed as promised. We address this non-compliance problem.

Academic/Practical Relevance: The prevalence of this non-compliance problem poses considerable public health risk, thus compromising the original purpose of a well-intentioned AP initiative. We provide an internally consistent and implementable solution to the problem through a comprehensive analysis of the myriad complicating factors and tradeoffs facing FDA.

Methodology: We …


Machine Learning Using Instruments For Text Selection: Predicting Innovation Performance, Kian Guan Lim, Michelle S. J. Lim Dec 2019

Machine Learning Using Instruments For Text Selection: Predicting Innovation Performance, Kian Guan Lim, Michelle S. J. Lim

Research Collection Lee Kong Chian School Of Business

In machine learning we utilize the idea of employing instrumental variable such as patent records to train the texts. Patent records are highly correlated with R&D expenditures, but are not necessarily correlated with performance residuals not linked to R&D. Thus, using instrumental patent records to train word counts of selected texts to serve as a proxy for firm R&D expenditure, we show that the texts and associated word counts provide effective prediction of firm innovation performances such as firm market value and total sales growth.


Dynamic Pricing Of Wireless Internet Based On Usage And Stochastically Changing Capacity, Demet Batur, Jennifer K. Ryan, Zhongyuan Zhao, Mehmet C. Vuran Jan 2019

Dynamic Pricing Of Wireless Internet Based On Usage And Stochastically Changing Capacity, Demet Batur, Jennifer K. Ryan, Zhongyuan Zhao, Mehmet C. Vuran

Department of Supply Chain Management and Analytics: Faculty and Staff Publications

(1) Problem Definition: Inspired by new developments in dynamic spectrum access, we study the dynamic pricing of wireless Internet access when demand and capacity (bandwidth) are stochastic. (2) Academic / Practical Relevance: The demand for wireless Internet access has increased enormously. However, the spectrum available to wireless service providers is limited. The industry has thus altered conventional license- based spectrum access policies through unlicensed spectrum operations. The additional spectrum obtained through these operations has stochastic capacity. Thus, the pricing of this service by the service provider has novel challenges. The problem considered in this paper is therefore of high practical …


Reflective Practice Series: Selected Instructional Models Using Synchronous Video Conferencing Software, Martin W. Sivula Sep 2018

Reflective Practice Series: Selected Instructional Models Using Synchronous Video Conferencing Software, Martin W. Sivula

MBA Faculty Conference Papers & Journal Articles

With the vast array of resources available to instructors, one would think that instruction and teaching would yield success for all learners. Now, well into the 21st century has much changed in the classroom? Certainly, movable desks and chairs, advanced audio and visual equipment, and a plethora of all types of technologies which might be able to enhance training and education. Over the last several decades research on individualized instruction, cognitive science, educational psychology, and multimedia instruction (to name a few) have permeated the literature on instruction. With all the research and the vast array of studies on improving …


Subjectivity Of Diamond Prices In Online Retail: Insights From A Data Mining Study, Stanislav Mamonov, Tamilla Triantoro May 2018

Subjectivity Of Diamond Prices In Online Retail: Insights From A Data Mining Study, Stanislav Mamonov, Tamilla Triantoro

Department of Information Management and Business Analytics Faculty Scholarship and Creative Works

Diamonds belong to a unique product category whose perceived value is largely dependent on socially constructed beliefs. To explore the degree to which the physical properties of a diamond can be used to predict the diamond price, we perform data mining on a large dataset of loose diamonds scraped from an online diamond retailer. We find that diamond weight, color and clarity are the key characteristics that influence diamond prices. The data mining results also suggest a high degree of subjectivity in diamond pricing that may reflect price obfuscation strategies employed by diamond retailers.


Glossary Of Business Evidence, Paul C. Boyd Apr 2018

Glossary Of Business Evidence, Paul C. Boyd

MBA Faculty Conference Papers & Journal Articles

No abstract provided.


Assessing The Validity And Reliability Of Family Factors On Physical Activity: A Case Study In Turkey, Sharalyn Steenson, Hilal Ozcebe, Umut Arslan, Hande Konsuk Unlu, Ozgur M. Araz, Mahmut Yardim, Sarp Uner, Nazmi Bilir, Terry T.-K. Huang Jan 2018

Assessing The Validity And Reliability Of Family Factors On Physical Activity: A Case Study In Turkey, Sharalyn Steenson, Hilal Ozcebe, Umut Arslan, Hande Konsuk Unlu, Ozgur M. Araz, Mahmut Yardim, Sarp Uner, Nazmi Bilir, Terry T.-K. Huang

Department of Supply Chain Management and Analytics: Faculty and Staff Publications

Background: Childhood obesity rates have been rising rapidly in developing countries. A better understanding of the risk factors and social context is necessary to inform public health interventions and policies. This paper describes the validation of several measurement scales for use in Turkey, which relate to child and parent perceptions of physical activity (PA) and enablers and barriers of physical activity in the home environment.

Method: The aim of this study was to assess the validity and reliability of several measurement scales in Turkey using a population sample across three socio-economic strata in the Turkish capital, Ankara. Surveys were conducted …


The Big, Gig Picture: We Can't Assume The Same Constructs Matter, Alice M. Brawley Newlin Nov 2017

The Big, Gig Picture: We Can't Assume The Same Constructs Matter, Alice M. Brawley Newlin

Management Faculty Publications

I am concerned about industrial and organizational (I-O) psychology's relevance to the gig economy, defined here as the broad trends toward technology-based platform work. This sort of work happens on apps like Uber (where the app connects drivers and riders) and sites like MTurk (where human intelligence tasks, or HITs, are advertised to workers on behalf of requesters). We carry on with I-O research and practice as if technology comprises only things (e.g., phones, websites, platforms) that we use to assess applicants and complete work. However, technology has much more radically restructured work as we know it, to happen in …


Use Of Smartphones For Clinical And Medical Education, Jazmine Valle, Tyler Godby, David P. Paul Iii, Harlan M. Smith Ii, Alberto Coustasse Jul 2017

Use Of Smartphones For Clinical And Medical Education, Jazmine Valle, Tyler Godby, David P. Paul Iii, Harlan M. Smith Ii, Alberto Coustasse

Management Faculty Research

Introduction: Smartphones for clinical and medical education have been on the rise and show contribution to healthcare and healthcare providers. Smartphones in healthcare facilities has been examined for utilization and efficacy, however, although the advantages are abundant some healthcare facilities and providers are reluctant to change due to threat of mixing personal apps with clinical care applications, distraction to the provider using the smartphone which has led to medication errors followed by errors linked to procedures, treatments, or tests. The purpose of this research was to examine the effects of smartphones in a clinical setting and for medical education to …


Artificial Intelligence In Engineering Risk Analytics, Desheng Wu, David L. Olson, Alexandre Dolgui Jan 2017

Artificial Intelligence In Engineering Risk Analytics, Desheng Wu, David L. Olson, Alexandre Dolgui

Department of Supply Chain Management and Analytics: Faculty and Staff Publications

Risks exist in every aspect of our lives, and can mean different things to different people. While negative in general they always cause a great deal of potential damage and inconvenience for stakeholders. Recent engineering risks include the Fukushima nuclear plant disaster from the 2011 tsunami, a year that also saw earthquakes in New Zealand, tornados in the US, and floods in both Australia and Thailand. Earthquakes, tornados (not to mention hurricanes) and floods are repetitive natural phenomenon. But the October 2011 floods in Thailand were the worst in 50 years, impacting supply chains including those of Honda, Toyota, Lenovo, …


Antitrust And Information Technologies, Herbert J. Hovenkamp Mar 2016

Antitrust And Information Technologies, Herbert J. Hovenkamp

All Faculty Scholarship

Technological change strongly affects the use of information to facilitate anticompetitive practices. The effects result mainly from digitization and the many products and processes that it enables. These technologies of information also account for a significant portion of the difficulties that antitrust law encounters when its addresses intellectual property rights. In addition, changes in the technologies of information affect the structures of certain products, in the process either increasing or decreasing the potential for competitive harm.

For example, digital technology affects the way firms exercise market power, but it also imposes serious measurement difficulties. The digital revolution has occurred in …


Can Contracts Replace Qualification In A Sourcing Process With Competitive Suppliers And Imperfect Information?, Yue Jin, Jennifer K. Ryan Jan 2016

Can Contracts Replace Qualification In A Sourcing Process With Competitive Suppliers And Imperfect Information?, Yue Jin, Jennifer K. Ryan

Department of Supply Chain Management and Analytics: Faculty and Staff Publications

This paper considers a manufacturer who outsources the production of a product to multiple competing suppliers, who differ in their cost structures and in their capabilities for producing high-quality products. The manufacturer must design the sourcing process to ensure that the selected supplier has sufficient quality capability, while encouraging competition among the suppliers. We develop and analyze a mathematical model of performance-based contracting, a sourcing method that is appropriate when the manufacturer has imperfect information regarding the suppliers’ costs and capabilities. We compare the performance of performance-based contracting with that of a two-stage sourcing process, an alternative sourcing method that …


Challenges For Developing Complex System Governance, Charles B. Keating, Polinpaplinho F. Katina, Joseph M. Bradley, Sila Çetinkaya (Ed.), J. K. Ryan (Ed.) Jan 2015

Challenges For Developing Complex System Governance, Charles B. Keating, Polinpaplinho F. Katina, Joseph M. Bradley, Sila Çetinkaya (Ed.), J. K. Ryan (Ed.)

Engineering Management & Systems Engineering Faculty Publications

This paper examines the challenges and practice implications for Complex System Governance (CSG). CSG is presented as an emerging field focused on the design, execution, and evolution of the higher order (metasystem) functions necessary to provide control, communication, coordination, and integration of a complex system. This paper is focused on three primary objectives. First, we introduce the complex system problem domain that the CSG field is being designed to address. The pervasiveness of this problem domain is demonstrated by a short examination of the water utilities sector. Second, we expound the nature of CSG and an emerging reference model …


Resource Planning In Engineering Services Firms, Vincent Hargaden, Jennifer K. Ryan Jan 2015

Resource Planning In Engineering Services Firms, Vincent Hargaden, Jennifer K. Ryan

Department of Supply Chain Management and Analytics: Faculty and Staff Publications

We develop a model to enable engineering professional services firms to improve the management of their competitive resources, i.e., skilled engineers, to be better able to respond to customer demand. The model was informed by semistructured interviews with senior executives from engineering, information technology (IT) services and technical consulting firms. As a result, we capture many of the complexities associated with the resource planning process in the professional engineering services sector. In the resulting model, the key attributes of supply, demand, and operations constraints are identified. Based on information obtained from the interviews, a number of test firms are created.We …


Two Stage Procurement Processes With Competitive Suppliers And Uncertain Supplier Quality, Yue Jin, Jennifer K. Ryan, Walter Yund Jan 2014

Two Stage Procurement Processes With Competitive Suppliers And Uncertain Supplier Quality, Yue Jin, Jennifer K. Ryan, Walter Yund

Department of Supply Chain Management and Analytics: Faculty and Staff Publications

This paper considers a sourcing problem faced by a manufacturer who outsources the manufacturing of a product to one of several competing suppliers, whose cost and quality capabilities are unknown. We consider a two-stage sourcing process in which the first stage is the qualification stage, while the second stage is the supplier selection stage. In the first stage, the manufacturer exerts effort to learn about the quality level of each of the suppliers and then must determine the set of qualified suppliers, subject to some tolerance for error. In the second stage, the manufacturer runs a price-only procurement auction, in …


Coordinating A Supply Chain With A Manufacturer-Owned Online Channel: A Dual Channel Model Under Price Competition, Jennifer K. Ryan, Daewon Sun, Xuying Zhao Jan 2013

Coordinating A Supply Chain With A Manufacturer-Owned Online Channel: A Dual Channel Model Under Price Competition, Jennifer K. Ryan, Daewon Sun, Xuying Zhao

Department of Supply Chain Management and Analytics: Faculty and Staff Publications

We consider a dual channel supply chain in which a manufacturer sells a single product to end-users through both a traditional retail channel and a manufacturer-owned direct online channel. We adopt a commonly used linear demand substitution model in which the mean demand in each channel is a function of the prices in each channel.We model each channel as a news vendor problem, with price and order quantity as decision variables. In addition, the manufacturer must choose the wholesale price to charge to the independent retailer. We analyze the optimal decisions for each channel and prove the existence of a …


Modeling Social Transmission Dynamics Of Unhealthy Behaviors For Evaluating Prevention And Treatment Interventions On Childhood Obesity, Leah M. Frerichs, Ozgur M. Araz, Terry T.-K. Huang Jan 2013

Modeling Social Transmission Dynamics Of Unhealthy Behaviors For Evaluating Prevention And Treatment Interventions On Childhood Obesity, Leah M. Frerichs, Ozgur M. Araz, Terry T.-K. Huang

Department of Supply Chain Management and Analytics: Faculty and Staff Publications

Research evidence indicates that obesity has spread through social networks, but lever points for interventions based on overlapping networks are not well studied. The objective of our research was to construct and parameterize a system dynamics model of the social transmission of behaviors through adult and youth influence in order to explore hypotheses and identify plausible lever points for future childhood obesity intervention research. Our objectives were: (1) to assess the sensitivity of childhood overweight and obesity prevalence to peer and adult social transmission rates, and (2) to test the effect of combinations of prevention and treatment interventions on the …


F.A.C.E.S. (Faculty Academic Community Education Showcase): Professional Growth Experiences In A Career University, Paul J. Colbert, Ph.D. Apr 2012

F.A.C.E.S. (Faculty Academic Community Education Showcase): Professional Growth Experiences In A Career University, Paul J. Colbert, Ph.D.

MBA Faculty Conference Papers & Journal Articles

Institutes of higher education exist for the purpose of developing, fostering, nurturing, and stimulating the intellectual growth and development of students. The core values of a college education provide students conceptual and practical educational opportunities that focus on improving their skills and knowledge. These skills and knowledge translate into purposeful, real-life learning experiences. However, in the academic community, learning is not restricted to students. Faculty, too, must be supported and provided opportunities for personal and professional growth and development. Although professional development is not a novel concept in the education profession, schools often take up the gauntlet, but fall short …


Simulating School Closure Policies For Cost Effective Pandemic Decision Making, Ozgur M. Araz, Paul Damien, David A. Paltiel, Sean Burke, Bryce Van De Geijn, Alison Galvani, Lauren Ancel Meyers Jan 2012

Simulating School Closure Policies For Cost Effective Pandemic Decision Making, Ozgur M. Araz, Paul Damien, David A. Paltiel, Sean Burke, Bryce Van De Geijn, Alison Galvani, Lauren Ancel Meyers

Department of Supply Chain Management and Analytics: Faculty and Staff Publications

Background: Around the globe, school closures were used sporadically to mitigate the 2009 H1N1 influenza pandemic. However, such closures can detrimentally impact economic and social life.

Methods: Here, we couple a decision analytic approach with a mathematical model of influenza transmission to estimate the impact of school closures in terms of epidemiological and cost effectiveness. Our method assumes that the transmissibility and the severity of the disease are uncertain, and evaluates several closure and reopening strategies that cover a range of thresholds in school-aged prevalence (SAP) and closure durations.

Results: Assuming a willingness to pay per quality adjusted life-year (QALY) …


Alternate Models For Forecasting Hedge Fund Returns, Michael A. Holden May 2011

Alternate Models For Forecasting Hedge Fund Returns, Michael A. Holden

Senior Honors Projects

Alternate Models for Forecasting Hedge Fund Returns

Michael Holden

Faculty Sponsor: Gordon Dash, Finance and Decision Sciences

Investors have always wanted to improve the efficiency of modeling realized volatility to maximize directional trading returns and substantially improve profitability. As proposed, this honors project will provide evidence from hedge fund returns that a Radial-Basis Function (RBF) artificial neural network (ANN), specifically the Kajiji-4 RBF-ANN dominates other forecast methods in producing one-period ahead change-of-direction when forecasting the expected returns of various hedge fund indexes.

I began this project by collecting historical economic data in monthly increments to serve as the dependent variables. …


Towards Evaluating The Quality Of A Spreadsheet: The Case Of The Analytical Spreadsheet Model, Thomas A. Grossman Jr., Vijay Mehrotra, J Sander Jan 2011

Towards Evaluating The Quality Of A Spreadsheet: The Case Of The Analytical Spreadsheet Model, Thomas A. Grossman Jr., Vijay Mehrotra, J Sander

Business Analytics and Information Systems

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 …