One-file paste prompt for producing a complete tidyverse R analysis script in an owner-familiar coding style. It is not an installable R package, Airflow replacement, or job scheduler.
Paste ENGINE.md into an AI together with a short owner brief. The model produces one R script with a thin configuration layer, named stage functions, a quality gate, and non-transforming publication outputs.
| Stage | Responsibility |
|---|---|
| Prep | Read, join, tidy, complete a panel when required, and apply the analysis window |
| Analyze | Split by named groups and apply one parameterized metric function |
| Expand | Optionally add forecasts as columns on existing rows |
| Assure | Apply the single automatic quality gate |
| Publish | Send the validated tibbles to Excel, Shiny, or both without recomputation |
flowchart LR
A["Thin CONFIG"] --> B["Prep"]
B --> C["Analyze"]
C --> D["Optional expand"]
D --> E["Assure gate"]
E --> F["Excel or Shiny"]
- Copy
ENGINE.md. - Paste it into ChatGPT, Grok, or DeepSeek.
- Attach an owner brief, or allow the generic in-memory demonstration to run.
- Review the generated tidyverse R script and execute it against the intended data.
The owner brief supplies file paths, join keys, date column, analysis window, grouping variables, forecast choice, publication target, and business recodes. The engine chooses appropriate column names and charts while preserving the locked workflow structure.
The engine is applied in the FulfillIQ portfolio project:
That implementation demonstrates the engine's named configuration, stage functions, explicit skips, assurance gate, and Excel publication path on a seller-performance analysis.
- Familiar
%>%-based tidyverse pipelines - Ordinary verbs used directly after libraries are attached
- Practical intermediate objects and linear stage bodies
- Named lists and explicit column roles
map()over group names rather than column positionsimap()for visible, directopenxlsxworkbook construction- One reusable metric function
- A single quality gate before publication
- Necessary unfamiliar techniques isolated and briefly explained
- Publication from validated objects without hidden recomputation
This is my preferred analytical dialect, not a copy of a former employer's internal framework.
Grok Bot coordinated Grok, ChatGPT, and DeepSeek through independent drafting, cross-critique, and controlled synthesis. Disagreements were resolved against the engine's locked requirements rather than by majority vote. The owner retained final keep/cut authority.
ENGINE.md— complete one-file promptdocs/r-workflow-engine-carousel.pdf— concise document carouselREADME.md— project overview and implemented example
- Generated code still requires human review and execution against the intended data.
- The repository is a prompt-based analytical specification, not an R package.
- The engine does not replace source-specific measurement design.
MIT. Copyright 2026 Mark Ciganovic.