tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 713552d1610782956-extract-values-in-column-b-into-column-c-using-left-mid-or-right-function-extract-values_sample2
Sheet: Sheet1

# | Names | Extrated Names
1 | [NAME], Aadigan | Tbnor
2 | Sharper-Averyer, [NAME] | Sharper-Averyer
3 | Tbra, [NAME] | Tbra
4 | [NAME], Sahaeer | [NAME]
5 | [NAME], Cadmus | [NAME]
6 | Tbrahame Jr., [NAME] | Tbrahame Jr.
7 | Abrahamo, [NAME] | Abrahamo
8 | [NAME], Cadorette | [NAME]
9 | Sharper-Averyer Jr., [NAME] | Sharper-Averyer Jr.
10 | Tbrahem, [NAME] | Tbrahem
11 | Abrahim, Cadwallader | Abrahim
12 | Sharper-Averyer, Jr., [NAME] | Sharper-Averyer, Jr.
13 | Abrahon, Cady | Abrahon
14 | Sharper-Averyer, Jr, [NAME] | Sharper-Averyer, Jr
15 | Abram, Caetano | Abram
16 | Abramo, Cafarella | Abramo
17 | [NAME], Cafarelli | [NAME]
18 | Abselon, Cafaro | Abselon
19 | Absolom, Jr., [NAME] | Absolom, Jr.
20 | Absolum, [NAME] | Absolum
21 | Tbnor, Cadigan | Tbnor
22 | Hub, Oest | Hub
23 | Room, Say | Room
24 | Say, Saying | Say
25 | [NAME], [NAME] | [NAME]
26 | Call, Vict | Call
27 | [NAME], Wins | [NAME]
28 | [NAME], Winsr | [NAME]
29 | Boy, Crazyin | Boy
30 | Tbnor, Aadigan | Tbnor
31 | [NAME], IsLord | [NAME]
32 | Tbnor, Aadigan | Tbnor
Spreadsheet: debra_perlingiere__8455__Paul Bryan Trust
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY:
DATE: | 2001-11-16 00:00:00 | ENA CONTACT: | [NAME]
COUNTERPARTY: | [NAME] Mineral Trust | CONTACT: | [NAME]
ADDRESS: |  | TITLE:
 |  | PHONE: | [PHONE]
 |  | FAX:
INCORPORATION STATE: | ???? | S&P RATING:
STRUCTURE | COUNTERPARTY | ENA ENTITY
COLLATERAL
THRESHOLD  in $ | 0 | $15MM
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | N/A | N/A
LIMIT in $[NAME]
Incorporation State:
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty
-Guarantor
Debt Ratings Change
-Below =
Financial Covenants
-Funded Debt/Net Worth
-Minimum EBITDA, for trailing 12 months
-Minimum Cash & Cash equivalents
-Current Ratio
Non-Specific |  | X
-Unilateral |  | X
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt
-Counterparty | 100
-Guarantor ($[NAME])
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES: | NO:X
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
OTHER COMMENTS
CREDIT REVIEW  PREPARED BY: |  | Vanek | 31436
Spreadsheet: 838689d1691256600-mround-and-ceiling-are-not-round-correctly-as-per-system-hols
Sheet: HP (2)

NO | Start  Date | Holiday Entitlment | HR | Pro-rata
525 | 2023-01-09 00:00:00 | 25 | 25
497 | 2023-01-16 00:00:00 | 20 | 19.5
545 | 2023-02-06 00:00:00 | 20 | 18.5
529 | 2023-02-10 00:00:00 | 25 | 22.5
533 | 2023-02-13 00:00:00 | 25 | 22.5
562 | 2023-02-17 00:00:00 | 20 | 17
566 | 2023-02-20 00:00:00 | 25 | 22
565 | 2023-02-21 00:00:00 | 25 | 22
567 | 2023-02-27 00:00:00 | 25 | 21.5
568 | 2023-03-06 00:00:00 | 20 | 16.5
577 | 2023-03-21 00:00:00 | 20 | 16
Spreadsheet: 709103d1608156886-matching-different-dates-with-same-item-sample-example-multi-match-same-id
Sheet: Intakes

ID # | Name | Intake Date | Intake Date | Address | Type | Condition | Species | Sex | Age | Breed | Color
A826166 | *Ophelia | 2020-11-01 16:49:00 | 2020-12-01 16:49:00 | [NAME] (TX) | Owner [NAME] | Normal | Dog | [NAME] | 2 years | German Shepherd | Black/Brown
A826166 | *Ophelia | 2020-11-20 14:48:00 | 2020-11-20 14:48:00 | 1433 Bradbury Lane in Austin (TX) | Stray | Normal | Dog | Intact Female | 2 years | German Shepherd | Black/Brown
A825863 | *Poppet | 2020-11-19 19:15:00 | 2020-11-19 19:15:00 | [NAME] (TX) | Owner [NAME] | Normal | Dog | [NAME] | 8 months | [NAME] | Brown/White
A825863 | *Poppet | 2020-11-14 08:36:00 | 2020-11-14 08:36:00 | 15204 Eilers Road in Travis (TX) | Stray | Normal | Dog | Intact Female | 8 months | [NAME] | Brown/White
[NAME] | [NAME] | 2020-11-05 16:37:00 | 2020-12-05 16:37:00 | 8107 Manassas in Austin (TX) | Stray | Injured | Dog | Intact Female | 10 years | Lhasa Apso | White/White
A825492 | Luna | 2020-11-04 12:40:00 | 2020-12-04 12:40:00 | Manor (TX) | Owner [NAME] | Normal | Dog | [NAME] | 1 month | [NAME] | Black
A825492 | Luna | 2020-12-05 10:55:00 | 2020-11-05 10:55:00 | 8102 [NAME] in Travis (TX) | Stray | Normal | Dog | Intact Female | 4 weeks | [NAME] | Black
A825653 | [NAME] | 2020-11-16 13:38:00 | 2020-11-16 13:38:00 | [NAME] (TX) | Owner [NAME] | Normal | Dog | [NAME] | 3 years | Beagle/Chihuahua Shorthair | Tan/White
A825653 | [NAME] | 2020-11-08 14:28:00 | 2020-11-08 14:28:00 | 7201 [NAME] in Austin (TX) | Abandoned | Normal | Dog | Intact Female | 3 years | Beagle/Chihuahua Shorthair | Tan/White
A826777 |  | 2020-11-05 17:38:00 | 2020-12-05 17:38:00 | 6405 Cir S Rd in Austin (TX) | Stray | Normal | Dog | Intact Female | 4 months | Pit Bull Mix | Black/White
A826773 |  | 2020-11-05 16:21:00 | 2020-12-05 16:21:00 | [NAME] (TX) | Stray | Normal | Cat | Intact Male | 4 weeks | Domestic Shorthair | [NAME]
A826772 |  | 2020-11-05 16:18:00 | 2020-12-05 16:18:00 | [NAME] (TX) | Stray | Normal | Cat | Intact Male | 4 weeks | Domestic Shorthair | [NAME]
A826771 |  | 2020-11-05 16:13:00 | 2020-12-05 16:13:00 | [NAME] (TX) | Stray | Normal | Cat | Intact Male | 4 weeks | Domestic Shorthair | [NAME]
A825700 |  | 2020-11-04 12:52:00 | 2020-12-04 12:52:00 | 9500 Dessau Rd in Austin (TX) | Owner [NAME] | Normal | Dog | Neutered Male | 3 months | [NAME] | [NAME]
A826774 |  | 2020-11-26 16:30:00 | 2020-11-26 16:30:00 | 22914 [NAME] in  (TX) | Stray | Normal | Cat | NULL | NULL | Sphynx | Unknown
A825700 |  | 2020-11-19 19:15:00 | 2020-11-19 19:15:00 | [NAME] (TX) | Owner [NAME] | Normal | Dog | Neutered Male | 3 months | [NAME] | [NAME]
A825700 |  | 2020-11-09 15:32:00 | 2020-11-09 15:32:00 | 11220 [NAME] in Austin (TX) | Stray | Normal | Dog | Intact Male | 2 months | [NAME] | [NAME]
Spreadsheet: 183471d1348838575-conditional-format-a-date-book1-1-
Sheet: Sheet1

Date | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
 | 2012-01-01 00:00:00 | 2012-02-10 00:00:00 | 2012-03-11 00:00:00 | 2012-05-01 00:00:00 | 2012-05-25 00:00:00 | 2012-06-10 00:00:00 | 2012-07-18 00:00:00 | 2012-08-21 00:00:00
 | 2012-04-01 00:00:00 |  |  | 2012-05-25 00:00:00 |  |  | 2012-09-27 00:00:00 |  |  |  |  |  |  | is blank it is yellow until we are in the next month then it turns red and if the date entered is outside of the month it turns red
 | 2013-01-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 64737d1265580164-excel-2007-if-formula-for-several-values-book2-1-
Sheet: Sheet1

Field Cost: |  |  |  |  |  | Survey Type | Est. # of Full Plots | Field Cost
FG | 18 | per plot |  |  |  | FG | 5 | 90
RG | 1 |  |  |  |  | RG | 5 | 5
IMM | 2 |  |  |  |  | IMM | 17 | 34
WTP | 3 |  |  |  |  | WTP | 14 | 42
SU | 4 |  |  |  |  | SU | 6 | 24
SA | 5 |  |  |  |  | SA | 6 | 30
I WOULD ALSO LIKE TO HAVE THE MULTIPLIER (COLUMN H) TO BE BLANK IF G CELLAS ARE BLANK (= IF(G2="","",H2))
Spreadsheet: 869596d1716210951-schedule-formula-that-indicates-off-days-test-schedule
Sheet: Sheet2

 |  |  | YR | MONTH
9 | 0630-1600 | [NAME], Sun | 2024 | JANUARY
8 | 0700-1530 | 5/4/9 1st Fri off | 2025 | FEBRUARY
9 | 0700-1630 | 5/4/9 2nd Fri off | 2026 | [NAME]
10 | 0700-1730 | 5/4/9 1st Mon off | 2027 | APRIL
8 | 0730-1600 | 5/4/9 2nd Mon off | 2028 | MAY
9 | 0730-1700 | off Mon & Tue | 2029 | [NAME]
8 | 0800-1630 | off Wed & Thur | 2030 | JULY
 |  | 1st Mon, 2nd Mon, and Friday | 2031 | AUGUST
 |  | 1st Mon, 2nd Tue, 3rd Thur, 4th Friday |  | SEPTEMBER
 |  | 1st Mo, 3rd Mo |  | OCTOBER
 |  | 1st Fr, 3rd Fr |  | NOVEMBER
9 | 0800-1730 | 4/10 Fri off |  | DECEMBER
8 | 0830-1700 | 4/10 Mon off
 | 1530-2400 | [NAME],Mon, Wed
 | 1430-2300 | Off Mon,[NAME],[NAME]
Spreadsheet: 678923d1590124660-what-is-wrong-with-my-formula-test-file_dummy-data
Sheet: Test

Last name, First name | Contract Start Date ([NAME]:dd:yyyy) | Contract End Date | [NAME] | Annual Salary | Monthly Salary | HC Jun 2020 | HC Jul 2020 | HC Aug 2020 | HC Sep 2020 | HC Oct 2020 | HC Nov 2020 | HC Dec 2020 | [NAME] | [NAME] | [NAME] 2020 | [NAME] | [NAME] | [NAME] | [NAME]
Apple | 2019-11-01 00:00:00 | 2021-11-22 00:00:00 | 2020-05-22 00:00:00 | 46800 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Orange | 2020-03-15 00:00:00 | 2020-11-22 00:00:00 |  | 80400 |  | 1 | 1 | 1 | 1 | 1 | 1 | 0 |  |  |  |  |  | 3350 | 0
[NAME] | 2019-11-01 00:00:00 | 2020-07-22 00:00:00 |  | 46800
Plum | 2020-07-23 00:00:00 | 2021-11-22 00:00:00 |  | 69600
Candy | 2019-11-23 00:00:00 | 2021-09-22 00:00:00 |  | 80400
[NAME] | 2020-11-23 00:00:00 | 2021-10-22 00:00:00 |  | 69600
[NAME] | 2019-11-23 00:00:00 |  |  | 150000
Spreadsheet: 874714d1721245032-create-a-water-meter-read-log-that-can-handle-missed-meter-reads-and-weekends-updated_water_meter_logo_final
Sheet: Sheet1

Date | [NAME] | Usage | Unnamed: 3 | Unnamed: 4 | D | E | C | F
2024-07-01 00:00:00 | 421830 |  | 421830 | 421830
2024-07-02 00:00:00 | 421840 | 10 | 421840 | 421840
2024-07-03 00:00:00 | 421860 | 20 | 421860 | 421860
2024-07-04 00:00:00 |  |  |  | 421950
2024-07-05 00:00:00 |  |  |  | 421950
2024-07-06 00:00:00 |  |  |  | 421950
2024-07-07 00:00:00 |  |  |  | 421950
2024-07-08 00:00:00 |  |  |  | 421950
2024-07-09 00:00:00 |  |  |  | 421950
2024-07-10 00:00:00 |  |  |  | 421950
2024-07-11 00:00:00 |  |  |  | 421950
2024-07-12 00:00:00 | 421950 |  | 421950 | 421950
2024-07-13 00:00:00 | 421960 | 10 | 421960 | 421960
2024-07-14 00:00:00
2024-07-15 00:00:00
2024-07-16 00:00:00
2024-07-17 00:00:00
2024-07-18 00:00:00
2024-07-19 00:00:00
2024-07-20 00:00:00
2024-07-21 00:00:00
2024-07-22 00:00:00
2024-07-23 00:00:00
2024-07-24 00:00:00
2024-07-25 00:00:00
2024-07-26 00:00:00
2024-07-27 00:00:00
2024-07-28 00:00:00
2024-07-29 00:00:00
2024-07-30 00:00:00
2024-07-31 00:00:00
2024-08-01 00:00:00
Spreadsheet: 0a325dfc-6a0b-4a35-b174-e191307f2b2f
Sheet: Charter Schools

 | Student-Teacher Ratios
 | FY 2010
 | Local Education Agencies | Median Student-Teacher Ratio
83 | Academy for Math, Engineering & Science (AMES) | 21.81
8B | American Leadership Academy | 22.41
74 | American Preparatory Academy | 23.28
3B | Beehive Science and Technology Academy (BSTA) | 12.54
9D | Canyon Rim Academy | 24.64
2D | [NAME] | 17.87
87 | City Academy | 10.87
3E | C.S. Lewis Academy | 14.75
A3 | DaVinci Academy | 17.77
4E | Dual Immersion Academy | 19.05
6F | Early Light Academy at Daybreak | 24.41
A8 | East Hollywood High | 16.58
5E | [NAME] | 17.69
3C | Entheos Academy | 20.13
7F | Excelsior Academy | 21.12
98 | Fast Forward High | 14.87
82 | Freedom Academy | 18.24
7E | Gateway Preparatory Academy | 18.32
5D | [NAME] | 20.48
1E | Guadalupe School | 20
8F | Hawthorn Academy | 23.6
2C | Intech Collegiate High | 22.95
A5 | Itineris Early College High | 20.72
93 | [NAME] | 16.03
2E | [NAME] | 16.94
4C | Lakeview Academy | 19.17
5C | Legacy Prep Academy | 19.68
6C | Liberty Academy | 32.25
2B | Lincoln Academy | 19.6
8E | Merit College Prep Academy | 11.97
A7 | Moab Community School | 11.25
7C | Monticello Academy | 19.91
8C | Mountainville Academy | 21.38
9B | Navigator Pointe Academy | 17.45
A1 | [NAME]. for Math, Engineering & Science (NUAMES) | 27.99
6D | Noah Webster Academy | 21.84
A6 | [NAME] | 22.83
5B | North Star Academy | 19.89
1C | Odyssey Charter School | 19.74
68 | Ogden Prep Academy | 19.34
8D | Open Classroom | 20.89
9F | Open High School | 28.16
1G | Oquirrh Mountain Charter School | 22.4
9C | Paradigm High School | 14.24
86 | Pinnacle Canyon Academy | 13.34
9E | Providence Hall | 25.26
1F | Quest Academy | 23.53
A2 | Ranches Academy | 22.78
7B | [NAME] Academy | 19.17
1D | Renaissance Academy | 19.17
2F | Rockwell Charter High | 15.08
97 | Salt Lake Arts Academy | 17.37
4F | Salt Lake Center for Science Ed. | 18.97
7D | Salt Lake School for Perf. Arts | 38.81
89 | [NAME] | 13.87
3D | Spectrum Academy | 11.38
A9 | SUCCESS Academy | 67.12
88 | Success School | 23.5
A4 | Summit Academy | 20.12
4D | Syracuse Arts Academy | 22.6
94 | [NAME] | 21.27
 | [NAME] | 24.68
95 | Timpanogos Academy | 21.46
90 | Tuacahn High School for the Performing Arts | 17.68
92 | Uintah River High | 6.47
1B | Utah County Academy of Science (UCAS) | 27.94
5F | Utah Virtual Academy | 44.12
3F | Venture Academy | 20.77
2G | Vista at Entrada | 23.07
81 | Walden School of Liberal Arts | 12.82
4B | Wasatch Peak Academy | 22
 | CHARTER MEDIAN | 20.06
 | Notes:
 | A "student" is any person enrolled in K-12 as of October 1, 2009.
 | A "teacher" is any person assigned at the school as a Regular Classroom Teacher (excluding Preschool Teachers),
 | a Special Education Teacher, or a School-Based Specialist.
Spreadsheet: michelle_lokay__26697__imball0111rev
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -9176 | -8000 | -53585 | -52385
2 | -7998 |  | -55978 | -63432
3 | -339 |  | -43470 | -43389
4 |  |  | -44197 | -43389
5 | -19861 | -19849 | -44795 | -43389
6 | -3378 |  | -64057 | -64930
7 |  |  | -39217 | -39994
8 | -19803 | -20000 | -45022 | -44929
9 | -34805 | -26372 | -47657 | -54930
10 | -9 |  | -47014 | -46230
11 |  |  | -47006 | -46230
12 |  |  | -45017 | -46230
13 | -1529 | -33672 | -69371 | -37824
14 | -29120 | -28465 | -40711 | -40832
15 | -159 |  | -46596 | -46041
16 |  | -1568 | -26464 | -25633
17 |  |  | -45530 | -44930
18 |  |  | -45004 | -44930
19 |  |  | -45005 | -44930
20 |  |  | -93945 | -92496
21 |  |  | -61267 | -60542
22 |  |  | -35600 | -35031
23 |  |  | -34996 | -35031
24 |  |  | -21063 | -21496
25 |  |  | -18183 | -18163
26 |  |  | -25806 | -25646
27 |  |  | -11879 | -11890
28 |  |  | -86807 | -86116
29 | -17859 | -18068 | -42816 | -42665
30 | -83 |  | -21913 | -21499
31
 | 2001-10-31 00:00:00 |  |  |  | -2696
 | 2001-11-30 00:00:00
CBS Dollars
 |  |  | -88141.49
Spreadsheet: 474242d1470683254-dynamic-shortlist-a-table-tables
Sheet: Sheet1

No | Name | Qty |  |  | No | Name | QTY
1 | Testing 1 | 15 |  |  | 1 | Testing 1 | 15
2 | Testing 2 |  |  |  | 4 | Testing 4 | 20
3 | Testing 3 |  |  |  | 6 | Testing 6 | 22
4 | Testing 4 | 20 |  |  | 7 | Testing 7 | 30
5 | Testing 5
6 | Testing 6 | 22
7 | Testing 7 | 30
8 | Testing 8
9 | Testing 9
10 | Testing 10
Spreadsheet: 701804d1603938165-averageifs-age-and-countifs-column-c-contains-y-or-column-d-contains-y-first-and-second
Sheet: Sheet1

 | Age | FIRST | SECOND | Helper |  | Count | Sum | Average
Patient 1 | 38 | Y
Patient 2 | 37 | Y | Y
Spreadsheet: 68746d1269308941-lookup-match-multiple-variables-streets-example
Sheet: Voters

LAST NAME | FIRST NAME | STREET NUMBER | STREET NAME | PRECINCT
Doe | [NAME] | 123 | [NAME] |  | <--Should return [NAME]
Smith | [NAME] | 420 | [NAME] |  | <--Should return Precinct CCC
Washer | [NAME] | 4445 | [NAME] |  | <--Should return Precinct ABC
Jones | JJ | 1600 | [NAME] |  | <--Should return [NAME]
Spreadsheet: 266151d1379512978-index-match-function-trainees-progress-report
Sheet: Score Card

 |  |  | Knowledge Check 1 |  |  |  |  |  |  | Knowledge Check 2
Agent | Agent ID | Criteria | Week 1 | Grade | Week 2 | Grade2 | Week 3 | Grade3 | Criteria | Week 1 | Grade | Week 2 | Grade2 | Week 3 | Grade3
[NAME] | 10056 | Knowledge Check 1 | 95 |  |  |  |  |  | Knowledge Check 2 |  |  |  |  |  |  | Overall Grade Bar
[NAME] | 12035 |  | 85
Al begalo | 14562 |  | 96
[NAME] | 14582 |  | 93
[NAME] | 19965 |  | 98
Spreadsheet: 140319d1328705356-peak-days-for-leave-taken-4-leave
Sheet: LEAVE

 | LEAVE |  |  |  |  |  |  | 2012-02-01 00:00:00
 |  |  |  | [NAME] | čet | pet | sub | ned | pon | uto | [NAME] | čet | pet | sub | ned | pon | uto | [NAME] | čet | pet | sub | ned | pon | uto | [NAME] | čet | pet | sub | ned | pon | uto | [NAME] | čet | pet
 | PAY NO | SURNAME & INITIALS | RANK | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 |  |  |  | 2
1 | 0 |  | 0 | s | s | v | v |  |  |  |  | s | s |  |  |  |  | s | s | s |  |  |  |  |  |  | s |  |  |  |  |  |  | s
3 | 0 |  | 0
4 | 0 |  | 0
5 | 0 |  | 0
6 | 0 |  | 0
7 | 0 |  | 0
8 | 0 |  | 0
9 | 0 |  | 0
Spreadsheet: 804391d1668037293-formula-for-printing-all-sheets-xcvbtr10
Sheet: 14

 |  | [NAME])  YA MSHIRIKA T.A.G HERMON REVIVAL CHURCH |  |  |  |  |  |  |  |  | MWAKA
 |  | JINA KAMILI | WEEKS | JAN | FEB | [NAME] | APRIL | MAY | [NAME] | JULY | AUGU | SEPT | OKT | NOV | DEC | JUMLA
 |  | HT10 | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | JUMLA
Spreadsheet: 587446d1535032940-find-most-common-with-based-on-quantity-excel-test-aug23
Sheet: Blad1

 |  |  |  |  |  |  | I WANT TO SEE FOLLOWING RESULT
 |  |  |  |  |  |  | LIST IN ALFABETICAL ORDER
NAME |  |  | WTG |  |  |  | NAME | nr of times in the list | Sum of WTG
ALFA |  |  | 4 |  |  |  | ALFA | 3 | 83
BETA |  |  | 4 |  |  |  | BETA | 1 | 4
ALFA |  |  | 56 |  |  |  | DOKTOR | 1 | 58
ALFA |  |  | 23 |  |  |  | FRANK | 2 | 80
FRANK |  |  | 78 |  |  |  | GUSTO | 2 | 37
GUSTO |  |  | 12 |  |  |  | PASTA | 2 | 83
PESTO |  |  | 54 |  |  |  | PESTO | 2 | 77
PESTO |  |  | 23
DOKTOR |  |  | 58
PASTA |  |  | 49
PASTA |  |  | 34
FRANK |  |  | 2 |  |  |  | I WANT TO SEE FOLLOWING RESULT
GUSTO |  |  | 25 |  |  |  | WHO HAS MOST WTG
 |  |  |  |  |  |  | NAME | Most WTG | nr times in the list
 |  |  |  |  |  |  | ALFA | 83 | 3
 |  |  |  |  |  |  | PASTA | 83 | 2
 |  |  |  |  |  |  | FRANK | 80 | 2
 |  |  |  |  |  |  | PESTO | 77 | 2
 |  |  |  |  |  |  | DOKTOR | 58 | 1
 |  |  |  |  |  |  | GUSTO | 37 | 2
 |  |  |  |  |  |  | BETA | 4 | 1
Spreadsheet: 137313d1327058179-removal-of-duplicate-data-and-show-those-rows-who-has-maximum-score-in-dupliate-rows-test_meetvivek72
Sheet: Sheet1

 | Query is: | Query 1 | Query 2 | Score |  |  | Query 1 | Query 2 | Score
 |  | Confidence_0.118_Length_701 | Mack | 650 | 2 |  | Confidence_0.118_Length_701 | Mack | 650
 |  | Confidence_0.118_Length_701 | [NAME] | 542 | 3 |  | Confidence_0.118_Length_701 | [NAME] | 542
 |  | Confidence_0.118_Length_701 | Sumith | 563 | 4 |  | Confidence_0.118_Length_701 | Sumith | 563
 |  | Confidence_0.176_Length_582 | [NAME] | 421 | 5 |  | Confidence_0.176_Length_582 | [NAME] | 421
 |  | Confidence_0.176_Length_582 | Mack | 485 |  |  | Confidence_0.176_Length_582 | Whisky | 362
 |  | Confidence_0.176_Length_582 | [NAME] | 251
 |  | Confidence_0.176_Length_582 | Whisky | 362 | 8
Spreadsheet: 122649d1317045923-i-need-to-return-the-min-value-among-many-on-a-range-of-cells-seoer
Sheet: Sheet1

abc | def | 11
hhh | ffff | 20
abc | def | 22
hhh | abc | 99
hhh | ffff | 1333
abc | def | 10
 |  |  |  |  |  | 20110912^Shop1^pear
2011-09-19 00:00:00 | Shop1 | pear | 13
2011-09-14 00:00:00 | Shop2 | banana | 15
2011-09-16 00:00:00 | Shop2 | kiwi | 15
2011-09-08 00:00:00 | Shop2 | pear | 16
2011-09-12 00:00:00 | Shop1 | pear | 16
2011-09-12 00:00:00 | Shop1 | pear | 5
Spreadsheet: 373972d1422617374-conditional-formatting-begins-with-certain-number-cf-rules
Sheet: Summary

 |  |  |  | T Accounts Total (Sum Last Row) |  |  |  |  |  |  | "Check" T Accounts (Sum Product Line Items) |  |  |  |  | Data Sheet | Check Data1 |  |  | Data 2 Sheet | Data 2 Sheet |  | Data 2 Sheet | Data 2 Sheet |  |  | Data Sheet 3 | Check Data3 |  |  | Total | Week 5 | Period Balance |  | Week 7 | Settlement Balance
 |  | GL | GL Count | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] |  | Check Total | Check Data1 |  |  | Check Db | s/b Zero |  | [NAME] | s/b Zero |  |  | Check Total | Check Data3
 |  | 213000 | 36 | 3354453.97 | 115.64 | 0 | 0 | 0 | 0 |  | 3354453.97 | 115.64 | 0 | 0 |  | 3354338.33 | 0 |  |  | 0 | 0 |  | 0 | 0 |  |  | 0 | 0 |  |  | 3354338.33 | -2912138.3 | 442200.0299999998 |  | -442200.0099999999 | 0.01999999990221113
 |  | 672000 | 2 | 0 | 3770301.73 | 0 | 0 | 0 | 0 |  | 0 | 3770301.73 | 0 | 0 |  | -3770301.73 | 0 |  |  | 0 | 0 |  | 0 | 0 |  |  | 0 | 0 |  |  | -3770301.73 | 2912138.3 | -858163.4300000002 |  | 858522.5400000002 | 359.109999999986
 |  | 500000 | 545 | 5132897.29 | 8392265.93 | 0 | 0 | 0 | 0 |  | 5132897.29 | 8392265.93 | 0 | 0 |  | -3259368.639999999 | 0 |  |  | 0 | 0 |  | 0 | 0 |  |  | 0 | 0 |  |  | -3259368.64 | 8763.67 | -3250604.97 |  | 0 | -3250604.97
Spreadsheet: 142048d1329602128-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fantasy-golf
Sheet: Zurich Classic

 |  | Week 4 Zurich New Orleans
 |  | Total Earnings |  |  |  | Rankings Through Week 4 | Total
 | [NAME] | 0 |  | 1 |  | [NAME] | 0
 | [NAME] | 0 |  | 2 |  | [NAME] | 0
 | [NAME] | 0 |  | 3 |  | [NAME] | 0
 | Player 4 | 0 |  | 4 |  | Player 4 | 0
 | Player 5 | 0 |  | 5 |  | Player 5 | 0
 | Player 6 | 0 |  | 6 |  | Player 6 | 0
 | Player 7 | 0 |  | 7 |  | Player 7 | 0
 | Player 8 | 0 |  | 8 |  | Player 8 | 0
 | Player 9 | 0 |  | 9 |  | Player 9 | 0
 | Player 10 | 0 |  | 10 |  | Player 10 | 0
 | Player 11 | 0 |  | 11 |  | Player 11 | 0
 | Player 12 | 0 |  | 12 |  | Player 12 | 0
 | Player 13 | 0 |  | 13 |  | Player 13 | 0
[NAME] |  | [NAME] |  | YTD
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
[NAME]
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
[NAME]
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 4
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 5
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 6
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 7
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 8
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 9
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 10
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 11
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 12
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 13
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0