tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: f80912c0-f7fa-458c-b697-bb9f8d21da2d
Sheet: Sheet1

IRN | District | County | Awarded | Disbursed | Org Type
43752 | Cincinnati City | [NAME] | 17450554.31 | 129471.26 | Public District
43794 | Cleveland Heights-University Heights City | Cuyahoga | 1992960 |  | Public District
43786 | Cleveland Municipal | Cuyahoga | 27505290 |  | Public District
43802 | Columbus City School District | Franklin | 20181961 |  | Public District
143412 | Crittenton Community School | Franklin | 650250 | 49111.58 | Community School
43844 | Dayton City | Montgomery | 3154833 |  | Public District
44222 | Lima City | [NAME] | 4057188.57 |  | Public District
44412 | Mt Healthy City | [NAME] | 3327441 | 218813 | Public District
277 | Scholarts Preparatory and Career Center for Children | Franklin | 1500000 | 353898.34 | Community School
44818 | Springfield City | [NAME] | 4244000 | 346096.3 | Public District
45922 | Trimble Local | Athens | 861685 |  | Public District
45153 | Xenia Community City | Greene | 5776119.3 | 656439.3400000001 | Public District
45161 | Youngstown City Schools | Mahoning | 4387311 |  | Public District
 |  |  | 95089593.17999999 | 1753829.82
Spreadsheet: 12f16dea-2fff-47f7-8936-5dafca1b732c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Event:- | Unnamed: 5 | Unnamed: 6 | Date:- | Unnamed: 8
 |  |  |  | OFFICIAL SIGNING-ON SHEET  (TYPE A EVENTS)
The event is being run for and on behalf of Cycling Time Trials under their Rules and Regulations as shown in the current [NAME]. I am conversant with such Rules and Regulations and undertake to abide by them and to participate in the Drug Testing Programme whenever required to do so. I am at present not under suspension by Cycling Time Trials or any organisation with which Cycling Time Trials has an agreement. I accept the decision of the promoter in all the matters concerning the event and my participation in it subject to such rights of appeal or review as may be provided for in the Rules and Regulations of Cycling Time Trials.
I understand that the event is held wholly or in part on public or private property or the public highway and that I participate therein entirely at my own risk and that no liability whatever shall attach to the promoter, promoting club or any officials of the event, Cycling Time Trials or any club affiliated thereto or any member of such club for any injury loss or damage suffered by me in or by reason of the event however such may be caused and whether by negligence or otherwise.
I CONFIRM THAT I HAVE READ ALL THE SAFETY INSTRUCTIONS CONTAINED IN THE START SHEET AND/OR DISPLAYED AT THE SIGNING-ON POINT. I ALSO UNDERSTAND THAT CYCLING TIME TRIALS RECOMMENDS THAT I WEAR A HARD SHELL HELMET THAT MEETS AN INTERNATIONALLY ACCEPTED SAFETY STANDARD.
No. | Name (print) | Signature | No. | Name (print) | Signature | No. | Name (print) | Signature
CYCLING TIME TRIALS IS A COMPANY LIMITED BY GUARANTEE REGISTERED IN ENGLAND No: 4413282   Registered Address: C/O DJH Accountants Ltd, [NAME], High Street, Wolstanton, Newcastle under Lyme, Staffordshire, ST5 0EZ
Spreadsheet: 728037d1618261191-countifs-returning-spill-or-value-error-test_12april21
Sheet: Expected outcome

Accoount ID | Product | 2004748 | 2005459 | 2005653 | 2005598 | 2004879
111587 | Platform |  |  |  | 1 |  |  |  |  |  | *Looking to identify which customres in AllCust list have already purchased a Support material for the same Product in the Support by prod list.
111587 | HR | 1
33569 | HR | 1
33569 | Sales |  |  | 1
47869 | Commerce |  | 1
558896 | Sales |  |  | 1
558879 | Platform |  |  |  | 1
223564 | Service |  |  |  |  | 1
223564 | Platform |  |  |  | 1
557896 | PoS
66989896 | LP
45478 | Accounting
Spreadsheet: 20a1c92a-d213-4060-8fd3-49a7bb0a5a3d
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
[NAME] | Test | [NAME] | Food-Fruit Panel | Food-Fruit Panel | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel			 [NAME]: 0.5 mL Additional Information: See 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
[NAME] | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
[NAME] | Result | [NAME] | Food-Fruit Panel | Food-Fruit Panel | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 46714-2
Spreadsheet: 801184d1666107617-double-look-up-formula-test-excel
Sheet: Sheet1

ID | Start time | Completion time | [NAME] | Name | Date of Submission | Submission Name | Site Location | Maximum Attendance | Any comments / feedback about the event
2 | 2022-09-21 09:59:45 | 2022-09-21 10:03:58 | [EMAIL] | [NAME] | 2022-09-18 00:00:00 | Ferrari | Site 1 | 320
3 | 2022-09-21 10:04:37 | 2022-09-21 10:05:05 | [EMAIL] | [NAME] | 2022-09-20 00:00:00 | Porsche | Site 2 | 460
10 | 2022-09-22 21:58:21 | 2022-09-22 21:58:46 | [EMAIL] | [NAME] | 2022-09-22 00:00:00 | Ford | Site3 | 55
48 | 2022-09-28 13:04:27 | 2022-09-28 13:05:57 | [EMAIL] | [NAME] | 2022-09-22 00:00:00 | Skoda | Site 1 | 20 | Fair amount of interaction, lots of people are now aware of Resx, was just quiet due to not as many people being moved in. Notes from students were to get the Tv working properly
8 | 2022-09-22 21:12:15 | 2022-09-22 21:50:34 | [EMAIL] | [NAME] | 2022-09-22 00:00:00 | Vauxhall | Site 2 | 3 | 3 people played pool at the beginning at about half 5 but from 6 onwards, no one else turned up. When walking around people are visible but they are all together in their own kitchens.
271 | 2022-10-18 13:33:04 | 2022-10-17 13:33:04 | [EMAIL] | [NAME] | 2022-10-17 00:00:00 | Nissan | Site 1 | 3 | Students were mainly directed to Rutland Hall for the workshop
Total
 |  | Site 1 | True
 |  | Site 2 | False
 |  | Site 3 | False
Spreadsheet: 727611d1617980539-i-want-to-populate-information-to-a-calendar-from-a-list-within-a-table-on-a-separate-tab-family-calendar
Sheet: Month View

 | WEEK VIEW | Mom | Dad | [NAME] | [NAME] | Mamaw & Papaw | Bills Due
 | Select Month: | Enter Year: |  |  |  |  | [NAME]
 | April
 | MONTH VIEW
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
Spreadsheet: 674935d1588083592-combination-of-two-iterative-formula-expected
Sheet: Sheet1

 |  | ARRAY 1 |  |  |  |  |  |  |  | 3 | 1
3 | 1 | [NAME] | STEPHEN | JOANNE |  |  |  |  |  | 4 | 2
4 | 2 | TREVOR | THOMAS | FRED | [NAME] |  |  |  |  | 2 | 3
2 | 3 | STEPHEN | ANDREW |  |  |  |  |  |  | 3 | 4
3 | 4 | CRAIG | TREVOR | THOMAS |  |  |  |  |  | 7 | 5
7 | 5 | JOANNE | FRED | TREVOR | THOMAS | [NAME] | [NAME] | [NAME]
ARRAY2 | DESIRED |  | ARRAY2 | DESIRED |  | ARRAY2 | DESIRED |  | ARRAY2 | DESIRED |  | ARRAY2 | DESIRED
[NAME] |  |  | [NAME] |  |  | CRAIG |  |  | [NAME] |  |  | STEPHEN
STEPHEN |  |  | STEPHEN |  |  | THOMAS |  |  | STEPHEN |  |  | ANDREW
 |  |  | CRAIG |  |  |  |  |  | CRAIG
 |  |  |  |  |  |  |  |  | THOMAS
ARRAY2 | DESIRED |  | ARRAY2 | DESIRED |  | ARRAY2 | DESIRED |  | ARRAY2 | DESIRED |  | ARRAY2 | DESIRED
[NAME] | JOANNE |  | [NAME] | JOANNE |  | CRAIG | [NAME] |  | [NAME] | JOANNE |  | STEPHEN | [NAME]
STEPHEN | TREVOR |  | STEPHEN | TREVOR |  | THOMAS | FRED |  | STEPHEN | FRED |  | ANDREW | TREVOR
 | ANDREW |  | CRAIG | ANDREW |  |  | STEPHEN |  | CRAIG | ANDREW
 | CRAIG |  |  | THOMAS |  |  | TREVOR |  | THOMAS | TREVOR |  |  | CRAIG
 | FRED |  |  | FRED |  |  | JOANNE |  |  | [NAME] |  |  | JOANNE
Spreadsheet: 786651d1657325364-count-excel-cells-based-on-two-colums-and-date-being-specific-day-of-week-book1
Sheet: Sheet1

[NAME] | Department | Date/Time of Sale |  | Monday - Friday Install |  | Saturday - Install |  | Any Day - General
[NAME] | Install | 2022-06-20 09:56:47 |  | [NAME] | Fred | [NAME] | Fred | [NAME] | Fred
[NAME] | General | 2022-06-25 08:57:09 |  | 1 | 2 | 0 | 1 | 1 | 2
Fred | Install | 2022-06-25 20:20:32
Fred | Install | 2022-06-24 17:51:27
Fred | Install | 2022-06-20 20:20:32
Fred | General | 2022-06-23 17:51:27
[NAME] | Install
Fred | General | 2022-06-21 17:51:27
Spreadsheet: 274177d1383042350-high-all-rows-with-same-invoice-number-workbooksample
Sheet: Sheet1

Invoice Number | Product Code | Product | Qty
1080 | FFPCJ | Shirt 1 | 1
1080 | FFPCJ | Embroidery for Shirt01 | 1
1082 | AH695 | Shirt 02 | 50
1083 | AH230 | Shirt 03 | 20
1084 | 4133 | Shirt04 White | 1
1084 | 4133 | Shirt04 Black | 1
1084 | 4133 | Embroidery for Shirt 04 | 1
1085 | FPC | Flexfit Curved Peak Cap | 2
1086 | AH715-1 | Hat with front embroidery | 30
1087 | FPC | Shirt 05 | 1
1088 | FPC | Shirt 06 | 1
1088 | FPC | Shirt 06 | 2
 | Task: Identify which invoices refer to ordersthat have embroidery.Highlight row for that invoice.
 | eg Invoice 1080 has 2 items ie a shirt and embroidery. The task is to highlight rows 2 and 3.
 | Invoice 1082 is an order with no embroidery so would not be highlighted.
 | 1084 would be highlighted
 | 1086 would be highlighted as it contains the word embroidery ( despite just having the one item in its Product column)
 | 1082, 1083 1087 and 1088 would not be highlighted as there is no refernce to embroidery.
Spreadsheet: 146863d1332389019-count-if-help-countif
Sheet: HaNoi

 | Product and Code | Price
 | Bike
 | HaNoiB01 | 2000
 | HaNoiB02 | 4000
 | HaNoiB03 | 7000
 | Car
 | HaNoiC01 | 30000
 | HaNoiC02 | 50000
 | HaNoiC03 | 70000
 | House
 | HaNoiH01 | 400000
 | HaNoiH02 | 3000000
 | HaNoiH03 | 9000000
 | Pen house HaNoi | 10000000
 | Private house HaNoi | 8000000
Spreadsheet: daren_farmer__5942__EI330Breveff061000
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/09/00
Subject:  Revised Availabilities Effective 6/10/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-10 00:00:00 | EI 330 B | 623 | 0 |  |  | 363
1st of month DBQ = 363/d
The Sea Robin Plant will shut down Monday, June 12, 2000 at 9:00 a.m. for repairs and maintenance.
The plant should be back up on Thursday, June 15, 2000.
Spreadsheet: 752476d1634781299-needing-help-with-matching-lookup-table-produced-from-mulitple-tables-using-power-query-ctuck1002-
Sheet: Parts Request

NIIN | Nomenclature | U of I | Batch | QTY | Unit Price | Total Price | Location | Date | QTY
Spreadsheet: 69867d1270557190-financial-predictions-financial_predictions
Sheet: Sheet1

Log No | Scheme | Length of Course (Years) | Course Start Date | Course End Date | Amount Approved
D.001 | B | 1 | 2010-05-01 00:00:00 | 2011-02-01 00:00:00 | 350
D.002 | A | 2 | 2010-05-02 00:00:00 | 2012-02-02 00:00:00 | 350 |  |  |  | Select Criteria
D.003 | B | 3 | 2010-05-03 00:00:00 | 2013-02-03 00:00:00 | 350 |  |  |  | > |  | <=
D.004 | B | 4 | 2010-05-04 00:00:00 | 2014-02-04 00:00:00 | 350 |  |  |  | Select Financial Year
D.005 | B | 5 | 2010-05-05 00:00:00 | 2015-02-01 00:00:00 | 350 |  |  |  | 2010-04-01 00:00:00 |  | 2011-03-31 00:00:00
D.006 | A | 3 | 2011-05-05 00:00:00 | 2014-08-01 00:00:00 | 350
D.007 | C | 4 | 2011-12-01 00:00:00 | 2015-09-01 00:00:00 | 350 |  |  |  | Course Start Date |  | Course Start Date |  | Scheme
D.008 | B | 3 | 2012-09-01 00:00:00 | 2015-08-01 00:00:00 | 350 |  |  |  | >01/04/10 |  | <=31/03/11 |  | C
D.009 | A | 3 | 2013-08-01 00:00:00 | 2016-08-01 00:00:00 | 350
[NAME] | B | 2 | 2014-06-01 00:00:00 | 2016-09-01 00:00:00 | 350 |  |  |  | Total per financial Year  (Scheme Costs)
 |  |  |  |  |  |  |  |  | Scheme |  |  | Amount Approved
 |  |  |  |  |  |  |  |  | Scheme
 |  |  |  |  |  |  |  |  | C |  |  | 0
 |  |  |  |  |  |  |  |  | Scheme
 |  |  |  |  |  |  |  |  | C
Sum of Amount Approved
Course Start Date | Scheme | Course End Date | Total
2010 | A | 2012 | 350
 | B | 2011 | 350
 |  | 2013 | 350
 |  | 2014 | 350
 |  | 2015 | 350
2011 | A | 2014 | 350
 | C | 2015 | 350
2012 | B | 2015 | 350
2013 | A | 2016 | 350
2014 | B | 2016 | 350
Grand Total |  |  | 3500
Spreadsheet: 809528d1671129862-amend-filter-function-to-include-data-from-other-columns-ticket-racker
Sheet: Tickets

No. | Date Raised | Company | Rep | Unit | Owner | Summary | Segment |  |  |  |  | Status
4072 |  | Plan A | [NAME] | Spanish | [NAME] | Summary 1 | Segment B
3922 |  | Plan B | Mark | MFP | Mark | Summary 2 | Segment C
2968 |  | Plan C | [NAME] | MFP | [NAME] | Summary 3 | Segment B
1680 |  | Plan D | Test | Meat | Test | Summary 4 | Segment E
2654 |  | Plan C | Test | English | Test | Summary 5 | Segment B
3233 |  | Plan D | Test | Japanese | Test | Summary 6 | Segment D
4631 |  | Plan C | [NAME] | Cars | [NAME] | Summary 7 | Segment 0
4908 |  | Plan E | [NAME] | MFP | [NAME] | Summary 8 | Segment F
Spreadsheet: 860324d1708459965-help-with-formula-example-cf-collors
Sheet: Sheet1

Acct. # |  |  |  |  |  |  | State
64655 |  |  |  |  |  |  | CO
976165 |  |  |  |  |  |  | TN
95546 |  |  |  |  |  |  | FL
855 |  |  |  |  |  |  | NY
24656 |  |  |  |  |  |  | OK
2959 |  |  |  |  |  |  | CA
65866353 |  |  |  |  |  |  | WI
6655 |  |  |  |  |  |  | KY
26565 |  |  |  |  |  |  | CO
Spreadsheet: 082e10bb-b8f1-4eaf-a43c-c62c2e5457fe
Sheet: Sheet1

 | IB 372/EUS 348  Fundamentals Business in the European Union
 | DATE |  | TOPIC | Lecture Notes | Text/Reading Assignments*
 | Section 1 - History of the EU
 | Jan | 15 | Course Overview - Intro to the EU |  | Course Schedule, Syllabus
 |  | 17 | History - The End of WWII & The Origins of the EU |  | Course Packet Readings 1-4
 |  |  |  |  | Address given by [NAME] (Zurich, 19 September 1946) available at http://www.cvce.eu/obj/address_given_by_winston_churchill_zurich_19_september_1946-en-5da812de-3a20-4e2a-9cc1-7e0f90c8f97b.html
 |  | 22 | History - Expansion, Conflict, and Further Integration |  | Course Packet Readings 5-6
 |  | 24 | History - The European Union & The End of the Cold War | [NAME] [NAME] | Course Packet Readings 7-8
 |  |  |  |  | [NAME], [NAME], Nov. 10, 1989: Celebration at the Berlin Wall, ABC World News Tonight, available at http://www.youtube.com/watch?v=snsdDb7KDkg.
 |  | 29 | History - A new Century - Constitutionalism & Lisbon | [NAME], Esq. | Course Packet Readings 9-11
 |  | 31 | !HISTORY QUIZ!
 | Section 2 - Structure & Authority
 | Feb | 5 | Structure - Overview & The Commission |  | Course Packet Readings 10 & 11
 |  | 7 | Structure - The European Council |  | Course Packet Readings 12 & 13
 |  | 12 | Structure - The Council of Ministers |  | Course Packet Readings 14, 15, & 16
 |  | 14 | Structure - The European Parliament |  | Course Packet Readings 17 & 18
 |  | 19 | Structure - Other EU Structures |  | Course Packet Reading 19
 |  | 21 | The Legislative Process |  | Course Packet Reading 20
 |  | 26 | The Legislative Process |  | Course Packet Reading 20
 |  | 28 | Structure - ECJ |  | Course Packet Reading 21 & 22
 | Mar | 5 | Structure - EU Judicial Order | [NAME][NAME], Esq. | Course Packet Readings
 |  | 7 | MID TERM EXAM
 |  | 12 | !!![NAME]!!!
 |  | 14
 | Section 3 - Conducting Business in the EU
 |  | 19 | Maritime Law & Piracy | [NAME], Esq. | Readings in Course Packet
 |  | 21 | Sovereignty/International Law/EU Legal Authority |  | Readings in Course Packet
 |  | 26 | Property/Intro to Four Freedoms | Group Assignments | Readings in Course Packet
 |  | 28 | The Freedom of Goods |  | Readings in Course Packet
 | Apr | 2 | The Freedom of Services |  | Readings in Course Packet
 |  | 4 | The Freedom of Workers |  | Readings in Course Packet
 |  | 9 | The Freedom of Capital |  | Readings in Course Packet
 |  | 11 | Overview |  | Readings in Course Packet
 |  | 16 | [NAME] | Group Presentations | Readings in Course Packet
 |  | 18 | IP Overview | IP Panel | Readings in Course Packet
 |  | 23 | EU Specific IP | [NAME] | Readings in Course Packet
 |  | 25 | E-Commerce |  | Readings in Course Packet
 |  | 30 | Entertainment |  | Readings in Course Packet
 | May | 2 | Course Wrap Up
 |  | 9 | !!!!!FINAL EXAM!!!!! - Thursday, May 9, 7:00–10:00 pm
 | * note that other assignments may be included during the semester
!!!THIS SCHEDULE IS SUBJECT TO CHANGE THROUGHOUT THE SEMESTER BASED ON THE AVAILABILTY OF GUEST LECTURERS!!!
Spreadsheet: 770652d1646214187-data-extraction-formatting-question-movie-database-example-aligw
Sheet: Sheet1

Movie |  | Rank | Date Entered/Released | Category/Country | Director/Lead Actor | Notes |  | Movie | Movie | Movie | Movie | Movie | Rank | Date Entered/Released | Date Entered/Released | Date Entered/Released | Category/Country | Category/Country | Director/Lead Actor | Director/Lead Actor | Notes | Notes |  | AliGW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
 |  | 1 | Entered: 3/14/1972 | Category: Drama | Director: [NAME] | Best Actor : [NAME] (W) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES |  | Misspelling!
The Godfather |  |  | 177 mins | Country: USA | Lead Actor : [NAME] | Language: English |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A
Rank: 1 | Type: Drama |  | Database: 3/24/1972 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME]: 21 | Academy Awards: 3
 |  | 2 | Entered: 12/10/1962 | Category: Drama | Director: [NAME] | Best Actor : [NAME]
[NAME] |  |  | 227  mins | Country: UK | Lead Actor: [NAME] | Language: English
Rank: 2 | Type: Drama |  | Database: 01/28/2022
[NAME]: 25 | Academy Awards: 7
 |  | 3 | Entered: 12/22/1965 | Category: Drama | Director: [NAME] | Best Actor : N/A |  | The Godfather | Rank: 1 | [NAME]: 21 | Type: Drama | Academy Awards: 3 | 1 | Entered: 3/14/1972 | 177 mins | Database: 3/24/1972 | Category: Drama | Country: USA | Director: [NAME] | Lead Actor : [NAME] | Best Actor : [NAME] (W) | Language: English
Doctor [NAME] |  |  | 200 mins | Country: UK, Italy, USA | Lead Actor : [NAME] | Language: English |  | [NAME] | Rank: 2 | [NAME]: 25 | Type: Drama | Academy Awards: 7 | 2 | Entered: 12/10/1962 | 227  mins | Database: 01/28/2022 | Category: Drama | Country: UK | Director: [NAME] | Lead Actor: [NAME] | Best Actor : [NAME] | Language: English
Rank: 3 | Type: Drama |  | Database: 9/28/1999 |  |  |  |  | Doctor [NAME] | Rank: 3 | [NAME]: 18 | Type: Drama | Academy Awards: 5 | 3 | Entered: 12/22/1965 | 200 mins | Database: 9/28/1999
[NAME]: 18 | Academy Awards: 5 |  |  |  |  |  |  | My Fair Lady | Rank: 4 | [NAME]: 10 | Type: Musical | Academy Awards: 8 | 4 | Entered: 10/21/1964 | 170 mins | Database: 2/24/1970
 |  | 4 | Entered: 10/21/1964 | Category: Musical | Director: [NAME] | Best Actor : [NAME] (W)
My Fair Lady |  |  | 170 mins | Country: USA | Lead Actor : [NAME] | Language: English
Rank: 4 | Type: Musical |  | Database: 2/24/1970
[NAME]: 10 | Academy Awards: 8
Spreadsheet: andy_zipper__244__DYNEGY-ICE VOL Jun4
Sheet: DD-Lookup

Dynegy DIrect
User Lookup
ENA |  |  | EPM |  |  | EGL |  |  | Count of Transaction ID
User Name | Real Name |  | User Name | Real Name |  | User Name | Real Name |  | Units | Total | DELIVERY | CONV
AFAIRLEY | [NAME] |  | CDEANEPM | [NAME] |  | AGROSSPHY | [NAME] |  | Barrel | 4 | Monthly
AGOSALIA | [NAME] |  | DBAUGHMANPHY | [NAME] |  | EGLSTHOM | [NAME] |  | Barrel per day | 1
AGROSS | [NAME] |  | EMETOYEREPM | [NAME] |  | LJACKSONPHY | [NAME] |  | Barrel per month | 295 | Monthly
AZIPPER | [NAME] |  | ENAPDADAM | [NAME] |  | WWHICKSPHY | Wade Hicks |  | [NAME] | 7
BGUILMINO | [NAME] |  | ENAPJLAVO | [NAME] |  | 0 | No Activity |  | [NAME] | 13 | Monthly | 42
BHENDRY | Brent Hendry |  | ENAPRHERN | [NAME] |  |  |  |  | GJ | 200
CDEANENA | [NAME] |  | ENAPSHAN | [NAME] |  |  |  |  | IPE mt | 9
CPENNIX | [NAME] |  | ENPSTHOM | [NAME] |  |  |  |  | LME Registered 20 mt LOT | 5
[NAME] | [NAME] |  | ESAIBIEPM | [NAME] |  |  |  |  | LME Registered 25 mt Lot | 452
DBAUGHMAN_PHY | [NAME] |  | GGUPTA_PHY | [NAME] |  |  |  |  | LME Registered 5 mt LOT | 10
DHYVL1 | [NAME] |  | JKINGEPM | [NAME] |  |  |  |  | LME Registered 6 mt Lot | 33
DSAMUELS | [NAME] |  | JSTEPENO_PHY | [NAME] |  |  |  |  | MMBtu | 3364
EMETOYER | [NAME] |  | KTHOMPSONEPM | [NAME] |  |  |  |  | MMBtu/Lots (Options) | 13 |  | 10000
ENECGERMANY | [NAME] |  | MCARSONEPM | [NAME] |  |  |  |  | mt | 3
ENECUILLA | [NAME] |  | NMISRA_PHY | Narsimha Misra |  |  |  |  | MWh | 811
ENEDADAM | [NAME] |  | PMAKKAIEPM | [NAME] |  |  |  |  | MWh (Canada) | 8
[NAME] | [NAME] |  | RSTALFORD_PHY | [NAME] |  |  |  |  | therm | 87
ENEHENDR | [NAME] |  | SPIWETZEPM | [NAME] |  |  |  |  | Thousand Board Feet | 1
ENEJARNO | [NAME] |  | TMAY_PHY | [NAME] |  |  |  |  | (blank)
ENEJMCKA | [NAME] |  | 0 | No Activity |  |  |  |  | European Alum 25 mt Lot | 1 | Monthly
ENEJOLAV | [NAME] |  |  |  |  |  |  |  | [NAME]/month | 1 | Monthly
ENEJSHAN | [NAME] |  |  |  |  |  |  |  | IPE Barrels | 6
ENEJTOWNSEND | [NAME] |  |  |  |  |  |  |  | Emission allowance | 2
ENEJUNEK | [NAME] |  |  |  |  |  |  |  | Crack bl/m | 2
ENEMCKAY | [NAME] |  |  |  |  |  |  |  | Pound | 2
ENEPEREI | [NAME] |  |  |  |  |  |  |  | [NAME] (+/- 5%) | 1
ENERHERN | [NAME] |  |  |  |  |  |  |  | Grand Total | 5331
ENERING | [NAME]
ENESANDRA | [NAME]
ENESTHOM | [NAME]
ENETHUR | Patrice Mims-Thurston
ENEVVERS | [NAME]
ENEkelli | [NAME]
ESAIBIENA | [NAME]
GGUPTA_FIN | [NAME]
GWHALLEY | [NAME]
JARNOLD | [NAME]
[NAME] | [NAME]
JBELL1 | [NAME]
JKING1 | [NAME]
JLAVORATO | [NAME]
JMASSEY | [NAME]
JMASSEY1 | [NAME]
JSHANKMAN | [NAME]
JSTEPENO_FIN | [NAME]
JTHOME | [NAME]
KMCGOWAN | [NAME]
KTHOMPSON | [NAME]
LHANSEN | [NAME]
LJACKSON | [NAME]
LKITCHEN | [NAME]
MBRIDGES | [NAME]
MCARSONENA | [NAME]
MNETTEL | [NAME]
NMISRA_FIN | Narsimha Misra
PMAKKAIENA | [NAME]
PTHOMASENA | [NAME]
RHERNDON | [NAME]
RJAFRY | [NAME]
RSTALFORD_FIN | [NAME]
RTOMASKI | [NAME]
SPIWETZ | [NAME]
SSEVER | [NAME]
SSHACKLE | [NAME]
TJONES | [NAME]
TKUYKENDALL | Tori Kuykendall
TMAY_FIN | [NAME]
WGRESHAM | [NAME]
WWHICKSFIN | Wade Hicks
ENESTOREY | [NAME]
0 | No Activity
Spreadsheet: 60724d1261251105-if-question-example-sheet
Sheet: Folha2

[NAME] |  |  |  |  | L1 | L2 | L3 |  |  | For format L1, any name with or without * is compatible. Total born age must not exceed 5935.
[NAME] |  |  |  |  | comp/incomp | comp/incomp | comp/incomp |  |  | For format L2, any name with or without * is compatible. Total born age must be 5936 or more.
[NAME] |  |  |  |  |  |  |  |  |  | For format L3, any name with * is incompatible. Total born age must not exceed 5935.
 |  |  |  |  |  |  |  |  |  | Note that in the original working sheet I actually changed so that zero shows blank.
A2:A4 represent the selected 3 names
The objective is to know if the 3 names I insert in the A column are or not compatible torwards a "format" that includes restrictions