tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__19068__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-10 00:00:00 |  | 372.23 | 8800 | 325 | 1800
 | 2001-04-09 00:00:00 |  | 303.28 | 10240 | 247.33 | 2920 | 516.2 | 1068 | 375.96 | 1070
 | 2001-04-08 00:00:00 |  |  |  |  |  |  |  | 329.65 | 2435 |  | 247.4 | 9000
 | 2001-04-07 00:00:00 |  | 269.8 | 4000 | 217.38 | 1600 | 388.04 | 575 | 304.12 | 323
 | 2001-04-06 00:00:00 |  | 269.8 | 4000 | 217.38 | 1600 | 337.41 | 1640 | 318.64 | 275
 | 2001-04-05 00:00:00 |  | 335.73 | 4960 | 244.29 | 1400 | 358.37 | 3130 | 252.05 | 670
 | 2001-04-04 00:00:00 |  | 303.95 | 3040 | 218.33 | 1800 | 354.42 | 1401 | 291.47 | 1225
 | 2001-04-03 00:00:00 |  | 293.57 | 5600 | 196.67 | 1800 | 343.76 | 487 | 308.73 | 315
 | 2001-04-02 00:00:00 |  | 278.14 | 4592 | 201.82 | 2200 | 343.33 | 2990 | 231.25 | 880
 | 2001-04-01 00:00:00 |  |  |  |  |  |  |  | 286.97 | 2045 |  | 201.82 | 6600
 | 2001-03-31 00:00:00 |  | 183.81 | 8944 | 119.54 | 3448 | 276.25 | 800 | 246.67 | 150
 | 2001-03-30 00:00:00 |  | 181.46 | 7680 | 119.54 | 3448 | 246.39 | 2630 | 195.61 | 570
 | 2001-03-29 00:00:00 |  | 188.08 | 5488 | 115.18 | 2408 | 218.64 | 2360 | 189.31 | 725
 | 2001-03-28 00:00:00 |  | 163.85 | 6240 | 84.65 | 2368 | 193.33 | 790 | 225 | 200
 | 2001-03-27 00:00:00 |  | 159.55 | 4400 | 95 | 200 | 158.05 | 665 | 92 | 500
 | 2001-03-26 00:00:00 |  | 324.62 | 5200 | 196.15 | 1560 | 125.58 | 1943 | 95.04 | 605
 | 2001-03-25 00:00:00 |  |  |  |  |  |  |  | 86.42 | 965 |  | 197.59 | 3480
 | 2001-03-24 00:00:00 |  | 304.64 | 6640 | 198.68 | 760 | 190.9 | 2680 | 187.34 | 1463
 | 2001-03-23 00:00:00 |  | 305.27 | 5840 | 202.5 | 400 | 405.31 | 3225 | 358.35 | 1365
 | 2001-03-22 00:00:00 |  | 373.61 | 7200 | 222.62 | 840 | 401.04 | 3938 | 388.28 | 1215
 | 2001-03-21 00:00:00 |  | 441.52 | 3680 | 243.61 | 720 | 491.64 | 1345 | 382.76 | 870
 | 2001-03-20 00:00:00 |  | 399.53 | 5120 | 308.69 | 560 | 483.98 | 1040 | 363.65 | 1000
 | 2001-03-19 00:00:00 |  | 458.18 | 14320 | 290 | 200 | 410.04 | 1220 | 293.22 | 885
 | 2001-03-18 00:00:00 |  |  |  |  |  |  |  | 256.06 | 3083 |  | 310 | 1200
 | 2001-03-17 00:00:00 |  | 244.64 | 5600 | 200.19 | 1040 | 357.5 | 360 | 276.3 | 270
 | 2001-03-16 00:00:00 |  | 244.64 | 5600 | 200.19 | 1040 | 394.78 | 335 | 330 | 360
 | 2001-03-15 00:00:00 |  | 216.79 | 7600 | 168.33 | 1200 | 254.45 | 627 | 261.36 | 550
 | 2001-03-14 00:00:00 |  | 213.33 | 7200 | 178.33 | 600 | 246.45 | 900 | 222.58 | 1035
 | 2001-03-13 00:00:00 |  | 217.05 | 8800 | 174.4 | 1000 | 234.06 | 1946 | 237.07 | 870
 | 2001-03-12 00:00:00 |  | 270 | 6800 | 205 | 200 | 237.03 | 3775 | 219.92 | 1945
 | 2001-03-11 00:00:00 |  |  |  |  |  |  |  | 239.18 | 2715 |  | 205 | 600
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: chris_germany__1770__trans
Sheet: Sheet1

Transport Worksheet
 | [NAME]
 |  |  | RP |  |  | RP
 |  | DP = | (1- Fuel) | + Comm | AND  DP = | (1- Fuel) | + Comm + Demand
 |  |  | RP
 |  | Fuel Cost = | (1-Fuel) | - RP
 |  | Variable = | Fuel Cost + Comm
 |  | Where
 |  |  | DP = Delivery Price  ([NAME])
 |  |  | RP = Receipt Price  ([NAME])
 |  |  | Fuel = [NAME] fuel
 |  |  | Fuel Cost = fuel percentage converted to dollars.
 |  |  | Comm = Commodity cost for Transco Z3-Z6 (includes all surcharges)
 |  |  | Variable = total transport cost to move gas from one point to another.
 |  |  |  | Also referred to as the "all in" cost.
 |  |  | RP = | 4.875
 |  |  | Fuel = | 0.0472
 |  |  | Comm = | 0.0465
 |  |  | DP = | (1-.0472) | + $.0465 | =
 |  |  | Variable = | (1 - .0472) | -  $4.8750 | + $.0465 =
 |  | Example
 |  |  | ENA purchases 1,000,000 dth from [NAME] at St 65 at a price of $4.8750
 |  |  | ENA sells 952,800 dth to [NAME] in Z6 at a price of $5.163
 |  |  | Transco will bill ENA commodity charges of $.0465 on a delivered volume
 |  |  | of 952,800 dth.
 |  |  | Cashflows
 |  |  |  |  | Volume | Price | Amount
 |  |  |  | Purchase | 1000000 | 4.875
 |  |  |  | Transport Bill | 952800 | 0.0465
 |  |  |  |  |  | Total Expense
 |  |  |  | Sale | 952800
Spreadsheet: 773687d1648004153-setting-up-formula-a-to-check-a-or-tol-between-columns-and-print-a-custom-text-result-example
Sheet: ExcelCertAttachmentforTPgtxAmo

Equipment | As Found | Line Number | Description | Standard | Tolerance - Neg | Tolerance - Pos | As Left | UOM | Result | Precision | Deviation | [NAME] | Limited | Result | Uncertaintity | Unc. Uom
 | 0.77 | 1 |  | 0.77 | 0.7699 | 0.7701 | 0.7701 | inch - In | In Tolerance | 5
 | 0.79 | 2 |  | 0.79 | 0.7899 | 0.7901 | 0.7902 | inch - In |  | 5
 | 0.8 | 3 |  | 0.8 | 0.7999 | 0.8001 | 0.8001 | inch - In | In Tolerance | 5
 | 0.82 | 4 |  | 0.82 | 0.8199 | 0.8201 | 0.82 | inch - In | In Tolerance | 5
 | 0.85 | 5 |  | 0.85 | 0.8499 | 0.8501 | 0.8498 | inch - In | Fail | 5
 | 0.87 | 6 |  | 0.87 | 0.8699 | 0.8701 | 0.8699 | inch - In | In Tolerance | 5
Spreadsheet: darron_c_giron__7950__cecilia book move
Sheet: fin out of money

Counterparty Short Name
AMERADAHESCOM
AMERICANASS200
ASTRAPOWLLC
BANKERSTRUINT
BELCO OIL
BLACKSTOMIN
BLUESTARESLTD
[NAME]
BRAZOSVPPLIM
CALLON-PET
CANNONINT
CARGILLENEA D
CARRIZOOILGAS
CGAS
CINERGYCAPTRA
COENERGYTRA
COL-GAS-T
COMPANIAMINAUT
CON_ED_NY
CONSUMERENECOM
CONTINENGAS
CONVERMEDELNOR
CONVERTIMEXDEP
COPAMEXSA
CRESCENDENELLC
CROSSTEXENESER
DAIMONPARI
DAIMONPARIII
[NAME]
DEVONSFS
DIAMONDSHAREF
DOMFIESER
DOMINIONEXPCAN
DOMINIONEXPPRO
DTEENETRA
DUKEENEMER
DYNEGYCANMAR
EASTSOULAK
EEXCORP
EEXEPCO
ENERGYMARAD
ENERVESTENEL P
ENTERPRIPROOPE
ENTRADAENEVEN
EOGRES
EPRIENE
EQUITABLENELL
ERAC
FAGADAUENECOR
FERSINSAGISBRO
FIBRASQUISA
FIRSTCRUAD
FLORIDA
FOREST
GRUPOINDSAL
GRUPOPETSA
HARVARDCOLPREFE
HESSENETRA
HILANDPARLLC
HOMESTAOIL
HUNTPETCOR
IDELPROSADE
INDUSTRIPENS A
JUNIPERENEL P
KAZTEXENEMAN
KCS
KERRMCGEROCMOU
KEYSPANENESER
KROGER
KUKUI
LAMOSAREVS A
LASVEGCOG
LDNGCSER98TRU
LENORMANPAR
LOUISDREPLA
MARINERENE
MCELVAINOILGAS
MERCADO
MERITENEPARA
MERITENEPARB
MERITENEPARCI
MERITENEPARCII
MERITENEPARIX
MERITENEPARVIII
MERITENEPARX
MERITENERGY
MERITPARLP
[NAME]
MICHIGANCONGASC
MORGAN
NEMAKSA
NEW JERSEY
NICORGASCOM
NYLONDEMEX
OCCIDENTALPETIN
PATINAOILGAS
PENNACOENE
PEOPLESENECOR
PETROTEMSADE
PG&ECOR
PICKENSFUECOR
POLYKRONSADE
PRESTONEXPCOM
PUBLICUTILITIES
QUALITECSTECOR
RANGERESCOR
[NAME]
RISINGSTAENE
SANITARIAZTSA
SCANAENETRA
SEGUNDONAVDRI
SHELLCHECOM
SMALLVENUSA
SOUTHERNUNION
SOUTHWESTROY
SWIFT
TAUBER
TBOOPIC
TDC ENERGY
TEJASGASMAR
TORCHENERGY
TRADEEXPCOR
TUDORINVCOR
TXUENETRCANL
ULTRAMARINC
UNITEDOILMIN
UNIVEXSA
VERNONEFAU
VIRGINIAELEPOW
VITROCORSA
WASATCHENELLC
WILLIAMS-CLAY
WISEROILCOM
WYNNCRO94
WYNNCRO95
WYNNCRO96
WYNNCRO97
WYNNCRO98
WYNNCRO99
YUMACOMTHE
Spreadsheet: 648947d1573317838-largest-positive-and-smallest-negative-with-multi-conditions-larpos_smallneg
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Largest Positive / Smallest Negative |  |  | Size
 | 1 |  | 22 | 88 | -50 | -78.25 |  |  | 24 | 28 | 41.25 | -80 |  |  |  | 24 | 28 | 41.25 | 80 |  |  |  |  | 28
 | 1 |  | 22 | 88 | -50 | -78.25 |  |  | 99 | 28 | 41.25 | -80 |  |  |  | 24 | 28 | 41.25 | 80 |  |  |  |  | 24
 | 1 |  | 22 | 88 | -50 | -78.25 |  |  | -99 | 28 | 41.25 | -80 |  |  |  | 24 | 28 | 41.25 | 80 |  |  |  |  | 28
 | 1 |  | 22 | 88 | -50 | 88 |  |  | -99 | 28 | 41.25 | -80 |  |  |  | 24 | 28 | 41.25 | 80 |  |  |  |  | 80
 | 1 |  | 22 | 88 | -50 | 88 |  |  | 88 | 28 | 41.25 | -80 |  |  |  | 24 | 28 | 41.25 | 80 |  |  |  |  | 24
 | 1 |  | 88 | 88 | 88 | 88 |  |  | 28 | 28 | 41.25 | -80 |  |  |  | 24 | 28 | 41.25 | 80 |  |  |  |  | 80
 | 0 |  | 52.5 | 68.35 | -100 | 25 |  |  | -100 | 20 | 1 | 5 |  |  |  | 888 | 20 | 1 | 5 |  |  |  |  | 888
 | 1 |  | 0 | 0 | 1 | 5 |  |  | -1 | -1 | -1 | -1 |  |  |  | 1 | 5 | 7 | 0 |  |  |  |  | 0
 | 1 |  | -5 | -5 | -5 | -5 |  |  | -5 | -5 | -5 | -5 |  |  |  | 80 | 50 | 40
 | 1 |  | -5 | -5 | -5 | -5 |  |  | 444 | -5 | -5 | -5 |  |  |  | 777 | 32 | 48.65 |  |  |  |  |  | 777
 | 0 |  | 1 | 0 | -65 | -55 |  |  | 1 | 0 | -65 | 50 |  |  |  | 0 | 2 | 30 | 0 |  |  |  |  | 30
 | 0 |  | 1 | 0 | -65 | -55 |  |  | -85 | 0 | -65 | 50 |  |  |  | 333 | 2 | 30 | 0 |  |  |  |  | 333
 | 1 |  | 20 | 22 | -44 | 22 |  |  | 7 | 8 | 9 | 0 |  |  |  | 7 | 0 | 9 | 999 |  |  |  |  | 999
 | 1 |  | 2 |  | 0
 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0
 | 1 |  | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 111
Spreadsheet: 755284d1636748375-how-to-automate-shift-pay-time-for-split-shifts-with-given-constraints-efsplitshift
Sheet: Sheet1

Minimum Guarntee |  | 7.25 |  |  | Shift A |  |  |  |  | 1.  Report Allowance = 10 minutes
Gurantee | 08:00:00 | 8 |  |  | Span of Day |  |  |  |  | So.  Report tine should be before shift start
Report Allowance | 00:10:00 |  |  |  | 1st Report |  |  |  |  | G3 =G4-$B$3
Clear Allowance | 00:05:00 |  |  |  | First Shift Start | 05:00:00
[NAME] | 02:00:00 |  |  |  | First Shift End | 10:00:00 |  |  |  | 2.  Paid break between shifts = 2 hours
Day Span Bonus | 10:00:00 |  |  |  | Clear |  |  |  |  | [NAME])
or | 11:00:00
Maximum Allowed Day Span | 14:00:00 |  |  |  | Break |  |  |  |  | 3.  Report Allowance = 10 minutes
 |  |  |  |  |  |  |  |  |  | So.  Report tine should be before shift start
 |  |  |  |  | 2nd Report |  |  |  |  | G10 =G11-$B$3
 |  |  |  |  | Second Shift Start | 12:00:00
 |  |  |  |  |  |  |  |  |  | 3.  F19 = "Day Span"
 |  |  |  |  | Second Shift End | 14:45:00 |  |  |  | G19 = =[NAME]
 |  |  |  |  | Clear |  |  |  |  | I19 =IF(H19>14/24,"Breach","Allowed")
 |  |  |  |  | STRAIGHT TIME |  |  |  |  | 4.  F20  10 hour limit pay
 |  |  |  |  |  |  |  |  |  | I20 =MAX(G19-10/24,0)
 |  |  |  |  | TOTAL WORK HOURS
 |  |  |  |  | Day Span = |  |  |  |  | 5. F21     =8 Hour Work Bonus…......I read this as actual work time not 8 Hour Guarantee
Staff get the following; |  |  |  |  | 10 Hour Limit Pay |  |  |  |  | I21 =MAX(G19-10/24,0)
 |  |  |  |  | 8 Hour Work Bonus
10 minutes for Report Time | Ok |  |  |  | 11 Hour Limit Bonus |  |  |  |  | 6.  If someone works > 11 hours then automatically gets 12 hours pay as overtime
5 minutes for Clear time | Ok |  |  |  |  |  |  |  |  | I22 =IF(G19>11/24,0.5,0)
 |  |  |  |  | Hours to pay
If the break between both shifts is less than 2 hours then it is paid at straight time. | Ok |  |  |  |  |  |  |  |  | 7.  Overtime pay is the max of 4.  or 5. or 6.
 |  |  |  |  |  |  |  |  |  | H21=MAX(I20:I22)
The maximum day span allowed is 14 hours. | ok
 |  |  |  |  |  |  |  |  |  | 8. Hours to Pay
 |  |  |  |  |  |  |  |  |  | H24 = =[NAME]:H20)
All employees shall be paid for overtime at the rate of one and one‑half times the hourly rate for all work performed after the completion of eight (8) hours work or ten (10) hour day span daily. | Ok |  |  |  |  |  |  |  |  | I25 = =HOUR(H24) +MINUTE(H24)/60
Jobs having a day span in excess of eleven hours (11) minimum pay at the end of eleven (11) hours shall be eight (8) times the hourly rate and work performed thereafter shall be paid in addition to the minimum guarantee of eight (8) hours.
Spreadsheet: 797558d1663954082-incorrect-result-from-rank-formula-midshires-master
Sheet: Results

INDIVIDUAL RESULT |  |  |  |  |  |  | TEAM |  |  |  |  |  |  |  |  |  |  | TEAM EVENT
No | PLAYER | PAR 3 | TOTAL |  |  |  | PLAYER | PLAYER | PLAYER | PLAYER | TOTAL | S/I 1 | S/I 2 | S/I 3 | S/I 4 |  |  |  | No | PLAYER | PLAYER | PLAYER | PLAYER | TOTAL | S/I 1 | S/I 2 | S/1/3 | S/1/4
1st |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2nd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
3rd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
4th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
5th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
6th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
7th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
8th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
9th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
10th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
11th |  |  |  |  |  |  | SKINS
12th |  |  |  |  |  |  | POT | 60
13th |  |  |  |  |  |  | HOLE
14th |  |  |  |  |  |  | 1
15th |  |  |  |  |  |  | 2
16th |  |  |  |  |  |  | 3
17th |  |  |  |  |  |  | 4
18th |  |  |  |  |  |  | 5
19th |  |  |  |  |  |  | 6
20th |  |  |  |  |  |  | 7
21st |  |  |  |  |  |  | 8
22nd |  |  |  |  |  |  | 9
23rd |  |  |  |  |  |  | 10
24th |  |  |  |  |  |  | 11
25th |  |  |  |  |  |  | 12
26th |  |  |  |  |  |  | 13
27th |  |  |  |  |  |  | 14
28th |  |  |  |  |  |  | 15
29th |  |  |  |  |  |  | 16
30th |  |  |  |  |  |  | 17
31st |  |  |  |  |  |  | 18
32nd
33rd
34th |  |  |  |  |  |  | Order of Merit Result | RANK | No |  | OoM | par 3
35th |  |  |  |  |  |  |  | 1 | 1
36th |  |  |  |  |  |  |  | 2 | 2
37th |  |  |  |  |  |  |  | 3 | 3
38th |  |  |  |  |  |  |  | 4 | 4
39th |  |  |  |  |  |  |  | 5 | 5
40th |  |  |  |  |  |  |  | 6 | 6
41st |  |  |  |  |  |  |  | 7 | 7
42nd |  |  |  |  |  |  |  | 8 | 8
43rd |  |  |  |  |  |  |  | 9 | 9
44th |  |  |  |  |  |  |  | 10 | 10
45th |  |  |  |  |  |  |  | 11 | 11
46th |  |  |  |  |  |  |  | 12 | 12
47th |  |  |  |  |  |  |  |  | 13
48th |  |  |  |  |  |  |  |  | 14
49th |  |  |  |  |  |  |  |  | 15
50th |  |  |  |  |  |  |  |  | 16
51st |  |  |  |  |  |  |  |  | 17
52nd |  |  |  |  |  |  |  |  | 18
53rd |  |  |  |  |  |  |  |  | 19
54th |  |  |  |  |  |  |  |  | 20
55th |  |  |  |  |  |  |  |  | 21
56th |  |  |  |  |  |  |  |  | 22
57th |  |  |  |  |  |  |  |  | 23
58th |  |  |  |  |  |  |  |  | 24
59th |  |  |  |  |  |  |  |  | 25
60th |  |  |  |  |  |  |  |  | 26
61st |  |  |  |  |  |  |  |  | 27
62nd |  |  |  |  |  |  |  |  | 28
63rd |  |  |  |  |  |  |  |  | 29
64th |  |  |  |  |  |  |  |  | 30
65th |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  | 45
Spreadsheet: 842038d1694113543-exclude-rows-with-duplicate-cell-dynamic-array-test-58-
Sheet: Feuil1

 |  |  |  |  | array from |  |  |  |  | EXPECTED RESULT
A | [NAME] | 4.22 |  |  |  | [NAME] | 4.22 |  |  | A | [NAME] | 4.22 |  |  | [NAME] | 4.22
B | er | 4.27103404 |  |  | B | er | 4.27103404 |  |  | B | er | 4.27103404 |  | B | er | 4.27103404
C | ty | 4.27103404 |  |  | C | ty | 4.27103404 |  |  | C | ty | 4.27103404 |  | C | ty | 4.27103404
D | ui | 4.99 |  |  | D | ui | 4.99 |  |  | D | ui | 4.99 |  | D | ui | 4.99
A | op | 6.133590238 |  |  | A | op | 6.133590238 |  |  | E | ml | 11.08970242 |  | E | ml | 11.08970242
E | ml | 11.08970242 |  |  | E | ml | 11.08970242 |  |  | F | [NAME] | 12.56690216 |  | F | [NAME] | 12.56690216
F | [NAME] | 12.56690216 |  |  | F | [NAME] | 12.56690216
F | hg | 13.45 |  |  | F | hg | 13.45
Spreadsheet: 49625d1248977064-empty-cell-not-returning-zero-still-not-calculating
Sheet: Serna

Received and [NAME] | LeftOvers and AlaCarte Sum
 |  |  | Received from Millswood | Prepared on Site | LEFT OVERS | [NAME] |  | REIM-BURSED
80 | 0 |  | 50 | 30 |  |  |  | 80
50 | 0 |  | 50 |  |  |  |  | 50
 | 1 |  |  | 50 | 1 | 0
40 | 0 |  | 40 |  |  |  |  | 40
 | 0
40 | 0 |  | 40 |  |  |  |  | 40
 | 0
50 | 0 |  | 50 |  | 30 |  |  | #N/A
 | 0 |  |  | 30 |  | 5 |  | #N/A
60 | 10 |  | 30 | 30 | 5 | 5 |  | 50
30 | 0 |  | 20 | 10 | 1 |  |  | #N/A
#N/A | 10 |  |  |  | 5 | 5 |  | #N/A
#N/A | 0 |  |  |  |  | 5 |  | #N/A
#N/A | 0 |  |  |  |  |  |  | #N/A
Spreadsheet: 472590d1469646140-many-ifs-in-one-cell-book1
Sheet: Sheet1

 |  |  |  |  | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 55 | 60 | 65 | 70 | 75 | 80 | 85 | 90 | 95 | 100 | 105 | 110 | 115 | 120
 |  |  |  | 6
 |  |  |  | 5
 |  |  |  | 4
 |  |  |  | 3 | Same for "3"
 |  |  |  | 2 | same for "2"
 |  |  |  | 1 | 2016 | 2016 | 2016 | 2017 | 2017 | 2016 | 2016 | 2025 | 2025 | 2025 | 2025
1 | 17 | 2016 |  | 1) | if A15 equals E12 and if B15 >= F6, then take value of C15 and insert it in F12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =>>> do this until B15 is greater then F6 or G6 or H6 etc.
1 | 10 | 2017
2 | 20 | 2016 |  |  | If the above is no longer true, then do this:
1 | 12 | 2016
3 | 19 | 2018 |  | 2) | search for the next "1"  in column A and ADD together with previous "1"s… and test it going further… but paste value from C16 in this case
2 | 14 | 2019
1 | 17 | 2025 |  |  | So we have…. |  |  | 17+10 = 27
 |  |  |  | 3) | So we have…. 17+10+12=39 |  |  |  |  |  | =>>> test 39 going further….
 |  |  |  | 4) | Next we have….. 17+10+12+17 = 56
Spreadsheet: mary_fischer__25636__31S
Sheet: E5.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031S
COMPANY NAME   Limbach Company
ANALYSIS OF GOODWILL
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-5
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  |  |  |  |  |  |  |  |  | 6-30-2001
[NAME] OR ENTITY |  | AMORTIZATION |  | BALANCE |  |  |  |  |  | OTHER |  |  |  | BALANCE
 |  | PERIOD (Yrs.) |  | DR. (CR.) |  | ADDITIONS |  | AMORTIZATION** |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Goodwill |  | 40 |  | 4709535 |  |  |  | -102853 |  | -37872 |  | Research for 3Q
Total Goodwill* |  |  |  |  |  |  |  |  | ** |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0344 | Same signs as Hyperion
**MUST TIE TO HYPERION ACCOUNT 1418 | Reverse signs from Hyperion
Spreadsheet: 789299d1659030298-countif-help-sampleex
Sheet: Sheet1

 | 3 GAMES
 |  |  |  |  |  |  |  |  | 50-59 |  |  |  | 60-69 |  |  |  | 70-79
series | UNDER |  |  | WIN | LOSS | TIE |  |  | WIN | LOSS | TIE |  | WIN | LOSS | TIE |  | WIN | LOSS | TIE
1 | 3,5,9 | 55 |  | 2 | 5 | 0
1 | 3,6,8 | 52 |  | 5 | 1 | 0
1 | 2,5,10 | 65 |  | 4 | 2 | 1
1 | 2,6,10 | 64 |  | 8 | 5 | 2
1 | 3,6,10 | 55 |  | 6 | 1 | 0
1 | 2,9,10 | 66 |  | 1 | 5 | 1
1 | 3,8,9 | 66 |  | 2 | 4 | 0
1 | 4,6,10 | 70 |  | 1 | 2 | 0
1 | 5,4,7 | 75 |  | 5 | 4 | 2
1 | 6,1,2 | 78 |  | 3 | 8 | 0
Spreadsheet: geir_solberg__11287__12-21act
Sheet: EPEData

 | 37342.3375
 | NEWMAN 1 ,UNAV,  0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,MANL, 28  , 77  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,ECON, 79  ,100  , 35  ,103  , 21  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,ECON,186  ,215  , 86  ,214  , 29  ,1
 | NEWMAN   ,, 293 ,  392,  155, 400 ,  49 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,   0 ,    0,    0,   0 ,   0 ,
 | PALOVERDE,MANL,605  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 67  , 67  , 67  ,104  ,  0  ,1
 | LAMBDA, 37.93,  717,  717,  134,   -1,    0,14988,0
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: lisa_gang__22285__ENA_PGE_MAY 2_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 2002-05-02 00:00:00
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  |  |  | Total In To PGE Trans
0100 |  |  |  |  | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0 | 0
0700 | 25 | 25 | 25 | 25 | 25 | 25
0800 | 25 | 25 | 25 | 25 | 25 | 25
0900 | 25 | 25 | 25 | 25 | 25 | 25
1000 | 25 | 25 | 25 | 25 | 25 | 25
1100 | 25 | 25 | 25 | 25 | 25 | 25
1200 | 25 | 25 | 25 | 25 | 25 | 25
1300 | 25 | 25 | 25 | 25 | 25 | 25
1400 | 25 | 25 | 25 | 25 | 25 | 25
1500 | 25 | 25 | 25 | 25 | 25 | 25
1600 | 25 | 25 | 25 | 25 | 25 | 25
1700 | 25 | 25 | 25 | 25 | 25 | 25
1800 | 25 | 25 | 25 | 25 | 25 | 25
1900 | 25 | 25 | 25 | 25 | 25 | 25
2000 | 25 | 25 | 25 | 25 | 25 | 25
2100 | 25 | 25 | 25 | 25 | 25 | 25
2200 | 25 | 25 | 25 | 25 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24711 | BPA(G)24718 | BPA(G)24727 | BPA(G)24771 | TPU(G)SYS | TPU(G)SYS
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AEP | AEP | AEP | AEP | AEP | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AEP | AEP | AEP | AEP | AEP | AEP
 | CDWR | CDWR | TID | MIRANT | MORGAN | MORGAN
 | ISO(T)MALIN/NP15 | ISO(T)MALIN/NP15 | TID(T)CPJK/TRACEY/WESLEY | PGE | APX | SMUD
 | CDWR(L,FS)NP15 (CA) | CDWR(L,FS)NP15 (CA) | TID | WESCO | ISO(T)MALIN/NP15 | SMUD(T)CPJK/NP15
 |  |  | TID(L)WESLEY | ISO(T)MALIN/NP15 | APX(L,FS)NP15 (CA) | SMUD(L,FS)NP15 (CA)
 |  |  |  | WESCO(L,FS)NP15 (CA)
Spreadsheet: kay_mann__19197__liability
Sheet: Sheet1

MDEA Liability SWAG |  |  |  |  |  |  |  |  |  | Fuel
 |  |  |  |  |  |  |  |  |  | Gas
 |  |  |  |  |  |  |  |  |  | MMBtu/Mcf
Contract Energy |  | Days | 30 |  |  |  |  |  | Heat Value of Fuel | 1.036
Existing Contracts |  |  |  |  |  |  |  |  | Typical Plant Heat Rate (MMBtu/MW-hr) | 11
Cajun |  | 7 | 24
EPI-Isis |  | 7 | 24 |  |  |  |  |  |  | Fuel Cost
EPI-Ritchie |  | 1 | 24 |  |  |  |  |  |  | Mcf
 |  |  |  |  |  |  |  |  |  | 5.2
Load
[NAME] | [NAME] | 26 | 24 |  |  |  |  |  |  | Fuel Consumed
 | Yazoo | 20 | 24 |  |  |  |  |  | Power Generated      (MW-hr) | Mcf
Required Energy
 |  |  |  |  |  |  |  |  |  | Power Cost per MW
 |  |  |  |  |  |  |  |  |  | Gas
Production Cost
Required Energy
 |  |  |  |  |  |  |  |  |  | Power Cost per MMBtu
Liability |  |  |  |  |  |  |  |  |  | Gas
Spreadsheet: 78346d1278698897-vlookup-dummy_vlook
Sheet: Sheet2

 |  |  |  |  |  |  |  | Cases
Byr# | PO # | PV# | [NAME] | Prod # | Product Descrption | Var |  | Short | Mfc Out | Dmgd | Quality Issue | Mis-ship | Others
130 | 265845 | 000417 | TYSON FOODS INC.      STATUS - CLOSED | 4608931 | CHICKEN, BRST FIL 5Z RTC BLS | -36 |  | 36
130 | 265845 | 000417 | TYSON FOODS INC.      STATUS - CLOSED | 5493796 | CHICKEN, 8 PC CUT BRDD LGTY | -10 |  | 10
130 | 265845 | 000417 | TYSON FOODS INC.      STATUS - CLOSED | 5874870 | CHICKEN BRST SNGL LOBE 4 Z | -161 |  | 161
130 | 265845 | 000417 | TYSON FOODS INC.      STATUS - CLOSED | 5875208 | CHICKEN, BRST SNGL LOBE 4Z M | -89 |  | 89
130 | 265845 | 000417 | TYSON FOODS INC.      STATUS - CLOSED | 5880646 | CHICKEN, BRST SNGL LOBE 5Z M | -57 |  | 57
130 | 265845 | 000417 | TYSON FOODS INC.      STATUS - CLOSED | 5880661 | CHICKEN, BRST SNGL LOBE 6Z M | -171 |  | 171
130 | 303042 | 079581 | WOLVERING PACKING - F STATUS - CLOSED | 1484096 | BEEF, PTY GRND 80/20 10 Z RN | -1 |  |  |  | 1
130 | 288993 | 002520 | JOHN MORRELL & CO     STATUS - CLOSED | 7401029 | SAUSAGE, PORK LNK SKNLS  CKD | -10 |  |  |  | 10
 |  |  |  |  |  |  |  | VLOOK THE "DMGD" COLUMN, IDENTIFIED BY "PV#" AND "PROD #"
 |  |  |  |  |  |  |  | (SINCE I DON'T HAVE AN UNIQUE IDENTIFIER, I'M NOT SURE WHAT TO DO
 |  |  |  |  |  |  |  | OTHER THAN USING 2 IDENTIFIERS TO MAKE SURE IT IS REFERRING
 |  |  |  |  |  |  |  | TO THE RIGHT CELLS)