Build a sourced analysis
Scope: global method, website edition 1
Revision SHA-256: 6f089a17adf8af280f5b041ccf37032b4b56bece088a99961785ab5e54a6cbd6

---
name: building-sourced-excel-models
description: Build an auditable model from typed evidence, explicit assumptions and owner-supplied operating inputs.
---

Website edition. Use ordinary HTML links and forms. No connector is required.

Start with the case question. Write each input and its grain, unit, population, period,
owner and status: sourced, provisional, pending, assumption or need. State dependencies.
Read the world method linked beside each source. A method is guidance, not evidence.

SOURCE SWITCH
Public register facts and benchmarks: explore data and run the appropriate analysis.
Customer operating facts: create a need with an owner and exact requested cut.
Do not repeatedly search public data for private enrollment, workflow or billing facts.
Payer mix is sourceable only when evidence describes the intended patient cohort.
General hospital or county mix remains a proxy, with the mismatch visible.

EVIDENCE
Read schema and source scope before rows. Preserve leading zeros, exact decimals,
nulls and units. Keep selection filters, snapshot and receipt with each sourced input.
Follow next-page links; a page is not the whole population. Count the same selection.
Graph adjacency is a relation, not proof that a financial or clinical inference follows.
Do not join payer names without the world's identity rules.

MODEL
Keep source facts, assumptions and formulas separate. Preserve individual input rows
and citations. Never hide missing eligibility by substituting zero. Show scenario ranges
only for explicitly labelled assumptions. Record what would change the decision.

SPINE / RTM CASE
Annual spine volume needs deduplicated patients, period, institution and surgical split.
Payer mix needs the same cohort and period, with Medicare and Medicare Advantage separate.
RTM enrollment and monthly qualification are separate denominators. The supplied 16-day
threshold is a premise to verify against the applicable code and rule year, not a rule
established by this guide. Ask operations for active enrollment and observed eligible months.
Billing needs the actual clinician or practice, eligibility and payer-specific arrangement.
Unknown billing eligibility blocks recognized revenue; it does not establish zero revenue.
Surgical cost avoidance needs an explicit case scope and NYU baseline cost. Charges and
negotiated rates do not establish cost. Keep deferred spend separate from avoided spend.

CHECK AND DELIVER
Run claim_check for quantitative statements and judgement_check for interpretations.
Read the returned verdict; sending a claim does not make it supported. Review the session
transcript and unresolved needs before writing conclusions. Delivery is an explicit form
submission, never an automatic action caused by following a link.

Keep ledger and snapshot on every internal request. Exact repeated operations reopen their
saved result. Guidance-served events record delivery only, not understanding or compliance.
Use browser forms for new arguments. Fetch-only clients may only follow links already shown.


HTTP bindings for this session:
Explicit source-reference bindings:
SKILL.md: https://space.hammer.ai/skills/global/building-sourced-excel-models.skill.txt?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
analysis.md: https://space.hammer.ai/skills/global/analysis.skill.txt?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
coverage-website.md: https://space.hammer.ai/skills/global/coverage-website.skill.txt?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm

rate_position: https://space.hammer.ai/analysis/rate_position/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
rate_comparison: https://space.hammer.ai/analysis/rate_comparison/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
stack_check: https://space.hammer.ai/analysis/stack_check/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
screening_yield: https://space.hammer.ai/analysis/screening_yield/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
deferred_versus_avoided: https://space.hammer.ai/analysis/deferred_versus_avoided/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
interpretation_requirement: https://space.hammer.ai/analysis/interpretation_requirement/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
cohort_figures: https://space.hammer.ai/analysis/cohort_figures/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
comorbidity_edges: https://space.hammer.ai/analysis/comorbidity_edges/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
fee_components: https://space.hammer.ai/analysis/fee_components/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
filed_charge: https://space.hammer.ai/analysis/filed_charge/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
hypertension_evidence: https://space.hammer.ai/analysis/hypertension_evidence/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
prognostic_association: https://space.hammer.ai/analysis/prognostic_association/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
treatment_effect: https://space.hammer.ai/analysis/treatment_effect/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
regression_to_mean_expectation: https://space.hammer.ai/analysis/regression_to_mean_expectation/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
competing_event_coupling: https://space.hammer.ai/analysis/competing_event_coupling/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
withhold_earnback: https://space.hammer.ai/analysis/withhold_earnback/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
tournament_position: https://space.hammer.ai/analysis/tournament_position/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
measure_reliability: https://space.hammer.ai/analysis/measure_reliability/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
declared_inputs: https://space.hammer.ai/analysis/declared_inputs/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
cost_of_care_exposure: https://space.hammer.ai/analysis/cost_of_care_exposure/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
savings_methodology: https://space.hammer.ai/analysis/savings_methodology/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
hospital_variance: https://space.hammer.ai/analysis/hospital_variance/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
filer_inventory: https://space.hammer.ai/analysis/filer_inventory/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
candidate_screen: https://space.hammer.ai/analysis/candidate_screen/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
frontier: https://space.hammer.ai/analysis/frontier/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
judgement_check: https://space.hammer.ai/analysis/judgement_check/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
claim_check: https://space.hammer.ai/analysis/claim_check/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
deliver: https://space.hammer.ai/analysis/deliver/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
session_trace: https://space.hammer.ai/analysis/session_trace/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
progress_check: https://space.hammer.ai/analysis/progress_check/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
model_advisory: https://space.hammer.ai/analysis/model_advisory/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
knowledge_navigate: https://space.hammer.ai/analysis/knowledge_navigate/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
simulate: https://space.hammer.ai/analysis/simulate/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
sensitivity: https://space.hammer.ai/analysis/sensitivity/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
interval_check: https://space.hammer.ai/analysis/interval_check/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
decision_navigate: https://space.hammer.ai/analysis/decision_navigate/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
network_infer: https://space.hammer.ai/analysis/network_infer/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
hello_world: https://space.hammer.ai/analysis/hello_world/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
say_world: https://space.hammer.ai/analysis/say_world/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm

Read the companion references here (these replace local file references in the source guide):
Build a sourced analysis: https://space.hammer.ai/analysis.skill.txt?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
OData exploration and analytic cuts: https://space.hammer.ai/odata.skill.txt?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
Worked analysis reference: https://space.hammer.ai/skills/global/analysis.skill.txt?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
Building sourced Excel models: https://space.hammer.ai/skills/global/building-sourced-excel-models.skill.txt?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
Coverage website reference: https://space.hammer.ai/skills/global/coverage-website.skill.txt?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
Spine cohort and post-acute analysis: https://space.hammer.ai/skills/spine-analysis.skill.txt?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
hammer-building-the-evidence: https://space.hammer.ai/skills/world/hammer-building-the-evidence.skill.txt?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
hammer-cost-of-care-case: https://space.hammer.ai/skills/world/hammer-cost-of-care-case.skill.txt?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
hammer-coverage-navigate: https://space.hammer.ai/skills/world/hammer-coverage-navigate.skill.txt?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
hammer-provider-contracting: https://space.hammer.ai/skills/world/hammer-provider-contracting.skill.txt?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
hammer-provider-quality: https://space.hammer.ai/skills/world/hammer-provider-quality.skill.txt?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
hammer-savings-classification: https://space.hammer.ai/skills/world/hammer-savings-classification.skill.txt?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
hammer-vendor-evidence: https://space.hammer.ai/skills/world/hammer-vendor-evidence.skill.txt?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
hammer-writing-the-deliverable: https://space.hammer.ai/skills/world/hammer-writing-the-deliverable.skill.txt?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
Data: https://space.hammer.ai/data/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm
Transcript: https://space.hammer.ai/session/?ledger=49ec6090f32b112cd7fc2d39a72e0974&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba&workflow=spine-rtm