Spreadsheet: 52660d1252508874-lookup-ranges-698650_drreamsurferr
Sheet: DATA

KEY | UDF | Return Value | #key |  | KEY | Range | Rate | Low | Rate
BC00114-B | 01 Range | 100000000 | BC00114-B:01 Range |  | BC00114-B | 100000000 | 0.6 | 0 | 0.6 |  |  | BC00114-B | 3 | 1
BC00114-B | 01 Rate | 0.6 | BC00114-B:01 Rate |  | BC00114-B | 100000000 | 0.5 | 100000000 | -0.09999999999999998 |  |  | BC00331-B | 3 | 4
BC00114-B | 02 Range | 100000000 | BC00114-B:02 Range |  | BC00114-B | 999999999999 | 0.45 | 200000000 | -0.04999999999999999 |  |  | BC00406-B | 4 | 7
BC00114-B | 02 Rate | 0.5 | BC00114-B:02 Rate |  | BC00331-B | 10000000 | 0.35 | 0 | 0.35 |  |  | BC00480-B | 3 | 11
BC00114-B | 03 Range | 999999999999 | BC00114-B:03 Range |  | BC00331-B | 10000000 | 0.15 | 10000000 | -0.2 |  |  | [NAME] | 9 | 14
BC00114-B | 03 Rate | 0.45 | BC00114-B:03 Rate |  | BC00331-B | 999999999999 | 0.1 | 20000000 | -0.04999999999999999 |  |  | BC00509-B | 4 | 23
BC00331-B | 01 Range | 10000000 | BC00331-B:01 Range |  | BC00406-B | 100000000 | 0.5 | 0 | 0.5 |  |  | BC00541-B | 6 | 27
BC00331-B | 01 Rate | 0.35 | BC00331-B:01 Rate |  | BC00406-B | 100000000 | 0.4 | 100000000 | -0.09999999999999998 |  |  | BC00619-B | 3 | 33
BC00331-B | 02 Range | 10000000 | BC00331-B:02 Range |  | BC00406-B | 100000000 | 0.3 | 200000000 | -0.1 |  |  | BC01359-B | 4 | 36
BC00331-B | 02 Rate | 0.15 | BC00331-B:02 Rate |  | BC00406-B | 999999999999 | 0.2 | 300000000 | -0.09999999999999998 |  |  | BC01474-B | 2 | 40
BC00331-B | 03 Range | 999999999999 | BC00331-B:03 Range |  | BC00480-B | 50000000 | 0.6 | 0 | 0.6 |  |  | BC01571-B | 5 | 42
BC00331-B | 03 Rate | 0.1 | BC00331-B:03 Rate |  | BC00480-B | 50000000 | 0.5 | 50000000 | -0.09999999999999998 |  |  | BC01608-B | 4 | 47
BC00406-B | 01 Range | 100000000 | BC00406-B:01 Range |  | BC00480-B | 999999999999 | 0.4 | 100000000 | -0.09999999999999998 |  |  | BC01619-B | 3 | 51
BC00406-B | 01 Rate | 0.5 | BC00406-B:01 Rate |  | [NAME] | 100000000 | 0.25 | 0 | 0.25 |  |  | BC01626-B | 2 | 54
BC00406-B | 02 Range | 100000000 | BC00406-B:02 Range |  | [NAME] | 100000000 | 0.2 | 100000000 | -0.04999999999999999
BC00406-B | 02 Rate | 0.4 | BC00406-B:02 Rate |  | [NAME] | 100000000 | 0.175 | 200000000 | -0.02500000000000002
BC00406-B | 03 Range | 100000000 | BC00406-B:03 Range |  | [NAME] | 200000000 | 0.15 | 300000000 | -0.02499999999999999
BC00406-B | 03 Rate | 0.3 | BC00406-B:03 Rate |  | [NAME] | 500000000 | 0.1 | 500000000 | -0.04999999999999999
BC00406-B | 04 Range | 999999999999 | BC00406-B:04 Range |  | [NAME] | 1000000000 | 0.08 | 1000000000 | -0.02
BC00406-B | 04 Rate | 0.2 | BC00406-B:04 Rate |  | [NAME] | 1000000000 | 0.065 | 2000000000 | -0.015
BC00480-B | 01 Range | 50000000 | [NAME] |  | [NAME] | 1000000000 | 0.05 | 3000000000 | -0.015
BC00480-B | 01 Rate | 0.6 | [NAME] |  | [NAME] | 999999999999 | 0.04 | 4000000000 | -0.01
BC00480-B | 02 Range | 50000000 | [NAME] |  | BC00509-B | 100000000 | 0.4 | 0 | 0.4
BC00480-B | 02 Rate | 0.5 | [NAME] |  | BC00509-B | 100000000 | 0.3 | 100000000 | -0.1
BC00480-B | 03 Range | 999999999999 | BC00480-B:03 Range |  | BC00509-B | 200000000 | 0.275 | 200000000 | -0.02499999999999997
BC00480-B | 03 Rate | 0.4 | [NAME] Rate |  | BC00509-B | 999999999999 | 0.25 | 400000000 | -0.02500000000000002
[NAME] | 01 Range | 100000000 | [NAME] |  | BC00541-B | 30000000 | 0.45 | 0 | 0.45
[NAME] | 01 Rate | 0.25 | [NAME] |  | BC00541-B | 30000000 | 0.4 | 30000000 | -0.04999999999999999
[NAME] | 02 Range | 100000000 | [NAME] |  | BC00541-B | 30000000 | 0.35 | 60000000 | -0.05000000000000004
[NAME] | 02 Rate | 0.2 | [NAME] |  | BC00541-B | 30000000 | 0.3 | 90000000 | -0.04999999999999999
[NAME] | 03 Range | 100000000 | BC00487-B:03 Range |  | BC00541-B | 30000000 | 0.25 | 120000000 | -0.04999999999999999
[NAME] | 03 Rate | 0.175 | BC00487-B:03 Rate |  | BC00541-B | 999999999999 | 0.2 | 150000000 | -0.04999999999999999
[NAME] | 04 Range | 200000000 | [NAME] |  | BC00619-B | 50000000 | 0.5 | 0 | 0.5
[NAME] | 04 Rate | 0.15 | [NAME] |  | BC00619-B | 50000000 | 0.4 | 50000000 | -0.09999999999999998
[NAME] | 05 Range | 500000000 | [NAME] |  | BC00619-B | 999999999999 | 0.35 | 100000000 | -0.05000000000000004
[NAME] | 05 Rate | 0.1 | [NAME] |  | BC01359-B | 100000000 | 0.3 | 0 | 0.3
[NAME] | 06 Range | 1000000000 | [NAME] |  | BC01359-B | 100000000 | 0.25 | 100000000 | -0.04999999999999999
[NAME] | 06 Rate | 0.08 | [NAME] |  | BC01359-B | 100000000 | 0.225 | 200000000 | -0.02499999999999999
[NAME] | 07 Range | 1000000000 | [NAME] Range |  | BC01359-B | 200000000 | 0.2 | 300000000 | -0.02499999999999999
[NAME] | 07 Rate | 0.065 | [NAME] Rate |  | BC01474-B | 1000000000 | 0.1 | 0 | 0.1
[NAME] | 08 Range | 1000000000 | [NAME] Range |  | BC01474-B | 999999999999 | 0.08 | 1000000000 | -0.02
[NAME] | 08 Rate | 0.05 | [NAME] Rate |  | BC01571-B | 1000000000 | 0.065 | 0 | 0.065
[NAME] | 09 Range | 999999999999 | [NAME] Range |  | BC01571-B | 1000000000 | 0.035 | 1000000000 | -0.03
[NAME] | 09 Rate | 0.04 | [NAME] Rate |  | BC01571-B | 1000000000 | 0.025 | 2000000000 | -0.01
BC00509-B | 01 Range | 100000000 | [NAME] |  | BC01571-B | 2000000000 | 0.015 | 3000000000 | -0.01
BC00509-B | 01 Rate | 0.4 | [NAME] |  | BC01571-B | 999999999999 | 0.01 | 5000000000 | -0.004999999999999999
BC00509-B | 02 Range | 100000000 | BC00509-B:02 Range |  | BC01608-B | 200000000 | 0.25 | 0 | 0.25
BC00509-B | 02 Rate | 0.3 | BC00509-B:02 Rate |  | BC01608-B | 200000000 | 0.22 | 200000000 | -0.03
BC00509-B | 03 Range | 200000000 | [NAME] Range |  | BC01608-B | 200000000 | 0.2 | 400000000 | -0.01999999999999999
BC00509-B | 03 Rate | 0.275 | [NAME] Rate |  | BC01608-B | 999999999999 | 0.15 | 600000000 | -0.05000000000000002
BC00509-B | 04 Range | 999999999999 | BC00509-B:04 Range |  | BC01619-B | 500000000 | 0.04 | 0 | 0.04
BC00509-B | 04 Rate | 0.25 | BC00509-B:04 Rate
BC00541-B | 01 Range | 30000000 | BC00541-B:01 Range
BC00541-B | 01 Rate | 0.45 | BC00541-B:01 Rate
BC00541-B | 02 Range | 30000000 | BC00541-B:02 Range
BC00541-B | 02 Rate | 0.4 | BC00541-B:02 Rate
BC00541-B | 03 Range | 30000000 | BC00541-B:03 Range
BC00541-B | 03 Rate | 0.35 | BC00541-B:03 Rate
BC00541-B | 04 Range | 30000000 | BC00541-B:04 Range
BC00541-B | 04 Rate | 0.3 | BC00541-B:04 Rate
BC00541-B | 05 Range | 30000000 | BC00541-B:05 Range
BC00541-B | 05 Rate | 0.25 | BC00541-B:05 Rate
BC00541-B | 06 Range | 999999999999 | BC00541-B:06 Range
BC00541-B | 06 Rate | 0.2 | BC00541-B:06 Rate
BC00619-B | 01 Range | 50000000 | BC00619-B:01 Range
BC00619-B | 01 Rate | 0.5 | BC00619-B:01 Rate
BC00619-B | 02 Range | 50000000 | BC00619-B:02 Range
BC00619-B | 02 Rate | 0.4 | BC00619-B:02 Rate
BC00619-B | 03 Range | 999999999999 | BC00619-B:03 Range
BC00619-B | 03 Rate | 0.35 | BC00619-B:03 Rate
BC01359-B | 01 Range | 100000000 | BC01359-B:01 Range
BC01359-B | 01 Rate | 0.3 | BC01359-B:01 Rate
BC01359-B | 02 Range | 100000000 | BC01359-B:02 Range
BC01359-B | 02 Rate | 0.25 | BC01359-B:02 Rate
BC01359-B | 03 Range | 100000000 | BC01359-B:03 Range
BC01359-B | 03 Rate | 0.225 | BC01359-B:03 Rate
BC01359-B | 04 Range | 200000000 | BC01359-B:04 Range
BC01359-B | 04 Rate | 0.2 | BC01359-B:04 Rate
BC01474-B | 01 Range | 1000000000 | BC01474-B:01 Range
BC01474-B | 01 Rate | 0.1 | BC01474-B:01 Rate
BC01474-B | 02 Range | 999999999999 | BC01474-B:02 Range
BC01474-B | 02 Rate | 0.08 | BC01474-B:02 Rate
BC01571-B | 01 Range | 1000000000 | [NAME]
BC01571-B | 01 Rate | 0.065 | [NAME]
BC01571-B | 02 Range | 1000000000 | BC01571-B:02 Range
BC01571-B | 02 Rate | 0.035 | BC01571-B:02 Rate
BC01571-B | 03 Range | 1000000000 | BC01571-B:03 Range
BC01571-B | 03 Rate | 0.025 | BC01571-B:03 Rate
BC01571-B | 04 Range | 2000000000 | BC01571-B:04 Range
BC01571-B | 04 Rate | 0.015 | BC01571-B:04 Rate
BC01571-B | 05 Range | 999999999999 | [NAME]
BC01571-B | 05 Rate | 0.01 | [NAME]
BC01608-B | 01 Range | 200000000 | BC01608-B:01 Range
BC01608-B | 01 Rate | 0.25 | [NAME]
BC01608-B | 02 Range | 200000000 | BC01608-B:02 Range
BC01608-B | 02 Rate | 0.22 | BC01608-B:02 Rate
BC01608-B | 03 Range | 200000000 | BC01608-B:03 Range
BC01608-B | 03 Rate | 0.2 | BC01608-B:03 Rate
BC01608-B | 04 Range | 999999999999 | BC01608-B:04 Range
BC01608-B | 04 Rate | 0.15 | BC01608-B:04 Rate
BC01619-B | 01 Range | 500000000 | BC01619-B:01 Range
BC01619-B | 01 Rate | 0.04 | BC01619-B:01 Rate
BC01619-B | 02 Range | 500000000 | BC01619-B:02 Range
BC01619-B | 02 Rate | 0.03 | BC01619-B:02 Rate
BC01619-B | 03 Range | 999999999999 | BC01619-B:03 Range
BC01619-B | 03 Rate | 0.02 | BC01619-B:03 Rate
BC01626-B | 01 Range | 500000000 | BC01626-B:01 Range
BC01626-B | 01 Rate | 0.03 | BC01626-B:01 Rate
BC01626-B | 02 Range | 999999999999 | BC01626-B:02 Range
BC01626-B | 02 Rate | 0.02 | BC01626-B:02 Rate