BAGS OF CEMENT, SAND AND GRAVEL IN 1 CUBIC METER W/ 1:2:4 CONCRETE MIX RATIO | FREE EXCEL PROGRAM
HTML-код
- Опубликовано: 8 сен 2024
- You can download excel program of the estimate in the link below. Just make sure to LIKE, SHARE and SUBSCRIBE to my RUclips Channel.
Download link: drive.google.c...
0:32 Tips and computation on how to get the quantities of cement, sand gravel.
11:20 Excel program estimate
NOTE: The 3,000 psi 1:2:4 cement-sand-gravel mix ratio can be achieved with proper proportioning of the mixture and gradation of sand and aggregate. Also, the cement-water ratio and proper curing should be followed.
For manual batching where quality control is not observed, it is advised to use 1:1.5: 3 to 1:2:3 mixture to achieved 3,000 psi concrete.
#cementsandgravel#concreteestimate#estimatedearnings
#concreteestimate
#cement
*You can download the excel program estimate in the link below. Just make sure to LIKE, SHARE and SUBSCRIBE to my RUclips Channel.*
*Download link 👇👇👇👇 Comment " GOT IT" if you DOWNLOADED the program.*
drive.google.com/file/d/1q91UYfJcNEGn8iwbbABqHRwmQi5I_BD_/view?usp=sharing
Thank you sir sa idea god bless po
Sir sana po mag vlog ka kung pano pag compute ng rebars,
Salamat po in advance sir
@James Jamari instablaster =)
How po
Got It! So Helpful.. Thanks.. 😊
Thank you sir for giving this file,malaking tulong to para sa mas mbilis na pagkuha ng computations specialy sa cubic meter..godspeed sir
guys dont skip adds, very informative and useful itong vid nato. More power sa channel na to
1:2:4
density of cement = 1440kg/cu.
1 bag cement = 40kg
1440/40 = 36
36/4 = 9 bgs
Thank you sir,, very big help tong excel mo para easy nalang pag calculate 😊😊
Grabeh ang galing nyu magturo sir 💪💪napakalaking tulong po nito. Salamat po. God bless po sir!!
salamat dito sa tutorial mo idol ang ganda dina mahirapan sa pag papatrabaho at pag estimate ng materyales sa pagpapagawa ng bahay tsaka yang excel salamat sayo idol
Pashare naman yung video. Salamat.
Million Likes and subscribed ! Salamat sa excel file. Daming salamat Engineer.
Thank you Sir & very impormative at sana marami pa kayong gagawin na formulation. God bless
Salamat po dito..TLE teacher in the making here 😁🤞
Thanks for sharing this lods, nakakatulong talaga ito sa project ko. God Bless you po!
Thank you sir ..Very informative kaayo imung videos and naa pay pa bonus na Excel Thank kaayo sir hopefully you make another Excel po for other like VERTICAL and other horizontal po ...
Very informative, and made my life more easier by using the excel file.. thank sir...
Shared Excel:Easy Life for my Lazy Life...
Charrrr😆😆
.. new subscriber here
thank you very much HarleyA Simple Designs for sharing, Godbless
Thanks a lot Sir very clear explanations more power to you. GOD BLESS
Salamat po sa excel file sir hehe 👍😊
Maraming salamat po Sir sa inyo.
Soft and clear
i would like to say super thank it helps me a lot
Godblss to u sir sa napaka informative na blog.more power
Boss, hindi 1:2:4 ang 3000psi kundi 1:1.5:3 kasi ang 1:2:4 ay M15 yan 2175 psi lang yan. Ngayon para makuha mo ang dami ng cement sa simple na mamaraan e multiply mo lang ang Volume sa 36 divide mo sa gravel mix. Yang 1:2:4 kung yan ang gagamitin mo sa (1m3 x 36 )/4 = 9bags kana kulang kana ng isa. Pag ganyan kasi ang pamamaraan mo kahit sa 2175 psi hindi sya aabot as per my experience. But ayos itong mga vlog mo nakaka pag bigay ka ng idea. God bless
Natest na namin yan.. basta me quality control at tama ang water-cement ratio maaatain mo yung 3000 psi.. pero king mano mano, 1:2:3 mixture.
Nice prgram bro. Full watch from jeddah
salamat lods... ♥️♥️♥️ very helpful...
hopefully meron din sa rebars hahaha🤣🤣
thanks a lot for sharing fantastic tips
Thank you Boss sa Excell nag Subscribe ako sa effort mo👍
Engr. Palitan muna ng yes ang No kc hindi ma palitan pg cp ang gamit ayos ang program mo madali mg compute sana nxt yg mga bakal nman tkanks
Hindi man ma download engr. Paano palitan ang NO ng yes
Thank you for this Sir.. more more calculation request ot share. thank you and more power.. Requesting for the rebars calculation . thanks.
Thank you for sharing Sir. God bless.
Salamat po engr
thanks for sharing idol.keep vlogging
bless you for sharing your content.
Salamat sir.
GOD bless u
GOT IT
salamat boss. i learn a lot. sa bakal naman po sana tranks
thanks kapatid
Very good tutorials...
Got It
Yes
Salamat Idol!!
bless you sir on sharing the idea.
Sir saan niyo po nakuha ang mga void percentage values 27%, 34%, 7%? Any references? Books? Gusto ko lang po parang facts saan nang galing yung mga values? Salamat
Very informative. Thank you sir !!
yes makikita yang subracriber computation
Got it!....Thanks a bunch!
very informative. kung mag buhos kayo ng column, kailangan ba mag deduct sa volume ng mga rebars para accurate yung volume ng concrete na kailangan?
Hindi na. Factor mo na yan sa wastage.
salamat sir
Great help po ito sir. Sir may excel sheet formula din po ba sa steel bar na magagamit hehe
Does the cement weight varies from country to country or continent to continent?Bcz in Africa is 50kg
Very informative new subscriber here
i love po
Hi Engr,
Thanks for sharing your knowledge.
Pag pang pundasyon ng poste sa bakod na barbed wire, ano ang mix ratio? ilang PSI and needed, kung ang poste ay 2 meters na 1" GI sched40pipe?
Best regards from Bicol🌋
1:2:4 - 2500 to 3000 psi depending on how the mix is prepared.
Subscribed! thankyou boss!
subscribed!
sir matagal ko na yan kinumpara ang formula na yan pati ng formula ng ginagamit ng ibang engineer dito sa atin magkaiba talaga ang resulta tulad halimbawa sa bag of cement.Ang ratio na 1:2:4 sa computation mo is 8 bags of cement sa ibng formula ang 1:2:4 ay 9 bags ho yan kc ang ibng formula is
no.of cement= vol.of concrete x 36/4
= 1 cu.m x 9 bags/ cu.m
= 9 bags
I'm not sure how the 9 cement bags/cu.m. was derived. My figures were supported with 2 computations. You can only verify that by actual mixing with properly graded sand and gravel.
@@harleyasimpledesigns2806 sir the number of bags per cu.m is 36 bags so if you are using the 1:2:4 mux you have to use this formula.
cement=volume of concrete (36/4)
= 1cu.m (9 bags/cu.m)
= 9. bags
@@richardlei1391 l'll stick to my formula and use yours. How was the 36/4 derived?
@@harleyasimpledesigns2806 sir i respect your idea and i am not saying your formula is wrong, i'am just telling you there's s diffrerence and i know what i said.My formula same as formula with the other engineers.
@@richardlei1391 Understood. I'm just responding to your comment that I have to use your formula. If you could provide how was 9 bags/cu.m. then we can compare. We can't just establish a constant without proof.
Goodevening sir! Ganda po ng explanation ninyo. Ask ko lang po paano po kapagtrapezoid yung figure, dike po kasi ginagawa namin. Maapektuhan po kaya yon?
yes
Thumps up and subscribe. Thank you sir.
Wow
YES, pano gamitin idol
Nakadetalye sa video kung paano gamitin ang program. PAnorin mo.
Very informative sir. Saan po reference nyo sa 4:28 - 5:54 regarding sa 1.54 multiplier? Thank you in advance po
Thank you po sir idol... Baka po meron kayo program ng para sa Labor parameters po. GB
Check mo yung conc. Slab at footing .
can you also show the proper computation when you derived to .22 cu.m because i derived to 10.78.., please im interested to get the computation. thank you
Can I answer your req pls
1 divided by the sum of ratio which is 7
Answer multiply by 1.54
wow bihira to hehe ty sa effort sa excel sana may flooring din hehehe sir ask ko lang ano ang maganda pra sa bilaran ng palay? nag subscribe n pla ako ^_^
Check mo yung channel ko, andun yung concrete slab estimate.
Sir ano reference nung 27+34=61%(total voids). diba dapat mas lesser dahil iooccupy ng sand particles yung voids dun sa gravel?
sir bakit po ung nasa reference na max fajardo is 9 bags of cement ang nasa 1cubic meter at same din sa ibang reference.
very informative. but how to download your excel format?
on progress kasi construction ng dream house ko at plano ko nang magpabuhos sa suspended Slab this month may volume na 14 cu.m. Salamuch and God Bless!
tanong ko lang poh, isang truck elf na sand ilang cubic meter?
Sir yung ginamit sa column and footings namin is hindi sya crushed. Kumbaga normal gravel lang sya. Wala po bang problema doon? Sinasabi po kasi ng iba na dapat daw crushed iyon pag hindi daw guguho daw po. Salamat po sa video nyo
Ok lang basta tama ang mixture.
@@harleyasimpledesigns2806 1 2 4 po ang mixture. Isang 40kg na cement, dalawang buhangin at apat na gravel na naka sukat sa kung gaano karami ang simento sa timba. Salamat po sa reply 😊
@@filecategory6596 Gumamit ka ng kahon gaya ng binanggit ko sa video para sakto ang sukat.
@@harleyasimpledesigns2806 opo. Ayon ang ginamit nila pinakita ko po video nyo.
Boss idol, anong psi ba ang naibibigay ng 1 to 2 to 3 ratios,instead of 1,2,4 mixing ratios?
Around 3500 psi l, pero dapat consistent ang timpla at tama ang water cement ratio. Since mano mano amg mixing, assume na.langbna 3000 psi ang 1:2:3.
@@harleyasimpledesigns2806 Salamat ng marami sa pag-reply mo ng sagot. I appreciate that!
Hi, ayaw po magchange to yes nun dinownload sa cp.
That's an MS excel program so use MS excel to function properly.
hi sir, dun sa nabanggit mo na air void ng sand na 27% at gravel na 34%, hindi ba dapat di na sila iadd kasi yung dry volume na yun is yung required mix volume. so pag minix mo sand sa gravel maffill up na ng sand yung ibang void ng gravel so dapat di sila iadd kasi mababawasan pa nga dapat yung air void ng mix for 1 cu.m. diba malaki masyado yung 61% na void para sa 1 cu.m na sand-gravel mix?
Binanggit kobyan sa video. Panoorin mo ng buo para malaman mo.
Boss can you help. I have a 70L cement mixer. How do i get the 1:2:3 ratio since it can only accomodate 1 bag at a time. Please help.
70L? ang liit nyan boss. d kasya yung 1:2:3 dyan.
at least 250L capacity kelangan mo if 1 bag per batch gusto mo.
sa 70L eh 1/4 bag per batch ka nalang.
Hello po Sir. Any recommended books regarding sa mga concrete? Preferably, follows Philippines std? Ty po in advance
Sir may tanong lang ako halimbawa 2 sako na cemento lang ang gagamitin ko tapus mixture na gagamitin ko ay 123. diba ang racio ng cemento sir ay 9 bags of cement sa 123 na paano na na sir ma computation ng cement hindi na gagamitan ng 9 bags of cement sir? Anong racio ang gagamitin sir?
Sir kaya ba ng mix 124 para sa footing;column;slab para sa two storey house?
meron karin ba sa hollow block at ratio ng cement, sand and gravel
boss ang ginagamit kupo ganito yong kahon po ang sukat ng kahon .3048x.3048x.3048=.028×3=•085 ang gravel at ang sand po naman ay .3048x.3048x.3048=.0566 sand sa isang bag na cemento tamo po bayon pakisagot lang po salamat
hey sir, what is your basis of testing? is 3000psi with your mentioned ratio which is 124 fall to cube testing or cylinder test? please clarify.
I answered that on Rufino's comment. Please check the comments.
Bakit lods sobrang layo ng sagot kapag yung libro ni max fajardo yung gamit sa pagkumpyut ng semento, sand at gravel?
Based on Max Fajardo book:
1:2:4 concrete mixture ----- 9 (40kg) cement , 0.50 cu m. sand at 1 cu.m gravel. In which the book didn't state that it's equivalent to 1 cu.m. dry volume of concrete.
Based on the sample problems in the book, the actual concrete volumes (wet volumes, concrete is composed of cement, sand gravel and water) were just multiplied by the constant/multiplier of that mixture. I didn't find any dry volume in Max Fajardos book. Maybe the dry volume factor was already included in the multiplier.
If you are in construction, try to verify the ratio and test it.
Ok lods
Pero kung icocompare yung computation mo sa libro ni max fajardo....
Mas accurate ba sayo lods?
paano po naging 1.54 yung 54% para sa air voids? thanks
Hello Sir...ask ko lng kung saan mo nkuha ung 1.54 na constant... thanks..
Sir may tanong lang ako saan kinuha ang ratio ng cement na 12 at 9
Ang formula na yan ay ginagamit ng mga Idian engineer kinukuha nila ang wet at dry volumn.
Hi Sir, hindi ko po ma-edit out yung sa Question kaya hindi po ako makapag Type ng YES.
Kasusubok ko lang at ok naman.
@@harleyasimpledesigns2806 YES sir. Okay na po
Sir ano pong ideal ratio ng concrete para sa mga sink countertop? Hoping to get a response. Thank you!
1:2:3, 3000 psi.
sir tanung ko lang sa isang LF na truck ilang cum ang isang ganun
subscribe matik, very informative
maraming salamat 🙇
Bro. Is it 1.54 or .54? How did you get 1.54 that you use in getting dry volume?
It's stated in the video.
@@harleyasimpledesigns2806 Is your method of computing more accurate than what Fajardo suggests in his book? Anyway, I'm just puzzled how 1.54 arises from the percentages you cited. Thank anyway.
What if banday banda sir ang ginamit? 1:6 cement ratio... May estimate po ba kung ilang Psi lalabas? Thanks sir
boss, ask ko if applicable ba ang 1:2:4 mixture para sa tulay sa drainage ( 1.50m Length)?
1:2:3. 200mm thick slab w/ 16mm top and bottom bars at 200mm o.c. , 12mm top and bottom temp bars at 12mm o.c.
Hi Harley, ano usually concrete class ng slab above ground?For example second storey. Tia
Minimum concrete strength is 3000 psi. Kung manual mixing ay 1:2:3 with 1: 0.50 to 0..55 cement water ratio, Pwedeng 1:2:4 kung me quality control. We usually specity compressive stength of concrete and not the class,.
How about po sa plastering paano computation kung Ilan bags of cement klangan per wall
Check my latest video.
Hindi ko ma download Yong excel file @HarleyA Simple Design
Hi! Hindi ba 2175 psi lang ang 1:2:4 concrete mix ratio? So pag ito yung ginamit na ratio, underdesigned na yung structure na gagawin lalo kung kailangan 3000 psi talaga?
Kung me quality control, pwede mong maachieve ang 3000 psi conc. strenght. Nakapag compressive test na kami nyan. Pero for safety at lalo na pag mano mano, 1:2:3 ang gamitin mo lalo na't hindi nasusunod ang water-cement ratio.
@@harleyasimpledesigns2806 Hmm.. kung may quality control, maaabot na yung 3000 psi gamit itong mix na ito? O ibang mix ratio na ang gagamitin? Yung wet volume nga pala, yun yung volume na may tubig na. O kaya naman ay yung volume nung pagbubuhusan ng concrete (kaya naging equivalent sa "actual volume"). Sabi mo kasi sa 3:51, yun yung wala pang halong tubig.
Paano e halo yan sa actual?
Sayang di pwede sa CP itong apps. Salamat po sa knowledge sir
Pwede yan sa ms excel
is this applicable po ba sa CHB po if ganyang mixture ang gagawin?
pwede: 1cement:3 sand
Sir bale ilang bag ng gravel at sand yung equivalent para sa 1 cu.m?
Panoorin mo yung video, naexplain dun.
Good day po, paano po mag compute kung ilang kg of cement, sand, and gravel po para sa concrete cylinder samples.
panooring mo buo yung video.
Napanood ko po ng buo kaso triny ko mag compute n2kg cement, 4kg sand, 7kg gravel nakuha ko sa isang cylinder. Hindi ko alam tama ba to sir.
@@zorojuro-- Dalawang method ang pagcompute sa concrete mix. Ito ay by volume and by weight. Ginamit sa video ay by volume. download mo yung excel formula, input mo lang yung cylinder volume then ibibigay sayo yung volume cement, sand ang gravel. timbangin mo yung volume for each components.
@@harleyasimpledesigns2806 Okay po, paano naman po pag compute by weight po sir?