tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 111072d1307559594-array-formula-based-on-cell-entry-internship_program_test
Sheet: College

Entity | College | Region | Applied | Failed | Eligible | Passed | Hold | Intern
Denver | Colorado State | [NAME], CO | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Denver | CU Boulder | Boulder, CO | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Denver | CU Denver | Denver, CO | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Denver | Front Range CC | Boulder, CO | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Denver | Johnson & Wales | Denver, CO | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Denver | Metro State College | Denver, CO | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Denver | Regis University | Denver, CO | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Denver | University of Colorado | Denver, CO | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Denver | University of Denver | Denver, CO | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Florida | Florida Atlantic | [NAME], FL | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Florida | University of Miami | Coral Gables, FL | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Florida | University of South Florida | Tampa, FL | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Los Angeles | Belmont | Nashville, TN | 0 | 0 | 0 | 0 | 0 | 0
Los Angeles | [NAME] | Boston, MA | 0 | 0 | 0 | 0 | 0 | 0
Los Angeles | [NAME] | [NAME], CA | 0 | 0 | 0 | 0 | 0 | 0
Los Angeles | Chapman | Orange, CA | 0 | 0 | 0 | 0 | 0 | 0
Los Angeles | [NAME] | Chico, CA | 0 | 0 | 0 | 0 | 0 | 0
Los Angeles | [NAME] | Dominguez Hills, CA | 0 | 0 | 0 | 0 | 0 | 0
Los Angeles | [NAME] | [NAME], CA | 0 | 0 | 0 | 0 | 0 | 0
Los Angeles | CSU Long Beach | Long Beach, CA | 0 | 0 | 0 | 0 | 0 | 0
Los Angeles | CSU Northridge | Northridge, CA | 0 | 0 | 0 | 0 | 0 | 0
Los Angeles | [NAME] | [NAME], CA | 0 | 0 | 0 | 0 | 0 | 0
Los Angeles | FIDM | Los Angeles, CA | 0 | 0 | 0 | 0 | 0 | 0
Los Angeles | Loyola Marymount | Los Angeles, CA | 0 | 0 | 0 | 0 | 0 | 0
Los Angeles | Santa Monica College | Santa Monica, CA | 0 | 0 | 0 | 0 | 0 | 0
Los Angeles | UC [NAME] | [NAME], CA | 0 | 0 | 0 | 0 | 0 | 0
Los Angeles | UC Riverside | Riverside, CA | 0 | 0 | 0 | 0 | 0 | 0
Los Angeles | UCLA | Los Angeles, CA | 0 | 0 | 0 | 0 | 0 | 0
Los Angeles | USC | Los Angeles, CA | 1 | 0 | 1 | 1 | 0 | 0
Spreadsheet: 091a24fc-1f7c-425d-bf6b-8405cc854ab9
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5961 | 45561 | Samantha | Moreira | BRA | 0 | [NAME] | 00:00:00 | 02:29:39 | 00:00:00 | 01:55:59 | 1 | 05:33:44
5961 | 45660 | [NAME] | Paz | BRA | 0 | 01:05:53 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 40577229-8ba7-4a13-b7f4-90e46cfff861
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
8777 | 69395 | Luca | Rodano | ITA | 140 | 00:16:49 | 00:00:52 | 00:25:14 | 00:01:23 | 00:22:24 | 1 | 01:06:44
Spreadsheet: 56c990ac-407e-4a47-af10-6308fc850f68
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
FGLUT | Test | FGLUT | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain, red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | < 2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:  Viracor-IBT Laboratories                               1001 NW Technology Dr.                               Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FGLUT | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FGLUT | Result | FGLUT | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 84095d1284090814-date-not-working-in-pivot-table-book1-1-pvt
Sheet: pivot

Sum of Qty | Column Labels
Row Labels | Jul | Aug | Grand Total
Big W | 10 | 10 | 20
Kmart | 10 | 10 | 20
Priceline | 10 | 10 | 20
Grand Total | 30 | 30 | 60
Spreadsheet: 41dab20d-7812-4c52-8c86-2706dfa4b5ba
Sheet: Sheet1

UNITED STATES OF AMERICA CRICKET UMPIRES ASSOCIATION, INC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Assessors and Dates of Assessments  2008
 | Sunday June 15, 2008 | Sunday  June 22, 2008 | Sunday June 29, 2008. | Sunday July 13, 2008 | Sunday July 20, 2008 | Sunday July 27, 2008 | Sunday August 10, 2008 | Sunday  August 17, 2008. | Sunday August  24, 2008th. | Sunday  August 31, 2008
ASSESSEES
Myers, [NAME]      [PHONE] | F.Hayles        [PHONE]  [PHONE] |  | [NAME][PHONE]   [PHONE] |  | L.Champagnie [PHONE]   [PHONE] | A.Naughton [PHONE] |  | [NAME][PHONE]   [PHONE] |  | S.Kalloo         [PHONE]   [PHONE]
[NAME], [NAME] | M.Baksh          [PHONE]   [PHONE] |  | F.Hayles        [PHONE]  [PHONE] | L.Champagnie [PHONE]   [PHONE] | V.Nesfield          [PHONE]     [PHONE] |  | A.Naughton     [PHONE] |  | [NAME][PHONE]   [PHONE]
[NAME], Lance |  | V.Nesfield          [PHONE]     [PHONE] | A.Naughton [PHONE] |  | [NAME]     [PHONE] | M.Baksh          [PHONE]   [PHONE] | [NAME][PHONE]   [PHONE] | S.Kalloo        [PHONE]    [PHONE]
Modeste, Clarence |  | [NAME]  [PHONE] |  | F.Hayles        [PHONE]  [PHONE] | S.Kalloo         [PHONE]   [PHONE] |  | M.Baksh        [PHONE] | A.Naughton       [PHONE] |  | L.Champagnie [PHONE]   [PHONE]
[NAME], [NAME]2270 |  | F.Hayles        [PHONE] | L.Champagnie [PHONE]   [PHONE] | S.Kalloo         [PHONE]   [PHONE] |  | [NAME][PHONE]   [PHONE] |  | V.Nesfield          [PHONE]     [PHONE] |  | L.G. Scott    [PHONE]
Brathwaite, Cosmo |  | S.Kalloo         [PHONE]   [PHONE] | V.Nesfield          [PHONE]     [PHONE] | A.Naughton       [PHONE] |  |  | L.Champagnie [PHONE]   [PHONE] | F.Hayles        [PHONE]  [PHONE] |  | M.Baksh          [PHONE]   [PHONE]
Spreadsheet: 23c6ca8d-c7a8-4c98-93c7-d6ab9371a31c
Sheet: 2005

Month | Date | Object Code | Category | Amount
January | 2005-01-08 00:00:00 | 3209 | Computer equipment | 389
January | 2005-01-12 00:00:00 | 4100 | Office supplies | 28.19
January | 2005-01-15 00:00:00 | 1909 | Salary faculty | 3009
January | 2005-01-15 00:00:00 | 2999 | [NAME] staff | 109222
February | 2005-02-02 00:00:00 | 4100 | Office supplies | 55.98
February | 2005-02-15 00:00:00 | 1909 | Salary faculty | 90832
February | 2005-02-15 00:00:00 | 2999 | [NAME] staff | 5609
February | 2005-02-19 00:00:00 | 3209 | Computer equipment | 218.2
February | 2005-02-25 00:00:00 | 4100 | Office supplies | 109.8
March | 2005-03-03 00:00:00 | 3209 | Computer equipment | 18.84
March | 2005-03-07 00:00:00 | 4100 | Office supplies | 256.78
March | 2005-03-15 00:00:00 | 1909 | Salary faculty | 25000
March | 2005-03-15 00:00:00 | 2999 | [NAME] staff | 905423
March | 2005-03-15 00:00:00 | 4100 | Office supplies | 134
March | 2005-03-18 00:00:00 | 4100 | Office supplies | 128.75
March | 2005-03-21 00:00:00 | 4100 | Office supplies | 2094
March | 2005-03-22 00:00:00 | 4100 | Office supplies | 309
March | 2005-03-29 00:00:00 | 3209 | Computer equipment | 3005
March | 2005-03-29 00:00:00 | 3219 | Computer software | 589
April | 2005-04-03 00:00:00 | 3209 | Computer equipment | 278.21
April | 2005-04-04 00:00:00 | 3219 | Computer software | 21900
April | 2005-04-05 00:00:00 | 3219 | Computer software | 489
April | 2005-04-07 00:00:00 | 4100 | Office supplies | 89.1
April | 2005-04-28 00:00:00 | 3209 | Computer equipment | 3897
April | 2005-04-29 00:00:00 | 3209 | Computer equipment | 47
May | 2005-05-05 00:00:00 | 4100 | Office supplies | 87.45
May | 2005-05-15 00:00:00 | 1909 | Salary faculty | 21250
May | 2005-05-15 00:00:00 | 2999 | [NAME] staff | 1986
May | 2005-05-15 00:00:00 | 3209 | Computer equipment | 58.9
May | 2005-05-16 00:00:00 | 4100 | Office supplies | 44.7
May | 2005-05-17 00:00:00 | 4100 | Office supplies | 35.9
May | 2005-05-20 00:00:00 | 4100 | Office supplies | 29.9
June | 2005-06-15 00:00:00 | 2999 | [NAME] staff | 90021
June | 2005-06-25 00:00:00 | 3209 | Computer equipment | 189
June | 2005-06-28 00:00:00 | 4100 | Office supplies | 9.76
June | 2005-06-29 00:00:00 | 4100 | Office supplies | 100.87
Spreadsheet: 680034d1590755360-consolidate-information-and-return-a-value-with-max-results-in-the-row-return-value-in-a-row
Sheet: Sheet1

 | name1 | 1 | 2019-01-01 00:00:00 |  | Return: name1: 2
 | [NAME] |  | 2019-01-02 00:00:00 |  | Return: name4: 3
 | name3 | 1 | 2019-01-03 00:00:00
 | name4 | 1 | 2019-01-04 00:00:00
 | name5 | 1 | 2019-01-05 00:00:00
 | [NAME] |  | 2019-01-06 00:00:00
 | name3 |  | 2019-01-07 00:00:00
 | name4 | 1 | 2019-01-08 00:00:00
 | name5 |  | 2019-01-09 00:00:00
 | name1 | 1 | 2019-01-10 00:00:00
 | [NAME] |  | 2019-01-11 00:00:00
 | name3 |  | 2019-01-12 00:00:00
 | name4 | 1 | 2019-01-13 00:00:00
 | name5 |  | 2019-01-14 00:00:00
 | [NAME] | 1 | 2019-01-15 00:00:00
Spreadsheet: 88021d1287923050-auto-sorting-and-grouping-data-by-column-sorting10000
Sheet: Salaries

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Uneducated
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unlisted | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Builders | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dockworkers | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teamsters | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tenements | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High School
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unlisted | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Soldiers | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teachers | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apartments | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | College
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unlisted | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Generals | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Professors | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Condos | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inflation | 0
Spreadsheet: 4cf68bd2-4ca7-445d-ae17-73bb19c2c2a3
Sheet: HCA Clinic

HCA 17th Street Testing, Treatment and Care
1725 W. 17th Street
Santa Ana, CA 92706
Main Phone Line (HIV): (714) 834-7991
Main Fax (HIV): (714) 834-8275
Main Phone Line (STD): (714) 834-8787
Main Fax (STD): (714) 834-8395
Name and Title | Role | Contact Email | Contact Phone Number | Fax Number
[NAME], Program Manager | Oversees clinic administrative functions and grant administration | [EMAIL] | (714) 834-8405 | (714) 834-8270
[NAME], Medical Director | Oversees clinic medical services | [EMAIL] | (714) 834-8598 | (714) 834-8395
[NAME], Supervising Public Health Nurse | Oversees nursing services | [EMAIL] | (714) 834-8256 | (714) 834-8395
[NAME], Program Supervisor | Oversees HIV testing, court-ordered testing, Partner Services, and disease control and investigation | [EMAIL] | (714) 834-7833 | (714) 834-7922
[NAME], Program Supervisor | Oversees eligibility services, office staff, and grants management | [EMAIL] | (714) 834-7966 | (714) 834-8655
[NAME] "Page" Brockman, Service Chief | Supervises case managers | [EMAIL] | (714) 834-7883 | (714) 834-8395
[NAME], Office Supervisor | Supervises office staff | [EMAIL] | (714) 834-8107 | (714) 834-8395
Dr. [NAME] | Psychiatrist | [EMAIL] | (714) 834-7963 | (714) 834-8395
[NAME] | Staff Specialist | [EMAIL] | 7145676239 | 7148348395
[NAME] | Case Manager | [EMAIL] | (714) 834-8565 | (714) 834-8395
[NAME] | Case Manager | [EMAIL] | (714) 834-8477 | (714) 834-8395
Lucilia Tarabay | Case Manager | [EMAIL] | (714) 834-8132 | (714) 834-8395
[NAME] | Outreach Worker | [EMAIL] | (714) 834-8524 | (714) 834-8395
[NAME] | Specialty Care Coordinator | [EMAIL] | (714) 834-8026 | (714) 834-8418
[NAME] | Eligibility Worker | [EMAIL] | (714) 834-8175 | (714) 834-8655
[NAME] | Eligibility Worker | [EMAIL] | (714) 834-7823 | (714) 834-8655
Carmen Carlos | Eligibility Worker | [EMAIL] | (714) 834-7837 | (714) 834-8655
[NAME] | Eligibility Worker | [EMAIL] | (714) 834-7882 | (714) 834-8655
[NAME] | Eligibility Worker | [EMAIL] | (714) 834-8456 | (714) 834-8655
Spreadsheet: 586795d1534633432-basketball-table-and-best-second-places-womens-eb-qualifier-tables
Sheet: Group H

GROUP H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS | rank
Team name | Bonus/penalty points
Macedonia
Italy
Croatia
Sweden
ROUND 1 |  |  |  |  |  |  | Table
 |  | 52 | : | 61
 |  | 71 | : | 83 |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS
 |  |  | :
 |  |  | :
 |  | 63 | : | 55
 |  |  | :
ROUND 2
 |  | 93 | : | 33
 |  |  | :
 |  | 91 | : | 51
 |  | 47 | : | 108
 |  | 54 | : | 57
 |  | 47 | : | 69
ROUND 3
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
ROUND 4
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
Spreadsheet: 41250d1239739584-updating-dates-on-separate-tabs-based-on-date-in-first-tab-form-booking-sheets-all-1
Sheet: T2

Boeing Tour - AM |  |  |  |  | 2009-05-09 00:00:00
 | Driver: |  |  |  | Vehicle: |  |  |  |  |  | Prepaid
P/U Time | Booked by |  | Hotel |  | Party | A | C | CT | MF | Amt | CC | Ck | Collect | [NAME]
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
Retail: | Adult | 55 | Child | 45 | Reseller: | Adult |  | 44 | Child |  | 36
Resellers: Alcatraz Media, [NAME], Look Tours, Sightseeing World, TourCorp
Driver Pickup Summary
Spreadsheet: benjamin_rogers__1227__UAE with 2 LM's & debt structure 04-21-00
Sheet: Capital Budget

UAE Lowell Power Expansion |  | PRELIMINARY DATA; ENGINEERING STUDY UNDERWAY TO CONFIRM ASSUMPTIONS
Capital Cost  [NAME] ($ = 000's)
 | 5x GE LM 6000 Base Package - Simple Cycle | DLE Combustor | 0 | (1=yes, 0=no)
 | Feb 23 Meeting with Enron Capital and Trade
 |  | Lowell Expansion |  |  |  |  | GT Pro
Gas Turbine Package |  | Equipment | Installation | Total | Per Unit
 | Gas Turbine Generator | 69000 | 1000
 | Sprint Package Adder (unavail w/DLE) |  | 0
 | Inlet Air Chiller | 3800 | 250 |  |  |  | 4278
 | Switchgear/MCC/Relays/Breaker Set | 1000 | 250 |  |  |  | 770
 | Stack(s)/Noise Attenuation/Buildings | 1250 | 250
 | Water Tube Oil Cooler | 0 | 0
 | Freight | 500 | 0
 | Spare Parts Inventory | 350 | 0 |  |  |  | 250
Total Base Package
Emissions Controls
 | Vanadium-Titanium SCR (to 2 ppm NOX) | 4600 | 250
 | CO Oxidation Catalyst (to 10ppm CO) | 1000 | 100
 | Dry Low Emissions (DLE) Combustor Adder |  | 200
Balance Of Plant
 | Pads and Grading | 1200 | 400
 | Fuel Gas Compressors | 1000 | 250
 | Control Room (upgrade to existing unit) | 250 | 100
 | Controls For Remote Operation | 50 | 50
 | [NAME] (for Sprint/Water Inj) |  | 100
 | Fire Protection | 300 | 100
 | [NAME] for Chiller | 1200 | 350
 | Ammonia System (Tanks, Unldg./Fwdg. Pumps) | 250 | 50
 | Step-Up Transformer(s) | 1500 | 300
 | Piping | 300 | 120
 | Wiring | 700 | 450
 | [NAME] Monitoring | 550 | 150
 | Other | 0 | 0
Total Emissions and BOP
Total EPC
Owner's Cost
 | Air Permitting | 500
 | Air Permit Fees | 25
 | Boston Gas Upgrades | 2000
 | Utility Connection Cost (NEP) | 750
 | Interconnect Study (NEP) | 250
 | Property Purchase | 1000
 | Water/Sewer Connect | 200
 | Phase I/Phase II Environmental Review | 35
 | Engineering Plant Specification | 50
 | Engineering (Studies/Services/Conceptual) | 75
 | Development/Construction Management | 600
 | Interest During Construction
 | [NAME]. Permits/Fees
 | Legal Fees | 500
 | Bank Fees | 500
 | Emissions Offsets | 350
 | Working Capital
 | Miscellaneous Consultants | 100
 | Owner's Contingency (3% of EPC)
Total Owner's
Commissioning
 | Site Infrastructure (roads, landscape, neighbors) | 250
 | Start Up | 500
Total Commissioning
Total
 | Base Package
 | BOP
 | Sales Tax (5.0%)
 | Owner's Cost
 | Other Costs
Total Capital Cost
ISO Output (MW) |  |  |  |  | 45.5
$/kW
 | DLE Estimated Output at 90 deg F | 221.6
 | Sprint/Water Inj Estimated Output at 90 deg F | 227.5
Spreadsheet: 790725d1659966686-count-each-element-in-the-column-and-assign-it-to-the-row-it-is-responsible-for-workbook1
Sheet: Sheet1

Machines | Host | VLAN
Machine11 | esxi-1 | 3,69 |  |  |  |  |  | Host   \ [NAME] | 3 | 69 | 3501 | 6 | 3007 | 1274 | 17 | 18
Machine12 | esxi-1 | 3501 |  |  |  |  |  | esxi-1
Machine13 | esxi-1 | 3501,6 |  |  |  |  |  | esxi-2
Machine14 | esxi-1 | 3501,3
Machine15 | esxi-1 | 3007,  1274, 3501
Machine16 | esxi-1 | 3007,  1274, 3501
Machine21 | esxi-2 | 17,18,19,3501
Machine22 | esxi-2 | 20,23,822,3501
Machine23 | esxi-2 | 24,25,298,3501
Machine24 | esxi-2 | 26,27,818
Spreadsheet: 107006d1304157664-lookup-a-value-based-on-2-criteria-one-being-a-date-relative-to-today-relative-date
Sheet: Sheet1

NAME | DATE | HOURS | 28 Day intervals | End of Month
BOB | 2011-01-31 00:00:00 | 100
DOUG | 2011-01-31 00:00:00 | 100
PHIL | 2011-01-31 00:00:00 | 100
HARRY | 2011-01-31 00:00:00 | 100
ANDY | 2011-01-31 00:00:00 | 100
 |  |  |  |  |  |  | HOURS TO DATE |  | Pre 2007 solution
 |  |  |  |  |  | BOB
BOB |  |  |  |  |  | DOUG
DOUG |  |  |  |  |  | PHIL
PHIL |  |  |  |  |  | HARRY
HARRY |  |  |  |  |  | ANDY
ANDY
BOB
DOUG
PHIL
HARRY
ANDY
BOB
DOUG
PHIL
HARRY
ANDY
BOB
DOUG
PHIL
HARRY
ANDY
BOB
DOUG
PHIL
HARRY
ANDY
BOB
DOUG
PHIL
HARRY
ANDY
Spreadsheet: 848467d1699201240-how-to-filter-select-specific-strings-from-a-big-database-if-and-or-search-left-example-for-forum-3-nov-2023-jacc-2_extended
Sheet: Forum (3)

 |  |  |  |  |  |  |  |  |  | How can I adapt the formula to only exclude strings that start with "Method", "A method", "The Method"?
 |  |  |  |  | A
Some examples for strings that occur in the big data sheet (80 columns; 900 rows) |  |  |  | Two attemps from myself (but not succesful yet) | An | according to claim |  |  |  | Method
 |  |  |  |  |  | as claimed |  |  |  | A method
Attempt 1 |  |  |  |  |  | according to any of the preceeding claim |  |  |  | The method
Apparatus for controlling a flow of molten source material | Apparatus for controlling something different | A method for controlling a flow
A method of improving a measurement of a parameter of interest | A method of improving a measurement of a parameter of interest | A method as claimed in claim 1
A lithographic apparatus | A lithographic apparatus comprising: [NAME] and the processing arrangement of claim XXX. | Exposure apparatus
An apparatus to perform the method of any of claims 1 to 14. | An apparatus | An apparatus, comprising a component
Method for control a flow | Method for controlling a flow according to claim 1 | The method for controlling a flow according to claim 1 or 2
An apparatus according to claim 1 | An optical arrangement as claimed in claim 1 | An apparatus according to any of the preceding claims
 |  |  |  |  | Apparatus for controlling something different | A method for controlling a flow |  |  |  |  |  | Apparatus for controlling something different
 |  |  |  | A method of improving a measurement of a parameter of interest | A method of improving a measurement of a parameter of interest
 |  |  |  | A lithographic apparatus | A lithographic apparatus comprising: [NAME] and the processing arrangement of claim XXX. | Exposure apparatus |  |  |  |  | A lithographic apparatus | A lithographic apparatus comprising: [NAME] and the processing arrangement of claim XXX. | Exposure apparatus
 |  |  |  | An apparatus to perform the method of any of claims 1 to 14. | An apparatus | An apparatus, comprising a component |  |  |  |  | An apparatus to perform the method of any of claims 1 to 14. | An apparatus | An apparatus, comprising a component
 |  |  |  | Method for control a flow
Spreadsheet: 167617d1342039551-sum-per-10-cells-summingevery100cells
Sheet: Φύλλο1

1 | 1
2
3
4
5 | 5
6
7
8
9
10 | 10
11
12
13
14
15 | 15
16
17
18
19
20 | 20
21
22
23
24
25 | 25
26
27
28
29
30 | 30
Spreadsheet: 830159d1684757661-distinct-values-based-on-multiple-criteria-edit-distinct-values-based-on-multiple-criteria-1-
Sheet: Sheet2

Client | Order Date | Order Month | [NAME] | List: | Dwight | Number of Clients | Number of Distinct Clients
Client 3 | 2023-05-05 00:00:00 |  | [NAME] |  | July
Client 3 | 2023-01-06 00:00:00 |  | [NAME] |  | August
Client 3 | 2023-01-07 00:00:00 |  | [NAME] |  | September
Client 3 | 2023-02-08 00:00:00 |  | Shane |  | October
Client 3 | 2023-05-09 00:00:00 |  | Shane |  | November
Client 6 | 2023-05-10 00:00:00 |  | Shane |  | December
Client 6 | 2023-04-11 00:00:00 |  | Shane |  | January
Client 6 | 2023-04-12 00:00:00 |  | Dwight |  | February
Client 9 | 2023-05-13 00:00:00 |  | Dwight |  | March
Client 10 | 2023-05-14 00:00:00 |  | Dwight |  | April
Client 10 | 2023-05-15 00:00:00 |  | Dwight |  | May
Client 10 | 2023-05-16 00:00:00 |  | Dwight |  | June
Client 10 | 2023-03-17 00:00:00 |  | Dwight |  | Total
Client 14 | 2023-02-18 00:00:00 |  | Dwight
Client 14 | 2023-05-19 00:00:00 |  | Dwight
Client 14 | 2023-05-20 00:00:00 |  | Dwight
Client 14 | 2023-03-21 00:00:00 |  | Dwight
Client 14 | 2023-03-22 00:00:00 |  | Dwight
Spreadsheet: darrell_schoolcraft__7735__imball0203
Sheet: Devon

 | Devon SFS Operating
 | POI 36289 - Bilbrey 28 Fed 1 C/P
Day | Measured | Scheduled
1 | 14 | 429
2 | 39 | 429
3 | 3 | 429
4 |  | 429
5 |  | 247
6 |  | 388
7 |  | 381
8 |  | 346
9 | 22 | 429
10 |  | 418
11 |  | 429
12 |  | 429
13 |  | 96
14 | 28 | 96
15 | 271 | 96
16 | 769 | 96
17 | 595 | 96
18 | 421 | 96
19 | 364 | 96
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | 147710.85
2002-03-19 00:00:00
CBS Volume
 |  |  | 27432