MétaCan
Menu
Back to cohort
Record W2086414271 · doi:10.1287/ited.3.2.55

Solving “Einstein's Riddle” Using Spreadsheet Optimization

2003· article· en· W2086414271 on OpenAlexaff
Julian Scott Yeomans

Bibliographic record

VenueINFORMS Transactions on Education · 2003
Typearticle
Languageen
FieldComputer Science
TopicSpreadsheets and End-User Computing
Canadian institutionsYork University
Fundersnot available
KeywordsEinsteinComputer scienceCalculus (dental)Theoretical physicsMathematicsPhysicsMathematical physicsMedicine

Abstract

fetched live from OpenAlex

A solution to Einstein's Riddle is presented using spreadsheet modelling and optimization. Various versions of this problem have been used in introductory management science (MS) classes either as an assignment or as a take-home exam. This riddle has proved to be a challenging problem, since it simultaneously integrates many of the elements that are taught throughout the semester. Namely, the ability to convert a somewhat complicated verbal description into requisite constraints, the creative modelling skills required to transform the problem into an assignment problem-type structure, no “true” or obvious objective function, a difficulty in determining what the (non-obvious) decision variables should be, the use of integer (binary) variables together with either-or constraints requiring satisfaction at equality (an added technical difficulty/challenge), the ubiquitous time issues involved in the solution of integer problems, the numerical representation of numbers by computers that are not readily obvious to business students (i.e. why supposedly integer values may appear in some form of scientific notation) and, most importantly, the ability to appropriately structure the problem formulation into a spreadsheet format for implementation with Solver.

Fetched live from OpenAlex and de-inverted. Abstracts are not stored in this database: the inverted indexes are 8.6 GB of the frame’s 9.3 GB of text, and the host has 13 GB free.

How this classification was reachedexpand

Full frame machine prediction

Teacher imitation

Not calibrated prevalence, not ground truth. Human validation pending. The Gemma side is a direct model label for every work in the frame, read from the title-only record. The Codex side is a classifier learned from the 10,348 direct Codex labels and calibrated to design-weighted sample rates; fields without enough sample support carry no Codex call. Candidate is the union of the two sides; consensus is their intersection. These outputs are machine_predicted_unvalidated and are not human labels.

metaresearch head score (Codex)0.003
metaresearch head score (Gemma)0.018
Version: metacan-v3-hybrid-931329e0061cValidation status: machine_predicted_unvalidated
Candidate categoriesnone
Consensus categoriesnone
DomainCandidate signal: none · Consensus signal: none
Study designCandidate signal: Not applicable · Consensus signal: none
GenreCandidate signal: Empirical · Consensus signal: none
Teacher disagreement score0.030
Threshold uncertainty score0.100

Distilled classifier scores by category (both heads)

CategoryCodexGemma
Metaresearch0.0030.018
Meta-epidemiology (narrow)0.0010.001
Meta-epidemiology (broad)0.0010.001
Bibliometrics0.0010.002
Science and technology studies0.0010.001
Scholarly communication0.0050.005
Open science0.0020.003
Research integrity0.0020.003
Insufficient payload (model declined to judge)0.0300.005

Machine scores (provisional)

The two teacher heads of the student model, read on this work. A score orders the frame for review; it never asserts a category, and the validation status ships verbatim with every row.

Baseline scores from an immature model (maturity gate not passed, 7 training rounds). Scores rank; they never assert a category.

Opus teacher head0.019
GPT teacher head0.254
Teacher spread0.235 · how far apart the two teachers sit on this one work
Validation statusscore_only:v0-immature-baseline · verbatim from the scoring run: score_only means the number may rank works, and no category label ships from it

Classification

machine, unvalidated

Machine predicted; a candidate call from one source (direct Gemma or distilled Codex), not a consensus.

The models applied no category: nothing in the taxonomy fit this work.
Study designNot applicable
Domainnot available
GenreEmpirical

How this classification was reached, model by model and score by score, is at the end of the page under "How this classification was reached".

Quick stats

Citations8
Published2003
Admission routes1
Has abstractyes

Explore more

Same venueINFORMS Transactions on EducationSame topicSpreadsheets and End-User ComputingFrench-language works237,207