tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 800129d1665497387-reconciliation-of-two-sheets-exercise-2-
Sheet: Comments - Request

I need to reconcile data from Sheet1 and Sheet 2 in terms of Store, Part, Element and Material consumption
Important info
Parts in Sheet2 all end with 000 - left & "000" formula in Sheet1 to match them
The same part can be on multiple locations - maybe a concat between store&part would be useful in both sheets
For each part there can be 1 or more elements to be taken into consideration as Material consumption - criteria is "L" in column C Sheet1 and elements that start with "5" in column C Sheet2/ Material consump in Sheet2 needs to be multipiled by 1000 to match values with Sheet1
For parts that only have "R" in column C Sheet1 only reconcile the Store
Example
Sheet 1 |  |  |  |  |  | Sheet 2
Store | Part | L/R | Element | Element Consump |  | Store | Part | Element | Element consump
5414 | [PHONE] | L | 5118866001 | 360 |  | 5414 | 5111318000 | 5118866000 | 0.36
 |  |  |  |  |  | same store | 000 ending | same element 000 ending | 0.36*1000 is the same consump as Sheet1 lines that have "L" as criteria in column C
Sheet 1 |  |  |  |  |  | Sheet 2
Store | Part | L/R | Element | Element Consump |  | Store | Part | Element | Element consump
5448 | [PHONE] | L | 5118864001 | 120 |  | 5448 | 5119176000 | 5118852000 | 0.24
5448 | [PHONE] | L | 5118852001 | 240 |  | 5448 | 5119176000 | 5118864000 | 0.12
5448 | [PHONE] | L | 5118867001 | 150 |  | 5448 | 5119176000 | 5118867000 | 0.15
5448 | [PHONE] | L | 5119561001 | 276 |  | 5448 | 5119176000 | 5119505000 | 0.36
5448 | [PHONE] | L | 5119505001 | 360 |  | 5448 | 5119176000 | 5119561000 | 0.276
 |  |  |  |  |  | same store | 000 ending | same element 000 ending | 0.36*1000 is the same consump as Sheet1 lines that have "L" as criteria in column C
Sheet1 |  |  |  |  |  | Sheet2
Store | Part |  |  |  |  | Store | Part
5524 | [PHONE] |  |  |  |  | 5524 | 7100372000
 |  |  |  |  |  | same store
Spreadsheet: 772066d1646992837-auto-fill-filling-with-colour-based-on-variables-golf-final
Sheet: Leaderboard

Name | Player | Score | Points |  | Position |  | Player | Score | Points |  | Player | Score | Points |  |  | Score | Points |  | Helper | player | Score today | Score | Position
[NAME] |  |  |  |  |  | Pearce | [NAME] | -6 | 20 |  | [NAME] |  |  |  | Pearce | -19 | 52
[NAME] |  |  |  |  |  | Pearce | [NAME] | -6 | 20 |  | [NAME] |  |  |  | [NAME] | -10 | 14
[NAME] |  |  |  |  |  | Pearce | [NAME] | -4 | 8 |  | Campbell |  |  |  | Campbell | -8 | 12
[NAME] |  |  |  |  |  | Campbell | [NAME] | -4 | 8 |  | Pearce |  |  |  | [NAME] | 3 | -4
[NAME] |  |  |  |  |  | Pearce | [NAME] | -3 | 4
[NAME] |  |  |  |  |  | [NAME] | [NAME] | -3 | 4 |  |  |  |  |  | Scoring
Campbell |  |  |  |  |  | Campbell | Jon Rahm | -3 | 4 |  |  |  |  |  | Postion | Points Scored
Campbell |  |  |  |  |  | [NAME] | [NAME] | -2 | 3 |  |  |  |  |  | Winner | 20
Pearce |  |  |  |  |  | Campbell | [NAME] | -2 | 3 |  |  |  |  |  | [NAME] Up | 16
Pearce |  |  |  |  |  | [NAME] | [NAME] | -2 | 3 |  |  |  |  |  | 3rd | 14
Pearce |  |  |  |  |  | [NAME] | [NAME] | -2 | 3 |  |  |  |  |  | 4th | 12
Pearce |  |  |  |  |  | [NAME] | [NAME] | -1 | 1 |  |  |  |  |  | 5th | 10
Pearce |  |  |  |  |  | [NAME] | Talor Gooch | -1 | 1 |  |  |  |  |  | 6th | 9
[NAME] |  |  |  |  |  | [NAME] | [NAME] | -1 | 1 |  |  |  |  |  | 7th | 8
Campbell |  |  |  |  |  | [NAME] | [NAME] | 0 | 0 |  |  |  |  |  | 8th | 7
[NAME] |  |  |  |  |  | [NAME] | Mackenzie Hughes | 0 | 0 |  |  |  |  |  | 9th | 6
Campbell |  |  |  |  |  | Campbell | [NAME] | 0 | 0 |  |  |  |  |  | 10th | 5
Campbell |  |  |  |  |  | Pearce | [NAME] | 0 | 0 |  |  |  |  |  | 11-15th | 4
Pearce |  |  |  |  |  | Pearce | [NAME] | 0 | 0 |  |  |  |  |  | 16-20th | 3
[NAME] |  |  |  |  |  | [NAME] | [NAME] Im | 0 | 0 |  |  |  |  |  | 21st-30th | 2
[NAME] |  |  |  |  |  | Campbell | [NAME] | 0 | 0 |  |  |  |  |  | 31st-40th | 1
Campbell |  |  |  |  |  | [NAME] | [NAME] | 1 | -3 |  |  |  |  |  | 41st+ (#) | 0
[NAME] |  |  |  |  |  | Campbell | Shane Lowry | 1 | -3 |  |  |  |  |  | Hole in one | 3
[NAME] |  |  |  |  |  | [NAME] | [NAME] | 4 | -3 |  |  |  |  |  | Miss Cut | -3
Spreadsheet: fe765b72-c75c-4059-a386-c75295abcfd8
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 | Unnamed: 13 | Unnamed: 14
[NAME] |  | Enter Farm Name |  |  |  |  |  |  | Year: | 2010
Developed by: [NAME], Business Information Management Specialist: Penn State Dairy Alliance - 2002
Data Source | Monitor Item | Date=> | 2010-01-15 00:00:00 | 2010-02-14 00:00:00 | 2010-03-16 00:00:00 | 2010-04-15 00:00:00 | 2010-05-15 00:00:00 | 2010-06-14 00:00:00 | 2010-07-14 00:00:00 | 2010-08-13 00:00:00 | 2010-09-12 00:00:00 | 2010-10-12 00:00:00 | 2010-11-11 00:00:00 | 2010-12-11 00:00:00
 | Production | Goals
DHI | Milk/Cow/Day
 | Milk-41-100 days (Hfrs)
 | Milk-41-100 days (Cows)
Calculated | 150 DIM Stand Prod |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DHI OR Dairy/Coop | %B.F.
 | % Prot
Calculated | Prot/Fat Ratio |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Dairy/Coop | Total [NAME]
 | Milk Price/Cwt  (gross)
 | Milk Price/Cwt  (net)
 | Repro
DHI | DIM
 | Cows Not Serviced>70 DIM
 | Cows Not Serviced>100 DIM
 | [NAME]
 | Breedings/month
 | Confirmed preg/month
 | Milk Quality
DHI | SCC-Weighted
 | SCS-Linear
 | LSCS-Heifers<40DIM
 | LSCS-Cows<40DIM
Dairy/Coop | SCC-Raw (Bulk Tank)
 | [NAME] (Bulk Tank)
 | Plate Count-PI (Bulk Tank)
Producer | # Clinical Cases
 | Feed Efficiency
Ration | DMI-Lbs/Cow
 | Feed$/CWT
Calculated | Milk/Lb DM |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Income/Feed Costs |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME]
Producer | FTWE (230 Hours/month)
Calculated | Lbs Milk Sold/worker |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Cow Management
Producer | Feet Problems # Cases
 | Laminitis
 | Heel Warts
 | [NAME]
 | Heel Cracks
Calculated | [NAME] | 0.025 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Prorated Annual Cull Rate | 0.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Cow Numbers
Calculated | Beginning Herd Size |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DHI or Producer | Cows Culled | 0
 | [NAME] | 0
 | Cows Purchased | 0
Calculated | Ending Herd Size | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Change of procedures
Archives and Chart modifications by: [NAME], Penn State Cooperative Extension, 10/8/2009
Spreadsheet: 2ea31493-16f2-4d25-b933-626bcc8bdfe6
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
LCADP | Test | LCADP | Adenovirus, Molecular Detection, PCR, Plasma | Adenovirus PCR, P | Real-Time Polymerase Chain Reaction (PCR)/DNA [NAME] (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Lavendar-top (EDTA) Tube: EDTA (<1 month old infant) |  |  |  |  | Container/Tube: Lavender top (EDTA) [NAME]: 1 mL Collection Instructions: Spin down promptly. Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. | 0.3 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	Thrombin-activated tube | Not applicable | Monday, Wednesday, Friday; 6 a.m. | Monday through Thursday: 2 days Friday, Saturday: 3 days | 5 days | 1 | 87798 |  |  |  |  | Rochester
LCADP | [NAME] | PLEDTA | [NAME] |  |  |  | Refrigerated | 7 days
LCADP | Result | [NAME] | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
LCADP | Result | 56088 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21055-9 | Adenovirus DNA:ACnc:Pt:Ser/Plas:[NAME]:Probe.amp.tar
LCADP | Result | 56089 | Special Information | Special Information | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8 | Annotation comment:Imp:Pt:{system}:Nar:
LCADP | Result | 56090 | Report Status | Report Status | Alphanumeric
Spreadsheet: 61d37665-1b7f-4202-b230-fd7757ed0f66
Sheet: Sheet1

 | First Name | Last Name | City | Country | club
1 | Carmen | Bucher | [NAME] | Switzerland
2 | Naiely | Cabrera | Vancouver | Canada
3 | [NAME] | [NAME] | Radstock | United Kingdom
4 | Camilla | Cullum | København N | Denmark
5 | Mandy | Dammekens | Thuillies | Belgique
6 | Marion | DELAS | Toulouse | France
7 | Alexandra | Ede | Wandsworth | United Kingdom
8 | [NAME] | [NAME] | Carterton | United Kingdom
9 | Manon | [NAME] | La Rochelle | France
10 | [NAME] | [NAME] | Kingston upon Thames | United Kingdom
11 | Anna | Jaskula | London | United Kingdom
12 | Astrid | Kleemann | Hannover | Germany
13 | Rebecca | Leonard | [NAME] | United States
14 | [NAME] | Rindlisbacher | Thun | Switzerland
15 | Fleur | [NAME] | Melksham | United Kingdom
16 | [NAME] | snare | Chipping Norton | United Kingdom
17 | MANON | TESTOU | ANTIBES | France
18 | Corinne | Thompson | London | United Kingdom
19 | Wiktor | Wandzel | Łódź | Poland
 | 19 | 19 | 19 | 19
Spreadsheet: 48559d1247777095-text-lookup-sample
Sheet: BLI Request

 | BLI Required Statement |  |  | .=INDEX($N$1:$N$8,MIN(IF(COUNTIF($K2,$P$1:$P$8),ROW($P$1:$P$8))))
 | S.No. | BLI No. | Shipping Line | FCLs | Weight | FOB Rate | FOB Value | [NAME] | CnF Value
 | 1 | BLI-1
 | 2 | BLI-2
 | 3 | BLI-3
 | 4 | BLI-4
 | 5 | BLI-5
 | 6 | BLI-6
 | 7 | BLI-7
 | 8 | BLI-8
 | 9 | BLI-9
 | 10 | BLI-10
 |  | TOTAL
Spreadsheet: chris_germany__1681__FSS-cheetsheet
Sheet: Oct 99 

FSS Cheat Sheet
INJECTIONS: STORAGE GAS LOSS RETAINAGE APPLIES
MMIQ (Maximum Monthly Injections Quantity) |  |  |  |  | SCQ = | 8214498
 |  | % of SCQ | MMIQ | 1.05
April |  | 0.15
May - Aug |  | 0.2
Sept |  | 0.13
Oct |  | 0.07
Nov |  | 0.05
Dec - Mar |  | 0.1
If 105% MMIQ is exceded a penatly of $5.00/dkt for all quantitiels injected in excess of 105% of its
MMIQ will be assessed.
MDIQ (MAXIMUM DAILY INJECTION QUANTITY) |  |  |  |  | Oct | Nov | Dec | Jan-Mar
MMIQ/30 | For November & December
MMIQ/25 | For Rest of the Months
If 110% of MDIQ is exceeded a penalty of $5.00 per dth for all quantities injected in excess of 110%
of its MDIQ will be assessed.
WITHDRAWALS: MDWQ BASED UPON AND LIMITED BY SCQ INVENTORY
REMAINING IN STORAGE.
% of SCQ in Inventory |  |  |  | MDWQ as % of MDSQ |  |  | MDSQ = | 147504
100% to 30% |  |  |  | 1
less than 30% to 20% |  |  |  | 0.8
less than 20% to 10% |  |  |  | 0.65
less than 10% to 0% |  |  |  | 0.5
If 103% of MDWQ is exceeded a penalty of $10.00 per dkt for all quantitites withdrawn in excess
of 103% of its MDWQ will be assessed.
Minimum and [NAME] net withdrawal for November thru March
 |  | Min % |  |  | [NAME]
Month |  | of SCQ |  |  | of SCQ
November |  | none |  |  | 0.4
December |  | none |  |  | 0.4
January |  | none |  |  | 0.4
February |  | 0.1 |  |  | 0.3
March |  | 0.1 |  |  | 0.2
If monthly net withdrawal exceeds applicable limits a penalty of $5.00 per dkt for all quantities
withdrawn in excess of such limits will be assessed.
INVENTORY: |  | no more than x% in SCQ in storage
April 1st |  | 0.25
February 1st |  | 0.65
June 30th |  | 0.6
August 31st |  | 0.85
Spreadsheet: 1813e99e-3875-4494-8490-6b53684ab51a
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
09/26/2014 | Women's Tennis | Pink Invitational (Mountaineer Tennis Courts) | 09:00 AM | Results
09/27/2014 | Women's Tennis | Pink Invitational (Mountaineer Tennis Courts) | 09:00 AM | Results
09/28/2014 | Women's Tennis | Pink Invitational (Mountaineer Tennis Courts) | 09:00 AM | Results
10/03/2014 | Women's Tennis | at Akron Invite | 09:00 AM | Results
10/04/2014 | Women's Tennis | at Akron Invite | 09:00 AM | Results
10/05/2014 | Women's Tennis | at Akron Invite | 09:00 AM | Results
10/10/2014 | Women's Tennis | at Georgia State Invite | 10:00 AM | Results
10/11/2014 | Women's Tennis | at Georgia State Invite | 03:00 PM | Results
10/12/2014 | Women's Tennis | at Georgia State Invite | 10:00 AM | Results
10/24/2014 | Women's Tennis | at Big Easy Tennis Classic (New Orleans, La.) | 08:00 AM | Results
10/25/2014 | Women's Tennis | at Big Easy Tennis Classic (New Orleans, La.) | 08:00 AM | Results
10/31/2014 | Women's Tennis | [NAME] (Ridgeview [NAME]) | 08:00 AM | Results
11/01/2014 | Women's Tennis | [NAME] (Ridgeview [NAME]) | 08:00 AM | Results
01/16/2015 | Women's Tennis | at Pitt Hidden Duel (Pittsburgh, Pa.) | 09:00 AM
01/17/2015 | Women's Tennis | at Pitt Hidden Duel (Pittsburgh, Pa.) | 09:00 AM
01/18/2015 | Women's Tennis | at Pitt Hidden Duel (Pittsburgh, Pa.) | 09:00 AM
01/29/2015 | Women's Tennis | at Ohio State | 09:00 AM
01/31/2015 | Women's Tennis | at Toledo | 03:00 PM
02/06/2015 | Women's Tennis | at Buffalo | 01:00 PM
02/07/2015 | Women's Tennis | at [NAME] | 10:00 AM
02/13/2015 | Women's Tennis | Youngstown State (Ridgeview Racquet Club) | 12:00 PM
02/13/2015 | Women's Tennis | Towson (Ridgeview [NAME]) | 04:00 PM
02/15/2015 | Women's Tennis | California-Pennsylvania (Ridgeview Racquet Club) | 09:00 AM
02/15/2015 | Women's Tennis | Eastern Michigan (Ridgeview [NAME]) | 01:00 PM
02/20/2015 | Women's Tennis | [NAME] (Ridgeview Racquet Club) | 12:00 PM
02/20/2015 | Women's Tennis | UMBC (Ridgeview Racquet Club) | 04:00 PM
03/07/2015 | Women's Tennis | Cornell (Ridgeview Racquet Club) | 02:00 PM
03/08/2015 | Women's Tennis | [NAME] (Ridgeview Racquet Club) | 09:00 AM
03/13/2015 | Women's Tennis | at Iowa State* | 01:00 PM
03/20/2015 | Women's Tennis | at Kansas State* | 12:00 PM
03/22/2015 | Women's Tennis | at Kansas* | 01:00 PM
03/27/2015 | Women's Tennis | Baylor* (Ridgeview Racquet Club) | 01:00 PM
03/29/2015 | Women's Tennis | Texas* (Ridgeview Racquet Club) | 10:00 AM
04/10/2015 | Women's Tennis | at Texas Tech* | 03:00 PM
04/12/2015 | Women's Tennis | at TCU* | 02:00 PM
04/18/2015 | Women's Tennis | Oklahoma* (Ridgeview Racquet Club) | 01:00 PM
04/19/2015 | Women's Tennis | Oklahoma State* (Ridgeview Racquet Club) | 10:00 AM
[NAME] | Women's Tennis | at Waco, Texas (Big 12 Championship)
04/24/2015 | Women's Tennis | at Waco, Texas (Big 12 Championship)
04/25/2015 | Women's Tennis | at Waco, Texas (Big 12 Championship)
04/26/2015 | Women's Tennis | at Waco, Texas (Big 12 Championship)
Spreadsheet: 47071d1245964558-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: TEST

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS/SPD BULK #1
FACILITY: | UNIVERSITY OF ALBERTA HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: | X | X | X | X | X |  |  |  |  |  |  |  | Hi!
 | *NO STAT HOLIDAYS
 |  |  |  |  |  |  |  |  |  |  |  |  | I have a working knowledge of excel but am stumped; I have an excel file that has roughly 50 worksheets inside of it, 49 of which are invoices (identical in format, differing only in specific product codes/quantities).
** If more/less linen required please fax in this order by 9:30 a.m. (FAX # (780) 451-5125) |  |  |  |  |  |  |  |  |  |  |  |  | On each invoice column E (E19:E23) contains the product codes and to the right column G contains the quantity sold of said product on the same row.
 |  |  |  |  |  |  |  |  |  |  |  |  | The 50th worksheet is a breakdown on summaries of how many of each product (of which there are several dozen) are sent out between all the accounts. That is; on said summary sheet I have two columns, column A (A2:A48) display each of the different 46 product codes, column B (B2:B48) will search all the other workbooks for incidents of the corresponding product code, then add up all of the cells that appear in column G on the same row as those incident cells. That'll tell me how many of each product code were sold in total between all the accounts. If I wasn't dealing with adjacent cells then I could probably figure this formula out.
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD |  | 1 |  | EG
20-WRAPPER 18" |  |  |  | BP0002 |  | 3
20-WRAPPER 24" |  |  |  | BP0003 |  | 20 |  |  |  |  |  |  | On the summary worksheet:
20-WRAPPER 30" |  |  |  | BP0004 |  | 1 |  |  |  |  |  |  | B32= sum(all cells in each worksheet in column g that are on the same row as the product code that matches A32 on the summary worksheet)
20-WRAPPER 45" |  |  |  | BP0006 |  | 20
20-MICRO WRAPS 45" |  |  |  | BP0008 |  | 5 |  |  |  |  |  | BP0007 | I hope that is descriptive enough, thanks in advance for the help
UPDATED:
June 17th 2009
Spreadsheet: 186ef81c-dcc4-4877-896d-e1e0cf549813
Sheet: D

Course color corresponds with term of offering.  ORANGE for Fall semester, PURPLE for J-term, GREEN for both Fall and J-term.
 | AOK Designation | CAR Designation | Comment
Drama
DRAM 111 | Arts & Literature-Arts
DRAM 211 | Arts & Literature-Arts
DRAM 212 | Arts & Literature-Arts
DRAM 215 | Arts & Literature-Arts
DRAM 310 | Arts & Literature-Arts (3 times at 1 hour)
DRAM 320 | Arts & Literature-Arts
 | OR Arts & Literature-Literature
DRAM 330 | Arts & Literature-Arts
DRAM 331 | Arts & Literature-Arts | Computing
DRAM 332 | Arts & Literature-Arts
DRAM 333 | Arts & Literature-Arts
DRAM 334 | Arts & Literature-Arts
DRAM 341 | Arts & Literature-Arts
DRAM 342 | Arts & Literature-Arts
DRAM 381 |  | Experiential-Research
DRAM 381 | Arts & Literature-Arts |  | J-term 2012 (Black American Theater)
DRAM 381 | Arts & Literature-Arts |  | J-term 2013 (Playmaking: The Playwright's Process)
DRAM 382 |  | Experiential-Research
DRAM 422 |  | Experiential-Research; Capstone
Spreadsheet: darrell_schoolcraft__7818__imbalsumm0109
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1 | -98383 | -75000
2 | -98232 | -95000
3 | -47152 | -38250
4 | -5 | -5000
5 | -31
6 | 0
7 | -3
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  | -173605
2001-09-11 00:00:00
CBS Volume
 |  |  | -86184
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: AB Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 02-02) 11-02-2020 | pdf |  | 01-01) 06-01-2020 | pdf |  | 03-01) 11-03-2020 | pdf |  | 01-01) 28-01-2020 | pdf |  | 02-01) 09-02-2020 | pdf
 | 03-01) 17-03-2020 | pdf |  | 02-01) 10-02-2020 | pdf
 |  |  |  | 02-02) 18-02-2020 | pdf
Spreadsheet: 174d2dd1-32e8-45db-8048-451698d0e30b
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
PBPR | Test | PBPR | Primidone and [NAME], Serum | Primidone and [NAME], S | Immunoassay Includes phenobarbital determination. | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube: Red top [NAME]: 1 mL Additional Information: Phenobarbital (metabolite) determination is required for proper interpretation. | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | PRIMIDONE Therapeutic concentration Children (<5 years): 7.0-10.0 mcg/mL Adults: 9.0-12.5 mcg/mL Toxic concentration: > or =15.0 mcg/mL  PHENOBARBITAL Therapeutic concentration Infants and children: 15.0-30.0 mcg/mL Adults: 20.0-40.0 mcg/mL Toxic concentration: > or =60.0 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 1 day |  | Profile |  |  |  |  | Rochester
PBPR | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
PBPR | Result | 31153 | Primidone, S | Primidone, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3978-4 | Primidone:MCnc:Pt:Ser/Plas:Qn:
PBPR | Result | 31154 | Phenobarbital, S | Phenobarbital, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3948-7 | Phenobarbital:MCnc:Pt:Ser/Plas:Qn:
PBPR | Billing Component | PBPR |  | Phenobarbital, S |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 80184
PBPR | Billing Component | PBPR |  | Primidone |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 80188
Spreadsheet: 807599d1669966679-customer-retention-stats-and-staff-bonuses-mock-spreadsheet-for-excel-forum-customer-retention
Sheet: Sheet1

Date | Member | Member ID | Prepared By |  | Member Id | Name | Date Joined | Total Transactions
2022-11-15 16:44:59 | [NAME] | 1 | [NAME] |  | 67 | [NAME] | 2022-11-01 00:00:00 | 2
2022-11-04 17:14:33 | [NAME] | 1 | [NAME] |  | 73 | [NAME] | 2022-11-04 00:00:00 | 2
2022-11-12 16:02:18 | [NAME] | 67 | [NAME] |  | 86 | Angelica Forrester | 2022-11-07 00:00:00 | 2
2022-11-03 15:28:38 | [NAME] | 67 | [NAME] |  | 94 | [NAME] | 2022-11-07 00:00:00 | 4
2022-11-12 13:29:02 | [NAME] | 2 | [NAME]
2022-11-04 19:39:06 | [NAME] | 2 | [NAME]
2022-11-10 15:40:17 | [NAME] | 73 | [NAME]
2022-11-04 17:47:25 | [NAME] | 73 | [NAME]
2022-11-14 13:22:34 | [NAME] | 3 | Carmen
2022-11-05 09:40:35 | [NAME] | 3 | [NAME]
2022-11-10 15:58:54 | Angelica Forrester | 86 | Carmen
2022-11-07 16:37:17 | Angelica Forrester | 86 | Carmen
2022-11-10 18:22:23 | [NAME] | 4 | [NAME]
2022-11-08 17:28:12 | [NAME] | 4 | [NAME]
2022-11-05 14:20:11 | [NAME] | 4 | Carmen
2022-11-02 19:52:28 | [NAME] | 4 | Carmen
2022-11-14 14:47:08 | [NAME] | 94 | [NAME]
2022-11-12 13:52:58 | [NAME] | 94 | [NAME]
2022-11-09 18:28:55 | [NAME] | 94 | [NAME]
2022-11-07 18:57:23 | [NAME] | 94 | [NAME]
Spreadsheet: eric_saibi__9766__012302
Sheet: Unit 06 CTHRSG

Owner Name | NRG Energy Incorporated
Station Name | Long Beach Power Station
Unit Name | Unit 06 CT/HRSG
NERC Region | WSCC
State | CA
Fuel Type | Natural Gas / Jet Fuel
Capacity | 63 MW
Start Date | 2002-01-23 00:00:00
End Date | 2002-01-25 00:00:00
Comments | Inspection
SIC | 4931
Plant ID | 1021594
Unit ID | 1007066
Outage ID | 19589
Spreadsheet: 719289d1613594579-trying-to-use-vlookup-to-search-return-value-text-solved-help-with-vlookup-formula
Sheet: Sheet1

Employee id | Name | Title | badge number |  |  | different sheet
12345 | [NAME] | superviosor a-shift | 1 |  |  | 4465465
4465465 | [NAME] | lead materials | 2 |  |  | 1416546
1416546 | [NAME] | supervisor | 3 |  |  | 464664
13213 | [NAME] | barista | 4 |  |  | 456456
415646 | [NAME] | associate metal working | 5 |  |  | 415646
41646 | [NAME] | press stamp assocate | 6 |  |  | 45869
456456 | [NAME] | press stamp lead | 7 |  |  | 41646
45869 | [NAME] | supervisor maufacturing | 8 |  |  | 13213
464664 | adam wade | barista lead | 9 |  |  | 12345
Spreadsheet: paul_y'barbo__28497__NatGas NYMEX NX3 Settles 2001 MM
Sheet: Price

 |  |  | Cabot LNG Supply Contract
 |  |  | 2002 Estimated Delivered Price
 |  |  | $/MMBtu
 |  | 0.869 | Comm. Charge - Fixed Comp.
 |  | 1.827103333333334 | 5/12 times 0.68 times [NAME]. Jan-May '01 NYMEX NX3
 |  | 0.238 | 1/12 times 0.68 times [NAME]. Jun '01 NYMEX NX3
 |  | 0.2419666666666667 | 1/12 times 0.68 times Avg. Jly '01 NYMEX NX3
 |  | 0.2465 | 1/12 times 0.68 times [NAME]. Aug '01 NYMEX NX3
 |  | 0.2482 | 1/12 times 0.68 times [NAME]. Sep '01 NYMEX NX3
 |  | 0.2499 | 1/12 times 0.68 times [NAME]. Oct '01 NYMEX NX3
 |  | 0.2606666666666667 | 1/12 times 0.68 times [NAME]. Nov '01 NYMEX NX3
 |  | 0.2697333333333333 | 1/12 times 0.68 times [NAME]. Dec '01 NYMEX NX3
 |  |  | Commodity Charge
 |  | 0.866 | Commodity Surcharge
 |  |  | Total Winter Cargo Incremental Cost
 |  |  |  | of Total Winter Cargo Incremental Cost
 |  |  |  | is Essentially Now Known
 |  | Final Contract Settlements
 |  | 4.2 | [NAME]. Jun '01 NYMEX NG NX3
 |  | 4.27 | Avg. Jly '01 NYMEX NG NX3
 |  | 4.35 | [NAME]. Aug '01 NYMEX NG NX3
 |  | 4.38 | Avg. Sep '01 NYMEX NG NX3
 |  | 4.41 | [NAME]. Oct '01 NYMEX NG NX3
 |  | 4.6 | Avg. Nov '01 NYMEX NG NX3
 |  | 4.76 | [NAME]. Dec '01 NYMEX NG NX3