tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 113416d1309337275-assigning-a-monetary-value-to-a-drop-down-list-charge
Sheet: Sheet1

Department | Charge Out | Ref Number |  |  |  |  |  |  | Branches |  | Yes
Amanzimtoti (Galleria) | Yes | 9874 |  |  |  |  |  |  | Albertinia |  | No
Amanzimtoti (Galleria) | No | 9878 |  |  |  |  |  |  | [NAME]
Amanzimtoti (Galleria) | Yes | 9810 |  |  |  |  |  |  | Alkantrant
 |  |  |  |  |  |  |  |  | Amanzimtoti (Galleria)
 |  |  |  |  |  |  |  |  | Andries Street, Pretoria
 |  |  |  |  |  |  |  |  | Arcadia
 |  |  |  |  |  |  |  |  | Argyle Road
 |  |  |  |  |  |  |  |  | Ashton
 |  |  |  |  |  |  |  |  | Asiatic Bazaar
 |  |  |  |  |  |  |  |  | Athlone
 |  |  |  |  |  |  |  |  | Atlantis
 |  |  |  |  |  |  |  |  | Atteridgeville
 |  |  |  |  |  |  |  |  | Balfour
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Ba-Phalaborwa
 |  |  |  |  |  |  |  |  | Barberton
 |  |  |  |  |  |  |  |  | Barrydale
 |  |  |  |  |  |  |  |  | Beacon Bay
 |  |  |  |  |  |  |  |  | Beaufort West
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Belfast
 |  |  |  |  |  |  |  |  | Belhar
[NAME]
Number | Department | Amount | Ref No
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 484403d1476263955-fill-the-form-in-sheet3-using-data-from-sheet1-school-reports
Sheet: Sheet2

School Name | Large Bus |  | Small Bus |  | Total
 | Single Trip | Double Trips | Single Trip | Double Trips
[NAME]
Hilal
Shoae
Sosan
Taqwa
Yahar
Adal
AlJood
Beda
[NAME]
Maqaam
Remah
[NAME]
Shakboot
[NAME]
Tariq
Alya
Ghaith
Mabadi
[NAME]
[NAME]
Sariya
Shaikha
Talia
Spreadsheet: 478989d1473174271-regarding-pulling-out-the-top-five-most-common-numbers-in-a-block-of-numbers-return-most-common-2nd-3rd-number-from-a-2d-range
Sheet: Sheet1

9 | 8 | 13 | 8 | 15 | 6 | 9 | 8 | 10 | 7 | 10 |  | Nth | Number
7 | 12 | 10 | 13 | 3 | 7 | 6 | 12 | 13 | 4 | 10 |  | 1
4 | 6 | 6 | 3 | 9 | 4 | 14 | 6 | 6 | 14 | 3 |  | 2
15 | 14 | 12 | 6 | 3 | 9 | 4 | 7 | 10 | 7 | 12 |  | 3
9 | 15 | 7 | 13 | 8 | 9 | 2 | 15 | 8 | 8 | 11 |  | 4
2 | 5 | 12 | 10 | 7 | 14 | 2 | 1 | 8 | 3 | 3 |  | 5
13 | 15 | 11 | 1 | 6 | 12 | 9 | 10 | 1 | 10 | 3 |  | 6
3 | 15 | 6 | 5 | 9 | 6 | 8 | 13 | 2 | 10 | 8 |  | 7
6 | 4 | 9 | 14 | 6 | 10 | 3 | 8 | 4 | 2 | 5 |  | 8
1 | 7 | 11 | 5 | 11 | 2 | 1 | 12 | 2 | 1 | 11 |  | 9
5 | 8 | 9 | 5 | 15 | 7 | 5 | 7 | 1 | 11 | 11 |  | 10
9 | 13 | 12 | 12 | 8 | 13 | 9 | 7 | 6 | 8 | 4 |  | etc
9 | 5 | 8 | 1 | 1 | 6 | 5 | 6 | 10 | 7 | 13
10 | 6 | 14 | 10 | 11 | 2 | 13 | 13 | 14 | 14 | 4
10 | 10 | 14 | 3 | 6 | 3 | 6 | 4 | 8 | 15 | 9
2 | 2 | 6 | 5 | 14 | 9 | 11 | 3 | 10 | 3 | 10
12 | 10 | 14 | 1 | 8 | 6 | 7 | 10 | 5 | 4 | 9
5 | 9 | 10 | 4 | 2 | 3 | 2 | 8 | 4 | 3 | 11
4 | 4 | 10 | 8 | 4 | 14 | 9 | 14 | 14 | 12 | 6
10 | 7 | 7 | 14 | 2 | 3 | 15 | 12 | 10 | 11 | 8
Spreadsheet: 778872d1651408760-number-the-repeated-empolyee-based-on-their-id-count-duplicates-aligw
Sheet: DataEntry

S/No | Date | Employee ID | Department | Cabinet | User Name | Count |  | Expected Result
1 | 2022-04-27 00:00:00 | 11111 | Finance | N-A | FN-Jame |  |  | 1
2 | 2022-04-27 00:00:00 | 11151 | Finance | N-B | FN-Jean
3 | 2022-04-27 00:00:00 | 11122 | Production | N-A | PD-Ali
4 | 2022-04-27 00:00:00 | 11115 | Store | N-B | ST-KokZheng
5 | 2022-04-27 00:00:00 | 11133 | HR | N-A | HR-Alex
6 | 2022-04-27 00:00:00 | 11355 | Production | N-B | PD-Ng
7 | 2022-04-27 00:00:00 | 11155 | Production | N-C | PD-Leo |  |  | 1
8 | 2022-04-27 00:00:00 | 11111 | Finance | N-D | FN-Jame |  |  | 2
9 | 2022-04-30 00:00:00 | 11111 | Finance | N-B | FN-Jame |  |  | 3
10 | 2022-04-30 00:00:00 | 11155 | Production | N-C | PD-Leo |  |  | 2
11 | 2022-05-01 00:00:00 | 11155 | Production | N-A | PD-Leo |  |  | 3
Spreadsheet: 469473d1467929898-help-with-drop-down-employee-training-tracker-2
Sheet: Course List

 |  | COURSE LIST
 |  | TITLE | INSTRUCTOR | [NAME] | HOURS
 |  | New Hire | [NAME] | A basic course introduction to new employees.  Defines departmental objectives and expectations. Basic employee operations, covering the employee handbook. | 1
 |  | Counseling Services – 1987 | [NAME] | Basic account procedures and guidelines | 1
 |  | Klingspor – 276 | [NAME] | Basic account procedures and guidelines | 1
 |  | Rik's Corvette Parts – 165 | [NAME] | Basic account procedures and guidelines | 1
 |  | AC Filter Smart – 133 | [NAME] | Basic account procedures and guidelines | 2
 |  | Protect Plus – 2024 | [NAME] | Basic account procedures and guidelines | 1
 |  | [NAME] – 1112 | [NAME] | Basic account procedures and guidelines | 1
 |  | CHTL – 264 | [NAME] | Basic account procedures and guidelines | 1
 |  | Sol's IAQ – 1058 | [NAME] | Basic account procedures and guidelines | 1
 |  | Princeton PC Clinic – 8051 | [NAME] | Basic account procedures and guidelines | 1
 |  | [NAME] – 1054 | [NAME] | Basic account procedures and guidelines | 2
 |  | Fisher – 1982 | [NAME] | Basic account procedures and guidelines | 2
 |  | Bama Clean – 1061 | [NAME] | Basic account procedures and guidelines | 2
 |  | [NAME] | [NAME] | How to be an AOA Lead | 2
 |  | Assistant [NAME] | [NAME] | How to be an AOA Assistant Lead | 2
 |  | [NAME] | [NAME] | How to be an AOA Buddy | 2
 |  | [NAME] | [NAME] | How to be an AOA Trainer | 8
Spreadsheet: 888407d1738884301-create-summary-by-month-for-data-on-multiple-monthly-sheets-mobsync-cust-info
Sheet: Summary

 | 9097
 |  | Current
Maj | Units | $ | Units | $ | Units | $ | Units | $ | Units | $
YO
HK
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 65

कार्यक्रम PROGRAM |  |  | पररखस्थतिजन्य नेिृत्व SITUATIONAL [NAME] (II LINE - RO EXECUTIVES) | PROG CODE
 |  |  |  | IT 1775
तर्षर् समूह/SUBJECT GROUP |  |  | HR, MARKETING, CUSTOMER SERVICE & COMPLIANCE
उद्देश्य/OBJECTIVE |  |  | LEADERSHIP DEVELOPMENT AND THINKING BEYOND VISION
लतक्षि समूह/TARGET GROUP |  |  | 2ND LINE RO EXECUTIVE
अर्तध/DURATION |  |  | 3 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | People Management and Inter-personal Skills
 | II | Business Strategy
 | III | Credit Skills
 | IV | Recovery Management/Recovery Policy
Day 2 | I | Role & Responsibilities, Delegation of power/credit Policy, Important aspect of Branch Visit.
 | II | Compliance & Governance (Preventive vigilance, Frauds including cyber security)
 | III | Situational leadership
 | IV | Important aspects to be covered during branch Visit
Day 3 | I | 360° Customer Relationship (Relationship with Customers, Branches & CO)
 | II | Future Vision of Banking
 | III | Stress Management & Motivation
 | IV | AML/KYC & Compliance, Business Ethics & Valediction
Spreadsheet: 47881d1247057961-look-up-data-in-another-sheet-sheet_1
Sheet: Company 2008

Company [NAME] number | Income 2008 | Tax 2008 | [NAME] | Emloyed
211313213 | 258300 | 258000 | 190600 | 1146
1232131321321 | 20012 | -2901 | -2851 | 0
13213 | 96463 | 10777 | 6970 | 128
3.21321321321321e+18 | 60698 | 24901 | 74065 | 1
3213213213 | 30685 | 3349 | 122 | 15
3213213213 | 100781 | 720 | -271 | 27
9996667788 | 20934 | 5629 | 5053 | 7
8889993456 | 81693 | 44994 | 110468 | 44
9994566446 | 31057 | 1757 | 1285 | 15
 | 33264 | 2758 | 2161 | 8
 | 20434 | -13 | -66 | 9
 | 24033 | 3309 | 496024 | 11
 | 103235 | 6838 | 5888 | 3
 | 574212 | 20882 | 14226 | 140
 | 224318 | 6233 | 4458 | 52
 | 910942 | 45870 | 27613 | 270
 | 321321 | 4845 | 4535 | 566
 | 32391 | 2513 | 1666 | 31
 | 34655 | 767 | 579 | 16
 | 35939 | 2251 | 1862 | 8
 | 30217 | 1962 | 1460 | 15
 | 118341 | 3629 | 1712 | 30
 | 35439 | 1856 | 1415 | 14
 | 449331 | 1657 | -1428 | 40
 | 43504 | 9402 | 6981 | 13
 | 47593 | -5 | 3 | 49
 | 20987 | 9774 | 5151 | #N/A
Spreadsheet: 77038d1277476285-match-three-fields-and-input-into-a-different-cell-sample
Sheet: RPweek

 |  |  | 2010-06-07 00:00:00 | 2010-06-14 00:00:00 | 2010-06-21 00:00:00 | 2010-06-28 00:00:00 | 2010-07-05 00:00:00 | 2010-07-12 00:00:00
Request Number | Description of Project | Employee
146555 | TOAD | [NAME], [NAME]
146555 | TOAD | [NAME], [NAME]
146555 | TOAD | [NAME], [NAME]
152847 | BULLFROG | [NAME], [NAME]
Spreadsheet: mark_taylor__25006__HotDog
Sheet: Sheet1

Actuals | 11329 | 207342 | 690860 | 803 | 2226 |  |  | Diff
 | Goats | Hogs | Cows | Horses | Turkeys | Total |  | Goats | Hogs | Cows | Horses | Turkeys | Total
[NAME] | 34000 | 72000 | 75000 | 15000 | 63000
[NAME] | 9999 | 12502 | 29952 | 572 | 1099
[NAME] | 4652 | 12889 | 16500 | 4283 | 15822
[NAME] | 50000 | 3000000 | 2000000 | 100000 | 2000000
[NAME] | 500 | 250000 | 59000 | 13000 | 300000
[NAME] | 376 | 16800 | 24250 | 210 | 8500
[NAME] | 170000 | 185000 | 106000 | 4400 | 1000000
[NAME] | 8000 | 105000 | 36000 | 1000 | 225000
[NAME] | 125000 | 320000 | 250000 | 25000 | 410000
[NAME] | 1000 | 5000 | 7000 | 15000 | 350000
[NAME] | 50000 | 525000 | 600000 | 25000 | 1000000
[NAME] | 5000 | 500000 | 250000 | 820 | 150000
[NAME] | 25000 | 250000 | 325000 | 0 | 100000
[NAME] | 18000 | 54000 | 252000 | 18000 | 18000
 |  |  |  |  |  |  | Min
 |  |  |  |  |  |  | [NAME]
Spreadsheet: 97bd7366-6be4-473f-b213-2b23320cdf09
Sheet: All You February 2013

All You Coupons January 2013 |  | done [NAME]
Coupon Name | Value | Expiration date
Pam No-Stick Cooking Spray, 6 oz + | $1/1 | 2013-02-03 00:00:00
Aleve Product | $1/1 | 2013-03-31 00:00:00
Arby’s or Checkers Fries | $1/1 | 2013-02-03 00:00:00
[NAME] | $1/1 | 2013-03-31 00:00:00
Dole Fruit Shakers | $.50/1 | 2013-03-31 00:00:00
Egg Beaters Product, 15 oz+ | $1/1 | 2013-02-03 00:00:00
Fleischmann’s Yeast, 4 oz jar | $1/1 | 2013-01-31 00:00:00
[NAME] Super Dieter’s Tea | $1/1 | 2013-02-28 00:00:00
Lean Cuisine Salad Additions | $1/2 | 2013-03-14 00:00:00
Lever 2000 Body Wash or Bar ETS | $1/1 | 2013-01-31 00:00:00
Manwich Sloppy [NAME], 15.5 oz+ | $1/3 | 2013-02-03 00:00:00
Nature Made Product | $2/1 | 2013-03-31 00:00:00
One a Day Multivitamin | $1/1 | 2013-03-31 00:00:00
Quaker Products | $1/2 | 2013-02-28 00:00:00
Soft Scrub Product | $1/1 | 2013-05-31 00:00:00
Suave Product ETS | $.50/2 | 2013-01-26 00:00:00
TruBiotics Dietary Supplement | $1/1 | 2013-03-31 00:00:00
Tylenol Children’s | $1/1 | 2013-02-28 00:00:00
Tyson Any’tizers Snacks | $1/1 | 2013-03-30 00:00:00
Urinozinc Prostate Formula | $2/1 | 2013-06-30 00:00:00
Vaseline Lotion ETS | $1/1 | 2013-01-15 00:00:00
[NAME] [NAME] 3 pk wyb (3) Baked Entrees | Free WYB 3 | 2013-02-03 00:00:00
Jennie-O [NAME] | $1/1 | 2013-04-30 00:00:00
[NAME] [NAME] 50 oz | $2/1 | 2013-02-03 00:00:00
Weight Watchers Cheese or Cream Cheese | $1/1 | 2013-03-14 00:00:00
Woolite Everyday or Darks Laundry Care 50 oz+ | $3/1 | 2013-07-15 00:00:00
List found at FabulesslyFrugal.com
Spreadsheet: 786793d1657449146-conditional-date-formula-test
Sheet: Sheet1

Number | Task type | Priority | Created | Location | Opened by | Assigned to | State | Short description | Updated | Needs attention | Due date | Closed | Closed by | SLA due | Tags | Resolved / Closed | Created Month | Closed Month | Created Week | Closed Week |  | IF |  | THEN, Column Q=
 | Request | 4 - Low | 2022-07-08 15:30:53 |  |  |  | Closed [NAME] |  | 2022-07-08 19:04:32 | False |  | 2022-07-08 19:04:32 |  |  |  |  |  |  |  |  |  | H2= | Closed [NAME] | M2
 | Request | 4 - Low | 2022-07-08 12:58:59 |  |  |  | Work in Progress |  | 2022-07-08 14:04:28 | False |  |  |  |  |  |  |  |  |  |  |  |  | Closed Incomplete | M2
 | Incident | 2 - High | 2022-07-08 12:44:45 |  |  |  | Resolved |  | 2022-07-08 20:03:14 | False |  |  |  |  |  |  |  |  |  |  |  |  | Closed Skipped | M2
 | Incident | 2 - High | 2022-07-08 10:15:18 |  |  |  | On Hold |  | 2022-07-08 17:12:21 | False |  |  |  |  |  |  |  |  |  |  |  |  | Resolved | J2
 | Incident | 2 - High | 2022-07-01 22:29:50 |  |  |  | Closed |  | 2022-07-08 23:00:20 | False |  | 2022-07-08 23:00:20 |  |  |  |  |  |  |  |  |  |  | Closed | M2-7
 | Problem | 3 - Moderate | 2022-06-29 09:57:50 |  |  |  | Root Cause Analysis |  | 2022-06-29 09:59:21 | False |  |  |  |  |  |  |  |  |  |  |  |  | Work in Progress | Blank
 | Request | 4 - Low | 2021-10-11 07:21:30 |  |  |  | Closed Incomplete |  | 2021-10-11 08:00:06 | False |  | 2021-10-11 08:00:06 |  |  |  |  |  |  |  |  |  |  | On Hold | Blank
 | Incident Task | 4 - Low | 2021-09-27 10:39:33 |  |  |  | Closed Skipped |  | 2021-10-10 07:13:17 | False |  | 2021-10-01 07:13:17 |  |  |  |  |  |  |  |  |  |  | Root Cause Analysis | Blank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Although reference fileds are blank, yet date appears. Date should appear only if data is entered in reference cells, if not it should be a blank cell.
Spreadsheet: 163998d1340600827-getting-a-position-number-in-excel-series
Sheet: Sheet1

100 | 200 | 300 | 400 | 500 | 600
700 | 800 | 900 | 45 | 88
23 | 20 | 50 | 55 | 99 | 9
Spreadsheet: 53307d1253199647-points-system-table-standing
Sheet: Sheet4

 | Chelsea | Vs | Fulham
 | 2 |  | 0
Particpants | Chelsea |  | Fulham | Actual Team A | Actual Team B | Correct goals (1) | No Goals (1) | Correct Result (3) | Win Score (3) | Draw Score (3) | Correct Match (5) | Points
[NAME] | 2 |  | 1 | 2 | 0 | 1 |  |  | 3 |  |  | 4
Angiiie | 2 |  | 0 | 2 | 0 | 1 |  | 3 | 3 |  | 5 | 5
Bakchang |  |  |  | 2 | 0
Blue Rascal | 3 |  | 0 | 2 | 0 | 1 |  |  | 3 |  |  | 4
[NAME] (1) | 2 |  | 0 | 2 | 0 | 1 |  | 3 | 3 |  | 5 | 5
[NAME] | 2 |  | 1 | 2 | 0 | 1 |  |  | 3 |  |  | 4
Chelseapaul |  |  |  | 2 | 0
[NAME] | 2 |  | 0 | 2 | 0 | 1 |  | 3 | 3 |  | 5 | 5
[NAME] | 2 |  | 0 | 2 | 0 | 1 |  | 3 | 3 |  | 5 | 5
Double D |  |  |  | 2 | 0
[NAME] | 2 |  | 0 | 2 | 0 | 1 |  | 3 | 3 |  | 5 | 5
Fookwing | 2 |  | 0 | 2 | 0 | 1 |  | 3 | 3 |  | 5 | 5
Harmony2828 | 4 |  | 0 | 2 | 0 | 1 |  |  | 3 |  |  | 4
[NAME] |  |  |  | 2 | 0
[NAME] |  |  |  | 2 | 0
JWNY | 5 |  | 0 | 2 | 0 | 1 |  |  | 3 |  |  | 4
Karthigesh | 3 |  | 0 | 2 | 0 | 1 |  |  | 3 |  |  | 4
[NAME] (1) | 2 |  | 1 | 2 | 0 | 1 |  |  | 3 |  |  | 4
[NAME] (: | 3 |  | 0 | 2 | 0 | 1 |  |  | 3 |  |  | 4
[NAME] | 2 |  | 1 | 2 | 0 | 1 |  |  | 3 |  |  | 4
Lighthouse | 3 |  | 0 | 2 | 0 | 1 |  |  | 3 |  |  | 4
[NAME] |  |  |  | 2 | 0
Monir | 4 |  | 1 | 2 | 0 |  |  |  | 3 |  |  | 3
North Stand | 2 |  | 1 | 2 | 0 | 1 |  |  | 3 |  |  | 4
[NAME] (2) |  |  |  | 2 | 0
[NAME] | 2 |  | 0 |  |  |  |  |  |  |  |  | 5
[NAME] | 3 |  | 0 |  |  |  |  |  |  |  |  | 4
PetrJack | 2 |  | 0 |  |  |  |  |  |  |  |  | 5
Polobear
Ray | 4 |  | 0 |  |  |  |  |  |  |  |  | 4
[NAME] | 2 |  | 0 |  |  |  |  |  |  |  |  | 5
Shevchenko
Shiesse | 2 |  | 0 |  |  |  |  |  |  |  |  | 5
Silent
Singablue | 2 |  | 0 |  |  |  |  |  |  |  |  | 5
Stellazio
Stephen | 2 |  | 1 |  |  |  |  |  |  |  |  | 4
tab
[NAME] (6) | 2 |  | 0 |  |  |  |  |  |  |  |  | 5
The Ridz | 3 |  | 0 |  |  |  |  |  |  |  |  | 4
Uncle gg | 3 |  | 1 |  |  |  |  |  |  |  |  | 3
Zenden | 2 |  | 1 |  |  |  |  |  |  |  |  | 4
Sharlene95
[NAME]
JoeyCole | 2 |  | 1 |  |  |  |  |  |  |  |  | 4
[NAME] | 2 |  | 1 |  |  |  |  |  |  |  |  | 4
SoccerMusic | 2 |  | 0 |  |  |  |  |  |  |  |  | 5
Voodoo | 2 |  | 0 |  |  |  |  |  |  |  |  | 5
Spreadsheet: 116370d1311784993-if-then-help-2011-day-ride-saddle-and-paddle-summary
Sheet: Saddle & Paddle 2011

SADDLE & PADDLE 2011
DATE | Party Name | # of Riders |  | $ Adults |  | $ Kids |  | Total Amt. | Pd Cash | Pd Charge | Bkd By | Chg By | ABO | YRC | pay ABO | pay YRC |  |  |  |  | How Heard | First Name | Last Name | Address | City | Sate | Zip | phone # | email | Notes
 |  | Adult | Child | ABO | YRC | ABO | YRC
 |  |  |  | 50 | 35 | 50 | 25
2011-06-02 00:00:00 | Shooter | 2 | 2 |  |  |  |  |  |  | 0 | YRC | YRC |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Shooter
2011-06-03 00:00:00 | Buckley | 4 | 0 |  |  |  |  |  | 340 |  | ABO | ABO |  |  |  |  |  |  |  |  | Web | [NAME] | Buckley
2011-06-06 00:00:00 | Noterajan | 3 | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Anad | Naterajan
2011-06-14 00:00:00 | Mancilo | 1 | 1 |  |  |  |  |  | 0 | 160 |  |  |  |  |  |  |  |  |  |  | YRC | Mauvilie | Mancilo
2011-06-21 00:00:00 | Murphy | 4 | 0 |  |  |  |  |  |  | 340 | ABO | ABO |  |  |  |  |  |  |  |  | Web | [NAME] | Murphy
2011-06-23 00:00:00 | Blair | 2 | 0 |  |  |  |  |  |  |  | YRC | YRC |  |  |  |  |  |  |  |  | YRC | [NAME] | Blair
2011-06-24 00:00:00 | Daniels | 2 | 0 |  |  |  |  |  |  |  | YRC | YRC |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Daniels
2011-06-26 00:00:00 | Choi | 4 | 0 |  |  |  |  |  |  |  | YRC | YRC |  |  |  |  |  |  |  |  | [NAME] | Sup | Choi
2011-06-26 00:00:00 | MacDonald | 2 | 2 |  |  |  |  |  |  |  | YRC | YRC |  |  |  |  |  |  |  |  | YRC | Garry | MacDonald
2011-06-26 00:00:00 | Berberich | 2 | 0 |  |  |  |  |  |  |  | YRC | YRC |  |  |  |  |  |  |  |  | YRC | [NAME] | Berberich
2011-06-26 00:00:00 | Ohlson | 2 |  |  |  |  |  |  |  |  | ABO | YRC |  |  |  |  |  |  |  |  | [NAME] | Martin & Andrew | Ohlson
2011-06-27 00:00:00 | Maita | 2 | 2 |  |  |  |  |  |  | 320 | YRC | ABO |  |  |  |  |  |  |  |  | YRC | [NAME] | Maita
2011-06-28 00:00:00 | Sinn | 3 | 1 |  |  |  |  |  |  | 330 | YRC | ABO |  |  |  |  |  |  |  |  | [NAME] | Cory | Sinn
2011-06-29 00:00:00 | [NAME] | 2 |  |  |  |  |  |  |  | 170 | YRC | ABO |  |  |  |  |  |  |  |  | YRC | [NAME] | [NAME]
2011-06-29 00:00:00 | Stratmann | 2 | 0 |  |  |  |  |  |  |  | ABO | ABO |  |  |  |  |  |  |  |  | RV Park | [NAME] | Stratmann
2011-06-29 00:00:00 | [NAME] | 3 | 2 |  |  |  |  |  |  |  | ABO | ABO |  |  |  |  |  |  |  |  | [NAME] | Michelle | [NAME]
2011-06-30 00:00:00 | [NAME] | 4 | 1 |  |  |  |  |  |  | 415 | ABO | ABO |  |  |  |  |  |  |  |  | Web | [NAME] | [NAME]
2011-06-30 00:00:00 | Thacher | 2 |  |  |  |  |  |  |  |  | YRC | ABO |  |  |  |  |  |  |  |  | YRC | [NAME] | Thacher
Spreadsheet: a6276a24-1183-42eb-b236-7418469ebcf6
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6146 | 30442 | Lynette | [NAME] | RSA | 149 | 00:21:40 | [NAME] | 01:10:41 | 00:00:45 | 00:48:22 | 1 | 02:22:05
6146 | 12805 | Tayla | Glover | RSA | 150 | 00:20:49 | 00:00:28 | 01:16:25 | 00:00:43 | 00:45:51 | 2 | 02:24:18
6146 | 20872 | Heide-Mari | Meiring | RSA | 148 | 00:26:19 | 00:00:31 | 01:12:57 | 00:00:41 | 00:45:28 | 3 | 02:25:56
6146 | 42147 | Nelmare | Loubser | RSA | 151 | [NAME] | 00:00:52 | 01:21:53 | 00:00:34 | 00:46:18 | 4 | 02:31:06
Spreadsheet: 849752d1700150971-sorting-data-and-labelling-data-and-preserving-the-labelling-for-other-data-sets-sorting-data-and-labelling-data-and-preserving-the-labelling-for-other-data-sets-for-upload
Sheet: Selection of DATA

 | [NAME]: = UNIQUE(DATA!C2:G12) |  |  |  |  |  | Requested outcome
 |  |  |  |  |  |  | Copy & Paste the five columns manually below each other |  |  | Copy and paste column H to column K and then apply ("Remove all duplicates")
 |  | An apparatus | A metrology tool | A lithographic apparatus | A litho cell |  | An apparatus |  |  | An apparatus
 | A reticle stage | A lithographic apparatus | A lithographic system | A method of operating an EUV lithographic apparatus |  |  | A reticle stage |  |  | A reticle stage
 | A method for improving a nuisance rate | A system | A non-transitory computer readable medium storing … | [NAME] | [NAME] |  | A method for improving a nuisance rate in image inspection data |  |  | A method for improving a nuisance rate
 | A height measurement sensor | A lithographic apparatus | An assessment system | A metrology system | A method for determining a focus plane |  | A height measurement sensor |  |  | A height measurement sensor
 | A method for cleaning | A system | A system | Klaasje |  |  | A method for cleaning |  |  | A method for cleaning
 | A membrane | A membrane | A pellicle | A patterning device and pellicle assembly | A lithographic apparatus |  | A membrane |  |  | A membrane
 |  |  |  |  |  |  | A charge regulator |  |  | A charge regulator
 |  |  |  |  |  |  | A charged particle-optical device |  |  | A charged particle-optical device
 |  |  |  |  |  |  | An apparatus |  |  | An apparatus
 | Question: HOW to remove all the duplicates from cells B3:[NAME]? |  |  |  |  |  | A lithographic apparatus |  |  | A lithographic apparatus
 |  |  |  |  |  |  | A system |  |  | A system
 |  |  |  |  |  |  | A lithographic apparatus
 |  |  |  |  |  |  | A system |  |  | A metrology tool
 |  |  |  |  |  |  | A membrane |  |  | A lithographic system
 |  |  |  |  |  |  |  |  |  | A non-transitory computer readable medium storing …
 |  |  |  |  |  |  |  |  |  | An assessment system
 |  |  |  |  |  |  | A metrology tool |  |  | A pellicle
 |  |  |  |  |  |  | A lithographic system |  |  | 0
 |  |  |  |  |  |  | A non-transitory computer readable medium storing … |  |  | A method of operating an EUV lithographic apparatus
 |  |  |  |  |  |  | An assessment system |  |  | A metrology system
 |  |  |  |  |  |  | A system |  |  | A patterning device and pellicle assembly
 |  |  |  |  |  |  | A pellicle |  |  | A litho cell
 |  |  |  |  |  |  |  |  |  | A method for determining a focus plane
 |  |  |  |  |  |  | 0 |  |  | A lithographic apparatus
 |  |  |  |  |  |  | A lithographic apparatus
 |  |  |  |  |  |  | A method of operating an EUV lithographic apparatus
 |  |  |  |  |  |  | A metrology system
 |  |  |  |  |  |  | A patterning device and pellicle assembly
 |  |  |  |  |  |  | A litho cell
 |  |  |  |  |  |  | A method for determining a focus plane
 |  |  |  |  |  |  | A lithographic apparatus
 |  |  |  |  |  |  | 0
Spreadsheet: 27588d1220971240-compiling-data-entered-in-rows-and-columns-help
Sheet: Sheet1

 | What I have: |  |  | <AutoFilter |  | What I want
 | (data I need is bolded, the rest is of no use)
 | Min | [NAME] | Average |  |  | Cylcle | Min | [NAME] | Average
 | 1155.45849609375 | 1407.96533203125 | 1211.82345556641 |  |  | 1000 | 1155.45849609375 | 1407.96533203125 | 1211.82345556641
# of Cycles | 1000 |  |  |  |  | 2000 | 1010.02734375 | 1560.32177734375 | 1201.18034570313
 | 334.265625 |  |  |  |  | 3000 | 1134.6826171875 | 1453.77880859375 | 1197.72728808594
 | 2147483647 |  |  |  |  | 4000 | 997.77490234375 | 1592.8173828125 | 1199.76652050781
 |  |  |  |  |  | 5000 | 1101.654296875 | 1661.0048828125 | 1201.23947705078
 |  |  |  |  |  | 6000 | 1136.28076171875 | 1242.291015625 | 1199.54064941406
 | 1010.02734375 | 1560.32177734375 | 1201.18034570313 |  |  | etc.
 | 2000
 | 661.359375
 | 2147483647
 | 1134.6826171875 | 1453.77880859375 | 1197.72728808594
 | 3000
 | 995.84375
 | 2147483647
 | 997.77490234375 | 1592.8173828125 | 1199.76652050781
 | 4000
 | 1340.40625
 | 2147483647
 | 1101.654296875 | 1661.0048828125 | 1201.23947705078
 | 5000
 | 1689
 | 2147483647
 | 1136.28076171875 | 1242.291015625 | 1199.54064941406
 | 6000
 | 2029.125
 | 2147483647
 | etc.
Spreadsheet: brad_mckay__1421__Report Samples
Sheet: Report 1

 | Summary of EOL Trades
Report 1 | Summary For Each Product | Start Date | 2000-11-01 00:00:00 | WA Prices = (Sum of (Buy vol*Buy price) for customer)/ Total Buy Volume
 | US Gas Basis CNG APP  Jan-Mar01 USD/MM | End Date | 2000-11-21 00:00:00 | WA Prices = (Sum of (sell vol*sell price) for customer)/ Total Sell Volume
 | Customer | ENA Sale Volume | [NAME] | Net Position | ENA WA Buy Price | ENA WA Sale Price
 | AEP Energy Services, Inc. | -15000 | 10000 |  | -0.45375 | 0.4591666666666667
 | BNP Paribas | -5000 | 10000 |  | -0.49 | 0.42
 | BP Amoco Corporation | -35000 | 5000 |  | -0.51 | 0.45
 | El Paso Merchant Energy - Gas, L.P. | -10000 | 15000 |  | -0.37 | 0.45
 | Engage Energy Canada L.P.
 | Enron Energy Services, Inc.
 | Koch Energy Trading, Inc.
 | Reliant Energy Services, Inc.
 | Select Energy, Inc.
 | Sempra Energy Trading Corp.
 | Southern Company Energy Marketing, L.P.
 | Texaco Natural Gas Inc.
 | Tractebel Energy Marketing, Inc.
 | Utilicorp United Inc.
 | Williams Energy Marketing & Trading Company
Report 2
Spreadsheet: 811968d1672897528-conditional-format-with-conditons-checking-multiple-columns-for-matches-and-conditional-format
Sheet: Sheet1

ID | Code | Value 1 | Value 2 |  |  |  | explanation column
1177 | 2022-102 | 1 |  |  | 1177
1178 | 2022-103 | 1 |  |  | 1178
1179 | 2022-104 | 1 |  |  | 1179
1180 | 2022-106 |  | 75 |  | 1180
1180 | 2022-PZ-07 | 336 |  |  | 1181
1181 | 2022-114 |  | 8 |  | 1182
1182 | 2022-116 | 150 |  |  | 1183
1183 | 2022-117 |  | 15 |  | 1184
1184 | 2022-118 | 270 |  |  | 1185
1184 | 2022-PZ-12 | 240 |  |  | 1186
1185 | 2022-119 | 112 | 135 |  | 1187
1186 | 2022-120 | 30
1187 | 2022-124 | 210