tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 872516d1718886988-create-list-in-different-tab-list-sorted-by-weighting-score-example-prioritising
Sheet: Template

Records |  |  | DPM Comments
Reference | Business function | Sub Function | Weighting | Comments
HR-001 | HR | Recruitment | 9
HR-002 | HR | Recruitment | 9
HR-003 | HR | Recruitment | 15
C Ops-001 | Central Operations | Business Continuity | 4
C Ops-002 | Central Operations | Disaster Recovery | 4
C Ops-003 | Central Operations | Incident Management Support | 4
C Ops-004 | Central Operations | Incident Management Support | 4
C Ops-005 | Central Operations | Incident Management Support | 3
GF-001 | Global Freight | Customer Management | 5
GF-002 | Global Freight | Customs and Excise | 2
GF-003 | Global Freight | Supplier Management | 5
GF-004 | Global Freight | Resource Management | 1
ITSM-001 | ITSM | Equipment provision to users | 4
INT-001 | International | Absence Management | 1
INT-002 | International | Absence Management | 1
INT-003 | International | Absence Management | 3
INT-004 | International | Operational Management | 1
INT-005 | International | Absence Management | 1
INT-006 | International | Operational Management | 1
INT-007 | International | Meeting Management | 1
INT-008 | International | Management awareness | 3
INT-009 | International | Supplier Management | 3
INT-010 | International | Uniform Management | 4
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Spreadsheet: 625250d1558422386-help-calendar-correction-employee-absence-schedule-current-v2
Sheet: January

 | Employee Absence Schedule
 | Absence Type Key | V | Vacation |  |  | P | Pick Up Shift |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
 | January | Dates of Absence/Pick up |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019
 | Employee 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 |  |  |  | Vacation Days Available | Total Vacation  Days Taken | Total Days Picked up | Total Sick Days | Vacation Days (Year)
 | [NAME] |  |  | V | V | V | V |  |  |  |  |  |  | V |  |  | s | s |  | p |  | s | s | p | p | p | p
 | Lynda |  |  |  |  | S | S |  |  |  |  | P |  |  |  |  |  |  |  |  | S |  |  | v |  | V | V | V
 | [NAME] |  |  | P | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s |  |  |  | s | s | s | s | s | S
 | Heather |  |  |  |  |  |  | P |  |  |  |  |  |  |  |  |  |  |  | V | V | V
 | [NAME] | v | v | v |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | v | V
 | Emili |  |  |  |  | v
 | Amber
 | Meredith
 | Julie
Spreadsheet: 841247d1693446271-if-formula-excel-test-ken
Sheet: 1D Validation

NPI | Pay Class | NPI2 | PRPR | AGAG
1234567 | test | 9876543 | 887 | NC100
6543210 | MDCR100 | 9876542 | 888 | NC100
1234568 | MDCR100 | 9876541 | 889 | NC100
6543209 | MDCR100 | 9876540 | 890 | NC100
1234569 | MDCR100 | 9876539 | 891 | NC100
6543208 | MDCR100 | 9876538 | 892 | NC100
1234570 | MDCR100 | 9876537 | 893 | NC100
6543207 | MDCR100 | 9876536 | 894 | NC100
1234571 | MDCR100 | 9876535 | 895 | NC85
6543206 | MDCR100 | 9876534 | 896 | NC85
1234572 | MDCR100 | 9876533 | 897 | NC85
6543205 | MDCR100 | 9876532 | 898 | NC85
1234573 | MDCR100 | 1234581 | 899 | NC85
6543204 | MDCR100 | 1234580 | 900 | NC85
1234574 | MDCR100 | 1234579 | 901 | NC85
6543203 | MDCR100 | 1234578 | 902 | NC85
1234575 | MDCR100 | 1234577 | 903 | NC85
6543202 | MDCR100 | 1234576 | 904 | NC100
1234576 | MDCR85 | 1234575 | 905 | NC100
6543201 | MDCR85 | 1234574 | 906 | NC100
1234577 | MDCR85 | 1234573 | 907 | NC100
6543200 | MDCR85 | 1234572 | 908 | NC100
1234578 | MDCR85 | 1234571 | 909 | NC100
6543199 | MDCR85 | 1234570 | 910 | NC100
1234579 | MDCR85 | 1234569 | 911 | NC100
1234580 | MDCR85 | 1234568 | 912 | NC100
1234581 | MDCR85 | 1234567 | 913 | NC100
 | test3
Spreadsheet: 117383d1312752055-filtering-lookup-array-question-filtered
Sheet: 8041A

CONTROL CABLE
CORE CARD
Location
Cable Number |  | 8041A
Number of cores |  | 12pr
Spare cores |  | 8pr
Core size |  | 0.5mm2
Cable Type |  | Cu, PVC
Drawing References
Cable Service |  | Protection 1 Alarms
Panel Number | T44 PP |  | Panel Number |  | T44 FIE
Cable Insulation resistance >100MΩ
Core Number | Ferrule Number |  | T44 PP | INITIAL | T44 FIE | INITIAL
1 Wh | 20/ADY441143 |  | TBX5:09 |  | X11:08A
1 Bk | 20/ADY441144 |  | TBX5:10 |  | X11:08B
2 Wh | Spare
2 Bk | 20/ADY441145 |  | TBX5:11 |  | X11:09B
3 Wh | 20/ADY441152 |  | [NAME] |  | X11:15A
3 Bk | 20/ADY441153 |  | TBX5:97 |  | X11:15B
4 Wh | 20/ADY441154 |  | TBX5:98 |  | X11:16A
4 Bk | 20/ADY441155 |  | TBX5:99 |  | X11:16B
5 Wh | Spare
5 Bk | Spare
6 Wh | Spare
6 Bk | Spare
7 Wh | Spare
7 Bk | Spare
8 Wh | Spare
8 Bk | Spare
9 Wh | Spare
9 Bk | Spare
10 Wh | Spare
10 Bk | Spare
11 Wh | Spare
11 [NAME] | Spare
12 Wh | Spare
12 Bk | Spare
Termination Notes
Edition Notes | 2011-08-02 00:00:00 | Was cable 4514 |  |  |  | DJC
Spreadsheet: 1e6989b8-7270-4dd2-8278-057cfe0e7bd8
Sheet: 1999-00

Table C
Graduate Student Numbers by Faculty and Year Group
1999-00
Faculty | Year 1 | Year 2 | Year 3 | Year 4 | Year 5+ | Total
Arts and Humanities | 346 | 151 | 51 | 20 | 17
Built Environment | 514 | 68 | 27 | 25 | 30
Clinical Sciences | 349 | 283 | 209 | 69 | 24
Eastman Dental Institute | 82 | 112 | 47 | 12 | 7
Engineering | 324 | 138 | 123 | 31 | 52
Laws | 325 | 24 | 6 | 2 | 4
Life Sciences | 365 | 205 | 170 | 38 | 9
Mathematical and Physical Sciences | 264 | 100 | 109 | 26 | 10
Social and Historical Sciences | 423 | 135 | 100 | 52 | 27
School of Slavonic & East European Studies | 119 | 42 | 7 | 3 | 0
Royal Free Hospital School of Medicine | 28 | 38 | 57 | 10 | 2
Total
The Clinical Sciences total includes the Graduate Institutes of Child Health, Neurology and Ophthalmology and the Eastman Dental Institute.
Spreadsheet: 740060d1626170465-tracking-countif-sample
Sheet: Participants

 |  |  |  | [NAME]
 | Join
 |  |  |  |  | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00
Participant 1 | 2021-08-01 00:00:00 |  |  | Group 1
Participant 2 | 2021-08-01 00:00:00
Participant 3 | 2021-10-01 00:00:00
Participant 4 | 2021-11-01 00:00:00
Participant 5 | 2021-08-01 00:00:00
Participant 6 | 2022-01-01 00:00:00
Participant 7 | 2022-02-01 00:00:00
Participant 8 | 2022-03-01 00:00:00
Participant 9 | 2022-04-01 00:00:00
Participant 10 | 2022-05-01 00:00:00
Participant 11 | 2022-06-01 00:00:00
Participant 12 | 2022-07-01 00:00:00
Participant 13 | 2022-08-01 00:00:00
Participant 14 | 2022-09-01 00:00:00
Participant 15 | 2022-10-01 00:00:00
Participant 16 | 2022-11-01 00:00:00
Participant 17 | 2022-12-01 00:00:00
Participant 18 | 2023-01-01 00:00:00
Participant 19 | 2023-02-01 00:00:00
Participant 20 | 2023-03-01 00:00:00
Participant 21 | 2023-04-01 00:00:00
Participant 22 | 2023-05-01 00:00:00
Participant 23 | 2023-06-01 00:00:00
Spreadsheet: 3c6263ed-c58e-49ff-bb3b-37f3caf83a9c
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 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Home Sales
 |  | New Single-family [NAME]: United States
 |  | Seasonally Adjusted All Houses [Thousands of Units]
 |  | Period: 1963 to 2012
 |  | Data Extracted on: April 16, 2014 (3:51 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1963
1964
1965
1966
1967
1968
1969
1970
1971
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
1982
1983
1984
1985
1986
1987
1988
1989
1990
1991
1992
1993
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
Spreadsheet: 55177d1255345184-filter-by-only-first-4-numbers-copy-of-malchemist-1-
Sheet: 31561

Date of Order | Date of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20090108 | 2009-01-08 | 47995 | Diamond cutter DCH 300 110V | 1 | 408.1 | 132070 | 31561
20090223 | 2009-02-23 | 244283 | Cordl. ham. dr. driver SFH 144-A Li-Ion | 1 | 93.75 | 133241 | 31561
20090223 | 2009-02-23 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 71.5199999999999 | 133241 | 31561
20090223 | 2009-02-23 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133241 | 31561
20090223 | 2009-02-23 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133241 | 31561
20090119 | 2009-01-19 | 370101 | Battery pack SFB 185 | 1 | 89.8599999999999 | 132370 | 31561
20090303 | 2009-03-03 | 370101 | Battery pack SFB 185 | 1 | 89.8599999999999 | 133475 | 31561
Spreadsheet: 858514d1707167969-comments-or-notes-on-calendar-calendar-1-month-per-tab
Sheet: November

 |  | 2024-10-29 00:00:00 | 2024-10-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-01 00:00:00 | 2024-11-02 00:00:00 | 2024-11-03 00:00:00
 |  | 2024-11-05 00:00:00 | 2024-11-06 00:00:00 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 | 2024-11-09 00:00:00 | 2024-11-10 00:00:00
 |  | 2024-11-12 00:00:00 | 2024-11-13 00:00:00 | 2024-11-14 00:00:00 | 2024-11-15 00:00:00 | 2024-11-16 00:00:00 | 2024-11-17 00:00:00
 |  | 2024-11-19 00:00:00 | 2024-11-20 00:00:00 | 2024-11-21 00:00:00 | 2024-11-22 00:00:00 | 2024-11-23 00:00:00 | 2024-11-24 00:00:00
 |  | 2024-11-26 00:00:00 | 2024-11-27 00:00:00 | 2024-11-28 00:00:00 | 2024-11-29 00:00:00 | 2024-11-30 00:00:00 | 2024-12-01 00:00:00
 |  | 2024-12-03 00:00:00 | NOTES
Spreadsheet: 493048d1481459346-build-a-ingredient-table-based-on-two-table-sandwiches-jacc
Sheet: Sheet1

 |  | 2016-12-11 00:00:00 | 2016-12-12 00:00:00
 | SP | 2 | 1
 | ES | 1 | 2
 | CS | 1 | 1
 |  | S | E | C
 | SP | 8 |  | 1
 | ES |  | 3 | 1
 | CS |  |  | 4
 |  | 2016-12-11 00:00:00 | 2016-12-12 00:00:00 |  |  |  | 2016-12-11 00:00:00 | 2016-12-12 00:00:00
 | S | 16 | 8 |  |  | S
 | E | 3 | 6 |  |  | E
 | C | 7 | 7 |  |  | C
Spreadsheet: 117838d1313156058-sum-cells-with-text-number-text-dummy-ot-report
Sheet: Jan.

SENIORITY # | EMPLOYEE | PAY PERIOD 1                                                                     January 1, 2012 to January 7, 2012 |  |  |  |  |  |  | (AC) Acting Captain     $ value | (APC) Acting P/C     $ value | OT Standard (OT)     hour value | OT Other (OTOT)     hour value | OT Acting Captain (OTAC)      hour value | OT Acting P/C (OTAPC)      hour value | OT Stat Standard (OTSTAT)        hour value | OT Stat - Acting Captain (ACSTAT)    $ value | OT Stat - Acting P/C (APCSTAT)     $ value | OT Tech (OTTECH)     hour value | Tech Acting Captain (ACTECH)     $ value
 |  | PAY PERIOD 1 - January 1, 2012 to January 7, 2012 |  |  |  |  |  |  | 5.39 | 4.67 | x 0 | x 1.5 | x 1.5 | x 1.5 | x 0.5 | $5.39 x 2 | $4.67 x 2 | x 1.5 | 5.39
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Pay Period 1
##### | Personel 1 | 15 OTSTAT |  | 10 APC |  |  | 8 AC | 6 AC | 75.46 | 46.7 | 0 | 0 | 0 | 0 | 7.5 | 0 | 0 | 0 | 0
##### | Personel 2 |  |  |  | 15 OT |  |  |  | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
##### | Personel 3 |  | 8 OTOT | 8 OTOT | 8 OTOT |  |  |  | 0 | 0 | 0 | 36 | 0 | 0 | 0 | 0 | 0 | 0 | 0
##### | Personel 4 | 10 AC |  |  |  |  |  |  | 53.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
##### | Personel 5 | 10 OTSTAT |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0
##### | Personel 6 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
##### | Personel 7 | 15 OTSTAT LB1 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
##### | Personel 8 |  |  |  |  |  | 10 OT LB2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
##### | Personel 9 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 888762d1739341132-need-to-spilled-formula-dd
Sheet: AnalysisOfOrders_Frequency

 | Analysis of Order Frequency UP
 |  |  |  |  |  |  | 10000 | 25000 | 50000 | 100000 | 150000 | 200000 | 250000
 |  | FY 22/23 | -------------------->>>>>>>>>> Select Fiscal year from here
 |  |  |  |  |  |  | Frequency of Orders
 | CustomerCode | Customer Name | Place | Territory | Region | Godown
 |  | Adarsh [NAME] | Nanpara | [NAME] | [NAME] Pradesh-2 | [NAME] |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | #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
 | 0902 | Adarsh [NAME] | Nanpara | [NAME] | [NAME] Pradesh-2 | Lucknow Godown |  | 4 | 0 | 2 | 0 | 0 | 0 | 0 |  |  |  | 41500 | 20000 | 52875 | 10200 | 12850 | 11500 | 52600 | 37150 | 53250 | 34375 | 53500 | #N/A | #N/A | #N/A | #N/A | #N/A
 | 0902 | Adarsh [NAME] | Nanpara | [NAME] | [NAME] Pradesh-2 | [NAME] |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 |  |  |  | 16750 | 33600 | 10200 | 10000 | 3300 | 27000 | 41000 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 0222 | Abhay Traders | [NAME] | [NAME] | [NAME] Pradesh-2 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 0 | #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
 | 0222 | Abhay Traders | [NAME] | [NAME] | [NAME] Pradesh-2 | Lucknow Godown |  |  |  |  |  |  |  |  |  |  |  | 28500 | 33000 | #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
 | 0222 | Abhay Traders | [NAME] | [NAME] | [NAME] Pradesh-2 | [NAME] |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 |  |  |  | 3800 | 4750 | 18500 | 24300 | 10450 | 4750 | 29000 | 8100 | 29900 | 68200 | 99050 | 55500 | 47750 | 30900 | 34500 | 20000
 | 1953 | Abhishek Beej Agency | Padrauna | [NAME] | [NAME] Pradesh-2 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 0 | #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
 | 1953 | Abhishek Beej Agency | Padrauna | [NAME] | [NAME] Pradesh-2 | Lucknow Godown |  |  |  |  |  |  |  |  |  |  |  | 55000 | 19000 | 137500 | 28500 | 39650 | 22000 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 1953 | Abhishek Beej Agency | Padrauna | [NAME] | [NAME] Pradesh-2 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 105400 | 76850 | 23750 | 31500 | 54500 | 111300 | 34500 | 6125 | 171250 | 44000 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 588373d1535582566-extract-from-varied-texts-jtakwformula-second-extract-example
Sheet: Sheet1

Actual Data |  | Manual Version of result desired | w/ formula
x 2p-7p Op Canyon 1+4 |  | 2p-7p
x2 2p-7p |  | 2p-7p
x2 3:30p-7p xfact |  | 3:30p-7p
8a-3p pop Lazy 1+4 |  | 8a-3p
11:59p-6a |  | 11:59p-6a
2p-7p Up |  | 2p-7p
2a-7p [NAME] |  | 2a-7p
"2p-7p" |  | 2p-7p
3:30a-8:30a Other Proj |  | 3:30a-8:30a
12p-7:30p Room 4 Only |  | 12p-7:30p
8:30p-6:30a Overnite |  | 8:30p-6:30a
"4a-4:30p" |  | 4a-4:30p
Spreadsheet: 38552d1236703071-occurence-1st-occurence
Sheet: 1st Occurence

Unique ID # | Jul | Aug | Sep | Jul_Attend | Aug_Attend | Sep_Attend | 1st Occurrence
1397 | 1 |  |  | Y | N | N
1399 | 2 |  |  | Y | N | N
1659 | 1 |  |  | Y | N | N
1673 |  |  | 1 | N | N | Y
1853 | 1 |  |  | Y | N | N
1863 |  | 1 |  | N | Y | N
1942 | 1 |  |  | Y | N | N
2169 | 1 |  |  | Y | N | N
2746 | 1 | 1 |  | Y | Y | N
3238 | 1 |  |  | Y | N | N
3347 | 2 |  |  | Y | N | N
3381 | 2 |  |  | Y | N | N
3399 | 1 | 2 | 1 | Y | Y | Y
4656 |  | 1 |  | N | Y | N
4657 |  |  | 1 | N | N | Y
4669 | 1 |  |  | Y | N | N
4671 | 2 |  |  | Y | N | N
4672 | 1 |  |  | Y | N | N
4675 | 1 |  |  | Y | N | N
4676 | 1 |  |  | Y | N | N
4678 | 1 |  |  | Y | N | N
4680 | 1 |  |  | Y | N | N
4681 | 1 |  |  | Y | N | N
4682 | 1 |  |  | Y | N | N
4683 | 1 |  |  | Y | N | N
4684 | 1 |  |  | Y | N | N
4688 | 1 |  |  | Y | N | N
4689 | 1 |  |  | Y | N | N
4690 | 1 |  |  | Y | N | N
4691 | 1 |  |  | Y | N | N
4692 | 1 |  |  | Y | N | N
4693 | 1 |  |  | Y | N | N
4695 | 1 |  |  | Y | N | N
4696 | 1 |  |  | Y | N | N
4697 | 1 |  |  | Y | N | N
4698 | 1 |  |  | Y | N | N
4699 | 1 |  |  | Y | N | N
4701 | 1 |  |  | Y | N | N
4702 | 1 |  |  | Y | N | N
4703 | 1 |  |  | Y | N | N
4705 | 1 |  |  | Y | N | N
5522 |  |  | 1 | N | N | Y
5575 |  |  | 1 | N | N | Y
5576 |  |  | 1 | N | N | Y
5577 |  |  | 1 | N | N | Y
5579 |  | 1 |  | N | Y | N
5581 |  | 1 |  | N | Y | N
5582 |  | 1 |  | N | Y | N
5583 |  | 1 |  | N | Y | N
5584 |  | 1 |  | N | Y | N
5585 | 1 |  |  | Y | N | N
5586 | 1 |  |  | Y | N | N
5589 | 1 |  |  | Y | N | N
5757 | 1 |  | 2 | Y | N | Y
5761 |  |  | 1 | N | N | Y
5762 |  |  | 1 | N | N | Y
5784 | 1 | 1 |  | Y | Y | N
5785 | 1 |  |  | Y | N | N
5788 | 1 |  | 1 | Y | N | Y
5789 |  | 1 | 1 | N | Y | Y
5790 |  | 2 |  | N | Y | N
5796 |  | 1 |  | N | Y | N
5848 |  |  | 1 | N | N | Y
5849 |  |  | 1 | N | N | Y
5521 |  |  | 1 | N | N | Y
5760 |  | 2 | 1 | N | Y | Y
5791 |  | 2 | 1 | N | Y | Y
4677 | 1 |  |  | Y | N | N
4685 | 1 |  |  | Y | N | N
210 | 1 |  |  | Y | N | N
211 |  | 1 |  | N | Y | N
5792 |  | 1 |  | N | Y | N
290 |  | 1 |  | N | Y | N
5759 |  |  | 1 | N | N | Y
4686 | 1 |  |  | Y | N | N
4670 | 1 |  |  | Y | N | N
419 | 1 |  |  | Y | N | N
4687 | 1 |  |  | Y | N | N
4674 | 1 |  |  | Y | N | N
5786 | 1 | 2 |  | Y | Y | N
4704 | 1 |  |  | Y | N | N
4652 | 1 | 1 |  | Y | Y | N
5795 |  | 1 |  | N | Y | N
5787 | 1 |  |  | Y | N | N
5574 |  |  | 1 | N | N | Y
720 | 1 |  |  | Y | N | N
761 | 1 |  | 1 | Y | N | Y
5523 |  |  | 1 | N | N | Y
5580 |  | 1 |  | N | Y | N
5587 | 1 |  |  | Y | N | N
5588 | 1 |  |  | Y | N | N
4679 | 1 |  |  | Y | N | N
5794 |  | 1 |  | N | Y | N
5783 | 1 | 1 | 1 | Y | Y | Y
5793 |  | 1 |  | N | Y | N
4694 | 1 |  |  | Y | N | N
4673 | 1 |  |  | Y | N | N
1074 | 1 |  |  | Y | N | N
1078 | 1 |  |  | Y | N | N
1084 | 1 |  |  | Y | N | N
5758 |  | 1 |  | N | Y | N
5797 |  | 1 |  | N | Y | N
4700 | 1 |  |  | Y | N | N
5524 |  |  | 1 | N | N | Y
Spreadsheet: 829646d1684346358-average-function-in-array-formula-s666-pq-average-row-from-columns
Sheet: Sheet1

a | b | c | d | e |  |  |  | a | b | c | d | e | Average
1 | 4 | 7 | 5 | x |  |  |  | 1 | 4 | 7 | 5 | x | 4.25
2 | 5 | y | 5 | 2 |  |  |  | 2 | 5 | y | 5 | 2 | 3.5
3 | z | 9 | 5 | 7 |  |  |  | 3 | z | 9 | 5 | 7 | 6
Spreadsheet: 152284d1335326974-index-match-issue-jw01_sample_index_issue_24apr12_01
Sheet: Summary

 |  | Chicago-Milwaukee | < select district
 |  |  | Table 1 |  |  | Table 2
 |  | Travel zone | X1 | X2 | X3 | X4 | X5 | X6
 |  | Dense
 |  | Urban
 |  | Semi-Urban
 |  | Suburban
 |  | Remote
 |  | Proactive sell only
 |  |  |  | I would like from the "data" sheet to show the $ in X1 that is dense
Spreadsheet: 101746d1299795355-multiple-ifs-for-markk
Sheet: Sheet1

Claim | Fee | Fee (Adjusted) | Party Paid | Unique Count of Claims | Countif
Claim 1 | 1500 |  | 255
Claim 1 | 1500 |  | 255
Claim 2 | 5550 |  | 275
Claim 2 | 5550 |  | 350
Claim 2 | 5550 |  | 525
Claim 2 | 5550 |  | 525
Claim 2 | 5550 |  | 525
Claim 2 | 5550 |  | 525
Claim 3 | 3650 |  | 230
Claim 3 | 3650 |  | 255
Claim 3 | 3650 |  | 255
Claim 3 | 3650 |  | 255
Claim 3 | 3650 |  | 255
Claim 4 | 725 |  | 240
Claim 5 | 725 |  | 275
Claim 6 | 1600 |  | 300
Claim 6 | 1600 |  | 250
Spreadsheet: 770138d1645823835-sum-total-of-all-cells-between-2-hlookup-points-example
Sheet: Data Example

Column121 | Column122 | Column123 | Column124 | Column125 | Column126 | Column127 | Column128 | Column129 | Column130 | Column131 | Column132
Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
2022-02-09 00:00:00 | 2022-02-10 00:00:00 | 2022-02-11 00:00:00 | 2022-02-12 00:00:00 | 2022-02-13 00:00:00 | 2022-02-14 00:00:00 | 2022-02-15 00:00:00 | 2022-02-16 00:00:00 | 2022-02-17 00:00:00 | 2022-02-18 00:00:00 | 2022-02-19 00:00:00 | 2022-02-20 00:00:00
11838.41890525344 | 19115.91733513212 | 33450.85730514396 | 26787.40607762859 | 21124.60072827906 | 26119.17069750077 | 15175.093958104 | 14104.84546751175 | 16178.44751987896 | 22615.23439098349 | 20059.99246306857 | 23875.45004369749
4674.952787615272 | 7548.813042427629 | 13209.63380822817 | 10578.25877913644 | 8342.035524533043 | 10314.37481979071 | 5992.594819421384 | 5569.95720162979 | 6388.815849283916 | 8930.681867642326 | 7921.625213240929 | 9428.336894534248
2041.488258733769 | 3296.463920302716 | 5768.46730797183 | 4619.381644380292 | 3642.853382902595 | 4504.147110654166 | 2616.884601617149 | 2432.324505800464 | 2789.908933000905 | 3899.90722977517 | 3459.265921521778 | 4117.226407198978
1906.495539186062 | 3078.486360261019 | 5387.029361320034 | 4313.926597976826 | 3401.970936987085 | 4206.311908757251 | 2443.843993813739 | 2271.487871812575 | 2605.427149897323 | 3642.027185313073 | 3230.523134299201 | 3844.97620574734
2007.186829996237 | 3241.076179636384 | 5671.544551035718 | 4541.76601783515 | 3581.64554828472 | 4428.46767410659 | 2572.91526684743 | 2391.456180770755 | 2743.032414343437 | 3834.380333231523 | 3401.142754276697 | 4048.048077321923
1208.295489722101 | 1951.077832504372 | 3414.182276588205 | 2734.07303829988 | 2156.095335571617 | 2665.869184192059 | 1548.855276404296 | 1439.619707498161 | 1651.263173353381 | 2308.237775021401 | 2047.435439729963 | 2436.862458895006
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13477 | 14092 | 18583 | 17866 | 14292 | 11744 | 11067 | 13040 | 13441 | 21941 | 17894 | 19106
6909 | 7195 | 7993 | 7824 | 6661 | 6115 | 5509 | 5937 | 5993 | 8928 | 7818 | 7811
1915 | 2237 | 3639 | 3433 | 2056 | 1723 | 1425 | 1968 | 1899 | 4839 | 3646 | 3008
2446 | 2390 | 3584 | 3105 | 2755 | 1887 | 2232 | 2538 | 3015 | 4265 | 3209 | 4266
2207 | 2270 | 3367 | 3504 | 2820 | 2019 | 1901 | 2597 | 2534 | 3909 | 3221 | 4021