标准轴载作用次数计算-excel

,,设计年限内一个车道上的累计当量轴次Ne的计算,,,,,,,

,,一、不同车型的交通参数表,,,,,,,

,,汽车车型,前轴重（KN）,后轴重（KN）,后轴数,后轴轮组数,后轴距（m）,日交通量（辆/日）,

,1,东风KM340,24.6,67.8,1,2,0,560,

,2,江淮HF150,45.1,101.2,1,2,0,460,

,3,东风SP9135B,20.1,72.6,2,2,4,368,

,4,五十铃EXR18L,60,100,3,2,4,530,

,5,江淮HF140A,18.9,41.8,1,2,0,450,

,6,五十铃NPR595G,23.5,44,1,2,0,320,

,7,三菱FR415,30,51,1,2,0,400,

,8,,,,,,,,

,,,,,,,,,,

,,,,,,,,,,

,9,,,,,,,,

,10,,,,,,,,

,,,,,,,,,,

,,二、当以设计弯沉值和沥青层层底拉应力为指标时，各级轴载换算成标准轴载P的当量轴次N的计算,,,,,,,

,,当量轴次（N）,各级轴载作用次数（n）,标准轴载（P）,被换算车型的各级轴载（Pi）,被换算车型的轴数系数（C1）,被换算车型的轴数系数（C2）,轴数（m）,被换算车型的轴载级别（K）

,1,8.034071952,560,100,24.6,6.4,1,1,

,2,103.2849861,560,100,67.8,1,1,1,

,3,92.17343295,460,100,45.1,6.4,1,1,

,4,490.7780328,460,100,101.5,1,1,1,

,5,2.192454769,368,100,20.1,6.4,1,1,

,6,182.789866,368,100,72.6,1,1,2,

,7,367.6324028,530,100,60,6.4,1,1,

,8,1590,530,100,100,1,1,3,

,9,2.051168488,450,100,18.9,6.4,1,1,

,,10.12346858,450,100,41.8,1,1,1,

,,3.762488257,320,100,23.5,6.4,1,1,

,,8.998479281,320,100,44,1,1,1,

,,13.60559137,400,100,30,6.4,1,1,

,,21.37914129,400,100,51,1,1,1,

,10,2896.805585,,,,,,,

,,,,,,,,,,

,,三、当以半刚性基层弯拉应力为指标时，各级轴载换算成标准轴载P的当量轴次N的计算,,,,,,,

,,当量轴次（N）,各级轴载作用次数（n）,标准轴载（P）,被换算车型的各级轴载（Pi）,被换算车型的轴数系数（C1）,被换算车型的轴数系数（C2）,轴数（m）,被换算车型的轴载级别（K）

,,0.138944261,560,100,24.6,18.5,1,1,

,,25.00492625,560,100,67.8,1,1,1,

,,14.56605331,460,100,45.1,18.5,1,1,

,,518.1865898,460,100,101.5,1,1,1,

,,0.018137942,368,100,20.1,18.5,1,1,

,1,56.80293549,368,100,72.6,1,1,2,

,2,164.6863488,530,100,60,18.5,1,1,

,3,1590,530,100,100,1,1,3,

,4,0.013554349,450,100,18.9,18.5,1,1,

,5,0.419394536,450,100,41.8,1,1,1,

,6,0.0550636,320,100,23.5,18.5,1,1,

,7,0.449543156,320,100,44,1,1,1,

,8,0.485514,400,100,30,18.5,1,1,

,9,1.830717783,400,100,51,1,1,1,

,10,2372.657723,,,,,,,

,,,,,,,,,,

,,四、设计年限内一个车道上的累计当量轴次Ne的计算,,,,,,,

,1,当量轴次（Ni）,车道系数（η）,设计年限（t）,增长率（r）,设计年限内一个车道上的累计当量轴次(Ne),,,

,2,2896.805585,0.5,15,0.0685,13132400.59,,,

,3,2372.657723,0.5,15,0.0685,10756224.66,,,

,4,,,,,,,,

,5,,,,,,,,

,6,,,,,,,,

,7,,,,,,,,

,8,,,,,,