tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__1168__DUE DILIGENCE PLAN 120999
Sheet: DOCUMENTNEEDS

 |  | ACCOMACK COUNTY/DELMARVA POWER PROJECT
CONTRACT
 | Interconnection Agreement with Delmarva Power and Light
REGULATORY
 | Environmental Impact Statement
 | Air permits
 | Proposed modification to EIS/Air Permits
 | Water withdrawal permit
 | Wastewater discharge permit
TECHNICAL
 | Transmission interconnect study
 | Site survey - both existing owned site and adjacent buffer acreage - should include new access road right of way
 | Site soil investigations
 |  | historical
 |  | toxic wastes
 |  | surface/underground obstructions - existing buildings, structures, foundations, tanks
 |  | geotechnical studies
 |  | test water well investigation
 | Major Equipment Purchase Orders and Specifications
 |  | LM 6000's
 |  | Main power transformers
 |  | Medium Voltage transformers/Switchgear
 |  | Chillers/chiller cooling towers
 |  | Demineralized water treatment system
 |  | Fuel oil centrifuge/filter system
 | Drawings
 |  | Regional plan
 |  | Site layout including access road, transmission interconnection
 |  | Major project electrical one-line
 |  | Major process flow diagrams
 | Fuel
 |  | Purchase specification
 | Performance
 |  | Buildup of guaranteed net plant performance at ISO and summer rating conditions - capacity, heat rate/fuel consumption, auxiliary power. Standby power, startup/shutdown power/fuel
 |  | Guaranteed emissions data
 | Project schedule
ECONOMIC
 | Proforma
 | EPC Estimate detail
 | O&M Estimate detail
Spreadsheet: 349478d1412345282-formula-to-refer-to-array-in-another-sheet-that-shifts-based-on-date-vertex34
Sheet: Sheet3

 |  |  |  | 2011-04-01 00:00:00
 |  |  | Price / unit
Start date | Quarterly kWh | Cost to Date ($) | end date |  | Q3-11 | Q4-11 | Q1-12 | Q2-12 | Q3-12 | Q4-12 | Q1-13 | Q2-13 | Q3-13 | Q4-13 | Q1-14 | Q2-14 | Q3-14 | Q4-14
2011-09-21 00:00:00 | 1424 |  | 2011-10-03 00:00:00
2011-09-21 00:00:00 | 1424 |  | 2011-09-28 00:00:00
Spreadsheet: 82554d1282622429-percentile-calculations-for-frequency-of-observations-example1
Sheet: Distance Percentile

Here is a sample of my data
Destination | Distance (km) | Frequency (observed trips)
A | 2 | 5
A | 4 | 3
A | 6 | 2
A | 1 | 6
B | 1.2 | 3
B | 2.4 | 2
B | 5.6 | 1
Here is how I know to do the calculation I need to perform but I don't have the data in this format
 |  | Distance to destination (km)
Destination | Distance | 85th Percentile | median | 15th percentile
A | 2
A | 2
A | 2
A | 2
A | 2
A | 4
A | 4
A | 4
A | 6
A | 6
A | 1
A | 1
A | 1
A | 1
A | 1
A | 1
B | 1.2
B | 1.2
B | 1.2
B | 2.4
B | 2.4
B | 5.6
I would then create a pivot table to summarize
Spreadsheet: 805783d1668915283-make-a-list-of-components-when-enter-quantity-of-product-bom-example
Sheet: product B

name | code | quantity | packing/box
glass B | 814 | 2 | 10
tube B | 754 | 2 | 20
ring B | 591 | 4 | 100
cover B | 345 | 1 | 25
bond | 110 | 6 | 100
Spreadsheet: 594495d1539795906-creating-segregated-lists-based-on-value-in-column-split
Sheet: Folha1

 |  |  |  | Office >=2010
Task | Person | Status |  | Choose: | Finished |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Status
task1 | Person1 | Finished |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Finished
[NAME] | Person2 | Finished |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pending
task3 | Person2 | Pending
task4 | Person1 | Pending
 |  |  |  | Office <2010
 |  |  |  | Choose: | Pending
Spreadsheet: larry_campbell__21027__Solar Saturn limits
Sheet: Sheet1

 |  |  |  |  |  |  |  | 976 | rated BHP
 |  | Amb Temp | 75 |  |  |  |  | 75 | amb. [NAME] ([NAME])
 |  | Net Output Power | 976 |  | bhp |  |  | 878 | BHP
 |  | Heat Rate | 10398 |  | btu/hp-hr | 11566 |  | 11566 | BTU / BHP.hr
 |  |  |  |  | btu/hr |  |  |  | BTU / hr
 |  |  |  |  | gigajoules/hr |  |  |  | [NAME] / hr
 |  | [NAME] in 40 CFR 60.330 | 10.7 |  | gigajoules/hr
 |  | Conversion factor | 0.000948451 |  | btu/joule |  |  |  | [NAME]/btu
 |  |  |  |  | btu/hr ( lhv )
 |  |  |  |  | btu/hr ( hhv )
 | Does a Mark 2 have lower emissions than [NAME] ?
 | What do you use for a conversion constant to go from gigajoules/hr to BTU/hour ?
 | Heat Rate at ISO conditions:  10,864 Btu/Hp-hr |  |  |  |  |  |  | 75 | amb. [NAME] ([NAME])
 |  |  |  |  |  |  |  | 976 | BHP
 | 10,864 Btu/Hp-hr  x  1055 J/Btu  /  745.7 w/Hp  /  1000 J/KJ = |  |  |  |  |  |  | 10864 | BTU / BHP.hr
 | 15.37 KJ/w-hr |  |  |  |  |  |  |  | BTU / hr
 |  |  |  |  |  |  |  |  | [NAME] / hr
 | [NAME] denominator is 14.4 per the regulation |  |  |  |  |  |  | 10.7 |  | gigajoules to high
 | 14.4  /  14.4  x  0.015   =  150  ppm |  |  |  |  |  | [NAME], I don't think this is correct, it's more like 15,000ppm
 | The regulatory limit is 150 ppm.  We warranty the Saturn 1500 at
 | 110 ppm.  I would suppose that the 1200 had a similar warranty.
Spreadsheet: 688238d1595657189-extract-values-with-criteria-then-sort-them-sample
Sheet: Sample

 | Data source |  |  | Actual formula |  |  | Expected result
 | MATERIAL # | MISSING STOCK (QTY) |  | MATERIAL # | Cross-check |  | MATERIAL # | Cross-check
 | 8001947 | 2258 |  |  |  |  | 8005606
 | 8005604 | 0 |  |  |  |  | 8010244
 | 8005606 | 490 |  |  |  |  | 8022660
 | 8007802 | 3311 |  |  |  |  | 8104601
 | 8010244 | 640 |  |  |  |  | 8001947
 | 8013080 | 0 |  |  |  |  | 8007802
 | 8022660 | 999
 | 8104601 | 1376
Spreadsheet: 691285d1597610987-vlookup-where-the-reference-is-number-formatted-in-one-sheet-and-text-formatted-in-the-sec-vlookup-question
Sheet: Aug.

[NAME] | Period | Country | Currency | Document Number
MEDIA LLC | Jun 2020 | US | USD | URMAY20
4M | Jun 2020 | JP | [NAME] | 202004
4M | Jun 2020 | JP | [NAME] | 202006
A&N | Jun 2020 | AU | USD | SIN463902
PVT LTD | Jun 2020 | IN | USD | 195000000000
OVATION INC. | Jun 2020 | JP | [NAME] | 202005
PR LIMITED | Jun 2020 | GB | GBP | [NAME]
TIVA, INC. | Jun 2020 | US | USD | 3137
TIVA, INC. | Jun 2020 | US | USD | 3140
TIVA, INC. | Jun 2020 | US | GBP | 3153
RITHM INC | Jun 2020 | JP | [NAME] | 202005
ALL | Jun 2020 | JP | [NAME] | 202004
ALL | Jun 2020 | JP | [NAME] | 202005
ONLINE UK LIMITED | Jun 2020 | GB | USD | 420014299
Spreadsheet: 857922d1706779004-compare-multiple-tables-etf-overlap-aligw
Sheet: CPSEETF

Stock Invested in | Sector | Sector Total | Value(Mn) | % of Total Holdings | 1M Change | 1Y Highest Holding | 1Y Lowest Holding | Quantity | 1M Change in Qty | M-Cap | GroupName
Power Grid Corporation of India Ltd. | Power - transmission | 20.15 | 61513.9 | 0.2015 | 0.0109 | 20.33% (Feb 2023) | 17.78% (Aug 2023) | 25.93 Cr | 86.04 L | Large Cap | 74.9
National Thermal Power Corporation Ltd. | Power generation | 26.13 | 60818.7 | 0.1992 | 0.0023 | 21.53% (Aug 2023) | 18.63% (May 2023) | 19.55 Cr | [NAME] | Large Cap | 74.9
Coal India Ltd. | Coal | 18.02 | 55010.8 | 0.1802 | -0.0061 | 18.66% (Oct 2023) | 15.25% (Jul 2023) | 14.63 Cr | [NAME] | Large Cap | 74.9
Oil & Natural Gas Corporation Ltd. | Oil exploration & production | 19.61 | 51309.4 | 0.1681 | -0.0134 | 20.42% (Feb 2023) | 16.81% (Dec 2023) | 25.02 [NAME] | [NAME] | Large Cap | 74.9
Bharat Electronics Ltd. | Aerospace & defense | 13.87 | 42332.6 | 0.1387 | 0.0139 | 14.33% (May 2023) | 12.15% (Feb 2023) | 22.98 Cr | [NAME] | Mid Cap | 21.52
NHPC Ltd. | Power generation | 26.13 | 11241.7 | 0.0368 | 0.0016 | 4.34% (Apr 2023) | 3.52% (Nov 2023) | 17.40 Cr | [NAME] | Mid Cap | 21.52
Oil India Ltd. | Oil exploration & production | 19.61 | 8545 | 0.028 | 0.0019 | 3.41% (Mar 2023) | 2.61% (Nov 2023) | 2.30 Cr | [NAME] | Mid Cap | 21.52
SJVN Ltd. | Power generation | 26.13 | 4127.9 | 0.0135 | -0.0008 | 1.43% (Nov 2023) | 0.57% (Feb 2023) | 4.54 Cr | [NAME] | Small Cap | 3.54
NLC India Ltd. | Power generation | 26.13 | 3608 | 0.0118 | 0.0028 | 1.18% (Dec 2023) | 0.63% (Jan 2023) | 1.42 Cr | -3.23 L | Small Cap | 3.54
NBCC (India) Ltd. | Civil construction | 1.17 | 3579 | 0.0117 | -0.0007 | 1.24% (Nov 2023) | 0.82% (Feb 2023) | [NAME] | -9.97 L | Mid Cap | 21.52
Cochin Shipyard Ltd. | Ship building & allied services | 1.01 | 3085.3 | 0.0101 | -0.0001 | 1.02% (Nov 2023) | 0.58% (Feb 2023) | 22.79 L | [NAME] | Small Cap | 3.54
Spreadsheet: 0a379928-a7f3-47bb-908f-f8e3939b92db
Sheet: Sport1 (Hungary)

Sport1 (Hungary)
Date | Start (CET) | End (CET) | Notes
2010-11-21 00:00:00 | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-21 00:00:00 | 21:00:00 | 23:00:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | 21:00:00 | 23:00:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | 21:00:00 | 23:00:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | 21:00:00 | 23:00:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | 21:00:00 | 23:00:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | 15:00:00 | 17:00:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | 21:00:00 | 23:00:00 | Round [NAME] (Singles)
2010-11-27 00:00:00 | 15:00:00 | 17:30:00 | Semi-Final 1 - Live (Singles)
2010-11-27 00:00:00 | 21:00:00 | 23:30:00 | Semi-Final 2 - Live (Singles)
2010-11-28 00:00:00 | 18:30:00 | 21:30:00 | Singles Final - Live
Spreadsheet: 0bf6846f-7d62-4da2-bdb2-e241540345f7
Sheet: Sheet1

Table 5--USDA-calculated world market rice prices (rough basis) 1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | 2011/12 |  |  | 2010/11 |  |  | 2009/10
 |  | Medium/ |  |  | Medium/ |  |  | Medium/
Month | Long | short |  | Long | short |  | Long | short
 | $/cwt
August | 14.08 | 14.4 |  | 9.58 | 9.68 |  | 11.33 | 11.42
September | 15.09 | 15.44 |  | 10.51 | 10.62 |  | 11.25 | 11.35
October | 15.63 | 15.99 |  | 12.15 | 12.29 |  | 11.02 | 11.11
November | 14.93 | 15.28 |  | 13.4 | 13.58 |  | 11.4 | 11.5
December | 13.9 | 14.21 |  | 14.5 | 14.67 |  | 13.03 | 13.15
January | 12.61 | 12.88 |  | 13.98 | 14.15 |  | 13.03 | 13.14
February | 11.81 | 12.2 |  | 12.68 | 13.35 |  | 12.74 | 12.99
March | 11.52 | 11.92 |  | 12.13 | 12.76 |  | 11.21 | 11.42
April 2/ | 11.01 | 11.39 |  | 11.76 | 12.36 |  | 10.53 | 10.72
May |  |  |  | 11.58 | 12.17 |  | 9.92 | 10.1
June |  |  |  | 11.78 | 12.39 |  | 9.41 | 9.57
July |  |  |  | 12.49 | 13.14 |  | 9.42 | 9.58
Market-year
average 1/ | 13.39777777777778 | 13.74555555555555 |  | 12.21166666666667 | 12.59666666666666 |  | 11.19083333333333 | 11.3375
1/ Simple average of the U.S. Department of Agriculture's weekly adjusted world market price.  2/  Preliminary.
Source: [NAME] and Rice Weekly Prices (ftp://ftp.fsa.usda.gov/public/cotton/default.htm), Farm Service Agency, USDA.
Last updated April 10, 2012.
Spreadsheet: 852627d1702596346-formula-to-locate-data-in-the-same-column-but-on-different-rows-and-place-data-ina-new-sheet-addressbookreport
Sheet: Data

Address Book Report
Name:
Organization:
Speciality:
Title |  | First Name | [NAME] | Family Name
[NAME] |  | Council No. |  | Affiliation |  | Specialty
Organization | ABC Company | Day Phone | +xxxxxxxxxx | Night Phone |  | Fax
Healthlink Mailbox |  | [NAME] | office@xxxxx | Notes |  | Active [Yed/No] | Yes
Permanent Address |  |  |  | Postal Address
Title |  | First Name | [NAME] | Family Name
[NAME] |  | Council No. |  | Affiliation |  | Specialty
Organization | JKL Company | Day Phone | +xxxxxxxxxx | Night Phone |  | Fax | 67594297
Healthlink Mailbox |  | [NAME] | reception@xxxx | Notes |  | Active [Yed/No] | Yes
Permanent Address |  |  |  | Postal Address
Title |  | First Name | [NAME] | Family Name
[NAME] |  | Council No. |  | Affiliation |  | Specialty
Organization | XYZ Company | Day Phone | +xxxxxxxxxx | Night Phone |  | Fax | 92381973
Healthlink Mailbox |  | [NAME] |  | Notes |  | Active [Yed/No] | Yes
Permanent Address |  |  |  | Postal Address
Requested Outcome to display like this
Spreadsheet: 206395d1358177933-how-to-create-a-functional-drop-down-menu-to-update-expiry-dates-members
Sheet: Members

2013-01-13 00:00:00
Member ID | First Name | Last Name | Membership Type | Start Date | [NAME]
1 | [NAME] | Kimuyu | 1 Week | 2013-01-09 00:00:00 | 2013-01-15 00:00:00 |  |  | 1 Week
2 | Rhys | McDonald | 1 Week |  | 2012-12-23 00:00:00 |  |  | 1 Month
3 | [NAME] | Sharp |  |  | 2012-12-23 00:00:00 |  |  | 3 Months
4 | Adam | Simnott |  |  | 2012-12-26 00:00:00 |  |  | 6 Months
5 | Mark | Finch |  |  | 2012-12-03 00:00:00 |  |  | 12 Months
6 | [NAME] | [NAME] | 1 Month |  | 2013-01-24 00:00:00
7 | [NAME] | [NAME]
8 | Vishal | [NAME]
9 | [NAME] | Edwards | 3 Months |  | 2013-03-16 00:00:00
10 | [NAME] | Bradley
11 | [NAME] | Knight
12 | [NAME] | Palmer | 3 Months |  | 2013-02-20 00:00:00
13 | Kristen | Duffin
14 | [NAME] | Burrows
15 | [NAME] | Watson
16 | [NAME] | [NAME]
17 | [NAME] | Illson
18 | [NAME] | Murphy
19 | [NAME] | Whitehead
20 | [NAME] | Bone |  |  | 2012-12-16 00:00:00
21 | [NAME] | Lampard | 1 Month |  | 2013-01-29 00:00:00
22 | [NAME] | Craven |  |  | 2012-12-10 00:00:00
23 | [NAME] | [NAME]
24 | Aby | [NAME]
25 | Micheal | Beeby
26 | [NAME] | [NAME]
27 | [NAME] | Wroughton
28 | Peri | Theodosiou
29 | [NAME] | Coulsons |  |  | 2013-01-10 00:00:00
30 | Shaun | Guthrit
31 | Mark | Bailey | 1 Month |  | 2013-01-29 00:00:00
32 | [NAME] | Betts
33 | [NAME] | [NAME]
34 | [NAME] | [NAME]
35 | [NAME] | Thorpe
36 | [NAME] | Bhamra
37 | Arran | Coffey
38 | [NAME] | Smith
39 | George | draper
40 | [NAME] | Wilson
41 | Adrian | Mulligan | 1 Month |  | 2013-01-25 00:00:00
42 | [NAME] | [NAME] | 1 Week |  | 2013-01-15 00:00:00
43 | Brett | Mitchell | 1 Week |  | 2013-01-15 00:00:00
44 | [NAME] | Gibbons
45 | Callum | Smith
46 | Callum | [NAME]
47 | [NAME] | [NAME]
48 | [NAME] | Griffiths
49 | [NAME] | McAdam | 1 Week |  | 2013-01-11 00:00:00
50 | [NAME] | Would
51 | Jon | [NAME]
52 | [NAME] | Orridge
53 | Adam | [NAME]
54 | Niall | Gibbons
55 | [NAME] | [NAME]
56 | [NAME] | Mclocklin
57 | [NAME] | Ward
58 | [NAME] | Thorpe
59 | [NAME] | Durner
Spreadsheet: 219728d1362921989-cross-reference-coumns-that-contain-specific-text-and-count-them-up-cross-reference
Sheet: Sheet1

Colour | Amount 2 or 4
RED | 2
GREEN | 2 |  |  |  |  | RED | 2
GREEN | 4 |  |  |  |  | RED | 4
RED | 2 |  |  |  |  | GREEN | 2
RED | 4 |  |  |  |  | GREEN | 4
Spreadsheet: 127231d1320247788-multiple-cascading-dropdowns-dynamic-data-validation-list-using-index-3-dependant-dropdowns
Sheet: Customers

Country 1 | Country 2 | Country 3 | Country 4 | Country 5
Country 1, Customer 1 | Country 2, Customer 1 | Country 3, Customer 1 | Country 4, Customer 1 | Country 5, Customer 1
Country 1, Customer 2 | Country 2, Customer 2 | Country 3, Customer 2 | Country 4, Customer 2 | Country 5, Customer 2
Country 1, Customer 3 | Country 2, Customer 3 | Country 3, Customer 3 | Country 4, Customer 3 | Country 5, Customer 3
Country 1, Customer 4 | Country 2, Customer 4 | Country 3, Customer 4 |  | Country 5, Customer 4
Country 1, Customer 5 | Country 2, Customer 5 | Country 3, Customer 5 |  | Country 5, Customer 5
Country 1, Customer 6 |  | Country 3, Customer 6 |  | Country 5, Customer 6
Country 1, Customer 7 |  |  |  | Country 5, Customer 7
Country 1, Customer 8
Spreadsheet: 100728d1298995581-need-help-automating-large-and-index-match-plzhelp
Sheet: Sheet1

my number--> | 1111
Numbers
1111 | 25 | AA
1111 | 32 | AB
1111 | 425 | SD
2222 | 65 | AS
2222 | 42 | DA
3333 | 86 | AP
1111 | 325 | BA
1111 | 425 | SS
3333 | 254 | SP
4444 | 53 | PW
how do I automate this?
TOP ENTRIES:
1 | 425 | SD
2 | 425 | SS
3 | 325 | BA
Spreadsheet: 298652d1392855808-sumifs-for-dates-sum-total-for-each-month-rent
Sheet: Sheet1

 |  |  |  |  | Jan 2014 Rent | 43000
 |  |  |  |  | Feb 2014 Rent | 32000
Date | Rent |  |  |  | Mar 2014 Rent | 57000
2014-01-01 00:00:00 | 8000 |  |  |  | Apr 2014 Rent | 19000
2014-01-16 00:00:00 | 20000 |  |  |  | May 2014 Rent | 23000
2014-01-31 00:00:00 | 15000 |  |  |  | Jun 2014 Rent | 11000
2014-02-10 00:00:00 | 23000 |  |  |  | Jul 2014 Rent | 7000
2014-02-28 00:00:00 | 9000 |  |  |  | Aug 2014 Rent | 21000
2014-03-03 00:00:00 | 15000 |  |  |  | Sep 2014 Rent | 6000
2014-03-07 00:00:00 | 7000 |  |  |  | Oct 2014 Rent | 18000
2014-03-16 00:00:00 | 18000 |  |  |  | Nov 2014 Rent | 21000
2014-03-20 00:00:00 | 2000 |  |  |  | Dec 2014 Rent | 8000
2014-03-31 00:00:00 | 15000 |  |  |  | Jan 2015 Rent | 13000
2014-04-30 00:00:00 | 19000 |  |  |  | Feb 2015 Rent | 23000
2014-05-31 00:00:00 | 23000 |  |  |  | Mar 2015 Rent | 4000
2014-06-30 00:00:00 | 11000 |  |  |  | Apr 2015 Rent | 22000
2014-07-31 00:00:00 | 7000 |  |  |  | May 2015 Rent | 29000
2014-08-31 00:00:00 | 21000 |  |  |  | Jun 2015 Rent | 6000
2014-09-30 00:00:00 | 6000 |  |  |  | Jul 2015 Rent | 20000
2014-10-31 00:00:00 | 18000 |  |  |  | Aug 2015 Rent | 15000
2014-11-30 00:00:00 | 21000
2014-12-31 00:00:00 | 8000
2015-01-31 00:00:00 | 13000
2015-02-28 00:00:00 | 23000
2015-03-31 00:00:00 | 4000
2015-04-30 00:00:00 | 22000
2015-05-11 00:00:00 | 7000
2015-05-31 00:00:00 | 22000
2015-06-30 00:00:00 | 6000
2015-07-31 00:00:00 | 20000
2015-08-31 00:00:00 | 15000
Spreadsheet: 65959d1266588735-count-values-from-same-dates-in-list-without-vba-list
Sheet: Sheet1

(list manually filled in) |  |  |  | (result list)
Date | Item | Status |  | Date | OK | Overdue
2010-01-01 00:00:00 | apple | OK |  | 2010-01-08 00:00:00
2010-01-02 00:00:00 | pear | OK |  | 2010-01-07 00:00:00
2010-01-03 00:00:00 | orange | Overdue |  | 2010-01-06 00:00:00
2010-01-01 00:00:00 | apple | OK |  | 2010-01-05 00:00:00
2010-01-05 00:00:00 | pear | Overdue |  | 2010-01-04 00:00:00
2010-01-06 00:00:00 | orange | OK |  | 2010-01-03 00:00:00
2010-01-01 00:00:00 | apple | Overdue |  | 2010-01-02 00:00:00
2010-01-08 00:00:00 | pear | OK |  | 2010-01-01 00:00:00 | 2 | 1 |  | exemple
2010-01-06 00:00:00 | orange | OK
2010-01-07 00:00:00 | apple | OK |  | Dates change with formula from TODAY() upwards (backwards) to TODAY(-7)
2010-01-08 00:00:00 | pear | OK |  | Result list will only cover 8 "current" days
2010-01-09 00:00:00 | orange | Overdue
2010-01-10 00:00:00 | apple | OK
2010-01-11 00:00:00 | pear | Overdue
2010-01-12 00:00:00 | orange | OK
2010-01-13 00:00:00 | apple | Overdue
2010-01-14 00:00:00 | pear | OK
Spreadsheet: tracy_geaccone__40281__EMNNG01CE
Sheet: IntDeduct

PRINT: PRINT
 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
DIRECT INTEREST EXPENSE
Carrying Charges - Reverse Auction 1 | Linked
- Reverse Auction 2 | Linked
- Reverse Auction 3 | Linked
- GSR R.A. | Linked
- Stranded 858 | Linked
- Rate Case | Linked
Carlton Resolution | Linked
Discount Issue |  | 1 | 2 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
AFUDC - Debt (SAP Change 7/00 Forward) | Link D.T. | -1 | -3 | -2 | -4 | -11 | -48 | -10 | -8 | -9 | -10 | -4 | -6
[NAME] (ASCC) Fees |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other (2&3/01-KS Ad Valorem Issue) |  | 1 | -23 |  | 2 | 1 | 1 |  |  |  | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL DIRECT INTEREST
INTERCOMPANY INTEREST EXPENSE / (INCOME)
Intercompany Interest Expense / (Income) |  |  |  | -4363 | -1463 | -1288 | -1198 | -1195 | -1334 | -1271 | -1288 | -1190 | -1196
Long Term Debt (Pre 1/1/98) - Interest Expense |  |  |  |  | 2031 | 2031 | 2031 | 2031 | 2031 | 2031 | 2031 | 2031 | 2031
- Debt Expense Amortization |  | 27 | 29 | 26 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27
Long Term Debt (Post 1/1/98) - Interest Expense |  | 844 | 844 | 844 | 843 | 844 | 844 | 844 | 843 | 844 | 844 | 844 | 843
- Debt Expense Amortization |  | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 10 | 11 | 11
- Interest Expense Differential |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL INTERCOMPANY INTEREST EXPENSE/(INCOME)
AFUDC
AFUDC - Equity (6/01 Prior Yr. Adj. $133K) |  | -3 | -13 | -8 | -13 | -41 | -175 | -38 | -30 | -33 | -34 | -14 | -23
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL AFUDC
OTHER DEDUCTIONS
Reacquired Debt - Amortized Loss | Link D.T. | 39 | 38 | 39 | 38 | 39 | 38 | 39 | 38 | 39 | 38 | 39 | 39
- Amortized (Gain) | Link D.T. | -1 | 0 | -1 | 0 | -1 | -1 | 0 | -1 | 0 | -1 | 0 | -1
Donations |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Reserve Issues - Building / Reversal | Link D.T. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Cooper Issue (Parts Sale) Deferred Gain | Link D.T. | 0 | 0 | 0 | 0 | 0 | 0 | -155 | 0 | 0 | 0 | 0 | 0
- Miscellaneous | Link D.T. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Miscellaneous | Link D.T. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Litigation Settlements |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1999 Base Gas Monetization (Physical / Pricing Amort.)
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL OTHER DEDUCTIONS
TOTAL INTEREST & OTHER DEDUCTIONS
Spreadsheet: 299394d1393166007-how-to-insert-simpsons-rule-of-integration-into-excel-2010-with-a-set-of-data-2
Sheet: Sheet2

Table of Boeing 737 Outboard Airfoil Cross Section:
BOEING 737 | OUTBOARD AIRFOIL | BOEING 737 | OUTBOARD AIRFOIL
23 | 23 | 23 | 23
0 | 0 | 0 | 0
0.0025 | 0.007 | 0.0025 | -0.0051
0.005 | 0.01 | 0.005 | -0.0066
0.0075 | 0.0123 | 0.0075 | -0.0077
0.0125 | 0.016 | 0.0125 | -0.0091
0.025 | 0.0232 | 0.025 | -0.0116
0.05 | 0.0335 | 0.05 | -0.0148
0.075 | 0.041 | 0.075 | -0.0174
0.1 | 0.0468 | 0.1 | -0.02 |  | Simpson's Rule:
0.15 | 0.0549 | 0.15 | -0.0246 |  |  | x | f(x) |  | Area approximation for each inteval
0.2 | 0.0606 | 0.2 | -0.0291 |  | n = 10 | 0 |  |  |  |  |  | x | f(x) | multiplier | product of sum
0.25 | 0.0643 | 0.25 | -0.0331 |  |  | 0.2 |  |  |  |  |  | 0 |  | 1
0.3 | 0.0662 | 0.3 | -0.0359 |  |  | 0.4 |  |  |  |  |  | 0.1 |  | 4
0.35 | 0.0678 | 0.35 | -0.0388 |  |  | 0.6 |  |  |  |  |  | 0.2 |  | 2
0.4 | 0.0678 | 0.4 | -0.0402 |  |  | 0.8 |  |  |  |  |  | 0.3 |  | 4
0.45 | 0.0668 | 0.45 | -0.0404 |  |  | 1 |  |  |  |  |  | 0.4 |  | 2
0.5 | 0.0646 | 0.5 | -0.0393 |  |  |  |  |  |  |  |  | 0.5 |  | 4
0.55 | 0.0611 | 0.55 | -0.0371 |  |  |  |  | Total Area: |  |  |  | 0.6 |  | 2
0.6 | 0.0563 | 0.6 | -0.0339 |  |  |  |  |  |  |  |  | 0.7 |  | 4
0.7 | 0.0437 | 0.7 | -0.0257 |  |  |  |  |  |  |  |  | 0.8 |  | 2
0.8 | 0.0291 | 0.8 | -0.0172 |  |  |  |  | [NAME]) |  |  |  | 0.9 |  | 4
0.9 | 0.0145 | 0.9 | -0.0086 |  |  |  |  |  |  |  |  | 1 |  | 1
1 | 0.0008 | 1 | -0.0008
 |  |  |  |  |  | x | f(x) |  | Area Approx |  |  |  | Total Area:
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0.2 |  |  |  |  |  | x | f(x) | multiplier | product of sum
 |  |  |  |  |  | 0.4 |  |  |  |  |  | 0 |  | 1
 |  |  |  |  |  | 0.6 |  |  |  |  |  | 0.1 |  | 4
 |  |  |  |  |  | 0.8 |  |  |  |  |  | 0.2 |  | 2
 |  |  |  |  |  | 1 |  |  |  |  |  | 0.3 |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 0.4 |  | 2
 |  |  |  |  |  |  |  | Total Area: |  |  |  | 0.5 |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 0.6 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 0.7 |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 0.8 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 0.9 |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Area: