tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 27010288-fc1e-4329-9218-df426fa00c3d
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
USNU | Test | USNU | Ustilago nuda, [NAME], IgE | [NAME], [NAME], 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
USNU | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
USNU | Result | USNU | [NAME], [NAME], IgE | [NAME], [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 46721-7 | Ustilago [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 2d16e83d-3606-4a6a-a223-5d39c5f76dd3
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Flöha, Stadt - Variante 1
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 1557 | 1618 | 1573 | 1468
20 - 65 | 6828 | 6354 | 5563 | 4888
65 und mehr | 3116 | 3091 | 3295 | 3459
Insgesamt | 11501 | 11063 | 10431 | 9815
%
unter 20 | 13.537953221459 | 14.62532766880593 | 15.08004985140447 | 14.95669893020886
20 - 65 | 59.36875054343101 | 57.43469221730091 | 53.33141597162304 | 49.80132450331126
65 und mehr | 27.09329623510999 | 27.93998011389316 | 31.58853417697249 | 35.24197656647988
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 22.80316344463972 | 25.46427447277306 | 28.27611001258314 | 30.03273322422259
Altenquotient | 45.63561804335091 | 48.64652187598363 | 59.23063095452095 | 70.76513911620295
Gesamtquotient | 68.43878148799062 | 74.1107963487567 | 87.50674096710408 | 100.7978723404255
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 840509d1692787266-pivot-table-use-slicer-to-filter-days-per-month-pivot-table-filter-by-month
Sheet: Sheet1

 |  | Project | Start date | End date | # Of Days
 |  | Pro-1 | 2022-01-19 00:00:00 | 2022-03-19 00:00:00
 |  | Pro-2 | 2023-05-21 00:00:00 | 2023-06-23 00:00:00
 |  | Pro-3 | 2022-02-02 00:00:00 | 2022-06-12 00:00:00
 |  |  | EXPECTED RESULTS |  |  |  | Days
 |  |  |  |  |  | Jan | 9
Row Labels | Sum of # Of Days |  | Row Labels | Sum of # Of Days |  | Feb | 39
Jan | 28 |  | Jan | 10 |  | Mar | 37
Feb | 94 |  | Feb | 38 |  | Apr | 21
May | 17 |  | Mar | 23 |  | May | 30
Grand Total | 139 |  | Apr | 20 |  | Jun | 25
 |  |  | May | 32
 |  |  | Jun | 16
 |  |  | Grand Total
Spreadsheet: 863622d1711034363-index-with-multiple-criteria-with-results-displayed-horizontally-index-with-multiple-criteria-test-sheet
Sheet: AVAILABILITY

Item | Batch | Quantity One | Quantity Two | Quantity Three
Product 1 | 32165
Product 2 | 36247
Product 3 | 32845
Product 4 | 37415
Product 5 | 39521
Spreadsheet: 53908d1253826112-excel-2007-how-to-create-a-drop-down-box-logbook-screen-shot
Sheet: Sheet1

TOTAL TIME |  | TOTAL PIC |  | TOTAL X/C |  | TOTAL X/C PIC |  | TOTAL INSTRUMENT |  | SINGLE ENGINE |  |  |  |  |  | MULTI ENGINE |  |  |  |  |  | CROSS COUNTRY |  |  |  |  |  | INSTRUMENT |  |  |  | TURB | JET | C152TT | C172TT | C310TT | C401TT | C402TT | C414TT | C550TT | PA31TT | BA31TT
 |  |  |  |  |  |  |  |  |  | DAY |  |  | NIGHT |  |  | DAY |  |  | NIGHT |  |  | DAY |  |  | NIGHT
MULTI TIME |  | TOTAL F/O |  | X/C DAY |  | MULTI PIC |  | TOTAL JET |  | PIC | F/O | DUAL | PIC | F/O | DUAL | PIC | F/O | DUAL | PIC | F/O | DUAL | PIC | F/O | DUAL | PIC | F/O | DUAL | SIM | HOOD | ACT | APR
SINGLE ENG TIME |  | TOTAL DUAL |  | X/C NIGHT |  | SINGLE ENG PIC |  | TOTAL TURBOPROP
Y.T.D TOTAL TIME
TOTAL HOURS |  | MULTI PIC
C152TT | C172TT | C310TT | C401TT | C402TT | C414TT | C550TT | PA31TT | BA31TT
DATE |  |  | A/C |  |  |  |  |  |  | SINGLE ENGINE |  |  |  |  |  | MULTI ENGINE |  |  |  |  |  | CROSS COUNTRY |  |  |  |  |  | INSTRUMENT |  |  |  | TURB | JET
 |  |  |  |  |  |  | REMARKS |  |  | DAY |  |  | NIGHT |  |  | DAY |  |  | NIGHT |  |  | DAY |  |  | NIGHT
YEAR | MONTH | DAY | TYPE | REG. | PIC | F/O |  |  |  | PIC | F/O | DUAL | PIC | F/O | DUAL | PIC | F/O | DUAL | PIC | F/O | DUAL | PIC | F/O | DUAL | PIC | F/O | DUAL | SIM | HOOD | ACT | APR
 |  |  | C152 |  |  |  |  |  |  | 7 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 44 | 4 | 4
 |  |  | C172 |  |  |  |  |  |  | 7 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  | C310 |  |  |  |  |  |  | 7 | 3 |  |  |  |  | 6
 |  |  | C401 |  |  |  |  |  |  | 7 | 3 |  |  |  |  | 6
 |  |  | C414 |  |  |  |  |  |  | 7 | 3 |  |  |  |  | 6
 |  |  | C550 |  |  |  |  |  |  | 7 | 3 |  |  |  |  | 6
 |  |  | PA31 |  |  |  |  |  |  | 7 | 33 |  |  |  |  | 6
 |  |  | BA31 |  |  |  |  |  |  | 7 | 33 |  |  |  |  | 6
 |  |  | C402 |  |  |  |  |  |  | 7 | 3 |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  | 7 | 33 |  |  |  |  | 6
Spreadsheet: 73424d1274094866-removing-specific-cells-by-functions-examplesetup
Sheet: Ark1

 | How it looks now |  |  |  | Preferred setup
 | Person | Title | Etc |  | Person | Title | Etc
 | Person 1 | Title 1 | Etc 1 |  | Person 1 | Title 1 | Etc 1
 |  |  |  |  | Person 2 | Title 2 | Etc 2
 |  |  |  |  | Person 3 | Title 3 | Etc 3
 |  |  |  |  | Person 4 | Title 4 | Etc 4
 | Person 2 | Title 2 | Etc 2
 | Person 3 | Title 3 | Etc 3
 | Person 4 | Title 4 | Etc 4
Spreadsheet: 677636d1589450026-populating-like-cells-on-common-rows-20200514-cell-populate-example
Sheet: Sheet1

 |  |  | April
 | Position | Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
 | Driver | [NAME] | ER | ER | ER | ER
 | Driver | [NAME] |  |  |  |  |  | ER | ER | ER | ER | ER | ER
 | Driver | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | ER | ER | ER | ER | ER | ER
 | Conductor | Fred | BR | BR | BR | BR
 | Conductor | Fred |  |  |  |  |  | BR | BR | BR | BR | BR | BR
 | Conductor | Fred |  |  |  |  |  |  |  |  |  |  |  |  | BR | BR | BR | BR | BR | BR
 | Conductor | Fred |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR | BR | BR | BR | BR | BR
 | Telephonist | Jimbo | ER | ER | ER | ER
 | Telephonist | Jimbo |  |  |  |  |  | ER | ER | ER | ER | ER | ER
 | Telephonist | Jimbo |  |  |  |  |  |  |  |  |  |  |  |  | ER | ER | ER | ER | ER | ER
 | Telephonist | Jimbo |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ER | ER | ER | ER | ER | ER
 | Telephonist | [NAME] | ER | ER | ER | ER
 | Telephonist | [NAME] |  |  |  |  |  | ER | ER | ER | ER | ER | ER
 | Telephonist | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | ER | ER | ER | ER | ER | ER
 | Telephonist | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PD | PD | PD | PD | PD | PD
 | [NAME] | [NAME] | BR | BR | BR | BR
 | [NAME] | [NAME] |  |  |  |  |  | BR | BR | BR | BR | BR | BR
 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | BR | BR | BR | BR | BR | BR
 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR | BR | BR | BR | BR | BR
 | Joiner | Elvis | BR | BR | BR | BR |  | BR | BR | BR | BR | BR | BR |  | BR | BR | BR | BR | BR | BR |  | BR | BR | BR | BR | BR | BR | BR |  | ER | ER | ER
 | Joiner | Elvis | BR | BR | BR | BR |  | BR | BR | BR | BR | BR | BR |  | BR | BR | BR | BR | BR | BR |  | BR | BR | BR | BR | BR | BR | BR |  | ER | ER | ER
 | Joiner | Elvis |  |  |  |  |  | BR | BR | BR | BR | BR | BR |  | BR | BR | BR | BR | BR | BR |  | BR | BR | BR | BR | BR | BR | BR |  | ER | ER | ER
 | Joiner | Elvis |  |  |  |  |  |  |  |  |  |  |  |  | BR | BR | BR | BR | BR | BR |  | BR | BR | BR | BR | BR | BR | BR |  | ER | ER | ER
 | Joiner | Elvis |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR | BR | BR | BR | BR | BR | BR |  | ER | ER | ER
 | DJ | [NAME] | PD | PD | PD | PD
 | DJ | [NAME] |  |  |  |  |  | PD | PD | PD | PD
 | DJ | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | ER | ER | ER
 | DJ | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PD | PD | PD | PD | PD | PD
Spreadsheet: 2a1eb375-0ee4-43a9-8e4a-28bbb93b2c5e
Sheet: 4.2(OA) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(OA): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 2011-12
 | Major Group | OA - Office Administration
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2011 (October 15, 2011)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | 2 | 21 | 0 | 0
 |  | Part Time | 5 | 16 | 0 | 0
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured gainful employment after graduation.
 |  |  |  |  | July 1, 2011- June 30, 2012
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
 | App. graduates admitted to a college program |  | na | na | na | na
Diploma |  |  | na | na | na | na
 | [NAME]. graduates admitted to a college program |  | na | na | na | na
Certificate |  |  | 1 | 3 | 0 | 0
 | Cert. graduates admitted to a college program |  | 0 | 0 | 0 | 0
Associate Degree |  |  | 0 | 1 | 0 | 0
 | Assoc. graduates admitted to four-year program |  | 0 | 0 | 0 | 0
Bachelor's Degree |  |  | na | 0 | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
Master's Degree |  |  | na | na | na | na
Gainfully Employed after graduation |  |  | m | m | m | m
Graduates who completed remedial courses during their time at the TCU |  |  | m | m | m | m
Graduates who received A*CF support at some point during their coursework |  |  | m | m | m | m
Notes:
NA denotes we do not offer the program.  We do not track graduates.
Spreadsheet: 465351d1465578611-autosort-lists-sdld-review-tool
Sheet: General Plan Details

 | SLDO Review Form
 |  |  |  | Plan Information |  |  |  |  |  | Additional Documentation Needed
 | Date of Application: |  |  | Plan Type: | Single Lot Subd |  |  |  |  | Document | Required? | Notified | Received
 |  |  |  |  |  |  |  |  |  | Sewage Module | Y
 | Parcel #: |  |  |  |  |  |  |  |  | Sewage Module Approval Letter | N
 | Parcel #: |  |  |  |  |  |  |  |  | Sewer Will Serve | Y
 | Parcel #: |  |  |  |  |  |  |  |  | Water Will Serve | N
 | Parcel #: |  |  |  |  |  |  |  |  | Right-of-Way Agreement | Y
 |  |  |  |  |  |  |  |  |  | Highway Occupancy Permit | N
 |  | Landowner Name |  |  |  |  |  |  |  | Nutrient Management Plan | N
 | Land Owner Name: |  |  |  |  |  |  |  |  | Manure Management Plan | N
 | Address: |  |  |  |  |  |  |  |  | Stream Crossing Permit | Y
 | [NAME]:
 | Secondary Phone:
 | [NAME]/Fax:
 |  | Agent Name |  | Municipal Coordination
 | Land Owner Name: |  |  |  |  | Sent | Received
 | Address: |  |  | Municipality: | Picture Rocks
 | [NAME]: |  |  | Municipality 2:
 | Secondary Phone: |  |  | Municipality 3:
 | [NAME]/Fax: |  |  | Municipality 4:
 |  | Surveyor/Engineer Information
 | Land Owner Name:
 | Address:
 | Phone:
 | [NAME]/Fax:
Spreadsheet: 793246d1661362432-automating-cell-reference-change-automating-formula-change
Sheet: Sheet1

 | 1 | 2 | 4 | 10 | 16 | 22
 | 2 | 3 | 5 | 11 | 17 | 23
 | 3 | 4 | 6 | 12 | 18 | 24
 | 4 | 5 | 7 | 13 | 19 | 25
 | 5 | 6 | 8 | 14 | 20 | 26
 | 6 | 7 | 9 | 15 | 21 | 27
Spreadsheet: darrell_schoolcraft__7445__imball0202
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1 | -28994 | -28956
2 | -58020 | -57711
3 | -57789 | -57711
4 | -57711 | -57711
5 | -29948 | -29013
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | -3066
2002-02-05 00:00:00
CBS Dollars
 |  |  | 186633
Spreadsheet: 4cd43b47-a68d-4a94-8136-30db1398da5e
Sheet: Sheet1

Table 2--Soybean meal:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 | 1,000 short tons
2010/11 | 301.554 | 39251 | 178.811 | 39731.365 |  | 30277.677 | 9103.688 | 39381.365 | 350
2011/121 | 350 | 41025 | 215.916 | 41590.916 |  | 31550.062 | 9740.854 | 41290.916 | 300
2012/132 | 300 | 38450 | 250 | 39000 |  | 29900 | 8800 | 38700 | 300
1 Estimated.  2 Forecast.
Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates.
Last update: | 2013-02-12 10:46:00.500000
Spreadsheet: 143441d1330424760-automatic-entry-into-summary-table-when-matching-various-criteria-blank-sui-form-test-1
Sheet: Lists

Month |  | Type of Notification |  | Completed By |  | Accident / Incident Happened To:
January |  | Death |  | [NAME] |  | Staff
February |  | Infectious disease |  | [NAME] |  | S U
March |  | Injury |  | [NAME] |  | Other
April |  | Illness |  | [NAME]
May |  | Event that adversely affects the person’s safety & welfare |  | [NAME]
June |  | Theft, burglary or accident |  | [NAME]
July |  | The termination of accommodation without notice |  | [NAME]
August |  | Physical Intervention |  | [NAME]
September |  | Temporary Change in Provider's Approval |  | Eva Parmiter
October |  | Safeguarding |  | [NAME]
November |  | Aggression / Violence |  | [NAME] Poulter
December |  | Medication Error |  | [NAME]
 |  | Seizures |  | Hussain Choudhury
 |  | Self Injuries Behaviour
 |  | Manual Handling
 |  | Slips / Trips / Falls
 |  | Injury Found cause unknown
 |  | Unwitnessed Event
 |  | Security
 |  | Equipment
 |  | Other *
 |  | Hints
 |  | Allegations
Aggression / Violence
Medication Error
Seizures
Self Injuries Behaviour
Manual Handling
Slips / Trips / Falls
Injury Found cause unknown
Unwitnessed Event
Spreadsheet: 780608d1652610336-infill-blank-rows-in-a-list-title-sample
Sheet: Sheet1

What I have | What I need
Title 1 | Title 1
 | Title 1
 | Title 1
 | Title 1
Title 2 | Title 2
 | Title 2
 | Title 2
 | Title 2
 | Title 2
Title 3 | Title 3
Title 4 | Title 4
 | Title 4
 | Title 4
 | Title 4
 | Title 4
Title 5 | Title 5
Spreadsheet: 745054d1629719947-need-formula-to-calculate-the-numbers-of-hours-and-get-the-value-true-or-false-sample-sheet
Sheet: Sheet1

Approved At | Ordered | Need value
2021-08-03 06:53:35 | 2021-08-03 13:12:16 | True
2021-07-30 15:46:26 | 2021-08-02 12:49:13 | False
2021-08-04 14:19:07 | 2021-08-05 11:28:40 | False
2021-07-30 14:50:05 | 2021-08-02 12:51:03 | False
2021-07-30 09:00:34 | 2021-08-02 12:42:29 | False
2021-07-30 15:49:15 | 2021-08-02 12:31:46 | False
2021-07-29 16:44:12 | 2021-07-30 10:36:42 | False
2021-07-29 16:20:30 | 2021-08-02 12:27:57 | False
2021-07-13 20:26:38 | 2021-07-14 14:35:56 | True
Spreadsheet: 71775d1272493215-how-to-move-sort-data-from-one-sheet-to-the-next-where-data-goes-2
Sheet: goes

PublisherId | ParentId | Tier | CSR | [NAME] | [NAME] | Phone | FirstName | LastName | CompanyName | ISORep | SRMRep | Note | Tags
 |  |  |  | column L | column AG | column AH |  |  | column AE |  |  | column AC | columns AV - BA; if the cell says NULL please ignore; if it says "On" then paste the header. For example, if columns AV and AW are "On" and the rest say "Null" then the cell should say "Opportunity_AFC, Opportunity_AFS"
 |  |  |  |  |  |  |  |  |  |  |  |  | on
Spreadsheet: 91293d1291060617-excel-formula-running-like-tortoies-test1a
Sheet: Sheet1

CODE | [NAME] | DIST | OIL (figure in quantity) | OIL FILTER (figure in quantity) | FUEL FILTER (figure in quantity) | [NAME] (figure in quantity) | AIR FILTER (in quantity) | OIL (last change date) | OIL FILTER (last change date) | FUEL FILTER (last change date) | [NAME] (last change date) | AIR FILTER (last change date) | NOS. OF DAY FROM LAST CHANGED K-OIL | NOS. OF DAY FROM LAST CHANGEDAIRFILTER | ESN | COUNT
 | AS ON oct-2010 |  | OI | OF | FF | OFF | AF | OI | OF | FF | OFF | AF | 2010-11-29 00:00:00 | 2010-11-29 00:00:00
A0031 | AARTI | NGP | 11 | 17 | 11 | 0 | 1 | 2010-10-21 00:00:00 | 2010-10-21 00:00:00 | 2010-10-21 00:00:00 |  | 2010-02-18 00:00:00 | 39 | 284 | 6H.3501/0701563 | 1
A0094 | AGAPE | NGP | 1 | 1 | 1 | 0 | 0 | 2010-10-05 00:00:00 | 2010-10-05 00:00:00 | 2010-10-05 00:00:00 |  |  | 55 |  | 06.2415/0700137 | 1
A0192 | AMAR | NGP | 6 | 6 | 4 | 1 | 3 | 2010-10-14 00:00:00 | 2010-10-14 00:00:00 | 2010-10-14 00:00:00 | 2010-09-08 00:00:00 | 2010-09-08 00:00:00 | 46 | 82 | 6H.3516/0801241 | 1
A0201 | AMBIKA | BHN | 2 | 1 | 1 | 0 | 0 | 2009-11-24 00:00:00 | 2009-11-24 00:00:00 | 2009-11-24 00:00:00 |  |  | 370 |  | 6H.3506/0801242 | 1
Spreadsheet: 679665d1590575015-index-and-match-functions-sample-data-airlines
Sheet: Sheet1

FL_DATE | CARRIER | ORIGIN_CITY_CDE | ORIGIN_CITY_NAME | SCHED_DEP_TIME | ACTUAL_DEP_TIME | DEST_CITY_NAME | DEST_CITY_CDE | [NAME] | MOD_SCHED_DEP | MOD_ACTUAL_DEP
2014-01-01 00:00:00 | EV | PVD | Providence, RI | 909 | 914 | Newark, NJ | EWR | 160
2014-01-01 00:00:00 | EV | ILM | [NAME], NC | 1645 | 1650 | Atlanta, GA | ATL | 377
2014-01-01 00:00:00 | FL | MSY | New Orleans, LA | 1451 | 1717 | Kansas City, MO | MCI | 689
2014-01-01 00:00:00 | MQ | MLI | [NAME], IL | 547 | 550 | Dallas/Fort Worth, TX | DFW | 691
2014-01-01 00:00:00 | MQ | BNA | Nashville, TN | 1425 | 1449 | Chicago, IL | ORD | 409
2014-01-01 00:00:00 | AA | DCA | Washington, DC | 714 | 715 | Miami, FL | MIA | 919
2014-01-01 00:00:00 | AA | SJU | San Juan, PR | 1408 | 1410 | New York, NY | [NAME] | 1598
2014-01-01 00:00:00 | B6 | ORD | Chicago, IL | 2025 | 2310 | New York, NY | [NAME] | 740
2014-01-01 00:00:00 | B6 | LGA | New York, NY | 1451 | 1524 | Fort Lauderdale, FL | FLL | 1076
2014-01-01 00:00:00 | B6 | EWR | Newark, NJ | 947 | 953 | Fort Lauderdale, FL | FLL | 1065
2014-01-01 00:00:00 | DL | BWI | Baltimore, MD | 733 | 735 | Salt Lake City, UT | SLC | 1865
2014-01-01 00:00:00 | DL | MKE | Milwaukee, WI | 920 | 920 | Detroit, MI | DTW | 237
Spreadsheet: 648360d1573001900-v-look-up-with-multiple-ifs-and-search-test
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data to look up against |  |  |  |  | Vlook-up on clumn"S"
a | b | c | d | a | b | c | d | a | b | c | d | a | b | c | d | a | b | style number | definition |  |  | style number finfing | -if finding is 1-replace with "A" '-if finding is 2- replace with "R" '-if finding is blank -look for date in column "Y" and if is 1/0/1900 -  show as a "NS" in column "X" | Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125 | 1 |  |  | 125 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 137 |  |  |  | 137 |  | 1/0/1900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 458 | 2 |  |  | 458 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 659 |  |  |  | 659
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 888 |  |  |  | 888 |  | 1/0/1900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | 1 |  |  | 555 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 596.666666666667 |  |  |  | 596.666666666667
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 544.666666666667 | 1 |  |  | 544.666666666667 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 492.666666666667 |  |  |  | 492.666666666667
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 440.666666666667 | 2 |  |  | 440.666666666667 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 388.666666666667 |  |  |  | 388.666666666667 |  | 1/0/1900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 336.666666666667 | 2 |  |  | 336.666666666667 | 2
Spreadsheet: 803757d1667666266-need-an-alternative-to-vlookup-that-returns-all-values-found-spa-lista-de-estabelecimentos-dsavrlvt-29_07_2022
Sheet: Secção II

[NAME]. 1069/2009 Secção II – Unidades de Armazenamento de Produtos Derivados
NCV (Approval Number) | Nome (Name) | Concelho (Municipality) | Categoria (Category) | Atividade (Activity) | Espécies / Produtos (Species / Products) | [NAME] (Associated Activities)
 | Fabrióleo, Fábrica de Óleos Vegetais,S.A. | Torres Novas | 3 | Armazenamento de Produtos Derivados(STORP*) | FATF
 | Oleotorres, Lda. | Torres Novas | 1 / 2 / 3 | Armazenamento de Produtos Derivados(STORP*) | FATOL, FATF, PAP, MBM, GAF | I(STORP), IAA(AAITR, AAVPAAR), IMPAA(AAIPR), [NAME], OTHER)
 | EUROCEREAL - Comercialização de Produtos Agro-Alimentares, S.A. | Mafra | 3 | Armazenamento de Produtos Derivados(STORP*) | PAP | FAC(AAINA), FPM(AAPMA), FDAM(AAINFAM, AADGAM), IAA(AAITA, AAVPAAR), IMPAA(AAIPR), SPONA(AAINPAT, AAPMPAT, AAITPAT)
 | Brandsweet - Aditivos Alimentares, Lda. | Barreiro | 3 | Armazenamento de Produtos Derivados(STORP*) | PAP | IAA(AAITA, AAVPAAR), IMPAA(AAIPR), SPONA(AAITPAT)
 | REAGRO - Importação e Exportação, S.A. | Salvaterra de Magos | 3 | Armazenamento de Produtos Derivados(STORP*) | PAP | FAC(AAINA), FPM(AAPMA), FDAM(AADGAM), IAA(AAITA, AAVPAAR), IMPAA(AAIPR), SPONA(AAITPAT), [NAME]-com), [NAME])
 | DINAZOO – Comércio de Produtos Pecuários e Agricultura, Lda. | Rio Maior | 3 | Armazenamento de Produtos Derivados(STORP*) | PAP | IAA(AAITA, AAVPAAR), SPONA(AAITPAT), [NAME])
 | MAPRICO – [NAME]. | Óbidos | 3 | Armazenamento de Produtos Derivados(STORP*) | PAP | IAA(AAITA, AAVPAAR), IMPAA(AAIPR), SPONA(AAITPAT)
 | O Cereal – Comércio e Indústria de Cereais, S.A. | Rio Maior | 3 | Armazenamento de Produtos Derivados(STORP*) | PAP | IAA(AAITR, AAVPAAR), IMPAA(AAIPR), SPONA(AAITPAT), [NAME])
 | Gomes & Severino Lda. | Loures | 3 | Armazenamento de Produtos Derivados(STORP*) | FATF | I(STORP), [NAME])
 | SEBOL - Comércio e Indústria de Sebo, S.A. | Loures | 3 | Armazenamento de Produtos Derivados(STORP*) | FATF, PAP | I(STORP), IV(PROCP), [NAME]), [NAME])
 | Joivo-Transformados Cárneos, Lda | [NAME] | 3 | Armazenamento de Produtos Derivados(STORP*) | FATOL, FATF
 | Biocompost-Composto Orgânico, Lda | Ferreira do Zêzere | 2 | Armazenamento de Produtos Derivados(STORP*) | COMR | XIII(TRANS)
 | ITS - Industria [NAME], S.A. | Coruche | 1 | Armazenamento de Produtos Derivados(STORP*) | FATOT, MBM | I(STORP), IV(PROCP), III(COMB)
 | LUÍS LEAL & FILHOS, S.A. | Torres Novas | 1 / 3 | Armazenamento de Produtos Derivados(STORP*) | FATOT | I(STORP)
 | ITS - Industria [NAME], S.A. | Coruche | 1 | Armazenamento de Produtos Derivados(STORP*) | MBM