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
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.
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.
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
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.
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
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.
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
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
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?
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?
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 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.
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
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??
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..
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
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
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
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.
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 👍
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 ❤️
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 👍👍
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 ?
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 ?
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. 🙏
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
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.
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
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.
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 ?
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?
This channel is literally a treasure for any cost engineer .. Thank you so much.
I bought your course on quantity surveying and cost estimation and I must admit that is a great discovery.
Thank you Charles for such kind testimonial and much appreciate your kind support and time. Wish you all the best 🙏❤️😊
Please where can I buy this course
I also want
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
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.
Thanks a lot 😊 and appreciate your valuable time watching 🙏👍.
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.
Yes
Thanks for the tip. That was helpful for my construction estimates.
To estimate the cost of something you need to gather lots of information
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
Thanks for watching and the feedback
ما شاء الله عليك يا بشمهندس شغل محترم و جهد مشكور
Thank you 😊
Thanks for sharing this help me a lot to improve my estimate skill
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.
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
Thank you 🙏 for watching and for the great support. I hope you enjoyed this video and I promise more similar ones 👍😊. Stay safe.
Idk why, but I fell in love with this guy.
His accent is perfect for teaching too.
Thanks for quality content, sir!
🙏
Thank you 😊🙏
This guy is a magician 😮
😂😂😂 whyyyy
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.
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
Always waiting for your videos boss,
ALLAH bless you
Thank you Faisal bro ❤️. Eid Mubarak to you and your Family 🙏👋🏻.
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
This guy is the smartest Spanish Waiter I know when you play him at .75 speed.
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?
As always very helpful video, and Eid Mubarak
Thank you 😊. Eid Mubarak 🙏
Outstanding...And This is Quite Incredible!!!
Thank you for sharing. It is superb indeed!
So helpful thank u man
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?
Thanks for the guidance it was great
Excellent video …Thanks
very interesting and valuable course. thank you sir
عاش يا باشمهندس
جزيل الشكر و الاحترام 🙂
ما شاء الله شرح رائع جدا ومفيد جدا جدا
جزاك الله خير
اشكرك شكرا جزيلا اخي الكريم. و اتمنى لك التوفيق و النجاح الدائم انشاءالله ❤️🙏😊
Good video! but why did you take down your courses because still learning all about this
This video is excellent 👍.
Thank you ❤️👍🙏
Nice explanation goodness formet
Glad you liked it
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?
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 🙂
@@CEPQS thanks for the reply, but if the contractor is a sole source and we expect the project order in 18 weeks or more?
@@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.
@@CEPQS thanks 🙏.
عيد مبارك و كل التوفيق لكم
عيد مبارك و لكم جزيل الشكر و التقدير على الدعم 🙏
NICE JOB!
Great video! Thank you! Low volume for audio though
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
It’s the benefit of the contractor
Please is there any video where you discuss the breakdown of the Material, Equipment and Manpower?
I am asking this same question
Astounding Channel.
Thanks a lot 🙏
great job. I really appreciate
Glad it was helpful! 🙂
Pls explain sir role of qs in mainatanace project
I’ll try my best ☺️
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??
Very helpful thanks
Thank you for watching and supporting 🙏
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..
Hi sir, the link for this course “Quantity Surveying, Cost Estimation and BOQ Preparation”.
Thanks
THANK YOU 🥰
Thank you 😊
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
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
Excellent
Thank you so much
You're most welcome
Hello sir, please can you share with us howa to do the quantity surveyors of wood construction
Hello 😊. Is this what you are asking for ?
ua-cam.com/video/Ikhm3MtrmrU/v-deo.html
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
I liked this video ...
Hope it helped you. Thanks for watching 👍
Great 👍
Thank you .
Thank you 😃🙏
How can I buy a sample spreadsheet for materials and labour estimating
Thank you for watching. The cost estimation course (link in the description) has all the materials you need. All the best 👍🙏
thank you sir
Thank you for watching and support 🙏👍🙂
Thank you
I want to join the cost professional course. Couldn't buy the course. please advise
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.
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 👍
I can't see what you're clicking on the keyboard :(
Sir does this method apply in case of Electrical Engineers also? Or its specifically for Civil Engineers?
Thanks
Welcome
Can you do a sample cost and estimate for fire protection works alone?
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 ❤️
@@CEPQS oh okay. Thank you for your videos maybe i can be used as guides.
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 👍👍
@@CEPQS Im also searching regarding the productive rates. But if I have i will send it you. Kindly give me your email.
@@CEPQS . You are a Civil engineer, since I started watching your videos I thought your are a Quantity Serveyor.
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 ?
There is more than one margin. Overhead, contingency, and profit
But ofc the percentage will vary cause to case 👍👍
Hay quá
🙂
hi sir can we get a link to market rates system of saudia arabia or dubai
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 ?
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. 🙏
nice.
nice
What about overhead and profit. And taxes??
Can you upload the excel spreadsheet?
Mr. Ahmed can you make cost estimation about bridge mobilization ? it is still hard for me...
Hello 🙂. Do you cost estimation for bridges ???
@@CEPQS yes... am fresh graduated... thats why i dont hv much experience... do you mean I have cost estimation for bridge ? 🙏
@@CEPQS it is a Truss warren bridges length about 120m n width 7 m...🙏
Future prospects of cost engineering?
hi how to buy?
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.
How Can I get a copy of that Excel Doc?
I really want to like the video...@
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
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.
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
I believe you are asking for this:
ua-cam.com/video/-_DoIh-gsLs/v-deo.html
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???
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.
@@CEPQS Huge thanks, I will try👍
Hi can i please get the excel sheet link
Hello 👋🏻. This cost estimation course has links to a similar template “AA Cost Estimation Pro”
Same quantity in summary sheet formula please to be add
Do you sell this template ? I need it
sir how calculate the unit rate
As explained in this video 😃
The unit rate is total cost rate as in the format
@@CEPQS thanks sir
we are waiting for the next videos
@@mahroofmafras3510 already released 😃
ua-cam.com/video/3yHKv3260QQ/v-deo.html
@@CEPQS sir that is finish
that is why i'm ask you sir
can you explain bar schedule
Can u provide this excel sheet file
could you send me the excel file pls
hey brother provide me an excel sheet for estimations
hello calculate unit rate sir
Hello, Already calculated 😊😃
معلم
😊
can you upload the excel file please?
Please bro. Send me your excel format
Still looking for a way to do that 👍
Yes bro.
Hello sir
Hello 🙂
Ap muja astimate bana kar da sakta ha
Estimating cost here in this course: ua-cam.com/video/ZPwkHBAWn6g/v-deo.html
Where are aluminium and glass costs?
sir pls attach excel here
I think accountant can do it more efficiently instead of engineers
This is an insult. What engineers can do Accountant can't and vice versa.
your course it too expensive
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 ?
Thank you Siraj and much appreciate your valuable support 🙏👍. You can contact me on info@costengpro.com
@@CEPQS Thank you very much sir for sharing
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?
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.
@@CEPQS thanks dear engineer.
We love you and your work.
Great video. Perfect for students in the profession. What is your LinkedIn details Ahmed Adil? Would be great to connect with you. Regard, Jay
Thank you for the support. Much appreciated 🙏👍
Thank you sir
Welcome 😊