tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 676896d1589042825-sorting-and-connecting-2020-05-0-oeldere-asojat-676887d1589041000-sorting-and-connecting-example1
Sheet: List1

Have: |  |  |  |  |  |  |  | Want to sort with formula: |  |  |  |  |  | Explanation
 |  |  |  |  | Vlookup
Level | Code | level |  |  | 0 | 1 |  | Level 1 | Level 2 | Level 3 |  |  |  | Level 1 = first number place | 1.
1 | 133XY |  |  |  | 2 | 2 |  | 133XY |  |  |  |  |  | Level 2 = 2nd number place (can be 1 to 3 digits) | 10.
1.10 | 2314XY |  |  |  | 5 | 3 |  |  | 2314XY |  |  |  |  | Level 3 = 3d nuber place | 1
1.10.1 | 231Ze |  |  |  |  |  |  |  |  | 231Ze
1.10.2 | 31WE |  |  |  |  |  |  |  |  | 31WE
Spreadsheet: fb5f7bf5-72bc-4d87-bcf3-08d4fd80b2f5
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
FC1EQ | Test | FC1EQ | C1 Esterase Inhibitor, Functional Assay, Serum | [NAME], Functional | Enzyme Immunoassay (EIA) | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube: Red top Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: 1. Immediately after drawing the specimen, place the tube on wet ice. 2. Spin down and separate serum from clot. 3. Freeze specimen immediately. Additional Information: Fasting preferred. | 0.1 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold reject Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | >67% normal (normal) 41-67% normal (equivocal) <41% normal (abnormal) | Varies | 1 day | 5 days | 1 | 83520 |  |  |  |  | Rochester
FC1EQ | [NAME] | SERUM | Serum |  |  |  | Frozen | 6 days
FC1EQ | Result | 81493 | [NAME], Functional, QN | [NAME], Functional, QN | Numeric |  |  |  |  | %of norm |  |  |  |  |  |  |  |  |  | 48494-9 | [NAME] esterase inhibitor actual/Normal:RelCCnc:Pt:Ser/Plas:Qn:
Spreadsheet: geir_solberg__11278__10_19act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: phillip_m_love__30643__HS FT Ont Central
Sheet: Financial Book Position

TIME BUCKET/KEY: |  |  | REPORT REGION | RISK TYPE | 1 |  | 2 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14
(Positions in Cont. [NAME].)     From: | Post ID |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total ECT
To: | Order |  |  |  |  |  | Index
FT - ONT - CENTRAL
Gas Daily | 1 |  | NGPRICE | P
Index | 1 |  | NGPRICE | P
Basis - Notional | 3 |  | NGLTX | P
Basis - Equivalent | 4 |  | NGFPL | P
Price | 5 |  | NGFPL | D
TOTAL:
Basis Roll-off
Post Ids
Price
Basis
Gas Daily
Spreadsheet: 67c87143-12ac-4cd8-9499-c3fe1b487518
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-10-12 09:26:48.590000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.644 | 101.519 | 101.394 | 101.019 |  | and are added to price quote
4.375 | 101.137 | 101.012 | 100.887 | 100.512
4.25 | 100.257 | 100.132 | 100.007 | 99.632 |  | Note: | Refer To Price [NAME]
4.125 | 99.835 | 99.71 | 99.585 | 99.21 |  |  | For all Price Adjs
4 | 99.366 | 99.241 | 99.116 | 98.491
3.875 | 98.765 | 98.64 | 98.515 | 97.89
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.217 | 101.092 | 100.967 | 100.592
3.75 | 100.662 | 100.537 | 100.412 | 100.037
3.625 | 100.227 | 100.102 | 99.977 | 99.602
3.5 | 99.887 | 99.762 | 99.637 | 99.262
3.375 | 99.436 | 99.311 | 99.186 | 98.561
3.25 | 98.888 | 98.763 | 98.638 | 98.013
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-10-26 09:26:48.590000
30 DAY | 2011-11-10 09:26:48.590000
45 DAY | 2011-11-25 09:26:48.590000
60 DAY | 2011-12-10 09:26:48.590000
90 DAY | 2012-01-09 09:26:48.590000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 806084d1669100131-copy-from-sheet-to-sheet-based-on-rows-and-columns-excel-help-example-ans-2
Sheet: October 2022

Sales | Location 1 | Location 3 | Location 4 | Location 5 | Location 6 | Location 7 | Location 8 | Location 9 | Location 10
2022-10-01 00:00:00
October 2022 Sales | 111111 | 333333 | 444444 | 555555 | 666666 | 777777 | 888888 | 1111110
October 2021 Sales
% Change | % | % | % | % | % | % | % | %
October 2020 Sales
% Change from 2022 | % | % | % | % | % | % | % | %
2019-11-01 00:00:00
Spreadsheet: 215461d1361385088-index-and-match-question-index-match-sample
Sheet: PA

 |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  | Sub
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Acme Corp 1 | Select Name
Acme Corp 2 | Select Name
Acme Corp 3 | Select Name
Acme Corp 4 | Select Name
 | Select Name
 | Select Name
 | Select Name
 | Select Name
 | Select Name
 | Select Name
TOTALS
[NAME]
[NAME]
[NAME]
Sue
[NAME]
[NAME]
[NAME]
[NAME]
Total (Match to Sub-Total)
Spreadsheet: 732021d1620744064-how-can-i-make-this-formula-simpler-shorter-sumif-test-file
Sheet: Sheet1

Partner number | C1 - city |  | C2 - city |  | C3 - city |  | C4 - city
 | Expert/trainer 1 | Expert/trainer 2 | Expert/trainer 1 | Expert/trainer 2 | Expert/trainer 1 | Expert/trainer 2 | Expert/trainer 1 | Expert/trainer 2
 | # days | # days | # days | # days | # days | # days | # days | # days
P1 | 2
P2 | 3 | 2
P3 |  | 4
P4 | 2 | 3
P5 | 4
P6 |  | 5
P7 | 4 | 2
P8 | 2
P9 | 3 | 4
P10 | 1
TOTAL
Total participants
Spreadsheet: 164764d1340886034-excel-format-issue-test-excel
Sheet: B

Date | Option A | Values
APR 07 | 1 | xxx
MAY 07
JUN 07
JUL 07
AUG 07 | 2 | xxx
SEP 07 | 3 | xxx
OCT 07
NOV 07
DEC 07 | 4 | xxx
JAN 08 | 5 | xxx
FEB 08
MAR 08
APR 08
MAY 08
JUN 08
JUL 08
AUG 08
SEP 08 | 6 | xxx
OCT 08 | 7 | xxx
NOV 08 | 8 | xxx
DEC 08 | 9 | xxx
JAN 09 | 10 | xxx
FEB 09 | etc | etc
MAR 09
APR 09
MAY 09
JUN 09
JUL 09
AUG 09
SEP 09
OCT 09
NOV 09
DEC 09
JAN 10
FEB 10
MAR 10
APR 10
MAY 10
JUN 10
JUL 10
AUG 10
SEP 10
OCT 10
NOV 10
DEC 10
JAN 11
FEB 11
MAR 11
APR 11
MAY 11
JUN 11
JUL 11
AUG 11
SEP 11
OCT 11
NOV 11
DEC 11
JAN 12
FEB 12
MAR 12
APR 12
MAY 12
JUN 12
JUL 12
AUG 12
SEP 12
OCT 12
NOV 12
DEC 12
JAN 13
FEB 13
MAR 13
APR 13
MAY 13
JUN 13
JUL 13
AUG 13
SEP 13
OCT 13
NOV 13
DEC 13
JAN 14
FEB 14
MAR 14
APR 14
MAY 14
JUN 14
JUL 14
AUG 14
SEP 14
OCT 14
NOV 14
DEC 14
JAN 15
FEB 15
MAR 15
APR 15
MAY 15
JUN 15
JUL 15
AUG 15
SEP 15
OCT 15
NOV 15
DEC 15
JAN 16
FEB 16
MAR 16
APR 16
MAY 16
JUN 16
JUL 16
AUG 16
SEP 16
OCT 16
NOV 16
DEC 16
JAN 17
FEB 17
MAR 17
APR 17
MAY 17
JUN 17
JUL 17
AUG 17
SEP 17
OCT 17
NOV 17
DEC 17
JAN 18
FEB 18
MAR 18
APR 18
MAY 18
JUN 18
JUL 18
AUG 18
SEP 18
OCT 18
NOV 18
DEC 18
JAN 19
FEB 19
MAR 19
APR 19
MAY 19
JUN 19
JUL 19
AUG 19
SEP 19
OCT 19
NOV 19
DEC 19
JAN 20
FEB 20
MAR 20
APR 20
MAY 20
JUN 20
JUL 20
AUG 20
SEP 20
OCT 20
NOV 20
DEC 20
JAN 21
FEB 21
MAR 21
APR 21
MAY 21
JUN 21
JUL 21
AUG 21
SEP 21
OCT 21
NOV 21
DEC 21
JAN 22
FEB 22
MAR 22
APR 22
MAY 22
JUN 22
JUL 22
AUG 22
SEP 22
OCT 22
NOV 22
DEC 22
Spreadsheet: 686435d1594625462-find-and-returns-value-of-a-table-from-multiple-criteria-sample-3
Sheet: Sheet1

Date | Value | Code | Customer
2020-01-01 00:00:00 | 5.2 | ABC | STEVE
2020-01-02 00:00:00 | -4.8 | DEF | STEVE
2020-01-03 00:00:00 | 3.2 | HIJ | MARK
2020-01-04 00:00:00 | -45.2 | KLM | MARK
2020-01-05 00:00:00 | 32.1 | NOP | TERRY
2020-01-06 00:00:00 | -56 | RST | MARK
2020-01-07 00:00:00 | -57.3 | XYZ | TERRY
2020-01-08 00:00:00 | 23.4 | XYZ | MARK
2020-01-09 00:00:00 | 32 | ABC | STEVE
2020-01-10 00:00:00 | -0.98 | DEF | TERRY
2020-01-11 00:00:00 | 11.58 | XYZ | STEVE
2020-01-12 00:00:00 | 5.2 | ABC | TERRY
2020-01-13 00:00:00 | 4.8 | ABC | STEVE
2020-01-14 00:00:00 | 3.2 | HIJ | MARK
2020-01-15 00:00:00 | -45.2 | KLM | STEVE
2020-01-16 00:00:00 | 32.1 | ABC | STEVE
2020-01-17 00:00:00 | -56 | XYZ | MARK
2020-01-18 00:00:00 | 57.3 | UVW | TERRY
2020-01-19 00:00:00 | 23.4 | ABC | STEVE
2020-01-20 00:00:00 | 32 | XYZ | TERRY
2020-01-21 00:00:00 | -5.2 | ABC | STEVE
2020-01-22 00:00:00 | -4.8 | HIJ | TERRY
2020-01-23 00:00:00 | 3.2 | ABC | TERRY
2020-01-24 00:00:00 | 45.2 | ABC | MARK
2020-01-25 00:00:00 | 32.1 | XYZ | TERRY
2020-01-26 00:00:00 | -56 | XYZ | STEVE
2020-01-27 00:00:00 | 57.3 | NOP | MARK
2020-01-28 00:00:00 | 23.4 | RST | TERRY
2020-01-29 00:00:00 | -32 | ABC | MARK
2020-01-30 00:00:00 | 0.98 | XYZ | TERRY
2020-01-31 00:00:00 | 11.58 | ABC | STEVE
Spreadsheet: 59998d1260527182-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-poss-new-budget-planner
Sheet: Marmy Ins

Marmy Insurance
Month | Year | Paymet
January | 2008
February | 2008
March | 2008
April | 2008
May | 2008
June | 2008
July | 2008
August | 2008
September | 2008
October | 2008
November | 2008
December | 2008
January | 2009
February | 2009
March | 2009 | 11.71
April | 2009 | 11.71
May | 2009 | 11.71
June | 2009 | 11.71
July | 2009 | 11.71
August | 2009 | 11.71
September | 2009 | 11.71
October | 2009
November | 2009
December | 2009
January | 2010
February | 2010
March | 2010
April | 2010
May | 2010
June | 2010
July | 2010
August | 2010
September | 2010
October | 2010
November | 2010
December | 2010
Spreadsheet: 188397d1350871851-populating-a-cell-with-text-based-on-the-rank-help-sample
Sheet: Sheet1

# PAID | REV/CLASS | FAC EXP | NET | DATE | DAY | TIME | CLASS | STUDIO | TEACHER |  |  | Rank
18 | 244.15 | 83.5 | 160.65 | 10/12/2012 | Friday | 10:00 am | Dance 2 | Holla | [NAME]
18 | 263 | 45 | 218 | 10/9/2012 | Tuesday | 6:30 pm | dance | Jeans Everywhere | [NAME]
609 | 7953.049999999999 | 5800 | 2153.05
Top Ten Performers |  |  |  |  |  | Top Ten Non-performers
1. [NAME] -Zumba-All Levels.- FH - Tuesday - 6:30PM |  |  |  |  |  | 1. [NAME] Jeans Everywhere - Tuesday- 6:30PM
2. [NAME] -  Broadway Jazz - Adv. Beg. - FH-Friday - 10:00AM |  |  |  |  |  | 2. [NAME]
Spreadsheet: 183075d1348689869-how-to-make-decimal-places-automatic-inspectionreportformatting
Sheet: Sheet1

 |  |  | Customer Part No: |  |  |  |  | Trueline Part No:
 |  |  | Customer: |  |  |  |  | Part/Print Revision:
 |  |  | Trueline Job No: |  |  |  |  | Date:
 |  |  | Inspector :
 | Rev
Crit. Dim | ID No. | Dimension Target | Tolerance  -/+ | Upper Spec Limit | Lower Spec Limit | Unit | Measuring Device | Device ID | Piece    1 | Piece    2 | Piece    1. | Piece 2.
 |  | 1.00 |  |  |  | [NAME] |  |  | 1 | 2 | 3 | 4
 |  | 1.0 |  |  |  |  |  |  | 1 | 2 | 3 | 4
 |  | 1.0 |  |  |  |  |  |  | 1 | 2 | 3 | 4
 |  | 1.0000 |  |  |  |  |  |  | 1 | 2 | 3 | 4
Spreadsheet: 482823d1475255460-find-first-available-cell-0-in-a-row-and-using-next-cell-0-thereafter-for-a-calculation-book1-sample
Sheet:  Application Factors

Generated | Location | Tarp | Months | [NAME] | Application Factor | Township | County | Count of Counties | Location | Tarp | Months | [NAME] | Application Factor | Adjusted Lbs of 1,3-D
 | Within San Joaquin Valley | Non 60% credit | Jan | Shallow | PROHIBITED |  |  |  | Within San Joaquin Valley | Non 60% credit | Feb-Nov | Drip
 | Within San Joaquin Valley | Non 60% credit | Jan | Deep | 1.9 |  |  |  | Within San Joaquin Valley | Non 60% credit | Feb-Nov | Strip
 | Within San Joaquin Valley | Non 60% credit | Jan | Strip | PROHIBITED |  |  |  | Outside San Joaquin Valley | Non 60% credit | Feb-Nov | Strip
 | Within San Joaquin Valley | Non 60% credit | Jan | Drip | 1.16 |  |  |  | Within San Joaquin Valley | 60% credit | Jan | Deep
 | Within San Joaquin Valley | Non 60% credit | Feb-Nov | Shallow | 1.9 |  |  |  | Outside San Joaquin Valley | 60% credit | Feb-Nov | Strip
 | Within San Joaquin Valley | Non 60% credit | Feb-Nov | Deep | 1 |  |  |  | Outside San Joaquin Valley | 60% credit | Jan | Drip
 | Within San Joaquin Valley | Non 60% credit | Feb-Nov | Strip | PROHIBITED
 | Within San Joaquin Valley | Non 60% credit | Feb-Nov | Drip | 1.16
 | Within San Joaquin Valley | 60% credit | Jan | Shallow | 0.6
 | Within San Joaquin Valley | 60% credit | Jan | Deep | 0.6
 | Within San Joaquin Valley | 60% credit | Jan | Strip | 1.2
 | Within San Joaquin Valley | 60% credit | Jan | Drip | 1.16
 | Within San Joaquin Valley | 60% credit | Feb-Nov | Shallow | 0.3
 | Within San Joaquin Valley | 60% credit | Feb-Nov | Deep | 0.3
 | Within San Joaquin Valley | 60% credit | Feb-Nov | Strip | 0.6
 | Within San Joaquin Valley | 60% credit | Feb-Nov | Drip | 1.16
 | Outside San Joaquin Valley | Non 60% credit | Jan | Shallow | 2.3
 | Outside San Joaquin Valley | Non 60% credit | Jan | Deep | 1.2
 | Outside San Joaquin Valley | Non 60% credit | Jan | Strip | PROHIBITED
 | Outside San Joaquin Valley | Non 60% credit | Jan | Drip | 1.16
 | Outside San Joaquin Valley | Non 60% credit | Feb-Nov | Shallow | 1.9
 | Outside San Joaquin Valley | Non 60% credit | Feb-Nov | Deep | 1
 | Outside San Joaquin Valley | Non 60% credit | Feb-Nov | Strip | PROHIBITED
 | Outside San Joaquin Valley | Non 60% credit | Feb-Nov | Drip | 1.16
 | Outside San Joaquin Valley | 60% credit | Jan | Shallow | 0.6
 | Outside San Joaquin Valley | 60% credit | Jan | Deep | 0.6
 | Outside San Joaquin Valley | 60% credit | Jan | Strip | 1.2
 | Outside San Joaquin Valley | 60% credit | Jan | Drip | 1.16
 | Outside San Joaquin Valley | 60% credit | Feb-Nov | Shallow | 0.3
 | Outside San Joaquin Valley | 60% credit | Feb-Nov | Deep | 0.3
 | Outside San Joaquin Valley | 60% credit | Feb-Nov | Strip | 0.6
 | Outside San Joaquin Valley | 60% credit | Feb-Nov | Drip | 1.16
Spreadsheet: 469877d1468230975-sum-of-day-with-date-range-data
Sheet: Sheet1

M/F | DATE OPEN | ETA | NO OF DAYS |  |  |  | SUM OF DAYS
F | 2016-07-03 00:00:00 | 2016-07-07 00:00:00 |  |  | FROM | TO | M | F
M | 2016-07-04 00:00:00 | 2016-07-08 00:00:00 |  |  | 2016-07-04 00:00:00 | 2016-07-10 00:00:00
M | 2016-07-04 00:00:00 | 2016-07-07 00:00:00 |  |  | 2016-07-11 00:00:00 | 2016-07-17 00:00:00
M | 2016-07-05 00:00:00 | 2016-07-07 00:00:00 |  |  | 2016-07-18 00:00:00 | 2016-07-24 00:00:00
F | 2016-07-05 00:00:00 | 2016-07-08 00:00:00 |  |  | 2016-07-25 00:00:00 | 2016-07-31 00:00:00
M | 2016-07-05 00:00:00 | 2016-07-10 00:00:00 |  |  | 2016-08-01 00:00:00 | 2016-08-07 00:00:00
F | 2016-07-06 00:00:00 | 2016-07-10 00:00:00 |  |  | 2016-08-08 00:00:00 | 2016-08-14 00:00:00
M | 2016-07-07 00:00:00 | 2016-07-11 00:00:00 |  |  | 2016-08-15 00:00:00 | 2016-08-21 00:00:00
M | 2016-07-07 00:00:00 | 2016-07-11 00:00:00 |  |  | 2016-08-22 00:00:00 | 2016-08-28 00:00:00
M | 2016-07-05 00:00:00 | 2016-07-11 00:00:00
M | 2016-07-09 00:00:00 | 2016-07-12 00:00:00
M | 2016-07-08 00:00:00 | 2016-07-12 00:00:00
M | 2016-07-06 00:00:00 | 2016-07-12 00:00:00
F | 2016-07-07 00:00:00 | 2016-07-12 00:00:00
M | 2016-07-09 00:00:00 | 2016-07-13 00:00:00
F | 2016-07-08 00:00:00 | 2016-07-13 00:00:00
F | 2016-07-09 00:00:00 | 2016-07-14 00:00:00
M | 2016-07-09 00:00:00 | 2016-07-14 00:00:00
F | 2016-07-09 00:00:00 | 2016-07-14 00:00:00
M | 2016-07-09 00:00:00 | 2016-07-14 00:00:00
M | 2016-07-09 00:00:00 | 2016-07-15 00:00:00
F | 2016-07-09 00:00:00 | 2016-07-15 00:00:00
F | 2016-07-09 00:00:00 | 2016-07-15 00:00:00
M | 2016-07-10 00:00:00 | 2016-07-15 00:00:00
M | 2016-07-11 00:00:00 | 2016-07-15 00:00:00
F | 2016-07-11 00:00:00 | 2016-07-16 00:00:00
F | 2016-07-10 00:00:00 | 2016-07-17 00:00:00
Spreadsheet: 25258d1216397034-advanced-filter-question-copy1-2-tool
Sheet: Sheet1

B | S | BR | QT | ab | cd | ef | gh | hj | jk | lo | pi | pr | hr | hc | ar | ac | le | lc | ad | ac | lr | lc
BR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <50
 |  |  |  |  | TOOL
INPUTS
AD |  |  |  | 100 |  | B | Br
B | S | BR | QT | ab | cd | ef | gh | hj | jk | lo | pi | pr | hr | hc | ar | ac | le | lc | ad | ac | lr | lc
AB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
BC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
CD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
BR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65
BC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
AB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52
BR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
AB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
AB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62
BR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
BR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
CD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82
Spreadsheet: 466176d1466043650-how-to-use-excell-to-track-hours-of-srevice-driver-log-rough-draft
Sheet: Sheet1

 | Date | Hours Off Since The Day Before | Time In | Time Out | Daily Hours
Monday | 2016-06-15 00:00:00 | N/A | 05:00:00 | 17:00:00
Tuesday | 2016-06-16 00:00:00 |  | 04:00:00 | 17:00:00
Wednesday | 2016-06-17 00:00:00 |  | 03:30:00 | 17:00:00
Thursday | 2016-06-18 00:00:00 |  | 04:00:00 | 17:00:00
Friday | 2016-06-19 00:00:00 |  | 09:00:00 | 17:00:00
Saturday | 2016-06-20 00:00:00 |  | 10:00:00 | 17:00:00
Sunday | 2016-06-21 00:00:00 |  | 09:00:00 | 17:00:00
Total
Spreadsheet: scott_neal__37927__STOR9816
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9816
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2001-01-26 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 312 | 296
(TX, LA, OK, KS, MS)
Market Area - East |  | 816 | 723
Market Area - West |  | 241 | 222
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 1335 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871
Spreadsheet: 877037d1723720868-excel-vlookup-or-something-else-apples-and-oranges
Sheet: Sheet1

Original |  |  |  |  |  |  | What it needs to say
Item name | Volume |  | [NAME] formula |  | WK9128 formula
[NAME] | 5 |  |  |  |  |  | Apple | 19
apple1 | 9 |  |  |  |  |  | Orange | 17
apple2 | 5 |  |  |  |  |  | [NAME] | 8
orange | 3
orange1 | 8
orange5 | 1
banana | 2
banana4 | 6
Spreadsheet: 724248d1616086559-flexible-data-example
Sheet: DI

 | Date | Value
 | 2021-01-04 00:00:00 | 1.00024583
 | 2021-01-05 00:00:00 | 1.00024583
 | 2021-01-06 00:00:00 | 1.00024583
 | 2021-01-07 00:00:00 | 1.00024583
 | 2021-01-08 00:00:00 | 1.00024583
 | 2021-01-11 00:00:00 | 1.00024583
 | 2021-01-12 00:00:00 | 1.00024583
 | 2021-01-13 00:00:00 | 1.0002462
 | 2021-01-14 00:00:00 | 1.0002462
 | 2021-01-15 00:00:00 | 1.0002462
 | 2021-01-18 00:00:00 | 1.0002462
 | 2021-01-19 00:00:00 | 1.0002462
 | 2021-01-20 00:00:00 | 1.0002462
 | 2021-01-21 00:00:00 | 1.0002462
 | 2021-01-22 00:00:00 | 1.0002462
 | 2021-01-25 00:00:00 | 1.0002462
 | 2021-01-26 00:00:00 | 1.0002462
 | 2021-01-27 00:00:00 | 1.0002462
 | 2021-01-28 00:00:00 | 1.0002462
 | 2021-01-29 00:00:00 | 1.0002462
 | 2021-02-01 00:00:00 | 1.0002462
 | 2021-02-02 00:00:00 | 1.00007469
 | 2021-02-03 00:00:00 | 1.00007469
 | 2021-02-04 00:00:00 | 1.00007469
 | 2021-02-05 00:00:00 | 1.00007469
 | 2021-02-08 00:00:00 | 1.00007469
 | 2021-02-09 00:00:00 | 1.00007469
 | 2021-02-10 00:00:00 | 1.00007469
 | 2021-02-11 00:00:00 | 1.00007469
 | 2021-02-12 00:00:00 | 1.00007469
 | 2021-02-17 00:00:00 | 1.00007469
 | 2021-02-18 00:00:00 | 1.00007469
 | 2021-02-19 00:00:00 | 1.00007469
 | 2021-02-22 00:00:00 | 1.00007469
 | 2021-02-23 00:00:00 | 1.00007469
 | 2021-02-24 00:00:00 | 1.00007469
 | 2021-02-25 00:00:00 | 1.00007469
 | 2021-02-26 00:00:00 | 1.00007469
 | 2021-03-01 00:00:00 | 1.00007469
 | 2021-03-02 00:00:00 | 1.00007469
 | 2021-03-03 00:00:00 | 1.00007469
 | 2021-03-04 00:00:00 | 1.00007469
 | 2021-03-05 00:00:00 | 1.00007469
 | 2021-03-08 00:00:00 | 1.00007469
 | 2021-03-09 00:00:00 | 1.00007469
 | 2021-03-10 00:00:00 | 1.00007469
 | 2021-03-11 00:00:00 | 1.00007469
 | 2021-03-12 00:00:00 | 1.00007469
 | 2021-03-15 00:00:00 | 1.00007469
 | 2021-03-16 00:00:00 | 1.00007469
Spreadsheet: 203079d1356925932-show-the-sum-of-a-list-of-numbers-onto-another-sheet-twisted_solution
Sheet: Sheet1

 |  |  | 47
 |  |  | 62
 |  |  | 21
 |  |  | 57
 |  |  | 45
 |  |  | 54
 |  |  | 68
 |  |  | 39
 |  |  | 54
 |  |  | 32
 |  |  | 87
 |  |  | 46
 |  |  | 50
 |  |  | 46
 |  |  | 21
 |  |  | 59
 |  |  | 46
 |  |  | 46
 |  |  | 98
 |  |  | 15
 |  |  | 18
 |  |  | 64
 |  |  | 60
 |  |  | 66
 |  |  | 22
 |  |  | 37
 |  |  | 15
Spreadsheet: 7332c1d6-2fd6-4fbc-a162-a60e4c728a49
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259509 | 41349 | [NAME] | Aranha | BRA | 35 | 00:16:32 | 00:02:16 | 00:39:27 | [NAME] | [NAME] | 1 | 01:13:52
259509 | 73528 | Eliziario | [NAME] | BRA | 37 | 00:20:05 | 00:06:54 | 00:42:20 | [NAME] | 00:17:28 | 2 | 01:30:26
259509 | 73527 | [NAME] | [NAME] | BRA | 38 | 00:24:54 | 00:02:41 | 00:55:01 | 00:02:23 | 00:20:52 | 3 | 01:45:53