tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 764403d1642713392-formula-to-adjust-a-rate-based-on-lookup-of-dept-payroll-sample
Sheet: Tab 2

No. | 105 |  |  | Base Rate |  | C61C | 0
Name |  |  |  | Adjusted Rate | 25 | C61CJ | 0
 |  |  |  |  |  | C61Q | 0.2
 |  |  |  |  |  | C61QJ | 0.2
 |  |  |  |  |  | C65D | 0.1
 |  |  |  |  |  | C65DJ | 0.1
 |  |  |  |  |  | C65F | 0.1
 |  |  |  |  |  | C65FJ | 0.1
 |  |  |  |  |  | C65L | 0.3
 |  |  |  |  |  | C65LJ | 0.3
 |  |  |  |  |  | C65S | 0.3
 |  |  |  |  |  | [NAME] | 0.3
 |  |  |  |  |  | C67G | 0.3
 |  |  |  |  |  | C67GJ | 0.3 |  |  | 1.  get the code corresponding to emp num
 |  |  |  |  |  |  |  |  |  | 2.  get the corresp. Adjustment
 |  |  |  |  |  |  |  |  |  | 3.  check if type FRx?
 |  |  |  |  |  |  |  |  |  | combine above to one formula
Spreadsheet: 69197d1269708472-conditional-format-using-ranges-cfexample1
Sheet: Sheet1

17
18
19
20 | 1
21 | 3
22
23
24 | 8
25
26
27 | 9
28
29 | 11
30
31
32
33
34 | 12
35
36 | 88
37
38 | 104
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
99
98
99
100
Spreadsheet: mary_fischer__25605__926
Sheet: E16.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 0926
COMPANY NAME Artemis Associates
ANALYSIS OF (GAIN) LOSS ON SALES OF ASSETS
FOR THE 3 MONTHS ENDED 3-31-2001
PREPARED BY: Sonya City
EXTENSION: 39690
**LIST ALL PROPERTY SALES INCLUDING SALES OF REGULATORY ASSETS
**REGULATED COMPANIES DO NOT SHOW (GAIN)/LOSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  | (A) | + | (B) | + | (C) |  |  | + | (D) | + | (E) | + | (F) | + | (G) |  |  | =
 |  |  |  | GROSS SALE PROCEEDS |  |  |  | NET BOOK VALUE |  |  |  |  |  |  |  |  |  | OTHER (EXPLAIN) |  |  |  | (GAIN) LOSS
 |  | DATE |  |  |  | N/R OR OTHER |  | ASSET |  |  |  |  |  | ACCUM |  | EXP ASSOC |  | AMOUNT |  | HYPERION |  | DR / (CR)
[NAME] OF ASSET |  | OF SALE |  | CASH | + | (EXPLAIN BELOW) | + | AMOUNT |  | HYPERION ACCT | + | PP&E | + | [NAME] | + | WITH SALE | + | DR (CR) |  | ACCT | = | ENDING BAL |  | COMMENTS
PROCEEDS OR BOOK VALUE OF ASSETS
OF $1,000,000 OR MORE:
SALES OF PP&E
SALES OF OTHER ASSETS
 |  |  |  |  |  | (B)
OTHER (LESS THAN $1,000,000) :
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ACCT 1676
 |  | EXPLAIN: |  |  |  |  |  |  |  |  |  |  |  |  | Hyperion Income Accts :  DR/(CR)
 |  | Notes Receivable |  |  |  |  |  |  |  |  |  |  |  |  |  | Signs are reversed from Hyperion
 |  | (list amounts and terms):
 |  | Other:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  |  |  | (B)
Spreadsheet: 850374d1700734394-formula-producing-crazy-dates-in-excel-test-file-8-aligw
Sheet: Sheet1

 |  |  | SKU codes |  | start date |  | What excel sees as a date
 |  |  | POROBA280523
 |  |  | FALPOR270323
 |  |  | ISAKUL030723
 |  |  | FALPOR270323
 |  |  | BODBOD050623
 |  |  | VIGPOR060323
 |  |  | ENGSTM260223
Spreadsheet: 866918d1713824671-average-ifs-within-a-targeted-range-example
Sheet: Sheet1

 | 2023 |  |  |  |  | 2022 |  |  |  |  | 2023 chg
 | Revenue | OI | EBITDA | EPS |  | Revenue | OI | EBITDA | EPS |  | Revenue | OI | EBITDA | EPS
BUNNY | 957.672 | 167.958 | 201.321 | 9.92 | 9.92 | 904.739 | 154.428 | 189.128 | 9.24
BEAR | 800.9 | -14.8 | 180.7 | 0.34 | 0.34 | 717.8 | -200 | -123.3 | 0.37
[NAME] | 3433.763 | 50000 | 193.236 | 1.27 |  | 2613.399 | 106.038 | 157.863 | 1.54
LIOn | 794.045 | 56.301 | 89.192 | 0.63 |  | 546.259 | 15.138 | 50.384 | 0.28
 |  |  |  |  |  |  |  |  |  |  |  | 0.08761364519387671 | 0.1442718022335137 | -0.0609375609375609
Spreadsheet: 886699d1736800939-filter-out-all-error-codes-and-return-highes-absolute-value-filter-error-codes
Sheet: Sheet1

Identifier | Apple | Cat | Taco | Car
372.5 | #[NAME]! | #[NAME]! | NaN | NaN
375 | #[NAME]! | #[NAME]! | 2 | 0
377.5 | 0 | -4 | NaN | NaN
380 | -10 | 0 | 11 | 0
382.5 | -21 | 0 | NaN | NaN
385 | #[NAME]! | #[NAME]! | 6 | 0
387.5 | 0 | -6 | 3 | 0
390 | -52 | -4 | 27 | 0
392.5 | -9 | 0 | 1 | 9
395 | 0 | -45 | 8 | 0
397.5 | 0 | -2 | 15 | 20
400 | 0 | -32 | 4 | 120
402.5 | #[NAME]! | #[NAME]! | 9 | 0
405 | -1 | -2 | 2 | 3
407.5 | -3 | 0 | NaN | NaN |  | Largest AbsVal ->
410 | 0 | -31 | 2 | 0
412.5 | -201 | -8 | NaN | NaN
415 | 0 | -22 | 0 | 2
417.5 | #[NAME]! | #[NAME]! | NaN | NaN
420 | 0 | -17 | NaN | NaN
Spreadsheet: 715442d1611705998-formula-for-selecting-one-of-24-option-log-on-formula
Sheet: Sheet1

 |  | 2
[EMAIL] |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
Spreadsheet: 701256d1603658087-numbering-a-multi-heading-excel-column-numbering-tdungdinh-
Sheet: Eng

Name | Country | Class | Score |  |  |  | Order | Country | Score
[NAME] | VIETNAM | Class 10 | 10 |  |  |  |  | RUSSIA | 38
[NAME] | VIETNAM | Class 11 | 9 |  |  |  |  | Class 10 | 8
[NAME] | VIETNAM | Class 11 | 8 |  |  |  |  | [NAME] | 8
[NAME] | ENGLAND | Class 10 | 5 |  |  |  |  | Class 11 | 7
Robben [NAME] | ENGLAND | Class 12 | 6 |  |  |  |  | Lenina | 7
Ricardo Ivanhoe | ENGLAND | Class 12 | 5 |  |  |  |  | Class 12 | 23
[NAME] | FRANCE | Class 11 | 10 |  |  |  |  | [NAME] | 8
[NAME] | FRANCE | Class 12 | 9 |  |  |  |  | Lewandos Expki | 8
[NAME] | RUSSIA | Class 12 | 7 |  |  |  |  | [NAME] | 7
[NAME] | RUSSIA | Class 12 | 8 |  |  |  |  | VIETNAM | 34
Lewandos Expki | RUSSIA | Class 12 | 8 |  |  |  |  | Class 10 | 10
[NAME] | USA | Class 10 | 7 |  |  |  |  | [NAME] | 10
[NAME] | USA | Class 11 | 7 |  |  |  |  | Class 11 | 17
Ivanhoe Imhotep | USA | Class 11 | 6 |  |  |  |  | [NAME] | 9
Golden Dercis | FRANCE | Class 10 | 9 |  |  |  |  | [NAME] | 8
Le Tuan Anh | VIETNAM | Class 12 | 7 |  |  |  |  | Class 12 | 7
[NAME] | RUSSIA | Class 10 | 8 |  |  |  |  | Le Tuan Anh | 7
Lenina | RUSSIA | Class 11 | 7
[NAME] | USA | Class 12 | 5
[NAME] | ENGLAND | Class 11 | 9
Spreadsheet: 101599d1299693466-lookup-quantity-of-part-by-warehouse-inventory-counts_upload
Sheet: 2300

ITEM | DESC | [NAME] | ONHAND
1452 | DECAL STAND CLEAR LONG | 2300 | 0
1453 | DECAL-CAUTION AUTOMATIC DOOR | 2300 | 0
1454 | DECAL-DO NOT ENTER/IN | 2300 | 0
1455 | DECAL-DO NO ENTER/OUT | 2300 | 0
1456 | DECAL-IN EMERGENCY PTO | 2300 | 0
1457 | DECAL-HANDICAP LOGO | 2300 | 0
1458 | 5 AMP FUSE | 2300 | 0
1459 | DECAL CARRIER CASE | 2300 | 0
1460 | RIVNUT | 2300 | 0
1461 | HORTON DECAL CAUTION AUTO.DOOR | 2300 | 0
1462 | DECAL - STAND CLEAR | 2300 | 0
1463 | CUSTOM STAND CLEAR DECAL | 2300 | 0
1464 | AUTOMATIC DOOR DECAL | 2300 | 0
1452 | DECAL STAND CLEAR LONG | 2301 | 0
1453 | DECAL-CAUTION AUTOMATIC DOOR | 2301 | 16
1454 | DECAL-DO NOT ENTER/IN | 2301 | 5
1455 | DECAL-DO NO ENTER/OUT | 2301 | 5
1456 | DECAL-IN EMERGENCY PTO | 2301 | 5
1457 | DECAL-HANDICAP LOGO | 2301 | 5
1458 | 5 AMP FUSE | 2301 | 0
1460 | RIVNUT | 2301 | 0
1461 | HORTON DECAL CAUTION AUTO.DOOR | 2301 | 0
1462 | DECAL - STAND CLEAR | 2301 | 1
1463 | CUSTOM STAND CLEAR DECAL | 2301 | 0
1464 | AUTOMATIC DOOR DECAL | 2301 | 11
1452 | DECAL STAND CLEAR LONG | 2350 | 0
1453 | DECAL-CAUTION AUTOMATIC DOOR | 2350 | 0
1454 | DECAL-DO NOT ENTER/IN | 2350 | 0
1455 | DECAL-DO NO ENTER/OUT | 2350 | 0
1456 | DECAL-IN EMERGENCY PTO | 2350 | 0
1457 | DECAL-HANDICAP LOGO | 2350 | 0
1458 | 5 AMP FUSE | 2350 | 0
1460 | RIVNUT | 2350 | 0
1461 | HORTON DECAL CAUTION AUTO.DOOR | 2350 | 0
1462 | DECAL - STAND CLEAR | 2350 | 0
1463 | CUSTOM STAND CLEAR DECAL | 2350 | 0
1464 | AUTOMATIC DOOR DECAL | 2350 | 0
1452 | DECAL STAND CLEAR LONG | 2351 | 0
1453 | DECAL-CAUTION AUTOMATIC DOOR | 2351 | 0
1454 | DECAL-DO NOT ENTER/IN | 2351 | 0
1455 | DECAL-DO NO ENTER/OUT | 2351 | 0
1456 | DECAL-IN EMERGENCY PTO | 2351 | 0
1457 | DECAL-HANDICAP LOGO | 2351 | 0
1458 | 5 AMP FUSE | 2351 | 0
1460 | RIVNUT | 2351 | 0
1461 | HORTON DECAL CAUTION AUTO.DOOR | 2351 | 0
1462 | DECAL - STAND CLEAR | 2351 | 0
1463 | CUSTOM STAND CLEAR DECAL | 2351 | 0
1464 | AUTOMATIC DOOR DECAL | 2351 | 0
 |  |  | 25
Spreadsheet: theresa_staab__39630__Citation Statement
Sheet: Statement

 |  |  | BEAR PAW ENERGY INC.
 |  |  | 370 17TH Street, [NAME] 2775
 |  |  | Denver, CO  80202
 |  |  | (303)626-8293
 | ANTELOPE VALLEY GAS BALANCING STATEMENT
Producer: | Citation Oil & Gas Corp.
 | 8223 Willow Place South
 | Houston, TX  77070-5623
 |  |  |  |  |  |  | Cumulative | Cumulative
 | Gas | Gas | Gas | Gas | Monthly | Monthly | Mcf  Due | MMBtu  Due
 | Delivered | Delivered | Allocated | Allocated | Imbalance | Imbalance | Producer | Producer
 | Mcf | MMBtu | Mcf | MMBtu | Mcf | MMBtu | (Bear Paw) | (Bear Paw)
2000-01-01 00:00:00 |  |  |  |  |  |  | 1391
2000-02-01 00:00:00 |  |  |  | 18974
2000-03-01 00:00:00 |  | 27345 |  | 25258
2000-04-01 00:00:00 | 28536 | 27506 | 29427 | 28500
April, revised | 28998 | 27951 | 29426 | 28500
2000-05-01 00:00:00 | 29765 | 28673 | 37999 | 36727
2000-06-01 00:00:00 | 28828 | 27793 | 20333 | 19693
2000-07-01 00:00:00 | 26382 | 25436 | 33540 | 32488
Spreadsheet: 146497d1332219221-macro-clear-function-in-a-row-that-has-value-choosingteams2v
Sheet: players

[NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME]
pat |  |  |  |  |  |  |  |  |  |  |  | pat
gene |  |  |  |  |  |  |  |  |  |  |  | gene
rod |  |  |  |  |  |  |  |  |  |  |  | rod
dirk |  |  |  |  |  |  |  |  |  |  |  | dirk
ira |  |  |  |  |  |  |  |  |  |  |  | ira
parks |  |  |  |  |  |  |  |  |  |  |  | parks
elmer |  |  |  |  |  |  |  |  |  |  |  | elmer
sdf |  |  |  |  |  |  |  |  |  |  |  | sdf
wer |  |  |  |  |  |  |  |  |  |  |  | wer
tyu |  |  |  |  |  |  |  |  |  |  |  | tyu
hjk |  |  |  |  |  |  |  |  |  |  |  | hjk
[NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME]
tyio |  |  |  |  |  |  |  |  |  |  |  | tyio
Spreadsheet: 809850d1671374303-how-to-only-show-data-on-page-soa-mo-10-lf-there-is-data-in-gl-mo-10-oktober-2022-nuut-01-1-
Sheet: Summary by Month

Calendar Year
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total YTD
Cash Beginning of Period
Revenue
 | Total Revenue:
Expenses:
 | Totaale Uitgawes:
Net Balance: Gain / (Loss)
Cash End of Period - PER BOOKS
 | BANK 1 - Enter Number from Bank Statement
 | Bank 2 - Checking Acct
 | Bank 2 - Savings Acct
TOTAL CASH BALANCE - PER STMTS
 | zero balance - unless checks outstanding
Spreadsheet: 871866d1718263922-converting-a-20-yr-dataset-to-annual-dataset-sample-time-series
Sheet: Sheet3

Date & Time | supply | Period (h) | demand
1/05/2004 9:00 AM | 0 | 1
1/05/2004 10:00 AM | 33962.42752 | 1
1/05/2004 11:00 AM | 3258.1626 | 1
1/05/2004 12:00 PM | 2740.31674 | 1
1/05/2004 1:00 PM | 17902.2312 | 1
1/05/2004 2:00 PM | 2.80798 | 1
1/05/2004 3:00 PM | 160.14544 | 1
1/05/2004 4:00 PM | 3175.2819 | 1
1/05/2004 5:00 PM | 35105.72828 | 1
1/05/2004 6:00 PM | 21428.60118 | 1
1/05/2004 7:00 PM | 164872.26672 | 1
1/05/2004 8:00 PM | 87734.4293 | 1
1/05/2004 9:00 PM | 26615.5743 | 1
1/05/2004 10:00 PM | 2354.80826 | 1
1/05/2004 11:00 PM | 46146.25274 | 1
2/05/2004 12:00 AM | 13706.38444 | 1
2/05/2004 1:00 AM | 0 | 1
2/05/2004 2:00 AM | 38495.86594 | 1
2/05/2004 3:00 AM | 165978.70142 | 1
2/05/2004 4:00 AM | 217354.4093 | 1
2/05/2004 5:00 AM | 326088 | 1
2/05/2004 6:00 AM | 141440.39826 | 1
2/05/2004 7:00 AM | 196190.8452 | 1
…
20 yr annual average (GWh) | 1191.510319804519
Spreadsheet: 54537d1254517721-excel-2007-pool-league-average-scores-rail-runners
Sheet: Rail Runners' Stats

Week | Date | Name | Game 1 | Game 2 | Game 3 | Total | Avg | Games Won | Rounds Won
1 | 2009-09-17 00:00:00 | [NAME] |  |  |  | 26 | 8.666666666666666 |  | 3
 |  | [NAME] |  |  |  | 26 | 8.666666666666666
 |  | Leonard | 10 | 10 | 10 | 30 | 10 | 3
 |  | [NAME] |  |  |  | 27 | 9
 |  | [NAME] |  |  |  | 27 | 9
2 | 2009-09-24 00:00:00 | [NAME] | 10 | 10 | 10 | 30 | 9.333333333333334 |  | 3
 |  | [NAME] |  |  |  | 24 | 8.333333333333334
 |  | Leonard | 10 | 10 | 4 | 24 | 9 | 5
 |  | [NAME] | 10 | 10 | 4 | 24 | 8.5
 |  | [NAME] |  |  |  | 26 | 8.833333333333334
3 | 2009-10-01 00:00:00 | [NAME] | 10 | 10 | 10 | 30 | 9.555555555555555 |  | 1
 |  | [NAME] | 7 | 10 | 7 | 24 | 8.222222222222221
 |  | Leonard | 10 | 6 | 10 | 26 | 8.88888888888889 | 7
 |  | [NAME] | 5 | 10 | 10 | 25 | 8.444444444444445
 |  | [NAME] | 10 | 6 | 10 | 26 | 8.777777777777779
4 | 2009-10-08 00:00:00 | [NAME]
 |  | [NAME]
 |  | Leonard
 |  | [NAME]
 |  | [NAME]
5 | 2009-10-15 00:00:00 | [NAME]
 |  | [NAME]
 |  | Leonard
 |  | [NAME]
 |  | [NAME]
6 | 2009-10-22 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
7 | 2009-10-29 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
8 | 2009-11-05 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
9 | 2009-11-12 00:00:00 | [NAME]
 |  | [NAME]
 |  | Leonard
 |  | [NAME]
 |  | [NAME]
10 | 2009-11-19 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
11 | 2009-11-26 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
12 | 2009-12-03 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
13 | 2009-12-10 00:00:00 | [NAME]
 |  | [NAME]
 |  | Leonard
 |  | [NAME]
 |  | [NAME]
14 | 2009-12-17 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
15 | 2009-12-24 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
16 | 2009-12-31 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
17 | 2010-01-07 00:00:00 | [NAME]
 |  | [NAME]
 |  | Leonard
 |  | [NAME]
 |  | [NAME]
18 | 2010-01-14 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
19 | 2010-01-21 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
20 | 2010-01-28 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
21 | 2010-02-04 00:00:00 | [NAME]
 |  | [NAME]
 |  | Leonard
 |  | [NAME]
 |  | [NAME]
22 | 2010-02-11 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
23 | 2010-02-18 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
24 | 2010-02-25 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Spreadsheet: gerald_nemec__11481__EOLfieldnames
Sheet: EOL

 | EOL Field Names
 |  |  |  |  |  |  |  |  |  |  | Gas Daily Refernce Prices
 | Pipeline |  | Points / Zone |  | Rate Schedule |  | [NAME] |  | Delivery Point |  | Receipt Location |  | Delivery Location
 | Columbia Gas Transmission Corporation | CGAS | Point to Point |  | FTS |  | Leach |  | BGE
 |  |  | Point to Point |  | FTS |  | Leach |  | VNG
 |  |  | Zone to Zone |  | FTS |  | MRKT 19 |  | MRKT 28
 |  |  | Zone to Zone |  | FTS |  | MRKT 19 |  | MRKT 34
 | Note:  I added 2 Zone to Zone examples for CGAS, I don't think we will use them
 | Columbia Gulf Transmission Corporation | CGLF | Point to Point |  | FTS-1 |  | Rayne |  | Leach
 |  |  | Point to Point |  | FTS-1 |  | Leach |  | Rayne
 |  |  | Zone to Zone |  | [NAME] |  | Onshore |  | Onshore
 |  |  | Zone to Zone |  | FTS-1 |  | Mainline |  | Mainline
 | Dominion Transmission, Inc. | ? | Zone to Zone |  | ? |  | South |  | South
 |  |  | Zone to Zone |  | ? |  | South |  | North
 |  |  | Zone to Zone |  | ? |  | North |  | North
 |  |  | Zone to Zone |  | ? |  | North |  | South
 |  |  | Zone to Zone |  | ? |  | South |  | South PL-1
 |  |  | Zone to Zone |  | ? |  | North |  | South PL-1
 | Note:  this will be the first time we have recognized South PL-1 in any of our trading systems
 | Texas Eastern Transmission Corporation | TETC | Zone to Zone |  | CDS / FT-1 |  | Ela |  | M3
 |  |  | Zone to Zone |  | CDS / FT-1 |  | [NAME] |  | M3
 |  |  | Zone to Zone |  | CDS / FT-1 |  | Ela |  | M2
 |  |  | Zone to Zone |  | CDS / FT-1 |  | [NAME] |  | M2
 | Transcontinental Gas Pipe Line Corporation | TRCO | Zone to Zone |  | FT-R |  | Zone 3 |  | Zone 6 Non NY
 |  |  | Zone to Zone |  | FT-R |  | Zone 2 |  | Zone 6 Non NY
 |  |  | Zone to Zone |  | FT-R |  | Zone 1 |  | Zone 6 Non NY
 |  |  | Zone to Zone |  | FT-R |  | Zone 3 |  | Zone 6 NY
 |  |  | Zone to Zone |  | FT-R |  | Zone 2 |  | Zone 6 NY
 |  |  | Zone to Zone |  | FT-R |  | Zone 1 |  | Zone 6 NY
Spreadsheet: 45015d1243817774-if-valuea-appears-in-different-sheet-sum-valueb-with-conditions-mewingexampleforsolving
Sheet: Sheet2

ID | LAST | FIRST | Div | Schl | In Research Register? | Points for 06 SR | Supported Researcher 2006 | Points for 07 SR | Supported Researcher 2007 | Points for 08 SR | Supported Researcher 2008 | # Principle Supervision | sum of Load = 1.0 | sum of Load = 0.5
000011
000032
000065
000090
000110
000145
000253
000292
000335
000393
000425
000442
000459
000461
000570
000670
000790
000812
000813
000830
000882
000900
000910
000933
000978
001057
001090
001095
001120
001158
001286
001291
001292
001307
001327
001349
001360
001390
001394
001477
001511
001515
001584
001675
001724
001810
001850
001880
001890
001903
002050
002175
002234
002302
002312
002324
002359
002360
002373
002478
002591
002593
002620
002703
003050
003570
004250
005795
008290
008347
008729
008738
008968
009175
009226
009403
009594
010039
010075
010081
010082
010105
010152
010229
010266
010275
010278
010284
010285
010295
010298
010299
010301
010306
010307
010310
010313
010317
Spreadsheet: 129601d1321729250-adding-dates-at-different-endpoints-sample_attendance_2011
Sheet: Sheet4

[NAME] | 1 | 2 | 3 | 4 | 5
102 | 2011-03-28 00:00:00 | 2011-03-25 00:00:00 | 2011-03-21 00:00:00
103 | 2011-03-28 00:00:00 | 2011-03-25 00:00:00 | 2011-03-21 00:00:00
107 | 2011-03-28 00:00:00 | 2011-03-25 00:00:00 | 2011-03-21 00:00:00 |  | 2011-07-11 00:00:00
113 | 2011-03-28 00:00:00 | 2011-03-25 00:00:00 | 2011-03-21 00:00:00 | 2011-05-23 00:00:00 | 2011-07-11 00:00:00
121 | 2011-03-28 00:00:00 | 2011-03-25 00:00:00 | 2011-03-21 00:00:00 | 2011-05-23 00:00:00 | 2011-07-11 00:00:00
122 | 2011-03-28 00:00:00 | 2011-03-25 00:00:00 | 2011-03-21 00:00:00 | 2011-05-23 00:00:00 | 2011-07-11 00:00:00
123 | 2011-03-28 00:00:00 | 2011-03-25 00:00:00 |  | 2011-05-23 00:00:00
124 | 2011-03-28 00:00:00 | 2011-03-25 00:00:00 |  | 2011-05-23 00:00:00
126 | 2011-03-28 00:00:00 | 2011-03-25 00:00:00 |  | 2011-05-23 00:00:00
127 | 2011-03-28 00:00:00 | 2011-03-25 00:00:00 |  | 2011-05-23 00:00:00
Spreadsheet: 689950d1596772689-how-to-put-the-multiple-value-in-one-cell-from-multiple-cell-sample-show-multiple-value
Sheet: Data Source

Module | Category | Process | Action | Group
HR | Claims | Rejection | Cancel | Manager
HR | Claims | Rejection | Cancel | HR training
HR | Claims | Rejection | Cancel | Employee
HR | Claims | Rejection | Cancel | Administrator
HR | Claims | Rejection | [NAME] | HR training
HR | Claims | Rejection | [NAME] | Employee
HR | Claims | Rejection | View | Manager
HR | Claims | Rejection | View | HR training
HR | Claims | Rejection | View | Employee
HR | Claims | Rejection | View | Administrator
HR | Claims | Rejection | View | HR Manager
Spreadsheet: 780631d1652627829-nested-if-and-then-forumla-tracking-comparison
Sheet: P1a

 |  |  | Reading Group | Cluster | School | On Track? | Cluster | School | On Track? | Cluster | School | On Track? | Writing grp | Cluster | School | On Track? | Cluster | School | On Track? | Cluster | School | On Track? | Numeracy grp | Cluster | School | On Track? | Cluster | School | On Track? | Cluster | School | On Track? | T&L grp | Cluster | School | On Track? | Cluster | School | On Track? | Cluster | School | On Track?
First Name | Surname | Class |  | OCT |  |  | JAN |  |  | MAY |  |  |  | OCT |  |  | JAN |  |  | MAY |  |  |  | OCT |  |  | JAN |  |  | MAY |  |  |  | OCT |  |  | JAN |  |  | MAY
 |  |  | 2 |  | EW | Y
 |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1
 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TP 1 | TP 2 | TP 3
 |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCT | JAN | MAY
 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grp 1 | EA | 1M | 1M
 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | EW | EA | 1M
 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grp3 | EW | EW | EA
 |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Individual | EM | EM | EW
 |  |  | 2
 |  |  | 3
 |  |  | 1
 |  |  | 1
 |  |  | 2
 |  |  | 1
 |  |  | 2
 |  |  | 2
 |  |  | 3
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 1
Spreadsheet: 109696d1306483871-how-to-transpose-if-duplicates-transposelikeduplicates-betterexample2
Sheet: Sheet1

Example 2
 |  |  |  |  |  |  |  | it is best to sort list by column B to group all the same surnames together
names1 | names 2 | (Desired Output) |  |  |  |  |  | then extract an unique list  of surnames using advanced filter
[NAME] | Jones | [NAME], [NAME], [NAME] |  |  |  |  |  | unique list
[NAME] | Jones |  |  |  |  |  |  | Jones | [NAME],[NAME] | [NAME],[NAME] | [NAME],[NAME]
[NAME] | Jones |  |  |  |  |  |  | [NAME] | [NAME],[NAME] | Todd,[NAME] | [NAME],[NAME]
[NAME] | [NAME] | [NAME], [NAME], [NAME] |  |  |  |  |  | Eagle | [NAME],Eagle | [NAME],Eagle | [NAME],Eagle | [NAME],Eagle | [NAME],Eagle
Todd | [NAME] |  |  |  |  |  |  | Ant | [NAME],[NAME] | [NAME]
[NAME] | [NAME] |  |  |  |  |  |  | Old | [NAME],Old | [NAME],Old | [NAME],Old | [NAME],Old
[NAME] | Eagle | [NAME], [NAME], [NAME], [NAME], [NAME]
[NAME] | Eagle
[NAME] | Eagle
[NAME] | Eagle
[NAME] | Eagle
[NAME] | Ant | [NAME], [NAME]
George | Ant
[NAME] | Old | [NAME], [NAME], [NAME], [NAME]
[NAME] | Old
[NAME] | Old
[NAME] | Old
etc.
Spreadsheet: 165fbd04-378a-44f4-a48d-7822080839d0
Sheet: EPR CF

Consolidated Statements of Cash Flows (Unaudited and Condensed)
Three Months Ended December 31, | 2013 |  | 2012
(In millions)
Operating
Net income | 79.20000000000006 |  | 65.30000000000008
Adjustments:
Depreciation and amortization | 51.3 |  | 57.7
Acquisition-related contingent earn-out costs | 4.5 |  | 2.1
Other non-cash items | 28.6 |  | 30.5
Changes in operating assets and liabilities, excluding acquisitions:
Receivables | -13.2 |  | 14.4
Inventories | 15.6 |  | 2.6
Accounts payable and accrued liabilities | -51 |  | -83.5
Jackpot liabilities | -16.6 |  | -24.2
Income taxes, net of employee stock plans | -17.8 |  | 28.8
Other assets and deferred costs | -4.5 |  | 0.7999999999999998
Net operating cash flows | 76.10000000000005 |  | 94.50000000000006
Investing
Capital expenditures | -24.6 |  | -37.6
Investment securities, net | -70.6 |  | 0
Jackpot annuity investments, net | 9 |  | 9.899999999999999
Changes in restricted cash | -0.8 |  | 5.7
Loans receivable, net | 6.4 |  | 7.6
Other | 3.3 |  | 4.6
Net investing cash flows | -77.29999999999998 |  | -9.800000000000004
Financing
Debt-related proceeds (payments), net | -0.5 |  | -75
Employee stock plan proceeds | 8.3 |  | 1.8
Share repurchases, including net shares | -211 |  | 0
Dividends paid | -25.9 |  | -16.1
Net financing cash flows | -229.1 |  | -89.29999999999997
Foreign exchange rates effect on cash | -2.4 |  | -1
Net change in cash and equivalents | -232.7 |  | -5.599999999999923
Beginning cash and equivalents | 713.3 |  | 206.3
Ending cash and equivalents | 480.6 |  | 200.7000000000001