U型渠道砼板工程量计算

孤14钭14孤14钭11钭14钭11规格(半径CM)渠口宽(CM)渠深(CM)渠口宽(CM)渠深(CM)孤长(5CM)体积(5CM)1030.593028.12300.640.03221543.384040.24400.900.04512053.694550.41451.160.05802564.005057.47421.420.07083076.806068.81501.670.08374097.417093.05702.190.109550120.5185114.17822.700.135260143.62100137.631003.220.1610103028.833034.83154033.214039.39205547.635556.80256041.986048.50307250.387258.194010075.2010087.885012083.9712096.9960150112.79150131.82B2==(A3*SIN(RADIANS(76))+(C3-A3+A3*SIN(RADIANS(14)))*TAN(RADIANS(14)))*2&"宋体,加粗"&18砼单板体积计算表半径R(CM)渠深H(CM)板厚B(CM)弧M14/钭N14弧M14/钭N11延米量(14/14)千米量(缝5CM)15405.00000.04820.04500.0964175.230520455.00000.05610.05790.1121203.881025505.00000.06390.07080.1279232.531530605.00000.07700.08360.1540279.920540705.00000.09270.10930.1855337.221550855.00000.11360.13510.2273413.2610601005.00000.13460.16080.2691489.300415404.00000.03870.03500.0775140.890520454.00000.04500.04530.0901163.810925504.00000.05140.05560.1027186.731330606.00000.09210.10190.1842334.845440705.00000.09270.10930.1855337.221550856.00000.13610.16360.2722494.8540601006.00000.16120.19450.3224586.1013砼体积=板中心线长*板厚板中心线长=钭长*2+弧长钭长=h/cos(N);h=Rsin(M)+R=R(1+sin(M))弧长=2Rл*(180-M8*2)/360砼体积=2R((1+sin(M))/cos(N)+л*(180-M*2)/360)半径R(CM)渠深H(CM)板厚B(CM)h=R(1+sin(M))钭长=h/cos(N)弧长=2Rл*152/360板中心线长砼体积=板中心线长*板厚/2(不包台帽)砼台帽(宽10cm)砼总体积(单块板)C20衬砌板量/KM(缝5CM)C20细石砼量/KM204550.27940.28800.59691.17290.02930.002750.0320758.345.867255050.29150.30050.72951.33050.03330.002750.0360165.506.656306050.35360.36450.86221.59110.03980.002750.0425377.367.959407060.37400.38551.14071.91170.05740.002750.06010109.3213.771508560.44820.46191.40602.32990.06990.002750.07265132.1516.7846010060.52240.53841.67132.74810.08240.002750.08519154.9719.7967512070.60490.62342.08253.32940.11650.002750.11928216.9732.644508560.44820.46191.40602.32990.06990.002750.07265132.1516.7846010060.52240.53841.67132.74810.08240.002750.08519154.9719.796154040.27110.27940.45101.00980.02020.002750.0229541.743.233204540.28320.29190.58361.16740.02330.002750.0261047.473.738255050.29150.30050.72951.33050.03330.002750.0360165.506.656306050.35360.36450.86221.59110.03980.002750.0425377.367.959407060.37400.38551.14071.91170.05740.002750.06010109.3213.771508550.45200.46581.39282.32450.05810.002750.06086110.7111.6287512070.60490.62342.08253.32940.11650.002750.11928216.9732.644砼体积=板中心线长*板厚板中心线长=钭长*2+弧长;h=Rsin(M)+R=R(1+sin(M))弧长=2Rл*(180-M8*2)/360砼体积=2R((1+sin(M))/cos(N)+л*(180-M*2)/360)半径R渠深H板厚B口宽H1内H2内L1内H1外H2外L1外内面积外面积砼面积砼量/块砼量/KM(5)砼量差差比定额量(+5%)/块定额量/米板厚增加1CM量增加比厚增加比量厚比差15405430.0360.2500.0010.0480.2500.0010.1460.1990.05330.026748.4982-0.0027-9.07%0.02800.056020455540.0480.2500.0010.0600.2500.0010.2000.2610.06120.030655.6644-0.0027-8.00%0.03210.06430.008314.78%20.00%-5.22%2550564.000.0600.2500.0010.0730.2500.0010.2620.3310.06910.034562.8306-0.0052-13.16%0.03630.072530605770.0730.3000.0010.0850.3000.0010.3770.4590.08210.041174.6800-0.0163-28.41%0.04310.08620.013718.86%20.00%-1.14%40706970.0970.3000.0010.1110.3000.0010.5510.6700.11840.0592107.6748-0.0232-28.20%0.06220.1243508561210.1210.3500.0010.1350.3500.0010.8260.9690.14350.0717130.49360.00182.63%0.07530.15070.026321.19%16.67%4.53%6010061440.1450.4000.0010.1600.4000.0011.1561.3240.16860.0843153.31240.00182.23%0.08850.17707512071770.1810.4500.0020.1980.4500.0021.7031.9410.23810.1190216.52230.0988489.37%0.12500.25000.073041.23%16.67%24.56%40805102.400.0970.4000.0010.1090.4000.0010.6710.7790.10820.054198.37890.0307131.64%0.05680.11364070697.410.0970.3000.0010.1110.3000.0010.5510.6700.11840.0592107.67480.025977.97%0.06220.12430.01079.45%20.00%-10.55%50855120.510.1210.3500.0010.1330.3500.0010.8260.9450.11880.0594108.02800.019649.30%0.06240.124750856120.510.1210.3500.0010.1350.3500.0010.8260.9690.14350.0717130.49360.014425.09%0.07530.15070.025920.80%20.00%0.80%601006143.620.1450.4000.0010.1600.4000.0011.1561.3240.16860.0843153.31240.026245.04%0.08850.1770751206186.960.1810.4500.0020.1960.4500.0021.7561.9600.20380.1019185.3861-0.0146-12.54%0.10700.21400.037020.92%16.67%4.25%砼体积=(外面积-内面积)*板厚14/14外内面积=S1+2S2+S3+2S4S1=ЛR*R*152/360;S2=(H1+H2)*L1/2;S3=(L-2L1)*H2;S4=(L-2L1)/2*H1口宽=(R*SIN(RADIANS(76))+(B-R+R*SIN(RADIANS(14)))*TAN(RADIANS(14)))*2半径R渠深H板厚B口宽H1内H2内L1内H1外H2外L1外内面积外面积砼面积砼量/块砼量/KM(5)砼量差差比定额量(+5%)/块定额量/米板厚增加1CM量增加比厚增加比量厚比差30604.50730.0730.3000.0010.0830.3000.0010.3650.4380.07330.036766.70160.0367#DIV/0!0.03850.077020455540.0480.2500.0010.0600.2500.0010.2000.2610.06120.030655.66440.0306#DIV/0!0.03210.0643-0.0127-16.55%22.22%-38.77%2550564.000.0600.2500.0010.0730.2500.0010.2620.3310.06910.034562.83060.0345#DIV/0!0.03630.072530605770.0730.3000.0010.0850.3000.0010.3770.4590.08210.041174.68000.0411#DIV/0!0.04310.08620.013718.86%20.00%-1.14%40706970.0970.3000.0010.1110.3000.0010.5510.6700.11840.0592107.67480.0592#DIV/0!0.06220.1243508561210.1210.3500.0010.1350.3500.0010.8260.9690.14350.0717130.49360.0717#DIV/0!0.07530.15070.026321.19%16.67%4.53%6010061440.1450.4000.0010.1600.4000.0011.1561.3240.16860.0843153.31240.0843#DIV/0!0.08850.17707512071770.1810.4500.0020.1980.4500.0021.7031.9410.23810.1190216.52230.1190#DIV/0!0.12500.25000.073041.23%16.67%24.56%40805102.400.0970.4000.0010.1090.4000.0010.6710.7790.10820.054198.37890.0541#DIV/0!0.05680.11364070697.410.0970.3000.0010.1110.3000.0010.5510.6700.11840.0592107.67480.0592#DIV/0!0.06220.12430.01079.45%20.00%-10.55%50855120.510.1210.3500.0010.1330.3500.0010.8260.9450.11880.0594108.02800.0594#DIV/0!0.06240.124750856120.510.1210.3500.0010.1350.3500.0010.8260.9690.14350.0717130.49360.0717#DIV/0!0.07530.15070.025920.80%20.00%0.80%601006143.620.1450.4000.0010.1600.4000.0011.1561.3240.16860.0843153.31240.0843#DIV/0!0.08850.1770751206186.960.1810.4500.0020.1960.4500.0021.7561.9600.20380.1019185.38610.1019#DIV/0!0.10700.21400.037020.92%16.67%4.25%