# Local market evidence and capacity workbook Updated 2026-09-19. ## Purpose Linked market records, evidence gaps and conditional weekly capacity — what do the entered records support? ## Who uses this Owner or buyer with a local research partner ## Records to gather Coded sites, usable chairs, hours, visit assumptions, control codes and evidenced person-site schedules. ## Steps 1. Read Results and Use and Limits; review the separate Fictional Example. 2. Enter coded site records in Sites rows 7–106 and linked person-site records in People rows 7–106. Use matching site codes, dated evidence and consistent weekly periods. 3. Complete every entered row, including its identifiers. Partially entered sites count as records and keep whole-input capacity totals unavailable until corrected; do not treat an omitted code as an excluded site. 4. Review duplicate person-site records and the Total days exceed 7 warning. This checks aggregate reported days, not actual weekday or time overlap; inspect the underlying schedules separately. 5. Enter 0 only for a known zero. Review physical capacity, evidenced staffing and unresolved records separately; these figures do not estimate demand or rank locations. 6. Review unavailable or adverse results and supporting evidence; assign the missing record, reviewer, due date and next action in Review Actions. ## Key terms - **Trade area**: The explicitly defined area and population being studied. - **Provider days**: Observed clinician availability over a stated period, distinct from a directory listing. - **Evidence gap**: An unresolved claim requiring a dated source or observation. ## Fictional example Fictional example: Three chairs open 40 hours with 60-minute visits and an 80% usable-time assumption yield 96 physical visits per week. One verified 24-hour provider limits staffed capacity to 19.2. ## Next action Review each unavailable or adverse result, then assign the missing record, reviewer, due date and next action in Review Actions. ## Limits Formulas are editable and sheet protection is not enabled. Use only the prepared rows and keep a clean copy. Recalculation and XLSX reimport were checked with Artifact Tool; Excel desktop/web, Google Sheets and native printing have not been interactively tested. These are aggregate planning tools, not professional verification. ## AI coaching Help me complete this DenQAI file using the context below. Explain the supplied fictional example first, then ask one question at a time about my permitted fictional or aggregate, non-identifying inputs. Treat missing values as unknown, not zero. Keep example values separate from my case. Do not invent records, source verification, contract terms or professional conclusions. Identify the missing evidence and responsible reviewer before the next action. File: Local market evidence and capacity workbook (XLSX). Question: Linked market records, evidence gaps and conditional weekly capacity — what do the entered records support? Records to gather: Coded sites, usable chairs, hours, visit assumptions, control codes and evidenced person-site schedules. Fields or sheets: Results; Sites; People; Fictional Example; Review Actions; Use and Limits. Key terms: Trade area: The explicitly defined area and population being studied. Provider days: Observed clinician availability over a stated period, distinct from a directory listing. Evidence gap: An unresolved claim requiring a dated source or observation. Steps: 1. Read Results and Use and Limits; review the separate Fictional Example. 2. Enter coded site records in Sites rows 7–106 and linked person-site records in People rows 7–106. Use matching site codes, dated evidence and consistent weekly periods. 3. Complete every entered row, including its identifiers. Partially entered sites count as records and keep whole-input capacity totals unavailable until corrected; do not treat an omitted code as an excluded site. 4. Review duplicate person-site records and the Total days exceed 7 warning. This checks aggregate reported days, not actual weekday or time overlap; inspect the underlying schedules separately. 5. Enter 0 only for a known zero. Review physical capacity, evidenced staffing and unresolved records separately; these figures do not estimate demand or rank locations. 6. Review unavailable or adverse results and supporting evidence; assign the missing record, reviewer, due date and next action in Review Actions. Fictional example: Fictional example: Three chairs open 40 hours with 60-minute visits and an 80% usable-time assumption yield 96 physical visits per week. One verified 24-hour provider limits staffed capacity to 19.2. Limits: Formulas are editable and sheet protection is not enabled. Use only the prepared rows and keep a clean copy. Recalculation and XLSX reimport were checked with Artifact Tool; Excel desktop/web, Google Sheets and native printing have not been interactively tested. These are aggregate planning tools, not professional verification. Next action: Review each unavailable or adverse result, then assign the missing record, reviewer, due date and next action in Review Actions. ## AI review Review my permitted fictional or aggregate, non-identifying draft against the DenQAI file context below. Check the actual fields, units, periods, evidence and unresolved contradictions. Use arithmetic only where the stated model supports it; a CSV has no embedded formulas. Keep missing values unknown and separate facts, assumptions and the fictional example. Return specific corrections, questions for the responsible reviewer and the next action; do not invent professional approval. File: Local market evidence and capacity workbook (XLSX). Question: Linked market records, evidence gaps and conditional weekly capacity — what do the entered records support? Records to gather: Coded sites, usable chairs, hours, visit assumptions, control codes and evidenced person-site schedules. Fields or sheets: Results; Sites; People; Fictional Example; Review Actions; Use and Limits. Key terms: Trade area: The explicitly defined area and population being studied. Provider days: Observed clinician availability over a stated period, distinct from a directory listing. Evidence gap: An unresolved claim requiring a dated source or observation. Steps: 1. Read Results and Use and Limits; review the separate Fictional Example. 2. Enter coded site records in Sites rows 7–106 and linked person-site records in People rows 7–106. Use matching site codes, dated evidence and consistent weekly periods. 3. Complete every entered row, including its identifiers. Partially entered sites count as records and keep whole-input capacity totals unavailable until corrected; do not treat an omitted code as an excluded site. 4. Review duplicate person-site records and the Total days exceed 7 warning. This checks aggregate reported days, not actual weekday or time overlap; inspect the underlying schedules separately. 5. Enter 0 only for a known zero. Review physical capacity, evidenced staffing and unresolved records separately; these figures do not estimate demand or rank locations. 6. Review unavailable or adverse results and supporting evidence; assign the missing record, reviewer, due date and next action in Review Actions. Fictional example: Fictional example: Three chairs open 40 hours with 60-minute visits and an 80% usable-time assumption yield 96 physical visits per week. One verified 24-hour provider limits staffed capacity to 19.2. Limits: Formulas are editable and sheet protection is not enabled. Use only the prepared rows and keep a clean copy. Recalculation and XLSX reimport were checked with Artifact Tool; Excel desktop/web, Google Sheets and native printing have not been interactively tested. These are aggregate planning tools, not professional verification. Next action: Review each unavailable or adverse result, then assign the missing record, reviewer, due date and next action in Review Actions. ## Related guide [Open the related guide](https://denqai.com/market/local)