tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30141__200001_OA
Sheet: EAST-LRC-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  LRC
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18781 | 44079.01
14 |  | Cash Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -18781 | -43947.54
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 99863d1298406991-index-match-match-returns-ref-or-0-2011-square-and-bracket-templet
Sheet: Master

 |  | FIRST ALPHABETICAL TEAM
 |  | 9 | pd | 5 | pd | 1 | pd | 8 | pd | 3 | pd | 4 | pd | 7 | pd | 2 | pd | 0 | pd | 6 | pd
SECOND ALPHABETICAL TEAM | 0 | Amy & Mike | a | [NAME] |  | Kathy & Frank |  | Connie G |  | [NAME] |  | R Train 1 |  | [NAME] O |  | [NAME] |  | [NAME] |  | Kings of Cali |  |  | 8 |  | 390 | 2007-02-24 00:00:00
 | 8 | [NAME] |  | [NAME] |  | Network Kings |  | Kings of Cali | a | [NAME] |  | D & F |  | Adam R |  | [NAME] |  | [NAME] |  | [NAME] |  |  | 9 |  | 305 | 2007-02-25 00:00:00
 | 2 | [NAME] |  | Carrie & Jen |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] Y |  | Geoff S |  | [NAME] and [NAME] |  | [NAME] R |  |  | 9 |  | 260
 | 9 | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] | a | [NAME] |  | [NAME] |  | Art D |  | [NAME] |  | [NAME] |  | [NAME] |  |  | 8 |  | 65
 | 7 | Sandy & Denise | a | [NAME] and [NAME] | a | Brad & Cathy |  | [NAME] |  | [NAME] |  | [NAME] | a | Carm C |  | [NAME] |  | [NAME] |  | [NAME] |  |  | 9 |  | 1240 | 2007-03-03 00:00:00
 | 4 | [NAME] P |  | [NAME] |  | [NAME] |  | Debbie & Bill |  | [NAME] |  | [NAME] |  | Trevor R |  | Sue & Mike |  | [NAME] |  | R Train 2 | a |  | 10 |  | 760 | 2007-03-05 00:00:00
 | 6 | [NAME] |  | Hershey S |  | Julie & Joe |  | [NAME] |  | Sean P |  | Jen T | a | [NAME] |  | [NAME] |  | [NAME] | a | [NAME] |  |  | 10 |  | 715 | 2007-03-07 00:00:00
 | 5 | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Kings of Cali |  | [NAME] |  | Terri & Nick |  | [NAME] |  |  | 10 |  | 1170 | 2007-03-10 00:00:00
 | 1 | [NAME] |  | Rich & George |  | [NAME] |  | [NAME] T |  | Yolanda M |  | [NAME] |  | Judi L |  | [NAME] |  | [NAME] |  | [NAME] |  |  | 9 |  | 715 | 2007-03-13 00:00:00
 | 3 | [NAME] |  | Robyn S |  | [NAME] |  | Trent T |  | [NAME] |  | Langer |  | [NAME] |  | Bubba R |  | [NAME] O |  | Jared O |  |  | 10
Spreadsheet: 97463d1296635677-concatenated-cell-reference-returns-wrong-value-by-a-quadrillionth-concissue
Sheet: AMEX

[NAME] |  |  |  |  |  |  |  | [NAME]
Current Balance: |  |  |  |  |  |  | tighter | Current Balance:
 |  |  | credits | debits |  |  | formula |  |  |  | credits | debits
 |  |  | 962.44 |  |  |  |  |  |  |  | 962.44
 |  |  |  | 88.16 |  |  |  |  |  |  |  | 88.16
 |  |  | 240 |  |  |  |  |  |  |  | 240
 |  |  |  | 1055 |  |  |  |  |  |  |  | 1055
 |  |  |  | 9.62 |  |  |  |  |  |  |  | 9.62
Spreadsheet: 807586d1669958627-formular-for-analyze-best-and-weak-students-g666-ver1-ans3
Sheet: MALE 5 BEST AND WEAK STUDENT

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 3 | 4 | 5 | 1
G. FIVE BEST MALE STUDENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
H. FIVE WEAK MALE STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
Spreadsheet: 167272d1341940339-changing-a-cells-background-colour-based-on-a-form-entry-templateexample
Sheet: Data

 |  |  |  |  |  | 07:00:00
 |  |  |  |  |  | 07:30:00
 |  |  |  |  |  | 08:00:00
 |  |  |  |  |  | 08:30:00
 |  |  |  |  |  | 09:00:00
 |  |  |  |  |  | 09:30:00
 |  |  |  |  |  | 10:00:00
 |  |  |  |  |  | 10:30:00
 |  |  |  |  |  | 11:00:00
 |  |  |  |  |  | 11:30:00
 |  |  |  |  |  | 12:00:00
 |  |  |  |  |  | 12:30:00
 |  |  |  |  |  | 13:00:00
 |  |  |  |  |  | 13:30:00
 |  |  |  |  |  | 14:00:00
 |  |  |  |  |  | 14:30:00
 |  |  |  |  |  | 15:00:00
 |  |  |  |  |  | 15:30:00
 |  |  |  |  |  | 16:00:00
 |  |  |  |  |  | 16:30:00
 |  |  |  |  |  | 17:00:00
 |  |  |  |  |  | 17:30:00
 |  |  |  |  |  | 18:00:00
 |  |  |  |  |  | 18:30:00
 |  |  |  |  |  | 19:00:00
 |  |  |  |  |  | 19:30:00
 |  |  |  |  |  | 20:00:00
 |  |  |  |  |  | 20:30:00
 |  |  |  |  |  | 21:00:00
 |  |  |  |  |  | 21:30:00
 |  |  |  |  |  | 22:00:00
Spreadsheet: 163073d1340184259-list-certain-row-only-when-matching-certain-condition-display-results-matching-certain-condition
Sheet: Schedule

CONDITIONS | NAMES | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 |  | 2012-05-31 00:00:00 | 2012-06-01 00:00:00 | 2012-06-02 00:00:00 | 2012-06-03 00:00:00 | 2012-06-04 00:00:00 | 2012-06-05 00:00:00 | 2012-06-06 00:00:00 | 2012-06-07 00:00:00 | 2012-06-08 00:00:00 | 2012-06-09 00:00:00 | 2012-06-10 00:00:00 | 2012-06-11 00:00:00 | 2012-06-12 00:00:00 | 2012-06-13 00:00:00 | 2012-06-14 00:00:00 | 2012-06-15 00:00:00 | 2012-06-16 00:00:00 | 2012-06-17 00:00:00 | 2012-06-18 00:00:00 | 2012-06-19 00:00:00 | 2012-06-20 00:00:00 | 2012-06-21 00:00:00 | 2012-06-22 00:00:00 | 2012-06-23 00:00:00 | 2012-06-24 00:00:00 | 2012-06-25 00:00:00 | 2012-06-26 00:00:00 | 2012-06-27 00:00:00 | 2012-06-28 00:00:00 | 2012-06-29 00:00:00 | 2012-06-30 00:00:00
 |  | May | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun | Jun
Condition4 | Name1 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | CD | CD | CD |  |  | 12 | 12 | 12 | 12 | 12 |  |  | 9 | 9 | 9 | 9 | 9
Condition2 | [NAME] | 9 | 9 |  |  | 10 | 10 | 10 | 10 | 10 |  |  | 9 | 9 | 12 | 9 | 9 |  |  | 9 | 11 | 11 | 8 | PL |  |  | PL | PL | PL | PL | PL
Condition3 | Name3 | 9 | 9 |  |  | 12 | 12 | 9 | 12 | 12 |  |  | 9 | 11 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 8 | 9 | 9 | 9 | 9
Condition4 | Name4 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 12 | 12 | 9 | 9 | 12 |  |  | 8 | 8 | 8 | 11 | 8 |  |  | 9 | 9 | 9 | 9 | 9
Condition5 | Name5 | PL | 12 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 11 | 9 | 11 | 11 | 11 |  |  | PL | PL | PL | PL | PL |  |  | 12 | 12 | 12 | 12 | 12
Condition6 | Name6 | 9 | 10 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 9 | 9 | SL | 9 | 9 |  |  | CD | 8 | 8 | 8 | 8
Condition4 | Name7 | 10 | 9 |  |  | 11 | 11 | 11 | 11 | 11 |  |  | 10 | 10 | 10 | 10 | 10 |  |  | PL | PL | PL | PL | PL |  |  | 11 | 11 | 11 | 11 | 11
Condition8 | Name8 | 9 | 9 |  |  | 9 | 9 | SL | SL | SL |  |  | 9 | 9 | 9 | 12 | 9 |  |  | 11 | 10 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9
Condition9 | Name9 | 9 | 9 |  |  | 8 | 9 | 9 | 9 | 8 |  |  | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 10 |  |  | 10 | 10 | 10 | 10 | 10
Condition1 | Name10 | 9 | 11 |  |  | 9 | 8 | 8 | 8 | PL |  |  | 9 | 9 | 9 | 9 | PL |  |  | 9 | PL | N/A | N/A | N/A |  |  | N/A | N/A | N/A | N/A | N/A
Spreadsheet: mary_hain__25859__IOU04
Sheet: Summary Page 1

Benefits distribution (in millions) among customer's
 | Benefit $s are the savings the customer gets assuming that the alternative cost is the market price.
 | Using rate case base assumptions  (See note 1.)
 | IOU Benefits | % | Public Benefits | % | DSI Benefits | % | Total Benefits
#1 | Using rate case market forecast and new load forecasts
 | IOU Benefits | % | Public Benefits | % | DSI Benefits | % | Total Benefits
#2 | Using $42 market forecast and new load forecasts
 | IOU Benefits | % | Public Benefits | % | DSI Benefits | % | Total Benefits
#3 | Using $42 market forecast and new load forecasts with a $400 million CRAC (Note 2)
 | IOU Benefits | % | Public Benefits | % | DSI Benefits | % | Total Benefits
#4 | Using $42 market forecast and new load forecasts with 1500 aMW power for IOUs & no CRAC
 | IOU Benefits | % | Public Benefits | % | DSI Benefits | % | Total Benefits
#5 | Using $42 market forecast new load forecasts 1500 aMW IOU and a $461 million CRAC (Note 2 & 3)
 | IOU Benefits | % | Public Benefits | % | DSI Benefits | % | Total Benefits
#6 | Using $42 market forecast new load forecasts 1900 aMW IOU and no CRAC
 | IOU Benefits | % | Public Benefits | % | DSI Benefits | % | Total Benefits
#7 | Using $42 market forecast new load forecasts 1900 aMW IOU and a $511 million CRAC
 | IOU Benefits | % | Public Benefits | % | DSI Benefits | % | Total Benefits
Note 1 | The following three items apply to all scenarios above.
 | DSI loads are 1490 instead of 1440.
 | Irrigation and Seasonal (I & S) rate mitigation is valued at $5/MWh rather than $4/MWh
 | I & S is an FPS sale not subject to CRAC.
Note 2 | The CRAC was not applied to the financial portion of the IOU settlement.
Note 3 | Increase CRAC by $61 million to capture net cost of change of 500 aMW from ResX to Purchase.
Note 4 | 900aMW of pre-subscription load is not included in the analysis.  If this load were included, the
 | results would be more dramatic.
Conclusions:
1 | The share of the benefits of the IOUs as a percentage of the
 | total benefits is eroding from rate case assumptions.
2 | The actual $ value of the benefits of the IOUs is increasing.
Spreadsheet: 5d04cece-a397-4942-be06-5dadbf5126d6
Sheet: Sheet1

 | Gene | [NAME] | [NAME] (Microarray) | Real-time RT-PCR | Western blot | Murine VILI
1 | MYBL2 | [NAME] myeloblastosis viral oncogene homolog (avian)-like 2 | 9.4 +/- 3.0 | Conf.
2 | CTGF | Connective tissue growth factor | 8.6 +/- 1.5 | Conf. |  | Conf.
3 | BIRC5 | Survivin | 6.9 +/- 3.2 | Conf. |  | Conf.
4 | CXCR4 | Chemokine (CXC motif) receptor 4 | 4.2 +/- 1.4 | Conf. |  | Conf.
5 | MMP1 | Matrix metaloprotesase 1 | 4  +/- 1.6 | Conf.
6 | EDN1 | Endothelin 1 | 4  +/- 1.2 | Conf.
7 | IL1RN | Interleukin 1 receptor | 3.5 +/- 1.4 | Conf. |  | Conf.
8 | IL-1B | Interleukin 1B | 3.5 +/- 1.3 | Conf. | ELISA | Conf.
9 | A2BAR | A2B adenosine receptor | 3.4 +/- 0.95 | Conf. | Conf. | Conf.
10 | IL 1A | Interleukin 1A | 3.15 +/- 1.5 | Conf. | ELISA | Conf.
11 | CD73 | Extracellular conversion of AMP to adenosine | 2.5 +/-0.3 | Conf. | Conf. | Conf.
12 | IL-8 | Interleukin 8 | 2.4 +/- 0.3 | Conf. | ELISA | Conf.
13 | ENO1 | Enolase 1 alpha | 2.4 +/- 0.18 | Conf.
14 | CD55 | Decay accelerating factor | 2.3 +/- 0.5 | Conf. | Conf.
15 | HK2 | Hexokinase 2 | 2.3 +/- 0.24 | Conf.
16 | CDC42 | cell division cycle 42, GTP binding protein | 2.2 +/- 0.23 | Conf.
17 | SAE1 | SUMO1 activating enzyme | 2.1  +/- 0.32 | Conf.
18 | [NAME] | Phosphoglycerate kinase 1 | 2.0  +/- 0.15 | Conf.
19 | TGFA | Transforming growth factor alpha | 1.8 +/- 0.37 | Conf. | Conf. | Conf.
20 | HIG2 | Hypoxia- inducible protein 2 | 1.5 +/- 0.15 | Conf. | Conf. | Conf.
Spreadsheet: 858064d1706835853-excel-solver-linearize-a-non-linear-equation-due-to-multiplication-of-variable-solver-work
Sheet: 1B

Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Book2]Sheet1
Report Created: 2024-01-28 6:18:59 PM
Variable Cells
 |  |  | Final | Reduced | Objective | Allowable | Allowable
 | Cell | Name | Value | Cost | Coefficient | Increase | Decrease
 | $D$21:$F$22
 | $D$21 | Bristol London | 20000 | 0 | 25 | 5 | 1e+30
 | $[NAME] | Bristol Brimingham | 15000 | 0 | 23 | 4 | 1e+30
 | $F$21 | [NAME] | 0 | -30 | 0 | 1e+30 | 30
 | $D$22 | [NAME] | 0 | 5 | 30 | 1e+30 | 5
 | $E$22 | [NAME] | 0 | 4 | 27 | 1e+30 | 4
 | $F$22 | [NAME] | 12000 | 0 | 30 | 17 | 1e+30
 | $[NAME]
 | $[NAME] | [NAME] | 0 | 4 | 80 | 1e+30 | 4
 | $M$21 | Bristol | 0 | -70 | 0 | 1e+30 | 70
 | $N$21 | Bristol Production | 0 | 36 | 90 | 1e+30 | 36
 | $[NAME] | Bristol | 0 | 21 | 100 | 1e+30 | 21
 | $P$21 | Bristol | 0 | 3 | 86 | 1e+30 | 3
 | $L$22 | [NAME] | 0 | -76 | 0 | 1e+30 | 76
 | $M$22 | Leeds | 18000 | 0 | 70 | 3 | 14
 | $[NAME] | [NAME] | 13000 | 0 | 54 | 15 | 54
 | $O$22 | Leeds | 0 | -79 | 0 | 1e+30 | 79
 | $P$22 | Leeds | 0 | 17 | 100 | 1e+30 | 17
 | $L$23 | [NAME] | 0 | 0 | 37 | 4 | 1
 | $M$23 | London | 2000 | 0 | 31 | 10 | 3
 | $[NAME] | London Production | 0 | -15 | 0 | 1e+30 | 15
 | $O$23 | London | 14000 | 0 | 40 | 1 | 79
 | $P$23 | London | 4000 | 0 | 44 | 3 | 16
 | $[NAME] | [NAME] | 15000 | 0 | 36 | 1 | 1e+30
 | $[NAME] | Birmingham | 0 | 10 | 40 | 1e+30 | 10
 | $N$24 | [NAME] | 0 | 29 | 43 | 1e+30 | 29
 | $O$24 | Birmingham | 0 | 1 | 40 | 1e+30 | 1
 | $P$24 | Birmingham | 0 | 3 | 46 | 1e+30 | 3
 | $[NAME] | [NAME] | 0 | 16 | 45 | 1e+30 | 16
 | $M$25 | [NAME] | 0 | 19 | 42 | 1e+30 | 19
 | $N$25 | Glasgow Production | 0 | 23 | 30 | 1e+30 | 23
 | $O$25 | [NAME] | 0 | -32 | 0 | 1e+30 | 32
 | $P$25 | [NAME] | 12000 | 0 | 36 | 16 | 1e+30
Constraints
 |  |  | Final | Shadow | Constraint | Allowable | Allowable
 | Cell | Name | Value | Price | R.H. Side | Increase | Decrease
 | $D$26:$F$26 <= $D$28:$F$28
 | $D$26 | London | 20000 | -14 | 20000 | 5000 | 2000
 | $E$26 | [NAME] | 15000 | -17 | 15000 | 0 | 2000
 | $F$26 | [NAME] | 12000 | -17 | 12000 | 4000 | 2000
 | $G$21 | [NAME] | 35000 | 0 | 40000 | 1e+30 | 5000
 | $G$22 | [NAME] | 12000 | 0 | 50000 | 1e+30 | 38000
 | $L$26:$P$26 >= $L$28:$P$28
 | $L$26 | Total Wholesaler | 15000 | 76 | 15000 | 2000 | 0
 | $M$26 | Total | 20000 | 70 | 20000 | 7000 | 18000
 | $N$26 | Total Production | 13000 | 54 | 13000 | 7000 | 13000
 | $O$26 | Total | 14000 | 79 | 14000 | 2000 | 14000
 | $[NAME] | Total | 16000 | 83 | 16000 | 2000 | 4000
 | $Q$21:$Q$25 <= $S$21:$S$25
 | $Q$21 | Bristol | 0 | 0 | 0 | 1e+30 | 5000
 | $[NAME] | Leeds | 31000 | 0 | 0 | 1e+30 | 7000
 | $[NAME] | London | 20000 | -39 | 0 | 18000 | 2000
 | $Q$24 | Birmingham | 15000 | -40 | 0 | 0 | 2000
 | $Q$25 | [NAME] | 12000 | -47 | 0 | 4000 | 2000
Spreadsheet: 36406d1234298154-querying-rows-for-a-master-sheet-pivot1
Sheet: Sheet4

Count of Status 0=Pending, 1=Repaired | DATE
Status 0=Pending, 1=Repaired | 2009-02-09 00:00:00 | 2009-02-10 00:00:00 | 2009-02-11 00:00:00 | (blank) | Grand Total
0 | 2 |  | 3 |  | 5
1 | 1 | 1 | 2 |  | 4
(blank)
Grand Total | 3 | 1 | 5 |  | 9
Spreadsheet: sally_beck__33737__MgmtSum-Q3-0728
Sheet: Expense Weekly Change

PLAN2000
TOT_OPS_EXPENSES | ENRON NORTH AMERICA
2000-09-01 00:00:00 | 3RD QUARTER 2000 EXPENSES-Weekly Change
M.QTD
ENA |  |  | Direct Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
gas_combined | Gas Trading
ASST_TRD | Texas Desk
sum | Gas Trading
CANADA | Canada Trading
E_PWR_TR | East Power Trading
W_PWR_TR | West Power Trading
IR_FX | Financial Drift
ECT_INV_IRFX | Financial Trading
COAL | Coal-Trading
SO2 | Emissions (Coal)
WEATHER | Weather
Exec_trd | Cross Commodity Trading
 | Total Trading & Risk Management
E_ORG | East Midstream
W_ORIG | West Midstream
DWNSTRM_IND_ORIG | Industrial Downstream
N_BS_DEV | Generation Investments
 | Coal Origination & Finance
 | Canada Origination & Finance
ASST_ORIG | Upstream Originations
 | HPL
 | LRC
INSURANCE | GRM - New Products
MEXICO | Mexico
 | Total Origination
EQUITY | Principal Investing
PROD_FIN | Energy Capital Resources
ASST_MGT_AND_RESTRCT | Special Assets
CTG_ASSETS | CTG Assets
 | CTG Assets
 | Total Investing
CTG | Commercial Transactions Group
OF_CHAIR | Office of the Chairman
 | Total Commercial
GROUP | Group
TREASURY_INT | Other Interest Related Charges
 | Total
 |  |  | Operating Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
 | Genco
 | HPL
 | ENA Upstream Assets
Spreadsheet: 704452d1605554451-if-formula-with-help-required-with-formula
Sheet: Sheet4

Example
Employee | weekly pay | weeks pay entitlemment | weekly stat cap | Full entitlement
Emp 1 | 500 | 6.5 | 538 |  |  | This one should show me a result of 500 x 6.5. Because 500 is lower than 538
Emp 2 | 550 | 4.5 | 538 |  |  | This one should show me a result of 538 x 4.5. Because 550 is higher than the 538 cap
'Weeky Pay' in column B  multiplied by 'weeks pay entitlement' column C
BUT
If figure in 'weekly pay' shown column B is higher than the figure in 'weekly stat cap' in column D
Then
use the figure in ''Weekly stat cap' in Column D instead and multiply by 'weekly pay entitlement' shown in column C
Show answers in column E in £
Spreadsheet: 839855d1692269740-need-formula-to-highlight-hours-out-with-working-arrangement-test-2-dougers1-
Sheet: Sheet1

Grade | From | To | Break | Start | End | Actual Break | Hours
StH-LA OW M-F9am-5pm | 09:00:00 | 17:00:00 | 30 | 09:00:00 | 17:00:00 | 30 | 07:30:00 |  | Working Arrangements
Con 8am-8pm Mon-Fri | 08:00:00 | 16:00:00 | 30 | 08:00:00 | 16:00:00 | 30 | 07:30:00 |  | LA Outside Monday to Friday 9am to 5pm for shift working patterns
StH-LA OW M-F9am-5pm | 17:00:00 | 21:00:00 | 0 | 17:00:00 | 21:00:00 | 0 | 04:00:00 |  | LB  Outside Monday to Friday 9am to 5pm for on-call working patterns
StH-LA OW M-F9am-5pm | 08:30:00 | 21:00:00 | 0 | 08:30:00 | 21:00:00 | 0 | 12:30:00 |  | LC Monday to Friday 9am to 5pm for all working patterns
StL-LA OW M-F9am-5pm | 08:45:00 | 17:00:00 | 30 | 08:45:00 | 17:00:00 | 30 | 07:45:00
[NAME] 24Hrs | 08:00:00 | 17:00:00 | 30 | 08:00:00 | 17:00:00 | 30 | 08:30:00
StH-LA OW M-F9am-5pm | 08:30:00 | 16:45:00 | 45 | 08:30:00 | 16:45:00 | 45 | 07:30:00
xStLED SatSun 24 Hrs | 14:00:00 | 22:00:00 | 30 | 14:00:00 | 22:00:00 | 30 | 07:30:00
StL-LA OW M-F9am-5pm | 21:00:00 | 10:00:00 | 45 | 21:00:00 | 10:00:00 | 45 | 12:15:00
StH-LA OW M-F9am-5pm | 20:30:00 | 08:45:00 | 45 | 20:30:00 | 08:45:00 | 45 | 11:30:00
FY2LA O/W M-F9am-5pm | 08:45:00 | 17:00:00 | 30 | 08:45:00 | 17:00:00 | 30 | 07:45:00
StH-LA OW M-F9am-5pm | 08:45:00 | 17:00:00 | 30 | 08:45:00 | 17:00:00 | 30 | 07:45:00
xStLED Mon-Fri 24hrs | 12:00:00 | 20:00:00 | 30 | 12:00:00 | 20:00:00 | 30 | 07:30:00
FY2LA O/W M-F9am-5pm | 08:45:00 | 17:10:00 | 30 | 08:45:00 | 17:00:00 | 30 | 07:45:00
StL-LA OW M-F9am-5pm | 08:45:00 | 17:00:00 | 30 | 08:45:00 | 17:00:00 | 30 | 07:45:00
StL-LA OW M-F9am-5pm | 20:30:00 | 08:45:00 | 45 | 20:30:00 | 08:45:00 | 45 | 11:30:00
StH-LA OW M-F9am-5pm | 08:00:00 | 17:30:00 | 60 | 08:00:00 | 17:30:00 | 60 | 08:30:00
StL-LA OW M-F9am-5pm | 07:45:00 | 16:30:00 | 30 | 07:45:00 | 16:30:00 | 30 | 08:15:00
StH-LA OW M-F9am-5pm | 17:00:00 | 21:30:00 | 0 | 17:00:00 | 21:30:00 | 0 | 04:30:00
[NAME] 24Hrs | 16:00:00 | 01:00:00 | 30 | 16:00:00 | 01:00:00 | 30 | 08:30:00
StL-LA OW M-F9am-5pm | 08:30:00 | 20:45:00 | 45 | 08:30:00 | 20:45:00 | 45 | 11:30:00
[NAME] 24Hrs | 22:15:00 | 08:15:00 | 45 | 22:15:00 | 08:15:00 | 45 | 09:15:00
StL-LA OW M-F9am-5pm | 10:00:00 | 20:00:00 | 45 | 10:00:00 | 20:00:00 | 45 | 09:15:00
FY2LA O/W M-F9am-5pm | 08:00:00 | 16:30:00 | 30 | 08:00:00 | 16:30:00 | 30 | 08:00:00
StH-LA OW M-F9am-5pm | 08:45:00 | 17:00:00 | 30 | 08:45:00 | 17:00:00 | 30 | 07:45:00
FY2LA O/W M-F9am-5pm | 08:45:00 | 17:00:00 | 30 | 08:45:00 | 17:00:00 | 30 | 07:45:00
[NAME] 24Hrs | 12:00:00 | 22:00:00 | 30 | 12:00:00 | 22:00:00 | 30 | 09:30:00
StL-LA OW M-F9am-5pm | 08:30:00 | 17:00:00 | 45 | 08:30:00 | 20:45:00 | 45 | 11:30:00
StL-LA OW M-F9am-5pm | 21:00:00 | 09:00:00 | 60 | 21:00:00 | 09:00:00 | 60 | 11:00:00
FY2LA O/W M-F9am-5pm | 09:00:00 | 17:00:00 | 30 | 09:00:00 | 17:00:00 | 30 | 07:30:00
Con 8am-8pm Mon-Fri | 09:00:00 | 17:00:00 | 30 | 07:30:00 | 17:00:00 | 30 | 09:00:00
xStLED Mon-Fri 24hrs | 12:00:00 | 23:00:00 | 60 | 12:00:00 | 23:00:00 | 60 | 10:00:00
Spreadsheet: 19a25403-f00a-4f85-913c-024c0d67fcc5
Sheet: Menu

HOLIDAY CALCULATOR
Menu
 | Click to select relevant calculator
1. | Holiday entitlement for a part-time member of staff who works all year
2. | Holiday entitlement for a part-time member of staff starting part way through the leave year
3. | Holiday entitlement for a full-time member of staff starting part way through the leave year
4. | Holiday entitlement for a part-time member of staff who works for a defined number of weeks in a year. All holiday is taken within the contracted working weeks
5. | Holiday entitlement for a part-time member of staff who works for a defined number of weeks in a year. All holiday is taken outside the contracted working weeks
6. | Calculating holiday entitlement when the hours of work change during the leave year
7. | Calculating a leaver's holiday entitlement when they are full-time
8. | Calculating a leaver's holiday entitlement when they are part-time. Holiday taken within the contracted working weeks.
9. | Calculating a leaver's holiday entitlement when they are part-time. Holiday taken outside the contracted working weeks.
 | FOR ANY OTHER ANNUAL LEAVE CALCULATIONS PLEASE SEEK THE ADVICE OF AN HR ADVISOR OR HR ADMINISTRATOR.
Spreadsheet: 163868d1340517299-date-wise-itemwise-inventory-daywise-inward
Sheet: Daily Inward

Daily Inward
Sr No. | Date | Month | Item Name | [NAME] | Qty
1 | 19 | June | Powder | Minearal bros | 19240
2 | 19 | June | Powder | Abc supplier | 4130
3 | 13 | June | Powder | Minearal bros | 20200
4 | 23 | June | Chemical | supplier A | 18312
5 | 22 | June | Firewood | Abc supplier | 13720
6 | 23 | June | Firewood | Abc supplier | 10660
7 | 23 | June | Firewood | Abc supplier | 5370
8 | 23 | June | Powder | Minearal bros | 9000
Spreadsheet: 40719d1239118759-pivot-table-on-status-field-678971_bluecrane
Sheet: Sheet1

Name | Manager | Status
[NAME] | Fred | Assessed
Sara | [NAME] | Approved
[NAME] | [NAME] | Unassessed
[NAME] | Fred | Unassessed
[NAME] | Fred | Assessed
[NAME] | [NAME] | Approved
[NAME] | Fred | Approved