adspace


How to do bbs in excel format

Answer Posted / Jayant Singh Rathore

BBs (Bill of Quantities) can be created in Excel by organizing the quantity takeoff and item specifications in a structured way. Here's a general guide on how to create a BBS in Excel:
1. Create Worksheets: Organize your workbook into separate worksheets for each trade or discipline (e.g., structural, electrical, plumbing).
2. List Items: List the items under each worksheet according to their respective trade. Include columns for item number, description, quantity, unit price, and total cost.
3. Format: Apply formatting as per your company's standards or the relevant industry standard (e.g., SIA 7-1:2013 in Singapore). Use tables to make it easy to read and navigate.
4. Save: Save the Excel file with a name and extension appropriate for a BBS, such as BBStemp.xlsx.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Kindly post me previous year interview questions with answer for post of DY. Manager (civil engg.) for GAIL, NTPC, IOC, OIL and ONGC etc.

2428


water leak detection system question & answer

2526


hii.plz send me hpcl placement papers for officers trainees for graduate engg plz my email id is ajm_knit@yahoo.com

2364


I need to constructive work in amaraj batteries

1939


kindly mail me by attaching files , formats for quality checks of common building materials like cement , concrete , bricks , sand and aggregates plz send my email id- VMANDAL91@gmail.com

1921


can any one give me sample question paper of BHEL at mdansari86@gmail.com as i m appearing for the same exam.

2235


400 ku d/c clearess ketan hota hai?

2124


Technical Question of Civil Engineering

2358


can u plz send me ntpc placement papers(civil engineering) at mohit_verma21@yahoo.com

2592


What is the per cu. mt. price of ready mix in Gujarat region.?

2429


In how many types u can do POP on ceiling and walls(on which material or by using which material)? b) what is the difference between dry , oil bound, enamel, acrlyic type of painting? 2nd :- I have certain queries, please help to solve. a) length of pile bore is 4m.excavation quantity will be area * length where area will be pi/4 * dia*dia. Is this right? b) It is a single reamed pile of 300m dia and reamed dia is 750mm. can any body help me to calculate excavated quantity of this bulb(reamed section),, concrete quantity in bulb with showing the formulas to be used?

2232


VAT and CST ? Which benefits for buyer ? Why benefits?

1902


manhole chamber having height of 2300 mm and thickness of brickwork is 230 mm and dia of opening covering is 560 mm and bottom length vertical is 1500 mm (1:4) brick masonry and plaster 12 mm on both sides..how to estimate the no bricks used with mortar cement bags and sand for total chamber including plaster.

1839


What is Density of cement, sand & aggregate ?

1610


I HAVE APPLIED FOR 20TH UES ARMY. I WANTED TO KNOW WHEN WILL I RECEIVE CALL LETTER FOR THE SAME.

2510