W Beam Calculator

Project Parameters

Total LengthRMT

Post Spacingm

No of Beamssides

Selling Rate₹/RMT

Baseplate

GST / Losses

GST Rate%

Transport GST%

Dross %%

Ash %%

Post Dimensions

Lengthmm

Widthmm

Thicknessmm

Micron (also for Spacer)μm

Wt/pckg

—Zinc kg/pc

—Zinc %

—Galv wt/pc kg

Spacer Dimensions

Lengthmm

Widthmm

Thicknessmm

Wt/pckg

Zinc kg/pckg

Zinc %%

W Beam Dimensions

Lengthmm

Widthmm

Thicknessmm

Micronμm

Wt/pckg

—Zinc kg/pc

—Zinc %

—Galv wt/pc kg

Steel Rates (₹/kg)

Post Steel

Spacer Steel

W Beam Steel

Zinc ₹/kg

Nut-Bolt Rates (₹/pc)

Hex nut ₹/pc

Button bolt ₹/pc

Service Rates

Galv Labor ₹/kg

Slitting ₹/kg

Transport ₹/kg

Transport ₹/mt

Labor ₹/RMT

Coil Parameters

Beam Coil Lenmm

Post Coil Lenmm

Panels/Beam Coil

Panels/Post Coil

Scrap Sold (mm)

Scrap Wastage₹

Byproducts

Dross qty—

Ash qty—

Quantities

Posts—

Spacers—

W Beams—

Hex nuts—

Button bolts—

Weights

Post steel—

Spacer steel—

Beam steel—

Galv total—

Total (incl NB)—

No. of trucks—

Cost Breakdown

Post steel—

Spacer steel—

Beam steel—

Galv zinc (heavy)—

Galv zinc (W beam)—

Galv labor—

Nut-bolts—

Slitting & shearing—

Total basic—

Grand total cost—

Profit Summary

Selling (excl GST)—

Mfg cost/kg—

Profit ₹—

Profit %—

Invoice Details

Proforma No

Validity

Bill To

Contact Name

Company Name

Delivery Address

Phone

Email

Client GST No

Invoice Terms

Transport ₹

Transport GST %

Payment Terms

Freight

Remarks

Optional Extra Items

      DescriptionQty / UnitRate / Amt
    

Description 1

Qty & Unit

Rate ₹

Description 2

Qty & Unit

Rate ₹

Google Sheet Sync

Apps Script URL Paste once — data auto-saves to ProformaRMT sheet on every Generate

Opens in new tab → use browser Print / Share → Save as PDF