| REBAR CUTTING LIST |
|---|
| Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them. |
| Project | Two-storey residence, Lot 12 (sample) | | | | Allowance for laps / waste | | | 3% |
| Prepared by | Engr. M. Dela Cruz | | | | Default commercial length (m) | | | 6.0 |
| Date | 2026-10-19 |
|
| Bar mark | Member | Ø (mm) | Shape / notes | Cut length (m) | No. of members | Bars per member | Total pieces | Total length (m) | kg per m | Total weight (kg) | Stock length (m) | Pieces per stock bar | Stock bars to order | Offcut per bar (m) | Waste % | Stock length used |
| F1-B | Footing F1 | 16 | Straight, both ways | 1.40 | 8 | 14 | N(F8)*N(G8) | ROUND(H8*N(E8),2) | IF(N(C8)=0,"",ROUND(C8^2/162,3)) | IF(J8="",0,ROUND(I8*J8*(1+$I$3),2)) | | IF(N(E8)=0,"",IF(E8>IF(L8="",$I$4,L8),"too long",INT(IF(L8="",$I$4,L8)/E8))) | IF(OR(M8="",M8="too long"),0,ROUNDUP(H8*(1+$I$3)/M8,0)) | IF(OR(M8="",M8="too long"),"",ROUND(IF(L8="",$I$4,L8)-M8*E8,2)) | IF(OR(O8="",N(E8)=0),"",O8/IF(L8="",$I$4,L8)) | IF(N(E8)=0,"",IF(L8="",$I$4,L8)) |
| C1-V | Column C1 | 16 | Vertical with 0.40 m hook | 3.60 | 10 | 4 | N(F9)*N(G9) | ROUND(H9*N(E9),2) | IF(N(C9)=0,"",ROUND(C9^2/162,3)) | IF(J9="",0,ROUND(I9*J9*(1+$I$3),2)) | 12.0 | IF(N(E9)=0,"",IF(E9>IF(L9="",$I$4,L9),"too long",INT(IF(L9="",$I$4,L9)/E9))) | IF(OR(M9="",M9="too long"),0,ROUNDUP(H9*(1+$I$3)/M9,0)) | IF(OR(M9="",M9="too long"),"",ROUND(IF(L9="",$I$4,L9)-M9*E9,2)) | IF(OR(O9="",N(E9)=0),"",O9/IF(L9="",$I$4,L9)) | IF(N(E9)=0,"",IF(L9="",$I$4,L9)) |
| C1-T | Column C1 | 10 | Tie 0.20×0.20, 135° hooks | 0.98 | 10 | 22 | N(F10)*N(G10) | ROUND(H10*N(E10),2) | IF(N(C10)=0,"",ROUND(C10^2/162,3)) | IF(J10="",0,ROUND(I10*J10*(1+$I$3),2)) | | IF(N(E10)=0,"",IF(E10>IF(L10="",$I$4,L10),"too long",INT(IF(L10="",$I$4,L10)/E10))) | IF(OR(M10="",M10="too long"),0,ROUNDUP(H10*(1+$I$3)/M10,0)) | IF(OR(M10="",M10="too long"),"",ROUND(IF(L10="",$I$4,L10)-M10*E10,2)) | IF(OR(O10="",N(E10)=0),"",O10/IF(L10="",$I$4,L10)) | IF(N(E10)=0,"",IF(L10="",$I$4,L10)) |
| B1-T | Beam B1 | 16 | Top bars | 5.10 | 6 | 3 | N(F11)*N(G11) | ROUND(H11*N(E11),2) | IF(N(C11)=0,"",ROUND(C11^2/162,3)) | IF(J11="",0,ROUND(I11*J11*(1+$I$3),2)) | | IF(N(E11)=0,"",IF(E11>IF(L11="",$I$4,L11),"too long",INT(IF(L11="",$I$4,L11)/E11))) | IF(OR(M11="",M11="too long"),0,ROUNDUP(H11*(1+$I$3)/M11,0)) | IF(OR(M11="",M11="too long"),"",ROUND(IF(L11="",$I$4,L11)-M11*E11,2)) | IF(OR(O11="",N(E11)=0),"",O11/IF(L11="",$I$4,L11)) | IF(N(E11)=0,"",IF(L11="",$I$4,L11)) |
| B1-B | Beam B1 | 16 | Bottom bars | 4.70 | 6 | 3 | N(F12)*N(G12) | ROUND(H12*N(E12),2) | IF(N(C12)=0,"",ROUND(C12^2/162,3)) | IF(J12="",0,ROUND(I12*J12*(1+$I$3),2)) | 9.0 | IF(N(E12)=0,"",IF(E12>IF(L12="",$I$4,L12),"too long",INT(IF(L12="",$I$4,L12)/E12))) | IF(OR(M12="",M12="too long"),0,ROUNDUP(H12*(1+$I$3)/M12,0)) | IF(OR(M12="",M12="too long"),"",ROUND(IF(L12="",$I$4,L12)-M12*E12,2)) | IF(OR(O12="",N(E12)=0),"",O12/IF(L12="",$I$4,L12)) | IF(N(E12)=0,"",IF(L12="",$I$4,L12)) |
| B1-S | Beam B1 | 10 | Stirrup 0.20×0.35 | 1.18 | 6 | 26 | N(F13)*N(G13) | ROUND(H13*N(E13),2) | IF(N(C13)=0,"",ROUND(C13^2/162,3)) | IF(J13="",0,ROUND(I13*J13*(1+$I$3),2)) | | IF(N(E13)=0,"",IF(E13>IF(L13="",$I$4,L13),"too long",INT(IF(L13="",$I$4,L13)/E13))) | IF(OR(M13="",M13="too long"),0,ROUNDUP(H13*(1+$I$3)/M13,0)) | IF(OR(M13="",M13="too long"),"",ROUND(IF(L13="",$I$4,L13)-M13*E13,2)) | IF(OR(O13="",N(E13)=0),"",O13/IF(L13="",$I$4,L13)) | IF(N(E13)=0,"",IF(L13="",$I$4,L13)) |
| S1-M | Slab S1 | 12 | Main bars @ 0.15 | 3.30 | 1 | 28 | N(F14)*N(G14) | ROUND(H14*N(E14),2) | IF(N(C14)=0,"",ROUND(C14^2/162,3)) | IF(J14="",0,ROUND(I14*J14*(1+$I$3),2)) | | IF(N(E14)=0,"",IF(E14>IF(L14="",$I$4,L14),"too long",INT(IF(L14="",$I$4,L14)/E14))) | IF(OR(M14="",M14="too long"),0,ROUNDUP(H14*(1+$I$3)/M14,0)) | IF(OR(M14="",M14="too long"),"",ROUND(IF(L14="",$I$4,L14)-M14*E14,2)) | IF(OR(O14="",N(E14)=0),"",O14/IF(L14="",$I$4,L14)) | IF(N(E14)=0,"",IF(L14="",$I$4,L14)) |
| S1-T | Slab S1 | 10 | Temperature bars @ 0.25 | 4.20 | 1 | 14 | N(F15)*N(G15) | ROUND(H15*N(E15),2) | IF(N(C15)=0,"",ROUND(C15^2/162,3)) | IF(J15="",0,ROUND(I15*J15*(1+$I$3),2)) | 12.0 | IF(N(E15)=0,"",IF(E15>IF(L15="",$I$4,L15),"too long",INT(IF(L15="",$I$4,L15)/E15))) | IF(OR(M15="",M15="too long"),0,ROUNDUP(H15*(1+$I$3)/M15,0)) | IF(OR(M15="",M15="too long"),"",ROUND(IF(L15="",$I$4,L15)-M15*E15,2)) | IF(OR(O15="",N(E15)=0),"",O15/IF(L15="",$I$4,L15)) | IF(N(E15)=0,"",IF(L15="",$I$4,L15)) |
| | | | | | | N(F16)*N(G16) | ROUND(H16*N(E16),2) | IF(N(C16)=0,"",ROUND(C16^2/162,3)) | IF(J16="",0,ROUND(I16*J16*(1+$I$3),2)) | | IF(N(E16)=0,"",IF(E16>IF(L16="",$I$4,L16),"too long",INT(IF(L16="",$I$4,L16)/E16))) | IF(OR(M16="",M16="too long"),0,ROUNDUP(H16*(1+$I$3)/M16,0)) | IF(OR(M16="",M16="too long"),"",ROUND(IF(L16="",$I$4,L16)-M16*E16,2)) | IF(OR(O16="",N(E16)=0),"",O16/IF(L16="",$I$4,L16)) | IF(N(E16)=0,"",IF(L16="",$I$4,L16)) |
| | | | | | | N(F17)*N(G17) | ROUND(H17*N(E17),2) | IF(N(C17)=0,"",ROUND(C17^2/162,3)) | IF(J17="",0,ROUND(I17*J17*(1+$I$3),2)) | | IF(N(E17)=0,"",IF(E17>IF(L17="",$I$4,L17),"too long",INT(IF(L17="",$I$4,L17)/E17))) | IF(OR(M17="",M17="too long"),0,ROUNDUP(H17*(1+$I$3)/M17,0)) | IF(OR(M17="",M17="too long"),"",ROUND(IF(L17="",$I$4,L17)-M17*E17,2)) | IF(OR(O17="",N(E17)=0),"",O17/IF(L17="",$I$4,L17)) | IF(N(E17)=0,"",IF(L17="",$I$4,L17)) |
| | | | | | | N(F18)*N(G18) | ROUND(H18*N(E18),2) | IF(N(C18)=0,"",ROUND(C18^2/162,3)) | IF(J18="",0,ROUND(I18*J18*(1+$I$3),2)) | | IF(N(E18)=0,"",IF(E18>IF(L18="",$I$4,L18),"too long",INT(IF(L18="",$I$4,L18)/E18))) | IF(OR(M18="",M18="too long"),0,ROUNDUP(H18*(1+$I$3)/M18,0)) | IF(OR(M18="",M18="too long"),"",ROUND(IF(L18="",$I$4,L18)-M18*E18,2)) | IF(OR(O18="",N(E18)=0),"",O18/IF(L18="",$I$4,L18)) | IF(N(E18)=0,"",IF(L18="",$I$4,L18)) |
| | | | | | | N(F19)*N(G19) | ROUND(H19*N(E19),2) | IF(N(C19)=0,"",ROUND(C19^2/162,3)) | IF(J19="",0,ROUND(I19*J19*(1+$I$3),2)) | | IF(N(E19)=0,"",IF(E19>IF(L19="",$I$4,L19),"too long",INT(IF(L19="",$I$4,L19)/E19))) | IF(OR(M19="",M19="too long"),0,ROUNDUP(H19*(1+$I$3)/M19,0)) | IF(OR(M19="",M19="too long"),"",ROUND(IF(L19="",$I$4,L19)-M19*E19,2)) | IF(OR(O19="",N(E19)=0),"",O19/IF(L19="",$I$4,L19)) | IF(N(E19)=0,"",IF(L19="",$I$4,L19)) |
| | | | | | | N(F20)*N(G20) | ROUND(H20*N(E20),2) | IF(N(C20)=0,"",ROUND(C20^2/162,3)) | IF(J20="",0,ROUND(I20*J20*(1+$I$3),2)) | | IF(N(E20)=0,"",IF(E20>IF(L20="",$I$4,L20),"too long",INT(IF(L20="",$I$4,L20)/E20))) | IF(OR(M20="",M20="too long"),0,ROUNDUP(H20*(1+$I$3)/M20,0)) | IF(OR(M20="",M20="too long"),"",ROUND(IF(L20="",$I$4,L20)-M20*E20,2)) | IF(OR(O20="",N(E20)=0),"",O20/IF(L20="",$I$4,L20)) | IF(N(E20)=0,"",IF(L20="",$I$4,L20)) |
| | | | | | | N(F21)*N(G21) | ROUND(H21*N(E21),2) | IF(N(C21)=0,"",ROUND(C21^2/162,3)) | IF(J21="",0,ROUND(I21*J21*(1+$I$3),2)) | | IF(N(E21)=0,"",IF(E21>IF(L21="",$I$4,L21),"too long",INT(IF(L21="",$I$4,L21)/E21))) | IF(OR(M21="",M21="too long"),0,ROUNDUP(H21*(1+$I$3)/M21,0)) | IF(OR(M21="",M21="too long"),"",ROUND(IF(L21="",$I$4,L21)-M21*E21,2)) | IF(OR(O21="",N(E21)=0),"",O21/IF(L21="",$I$4,L21)) | IF(N(E21)=0,"",IF(L21="",$I$4,L21)) |
| | | | | | | N(F22)*N(G22) | ROUND(H22*N(E22),2) | IF(N(C22)=0,"",ROUND(C22^2/162,3)) | IF(J22="",0,ROUND(I22*J22*(1+$I$3),2)) | | IF(N(E22)=0,"",IF(E22>IF(L22="",$I$4,L22),"too long",INT(IF(L22="",$I$4,L22)/E22))) | IF(OR(M22="",M22="too long"),0,ROUNDUP(H22*(1+$I$3)/M22,0)) | IF(OR(M22="",M22="too long"),"",ROUND(IF(L22="",$I$4,L22)-M22*E22,2)) | IF(OR(O22="",N(E22)=0),"",O22/IF(L22="",$I$4,L22)) | IF(N(E22)=0,"",IF(L22="",$I$4,L22)) |
| | | | | | | N(F23)*N(G23) | ROUND(H23*N(E23),2) | IF(N(C23)=0,"",ROUND(C23^2/162,3)) | IF(J23="",0,ROUND(I23*J23*(1+$I$3),2)) | | IF(N(E23)=0,"",IF(E23>IF(L23="",$I$4,L23),"too long",INT(IF(L23="",$I$4,L23)/E23))) | IF(OR(M23="",M23="too long"),0,ROUNDUP(H23*(1+$I$3)/M23,0)) | IF(OR(M23="",M23="too long"),"",ROUND(IF(L23="",$I$4,L23)-M23*E23,2)) | IF(OR(O23="",N(E23)=0),"",O23/IF(L23="",$I$4,L23)) | IF(N(E23)=0,"",IF(L23="",$I$4,L23)) |
| | | | | | | N(F24)*N(G24) | ROUND(H24*N(E24),2) | IF(N(C24)=0,"",ROUND(C24^2/162,3)) | IF(J24="",0,ROUND(I24*J24*(1+$I$3),2)) | | IF(N(E24)=0,"",IF(E24>IF(L24="",$I$4,L24),"too long",INT(IF(L24="",$I$4,L24)/E24))) | IF(OR(M24="",M24="too long"),0,ROUNDUP(H24*(1+$I$3)/M24,0)) | IF(OR(M24="",M24="too long"),"",ROUND(IF(L24="",$I$4,L24)-M24*E24,2)) | IF(OR(O24="",N(E24)=0),"",O24/IF(L24="",$I$4,L24)) | IF(N(E24)=0,"",IF(L24="",$I$4,L24)) |
| | | | | | | N(F25)*N(G25) | ROUND(H25*N(E25),2) | IF(N(C25)=0,"",ROUND(C25^2/162,3)) | IF(J25="",0,ROUND(I25*J25*(1+$I$3),2)) | | IF(N(E25)=0,"",IF(E25>IF(L25="",$I$4,L25),"too long",INT(IF(L25="",$I$4,L25)/E25))) | IF(OR(M25="",M25="too long"),0,ROUNDUP(H25*(1+$I$3)/M25,0)) | IF(OR(M25="",M25="too long"),"",ROUND(IF(L25="",$I$4,L25)-M25*E25,2)) | IF(OR(O25="",N(E25)=0),"",O25/IF(L25="",$I$4,L25)) | IF(N(E25)=0,"",IF(L25="",$I$4,L25)) |
| | | | | | | N(F26)*N(G26) | ROUND(H26*N(E26),2) | IF(N(C26)=0,"",ROUND(C26^2/162,3)) | IF(J26="",0,ROUND(I26*J26*(1+$I$3),2)) | | IF(N(E26)=0,"",IF(E26>IF(L26="",$I$4,L26),"too long",INT(IF(L26="",$I$4,L26)/E26))) | IF(OR(M26="",M26="too long"),0,ROUNDUP(H26*(1+$I$3)/M26,0)) | IF(OR(M26="",M26="too long"),"",ROUND(IF(L26="",$I$4,L26)-M26*E26,2)) | IF(OR(O26="",N(E26)=0),"",O26/IF(L26="",$I$4,L26)) | IF(N(E26)=0,"",IF(L26="",$I$4,L26)) |
| | | | | | | N(F27)*N(G27) | ROUND(H27*N(E27),2) | IF(N(C27)=0,"",ROUND(C27^2/162,3)) | IF(J27="",0,ROUND(I27*J27*(1+$I$3),2)) | | IF(N(E27)=0,"",IF(E27>IF(L27="",$I$4,L27),"too long",INT(IF(L27="",$I$4,L27)/E27))) | IF(OR(M27="",M27="too long"),0,ROUNDUP(H27*(1+$I$3)/M27,0)) | IF(OR(M27="",M27="too long"),"",ROUND(IF(L27="",$I$4,L27)-M27*E27,2)) | IF(OR(O27="",N(E27)=0),"",O27/IF(L27="",$I$4,L27)) | IF(N(E27)=0,"",IF(L27="",$I$4,L27)) |
| | | | | | | N(F28)*N(G28) | ROUND(H28*N(E28),2) | IF(N(C28)=0,"",ROUND(C28^2/162,3)) | IF(J28="",0,ROUND(I28*J28*(1+$I$3),2)) | | IF(N(E28)=0,"",IF(E28>IF(L28="",$I$4,L28),"too long",INT(IF(L28="",$I$4,L28)/E28))) | IF(OR(M28="",M28="too long"),0,ROUNDUP(H28*(1+$I$3)/M28,0)) | IF(OR(M28="",M28="too long"),"",ROUND(IF(L28="",$I$4,L28)-M28*E28,2)) | IF(OR(O28="",N(E28)=0),"",O28/IF(L28="",$I$4,L28)) | IF(N(E28)=0,"",IF(L28="",$I$4,L28)) |
| | | | | | | N(F29)*N(G29) | ROUND(H29*N(E29),2) | IF(N(C29)=0,"",ROUND(C29^2/162,3)) | IF(J29="",0,ROUND(I29*J29*(1+$I$3),2)) | | IF(N(E29)=0,"",IF(E29>IF(L29="",$I$4,L29),"too long",INT(IF(L29="",$I$4,L29)/E29))) | IF(OR(M29="",M29="too long"),0,ROUNDUP(H29*(1+$I$3)/M29,0)) | IF(OR(M29="",M29="too long"),"",ROUND(IF(L29="",$I$4,L29)-M29*E29,2)) | IF(OR(O29="",N(E29)=0),"",O29/IF(L29="",$I$4,L29)) | IF(N(E29)=0,"",IF(L29="",$I$4,L29)) |
| | | | | | | N(F30)*N(G30) | ROUND(H30*N(E30),2) | IF(N(C30)=0,"",ROUND(C30^2/162,3)) | IF(J30="",0,ROUND(I30*J30*(1+$I$3),2)) | | IF(N(E30)=0,"",IF(E30>IF(L30="",$I$4,L30),"too long",INT(IF(L30="",$I$4,L30)/E30))) | IF(OR(M30="",M30="too long"),0,ROUNDUP(H30*(1+$I$3)/M30,0)) | IF(OR(M30="",M30="too long"),"",ROUND(IF(L30="",$I$4,L30)-M30*E30,2)) | IF(OR(O30="",N(E30)=0),"",O30/IF(L30="",$I$4,L30)) | IF(N(E30)=0,"",IF(L30="",$I$4,L30)) |
| | | | | | | N(F31)*N(G31) | ROUND(H31*N(E31),2) | IF(N(C31)=0,"",ROUND(C31^2/162,3)) | IF(J31="",0,ROUND(I31*J31*(1+$I$3),2)) | | IF(N(E31)=0,"",IF(E31>IF(L31="",$I$4,L31),"too long",INT(IF(L31="",$I$4,L31)/E31))) | IF(OR(M31="",M31="too long"),0,ROUNDUP(H31*(1+$I$3)/M31,0)) | IF(OR(M31="",M31="too long"),"",ROUND(IF(L31="",$I$4,L31)-M31*E31,2)) | IF(OR(O31="",N(E31)=0),"",O31/IF(L31="",$I$4,L31)) | IF(N(E31)=0,"",IF(L31="",$I$4,L31)) |
| | | | | | | N(F32)*N(G32) | ROUND(H32*N(E32),2) | IF(N(C32)=0,"",ROUND(C32^2/162,3)) | IF(J32="",0,ROUND(I32*J32*(1+$I$3),2)) | | IF(N(E32)=0,"",IF(E32>IF(L32="",$I$4,L32),"too long",INT(IF(L32="",$I$4,L32)/E32))) | IF(OR(M32="",M32="too long"),0,ROUNDUP(H32*(1+$I$3)/M32,0)) | IF(OR(M32="",M32="too long"),"",ROUND(IF(L32="",$I$4,L32)-M32*E32,2)) | IF(OR(O32="",N(E32)=0),"",O32/IF(L32="",$I$4,L32)) | IF(N(E32)=0,"",IF(L32="",$I$4,L32)) |
| | | | | | | N(F33)*N(G33) | ROUND(H33*N(E33),2) | IF(N(C33)=0,"",ROUND(C33^2/162,3)) | IF(J33="",0,ROUND(I33*J33*(1+$I$3),2)) | | IF(N(E33)=0,"",IF(E33>IF(L33="",$I$4,L33),"too long",INT(IF(L33="",$I$4,L33)/E33))) | IF(OR(M33="",M33="too long"),0,ROUNDUP(H33*(1+$I$3)/M33,0)) | IF(OR(M33="",M33="too long"),"",ROUND(IF(L33="",$I$4,L33)-M33*E33,2)) | IF(OR(O33="",N(E33)=0),"",O33/IF(L33="",$I$4,L33)) | IF(N(E33)=0,"",IF(L33="",$I$4,L33)) |
| | | | | | | N(F34)*N(G34) | ROUND(H34*N(E34),2) | IF(N(C34)=0,"",ROUND(C34^2/162,3)) | IF(J34="",0,ROUND(I34*J34*(1+$I$3),2)) | | IF(N(E34)=0,"",IF(E34>IF(L34="",$I$4,L34),"too long",INT(IF(L34="",$I$4,L34)/E34))) | IF(OR(M34="",M34="too long"),0,ROUNDUP(H34*(1+$I$3)/M34,0)) | IF(OR(M34="",M34="too long"),"",ROUND(IF(L34="",$I$4,L34)-M34*E34,2)) | IF(OR(O34="",N(E34)=0),"",O34/IF(L34="",$I$4,L34)) | IF(N(E34)=0,"",IF(L34="",$I$4,L34)) |
| | | | | | | N(F35)*N(G35) | ROUND(H35*N(E35),2) | IF(N(C35)=0,"",ROUND(C35^2/162,3)) | IF(J35="",0,ROUND(I35*J35*(1+$I$3),2)) | | IF(N(E35)=0,"",IF(E35>IF(L35="",$I$4,L35),"too long",INT(IF(L35="",$I$4,L35)/E35))) | IF(OR(M35="",M35="too long"),0,ROUNDUP(H35*(1+$I$3)/M35,0)) | IF(OR(M35="",M35="too long"),"",ROUND(IF(L35="",$I$4,L35)-M35*E35,2)) | IF(OR(O35="",N(E35)=0),"",O35/IF(L35="",$I$4,L35)) | IF(N(E35)=0,"",IF(L35="",$I$4,L35)) |
| | | | | | | N(F36)*N(G36) | ROUND(H36*N(E36),2) | IF(N(C36)=0,"",ROUND(C36^2/162,3)) | IF(J36="",0,ROUND(I36*J36*(1+$I$3),2)) | | IF(N(E36)=0,"",IF(E36>IF(L36="",$I$4,L36),"too long",INT(IF(L36="",$I$4,L36)/E36))) | IF(OR(M36="",M36="too long"),0,ROUNDUP(H36*(1+$I$3)/M36,0)) | IF(OR(M36="",M36="too long"),"",ROUND(IF(L36="",$I$4,L36)-M36*E36,2)) | IF(OR(O36="",N(E36)=0),"",O36/IF(L36="",$I$4,L36)) | IF(N(E36)=0,"",IF(L36="",$I$4,L36)) |
| | | | | | | N(F37)*N(G37) | ROUND(H37*N(E37),2) | IF(N(C37)=0,"",ROUND(C37^2/162,3)) | IF(J37="",0,ROUND(I37*J37*(1+$I$3),2)) | | IF(N(E37)=0,"",IF(E37>IF(L37="",$I$4,L37),"too long",INT(IF(L37="",$I$4,L37)/E37))) | IF(OR(M37="",M37="too long"),0,ROUNDUP(H37*(1+$I$3)/M37,0)) | IF(OR(M37="",M37="too long"),"",ROUND(IF(L37="",$I$4,L37)-M37*E37,2)) | IF(OR(O37="",N(E37)=0),"",O37/IF(L37="",$I$4,L37)) | IF(N(E37)=0,"",IF(L37="",$I$4,L37)) |
| | | | | | | N(F38)*N(G38) | ROUND(H38*N(E38),2) | IF(N(C38)=0,"",ROUND(C38^2/162,3)) | IF(J38="",0,ROUND(I38*J38*(1+$I$3),2)) | | IF(N(E38)=0,"",IF(E38>IF(L38="",$I$4,L38),"too long",INT(IF(L38="",$I$4,L38)/E38))) | IF(OR(M38="",M38="too long"),0,ROUNDUP(H38*(1+$I$3)/M38,0)) | IF(OR(M38="",M38="too long"),"",ROUND(IF(L38="",$I$4,L38)-M38*E38,2)) | IF(OR(O38="",N(E38)=0),"",O38/IF(L38="",$I$4,L38)) | IF(N(E38)=0,"",IF(L38="",$I$4,L38)) |
| | | | | | | N(F39)*N(G39) | ROUND(H39*N(E39),2) | IF(N(C39)=0,"",ROUND(C39^2/162,3)) | IF(J39="",0,ROUND(I39*J39*(1+$I$3),2)) | | IF(N(E39)=0,"",IF(E39>IF(L39="",$I$4,L39),"too long",INT(IF(L39="",$I$4,L39)/E39))) | IF(OR(M39="",M39="too long"),0,ROUNDUP(H39*(1+$I$3)/M39,0)) | IF(OR(M39="",M39="too long"),"",ROUND(IF(L39="",$I$4,L39)-M39*E39,2)) | IF(OR(O39="",N(E39)=0),"",O39/IF(L39="",$I$4,L39)) | IF(N(E39)=0,"",IF(L39="",$I$4,L39)) |
| | | | | | | N(F40)*N(G40) | ROUND(H40*N(E40),2) | IF(N(C40)=0,"",ROUND(C40^2/162,3)) | IF(J40="",0,ROUND(I40*J40*(1+$I$3),2)) | | IF(N(E40)=0,"",IF(E40>IF(L40="",$I$4,L40),"too long",INT(IF(L40="",$I$4,L40)/E40))) | IF(OR(M40="",M40="too long"),0,ROUNDUP(H40*(1+$I$3)/M40,0)) | IF(OR(M40="",M40="too long"),"",ROUND(IF(L40="",$I$4,L40)-M40*E40,2)) | IF(OR(O40="",N(E40)=0),"",O40/IF(L40="",$I$4,L40)) | IF(N(E40)=0,"",IF(L40="",$I$4,L40)) |
| | | | | | | N(F41)*N(G41) | ROUND(H41*N(E41),2) | IF(N(C41)=0,"",ROUND(C41^2/162,3)) | IF(J41="",0,ROUND(I41*J41*(1+$I$3),2)) | | IF(N(E41)=0,"",IF(E41>IF(L41="",$I$4,L41),"too long",INT(IF(L41="",$I$4,L41)/E41))) | IF(OR(M41="",M41="too long"),0,ROUNDUP(H41*(1+$I$3)/M41,0)) | IF(OR(M41="",M41="too long"),"",ROUND(IF(L41="",$I$4,L41)-M41*E41,2)) | IF(OR(O41="",N(E41)=0),"",O41/IF(L41="",$I$4,L41)) | IF(N(E41)=0,"",IF(L41="",$I$4,L41)) |
| | | | | | | N(F42)*N(G42) | ROUND(H42*N(E42),2) | IF(N(C42)=0,"",ROUND(C42^2/162,3)) | IF(J42="",0,ROUND(I42*J42*(1+$I$3),2)) | | IF(N(E42)=0,"",IF(E42>IF(L42="",$I$4,L42),"too long",INT(IF(L42="",$I$4,L42)/E42))) | IF(OR(M42="",M42="too long"),0,ROUNDUP(H42*(1+$I$3)/M42,0)) | IF(OR(M42="",M42="too long"),"",ROUND(IF(L42="",$I$4,L42)-M42*E42,2)) | IF(OR(O42="",N(E42)=0),"",O42/IF(L42="",$I$4,L42)) | IF(N(E42)=0,"",IF(L42="",$I$4,L42)) |
| | | | | | | N(F43)*N(G43) | ROUND(H43*N(E43),2) | IF(N(C43)=0,"",ROUND(C43^2/162,3)) | IF(J43="",0,ROUND(I43*J43*(1+$I$3),2)) | | IF(N(E43)=0,"",IF(E43>IF(L43="",$I$4,L43),"too long",INT(IF(L43="",$I$4,L43)/E43))) | IF(OR(M43="",M43="too long"),0,ROUNDUP(H43*(1+$I$3)/M43,0)) | IF(OR(M43="",M43="too long"),"",ROUND(IF(L43="",$I$4,L43)-M43*E43,2)) | IF(OR(O43="",N(E43)=0),"",O43/IF(L43="",$I$4,L43)) | IF(N(E43)=0,"",IF(L43="",$I$4,L43)) |
| | | | | | | N(F44)*N(G44) | ROUND(H44*N(E44),2) | IF(N(C44)=0,"",ROUND(C44^2/162,3)) | IF(J44="",0,ROUND(I44*J44*(1+$I$3),2)) | | IF(N(E44)=0,"",IF(E44>IF(L44="",$I$4,L44),"too long",INT(IF(L44="",$I$4,L44)/E44))) | IF(OR(M44="",M44="too long"),0,ROUNDUP(H44*(1+$I$3)/M44,0)) | IF(OR(M44="",M44="too long"),"",ROUND(IF(L44="",$I$4,L44)-M44*E44,2)) | IF(OR(O44="",N(E44)=0),"",O44/IF(L44="",$I$4,L44)) | IF(N(E44)=0,"",IF(L44="",$I$4,L44)) |
| | | | | | | N(F45)*N(G45) | ROUND(H45*N(E45),2) | IF(N(C45)=0,"",ROUND(C45^2/162,3)) | IF(J45="",0,ROUND(I45*J45*(1+$I$3),2)) | | IF(N(E45)=0,"",IF(E45>IF(L45="",$I$4,L45),"too long",INT(IF(L45="",$I$4,L45)/E45))) | IF(OR(M45="",M45="too long"),0,ROUNDUP(H45*(1+$I$3)/M45,0)) | IF(OR(M45="",M45="too long"),"",ROUND(IF(L45="",$I$4,L45)-M45*E45,2)) | IF(OR(O45="",N(E45)=0),"",O45/IF(L45="",$I$4,L45)) | IF(N(E45)=0,"",IF(L45="",$I$4,L45)) |
| | | | | | | N(F46)*N(G46) | ROUND(H46*N(E46),2) | IF(N(C46)=0,"",ROUND(C46^2/162,3)) | IF(J46="",0,ROUND(I46*J46*(1+$I$3),2)) | | IF(N(E46)=0,"",IF(E46>IF(L46="",$I$4,L46),"too long",INT(IF(L46="",$I$4,L46)/E46))) | IF(OR(M46="",M46="too long"),0,ROUNDUP(H46*(1+$I$3)/M46,0)) | IF(OR(M46="",M46="too long"),"",ROUND(IF(L46="",$I$4,L46)-M46*E46,2)) | IF(OR(O46="",N(E46)=0),"",O46/IF(L46="",$I$4,L46)) | IF(N(E46)=0,"",IF(L46="",$I$4,L46)) |
| | | | | | | N(F47)*N(G47) | ROUND(H47*N(E47),2) | IF(N(C47)=0,"",ROUND(C47^2/162,3)) | IF(J47="",0,ROUND(I47*J47*(1+$I$3),2)) | | IF(N(E47)=0,"",IF(E47>IF(L47="",$I$4,L47),"too long",INT(IF(L47="",$I$4,L47)/E47))) | IF(OR(M47="",M47="too long"),0,ROUNDUP(H47*(1+$I$3)/M47,0)) | IF(OR(M47="",M47="too long"),"",ROUND(IF(L47="",$I$4,L47)-M47*E47,2)) | IF(OR(O47="",N(E47)=0),"",O47/IF(L47="",$I$4,L47)) | IF(N(E47)=0,"",IF(L47="",$I$4,L47)) |
| TOTAL | | | | | | | SUM(H8:H47) | SUM(I8:I47) | | SUM(K8:K47) | | | SUM(N8:N47) |
|
| Weight per metre = d² ÷ 162 (d in mm), the usual site formula (e.g. Ø16 → 1.580 kg/m). Cut length includes hooks and laps you add yourself. Leave "Stock length" empty to use the default. |
| Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them. |
| © Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers. |