Model Migration: from Excel to R
summary
Describes migrating a monolithic Excel model into R and why copying Excel verbatim causes failure not success. Converts a 10–15 million iteration simulation that originally appends rows across sheets into a list of simulation results then binds them, avoiding repeated object copies and memory blowouts, having earlier crashed the server by looping and attempting premature parallelism. Emphasizes abstract A to B, identify operations and data structures, and don’t replicate Excel—start simple and profile.
AI-written summary · about
chapters (4)
related talks
46mModel Mitosis: Stop making the wrong choice between microservices and monolith
05mR Scripts to Databricks: Lessons in Production Workflow
40mLegacy Evolution – The Innovation Opportunity!
35mRow, Row, Row Your Rows Surviving Multi Agency Government Drupal Migrations
50mModel Mitosis: a dynamic pattern to deal with model tensions
48mModel Mitosis: Stop Confusing Microservices and the Monolith
05mCoding Tools for Industry R&D – Development Lessons from an Analytical Lab
49mMitosis Pattern