Spreadsheet: 151383d1334876970-index-and-match-formulas-exceltest
Sheet: MonthlySales

PNAME1 | pmast | PCLASS | POSTDATE | QNTY | AMT | TOTCOST | PROF
Prod1 | 6PPD | ACCEL | 2010-02-01 00:00:00 | 1675 | 3518.54 | 3350.992 | 167.548
Prod1 | 6PPD | ACCEL | 2010-03-01 00:00:00 | 4740 | 10080.54 | 9479.78 | 600.76
Prod1 | 6PPD | ACCEL | 2010-04-01 00:00:00 | 4420 | 9282.46 | 8840.446 | 442.0139999999999
Prod1 | 6PPD | ACCEL | 2010-05-01 00:00:00 | 6614 | 14109.44 | 13227.6 | 881.840000000001
Prod1 | 6PPD | ACCEL | 2010-06-01 00:00:00 | 2205 | 4629.66 | 4409.2 | 220.46
Prod1 | 6PPD | ACCEL | 2010-07-01 00:00:00 | 4630 | 10659.24 | 9259.32 | 1399.92
Prod1 | 6PPD | ACCEL | 2010-08-01 00:00:00 | 1323 | 2832.91 | 2645.52 | 187.39
Prod1 | 6PPD | ACCEL | 2010-09-01 00:00:00 | 4410 | 10143.46 | 8752.261999999999 | 1391.198
Prod1 | 6PPD | ACCEL | 2010-10-01 00:00:00 | 6393 | 13977.16 | 12727.1558 | 1250.004200000001
Prod1 | 6PPD | ACCEL | 2010-11-01 00:00:00 | 8102 | 17771.83 | 16048.93685 | 1722.89315
Prod1 | 6PPD | ACCEL | 2010-12-01 00:00:00 | 7716 | 16369.16 | 15233.786 | 1135.374
Prod1 | 6PPD | ACCEL | 2011-01-01 00:00:00 | 4630 | 10328.55 | 9243.8878 | 1084.6622
Prod1 | 6PPD | ACCEL | 2011-02-01 00:00:00 | 6063 | 13365.39 | 12042.6275 | 1322.762499999998
Prod1 | 6PPD | ACCEL | 2011-03-01 00:00:00 | 4409 | 10141.16 | 9038.86 | 1102.299999999999
Prod1 | 6PPD | ACCEL | 2011-04-01 00:00:00 | 3693 | 8347.17 | 7570.045250000001 | 777.1247499999994
Prod1 | 6PPD | ACCEL | 2011-05-01 00:00:00 | 1102 | 2369.95 | 2280.98939 | 88.96060999999963
Prod1 | 6PPD | ACCEL | 2011-06-01 00:00:00 | 3858 | 8294.81 | 7983.462865 | 311.3471349999991
Prod1 | 6PPD | ACCEL | 2011-07-01 00:00:00 | 2205 | 4739.9 | 4420.223 | 319.6769999999997
Prod1 | 6PPD | ACCEL | 2011-08-01 00:00:00 | 4630 | 9997.86 | 9166.7268 | 831.1332000000003
Prod1 | 6PPD | ACCEL | 2011-09-01 00:00:00 | 2425 | 5257.98 | 4856.7338 | 401.2461999999997
Prod1 | 6PPD | ACCEL | 2011-10-01 00:00:00 | 1323 | 2888.03 | 2674.1798 | 213.8502
Prod1 | 6PPD | ACCEL | 2011-11-01 00:00:00 | 1102 | 2369.95 | 2182.554 | 187.3959999999997
Prod1 | 6PPD | ACCEL | 2012-01-01 00:00:00 | 110 | 259.04 | 217.1531 | 41.88690000000003
Prod1 | 6PPD | ACCEL | 2012-02-01 00:00:00 | 2425 | 4993.42 | 4777.3682 | 216.0518000000003
Prod1 | 6PPD | ACCEL | 2012-03-01 00:00:00 | 21385 | 41655.92 | 42127.7014 | -471.7814000000005
Prod2 | ALCTPIOP | ACCEL | 2011-06-01 00:00:00 | 5 | 43.82 | 36.545081004 | 7.274918995999997
Prod2 | ALCTPIOP | ACCEL | 2011-08-01 00:00:00 | 55 | 248.02 | 253.3912125 | -5.371212500000013
Prod3 | ALEW100 | ACCEL | 2011-03-01 00:00:00 | 4 | 13.8 | 11.9684349939 | 1.831565006100002
Prod3 | ALEW100 | ACCEL | 2012-03-01 00:00:00 | 551 | 496.04 | 1377.875 | -881.835
Prod4 | MBPA25 | ACCEL | 2010-01-01 00:00:00 | 1709 | 6757.13 | 3417.13 | 3340
Prod4 | MBPA25 | ACCEL | 2010-02-01 00:00:00 | 1543 | 6139.82 | 3086.44 | 3053.38
Prod4 | MBPA25 | ACCEL | 2010-03-01 00:00:00 | 1488 | 5935.89 | 3348.23625 | 2587.65375
Prod4 | MBPA25 | ACCEL | 2010-04-01 00:00:00 | 2094 | 8427.11 | 4712.3325 | 3714.7775
Prod4 | MBPA25 | ACCEL | 2010-05-01 00:00:00 | 2149 | 8526.310000000001 | 4836.341249999999 | 3689.96875
Prod4 | MBPA25 | ACCEL | 2010-06-01 00:00:00 | 716 | 2932.13 | 1612.11375 | 1320.01625
Prod4 | MBPA25 | ACCEL | 2010-07-01 00:00:00 | 1378 | 5439.860000000001 | 3284.556379000001 | 2155.303621
Prod4 | MBPA25 | ACCEL | 2010-08-01 00:00:00 | 2425 | 9678.2 | 6615.078668 | 3063.121332000001
Prod4 | MBPA25 | ACCEL | 2010-09-01 00:00:00 | 1488 | 5919.360000000001 | 4047.6456 | 1871.7144
Prod4 | MBPA25 | ACCEL | 2010-10-01 00:00:00 | 1598 | 6360.27 | 4347.4712 | 2012.7988
Prod4 | MBPA25 | ACCEL | 2010-11-01 00:00:00 | 992 | 3604.52 | 2698.4304 | 906.0896
Prod4 | MBPA25 | ACCEL | 2010-12-01 00:00:00 | 1433 | 5842.2 | 3937.4156 | 1904.7844
Prod4 | MBPA25 | ACCEL | 2011-01-01 00:00:00 | 1433 | 5417.809999999999 | 3940.7225 | 1477.0875
Prod4 | MBPA25 | ACCEL | 2011-02-01 00:00:00 | 772 | 3141.55 | 2121.9275 | 1019.6225
Prod4 | MBPA25 | ACCEL | 2011-03-01 00:00:00 | 2039 | 8327.859999999999 | 5607.95125 | 2719.90875
Prod4 | MBPA25 | ACCEL | 2011-04-01 00:00:00 | 2480 | 9793.93 | 6820.481250000001 | 2973.44875
Prod4 | MBPA25 | ACCEL | 2011-05-01 00:00:00 | 1213 | 4839.09 | 3334.4575 | 1504.6325
Prod4 | MBPA25 | ACCEL | 2011-06-01 00:00:00 | 1764 | 7054.720000000001 | 4850.12 | 2204.6
Prod4 | MBPA25 | ACCEL | 2011-07-01 00:00:00 | 1213 | 4706.83 | 3334.4575 | 1372.3725
Prod4 | MBPA25 | ACCEL | 2011-08-01 00:00:00 | 1268 | 5224.9 | 3486.02375 | 1738.87625
Prod4 | MBPA25 | ACCEL | 2011-09-01 00:00:00 | 1929 | 7556.26 | 5517.011499999999 | 2039.2485
Prod4 | MBPA25 | ACCEL | 2011-10-01 00:00:00 | 2425 | 9601.03 | 6959.922200000001 | 2641.107800000001
Prod4 | MBPA25 | ACCEL | 2011-11-01 00:00:00 | 1874 | 7385.42 | 5434.339000000001 | 1951.081
Prod4 | MBPA25 | ACCEL | 2011-12-01 00:00:00 | 1488 | 6051.630000000001 | 4345.2666 | 1706.3634
Prod4 | MBPA25 | ACCEL | 2012-01-01 00:00:00 | 1764 | 7209.039999999999 | 5149.945600000001 | 2059.0944
Prod4 | MBPA25 | ACCEL | 2012-02-01 00:00:00 | 3197 | 13227.6 | 9334.2764 | 3893.323600000001
Prod4 | MBPA25 | ACCEL | 2012-03-01 00:00:00 | 2646 | 10372.65 | 7724.9184 | 2647.7316
Prod4 | MBPA25 | ACCEL | 2012-04-01 00:00:00 | 1213 | 4993.42 | 3540.5876 | 1452.8324
Prod5 | [NAME] | ACCEL | 2010-01-01 00:00:00 | 67461 | 90609.06 | 85922.0804 | 4686.979599999993
Prod5 | [NAME] | ACCEL | 2010-02-01 00:00:00 | 47619 | 65697.08 | 60829.3232 | 4867.756800000004
Prod5 | [NAME] | ACCEL | 2010-03-01 00:00:00 | 69665 | 95018.26 | 89747.06139999999 | 5271.198600000004
Prod5 | [NAME] | ACCEL | 2010-04-01 00:00:00 | 51808 | 72641.56999999999 | 67604.05900000001 | 5037.511000000001
Prod5 | [NAME] | ACCEL | 2010-05-01 00:00:00 | 68563 | 93364.81 | 88519.09920000001 | 4845.710800000001
Prod5 | [NAME] | ACCEL | 2010-06-01 00:00:00 | 49824 | 69555.13 | 64921.06079999999 | 4634.069200000002
Prod5 | [NAME] | ACCEL | 2010-07-01 00:00:00 | 47178 | 82418.97 | 61612.50735 | 20806.46265
Prod5 | [NAME] | ACCEL | 2010-08-01 00:00:00 | 52249 | 90090.98000000003 | 85129.63693 | 4961.343070000004
Prod5 | [NAME] | ACCEL | 2010-09-01 00:00:00 | 71870 | 124449.67 | 116643.203446 | 7806.466554000022
Prod5 | [NAME] | ACCEL | 2010-10-01 00:00:00 | 68563 | 117417 | 111748.9694 | 5668.030600000021
Prod5 | [NAME] | ACCEL | 2010-11-01 00:00:00 | 48986 | 84515.55 | 80181.434276 | 4334.115724000004
Prod5 | [NAME] | ACCEL | 2010-12-01 00:00:00 | 50000 | 86036.28 | 81000.53136 | 5035.748640000008
Prod5 | [NAME] | ACCEL | 2011-01-01 00:00:00 | 73193 | 126158.24 | 118572.2064 | 7586.033600000019
Prod5 | [NAME] | ACCEL | 2011-02-01 00:00:00 | 57231 | 100238.75 | 92714.89391999999 | 7523.856080000013
Prod5 | [NAME] | ACCEL | 2011-03-01 00:00:00 | 71561 | 127531.7 | 121312.4756988 | 6219.2243012
Prod5 | [NAME] | ACCEL | 2011-04-01 00:00:00 | 55027 | 105018.33 | 101228.0185488 | 3790.311451200004
Prod5 | [NAME] | ACCEL | 2011-05-01 00:00:00 | 75971 | 145582.97 | 136420.648 | 9162.322000000016
Prod5 | [NAME] | ACCEL | 2011-06-01 00:00:00 | 70106 | 133598.76 | 125992.89 | 7605.870000000017
Prod5 | [NAME] | ACCEL | 2011-07-01 00:00:00 | 70591 | 135073.65 | 126910.0036 | 8163.646400000011
Prod5 | [NAME] | ACCEL | 2011-08-01 00:00:00 | 71120 | 135662.27 | 128032.145 | 7630.125000000015
Prod5 | [NAME] | ACCEL | 2011-09-01 00:00:00 | 49383 | 94356.88 | 89065.84 | 5291.039999999999
Prod5 | [NAME] | ACCEL | 2011-10-01 00:00:00 | 71826 | 137375.25 | 129472.18972 | 7903.060280000016
Prod5 | [NAME] | ACCEL | 2011-11-01 00:00:00 | 35715 | 67350.53 | 64070.041108 | 3280.488892
Prod5 | [NAME] | ACCEL | 2011-12-01 00:00:00 | 5203 | 10992.14 | 9223.16456 | 1768.975440000001
Prod5 | [NAME] | ACCEL | 2012-01-01 00:00:00 | 53263 | 101490.97 | 96039.43071999999 | 5451.53928
Prod5 | [NAME] | ACCEL | 2012-02-01 00:00:00 | 64903 | 123069.59 | 116642.74048 | 6426.849520000002
Prod5 | [NAME] | ACCEL | 2012-03-01 00:00:00 | 49383 | 92152.28 | 87055.24479999999 | 5097.035200000006
Prod5 | [NAME] | ACCEL | 2012-04-01 00:00:00 | 24692 | 44973.84 | 42822.1504 | 2151.689600000002
Prod6 | CBSPDR25 | ACCEL | 2010-04-01 00:00:00 | 661 | 1025.14 | 873.0216 | 152.1184000000001
Prod6 | CBSPDR25 | ACCEL | 2010-05-01 00:00:00 | 772 | 1196 | 994.2746 | 201.7254
Prod6 | CBSPDR25 | ACCEL | 2010-06-01 00:00:00 | 2976 | 2267.98 | 3764.90565 | -1496.92565
Prod6 | CBSPDR25 | ACCEL | 2010-08-01 00:00:00 | 1433 | 2094.37 | 1741.08285 | 353.2871499999997
Prod6 | CBSPDR25 | ACCEL | 2010-12-01 00:00:00 | 1764 | 1251.12 | 1014.116 | 237.004
Prod6 | CBSPDR25 | ACCEL | 2011-01-01 00:00:00 | 2205 | 3086.44 | 2601.428 | 485.0120000000002
Prod6 | CBSPDR25 | ACCEL | 2011-03-01 00:00:00 | 2205 | 3306.9 | 3600.99364 | -294.0936400000001
Prod6 | CBSPDR25 | ACCEL | 2011-04-01 00:00:00 | 3307 | 4960.360000000001 | 4795.005 | 165.355
Prod6 | CBSPDR25 | ACCEL | 2011-08-01 00:00:00 | 276 | 564.93 | 482.25625 | 82.67374999999993
Prod6 | CBSPDR25 | ACCEL | 2011-09-01 00:00:00 | 772 | 1658.96 | 1350.3175 | 308.6424999999999
Prod6 | CBSPDR25 | ACCEL | 2011-10-01 00:00:00 | 55 | 112.99 | 96.45125 | 16.53874999999999
Prod6 | CBSPDR25 | ACCEL | 2011-12-01 00:00:00 | 55 | 0 | 96.45125 | -96.45125
Prod6 | CBSPDR25 | ACCEL | 2012-01-01 00:00:00 | 882 | 1631.41 | 1543.22 | 88.18999999999994
Prod6 | CBSPDR25 | ACCEL | 2012-02-01 00:00:00 | 386 | 719.25 | 675.1587499999999 | 44.09124999999999
Prod6 | CBSPDR25 | ACCEL | 2012-04-01 00:00:00 | 3582 | 6682.700000000001 | 6090.2075 | 592.4924999999998
Prod7 | 01045 | ACCEL | 2010-01-01 00:00:00 | 6233 | 16761.85 | 6179.3432 | 10582.5068
Prod7 | 01045 | ACCEL | 2010-02-01 00:00:00 | 882 | 3306.9 | 2733.704 | 573.1960000000004
Prod7 | 01045 | ACCEL | 2010-03-01 00:00:00 | 4129 | 30416.04 | 30551.3468 | -135.3068000000022
Prod7 | 01045 | ACCEL | 2010-04-01 00:00:00 | 3527 | 13668.53 | 10934.816 | 2733.714000000001
Prod7 | 01045 | ACCEL | 2010-05-01 00:00:00 | 11899 | 16625.41 | 10254.8116 | 6370.598399999999
Prod7 | 01045 | ACCEL | 2010-06-01 00:00:00 | 2105 | 8540.1 | 5642.8114875 | 2897.2885125
Prod7 | 01045 | ACCEL | 2010-07-01 00:00:00 | 1587 | 6415.400000000001 | 5526.821969999999 | 888.5780300000006
Prod7 | 01045 | ACCEL | 2010-08-01 00:00:00 | 3504 | 14892.59 | 14255.836451977 | 636.7535480229991
Prod7 | 01045 | ACCEL | 2010-09-01 00:00:00 | 3296 | 14158.49 | 10758.448 | 3400.041999999999
Prod7 | 01045 | ACCEL | 2010-10-01 00:00:00 | 948 | 3860.25 | 3141.00385 | 719.2461500000002
Prod7 | 01045 | ACCEL | 2010-11-01 00:00:00 | 246 | 978.75 | 862.6061083943999 | 116.1438916056
Prod7 | 01045 | ACCEL | 2010-12-01 00:00:00 | 705 | 2570.56 | 2178.1448 | 392.4152000000004
Prod7 | 01045 | ACCEL | 2011-01-01 00:00:00 | 529 | 2089.96 | 1613.7672 | 476.1928000000003
Prod7 | 01045 | ACCEL | 2011-02-01 00:00:00 | 2468 | 8592.310000000001 | 8132.363665415999 | 459.9463345840011
Prod7 | 01045 | ACCEL | 2011-03-01 00:00:00 | 1279 | 5235.92 | 4021.41086 | 1214.50914
Prod7 | 01045 | ACCEL | 2011-04-01 00:00:00 | 617 | 2438.29 | 1956.80296 | 481.4870400000001
Prod7 | 01045 | ACCEL | 2011-05-01 00:00:00 | 5776 | 21199.43 | 18310.08484 | 2889.345160000001
Prod7 | 01045 | ACCEL | 2011-06-01 00:00:00 | 2690 | 10125.73 | 8522.10176 | 1603.62824
Prod7 | 01045 | ACCEL | 2011-07-01 00:00:00 | 529 | 2089.96 | 1671.96864 | 417.99136
Prod7 | 01045 | ACCEL | 2011-08-01 00:00:00 | 5688 | 21064.95 | 17973.66288 | 3091.287119999999
Prod7 | 01045 | ACCEL | 2011-09-01 00:00:00 | 2822 | 10789.32 | 9030.041599999999 | 1759.278399999999
Prod7 | 01045 | ACCEL | 2011-10-01 00:00:00 | 2699 | 10205.36 | 8635.55576704 | 1569.80423296
Prod7 | 01045 | ACCEL | 2011-11-01 00:00:00 | 1235 | 4929.49 | 3950.6432 | 978.8467999999998
Prod7 | 01045 | ACCEL | 2011-12-01 00:00:00 | 2249 | 8697.16 | 7195.814400000001 | 1501.345599999999
Prod7 | 01045 | ACCEL | 2012-01-01 00:00:00 | 2425 | 9230.66 | 7760.191999999999 | 1470.468
Prod7 | 01045 | ACCEL | 2012-02-01 00:00:00 | 3395 | 12868.25 | 10863.475144 | 2004.774856
Prod7 | 01045 | ACCEL | 2012-03-01 00:00:00 | 2998 | 11757.12 | 9540.450592 | 2216.669408000001
Prod7 | 01045 | ACCEL | 2012-04-01 00:00:00 | 1675 | 6216.97 | 5331.428272 | 885.5417280000003
Prod8 | 03040 | ACCEL | 2010-01-01 00:00:00 | 8543 | 17939.93 | 11959.955 | 5979.974999999999
Prod8 | 03040 | ACCEL | 2010-02-01 00:00:00 | 8818 | 18518.65 | 12345.76 | 6172.889999999999
Prod8 | 03040 | ACCEL | 2010-03-01 00:00:00 | 8267 | 17361.23 | 11574.15 | 5787.08
Prod8 | 03040 | ACCEL | 2010-04-01 00:00:00 | 5456 | 11458.41 | 8509.833161 | 2948.576838999999
Prod8 | 03040 | ACCEL | 2010-05-01 00:00:00 | 7716 | 18518.64 | 13073.49846 | 5445.14154
Prod8 | 03040 | ACCEL | 2010-06-01 00:00:00 | 7716 | 18518.64 | 13078.7895 | 5439.8505
Prod8 | 03040 | ACCEL | 2010-07-01 00:00:00 | 5512 | 13227.6 | 9341.9925 | 3885.6075
Prod8 | 03040 | ACCEL | 2010-08-01 00:00:00 | 7826 | 18750.12 | 13265.62935 | 5484.490650000001
Prod8 | 03040 | ACCEL | 2010-09-01 00:00:00 | 5512 | 13227.6 | 9341.9925 | 3885.6075
Prod8 | 03040 | ACCEL | 2010-10-01 00:00:00 | 6614 | 15873.12 | 11212.48537 | 4660.63463
Prod8 | 03040 | ACCEL | 2010-11-01 00:00:00 | 7716 | 18518.64 | 13162.12338 | 5356.516619999999
Prod8 | 03040 | ACCEL | 2010-12-01 00:00:00 | 3307 | 7936.559999999999 | 5952.42 | 1984.14
Prod8 | 03040 | ACCEL | 2011-01-01 00:00:00 | 8818 | 21164.16 | 16314.04 | 4850.119999999999
Prod8 | 03040 | ACCEL | 2011-02-01 00:00:00 | 4409 | 10582.08 | 8181.270600000001 | 2400.809399999999
Prod8 | 03040 | ACCEL | 2011-03-01 00:00:00 | 6614 | 15873.12 | 12381.0336 | 3492.086399999997
Prod8 | 03040 | ACCEL | 2011-04-01 00:00:00 | 5512 | 13227.6 | 10317.528 | 2910.071999999998
Prod8 | 03040 | ACCEL | 2011-05-01 00:00:00 | 6614 | 15873.12 | 12235.53 | 3637.589999999999
Prod8 | 03040 | ACCEL | 2011-06-01 00:00:00 | 4409 | 10582.08 | 8157.02 | 2425.059999999999
Prod8 | 03040 | ACCEL | 2011-07-01 00:00:00 | 3307 | 7936.559999999999 | 6117.765 | 1818.795
Prod8 | 03040 | ACCEL | 2011-08-01 00:00:00 | 7716 | 18518.64 | 14274.785 | 4243.855
Prod8 | 03040 | ACCEL | 2011-09-01 00:00:00 | 8818 | 21164.16 | 16314.04 | 4850.119999999999
Prod8 | 03040 | ACCEL | 2011-10-01 00:00:00 | 2535 | 6084.7 | 4690.2865 | 1394.4135
Prod8 | 03040 | ACCEL | 2011-11-01 00:00:00 | 55 | 137.79 | 106.37195 | 31.41804999999999
Prod8 | 03040 | ACCEL | 2011-12-01 00:00:00 | 2205 | 5291.04 | 4243.855 | 1047.184999999999
Prod8 | 03040 | ACCEL | 2012-01-01 00:00:00 | 9921 | 23809.68 | 19146.951 | 4662.728999999998
Prod8 | 03040 | ACCEL | 2012-02-01 00:00:00 | 6614 | 15873.12 | 12764.634 | 3108.485999999998
Prod8 | 03040 | ACCEL | 2012-03-01 00:00:00 | 8818 | 21164.16 | 16869.5992 | 4294.560799999999
Prod8 | 03040 | ACCEL | 2012-04-01 00:00:00 | 4409 | 10582.08 | 8434.7996 | 2147.2804