公路建设项目经济评价表模板(自动计算)

晋级．缩短里程．减少交通事故效益计算表,,,,,,,,,,,,,

评价,老路交通量,新路交通量,新路周转量,老路运输成本,新路运输成本,成本差,晋级效益,缩短里程上的换算周转量,缩短里程效益,车辆行驶量,减少交通事故节约效益,,

年度,(辆/日),(辆/日),(千万吨公里),(元/千吨公里),(元/千吨公里),(元/千吨公里),(万元),(千万吨公里),(万元),(亿车公里),(万元),,

2004,2973,2973,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,,

2005,3197,3197,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,,

2006,3436,3436,2.19,265.67,173.19,92.48,202.94,0.12,32.46,0.10,3.32,,

2007,3665,3665,2.34,267.24,175.04,92.20,215.81,0.13,34.83,0.10,3.54,,

2008,3909,3909,2.50,268.80,176.90,91.90,229.43,0.14,37.36,0.11,3.77,,

2009,4168,4168,2.66,270.35,178.78,91.58,243.78,0.15,40.07,0.12,4.02,,

2010,4443,4443,2.84,271.89,180.65,91.24,258.91,0.16,42.96,0.13,4.29,,

2011,4734,4734,3.02,273.42,182.53,90.88,274.79,0.17,46.03,0.13,4.57,,

2012,5019,5019,3.21,274.82,184.27,90.54,290.24,0.18,49.05,0.14,4.84,,

2013,5321,5321,3.40,276.21,186.02,90.19,306.49,0.19,52.26,0.15,5.14,,

2014,5638,5638,3.60,277.59,187.77,89.82,323.43,0.20,55.65,0.16,5.44,,

2015,5974,5974,3.82,278.96,189.52,89.44,341.25,0.21,59.26,0.17,5.77,,

2016,6331,6331,4.04,280.33,191.29,89.04,360.05,0.23,63.11,0.18,6.11,,

2017,6673,6673,4.26,281.57,192.90,88.67,377.92,0.24,66.81,0.19,,,说明：表中黄色背景的单元格数值是要求用户输入的。

2018,7034,7034,4.49,282.81,194.51,88.30,396.67,0.25,70.74,0.20,6.79,,老路交通量和新路交通量为同一数值。

2019,7434,7434,4.75,284.10,196.21,87.89,417.29,0.26,75.10,0.21,7.17,,其它的空白。

2020,7857,7857,5.02,285.39,197.92,87.47,438.94,0.28,79.74,0.22,7.58,,

2021,8279,8279,5.29,286.61,199.54,87.07,460.38,0.29,84.38,0.24,7.99,,

2022,8697,8697,5.55,287.75,201.07,86.68,481.47,0.31,88.99,0.25,8.39,,

2023,9137,9137,5.84,288.89,202.60,86.28,503.52,0.32,93.86,0.26,8.82,,

2024,9598,9598,6.