tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 4ee12f52-cc3a-479c-9902-86af52926e5a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
Transaction Date:31/07/2012
Debt and Money Market Securities Transaction Details
S.No | Name of the Security | ISIN | Scheme Name | Maturity Date | Residual days | Settlement Type | Trade Date | Valuation Date | Settlement Date | Quantity Traded | Value of the Trade | Price at which valued | Yield at which valued | Type of trade
1 | POWER FINANCE CORPORATION LTD 89-B 9.46%  02/05/2015 | INE134E08EQ4 | SBI MAGNUM INCOME FUND | 02-MAY-2015 | 975 | T+1 | 30-AUG-2012 | 30-AUG-2012 | 31-AUG-2012 | 50 | 50215500 | 1004310 | 9.2329 | MARKET TRADE
2 | GOI 8.15%  11/06/2022 | IN0020120013 | SBI SHORT HORI DEBT FUND-SHORTTERM | 11-JUN-2022 | 3572 | T+1 | 30-AUG-2012 | 30-AUG-2012 | 31-AUG-2012 | 500000 | 49898750 | 99.8 | 8.1739 | MARKET TRADE
3 | 91 DAY TBILL MAT 30.11.2012 | IN002012X024 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 30-NOV-2012 | 92 | T+1 | 30-AUG-2012 | 30-AUG-2012 | 31-AUG-2012 | 5000000 | 489950000 | 97.99 | 8.2275 | MARKET TRADE
4 | GOI 8.15%  11/06/2022 | IN0020120013 | SBI MAGNUM BALANCED FUND | 11-JUN-2022 | 3572 | T+1 | 30-AUG-2012 | 30-AUG-2012 | 31-AUG-2012 | 1000000 | 99710000 | 99.71 | 8.1871 | MARKET TRADE
5 | ALLAHABAD BANK CD MAT 29.11.2012 | INE428A16HJ9 | SBI PREMIER LIQUID FUND | 29-NOV-2012 | 90 | T+0 | 31-AUG-2012 | 31-AUG-2012 | 31-AUG-2012 | 20000 | 1958990000 | 97949.5 | 8.49 | MARKET TRADE
6 | ALLAHABAD BANK CD MAT 29.11.2012 | INE428A16HJ9 | SBI MAGNUM INSTACASH FUND | 29-NOV-2012 | 90 | T+0 | 31-AUG-2012 | 31-AUG-2012 | 31-AUG-2012 | 10000 | 979495000 | 97949.5 | 8.49 | MARKET TRADE
7 | ADITYA BIRLA FINANCE LTD CP MAT 26.11.2012 | INE860H14IG7 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 26-NOV-2012 | 87 | T+0 | 31-AUG-2012 | 31-AUG-2012 | 31-AUG-2012 | 2000 | 979318000 | 489659 | 8.8602 | MARKET TRADE
8 | TATA CAPITAL FINANCIAL SERVICES LTD CP MAT 30.11.2012 | INE306N14423 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 30-NOV-2012 | 91 | T+0 | 31-AUG-2012 | 31-AUG-2012 | 31-AUG-2012 | 2000 | 978531000 | 489265.5 | 8.8001 | MARKET TRADE
9 | INDIAN OIL [NAME] MAT 29.11.2012 | INE242A14CW3 | SBI MAGNUM INSTACASH FUND-LIQUID FLOATER PLAN | 29-NOV-2012 | 90 | T+0 | 31-AUG-2012 | 31-AUG-2012 | 31-AUG-2012 | 500 | 244779250 | 489558.5 | 8.6499 | MARKET TRADE
10 | INDIAN OIL [NAME] MAT 29.11.2012 | INE242A14CW3 | SBI PREMIER LIQUID FUND | 29-NOV-2012 | 90 | T+0 | 31-AUG-2012 | 31-AUG-2012 | 31-AUG-2012 | 1500 | 734337750 | 489558.5 | 8.6499 | MARKET TRADE
11 | EDELWEISS FINANCIAL SERVICES LTD CP MAT 29.11.2012 | INE532F14IH4 | SBI PREMIER LIQUID FUND | 29-NOV-2012 | 90 | T+0 | 31-AUG-2012 | 31-AUG-2012 | 31-AUG-2012 | 2000 | 976758000 | 488379 | 9.6502 | MARKET TRADE
Note: | Value of the trade is based on the clean price.
 | Repo/CBLO and Fixed Deposits trades as not valued have not be reported.
 | Report is on Transaction level basis.
Spreadsheet: andy_zipper__120__Broker & Exchange Detail 6-5-01
Sheet: Exchange  Data

Date | Commodity | Transaction ID | Transaction Time | Counterparty Name | External Party | External Party Type | External Deal ID | Commodity Group | Product Type | Product ID | Product Name | Buy Volume | Sell Volume | Option Delta | Units | Currency | Price | External User ID | Trader ID | Risk Book | Bridge | Collateral Flag | Enron Entity | Contract ID | Deal ID | Global Counterparty ID | Begin Date | End Date | Strike Price | Expiration Date | Option Style | Option Type
 |  | 1335927 | 37046.6564236111 | Tucson Electric Power Company | True Quote LLC | Exchange | 5353 | Power | US West Power Phy Fwd Firm | 29412 | US Pwr Phy Firm  PALVE Peak              06Jun01         USD/MWh |  | 25 |  | MWh | United States Dollar | 115 | EXCHTQ00 | MFISCHE2 | ST-SW | Enpower US | Y | Enron Power Marketing, Inc. | 95001154 | 631936.1 | 26304 | 37048.875 | 37048.875
 |  | 1336904 | 2001-06-05 07:32:00 | PG&E Energy Trading - Power, L.P. | True Quote LLC | Exchange | 5361 | Power | US East Power Phy Fwd Firm | 29082 | US Pwr Phy Firm  NEPOOL Peak             06Jun01         USD/MWh | 50 |  |  | MWh | United States Dollar | 35.6 | EXCHTQ00 | PBRODER | ST-New England | Enpower US | N | Enron Power Marketing, Inc. | 96004859 | 632379.1 | 57552 | 2001-06-06 21:00:00 | 2001-06-06 21:00:00
 |  | 1336947 | 2001-06-05 07:36:00 | PG&E Energy Trading - Power, L.P. | True Quote LLC | Exchange | 5362 | Power | US East Power Phy Fwd Firm | 29088 | US Pwr Phy Firm  PJM-W Peak              06Jun01         USD/MWh |  | 50 |  | MWh | United States Dollar | 27.4 | EXCHTQ00 | JQUENET | ST-PJM | Enpower US | N | Enron Power Marketing, Inc. | 96004859 | 632396.1 | 57552 | 2001-06-06 21:00:00 | 2001-06-06 21:00:00
 |  | 1337087 | 2001-06-05 07:48:00 | PG&E Energy Trading - Power, L.P. | True Quote LLC | Exchange | 5364 | Power | US East Power Phy Fwd Firm | 29082 | US Pwr Phy Firm  NEPOOL Peak             06Jun01         USD/MWh |  | 50 |  | MWh | United States Dollar | 35.55 | EXCHTQ00 | PBRODER | ST-New England | Enpower US | N | Enron Power Marketing, Inc. | 96004859 | 632441.1 | 57552 | 2001-06-06 21:00:00 | 2001-06-06 21:00:00
Spreadsheet: 238366d1369498998-need-a-way-to-search-using-a-date-date-search-2
Sheet: Sheet1

Employee | Start | End | Hours
A | 2013-01-01 00:00:00 | 2013-01-02 00:00:00 | 12
A | 2013-03-22 00:00:00 | 2013-03-23 00:00:00 | 12
A | 2013-06-10 00:00:00 | 2013-06-11 00:00:00 | 12
b | 2013-08-29 00:00:00 | 2013-08-30 00:00:00 | 12 |  |  | Date | 2012-12-31 00:00:00
c | 2013-11-17 00:00:00 | 2013-11-18 00:00:00 | 12
c | 2014-02-05 00:00:00 | 2014-02-06 00:00:00 | 12 |  |  | Employee | Start | End | Hours
d | 2014-04-26 00:00:00 | 2014-04-27 00:00:00 | 12 |  |  | A | 2013-01-01 00:00:00 | 2013-01-02 00:00:00 | 12
f | 2014-07-15 00:00:00 | 2014-07-16 00:00:00 | 12 |  |  | d | 2013-01-05 00:00:00 | 2013-01-06 00:00:00 | 12
g | 2014-10-03 00:00:00 | 2014-10-04 00:00:00 | 12
d | 2013-01-05 00:00:00 | 2013-01-06 00:00:00 | 12
Spreadsheet: tracy_geaccone__40186__2002 Pl1
Sheet: CapEx

DETAILS OF CAPITAL EXPENDITURES
Non-Merchant Activities
(Millions of Dollars)
 | Capital Expenditures
 | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Total
Capital Expenditures
Generation
Relicensing
Transmission |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -9.61
Distribution |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -102.036
General |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -9.4
Non-Utility |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2.76
RWIP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -5.4
Various IT project |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -28.6
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other
Total (line 122)
Property Transfers - Intercompany
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other
Total (line 123)
Spreadsheet: 291673d1390372538-lookup-and-extract-multiple-rows-between-dates-overtime-vs-annual-leave
Sheet: Overtime

Emp ID | Start Date | End date | Overtime ID | Type
1 | 2014-01-03 00:00:00 | 2014-01-03 00:00:00 | 100 | Non Shift
3 | 2014-01-05 00:00:00 | 2014-01-05 00:00:00 | 100 | Non Shift
1 | 2014-01-01 00:00:00 | 2014-01-01 00:00:00 | 101 | Shift
3 | 2014-01-15 00:00:00 | 2014-01-15 00:00:00 | 101 | Shift
2 | 2014-01-05 00:00:00 | 2014-01-05 00:00:00 | 101 | Shift
Spreadsheet: 34bb8449-a7dc-42fa-97d6-d182ad79d6b6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-11-21 09:33:35.150000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.644 | 101.519 | 101.394 | 101.019
4.25 | 100.9 | 100.775 | 100.65 | 100.275 |  | Note: | Refer To Price [NAME]
4.125 | 100.508 | 100.383 | 100.258 | 99.883 |  |  | For all Price Adjs
4 | 100.052 | 99.927 | 99.802 | 99.177
3.875 | 99.478 | 99.353 | 99.228 | 98.603
3.75 | 98.607 | 98.482 | 98.357 | 97.732
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.706 | 101.581 | 101.456 | 101.081
3.75 | 101.193 | 101.068 | 100.943 | 100.568
3.625 | 100.821 | 100.696 | 100.571 | 100.196
3.5 | 100.465 | 100.34 | 100.215 | 99.84
3.375 | 100.081 | 99.956 | 99.831 | 99.206
3.25 | 99.525 | 99.4 | 99.275 | 98.65
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-12-05 09:33:35.150000
30 DAY | 2011-12-20 09:33:35.150000
45 DAY | 2012-01-04 09:33:35.150000
60 DAY | 2012-01-19 09:33:35.150000
90 DAY | 2012-02-18 09:33:35.150000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 473907d1470489665-how-to-return-a-blank-cell-until-condition-is-met-workbook1
Sheet: Sheet1

PETTY CASH
DATE | IN | OUT | RECEIPT NO | [NAME] | BALANCE
2016-08-01 00:00:00 |  |  |  | Bal B/F | -20
2016-08-02 00:00:00 | 150
2016-08-03 00:00:00 |  | 5
2016-08-04 00:00:00 |  | 2.75
2016-08-05 00:00:00 |  | 16.45
2016-08-06 00:00:00 |  | 45
2016-08-07 00:00:00 |  | 2.99
2016-08-08 00:00:00 |  | 60
2016-08-09 00:00:00 | 150
2016-08-10 00:00:00 |  | 2.25
2016-08-11 00:00:00 |  | 1.16
2016-08-12 00:00:00 |  | 15.99
2016-08-13 00:00:00 |  | 25
2016-08-14 00:00:00 |  | 14.3
2016-08-15 00:00:00 |  | 28
2016-08-16 00:00:00 |  | 19.99
2016-08-17 00:00:00 |  | 74
2016-08-18 00:00:00 | 150
2016-08-19 00:00:00 |  | 16
2016-08-20 00:00:00 |  | 25
2016-08-21 00:00:00 |  | 35
2016-08-22 00:00:00 |  | 1.5
2016-08-23 00:00:00 |  | 25
2016-08-24 00:00:00 |  | 10
2016-08-25 00:00:00 |  | 2.5
PETTY CASH
DATE | IN | OUT | RECEIPT NO | [NAME] | BALANCE
 |  |  |  | Bal B/F | 2.12
PETTY CASH
DATE | IN | OUT | RECEIPT NO | [NAME] | BALANCE
 |  |  |  | Bal B/F | 2.12
Spreadsheet: kimberly_watson__20613__EP-SanJuan
Sheet: EP-SanJuan

Dates | IGDI00ELU - Val
 | Inside FERC, El Paso San Juan Monthly Index
1995-01-31 00:00:00 | 1.09
1995-02-28 00:00:00 | 1.08
1995-03-31 00:00:00 | 1.09
1995-04-28 00:00:00 | 1.17
1995-05-31 00:00:00 | 1.17
1995-06-30 00:00:00 | 1.17
1995-07-31 00:00:00 | 1.02
1995-08-31 00:00:00 | 1.19
1995-09-29 00:00:00 | 1.19
1995-10-31 00:00:00 | 1.25
1995-12-29 00:00:00 | 1.39
1996-01-31 00:00:00 | 1.26
1996-02-29 00:00:00 | 1.18
1996-03-29 00:00:00 | 1.12
1996-04-30 00:00:00 | 1.12
1996-05-31 00:00:00 | 1.18
1996-06-28 00:00:00 | 1.47
1996-07-31 00:00:00 | 2
1996-08-30 00:00:00 | 1.55
1996-09-30 00:00:00 | 1.59
1996-10-31 00:00:00 | 2.45
1996-12-31 00:00:00 | 4.05
1997-01-31 00:00:00 | 2.48
1997-02-28 00:00:00 | 1.46
1997-03-31 00:00:00 | 1.59
1997-04-30 00:00:00 | 1.87
1997-05-30 00:00:00 | 1.87
1997-06-30 00:00:00 | 2.02
1997-07-31 00:00:00 | 1.97
1997-08-29 00:00:00 | 2
Spreadsheet: 772036d1646981375-return-a-month-wise-sum-values-with-ignoring-text-values-in-date-range-and-blanks-return-a-sum-values-with-ignoring-texts-in-date-range-and-blanks
Sheet: Sheet1

30.00 / Hr |  | 0.65 | 0.2 | 0.15 |  |  | Expected results
2019-12-25 00:00:00 | 30 |  |  |  |  | 2019-11-01 00:00:00
30.00 / Hr |  |  |  |  |  | 2019-12-01 00:00:00
2019-11-25 00:00:00 | 73 |  |  |  |  | 2020-01-01 00:00:00
30.00 / Hr |  |  |  |  |  | 2020-02-01 00:00:00
2020-01-25 00:00:00 | 402 |  |  |  |  | 2020-03-01 00:00:00
30.00 / Hr
2020-02-25 00:00:00 | 330
46.00 / Hr
2020-01-21 00:00:00 | 5
46.00 / Hr
2020-02-13 00:00:00 | 159
30.00 / Hr
2020-03-25 00:00:00 | 10
2020-03-25 00:00:00 | 12
2020-03-25 00:00:00 | 10
2020-02-18 00:00:00 | 159
30.00 / Hr
Spreadsheet: 740689d1626457083-trying-to-calculate-the-number-of-nights-needed-by-day-when-given-check-in-check-out-dates-nights-per-day
Sheet: Sheet1

2021-08-01 00:00:00 | 2021-08-04 00:00:00 |  |  | 2021-08-01 00:00:00
2021-08-01 00:00:00 | 2021-08-18 00:00:00 |  |  | 2021-08-02 00:00:00
2021-08-01 00:00:00 | 2021-08-04 00:00:00 |  |  | 2021-08-03 00:00:00
2021-08-01 00:00:00 | 2021-08-16 00:00:00 |  |  | 2021-08-04 00:00:00
2021-08-01 00:00:00 | 2021-08-03 00:00:00 |  |  | 2021-08-05 00:00:00
2021-08-01 00:00:00 | 2021-08-04 00:00:00 |  |  | 2021-08-06 00:00:00
2021-08-01 00:00:00 | 2021-08-08 00:00:00 |  |  | 2021-08-07 00:00:00
2021-08-01 00:00:00 | 2021-08-18 00:00:00 |  |  | 2021-08-08 00:00:00
2021-08-01 00:00:00 | 2021-08-08 00:00:00 |  |  | 2021-08-09 00:00:00
2021-08-01 00:00:00 | 2021-08-28 00:00:00 |  |  | 2021-08-10 00:00:00
2021-08-01 00:00:00 | 2021-08-12 00:00:00 |  |  | 2021-08-11 00:00:00
2021-08-01 00:00:00 | 2021-08-17 00:00:00 |  |  | 2021-08-12 00:00:00
2021-08-01 00:00:00 | 2021-08-03 00:00:00 |  |  | 2021-08-13 00:00:00
2021-08-01 00:00:00 | 2021-08-03 00:00:00 |  |  | 2021-08-14 00:00:00
2021-08-01 00:00:00 | 2021-08-16 00:00:00 |  |  | 2021-08-15 00:00:00
2021-08-01 00:00:00 | 2021-08-03 00:00:00 |  |  | 2021-08-16 00:00:00
2021-08-01 00:00:00 | 2021-08-15 00:00:00 |  |  | 2021-08-17 00:00:00
2021-08-01 00:00:00 | 2021-08-16 00:00:00 |  |  | 2021-08-18 00:00:00
2021-08-01 00:00:00 | 2021-08-15 00:00:00 |  |  | 2021-08-19 00:00:00
2021-08-01 00:00:00 | 2021-08-03 00:00:00 |  |  | 2021-08-20 00:00:00
2021-08-01 00:00:00 | 2021-08-16 00:00:00 |  |  | 2021-08-21 00:00:00
2021-08-02 00:00:00 | 2021-08-17 00:00:00 |  |  | 2021-08-22 00:00:00
 |  |  |  | 2021-08-23 00:00:00
 |  |  |  | 2021-08-24 00:00:00
 |  |  |  | 2021-08-25 00:00:00
 |  |  |  | 2021-08-26 00:00:00
 |  |  |  | 2021-08-27 00:00:00
 |  |  |  | 2021-08-28 00:00:00
 |  |  |  | 2021-08-29 00:00:00
 |  |  |  | 2021-08-30 00:00:00
 |  |  |  | 2021-08-31 00:00:00
Spreadsheet: 838295d1690899106-replace-special-characters-with-space-excel-forum-sample-file
Sheet: Sheet1

Invoice No. | Invoice Date | Current Result (Formula CONCATENATE) | Required Result  all special characters (like . / - etc.) to be replaced with blank space
4 | 2023-04-03 00:00:00 |  | Your Invoice No 4 dated 03 Apr2023
48/23-24 | 2023-04-08 00:00:00 |  | Your Invoice No 48 23 24 dated 08 Apr 2023
ST/2324/0000035 | 2023-04-10 00:00:00 |  | Your Invoice No ST [PHONE] dated 10 Apr 2023
KE/23-24/050 | 2023-04-27 00:00:00 |  | Your Invoice No KE 23 24 050 dated 27 Apr 2023
S23240297 | 2023-05-11 00:00:00 |  | Your Invoice No S23240297 dated 11 May 2023
ST/2324/0000235 | 2023-06-11 00:00:00 |  | Your Invoice No ST [PHONE] dated 11 Jun 2023
DGR/0217/2023-24 | 2023-06-30 00:00:00 |  | Your Invoice No DGR 0217 2023 24 dated 30 Jun 2023
2023-24/070 | 2023-06-30 00:00:00 |  | Your Invoice No 2023 24 070 dated 30 Jun 2023
121 | 2023-07-01 00:00:00 |  | Your Invoice No 121 dated 01 Jul 2023
625/23-24 | 2023-07-01 00:00:00 |  | Your Invoice No 625 23 24 dated 01 Jul 2023
DE0000268 | 2023-07-07 00:00:00 |  | Your Invoice No DE0000268 dated 07 Jul 2023
$ | $
Spreadsheet: phillip_m_love__30149__9908_OA
Sheet: ONT_FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ALL
REGION:  TRANSPORT
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 17755643 | 47624430
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 6266178 | 17050354
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 24021821 | 64674784
 | Purchases:
6 |  | 3rd Party / Inter Enron | -18325529 | -49279217
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -5814448 | -15558896
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 0
 | Total Purchases: |  | -24139977 | -64838113
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 | Storage:
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 118156 | 342652.4
23 | Fuel: |  | 0 | 0
 | Transport Expense:
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | -1202682.56710171
31 |  | Prior Month Book Balance | 0 | 1156439
 |  | Total MTM Income | 0 | -46243.56710170978
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 313157
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 2904
 |  | TOTAL INTRA-MTH
FT-Ontario
 |  | Current Month MTM | 0 | 3777
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 74196d1274774376-charting-every-second-data-point-730360b
Sheet: Sheet1

Date | Yield1 | Yield2 | Rent1 | Rent2 | Filter
2005-03-01 00:00:00 | 0.085 | 0.075 | 115 | 125 | 0
2005-06-01 00:00:00 | 0.085 | 0.075 | 115 | 125 | 1
2005-09-01 00:00:00 | 0.0825 | 0.075 | 115 | 125 | 0
2005-12-01 00:00:00 | 0.08375 | 0.075 | 115 | 125 | 1
2006-03-01 00:00:00 | 0.08 | 0.0775 | 115 | 125 | 0
2006-06-01 00:00:00 | 0.08 | 0.0775 | 120 | 130 | 1
2006-09-01 00:00:00 | 0.0775 | 0.075 | 120 | 130 | 0
2006-12-01 00:00:00 | 0.0775 | 0.0725 | 120 | 130 | 1
2007-03-01 00:00:00 | 0.075 | 0.08 | 120 | 130 | 0
2007-06-01 00:00:00 | 0.0725 | 0.08 | 120 | 130 | 1
2007-09-01 00:00:00 | 0.07 | 0.07 | 120 | 130 | 0
2007-12-01 00:00:00 | 0.065 | 0.0725 | 120 | 130 | 1
2008-03-01 00:00:00 | 0.07 | 0.075 | 120 | 130 | 0
2008-06-01 00:00:00 | 0.0788 | 0.08 | 130 | 140 | 1
2008-09-01 00:00:00 | 0.0788 | 0.0825 | 130 | 140 | 0
2008-12-01 00:00:00 | 0.0838 | 0.085 | 130 | 140 | 1
2009-03-01 00:00:00 | 0.0875 | 0.0875 | 125 | 135 | 0
2009-06-01 00:00:00 | 0.09 | 0.0875 | 125 | 135 | 1
2009-09-01 00:00:00 | 0.09 | 0.09 | 125 | 135 | 0
2009-12-01 00:00:00 | 0.0888 | 0.09 | 125 | 135 | 1
Mar-10 | 0.0888 | 0.09 | 125 | 135 | 0
Spreadsheet: 182497d1348504190-help-need-with-calculating-data-based-off-drop-down-list-test_scorecard_1
Sheet: Scorecard

Store Weekly Scorecard
Location:[NAME]
 |  |  | ACTUALS |  |  |  |  |  |  |  |  |  |  |  |  |  | GOALS |  |  |  |  |  |  |  | ATTAINMENT %
Week Ending: | Hrs worked for that week | Total Revenue | TRU (revenue/unit) |  | DPA |  | Quotes |  |  |  |  | SYSTEM SALES (units) |  |  | SnP (units) | Business Pipeline
2012-09-21 00:00:00 | actual hrs worked | $ order WITHOUT tax | Total | Denied | Accepted | Total | Quotes | Equotes | Total | [NAME] | Total w/ Event | Dell.com | Inventory | TOTAL | Dell.com | Business Opportunities |  | Total store Revenue                    ($ budget) | TRU                  $1050.00 per system sold | DPA Enrollment (Minimum 3 Per Day) | Quotes (Minimum 25 per day) | [NAME] quotes (60% of total quotes) | Systems      (goal) | SnP             (minimum 2.0 per system) | Total Revenue | TRU | DPA Enrollments | Quotes | [NAME] | Systems | SnP | Employee notes (ie vacation, sick, overtime, etc..)
EMPLOYEES
[NAME] | 40 |  |  |  |  |  | 8 | 9 |  | 50 |  |  |  |  |  |  |  | 1047 | 1050 |  |  |  | 1
[NAME] | 40 |  |  |  |  | 0 | 7 | 6 |  |  |  |  |  |  |  |  |  | 3000 | 1050 |  |  |  | 3
[NAME] | 40 | 279.99 |  |  | 1 |  | 5 | 5 |  |  |  |  |  |  | 1 |  |  | 3000 | 1050 |  |  |  | 3
[NAME] | 31 |  |  |  |  |  | 12 | 2 | 16 |  |  |  |  |  |  |  |  | 2000 | 1050 |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1050
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1050
TOTAL STORE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1050
 |  |  |  |  |  |  |  |  |  |  |  | TRU NOTE
Spreadsheet: 721271d1614618490-excel-formula-to-transpose-data-from-a-master-sheet-to-other-worksheets-sample-for-discussion
Sheet: A

Ariat | Order Number: | Date: | Ariat Products: | Product Code: | Colour: | [NAME]: | Quantity | Ordered? | In stock? | If Not - Due Date? | Comments | come in?
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Spreadsheet: 840338d1692662367-sumifs-while-cross-referencing-filtered-data-helper-or-no-helper-column-tms
Sheet: EX 1 Imported Report

People | Places | Purpose | Days |  |  | Purpose
[NAME] | Chicago | Business | 1 |  |  | Tour | <<< DV: =G4#
[NAME] | San Francisco | Tour | 2
Zach | New York | Work | 3 |  |  |  |  |  |  | Places | Purpose | Days
Gina | Lisbon | Work | 4 |  |  | Tour |  |  | [NAME] | San Francisco | Tour | 2
[NAME] the Eyebrow | Barcelona | Personal | 5 |  |  | Work |  |  | [NAME] | Madrid | Tour | 8
Gina | Madrid | Friends | 6 |  |  | Personal |  |  | [NAME] | San Francisco | Tour | 5
Zach | New York | Seminar | 7 |  |  | Friends
[NAME] | Madrid | Tour | 8 |  |  | Seminar
[NAME] | Barcelona | Conference | 7 |  |  | Conference
[NAME] the Eyebrow | San Francisco | Travel | 6 |  |  | Travel
[NAME] | San Francisco | Tour | 5 |  |  | Family
Gina | Chicago | Work | 4
[NAME] the Eyebrow | Lisbon | Conference | 3
[NAME] | Chicago | Seminar | 2
Zach | Lisbon | Business | 1
[NAME] | Madrid | Family | 10