tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0045db68-1f26-4131-b78e-f3b0e6c975ed
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | IMPERIAL VALLEY COLLEGE | Unnamed: 3 | Unnamed: 4
 |  | WOMEN'S CROSS COUNTRY SCHEDULE
 |  | FALL 2013
DATE | DAY | MEET | PLACE | TIME
SEPT 6 | FRI | [NAME] | [NAME], Oceanside | 12:30:00
SEPT 13 | FRI | So Cal Preview | Central Park, Santa Clarita | 09:30:00
SEPT 21 | SAT | Orange Coast Classic | Fairview Park, Costa Mesa | 09:30:00
OCT  5 | SAT | San Diego Invitational | Mission Bay        San Diego | 10:00:00
OCT  18 | FRI | Mt. SAC. Invitational | Mt. SAC College,Walnut | 10:00:00
NOV 1 | FRI | [NAME] | Morely Field,    San Diego | 13:15:00
NOV  9 | SAT | So Cal Championships | Central Park, Santa Clarita | 11:00:00
NOV 23 | SAT | CA State Championships | [NAME], Fresno | 10:00:00
[NAME] |  | Head Coach | (760) 355-6522
[NAME] |  | Assistant  Coach | (760) 355-6522
[NAME] |  | Athletic Director | (760) 355-6341
[NAME] |  | Secretary | (760) 355-6325
[NAME] |  | Athletic Trainer | (760) 355-6329
 |  | Athletic Fax | (760) 355-6514
 |  | Athletic Department 380 East Aten Rd. Imperial, CA 92251
Spreadsheet: 696861d1601016163-fomula-to-display-average-of-last-12-months-data-metric-excel
Sheet: Maintenance  Graph

Mining Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], 6MM TRIFR & Reportable Injuries
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | 12MM TRIFR | 6MM TRIFR | LTI- Actual | RWC- Actual | MTI - Actual | TRIFR Target | Employee | Business Partner | TRI Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 695446d1600217542-to-have-a-sum-of-days-from-multiple-column-and-reference-need-help
Sheet: Sheet1

 | Can help how to automate the data? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completion Date |  |  |  | Number of Days to [NAME]
 | Attendance | 2020-09-12 00:00:00 | 2020-09-11 00:00:00 | 2020-09-10 00:00:00 | 2020-09-09 00:00:00 | 2020-09-08 00:00:00 | 2020-09-07 00:00:00 | 2020-09-06 00:00:00 | 2020-09-05 00:00:00 | 2020-09-04 00:00:00 | 2020-09-03 00:00:00 | 2020-09-02 00:00:00 | 2020-09-01 00:00:00 | 2020-08-31 00:00:00 | 2020-08-30 00:00:00 | 2020-08-29 00:00:00 | 2020-08-28 00:00:00 | 2020-08-27 00:00:00 | 2020-08-26 00:00:00 | 2020-08-25 00:00:00 | 2020-08-24 00:00:00 | 2020-08-23 00:00:00 |  | Stage 1 | Stage 2 | Stage 3 |  | Stage 1 | Stage 2 | Stage 3
 | Person 1 |  | 1 | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  |  | Absent | Absent |  | 2020-08-28 00:00:00 | 2020-09-05 00:00:00 | 2020-09-11 00:00:00
 | Person 2 |  |  | 1 | 1 | 1 |  |  | 1 | 1 |  |  |  | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  | 2020-08-25 00:00:00 | 2020-08-30 00:00:00 | 2020-09-09 00:00:00
 | Person 3 |  | 1 | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  |  |  |  |  | 2020-08-28 00:00:00 | 2020-09-05 00:00:00 | 2020-09-11 00:00:00
 | Person 4 |  |  | 1 | 1 | 1 |  |  | 1 | 1 |  |  |  | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  | 2020-08-26 00:00:00 | 2020-08-30 00:00:00 | 2020-09-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completion Date |  |  |  | Number of Days to [NAME]
 | Attendance | 2020-09-12 00:00:00 | 2020-09-11 00:00:00 | 2020-09-10 00:00:00 | 2020-09-09 00:00:00 | 2020-09-08 00:00:00 | 2020-09-07 00:00:00 | 2020-09-06 00:00:00 | 2020-09-05 00:00:00 | 2020-09-04 00:00:00 | 2020-09-03 00:00:00 | 2020-09-02 00:00:00 | 2020-09-01 00:00:00 | 2020-08-31 00:00:00 | 2020-08-30 00:00:00 | 2020-08-29 00:00:00 | 2020-08-28 00:00:00 | 2020-08-27 00:00:00 | 2020-08-26 00:00:00 | 2020-08-25 00:00:00 | 2020-08-24 00:00:00 | 2020-08-23 00:00:00 |  | Stage 1 | Stage 2 | Stage 3 |  | Stage 1 | Stage 2 | Stage 3
 | Person 1 |  | 1 | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  |  | Absent | Absent |  | 2020-08-28 00:00:00 | 2020-09-05 00:00:00 | 2020-09-11 00:00:00
 | Person 2 |  |  | 1 | 1 | 1 |  |  | 1 | 1 |  |  |  | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  | 2020-08-25 00:00:00 | 2020-08-30 00:00:00 | 2020-09-09 00:00:00 |  | 1 | 3 | 5
 | Person 3 |  | 1 | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  |  |  |  |  | 2020-08-28 00:00:00 | 2020-09-05 00:00:00 | 2020-09-11 00:00:00 |  | 1 | 4 | 4
 | Person 4 |  |  | 1 | 1 | 1 |  |  | 1 | 1 |  |  |  | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  | 2020-08-26 00:00:00 | 2020-08-30 00:00:00 | 2020-09-10 00:00:00 |  | 2 | 2 | 6
Spreadsheet: 217752d1362168626-extract-numbers-from-a-alphanumeric-cell-extracting-numbers-from-cell
Sheet: Sheet1

 | Erf | Portion | Town
ERF 3544 OF BRYANSTON EXT.8
ERF 3547 OF BRYANSTON EXT.8
ERF 3576 OF BRYANSTON EXT.8
ERF 3583 OF BRYANSTON EXT.8
ERF 3588 OF BRYANSTON EXT.8
ERF 3592 OF BRYANSTON EXT.8
ERF 3593 OF BRYANSTON EXT.8
ERF 3594 OF BRYANSTON EXT.8
ERF 3595 OF BRYANSTON EXT.8
ERF 3598 OF BRYANSTON EXT.8
ERF 3627 OF BRYANSTON EXT.8
ERF 3634 OF BRYANSTON EXT.8
ERF 3640 OF BRYANSTON EXT.8
ERF 3648 OF BRYANSTON EXT.8
ERF 3666 OF BRYANSTON EXT.8
ERF 3675 OF BRYANSTON EXT.8
ERF 3681 OF BRYANSTON EXT.8
ERF 3691 OF BRYANSTON EXT.8
ERF 3733 OF BRYANSTON EXT.8
ERF 3739 OF BRYANSTON EXT.8
ERF 3757 OF BRYANSTON EXT.8
ERF 3758 OF BRYANSTON EXT.8
ERF 3770 OF BRYANSTON EXT.8
ERF 3779 OF BRYANSTON EXT.8
ERF 3780 OF BRYANSTON EXT.8
ERF 3782 OF BRYANSTON EXT.8
PORTION 1 OF ERF 3599 OF BRYANSTON EXT.8
PORTION 1 OF ERF 3748 OF BRYANSTON EXT.8
PORTION 12 OF ERF 4128 OF BRYANSTON EXT.8
PORTION 12 OF ERF 4309 OF BRYANSTON EXT.8
PORTION 13 OF ERF 4128 OF BRYANSTON EXT.8
PORTION 14 OF ERF 4128 OF BRYANSTON EXT.8
PORTION 2 OF ERF 3747 OF BRYANSTON EXT.8
PORTION 2 OF ERF 3752 OF BRYANSTON EXT.8
PORTION 2 OF ERF 4309 OF BRYANSTON EXT.8
PORTION 3 OF ERF 4309 OF BRYANSTON EXT.8
PORTION 9 OF ERF 4128 OF BRYANSTON EXT.8
REM OF ERF 3523 OF BRYANSTON EXT.8
REM OF ERF 3530 OF BRYANSTON EXT.8
REM OF ERF 3540 OF BRYANSTON EXT.8
REM OF ERF 3600 OF BRYANSTON EXT.8
REM OF ERF 3745 OF BRYANSTON EXT.8
REM OF ERF 3748 OF BRYANSTON EXT.8
REM OF ERF 4128 OF BRYANSTON EXT.8
REM OF PORTION 2 OF ERF 4127 OF BRYANSTON EXT.8
Spreadsheet: 729520d1619141918-creating-a-new-permit-register-permit-register-example-2-emma-22-4-21
Sheet: ABC Job Register

ABC Job Number | Address | Job Description | Client | Job Received | Quote Sent | Date of Confirmation  to Proceed | Permit Number | BP | OP | Job Notes | Oustanding Documents | Invoice Date
ABC-21001 | Address 1 | Description 1 | Client 1 | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | 2021-02-05 00:00:00 | 123/123/123 | 2021-03-01 00:00:00 | 2021-03-01 00:00:00
ABC-21002 | Address 2 | Description 2 | Client 2 | 2021-02-05 00:00:00 | 2021-02-06 00:00:00
ABC-21003 | Address 3 | Description 3 | Client 3 | 2021-02-10 00:00:00 | 2021-02-11 00:00:00 | 2021-02-15 00:00:00 | 456/456/456 | 2021-03-01 00:00:00 | 2021-03-01 00:00:00
ABC-21004 | Address 4 | Description 4 | Client 4 | 2021-02-15 00:00:00 | 2021-02-16 00:00:00 | 2021-02-20 00:00:00 | 789/789/789 | 2021-03-01 00:00:00 | OP |  | Waiting on Plumbing cert
ABC-21005 | Address 5 | Description 5 | Client 5 | 2021-02-20 00:00:00 | 2021-02-21 00:00:00 | 2021-02-25 00:00:00 | 001/123/001 | 2021-03-05 00:00:00 | AMDT OP
ABC-21006 | Address 6 | Description 6 | Client 6 | 2021-02-25 00:00:00 | 2021-02-26 00:00:00 | 2021-02-28 00:00:00 | 002/456/002 | 2021-03-05 00:00:00 | READY
ABC-21007 | Address 7 | Description 7 | Client 7 | 2021-03-01 00:00:00 | 2021-03-02 00:00:00 | 2021-03-05 00:00:00 | 003/789/003 | 2021-04-01 00:00:00 | READY
ABC-21008 | Address 8 | Description 8 | Client 8 | 2021-03-05 00:00:00 | 2021-03-06 00:00:00 | 2021-03-10 00:00:00 | 004/999/456 | READY
ABC-21009 | Address 9 | Description 9 | Client 9 | 2021-03-10 00:00:00 | 2021-03-11 00:00:00 | 2021-03-15 00:00:00 | 789/000/001 | READY
ABC-21010 | Address 10 | Description 10 | Client 10 | 2021-03-15 00:00:00 | 2021-03-16 00:00:00
ABC-21011 | Address 11 | Description 11 | Client 11 | 2021-03-20 00:00:00 | 2021-03-21 00:00:00 | 2021-03-25 00:00:00 |  | BP |  | Waiting on $ value from client 30/3
ABC-21012 | Address 12 | Description 12 | Client 12 | 2021-03-25 00:00:00 | 2021-03-26 00:00:00 | 2021-03-30 00:00:00 | 654/654/654 | BP Stage 2
ABC-21013 | Address 13 | Description 13 | Client 13 | 2021-03-30 00:00:00 | 2021-03-31 00:00:00 | 2021-04-01 00:00:00 | 987/987/987 | BP
ABC-21014 | Address 14 | Description 14 | Client 14 | 2021-04-01 00:00:00 | 2021-04-02 00:00:00
ABC-21015 | Address 15 | Description 15 | Client 15 | 2021-04-05 00:00:00 | 2021-04-06 00:00:00 | 2021-04-05 00:00:00 | 321/321/321 | BP
ABC-21016 | Address 16 | Description 16 | Client 16 | 2021-04-10 00:00:00 | 2021-04-11 00:00:00 | 2021-04-15 00:00:00 |  | Out of Area BP
ABC-21017 | Address 17 | Description 17 | Client 17 | 2021-04-15 00:00:00 | 2021-04-16 00:00:00
ABC-21018 | Address 18 | Description 18 | Client 18 | 2021-04-20 00:00:00 | 2021-04-21 00:00:00 | 2021-04-22 00:00:00 |  | BP
ABC-21019 | Address 19 | Description 19 | Client 19
ABC-21020 | Address 20 | Description 20 | Client 20
ABC-21021
ABC-21022
ABC-21023
ABC-21024
ABC-21025
ABC-21026
ABC-21027
ABC-21028
ABC-21029
ABC-21030
ABC-21031
ABC-21032
ABC-21033
ABC-21034
ABC-21035
ABC-21036
ABC-21037
ABC-21038
ABC-21039
ABC-21040
ABC-21041
ABC-21042
ABC-21043
ABC-21044
ABC-21045
Spreadsheet: 720967d1614401608-formula-weekends-excel-2-ans
Sheet: data

ID | TASK DESCRIPTION | TASK DURATION | PROJECT START DATE | PROJECT END DATE
1 | ABC | 3 | 2021-02-10 00:00:00
2 | DEF | 9
3 | GHI | 12
4 | JKL | 24
5 | MNO | 10
6 | PQR | 14
7 | STU | 15
8 | VWX | 16
9 | YZ1 | 5
10 | 123 | 8
11 | 456 | 4
Spreadsheet: 700597d1603263709-highlight-highest-value-in-row-excel-highlight-highest-value-sample
Sheet: Sheet1

Simple
1 | 2 | 3 | 4
2 | 3 | 4 | 5
3 | 4 | 5 | 6
4 | 5 | 6 | 7
5 | 6 | 7 | 8
6 | 7 | 8 | 9
7 | 8 | 9 | 10
8 | 9 | 10 | 11
9 | 10 | 11 | 12
Complex (only some colums eg a, c, f & j to be checked for highest value)
1 |  | 2 |  |  | 3 |  |  |  | 4
2 |  | 3 |  |  | 4 |  |  |  | 5
3 |  | 4 |  |  | 5 |  |  |  | 6
4 |  | 5 |  |  | 6 |  |  |  | 7
5 |  | 6 |  |  | 7 |  |  |  | 8
6 |  | 7 |  |  | 8 |  |  |  | 9
7 |  | 8 |  |  | 9 |  |  |  | 10
8 |  | 9 |  |  | 10 |  |  |  | 11
9 |  | 10 |  |  | 11 |  |  |  | 12
Spreadsheet: 159908d1338900897-excel-2007-counting-values-and-unique-values-within-a-1-minute-time-interval-counting
Sheet: Sheet1

Time | Item |  | Time Interval | Unique Items
15:01:01 | 1000 |  | 15:01:00 - 15:01:59 | 4
15:01:15 | 2000 |  | 15:02:00 - 15:02:59 | 2
15:01:30 | A400 |  | 15:03:00 - 15:03:59 | 1
15:01:45 | B200 |  | 15:04:00 - 15:04:59 | 3
15:02:01 | 1000 |  | 15:05:00 - 15:05:59 | 2
15:02:15 | B200
15:02:30 | B200
15:02:45 | 1000
15:03:01 | 1000
15:03:09 | 1000
15:03:11 | 1000
15:03:15 | 1000
15:03:30 | 1000
15:03:45 | 1000
15:04:01 | 2000
15:04:15 | 3000
15:04:30 | 4000
15:05:02 | A500
15:05:15 | B500
15:05:45 | B500
 |  |  | Time Interval | Item Counts
 |  |  | 15:01:00 - 15:01:59 | 4
 |  |  | 15:02:00 - 15:02:59 | 4
 |  |  | 15:03:00 - 15:03:59 | 6
 |  |  | 15:04:00 - 15:04:59 | 3
 |  |  | 15:05:00 - 15:05:59 | 3
Spreadsheet: 727735d1618062582-countif-equivalent-in-power-p-vot-power-pivot-sumif
Sheet: Sheet3

 | 1 | 3 | 59 | 83 | 84 | 88
 | Pick 1 | Pick 2 | Pick 3 | Pick 4 | Pick 5 | Pick 6 | Match
 | 75 | 28 | 14 | 58 | 45 | 63
 | 69 | 25 | 5 | 68 | 36 | 46
 | 25 | 64 | 56 | 16 | 33 | 68
 | 56 | 52 | 28 | 13 | 22 | 66
 | 1 | 31 | 12 | 20 | 4 | 72
 | 38 | 90 | 45 | 60 | 70 | 76
 | 51 | 33 | 56 | 1 | 45 | 21
 | 84 | 8 | 41 | 85 | 76 | 34
 | 37 | 6 | 52 | 61 | 22 | 11
 | 88 | 7 | 9 | 11 | 44 | 54
Spreadsheet: 71472d1272210040-creating-a-top-performers-table-hitsquad2
Sheet: blank week

 |  | THE HIT CLUB
 |  | Monday |  |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
TEAMS
 | Player | Hits | Points |  | Hits | Points | Hits | Points | Hits | Points | Hits | Points | Hits | Points | Hits | Points
Cubie |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Dwayne |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Kent |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Nate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Scott |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 766876d1644135103-stock-closing-prices-w-o-data-types-data-from-web-imported-aligw
Sheet: Table 2

New TSP Lifecycle Funds 7/1/2020 - 2/4/2022 | TSP L 2025 Fund | TSP L 2035 Fund | TSP L 2045 Fund | TSP L 2055 Fund | TSP L 2060 Fund | TSP L 2065 Fund
Last Price (2/4/2022) | 11.9423 | 12.6177 | 13.0540 | 14.0488 | 14.0484 | 14.0481
Change (1-Day) | 0.15% | 0.25% | 0.30% | 0.45% | 0.45% | 0.45%
YTD Return | -2.49% | -3.85% | -4.52% | -5.60% | -5.60% | -5.61%
1-Year Return | 5.44% | 6.85% | 7.56% | 9.64% | 9.63% | 9.63%
Annual Return Since 7/1/2020 | 11.8% | 15.7% | 18.2% | 23.7% | 23.7% | 23.7%
Annualized Standard Deviation | 6.3% | 8.9% | 10.4% | 13.4% | 13.4% | 13.4%
Maximum Drawdown | -4.2% | -6.5% | -7.7% | -9.7% | -9.7% | -9.7%
[NAME] | 1.61 | 1.56 | 1.56 | 1.58 | 1.58 | 1.58
Value of $1,000 invested on 7/1/2020 | $1,194 | $1,262 | $1,305 | $1,405 | $1,405 | $1,405
Spreadsheet: 207197d1358391291-count-records-within-a-specified-time-range-prioradmits
Sheet: ALLADMITS

ID | ADMDATE
92472705 | 2009-04-13 00:00:00
92472705 | 2009-12-04 00:00:00
92472705 | 2010-03-16 00:00:00
92603180 | 2011-11-26 00:00:00
92624577 | 2010-10-17 00:00:00
92624577 | 2011-06-27 00:00:00
92718426 | 2011-04-13 00:00:00
92806442 | 2011-06-07 00:00:00
92825069 | 2009-06-26 00:00:00
92825069 | 2009-07-01 00:00:00
92881996 | 2010-12-30 00:00:00
92929433 | 2010-11-08 00:00:00
93059404 | 2009-02-12 00:00:00
93106074 | 2010-06-02 00:00:00
93201203 | 2009-09-24 00:00:00
93201203 | 2010-07-09 00:00:00
93201203 | 2011-07-05 00:00:00
93201203 | 2011-12-22 00:00:00
93223167 | 2010-03-23 00:00:00
93223167 | 2010-05-11 00:00:00
93223167 | 2010-06-25 00:00:00
93255987 | 2009-11-13 00:00:00
93259490 | 2009-05-11 00:00:00
93405659 | 2009-08-22 00:00:00
93428293 | 2009-04-13 00:00:00
93428293 | 2009-09-16 00:00:00
93428293 | 2009-12-21 00:00:00
93478837 | 2009-11-10 00:00:00
93631474 | 2010-09-03 00:00:00
93688919 | 2011-07-11 00:00:00
93781973 | 2011-02-21 00:00:00
93793198 | 2010-02-04 00:00:00
93793198 | 2010-06-24 00:00:00
93793198 | 2011-08-01 00:00:00
93810033 | 2010-04-12 00:00:00
93965164 | 2010-02-16 00:00:00
94037770 | 2011-04-19 00:00:00
94046713 | 2011-07-27 00:00:00
94200725 | 2011-04-18 00:00:00
94283377 | 2010-10-23 00:00:00
94429776 | 2009-06-29 00:00:00
94504024 | 2009-06-22 00:00:00
94605628 | 2010-06-02 00:00:00
94613423 | 2011-03-08 00:00:00
94755089 | 2011-05-18 00:00:00
Spreadsheet: 543928d1508673723-multi-rows-into-single-row-using-power-query-s666-multi-rows-into-single-row-using-power-query
Sheet: Sheet1

Driver Name | Driver ID | Bus Number | School ID | School Name | Timing
[NAME] | 1005 | F005002 | A123 | Helen Model School | 07:15:00
[NAME] | 1005 | F005002 | A300 | Stuart High School | 08:00:00
Driver Name | Driver ID | Bus Number | School ID 1 | School Name 1 | Timing 1 | School ID 2 | School Name 2 |  | Timing 2
[NAME] | 1005 | F005002 | A123 | Helen Model School | 07:15:00 | A300 | Stuart High School |  | 08:00:00
Driver Name.1 | Driver ID.2 | Bus Number.2 | School ID.1 | School Name.1 | Timing.1 | School ID.2 | School Name.2 | Timing.2
[NAME] | 1005 | F005002 | A123 | Helen Model School | 07:15:00 | A300 | Stuart High School | 08:00:00
Spreadsheet: john_lavorato__16496__OGC Cheques - 2000
Sheet: Kelly Trout

Order of [NAME]
Donations for deputy | [NAME]
CompanyName | FirstName | Initial | LastName | As it appears in the Brochure… | Address 1 | Address2 | City | Province | PostalCode | Donation | Category | Tax Receipt to Individual? | notes | Deputy | website address
ICEC Canada Ltd. | Lesley |  | Palmer | ICEC Canada Ltd. | 520, 510 - 5 St SW |  | Calgary | AB | T2P 3S2 | 100 | < 1000 | Company |  | [NAME]
Spreadsheet: c844d4f1-9f4f-4b7f-9592-0b18145c5f6b
Sheet: Sheet1

Release: International Unemployment Rates and Employment Indexes | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=202
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-12-20 12:40 PM CST
 | Real-Time | Period
Name: | Start | End
International Unemployment Rates and Employment Indexes | 2010-11-04 00:00:00 | Current
Link:
http://www.bls.gov/fls/intl_unemployment_rates_monthly.htm | 2010-11-04 00:00:00 | Current
Source:
US. Bureau of Labor Statistics | 2010-11-04 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2010-11-04 00:00:00
2010-12-02 00:00:00
2011-01-06 00:00:00
2011-02-03 00:00:00
2011-03-03 00:00:00
2011-03-31 00:00:00
2011-05-05 00:00:00
2011-06-02 00:00:00
2011-07-07 00:00:00
2011-08-04 00:00:00
2011-09-01 00:00:00
2011-10-06 00:00:00
2011-11-03 00:00:00
2011-12-02 00:00:00
2012-01-05 00:00:00
2012-02-02 00:00:00
2012-03-08 00:00:00
2012-04-05 00:00:00
2012-05-03 00:00:00
2012-05-31 00:00:00
2012-07-05 00:00:00
2012-08-02 00:00:00
2012-09-06 00:00:00
2012-10-05 00:00:00
2012-11-06 00:00:00
2012-12-06 00:00:00
2013-01-03 00:00:00
2013-01-31 00:00:00
2013-03-07 00:00:00
2013-04-04 00:00:00
2013-05-02 00:00:00
2013-06-07 00:00:00
2013-07-03 00:00:00
2013-08-01 00:00:00
Spreadsheet: 200621d1355681358-trying-to-merge-two-formulas-in-one-cell-example
Sheet: Desired Results 

 |  | NAME |  | Results by case |  | Results by case |  | Results by case |  | Results by case
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | DOE
 |  |  |  | ^ |  | ^ |  | ^ |  | ^
 |  |  |  | On these columns |  |  | <<-- TO | I want to join the formulas in these columns.
 |  | To see the desired results (if chosen by me) only in these two columns.
Spreadsheet: 60796d1261392822-excel-2007-ranking-table-div-0-and-n-a-performance-report
Sheet:  14.12.2009

Week Commencing 14th December 2009
 |  |  |  | Not Ready Times |  |  |  |  |  |  | Call Logging
Agent Name |  | 14.12.09 | 15.12.09 | 16.12.09 | 17.12.09 | 18.12.09 | Week Average |  | 14.12.09 | 15.12.09 | 16.12.09 | 17.12.09 | 18.12.09 | Week Average |  | Hang Ups | [NAME] | Long Calls
[NAME] |  | 21.3 | 0 | 0 | 0 | 0 | 0.213 | #N/A
[NAME] |  | 14.9 | 0 | 0 | 13.2 | 13 | 0.137 | #N/A
[NAME] |  | 13 | 15.1 | 0 | 0 | 0 | 0.1405 | #N/A | 0.81
Philip McKeown |  | 0 | 11.3 | 13.5 | 0 | 14.6 | 0.1313333333333333 | #N/A | 0.59 |  | 0.61
[NAME] |  | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0
[NAME] |  | 14.5 | 0 | 0 | 0 | 0 | 0.145 | #N/A
[NAME] |  | 15.7 | 12.6 | 14.4 | 0 | 0 | 0.1423333333333333 | #N/A | 1 |  | 1
[NAME] |  | 0 | 0 | 0 | 0 | 0
[NAME] |  | 18.7 | 17.3 | 0 | 16 | 0 | 0.1733333333333333 | #N/A | 1
[NAME] |  | 0 | 13.6 | 15.5 | 16.5 | 15.3 | 0.15225 | #N/A | 0.85 |  | 0.87
[NAME] |  | 16.4 | 19.2 | 15.9 | 0 | 0 | 0.1716666666666666 | #N/A | 0.69 |  | 0.73
[NAME] |  | 12.9 | 12.4 | 0 | 13.3 | 14.9 | 0.13375 | #N/A | 0.97
Malachy Kelly |  | 15.2 | 18 | 14.3 | 0 | 0 | 0.1583333333333333 | #N/A | 1 |  | 0.93
[NAME] |  | 11.1 | 11.3 | 0 | 12.4 | 12.9 | 0.11925 | #N/A | 1
[NAME] |  | 15.7 | 0 | 0 | 13.9 | 16.1 | 0.1523333333333333 | #N/A
[NAME] |  | 13 | 0 | 13.1 | 14.4 | 0 | 0.135 | #N/A |  |  | 1
[NAME] |  | 0 | 11.2 | 0 | 0 | 0 | 0.112 | #N/A | 0.98
[NAME] |  | 13.1 | 0 | 11.8 | 15.3 | 0 | 0.134 | #N/A |  |  | 0.93
[NAME] |  | 15.4 | 13.9 | 16.5 | 16.8 | 9.1 | 0.1434 | #N/A | 0.93 |  | 0.96
[NAME] |  | 0 | 0 | 0 | 0 | 18.1 | 0.181 | #N/A
[NAME] |  | 15.2 | 13.4 | 13.9 | 0 | 11.5 | 0.135 | #N/A | 0.98 |  | 0.98
[NAME] |  | 13.2 | 14.1 | 13.3 | 14.3 | 13.3 | 0.1364 | #N/A | 1 |  | 1
[NAME] |  | 0 | 0 | 18 | 16.2 | 14.3 | 0.1616666666666667 | #N/A |  |  | 1
[NAME] |  | 12.1 | 11.7 | 13.9 | 0 | 13.1 | 0.127 | #N/A | 1 |  | 0.93
Gemma Donnelly |  | 0 | 11.9 | 0 | 0 | 0 | 0.119 | #N/A
[NAME] |  | 0 | 11.1 | 15.6 | 13.3 | 0 | 0.1333333333333333 | #N/A | 1 |  | 1
[NAME] |  | 11.8 | 14.5 | 14.9 | 0 | 0 | 0.1373333333333333 | #N/A | 0.7 |  | 0.69
[NAME] |  | 16.4 | 15.3 | 0 | 15.1 | 0 | 0.156 | #N/A | 0.83
[NAME] |  | 0 | 0 | 0 | 0 | 13 | 0.13 | #N/A
[NAME] |  | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A
[NAME] |  | 0 | 0 | 20.5 | 19.1 | 16.6 | 0.1873333333333334 | #N/A |  |  | 0.73
 |  |  |  |  |  |  |  | 1
Spreadsheet: 698908d1602243980-tracking-duplicates-across-multiple-columns-cca_repair-reva
Sheet: Sheet1

Part Num | Name | Current Serial Num | Repaired? | New Serial Num
CCA1 | Circuit Card | 3B2 | Y | 3N7
HD1 | Hard Drive | 1HP | Y | 2K4
HD1 | Hard Drive | 2K4 | Y | 7WS
CCA2 | Circuit Card | 9KB | Y | 3KL
CCA1 | Circuit Card | 3N7 | Y | 4RB
HD2 | Hard Drive | 8TO | Y | 6PL
CCA2 | Circuit Card | 3KL | Y | 8ZS
HD1 | Hard Drive | 7WS | Y | 9PP
CCA1 | Circuit Card | 4RB | Y | 5B8
Spreadsheet: 695099d1600051857-need-help-to-insert-a-value-after-multiple-occurrences-of-a-value-sample
Sheet: Sheet1

 |  |  |  |  |  |  | Tq
 |  |  |  |  |  |  | DA
 |  |  |  |  |  |  | WA
 |  |  |  |  |  |  | CH
 |  |  |  |  |  |  | CH
 |  |  |  |  |  |  | KA
 |  |  |  |  |  |  | BA
 |  |  |  |  |  |  | ST
 |  |  |  |  |  |  | NW
 |  |  |  |  |  |  | NY
 |  |  |  |  |  |  | NY
 |  |  |  |  |  |  | NY
 |  |  |  |  |  |  | CA
 |  |  |  |  |  |  | NO
 |  |  |  |  |  |  | GN
 |  |  |  |  |  |  | OA
 |  |  |  |  |  |  | BU
 |  |  |  |  |  |  | IN
 |  |  |  |  |  | 2009.4.14 | CI |  | <--- should NOT be number 1 here as H19 <> H18
 |  |  |  |  |  | 2009.5.1 | CI |  | <--- should NOT be number 1 here as G20 <> G19
 |  |  |  |  |  | 2009.5.1 | CI |  | <--- should be number 1 here as G21 = G20 AND H21 = H20
 |  |  |  |  |  | 2017.3.3 | CA |  | <--- should NOT be number 1 here as H22 <> H21
 |  |  |  |  |  | 2017.3.3 | CA
 |  |  |  |  |  | 2017.3.3 | NO |  | <--- should also be a number 1 here as H23 = H22 AND G23 = G22
 |  |  |  |  |  | 2017.3.4 | BU
 |  |  |  |  |  | 2017.3.4 | DE
 |  |  |  |  |  |  | MI
 |  |  |  |  |  |  | NY
 |  |  |  |  |  |  | TA
 |  |  |  |  |  |  | TA
 |  |  |  |  |  |  | DE
 |  |  |  |  |  |  | SE
 |  |  |  |  |  |  | JA
 |  |  |  |  |  |  | JA
 |  |  |  |  |  |  | SF
 |  |  |  |  |  |  | SF
 |  |  |  |  |  |  | CL
 |  |  |  |  |  |  | CL
 |  |  |  |  |  |  | PI
 |  |  |  |  |  |  | PI
 |  |  |  |  |  |  | PI