tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 454939d1460038904-if-word-appears-in-column-b-within-date-range-in-column-q-test
Sheet: N8770 BM

N8770 Battery Maintenance
Status |  |  |  |  |  |  |  |  |  |  | Average sites received per day | Average sites [NAME] per day
aborted |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00
Active |  |  |  |  |  |  |  |  |  | 2016-02-01 00:00:00
Complete |  |  |  |  |  |  |  |  |  | 2016-03-01 00:00:00
Issue |  |  |  |  |  |  |  |  |  | 2016-04-01 00:00:00
inactive |  |  |  |  |  |  |  |  |  | 2016-05-01 00:00:00
planned |  |  |  |  |  |  |  |  |  | 2016-06-01 00:00:00
Survey |  |  |  |  |  |  |  |  |  | 2016-07-01 00:00:00
Specialist |  |  |  |  |  |  |  |  |  | 2016-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2016-10-01 00:00:00 |  |  |  |  |  | working days
 |  |  |  |  |  |  |  |  |  | 2016-11-01 00:00:00 |  |  |  | 2016-01-01 00:00:00 | 2016-01-31 00:00:00
Battery Handling |  |  |  |  |  |  |  |  |  | 2016-12-01 00:00:00 |  |  |  | 2016-02-01 00:00:00 | 2016-02-29 00:00:00
 | 12v30F | 12v33F | 12V62F | 12V92F | 12V170F | SBS 60 | Total |  |  |  |  |  |  | 2016-03-01 00:00:00 | 2016-03-31 00:00:00
2016-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-04-01 00:00:00 | 2016-04-30 00:00:00
2016-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-05-01 00:00:00 | 2016-05-31 00:00:00
2016-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-06-01 00:00:00 | 2016-06-30 00:00:00
2016-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-07-01 00:00:00 | 2016-07-31 00:00:00
2016-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-08-01 00:00:00 | 2016-08-31 00:00:00
2016-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-09-01 00:00:00 | 2016-09-30 00:00:00
2016-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-10-01 00:00:00 | 2016-10-31 00:00:00
2016-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-11-01 00:00:00 | 2016-11-30 00:00:00
2016-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-12-01 00:00:00 | 2016-12-31 00:00:00
2016-10-01 00:00:00
2016-11-01 00:00:00
2016-12-01 00:00:00
Date | Orders Received | Complete | Aborted | Surveys | Total events
2016-01-01 00:00:00
2016-02-01 00:00:00
2016-03-01 00:00:00
2016-04-01 00:00:00
2016-05-01 00:00:00
2016-06-01 00:00:00
2016-07-01 00:00:00
2016-08-01 00:00:00
2016-09-01 00:00:00
2016-10-01 00:00:00
2016-11-01 00:00:00
2016-12-01 00:00:00
Spreadsheet: 166281d1341517044-how-to-display-the-average-of-a-group-averages-in-a-pivot-table-sample2
Sheet: Data

Account | Quarter | Value
Company 1 | Q1 | 9000
Company 2 | Q2 | 8000
Company 3 | Q3 | 8000
Company 4 | Q4 | 10000
Company 5 | Q1 | 8000
Company 6 | Q2 | 9000
Company 7 | Q3 | 9000
Company 8 | Q4 | 8000
Company 9 | Q1 | 9000
Company 10 | Q2 | 9000
Company 11 | Q3 | 7000
Company 12 | Q4 | 9000
Company 13 | Q1 | 9000
Company 14 | Q2 | 8000
Spreadsheet: 163881d1340526688-searching-and-correlating-searching-and-correlating
Sheet: Hoja1

 |  |  |  |  |  |  |  | CODES CORRELATIONS |  | MIXED CODES | What I need is fill this column with the new codes & FORMAT
 |  |  |  |  |  |  |  | Old industry code code | New industry code code | Data received | New industry code code
 |  |  |  |  |  |  |  | 1 | 11 | 1
 |  |  |  |  |  |  |  | 2 | 12 | 1
 |  |  |  |  |  |  |  | 3 | 13 | 1
 |  |  |  |  |  |  |  | 4 | 14 | 2
 |  |  |  |  |  |  |  | 5 | 15 | 2
 |  |  |  |  |  |  |  | 6 | 16 | 4
 |  |  |  |  |  |  |  | 7 | 17 | 4
 |  |  |  |  |  |  |  | 8 | 18 | 5
 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 8
Spreadsheet: 6383fe73-52d6-444a-a6ed-d3ec3d2188b2
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PECH | Test | PECH | Peach, IgE | Peach, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m. Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
PECH | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PECH | Result | PECH | Peach, IgE | Peach, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6205-9 | Prunus persica Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 713447d1610722928-bulding-a-schedule-index-aggregate-dexter2-
Sheet: Schedule

Route 1 Line
 |  | Vehicle | Depot | Terminal A | Stop 1 | Stop 2 | Stop 3 | Terminal B | Column1 | Vehicle | Terminal B2 | Stop 33 | Stop 24 | Stop 15 | Terminal A6 | Column7 | Depot8 | Vehicle9
 | 101 |  |  | 05:30:00 |  |  |  |  |  |  | 06:15:00 |  |  |  |  | 07:00:00
 | 104 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:15:00
 | 102 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00
 | 103 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:45:00
 | 105 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00
 | 106 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00
 | 108 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:30:00
 | 107 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:15:00
Spreadsheet: 34894d1232320723-text-if-cell-contains-text-text-lookup-jw
Sheet: Sheet1

Lookup text | text entries to sort through | It's there | Character number it starts with
both | I like fish | it's not there
 | I don't like fish
 | I prefer dolphins
 | that’s silly as both are infact tomatos
 | Dumb ass tomatos and fish are both dogs
Spreadsheet: 92684d1292256786-autmatic-adjusting-dates-based-on-the-date-auto-date
Sheet: Sheet1

STATUS
Part Number | M Date | W | STEPS | PS DATE | PA DATE | SP DATE | Days ahead (+) / late (-) | CLEAR | S DATE | SS DATE | Days ahead (+) / late (-) | Notes
1 | #N/A |  |  |  |  | #N/A | #N/A |  |  | #N/A | #N/A
A | 2010-10-20 00:00:00 | 1 | 3 | 2010-10-25 00:00:00 | 2010-10-26 00:00:00 | 2010-10-27 00:00:00 | 1 | 2010-10-27 00:00:00 | 2010-10-27 00:00:00 | 2010-10-28 00:00:00 | 1
B | 2010-11-01 00:00:00 | 2 | 4 | 2010-11-05 00:00:00 | 2010-11-10 00:00:00 | 2010-11-05 00:00:00 | -5 | 2010-11-10 00:00:00 | 2010-11-11 00:00:00 | 2010-11-07 00:00:00 | -4
C | 2010-11-01 00:00:00 | 3 | 7 |  |  | 2010-12-10 00:00:00 | -3 |  |  | 2010-12-12 00:00:00 | -1
Spreadsheet: 21f06e6e-15b1-4ebe-87e0-615848d53c5f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: Monthly Wholesale Trade: Sales and Inventories
 |  | 42: Total [NAME], Except Manufacturers' Sales Branches and Offices: U.S. Total
 |  | Not Seasonally Adjusted Sales - Monthly [Millions of Dollars]
 |  | Period: 1992 to 2013
 |  | Data Extracted on: May 20, 2013 (9:05 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | 138830 | 132921 | 150672 | 146927 | 141749 | 150869 | 150768 | 147079 | 152030 | 158307 | 145676 | 151302
1993 | 140824 | 138267 | 159749 | 154677 | 153693 | 158043 | 152798 | 159014 | 158768 | 160576 | 156357 | 155449
1994 | 143826 | 143069 | 171413 | 157193 | 163090 | 168454 | 157254 | 177898 | 172066 | 176341 | 171870 | 172425
1995 | 165397 | 161211 | 186778 | 170025 | 185818 | 186564 | 172384 | 191076 | 181621 | 193246 | 184672 | 180188
1996 | 178477 | 176150 | 189303 | 189906 | 195454 | 185356 | 193212 | 196149 | 190873 | 209454 | 189016 | 190993
1997 | 186983 | 181571 | 200205 | 198723 | 200357 | 199810 | 200632 | 195457 | 206341 | 215636 | 188397 | 203733
1998 | 187750 | 183337 | 211184 | 204583 | 198874 | 210701 | 204982 | 199128 | 207425 | 212915 | 196656 | 209585
1999 | 184434 | 188602 | 225471 | 212372 | 211738 | 226910 | 215120 | 223078 | 226580 | 226868 | 225903 | 232083
2000 | 208053 | 218632 | 248659 | 222637 | 243460 | 247509 | 226260 | 246918 | 236862 | 248451 | 236370 | 230743
2001 | 229917 | 217231 | 245078 | 229085 | 244303 | 234330 | 228826 | 242911 | 223722 | 243615 | 227250 | 218884
2002 | 220173 | 210596 | 234089 | 237757 | 244150 | 234015 | 241943 | 245497 | 237792 | 255957 | 235200 | 238359
2003 | 235088 | 223739 | 251324 | 246116 | 243813 | 247978 | 251672 | 245016 | 254581 | 270128 | 239776 | 262585
2004 | 241829 | 243698 | 292893 | 277008 | 268331 | 286163 | 271952 | 284489 | 284818 | 285740 | 285504 | 293978
2005 | 265455 | 266343 | 314412 | 294269 | 298665 | 309744 | 287888 | 320342 | 317389 | 318771 | 309048 | 311055
2006 | 296628 | 288192 | 341605 | 309949 | 339559 | 344482 | 317360 | 351476 | 327270 | 340822 | 325861 | 321005
2007 | 317860 | 302176 | 352547 | 340415 | 362817 | 355936 | 343311 | 367627 | 341646 | 381999 | 362401 | 345551
2008 | 357227 | 345074 | 374686 | 387143 | 393339 | 403469 | 400657 | 384054 | 383198 | 379314 | 305731 | 317883
2009 | 285273 | 275290 | 307718 | 302964 | 297782 | 320293 | 312954 | 308908 | 319451 | 326959 | 312021 | 329601
2010 | 299417 | 297448 | 359964 | 348835 | 337917 | 357010 | 340666 | 354056 | 352836 | 357257 | 358994 | 367927
2011 | 345734 | 336398 | 413865 | 387872 | 396558 | 407610 | 376195 | 417221 | 402955 | 400006 | 394417 | 398506
2012 | 381845 | 382933 | 429747 | 412547 | 431708 | 409934 | 396689 | 424186 | 396767 | 432374 | 415963 | 402360
2013 | 404194 | 381753 | 423228
Spreadsheet: darrell_schoolcraft__7804__imbalsumm0108
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 53256 | 50455
2 | 35225 | 42864
3 | 9749 | 31925
4 | 13680 | 13148
5 | 39257 | 39446
6 | 39309 | 39455
7 | 17078 | 21455
8 | 38021 | 38122
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00
2001-08-08 00:00:00
CBS Dollars
Spreadsheet: 84a8741f-e617-4a2c-b7b4-50a9d3ae138e
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
THYRO | Test | THYRO | Thyrotropin Receptor Antibody, Serum | Thyrotropin Receptor Ab, S | Electrochemiluminescence Immunoassay | Plain, Red-Top Tube: Red OR Serum Gel Tube: SGT OR |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | < or =1.75 IU/L | Monday through Friday 5 a.m. - 12 a.m., Saturday 6 a.m. - 6 p.m. | 1 day / same day | 3 days | 1 | 83520 |  |  |  |  | Rochester
THYRO | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
THYRO | Result | THYRO | Thyrotropin Receptor Ab, S | Thyrotropin Receptor Ab, S | Numeric |  |  |  |  | IU/L |  |  |  |  |  |  |  |  |  | 5385-0 | Thyrotropin receptor [NAME]:ACnc:Pt:Ser:Qn:
Spreadsheet: 464088d1464871937-monthly-financial-statement-help-pl-budget-by-store-by-month-excel
Sheet: P&L Short

 | Store 1 | Store 2 | Store 3 | Store 4 | CORPORATE
Revenue | 1115872 | 394953.4299999999 | 315799.4 | 549802.19 | 2376427.02
% of Corporate | 0.4695587075087204 | 0.1661963219051431 | 0.1328883224025958 | 0.2313566481835407
[NAME] | -782190.5800000001 | -257032.59 | -230951.07 | -353589.26 | -1623763.5
% of Sales | 0.7009680142525309 | 0.6507921452916614 | 0.7313220671096905 | 0.64312086497873
Gross Profit | 333681.4199999999 | 137920.84 | 84848.33000000002 | 196212.9299999999 | 752663.5199999998
 | 0.2990319857474692 | 0.3492078547083386 | 0.2686779328903095 | 0.35687913502127 | 0.3167206540178119
Payroll | -220233.49 | -50015.89000000001 | -41957.22 | -78406.07 | -390612.67
% of Sales | 0.1973644737030771 | 0.126637436722603 | 0.1328603537562136 | 0.1426077804455454
Expenses | -101617.37 | -33502.6 | -29406.18999999999 | -46875.42 | -211401.58
% of Sales | 0.09106543582059591 | 0.084826709822472 | 0.09311667469919191 | 0.08525870004264625
Net Income | 11830.55999999994 | 54402.34999999995 | 13484.92000000003 | 70931.43999999993 | 150649.2699999998
% of Sales | 0.01060207622379622 | 0.1377437081632636 | 0.04270090443490401 | 0.1290126545330784
Spreadsheet: 110208d1306941651-vlookup-question-vlookup_question_variable_arrays
Sheet: Sheet1

 | ARRAY 1
 | A | B | C | Dropdown menu 1
1 | A1 | BA1 | CBA1 | A12 | BA1A12 |  | Array 1
2 | A12 | BA1A12 | CBA1BA1A12 |  |  |  | [NAME]
3 | A123 | BA1A12A123 | CBA1BA1A12BA1A12A123 | Dropdown menu 2
 |  |  |  | [NAME] | return value depending here depending on both dropdowns using array 2 if selected rather than array 1
 | ARRAY 2
 | A | B | C
1 | B1 | BB1 | CBB1
2 | B2 | BB1B2 | CBB1BB1B2
3 | B3 | BB1B2B3 | CBB1BB1B2BB1B2B3
Spreadsheet: 52559d1252413933-help-with-a-formula-referencing-multiple-tabs-sept-09-sales-and-labor
Sheet: Sept Wk 5

Date | 2009-09-27 00:00:00 | 2009-09-28 00:00:00 | 2009-09-29 00:00:00 | 2009-09-30 00:00:00
 | Sunday | Monday | Tuesday | Wednesday
Net Sales*
WTD Net Sales |  | 0 | 0 | 0
MTD Net sales | 55173 | 55173 | 55173 | 55173
LY Sales | 7558 | 4433 | 5274 | 5195
LY [NAME] |  | 11991 | 17265 | 22460
LY Sales MTD | 217060 | 221493 | 226767 | 231962
Comp $ +/- | -7558 | -4433 | -5274 | -5195
WTD Comp  $ +/- |  | -11991 | -17265 | -22460
MTD Comp $ +/- | -161887 | -166320 | -171594 | -176789
Comp %  +/- | #N/A | #N/A | #N/A | #N/A
WTD Comp  % +/- |  | #N/A | #N/A | #N/A
MTD Comp % +/- |  | -3.014517970746561 | -3.110108205100321 | -3.204266579667591
Food/Bev Sales
WTD F&B |  | 0 | 0 | 0
LBW Sales
WTD LBW |  | 0 | 0 | 0
Alcohol Sales Mix   * | #N/A | #N/A | #N/A | #N/A
WTD Alc Mix |  | #N/A | #N/A | #N/A
BOH Labor $
WTD BOH Labor $ |  | 0 | 0 | 0
BOH Labor Hours
WTD BOH Labor Hrs |  | 0 | 0 | 0
FOH Labor $
WTD FOH Labor $ |  | 0 | 0 | 0
FOH Labor Hours
WTD FOH Labor Hrs |  | 0 | 0 | 0
BOH Labor %   * | #N/A | #N/A | #N/A | #N/A
WTD BOH % |  | #N/A | #N/A | #N/A
BOH Productivity | #N/A | #N/A | #N/A | #N/A
WTD BOH Prod |  | #N/A | #N/A | #N/A
FOH Labor %   * | #N/A | #N/A | #N/A | #N/A
WTD FOH % |  | #N/A | #N/A | #N/A
FOH Productivity | #N/A | #N/A | #N/A | #N/A
WTD FOH Prod |  | #N/A | #N/A | #N/A
[NAME]
Lunch Sales WTD |  | 0 | 0 | 0
[NAME] | 3370 | 1745 | 1692 | 1481
[NAME] |  | 5115 | 6807 | 8288
"+/-" LY | -3370 | -1745 | -1692 | -1481
"+/- [NAME] |  | -5115 | -6807 | -8288
DATE | 2009-09-07 00:00:00
DAILY SALES: $ | #N/A
[NAME] SALES: $ | #N/A
+/- [NAME] | #N/A
WTD SALES: $ | #N/A
MTD SALES: $ | #N/A
FOOD & BEV $ | #N/A
LIQUOR MIX: % | #N/A
WTD LIQUOR MIX: % | #N/A
FOH: $ | #N/A
FOH HOURS | #N/A
FOH LABOR: % | #N/A
FOH PROD: $ | #N/A
WTD FOH LABOR: % | #N/A
BOH: $ | #N/A
BOH HOURS | #N/A
BOH LABOR: % | #N/A
BOH PROD: $ | #N/A
WTD BOH LABOR: % | #N/A
LUNCH: $ | #N/A
LUNCH VS LY | #N/A
 | high 30s
Spreadsheet: 163410b2-d412-4a33-b1d9-f8df5e2991c7
Sheet: Sheet1

Unnamed: 0 | 2009 | 2008
Average Hours for QSA Significant Desk Audits | 5.07 | 3.55
Average Costs for QSA Significant Desk Audits | 547.56 | 383.4
Average Hours for QSA Desk Audits | 10.23 | 9.9
Average Costs for QSA Desk Audits | 1104.84 | 1069.2
Average Hours for QSA On-Site Audits | 13 | 12.96
Average Costs for QSA On-Site Audits | 1615.7 | 1642.13
Average Hours for QSA Live On-Site Audits | 27.1 | 34.55
Average Costs for QSA Live On-Site Audits | 3440.29 | 4521.26
Average Hours for HQ Desk Audits | 13
Average Costs for HQ Desk Audits | 1404
Average Hours for HQ On-Site Audits | 15.5
Average Costs for HQ On-Site Audits | 2124.21
Average Hours for PVP Desk Audits | 9.92 | 17.91
Average Costs for PVP Desk Audits | 1071.36 | 1934.28
Average Hours for PVP Significant Desk Audits | 6.25 | 6.73
Average Costs for PVP Significant Desk Audits | 675 | 726.84
Average Hours for [NAME]. On-Site Audits | 24.35 | 29.04
Average Costs for [NAME]. On-Site Audits | 3226.56 | 3824
Average Hours for PVP On-Site Audits | 47.24 | 56.72
Average Costs for PVP On-Site Audits | 6219.26 | 7858.18
Average Hours for Guide 65 Desk Audits | 18.84 | 22.5
Average Costs for Guide 65 Desk Audits | 2034.72 | 2430
Average Hours for Guide 65 On-Site Audits | 48.42 | 50.64
Average Costs for Guide 65 On-Site Audits | 6170.18 | 6610.99
Average Hours for NHTC Significant Desk Audits | 3.67
Average Costs for NHTC Significant Desk Audit | 396.36
Average Hours for NHTC Desk Audits |  | 13.5
Average Costs for NHTC Desk Audits |  | 1458
Average Hours for NHTC On-Site Audits | 22.34 | 21.42
Average Costs for NHTC On-Site Audits | 2768.94 | 2731.35
Average Hours for PFEU Desk Audits |  | 12
Average Costs for PFEU Desk Audits |  | 1296
Average Hours for PFEU On-Site Audits | 19.29 | 25.78
Average Costs for PFEU On-Site Audits | 2472.23 | 3345.02
Average Hours for EL On-Site Audits | 18.34 | 17.03
Average Costs for EL On-Site Audits | 2717.61 | 2422.01
Average Hours for NOP Scope Desk Audits | 11.5
Average Costs for NOP Scope Desk Audits | 1242
Average Hours for NOP Initial Desk Audits | 37.44 | 35.95
Average Costs for NOP Initial Desk Audits | 4043.52 | 3882.6
Average Hours for Domestic NOP On-Site Audits | 69.05 | 67.69
Average Costs for Domestic NOP On-Site Audits | 9119.79 | 10326
Average Hours for Foreign NOP On-Site Audits | 150.6 | 172.11
Average Costs for Foreign NOP On-Site Audits | 23362.25 | 26980.99
Average EV Export SOV | 108 | 108
Average EV SOV-FP | 108 | 108
Average EV Supplier List | 108 | 108
Average EV Product List | 108 | 108
Spreadsheet: e698f713-b752-45b1-acb7-75914a04b8a4
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FFTEM | Test | FFTEM | Temazepam (Restoril), Serum | Temazepam (Restoril) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 2 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin down and send 2 mL sodium heparin plasma refrigerated in a plastic vial.   Serum Draw blood in a plain, red-top tube(s), serum gel tube is not acceptable. Spin down and send 2 mL of serum refrigerated in a plastic vial. | 0.3 mL | Hemolysis	NA Thawing	Cold OK; Warm OK Lipemia	NA Icterus	NA Other	NA | [NAME]: 50 - 1000 ng/mL   Test Performed by: Medtox Laboratories, Inc.                              402 W County Road D                              St. Paul, MN 55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 80154 |  |  |  |  | Medtox Laboratories, Inc.
FFTEM | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FFTEM | Result | [NAME] | Temazepam (Restoril) | Temazepam (Restoril) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 225644d1365076648-populate-data-based-on-cell-information-test
Sheet: Sheet2

TYPE | CODE | OTHER | PRICE |  | 1 | [NAME] | [NAME]
Buckle Only | 94972 | L/H | 9 |  | 2 | Buckle Only
Buckle Only | 94973 | R/H | 9 |  | 3 | Complete
Buckle Only | 95899 | n/a | 9.5 |  | 4 | Reel Only
Complete | 95286 | n/a | 13.5
Complete | 102047 | n/a | 13.5
Complete | 94787 | n/a | 14.5
Complete | 91074 | n/a | 18.5
Complete | 96809 | n/a | 26
Complete | 99765 | n/a | 28.5
Complete | 92618 | n/a | 29.5
Complete | 93202 | n/a | 29.5
Complete | 99052 | ORION 403134 | 29.5
Complete | 96876 | n/a | 32.5
Complete | 96174 | Suitable Alternative | 32.5
Complete | 94970 | n/a | 34
Complete | 94972 | L/H | 34
Complete | 94973 | R/H | 34
Reel Only | 95899 | n/a | 28.5
Reel Only | 97191 | n/a | 29.5
Reel Only | 94944 | n/a | 29.5
Reel Only | 105319 | n/a | 29.5
Reel Only | 94972 | L/H | 32.5
Reel Only | 94973 | R/H | 32.5
Reel Only | 99541 | n/a | 78