Spreadsheet: 147456d1332800371-matching-and-indexing-multiple-columns-testbudgetdata
Sheet: Full Year By Month

 | January | Last January | YTD January | YTD Last January | February | Last February | YTD February | YTD Last February | March | Last March | YTD March | YTD Last March |  | Department
Revenues
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 363325 | 172269 | 363325 | 172269 | 363325 | 172269 | 363325 | 172269 | 363325 | 172269 | 363325 | 172269 |  | 10
Sls New | 75429 | 74256 | 75429 | 74256 | 75429 | 74256 | 75429 | 74256 | 75429 | 74256 | 75429 | 74256 |  | 10
Sls New | 35403 | 0 | 35403 | 0 | 35403 | 0 | 35403 | 0 | 35403 | 0 | 35403 | 0 |  | 10
Sls New | 10604 | 0 | 10604 | 0 | 10604 | 0 | 10604 | 0 | 10604 | 0 | 10604 | 0 |  | 10
Sls New | 0 | 28169 | 0 | 28169 | 0 | 28169 | 0 | 28169 | 0 | 28169 | 0 | 28169 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 2224 | 0 | 2224 | 0 | 2224 | 0 | 2224 | 0 | 2224 | 0 | 2224 | 0 |  | 10
Sls New | 168 | 64 | 168 | 64 | 168 | 64 | 168 | 64 | 168 | 64 | 168 | 64 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 10364.8 | 0 | 10364.8 | 0 | 10364.8 | 0 | 10364.8 | 0 | 10364.8 | 0 | 10364.8 | 0 |  | 10
Sls New | 0 | 209.95 | 0 | 209.95 | 0 | 209.95 | 0 | 209.95 | 0 | 209.95 | 0 | 209.95 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 173414.71 | 304201.08 | 173414.71 | 304201.08 | 173414.71 | 304201.08 | 173414.71 | 304201.08 | 173414.71 | 304201.08 | 173414.71 | 304201.08 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Sls New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | -235.33 | 0 | 0 | 0 | -235.33 | 0 | 0 | 0 | -235.33 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | -41.36 | 0 | 0 | 0 | -41.36 | 0 | 0 | 0 | -41.36 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | -354.48 | 0 | 0 | 0 | -354.48 | 0 | 0 | 0 | -354.48 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | -105 | 0 | 0 | 0 | -105 | 0 | 0 | 0 | -105 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | -43.11 | 0 | 0 | 0 | -43.11 | 0 | 0 | 0 | -43.11 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | -1264.249999998 | 0 | 0 | 0 | -1264.249999998 | 0 | 0 | 0 | -1264.249999998 | 0 | 0 | 0 |  | 10
Disc New | -12.99 | 0 | 0 | 0 | -12.99 | 0 | 0 | 0 | -12.99 | 0 | 0 | 0 |  | 10
Disc New | -18.56 | 0 | 0 | 0 | -18.56 | 0 | 0 | 0 | -18.56 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Disc New | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Total Revenues | 668857.430000002 | 579169.03 | 670932.51 | 579169.03 | 668857.430000002 | 579169.03 | 670932.51 | 579169.03 | 668857.430000002 | 579169.03 | 670932.51 | 579169.03
Cost of Sales
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 293363.329999999 | 138164.19 | 293363.329999999 | 138164.19 | 293363.329999999 | 138164.19 | 293363.329999999 | 138164.19 | 293363.329999999 | 138164.19 | 293363.329999999 | 138164.19 |  | 10
[NAME] | 61427.91 | 60871.41 | 61427.91 | 60871.41 | 61427.91 | 60871.41 | 61427.91 | 60871.41 | 61427.91 | 60871.41 | 61427.91 | 60871.41 |  | 10
[NAME] | 31972.83 | 0 | 31972.83 | 0 | 31972.83 | 0 | 31972.83 | 0 | 31972.83 | 0 | 31972.83 | 0 |  | 10
[NAME] | 8312.24 | 0 | 8312.24 | 0 | 8312.24 | 0 | 8312.24 | 0 | 8312.24 | 0 | 8312.24 | 0 |  | 10
[NAME] | 0 | 28169 | 0 | 28169 | 0 | 28169 | 0 | 28169 | 0 | 28169 | 0 | 28169 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 328 | 0 | 328 | 0 | 328 | 0 | 328 | 0 | 328 | 0 | 328 | 0 |  | 10
[NAME] | 3784 | 1040 | 3784 | 1040 | 3784 | 1040 | 3784 | 1040 | 3784 | 1040 | 3784 | 1040 |  | 10
[NAME] | 328 | 624 | 328 | 624 | 328 | 624 | 328 | 624 | 328 | 624 | 328 | 624 |  | 10
[NAME] | 80 | 0 | 80 | 0 | 80 | 0 | 80 | 0 | 80 | 0 | 80 | 0 |  | 10
[NAME] | 104 | 0 | 104 | 0 | 104 | 0 | 104 | 0 | 104 | 0 | 104 | 0 |  | 10
[NAME] | 0 | 80 | 0 | 80 | 0 | 80 | 0 | 80 | 0 | 80 | 0 | 80 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 13933.13 | -866.3 | 13933.13 | -866.3 | 13933.13 | -866.3 | 13933.13 | -866.3 | 13933.13 | -866.3 | 13933.13 | -866.3 |  | 10
[NAME] | 0 | 606.39 | 0 | 606.39 | 0 | 606.39 | 0 | 606.39 | 0 | 606.39 | 0 | 606.39 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 140170.7 | 250451.12 | 140170.7 | 250451.12 | 140170.7 | 250451.12 | 140170.7 | 250451.12 | 140170.7 | 250451.12 | 140170.7 | 250451.12 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Total Cost of Sales | 553804.1399999991 | 479139.8100000001 | 553804.1399999991 | 479139.8100000001 | 553804.1399999991 | 479139.8100000001 | 553804.1399999991 | 479139.8100000001 | 553804.1399999991 | 479139.8100000001 | 553804.1399999991 | 479139.8100000001
Gross Profit | 115053.2900000029 | 100029.22 | 117128.3700000009 | 100029.22 | 115053.2900000029 | 100029.22 | 117128.3700000009 | 100029.22 | 115053.2900000029 | 100029.22 | 117128.3700000009 | 100029.22
Expenses
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Expenses | 10997.6 | 11612.98 | 10997.6 | 11612.98 | 10997.6 | 11612.98 | 10997.6 | 11612.98 | 10997.6 | 11612.98 | 10997.6 | 11612.98 |  | 10
Expenses | 34.15 | 386.05 | 34.15 | 386.05 | 34.15 | 386.05 | 34.15 | 386.05 | 34.15 | 386.05 | 34.15 | 386.05 |  | 11
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 20
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 21
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 50
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 80
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 83
Expenses | 2907.81 | 3243.03 | 2907.81 | 3243.03 | 2907.81 | 3243.03 | 2907.81 | 3243.03 | 2907.81 | 3243.03 | 2907.81 | 3243.03 |  | 10
Expenses | 1634.94 | 2263.37 | 1634.94 | 2263.37 | 1634.94 | 2263.37 | 1634.94 | 2263.37 | 1634.94 | 2263.37 | 1634.94 | 2263.37 |  | 80
Expenses | 1255.04 | 2163.09 | 1255.04 | 2163.09 | 1255.04 | 2163.09 | 1255.04 | 2163.09 | 1255.04 | 2163.09 | 1255.04 | 2163.09 |  | 10
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 80
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 83
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 80
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 83
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Expenses | 12309.18 | 8250.08 | 12309.18 | 8250.08 | 12309.18 | 8250.08 | 12309.18 | 8250.08 | 12309.18 | 8250.08 | 12309.18 | 8250.08 |  | 0
Expenses | 742.6 | 552.33 | 742.6 | 552.33 | 742.6 | 552.33 | 742.6 | 552.33 | 742.6 | 552.33 | 742.6 | 552.33 |  | 10
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 11
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 20
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 21
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 50
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 80
Expenses | 50 | 0 | 50 | 0 | 50 | 0 | 50 | 0 | 50 | 0 | 50 | 0 |  | 83
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Expenses | -1050 | 0 | -1050 | 0 | -1050 | 0 | -1050 | 0 | -1050 | 0 | -1050 | 0 |  | 0
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 11
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 20
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 21
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 50
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 80
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 83
Expenses | 4.99 | -0.76 | 4.99 | -0.76 | 4.99 | -0.76 | 4.99 | -0.76 | 4.99 | -0.76 | 4.99 | -0.76 |  | 0
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 11
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 20
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 21
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 50
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 80
Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 83
Total Expenses | 28886.31 | 28470.17 | 28886.31 | 28470.17 | 28886.31 | 28470.17 | 28886.31 | 28470.17 | 28886.31 | 28470.17 | 28886.31 | 28470.17
Net Income | 86166.98000000295 | 71559.04999999997 | 88242.06000000093 | 71559.04999999997 | 86166.98000000295 | 71559.04999999997 | 88242.06000000093 | 71559.04999999997 | 86166.98000000295 | 71559.04999999997 | 88242.06000000093 | 71559.04999999997