How To Prepare Construction Cost Estimation Format In Excel For Projects

In this video, I explain how to prepare construction cost estimation format in Excel, including rate breakdown analysis for construction projects. This format helps you estimate the costs of the items in construction projects in a quick and accurate manner. You will get the amount estimated for each cost element in the project after using it.
Labor Cost Estimation video link: • Labor cost estimation ...
Labor Productivity video link: • Labor Productivity Rat...
You can enroll to our Cost Estimation online courses from these below links:
**Cost Estimation Course:
cost-engineeri...
Here is the link to download my cost estimation template for free:
www.costengpro...
**Procurement Course:
cost-engineeri...
If you would like to see content similar to our course for free , please visit our KZbin channel:
/ @cepqs
If you would like to join our Facebook page where we discuss everything related to quantity surveying and cost estimation:
/ costengpro

[@abdallahelhajj9527]

This channel is literally a treasure for any cost engineer .. Thank you so much.

[@mz6367]

To estimate the cost of something you need to gather lots of information

[@charlesokoro2100]

I bought your course on quantity surveying and cost estimation and I must admit that is a great discovery.

[@CEPQS]

Thank you Charles for such kind testimonial and much appreciate your kind support and time. Wish you all the best 🙏❤️😊

[@oep8823]

Please where can I buy this course

[@romupfaprecious368]

I also want

[@zainengineer8735]

I want to learn about joinery QS and estimation with complete breakdown as per UAE rates and excel sheet template for calculation let me know pls​@@CEPQS

[@hanningtonopondo8907]

This is a very good guide for establishing cost estimation in excel, you have well explained your methods. It is best for Esimators and Qs working for a contractor. Many thanks. I am sure you had a good IDD.

[@CEPQS]

Thanks a lot 😊 and appreciate your valuable time watching 🙏👍.

[@ibrahimdiis4595]

OMG i'm an interior designer and wish to grasp all this info. i can only become great in this kind of work through direct contact with the tutor like sitting in your class.

[@ammuhasini3305]

Yes

[@jeffreykruter5317]

Thanks for the tip. That was helpful for my construction estimates.

[@mostafasoliman-k6g]

ما شاء الله عليك يا بشمهندس شغل محترم و جهد مشكور

[@CEPQS]

Thank you 😊

[@ibrahimmusthafanava5639]

your channel is very much helpful for me to improve my skills. Can you please share BOQ, AND AMC Contracts for MEP HARD AND Soft services to provide a sample format in excel? I would like to practice myself.

[@abdulmateen3369]

What a beautiful explanation and to make things more easy you can use only Rate column cause eventually Rate is going to multiply with Units in Amount column

[@CEPQS]

Thanks for watching and the feedback

[@ksdaily]

Thanks for sharing this help me a lot to improve my estimate skill

[@akindoyinkehindesolomon7251]

This guy is a magician 😮

[@CEPQS]

😂😂😂 whyyyy

[@muhammaddargallay2830]

very helpful thank you sir ... would you prefer to use another software for cost estimation like stack or candy or excel is enough ?? as your experience

[@mohamedfaisal5059]

As always very helpful video, and Eid Mubarak

[@CEPQS]

Thank you 😊. Eid Mubarak 🙏

[@schoolfield27]

Thank you for sharing this knowledge. it gives me more idea on costing, it convince me more because the 1 i have here in my work is similar to that format but its M&E BOQ. thank you very much sir. hoping for more costing idea videos

[@CEPQS]

Thank you 🙏 for watching and for the great support. I hope you enjoyed this video and I promise more similar ones 👍😊. Stay safe.

[@AceCPAsBookkeeping]

TLDR: The video demonstrates how to create a construction cost estimation format in Excel by breaking down rates into four categories and adding 10 columns, and then calculating the total cost for construction projects using a detailed breakdown of materials, equipment, and manpower. 00:00 🔨 Learn how to create a construction cost estimation format in Excel by breaking down rates into four categories and adding 10 columns. 02:26 🔧 Adjust borders and lines in Excel to create a construction cost estimation format for projects. 03:35 💡 Copy and paste rates and amounts for materials, equipment, manpower, and subcontractors to calculate total cost. 05:18 💡 Start estimating the cost by calculating the total amount for each cost element and linking cells to other tabs for material, labor, and activity costs. 06:51 🏗 Learn how to calculate construction costs for concrete and steel reinforcement in Excel using formulas and adjusting rates for different project elements. 09:18 💰 Calculate material and equipment costs for construction projects in Excel using the price per ton and dividing by 1000. 10:26 💡 Calculate the total cost for construction projects using a detailed breakdown of materials, equipment, and manpower. 12:03 💰 Add 15% margin to the total cost rate, hide the details, and print as a PDF for submission as the priced BOQ.

[@vinothshalabha3200]

This video is excellent 👍.

[@CEPQS]

Thank you ❤️👍🙏

[@sarfarazmallick6191]

Excellent video …Thanks

[@faisaldilshad6765]

Always waiting for your videos boss, ALLAH bless you

[@CEPQS]

Thank you Faisal bro ❤️. Eid Mubarak to you and your Family 🙏👋🏻.

[@faisaldilshad6765]

Thank you so much boss, السَّلاَمُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ Happy Eid-ul-Fitr to you and your family from me and I pray to ALLAH to accept all the good deeds of you and your family in the court of ALLAH, Muhammad Faisal Dilshad

[@Veeeeeeman72]

So helpful thank u man

[@artofvillageengineering]

Outstanding...And This is Quite Incredible!!!

[@ahamedhilmi4221]

very interesting and valuable course. thank you sir

[@adhocmtb8036]

Good afternoon, i have a question... If you were to categorize this method of cost estimating in terms of basic, intermediate or advanced; what category would it fit into?

[@aiswaryaradhakrishnan1072]

Thanks for the video, sharing the knowledge and for well explanation. if we have subcontractor price for some item in the proposal stage, do we need to put exact price or can we increase the price based on the inflation as it's in proposal stage?

[@CEPQS]

Thank you for watching and support 🙏. What I would do is to get more than 1 offer if the tender timing allows. And if prices are in the same range I would take the average 🙂

[@aiswaryaradhakrishnan1072]

@@CEPQS thanks for the reply, but if the contractor is a sole source and we expect the project order in 18 weeks or more?

[@CEPQS]

@@aiswaryaradhakrishnan1072 well if there is an inflation factor then you have to establish the future value with economic analysis. But one thing you can is to check with subcontractor about the duration of his offer validity first.

[@aiswaryaradhakrishnan1072]

@@CEPQS thanks 🙏.

[@SelauMaugaotega]

This is self explanatory..thank you so much and it's very helpful..where can i get the attachment pls so that i can use it please?

[@antonmcdonaldgnanapragasam913]

Thanks for the guidance it was great

[@Msk1569]

Nice explanation goodness formet

[@CEPQS]

Glad you liked it

[@patricknumi3539]

Thank you for sharing. It is superb indeed!

[@MohammadAdnan-ql3vj]

ما شاء الله شرح رائع جدا ومفيد جدا جدا جزاك الله خير

[@CEPQS]

اشكرك شكرا جزيلا اخي الكريم. و اتمنى لك التوفيق و النجاح الدائم انشاءالله ❤️🙏😊

[@katisokhali8127]

Good video! but why did you take down your courses because still learning all about this

[@AJ-et3vf]

Great video! Thank you! Low volume for audio though

[@braveheart3473]

عاش يا باشمهندس

[@CEPQS]

جزيل الشكر و الاحترام 🙂

[@MunirudeenMonsur]

Please is there any video where you discuss the breakdown of the Material, Equipment and Manpower?

[@georgecole4844]

I am asking this same question

[@CrazyWorld8161]

Hi, thank you for this helpful video. I just didn't understand the end of the video. why did you apply 1.15* Total Rate instead of cope the Total Rate ???? Thank you

[@Nicolas-ch5yu]

It’s the benefit of the contractor

[@fardeenbahram9758]

great job. I really appreciate

[@CEPQS]

Glad it was helpful! 🙂

[@lramirez0317]

NICE JOB!

[@mariafebronia2690]

Very helpful thanks

[@CEPQS]

Thank you for watching and supporting 🙏

[@adamchalkley9445]

Astounding Channel.

[@CEPQS]

Thanks a lot 🙏

[@daviddogbe9097]

THANK YOU 🥰

[@CEPQS]

Thank you 😊

[@CostEngWorld]

عيد مبارك و كل التوفيق لكم

[@CEPQS]

عيد مبارك و لكم جزيل الشكر و التقدير على الدعم 🙏

[@vincentbyrneconsult1]

How can I buy a sample spreadsheet for materials and labour estimating

[@CEPQS]

Thank you for watching. The cost estimation course (link in the description) has all the materials you need. All the best 👍🙏

[@gentlestrokes2139]

Hello, I'm not an engineer but Iam pretty good with math. I am trying to make an estimation for a small project in my yard. I would like to know Where do you find the rate and the manpower cost for your country??

[@iainhmunro]

We use MS Project for helping rollup the costs of a project for proposal purposes. So, adding in normal task etc with the resources and the hourly rates in the backend. So I typically add in the task, then the resources and everything is ok - the cost column rolls up the costs as it would do normally, but when I them go to add in the dates for the work to start, all hell breaks loose when the costs now change - as would expect project to do, but I don't want that to happen, the costs are fixed - all I want to do is highlight when the work will start, not actually say that the task taking 2 days longer etc. Is there a way to fix this ?

[@CEPQS]

Apologies, I don’t know much of MS project. But generally with reference to project costs we need to understand the earned value metrics. There are planned values, actual costs, and earned values. Planned values should be fixed as they follow the baseline, however actual costs are the ones that should be updated on the program. Hope it helps and apologies if it doesn’t. 🙏

[@Allinone-hf5uu]

Pls explain sir role of qs in mainatanace project

[@CEPQS]

I’ll try my best ☺️

[@ahmedrashid8596]

Salam sir...i m ur new subscriber ..plz upload more videos regarding cost engineering and planning engineer course on primavera p6...practically live project...and plz also provides videos regarding ms excel for engineer...more videos for steel bar bending estimating etc..thank u...u r doing a good job..

[@Deepmotivational9]

Hello sir, please can you share with us howa to do the quantity surveyors of wood construction

[@CEPQS]

Hello 😊. Is this what you are asking for ? kzbin.info/www/bejne/f5zLnmaDqdegqLc

[@Deepmotivational9]

Thanks for your reply. No not this, I would the Wooden structure, wooden house built only with wood, I need how to make the quantity surveying of this type of construction

[@EngMohali]

very interesting and valuable course. thank you sir but I have a question ; you add the final rate 15% what's that percentage mean? coz it may be lot of money to the big projects and where did you get this number 1.15 ?

[@CEPQS]

There is more than one margin. Overhead, contingency, and profit

[@CEPQS]

But ofc the percentage will vary cause to case 👍👍

[@shabehijer6876]

Thank you so much

[@CEPQS]

You're most welcome

[@matiullahsarwari823]

Dear sir I wish you are doing well. I am from Afghanistan I am following your vedio and it is very intresting for me but I want to estimate skill &unskill labous ,sand,graval,and all requairment in excel if could you help me about it will be kind of you

[@CEPQS]

Love to Afghanistan and wish you all the best. There are several videos on the channel about mortar and cost estimation in general and I’ll be adding more inshallah. Thank you

[@visionarydesignbuild4481]

Idk why, but I fell in love with this guy. His accent is perfect for teaching too. Thanks for quality content, sir! 🙏

[@CEPQS]

Thank you 😊🙏

[@buildersandinteriorexperts]

This guy is the smartest Spanish Waiter I know when you play him at .75 speed.

[@yowmamen4767]

Can you do a sample cost and estimate for fire protection works alone?

[@CEPQS]

Thank you for the request, however MEP is not my core competency as I’m a civil engineer 😃. Specially for FF works, I can’t do that. Sincere apologies ❤️

[@yowmamen4767]

@@CEPQS oh okay. Thank you for your videos maybe i can be used as guides.

[@CEPQS]

I can do the video, but I’ll need some information about material rates and productivities 😃. If you can provide me these information then we can do it 👍👍

[@yowmamen4767]

@@CEPQS Im also searching regarding the productive rates. But if I have i will send it you. Kindly give me your email.

[@hanningtonopondo8907]

@@CEPQS . You are a Civil engineer, since I started watching your videos I thought your are a Quantity Serveyor.

[@abdihakimhassan6791]

Hi sir, the link for this course “Quantity Surveying, Cost Estimation and BOQ Preparation”. Thanks

[@ashikfarith]

I want to join the cost professional course. Couldn't buy the course. please advise

[@Ganesh_Kumar_1990]

I liked this video ...

[@CEPQS]

Hope it helped you. Thanks for watching 👍

[@khaldoonawadh3136]

Thank you .

[@CEPQS]

Thank you 😃🙏

[@jahurulislam8390]

Excellent

[@kankiritharan3418]

Great 👍

[@bilalqasmi9907]

Sir does this method apply in case of Electrical Engineers also? Or its specifically for Civil Engineers?

[@maljubori]

thank you sir

[@CEPQS]

Thank you for watching and support 🙏👍🙂

[@tasbeehullah2430]

hi sir can we get a link to market rates system of saudia arabia or dubai

[@vinothshalabha3200]

Can u send manpower productivity for each activity means suppose formwork 1 carpenter +1helper- 7 to 10m2 per day(different works) Equipment/materials required per hour/units for each activity of work

[@CEPQS]

I believe you are asking for this: kzbin.info/www/bejne/Y5CnoHyeYsymgtU

[@HARCONSTRUCTION]

I created something similar for my material cost just based on my weekly purchases. Now, every time I need a material cost I just enter the quantity.

[@mebrahtumedhanie4150]

Hi my dear Engineer . I really appreciate your video .my dear engineer if you willing i ask to you how can create or form a "rate " in BOQ . Out side from reseach of marketing rate method.

[@CEPQS]

Thank you for watching and the question. To establish the rate of anything you have understand the cost elements involved i.e. materials equipment manpower subcontractor. And from there you establish 👍

[@waheedshahzad9875]

Hi Engr Ahmed, I have purchased your cost estimation package on your official website. But its missing one concrete video related to inhouse concrete works. Please share that video

[@CEPQS]

Hello Waheed. I’ll add that missing video there 👍. it will be a little bit similar to this video that you have commented on. Btw, the full Project BOQ is available to download at the last lecture. Thank you for your purchase and support and wish you all the best.

[@StefaniaBerlin]

I can't see what you're clicking on the keyboard :(

[@Kenan19874]

Mr. Ahmed can you make cost estimation about bridge mobilization ? it is still hard for me...

[@CEPQS]

Hello 🙂. Do you cost estimation for bridges ???

[@Kenan19874]

@@CEPQS yes... am fresh graduated... thats why i dont hv much experience... do you mean I have cost estimation for bridge ? 🙏

[@Kenan19874]

@@CEPQS it is a Truss warren bridges length about 120m n width 7 m...🙏

[@athamfoumymohammed6308]

hi how to buy?

[@mohamedkhan3491]

Thank you

[@sivas2795]

Future prospects of cost engineering?

[@blake4567able]

How Can I get a copy of that Excel Doc?

[@fiydude365]

Sir, I did everyshing as in the video, and even put the sign of "$" but error appears in the cell instead of Zero, can you explain why???

[@CEPQS]

Thank you for watching and for reaching out. Try to use the button “F4” instead of typing the $ sign. Also remember that $A will fix column A and $1 will fix row 1 and $A$1 will fix cell A1. Just try it again and hopefully it works 🙂. Wish you all the best.

[@fiydude365]

@@CEPQS Huge thanks, I will try👍

[@devisbett3599]

Thanks

[@CEPQS]

Welcome

[@craig7878]

Can you upload the excel spreadsheet?

[@saramoz5724]

Do you sell this template ? I need it

[@pshashank0314]

Hi can i please get the excel sheet link

[@CEPQS]

Hello 👋🏻. This cost estimation course has links to a similar template “AA Cost Estimation Pro”

[@mavol5839]

What about overhead and profit. And taxes??

[@ikeevents2525]

nice

[@nabeelattari1545]

nice.

[@mahroofmafras3510]

sir how calculate the unit rate

[@CEPQS]

As explained in this video 😃

[@CEPQS]

The unit rate is total cost rate as in the format

[@mahroofmafras3510]

@@CEPQS thanks sir we are waiting for the next videos

[@CEPQS]

@@mahroofmafras3510 already released 😃 kzbin.info/www/bejne/aaqrfKlpZ5tjh7M

[@mahroofmafras3510]

@@CEPQS sir that is finish that is why i'm ask you sir can you explain bar schedule

[@dungtruong5305]

Hay quá

[@CEPQS]

🙂

[@Memes_King122]

Can u provide this excel sheet file

[@fahadiqbal7913]

I really want to like the video...@

[@nobingeorge138]

Same quantity in summary sheet formula please to be add

[@md.shahinuralamshahin2476]

could you send me the excel file pls

[@sulemanlaiq]

hey brother provide me an excel sheet for estimations

[@mahroofmafras3510]

hello calculate unit rate sir

[@CEPQS]

Hello, Already calculated 😊😃

[@andreastiger947]

can you upload the excel file please?

[@MainAhmed-v6f]

Ap muja astimate bana kar da sakta ha

[@CEPQS]

Estimating cost here in this course: kzbin.info/www/bejne/kIHanHt4dryhbMk

[@MrIntrovert-p7l]

Please bro. Send me your excel format

[@CEPQS]

Still looking for a way to do that 👍

[@MrIntrovert-p7l]

Yes bro.

[@FriendTrue2008]

I think accountant can do it more efficiently instead of engineers

[@meshackwachiuri566]

This is an insult. What engineers can do Accountant can't and vice versa.

[@AbdalahAlzoabe]

معلم

[@CEPQS]

😊

[@MainAhmed-v6f]

Hello sir

[@CEPQS]

Hello 🙂

[@trm4058]

Where are aluminium and glass costs?

[@IsmaelKarim-d9h]

sir pls attach excel here

[@kunaljha6837]

your course it too expensive

[@mohamedsiraj1988]

Dear sir Your tutorials is much more value for the Quantity surveyors and I really thanks to god because i found you in the mean time. Sir if possible kindly share your contact information please ?

[@CEPQS]

Thank you Siraj and much appreciate your valuable support 🙏👍. You can contact me on [e-mail]

[@mohamedsiraj1988]

@@CEPQS Thank you very much sir for sharing

[@PracticalConstructions]

Thanks dear sir. I m er. Numan i want to engage your course. Very soon. I m work with contracting company in Al Ain UAE, now i need these types of lectures. May i approach your WhatsApp?

[@CEPQS]

Hello Mr. Numan and thank you for the support. I'll coordinate a seminar in the near future, and i'll make sure that you know it is about to happen.

[@PracticalConstructions]

@@CEPQS thanks dear engineer. We love you and your work.

[@theone9069]

Great video. Perfect for students in the profession. What is your LinkedIn details Ahmed Adil? Would be great to connect with you. Regard, Jay

[@CEPQS]

Thank you for the support. Much appreciated 🙏👍

[@yolimoonercar2966]

Thank you sir

[@CEPQS]

Welcome 😊