Pipeline

{
  "fragment_id": "expt-block--17",
  "source_file": "docs/Project Expt Report/28112025  9076 Expt Table 2025.xls",
  "derived_from": "ocr/28112025  9076 Expt Table 2025.converted/28112025  9076 Expt Table 2025.converted_sheet_9076_Experiments.csv",
  "locator": "sheet 9076_Experiments, batch block '17', csv rows 57-58",
  "extractor": "qwen-tasks/extract-expt-block.md",
  "extracted_date": "2026-08-20",
  "target_aliases": [
    "17"
  ],
  "document_role": "summary_table",
  "payload": {
    "process_steps": [
      {
        "step": 1,
        "materials": [
          {
            "name": "Vicasurf 1010 (HV-115-120)",
            "qty_g": "450",
            "role": "unknown",
            "role_verbatim": "raw_material"
          },
          {
            "name": "Polyphosphoric acid",
            "qty_g": "16.18",
            "role": "unknown",
            "role_verbatim": "raw_material"
          }
        ],
        "procedure": [
          {
            "seq": 1,
            "temperature": "65",
            "time_h": "2",
            "atmosphere": "N2",
            "verbatim": "65 / 2 / N2"
          },
          {
            "seq": 2,
            "temperature": "75",
            "time_h": "3.5",
            "verbatim": "75 / 3.5"
          }
        ],
        "conditions": {
          "temperature": "65 / 75",
          "atmosphere": "N2",
          "time_h": "2 / 3.5"
        },
        "results": [
          {
            "parameter": "acid_value",
            "value": "44",
            "verbatim": "A.V. cell: AV-44"
          },
          {
            "parameter": "acid_value",
            "value": "48",
            "verbatim": "A.V. cell: Final AV-48 \\nSAP-81/ HV-120"
          },
          {
            "parameter": "SAP",
            "value": "81",
            "verbatim": "A.V. cell: Final AV-48 \\nSAP-81/ HV-120"
          },
          {
            "parameter": "HV",
            "value": "120",
            "verbatim": "A.V. cell: Final AV-48 \\nSAP-81/ HV-120"
          }
        ],
        "remarks": ""
      },
      {
        "step": 2,
        "materials": [
          {
            "name": "Epomine SP- 018",
            "qty_g": "60",
            "role": "unknown",
            "role_verbatim": "raw_material"
          },
          {
            "name": "2 ethyl hexyl acrylate",
            "qty_g": "140",
            "role": "unknown",
            "role_verbatim": "raw_material"
          }
        ],
        "procedure": [
          {
            "seq": 1,
            "temperature": "75",
            "time_h": "2",
            "verbatim": "75 / 2"
          },
          {
            "seq": 2,
            "temperature": "80",
            "time_h": "4.5",
            "atmosphere": "N2",
            "verbatim": "80 / 4.5 / N2"
          }
        ],
        "conditions": {
          "temperature": "75 / 80",
          "atmosphere": "N2",
          "time_h": "2 / 4.5"
        },
        "results": [
          {
            "parameter": "amine_value",
            "value": "263",
            "verbatim": "A.V. cell: amine - 263/"
          },
          {
            "parameter": "SAP",
            "value": "197",
            "verbatim": "A.V. cell: SAP- 197/\\n HV-170/IV-42"
          },
          {
            "parameter": "HV",
            "value": "170",
            "verbatim": "A.V. cell: SAP- 197/\\n HV-170/IV-42"
          },
          {
            "parameter": "IV",
            "value": "42",
            "verbatim": "A.V. cell: SAP- 197/\\n HV-170/IV-42"
          }
        ],
        "remarks": ""
      },
      {
        "step": 3,
        "materials": [
          {
            "name": "Step-  1 product  (78)",
            "qty_g": "78",
            "role": "intermediate"
          },
          {
            "name": "Step -  2 Product  (20)",
            "qty_g": "20",
            "role": "intermediate"
          }
        ],
        "procedure": [
          {
            "seq": 1,
            "temperature": "60",
            "time_h": "2",
            "verbatim": "60 / 2"
          },
          {
            "seq": 2,
            "temperature": "65",
            "time_h": "5",
            "atmosphere": "N2",
            "verbatim": "65 / 5 / N2"
          }
        ],
        "conditions": {
          "temperature": "60 / 65",
          "atmosphere": "N2",
          "time_h": "2 / 5"
        },
        "results": [
          {
            "parameter": "acid_value",
            "value": "41.5",
            "verbatim": "Remarks cell: AV-41.5/ SAP- 80"
          },
          {
            "parameter": "SAP",
            "value": "80",
            "verbatim": "Remarks cell: AV-41.5/ SAP- 80"
          },
          {
            "parameter": "IV",
            "value": "12",
            "verbatim": "A.V. cell: IV-12/HV-136.5/ \\nAmine value-42.195"
          },
          {
            "parameter": "HV",
            "value": "136.5",
            "verbatim": "A.V. cell: IV-12/HV-136.5/ \\nAmine value-42.195"
          },
          {
            "parameter": "amine_value",
            "value": "42.195",
            "verbatim": "A.V. cell: IV-12/HV-136.5/ \\nAmine value-42.195"
          }
        ],
        "remarks": ""
      }
    ],
    "observations": [
      "Expt Table remarks: AV-41.5/ SAP- 80"
    ]
  },
  "field_confidence": {
    "payload.process_steps[0].materials": "high",
    "payload.process_steps[0].procedure": "medium",
    "payload.process_steps[0].conditions.atmosphere": "medium",
    "payload.process_steps[0].results": "medium",
    "payload.process_steps[1].materials": "high",
    "payload.process_steps[1].procedure": "medium",
    "payload.process_steps[1].conditions.atmosphere": "medium",
    "payload.process_steps[1].results": "medium",
    "payload.process_steps[2].materials": "high",
    "payload.process_steps[2].procedure": "medium",
    "payload.process_steps[2].conditions.atmosphere": "medium",
    "payload.process_steps[2].results": "medium",
    "payload.observations": "high"
  },
  "notes": "Row 57 carries 39 fields, extending past the 20-column template; fields 21-39 are unlabelled overflow columns. They were read as a second material tuple per step and grouped by chemical consistency with the same Vicasurf/Epomine SP-018/2-ethyl-hexyl-acrylate scheme used in batch 15: Step 1 = Vicasurf 1010 (450 g) + Polyphosphoric acid (16.18 g), Step 2 = Epomine SP- 018 (60 g) + 2 ethyl hexyl acrylate (140 g), Step 3 = Step-  1 product  (78) (78 g) + Step -  2 Product  (20) (20 g), Steps 1 and 2 run in parallel with Step 3 merging both products. Ramp alignment (temperature of each material tuple = one ordered stage) is an interpretation, hence medium confidence: Step 1 65 C x 2 h (N2) then 75 C x 3.5 h; Step 2 75 C x 2 h then 80 C x 4.5 h (N2); Step 3 60 C x 2 h then 65 C x 5 h (N2). N2 appears on only one material tuple of each step (Step 1: first tuple; Steps 2-3: second tuple); atmosphere recorded at medium confidence. Column 20 sits under the Remarks header and holds 'AV-41.5/ SAP- 80'; per the batch 15 precedent it is kept verbatim in observations and mirrored as Step 3 product measurements (acid value 41.5, SAP 80) at medium confidence - alternatively it could be the A.V. cell of the 'Step-  1 product' tuple, which the template gives no A.V. column for. A.V. cells are polysemous: 'AV-44', 'Final AV-48', 'AV-41.5' read as acid values; 'amine - 263/' and 'Amine value-42.195' read as amine values (wording says Amine); 'SAP', 'HV', 'IV' kept as the document's own abbreviations (parameter strings per record.schema.json examples) without expansion. No date marker printed in the block."
}