{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["TOTAL FUNCFAC","TAX DEPR","GROSS PLANT","FORM 1","BOOKDPR","OTHER REVENUE","GENERAL PLANT","INTANGIBLE PLANT","SCH M","DDS","ACCUMDIT"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TOTAL FUNCFAC","index":0,"n_rows":73,"n_cols":8,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["PacifiCorp"]
["12 Months Ended December 2016"]
["FUNCTIONAL FACTORS "]
[]
[]
["Function","Description","Production","Transmission","DPW","CUST","DMSC","Total"]
["ACCMDIT","Deferred Income Tax",{"$f":"ACCUMDIT!D50","v":0.50449122453835626},{"$f":"ACCUMDIT!E50","v":0.25430125872543402},{"$f":"ACCUMDIT!F50","v":0.24035055809911826},{"$f":"ACCUMDIT!G50","v":8.5695863709149133E-4},{"$f":"ACCUMDIT!H50","v":0},1]
["BOOKDEPR","Book Depreciation",{"$f":"BOOKDPR!C13","v":0.61176811256826358},{"$f":"BOOKDPR!D13","v":0.16297748822398689},{"$f":"BOOKDPR!E13","v":0.22339723514158377},{"$f":"BOOKDPR!F13","v":1.8571640661657403E-3},{"$f":"BOOKDPR!G13","v":0},{"$f":"ROUND(SUM(C8:G8),4)","v":1}]
["COM_EQ","Communication Equipment Acct 397",0,0,0,0,0,0]
["CUST","Distribution Retail",0,0,0,1,0,1]
["DDS2","Deferred Debits - Situs",{"$f":"DDS!F34","v":0.91775795906871349},{"$f":"DDS!G34","v":-1.4581569254889543E-2},{"$f":"DDS!H34","v":-5.2589344162217111E-2},{"$f":"DDS!I34","v":0.14682792435524764},{"$f":"DDS!J34","v":2.5850299931455063E-3},1]
["DDS6","Deferred Debits - Situs",0,0,0,0,0,0]
["DDSO2","Deferred Debits - System Overhead",{"$f":"DDS!F33","v":0.45187157260754207},{"$f":"DDS!G33","v":8.7188060803084305E-2},{"$f":"DDS!H33","v":0.32358699756086068},{"$f":"DDS!I33","v":0.13110914560428888},{"$f":"DDS!J33","v":6.2442234242241247E-3},1]
["DDSO6","Deferred Debits - System Overhead",{"$f":"IF(DDS!F54=0,0,DDS!F54)","v":0},{"$f":"DDS!G54","v":0},{"$f":"DDS!H54","v":0},{"$f":"DDS!I54","v":0},{"$f":"DDS!J54","v":1},1]
["DEFSG","Deferred Debit - System Generation",{"$f":"DDS!F53","v":0.74883074988533083},{"$f":"DDS!G53","v":0.25116925011466917},{"$f":"DDS!H53","v":0},{"$f":"DDS!I53","v":0},{"$f":"DDS!J53","v":0},1]
["DMSC","Distribution Miscellaneous",0,0,0,0,1,1]
["DPW","Distribution Poles & Wires",{"$f":"'FORM 1'!C15","v":0},{"$f":"'FORM 1'!D15","v":0},{"$f":"'FORM 1'!E15","v":1},{"$f":"'FORM 1'!F15","v":0},{"$f":"'FORM 1'!G15","v":0},1]
["ESD","Environmental Services Department",0.3,0.1,0.6,0,0,1]
["FERC","FERC Fees",{"$f":"'FORM 1'!C39","v":0.49494951244555979},{"$f":"'FORM 1'!D39","v":0.50505048755444026},{"$f":"'FORM 1'!E39","v":0},{"$f":"'FORM 1'!F39","v":0},{"$f":"'FORM 1'!G39","v":0},1]
["G","General Plant",{"$f":"'GENERAL PLANT'!E38","v":0.21913484417596008},{"$f":"'GENERAL PLANT'!F38","v":0.35127302852730607},{"$f":"'GENERAL PLANT'!G38","v":0.41305487597715296},{"$f":"'GENERAL PLANT'!H38","v":1.6537251319580878E-2},{"$f":"'GENERAL PLANT'!I38","v":0},1]
["G-DGP","General Plant - DGP Factor",{"$f":"+C70","v":0.66860318198778701},{"$f":"+D70","v":0.33139681801221293},{"$f":"+E70","v":0},{"$f":"+F70","v":0},{"$f":"+G70","v":0},1]
["G-DGU","General Plant - DGU Factor",{"$f":"+C21","v":0.66860318198778701},{"$f":"+D21","v":0.33139681801221293},{"$f":"+E21","v":0},{"$f":"+F21","v":0},{"$f":"+G21","v":0},1]
["GP","Total Plant",{"$f":"'GROSS PLANT'!E42","v":0.48418675187421589},{"$f":"'GROSS PLANT'!F42","v":0.24466360081432525},{"$f":"'GROSS PLANT'!G42","v":0.26509262562442881},{"$f":"'GROSS PLANT'!H42","v":6.0570216870301534E-3},{"$f":"'GROSS PLANT'!I42","v":0},1]
["G-SG","General Plant - SG Factor",{"$f":"'GENERAL PLANT'!E34","v":0.42741321020630912},{"$f":"'GENERAL PLANT'!F34","v":0.57258678979369093},{"$f":"'GENERAL PLANT'!G34","v":0},{"$f":"'GENERAL PLANT'!H34","v":0},{"$f":"'GENERAL PLANT'!I34","v":0},1]
["G-SITUS","General Plant - SITUS Factor",{"$f":"'GENERAL PLANT'!E36","v":0},{"$f":"'GENERAL PLANT'!F36","v":0.31170267880907676},{"$f":"'GENERAL PLANT'!G36","v":0.68829732119092313},{"$f":"'GENERAL PLANT'!H36","v":0},{"$f":"'GENERAL PLANT'!I36","v":0},1]
["I","Intangible Plant",{"$f":"'INTANGIBLE PLANT'!D35","v":0.48728009888063989},{"$f":"'INTANGIBLE PLANT'!E35","v":0.17769216216435935},{"$f":"'INTANGIBLE PLANT'!F35","v":0.15552860614597433},{"$f":"'INTANGIBLE PLANT'!G35","v":0.17949913280902657},{"$f":"'INTANGIBLE PLANT'!H35","v":0},1]
["I-DGP","Intangible Plant - DGP Factor",1,0,0,0,0,1]
["I-DGU","Intangible Plant - DGU Factor",1,0,0,0,0,1]
["I-SG","Intangible Plant - SG Factor",{"$f":"'INTANGIBLE PLANT'!D33","v":0.83354265691961948},{"$f":"'INTANGIBLE PLANT'!E33","v":0.16645734308038052},{"$f":"'INTANGIBLE PLANT'!F33","v":0},{"$f":"'INTANGIBLE PLANT'!G33","v":0},{"$f":"'INTANGIBLE PLANT'!H33","v":0},1]
["I-SITUS","Intangible Plant - SITUS Factor",{"$f":"'INTANGIBLE PLANT'!D34","v":2.0611776287758561},{"$f":"'INTANGIBLE PLANT'!E34","v":-0.52126991947967261},{"$f":"'INTANGIBLE PLANT'!F34","v":-0.53990770929618348},{"$f":"'INTANGIBLE PLANT'!G34","v":0},{"$f":"'INTANGIBLE PLANT'!H34","v":0},1]
["LABOR","Direct Labor Expense",{"$f":"'FORM 1'!C25","v":0.46089210710155087},{"$f":"'FORM 1'!D25","v":8.7245911656529326E-2},{"$f":"'FORM 1'!E25","v":0.31465785298198112},{"$f":"'FORM 1'!F25","v":0.13720412825993866},{"$f":"'FORM 1'!G25","v":0},1]
["MSS","Materials & Supplies",{"$f":"'FORM 1'!C32","v":0.85440884586336985},{"$f":"'FORM 1'!D32","v":8.3219666752753791E-3},{"$f":"'FORM 1'!E32","v":0.13726918746135475},{"$f":"'FORM 1'!F32","v":0},{"$f":"'FORM 1'!G32","v":0},1]
["OTHDGP","Other Revenues - DGP Factor",{"$f":"C37","v":0.2244204206239834},{"$f":"D37","v":0.77557957937601663},{"$f":"E37","v":0},{"$f":"F37","v":0},{"$f":"G37","v":0},{"$f":"ROUND(SUM(C33:G33),4)","v":1}]
["OTHDGU","Other Revenues - DGU Factor",{"$f":"C37","v":0.2244204206239834},{"$f":"D37","v":0.77557957937601663},{"$f":"E37","v":0},{"$f":"F37","v":0},{"$f":"G37","v":0},1]
["OTHSE","Other Revenues - SE Factor",{"$f":"'OTHER REVENUE'!E25","v":0},{"$f":"'OTHER REVENUE'!F25","v":1},{"$f":"'OTHER REVENUE'!G25","v":0},{"$f":"'OTHER REVENUE'!H25","v":0},{"$f":"'OTHER REVENUE'!I25","v":0},1]
["OTHSG","Other Revenues - SG Factor",{"$f":"'OTHER REVENUE'!E26","v":0.2244204206239834},{"$f":"'OTHER REVENUE'!F26","v":0.77557957937601663},{"$f":"'OTHER REVENUE'!G26","v":0},{"$f":"'OTHER REVENUE'!H26","v":0},{"$f":"'OTHER REVENUE'!I26","v":0},1]
["OTHSGR","Other Revenues - Rolled-In SG Factor",{"$f":"+C36","v":0.2244204206239834},{"$f":"+D36","v":0.77557957937601663},{"$f":"+E36","v":0},{"$f":"+F36","v":0},{"$f":"+G36","v":0},1]
["OTHSITUS","Other Revenues - SITUS",{"$f":"'OTHER REVENUE'!E23","v":-3.8886329505321185E-2},{"$f":"'OTHER REVENUE'!F23","v":0.85417771769355555},{"$f":"'OTHER REVENUE'!G23","v":0},{"$f":"'OTHER REVENUE'!H23","v":0},{"$f":"'OTHER REVENUE'!I23","v":0.18470861181176565},1]
["OTHSO","Other Revenues - SO Factor",{"$f":"'OTHER REVENUE'!E27","v":0},{"$f":"'OTHER REVENUE'!F27","v":0},{"$f":"'OTHER REVENUE'!G27","v":0},{"$f":"'OTHER REVENUE'!H27","v":0},{"$f":"'OTHER REVENUE'!I27","v":1},1]
["P","Production",{"$f":"'FORM 1'!C13","v":1},{"$f":"'FORM 1'!D13","v":0},{"$f":"'FORM 1'!E13","v":0},{"$f":"'FORM 1'!F13","v":0},{"$f":"'FORM 1'!G13","v":0},1]
["SCHMA","Schedule M Additions",{"$f":"'SCH M'!F65","v":0.49284278008419347},{"$f":"'SCH M'!G65","v":0.19845263963411527},{"$f":"'SCH M'!H65","v":0.2960096213013888},{"$f":"'SCH M'!I65","v":9.8507224396943427E-3},{"$f":"'SCH M'!J65","v":2.8442365406082279E-3},1]
["SCHMAF","Schedule M Additions - Flow Through",1,0,0,0,0,1]
["SCHMAP","Schedule M Additions - Permanent",{"$f":"'SCH M'!F16","v":0.89905114356237581},{"$f":"'SCH M'!G16","v":1.6336943173346673E-2},{"$f":"'SCH M'!H16","v":5.8920210306830902E-2},{"$f":"'SCH M'!I16","v":2.5691702957446678E-2},{"$f":"'SCH M'!J16","v":0},1]
["SCHMAP-SO","Schedule M Additions - Permanent-SO",{"$f":"'SCH M'!F15","v":1},{"$f":"'SCH M'!G15","v":0},{"$f":"'SCH M'!H15","v":0},{"$f":"'SCH M'!I15","v":0},{"$f":"'SCH M'!J15","v":0},1]
["SCHMAT","Schedule M Additions - Temporary",{"$f":"+'SCH M'!F$57","v":0.49269300607809274},{"$f":"+'SCH M'!G$57","v":0.19851978792520211},{"$f":"+'SCH M'!H$57","v":0.29609703907532292},{"$f":"+'SCH M'!I$57","v":9.8448816758745349E-3},{"$f":"+'SCH M'!J$57","v":2.8452852455076966E-3},{"$f":"+'SCH M'!K$57","v":0}]
["SCHMAT-GPS","Schedule M Additions - Temporary-GPS",0,0,0,0,0,0]
["SCHMAT-SE","Schedule M Additions - Temporary-SE",{"$f":"'SCH M'!F53","v":0.99928318498888669},{"$f":"'SCH M'!G53","v":1.1600494067605655E-4},{"$f":"'SCH M'!H53","v":4.1837909508162397E-4},{"$f":"'SCH M'!I53","v":1.8243097535577287E-4},{"$f":"'SCH M'!J53","v":0},1]
["SCHMAT-SITUS","Schedule M Additions - Temporary-SITUS",{"$f":"'SCH M'!F55","v":0.79953270173847846},{"$f":"'SCH M'!G55","v":2.6033599304963066E-2},{"$f":"'SCH M'!H55","v":0.13097107768018212},{"$f":"'SCH M'!I55","v":4.3462621276376311E-2},{"$f":"'SCH M'!J55","v":0},1]
["SCHMAT-SNP","Schedule M Additions - Temporary-SNP",{"$f":"'SCH M'!F54","v":0.49127200719318387},{"$f":"'SCH M'!G54","v":0.2436131341759484},{"$f":"'SCH M'!H54","v":0.26489612353124331},{"$f":"'SCH M'!I54","v":2.1873509962435072E-4},{"$f":"'SCH M'!J54","v":0},1]
["SCHMAT-SO","Schedule M Additions - Temporary-SO",{"$f":"'SCH M'!F56","v":0.46373007006249123},{"$f":"'SCH M'!G56","v":0.10172290868159636},{"$f":"'SCH M'!H56","v":0.31004890508399596},{"$f":"'SCH M'!I56","v":0.12449811617191635},{"$f":"'SCH M'!J56","v":0},1]
["SCHMD","Schedule M Deductions",{"$f":"+'SCH M'!F$135","v":0.4974415631610265},{"$f":"+'SCH M'!G$135","v":0.21730423481509481},{"$f":"+'SCH M'!H$135","v":0.27669077531835218},{"$f":"+'SCH M'!I$135","v":1.0410247604546443E-2},{"$f":"+'SCH M'!J$135","v":-1.8468208990198337E-3},1]
["SCHMDF","Schedule M Deductions - Flow Through",1,0,0,0,0,1]
["SCHMDP","Schedule M Deductions - Permanent",{"$f":"'SCH M'!F77","v":0.99913054543718471},{"$f":"'SCH M'!G77","v":5.2229148549538438E-4},{"$f":"'SCH M'!H77","v":4.3203955170039164E-4},{"$f":"'SCH M'!I77","v":-8.4876474380384928E-5},{"$f":"'SCH M'!J77","v":0},1]
["SCHMDP-SO","Schedule M Deductions - Permanent- SO",{"$f":"'SCH M'!F76","v":" "},{"$f":"'SCH M'!G76","v":" "},{"$f":"'SCH M'!H76","v":" "},{"$f":"'SCH M'!I76","v":" "},{"$f":"'SCH M'!J76","v":" "},0]
["SCHMDT","Schedule M Deductions - Temporary",{"$f":"'SCH M'!F128","v":0.48611865142297717},{"$f":"'SCH M'!G128","v":0.22219691314258638},{"$f":"'SCH M'!H128","v":0.2829258201219253},{"$f":"'SCH M'!I128","v":1.0647118191351857E-2},{"$f":"'SCH M'!J128","v":-1.8885028788407012E-3},1]
["SCHMDT-GPS","Schedule M Deductions - Temporary-GPS",{"$f":"'SCH M'!F119","v":0.49153746076502491},{"$f":"'SCH M'!G119","v":0.24357377777893749},{"$f":"'SCH M'!H119","v":0.26488876145603757},{"$f":"'SCH M'!I119","v":0},{"$f":"'SCH M'!J119","v":0},1]
["SCHMDT-SG","Schedule M Deductions - Temporary-SG",{"$f":"'SCH M'!F121","v":1.000725278301615},{"$f":"'SCH M'!G121","v":-7.2527830161491283E-4},{"$f":"'SCH M'!H121","v":0},{"$f":"'SCH M'!I121","v":0},{"$f":"'SCH M'!J121","v":0},1]
["SCHMDT-SITUS","Schedule M Deductions - Temporary-SITUS",{"$f":"'SCH M'!F127","v":1.0534836466713973},{"$f":"'SCH M'!G127","v":-1.6495529669412826E-2},{"$f":"'SCH M'!H127","v":-3.5812261782246717E-2},{"$f":"'SCH M'!I127","v":-2.9265882070475178E-2},{"$f":"'SCH M'!J127","v":2.809002685073729E-2},1]
["SCHMDT-SNP","Schedule M Deductions - Temporary-SNP",{"$f":"'SCH M'!F123","v":0.49153746076502497},{"$f":"'SCH M'!G123","v":0.24357377777893746},{"$f":"'SCH M'!H123","v":0.26488876145603757},{"$f":"'SCH M'!I123","v":0},{"$f":"'SCH M'!J123","v":0},1]
["SCHMDT-SO","Schedule M Deductions - Temporary-SO",{"$f":"'SCH M'!F124","v":0.45241896945012755},{"$f":"'SCH M'!G124","v":0.11130434254442742},{"$f":"'SCH M'!H124","v":0.32927557539241076},{"$f":"'SCH M'!I124","v":0.10700111261303419},{"$f":"'SCH M'!J124","v":0},1]
["T","Transmission",{"$f":"'FORM 1'!C14","v":0},{"$f":"'FORM 1'!D14","v":1},{"$f":"'FORM 1'!E14","v":0},{"$f":"'FORM 1'!F14","v":0},{"$f":"'FORM 1'!G14","v":0},{"$f":"ROUND(SUM(C61:G61),4)","v":1}]
["TAXDEPR ","Tax Depreciation ",{"$f":"+'TAX DEPR'!C$24","v":0.42071110262209088},{"$f":"+'TAX DEPR'!D$24","v":0.25424940596708662},{"$f":"+'TAX DEPR'!E$24","v":0.31798006557730624},{"$f":"+'TAX DEPR'!F$24","v":7.0594258335162597E-3},{"$f":"+'TAX DEPR'!G$24","v":0},{"$f":"ROUND(SUM(C62:G62),4)","v":1}]
["TD","Transmission / Distribution",{"$f":"'FORM 1'!C18","v":0},{"$f":"'FORM 1'!D18","v":0.47903976986272157},{"$f":"'FORM 1'!E18","v":0.52096023013727843},{"$f":"'FORM 1'!F18","v":0},{"$f":"'FORM 1'!G18","v":0},{"$f":"ROUND(SUM(C63:G63),4)","v":1}]
["CWC","Cash Working Capital",0.67918839423389055,0.10474514946353318,0.10241236761468425,7.1610975615343797E-2,4.2043113072548377E-2,1]
["DITEXP","Deferred Income Tax - Expense",0,0,0,0,0,1]
["FIT","Federal Income Taxes",0.41368852978807208,0.28124056322798063,0.28708025986167152,1.1213826218364382E-2,6.776820903910916E-3,1]
["IBT","Income Before Taxes",0.5468771744865728,0.21735293463180394,0.22186606455205379,8.6664526945819022E-3,5.2373736349872581E-3,1]
["NONE","Not Functionalized",0,0,0,0,0,0]
["NUTIL","Non-Utility",0,0,0,0,0,0]
["PT","Production / Transmission",0.66860318198778701,0.33139681801221293,0,0,0,1]
["PTD","Prod, Trans, Dist Plant",0.49187400909517487,0.24380003845095186,0.26432595245387325,0,0,1]
["REVREQ","Revenue Requirement",0.62661091704550775,0.15100996998040983,0.14709933799985991,4.8232288519438227E-2,2.7047486454784244E-2,1]
["SIT","State Income Taxes",0.54687717448656037,0.21735293463180164,0.22186606455204566,8.6664526946044727E-3,5.2373736349872581E-3,1]

{"sheet":"TAX DEPR","index":1,"n_rows":330,"n_cols":7,"rows_kept":330,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'TOTAL FUNCFAC'!$A$1","v":"PacifiCorp"}]
[{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended December 2016"}]
["Tax Depreciation"]
[]
[null,"Total","Production","Transmission","Distribution","General","Mining"]
[]
[]
["Total",{"$f":"SUM(C8:G8)","v":910819181},{"$f":"348016209+54159-G8","v":347403596},208531903,265593946,{"$f":"93820388-5201627+4203","v":88622964},{"$f":"880139+100837+34412+78385-80846+16063-38885+12378-335711","v":666772}]
[]
[]
[]
["Conversion to COS Functions","Total","Pro","Trn","Dis","Retail","Misc"]
[]
["Percent of GenPlant in Functions",{"$f":"SUM(C14:F14)","v":1},0.39630105271428068,0.26001536929726643,0.27113059436206993,7.2552983626382905E-2,0]
[]
[]
[]
["Allocation of GenPlant to Functions",{"$f":"SUM(C18:F18)","v":88622963.999999985},{"$f":"+$F$8*C14","v":35121373.927859798},{"$f":"+$F$8*D14","v":23043332.712678347},{"$f":"+$F$8*E14","v":24028396.903448328},{"$f":"+$F$8*F14","v":6429860.4560135221},{"$f":"+$F$8*G14","v":0}]
["Assignment of Mining to Prod Function",{"$f":"SUM(C19:F19)","v":666772},{"$f":"G8","v":666772}]
[]
["Adjusted Totals",{"$f":"SUM(C21:F21)","v":910819181},{"$f":"+C8+C18+C19","v":383191741.92785978},{"$f":"+D8+D18+D19","v":231575235.71267834},{"$f":"+E8+E18+E19","v":289622342.90344834},{"$f":"+F18+F19","v":6429860.4560135221},{"$f":"+G18+G19","v":0}]
[]
[]
["TAXDEPR FACTOR",{"$f":"SUM(C24:F24)","v":0.99999999999999989},{"$f":"+C21/$B$21","v":0.42071110262209088},{"$f":"+D21/$B$21","v":0.25424940596708662},{"$f":"+E21/$B$21","v":0.31798006557730624},{"$f":"+F21/$B$21","v":7.0594258335162597E-3},{"$f":"+G21/$B$21","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TAXDEPR Factor",null,{"$f":"#REF!/#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!/#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!/#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!/#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!/#REF!","v":{"$error":"#REF!"}}]

{"sheet":"GROSS PLANT","index":2,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended December 2016"}]
["Gross Plant"]
["(In 000's)"]
[]
[null,"Alloc."]
["Description","Factor","Funct.","Amount","Production","Transmisssion","DPW","CUSTOMER","DMISC"]
[]
["Production Plant",null,"P",12212509.341,{"$f":"$D9*VLOOKUP(+$C9,$C$45:$I$51,3)","v":12212509.341},{"$f":"$D9*VLOOKUP(+$C9,$C$45:$I$51,4)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$45:$I$51,5)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$45:$I$51,6)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$45:$I$51,7)","v":0}]
["Transmission Plant",null,"T",6051719.9069999997,{"$f":"$D10*VLOOKUP(+$C10,$C$45:$I$51,3)","v":0},{"$f":"$D10*VLOOKUP(+$C10,$C$45:$I$51,4)","v":6051719.9069999997},{"$f":"$D10*VLOOKUP(+$C10,$C$45:$I$51,5)","v":0},{"$f":"$D10*VLOOKUP(+$C10,$C$45:$I$51,6)","v":0},{"$f":"$D10*VLOOKUP(+$C10,$C$45:$I$51,7)","v":0}]
["Distribution Plant",null,"DPW",6581302,{"$f":"$D11*VLOOKUP(+$C11,$C$45:$I$51,3)","v":0},{"$f":"$D11*VLOOKUP(+$C11,$C$45:$I$51,4)","v":0},{"$f":"$D11*VLOOKUP(+$C11,$C$45:$I$51,5)","v":6581302},{"$f":"$D11*VLOOKUP(+$C11,$C$45:$I$51,6)","v":0},{"$f":"$D11*VLOOKUP(+$C11,$C$45:$I$51,7)","v":0}]
["Mining","SE","P",{"$f":"1854.828+161602.075+8385.398","v":171842.30100000001},{"$f":"$D12*VLOOKUP(+$C12,$C$45:$I$51,3)","v":171842.30100000001},{"$f":"$D12*VLOOKUP(+$C12,$C$45:$I$51,4)","v":0},{"$f":"$D12*VLOOKUP(+$C12,$C$45:$I$51,5)","v":0},{"$f":"$D12*VLOOKUP(+$C12,$C$45:$I$51,6)","v":0},{"$f":"$D12*VLOOKUP(+$C12,$C$45:$I$51,7)","v":0}]
["General Plant"]
["Business Centers",{"$f":"'GENERAL PLANT'!B7","v":"CN"},{"$f":"'GENERAL PLANT'!C7","v":"CUST"},{"$f":"'GENERAL PLANT'!D7","v":19276.112819999998},{"$f":"$D14*VLOOKUP(+$C14,$C$45:$I$51,3)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$45:$I$51,4)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$45:$I$51,5)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$45:$I$51,6)","v":19276.112819999998},{"$f":"$D14*VLOOKUP(+$C14,$C$45:$I$51,7)","v":0}]
["Utah Mine",{"$f":"'GENERAL PLANT'!B8","v":"SE"},{"$f":"'GENERAL PLANT'!C8","v":"P"},{"$f":"'GENERAL PLANT'!D8","v":5385.9918299999999},{"$f":"$D15*VLOOKUP(+$C15,$C$45:$I$51,3)","v":5385.9918299999999},0,0,0,0]
[null,{"$f":"'GENERAL PLANT'!B9","v":"SG"},{"$f":"'GENERAL PLANT'!C9","v":"P"},{"$f":"'GENERAL PLANT'!D9","v":118117.27509000001},{"$f":"$D16*VLOOKUP(+$C16,$C$45:$I$51,3)","v":118117.27509000001},0,0,0,0]
[null,{"$f":"'GENERAL PLANT'!B10","v":"SG"},{"$f":"'GENERAL PLANT'!C10","v":"T"},{"$f":"'GENERAL PLANT'!D10","v":158236.54895999999},{"$f":"$D17*VLOOKUP(+$C17,$C$45:$I$51,3)","v":0},158236.54895999999,0,0,0]
[null,{"$f":"'GENERAL PLANT'!B12","v":"SO"},{"$f":"'GENERAL PLANT'!C12","v":"DPW"},{"$f":"'GENERAL PLANT'!D12","v":0},0,0,0,0,0]
[null,{"$f":"'GENERAL PLANT'!B17","v":"SG"},{"$f":"'GENERAL PLANT'!C17","v":"DPW"},{"$f":"'GENERAL PLANT'!D17","v":0},0,0,0,0,0]
[null,{"$f":"'GENERAL PLANT'!B18","v":"SG"},{"$f":"'GENERAL PLANT'!C18","v":"P"},{"$f":"'GENERAL PLANT'!D18","v":0},0,0,0,0,0]
["General Plant",{"$f":"'GENERAL PLANT'!B19","v":"SITUS"},{"$f":"'GENERAL PLANT'!C19","v":"DPW"},{"$f":"'GENERAL PLANT'!D19","v":208267.03208000006},0,0,208267.03208000006,0,0]
["General Plant",{"$f":"'GENERAL PLANT'!B20","v":"SITUS"},{"$f":"'GENERAL PLANT'!C20","v":"P"},{"$f":"'GENERAL PLANT'!D20","v":0},0,0,0,0,0]
["General Plant",{"$f":"'GENERAL PLANT'!B21","v":"SITUS"},{"$f":"'GENERAL PLANT'!C21","v":"TD"},{"$f":"'GENERAL PLANT'!D21","v":387943.82882000011},0,185840.52247759589,202103.30634240422,0,0]
["Total General Plant",null,null,{"$f":"SUBTOTAL(9,D14:D23)","v":897226.78960000025},123503.26692000001,344077.07143759588,410370.33842240425,19276.112819999998,0]
[]
["Intangible Plant"]
["Customer Service Sys",{"$f":"'INTANGIBLE PLANT'!A7","v":"CN"},{"$f":"'INTANGIBLE PLANT'!B7","v":"CUST"},{"$f":"'INTANGIBLE PLANT'!C7","v":142708.82968999998},{"$f":"$D27*VLOOKUP(+$C27,$C$45:$I$52,3)","v":0},{"$f":"$D27*VLOOKUP(+$C27,$C$45:$I$52,4)","v":0},{"$f":"$D27*VLOOKUP(+$C27,$C$45:$I$52,5)","v":0},{"$f":"$D27*VLOOKUP(+$C27,$C$45:$I$52,6)","v":142708.82968999998},{"$f":"$D27*VLOOKUP(+$C27,$C$45:$I$52,7)","v":0}]
["Customer Service Sys",{"$f":"'INTANGIBLE PLANT'!A8","v":"SE"},{"$f":"'INTANGIBLE PLANT'!B8","v":"P"},{"$f":"'INTANGIBLE PLANT'!C8","v":23.299600000000002},23.299600000000002,0,0,0,0]
["Washington Hydro",{"$f":"'INTANGIBLE PLANT'!A9","v":"SG"},{"$f":"'INTANGIBLE PLANT'!B9","v":"P"},{"$f":"'INTANGIBLE PLANT'!C9","v":104841.12471999999},104841.12471999999,0,0,0,0]
["Utah Hydro",{"$f":"'INTANGIBLE PLANT'!A10","v":"SG"},{"$f":"'INTANGIBLE PLANT'!B10","v":"T"},{"$f":"'INTANGIBLE PLANT'!C10","v":57403.921119999999},0,57403.921119999999,0,0,0]
["Colorado Steam-UPD",{"$f":"'INTANGIBLE PLANT'!A11","v":"SG"},{"$f":"'INTANGIBLE PLANT'!B11","v":"P"},{"$f":"'INTANGIBLE PLANT'!C11","v":172821.24465000001},172821.24465000001,0,0,0,0]
[null,{"$f":"'INTANGIBLE PLANT'!A12","v":"SG"},{"$f":"'INTANGIBLE PLANT'!B12","v":"P"},{"$f":"'INTANGIBLE PLANT'!C12","v":9790.3560099999995},9790.3560099999995,0,0,0,0]
["Oregon Trans",{"$f":"'INTANGIBLE PLANT'!A15","v":"SO"},{"$f":"'INTANGIBLE PLANT'!B15","v":"P"},{"$f":"'INTANGIBLE PLANT'!C15","v":27404.399949999999},27404.399949999999,0,0,0,0]
["Utah Mine",{"$f":"'INTANGIBLE PLANT'!A16","v":"SO"},{"$f":"'INTANGIBLE PLANT'!B16","v":"PTD"},{"$f":"'INTANGIBLE PLANT'!C16","v":256403.18338000102},126031.76969067474,62453.092010412525,67918.321678913751,0,0]
["Utah",{"$f":"'INTANGIBLE PLANT'!A18","v":"SO"},{"$f":"'INTANGIBLE PLANT'!B18","v":"TD"},{"$f":"'INTANGIBLE PLANT'!C18","v":41519.137610000005},0,19889.318125593069,21629.819484406937,0,0]
["Utah G/O",{"$f":"'INTANGIBLE PLANT'!A19","v":"SO"},{"$f":"'INTANGIBLE PLANT'!B19","v":"LABOR"},{"$f":"'INTANGIBLE PLANT'!C19","v":0},{"$f":"$D36*VLOOKUP(+$C36,$C$45:$I$52,3)","v":0},0,0,0,0]
["Utah G/O",{"$f":"'INTANGIBLE PLANT'!A25","v":"SITUS"},{"$f":"'INTANGIBLE PLANT'!B25","v":"TD"},{"$f":"'INTANGIBLE PLANT'!C25","v":15816.264149999999},0,7576.6195385040128,8239.6446114959854,0,0]
["Total Intangible Plant",null,null,{"$f":"SUBTOTAL(9,D27:D37)","v":828731.76088000089},440912.19462067471,147322.95079450961,97787.785774816672,142708.82968999998,0]
[]
["Total Gross Plant",null,null,{"$f":"SUBTOTAL(9,D8:D38)","v":26743332.099479999},12948767.103540676,6543119.9292321056,7089460.1241972214,161984.94250999999,0]
[]
[null,"GP Factor",null,{"$f":"SUM(E42:I42)","v":1.0000000000000002},{"$f":"E40/$D40","v":0.48418675187421589},{"$f":"F40/$D40","v":0.24466360081432525},{"$f":"G40/$D40","v":0.26509262562442881},{"$f":"H40/$D40","v":6.0570216870301534E-3},{"$f":"I40/$D40","v":0}]
[]
[]
[null,"Functional Allocators:",null,null,"Prod","Trans","DPW","CUST","DMISC"]
[null,null,"P",{"$f":"SUM(E46:F46)","v":1},{"$f":"'FORM 1'!$C$13","v":1},{"$f":"'FORM 1'!$D$13","v":0},{"$f":"'FORM 1'!$E$13","v":0},{"$f":"'FORM 1'!$F$13","v":0},{"$f":"'FORM 1'!$G$13","v":0}]
[null,null,"T",{"$f":"SUM(E47:F47)","v":1},{"$f":"'FORM 1'!$C$14","v":0},{"$f":"'FORM 1'!$D$14","v":1},{"$f":"'FORM 1'!$E$14","v":0},{"$f":"'FORM 1'!$F$14","v":0},{"$f":"'FORM 1'!$G$14","v":0}]
[null,null,"TD",{"$f":"SUM(E48:I48)","v":1},{"$f":"'FORM 1'!$C$18","v":0},{"$f":"'FORM 1'!$D$18","v":0.47903976986272157},{"$f":"'FORM 1'!$E$18","v":0.52096023013727843},{"$f":"'FORM 1'!$F$18","v":0},{"$f":"'FORM 1'!$G$18","v":0}]
[null,null,"CUST",{"$f":"SUM(E49:I49)","v":1},0,0,0,1,0]
[null,null,"DPW",{"$f":"SUM(E50:I50)","v":1},0,0,1,0,0]
[null,null,"PTD",{"$f":"SUM(E51:I51)","v":1},{"$f":"'FORM 1'!$C$16","v":0.49153746076502491},{"$f":"'FORM 1'!$D$16","v":0.24357377777893749},{"$f":"'FORM 1'!$E$16","v":0.26488876145603757},{"$f":"'FORM 1'!$F$16","v":0},{"$f":"'FORM 1'!$G$16","v":0}]
[null,null,"LABOR",{"$f":"SUM(E52:I52)","v":1},{"$f":"'SCH M'!F146","v":0.46089210710155087},{"$f":"'SCH M'!G146","v":8.7245911656529326E-2},{"$f":"'SCH M'!H146","v":0.31465785298198112},{"$f":"'SCH M'!I146","v":0.13720412825993866},{"$f":"'SCH M'!J146","v":0}]

{"sheet":"FORM 1","index":3,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'TOTAL FUNCFAC'!A1","v":"PacifiCorp"}]
["12 Months Ended December 2016"]
["FERC FORM 1 Funtionalization Factors"]
[]
[]
["Factor","Total","Production","Transmission","DPW","CUST","DMSC"]
[]
["PLANT",{"$f":"SUM(C8:G8)","v":24845531.248},{"$f":"+'GROSS PLANT'!D9","v":12212509.341},{"$f":"+'GROSS PLANT'!D10","v":6051719.9069999997},{"$f":"+'GROSS PLANT'!D11","v":6581302},0,0]
["UNCLASSIFIED PLANT",{"$f":"SUM(C9:G9)","v":0},null,null,null,0,0]
["TOTAL PLANT",{"$f":"SUM(C10:G10)","v":24845531.248},{"$f":"C8+C9","v":12212509.341},{"$f":"D8+D9","v":6051719.9069999997},{"$f":"E8+E9","v":6581302},0,0]
[]
["PLANT %"]
["P",{"$f":"SUM(C13:G13)","v":1},{"$f":"C10/C10","v":1}]
["T",1,null,{"$f":"D10/D10","v":1}]
["DPW",1,null,null,{"$f":"E10/E10","v":1}]
["PTD",1,{"$f":"C10/$B10","v":0.49153746076502491},{"$f":"D10/$B10","v":0.24357377777893749},{"$f":"E10/$B10","v":0.26488876145603757},{"$f":"F10/$B10","v":0},{"$f":"G10/$B10","v":0}]
["PT",1,{"$f":"C10/(C10+D10)","v":0.66865725211685645},{"$f":"D10/(C10+D10)","v":0.3313427478831435}]
["TD",1,null,{"$f":"D10/(D10+E10)","v":0.47903976986272157},{"$f":"E10/(D10+E10)","v":0.52096023013727843}]
[]
[]
[]
[]
["LABOR",{"$f":"SUM(C23:G23)","v":312813248},144173157,27291677,98429145,{"$f":"36465651+6453618","v":42919269},0]
[]
["LABOR %",{"$f":"B23/$B23","v":1},{"$f":"C23/$B23","v":0.46089210710155087},{"$f":"D23/$B23","v":8.7245911656529326E-2},{"$f":"E23/$B23","v":0.31465785298198112},{"$f":"F23/$B23","v":0.13720412825993866},{"$f":"G23/$B23","v":0}]
[]
[]
[]
[]
["Material & Supplies",{"$f":"SUM(C30:G30)","v":85951678},73437874,715287,11798517,0,0]
[]
["Material & Supplies %",{"$f":"B30/$B30","v":1},0.85440884586336985,8.3219666752753791E-3,0.13726918746135475,0,0]
[]
[]
[]
[]
["FERC (mWh)",25979868,{"$f":"B37-D37","v":12858723},13121145,0,0,0]
[]
["FERC %",{"$f":"B37/$B37","v":1},{"$f":"C37/$B37","v":0.49494951244555979},{"$f":"D37/$B37","v":0.50505048755444026},0,0,0]

{"sheet":"BOOKDPR","index":4,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'TOTAL FUNCFAC'!$A$1","v":"PacifiCorp"}]
[{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended December 2016"}]
["Depreciation Expense"]
[]
[]
["Function","Amount","Production","Transmission","DPW","CUST","DMSC"]
["CUST",1228.4073200000041,{"$f":"VLOOKUP($A7,$A$16:$G$22,3,FALSE)*$B7","v":0},{"$f":"VLOOKUP($A7,$A$16:$G$22,4,FALSE)*$B7","v":0},{"$f":"VLOOKUP($A7,$A$16:$G$22,5,FALSE)*$B7","v":0},{"$f":"VLOOKUP($A7,$A$16:$G$22,6,FALSE)*$B7","v":1228.4073200000041},{"$f":"VLOOKUP($A7,$A$16:$G$22,7,FALSE)*$B7","v":0}]
["DPW",144013.75699000002,{"$f":"VLOOKUP($A8,$A$16:$G$22,3,FALSE)*$B8","v":0},{"$f":"VLOOKUP($A8,$A$16:$G$22,4,FALSE)*$B8","v":0},{"$f":"VLOOKUP($A8,$A$16:$G$22,5,FALSE)*$B8","v":144013.75699000002},{"$f":"VLOOKUP($A8,$A$16:$G$22,6,FALSE)*$B8","v":0},{"$f":"VLOOKUP($A8,$A$16:$G$22,7,FALSE)*$B8","v":0}]
["P",397689.55729999713,{"$f":"VLOOKUP($A9,$A$16:$G$22,3,FALSE)*$B9","v":397689.55729999713},{"$f":"VLOOKUP($A9,$A$16:$G$22,4,FALSE)*$B9","v":0},{"$f":"VLOOKUP($A9,$A$16:$G$22,5,FALSE)*$B9","v":0},{"$f":"VLOOKUP($A9,$A$16:$G$22,6,FALSE)*$B9","v":0},{"$f":"VLOOKUP($A9,$A$16:$G$22,7,FALSE)*$B9","v":0}]
["PTD",14159.445560000251,{"$f":"VLOOKUP($A10,$A$16:$G$22,3,FALSE)*$B10","v":6959.8979164031298},{"$f":"VLOOKUP($A10,$A$16:$G$22,4,FALSE)*$B10","v":3448.8696463044644},{"$f":"VLOOKUP($A10,$A$16:$G$22,5,FALSE)*$B10","v":3750.677997292657},{"$f":"VLOOKUP($A10,$A$16:$G$22,6,FALSE)*$B10","v":0},{"$f":"VLOOKUP($A10,$A$16:$G$22,7,FALSE)*$B10","v":0}]
["T",104351.37438000501,{"$f":"VLOOKUP($A11,$A$16:$G$22,3,FALSE)*$B11","v":0},{"$f":"VLOOKUP($A11,$A$16:$G$22,4,FALSE)*$B11","v":104351.37438000501},{"$f":"VLOOKUP($A11,$A$16:$G$22,5,FALSE)*$B11","v":0},{"$f":"VLOOKUP($A11,$A$16:$G$22,6,FALSE)*$B11","v":0},{"$f":"VLOOKUP($A11,$A$16:$G$22,7,FALSE)*$B11","v":0}]
["Book Depreciation",{"$f":"SUM(B7:B11)","v":661442.54155000241},404649.45521640027,107800.24402630948,147764.43498729268,1228.4073200000041,0]
["BookDepr Factor",{"$f":"B12/$B12","v":1},0.61176811256826358,0.16297748822398689,0.22339723514158377,1.8571640661657403E-3,0]
[]
[]
["P",{"$f":"'FORM 1'!$B$13","v":1},{"$f":"'FORM 1'!$C$13","v":1},{"$f":"'FORM 1'!$D$13","v":0},{"$f":"'FORM 1'!$E$13","v":0},{"$f":"'FORM 1'!$F$13","v":0},{"$f":"'FORM 1'!$G$13","v":0}]
["T",{"$f":"'FORM 1'!$B$14","v":1},{"$f":"'FORM 1'!$C$14","v":0},{"$f":"'FORM 1'!$D$14","v":1},{"$f":"'FORM 1'!$E$14","v":0},{"$f":"'FORM 1'!$F$14","v":0},{"$f":"'FORM 1'!$G$14","v":0}]
["DPW",{"$f":"'FORM 1'!$B$15","v":1},{"$f":"'FORM 1'!$C$15","v":0},{"$f":"'FORM 1'!$D$15","v":0},{"$f":"'FORM 1'!$E$15","v":1},{"$f":"'FORM 1'!$F$15","v":0},{"$f":"'FORM 1'!$G$15","v":0}]
["CUST",{"$f":"'FORM 1'!$B$15","v":1},0,0,0,1,0]
["PTD",{"$f":"'FORM 1'!$B$16","v":1},{"$f":"'FORM 1'!$C$16","v":0.49153746076502491},{"$f":"'FORM 1'!$D$16","v":0.24357377777893749},{"$f":"'FORM 1'!$E$16","v":0.26488876145603757},{"$f":"'FORM 1'!$F$16","v":0},{"$f":"'FORM 1'!$G$16","v":0}]
["TD",{"$f":"'FORM 1'!$B$18","v":1},{"$f":"'FORM 1'!$C$18","v":0},{"$f":"'FORM 1'!$D$18","v":0.47903976986272157},{"$f":"'FORM 1'!$E$18","v":0.52096023013727843},{"$f":"'FORM 1'!$F$18","v":0},{"$f":"'FORM 1'!$G$18","v":0}]
["G",{"$f":"'GENERAL PLANT'!$D$38","v":1},{"$f":"'GENERAL PLANT'!$E$38","v":0.21913484417596008},{"$f":"'GENERAL PLANT'!$F$38","v":0.35127302852730607},{"$f":"'GENERAL PLANT'!$G$38","v":0.41305487597715296},{"$f":"'GENERAL PLANT'!$H$38","v":1.6537251319580878E-2},{"$f":"'GENERAL PLANT'!$I$38","v":0}]

{"sheet":"OTHER REVENUE","index":5,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'TOTAL FUNCFAC'!A1","v":"PacifiCorp"}]
[{"$f":"+'TOTAL FUNCFAC'!A2:A2","v":"12 Months Ended December 2016"}]
["Account 456"]
[]
["Main"]
["Account","Factor","Function","Amount","Production","Transmission","DPW","Customer","DMSC"]
["456","OTHER","P",-501.27959999999985,{"$f":"$D7*VLOOKUP(+$C7,$C$31:$I37,3,FALSE)","v":-501.27959999999985},{"$f":"$D7*VLOOKUP(+$C7,$C$31:$I37,4,FALSE)","v":0},{"$f":"$D7*VLOOKUP(+$C7,$C$31:$I37,5,FALSE)","v":0},{"$f":"$D7*VLOOKUP(+$C7,$C$31:$I37,6,FALSE)","v":0},{"$f":"$D7*VLOOKUP(+$C7,$C$31:$I37,7,FALSE)","v":0}]
["456","OTHER","T",0,{"$f":"$D8*VLOOKUP(+$C8,$C$31:$I38,3,FALSE)","v":0},{"$f":"$D8*VLOOKUP(+$C8,$C$31:$I38,4,FALSE)","v":0},{"$f":"$D8*VLOOKUP(+$C8,$C$31:$I38,5,FALSE)","v":0},{"$f":"$D8*VLOOKUP(+$C8,$C$31:$I38,6,FALSE)","v":0},{"$f":"$D8*VLOOKUP(+$C8,$C$31:$I38,7,FALSE)","v":0}]
["456","SE","P",0,{"$f":"$D9*VLOOKUP(+$C9,$C$31:$I38,3,FALSE)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$31:$I38,4,FALSE)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$31:$I38,5,FALSE)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$31:$I38,6,FALSE)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$31:$I38,7,FALSE)","v":0}]
["456","SE","T",-7481.0657200000005,{"$f":"$D10*VLOOKUP(+$C10,$C$31:$I39,3,FALSE)","v":0},{"$f":"$D10*VLOOKUP(+$C10,$C$31:$I39,4,FALSE)","v":-7481.0657200000005},{"$f":"$D10*VLOOKUP(+$C10,$C$31:$I39,5,FALSE)","v":0},{"$f":"$D10*VLOOKUP(+$C10,$C$31:$I39,6,FALSE)","v":0},{"$f":"$D10*VLOOKUP(+$C10,$C$31:$I39,7,FALSE)","v":0}]
["456","SG","P",-27112.074129999983,{"$f":"$D11*VLOOKUP(+$C11,$C$31:$I40,3,FALSE)","v":-27112.074129999983},{"$f":"$D11*VLOOKUP(+$C11,$C$31:$I40,4,FALSE)","v":0},{"$f":"$D11*VLOOKUP(+$C11,$C$31:$I40,5,FALSE)","v":0},{"$f":"$D11*VLOOKUP(+$C11,$C$31:$I40,6,FALSE)","v":0},{"$f":"$D11*VLOOKUP(+$C11,$C$31:$I40,7,FALSE)","v":0}]
["456","SG","T",-93697.226799999989,{"$f":"$D12*VLOOKUP(+$C12,$C$31:$I40,3,FALSE)","v":0},{"$f":"$D12*VLOOKUP(+$C12,$C$31:$I40,4,FALSE)","v":-93697.226799999989},{"$f":"$D12*VLOOKUP(+$C12,$C$31:$I40,5,FALSE)","v":0},{"$f":"$D12*VLOOKUP(+$C12,$C$31:$I40,6,FALSE)","v":0},{"$f":"$D12*VLOOKUP(+$C12,$C$31:$I40,7,FALSE)","v":0}]
["456","SO","DMSC",-1302.4991399999999,{"$f":"$D13*VLOOKUP(+$C13,$C$31:$I41,3,FALSE)","v":0},{"$f":"$D13*VLOOKUP(+$C13,$C$31:$I41,4,FALSE)","v":0},{"$f":"$D13*VLOOKUP(+$C13,$C$31:$I41,5,FALSE)","v":0},{"$f":"$D13*VLOOKUP(+$C13,$C$31:$I41,6,FALSE)","v":0},{"$f":"$D13*VLOOKUP(+$C13,$C$31:$I41,7,FALSE)","v":-1302.4991399999999}]
["456","SITUS","DMSC",1534.00803,{"$f":"$D14*VLOOKUP(+$C14,$C$31:$I42,3,FALSE)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$31:$I42,4,FALSE)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$31:$I42,5,FALSE)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$31:$I42,6,FALSE)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$31:$I42,7,FALSE)","v":1534.00803}]
["456","SITUS","P",-322.95160000000004,{"$f":"$D15*VLOOKUP(+$C15,$C$31:$I43,3,FALSE)","v":-322.95160000000004},{"$f":"$D15*VLOOKUP(+$C15,$C$31:$I43,4,FALSE)","v":0},{"$f":"$D15*VLOOKUP(+$C15,$C$31:$I43,5,FALSE)","v":0},{"$f":"$D15*VLOOKUP(+$C15,$C$31:$I43,6,FALSE)","v":0},{"$f":"$D15*VLOOKUP(+$C15,$C$31:$I43,7,FALSE)","v":0}]
["456","SITUS","T",7093.9598599999999,{"$f":"$D16*VLOOKUP(+$C16,$C$31:$I44,3,FALSE)","v":0},{"$f":"$D16*VLOOKUP(+$C16,$C$31:$I44,4,FALSE)","v":7093.9598599999999},{"$f":"$D16*VLOOKUP(+$C16,$C$31:$I44,5,FALSE)","v":0},{"$f":"$D16*VLOOKUP(+$C16,$C$31:$I44,6,FALSE)","v":0},{"$f":"$D16*VLOOKUP(+$C16,$C$31:$I44,7,FALSE)","v":0}]
["Total Situs Revenues",null,null,{"$f":"SUMIF($B:$B,\"SITUS\",D:D)","v":8305.0162899999996},-322.95160000000004,7093.9598599999999,0,0,1534.00803]
["Total CN Revenues",null,null,{"$f":"SUMIF($B:$B,\"CN\",D:D)","v":0},0,0,0,0,0]
["Total SE Revenues",null,null,{"$f":"SUMIF($B:$B,\"SE\",D:D)","v":-7481.0657200000005},0,-7481.0657200000005,0,0,0]
["Total SG Revenues",null,null,{"$f":"SUMIF($B:$B,\"SG\",D:D)","v":-120809.30092999997},-27112.074129999983,-93697.226799999989,0,0,0]
["Total SO Revenues",null,null,{"$f":"SUMIF($B:$B,\"SO\",D:D)","v":-1302.4991399999999},0,0,0,0,-1302.4991399999999]
["Total Operation",null,null,{"$f":"SUM(D7:D16)","v":-121789.12909999998},-27936.305329999981,-94084.332659999985,0,0,231.50889000000006]
["OTHSITUS",null,null,{"$f":"SUM(E23:I23)","v":1},{"$f":"E17/$D$17","v":-3.8886329505321185E-2},{"$f":"F17/$D$17","v":0.85417771769355555},{"$f":"G17/$D$17","v":0},{"$f":"H17/$D$17","v":0},{"$f":"I17/$D$17","v":0.18470861181176565}]
["CN Factor",null,null,0,{"$f":"IF(ISERROR(E18/$D$18),\" \",(E18/$D$18))","v":" "},{"$f":"IF(ISERROR(F18/$D$18),\" \",(F18/$D$18))","v":" "},{"$f":"IF(ISERROR(G18/$D$18),\" \",(G18/$D$18))","v":" "},{"$f":"IF(ISERROR(H18/$D$18),\" \",(H18/$D$18))","v":" "},{"$f":"IF(ISERROR(I18/$D$18),\" \",(I18/$D$18))","v":" "}]
["OTHSE",null,null,1,{"$f":"E19/$D$19","v":0},{"$f":"F19/$D$19","v":1},{"$f":"G19/$D$19","v":0},{"$f":"H19/$D$19","v":0},{"$f":"I19/$D$19","v":0}]
["OTHSG",null,null,1,{"$f":"E20/$D$20","v":0.2244204206239834},{"$f":"F20/$D$20","v":0.77557957937601663},{"$f":"G20/$D$20","v":0},{"$f":"H20/$D$20","v":0},{"$f":"I20/$D$20","v":0}]
["OTHSO",null,null,1,{"$f":"E21/$D$21","v":0},{"$f":"F21/$D$21","v":0},{"$f":"G21/$D$21","v":0},{"$f":"H21/$D$21","v":0},{"$f":"I21/$D$21","v":1}]
["Total Operation Factor",null,null,1,{"$f":"E22/$D$22","v":0.22938258559236208},{"$f":"F22/$D$22","v":0.77251831386977221},{"$f":"G22/$D$22","v":0},{"$f":"H22/$D$22","v":0},{"$f":"I22/$D$22","v":-1.9008994621343433E-3}]
[]
[null,null,null,"Total","Prod","Trans","DPW","CUST","DMSC"]
[null,null,"P",{"$f":"SUM(E31:I31)","v":1},{"$f":"'FORM 1'!$C$13","v":1},{"$f":"'FORM 1'!$D$13","v":0},{"$f":"'FORM 1'!$E$13","v":0},{"$f":"'FORM 1'!$F$13","v":0},{"$f":"'FORM 1'!$G$13","v":0}]
[null,null,"T",{"$f":"SUM(E32:I32)","v":1},{"$f":"'FORM 1'!$C$14","v":0},{"$f":"'FORM 1'!$D$14","v":1},{"$f":"'FORM 1'!$E$14","v":0},{"$f":"'FORM 1'!$F$14","v":0},{"$f":"'FORM 1'!$G$14","v":0}]
[null,null,"TD",1,{"$f":"'FORM 1'!$C$18","v":0},{"$f":"'FORM 1'!$D$18","v":0.47903976986272157},{"$f":"'FORM 1'!$E$18","v":0.52096023013727843},{"$f":"'FORM 1'!$F$18","v":0},{"$f":"'FORM 1'!$G$18","v":0}]
[null,null,"CUST",1,0,0,0,1,0]
[null,null,"DPW",1,0,0,1,0,0]
[null,null,"PTD",1,{"$f":"'FORM 1'!$C$16","v":0.49153746076502491},{"$f":"'FORM 1'!$D$16","v":0.24357377777893749},{"$f":"'FORM 1'!$E$16","v":0.26488876145603757},{"$f":"'FORM 1'!$F$16","v":0},{"$f":"'FORM 1'!$G$16","v":0}]
[null,null,"DMSC",1,0,0,0,0,1]

{"sheet":"GENERAL PLANT","index":6,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'TOTAL FUNCFAC'!$A$1","v":"PacifiCorp"}]
[{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended December 2016"}]
["General Plant"]
[]
[null,"Alloc."]
["Description","Factor","Funct.","Amount","Prod","Trans","DPW","CUST","DMSC"]
["Business Centers","CN","CUST",19276.112819999998,{"$f":"$D7*VLOOKUP(+$C7,$B$45:$H$51,3)","v":0},{"$f":"$D7*VLOOKUP(+$C7,$B$45:$H$51,4)","v":0},{"$f":"$D7*VLOOKUP(+$C7,$B$45:$H$51,5)","v":0},{"$f":"$D7*VLOOKUP(+$C7,$B$45:$H$51,6)","v":19276.112819999998},{"$f":"$D7*VLOOKUP(+$C7,$B$45:$H$51,7)","v":0}]
[null,"SE","P",5385.9918299999999,5385.9918299999999,0,0,0,0]
[null,"SG","P",118117.27509000001,118117.27509000001,0,0,0,0]
[null,"SG","T",158236.54895999999,0,158236.54895999999,0,0,0]
[null,"SG","TD",0,0,0,0,0,0]
["General Plant","SO","DPW",0,0,0,0,0,0]
[null,"SO","PTD",268390.90874000022,131924.18577447723,65372.987563323906,71093.735402199061,0,0]
[null,"SO","TD",0,0,0,0,0,0]
[null,"SO","P",0,0,0,0,0,0]
["SSGCH","SG","P",0,0,0,0,0,0]
["SSGCT","SG","DPW",0,0,0,0,0,0]
["SSGCT","SG","P",0,0,0,0,0,0]
[null,"SITUS","DPW",208267.03208000006,0,0,208267.03208000006,0,0]
[null,"SITUS","P",0,0,0,0,0,0]
[null,"SITUS","TD",387943.82882000011,0,185840.52247759589,202103.30634240422,0,0]
["Total-CUST",null,null,{"$f":"SUMIF($C:$C,\"CUST\",D:D)","v":19276.112819999998},0,0,0,19276.112819999998,0]
["Total-TD",null,null,{"$f":"SUMIF($C:$C,\"TD\",D:D)","v":387943.82882000011},0,185840.52247759589,202103.30634240422,0,0]
["Total-PTD",null,null,{"$f":"SUMIF($C:$C,\"PTD\",D:D)","v":268390.90874000022},131924.18577447723,65372.987563323906,71093.735402199061,0,0]
["Total-DPW",null,null,{"$f":"SUMIF($C:$C,\"DPW\",D:D)","v":208267.03208000006},0,0,208267.03208000006,0,0]
["Total-SSGCH",null,null,{"$f":"SUMIF($B:$B,\"SSGCH\",D:D)","v":0},0,0,0,0,0]
["Total-SSGCT",null,null,{"$f":"SUMIF($B:$B,\"SSGCT\",D:D)","v":0},0,0,0,0,0]
["Total-G-SG",null,null,{"$f":"SUMIF($B:$B,\"SG\",D:D)","v":276353.82405},118117.27509000001,158236.54895999999,0,0,0]
["Total-SE",null,null,{"$f":"SUMIF($B:$B,\"SE\",D:D)","v":5385.9918299999999},5385.9918299999999,0,0,0,0]
["Total-G-Situs",null,null,{"$f":"SUMIF($B:$B,\"SITUS\",D:D)","v":596210.8609000002},0,185840.52247759589,410370.33842240425,0,0]
["Total-SO",null,null,{"$f":"SUMIF($B:$B,\"SO\",D:D)","v":268390.90874000022},131924.18577447723,65372.987563323906,71093.735402199061,0,0]
["Total-General Plant",null,null,{"$f":"SUM(D7:D21)","v":1165617.6983400004},255427.45269447722,409450.05900091981,481464.07382460334,19276.112819999998,0]
[]
["G-SG Factor",null,null,{"$f":"SUM(E34:I34)","v":1},{"$f":"E28/$D$28","v":0.42741321020630912},{"$f":"F28/$D$28","v":0.57258678979369093},{"$f":"G28/$D$28","v":0},{"$f":"H28/$D$28","v":0},{"$f":"I28/$D$28","v":0}]
[".",null,null,{"$f":"SUM(E35:I35)","v":1},{"$f":"E29/$D$29","v":1},{"$f":"F29/$D$29","v":0},{"$f":"G29/$D$29","v":0},{"$f":"H29/$D$29","v":0},{"$f":"I29/$D$29","v":0}]
["G-SITUS Factor",null,null,{"$f":"SUM(E36:I36)","v":0.99999999999999989},{"$f":"E30/$D$30","v":0},{"$f":"F30/$D$30","v":0.31170267880907676},{"$f":"G30/$D$30","v":0.68829732119092313},{"$f":"H30/$D$30","v":0},{"$f":"I30/$D$30","v":0}]
["SO Factor",null,null,{"$f":"SUM(E37:I37)","v":0.99999999999999989},{"$f":"E31/$D$31","v":0.49153746076502486},{"$f":"F31/$D$31","v":0.24357377777893749},{"$f":"G31/$D$31","v":0.26488876145603757},{"$f":"H31/$D$31","v":0},{"$f":"I31/$D$31","v":0}]
["G Allocator",null,null,{"$f":"SUM(E38:I38)","v":1},{"$f":"E32/$D$32","v":0.21913484417596008},{"$f":"F32/$D$32","v":0.35127302852730607},{"$f":"G32/$D$32","v":0.41305487597715296},{"$f":"H32/$D$32","v":1.6537251319580878E-2},{"$f":"I32/$D$32","v":0}]
["Total Gen. Plant",null,null,{"$f":"D32","v":1165617.6983400004}]
["Mining",null,"acct 399 from JAM",{"$f":"'GROSS PLANT'!D12","v":171842.30100000001},{"$f":"D29","v":5385.9918299999999},{"$f":"SUM(D40+E40)","v":177228.29283000002}]
["Total ",null,"P",{"$f":"SUM(D39:D40)","v":1337459.9993400003}]
[]
[]
[null,"Functional Allocators:",null,"Prod","Trans","DPW","CUST","DMISC"]
[null,"P",{"$f":"SUM(D45:H45)","v":1},{"$f":"'FORM 1'!$C$13","v":1},{"$f":"'FORM 1'!$D$13","v":0},{"$f":"'FORM 1'!$E$13","v":0},{"$f":"'FORM 1'!$F$13","v":0},{"$f":"'FORM 1'!$G$13","v":0}]
[null,"T",1,{"$f":"'FORM 1'!$C$14","v":0},{"$f":"'FORM 1'!$D$14","v":1},{"$f":"'FORM 1'!$E$14","v":0},{"$f":"'FORM 1'!$F$14","v":0},{"$f":"'FORM 1'!$G$14","v":0}]
[null,"TD",1,{"$f":"'FORM 1'!$C$18","v":0},{"$f":"'FORM 1'!$D$18","v":0.47903976986272157},{"$f":"'FORM 1'!$E$18","v":0.52096023013727843},{"$f":"'FORM 1'!$F$18","v":0},{"$f":"'FORM 1'!$G$18","v":0}]
[null,"CUST",1,0,0,0,1,0]
[null,"DPW",1,0,0,1,0,0]
[null,"PTD",1,{"$f":"'FORM 1'!$C$16","v":0.49153746076502491},{"$f":"'FORM 1'!$D$16","v":0.24357377777893749},{"$f":"'FORM 1'!$E$16","v":0.26488876145603757},{"$f":"'FORM 1'!$F$16","v":0},{"$f":"'FORM 1'!$G$16","v":0}]
[null,"GP",{"$f":"SUM(D51:H51)","v":1.0000000000000002},{"$f":"+'GROSS PLANT'!E42","v":0.48418675187421589},{"$f":"+'GROSS PLANT'!F42","v":0.24466360081432525},{"$f":"+'GROSS PLANT'!G42","v":0.26509262562442881},{"$f":"+'GROSS PLANT'!H42","v":6.0570216870301534E-3},{"$f":"+'GROSS PLANT'!I42","v":0}]

{"sheet":"INTANGIBLE PLANT","index":7,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'TOTAL FUNCFAC'!A1","v":"PacifiCorp"}]
[{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended December 2016"}]
["Intangible Plant"]
["(In 000's)"]
["Alloc."]
["Factor","Funct.","Amount","Production","Transmisssion","DPW","Customer","DMSC"]
["CN","CUST",142708.82968999998,{"$f":"$C7*VLOOKUP(+$B7,$B$39:$H$46,3)","v":0},{"$f":"$C7*VLOOKUP(+$B7,$B$39:$H$46,4)","v":0},{"$f":"$C7*VLOOKUP(+$B7,$B$39:$H$46,5)","v":0},{"$f":"$C7*VLOOKUP(+$B7,$B$39:$H$46,6)","v":142708.82968999998},{"$f":"$C7*VLOOKUP(+$B7,$B$39:$H$46,7)","v":0}]
["SE","P",23.299600000000002,23.299600000000002,0,0,0,0]
["SG","P",104841.12471999999,104841.12471999999,0,0,0,0]
["SG","T",57403.921119999999,0,57403.921119999999,0,0,0]
["SG","P",172821.24465000001,172821.24465000001,0,0,0,0]
["SG","P",9790.3560099999995,9790.3560099999995,0,0,0,0]
["SO","CUST",7900.6057099999998,0,0,0,7900.6057099999998,0]
["SO","DPW",32551.425749999999,0,0,32551.425749999999,0,0]
["SO","P",27404.399949999999,27404.399949999999,0,0,0,0]
["SO","PTD",256403.18338000102,126031.76969067474,62453.092010412525,67918.321678913751,0,0]
["SO","T",1239.5300299999999,0,1239.5300299999999,0,0,0]
["SO","TD",41519.137610000005,0,19889.318125593069,21629.819484406937,0,0]
["SO","LABOR",0,0,0,0,0,0]
["SO","DMSC",0,0,0,0,0,0]
["SITUS","DPW",157.66159999999999,0,0,157.66159999999999,0,0]
["SITUS","P",-32057.959920000001,-32057.959920000001,0,0,0,0]
["SITUS","PTD",0,0,0,0,0,0]
["SITUS","T",530.80893000000003,0,530.80893000000003,0,0,0]
["SITUS","TD",15816.264149999999,0,7576.6195385040128,8239.6446114959854,0,0]
["Total-DGP",null,{"$f":"SUMIF($A:$A,\"SG-P\",C:C)","v":0},0,0,0,0,0]
["Total-DGU",null,{"$f":"SUMIF($A:$A,\"SG-U\",C:C)","v":0},0,0,0,0,0]
["Total-SG",null,{"$f":"SUMIF($A:$A,\"SG\",C:C)","v":344856.64649999997},287452.72537999996,57403.921119999999,0,0,0]
["Total-SITUS",null,{"$f":"SUMIF($A:$A,\"SITUS\",C:C)","v":-15553.225240000003},-32057.959920000001,8107.4284685040129,8397.3062114959848,0,0]
["Total-Intangible",null,{"$f":"SUM(C7:C25)","v":839053.83298000088},{"$f":"SUM(D7:D25)","v":408854.23470067471},149093.28975450961,130496.87312481667,150609.43539999999,0]
["I-DGP FACTOR",null,{"$f":"SUM(D31:H31)","v":{"$error":"#DIV/0!"}},{"$f":"D26/$C$26","v":{"$error":"#DIV/0!"}},{"$f":"E26/$C$26","v":{"$error":"#DIV/0!"}},{"$f":"F26/$C$26","v":{"$error":"#DIV/0!"}},{"$f":"G26/$C$26","v":{"$error":"#DIV/0!"}},{"$f":"H26/$C$26","v":{"$error":"#DIV/0!"}}]
["I-DGU FACTOR",null,{"$f":"SUM(D32:H32)","v":{"$error":"#DIV/0!"}},{"$f":"D27/$C$27","v":{"$error":"#DIV/0!"}},{"$f":"E27/$C$27","v":{"$error":"#DIV/0!"}},{"$f":"F27/$C$27","v":{"$error":"#DIV/0!"}},{"$f":"G27/$C$27","v":{"$error":"#DIV/0!"}},{"$f":"H27/$C$27","v":{"$error":"#DIV/0!"}}]
["I-SG FACTOR",null,{"$f":"SUM(D33:H33)","v":1},{"$f":"D28/$C$28","v":0.83354265691961948},{"$f":"E28/$C$28","v":0.16645734308038052},{"$f":"F28/$C$28","v":0},{"$f":"G28/$C$28","v":0},{"$f":"H28/$C$28","v":0}]
["I-Situs FACTOR",null,{"$f":"SUM(D34:H34)","v":1},{"$f":"D29/$C$29","v":2.0611776287758561},{"$f":"E29/$C$29","v":-0.52126991947967261},{"$f":"F29/$C$29","v":-0.53990770929618348},{"$f":"G29/$C$29","v":0},{"$f":"H29/$C$29","v":0}]
["I FACTOR",null,{"$f":"SUM(D35:H35)","v":1.0000000000000002},{"$f":"D30/$C$30","v":0.48728009888063989},{"$f":"E30/$C$30","v":0.17769216216435935},{"$f":"F30/$C$30","v":0.15552860614597433},{"$f":"G30/$C$30","v":0.17949913280902657},{"$f":"H30/$C$30","v":0}]
[]
[]
[null,"Functional Allocators:",null,"Prod","Trans","DPW","CUST","DMSC"]
[null,"P",{"$f":"SUM(D39:H39)","v":1},{"$f":"'FORM 1'!$C$13","v":1},{"$f":"'FORM 1'!$D$13","v":0},{"$f":"'FORM 1'!$E$13","v":0},{"$f":"'FORM 1'!$F$13","v":0},{"$f":"'FORM 1'!$G$13","v":0}]
[null,"T",1,{"$f":"'FORM 1'!$C$14","v":0},{"$f":"'FORM 1'!$D$14","v":1},{"$f":"'FORM 1'!$E$14","v":0},{"$f":"'FORM 1'!$F$14","v":0},{"$f":"'FORM 1'!$G$14","v":0}]
[null,"TD",1,{"$f":"'FORM 1'!$C$18","v":0},{"$f":"'FORM 1'!$D$18","v":0.47903976986272157},{"$f":"'FORM 1'!$E$18","v":0.52096023013727843},{"$f":"'FORM 1'!$F$18","v":0},{"$f":"'FORM 1'!$G$18","v":0}]
[null,"CUST",1,0,0,0,1,0]
[null,"DPW",1,0,0,1,0,0]
[null,"PTD",1,{"$f":"'FORM 1'!$C$16","v":0.49153746076502491},{"$f":"'FORM 1'!$D$16","v":0.24357377777893749},{"$f":"'FORM 1'!$E$16","v":0.26488876145603757},{"$f":"'FORM 1'!$F$16","v":0},{"$f":"'FORM 1'!$G$16","v":0}]
[null,"DMSC",1,{"$f":"'TOTAL FUNCFAC'!C16","v":0},{"$f":"'TOTAL FUNCFAC'!D16","v":0},{"$f":"'TOTAL FUNCFAC'!E16","v":0},{"$f":"'TOTAL FUNCFAC'!F16","v":0},{"$f":"'TOTAL FUNCFAC'!G16","v":1}]
[null,"LABOR",{"$f":"SUM(D46:H46)","v":1},{"$f":"'SCH M'!F146","v":0.46089210710155087},{"$f":"'SCH M'!G146","v":8.7245911656529326E-2},{"$f":"'SCH M'!H146","v":0.31465785298198112},{"$f":"'SCH M'!I146","v":0.13720412825993866},{"$f":"'SCH M'!J146","v":0}]

{"sheet":"SCH M","index":8,"n_rows":152,"n_cols":10,"rows_kept":152,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"+'TOTAL FUNCFAC'!A1","v":"PacifiCorp"}]
[null,{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended December 2016"}]
[null,"Schedule M"]
[null,"Primary","PITA"]
[null,"Account","Factor","Function","Amount","Production","Transmission","Poles & Wires","Customers","Miscellaneous"]
[null,"ADDITIONS"]
[{"$f":"IF(C7=\"\",\"\",B7&\"-\"&C7)","v":"SCHMAP-SCHMDEXP"},"SCHMAP","SCHMDEXP","LABOR",68.491889999999998,{"$f":"VLOOKUP($D7,$D$140:$J$152,3,FALSE)*$E7","v":31.56737150146764},{"$f":"VLOOKUP($D7,$D$140:$J$152,4,FALSE)*$E7","v":5.9756373841287242},{"$f":"VLOOKUP($D7,$D$140:$J$152,5,FALSE)*$E7","v":21.551511054078023},{"$f":"VLOOKUP($D7,$D$140:$J$152,6,FALSE)*$E7","v":9.3973700603256098},{"$f":"VLOOKUP($D7,$D$140:$J$152,7,FALSE)*$E7","v":0}]
[{"$f":"IF(C8=\"\",\"\",B8&\"-\"&C8)","v":"SCHMAP-SE"},"SCHMAP","SE","P",47.238,{"$f":"VLOOKUP($D8,$D$140:$J$152,3,FALSE)*$E8","v":47.238},{"$f":"VLOOKUP($D8,$D$140:$J$152,4,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,$D$140:$J$152,5,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,$D$140:$J$152,6,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,$D$140:$J$152,7,FALSE)*$E8","v":0}]
[{"$f":"IF(C9=\"\",\"\",B9&\"-\"&C9)","v":"SCHMAP-SO"},"SCHMAP","SO","P",250.04462000000001,{"$f":"VLOOKUP($D9,$D$140:$J$152,3,FALSE)*$E9","v":250.04462000000001},{"$f":"VLOOKUP($D9,$D$140:$J$152,4,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,$D$140:$J$152,5,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,$D$140:$J$152,6,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,$D$140:$J$152,7,FALSE)*$E9","v":0}]
[{"$f":"IF(C10=\"\",\"\",B10&\"-\"&C10)","v":"SCHMAP-SO"},"SCHMAP","SO","LABOR",0,{"$f":"VLOOKUP($D10,$D$140:$J$152,3,FALSE)*$E10","v":0},{"$f":"VLOOKUP($D10,$D$140:$J$152,4,FALSE)*$E10","v":0},{"$f":"VLOOKUP($D10,$D$140:$J$152,5,FALSE)*$E10","v":0},{"$f":"VLOOKUP($D10,$D$140:$J$152,6,FALSE)*$E10","v":0},{"$f":"VLOOKUP($D10,$D$140:$J$152,7,FALSE)*$E10","v":0}]
[{"$f":"IF(C11=\"\",\"\",B11&\"-\"&C11)","v":"SCHMAP-SO"},"SCHMAP","SO","PTD",0,{"$f":"VLOOKUP($D11,$D$140:$J$152,3,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,$D$140:$J$152,4,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,$D$140:$J$152,5,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,$D$140:$J$152,6,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,$D$140:$J$152,7,FALSE)*$E11","v":0}]
[]
[{"$f":"IF(C13=\"\",\"\",B13&\"-\"&C13)","v":""},"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"SCHMAP-SO\",E:E)","v":250.04462000000001},250.04462000000001,0,0,0,0]
[{"$f":"IF(C14=\"\",\"\",B14&\"-\"&C14)","v":""},"Total SCHMAP",null,null,{"$f":"SUMIF($B:$B,\"SCHMAP\",E:E)","v":365.77451000000002},328.84999150146768,5.9756373841287242,21.551511054078023,9.3973700603256098,0]
[{"$f":"IF(C15=\"\",\"\",B15&\"-\"&C15)","v":""},"SCHMAP-SO",null,null,{"$f":"SUM(F15:J15)","v":1},{"$f":"IF(ISERROR(F13/$E13),\" \",(F13/$E13))","v":1},0,0,0,0]
[{"$f":"IF(C16=\"\",\"\",B16&\"-\"&C16)","v":""},"SCHMAP FACTOR",null,null,{"$f":"SUM(F16:J16)","v":1},0.89905114356237581,1.6336943173346673E-2,5.8920210306830902E-2,2.5691702957446678E-2,0]
[]
[{"$f":"IF(C18=\"\",\"\",B18&\"-\"&C18)","v":"SCHMAT-CIAC"},"SCHMAT","CIAC","DPW",71153.413,{"$f":"VLOOKUP($D18,$D$140:$J$152,3,FALSE)*$E18","v":0},{"$f":"VLOOKUP($D18,$D$140:$J$152,4,FALSE)*$E18","v":0},{"$f":"VLOOKUP($D18,$D$140:$J$152,5,FALSE)*$E18","v":71153.413},{"$f":"VLOOKUP($D18,$D$140:$J$152,6,FALSE)*$E18","v":0},{"$f":"VLOOKUP($D18,$D$140:$J$152,7,FALSE)*$E18","v":0}]
["SCHMAT-BADDEBT","SCHMAT","BADDEBT","CUST",139.31962013931999,0,0,0,139.31962013931999,0]
["SCHMAT-SCHMDEXP","SCHMAT","SCHMDEXP","GP",760803.37219999998,368370.91360046813,186140.89255413332,201683.36352041757,4608.202524981074,0]
[{"$f":"IF(C21=\"\",\"\",B21&\"-\"&C21)","v":"SCHMAT-GPS"},"SCHMAT","GPS","GP",-663.38652999999999,-321.20296919780708,-162.3065371615204,-175.85887704157892,-4.0181465990936793,0]
[{"$f":"IF(C22=\"\",\"\",B22&\"-\"&C22)","v":"SCHMAT-SE"},"SCHMAT","SE","LABOR",63.253,29.152808450494398,5.5185656500104496,19.903053174669253,8.6785727248258997,0]
["SCHMAT-SE","SCHMAT","SE","P",47508.56263,47508.56263,0,0,0,0]
["SCHMAT-SG","SCHMAT","SG","DPW",null,0,0,0,0,0]
[{"$f":"IF(C25=\"\",\"\",B25&\"-\"&C25)","v":"SCHMAT-SG"},"SCHMAT","SG","P",-135.67626000000001,-135.67626000000001,0,0,0,0]
["SCHMAT-SG","SCHMAT","SG","T",null,0,0,0,0,0]
["SCHMAT-SGCT","SCHMAT","SGCT","P",1122.425,1122.425,0,0,0,0]
["SCHMAT-SNP","SCHMAT","SNP","GP",572.40603999999996,277.15142126078246,140.04692287426869,151.7406200668818,3.4670757980670492,0]
["SCHMAT-SNP","SCHMAT","SNP","PTD",15278.163,7509.7894461741553,3721.3598794323852,4047.0136743934595,0,0]
["SCHMAT-SNPD","SCHMAT","SNPD","DPW",1863.6344200000001,0,0,1863.6344200000001,0,0]
[{"$f":"IF(C31=\"\",\"\",B31&\"-\"&C31)","v":"SCHMAT-SO"},"SCHMAT","SO","DMSC",null,0,0,0,0,0]
[{"$f":"IF(C32=\"\",\"\",B32&\"-\"&C32)","v":"SCHMAT-SO"},"SCHMAT","SO","LABOR",27255.178580000003,12561.696685165256,2377.9029025736108,8576.055974623283,3739.5230176378532,0]
["SCHMAT-SO","SCHMAT","SO","PTD",2781.6053700000002,1367.2632404201577,677.52612826107929,736.81600131876314,0,0]
[{"$f":"IF(C34=\"\",\"\",B34&\"-\"&C34)","v":"SCHMAT-OTHER"},"SCHMAT","OTHER","DMSC",2822.6151199999999,0,0,0,0,2822.6151199999999]
[{"$f":"IF(C35=\"\",\"\",B35&\"-\"&C35)","v":"SCHMAT-OTHER"},"SCHMAT","OTHER","GP",null,0,0,0,0,0]
["SCHMAT-OTHER","SCHMAT","OTHER","P",33065.715089999998,33065.715089999998,0,0,0,0]
["SCHMAT-OTHER","SCHMAT","OTHER","PTD",15230.040419999999,7486.1353953954931,3709.6384808253156,4034.2665437791902,0,0]
[{"$f":"IF(C38=\"\",\"\",B38&\"-\"&C38)","v":"SCHMAT-OTHER"},"SCHMAT","OTHER","CUST",724.54588000000001,0,0,0,724.54588000000001,0]
["SCHMAT-TROJD","SCHMAT","TROJD","P",-131.94999999999999,-131.94999999999999,0,0,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","DMSC",null,0,0,0,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","DPW",391.09235999999999,0,0,391.09235999999999,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","ESD",49.91292,14.973875999999999,4.9912920000000005,29.947751999999998,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","GP",null,0,0,0,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","LABOR",3984.7412199999999,1836.5357771402043,347.65238045425087,1253.830116974,546.72294543154442,0]
["SCHMAT-SITUS","SCHMAT","SITUS","P",8256.7138300000006,8256.7138300000006,0,0,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","PTD",-103.30772999999999,-50.779619281598784,-25.163054069866472,-27.365056648534733,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","T",null,0,0,0,0,0]
[null,"Total-SE",null,null,{"$f":"SUMIF($A:$A,\"SCHMAT-SE\",E:E)","v":47571.815629999997},47537.715438450497,5.5185656500104496,19.903053174669253,8.6785727248258997,0]
[{"$f":"IF(C49=\"\",\"\",B49&\"-\"&C49)","v":""},"Total-SNP",null,null,{"$f":"SUMIF($A:$A,\"SCHMAT-SNP\",E:E)","v":15850.56904},7786.9408674349379,3861.4068023066538,4198.754294460341,3.4670757980670492,0]
["","Total-SITUS",null,null,{"$f":"SUMIF($A:$A,\"SCHMAT-SITUS\",E:E)","v":12579.152600000001},10057.443863858607,327.4806183843844,1647.5051723254651,546.72294543154442,0]
[null,"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"SCHMAT-SO\",E:E)","v":30036.783950000005},13928.959925585414,3055.4290308346899,9312.8719759420455,3739.5230176378532,0]
["","Total-SCHMAT",null,null,{"$f":"SUMIF($B:$B,\"SCHMAT\",E:E)","v":992032.38918013941},488767.41995199531,196938.05951497285,293737.85310305771,9766.4414901135897,2822.6151199999999]
[null,"SCHMAT-SE",null,null,{"$f":"SUM(F53:J53)","v":1.0000000000000002},{"$f":"IF(ISERROR(F48/$E48),\" \",(F48/$E48))","v":0.99928318498888669},1.1600494067605655E-4,4.1837909508162397E-4,1.8243097535577287E-4,0]
["","SCHMAT-SNP",null,null,{"$f":"SUM(F54:J54)","v":1},0.49127200719318387,0.2436131341759484,0.26489612353124331,2.1873509962435072E-4,0]
["","SCHMAT-SITUS",null,null,{"$f":"SUM(F55:J55)","v":1},0.79953270173847846,2.6033599304963066E-2,0.13097107768018212,4.3462621276376311E-2,0]
[null,"SCHMAT-SO",null,null,{"$f":"SUM(F56:J56)","v":0.99999999999999989},0.46373007006249123,0.10172290868159636,0.31004890508399596,0.12449811617191635,0]
["","SCHMAT FACTOR",null,null,{"$f":"SUM(F57:J57)","v":0.99999999999999989},0.49269300607809274,0.19851978792520211,0.29609703907532292,9.8448816758745349E-3,2.8452852455076966E-3]
[]
[{"$f":"IF(C59=\"\",\"\",B59&\"-\"&C59)","v":"SCHMAF-DGP"},"SCHMAF","DGP","P",0,{"$f":"VLOOKUP($D59,$D$140:$J$152,3,FALSE)*$E59","v":0},{"$f":"VLOOKUP($D59,$D$140:$J$152,4,FALSE)*$E59","v":0},{"$f":"VLOOKUP($D59,$D$140:$J$152,5,FALSE)*$E59","v":0},{"$f":"VLOOKUP($D59,$D$140:$J$152,6,FALSE)*$E59","v":0},{"$f":"VLOOKUP($D59,$D$140:$J$152,7,FALSE)*$E59","v":0}]
[{"$f":"IF(C60=\"\",\"\",B60&\"-\"&C60)","v":"SCHMAF-TROJP"},"SCHMAF","TROJP","P",0,{"$f":"VLOOKUP($D60,$D$140:$J$152,3,FALSE)*$E60","v":0},{"$f":"VLOOKUP($D60,$D$140:$J$152,4,FALSE)*$E60","v":0},{"$f":"VLOOKUP($D60,$D$140:$J$152,5,FALSE)*$E60","v":0},{"$f":"VLOOKUP($D60,$D$140:$J$152,6,FALSE)*$E60","v":0},{"$f":"VLOOKUP($D60,$D$140:$J$152,7,FALSE)*$E60","v":0}]
[{"$f":"IF(C61=\"\",\"\",B61&\"-\"&C61)","v":""},"Total-SCHMAF",null,null,{"$f":"SUMIF($A:$A,\"SCHMAF\",E:E)","v":0},0,0,0,0,0]
["","SCHMAF FACTOR",null,null,{"$f":"SUM(F62:J62)","v":0},{"$f":"IF(ISERROR(F61/$E61),\" \",(F61/$E61))","v":" "},{"$f":"IF(ISERROR(G61/$E61),\" \",(G61/$E61))","v":" "},{"$f":"IF(ISERROR(H61/$E61),\" \",(H61/$E61))","v":" "},{"$f":"IF(ISERROR(I61/$E61),\" \",(I61/$E61))","v":" "},{"$f":"IF(ISERROR(J61/$E61),\" \",(J61/$E61))","v":" "}]
[]
["","Total-SCHMA",null,null,{"$f":"SUM(E61,E52,E14)","v":992398.16369013942},489096.26994349679,196944.03515235698,293759.40461411182,9775.8388601739152,2822.6151199999999]
["","SCHMA FACTOR",null,null,{"$f":"SUM(F65:J65)","v":1},{"$f":"IF(ISERROR(F64/$E64),\" \",(F64/$E64))","v":0.49284278008419347},{"$f":"IF(ISERROR(G64/$E64),\" \",(G64/$E64))","v":0.19845263963411527},{"$f":"IF(ISERROR(H64/$E64),\" \",(H64/$E64))","v":0.2960096213013888},{"$f":"IF(ISERROR(I64/$E64),\" \",(I64/$E64))","v":9.8507224396943427E-3},{"$f":"IF(ISERROR(J64/$E64),\" \",(J64/$E64))","v":2.8442365406082279E-3}]
[]
["","DEDUCTIONS"]
["SCHMDP-SCHMDEXP","SCHMDP","SCHMDEXP","LABOR",-16.933109999999999,{"$f":"VLOOKUP($D68,$D$140:$J$152,3,FALSE)*$E68","v":-7.804336747682342},{"$f":"VLOOKUP($D68,$D$140:$J$152,4,FALSE)*$E68","v":-1.4773446191302932},{"$f":"VLOOKUP($D68,$D$140:$J$152,5,FALSE)*$E68","v":-5.328136036907714},{"$f":"VLOOKUP($D68,$D$140:$J$152,6,FALSE)*$E68","v":-2.32329259627965},{"$f":"VLOOKUP($D68,$D$140:$J$152,7,FALSE)*$E68","v":0}]
["SCHMDP-SE","SCHMDP","SE","P",1783.664,1783.664,0,0,0,0]
["SCHMDP-SG","SCHMDP","SG","P",25541.142260000001,25541.142260000001,0,0,0,0]
["SCHMDP-SNP","SCHMDP","SNP","PTD",64.760000000000005,31.831965959143016,15.773837848963993,17.154196191892993,0,0]
["SCHMDP-SO","SCHMDP","SO","LABOR",null,0,0,0,0,0]
["SCHMDP-SITUS","SCHMDP","SITUS","PTD",null,0,0,0,0,0]
[null,"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"SCHMDP-SO\",E:E)","v":0},0,0,0,0,0]
["","Total-SCHMDP",null,null,{"$f":"SUMIF($B:$B,\"SCHMDP\",E:E)","v":27372.633149999998},27348.833889211463,14.2964932298337,11.826060154985278,-2.32329259627965,0]
["","SCHMDP-SO",null,null,{"$f":"SUM(F76:J76)","v":0},{"$f":"IF(ISERROR(F74/$E74),\" \",(F74/$E74))","v":" "}," "," "," "," "]
["","SCHMDP FACTOR",null,null,{"$f":"SUM(F77:J77)","v":1.0000000000000002},0.99913054543718471,5.2229148549538438E-4,4.3203955170039164E-4,-8.4876474380384928E-5,0]
[]
["SCHMDT-BADDEBT","SCHMDT","BADDEBT","CUST",null,{"$f":"VLOOKUP($D79,$D$140:$J$152,3,FALSE)*$E79","v":0},{"$f":"VLOOKUP($D79,$D$140:$J$152,4,FALSE)*$E79","v":0},{"$f":"VLOOKUP($D79,$D$140:$J$152,5,FALSE)*$E79","v":0},{"$f":"VLOOKUP($D79,$D$140:$J$152,6,FALSE)*$E79","v":0},{"$f":"VLOOKUP($D79,$D$140:$J$152,7,FALSE)*$E79","v":0}]
["SCHMDT-CN","SCHMDT","CN","CUST",null,0,0,0,0,0]
["SCHMDT-GPS","SCHMDT","GPS","GP",0,0,0,0,0,0]
["SCHMDT-GPS","SCHMDT","GPS","P",null,0,0,0,0,0]
["SCHMDT-GPS","SCHMDT","GPS","PTD",81722.263760000016,40169.554016560025,19905.400512669959,21647.309230770028,0,0]
["SCHMDT-SG","SCHMDT","SG","P",170974.55148999998,170974.55148999998,0,0,0,0]
[{"$f":"IF(C85=\"\",\"\",B85&\"-\"&C85)","v":"SCHMDT-SG"},"SCHMDT","SG","T",-123.91426,0,-123.91426,0,0,0]
["SCHMDT-SE","SCHMDT","SE","P",16456.354860000003,16456.354860000003,0,0,0,0]
[{"$f":"IF(C87=\"\",\"\",B87&\"-\"&C87)","v":"SCHMDT-SNPD"},"SCHMDT","SNPD","DPW",-35.5999499999999,0,0,-35.5999499999999,0,0]
[{"$f":"IF(C88=\"\",\"\",B88&\"-\"&C88)","v":"SCHMDT-SNPD"},"SCHMDT","SNPD","P",-305.79566000000102,-305.79566000000102,0,0,0,0]
["SCHMDT-SNP","SCHMDT","SNP","PTD",42461.886119999996,20871.607682718455,10342.602013867428,11247.676423414112,0,0]
["SCHMDT-SO","SCHMDT","SO","ESD",4489.38879,1346.8166369999999,448.93887900000004,2693.6332739999998,0,0]
["SCHMDT-SO","SCHMDT","SO","GP",4931.8950000000004,2387.9582206346863,1206.6551895381667,1307.4089948539925,29.872594973155582,0]
["SCHMDT-SO","SCHMDT","SO","LABOR",45360.793689999999,20906.431783582833,3957.5437989477928,14273.129952053996,6223.6881554153761,0]
["SCHMDT-SO","SCHMDT","SO","PTD",3661.8077999999996,1799.9157078215619,891.92035934637988,969.97173283205757,0,0]
[{"$f":"IF(C94=\"\",\"\",B94&\"-\"&C94)","v":"SCHMDT-OTHER"},"SCHMDT","OTHER","CUST",8.5411300000000008,0,0,0,8.5411300000000008,0]
["SCHMDT-OTHER","SCHMDT","OTHER","DDS2",-124.29094000000001,-114.06899942513193,1.8123569493653209,6.5363790199054774,-18.249380736362625,-0.32129580777624855]
[{"$f":"IF(C96=\"\",\"\",B96&\"-\"&C96)","v":"SCHMDT-OTHER"},"SCHMDT","OTHER","DMSC",-1976.33095,0,0,0,0,-1976.33095]
["SCHMDT-OTHER","SCHMDT","OTHER","DPW",null,0,0,0,0,0]
["SCHMDT-OTHER","SCHMDT","OTHER","LABOR",-850.19771000000003,-391.84941401481331,-74.176274297243538,-267.521386038797,-116.65063564914614,0]
["SCHMDT-OTHER","SCHMDT","OTHER","P",-58252.377560000008,-58252.377560000008,0,0,0,0]
["SCHMDT-OTHER","SCHMDT","OTHER","PT",null,0,0,0,0,0]
[{"$f":"IF(C101=\"\",\"\",B101&\"-\"&C101)","v":"SCHMDT-OTHER"},"SCHMDT","OTHER","GP",4605.5043000000005,2229.9241677597347,1126.7992656038587,1220.8852272115971,27.895639424810629,0]
["SCHMDT-TAXDEPR","SCHMDT","TAXDEPR","TAXDEPR",910975.45600000001,383257.48855542205,231614.96853859586,289672.03523819643,6430.9636677856552,0]
["SCHMDT-SITUS","SCHMDT","SITUS","DMSC",-316.78068000000002,0,0,0,0,-316.78068000000002]
[{"$f":"IF(C104=\"\",\"\",B104&\"-\"&C104)","v":"SCHMDT-SITUS"},"SCHMDT","SITUS","DDS2",1174.6226100000001,1078.0192492295655,-17.127840936074112,-61.772632698011734,172.46739972704356,3.0364346774768571]
["SCHMDT-SITUS","SCHMDT","SITUS","GP",427.01907999999997,206.75698133351594,104.47602572922041,113.19960910892802,2.5864638283356638,0]
["SCHMDT-SITUS","SCHMDT","SITUS","LABOR",1106.5541000000001,510.00205077086025,96.542321251770318,348.18593731440848,151.82379066296099,0]
["SCHMDT-SITUS","SCHMDT","SITUS","P",-13562.100120000003,-13562.100120000003,0,0,0,0]
["SCHMDT-SITUS","SCHMDT","SITUS","PTD",1.44523,0.71038468442143698,0.35202013085945383,0.3828251847191092,0,0]
["","Total-GPS",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-GPS\",E:E)","v":81722.263760000016},40169.554016560025,19905.400512669959,21647.309230770028,0,0]
[{"$f":"IF(C110=\"\",\"\",B110&\"-\"&C110)","v":""},"Total-CN",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-CN\",E:E)","v":0},0,0,0,0,0]
["","Total-SG",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-SG\",E:E)","v":170850.63722999999},170974.55148999998,-123.91426,0,0,0]
[{"$f":"IF(C112=\"\",\"\",B112&\"-\"&C112)","v":""},"Total-SE",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-SE\",E:E)","v":16456.354860000003},16456.354860000003,0,0,0,0]
["","Total-SNP",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-SNP\",E:E)","v":42461.886119999996},20871.607682718455,10342.602013867428,11247.676423414112,0,0]
["","Total SO",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-SO\",E:E)","v":58443.885280000002},26441.12234903908,6505.0582268323396,19244.143953740047,6253.5607503885312,0]
[{"$f":"IF(C115=\"\",\"\",B115&\"-\"&C115)","v":""},"Total OTHER",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-OTHER\",E:E)","v":-56589.151730000005},-56528.371805680217,1054.4353482559804,959.90022019270555,-98.463246960698143,-1976.6522458077764]
[{"$f":"IF(C116=\"\",\"\",B116&\"-\"&C116)","v":""},"Total TAXDEPR",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-TAXDEPR\",E:E)","v":910975.45600000001},383257.48855542205,231614.96853859586,289672.03523819643,6430.9636677856552,0]
["","Total-SITUS",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-SITUS\",E:E)+SUMIF($A:$A,\"SCHMDT-CN\",E:E)","v":-11169.239780000004},-11766.611453981639,184.24252617577605,399.99573891004383,326.87765421834024,-313.74424532252317]
["","Total SCHMDT",null,null,{"$f":"SUMIF($B:$B,\"SCHMDT\",E:E)","v":1212810.6961299998},589569.9000340777,269482.79290639731,343135.46085522335,12912.938825431829,-2290.3964911302996]
["","SCHMDT-GPS",null,null,{"$f":"SUM(F119:J119)","v":1},{"$f":"IF(ISERROR(F109/$E109),\" \",(F109/$E109))","v":0.49153746076502491},0.24357377777893749,0.26488876145603757,0,0]
[{"$f":"IF(C120=\"\",\"\",B120&\"-\"&C120)","v":""},"SCHMDT-CN",null,null,{"$f":"SUM(F120:J120)","v":0}," "," "," "," "," "]
["","SCHMDT-SG",null,null,{"$f":"SUM(F121:J121)","v":1},1.000725278301615,-7.2527830161491283E-4,0,0,0]
[{"$f":"IF(C122=\"\",\"\",B122&\"-\"&C122)","v":""},"SCHMDT-SE",null,null,{"$f":"SUM(F122:J122)","v":1},1,0,0,0,0]
["","SCHMDT-SNP",null,null,1,0.49153746076502497,0.24357377777893746,0.26488876145603757,0,0]
["","SCHMDT-SO",null,null,0.99999999999999978,0.45241896945012755,0.11130434254442742,0.32927557539241076,0.10700111261303419,0]
[{"$f":"IF(C125=\"\",\"\",B125&\"-\"&C125)","v":""},"SCHMDT-OTHER",null,null,{"$f":"SUM(F125:J125)","v":0.99999999999999989},0.99892594388744715,-1.8633171129458462E-2,-1.6962618997588313E-2,1.7399668302237358E-3,3.4929879409375912E-2]
[{"$f":"IF(C126=\"\",\"\",B126&\"-\"&C126)","v":""},"SCHMDT-TAXDEPR",null,null,{"$f":"SUM(F126:J126)","v":0.99999999999999989},0.42071110262209088,0.25424940596708662,0.31798006557730624,7.0594258335162597E-3,0]
[{"$f":"IF(C127=\"\",\"\",B127&\"-\"&C127)","v":""},"SCHMDT-SITUS",null,null,0.99999999999999967,{"$f":"IF(ISERROR(F117/$E117),\" \",(F117/$E117))","v":1.0534836466713973},-1.6495529669412826E-2,-3.5812261782246717E-2,-2.9265882070475178E-2,2.809002685073729E-2]
["","SCHMDT FACTOR",null,null,1,0.48611865142297717,0.22219691314258638,0.2829258201219253,1.0647118191351857E-2,-1.8885028788407012E-3]
[]
["SCHMDF-DGP","SCHMDF","DGP","P",0,{"$f":"VLOOKUP($D130,$D$140:$J$152,3,FALSE)*$E130","v":0},{"$f":"VLOOKUP($D130,$D$140:$J$152,4,FALSE)*$E130","v":0},{"$f":"VLOOKUP($D130,$D$140:$J$152,5,FALSE)*$E130","v":0},{"$f":"VLOOKUP($D130,$D$140:$J$152,6,FALSE)*$E130","v":0},{"$f":"VLOOKUP($D130,$D$140:$J$152,7,FALSE)*$E130","v":0}]
["","Total-SCHMDF",null,null,{"$f":"SUMIF($A:$A,\"SCHMDF\",E:E)","v":0},0,0,0,0,0]
["","SCHMDF FACTOR",null,null,{"$f":"SUM(F132:J132)","v":0},{"$f":"IF(ISERROR(F131/$E131),\" \",(F131/$E131))","v":" "},{"$f":"IF(ISERROR(G131/$E131),\" \",(G131/$E131))","v":" "},{"$f":"IF(ISERROR(H131/$E131),\" \",(H131/$E131))","v":" "},{"$f":"IF(ISERROR(I131/$E131),\" \",(I131/$E131))","v":" "},{"$f":"IF(ISERROR(J131/$E131),\" \",(J131/$E131))","v":" "}]
[]
["","Total-SCHMD",null,null,{"$f":"SUM(E131,E118,E75)","v":1240183.3292799997},616918.73392328911,269497.08939962712,343147.28691537835,12910.615532835549,-2290.3964911302996]
["","SCHMD FACTOR",null,null,{"$f":"SUM(F135:J135)","v":1},{"$f":"IF(ISERROR(F134/$E134),\" \",(F134/$E134))","v":0.4974415631610265},{"$f":"IF(ISERROR(G134/$E134),\" \",(G134/$E134))","v":0.21730423481509481},{"$f":"IF(ISERROR(H134/$E134),\" \",(H134/$E134))","v":0.27669077531835218},{"$f":"IF(ISERROR(I134/$E134),\" \",(I134/$E134))","v":1.0410247604546443E-2},{"$f":"IF(ISERROR(J134/$E134),\" \",(J134/$E134))","v":-1.8468208990198337E-3}]
[]
["","Net SCHM"]
[""]
[null,null,null,null,"Total","Production","Transmission","Poles & Wires","Customers","Miscellaneous"]
[null,null,null,"DMSC",{"$f":"SUM(F140:J140)","v":1},0,0,0,0,1]
[null,null,null,"DPW",{"$f":"SUM(F141:J141)","v":1},0,0,1,0,0]
[null,null,null,"DDS2",1,{"$f":"DDS!F34","v":0.91775795906871349},{"$f":"DDS!G34","v":-1.4581569254889543E-2},{"$f":"DDS!H34","v":-5.2589344162217111E-2},{"$f":"DDS!I34","v":0.14682792435524764},{"$f":"DDS!J34","v":2.5850299931455063E-3}]
[null,null,null,"CUST",1,0,0,0,1,0]
[null,null,null,"ESD",1,0.3,0.1,0.6,0,0]
[null,null,null,"GP",1.0000000000000002,{"$f":"'GROSS PLANT'!E42","v":0.48418675187421589},{"$f":"'GROSS PLANT'!F42","v":0.24466360081432525},{"$f":"'GROSS PLANT'!G42","v":0.26509262562442881},{"$f":"'GROSS PLANT'!H42","v":6.0570216870301534E-3},{"$f":"'GROSS PLANT'!I42","v":0}]
[null,null,null,"LABOR",1,{"$f":"'FORM 1'!C25","v":0.46089210710155087},{"$f":"'FORM 1'!D25","v":8.7245911656529326E-2},{"$f":"'FORM 1'!E25","v":0.31465785298198112},{"$f":"'FORM 1'!F25","v":0.13720412825993866},{"$f":"'FORM 1'!G25","v":0}]
[null,null,null,"P",1,{"$f":"'FORM 1'!C13","v":1},{"$f":"'FORM 1'!D13","v":0},{"$f":"'FORM 1'!E13","v":0},{"$f":"'FORM 1'!F13","v":0},{"$f":"'FORM 1'!G13","v":0}]
[null,null,null,"PT",{"$f":"SUM(F148:J148)","v":1},{"$f":"+'FORM 1'!C17","v":0.66865725211685645},{"$f":"+'FORM 1'!D17","v":0.3313427478831435},0,0,0]
[null,null,null,"PTD",1,{"$f":"'FORM 1'!C16","v":0.49153746076502491},{"$f":"'FORM 1'!D16","v":0.24357377777893749},{"$f":"'FORM 1'!E16","v":0.26488876145603757},{"$f":"'FORM 1'!F16","v":0},{"$f":"'FORM 1'!G16","v":0}]
[null,null,null,"T",1,{"$f":"'FORM 1'!C14","v":0},{"$f":"'FORM 1'!D14","v":1},{"$f":"'FORM 1'!E14","v":0},{"$f":"'FORM 1'!F14","v":0},{"$f":"'FORM 1'!G14","v":0}]
[null,null,null,"TAXDEPR",0.99999999999999989,{"$f":"'TAX DEPR'!C24","v":0.42071110262209088},{"$f":"'TAX DEPR'!D24","v":0.25424940596708662},{"$f":"'TAX DEPR'!E24","v":0.31798006557730624},{"$f":"'TAX DEPR'!F24","v":7.0594258335162597E-3},{"$f":"'TAX DEPR'!G24","v":0}]
[null,null,null,"TD",1,{"$f":"'FORM 1'!C18","v":0},{"$f":"'FORM 1'!D18","v":0.47903976986272157},{"$f":"'FORM 1'!E18","v":0.52096023013727843},{"$f":"'FORM 1'!F18","v":0},{"$f":"'FORM 1'!G18","v":0}]

{"sheet":"DDS","index":9,"n_rows":83,"n_cols":10,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"+'TOTAL FUNCFAC'!A1","v":"PacifiCorp"}]
[null,{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended December 2016"}]
[null,"Reg Assets / Deferred Debits"]
[]
[null,"Pri-Acct","Factor","Function","Total","Production","Transmission","DPW","CUST","DMSC"]
[{"$f":"\"RA\"&\"-\"&C6","v":"RA-SE"},"182M","SE","P",207566.08481999993,{"$f":"VLOOKUP($D6,$D$71:$J$83,3,FALSE)*$E6","v":207566.08481999993},{"$f":"VLOOKUP($D6,$D$71:$J$83,4,FALSE)*$E6","v":0},{"$f":"VLOOKUP($D6,$D$71:$J$83,5,FALSE)*$E6","v":0},{"$f":"VLOOKUP($D6,$D$71:$J$83,6,FALSE)*$E6","v":0},{"$f":"VLOOKUP($D6,$D$71:$J$83,7,FALSE)*$E6","v":0}]
["RA-SG","182M","SG","P",3449.4055199999998,3449.4055199999998,0,0,0,0]
["RA-SGCT","182M","SGCT","P",654.74794000000895,654.74794000000895,0,0,0,0]
["RA-SG-P","182M","SG-P","P",0,0,0,0,0,0]
["RA-SO","182M","SO","DMSC",3444.5121199999999,0,0,0,0,3444.5121199999999]
["RA-SO","182M","SO","LABOR",527126.7932999999,242948.57847372061,45989.657640041383,165864.58502905452,72323.972157183365,0]
["RA-SO","182M","SO","ESD",21060.480630000002,6318.1441890000006,2106.0480630000002,12636.288378000001,0,0]
["RA-SO","182M","SO","P",0,0,0,0,0,0]
["RA-SO","182M","SO","TD",0,0,0,0,0,0]
[{"$f":"\"RA\"&\"-\"&C15","v":"RA-OTHER"},"182M","OTHER","CUST",-1016.4875700005487,0,0,0,-1016.4875700005487,0]
[{"$f":"\"RA\"&\"-\"&C16","v":"RA-OTHER"},"182M","OTHER","DMSC",40.605559999999997,0,0,0,0,40.605559999999997]
["RA-OTHER","182M","OTHER","LABOR",1010.91511,465.92279514869608,88.198210379310623,318.09237805964329,138.70172641235001,0]
["RA-OTHER","182M","OTHER","P",59780.913819999994,59780.913819999994,0,0,0,0]
["RA-OTHER","182M","OTHER","DPW",0,0,0,0,0,0]
["RA-OTHER","182M","OTHER","PTD",875.23119000000008,430.2089167149511,213.18336737825504,231.83890590679391,0,0]
["RA-OTHER","182M","OTHER","ESD",0,0,0,0,0,0]
["RA-TROJD","182M","TROJD","P",0,0,0,0,0,0]
["RA-TROJP","182M","TROJP","P",0,0,0,0,0,0]
["RA-SITUS","182M","SITUS","DMSC",26.86647,0,0,0,0,26.86647]
["RA-SITUS","182M","SITUS","LABOR",-1737.0175299999999,-800.57766947403127,-151.54767796822276,-546.56620658186398,-238.32597597588185,0]
["RA-SITUS","182M","SITUS","P",10338.926060000009,10338.926060000009,0,0,0,0]
["RA-SITUS","182M","SITUS","PTD",0,0,0,0,0,0]
["RA-SITUS","182M","SITUS","CUST",1764.3229800000004,0,0,0,1764.3229800000004,0]
[null,"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"RA-SO\",E:E)","v":551631.78604999988},249266.72266272063,48095.705703041385,178500.87340705452,72323.972157183365,3444.5121199999999]
[null,"Total-OTHER",null,null,{"$f":"SUMIF($A:$A,\"RA-OTHER\",E:E)","v":60691.178109999448},60677.045531863645,301.38157775756565,549.93128396643715,-877.78584358819865,40.605559999999997]
[null,"Total SITUS",null,null,{"$f":"SUMIF($A:$A,\"RA-SITUS\",E:E)","v":10393.09798000001},9538.3483905259782,-151.54767796822276,-546.56620658186398,1525.9970040241185,26.86647]
[null,"Total RA",null,null,{"$f":"SUMIF($B:$B,\"182M\",E:E)","v":834386.30041999929},531152.35486511013,48245.53960283073,178504.23848443909,72972.183317619289,3511.9841499999998]
[null,"DDSO2 FACTOR",null,null,{"$f":"SUM(F33:J33)","v":1},{"$f":"F29/$E29","v":0.45187157260754207},{"$f":"G29/$E29","v":8.7188060803084305E-2},{"$f":"H29/$E29","v":0.32358699756086068},{"$f":"I29/$E29","v":0.13110914560428888},{"$f":"J29/$E29","v":6.2442234242241247E-3}]
[null,"DDS2 FACTOR",null,null,{"$f":"SUM(F34:J34)","v":1},{"$f":"F31/$E31","v":0.91775795906871349},{"$f":"G31/$E31","v":-1.4581569254889543E-2},{"$f":"H31/$E31","v":-5.2589344162217111E-2},{"$f":"I31/$E31","v":0.14682792435524764},{"$f":"J31/$E31","v":2.5850299931455063E-3}]
[]
[{"$f":"\"DD\"&\"-\"&C36","v":"DD-SE"},"186M","SE","P",2318.4521799999989,{"$f":"VLOOKUP($D36,$D$71:$J$83,3,FALSE)*$E36","v":2318.4521799999989},{"$f":"VLOOKUP($D36,$D$71:$J$83,4,FALSE)*$E36","v":0},{"$f":"VLOOKUP($D36,$D$71:$J$83,5,FALSE)*$E36","v":0},{"$f":"VLOOKUP($D36,$D$71:$J$83,6,FALSE)*$E36","v":0},{"$f":"VLOOKUP($D36,$D$71:$J$83,7,FALSE)*$E36","v":0}]
["DD-SG","186M","SG","P",38588.96433000001,{"$f":"VLOOKUP($D37,$D$71:$J$83,3,FALSE)*$E37","v":38588.96433000001},{"$f":"VLOOKUP($D37,$D$71:$J$83,4,FALSE)*$E37","v":0},{"$f":"VLOOKUP($D37,$D$71:$J$83,5,FALSE)*$E37","v":0},{"$f":"VLOOKUP($D37,$D$71:$J$83,6,FALSE)*$E37","v":0},{"$f":"VLOOKUP($D37,$D$71:$J$83,7,FALSE)*$E37","v":0}]
["DD-SG","186M","SG","T",12943.32696,{"$f":"VLOOKUP($D38,$D$71:$J$83,3,FALSE)*$E38","v":0},{"$f":"VLOOKUP($D38,$D$71:$J$83,4,FALSE)*$E38","v":12943.32696},{"$f":"VLOOKUP($D38,$D$71:$J$83,5,FALSE)*$E38","v":0},{"$f":"VLOOKUP($D38,$D$71:$J$83,6,FALSE)*$E38","v":0},{"$f":"VLOOKUP($D38,$D$71:$J$83,7,FALSE)*$E38","v":0}]
["DD-SO","186M","SO","DMSC",191.90201999999391,{"$f":"VLOOKUP($D39,$D$71:$J$83,3,FALSE)*$E39","v":0},{"$f":"VLOOKUP($D39,$D$71:$J$83,4,FALSE)*$E39","v":0},{"$f":"VLOOKUP($D39,$D$71:$J$83,5,FALSE)*$E39","v":0},{"$f":"VLOOKUP($D39,$D$71:$J$83,6,FALSE)*$E39","v":0},{"$f":"VLOOKUP($D39,$D$71:$J$83,7,FALSE)*$E39","v":191.90201999999391}]
[]
["DD-OTHER","186M","OTHER","DMSC",2005.63805,{"$f":"VLOOKUP($D41,$D$71:$J$83,3,FALSE)*$E41","v":0},{"$f":"VLOOKUP($D41,$D$71:$J$83,4,FALSE)*$E41","v":0},{"$f":"VLOOKUP($D41,$D$71:$J$83,5,FALSE)*$E41","v":0},{"$f":"VLOOKUP($D41,$D$71:$J$83,6,FALSE)*$E41","v":0},{"$f":"VLOOKUP($D41,$D$71:$J$83,7,FALSE)*$E41","v":2005.63805}]
["DD-OTHER","186M","OTHER","LABOR",0,0,0,0,0,0]
["DD-OTHER","186M","OTHER","P",0,0,0,0,0,0]
["DD-OTHER","186M","OTHER","PTD",60.722360000000002,29.847314646059719,14.790374620852644,16.084670733087638,0,0]
["DD-OTHER","186M","OTHER","T",3063.3444199999999,0,3063.3444199999999,0,0,0]
["DD-SITUS","186M","SITUS","T",0,0,0,0,0,0]
["DD-SITUS","186M","SITUS","LABOR",0,0,0,0,0,0]
[null,"Total SITUS",null,null,{"$f":"SUMIF($A:$A,\"DD-SITUS\",E:E)","v":0},0,0,0,0,0]
[null,"Total SG",null,null,{"$f":"SUMIF($A:$A,\"DD-SG\",E:E)","v":51532.291290000008},38588.96433000001,12943.32696,0,0,0]
[null,"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"DD-SO\",E:E)","v":191.90201999999391},0,0,0,0,191.90201999999391]
[null,"Total-DD",null,null,{"$f":"SUMIF($B:$B,\"186M\",E:E)","v":59172.350320000005},40937.26382464607,16021.461754620852,16.084670733087638,0,2197.5400699999941]
[null,"DDS6 FACTOR",null,null,{"$f":"SUM(F52:J52)","v":0},{"$f":"IFERROR(F48/$E48,0)","v":0},{"$f":"IFERROR(G48/$E48,0)","v":0},0,0,0]
[null,"DEFSG FACTOR",null,null,{"$f":"SUM(F53:J53)","v":1},{"$f":"F49/$E49","v":0.74883074988533083},0.25116925011466917,0,0,0]
[null,"DDSO6 FACTOR",null,null,{"$f":"SUM(F54:J54)","v":1},{"$f":"IFERROR(F50/$E50,0)","v":0},{"$f":"IFERROR(G50/$E50,0)","v":0},0,0,1]
[]
[null,"Major Adjustment"]
[null,"1998 Early Retirement",null,"LABOR",0,{"$f":"VLOOKUP($D57,$D$71:$J$83,3,FALSE)*$E57","v":0},{"$f":"VLOOKUP($D57,$D$71:$J$83,4,FALSE)*$E57","v":0},{"$f":"VLOOKUP($D57,$D$71:$J$83,5,FALSE)*$E57","v":0},{"$f":"VLOOKUP($D57,$D$71:$J$83,6,FALSE)*$E57","v":0},{"$f":"VLOOKUP($D57,$D$71:$J$83,7,FALSE)*$E57","v":0}]
[null,"1999 Early Retirement",null,"LABOR",0,{"$f":"VLOOKUP($D58,$D$71:$J$83,3,FALSE)*$E58","v":0},{"$f":"VLOOKUP($D58,$D$71:$J$83,4,FALSE)*$E58","v":0},{"$f":"VLOOKUP($D58,$D$71:$J$83,5,FALSE)*$E58","v":0},{"$f":"VLOOKUP($D58,$D$71:$J$83,6,FALSE)*$E58","v":0},{"$f":"VLOOKUP($D58,$D$71:$J$83,7,FALSE)*$E58","v":0}]
[null,"Transition Planning",null,"PTD",0,{"$f":"VLOOKUP($D59,$D$71:$J$83,3,FALSE)*$E59","v":0},{"$f":"VLOOKUP($D59,$D$71:$J$83,4,FALSE)*$E59","v":0},{"$f":"VLOOKUP($D59,$D$71:$J$83,5,FALSE)*$E59","v":0},{"$f":"VLOOKUP($D59,$D$71:$J$83,6,FALSE)*$E59","v":0},{"$f":"VLOOKUP($D59,$D$71:$J$83,7,FALSE)*$E59","v":0}]
[null,"Environmental Clean-up",null,"ESD",0,{"$f":"VLOOKUP($D60,$D$71:$J$83,3,FALSE)*$E60","v":0},{"$f":"VLOOKUP($D60,$D$71:$J$83,4,FALSE)*$E60","v":0},{"$f":"VLOOKUP($D60,$D$71:$J$83,5,FALSE)*$E60","v":0},{"$f":"VLOOKUP($D60,$D$71:$J$83,6,FALSE)*$E60","v":0},{"$f":"VLOOKUP($D60,$D$71:$J$83,7,FALSE)*$E60","v":0}]
[null,"Y2K",null,"PTD",0,{"$f":"VLOOKUP($D61,$D$71:$J$83,3,FALSE)*$E61","v":0},{"$f":"VLOOKUP($D61,$D$71:$J$83,4,FALSE)*$E61","v":0},{"$f":"VLOOKUP($D61,$D$71:$J$83,5,FALSE)*$E61","v":0},{"$f":"VLOOKUP($D61,$D$71:$J$83,6,FALSE)*$E61","v":0},{"$f":"VLOOKUP($D61,$D$71:$J$83,7,FALSE)*$E61","v":0}]
[null,"Subtotal Major Adjustments",null,null,{"$f":"SUM(E57:E61)","v":0},0,0,0,0,0]
[]
[null,"Total 186M SO",null,null,{"$f":"+E50+E62","v":191.90201999999391},0,0,0,0,191.90201999999391]
[]
[null,"Total 182 &186",null,null,{"$f":"SUM(E51,E32)","v":893558.65073999926},{"$f":"SUM(F32,F51)","v":572089.61868975614},{"$f":"SUM(G32,G51)","v":64267.001357451583},{"$f":"SUM(H32,H51)","v":178520.32315517217},{"$f":"SUM(I32,I51)","v":72972.183317619289},{"$f":"SUM(J32,J51)","v":5709.5242199999939}]
[]
[]
[]
[null,null,null,null,"Total","Production","Transmission","Poles & Wires","Customers","Miscellaneous"]
[null,null,null,"DMSC",{"$f":"SUM(F71:J71)","v":1},0,0,0,0,1]
[null,null,null,"DPW",{"$f":"SUM(F72:J72)","v":1},0,0,1,0,0]
[null,null,null,"CUST",1,0,0,0,1,0]
[null,null,null,"ESD",1,0.3,0.1,0.6,0,0]
[null,null,null,"GP",1.0000000000000002,{"$f":"'GROSS PLANT'!$E$42","v":0.48418675187421589},{"$f":"'GROSS PLANT'!$F$42","v":0.24466360081432525},{"$f":"'GROSS PLANT'!$G$42","v":0.26509262562442881},{"$f":"'GROSS PLANT'!$H$42","v":6.0570216870301534E-3},{"$f":"'GROSS PLANT'!$I$42","v":0}]
[null,null,null,"RETAIL",1,0,0,0,1,0]
[null,null,null,"LABOR",1,{"$f":"'FORM 1'!$C$25","v":0.46089210710155087},{"$f":"'FORM 1'!$D$25","v":8.7245911656529326E-2},{"$f":"'FORM 1'!$E$25","v":0.31465785298198112},{"$f":"'FORM 1'!$F$25","v":0.13720412825993866},{"$f":"'FORM 1'!$G$25","v":0}]
[null,null,null,"P",1,{"$f":"'FORM 1'!$C$13","v":1},{"$f":"'FORM 1'!$D$13","v":0},{"$f":"'FORM 1'!$E$13","v":0},{"$f":"'FORM 1'!$F$13","v":0},{"$f":"'FORM 1'!$G$13","v":0}]
[null,null,null,"PT",{"$f":"SUM(F79:J79)","v":1},{"$f":"'FORM 1'!$C$17","v":0.66865725211685645},{"$f":"'FORM 1'!$D$17","v":0.3313427478831435},{"$f":"'FORM 1'!$E$17","v":0},{"$f":"'FORM 1'!$F$17","v":0},{"$f":"'FORM 1'!$G$17","v":0}]
[null,null,null,"PTD",1,{"$f":"'FORM 1'!$C$16","v":0.49153746076502491},{"$f":"'FORM 1'!$D$16","v":0.24357377777893749},{"$f":"'FORM 1'!$E$16","v":0.26488876145603757},{"$f":"'FORM 1'!$F$16","v":0},{"$f":"'FORM 1'!$G$16","v":0}]
[null,null,null,"T",1,{"$f":"'FORM 1'!$C$14","v":0},{"$f":"'FORM 1'!$D$14","v":1},{"$f":"'FORM 1'!$E$14","v":0},{"$f":"'FORM 1'!$F$14","v":0},{"$f":"'FORM 1'!$G$14","v":0}]
[null,null,null,"TAXDEPR",0.99999999999999989,{"$f":"'TAX DEPR'!C24","v":0.42071110262209088},{"$f":"'TAX DEPR'!D24","v":0.25424940596708662},{"$f":"'TAX DEPR'!E24","v":0.31798006557730624},{"$f":"'TAX DEPR'!F24","v":7.0594258335162597E-3},{"$f":"'TAX DEPR'!G24","v":0}]
[null,null,null,"TD",1,{"$f":"'FORM 1'!$C$18","v":0},{"$f":"'FORM 1'!$D$18","v":0.47903976986272157},{"$f":"'FORM 1'!$E$18","v":0.52096023013727843},{"$f":"'FORM 1'!$F$18","v":0},{"$f":"'FORM 1'!$G$18","v":0}]

{"sheet":"ACCUMDIT","index":10,"n_rows":72,"n_cols":14,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'TOTAL FUNCFAC'!A1","v":"PacifiCorp"}]
[{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended December 2016"}]
["Deferred Income Tax - Balance"]
[]
[]
[]
["DITBALRL"]
["Pacific Division",null,"Total","Production","Transmission","DPW","CUST","DMSC"]
["Pacific Division"]
["Production","P",38496372,{"$f":"VLOOKUP($B10,$B$59:$H$72,3,FALSE)*$C10","v":38496372},{"$f":"VLOOKUP($B10,$B$59:$H$72,4,FALSE)*$C10","v":0},{"$f":"VLOOKUP($B10,$B$59:$H$72,5,FALSE)*$C10","v":0},{"$f":"VLOOKUP($B10,$B$59:$H$72,6,FALSE)*$C10","v":0},{"$f":"VLOOKUP($B10,$B$59:$H$72,7,FALSE)*$C10","v":0}]
["Transmission","T",16878780,{"$f":"VLOOKUP($B11,$B$59:$H$72,3,FALSE)*$C11","v":0},{"$f":"VLOOKUP($B11,$B$59:$H$72,4,FALSE)*$C11","v":16878780},{"$f":"VLOOKUP($B11,$B$59:$H$72,5,FALSE)*$C11","v":0},{"$f":"VLOOKUP($B11,$B$59:$H$72,6,FALSE)*$C11","v":0},{"$f":"VLOOKUP($B11,$B$59:$H$72,7,FALSE)*$C11","v":0}]
["Distribution","DPW",17401021,{"$f":"VLOOKUP($B12,$B$59:$H$72,3,FALSE)*$C12","v":0},{"$f":"VLOOKUP($B12,$B$59:$H$72,4,FALSE)*$C12","v":0},{"$f":"VLOOKUP($B12,$B$59:$H$72,5,FALSE)*$C12","v":17401021},{"$f":"VLOOKUP($B12,$B$59:$H$72,6,FALSE)*$C12","v":0},{"$f":"VLOOKUP($B12,$B$59:$H$72,7,FALSE)*$C12","v":0}]
["General","G",-301646,{"$f":"VLOOKUP($B13,$B$59:$H$72,3,FALSE)*$C13","v":-66101.149206301649},{"$f":"VLOOKUP($B13,$B$59:$H$72,4,FALSE)*$C13","v":-105960.10396314776},{"$f":"VLOOKUP($B13,$B$59:$H$72,5,FALSE)*$C13","v":-124596.35111900428},{"$f":"VLOOKUP($B13,$B$59:$H$72,6,FALSE)*$C13","v":-4988.3957115462936},{"$f":"VLOOKUP($B13,$B$59:$H$72,7,FALSE)*$C13","v":0}]
["Mining Plant","P",5248,{"$f":"VLOOKUP($B14,$B$59:$H$72,3,FALSE)*$C14","v":5248},{"$f":"VLOOKUP($B14,$B$59:$H$72,4,FALSE)*$C14","v":0},{"$f":"VLOOKUP($B14,$B$59:$H$72,5,FALSE)*$C14","v":0},{"$f":"VLOOKUP($B14,$B$59:$H$72,6,FALSE)*$C14","v":0},{"$f":"VLOOKUP($B14,$B$59:$H$72,7,FALSE)*$C14","v":0}]
[]
["     Total Pacific Division",null,{"$f":"SUM(C10:C14)","v":72479775},{"$f":"SUM(D10:D14)","v":38435518.850793697},16772819.896036852,17276424.648880996,-4988.3957115462936,0]
[]
["Utah Division"]
["Production","P",62329130,{"$f":"VLOOKUP($B19,$B$59:$H$72,3,FALSE)*$C19","v":62329130},{"$f":"VLOOKUP($B19,$B$59:$H$72,4,FALSE)*$C19","v":0},{"$f":"VLOOKUP($B19,$B$59:$H$72,5,FALSE)*$C19","v":0},{"$f":"VLOOKUP($B19,$B$59:$H$72,6,FALSE)*$C19","v":0},{"$f":"VLOOKUP($B19,$B$59:$H$72,7,FALSE)*$C19","v":0}]
["Transmission","T",39083264,0,39083264,0,0,0]
["Distribution","DPW",27580897,0,0,27580897,0,0]
["General","G",-695917,-152499.66335440159,-244456.87219363727,-287451.91012539237,-11508.554326568767,0]
["Mining Plant","P",13520,13520,0,0,0,0]
[]
["     Total Utah Division",null,{"$f":"SUM(C19:C23)","v":128310894},{"$f":"SUM(D19:D23)","v":62190150.336645596},38838807.127806365,27293445.089874607,-11508.554326568767,0]
[]
["PACIFICORP"]
["Prod / Other Prod","P",467189333,{"$f":"VLOOKUP($B28,$B$59:$H$72,3,FALSE)*$C28","v":467189333},{"$f":"VLOOKUP($B28,$B$59:$H$72,4,FALSE)*$C28","v":0},{"$f":"VLOOKUP($B28,$B$59:$H$72,5,FALSE)*$C28","v":0},{"$f":"VLOOKUP($B28,$B$59:$H$72,6,FALSE)*$C28","v":0},{"$f":"VLOOKUP($B28,$B$59:$H$72,7,FALSE)*$C28","v":0}]
["Cholla Unit 4","P",31303088,31303088,0,0,0,0]
["Gadsby Unit 4, 5 & 6","P",5888838,5888838,0,0,0,0]
["Hydro-PPL","P",38303388,38303388,0,0,0,0]
["Hydro-UPL","P",11779913,11779913,0,0,0,0]
["Transmission","T",274172198,0,274172198,0,0,0]
["Distribution","DPW",937458888,0,0,937458888,0,0,null,null,null,null,null," "]
["General/ Intangibles","G",67290041,14745592.649128964,23637176.491796594,27794479.539752539,1112792.3193219013,0]
["Mining","P",-3059972,-3059972,0,0,0,0]
["WCA - CAEE 2007+","P",2345795,2345795,0,0,0,0]
["WCA - CAGE 2007+","PT",1790826035,1197448815.5824254,593377219.41757452,0,0,0]
["WCA - CAGW 2007+","PT",410130366,274236643.5392406,135893722.46075937,0,0,0]
["WCA_CAGW 2007+ -Marengo","P",0,0,0,0,0,0]
["WCA CAGW 2007+ -Goodnoe","P",0,0,0,0,0,0]
["WCA - General 2007+","G",166230415,36426876.088330179,58392261.310400926,68662283.451455668,2748994.1498132269,0]
["WCA - JBG 2007+","P",144114817,144114817,0,0,0,0]
["OREGON EXTRA BOOK DEPR","P",-57628316,-57628316,0,0,0,0]
[]
["     Total PC (Post Merger)",null,{"$f":"SUM(C28:C44)","v":4286344827},{"$f":"SUM(D28:D44)","v":2163094811.8591251},1085472577.6805315,1033915650.9912082,3861786.469135128,0]
[]
["Total Deferred Taxes ",null,{"$f":"C16+C25+C46","v":4487135496},{"$f":"D16+D25+D46","v":2263720481.0465646},1141084204.7043748,1078485520.7299638,3845289.5190970129,0]
[]
["ACCMDITRL FACTOR",null,1,{"$f":"D48/$C$48","v":0.50449122453835626},{"$f":"E48/$C$48","v":0.25430125872543402},0.24035055809911826,8.5695863709149133E-4,0]
[]
[]
[]
[null,"ACCUMDIT",{"$f":"SUM(D54:F54)","v":0.40916639709420199},9.962591977161854E-2,0.30954047732258344,0]
[]
[]
[]
[null,null,"Total","Production","Transmission","Poles & Wires","Customers","Miscellaneous"]
[null,"DMSC",{"$f":"SUM(D59:H59)","v":1},0,0,0,0,1]
[null,"DPW",{"$f":"SUM(D60:H60)","v":1},0,0,1,0,0]
[null,"DDS2",1,{"$f":"DDS!F34","v":0.91775795906871349},{"$f":"DDS!G34","v":-1.4581569254889543E-2},{"$f":"DDS!H34","v":-5.2589344162217111E-2},{"$f":"DDS!I34","v":0.14682792435524764},{"$f":"DDS!J34","v":2.5850299931455063E-3}]
[null,"CUST",1,0,0,0,1,0]
[null,"ESD",1,0.3,0.1,0.6,0,0]
[null,"G",{"$f":"SUM(D64:H64)","v":1},{"$f":"'GENERAL PLANT'!E38","v":0.21913484417596008},{"$f":"'GENERAL PLANT'!F38","v":0.35127302852730607},{"$f":"'GENERAL PLANT'!G38","v":0.41305487597715296},{"$f":"'GENERAL PLANT'!H38","v":1.6537251319580878E-2},{"$f":"'GENERAL PLANT'!I38","v":0}]
[null,"GP",1.0000000000000002,{"$f":"'GROSS PLANT'!E42","v":0.48418675187421589},{"$f":"'GROSS PLANT'!F42","v":0.24466360081432525},{"$f":"'GROSS PLANT'!G42","v":0.26509262562442881},{"$f":"'GROSS PLANT'!H42","v":6.0570216870301534E-3},{"$f":"'GROSS PLANT'!I42","v":0}]
[null,"LABOR",1,{"$f":"'FORM 1'!C25","v":0.46089210710155087},{"$f":"'FORM 1'!D25","v":8.7245911656529326E-2},{"$f":"'FORM 1'!E25","v":0.31465785298198112},{"$f":"'FORM 1'!F25","v":0.13720412825993866},{"$f":"'FORM 1'!G25","v":0}]
[null,"P",1,1,0,0,0,0]
[null,"PT",{"$f":"SUM(D68:H68)","v":1},{"$f":"+'FORM 1'!C17","v":0.66865725211685645},{"$f":"+'FORM 1'!D17","v":0.3313427478831435},{"$f":"+'FORM 1'!E17","v":0},{"$f":"+'FORM 1'!F17","v":0},{"$f":"+'FORM 1'!G17","v":0}]
[null,"PTD",1,{"$f":"'FORM 1'!C16","v":0.49153746076502491},{"$f":"'FORM 1'!D16","v":0.24357377777893749},{"$f":"'FORM 1'!E16","v":0.26488876145603757},{"$f":"'FORM 1'!F16","v":0},{"$f":"'FORM 1'!G16","v":0}]
[null,"T",1,0,1,0,0,0]
[null,"TAXDEPR",0.99999999999999989,{"$f":"'TAX DEPR'!C24","v":0.42071110262209088},{"$f":"'TAX DEPR'!D24","v":0.25424940596708662},{"$f":"'TAX DEPR'!E24","v":0.31798006557730624},{"$f":"'TAX DEPR'!F24","v":7.0594258335162597E-3},{"$f":"'TAX DEPR'!G24","v":0}]
[null,"TD",1,{"$f":"'FORM 1'!C18","v":0},{"$f":"'FORM 1'!D18","v":0.47903976986272157},{"$f":"'FORM 1'!E18","v":0.52096023013727843},{"$f":"'FORM 1'!F18","v":0},{"$f":"'FORM 1'!G18","v":0}]