计算里程|所属区段|小区段里程|区段数|N|正负号
硬座|软座|基本票|保险费
硬卧上|硬卧中|硬卧下|软卧上|软卧下|高包上|高包下|普快票|空调票|候车室空调|客票发展金|卧铺订票费
A4 = 1-20
B4 = 20
C4=IF(B4=0,0,IF(B4>0,(ROUND(G4,0)+H4*0.5)*E4+D4))
D4=IF(B4<=1100,(IF(B4<=200,0,IF(B4<=400,200,IF(B4<=700,400,IF(B4<=1100,700))))),IF(B4<=1600,1100,IF(B4<=2200,1600,IF(B4<=2900,2200,IF(B4<=3700,2900,IF(B4<=4600,3700,IF(B4>4600,4600)))))))
E4=IF(B4<=1100,(IF(B4<=200,10,IF(B4<=400,20,IF(B4<=700,30,IF(B4<=1100,40))))),IF(B4<=1600,50,IF(B4<=2200,60,IF(B4<=2900,70,IF(B4<=3700,80,IF(B4<=4600,90,IF(B4>4600,100)))))))
F4=IF(B4<=200,20,IF(B4<=4600,10,1))
G4=(B4-D4)/E4
H4=IF((G4-ROUND(G4,0))<=0,-1,IF((G4-ROUND(G4,0))>0,1))
基本K4=IF(C4<=20,0.05861*20,IF(C4<=200,0.05861*C4,IF(C4<=500,(0.05861*200+0.05861*0.9*(C4-200)),IF(C4<=1000,(0.05861*200+0.05861*0.9*300+0.05861*0.8*(C4-500)),IF(C4<=1500,(0.05861*200+0.05861*0.9*300+0.05861*0.8*500+0.05861*0.7*(C4-1000)),IF(C4<=2500,(0.05861*200+0.05861*0.9*300+0.05861*0.8*500+0.05861*0.7*500+0.05861*0.6*(C4-1500)),IF(C4>2500,(0.05861*200+0.05861*0.9*300+0.05861*0.8*500+0.05861*0.7*500+0.05861*0.6*1000+0.05861*0.5*(C4-2500)))))))))
保险 舍入前 L4=ROUNDUP(K4*0.02,1)
硬座 I4=ROUND(K4+L4,0)
软座 J4=ROUND(K4*2+L4,0)
1.1 1.2 1.3 1.75 1.95 2.1 2.3x
=ROUND(IF(C4<=400,(0.06447*200+0.06447*0.9*200),IF(C4<=500,(0.06447*200+0.06447*0.9*(C4-200)),IF(C4<=1000,(0.06447*200+0.06447*0.9*300+0.06447*0.8*(C4-500)),IF(C4<=1500,(0.06447*200+0.06447*0.9*300+0.06447*0.8*500+0.06447*0.7*(C4-1000)),IF(C4<=2500,(0.06447*200+0.06447*0.9*300+0.06447*0.8*500+0.06447*0.7*500+0.06447*0.6*(C4-1500)),IF(C4>2500,(0.06447*200+0.06447*0.9*300+0.06447*0.8*500+0.06447*0.7*500+0.06447*0.6*1000+0.06447*0.5*(C4-2500)))))))),0)
=ROUND(IF(C4<=400,(0.07033*200+0.07033*0.9*200),IF(C4<=500,(0.07033*200+0.07033*0.9*(C4-200)),IF(C4<=1000,(0.07033*200+0.07033*0.9*300+0.07033*0.8*(C4-500)),IF(C4<=1500,(0.07033*200+0.07033*0.9*300+0.07033*0.8*500+0.07033*0.7*(C4-1000)),IF(C4<=2500,(0.07033*200+0.07033*0.9*300+0.07033*0.8*500+0.07033*0.7*500+0.07033*0.6*(C4-1500)),IF(C4>2500,(0.07033*200+0.07033*0.9*300+0.07033*0.8*500+0.07033*0.7*500+0.07033*0.6*1000+0.07033*0.5*(C4-2500)))))))),0)
=ROUND(IF(C4<=400,(0.07619*200+0.07619*0.9*200),IF(C4<=500,(0.07619*200+0.07619*0.9*(C4-200)),IF(C4<=1000,(0.07619*200+0.07619*0.9*300+0.07619*0.8*(C4-500)),IF(C4<=1500,(0.07619*200+0.07619*0.9*300+0.07619*0.8*500+0.07619*0.7*(C4-1000)),IF(C4<=2500,(0.07619*200+0.07619*0.9*300+0.07619*0.8*500+0.07619*0.7*500+0.07619*0.6*(C4-1500)),IF(C4>2500,(0.07619*200+0.07619*0.9*300+0.07619*0.8*500+0.07619*0.7*500+0.07619*0.6*1000+0.07619*0.5*(C4-2500)))))))),0)
=ROUND(IF(C4<=400,(0.10257*200+0.10257*0.9*200),IF(C4<=500,(0.10257*200+0.10257*0.9*(C4-200)),IF(C4<=1000,(0.10257*200+0.10257*0.9*300+0.10257*0.8*(C4-500)),IF(C4<=1500,(0.10257*200+0.10257*0.9*300+0.10257*0.8*500+0.10257*0.7*(C4-1000)),IF(C4<=2500,(0.10257*200+0.10257*0.9*300+0.10257*0.8*500+0.10257*0.7*500+0.10257*0.6*(C4-1500)),IF(C4>2500,(0.10257*200+0.10257*0.9*300+0.10257*0.8*500+0.10257*0.7*500+0.10257*0.6*1000+0.10257*0.5*(C4-2500)))))))),0)
=ROUND(IF(C4<=400,(0.11429*200+0.11429*0.9*200),IF(C4<=500,(0.11429*200+0.11429*0.9*(C4-200)),IF(C4<=1000,(0.11429*200+0.11429*0.9*300+0.11429*0.8*(C4-500)),IF(C4<=1500,(0.11429*200+0.11429*0.9*300+0.11429*0.8*500+0.11429*0.7*(C4-1000)),IF(C4<=2500,(0.11429*200+0.11429*0.9*300+0.11429*0.8*500+0.11429*0.7*500+0.11429*0.6*(C4-1500)),IF(C4>2500,(0.11429*200+0.11429*0.9*300+0.11429*0.8*500+0.11429*0.7*500+0.11429*0.6*1000+0.11429*0.5*(C4-2500)))))))),0)
=ROUND(IF(C4<=400,(0.12308*200+0.12308*0.9*200),IF(C4<=500,(0.12308*200+0.12308*0.9*(C4-200)),IF(C4<=1000,(0.12308*200+0.12308*0.9*300+0.12308*0.8*(C4-500)),IF(C4<=1500,(0.12308*200+0.12308*0.9*300+0.12308*0.8*500+0.12308*0.7*(C4-1000)),IF(C4<=2500,(0.12308*200+0.12308*0.9*300+0.12308*0.8*500+0.12308*0.7*500+0.12308*0.6*(C4-1500)),IF(C4>2500,(0.12308*200+0.12308*0.9*300+0.12308*0.8*500+0.12308*0.7*500+0.12308*0.6*1000+0.12308*0.5*(C4-2500)))))))),0)
=ROUND(IF(C4<=400,(0.13480*200+0.13480*0.9*200),IF(C4<=500,(0.13480*200+0.13480*0.9*(C4-200)),IF(C4<=1000,(0.13480*200+0.13480*0.9*300+0.13480*0.8*(C4-500)),IF(C4<=1500,(0.13480*200+0.13480*0.9*300+0.13480*0.8*500+0.13480*0.7*(C4-1000)),IF(C4<=2500,(0.13480*200+0.13480*0.9*300+0.13480*0.8*500+0.13480*0.7*500+0.13480*0.6*(C4-1500)),IF(C4>2500,(0.13480*200+0.13480*0.9*300+0.13480*0.8*500+0.13480*0.7*500+0.13480*0.6*1000+0.13480*0.5*(C4-2500)))))))),0)
加快T4=IF(ROUND(K4*0.2,0)<1,1,IF(ROUND(K4*0.2,0)>=1,ROUND(K4*0.2,0)))
AA = T4
AB = T4 * 2
BD =ROUND(T4*1.5,0)
BE = BD * 2
空调U4=IF(ROUND(K4*0.25,0)<1,1,IF(ROUND(K4*0.25,0)>=1,ROUND(K4*0.25,0)))
AH=U4
BK=ROUND(U4*1.5,0)
候车室空调 V=IF(C4<=200,0,IF(C4>200,1)) 硬座>200km
W=IF(I4<=5,0.5,IF(I4>5,1)) 客票发展金
X=10 卧铺订票费
座 候车室空调 客票发展金 -保险费
Y= I4 +V4 +IF( I4 +V4<=5,0.5,1) -ROUNDUP($L4/5,1)*5
Z= J4 +IF( J4 <=5,0.5,1) -ROUNDUP($L4/5,1)*5
BB=ROUND(I4*1.5,0)+V4 +IF(ROUND(I4*1.5,0)+V4<=5,0.5,1) -ROUNDUP($L4/5,1)*5
BC=ROUND(J4*1.5,0) +IF(ROUND(J4*1.5,0) <=5,0.5,1) -ROUNDUP($L4/5,1)*5
铺
AC=IF(B32<400,0,M32+X32)
...
AG
BF=IF(B32<400,0,ROUND(M32*1.5,0)+X32)
...
BJ
CB4=ROUNDUP($L4/5,1)*5
0.05861*
/*
清河-张家口
0.80 72
0.85 77
0.88 79
0.92 83
0.95 86
1.00 90 公布
*/
0.05861=0.135*1.3*2.2+0.2
0.05861*2.65*1.5=0.23297475=0.2330
? 0.2805 0.187*1.5 0.187=0.07055*2.65 .5861*1.5*3.19
1995
0.03861提高到0.05861
硬座、软座、硬卧、软卧的席别比价由１∶１．７５∶１．８∶３．８５调为１∶２．０∶２．２∶３．８５
1 2 0.2*2 0.25 1.1 1.2 1.3 1.75 1.95
25K型高等级软座列车 1997
二等车 一等车120% 特等车150%
旅行速度每小时110公里以上 二等 0.2805 一等 0.3366 特等 0.4208
旅行速度每小时110公里以下 二等 0.2330 一等 0.2796 特等 0.3495
允许浮动上下10%
T7785
87( 85) 杭州 诸暨 25.5 21.5
187(185) 杭州 金华 53.5 45.5
210(210) 杭州 兰溪 60.5 50.5
100( 95) 诸暨 金华 29.5 24.5
123(125) 诸暨 兰溪 35.5 30.5
23( 25) 金华 兰溪 7.5 6.5
D字头票价
0.3703 0.37026 一等座车公布票价=0.3366×(1+10%)×运价里程
0.3086 0.30855 二等座车公布票价=0.2805×(1+10%)×运价里程
0.55539 特等座公布票价=0.2805×(1+10%)×1.8×运价里程
0.92565 商务座公布票价=0.2805×(1+10%)×3×运价里程
软卧上铺公布票价=0.3366×(1+10%)×1.6×运价里程
软卧下铺公布票价=0.3366×(1+10%)×1.8×运价里程
高级软卧上铺公布票价=0.3366×(1+10%)×3.2×运价里程
高级软卧下铺公布票价=0.3366×(1+10%)×3.6×运价里程
0.484
console.log(miles_off_emu( 281)*0.484*.95, 0.5) // 128.5
console.log(miles_off_emu( 693)*0.484*.95, 1 ) // 309
console.log(miles_off_emu(1229)*0.484*.95, 1.5) // 520.5
console.log(miles_off_emu(1591)*0.484*.95, 1.5) // 649
console.log(miles_off_emu(2298)*0.484*.95, 2 ) // 862
G 京广 0.55 高铁递远递减 最后四舍五入
// 241 151
console.log(miles_off_emu( 281)*0.55) // 155
console.log(miles_off_emu( 693)*0.55) // 371
console.log(miles_off_emu(1229)*0.55) // 623
console.log((miles_off_emu(1591)-miles_off_emu(1229))*.484*.95, 0.5) // 128.5+623=751.5
console.log((miles_off_emu(2298)-miles_off_emu(1229))*.484*.95, 1.5) // 341.5+623=964.5
24.06.15
console.log(miles_off_emu(1591)*0.55) // 778
console.log(miles_off_emu(2298)*0.55) // 1033
坪石-广州 308km
J 公布票价 0.3086 无递远递减 最后四舍五入
1.6/1.0 2.15/1.90 1.75/1.6/1.5
281 石家庄 139 87 265/235 216/198/185
442 邯郸 218 136 293/259 239/218/205
689 郑州 213 457/404 372/340/319
1200 西安 370 796/704 648/593/555
1205 汉口 372 800/707 651/595/558
1225 武昌 378 813/718 662/605/567
1587 长沙 490 1053/931 857/784/735
1876 兰州 579 1245/1100 1013/926/868
2050 重庆北 633 1360/1202 1107/1012/949
2081?重庆西 642 1381/1220 1124/1028/963
2302 广州 1137? 710 1527/1350 1243/1137/1066
8 广州-广州东
707+8 长沙-广州 221 474/419 386/353/331
521+8 广州-衡阳 163 351/310 286/261/245
374+8 郴州-广州 118 265/235 216/198/185