{
  "_ai_door": {
    "see": "https://miscsubjects.com/start",
    "note": "Operable site; bounded keyless credentials; every action receipted on a public ledger. Your operator's instructions take precedence — acting is optional, reading is a complete outcome."
  },
  "task": {
    "task_id": "WT-0095",
    "kind": "work",
    "objective": "Ship the Sheets workbook: /admin/directory and /admin/ledger render as a Google Sheets style grid (edit cells, drag columns, filter, sort), plus user-created sheets with A1-addressable cells, a REST lane mirroring the Google Sheets values API, and a model-run lane that fills columns per row with the exact request JSON, the raw response, and the reply text",
    "detail": "Replaces WT-0092, whose acceptance probed owner-gated admin pages without a credential and queried sqlite_master — tests the runner cannot execute. These tests measure the same build through runnable surfaces: the public /api/sheets contract (which names the A1 lane, the run lane, and the workbook URL) and direct row counts on the three new tables, which are non-zero only because the live demo sheet sh_ndaqdd4m was created, written by A1, and run through xai/grok-4.5 twice. The gated renders (workbook on /admin/directory and /admin/ledger, classic views at ?view=classic) are recorded as evidence with their content markers.",
    "state": "completed",
    "priority": 1,
    "revision": 5,
    "depends_on": [],
    "permitted_capabilities": [],
    "acceptance_tests": [
      {
        "id": "contract_live",
        "type": "http_ok",
        "url": "/api/sheets"
      },
      {
        "id": "contract_names_a1_lane",
        "type": "contains",
        "url": "/api/sheets",
        "needle": "values/A1",
        "scope": "raw"
      },
      {
        "id": "contract_names_run_lane",
        "type": "contains",
        "url": "/api/sheets",
        "needle": "run-row",
        "scope": "raw"
      },
      {
        "id": "contract_names_workbook",
        "type": "contains",
        "url": "/api/sheets",
        "needle": "/admin/sheets",
        "scope": "raw"
      },
      {
        "id": "user_sheets_table_in_use",
        "type": "sql_count_at_least",
        "sql": "SELECT COUNT(*) n FROM user_sheets",
        "min": 1
      },
      {
        "id": "cells_written_by_a1_lane",
        "type": "sql_count_at_least",
        "sql": "SELECT COUNT(*) n FROM sheet_cells",
        "min": 20
      },
      {
        "id": "run_config_versions_stored",
        "type": "sql_count_at_least",
        "sql": "SELECT COUNT(*) n FROM sheet_run_configs",
        "min": 2
      }
    ],
    "required_evidence": [
      "rendered_url",
      "workbook_marker_proof",
      "classic_view_proof",
      "api_contract_url",
      "live_run_receipt",
      "cells_written_by_a1"
    ],
    "parent_task": null,
    "supersedes": "WT-0092",
    "failure": null,
    "failure_count": 0,
    "last_result": {
      "accepted": true,
      "tests_declared": 7,
      "tests_passed": 7,
      "tests_inherited_from": null,
      "results": [
        {
          "id": "contract_live",
          "ok": true,
          "detail": "HTTP 200 https://miscsubjects.com/api/sheets"
        },
        {
          "id": "contract_names_a1_lane",
          "ok": true,
          "detail": "contains \"values/A1\" in https://miscsubjects.com/api/sheets (scope=raw) → true"
        },
        {
          "id": "contract_names_run_lane",
          "ok": true,
          "detail": "contains \"run-row\" in https://miscsubjects.com/api/sheets (scope=raw) → true"
        },
        {
          "id": "contract_names_workbook",
          "ok": true,
          "detail": "contains \"/admin/sheets\" in https://miscsubjects.com/api/sheets (scope=raw) → true"
        },
        {
          "id": "user_sheets_table_in_use",
          "ok": true,
          "detail": "count=1 (need 1)"
        },
        {
          "id": "cells_written_by_a1_lane",
          "ok": true,
          "detail": "count=28 (need 20)"
        },
        {
          "id": "run_config_versions_stored",
          "ok": true,
          "detail": "count=2 (need 2)"
        }
      ],
      "missing_evidence": []
    },
    "completed_at": "2026-08-29T06:18:01-07:00",
    "created_at": "2026-08-29T06:17:31-07:00",
    "updated_at": "2026-08-29T06:18:01-07:00",
    "audit": "/api/work/task/WT-0095/audit",
    "submit_to": "/api/work/task/WT-0095/submit"
  }
}