Spreadsheet: 55305d1255451211-text-to-number-formatting-vlookup
Sheet: RedemptionDatabase

Unique ID | Date | Station Number | Amount
6043334412307246 | 2009-06-01 00:00:00 | 99992760 | 115.3
6041858447592220 | 2009-06-01 00:00:00 | 99999944 | 40
6041858447592220 | 2009-06-01 00:00:00 | 99999944 | 40
6043334415978709 | 2009-06-01 00:00:00 | 99999944 | 219.2
6043334417169020 | 2009-06-01 00:00:00 | 99999944 | 344.42
6043334401400726 | 2009-06-01 00:00:00 | 99999944 | 50
6041858451936258 | 2009-06-01 00:00:00 | 99999944 | 25
6041858451936258 | 2009-06-01 00:00:00 | 99999944 | 25
6041858443345782 | 2009-06-01 00:00:00 | 99999944 | 200
6041858452028136 | 2009-06-02 00:00:00 | 99999944 | 124.8
6043334414029795 | 2009-06-02 00:00:00 | 99999944 | 512.2
6041858441699814 | 2009-06-02 00:00:00 | 99999944 | 50.2
6041858441699814 | 2009-06-02 00:00:00 | 99999944 | 50.2
6041858441699814 | 2009-06-02 00:00:00 | 99999944 | 50.2
6041858440373432 | 2009-06-02 00:00:00 | 99999944 | 129.6
6041858440373432 | 2009-06-02 00:00:00 | 99999944 | 129.6
6043334417874853 | 2009-06-02 00:00:00 | 99999944 | 87.5
6043334417874853 | 2009-06-02 00:00:00 | 99999944 | 87.5
6041858425212942 | 2009-06-02 00:00:00 | 99999944 | 240.6
6043334418808972 | 2009-06-03 00:00:00 | 99999944 | 100
6041858434032697 | 2009-06-03 00:00:00 | 99999944 | 30.3
6043334417778426 | 2009-06-03 00:00:00 | 99999944 | 150
6041858439577673 | 2009-06-03 00:00:00 | 99999944 | 49.11
6041858694651872 | 2009-06-03 00:00:00 | 99999944 | 311.2
6041858432536841 | 2009-06-03 00:00:00 | 99999944 | 50
6041858432521030 | 2009-06-03 00:00:00 | 99992550 | 109.6
6041858445046984 | 2009-06-04 00:00:00 | 99999944 | 50
6043334415140799 | 2009-06-04 00:00:00 | 99999944 | 75
6043334417458779 | 2009-06-04 00:00:00 | 99999944 | 54.1
6043334418353784 | 2009-06-04 00:00:00 | 99999944 | 100
6043334418580620 | 2009-06-05 00:00:00 | 99999944 | 370.2
6043334418580620 | 2009-06-05 00:00:00 | 99999944 | 370.2
6041858445557794 | 2009-06-05 00:00:00 | 99999944 | 48.1
6041858429424765 | 2009-06-05 00:00:00 | 99999944 | 50
6041858429424765 | 2009-06-05 00:00:00 | 99999944 | 50
6043334416603975 | 2009-06-05 00:00:00 | 99999944 | 285.2
6043334418706917 | 2009-06-06 00:00:00 | 99999944 | 250
6041858440028842 | 2009-06-06 00:00:00 | 99999944 | 100
6041858448302601 | 2009-06-07 00:00:00 | 99999944 | 200
6041858694461291 | 2009-06-08 00:00:00 | 99999944 | 199.2
6041858694461291 | 2009-06-08 00:00:00 | 99999944 | 199.2
6041858694461291 | 2009-06-08 00:00:00 | 99999944 | 199.2
6041858694461291 | 2009-06-08 00:00:00 | 99999944 | 199.2
6041858452186050 | 2009-06-08 00:00:00 | 99999944 | 18.59
6041858452186050 | 2009-06-08 00:00:00 | 99999944 | 18.59
6041858443542530 | 2009-06-08 00:00:00 | 99999944 | 84.6
6043334417933534 | 2009-06-08 00:00:00 | 99999944 | 151.2
6041858694717887 | 2009-06-08 00:00:00 | 99992760 | 207.5
6041858694717887 | 2009-06-08 00:00:00 | 99992760 | 207.5
6041858426376208 | 2009-06-08 00:00:00 | 99999944 | 75
6041858426376208 | 2009-06-08 00:00:00 | 99999944 | 75
6043334418797203 | 2009-06-09 00:00:00 | 99999944 | 150
6043334418797203 | 2009-06-09 00:00:00 | 99999944 | 150
6041858449548937 | 2009-06-09 00:00:00 | 99999944 | 453.2
6041858433041395 | 2009-06-09 00:00:00 | 99999944 | 179.2
6041858694367448 | 2009-06-10 00:00:00 | 99999944 | 250
6041858694367448 | 2009-06-10 00:00:00 | 99999944 | 250
6041858440180692 | 2009-06-10 00:00:00 | 99999944 | 55.8
6041858440180692 | 2009-06-10 00:00:00 | 99999944 | 55.8
6043334400222310 | 2009-06-10 00:00:00 | 99999944 | 400
6043334418153152 | 2009-06-10 00:00:00 | 99999944 | 189.2
6041858694294509 | 2009-06-10 00:00:00 | 99999944 | 125
6041858694294509 | 2009-06-10 00:00:00 | 99999944 | 125
6043334410679802 | 2009-06-10 00:00:00 | 99999944 | 200
6041858426013659 | 2009-06-10 00:00:00 | 99999944 | 26.9
6041858426013659 | 2009-06-10 00:00:00 | 99999944 | 26.9
6043334419214532 | 2009-06-10 00:00:00 | 99999944 | 177.7
6043334419501026 | 2009-06-11 00:00:00 | 99999944 | 176.66
6043334419501026 | 2009-06-11 00:00:00 | 99999944 | 176.66
6043334419501026 | 2009-06-11 00:00:00 | 99999944 | 176.66
6041858447489619 | 2009-06-11 00:00:00 | 99999944 | 298.2
873 | 2009-06-11 00:00:00 | 99992734 | 0
873 | 2009-06-11 00:00:00 | 99992734 | 0
6043334419258060 | 2009-06-11 00:00:00 | 99999944 | 100
6043334419258060 | 2009-06-11 00:00:00 | 99999944 | 100
6043334414914308 | 2009-06-11 00:00:00 | 99999944 | 197.7
6043334414902892 | 2009-06-11 00:00:00 | 99999944 | 197.7
6041858694194074 | 2009-06-11 00:00:00 | 99999944 | 250
6041858694194074 | 2009-06-11 00:00:00 | 99999944 | 250
6041858426351356 | 2009-06-11 00:00:00 | 99999944 | 25
6041858426351356 | 2009-06-11 00:00:00 | 99999944 | 25
6041858445239692 | 2009-06-12 00:00:00 | 99999944 | 200
6041858429404483 | 2009-06-12 00:00:00 | 99999944 | 100
6041858429404483 | 2009-06-12 00:00:00 | 99999944 | 100
6043334411436984 | 2009-06-12 00:00:00 | 99999944 | 400
6041858448056327 | 2009-06-12 00:00:00 | 99999944 | 300
6052819094966099 | 2009-06-12 00:00:00 | 99999944 | -15
6043334416385907 | 2009-06-12 00:00:00 | 99999944 | 25
6041858449277027 | 2009-06-12 00:00:00 | 99999944 | 50
6041858449277027 | 2009-06-12 00:00:00 | 99999944 | 50
6041858450397452 | 2009-06-13 00:00:00 | 99999944 | 200
6043334415576117 | 2009-06-13 00:00:00 | 99999944 | 30
6041858437546580 | 2009-06-13 00:00:00 | 99999944 | 25
6041858440273591 | 2009-06-13 00:00:00 | 99999944 | 199.2
6041858440273591 | 2009-06-13 00:00:00 | 99999944 | 75.8
6043334414039415 | 2009-06-14 00:00:00 | 99999944 | 255.2
6041858429819211 | 2009-06-15 00:00:00 | 99999944 | 449.2
6041858426147222 | 2009-06-15 00:00:00 | 99999944 | 100
6041858426158973 | 2009-06-15 00:00:00 | 99999944 | 100
6043334417818389 | 2009-06-15 00:00:00 | 99999944 | 238.2
6041858426838048 | 2009-06-15 00:00:00 | 99999944 | 75
6041858427403168 | 2009-06-15 00:00:00 | 99999944 | 147.6
6043334419570531 | 2009-06-15 00:00:00 | 99999944 | 125
6043334419570531 | 2009-06-15 00:00:00 | 99999944 | 125
6041858426566302 | 2009-06-15 00:00:00 | 99999944 | 25
6043334416846146 | 2009-06-15 00:00:00 | 99999944 | 192.6
6043334415422066 | 2009-06-15 00:00:00 | 99999944 | 5
6041858426172323 | 2009-06-15 00:00:00 | 99999944 | 100
6041858449057430 | 2009-06-16 00:00:00 | 99999944 | 75
6041858449057430 | 2009-06-16 00:00:00 | 99999944 | 75
6041858429146744 | 2009-06-16 00:00:00 | 99999944 | 83.33
6041858429146744 | 2009-06-16 00:00:00 | 99999944 | 83.33
6041858429146744 | 2009-06-16 00:00:00 | 99999944 | 83.33
6043334416174584 | 2009-06-16 00:00:00 | 99999944 | 125
6043334419714975 | 2009-06-16 00:00:00 | 99999944 | 50
6043334419714975 | 2009-06-16 00:00:00 | 99999944 | 50
6043334417442758 | 2009-06-17 00:00:00 | 99999944 | 75
6043334417442758 | 2009-06-17 00:00:00 | 99999944 | 75
6041858434744597 | 2009-06-17 00:00:00 | 99999944 | 199.2
6041858434744597 | 2009-06-17 00:00:00 | 99999944 | 30.6
6043334412207931 | 2009-06-17 00:00:00 | 99999944 | 50
6041858440517092 | 2009-06-17 00:00:00 | 99999944 | 50
6041858440526231 | 2009-06-17 00:00:00 | 99999944 | 50
6041858429549559 | 2009-06-17 00:00:00 | 99999944 | 100
6041858447856148 | 2009-06-17 00:00:00 | 99999944 | 100
6041858432042538 | 2009-06-17 00:00:00 | 99999944 | 329.9
6043334395031332 | 2009-06-17 00:00:00 | 99999944 | 134.7
6043334413194762 | 2009-06-17 00:00:00 | 99999944 | 149.2
6043334418739026 | 2009-06-17 00:00:00 | 99999944 | 300
6043334419111778 | 2009-06-18 00:00:00 | 99999944 | 225
6043334407902992 | 2009-06-18 00:00:00 | 99999944 | 150
6043334407902992 | 2009-06-18 00:00:00 | 99999944 | 150
6043334416421953 | 2009-06-18 00:00:00 | 99999944 | 150
6043334418953928 | 2009-06-18 00:00:00 | 99999944 | 200
6041858448660675 | 2009-06-18 00:00:00 | 99999944 | 50
6041858448660675 | 2009-06-18 00:00:00 | 99999944 | 50
6052818180544414 | 2009-06-18 00:00:00 | 99999944 | 2.5
6052818180544414 | 2009-06-18 00:00:00 | 99999944 | 2.5
6052818108608623 | 2009-06-18 00:00:00 | 99999944 | 5
6043334418272188 | 2009-06-18 00:00:00 | 99999944 | 100
6043334418272188 | 2009-06-18 00:00:00 | 99999944 | 100
6052818115748466 | 2009-06-19 00:00:00 | 99999944 | 5
6052818190491558 | 2009-06-19 00:00:00 | 99999944 | 10
6052818104719241 | 2009-06-19 00:00:00 | 99999944 | 5
6052818118164752 | 2009-06-19 00:00:00 | 99999944 | 5
6043334414054916 | 2009-06-19 00:00:00 | 99999944 | 202.2
6043334414054916 | 2009-06-19 00:00:00 | 99999944 | 202.2
6043334402126935 | 2009-06-19 00:00:00 | 99999944 | 50
6041858447549263 | 2009-06-19 00:00:00 | 99999944 | 50
6043334413720842 | 2009-06-19 00:00:00 | 99999944 | 250
6043334393779085 | 2009-06-20 00:00:00 | 99999944 | 16.62
6052818099810756 | 2009-06-21 00:00:00 | 99999944 | 5
6041858447427893 | 2009-06-21 00:00:00 | 99999944 | 100
6043334402523074 | 2009-06-21 00:00:00 | 99999944 | 200
6043334412824009 | 2009-06-21 00:00:00 | 99999944 | 91.5
6052818112513212 | 2009-06-21 00:00:00 | 99999944 | 5
6052818164408797 | 2009-06-21 00:00:00 | 99999944 | 2.5
6052818164408797 | 2009-06-21 00:00:00 | 99999944 | 2.5
6052818164421770 | 2009-06-21 00:00:00 | 99999944 | 5
6052818145351056 | 2009-06-21 00:00:00 | 99999944 | 5
6043334418321461 | 2009-06-21 00:00:00 | 99999944 | 125
6043334418321461 | 2009-06-21 00:00:00 | 99999944 | 125
6043334412867110 | 2009-06-22 00:00:00 | 99999944 | 25
6041858446921117 | 2009-06-22 00:00:00 | 99999944 | 10.4
6052818147223217 | 2009-06-22 00:00:00 | 99999944 | 5
6041858424589485 | 2009-06-22 00:00:00 | 99999944 | 215.2
6052818159604905 | 2009-06-22 00:00:00 | 99999944 | 5
6052818192611537 | 2009-06-22 00:00:00 | 99999944 | 3.33
6052818192611537 | 2009-06-22 00:00:00 | 99999944 | 3.33
6052818192611537 | 2009-06-22 00:00:00 | 99999944 | 3.33
6043334419193738 | 2009-06-22 00:00:00 | 99999944 | 100
6052818136688684 | 2009-06-23 00:00:00 | 99999944 | 5
6052818135862956 | 2009-06-23 00:00:00 | 99999944 | 5
6041858448976638 | 2009-06-23 00:00:00 | 99999944 | 50
6052818124154550 | 2009-06-23 00:00:00 | 99999944 | 5
6041858432409232 | 2009-06-23 00:00:00 | 99999944 | 179.2
6041858439300729 | 2009-06-23 00:00:00 | 99999944 | 200
6052818128068223 | 2009-06-23 00:00:00 | 99999944 | 2.5
6052818128068223 | 2009-06-23 00:00:00 | 99999944 | 2.5
6041858448105537 | 2009-06-23 00:00:00 | 99999944 | 50
6052818113427418 | 2009-06-23 00:00:00 | 99999944 | 5
6041858449861560 | 2009-06-24 00:00:00 | 99992760 | 127.7
6041858449861560 | 2009-06-24 00:00:00 | 99992760 | 127.7
6041858423969301 | 2009-06-24 00:00:00 | 99999944 | 200
6041858436431820 | 2009-06-24 00:00:00 | 99999944 | 110.62
6041858436431820 | 2009-06-24 00:00:00 | 99999944 | 110.62
6043334412579935 | 2009-06-24 00:00:00 | 99999944 | 75
6043334407152790 | 2009-06-24 00:00:00 | 99999944 | 174.2
6041858427811385 | 2009-06-24 00:00:00 | 99999944 | 11
6041858427811385 | 2009-06-24 00:00:00 | 99999944 | 11
6043334412915663 | 2009-06-24 00:00:00 | 99992760 | 150
6043334412915663 | 2009-06-24 00:00:00 | 99992760 | 150
6041858450337727 | 2009-06-24 00:00:00 | 99999944 | 50
6041858450337727 | 2009-06-24 00:00:00 | 99999944 | 50
6052818134432565 | 2009-06-24 00:00:00 | 99999944 | 5
6043334419053244 | 2009-06-24 00:00:00 | 99999944 | 250
6043334419053244 | 2009-06-24 00:00:00 | 99999944 | 250
6043334416636739 | 2009-06-24 00:00:00 | 99999944 | 150
6043334397585650 | 2009-06-24 00:00:00 | 99999944 | 154.2
6041858430977673 | 2009-06-24 00:00:00 | 99999944 | 500
6041858446571564 | 2009-06-24 00:00:00 | 99999944 | 50
6041858446571564 | 2009-06-24 00:00:00 | 99999944 | 50
6043334408241239 | 2009-06-24 00:00:00 | 99999944 | 95.15
6043334408241239 | 2009-06-24 00:00:00 | 99999944 | 95.15
6043334408241239 | 2009-06-24 00:00:00 | 99999944 | 95.15
6043334408241239 | 2009-06-24 00:00:00 | 99999944 | 95.15
6052818119028432 | 2009-06-25 00:00:00 | 99999944 | 5
6042227387244761 | 2009-06-25 00:00:00 | 99999944 | -134.7
6042227387244761 | 2009-06-25 00:00:00 | 99999944 | -65.3
6043334418054626 | 2009-06-25 00:00:00 | 99999944 | 60
6043334418746087 | 2009-06-25 00:00:00 | 99999944 | 150
6043334417567647 | 2009-06-25 00:00:00 | 99999944 | 195.9
6052818145433898 | 2009-06-25 00:00:00 | 99999944 | 2.5
6052818145433898 | 2009-06-25 00:00:00 | 99999944 | 2.5
6052818181983817 | 2009-06-25 00:00:00 | 99999944 | 5
6052818180476406 | 2009-06-25 00:00:00 | 99992760 | 5
6043334416541809 | 2009-06-25 00:00:00 | 99999944 | 50
6052818103132672 | 2009-06-25 00:00:00 | 99999944 | 5
6043334419989934 | 2009-06-26 00:00:00 | 99999944 | 391.2
6043334419989934 | 2009-06-26 00:00:00 | 99999944 | 391.2
6052818193939295 | 2009-06-26 00:00:00 | 99999944 | 50
6052818134951950 | 2009-06-26 00:00:00 | 99999944 | 5
6041858694415873 | 2009-06-27 00:00:00 | 99999944 | 215.8
6041858694415873 | 2009-06-27 00:00:00 | 99999944 | 215.8
6043334420116898 | 2009-06-27 00:00:00 | 99999944 | 259.4
6043334420116898 | 2009-06-27 00:00:00 | 99999944 | 259.4
6052818194390867 | 2009-06-27 00:00:00 | 99999944 | 25
6052818194390867 | 2009-06-27 00:00:00 | 99999944 | 25
6043334397467087 | 2009-06-27 00:00:00 | 99999944 | 100
6041858433161481 | 2009-06-27 00:00:00 | 99999944 | 75
6041858433149718 | 2009-06-27 00:00:00 | 99999944 | 37.5
6041858433149718 | 2009-06-27 00:00:00 | 99999944 | 37.5
6041858446484723 | 2009-06-27 00:00:00 | 99999944 | 169.2
6043334420053306 | 2009-06-28 00:00:00 | 99999944 | 15
6043334420053306 | 2009-06-28 00:00:00 | 99999944 | 15
6043334419067317 | 2009-06-28 00:00:00 | 99999944 | 179.2
6041858433908380 | 2009-06-28 00:00:00 | 99999944 | 200
6041858433908380 | 2009-06-28 00:00:00 | 99999944 | 200
6041858428803483 | 2009-06-28 00:00:00 | 99999944 | 50
6041858428803483 | 2009-06-28 00:00:00 | 99999944 | 50
6041858424127548 | 2009-06-28 00:00:00 | 99999944 | 277.7
6052818119486847 | 2009-06-28 00:00:00 | 99999944 | 5
6043334419163820 | 2009-06-29 00:00:00 | 99999944 | 50
6052818106170729 | 2009-06-29 00:00:00 | 99999944 | 5
6052818106168925 | 2009-06-29 00:00:00 | 99999944 | 5
6041858447149609 | 2009-06-29 00:00:00 | 99992760 | 100
6041858447151410 | 2009-06-29 00:00:00 | 99992760 | 100
6052818100889771 | 2009-06-29 00:00:00 | 99999944 | 5
6041858429215588 | 2009-06-29 00:00:00 | 99999944 | 100
6041858429215588 | 2009-06-29 00:00:00 | 99999944 | 100
6043334417139243 | 2009-06-29 00:00:00 | 99992760 | 150
6052818118133473 | 2009-06-29 00:00:00 | 99999944 | 5
6043334412905663 | 2009-06-29 00:00:00 | 99999944 | 25
6043334412905663 | 2009-06-29 00:00:00 | 99999944 | 25
6052818171616340 | 2009-06-30 00:00:00 | 99999944 | 5
6041858442084946 | 2009-06-30 00:00:00 | 99999944 | 100
6041858442084946 | 2009-06-30 00:00:00 | 99999944 | 100
6041858694633430 | 2009-06-30 00:00:00 | 99999944 | 250
6041858694633430 | 2009-06-30 00:00:00 | 99999944 | 250
6041858694633430 | 2009-06-30 00:00:00 | 99999944 | 250
6041858694633430 | 2009-06-30 00:00:00 | 99999944 | 250
6052818189407486 | 2009-06-30 00:00:00 | 99999944 | 5
6043334415101125 | 2009-06-30 00:00:00 | 99999944 | 209.6
6052818145741141 | 2009-06-30 00:00:00 | 99992760 | 5
6041858448003704 | 2009-06-30 00:00:00 | 99992760 | 50
6041858448003704 | 2009-06-30 00:00:00 | 99992760 | 50
6041858453491093 | 2009-06-30 00:00:00 | 99992760 | 100
6041858453491093 | 2009-06-30 00:00:00 | 99992760 | 100
6041858448574002 | 2009-06-30 00:00:00 | 99999944 | 100
6041858430965917 | 2009-06-30 00:00:00 | 99999944 | 60
6041858430965917 | 2009-06-30 00:00:00 | 99999944 | 60
6043334419855505 | 2009-06-30 00:00:00 | 99999944 | 50
6052818181701895 | 2009-06-30 00:00:00 | 99999944 | 0.83
6052818181701895 | 2009-06-30 00:00:00 | 99999944 | 0.83
6052818181701895 | 2009-06-30 00:00:00 | 99999944 | 0.83
6052818181701895 | 2009-06-30 00:00:00 | 99999944 | 0.83
6052818181701895 | 2009-06-30 00:00:00 | 99999944 | 0.83
6052818181701895 | 2009-06-30 00:00:00 | 99999944 | 0.83
6052818110886999 | 2009-06-30 00:00:00 | 99999944 | 2.5
6052818110886999 | 2009-06-30 00:00:00 | 99999944 | 2.5
6043334412193249 | 2009-06-30 00:00:00 | 99999944 | 229.2
6043334413955845 | 2009-06-30 00:00:00 | 99999944 | 12.5
6043334413955845 | 2009-06-30 00:00:00 | 99999944 | 12.5
6052818186924563 | 2009-06-30 00:00:00 | 99999944 | 5
6043334418142326 | 2009-06-30 00:00:00 | 99999944 | 50
6041858424071716 | 2009-06-30 00:00:00 | 99999944 | 50
6041858424071716 | 2009-06-30 00:00:00 | 99999944 | 50
6041858432959260 | 2009-06-30 00:00:00 | 99999944 | 120.2
6043334414423229 | 2009-06-30 00:00:00 | 99999944 | 125
6043334414423229 | 2009-06-30 00:00:00 | 99999944 | 125
 |  |  |  |  | 1