Spreadsheet: 99227d1297939107-conditional-formula-nsd3-help
Sheet: Sheet1

Cust No. | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Total 2010 | Proposed Class
15069012 | 0 | 0 | 0 | 0 | 398.6 | 187.9 | 373.3 | 134.8 | 292.4 | 242.8 | 219.77 | 0 | 1849.57
15069013 | 0 | 0 | 0 | 0 | 330.7 | 88.6 | 199.35 | 289.65 | 66.35 | 242.4 | 158.2 | 0 | 1375.25
15069014 | 0 | 0 | 0 | 0 | 316.9 | 153 | 321.2 | 150.3 | 222.5 | 245.6 | 175.1 | 0 | 1584.6
15069015 | 0 | 0 | 0 | 0 | 19 | 0 | 19 | 19 | 19 | 19 | 0 | 19 | 114
15069016 | 0 | 0 | 0 | 0 | 142.56 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 142.56
15069017 | 0 | 0 | 0 | 0 | 318 | 0 | 199.5 | 0 | 612.2 | 335.57 | 316 | 770.25 | 2551.52
15069018 | 0 | 0 | 0 | 0 | 179.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 179.5
15069019 | 0 | 0 | 0 | 0 | 343.4 | 159.8 | 136.9 | 0 | 336.4 | 358.07 | 645.61 | 892.44 | 2872.62
15069020 | 0 | 0 | 0 | 0 | 519.7 | 155.5 | 50.7 | 200.2 | 227 | 406.4 | 675.51 | 660.97 | 2895.98
15069021 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
15069022 | 0 | 0 | 0 | 0 | 71.4 | 92.2 | 70 | 262.3 | 303.9 | 255.7 | 270.5 | 440.7 | 1766.7
15069023 | 0 | 0 | 0 | 0 | 66.45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 66.45
15069024 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25.3 | 25.3
15069025 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
15069026 | 0 | 0 | 0 | 0 | 167 | 49.1 | 0 | 0 | 0 | 0 | 0 | 0 | 216.1
15069027 | 0 | 0 | 0 | 0 | 335.3 | 46.1 | 303 | 0 | 0 | 187.6 | 356.87 | 180.9 | 1409.77
15069028 | 0 | 0 | 0 | 0 | 78.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 78.1
15069029 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 414.1 | 793.2 | 1207.3
15069030 | 0 | 0 | 0 | 0 | 251.2 | 184.4 | 0 | 108 | 128.8 | 248.67 | 477.41 | 160 | 1558.48
15069031 | 0 | 0 | 0 | 0 | 251.2 | 84.1 | 122.1 | 130.2 | 46.1 | 206.2 | 604.11 | 390.6 | 1834.61
15069032 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
15069033 | 0 | 989.9 | 1022.4 | 750.8 | 313.2 | 336.5 | 630.8 | 784.3 | 393 | 700.1 | 1141.34 | 377.25 | 7439.59
15069034 | 0 | 0 | 0 | 0 | 552.3 | 0 | 208.3 | 162.2 | 347.6 | 379.5 | 0 | 273.07 | 1922.97
15069035 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
15069036 | 0 | 0 | 0 | 0 | 111.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 111.6
15069037 | 0 | 428.2 | 559.3 | 0 | 284.6 | 179.1 | 180.9 | 0 | 0 | 0 | 0 | 0 | 1632.1
15069038 | 0 | 0 | 0 | 0 | 369.44 | 329.2 | 369.44 | 582.88 | 244.64 | 543.92 | 150.54 | 301.08 | 2891.14
15069039 | 0 | 0 | 0 | 0 | 480.6 | 350.9 | 440 | 131.7 | 251.2 | 298.27 | 848.24 | 422 | 3222.91
15069040 | 0 | 0 | 0 | 0 | 0 | 0 | 161.9 | 313.9 | 134.8 | 0 | 84.1 | 82.3 | 776.9999999999999
15069041 | 0 | 0 | 0 | 0 | 210.95 | 123.4 | 94.85 | 0 | 113.85 | 140.85 | 0 | 0 | 683.9000000000001
15069042 | 0 | 0 | 0 | 0 | 528.7 | 0 | 0 | 0 | 0 | 0 | 0 | 157.3 | 686
15069043 | 0 | 0 | 0 | 0 | 149.5 | 388.1 | 503.7 | 272.9 | 494.7 | 640.5 | 0 | 639.22 | 3088.62
15069044 | 0 | 0 | 0 | 0 | 307.1 | 0 | 312.4 | 0 | 0 | 0 | 0 | 0 | 619.5
15069045 | 0 | 0 | 0 | 0 | 415.4 | 387.6 | 144.5 | 360.4 | 336 | 467.2 | 488.07 | 258.27 | 2857.44
15069046 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15069047 | 0 | 0 | 0 | 0 | 98.2 | 0 | 74.4 | 0 | 0 | 0 | 0 | 0 | 172.6
15069048 | 0 | 0 | 0 | 0 | 465.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 465.7
15069049 | 0 | 0 | 0 | 0 | 499.6 | 470.9 | 247.5 | 619.3 | 1379.4 | 425.5 | 1132.14 | 1112.94 | 5887.280000000001
15069050 | 0 | 0 | 0 | 0 | 96.7 | 313.2 | 180.8 | 330.4 | 271.6 | 201.6 | 175.77 | 176.3 | 1746.37
15069051 | 0 | 0 | 318.7 | 598.4 | 177.5 | 171.9 | 0 | 158.6 | 333.4 | 447.5 | 217.97 | 528.37 | 2952.34
15069052 | 0 | 0 | 0 | 0 | 138.3 | 675 | 219.4 | 469.4 | 616.9 | 262.94 | 498.95 | 180.95 | 3061.84
15069053 | 0 | 0 | 0 | 0 | 811.9 | 942.1 | 365.5 | 405.3 | 997.82 | 153.9 | 1417.78 | 871.17 | 5965.47
15069054 | 0 | 0 | 0 | 0 | 291.3 | 446.6 | 269.4 | 262.5 | 230 | 224.6 | 497.47 | 543.2 | 2765.07
15069055 | 0 | 0 | 0 | 0 | 303.7 | 189 | 174.9 | 0 | 317.8 | 406.8 | 466.47 | 797.44 | 2656.11
15069056 | 0 | 0 | 0 | 0 | 324 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 324
15069057 | 0 | 0 | 0 | 0 | 380 | 222.4 | 314.2 | 436.4 | 452.5 | 412.4 | 217.01 | 878.95 | 3313.86
15069058 | 0 | 0 | 0 | 0 | 1814.3 | 741.2 | 1410.8 | 1077.9 | 1419 | 1532.87 | 1688.38 | 1247.52 | 10931.97
15069059 | 0 | 0 | 0 | 0 | 0 | 0 | 1434.4 | 802.1 | 400.2 | 847 | 405.87 | 0 | 3889.57
15069060 | 0 | 0 | 0 | 0 | 815.8 | 567.6 | 688.7 | 690.1 | 570 | 854 | 802.47 | 0 | 4988.670000000001
15069061 | 0 | 0 | 0 | 0 | 0 | 230.5 | 0 | 0 | 138.3 | 0 | 25.3 | 0 | 394.1
15069062 | 0 | 0 | 0 | 0 | 92.2 | 380 | 269.2 | 0 | 260.4 | 232.47 | 0 | 598.64 | 1832.91
15069063 | 0 | 0 | 0 | 0 | 380 | 92.2 | 134.8 | 46.1 | 222.4 | 25.3 | 119.34 | 380.57 | 1400.71
15069064 | 0 | 0 | 0 | 0 | 221.6 | 0 | 263.2 | 0 | 196 | 183.8 | 167.8 | 0 | 1032.4
15069065 | 0 | 0 | 0 | 0 | 1517.1 | 375.1 | 1272.8 | 1071.2 | 2702.7 | 1854.57 | 1178.78 | 2743.62 | 12715.87
15069066 | 0 | 0 | 0 | 0 | 678 | 777.4 | 275.2 | 400.8 | 401.4 | 0 | 0 | 421.1 | 2953.9
15069067 | 0 | 807.26 | 680 | 531.53 | 340 | 136 | 85 | 170 | 238 | 564.66 | 425 | 0 | 3977.45
15069068 | 0 | 0 | 0 | 0 | 919.7 | 0 | 175.2 | 0 | 83 | 472.24 | 0 | 0 | 1650.14
15069069 | 0 | 0 | 0 | 0 | 181.2 | 0 | 166.7 | 190.6 | 212.7 | 568.2 | 158.2 | 183.6 | 1661.2
15069070 | 0 | 0 | 0 | 0 | 998 | 0 | 574.4 | 0 | 0 | 437.3 | 508.01 | 440.67 | 2958.38
15069071 | 0 | 0 | 0 | 0 | 306.7 | 0 | 0 | 0 | 0 | 206.5 | 0 | 0 | 513.2
15069072 | 0 | 0 | 0 | 0 | 1034.2 | 695.3 | 204.7 | 637.2 | 1005.1 | 852.07 | 775.34 | 1145.71 | 6349.62
15069073 | 0 | 0 | 0 | 0 | 16057.26 | 0 | 668.9 | 0 | 0 | 0 | 3445.3 | 2513.8 | 22685.26
15069074 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
15069075 | 0 | 0 | 0 | 0 | 338 | 266.7 | 169.7 | 0 | 352.3 | 479.7 | 753.67 | 1100.27 | 3460.34
15069076 | 0 | 0 | 0 | 0 | 1125.9 | 0 | 0 | 229.5 | 342.2 | 0 | 564.57 | 677.17 | 2939.34
15069077 | 0 | 0 | 0 | 0 | 380 | 0 | 0 | 96.8 | 38 | 105.77 | 311.97 | 257.64 | 1190.18
15069078 | 0 | 0 | 0 | 0 | 138.3 | -138.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15069079 | 0 | 0 | 0 | 0 | 0 | 142.8 | 0 | 0 | 0 | 0 | 0 | 265 | 407.8
15069080 | 0 | 0 | 0 | 0 | 438.3 | 573.1 | 378.2 | 158.7 | 485.3 | 142.8 | 542.87 | 441.67 | 3160.94
15069081 | 0 | 0 | 0 | 0 | 322.5 | 416 | 403.3 | 378 | 250.8 | 331.9 | 429.57 | 570 | 3102.07
15069082 | 0 | 0 | 0 | 0 | 175.47 | 1135.67 | 1457.3 | 1454.87 | 1618.9 | 1083.97 | 1574.64 | 1061.57 | 9562.39
15069083 | 0 | 0 | 0 | 0 | 693.7 | 329.5 | 375.2 | 463.3 | 313 | 172.7 | 497.94 | 374.2 | 3219.54
15069084 | 0 | 0 | 0 | 0 | 76 | 0 | 130.2 | 0 | 0 | 0 | 0 | 0 | 206.2
15069085 | 0 | 0 | 0 | 0 | 295.1 | 0 | 69.9 | 82.3 | 0 | 0 | 158.6 | 0 | 605.9
15069086 | 0 | 0 | 0 | 0 | 559.8 | 873.1 | 676 | 766.8 | 335 | 618.6 | 680.11 | 831.01 | 5340.42
15069087 | 0 | 272 | 228.4 | 0 | 183 | 0 | 0 | 0 | 0 | 180.9 | 173.67 | 0 | 1037.97
15069088 | 0 | 0 | 0 | 0 | 135.95 | 158.15 | 161.35 | 161.35 | 326 | 156.7 | 153.7 | 0 | 1253.2
15069089 | 0 | 0 | 0 | 0 | 149.5 | 0 | 0 | 0 | 0 | 0 | 208.87 | 0 | 358.37
15069090 | 0 | 0 | 0 | 0 | 167.6 | -167.6 | 167.6 | 0 | 0 | 0 | 0 | 0 | 167.6
15069091 | 0 | 0 | 0 | 0 | 280.7 | 419.2 | 0 | 0 | 100.1 | 78.4 | 120.6 | 213.9 | 1212.9
15069092 | 0 | 0 | 0 | 0 | 285.12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 285.12
15069093 | 0 | 0 | 0 | 0 | 177.8 | 0 | 0 | 0 | 0 | 245.2 | 296.07 | 238.5 | 957.5699999999999
15069094 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
15069095 | 0 | 0 | 0 | 0 | 149 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 149
15069096 | 0 | 0 | 0 | 0 | 122.4 | 0 | 0 | 0 | 278.4 | 0 | 0 | 0 | 400.8
15069097 | 0 | 0 | 0 | 0 | 137.6 | 0 | 0 | 319.2 | 0 | 353.6 | 0 | 255.2 | 1065.6
15069098 | 0 | 0 | 0 | 0 | 177.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 177.8
15069099 | 0 | 0 | 0 | 0 | 203.6 | 162.8 | 1147.2 | 794.3 | 1238.4 | 1119.61 | 738.1 | 532.65 | 5936.66
15069100 | 0 | 0 | 0 | 0 | 0 | 0 | 107.6 | 129.75 | 0 | 227.8 | 291.05 | 0 | 756.2
15069101 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
15069102 | 0 | 0 | 0 | 0 | 0 | 298.6 | 398.6 | 75.9 | 614.1 | 811.77 | 185 | 788.97 | 3172.940000000001
15069103 | 0 | 0 | 0 | 0 | 0 | 475.7 | 1355.9 | 1750.4 | 544.1 | 639.8 | 0 | 0 | 4765.900000000001
15069104 | 0 | 0 | 0 | 0 | 0 | 84.1 | 69.9 | 87.1 | 116 | 139.7 | 185.6 | 0 | 682.4
15069105 | 0 | 0 | 0 | 0 | 0 | 297.3 | 0 | 381.1 | 92.2 | 396.07 | 325.54 | 523.51 | 2015.72
15069106 | 0 | 0 | 0 | 0 | 0 | 1152.8 | 0 | 0 | 0 | 0 | 0 | 0 | 1152.8
15069107 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
15069108 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
15069109 | 0 | 0 | 0 | 0 | 0 | 277.7 | 0 | 116.1 | 180.9 | 0 | 177.3 | 0 | 752
15069110 | 0 | 0 | 0 | 0 | 0 | 103.1 | 0 | 0 | 0 | 0 | 0 | 167.1 | 270.2
15069111 | 0 | 0 | 0 | 0 | 0 | 795.4 | 781 | 351.7 | 421.7 | 261.1 | 1491.54 | 555.57 | 4658.01