tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2d1077de-fc10-470c-a55e-c0a5342745ec
Sheet: December

FEDERAL COLLEGE WORK-STUDY PROGRAM
MASTER SHEET FOR STUDENT WORK HOURS
NAME |  |  |  |  |  |  |  | ASU ID #
PAY PERIOD BEGINNING |  |  | 2012-12-03 00:00:00 |  |  |  |  | PAY PERIOD ENDING |  |  | 2012-12-14 00:00:00
HOURLY RATE |  |  | 7.25 |  | TOTAL Hours |  |  |  |  | DEPARTMENT
TIME
WORKED | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
IN
OUT
IN
OUT
IN
OUT
TOTAL
TIME
WORKED | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
IN
OUT
IN
OUT
IN
OUT
TOTAL
Student's Signature
[NAME]'s (Print Name) |  |  |  |  |  |  |  |  | [NAME]'s Signature
Department Head's(Print Name) |  |  |  |  |  |  |  |  | Department Head's Signature
Note:  This Master [NAME] should reflect the time and hours the student actually worked.  The total hours per day should reflect in the total column.
Students are not authorized to work no more than 20 hours per week.  No EXCEPTIONS!!!
Spreadsheet: 792343d1660842860-how-to-use-offset-when-the-reference-is-a-formula-linked-to-another-tab-new-report-log
Sheet: Current Status

 |  |  |  |  |  |  |  |  | Details of Longest Waiter Per Clinic
 | Clinic | [NAME] | Reports Breaching Target | [NAME] | Longest Outstanding Report |  |  |  | Start Date | Current Wait | NHS No. | Client Name | Clinician | [NAME]
 | SACC
 | JAC
 | Neuromotor
 | CDC
 | VADA
 | Downs
 | Whitefield School
 | Brookfield School
 | Neurodevelopmental
 | Epilepsy
 | Adoption & Fostering
 | Immunisations
 | SEN
 | LAC
Spreadsheet: 162315d1339792687-timesheet-problem-weekly-on-call-test
Sheet: Sheet1

WEEKLY ON-CALL PERSONNEL
Week Beginning: Friday June 8th, 2012
Week Ending: Friday April 15th, 2012
NEXT UP | TITLE | EMPLOYEE | TRK # | PRIMARY NUMBER | RADIO ID | SECOND NUMBER | CLOCK IN | CLOCK OUT |  | HOURS WORKED | CLOCK IN | CLOCK OUT |  | HOURS WORKED | CLOCK IN | CLOCK OUT |  | HOURS WORKED | DAILY TOTAL | WEEKLY TOTAL
 | L1
 |  |  |  |  |  |  | 01:00:00 | 01:30:00
 | L2
 | L3
 | [NAME]
 | G2
 | O.C.S. |  |  |  |  |  |  | FRI |  | SAT | SUN | MON |  | TUE | WED | THU
 |  |  |  |  |  |  | L1
 |  |  |  |  |  |  | L2
 | E.E |  |  |  |  |  | L3
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | G3
Note:  Only one substitution of on-call personnel per week is permitted unless approved by Operations Supervisor OB-10S
 |  | OTHER:  (If someone is getting replaced, please note the time and day that will take place.)
Spreadsheet: 866349d1713289206-excel-challenge-fifo-roster-impossible-formula-3-year-roster
Sheet: Input Page

 | Swing Commencement Date |  |  |  |  |  | Swing Cycle in Days
 |  | Day | Month | Year | Enter swing          cycle in days |  | On | Off | On | Off | Total |  |  | 1 | January | 2008
 |  | 29 | March | 2012 |  |  | 21 | 21 | 21 | 42 |  |  |  | 2 | February | 2009 | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | March | 2010 | No
 | Is the swing off day the same day of the week as the swing on day? |  |  |  |  |  |  |  | Yes |  |  |  |  | 4 | April | 2011
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May | 2012
 | Enter the travel days required before joining day, if none enter zero. |  |  |  |  |  |  |  | 0 |  |  |  |  | 6 | June | 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | July | 2014
 |  | Enter the travel days required after joining day, if none enter zero. |  |  |  |  |  |  | 0 |  |  |  |  | 8 | August | 2015
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | September | 2016
 |  |  | After all fields have been entered click on the                                                  Swing Calenders tab below for the three year swing cycle. |  |  |  |  |  |  |  |  |  |  | 10 | October | 2017
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November | 2018
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December | 2019
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 2020
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 2021
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 2022
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 2023
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 |  | 2024
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 2025
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 |  | 2026
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 2027
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 2028
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 2029
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 2030
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 2031
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 2032
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 2033
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 |  | 2034
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  | 2035
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  | 2036
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  | 2037
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 |  | 2038
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2039
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2040
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2041
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2042
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2043
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2044
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2045
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2046
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2047
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2048
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2049
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2050
Spreadsheet: 364de9c3-679a-443a-9488-7e480f7f24da
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
FZCCE | Test | FZCCE | [NAME] (Cucurbita spp) IgE | [NAME] | Radioimmunoassay (RIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain, red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | <[NAME]/L   Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr.                              Lee's Summit, MO 64086 | Monday through Friday | 2 - 3 days | 4 - 7 days | 1 | 86003 |  |  |  |  | Viracor-IBT Laboratories
FZCCE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FZCCE | Result | Z3122 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FZCCE | Result | Z3123 | Class | Class | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 730829d1619977584-find-the-percentage-a-cell-is-in-a-time-range-and-the-average-time-within-each-5x20-strategy-tms-v3
Sheet: RESULTS (v2)

 | TIME TRADED % |  |  |  |  |  | (Total Time in range) | (entries in range) | Total rows:
 |  |  |  |  | Much shorter formula … |  | SUMIFS | COUNTIFS | SUMIFS/COUNTIFS | %AGE
 | 06:00:00 | 08:59:00 |  |  | =IFERROR(AVERAGEIFS(DATA!C:C,DATA!C:C,">="&B4,DATA!C:C,"<"&C4),0)
 | 09:00:00 | 09:29:00
 | 09:30:00 | 09:49:00
 | 09:50:00 | 10:29:00
 | 10:30:00 | 11:29:00
 | 11:30:00 | 14:59:00
 | 15:00:00 | 16:00:00 |  |  | Note: 15:00 entry added to test the formula for this range
 | GAIN/LOSS |  |  |  |  |  | =SUMIFS(DATA!C:C,DATA!C:C,">="&B4,DATA!C:C,"<"&C4)
 |  |  |  |  |  |  |  | =COUNTIFS(DATA!C:C,">="&B4,DATA!C:C,"<"&C4)
 | Trading Days Span |  | 53 |  |  |  |  |  | =H4/I4
 | Trading Days |  |  |  |  |  |  |  |  | =I4/(COUNT(DATA!C:C))
 | Trading Days %
 | Total Wins
 | Total Points /share
 | Average Points /share |  |  |  | Excluding top 2 and bottom 2
 | Win/Loss % |  |  |  | Note, this is Win % on days there was a 5x20 strategy win
 | ENTRY REASON %
 | PM CONSOLIDATION
 | R2G
 | MOMO
 | CONSOLIDATION
 | PMH
 | BO
 | HIGHS %
 | Entry-High Ave |  |  |  | Percentage High above Entry
 | High-Close Ave |  |  |  | Percentage High above Close
Spreadsheet: mary_fischer__25435__May Monthly Logs
Sheet: WTG Downtime

GE Wind Maintenance Corp.
Site:     FENNER
DATE:  6/01/02
WTG DOWNTIME LOG MAY  2002
Pad |  | Date | Date | Time | Time | Elapsed
Location | Description - Fault Indication/Activity | Off | On | Off | On | Hours
5 | Pitch Encoder Failure | 2002-05-09 00:00:00 | 2002-05-09 00:00:00 | 03:56:00 | 15:21:00
10 | Pitch Controller Failure | 2002-05-04 00:00:00 | 2002-05-05 00:00:00 | 22:12:00 | 11:44:00
17 | Pitch Motor Failure | 2002-05-20 00:00:00 | 2002-05-21 00:00:00 | 07:15:00 | 21:15:00
18 | Pitch Motor Failure | 2002-05-26 00:00:00 | 2002-05-26 00:00:00 | 04:30:00 | 16:45:00
Note - if the event is considered a force majeure event, include the wording force majeure in the description.
Spreadsheet: 540366d1506659587-please-critique-my-spreadsheet-payroll-worksheets-year-2017
Sheet: June 2017 Summary

June 2017 Summary |  | Total Job Hours | Total Hours-Per Job
 |  |  | 1 | 2 | 3 | 4 | 5 | 6
#
1 |  |  | x
2 |  |  |  | x
3 |  |  |  |  | x
4 | Shop, |  |  |  |  | x
 | less shop hours
 | Hours less Shop
#
1 |  |  |  |  |  |  | x
2 |  |  |  | x
3 |  |  |  |  |  | x
 | less shop hours | 0
 | Hours less Shop
Totals
%
Vehicles
 | Fuel | 1475.13 |  |  |  |  |  | 0
 | Repairs & Maintenance | 2493.29
 | Total Overhead | 10459.13
 | fraction | 1
Spreadsheet: 840515d1692793548-change-a-number-then-move-the-correct-answer-sample-quiz-questions
Sheet: Sheet1

 |  |  | Question | Ans1 | Ans2 | Ans3 | Ans4 | CorrectAns
 |  |  | What color is the sky on a clear day? | Red | Green | Blue | Orange | 3
 |  |  | What is the capital of France? | Berlin | London | Madrid | Paris | 4
 |  |  | What game involves crafting, building, and exploring in a blocky world? | Roblox | Fortnite | Minecraft | Among Us | 3
 |  |  | What programming language is often used for building websites and web applications? | [NAME] | Python | PHP | [NAME] | 3
 |  |  | People that use fishing rods are usually trying to catch what? | Fish | Robots | Squirrels | Balloons | 1
 |  |  | What is the process of replacing or restoring damaged tissue called? | Evolution | Restoration | Regeneration | Transformation | 3
 |  |  | What is the largest mammal on Earth? | Elephant | Blue Whale | Giraffe | Rhinoceros | 2
Spreadsheet: phillip_allen__29914__Valuation Summary Recallable
Sheet: Sheet1

 |  |  | SJ | 0.5
 |  |  | Perm
 | Start on July 1, 2001 End on May 31, 2006
 | PG&E Topock Delivery Legs |  |  | Basis Swaps
 | Mmbtu/d | PV Volume | [NAME] (SJ/Perm) | Receipt | Total [NAME] | [NAME] | Delivery | Total [NAME] | Swap Value Deliverty | Spread | Total PV Spread | Swap Value |  | Tariff | Total PV Tariff | Swap Value |  | Value Over Tolls |  |  | Total Value | Swap Value
 | 200000
 |  |  |  |  | 8864512.130180428
 |  | SJ PV Vol | Perm PV Vol | Total |  | 0.1658327322033124
 | 2001-10-01 00:00:00
Spreadsheet: 56433d1256636166-formula-to-sum-for-a-given-field-type-specified-in-another-column-example
Sheet: Sheet1

Fruits | Types | Quantity | Cost | Use | Required
Lemons | A | 2 | 1 | Eat | Yes
 | B | 3 | 2 | [NAME] | No
 | C | 4 | 3 | [NAME] | Yes |  | Lemons | Eat | Yes
 | D | 5 | 4 | Eat | Yes |  | Apples | [NAME] | No
 | E | 9 | 6 | [NAME] | No |  | Pears
 | F | 7 | 7 | Eat | Yes
 | G | 2 | 1 | [NAME] | No
 | H | 5 | 2 | [NAME] | No
Apples | I | 6 | 3 | [NAME] | No
 | J | 1 | 4 | [NAME] | Yes
 | K | 8 | 7 | [NAME] | No
 | L | 7 | 8 | [NAME] | Yes
 | M | 6 | 9 | Eat | Yes
 | N | 3 | 6 | Eat | Yes
 | O | 4 | 4 | Eat | Yes
 | P | 5 | 2 | Eat | Yes
Pears | Q | 9 | 1 | [NAME] | Yes
 | R | 7 | 2 | Eat | Yes
 | S | 8 | 3 | [NAME] | Yes
 | T | 2 | 4 | Eat | No
 | U | 1 | 7 | [NAME] | No
 | V | 5 | 8 | Eat | Yes
 | W | 6 | 9 | Eat | No
 | X | 7 | 5 | [NAME] | No
Question
Z1 | Total Cost of All types of "Lemons"
[NAME] | Total Cost of All types of "Apples"
Z3 | Total Cost of All types of "Pears"
Z4 | Total Cost of "Use = Eat" - "Lemons"
[NAME] | Total Cost of "Use = Eat" - "Apples"
Z6 | Total Cost of "Use = Eat" - "Pears"
Z7 | Total Cost of "Required = Yes" - "Lemons"
Z8 | Total Cost of "Required = Yes" - "Apples"
Z9 | Total Cost of "Required = Yes" - "Pears"
[NAME] | Overall Cost of "Required = Yes" - All Fruits
Z11 | Overall Cost of "Use = Eat" - All Fruits
Z12 | Overall Cost of "Use = [NAME]" - All Fruits
Spreadsheet: adbccc8b-6fb7-4bd8-8aa1-ae7014c7d340
Sheet: Sheet1

Global X MLP ETF | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  |  | Fund Holdings Data as of 12/17/2014
% of Net Assets | Name | Identifier | Market Price($) | Shares Held | Market Value($)
6.7 | ENERGY TRANSFER PARTNERSP | 29273R109 | 63.39 | 148751 | 9429325.89
6.11 | [NAME] PARTNERS | 118230101 | 75.78 | 113565 | 8605955.7
5.98 | MAGELLAN MIDSTREAM | 559080106 | 79.33 | 106155 | 8421276.15
5.58 | PLAINS ALL AMERN PIP | 726503105 | 50.81 | 154540 | 7852177.4
5.56 | ENTERPRISE PRODUCTS PRTNR | 293792107 | 34.91 | 224022 | 7820608.02
5.41 | ENBRIDGE ENERGY PARTNERS | 29250R106 | 38.42 | 198057 | 7609349.94
5.24 | MARKWEST ENERGY-PART UTS | 570759100 | 63.34 | 116489 | 7378413.26
4.92 | REGENCY ENERGY PARTNERS | 75885Y107 | 24.53 | 282532 | 6930509.96
4.75 | [NAME] PARTNERS LP | 96950F104 | 44.01 | 151966 | 6688023.66
4.37 | ONEOK PARTNERS LP | 68268N103 | 41.37 | 148777 | 6154904.49
4.3 | SUNOCO LOGISTICS PRTS | 86764L108 | 41.77 | 144860 | 6050802.2
3.66 | ACCESS MIDSTREAM PARTNERS | 00434L109 | 53.51 | 96195 | 5147394.45
3.21 | WESTERN GAS PARTNERS L.P. | 958254104 | 70.24 | 64401 | 4523526.24
3.06 | TARGA RESOURCES PARTNERS | 87611X105 | 44.76 | 96270 | 4309045.2
2.83 | NUSTAR ENERGY LP | 67058H102 | 55.53 | 71754 | 3984499.62
2.83 | AMERIGAS PARTNERS-LP | 030975106 | 47.05 | 84511 | 3976242.55
2.6 | DCP MIDSTREAM PARTNER LLP | 23311P100 | 44.65 | 81869 | 3655450.85
2.34 | [NAME] | 87233Q108 | 76.59 | 42989 | 3292527.51
2.13 | EQT MIDSTREAM PARTNERS | 26885B100 | 80.78 | 37087 | 2995887.86
2.04 | GENESIS ENERGY L.P. | 371927104 | 42.66 | 67216 | 2867434.56
1.87 | SPECTRA ENERGY PARTNERS | 84756N109 | 55.21 | 47687 | 2632799.27
1.72 | SUBURBAN PROPANE PARTNERS | 864482104 | 43.54 | 55720 | 2426048.8
1.7 | ENLINK MIDSTREAM PARTNERS | 29336U107 | 27.44 | 87132 | 2390902.08
1.69 | CRESTWOOD MIDSTREAM PART | 226378107 | 16.6 | 142937 | 2372754.2
1.37 | TESORO LOGISTICS LP | 88160T107 | 54.35 | 35563 | 1932849.05
1.35 | [NAME]. PART. | 096627104 | 17.26 | 110410 | 1905676.6
1.26 | NGL ENERGY PARTNERS LP | 62913M107 | 29.37 | 60367 | 1772978.79
1.25 | ATLAS PIPELINE PARTNERS | 049392103 | 25.37 | 69075 | 1752432.75
1.15 | ALLIANCE RESOURCE PTNRLP | 01877R108 | 40.56 | 39724 | 1611205.44
0.92 | ATLAS ENERGY LP | 04930A104 | 29.05 | 44507 | 1292928.35
0.88 | NORTHERN TIER ENERGY LP | 665826103 | 22.66 | 54877 | 1243512.82
0.82 | CHENIERE ENERGY PARTNERS | 16411Q101 | 29.08 | 39441 | 1146944.28
0.8 | PHILLIPS 66 PARTNERS LP | 718549207 | 63.88 | 17617 | 1125373.96
0.72 | EV ENERGY PARTNERS L.P. | 26926V107 | 24 | 42189 | 1012536
0.54 | CRESTWOOD EQUITY PARTNERS | 226344109 | 7.27 | 103601 | 753179.27
0.34 | ENABLE MIDSTREAM PARTNERS | 292480100 | 19.9 | 23723 | 472087.7
0.27 | CASH | CASH | 1 | 377442.69 | 377442.69
0.1 | VIPER ENERGY PARTNERS LP | 92763M105 | 17.08 | 8368 | 142925.44
Spreadsheet: 009c67f0-2f17-47c5-85c5-e00d71cf74b3
Sheet: income

Census Tract | HH Median Income(1) | As % City HH Median(2) | Average Household Income(1) | Family Median Income(1,3) | As % City Family Median(2) | Average Family Income(1) | Per Capita Income | As % City Per Capita Income(2,4)
3521 | 84145 | 1.31 | 133886 | 131125 | 1.5 | 91877 | 66692 | 1.51
3522 | 45496 | 0.71 | 61532 | 48424 | 0.55 | 29739 | 28832 | 0.65
3523 | 65125 | 1.01 | 85246 | 78221 | 0.89 | 35535 | 41457 | 0.94
3524 | 29693 | 0.46 | 41265 | 31552 | 0.36 | 26656 | 18012 | 0.41
3525 | 60705 | 0.94 | 77670 | 85966 | 0.98 | 42231 | 30627 | 0.69
3526 | 56705 | 0.88 | 78525 | 61591 | 0.7 | 39571 | 35415 | 0.8
3527 | 34091 | 0.53 | 49336 | 34127 | 0.39 | 23095 | 24849 | 0.56
3528 | 64735 | 1 | 73508 | 69294 | 0.79 | 41324 | 30730 | 0.7
3529 | 76887 | 1.19 | 108734 | 99688 | 1.14 | 66271 | 49524 | 1.12
3530 | 54938 | 0.85 | 89297 | 97578 | 1.11 | 39338 | 45217 | 1.02
3531 | 51007 | 0.79 | 69555 | 46818 | 0.53 | 28744 | 24420 | 0.55
3532 | 65121 | 1.01 | 85098 | 93611 | 1.07 | 46985 | 41965 | 0.95
3533 | 90030 | 1.4 | 98235 | 116555 | 1.33 | 50900 | 42947 | 0.97
3534 | 50345 | 0.78 | 87114 | 42614 | 0.49 | 30613 | 41077 | 0.93
3535 | 57273 | 0.89 | 81811 | 66518 | 0.76 | 44913 | 40919 | 0.93
3536 | 59915 | 0.93 | 94858 | 107159 | 1.22 | 57207 | 39026 | 0.88
3537 | 53464 | 0.83 | 76320 | 71983 | 0.82 | 26258 | 30723 | 0.7
3538 | 81089 | 1.26 | 89552 | 95446 | 1.09 | 29170 | 54229 | 1.23
3539 | 32609 | 0.51 | 58652 | 57386 | 0.66 | 31692 | 26037 | 0.59
3540 | 60273 | 0.94 | 113070 | 167692 | 1.91 | 70540 | 62058 | 1.4
3541 | 65873 | 1.02 | 155974 | 145625 | 1.66 | 74760 | 81422 | 1.84
3542 | 119215 | 1.85 | 249021 | 161477 | 1.84 | 213973 | 104926 | 2.38
3543 | 76146 | 1.18 | 95802 | 97934 | 1.12 | 67384 | 44276 | 1
3544 | 96364 | 1.5 | 123748 | 113750 | 1.3 | 71593 | 61666 | 1.4
3545 | 91080 | 1.41 | 127355 | 172171 | 1.97 | 80765 | 66469 | 1.5
3546 | 65895 | 1.02 | 82929 | 62171 | 0.71 | 46643 | 36448 | 0.83
3547 | 88990 | 1.38 | 111210 | 160057 | 1.83 | 64328 | 54760 | 1.24
3548 | 82829 | 1.29 | 104173 | 119605 | 1.37 | 50237 | 50531 | 1.14
3549 | 41422 | 0.64 | 64870 | 39619 | 0.45 | 35795 | 28319 | 0.64
3550 | 62656 | 0.97 | 89542 | 109253 | 1.25 | 57024 | 41303 | 0.94
Citywide | 64420 | 1 | 95925 | 87595 | 1 | 128920 | 44171 | 1
Spreadsheet: tracy_geaccone__40327__Q3 2001 Accounting Adjustments
Sheet: PGE

 |  |  | (prepared 9/18/01)
Portland General Group (PGE)
Q3 2001- Significant Accounting Adjustments
The following accounting adjustments and/or rate case implementation issues are included
in our latest (Third) Current Estimate of results for Q3 2001.  We will need AA&Co. to concur
with our proposed treatment of each of these in our to reach our Q3 earnings forecast.
We have presented all of these proposed adjustments to AA&Co, which they are currently
considering as to their appropriateness.
Portland General Electric (PGE) | IBIT | Net Income | Footnote
TOLI Deferred Tax Reserve Reversal | 0 | 9 | (1)
SAVE (Energy Efficiency) True-up 2001 | 3.2 |  | (2)
Y2-K Cost Deferral | 0.8 |  | (3)
Colstrip Cost of Sale Recovery | 1.8 |  | (4)
Pension Capitalization Policy Change | 5.4 |  | (5)
SB1149 Deferral - Reverse Reserve | 1 |  | (6)
Total PGE
(1) Deferred Tax Reserve was established (1999) for taxes on PGE TOLI policies to be transferred
to Enron under the proposed Sierra sale. Since the sale has been terminated, this reserve
should be reversed.
(2)  This is to accrue for the difference between actual EE amortization expense and the
amount of revenue we've collected for the period Jan-Sept 2001.  This change gets us
current as opposed to awaiting OPUC final review/approval as we've done in prior years.
Changes in our accounting/rate recovery for these expenditures that took effect 10/1/00,
as well as our future recovery of these costs effective 10/1/01 helped support this change.
(3)  In our rate case order, we were allowed to defer incremental costs incurred in calender
year 2000 for Y2-K issues ($.4m) and allows recovery of previously deferred costs that
we reserved for Q4 2001 ($.4m).
(4) Our rate order provides recovery of these costs that we're previously expensed (2000)
pending OPUC approval to recover.
(5)  Our rate order assumes zero pension expense for ratemaking, as well as for what we
include in our labor loading amounts capitalized to plant.  Our YTD results include a FAS
87 pension credit as a "negative labor loading".  This change moves amounts recorded
YTD Sept 2001 as negative loadings back to an effective pension loading rate of zero.
(6) Based on an assessment of risks associated with the potential recovery of certain costs
deferred for recovery related to implementation of SB1149 (deregulation), PGE made a
general reserve of $1.0 m in 2000.  Based on reporting mechanisms since that time with
the OPUC, we now assess that there is no longer a need for this reserve.
Spreadsheet: jeffrey_a_shankman__13915__Family pool
Sheet: Week #12

 |  | 50 |  | = | 1st place
 |  | 30 |  | = | 2nd place
 |  | 10 |  | = | 3rd place
 |  |  |  | = | 4th place
 |  |  |  | w | l | w | l | w | l | w | l | l | w | w | l | l | w | W | l | w | l | w | l | l | w | w | l | w | l | w |  | w | l
 |  | Points Won | Points Lost | GB | DET | DEN | DALLAS | PITT | TENN | MIAMI | BUFF | CINCIN | CLEVE | SF | INDY | SEA | KC | WASH | PHIL | ATL | CAR | BALT | JACK | NO | NE | AZ | SD | OAK | NYG | CHIC | MINN | TB | ST.L |  |  |  |  | NYG | MN
2 | Cameron |  |  | 11 |  | 8 |  | 10 |  | 7 |  |  | 13 | 2 |  |  | 4 |  | 12 | 6 |  |  | 1 |  | 3 |  | 14 | 5 |  | 9 |  |  | 15
1 | Eldon |  |  | 1 |  | 15 |  | 3 |  | 9 |  |  | 12 | 5 |  | 6 |  |  | 14 | 11 |  | 10 |  |  | 8 |  | 7 | 4 |  |  | 2 |  | 13
 | Scott |  |  | 12 |  | 7 |  |  | 1 | 13 |  |  | 10 | 5 |  |  | 3 |  | 14 | 6 |  | 8 |  |  | 4 |  | 11 | 9 |  |  | 2 |  | 15
 | Kent |  |  | 10 |  | 14 |  | 8 |  | 13 |  |  | 1 |  | 5 | 3 |  | 4 |  |  | 2 | 6 |  | 9 |  |  | 15 | 12 |  | 7 |  |  | 11
 | [NAME] |  |  | 15 |  |  | 4 |  | 5 | 6 |  | 3 |  | 10 |  |  | 7 |  | 11 |  | 2 |  | 12 |  | 8 | 13 |  | 14 |  |  | 1 |  | 9
 | [NAME] |  |  | 15 |  | 12 |  | 10 |  |  | 1 |  | 9 | 6 |  | 2 |  |  | 13 | 3 |  | 8 |  | 7 |  |  | 11 | 5 |  | 4 |  |  | 14
4 | [NAME] |  |  | 15 |  | 14 |  | 2 |  | 5 |  |  | 3 | 4 |  | 10 |  |  | 13 | 1 |  | 9 |  |  | 8 |  | 7 | 11 |  |  | 6 |  | 12
3 | Prentice |  |  | 15 |  | 14 |  | 9 |  | 6 |  |  | 10 |  | 1 |  | 5 |  | 13 | 3 |  | 7 |  | 8 |  |  | 11 | 2 |  |  | 4 |  | 12
6 | Bobbi Sue |  |  | 14 |  | 7 |  | 13 |  |  | 9 |  | 4 | 6 |  | 2 |  | 3 |  | 8 |  | 11 |  |  | 1 |  | 5 |  | 12 |  | 10 |  | 15
 | TOTAL
 | AVERAGE
 | Edge |  |  | 1 |  | 15 |  | 9 |  | 2 |  | 12 |  | 14 |  |  | 10 | 6 |  |  | 8 | 3 |  |  | 4 |  | 5 | 11 |  | 7 |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
Spreadsheet: 58964d1259265610-auto-data-fill-call-form
Sheet: Sheet1

Manual Ref # | M - | dd | [NAME] | yy | xxxx | nnn | Agent:
[NAME] |  | x = your uk number     nnn = 001, 002, 003… |  |  |  |  | Time:
Branch Code |  |  |  |  | Contact #
Site Name |  |  |  |  | Caller Name
Classification |  |  |  |  |  | VIP |  | HOT
Number of counters |  |  |  |  |  |  | SLA? | Y | N
Affected Counter |  |  |  |  | Priority | 0 | 45 | 98 | 99
Severity | A | B | C
Problem Description:
Diagnostics & Outcome
 |  |  |  |  |  | Branch address
Resolution/Progression:
 |  |  | Close | Y | N | Postcode:
Next Action: |  |  | Voice IMT |  |  | Voice CMT |  | Voice NBSC
[NAME]/Other:
Access Times:
Mon |  |  | Thurs |  |  | Sun
[NAME] |  |  | Friday |  |  | Bank Hol
Weds |  |  | Sat
Spares Type
[NAME] # |  |  |  | Logged by: |  |  | Time/Date