Spreadsheet: 225242d1364931151-data-challenge-turning-massive-amounts-of-sales-order-data-into-summarized-customer-data-eforum-example-solution
Sheet: Data

Account | Sales Orders | JAN | FEB | MAR | 2012 | 2011 | 2010
100000 | SO-1346450 |  |  |  |  |  | 292.62
100000 | SO-1671557 |  |  |  | 990.84
100000 | SO-1744401 |  |  |  | 544.17
100005 | SO-1251183 |  |  |  |  |  | 572.01
100005 | SO-1348546 |  |  |  |  |  | 252.91
100005 | SO-1361448 |  |  |  |  |  | 287.21
100005 | SO-1367080 |  |  | 120.88 |  |  | 120.88
100005 | SO-1380111 |  |  | 209.07 |  |  | 209.07
100005 | SO-1510861 |  |  |  |  | 283.32
100005 | SO-1530250 |  |  |  |  | 35.85
100005 | SO-1543553 |  |  |  |  | 579.17
100005 | SO-1550212 |  |  |  |  | -11.95
100005 | SO-1553796 |  |  |  |  | 138.75
100005 | SO-1562380 |  |  |  |  | 213.34
100005 | SO-1564726 |  |  |  |  | 418.72
100005 | SO-1585660 |  |  |  |  | 541.55
100005 | SO-1588637 |  |  |  |  | 145.31
100005 | SO-1599173 |  |  |  |  | 903.93
100005 | SO-1735918 |  |  |  | 231
100005 | SO-1801910 |  |  |  | 763.45
100005 | SO-1817581 |  |  |  | 514.37
100005 | SO-1821287 |  |  |  | 339.26
100010 | SO-1190343 |  |  |  |  |  | 332.7
100010 | SO-1196675 |  |  |  |  |  | 244.85
100010 | SO-1206620 |  |  |  |  |  | 305.25
100010 | SO-1207179 |  |  |  |  |  | 27.4
100010 | SO-1211869 |  |  |  |  |  | 68.5
100010 | SO-1220126 |  |  |  |  |  | 132.55
100010 | SO-1228185 |  |  |  |  |  | 137.05
100010 | SO-1236216 |  |  |  |  |  | 211.26
100010 | SO-1249241 |  |  |  |  |  | 54.75
100010 | SO-1258479 |  |  |  |  |  | 120.5
100010 | SO-1263749 |  |  |  |  |  | 619.6
100010 | SO-1265995 |  |  |  |  |  | 196.1
100010 | SO-1268091 |  |  |  |  |  | 142.6
100010 | SO-1270502 |  |  |  |  |  | 152.9
100010 | SO-1273730 |  |  |  |  |  | 76.45
100010 | SO-1281052 |  |  |  |  |  | 236.5
100010 | SO-1282756 |  |  |  |  |  | 410.6
100010 | SO-1285538 |  |  |  |  |  | 172.75
100010 | SO-1290904 |  |  |  |  |  | 733.6
100010 | SO-1294806 |  |  |  |  |  | 304
100010 | SO-1294816 |  |  |  |  |  | 419.7
100010 | SO-1302097 |  |  |  |  |  | 126.4
100010 | SO-1302766 |  |  |  |  |  | 118.5
100010 | SO-1311441 |  |  |  |  |  | 347.65
100010 | SO-1316087 |  |  |  |  |  | 307.45
100010 | SO-1317370 |  |  |  |  |  | 401.55
100010 | SO-1318942 |  |  |  |  |  | 116.3
100010 | SO-1325094 |  |  |  |  |  | 296.8
100010 | SO-1326536 |  |  |  |  |  | 286.8
100010 | SO-1333021 |  |  |  |  |  | 319.35
100010 | SO-1337941 |  |  |  |  |  | 240.7
100010 | SO-1340406 |  |  |  |  |  | 257.85
100010 | SO-1342243 |  |  |  |  |  | 356.3
100010 | SO-1345131 |  |  |  |  |  | 315.45
100010 | SO-1348013 |  |  |  |  |  | 154.45
100010 | SO-1348609 |  |  |  |  |  | 520.65
100010 | SO-1350863 |  |  |  |  |  | 74.25
100010 | SO-1356293 |  |  |  |  |  | 320.05
100010 | SO-1360682
100010 | SO-1362012 |  |  |  |  |  | 525.25
100010 | SO-1362828 |  |  |  |  |  | 371.9
100010 | SO-1364731 |  |  | 402.25 |  |  | 402.25
100010 | SO-1367476 |  |  | 152.15 |  |  | 152.15
100010 | SO-1368901 |  |  | 153.5 |  |  | 153.5
100010 | SO-1372403 |  |  | 227.3 |  |  | 227.3
100010 | SO-1374409 |  |  | 538.15 |  |  | 538.15
100010 | SO-1375403 |  |  | 223 |  |  | 223
100010 | SO-1376708 |  |  | 620.1 |  |  | 620.1
100010 | SO-1377442 |  |  | 637.85 |  |  | 637.85
100010 | SO-1378744 |  |  | 271.35 |  |  | 271.35
100010 | SO-1378929 |  |  | -119.4 |  |  | -119.4
100010 | SO-1379773 |  |  | 78.15 |  |  | 78.15
100010 | SO-1379784 |  |  | 198.85 |  |  | 198.85
100010 | SO-1381530 |  |  | -113.4 |  |  | -113.4
100010 | SO-1381725 |  |  | 193.5 |  |  | 193.5
100010 | SO-1382391 |  |  | 165.95 |  |  | 165.95
100010 | SO-1383316 |  |  | 260.05 |  |  | 260.05
100010 | SO-1385766 |  |  | 242.75 |  |  | 242.75
100010 | SO-1386685 |  |  | 180.9 |  |  | 180.9
100010 | SO-1389450 |  |  | 351.1 |  |  | 351.1
100010 | SO-1392550 |  |  | 572.5 |  |  | 572.5
100010 | SO-1394925 |  |  | 172.2 |  |  | 172.2
100010 | SO-1395720 |  |  | 69.3 |  |  | 69.3
100010 | SO-1396761 |  |  | 119.1 |  |  | 119.1
100010 | SO-1401682 |  |  | 348.6 |  |  | 348.6
100010 | SO-1409914 |  |  | 328.95 |  |  | 328.95
100010 | SO-1414465 |  |  | 228.75 |  |  | 228.75
100010 | SO-1419997 |  |  | 195.85 |  |  | 195.85
100010 | SO-1422791 |  |  | 179 |  |  | 179
100010 | SO-1425898 |  |  | 289.3 |  |  | 289.3
100010 | SO-1429956 |  |  |  |  | 353.95
100010 | SO-1434901 |  |  |  |  | 681.1
100010 | SO-1434930 |  |  |  |  | -217.3
100010 | SO-1438411 |  |  |  |  | 191.2
100010 | SO-1444977 |  |  |  |  | 433
100010 | SO-1448542 |  |  |  |  | 7.95
100010 | SO-1450885 |  |  |  |  | 269.25
100010 | SO-1453226 |  |  |  |  | 91.7
100010 | SO-1458350 |  |  |  |  | 74.25
100010 | SO-1468066 |  |  |  |  | 145.15
100010 | SO-1473706 |  |  |  |  | 455.95
100010 | SO-1475758 |  |  |  |  | 178.5
100010 | SO-1478067 |  |  |  |  | 1491.15
100010 | SO-1482723 |  |  |  |  | -1074
100010 | SO-1485884 |  |  |  |  | 51.7
100010 | SO-1502089 |  |  |  |  | 159.2
100010 | SO-1505340 |  |  |  |  | 38.3
100010 | SO-1523786 |  |  |  |  | 359.2
100010 | SO-1543188 |  |  |  |  | 68.25
100010 | SO-1556138 |  |  |  |  | 64.25
100010 | SO-1557587 |  |  |  |  | 54.6
100010 | SO-1560494 |  |  |  |  | 199.25
100010 | SO-1562789 |  |  |  |  | 274.5
100010 | SO-1563694 |  |  |  |  | 143.8
100010 | SO-1569310 |  |  |  |  | 744.45
100010 | SO-1572950 |  |  |  |  | 169.2
100010 | SO-1574427 |  |  |  |  | 256.45
100010 | SO-1578618 |  |  |  |  | 174.7
100010 | SO-1579265 |  |  |  |  | 245.5
100010 | SO-1582307 |  |  |  |  | 129
100010 | SO-1582322 |  |  |  |  | -129
100010 | SO-1583286 |  |  |  |  | 305.85
100010 | SO-1593245 |  |  |  |  | 702.56
100010 | SO-1595127 |  |  |  |  | 117
100010 | SO-1598037 |  |  |  |  | 535.8
100010 | SO-1600099 |  |  |  |  | 442.35
100010 | SO-1600986 |  | -293.05 |  |  | -293.05
100010 | SO-1601346 |  |  |  |  | 734.95
100010 | SO-1604801 |  | 379.68 |  |  | 379.68
100010 | SO-1607597 |  | 289.76 |  |  | 289.76
100010 | SO-1609852 |  | 99.76 |  |  | 99.76
100010 | SO-1609992 |  | -71.96 |  |  | -71.96
100010 | SO-1611183 |  | 809.25 |  |  | 809.25
100010 | SO-1612076 |  | 673.76 |  |  | 673.76
100010 | SO-1612121 |  | -27.8 |  |  | -27.8
100010 | SO-1616589 |  | 284.74 |  |  | 284.74
100010 | SO-1621690 |  | 430.26 |  |  | 430.26
100010 | SO-1625935 |  | 231.8 |  |  | 231.8
100010 | SO-1627980 |  | 414.95 |  |  | 414.95
100010 | SO-1629647 |  | 231.8 |  |  | 231.8
100010 | SO-1629653 |  | -231.8 |  |  | -231.8
100010 | SO-1629990 |  | 284.47 |  |  | 284.47
100010 | SO-1635893 |  | 181.34 |  |  | 181.34
100010 | SO-1643672 |  | 87.05 |  |  | 87.05
100010 | SO-1648631 |  | 216.52 |  |  | 216.52
100010 | SO-1654482 |  | 166.85 |  |  | 166.85
100010 | SO-1664619 |  | 789.8 |  |  | 789.8
100010 | SO-1666379 |  | 176.15 |  |  | 176.15
100010 | SO-1676717 |  |  |  | 255.87
100010 | SO-1683614 |  |  |  | 250.9
100010 | SO-1700617 |  |  |  | 132.4
100010 | SO-1705037 |  |  |  | 144.8
100010 | SO-1710933 |  |  |  | 157.44
100010 | SO-1734040 |  |  |  | 669.49
100010 | SO-1736264 |  |  |  | 114.92
100010 | SO-1742210 |  |  |  | 98.45
100010 | SO-1743499 |  |  |  | 439.9
100010 | SO-1757795 |  |  |  | 3348.48
100010 | SO-1765039 |  |  |  | 52.36
100010 | SO-1782070 |  |  |  | 225.71
100010 | SO-1784252 |  |  |  | 212.12
100010 | SO-1795828 |  |  |  | 324.3
100010 | SO-1798705 |  |  |  | 250.8
100010 | SO-1800961 |  |  |  | 376.65
100010 | SO-1803678 |  |  |  | 353.7
100010 | SO-1804570 |  |  |  | 366.24
100010 | SO-1808381 |  |  |  | 688.43
100010 | SO-1810416 |  |  |  | 274.88
100010 | SO-1820728 |  |  |  | 221.9
100010 | SO-1826895 |  |  |  | 860.95
100010 | SO-1830595 |  |  |  | 222.08
100010 | SO-1833449 | 277.16 |  |  | 277.16
100010 | SO-1838481 | 328.5 |  |  | 328.5
100010 | SO-1839816 | 351.65 |  |  | 351.65
100010 | SO-1841968 | 382.91 |  |  | 382.91
100010 | SO-1843460 | 349.4 |  |  | 349.4
100010 | SO-1845454 | 1969.88 |  |  | 1969.88
100010 | SO-1848313 | 463.63 |  |  | 463.63
100010 | SO-1851841 | 350.34 |  |  | 350.34
100010 | SO-1856340 | 518.53 |  |  | 518.53
100010 | SO-1862056 | 2799.2 |  |  | 2799.2
100010 | SO-1889729 | 172.16 |  |  | 172.16
100018 | SO-1300575
100018 | SO-1310280 |  |  |  |  |  | 18.44
100018 | SO-1314582 |  |  |  |  |  | 20.5
100018 | SO-1314594 |  |  |  |  |  | -18.44