tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 716754d1612353936-get-weighted-average-with-a-lookup-sample-sspreadsheet-feb-21
Sheet: Sheet1

Period | Service | Virtual [NAME] | Average Cube | Volume
P4 | [NAME] | 2041.463711367149 | 0.02645160905840286 | 871
P4 | Return of Undelivered Parcel | 880.1512556231886 | 0.06135309090909091 | 258
P4 | XPECT 24 POD | 881.0793850015689 | 0.06128846153846153 | 24
P4 | [NAME] LARGE POD | 587.5432886117069 | 0.09190812157448928 | 3921
P4 | XPECT 48 POD | 457.1935988974896 | 0.1181118898650803 | 90675
P4 | XPRESS 24 POD | 1179.160173870253 | 0.04579530516431925 | 212
P4 | XPRESS MINI 48 NON POD | 2284.931427940534 | 0.02363309434133503 | 88382
P3 | [NAME] | 2196.044538894578 | 0.02458966521106259 | 678
P3 | EXPRESS ISLE | 622.4783861671469 | 0.08675000000000001 | 2
P3 | Return of Undelivered Parcel | 1139.380871707993 | 0.04739416058394161 | 140
P3 | XPECT 24 POD | 823.0139074109355 | 0.06561249999999999 | 10
P3 | [NAME] LARGE POD | 647.6411945640534 | 0.08337950157162101 | 4576
P3 | XPECT 48 POD | 457.7657776280383 | 0.1179642573540702 | 45536
P3 | XPRESS 24 POD | 1075.697211155378 | 0.05020000000000001 | 41
P3 | XPRESS MINI 48 NON POD | 2426.965973102593 | 0.02225000292483182 | 67560
 | Trailer Fill | Average Cube
P4
P3
Period | Virtual [NAME] | Average Cube
P3
P4
Spreadsheet: 598409d1542449122-devide-numbers-and-duplicate-one-spesific-cell-number-book1
Sheet: Sheet1

1.614 | 1.545 | 1.456 | 1.357 | 1.255 | 1.16 | 1.08 | 1.022 | 0.99 | 0.986 | 1.011 | 1.065 | 1.146 | 1.255 | 1.387 | 1.536 | 1.692 | 1.843 | 1.974 | 2.072 | 2.126 | 2.133 | 2.092 | 2.006 | 1.879 | 1.716 | 1.523 | 1.309 | 1.088 | 0.876 | 0.683 | 0.517 | 0.379 | 0.267 | 0.184 | 0.136 | 0.133 | 0.182 | 0.285 | 0.435 | 0.621 | 0.825 | 1.033 | 1.23 | 1.404 | 1.545 | 1.647 | 1.706 | 1.722
1.722 | 1.7 | 1.643 | 1.56 | 1.457 | 1.346 | 1.236 | 1.137 | 1.059 | 1.007 | 0.982 | 0.985 | 1.018 | 1.079 | 1.171 | 1.292 | 1.438 | 1.599 | 1.764 | 1.916 | 2.042 | 2.128 | 2.167 | 2.155 | 2.094 | 1.987 | 1.837 | 1.65 | 1.436 | 1.208 | 0.981 | 0.771 | 0.585 | 0.428 | 0.297 | 0.193 | 0.122 | 0.093 | 0.116 | 0.198 | 0.335 | 0.515 | 0.722 | 0.938 | 1.147 | 1.337 | 1.5 | 1.626 | 1.713
1.713 | 1.756 | 1.756 | 1.718 | 1.645 | 1.545 | 1.429 | 1.308 | 1.194 | 1.098 | 1.026 | 0.981 | 0.965 | 0.975 | 1.014 | 1.084 | 1.185 | 1.317 | 1.473 | 1.641 | 1.807 | 1.953 | 2.065 | 2.133 | 2.152 | 2.119 | 2.037 | 1.909 | 1.74 | 1.539 | 1.317 | 1.089 | 0.871 | 0.673 | 0.501 | 0.357 | 0.239 | 0.152 | 0.103 | 0.104 | 0.162 | 0.278 | 0.442 | 0.638 | 0.85 | 1.06 | 1.258 | 1.434 | 1.581
1.581 | 1.692 | 1.761 | 1.786 | 1.768 | 1.711 | 1.621 | 1.507 | 1.382 | 1.258 | 1.148 | 1.059 | 0.996 | 0.959 | 0.948 | 0.964 | 1.008 | 1.084 | 1.194 | 1.333 | 1.493 | 1.659 | 1.815 | 1.945 | 2.036 | 2.081 | 2.076 | 2.023 | 1.922 | 1.78 | 1.603 | 1.399 | 1.182 | 0.967 | 0.765 | 0.586 | 0.434 | 0.309 | 0.214 | 0.153 | 0.137 | 0.172 | 0.263 | 0.402 | 0.578 | 0.774 | 0.977 | 1.173 | 1.356
Spreadsheet: 123467d1317671918-obtaining-data-within-a-specific-date-range-resource-center-service-tracking-log
Sheet: Totals 

Served | April | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar
Participants Entered
Participants Enrolled
Case Management
[NAME]
Brandie
Program [NAME].
Supportive Services
[NAME]
Brandie
Program [NAME].
Services
Bus Tokens
Meal Vouchers
Birth Certificates
Identification Voucher
Emergency Housing Referrals
Transitional Housing Referrals
Permanent Housing Referrals
Spreadsheet: 464997d1465400176-inputting-data-in-alternating-rows-zeszyt1
Sheet: Arkusz1

A1 | B1
A2 | B2
A3 | B3
A4 | B4
A5 | B5
A6 | B6
A7 | B7
A8 | B8
A9 | B9
A10 | B10
A11 | B11
Spreadsheet: 129320d1321545926-conditional-formatting-two-cols-such-that-both-cols-get-same-color-based-on-a-sum-conditional_format_two_cells_together
Sheet: Sheet1

2 | 3 |  | 1 | 1 | junk1 |  | Goal:
1 | 5 |  |  |  | 4 |  | I will have two cols of data(col A and col B).
2 | 5 |  |  |  |  |  | I want to conditionally format these two cols such that if the sum of the data in their respective cells are larger than some limit
2 | 3 |  |  |  |  |  | then BOTH cells are to be formated a certain way.
1 | 1
2 | 1 |  |  |  |  |  | For example
3 | 1 |  |  |  |  |  | If [NAME] and B1=2 the sum is 3 and this is less than or equal to 4…….both A1 and B1 would be formatted green
4 | 1
1 | 2 |  |  |  |  |  | if A1=4 and B1=1 then sum is 5 and this is greater than 4 …..both [NAME] and B1 would be formatter red
2 | 2
3 | 2
4 | 2 |  |  |  |  |  | ($A1+$B1)<=4
1 | 3
2 | 3
3 | 3
4 | 3
1 | 4
2 | 4
3 | 4
4 | 4
1 | 5
2 | 5
3 | 5
4 | 5
4 | 5
4 | 5
4 | 5
4 | 5
Spreadsheet: eric_saibi__9681__121901R
Sheet: Sain Lucie 02

Owner Name |  | Florida Power and Light
Station Name |  | Saint Lucie Nuclear Power Station
Unit Name |  | Saint Lucie 02
NERC Region |  | FRCC
State |  | FL
Fuel Type |  | Nuclear
Capacity |  | 850 MW
Start Date |  | 2001-11-25 00:00:00
End Date |  | 2001-12-21 00:00:00
Prv. Start Date |  | 2001-11-25 00:00:00
Prv. End Date |  | 2001-12-19 00:00:00
Comments |  | Refuel-finishing up now and will be on-line Friday Dec 21
SIC |  | 4911
Plant ID |  | 1016650
Unit ID |  | 1004843
Outage ID |  | 11971
Spreadsheet: 166869d1341837034-returning-a-value-in-another-cell-when-merged-cells-are-being-used-excel-example2
Sheet: Sheet1

SELECT YOUR CAR
CAR | CODE | SELECT
BLUE CAR | A
RED CAR | B
GREEN CAR | C
YELLOW CAR | D
PINK CAR | E
PURPLE CAR | F
SILVER CAR | G
SELECTION
In this form, I want to place an 'X' in the select column, against the colour car I wish to choose, to reflect the
code for the car at the selection cell B13.
If I wish to select a green car, I would enter an X at C7 and 'C' would appear in the selection cell B13.
Or if I wanted to select a silver car, an X would be entred into C11 and G would appear in the cell B13.
Is this a nested 'if' using 'sumproduct'?
Spreadsheet: 858260d1706984906-dashboard-to-show-names-over-the-week-location
Sheet: Dashboard

 |  |  | W/C | 2024-02-05 00:00:00
 |  |  | Mon | Tue | Wed | Thurs | Fri | Sat | Sun
 | Liverpool |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | London |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Luton |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Birmingham |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Brentford |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Spreadsheet: 155770d1337029900-help-with-my-fantasy-result-prediction-spreadsheet-it-cant-work-out-0-0-scorelines-srs-draft-1
Sheet: Table

 |  |  |  |  |  |  | Result Table (to date)
Name | Points |  |  |  |  |  | Rank |  | Points
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 6
 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 11
 |  |  |  |  |  |  | 12
 |  |  |  |  |  |  | 13
 |  |  |  |  |  |  | 14
 |  |  |  |  |  |  | 15
 |  |  |  |  |  |  | 16
 |  |  |  |  |  |  | 17
 |  |  |  |  |  |  | 18
 |  |  |  |  |  |  | 19
 |  |  |  |  |  |  | 20
 |  |  |  |  |  |  | 21
 |  |  |  |  |  |  | 22
 |  |  |  |  |  |  | 23
 |  |  |  |  |  |  | 24
 |  |  |  |  |  |  | 25
 |  |  |  |  |  |  | 26
 |  |  |  |  |  |  | 27
 |  |  |  |  |  |  | 28
 |  |  |  |  |  |  | 29
 |  |  |  |  |  |  | 30
 |  |  |  |  |  |  | 31
 |  |  |  |  |  |  | 32
 |  |  |  |  |  |  | 33
 |  |  |  |  |  |  | 34
 |  |  |  |  |  |  | 35
 |  |  |  |  |  |  | 36
 |  |  |  |  |  |  | 37
 |  |  |  |  |  |  | 38
 |  |  |  |  |  |  | 39
 |  |  |  |  |  |  | 40
 |  |  |  |  |  |  | 41
 |  |  |  |  |  |  | 42
 |  |  |  |  |  |  | 43
 |  |  |  |  |  |  | 44
 |  |  |  |  |  |  | 45
 |  |  |  |  |  |  | 46
 |  |  |  |  |  |  | 47
 |  |  |  |  |  |  | 48
 |  |  |  |  |  |  | 49
 |  |  |  |  |  |  | 50
 |  |  |  |  |  |  | 51
 |  |  |  |  |  |  | 52
 |  |  |  |  |  |  | 53
 |  |  |  |  |  |  | 54
 |  |  |  |  |  |  | 55
 |  |  |  |  |  |  | 56
 |  |  |  |  |  |  | 57
 |  |  |  |  |  |  | 58
 |  |  |  |  |  |  | 59
 |  |  |  |  |  |  | 60
 |  |  |  |  |  |  | 61
 |  |  |  |  |  |  | 62
 |  |  |  |  |  |  | 63
 |  |  |  |  |  |  | 64
 |  |  |  |  |  |  | 65
 |  |  |  |  |  |  | 66
 |  |  |  |  |  |  | 67
 |  |  |  |  |  |  | 68
 |  |  |  |  |  |  | 69
 |  |  |  |  |  |  | 70
 |  |  |  |  |  |  | 71
 |  |  |  |  |  |  | 72
 |  |  |  |  |  |  | 73
 |  |  |  |  |  |  | 74
 |  |  |  |  |  |  | 75
 |  |  |  |  |  |  | 76
 |  |  |  |  |  |  | 77
 |  |  |  |  |  |  | 78
 |  |  |  |  |  |  | 79
 |  |  |  |  |  |  | 80
 |  |  |  |  |  |  | 81
 |  |  |  |  |  |  | 82
 |  |  |  |  |  |  | 83
 |  |  |  |  |  |  | 84
 |  |  |  |  |  |  | 85
 |  |  |  |  |  |  | 86
 |  |  |  |  |  |  | 87
 |  |  |  |  |  |  | 88
 |  |  |  |  |  |  | 89
 |  |  |  |  |  |  | 90
 |  |  |  |  |  |  | 91
 |  |  |  |  |  |  | 92
 |  |  |  |  |  |  | 93
 |  |  |  |  |  |  | 94
 |  |  |  |  |  |  | 95
 |  |  |  |  |  |  | 96
 |  |  |  |  |  |  | 97
 |  |  |  |  |  |  | 98
 |  |  |  |  |  |  | 99
 |  |  |  |  |  |  | 100
 |  |  |  |  |  |  | 101
 |  |  |  |  |  |  | 102
 |  |  |  |  |  |  | 103
Spreadsheet: 101642d1299729795-help-with-barcodes-and-checkin-checkin-help
Sheet: Barcodes

Name of Person | Barcode
Person's Name | 0041607000187277
Person's Name | 0041607000187278
Person's Name | 0041607000187279
Person's Name | 0041607000187280
Person's Name | 0041607000187281
Person's Name | 0041607000187282
Person's Name | 0041607000187283
Person's Name | 0041607000187284
Person's Name | 0041607000187285
Person's Name | 0041607000187286
Person's Name | 0041607000187287
Person's Name | 0041607000187288
Person's Name | 0041607000187289
Person's Name | 0041607000187290
Person's Name | 0041607000187291
Person's Name | 0041607000187292
Person's Name | 0041607000187293
Person's Name | 0041607000187294
Person's Name | 0041607000187295
Person's Name | 0041607000187296
Person's Name | 0041607000187297
Person's Name | 0041607000187298
Person's Name | 0041607000187299
Person's Name | 0041607000187300
Person's Name | 0041607000187301
Person's Name | 0041607000187302
Person's Name | 0041607000187303
Person's Name | 0041607000187304
Person's Name | 0041607000187305
Person's Name | 0041607000187306
Person's Name | 0041607000187307
Person's Name | 0041607000187308
Person's Name | 0041607000187309
Person's Name | 0041607000187310
Person's Name | 0041607000187311
Person's Name | 0041607000187312
Person's Name | 0041607000187313
Person's Name | 0041607000187314
Person's Name | 0041607000187315
Person's Name | 0041607000187316
Person's Name | 0041607000187317
Person's Name | 0041607000187318
Person's Name | 0041607000187319
Person's Name | 0041607000187320
Person's Name | 0041607000187321
Person's Name | 0041607000187322
Person's Name | 0041607000187323
Person's Name | 0041607000187324
Spreadsheet: 686507d1594661440-how-to-have-conditional-format-highlight-cell-based-on-two-cell-values-book1
Sheet: Sheet1

Months | TestA | TestB | TestC | Test4 | Test5 | Test6
January |  |  | Pass
February |  |  | Fail
March |  |  | [NAME]
April |  |  | Pass
May |  |  | Fail
June |  |  | [NAME]
July |  |  | Pass
August |  |  | Fail
September |  |  | [NAME]
October |  |  | Pass
November |  |  | Fail
December |  |  | [NAME]
Last three months
May
June
July
Spreadsheet: 3bcd556c-64c8-46c5-a709-2de92b90cb76
Sheet: Sheet1

Unnamed: 0 | Project Title: | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Order # | Unnamed: 14 | Unnamed: 15
 |  | PURCHASE REQUEST |  |  |  |  |  |  |  |  |  |  | Conf #
 |  |  |  |  |  |  |  |  |  |  |  |  | PC #
 |  | Vendor Information
 |  |  |  |  |  |  |  |  |  |  | Deliver To:
 | VENDOR NAME |  |  |  |  |  |  |  |  |  | NAME:
 | Contact person |  |  |  |  | Yes, checked with |  |  |  |  | BUILDING:
 | ADDRESS |  |  |  |  |  | (name) |  | (date) |  | ROOM#
 | CITY |  |  |  |  |  |  |  |  |  | PHONE#
 | STATE |  | ZIP |  |  | Yes, verified by |  |  |  |  | EMAIL:
 | VENDOR PHONE#: |  |  |  |  |  | (name) |  | (date) |  |  |  | Special processing requested
 | VENDOR FAX#: |  |  |  |  |  |  | Business Office Use Only: |  |  |  |  |  | REQUEST EXPRESS SHIPPING
 |  | ACCOUNT(S) TO BE CHARGED |  |  |  |  |  | Project Period |  |  |  | Date |  | SOLE SOURCE
 |  | Object /       GL Account | Cost Center | Fund | Internal Order            or SIO |  | $ [NAME] or % | Begin Date | Expiration | Account      Balance |  |  |  | NO SUBSTITUTIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | OTHER (explain below)
CATALOG # |  |  | [NAME] |  |  |  |  |  |  |  |  | UNIT | QUAN. | UNIT COST | TOTAL COST
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
PI/Requestor Signature: |  |  |  |  |  |  | Date
Signature certifies that the requestor has the technical expertise and/or direct knowledge that these item(s) and costs will benefit the project(s) indicated. |  |  |  |  |  |  |  |  |  |  |  | Authorized Fiscal Approver (ME BO)                   Date
 | Business Office Use Only:
 | Are the items being purchased specifically budgeted on the sponsored account?     Yes _____   No _____ (If no, explain how the purchase benefits the project).
 | Has an equipment screening been completed?   Yes _____  No _____   (Required for >$25,000 on Sponsored Accts, Desired for all other accounts)?
 | Has Sole Source document been completed?  Yes _____  No _____  (Required for all single source acquisitions >$10,000).
 | Is there proper documentation from the PI approving the purchase (signature, email, other ________________)?
 | For P-card orders from Herrick or [NAME] lab, send original documentation to MEBO                               P-card orders entered on log? Yes _____ [NAME]________
Spreadsheet: 1d3549d4-4a7c-441c-9fd0-3a38e2a51abb
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261338 | 70655 | Masazumi | Soejima | JPN | 24 | 00:21:12 | 00:01:12 | 00:41:35 | 00:02:12 | [NAME] | 1 | 01:17:11
261338 | 70657 | Junpei | Kimura | JPN | 25 | 00:14:13 | 00:01:39 | 00:45:35 | 00:02:38 | 00:28:46 | 2 | [NAME]
Spreadsheet: 716972d1612439912-link-data-across-tabs-capacity-plan-option-2-1-2-final
Sheet: Year View

YEAR | CALENDAR
JANUARY | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
FEBRUARY | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
[NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
APRIL | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
 |  |  |  |  | Launcs | Launcs | Launcs | Launcs | Launcs
MAY | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
[NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
JULY | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
AUGUST | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
SEPTEMBER | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
OCTOBER | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
NOVEMBER | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
DECEMBER | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Spreadsheet: 118694d1313901679-how-to-capture-most-latest-childs-birth-date-for-albert-from-raw-data-book1
Sheet: Sheet1

Raw Data |  |  |  |  |  | [NAME]
ID | Name | Member | Type of family | Birth Date
1254 | [NAME] | 1 | Spouse | 06.09.1971 |  | 09/06/1971
1254 | [NAME] | 2 | Child | 14.06.1996 |  | 06/14/1996
1254 | [NAME] | 2 | Child | 29.05.2001 |  | 05/29/2001
1254 | [NAME] | 2 | Child | 09.06.2011 |  | 06/09/2011
1647 | [NAME] | 1 | Spouse | 09.09.1979 |  | 09/09/1979
1647 | [NAME] | 2 | Child | 09.06.2005 |  | 06/09/2005
1647 | [NAME] | 2 | Child | 20.02.2011 |  | 02/20/2011
How to capture most latest child's birth date for [NAME] from raw data?
Answer = 20.02.2011
* Result I would like to show is 20.02.2011 (General format)
Spreadsheet: eric_saibi__9765__012302R
Sheet: Encina 03

Owner Name |  | Cabrillo Power LLC
Station Name |  | Encina Power Station
Unit Name |  | Encina 03
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Natural Gas
Capacity |  | 110 MW
Start Date |  | 2002-01-04 00:00:00
End Date |  | 2002-01-25 00:00:00
Prv. Start Date |  | 2002-01-04 00:00:00
Prv. End Date |  | 2002-01-23 00:00:00
Comments |  | Asbestos Removal and Inspection
SIC |  | 4931
Plant ID |  | 1013264
Unit ID |  | 1006366
Outage ID |  | 19378
Spreadsheet: 054efe23-5b21-44f4-9965-84f494e0caf7
Sheet: Sheet1

Department of Human Resource Management Individual Performance Plan and Evaluation | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Name: |  |  |  |  |  |  | Agency: |  | Utah State Office of Education
Position: |  |  |  |  |  |  | Unit/Division:
EID#: |  |  |  |  |  |  | Work Location: |  | State Office Of Education
Period Covered: |  | 2008-07-01 00:00:00 | to |  | 2009-06-30 00:00:00 |  | Purpose: | █Annual Review     Probationary Review     Interim Review
Agency Strategic Goal(s)
Provide leadership, vision and advocacy so that all students have educational opportunities to meet their potential and achieve competency.  Do this by 1) Model integrity and character in behavior, leadership, and decision-making.  2) Display a strong work ethic.  3) Facilitate teamwork.  4) Ensure quality work in a timely manner.  5) Build positive relationships with others in the office, and with members of the board, government, schools and community.
Team Strategic Goal(s)
Individual Strategic Goal(s)
Work Performed/Core Responsibilities -- activities, services provided and/or products produced by this position (or attach copy of PDQ):
The Performance Plan for this period has been discussed by the employee and the supervisor. |  |  |  |  |  |  |  | Yes
Employee Signature |  |  |  |  | Date |  | Supervisor Signature |  |  |  |  | Date
Next Higher Management Level Signature |  |  |  |  | Date
Spreadsheet: 30591d1226175678-formatting-cells-as-fractions-random_inches
Sheet: Sheet1

100 | 141.4375
100.125 | 141.625
100.25 | 141.75
100.375 | 141.9375
100.5 | 142.125
100.625 | 142.3125
100.75 | 142.5
100.875 | 142.6875
101 | 142.8125
101.125 | 143
101.25 | 143.1875
101.375 | 143.375
101.5 | 143.5625
101.625 | 143.75
101.75 | 143.875
101.875 | 144.0625
102 | 144.25
102.125 | 144.4375
102.25 | 144.625
102.375 | 144.75
102.5 | 144.9375
102.625 | 145.125
102.75 | 145.3125
102.875 | 145.5
103 | 145.6875
103.125 | 145.8125
103.25 | 146
103.375 | 146.1875
103.5 | 146.375
103.625 | 146.5625
103.75 | 146.75
103.875 | 146.875
104 | 147.0625
104.125 | 147.25
104.25 | 147.4375
104.375 | 147.625
104.5 | 147.8125
104.625 | 147.9375
104.75 | 148.125
104.875 | 148.3125
105 | 148.5
105.125 | 148.6875
105.25 | 148.875
105.375 | 149
105.5 | 149.1875
105.625 | 149.375
105.75 | 149.5625
105.875 | 149.75
106 | 149.9375
106.125 | 150.0625
106.25 | 150.25
106.375 | 150.4375
106.5 | 150.625
106.625 | 150.8125
106.75 | 150.9375
106.875 | 151.125
107 | 151.3125
107.125 | 151.5
107.25 | 151.6875
107.375 | 151.875
107.5 | 152
107.625 | 152.1875
107.75 | 152.375
107.875 | 152.5625
108 | 152.75
108.125 | 152.9375
108.25 | 153.0625
108.375 | 153.25
108.5 | 153.4375
108.625 | 153.625
108.75 | 153.8125
108.875 | 154
109 | 154.125
109.125 | 154.3125
109.25 | 154.5
109.375 | 154.6875
109.5 | 154.875
109.625 | 155.0625
109.75 | 155.1875
109.875 | 155.375
110 | 155.5625
110.125 | 155.75
110.25 | 155.9375
110.375 | 156.125
110.5 | 156.25
110.625 | 156.4375
110.75 | 156.625
110.875 | 156.8125
111 | 157
111.125 | 157.125
111.25 | 157.3125
111.375 | 157.5
111.5 | 157.6875
111.625 | 157.875
111.75 | 158.0625
111.875 | 158.1875
112 | 158.375
112.125 | 158.5625
112.25 | 158.75
112.375 | 158.9375
112.5 | 159.125
112.625 | 159.25
112.75 | 159.4375
112.875 | 159.625
113 | 159.8125
113.125 | 160
113.25 | 160.1875
113.375 | 160.3125
113.5 | 160.5
113.625 | 160.6875
113.75 | 160.875
113.875 | 161.0625
114 | 161.25
114.125 | 161.375
114.25 | 161.5625
114.375 | 161.75
114.5 | 161.9375
114.625 | 162.125
114.75 | 162.25
114.875 | 162.4375
115 | 162.625
115.125 | 162.8125
115.25 | 163
115.375 | 163.1875
115.5 | 163.3125
115.625 | 163.5
115.75 | 163.6875
115.875 | 163.875
116 | 164.0625
116.125 | 164.25
116.25 | 164.375
116.375 | 164.5625
116.5 | 164.75
116.625 | 164.9375
116.75 | 165.125
116.875 | 165.3125
117 | 165.4375
117.125 | 165.625
117.25 | 165.8125
117.375 | 166
117.5 | 166.1875
117.625 | 166.375
117.75 | 166.5
117.875 | 166.6875
118 | 166.875
118.125 | 167.0625
118.25 | 167.25
118.375 | 167.4375
118.5 | 167.5625
118.625 | 167.75
118.75 | 167.9375
118.875 | 168.125
119 | 168.3125
119.125 | 168.4375
119.25 | 168.625
119.375 | 168.8125
119.5 | 169
119.625 | 169.1875
119.75 | 169.375
119.875 | 169.5
120 | 169.6875
120.125 | 169.875
120.25 | 170.0625
120.375 | 170.25
120.5 | 170.4375
120.625 | 170.5625
120.75 | 170.75
120.875 | 170.9375
121 | 171.125
121.125 | 171.3125
121.25 | 171.5
121.375 | 171.625
121.5 | 171.8125
121.625 | 172
121.75 | 172.1875
121.875 | 172.375
122 | 172.5625
122.125 | 172.6875
122.25 | 172.875
122.375 | 173.0625
Spreadsheet: 34962d1232434060-text-if-cell-contains-text-stevensample
Sheet: Sheet1

x | y | 2 |  |  |  | x | y | 2
0 |  |  |  |  |  | 0
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  | Or |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
9 |  |  |  |  |  | 9
10 |  |  |  |  |  | 10