tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 845430d1696953939-if-values-between-x-and-y-date-each-year-output-yes-between-dates
Sheet: Sheet1

Date |  | Expected | So Far
2000-02-16 00:00:00 |  | Nope
2000-12-09 00:00:00 |  | Yes
2001-03-16 00:00:00 |  | Yes
2001-05-31 00:00:00 |  | Nope
2001-10-03 00:00:00 |  | Yes
2002-02-14 00:00:00 |  | Yes
2002-04-27 00:00:00 |  | Nope
2002-06-21 00:00:00 |  | Nope
2002-07-08 00:00:00 |  | Nope
2002-08-05 00:00:00 |  | Nope
2002-08-11 00:00:00 |  | Nope
2002-10-05 00:00:00 |  | Yes
2002-10-16 00:00:00 |  | Yes
2003-08-27 00:00:00 |  | Nope
2003-11-02 00:00:00 |  | Yes
2004-01-28 00:00:00 |  | Yes
2004-02-09 00:00:00 |  | Yes
2004-03-02 00:00:00 |  | Yes
2004-03-07 00:00:00 |  | Yes
2004-06-24 00:00:00 |  | Nope
2004-10-06 00:00:00 |  | Yes
2005-06-15 00:00:00 |  | Nope
2005-07-22 00:00:00 |  | Nope
2006-01-26 00:00:00 |  | Yes
2006-03-02 00:00:00 |  | Yes
2006-05-05 00:00:00 |  | Nope
2006-07-02 00:00:00 |  | Nope
2006-12-31 00:00:00 |  | Yes
2007-05-17 00:00:00 |  | Nope
2007-06-12 00:00:00 |  | Nope
2007-07-30 00:00:00 |  | Nope
2008-05-07 00:00:00 |  | Nope
2008-11-30 00:00:00 |  | Yes
2008-12-26 00:00:00 |  | Yes
2009-03-18 00:00:00 |  | Yes
2009-03-29 00:00:00 |  | Yes
2009-07-14 00:00:00 |  | Nope
2009-07-28 00:00:00 |  | Nope
2009-11-22 00:00:00 |  | Yes
2009-12-13 00:00:00 |  | Yes
2010-06-08 00:00:00 |  | Nope
2010-10-10 00:00:00 |  | Nope
2010-11-26 00:00:00 |  | Nope
2011-06-29 00:00:00 |  | Nope
2011-08-12 00:00:00 |  | Nope
2011-10-23 00:00:00 |  | Yes
2011-11-20 00:00:00 |  | Yes
2011-12-26 00:00:00 |  | Yes
2012-03-10 00:00:00 |  | Yes
2012-07-11 00:00:00 |  | Nope
2012-07-27 00:00:00 |  | Nope
2012-12-26 00:00:00 |  | Yes
2013-01-11 00:00:00 |  | Yes
2013-07-29 00:00:00 |  | Nope
2013-08-10 00:00:00 |  | Nope
2014-03-08 00:00:00 |  | Yes
2014-12-26 00:00:00 |  | Yes
2015-03-29 00:00:00 |  | Yes
2015-07-03 00:00:00 |  | Nope
2015-08-17 00:00:00 |  | Nope
2015-09-27 00:00:00 |  | Yes
2015-10-09 00:00:00 |  | Yes
2015-11-08 00:00:00 |  | Yes
2015-11-17 00:00:00 |  | Yes
2016-02-22 00:00:00 |  | Yes
2016-06-06 00:00:00 |  | Nope
2016-08-30 00:00:00 |  | Nope
2016-11-16 00:00:00 |  | Yes
2016-11-20 00:00:00 |  | Yes
2017-02-02 00:00:00 |  | Yes
2017-04-12 00:00:00 |  | Yes
2017-07-14 00:00:00 |  | Nope
2017-08-05 00:00:00 |  | Nope
2017-08-22 00:00:00 |  | Nope
2017-10-12 00:00:00 |  | Yes
2017-10-17 00:00:00 |  | Yes
2017-12-15 00:00:00 |  | Yes
2018-01-06 00:00:00 |  | Yes
2018-01-24 00:00:00 |  | Yes
2018-06-09 00:00:00 |  | Nope
2018-06-09 00:00:00 |  | Nope
2018-07-31 00:00:00 |  | Nope
2018-11-19 00:00:00 |  | Yes
2019-03-27 00:00:00 |  | Yes
2019-05-20 00:00:00 |  | Nope
2019-11-11 00:00:00 |  | Yes
2020-01-02 00:00:00 |  | Yes
2020-02-03 00:00:00 |  | Yes
2020-07-23 00:00:00 |  | Nope
2020-11-21 00:00:00 |  | Yes
2020-12-12 00:00:00 |  | Yes
2021-01-19 00:00:00 |  | Yes
2021-05-30 00:00:00 |  | Nope
2021-09-19 00:00:00 |  | Yes
2022-02-24 00:00:00 |  | Yes
2022-07-29 00:00:00 |  | Nope
2022-12-22 00:00:00 |  | Yes
2023-02-01 00:00:00 |  | Yes
2023-06-15 00:00:00 |  | Nope
Spreadsheet: 329941d1404463155-searching-if-a-cell-contains-a-range-of-values-madasu2
Sheet: Lookup vlaues

2nd Level | 1st Level |  | sort
z | accountants | something else 1 | 1 |  |  | note column a is sorted by length as the look up matches the last value found
y | accountants | something else 2 | 1
x | accountants | something else 3 | 1 |  |  | so xyz if found it is further up the list than x
w | accountants | something else 4 | 1
xyz | accountants | something else 5 | 3 |  |  | otherewise   xyz.com
xxx | accountants | something else 6 | 3 |  |  | would be a match for say x or xy
wtf | accountants | something else 7 | 3 |  |  | so this enables the formula to check the longest match
want | accountants | something else 8 | 4
world | accountants | something else 9 | 5 |  |  | to sort your data simply put =len(a2)
zurich | accountants | something else 10 | 6 |  |  | as I have done in col d then select all and sort by column d ascending
website | accountants | something else 11 | 7
worldwide | accountants | something else 12 | 9
Spreadsheet: 714315d1611168813-create-list-including-duplicates-from-range-book1
Sheet: Sheet1

ID | Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6 | Team 7 | Team 8 | Team 9
506 | 506 |  |  |  |  |  | 506
505 | 505 |  |  |  |  |  | 505
504 | 504 |  |  |  |  |  | 504
502 |  |  |  | 502 |  |  | 502
495 | 495 | 495 |  |  |  |  | 495 |  | 495
492 | 492 | 492 |  |  |  | 492
479 |  | 479 | 479
475 |  |  | 475 | 475
474 |  |  |  | 474 |  |  | 474
471 |  |  | 471 |  |  |  |  | 471
424 |  | 424 |  |  |  |  | 424
407 |  |  | 407 |  |  | 407
393 | 393 |  |  |  |  |  | 393
Spreadsheet: 751730d1634287516-calculate-and-count-occurrences-across-multiple-non-adjacent-columns-and-multiply-earnings
Sheet: Volunteers

 |  | Earnings WK1 | Earnings WK2 | Earnings WK3 | Earnings WK4 | Earnings WK5 | Earnings WK6 | [NAME] | Earnings WK8 | Earnings WK9
Volunteer 1
Volunteer 2
Volunteer 3
Volunteer 4
Volunteer 5
Volunteer 6
Volunteer 7
Volunteer 8
Volunteer 9
Volunteer 10
Volunteer 11
Volunteer 12
Volunteer 13
Volunteer 14
Volunteer 15
Volunteer 16
Volunteer 17
Volunteer 18
Volunteer 19
Volunteer 20
Spreadsheet: 102804d1300747976-step-graphs-excel-forum
Sheet: Correct

 | Period | Distribtuion Rate
 | 2005-01-01 00:00:00 | 0.05
 | 2005-12-31 00:00:00 | 0.05
 | 2006-01-01 00:00:00 | 0.064
 | 2006-12-31 00:00:00 | 0.064
 | 2007-01-01 00:00:00 | 0.061
 | 2007-12-31 00:00:00 | 0.061
 | 2008-01-01 00:00:00 | 0.068
 | 2008-12-31 00:00:00 | 0.068
 | 2009-01-01 00:00:00 | 0.05
 | 2011-02-28 00:00:00 | 0.05
Spreadsheet: 770847d1646300458-replace-multiple-specific-values-database-sample
Sheet: Sheet1

Sample: |  |  |  |  |  |  |  |  |  |  |  | Excepted result:
ID | No. | Title | Slug | Parent [NAME] |  |  |  |  |  |  |  | ID | No. | Title | Slug | Parent [NAME]
11111 | […] | Title […] | db-4186 | db-4167/db-4168/db-4169 |  |  |  |  |  |  |  | 11111 | […] | Title […] | db-4186 | db-4167/db-4168/db-4169
22222 | […] | Details | db-4187 | db-4167/db-4168/db-4169/db-4186/db-9516/db-12338/db-9483 |  |  |  |  |  |  |  | 22222 | […] | Details | db-4187 | db-4167/db-4168/db-4169/db-4186/db-9516/db-12338/db-9483
33333 | […] | Title […] | db-4188 | db-4167/db-4168/db-4169/db-4186/db-9516/db-12338/db-9483/db-4187 |  |  |  |  |  |  |  | 33333 | […] | Title […] | db-4188 | db-4167/db-4168/db-4169/db-4186/db-9516/db-12338/db-9483
44444 | […] | Details | db-4189 | db-4167/db-4168/db-4169/db-4186/db-9516/db-12337/db-8890 |  |  |  |  |  |  |  | 44444 | […] | Details | db-4189 | db-4167/db-4168/db-4169/db-4186/db-9516/db-12337/db-8890
55555 | […] | Title […] | db-4190 | db-4167/db-4168/db-4169/db-4186/db-9516/db-12337/db-8890/db-4189 |  |  |  |  |  |  |  | 55555 | […] | Title […] | db-4190 | db-4167/db-4168/db-4169/db-4186/db-9516/db-12337/db-8890
66666 | […] | Title […] | db-4207 | db-4167/db-4168/db-5261/db-9628/db-5277/db-5288/db-5303/db-12106 |  |  |  |  |  |  |  | 66666 | […] | Title […] | db-4207 | db-4167/db-4168/db-5261/db-9628/db-5277/db-5288/db-5303/db-12106
77777 | […] | Title […] | db-4212 | db-4167/db-4168 |  |  |  |  |  |  |  | 77777 | […] | Title […] | db-4212 | db-4167/db-4168
88888 | […] | Title […] | db-4213 | db-4167/db-4168/db-4212 |  |  |  |  |  |  |  | 88888 | […] | Title […] | db-4213 | db-4167/db-4168/db-4212
Spreadsheet: 851603d1701799526-countif-unique-in-pivot-table-field-demo
Sheet: Sheet1

Employees/LEMs with Time Issues to Resolve
 |  |  |  |  |  |  |  |  |  | Unique Values
[NAME] | Problem |  | # of Problems: | 20 |  | # of LEMs: |  | <-- s/b 13 |  | 018210
 |  |  |  |  |  |  |  |  |  | 018337
Sum of RT Hours | Column Labels |  |  |  |  |  |  |  |  | 018357
Employee ~ LEM # | 1900-01-01 00:00:00 | 1900-01-02 00:00:00 | 1900-01-03 00:00:00 | 1900-01-04 00:00:00 | 1900-01-05 00:00:00 | 1900-01-07 00:00:00 | Grand Total |  |  | 018367
Employee 1 |  | 11 | 14 |  |  |  | 25 |  |  | 018374
018210 |  | 1 |  |  |  |  | 1 |  |  | 018375
018337 |  | 2 |  |  |  |  | 2 |  |  | 018292 |  | 13
018357 |  |  | 4 |  |  |  | 4 |  |  | 018313
018367 |  |  | 2 |  |  |  | 2 |  |  | 018482
018374 |  | 8 |  |  |  |  | 8 |  |  | 018370
018375 |  |  | 8 |  |  |  | 8 |  |  | 018428
Employee 2 | 8 |  |  |  |  | 8 | 16 |  |  | 018444
018292 | 8 |  |  |  |  |  | 8 |  |  | 018472
018313 | 0 |  |  |  |  |  | 0
018482 |  |  |  |  |  | 8 | 8
Employee 3 | 8 |  |  |  |  | 8 | 16
018292 | 7 |  |  |  |  |  | 7
018313 | 1 |  |  |  |  |  | 1
018482 |  |  |  |  |  | 8 | 8
Employee 4 | 8 |  |  |  |  | 8 | 16
018292 | 8 |  |  |  |  |  | 8
018482 |  |  |  |  |  | 8 | 8
Employee 5 |  |  | 10 |  | 10 |  | 20
018370 |  |  | 10 |  |  |  | 10
018428 |  |  |  |  | 3 |  | 3
018444 |  |  |  |  | 7 |  | 7
Employee 6 | 8 |  |  |  |  | 8 | 16
018292 | 8 |  |  |  |  |  | 8
018482 |  |  |  |  |  | 8 | 8
Employee 7 |  |  |  |  |  | 8 | 8
018472 |  |  |  |  |  | 8 | 8
Spreadsheet: 95b4be65-7c5d-45ff-afa0-0d2f32bb7c4d
Sheet: Sheet1

18u BCS Florida Regional- Dodgertown Playoff Bracket | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | #1 Orlando Scorpions Purple
#4 Jacksonville Stars | Monday 9:00 AM | #1 Orlando Scorpions Purple
 | Stadium
Sunday 2:45 PM | #5 The Bombers
[NAME]
#5 The Bombers
 |  | Monday 11:30 AM | #1 Orlando Scorpions Purple
 |  | Stadium | Regional Champion
#6 PG National Academy
Sunday 2:45 PM | #3 Florida Pokers
[NAME]
#3 Florida Pokers | Monday 9:00 AM | #2 Central FL Renegades
 | [NAME]
 | #2 Central FL Renegades
Spreadsheet: 146089d1331896526-vlook-up-duplicate-data-part-master-example
Sheet: PARTS

Part# | Material | Customer | Description | Material Grade | Material Price | Price (£) | Price (€) | Price Comment | Part Weight | Density | Volume | as% | Material Cost | as X material
90287 | EPP | Cust1 | [NAME] | BLUE |  | 0.327 | 0.3924 |  |  | 72 | 0.51
90332 | EPP | Cust2 | P32L STEERING COLUMN COVER | 5118 bulk |  | 1.075 | 1.229 |  |  | 45 | 2.3
90471 | EPP | Cust3 | [NAME] | 5118 bulk |  | 1.091 | 0 |  |  | 45 | 0.151
10778L | EPS | Cust4 | P32L CRASH PAD LHD - LEFT | 5118 bulk |  | 0.306 | 0.444 |  |  | 20 | 3.939
Spreadsheet: 788306d1658396588-aligning-rows-with-similar-id-from-one-worksheet-into-another-book
Sheet: pay

Reference | Paid
REC-2022-01-000216 | 800
REC-2022-01-000222 | 200
REC-2022-01-000225 | 300
REC-2022-01-000229 | 150
REC-2022-01-000305 | 400
REC-2022-01-000315 | 200
REC-2022-01-000322 | 700
REC-2022-01-000327 | 100
REC-2022-01-000331 | 50
REC-2022-01-000336 | 100
REC-2022-01-000358 | 100
REC-2022-01-000376 | 120
REC-2022-02-000950 | 100
REC-2022-02-001084 | 100
REC-2022-02-001105 | 200
REC-2022-02-001181 | 300
REC-2022-03-001412 | 100
REC-2022-03-001652 | 120
REC-2022-03-001704 | 300
REC-2022-03-001714 | 100
REC-2022-03-001881 | 220
REC-2022-04-002315 | 240
REC-2022-04-002700 | 100
REC-2022-04-002357 | 100
REC-2022-04-002360 | 220
REC-2022-04-002364 | 220
REC-2022-04-002605 | 100
REC-2022-04-002609 | 100
REC-2022-04-002628 | 100
REC-2022-04-002634 | 200
REC-2022-04-002641 | 300
REC-2022-04-002648 | 100
REC-2022-04-002683 | 100
REC-2022-04-002714 | 120
REC-2022-05-002840 | 100
REC-2022-05-002845 | 600
REC-2022-05-002849 | 200
REC-2022-05-002854 | 200
REC-2022-05-002858 | 100
REC-2022-05-002934 | 400
REC-2022-05-002950 | 500
REC-2022-05-002988 | 100
REC-2022-05-003024 | 300
REC-2022-05-003034 | 200
REC-2022-05-003072 | 1120
REC-2022-05-003076 | 300
REC-2022-05-003506 | 50
REC-2022-05-003135 | 650
REC-2022-05-003141 | 550
REC-2022-05-003270 | 450
REC-2022-05-003285 | 1100
REC-2022-05-003291 | 400
REC-2022-05-003308 | 800
REC-2022-06-003514 | 250
REC-2022-06-003518 | 1320
REC-2022-06-003523 | 700
REC-2022-06-003534 | 100
REC-2022-06-003571 | 100
REC-2022-06-003807 | 400
REC-2022-06-003817 | 1080
REC-2022-06-003830 | 300
REC-2022-06-003842 | 100
REC-2022-06-003847 | 600
REC-2022-06-003851 | 520
REC-2022-06-003857 | 820
REC-2022-06-003860 | 500
REC-2022-06-003864 | 400
REC-2022-06-003871 | 820
REC-2022-06-003875 | 2593
REC-2022-06-003977 | 920
REC-2022-06-003982 | 1720
REC-2022-06-003994 | 2600
 | 30723
Spreadsheet: 825891d1681613078-shows-unique-entries-automatically-auto-filter
Sheet: Sheet1

Date | Voucher No | Amount | Account Head | Voucher No List
2023-01-01 00:00:00 | CPV-125 | 15000 | Loading / Unloading
2023-01-04 00:00:00 | CPV-125 | 10000 | Repair And Maintenance
2023-01-07 00:00:00 | CPV-125 | 11000 | Sundry Creditors
2023-01-10 00:00:00 | BPV-126 | 25000 | Utilities Payable
2023-01-13 00:00:00 | BPV-126 | 27850 | Bills Payable
2023-01-16 00:00:00 | CPV-127 | 30700 | Bank Charges
2023-01-19 00:00:00 | CPV-128 | 33550 | Custom Duty
2023-01-22 00:00:00 | CPV-128 | 36400 | Freight Charges
2023-01-25 00:00:00 | BPV-129 | 39250 | [NAME]
2023-01-28 00:00:00 | BPV-130 | 42100 | Computers
2023-01-31 00:00:00 | [NAME] | 44950 | Furniture
2023-02-03 00:00:00 | [NAME] | 47800 | [NAME]
2023-02-06 00:00:00 | [NAME] | 50650 | Rent Expense
Spreadsheet: 45084d1243869037-help-finding-if-names-occur-multiple-times-sample-1
Sheet: Sheet1

 | 2009 Object Created | Main Builder | Help |  | 2008 Object Created | Main Builder | Help |  | 2007 Object Created | Main Builder | Help
 | Stool | [NAME] | Al |  | Stool | [NAME] | Al |  | Stool | [NAME] | [NAME]
 | Bed | [NAME] | Fred |  | Bed | [NAME] | [NAME] |  | Bench | [NAME] | [NAME]
 | Chair | [NAME] | [NAME] |  | Chair | [NAME] | [NAME] |  | Bed | [NAME] | [NAME]
 | Couch | Suzie | [NAME] |  | Desk | Suzie | [NAME] |  | Chair | [NAME] | [NAME]
 | Table | [NAME] | Sid |  | Couch | Suzie | [NAME] |  | Desk | Suzie | [NAME]
 | Coffee Table | Todd | [NAME] |  | Table | [NAME] | Todd |  | Couch | Suzie | [NAME]
 |  |  |  |  | Coffee Table | Todd | [NAME] |  | Table | [NAME] | Todd
 |  |  |  |  |  |  |  |  | Coffee Table | [NAME] | [NAME]
Spreadsheet: 877632d1724424844-populate-cells-based-on-selection-from-dropdown-book2
Sheet: Sheet2

I want to return this data to Sheet1 when Gold is selected from the dropdown on Sheet1
 | 0.5 | 0.5 | 0.0666
 | 1.3333 | 0.9 | 0.2666
 | 0.5 | 0.1333 | 0.1333
 | 2 | 0.2666 | 0.1333
 | 0.3333 | 0.6666 | 0.0666
 | 0.3333 | 0.1 | 0.0666
 | 0.2 | 0.2 | 0.1
 | 0.6666 | 0.3333 | 0.1666
Spreadsheet: 854cf3b3-9879-4e0f-b7be-b75d4139f279
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
FEDERAL FUNDING REQUEST
For All Federal SAPT Block Grant Funding
Ohio Department of Alcohol & Drug Addiction Services
1. Header Information:
Agency/Board Name: |  |  |  |  |  |  | Purchase Order #: (If applicable)
2. Expenses  SFY 2012
Service Category | Total SFY11 [NAME] | 4th QTR Max 100% of SFY Award Eligible for Disbursement | SFY12 4th Quarter Actual Expense |  |  |  | Projected Expenses Thru                (Enter Date) | Total Cumulative Expenses | Cash Received To Date | Amount Requested | [NAME] for Request | SFY11 [NAME]
 |  |  | Prior Qtr(s) Cumulative Expenses | April | May | June
Prevention | ( A ) | ( B ) | ( C ) | ( D ) | ( E ) | ( F ) | ( G ) | (H) =C+D+E+F+G | ( I ) | ( J ) = H - I | (K) = B - I - J | (L) = A - I - J
2000C - Per Capita Prevention |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
2010C - UMADAOP |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
2010G - Women's Prevention Grants |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
2020C - Drug Free Coalitions |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
2020E - Higher Education |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
2020I - Community Prevention |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
2020J - Targeted Prevention Initiatives |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
2030E - Youth-Led Prevention |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
2030G - Circle for Recovery |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
2030M - Prevention Services |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
Total Prevention | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Treatment
2050C - Per Capita Treatment |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
2060E - Women's Treatment Grants |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
2070C - Adolescent Treatment |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
2080E - TASC |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
2080F - Drug Courts |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
2080I  - DYS Aftercare |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
2080M - Circle for Recovery |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
2100I - SAMI |  | 0 |  |  |  |  |  | 0 |  | 0 | 0 | 0
Total Treatment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GRAND TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Federal regulations require that all federal funds be drawn down on a reimbursement basis and/or no more than thirty (30) days in advance of projected expenditures.  NO FUNDS WILL BE DISBURSED UNLESS ALL REQUIRED COLUMNS ARE COMPLETED.
3. CERTIFICATION
I certify that the financial information shown in this funding request is correct.
Requestor's Signature/Title | Phone Number |  | Date |  | Board Executive Director's Signature |  |  | Phone Number |  |  | Date
Spreadsheet: 818202d1676646501-insert-empty-column-in-dynamic-array-dynamic-array-empty-column
Sheet: Feuil1

 |  |  |  |  |  | expected result
ID | A | B | C |  |  | ID | A | B | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ID | A | B
 | aa | ww |  |  |  | 1 |  | aa | ww |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | aa | ww
2 | zz | xx |  |  |  | 2 |  | zz | xx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | zz | xx
3 | ee | rr |  |  |  | 3 |  | ee | rr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | ee | rr
4 | rr | tt |  |  |  | 4 |  | rr | tt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | rr | tt
5 | tt | yy |  |  |  | 5 |  | tt | yy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | tt | yy
6 | yy | uu |  |  |  | 6 |  | yy | uu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | yy | uu
7 | uu | ii |  |  |  | 7 |  | uu | ii |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | uu | ii
8 | ii | jj |  |  |  | 8 |  | ii | jj |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | ii | jj
9 | oo | ,, |  |  |  | 9 |  | oo | ,, |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | oo | ,,
Spreadsheet: 150095d1334278207-copying-data-to-another-worksheet-test-tracker
Sheet: Test Tracker

DEPARTMENT | TEST #1 | TEST #2 | TEST #3 | TEST #4 | TEST #5
SALES | 0 | 0 | 0 | 0 | 0
ACCOUNTING | 0 | 0 | 0 | 0 | 0
MANAGEMENT | 0 | 0 | 0 | 0 | 0
PUBLIC AFFAIRS | 0 | 0 | 0 | 0 | 0
Spreadsheet: 685413d1593981805-create-relationship-between-randomised-data-to-prevent-repetition-andynw1
Sheet: Sheet1

 | WORK | RANDOM | RANK |  | DAY | PERSON 1 | PERSON 2 | PERSON 3 | PERSON 4 | PERSON 5 |  | Helper | Invalid schedule?
 | [NAME] |  |  |  | Sun
 | [NAME] |  |  |  | Mon
 | [NAME] |  |  |  | [NAME]
 | [NAME] |  |  |  | Wed
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Valid solution? |  |  |  |  |  |  | Sun | Mon | [NAME] | Wed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERSON 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERSON 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERSON 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERSON 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERSON 5
Spreadsheet: 793427d1661460129-if-cell-is-the-same-equal-adjacent-value-and-sort-alphabetically-in-one-cell-sample
Sheet: Sheet1

 |  | Desired Output
Apple | Promo 1 | Apple, [NAME], Pear
[NAME] | Promo 1 | Apple, [NAME], Pear
Pear | Promo 1 | Apple, [NAME], Pear
Orange | Promo 2 | Apple, Orange
Apple | Promo 2 | Apple, Orange
[NAME] | Promo 3 | Banana, Orange, Pear
Pear | Promo 3 | Banana, Orange, Pear
Orange | Promo 3 | Banana, Orange, Pear
Spreadsheet: hunter_shively__12678__Nov_01 Volume Changes
Sheet: Nov 8

Pipeline | Producer |  | Zone | Current Volume | New Volume | Change | Index | GDA | Fixed
ANR | KCS | 1135904 | Gath | 229 | 120 |  |  | -109
ANR | Ralaco | 969536 | Gath | 1540 | 2840 |  | 910 | 390
ANR | Riceland | 969604 | Gath | 2518 | 5036 |  | 1950 | 486 | 82
CGLF | Forest | 1109813 | [NAME] | 7484 | 0 |  |  |  | -7484
HIOS | Juniper | 1156052 | Offshre | 1750 | 1500 |  |  | -250
HIOS | Panaco | 1135518 | Offshre | 12965 | 12910 |  |  | -55
SNAT | Qwest | 1139643 | Constr WH | 18500 | 18700 |  | 200 |  |  | one day
STRY | Linder | 1135987 | RCPTS | 6000 | 2326 |  | -1274 | -2400
STRY | MMS | 1103008 | RCPTS | 66139 | 65612 |  |  | -527
TENN | Samedan | 1139500 | Zone 0 | 3800 | 4000 |  |  |  | 200
TENN | Century Expl | 1135962 | Zone 500 | 2008 | 2225 |  |  | 217
TENN | Pioneer | 1135749 | Zone 500 | 1549 | 1731 |  |  | 182
TENN | Cabot | 1138935 | Zone 500 | 10313 | 10613 |  | 300
TENN | Crosstex | 1152828 | Zone 500 | 500 | 700 |  |  | 200
TENN | Denbury | 1139933 | Zone 800 | 2120 | 1600 |  | -520
TENN | Progas | 1143611 | Zone 800 | 3780 | 3500 |  |  | -280
TETCO | Mariner | 1047379 | ELA | 24000 | 23460 |  | -540
TETCO | KCS | 1143961 | ETX | 5200 | 5000 |  |  | -200
TETCO | Spinnaker | 1139869 | WLA | 10487 | 12500 |  |  | 2013
VGS | Bluebird | 1127576 | Gath | 4836 | 5301 |  |  | 465
 |  |  |  |  |  | Daily Total
 |  |  |  |  |  | MTD Total | -33488 | -1153 | -7202
Spreadsheet: 586314d1534315567-pivot-tables-and-relationships-pivots
Sheet: Result

 |  |  | ID | Name | TicketPrice
 |  |  | 1 | Name1 | 10
 |  |  |  |  | 20 |  |  |  |  |  |  |  | Expected Result: |  | 1 | Name1 | 10
 |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  | 2 | [NAME] | 20
 |  |  |  |  | 40 |  |  |  |  |  |  |  |  |  | 3 | Name3 | 30
 |  |  |  |  | 50 |  |  |  |  |  |  |  |  |  | 4 | Name4 | 40
 |  |  |  |  | (blank) |  |  |  |  |  |  |  |  |  | 5 | Name5 | 50
 |  |  | 2 | [NAME] | 10
 |  |  |  |  | 20
 |  |  |  |  | 30
 |  |  |  |  | 40
 |  |  |  |  | 50
 |  |  |  |  | (blank)
 |  |  | 3 | Name3 | 10
 |  |  |  |  | 20
 |  |  |  |  | 30
 |  |  |  |  | 40
 |  |  |  |  | 50
 |  |  |  |  | (blank)
 |  |  | 4 | Name4 | 10
 |  |  |  |  | 20
 |  |  |  |  | 30
 |  |  |  |  | 40
 |  |  |  |  | 50
 |  |  |  |  | (blank)
 |  |  | 5 | Name5 | 10
 |  |  |  |  | 20
 |  |  |  |  | 30
 |  |  |  |  | 40
 |  |  |  |  | 50
 |  |  |  |  | (blank)
 |  |  | 6 | Name6 | 10
 |  |  |  |  | 20
 |  |  |  |  | 30
 |  |  |  |  | 40
 |  |  |  |  | 50
 |  |  |  |  | (blank)
 |  |  | Grand Total