md_dlg.dcl — Material Database Configuration¶

File: md_dlg.dcl
Version: v3.60
Category: Dialog Definitions
Size: 5.7 KB (172 lines)

Note

Material Library Management

Manage material database including concrete mixes, rebar grades, steel plates, and hardware with properties, costs, and supplier information.

Functional Purpose¶

Material Database - Centralized library of all materials used in precast panels with specifications, costs, availability, and supplier data.

Key Functions:

Material library (concrete, rebar, embeds, hardware)
Properties database (strength, weight, dimensions)
Cost tracking (unit costs, pricing updates)
Supplier information (vendors, lead times, contacts)
Material takeoffs (automatic quantity calculations)
Substitution management (approved alternates)

Typical Workflow¶

1. User opens md_dlg (Configuration ? Materials)
2. Material library displayed:
   • Concrete mixes (5 standard mixes)
   • Rebar (Grade 60, sizes #3-#8)
   • Weld plates (various sizes)
   • Inserts (lifting, anchors)
   • Hardware (bolts, angles, etc.)
3. User adds new material:
   • Name: "6000 PSI High-Strength Mix"
   • Properties: f'c = 6000 PSI, 150 PCF
   • Cost: $145/CY
   • Supplier: ABC Concrete, (555) 123-4567
   • Lead time: Standard (no delay)
4. User sets as available for project
5. Material now selectable in panel configurations

Control Semantics¶

Material Categories:

md_category - Material type:
- Concrete mixes
- Reinforcing steel
- Structural steel (plates, angles)
- Inserts and embeds
- Hardware (bolts, anchors)
- Accessories (sealants, gaskets)

Material Properties:

md_name - Material name/description
md_spec - Specification (ASTM, ACI, etc.)
md_properties - Technical properties:
- Strength (PSI, ksi)
- Weight (PCF, lb/ft)
- Dimensions (size, thickness)

Cost Data:

md_cost - Unit cost:
- Concrete: $/CY
- Rebar: $/lb or $/ton
- Plates: $/lb or $/each
- Hardware: $/each
md_cost_date - Price date (for tracking)
md_waste - Waste factor (%): 5-10% typical

Supplier Information:

md_supplier - Vendor name
md_contact - Contact person, phone
md_lead - Lead time (days)
md_moq - Minimum order quantity

Material Library Examples¶

Concrete Mixes¶

Mix ID: CM-5000
Name: 5000 PSI Normal Weight
Properties:
  - f'c: 5000 PSI @ 28 days
  - Unit weight: 145 PCF
  - Slump: 4-6"
  - Air: 6% (freeze-thaw)
Cost: $135/CY
Supplier: XYZ Ready Mix
Lead time: Same day (batched on demand)
Notes: Standard architectural mix

Reinforcing Steel¶

Material: Rebar #5
Spec: ASTM A615 Grade 60
Properties:
  - Diameter: 0.625"
  - Area: 0.31 sq in
  - fy: 60,000 PSI
  - Weight: 1.043 lb/ft
Cost: $0.65/lb = $1,300/ton
Supplier: Steel Supplier Inc.
Lead time: 2 weeks (mill order)
Sizes available: #3-#11

Embed Plates¶

Item: Weld Plate 6×6×1/2
Spec: ASTM A36 steel
Properties:
  - Size: 6" × 6"
  - Thickness: 1/2"
  - Weight: 7.65 lbs each
  - Holes: (4) 7/8" diameter
Cost: $15.00 each
Supplier: Metal Fabricators LLC
Lead time: 1 week (fabricated to order)
Qty on hand: 200 pieces

Material Takeoff Integration¶

Automatic Quantities:

User designs 20 panels
System calculates materials needed:

Concrete:
  20 panels × 45 CF/panel = 900 CF
  900 CF / 27 = 33.3 CY
  + 5% waste = 35 CY
  Cost: 35 × $135 = $4,725

Rebar #5:
  20 panels × 240 LF/panel = 4,800 LF
  4,800 × 1.043 lb/ft = 5,006 lbs
  + 10% waste = 5,507 lbs = 2.75 tons
  Cost: 2.75 × $1,300 = $3,575

Weld Plates 6×6:
  20 panels × 4 plates/panel = 80 plates
  + 5% waste = 84 plates
  Cost: 84 × $15 = $1,260

Total Material Cost: $9,560

Supplier Management¶

Vendor Database:

Multiple suppliers per material (competition, backup)
Lead time tracking (schedule critical path)
Price history (cost trending)
Performance notes (quality issues, delivery problems)

Approved Substitutions:

Primary: 5000 PSI Mix from XYZ Ready Mix
Alternate 1: 5000 PSI from ABC Concrete (+$5/CY)
Alternate 2: 5500 PSI from DEF Supply (-3 day cure time)

Substitution rules:
- Must meet strength requirements
- Must have equivalent durability
- Engineer approval required

Integration¶

Used By:

Panel configuration (material selection)
Cost estimating (automatic pricing)
Purchasing (purchase orders)
Scheduling (lead time planning)

Updates:

Price updates (quarterly or as needed)
Availability changes (supplier changes)
Specification revisions (code updates)

Best Practices¶

Material Library:

? Keep updated (prices, specifications)
? Include local suppliers (reduce lead time)
? Track price history (identify trends)
? Document approved substitutions

Cost Tracking:

? Include waste factors (realistic estimates)
? Update prices regularly (quarterly minimum)
? Separate material and labor costs
? Track escalation (price increases over time)

Supplier Management:

? Maintain multiple sources (backup supply)
? Track performance (quality, delivery)
? Negotiate volume discounts
? Document lead times accurately

Documentation Metadata¶

Enhancement Status: ? COMPREHENSIVE - ENHANCED [15/23 v3.60 remaining]

End of Document