*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
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
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 ...
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
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🌋
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!
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
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?
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
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 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
@@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.
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.
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
@@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 😊
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?
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 ^_^
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,.
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.
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
@@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.
@@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.
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.
*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
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.
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
Grabeh ang galing nyu magturo sir 💪💪napakalaking tulong po nito. Salamat po. God bless po sir!!
Thank you sir,, very big help tong excel mo para easy nalang pag calculate 😊😊
Thank you Sir & very impormative at sana marami pa kayong gagawin na formulation. God bless
Salamat po dito..TLE teacher in the making here 😁🤞
Shared Excel:Easy Life for my Lazy Life...
Charrrr😆😆
.. new subscriber here
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 ...
Thanks for sharing this lods, nakakatulong talaga ito sa project ko. God Bless you po!
Godblss to u sir sa napaka informative na blog.more power
Very informative, and made my life more easier by using the excel file.. thank sir...
salamat boss. i learn a lot. sa bakal naman po sana tranks
Thank you for this Sir.. more more calculation request ot share. thank you and more power.. Requesting for the rebars calculation . thanks.
thank you very much HarleyA Simple Designs for sharing, Godbless
Maraming salamat po Sir sa inyo.
Thanks a lot Sir very clear explanations more power to you. GOD BLESS
Salamat po sa excel file sir hehe 👍😊
Nice prgram bro. Full watch from jeddah
salamat lods... ♥️♥️♥️ very helpful...
hopefully meron din sa rebars hahaha🤣🤣
Does the cement weight varies from country to country or continent to continent?Bcz in Africa is 50kg
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
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
i would like to say super thank it helps me a lot
thanks kapatid
Soft and clear
yes makikita yang subracriber computation
Salamat po engr
Thank you Boss sa Excell nag Subscribe ako sa effort mo👍
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.
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.
thanks a lot for sharing fantastic tips
Sir ano reference nung 27+34=61%(total voids). diba dapat mas lesser dahil iooccupy ng sand particles yung voids dun sa gravel?
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!
Thank you po sir idol... Baka po meron kayo program ng para sa Labor parameters po. GB
Check mo yung conc. Slab at footing .
thanks for sharing idol.keep vlogging
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.
Very informative sir. Saan po reference nyo sa 4:28 - 5:54 regarding sa 1.54 multiplier? Thank you in advance po
Great help po ito sir. Sir may excel sheet formula din po ba sa steel bar na magagamit hehe
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?
meron karin ba sa hollow block at ratio ng cement, sand and gravel
YES, pano gamitin idol
Nakadetalye sa video kung paano gamitin ang program. PAnorin mo.
tanong ko lang poh, isang truck elf na sand ilang cubic meter?
Sir kaya ba ng mix 124 para sa footing;column;slab para sa two storey house?
GOD bless u
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
bless you for sharing your content.
Hello po Sir. Any recommended books regarding sa mga concrete? Preferably, follows Philippines std? Ty po in advance
Hello Sir...ask ko lng kung saan mo nkuha ung 1.54 na constant... thanks..
Thank you for sharing Sir. God bless.
Very good tutorials...
Sir may tanong lang ako saan kinuha ang ratio ng cement na 12 at 9
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 bakit po ung nasa reference na max fajardo is 9 bags of cement ang nasa 1cubic meter at same din sa ibang reference.
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.
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.
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.
sir tanung ko lang sa isang LF na truck ilang cum ang isang ganun
Paano din naman po para sa 4000 psi and 5000 psi..ano po pwede na design mix? Ty
Very informative new subscriber here
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.
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.
Hi, ayaw po magchange to yes nun dinownload sa cp.
That's an MS excel program so use MS excel to function properly.
bless you sir on sharing the idea.
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!
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.
Got it!....Thanks a bunch!
Got It
Sir ano pong ideal ratio ng concrete para sa mga sink countertop? Hoping to get a response. Thank you!
1:2:3, 3000 psi.
Salamat sir.
Salamat Idol!!
How about po sa plastering paano computation kung Ilan bags of cement klangan per wall
Check my latest video.
subscribed!
Subscribed! thankyou boss!
Very informative. Thank you sir !!
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,.
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
salamat sir
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
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
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.
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?
Sir bale ilang bag ng gravel at sand yung equivalent para sa 1 cu.m?
Panoorin mo yung video, naexplain dun.
Salamat idol....baka nmn pwede magtanong yung estimate ng 6×7n slab magkqnu magagastos ko pls idol
Check video description.
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.
Hello Sir.. ask ko kung saan mo nkuha ung na 1.54..tnx..
Well explained sa video kung saan nanggaling ang 1.54..
Thumps up and subscribe. Thank you sir.
Pano I downloaded Yan mga compute
is this applicable po ba sa CHB po if ganyang mixture ang gagawin?
pwede: 1cement:3 sand
Hello lodi anu gamit mo for voice recording??
Cellfone lang.
Pano po kung basa yung wash sand idol? Pano computation sa tubig?
Stock pile mo muna ng ilang oras pagkatapos kumuha ka ng buhangin sa taas. Huwag sa baba dahil yun ang basa.
What if banday banda sir ang ginamit? 1:6 cement ratio... May estimate po ba kung ilang Psi lalabas? Thanks sir
i love po
Hindi ko ma download Yong excel file @HarleyA Simple Design
GOT IT
Paano e halo yan sa actual?
pinanood ko po ng buo shared and liked. bakit po diko makita yug yes? pahelp sir
subscribe ka rin. check mo yung questions tab sa baba.