37 citations · 88 across the 12 of their papers we have counts for
12 papers
Spreadsheet Modeling Experiments Using GPTs on Small Problem Statements and the Wall Task
Thomas A. Grossman, Yuan Chen, Sopiko Datuashvili
This paper investigates how GPT-based tools can assist in building reusable analytical spreadsheet models. After a screening, we evaluate five GPT extensions and select Excel AI by…
A Use Case-Engineering Resources Taxonomy for Analytical Spreadsheet Models
Thomas A. Grossman, Vijay Mehrotra
This paper presents a taxonomy for analytical spreadsheet models. It considers both the use case that a spreadsheet is meant to serve, and the engineering resources devoted to its…
Alternative Spreadsheet Model Designs for an Operations Management Model Embedded in a Periodic Business Process
Thomas A. Grossman, Vijay Mehrotra, Mouwafac Sidaoui
We present a widely-used operations management model used in supply and distribution planning, that is typically embedded in a periodic business process that necessitates model mod…
Towards Evaluating the Quality of a Spreadsheet: The Case of the Analytical Spreadsheet Model
Thomas A. Grossman, Vijay Mehrotra, Johncharles Sander
We consider the challenge of creating guidelines to evaluate the quality of a spreadsheet model. We suggest four principles. First, state the domain-the spreadsheets to which the g…
Spreadsheets Grow Up: Three Spreadsheet Engineering Methodologies for Large Financial Planning Models
Thomas A. Grossman, Ozgur Ozluk
Many large financial planning models are written in a spreadsheet programming language (usually Microsoft Excel) and deployed as a spreadsheet application. Three groups, FAST Allia…
The Lookup Technique to Replace Nested-IF Formulas in Spreadsheet Programming
Thomas A. Grossman, Ozgur Ozluk, Jan Gustavson
Spreadsheet programmers often implement contingent logic using a nested-IF formula even though this technique is difficult to test and audit and is believed to be risky. We interpr…