tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 374068d1422642216-updating-average-function-not-pivot-table-average-update
Sheet: Sheet1

 | Patients visits to health Centers
 |  |  | Children |  | Pregnant |  | Adults
 |  |  | Total |  | Total |  | Total
 | 2015-01-01 00:00:00 |  | * |  | * |  | * |  | Average Patients visits per day ?
 | 2015-01-02 00:00:00 |  | * |  | * |  | * |  | Average would be daily updated according
 | 2015-01-03 00:00:00 |  | * |  | * |  | * |  | to daily new data entry
 | 2015-01-04 00:00:00 |  | 28 |  | 14 |  | 9
 | 2015-01-05 00:00:00 |  | 12 |  | 12 |  | 8
 | 2015-01-06 00:00:00 |  | 22 |  | 1 |  | 2
 | 2015-01-07 00:00:00 |  | * |  | * |  | *
 | 2015-01-08 00:00:00 |  | 24 |  | 6 |  | 11
 | 2015-01-09 00:00:00
 | 2015-01-10 00:00:00 |  | 13 |  | 2 |  | 5
 | 2015-01-11 00:00:00 |  | 10 |  | 3 |  | 6
 | 2015-01-12 00:00:00 |  | 24 |  | 16 |  | 13
 | 2015-01-13 00:00:00 |  | 21 |  | 9 |  | 5
 | 2015-01-14 00:00:00 |  | 15 |  | 16 |  | 9
 | 2015-01-15 00:00:00 |  | 15 |  | 15 |  | 6
 | 2015-01-16 00:00:00
 | 2015-01-17 00:00:00 |  | 20 |  | 13 |  | 6
 | 2015-01-18 00:00:00 |  | 17 |  | 18 |  | 7
 | 2015-01-19 00:00:00 |  | 12 |  | 20 |  | 4
 | 2015-01-20 00:00:00 |  | 12 |  | 18 |  | 7
 | 2015-01-21 00:00:00 |  | 14 |  | 14 |  | 11
 | 2015-01-22 00:00:00 |  | 17 |  | 15 |  | 8
 | 2015-01-23 00:00:00
 | 2015-01-24 00:00:00 |  | 16 |  | 22 |  | 7
 | 2015-01-25 00:00:00 |  | 16 |  | 20 |  | 9
 | 2015-01-26 00:00:00
 | 2015-01-27 00:00:00
 | 2015-01-28 00:00:00
 | 2015-01-29 00:00:00
 | 2015-01-30 00:00:00
 | 2015-01-31 00:00:00
 | Total
Spreadsheet: 488543d1478708064-dynamic-range-in-chart-error-dynamic-range-error-in-chart
Sheet: x

Sales | 0 | 0.03333333333333333 | 0.06666666666666667 | 0.1 | 0.1166666666666667 | 0.1333333333333333 | 0.15 | 0.1666666666666667 | 0.1833333333333333 | 0.2 | 0.2333333333333333 | 0.2666666666666667 | 0.3 | 0.3333333333333334 | 0.3666666666666667 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6 | 0.6499999999999999 | 0.7 | 0.7333333333333333 | 0.7666666666666666 | 0.8 | 0.8333333333333334 | 0.8666666666666667 | 0.9 | 0.85 | 0.8 | 0.75 | 0.7 | 0.65 | 0.6 | 0.5666666666666667 | 0.5333333333333333 | 0.5 | 0.4666666666666667 | 0.4333333333333333 | 0.4 | 0.3833333333333334 | 0.3666666666666667 | 0.35 | 0.3333333333333333 | 0.3166666666666667 | 0.3 | 0.3166666666666667 | 0.3333333333333333 | 0.35 | 0.3666666666666667 | 0.3833333333333334 | 0.4 | 0.4666666666666667 | 0.5333333333333333 | 0.6000000000000001 | 0.6666666666666667 | 0.7333333333333334 | 0.8 | 0.8333333333333334 | 0.8666666666666667 | 0.9 | 0.9333333333333333 | 0.9666666666666667 | 1 | 0.95 | 0.9 | 0.85 | 0.7999999999999999 | 0.75 | 0.7 | 0.6333333333333333 | 0.5666666666666667 | 0.5 | 0.4333333333333333 | 0.3666666666666666 | 0.3 | 0.2833333333333333 | 0.2666666666666667 | 0.25 | 0.2333333333333333 | 0.2166666666666667 | 0.2 | 0.1333333333333333 | 0.06666666666666667 | 0
X Axis | 08:00:00 | 08:10:00 | 08:20:00 | 08:30:00 | 08:40:00 | 08:50:00 | 09:00:00 | 09:10:00 | 09:20:00 | 09:30:00 | 09:40:00 | 09:50:00 | 10:00:00 | 10:10:00 | 10:20:00 | 10:30:00 | 10:40:00 | 10:50:00 | 11:00:00 | 11:10:00 | 11:20:00 | 11:30:00 | 11:40:00 | 11:50:00 | 12:00:00 | 12:10:00 | 12:20:00 | 12:30:00 | 12:40:00 | 12:50:00 | 13:00:00 | 13:10:00 | 13:20:00 | 13:30:00 | 13:40:00 | 13:50:00 | 14:00:00 | 14:10:00 | 14:20:00 | 14:30:00 | 14:40:00 | 14:50:00 | 15:00:00 | 15:10:00 | 15:20:00 | 15:30:00 | 15:40:00 | 15:50:00 | 16:00:00 | 16:10:00 | 16:20:00 | 16:30:00 | 16:40:00 | 16:50:00 | 17:00:00 | 17:10:00 | 17:20:00 | 17:30:00 | 17:40:00 | 17:50:00 | 18:00:00 | 18:10:00 | 18:20:00 | 18:30:00 | 18:40:00 | 18:50:00 | 19:00:00 | 19:10:00 | 19:20:00 | 19:30:00 | 19:40:00 | 19:50:00 | 20:00:00 | 20:10:00 | 20:20:00 | 20:30:00 | 20:40:00 | 20:50:00 | 21:00:00 | 21:10:00 | 21:20:00 | 21:30:00 | 21:40:00 | 21:50:00 | 22:00:00
Sum using OFFSET: |  |  |  |  |  | If I try to replace the series values of sales with any of the ranges (formula or defined name, offset or indirect) it gives me an error. Any ideas why?
Sum using INDIRECT: |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales_Offset |  |  | =OFFSET(Sheets1!$B$22,0,0,1,COUNTA(Sheets1!$22:$22)-1)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | X_Axis |  |  | =OFFSET(Sales_Offset,1,0)
Sum using defined names:
Spreadsheet: darrell_schoolcraft__7759__DukeTW WT1
Sheet: DukeTW WT-1

Transwestern  Interconnect  Information
Revision Number |  | POI Date:
 |  | Current Date:
Legal Entity Number |  | Interconnect Name: | TW/DUKE ENERGY WT1 REC.
Physical Operator: | Transwestern | County: | [NAME]
Business Operator: |  | State: | New Mexico
[NAME]: | Transwestern | Individual Contact | [NAME]
Location: | Sec. 31, T20S, R32E | Contact Phone | [PHONE]
FNL/FEL |  | ACTION REQUESTED
I/D Date: | 2001-06-06 00:00:00 | FAS |  | 311 Facilities
Area: | West Texas | Valid for Transport | Y | Physical Indicator
Dedicated Ownership: |  | Receipt or Delivery | R | LDC to lay line
Dedicated Interest: |  | Survey | N | LDC to install meter
[NAME] Vol(Mmcf/d): | 60 mmcf | TW - Tap w/Valve | N | EFM
Est. Pressure (S.I.P.) | 650 | TW - Meter |  | Use existing tap & meter
Zone |  | Instruments |  | Survey
Remarks:
 | 30 days at 5 mmcfd, W/2470 CPU
 | Duke to install
 | Bristal, Del Mar, Conn H20, [NAME]
By:
FACILITIES |  | Meas. Section/Segment
Est. Tie-in Date: | 2001-06-06 00:00:00 | Tie Into: |  | NMBW121
Size of Gathering Line: | TW old 8" Crawford line | Capacity |  | 60 mmcfd
Length of Gathering Line: | 23.5 miles NMBW121A | POI Type
Operating Pressure: | 625-650 | Elevation |  | 3500
[NAME]: | WT-1 | Lat. Name & Number |  | 24" suction WT-1
Field Contact: | [NAME] at Duke | [NAME] Number |  | T-14 Alignment sheet
Remarks:
 | 8 " orifice wGFC
By:
 | TW Costs |  |  | Reimbursable
Total Estimated Costs:
Remarks:
CONNECT REQUEST
Station Name |  | Basis of Measurements
Station Number | 10186 | Pressure Base |  | 14.73
POI Number | 78169 | Temperature Base |  | 60 deg F
Work Order No. | C014668 | Barometric Pressure |  | 12.95
Remarks:
Contract Terms:
Contract No.
Spreadsheet: 714711d1611333917-help-with-commission-calculations-question
Sheet: Sheet1

customer | SP | stock# | Date | Type | PROFIT | COMMISSION | NET INCOME
kluger shimon | YK | 884230 | 2021-01-25 00:00:00 | A | 3400
[NAME] | YK | 86359 | 2021-01-27 00:00:00 | B | 860
Profit – 150
If [NAME]  less than $1500  35%  , anything higher than 1500 is 50%
If [NAME]  less than $1500  25%  , anything higher than 1500 is 40%
Spreadsheet: 751916d1634434414-solved-cell-count-according-to-whether-it-is-a-working-day-or-a-day-off-grafik_gw_reva
Sheet: January

 |  |  |  |  | YEAR |  |  | 2021 |  |  | MONTH |  |  | 1
№ | NAME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | number of cells in red  when it is a day off | number of cells in red when  it is a working day
 |  | almond | kiwi |  | [NAME] | redcurrant
 |  |  | redcurrant |  |  | blueberry
 |  |  | apricot
 |  | Red?
 | almond | y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOLIDAYS
 | apple |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-01-01 00:00:00
 | apricot |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-03-03 00:00:00
 | banana |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-30 00:00:00
 | blueberry
 | fruit
 | grape
 | kiwi | y
 | lemon
 | mandarin
 | nectarine
 | watermelon
 | quince
 | [NAME] | y
 | redcurrant | y
 | papaya
 | fruits
 | fig
Spreadsheet: 143531d1330451842-excel-2007-creating-dynamic-formulas-based-on-selections-in-one-sheet-with-data-from-another-rf17_1110
Sheet: RF17_Summary_Certification

LDSS-4975 (rev. 10/11)
MONTHLY STATEMENT OF SPECIAL PROJECT CLAIMS FEDERAL AND STATE AID (RF-17)
EXPENDITURES | TOTAL | FEDERAL SHARE | STATE SHARE | LOCAL SHARE
 | RF-17 wksh (Lines 15 + 21) | RF-17 wksh (Lines 17 + 22) | RF-17 wksh (Line 20) | RF-17 wksh (Line 24)
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
Grand Total | 0 | 0 | 0 | 0
Spreadsheet: 793664d1661618746-lookup-value-and-return-corresponding-cell-range-help-6-aligw
Sheet: Sheet1

 | Source data
23 | 38 | 54 | 78 | 82
66463 | 66863 | 67063 | 66764 | 67053
Case-1 |  |  | Case-2
Enter value | 54 |  | If input value | 79
requirement: |  |  | requirement:
 | 66863 |  |  | 66863
 | 67063 |  |  | 67063
 |  |  |  | 66764
Spreadsheet: 469635d1468009687-conditionally-give-a-value-to-a-cell-contain-operator-copy-of-case
Sheet: Feuil1

NOME | COLIGACAO | PT | PP | PDT | PSDB | PRTB | PSB | PR | PTB | PROS | PMDB | DEM | PPS | PRB | SD | PSL | PEN | PT DO B | PSC | PTN | PSOL | PSDC | PV | PSOL | PRB | PDT | PRP | PSD | PEN | PMDB | PPS | PSC | PRB | PPL | PDT | PT | PRB | DEM | PP | PSL | PSDC | PTB | SD | PT DO B | PT | PSB | PSD | PTC | PMN | PR | PSDB | PMN | PRP | PV | PSDC | PSD | PSTU | SD | PPL | PTN | PROS | PSL | PRTB | PC DO B | PHS | PROS | PC DO B | PMDB | PSOL | PCDOB | PRTB | PDT | DEM | PCDOB | PTC | PPS | PTN | PR | PEN | PSDB | PT DO B | PTB | PSB | PSC | PTDOB | PV | PHS | SEM COLIGACAO | (CASSADO) PP
RAIMUNDO ANGELIM | PT / PEN / PROS / PDT / PTB / PSL / PTN / PSDC / PHS / PSB / PRP / PPL / PRB / PCDOB
CESAR MESSIAS | PT / PEN / PROS / PDT / PTB / PSL / PTN / PSDC / PHS / PSB / PRP / PPL / PRB / PCDOB
MAJOR ROCHA | PP / PMDB / PSC / PR / PPS / PTC / PSDB / PSD / PTDOB / SD
LEO DE BRITO | PT / PEN / PROS / PDT / PTB / PSL / PTN / PSDC / PHS / PSB / PRP / PPL / PRB / PCDOB
JESSICA SALES | PP / PMDB / PSC / PR / PPS / PTC / PSDB / PSD / PTDOB / SD
SIBA MACHADO | PT / PEN / PROS / PDT / PTB / PSL / PTN / PSDC / PHS / PSB / PRP / PPL / PRB / PCDOB
FLAVIANO MELO | PP / PMDB / PSC / PR / PPS / PTC / PSDB / PSD / PTDOB / SD
[NAME] | PT / PEN / PROS / PDT / PTB / PSL / PTN / PSDC / PHS / PSB / PRP / PPL / PRB / PCDOB
JHC | PP / PPS / PSDC / PRP / PR / PSL / PSB / SD / DEM
[NAME] | PDT / PSC / PMDB / PV / PTB / PSD / PT DO B / PROS / PCDOB / PT / PHS
PEDRO VILELA | PSDB / PRB
ARTHUR LIRA | PP / PPS / PSDC / PRP / PR / PSL / PSB / SD / DEM
RONALDO LESSA | PDT / PSC / PMDB / PV / PTB / PSD / PT DO B / PROS / PCDOB / PT / PHS
GIVALDO CARIMBAO | PDT / PSC / PMDB / PV / PTB / PSD / PT DO B / PROS / PCDOB / PT / PHS
NIVALDO ALBUQUERQUE | PP / PPS / PSDC / PRP / PR / PSL / PSB / SD / DEM
VAL AMELIO | PRTB / PPL / PMN
PAULAO | PDT / PSC / PMDB / PV / PTB / PSD / PTDOB / PROS / PCDOB / PT / PHS
ROBERTO GOES | PP / PDT / PMDB
JANETE CAPIBERIBE | PSB / PT / PSOL / PCDOB
CABUCU BORGES | PP / PDT / PMDB
VINICIUS GURGEL | PR / PRB / PHS / PROS / PSDC / PEN / PV / PT DO B
PROFESSORA MARCIVANIA | PSB / PT / PSOL / PCDOB
ANDRE ABDON | PR / PRB / PHS / PROS / PSDC / PEN / PV / PT DO B
MARCOS REATEGUI | PTB / PSC / PPS / PRTB / PMN / PTC / PRP / PPL
JOZI ARAUJO | PTB / PSC / PPS / PRTB / PMN / PTC / PRP / PPL
ARTHUR BISNETO | PROS / DEM / PSDB / PR / PTN / PSC / PT DO B / PTC / PRTB / PEN / PV / PHS / PSL / PSD / SD
SILAS CAMARA | PROS / DEM / PSDB / PR / PTN / PSC / PT DO B / PTC / PRTB / PEN / PV / PHS / PSL / PSD / SD
ALFREDO NASCIMENTO | PROS / DEM / PSDB / PR / PTN / PSC / PT DO B / PTC / PRTB / PEN / PV / PHS / PSL / PSD / SD
MARCOS ROTTA | PMDB / PP / PT / PDT / PTB / PPS / PRB / PSDC / PPL / PC DO B
Spreadsheet: chris_germany__2129__FebCohCHOICE-ENA
Sheet: Feb 12

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-02-12 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | Upstream K# | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 989 |  | 732 |  | 67694 |  |  |  |  |  |  | 33 | 1 | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | 2 | 38
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 7278 |  | 5465 |  | 67694 |  |  |  |  |  |  | 34 | 3 | 37
 |  |  |  |  |  |  |  |  | 3000 |  | 3000 |  | 68918 | 103722 | 0 |  |  |  |  | 31 | 4 | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | 5 | 40
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2060 |  | 1692 |  | 67694 |  |  |  |  |  |  | 37 | 6 | 39
 |  |  |  |  |  |  |  |  | 2000 |  | 2000 |  | 68915 | 103722 | 0 |  |  |  |  | 33 | 7 | 36
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69148 |  | 0 |  |  |  |  | 38 | 8 | 41
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0 |  |  |  |  | 36 | 9 | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 | 15 | 47
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 14437 |  | 13806 |  | 67694 |  |  |  |  |  |  | 34 | 35 | 42
 |  |  |  |  |  |  |  |  | 25 |  | 25 |  | 68917 | 103722 | 0 |  |  |  |  | 31 | 39 | 38
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69149 |  | 0
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1563 |  | 1274 |  | 67694 |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1523 |  | 987 |  | 67694 |  |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 68916 | 103722 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 10857 |  | 9667 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 2984 |  | 2774 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 2659 |  | 2318 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 4470 |  | 3768 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 924 |  | 314 |  | 67694
 |  |  |  |  |  |  |  |  | 257 |  | 257 |  | 69708 | 53858 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 53858 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 37 |  | 30 |  | 67694 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20606 | FOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21066 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: larry_campbell__21312__LFC0700V1
Sheet: BUG-PGE E

Pipeline | Status | ProdYear | ProdMonth | LDCMeter | ReadDate | ReadUnit | Quantity | BillFrom | BillTo | BTU |  | CustomerName
BUG | E | 2000 | 7 | MERCURY |  | dth | 3534 | 2000-07-01 00:00:00 | 2000-07-31 00:00:00 |  |  | PG&E ENERGY SERVICES END USERS
Spreadsheet: 670059d1585739084-excel-to-sql-script-exceltosqlscriptsample
Sheet: Sheet1

2229207 | 13824721 | 2020-03-27 00:00:00.000 | 2020-03-27 00:00:00.000 | [NAME] | [NAME] | [NAME] |  | NULL |  | 80007970 | [NAME] | 0520 | 3 | CA | 01 | 01 | H5 | 2018-02-23 00:00:00.000 | 2020-03-23 00:00:00.000 | 1000 | [PHONE] | [NAME] | 10000028 | A | NULL | 80007970 | DL | [NAME] | 17803781 | [NAME] |  |  |  |  |  | 135 | [NAME]
2148402 | 14149839 | 2020-03-27 00:00:00.000 | 2020-03-27 00:00:00.000 | Lewis | Ffion | Bailey |  | NULL |  | 80007970 | [NAME] | 0520 | 3 | CA | 01 | 01 | H5 | 2018-01-08 00:00:00.000 | 2020-03-24 00:00:00.000 | 1000 | 10000304 | [NAME] | 10000022 | A | NULL | 80007970 | DL | [NAME] | 24436695 | [NAME] |  |  |  |  |  | 135 | [NAME]
Spreadsheet: 97439d1296606344-loan-schedule-when-i-know-the-monthly-payment-amount-loan-balance-repayment
Sheet: Mortgage Amortisation

 | Loan Balance Repayment
 | Inputs |  |  |  |  | Key Figures
 | Loan principal amount |  |  | 50000 |  | Annual loan payments
 | Annual interest rate |  |  | 0.18 |  | Monthly payments
 | Loan period in years |  |  | 1 |  | Interest in first calendar year
 | Base year of loan |  |  | 2011 |  | Interest over term of loan
 | Base month of loan |  |  |  |  | Final Payment
 | Monthly Payment |  |  | 500
 | Payments in First 12 Months
 | Year | Month | Start Balance | Payment |  | Interest |  | Cumulative Interest | End Balance
 |  |  |  |  |  |  |  |  |  |  |  | DO NOT ERASE
 |  |  |  |  |  |  |  |  |  |  |  | 1 | Jan |  |  | Jan
 |  |  |  |  |  |  |  |  |  |  |  | 2 | Feb |  |  | Feb
 |  |  |  |  |  |  |  |  |  |  |  | 3 | Mar |  |  | Mar
 |  |  |  |  |  |  |  |  |  |  |  | 4 | Apr |  |  | Apr
 |  |  |  |  |  |  |  |  |  |  |  | 5 | May |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  | 6 | Jun |  |  | Jun
 |  |  |  |  |  |  |  |  |  |  |  | 7 | Jul |  |  | Jul
 |  |  |  |  |  |  |  |  |  |  |  | 8 | Aug |  |  | Aug
 |  |  |  |  |  |  |  |  |  |  |  | 9 | Sep |  |  | Sep
 |  |  |  |  |  |  |  |  |  |  |  | 10 | Oct |  |  | Oct
 |  |  |  |  |  |  |  |  |  |  |  | 11 | Nov |  |  | Nov
 |  |  |  |  |  |  |  |  |  |  |  | 12 | Dec |  |  | Dec
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Months
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Base Year
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Years
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last Year
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mos in Last Yr
Spreadsheet: 692259d1598239359-use-min-and-max-excluding-top-and-bottom-values-average_of_table
Sheet: Average min max- ignoring top 

FORMULA - IGNORE THE BOTTOM TWO VALUES AND GET AVERAGE
=(SUM(A10:A14)-SMALL(A10:A14,1)-SMALL(A10:[NAME]:A20)-2)
ARRAY FORMULA - IGNORE THE BOTTOM TWO VALUES AND GET AVERAGE | Column1
=AVERAGE(IF(A10:A14>SMALL(A10:A20,2),A10:A20))
0.1251699910840994
0.1535449997263535
0.1889925085697778
0.1950451246874145
0.01
0.2043939445462139
0.2060076503643486
0.2085314595478486
0.2163629343915396
0.2172664427638858
0.233040586378616
ARRAY FORMULA - IGNORE THE BOTTOM20% of VALUES AND GET  maximum of a range
use  average  if  & count  function =MAX(IF(A26:A35<LARGE(A26:A35,COUNT(A26:A35)*0.2),A26:A35,0)) |  |  |  | X
12 |  | [NAME] | X
175 |  |  | X
76 |  | Min | X
4 |  |  | X
17 |  |  | X
21 |  |  | X
55 |  |  | X
15 |  |  | X
25 |  |  | X
29 |  |  | X
ARRAY FORMULA - IGNORE THE BOTTOM20% IN A CONDITIONAL RANGE of VALUES AND GET MINIMUM OF TRUNCATED RANGE |  |  | X
use  average  if  & count  function =MAX(IF(A26:A35<LARGE(A26:A35,COUNT(A26:A35)*0.2),A26:A35,0))
9 | X
34 | X
1 | X
17 | X
12 | X
13 | X
7 | X
1211 | X
121 | Y
11 | Y
56 | X
11 | X
Spreadsheet: 8f604f6d-5102-4d29-b9a1-1e71fba043a7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5957 | 45536 | Maria Cleonice | Baracho | BRA | 0 | 01:29:22 | 00:00:00 | 02:55:11 | 00:00:00 | 01:54:01 | 1 | 06:18:34
Spreadsheet: 01727a8d-cf9a-4aaa-86e1-7d564f3d11ea
Sheet: Sheet1

Undergraduate Majors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Adult Education (Includes Aboriginal Adult Education)
Study Year | Major | 1999-00 | 2000-01 | 2002-03 | 2003-04 | 2004-05 | 2005-06 | 2006-07 | 2007-08
 | Single | 18 | 38 | 115 | 117 | 142 | 129 | 110 | 126
 | Combined | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Year I | Sub-Total: | 18 | 38 | 115 | 117 | 142 | 129 | 110 | 126
 | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total: | 18 | 38 | 115 | 117 | 142 | 129 | 110 | 126
 | Single | 20 | 50 | 105 | 127 | 114 | 112 | 122 | 109
 | Combined | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Year II | Sub-Total: | 20 | 50 | 105 | 127 | 114 | 112 | 122 | 109
 | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total: | 20 | 50 | 105 | 127 | 114 | 112 | 122 | 109
 | Single | 85 | 102 | 257 | 302 | 301 | 243 | 254 | 226
 | Combined | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Year III | Sub-Total: | 85 | 102 | 257 | 302 | 301 | 243 | 254 | 226
 | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total: | 85 | 102 | 257 | 302 | 301 | 243 | 254 | 226
 | Single | 0 | 2 | 6 | 5 | 1 | 1 | 0 | 1
 | Combined | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Year IV | Sub-Total: | 0 | 2 | 6 | 5 | 1 | 1 | 0 | 1
 | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total: | 0 | 2 | 6 | 5 | 1 | 1 | 0 | 1
 | Single | 123 | 192 | 483 | 551 | 558 | 485 | 486 | 462
 | Combined | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL: | Sub-Total: | 123 | 192 | 483 | 551 | 558 | 485 | 486 | 462
 | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total: | 123 | 192 | 483 | 551 | 558 | 485 | 486 | 462
Male |  | 43 | 65 | 130 | 163 | 179 | 143 | 134 | 128
Female |  | 80 | 127 | 353 | 388 | 379 | 342 | 352 | 334
Full-Time |  | 11 | 12 | 19 | 27 | 32 | 30 | 26 | 19
Part-Time |  | 112 | 180 | 464 | 524 | 526 | 455 | 460 | 443
Codes: | ADAB, ADAC, ADEC, ADED, ADGN, ADSB, ENPC
Spreadsheet: mary_fischer__25620__77M
Sheet: E15.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  077M
COMPANY NAME    MEP Services, Inc.
ANALYSIS OF MINORITY INTERESTS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  | E-15
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  | AMOUNT |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | ENRON'S |  | BALANCE |  | PER INCOME |  | OTHER |  |  |  | BALANCE
 |  | OWNERSHIP % |  | DR. (CR.) |  | STATEMENT |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Minority Interest | * |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0855  DR/(CR)
Spreadsheet: 185786d1349836572-sorting-non-empty-cells-to-bottom-schedule-example
Sheet: 6

2200-0000 |  |  | 0000-0200 |  |  | 0200-0400 |  |  | 0400-0600 |  |  | THURSDAY
CHRISTY |  |  | CHRISTY |  |  | CHRISTY |  |  | CHRISTY
[NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
STEPHANIE |  |  | STEPHANIE |  |  | STEPHANIE |  |  | STEPHANIE
ANGELA H |  |  | ANGELA H |  |  | DEBBIE |  |  | DEBBIE
BRANDY |  |  | BRANDY
DEBBIE |  |  | DEBBIE
NICOLE |  |  | NICOLE
0600-0800 |  |  | 0800-1000 |  |  | 1000-1200 |  |  | 1200-1400
 |  |  | KATY
KATY |  |  | [NAME] |  |  | KATY |  |  | KATY
[NAME] |  |  | CHERYL |  |  | [NAME] |  |  | [NAME]
CHERYL |  |  | RHONDA |  |  | CHERYL |  |  | CHERYL
RHONDA |  |  | CINDY |  |  | RHONDA |  |  | RHONDA
CINDY |  |  |  |  |  | CINDY |  |  | CINDY
 |  |  |  |  |  | LACY |  |  | LACY
 |  |  |  |  |  |  |  |  | MARK
 |  |  |  |  |  |  |  |  | KAY
1400-1600 |  |  | 1600-1800 |  |  | 1800-2000 |  |  | 2000-2200
 |  |  |  |  |  |  |  |  | CHRISTY
KATY |  |  | ANGELA H |  |  | ANGELA H |  |  | [NAME]
[NAME] |  |  | BRANDY |  |  | BRANDY |  |  | ANGELA H
CHERYL |  |  | LACY |  |  | LACY |  |  | JESS
RHONDA |  |  | NICOLE |  |  | NICOLE |  |  | BRANDY
CINDY |  |  | MARK |  |  | MARK |  |  | DEBBIE
LACY |  |  | KAY |  |  | KAY |  |  | NICOLE
KAY |  |  |  |  |  |  |  |  | MARK
 |  |  |  |  |  |  |  |  | KAY