灌砂法测压实度自动计算表

灌砂随机数 标准 excel标准偏差excel标准偏差函数exl标准差函数国标检验抽样标准表免费下载红头文件格式标准下载 砂密度1.42最大干密度1.96最优含水率13.5土的颗粒密度123456789101112序号密度测定器灌满标准砂总质量灌满灌砂漏斗所需标准砂质量密度测定器和剩余标准砂总质量灌满试坑所用标准砂质量试坑体积土和容器总质量容器质量试坑土的质量土的湿密度土的含水率土的干密度压实系数规定值实测值18200112339033174223546411546262.0712.11.846≥900.94228200112338743203225645831545682.0312.31.8040.92038200112339153162222745911545762.0512.51.8260.93248200112339263151221946021545872.0712.51.8370.93758200112339223155222245581545432.0413.41.8030.92068200112338643213226345671545522.0112.51.7880.91278200112338663211226245911545762.0212.11.8040.92188200112339263151221946271546122.0812.61.8460.94298200112339083169223245871545722.0513.21.8090.923108200112339143163222746561546412.0813.61.8330.935118200112339103167223045931545782.0513.71.8050.921128200112339093168223146441546292.0713.81.8240.931灌砂随机数标准砂密度1.42最大干密度1.81最优含水率13.4土的颗粒密度123456789101112序号密度测定器灌满标准砂总质量灌满灌砂漏斗所需标准砂质量密度测定器和剩余标准砂总质量灌满试坑所用标准砂质量试坑体积土和容器总质量容器质量试坑土的质量土的湿密度土的含水率土的干密度压实系数规定值实测值18200113038603210226046601046502.0613.101.82≥90100.63210.00028200113038453225227046101046002.0313.601.7998.938200113038653205225546201046102.0413.301.8099.448200113038253245228547001046902.0514.301.7998.958200113038053265230046901046802.0313.701.7998.968200113038303240228047501047402.0813.101.84101.778200113038153255229047501047402.0713.601.82100.688200113038353235228046201046102.0213.001.7998.998200113038553215226545901045802.0213.801.7898.3108200113038203250229046201046102.0114.301.7697.2118200113038603210226046601046502.0612.701.83101.1128200113038653205225547501047402.1012.801.86102.8灌砂随机数标准砂密度1.42最大干密度1.8最优含水率12.1土的颗粒密度123456789101112序号密度测定器灌满标准砂总质量灌满灌砂漏斗所需标准砂质量密度测定器和剩余标准砂总质量灌满试坑所用标准砂质量试坑体积土和容器总质量容器质量试坑土的质量土的湿密度土的含水率土的干密度压实系数规定值实测值18300113039303240228043201043101.8912.801.68≥9093.33240.00028300113039203250229042901042801.8714.201.6491.138300113039203250229042401042301.8513.401.6390.648300113039403230227542501042401.8613.301.6491.158300113039503220227042601042501.8713.901.6491.168300113039403230227543301043201.9014.001.6792.878300113039303240228042101042001.8413.901.6290.088300113039403230227543201043101.8912.901.6792.898300113039253245228543401043301.8913.501.6792.8108300113039203250229042701042601.8613.701.6491.1118300113039203250229043001042901.8713.901.6491.1128300113039153255229042201042101.8414.301.6189.4灌砂随机数标准砂密度1.42最大干密度1.8最优含水率12.1土的颗粒密度123456789101112序号密度测定器灌满标准砂总质量灌满灌砂漏斗所需标准砂质量密度测定器和剩余标准砂总质量灌满试坑所用标准砂质量试坑体积土和容器总质量容器质量试坑土的质量土的湿密度土的含水率土的干密度压实系数规定值实测值18400113040003270230547401047302.0513.531.81≥90100.63270.00028400113039753295232047601047502.0512.951.81100.638400113039453325234045901045801.9612.901.7496.748400113039953275230546601046502.0213.591.7898.958400113039803290231545901045801.9812.851.7597.268400113039453325234046901046802.0013.161.7798.378400113039503320234046501046401.9813.011.7597.288400113040003270230547201047102.0414.311.7898.998400113039953275230546401046302.0113.981.7697.8108400113039753295232046501046402.0014.221.7597.2118400113039553315233546501046401.9914.131.7496.7128400113039953275230547501047402.0614.191.80100.0灌砂随机数标准砂密度1.42最大干密度1.79最优含水率13.4土的颗粒密度12345678910.01112序号密度测定器灌满标准砂总质量灌满灌砂漏斗所需标准砂质量密度测定器和剩余标准砂总质量灌满试坑所用标准砂质量试坑体积土和容器总质量容器质量试坑土的质量土的湿密度土的含水率土的干密度压实系数规定值实测值18500113040703300232543601043501.8713.41.65≥9092.23300.00028500113040703300232542801042701.8413.81.6290.538500113040653305232542901042801.8413.91.6290.548500113040853285231544201044101.9012.81.6893.958500113040603310233043001042901.8412.91.6391.168500113040803290231543801043701.8913.31.6793.378500113040603310233043001042901.8412.81.6391.188500113040653305232543101043001.8513.31.6391.198500113040503320234043301043201.8514.11.6290.5108500113040503320234043601043501.8613.11.6491.6118500113041053265230044001043901.9113.11.6994.4128500113040703300232543001042901.8513.91.6290.5灌砂随机数标准砂密度1.42最大干密度1.79最优含水率13.5土的颗粒密度123456789101112序号密度测定器灌满标准砂总质量灌满灌砂漏斗所需标准砂质量密度测定器和剩余标准砂总质量灌满试坑所用标准砂质量试坑体积土和容器总质量容器质量试坑土的质量土的湿密度土的含水率土的干密度压实系数规定值实测值18600113041903280231043301043201.8713.791.64≥9091.63280.00028600113042203250229044201044101.9312.911.7195.538600113041603310233044301044201.9013.631.6793.348600113041753295232043901043801.8913.101.6793.358600113042253245228544001043901.9213.221.7095.068600113042153255229042801042701.8613.881.6391.178600113042253245228543101043001.8814.241.6592.288600113042003270230544301044201.9213.311.6994.498600113042103260229543501043401.8913.101.6793.3108600113042003270230544301044201.9213.001.7095.0118600113042003270230544401044301.9213.171.7095.0128600113042303240228044701044601.9613.611.7396.6灌砂随机数标准砂密度1.42最大干密度1.81最优含水率13.4土的颗粒密度123456789101112序号密度测定器灌满标准砂总质量灌满灌砂漏斗所需标准砂质量密度测定器和剩余标准砂总质量灌满试坑所用标准砂质量试坑体积土和容器总质量容器质量试坑土的质量土的湿密度土的含水率土的干密度压实系数规定值实测值18700113042953275230545001044901.9513.711.71≥9094.53280.00028700113042453325234043701043601.8613.831.6390.138700113042703300232543501043401.8713.761.6490.648700113042753295232045401045301.9513.341.7295.058700113042953275230543701043601.8913.331.6792.368700113043003270230544701044601.9312.731.7194.578700113042503320234044201044101.8814.011.6591.288700113042653305232542801042701.8413.361.6289.598700113043053265230043901043801.9013.001.6892.8108700113042453325234044101044001.8813.541.6691.7118700113042753295232043801043701.8813.291.6691.7128700113042553315233545401045301.9412.941.7295.0