tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: john_griffith__16225__2_1_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 20.5 | 160 | 170 | 51.9 | 55.1 | 0.69 | 2002-02-01 14:49:00
 | CL J2 | 20.5 | 265 | 275 | 48 | 49.8 | 0.63 | 2002-02-01 14:49:00
 | CL K2 | 21 | 350 | 365 | 46.5 | 48.5 | 0.63 | 2002-02-01 14:49:00
 | CL M2 | 21 | 395 | 410 | 44.8 | 46.5 | 0.6 | 2002-02-01 14:49:00
 | CL N2 | 21 | 430 | 450 | 42.8 | 44.8 | 0.58 | 2002-02-01 14:49:00
 | CL Q2 | 21 | 465 | 480 | 42 | 43.4 | 0.56 | 2002-02-01 14:49:00
 | CL U2 | 21 | 475 | 490 | 39.8 | 41.1 | 0.53 | 2002-02-01 14:49:00
 | [NAME] | 21 | 490 | 510 | 38.1 | 39.7 | 0.51 | 2002-02-01 14:49:00
 | CL X2 | 21 | 495 | 515 | 36.3 | 37.8 | 0.49 | 2002-02-01 14:49:00
 | [NAME] | 21 | 500 | 520 | 35 | 36.4 | 0.47 | 2002-02-01 14:49:00
 | CL F3 | 21 | 500 | 525 | 33.3 | 35 | 0.45 | 2002-02-01 14:49:00
 | CL G3 | 21 | 505 | 530 | 32.3 | 33.9 | 0.44 | 2002-02-01 14:49:00
 | CL M3 | 21 | 540 | 570 | 30.3 | 32.1 | 0.41 | 2002-02-01 14:49:00
 | CL Z3 | 21 | 540 | 575 | 26.4 | 28.2 | 0.36 | 2002-02-01 14:49:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 676211d1588703118-vlookup-with-wildcard-not-working-deepak
Sheet: Sheet1

 |  | I want Key word (reference table) to lookup Description in Table 1 checking if value either column B or C.
 |  | e.g. Tesco is in two places but is defined by revenue or cost Coolum
TABLE 1:     EXACT NAME |  |  |  |  |  |  |  | REFERENCE
[NAME] | revenue | cost | [NAME] revenue | [NAME] in |  |  |  | KEY | [NAME]
Toolstation |  | 50 |  |  |  |  |  | Toolstation | repairs
Gym Group |  | 60 |  |  |  |  |  | Screwfix | repairs
Tesco |  | 10 |  |  |  |  |  | Gym Group | workout
Screwfix |  | 10 |  |  |  |  |  | Tesco | food
wages Tesco | 5 |  | wages1 |  |  |  |  | wage Tesco | wages1
wages screwfix | 10 |  | wages2 |  |  |  |  | wages screwfix | wages2
Spreadsheet: 676315d1588754947-cannot-get-index-match-formula-to-sum-eus_gah
Sheet: AlmaSource

Course Year | Course Term | Course Name | Number of Participants | Citation Material Type | Title of Journal/Book/Work | Book Chapter or Article Title | Pages | Article Start Page | Article End Page | Num. Pages | Section Name | Citation Public Tags | Number of Citations Views | Number of Files Download | Students that Viewed Citation | Students that Downloaded Files | Students that Viewed Full Text | Publisher | Journal Title | Publication Date | Journal Title | Author | Isbn | ISBN, ISSN, etc | Publisher | Title | Date | Title of Work | Author
2018 | 1 | [NAME] | 1 |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | Current History, Inc. | Current History | 2017 | Current History | Beeson, [NAME] |  | 00113530 | Current History, Inc. | Current History | 2017 | ??? | Beeson, [NAME]
 |  |  | 65 |  | Trump and the Asia-Pacific: do the ties still bind?(Author abstract) |  |  | 235 | 240 | 5 | Week 9 - Core reading |  | 50 | 0 | 30 | 0 | 0 | Current History, Inc. | Current History | 2017 | Current History | Beeson, [NAME] |  | 00113530 | Current History, Inc. | Current History | 2017 | ??? | Beeson, [NAME]
2018 | 2 | [NAME] | 1 |  |  |  |  |  |  |  |  |  | 1 | 0 | 1 | 0 | 0 | Current History, Inc. | Current History | 2017 | Current History | Beeson, [NAME] |  | 00113530 | Current History, Inc. | Current History | 2017 | ??? | Beeson, [NAME]
 |  |  |  |  | Trump and the Asia-Pacific: do the ties still bind?(Author abstract) |  |  | 235 | 240 | 5 | Week 9 - Core reading
Spreadsheet: 862466d1710188249-sumif-changing-criteria-while-copying-down-formula-excel-forum-sum-if-criteria-question
Sheet: Sheet3

BANNER_ID | STUNAME | MAJOR_1 | CLASS
A00773974 | Name, Student1 | BIOL | FR
A00803391 | Name, Student2 | LIBA | JR
A00802565 | Name, Student3 | ACCT | FR
A00818088 | Name, Student4 | SWRK | JR
A00777319 | Name, Student5 | ACCT | SO
A00785654 | Name, Student6 | LIBA | SO
A00786403 | Name, Student7 | LIBA | FR
A00786532 | Name, Student8 | ACCT | FR
A00796646 | Name, Student9 | ACCT | SR
A00786408 | Name, Student10 | LIBA | SO
A00802174 | Name, Student11 | NURS | FR
A00810476 | Name, Student12 | RDSC | FR
A00789788 | Name, Student13 | ACCT | SO
A00554584 | Name, Student14 | NURS | SO
A00665554 | Name, Student15 | ACCT | JR
A00787744 | Name, Student16 | ENGT | FR
A00766881 | Name, Student17 | LIBA | SR
A00497282 | Name, Student18 | CMIT | SR
A00325733 | Name, Student19 | AGRI | FR
A00813403 | Name, Student20 | BIOL | FR
A00805474 | Name, Student21 | AGRI | FR
A00807953 | Name, Student22 | LIBA | FR
[NAME] | Name, Student23 | CRIM | FR
A00795041 | Name, Student24 | MGT | JR
A00806759 | Name, Student25 | AGRI | FR
A00808077 | Name, Student26 | CMMD | FR
A00774585 | Name, Student27 | SWRK | SO
A00768058 | Name, Student28 | CSC | FR
A00812640 | Name, Student29 | MGT | FR
A00802991 | Name, Student30 | CSC | FR
Spreadsheet: 71744d1272481020-creating-a-pivot-table-and-a-chart-file
Sheet: pivot

 |  |  |  |  |  |  | How can I make Chart like this one, with this pivot table? I also don't know how to add "Difference" below "Income" and "Outgoing"
Sum of Cost | Column Labels
Row Labels | 1 | 2 | 3 | 4 | 5 | 6 | Grand Total
Income | 1650000 | 1750000 | 1345000 | 1290000 | 1382000 | 1798500 | 9215500
Outgoing | 920900 | 272500 | 708500 | 1410900 | 1432000 | 302000 | 5046800
Spreadsheet: 168350d1342418179-conditional-format-edited-conditional-format
Sheet: Soution

RANK | RATEE | Assigned To | Date Assigned | Days in your Que | Dates due to Mgt | Days due to CSS | CLOSE OUT
Superintendent | [NAME] | [NAME] | 2012-05-01 00:00:00 |  |  |  | 2012-07-12 00:00:00
[NAME] | [NAME] | [NAME] | 2012-05-20 00:00:00 |  |  |  | 2012-07-25 00:00:00
 | RED | =E3<50
 | YELLOW | =AND(E3>50,E3<=60)
 | GREEN | =E3>60
I ve changed th formula and now condiotnal formula check trhe Day in your que! I think it will solve the problem or ???
So here, I have a [NAME] and a Super…  Foremam:  the report was assined to [NAME] on 20 Jun 2012.  It has been in her que for 25 days.  The report wil close out on 25 August.  So if today's date is 50 days or less then the close out date, the cell will turn red. And for superintendent will turn red if today's date is within 45 days of the closeout date.                   Do we need a cell that has (TODAY) - the Close out date???
 |  |  |  |  |  |  |  | Foreman 50 & 40
 |  |  |  |  |  |  |  | Super 45 & 35
Spreadsheet: 1ab8c2b3-67e3-40ff-8ffd-a02b997a33c9
Sheet: Sheet1

[NAME] | [NAME] | Charter IRN | Charter Name | Charter Closure Status
7991 | Educational Resource Consultants of Ohio | 134288 | East End Comm Heritage School | Required to close by June 30, 2014
862 | 'Buckeye Community Hope Foundation | 143552 | Eagle Academy | At-Risk of closing by June 30, 2015
8316 | Richland Academy | 11985 | Theodore Roosevelt Public Community School | At-Risk of closing by June 30, 2015
83246 | St Aloysius Orphanage | 9957 | Klepinger Community School | At-Risk of closing by June 30, 2015
821 | [NAME] | 133454 | Dayton Leadership Academies-Dayton View Campus | At-Risk of closing by June 30, 2015
Spreadsheet: 95069d1294765295-dates-in-cells-is-it-possible-to-drag-drag-fill
Sheet: Sheet2

 |  | [NAME] | Packs Out | Collections | Packs Back | FMP Out | FMP In | Calls Taken | Calls Out | Attendence | Col % 2 PB | Packs Out 2 PB | FMP'S OUT2IN
2011-01-17 00:00:00 | PG | 7.5 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A
 | SP |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | CM |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | KD |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Daily Total |  | 7.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A | #N/A
2011-01-18 00:00:00 | PG | 7.5 |  |  |  |  |  |  |  |  | #N/A | #N/A
 | SP |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | CM |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | KD |  |  |  |  |  |  |  |  |  | #N/A | #N/A
daily total |  | 7.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A | 0
2011-01-19 00:00:00 | PG | 7.5 |  |  |  |  |  |  |  |  | #N/A | #N/A
 | SP |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | CM |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | KD |  |  |  |  |  |  |  |  |  | #N/A | #N/A
daily total |  | 7.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A | 0
2011-01-20 00:00:00 | PG | 7.5 |  |  |  |  |  |  |  |  | #N/A | #N/A
 | SP |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | CM |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | KD |  |  |  |  |  |  |  |  |  | #N/A | #N/A
daily total |  | 7.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A | 0
2011-01-21 00:00:00 | PG | 7.5 |  |  |  |  |  |  |  |  | #N/A | #N/A
 | SP |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | CM |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | KD |  |  |  |  |  |  |  |  |  | #N/A | #N/A
weekly total |  | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A | #N/A
2011-01-24 00:00:00 | PG | 7.5 |  |  |  |  |  |  |  |  | #N/A | #N/A
 | SP |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | CM |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | KD |  |  |  |  |  |  |  |  |  | #N/A | #N/A
daily total |  | 7.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A | 0
2011-01-25 00:00:00 | PG | 7.5 |  |  |  |  |  |  |  |  | #N/A | #N/A
 | SP |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | CM |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | KD |  |  |  |  |  |  |  |  |  | #N/A | #N/A
daily total |  | 7.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A | 0
2011-01-26 00:00:00 | PG | 7.5 |  |  |  |  |  |  |  |  | #N/A | #N/A
 | SP |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | CM |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | KD |  |  |  |  |  |  |  |  |  | #N/A | #N/A
daily total |  | 7.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A | 0
2011-01-27 00:00:00 | PG | 7.5 |  |  |  |  |  |  |  |  | #N/A | #N/A
 | SP |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | CM |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | KD |  |  |  |  |  |  |  |  |  | #N/A | #N/A
daily total |  | 7.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A | 0
2011-01-28 00:00:00 | PG | 7.5 |  |  |  |  |  |  |  |  | #N/A | #N/A
 | SP |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | CM |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 | KD |  |  |  |  |  |  |  |  |  | #N/A | #N/A
weekly total |  | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A | 0
Spreadsheet: 747073d1631201540-sumifs-with-a-dynamic-criteria-range-based-on-selection-epm-mileage-sample-sheet-ans
Sheet: Dashboard

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Main
 |  |  | Select mileage to process |  |  |  |  |  |  |  |  |  |  | CBSSG
 | Split |  | CBSSG |  |  |  |  |  |  |  |  |  |  | HCC Conc
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BCP Tender
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process5
 | London |  | sumif formula | sumif formula |  |  |  |  |  |  |  |  |  | Process6
 | Southampton |  | sumif formula | sumif formula |  |  |  |  |  |  |  |  |  | Process7
 | Newport |  | sumif formula | sumif formula |  |  |  |  |  |  |  |  |  | Process8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process11
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process12
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process13
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process14
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process16
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process17
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process18
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process19
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process20
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process21
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process22
Spreadsheet: chris_germany__2353__Transco_Doyle_confirms_May_2001
Sheet: external

DOYLE
MAY    2001
 | GAS [NAME] |  |  |  |  |  | PURCHASE |  | TRANSPORT
 |  | PURCHASES |  |  |  |  |  |  | COMMODITY |  | DAILY TRANS
 | DAY AHEAD | RECEIPT | DELIVERY | [NAME] | IMBALANCE |  | STA 85 Gas Daily +0.05 |  | FT | IT @ .1861 | COST
DAY | REQUEST * |  |  |  |  |  |  |  | none for May |  | DEL'd x Comm.
2001-05-01 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-02 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
*   3-May | 4030 | 4250 | 4250 | 4027 |  |  | fixed price del'd $4.90 |  | 0.0306 | 0.1861 | 0
2001-05-04 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-05 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-06 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-07 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-08 00:00:00 | 4500 | 4500 |  | 5683 |  |  |  |  | 0.0306 | 0.1861
2001-05-09 00:00:00 | 10000 | 10000 |  | 6586 |  |  |  |  | 0.0306 | 0.1861
2001-05-10 00:00:00 | 12500 | 10000 |  | 11781 |  |  |  |  | 0.0306 | 0.1861
2001-05-11 00:00:00 | 5250 | 5500 |  | 4859 |  |  |  |  | 0.0306 | 0.1861
2001-05-12 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-13 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-14 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-15 00:00:00 | 0 | 0 |  | 5 |  |  |  |  | 0.0306 | 0.1861
2001-05-16 00:00:00 | 0 | 0 |  | 0 |  |  | fixed price @ Sta 85=$4.40 |  | 0.0306 | 0.1861
*  17-May | 32000 | 32000 |  | 32500 |  |  |  |  | 0.0306 | 0.1861
2001-05-18 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-19 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-20 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-21 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-22 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-23 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-24 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-25 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-26 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-27 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-28 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-29 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-30 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-31 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
 | BOLD DATE = PIPELINE ACTUALS
 | DAY AHEAD REQUEST = "Schedule 8's" total MW x heat rate estimate of 12.1
 | * Interruptible transport restricted for May 1 - 5, gas purchased from ENA at a delivered price at gate.
Spreadsheet: thomas_martin__39667__April 01
Sheet: Sheet1

 |  |  |  |  | April 01 Transportation Rates
 |  |  |  | HSP Minus |  | Deliveries |  |  | Deliveries
 |  | Receipts |  | Supply |  | Trnspt. | Delivered |  | Trnspt. | Delivered
 |  |  |  | Price |  | HSC Loop | Price |  | HSC - Beau | Price
King Ranch, Live Oak |  |  |  | -0.15 |  | 0.13
[NAME] |  |  |  | -0.15 |  | 0.13
[NAME] |  |  |  | -0.12 |  | 0.1
Oasis,Western & PG&E Katy |  |  |  | -0.03 |  | 0.015
Lonestar,Tailgate |  |  |  | -0.03 |  | 0.015
Texoma |  |  |  | -0.07 |  | 0.05
[NAME] |  |  |  | -0.06 |  | 0.025
Enerfin, M. Bluff, Devers, La Porte |  |  |  | -0.05 |  | 0.02
 |  |  |  |  |  | Add $.01 for CP&L
 |  |  |  |  |  | Deliveries
 |  | Receipts |  | Supply |  | Trnspt. | Delivered
 |  |  |  | Price |  | Corpus | Price
[NAME], King |  |  |  |  |  | 0.06
[NAME] |  |  |  |  |  | 0.05
Western & PG&E Katy,Oasis,lonestar,enerfin |  |  |  | 0 |  | 0
Tailgate |  |  |  | 0 |  | 0
[NAME], M. Bluff, Devers, La Porte |  |  |  | 0 |  | 0
Texoma |  |  |  | 0 |  | 0
Spreadsheet: 46322d1245234457-summarising-a-spreadsheet-test
Sheet: May

 |  | Number of Visits
 | Depot #1
 | Valve & Penstock Inspection | 1
 | Bridge/Debris runs | 1
 | Grasscutting (Floodbanks) | 1
 | Major Assets-Shardlow Pumping Station | 4
 | Major [NAME] | 4
 | Depot #2
 | Valve & Penstock Inspection | 1
 | Bridge/Debris runs | 1
 | Grasscutting (Floodbanks) | 1
 | Depot #3
 | Valve & Penstock Inspection | 1
 | Bridge/Debris runs | 1
 | Grasscutting | 1
 | Depot #4
 | Valve Inspection | 1
 | Bridge/Debris runs | 1
 | Grasscutting | 1
 | Depot #5
 | Valve & Penstock Inspection | 1
 | Bridge/Debris runs | 1
 | Grasscutting | 1
 | Depot #6
 | Valve & Penstock Inspection | 1
 | Bridge/Debris runs | 1
 | Grasscutting | 1
 | Major Asset - Pumping Station | 1
 | Depot #7
 | Valve & Penstock Inspection | 1
 | Bridge/Debris runs | 1
 | Grasscutting | 1
 | Depot #8
 | Valve & Penstock Inspection | 1
 | Bridge/Debris runs | 1
 | Grasscutting | 1
 | Major Asset - Pumping Station | 1
Spreadsheet: daren_farmer__5853__Entex99Recap
Sheet: Sheet1

ENTEX TRANSACTION
 |  |  |  |  |  |  |  | Released |  | Net Original Value |  | PV As of
 | Description | 7-Year Value |  | 1-Year Value |  | TOTAL |  | To Earnings |  | Remaining |  | 5/8/00**
RESERVES:
 | Desk Management Fee (including Reduction of "Call Value") | 30277372 |  | 3177135 |  |  |  | -9285786 |  |  |  | 19549860
 | Regulatory Reserve | 6658324 |  | 0 |  |  |  | -6658324 |  |  |  | 0
 | Underburn (Volumetric Reserve) | 3228960 |  | 0 |  |  |  | 0 |  |  |  | 3221921
 | Gas Daily Call (Cap) Premium | 2867370 |  | 0 |  |  |  | 0 |  |  |  | 2385169
 | Interest Rate Reserve/55 Day Discounting Reserve | 1550000 |  | 0 |  |  |  | -1550000 |  |  |  | 0
 | Industrial Discount Reserve | 0 |  | 1000000 |  |  |  | -1000000 |  |  |  | 0
OTHER VALUE FROM DEALS:
 | Origination - East Origination Team | 14500000 |  | 5710026 |  |  |  |  |  | 0 |  | 0
 | Origination - Middle Market Texas | 15500000 |  | 0 |  |  |  |  |  | 0 |  | 0
 | To Reimburse for Underburn in Winter '98 - '99 | 0 |  | 5723922 |  |  |  | -5723922 |  | 0 |  | 0
 | Miscellaneous | -2169316 |  | 147714 |  |  |  | 2021602 |  | 0 |  | 0
 | TOTAL VALUE
**  Remaining PV value is net of the first contract year liquidation.
Spreadsheet: sally_beck__33697__Metrics 0609
Sheet: CTG Assets

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | CTG Assets
Results based on Activity through June 9, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 10
 |  | Weekly Summary - 2Q00 through 1Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-04-07 00:00:00 | 2000-04-14 00:00:00 | 2000-04-21 00:00:00 | 2000-04-28 00:00:00 | 2000-05-05 00:00:00 | 2000-05-12 00:00:00 | 2000-05-19 00:00:00 | 2000-05-26 00:00:00 | 2000-06-02 00:00:00 | 2000-06-09 00:00:00 | 2000-06-16 00:00:00 | 2000-06-23 00:00:00 | 2000-06-30 00:00:00
Postings Rollforward:
Beginning |  | 0
+ Entrances |  | 0 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Exits |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Executions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
Ending
 | Dollar Value of Transactions
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |  | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Average
Postings Rollforward:
Beginning |  | 100.5
+ Entrances |  | 0 | 14.3 | 1
- Exits |  | 0 | 0 | 0
+/- [NAME] |  | 0 | 0 | -13
- Executions |  | 0 | 0 | 0
Ending
Average Deal Size
 |  |  |  |  |  |  |  | Forward Quarters
 | Actual |  |  | Current Quarter |  | Per |  |  |  |  |  |  |  | Total Year
 | 1Q00 |  |  | 2Q00 |  | Hot List |  | 3Q00 |  |  | 4Q00 |  |  | 2000 |  |  | 1Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions | 1 | 1.4 |  | 1 | -0.17 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0
DPR/MPR |  | -2 |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0
Postings | 0 | 0 |  | 5 | 0 |  |  | 8 | 1 |  | 3 | 0 |  |  |  |  | 0 | 0
Identified Margin
Budget |  |  |  |  | 14.7 |  |  |  | 2.4 |  |  | 2.4 |  |  |  |  |  | 6.7
$ Coverage
$ millions
Spreadsheet: eric_saibi__9936__103101R
Sheet: Ravenswood 01

Owner Name |  | KeySpan Energy
Station Name |  | Ravenswood Power Station
Unit Name |  | Unit 1
NERC Region |  | NPCC
State |  | NY
Fuel Type |  | Natural Gas
Capacity |  | 400 MW
Start Date |  | 2001-10-05 00:00:00
End Date |  | 2001-12-16 00:00:00
Prv. Start Date |  | 2001-10-05 00:00:00
Prv. End Date |  | 2001-10-31 00:00:00
Comments
SIC |  | 4931
Plant ID |  | 1516826
Unit ID |  | 1004328
Outage ID |  | 18595
Spreadsheet: 29bbecf8-5e99-4f4d-a57d-962e90ef8830
Sheet: Sheet1

2010-2011  Data Validation Monitoring (DVM) System for Student Leaver Records Continuous Improvement Plan (CIP)/Corrective Action Plan (CAP) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
[NAME]: |  |  | CDN: |  | Date:
Indicator Description | Data Area Targeted | System Targets | Components | Corrective Actions/Improvement Activities  (See tab tiled "Considerations for CIP_CAP") | Start Date | Projected Completion Date | Resources Required and Person(s) Responsible | Evidence of Implementation | Evidence of Impact
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
select | select | select | select
Spreadsheet: daren_farmer__5318__Enron Nom Change
Sheet: Sheet1

To:   [NAME]          (Enron) |  |  |  |  |  | Phone: | (713) 853-9272
From:  Jan Svajian      ([NAME]) |  |  |  |  |  | FAX: | (713) 646-2391
Date:  6/21/00 |  |  |  |  |  | E-Mail: | [EMAIL]
Subject:  Nomination Change Effective June 22nd
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | DBQ Available | Excess Available | First of the month original nomination |  | Pipeline affected
2000-06-22 00:00:00 | [NAME] 91 | 1 | 1 | 0 | 78 |  | TETCO
2000-06-27 00:00:00 | [NAME] 91 | 78 | 72 | 6 | 78 |  | TETCO
This well will be down June 22nd and brought back on line June 27th.
xc:  [NAME]
Phone: | [PHONE]
Fax: | [PHONE]
Spreadsheet: d02bb966-7544-47e3-b272-331daae3e8cd
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
264627 | 79505 | Christos | Xitas | GRE |  | 00:50:46 | 00:09:04 | 00:52:44 | 00:02:20 | 00:52:16 | 1 | 02:47:13
Spreadsheet: 670359d1585842102-getting-rid-of-divide-by-zero-errors-test-trial_2
Sheet: Sheet1

 |  | 3" | 4" | 5" | 6" | 7" | 8" | 9" |  | 3" | 4" | 5" | 6" | 7" | 8" | 9"
 | qty | 12 | 3 | 0 | 3 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 20 | 0 | 0
 |  | 15 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 10 | 2
 |  | 0 | 0 | 0 | 33 | 0 | 0 | 0
 |  | These are the qty of each size |  |  |  |  |  |  |  | This is comparison of each size in relation to one another but when there is only one size
 |  |  |  |  |  |  |  |  |  | on an order you divide by zero which gives an error. I tried sumif but when I split the sum such as =F7/SUM(C7:E7,G7:I7)
 |  |  |  |  |  |  |  |  |  | the comma ruins the formula because it thinks its moving to the next part of the sumif operation
 |  |  |  |  |  |  |  |  |  |  | ?? | ?? | ?? | ?? | ?? | ??
 |  |  |  |  |  |  |  |  |  |  | ?? | ?? | ?? | ?? | ?? | ??
 |  | =C5/IF(SUM(D5:I5)=0,1,SUM(D5:I5)) |  |  |  |  |  |  |  |  | ?? | ?? | ?? | ?? | ?? | ??
 |  |  |  |  |  |  |  |  |  |  | ?? | ?? | ?? | ?? | ?? | ??
 |  |  |  |  |  |  |  |  |  |  | ?? | ?? | ?? | ?? | ?? | ??
 |  |  |  |  |  |  |  |  |  |  | ?? | ?? | ?? | ?? | ?? | ??
 |  |  |  |  |  |  |  |  |  |  | ?? | ?? | ?? | ?? | ?? | ??
 |  | =IFERROR(C5/SUM(D5:I5),C5) |  |  |  |  |  |  |  |  | ?? | ?? | ?? | ?? | ?? | ??
 |  |  |  |  |  |  |  |  |  |  | ?? | ?? | ?? | ?? | ?? | ??
 |  |  |  |  |  |  |  |  |  |  | ?? | ?? | ?? | ?? | ?? | ??
 |  |  |  |  |  |  |  |  |  |  | ?? | ?? | ?? | ?? | ?? | ??
 |  |  |  |  |  |  |  |  |  |  | ?? | ?? | ?? | ?? | ?? | ??
 |  | =IFERROR(C5/(SUM($C5:$I5)-C5),0) |  |  |  |  |  |  |  |  | ?? | ?? | ?? | ?? | ?? | ??
 |  |  |  |  |  |  |  |  |  |  | ?? | ?? | ?? | ?? | ?? | ??
 |  |  |  |  |  |  |  |  |  |  | ?? | ?? | ?? | ?? | ?? | ??