粗集料自动生成.xls

1、粗粗骨骨料料颗颗粒粒级级配配最最好好的的沉沉淀淀5 531.531.5筛孔37.531.526.519169.54.752.367.5kg)筛余质量(直接抄）0 02132131346134613601360195719571493149366066063563526267.6987.6982.76717.48517.66725.42219.3958.5748.2490.338分分计计筛筛余余（上上行行保保留留一一位位需需核核对对）0 02.82.817.517.517.717.725.425.419.419.48.68.68.28.20.30.3散失(1%)kg2.820.338.063.4

2、82.891.499.699.90.0080.008累累计计筛筛余余（上上行行保保留留整整数数需需核核对对）0 03 32020383863638383919110010010010000515457090 90100 951005 51010筛孔37.531.526.519169.54.752.363.2kg)筛余质量(直接抄）0 03253252592259245945971713.4523.4529.41575.08713.2972.057分分计计筛筛余余（上上行行保保留留一一位位需需核核对对）0 09.49.475.175.113.313.32.12.1散失(1%)kg9.484.59

3、7.899.90.0050.005累累计计筛筛余余（上上行行保保留留整整数数需需核核对对）0 09 985859898100100001580100 9510010102020筛孔37.531.526.519169.54.752.365kg)筛余质量(直接抄）0 034134114101410327532751291291 121215.1825.1826.58027.21063.2002.4890.0190.405分分计计筛筛余余（上上行行保保留留一一位位需需核核对对）0 06.66.627.227.263.263.22.52.50.00.00.40.4散失(1%)kg6.633.897.0

4、99.599.599.90.0050.005累累计计筛筛余余（上上行行保保留留整整数数需需核核对对）0 07 734349797100100100100100100001585100 95100161631.531.5筛孔37.531.526.519169.54.752.367.5kg)筛余质量(直接抄）0 049449440204020261126113253251161164 45 564647.6447.6446.46352.59034.1584.2521.5180.0520.0650.837分分计计筛筛余余（上上行行保保留留一一位位需需核核对对）0 06.56.552.652.634.

5、234.24.34.31.51.50.10.10.10.10.80.8散失(10kg）烘干后质量单单个个值值（保保留留一一位位）平平均均值值（保保留留一一位位）参参考考值值需需核核对对勿勿动动试验前取样质量（10kg）烘干后质量单单个个值值（保保留留一一位位）平平均均值值（保保留留一一位位）参参考考值值需需核核对对勿勿动动10200101460.52940.52940.60.60.54310163101500.12790.12790.10.10.12610099100390.59410.59410.59210035100240.10960.10960.1255 51010试验前取样质量（2kg

6、）烘干后质量单单个个值值（保保留留一一位位）平平均均值值（保保留留一一位位）参参考考值值需需核核对对勿勿动动试验前取样质量（10kg）烘干后质量单单个个值值（保保留留一一位位）平平均均值值（保保留留一一位位）参参考考值值需需核核对对勿勿动动207320620.53060.53060.50.50.526208820880.00000.00000.00.00.068206020500.48540.48540.536203620360.00000.00000.07110102020试验前取样质量（6kg）烘干后质量单单个个值值（保保留留一一位位）平平均均值值（保保留留一一位位）参参考考值值需需核核对

7、对勿勿动动试验前取样质量（10kg）烘干后质量单单个个值值（保保留留一一位位）平平均均值值（保保留留一一位位）参参考考值值需需核核对对勿勿动动611460810.53970.53970.60.60.560608560760.14790.14790.20.20.154610160600.67200.67200.672618061700.16180.16180.173161631.531.5试验前取样质量（10kg）烘干后质量单单个个值值（保保留留一一位位）平平均均值值（保保留留一一位位）参参考考值值需需核核对对勿勿动动试验前取样质量（10kg）烘干后质量单单个个值值（保保留留一一位位）平平均均值

8、值（保保留留一一位位）参参考考值值需需核核对对勿勿动动10175101310.43240.43240.40.40.43210061100450.15900.15900.20.20.16010057100130.43750.43750.44310041100240.16930.16930.173压压碎碎值值针针片片状状（5 531.531.5）取样压碎后筛余质量压压碎碎值值（保保留留一一位位）平平均均值值（保保留留整整数数）参参考考值值需需核核对对勿勿动动烘干试样量针片颗粒总质量针针片片状状含含量量（保保留留整整数数）勿勿动动300028495.0335.0335 55.055101204784

9、.724.724.728300028664.4674.4674.703300028594.7004.7004.842表表观观密密度度（5 531.531.5）表表观观密密度度（5 531.531.5）次数试样的烘干质量吊篮在水中质量吊篮和试样在水中的m水温水温修正系数精精确确到到1010（kg/m3)kg/m3)平平均均值值参参考考 精精确确到到1010勿勿动动次数140182342758190.0042685.42685.4269026902681.41240122342757190.0042690.42690.42685.124000（国标4000g分两份）精确至5g精确至5g差不得大于2

10、02600水水温温修修正正系系数数(勿勿删删）1516171819202122232425密密度度小小的的装装不不了了4000g4000g0.0020.0030.0030.0040.0040.0050.0050.0060.0060.0070.008 紧紧密密密密度度（5 531.531.5）紧紧密密密密度度（5 531.531.5）试验次数容量筒质量m1（g）容量筒和试样总质量m2（g）容量筒的体积V（L）紧密密度c精精确确到到1010（kg/m3)kg/m3)平平均均值值参参考考 精精确确到到1010勿勿动动紧紧密密空空隙隙率率（%）取取整整数数试验次数120243554619.990167

11、6.9168016801676.737.551220243556919.9901678.140216801680试样的烘干质量吊篮在水中质量吊篮和试样在水中的m水温水温修正系数精精确确到到1010（kg/m3)kg/m3)平平均均值值参参考考 精精确确到到1010勿勿动动36542342521170.0032670.02670.0267026702668.636672342528170.0032667.82667.82665.74000精确至5g精确至5g差不得大于202600容量筒质量m1（g）容量筒和试样总质量m2（g）容量筒的体积V（L）紧密密度c 精精确确到到1010（kg/m3)kg

12、/m3)平平均均值值参参考考精精确确到到1010勿勿动动紧紧密密空空隙隙率率（%）取取整整数数20243556119.9901677.7168016801677.437.08表表观观密密度度（5 531.531.5）密密度度小小的的装装不不了了4000g4000g 紧紧密密密密度度（5 531.531.5）20243548319.9901673.840168016800.619402985序号初读数终读数弯沉值序号初读数终读数弯沉值1191148865126322086235030010052414387543524477945319416166448743996544564217051751

13、475655149105886152118685638734388750948058572322006485284868458262229669303259885921018354105014511006033829978114444038261124848012227183886254850096132482127263263228701435031570642952665815508458100655004676616375343646614210966173533226267521489641830225210068411378661951247574694784388020297269

14、567031228358211881458671353320662226622582721219454231541118673344311662414311752744544226425323293607525320890261801319876336305622722517992771831487028390346887815512462292141708879369333723019114592804904586431380353548114511462321811447482387354663347644366832522177034108835084284234100351771485

15、885211169843645542658864153875637440406688751748270383403047288328303503945742858893483137040146121509025422656415344967691405365804248644778924644141004312899589352748976441531255694513472824553048786953713259246214179709622719662472682209697487456624834029786982932469449523485769923318988505344997010035732270最小值50最大值100平均值73.6标准差14.38保证率系数1.645代表值97.26L+2*s102.36L-2*s44.84实测点数100合格点数100