tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 75932d1276537040-calculate-average-withouot-incorporating-sub-average-dummy_calculate_avg
Sheet: Sheet1

WEEK | SALES |  |  | FILL RATE
ENDING |  |  |  | CASES
 | CASES | $ | AVG $ / CS | OUT | %
GOAL |  |  |  |  | 0.997
2010-01-09 00:00:00 | 48604 | 1352075 | 27.82 | 8 | 0.9998
2010-01-16 00:00:00 | 50478 | 1424747 | 28.23 | 0 | 1
2010-01-23 00:00:00 | 51296 | 1433567 | 27.95 | 3 | 0.9999
2010-01-30 00:00:00 | 54978 | 1527994 | 27.79 | 4 | 0.9999
2010-02-06 00:00:00 | 62290 | 1756967 | 28.21 | 1 | 1
1st PRD | 53529.2 | 1499070 | 28 | 3.2 | 0.9999 |  | SUBTOTAL for the period
2010-02-13 00:00:00 | 54892 | 1509321 | 27.5 | 0 | 1
2010-02-20 00:00:00 | 60433 | 1683508 | 27.86 | 0 | 1
2010-02-27 00:00:00 | 65057 | 1811016 | 27.84 | 0 | 1
2010-03-06 00:00:00 | 62208 | 1736486 | 27.91 | 0 | 1
2ND PRD | 60647.5 | 1685082.75 | 27.78 | 0 | 1
2010-03-13 00:00:00 | 63004 | 1759249 | 27.92 | 7 | 0.9999
2010-03-20 00:00:00 | 63452 | 1769425 | 27.89 | 6 | 0.9999
2010-03-27 00:00:00 | 62705 | 1741108 | 27.77 | 25 | 0.9996
2010-04-03 00:00:00 | 60710 | 1673328 | 27.56 | 3 | 1
3RD PRD | 62467.75 | 1735777.5 | 27.79 | 10.25 | 0.9998
2010-04-10 00:00:00 | 58942 | 1601839 | 27.18 | 30 | 0.9995
2010-04-17 00:00:00 | 61497 | 1670696 | 27.17 | 5 | 0.9999
2010-04-24 00:00:00 | 64621 | 1759301 | 27.22 | 8 | 0.9999
2010-05-01 00:00:00 | 63498 | 1727700 | 27.21 | 126 | 0.998
2010-05-08 00:00:00 | 67932 | 1875573 | 27.61 | 207 | 0.997
4TH PRD | 63298 | 1727021.8 | 27.28 | 75.2 | 0.9988
 |  | 0
2010-05-15 00:00:00 | 57681 | 1561002 | 27.06 | 156 | 0.9973
2010-05-22 00:00:00 | 61620 | 1702270 | 27.63 | 16 | 0.9997
2010-05-29 00:00:00 | 71539 | 1988960 | 27.8 | 23 | 0.9997
2010-06-05 00:00:00 | 66071 | 1832147 | 27.73 | 44 | 0.9993
5TH PRD | 64227.75 | 1771094.75 | 27.58 | 59.75 | 0.9991
2010-06-12 00:00:00 |  |  | 0 |  | 0
2010-06-19 00:00:00 |  |  | 0 |  | 0
2010-06-26 00:00:00 |  |  | 0 |  | 0
2010-07-03 00:00:00 |  |  | 0 |  | 0
6TH PRD | 0 | 0 | 0 | 0 | 0
2010-07-10 00:00:00 |  |  | 0 |  | 0
2010-07-17 00:00:00 |  |  | 0 |  | 0
2010-07-24 00:00:00 |  |  | 0 |  | 0
2010-07-31 00:00:00 |  |  | 0 |  | 0
2010-08-07 00:00:00 |  |  | 0 |  | 0
7TH PRD | 0 | 0 | 0 | 0 | 0
2010-08-14 00:00:00 |  |  | 0 |  | 0
2010-08-21 00:00:00 |  |  | 0 |  | 0
2010-08-28 00:00:00 |  |  | 0 |  | 0
2010-09-04 00:00:00 |  |  | 0 |  | 0
8TH PRD | 0 | 0 | 0 | 0 | 0
2010-09-11 00:00:00 |  |  | 0 |  | 0
2010-09-18 00:00:00 |  |  | 0 |  | 0
2010-09-25 00:00:00 |  |  | 0 |  | 0
2010-10-02 00:00:00 |  |  | 0 |  | 0
9TH PRD | 0 | 0 | 0 | 0 | 0
2010-10-09 00:00:00 |  |  | 0 |  | 0
2010-10-16 00:00:00 |  |  | 0 |  | 0
2010-10-23 00:00:00 |  |  | 0 |  | 0
2010-10-30 00:00:00 |  |  | 0 |  | 0
2010-11-06 00:00:00 |  |  | 0 |  | 0
10TH PRD | 0 | 0 | 0 | 0 | 0
2010-11-13 00:00:00 |  |  | 0 |  | 0
2010-11-20 00:00:00 |  |  | 0 |  | 0
2010-11-27 00:00:00 |  |  | 0 |  | 0
2010-12-04 00:00:00 |  |  | 0 |  | 0
11TH PRD | 0 | 0 | 0 | 0 | 0
2010-12-11 00:00:00 |  |  | 0 |  | 0
2010-12-18 00:00:00 |  |  | 0 |  | 0
2010-12-25 00:00:00 |  |  | 0 |  | 0
2011-01-01 00:00:00 |  |  | 0 |  | 0
12TH PRD | 0 | 0 | 0 | 0 | 0
YTD | AVERAGE | AVERAGE | AVERAGE | AVERAGE | AVERAGE |  | Help Calculate year to date
Spreadsheet: 736576d1623750246-need-help-extracting-single-data-from-cell-with-multi-data-excelforum_searchdata-ans-1-
Sheet: Jobs (2)

Job Number | Part Number | [NAME] | S/O | Ship Date
2572 | PN G | 10
3584 | PN 20 | 4
10014 | PN B | 4
10083 | PN D | 2
10085 | PN E | 4
10088 | PN F | 6
10232 | PN H | 4
10235 | PN I | 12
10269 | PN J | 1
10536 | PN N | 6
10591 | PN O | 4
10606 | PN Q | 4
25113 | PN C | 2
27184 | PN M | 4
28310 | PN P | 2
28658 | PN R | 8
29659 | PN 23 | 4 |  |  |  | Cust 1 | [NAME] | 17897 | 2020-02-05 00:00:00 | 1 | PN 23 | 29659 | 29660, 29662, 29663, 29567, 2572, 29661, 25293 | 29568, 29569, 29570, 29571, 28310-2 from stock, 25769-2 from stock, [25369-8 in stock, 25848-4 from stock], 29873, 29858, [25012-1 in stock, 25113], [24393-1 in stock, 29817
33026 | PN K | 1
003345-2 | PN A | 0
Spreadsheet: 8e620b78-e72f-4c9a-976d-1765d26287d0
Sheet: Sheet1

Table 7--U.S. feed grain imports by selected sources (1,000 metric tons) 1/, 11/14/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Import and country/region |  | ---------- 2010/11 ---------- |  | ---------- 2011/12 ---------- |  | 2012/13
 |  | Mkt year | [NAME] | Mkt year | [NAME] | [NAME]
Oats | Canada | 1393.292808 | 513.757001 | 1556.499397 | 558.158835 | 673.905242
 | Finland | 73.93257200000001 | 51.724542 | 34.84057 | 7.837
 | Jamaica | 0.159212 | 0.006248999999999999 | 0.285218 | 0.095232
 | All other countries | 0.264317 | 0.082076 | 29.802409 | 0.265508 | 0.6509489999999999
 | Total 2/ | 1467.648909 | 565.569868 | 1621.427594 | 566.356575 | 674.5561909999999
Malting barley | Canada | 174.724159 | 91.39116 | 263.6603059999999 | 16.80088 | 123.442881
 | All other countries | 0.006579999999999999 |  | 0.244638 | 0.017 | 0.016575
 | Total 2/ | 174.730739 | 91.39116 | 263.904944 | 16.81788 | 123.459456
Other barley 3/ | Canada | 30.69757099999999 | 6.847465 | 89.27383700000001 | 22.760805 | 31.473278
 | All other countries | 1.288141 | 0.4108499999999999 | 0.7575109999999999 | 0.11822 | 0.8434350000000002
 | Total 2/ | 31.98571200000001 | 7.258315 | 90.031348 | 22.879025 | 32.316713
1/ Grain only. Market year (June-May) and market year to date. 2/ Totals may not add due to rounding.
3/ Grain for purposes other than malting, such as feed and seed use. Source: U.S. Department of Commerce, Bureau of the Census, Foreign Trade Statistics.
Date run: 11/9/2012
Spreadsheet: 709718d1608521547-help-for-formula-to-count-number-of-reporting-months-which-fall-between-certain-dates-date-count-example
Sheet: Sheet1

Monthly Example
Start Date | End Date | Date Dif Months | reporting period start | reporting period end | Number of reporting months | Number of reporting months which fall between start date and end date
2017-04-01 00:00:00 | 2020-04-01 00:00:00 |  | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 |  | 4
2019-01-01 00:00:00 | 2021-01-01 00:00:00 |  | 2020-01-01 00:00:00 | 2020-03-01 00:00:00 |  | 3
2019-01-01 00:00:00 | 2021-05-01 00:00:00 |  | 2019-01-01 00:00:00 | 2020-06-01 00:00:00 |  | 18
Quarterly Example
Start Date | End Date | Date Dif Quarters | reporting period start | reporting period end | Number of reporting quarters | Number of  complete reporting quarters which fall between start date and end date
2017-04-01 00:00:00 | 2020-04-01 00:00:00 |  | 2020-01-01 00:00:00 | 2020-12-01 00:00:00 |  | 1
2019-01-01 00:00:00 | 2021-01-01 00:00:00 |  | 2020-01-01 00:00:00 | 2020-03-01 00:00:00 |  | 1
2019-01-01 00:00:00 | 2021-07-01 00:00:00 |  | 2019-01-01 00:00:00 | 2020-06-01 00:00:00 |  | 6
2018-11-01 00:00:00 | 2020-11-01 00:00:00 |  | 2020-01-01 00:00:00 | 2020-12-01 00:00:00 |  | 3 | 3 complete reporting quarters fall between the start and end date
 |  |  |  |  |  | 2018-11-01 00:00:00
Spreadsheet: 745927d1630369584-look-up-two-columns-return-the-second-column-with-a-sum-of-counts-for-both-columns-dates_data
Sheet: Sheet3

Internal A | Count |  | External B | Count |  |  | internal Date | vlookup internal number | Internal + 1 | vlookup External Number | <--I would like to consolidate these steps to look like this --> |  | Final Date | Count
 | 0 |  | 2021-04-26 00:00:00 | 0
N/A | 0 |  | 2021-05-24 00:00:00 | 4
NA | 0 |  | 2021-07-06 00:00:00 | 3
TBD | 0 |  | 2021-07-19 00:00:00 | 43
2021-03-14 00:00:00 | 2 |  | 2021-08-02 00:00:00 | 36
2021-03-28 00:00:00 | 10 |  | 2021-08-16 00:00:00 | 13
2021-04-11 00:00:00 | 7 |  | 2021-08-30 00:00:00 | 4
2021-04-24 00:00:00 | 40 |  | 2021-09-13 00:00:00 | 93
2021-05-09 00:00:00 | 135 |  | 2021-09-27 00:00:00 | 5
2021-05-23 00:00:00 | 86 |  | Grand Total | 198
2021-06-06 00:00:00 | 21
2021-06-20 00:00:00 | 14
2021-07-04 00:00:00 | 1 |  |  |  |  |  |  |  |  |  | <--I would like it to populate 07/06/2021
2021-07-18 00:00:00 | 3
2021-08-01 00:00:00 | 15
2021-08-15 00:00:00 | 5
2021-08-29 00:00:00 | 2
2021-09-12 00:00:00 | 9
Grand Total | 350 |  |  |  |  |  |  |  |  |  | <-- It would not populate 09/27/2021 b/c there is no 09/26/2021
Spreadsheet: 729972d1619462097-formula-show-the-last-day-of-customer-service-service-
Sheet: Sheet1

 | Customer Service | Period Service | Delivery | Amount |  | Period Service Last |  | Customer Service Last
 | Jessica | 2019-02-20 00:00:00 | [NAME] | 3000
 | [NAME] | 2019-04-21 00:00:00 | River Reach | 3000
 | Julian | 2019-08-01 00:00:00 | [NAME] | 3000
 | Jackeline | 2019-10-27 00:00:00 | [NAME] | 3000
 | [NAME] | 2020-01-22 00:00:00 | Small Acre | 3000 |  | Period Service Last | 2021-04-25 00:00:00 | Customer Service Last | [NAME]
 | Martin | 2020-07-01 00:00:00 | [NAME] | 3000
 | [NAME] | 2020-10-28 00:00:00 | The Heathers | 3000
 | [NAME] | 2020-11-16 00:00:00 | The Quarry | 3000
 | [NAME] | 2021-01-28 00:00:00 | Waldingfield Road | 3000
 | [NAME] | 2021-04-25 00:00:00 | [NAME] | 3000
Spreadsheet: 81958d1282058013-converting-nominal-value-to-real-value-data-modified
Sheet: GDP deflator

1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
54.043 | 59.119 | 62.726 | 65.207 | 67.655 | 69.713 | 71.25 | 73.196 | 75.694 | 78.557 | 81.59 | 84.443 | 86.386 | 88.381 | 90.259 | 92.106 | 93.852 | 95.414 | 96.472 | 97.868 | 100 | 102.399 | 104.187 | 106.404 | 109.463 | 113 | 116.567 | 119.682 | 122.087 | 124.298 | 126.598
Spreadsheet: 760958d1640568278-formula-to-textjoin-if-column-contains-the-same-values-excel-problem
Sheet: Sheet1

PROBLEM |  |  |  |  | DESIRED OUTPUT
Train | Count FTS | Location |  |  | Train | Locations
MAN1 | 2 | DEIGHTON |  |  | MAN1 | DEIGHTON, MIRFIELD, MORLEY, BATLEY, DEWSBURY, COTINGLEY, RAVENTHPE
MAN1 | 2 | MIRFIELD |  |  | [NAME] | MANCR VIC, MANCROXRD
MAN1 | 2 | MORLEY |  |  | CLE4 | MANCROXRD, MANCR VIC
MAN1 | 2 | BATLEY |  |  | YRK4 | DARLINGTN, CHESTERLS, NOALLERTN, DURHAM
MAN1 | 2 | DEWSBURY
MAN1 | 2 | COTINGLEY
MAN1 | 2 | RAVENTHPE
[NAME] | 2 | MANCR VIC
[NAME] | 2 | MANCROXRD
CLE4 | 2 | MANCROXRD
CLE4 | 2 | MANCR VIC
YRK4 | 2 | DARLINGTN
YRK4 | 2 | CHESTERLS
YRK4 | 2 | NOALLERTN
YRK4 | 2 | DURHAM
SHF6 | 0 | LEEDS WJ
SHF6 | 0 | MIRFLDEJN
SHF6 | 0 | THORNH JN
SHF6 | 0 | WHITEHLJN
SHF6 | 0 | BRADLEY J
SHF6 | 0 | LEEDS
SHF6 | 0 | HUDDFIELD
Spreadsheet: 799861d1665372760-formula-to-compute-diffrences-formula-to-sum-items-in-yellow-colour-
Sheet: Sheet1

On statement |  |  | Sum CF Items on Statement
2022-09-02 00:00:00 | 830 | 84.16
2022-09-09 00:00:00 | 657 | 41.1
2022-09-15 00:00:00 | 895 | 56639.27
2022-09-21 00:00:00 | 0221 | 52.11
2022-09-22 00:00:00 | 4893 | 593.4
2022-09-26 00:00:00 | 1005 | 188.43
On Ledger |  |  | [NAME] on Ledger
2022-09-12 00:00:00 | 175 | 41.1
2022-09-13 00:00:00 | 264 | 84.16
2022-09-16 00:00:00 | 633 | 56639.27
2022-09-27 00:00:00 | 165 | 188.44
2022-09-29 00:00:00 | 331 | 3607.6
2022-09-29 00:00:00 | 348 | 11849.13
2022-09-30 00:00:00 | 361 | 13645.41
2022-09-30 00:00:00 | 362 | 3607.62
Spreadsheet: 581094d1531119627-compare-2-sheets-and-show-balance-bbsn
Sheet: ENTRY

CODE | Customer Name | Address | DATE | MONTH | YEAR | Date of Keeping | Serial Number | Item Name | Gross Weight | Net Weight | Amount | Remarks
AS1 | Ranjana | Khabam | 20 | 2 | 2018 |  | 2 | [NAME] | 3 san | 2 san | 20000
AS2 | Samida | [NAME] | 1 | 2 | 2017 |  | 3 | lei |  |  | 10000
AS3 | Samida | [NAME] | 7 | 7 | 2018 |  | 4 | lik |  |  | 5000
AS4 | Jahida | khabam | 2 | 7 | 2018 |  | 5 | baltin mana | 4 san | 3 san | 25000 | received 200 int
[NAME] | L Bobby | mantripukri | 2 | 9 | 2017 |  | 6 | nl |  |  | 3500
[NAME] | L Bobby | [NAME] | 3 | 10 | 2017 |  | 7 | matek |  |  | 1500
AS7 | Sheetalit | moirang | 29 | 11 | 2016 |  | 8 | jantra |  |  | 1800
Spreadsheet: 482986d1475406378-lookup-columns-with-several-same-names-lookup-columns-with-several-same-names-reply
Sheet: Summary

[NAME] | Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | Field 6 | Field 7 | Field 8 | Field 9 | Field 10 | Field 11 | Field 12 |  |  |  |  | Kelly
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  |  | [NAME]
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  |  | [NAME]
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  |  | [NAME]
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  |  | Elsie
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  |  | Rachel
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  |  | [NAME]
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  |  | [NAME]
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 70912d1271675751-match-formula-example-23
Sheet: Sheet1

456 | found | found
457 | not found | not found
459 | found | found
460 | not found | not found
461 | found | found
311 | not found | not found
1 | not found | not found
3333 | found | found
Spreadsheet: d4a91822-411f-46e6-9a5d-7594188e693b
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Warner Home Video | 85391200635 | Peanuts | It'S The Easter Beagle [NAME] | 2010-03-16 | DVD | Children | 19.98 | Y | Available
Warner Home Video | 14764291727 | Various | [NAME], The | 2006-03-14 | DVD | Children | 9.98 | Y | Available
Spreadsheet: 9f2cb791-bd85-4eff-87d9-1a24c3535a1e
Sheet: Table 8.4

8.4 Short-term interest rates
 |  |  |  |  |  | Months (c)
 | Annual average (a) (b) |  |  |  |  | 2014
Country | 2010 | 2011 | 2012 | 2013 |  | Feb | Mar | Apr | May
Australia |  | 4.399 | 3.553 | 2.616 |  | 2.337 | 2.407 | 2.432 | 2.494
Canada | 0.5700000000000001 | 0.916 | 0.9470000000000001 | 0.966 |  | 0.87 | 0.847 | 0.927 | 0.926
China | 1.782 | 3.193 | 2.959 | 3.411 |  | 3.709 | 3.452 | 3.31 | 3.221
France | 0.392 | 0.713 | 0.065 | 0.063 |  | 0.158 | 0.195 | 0.199 | 0.154
Germany | 0.321 | 0.544 | 0.011 | 0.032 |  | 0.094 | 0.135 | 0.09 | 0.04
India | 5.412 | 8.247 | 8.679 | 8.901 |  | 9.346 | 9.351 | 9.142 | 9.033
Italy | 0.707 | 2.027 | 1.053 | 0.454 |  | 0.311 | 0.343 | 0.385 | 0.45
Japan | 0.114 | 0.111 | 0.11 | 0.089 |  | 0.052 | 0.037 | 0.062 | 0.053
Malaysia | 2.585 | 2.892 | 3.011 | 3 |  | 3 | 3 | 3 | 3
New Zealand | 3.036 | 2.826 | 2.698 | 2.686 |  | 2.954 | 3.082 | 3.273 | 3.408
Philippines | 3.791 | 2.03 | 1.747 | 0.797 |  | 1.289 | 1.335 | 1.605 | 1.346
Singapore | 0.337 | 0.274 | 0.269 | 0.245 |  | 0.289 | 0.305 | 0.332 | 0.328
Thailand | 1.447 | 2.891 | 3.145 | 3.145 |  | 3.145 | 3.145 | 3.145 | 3.145
United Kingdom | 0.547 | 0.58 | 0.468 | 0.376 |  | 0.379 | 0.361 | 0.369 | 0.372
United States | 0.135 | 0.049 | 0.084 | 0.055 |  | 0.047 | 0.05 | 0.027 | 0.028
Comparable data for Australia not available prior to August 2011
(a) 3 month Treasury [NAME].
(b) Years shown are calendar years.
(c)  Monthly average
Source: Datastream
 |  |  |  |  |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  |  |  |  |  | 2014-09-01 00:00:00
Spreadsheet: 62035d1262932758-another-index-match-example
Sheet: Sheet2

Weight | 5553 |  | [NAME] |  |  |  | A | B | C | D | E | F | G
Zone | B |  |  |  |  | 0 | 0.16 | 0.2 | 0.22 | 0.24 | 0.26 | 0.31 | 0.4
 |  |  |  |  |  | 5000 | 0.14 | 0.17 | 0.21 | 0.24 | 0.26 | 0.3 | 0.35
Spreadsheet: 300914d1393602347-sound-alert-as-a-cell-value-changes-sound-alert
Sheet: Sheet1

Category |  |  |  |  | Amount
 |  | Groceries |  |  |  |  |  | Expenses
Walmart |  |  |  |  |  |  |  | Walmart |  |  | -30
Target |  |  |  |  |  |  |  | Target |  |  | -20
 |  | Dining |  |  |  |  |  | Shell |  |  | -15
McDonald's |  |  |  |  |  |  |  | TGIF |  |  | -20
Taco Bell |  |  |  |  |  |  |  | Walmart |  |  | -90
TGIF |  |  |  |  |  |  |  | Sunoco |  |  | -30
 |  | Gas/ Fuel |  |  |  |  |  | Taco Bell |  |  | -50
Shell |  |  |  |  |  |  |  | TGIF |  |  | -20
Marathon |  |  |  |  |  |  |  | Walmart |  |  | -14
Sunoco |  |  |  |  |  |  |  | Sunoco |  |  | -30
TOTAL |  |  |  |  |  |  |  | McDonald's |  |  | -16
 |  |  |  |  |  |  |  | McDonald's |  |  | -15
 |  |  |  |  |  |  |  | Taco Bell |  |  | -10
 |  |  |  |  |  |  |  | Walmart |  |  | -10
 |  |  |  |  |  |  |  |  |  |  | -20
 |  |  |  |  |  |  |  | Now, If I type "Walmart" in the red cell, It will
 |  |  |  |  |  |  |  | Add "-20" to Groceries, and to the total.
 |  |  |  |  |  |  |  | However, if I type something that is not in the
 |  |  |  |  |  |  |  | Category list (ex: [NAME]), nothing will happen.
 |  |  |  |  |  |  |  | Which means I would have to add "Publix" to my
 |  |  |  |  |  |  |  | Category list to be included in the calculations.
 |  |  |  |  |  |  |  | I want to heat a beep or a .wav file evey time "F13"
 |  |  |  |  |  |  |  | changes value.
Spreadsheet: 42f5a016-1b68-4672-b72f-d5e5218c4496
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6198 | 25827 | Nadia | Pretorius | RSA | 24 | 00:42:47 | 00:00:00 | 01:17:58 | 00:00:00 | 00:22:13 | 1 | 02:22:59
Spreadsheet: 36baaf76-bd90-4bdd-afcf-8e041bbd716b
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME] im ländlichen Raum Südliche Oberlausitz - Variante 2
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 55 | 116520 | 104334 | 89912 | 79203
55 - 60 | 16183 | 16162 | 16606 | 12814
60 - 65 | 13949 | 15891 | 15721 | 16230
65 - 75 | 27877 | 24562 | 26292 | 29439
75 - 85 | 19952 | 22372 | 22128 | 18920
85 und mehr | 6878 | 7976 | 9031 | 11221
Insgesamt | 201359 | 191297 | 179690 | 167827
%
unter 55 | 57.86679512711128 | 54.54032211691767 | 50.03728643775391 | 47.19324065853528
55 - 60 | 8.036889336955388 | 8.448642686503186 | 9.241471423006288 | 7.635243435204108
60 - 65 | 6.927428125884615 | 8.306978154388203 | 8.748956536256888 | 9.670672776132564
65 - 75 | 13.84442711773499 | 12.8397204347167 | 14.63186599142968 | 17.54127762517354
75 - 85 | 9.908670583385891 | 11.69490373607532 | 12.31454171072403 | 11.27351379694566
85 und mehr | 3.415789708927836 | 4.169432871398924 | 5.025877900829205 | 6.686051708008843
Insgesamt | 100 | 100 | 100 | 100
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 858888d1707392819-help-sumif-multiple-tabs-example2
Sheet: June

Name | NHS | 1st | 2nd | 3rd | Seen | Comments |  |  | Month Summary
Name 66
Name 67
Name 68 |  |  |  |  |  |  |  |  | Done Totals
Name 69 |  |  |  |  |  |  |  |  | Outstanding Totals
Name 70
Name 71
Name 72
Name 73
Name 74
Name 75
Name 76
Name 77
Spreadsheet: chris_germany__1881__2001tran05
Sheet: IT & Pooling

East Desk IT and Pooling Contracts
Pipeline | Contract # | Sitara | Rate Schedule |  | Volume | [NAME] | Delivery Points | Volume | Comment
Transco | 0.3051 | 77177 | IT |  |  | All | All | ?? | Primary use is to nomiante gas to the interconnects.
Transco | 0.4983 | 77169 | IT |  |  | All | All | ?? | Primary use is to nominate supply into the pools
Transco | 0.2999 |  | IT |  |  | All | All | ?? | Primary use is to nominate supply into the pools
Transco | 0.2774 | 77175 | IT |  |  | All | All | ?? | Primary use is to nominate supply into the pools
Transco | 0.7537 | 82420 | FT-R |  |  | All | All | ?? | Master [NAME] contract - use to nominate firm capacity on rate schedule FT
Transco | 3.073 | 96503 | PBS |  |  | All | All | ?? | Use to park and borrow gas.  Remember to update the "DEAL FEES" on the front screen of the deal.
Transco | 1.8793 | 104783 | ICTS |  |  | All | All | ?? | Interconnect Transfer Service Agreement.
Transco | 0.9047 | 168466 | Overrun |  |  | All | All | ?? | Overrun contract
Chandeleur | CI-30
Tennessee | 2891 |  | IT |  |  | All | All
Tennessee | 80045 |  | ??
Texas Eastern | B10851 | 98243 | IT-BH |  |  | All | All |  | Backhaul IT contract
Texas Eastern | B10851 | 98567 | IT-1 |  |  | All | All |  | Forward Haul IT contract
Texas Eastern | 600228 | 77009 | TABS-1 |  |  | All | All |  | Pooling contract.  No transport rates.
Texas Gas Transmission | T006057 | 168569 | FT |  |  | All | All |  | Dayton does the scheduling and they will bill ENA for the transport usage.
Algonquin | 9310010 |  | AIT
CGLF | 38641 | 93039 | ITS-1 |  |  |  |  |  | Used for mainline receipts and deliveries.
CGLF | 37556 | 93037 | ITS-2 |  |  |  |  |  | Used for onshore and offshore receipts and deliveries.
CGLF | 39229 | 93030 | IPP |  |  |  |  |  | Pooling Contract
CGAS | 40998 |  | IT
CGAS | 38021 | 166118 | SST |  |  | All | All |  | Dayton does the scheduling and they will bill ENA for the transport usage.
CNG | MCS105 | 102637 | MCS |  | 60000 |  |  |  | Use for parking and loaning.
CNG | 8T001N | 549343
CNG | 8T001S | 549352
CNG | 8G001N | 549353
CNG | 8G001S | 549354
National Fuel Gas Supply | V02241 | 104749 | FMS |  |  | NFGUPS |  |  | Use when purchasing gas from National Fuel Gas Supply
National Fuel Gas Supply | I00454 | 82026 | IT |  |  | All | All
National Fuel Gas Supply | H02262 | 312407 | ISS |  |  | All | All |  | Use when parking gas first then withdrawing.
National Fuel Gas Supply | A02353 | 312309 / 362289 | IAS |  |  | All | All |  | Use when borrowing gas then paying back.
Bridgeline Gas Distribution Co. LLC | 1-70-185 | 117510 | IT |  |  |  |  |  | Set up in Sitara
[NAME] | 15 | 125711 | IT
Iroquois | R-1250-99 | 124109 | Park & Loan
Iroquois | R-1250-01 | 77753 | IT
KO Transmission | 019 | 220796 | IT |  | Evergreen |  |  |  | Acquired from CES
CES/Agency | Transco | Transco | Evergreen | Evergreen | all | all | IT | 0 | 0 | 0.0022 | 0.0072 | 0.0131 | 0 |  | 1.1501 | 1.1501 | 0 | CES IT Contract |  |  |  | 145336
[NAME] | ENA-00001 | 220903
Spreadsheet: 34259d1231421485-xl-charting-problem-667726
Sheet: Data 

SWGR AFR Statistics
 |  | AFR |  | X | Y
2005/2006 | 1 | 0.568 |  | 0 | 0.2
 | 2 | 0.687 |  | 1 | 0.18
 | 3 | 0.792
 | 4 | 0.994
 | 5 | 0.887
 | 6 | 0.895
 | 7 | 0.895
 | 8 | 0.797
 | 9 | 0.802
 | 10 | 0.8
 | 11 | 0.697
 | 12 | 0.598
 | 13 | 0.696
2006/2007 | 1 | 0.7
 | 2 | 0.694
 | 3 | 0.602
 | 4 | 0.404
 | 5 | 0.41
 | 6 | 0.415
 | 7 | 0.422
 | 8 | 0.538
 | 9 | 0.548
 | 10 | 0.551
 | 11 | 0.57
 | 12 | 0.589
 | 13 | 0.361
2008/2009 | 1 | 0.247
 | 2 | 0.127
 | 3 | 0.13
 | 4 | 0.133
 | 5 | 0.134
 | 6 | 0.135
 | 7 | 0.136
 | 8 | 0
 | 9 | 0
 | 10 | 0
 | 11 | 0
 | 12 | 0
 | 13 | 0
2009/2010 | 1 | 0
 | 2 | 0
 | 3 | 0
 | 4 | 0
 | 5 | 0
 | 6 | 0
 | 7 | 0
 | 8 | 0.122
 | 9 | 0.12
 | 10
 | 11
 | 12
 | 13
2010/2011 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13