tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 838719d1691305078-trying-to-find-the-sums-of-2tables-invoices-2023-
Sheet: ΣΤΑΤΙΣΤΙΚΑ 

ΣΚΦ |  |  |  | ΦΑΙΔΡΑ |  |  |  | ΣΚΦ |  |  |  | ΦΑΙΔΡΑ
ΑΓΟΡΕΣ |  |  |  | ΑΓΟΡΕΣ |  |  |  | ΕΞΟΔΑ |  |  |  | ΕΞΟΔΑ
[NAME] | ΓΕΝΙΚΟ ΣΥΝΟΛΟ ΑΓΟΡΩΝ | ΑΡΙΘΜΟΣ ΤΙΜΟΛΟΓΙΩΝ |  | [NAME] | ΓΕΝΙΚΟ ΣΥΝΟΛΟ ΑΓΟΡΩΝ | ΑΡΙΘΜΟΣ ΤΙΜΟΛΟΓΙΩΝ |  | [NAME] | ΓΕΝΙΚΟ ΣΥΝΟΛΟ ΑΓΟΡΩΝ | ΑΡΙΘΜΟΣ ΤΙΜΟΛΟΓΙΩΝ |  | [NAME] | ΓΕΝΙΚΟ ΣΥΝΟΛΟ ΑΓΟΡΩΝ | ΑΡΙΘΜΟΣ ΤΙΜΟΛΟΓΙΩΝ
AQUASERA IKE | 1533.38 | 4 |  | ΓΙΑΝΝΑΚΑΚΗΣ | 1213.37 | 3 |  | AMAZON TECHNOLOGY | 52.64 | 1 |  | ΜΑΚΡΗΣ | 371.1 | 8
ECO | 4166.440000000001 | 15 |  | [NAME] | 15520.95 | 25 |  | EASY MARKET | 71.84 | 5 |  | ΠΑΠΑΘΑΝΑΣΗΣ | 156.11 | 2
PHARMAID | 11930.01 | 16 |  | ΚΕΣΙΔΗΣ | 52907.17000000002 | 67 |  | GADGET4YOU | 28.85 | 1 |  | [NAME] | 527.21 | 10
ΒΑΛΑΗΣ | 691.3000000000001 | 3 |  | ΝΑΟΥΜ | 2062.72 | 3 |  | OGGI | 185.87 | 13
ΓΑΝΩΤΑΚΗΣ | 281.23 | 1 |  | ΡΙΖΕΣ | 4804.21 | 6 |  | PRO COMPIOUTER  SERVISES | 43.4 | 1
ΓΙΑΝΝΑΚΑΚΗΣ | 2902.49 | 6 |  | ΣΤΡΕΜΜΕΝΟΣ | 498.48 | 2 |  | STUDIO LIFE | 59 | 1
[NAME] | 36172.49000000001 | 29 |  | ΦΑΙΣΤΑ | 8446.079999999998 | 23 |  | TECHFACE | 7.4 | 1
ΚΑΛΛΑΣ ΣΤΑΥΡΟΣ | 573.6400000000001 | 3 |  | ΧΟΥΛΗΣ | 8730.839999999998 | 14 |  | ΗΛΕΚΤΡΟΦΑΣΗ | 201.5 | 1
ΚΕΣΙΔΗΣ | 18752.49 | 21 |  | [NAME] | 94183.82 | 143 |  | ΚΑΤΣΑΜΟΥΝΗΣ | 400 | 1
ΜΟΥΤΣΙΟΣ | 29610.02 | 5 |  |  |  |  |  | ΚΟΥΓΙΟΣ | 48.57000000000001 | 3
ΝΑΟΥΜ | 3550.74 | 5 |  |  |  |  |  | ΚΩΤΣΟΒΟΛΟΣ | 138 | 1
ΠΟΤΑΜΙΤΗΣ | 654.72 | 2 |  |  |  |  |  | ΜΑΚΡΗΣ | 867.1999999999999 | 21
ΡΙΖΕΣ | 4329.25 | 5 |  |  |  |  |  | ΝΤΕΛΗΓΙΩΡΓΗΣ ΒΑΣΙΛΗΣ | 1300 | 1
ΣΤΡΕΜΜΕΝΟΣ | 1261.08 | 4 |  |  |  |  |  | ΠΑΠΑΘΑΝΑΣΗΣ | 1092.14 | 17
ΤΣΑΓΚΟΓΕΩΡΓΑΣ | 208.51 | 1 |  |  |  |  |  | ΣΠΑΝΟΣ | 16.1 | 1
ΦΑΙΣΤΑ | 21172.86 | 24 |  |  |  |  |  | [NAME] | 4512.510000000004 | 69
ΦΤΑΚΛΑΣ | 333.9 | 1
ΧΟΥΛΗΣ | 7537.03 | 7
[NAME] | 145661.5799999999 | 152
Spreadsheet: 876520d1723222832-determine-if-digits-of-numbers-in-a-column-are-permutations-of-the-number-at-the-bottom-3-test
Sheet: Sheet1

 | 2024-08-08 00:00:00 | 533 | 259 | 290 |  | 9912 | 2077 | 5402 |  | 06281 | 07 12 15 30 40
 | 2024-08-08 00:00:00 | 990 | 806 | 506 |  | 9219 | 7702 | 1218 |  | 06218 | 3 6 12 22 30
 | 2024-08-08 00:00:00 | 323 | 274 | 902 |  | 1929 | 7207 | 1281 |  | 06812 | 2 6 11 12 22
 | 2024-08-08 00:00:00 | 909 | 608 | 209 |  | 9921 | 2707 | 2181 |  | 06218 | 4 10 19 26 25
 | 2024-08-08 00:00:00 | 593 | 671 | 029 |  | 5891 | 2770 | 2818 |  | 06281 | 8 9 10 11 15
 | 2024-08-08 00:00:00 | 239 | 178 | 902 |  | 9129 | 7702 | 1821 |  | 62810 | 8 16 18 19 23
 | 2024-08-08 00:00:00 | 695 | 068 | 207 |  | 1067 | 7720 | 1812 |  | 62180 | 3 12 16 23 24
 | 2024-08-08 00:00:00 | 099 | 116 | 532 |  | 1299 | 9214 | 8121 |  | 81062 | 8 10 15 17 27
 | 2024-08-08 00:00:00 | 227 | 086 | 426 |  | 8689 | 8057 | 8211 |  | 61820 | 15 23 30 35 38
 | 2024-08-08 00:00:00 | 062 | 082 | 746 |  | 2191 | 1266 | 6382 |  | 82601 | 1 8 17 24 29
 |  | 099 | 608 | 290 |  | 9219 | 2077 | 1218 |  | 06281 | 8 10 11 15 25
 | I am looking for a formula that will tell me if the digits in C13 are included in (the column above it), in any order.
 | So [NAME] would show, me if any of the cells C4, C6, or the C10 value on cell C13.
 | I would also want to do this for the 4 digit and 5 digit columns on the right.
 | Columns C-K, are numbers 1-9.  [NAME], are numbers 1-42.
Spreadsheet: 212696c2-ebff-4bdf-8f0a-137baffb0d8c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Summary of State & Local Taxes
 |  | Table 2 - Latest National Totals of State Tax Revenue: U.S. Total
 |  | Not Seasonally Adjusted Total Taxes, 4 Quarters Ending [Millions of Dollars]
 |  | Period: 2003 to 2014
 |  | Data Extracted on: September 16, 2014 (7:31 pm)
Period | Value
Q1-2003 | 541112
Q2-2003 | 544298
Q3-2003 | 552486
Q4-2003 | 561604
Q1-2004 | 572252
Q2-2004 | 589411
Q3-2004 | 598357
Q4-2004 | 611582
Q1-2005 | 626586
Q2-2005 | 653494
Q3-2005 | 668507
Q4-2005 | 680631
Q1-2006 | 691815
Q2-2006 | 711663
Q3-2006 | 721228
Q4-2006 | 728211
Q1-2007 | 736909
Q2-2007 | 748823
Q3-2007 | 754054
Q4-2007 | 760250
Q1-2008 | 764823
Q2-2008 | 777248
Q3-2008 | 782099
Q4-2008 | 774894
Q1-2009 | 752721
Q2-2009 | 713353
Q3-2009 | 693476
Q4-2009 | 688115
Q1-2010 | 693391
Q2-2010 | 697558
Q3-2010 | 706153
Q4-2010 | 719606
Q1-2011 | 736309
Q2-2011 | 759329
Q3-2011 | 767859
Q4-2011 | 773307
Q1-2012 | 780089
Q2-2012 | 788085
Q3-2012 | 794617
Q4-2012 | 804634
Q1-2013 | 823958
Q2-2013 | 848035
Q3-2013 | 858196
Q4-2013 | 865097
Q1-2014 | 864554
Q2-2014
Q3-2014
Q4-2014
Spreadsheet: 67928d1268422724-method-for-posting-and-tracking-staffing-changes-kinikisu-staff
Sheet: Sheet1

Staff Member | Supervisor | Date
[NAME] | [NAME] | 2010-01-01 00:00:00
[NAME] | [NAME] | 2010-01-01 00:00:00
Justin | Gavin | 2010-01-01 00:00:00
[NAME] | [NAME] | 2010-01-01 00:00:00
Justin | Gavin | 2010-01-01 00:00:00
Brooklyn | Gavin | 2010-01-01 00:00:00
[NAME] | [NAME] | 2010-01-01 00:00:00
Addison | [NAME] | 2010-01-01 00:00:00
Sofia | [NAME] | 2010-01-01 00:00:00
Makayla | [NAME] | 2010-01-01 00:00:00
[NAME] | [NAME] | 2010-01-01 00:00:00
Gabriella | [NAME] | 2010-01-01 00:00:00
[NAME] | [NAME] | 2010-01-01 00:00:00
[NAME] | [NAME] | 2010-01-01 00:00:00
Alexa | [NAME] | 2010-01-01 00:00:00
[NAME] | [NAME] | 2010-01-01 00:00:00
Makayla | [NAME] | 2010-01-01 00:00:00
Nevaeh | [NAME] | 2010-01-01 00:00:00
[NAME] | [NAME] | 2010-01-01 00:00:00
[NAME] | [NAME] | 2010-01-01 00:00:00
Kayla | [NAME] | 2010-01-01 00:00:00
Ella | Gavin | 2010-01-01 00:00:00
Victoria | [NAME] | 2010-01-01 00:00:00
[NAME] | [NAME] | 2010-01-01 00:00:00
Mason | Gavin | 2010-01-01 00:00:00
[NAME] | [NAME] | 2010-01-01 00:00:00
[NAME] | [NAME] | 2010-01-01 00:00:00
Mason | Gavin | 2010-01-01 00:00:00
[NAME] | [NAME] | 2010-01-01 00:00:00
Olivia | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Victoria | [NAME]
[NAME] | [NAME]
Kayla | [NAME]
Alexa | Gavin
Jayden | [NAME]
Destiny | Gavin
Chloe | [NAME]
Mason | Gavin
[NAME] | [NAME]
[NAME] | [NAME]
Chloe | [NAME]
[NAME] | [NAME]
Jordan | [NAME]
Anna | Gavin
Alyssa | [NAME]
[NAME] | [NAME]
Logan | [NAME]
Avery | [NAME]
Sofia | [NAME]
Chloe | Gavin
[NAME] | [NAME]
Jayden | Gavin
[NAME] | [NAME]
Gabriella | [NAME]
[NAME] | Gavin
[NAME] | [NAME]
[NAME] | [NAME]
Justin | [NAME]
Aiden | [NAME]
Jordan | [NAME]
[NAME] | [NAME]
Morgan | Gavin
[NAME] | [NAME]
Sydney | Gavin
[NAME] | Gavin
Samantha | Gavin
Emma | [NAME]
[NAME] | [NAME]
Brooklyn | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Victoria | [NAME]
Tyler | [NAME]
[NAME] | [NAME]
Samantha | [NAME]
Christian | [NAME]
Sofia | [NAME]
Nathan | [NAME]
Kaylee | [NAME]
[NAME] | [NAME]
[NAME] | Gavin
Julia | [NAME]
Emma | [NAME]
Lillian | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Addison | [NAME]
Spreadsheet: 06e742fa-c933-4acb-8b82-34a80fe2b0cd
Sheet: Grade 6 Reading

2013 Minnesota Comprehensive Assessments-Series III (MCA-III)
Grade 6 Reading
Scale Score | Level | Percentile Rank
606 | D | 1
607 | D | 1
608 | D | 1
609 | D | 1
610 | D | 1
611 | D | 2
612 | D | 2
613 | D | 2
614 | D | 2
615 | D | 2
616 | D | 2
617 | D | 3
618 | D | 3
619 | D | 3
620 | D | 4
621 | D | 4
622 | D | 4
623 | D | 5
624 | D | 5
625 | D | 6
626 | D | 6
627 | D | 7
628 | D | 8
629 | D | 9
630 | D | 9
631 | D | 10
632 | D | 11
633 | D | 12
634 | D | 13
635 | D | 14
636 | D | 16
637 | D | 17
638 | D | 19
639 | D | 20
640 | P | 22
641 | P | 23
642 | P | 25
643 | P | 27
644 | P | 29
645 | P | 31
646 | P | 33
647 | P | 35
648 | P | 37
649 | P | 39
650 | M | 42
651 | M | 44
652 | M | 47
653 | M | 49
654 | M | 51
655 | M | 54
656 | M | 56
657 | M | 59
658 | M | 61
659 | M | 63
660 | M | 66
661 | M | 68
662 | M | 70
663 | M | 72
664 | M | 74
665 | M | 76
666 | M | 78
667 | E | 80
668 | E | 81
669 | E | 83
670 | E | 84
671 | E | 86
672 | E | 87
673 | E | 88
674 | E | 89
675 | E | 90
676 | E | 91
677 | E | 92
678 | E | 93
679 | E | 94
680 | E | 94
681 | E | 95
682 | E | 95
683 | E | 96
684 | E | 96
685 | E | 97
686 | E | 97
687 | E | 97
688 | E | 98
689 | E | 98
690 | E | 98
691 | E | 98
692 | E | 98
693 | E | 98
694 | E | 99
695 | E | 99
696 | E | 99
697 | E | 99
698 | E | 99
699 | E | 99
End of Worksheet
Spreadsheet: 878382d1725456458-determining-sample-size-based-on-sales-sourcingsolutionsample
Sheet: Sheet1 (3)

 | Store | Products Sold | Number of Reviews Per Store | Minimum Sample with Rounding |  | ROUNDDOWN but min. 1 | # > Total in column G | Adjustment Required
 | Store 1 | 11
 | Store 2 | 16
 | Store 3 | 6
 | Store 4 | 9
 | Store 5 | 15
 | Store 6 | 9
 | Store 7 | 21
 | Store 8 | 24
 | Store 9 | 10
 | Store 10 | 9
 | Store 11 | 14
 | Store 12 | 21
 | Store 13 | 8
 | Store 14 | 20
 | Store 15 | 9
 | Store 16 | 19
 | Store 17 | 7
 | Store 18 | 21
 | Store 19 | 34
 | Store 20 | 6
 | Total
 |  |  |  | Sample size | :
 |  |  |  | Left to assign | :
 | Total Stores |  |  |  | :
 | Total that require the minimum review number of 1 |  |  | No. of stores with values [NAME] above value | :
 |  |  |  | Difference | :
 | Stores left to allocate
 | Total Reviews Required: | 30
 | Total Assigned One Review:
 | Total Left to Assign:
Spreadsheet: 504933d1488470926-rag-if-percentage-is-within-tolerance-tollerance-upload
Sheet: Sheet1

 |  | Action Status | % Target | Tollerance | [NAME] |  | Justification
 |  | 0.5 | 0.4285714285714285 | 0.1 | Green |  | As it is above the target
 |  | 0.1 | 0 | 0.1 | Yellow |  | Although its below the target its within tollerance
 |  | 0.2 | 1 | 0.2 | Red |  | Below the targt and tollerance
 |  | 0.6 | 0.6000000000000001 | 0.05 | Yellow |  | As its within the tollerance
Spreadsheet: 815180d1674790459-sumifs-with-multiple-criteria-copy-of-sumifs-with-multiple-criteria
Sheet: desired result

report
 | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 5 | 5 | 5 | 6 | 6 | 6
 | JAN |  |  | FEB |  |  | MAR |  |  | APR |  |  | MAY |  |  | JUN
ACCOUNT NAME | PLT | CTN | TOTAL WT. | PLT | CTN | TOTAL WT. | PLT | CTN | TOTAL WT. | PLT | CTN | TOTAL WT. | PLT | CTN | TOTAL WT. | PLT | CTN | TOTAL WT.
ALLAN
[NAME]
[NAME]
[NAME]
TAKESHI
Only "shipped" figure on the remarks will appear on the report
Spreadsheet: 355528d6-5d19-4f29-b66b-f9c340275f68
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
 | Time Series Workbook
 | 5609.0 Housing Finance, Australia
 | TABLE 15. HOUSING FINANCE SEASONAL FACTORS, BY STATE
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
New South Wales ;  Number of Commitments ; |  |  | Original | A2433086W | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | Number | FACTOR | Month | 1
New South Wales ;  Value of Commitments ; |  |  | Original | A2433087X | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | Number | FACTOR | Month | 1
Victoria ;  Number of Commitments ; |  |  | Original | A2433088A | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | Number | FACTOR | Month | 1
Victoria ;  Value of Commitments ; |  |  | Original | A2433089C | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | Number | FACTOR | Month | 1
Queensland ;  Number of Commitments ; |  |  | Original | A2433090L | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | Number | FACTOR | Month | 1
Queensland ;  Value of Commitments ; |  |  | Original | A2433091R | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | Number | FACTOR | Month | 1
South Australia ;  Number of Commitments ; |  |  | Original | A2433092T | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | Number | FACTOR | Month | 1
South Australia ;  Value of Commitments ; |  |  | Original | A2433093V | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | Number | FACTOR | Month | 1
Western Australia ;  Number of Commitments ; |  |  | Original | A2433094W | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | Number | FACTOR | Month | 1
Western Australia ;  Value of Commitments ; |  |  | Original | A2433095X | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | Number | FACTOR | Month | 1
Tasmania ;  Number of Commitments ; |  |  | Original | A2433096A | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | Number | FACTOR | Month | 1
Tasmania ;  Value of Commitments ; |  |  | Original | A2433097C | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | Number | FACTOR | Month | 1
Northern Territory ;  Number of Commitments ; |  |  | Original | A2433098F | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | Number | FACTOR | Month | 1
Northern Territory ;  Value of Commitments ; |  |  | Original | A2433099J | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | Number | FACTOR | Month | 1
Australian Capital Territory ;  Number of Commitments ; |  |  | Original | A2433100F | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | Number | FACTOR | Month | 1
Australian Capital Territory ;  Value of Commitments ; |  |  | Original | A2433101J | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | Number | FACTOR | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 82d306e1-dbc0-4050-97a9-35576392005b
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
PBORR | Test | PBORR | Lyme Disease (Borrelia burgdorferi), Molecular Detection, PCR | Lyme Disease PCR | Real-Time Polymerase Chain Reaction (PCR)/DNA [NAME] (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | [NAME], leak proof vial: ScwLkPf |  |  | 1 | mL | Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen.  [NAME] source is required.   Submit only 1 of the following specimens:   Specimen Type: Spinal fluid Container/Tube: Sterile vial [NAME]: 1 mL Collection Instructions: Label specimen as spinal fluid.   Specimen Type: Synovial fluid Container/Tube: Sterile vial [NAME]: 1 mL Collection Instructions: Label specimen as synovial fluid.   Specimen Type: Tissue (fresh only)  Sources: Skin or synovial biopsy Container/Tube: Sterile container with normal saline  [NAME]: Approximately 4 mm(3)  Collection Instructions:  1. Submit only fresh tissue. 2. Skin biopsies: [NAME] biopsy site with an antiseptic soap. Thoroughly rinse area with sterile water. Do not use alcohol or iodine preparations. A local anesthetic may be used.  [NAME] specimens are best taken by [NAME] to include full thickness of dermis. 3. Label specimen with source of tissue. | Spinal Fluid or Synovial Fluid: | Hemolysis	NA Thawing	Warm OK - note to lab; Cold OK Lipemia	NA Icterus	NA Other	Green-top (heparin) tube, yellow-top (ACD) tube, blood, or plasma | Negative | Monday through Saturday; (June through November) Monday through Friday; (December through May) | 1 day | 4 days | 1 | 87476 |  |  |  |  | Rochester
PBORR | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
PBORR | Order Question | SRC71 | [NAME] |  | Plain Text
PBORR | Result | SRC71 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
PBORR | Result | 23635 | Lyme Disease PCR | Lyme Disease PCR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4991-6
Spreadsheet: 711351d1609628390-transpose-x-matching-headers-x-duplicate-tables-multiple-problems-excel-problem
Sheet: Solution

A | B | C | D | E | F | G | H | Attributes | Values
Spreadsheet: 230387d1366747564-return-multiple-values-from-multiple-sheets-example
Sheet: OVERVIEW

EQUIPMENT | DATE | TEMP | BEGIN PSIG | MCF LOSS
Spreadsheet: 7b4af35c-9108-4eba-aa71-9c049ff44fb2
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
34023306 | 2013-01-17 17:11:00 | ALLIES | 1 | 5 | 2 | 1021105 | The Chairman1 | 12500 | pacific | 1943-01-13 | 1943-01-13 | Clearing Matanikau River | Nettoyage du secteur Matanikau
34023419 | 2013-01-17 17:18:56 | AXIS | 1 | 5 | 2 | 1021105 | The Chairman1 | 12500 | pacific | 1943-01-13 | 1943-01-13 | Clearing Matanikau River | Nettoyage du secteur Matanikau
Spreadsheet: aed451cf-551e-4d1a-9a21-04d57344a26d
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
FHER | Test | FHER | HER-2/neu, Quantitative, ELISA | HER-2/neu Quantitative ELISA | Enzyme Linked Immunosorbent Assay (ELISA) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Draw blood in a plain, red-top tube. (Serum gel tube is acceptable.) Spin down and send 1mL serum in a screw-capped vial, shipped frozen. | 0.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | Reference Range:  0.0 - 15.0 ng/mL   Test Performed By:  LabCorp Burlington                                         1447 York Court                                          Burlington, NC 27215-2230 | Tuesday, Friday | 3 days | 4-8 days | 1 | 83950 |  |  |  |  | LabCorp Burlington
FHER | [NAME] | SRED | Serum Red |  |  |  | Frozen
FHER | Result | Z0985 | HER-2/neu Quantitative | HER-2/neu Quantitative | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 32966-1
Spreadsheet: 704891d1605796334-find-the-closer-value-from-other-columns-excel-question1
Sheet: Sheet1

 | Black Numbers 1 | Black Numbers 2 | Black Numbers 3 | [NAME] 1 | [NAME] 2 | [NAME] 3 | Red Numbers 1 | Red Numbers 2 | Red Numbers 3 | Closest value 1 | Closest value 2 | Closest value 3
 | 1642016.096 | 264841.3058064517 | 264841.3058064517 | 2973137.692899807 | 479538.3375644851 | 436993.97148 | 2871478.053737678 | 463141.6215705932 | 374538.6778922993
 | 953579.554585 | 164410.2680318966 | 153803.1539653227 | 1993875.773146834 | 343771.6850253161 | 229614.9389692307 | 2686221.405109441 | 463141.6215705932 | 374538.6778922993
 | 440362.7375 | 440362.7375 | 71026.247983871 | 443280.4868855118 | 443280.4868855118 | 409106.323748387 | 463141.6215705932 | 463141.6215705932 | 374538.6778922993
 | 672483.08652 | 258647.3409692308 | 108465.0139548388 | 1152529.265902331 | 443280.4868855118 | 409106.323748387 | 1204168.216083542 | 463141.6215705932 | 374538.6778922993
 | 1698798.3558 | 249823.2876176471 | 273999.7348064517 | 3260860.695438499 | 479538.3375644851 | 436993.97148 | 3149363.026680034 | 463141.6215705932 | 374538.6778922993
 | 3235180.781 | 505496.99703125 | 521803.3517741938 | 3069045.360412706 | 479538.3375644851 | 436993.97148 | 2964106.378051797 | 463141.6215705932 | 374538.6778922993
 | 1482785.472 | 449328.9309090909 | 239158.9470967743 | 1582476.513962801 | 479538.3375644851 | 436993.97148 | 1528367.351182958 | 463141.6215705932 | 374538.6778922993
Spreadsheet: 216235d1361651828-counting-only-specific-values-problem-2-
Sheet: Aircraft

Registration | Make | Model | Engines | Type | Operator | Times Flown | Hours Flown | Logbook Co-Pilot Night Hours
C-GGGG | Cessna | 152 | 1 | Piston
C-XXXX | [NAME] | [NAME] 23 | 2 | Turbo-Propeller
C-YYYY | [NAME] | [NAME] 23 | 2 | Turbo-Propeller
C-ZZZZ | [NAME] | [NAME] 23 | 2 | Turbo-Propeller
Spreadsheet: 751472d1634132274-tons-of-info-show-affected-from-dropdown-examplefileupdated
Sheet: Presentation

When I select Stockholm, I want a complete list of ALL devices that belong to Stockholm that are marked as Yes in the AT Column to be listed, full devicename Prefix+Numbers in the B Column. And then I want all devices marked as no in the AU column to be listed, full devicename Prefix+Numbers in the C Column. I made A6 Data Validation List based on OrgList.
Select Organization | Devices marked Yes | Devices Marked No
Stockholm
Spreadsheet: 882583d1730976580-if-a-cell-has-a-number-in-with-a-certain-text-for-it-then-to-be-added-in-a-different-cel-molecular-
Sheet: Sheet1

Molecular
Panel 1 |  |  | MCP's | Opticals | Heats | Multi's | Sounder Base | Sounder Beacon Bases | Wall Sounder Beacon | I/O's |  | bases
Loop 1 |  |  | 36 | 147 | 44
MCP's-3
Opticals-30
Heats-0
Sounder Base-19
[NAME] Bases-4
Wall Sounder Beacon-2
I/O's-3
Panel 1
[NAME]
MCP's-9
Opticals-3
Heats-37
Multi's-2
Wall Sounder Beacon-9
I/O's-7
Panel 2
Loop 1
MCP's-11
Opticals-49
Heats-3
Multi's-1
Sounder Base-17
[NAME]
Wall Sounder Beacon-5
I/O's-1
Panel 2
[NAME]
MCP's-1
Opticals-1
Sounder Base-1
Panel 3
Loop 1
MCP's-4
Opticals-17
Heats-2
Sounder Base-6
[NAME] Bases-2
Wall Sounder Beacons-3
I/O's-1
Panel 4
Loop 1
MCP's-2
Opticals-9
Wall Sounder Beacons-2
Panel 5
Loop 1
MCP's-5
Opticals-37
Heats-2
Sounder Base-13
[NAME] Bases-2
Wall Sounder Beacons-3
I/O's-4
Panel 6
Loop 1
MCP's-1
Opticals-1
Sounder Base-1
I/O-1
Spreadsheet: 821579d1678804563-remove-break-times-from-time-ranges-test10-gk
Sheet: Sheet1

Employee | Start_Time | End_Time | Actual | Required | Column1 |  | Employee List | Shift |  |  | Shift | Start | End
Emp1 | 2022-03-14 08:00:14 | 2022-03-14 12:30:00 |  | 04:14:46 |  |  | Emp1 | Patt1 |  |  | Patt1 | 10:00:00 | 10:15:00
Emp2 | 2022-03-14 08:01:00 | 2022-03-14 14:00:00 |  | 05:13:00 |  |  | Emp2 | Patt2 |  |  | Patt1 | 12:30:00 | 13:00:00
Emp3 | 2022-03-14 10:45:00 | 2022-03-14 16:00:00 |  | 04:45:00 |  |  | Emp3 | Patt3
 |  |  |  |  |  |  |  |  |  |  | Shift | Start | End
 |  |  |  |  |  |  |  |  |  |  | Patt2 | 10:15:00 | 10:30:00
 |  |  |  |  |  |  |  |  |  |  | Patt2 | 13:00:00 | 13:30:00
 |  |  |  |  |  |  |  |  |  |  | Shift | Start | End
 |  |  |  |  |  |  |  |  |  |  | Patt3 | 10:30:00 | 10:45:00
 |  |  |  |  |  |  |  |  |  |  | Patt3 | 13:30:00 | 14:00:00
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: Z Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 01-01) 22-01-2019 | pdf |  | 03-01) 05-03-2018 | pdf |  | 02-01) 18-02-2019 | pdf |  | 03-01) 25-03-2019 | pdf |  | 02-01) 18-02-2019 | pdf
 | 02-01) 19-02-2019 | pdf |  | 10-01) 11-10-2018 | pdf |  | 03-01) 25-03-2019 | pdf |  | 05-01) 02-05-2019 | pdf |  | 03-01) 26-03-2019 | pdf
 | 03-01) 26-03-2019 | pdf |  | 12-01) 16-12-2018 | pdf |  | 05-01) 02-05-2019 | pdf |  | 09-01) 09-09-2019 | pdf |  | 11-01) 24-11-2019 | pdf
 | 05-01) 02-05-2019 | pdf |  | 01-01) 21-01-2019 | pdf |  | 09-01) 08-09-2019 | pdf |  |  |  |  | 12-01) 23-12-2019 | pdf
 | 06-01) 11-06-2019 | pdf |  | 02-01) 19-02-2019 | pdf |  | 11-01) 24-11-2019 | pdf
 | 09-01) 09-09-2019 | pdf |  | 03-01) 25-03-2019 | pdf |  | 12-01) 23-12-2019 | pdf
 | 11-01) 25-11-2019 | pdf |  | 06-01) 11-06-2019 | pdf
 | 11-02) 26-11-2019 | pdf |  | 11-01) 24-11-2019 | pdf
 | 12-01) 24-12-2019 | pdf
 | 01-01) 27-01-2020 | pdf
 | 03-01) 16-03-2020 | pdf
 | 04-01) 21-04-2020 | pdf