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:
| Format | How it is read | Notes |
|---|---|---|
| XLSX (Excel workbook) | Built-in workbook reader | Pick 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 reader | Tested with workbooks saved by Microsoft Excel, with and without macros. Macros are never opened or run. |
| CSV | Text; comma, semicolon or tab detected automatically | If 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. |
| TSV | Text, tab separated | |
| TXT | Text, read like CSV (comma, semicolon or tab) | Excel “Text (Tab delimited)” and “Unicode Text” both work. |
| Paste from Excel | Tab-separated text from the clipboard | Select the schedule including its header row, copy, paste. |
| Manual entry | Fixed columns | Member, bar mark, diameter, grade, shape code, cut length in mm and total bars. |
| XLS, XLSB, ODS | Not supported | Refused 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
| Limit | Value | What happens |
|---|---|---|
| File size, any format | 25 MB | Checked before the file is read. A larger file is refused: save only the schedule sheet as CSV. |
| Rows: CSV, TSV, TXT, pasted text | 100,000 data rows | More rows are refused. Split the schedule and analyse it in parts. |
| Rows: XLSX, XLSM | First 100,000 rows of the sheet | Only those rows are read and a message says so; the totals then cover only those rows, so split the schedule. |
| Columns: XLSX, XLSM | 200 | Columns after the 200th are not read. |
| Workbooks | 50 sheets; password-protected or damaged files refused | Save 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
| Field | Accepted | Not accepted |
|---|---|---|
| Diameter | 16, T16, Y16, H16, Ø16, 16mm (4–60 mm) | #5 (US bar size), text |
| Cut length | Plain decimals with a dot, in the chosen unit | 2,350 (comma), values that only fit the other unit, above 12,000 mm |
| Bars | Whole numbers ≥ 1; or members × bars in each | Fractions, zero, a total that contradicts members × each |
| Grade | Gr60, Grade 60, A615 Gr.60 are one grade; other text kept as written | Never assumed when empty |
| Shape code | Kept as written | Not used to compute lengths |
| Weight | 0.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.
| Group | Rows | Result |
|---|---|---|
| Included in the analysis | 9 | 860 bars · 1,859.60 m · 2.080 t |
| Excluded from the calculation | 3 | Row 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 optimizer | 1 | Row 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.
Related
- Cutting Optimizer and its guide.
- RebarPlan (desktop app that writes bar bending schedules).
- Troubleshooting.