Spreadsheet: 273309d1382663173-help-adding-an-if-statement-117
Sheet: October 2013 Budget

 |  |  |  | Monthly $ [NAME] |  |  |  |  |  |  |  | Sales and Labor Budgets Daily Sales Tracking |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Novi, MI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Store 117
 |  |  |  |  |  |  |  |  |  |  |  | October 2013
 |  |  |  | Sales |  |  |  |  |  |  |  | Productivity |  |  |  |  |  |  |  | High Margin Items |  |  |  |  |  |  |  | Mailouts |  |  |  |  |  |  |  | Payroll |  |  |  | Budget $'s
 |  |  |  |  |  | Goals |  |  |  |  |  |  |  | 71 |  |  |  | 2 |  |  |  | 0.06 |  |  |  | 0.1 |  |  |  |  |  | 0.05
 | Date |  |  | Actual Sales |  | Daily Budget |  | % to Budget |  | $ (+/-) diff |  | Trans |  | ADT |  | Units |  | UPT |  | Travalos |  | % to Sales |  | Premier |  | % to Sales |  | In store ($'s) |  | Out of Store |  | % to Sales |  |  |  | Hours |  | Budget
 | Sunday, | 2013-10-06 00:00:00 |  | 862 |  | 1635.450098566294 |  |  |  |  |  | 12 |  |  |  | 29 |  |  |  | 3 |  |  |  | 0 |  |  |  | 0 |  | 0
 | Monday, | 2013-10-07 00:00:00 |  | 455 |  | 721.1575504104006 |  |  |  |  |  | 8 |  |  |  | 22 |  |  |  | 4 |  |  |  | 0 |  |  |  | 0 |  | 0
 | Tuesday, |  |  | 669 |  | 365.2547280443496 |  |  |  |  |  | 6 |  |  |  | 22 |  |  |  | 3 |  |  |  | 0 |  |  |  | 0 |  | 0
 | Wednesday, |  |  | 689 |  | 518.9274754410582 |  |  |  |  |  | 10 |  |  |  | 25 |  |  |  | 5 |  |  |  | 0 |  |  |  | 0 |  | 0
 | Thursday, |  |  | 664 |  | 355.4617474116716 |  |  |  |  |  | 9 |  |  |  | 22 |  |  |  | 2 |  |  |  | 0 |  |  |  | 0 |  | 0
 | Friday, |  |  | 963 |  | 1174.560270603393 |  |  |  |  |  | 13 |  |  |  | 30 |  |  |  | 1 |  |  |  | 3 |  |  |  | 0 |  | 0
 | Saturday, |  |  | 785 |  | 2100.192353345928 |  |  |  |  |  | 8 |  |  |  | 22 |  |  |  | 2 |  |  |  | 0 |  |  |  | 0 |  | 0
 | Weekly Total
 | Sunday, |  |  | 944 |  | 987.706403537354 |  |  |  |  |  | 14 |  |  |  | 29 |  |  |  | 1 |  |  |  | 0 |  |  |  | 0 |  | 0
 | Monday, |  |  | 942 |  | 634.684526442946 |  |  |  |  |  | 11 |  |  |  | 32 |  |  |  | 4 |  |  |  | 2 |  |  |  | 0 |  | 0
 | Tuesday, |  |  | 392 |  | 470.0407374594573 |  |  |  |  |  | 5 |  |  |  | 12 |  |  |  | 2 |  |  |  | 0 |  |  |  | 0 |  | 0
 | Wednesday, |  |  | 754 |  | 186.9711148387217 |  |  |  |  |  | 6 |  |  |  | 17 |  |  |  | 0 |  |  |  | 0 |  |  |  | 320.64 |  | 0
 | Thursday, |  |  | 651 |  | 529.64727180066 |  |  |  |  |  | 8 |  |  |  | 18 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  | 0
 | Friday, |  |  | 581 |  | 1214.502678497451 |  |  |  |  |  | 8 |  |  |  | 19 |  |  |  | 2 |  |  |  | 0 |  |  |  | 0 |  | 0
 | Saturday, |  |  | 1858 |  | 1824.386509404276 |  |  |  |  |  | 26 |  |  |  | 63 |  |  |  | 9 |  |  |  | 0 |  |  |  | 0 |  | 0
 | Weekly Total
 | Sunday, | 2013-10-20 00:00:00 |  | 559 |  | 747.2703043551182 |  |  |  |  |  | 7 |  |  |  | 17 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  | 0
 | Monday, |  |  | 257 |  | 538.8093477517571 |  |  |  |  |  | 5 |  |  |  | 9 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  | 0
 | Tuesday, |  |  | 1003 |  | 471.8441198678694 |  |  |  |  |  | 12 |  |  |  | 36 |  |  |  | 3 |  |  |  | 6 |  |  |  | 0 |  | 0
 | Wednesday, |  |  |  |  | 727.9411715442111
 | Thursday, |  |  |  |  | 626.7284275823039
 | Friday, |  |  |  |  | 1116.690119943355
 | Saturday, |  |  |  |  | 1968.338858122825
 | Weekly Total
 | Sunday, | 2013-10-27 00:00:00 |  |  |  | 1014.773889345348
 | Monday, |  |  |  |  | 551.706602746903
 | Tuesday, |  |  |  |  | 516.063279851227
 | Wednesday, |  |  |  |  | 538.826097433569
 | Thursday, |  |  |  |  | 731.363689861105 |  |  |  |  |  |  |  |  | 44
 | Friday, |  |  |  |  | 628.0014034000067 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 | Saturday, |  |  |  |  | 2102.699222390438
 | Weekly Total
 | Monthly Totals