IDEAS home Printed from https://ideas.repec.org/a/eee/jomega/v25y1997i5p595-598.html
   My bibliography  Save this article

Some comments on "modeling optimization problems in the unstructured world of spreadsheets"

Author

Listed:
  • King, Malcolm

Abstract

This paper suggests that the use of spreadsheets for teaching students about LP modelling can be further enhanced by supplying students with a suitable template at the introductory stage. With a rearrangement of the layout, which corresponds to a standard pedagogic approach, it is possible to create a template, with locked formulae, which is easy to use and flexible enough to handle problems of different sizes. Such a template would help students concentrate on LP modelling concepts rather than being distracted by spreadsheet errors.

Suggested Citation

  • King, Malcolm, 1997. "Some comments on "modeling optimization problems in the unstructured world of spreadsheets"," Omega, Elsevier, vol. 25(5), pages 595-598, October.
    • Handle: RePEc:eee:jomega:v:25:y:1997:i:5:p:595-598
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0305-0483(97)00019-4
    Download Restriction: Full text for ScienceDirect subscribers only
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Conway, D. G. & Ragsdale, C. T., 1997. "Modeling optimization problems in the unstructured world of spreadsheets," Omega, Elsevier, vol. 25(3), pages 313-322, June.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Cunha, Claudio Barbieri & Mutarelli, Fernando, 2007. "A spreadsheet-based optimization model for the integrated problem of producing and distributing a major weekly newsmagazine," European Journal of Operational Research, Elsevier, vol. 176(2), pages 925-940, January.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Lawson, Barry R. & Baker, Kenneth R. & Powell, Stephen G. & Foster-Johnson, Lynn, 2009. "A comparison of spreadsheet users with different levels of experience," Omega, Elsevier, vol. 37(3), pages 579-590, June.
    2. John F. Raffensperger, 2003. "New Guidelines for Spreadsheets," International Journal of Business and Economics, School of Management Development, Feng Chia University, Taichung, Taiwan, vol. 2(2), pages 141-154, August.
    3. John Miltenburg, 2019. "Online Teaching in a Large, Required, Undergraduate Management Science Course," INFORMS Transactions on Education, INFORMS, vol. 19(2), pages 89-104, January.
    4. Larry J. LeBlanc & Michael R. Galbreth, 2007. "Implementing Large-Scale Optimization Models in Excel Using VBA," Interfaces, INFORMS, vol. 37(4), pages 370-382, August.
    5. LeBlanc, Larry J. & Grossman, Thomas A. & Bartolacci, Michael R., 2019. "Ensuring scalability and reusability of spreadsheet linear programming models," Omega, Elsevier, vol. 84(C), pages 55-69.
    6. Larry J. LeBlanc & Michael R. Bartolacci & Thomas A. Grossman, 2017. "ASP, The Art and Science of Practice: Increasing Productivity and Minimizing Errors in Operations Research Spreadsheet Models," Interfaces, INFORMS, vol. 47(3), pages 260-269, June.
    7. Cunha, Claudio Barbieri & Mutarelli, Fernando, 2007. "A spreadsheet-based optimization model for the integrated problem of producing and distributing a major weekly newsmagazine," European Journal of Operational Research, Elsevier, vol. 176(2), pages 925-940, January.
    8. Larry J. LeBlanc & Dale Randels & T. K. Swann, 2000. "Heery International's Spreadsheet Optimization Model for Assigning Managers to Construction Projects," Interfaces, INFORMS, vol. 30(6), pages 95-106, December.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:eee:jomega:v:25:y:1997:i:5:p:595-598. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Catherine Liu (email available below). General contact details of provider: http://www.elsevier.com/wps/find/journaldescription.cws_home/375/description#description .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.