Spreadsheet: 220921d1363301939-formula-for-summation-of-relative-ranges-range-test-jacc
Sheet: Summary

 |  |  |  |  | 2010-01-31 00:00:00
 |  | Fee for Service Revenue |  |  | 564728.75 | 543259.25 | 675616 | 572650.75 | 608794.5 | 467732 | 407603 | 437200.25 | 534893.25 | 520569.5 | 564153 | 595370.5 | 656834.25 | 636998.75 | 653257.25 | 605227.75 | 567172.25 | 435382.25 | 411846.5 | 423424.5 | 503036 | 552162.25 | 591100 | 539258 | 530226.44 | 565558.75 | 621102.25 | 578382 | 576197.5 | 483111.25 | 431496 | 464578 | 588860.25 | 613050.25 | 685892.75 | 729823.5
 |  | Allowances & Bad Debt |  |  | -74547.11 | 2742.100000000006 | -82694.77 | -61757.91 | -172762.87 | -52231.39999999999 | -41635.85999999999 | -77818.57999999999 | -62547.5 | -66556.93 | -47543.13 | -71100.55 | -73765.22 | -117480.49 | -87183.9 | -99018.27 | -55834.61 | -62497.84 | -56676.38 | -70435.21999999999 | -55925.88999999999 | -79701.73 | -135792.36 | -77112.78 | -87736.14000000001 | -74774.87999999999 | -106869.87 | -103346.03 | -35239 | -77740.69 | -72688.89 | -44345.74999999999 | -89817.40999999999 | -87231.99 | -98680.22 | -118341.6
 |  | Net Revenue
 |  | NNR % of Gross
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Collections DOS + 1m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Collections DOS + 2m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Collections DOS + 3m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Collections DOS + 4m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Collections DOS + 5m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Collections DOS + 6m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Collections DOS + 7m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Collections DOS + 8m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Collections DOS + 9m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Collections DOS + 10m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Collections DOS + 11m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Collections DOS + 12m
 |  |  |  |  | 99996.77999999998 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 289690.5399999999 | 81443.91 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 45847.57 | 298620.4700000001 | 124174.68 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 20487.54 | 30339.69999999999 | 321179.1999999999 | 98536.63000000002 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 9731.390000000001 | 13497.76 | 77208.4199999998 | 312599.3499999999 | 92806.62999999998 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 6549.51 | 10730.36 | 28764.37 | 51878.96999999993 | 355740.2899999995 | 110757.4599999999 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 2829.79 | 4242.57 | 12037.03 | 17384.77 | 40812.34 | 181736.8299999998 | 129914.8599999999 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 1488 | 2649.8 | 6710.440000000001 | 9282.18 | 14279.45 | 73997.05999999998 | 169913.4099999998 | 103736.0299999999 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 837.86 | 2065.66 | 3355.29 | 4826.690000000001 | 10772.41 | 11999.84 | 24595.19 | 219407.52 | 109878.5799999999 | 0 | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 495.66 | 881.5 | 2205.76 | 2675.97 | 5700.669999999999 | 7982.300000000001 | 9418.159999999998 | 26652.1 | 275864.4699999997 | 77971.35999999994 | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 342 | 414.5 | 1376.47 | 2386.93 | 3334.119999999999 | 3283.87 | 6562.480000000001 | 12899.9 | 47484.06999999999 | 287223.11 | 91724.11 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 591.5 | 1434 | 1301.87 | 1792.97 | 2008.89 | 856.92 | 2618.67 | 5609.68 | 13465.78 | 41552.38999999999 | 305155.0100000006 | 109314.1299999999 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 429.5 | 829.3299999999999 | 834.6700000000001 | 942.09 | 711.8399999999999 | 1575.03 | 1742.41 | 2238.51 | 6618.940000000001 | 15419.68 | 50740.5 | 327908.0000000008 | 114094.42 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 196.5 | 992 | 177.1 | 380.22 | 656.5 | 2130.79 | 1267.54 | 2303.1 | 4254.780000000001 | 7020.02 | 14514.53 | 27685.66000000002 | 320778.8800000007 | 121846.8 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 924.01 | 1322.18 | 593.75 | 938.91 | 1041.87 | 743.98 | 833.3 | 827.4399999999999 | 2676.5 | 4828.070000000001 | 6767.200000000002 | 20190.30000000002 | 58268.81999999996 | 308532.3400000004 | 139450.4999999999 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 360 | 854.13 | 1294.05 | 717.25 | 739.33 | 421.59 | 1384.66 | 1121.99 | 2101.15 | 2811.58 | 3639.7 | 7026.690000000001 | 30779.7 | 39725.29000000011 | 302973.8700000006 | 117239.2999999999 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 225 | 928.87 | 859.2700000000001 | 1331.09 | 1112.87 | 888.98 | 498.64 | 933.12 | 746.04 | 1749.25 | 3271.09 | 5356.61 | 12324.61 | 19204.57000000001 | 47259.96000000001 | 294452.4900000007 | 150267.8899999998 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 388 | 145 | 687.78 | 1050.63 | 967.5 | 1189.87 | 310 | 849.7 | 1057.92 | 1526.05 | 2244.05 | 3801.739999999999 | 7665.599999999999 | 25460.34999999999 | 35584.85999999992 | 45892.76000000006 | 233887.9399999993 | 97940.76999999992 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 65 | 90 | 112 | 140 | 392.91 | 935.6500000000001 | 502.8 | 555.74 | 787.65 | 1143.64 | 1716.19 | 2278.83 | 2752.87 | 4769.910000000001 | 7292.740000000002 | 15389.10000000001 | 26608.68 | 182361.4199999997 | 108979.2199999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 80 | 90 | 639.69 | 405 | 300 | 576.31 | 1019.34 | 539.85 | 910.7900000000001 | 1467.03 | 2119.26 | 3764.25 | 4407.450000000001 | 6072.739999999998 | 11166.06 | 14303.06999999999 | 22413.03999999999 | 166234.5599999996 | 92862.4699999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 140 | 446.22 | 180 | 851.76 | 647 | 258.6 | 130 | 437.8700000000001 | 318.65 | 851.19 | 317.83 | 1333.39 | 1721.06 | 2304.54 | 2711.719999999999 | 4933.36 | 9322.710000000005 | 11395.11 | 17331.17000000001 | 197791.5399999997 | 112813.2599999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 25 | 65 | 93.50999999999999 | 236.33 | 50 | 230.97 | 371.91 | 406.72 | 948 | 993.87 | 1720.34 | 2087.31 | 1521.38 | 4014.08 | 4395.67 | 3072.01 | 7933.25 | 10304.93 | 22609.89 | 264630.4999999995 | 147984.5799999998 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 53.6 | 15 | 0 | 14.94 | 18 | 440.91 | 120 | 110 | 105 | 480.15 | 190.86 | 368 | 955.0699999999999 | 2645.29 | 9021.32 | 12615.82 | 7447.74 | 7626.36 | 7812.13 | 14518.61 | 23256.33000000001 | 228782.8200000003 | 98781.18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 12 | 160 | 355.94 | 372 | 0 | 178.5 | 50 | 72.31 | 0 | 968.1 | 591 | 1212.58 | 1216.17 | 1652.75 | 2256.78 | 3774.59 | 35272.26000000001 | 32195.07 | 28814.87 | 23786.36 | 14823.88 | 37104.27999999998 | 301355.3700000006 | 105170.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 12 | 105 | 148.25 | 170 | 0 | 145 | 281.17 | 20 | 350 | 333.83 | 933.8200000000002 | 220 | 713.1800000000001 | 923.72 | 957.3100000000001 | 2041.82 | 1048.72 | 1871.04 | 3388.09 | 4821.46 | 7484.180000000001 | 29549.29 | 55589.45999999998 | 303879.3700000006 | 128375.1999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 20 | 0 | 50 | 49 | 199.46 | 80 | 74.47 | 455.09 | 315.76 | 68.84 | 399.83 | 37.04 | 1218.12 | 940.79 | 1416.63 | 1973.54 | 2887.76 | 2473.44 | 2432.75 | 2668.11 | 7946.709999999999 | 17509.96 | 19061.91 | 20523.67000000001 | 255412.2500000003 | 77537.31999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 210 | 0 | 230.39 | 150 | 72 | 225 | 99 | 137 | 135 | 112.94 | 90 | 82.03999999999999 | 472.1899999999999 | 721.2 | 776.05 | 839.63 | 1155.47 | 1074.93 | 1740.02 | 1534.68 | 1665.54 | 7923.850000000001 | 20265.41 | 16091.02 | 33230.24999999999 | 324343.8399999999 | 125087.71 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 37.5 | 0 | 105.92 | 0 | 20 | 0 | 30 | 60.49 | 0 | 0 | 193.5 | 66.76 | 532.87 | 208.17 | 107.18 | 936.2099999999999 | 434.99 | 634.5999999999999 | 723.29 | 1235.13 | 1573.51 | 5026.83 | 8608.579999999998 | 6310.349999999999 | 15479.32 | 32876.71999999999 | 325947.2100000003 | 101833.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 131.5 | 0 | 0 | 80 | 0 | 334.08 | 200 | 42.61 | 191.97 | 227.51 | 315.46 | 569.72 | 348.35 | 603.31 | 511.5 | 626.67 | 427.18 | 739.2099999999999 | 1311.33 | 1694.81 | 3299.92 | 4786.33 | 6120.650000000001 | 27333.18999999999 | 33138.48000000001 | 327536.8 | 136843.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 10 | 0 | 0 | 0 | 0 | 25 | 0 | 0 | 217.38 | 42.61 | 20 | 134.51 | 531.3000000000001 | 302.76 | 358.3 | 415 | 20 | 396.38 | 624.39 | 309.53 | 794.8199999999999 | 1486.88 | 2132.15 | 1737.18 | 4634.210000000001 | 9649.16 | 17766.09 | 28150.72999999999 | 299845.6900000006 | 97219.13999999994 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 10 | 100 | 270 | 0 | 5 | 30 | 10 | 112.5 | 10.08 | 45 | 20 | 114.47 | 87.47 | 100.9 | 140.56 | 453.65 | 50 | 417.73 | 168.41 | 299.53 | 521.8599999999999 | 404.52 | 702.6000000000001 | 1148.94 | 3403.309999999999 | 4594.93 | 10704.87 | 15497.66 | 27256.91 | 277960.3200000002 | 107730.92 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 10 | 15 | 0 | 10 | 0 | 50 | 15 | 94.57 | 45 | 0 | 20 | 70 | 45 | 275.03 | 341.86 | 92.28 | 45 | 102.59 | 148.14 | 836.45 | 250.74 | 204.36 | 679.45 | 999.98 | 1661.31 | 3279.59 | 5041.95 | 8198.02 | 12295.05 | 22297.28 | 220797.4900000001 | 122806.12 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 125 | 0 | 30 | 10 | 0 | 10 | 75 | 50 | 25 | 0 | 168.79 | 90 | 164.2 | 160.95 | 81.97999999999999 | 71.36 | 0 | 103.17 | 450.98 | 214.56 | 432.8 | 464 | 1484.16 | 2289.82 | 4984.73 | 3895.85 | 6521.25 | 7978.1 | 14860.04 | 231444.2000000004 | 98936.94000000002 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 20 | 0 | 0 | 0 | 40 | 50 | 0 | 0 | 25 | 7.04 | 501.92 | 20 | 0 | 55.46 | 481.68 | 25 | 0 | 230.75 | 30 | 240 | 700.84 | 998.2500000000001 | 1105.45 | 2065.74 | 2974.58 | 3832.58 | 4641.36 | 6821.410000000001 | 9778.19 | 18684.92 | 364299.7400000004 | 148480.45 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 10 | 10 | 330 | 65.82 | 50 | 131.28 | 200 | 7.04 | 150 | 0 | 140.21 | 362.37 | 86.7 | 0 | 125 | 116.31 | 123.42 | 248.08 | 472.35 | 715.7900000000001 | 1154.05 | 1653.92 | 3010.44 | 2164.14 | 3296.53 | 2764.32 | 5011.15 | 8773.449999999999 | 19070.06 | 324792.0599999998 | 126582.51 | 0
 |  |  |  |  | 0 | 10 | 0 | 0 | 0 | 33.12 | 68.34 | 15.67 | 0 | 170 | 0 | 7.04 | 0 | 0 | 0 | 10 | 77.00999999999999 | 25 | 161.55 | 103.58 | 20 | 25 | 326.54 | 71 | 563.9200000000001 | 257.52 | 1186.43 | 897.26 | 2113 | 2705.309999999999 | 2807.07 | 5257.949999999999 | 10244.74 | 25981.78999999999 | 381095.2100000001 | 145330.6100000001
 |  | Total Cash Collections
 |  | Over (Under) Collected
 |  | TTM Over (Under)
 |  | TTM Over (Under) % of Net Rev