Spreadsheet: 217778d1362177197-if-formula-unable-to-create-correct-formula-arcustsaleshistory_with-total-sales-formulas_courtfile_1
Sheet: Sheet1

CustomerName | State | SalespersonNo | FiscalYear | DollarsSold | CostOfGoodsSold | Total $ [NAME] | Column1 | 2011 | 2012 | 2013
B & G Electric - Windfield,AL | AL | KLB | 2011 | 670.49 | 563.55 | 670.49
B & G Electric - Windfield,AL | AL | KLB | 2011 | 4646 | 4166.43 | 5316.49 |  | 5986.98 | 0 | 0
BAR S, INC | AL | SER | 2012 | 600 | 0 | 600
The Salvation Army,[NAME]. | MS | SER | 2011 | 191.25 | 30 | 191.25
The Salvation Army,[NAME]. | MS | SER | 2011 | 0 | 74.01 | 191.25 |  | 2859.25 | 4641.75 | 0
The Salvation Army,[NAME]. | MS | SER | 2011 | 0 | 30 | 191.25
The Salvation Army,[NAME]. | MS | SER | 2011 | 951.5 | 373.98 | 1142.75
The Salvation Army,[NAME]. | MS | SER | 2011 | 0 | 320.73 | 1142.75
The Salvation Army,[NAME]. | MS | SER | 2012 | 404.5 | 56.6 | 1547.25
The Salvation Army,[NAME]. | MS | SER | 2012 | 0 | 0 | 1547.25
The Salvation Army,[NAME]. | MS | SER | 2012 | 0 | 30 | 1547.25
4 D Solutions | MS | SER | 2012 | 600 | 0 | 600
4 D Solutions | MS | SER | 2012 | 649.25 | 163.96 | 1249.25
4 D Solutions | MS | SER | 2013 | 1366.65 | 340.48 | 2615.9
A & A Farms | AL | SER | 2011 | 853.9 | 164.48 | 853.9
A & A Farms | AL | SER | 2011 | 0 | 0 | 853.9 |  | 7347.269999999999 | 0 | 0
A & A Farms | AL | SER | 2011 | 0 | 0 | 853.9
A & A Farms | AL | SER | 2011 | 0 | 0 | 853.9
A & A Farms | AL | SER | 2011 | 0 | 0 | 853.9
A & A Farms | AL | SER | 2011 | 0 | 0 | 853.9
A & A Farms | AL | SER | 2011 | 0 | 0 | 853.9
A & A Farms | AL | SER | 2011 | 0 | 0 | 853.9
A & A Farms | AL | SER | 2011 | -561.86 | 0 | 292.04
A & A Farms | AL | SER | 2011 | -68.01 | 0 | 224.03
A/C Power | LA | SER | 2012 | 1287.99 | 57.64 | 1287.99
AAA Cooper Transportation | AL | JM | 2011 | 570 | 105.69 | 570
AAA Cooper Transportation | AL | JM | 2011 | 0 | 0 | 570 |  | 4667.12 | 260447.58 | 78701.71999999999
AAA Cooper Transportation | AL | JM | 2011 | 1193.56 | 670.95 | 1763.56
AAA Cooper Transportation | AL | JM | 2011 | 0 | 0 | 1763.56
AAA Cooper Transportation | AL | JM | 2012 | 570 | 115 | 2333.56
AAA Cooper Transportation | AL | JM | 2012 | 1389.9 | 456.98 | 3723.46
AAA Cooper Transportation | AL | JM | 2012 | 0 | 0 | 3723.46
AAA Cooper Transportation | AL | JM | 2012 | 0 | 0 | 3723.46
AAA Cooper Transportation | AL | JM | 2012 | 0 | 0 | 3723.46
AAA Cooper Transportation | AL | JM | 2012 | 430 | 321.6 | 4153.46
AAA Cooper Transportation | AL | JM | 2012 | 39639 | 34776.74 | 43792.46
AAA Cooper Transportation | AL | JM | 2012 | 1177.81 | 769.27 | 44970.27
AAA Cooper Transportation | AL | JM | 2012 | 26632 | 0 | 71602.26999999999
AAA Cooper Transportation | AL | JM | 2012 | 7099.45 | 5000.9 | 78701.71999999999
AAA Cooper Transportation | AL | JM | 2013 | 0 | 0 | 78701.71999999999
Army Aviation Credit Union | AL | JM | 2011 | 486.55 | 311.63 | 486.55
Army Aviation Credit Union | AL | JM | 2011 | 124.25 | 272.7 | 610.8 |  | 18713.57 | 111398.71 | 13857.28
Army Aviation Credit Union | AL | JM | 2011 | 636.75 | 370.68 | 1247.55
Army Aviation Credit Union | AL | JM | 2011 | 0 | 160.57 | 1247.55
Army Aviation Credit Union | AL | JM | 2011 | 0 | 108.47 | 1247.55
Army Aviation Credit Union | AL | JM | 2011 | 366.07 | 115.04 | 1613.62
Army Aviation Credit Union | AL | JM | 2011 | 347.95 | 57.27 | 1961.57
Army Aviation Credit Union | AL | JM | 2011 | 0 | 0 | 1961.57
Army Aviation Credit Union | AL | JM | 2011 | 0 | 155.25 | 1961.57
Army Aviation Credit Union | AL | JM | 2011 | 250 | 175.5 | 2211.57
Army Aviation Credit Union | AL | JM | 2011 | 1952.1 | 665.38 | 4163.67
Army Aviation Credit Union | AL | JM | 2012 | 0 | 154.86 | 4163.67
Army Aviation Credit Union | AL | JM | 2012 | 0 | 0 | 4163.67
Army Aviation Credit Union | AL | JM | 2012 | 3135.06 | 1797.26 | 7298.73
Army Aviation Credit Union | AL | JM | 2012 | 2229.05 | 1030.67 | 9527.779999999999
Army Aviation Credit Union | AL | JM | 2012 | 1560.6 | 583.75 | 11088.38
Army Aviation Credit Union | AL | JM | 2012 | 322.5 | 44 | 11410.88
Army Aviation Credit Union | AL | JM | 2012 | 753.45 | 213.99 | 12164.33
Army Aviation Credit Union | AL | JM | 2012 | 0 | 97.75 | 12164.33
Army Aviation Credit Union | AL | JM | 2012 | 615.5 | 297.25 | 12779.83
Army Aviation Credit Union | AL | JM | 2012 | 0 | 0 | 12779.83
Army Aviation Credit Union | AL | JM | 2012 | 1077.45 | 321.03 | 13857.28
Army Aviation Credit Union | AL | JM | 2013 | 0 | 0 | 13857.28
AAP INDUSTRIAL | FL | SER | 2012 | 837.98 | 57.64 | 837.98
AB Home Solutions | CA | SER | 2012 | 500 | 0 | 500
AB Home Solutions | CA | SER | 2012 | 0 | 0 | 500
Absolute Aire, Inc. | AL | SER | 2012 | 500 | 0 | 500
Absolute Aire, Inc. | AL | SER | 2012 | 76.4 | 33.6 | 576.4
Absolute Aire, Inc. | AL | SER | 2012 | 8723 | 7668.89 | 9299.4
Action Heating and AC | AL | SER | 2012 | 500 | 0 | 500
Acme Propane | AL | SER | 2011 | 560 | 334.56 | 560
Acme Propane | AL | SER | 2011 | 0 | 0 | 560 |  | 1120 | 0 | 0
Acorn Electrical Specialist | TN | SER | 2013 | 1114.85 | 213.8 | 1114.85
Action Service Group | TN | ME | 2011 | 1498.95 | 1368.95 | 1498.95
Action Service Group | TN | ME | 2011 | 14274 | 13020.5 | 15772.95 |  | 82679.7 | 0 | 0
Action Service Group | TN | ME | 2011 | 0 | 0 | 15772.95
Action Service Group | TN | ME | 2011 | 0 | 0 | 15772.95
Action Service Group | TN | ME | 2011 | 1158 | 176 | 16930.95
Action Service Group | TN | ME | 2011 | 0 | 0 | 16930.95
Advanced Electrical -LA | LA | SER | 2013 | 500 | 0 | 500
Adkins Electrical Services | AL | SS | 2011 | 731.62 | 613.73 | 731.62
Adkins Electrical Services | AL | SS | 2011 | 0 | 0 | 731.62 |  | 4680.48 | 10591.31 | 6627.77
Adkins Electrical Services | AL | SS | 2011 | 553 | 452.75 | 1284.62
Adkins Electrical Services | AL | SS | 2011 | 648 | 563.55 | 1932.62
Adkins Electrical Services | AL | SS | 2012 | 49.15 | 29.21 | 1981.77
Adkins Electrical Services | AL | SS | 2012 | 0 | 0 | 1981.77
Adkins Electrical Services | AL | SS | 2012 | 4646 | 4166.43 | 6627.77
Adkins Electrical Services | AL | SS | 2013 | 0 | 0 | 6627.77