Resource data
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 |
sí
|
| 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 |
|
|