sale_table.xlsx
Sheet1
| | SaleID | CustomerID | EmployeeID | SaleDate | SubTotal | Tax | Total |
| 1 | 1 | 1 | 1 | 12/14/13 | $3,500.00 | $290.50 | $3,790.00 |
| 2 | 2 | 2 | 1 | 12/15/13 | $1,000.00 | $83.00 | $1,083.00 |
| 3 | 3 | 3 | 1 | 12/15/13 | $50.00 | $4.15 | $54.15 |
| 4 | 4 | 4 | 3 | 12/23/13 | $45.00 | $3.74 | $48.74 |
| 5 | 5 | 1 | 5 | 1/5/14 | $250.00 | $20.75 | $270.75 |
| 6 | 6 | 5 | 5 | 1/10/14 | $750.00 | $62.25 | $812.25 |
| 7 | 7 | 6 | 4 | 1/12/14 | $250.00 | $20.75 | $270.75 |
| 8 | 8 | 2 | 1 | 1/15/14 | $3,000.00 | $249.00 | $249.00 |
| 9 | 9 | 5 | 5 | 1/25/14 | $350.00 | $29.05 | $379.05 |
| 10 | 10 | 7 | 1 | 2/4/14 | $4,250.00 | $1,182.00 | $15,432.75 |
| 11 | 11 | 8 | 5 | 2/4/14 | $250.00 | $20.75 | $270.75 |
| 12 | 12 | 5 | 4 | 2/7/14 | $50.00 | $4.15 | $54.15 |
| 13 | 13 | 9 | 2 | 2/7/14 | $4,500.00 | $373.50 | $4,873.50 |
| 14 | 14 | 10 | 3 | 2/11/14 | $3,675.00 | $305.03 | $3,980.03 |
| 15 | 15 | 2 | 2 | 2/11/14 | $800.00 | $66.40 | $866.40 |
hadeln
