{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["C-1-1型","C-1-2型","Sheet3"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"C-1-1型","index":0,"n_rows":78,"n_cols":7,"rows_kept":78,"merged":[[0,0,0,6],[1,4,1,6],[2,1,2,6],[3,1,3,6],[15,1,15,6],[21,1,21,6],[30,1,30,6],[33,1,33,6],[55,1,55,6],[65,1,65,6],[75,1,75,6],[77,0,78,0],[77,1,78,6]],"flags":["formulas_cached_only"]}
["路面计算书"]
[null,"项目名称：屈原至汨罗公路"]
["项目概述及\n路面结构说明","        屈汨公路属平微二级公路，路面宽为9m，土路肩（一侧）宽1.5m；自然区划为Ⅴ3区，项目沿线砂砾石、水泥丰富，故推荐采用水泥砼路面结构，设计使用年限为30年。据交通量分析和轴载谱调查计算其设计使用年限内标准轴载累计作用次数为125085934次。路面结构面层采用24cm普通砼，基层采用15cm6%水泥稳定砂砾，底基层为15cm4%水泥稳定砂砾。面板尺寸为长5m，宽4.5m，纵缝为设拉杆平缝，横缝为设传力杆缩缝。本结构适用于路基干燥中湿路段。"]
["一","计算路基基顶当量回弹模量及砼面层相对刚度半径输入数据"]
[1,"普通砼面层弯拉弹性模量Ec（MPa）","=",31000]
[2,"面层厚度h（m）","=",0.24]
[]
[3,"基层材料回弹模量E1（MPa）","=",1500]
[4,"基层厚度h1（m）","=",0.15]
[]
[5,"底基层材料回弹模量E2（MPa）","=",1300]
[6,"底基层厚度h2（m）","=",0.15]
[]
[7,"土基回弹模量E0（MPa）","=",50]
[]
["二","计算荷载疲劳应力输入数据"]
[1,"接缝传荷能力的应力折减系数kr","=",0.87]
[2,"综合系数kc","=",1.2]
[3,"设计基准期内标准轴载累计作用次数Ne(次）","=",125085934]
[4,"计算荷载疲劳应力系数v","=",0.057]
[]
["三","计算温度疲劳应力输入数据"]
[1,"温度梯度值Tg（°C/m）","=",87]
[2,"板长L（m）","=",5,"L/r","=",{"v":7.75495128916993,"d":"7.75"}]
[3,"由图B.2.2根据砼面板厚h及L/r查得温度应力系数Bx","=",0.64]
[4,"面层砼弯拉强度标准值fr（MPa）","=",5]
[5,"回归系数a","=",0.841]
[6,"回归系数b","=",0.058]
[7,"回归系数c","=",1.323]
[]
["四","计算极限状态输入数据"]
[1,"可靠度系数Rr","=",1.13]
[]
["一","新建公路的基顶当量回弹模量及面层相对刚度半径计算"]
[null,"Ex","=","(h12*E1+h22*E2)/(h12+h12)"]
[null,null,"=",{"v":1400,"d":"1400.00"}]
[]
[null,"Dx","=","(E1*h13+E2*h23)/12+((h1+h1)2/4)*(1/(E1*h1)+1/(E2*h2))-1"]
[null,null,"=",{"v":3.1379464285714285,"d":"3.14"}]
[]
[null,"hx","=","(12*Dx/Ex)^(1/3)"]
[null,null,"=",{"v":0.2996168578206564,"d":"0.30"}]
[]
[null,"a","=","6.22*(1-1.51*(Ex/E0）-0.45）"]
[null,null,"=",{"v":4.123252094407523,"d":"4.12"}]
[]
[null,"b","=","1-1.44*(Ex/E0）-0.45"]
[null,null,"=",{"v":0.7696301843044218,"d":"0.77"}]
[]
[null,"基层顶面当面回弹模量Et","=","a*hxb*E0*(Ex/E0)1/3"]
[null,null,"=",{"v":247.59706130073116,"d":"247.60"}]
[]
[null,"普通砼面层的相对刚度半径r","=","0.537*h*(Ec/Et)(1/3)"]
[null,null,"=",{"v":0.6447493754064814,"d":"0.645"}]
[]
["二","荷载疲劳应力计算"]
[null,"荷载应力σps","=","0.077*r0.6*h-2"]
[null,null,"=",{"v":1.0273130376873107,"d":"1.03"}]
[]
[null,"疲劳应力系数kf","=","Nev"]
[null,null,"=",{"v":2.894282262868078,"d":"2.894"}]
[]
[null,"荷载疲劳应力σpr","=","kr*kf*kc*σps"]
[null,null,"=",{"v":3.104160595140735,"d":"3.10"}]
[]
["三","温度疲劳应力计算"]
[null,"温度翘曲应力σtm","=","αc*Ec*h*Tg*Bx/2"]
[null,null,"=",{"v":2.071296,"d":"2.07"}]
[]
[null,"温度疲劳应力系数kt","=","(fr/σtm)*(a*(σtm/fr)c-b)"]
[null,null,"=",{"v":0.49265763442050065,"d":"0.493"}]
[]
[null,"温度疲劳应力σtr","=","kt*σtm"]
[null,null,"=",{"v":1.0204397875446451,"d":"1.02"}]
[]
["四","极限状态计算"]
[null,"Rr*（σpr+σtr）","=",{"v":4.660798432434479,"d":"4.66"}]
["结论","综合疲劳应力小于面层砼弯拉标准强度值，能够满足使用要求"]

{"sheet":"C-1-2型","index":1,"n_rows":78,"n_cols":7,"rows_kept":78,"merged":[[0,0,0,6],[1,4,1,6],[2,1,2,6],[3,1,3,6],[15,1,15,6],[21,1,21,6],[30,1,30,6],[33,1,33,6],[55,1,55,6],[65,1,65,6],[75,1,75,6],[77,0,78,0],[77,1,78,6]],"flags":["formulas_cached_only"]}
["路面计算书（C-1-2型）"]
[null,"项目名称：东安至冷水滩公路"]
["项目概述及\n路面结构说明","        东冷路属平微二级公路，路面宽为9m，土路肩（一侧）宽1.5m（其中K0+000-K9+208为山岭重丘二级公路，路面宽7.5m，土路肩（一侧）宽为0.5m）；自然区划为Ⅵ6区，项目沿线石料水泥丰富，故推荐采用水泥砼路面结构，设计使用年限为30年。交通分析据工可其设计使用年限内标准轴载作用次数为4287985次。路面结构面层采用24cm普通砼，基层采用20cm5%水泥稳定碎石，垫层为20cm级配碎石。面板尺寸为长5m，宽4.5m，纵缝为设拉杆平缝，横缝为设传力杆缩缝，结构图见《路面结构图》中“C-1-2”型。本结构适用于路基较潮湿路段。"]
["一","计算路基基顶当量回弹模量及砼面层相对刚度半径输入数据"]
[1,"普通砼面层弯拉弹性模量Ec（MPa）","=",31000]
[2,"面层厚度h（m）","=",0.24]
[]
[3,"基层材料回弹模量E1（MPa）","=",1300]
[4,"基层厚度h1（m）","=",0.2]
[]
[5,"底基层材料回弹模量E2（MPa）","=",200]
[6,"底基层厚度h2（m）","=",0.2]
[]
[7,"土基回弹模量E0（MPa）","=",30]
[]
["二","计算荷载疲劳应力输入数据"]
[1,"接缝传荷能力的应力折减系数kr","=",0.9]
[2,"综合系数kc","=",1.2]
[3,"设计基准期内标准轴载累计作用次数Ne(次）","=",4287985]
[4,"计算荷载疲劳应力系数v","=",0.057]
[]
["三","计算温度疲劳应力输入数据"]
[1,"温度梯度值Tg（°C/m）","=",92]
[2,"板长L（m）","=",5,"L/r","=",6.631441721124201]
[3,"由图B.2.2根据砼面板厚h及L/r查得温度应力系数Bx","=",0.64]
[4,"面层砼弯拉强度标准值fr（MPa）","=",5]
[5,"回归系数a","=",0.841]
[6,"回归系数b","=",0.058]
[7,"回归系数c","=",1.323]
[]
["四","计算极限状态输入数据"]
[1,"可靠度系数Rr","=",1.13]
[]
["一","新建公路的基顶当量回弹模量及面层相对刚度半径计算"]
[null,"Ex","=","(h12*E1+h22*E2)/(h12+h12)"]
[null,null,"=",749.9999999999999]
[]
[null,"Dx","=","(E1*h13+E2*h23)/12+((h1+h1)2/4)*(1/(E1*h1)+1/(E2*h2))-1"]
[null,null,"=",2.386666666666667]
[]
[null,"hx","=","(12*Dx/Ex)^(1/3)"]
[null,null,"=",0.3367471406271519]
[]
[null,"a","=","6.22*(1-1.51*(Ex/E0）-0.45）"]
[null,null,"=",4.013548792545742]
[]
[null,"b","=","1-1.44*(Ex/E0）-0.45"]
[null,null,"=",0.754814102314014]
[]
[null,"基层顶面当面回弹模量Et","=","a*hxb*E0*(Ex/E0)1/3"]
[null,null,"=",154.821808032875]
[]
[null,"普通砼面层的相对刚度半径r","=","0.537*h*(Ec/Et)(1/3)"]
[null,null,"=",0.7539838560403379]
[]
["二","荷载疲劳应力计算"]
[null,"荷载应力σps","=","0.077*r0.6*h-2"]
[null,null,"=",1.1284581825169213]
[]
[null,"疲劳应力系数kf","=","Nev"]
[null,null,"=",2.388022616937267]
[]
[null,"荷载疲劳应力σpr","=","kr*kf*kc*σps"]
[null,null,"=",2.910366355087797]
[]
["三","温度疲劳应力计算"]
[null,"温度翘曲应力σtm","=","αc*Ec*h*Tg*Bx/2"]
[null,null,"=",2.190336]
[]
[null,"温度疲劳应力系数kt","=","(fr/σtm)*(a*(σtm/fr)c-b)"]
[null,null,"=",0.511789739973686]
[]
[null,"温度疲劳应力σtr","=","kt*σtm"]
[null,null,"=",1.1209914918950035]
[]
["四","极限状态计算"]
[null,"Rr*（σpr+σtr）","=",4.555434367090564]
["结论","综合疲劳应力小于面层砼弯拉标准强度值，能够满足使用要求"]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}