{"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":1,"defined_names":26,"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 2015"]
["FUNCTIONAL FACTORS "]
[]
[]
["Function","Description","Production","Transmission","DPW","CUST","DMSC","Total"]
["ACCMDIT","Deferred Income Tax",{"$f":"ACCUMDIT!D50","v":0.50931226634999327},{"$f":"ACCUMDIT!E50","v":0.254695722622725},{"$f":"ACCUMDIT!F50","v":0.2350913856448644},{"$f":"ACCUMDIT!G50","v":9.0062538241735522E-4},{"$f":"ACCUMDIT!H50","v":0},1]
["BOOKDEPR","Book Depreciation",{"$f":"BOOKDPR!C13","v":0.62137806293194875},{"$f":"BOOKDPR!D13","v":0.15747481403283387},{"$f":"BOOKDPR!E13","v":0.21930978284539648},{"$f":"BOOKDPR!F13","v":1.8373401898210942E-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.96825470787793089},{"$f":"DDS!G34","v":-3.9949466467465817E-3},{"$f":"DDS!H34","v":-1.6544736081990689E-2},{"$f":"DDS!I34","v":5.1831960997472233E-2},{"$f":"DDS!J34","v":4.5301385333423904E-4},1]
["DDS6","Deferred Debits - Situs",0,0,0,0,0,0]
["DDSO2","Deferred Debits - System Overhead",{"$f":"DDS!F33","v":0.45389440789409657},{"$f":"DDS!G33","v":7.8927501186535201E-2},{"$f":"DDS!H33","v":0.32790022703867855},{"$f":"DDS!I33","v":0.13148508970814868},{"$f":"DDS!J33","v":7.7927741725409829E-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.78178302998949389},{"$f":"DDS!G53","v":0.21821697001050616},{"$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.51225681198725614},{"$f":"'FORM 1'!D39","v":0.48774318801274391},{"$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.22038330506248377},{"$f":"'GENERAL PLANT'!F38","v":0.33999351096339209},{"$f":"'GENERAL PLANT'!G38","v":0.42239697137578525},{"$f":"'GENERAL PLANT'!H38","v":1.7226212598338838E-2},{"$f":"'GENERAL PLANT'!I38","v":0},1]
["G-DGP","General Plant - DGP Factor",{"$f":"+C70","v":0.67792786344641009},{"$f":"+D70","v":0.32207213655358996},{"$f":"+E70","v":0},{"$f":"+F70","v":0},{"$f":"+G70","v":0},1]
["G-DGU","General Plant - DGU Factor",{"$f":"+C21","v":0.67792786344641009},{"$f":"+D21","v":0.32207213655358996},{"$f":"+E21","v":0},{"$f":"+F21","v":0},{"$f":"+G21","v":0},1]
["GP","Total Plant",{"$f":"'GROSS PLANT'!E42","v":0.48783982134533266},{"$f":"'GROSS PLANT'!F42","v":0.24307642201472882},{"$f":"'GROSS PLANT'!G42","v":0.26320846349075677},{"$f":"'GROSS PLANT'!H42","v":5.8752931491821312E-3},{"$f":"'GROSS PLANT'!I42","v":0},1]
["G-SG","General Plant - SG Factor",{"$f":"'GENERAL PLANT'!E34","v":0.44203846332582047},{"$f":"'GENERAL PLANT'!F34","v":0.55796153667417958},{"$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.2964371062520515},{"$f":"'GENERAL PLANT'!G36","v":0.70356289374794845},{"$f":"'GENERAL PLANT'!H36","v":0},{"$f":"'GENERAL PLANT'!I36","v":0},1]
["I","Intangible Plant",{"$f":"'INTANGIBLE PLANT'!D35","v":0.51932003920804659},{"$f":"'INTANGIBLE PLANT'!E35","v":0.16798508215417879},{"$f":"'INTANGIBLE PLANT'!F35","v":0.14318063459787328},{"$f":"'INTANGIBLE PLANT'!G35","v":0.16951424403990153},{"$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.83989590246944101},{"$f":"'INTANGIBLE PLANT'!E33","v":0.16010409753055904},{"$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":1.857502224707865},{"$f":"'INTANGIBLE PLANT'!E34","v":-0.42340579880183937},{"$f":"'INTANGIBLE PLANT'!F34","v":-0.43409642590602576},{"$f":"'INTANGIBLE PLANT'!G34","v":0},{"$f":"'INTANGIBLE PLANT'!H34","v":0},1]
["LABOR","Direct Labor Expense",{"$f":"'FORM 1'!C25","v":0.46309363850275576},{"$f":"'FORM 1'!D25","v":7.8815542097072699E-2},{"$f":"'FORM 1'!E25","v":0.32083117523618421},{"$f":"'FORM 1'!F25","v":0.13725964416398734},{"$f":"'FORM 1'!G25","v":0},1]
["MSS","Materials & Supplies",{"$f":"'FORM 1'!C32","v":0.8635209668306757},{"$f":"'FORM 1'!D32","v":6.644339247107848E-3},{"$f":"'FORM 1'!E32","v":0.12983469392221642},{"$f":"'FORM 1'!F32","v":0},{"$f":"'FORM 1'!G32","v":0},1]
["OTHDGP","Other Revenues - DGP Factor",{"$f":"C37","v":0.2786364795976774},{"$f":"D37","v":0.72136352040232266},{"$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.2786364795976774},{"$f":"D37","v":0.72136352040232266},{"$f":"E37","v":0},{"$f":"F37","v":0},{"$f":"G37","v":0},1]
["OTHSE","Other Revenues - SE Factor",{"$f":"'OTHER REVENUE'!E24","v":0},{"$f":"'OTHER REVENUE'!F24","v":1},{"$f":"'OTHER REVENUE'!G24","v":0},{"$f":"'OTHER REVENUE'!H24","v":0},{"$f":"'OTHER REVENUE'!I24","v":0},1]
["OTHSG","Other Revenues - SG Factor",{"$f":"'OTHER REVENUE'!E25","v":0.2786364795976774},{"$f":"'OTHER REVENUE'!F25","v":0.72136352040232266},{"$f":"'OTHER REVENUE'!G25","v":0},{"$f":"'OTHER REVENUE'!H25","v":0},{"$f":"'OTHER REVENUE'!I25","v":0},1]
["OTHSGR","Other Revenues - Rolled-In SG Factor",{"$f":"+C36","v":0.2786364795976774},{"$f":"+D36","v":0.72136352040232266},{"$f":"+E36","v":0},{"$f":"+F36","v":0},{"$f":"+G36","v":0},1]
["OTHSITUS","Other Revenues - SITUS",{"$f":"'OTHER REVENUE'!E22","v":-0.22071790990022586},{"$f":"'OTHER REVENUE'!F22","v":0},{"$f":"'OTHER REVENUE'!G22","v":0},{"$f":"'OTHER REVENUE'!H22","v":0},{"$f":"'OTHER REVENUE'!I22","v":1.2207179099002259},1]
["OTHSO","Other Revenues - SO Factor",{"$f":"'OTHER REVENUE'!E26","v":0},{"$f":"'OTHER REVENUE'!F26","v":0},{"$f":"'OTHER REVENUE'!G26","v":0},{"$f":"'OTHER REVENUE'!H26","v":0},{"$f":"'OTHER REVENUE'!I26","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'!F64","v":0.39726938124957911},{"$f":"'SCH M'!G64","v":0.21998270772563189},{"$f":"'SCH M'!H64","v":0.36758651107009827},{"$f":"'SCH M'!I64","v":1.0422790375247482E-2},{"$f":"'SCH M'!J64","v":4.7386095794434875E-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.96413782672100545},{"$f":"'SCH M'!G16","v":5.264412624728456E-3},{"$f":"'SCH M'!H16","v":2.1429627258537459E-2},{"$f":"'SCH M'!I16","v":9.1681333957286618E-3},{"$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$56","v":0.39672000615266034},{"$f":"+'SCH M'!G$56","v":0.220190799894324},{"$f":"+'SCH M'!H$56","v":0.36792198568173395},{"$f":"+'SCH M'!I$56","v":1.0424006313981117E-2},{"$f":"+'SCH M'!J$56","v":4.743201957300755E-3},{"$f":"+'SCH M'!K$56","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'!F52","v":1},{"$f":"'SCH M'!G52","v":0},{"$f":"'SCH M'!H52","v":0},{"$f":"'SCH M'!I52","v":0},{"$f":"'SCH M'!J52","v":0},1]
["SCHMAT-SITUS","Schedule M Additions - Temporary-SITUS",{"$f":"'SCH M'!F54","v":0.71926996829876422},{"$f":"'SCH M'!G54","v":7.9460567074925992E-3},{"$f":"'SCH M'!H54","v":0.19841036171320453},{"$f":"'SCH M'!I54","v":7.4373613280538708E-2},{"$f":"'SCH M'!J54","v":0},1]
["SCHMAT-SNP","Schedule M Additions - Temporary-SNP",{"$f":"'SCH M'!F53","v":0.49344209680167433},{"$f":"'SCH M'!G53","v":0.24311968144121765},{"$f":"'SCH M'!H53","v":0.26323433176102212},{"$f":"'SCH M'!I53","v":2.0388999608595248E-4},{"$f":"'SCH M'!J53","v":0},1]
["SCHMAT-SO","Schedule M Additions - Temporary-SO",{"$f":"'SCH M'!F55","v":0.4689372796069185},{"$f":"'SCH M'!G55","v":0.1102442757252405},{"$f":"'SCH M'!H55","v":0.30981410958674577},{"$f":"'SCH M'!I55","v":0.11100433508109521},{"$f":"'SCH M'!J55","v":0},1]
["SCHMD","Schedule M Deductions",{"$f":"+'SCH M'!F$133","v":0.46363413445132906},{"$f":"+'SCH M'!G$133","v":0.30326391960462434},{"$f":"+'SCH M'!H$133","v":0.22344249406070635},{"$f":"+'SCH M'!I$133","v":7.6069827332371862E-3},{"$f":"+'SCH M'!J$133","v":2.0524691501034734E-3},1]
["SCHMDF","Schedule M Deductions - Flow Through",1,0,0,0,0,1]
["SCHMDP","Schedule M Deductions - Permanent",{"$f":"'SCH M'!F76","v":0.99954452824929596},{"$f":"'SCH M'!G76","v":7.30436175288391E-4},{"$f":"'SCH M'!H76","v":1.1750722060012341E-4},{"$f":"'SCH M'!I76","v":-3.9247164518421511E-4},{"$f":"'SCH M'!J76","v":0},1]
["SCHMDP-SO","Schedule M Deductions - Permanent- SO",{"$f":"'SCH M'!F75","v":0.46309363850275576},{"$f":"'SCH M'!G75","v":7.8815542097072686E-2},{"$f":"'SCH M'!H75","v":0.32083117523618426},{"$f":"'SCH M'!I75","v":0.13725964416398734},{"$f":"'SCH M'!J75","v":0},1]
["SCHMDT","Schedule M Deductions - Temporary",{"$f":"'SCH M'!F126","v":0.45714818618704151},{"$f":"'SCH M'!G126","v":0.30692538343224535},{"$f":"'SCH M'!H126","v":0.22614532335368268},{"$f":"'SCH M'!I126","v":7.7037975139195866E-3},{"$f":"'SCH M'!J126","v":2.0773095131113163E-3},1]
["SCHMDT-GPS","Schedule M Deductions - Temporary-GPS",{"$f":"'SCH M'!F117","v":0.49364350161985276},{"$f":"'SCH M'!G117","v":0.24312123664088509},{"$f":"'SCH M'!H117","v":0.26323526173926221},{"$f":"'SCH M'!I117","v":0},{"$f":"'SCH M'!J117","v":0},1]
["SCHMDT-SG","Schedule M Deductions - Temporary-SG",{"$f":"'SCH M'!F119","v":0.99942041542686366},{"$f":"'SCH M'!G119","v":5.7958457313635723E-4},{"$f":"'SCH M'!H119","v":0},{"$f":"'SCH M'!I119","v":0},{"$f":"'SCH M'!J119","v":0},1]
["SCHMDT-SITUS","Schedule M Deductions - Temporary-SITUS",{"$f":"'SCH M'!F125","v":1.8769124297424844},{"$f":"'SCH M'!G125","v":-3.4700783006261463E-2},{"$f":"'SCH M'!H125","v":-0.12007696698359563},{"$f":"'SCH M'!I125","v":-6.9605835080336367E-2},{"$f":"'SCH M'!J125","v":-0.65252884467229055},1]
["SCHMDT-SNP","Schedule M Deductions - Temporary-SNP",{"$f":"'SCH M'!F121","v":0.49364350161985282},{"$f":"'SCH M'!G121","v":0.24312123664088509},{"$f":"'SCH M'!H121","v":0.26323526173926221},{"$f":"'SCH M'!I121","v":0},{"$f":"'SCH M'!J121","v":0},1]
["SCHMDT-SO","Schedule M Deductions - Temporary-SO",{"$f":"'SCH M'!F122","v":0.44422110284528293},{"$f":"'SCH M'!G122","v":9.399671448766321E-2},{"$f":"'SCH M'!H122","v":0.34693189730007318},{"$f":"'SCH M'!I122","v":0.11485028536698062},{"$f":"'SCH M'!J122","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.37703805219886682},{"$f":"+'TAX DEPR'!D$24","v":0.36176773816797969},{"$f":"+'TAX DEPR'!E$24","v":0.25593850708322552},{"$f":"+'TAX DEPR'!F$24","v":5.255702549928013E-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.48013847441207663},{"$f":"'FORM 1'!E18","v":0.51986152558792331},{"$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.75118651568246286,9.3721838692501017E-2,0.12067937361446301,2.9228353662459641E-2,5.1839183481134834E-3,1]
["DITEXP","Deferred Income Tax - Expense",0,0,0,0,0,1]
["FIT","Federal Income Taxes",0.16390330966532787,-2.3800852179897903E-2,0.86472165980015747,-9.2035099782137586E-3,4.3793926926261424E-3,1]
["IBT","Income Before Taxes",0.48034752241116435,-1.4792752975805781E-2,0.53744352553293173,-5.7201838232106422E-3,2.7218888549202088E-3,1]
["NONE","Not Functionalized",0,0,0,0,0,0]
["NUTIL","Non-Utility",0,0,0,0,0,0]
["PT","Production / Transmission",0.67792786344641009,0.32207213655358996,0,0,0,1]
["PTD","Prod, Trans, Dist Plant",0.50499444766859891,0.23991437655546771,0.25509117577593338,0,0,1]
["REVREQ","Revenue Requirement",0.67591743404135174,0.15440848508897959,0.1464243205047695,1.9883454083995167E-2,3.3663062809040803E-3,1]
["SIT","State Income Taxes",0.48034752241116441,-1.4792752975805784E-2,0.53744352553293184,-5.720183823210644E-3,2.7218888549202093E-3,1]

{"sheet":"TAX DEPR","index":1,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'TOTAL FUNCFAC'!$A$1","v":"PacifiCorp"}]
[{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended December 2015"}]
["Tax Depreciation"]
[]
[null,"Total","Production","Transmission","Distribution","General","Mining"]
[]
[]
["Total",{"$f":"SUM(C8:G8)","v":1137695628},{"$f":"394756224-G8","v":392504723},390593731,268306554,{"$f":"83867469+171650","v":84039119},2251501]
[]
[]
[]
["Conversion to COS Functions","Total","Pro","Trn","Dis","Retail","Misc"]
[]
["Percent of GenPlant in Functions",{"$f":"SUM(C14:F14)","v":0.99999999999999989},0.40693334227226474,0.24973897055202585,0.27217760987514228,7.1150077300567036E-2,0]
[" (%'s developed in JAM Jun 2015 - "]
["use \"Total Plant\" variable)"]
[]
["Allocation of GenPlant to Functions",{"$f":"SUM(C18:F18)","v":84039119},{"$f":"+$F$8*C14","v":34198319.576286584},{"$f":"+$F$8*D14","v":20987843.065159194},{"$f":"+$F$8*E14","v":22873566.545432657},{"$f":"+$F$8*F14","v":5979389.8131215516},{"$f":"+$F$8*G14","v":0}]
["Assignment of Mining to Prod Function",{"$f":"SUM(C19:F19)","v":2251501},{"$f":"G8","v":2251501}]
[]
["Adjusted Totals",{"$f":"SUM(C21:F21)","v":1137695628},{"$f":"+C8+C18+C19","v":428954543.57628655},{"$f":"+D8+D18+D19","v":411581574.0651592},{"$f":"+E8+E18+E19","v":291180120.54543269},{"$f":"+F18+F19","v":5979389.8131215516},{"$f":"+G18+G19","v":0}]
[]
[]
["TAXDEPR FACTOR",{"$f":"SUM(C24:F24)","v":1},{"$f":"+C21/$B$21","v":0.37703805219886682},{"$f":"+D21/$B$21","v":0.36176773816797969},{"$f":"+E21/$B$21","v":0.25593850708322552},{"$f":"+F21/$B$21","v":5.255702549928013E-3},{"$f":"+G21/$B$21","v":0}]

{"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 2015"}]
["Gross Plant"]
["(In 000's)"]
[]
[null,"Alloc."]
["Description","Factor","Funct.","Amount","Production","Transmisssion","DPW","CUSTOMER","DMISC"]
[]
["Production Plant",null,"P",12001446.473999999,{"$f":"$D9*VLOOKUP(+$C9,$C$45:$I$51,3)","v":12001446.473999999},{"$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",5910756.4440000001,{"$f":"$D10*VLOOKUP(+$C10,$C$45:$I$51,3)","v":0},{"$f":"$D10*VLOOKUP(+$C10,$C$45:$I$51,4)","v":5910756.4440000001},{"$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",6399768.0379999997,{"$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":6399768.0379999997},{"$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":"2559.113+190383.877+8535.366","v":201478.35600000003},{"$f":"$D12*VLOOKUP(+$C12,$C$45:$I$51,3)","v":201478.35600000003},{"$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":19656.347064615344},{"$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":19656.347064615344},{"$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":1742.6854561538455},1742.6854561538455,0,0,0,0]
[null,{"$f":"'GENERAL PLANT'!B9","v":"SG"},{"$f":"'GENERAL PLANT'!C9","v":"P"},{"$f":"'GENERAL PLANT'!D9","v":118656.51183230818},118656.51183230818,0,0,0,0]
[null,{"$f":"'GENERAL PLANT'!B10","v":"SG"},{"$f":"'GENERAL PLANT'!C10","v":"T"},{"$f":"'GENERAL PLANT'!D10","v":149773.77574845401},0,149773.77574845401,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":224096.55417384612},0,0,224096.55417384612,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":361622.4239684614},0,173628.83895741423,187993.58501104714,0,0]
["Total General Plant",null,null,{"$f":"SUBTOTAL(9,D14:D23)","v":875548.29824383883},120399.19728846203,323402.61470586824,412090.13918489323,19656.347064615344,0]
[]
["Intangible Plant"]
["Customer Service Sys",{"$f":"'INTANGIBLE PLANT'!A7","v":"CN"},{"$f":"'INTANGIBLE PLANT'!B7","v":"CUST"},{"$f":"'INTANGIBLE PLANT'!C7","v":134387.75609384608},{"$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":134387.75609384608},{"$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":1833.7476284615389},1833.7476284615389,0,0,0,0]
["Washington Hydro",{"$f":"'INTANGIBLE PLANT'!A9","v":"SG"},{"$f":"'INTANGIBLE PLANT'!B9","v":"P"},{"$f":"'INTANGIBLE PLANT'!C9","v":114693.00572230795},114693.00572230795,0,0,0,0]
["Utah Hydro",{"$f":"'INTANGIBLE PLANT'!A10","v":"SG"},{"$f":"'INTANGIBLE PLANT'!B10","v":"T"},{"$f":"'INTANGIBLE PLANT'!C10","v":56673.315772307717},0,56673.315772307717,0,0,0]
["Colorado Steam-UPD",{"$f":"'INTANGIBLE PLANT'!A11","v":"SG"},{"$f":"'INTANGIBLE PLANT'!B11","v":"P"},{"$f":"'INTANGIBLE PLANT'!C11","v":172821.24465000301},172821.24465000301,0,0,0,0]
[null,{"$f":"'INTANGIBLE PLANT'!A12","v":"SG"},{"$f":"'INTANGIBLE PLANT'!B12","v":"P"},{"$f":"'INTANGIBLE PLANT'!C12","v":9790.3560100001105},9790.3560100001105,0,0,0,0]
["Oregon Trans",{"$f":"'INTANGIBLE PLANT'!A15","v":"SO"},{"$f":"'INTANGIBLE PLANT'!B15","v":"P"},{"$f":"'INTANGIBLE PLANT'!C15","v":26771.955247692211},26771.955247692211,0,0,0,0]
["Utah Mine",{"$f":"'INTANGIBLE PLANT'!A16","v":"SO"},{"$f":"'INTANGIBLE PLANT'!B16","v":"PTD"},{"$f":"'INTANGIBLE PLANT'!C16","v":286483.41312230902},141420.67520970351,69650.201675397329,75412.536237208202,0,0]
["Utah",{"$f":"'INTANGIBLE PLANT'!A18","v":"SO"},{"$f":"'INTANGIBLE PLANT'!B18","v":"TD"},{"$f":"'INTANGIBLE PLANT'!C18","v":12740.98295999991},0,6117.4361209246217,6623.5468390752885,0,0]
["Utah G/O",{"$f":"'INTANGIBLE PLANT'!A19","v":"SO"},{"$f":"'INTANGIBLE PLANT'!B19","v":"LABOR"},{"$f":"'INTANGIBLE PLANT'!C19","v":0},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":13771.223686153849},0,6612.0943314573633,7159.1293546964853,0,0]
["Total Intangible Plant",null,null,{"$f":"SUBTOTAL(9,D27:D37)","v":829967.00089308142},467330.98446816835,139053.04790008703,89195.212430979984,134387.75609384608,0]
[]
["Total Gross Plant",null,null,{"$f":"SUBTOTAL(9,D8:D38)","v":26218964.61113691},12790655.011756629,6373212.1066059554,6901053.3896158729,154044.10315846142,0]
[]
[null,"GP Factor",null,{"$f":"SUM(E42:I42)","v":1.0000000000000004},{"$f":"E40/$D40","v":0.48783982134533266},{"$f":"F40/$D40","v":0.24307642201472882},{"$f":"G40/$D40","v":0.26320846349075677},{"$f":"H40/$D40","v":5.8752931491821312E-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.48013847441207663},{"$f":"'FORM 1'!$E$18","v":0.51986152558792331},{"$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.49364350161985282},{"$f":"'FORM 1'!$D$16","v":0.24312123664088509},{"$f":"'FORM 1'!$E$16","v":0.26323526173926221},{"$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'!F144","v":0.46309363850275576},{"$f":"'SCH M'!G144","v":7.8815542097072699E-2},{"$f":"'SCH M'!H144","v":0.32083117523618421},{"$f":"'SCH M'!I144","v":0.13725964416398734},{"$f":"'SCH M'!J144","v":0}]

{"sheet":"FORM 1","index":3,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'TOTAL FUNCFAC'!A1","v":"PacifiCorp"}]
[{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended December 2015"}]
["FERC FORM 1 Funtionalization Factors"]
[]
[]
["Factor","Total","Production","Transmission","DPW","CUST","DMSC"]
[]
["PLANT",{"$f":"SUM(C8:G8)","v":24311970.955999997},{"$f":"+'GROSS PLANT'!D9","v":12001446.473999999},{"$f":"+'GROSS PLANT'!D10","v":5910756.4440000001},{"$f":"+'GROSS PLANT'!D11","v":6399768.0379999997},0,0]
["UNCLASSIFIED PLANT",{"$f":"SUM(C9:G9)","v":0},null,null,null,0,0]
["TOTAL PLANT",{"$f":"SUM(C10:G10)","v":24311970.955999997},{"$f":"C8+C9","v":12001446.473999999},{"$f":"D8+D9","v":5910756.4440000001},{"$f":"E8+E9","v":6399768.0379999997},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.49364350161985282},{"$f":"D10/$B10","v":0.24312123664088509},{"$f":"E10/$B10","v":0.26323526173926221},{"$f":"F10/$B10","v":0},{"$f":"G10/$B10","v":0}]
["PT",1,{"$f":"C10/(C10+D10)","v":0.67001510249416218},{"$f":"D10/(C10+D10)","v":0.32998489750583793}]
["TD",1,null,{"$f":"D10/(D10+E10)","v":0.48013847441207663},{"$f":"E10/(D10+E10)","v":0.51986152558792331}]
[]
[]
[]
[]
["LABOR",{"$f":"SUM(C23:G23)","v":318938376},147698333,25137301,102325374,43777368,0]
[]
["LABOR %",{"$f":"B23/$B23","v":1},{"$f":"C23/$B23","v":0.46309363850275576},{"$f":"D23/$B23","v":7.8815542097072699E-2},{"$f":"E23/$B23","v":0.32083117523618421},{"$f":"F23/$B23","v":0.13725964416398734},{"$f":"G23/$B23","v":0}]
[]
["Source: Ferc Form 1 (Dec 2015) - pg. 354"]
[]
[]
["Material & Supplies",{"$f":"SUM(C30:G30)","v":98373213},84947332,653625,12772256,0,0]
[]
["Material & Supplies %",{"$f":"B30/$B30","v":1},0.8635209668306757,6.644339247107848E-3,0.12983469392221642,0,0]
[]
["Source: Ferc Form 1 (Dec 2015) - pg. 227, Total Company"]
[]
[]
["FERC (mWh)",26956561,{"$f":"B37-D37","v":13808682},13147879,0,0,0]
[]
["FERC %",{"$f":"B37/$B37","v":1},{"$f":"C37/$B37","v":0.51225681198725614},{"$f":"D37/$B37","v":0.48774318801274391},0,0,0]
[]
["Source: FERC reporting requirement No. 582 - (from Transmissio Dept., 4-13-16)"]

{"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 2015"}]
["Depreciation Expense"]
[]
[]
["Function","Amount","Production","Transmission","DPW","CUST","DMSC"]
["CUST",1195.397030000004,{"$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":1195.397030000004},{"$f":"VLOOKUP($A7,$A$16:$G$22,7,FALSE)*$B7","v":0}]
["DPW",138874.43634000001,{"$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":138874.43634000001},{"$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",397129.18251999532,{"$f":"VLOOKUP($A9,$A$16:$G$22,3,FALSE)*$B9","v":397129.18251999532},{"$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",14478.735390000253,{"$f":"VLOOKUP($A10,$A$16:$G$22,3,FALSE)*$B10","v":7147.3336369470098},{"$f":"VLOOKUP($A10,$A$16:$G$22,4,FALSE)*$B10","v":3520.0880530130089},{"$f":"VLOOKUP($A10,$A$16:$G$22,5,FALSE)*$B10","v":3811.3137000402353},{"$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",98935.04031000525,{"$f":"VLOOKUP($A11,$A$16:$G$22,3,FALSE)*$B11","v":0},{"$f":"VLOOKUP($A11,$A$16:$G$22,4,FALSE)*$B11","v":98935.04031000525},{"$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":650612.79159000074},404276.51615694235,102455.12836301826,142685.75004004026,1195.397030000004,0]
["BookDepr Factor",{"$f":"B12/$B12","v":1},0.62137806293194875,0.15747481403283387,0.21930978284539648,1.8373401898210942E-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.49364350161985282},{"$f":"'FORM 1'!$D$16","v":0.24312123664088509},{"$f":"'FORM 1'!$E$16","v":0.26323526173926221},{"$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.48013847441207663},{"$f":"'FORM 1'!$E$18","v":0.51986152558792331},{"$f":"'FORM 1'!$F$18","v":0},{"$f":"'FORM 1'!$G$18","v":0}]
["G",{"$f":"'GENERAL PLANT'!$D$38","v":0.99999999999999989},{"$f":"'GENERAL PLANT'!$E$38","v":0.22038330506248377},{"$f":"'GENERAL PLANT'!$F$38","v":0.33999351096339209},{"$f":"'GENERAL PLANT'!$G$38","v":0.42239697137578525},{"$f":"'GENERAL PLANT'!$H$38","v":1.7226212598338838E-2},{"$f":"'GENERAL PLANT'!$I$38","v":0}]

{"sheet":"OTHER REVENUE","index":5,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'TOTAL FUNCFAC'!A1","v":"PacifiCorp"}]
[{"$f":"+'TOTAL FUNCFAC'!A2:A2","v":"12 Months Ended December 2015"}]
["Account 456"]
[]
["Main"]
["Account","Factor","Function","Amount","Production","Transmission","DPW","Customer","DMSC"]
["456","OTHER","P",-181.82543000000078,{"$f":"$D7*VLOOKUP(+$C7,$C$30:$I36,3,FALSE)","v":-181.82543000000078},{"$f":"$D7*VLOOKUP(+$C7,$C$30:$I36,4,FALSE)","v":0},{"$f":"$D7*VLOOKUP(+$C7,$C$30:$I36,5,FALSE)","v":0},{"$f":"$D7*VLOOKUP(+$C7,$C$30:$I36,6,FALSE)","v":0},{"$f":"$D7*VLOOKUP(+$C7,$C$30:$I36,7,FALSE)","v":0}]
["456","OTHER","T",5114.0289700000003,{"$f":"$D8*VLOOKUP(+$C8,$C$30:$I37,3,FALSE)","v":0},{"$f":"$D8*VLOOKUP(+$C8,$C$30:$I37,4,FALSE)","v":5114.0289700000003},{"$f":"$D8*VLOOKUP(+$C8,$C$30:$I37,5,FALSE)","v":0},{"$f":"$D8*VLOOKUP(+$C8,$C$30:$I37,6,FALSE)","v":0},{"$f":"$D8*VLOOKUP(+$C8,$C$30:$I37,7,FALSE)","v":0}]
["456","SE","P",0,{"$f":"$D9*VLOOKUP(+$C9,$C$30:$I37,3,FALSE)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$30:$I37,4,FALSE)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$30:$I37,5,FALSE)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$30:$I37,6,FALSE)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$30:$I37,7,FALSE)","v":0}]
["456","SE","T",-8324.8256899999997,{"$f":"$D10*VLOOKUP(+$C10,$C$30:$I38,3,FALSE)","v":0},{"$f":"$D10*VLOOKUP(+$C10,$C$30:$I38,4,FALSE)","v":-8324.8256899999997},{"$f":"$D10*VLOOKUP(+$C10,$C$30:$I38,5,FALSE)","v":0},{"$f":"$D10*VLOOKUP(+$C10,$C$30:$I38,6,FALSE)","v":0},{"$f":"$D10*VLOOKUP(+$C10,$C$30:$I38,7,FALSE)","v":0}]
["456","SG","P",-32751.93205000001,{"$f":"$D11*VLOOKUP(+$C11,$C$30:$I39,3,FALSE)","v":-32751.93205000001},{"$f":"$D11*VLOOKUP(+$C11,$C$30:$I39,4,FALSE)","v":0},{"$f":"$D11*VLOOKUP(+$C11,$C$30:$I39,5,FALSE)","v":0},{"$f":"$D11*VLOOKUP(+$C11,$C$30:$I39,6,FALSE)","v":0},{"$f":"$D11*VLOOKUP(+$C11,$C$30:$I39,7,FALSE)","v":0}]
["456","SG","T",-84791.657710000029,{"$f":"$D12*VLOOKUP(+$C12,$C$30:$I39,3,FALSE)","v":0},{"$f":"$D12*VLOOKUP(+$C12,$C$30:$I39,4,FALSE)","v":-84791.657710000029},{"$f":"$D12*VLOOKUP(+$C12,$C$30:$I39,5,FALSE)","v":0},{"$f":"$D12*VLOOKUP(+$C12,$C$30:$I39,6,FALSE)","v":0},{"$f":"$D12*VLOOKUP(+$C12,$C$30:$I39,7,FALSE)","v":0}]
["456","SO","DMSC",-1473.9320600000001,{"$f":"$D13*VLOOKUP(+$C13,$C$30:$I40,3,FALSE)","v":0},{"$f":"$D13*VLOOKUP(+$C13,$C$30:$I40,4,FALSE)","v":0},{"$f":"$D13*VLOOKUP(+$C13,$C$30:$I40,5,FALSE)","v":0},{"$f":"$D13*VLOOKUP(+$C13,$C$30:$I40,6,FALSE)","v":0},{"$f":"$D13*VLOOKUP(+$C13,$C$30:$I40,7,FALSE)","v":-1473.9320600000001}]
["456","SITUS","DMSC",1596.2396700000002,{"$f":"$D14*VLOOKUP(+$C14,$C$30:$I41,3,FALSE)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$30:$I41,4,FALSE)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$30:$I41,5,FALSE)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$30:$I41,6,FALSE)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$30:$I41,7,FALSE)","v":1596.2396700000002}]
["456","SITUS","P",-288.61597,{"$f":"$D15*VLOOKUP(+$C15,$C$30:$I42,3,FALSE)","v":-288.61597},{"$f":"$D15*VLOOKUP(+$C15,$C$30:$I42,4,FALSE)","v":0},{"$f":"$D15*VLOOKUP(+$C15,$C$30:$I42,5,FALSE)","v":0},{"$f":"$D15*VLOOKUP(+$C15,$C$30:$I42,6,FALSE)","v":0},{"$f":"$D15*VLOOKUP(+$C15,$C$30:$I42,7,FALSE)","v":0}]
["Total Situs Revenues",null,null,{"$f":"SUMIF($B:$B,\"SITUS\",D:D)","v":1307.6237000000001},-288.61597,0,0,0,1596.2396700000002]
["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":-8324.8256899999997},0,-8324.8256899999997,0,0,0]
["Total SG Revenues",null,null,{"$f":"SUMIF($B:$B,\"SG\",D:D)","v":-117543.58976000003},-32751.93205000001,-84791.657710000029,0,0,0]
["Total SO Revenues",null,null,{"$f":"SUMIF($B:$B,\"SO\",D:D)","v":-1473.9320600000001},0,0,0,0,-1473.9320600000001]
["Total Operation",null,null,{"$f":"SUM(D7:D15)","v":-121102.52027000005},-33222.373450000014,-88002.454430000027,0,0,122.30761000000007]
["OTHSITUS",null,null,{"$f":"SUM(E22:I22)","v":1},{"$f":"E16/$D$16","v":-0.22071790990022586},{"$f":"F16/$D$16","v":0},{"$f":"G16/$D$16","v":0},{"$f":"H16/$D$16","v":0},{"$f":"I16/$D$16","v":1.2207179099002259}]
["CN Factor",null,null,0,{"$f":"IF(ISERROR(E17/$D$17),\" \",(E17/$D$17))","v":" "},{"$f":"IF(ISERROR(F17/$D$17),\" \",(F17/$D$17))","v":" "},{"$f":"IF(ISERROR(G17/$D$17),\" \",(G17/$D$17))","v":" "},{"$f":"IF(ISERROR(H17/$D$17),\" \",(H17/$D$17))","v":" "},{"$f":"IF(ISERROR(I17/$D$17),\" \",(I17/$D$17))","v":" "}]
["OTHSE",null,null,1,{"$f":"E18/$D$18","v":0},{"$f":"F18/$D$18","v":1},{"$f":"G18/$D$18","v":0},{"$f":"H18/$D$18","v":0},{"$f":"I18/$D$18","v":0}]
["OTHSG",null,null,1,{"$f":"E19/$D$19","v":0.2786364795976774},{"$f":"F19/$D$19","v":0.72136352040232266},{"$f":"G19/$D$19","v":0},{"$f":"H19/$D$19","v":0},{"$f":"I19/$D$19","v":0}]
["OTHSO",null,null,1,{"$f":"E20/$D$20","v":0},{"$f":"F20/$D$20","v":0},{"$f":"G20/$D$20","v":0},{"$f":"H20/$D$20","v":0},{"$f":"I20/$D$20","v":1}]
["Total Operation Factor",null,null,0.99999999999999978,{"$f":"E21/$D$21","v":0.27433263466301272},{"$f":"F21/$D$21","v":0.72667731632502042},{"$f":"G21/$D$21","v":0},{"$f":"H21/$D$21","v":0},{"$f":"I21/$D$21","v":-1.0099509880332237E-3}]
[]
[null,null,null,"Total","Prod","Trans","DPW","CUST","DMSC"]
[null,null,"P",{"$f":"SUM(E30:I30)","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(E31:I31)","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.48013847441207663},{"$f":"'FORM 1'!$E$18","v":0.51986152558792331},{"$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.49364350161985282},{"$f":"'FORM 1'!$D$16","v":0.24312123664088509},{"$f":"'FORM 1'!$E$16","v":0.26323526173926221},{"$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 2015"}]
["General Plant"]
[]
[null,"Alloc."]
["Description","Factor","Funct.","Amount","Prod","Trans","DPW","CUST","DMSC"]
["Business Centers","CN","CUST",19656.347064615344,{"$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":19656.347064615344},{"$f":"$D7*VLOOKUP(+$C7,$B$45:$H$51,7)","v":0}]
[null,"SE","P",1742.6854561538455,1742.6854561538455,0,0,0,0]
[null,"SG","P",118656.51183230818,118656.51183230818,0,0,0,0]
[null,"SG","T",149773.77574845401,0,149773.77574845401,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",265523.59741538722,131073.99839083184,64554.425360965462,69895.173663589943,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",224096.55417384612,0,0,224096.55417384612,0,0]
[null,"SITUS","P",0,0,0,0,0,0]
[null,"SITUS","TD",361622.4239684614,0,173628.83895741423,187993.58501104714,0,0]
["Total-CUST",null,null,{"$f":"SUMIF($C:$C,\"CUST\",D:D)","v":19656.347064615344},0,0,0,19656.347064615344,0]
["Total-TD",null,null,{"$f":"SUMIF($C:$C,\"TD\",D:D)","v":361622.4239684614},0,173628.83895741423,187993.58501104714,0,0]
["Total-PTD",null,null,{"$f":"SUMIF($C:$C,\"PTD\",D:D)","v":265523.59741538722},131073.99839083184,64554.425360965462,69895.173663589943,0,0]
["Total-DPW",null,null,{"$f":"SUMIF($C:$C,\"DPW\",D:D)","v":224096.55417384612},0,0,224096.55417384612,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":268430.28758076217},118656.51183230818,149773.77574845401,0,0,0]
["Total-SE",null,null,{"$f":"SUMIF($B:$B,\"SE\",D:D)","v":1742.6854561538455},1742.6854561538455,0,0,0,0]
["Total-G-Situs",null,null,{"$f":"SUMIF($B:$B,\"SITUS\",D:D)","v":585718.97814230749},0,173628.83895741423,412090.13918489323,0,0]
["Total-SO",null,null,{"$f":"SUMIF($B:$B,\"SO\",D:D)","v":265523.59741538722},131073.99839083184,64554.425360965462,69895.173663589943,0,0]
["Total-General Plant",null,null,{"$f":"SUM(D7:D21)","v":1141071.8956592262},251473.19567929389,387957.04006683372,481985.31284848321,19656.347064615344,0]
[]
["G-SG Factor",null,null,{"$f":"SUM(E34:I34)","v":1},{"$f":"E28/$D$28","v":0.44203846332582047},{"$f":"F28/$D$28","v":0.55796153667417958},{"$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":1},{"$f":"E30/$D$30","v":0},{"$f":"F30/$D$30","v":0.2964371062520515},{"$f":"G30/$D$30","v":0.70356289374794845},{"$f":"H30/$D$30","v":0},{"$f":"I30/$D$30","v":0}]
["SO Factor",null,null,{"$f":"SUM(E37:I37)","v":1},{"$f":"E31/$D$31","v":0.49364350161985276},{"$f":"F31/$D$31","v":0.24312123664088509},{"$f":"G31/$D$31","v":0.26323526173926221},{"$f":"H31/$D$31","v":0},{"$f":"I31/$D$31","v":0}]
["G Allocator",null,null,{"$f":"SUM(E38:I38)","v":0.99999999999999989},{"$f":"E32/$D$32","v":0.22038330506248377},{"$f":"F32/$D$32","v":0.33999351096339209},{"$f":"G32/$D$32","v":0.42239697137578525},{"$f":"H32/$D$32","v":1.7226212598338838E-2},{"$f":"I32/$D$32","v":0}]
["Total Gen. Plant",null,null,{"$f":"D32","v":1141071.8956592262}]
["Mining",null,"acct 399 from JAM",{"$f":"'GROSS PLANT'!D12","v":201478.35600000003},{"$f":"D29","v":1742.6854561538455},{"$f":"SUM(D40+E40)","v":203221.04145615388}]
["Total ",null,"P",{"$f":"SUM(D39:D40)","v":1342550.2516592261}]
[]
[]
[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.48013847441207663},{"$f":"'FORM 1'!$E$18","v":0.51986152558792331},{"$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.49364350161985282},{"$f":"'FORM 1'!$D$16","v":0.24312123664088509},{"$f":"'FORM 1'!$E$16","v":0.26323526173926221},{"$f":"'FORM 1'!$F$16","v":0},{"$f":"'FORM 1'!$G$16","v":0}]
[null,"GP",{"$f":"SUM(D51:H51)","v":1.0000000000000004},{"$f":"+'GROSS PLANT'!E42","v":0.48783982134533266},{"$f":"+'GROSS PLANT'!F42","v":0.24307642201472882},{"$f":"+'GROSS PLANT'!G42","v":0.26320846349075677},{"$f":"+'GROSS PLANT'!H42","v":5.8752931491821312E-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 2015"}]
["Intangible Plant"]
["(In 000's)"]
["Alloc."]
["Factor","Funct.","Amount","Production","Transmisssion","DPW","Customer","DMSC"]
["CN","CUST",134387.75609384608,{"$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":134387.75609384608},{"$f":"$C7*VLOOKUP(+$B7,$B$39:$H$46,7)","v":0}]
["SE","P",1833.7476284615389,1833.7476284615389,0,0,0,0]
["SG","P",114693.00572230795,114693.00572230795,0,0,0,0]
["SG","T",56673.315772307717,0,56673.315772307717,0,0,0]
["SG","P",172821.24465000301,172821.24465000301,0,0,0,0]
["SG","P",9790.3560100001105,9790.3560100001105,0,0,0,0]
["SO","CUST",7766.7506399999802,0,0,0,7766.7506399999802,0]
["SO","DPW",30596.528891538532,0,0,30596.528891538532,0,0]
["SO","P",26771.955247692211,26771.955247692211,0,0,0,0]
["SO","PTD",286483.41312230902,141420.67520970351,69650.201675397329,75412.536237208202,0,0]
["SO","T",1175.83938846154,0,1175.83938846154,0,0,0]
["SO","TD",12740.98295999991,0,6117.4361209246217,6623.5468390752885,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",462.55360999999999,228.33658372730378,112.45660567590566,121.76042059679061,0,0]
["SITUS","T",530.80893000000003,0,530.80893000000003,0,0,0]
["SITUS","TD",13771.223686153849,0,6612.0943314573633,7159.1293546964853,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":353977.92215461878},297304.60638231109,56673.315772307717,0,0,0]
["Total-SITUS",null,{"$f":"SUMIF($A:$A,\"SITUS\",C:C)","v":-17135.712093846152},-31829.623336272696,7255.3598671332693,7438.5513752932757,0,0]
["Total-Intangible",null,{"$f":"SUM(C7:C25)","v":838599.1840330814},{"$f":"SUM(D7:D25)","v":435501.36113189568},140872.15282422447,120071.16334311532,142154.50673384606,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.83989590246944101},{"$f":"E28/$C$28","v":0.16010409753055904},{"$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":0.99999999999999978},{"$f":"D29/$C$29","v":1.857502224707865},{"$f":"E29/$C$29","v":-0.42340579880183937},{"$f":"F29/$C$29","v":-0.43409642590602576},{"$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.51932003920804659},{"$f":"E30/$C$30","v":0.16798508215417879},{"$f":"F30/$C$30","v":0.14318063459787328},{"$f":"G30/$C$30","v":0.16951424403990153},{"$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.48013847441207663},{"$f":"'FORM 1'!$E$18","v":0.51986152558792331},{"$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.49364350161985282},{"$f":"'FORM 1'!$D$16","v":0.24312123664088509},{"$f":"'FORM 1'!$E$16","v":0.26323526173926221},{"$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'!F144","v":0.46309363850275576},{"$f":"'SCH M'!G144","v":7.8815542097072699E-2},{"$f":"'SCH M'!H144","v":0.32083117523618421},{"$f":"'SCH M'!I144","v":0.13725964416398734},{"$f":"'SCH M'!J144","v":0}]

{"sheet":"SCH M","index":8,"n_rows":150,"n_cols":10,"rows_kept":150,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"+'TOTAL FUNCFAC'!A1","v":"PacifiCorp"}]
[null,{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended December 2015"}]
[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",59.466050000000003,{"$f":"VLOOKUP($D7,$D$138:$J$150,3,FALSE)*$E7","v":27.538349461886799},{"$f":"VLOOKUP($D7,$D$138:$J$150,4,FALSE)*$E7","v":4.6868489671216302},{"$f":"VLOOKUP($D7,$D$138:$J$150,5,FALSE)*$E7","v":19.078562708153694},{"$f":"VLOOKUP($D7,$D$138:$J$150,6,FALSE)*$E7","v":8.1622888628378796},{"$f":"VLOOKUP($D7,$D$138:$J$150,7,FALSE)*$E7","v":0}]
[{"$f":"IF(C8=\"\",\"\",B8&\"-\"&C8)","v":"SCHMAP-SE"},"SCHMAP","SE","P",64.197000000000003,{"$f":"VLOOKUP($D8,$D$138:$J$150,3,FALSE)*$E8","v":64.197000000000003},{"$f":"VLOOKUP($D8,$D$138:$J$150,4,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,$D$138:$J$150,5,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,$D$138:$J$150,6,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,$D$138:$J$150,7,FALSE)*$E8","v":0}]
[{"$f":"IF(C9=\"\",\"\",B9&\"-\"&C9)","v":"SCHMAP-SO"},"SCHMAP","SO","P",766.62601000000006,{"$f":"VLOOKUP($D9,$D$138:$J$150,3,FALSE)*$E9","v":766.62601000000006},{"$f":"VLOOKUP($D9,$D$138:$J$150,4,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,$D$138:$J$150,5,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,$D$138:$J$150,6,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,$D$138:$J$150,7,FALSE)*$E9","v":0}]
[{"$f":"IF(C10=\"\",\"\",B10&\"-\"&C10)","v":"SCHMAP-SO"},"SCHMAP","SO","LABOR",0,{"$f":"VLOOKUP($D10,$D$138:$J$150,3,FALSE)*$E10","v":0},{"$f":"VLOOKUP($D10,$D$138:$J$150,4,FALSE)*$E10","v":0},{"$f":"VLOOKUP($D10,$D$138:$J$150,5,FALSE)*$E10","v":0},{"$f":"VLOOKUP($D10,$D$138:$J$150,6,FALSE)*$E10","v":0},{"$f":"VLOOKUP($D10,$D$138:$J$150,7,FALSE)*$E10","v":0}]
[{"$f":"IF(C11=\"\",\"\",B11&\"-\"&C11)","v":"SCHMAP-SO"},"SCHMAP","SO","PTD",0,{"$f":"VLOOKUP($D11,$D$138:$J$150,3,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,$D$138:$J$150,4,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,$D$138:$J$150,5,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,$D$138:$J$150,6,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,$D$138:$J$150,7,FALSE)*$E11","v":0}]
[]
[{"$f":"IF(C13=\"\",\"\",B13&\"-\"&C13)","v":""},"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"SCHMAP-SO\",E:E)","v":766.62601000000006},766.62601000000006,0,0,0,0]
[{"$f":"IF(C14=\"\",\"\",B14&\"-\"&C14)","v":""},"Total SCHMAP",null,null,{"$f":"SUMIF($B:$B,\"SCHMAP\",E:E)","v":890.28906000000006},858.36135946188688,4.6868489671216302,19.078562708153694,8.1622888628378796,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.96413782672100545,5.264412624728456E-3,2.1429627258537459E-2,9.1681333957286618E-3,0]
[]
[{"$f":"IF(C18=\"\",\"\",B18&\"-\"&C18)","v":"SCHMAT-CIAC"},"SCHMAT","CIAC","DPW",108326.66800000001,{"$f":"VLOOKUP($D18,$D$138:$J$150,3,FALSE)*$E18","v":0},{"$f":"VLOOKUP($D18,$D$138:$J$150,4,FALSE)*$E18","v":0},{"$f":"VLOOKUP($D18,$D$138:$J$150,5,FALSE)*$E18","v":108326.66800000001},{"$f":"VLOOKUP($D18,$D$138:$J$150,6,FALSE)*$E18","v":0},{"$f":"VLOOKUP($D18,$D$138:$J$150,7,FALSE)*$E18","v":0}]
["SCHMAT-BADDEBT","SCHMAT","BADDEBT","CUST",-95.341000095341101,0,0,0,-95.341000095341101,0]
["SCHMAT-SCHMDEXP","SCHMAT","SCHMDEXP","GP",768720,375012.22746458411,186857.70713116234,202333.61005461455,4516.4553496392882,0]
[{"$f":"IF(C21=\"\",\"\",B21&\"-\"&C21)","v":"SCHMAT-GPS"},"SCHMAT","GPS","GP",231.066,112.72319615898064,56.166696529255326,60.818526824955207,1.3575804868089183,0]
[{"$f":"IF(C22=\"\",\"\",B22&\"-\"&C22)","v":"SCHMAT-SE"},"SCHMAT","SE","LABOR",null,0,0,0,0,0]
["SCHMAT-SE","SCHMAT","SE","P",-73161.199999999983,-73161.199999999983,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",1657.3939999999996,1657.3939999999996,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",832.21199999999999,405.98615340144198,202.29111531772151,219.04524181856968,4.8894894622671599,0]
["SCHMAT-SNP","SCHMAT","SNP","PTD",23148.805,11427.257158515156,5627.9660983587037,6093.5817431261421,0,0]
["SCHMAT-SNPD","SCHMAT","SNPD","DPW",1386.597,0,0,1386.597,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",33908.083009999995,15702.617535754373,2672.48394390569,10878.770122104388,4654.2114082355438,0]
["SCHMAT-SO","SCHMAT","SO","PTD",8020.1120000000001,3959.076171063401,1949.8595474384022,2111.1762814981976,0,0]
[{"$f":"IF(C34=\"\",\"\",B34&\"-\"&C34)","v":"SCHMAT-OTHER"},"SCHMAT","OTHER","DMSC",4357.2850000000008,0,0,0,0,4357.2850000000008]
[{"$f":"IF(C35=\"\",\"\",B35&\"-\"&C35)","v":"SCHMAT-OTHER"},"SCHMAT","OTHER","GP",null,0,0,0,0,0]
["SCHMAT-OTHER","SCHMAT","OTHER","P",13599.353999999999,13599.353999999999,0,0,0,0]
["SCHMAT-OTHER","SCHMAT","OTHER","PTD",19974.902999999998,9860.4810614369017,4856.3231191417253,5258.0988194213733,0,0]
["SCHMAT-TROJD","SCHMAT","TROJD","P",-36.847000000000001,-36.847000000000001,0,0,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","DMSC",null,0,0,0,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","DPW",311.71499999999997,0,0,311.71499999999997,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","ESD",206.86500000000001,62.0595,20.686500000000002,124.119,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","GP",null,0,0,0,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","LABOR",3601.308,1667.7428250890823,283.83904227852469,1155.4118780274721,494.3142546049209,0]
["SCHMAT-SITUS","SCHMAT","SITUS","P",3561.8179999999998,3561.8179999999998,0,0,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","PTD",-1035.3399999999999,-511.08886296709835,-251.71314114377395,-272.53799588912773,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":-73161.199999999983},-73161.199999999983,0,0,0,0]
[{"$f":"IF(C48=\"\",\"\",B48&\"-\"&C48)","v":""},"Total-SNP",null,null,{"$f":"SUMIF($A:$A,\"SCHMAT-SNP\",E:E)","v":23981.017},11833.243311916598,5830.2572136764247,6312.6269849447117,4.8894894622671599,0]
["","Total-SITUS",null,null,{"$f":"SUMIF($A:$A,\"SCHMAT-SITUS\",E:E)","v":6646.366},4780.5314621219841,52.812401134750758,1318.7078821383443,494.3142546049209,0]
[null,"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"SCHMAT-SO\",E:E)","v":41928.195009999996},19661.693706817772,4622.3434913440924,12989.946403602586,4654.2114082355438,0]
["","Total-SCHMAT",null,null,{"$f":"SUMIF($B:$B,\"SCHMAT\",E:E)","v":918637.88200990483},364442.02620303631,202275.61005298857,337987.07367154659,9575.8870823334873,4357.2850000000008]
[null,"SCHMAT-SE",null,null,{"$f":"SUM(F52:J52)","v":1},{"$f":"IF(ISERROR(F47/$E47),\" \",(F47/$E47))","v":1},0,0,0,0]
["","SCHMAT-SNP",null,null,{"$f":"SUM(F53:J53)","v":1},0.49344209680167433,0.24311968144121765,0.26323433176102212,2.0388999608595248E-4,0]
["","SCHMAT-SITUS",null,null,{"$f":"SUM(F54:J54)","v":1},0.71926996829876422,7.9460567074925992E-3,0.19841036171320453,7.4373613280538708E-2,0]
[null,"SCHMAT-SO",null,null,{"$f":"SUM(F55:J55)","v":1},0.4689372796069185,0.1102442757252405,0.30981410958674577,0.11100433508109521,0]
["","SCHMAT FACTOR",null,null,{"$f":"SUM(F56:J56)","v":1.0000000000000002},0.39672000615266034,0.220190799894324,0.36792198568173395,1.0424006313981117E-2,4.743201957300755E-3]
[]
[{"$f":"IF(C58=\"\",\"\",B58&\"-\"&C58)","v":"SCHMAF-DGP"},"SCHMAF","DGP","P",0,{"$f":"VLOOKUP($D58,$D$138:$J$150,3,FALSE)*$E58","v":0},{"$f":"VLOOKUP($D58,$D$138:$J$150,4,FALSE)*$E58","v":0},{"$f":"VLOOKUP($D58,$D$138:$J$150,5,FALSE)*$E58","v":0},{"$f":"VLOOKUP($D58,$D$138:$J$150,6,FALSE)*$E58","v":0},{"$f":"VLOOKUP($D58,$D$138:$J$150,7,FALSE)*$E58","v":0}]
[{"$f":"IF(C59=\"\",\"\",B59&\"-\"&C59)","v":"SCHMAF-TROJP"},"SCHMAF","TROJP","P",0,{"$f":"VLOOKUP($D59,$D$138:$J$150,3,FALSE)*$E59","v":0},{"$f":"VLOOKUP($D59,$D$138:$J$150,4,FALSE)*$E59","v":0},{"$f":"VLOOKUP($D59,$D$138:$J$150,5,FALSE)*$E59","v":0},{"$f":"VLOOKUP($D59,$D$138:$J$150,6,FALSE)*$E59","v":0},{"$f":"VLOOKUP($D59,$D$138:$J$150,7,FALSE)*$E59","v":0}]
[{"$f":"IF(C60=\"\",\"\",B60&\"-\"&C60)","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(F61:J61)","v":0},{"$f":"IF(ISERROR(F60/$E60),\" \",(F60/$E60))","v":" "},{"$f":"IF(ISERROR(G60/$E60),\" \",(G60/$E60))","v":" "},{"$f":"IF(ISERROR(H60/$E60),\" \",(H60/$E60))","v":" "},{"$f":"IF(ISERROR(I60/$E60),\" \",(I60/$E60))","v":" "},{"$f":"IF(ISERROR(J60/$E60),\" \",(J60/$E60))","v":" "}]
[]
["","Total-SCHMA",null,null,{"$f":"SUM(E60,E51,E14)","v":919528.17106990481},365300.38756249822,202280.29690195571,338006.15223425475,9584.0493711963245,4357.2850000000008]
["","SCHMA FACTOR",null,null,{"$f":"SUM(F64:J64)","v":1.0000000000000002},{"$f":"IF(ISERROR(F63/$E63),\" \",(F63/$E63))","v":0.39726938124957911},{"$f":"IF(ISERROR(G63/$E63),\" \",(G63/$E63))","v":0.21998270772563189},{"$f":"IF(ISERROR(H63/$E63),\" \",(H63/$E63))","v":0.36758651107009827},{"$f":"IF(ISERROR(I63/$E63),\" \",(I63/$E63))","v":1.0422790375247482E-2},{"$f":"IF(ISERROR(J63/$E63),\" \",(J63/$E63))","v":4.7386095794434875E-3}]
[]
["","DEDUCTIONS"]
["SCHMDP-SCHMDEXP","SCHMDP","SCHMDEXP","LABOR",-17.167960000000001,{"$f":"VLOOKUP($D67,$D$138:$J$150,3,FALSE)*$E67","v":-7.9503730620697715},{"$f":"VLOOKUP($D67,$D$138:$J$150,4,FALSE)*$E67","v":-1.3531020741008604},{"$f":"VLOOKUP($D67,$D$138:$J$150,5,FALSE)*$E67","v":-5.5080167832078013},{"$f":"VLOOKUP($D67,$D$138:$J$150,6,FALSE)*$E67","v":-2.3564680806215681},{"$f":"VLOOKUP($D67,$D$138:$J$150,7,FALSE)*$E67","v":0}]
["SCHMDP-SE","SCHMDP","SE","P",646.67499999999995,646.67499999999995,0,0,0,0]
["SCHMDP-SG","SCHMDP","SG","P",15808.34899,15808.34899,0,0,0,0]
["SCHMDP-SNP","SCHMDP","SNP","PTD",64.760000000000005,31.968353164901671,15.744531284863719,17.047115550234622,0,0]
["SCHMDP-SO","SCHMDP","SO","LABOR",-29.933,-13.861781881302988,-2.3591856215916769,-9.6034395683447027,-4.1085929287606326,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":-29.933},-13.861781881302988,-2.3591856215916769,-9.6034395683447027,-4.1085929287606326,0]
["","Total-SCHMDP",null,null,{"$f":"SUMIF($B:$B,\"SCHMDP\",E:E)","v":16472.683029999997},16465.18018822153,12.032243589171181,1.935659198682119,-6.4650610093822003,0]
["","SCHMDP-SO",null,null,{"$f":"SUM(F75:J75)","v":1},{"$f":"IF(ISERROR(F73/$E73),\" \",(F73/$E73))","v":0.46309363850275576},7.8815542097072686E-2,0.32083117523618426,0.13725964416398734,0]
["","SCHMDP FACTOR",null,null,{"$f":"SUM(F76:J76)","v":1.0000000000000002},0.99954452824929596,7.30436175288391E-4,1.1750722060012341E-4,-3.9247164518421511E-4,0]
[]
["SCHMDT-BADDEBT","SCHMDT","BADDEBT","CUST",null,{"$f":"VLOOKUP($D78,$D$138:$J$150,3,FALSE)*$E78","v":0},{"$f":"VLOOKUP($D78,$D$138:$J$150,4,FALSE)*$E78","v":0},{"$f":"VLOOKUP($D78,$D$138:$J$150,5,FALSE)*$E78","v":0},{"$f":"VLOOKUP($D78,$D$138:$J$150,6,FALSE)*$E78","v":0},{"$f":"VLOOKUP($D78,$D$138:$J$150,7,FALSE)*$E78","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",-40012.756000000008,-19752.036981300778,-9727.9507201299966,-10532.768298569237,0,0]
["SCHMDT-SG","SCHMDT","SG","P",206416.15801000001,206416.15801000001,0,0,0,0]
[{"$f":"IF(C84=\"\",\"\",B84&\"-\"&C84)","v":"SCHMDT-SG"},"SCHMDT","SG","T",119.705,0,119.705,0,0,0]
["SCHMDT-SE","SCHMDT","SE","P",30456.54700000001,30456.54700000001,0,0,0,0]
[{"$f":"IF(C86=\"\",\"\",B86&\"-\"&C86)","v":"SCHMDT-SNPD"},"SCHMDT","SNPD","DPW",50.905000000000001,0,0,50.905000000000001,0,0]
["SCHMDT-SNP","SCHMDT","SNP","PTD",50212.205000000002,24786.928700253884,12207.653374065634,13217.622925680491,0,0]
["SCHMDT-SO","SCHMDT","SO","ESD",4624.8739999999998,1387.4621999999999,462.48739999999998,2774.9243999999999,0,0]
["SCHMDT-SO","SCHMDT","SO","GP",24490.288,11947.337722615744,5953.0115811502492,6446.0510749261184,143.88762130789735,0]
["SCHMDT-SO","SCHMDT","SO","LABOR",34219.451999999997,15846.8105342504,2697.0246596447582,10978.667001098192,4696.9498050066441,0]
["SCHMDT-SO","SCHMDT","SO","PTD",-21185.503000000004,-10458.085884497899,-5150.6456882191824,-5576.7714272829262,0,0]
[{"$f":"IF(C92=\"\",\"\",B92&\"-\"&C92)","v":"SCHMDT-OTHER"},"SCHMDT","OTHER","CUST",1.728,0,0,0,1.728,0]
["SCHMDT-OTHER","SCHMDT","OTHER","DDS2",-2.2120000000000175,-2.1417794138260002,8.8368219826035089E-3,3.6596956213363695E-2,-0.11465229772640949,-1.0020666435753447E-3]
[{"$f":"IF(C94=\"\",\"\",B94&\"-\"&C94)","v":"SCHMDT-OTHER"},"SCHMDT","OTHER","DMSC",871.45299999999997,0,0,0,0,871.45299999999997]
["SCHMDT-OTHER","SCHMDT","OTHER","DPW",368.68400000000003,0,0,368.68400000000003,0,0]
["SCHMDT-OTHER","SCHMDT","OTHER","LABOR",-3937.7089999999998,-1823.5279881750478,-310.352669455522,-1263.3398062080996,-540.48853616133044,0]
["SCHMDT-OTHER","SCHMDT","OTHER","P",-59544.117000000006,-59544.117000000006,0,0,0,0]
["SCHMDT-OTHER","SCHMDT","OTHER","PT",null,0,0,0,0,0]
[{"$f":"IF(C99=\"\",\"\",B99&\"-\"&C99)","v":"SCHMDT-OTHER"},"SCHMDT","OTHER","GP",-769.78499999999997,-375.5317768743169,-187.116583520608,-202.61392706823219,-4.5227125368431667,0]
["SCHMDT-TAXDEPR","SCHMDT","TAXDEPR","TAXDEPR",1137695.628,428954.54357628658,411581.57406515925,291180.12054543273,5979.3898131215519,0]
["SCHMDT-SITUS","SCHMDT","SITUS","DMSC",1955.4360000000001,0,0,0,0,1955.4360000000001]
[{"$f":"IF(C102=\"\",\"\",B102&\"-\"&C102)","v":"SCHMDT-SITUS"},"SCHMDT","SITUS","DDS2",1087.0710000000001,1052.5616135475702,-4.3427906462254535,-17.985302797385703,56.345021673483146,0.49245822255790461]
["SCHMDT-SITUS","SCHMDT","SITUS","GP",69.852999999999994,34.077075040435517,16.97961730699485,18.385900800219833,0.41040685234981938,0]
["SCHMDT-SITUS","SCHMDT","SITUS","LABOR",1106.5540000000001,512.43811805977839,87.213653369684195,355.01702028230062,151.88520828823687,0]
["SCHMDT-SITUS","SCHMDT","SITUS","P",-7233.4989999999989,-7233.4989999999989,0,0,0,0]
["SCHMDT-SITUS","SCHMDT","SITUS","PTD",17.126000000000001,8.4541386087415997,4.163694298711798,4.5081670925466044,0,0]
["","Total-GPS",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-GPS\",E:E)","v":-40012.756000000008},-19752.036981300778,-9727.9507201299966,-10532.768298569237,0,0]
[{"$f":"IF(C108=\"\",\"\",B108&\"-\"&C108)","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":206535.86301},206416.15801000001,119.705,0,0,0]
[{"$f":"IF(C110=\"\",\"\",B110&\"-\"&C110)","v":""},"Total-SE",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-SE\",E:E)","v":30456.54700000001},30456.54700000001,0,0,0,0]
["","Total-SNP",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-SNP\",E:E)","v":50212.205000000002},24786.928700253884,12207.653374065634,13217.622925680491,0,0]
["","Total SO",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-SO\",E:E)","v":42149.110999999997},18723.524572368246,3961.8779525758246,14622.871048741385,4840.8374263145415,0]
[{"$f":"IF(C113=\"\",\"\",B113&\"-\"&C113)","v":""},"Total OTHER",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-OTHER\",E:E)","v":-63011.958000000006},-61745.318544463196,-497.46041615414742,-1097.2331363201183,-543.39790099590005,871.45199793335644]
[{"$f":"IF(C114=\"\",\"\",B114&\"-\"&C114)","v":""},"Total TAXDEPR",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-TAXDEPR\",E:E)","v":1137695.628},428954.54357628658,411581.57406515925,291180.12054543273,5979.3898131215519,0]
["","Total-SITUS",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-SITUS\",E:E)+SUMIF($A:$A,\"SCHMDT-CN\",E:E)","v":-2997.458999999998},-5625.9680547434737,104.0141743291654,359.92578537768134,208.64063681406984,1955.928458222558]
["","Total SCHMDT",null,null,{"$f":"SUMIF($B:$B,\"SCHMDT\",E:E)","v":1361078.0860099997},622214.37827840145,417749.41342984576,307801.44387034292,10485.469975254266,2827.3804561559145]
["","SCHMDT-GPS",null,null,{"$f":"SUM(F117:J117)","v":1},{"$f":"IF(ISERROR(F107/$E107),\" \",(F107/$E107))","v":0.49364350161985276},0.24312123664088509,0.26323526173926221,0,0]
[{"$f":"IF(C118=\"\",\"\",B118&\"-\"&C118)","v":""},"SCHMDT-CN",null,null,{"$f":"SUM(F118:J118)","v":0}," "," "," "," "," "]
["","SCHMDT-SG",null,null,{"$f":"SUM(F119:J119)","v":1},0.99942041542686366,5.7958457313635723E-4,0,0,0]
[{"$f":"IF(C120=\"\",\"\",B120&\"-\"&C120)","v":""},"SCHMDT-SE",null,null,{"$f":"SUM(F120:J120)","v":1},1,0,0,0,0]
["","SCHMDT-SNP",null,null,1,0.49364350161985282,0.24312123664088509,0.26323526173926221,0,0]
["","SCHMDT-SO",null,null,1,0.44422110284528293,9.399671448766321E-2,0.34693189730007318,0.11485028536698062,0]
[{"$f":"IF(C123=\"\",\"\",B123&\"-\"&C123)","v":""},"SCHMDT-OTHER",null,null,{"$f":"SUM(F123:J123)","v":1},0.97989842728682053,7.8946985928313382E-3,1.7413093818162549E-2,8.6237266424239664E-3,-1.382994634023841E-2]
[{"$f":"IF(C124=\"\",\"\",B124&\"-\"&C124)","v":""},"SCHMDT-TAXDEPR",null,null,{"$f":"SUM(F124:J124)","v":1},0.37703805219886682,0.36176773816797969,0.25593850708322552,5.255702549928013E-3,0]
[{"$f":"IF(C125=\"\",\"\",B125&\"-\"&C125)","v":""},"SCHMDT-SITUS",null,null,1.0000000000000002,{"$f":"IF(ISERROR(F115/$E115),\" \",(F115/$E115))","v":1.8769124297424844},-3.4700783006261463E-2,-0.12007696698359563,-6.9605835080336367E-2,-0.65252884467229055]
["","SCHMDT FACTOR",null,null,1.0000000000000004,0.45714818618704151,0.30692538343224535,0.22614532335368268,7.7037975139195866E-3,2.0773095131113163E-3]
[]
["SCHMDF-DGP","SCHMDF","DGP","P",0,{"$f":"VLOOKUP($D128,$D$138:$J$150,3,FALSE)*$E128","v":0},{"$f":"VLOOKUP($D128,$D$138:$J$150,4,FALSE)*$E128","v":0},{"$f":"VLOOKUP($D128,$D$138:$J$150,5,FALSE)*$E128","v":0},{"$f":"VLOOKUP($D128,$D$138:$J$150,6,FALSE)*$E128","v":0},{"$f":"VLOOKUP($D128,$D$138:$J$150,7,FALSE)*$E128","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(F130:J130)","v":0},{"$f":"IF(ISERROR(F129/$E129),\" \",(F129/$E129))","v":" "},{"$f":"IF(ISERROR(G129/$E129),\" \",(G129/$E129))","v":" "},{"$f":"IF(ISERROR(H129/$E129),\" \",(H129/$E129))","v":" "},{"$f":"IF(ISERROR(I129/$E129),\" \",(I129/$E129))","v":" "},{"$f":"IF(ISERROR(J129/$E129),\" \",(J129/$E129))","v":" "}]
[]
["","Total-SCHMD",null,null,{"$f":"SUM(E129,E116,E74)","v":1377550.7690399997},638679.55846662296,417761.44567343494,307803.37952954159,10479.004914244884,2827.3804561559145]
["","SCHMD FACTOR",null,null,{"$f":"SUM(F133:J133)","v":1.0000000000000004},{"$f":"IF(ISERROR(F132/$E132),\" \",(F132/$E132))","v":0.46363413445132906},{"$f":"IF(ISERROR(G132/$E132),\" \",(G132/$E132))","v":0.30326391960462434},{"$f":"IF(ISERROR(H132/$E132),\" \",(H132/$E132))","v":0.22344249406070635},{"$f":"IF(ISERROR(I132/$E132),\" \",(I132/$E132))","v":7.6069827332371862E-3},{"$f":"IF(ISERROR(J132/$E132),\" \",(J132/$E132))","v":2.0524691501034734E-3}]
[]
["","Net SCHM"]
[""]
[null,null,null,null,"Total","Production","Transmission","Poles & Wires","Customers","Miscellaneous"]
[null,null,null,"DMSC",{"$f":"SUM(F138:J138)","v":1},0,0,0,0,1]
[null,null,null,"DPW",{"$f":"SUM(F139:J139)","v":1},0,0,1,0,0]
[null,null,null,"DDS2",1,{"$f":"DDS!F34","v":0.96825470787793089},{"$f":"DDS!G34","v":-3.9949466467465817E-3},{"$f":"DDS!H34","v":-1.6544736081990689E-2},{"$f":"DDS!I34","v":5.1831960997472233E-2},{"$f":"DDS!J34","v":4.5301385333423904E-4}]
[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.0000000000000004,{"$f":"'GROSS PLANT'!E42","v":0.48783982134533266},{"$f":"'GROSS PLANT'!F42","v":0.24307642201472882},{"$f":"'GROSS PLANT'!G42","v":0.26320846349075677},{"$f":"'GROSS PLANT'!H42","v":5.8752931491821312E-3},{"$f":"'GROSS PLANT'!I42","v":0}]
[null,null,null,"LABOR",1,{"$f":"'FORM 1'!C25","v":0.46309363850275576},{"$f":"'FORM 1'!D25","v":7.8815542097072699E-2},{"$f":"'FORM 1'!E25","v":0.32083117523618421},{"$f":"'FORM 1'!F25","v":0.13725964416398734},{"$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(F146:J146)","v":1},{"$f":"+'FORM 1'!C17","v":0.67001510249416218},{"$f":"+'FORM 1'!D17","v":0.32998489750583793},0,0,0]
[null,null,null,"PTD",1,{"$f":"'FORM 1'!C16","v":0.49364350161985282},{"$f":"'FORM 1'!D16","v":0.24312123664088509},{"$f":"'FORM 1'!E16","v":0.26323526173926221},{"$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",1,{"$f":"'TAX DEPR'!C24","v":0.37703805219886682},{"$f":"'TAX DEPR'!D24","v":0.36176773816797969},{"$f":"'TAX DEPR'!E24","v":0.25593850708322552},{"$f":"'TAX DEPR'!F24","v":5.255702549928013E-3},{"$f":"'TAX DEPR'!G24","v":0}]
[null,null,null,"TD",1,{"$f":"'FORM 1'!C18","v":0},{"$f":"'FORM 1'!D18","v":0.48013847441207663},{"$f":"'FORM 1'!E18","v":0.51986152558792331},{"$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 2015"}]
[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",164495.97621307644,{"$f":"VLOOKUP($D6,$D$71:$J$83,3,FALSE)*$E6","v":164495.97621307644},{"$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",2338.3855000000099,2338.3855000000099,0,0,0,0]
["RA-SGCT","182M","SGCT","P",0,0,0,0,0,0]
["RA-SG-P","182M","SG-P","P",0,0,0,0,0,0]
["RA-SO","182M","SO","DMSC",3855.7661923076976,0,0,0,0,3855.7661923076976]
["RA-SO","182M","SO","LABOR",473971.51113846194,219493.19163975975,37356.321588946608,152064.83694702291,65057.160962732647,0]
["RA-SO","182M","SO","ESD",16960.086826923089,5088.0260480769266,1696.0086826923089,10176.052096153853,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",10541.956917692352,0,0,0,10541.956917692352,0]
[{"$f":"\"RA\"&\"-\"&C16","v":"RA-OTHER"},"182M","OTHER","DMSC",6681.3812307692288,0,0,0,0,6681.3812307692288]
["RA-OTHER","182M","OTHER","LABOR",2615.6817346153812,1211.3055716482365,206.15637386712271,839.19224496047366,359.02754413954835,0]
["RA-OTHER","182M","OTHER","P",153404.83808692303,153404.83808692303,0,0,0,0]
["RA-OTHER","182M","OTHER","DPW",-374.733104615385,0,0,-374.733104615385,0,0]
["RA-OTHER","182M","OTHER","PTD",367.47900923076901,181.40362488847103,89.341951163751787,96.733433178546235,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",15.395650769230798,0,0,0,0,15.395650769230798]
["RA-SITUS","182M","SITUS","LABOR",-1763.3980530769236,-816.61842052806821,-138.98317348618031,-565.75306977786852,-242.04338928480658,0]
["RA-SITUS","182M","SITUS","P",33716.173016923072,33716.173016923072,0,0,0,0]
["RA-SITUS","182M","SITUS","PTD",13.224399999999999,6.5281391228215817,3.2151324818337206,3.4811283953446988,0,0]
["RA-SITUS","182M","SITUS","CUST",2003.5497192307694,0,0,0,2003.5497192307694,0]
[null,"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"RA-SO\",E:E)","v":494787.3641576927},224581.21768783667,39052.330271638915,162240.88904317675,65057.160962732647,3855.7661923076976]
[null,"Total-OTHER",null,null,{"$f":"SUMIF($A:$A,\"RA-OTHER\",E:E)","v":173236.60387461536},154797.54728345975,295.49832503087453,561.19257352363491,10900.9844618319,6681.3812307692288]
[null,"Total SITUS",null,null,{"$f":"SUMIF($A:$A,\"RA-SITUS\",E:E)","v":33984.944733846147},32906.082735517826,-135.76804100434657,-562.27194138252378,1761.5063299459628,15.395650769230798]
[null,"Total RA",null,null,{"$f":"SUMIF($B:$B,\"182M\",E:E)","v":868843.2744792304},579119.20941989089,39212.060555665448,162239.80967531784,77719.651754510502,10552.543073846158]
[null,"DDSO2 FACTOR",null,null,{"$f":"SUM(F33:J33)","v":0.99999999999999989},{"$f":"F29/$E29","v":0.45389440789409657},{"$f":"G29/$E29","v":7.8927501186535201E-2},{"$f":"H29/$E29","v":0.32790022703867855},{"$f":"I29/$E29","v":0.13148508970814868},{"$f":"J29/$E29","v":7.7927741725409829E-3}]
[null,"DDS2 FACTOR",null,null,{"$f":"SUM(F34:J34)","v":1},{"$f":"F31/$E31","v":0.96825470787793089},{"$f":"G31/$E31","v":-3.9949466467465817E-3},{"$f":"H31/$E31","v":-1.6544736081990689E-2},{"$f":"I31/$E31","v":5.1831960997472233E-2},{"$f":"J31/$E31","v":4.5301385333423904E-4}]
[]
[{"$f":"\"DD\"&\"-\"&C36","v":"DD-SE"},"186M","SE","P",5451.9044000000004,{"$f":"VLOOKUP($D36,$D$71:$J$83,3,FALSE)*$E36","v":5451.9044000000004},{"$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",47861.238885384722,{"$f":"VLOOKUP($D37,$D$71:$J$83,3,FALSE)*$E37","v":47861.238885384722},{"$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",13359.3773846153,{"$f":"VLOOKUP($D38,$D$71:$J$83,3,FALSE)*$E38","v":0},{"$f":"VLOOKUP($D38,$D$71:$J$83,4,FALSE)*$E38","v":13359.3773846153},{"$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",64.996588461528702,{"$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":64.996588461528702}]
[]
["DD-OTHER","186M","OTHER","DMSC",2724.3169792307699,{"$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":2724.3169792307699}]
["DD-OTHER","186M","OTHER","LABOR",2977.5164307692298,1378.8689176266614,234.67457159401789,955.28009576874047,408.69284577981011,0]
["DD-OTHER","186M","OTHER","P",75.211969230769199,75.211969230769199,0,0,0,0]
["DD-OTHER","186M","OTHER","PTD",84.618416153846198,41.771331251710556,20.572533977916134,22.274550924219518,0,0]
["DD-OTHER","186M","OTHER","T",4311.9302492307697,0,4311.9302492307697,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":61220.61627000002},47861.238885384722,13359.3773846153,0,0,0]
[null,"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"DD-SO\",E:E)","v":64.996588461528702},0,0,0,0,64.996588461528702]
[null,"Total-DD",null,null,{"$f":"SUMIF($B:$B,\"186M\",E:E)","v":76911.111303076948},54808.995503493861,17926.554739418003,977.55464669295998,408.69284577981011,2789.3135676922984]
[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.78178302998949389},0.21821697001050616,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":64.996588461528702},0,0,0,0,64.996588461528702]
[]
[null,"Total 182 &186",null,null,{"$f":"SUM(E51,E32)","v":945754.38578230736},{"$f":"SUM(F32,F51)","v":633928.20492338471},{"$f":"SUM(G32,G51)","v":57138.615295083451},{"$f":"SUM(H32,H51)","v":163217.36432201081},{"$f":"SUM(I32,I51)","v":78128.344600290307},{"$f":"SUM(J32,J51)","v":13341.856641538456}]
[]
[]
[]
[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.0000000000000004,{"$f":"'GROSS PLANT'!$E$42","v":0.48783982134533266},{"$f":"'GROSS PLANT'!$F$42","v":0.24307642201472882},{"$f":"'GROSS PLANT'!$G$42","v":0.26320846349075677},{"$f":"'GROSS PLANT'!$H$42","v":5.8752931491821312E-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.46309363850275576},{"$f":"'FORM 1'!$D$25","v":7.8815542097072699E-2},{"$f":"'FORM 1'!$E$25","v":0.32083117523618421},{"$f":"'FORM 1'!$F$25","v":0.13725964416398734},{"$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.67001510249416218},{"$f":"'FORM 1'!$D$17","v":0.32998489750583793},{"$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.49364350161985282},{"$f":"'FORM 1'!$D$16","v":0.24312123664088509},{"$f":"'FORM 1'!$E$16","v":0.26323526173926221},{"$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",1,{"$f":"'TAX DEPR'!C24","v":0.37703805219886682},{"$f":"'TAX DEPR'!D24","v":0.36176773816797969},{"$f":"'TAX DEPR'!E24","v":0.25593850708322552},{"$f":"'TAX DEPR'!F24","v":5.255702549928013E-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.48013847441207663},{"$f":"'FORM 1'!$E$18","v":0.51986152558792331},{"$f":"'FORM 1'!$F$18","v":0},{"$f":"'FORM 1'!$G$18","v":0}]

{"sheet":"ACCUMDIT","index":10,"n_rows":72,"n_cols":8,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'TOTAL FUNCFAC'!A1","v":"PacifiCorp"}]
[{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended December 2015"}]
["Deferred Income Tax - Balance"]
[]
[]
[]
["DITBALRL"]
["Pacific Division",null,"Total","Production","Transmission","DPW","CUST","DMSC"]
["Pacific Division"]
["Production","P",42724405,{"$f":"VLOOKUP($B10,$B$59:$H$72,3,FALSE)*$C10","v":42724405},{"$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",17577756,{"$f":"VLOOKUP($B11,$B$59:$H$72,3,FALSE)*$C11","v":0},{"$f":"VLOOKUP($B11,$B$59:$H$72,4,FALSE)*$C11","v":17577756},{"$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",20834796,{"$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":20834796},{"$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",-340826,{"$f":"VLOOKUP($B13,$B$59:$H$72,3,FALSE)*$C13","v":-75112.360331226097},{"$f":"VLOOKUP($B13,$B$59:$H$72,4,FALSE)*$C13","v":-115878.62836760907},{"$f":"VLOOKUP($B13,$B$59:$H$72,5,FALSE)*$C13","v":-143963.87016612338},{"$f":"VLOOKUP($B13,$B$59:$H$72,6,FALSE)*$C13","v":-5871.1411350414328},{"$f":"VLOOKUP($B13,$B$59:$H$72,7,FALSE)*$C13","v":0}]
["Mining Plant","P",3474,{"$f":"VLOOKUP($B14,$B$59:$H$72,3,FALSE)*$C14","v":3474},{"$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":80799605},{"$f":"SUM(D10:D14)","v":42652766.639668778},17461877.37163239,20690832.129833877,-5871.1411350414328,0]
[]
["Utah Division"]
["Production","P",65261524,{"$f":"VLOOKUP($B19,$B$59:$H$72,3,FALSE)*$C19","v":65261524},{"$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",41175577,0,41175577,0,0,0]
["Distribution","DPW",30022827,0,0,30022827,0,0]
["General","G",-717525,-158130.53096495866,-243953.8439540079,-303080.3868864103,-12360.238194623074,0]
["Mining Plant","P",8895,8895,0,0,0,0]
[]
["     Total Utah Division",null,{"$f":"SUM(C19:C23)","v":135751298},{"$f":"SUM(D19:D23)","v":65112288.469035044},40931623.156045996,29719746.61311359,-12360.238194623074,0]
[]
["PACIFICORP"]
["Prod / Other Prod","P",479644261,{"$f":"VLOOKUP($B28,$B$59:$H$72,3,FALSE)*$C28","v":479644261},{"$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",30793696,30793696,0,0,0,0]
["Gadsby Unit 4, 5 & 6","P",5816168,5816168,0,0,0,0]
["Hydro-PPL","P",39398249,39398249,0,0,0,0]
["Hydro-UPL","P",12101337,12101337,0,0,0,0]
["Transmission","T",272129805,0,272129805,0,0,0]
["Distribution","DPW",875230929,0,0,875230929,0,0]
["General/ Intangibles","G",75274365,16589213.345179752,25592795.641889878,31795663.798235409,1296692.2146949561,0]
["Mining","P",-3024872,-3024872,0,0,0,0]
["WCA - CAEE 2007+","P",2055850,2055850,0,0,0,0]
["WCA - CAGE 2007+","PT",1716595647,1150145008.3657377,566450638.63426256,0,0,0]
["WCA - CAGW 2007+","PT",402197223,269478213.59121239,132719009.40878764,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",153090545,33738600.280916899,52049791.889849171,64664982.55426836,2637170.2749655587,0]
["WCA - JBG 2007+","P",116578868,116578868,0,0,0,0]
["OREGON EXTRA BOOK DEPR","P",-46752810,-46752810,0,0,0,0]
[]
["     Total PC (Post Merger)",null,{"$f":"SUM(C28:C44)","v":4131129261},{"$f":"SUM(D28:D44)","v":2106561782.5830469},1048942040.5747892,971691575.35250378,3933862.4896605145,0]
[]
["Total Deferred Taxes ",null,{"$f":"C16+C25+C46","v":4347680164},{"$f":"D16+D25+D46","v":2214326837.6917505},1107335541.1024675,1022102154.0954512,3915631.1103308499,0]
[]
["ACCMDITRL FACTOR",null,1,{"$f":"D48/$C$48","v":0.50931226634999327},{"$f":"E48/$C$48","v":0.254695722622725},0.2350913856448644,9.0062538241735522E-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.96825470787793089},{"$f":"DDS!G34","v":-3.9949466467465817E-3},{"$f":"DDS!H34","v":-1.6544736081990689E-2},{"$f":"DDS!I34","v":5.1831960997472233E-2},{"$f":"DDS!J34","v":4.5301385333423904E-4}]
[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":0.99999999999999989},{"$f":"'GENERAL PLANT'!E38","v":0.22038330506248377},{"$f":"'GENERAL PLANT'!F38","v":0.33999351096339209},{"$f":"'GENERAL PLANT'!G38","v":0.42239697137578525},{"$f":"'GENERAL PLANT'!H38","v":1.7226212598338838E-2},{"$f":"'GENERAL PLANT'!I38","v":0}]
[null,"GP",1.0000000000000004,{"$f":"'GROSS PLANT'!E42","v":0.48783982134533266},{"$f":"'GROSS PLANT'!F42","v":0.24307642201472882},{"$f":"'GROSS PLANT'!G42","v":0.26320846349075677},{"$f":"'GROSS PLANT'!H42","v":5.8752931491821312E-3},{"$f":"'GROSS PLANT'!I42","v":0}]
[null,"LABOR",1,{"$f":"'FORM 1'!C25","v":0.46309363850275576},{"$f":"'FORM 1'!D25","v":7.8815542097072699E-2},{"$f":"'FORM 1'!E25","v":0.32083117523618421},{"$f":"'FORM 1'!F25","v":0.13725964416398734},{"$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.67001510249416218},{"$f":"+'FORM 1'!D17","v":0.32998489750583793},{"$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.49364350161985282},{"$f":"'FORM 1'!D16","v":0.24312123664088509},{"$f":"'FORM 1'!E16","v":0.26323526173926221},{"$f":"'FORM 1'!F16","v":0},{"$f":"'FORM 1'!G16","v":0}]
[null,"T",1,0,1,0,0,0]
[null,"TAXDEPR",1,{"$f":"'TAX DEPR'!C24","v":0.37703805219886682},{"$f":"'TAX DEPR'!D24","v":0.36176773816797969},{"$f":"'TAX DEPR'!E24","v":0.25593850708322552},{"$f":"'TAX DEPR'!F24","v":5.255702549928013E-3},{"$f":"'TAX DEPR'!G24","v":0}]
[null,"TD",1,{"$f":"'FORM 1'!C18","v":0},{"$f":"'FORM 1'!D18","v":0.48013847441207663},{"$f":"'FORM 1'!E18","v":0.51986152558792331},{"$f":"'FORM 1'!F18","v":0},{"$f":"'FORM 1'!G18","v":0}]