tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 927f9d92-9fc0-433e-aef5-d8a5144bacd4
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Offshoreutstyr
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
[NAME] | Øyav. 60 | 4270 | Åkrehamn | 52 84 45 20
Aukra Maritime AS | Nautnes | 6480 | Aukra | 71 17 17 00
Trelleborg Offshore Norway AS | Kalosjeg. 15 | 3055 | [NAME] | 32 23 20 00
[NAME] | Fyrstikkalléen 17 | 0661 | Oslo | 22 70 68 00 | 22 70 68 01
Maritim Service AS | [NAME] | 5450 | Sunde i Sunnhordland | 53 48 29 29 | 53 48 29 20
Cosalt Offshore Norway AS | Bekhuskaien 1 | 4013 | Stavanger | 51 55 45 00
Northrop Grumman [NAME] BV | Damsgårdsv. 167 | 5160 | Laksevåg | 55 94 94 94 | 55 34 52 27
[NAME] | Industriv. 40 | 1337 | Sandvika | 67 13 69 80
[NAME] | Høgslundv. 49 | 2020 | Skedsmokorset | 06706
PSSI AS | [NAME] g 6 | 3012 | Drammen | 400 04 325 | 32 89 90 91
Origo Solutions AS | [NAME] | 4623 | Kristiansand | 920 80 500
GearConsult | Griniv. 159 | 1359 | Eiksmarka | 400 08 003
Jumo AS | Storg. 2B | 1767 | Halden | 67 97 37 10 | 67 97 37 11
Norsafe AS | [NAME] | 4818 | Færvik | 37 05 85 00 | 37 05 85 01
Scana Offshore Vestby AS | Tverrv. 4 | 1540 | Vestby | 64 95 65 00 | 64 95 65 01
Apply Leirvik AS | Storhaugv. 130 | 5416 | Stord | 53 49 62 00 | 53 49 62 01
Origo Solutions AS | Teknologiv. | 4846 | Arendal | 920 80 500
Origo Solutions AS | Kanalarmen 12 | 4033 | Stavanger | 920 80 500
Øglænd System AS | Engelsvollv. 264 | 4353 | [NAME] | 51 78 81 00 | 51 78 81 60
Vinje Industri AS | Skibåsen 10A | 4636 | Kristiansand | 38 03 88 00
[NAME] | Stålverksv. 1 | 0661 | OSLO | 22 70 77 00 | 22 70 77 01
Kongsberg Seatex AS | Pirsenteret | 7462 | Trondheim | 73 54 55 00 | 73 51 50 20
AS Robinet | Davanger | 5310 | Hauglandshella | 56 15 28 80 | 56 15 28 88
Westcon Power and Automation AS | Jektevikv. 41 | 5582 | Ølensvåg | 474 68 000 | 53 76 61 51
TESS AS | Industrig. 8 | 3414 | [NAME] | 32 84 40 00 | 32 84 40 01
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 773580d1647945297-how-to-count-ranges-that-sum-up-to-a-specific-value-regional-stores
Sheet: Sheet1

Region | Items | Sales
maseru | Books | 56215
 | Pen | 23164
 | Pencils | 21654
 | Covers | 5643
Gaborone | Books | 24566
 | Pen | 56148
 | Pencils | 35165
 | Covers | 2152
Lilongoe | Books | 56852
 | Pen | 36521
 | Pencils | 25632
 | Covers | 1254
Joburg | Books | 56215
 | Pen | 56325
 | Pencils | 1254
 | Covers | 35264
London | Books | 45895
 | Pen | 69532
 | Pencils | 9854
 | Covers | 5623
Spreadsheet: 719057d1613488765-using-nested-vlookups-or-index-match-example-1-
Sheet: Sheet2

Routing ID | 20159 | 11217 | 10900 | 91040 | 10907 | 91050 | 91051 | 10911 | 11245 | 11219 | 10912 | 10917 | 10919 | 10910 | 12116 | 12118 | 5 | 87000 | 9065 | 12130 | 9058 | 11 | 91054 | 10924 | 65015 | 11216 | 1 | 64000 | 64010 | 11710 | 30 | 91052 | 10923 | 10408 | 9028 | 65020 | 12730
192007B
192007
192008B
192008
192009B
192009
192010B
192010
192011B
192011
192012B
192012
Spreadsheet: 00549085-aa23-4c7c-b595-9f0a4a51825e
Sheet: New Course Denial

11-Digit Core Codes for Use in the High School | CIP Code | USOE Course Title                                               Assignment Names Updated 04/26/2005 | Reason for Denial | HS Core Flag | HE GenEd Code | College | Course Prefix | Course Prefix2 | Course Title | [NAME]. | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11
[PHONE] | 110215 | 3D Graphics CE | Prerequisite courses should be taught first.  Listed instructor is not endorsed to teach course work.  Prereq: ART 1800 or instructor approval. | N |  | SLCC | ART | 2630 | Introduction to 3D Modeling | 3 | Requires, VAD Animation Emphasis A, T | 2 | E |  |  | 10 | 11 | 12 | P
[PHONE] | 110216 | 3D Animation CE | Prerequisite courses should be taught first.  Listed instructor is not endorsed to teach course work.  Prereq: ART 2630 and ART 1620 or instructor approval. | N |  | SLCC | ART | 2640 | Introduction to 3D Animation | 3 | Requires, VAD Animation Emphasis A, T | 2 | E |  |  | 10 | 11 | 12 | P
 |  |  | No Core Code counterpart.  District must submit request for new code approval to USOE.   Prereq: Recommended CIS 1130 and CS 1410. | N |  | SLCC | CSIS | 2640 | Mobile IOS App Development | 3
[PHONE] | 520621 | Entrepreneurship - Business CE | Upper level class.  Prereq: BUS 1050, MKTG 1030, ACCT 2020 | N |  | SLCC | MGT | 2020 | Entrepreneurship | 3 | Required, BusMgt Small Bus Ownership Emphasis T | 4 | B |  |  | 10 | 11 | 12 | P
[PHONE] |  | Anatomy & Physiology CE | Course may NOT be offered for Anatomy & Physiology or Advanced Health Science credit. Districts must award Foundations of Nutrition credit. | N |  | UVU | NUTR | 1020 | Foundations of Human Nutrition | 3 |  |  |  |  |  | 10 | 11 | 12 | P I
Spreadsheet: 721627d1614793785-quick-way-to-update-cell-references-in-a-chart-cell-reference-example
Sheet: example data

Month | VOLUME | ON TIME | % OT | Target TAT % on Time (90%)
July | 700 | 609 | 0.87 | 0.9
August | 595 | 483 | 0.81 | 0.9
September | 546 | 457 | 0.84 | 0.9
October | 593 | 552 | 0.9308600337268128 | 0.9
November | 517 | 445 | 0.8607350096711799 | 0.9
December | 668 | 590 | 0.8832335329341318 | 0.9
January | 627 | 541 | 0.8628389154704944 | 0.9
February | 711 | 643 | 0.9043600562587905 | 0.9
March | 686 | 638 | 0.9300291545189504 | 0.9
April | 681 | 664 | 0.9750367107195301 | 0.9
May | 617 | 596 | 0.965964343598055 | 0.9
June | 635 | 613 | 0.9653543307086614 | 0.9
July | 720 | 660 | 0.9166666666666666 | 0.9
August | 594 | 572 | 0.9629629629629629 | 0.9
September | 507 | 482 | 0.9506903353057199 | 0.9
October | 736 | 705 | 0.9578804347826086 | 0.9
November | 688 | 637 | 0.9287790697674418 | 0.9
December | 680 | 625 | 0.9191176470588235 | 0.9
January | 615 | 545 | 0.8861788617886179 | 0.9
February
Spreadsheet: 692085d1598075362-if-date-falls-on-weekend-pull-to-friday-if-date-falls-on-holiday-pull-to-previous-wday-weekend-and-holidays-dummy
Sheet: Payment Date

Country | Pay Date |  | Amended Pay Date
UK | 2020-09-18 00:00:00
AT | 2020-08-14 00:00:00
SG | 2020-09-18 00:00:00
BE | 2020-08-14 00:00:00
AT | 2020-08-24 00:00:00
US | 2020-08-24 00:00:00
NL | 2021-02-20 00:00:00
US | 2021-02-20 00:00:00
UK | 2020-11-01 00:00:00
HK | 2020-11-01 00:00:00
DE | 2020-08-27 00:00:00
US | 2021-07-08 00:00:00
SG | 2020-08-27 00:00:00
BE | 2021-07-08 00:00:00
UK | 2020-09-15 00:00:00
NL | 2020-09-15 00:00:00
AT | 2020-08-26 00:00:00
BE | 2020-08-26 00:00:00
Spreadsheet: michelle_lokay__26697__imball0111rev
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 13493 | 12695 | -79
2 | 12485 | 12695 | -89
3 | 12373 | 12695 | -49
4 | 12240 | 12695 | -3
5 | 11824 | 12695 | -6
6 | 12719 | 12695 | -19
7 | 12765 | 12316 | -17
8 | 12781 | 12695 | -3
9 | 12715 | 12695
10 | 11699 | 12695
11 | 12181 | 12695
12 | 12457 | 12695
13 | 11803 | 12695
14 | 12889 | 12695
15 | 12267 | 10695 | -814
16 | 13200 | 10851 | -1491
17 | 11471 | 10932 | -581
18 | 11182 | 10932 | -436
19 | 10635 | 10932 | -354
20 | 12573 | 10932 | -657
21 | 13477 | 10930 | -278
22 | 12903 | 9133 | -195
23 | 12860 | 10932 | -47
24 | 12302 | 10557 | -122
25 | 12831 | 10932 | -95
26 | 12471 | 10932
27 | 10710 | 10932
28 | 9526 | 10932 | 5
29 | 11549 | 10932 | -43
30 | 15227 | 10888
31
2001-10-31 00:00:00 |  |  |  |  | 421989.98
2001-11-30 00:00:00
CBS Volume
 |  |  | -246098
Spreadsheet: 477703d1472480745-excel-approval-tracker-logic-school-sub-contract-drawing-tracker
Sheet: Precast

 |  |  |  |  |  |  |  |  |  | Red lettering = returned late |  |  |  |  |  |  |  |  |  |  |  |  | Red lettering = returned late
 |  |  |  |  |  |  |  |  |  | Not yet returned |  |  |  |  |  |  |  |  |  |  |  |  | Not yet returned
 |  |  |  |  |  |  |  |  |  | A status |  |  |  |  |  |  |  |  |  |  |  |  | A status
 |  |  |  |  |  |  |  |  |  | B status |  |  |  |  |  |  |  |  |  |  |  |  | B status
 |  |  |  |  |  |  |  |  |  | C status |  |  |  |  |  |  |  |  |  |  |  |  | C status
 | Precast
 | Community School
 |  |  | DATE OF ISSUE
 |  |  |  |  |  | ISS | O+W |  |  |  | ISS | O+W |  |  | ISS | O+W |  |  | ISS | O+W
 |  |  |  | Rev | Issued | Approved | Approved | Comments | Rev | Issued | Approved | Approved | Rev | Issued | Approved | Approved | Rev | Issued | Approved | Approved | Rev | Issued | Returned | Rev | Issued | Returned
DRAWING TITLE |  |  | [NAME]
Dining Room Extension Ground Floor Slab Layout |  |  | OPL1612-HC-02 | A | 2016-07-27 00:00:00 | C | C | Change span directions | B | 2016-08-01 00:00:00 | C | C | C | 2016-08-03 00:00:00 | B | A
Stairs Details at Core 01 |  |  | OPL1612-C1 | A | 2016-07-27 00:00:00 | C | C | Subject to change
Stairs Details at Core 02 |  |  | [NAME] | A | 2016-07-27 00:00:00 | A | A
Stairs Details at Core 02 |  |  | OPL1612-C2-01 | A | 2016-07-27 00:00:00 | A | C | Level changes
Ground Floor Slab Layout Details |  |  | OPL 1612 HC-01-D | A | 2016-07-28 00:00:00 | C | A |  | B | 2016-08-10 00:00:00 | B | A
Ground Floor Slab Layout 01 |  |  | OPL 1612 HC-01-L1 | A | 2016-07-28 00:00:00 | C | A |  | B | 2016-08-10 00:00:00 | B | A
Ground Floor Slab Layout 02 |  |  | OPL 1612 HC-01-L2 | A | 2016-07-28 00:00:00 | C | A |  | B | 2016-08-10 00:00:00 | B | A
Spreadsheet: 65095d1265840159-generate-sheet-by-number-of-hours-on-shift-hb-work-load-plan
Sheet: Act KPI Workload Plan

 |  |  |  | 2010-02-07 00:00:00 | 2010-02-08 00:00:00 | 2010-02-09 00:00:00 | 2010-02-10 00:00:00 | 2010-02-11 00:00:00 | 2010-02-12 00:00:00 | 2010-02-13 00:00:00
 | 2009-06-14 00:00:00 |  |  | 2010-02-07 00:00:00 | 2010-02-08 00:00:00 | 2010-02-09 00:00:00 | 2010-02-10 00:00:00 | 2010-02-11 00:00:00 | 2010-02-12 00:00:00 | 2010-02-13 00:00:00
 |  |  | Modified: | Sun | Mon | Tue | Wed | Thu | Fri | Sat
0
0.15
0.15
0.2
0.23 |  |  |  | 0 | 0.15 | 0.15 | 0.2 | 0.23 | 0.27 | 0
0.27 |  |  |  | 10393 | 10393 | 10393 | 10393 | 10393 | 10393 | 10393
0
320
 |  |  | Total Items Unloaded | 0 | 1558.95 | 1558.95 | 2078.6 | 2390.39 | 2806.11 | 0
933
 |  |  | Total Items Processed | 0 | 1558.95 | 1558.95 | 2078.6 | 2390.39 | 2806.11 | 0
180
 |  |  | Items Put Away | 0 | 1558.95 | 1558.95 | 2078.6 | 2390.39 | 2806.11 | 0
210
0.04 |  |  | Locations Replen Retrieve | 30.616 | 26.0236 | 26.0236 | 22.962 | 24.4928 | 22.962 | 0
28
 |  |  | Locations Replen Putaway | 30.616 | 26.0236 | 26.0236 | 22.962 | 24.4928 | 22.962 | 0
32
 |  |  | Units Per Order | 1.5 | 1.9 | 2.1 | 2.2 | 2.1 | 2.1 | 2.1
 |  |  | Units To be Despatched | 1148.1 | 1236.121 | 1366.239 | 1262.91 | 1285.872 | 1205.505 | 0
 |  | 2
#N/A
#N/A
#N/A
#N/A
55
#N/A
55
20
#N/A
58.8
 |  |  | Overall Rate | 36.75511343102381 | 29.01719481396618 | 26.2536524507313 | 25.06030461206169 | 26.2536524507313 | 26.2536524507313 | 0
#N/A
53
#N/A
47 |  |  | #N/A
 |  |  | Packing 2 Man Orders | 28.50009907415824 | 24.22508421303439 | 24.22508421303439 | 21.37507430561868 | 22.80007925932659 | 21.37507430561868 | 0
#N/A
45
#N/A |  |  | [NAME] | 941.1724558034854 | 799.9965874329627 | 799.9965874329627 | 705.8793418526138 | 752.9379646427883 | 705.8793418526138 | 0
140
#N/A
140
100
100
380
25
10
Q
Spreadsheet: 859575d1707915746-by-group-subtotal-groupby-sample-data
Sheet: Table1

Site | Core | Spend
North | Non-Core | 6066.76
North | Core | 69.41999999999999
South | Non-Core | 38.51000000000001
South | Core | 476.71
East | Non-Core | 387.64
East | Core | 85.61
West | Core | 162.17
West | Non-Core | 266.86
Spreadsheet: 40832d1239217841-consecutive-positive-numbers-excel-help
Sheet: Sheet1

 | Profit/Loss | Cosecutive Positive | Consecutive Negative | [NAME] | Max Consecutive Negative | Max Consecutive Positive Value | Max Consecutive Negative Value
 | 500 | 1 | 0 | 3 | 3 | 1300 | -668
 | 200 | 2 | 0 |  |  | The value in this case should be: 2613
 | 600 | 3 | 0
 | -250 | 0 | 1
 | -360 | 0 | 2
 | -58 | 0 | 3
 | 699 | 1 | 0
 | 1900 | 2 | 0
 | 14 | 3 | 0
Spreadsheet: 180951d1347884727-how-to-insert-colums-contents-in-the-box-automatically-box
Sheet: Sheet1

Mata Pelajaran | BAHASA MELAYU
Kelas | 2 NILAM
Masa | 1.30-2.30PM
TEMA | Tema : Saya Anak Malaysia
TAJUK | Tajuk : Lambang Negara
Standard Pembjrn. | B colum's content (in sheet2)is here in the yellow box.(I want to put the point and its contents below):example
 | 1.2 | [NAME],[NAME] sumber dengan [NAME] betul.
 | 2.3 | etc
 | 5.1 | etc
Spreadsheet: eric_saibi__9674__121701
Sheet: Clinton 01

Owner Name |  | AmerGen Energy Company
Station Name |  | Clinton Nuclear Power
Unit Name |  | [NAME] 01
NERC Region |  | MAIN
State |  | IL
Fuel Type |  | Nuclear
Capacity |  | 985 MW
Start Date |  | 2001-12-15 00:00:00
End Date |  | 2001-12-17 00:00:00
Comments |  | Tube Leak
SIC |  | 4931
Plant ID |  | 1013590
Unit ID |  | 1006949
Outage ID |  | 19226
Spreadsheet: 808860d1670710690-countif-or-counta-centre-across-selection-timetable
Sheet: Term 1

LSU Teacher Timetable |  | T1 | Week | 1 | 2023-01-30 00:00:00 |  | Class 1 | Class 2 | Class 3 | Class 4 | Class 5 | Class 6 | Class 7 | N-A
Day | Teacher | 7 AM | 8 AM | 9 AM | 10 AM | 11 AM | 12 PM | 1 PM | 2 PM | 3 PM | 4 PM | 5 PM | 6 PM | 7 PM | 8 PM | 9 PM | 10 PM | Total teaching
 | Teacher 1 | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A
 | Teacher 2 |  |  |  |  |  | Class 7 | Class 7 | Class 7 |  |  |  | Class 3 | Class 3
 | Teacher 3 |  |  | 9.30-12.30
 | Teacher 4 |  |  |  |  |  | Class 1 | Class 1 |  |  |  |  | Class 4 | Class 4
 | Teacher 5 |  |  |  | Class 1 | Class 1 |  |  |  |  |  |  | Class 7 | Class 7
 | Teacher 1 |  |  | Class 2 | Class 2 | Class 2 | Class 2 | Class 2 | Class 2 | Class 2
 | Teacher 2 |  | 8.00-9.00 |  | Class 1 | Class 1 | Class 1
 | Teacher 3 | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A | N-A
 | Teacher 4 |  |  | Class 2 | Class 2 | Class 2 | Class 5 | Class 5 | Class 5
 | Teacher 5 |  |  | Class 2 | Class 2 | Class 2 |  |  |  |  |  |  | 6.00-8.00
 | Teacher 1 |  |  | class 2 | class 2 | class 2 | class 2 | class 2 | class 2 | class 2
 | Teacher 2 |  |  | class 2 | class 2 | class 2 |  | Class 1 | Class 1
 | Teacher 3 |  |  |  |  |  |  |  | Class 1 | Class 1
 | Teacher 4 |  |  | Class 5 | Class 5 | Class 5 | Class 5 | Class 5 | Class 5 |  |  |  | Class 4 | Class 4
 | Teacher 5 |  |  | class 2 | class 2 | class 2 |  |  | Class 1 | Class 1 |  |  | Class 3 | Class 3
Spreadsheet: elizabeth_sager__9505__SagerIWomen
Sheet: Women 1999 NCAA Bracket

seed |  |  | EAST |  | NAME: |  |  |  |  |  | WEST |  |  | seed
 |  |  |  |  | PHONE: |  | [PHONE]
 |  | 1 |  |  | E-MAIL: |  | [EMAIL] e-mail address Here |  |  |  |  | 1
 |  | Storrs, CT | 1 |  |  |  |  |  |  |  | 1 | Athens, GA
 |  | 2 |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | Champion &
 |  |  |  | 1 |  |  | Total Points in Final Game (both teams) |  |  | 1
 |  | 1 |  |  |  |  | 4 |  |  |  |  | 2
 |  | West Lafayette, IN | 3 |  |  |  | 95 |  |  |  | 3 | Santa Barbara, CA
 |  |  |  |  |  |  | (for tiebreaker)
 |  | 1 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  | Richmond, VA | 1 |  |  |  | 1 | Portland, OR
 |  | 1 |  |  |  |  |  |  |  |  |  | 1
 |  | Durham, NC | 1 |  |  |  |  |  |  |  | 1 | Piscataway, NJ
 |  | 2 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  | 1 |  |  |  |  |  | 1
 |  | 1 |  |  |  |  | Finals |  |  |  |  | 1
 |  |  |  |  |  |  | Philadelphia, PA
 |  | Baton Rouge, LA | 1 |  |  |  |  |  |  |  | 1 | [NAME], OR
 |  | 1 |  |  |  |  | 1 |  |  |  |  | 1
 |  |  |  |  |  |  | vs.
 |  |  | MIDWEST |  |  |  |  |  |  |  | MIDEAST
 |  |  |  |  |  |  | 2
 |  | 1 |  |  |  |  |  |  |  |  |  | 1
 |  | Ruston,LA | 1 |  |  |  |  |  |  |  | 1 | Knoxville, TN
 |  | 2 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  | 1 |  |  |  |  |  | 1
 |  | 1 |  |  |  |  |  |  |  |  |  | 1
 |  | Norfolk, VA | 1 |  |  |  |  |  |  |  | 1 | Charlottesville, VA
 |  | 1 |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  | 9 |  |  |  | 1
 |  | 1 |  |  |  |  |  |  |  |  |  | 1
 |  | State College, PA | 1 |  |  |  | Points per game: |  |  |  | 1 | South Bend, IN
 |  |  |  |  | 1st Round = |  | 5        Final 4 = |  | 20
 |  | 1 |  |  | [NAME] = |  | 10      Semis = |  | 35 |  |  | 2
 |  |  |  |  | 3rd Round = |  | 15      Finals = |  | 50
 |  |  |  | 1 |  |  |  |  |  | 1
 |  | 1 |  |  | Bonus Points are awarded for upset picks equal to the difference |  |  |  |  |  |  | 1
 |  |  |  |  | between the seed of the underdog minus the seed of the team
 |  | Ames, IA | 1 |  | expected to win that game times the round in which the game is played. |  |  |  |  |  | 1 | Lubbock, TX
 |  | 2 |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 866413d1713331008-convert-time-to-hour-and-mins-book5
Sheet: Sheet1

Date Convert | Hour [NAME] | Minute | Date | Interval 30 Minutes
 |  |  | 2024-03-28 00:00:00 | 00:30-01:00
 |  |  | 2024-03-28 00:00:00 | 03:00-03:30
 |  |  | 2024-03-28 00:00:00 | 10:00-10:30
 |  |  | 2024-03-28 00:00:00 | 20:00-20:30
 |  |  | 2024-03-28 00:00:00 | 20:00-20:30
 |  |  | 2024-03-28 00:00:00 | 20:00-20:30
 |  |  | 2024-03-28 00:00:00 | 20:30-21:00
 |  |  | 2024-03-28 00:00:00 | 20:30-21:00
 |  |  | 2024-03-28 00:00:00 | 20:30-21:00
 |  |  | 2024-03-28 00:00:00 | 21:00-21:30
 |  |  | 2024-03-28 00:00:00 | 21:00-21:30
Spreadsheet: 807601d1669967016-formular-for-analyze-best-and-weak-students-g666-ver1-ans3-v2
Sheet: 5 BEST AND WEK FEMALE STUDENT

I. FIVE BEST FEMALE STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
J. FIVE WEAK FEMALE STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
 | sd\
Spreadsheet: adb8cd25-bc61-4f07-ac02-4081f3025299
Sheet: U13 GS

 |  |  |  |  | GIRLS SINGLES 2011
 |  | GROUP MATCHES   Best of 3 games to 15
 |  |  |  |  |  |  |  | Games
 |  | GROUP A |  | 1 | 2 | 3 | 4 | Won | Points
 | 1 | [NAME] | Co |  | 4.1. | 5.9. | 15.17. | 2 | 51
 | 2 | [NAME] | Co | 15.15. |  | 15.15. | 15.15. | 6 | 90 |  | POLGLASE
 | 3 | [NAME] | Dv | 15.15. | 1.2. |  | 15.15. | 4 | 63 |  | S/F 1
 | 4 | [NAME] | Dv | 11.15. | 2.5. | 9.11. |  | 0 | 53
 |  |  |  |  |  |  |  |  |  |  | 15.6 15.9.
 |  |  |  |  |  |  |  |  | Games |  |  | POLGLASE
 |  | GROUP B |  | 1 | 2 | 3 | 4 | 5 | Won | Points |  |  | FINAL
 | 1 | [NAME] | Co |  | 10.5. | 5.8. | 15.10.16. |  | 2 | 69
 | 2 | [NAME] | Dv | 15.15. |  | 16.15. | 15.15. |  | 6 | 91
 | 3 | [NAME] | Co | 15.15. | 14.9. |  | 15.15. |  | 4 | 83 | BOWMAN
 | 4 | [NAME] | Co | 10.15.14. | 5.7. | 6.8. |  |  | 1 | 65 | S/F 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | POLGLASE
 |  |  |  |  |  |  |  |  | Games |  |  |  |  | WINNER
 |  | GROUP C |  | 1 | 2 | 3 | 4 | 5 | Won | Points |  |  |  |  | 15.6 15.8.
 | 1 | [NAME] | Co |  | 6.7. | 9.8. | 14.15.16. | 15.15. | 4 | 105
 | 2 | [NAME] | Dv | 15.15. |  | 15.15. | 15.15. | 15.15. | 8 | 120 | PIKE
 | 3 | W Houlson | Do | 15.15. | 8.6. |  | 16.15. | 15.15. | 6 | 105 | S/F 2
 | 4 | Polly Morris | Co | 16.10.14. | 5.7. | 14.9. |  | 15.15. | 3 | 105
 | 5 | [NAME] | Dv | 8.8. | 1.6. | 11.8. | 9.11. |  | 0 | 72
 |  |  |  |  |  |  |  |  |  |  |  | PIKE
 |  |  |  |  |  |  |  |  |  |  | 15.10 15.5. |  | FINAL
 |  |  |  |  |  |  |  | Games
 |  | GROUP D |  | 1 | 2 | 3 | 4 | Won | Points
 | 1 | [NAME] | Co |  | 6.6. | 10.5. | 6.4. | 0 | 37
 | 2 | [NAME] | Dv | 15.15. |  | 16.15.8. | 15.15. | 5 | 99 |  | COSGROVE
 | 3 | [NAME] | Wo | 15.15. | 18.12.15. |  | 15.15. | 6 | 105 |  | S/F2
 | 4 | [NAME] | Co | 15.15. | 9.9. | 9.9. |  | 2 | 66
Spreadsheet: 7e8f0bfe-56bd-4990-aa54-f714e874e18d
Sheet: cons_targets_up

GOID | SampleMatch | Expected | Erichment | Phyper | Padj | Term | SampleGenes | Ont
GO:0048522 | 5 | 1 | 7 | 0.000583661035258848 | 0.00408562724681193 | positive regulation of cellular process | [NAME] sax-RB spi-RE su(Hw)-RA trr-RD | BP
GO:0001745 | 5 | 1 | 6.6 | 0.000755280213352155 | 0.00528696149346509 | compound eye morphogenesis | [NAME] sav-RA sax-RB spi-RE trr-RD | BP
GO:0050793 | 5 | 1 | 6.4 | 0.000875027939116156 | 0.00612519557381309 | regulation of developmental process | Pk92B-RB arr-RA sav-RA sax-RB spi-RE | BP
GO:0007432 | 2 | 0 | 44 | 0.000931686248355702 | 0.00652180373848991 | salivary gland boundary specification | spi-RE unc-5-RA | BP
GO:0048592 | 5 | 1 | 6.2 | 0.00103217141027765 | 0.00722519987194357 | eye morphogenesis | [NAME] sav-RA sax-RB spi-RE trr-RD | BP
GO:0048518 | 5 | 1 | 6 | 0.00115673019094783 | 0.00809711133663478 | positive regulation of biological process | [NAME] sax-RB spi-RE su(Hw)-RA trr-RD | BP
GO:0009887 | 7 | 2 | 4 | 0.00120209988721405 | 0.00841469921049832 | organ morphogenesis | Ilk-RA arr-RA sav-RA sax-RB spi-RE trr-RD unc-5-RA | BP
GOID | SampleMatch | Expected | Erichment | Phyper | Padj | Term | SampleGenes | Ont
GOID | SampleMatch | Expected | Erichment | Phyper | Padj | Term | SampleGenes | Ont
Annot | Found | Expected | Enrichment | Phyper | Padj |  | Genes | Ont
Spreadsheet: 833312d1686901334-filter-with-dynamic-number-of-conditions-nested-list-formula-example
Sheet: Sheet1

Problem: Use a formula to find the count of unique Countries selected by dynamically parsing the required keys from a single text field.
Manual example:  1. Parse the keys from each yellow cell (this list of keys can be arbitrarily long) 2. Get only blue rows with one of the desired keys 3. Select all Countries for these rows 4. [NAME], then count the countries
Key | Country |  | Sample Combined Key Conditions
CAT | Aruba |  | CAT,BAM | 5
CAT | Scuba |  | BAM | 4
CAT | Pine
CAT | Palm
CAT | Cove
SAM | Aruba
SAM | Palm
SAM | Cove
BAM | Scuba
BAM | Pine
BAM | Palm
BAM | Cove
Spreadsheet: 117344d1312679975-conditional-vlookup-to-find-entry-within-date-range-conditional-vlookup-test
Sheet: Sheet1

Operation data |  |  | Admission data
URN | Op date |  | URN | ADM date E | DIS dates F | Op date OLD | Op Date
189067 | 2011-05-13 17:45:00 |  | 189067 | 2011-05-12 00:00:00
389634 | 2011-02-28 06:00:00 |  | 389634 | 2011-02-24 00:00:00
900267 | 2011-03-06 23:14:00 |  | 900267 | 2011-03-06 00:00:00
862982 | 2011-03-26 00:36:00 |  | 862982 | 2011-03-24 00:00:00
6532 | 2011-05-04 10:21:00 |  | 6532 | 2011-05-01 00:00:00
678928 | 2011-05-09 05:32:00 |  | 678928 | 2011-05-08 00:00:00
 |  |  | 189067 | 2011-01-01 02:30:00
189067 | 2011-01-01 03:02:00 |  | 389634 | 2011-12-09 00:00:00
189067 | 2011-01-01 00:00:00 |  | 900267 | 2011-08-17 00:00:00
 |  |  | 862982 | 2011-09-03 00:00:00
 |  |  | 6532 | 2011-10-25 00:00:00
 |  |  | 678928 | 2011-10-01 00:00:00
 |  |  | 189067 | 2011-01-01 00:00:00 | 2011-01-05 00:00:00