Matches in SemOpenAlex for { <https://semopenalex.org/work/W4386607579> ?p ?o ?g. }
Showing items 1 to 64 of
64
with 100 items per page.
- W4386607579 abstract "Because of the limitations on problem size with the built-in optimization solver in Microsoft Excel, other software applications are required to illustrate the power of integer linear programming in spreadsheets. The built-in linear optimization solver in LibreOffice Calc allows much larger problems. In this paper, we build a spreadsheet in LibreOffice Calc to solve sudoku problems and a simple generalization that further illustrates the power of integer linear programming in spreadsheets. The generalization we consider, n-doku, also introduces an interesting puzzle that includes, as a special case, a union of multiple sudoku puzzles. Besides further demonstrating the power of integer linear programming in spreadsheets, we use the n-doku solutions to develop optimization intuition and to, more generally, foster critical thinking. We use this spreadsheet in the classroom to transition from continuous to categorical decisions, emphasizing the idea of one-hot encoding. We also illustrate multiple optima and add preferences to sudoku puzzles as a way introduce multiobjective optimization. Supplemental Material: The online supplement is available at https://doi.org/10.1287/ited.2022.0068 ." @default.
- W4386607579 created "2023-09-12" @default.
- W4386607579 creator A5055992629 @default.
- W4386607579 date "2023-09-11" @default.
- W4386607579 modified "2023-09-29" @default.
- W4386607579 title "Integer Linear Programming: Spreadsheet Solver Excellence Without Excel" @default.
- W4386607579 cites W1997818347 @default.
- W4386607579 cites W2105250948 @default.
- W4386607579 cites W2130564774 @default.
- W4386607579 cites W2169873486 @default.
- W4386607579 cites W2200828225 @default.
- W4386607579 doi "https://doi.org/10.1287/ited.2022.0068" @default.
- W4386607579 hasPublicationYear "2023" @default.
- W4386607579 type Work @default.
- W4386607579 citedByCount "0" @default.
- W4386607579 crossrefType "journal-article" @default.
- W4386607579 hasAuthorship W4386607579A5055992629 @default.
- W4386607579 hasBestOaLocation W43866075791 @default.
- W4386607579 hasConcept C11413529 @default.
- W4386607579 hasConcept C119857082 @default.
- W4386607579 hasConcept C123558587 @default.
- W4386607579 hasConcept C126255220 @default.
- W4386607579 hasConcept C134306372 @default.
- W4386607579 hasConcept C177148314 @default.
- W4386607579 hasConcept C199360897 @default.
- W4386607579 hasConcept C2777904410 @default.
- W4386607579 hasConcept C2778770139 @default.
- W4386607579 hasConcept C33923547 @default.
- W4386607579 hasConcept C41008148 @default.
- W4386607579 hasConcept C41045048 @default.
- W4386607579 hasConcept C5274069 @default.
- W4386607579 hasConcept C56086750 @default.
- W4386607579 hasConcept C97137487 @default.
- W4386607579 hasConceptScore W4386607579C11413529 @default.
- W4386607579 hasConceptScore W4386607579C119857082 @default.
- W4386607579 hasConceptScore W4386607579C123558587 @default.
- W4386607579 hasConceptScore W4386607579C126255220 @default.
- W4386607579 hasConceptScore W4386607579C134306372 @default.
- W4386607579 hasConceptScore W4386607579C177148314 @default.
- W4386607579 hasConceptScore W4386607579C199360897 @default.
- W4386607579 hasConceptScore W4386607579C2777904410 @default.
- W4386607579 hasConceptScore W4386607579C2778770139 @default.
- W4386607579 hasConceptScore W4386607579C33923547 @default.
- W4386607579 hasConceptScore W4386607579C41008148 @default.
- W4386607579 hasConceptScore W4386607579C41045048 @default.
- W4386607579 hasConceptScore W4386607579C5274069 @default.
- W4386607579 hasConceptScore W4386607579C56086750 @default.
- W4386607579 hasConceptScore W4386607579C97137487 @default.
- W4386607579 hasLocation W43866075791 @default.
- W4386607579 hasOpenAccess W4386607579 @default.
- W4386607579 hasPrimaryLocation W43866075791 @default.
- W4386607579 hasRelatedWork W134055995 @default.
- W4386607579 hasRelatedWork W1504088526 @default.
- W4386607579 hasRelatedWork W1862675270 @default.
- W4386607579 hasRelatedWork W2160856614 @default.
- W4386607579 hasRelatedWork W2348670029 @default.
- W4386607579 hasRelatedWork W2753007631 @default.
- W4386607579 hasRelatedWork W3118867582 @default.
- W4386607579 hasRelatedWork W4238890272 @default.
- W4386607579 hasRelatedWork W4298298787 @default.
- W4386607579 hasRelatedWork W4385400069 @default.
- W4386607579 isParatext "false" @default.
- W4386607579 isRetracted "false" @default.
- W4386607579 workType "article" @default.