Getting started
There are three tools for reinforcing steel. They run in your browser: nothing you enter or open is uploaded or stored, and you do not need an account. Close the page and the data is gone.
| If you want to… | Use | Guide |
|---|---|---|
| Turn a bar bending schedule (Excel or CSV) into checked quantities and weights | BBS Analyzer | Guide |
| Find how many 12 m bars to buy and how to cut them with the least waste | Cutting Optimizer | Guide |
| Compare the measured weight of a bar sample with its nominal weight | Steel Weight Verification | Guide |
| Find a construction term in English, Arabic or Chinese | Construction Dictionary | Guide |
- Language. Every page has an English, Arabic and Chinese version. Use the language links at the top of any page; you stay on the same guide or tool.
- Units. Diameters are in millimetres. Lengths are typed in the unit each field asks for (or the one you choose). Weights are in kilograms or tonnes.
- Decimals. Use a dot: 2.35, not 2,35. A comma is refused because 2,350 could mean 2.35 or 2350.
- Stock length. The standard stock bar length in Saudi Arabia is 12 m, and the tools assume it unless you change it in the optimizer.
- Weights are nominal. All three tools use 0.006165 × d² kg/m. They are theoretical weights for planning and checking, not weighed or certified quantities.
Tool guides
Step-by-step tutorials
Tutorial 1: from a BBS spreadsheet to a cutting plan
- Open the BBS Analyzer and choose your .xlsx, .xlsm, .csv, .tsv or .txt file (or paste the range from Excel).
- Check the Columns panel: the header row, and that diameter, cut length and number of bars point at the right columns. If the cut length header has no unit, choose mm or m.
- Press Analyse. Read the three groups: included, excluded from the calculation, and included but not sent to the optimizer.
- Fix what the excluded list shows in your spreadsheet if needed, and load it again. Rows over 12 m stay excluded on purpose.
- If some rows have no grade and you know it, assign it in the third group and tick the confirmation.
- Press Send to Cutting Optimizer. The optimizer opens in a new tab with the lines grouped by diameter, grade and cut length; your schedule stays in the first tab.
- In the optimizer, check the lines, set kerf and reusable offcut length, and press Optimise cutting.
Tutorial 2: a cutting plan without a spreadsheet
- Open the Cutting Optimizer. Leave the stock length at 12 m.
- Set kerf to 0 for shear cutting, or about 3 mm for a saw. Set “reusable offcut from” to the shortest piece your site will actually reuse, for example 1 m.
- Type one line per diameter, grade and cut length: Ø mm, grade, length in metres, pieces.
- Press Optimise cutting, then read the status line, the four figures and the patterns.
- Use Print / PDF for the workshop and Download CSV for your records.
Tutorial 3: checking delivered bars by weight
- Cut a straight sample from each bar, square at both ends, and measure its length.
- Weigh the samples on a calibrated scale.
- Open Steel Weight Verification, enter diameter, length (choose mm or m), number of bars and the measured weight, and press Add sample.
- Repeat for each sample. If your specification or contract gives a weight range, enter it as the lower and upper limit.
- Read each sample’s deviation, the pooled deviation per diameter, and keep the CSV or printed report.
Practical examples
- Cutting: 96 × 2.35 m, 64 × 3.60 m and 40 × 4.25 m of 16 mm Gr60 need 55 bars of 12 m (proven minimum), 1.042 t, 5.15% waste. Worked example.
- BBS: a villa footings and columns schedule gives 860 bars, 1,859.60 m and 2.080 t; one 12.5 m line is excluded and one line without a grade is held back from the optimizer. Worked example.
- Weight check: three 1 m bars of 16 mm weighing 4.600 kg against a theoretical 4.735 kg: −0.135 kg, −2.85%. Worked example.
Engineering formulas
The three tools use the same nominal unit weight, from the nominal diameter d in millimetres:
Unit weight = 0.006165 × d² kg/m · Weight = unit weight × length (m) × number of bars
| Ø mm | kg/m | kg per 12 m bar | Bars per tonne (12 m) |
|---|---|---|---|
| 10 | 0.617 | 7.40 | 135.2 |
| 12 | 0.888 | 10.65 | 93.9 |
| 14 | 1.208 | 14.50 | 69.0 |
| 16 | 1.578 | 18.94 | 52.8 |
| 18 | 1.997 | 23.97 | 41.7 |
| 20 | 2.466 | 29.59 | 33.8 |
| 25 | 3.853 | 46.24 | 21.6 |
| 32 | 6.313 | 75.76 | 13.2 |
- Grade does not change the nominal weight. Grade 60 and Grade 80 bars of the same diameter have the same kg/m.
- Deviation % = (measured − theoretical) ÷ theoretical × 100. Positive: heavier than nominal. Negative: lighter.
- Pooled deviation for samples of one diameter = (Σ measured − Σ theoretical) ÷ Σ theoretical × 100. It is not the average of the sample percentages.
- Kerf. A bar cut into n pieces needs n cuts, or n − 1 when the last piece ends exactly at the bar end. Each cut removes the kerf.
- Waste = bought length − required length (kerf, allowance and offcuts). Utilisation = required ÷ bought.
- Total length in a BBS = cut length × number of bars; number of bars = total column, or no. of members × no. in each.
The separate rebar weight calculator computes with the full density expression (π/4 × 7,850 ÷ 10⁶ = 0.0061654…). The difference from 0.006165 is about 0.007%.
Frequently asked questions
Do I need an account?
No. The tools work immediately, without registration.
Is my file or data uploaded?
No. Everything is calculated in your browser. Nothing is sent to a server or stored, and it is gone when you close the page.
Why are the weights called theoretical?
They come from the nominal diameter and the formula 0.006165 × d² kg/m. Delivered steel is weighed and falls within the tolerance of the governing standard, so invoiced weight can differ.
Why 12 m?
It is the standard stock bar length in Saudi Arabia. The BBS Analyzer excludes any cut length above 12,000 mm because it cannot be cut from one stock bar. In the optimizer you can change the stock length.
Do the tools give prices or quotations?
No. They give quantities and weights. For a quotation, send the quantities to me and I reply with an official Al Rajhi Steel quotation.
Does the weight check tell me whether the steel passes?
No. It compares measured with nominal weight. It shows inside or outside only for a range you enter yourself, and it is not an MTC, a laboratory test or a certification.
Troubleshooting
| What you see | Why | What to do |
|---|---|---|
| “Use a dot for decimals” or a length is refused for a comma | A comma is ambiguous (2,350 = 2.35 or 2350?) | Type 2.35 or 2350 in the right unit. In Excel, format the column as a plain number before copying. |
| BBS Analyzer asks for the cut length unit | The header does not say mm or m, and the tool does not guess | Choose mm or m in the Columns panel, or add “(mm)” to the header in your sheet. |
| A row is excluded: “Cut length exceeds the 12 m stock bar limit.” | The length is above 12,000 mm | This is intended. Split the bar with laps in the design, or order it as a special length outside the tool. |
| Rows are not sent to the optimizer | They have no grade | Assign a grade in the third group and tick the confirmation, or add the grade in the sheet. |
| The file is refused | Saved as .xls, .xlsb or .ods; password-protected or damaged; over 25 MB; or a workbook renamed to .csv | Save the schedule sheet from Excel as .xlsx or CSV UTF-8 and open that. See the supported formats. |
| Arabic or Chinese headers are not recognised in a CSV | The CSV was saved in an old Windows code page | Save it from Excel as CSV UTF-8, or open the .xlsx instead. |
| Nothing opens when sending to the optimizer or WhatsApp | The browser blocked a new tab | Allow pop-ups for mashharawi.com, or use the link shown under the button. |
| Optimizer says “Good plan, not proven minimum” | The plan could not be proven optimal for this job | Use it: it is valid. The gap shown is the most it could be above the minimum. |
| Weight check shows an “Input check” note | The difference is over 25%, usually a typing slip | Re-check the length unit, the number of bars and the diameter. |