Paul Kelly
Verified Rep - BR Fares
A search shows there have a been a few previous threads about rounding rules on here, none of them really conclusive, so I thought I would start a new one looking at it from a different angle.
The RJIS Datafeed spec. for fares data contains (on page 48) a description of a list of rounding rules. It does not however say when they should be used, and to the best of my knowledge nothing else in the spec references them. They are however included in the data files that come with Avantix Traveller, and I have included a summary of them below.
Some of them seem really quite elaborate, and I am baffled as to what all the different rules would be needed for. Any ideas or hints or clues that anybody has would be really interesting. As far as I can see, Avantix Traveller just rounds everything to the nearest 5p (which is actually the first rule).
I suppose my main question is, if you were to implement some software that could calculate railcard-discounted fares, would it be acceptable for it just to always round to the nearest 5p. I think it probably would, but I'd be really interested in any historical insights into all these rounding rules and when/where they should be/were used!
There are 36 of them, labeled 1 to 10 and then A to Z. Some of them are duplicates of others:
01: Round all fares to nearest 5p
02: Round all fares to nearest penny
03: Round all fares to nearest 50p
04: Same as 03
05: Round all fares to nearest 10p
06: Fares up to £20.00, round to nearest 10p. £20.01 and above round to nearest 50p
07: Same as 03
08: Round all fares to nearest pound
09: Same as 02
10: Same as 05
A : Round all fares up to next pound
B : Round all fares up to next 50p
C : Fares up to £14.49, round up to next 10p. Fares £14.50 - £73.99, round up to next 50p. Fares £75.00 and above round up to next pound.
D : Fares up to £9.99, round up to next 10p. Fares £10.00 - £49.99, round up to next 50p. Fares £50.00 and above round up to next pound.
E : Fares up to £9.99, round up to next 10p. Fares £10.00 - £29.99, round up to next 50p. Fares £30.00 and above round up to next pound.
F : Round all fares up to next 10p
G : Fares up to £29.99, round up to next 10p. Fares £30.00 and above round up to next 50p.
H : Fares up to £19.99, round up to next 50p. Fares £20.00 and above round up to next pound.
I : Round all fares up to next 20p
J : Fares up to £24.99, round up to next 10p. Fares £25.00 to £99.99, round up to next 50p. Fares £100.00 to £249.99, round up to next pound. Fares £250.00 and above, round up to next £5.
K : Fares up to £9.99, round up to next 10p. Fares £10.00 to £19.99, round up to next 50p. Fares £20.00 and above round up to next pound.
L : Round all fares up to next 10p
M : Round all fares up to next 5p
N : Fares up to £14.49, round up to next 10p. Fares £14.50 and above, round up to next 50p.
O : Same as B
P : Same as A
Q : Same as A
R : Same as L
S : Round all fares up to next £5
T : Same as B
U : Same as L
V : Same as B
W : Fares up to £9.99, round up to next 10p. Fares £10.00 to £29.99, round up to next 20p. Fares £30.00 to £39.99, round up to next 50p. Fares £40.00 and above, also round up to next 50p!
X : Fares up to £9.99, round up to next 10p. Fares £10.00 and above round up to next 50p.
Y : Fares up to £14.99, round up to next 10p. Fares £15.00 and above round up to next 50p.
Z : Fares up to £14.99, round up to next 10p. Fares £15.00 to £99.99, round up to next 50p. Fares £100.00 and above round up to next pound.
The RJIS Datafeed spec. for fares data contains (on page 48) a description of a list of rounding rules. It does not however say when they should be used, and to the best of my knowledge nothing else in the spec references them. They are however included in the data files that come with Avantix Traveller, and I have included a summary of them below.
Some of them seem really quite elaborate, and I am baffled as to what all the different rules would be needed for. Any ideas or hints or clues that anybody has would be really interesting. As far as I can see, Avantix Traveller just rounds everything to the nearest 5p (which is actually the first rule).
I suppose my main question is, if you were to implement some software that could calculate railcard-discounted fares, would it be acceptable for it just to always round to the nearest 5p. I think it probably would, but I'd be really interested in any historical insights into all these rounding rules and when/where they should be/were used!
There are 36 of them, labeled 1 to 10 and then A to Z. Some of them are duplicates of others:
01: Round all fares to nearest 5p
02: Round all fares to nearest penny
03: Round all fares to nearest 50p
04: Same as 03
05: Round all fares to nearest 10p
06: Fares up to £20.00, round to nearest 10p. £20.01 and above round to nearest 50p
07: Same as 03
08: Round all fares to nearest pound
09: Same as 02
10: Same as 05
A : Round all fares up to next pound
B : Round all fares up to next 50p
C : Fares up to £14.49, round up to next 10p. Fares £14.50 - £73.99, round up to next 50p. Fares £75.00 and above round up to next pound.
D : Fares up to £9.99, round up to next 10p. Fares £10.00 - £49.99, round up to next 50p. Fares £50.00 and above round up to next pound.
E : Fares up to £9.99, round up to next 10p. Fares £10.00 - £29.99, round up to next 50p. Fares £30.00 and above round up to next pound.
F : Round all fares up to next 10p
G : Fares up to £29.99, round up to next 10p. Fares £30.00 and above round up to next 50p.
H : Fares up to £19.99, round up to next 50p. Fares £20.00 and above round up to next pound.
I : Round all fares up to next 20p
J : Fares up to £24.99, round up to next 10p. Fares £25.00 to £99.99, round up to next 50p. Fares £100.00 to £249.99, round up to next pound. Fares £250.00 and above, round up to next £5.
K : Fares up to £9.99, round up to next 10p. Fares £10.00 to £19.99, round up to next 50p. Fares £20.00 and above round up to next pound.
L : Round all fares up to next 10p
M : Round all fares up to next 5p
N : Fares up to £14.49, round up to next 10p. Fares £14.50 and above, round up to next 50p.
O : Same as B
P : Same as A
Q : Same as A
R : Same as L
S : Round all fares up to next £5
T : Same as B
U : Same as L
V : Same as B
W : Fares up to £9.99, round up to next 10p. Fares £10.00 to £29.99, round up to next 20p. Fares £30.00 to £39.99, round up to next 50p. Fares £40.00 and above, also round up to next 50p!
X : Fares up to £9.99, round up to next 10p. Fares £10.00 and above round up to next 50p.
Y : Fares up to £14.99, round up to next 10p. Fares £15.00 and above round up to next 50p.
Z : Fares up to £14.99, round up to next 10p. Fares £15.00 to £99.99, round up to next 50p. Fares £100.00 and above round up to next pound.