This study figured out the advantages and disadvantages of modeling with spreadsheet tools. It compared with LINDO with reasonable size of LP problems. There were 6 advantages.
1. Problem description and problem modeling can be done on the same sprea...
This study figured out the advantages and disadvantages of modeling with spreadsheet tools. It compared with LINDO with reasonable size of LP problems. There were 6 advantages.
1. Problem description and problem modeling can be done on the same spreadsheet. But it can not be done on LINDO.
2. Spreadsheet modeling helps communications among the users in conrcern by using the same tool.
3. Spreadsheet modeling helps understanding and expression of the problem.
4. Spreadsheet modeling is easy to accomodate multistage implicit relations in problem.
5. Secondary analysis on the sensitivity reports can be done on the same spreadsheet.
6. It can use macros for further analysis and model utilization.
However, spreadsheet model is hard to verify its modeling. Mistranslation of the Solver terminologies into Korean causes serious differences between text books and spreadsheet modeling words such as 'Target Cell' and 'Objective Cell'.