tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 169182d1342717173-need-help-in-replacing-text-replace
Sheet: Sheet1

what I have | what I want |  |  | Word to replace | category
 |  |  |  | new york | city
atlanta football GA | city game state |  |  | atlanta | city
new york rugby | city game |  |  | ga | state
wwe chicago il | game city state |  |  | chicago | city
 |  |  |  | wwe | game
 |  |  |  | football | game
 |  |  |  | rugby | game
I want each word to convert into its category given in E and F column
currently I am doing ctrl+h and replace each word one by one
can any one help me to suggest me any formula to do so ?
I need the formula to find the word given in column E, from column A
and replace it with the given category in column F
Spreadsheet: 487006d1477849239-table-calling-lists-of-variant-sizes-and-with-duplicate-values-example
Sheet: Sheet2

 |  | Name |  |  |  |  |  | Type | Mod | Pwr |  | Effect |  |  |  | Lv | R | M | PP |  | Name:  User entered entry.
 |  |  |  |  |  |  |  | Zeta |  |  |  |  |  |  |  |  |  |  |  |  | Type:  This is the part that matters.  They select one of the items from a dropdown menu,
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | when should then be used by the cells below to automatically fill with the lists below those
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | options from Sheet 1.  For the sake of the example, I'm using greek letters.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:  Displays different text based on what's in the Type section.  I can do this easy enough.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pwr, Effect, [NAME], R, M, PP:  Not required for this example.
Spreadsheet: 36b4807f-b2cc-4aa6-81ed-15b4bd915fb7
Sheet: 2002-03

Table F
Student Numbers by [NAME] and Method of Study
2002-03
 | Full Time |  |  | Part Time |  |  | Total
 | Male | Female | Total | Male | Female | Total | Male | Female | Total
Undergraduate | 5372 | 6030 |  | 172 | 95 |  | 5544 | 6125
%
Graduate | 2216 | 2305 |  | 1130 | 1017 |  | 3346 | 3322
%
Total
Spreadsheet: 196537d1354033277-pulling-information-from-one-sheet-to-another-trackingphys
Sheet: Jan Phys,CDLs (2)

Physical | 2013-02-01 00:00:00
B-Date | BD-YR | Code | Truck | FMT | Driver / length of last phys | Cell # | 45 days | 15 Days | Phy Exp | Appointment |  | I need all Physicals, CDLs and [NAME] that are before (But
2012-01-02 00:00:00 | 1950 | 6910 | 1134 | Mitch | [NAME] | 1800-67563 |  |  | 2013-01-02 00:00:00 |  |  | not equal to) the date of 2/1/13.
2012-01-03 00:00:00 | 1961 | 60194 | 1192 | Mitch | [NAME] | [PHONE] |  |  | #N/A
CDL |  | Code | Truck | FMT | Driver | Cell # | 45 days | 15 Days | CDL Exp# | Appointment
 |  | 60194 | 1192 | Mitch | [NAME] | [PHONE] |  |  | 2012-01-23 00:00:00
[NAME] |  | Code | Truck | FMT | Driver | Cell # | 45 days | 15 Days | HM Exp. | Has Disk
 |  | 6087 | 1241 | Brent | [NAME] | [PHONE] |  |  | 2013-01-03 00:00:00
Spreadsheet: david_delainey__8062__Sweetwater_129 MW_13June00_Breakeven
Sheet: Merchant

 | Discount Rate
 | PV(Market [NAME]) | PV(Contract Price) | PV(Green Premium) | FMV(Project) | Cost(Project) | Total
Spreadsheet: 752099d1634579679-find-the-index-of-substring-in-whole-string-in-one-cell-lookup-occurences
Sheet: LookUp_Result

 |  | Lookup | ResultValue | TableName
 |  | Vn_Input_HANA_Deployment_Description |  | DeploymentsMap
 |  | Vn_Input_Oracle_Deployment_Description |  | DeploymentsMap
 |  | Vn_Comp_WebDispatcher_Server_Vendor |  | DeploymentsMap
 |  | Vn_Comp_HANA_Server_Vendor |  | DeploymentsMap
 |  | Vn_Input |  | DeploymentsMap
Spreadsheet: 100637d1298944735-excel-2007-max-and-hlookup-problems-max-and-hlookup
Sheet: Summary

Site | [NAME] | Month | Should Be
[NAME] |  |  | 2011-05-11 00:00:00
[NAME] |  |  | 3/11 or 5/11
[NAME] |  |  | 2011-04-11 00:00:00
[NAME] |  |  | 2011-02-11 00:00:00
[NAME] |  |  | 2011-05-11 00:00:00
Spreadsheet: 107075d1304261130-excel-2007-pick-n-largest-values-and-return-subsequent-data-media_vs_return_condensed
Sheet: portfolio

portfolio return
 |  |  |  | ??
05/96
06/96
07/96
08/96
09/96
10/96
11/96
12/96
01/97
02/97
03/97
04/97
05/97
06/97
07/97
08/97
09/97
10/97
11/97
12/97
01/98
02/98
03/98
04/98
05/98
06/98
07/98
08/98
09/98
10/98
11/98
12/98
01/99
02/99
03/99
04/99
05/99
06/99
07/99
08/99
09/99
10/99
11/99
12/99
01/00
02/00
03/00
04/00
05/00
06/00
07/00
08/00
09/00
10/00
11/00
12/00
01/01
02/01
03/01
04/01
05/01
06/01
07/01
08/01
09/01
10/01
11/01
12/01
01/02
02/02
03/02
04/02
05/02
06/02
07/02
08/02
09/02
10/02
11/02
12/02
01/03
02/03
03/03
04/03
05/03
06/03
07/03
08/03
09/03
10/03
11/03
12/03
01/04
02/04
03/04
04/04
05/04
06/04
07/04
08/04
09/04
10/04
11/04
12/04
01/05
02/05
03/05
04/05
05/05
06/05
07/05
08/05
09/05
10/05
11/05
12/05
01/06
02/06
03/06
04/06
05/06
06/06
07/06
08/06
09/06
10/06
11/06
12/06
01/07
02/07
03/07
04/07
05/07
06/07
07/07
08/07
09/07
10/07
11/07
12/07
01/08
02/08
03/08
04/08
05/08
06/08
07/08
08/08
09/08
10/08
11/08
12/08
01/09
02/09
03/09
04/09
05/09
06/09
07/09
08/09
09/09
10/09
11/09
12/09
01/10
02/10
03/10
04/10
05/10
06/10
07/10
08/10
09/10
10/10
11/10
12/10
01/11
02/11
03/11
Spreadsheet: 100874d1299095055-multiple-conditions-on-data-validation-datavalidaton_problem
Sheet: Database

 | Feeling | Category | Brand
 | Positive | [NAME] | Brand1
 | Neutral | Cat.2 | Brand2
 | Negative | Cat.3 | Brand3
 | Warning | Cat.4 | Brand4
 |  | Cat.5 | Brand5
 |  |  | Brand6
 |  |  | Brand7
 |  |  | Brand8
 |  |  | Brand9
 |  |  | Brand10
 | Brand 1 Topic | Brand 1 Topic2 | Brand 1 Topic3
 | [NAME] | [NAME] | Bolivia
 | Asia | Chile | Colombia
 | Europe | Peru | Suriname
 | [NAME] | Argentina | Guatemala
 |  | South Korea | Japan
 |  | Cingapure | China
 |  | Camboja | USA
 |  | Tayland | Canada
 |  | India | Mexico
 |  | Korea
 |  | Switzerland
 |  | Sweden
 | Brand 2 Topic | Brand 2 Topic2 | Brand 2 Topic3
 | [NAME] | [NAME] | Argentina
 | Asia | Tayland
 | [NAME] | Alaska
 |  | Mexico
 |  | Canada
 |  | USA
 | Brand 3 Topic | Brand 3 Topic2 | Brand 3 Topic3
 | [NAME] | Argentina | Mexico
 | Asia | Peru | Canada
 | Europe | China
 | [NAME] | USA
 |  | Canada
 |  | Mexico
 | Brand 4 Topic | Brand 4 Topic2 | Brand 4 Topic3
 | [NAME] | [NAME] | Germany
 | Asia | Peru
 | Europe | Colombia
 | [NAME] | Chile
 |  | China
 |  | Korea
 |  | USA
 | Brand 5 Topic | Brand 5 Topic2 | Brand 5 Topic3
 | [NAME] |  | Japan
 | Asia |  | UnitedKingdom
 | Europe |  | Candada
 | [NAME] |  | Mexico
 | Sustentabilidade |  | Australia
 | Business |  | NewZealand
 |  |  | Tuvalu
 |  |  | Fiji
 |  |  | Madagascar
 | Brand 6 Topic | Brand 6 Topic2 | Brand 6 Topic3
 | [NAME] | Japan | France
 | Asia | China | USA
 | Europe | India
 | [NAME] | Korea
 |  | Canada
 |  | Mexico
 | Brand 7 Topic | Brand 7 Topic2 | Brand 7 Topic3
 | [NAME] | Peru
 | Asia | Colombia
 | Europe | Chile
 | [NAME] | [NAME]
 |  | USA
 | Brand 8 Topic | Brand 8 Topic2 | Brand 8 Topic3
 | [NAME] | [NAME] | USA
 | Asia | Chile
 | Europe | Japan
 | [NAME] | China
 |  | India
 |  | Mexico
 | Brand 9 Topic | Brand 9 Topic2 | Brand 9 Topic3
 | [NAME] | Mexico | USA
 | Asia
 | Europe
 | [NAME]
 | Brand 10 Topic | Brand 10 Topic2 | Brand 10 Topic3
 | [NAME] |  | Japan
 | Asia |  | Korea
 | Europe |  | China
 | [NAME] |  | Australia
 | CentralAmerica
 | Oceania
Spreadsheet: 876903d1723624821-how-to-convert-decimal-into-degree-hours-minutes-seconds-ship-dr
Sheet: DR

 | DEAD  RECKONING  ( WGS-84 )
 | Wpt. No. | DEP. LAT. 1 |  | DEP. LON. 2 |  | INPUT | INPUT | ARR. LAT: 2 |  | ARR. LON: 2
 |  |  |  |  |  | COURSE | DISTANCE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LAT1 | LONG1 | COS CO |  | LAT2 | LAT2 | MP1 | MP2 | DMP | TAN CO | DLO | LONG2 | LONG2 |  | LAT. ANSWER |  | LONG. ANSWER
 | NO. | 40.5029 | N | 133.3578 | e | 0 | 11.5
 | 1 |  |  |  |  | 0 | 11.5
 |  |  |  |  |  | 100 | 11
 |  |  |  |  |  | 200 | 11
 |  |  |  |  |  | 0 | 11
 |  |  |  |  |  | 0 | 11
 |  |  |  |  |  | 0 | 11
 |  |  |  |  |  | 0 | 11
 |  |  |  |  |  | 0 | 11
 |  |  |  |  |  | 0 | 11
 |  |  |  | TOTAL  DISTANCE
Spreadsheet: 2d74a519-a72a-497f-987a-aabd0c7906b7
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
82266 | Test | 82266 | KIT, Immunostain | KIT, Immunostain | Includes pathology consultation charged separately. | Varies: Var |  |  |  | Varies | This is not an orderable test. Order 5434 Hematopathology Consultation or 5439 Surgical Pathology Consultation. The consultant will determine the need for special stains. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | This request will be processed as a consultation. An interpretation will be provided. | Monday through Friday |  |  | 1 | 88342 |  |  |  |  | Rochester
82266 | [NAME] | MIXED | Mixed |  |  |  | Ambient
82266 | Result | 82266 | KIT, Immunostain | KIT, Immunostain |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40552-2
Spreadsheet: 489999d1479554512-football-predictions-football-predictions
Sheet: Week 5

Fixtures | Week 5 |  |  |  |  | Player Scores
Home Team | Score |  |  | Away Team |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Damian West | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Chelsea |  | - |  | Liverpool |  | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 5 | 0 | 0
Hull City |  | - |  | Arsenal |  | 2 | 2 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Leicester City |  | - |  | Burnley |  | 0 | 2 | 2 | 2 | 5 | 2 | 2 | 2 | 2 | 0 | 5 | 2 | 5 | 2 | 2 | 2 | 2 | 2 | 2 | 0
Manchester City |  | - |  | Bournemouth |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 2 | 2 | 5 | 2 | 2 | 2 | 2
West Brom |  | - |  | West Ham |  | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Everton |  | - |  | Middlesbrough |  | 2 | 2 | 2 | 5 | 2 | 2 | 0 | 2 | 5 | 0 | 2 | 2 | 5 | 5 | 2 | 2 | 2 | 2 | 2 | 2
Watford |  | - |  | [NAME] |  | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Crystal Palace |  | - |  | Stoke City |  | 2 | 2 | 0 | 2 | 2 | 2 | 0 | 0 | 2 | 0 | 0 | 2 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0
Southampton |  | - |  | Swansea City |  | 5 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 2 | 2 | 0 | 2 | 0 | 0 | 5 | 0 | 5 | 0
Tottenham |  | - |  | Sunderland |  | 2 | 5 | 2 | 2 | 2 | 2 | 0 | 2 | 2 | 0 | 2 | 2 | 2 | 5 | 5 | 2 | 2 | 2 | 2 | 2
Home Team | Score |  |  | Away Team | Weekly Total
Chelsea | 1 | - | 2 | Liverpool |  | 1-1 | 2-2 | 2-2 | 1-2 | 2-2 | 2-1 | 1-1 | 2-1 | 2-2 |  | 2-1 | 2-1 | 1-2 | 2-1 | 2-1 | 2-1 | 1-1 | 1-2 | 2-0 | 2-1
Hull City | 1 | - | 4 | Arsenal |  | 1-2 | 1-3 | 1-2 | 1-3 | 1-2 | 2-2 | 1-2 | 0-2 | 1-2 |  | 0-3 | 0-2 | 0-3 | 0-2 | 0-3 | 1-3 | 0-2 | 1-2 | 0-3 | 0-2
Leicester City | 3 | - | 0 | Burnley |  | 1-1 | 1-0 | 1-0 | 2-0 | 3-0 | 1-0 | 2-0 | 2-0 | 2-0 |  | 3-0 | 2-1 | 3-0 | 2-0 | 2-1 | 2-1 | 2-1 | 2-1 | 1-0 | 1-1
Manchester City | 4 | - | 0 | Bournemouth |  | 3-0 | 2-0 | 3-1 | 4-1 | 4-1 | 3-1 | 5-0 | 3-0 | 4-1 |  | 4-1 | 3-0 | 2-1 | 3-0 | 4-1 | 4-0 | 3-1 | 3-1 | 3-0 | 3-0
West Brom | 4 | - | 2 | West Ham |  | 1-1 | 2-1 | 1-2 | 2-0 | 1-1 | 1-1 | 1-3 | 1-1 | 2-1 |  | 1-1 | 1-1 | 2-1 | 1-1 | 1-1 | 1-1 | 1-2 | 0-2 | 1-1 | 0-1
Everton | 3 | - | 1 | Middlesbrough |  | 2-1 | 2-0 | 2-0 | 3-1 | 2-1 | 1-0 | 1-2 | 2-1 | 3-1 |  | 2-0 | 2-1 | 3-1 | 3-1 | 2-0 | 2-1 | 2-1 | 2-0 | 2-1 | 2-0
Watford | 3 | - | 1 | [NAME] |  | 0-2 | 1-2 | 1-2 | 1-3 | 2-1 | 2-2 | 0-2 | 0-1 | 2-1 |  | 0-3 | 1-1 | 2-2 | 0-2 | 1-2 | 0-3 | 0-2 | 0-2 | 0-2 | 0-2
Crystal Palace | 4 | - | 1 | Stoke City |  | 1-0 | 2-1 | 0-2 | 2-0 | 1-0 | 2-0 | 0-0 | 1-1 | 2-0 |  | 1-1 | 1-0 | 2-0 | 0-0 | 0-0 | 2-1 | 1-1 | 1-2 | 1-1 | 1-2
Southampton | 1 | - | 0 | Swansea City |  | 1-0 | 1-2 | 3-1 | 1-1 | 1-1 | 1-1 | 1-1 | 2-1 | 2-1 |  | 2-1 | 2-0 | 1-2 | 2-1 | 2-2 | 1-1 | 1-0 | 1-1 | 1-0 | 1-1
Tottenham | 1 | - | 0 | Sunderland |  | 2-1 | 1-0 | 3-0 | 2-0 | 3-1 | 2-0 | 0-1 | 2-0 | 3-0 |  | 2-0 | 3-1 | 3-0 | 1-0 | 1-0 | 3-1 | 2-0 | 2-0 | 3-1 | 2-0
Spreadsheet: 79015d1279250966-excel-2007-transposing-3-columns-into-multiple-columns-excel-forum-transpose-data
Sheet: Sheet1

Name | Subject | dfgs
[NAME], [NAME] | Art&Des | B
[NAME], [NAME] | CreatArt | A
[NAME], [NAME] | D&T | A
[NAME], [NAME] | English | A
[NAME], [NAME] | Geography | A*
[NAME], [NAME] | History | A
[NAME], [NAME] | Hu'ties | A
[NAME], [NAME] | ICT | A
[NAME], [NAME] | Maths | A*
[NAME], [NAME] | MFL | A
[NAME], [NAME] | PE | A
[NAME], [NAME] | Science | A*
Allman, [NAME] | Art&Des | C
Allman, [NAME] | CreatArt | B
Allman, [NAME] | D&T | C
Allman, [NAME] | English | C
Allman, [NAME] | Geography | C
Allman, [NAME] | History | C
Allman, [NAME] | Hu'ties | C
Allman, [NAME] | ICT | C
Allman, [NAME] | Maths | C
Allman, [NAME] | MFL | C
Allman, [NAME] | PE | B
Allman, [NAME] | Science | B
[NAME],Mary | Art&Des | A
[NAME],Mary | CreatArt | A
[NAME],Mary | D&T | A
[NAME],Mary | English | A
[NAME],Mary | Geography | A
[NAME],Mary | History | A
[NAME],Mary | Hu'ties | A
[NAME],Mary | ICT | B
[NAME],Mary | Maths | C
[NAME],Mary | MFL | B
[NAME],Mary | PE | B
[NAME],Mary | Science | B
Spreadsheet: errol_mclaughlin_jr__10312__BOOKREQUEST-NGPriceCrude
Sheet: Sheet1

From: | Risk Analysis and Reporting
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: |  |  | Risk Management
Subject: | New Book Request (to set up book in RisktRAC)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  |  |  | IT SECURITY | Reporting -Subledger
 |  |  | Internal | External | Both | Book Mapping |  |  |  |  |  |  |  |  |  |  | Book
 | Short Name | [NAME] | Transactions | Transactions | Transactions | Code | Region | P | B | Idx | [NAME] | PHY | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason for Book | Administrator* | MTM | Prud | Realized
 | NG-Price | Natural Gas Price (Non-Affiliate) |  |  | x |  |  | x |  |  |  |  | WTI/Bbls/USD | [NAME] | MTM | Trader start trading crude | See Below
 | FIN-ECTI-ENERGY | Financial ECTI-Energy |  |  |  | I7 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-PROP | Financial ECTI-Prop |  |  |  | I8 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-ST | Financial ECTI-ST |  |  |  | I3 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FINLAND-JV-.2GO | Finland JV GASOIL.2 |  |  |  | QM | DESK | X | - | - | - |  | TN10/CNTR/USD
 | UK-FO-LSSR | UK -Fuel Oil-LSSR |  |  |  | V# | DESK | X | - | - | - |  | TN10/CNTR/USD
 | (Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag
 | Please provide a list of the people who need access to the above book(s).
 | ***'Please provide login names for book administrators.***
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Brent Price
 | Access List: | emclaug
 |  | [NAME]
 |  | bbajwa
 | BOOK WILL NOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
 | For questions, call:
 | [NAME] (x57197)
 | [NAME] (x31462)
 | [NAME] ([NAME])
 | [NAME] (x33102)
Spreadsheet: 811993d1672908917-autofill-with-if-formula-if-formula
Sheet: Sheet1

 |  |  | [NAME] | Grade | BC | Ket |  |  | SOURCE  IF | TEXT
THE RESULT I WANT (AUTO FILL) |  |  | MPS FARM 2 |  |  |  |  |  | FARM 1 | MPS FARM 1
 |  |  |  |  |  |  |  |  | FARM 2 | MPS FARM 2
 |  |  | "+IF() |  |  |  |  |  | Farm 1 | MIX MPS FARM 1 AND FARM 2
 |  |  |  |  |  |  |  |  | Farm 2 | MIX MPS FARM 1 AND FARM 2
 |  |  |  |  |  |  |  | I ENTER THE TEXT HERE FROM D4:D12
 |  |  | [NAME] | Grade | BC | Ket |  |  | [NAME] | Grade | BC | Ket
THE RESULT I WANT |  |  | MPS FARM 1 |  |  |  |  | THE RESULT I WANT | MIX MPS FARM 1 AND FARM 2
Spreadsheet: benjamin_rogers__1039__Consolidated 6 Peaker-051800
Sheet: New Albany

INCOME STATEMENT - NEW ALBANY
('000 $)
Revenue
Fixed Price Period: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Demand Payment
Energy Payment
Block Payment
Amortization of Contract
Market Price & Price Extension Period:
Demand Payment | 0 | 0 | 0
Variable Revenue | 0 | 0 | 0
Energy Margin | 0 | 0 | 0
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major Maintenance & Ongoing Capex
O&M Management Fee
Owner's Expense
Property Taxes Liability | 487.9 | 486.5 | 484.5 | 476.4 | 467.3 | 451.3 | 427.8 | 402.5 | 362.4 | 878.3 | 695.3 | 494 | 365.9 | 365.9 | 365.9 | 365.9 | 365.9 | 365.9 | 365.9
Franchise Tax
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
After Tax Book Income
CASH FLOW - NEW ALBANY
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
EBITDA less Contract Amortization
Plus Property Tax Liability
Less Property Tax Expense | -488.8
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense)
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
STATE TAX & FRANCHISE TAX - NEW ALBANY
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
FRANCHISE TAX
Paid-In-Capital
[NAME]
Outstanding Debt
Shareholders Equity & Long Term Debt
State Franchise Tax Rate
State Franchise Tax Liability | 414.3754644834614 | 400.7862389008276 | 388.4668615063393 | 366.8114912546404 | 345.9142323799888 | 325.7785152908148 | 305.9668527678614 | 286.7409647515161 | 267.954046548113 | 248.1815847959205 | 230.0231638100639 | 211.7493920166792 | 193.1738093263 | 174.2458988093398 | 155.2676893345956 | 140.8014093229252 | 130.7920492951862 | 120.7800196409608 | 110.7667673458902 | 100.7541148292862
STATE TAXES
Pretax Book Income less Contract Amortization
Plus Book Depreciation & Amortization
Less Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs
Spreadsheet: james_steffes__12858__View on CA DA extend & add
Sheet: Sheet1

 |  |  |  | DIRECT ACCESS SUSPENSION ANALYSIS
 |  |  | Contract Modification |  | Add Facilities under Existing Deals
 |  |  | No DASR Required (1,2) |  | DASR Required
 |  |  | Modification | Survive PUC review? | Addition terms | Prevail at PUC? (3)
 |  |  | Price change only | 0.85 | No caps on add volumes | 0.15
 |  |  | Blend & Extend (4) | 0.35 | Caps on add volumes,e.g., 2-5% | 0.5
 |  |  | Other nonterm changes | 0.85
Note: We haven't yet seen the utilities filings, which are scheduled to be filed this Friday; thus, probabilities are subject to change.
(1) In order to protect original contracts from the PUC, assumes that all contract modifications are separate amendments to original contracts,
rather than modifications to the original contract. Edison has said it does not intend to review contracts.
(2) Probabilities refer to whether contract modifications would survive PUC scrutiny if the PUC or another agency (e.g., AG) decides to examine customer contracts.
(3) [NAME] is proposing that the Commission suspend all new DASR "connects," including facility additions under existing contracts.
(4) EES' contracts roll-off according to the following schedule (Source: [NAME])
 |  |  | EES Cumulative Contract Roll-off
 |  |  | PG&E | Edison
 |  |  | Nominal MWHs | Nominal MWHs
 |  | 12.31.02 | 0.4 | 0.49
 |  | 12.31.03 | 0.62 | 0.74
 |  | 12.31.04 | 0.72 | 0.86
Spreadsheet: 0a1dca1b-0906-4862-9446-a84b9bfd9335
Sheet: Sheet1

Присъствието на датата на  изпита е задължително за всички (освободени и неосвободени) | Unnamed: 1 | Unnamed: 2
Предварителни оценки по  [NAME] на човешките ресурси
Мениджмънт на туристически услуги Р
Курс: 2
Фак. номер | Име | оценка
09050036 | СИМОНА  ПЛАМЕНОВА  ПЕТКОВА | 6
09050057 | ШЕФКЕТ  РАХМАН  ДАУТ | 5
10050001 | СЛАВИ  ГЕОРГИЕВ  НЕДЕЛЧЕВ | 6
10050003 | РАДОСЛАВ  ДИМОВ  ХУБЕНОВ
10050007 | ГЕОРГИ  [NAME]  ПАНОВ
10050008 | ПЛАМЕНА  ГЕНЧЕВА  ГРУДЕВА | 6
10050010 | МИЛЕНА  БОЖИДАРОВА  БОЙНОВА
10050011 | СТОЯНКА  МИХАЙЛОВА   МИХАЙЛОВА
10050012 | ВАСИЛ   АНГЕЛОВ  МАРКОВСКИ
10050013 | ВАНИНА  НИКОЛОВА  ЧАВДАРОВА | 6
10050014 | ЕВГЕНИЯ  ИВАЙЛОВА  ЗАХАРИЕВА
10050015 | СВЕТЛАНА  СПАСОВА  АЛЕКСАНДРОВА
10050018 | НИКОЛА   ИВАНОВ  ТОДОРОВ
10050019 | ХРИСТО  НЕНОВ  НЕНОВ
10050022 | СТАНКО  ДИМИТРОВ  СТОЙЧЕВ
10050024 | МАРИЯ  ТОДОРОВА  СТАМАТОВА
10050025 | ВИОЛЕТА  СТЕФАНОВА  СИРАКОВА | 6
10050026 | КРИСТИНА  ИЛИЕВА  КОЦЕВА | 6
10050027 | КРАСИМИР  ДИМИТРОВ  МИХАЙЛОВ
10050029 | ДЕЯН  АНДРЕЕВ  ПАВЛОВ
10050030 | [NAME]  ИВАНОВ  ЧОРОЛЕЕВ
10050031 | ВАНГЕЛ  АНАСТАСОВ  АПОСТОЛОВ | 6
10050032 | ЦВЕТЕЛИНА  ИВАНОВА  МИЦЕВА
10050034 | МАРТИН  НИКОЛАЕВ  БЕНОВ
10050035 | РОСИЦА  ИВАНОВА  ЦАНЕВА | 6
10050036 | СРЕБРИНА  ВЛАДИМИРОВА  БОЯДЖИЕВА
10050039 | ВАЛЕНТИНА  ЕСКОВА  АСАНСКА | 5
10050041 | ИВАЙЛО  ГЕОРГИЕВ  ГЕОРГИЕВ | 5
10050042 | ТЕОДОРА  ИВАНОВА  БЪМБИНА
10050043 | ГЕОРГИ  НИКОЛАЕВ  ДЕНИШЕВ
10050045 | ТЕОДОР  ЯНКОВ  ТОДОРОВ
10050046 | СТОЯНКА  ЙОРДАНОВА  ДИМИТРОВА | 6
10050047 | СУЗАНА  МИЛЕНОВА  БОРИСОВА | 5
10050048 | ПЕТЯ  ДЕЛЧЕВА  ДЕЛЧЕВА
10050051 | ВАКЛИН  ВАЛЕНТИНОВ  ПИРИНСКИ
10050052 | ИЛИАН  ИЛИЕВ  ЦУЛИН
10050053 | ТАНЯ  ЯНКОВА  ЯНКОВА | 6
10050054 | АЛЕКСАНДЪР  АТАНАСОВ  ЧОБАНОВ | 6
10050055 | ГЕОРГИ  ВАСКОВ  СТОИМЕНОВ
10050056 | ЮЛИЯ  ХРИСТОВА  КАЗАКОВА
10050058 | ТЕОДОРА  СТОЯНОВА  МАНЧЕВА | 5
Spreadsheet: 0222888d-a7ea-4243-a6d7-16eff47a4767
Sheet: Sheet1

1 | 4 | 4 | 208 | 7 | -31
2 | 29 | 29 | 183 | -16 | -105
3 | 5 | 5 | 180 | 31 | -56
4 | -30 | -30 | 226 | -8 | -42
5 | 5 | 5 | 162 | -16 | -30
6 | 11 | 11 | 192 | 19 | -47
7 | 7 | 7 | 90 | 11 | -26
8 | 12 | 12 | 178 | -15 | -32
9 | 9 | 9 | 120 | 0 | -37
10 | -3 | -3 | 224 | 1 | -37
11 | -2 | -2 | 173 | 13 | -35
12 | -9 | -9 | 214 | -12 | -36
13 | 8 | 8 | 240 | 8 | -18
14 | 16 | 16 | 228 | 13 | -39
15 | -6 | -6 | 247 | -5 | -15
16 | -6 | -6 | 175 | 3 | -21
17 | 8 | 8 | 202 | 10 | -30
18 | -17 | -17 | 203 | -2 | -34
19 | -12 | -12 | 213 | 13 | -33
20 | -5 | -5 | 226 | -14 | -34
21 | 2 | 2 | 212 | -2 | -19
22 | 5 | 5 | 175 | 22 | -39
23 | -13 | -13 |  | 9 | -35
24 | -1 | -1 |  | -5 | -21
25 | -3 | -3 |  | 8 | -30
26 | -9 | -9 |  | 8 | -37
27 | -2 | -2 |  | 7 | -28
28 | 6 | 6 |  | -1 | -44
29 | 5 | 5 |  | 4 | -22
30 | -2 | -2 |  | 2 | -37
31 | -1 | -1 |  | 4 | -33
32 | 2 | 2 |  | -4 | -27
33 | 9 | 9 |  | 14 | -25
34 | 21 | 21 |  | 6 | -42
35 | -3 | -3 |  | 3
36 |  | -31 |  | -4
37 |  | -125 |  | 20
38 |  | -37 |  | 5
39 |  | -34 |  | 16
40 |  | -25 |  | 7
41 |  | -22 |  | -2
42 |  | -24 |  | 12
43 |  | -24 |  | 8
44 |  | -36 |  | -10
45 |  | -32 |  | 6
46 |  | -12 |  | 13
47 |  | -28 |  | 5
48 |  | -47 |  | -2
49 |  | -16 |  | 11
50 |  | -33 |  | -2
51 |  | -43 |  | 9
52 |  | -23 |  | 1
53 |  | -28 |  | 9
54 |  | -25 |  | -3
55 |  | -39 |  | 9
56 |  | -27 |  | 0
57 |  | -44 |  | 19
58 |  | -18 |  | -4
59 |  | -37 |  | 6
60 |  | -41
61 |  | -38
62 |  | -32
63 |  | -32
64 |  | -37