Omar Mashharawi

Help Center

BBS Analyzer: guide

How to turn a bar bending schedule into checked quantities and theoretical weights, and send the cut lengths to the cutting optimizer.

Open the tool

What the tool does

The analyzer reads a bar bending schedule (BBS), recognises its columns, checks every row, and totals bars, length and theoretical weight by diameter, grade and shape. It never fills in missing engineering data: a row it cannot read is excluded and listed with the reason.

When to use it

  • To check a BBS from a consultant or subcontractor before ordering.
  • To get tonnes per diameter and grade for a quotation request.
  • To prepare the cut lengths for the cutting optimizer.

Privacy: your file stays in your browser

  • Processed locally. The file is opened and analysed by the page in your own browser.
  • Not uploaded. The contents of the file are never sent to the website’s server or anywhere else.
  • Not stored. The website does not keep the file, and the tool does not save it in your browser for later. No account is needed.
  • Closing the tab ends the session. The file, the analysis and anything you typed are gone when you close the tab. Open the file again next time.

Send to Cutting Optimizer passes the grouped cut lengths to the new tab inside the page address, after the “#” sign, which browsers do not send to the server; the optimizer removes it from the address once it has read it. Download CSV and Print / PDF are created in your browser too.

Step by step

1. Open the schedule

Choose a file, drop it on the box, paste a range from Excel, or type the lines by hand. These are the formats the analyzer actually reads:

FormatHow it is readNotes
XLSX (Excel workbook)Built-in workbook readerPick the sheet if there are several. Formula cells use the value Excel last saved, and those rows are marked.
XLSM (macro-enabled workbook)Same workbook readerTested with workbooks saved by Microsoft Excel, with and without macros. Macros are never opened or run.
CSVText; comma, semicolon or tab detected automaticallyIf the schedule has Arabic or Chinese text, save it from Excel as CSV UTF-8; an older “CSV” saved in a Windows code page is not read correctly.
TSVText, tab separated
TXTText, read like CSV (comma, semicolon or tab)Excel “Text (Tab delimited)” and “Unicode Text” both work.
Paste from ExcelTab-separated text from the clipboardSelect the schedule including its header row, copy, paste.
Manual entryFixed columnsMember, bar mark, diameter, grade, shape code, cut length in mm and total bars.
XLS, XLSB, ODSNot supportedRefused with a message. Save the sheet as .xlsx or CSV and open that.

The file picker lists .xlsx, .xlsm, .csv, .tsv and .txt. A file chosen with “All files”, or dropped on the box, is checked by name and by content: .xls, .xlsb and .ods are refused with a message, and any other name is read as text only if it really is text. A workbook given another name is refused, never shown as rows of noise.

File and row limits

LimitValueWhat happens
File size, any format25 MBChecked before the file is read. A larger file is refused: save only the schedule sheet as CSV.
Rows: CSV, TSV, TXT, pasted text100,000 data rowsMore rows are refused. Split the schedule and analyse it in parts.
Rows: XLSX, XLSMFirst 100,000 rows of the sheetOnly those rows are read and a message says so; the totals then cover only those rows, so split the schedule.
Columns: XLSX, XLSM200Columns after the 200th are not read.
Workbooks50 sheets; password-protected or damaged files refusedSave the schedule sheet as .xlsx again, or as CSV.

2. Check the columns

The analyzer looks for the header in the first 30 rows and matches columns by name in English, Arabic or Chinese (Bar mark, Dia, Cut length, No. of members, رقم السيخ, القطر, 钢筋编号, 下料长度…). Check every field and change any that is wrong.

  • Required: diameter, cut length, and the number of bars: either a total column, or “no. of members” and “no. in each” together.
  • Optional: bar mark, member, grade, shape code, and the sheet’s own total length and weight, which are used only to cross-check.
  • Cut length unit: read from the header, for example “Cut length (mm)”. If the header does not say, you must choose mm or m; the tool does not guess.
  • Header row: change it if the title rows confuse the detection.

3. How values are read

FieldAcceptedNot accepted
Diameter16, T16, Y16, H16, Ø16, 16mm (4–60 mm)#5 (US bar size), text
Cut lengthPlain decimals with a dot, in the chosen unit2,350 (comma), values that only fit the other unit, above 12,000 mm
BarsWhole numbers ≥ 1; or members × bars in eachFractions, zero, a total that contradicts members × each
GradeGr60, Grade 60, A615 Gr.60 are one grade; other text kept as writtenNever assumed when empty
Shape codeKept as writtenNot used to compute lengths
Weight0.006165 × d² × cut length × bars (theoretical)Sheet weights are only compared, never used

4. Fix excluded rows

Excluded rows are listed with row number, bar mark, diameter, cut length, bars and the reason. Correct the spreadsheet and load it again. Title, note and subtotal lines are excluded as “not a bar line”, which is expected.

Why bars over 12 m are excluded

A cut length above 12,000 mm cannot be cut from one 12 m stock bar. The analyzer excludes it from every total and from the optimizer hand-off, and shows its bars, length and theoretical weight separately so nothing is hidden. 12,000 mm itself is included. The decision is made on the value exactly as written: 12,000.001 mm is excluded.

Why a missing grade must be chosen by you

Grade 60 and Grade 80 are different products. Rows without a grade stay in the analysis as “no grade” but are not sent to the optimizer. If you know the grade, enter it in the third group, read which rows it applies to, tick the confirmation and press Assign grade. It applies to all rows without a grade and is marked as assigned by you. The tool never assumes a grade.

5. Send to the Cutting Optimizer

Press Send to Cutting Optimizer. Valid rows are grouped by diameter, grade and cut length (rounded to the millimetre) and the optimizer opens in a new tab with them. Review the lines there and press Optimise; nothing runs by itself. Your schedule stays unchanged in the analyzer tab.

Worked example

Villa footings and columns (the sample schedule)

Press Load sample schedule. The header is on row 3; the cut length header says (mm), so the unit is set automatically.

GroupRowsResult
Included in the analysis9860 bars · 1,859.60 m · 2.080 t
Excluded from the calculation3Row 12: length “2,875” (comma) · Row 13: 12,500 mm, exceeds the 12 m stock bar limit (4 bars, 50 m, 0.193 t shown apart) · Row 15: the “Total” line
Included, not sent to the optimizer1Row 14: no grade, 20 bars

By diameter: 10 mm 320 bars 292.0 kg · 12 mm 308 bars 686.1 kg · 16 mm 184 bars 729.1 kg · 20 mm 48 bars 372.9 kg. Warnings: bar mark 06 in member B1 repeats on rows 9 and 10 with identical data (review), Gr60 is also written “Grade 60”, and two rows have a sheet weight more than 1% from the theoretical weight.

Sending to the optimizer transfers 7 grouped lines; the no-grade row is held back. With kerf 0 and reusable offcuts from 1 m, the optimizer needs 160 bars of 12 m (2.209 t), proven minimum.

Reading the results

  • Three groups tell you exactly where every row went: included, excluded with a reason, or included but held back from the optimizer.
  • Warnings need review but do not change the totals: repeated bar marks (checked within each member; without a member column they cannot be told apart), several grades, grade spellings, non-standard diameters, formula values, and sheet weights or lengths that disagree.
  • Tables by diameter, by diameter and grade, by grade and by shape add up to the same totals.
  • Download CSV exports the used rows, the summary and the excluded rows; Print / PDF prints the report.

Common mistakes

  • Leaving the cut length unit to chance: always check the unit the analyzer shows.
  • Mapping “Total length” as cut length: cut length is the length of one bar.
  • Expecting bars over 12 m to be cut: they are excluded by design.
  • Assigning a grade “to make the rows go through” when the drawing does not say: ask the designer instead.
  • Saving the workbook without recalculating: formula cells use the value Excel saved, and those rows are marked.

Limitations

  • Old .xls, .xlsb and .ods files are not supported; see formats and limits.
  • Cut lengths are not calculated from shape dimensions.
  • Weights are theoretical estimates, not certified quantities.
  • One grade at a time can be assigned to all rows without a grade; different grades per row must be corrected in the sheet.

← All help topics · Tool guides