tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 834051d1687419843-need-help-to-find-out-code-wise-rate-calculation-code-wise-rate-calculation-revised-single-code-ans
Sheet: Sheet1

 |  |  |  |  |  |  | 2022-09-01 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-02 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-03 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-04 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-05 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-06 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-07 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-08 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-09 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-10 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-11 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-12 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-13 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-14 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-15 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-16 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-17 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-18 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-19 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-20 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-21 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-22 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-23 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-24 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-25 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-26 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-27 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-28 00:00:00 | 20
 |  |  |  |  |  |  | 2022-09-29 00:00:00 | 5
 |  |  |  |  |  |  | 2022-09-30 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-01 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-02 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-03 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-04 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-05 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-06 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-07 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-08 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-09 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-10 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-11 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-12 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-13 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-14 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-15 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-16 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-17 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-18 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-19 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-20 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-21 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-22 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-23 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-24 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-25 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-26 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-27 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-28 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-29 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-30 00:00:00 | 5
 |  |  |  |  |  |  | 2022-10-31 00:00:00 | 5
 |  |  |  |  |  |  | 2022-11-01 00:00:00 | 5
 |  |  |  |  |  |  | 2022-11-02 00:00:00 | 5
Spreadsheet: 730394d1619687441-normalize-rows-to-highest-value-mappe1
Sheet: Tabelle2

Sample 1
Sample 2
Sample 3
Sample 4
Sample 5
Sample 6
Sample 7
Sample 8
Sample 9
Sample 10
Spreadsheet: 0be49541-609e-4a88-ab22-7c91d5b1346a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
2322 | 10289 | Julia | Lucke | GER | 0 | 00:21:52 | [NAME] | 00:26:30 | 00:02:44 | 00:25:23 | 1 | 01:27:21
2322 | 7616 | [NAME] | Springman | GBR | 0 | 00:25:15 | 00:00:20 | 00:28:02 | 00:01:53 | 00:36:00 | 2 | 01:31:35
2322 | 10258 | Claudia | [NAME] | ITA | 0 | 00:27:56 | 00:00:32 | 00:28:15 | 00:01:43 | 00:40:04 | 3 | [NAME]
2322 | 10253 | [NAME] | Ferrari | ITA | 0 | 00:26:27 | 00:00:46 | 00:29:10 | 00:01:39 | 00:49:40 | 4 | 01:47:45
Spreadsheet: 185881d1349870154-sorting-a-spreadsheet-of-data-that-is-consistantly-disorganised-into-organised-columns-employee-list-test
Sheet: POLY

 | EMPLOYEE DETAILS: |  |  |  | DEPARTMENT
 | Name: | [NAME] |  | Active | POLY - SITE
 | Card ID: | CA1 | Gender: | Male | Casual
 |  |  | Date of Birth: | 22/03/1968
 |  |  | Start Date: | 2012-07-18 00:00:00
 |  |  | Hours in pay period: | 76
 | EMPLOYEE DETAILS:
 | Name: | [NAME] |  | Active | POLY - SITE
 | Card ID: | CA2 | Gender: | Male | Casual
 |  |  | Date of Birth: | 22/03/1977
 |  |  | Start Date: | 27/01/2010
 |  |  | Hours in pay period: | 76
 | EMPLOYEE DETAILS:
 | Name: | [NAME] |  | Active | POLY - OFFICE
 | Card ID: | SA1 | Gender: | Male | Salaried
 |  |  | Date of Birth: | 1977-02-11 00:00:00
 |  |  | Start Date: | 2012-02-07 00:00:00
 |  |  | Hours in pay period: | 76
Spreadsheet: john_arnold__15144__Enron - Randy Matson team
Sheet: Enron ecom

 |  |  |  |  |  |  | Product Order Form:  Open System Products |  |  |  |  | Product Order Form #
6
 |  |  |  |  | SUPPORT |  | DESIGNATED CPU |  | PRODUCT | LICENSE FEE
 | SLA # | ITEM# | QUANTITY | PRODUCT DESCRIPTION | B=BASE | TIER | MACHINE TYPE & | MANUFACTURE | EFFECTIVE | UNIT COST | TOTAL COST | INSTALLATION LOCATION
 |  |  |  |  | E=EXTENDED |  | MODEL | # | DATE
 | 5839 | 1 | 99 | Patrol for Unix | E | Ent 1 |  | Sun | 2000-11-30 00:00:00 | 10645
 |  | 2 | 201 | Patrol for Unix | E | Dept |  | Sun | 2000-11-30 00:00:00 | 4200
 |  | 3 | 99 | Patrol Perform for Unix | E | Ent 1 |  | Sun | 2000-11-30 00:00:00 | 5065
 |  | 4 | 99 | Patrol Predict for Unix | E | Ent 1 |  | Sun | 2000-11-30 00:00:00 | 11400
 |  | 5 | 126 | Patrol Perform for Unix | E | Dept |  | Sun | 2000-11-30 00:00:00 | 2000
 |  | 6 | 126 | Patrol Predict for Unix | E | Dept |  | Sun | 2000-11-30 00:00:00 | 4500
 |  | 7 | 4 | Patrol Console | E | N/A |  |  | 2000-11-30 00:00:00 | 3500
 |  |  |  |  |  |  |  |  |  | Less Discount
 |  |  |  |  |  |  |  |  |  | Maintenance
 |  | 8 | 45 | Profressional Services |  |  |  |  | estimate | 2000
 | This Product Order Form is valid through November 30, 2000.
 |  | ACCEPTED BY LICENSOR: BMC Software Distribution, Inc.
 |  |  |  |  |  |  | ACCEPTED BY [NAME]: Company Name
 |  | By: |  |  |  |  | By:
 |  | Name: |  |  |  |  | Name:
 |  | Title: |  |  |  |  | Title:
 |  | Date: |  |  |  |  | Date:
Spreadsheet: 680589d1591099864-time-conversion-with-daylight-savings-time-time-difference-aligw
Sheet: Sheet1

 |  |  |  |  | Time (LOCAL) | Time (UTC/ZULU) |  | Time (LOCAL) | Time (UTC/ZULU) |  | YEAR | START | END
 |  |  |  |  | 1100 |  |  |  | 1600 |  | 2020 | 2020-03-08 00:00:00 | 2020-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2021 | 2021-03-14 00:00:00 | 2021-11-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2022 | 2022-03-13 00:00:00 | 2022-11-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2023 | 2023-03-12 00:00:00 | 2023-11-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2024 | 2024-03-10 00:00:00 | 2024-11-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2025 | 2025-03-09 00:00:00 | 2025-11-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2026 | 2026-03-08 00:00:00 | 2026-11-01 00:00:00
Spreadsheet: 541427d1507285108-help-with-a-formula-to-determine-repeat-customers-and-if-they-upgrade-excelforum-example-1
Sheet: Sheet1

Event Name | Event ID | Order no. | Order Date | Prefix | First Name | Surname | Suffix | [NAME] | Guest Of | Guestlist | Quantity | Ticket Type
Rough [NAME] Saturday | 16442169973 | 413899569 | 2015-04-11 10:28:55.001000 |  | [NAME] | Smith |  | [EMAIL] |  |  | 1 | Launch Special (Group rate) 5KM
Rough [NAME] Saturday | 16442169973 | 414628557 | 2015-04-14 09:42:35.004000 |  | Emma | Edwards |  | [EMAIL] |  |  | 1 | Launch Special (Group rate) 5KM
Rough [NAME] Saturday | 16442169973 | 416185783 | 2015-04-18 17:27:18.996000 |  | Chloe | Bost |  | [EMAIL] |  |  | 1 | Launch Special (Group rate) 5KM
Rough [NAME] 2016 Saturday | 19379527689 | 470693682 | 2015-11-09 06:34:09.002000 |  | [NAME] | Wilson |  | [EMAIL] |  |  | 1 | Launch Special (Individual) 5KM
Rough [NAME] 2016 Saturday | 19379527689 | 470699591 | 2015-11-09 07:53:17.002000 |  | [NAME] | Woods |  | [EMAIL] |  |  | 1 | Launch Special (Group rate) 10KM
Rough [NAME] 2016 Sunday | 19443590302 | 470942041 | 2015-11-09 22:29:50.004000 |  | Dionne | [NAME] |  | [EMAIL] |  |  | 1 | Launch Special (Group rate) 10KM
Rough [NAME] 2016 Sunday | 19443590302 | 471266465 | 2015-11-10 21:41:55 |  | [NAME] | [NAME] |  | [EMAIL] |  |  | 1 | Launch Special (Individual) 5KM
Rough [NAME] 2016 Sunday | 19443590302 | 471551765 | 2015-11-11 19:58:39.999000 |  | [NAME] | [NAME] |  | example{@email6.com |  |  | 1 | Launch Special (Group rate) 10KM
Rough [NAME] - Saturday | 29610777633 | 574376419 | 2016-11-24 16:38:27.997000 |  | Emma | Bassett |  | [EMAIL] |  |  | 1 | Launch Special (Group rate) 5KM
Rough [NAME] - Saturday | 29610777633 | 574389768 | 2016-11-24 17:49:44.996000 |  | Lucie | Rooke |  | [EMAIL] |  |  | 1 | Launch Special (Group rate) 5KM
Rough [NAME] - Saturday | 29610777633 | 574401472 | 2016-11-24 19:00:11.002000 |  | Lyndsey | Bullock |  | [EMAIL] |  |  | 1 | Launch Special (Group rate) 10KM
Spreadsheet: 376658d1423673437-indirect-function-on-this-formula-single-cell-array-formulas
Sheet: Sheet13

Summing rounded values
Description | Quantity | Unit Price | Discount | Total
Widgets | 6 | 11.69 | 0.0523
Sprockets | 8 | 9.74 | 0.0523
Snapholytes | 3 | 9.85 | 0.0523
GRAND TOTAL |  |  |  |  |  | <-- appears to be incorrect
 |  | Sum of rounded values:
Spreadsheet: 178122d1346668460-putting-data-in-other-worksheets-corbinsbere-gundogs-competition
Sheet: Spaniel Open

ENTRANTS NUMBER | HANDLERS NAME | DOGS NAME | TEST 1 | TEST 2 | TEST 3 | SCORE | POSITION
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
4 | [NAME] | Fly | 10 | 9 | 10 | 29 | 2
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
9 | [NAME] | Reba | 17 | 18 | 18 | 53 | 1
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
Spreadsheet: 52811234-5786-4ff7-b2d9-5774e79faca9
Sheet: Sheet1

November 5, 2002                        State Senate District 1 | Gallus, r | Sorlucco, d | Unnamed: 3
Albany | 123 | 104
Atkinson and [NAME]. Gt. | - | -
[NAME] | 784 | 483 | 1
Bean's Grant | - | -
Bean's Purchase | - | -
[NAME] | 664 | 209
[NAME] | 699 | 203
[NAME] 3 | 784 | 281
[NAME] 4 | 546 | 196 | 2
Bethlehem | 441 | 390 | 4
Cambridge | 1 | -
Carroll | 205 | 118
[NAME]'s Purchase | - | -
[NAME] | 67 | 18
Colebrook | 470 | 135 | 1
Columbia | 133 | 48
Crawford's Purchase | - | -
Cutt's Grant | - | -
[NAME] | 223 | 88
Dix's Grant | - | -
Dixville | 16 | 3
Dummer | 100 | 30
Errol | 108 | 14
Erving's Location | - | -
Franconia | 278 | 235 | 1
[NAME] | 806 | 346 | 1
Green's Grant | 2 | 1
Hadley's Purchase | - | -
Hale's Location | 65 | 6
Hart's Location | 13 | 8
[NAME] | 294 | 230 | 1
[NAME] | 283 | 99 | 1
Kilkenny | - | -
Lancaster | 775 | 337
Lincoln | 327 | 163
Lisbon | 273 | 133
Littleton | 1292 | 619 | 8
Livermore | - | -
Low and Burbank's Grant | - | -
[NAME] | 105 | 62
Martin's Location | - | -
Milan | 346 | 89
[NAME] | 14 | -
Northumberland | 365 | 260
[NAME] | - | -
[NAME]'s Grant | - | 2
Pittsburg | 239 | 62
Randolph | 117 | 86
Sargent's Purchase | - | -
Second College Grant | - | -
Shelburne | 119 | 57
[NAME] | 114 | 41
Stewartstown | 131 | 52 | 1
[NAME] | 100 | 78
Success | - | -
[NAME] | 161 | 142 | 1
Thompson & Meserve's Purchase | - | -
Waterville Valley | 83 | 53
Wentworth's Location | 6 | 4
[NAME] | 468 | 248
Totals | 12140 | 5733 | 22
Spreadsheet: 868996d1715692380-pull-data-from-sheet-to-new-sheet-based-on-multiple-criteria-from-another-sheet-in-excel-household-information
Sheet: Sheet1

Household ID | Family Member
6763838 | 4 |  |  |  |  | Household ID | Age | Gender | Recipient Type
9063838 | 6 |  |  |  | Robyn | 6763838 | 12 | Female | Family Member
8950958 | 8 |  |  |  | [NAME] | 6763838 | 44 | Female | Recipient 1
1759058 | 4 |  |  |  | Lynette | 6763838 | 8 | Female | Family Member
7519058 | 9 |  |  |  | [NAME] | 6763838 | 41 | Female | Recipient 2
8259058 | 3 |  |  |  | [NAME] | 9063838 | 9 | Female | Family Member
4173838 | 6 |  |  |  | Sandra | 9063838 | 20 | Female | Family Member
9019058 | 4 |  |  |  | [NAME] | 9063838 | 48 | Female | Recipient 1
2763838 | 2 |  |  |  | [NAME] | 9063838 | 18 | Female | Family Member
 |  |  |  |  | Helen | 9063838 | 42 | Female | Recipient 2
 |  |  |  |  | Heather | 9063838 | 4 | Female | Family Member
 |  |  |  |  | [NAME] | 8950958 | 27 | Male | Recipient 2
 |  |  |  |  | [NAME] | 8950958 | 29 | Male | Family Member
 |  |  |  |  | [NAME] | 8950958 | 12 | Male | Family Member
 |  |  |  |  | [NAME] | 8950958 | 80 | Male | Recipient 1
 |  |  |  |  | [NAME] | 8950958 | 9 | Male | Family Member
 |  |  |  |  | Grant | 8950958 | 18 | Male | Family Member
 |  |  |  |  | [NAME] | 8950958 | 31 | Male | Family Member
 |  |  |  |  | [NAME] | 8950958 | 16 | Male | Family Member
 |  |  |  |  | Trevor | 1759058 | 1 | Male | Family Member
 |  |  |  |  | [NAME] | 1759058 | 15 | Male | Family Member
 |  |  |  |  | [NAME] | 1759058 | 41 | Male | Recipient 2
 |  |  |  |  | [NAME] | 1759058 | 3 | Male | Family Member
 |  |  |  |  | [NAME] | 7519058 | 24 | Male | Family Member
 |  |  |  |  | Stephen | 7519058 | 60 | Male | Recipient 1
 |  |  |  |  | [NAME] | 7519058 | 30 | Male | Family Member
 |  |  |  |  | [NAME] | 7519058 | 4 | Male | Family Member
 |  |  |  |  | Mark | 7519058 | 14 | Male | Family Member
 |  |  |  |  | [NAME] | 7519058 | 21 | Male | Family Member
 |  |  |  |  | Ian | 7519058 | 19 | Male | Family Member
 |  |  |  |  | [NAME] | 7519058 | 16 | Male | Family Member
 |  |  |  |  | [NAME] | 7519058 | 31 | Male | Family Member
 |  |  |  |  | Wayne | 8259058 | 44 | Male | Recipient 2
 |  |  |  |  | [NAME] | 8259058 | 14 | Male | Family Member
 |  |  |  |  | Graeme | 8259058 | 43 | Male | Recipient 1
 |  |  |  |  | Suzanne | 4173838 | 26 | Female | Family Member
 |  |  |  |  | Rosemary | 4173838 | 48 | Female | Family Member
 |  |  |  |  | [NAME] | 4173838 | 78 | Female | Family Member
 |  |  |  |  | [NAME] | 4173838 | 39 | Female | Recipient 1
 |  |  |  |  | [NAME] | 4173838 | 67 | Female | Family Member
 |  |  |  |  | [NAME] | 4173838 | 18 | Female | Family Member
 |  |  |  |  | [NAME] | 9019058 | 21 | Male | Family Member
 |  |  |  |  | [NAME] | 9019058 | 32 | Male | Recipient 2
 |  |  |  |  | [NAME] | 9019058 | 67 | Male | Family Member
 |  |  |  |  | [NAME] | 9019058 | 25 | Male | Family Member
 |  |  |  |  | [NAME] | 2763838 | 39 | Female | Recipient 2
 |  |  |  |  | [NAME] | 2763838 | 59 | Female | Family Member
Spreadsheet: 28380d1222553316-shortening-dates-dd-mmm-yy-to-mmm-yy-dates1
Sheet: Sheet4

Sum of Amount | Column Labels
 | 2003 | 2006 |  | 2008 | Grand Total
Row Labels | Mar | May | Jun | Apr
aaa | 300 | 54680 | 45680 |  | 100660
bbb | 3000 | 6860 | 6860 | 5000 | 21720
[NAME] |  |  |  | 13000 | 13000
Grand Total | 3300 | 61540 | 52540 | 18000 | 135380
Spreadsheet: 221542d1363607507-assigning-a-category-to-a-specific-time-frame-length-in-time
Sheet: Sheet1

Begin | End | <3 Months | 3-6 Months | 7-12 Months | 1-2 years | 5-7 years | >7 years
2012-03-12 00:00:00 | 2013-03-15 00:00:00
2008-05-25 00:00:00 | 2013-01-15 00:00:00
2010-01-01 00:00:00 | 2013-02-14 00:00:00
2012-04-03 00:00:00 | 2012-11-12 00:00:00
2012-09-03 00:00:00 | 2012-10-23 00:00:00
2001-08-31 00:00:00 | 2012-12-12 00:00:00
2009-09-29 00:00:00 | 2012-01-12 00:00:00
2005-06-30 00:00:00 | 2012-02-14 00:00:00
1980-12-29 00:00:00 | 2011-05-05 00:00:00
2011-11-05 00:00:00 | 2012-08-30 00:00:00
Spreadsheet: 9d550114-ea13-4e13-911f-13254518723a
Sheet: Sheet1

Title | Upload Date | Module | Authors | Print Publication Date | DOI | ISBN | Sub-discipline | LINK | Site Module Name
[NAME] Palliative Care | Aug-10 | Physiotherapy | Watson, Lucas, Hoy, Wells | 2009 | 10.1093/med/[PHONE].001.0001 | 9780199234356 | Clinical Medicine, Palliative Medicine, Medical Ethics, Medical Skills, Communication Skills, Drugs and Medicines, Geriatric Medicine, Rehabilitation Medicine, Allied Health Professions, Occupational Therapy, Dietetics, Physiotherapy, [NAME] and [NAME], Arts Therapies, Community Medical Services, Doctor, Qualified, early specialism training, Oxford Medical Handbooks | http://oxfordmedicine.com/view/10.1093/med/[PHONE].001.0001/med-[PHONE] | OXMEDO_SPECIALTY:MED00110
Oxford Textbook of Palliative Medicine | Mar-11 | Physiotherapy | Hanks, Cherny, Christakis, Fallon, [NAME], Portenoy | 2009 | 10.1093/med/[PHONE].001.0001 | 9780198570295 | Clinical Medicine, Palliative Medicine, History of Medicine, Drugs and Medicines, Public Health and Epidemiology, Medical Statistics and Methodology, Medical Oncology, Medical Ethics, Medical Skills, [NAME], Allied Health Professions, Occupational Therapy, Arts Therapies, Dietetics, Physiotherapy, [NAME] and [NAME], Clinical Pharmacology and Therapeutics, Paediatrics, Communication Skills, Clinical Science, Radiology, Clinical Radiology, Surgery, Psychiatry, Gastroenterology, Dermatology, Genito-Urinary Medicine, Endocrinology and Diabetes, Respiratory Medicine and Pulmonology, Neurology, Infectious Diseases, Cardiology, Renal Medicine, Intensive Care, Geriatric Medicine, Rehabilitation Medicine, Professional Development in Medicine, Doctor, Qualified, late specialism training, [NAME], specialist, Oxford Textbooks | http://oxfordmedicine.com/view/10.1093/med/[PHONE].001.0001/med-[PHONE] | OXMEDO_SPECIALTY:MED00110
Spreadsheet: 161156d1339431645-expiry-date-flagging-can-you-help-training-database-template
Sheet: Variables

 | Courses | [NAME]
 | Cable Avoidance / CAT & GENNY | 2013-06-13 00:00:00
 | Street Works NRSWA Supervisor | 2014-05-10 00:00:00
 | Street Works NRSWA Operative
 | Crane Appointed Person - 3years
 | PASMA - Mobile Towers
 | [NAME] training (IPAF)
 | Confined Space Training - 3 years
 | Slinger / Signaller (CPCS)
 | Drugs & Alcohol Screening
 | Track Awareness Training - DLR
 | LUL Entry Permit
 | LUL Track Awareness Training
 | Network Rail PTS Training
 | CSCS - H&S Touch Screen Test
 | Medical for Network Rail - LUL - DLR
 | Site Managers Safety Training Scheme (5day)
 | Site Supervisors Safety Training Scheme (2 day)
 | 4 Day First Aid
 | CPCS - Plant Operator
 | Asbestos Awareness training
 | Other
Spreadsheet: 122376d1316773884-excel-2007-search-and-find-match-from-list-sample-sf-1-
Sheet: Sheet1

List | Search Fields | Return
243556478 | 55566 | 36755566
222222222 | 888889 | Not Available
36755566 | 4456 | 4456
4456 | 335567 | 6335567
6335567 | 111115 | Not Available
 |  |  |  | Note: array formula is used and should be confirmed though Ctrl+Shift+Enter
Spreadsheet: 172909fb-bf08-42ea-9c8a-c275f0289967
Sheet: Ethnicity - Fall Afr Amer

Return to Contents
Ethnicity - African American or Black
 |  |  |  | UH | UH COMMUNITY COLLEGES
 |  | UH | UH | WEST
 | TOTAL | MĀNOA | HILO | O‘AHU | SUBTOTAL | Hawaii | Honolulu | Kapi‘olani | Kaua‘i | Leeward | Maui | [NAME]
1977 | 303 | 81 | 16 | 2 | 204 | 13 | 50 | 31 | 3 | 93 | 3 | 11
1978 | 328 | 85 | 10 | 9 | 224 | 13 | 63 | 32 | 3 | 94 | 4 | 15
1979 | 335 | 101 | 4 | 9 | 221 | 7 | 79 | 27 | 3 | 86 | 2 | 17
1980 | 359 | 106 | 7 | 4 | 242 | 8 | 62 | 39 | 3 | 122 | 1 | 7
1981 | 406 | 132 | 9 | 8 | 257 | 5 | 73 | 43 | 2 | 116 | 3 | 15
1982 | 481 | 132 | 14 | 14 | 321 | 15 | 89 | 50 | 3 | 129 | 7 | 28
1983 | 467 | 152 | 10 | 17 | 288 | 7 | 76 | 54 | 2 | 128 | 9 | 12
1984 | 437 | 132 | 15 | 11 | 279 | 11 | 75 | 49 | 3 | 113 | 8 | 20
1985 | 419 | 131 | 13 | 11 | 264 | 13 | 67 | 39 | 2 | 111 | 11 | 21
1986 | 392 | 118 | 7 | 3 | 264 | 14 | 50 | 40 | 2 | 119 | 7 | 32
1987 | 448 | 111 | 12 | 8 | 317 | 13 | 51 | 53 | 4 | 159 | 10 | 27
1988 | 401 | 129 | 12 | 9 | 251 | 7 | 50 | 43 | 4 | 121 | 7 | 19
1989 | 404 | 130 | 11 | 10 | 253 | 13 | 44 | 41 | 6 | 120 | 6 | 23
1990 | 468 | 148 | 18 | 14 | 288 | 19 | 36 | 49 | 7 | 149 | 8 | 20
1991 | 505 | 163 | 31 | 18 | 293 | 6 | 44 | 59 | 5 | 146 | 10 | 23
1992 | 468 | 142 | 26 | 15 | 285 | 11 | 50 | 66 | 5 | 117 | 3 | 33
1993 | 512 | 154 | 24 | 8 | 326 | 15 | 70 | 73 | 6 | 133 | 7 | 22
1994 | 498 | 163 | 31 | 6 | 298 | 18 | 70 | 71 | 5 | 110 | 11 | 13
1995 | 487 | 132 | 23 | 11 | 321 | 21 | 61 | 73 | 5 | 129 | 14 | 18
Note: Data may not match [NAME] reports due to changes in enrollment counting methodology.
Spreadsheet: 709103d1608156886-matching-different-dates-with-same-item-sample-example-multi-match-same-id
Sheet: Outcomes

ID # | Name | Outcome Dates | Intake Date | Length of Stay | Intake Date - Standard Index and Match
A825492 | Luna | 2020-11-07 12:40:00 |  |  |  | Same Date
A825492 | Luna | 2020-12-30 10:55:00 |  |  |  | Same Date
A825653 | [NAME] | 2020-12-10 13:38:00 |  |  |  | Same Date
A825653 | [NAME] | 2020-12-02 14:28:00 |  |  |  | Same Date
A825700 |  | 2020-12-01 12:52:00
A825700 |  | 2020-12-14 19:15:00 |  |  |  | Same Date
A825700 |  | 2020-12-01 15:32:00 |  |  |  | Same Date
A825863 | *Poppet | 2020-12-16 19:15:00 |  |  |  | Same Date
A825863 | *Poppet | 2020-12-12 08:36:00 |  |  |  | Same Date
A826166 | *Ophelia | 2020-12-28 16:49:00 |  |  |  | Same Date
A826166 | *Ophelia | 2020-11-12 14:48:00 |  |  |  | Same Date
[NAME] | [NAME] | 2020-12-03 16:37:00
A826771 |  | 2020-12-04 16:13:00
A826772 |  | 2020-12-01 16:18:00
A826773 |  | 2020-12-03 16:21:00
A826774 |  | 2020-12-03 16:30:00
A826777 |  | 2020-12-01 17:38:00
Spreadsheet: 750928d1633726881-need-to-compare-the-same-contents-in-two-columns-then-copy-the-left-columns-accordingly-try-out-example100821-thank-you
Sheet: Sheet1

A | B | C | D | E | F | G | H | I
1 | 123568 | 2021-12-03 00:00:00 | A23 | 5678 | DR12 | 4557 | C45 | 5678
2 | 134567 | 2021-12-03 00:00:00 | A24 | 5679 | DR13 | 4558 | C46 | 5679
3 | 1436778 | 2020-02-05 00:00:00 | A25 | 5680 | DR14 | 4559 | C47 | 5680
4 | 123568 | 2021-12-03 00:00:00 | A23 | 5678 | DR12 | 4557 | C45 | 5678
5 | 1436778 | 2020-02-05 00:00:00 | A25 | 5680 | DR14 | 4559 | C47 | 5680
6 | 134567 | 2021-05-04 00:00:00 | B24 | 5679 | B13 | 4558 | C46 | 5679
7 | 123568 | 2021-12-03 00:00:00
8 | 134567 | 2020-02-05 00:00:00
9 | 123568 | 2021-12-03 00:00:00
10 | 1436778 | 2020-02-05 00:00:00
11 | 1436778 | 2020-02-05 00:00:00
12 | 123568 | 2021-12-03 00:00:00
13 | 134567 | 2021-12-03 00:00:00
Spreadsheet: 154313d1336377541-find-text-in-array-and-return-adjacent-cell-value-find-text-in-array-return-adjacent-cell-value
Sheet: test

 | Charts |  |  |  | Syllabus e01932 summer
 | pie | dust | screen |  | tue | moon | white
 | 1.12 | 12451 | 45 |  | 13 | 326 | 632
 |  |  |  |  | 73 | 26 | 25
 |  |  |  |  | 165 | 3 | 364
 |  |  |  |  | 4 | 634 | 37
 | - array is B4: H9
 | - set cell B2 to find text "Syllabus e01932 summer" from array, & get value of cell offset (3,1) highlighted in yellow