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-engineering-professional...
**Procurement Course:
cost-engineering-professional...
If you would like to see takeoff 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

[@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 🙏👍.

[@jeffreykruter5317]

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

[@abdallahelhajj9527]

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

[@ksdaily]

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

[@patricknumi3539]

Thank you for sharing. It is superb indeed!

[@ahamedhilmi4221]

very interesting and valuable course. thank you sir

[@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.

[@artofvillageengineering]

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

[@sarfarazmallick6191]

Excellent video …Thanks

[@antonmcdonaldgnanapragasam913]

Thanks for the guidance it was great

[@mz6367]

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

[@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.

[@Vazz01172]

So helpful thank u man

[@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

[@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

[@MohammadAdnan-ql3vj]

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

[@CEPQS]

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

[@lramirez0317]

NICE JOB!

[@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?

[@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

[@jahurulislam8390]

Excellent

[@bilalqasmi9907]

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

[@vinothshalabha3200]

This video is excellent 👍.

[@CEPQS]

Thank you ❤️👍🙏

[@daviddogbe9097]

THANK YOU 🥰

[@CEPQS]

Thank you 😊

[@fardeenbahram9758]

great job. I really appreciate

[@CEPQS]

Glad it was helpful! 🙂

[@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 😊🙏

[@khaldoonawadh3136]

Thank you .

[@CEPQS]

Thank you 😃🙏

[@shabehijer6876]

Thank you so much

[@CEPQS]

You're most welcome

[@mohamedfaisal5059]

As always very helpful video, and Eid Mubarak

[@CEPQS]

Thank you 😊. Eid Mubarak 🙏

[@mariafebronia2690]

Very helpful thanks

[@CEPQS]

Thank you for watching and supporting 🙏

[@mohamedkhan3491]

Thank you

[@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. 🙏

[@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

[@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..

[@kankiritharan3418]

Great 👍

[@akindoyinkehindesolomon7251]

This guy is a magician 😮

[@CEPQS]

😂😂😂 whyyyy

[@maljubori]

thank you sir

[@CEPQS]

Thank you for watching and support 🙏👍🙂

[@Msk1569]

Nice explanation goodness formet

[@CEPQS]

Glad you liked it

[@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]

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

[@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 🙏.

[@adamchalkley9445]

Astounding Channel.

[@CEPQS]

Thanks a lot 🙏

[@abdihakimhassan6791]

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

[@user-qw3xu9ew3d]

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?

[@Ganesh_Kumar_1990]

I liked this video ...

[@CEPQS]

Hope it helped you. Thanks for watching 👍

[@devisbett3599]

Thanks

[@CEPQS]

Welcome

[@nabeelattari1545]

nice.

[@CostEngWorld]

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

[@CEPQS]

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

[@ikeevents2525]

nice

[@JAMMOAli]

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 👍👍

[@ashikfarith]

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

[@dungtruong5305]

Hay quá

[@CEPQS]

🙂

[@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

[@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 👍

[@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

[@fahadiqbal7913]

I really want to like the video...@

[@user-io4zc8xr8p]

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

[@georgecole4844]

I am asking this same question

[@tasbeehullah2430]

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

[@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

[@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 👍🙏

[@blake4567able]

How Can I get a copy of that Excel Doc?

[@Allinone-hf5uu]

Pls explain sir role of qs in mainatanace project

[@CEPQS]

I’ll try my 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??

[@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

[@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.

[@athamfoumymohammed6308]

hi how to buy?

[@saramoz5724]

Do you sell this template ? I need it

[@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👍

[@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.

[@mavol5839]

What about overhead and profit. And taxes??

[@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...🙏

[@craig7878]

Can you upload the excel spreadsheet?

[@nobingeorge138]

Same quantity in summary sheet formula please to be add

[@sivas2795]

Future prospects of cost engineering?

[@andreastiger947]

can you upload the excel file please?

[@Memes_King122]

Can u provide this excel sheet file

[@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.

[@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”

[@buildersandinteriorexperts]

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

[@md.shahinuralamshahin2476]

could you send me the excel file pls

[@AbdalahAlzoabe]

معلم

[@CEPQS]

😊

[@user-ke3rw2ps1j]

hey brother provide me an excel sheet for estimations

[@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.

[@StefaniaBerlin]

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

[@mahroofmafras3510]

hello calculate unit rate sir

[@CEPQS]

Hello, Already calculated 😊😃

[@user-sr9je8jb5y]

Hello sir

[@CEPQS]

Hello 🙂

[@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

[@user-sr9je8jb5y]

Ap muja astimate bana kar da sakta ha

[@CEPQS]

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

[@trm4058]

Where are aluminium and glass costs?

[@user-vc5qx3bx5v]

Please bro. Send me your excel format

[@CEPQS]

Still looking for a way to do that 👍

[@user-vc5qx3bx5v]

Yes bro.

[@user-jy6ou9by4f]

sir pls attach excel here

[@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.

[@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 😊