tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 185786d1349836572-sorting-non-empty-cells-to-bottom-schedule-example
Sheet: 1

2200-0000 |  |  | 0000-0200 |  |  | 0200-0400 |  |  | 0400-0600 |  |  | SATURDAY
ANGELA H |  |  | ANGELA H |  |  | CHRISTY |  |  | LISA H
LISA H |  |  | LISA H |  |  | DEBBIE |  |  | CHRISTY
CHRISTY |  |  | CHRISTY |  |  | JESSIE |  |  | DEBBIE
NICOLE |  |  | NICOLE |  |  | CHARITY L |  |  | JESSIE
CHARITY E |  |  | CHARITY E |  |  | JESS |  |  | CHARITY L
KATHY |  |  | KATHY |  |  |  |  |  | JESS
DEBBIE |  |  | DEBBIE
JESSIE |  |  | JESSIE
CHARITY L |  |  | CHARITY L
JESS |  |  | JESS
0600-0800 |  |  | 0800-1000 |  |  | 1000-1200 |  |  | 1200-1400
LISA H |  |  | JULIE |  |  | JULIE |  |  | JULIE
JULIE |  |  | RHONDA |  |  | RHONDA |  |  | RHONDA
RHONDA |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
[NAME] |  |  | KELLY |  |  | KELLY |  |  | KELLY
KELLY |  |  | KATY |  |  | KATY |  |  | KATY
KATY |  |  |  |  |  | LACY |  |  | LACY
 |  |  |  |  |  | TAMMY |  |  | TAMMY
 |  |  |  |  |  | ANGELA |  |  | ANGELA
1400-1600 |  |  | 1600-1800 |  |  | 1800-2000 |  |  | 2000-2200
JULIE |  |  | ANGELA H |  |  | ANGELA H |  |  | ANGELA H
RHONDA |  |  | NICOLE |  |  | NICOLE |  |  | CHRISTY
[NAME] |  |  | LACY |  |  | LACY |  |  | NICOLE
KELLY |  |  | CHARITY E |  |  | CHARITY E |  |  | CHARITY E
KATY |  |  | KATHY |  |  | KATHY |  |  | KATHY
LACY |  |  | TAMMY |  |  | TAMMY |  |  | DEBBIE
TAMMY |  |  | ANGELA |  |  | ANGELA |  |  | JESSIE
ANGELA |  |  |  |  |  |  |  |  | CHARITY L
 |  |  |  |  |  |  |  |  | ANGELA
 |  |  |  |  |  |  |  |  | JESS
TERI |  |  | CINDY |  |  | ANGELA H
CINDY |  |  | ANGELA H |  |  | CINDY
ANGELA H |  |  | TERI |  |  | TERI
LISA H |  |  | JULIE |  |  | CHAD
JULIE |  |  | CHAD |  |  | JULIE
CHAD |  |  | LISA H |  |  | LISA H
[NAME] |  |  | [NAME] |  |  | [NAME]
CHERYL |  |  | CHERYL |  |  | CHERYL
ALANA |  |  | ALANA |  |  | ALANA
VAL |  |  | VAL |  |  | VAL
RHONDA |  |  | RHONDA |  |  | RHONDA
[NAME] |  |  | [NAME] |  |  | [NAME]
CHRISTY |  |  | CHRISTY |  |  | CHRISTY
ANGELA |  |  | ANGELA |  |  | ANGELA
KAY |  |  | KAY |  |  | KAY
[NAME] |  |  | [NAME] |  |  | [NAME]
KELLY |  |  | KELLY |  |  | KELLY
BRANDY |  |  | BRANDY |  |  | BRANDY
STEPHANIE |  |  | STEPHANIE |  |  | STEPHANIE
NICOLE |  |  | NICOLE |  |  | NICOLE
KATY |  |  | KATY |  |  | KATY
LACY |  |  | LACY |  |  | LACY
JESSICA |  |  | JESSICA |  |  | JESSICA
MARK |  |  | MARK |  |  | MARK
CHARITY E |  |  | CHARITY E |  |  | CHARITY E
KATHY |  |  | KATHY |  |  | KATHY
DEBBIE |  |  | DEBBIE |  |  | DEBBIE
DANNEL |  |  | DANNEL |  |  | DANNEL
TAMMY |  |  | TAMMY |  |  | TAMMY
JESSIE |  |  | JESSIE |  |  | JESSIE
JESS |  |  | JESS |  |  | JESS
CHARITY L |  |  | CHARITY L |  |  | CHARITY L
Spreadsheet: 874741d1721272275-how-to-filter-and-show-only-data-that-meets-a-certain-criteria-sample_sheet_filtering
Sheet: Sheet1

Sample Raw Data | Column1 |  | Desired Table |  |  |  | What I Can Do
Text |  |  | 2 | 1.26 | Text |  |  | 1.26
1 | 0.8 |  | 5 | 1.56 | Text2 |  | 5 | 1.56
2 | 1.26 |  | 7 | 1.33 | Text2 |  | 7 | 1.33
3 | 0.67 |  | 13 | 1.9 | Text4 |  | 13 | 1.9
Text2 |  |  |  |  |  |  | [NAME] is to show only data from column B that is greater than 1.2 and its corresponding
5 | 1.56 |  |  |  |  |  | number from column A as well as text heading of each corresponding data block
6 | 0.09 |  | Sample Raw Data | Column1 | Custom
7 | 1.33 |  | 2 | 1.26 | Text
 |  |  | 5 | 1.56 | Text2
Text3 |  |  | 7 | 1.33 | Text2
9 | 0.9 |  | 13 | 1.9 | Text4
10 | 1.17
11 | 1.19
Text4
12 | 0.9
13 | 1.9
14 | 0.03
Spreadsheet: lindy_donoho__22122__West Throughput
Sheet: Sheet1

Estimated West Flow (MMBTU/Day)
 |  |  |  |  |  |  |  | 2002
 |  |  |  |  |  |  |  | Without
 |  | 2002 |  | 2001 |  | 2001 |  | Red Rock
 |  | Plan |  | CE |  | Plan |  | Outage
January |  | 1020 |  | 1109 |  | 1014 |  | 1020
February |  | 1022 |  | 1119 |  | 1018 |  | 1022
March |  | 998 |  | 1110 |  | 967 |  | 1009
April |  | 910 |  | 1104 |  | 949 |  | 1003
May |  | 910 |  | 1075 |  | 959 |  | 1006
June |  | 1072 |  | 1073 |  | 891 |  | 1089
July |  | 1101 |  | 1090 |  | 885 |  | 1101
August |  | 1117 |  | 1082 |  | 925 |  | 1117
September |  | 1112 |  | 1020 |  | 935 |  | 1112
October |  | 1119 |  | 1000 |  | 1055 |  | 1119
November |  | 1075 |  | 1002 |  | 1014 |  | 1075
December |  | 1072 |  | 1000 |  | 965 |  | 1072
Avg. Throughput
Avg. Load Factor |  | 0.904 |  | 0.97 |  | 0.89 |  | 0.92
Red Rock Outage Impact:
March
6 Days @ | 100,000/d
6 Days @ | 80,000/d
April & May
61 Days @ | 180,000/d
June
4 Days @ | 180,000/d
January (Possible Outage)
5 Days @ | 130,000/d
 | 21,000/d avg
Did not adjust Plan, volume already down to 1020
Spreadsheet: 74ff73c1-1e31-4dd6-b3bb-ab242612e435
Sheet: Sheet1

[NAME] | Unnamed: 1
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Ich bin bereit, länger zu arbeiten, damit meine [NAME] ist.
 | schweizweites Ergebnis
Antwort | schweizweites Ergebnis
Ja | 0.36
Neutral / Weiss nicht | 0.22
[NAME] | 0.41
Angaben zu den [NAME]
Erhebungsjahr | 2011
Stichprobengrösse | 30565
Erhebungszeitraum | 05.11.2011 bis: 30.12.2011
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 226001d1365198147-how-to-use-the-name-of-a-cell-to-reference-a-sheet-with-the-same-name-price-metrics_etaf
Sheet: Sheet6

Price to Book
 | 2010 | 2011 | 2012
CMO
AGNC
HTS
MFA
ARR
Price [NAME] (P/E)
 | 2010 | 2011 | 2012
CMO |  |  |  |  |  | g13 | [NAME] | I13
AGNC |  |  |  |  |  | g14 | H14 | I14
HTS |  |  |  |  |  | g15 | H15 | [NAME]
MFA |  |  |  |  |  | g16 | H16 | I16
ARR |  |  |  |  |  | g17 | H17 | I17
Spreadsheet: 27564d1220908149-automatic-notification-advances-to-suppliesr
Sheet: Sheet1

SR | [NAME] | Payment Date | Payment No | Amount | Today's Date | Days Elapsed | Requested by | E-mail
1 | AAAA | 2008-09-01 00:00:00 | 9005 | 1000 |  |  | Scott | [EMAIL]
2 | BBBB | 2008-08-07 00:00:00 | 9001 | 500 |  |  | [NAME] | [EMAIL]
3 | CCCC | 2008-09-07 00:00:00 | 9008 | 2000 |  |  | Reena | [EMAIL]
Spreadsheet: sally_beck__36212__Weekly Operating Report 5-30
Sheet: WE 5-16 EOL Data

EOL
 | Week ending 05/16 |  | Volumetric
New Deals for: | New Deals | Volume | Units
EA
Gas |  |  | MMBTU
Power |  |  | MHtz
EGM
Liquids |  |  | BBL
Coal |  |  | TONNE
Coal International |  |  | TONNE
Weather |  |  | HDD/CDD
IR/FX |  |  | USD
Emissions |  |  | CONTRACTS
EIM
Pulp & Paper |  |  | TONNE
Steel |  |  | TONNE
Number of new EOL Counterparties | 5
Non-EOL
 |  |  | Volumetric
New Deals for: | New Deals | Volume | Units
EA
Gas |  |  | MMBTU
Power |  |  | MHtz
EGM
Liquids |  |  | BBL
Coal |  |  | TONNE
Coal International |  |  | TONNE
Weather |  |  | HDD/CDD
IR/FX |  | 0 | USD
Emissions |  |  | CONTRACTS
EIM
Pulp & Paper |  |  | TONNE
Steel |  |  | TONNE
Clickpaper
 |  |  | Volumetric
New Deals for: | New Deals | Volume | Units
EIM
Lumber | 6 | 528000 | Board Feet
Newsprint
Pulp (recycled paper) | 6 | 3285 | [NAME]
Number of new CP Counterparties | 2
Lumber Converted
EIM TOTAL
Spreadsheet: eric_saibi__9869__101901R
Sheet: Pasco ST 01

Owner Name |  | Pasco Cogen Limited
Station Name |  | [NAME]
Unit Name |  | ST 01
NERC Region |  | SERC
State |  | FL
Fuel Type |  | Natural Gas
Capacity |  | 49 MW
Start Date |  | 2002-03-01 00:00:00
End Date |  | 2002-03-02 00:00:00
Prv. Start Date |  | 2001-10-19 00:00:00
Prv. End Date |  | 2001-10-20 00:00:00
Comments |  | External Inspection and Boroscope
SIC |  | 4931
Plant ID |  | 1013166
Unit ID |  | 1012005
Outage ID |  | 17070
Spreadsheet: 811934fa-1d2b-4130-998b-15c77de33127
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
SALM | Test | SALM | Salmon, IgE | Salmon, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
SALM | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SALM | Result | SALM | Salmon, IgE | Salmon, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6237-2 | Salmo salar Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 193977d1353000877-associating-a-list-with-positve-and-negative-numbers-formula-divisionexample
Sheet: Sheet1

 | (vs Damian B)
 | (vs [NAME])
 | (vs [NAME])
 | (vs [NAME]) |  |  | week 1 | week 2 | week 3 | week 4 | week 5
 | (vs [NAME] E)
 | (vs [NAME])
 | (vs [NAME]) |  |  | VERSUS
 | (vs [NAME] D) |  |  | 1 | 2 | 2 | 1 | 1
 | (vs [NAME]) |  |  | Damian B | [NAME] | [NAME] D | [NAME] | Keith E
 | (vs Brett B)
 |  |  |  | RESULT (Positve number = win   Negative number = loss)
1 | [NAME] |  |  | 20 | 30 | 14.3 | 40 | -20
 |  | W-L-T
 |  | 2-1-0 |  | Won |  |  | Won | Loss
Spreadsheet: 290638d1389926846-dealing-with-lists-where-the-number-of-records-change-offset-example
Sheet: Sheet3 - Calculations

 |  |  |  | Key field for Green | Key field for Blue | Key field match | Name match | Address match
Spreadsheet: 725790d1616861785-loan-calculation-formula-loansample
Sheet: H_E Loan Calculator

 | SIMPLE LOAN CALCULATOR
 | LOAN VALUES |  | 8000 | Start Value | LOAN SUMMARY
 |  | Dsicount
 |  | Deposit
 | Loan amount |  |  |  | Monthly payment
 | Annual interest rate |  | 0.044 |  | Number of payments
 | Loan period in years |  | 15 |  | Total interest
 | Start date of loan |  | 2021-01-01 00:00:00 |  | Total cost of loan
 | PMT NO. | PAYMENT DATE | BEGINNING BALANCE | PAYMENT | PRINCIPAL | INTEREST | ENDING BALANCE
Spreadsheet: 724759d1616354065-averaging-cells-in-one-column-based-on-another-book1
Sheet: Sheet1

34 | 8800
30 | 10500
30 | 10900
30 | 8000
31 | 7600
31 | 8000
34 | 8400
33 | 8500
34 | 8800
32 | 8300
35 | 9100
35 | 9000
39 | 9900
37 | 9200
34 | 8400
36 | 8900
36 | 9300
Spreadsheet: 879888d1727466541-conditional-formatting-issue-desertdwell-graddates-1-cf-365-aligw
Sheet: Sheet1

Course Title | TIP | CID | Class# | Conv/Grad | Conv | Grad
BASIC CRS |  | M092721 | 2025010 | 241007/241217 | 2024-10-07 00:00:00 | 2024-12-17 00:00:00
 |  |  | 2025020 | 241017/250113 | 2024-10-17 00:00:00 | 2025-01-13 00:00:00
 |  |  | 2025030 | 241025/250123 | 2024-10-25 00:00:00 | 2025-01-23 00:00:00
 |  |  | 2025040 | 241031/250129 | 2024-10-31 00:00:00 | 2025-01-29 00:00:00
 |  |  | 2025050 | 241115/250210 | 2024-08-15 00:00:00 | 2024-10-01 00:00:00
 |  |  | 2025060 | 241122/250219 | 2024-11-22 00:00:00 | 2025-02-19 00:00:00
 |  |  | 2025070 | 241203/250226 | 2024-12-03 00:00:00 | 2025-02-26 00:00:00
 |  |  | 2025080 | 250114/250321 | 2025-01-14 00:00:00 | 2025-03-21 00:00:00
 |  |  | 2025090 | 250123/250328 | 2025-01-23 00:00:00 | 2025-03-28 00:00:00
 |  |  | 2025100 | 250123/250328 | 2025-01-23 00:00:00 | 2025-03-28 00:00:00
 |  |  | 2025110 | 250131/250408 | 2025-01-31 00:00:00 | 2025-04-08 00:00:00
 |  |  | 2025120 | 250207/250415 | 2025-02-07 00:00:00 | 2025-04-15 00:00:00
 |  |  | 2025130 | 250220/250424 | 2025-02-20 00:00:00 | 2025-04-24 00:00:00
 |  |  | 2025140 | 250228/250505 | 2025-02-28 00:00:00 | 2025-05-05 00:00:00
 |  |  | 2025150 | 250310/250513 | 2025-03-10 00:00:00 | 2025-05-13 00:00:00
 |  |  | 2025160 | 250317/250520 | 2025-03-17 00:00:00 | 2025-05-20 00:00:00
 |  |  | 2025170 | 250331/250605 | 2025-03-31 00:00:00 | 2025-06-05 00:00:00
 |  |  | 2025180 | 250331/250605 | 2025-03-31 00:00:00 | 2025-06-05 00:00:00
 |  |  | 2025190 | 250414/250623 | 2025-04-14 00:00:00 | 2025-06-23 00:00:00
 |  |  | 2025200 | 250421/250630 | 2025-04-21 00:00:00 | 2025-06-30 00:00:00
 |  |  | 2025210 | 250428/250709 | 2025-04-28 00:00:00 | 2025-07-09 00:00:00
 |  |  | 2025220 | 250509/250721 | 2025-05-09 00:00:00 | 2025-07-21 00:00:00
 |  |  | 2025230 | 250516/250728 | 2025-05-16 00:00:00 | 2025-07-28 00:00:00
 |  |  | 2025240 | 250530/250807 | 2025-05-30 00:00:00 | 2025-08-07 00:00:00
 |  |  | 2025250 | 250606/250814 | 2025-06-06 00:00:00 | 2025-08-14 00:00:00
 |  |  | 2025260 | 250613/250820 | 2025-06-13 00:00:00 | 2025-08-20 00:00:00
 |  |  | 2025270 | 250626/250829 | 2025-06-26 00:00:00 | 2025-08-29 00:00:00
 |  |  | 2025280 | 250710/250912 | 2025-07-10 00:00:00 | 2025-09-12 00:00:00
 |  |  | 2025290 | 250718/250922 | 2025-07-18 00:00:00 | 2025-09-22 00:00:00
 |  |  | 2025300 | 250725/250930 | 2025-07-25 00:00:00 | 2025-09-30 00:00:00
 |  |  | 2025310 | 250808/251016 | 2025-08-08 00:00:00 | 2025-10-16 00:00:00
 |  |  | 2025320 | 250819/251027 | 2025-08-19 00:00:00 | 2025-10-27 00:00:00
 |  |  | 2025330 | 250905/251114 | 2024-09-16 00:00:00 | 2025-11-14 00:00:00
 |  |  | 2025340 | 250919/251202 | 2024-09-26 00:00:00 | 2025-10-01 00:00:00
Spreadsheet: 47402d1246446639-how-to-find-a-total-average-across-different-criteria-test
Sheet: Sheet1

Contracts completed | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | Total | Average per day | Percentage
Same day | 10 | 50
1 Day | 20 | 20
2 Days | 30 | 100
3 Days | 50 | 20
4 Days | 60 | 30
5 Days | 10
6 Days + |  | 15
Total |  |  |  |  |  |  |  |  | Average days taken | Within 4 days
 |  |  |  |  |  |  |  |  | ???
Spreadsheet: 101129d1299264246-return-1-or-0-based-on-date-range-example-2
Sheet: Months Covered

Year | Month | A | B | D | E | F | W | Totals | Baseline
2007 | 2007-01-01 00:00:00 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
2008 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
2009 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
2010 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
2011 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
2012 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
2013 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
2014 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
Spreadsheet: 840878d1693094082-return-split-values-in-a-dynamic-range-and-include-blanks-split-text-example
Sheet: Sheet1

Name |  | Current Result |  |  |  |  |  | Expected Result
[NAME] |  |  | [NAME] |  |  |  |  | [NAME] | [NAME]
Hortensia Gaius Aurelia Valentina Maximilla |  | Hortensia | Gaius | Aurelia | Valentina | [NAME] |  | Hortensia | Gaius | Aurelia | Valentina | [NAME]
 |  | Olivia | [NAME]
[NAME] |  | [NAME] | de | la | Cruz |  |  | Olivia | [NAME]
[NAME] |  | Juan | Martin | Hernandez |  |  |  | [NAME] | de | la | Cruz
 |  | Ava | [NAME]
[NAME] |  | [NAME] | White |  |  |  |  | Juan | Martin | Hernandez
[NAME] |  | Charlotte | [NAME] |  |  |  |  | Ava | [NAME]
[NAME] |  |  |  |  |  |  |  | [NAME] | White
[NAME] |  |  |  |  |  |  |  | Charlotte | [NAME]
Spreadsheet: john_griffith__15881__11_12_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 21 | 93 | 103 | 74.9 | 83 | 1.04 | 2001-11-12 14:01:00
 | CL F2 | 21.5 | 268 | 283 | 53 | 55.9 | 0.74 | 2001-11-12 14:01:00
 | CL G2 | 21.5 | 370 | 385 | 51.5 | 53.6 | 0.71 | 2001-11-12 14:01:00
 | CL H2 | 21.5 | 437 | 442 | 50.8 | 51.4 | 0.69 | 2001-11-12 14:01:00
 | CL J2 | 21.5 | 470 | 490 | 48 | 50 | 0.66 | 2001-11-12 14:01:00
 | CL K2 | 21.5 | 505 | 525 | 46 | 47.8 | 0.63 | 2001-11-12 14:01:00
 | CL M2 | 21.5 | 540 | 550 | 45.4 | 46.2 | 0.62 | 2001-11-12 14:01:00
 | CL N2 | 21.5 | 550 | 565 | 42.8 | 44 | 0.59 | 2001-11-12 14:01:00
 | CL Q2 | 21.5 | 550 | 570 | 40.3 | 41.7 | 0.55 | 2001-11-12 14:01:00
 | CL U2 | 21.5 | 555 | 575 | 38.6 | 40 | 0.53 | 2001-11-12 14:01:00
 | [NAME] | 21.5 | 558 | 578 | 36.9 | 38.2 | 0.51 | 2001-11-12 14:01:00
 | CL X2 | 21.5 | 560 | 580 | 35.4 | 36.7 | 0.49 | 2001-11-12 14:01:00
 | [NAME] | 21.5 | 562 | 582 | 34.3 | 35.6 | 0.47 | 2001-11-12 14:01:00
 | CL M3 | 21 | 560 | 580 | 29.5 | 30.5 | 0.4 | 2001-11-12 14:01:00
 | CL Z3 | 21 | 560 | 580 | 26.1 | 27.1 | 0.35 | 2001-11-12 14:01:00
Spreadsheet: f49b8c63-ee7d-4d61-8c61-fe82b77bd867
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8476 | 50070 | Martins | Drusts | LAT | 12 | 00:16:29 | 00:02:47 | 00:34:57 | 00:02:06 | 00:15:42 | 1 | 01:12:01
8476 | 30389 | [NAME] | Noordzij | NED | 11 | 00:17:40 | 00:03:51 | [NAME] | 00:02:07 | [NAME] | 2 | 01:19:02
Spreadsheet: 190840d1351801788-converting-data-that-is-showing-as-general-to-a-custom-time-format-scarames-template
Sheet: Sheet1

 |  |  | Only the columns with colored filled headings have to be in time format.
 | RUN | BLK | RTE | REPORT | ON | TIME | TIME | OFF | WORK | TOTAL | PLAT- | REPRT | TRAVL | MAKE | TOTAL | WORK | SPRD | TOTAL
 | NO. | NO. | NO. | TIME | LOC. | ON | OFF | LOC. | END | SPRD | FORM | ALLOW | ALLOW | UP | WORK | O/T | O/T | PAY
 | 3801 | 309 | 3 | 5:50a | SOUTH | 6:00a | 9:20a | SOUTH | 9:20a | 3:20 | 3:20 | 0:10 | 0:00 | 0:00 | 3:30 | 0:00 | 0:00 | 3:30
 | 3802 | 9104 | 91 | 6:00a | SOUTH | 6:10a | 11:45a | TCML | 12:05p | 5:35 | 5:35 | 0:10 | 0:20 | 0:20 | 6:05 | 0:00 | 0:00 | 6:05
 | 3803 | 115 | 1 | 6:25a | SOUTH | 6:35a | 11:05a | LKDX | 11:30a | 4:30 | 4:30 | 0:10 | 0:25 | 0:25 | 5:05 | 0:00 | 0:00 | 5:05
Spreadsheet: 836753d1689614295-how-to-compare-two-list-to-find-the-missing-package-number-missing-package
Sheet: Sheet3

 | Compare Data 1 with Data 2 to find out missing pakacge number in Data 1
 | Data 1 |  |  |  |  | Data 2
 | Package | Product Code | Unit |  |  | Package | Product Code | Unit |  |  | Missing Package
 | 4 | [NAME] | 1 |  |  | 1 | CK0201 | 1 |  |  | 1, 3, 6
 | 4 | AKW001 | 1 |  |  | 1 | AP001 | 1
 | 4 | MK002 | 1 |  |  | 1 | JK0021 | 1
 | 4 | MK002 | 1 |  |  | 1 | JK0021 | 1
 | 2 | MK002 | 1 |  |  | 2 | MK002 | 1
 | 2 | MK002 | 1 |  |  | 2 | MK002 | 1
 | 2 | MK002 | 1 |  |  | 2 | MK002 | 1
 | 2 | AP001 | 1 |  |  | 2 | AP001 | 1
 | 5 | MK002 | 1 |  |  | 3 | AP001 | 1
 | 5 | MK002 | 1 |  |  | 3 | PD0012 | 1
 | 7 | AKW001 | 1 |  |  | 3 | Pen01 | 1
 | 7 | MK002 | 1 |  |  | 4 | [NAME] | 1
 | 7 | MK002 | 1 |  |  | 4 | AKW001 | 1
 |  |  |  |  |  | 4 | MK002 | 1
 |  |  |  |  |  | 4 | MK002 | 1
 |  |  |  |  |  | 5 | MK002 | 1
 |  |  |  |  |  | 5 | MK002 | 1
 |  |  |  |  |  | 6 | BH01 | 1
 |  |  |  |  |  | 6 | BH01 | 1
 |  |  |  |  |  | 7 | AKW001 | 1
 |  |  |  |  |  | 7 | MK002 | 1
 |  |  |  |  |  | 7 | MK002 | 1
Spreadsheet: 134607d1325512504-trying-to-track-names-with-days-months-and-year-s-member-aging
Sheet: Sheet1

Name | [NAME] | Client Names | Date of Entry | Days in program | Months in program | Years in program
a | 2011-01-01 00:00:00 | [NAME] | 2011-01-29 00:00:00 | 367 | 12 | 1.002739726027397
b | 2009-01-02 00:00:00 | [NAME] | 2009-12-29 00:00:00 | 1096 | 37 | 3
c | 2011-11-15 00:00:00 | [NAME] | 2011-12-29 00:00:00 | 49 | 2 | 0.1315068493150685
d | 2010-01-19 00:00:00 | [NAME] | 2010-12-29 00:00:00 | 714 | 24 | 1.953424657534247
 |  | I am specifically looking for a calculation, whereas I sumit a 'Date of Entry' it can then update each date, month, and year a client has been in the program automatically.
 |  | However, thank you for this sample and starting point Sir / Ma'am.
 |  |  |  |  | - Two calculations for calculating Months and year have been provided above, choose whichever suits you.
Spreadsheet: john_griffith__16169__1_28_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | 53 | 50 | 110 | 43 | 60 | 1.72 | 2002-01-25 15:07:00
 | [NAME] | 53 | 530 | 630 | 45.4 | 54 | 1.66 | 2002-01-28 14:12:00
 | HO J2 | 53 | 770 | 870 | 46.8 | 52.9 | 1.66 | 2002-01-28 14:12:00
 | HO K2 | 53 | 920 | 1020 | 45.1 | 50 | 1.58 | 2002-01-28 14:12:00
 | HO M2 | 55 | 1050 | 1150 | 42.4 | 46.4 | 1.54 | 2002-01-28 14:12:00
 | HO N2 | 55 | 1110 | 1210 | 40.5 | 44.1 | 1.46 | 2002-01-28 14:12:00
 | HO Q2 | 56 | 1190 | 1290 | 38.9 | 42.2 | 1.43 | 2002-01-28 14:12:00
 | HO U2 | 56 | 1250 | 1375 | 37.8 | 41.6 | 1.4 | 2002-01-28 14:12:00
 | [NAME] | 57 | 1350 | 1475 | 37.8 | 41.3 | 1.42 | 2002-01-28 14:12:00
 | HO X2 | 58 | 1375 | 1500 | 35.6 | 38.9 | 1.36 | 2002-01-28 14:12:00
 | [NAME] | 59 | 1450 | 1600 | 35.3 | 39 | 1.38 | 2002-01-28 14:12:00
 | HO F3 | 60 | 1500 | 1650 | 34.4 | 37.9 | 1.36 | 2002-01-28 14:12:00
 | [NAME] |  |  |  | 33.2 | 36.5 | 1.31 | 2001-12-31 13:18:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]