tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mary_fischer__25724__890 MTM Summary
Sheet: Feb 2001

Enron Energy Services
MTM Summary
Company 890
 |  |  |  | Beginning |  |  |  | Ending
Date |  | Account MSA/SAP |  | Balance |  | Change |  | Balance
2001-01-01 00:00:00 |  | 1740-310/2106-0000 |  | 50493145 |  |  |  | 35500417
2001-01-01 00:00:00 |  | 1860-310/2510-0000 |  | 587035369 |  |  |  | 693810695
2001-01-01 00:00:00 |  | 1860-330/2510-0100 |  | -55096987 |  |  |  | -92854607
2001-01-01 00:00:00 |  | 1860-320/2510-0200 |  | 831595 |  |  |  | 32901
2001-01-01 00:00:00 |  | 2420-310/3030-0000 |  | -448393114 |  |  |  | -527897055
2001-01-01 00:00:00 |  | 2530-310/3310-0000 |  | -115116482 |  |  |  | -235244427
 |  |  |  |  |  | Ending
Date |  | Account |  |  |  | Balance
2001-01-01 00:00:00 |  | 4923-999/4200-0000 |  |  |  | 126405602
 |  | Difference
Spreadsheet: 122454d1316806610-creating-a-sorted-spreadsheet-using-data-from-2-separate-sheets-test-data
Sheet: Sheet1

CAPTION_ID | DIRECTORY_CODE | SUB_SECTION | DISPLAY_ORDER | OM_ORDER_ID | ARCHIVE_TYPE | CAPTION_STATUS | LINE_TYPE | LISTING_ID | [NAME] | INDENT_LEVEL | DISPLAY_TEXT | DISPLAY_NUMBER | SORT_TEXT | USE_LISTING_TEXT | USE_LISTING_PHONE | PLA | CREATION_TIMESTAMP | CREATED_BY | UPDATE_TIMESTAMP | UPDATED_BY | APPLICATION_ID | APPLICATION_DATE | [NAME]
1 | 2 | CO1 | 0 | 909090 | B | A | SH | 111111 | 21111 | 0 | Store | [PHONE] |  |  |  |  | 2011-03-17 00:00:00 | 1111111 | 2011-03-17 00:00:00 | 1111111 | 1111111 | 2011-03-17 00:00:00
1 | 2 | CO1 | 1 | 909090 | B | A | SH | 111112 | 21112 | 1 | Pharmacy | [PHONE] |  |  |  |  | 2011-03-17 00:00:00 | 1111111 | 2011-03-17 00:00:00 | 1111111 | 1111111 | 2011-03-17 00:00:00
1 | 2 | CO1 | 2 | 909090 | B | A | SH | 111113 | 21113 | 2 | Deli | [PHONE] |  |  |  |  | 2011-03-17 00:00:00 | 1111111 | 2011-03-17 00:00:00 | 1111111 | 1111111 | 2011-03-17 00:00:00
1 | 2 | CO1 | 3 | 909090 | B | A | SH | 111114 | 21114 | 3 | Bakery | [PHONE] |  |  |  |  | 2011-03-17 00:00:00 | 1111111 | 2011-03-17 00:00:00 | 1111111 | 1111111 | 2011-03-17 00:00:00
Spreadsheet: 468702d1467466406-need-help-with-excel-count-function-sample-roster_reply
Sheet: Master Roster 

ROSTER
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
Date | 2016-07-03 00:00:00 | 2016-07-04 00:00:00 | 2016-07-05 00:00:00 | 2016-07-06 00:00:00 | 2016-07-07 00:00:00 | 2016-07-08 00:00:00 | 2016-07-09 00:00:00
Occupancy
Arrival/Departure
Specials | Ramadan | Ramadan | Ramadan | Eid Al Fitr | Eid Al Fitr
 |  |  |  | PH | PH
Directors
 | am | pm
Department Heads
 |  | mid
FRONT OFFICE
Guest Relations
Guest Relations Officers
Coffee Attendents
Coffee Attendent
Coffee Attendent
Coffee Attendent
CONCIERGE
Concierge
[NAME]
Bell Captain # 1
Bell Captain # 2
Bell Captain # 3
Bellboy # 6
Bellboy # 7
Bellboy # 8
Bellboy # 9
Bellboy # 10
Doormen
Doorman # 5
Doorman # 6
Doorman # 7
Doorman # 8
Club Lounge
Guest Service Agents-Club Lounge
Butlers
 | am |  |  |  |  |  | am
 |  | am
 |  | am
 |  |  |  |  |  |  | pm
Waiters
Waiter #2
Waiter #3
Guest Service Centre
Guest Service Assistants
G.S.S # 1
 | am
 | am
G.S.A # 5 | pm
G.S.A # 6 | ns
G.S.A # 7
G.S.A # 8
CID
G.S.A # 1
G.S.A # 2
G.S.A # 3
Shift Tally
Total Collegues
AM
MID
PM
NS
 | Total Collegues |  | B18:B120
 | Directors |  | B18:B19
 | Department Heads |  | B22:B25 | Dept Heads
 | Front Office |  | B27:B43 | Fo
 | Guest Relations |  | B47:B52 | GR
 | Coffee Attendants |  | B54:B56 | COFFEE
 | Concierge |  | B60:B62 | CONCIERGE
 | [NAME] |  | B64:B76 | BELL DESK
 | Doormen |  | B78:B85 | DOORMEN
 | Club [NAME] |  | B89:B93 | Club Attendants agents
 | Butlers |  | b95:b100 | butlers
 | Waiters |  | b102:b104 | waiters
 | Guest Service Centre |  | b108:b116 | gsa call centre
 | CID |  | b118:b120 | cid
Spreadsheet: 52752d1252588313-sum-a-column-if-certain-criteria-is-met-that-resides-in-other-columns-sample
Sheet: Sheet1

Identifer |  | Amount |  | Due Date |  | Interest only |  | Code |  | Fixed/Adjustable |  | Accrued
1 |  | 500 |  | 2009-01-01 00:00:00 |  | N |  | AUTO |  | F |  | N
2 |  | 300 |  | 2009-01-02 00:00:00 |  | Y |  | CREDIT |  | F |  | N
3 |  | 200 |  | 2009-01-03 00:00:00 |  | Y |  | CREDIT |  | A |  | N
4 |  | 233 |  | 2009-01-04 00:00:00 |  | Y |  | AUTO |  | A |  | N
5 |  | 50 |  | 2009-01-05 00:00:00 |  | N |  | CREDIT |  | F |  | Y
6 |  | 75 |  | 2009-01-06 00:00:00 |  | N |  | AUTO |  | A |  | Y
7 |  | 25 |  | 2009-01-07 00:00:00 |  | N |  | AUTO |  | F |  | N
8 |  | 222 |  | 2009-01-08 00:00:00 |  | N |  | CREDIT |  | F |  | N
9 |  | 4886 |  | 2009-01-09 00:00:00 |  | Y |  | CREDIT |  | A |  | N
10 |  | 1187633 |  | 2009-01-10 00:00:00 |  | N |  | EQUITY |  | A |  | Y
11 |  | 214 |  | 2009-01-11 00:00:00 |  | Y |  | EQUITY |  | A |  | N
12 |  | 2159 |  | 2009-01-12 00:00:00 |  | N |  | AUTO |  | F |  | N
13 |  | 92211 |  | 2009-01-13 00:00:00 |  | N |  | LOAN |  | F |  | N
14 |  | 2658 |  | 2009-01-14 00:00:00 |  | N |  | OTHER |  | A |  | N
15 |  | 2254 |  | 2009-01-15 00:00:00 |  | Y |  | OTHER |  | A |  | N
criteria
total sum if code =auto and equity, and fixed and adjustable=A, interest only=n and accrued =n
Spreadsheet: 96174d1295589962-summing-data-with-criteria-into-one-total-summing-data-wth-criterions
Sheet: LIST

Sr.No | NAME OF THE POLICY HOLDER | Date of Birth |  |  |  |  |  | MODE
1 | Shailesh Pradhan | 1981-01-12 00:00:00
2 | Sachin Deshpande | 1977-09-22 00:00:00 |  |  |  |  |  | [NAME]
3 | Manisha Naik | 1975-06-24 00:00:00 |  |  |  |  |  | SGL
4 | [NAME] | 1983-02-12 00:00:00 |  |  |  |  |  | HLY
 |  |  |  |  |  |  |  | QLY
 |  |  |  |  |  |  |  | ECS
Spreadsheet: 66598d1267216936-summing-quarter-to-date-in-columns-test
Sheet: data

 | January | February | March | April | May | June | July | August | September | October | November | December | Total
Revenue | 1950.634107956671 | 3737.631033720695 | 4390.341106103602 | 3629.913179721888 | 4820.341106103602 | 4876.482179104199 | 3518.558143530435 | 3538.558143530435 | 3558.558143530435 | 2658.996713329003 | 2676.004282509881 | 1364.931604754642 | 40720.94974389549
Spreadsheet: 48984d1248272263-a-couple-of-questions-related-to-if-function-sample
Sheet: Sheet1

Task | Timing
A | 2 |  | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0
B | 8 |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
C | 12 |  | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 164480d1340790203-grouping-similar-numbers-in-a-row-onecoltoseveral
Sheet: Sheet2

1107000.jpg | 1107004.jpg | 1107005.jpg | #N/A | #N/A | #N/A | #N/A | #N/A
1108500.jpg | 1108503.jpg | 1108504.jpg | 1108505.jpg | 1108509.jpg | 1108510.jpg | 1108511.jpg | #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 | #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 | #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 | #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 | #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 | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 692449d1598371398-checking-a-value-in-an-area-formula-example
Sheet: Sheet1

While/Black Zone | Buy |  |  |  |  |  | [NAME] based on A and B columns
White
White | 50 | OK |  |  |  |  | OK
White
White | 100 | Not OK since I already bought in this White  zone
White
Black | 100 | OK |  |  |  |  | OK
Black
Black
Black | 50 | Not OK since I already bought in this Black zone
White | 20 | OK |  |  |  |  | OK
Black | 30 | OK |  |  |  |  | OK
Black
Black
White
Spreadsheet: 767665d1644577024-variable-column-for-vlookup-possible-book3a
Sheet: Sheet1

Aantal ronden aan de leiding gereden per race. |  |  |  | Aantal
 |  |  | Totaal |  | 10° Targa [NAME] | 1° Circuito di Mugello | 11° Targa [NAME]
 |  |  |  |  | nWK | nWK | nWK
Abate | Carlo |  |  |  | - | - | -
Ábate | Walter |  |  |  | - | - | -
Abecassis | George |  |  |  | - | - | -
Abney | [NAME] |  |  |  | - | - | -
[NAME] | Lino |  |  |  | - | - | -
Accadia | Agostino |  |  |  | - | - | -
Achard | [NAME] |  |  |  | - | - | -
Acheson | Kenny |  |  |  | - | - | -
Ación | [NAME] |  |  |  | - | - | -
Adams | [NAME] |  |  |  | - | - | -
Adant | [NAME] |  |  |  | - | - | -
Adas | [NAME] |  |  |  | - | - | -
Ader | [NAME] |  |  |  | - | - | -
Adolff | Kurt |  |  |  | - | - | -
Agabashian | Fred |  |  |  | - | - | -
Agostini | Giacomo |  |  |  | - | - | -
Agúero | [NAME] |  |  |  | - | - | -
Aguirre | Juan |  |  |  | - | - | -
Aguirre | [NAME] |  |  |  | - | - | -
Ahrens | Kurt |  |  |  | - | - | -
[NAME] | Guido |  |  |  | - | - | 4
Aitken | [NAME] |  |  |  | - | - | -
Alabern | [NAME] |  |  |  | - | - | -
Albanese | [NAME] |  |  |  | - | - | -
Albers | Christijan |  |  |  | - | - | -
Alberti | Augustín |  |  |  | - | - | -
Spreadsheet: 78687d1279027901-competition-rank-or-vlookup-dummy
Sheet: Sheet1

ALL STAFF
 |  |  | Name |  |  |  | Date |  |  |  | Bets |  | Time |  | Pos |  | AR |  | Pos |  |  |  | [NAME]
 |  |  | Player 1 |  |  |  | 05.10. |  |  |  | -12 |  | 05:15:00 |  |  |  | 41 |  |  |  |  |  | 1
 |  |  | Player 2 |  |  |  | 24.10. |  |  |  | -12 |  | 03:14:00 |  |  |  | 37 |  |  |  |  |  | 2
 |  |  | Player 3 |  |  |  | 13.10. |  |  |  | -6 |  | 04:17:00 |  |  |  | 36 |  |  |  |  |  | 3
 |  |  | Player 4 |  |  |  | 13.10. |  |  |  | -9 |  | 05:53:00 |  |  |  | 34 |  |  |  |  |  | 4
 |  |  | Player 5 |  |  |  | 06.10. |  |  |  | -12 |  | 03:54:00 |  |  |  | 32 |  |  |  |  |  | 5
Spreadsheet: 327375d1403548720-prioritizing-budgets-with-functions-and-then-summing-prioritizing-budgets_sample_2
Sheet: Sheet1

 | Input Table |  |  |  |  |  | Summary Matrix
 | Index | Equipment | Equipment Price | Year | Priority |  |  | Year
 | 1 | Equipment A | 39981 | 1 | 1 |  | Priority | 1 | 2 | 3 |  | Total All years - by priority
 | 2 | Equipment B | 62389 | 1 | 3 |  | 1
 | 3 | Equipment C | 19365 | 3 | 3 |  | 2
 | 4 | Equipment D | 58896 | 1 | 1 |  | 3
 | 5 | Equipment E | 25035 | 3 | 2
 | 6 | Equipment F | 62536 | 3 | 1 |  | Total Per year
 | 7 | Equipment G | 66045 | 1 | 1
 | 8 | Equipment H | 15938 | 2 | 1
 | 9 | Equipment I | 37017 | 2 | 1
 | 10 | Equipment J | 47283 | 3 | 2
 | 11 | Equipment K | 17858 | 2 | 2
 | 12 | Equipment L | 73293 | 2 | 3
 | 13 | Equipment M | 43027 | 1 | 2
 | 14 | Equipment N | 11555 | 2 | 1
 | 15 | Equipment O | 69271 | 3 | 3
 | Total
Spreadsheet: andy_zipper__799__Global_Prod 10-24-01 EM
Sheet: Taken Down Prior to Exp

Global Products that were not made available on
and have not yet expired
Global Product Short Desc.
For Curr Exch    Forward                 25Oct01         JPY/USD
For Curr Exch    Forward                 25Oct01         USD/EUR
For Curr Exch    Forward                 25Oct01         USD/GBP
For Curr LME     LME (Spot)              25Oct01         JPY/USD
For Curr LME     LME (Spot)              25Oct01         USD/EUR
For Curr LME     LME (Spot)              25Oct01         USD/GBP
SG Gasoil Swap   Platts AP               Nov01           USD/bbl
SG HSFO Swap     Platts AP 180           Q2 2002         USD/mt
SG HSFO Time Spd Platts AP 180           Q102 v Q202     USD/mt
US Crude Fin Opt NYMEX WTI    EC24.5     Dec01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC25.0     Dec01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP22.5     Dec01           USD/bl/m
US PuEthane Phy  MB Dia                  Oct01           c/Gl-b
US [NAME]   Ohio River              Apr-Jun02       USD/ST-b
US [NAME]   Ohio River              Jan-Mar02       USD/ST-b
US [NAME]   Ohio River              Jul-Sep02       USD/ST-b
US [NAME]   Ohio River              Oct-Dec02       USD/ST-b
Spreadsheet: 85329d1285347894-excel-2007-excel-macro-to-update-column1-of-sheet1-with-names-in-sheet-with-equal-based-count-test
Sheet: Sheet1

Name | Data1 | Data2 | Data3 | Data4
 | Data1 | Data2 | Data3 | Data4
 | Data1 | Data2 | Data3 | Data4
 | Data1 | Data2 | Data3 | Data4
 | Data1 | Data2 | Data3 | Data4
 | Data1 | Data2 | Data3 | Data4
 | Data1 | Data2 | Data3 | Data4
 | Data1 | Data2 | Data3 | Data4
 | Data1 | Data2 | Data3 | Data4
 | Data1 | Data2 | Data3 | Data4
 | Data1 | Data2 | Data3 | Data4
 | Data1 | Data2 | Data3 | Data4
 | Data1 | Data2 | Data3 | Data4
 | Data1 | Data2 | Data3 | Data4
 | Data1 | Data2 | Data3 | Data4
 | Data1 | Data2 | Data3 | Data4
 | Data1 | Data2 | Data3 | Data4
 | Data1 | Data2 | Data3 | Data4
Spreadsheet: 64101c71-6c9e-482f-8fb6-2889f2266a58
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Big Idea | 820413007102 | Big Idea | Elephant ($6.99) God'S Creation Animal | 2012-10-27 | Toy | Ac | Call | N | Available
Big Idea | 820413007201 | Big Idea | Giraffe (5.99) God'S Creation Animal | 2012-10-27 | Toy | Children | Call | N | Available
Spreadsheet: 806997d1669710156-googlesheets-schedule-checker-2023-1st-semester-schedule-bundang
Sheet: NINA

 | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | BOOKS/PREPS
 |  |  |  |  |  |  |  |  |  |  | 1st Grade |  |  |  | 4th Grade
 |  |  |  |  |  |  |  |  |  |  | 2nd Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5th Grade
 |  |  |  |  |  |  |  |  |  |  | 3rd Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6th Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  | WRITING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | _ |  |  |  |  |  |  |  | _
 |  |  | _ |  |  |  | _
Spreadsheet: 250714d1374008373-formula-to-extract-unique-values-from-two-excel-tabs-and-sort-alphabetically-extract-unique-values-from-2-worksheets
Sheet: DATA SOURCE TAB 2

 |  |  |  |  |  |  |  |  | JAN 100
 |  |  |  |  |  |  |  |  | FEB 101
 |  |  |  |  |  |  |  |  | MAR 102
 |  |  |  |  |  |  |  |  | APR 103
 |  |  |  |  |  |  |  |  | MAY 104
 |  |  |  |  |  |  |  |  | JUN 105
 |  |  |  |  |  |  |  |  | JUL 106
 |  |  |  |  |  |  |  |  | AUG 107
 |  |  |  |  |  |  |  |  | SEP 108
 |  |  |  |  |  |  |  |  | OCT 109
 |  |  |  |  |  |  |  |  | NOV 110
 |  |  |  |  |  |  |  |  | DEC 111
 |  |  |  |  |  |  |  |  | JAN 112
 |  |  |  |  |  |  |  |  | FEB 113
 |  |  |  |  |  |  |  |  | MAR 114
 |  |  |  |  |  |  |  |  | APR 115
 |  |  |  |  |  |  |  |  | MAY 116
 |  |  |  |  |  |  |  |  | JUN 117
 |  |  |  |  |  |  |  |  | JUL 118
 |  |  |  |  |  |  |  |  | AUG 119
 |  |  |  |  |  |  |  |  | SEP 120
 |  |  |  |  |  |  |  |  | OCT 121
 |  |  |  |  |  |  |  |  | NOV 122
 |  |  |  |  |  |  |  |  | DEC 123
 |  |  |  |  |  |  |  |  | JAN 124
 |  |  |  |  |  |  |  |  | FEB 125
 |  |  |  |  |  |  |  |  | MAR 126
 |  |  |  |  |  |  |  |  | APR 127
 |  |  |  |  |  |  |  |  | MAY 128
 |  |  |  |  |  |  |  |  | JUN 129
 |  |  |  |  |  |  |  |  | JUL 130
 |  |  |  |  |  |  |  |  | AUG 131
 |  |  |  |  |  |  |  |  | SEP 132
 |  |  |  |  |  |  |  |  | OCT 133
 |  |  |  |  |  |  |  |  | NOV 134
 |  |  |  |  |  |  |  |  | DEC 36 | <<< Also listed on Data Tab 1
Spreadsheet: 752839d1635002466-combing-sumif-search-and-xlookup-excel-help-10-23-21
Sheet: Sheet1

 | Desired Outcome |  |  |  | Formulated Outcome |  | Potential formulas
Line List Only Unique | "Pipe" | "90" |  | Line List Only Unique | Pipe | 90 | Example IF(SEARCH("Pipe",P3),Q3,0) | Example XLOOKUP(A2,O4:O24,Q4:Q24,"",0) | Example SUMIF(O3:O23,A3,Q3:[NAME]) |  | Model Dump MTO | Desciption | Value 1
00001 | 40 | 10 |  | 00001 |  |  |  |  |  |  | 00001 | wholly molly, Pipe car car | 10
00002 | 60 | 10 |  | 00002 |  |  |  |  |  |  | 00001 | wholly molly 90, car car | 10
00003 | 50 | 20 |  | 00003 |  |  |  |  |  |  | 00001 | wholly molly Pipe, car car | 10
00004 | 20 | 0 |  | 00004 |  |  |  |  |  |  | 00001 | wholly molly pipe, car car | 10
00005 |  |  |  | 00005 |  |  |  |  |  |  | 00001 | wholly molly pipe, car car | 10
00006 |  |  |  | 00006 |  |  |  |  |  |  | 00002 | wholly molly pipe, car car | 10
00007 |  |  |  | 00007 |  |  |  |  |  |  | 00002 | wholly molly pipe, car car | 10
00008 |  |  |  | 00008 |  |  |  |  |  |  | 00002 | wholly molly, Pipe car car | 10
 |  |  |  |  |  |  |  |  |  |  | 00002 | wholly molly 90, car car | 10
 |  |  |  |  |  |  |  |  |  |  | 00002 | wholly molly Pipe, car car | 10
 |  |  |  |  |  |  |  |  |  |  | 00002 | wholly molly pipe, car car | 10
 |  |  |  |  |  |  |  |  |  |  | 00002 | wholly molly pipe, car car | 10
IF the word "Pipe " is present, AND the XLOOKUP says that that line is in is the line list, SUM the corresponding values |  |  |  |  |  |  |  |  |  |  | 00003 | wholly molly 90, car car | 10
 |  |  |  |  |  |  |  |  |  |  | 00003 | wholly molly pipe, car car | 10
IF(SEARCH("Pipe",D1),E1,0) |  |  |  |  |  |  |  |  |  |  | 00003 | wholly molly, Pipe car car | 10
XLOOKUP(K1,A:A,E:E,"",0) |  |  |  |  |  |  |  |  |  |  | 00003 | wholly molly 90, car car | 10
SUMIF(A:A,K1,E:E) |  |  |  |  |  |  |  |  |  |  | 00003 | wholly molly Pipe, car car | 10
IF(SEARCH("Pipe",D1),XLOOKUP(K1,A:A,E:E,"",0),0) |  |  |  |  |  |  |  |  |  |  | 00003 | wholly molly pipe, car car | 10
SUMIF(A:A,XLOOKUP(K1,A:A,E:E,"",0),E:E) |  |  |  |  |  |  |  |  |  |  | 00003 | wholly molly pipe, car car | 10
 |  |  |  |  |  |  |  |  |  |  | 00004 | wholly molly pipe, car car | 10
 |  |  |  |  |  |  |  |  |  |  | 00004 | wholly molly pipe, car car | 10
Spreadsheet: 41631d1240182579-index-and-match-returing-the-first-name-every-time-metrics-wk10b
Sheet: Sheet1

Clock | Name | Opportunities | Percent | RankKey |  | top 5 | Clock | Name | Percent | Opport.
2 | Nika | 5 | 40 |  |  |  | 32 | [NAME] | 20.93023255813954 | 43
3 | [NAME] | 30 | 9.999999999999999e-06 | 19 |  |  | 12 | [NAME] | 18.75 | 16
5 | Manny | 16 | 12.5 | 8 |  |  | 16 | Amanda | 16.12903225806452 | 62
8 | Elissa | 96 | 15.625 | 6 |  |  | 8 | Elissa | 15.625 | 96
9 | [NAME] | 83 | 7.228915662650602 | 12 |  |  | 26 | [NAME] | 13.33333333333333 | 45
11 | [NAME] | 34 | 11.76470588235294 | 9
12 | [NAME] | 16 | 18.75 | 4 |  | Bottom 8 | Clock | Name | Percent | Opport.
13 | Willie | 61 | 3.278688524590164 | 18 |  |  | 18 | Gayle | 3.773584905660377 | 53
14 | [NAME] | 89 | 10.1123595505618 | 11 |  |  | 13 | Willie | 3.278688524590164 | 61
16 | Amanda | 62 | 16.12903225806452 | 5 |  |  | 3 | [NAME] | 9.999999999999999e-06 | 30
18 | Gayle | 53 | 3.773584905660377 | 17 |  |  | 31 | Carol | 9.999999999999999e-06 | 23
44 | Kelly | 0 | 9.999999999999999e-06 |  |  |  | 33 | Adam | 9.999999999999999e-06 | 16
24 | Janice | 19 | 5.263157894736842 | 16 |  |  | 43 | Ramsay | 9.999999999999999e-06 | 45
26 | [NAME] | 45 | 13.33333333333333 | 7 |  |  | 45 | [NAME] | 9.999999999999999e-06 | 27
31 | Carol | 23 | 9.999999999999999e-06 | 21 |  |  | 62 | [NAME] | -12.5 | 16
32 | [NAME] | 43 | 20.93023255813954 | 3
33 | Adam | 16 | 9.999999999999999e-06 | 22
38 | Sandy | 43 | 6.976744186046512 | 13
40 | [NAME] | 1 | 9.999999999999999e-06
43 | Ramsay | 45 | 9.999999999999999e-06 | 24
45 | [NAME] | 27 | 9.999999999999999e-06 | 25
53 | [NAME] | 0 | 9.999999999999999e-06
62 | [NAME] | 16 | -12.5 | 28
65 | [NAME] | 2 | 50
74 | Hayley | 36 | 5.555555555555555 | 15
75 | Yvonne | 3 | 9.999999999999999e-06
5000 | [NAME] | 3 | -33.33333333333333
5001 | [NAME] | 9 | 11.11111111111111
5002 | [NAME] | 16 | 6.25 | 14
Spreadsheet: 774586d1648557176-top-10-highest-numbers-per-month-book-1-
Sheet: Points

Date | PtValue |  | Top 10 highest pts for JAN |  |  | Top 10 highest pts for March |  |  |  | Top 10 highest pts for the whole year
2021-11-02 00:00:00 | 1250
2021-11-05 00:00:00 | 750 |  | PtValue |  |  | PtValue |  |  |  | PtValue
2022-01-03 00:00:00 | 100 |  | 934 |  |  | 800 |  |  |  | 1250
2022-01-03 00:00:00 | 200 |  | 800 |  |  | 700 |  |  |  | 934
2022-01-03 00:00:00 | 450 |  | 700 |  |  | 700 |  |  |  | 800
2022-01-03 00:00:00 | 400 |  | 700 |  |  | 700 |  |  |  | 800
2022-01-03 00:00:00 | 600 |  | 700 |  |  | 700 |  |  |  | 750
2022-01-03 00:00:00 | 450 |  | 700 |  |  | 700 |  |  |  | 700
2022-01-03 00:00:00 | 350 |  | 700 |  |  | 700 |  |  |  | 700
2022-01-03 00:00:00 | 150 |  | 700 |  |  | 700 |  |  |  | 700
2022-01-03 00:00:00 | 250 |  | 700 |  |  | 600 |  |  |  | 700
2022-01-03 00:00:00 | 934 |  | 700 |  |  | 600 |  |  |  | 700
2022-01-03 00:00:00 | 450
2022-01-03 00:00:00 | 500
2022-01-08 00:00:00 | 700
2022-01-08 00:00:00 | 700
2022-01-08 00:00:00 | 450
2022-01-08 00:00:00 | 450
2022-01-08 00:00:00 | 450
2022-01-08 00:00:00 | 700
2022-01-08 00:00:00 | 350
2022-01-08 00:00:00 | 450
2022-01-08 00:00:00 | 200
2022-01-08 00:00:00 | 350
2022-01-08 00:00:00 | 600
2022-01-08 00:00:00 | 400
2022-01-08 00:00:00 | 400
2022-01-08 00:00:00 | 400
2022-01-11 00:00:00 | 450
2022-01-11 00:00:00 | 600
2022-01-11 00:00:00 | 400
2022-01-11 00:00:00 | 450
2022-01-11 00:00:00 | 350
2022-01-11 00:00:00 | 600
2022-01-11 00:00:00 | 600
2022-01-11 00:00:00 | 600
2022-01-21 00:00:00 | 800
2022-01-25 00:00:00 | 700
2022-01-25 00:00:00 | 700
2022-01-25 00:00:00 | 700
2022-01-25 00:00:00 | 700
2022-01-25 00:00:00 | 600
2022-01-25 00:00:00 | 600
2022-01-26 00:00:00 | 600
2022-01-26 00:00:00 | 600
2022-01-26 00:00:00 | 700
2022-03-07 00:00:00 | 700
2022-03-07 00:00:00 | 350
2022-03-07 00:00:00 | 700
2022-03-07 00:00:00 | 600
2022-03-07 00:00:00 | 450
2022-03-07 00:00:00 | 400
2022-03-07 00:00:00 | 600
2022-03-07 00:00:00 | 600
2022-03-07 00:00:00 | 600
2022-03-07 00:00:00 | 700
2022-03-07 00:00:00 | 450
2022-03-07 00:00:00 | 400
2022-03-07 00:00:00 | 350
2022-03-07 00:00:00 | 700
2022-03-07 00:00:00 | 350
2022-03-07 00:00:00 | 600
2022-03-07 00:00:00 | 600
2022-03-07 00:00:00 | 600
2022-03-07 00:00:00 | 700
2022-03-07 00:00:00 | 700
2022-03-07 00:00:00 | 700
2022-03-07 00:00:00 | 600
2022-03-07 00:00:00 | 400
2022-03-14 00:00:00 | 400
2022-03-14 00:00:00 | 450
2022-03-14 00:00:00 | 350
2022-03-14 00:00:00 | 350
2022-03-14 00:00:00 | 800
Spreadsheet: 866486d1713405808-comma-seperated-filter-criteria-issue-example-spreadsheet-travisdh-
Sheet: Calculator

 |  |  |  |  |  |  |  |  |  | Components: | SV,TT,RP,MC
Item | Qty | $/Qty | [NAME] |  | CATEGORY_A | Total | Section |  | Item | Qty | $/Qty | [NAME] | CATEGORY_A | Total | Section
Spreadsheet: 116854d1312230295-selective-columns-table
Sheet: Sheet1

handicap | 0 |  | All holes
 | bogie |  | par |  | [NAME] |  | albatross |  | condor |  | condor
 | Shots taken | Points | Shots taken | Points | Shots taken | Points | Shots taken | Points | Shots taken | Points | Shots taken | Points
par 3 | 4 | 1 | 3 | 2 | 2 | 3 | 1 | 4
par 4 | 5 | 1 | 4 | 2 | 3 | 3 | 2 | 4 | 1 | 5
par 5 | 6 | 1 | 5 | 2 | 4 | 3 | 3 | 4 | 2 | 5 | 1 | 6
handicap | 1-18
 | double bogie |  | bogie |  | par |  | [NAME] |  | albatross |  | condor
 | Shots taken | Points | Shots taken | Points | Shots taken | Points | Shots taken | Points | Shots taken | Points | Shots taken | Points | Shots taken | Points
par 3 | 5 | 1 | 4 | 2 | 3 | 3 | 2 | 4 | 1 | 5
par 4 | 6 | 1 | 5 | 2 | 4 | 3 | 3 | 4 | 2 | 5 | 1 | 6
par 5 | 7 | 1 | 6 | 2 | 5 | 3 | 4 | 4 | 3 | 5 | 2 | 6 | 1 | 7
handicap | 19-36
 | triple bogie |  | double bogie |  | bogie |  | par |  | [NAME] |  | albatross |  | condor |  | condor
 | Shots taken | Points | Shots taken | Points | Shots taken | Points | Shots taken | Points | Shots taken | Points | Shots taken | Points | Shots taken | Points | Shots taken | Points
par 3 | 6 | 1 | 5 | 2 | 4 | 3 | 3 | 4 | 2 | 5 | 1 | 6
par 4 | 7 | 1 | 6 | 2 | 5 | 3 | 4 | 4 | 3 | 5 | 2 | 6 | 1 | 7 | 1 | 7
par 5 | 8 | 1 | 7 | 2 | 6 | 3 | 5 | 4 | 4 | 5 | 3 | 6 | 2 | 7 | 2 | 7
 | Handicap |  | Stroke index |  | Extra Shots
 | 1 |  | 1 |  | 1 (Table  2) |  | 2-18 (table 1)
 | 10 |  | 1-10 |  | 1-10 (table 2) |  | 11-18 (table 1)
 | 18 |  | 1-18 |  | 1-18 (table 2)
 | 24 |  | 1-18, 1-6 |  | 1-6 (table 3) |  | 7-18 (table 2)
 | 30 |  | 1-18, 1-12 |  | 1-12 (table 3) |  | 13-18 (table 2)
 | 36 |  | 1-18 |  | 1-18 (Table 3)
Spreadsheet: 24327d1214515760-linking-adjacent-cells-to-each-other-terttables
Sheet: WBMain

Phone | Name
6555222 | NICK
6555235 | NICK
6555248 | NICK
6555261 | NICK
6555274 | NICK
6555287 | NICK
6555300 | NICK
6555313 | NED
6555326 | NED
6555339 | NED
6555352 | [NAME]
6555365 | [NAME]
6555378 | [NAME]
6555391 | [NAME]
6555404 | [NAME]
6555417 | MARY
6555430 | MARY
6555443 | MARY
6555456 | GEORGE
6555469 | OSCAR
6555482 | OSCAR
6555495 | OSCAR
6555508 | OSCAR
6534455 | [NAME]