Spreadsheet: 269486d1381172925-dynamic-file-paths-help-book1
Sheet: Comps

 |  | Restaurant # | 2262 |  | Year | 2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cell References
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week # | Year | Week # + Year |  | File Name |  |  |  |  |  |  |  | File Path |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | Week Ending | Weekly [NAME] | Labor Dollars | Labor % | Food Dollars | Food % | Bread % | Food % | Sides % | Paper % | Prod % | Pop % | Last Year Sales
P 1 | Week Ending | Weekly [NAME] | Labor Dollars | Labor % | Food Dollars | Food % | Bread % | Food % | Sides % | Paper % | Prod % | Pop % | Last Year Sales | Up/Down | Up/Down | Sample | Cash | Delivery | Delivery | Catering | Catering | DMR | Adjusted | Adjusted | Adjusted | Labor | Labor vs | Food | Food vs | PW | CC | Peak |  |  | Week 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $ | % | # | +/- | Sales $ | % | Sales $ | % | $ | Sales $ | Food % | Labor % | Goal | Goal | Goal | Goal | [NAME] | # | Score |  |  | Week 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Summary'!$E$2 | Gross Sales'!$H$15 | Sales Summary'!$H$18 |  | Inventory'!$K$107 |  | Sales Summary'!$B$19 | Sales Summary'!$B$20 | [NAME] | Sales Summary'!$B$22 | Sales Summary'!$B$23 | Sales Summary'!$B$24
Week 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 3
Week 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 4
Week 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 5
Week 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 6
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 8
P 2 | Week Ending | Weekly [NAME] | Labor Dollars | Labor % | Food Dollars | Food % | Bread % | Food % | Sides % | Paper % | Prod % | Pop % | Last Year Sales | Up/Down | Up/Down | Sample | Cash | Delivery | Delivery | Catering | Catering | DMR | Adjusted | Adjusted | Adjusted | Labor | Labor vs | Food | Food vs | PW | CC | Peak |  |  | Week 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $ | % | # | +/- | Sales $ | % | Sales $ | % | $ | Sales $ | Food % | Labor % | Goal | Goal | Goal | Goal | [NAME] | # | Score |  |  | Week 10
Week 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 11
Week 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 12
Week 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 13
Week 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 14
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 16
P 3 | Week Ending | Weekly [NAME] | Labor Dollars | Labor % | Food Dollars | Food % | Bread % | Food % | Sides % | Paper % | Prod % | Pop % | Last Year Sales | Up/Down | Up/Down | Sample | Cash | Delivery | Delivery | Catering | Catering | DMR | Adjusted | Adjusted | Adjusted | Labor | Labor vs | Food | Food vs | PW | CC | Peak |  |  | Week 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $ | % | # | +/- | Sales $ | % | Sales $ | % | $ | Sales $ | Food % | Labor % | Goal | Goal | Goal | Goal | [NAME] | # | Score |  |  | Week 18
Week 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 19
Week 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 20
Week 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 21
Week 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 22
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 24
P 4 | Week Ending | Weekly [NAME] | Labor Dollars | Labor % | Food Dollars | Food % | Bread % | Food % | Sides % | Paper % | Prod % | Pop % | Last Year Sales | Up/Down | Up/Down | Sample | Cash | Delivery | Delivery | Catering | Catering | DMR | Adjusted | Adjusted | Adjusted | Labor | Labor vs | Food | Food vs | PW | CC | Peak |  |  | Week 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $ | % | # | +/- | Sales $ | % | Sales $ | % | $ | Sales $ | Food % | Labor % | Goal | Goal | Goal | Goal | [NAME] | # | Score |  |  | Week 26
Week 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 27
Week 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 28
Week 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 29
Week 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 30
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 32
P 5 | Week Ending | Weekly [NAME] | Labor Dollars | Labor % | Food Dollars | Food % | Bread % | Food % | Sides % | Paper % | Prod % | Pop % | Last Year Sales | Up/Down | Up/Down | Sample | Cash | Delivery | Delivery | Catering | Catering | DMR | Adjusted | Adjusted | Adjusted | Labor | Labor vs | Food | Food vs | PW | CC | Peak |  |  | Week 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $ | % | # | +/- | Sales $ | % | Sales $ | % | $ | Sales $ | Food % | Labor % | Goal | Goal | Goal | Goal | [NAME] | # | Score |  |  | Week 34
Week 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 35
Week 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 36
Week 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 37
Week 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 38
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 40
P 6 | Week Ending | Weekly [NAME] | Labor Dollars | Labor % | Food Dollars | Food % | Bread % | Food % | Sides % | Paper % | Prod % | Pop % | Last Year Sales | Up/Down | Up/Down | Sample | Cash | Delivery | Delivery | Catering | Catering | DMR | Adjusted | Adjusted | Adjusted | Labor | Labor vs | Food | Food vs | PW | CC | Peak |  |  | Week 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $ | % | # | +/- | Sales $ | % | Sales $ | % | $ | Sales $ | Food % | Labor % | Goal | Goal | Goal | Goal | [NAME] | # | Score |  |  | Week 42
Week 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 43
Week 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 44
Week 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 45
Week 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 46
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 47
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 48
P 7 | Week Ending | Weekly [NAME] | Labor Dollars | Labor % | Food Dollars | Food % | Bread % | Food % | Sides % | Paper % | Prod % | Pop % | Last Year Sales | Up/Down | Up/Down | Sample | Cash | Delivery | Delivery | Catering | Catering | DMR | Adjusted | Adjusted | Adjusted | Labor | Labor vs | Food | Food vs | PW | CC | Peak |  |  | Week 49
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $ | % | # | +/- | Sales $ | % | Sales $ | % | $ | Sales $ | Food % | Labor % | Goal | Goal | Goal | Goal | [NAME] | # | Score |  |  | Week 50
Week 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 51
Week 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 52
Week 27
Week 28
Total
P 8 | Week Ending | Weekly [NAME] | Labor Dollars | Labor % | Food Dollars | Food % | Bread % | Food % | Sides % | Paper % | Prod % | Pop % | Last Year Sales | Up/Down | Up/Down | Sample | Cash | Delivery | Delivery | Catering | Catering | DMR | Adjusted | Adjusted | Adjusted | Labor | Labor vs | Food | Food vs | PW | CC | Peak
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $ | % | # | +/- | Sales $ | % | Sales $ | % | $ | Sales $ | Food % | Labor % | Goal | Goal | Goal | Goal | [NAME] | # | Score
Week 29
Week 30
Week 31
Week 32
Total
P 9 | Week Ending | Weekly [NAME] | Labor Dollars | Labor % | Food Dollars | Food % | Bread % | Food % | Sides % | Paper % | Prod % | Pop % | Last Year Sales | Up/Down | Up/Down | Sample | Cash | Delivery | Delivery | Catering | Catering | DMR | Adjusted | Adjusted | Adjusted | Labor | Labor vs | Food | Food vs | PW | CC | Peak
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $ | % | # | +/- | Sales $ | % | Sales $ | % | $ | Sales $ | Food % | Labor % | Goal | Goal | Goal | Goal | [NAME] | # | Score
Week 33
Week 34
Week 35
Week 36
Total
P 10 | Week Ending | Weekly [NAME] | Labor Dollars | Labor % | Food Dollars | Food % | Bread % | Food % | Sides % | Paper % | Prod % | Pop % | Last Year Sales | Up/Down | Up/Down | Sample | Cash | Delivery | Delivery | Catering | Cater | DMR | Adjusted | Adjusted | Adjusted | Labor | Labor vs | Food | Food vs | PW | CC | Peak
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $ | % | # | +/- | Sales $ | % | Sales $ | % | $ | Sales $ | Food % | Labor % | Goal | Goal | Goal | Goal | [NAME] | # | Score
Week 37
Week 38
Week 39
Week 40
Total
P 11 | Week Ending | Weekly [NAME] | Labor Dollars | Labor % | Food Dollars | Food % | Bread % | Food % | Sides % | Paper % | Prod % | Pop % | Last Year Sales | Up/Down | Up/Down | Sample | Cash | Delivery | Delivery | Catering | Catering | DMR | Adjusted | Adjusted | Adjusted | Labor | Labor vs | Food | Food vs | PW | CC | Peak
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $ | % | # | +/- | Sales $ | % | Sales $ | % | $ | Sales $ | Food % | Labor % | Goal | Goal | Goal | Goal | [NAME] | # | Score
Week 41
Week 42
Week 43
Week 44
Total
P 12 | Week Ending | Weekly [NAME] | Labor Dollars | Labor % | Food Dollars | Food % | Bread % | Food % | Sides % | Paper % | Prod % | Pop % | Last Year Sales | Up/Down | Up/Down | Sample | Cash | Delivery | Delivery | Catering | Catering | DMR | Adjusted | Adjusted | Adjusted | Labor | Labor vs | Food | Food vs | PW | CC | Peak
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $ | % | # | +/- | Sales $ | % | Sales $ | % | $ | Sales $ | Food % | Labor % | Goal | Goal | Goal | Goal | [NAME] | # | Score
Week 45
Week 46
Week 47
Week 48
Total
P 13 | Week Ending | Weekly [NAME] | Labor Dollars | Labor % | Food Dollars | Food % | Bread % | Food % | Sides % | Paper % | Prod % | Pop % | Last Year Sales | Up/Down | Up/Down | Sample | Cash | Delivery | Delivery | Catering | Catering | DMR | Adjusted | Adjusted | Adjusted | Labor | Labor vs | Food | Food vs | PW | CC | Peak
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $ | % | # | +/- | Sales $ | % | Sales $ | % | $ | Sales $ | Food % | Labor % | Goal | Goal | Goal | Goal | [NAME] | # | Score
Week 49
Week 50
Week 51
Week 52
Total
YTD | YR End | Yearly | Labor | Labor | Food | Food | Bread | Food | Sides | Paper | Prod | Pop | Last Year | Up/Down | Up/Down | Sample | Cash | Delivery | Delivery | Catering | Catering | DMR | Adjusted | Adjusted | Adjusted | Labor | Labor vs | Food | Food vs | PW | CC | Peak
 | Date | [NAME] | Dollars | Percent | Dollars | Percent | % | % | % | % | % | % | Sales | $ | % | # | +/- | Sales $ | % | Sales $ | % | $ | Sales $ | Food % | Labor % | Goal | Goal | Goal | Goal | [NAME] | # | Score
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | na |  | na
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YTD # |  | YTD
Period | Week Ending | Weekly [NAME] | Labor Dollars | Labor % | Total Food Dollars | Total Food % | Bread % | Food % | Sides % | Paper % | Prod % | Pop % | Last Year Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Peaks |  | AVG
1
2
3
4
5
6
7
8
9
10
11
12
13