Drawing to BOQpipeline control sheet
← Mindmapwhat the drawings said

Bridge Excavation

1 page · 1 crop · earthwork

Matched toFoundation Excavationbridge.approach_earthwork_system.excavationon “Bridge Excavation”

0 of 5 required measurements have a number

The model provider refused the call: the account is out of credit. Top up the OpenRouter key, or lower OPENAI_MAX_TOKENS.

The class asks forUnitA reading with that nameFrom
LengthLm/mmno reading by that name
WidthWm/mmno reading by that name
Excavation DepthD_excm/mmno reading by that name
Working SpaceWSm/mmno reading by that name
Instance CountNcountno reading by that name

Paired on the measurement’s name only, which cannot know that three span lengths sum to the deck length. Step 3 works these out properly for every item it matches — reading every crop behind the item, deriving what the drawings imply and showing its arithmetic. This item has not had that pass yet; the button runs it for this one.

How the sheets named it

211-0200

Every dimension read for it2

  • 295 CYBRIDGE EXCAVATION - LEFT BRIDGEp2 · p02_r05
  • 295 CYBRIDGE EXCAVATION - RIGHT BRIDGEp2 · p02_r05

Notes on the sheets that carry it

  • p2LOAD TEST, STEEL H, HP 12 X 53 (IF REQD)

Every crop it was read in — the drawing beside what the model took off it

Page 2

crop

p02_r05

page 2 · other_p02_r05
Original
p02_r05
{
  "view": "Table",
  "objects": [
    {
      "name": "Foundation backfill material",
      "tag": "207-0203",
      "shape": "",
      "material": "granular/backfill",
      "count": null,
      "note": "Type II"
    },
    {
      "name": "Bridge excavation",
      "tag": "211-0200",
      "shape": "",
      "material": "earth/soil",
      "count": null,
      "note": "Grade separation"
    },
    {
      "name": "Grooved concrete surface",
      "tag": "500-0100",
      "shape": "",
      "material": "concrete",
      "count": null,
      "note": ""
    },
    {
      "name": "Superstructure concrete",
      "tag": "500-1011",
      "shape": "",
      "material": "concrete, Class D",
      "count": null,
      "note": "Br No-1 LT and RT, lump sum items, reference (249)"
    },
    {
      "name": "Concrete barrier",
      "tag": "500-2100",
      "shape": "",
      "material": "concrete",
      "count": null,
      "note": ""
    },
    {
      "name": "Class AA concrete",
      "tag": "500-3002",
      "shape": "",
      "material": "concrete",
      "count": null,
      "note": ""
    },
    {
      "name": "PSC beam",
      "tag": "507-9002",
      "shape": "AASHTO Type II",
      "material": "precast concrete",
      "count": null,
      "note": "Br No-1"
    },
    {
      "name": "PSC beam",
      "tag": "507-9003",
      "shape": "AASHTO Type III",
      "material": "precast concrete",
      "count": null,
      "note": "Br No-1"
    },
    {
      "name": "Bar reinforcement steel",
      "tag": "511-1000",
      "shape": "",
      "material": "steel",
      "count": null,
      "note": ""
    },
    {
      "name": "Superstructure reinforcement steel",
      "tag": "511-3000",
      "shape": "",
      "material": "steel",
      "count": null,
      "note": "Br No-1 LT and RT, lump sum items, reference (69762)"
    },
    {
      "name": "Steel H pile",
      "tag": "520-1125",
      "shape": "H-section",
      "material": "structural steel",
      "count": null,
      "note": "HP 12 X 53, in place piling"
    },
    {
      "name": "Load test pile",
      "tag": "520-4125",
      "shape": "H-section",
      "material": "structural steel",
      "count": null,
      "note": "HP 12 X 53, if required"
    },
    {
      "name": "Dynamic pile test",
      "tag": "523-1100",
      "shape": "",
      "material": "",
      "count": null,
      "note": ""
    },
    {
      "name": "Chain link fence",
      "tag": "643-1152",
      "shape": "",
      "material": "steel, zinc coated",
      "count": null,
      "note": "6 FT height, 9 GA"
    }
  ],
  "measurements": [
    {
      "label": "FOUND BKFILL MATL TP II - LEFT BRIDGE",
      "value": "35",
      "unit": "CY",
      "appliesTo": "207-0203"
    },
    {
      "label": "FOUND BKFILL MATL TP II - RIGHT BRIDGE",
      "value": "35",
      "unit": "CY",
      "appliesTo": "207-0203"
    },
    {
      "label": "BRIDGE EXCAVATION - LEFT BRIDGE",
      "value": "295",
      "unit": "CY",
      "appliesTo": "211-0200"
    },
    {
      "label": "BRIDGE EXCAVATION - RIGHT BRIDGE",
      "value": "295",
      "unit": "CY",
      "appliesTo": "211-0200"
    },
    {
      "label": "GROOVED CONCRETE - LEFT BRIDGE",
      "value": "811",
      "unit": "SY",
      "appliesTo": "500-0100"
    },
    {
      "label": "GROOVED CONCRETE - RIGHT BRIDGE",
      "value": "811",
      "unit": "SY",
      "appliesTo": "500-0100"
    },
    {
      "label": "SUPERSTR CONCRETE CL D BR NO-1 LT - LEFT BRIDGE",
      "value": "LUMP",
      "unit": "LS",
      "appliesTo": "500-1011"
    },
    {
      "label": "SUPERSTR CONCRETE CL D BR NO-1 LT reference",
      "value": "249",
      "unit": "",
      "appliesTo": "500-1011"
    },
    {
      "label": "SUPERSTR CONCRETE CL D BR NO-1 RT - RIGHT BRIDGE",
      "value": "LUMP",
      "unit": "LS",
      "appliesTo": "500-1011"
    },
    {
      "label": "SUPERSTR CONCRETE CL D BR NO-1 RT reference",
      "value": "249",
      "unit": "",
      "appliesTo": "500-1011"
    },
    {
      "label": "CONCRETE BARRIER - LEFT BRIDGE",
      "value": "378",
      "unit": "LF",
      "appliesTo": "500-2100"
    },
    {
      "label": "CONCRETE BARRIER - RIGHT BRIDGE",
      "value": "378",
      "unit": "LF",
      "appliesTo": "500-2100"
    },
    {
      "label": "CLASS AA CONCRETE - LEFT BRIDGE",
      "value": "221",
      "unit": "CY",
      "appliesTo": "500-3002"
    },
    {
      "label": "CLASS AA CONCRETE - RIGHT BRIDGE",
      "value": "221",
      "unit": "CY",
      "appliesTo": "500-3002"
    },
    {
      "label": "PSC BEAMS AASHTO TYPE II BR NO-1 - LEFT BRIDGE",
      "value": "644",
      "unit": "LF",
      "appliesTo": "507-9002"
    },
    {
      "label": "PSC BEAMS AASHTO TYPE II BR NO-1 - RIGHT BRIDGE",
      "value": "644",
      "unit": "LF",
      "appliesTo": "507-9002"
    },
    {
      "label": "PSC BEAMS AASHTO TYPE III BR NO-1 - LEFT BRIDGE",
      "value": "486",
      "unit": "LF",
      "appliesTo": "507-9003"
    },
    {
      "label": "PSC BEAMS AASHTO TYPE III BR NO-1 - RIGHT BRIDGE",
      "value": "486",
      "unit": "LF",
      "appliesTo": "507-9003"
    },
    {
      "label": "BAR REINF STEEL - LEFT BRIDGE",
      "value": "35422",
      "unit": "LB",
      "appliesTo": "511-1000"
    },
    {
      "label": "BAR REINF STEEL - RIGHT BRIDGE",
      "value": "35397",
      "unit": "LB",
      "appliesTo": "511-1000"
    },
    {
      "label": "SUPERSTR REINF STEEL BR NO-1 LT - LEFT BRIDGE",
      "value": "LUMP",
      "unit": "LS",
      "appliesTo": "511-3000"
    },
    {
      "label": "SUPERSTR REINF STEEL BR NO-1 LT reference",
      "value": "69762",
      "unit": "",
      "appliesTo": "511-3000"
    },
    {
      "label": "SUPERSTR REINF STEEL BR NO-1 RT - RIGHT BRIDGE",
      "value": "LUMP",
      "unit": "LS",
      "appliesTo": "511-3000"
    },
    {
      "label": "SUPERSTR REINF STEEL BR NO-1 RT reference",
      "value": "69762",
      "unit": "",
      "appliesTo": "511-3000"
    },
    {
      "label": "PILING IN PLACE STEEL H HP 12X53 - LEFT BRIDGE",
      "value": "2720",
      "unit": "LF",
      "appliesTo": "520-1125"
    },
    {
      "label": "PILING IN PLACE STEEL H HP 12X53 - RIGHT BRIDGE",
      "value": "2540",
      "unit": "LF",
      "appliesTo": "520-1125"
    },
    {
      "label": "Pile size callout",
      "value": "12 X 53",
      "unit": "",
      "appliesTo": "520-1125"
    },
    {
      "label": "LOAD TEST STEEL H HP 12X53 - LEFT BRIDGE",
      "value": "1",
      "unit": "EA",
      "appliesTo": "520-4125"
    },
    {
      "label": "LOAD TEST STEEL H HP 12X53 - RIGHT BRIDGE",
      "value": "1",
      "unit": "EA",
      "appliesTo": "520-4125"
    },
    {
      "label": "DYNAMIC PILE TEST - LEFT BRIDGE",
      "value": "2",
      "unit": "EA",
      "appliesTo": "523-1100"
    },
    {
      "label": "DYNAMIC PILE TEST - RIGHT BRIDGE",
      "value": "2",
      "unit": "EA",
      "appliesTo": "523-1100"
    },
    {
      "label": "CH LK FENCE ZC COAT 6FT 9GA - LEFT BRIDGE",
      "value": "378",
      "unit": "LF",
      "appliesTo": "643-1152"
    },
    {
      "label": "CH LK FENCE ZC COAT 6FT 9GA - RIGHT BRIDGE",
      "value": "378",
      "unit": "LF",
      "appliesTo": "643-1152"
    }
  ],
  "notes": [
    "LOAD TEST, STEEL H, HP 12 X 53 (IF REQD)"
  ],
  "labels": [
    "SUMMARY OF QUANTITIES",
    "PAY ITEM NUMBER",
    "LEFT BRIDGE",
    "RIGHT BRIDGE",
    "UNIT",
    "PAY ITEM",
    "12 X 53"
  ],
  "description": "This crop is a Summary of Quantities schedule table listing pay item numbers, quantities for a Left Bridge and Right Bridge, units, and pay item descriptions for a bridge project (Bridge No.-1). Items include earthwork, various concrete classes and superstructure concrete/reinforcement (some lump sum with cross-references to items 249 and 69762), PSC beams (AASHTO Type II and III), steel H-piling (HP 12x53) with an associated pile size callout, load and dynamic pile testing, concrete barrier, and chain link fencing. All quantity values that appear highlighted in yellow are printed numeric quantities; the table documents overall bridge quantities for bill-of-quantities preparation."
}

p02_r05Table

  • Bridge excavation211-0200earth/soilGrade separation

35 CY FOUND BKFILL MATL TP II - LEFT BRIDGE35 CY FOUND BKFILL MATL TP II - RIGHT BRIDGE295 CY BRIDGE EXCAVATION - LEFT BRIDGE295 CY BRIDGE EXCAVATION - RIGHT BRIDGE811 SY GROOVED CONCRETE - LEFT BRIDGE811 SY GROOVED CONCRETE - RIGHT BRIDGELUMP LS SUPERSTR CONCRETE CL D BR NO-1 LT - LEFT BRIDGE249 SUPERSTR CONCRETE CL D BR NO-1 LT reference+25 more