tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 215056d1361242206-find-duplicate-multiple-columns-count-only-most-recent-row-excel-2007-sample-worksheet
Sheet: Sheet1

Name | Company | Activity | Date | Period | Count
[NAME] | Quicksilver | Call | 2013-01-07 00:00:00 |  | 1
[NAME] | Toyota | [NAME] | 2012-12-21 00:00:00 |  | 1
[NAME] | LandRover | [NAME] | 2013-02-06 00:00:00 |  | 1
Sandee | Toyota | Call | 2011-10-07 00:00:00 |  | 1
[NAME] | Quicksilver | [NAME] | 2012-12-08 00:00:00
[NAME] | Quicksilver | Call | 2012-12-21 00:00:00
[NAME] | Quicksilver | [NAME] | 2013-01-01 00:00:00
[NAME] | [NAME] | Call | 2012-12-14 00:00:00 |  | 1
Aging Pivot Table
Count of Count
Name | Company | 0 to 30 days | 30 to 60 days | 60 to 90 days | Greater 90 days
[NAME] | Quicksilver |  | 1
 | Toyota |  |  | 1
[NAME] | LandRover | 1
 | [NAME] |  |  | 1
Sandee | Toyota |  |  |  | 1
Spreadsheet: 139ec7ff-f666-42b9-93c6-a3c5849a46fa
Sheet: Sheet1

Table 4--Wheat: Monthly food disappearance estimates (1,000 grain-equivalent bushels), 7/15/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Mkt year and month 1/
 |  |  | Wheat ground for flour | + | Food imports 2/ | + | Nonmilled food use 3/ | - | Food exports 2/ | = | Food use 4/
2011/12 | Jun |  | 70554 |  | 2237 |  | 2000 |  | 1743 |  | 73048
 | Jul |  | 72573 |  | 2098 |  | 2000 |  | 1326 |  | 75344
 | Aug |  | 79317 |  | 2308 |  | 2000 |  | 2390 |  | 81235
 | Sep |  | 76269 |  | 2245 |  | 2000 |  | 1652 |  | 78863
 | Oct |  | 81402 |  | 2246 |  | 2000 |  | 1487 |  | 84162
 | Nov |  | 77915 |  | 2568 |  | 2000 |  | 1763 |  | 80720
 | Dec |  | 73135 |  | 2464 |  | 2000 |  | 1291 |  | 76308
 | Jan |  | 74522 |  | 2583 |  | 2000 |  | 1280 |  | 77826
 | Feb |  | 73931 |  | 2056 |  | 2000 |  | 1336 |  | 76650
 | Mar |  | 78437 |  | 2556 |  | 2000 |  | 1764 |  | 81230
 | Apr |  | 74497 |  | 2621 |  | 2000 |  | 1506 |  | 77613
 | May |  | 76171 |  | 2527 |  | 2000 |  | 2342 |  | 78355
2012/13 | Jun |  | 72876 |  | 2178 |  | 2000 |  | 1724 |  | 75330
 | Jul |  | 75861 |  | 2295 |  | 2000 |  | 2906 |  | 77250
 | Aug |  | 82910 |  | 2345 |  | 2000 |  | 2187 |  | 85069
 | Sep |  | 79725 |  | 2062 |  | 2000 |  | 2283 |  | 81504
 | Oct |  | 81567 |  | 2460 |  | 2000 |  | 1834 |  | 84194
 | Nov |  | 78073 |  | 2446 |  | 2000 |  | 1598 |  | 80920
 | Dec |  | 73283 |  | 2371 |  | 2000 |  | 1447 |  | 76207
 | Jan |  | 72290 |  | 2191 |  | 2000 |  | 1550 |  | 74931
 | Feb |  | 71716 |  | 2101 |  | 2000 |  | 1674 |  | 74143
 | Mar |  | 76088 |  | 2391 |  | 2000 |  | 1744 |  | 78734
 | Apr |  | 0 |  | 2581 |  | 0 |  | 1432 |  | 1149
 | May |  | 0 |  | 2530 |  | 0 |  | 2042 |  | 488
1/ Current year is preliminary. Previous year is preliminary through August of current year, estimated afterwards. 2/ Food imports and exports used to calculate total food use. Includes all categories of wheat flour, semolina, bulgur, and couscous and selected categories of pasta. 3/ Wheat prepared for food use by processes other than milling.
4/ Estimated food use equals wheat ground for flour plus food imports plus nonmilled food use minus food exports. See http://www.ers.usda.gov/topics/crops/wheat/estimating-wheat-supply-and-use/food-use-estimates.aspx for more information. Source: Data through the 2nd quarter of 2011 was calculated using data from U.S. Department of Commerce, Bureau of the Census’ Flour Milling Products (MQ311A) and U.S. Department of Commerce, Bureau of Economic Analysis’ Foreign Trade Statistics. Subsequent flour milling calculations are based on data from the North American Millers Association.
Date run: 7/15/2013
Spreadsheet: 59482d1259969976-count-the-number-of-values-between-two-numbers-how-to-let-excel-count-the-number-of-values-with-aavaluesetween-two-numbers
Sheet: Sheet1

2.26 | 1.5 | 1.75 | 0
1.88 | 1.75 | 2 | 4
1.97 | 2 | 2.25 | 11
1.8 | 2.25 | 2.5 | 4
2.04 | 2.5 | 2.75 | 1
1.85 | 2.75 | 3 | 0
1.95 | 3 | 3.25 | 0
1.75 | 3.25 | 3.5 | 0
1.84 | 3.5 | 3.75 | 0
2.03 | 3.75 | 4 | 0
1.73 | 4 | 4.25 | 0
2.22
1.75
1.87
2.01
1.88
1.73
1.86
1.77
1.89
Spreadsheet: 695904d1600452549-return-name-from-row-based-on-rank-from-total-of-columns-tourney-standings
Sheet: Sheet1

 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2020-09-03 00:00:00 | 3 | 5 | 2 | 4 | 1 | N/A | N/A | N/A | N/A
2020-09-10 00:00:00 | 5 | 3 | 2 | N/A | N/A | 1 | N/A | N/A | 4
2020-09-17 00:00:00 | 6 | 2 | 3 | 9 | 1 | 7 | 4 | 8 | N/A
2020-09-24 00:00:00
2020-10-01 00:00:00
2020-10-08 00:00:00
2020-10-15 00:00:00
2020-10-22 00:00:00
2020-10-29 00:00:00
2020-11-05 00:00:00
2020-11-12 00:00:00
2020-11-19 00:00:00
2020-11-26 00:00:00
2020-12-03 00:00:00
2020-12-10 00:00:00
2020-12-17 00:00:00
2020-12-24 00:00:00 | Christmas Eve
2020-12-31 00:00:00 | New Years Eve
2021-01-07 00:00:00
2021-01-14 00:00:00
2021-01-21 00:00:00
2021-01-28 00:00:00
2021-02-04 00:00:00
2021-02-11 00:00:00
2021-02-18 00:00:00
2021-02-25 00:00:00
2021-03-04 00:00:00
2021-03-11 00:00:00
2021-03-18 00:00:00
2021-03-25 00:00:00
2021-04-04 00:00:00
2021-04-11 00:00:00
2021-04-18 00:00:00
2021-04-25 00:00:00
Total |  | 10
 | 14 | 10 | 7 | 13 | 2 | 8 | 4 | 8 | 4
 | 4-Player Pay Out |  | 1st-$60 | 2nd-$20
 | 5-Player Pay Out |  | 1st-$70 | 2nd-$30
 | 6-Player Pay Out |  | 1st-$80 | 2nd-$40
 | 7-Player Pay Out |  | 1st-$95 | 2nd-$45
 | 8-Player Pay Out |  | 1st-$100 | 2nd-$50 | 3rd-$10
 | 9-Player Pay Out |  | [NAME] | 2nd-$55 | 3rd-$15
 | 10-Player Pay Out |  | 1st-$120 | 2nd-$60 | 3rd-$20
Spreadsheet: 711603d1609792665-extract-data-from-column-b-for-month-cola-matching-category-c-and-search-words-d-example
Sheet: Sheet1

 | date | amount | category | description |  |  |  |  | January | February | March
 | 2020-01-19 00:00:00 | 793.2157424689843 | manufacuturing | raw materials |  |  | office supplies | printer
 | 2020-01-20 00:00:00 | 465.4523385206585 | office supplies | printer paper |  |  |  | chairs
 | 2020-03-19 00:00:00 | 113.7474512908302 | packaging | repairs |  |  | packaging | maintenance
 | 2020-03-27 00:00:00 | 503.7659816134972 | office supplies | printer paper |  |  |  | supplies
 | 2020-04-04 00:00:00 | 950.0314409277963 | manufacuturing | maintenance
 | 2020-04-12 00:00:00 | 840.6975914146053 | manufacuturing | maintenance
 | 2020-05-11 00:00:00 | 355.2266935587126 | packaging | supplies
 | 2020-05-14 00:00:00 | 718.5633560767365 | manufacuturing | raw materials
 | 2020-05-17 00:00:00 | 321.1895086592373 | manufacuturing | maintenance
 | 2020-05-24 00:00:00 | 201.2859636629194 | packaging | materials
 | 2020-05-30 00:00:00 | 611.2702777770525 | manufacuturing | raw materials
 | 2020-06-03 00:00:00 | 788.1315365219751 | manufacuturing | discardation
 | 2020-06-25 00:00:00 | 668.9830376400133 | packaging | installation
 | 2020-07-23 00:00:00 | 554.6038568253077 | packaging | new machine
 | 2020-08-01 00:00:00 | 411.2082630423009 | manufacuturing | raw materials
 | 2020-08-04 00:00:00 | 590.952710697995 | office supplies | printer
 | 2020-08-11 00:00:00 | 502.9410172845846 | manufacuturing | raw materials
 | 2020-09-04 00:00:00 | 685.275482254 | packaging | supplies
 | 2020-09-11 00:00:00 | 884.664530573648 | office supplies | chairs
 | 2020-09-16 00:00:00 | 367.7512849655972 | packaging | repairs
 | 2020-10-04 00:00:00 | 544.4386059323381 | manufacuturing | discardation
 | 2020-10-11 00:00:00 | 573.9819104535738 | office supplies | paperclips
 | 2020-12-07 00:00:00 | 668.4393341495951 | office supplies | tacks
 | 2020-12-15 00:00:00 | 159.2853240589621 | manufacuturing | raw materials
 | 2020-12-17 00:00:00 | 387.9078428187544 | manufacuturing | machine maintenance
 | 2020-12-21 00:00:00 | 776.0952514018581 | manufacuturing | maintenance
Spreadsheet: 759469d1639567079-lookup-values-from-multi-values-in-single-cell-multi-lookup
Sheet: Sheet1

 |  |  |  |  |  | Lookup Table
 |  | PRD1; | Group 1 |  |  | PRD1 | Group 1
 |  | PRD2;PRD1 | Group 1 |  |  | PRD2 | Group 1
 |  | PRD4; | Group 2 |  |  | PRD3 | Group 1
 |  | PRD5;PRD6 | Group 2 |  |  | PRD4 | Group 2
 |  | PRD1;PRD4;PRD5 | Both |  |  | PRD5 | Group 2
 |  | PRD1;PRD6 | Both |  |  | PRD6 | Group 2
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: PG&E

56698
Day | Scheduled | Measured
1 | 199560 | 201126
2 | 147248 | 148629
3 | 192955 | 194271
4 | 192652 | 193485
5 | 169009 | 165596
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  | -10045
2001-06-05 00:00:00
Spreadsheet: 448bd9a5-0c67-4a27-afa6-0cb4ba113abd
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: Construction Spending
 |  | Total Construction: U.S. Total
 |  | Seasonally Adjusted Total Construction [Millions of Dollars]
 |  | Period: 2002 to 2012
 |  | Data Extracted on: December 20, 2014 (6:43 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
Spreadsheet: 355808d1414787513-move-a-row-to-a-new-sheet-based-on-a-cells-value-job-requisition-workbook
Sheet: WESTMONT

Westmont Healthcare Community |  |  |  | Administrator: [NAME]: |  | EEO: [EMAIL] Phone: [PHONE]
Requisition # | Job Title | Department | [NAME] | Position Open | Offer Accepted | Shift | Reason for Opening | Days Open | Satus
WESTM14003 | CNA | Nursing | 10.25 | 2014-10-30 00:00:00 |  | FT DAY | New Position
WESTM14002 | RN | Nursing | 22 | 2014-10-30 00:00:00 |  | FT DAY | New Position
WESTM14001 | LPN | Nursing | 17.25 | 2014-10-30 00:00:00 |  | FT EVENING | New Position
Spreadsheet: darrell_schoolcraft__7796__imbalsumm0107
Sheet: DEFS

 | 23995 |  | 22051 |  | 22051
 | 59687 |  | 10703 |  | 78169
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 0 | 0 | 24670 | 23460 | 5859 | 5072
2 | 0 | 0 | 24668 | 23536 | 5831 | 5129
3 | 0 | 0 | 24650 | 24000 | 5360 | 5129
4 |  |  | 24663 | 24000 | 5420 | 5126
5 |  |  | 24668 | 24000 | 5484 | 5124
6 |  |  | 24503 | 24000 | 5429 | 5129
7 |  |  | 24451 | 23999 | 5242 | 5129
8 |  |  | 24468 | 23999 | 5480 | 5129
9 |  |  | 24443 | 23999 | 5410 | 5129
10 |  |  | 24497 | 24000 | 5394 | 5129
11 |  |  | 24479 | 24000 | 5664 | 5129
12 |  |  | 24472 | 24000 | 5778 | 5129
13 |  |  | 24489 | 24000 | 5753 | 5129
14 |  |  | 24484 | 23536 | 5619 | 5129
15 | 1 |  | 23245 | 20840 | 5765 | 5129
16 | 16 |  | 22510 | 23536 | 5860 | 5129
17 |  |  | 22450 | 24000 | 5860 | 5129
18 |  |  | 20394 | 24000 | 4806 | 5129
19 |  |  | 7631 | 11501 | 1872 | 5129
20 |  |  | 22472 | 21941 | 2985 | 3143
21 |  |  | 24856 | 21802 | 2309 | 3554
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 | Balance | -1023092.89 |  |  |  | -436546.2
2001-07-21 00:00:00 | Balance
 |  |  |  | Contract #
 |  |  |  | 22864 |  |  | -58339.66 | Zia
 |  |  |  | 20379 |  |  | -51695.87 | Grayco/Artesia
 |  |  |  | 21459 |  |  | 10570.56
 |  |  |  | 26357 |  |  | 44144.84 | [NAME]
 |  |  |  | 21544 |  |  | 61340.16 | [NAME], [NAME]
 |  |  |  | 24532 |  |  | -671608.5 | 500211,500212,500219,500230 - Coburn points
 |  |  |  | Duke
Spreadsheet: 729157d1618936588-index-and-match-formula-error-b1-accounts-apr-2021-v1
Sheet: Transactions

Month | Trxn  Type | For Unit | Transaction Details | Purpose in Brief | [NAME] | Amount Received or Paid | Cash Receipt or Exp Vchr No. | Mode of Transaction | Balance in ICICI Bank | Balance in Corp Bank | [NAME]
2021-04-01 00:00:00 | Income | B1-101 | EFT 2021 Maint Apr 21 |  | 2021-04-20 00:00:00 | 1950 |  |  | 300000 |  | 2000
 |  |  |  |  |  | 3000 |  | Debit by Bank
 |  |  |  |  |  | 5000 |  | [NAME] to Acct
 |  |  |  |  |  | 3200 |  | Paid in Cash
Yes | Income | B1 Bldg |  |  |  |  |  | EFT to Bank Acct
No | Expense | B1-101 |  |  |  |  |  | Received in Cash
 | Transfer | B1-102 |  |  |  |  |  | [NAME] to Acct
 |  | B1-103 |  |  |  |  |  | Paid in Cash
 |  | B1-104 |  |  |  |  |  | Paid by Cheque
 |  | B1-201 |  |  |  |  |  | Paid via EFT
 |  | B1-202 |  |  |  |  |  | Cash Deposit to Acct
 |  | B1-203 |  |  |  |  |  | Cash Withdrawal
 |  | B1-204 |  |  |  |  |  | Credit by Bank
 |  | B1-301/2 |  |  |  |  |  | Debit by Bank
 |  | B1-303
 |  | B1-304
 |  | B1-401
 |  | B1-402
 |  | B1-403
 |  | B1-404
 |  | B1-501
 |  | B1-502
 |  | B1-503
 |  | B1-504
 |  | B1-601/2
 |  | B1-603
 |  | B1-604
 |  | B1-701/2
 |  | B1-703/4
Spreadsheet: 437941d1451592193-filtering-a-table-using-a-dynamic-drop-down-dashboard-dropdown-filter
Sheet: Data

 | clinic_id | provider_id | total_prod | [NAME] |  |  |  | Clinic_Id | provider_id
 | 6 | 56 | 133927.57 | 1255.94139473648
 | 6 | 65 | 53341.99 | 676.88384741779 |  |  |  | 6 | 56
 | 11 | 30 | 37051.5 | 493.28606447505 |  |  |  | 11 | 65
 | 11 | 48 | 52053.36 | 803.164685905048 |  |  |  | 12 | 30
 | 11 | 49 | 598.39 | 30.1555204375757 |  |  |  | 15 | 48
 | 12 | 47 | 79760.27 | 932.288642803221 |  |  |  | 17 | 49
 | 12 | 48 | 13468.68 | 196.392700771803 |  |  |  | 18 | 47
 | 12 | 54 | 41497.63 | 382.505075979711 |  |  |  | 19 | 54
 | 15 | 26 | 141299.82 | 1669.4070546488 |  |  |  | 20 | 26
 | 15 | 37 | 87024.06 | 1251.6849036017 |  |  |  |  | 37
 | 15 | 47 | 24108.25 | 281.312252790726 |  |  |  |  | 39
 | 17 | 39 | 31908.7 | 317.286152771857 |  |  |  |  | 50
 | 17 | 47 | 126801.2 | 1408.84810168038 |  |  |  |  | 31
 | 17 | 49 | 15299.32 | 218.424869739363 |  |  |  |  | 34
 | 17 | 50 | 1177.3 | 21.2900090503364 |  |  |  |  | 33
 | 18 | 31 | 50699.39 | 423.585888135182 |  |  |  |  | 41
 | 18 | 34 | 34210 | 472.746056264314 |  |  |  |  | 44
 | 19 | 33 | 103643.1 | 1071.1798985785 |  |  |  |  | 46
 | 19 | 34 | 48508.9 | 556.615206652506
 | 19 | 39 | 21289.5 | 204.984525102928
 | 19 | 41 | 8538.3 | 117.11752474698
 | 20 | 44 | 109712.22 | 1085.37842097303
 | 20 | 46 | 13900.7 | 141.148422963494
Spreadsheet: 695226d1600102237-count-number-of-cells-between-2-repeating-values-eg
Sheet: Sheet1

 | DATE | ASSET CHECKED | DAYS SINCE LAST ASSET CHECK
 | 2020-01-01 00:00:00 | 1 |  | EXPECTED RESULTS
 | 2020-01-02 00:00:00 | 2
 | 2020-01-03 00:00:00 | 3
 | 2020-01-04 00:00:00 | 4
 | 2020-01-05 00:00:00 | 5
 | 2020-01-06 00:00:00 | 2
 | 2020-01-07 00:00:00 | 1
 | 2020-01-08 00:00:00 | 3
 | 2020-01-09 00:00:00 | 4
 | 2020-01-10 00:00:00 | 5
 | 2020-01-11 00:00:00 | 1
 | 2020-01-12 00:00:00 | 2
 | 2020-01-13 00:00:00 | 3
 | 2020-01-14 00:00:00 | 4
 | 2020-01-15 00:00:00 | 5
Spreadsheet: 7a383b6c-db11-4b33-8748-58fdebd1d723
Sheet: Sheet1

CAPITAL PROJECT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Ordinance Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Estimate and appropriate federal grant money for green impact zone project
Is this ordinance for the following: |  |  |  |  | New Construction
 |  |  |  | X | Replacement
 |  |  |  |  | Repair
Was this project programmed in the Five-Year Capital Improvement Plan? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify year in which this project was funded. |  |  |  |  |  | FY | 2012
 | If no, please detail the reasons why this project was not included and need for present funding request.
Does this project leverage non-city funds for design/construction? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify source and amount.
 | Source of Funds: |  |  |  | Tiger Grant
 | Year Funded: |  |  |  | 2012
 | Amount of Non-City Funds: |  |  | $ | 2395640.92
 | If no, please identify source and amount of city funds.
 | Acct #:
 | Name of Fund:
 | Year Funded:
 | Amount of City Funds: |  |  | $
If ordinance is for new construction or replacement of asset please provide the following information:
 | Total estimated costs (design through construction): |  |  | $ | 2395640.92
 | Estimated lifespan of project in years |  |  | $ | 25 years
 | Estimated annual operating and maintenance costs |  |  | $ | 0
 | (Please detail type of maintenance or operating costs needed, additional staffing, capital maintenance costs, utilities, etc.)
Are these O&M costs reflected in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please please provide source of funds.
 | If no, please identify year in which additional operating and maintenance costs will be needed. |  |  |  |  |  |  |  |  |  | 2037
 | It will be included in all years of general operation money and fixed as needed.
Reference Numbers: (Previously approved legislation):
Reviewed by:
 |  |  |  |  |  | OMB Approval Date
Spreadsheet: 782255d1653924382-is-there-a-way-to-combine-multiple-similar-equations-in-one-formula-sample-book
Sheet: Sheet1

 |  | Cost Centre 1 | Cost Centre 2 | Cost Centre 3 |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6
 | Postage | 0.35 | 0.35 | 0.3 |  |  | 200 | 300 | 200 | 250 | 300 | 150
 | Rent | 0.5 | 0.5 | 0 |  |  | 6000 | 6000 | 6000 | 6000 | 6000 | 6000
 | Telephones | 0.4 | 0.4 | 0.2 |  |  | 750 | 800 | 750 | 600 | 930 | 750
 | Salaries | 0.1 | 0.4 | 0.5 |  |  | 5000 | 5000 | 5000 | 5000 | 5000 | 5000
 | Insurance | 0.2 | 0.6 | 0.2 |  |  | 950 | 950 | 950 | 950 | 950 | 950
 | Legal | 0.45 | 0.45 | 0.1 |  |  | 430 | 430 | 430 | 430 | 430 | 430
 |  |  |  | Total CC1
 |  |  |  | Total CC2
 |  |  |  | Total CC3
Spreadsheet: 0095deb3-50b5-4a25-a37c-b46450442834
Sheet: Sheet1

Unit | 2006 | Unnamed: 2 | Unnamed: 3 | 2007 | Unnamed: 5 | Unnamed: 6 | 2008 | Unnamed: 8 | Unnamed: 9 | AVERAGES | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
 | NOx | SO2 | PM10 | NOx | SO2 | PM10 | NOx | SO2 | PM10 | NOx |  | SO2 |  | PM10
 | tons/year | tons/year | tons/year | tons/year | tons/year | tons/year | tons/year | tons/year | tons/year | tons/year | lb/MMBtu | tons/year | lb/MMBtu | tons/year | lb/MMBtu
B003 | 204.82 | 263.7 | 2.33 | 150.44 | 205 | 1.88 | 170.36 | 266.8 | 2.086 |  | 0.1830362478155477 |  | 0.2603416201589718 |  | 0.002222222222222222
Historical Baseline
B003
Year | Coal usage (tons/year) | Coal heating value (Btu/lb) | Coal usage ([NAME]/yr) | NOx (tpy) | w/ 20% contingency | SO2 (tpy) | PM10 (tpy) | SO2 w/ 20% contingency
2000 | 38438 | 12959 | 996236.084 | 204.82 | 245.784 | 276 | 2.46 | 331.2
2001 | 36993 | 12344 | 913283.184 | 193.19 | 231.828 | 253.7 | 2.318
2002 | 35187 | 12449 | 876085.926 | 185.33 | 222.396 | 247.6 | 2.224
2003 | 35449 | 12378 | 877575.444 | 185.64 | 222.768 | 263.5 | 2.228
2004 | 33375 | 12404 | 827967 | 175.14 | 210.168 | 269.7 | 2.102
2005 | 32840 | 12189 | 800573.52 | 173.52 | 208.224 | 263.1 | 2.082
2006 | 35245 | 12407 | 874569.43 | 185 | 222 | 263.7 | 2.33
2007 | 28485 | 12483 | 711156.51 | 150.44 | 180.528 | 205 | 1.88
2008 | 31601 | 12742 | 805319.884 | 170.36 | 204.432 | 266.8 | 2.086
AVG | 34179.22222222222 | 12483.88888888889 | 853640.7757777777 | 180.3822222222222 | 216.4586666666667 | 256.5666666666667 | 2.19
MAX | 38438 | 12959 | 996236.084 | 204.82 | 245.784 | 276 | 2.46
Uncontrolled PM10 Emissions
Emission factor |  | 13.2 | lb PM10/ton coal
Emission factor |  | 0.5286814115971697 | lb PM10/MMBtu coal | Boiler 3
Uncontrolled Emissions |  | 263.3457495865783 | tons PM10/year | Boiler 3
Uncontrolled NOx Emissions
Emission factor |  | 11 | lb NOx/ton coal | Table 1.1-3 | B-rated in AP-42
Emission factor |  | 0.4405678429976415 | lb NOx/MMBtu coal | unit conversion method
Control Efficiency (Average of 2006 - 2008)
Boiler 3 | 1
Stack Test Control Efficiency
Boiler 3 | 0.9300145622895624 | Date: August 23, 2007 | Emissions | 0.037 | lb PM10/MMBtu coal
SO2 Calcs |  | Using Stoker Coal Analysis
 |  | [NAME]S | Min btu/lb | SO2 lb/MMBtu | plus 20% | rounded
 | 2000-2006 | 0.55 | 11068 | 0.9923683532825928 | 1.190842023939111 | 1.190842023939111
 | 2006-2008 | 0.55 | 11221 | 0.9788372635354903 | 1.174604716242588 | 1.174604716242588
 | 2009-Nov 2010 | 0.57 | 11444 | 0.9946639402076656 | 1.193596728249199 | 1.193596728249199
SO2 lb/mmbtu = (%S/100) * (64.032/32.064 MWSO2/MWS) / (btu/lb) * (10^6 btu/MMBtu)
Spreadsheet: mary_fischer__25717__Consolidated of 890 20Q 20R 1572
Sheet: July

Enron Energy Services
MTM Summary
Companies 1572, 890, 20Q, 20R
Balance Sheet Look
 |  |  |  | Beginning |  |  |  | Ending
COMPANY |  | Account MSA/SAP |  | Balance |  | Change |  | Balance
1572 |  | 20004000- N/R |  | 0 |  |  |  | 28789243
1572 |  | 20029200- A/R Third Parties |  | 0 |  |  |  | 6327530
1572 |  | 25100000- PRM Assets- NonCurrent |  | 0 |  |  |  | 228099428
1572 |  | 25100300- Prudency Reserve |  | 0 |  |  |  | -16338160
890 |  | 21060000- PRM Asset- Current |  | 50493145 |  |  |  | 206298339
890 |  | 25100000- PRM Asset- NonCurrent |  | 587035369 |  |  |  | 928188129
890 |  | 25100100- Credit Reserve |  | -55096987 |  |  |  | -135322770
890 |  | 25100200- Prudency Reserve |  | 831595 |  |  |  | -43290416
890 |  | 25100300- Prudency Reserve |  | 0 |  |  |  | 16338160
890 |  | 30300000- PRM Liability- Current |  | -448393114 |  |  |  | -119495683
890 |  | 33100000- PRM Liability- NonCurrent |  | -115116482 |  |  |  | -616545425
20Q |  | 20032500- Liquidation |  | -8673064 |  |  |  | 12467418
20Q |  | 21060000- PRM Asset- Current |  | 1277047002 |  |  |  | 218478592
20Q |  | 25100000- PRM Asset- NonCurrent |  | 196011309 |  |  |  | 202614660
20Q |  | 25100100- Credit Reserve |  | 0 |  |  |  | -1762590
20Q |  | 25100200- Prudency Reserve |  | 12033165 |  |  |  | -3360737
20Q |  | 25100300- Prudency Reserve |  | 0 |  |  |  | -28818837
20Q |  | 30300000- PRM Liability- Current |  | -1247510983 |  |  |  | -179024538
20Q |  | 33100000- PRM Liability- NonCurrent |  | -155003635 |  |  |  | -109312628
20R |  | 21060000- PRM Asset- Current |  | 31910438 |  |  |  | 1
 |  |  |  |  |  | Ending
 |  | Account |  |  |  | Balance
1572 |  | No MTM Income Accounts
890 |  | 42000000- Unrealized MTM Revenue |  |  |  | -391094343
20Q |  | 42000000- Unrealized MTM Revenue |  |  |  | -58370148
20R |  | 42000000- Unrealized MTM Revenue |  |  |  | -33719564
 |  | Difference
 |  | The $20 million difference is due to error made at EOY last year.  Separate entry has been made to address this
 |  | error.
Spreadsheet: 235530d1368531598-pull-data-using-drop-down-list-urgent-attached-sample
Sheet: Parish

ALBOURNE
ALDINGBOURNE
ALDWICK
AMBERLEY
ANGMERING
ANSTY AND STAPLEFIELD
APPLEDRAM
ARDINGLY
ARUNDEL
ASHINGTON
ASHURST
ASHURST WOOD
BALCOMBE
BARLAVINGTON
BARNHAM
BEPTON
BERSTED
BIGNOR
BILLINGSHURST
BIRDHAM
BOGNOR REGIS
BOLNEY
BOSHAM
BOXGROVE
BRAMBER
BROADBRIDGE HEATH
BURGESS HILL
BURPHAM
BURY
CHICHESTER
CHIDHAM
CLAPHAM
CLAYTON
CLIMPING
COCKING
COLDWALTHAM
COLGATE
COMPTON
COOMBES
COWFOLD
CRAWLEY
CUCKFIELD
DONNINGTON
DUNCTON
EARNLEY
EARTHAM
EASEBOURNE
EAST DEAN
EAST GRINSTEAD
EAST LAVINGTON
EAST PRESTON
EAST WITTERING
EASTERGATE
EBERNOE
ELSTED
FELPHAM
FERNHURST
FERRING
FINDON
FISHBOURNE
FITTLEWORTH
FORD
FULKING
FUNTINGTON
GRAFFHAM
HARTING
HASSOCKS
HAYWARDS HEATH
HENFIELD
HEYSHOTT
HORSHAM
HORSTED KEYNES
HOUGHTON
HUNSTON
HURSTPIERPOINT
ITCHINGFIELD
KEYMER
KINGSTON
KIRDFORD
LANCING
LAVANT
LINCH
LINCHMERE
LINDFIELD RURAL
LINDFIELD URBAN
LITTLEHAMPTON
LODSWORTH
LOWER BEEDING
LOXWOOD
LURGASHALL
LYMINSTER
MADEHURST
MARDEN
MIDDLETON-ON-SEA
MIDHURST
MILLAND
NEWTIMBER
NORTH HORSHAM
NORTH MUNDHAM
NORTHCHAPEL
NUTHURST
OVING
PAGHAM
PARHAM
PATCHING
PETWORTH
PLAISTOW
POLING
POYNINGS
PULBOROUGH
PYECOMBE
ROGATE
RUDGWICK
RUSPER
RUSTINGTON
SELSEY
SHERMANBURY
SHIPLEY
SHOREHAM-BY-SEA
SIDLESHAM
SINGLETON
SLAUGHAM
SLINDON
SLINFOLD
SOMPTING
SOUTH STOKE
SOUTHBOURNE
SOUTHWATER
SOUTHWICK
STEDHAM-WITH-IPING
STEYNING
STOPHAM
STORRINGTON
STOUGHTON
SULLINGTON
SUTTON
TANGMERE
THAKEHAM
TILLINGTON
TREYFORD
TROTTON-WITH-CHITHURST
TURNERS HILL
TWINEHAM
UPPER BEEDING
UPWALTHAM
WALBERTON
WARNHAM
WARNINGCAMP
WASHINGTON
WEST CHILTINGTON
[NAME]
WEST GRINSTEAD
WEST HOATHLY
WEST ITCHENOR
WEST LAVINGTON
WEST THORNEY
WEST WITTERING
WESTBOURNE
WESTHAMPNETT
WISBOROUGH GREEN
WISTON
WOODMANCOTE
WOOLBEDING
WORTH
WORTHING
YAPTON