Pipeline

{
  "fragment_id": "expt-block--42",
  "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 '42', csv rows 161-166",
  "extractor": "qwen-tasks/extract-expt-block.md",
  "extracted_date": "2026-08-20",
  "target_aliases": [
    "42"
  ],
  "document_role": "summary_table",
  "payload": {
    "date": "05.06.25",
    "process_steps": [
      {
        "step": 1,
        "materials": [
          {
            "name": "i) Esteem BEP 1450 ( HV-40 LOD-3.1 %) Lot-2505013A",
            "role": "unknown",
            "quantity_g": 200,
            "verbatim": "i) Esteem BEP 1450 ( HV-40 LOD-3.1 %) Lot-2505013A",
            "role_verbatim": "raw_material"
          },
          {
            "name": "R-2433",
            "role": "unknown",
            "verbatim": "R-2433",
            "role_verbatim": "raw_material"
          },
          {
            "name": "Epomine SP- 018",
            "role": "unknown",
            "quantity_g": 72.8,
            "verbatim": " Epomine SP- 018",
            "role_verbatim": "raw_material"
          }
        ],
        "procedure": [
          {
            "seq": 1,
            "time_h": 0.2,
            "verbatim": "40",
            "temperature": 40
          },
          {
            "seq": 2,
            "time_h": 3,
            "verbatim": "74-75",
            "temperature": "74-75"
          },
          {
            "seq": 3,
            "time_h": 3,
            "verbatim": "55",
            "temperature": 55
          }
        ],
        "conditions": {
          "temperature": "40, then 74-75, then 55 oC (ramp)",
          "time_h": "0.2 h, then 3 h, then 3 h"
        },
        "results": [
          {
            "parameter": "acid_value",
            "value": 27.5,
            "verbatim": "27.5",
            "note": "positionally aligned with the 5.5 h time entry (55 oC, 3 h ramp stage); cell layout ambiguous"
          },
          {
            "parameter": "composition",
            "value": "Mono-15.5/ Di-72/Free A-0.53",
            "verbatim": "Mono-15.5/ Di-72/Free A-0.53",
            "note": "step-1 product composition, printed in the Remarks column area"
          }
        ]
      },
      {
        "step": 2,
        "materials": [],
        "procedure": [
          {
            "seq": 1,
            "time_h": 2,
            "verbatim": "74-81",
            "temperature": "74-81"
          }
        ],
        "conditions": {
          "temperature": "74-81 oC",
          "time_h": "2 h"
        },
        "results": [
          {
            "parameter": "acid_value",
            "value": 36.85,
            "verbatim": "AV-36.85"
          },
          {
            "parameter": "iodine_value",
            "verbatim": "Iodine value",
            "note": "label only; the measured value is not present in this block"
          }
        ]
      },
      {
        "step": 3,
        "materials": [
          {
            "name": "Feed",
            "role": "unknown",
            "verbatim": "Feed"
          },
          {
            "name": "Step - 1 Product",
            "role": "intermediate",
            "verbatim": "Step - 1 Product"
          },
          {
            "name": "Phosphate",
            "role": "unknown",
            "quantity_g": 0.85,
            "verbatim": "Phosphate",
            "role_verbatim": "raw_material"
          }
        ],
        "procedure": [
          {
            "seq": 1,
            "action": "0.5 hr feed of phosphate ester",
            "verbatim": "0.5 hr feed of phosphate ester",
            "temperature": "55-60"
          },
          {
            "seq": 2,
            "time_h": 2.5,
            "action": "stirred well",
            "verbatim": "2.5 hr stirred well",
            "temperature": "55-60"
          }
        ],
        "conditions": {
          "temperature": "55-60 oC",
          "time_h": "0.5 h phosphate ester feed + 2.5 h stirring"
        },
        "results": [],
        "remarks": "turbidity found; Non uniform mass"
      }
    ],
    "observations": [
      "Expt Table remarks: Mono-15.5/ Di-72/Free A-0.53",
      "Expt Table remarks: Iodine value (label only, no value)",
      "Expt Table remarks: 0.5 hr feed of phosphate ester",
      "Expt Table remarks: 2.5 hr stirred well turbidity found",
      "Expt Table remarks: Non uniform mass"
    ]
  },
  "field_confidence": {
    "payload.date": "medium",
    "payload.process_steps[0].materials": "high",
    "payload.process_steps[0].procedure": "medium",
    "payload.process_steps[0].results[0]": "low",
    "payload.process_steps[0].results[1]": "medium",
    "payload.process_steps[1]": "medium",
    "payload.process_steps[2]": "medium"
  },
  "notes": "Step 1 material cells are a comma-separated run (no Qty for R-2433 or Epomine SP- 018); Epomine SP- 018 qty 72.8 was taken from the Step 2 Name column position — likely a misaligned/merged cell, flag for ELN cross-check. Step 1 A.V. 27.5 sits positionally opposite a 5.5 h time entry that does not align with the 0.2/3/3 ramp, so its assignment is low confidence. Step 1 temps/times are read as a positional ramp (40/0.2, 74-75/3, 55/3). Step 2 has no raw-material cells. Step 3 'Feed' is an unlabelled entry. Remarks-column notes (composition, iodine-value label, feed/stir text, turbidity, non uniform mass) are duplicated into observations and step remarks verbatim."
}