tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 859387d1707791199-recursive-lambda-samplefile
Sheet: Sheet1

MGRNAME | MGRID | EENAME | EEID | HLVL
[NAME] | 123 | [NAME] | 134 | 1 |  |  | Direct | Indirect
[NAME] | 123 | [NAME] | 145 | 1 |  | [NAME] | 4 | 24
[NAME] | 123 | [NAME] | 198 | 1 |  | [NAME] | 3 | 5
[NAME] | 123 | [NAME] | 156 | 1 |  | [NAME] | 3 | 13
[NAME] | 134 | [NAME] | 456 | 2 |  | [NAME] | 5 | 8
[NAME] | 134 | [NAME] | 845 | 2 |  | [NAME] | 5 | 0
[NAME] | 134 | [NAME] | 334 | 2 |  | Missy Rower | 8 | 0
[NAME] | 145 | [NAME] | 688 | 2
[NAME] | 145 | [NAME] | 543 | 2
[NAME] | 145 | [NAME] | 789 | 2
[NAME] | 543 | [NAME] | 877 | 3
[NAME] | 543 | [NAME] | 455 | 3
[NAME] | 543 | [NAME] | 322 | 3
[NAME] | 543 | Missy Rower | 111 | 3
[NAME] | 543 | [NAME] | 226 | 3
[NAME] | 456 | Carm Gower | 833 | 3
[NAME] | 456 | [NAME] | 412 | 3
[NAME] | 456 | [NAME] | 288 | 3
[NAME] | 456 | [NAME] | 999 | 3
[NAME] | 456 | [NAME] | 733 | 3
Missy Rower | 111 | [NAME] | 311 | 4
Missy Rower | 111 | [NAME] | 855 | 4
Missy Rower | 111 | [NAME] | 357 | 4
Missy Rower | 111 | [NAME] | 880 | 4
Missy Rower | 111 | [NAME] | 343 | 4
Missy Rower | 111 | [NAME] | 661 | 4
Missy Rower | 111 | [NAME] | 222 | 4
Missy Rower | 111 | [NAME] | 187 | 4
Spreadsheet: 217348d1362049739-hyperlinking-or-producing-tables-staff-requirements-test
Sheet: Matrix

Week Commencing: |  |  |  |  |  |  |  |  | Week Commencing: |  |  | 2013-02-25 00:00:00
Today:
 |  | Mon | Tue | Wed | Thur | Fri |  |  |  |  | Mon | Tue | Wed | Thur | Fri
 |  | 2013-02-25 00:00:00
1 - RV53B | Maximum Staff Requirement |  |  |  |  |  |  |  | 1 - RV53B | Maximum Staff Requirement
2 - RV74 | Maximum Staff Requirement |  |  |  |  |  |  |  | 2 - RV74 | Maximum Staff Requirement
3 - RV53 | Maximum Staff Requirement |  |  |  |  |  |  |  | 3 - RV53 | Maximum Staff Requirement
4 - RDKP72 | Maximum Staff Requirement |  |  |  |  |  |  |  | 4 - RDKP72 | Maximum Staff Requirement
5 - KIEFEL | Maximum Staff Requirement |  |  |  |  |  |  |  | 5 - KIEFEL | Maximum Staff Requirement
6 - RDKP72 | Maximum Staff Requirement |  |  |  |  |  |  |  | 6 - RDKP72 | Maximum Staff Requirement
7 - RDKP54 | Maximum Staff Requirement |  |  |  |  |  |  |  | 7 - RDKP54 | Maximum Staff Requirement
 |  | Tool | Order Reference | Start Date | End Date | Staff
Spreadsheet: 158849d1338407638-sort-list-removing-certain-values-formula-excludelist-1-
Sheet: Sheet1

No blanks mixed in with data:
Full List | Exclude List |  | Sorted List |  | Full List |  |  | Sorted List
Dog | Rat |  | Dog
Cow | Cow |  | Cat
Cat | Bear |  | Bird
Bird |  |  | Horse
Horse |  |  | Zebra
Zebra |  |  | Goat
Bear
Goat
Rat
Blanks mixed in with data:
Full List | Exclude List |  | Sorted List
Dog | Rat |  | Dog
 | Cow |  | Cat
Cow | Bear |  | Bird
Cat |  |  | Horse
Bird |  |  | Zebra
 |  |  | Goat
Horse
Zebra
Bear
Goat
Rat
Spreadsheet: d5cecd03-58c5-4248-b4b5-1ddbb6b5fff0
Sheet: Pg5

Permit No.: |  |  | WQ0023693 |  |  | Facility Name: |  | West Brunswick Regional WWTF |  |  |  |  |  | County: | Brunswick |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 17 (PGM 15) |  | Field Name: |  | 18 (PGM 18) |  | Field Name: |  | 1A |  | Field Name: |  | 1B
 |  |  |  |  |  | Area (acres): |  | 6.69 |  | Area (acres): |  | 10.56 |  | Area (acres): |  | 3.29 |  | Area (acres): |  | 1.19
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.2 |  | [NAME] (in): |  | 0.2 |  | [NAME] (in): |  | 0.2
 |  |  |  |  |  | Annual Rate (in): |  | 156 |  | Annual Rate (in): |  | 36.4 |  | Annual Rate (in): |  | 83.2 |  | Annual Rate (in): |  | 41.6
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 43888d1242515635-excel-2007-calculate-commissions-commissions
Sheet: Sheet7

Salespersons Total | Comm Paid | % of Total Comm
11764 | 705.8399999999999 | 0.06
14638 | 1171.04 | 0.08
14914 | 1193.12 | 0.08
10649 | 638.9399999999999 | 0.06
13455 | 1076.4 | 0.08
65420 | 5233.6 | 0.08
 | Commission
 | Over | 12000 | 0.08
 | Under | 12000 | 0.06
Spreadsheet: daren_farmer__5546__HPL-Nov
Sheet: Nov 00

 |  | Reliant Energy - Entex
 |  | Enron Capital &  Trade/Houston Pipe Line
 |  | MONTHLY NOMINATION SUMMARY
 |  |  | From |  | Month to Date
Gas Flow Day |  | [NAME]. | 2000-11-01 00:00:00
Houston Pipe Line
982000 |  | HPL  Points | 75000
981326 | Industrial Tier 1 & 2 | Enterprise | 5000
981195 | Industrial Tier 1 & 2 | Huntsman East | 4000
981279, 981280, 981293 | Lufkin/Diboll- Temple Inland
980073 | Huntv,Woodls,[NAME]
Total HPL
Midcon |  |  | 25000
Total  Midcon
NGPL Spring City Gate |  |  | 1000
Total  NGPL
PAYBACK |  |  | 0
Total Available
Allocated as Follows:
Residential
012-41991-301 | 91% Domestic | HPL 76 | 910
016-41991-301 | Transactions 2-5,7 | ECT Trans # 1
016-41991-313 | Contract terminated 07/31/00 | NGMS 308 | 0
016-41991-306 | Trans 6- Silsbee |  | 250
016-41991-301 | Trans 10 [NAME]. | Lufkin Diboll | 0
 | Subtotal
016-41991-301 | Transaction 1 - Overflow | ECT Trans # 1
Total Residential
Industrial
012-41991-301 | 9% Industrial | HPL 76 | 90
016-41991-311 | Terminated 12/31/99 | CNG | 0
016-41991-306 | Trans 6 -Tier 1 - Entex | Tier 1 | 21000
016-91000-303 | Trans 6 -Tier 1 - Unit | Tier 1
016-41991-306 | Trans 6 -Tier 2 - Entex | [NAME] | 7000
016-91000-303 | Trans 6 - Tier 2  - Unit | [NAME] | 500
016-41991-306 | VA Hospital - Terminated 07/31/00 | VA Hosp | 0
Total Industrial at meter 2000
016-91000-301 | existing | NSS/Vidor | 4000
016-41991-306 | [NAME]. | Lufkin Diboll | 8000
016-41991-312 | [NAME]. | Temple Inland | 2800
Total Industrial not at meter 2000
Total Industrial
Huntsville/Woodlands/Conroe
016-41991-301 | Trans 6 -Huntsville |  | 500
016-41991-301 | Trans 9 -Woodlands |  | 2000
016-41991-301 | Trans 8 - Conroe |  | 0
Total H/W/C
Transportation
012-41991-204 |  | IT | 0
012-41991-203 |  | Firm Trsp | 10000
Total Transportation
Total Allocated
Check Available = Allocated
Transport Receipts |  | [NAME]
012-41991-204 | TEJAS THOMPSONVILLE From PanCanadian | 6351 | 10000
012-41991-203 | TEJAS THOMPSONVILLE | 6351 | 5000
012-41991-203 | TEJAS THOMPSONVILLE | 6351 | 10000
Spreadsheet: sara_shackleton__36588__counterparties1
Sheet: Recovered

EIM Forest Products Trading Business
Recovered Products
Top 10 Financial Trading Counterparties
 |  | % Total |  | Credit
Description of Counterparty |  | [NAME] |  | Rating
Large Waste Services Provider |  | 0.3692096901722206 |  | Ba2/BBB
Forest Products Company |  | 0.0753497235792424 |  | BBB3
Solid Waste Services Company |  | 0.05933049100727748 |  | B2/BB-
 |  | 0.05766923725907371 |  | WR/D
Packaging Supply Company |  | 0.05320224459113579 |  | N/A
Manufacturer of Recycled Products |  | 0.03915812406480314 |  | NR
Building & Construction Products Co. |  | 0.03559829460436649 |  | NR
Paperboard & Pkg. [NAME] |  | 0.03263177005400261 |  | Ba2/BB
Packaging Company |  | 0.03203846514392984 |  | NR
Large Consumer Products Company |  | 0.02135897676261989 |  | Baa1/A-
Total
Spreadsheet: 88925d1288729468-excel-scheduling-tool-help-total-scheduled-hours-calendar
Sheet: Sheet1

 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
[NAME] | 18:00:00 |  | 07:00:00 | 12:00:00 | 09:00:00 |  | 11:00:00 |  | off | off | off | off | 10:00:00 | 17:00:00
Split | 02:00:00 |  | 08:45:00 | 18:00:00 | 18:00:00 |  | 19:00:00 |  |  |  |  |  | 15:00:00 | 19:45:00 | Total
Spreadsheet: 96836d1296114058-scrolling-charts-chart
Sheet: Sheet2

 |  |  |  |  | A | 22
 |  |  |  |  | B | 33
 |  |  |  |  | C | 44
 |  |  |  |  | D | 55
 |  |  |  |  | E | 66
 |  |  |  |  | F | 77
 |  |  |  |  | G | 88
 |  |  |  |  | H | 12
 |  |  |  |  | I | 45
 |  |  |  |  | J | 88
 |  |  |  |  | K | 98
 |  |  |  |  | L | 55
 |  |  |  |  | M | 33
 |  |  |  |  | N | 39
 |  |  |  |  | O | 45
 |  |  |  |  | P | 69
 |  |  |  |  | Q | 25
 |  |  |  |  | R | 78
 |  |  |  |  | S | 55
 |  |  |  |  | T | 66
 |  |  |  |  | U | 77
 |  |  |  |  | V | 88
 |  |  |  |  | W | 69
 |  |  |  |  | X | 25
 |  |  |  |  | Y | 78
 |  |  |  |  | Z | 17
Spreadsheet: 150269d1334359944-counting-cells-with-data-across-3-columns-excel1
Sheet: YR prog 

 |  |  | score1 |  |  |  | score2
 |  | a | 0 |  |  | m | 0
 |  | s | 1 | * |  | m | 4
 |  | d | 2 | * | * | f | 5
 |  | f | 3 |  | * | f | 0
 |  | g | 4 |  |  | m | 0
 |  | h | 5 |  |  | m | 9
 |  | j | 6 |  |  | f | 7
 |  | k | 2 |  |  | f | 7
 |  | z | 2 |  |  | f | 8
 |  | x | 2 |  |  | f | 9
 |  | c |  |  |  | f | 7
Spreadsheet: 111098d1307566798-if-sumproduct-combo-sample-budget
Sheet: Membership

 |  |  | Budgeted
 |  |  | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 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 | Fiscal year 2012
Membership
 |  |  | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54
 |  |  | 1059 | 1059 | 1059 | 1059 | 1059 | 1059 | 1059 | 1059 | 1059 | 1059 | 1059 | 1059
 |  |  | 405 | 405 | 405 | 405 | 405 | 405 | 405 | 405 | 405 | 405 | 405 | 405
 |  |  | 4364 | 4364 | 4364 | 4364 | 4364 | 4364 | 4364 | 4364 | 4364 | 4364 | 4364 | 4364
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total
Assumptions
% of Membership lost | 0.1 |  | Yes |  |  | Yes | Yes | Yes
Spreadsheet: 401440d1434473316-how-do-calculate-distance-between-2-zip-codes-zip-codes
Sheet: Sheet1

ZIP CODE | Distance from 90802
91436
90041
91604
90640
90027
91101
90013
90803
91101
90064
91108
90049
91025
91203
90064
91107
90067
91066
90048
90807
91326
91306
91604
90670
90401
90291
90036
90049
90272
91406
90048
90230
90640
90067
90267
91101
91770
90005
91107
91367
90213
91203
90210
90815
90012
90631
90506
90015
91107
91101
90029
90064
90404
90066
90232
91502
90250
90036
91208
91502
90064
90701
92821
91106
90704
90272
91003
90014
90025
90048
90069
90002
90815
90048
91205
90067
90025
91723
91361
90064
91791
90815
91109
91605
90005
90703
90089
90010
91746
91330
90013
91406
90028
90025
90007
91011
90025
90077
91108
90066
90637
90040
90025
91101
91343
91208
91702
90026
90292
90815
90045
91107
90024
90802
90815
90806
90007
90010
90802
90017
91107
90037
90036
91746
90036
91307
90230
90071
90402
91505
90071
90066
90405
91011
91104
90069
91769
90048
90071
91103
90266
90064
91105
90035
91436
90024
91724
90815
90031
90077
91331
90038
91502
90804
91711
91106
91101
90631
90012
90401
90815
90060
90213
90025
90038
91109
91502
91203
90804
90017
90210
90230
90071
90063
90242
90403
90241
91710
91202
90011
91109
91790
90272
90041
90806
90014
90067
90022
90704
90230
90230
90031
90014
90064
90670
91505
91066
90004
90071
90020
91208
90813
91745
91345
90670
90024
91604
90505
90813
90815
90602
90025
90007
90201
91709
90015
90802
91601
91604
90815
90006
91789
90210
91024
90045
91711
90024
91711
91505
90071
91745
91776
91101
90064
90815
90230
90274
90031
91340
90064
91109
93534
91030
91331
91780
90048
90068
90815
90274
91007
90064
90254
90815
90210
Spreadsheet: 726397d1617208890-conditional-formattng-conditional-formatting-based-on-relative-values-mlott3528-
Sheet: Sheet1

Case Number | Priority | Business Hours Age | Opened Date |  | P1 | P2 | P3 |  |  |  |  |  | Priority | SLA
SF1234567 | P1 - Critical | 14 | 2021-03-24 00:00:00 |  |  |  |  |  |  |  |  |  | P1 | 12
SF1234568 | P1 - Critical | 6 | 2021-03-17 00:00:00 |  |  |  |  |  |  |  |  |  | P2 | 36
SF1234569 | P2 - High | 177.6336111111111 | 2021-02-23 00:00:00 |  |  |  |  |  |  |  |  |  | P3 | 400
SF1234570 | P2 - High | 24 | 2014-11-05 00:00:00
SF1234571 | P3 - Medium | 36 | 2021-03-16 00:00:00
SF1234572 | P3 - Medium | 24.74583333333333 | 2021-03-15 00:00:00 |  |  |  |  |  |  |  |  |  | Need Column C to reflect low to high with column G being the High
SF1234573 | P3 - Medium | 10.2875 | 2021-03-22 00:00:00
SF1234574 | P2 - High | 0.9533333333333334 | 2021-03-23 00:00:00 |  |  |  |  |  |  |  |  |  | Example how I need it to read
SF1234575 | P3 - Medium | 30 | 2021-03-18 00:00:00
SF1234576 | P3 - Medium | 494 | 2021-03-20 00:00:00 |  |  |  |  |  |  |  |  |  | Case Number | Priority | Business Hours Age
 |  |  |  |  |  |  |  |  |  |  |  |  | SF1234567 | P1 - Critical | 14
 |  |  |  |  |  |  |  |  |  |  |  |  | SF1234568 | P1 - Critical | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | SF1234569 | P2 - High | 177.6336111111111
 |  |  |  |  |  |  |  |  |  |  |  |  | SF1234570 | P2 - High | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | SF1234571 | P3 - Medium | 36
 |  |  |  |  |  |  |  |  |  |  |  |  | SF1234572 | P3 - Medium | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | Conditional Formattng (excelforum.com)
Spreadsheet: darrell_schoolcraft__7532__Eott Summary UAF Reports 2002
Sheet: Ark-La-Tex

[NAME]
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec | Total
Hanesville/Caddo/Bumpus - Condensate
Beginning Inventory | 133906.61 | 0
Receipts | 245735.16
Deliveries | 188563.8
Ending Inventory | 196616.73
Gain (Loss)-Bbls
Gain (Loss)- % |  |  |  |  | 0 | 0
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- % |  |  |  |  | 0 | 0
Haynesville/Caddo/Bumpus - Arkansas Sour
Beginning Inventory
Receipts | 0 |  |  |  |  |  |  |  |  |  |  | 0
Deliveries | 0 |  |  |  |  |  |  |  |  |  |  | 0
Ending Inventory | 0
Gain (Loss)-Bbls
Gain (Loss)- % | 0 |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- % | 0 |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Hayesville/Caddo/Bumpus - East Texas Crude
Beginning Inventory | 119431.63
Receipts | 255561.7
Deliveries | 286586.42
Ending Inventory | 82921.97
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
Smith Station - East Texas Crude
Beginning Inventory
Receipts | 0
Deliveries | 0
Ending Inventory | 0
Gain (Loss)-Bbls
Gain (Loss)- % | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- % | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
[NAME] Texas Crude
Beginning Inventory | 381.34
Receipts | 5202.27
Deliveries | 5345.88
Ending Inventory | 317.82
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
[NAME] Texas Crude
Beginning Inventory | 199.46
Receipts | 25621.39
Deliveries | 25181.89
Ending Inventory | 182.65
Gain (Loss)-Bbls
Gain (Loss)- % |  |  |  |  |  | 0
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- % |  |  |  |  |  | 0
Total Ark-La-Tex Pipeline
Beginning Inventory |  | 0
Receipts
Deliveries
Ending Inventory
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's
Adjusted G(L)-Bbls
Adjusted G(L)- %
Spreadsheet: 62906d1263905138-excel-2007-conditional-counting-then-displaying-data-in-new-sheet-example
Sheet: Raw Data

Job# | Group | Value1 | Value2 | Value3
5636574 | A | 0 | 1 | 1
5823617 | A | 0 | 1 | 1
5939589 | B |  |  | 1
6127856 | A |  |  | 1
6127856 | A | 1 | 1 | 1
6131497 | A | 1 | 1 | 1
6136168 | A | 1 | 1 | 1
6175164 | A | 0 | 1 | 1
6189556 | A | 0 | 1 | 1
6248560 | C |  |  | 1
6320159 | C |  |  | 1
6320162 | C |  |  | 1
6329176 | B |  |  | 1
6391769 | C |  |  | 1
6393679 | A |  |  | 1
6393679 | A | 1 | 1 | 1
6401466 | B | 0 | 1 | 1
6408506 | B | 1 | 1 | 1
6444936 | B | 0 | 1 | 1
6444936 | B |  |  | 1
6446306 | A | 0 | 1 | 1
6448005 | B | 0 | 1 | 1
6450835 | A | 1 | 1 | 1
6453697 | A | 0 | 1 | 1
6454221 | C |  |  | 1
6458428 | A | 0 | 1 | 1
6459911 | B | 1 | 1 | 1
6540 | A | 0 | 1 | 1
6461545 | A | 0 | 1 | 1
6462532 | C |  |  | 1
6503976 | B |  |  | 1
6503976 | B |  |  | 0
6510492 | A | 0 | 1 | 1
6511065 | C |  |  | 1
6511065 | C |  |  | 1
6512742 | A | 0 | 1 | 1
6517602 | B |  |  | 1
6517602 | B | 0 | 1 | 1
6538221 | A | 0 | 1 | 1
6566965 | B | 0 | 1 | 1
6567585 | B | 0 | 1 | 1
6569999 | C |  |  | 1
6574731 | B | 0 | 1 | 1
6576538 | A |  |  | 1
6577196 | B |  |  | 1
6577236 | A | 0 | 1 | 1
6577404 | A | 0 | 1 | 1
6577768 | A | 0 | 1 | 1
6577789 | A | 0 | 1 | 1
6579536 | C | 0 | 1 | 1
6581130 | A | 0 | 1 | 1
6587668 | B | 0 | 1 | 1
6589627 | A | 0 | 1 | 1
6590718 | B |  |  | 1
6594778 | A | 0 | 1 | 1
6596249 | C | 0 | 1 | 1
6598206 | A | 0 | 1 | 1
6601608 | A |  |  | 1
6645291 | B |  |  | 1
6645995 | A |  |  | 1
6645995 | A |  |  | 1
6646100 | A | 0 | 1 | 1
6647336 | C |  |  | 1
6647396 | B | 0 | 1 | 1
6647729 | B |  |  | 1
6648357 | A | 0 | 1 | 1
6648481 | A | 0 | 1 | 1
6650641 | A | 0 | 1 | 1
6659751 | B |  |  | 1
6663648 | A | 0 | 1 | 1
6666129 | B | 0 | 1 | 1
6666378 | B | 0 | 1 | 1
6708285 | A |  |  | 1
6711588 | A | 0 | 1 | 1
6712178 | A |  |  | 1
6723480 | B | 0 | 1 | 1
6727805 | B | 0 | 1 | 1
6777932 | B | 0 | 1 | 1
Spreadsheet: 786637d1657313062-finding-duplicates-in-house-and-street-name-columns-book5
Sheet: Sheet1

Mt Vernon | 1
Mt Vernon | 1 | Mt Vernon 1 | duplicate
Mt Vernon | 1 | Mt Vernon 1 | duplicate
Mt Vernon | 8 | Mt Vernon 8 | unique
OAK TREE | 8 | OAK TREE 8 | unique
Mt Vernon | 11 | [NAME] 11 | unique
OAK TREE | 12 | OAK TREE 12 | unique
Mt Vernon | 15 | Mt Vernon 15 | unique
OAK TREE | 16 | OAK TREE 16 | unique
Mt Vernon | 17 | [NAME] 17 | unique
Spreadsheet: 296831d1392209644-creating-a-database-excel-spreadsheet-and-an-invoice-00-books-4-you-vlookup
Sheet: Invoice

BOOKS 4 YOU
56 Burnley Road
Accrington
Name: |  |  | Date:
Address:
 |  |  | Client Code: | [NAME]
Post Code
Book code | Title | Quantity | Sale price | Total
BI02 |  | 1
CO03 |  | 2
DE06 |  | 1
GR01 |  | 1
KI03 |  | 1
Payment: | Credit card | TOTAL AMOUNT DUE
 | Thankyou for your business
Spreadsheet: 217081d1361981932-multiple-values-with-more-than-one-critera-205-plan-by-program-compare
Sheet: Sheet1

Sample |  |  |  |  |  |  |  |  | REG | EXC
Plan Type | [NAME] | [NAME] |  | Plan Type | REG | EXC |  |  | REG Medical | REG Medical
10 | REG | REG Medical |  | 10 |  |  |  |  | BCBS HMO Plan | BCBS HMO Plan
10 | REG | BCBS HMO Plan |  |  |  |  |  |  | BCBS Low Deductible Plan | BCBS Low Deductible Plan
10 | REG | BCBS Low Deductible Plan |  |  |  |  |  |  | BCBS High Deductible Plan | BCBS High Deductible Plan
10 | REG | BCBS High Deductible Plan |  |  |  |  |  |  |  | Kaiser HMO
11 | REG | Basic Dental
11 | REG | Fancy Dental
10 | EXC | REG Medical
10 | EXC | BCBS HMO Plan
10 | EXC | BCBS Low Deductible Plan
10 | EXC | BCBS High Deductible Plan
10 | EXC | Kaiser HMO
11 | EXC | Basic Dental
11 | EXC | Fancy Dental
Spreadsheet: 850657d1701072173-search-for-text-in-the-cell-and-return-a-value-search-test
Sheet: Sheet1

diagnosis | Expected Result |  |  |  |  |  |  |  | Diag | New Diag
ACUTE GE | FEVER ON LONG LEAVE |  |  |  |  |  |  |  | Cataract | Cataract Surgery
fibroids, acute ge, dehydration | FEVER ON LONG LEAVE |  |  |  |  |  |  |  | ACUTE GE | FEVER ON LONG LEAVE
anaemia , acute ge aki dehydration cr 1.7 hb 8.2 to 9.2, terminal ileitis on ct abdomen no repeat inv | FEVER ON LONG LEAVE |  |  |  |  |  |  |  | AFI | FOLG 3
t2dm htn acute ge, dehydration, sepsis? , [NAME] rv dilated left to right shunt | FEVER ON LONG LEAVE
cataract sx | Cataract Surgery
cataract Rt s/p sics pciol | Cataract Surgery
cataract s/p phaco | Cataract Surgery
left cataract s/p ns 3 4 c nuclear sclerosis corticalcataract | Cataract Surgery
left cataract s/p phaco | Cataract Surgery
left cataract s/p phaco pc iol | Cataract Surgery
cataract ns3 | Cataract Surgery
left cataract s/p sics pc iol | Cataract Surgery
cataract | Cataract Surgery
left cataract s/p phaco pc iol | Cataract Surgery
cataract left a/ phaco pc iol | Cataract Surgery
cataract s/p phaco | Cataract Surgery
cataract s/p phaco | Cataract Surgery
cataract left | Cataract Surgery
cataract left | Cataract Surgery
hepatitis, afi, costochondritis ct chest normal med mx | FOLG3
rt indirect inguinal hernia, afi a/e ba | FOLG3
afi ? Uti labelled urine c/s neg urine rme nad | FOLG3
age with afi dehydration | FOLG3
afi febrile illnes hepatitis hyperbilirbinemia | FOLG3
t2dm, afi, myalgia ? Viral urti no complications no inv reports | FOLG3
afi no complications | FOLG3
afi swineflu h1n1 inj a +, cag normal coronaries echo no lv rwma hrct ct abd normal /l small renal calculi non obstructve | FOLG3
afi dengues ns1 +widal 1:160 lrti hrct plt 1.2 lakh lowest | FOLG3
Spreadsheet: 809762d1671288372-data-cleansing-query-compare-lookup-return-standard-value-data-cleansing-query-updated
Sheet: Sheet1

 |  |  |  | Can I create a table like this?
 | Current Data Example | DESIRED Result |  | RETURN THIS | opt1 | opt2 | opt3 | opt4 | opt5 | opt6 |  | Current Data Example | Desired Result
 | [NAME] | Floor 01 |  | Floor 01 | [NAME] | Flr 1 | [NAME] | Flr One | 1 | 1 |  | [NAME]
 | Flr 1 | Floor 01 |  | Floor 02 | [NAME] | Flr 2 | Floor Two | Flr Two | 2 | 2 |  | Flr 1
 | [NAME] | Floor 01 |  |  |  |  |  |  |  |  |  | [NAME]
 | Flr One | Floor 01 |  |  |  |  |  |  |  |  |  | Flr One
 | [NAME] | Floor 01 |  | CurrentData | UseData |  |  |  |  |  |  | [NAME]
 | [NAME] | Floor 01 |  | 1 | Floor 01 |  |  |  |  |  |  | [NAME]
 | [NAME] | Floor 01 |  | [NAME] | Floor 01 |  |  |  |  |  |  | [NAME]
 | 1 | Floor 01 |  | [NAME] | Floor 01 |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  | Flr 1 | Floor 01 |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  | Flr One | Floor 01 |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  |  |  |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  |  |  |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  |  |  |  |  |  |  |  |  | 1
 | 1 | Floor 01 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Location | Correct Location |  |  |  |  |  |  | Unknown location
 |  |  |  | Floor 01 | Floor 01
 |  |  |  | [NAME] | Floor 01
 |  |  |  | Flr 1 | Floor 01
 |  |  |  | Flr 2 | Floor 02
 |  |  |  | Floor Two | Floor 02
 |  |  |  | Flr Two | Floor 02
 |  |  |  | 1 | Floor 01
 |  |  |  | Unknown location