tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 09e6a2e2-2356-4f26-b5a7-d165817acf12
Sheet: ACF Fall

Team | [NAME] | Set | PPG | PPB | 15PG
Bellaire | ACF Fall Texas | ACF Fall | 299.5 | 18.06 | n/a
Cinco Ranch | ACF Fall Texas | ACF Fall | 62.5 | 8.06 | n/a
Dorman | ACF Fall UVA | ACF Fall | 330.3 | 23.57 | n/a
Georgetown Day School | ACF Fall UVA | ACF Fall | 282.3 | 19.68 | n/a
Hanover | ACF Fall Yale | ACF Fall |  |  | n/a
IMSA | ACF Fall NIU | ACF Fall | 399.6 | 23.31 | n/a
Kealing A | ACF Fall Texas | ACF Fall | 271 | 17.7 | n/a
Loyola A | ACF Fall NIU | ACF Fall | 368.3 | 23.58 | n/a
Loyola B | ACF Fall NIU | ACF Fall | 185 | 14.43 | n/a
[NAME] | ACF Fall NIU | ACF Fall | 285 | 18.92 | n/a
North Hollywood A | ACF Fall West | ACF Fall | 233 | 16.85 | n/a
North Hollywood B | ACF Fall West | ACF Fall | 73 | 10.49 | n/a
[NAME] | ACF Fall West | ACF Fall | 224.5 | 16.78 | n/a
Seven Lakes A | ACF Fall Texas | ACF Fall | 425.8 | 24.08 | n/a
Seven Lakes B | ACF Fall Texas | ACF Fall | 37.2 | 5.21 | n/a
St. Anselm's | ACF Fall UVA | ACF Fall | 348.3 | 23 | n/a
St. John's A | ACF Fall Texas | ACF Fall | 169.4 | 13.51 | n/a
St. John's B | ACF Fall Texas | ACF Fall | 220.5 | 14.18 | n/a
St. John's C | ACF Fall Texas | ACF Fall | 120.6 | 11.35 | n/a
[NAME] A | ACF Fall UVA | ACF Fall | 382.9 | 22.95 | n/a
Treasure Valley Math & Science | ACF Fall Boise State | ACF Fall | 144 | 13.23 | n/a
Spreadsheet: 356827d1415217434-totaling-throughout-ranges-total-loans-issued
Sheet: Sheet1

loan amount | issue date |  | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00
948.98 | 2013-10-08 00:00:00 |  |  |  |  | Sums number granted for each month
1063.14 | 2013-10-17 00:00:00 |  |  |  |  | Total for each month ???
484.25 | 2013-11-27 00:00:00
1000 | 2013-11-28 00:00:00 |  |  |  |  | I want to total amount of loans issued for each month from a range. This is a shortened range as it could cover a full year
200 | 2013-12-13 00:00:00
2000 | 2013-12-20 00:00:00
800 | 2014-01-10 00:00:00
1038.29 | 2014-01-10 00:00:00
Spreadsheet: e8073935-4286-49b4-8ce3-cd3a46e254c8
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
08/31/2013 | Women's Cross Country | Lehigh Invitational | 4th place
[NAME] | Women's Cross Country | PSU Spiked Shoe Invitational | 8th place
10/05/2013 | Women's Cross Country | [NAME] | 8th Place
10/18/2013 | Women's Cross Country | PSU National | 1st Place
11/02/2013 | Women's Cross Country | Big 12 Championships* | 2nd Place
11/15/2013 | Women's Cross Country | NCAA Mid-Atlantic Regional | 4th Place
11/23/2013 | Women's Cross Country | NCAA Cross Country Championship | 24th Place
Spreadsheet: 153006d1335688950-excel-2007-count-how-many-a-value-occurs-with-given-set-of-criteria-book1_heartbreak_one
Sheet: Sheet3

 |  |  |  | USING FOMULA
 | datalist |  |  | expected result
 |  |  |  |  |  |  |  |  |  |  | USING PIVOTABLE
 | ITEM | qty |  | item name | # of quantity |  |  |  |  |  | Count of qty | Column Labels
 | [NAME] | 10 |  |  | 5 | 10 | 15 | 20 |  |  | Row Labels | 5 | 10 | 15 | 20
 | hammer | 15 |  | [NAME] |  |  |  |  |  |  | [NAME] |  | 2 | 3
 | hammer | 5 |  | hammer |  |  |  |  |  |  | disc brake | 2 |  | 2 | 1
 | flow | 20 |  | flow |  |  |  |  |  |  | flow | 2 | 1 |  | 4
 | disc brake | 15 |  | disc brake |  |  |  |  |  |  | hammer | 2 |  | 2
 | flow | 5
 | flow | 20
 | [NAME] | 10
 | hammer | 15
 | hammer | 5 |  | so i need it to look item name in column E, then look it in column B, then return how many times the quantity in column C occurs
 | flow | 20 |  | for example, item name air chuck in datalist has 3 of quantity 15
 | disc brake | 15 |  | so in cell H7 i need to write a formula to look an airchuck in datalist, and count how many times it has 15 value
 | flow | 5
 | flow | 20
 | disc brake | 5
 | disc brake | 20
 | disc brake | 5
 | flow | 10 | ----> should delelte 1 space in yr ogrinal data "flow ", now it is already deleted
 | [NAME] | 15
 | [NAME] | 15
 | [NAME] | 15
Spreadsheet: 044a79c3-e3a5-4e1d-af19-874d1b0efc99
Sheet: Sheet1

1989 - 33rd Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | Lech am [NAME], Schmelzhofwiesen, Austria |  |  |  |  | 1989-09-16 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | AUT | Starkbaum | [NAME] | Scholz | Gerd | OE-PZS Polarstern | Batorliget/Debrecen/Hungaria | 911.2 | 1900-01-01 13:33:00
2 | GER | Fink | [NAME] | Märkl | Erich | D-Augsburg | Nyiracsad/Hungaria | 894.1 | 1900-01-01 15:32:00
3 | USA | Kittinger | [NAME] | Snow | [NAME] | D-Columbus | Hejocpapi/Hungaria | 809.4 | 1900-01-01 10:01:00
4 | SUI | Signer | Gerold | Osterwalder | Silvan | HB-BJB Solvay | Tisovec Chechslovakia | 748.4 | 1900-01-01 01:52:00
5 | SUI | Spenger | [NAME] | Messner | Martin | HB-BFC Jura | Namestovo Chechoslovakia | 731.9 | 1900-01-01 18:47:00
6 | SUI | Nater | Alfred | [NAME] | Otto | HB-BGN Zurzach | Ferriego/Hungaria | 691.2 | 22:07:00
7 | GER | Sjuts | Helma | Derks | Alfred | D-Continentale | [NAME] | 669 | 1900-01-01 07:59:00
8 | USA | Woods | [NAME] | Boring | [NAME] | D-Aspen | Piesti-any Chechslovakia | 576.1 | 22:01:00
9 | POL | Ozga | [NAME] | Szary | Piotr | SP-BZR Polonia | Loimersdorf/Austria | 510.6 | 20:53:00
10 | USA | Hyde | [NAME] | Reinhard | [NAME] | HB-BJS Motor Columbus | Sopron/Hungaria | 496.7 | 20:27:00
11 | POL | Makne | [NAME] | [NAME] | Grzegorz | SP-BZO Polonez | Himberg/Austria | 486.4 | 22:56:00
12 | GER | Kuinke | Volker | Vormbäumen | Gustav | D-Euregio | Igelbach/Germany | 272.2 | [NAME]
Spreadsheet: c22a8d10-9198-43f8-9b26-46e7d2380ab1
Sheet: R-95 Revenue Collector Cars

New # | Old # | New Contract | Old Contract | Purpose | Notes
0R714 | 7194 | R-95 | R-21 | Revenue Car | Train #2-East 180th; Was in NYTM | Numbers from NYD 3/89
0R715 | 7343 | R-95 | R-22 | Revenue Car | Train #3-Corona | Numbers from NYD 3/89
0R716 | 7355 | R-95 | R-22 | Revenue Car | Train #1-Livonia | Numbers from NYD 3/89
0R717 | 7313 | R-95 | R-22 | Revenue Car | Train #3A-Livonia | Numbers from NYD 3/89
0R718 | 7379 | R-95 | R-22 | Revenue Car | IRT Spare | Numbers from NYD 3/89
0R719 | 7389 | R-95 | R-22 | Revenue Car | Train #7-Jamaica | Numbers from NYD 3/89
0R720 | 7337 | R-95 | R-22 | Revenue Car | Train #8-Concourse | Numbers from NYD 3/89
0R721 | 7392 | R-95 | R-22 | Revenue Car | Train #5-36th St | Numbers from NYD 3/89
0R722 | 7368 | R-95 | R-22 | Revenue Car | Train #6-36th St | Numbers from NYD 3/89
0R723 | 7490 | R-95 | R-22 | Revenue Car | BMT-IND Spare | Numbers from NYD 3/89
1R714 | 7422 | R-95 | R-22 | Locker Car | Train #2-East 180th; Was in NYTM | Numbers from NYD 3/89
1R715 | 7424 | R-95 | R-22 | Locker Car | Train #3-Corona | Numbers from NYD 3/89
1R716 | 7410 | R-95 | R-22 | Locker Car | Train #1-Livonia | Numbers from NYD 3/89
1R717 | 7314 | R-95 | R-22 | Locker Car | Train #3A-Livonia | Numbers from NYD 3/89
1R718 | 7374 | R-95 | R-22 | Locker Car | IRT Spare | Numbers from NYD 3/89
1R719 | 7386 | R-95 | R-22 | Locker Car | Train #7-Jamaica | Numbers from NYD 3/89
1R720 | 7444 | R-95 | R-22 | Locker Car | Train #8-Concourse | Numbers from NYD 3/89
1R721 | 7449 | R-95 | R-22 | Locker Car | Train #5-36th St | Numbers from NYD 3/89
1R722 | 7459 | R-95 | R-22 | Locker Car | Train #6-36th St | Numbers from NYD 3/89
1R723 | 7496 | R-95 | R-22 | Locker Car | BMT-IND Spare | Numbers from NYD 3/89
Spreadsheet: 857204d1706229381-forumula-to-populate-a-column-with-data-from-other-columns-populating-a-column-from-other-columns
Sheet: Sheet1

Dept | PO Dept | Invoice Dept | [NAME]
Hoggs |  | Hoggs | Hoggs
Soggs |  | Hoggs | Hoggs
Cloggs | Hoggs |  | Hoggs
Cloggs | Cloggs |  | Cloggs
Cloggs | Soggs |  | Soggs
Cloggs | Soggs |  | Soggs
Hoggs |  |  | Hoggs
Hoggs |  |  | Hoggs
Soggs |  |  | Soggs
Looking for a formua that says if there's a value in either column B or C, put it into column D.  And if there's no value in column B or C, put the value in column A into Column D instead
Spreadsheet: 809985d1671476179-discount-rates-formula-and-npv-investment-model_help_v2
Sheet: IRR of diff

 |  |  |  |  |  | 2022-12-01 00:00:00
 | Rental Revenue Discount Rate |  |  | 0.0686
 | Residual Value Discount Rate |  |  | 0.08
 | Cash Flow
 | Rental Revenue |  |  |  |  | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86
 | Residual |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17952165
 | Unlevered Cash Flow, PV
 | Residual, PV
 | Unlevered Present Value
 | Unlevered Cash Flow
 | Interest Expense |  |  |  |  | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667
 | [NAME]
 | Residual |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Debt Payoff |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -15307908.73
 | Net Residual |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Proof of Concept (IRR of debt CF)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Diff | NPV | Same?
 | [NAME], PV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Interest Expense
 | Net Residual, PV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Debt Payoff
 | Levered Present Value
 |  |  |  | NPV Difference |  |  |  |  |  | exact NPV |  |  |  |  |  |  |  |  |  |  | NPV of debt CF
 |  |  |  |  | IRR CF
 |  |  |  |  | IRR |  |  |  |  | exact IRR |  |  |  |  |  |  |  |  |  |  | IRR of debt CF
 |  |  |  | Proof of Concept (IRR of difference between unlevered and levered CFs)
 |  |  |  | Unlevered CF PV
 |  |  |  | Residual CF PV
 |  |  |  | Unlevered NPV
 |  |  |  | [NAME]
 |  |  |  | Net Residual PV
 |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Difference
 |  |  |  | NPV Difference |  |  |  |  |  | exact NPV
 |  |  |  | Difference CF NPV |  |  |  |  |  | exact NPV
 | GOAL SEEK:
 | Unlevered CF |  |  | 0.07914250775360218
 | Unlevered PV
 | Difference |  |  |  |  |  | Goal seek, set = 0, by changing discount rate in column E
 | [NAME] |  |  | 0.0764259132684417
 | [NAME]
 | Difference |  |  |  |  |  | Goal seek, set = 0, by changing discount rate in column E
Spreadsheet: 678082d1589705954-sorting-and-connecting-2020-05-0-oeldere-asojat-676887d1589041000-sorting-and-connecting-example1-1-
Sheet: List1

Have: |  |  |  |  |  |  |  | Want to sort with formula:
 |  |  |  |  | Vlookup
Level | Code | level |  |  | 0 | 1 |  | Level 1 | Level 2 | Level 3 | Level 4
1 | 133XY |  |  |  | 2 | 2 |  | 133XY
1.10 | 2314XY |  |  |  | 5 | 3 |  |  | 2314XY
1.10.1 | 231Ze |  |  |  |  |  |  |  |  | 231Ze
1.10.2 | 31WE |  |  |  |  |  |  |  |  | 31WE
1.10.3 | wd2 |  |  |  |  |  |  |  |  | wd2
1.10.4 | cd21 |  |  |  |  |  |  |  |  | cd21
1.10.5 | d523 |  |  |  |  |  |  |  |  | d523
1.10.5.1 | d3x3 |  |  |  |  |  |  |  |  |  | d3x3
1.10.5.2 | 231d |  |  |  |  |  |  |  |  |  | 231d
1.10.6 | 5122d |  |  |  |  |  |  |  |  | 5122d
Spreadsheet: 876740d1723476604-functions-solving-data
Sheet: Sheet2

Grade 1 | [NAME]
3 | 3
3 | 1
3 | 4
4 | 3
2 | 1
4 | 4
3 | 3
3 | 1
3 | 4
1 | 3
1 | 1
3 | 4
3 | 3
1 | 1
3 | 4
4 | 3
1 | 1
1 | 4
Spreadsheet: 89786d1289512976-deleting-both-duplicates-book3
Sheet: Sheet1

 | Option 1 | Option 2
A | 1 | 0
B | 1 | 0
C | 0 | 0
D | 1 | 0
A | 1 | 1
A | 1 | 1
B | 1 | 1
l | 0 | 0
D | 1 | 1
E | 0 | 0
A | 1 | 1
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: ICS

Old course number | New course number
ICS-320 | ICS-3200
ICS-330 | ICS-3300
ICS-440 | ICS-3400
ICS-441 | ICS-3401
ICS-442 | ICS-4400
ICS-455 | ICS-3550
ICS-456 | ICS-3551
ICS-457 | ICS-4550
ICS-505 | ICS-5500 and ICS-4605
ICS-510 | ICS-4610
ICS-510 | ICS-6610
ICS-532 | ICS-4620
ICS-540 | [NAME] and ICS-4630
ICS-548 | ICS-4640
ICS-550 | ICS-4600
ICS-575 | ICS-4650
Spreadsheet: 593793d1539331402-im-having-a-problem-formatting-a-column-so-that-it-shows-a-percentage-the-way-i-need-example-2
Sheet: Sheet1

1975 | 8
1976 | 6.4
1977 | 5.9
1978 | 6.5
1979 | 9.9
1980 | 14.3
1981 | 11.2
1982 | 7.4
1983 | 3.5
1984 | 3.5
1985 | 3.1
1986 | 1.3
1987 | 4.2
1988 | 4
1989 | 4.7
1990 | 5.4
1991 | 3.7
1992 | 3
1993 | 2.6
1994 | 2.8
1995 | 2.6
1996 | 2.9
1997 | 2.1
1998 | 1.3
1999 | 2.5
2000 | 3.5
2001 | 2.6
2002 | 1.4
2003 | 2.1
2004 | 2.7
2005 | 4.1
2006 | 3.3
2007 | 2.3
2008 | 5.8
2009 | 0
2010 | 0
2011 | 3.6
2012 | 1.7
2013 | 1.5
2014 | 1.7
2015 | 0
2016 | 0.3
2017 | 2
2018 | 2.8
Spreadsheet: 101477d1299598155-excel-2007-excel-conditional-summing-book2
Sheet: Sheet1

 | Month | Goal | Actual | Projected | OI goal | Act + Proj | Monthly Surplus or (Shortfall) | [NAME]
 | 2011-01-08 00:00:00 | 537500 | 793937.0000000002 | 793937.0000000002 | 6450000 |  | 256437.0000000002 | 7745000
 | 2011-02-08 00:00:00 | 537500 | 62466 | 756402 | 6450000 |  | -475034 | 7745000
 | 2011-03-08 00:00:00 | 537500 | 13733 | 711383 | 6450000 |  | -523767 | 7745000
 | 2011-04-08 00:00:00 | 537500 | 0 | 621900 | 6450000 |  | -537500 | 7745000
 | 2011-05-08 00:00:00 | 537500 | 0 | 434996 | 6450000 |  | -537500 | 7745000
 | 2011-06-08 00:00:00 | 537500 | 0 | 408159 | 6450000 |  | -537500 | 7745000
 | 2011-07-08 00:00:00 | 537500 | 0 | 374255 | 6450000 |  | -537500 | 7745000
 | 2011-08-08 00:00:00 | 537500 | 0 | 379671 | 6450000 |  | -537500 | 7745000
 | 2011-09-08 00:00:00 | 537500 | 0 | 404922 | 6450000 |  | -537500 | 7745000
 | 2011-10-08 00:00:00 | 537500 | 0 | 399922 | 6450000 |  | -537500 | 7745000
 | 2011-11-08 00:00:00 | 537500 | 0 | 397922 | 6450000 |  | -537500 | 7745000
 | 2011-12-08 00:00:00 | 537500 | 0 | 395941 | 6450000 |  | -537500 | 7745000
Spreadsheet: 713930d1611010795-number-shuffle-number-shuffle-1_mrshorty
Sheet: Sheet1

20 |  |  | 33 | 32 | 31 | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21
19
18
17
16
15
14
13
12
11
10
9
8
7
6
5
4
3
2
1
20 |  |  | 33 | 32 | 31 | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21
19
18
17
16
15
14
13
12
11
10
9
8
7
6
5
4
3
2
1
20 |  |  | 33 | 32 | 31 | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21
19
18
17
16
15
14
13
12
11
10
9
8
7
6
5
4
3
2
1
Spreadsheet: kate_symes__18273__EES March Dailies
Sheet: 3-4

NP15 | 2001-03-04 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  | ZP26
Fixed Peak | 211.5 | Fixed Off Peak | 211.5 |  |  |  | Fixed Peak | 209.29 |  | Fixed Off Peak | 209.29 |  |  | Fixed Peak |  |  | Fixed Off Peak
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  | Index Peak |  |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | -4.86 | 0 | 0 | -4.86 |  |  | 1 | -21.17 | 0 |  | -4.169999999999995 |  |  | 1 | -1.98 | 0 | 0 | -1.98
2 | -3.91 | 0 | 0 | -3.91 |  |  | 2 | -33.78 | 0 |  | 0.219999999999992 |  |  | 2 | -1.93 | 0 | 0 | -1.93
3 | -3.38 | 0 | 0 | -3.38 | 0 |  | 3 | -43.09 | 0 |  | 1.90999999999999 |  |  | 3 | -1.92 | 0 | 0 | -1.92
4 | -3.19 | 0 | 0 | -3.19 |  |  | 4 | -45.27 | 0 |  | 2.730000000000011 |  |  | 4 | -1.9 | 0 | 0 | -1.9
5 | -3.22 | 0 | 0 | -3.22 |  |  | 5 | -44.28 | 0 |  | 1.719999999999992 |  |  | 5 | -1.9 | 0 | 0 | -1.9
6 | -3.7 | 0 | 0 | -3.7 |  |  | 6 | -38.5 | 0 |  | -2.500000000000007 |  |  | 6 | -1.93 | 0 | 0 | -1.93
7 | -5.05 | 0 | 0 | -5.05 |  |  | 7 | -55.08 | 0 |  | -7.079999999999991 |  |  | 7 | -1.98 | 0 | 0 | -1.98
8 | -7.15 | 0 | 0 | -7.15 |  |  | 8 | -50.48 | 0 |  | -11.48 |  |  | 8 | -2.08 | 0 | 0 | -2.08
9 | -9.13 | 0 | 0 | -9.13 |  |  | 9 | -34.79 | 0 |  | -16.79 |  |  | 9 | -2.16 | 0 | 0 | -2.16
10 | -9.98 | 0 | 0 | -9.98 |  |  | 10 | -27.66 | 0 |  | -22.66 |  |  | 10 | -2.2 | 0 | 0 | -2.2
11 | -10.31 | 0 | 0 | -10.31 |  |  | 11 | -15.95 | 0 |  | -27.95 |  |  | 11 | -2.21 | 0 | 0 | -2.21
12 | -10.17 | 0 | 0 | -10.17 |  |  | 12 | -16.25 | 0 |  | -30.25 |  |  | 12 | -2.2 | 0 | 0 | -2.2
13 | -10.15 | 0 | 0 | -10.15 |  |  | 13 | -15.81 | 0 |  | -31.81 |  |  | 13 | -2.2 | 0 | 0 | -2.2
14 | -9.8 | 0 | 0 | -9.8 |  |  | 14 | -16.5 | 0 |  | -32.5 |  |  | 14 | -2.19 | 0 | 0 | -2.19
15 | -9.19 | 0 | 0 | -9.19 |  |  | 15 | -17.41 | 0 |  | -32.41 |  |  | 15 | -2.16 | 0 | 0 | -2.16
16 | -9.22 | 0 | 0 | -9.22 |  |  | 16 | -17.23 | 0 |  | -32.23 |  |  | 16 | -2.16 | 0 | 0 | -2.16
17 | -9.71 | 0 | 0 | -9.71 |  |  | 17 | -16.42 | 0 |  | -31.42 |  |  | 17 | -2.18 | 0 | 0 | -2.18
18 | -11.38 | 0 | 0 | -11.38 |  |  | 18 | -14.48 | 0 |  | -35.48 |  |  | 18 | -2.25 | 0 | 0 | -2.25
19 | -13.82 | 0 | 0 | -13.82 |  |  | 19 | -12.44 | 0 |  | -36.44 |  |  | 19 | -2.36 | 0 | 0 | -2.36
20 | -13.34 | 0 | 0 | -13.34 |  |  | 20 | -12.41 | 0 |  | -33.41 |  |  | 20 | -2.33 | 0 | 0 | -2.33
21 | -12.26 | 0 | 0 | -12.26 |  |  | 21 | -14.12 | 0 |  | -29.12 |  |  | 21 | -2.29 | 0 | 0 | -2.29
22 | -10.61 | 0 | 0 | -10.61 |  |  | 22 | -15.89 | 0 |  | -23.89 |  |  | 22 | -2.22 | 0 | 0 | -2.22
23 | -8.45 | 0 | 0 | -8.45 |  |  | 23 | -18.13 | 0 |  | -17.13 |  |  | 23 | -2.13 | 0 | 0 | -2.13
24 | -6.14 | 0 | 0 | -6.14 |  |  | 24 | -20.49 | 0 |  | -9.489999999999988 |  |  | 24 | -2.02 | 0 | 0 | -2.02
Spreadsheet: 713877d1610990768-search-for-text-string-in-range-book1
Sheet: calcs

ID | Country | Service Line | Cross-Fuctional SL | Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6
Spreadsheet: 150570d1334603695-how-to-easily-adjust-multiple-sum-ranges-without-using-date-fields-sum-sample
Sheet: Sheet1

 |  |  | Pre-season Projection | Current Projection | Actual Picked | Projected Pick | Balance to Harvest | 15-Day Total | 2012-04-20 00:00:00 | 2012-04-21 00:00:00 | 2012-04-22 00:00:00 | 2012-04-23 00:00:00 | 2012-04-24 00:00:00 | 2012-04-25 00:00:00 | 2012-04-26 00:00:00 | 2012-04-27 00:00:00 | 2012-04-28 00:00:00 | 2012-04-29 00:00:00 | 2012-04-30 00:00:00 | 2012-05-01 00:00:00 | 2012-05-02 00:00:00 | 2012-05-03 00:00:00 | 2012-05-04 00:00:00 | 2012-05-05 00:00:00 | 2012-05-06 00:00:00 | 2012-05-07 00:00:00 | 2012-05-08 00:00:00 | 2012-05-09 00:00:00 | 2012-05-10 00:00:00 | 2012-05-11 00:00:00
Block ID | Lot # | Variety |  |  |  |  |  |  | 2012-04-20 00:00:00 | 2012-04-21 00:00:00 | 2012-04-22 00:00:00 | 2012-04-23 00:00:00 | 2012-04-24 00:00:00 | 2012-04-25 00:00:00 | 2012-04-26 00:00:00 | 2012-04-27 00:00:00 | 2012-04-28 00:00:00 | 2012-04-29 00:00:00 | 2012-04-30 00:00:00 | 2012-05-01 00:00:00 | 2012-05-02 00:00:00 | 2012-05-03 00:00:00 | 2012-05-04 00:00:00 | 2012-05-05 00:00:00 | 2012-05-06 00:00:00 | 2012-05-07 00:00:00 | 2012-05-08 00:00:00 | 2012-05-09 00:00:00 | 2012-05-10 00:00:00 | 2012-05-11 00:00:00
WIDGETS
1A | 1 | WIDGET A | 500 |  | 0 | 0 | 0 | 0
1B | 1 | [NAME] | 500 |  | 0 | 0 | 0 | 0
1C | 1 | [NAME] | 500 |  | 0 | 0 | 0 | 0
1D | 1 | [NAME] | 500 |  | 0 | 0 | 0 | 0
1E | 1 | [NAME] | 500 |  | 0 | 0 | 0 | 0
1F | 1 | [NAME] | 500 |  | 0 | 0 | 0 | 0
WIDGETS |  |  | 3000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME]
2A | 1 | SPROCKET A | 1000 |  | 0 | 0 | 0 | 0
2B | 1 | SPROCKET B | 1000 |  | 0 | 0 | 0 | 0
2C | 1 | SPROCKET C | 1000 |  | 0 | 0 | 0 | 0
2D | 1 | SPROCKET D | 1000 |  | 0 | 0 | 0 | 0
2E | 1 | SPROCKET E | 1000 |  | 0 | 0 | 0 | 0
2F | 1 | SPROCKET F | 1000 |  | 0 | 0 | 0 | 0
[NAME] |  |  | 6000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 134080d1324994579-drop-down-list-sample
Sheet: Sprd Sht

TRANSACTION RECORD
DATE | VENDOR | [NAME] | TML PO # | Vendor Invoice # | GOODS REC'D BY MONTH END? | INVOICE REC'D BY MONTH END? | Total Invoice | AMOUNT
 |  |  |  |  | Yes or No | Yes or No |  | Supply 1234-54 | TV 1234-55
 |  |  |  |  |  |  |  |  | 50
 | So I would like the amount ($50) to populate the field in tab 3 if my answer in column G is No
Spreadsheet: daren_farmer__5352__hpl0707
Sheet: Sheet1

HPLN0707.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective July 7, 2000
 |  |  |  |  |  | ** Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-07-07 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream | NOM
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 60  0900hrs | 0 to 60  0900hrs
 |  |  |  |  | 60  to 0 2100hrs | 60  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | ENA | 0 | 8
Enron (S) |  | Texoma |  | ENA | 0 | 10
Enron (S) |  | Oasis Sealy |  | ENA | 20 | 40
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | TOG 3 |  | Empire | 1.4 | 1.4
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 3.6 | 3.6
Empire (Enron) |  | Sterling Plant |  | Empire | 5 | 5
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 107849d1305008725-pivot-table-show-details-sum-of-not-working-2011-04-vessel-recap-2
Sheet: Recap - OTS

OU | OTS
FIRST_ROPE_ASHORE_DATE | Data | Total
Apr | Sum of 30000 tons and below | 109
 | Sum of above 30000 tons | 67
OU | OOTS
FIRST_ROPE_ASHORE_DATE | Data | Total
Apr | Sum of 30000 tons and below | 77
 | Sum of above 30000 tons | 10
Spreadsheet: 88059d1287975202-excel-2010-conditional-formatting-across-mulitpe-colums-patch
Sheet: Sheet2

DEVICE | PORTS
EDGE1 | 1
R2C2-PPA | 1/01
R2C2-PPB | 1/02
R2C2-PPC | 1/03
EDGE2 | 1/04
BCC-RR1 | 1/05
 | 1/06
 | 1/07
 | 1/08
 | 1/09
 | 1/10
 | 1/11
 | 1/12
 | 1/13
 | 1/14
 | 1/15
 | 1/16
 | 1/17
 | 1/18
 | 1/19
 | 1/20
 | 1/21
 | 1/22
 | 1/23
 | 1/24
 | 1/25
 | 1/26
 | 1/27
 | 1/28
 | 1/29
 | 1/30
 | 1/31
 | 1/32
 | 1/33
 | 1/34
 | 1/35
 | 1/36
 | 1/37
 | 1/38
 | 1/39
 | 1/40
 | 1/41
 | 1/42
 | 1/43
 | 1/44
 | 1/45
 | 1/46
 | 1/47
 | 1/48
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 2
 | 2/01
 | 2/02
 | 2/03
 | 2/04
 | 2/05
 | 2/06
 | 2/07
 | 2/08
 | 2/09
 | 2/10
 | 2/11
 | 2/12
 | 2/13
 | 2/14
 | 2/15
 | 2/16
 | 2/17
 | 2/18
 | 2/19
 | 2/20
 | 2/21
 | 2/22
 | 2/23
 | 2/24
 | 2/25
 | 2/26
 | 2/27
 | 2/28
 | 2/29
 | 2/30
 | 2/31
 | 2/32
 | 2/33
 | 2/34
 | 2/35
 | 2/36
 | 2/37
 | 2/38
 | 2/39
 | 2/40
 | 2/41
 | 2/42
 | 2/43
 | 2/44
 | 2/45
 | 2/46
 | 2/47
 | 2/48
 | 20
 | 21
 | 22
 | 23
 | 24
 | 3
 | 3/01
 | 3/02
 | 3/03
 | 3/04
 | 3/05
 | 3/06
 | 3/07
 | 3/08
 | 3/09
 | 3/10
 | 3/11
 | 3/12
 | 3/13
 | 3/14
 | 3/15
 | 3/16
 | 3/17
 | 3/18
 | 3/19
 | 3/20
 | 3/21
 | 3/22
 | 3/23
 | 3/24
 | 3/25
 | 3/26
 | 3/27
 | 3/28
 | 3/29
 | 3/30
 | 3/31
 | 3/32
 | 3/33
 | 3/34
 | 3/35
 | 3/36
 | 3/37
 | 3/38
 | 3/39
 | 3/40
 | 3/41
 | 3/42
 | 3/43
 | 3/44
 | 3/45
 | 3/46
 | 3/47
 | 3/48
 | 4
 | 5
 | 6
 | 6/1
 | 6/2
 | 7
 | 8
 | 9
Spreadsheet: 774966d1648741271-search-headers-to-retrieve-totals-example
Sheet: Report

PE ID 0125 | PE ID 0128 | PE ID 0124 | PE ID 0001 | TOTAL | PE ID 0010 | PE ID 0030 | PE ID 5420 | PE ID 0135
Example 1 | Example 2 | Example 3 | Example 4 | Example 4.4 | Example 5 | Example 6 | Example 7 | Example 8
10000 | 0 | 0 | 29723.87 | 200000 | 500 | 3406.940000000001 | 11846.89 | 0
HMRC Rec
Example 1 | 10000
Example 2 | 0
Example 3 | 0
Example 4 | 29723.87
Example 5 | 200000
Example 6 | 500
Example 7 | 3406.940000000001
Example 8 | 11846.89
Example 9 | 0
 | 224970.04
Spreadsheet: 93ddf882-9ee2-4447-a580-4f7e28d2b55f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4380 | 13699 | [NAME] | Averesch | GER | 134 | 00:28:12 | 00:00:00 | [NAME] | 00:00:00 | 00:42:19 | 1 | 02:24:07
4380 | 7981 | [NAME] | [NAME] | USA | 135 | 00:27:31 | 00:00:00 | 01:18:43 | 00:00:00 | 00:39:40 | 2 | 02:25:55
4380 | 7965 | Cedric | Delescluse | FRA | 122 | 00:18:31 | 00:00:00 | 01:27:42 | 00:00:00 | 00:43:21 | 3 | [NAME]
4380 | 23799 | Luciano | [NAME] | BRA | 146 | 00:26:28 | 00:00:00 | 01:25:53 | 00:00:00 | [NAME] | 4 | 02:50:15
4380 | 25137 | [NAME] | Smith | CAN | 138 | 00:23:23 | 00:00:00 | 01:22:12 | 00:00:00 | 01:09:18 | 5 | 02:54:55
4380 | 19285 | [NAME] | [NAME] | CAN | 145 | 00:22:29 | 00:00:00 | 01:55:06 | 00:00:00 | 00:47:15 | 6 | [NAME]