# dr-get-formula

> Claude/Codex skill by [@datarails](https://omgskills.com/library/datarails/index.md) · 3 stars · Updated 2026-09-22

Generate Excel workbooks with DR.GET formulas that pull live financial data from Datarails. Creates P&L templates, budget models, and variance reports with validated dimension values. Asks which account level to cut the P&L at and which design to use before building. Self-contained — discovers the client's financials table and fields on its own, no profile or setup step required.

## Install

```sh
git clone https://github.com/Datarails/dr-claude-code-plugins-re /tmp/dr-claude-code-plugins-re && ln -s /tmp/dr-claude-code-plugins-re/skills/get-formula ~/.claude/skills/dr-get-formula
```

## From README

DR.GET Formula Workbook Generator Generate Excel workbooks containing DR.GET formulas that pull live financial data from Datarails when opened with the Datarails Excel Add-in. DR.GET is a custom Excel function that bridges Datarails' centralized financial database and Excel-based models. Formulas auto-refresh when the workbook is opened with the add-in active. ⚠️ Two output modes — resolve one in Step 0, never guess. In a live Excel context (add-in agent bridge available) this skill writes into the open workbook and refreshes through the agent (in-sheet mode, Step 7-A). With no bridge it generates an .xlsx with openpyxl (file mode, Step 7-B). A user who asks for a file — --file, --output, or plain phrasing — gets file mode regardless of the bridge; mutating live cells is never a substitute for a file someone asked for. Writing DR.GET formulas and refreshing them is one atomic step in in-sheet mode: freshly written formulas read Missing / Loading… / \#BUSY!

## Links

- HTML page: https://omgskills.com/library/datarails/dr-claude-code-plugins-re/skills/get-formula/
- GitHub: https://github.com/Datarails/dr-claude-code-plugins-re
- Author: [@datarails](https://omgskills.com/library/datarails/index.md)

## More from this repo

- [datarails-excel-agent](https://omgskills.com/library/datarails/dr-claude-code-plugins-re/skills/datarails-excel-agent/index.md) — Datarails operations on the OPEN Excel workbook.
   - [@datarails](https://omgskills.com/library/datarails/index.md) · 3 stars
- [dr-anomalies](https://omgskills.com/library/datarails/dr-claude-code-plugins-re/skills/anomalies/index.md) — Detect data anomalies in one Datarails Finance OS table and answer IN CHAT — severity-ranked outliers, duplicates,...
   - [@Datarails](https://omgskills.com/library/datarails/index.md) · 3 stars
- [dr-anomalies-report](https://omgskills.com/library/datarails/dr-claude-code-plugins-re/skills/anomalies-report/index.md) — Detect data anomalies and generate a comprehensive data-quality Excel WORKBOOK from Finance OS tables, computed over...
   - [@Datarails](https://omgskills.com/library/datarails/index.md) · 3 stars