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=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba
analysis.md: https://space.hammer.ai/skills/global/analysis.skill.txt?ledger=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba
coverage-website.md: https://space.hammer.ai/skills/global/coverage-website.skill.txt?ledger=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba

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

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=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba
OData exploration and analytic cuts: https://space.hammer.ai/odata.skill.txt?ledger=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba
Worked analysis reference: https://space.hammer.ai/skills/global/analysis.skill.txt?ledger=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba
Building sourced Excel models: https://space.hammer.ai/skills/global/building-sourced-excel-models.skill.txt?ledger=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba
Coverage website reference: https://space.hammer.ai/skills/global/coverage-website.skill.txt?ledger=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba
Spine cohort and post-acute analysis: https://space.hammer.ai/skills/spine-analysis.skill.txt?ledger=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba
hammer-building-the-evidence: https://space.hammer.ai/skills/world/hammer-building-the-evidence.skill.txt?ledger=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba
hammer-cost-of-care-case: https://space.hammer.ai/skills/world/hammer-cost-of-care-case.skill.txt?ledger=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba
hammer-coverage-navigate: https://space.hammer.ai/skills/world/hammer-coverage-navigate.skill.txt?ledger=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba
hammer-provider-contracting: https://space.hammer.ai/skills/world/hammer-provider-contracting.skill.txt?ledger=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba
hammer-provider-quality: https://space.hammer.ai/skills/world/hammer-provider-quality.skill.txt?ledger=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba
hammer-savings-classification: https://space.hammer.ai/skills/world/hammer-savings-classification.skill.txt?ledger=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba
hammer-vendor-evidence: https://space.hammer.ai/skills/world/hammer-vendor-evidence.skill.txt?ledger=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba
hammer-writing-the-deliverable: https://space.hammer.ai/skills/world/hammer-writing-the-deliverable.skill.txt?ledger=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba
Data: https://space.hammer.ai/data/?ledger=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba
Transcript: https://space.hammer.ai/session/?ledger=e42d7ef6e11ae35efb35a685235861cb&snapshot=7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba