tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 130762d1322575481-formulas-referencing-my-month-year-dropdown-list-sales_rev_-_samplev2
Sheet: Targets

 | Target Revenue
 |  | Claudia | Sydney | Julia | Gene | Serene | Eunice | Con7 | Con8 | Total
 | 2011-01-01 00:00:00 | 6000 | 6000 | 6000 | 6000 | 20000 | 3000
 | 2011-02-01 00:00:00 | 6000 | 6000 | 6000 | 6000 | 20000 | 3000
 | 2011-03-01 00:00:00 | 6000 | 6000 | 6000 | 6000 | 20000 | 3000
 | 2011-04-01 00:00:00 | 6000 | 6000 | 6000 | 6000 | 20000 | 3000
 | 2011-05-01 00:00:00 | 6000 | 6000 | 6000 | 6000 | 25000 | 3000
 | 2011-06-01 00:00:00 | 6000 | 6000 | 6000 | 6000 | 25000 | 3000
 | 2011-07-01 00:00:00 | 6000 | 6000 | 6000 | 6000 | 25000 | 3000
 | 2011-08-01 00:00:00 | 7000 | 7000 | 7000 | 7000 | 25000 | 3000
 | 2011-09-01 00:00:00 | 8000 | 8000 | 8000 | 8000 | 25000 | 3000
 | 2011-10-01 00:00:00 | 8000 | 8000 | 8000 | 8000 | 25000 | 3000
 | 2011-11-01 00:00:00 | 8000 | 8000 | 8000 | 8000 | 25000 | 3000
 | 2011-12-01 00:00:00 | 8000 | 8000 | 8000 | 8000 | 25000 | 3000
 | Total FY2011
Spreadsheet: 374163d1422700177-pulling-multiple-data-from-a-spreadsheet-to-a-certain-criteria-highlights
Sheet: Sheet3

date | Quote | Part No | Customer | indusrty | class | Value
 |  |  |  |  |  |  |  |  | 2015-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 2015-02-01 00:00:00
Spreadsheet: 886261d1736306409-making-a-basketball-schedule-2025-schedule-sportsmen05-
Sheet: Sheet2

Teams | Days | Time |  | 2025-01-07 00:00:00
ANFG | TH | late |  | 5 | 8 |  | 4 | 11 |  | 06:30:00 |  |  | 06:30:00
Legends | TH |  |  | 6 | 9 |  | 3 | 12 |  | 07:30:00 |  |  | 07:30:00
FlossOver | TH | early |  | 7 | 10 |  | 2 | 13 |  | 08:30:00 |  |  | 08:30:00
Assisted Living | Tue
[NAME] | Tue
Young Bulls | Tue | late |  | 5 | 11 |  | 4 | 8 |  | 06:30:00 |  |  | 06:30:00
V Ups |  |  |  | 6 | 12 |  | 3 | 9 |  | 07:30:00 |  |  | 07:30:00
Soviet Reunion |  |  |  | 7 | 13 |  | 2 | 10 |  | 08:30:00 |  |  | 08:30:00
Good Neighbors
FreeBallers
Mask Off |  |  |  | 5 | 9 |  | 4 | 12 |  | 06:30:00 |  |  | 06:30:00
24 Hourz |  |  |  | 6 | 10 |  | 3 | 13 |  | 07:30:00 |  |  | 07:30:00
 |  |  |  | 7 | 8 |  | 2 | 11 |  | 08:30:00 |  |  | 08:30:00
 |  |  |  | 5 | 12 |  | 4 | 9 |  | 06:30:00 |  |  | 06:30:00
 |  |  |  | 6 | 13 |  | 3 | 10 |  | 07:30:00 |  |  | 07:30:00
 |  |  |  | 7 | 11 |  | 2 | 8 |  | 08:30:00 |  |  | 08:30:00
 |  |  |  | 5 | 10 |  | 4 | 13 |  | 06:30:00 |  |  | 06:30:00
 |  |  |  | 6 | 8 |  | 3 | 11 |  | 07:30:00 |  |  | 07:30:00
 |  |  |  | 7 | 9 |  | 2 | 12 |  | 08:30:00 |  |  | 08:30:00
 |  |  |  | 5 | 13 |  | 4 | 10 |  | 06:30:00 |  |  | 06:30:00
 |  |  |  | 6 | 11 |  | 3 | 8 |  | 07:30:00 |  |  | 07:30:00
 |  |  |  | 7 | 12 |  | 2 | 9 |  | 08:30:00 |  |  | 08:30:00
 |  |  |  | 8 | 11 |  |  |  |  | 06:30:00 |  |  | 06:30:00
 |  |  |  | 9 | 12 |  |  |  |  | 07:30:00 |  |  | 07:30:00
 |  |  |  | 10 | 13 |  |  |  |  | 08:30:00 |  |  | 08:30:00
 |  |  |  | 8 | 12 |  | 8 | 13 |  | 06:30:00 |  |  | 06:30:00
 |  |  |  | 9 | 13 |  | 9 | 11 |  | 07:30:00 |  |  | 07:30:00
 |  |  |  | 10 | 11 |  | 10 | 12 |  | 08:30:00 |  |  | 08:30:00
Spreadsheet: darrell_schoolcraft__7692__Documentation of meter test_calibration
Sheet: Sheet1

 |  | One billion | 1000000000 | [NAME] is equal to
 |  |  | 1000000 | MCF
 |  | One Trillion | 1000000000000 | BTU is equal to
 |  |  | 1000000 | MMBtu
 |  | Error % |  |  |  | 30 day impact | errors to cover 500,000 [NAME]
 |  | 0.01 | 10000 | MMBtu
 |  | 0.005 | 5000 | MMBtu
 |  | 0.0025 | 2500 | MMBtu
 |  | 0.001 | 1000 | MMBtu
 |  | 0.0005 | 500 | MMBtu
 |  | 0.00025 | 250 | MMBtu
 | In / Out indicator | Station Number - Data by meter run please | Station Name | Estimated % error as found -last test & date | Estimated % error as found -previous test & date | [NAME]. Monthly flow | Possible monthly impact |  |  | Comments
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 676397d1588784972-how-can-i-calculate-realised-profits-loss-after-each-sell-trade-date-trading-dashboard
Sheet: Portfolio

Counter | Holding Shares | Average Cost (SGD) | Average Price | Market Price | Unrealised Profit/Loss (SGD/USD) |  |  | Sold Positions (SGD)
 |  |  |  |  | Market Value | Profit/Loss | % | Bought Value | Sold Value | Profit/Loss
BNO |  |  |  | 8.16
SDOW |  |  |  | 33.63
 |  |  |  |  |  | Total
Spreadsheet: 855650d1705155872-how-do-i-add-1-year-to-a-specific-date-once-that-date-has-passed-payment-date-ans-1-
Sheet: Sheet1

 | First term. |  |  | # terms |  | Next term | Next term | Next term
 |  |  |  |  |  | [NAME] | Formula kvsrinivasamurthy | [NAME] HansDouwe
 | 2012-09-14 00:00:00 |  |  | 12
 | 2013-09-14 00:00:00 |  |  | 12
 | 2014-09-14 00:00:00 |  |  | 12
 | 2015-09-14 00:00:00 |  |  | 12
 | 2016-09-14 00:00:00 |  |  | 12
 | 2017-09-14 00:00:00 |  |  | 12
 | 2018-09-14 00:00:00 |  |  | 12
 | 2019-09-14 00:00:00 |  |  | 12
 | 2020-09-14 00:00:00 |  |  | 12
 | 2021-09-14 00:00:00 |  |  | 12
 | 2022-09-14 00:00:00 |  |  | 12
 | 2023-09-14 00:00:00 |  |  | 12
 | 2024-09-14 00:00:00 |  |  | 12
 | 2025-09-14 00:00:00 |  |  | 12
Spreadsheet: 118835d1314038076-excel-2007-vlookup-return-multiple-values-swap-tracker-1-
Sheet: Swap Info

 | Test | Agent 1 | Date | Agent 2 | Date
 | 9 | BOUNDAOUI, MOHAMMED | 2011-09-24 00:00:00 | COULIBALY, AMADOU | 2011-09-25 00:00:00
 |  | GHAZALI, MAHDI | 2011-09-25 00:00:00 | KANSAYE, SEYDOU | 2011-09-26 00:00:00
 |  | NAWALAGUEMBA, YAMEOGO THEOPHANE | 2011-09-26 00:00:00 | LAIHEM, RABAH | 2011-09-27 00:00:00
 |  | NAWALAGUEMBA, YAMEOGO THEOPHANE | 2011-09-27 00:00:00 | HENRY, JUNIOR | 2011-09-28 00:00:00
 |  | OSSETÉ, CEDRIC JOHAN | 2011-09-28 00:00:00 | RAMOUL, KAMEL | 2011-09-29 00:00:00
 |  | [NAME], ZIZINA | 2011-09-29 00:00:00 | MECHID, MOKRANE | 2011-09-30 00:00:00
 |  | [NAME], ZIZINA | 2011-09-30 00:00:00 | [NAME], JEFFREY | 2011-10-01 00:00:00
 | 16 | BOUNDAOUI, MOHAMMED | 2011-09-24 00:00:00 | SAYAD, ILYAS | 2011-09-26 00:00:00
Spreadsheet: 00fbb896-a2ac-4483-a69e-d7171048029e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | CDCS WAIVER EXPENDITURE PLAN | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  |  |  | APPROVED BY:
 |  |  |  |  |  |  | DATE:
Client Name |  |  |  |  | Date of Birth
Case # |  |  | PMI # |  |  | Waiver Type
BUDGET THIS YEAR |  |  | 0 |  | For supports starting |  |  | to
ANNUAL BUDGET
FSE: | CIP |  | MRCI |  |  | LIFEWORKS
 | OTHER
PERSONAL ASSISTANCE (supports for personal care, relief of caregiver, etc.)
ITEM or TYPE OF SERVICE |  |  |  | Rate of Pay     or Cost |  | Annual Total # of Items/Hours/Units: | TOTAL
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  | PERSONAL ASSISTANCE TOTAL | 0
TREATMENT AND TRAINING (supports/services for training, therapy,  etc.)
ITEM or TYPE OF SERVICE |  |  |  | Rate of Pay     or Cost |  | Annual Total # of Items/Hours/Units: | TOTAL
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  | TREATMENT & TRAINING TOTAL | 0
DD/LTC-CDCS-DAK1171 (6/2010)
ENVIRONMENTAL MODIFICATIONS AND PROVISIONS (supplies, equip., special diets, chore serv., etc.)
ITEM or TYPE OF SERVICE |  |  |  | Rate of Pay     or Cost |  | Annual Total # of Items/Hours/Units: | TOTAL
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  | ENVIRONMENTAL MODIFICATIONS AND PROVISIONS TOTAL | 0
SELF DIRECTION SUPPORT ACTIVITIES (FSE fees; payroll costs, office supplies, support planner, etc.)
ITEM or TYPE OF SERVICE |  |  |  | Rate of Pay     or Cost |  | Annual Total # of Items/Hours/Units: | TOTAL
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  | SELF DIRECTION SUPPORT ACTIVITIES TOTAL | 0
 |  |  |  |  |  | Total Personal Assistance | 0
 |  |  |  |  |  | Total Treatment & Training | 0
 |  |  |  |  |  | Total Environmental Modifications & Provisions | 0
 |  |  |  |  |  | Total Self Direction Support Activities | 0
 |  |  |  |  |  | GRAND TOTAL | 0
I have reviewed the CDS Participation Agreement with my social worker/public health nurse and signed it stating I understand my responsibilities under this service option.
 |  |  |  |  |  | _x_Contains an habilitative component (DD waiver only)     _x_Health, Safety and Emergency Plans have been reviewed.
Client/Guardian |  |  |  | Date |  | Social Worker/Public Health Nurse |  |  | Date
CLS/DD&LTC-CDCS-DAK1171 (6/2011)
Spreadsheet: 267297d1380037167-vlookup-between-workbooks-in-excel-2013-workbook1
Sheet: CIS Statements

 |  | Construction Industry Scheme payment and deductions statement
 |  | Date: |  | Statement No. |  |  | CI- | 1001
Contractor Details
 |  | Payment and deduction  made in tax month ending: |  |  |  | Accounts Office Reference
 |  | Accounts office |  |  |  | UTR Number
Sub Contractor Details
 |  | Name/Company name |  |  | Gross amount paid (Excl VAT)
 |  | VLOOKUP to go here
 |  |  |  |  | Less cost of materials
 |  | Address
 |  |  |  |  | Amount liable to deduction
 |  |  |  |  | Amount deducted
 |  | UTR number
 |  |  |  |  | Amount paid to  sub contractor (Excl VAT)
 |  | Verification number
 |  |  | Your tax has been deducted at
Spreadsheet: 860293d1708442865-looking-for-the-exact-value-of-sales-handling-customers-simulation-3
Sheet: Sheet9

customer name | sales name | sales name 1st try |  |  | Sales Data
A |  |  |  |  | Number | Sales name | portion customers
B |  |  |  |  | 1 | aa | 1
C |  |  |  |  | 2 | ab | 3
D |  |  |  |  | 3 | ac | 10
E
F |  |  |  |  | CHECK
G |  |  |  |  | Sales name | portion customers
H |  |  |  |  | aa
I |  |  |  |  | ab
J |  |  |  |  | ac
K
L
M
N
*fill sales name based handling portion
*sales are free to handle any customer
Spreadsheet: 809442d1671094534-combining-if-and-vlookup-functions-scoring-sheet
Sheet: Scoring Sheet

BMI | [NAME] (n) | Push Ups Score  (%)
18 | 30
21 | 12
35 | 20
32 | 6
26 | 13
18 | 10
39 | 9
25 | 2
31 | 0
Spreadsheet: 10eab029-9da5-4681-8b49-4b1496bf523c
Sheet: Sheet1

To determine the amount for private vehicle mileage reimbursement, please fill in the yellow highlighted fields.  Personal reimbursement will be at the Hertz Full Size rate or the Employee Car/Minivan rate, whichever is less.  If no FHSU Motor Pool vehicle or Hertz vehicle is available, $0.56 per mile will be the reimbursement rate.  The traveler is not required to use Hertz as the rental company. | 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 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
[NAME]'s Name:
PR #:
PO #:
Check Applicable:
 | Pretrip Estimate
 | Complete prior to submitting a PR. Form to be retained by department.
 | Actual Expense
 | Complete after traveler returns. Form to be sent to Accounts Payable along with travel receipts.
Number of Days Vehicle is Required:
Total Miles Driven:
KDOT mileage chart: |  |  |  |  |  | http://kdotapp2.ksdot.org/mileagebetweencities/
Return Travel Date: |  |  |  |  |  |  |  |  | Travel Date must be 07/01/13 or later
Reimbursement Calculation
Employee Car/Minivan when [NAME] is available ($0.22 plus estimated fuel per mile) |  |  |  |  | Employee Car/Minivan when [NAME] and [NAME] NOT available ($0.56 per mile) |  |  |  | Hertz Full Size  rate including the Cost of Fuel |  |  |  |  |  | Department may reduce the rate or limit the amount to be reimbursed.
 |  |  |  |  | 0
Vehicle Data
Current Cost of Fuel per Gallon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per gallon
Estimated Miles per Gallon for Rental Full Size |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | miles/gallon
Employee Car/Minivan Rate when Motor [NAME] is available |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per mile
Employee Car/Minivan Rate when [NAME] and Hertz Vehicle NOT available |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.56 | per mile
Hertz Full Size Rate (Unlimited Miles) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.5 | per day
Gas price updated as of |  |  |  |  |  | 2013-12-03 00:00:00
Hertz Contract 37354  Awarded 11-01-12
Comments:
Spreadsheet: 143099d1330196748-subtotal-sample-file2_updated-23feb12
Sheet: Stage 2

CustomerID | OrderDate | ContactFirstName | ContactLastName | BillingAddress | OrderID | Total
13230 | 2010-01-04 00:00:00 | KRAIG | PATTERSON | 185 FRANKLIN STREET N | 30776 | 2295
13230 | 2010-01-04 00:00:00 | KRAIG | PATTERSON | 185 FRANKLIN STREET N | 30776 | 500
13230 | 2010-01-04 00:00:00 | KRAIG | PATTERSON | 185 FRANKLIN STREET N | 30776 | 500
 |  |  |  |  | 30776 Total | 3295
13234 | 2010-01-04 00:00:00 | RICHARD | [NAME] | 248 QUEEN ALEXANDRA ROAD SE | 30791 | 500
13234 | 2010-01-04 00:00:00 | RICHARD | [NAME] | 248 QUEEN ALEXANDRA ROAD SE | 30791 | 500
13234 | 2010-01-04 00:00:00 | RICHARD | [NAME] | 248 QUEEN ALEXANDRA ROAD SE | 30791 | 2295
 |  |  |  |  | 30791 Total | 3295
13235 | 2010-01-04 00:00:00 | CHRIS | MCCOLEMAN | 3218 3RD STREET SW | 30792 | 500
13235 | 2010-01-04 00:00:00 | CHRIS | MCCOLEMAN | 3218 3RD STREET SW | 30792 | 500
13235 | 2010-01-04 00:00:00 | CHRIS | MCCOLEMAN | 3218 3RD STREET SW | 30792 | 2295
 |  |  |  |  | 30792 Total | 3295
 |  |  |  |  | Grand Total | 9885
 | XL '07
 | Highlight the entire table
 | Data tab > Outline group > Subtotal
 | At each change in OrderID
 | Use function [NAME]
 | Add subtotal to Total
Spreadsheet: 150873d1334705101-many-cities-into-few-regions-country-list
Sheet: Sheet1

Albania | Europe
Andorra | Europe |  | Insert Country Here ---> | Latvia
Austria | Europe |  | Obtain Region with formula --->
Belarus | Europe
Belgium | Europe
Bosnia and Herzegovina | Europe
Bulgaria | Europe
Croatia | Europe
Cyprus | Europe
Czech Republic | Europe
Denmark | Europe
Estonia | Europe
Finland | Europe
France | Europe
Germany | Europe
Greece | Europe
Hungary | Europe
Iceland | Europe
Ireland | Europe
Italy | Europe
Latvia | Europe
[NAME] | Europe
Lithuania | Europe
Luxembourg | Europe
Macedonia | Europe
Malta | Europe
Moldova | Europe
Monaco | Europe
Netherlands | Europe
Norway | Europe
Poland | Europe
Portugal | Europe
Romania | Europe
Russia | Europe
[NAME] | Europe
Serbia and Montenegro | Europe
Slovakia (Slovak Republic) | Europe
Slovenia | Europe
Spain | Europe
Sweden | Europe
Switzerland | Europe
Turkey | Europe
Ukraine | Europe
United Kingdom | Europe
Vatican City | Europe
Algeria | Africa
Angola | Africa
Benin | Africa
Botswana | Africa
[NAME] | Africa
Burundi | Africa
Cameroon | Africa
Cape Verde | Africa
Central African Republic | Africa
Chad | Africa
Comoros | Africa
Congo, Democratic Republic of The | Africa
Congo, Republic of | Africa
Cote d'Ivoire | Africa
Djibouti | Africa
Egypt | Africa
Equatorial Guinea | Africa
Eritrea | Africa
Ethiopia | Africa
Gabon | Africa
Ghana | Africa
Guinea | Africa
Guinea-Bissau | Africa
Ivory Coast (Cote d'Ivoire) | Africa
Kenya | Africa
[NAME] | Africa
Liberia | Africa
Libya | Africa
Madagascar | Africa
[NAME] | Africa
[NAME] | Africa
Mauritania | Africa
[NAME] | Africa
Morocco | Africa
Mozambique | Africa
Namibia | Africa
[NAME] | Africa
Nigeria | Africa
Rwanda | Africa
Sao Tome and Principe | Africa
Senegal | Africa
Seychelles | Africa
Sierra Leone | Africa
Somalia | Africa
South Africa | Africa
Sudan | Africa
Swaziland | Africa
Tanzania | Africa
The Gambia | Africa
Togo | Africa
Tunisia | Africa
Uganda | Africa
Zambia | Africa
Zimbabwe | Africa
Spreadsheet: 675537d1588346865-conditional-drop-down-auto-fill-option-is-this-possible-competitor-autofill
Sheet: Market Share by Competitor

 |  | Market Share by Competitor
 |  |  |  |  |  | [NAME] is Autofill from Source Data Tab
 |  | Service Area
 |  | Competitor | Est Sales | Share
TOP
Competitor |  | PHC
 |  |  |  |  |  | Hydraulic IND | Pneumatic | Fluid  Connectors
#1 |  | Would like for drop down options
#2 |  | to select using data from columns on
#3 |  | the right, which would be based on the |  |  |  | ABC Company | 123 Connect | ABC Company | 123 Connect
#4 |  | autopopulated data from C2 (which is |  |  |  | DEF Company | 456 Fluid | DEF Company | 456 Fluid
 |  | pulled from Data Source Tab |  |  |  | HIJ Inc. | 789 Tools | HIJ Inc. | 789 Tools
 |  |  |  |  |  | [NAME] | 0 Mfg. | [NAME] | 0 Mfg.
 |  |  |  |  |  | NOP Express |  | NOP Express
 |  |  |  |  |  | QRS Inc. |  | QRS Inc.
 |  |  |  |  |  | TUV Organization |  | TUV Organization
 |  |  |  |  |  | WXY LLC |  | WXY LLC
 |  |  |  |  |  | Z Corporation |  | Z Corporation
 |  | OTHER
 |  | TOTAL
Spreadsheet: tracy_geaccone__40490__OM Schedule - IT 1
Sheet:  Normalized for O&E

DIRECT  O & M COSTS  WITH 2001 NORMALIZED FOR O&E
2002 - 2004 PLAN
INFORMATION TECHNOLOGY
( $ In Millions)
 |  |  |  | 2000 Actuals |  |  |  |  |  |  |  |  |  | Restated 2001 Plan (3) |  |  |  |  |  |  |  |  |  | 2001 2nd Current Estimate (2,3) |  |  |  |  |  |  |  |  |  | 2002 Plan
 |  |  |  |  |  | Project |  |  |  |  |  |  |  |  |  | Project |  |  |  |  |  |  |  |  |  | Project |  |  |  |  |  |  |  |  |  | Project
 |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  | Gross O&M
 |  |  |  | Gross |  | Capital |  | Capital |  | Allocations |  | Net |  | Gross |  | Capital |  | Capital |  | Allocations |  | Net |  | Gross |  | Capital |  | Capital |  | Allocations |  | Net |  | Gross |  | Capital |  | Capital |  | Allocations |  | Net |  | % O(U)
Department |  |  |  | O & M |  | O & M |  | O & M |  | In/(Out) |  | O & M |  | O & M |  | O & M |  | O & M |  | In/(Out) |  | O & M |  | O & M |  | O & M |  | O & M |  | In/(Out) |  | O & M |  | O & M |  | O & M |  | O & M |  | In/(Out) |  | O & M |  | 2000 Plan
NNG |  |  |  | 12.7 |  | 1.3 |  |  |  |  |  |  |  |  |  | 0.4 |  |  |  | -0.1 |  |  |  |  |  | 0.4 |  |  |  | -0.1
TW |  |  |  | 4 |  | 0.4 |  |  |  |  |  |  |  |  |  | 0.1 |  |  |  | -0.1 |  | 3.5 |  |  |  | 0.1 |  |  |  | -0.1 |  |  |  |  |  | 0.1
Citrus |  |  |  | 6.3 |  | 0.2 |  |  |  |  |  |  |  |  |  | 0.4 |  |  |  | -0.1 |  | 5.8 |  |  |  | 0.4 |  |  |  | -0.1 |  |  |  |  |  | 0.1
Northern Border Partners (1) |  |  |  | 0.3
EOTT (Co 1195) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3 |  | 1.2 |  |  |  |  |  |  |  | 0.3 |  | 1.2 |  |  |  |  |  |  |  |  |  | 1.5
[NAME]
Enron Construction Services
EAMR
ETS
Other * |  |  |  | 5.9 |  | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.3 |  |  |  |  |  |  |  |  |  | 2.3 |  |  |  |  |  |  |  |  |  | 1.2
Total Direct
(1)  Not included - NBP submits their own schedule.  (These costs are NPNG.)
(2)  $.6 increase in expense over 2001 Plan due to Data Center move to new building.  ($1.3MM Capital Expenditures savings)
(3)  2001 "Other" includes HPL.
* Companies outside of ETS
Spreadsheet: phillip_m_love__30153__9904_OA
Sheet: TX-HPL-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  HPL
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  |  |  |  |  | June |  |  |  |  |  | September |  |  |  | November |  | December |  | 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 | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -7916 | -13398.62
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
14 |  | Cash Out
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: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7916 | 13900.5
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 |  |  |  |  |  |  |  |  |  | -4442
 | 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: 748739d1632320073-work-out-daily-amount-to-target-31-day-figures
Sheet: 13th

 |  |  |  | TURNOVER |  |  |  |  | REVENUE
 | AREA 3 |  |  | Target | Needed Daily | Actual | [NAME] |  | Target | Needed Daily | Actual | [NAME] |  | [NAME]'s | ATV |  | [NAME] | SALT £ |  | TMC |  | BB+ |  | Errors
 | Asda - Aintree
 | Asda - Huyton
 | Asda - Hunts Cross
 | Asda - Horwich
 | Asda - Leigh
 | Asda - Burnley
 | Asda - Westbrook
 | Asda - Widnes
 | Asda - Bromborough
 | Asda - Accrington
 | Asda - Colne
 | Asda - Clayton Green
 | Asda - Runcorn
 | Asda - Blackburn
 | Asda - Walton
 | Asda - Blackpool
 | Asda - Wigan
 | Asda - Preston
Spreadsheet: 01e38e64-4233-491f-b04f-6e4cc04b2cf3
Sheet: variable description

Variable list (for Alabama) | Variable Definition | Used in This Study
ALAB_CONFED | dummy variable if part of Old South | yes
[NAME] | manufacturing employment | yes
ALAB_MANEMPC | manufacturing employment weighted in adjacent states | yes
ALAB_MANU1947 | manufacturing incomes in 1947 | yes
ALAB_MANUELAS | an elasticity measurment of changes to manufacturing | no
ALAB_MANUINC | manufacturing incomes (total) | yes
ALAB_MANUINCC | manufacturing incomes weighted in adjacent states | yes
ALAB_PERUNION | percent union participation | no
ALAB_PI | personal income | yes
ALAB_PIC | personal income weighted in adjacent states | yes
ALAB_POP | population | no
ALAB_POPC | population weighted in adjacent states | no
ALAB_RESIDADJ | residence adjustment of income | no
ALAB_RESIDADJC | residence adjustment of income wieghted in adjacent states | no
ALAB_RTW | dummy variable for RTW legislation | yes
ALAB_RTWC | dummy variable for RTW legislation weighted in adjacent states | no
ALAB_RTWCONFEDENDOG | endogeneity derived error term for old south | yes
ALAB_RTWF | forecast of rtw (for panel share estimation) | yes
ALAB_SPEMP | spatial employment variable | no
ALAB_TRANSPINC | transportation sector incomes | no
ALAB_TRANSPINCC | transportation sector incomes weighted in adjacent states | no
note: adjacent weighted variables are the calculated elements of the state level spatial correction (see equation and table 2 in study
note:  non panel variables (e.g. consumer price index) and derived variables (autoregression, trend, errors and intercepts) not included here.