Publicidad

Publicidad

becas.universia.netBiblioteca.Net

Buscar recursos:

Buscador Google

Resource data



Ver

Creation Of A Linear Optimization File Format
Cavolo, Richard A. Jr.
Location: http://hdl.handle.net/1811/308

Every year, over one hundred Industrial and Systems Engineering at Ohio State students take courses that teach them the basics of linear and integer programming. Currently, students in these courses are taught to use a built in Excel solver or CPLEX using the LP or MPS file formats. These formats make it frustrating for students to create, modify, and debug mathematical programs. This frustration can prevent students from learning. This paper suggests the use of a high-level Excel specification format that is easier to use and more powerful than the formats that are currently taught. An Excel add-in was created to convert this new file format into an industry standard format. The new format and conversion program have many features to help students create, modify, read, and debug their models. Each section of the model has a column for a description and many different ways to add comments and notes exist. In addition, all of Excel’s features can be used to derive the end model. Finally, an error checker that gives specific feedback and suggestions for fixing errors is built into the file converter. The new format still needs to be extensively tested and some features are yet to be added. In addition, testing should be done to determine how the use of the new format influences the learning of mathematical programming.

Belongs to: The KnowledgeBank at OSU

Descargar SCORM

¡Sea el primero en solicitar este recurso!

Para poder solicitar este recurso debe identificarse como usuario de la biblioteca

Users rating

No hay ninguna valoración para este recurso. Sea el primero en valorar este recurso.

Detalles del recurso

Creation Of A Linear Optimization File Format
Id. 4605257
Idioma inglés (Estados Unidos)
Titulo Creation Of A Linear Optimization File Format
Autor(es) Cavolo, Richard A. Jr.
Location http://hdl.handle.net/1811/308
Versión 1.0
Estado Final
Descripción Every year, over one hundred Industrial and Systems Engineering at Ohio State students take courses that teach them the basics of linear and integer programming. Currently, students in these courses are taught to use a built in Excel solver or CPLEX using the LP or MPS file formats. These formats make it frustrating for students to create, modify, and debug mathematical programs. This frustration can prevent students from learning. This paper suggests the use of a high-level Excel specification format that is easier to use and more powerful than the formats that are currently taught. An Excel add-in was created to convert this new file format into an industry standard format. The new format and conversion program have many features to help students create, modify, read, and debug their models. Each section of the model has a column for a description and many different ways to add comments and notes exist. In addition, all of Excel’s features can be used to derive the end model. Finally, an error checker that gives specific feedback and suggestions for fixing errors is built into the file converter. The new format still needs to be extensively tested and some features are yet to be added. In addition, testing should be done to determine how the use of the new format influences the learning of mathematical programming.
Tipo 397830 bytes
578560 bytes
application/pdf
application/vnd.ms-excel
Palabras clave Linear Programming
Tipo de recurso Software
Thesis
Tipo de Interactividad Expositivo
Nivel de Interactividad muy bajo
Audiencia Estudiante
Profesor
Autor
Estructura Atomic
Coste no
Copyright
Formatos 397830 bytes
578560 bytes
application/pdf
application/vnd.ms-excel
Requerimientos técnicos Browser: Any
Relación [References] The Ohio State University. Department of Industrial, Welding and Systems Engineering Honors Theses;2005
Fecha de contribución 29-oct-2006
Contacto