tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: dcb278af-da8d-4fe6-a029-5c99c6e0066a
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | Sharp | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Academy Drive |  | Boone | NC | 28608
East Carolina University | [NAME] | Skip | [EMAIL] | [PHONE] |  | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | Wade | Damon | [EMAIL] | [PHONE] | [PHONE] | 1704 Weeksville Road |  | Elizabeth City | NC | 27909
Fayetteville State University | Walker | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Jenkins | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | [NAME] | Sandra | [EMAIL] | [PHONE] | [PHONE] | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Helm | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Raleigh | NC | 27695
UNC Asheville | Gravely | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | Williford | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Chapel Hill | NC | 27599
UNC Charlotte | Coppola | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | Carrigan | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Post Office Box 26170 |  | Greensboro | NC | 27402
UNC Pembroke | Little | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | Castellino | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts | [NAME] | Xiaoyun | [EMAIL] | [PHONE] | [PHONE] | 1533 South Main St. |  | Winston-Salem | NC | 27127
Western Carolina University | Metz | Timothy | [EMAIL] | [PHONE] |  |  |  | Cullowhee | NC | 28723
Winston-Salem State University | Mussat-Whitlow | Becky | [EMAIL] | [PHONE] | [PHONE] | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics | Coltrane | Geoff | [EMAIL] | [PHONE] | [PHONE] | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: 67501d1268125484-how-to-separate-data-from-1-column-to-3-column-1-column-to-3-column
Sheet: Sheet1

06660 |  |  |  |  | 06660
SUREUP 42300 NASIR |  |  |  | SUREUP | 42300 | NASIR
28500 |  |  |  |  | 28500
SUREUP 01000 AZIMAN |  |  |  | SUREUP | 1000 | AZIMAN
BATU PAHAT |  |  |  |  | BATU PAHAT
26070 |  |  |  |  | 26060
Sureup 15150 [NAME] |  |  |  | SUREUP | 15150 | [NAME]
43650 |  |  |  |  | 43650
SUREUP 02500 WAN |  |  |  | SUREUP | 2500 | WAN
SUREUP 81000 SAMSUDIN |  |  |  | SUREUP | 81000 | SAMSUDIN
SUREUP 48000 WANN |  |  |  | SUREUP | 48000 | WANN
68100 |  |  |  |  | 68100
Sureup 76100 din |  |  |  | SUREUP | 76100 | DIN
IPOH |  |  |  |  | IPOH
BWORTH |  |  |  |  | BWORTH
Spreadsheet: 676923d1589060693-conditional-function-not-producing-results-20200508_forum
Sheet: Therapist

Patient's Full Name:
Therapist:
Period: | 4/6/2020- | 2020-04-10 00:00:00
Behavior | Monday | Tuesday | Wednesday | Thursday | Friday
S&B | 9 | 5 | 4 | 3 | 3
Physical Agression | 10 | 10 | 10 | 10 | 8
Property Destruction | 13 | 10 | 10 | 8 | 11
Tantrums | 8 | 10 | 8 | 10 | 14
Disruption | 10 | 10 | 5 | 5 | 3
Off Task | 6 | 12 | 11 | 7 | 12
Repetitive | 15 | 13 | 5 | 7 | 10
Task Refusal | 80 | 70 | 60 | 50 | 45
Innapropriate Social Interaction | 10 | 10 | 5 | 9 | 9
Spreadsheet: bf823ecb-f6b3-4520-903c-aca124af0048
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
8757 | 69393 | Lino | [NAME] | ITA | 271 | 00:28:45 | 00:00:55 | 00:44:07 | [NAME] | 00:27:53 | 1 | 01:45:16
8757 | 11676 | [NAME] | Rozhkov | RUS | 272 | 00:26:23 | [NAME] | 00:48:48 | 00:02:14 | 00:28:01 | 2 | 01:46:11
Spreadsheet: 189232d1351123271-calculating-value-between-two-points-solar102412
Sheet: Sept

 |  | Service Dates: |  | 2011-09-01 00:00:00 |  |  | thru | 2011-10-01 00:00:00
 | PG&E RATES
 | T1 |  | T2 |  | T3 |  | T4 |  | T5
 | Baseline |  | 1.01 | 1.3 | 131-200% |  | 201-300% |  | 301%+
 | 1083.078 |  | 1083.078 | 1408.0014 | 1408.0014 | 2166.156 | 2166.156 | 3249.234 | 3249.234
 | 0.12845 |  | 0.14602 |  | 0.29561 |  | 0.33561 |  | 0.33561 |  | check total of breakout:
 | 2004.22 |  | 324.9234000000001 |  | 596.2185999999999 |  | 0 |  | 0 |  | 2004.22 | check total consumed - PG&E Rates
 | RATE CHARGES
 | T1 |  | T2 |  | T3 |  | T4 |  | T5
 | 257.442059 |  | 5.708904138000003 |  | 89.18834037399998 |  | 0 |  | 0
 | Total Consumed |  |  | PG&E |  |  |  | Solar
 | 2004.22 |  |  | 1462 |  |  |  | 542.6600000000001
 | Total Charges |  |  | PG&E |  |  |  | Solar Savings
 |  |  |  | Billed |  | Min
 | 352.339303512 |  |  | 202.95 |  | 4.58 |  | 144.809303512
 |  |  |  |  | 207.53
 | Date | Solar | Date | Solar | Date | Solar
 | 2012-09-01 00:00:00 | 19.53 | 2012-09-12 00:00:00 | 17.9 | 2012-09-22 00:00:00 | 12.32 |  | Solar | 542.6600000000001
 | 2012-09-02 00:00:00 | 19.11 | 2012-09-13 00:00:00 | 18.52 | 2012-09-23 00:00:00 | 17.75
 | 2012-09-03 00:00:00 | 18.89 | 2012-09-14 00:00:00 | 18.1 | 2012-09-24 00:00:00 | 17.9
 | 2012-09-04 00:00:00 | 19.97 | 2012-09-15 00:00:00 | 18.72 | 2012-09-25 00:00:00 | 18.62 | [NAME] |  | 0.9196118733941946
 | 2012-09-05 00:00:00 | 6.63 | 2012-09-16 00:00:00 | 18.95 | 2012-09-26 00:00:00 | 17.7 | Estimate |  | 590.0967741935484
 | 2012-09-06 00:00:00 | 11 | 2012-09-17 00:00:00 | 18.5 | 2012-09-27 00:00:00 | 17.34 | Actual |  | 542.6600000000001
 | 2012-09-07 00:00:00 | 17.84 | 2012-09-18 00:00:00 | 19.17 | 2012-09-28 00:00:00 | 17.61 | Estimate
 | 2012-09-08 00:00:00 | 17.93 | 2012-09-19 00:00:00 | 19 | 2012-09-29 00:00:00 | 18.72 |  |  | Sep | Oct
 | 2012-09-09 00:00:00 | 18.3 | 2012-09-20 00:00:00 | 18.8 | 2012-09-30 00:00:00 | 18.2 | Proposed Prod |  | 573 | 530
 | 2012-09-10 00:00:00 | 17.2 | 2012-09-21 00:00:00 | 16.65 | 2012-10-01 00:00:00 | 18.06 | Days |  | 30 | 31
 | 2012-09-11 00:00:00 | 17.73 |  |  |  |  | Per Day |  | 19.1 | 17.09677419354839
 |  |  |  |  |  |  | Billed Days |  | 30 | 1
 |  |  |  |  |  |  | Total |  | 573 | 17.09677419354839
 |  |  |  |  |  |  |  | T2 | 921.142
 |  |  |  |  |  |  |  |  | 0.01757
 |  |  |  |  |  |  |  | T3 | 596.2185999999999
 |  |  |  |  |  |  |  |  | 0.14959
 |  |  |  |  |  |  |  | T4 | -161.9359999999999
 |  |  |  |  |  |  |  |  | 0.04000000000000004
Spreadsheet: 871844d1718246001-unique-from-a-and-sum-each-row-from-3rd-column-unique-with-sumif-or-sumifs-1-
Sheet: Sheet1

Name |  |  | Score |  | Score 5 | Score 0
Apple | X | 4 | 1 | 1 |  | 3 |  |  | 4
Grapes | B |  | 1 | 2 | 4 |  |  | Grapes | 3
Oranges | M | 6 | 4 | 7 |  | 4 |  | Apple | 2
Grapes | B |  | 2 | 3 |  | 3
Apple | X | 2 | 1 | 4 | 7
 |  |  |  |  |  |  |  |  | #[NAME]!
[NAME] |  |  |  |  |  |  |  | Grapes | #[NAME]!
 | 0 | Score | 0 | Score 5 | Score 0 |  |  | Oranges | #[NAME]!
Apple | 6 | 2 | 5 | 7 | 3
Grapes | 0 | 3 | 5 | 4 | 3
Oranges | 6 | 4 | 7 | 0 | 4
Spreadsheet: 491859d1480674518-mulitple-rows-to-a-single-column-leave-blanks-out-test-frames
Sheet: TEST1

HeadingA | HeadingB | HeadingC | HeadingD | HeadingE | [NAME]
A1 | B1 | C1 | D1
A2 | B2 | C2 | D2 | E2
A3 | B3 | [NAME]
A4 | B4 | C4 | D4
Spreadsheet: 726429d1617226134-populate-text-from-other-sheet-based-on-number-or-word-entered-reminders
Sheet: Weekly Sign Sheet

Reminders
 |  | 1
Duty |  | Name | Signature
 |  | [NAME]
 | W/M | Ally
Detail Instructions |  | Dre
Weekly Minder: | 1 | [NAME]
Cleaning |  | [NAME]
 |  | Jordan
Safety |  | [NAME]
 |  | [NAME]
Safety Minder: | 1 | Venus
Observe |  | Serena
 |  | Willie
Don’t rush |  | [NAME]
 |  | Sandy
Customer Service: | 1 | Reed
Be interactive |  | [NAME]
 |  | Louis
 |  | [NAME]
 |  | [NAME]
Managers | 1 | [NAME]
Sign in |  | Kenny
 |  | [NAME]
Sign out |  | Blake
 |  | Chirs
Monthly Chat | March | Kris
Attentive |  | [NAME]
 |  | Shay
Punctual |  | Destiny
 |  | [NAME]
 |  | CJ
 |  | [NAME]
 |  | Maria
 |  | Holly
 |  | [NAME]
 |  | [NAME]
Approved By
Week Ending Date
 |  |  |  |  |  | 1
Spreadsheet: 843608d1695389672-vertically-display-column-header-and-row-label-of-cells-with-matching-value-from-a-table-test-index-match-monthly-activity
Sheet: Result

 | 2023-09-01 00:00:00 |  | 2023-10-01 00:00:00 |  | 2023-11-01 00:00:00 |  | 2023-12-01 00:00:00 |  | 2024-01-01 00:00:00 |  | 2024-02-01 00:00:00
 | Floor | Activity | Floor | Activity | Floor | Activity | Floor | Activity | Floor | Activity | Floor | Activity
 | A-UPPER GROUND | Internal Plaster | A-5 | RCC
 | A-2 | Brickwork | A-6 | RCC
 | A-3 | Brickwork
 | A-UPPER GROUND | Internal Plaster
 | A-UPPER GROUND | ELECTRICAL
Spreadsheet: 736230d1623424804-copy-and-combining-duplicate-data-carllogsdon
Sheet: Sheet1

Example of what I am looking for
Year | Month | Customer | # ECIs | Total cost
 |  | Total
2021 | 1 | ELSEVIER INC | 2 | 1.08
2021 | 2 | MINING MEDIA, INC. | 2 | 184.6
2021 | 3 | ENDEAVOR BUSINESS MEDIA LLC | 2 | 0
2021 | 5 | MINING MEDIA, INC. | 2 | 0
2021 | 6 | FAITH CATHOLIC | 2 | 0
Spreadsheet: d38fd49a-00ef-4ee0-a244-f8f6985acc77
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
7973 | 28254 | Pavel | Yakimov | RUS | 25 | 00:25:32 | 00:00:00 | [NAME] | 00:00:00 | 00:29:57 | 1 | 01:25:01
7973 | 28250 | Pavel | Khanzhin | RUS | 26 | 00:25:29 | 00:00:00 | 00:31:17 | 00:00:00 | 00:33:02 | 2 | 01:29:49
7973 | 28394 | Martin | Husek | CZE | 24 | 00:28:33 | 00:00:00 | 00:31:19 | 00:00:00 | 00:32:08 | 3 | 01:32:01
7973 | 49118 | Julian | Erhardt | GER | 29 | 00:25:04 | 00:00:00 | [NAME] | 00:00:00 | 00:34:35 | 4 | 01:33:45
7973 | 21621 | Felix | [NAME] | AUT | 27 | [NAME] | 00:00:00 | 00:32:45 | 00:00:00 | 00:34:21 | 5 | 01:34:25
7973 | 54701 | [NAME] | Ager | GER | 28 | 00:25:37 | 00:00:00 | 00:33:42 | 00:00:00 | 00:39:05 | 6 | 01:38:24
7973 | 54766 | [NAME] | Gschwendner | GER | 30 | 00:27:01 | 00:00:00 | 00:44:39 | 00:00:00 | 00:37:25 | 7 | [NAME]
Spreadsheet: 9d99b48a-fc04-422e-9552-a7da5eaca743
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 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
 |  | Albania, Beverage and tobacco
 |  |  |  |  |  |  |  |  |  |  |  |  | see statistical information for elasticities in the results table
 |  | 2 data points found
 | Author |  | Full citation |  | Source of result |  | Publication date | Data type | Data period | Model |  |  |  | Demand | Property | Cross commodity | Elasticity information |  | Amount
 | Seale et. [NAME]. |  | [NAME], J., A. Regmi, and [NAME]. [International Evidence on Food Consumption Patterns.] United States Department of Agriculture, Economic Research Service. Technical Bulletin Number 1904 |  | Table 11. Unconditional expenditure elasticity for food sub-categories, 114 countries in 1996 |  | 2003 | cross section | 1996 | Florida PI Model |  |  |  | Unconditional | homogeneity, negativity, symmetry | Beverage and tobacco | income |  | 0.95127
 |  |  |  |  | Table 12.  Unconditional Frisch own-price elasticity for food sub categories 114 countries in 1996 |  | 2003 | cross section | 1996 | Florida PI Model |  |  |  | Unconditional | homogeneity, negativity, symmetry | Beverage and tobacco | own price |  | -0.7693
Spreadsheet: 862646d1710315003-look-up-value-based-on-criteria-1st-of-every-month-sample62
Sheet: Sheet1

Date | xxxx2100 | xxxx8192 | xxxx1245 |  | Card | 1/1/2024 | 2/1/2024 | 3/1/2024 | 4/1/2024 | 5/1/2024 | 6/1/2024 | [NAME] | 8/1/2024 | 9/1/2024 | 10/1/2024 | 11/1/2024 | 12/1/2024
2024-01-01 00:00:00 | #N/A | 45 | #N/A |  | xxxx2100 | 109 | 78
2024-01-02 00:00:00 | #N/A | #N/A | 98 |  | xxxx8192 | 45 | 24
2024-01-03 00:00:00 | 109 | 122 | 102 |  | xxxx1245 | 98 | 50
2024-01-04 00:00:00 | 111 | 135 | 105
2024-01-05 00:00:00 | 115 | #N/A | 121
2024-01-06 00:00:00 |  |  | #N/A
2024-01-07 00:00:00
2024-01-08 00:00:00
2024-01-09 00:00:00
2024-01-10 00:00:00 |  | #N/A
2024-01-11 00:00:00
2024-01-12 00:00:00
2024-01-13 00:00:00
2024-01-14 00:00:00
2024-01-15 00:00:00
2024-01-16 00:00:00
2024-01-17 00:00:00
2024-01-18 00:00:00
2024-01-19 00:00:00
2024-01-20 00:00:00
2024-01-21 00:00:00
2024-01-22 00:00:00
2024-01-23 00:00:00
2024-01-24 00:00:00
2024-01-25 00:00:00
2024-01-26 00:00:00
2024-01-27 00:00:00
2024-01-28 00:00:00
2024-01-29 00:00:00
2024-01-30 00:00:00 | 78
2024-01-31 00:00:00 | #N/A | 24 | 50
2024-02-01 00:00:00 | #N/A | #N/A | #N/A
2024-02-02 00:00:00 | #N/A | #N/A | #N/A
2024-02-03 00:00:00 | #N/A | 142 | 100
2024-02-04 00:00:00 | #N/A | 156 | 109
2024-02-05 00:00:00 | 112 | 182
2024-02-06 00:00:00 | 120
2024-02-07 00:00:00 | 132
2024-02-08 00:00:00
2024-02-09 00:00:00
2024-02-10 00:00:00
2024-02-11 00:00:00
2024-02-12 00:00:00
2024-02-13 00:00:00
2024-02-14 00:00:00
2024-02-15 00:00:00
2024-02-16 00:00:00
2024-02-17 00:00:00
2024-02-18 00:00:00
2024-02-19 00:00:00
2024-02-20 00:00:00
2024-02-21 00:00:00
2024-02-22 00:00:00
2024-02-23 00:00:00
2024-02-24 00:00:00
2024-02-25 00:00:00
2024-02-26 00:00:00
2024-02-27 00:00:00
2024-02-28 00:00:00
2024-02-29 00:00:00
2024-03-01 00:00:00
2024-03-02 00:00:00
2024-03-03 00:00:00
Spreadsheet: 766167d1643789370-read-partial-text-from-another-cell-chas-data-2
Sheet: Sheet1

Project ID | Project Manager | Phase | ParentTaskName | TaskName | [NAME] | New Detail | TaskEarlyStart | TaskFinishDate | TaskDuration | Complete
1 | A | #N/A | Design Phase | SG3 Board (is booked) | SG3 |  | 2022-01-19 08:00:00 | 2022-01-19 08:00:00 | 0 | Yes
2 | B | #N/A | Handover & Closure | SG5 - Project Closure | SG5 |  | 2022-01-12 17:00:00 | 2022-01-12 17:00:00 | 0 | Yes
3 | C | #N/A | Build Phase | Build Phase Complete - SG4 | SG4 |  | 2022-01-21 17:00:00 | 2022-01-21 17:00:00 | 0 | No
4 | D | #N/A | Transition (Handover and Closure) Phase | Warranty | Warranty |  | 2022-01-24 08:00:00 | 2022-02-18 17:00:00 | 160 | No
5 | E | #N/A | Milestones | Go Live | Go Live |  | 2022-01-25 17:00:00 | 2022-01-25 17:00:00 | 0 | No
6 | G | #N/A | Delivery Phase SG4 | Build Phase Complete - SG4 | SG4 |  | 2022-01-13 17:00:00 | 2022-01-13 17:00:00 | 0 | No
7 | G | #N/A | Build Phase | Build Phase Complete - SG4 | SG4 |  | 2022-01-27 17:00:00 | 2022-01-27 17:00:00 | 0 | No
Spreadsheet: 776005d1649433889-combine-two-or-more-columns-with-spaces-together-column-combine-test
Sheet: Sheet1

2021-12-20 00:00:00 | 17:26:00
 |  | 2021-12-20 00:00:00 | 00:02:00
2021-12-21 00:00:00 | 13:24:00
 |  | 2021-12-21 00:00:00 | 19:37:00
2021-12-21 00:00:00 | 20:00:00
 |  | 2021-12-21 00:00:00 | 23:31:00
2021-12-22 00:00:00 | 19:59:00
 |  | 2021-12-22 00:00:00 | 23:33:00
2021-12-22 00:00:00 | 13:28:00
 |  | 2021-12-22 00:00:00 | 19:31:00
2021-12-23 00:00:00 | 13:24:00
 |  | 2021-12-23 00:00:00 | 19:34:00
2021-12-23 00:00:00 | 20:00:00
 |  | 2021-12-23 00:00:00 | 21:23:00
2021-12-28 00:00:00 | 13:26:00
 |  | 2021-12-28 00:00:00 | 14:23:00
2021-12-28 00:00:00 | 15:06:00
 |  | 2021-12-28 00:00:00 | 20:18:00
2021-12-28 00:00:00 | 20:44:00
 |  | 2021-12-28 00:00:00 | 00:31:00
2021-12-29 00:00:00 | 13:25:00
 |  | 2021-12-29 00:00:00 | 20:17:00
2021-12-29 00:00:00 | 20:45:00
 |  | 2021-12-29 00:00:00 | 00:33:00
2021-12-30 00:00:00 | 20:00:00
 |  | 2021-12-30 00:00:00 | 21:01:00
2021-12-30 00:00:00 | 13:28:00
 |  | 2021-12-30 00:00:00 | 19:36:00
2022-01-04 00:00:00 | 13:24:00
 |  | 2022-01-04 00:00:00 | 19:32:00
2022-01-04 00:00:00 | 20:00:00
 |  | 2022-01-04 00:00:00 | 00:31:00
2022-01-05 00:00:00 | 13:23:00
Spreadsheet: 692666d1598491407-max-value-on-cell-from-the-list-h1-h8-max-value
Sheet: Sheet1

 |  |  |  | To | T' (A) | T (A) | T∞
 |  |  | 1 | 30 | 20
 |  |  | 2 | 27 | 20
 |  |  | 1 | 63 | 20
 |  |  | 0 | 51 | 20
 |  |  | 0
 |  |  | 5 | 37 | 20
 |  |  | 1 | 42 | 20
 |  |  |  |  |  |  | What is he formula to select [NAME] from h1:h8?
Spreadsheet: 888171d1738622774-giving-a-start-date-based-on-certain-criteria-datescheck1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # of months gap | 3
 |  | Earliest |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Most Recent | Answer Required
 |  | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date to start counting # of products from
 | Product A | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 7 | 8 | 10 | 7 | 2 | 0 | 0 | 3 | 4 | 7 | 0 | 8 | 9 | 12 | 1 | 9
 | Product B | 1 | 12 | 13 | 1 | 45 | 5 | 6 | 12 | 8 | 3 | 3 | 88 | 1 | 8 | 4 | 1 | 1 | 2 | 3 | 8 | 7 | 2 | 6 | 9
 | Product C | 0 | 7 | 1 | 98 | 0 | 0 | 56 | 22 | 71 | 7 | 3 | 1 | 1 | 3 | 9 | 0 | 0 | 0 | 3 | 2 | 6 | 7 | 3 | 3
 | Product D | 4 | 0 | 0 | 8 | 8 | 7 | 0 | 0 | 3 | 44 | 55 | 1 | 0 | 0 | 1 | 2 | 2 | 5 | 8 | 2 | 0 | 12 | 0 | 17
Spreadsheet: michelle_lokay__26805__imbalsumm
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
 | 500168 | Westar Ward
 | Scheduled | Measured
1 | 36064 | 33263
2 | 36793 | 36301
3 | 65652 | 67062
4 | 51791 | 49272
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
index
2000-07-31 00:00:00 |  |  | 193332.51
2000-08-04 00:00:00
Spreadsheet: 677844d1589552580-group-and-transpose-data-ors-ancestor-id-with-rating-may-15-2020-1-
Sheet: ORS Ancestor ID with Rating

client_id | rev_timein | answer
1040 | 2020-04-08 08:59:00 | 30
1083 | 2020-02-26 10:30:00 | 20
1083 | 2020-03-04 10:30:00 | 20
1083 | 2020-03-30 14:00:00 | 19
1083 | 2020-04-27 14:00:00 | 21
1083 | 2020-05-11 13:00:00 | 29
1089 | 2020-03-30 15:00:00 | 28
1089 | 2020-04-30 14:00:00 | 28
1145 | 2020-03-11 14:35:00 | 14
1145 | 2020-04-08 14:02:00 | 14
1145 | 2020-04-24 13:05:00 | 15
1170 | 2020-03-27 09:50:00 | 30
1170 | 2020-04-22 13:12:00 | 32
1192 | 2020-03-25 11:00:00 | 35
1192 | 2020-03-06 12:00:00 | 31
1192 | 2020-04-16 12:00:00 | 25
1235 | 2020-03-13 10:01:00 | 20
1244 | 2020-04-21 13:00:00 | 23
1244 | 2020-05-08 08:30:00 | 17
1267 | 2020-02-21 15:00:00 | 20
1308 | 2020-03-20 15:04:00 | 33
1311 | 2020-02-25 11:15:00 | 27
1311 | 2020-03-05 12:00:00 | 30
1311 | 2020-03-09 14:00:00 | 31
1311 | 2020-03-13 13:00:00 | 32
1311 | 2020-04-02 16:30:00 | 23
1311 | 2020-04-22 14:30:00 | 22
1311 | 2020-04-29 14:30:00 | 24
1330 | 2020-02-21 11:48:00 | 34
1330 | 2020-03-02 11:32:00 | 28
1330 | 2020-03-13 12:26:00 | 30
1339 | 2020-03-30 10:08:00 | 40
1361 | 2020-03-31 14:00:00 | 25
1361 | 2020-04-14 09:30:00 | 20
1361 | 2020-04-27 09:30:00 | 15
1361 | 2020-05-12 09:30:00 | 19
Spreadsheet: 50486d1249934900-help-league-table-laegue-table-template
Sheet: Sheet1

 | player | points | Not the best way but I would do it like this. |  |  |  |  |  |  |  |  |  | Helper numbers
 |  |  |  |  |  |  |  |  |  |  |  |  | 1e-06
team_1 | player 1 | 3 |  | team_2 | player 1 | 43 |  |  | CURRENT TABLE> |  |  |  |  |  | Helper table.
 | player 2 | 3 |  |  | player 2 | 3 |  |  | Teams | Points |  |  |  |  | team_1
 | player 3 | 3 |  |  | player 3 | 3 |  |  |  |  |  |  |  |  | team_2
 | player 4 | 3 |  |  | player 4 | 3 |  |  |  |  |  |  |  |  | team_3
 | player 5 | 3 |  |  | player 5 | 3 |  |  |  |  |  |  |  |  | team_4
 | player 6 | 3 |  |  | player 6 | 3
 | player 7 | 3 |  |  | player 7 | 3
 | player 8 | 3 |  |  | player 8 | 34
 | player 9 | 3 |  |  | player 9 | 3
 | player 10 | 3 |  |  | player 10 | 3
 | player11 | 3 |  |  | player11 | 3
 | total |  |  |  | total
team_3 | player 1 | 3 |  | team_4 | player 1 | 3
 | player 2 | 4 |  |  | player 2 | 3
 | player 3 | 3 |  |  | player 3 | 3
 | player 4 | 3 |  |  | player 4 | 3
 | player 5 | 3 |  |  | player 5 | 4
 | player 6 | 3 |  |  | player 6 | 3
 | player 7 | 3 |  |  | player 7 | 3
 | player 8 | 44 |  |  | player 8 | 3
 | player 9 | 3 |  |  | player 9 | 3
 | player 10 | 3 |  |  | player 10 | 3
 | player11 | 3 |  |  | player11 | 3
 | total |  |  |  | total
Spreadsheet: mark_taylor__24725__ClickInTradingProducts
Sheet: Liquids

Short Description Boxes for Global Liquids
Financial |  | Location |  | Basis |  | [NAME] |  | Size |  | Term |  | Settlement Index |  | Currency |  | Units
Swap |  | ARA |  | CIF |  | 0.035 |  | Cargo |  | 1999-06-01 00:00:00 |  | Platt's |  | USD |  | mt
 |  | MED |  | FOB |  | 0.01 |  | Barge |  | 1999-07-01 00:00:00 |  | IPE |  | GBP |  | cm
 |  |  |  | C&F |  | 0.02 |  |  |  | Q3-99 |  |  |  | EUR
 |  |  |  |  |  | 0.002 |  |  |  | Q4-99
 |  |  |  |  |  | 0.0005 |  |  |  | Q1-00
 |  |  |  |  |  |  |  |  |  | Q2-00
 |  |  |  |  |  |  |  |  |  | Q3-00
 |  |  |  |  |  |  |  |  |  | Q4-00
 |  |  |  |  |  |  |  |  |  | Cal Year 2000
 |  |  |  |  |  |  |  |  |  | Cal Year 2001
Notes: | Options are all tailored to a customer => cannot be traded online
 | Market is all physically driven => not enough liquidity in the OTC financial market, it is all traded on IPE. Specific products are to be confirmed with senior manager.
 | Long descriptions should be filled in only after specific products for online trading are identified.
 | People to talk to about other liquids products: |  |  |  | [NAME]
 |  |  |  |  | [NAME]
Spreadsheet: 717476d1612690487-numbering-returned-matches-in-array-by-date-excel-forum-example-ans
Sheet: Sheet1

Item | Position | Type | Date | Helper | Desired Outcome |  |  |  | Desired Outcome
10000 | 1
10003 | 1 | [NAME] | 2021-01-04 00:00:00 |  |  |  |  |  | 1
10005 | 1 | [NAME] | 2021-01-02 00:00:00 |  |  |  |  |  | 1
10004 | 1
10004 | 2
10003 | 1 | Apple | 2021-01-15 00:00:00 |  |  |  |  |  | 1
10001 | 1
10007 | 1
10003 | 1 | Apple | 2021-02-01 00:00:00 |  |  |  |  |  | 2
9865 | 1
10008 | 1
10009 | 1
10005 | 1 | Apple | 2021-02-02 00:00:00 |  |  |  |  |  | 1
10003 | 1 | Apple | 2021-02-06 00:00:00 |  |  |  |  |  | 3
10005 | 1 | Apple | 2021-02-09 00:00:00 |  |  |  |  |  | 2
10010 | 1
10010 | 2
10010 | 3
10011 | 1
Spreadsheet: 220042d1363038875-list-within-list-list-in-list
Sheet: Sheet1

Alaska |  |  | All States | States Without Operations
 | or |  | Alabama | Alaska
 |  |  | Alaska | Arkansas
 |  |  | Arizona | Hawaii
 |  |  | Arkansas | Indiana
 |  |  | California | Kansas
 |  |  | Colorado | Louisiana
 |  |  | Connecticut | Mississippi
 |  |  | Delaware | New Hampshire
 |  |  | Florida | North Dakota
 |  |  | Georgia | Vermont
 |  |  | Hawaii
 |  |  | Idaho
 |  |  | Illinois
 |  |  | Indiana
 |  |  | Iowa
 |  |  | Kansas
 |  |  | Kentucky
 |  |  | Louisiana
 |  |  | Maine
 |  |  | Maryland
 |  |  | Massachusetts
 |  |  | Michigan
 |  |  | Minnesota
 |  |  | Mississippi
 |  |  | Missouri
 |  |  | Montana
 |  |  | Nebraska
 |  |  | Nevada
 |  |  | New Hampshire
 |  |  | New Jersey
 |  |  | New Mexico
 |  |  | New York
 |  |  | North Carolina
 |  |  | North Dakota
 |  |  | Ohio
 |  |  | Oklahoma
 |  |  | Oregon
 |  |  | Pennsylvania
 |  |  | Rhode Island
 |  |  | South Carolina
 |  |  | South Dakota
 |  |  | Tennessee
 |  |  | Texas
 |  |  | Utah
 |  |  | Vermont
 |  |  | Virginia
 |  |  | Washington
 |  |  | West Virginia
 |  |  | Wisconsin
 |  |  | Wyoming