Spreadsheet Error Detection and Debugging Approach for Dynamic Discrete Inventory Control Models
DOI:
https://doi.org/10.23055/ijietap.2019.26.5.4727Keywords:
spreadsheet modeling, error detection, error analysis, discrete-time systems, inventory controlAbstract
Spreadsheets have been widely used in many business and scientific areas for modeling and simulation. Nevertheless, a number of research surveys have shown that these applications are particularly prone to errors. Some of the reasons for this error-proneness can be attributed to the fact that spreadsheet models are usually developed by the end-users and that standard software quality assurance processes are typically not applied. In addition, end-users often don't have a "clear picture" about the model structure and elements represented in the spreadsheet. The paper presents error detection and debugging approach developed for dynamic discrete spreadsheet models of inventory control. Spreadsheet modeling of inventory dynamics is based on the utilization of the discrete-time system control concept. This concept provides additional rules (common and specific constraints) which can be used for error detection. Preliminary experiments show general applicability of the approach.
Published
How to Cite
Issue
Section
License
The Author(s) must formally transfer each article's copyright before publication in the INTERNATIONAL JOURNAL OF INDUSTRIAL ENGINEERING. Such transfer enables the Journal to defend itself against plagiarism and other forms of copyright infringement. Your cooperation is appreciated.
You agree that the copyright of your article to be published in the INTERNATIONAL JOURNAL OF INDUSTRIAL ENGINEERING - THEORY, APPLICATIONS, AND PRACTICE is hereby transferred, throughout the World and for the full term and all extensions and renewals thereof, to INTERNATIONAL JOURNAL OF INDUSTRIAL ENGINEERING - THEORY, APPLICATIONS, AND PRACTICE.
The Author(s) reserve(s): (a) the trademark rights and patent rights, if any, and (b) the right to use all or part of the information contained in this article in future, non-commercial works of the Author's own, or, if the article is a "work-for-hire" and made within the scope of the Author's employment, the employer may use all or part of the information contained in this article for intra-company use, provided the usual acknowledgments are given regarding copyright notice and reference to the original publication.
The Author(s) warrant(s) that the article is Author's original work and has not been published before. If excerpts from copyrighted works are included, the Author will obtain written permission from the copyright owners and credit the article's sources.
The author also warrants that the article contains no libelous or unlawful statements and does not infringe on the rights of others. If the article was prepared jointly with other Author(s), the Author agrees to inform the co-Author(s) of the terms of the copyright transfer and to sign on their behalf; or in the case of a "work-for-hire," the employer or an authorized representative of the employer.
The journal does not provide the author copy of the final paper when it is published. The author(s) can make(s) a subscription to INTERNATIONAL JOURNAL OF INDUSTRIAL ENGINEERING - THEORY, APPLICATIONS, AND PRACTICE if they want to get the final paper that has already been published.
The journal is registered with the Library of Congress (ISSN # 1943-670X). All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the journal.
The author reserves patent and trademark rights and the right to use all or part of the information contained in the article in future non-commercial works.
