REO Count Calculator

Analyze construction sets data and count reinforcement elements (including shear) with advanced filtering and export capabilities.

Data Input

Reinforcement Type

Excel Data Upload & Processing

No Excel file chosen

Excel Data Processing:

  • Column B Input: Reads from row 19, outputs to K(Qty), C(Bar Size), E(Length), F(1st COG), G(2nd COG)
  • Column P Input: Reads from row 19, outputs to Y(Qty), Q(Bar Size), S(Length), T(1st COG), U(2nd COG)
  • Parses entries like: 6n12 9000, 17N12 1200c, 12n12 1800c 1200c
  • COG Logic: 'c'/'C' = 1st COG (F/T), 'cs'/'CS'/'c2'/'C2' = 2nd COG (G/U)
  • Examples: 1800c/1800C (1st COG), 1800cs/1800CS/1800c2/1800C2 (2nd COG)
  • COG mapping: N12=170, N16=200, N20=245, N24=295, N28=340, N32=390

Text Data File Upload

No file chosen

Excel Template

No template chosen

Template Format:

  • Top/Bottom Reo: Data starts at row 18
  • Column A: Full specification
  • Column C: Bar size (e.g., 24)
  • Column E: Length (e.g., 2500 or VAR)
  • Column F: COG length (auto-filled based on bar size)
  • Column I: Spacing (e.g., 200)
  • Column K: Quantity (e.g., 21)
  • Shear Reinforcement:
  • Column AC: Full specification
  • Column AD: Tie type (2=2 legs, B=3 legs, etc.)
  • Column AE: Bar size (e.g., 20)
  • Column AF: Spacing (e.g., 150)
  • Column AM: Quantity/Sets
  • Special Codes:
  • 'P2E' = N12 200 1200
  • 'Z2A' = N12 450 600

Text Input

No Data Analyzed Yet

Select reinforcement type, upload a file or paste construction sets data to begin analysis.