{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Page 1","Page 2","Page 3","Page 4","Page 5","Page 6","Page 7","Page 8","Page 9","Page 10","Page 11","Page 12","Page 13","Page 14"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":66,"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":"Page 1","index":0,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,0,2,7]]}
["PacifiCorp"]
["12 Months Ended June 2011"]
["Functional Factors "]
[]
[]
["Function","Description","Production","Transmission","DPW","CUST","DMSC","Total"]
[]
["BOOKDEPR","Book Depreciation",{"$f":"'Page 7'!C12","v":0.53330883081307834},{"$f":"'Page 7'!D12","v":0.16661852821541756},{"$f":"'Page 7'!E12","v":0.29663707297504832},{"$f":"'Page 7'!F12","v":3.4355679964556858E-3},{"$f":"'Page 7'!G12","v":0},{"$f":"ROUND(SUM(C8:G8),4)","v":1}]
["CUST","Distribution Retail",0,0,0,1,0,1]
["DDS2","Deferred Debits - Situs",{"$f":"'Page 12'!F34","v":0.8654170762895036},{"$f":"'Page 12'!G34","v":1.1344409372251537E-2},{"$f":"'Page 12'!H34","v":7.1894508570484687E-3},{"$f":"'Page 12'!I34","v":0.14539156536514505},{"$f":"'Page 12'!J34","v":-2.9342501883948758E-2},1]
["DDSO2","Deferred Debits - System Overhead",{"$f":"'Page 12'!F33","v":0.11177468612147946},{"$f":"'Page 12'!G33","v":3.7258228707159828E-2},{"$f":"'Page 12'!H33","v":0.22354937224295893},{"$f":"'Page 12'!I33","v":0},{"$f":"'Page 12'!J33","v":0.62741771292840176},1]
["DEFSG","Deferred Debit - System Generation",{"$f":"'Page 12'!F47","v":0.63464816167518867},{"$f":"'Page 12'!G47","v":0.36535183832481127},{"$f":"'Page 12'!H47","v":0},{"$f":"'Page 12'!I47","v":0},{"$f":"'Page 12'!J47","v":0},1]
["DMSC","Distribution Miscellaneous",0,0,0,0,1,1]
["DPW","Distribution Poles & Wires",{"$f":"'Page 14'!C15","v":0},{"$f":"'Page 14'!D15","v":0},{"$f":"'Page 14'!E15","v":1},{"$f":"'Page 14'!F15","v":0},{"$f":"'Page 14'!G15","v":0},1]
["ESD","Environmental Services Department",0.3,0.1,0.6,0,0,1]
["FERC","FERC Fees",{"$f":"'Page 14'!C39","v":0.53728866283770005},{"$f":"'Page 14'!D39","v":0.4627113371622999},{"$f":"'Page 14'!E39","v":0},{"$f":"'Page 14'!F39","v":0},{"$f":"'Page 14'!G39","v":0},1]
["G","General Plant",{"$f":"'Page 3'!E38","v":0.23284244722796199},{"$f":"'Page 3'!F38","v":0.2990202443759668},{"$f":"'Page 3'!G38","v":0.44193116167922869},{"$f":"'Page 3'!H38","v":2.6206146716842512E-2},{"$f":"'Page 3'!I38","v":0},1]
["G-DGP","General Plant - DGP Factor",0.69712876692486192,0.30287123307513802,0,0,0,1]
["G-DGU","General Plant - DGU Factor",0.69712876692486192,0.30287123307513802,0,0,0,1]
["GP","Total Plant",{"$f":"'Page 4'!E43","v":0.50926645632842615},{"$f":"'Page 4'!F43","v":0.21576006978240711},{"$f":"'Page 4'!G43","v":0.26867509095069092},{"$f":"'Page 4'!H43","v":6.2983829384758213E-3},{"$f":"'Page 4'!I43","v":0},1]
["G-SG","General Plant - SG Factor",{"$f":"'Page 3'!E34","v":0.47156660238274711},{"$f":"'Page 3'!F34","v":0.52843339761725294},{"$f":"'Page 3'!G34","v":0},{"$f":"'Page 3'!H34","v":0},{"$f":"'Page 3'!I34","v":0},1]
["G-SITUS","General Plant - SITUS Factor",{"$f":"'Page 3'!E36","v":0},{"$f":"'Page 3'!F36","v":0.25712929813384683},{"$f":"'Page 3'!G36","v":0.74287070186615312},{"$f":"'Page 3'!H36","v":0},{"$f":"'Page 3'!I36","v":0},1]
["I","Intangible Plant",{"$f":"'Page 5'!D33","v":0.55656937860616518},{"$f":"'Page 5'!E33","v":0.14769088765991648},{"$f":"'Page 5'!F33","v":0.14123903943769978},{"$f":"'Page 5'!G33","v":0.15450069429621865},{"$f":"'Page 5'!H33","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":"'Page 5'!D31","v":0.85459762506580794},{"$f":"'Page 5'!E31","v":0.14540237493419209},{"$f":"'Page 5'!F31","v":0},{"$f":"'Page 5'!G31","v":0},{"$f":"'Page 5'!H31","v":0},1]
["I-SITUS","Intangible Plant - SITUS Factor",{"$f":"'Page 5'!D32","v":2.7634291901946124E-2},{"$f":"'Page 5'!E32","v":0.46796630452447796},{"$f":"'Page 5'!F32","v":0.50439940357357582},{"$f":"'Page 5'!G32","v":0},{"$f":"'Page 5'!H32","v":0},1]
["LABOR","Direct Labor Expense",{"$f":"'Page 14'!C25","v":0.42712904549402431},{"$f":"'Page 14'!D25","v":6.855059317608897E-2},{"$f":"'Page 14'!E25","v":0.35533822131657783},{"$f":"'Page 14'!F25","v":0.14898214001330889},{"$f":"'Page 14'!G25","v":0},1]
["MSS","Materials & Supplies",{"$f":"'Page 14'!C32","v":0.84309552049741154},{"$f":"'Page 14'!D32","v":6.4844048397869371E-3},{"$f":"'Page 14'!E32","v":0.15042007466280158},{"$f":"'Page 14'!F32","v":0},{"$f":"'Page 14'!G32","v":0},1]
["OTHDGP","Other Revenues - DGP Factor",{"$f":"C34","v":0.65778675941071063},{"$f":"D34","v":0.34221324058928942},{"$f":"E34","v":0},{"$f":"F34","v":0},{"$f":"G34","v":0},1]
["OTHDGU","Other Revenues - DGU Factor",{"$f":"C34","v":0.65778675941071063},{"$f":"D34","v":0.34221324058928942},{"$f":"E34","v":0},{"$f":"F34","v":0},{"$f":"G34","v":0},1]
["OTHSE","Other Revenues - SE Factor",{"$f":"'Page 6'!E23","v":0},{"$f":"'Page 6'!F23","v":1},{"$f":"'Page 6'!G23","v":0},{"$f":"'Page 6'!H23","v":0},{"$f":"'Page 6'!I23","v":0},1]
["OTHSG","Other Revenues - SG Factor",{"$f":"'Page 6'!E24","v":0.65778675941071063},{"$f":"'Page 6'!F24","v":0.34221324058928942},{"$f":"'Page 6'!G24","v":0},{"$f":"'Page 6'!H24","v":0},{"$f":"'Page 6'!I24","v":0},1]
["OTHSGR","Other Revenues - Rolled-In SG Factor",{"$f":"+C33","v":0.65778675941071063},{"$f":"+D33","v":0.34221324058928942},{"$f":"+E33","v":0},{"$f":"+F33","v":0},{"$f":"+G33","v":0},1]
["OTHSITUS","Other Revenues - SITUS",{"$f":"'Page 6'!E21","v":0},{"$f":"'Page 6'!F21","v":0},{"$f":"'Page 6'!G21","v":0},{"$f":"'Page 6'!H21","v":0},{"$f":"'Page 6'!I21","v":1},1]
["OTHSO","Other Revenues - SO Factor",{"$f":"'Page 6'!E25","v":0},{"$f":"'Page 6'!F25","v":0},{"$f":"'Page 6'!G25","v":0},{"$f":"'Page 6'!H25","v":0},{"$f":"'Page 6'!I25","v":1},1]
["P","Production",{"$f":"'Page 14'!C13","v":1},{"$f":"'Page 14'!D13","v":0},{"$f":"'Page 14'!E13","v":0},{"$f":"'Page 14'!F13","v":0},{"$f":"'Page 14'!G13","v":0},1]

{"sheet":"Page 2","index":1,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,7]]}
["PacifiCorp"]
["12 Months Ended June 2011"]
["Functional Factors "]
[]
[]
["Function","Description","Production","Transmission","DPW","CUST","DMSC","Total"]
[]
["SCHMA","Schedule M Additions",{"$f":"'Page 9'!F12","v":0.52592735793137158},{"$f":"'Page 9'!G12","v":0.17749230447050818},{"$f":"'Page 9'!H12","v":0.2797551697710543},{"$f":"'Page 9'!I12","v":1.2090484078880118E-2},{"$f":"'Page 9'!J12","v":4.7346837481858691E-3},{"$f":"ROUND(SUM(C8:G8),4)","v":1}]
["SCHMAF","Schedule M Additions - Flow Through",1,0,0,0,0,1]
["SCHMAP","Schedule M Additions - Permanent",{"$f":"'Page 8'!F16","v":0.43956098409095457},{"$f":"'Page 8'!G16","v":7.8689969960154899E-2},{"$f":"'Page 8'!H16","v":0.34527455396186357},{"$f":"'Page 8'!I16","v":0.13647449198702705},{"$f":"'Page 8'!J16","v":0},1]
["SCHMAP-SO","Schedule M Additions - Permanent-SO",{"$f":"'Page 8'!F15","v":0.43281923253404248},{"$f":"'Page 8'!G15","v":7.9188139695999277E-2},{"$f":"'Page 8'!H15","v":0.34951873105478648},{"$f":"'Page 8'!I15","v":0.1384738967151718},{"$f":"'Page 8'!J15","v":0},1]
["SCHMAT","Schedule M Additions - Temporary",{"$f":"+'Page 8'!F$55","v":0.52740517946323806},{"$f":"+'Page 8'!G$55","v":0.17918291866264574},{"$f":"+'Page 8'!H$55","v":0.27863406265023533},{"$f":"+'Page 8'!I$55","v":9.9621399452459927E-3},{"$f":"+'Page 8'!J$55","v":4.8156992786349741E-3},1]
["SCHMAT-SE","Schedule M Additions - Temporary-SE",{"$f":"'Page 8'!F51","v":0.99970273171677915},{"$f":"'Page 8'!G51","v":3.5571566313406565E-5},{"$f":"'Page 8'!H51","v":1.8438844242794246E-4},{"$f":"'Page 8'!I51","v":7.7308274479602295E-5},{"$f":"'Page 8'!J51","v":0},1]
["SCHMAT-SITUS","Schedule M Additions - Temporary-SITUS",{"$f":"'Page 8'!F53","v":0.56171083564203561},{"$f":"'Page 8'!G53","v":4.5221940914908262E-2},{"$f":"'Page 8'!H53","v":0.22924058443625531},{"$f":"'Page 8'!I53","v":3.5863226649137943E-2},{"$f":"'Page 8'!J53","v":0.12796341235766287},1]
["SCHMAT-SNP","Schedule M Additions - Temporary-SNP",{"$f":"'Page 8'!F52","v":0.50786983377167305},{"$f":"'Page 8'!G52","v":0.21920008801843979},{"$f":"'Page 8'!H52","v":0.2726403702431649},{"$f":"'Page 8'!I52","v":2.8970796672232258E-4},{"$f":"'Page 8'!J52","v":0},1]
["SCHMAT-SO","Schedule M Additions - Temporary-SO",{"$f":"'Page 8'!F54","v":0.47953534255774422},{"$f":"'Page 8'!G54","v":0.16652178797705691},{"$f":"'Page 8'!H54","v":0.30174104897865572},{"$f":"'Page 8'!I54","v":5.2201820486543121E-2},{"$f":"'Page 8'!J54","v":0},1]
["SCHMD","Schedule M Deductions",{"$f":"+'Page 10'!F$25","v":0.58363443343232746},{"$f":"+'Page 10'!G$25","v":0.18373948447688987},{"$f":"+'Page 10'!H$25","v":0.21126920683782022},{"$f":"+'Page 10'!I$25","v":5.3105496369128327E-3},{"$f":"+'Page 10'!J$25","v":1.6046325616049614E-2},1]
["SCHMDF","Schedule M Deductions - Flow Through",1,0,0,0,0,1]
["SCHMDP","Schedule M Deductions - Permanent",{"$f":"'Page 9'!F24","v":0.44350674696753561},{"$f":"'Page 9'!G24","v":6.9241309808896062E-2},{"$f":"'Page 9'!H24","v":0.34464326134131928},{"$f":"'Page 9'!I24","v":0.14260868188224907},{"$f":"'Page 9'!J24","v":0},1]
["SCHMDP-SO","Schedule M Deductions - Permanent- SO",{"$f":"'Page 9'!F23","v":0.42712904549402431},{"$f":"'Page 9'!G23","v":6.855059317608897E-2},{"$f":"'Page 9'!H23","v":0.35533822131657783},{"$f":"'Page 9'!I23","v":0.14898214001330889},{"$f":"'Page 9'!J23","v":0},1]
["SCHMDT","Schedule M Deductions - Temporary",{"$f":"+'Page 10'!F18","v":0.58457280955951785},{"$f":"+'Page 10'!G18","v":0.18450623055274348},{"$f":"+'Page 10'!H18","v":0.21037605694082162},{"$f":"+'Page 10'!I18","v":4.3911218431825199E-3},{"$f":"+'Page 10'!J18","v":1.6153781103734471E-2},{"$f":"ROUND(SUM(C21:G21),4)","v":1}]
["SCHMDT-GPS","Schedule M Deductions - Temporary-GPS",{"$f":"'Page 10'!F9","v":0.50790729766261489},{"$f":"'Page 10'!G9","v":0.21910781078332736},{"$f":"'Page 10'!H9","v":0.27253400307169895},{"$f":"'Page 10'!I9","v":4.5088848235883444E-4},{"$f":"'Page 10'!J9","v":0},1]
["SCHMDT-SG","Schedule M Deductions - Temporary-SG",{"$f":"'Page 10'!F11","v":1},{"$f":"'Page 10'!G11","v":0},{"$f":"'Page 10'!H11","v":0},{"$f":"'Page 10'!I11","v":0},{"$f":"'Page 10'!J11","v":0},1]
["SCHMDT-SITUS","Schedule M Deductions - Temporary-SITUS",{"$f":"'Page 10'!F17","v":0.83446664233208079},{"$f":"'Page 10'!G17","v":1.1838611749211416E-2},{"$f":"'Page 10'!H17","v":6.3316079492887853E-2},{"$f":"'Page 10'!I17","v":2.9438266343328669E-2},{"$f":"'Page 10'!J17","v":6.0940400082491235E-2},1]
["SCHMDT-SNP","Schedule M Deductions - Temporary-SNP",{"$f":"'Page 10'!F13","v":0.50780249568414171},{"$f":"'Page 10'!G13","v":0.2193659483276317},{"$f":"'Page 10'!H13","v":0.27283155598822667},{"$f":"'Page 10'!I13","v":0},{"$f":"'Page 10'!J13","v":0},1]
["SCHMDT-SO","Schedule M Deductions - Temporary-SO",{"$f":"'Page 10'!F14","v":0.44777325063596862},{"$f":"'Page 10'!G14","v":0.18161323250672493},{"$f":"'Page 10'!H14","v":0.36596892501547851},{"$f":"'Page 10'!I14","v":4.6445918418280508E-3},{"$f":"'Page 10'!J14","v":0},1]
["T","Transmission",{"$f":"'Page 14'!C14","v":0},{"$f":"'Page 14'!D14","v":1},{"$f":"'Page 14'!E14","v":0},{"$f":"'Page 14'!F14","v":0},{"$f":"'Page 14'!G14","v":0},1]
["TAXDEPR ","Tax Depreciation ",{"$f":"+'Page 11'!C$24","v":0.57747451163818431},{"$f":"+'Page 11'!D$24","v":0.1959065237010699},{"$f":"+'Page 11'!E$24","v":0.22210242530333088},{"$f":"+'Page 11'!F$24","v":4.516539357414911E-3},{"$f":"+'Page 11'!G$24","v":0},1]
["TD","Transmission / Distribution",{"$f":"'Page 14'!C18","v":0},{"$f":"'Page 14'!D18","v":0.44568683588216201},{"$f":"'Page 14'!E18","v":0.55431316411783793},{"$f":"'Page 14'!F18","v":0},{"$f":"'Page 14'!G18","v":0},1]

{"sheet":"Page 3","index":2,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'Page 1'!$A$1","v":"PacifiCorp"}]
[{"$f":"+'Page 1'!A2","v":"12 Months Ended June 2011"}]
["General Plant"]
[]
[null,"Alloc."]
["Description","Factor","Funct.","Amount","Prod","Trans","DPW","CUST","DMISC"]
["Business Centers","CN","CUST",24826,{"$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":24826},{"$f":"$D7*VLOOKUP(+$C7,$B$45:$H$51,7)","v":0}]
[null,"SE","P",660,660,0,0,0,0]
[null,"SG","P",96342,96342,0,0,0,0]
[null,"SG","T",107960,0,107960,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",243358,123577.79974470136,53384.458453115796,66395.741802182863,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",200616,0,0,200616,0,0]
[null,"SITUS","P",0,0,0,0,0,0]
[null,"SITUS","TD",273573,0,121927.88475279071,151645.11524720927,0,0]
["Total-CUST",null,null,{"$f":"SUMIF($C:$C,\"CUST\",D:D)","v":24826},0,0,0,24826,0]
["Total-TD",null,null,{"$f":"SUMIF($C:$C,\"TD\",D:D)","v":273573},0,121927.88475279071,151645.11524720927,0,0]
["Total-PTD",null,null,{"$f":"SUMIF($C:$C,\"PTD\",D:D)","v":243358},123577.79974470136,53384.458453115796,66395.741802182863,0,0]
["Total-DPW",null,null,{"$f":"SUMIF($C:$C,\"DPW\",D:D)","v":200616},0,0,200616,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":204302},96342,107960,0,0,0]
["Total-SE",null,null,{"$f":"SUMIF($B:$B,\"SE\",D:D)","v":660},660,0,0,0,0]
["Total-G-Situs",null,null,{"$f":"SUMIF($B:$B,\"SITUS\",D:D)","v":474189},0,121927.88475279071,352261.11524720927,0,0]
["Total-SO",null,null,{"$f":"SUMIF($B:$B,\"SO\",D:D)","v":243358},123577.79974470136,53384.458453115796,66395.741802182863,0,0]
["Total-General Plant",null,null,{"$f":"SUM(D7:D21)","v":947335},220579.79974470136,283272.34320590651,418656.85704939213,24826,0]
[]
["G-SG Factor",null,null,{"$f":"SUM(E34:I34)","v":1},{"$f":"E28/$D$28","v":0.47156660238274711},{"$f":"F28/$D$28","v":0.52843339761725294},{"$f":"G28/$D$28","v":0},{"$f":"H28/$D$28","v":0},{"$f":"I28/$D$28","v":0}]
["SE Factor",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.25712929813384683},{"$f":"G30/$D$30","v":0.74287070186615312},{"$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.50780249568414171},{"$f":"F31/$D$31","v":0.2193659483276317},{"$f":"G31/$D$31","v":0.27283155598822667},{"$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.23284244722796199},{"$f":"F32/$D$32","v":0.2990202443759668},{"$f":"G32/$D$32","v":0.44193116167922869},{"$f":"H32/$D$32","v":2.6206146716842512E-2},{"$f":"I32/$D$32","v":0}]
["Total Gen. Plant",null,null,{"$f":"D32","v":947335}]
["Mining",null,null,{"$f":"'Page 4'!D12","v":482169.42363653303},{"$f":"D29","v":660},{"$f":"SUM(D40+E40)","v":482829.42363653303}]
["Total ",null,"P",{"$f":"SUM(D39:D40)","v":1429504.4236365331}]
[]
[]
[null,"Functional Allocators:",null,"Prod","Trans","DPW","CUST","DMISC"]
[null,"P",{"$f":"SUM(D45:H45)","v":1},{"$f":"'Page 14'!$C$13","v":1},{"$f":"'Page 14'!$D$13","v":0},{"$f":"'Page 14'!$E$13","v":0},{"$f":"'Page 14'!$F$13","v":0},{"$f":"'Page 14'!$G$13","v":0}]
[null,"T",1,{"$f":"'Page 14'!$C$14","v":0},{"$f":"'Page 14'!$D$14","v":1},{"$f":"'Page 14'!$E$14","v":0},{"$f":"'Page 14'!$F$14","v":0},{"$f":"'Page 14'!$G$14","v":0}]
[null,"TD",1,{"$f":"'Page 14'!$C$18","v":0},{"$f":"'Page 14'!$D$18","v":0.44568683588216201},{"$f":"'Page 14'!$E$18","v":0.55431316411783793},{"$f":"'Page 14'!$F$18","v":0},{"$f":"'Page 14'!$G$18","v":0}]
[null,"CUST",1,0,0,0,1,0]
[null,"DPW",1,0,0,1,0,0]
[null,"PTD",1,{"$f":"'Page 14'!$C$16","v":0.50780249568414171},{"$f":"'Page 14'!$D$16","v":0.2193659483276317},{"$f":"'Page 14'!$E$16","v":0.27283155598822667},{"$f":"'Page 14'!$F$16","v":0},{"$f":"'Page 14'!$G$16","v":0}]
[null,"GP",{"$f":"SUM(D51:H51)","v":1},{"$f":"+'Page 4'!E43","v":0.50926645632842615},{"$f":"+'Page 4'!F43","v":0.21576006978240711},{"$f":"+'Page 4'!G43","v":0.26867509095069092},{"$f":"+'Page 4'!H43","v":6.2983829384758213E-3},{"$f":"+'Page 4'!I43","v":0}]

{"sheet":"Page 4","index":3,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["PacifiCorp"]
["Gross Plant"]
[{"$f":"+'Page 1'!A2","v":"12 Months Ended June 2011"}]
["(In 000's)"]
[]
[null,"Alloc."]
["Description","Factor","Funct.","Amount","Production","Transmisssion","DPW","CUSTOMER","DMISC"]
[]
["Production Plant",null,"P",10754154.3554995,{"$f":"$D9*VLOOKUP(+$C9,$C$46:$I$52,3)","v":10754154.3554995},{"$f":"$D9*VLOOKUP(+$C9,$C$46:$I$52,4)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$46:$I$52,5)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$46:$I$52,6)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$46:$I$52,7)","v":0}]
["Transmission Plant",null,"T",4645694.5145130996,{"$f":"$D10*VLOOKUP(+$C10,$C$46:$I$52,3)","v":0},{"$f":"$D10*VLOOKUP(+$C10,$C$46:$I$52,4)","v":4645694.5145130996},{"$f":"$D10*VLOOKUP(+$C10,$C$46:$I$52,5)","v":0},{"$f":"$D10*VLOOKUP(+$C10,$C$46:$I$52,6)","v":0},{"$f":"$D10*VLOOKUP(+$C10,$C$46:$I$52,7)","v":0}]
["Distribution Plant",null,"DPW",5777980.0042052502,{"$f":"$D11*VLOOKUP(+$C11,$C$46:$I$52,3)","v":0},{"$f":"$D11*VLOOKUP(+$C11,$C$46:$I$52,4)","v":0},{"$f":"$D11*VLOOKUP(+$C11,$C$46:$I$52,5)","v":5777980.0042052502},{"$f":"$D11*VLOOKUP(+$C11,$C$46:$I$52,6)","v":0},{"$f":"$D11*VLOOKUP(+$C11,$C$46:$I$52,7)","v":0}]
["Mining","SE","P",482169.42363653303,{"$f":"$D12*VLOOKUP(+$C12,$C$46:$I$52,3)","v":482169.42363653303},{"$f":"$D12*VLOOKUP(+$C12,$C$46:$I$52,4)","v":0},{"$f":"$D12*VLOOKUP(+$C12,$C$46:$I$52,5)","v":0},{"$f":"$D12*VLOOKUP(+$C12,$C$46:$I$52,6)","v":0},{"$f":"$D12*VLOOKUP(+$C12,$C$46:$I$52,7)","v":0}]
["General Plant"]
["Business Centers",{"$f":"'Page 3'!B7","v":"CN"},{"$f":"'Page 3'!C7","v":"CUST"},{"$f":"'Page 3'!D7","v":24826},{"$f":"$D14*VLOOKUP(+$C14,$C$46:$I$52,3)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$46:$I$52,4)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$46:$I$52,5)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$46:$I$52,6)","v":24826},{"$f":"$D14*VLOOKUP(+$C14,$C$46:$I$52,7)","v":0}]
["Utah Mine",{"$f":"'Page 3'!B8","v":"SE"},{"$f":"'Page 3'!C8","v":"P"},{"$f":"'Page 3'!D8","v":660},660,0,0,0,0]
[null,{"$f":"'Page 3'!B9","v":"SG"},{"$f":"'Page 3'!C9","v":"P"},{"$f":"'Page 3'!D9","v":96342},96342,0,0,0,0]
[null,{"$f":"'Page 3'!B10","v":"SG"},{"$f":"'Page 3'!C10","v":"T"},{"$f":"'Page 3'!D10","v":107960},0,107960,0,0,0]
[null,{"$f":"'Page 3'!B12","v":"SO"},{"$f":"'Page 3'!C12","v":"DPW"},{"$f":"'Page 3'!D12","v":0},0,0,0,0,0]
[null,{"$f":"'Page 3'!B16","v":"SG"},{"$f":"'Page 3'!C16","v":"P"},{"$f":"'Page 3'!D16","v":0},0,0,0,0,0]
[null,{"$f":"'Page 3'!B17","v":"SG"},{"$f":"'Page 3'!C17","v":"DPW"},{"$f":"'Page 3'!D17","v":0},0,0,0,0,0]
[null,{"$f":"'Page 3'!B18","v":"SG"},{"$f":"'Page 3'!C18","v":"P"},{"$f":"'Page 3'!D18","v":0},0,0,0,0,0]
["General Plant",{"$f":"'Page 3'!B19","v":"SITUS"},{"$f":"'Page 3'!C19","v":"DPW"},{"$f":"'Page 3'!D19","v":200616},0,0,200616,0,0]
["General Plant",{"$f":"'Page 3'!B20","v":"SITUS"},{"$f":"'Page 3'!C20","v":"P"},{"$f":"'Page 3'!D20","v":0},0,0,0,0,0]
["General Plant",{"$f":"'Page 3'!B21","v":"SITUS"},{"$f":"'Page 3'!C21","v":"TD"},{"$f":"'Page 3'!D21","v":273573},0,121927.88475279071,151645.11524720927,0,0]
["Total General Plant",null,null,{"$f":"SUBTOTAL(9,D14:D24)","v":703977},97002,229887.88475279071,352261.11524720927,24826,0]
[]
["Intangible Plant"]
["Customer Service Sys",{"$f":"'Page 5'!A7","v":"CN"},{"$f":"'Page 5'!B7","v":"CUST"},{"$f":"'Page 5'!C7","v":121077},{"$f":"$D28*VLOOKUP(+$C28,$C$46:$I$53,3)","v":0},{"$f":"$D28*VLOOKUP(+$C28,$C$46:$I$53,4)","v":0},{"$f":"$D28*VLOOKUP(+$C28,$C$46:$I$53,5)","v":0},{"$f":"$D28*VLOOKUP(+$C28,$C$46:$I$53,6)","v":121077},{"$f":"$D28*VLOOKUP(+$C28,$C$46:$I$53,7)","v":0}]
["Customer Service Sys",{"$f":"'Page 5'!A8","v":"SE"},{"$f":"'Page 5'!B8","v":"P"},{"$f":"'Page 5'!C8","v":3654},3654,0,0,0,0]
["Washington Hydro",{"$f":"'Page 5'!A9","v":"SG"},{"$f":"'Page 5'!B9","v":"P"},{"$f":"'Page 5'!C9","v":94169},94169,0,0,0,0]
["Utah Hydro",{"$f":"'Page 5'!A10","v":"SG"},{"$f":"'Page 5'!B10","v":"T"},{"$f":"'Page 5'!C10","v":47228},0,47228,0,0,0]
["Colorado Steam-UPD",{"$f":"'Page 5'!A11","v":"SG"},{"$f":"'Page 5'!B11","v":"P"},{"$f":"'Page 5'!C11","v":173622},173622,0,0,0,0]
[null,{"$f":"'Page 5'!A12","v":"SG"},{"$f":"'Page 5'!B12","v":"P"},{"$f":"'Page 5'!C12","v":9790},9790,0,0,0,0]
["Oregon Trans",{"$f":"'Page 5'!A15","v":"SO"},{"$f":"'Page 5'!B15","v":"P"},{"$f":"'Page 5'!C15","v":29195},29195,0,0,0,0]
["Utah Mine",{"$f":"'Page 5'!A16","v":"SO"},{"$f":"'Page 5'!B16","v":"PTD"},{"$f":"'Page 5'!C16","v":302242},153479.24190056635,66301.602954440066,82461.155144993609,0,0]
["Utah",{"$f":"'Page 5'!A17","v":"SO"},{"$f":"'Page 5'!B17","v":"TD"},{"$f":"'Page 5'!C17","v":12686},0,5653.9832000011074,7032.0167999988917,0,0]
["Utah G/O",{"$f":"'Page 5'!A18","v":"SO"},{"$f":"'Page 5'!B18","v":"LABOR"},{"$f":"'Page 5'!C18","v":0},0,0,0,0,0]
["Utah G/O",{"$f":"'Page 5'!A23","v":"SITUS"},{"$f":"'Page 5'!B23","v":"TD"},{"$f":"'Page 5'!C23","v":7514},0,3348.8908848185652,4165.1091151814344,0,0]
["Total Intangible Plant",null,null,{"$f":"SUBTOTAL(9,D28:D38)","v":801177},463909.24190056638,122532.47703925974,93658.281060173933,121077,0]
[]
["Total Gross Plant",null,null,{"$f":"SUBTOTAL(9,D8:D39)","v":23165152.297854383},11797235.021036601,4998114.8763051499,6223899.4005126329,145903,0]
[]
[null,"GP Factor",null,{"$f":"SUM(E43:I43)","v":1},{"$f":"E41/$D41","v":0.50926645632842615},{"$f":"F41/$D41","v":0.21576006978240711},{"$f":"G41/$D41","v":0.26867509095069092},{"$f":"H41/$D41","v":6.2983829384758213E-3},{"$f":"I41/$D41","v":0}]
[]
[]
[null,"Functional Allocators:",null,null,"Prod","Trans","DPW","CUST","DMISC"]
[null,null,"P",{"$f":"SUM(E47:F47)","v":1},{"$f":"'Page 14'!$C$13","v":1},{"$f":"'Page 14'!$D$13","v":0},{"$f":"'Page 14'!$E$13","v":0},{"$f":"'Page 14'!$F$13","v":0},{"$f":"'Page 14'!$G$13","v":0}]
[null,null,"T",{"$f":"SUM(E48:F48)","v":1},{"$f":"'Page 14'!$C$14","v":0},{"$f":"'Page 14'!$D$14","v":1},{"$f":"'Page 14'!$E$14","v":0},{"$f":"'Page 14'!$F$14","v":0},{"$f":"'Page 14'!$G$14","v":0}]
[null,null,"TD",{"$f":"SUM(E49:I49)","v":1},{"$f":"'Page 14'!$C$18","v":0},{"$f":"'Page 14'!$D$18","v":0.44568683588216201},{"$f":"'Page 14'!$E$18","v":0.55431316411783793},{"$f":"'Page 14'!$F$18","v":0},{"$f":"'Page 14'!$G$18","v":0}]
[null,null,"CUST",{"$f":"SUM(E50:I50)","v":1},0,0,0,1,0]
[null,null,"DPW",{"$f":"SUM(E51:I51)","v":1},0,0,1,0,0]
[null,null,"PTD",{"$f":"SUM(E52:I52)","v":1},{"$f":"'Page 14'!$C$16","v":0.50780249568414171},{"$f":"'Page 14'!$D$16","v":0.2193659483276317},{"$f":"'Page 14'!$E$16","v":0.27283155598822667},{"$f":"'Page 14'!$F$16","v":0},{"$f":"'Page 14'!$G$16","v":0}]
[null,null,"LABOR",{"$f":"SUM(E53:I53)","v":1},{"$f":"'Page 10'!F35","v":0.42712904549402431},{"$f":"'Page 10'!G35","v":6.855059317608897E-2},{"$f":"'Page 10'!H35","v":0.35533822131657783},{"$f":"'Page 10'!I35","v":0.14898214001330889},{"$f":"'Page 10'!J35","v":0}]

{"sheet":"Page 5","index":4,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'Page 1'!A1","v":"PacifiCorp"}]
[{"$f":"+'Page 1'!A2","v":"12 Months Ended June 2011"}]
["Intangible Plant"]
["(In 000's)"]
["Alloc."]
["Factor","Funct.","Amount","Production","Transmisssion","DPW","Customer","DMSC"]
["CN","CUST",121077,{"$f":"$C7*VLOOKUP(+$B7,$B$37:$H$44,3)","v":0},{"$f":"$C7*VLOOKUP(+$B7,$B$37:$H$44,4)","v":0},{"$f":"$C7*VLOOKUP(+$B7,$B$37:$H$44,5)","v":0},{"$f":"$C7*VLOOKUP(+$B7,$B$37:$H$44,6)","v":121077},{"$f":"$C7*VLOOKUP(+$B7,$B$37:$H$44,7)","v":0}]
["SE","P",3654,3654,0,0,0,0]
["SG","P",94169,94169,0,0,0,0]
["SG","T",47228,0,47228,0,0,0]
["SG","P",173622,173622,0,0,0,0]
["SG","P",9790,9790,0,0,0,0]
["SO","CUST",7767,0,0,0,7767,0]
["SO","DPW",24000,0,0,24000,0,0]
["SO","P",29195,29195,0,0,0,0]
["SO","PTD",302242,153479.24190056635,66301.602954440066,82461.155144993609,0,0]
["SO","TD",12686,0,5653.9832000011074,7032.0167999988917,0,0]
["SO","LABOR",0,0,0,0,0,0]
["SO","DMSC",0,0,0,0,0,0]
["SITUS","CUST",0,0,0,0,0,0]
["SITUS","PTD",463,235.11255550175761,101.56643407569348,126.32101042254895,0,0]
["SITUS","T",531,0,531,0,0,0]
["SITUS","TD",7514,0,3348.8908848185652,4165.1091151814344,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":324809},277581,47228,0,0,0]
["Total-SITUS",null,{"$f":"SUMIF($A:$A,\"SITUS\",C:C)","v":8508},235.11255550175761,3981.4573188942586,4291.4301256039835,0,0]
["Total-Intangible",null,{"$f":"SUM(C7:C23)","v":833938},464144.35445606813,123165.04347333543,117784.60207059648,128844,0]
["I-DGP FACTOR",null,{"$f":"SUM(D29:H29)","v":{"$error":"#DIV/0!"}},{"$f":"D24/$C$24","v":{"$error":"#DIV/0!"}},{"$f":"E24/$C$24","v":{"$error":"#DIV/0!"}},{"$f":"F24/$C$24","v":{"$error":"#DIV/0!"}},{"$f":"G24/$C$24","v":{"$error":"#DIV/0!"}},{"$f":"H24/$C$24","v":{"$error":"#DIV/0!"}}]
["I-DGU FACTOR",null,{"$f":"SUM(D30:H30)","v":{"$error":"#DIV/0!"}},{"$f":"D25/$C$25","v":{"$error":"#DIV/0!"}},{"$f":"E25/$C$25","v":{"$error":"#DIV/0!"}},{"$f":"F25/$C$25","v":{"$error":"#DIV/0!"}},{"$f":"G25/$C$25","v":{"$error":"#DIV/0!"}},{"$f":"H25/$C$25","v":{"$error":"#DIV/0!"}}]
["I-SG FACTOR",null,{"$f":"SUM(D31:H31)","v":1},{"$f":"D26/$C$26","v":0.85459762506580794},{"$f":"E26/$C$26","v":0.14540237493419209},{"$f":"F26/$C$26","v":0},{"$f":"G26/$C$26","v":0},{"$f":"H26/$C$26","v":0}]
["I-Situs FACTOR",null,{"$f":"SUM(D32:H32)","v":0.99999999999999989},{"$f":"D27/$C$27","v":2.7634291901946124E-2},{"$f":"E27/$C$27","v":0.46796630452447796},{"$f":"F27/$C$27","v":0.50439940357357582},{"$f":"G27/$C$27","v":0},{"$f":"H27/$C$27","v":0}]
["I FACTOR",null,{"$f":"SUM(D33:H33)","v":1},{"$f":"D28/$C$28","v":0.55656937860616518},{"$f":"E28/$C$28","v":0.14769088765991648},{"$f":"F28/$C$28","v":0.14123903943769978},{"$f":"G28/$C$28","v":0.15450069429621865},{"$f":"H28/$C$28","v":0}]
[]
[]
[null,"Functional Allocators:",null,"Prod","Trans","DPW","CUST","DMSC"]
[null,"P",{"$f":"SUM(D37:H37)","v":1},{"$f":"'Page 14'!$C$13","v":1},{"$f":"'Page 14'!$D$13","v":0},{"$f":"'Page 14'!$E$13","v":0},{"$f":"'Page 14'!$F$13","v":0},{"$f":"'Page 14'!$G$13","v":0}]
[null,"T",1,{"$f":"'Page 14'!$C$14","v":0},{"$f":"'Page 14'!$D$14","v":1},{"$f":"'Page 14'!$E$14","v":0},{"$f":"'Page 14'!$F$14","v":0},{"$f":"'Page 14'!$G$14","v":0}]
[null,"TD",1,{"$f":"'Page 14'!$C$18","v":0},{"$f":"'Page 14'!$D$18","v":0.44568683588216201},{"$f":"'Page 14'!$E$18","v":0.55431316411783793},{"$f":"'Page 14'!$F$18","v":0},{"$f":"'Page 14'!$G$18","v":0}]
[null,"CUST",1,0,0,0,1,0]
[null,"DPW",1,0,0,1,0,0]
[null,"PTD",1,{"$f":"'Page 14'!$C$16","v":0.50780249568414171},{"$f":"'Page 14'!$D$16","v":0.2193659483276317},{"$f":"'Page 14'!$E$16","v":0.27283155598822667},{"$f":"'Page 14'!$F$16","v":0},{"$f":"'Page 14'!$G$16","v":0}]
[null,"DMSC",1,{"$f":"'Page 1'!C13","v":0},{"$f":"'Page 1'!D13","v":0},{"$f":"'Page 1'!E13","v":0},{"$f":"'Page 1'!F13","v":0},{"$f":"'Page 1'!G13","v":1}]
[null,"LABOR",{"$f":"SUM(D44:H44)","v":1},{"$f":"'Page 10'!F35","v":0.42712904549402431},{"$f":"'Page 10'!G35","v":6.855059317608897E-2},{"$f":"'Page 10'!H35","v":0.35533822131657783},{"$f":"'Page 10'!I35","v":0.14898214001330889},{"$f":"'Page 10'!J35","v":0}]

{"sheet":"Page 6","index":5,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,0,2,8],[1,0,1,8]]}
[{"$f":"+'Page 1'!A1","v":"PacifiCorp"}]
[{"$f":"+'Page 1'!A2:A2","v":"12 Months Ended June 2011"}]
["Account 456"]
[]
["Main"]
["Account","Factor","Function","Amount","Production","Transmission","DPW","Customer","DMSC"]
["456","OTHER","DMSC",4920,{"$f":"$D7*VLOOKUP(+$C7,$C$29:$I35,3,FALSE)","v":0},{"$f":"$D7*VLOOKUP(+$C7,$C$29:$I35,4,FALSE)","v":0},{"$f":"$D7*VLOOKUP(+$C7,$C$29:$I35,5,FALSE)","v":0},{"$f":"$D7*VLOOKUP(+$C7,$C$29:$I35,6,FALSE)","v":0},{"$f":"$D7*VLOOKUP(+$C7,$C$29:$I35,7,FALSE)","v":4920}]
["456","SE","P",0,{"$f":"$D8*VLOOKUP(+$C8,$C$29:$I36,3,FALSE)","v":0},{"$f":"$D8*VLOOKUP(+$C8,$C$29:$I36,4,FALSE)","v":0},{"$f":"$D8*VLOOKUP(+$C8,$C$29:$I36,5,FALSE)","v":0},{"$f":"$D8*VLOOKUP(+$C8,$C$29:$I36,6,FALSE)","v":0},{"$f":"$D8*VLOOKUP(+$C8,$C$29:$I36,7,FALSE)","v":0}]
["456","SE","T",10745,{"$f":"$D9*VLOOKUP(+$C9,$C$29:$I37,3,FALSE)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$29:$I37,4,FALSE)","v":10745},{"$f":"$D9*VLOOKUP(+$C9,$C$29:$I37,5,FALSE)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$29:$I37,6,FALSE)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$29:$I37,7,FALSE)","v":0}]
["456","SG","P",117830,{"$f":"$D10*VLOOKUP(+$C10,$C$29:$I38,3,FALSE)","v":117830},{"$f":"$D10*VLOOKUP(+$C10,$C$29:$I38,4,FALSE)","v":0},{"$f":"$D10*VLOOKUP(+$C10,$C$29:$I38,5,FALSE)","v":0},{"$f":"$D10*VLOOKUP(+$C10,$C$29:$I38,6,FALSE)","v":0},{"$f":"$D10*VLOOKUP(+$C10,$C$29:$I38,7,FALSE)","v":0}]
["456","SG","T",61301,{"$f":"$D11*VLOOKUP(+$C11,$C$29:$I38,3,FALSE)","v":0},{"$f":"$D11*VLOOKUP(+$C11,$C$29:$I38,4,FALSE)","v":61301},{"$f":"$D11*VLOOKUP(+$C11,$C$29:$I38,5,FALSE)","v":0},{"$f":"$D11*VLOOKUP(+$C11,$C$29:$I38,6,FALSE)","v":0},{"$f":"$D11*VLOOKUP(+$C11,$C$29:$I38,7,FALSE)","v":0}]
["456","SO","DMSC",293,{"$f":"$D12*VLOOKUP(+$C12,$C$29:$I39,3,FALSE)","v":0},{"$f":"$D12*VLOOKUP(+$C12,$C$29:$I39,4,FALSE)","v":0},{"$f":"$D12*VLOOKUP(+$C12,$C$29:$I39,5,FALSE)","v":0},{"$f":"$D12*VLOOKUP(+$C12,$C$29:$I39,6,FALSE)","v":0},{"$f":"$D12*VLOOKUP(+$C12,$C$29:$I39,7,FALSE)","v":293}]
["456","SITUS","DMSC",94223,{"$f":"$D13*VLOOKUP(+$C13,$C$29:$I40,3,FALSE)","v":0},{"$f":"$D13*VLOOKUP(+$C13,$C$29:$I40,4,FALSE)","v":0},{"$f":"$D13*VLOOKUP(+$C13,$C$29:$I40,5,FALSE)","v":0},{"$f":"$D13*VLOOKUP(+$C13,$C$29:$I40,6,FALSE)","v":0},{"$f":"$D13*VLOOKUP(+$C13,$C$29:$I40,7,FALSE)","v":94223}]
["456","SITUS","P",0,{"$f":"$D14*VLOOKUP(+$C14,$C$29:$I41,3,FALSE)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$29:$I41,4,FALSE)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$29:$I41,5,FALSE)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$29:$I41,6,FALSE)","v":0},{"$f":"$D14*VLOOKUP(+$C14,$C$29:$I41,7,FALSE)","v":0}]
["Total Situs Revenues",null,null,{"$f":"SUMIF($B:$B,\"SITUS\",D:D)","v":94223},0,0,0,0,94223]
["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":10745},0,10745,0,0,0]
["Total SG Revenues",null,null,{"$f":"SUMIF($B:$B,\"SG\",D:D)","v":179131},117830,61301,0,0,0]
["Total SO Revenues",null,null,{"$f":"SUMIF($B:$B,\"SO\",D:D)","v":293},0,0,0,0,293]
["Total Operation",null,null,{"$f":"SUM(D7:D14)","v":289312},117830,72046,0,0,99436]
["OTHSITUS",null,null,{"$f":"SUM(E21:I21)","v":1},{"$f":"E15/$D$15","v":0},{"$f":"F15/$D$15","v":0},{"$f":"G15/$D$15","v":0},{"$f":"H15/$D$15","v":0},{"$f":"I15/$D$15","v":1}]
["CN Factor",null,null,0,{"$f":"IF(ISERROR(E16/$D$16),\" \",(E16/$D$16))","v":" "},{"$f":"IF(ISERROR(F16/$D$16),\" \",(F16/$D$16))","v":" "},{"$f":"IF(ISERROR(G16/$D$16),\" \",(G16/$D$16))","v":" "},{"$f":"IF(ISERROR(H16/$D$16),\" \",(H16/$D$16))","v":" "},{"$f":"IF(ISERROR(I16/$D$16),\" \",(I16/$D$16))","v":" "}]
["OTHSE",null,null,1,{"$f":"E17/$D$17","v":0},{"$f":"F17/$D$17","v":1},{"$f":"G17/$D$17","v":0},{"$f":"H17/$D$17","v":0},{"$f":"I17/$D$17","v":0}]
["OTHSG",null,null,1,{"$f":"E18/$D$18","v":0.65778675941071063},{"$f":"F18/$D$18","v":0.34221324058928942},{"$f":"G18/$D$18","v":0},{"$f":"H18/$D$18","v":0},{"$f":"I18/$D$18","v":0}]
["OTHSO",null,null,1,{"$f":"E19/$D$19","v":0},{"$f":"F19/$D$19","v":0},{"$f":"G19/$D$19","v":0},{"$f":"H19/$D$19","v":0},{"$f":"I19/$D$19","v":1}]
["Total Operation Factor",null,null,1,{"$f":"E20/$D$20","v":0.40727657338789958},{"$f":"F20/$D$20","v":0.24902527375290345},{"$f":"G20/$D$20","v":0},{"$f":"H20/$D$20","v":0},{"$f":"I20/$D$20","v":0.34369815285919697}]
[]
[null,null,null,"Total","Prod","Trans","DPW","CUST","DMSC"]
[null,null,"P",{"$f":"SUM(E29:I29)","v":1},{"$f":"'Page 14'!$C$13","v":1},{"$f":"'Page 14'!$D$13","v":0},{"$f":"'Page 14'!$E$13","v":0},{"$f":"'Page 14'!$F$13","v":0},{"$f":"'Page 14'!$G$13","v":0}]
[null,null,"T",{"$f":"SUM(E30:I30)","v":1},{"$f":"'Page 14'!$C$14","v":0},{"$f":"'Page 14'!$D$14","v":1},{"$f":"'Page 14'!$E$14","v":0},{"$f":"'Page 14'!$F$14","v":0},{"$f":"'Page 14'!$G$14","v":0}]
[null,null,"TD",1,{"$f":"'Page 14'!$C$18","v":0},{"$f":"'Page 14'!$D$18","v":0.44568683588216201},{"$f":"'Page 14'!$E$18","v":0.55431316411783793},{"$f":"'Page 14'!$F$18","v":0},{"$f":"'Page 14'!$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":"'Page 14'!$C$16","v":0.50780249568414171},{"$f":"'Page 14'!$D$16","v":0.2193659483276317},{"$f":"'Page 14'!$E$16","v":0.27283155598822667},{"$f":"'Page 14'!$F$16","v":0},{"$f":"'Page 14'!$G$16","v":0}]
[null,null,"DMSC",1,0,0,0,0,1]

{"sheet":"Page 7","index":6,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6]]}
[{"$f":"+'Page 1'!$A$1","v":"PacifiCorp"}]
[{"$f":"+'Page 1'!A2","v":"12 Months Ended June 2011"}]
["Depreciation Expense"]
[]
["Function","Amount","Production","Transmission","DPW","CUST","DMSC"]
["CUST",1706,{"$f":"VLOOKUP($A6,$A$15:$G$21,3,FALSE)*$B6","v":0},{"$f":"VLOOKUP($A6,$A$15:$G$21,4,FALSE)*$B6","v":0},{"$f":"VLOOKUP($A6,$A$15:$G$21,5,FALSE)*$B6","v":0},{"$f":"VLOOKUP($A6,$A$15:$G$21,6,FALSE)*$B6","v":1706},{"$f":"VLOOKUP($A6,$A$15:$G$21,7,FALSE)*$B6","v":0}]
["DPW",143309,{"$f":"VLOOKUP($A7,$A$15:$G$21,3,FALSE)*$B7","v":0},{"$f":"VLOOKUP($A7,$A$15:$G$21,4,FALSE)*$B7","v":0},{"$f":"VLOOKUP($A7,$A$15:$G$21,5,FALSE)*$B7","v":143309},{"$f":"VLOOKUP($A7,$A$15:$G$21,6,FALSE)*$B7","v":0},{"$f":"VLOOKUP($A7,$A$15:$G$21,7,FALSE)*$B7","v":0}]
["P",257395,{"$f":"VLOOKUP($A8,$A$15:$G$21,3,FALSE)*$B8","v":257395},{"$f":"VLOOKUP($A8,$A$15:$G$21,4,FALSE)*$B8","v":0},{"$f":"VLOOKUP($A8,$A$15:$G$21,5,FALSE)*$B8","v":0},{"$f":"VLOOKUP($A8,$A$15:$G$21,6,FALSE)*$B8","v":0},{"$f":"VLOOKUP($A8,$A$15:$G$21,7,FALSE)*$B8","v":0}]
["PTD",14632,{"$f":"VLOOKUP($A9,$A$15:$G$21,3,FALSE)*$B9","v":7430.1661168503615},{"$f":"VLOOKUP($A9,$A$15:$G$21,4,FALSE)*$B9","v":3209.7625559299072},{"$f":"VLOOKUP($A9,$A$15:$G$21,5,FALSE)*$B9","v":3992.0713272197327},{"$f":"VLOOKUP($A9,$A$15:$G$21,6,FALSE)*$B9","v":0},{"$f":"VLOOKUP($A9,$A$15:$G$21,7,FALSE)*$B9","v":0}]
["T",79528,{"$f":"VLOOKUP($A10,$A$15:$G$21,3,FALSE)*$B10","v":0},{"$f":"VLOOKUP($A10,$A$15:$G$21,4,FALSE)*$B10","v":79528},{"$f":"VLOOKUP($A10,$A$15:$G$21,5,FALSE)*$B10","v":0},{"$f":"VLOOKUP($A10,$A$15:$G$21,6,FALSE)*$B10","v":0},{"$f":"VLOOKUP($A10,$A$15:$G$21,7,FALSE)*$B10","v":0}]
["Book Depreciation",{"$f":"SUM(B6:B10)","v":496570},264825.16611685033,82737.762555929905,147301.07132721975,1706,0]
["BookDepr Factor",{"$f":"B11/$B11","v":1},0.53330883081307834,0.16661852821541756,0.29663707297504832,3.4355679964556858E-3,0]
[]
[]
["P",{"$f":"'Page 14'!$B$13","v":1},{"$f":"'Page 14'!$C$13","v":1},{"$f":"'Page 14'!$D$13","v":0},{"$f":"'Page 14'!$E$13","v":0},{"$f":"'Page 14'!$F$13","v":0},{"$f":"'Page 14'!$G$13","v":0}]
["T",{"$f":"'Page 14'!$B$14","v":1},{"$f":"'Page 14'!$C$14","v":0},{"$f":"'Page 14'!$D$14","v":1},{"$f":"'Page 14'!$E$14","v":0},{"$f":"'Page 14'!$F$14","v":0},{"$f":"'Page 14'!$G$14","v":0}]
["DPW",{"$f":"'Page 14'!$B$15","v":1},{"$f":"'Page 14'!$C$15","v":0},{"$f":"'Page 14'!$D$15","v":0},{"$f":"'Page 14'!$E$15","v":1},{"$f":"'Page 14'!$F$15","v":0},{"$f":"'Page 14'!$G$15","v":0}]
["CUST",{"$f":"'Page 14'!$B$15","v":1},0,0,0,1,0]
["PTD",{"$f":"'Page 14'!$B$16","v":1},{"$f":"'Page 14'!$C$16","v":0.50780249568414171},{"$f":"'Page 14'!$D$16","v":0.2193659483276317},{"$f":"'Page 14'!$E$16","v":0.27283155598822667},{"$f":"'Page 14'!$F$16","v":0},{"$f":"'Page 14'!$G$16","v":0}]
["TD",{"$f":"'Page 14'!$B$18","v":1},{"$f":"'Page 14'!$C$18","v":0},{"$f":"'Page 14'!$D$18","v":0.44568683588216201},{"$f":"'Page 14'!$E$18","v":0.55431316411783793},{"$f":"'Page 14'!$F$18","v":0},{"$f":"'Page 14'!$G$18","v":0}]
["G",{"$f":"'Page 3'!$D$38","v":1},{"$f":"'Page 3'!$E$38","v":0.23284244722796199},{"$f":"'Page 3'!$F$38","v":0.2990202443759668},{"$f":"'Page 3'!$G$38","v":0.44193116167922869},{"$f":"'Page 3'!$H$38","v":2.6206146716842512E-2},{"$f":"'Page 3'!$I$38","v":0}]

{"sheet":"Page 8","index":7,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"+'Page 1'!A1","v":"PacifiCorp"}]
[null,{"$f":"+'Page 1'!A2","v":"12 Months Ended June 2011"}]
[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",-536,{"$f":"VLOOKUP($D7,'Page 10'!$D$30:$J$41,3,FALSE)*$E7","v":-228.94116838479704},{"$f":"VLOOKUP($D7,'Page 10'!$D$30:$J$41,4,FALSE)*$E7","v":-36.743117942383691},{"$f":"VLOOKUP($D7,'Page 10'!$D$30:$J$41,5,FALSE)*$E7","v":-190.46128662568572},{"$f":"VLOOKUP($D7,'Page 10'!$D$30:$J$41,6,FALSE)*$E7","v":-79.854427047133569},{"$f":"VLOOKUP($D7,'Page 10'!$D$30:$J$41,7,FALSE)*$E7","v":0}]
[{"$f":"IF(C8=\"\",\"\",B8&\"-\"&C8)","v":"SCHMAP-SE"},"SCHMAP","SE","P",130,{"$f":"VLOOKUP($D8,'Page 10'!$D$30:$J$41,3,FALSE)*$E8","v":130},{"$f":"VLOOKUP($D8,'Page 10'!$D$30:$J$41,4,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,'Page 10'!$D$30:$J$41,5,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,'Page 10'!$D$30:$J$41,6,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,'Page 10'!$D$30:$J$41,7,FALSE)*$E8","v":0}]
[{"$f":"IF(C9=\"\",\"\",B9&\"-\"&C9)","v":"SCHMAP-OTHER"},"SCHMAP","OTHER","P",29,{"$f":"VLOOKUP($D9,'Page 10'!$D$30:$J$41,3,FALSE)*$E9","v":29},{"$f":"VLOOKUP($D9,'Page 10'!$D$30:$J$41,4,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,'Page 10'!$D$30:$J$41,5,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,'Page 10'!$D$30:$J$41,6,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,'Page 10'!$D$30:$J$41,7,FALSE)*$E9","v":0}]
[{"$f":"IF(C10=\"\",\"\",B10&\"-\"&C10)","v":"SCHMAP-SO"},"SCHMAP","SO","LABOR",13204,{"$f":"VLOOKUP($D10,'Page 10'!$D$30:$J$41,3,FALSE)*$E10","v":5639.8119167030973},{"$f":"VLOOKUP($D10,'Page 10'!$D$30:$J$41,4,FALSE)*$E10","v":905.1420322970788},{"$f":"VLOOKUP($D10,'Page 10'!$D$30:$J$41,5,FALSE)*$E10","v":4691.8858742640932},{"$f":"VLOOKUP($D10,'Page 10'!$D$30:$J$41,6,FALSE)*$E10","v":1967.1601767357306},{"$f":"VLOOKUP($D10,'Page 10'!$D$30:$J$41,7,FALSE)*$E10","v":0}]
[{"$f":"IF(C11=\"\",\"\",B11&\"-\"&C11)","v":"SCHMAP-SO"},"SCHMAP","SO","PTD",1002,{"$f":"VLOOKUP($D11,'Page 10'!$D$30:$J$41,3,FALSE)*$E11","v":508.81810067550998},{"$f":"VLOOKUP($D11,'Page 10'!$D$30:$J$41,4,FALSE)*$E11","v":219.80468022428695},{"$f":"VLOOKUP($D11,'Page 10'!$D$30:$J$41,5,FALSE)*$E11","v":273.37721910020315},{"$f":"VLOOKUP($D11,'Page 10'!$D$30:$J$41,6,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,'Page 10'!$D$30:$J$41,7,FALSE)*$E11","v":0}]
[]
[{"$f":"IF(C13=\"\",\"\",B13&\"-\"&C13)","v":""},"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"SCHMAP-SO\",E:E)","v":14206},6148.6300173786076,1124.9467125213657,4965.2630933642968,1967.1601767357306,0]
[{"$f":"IF(C14=\"\",\"\",B14&\"-\"&C14)","v":""},"Total SCHMAP",null,null,{"$f":"SUMIF($B:$B,\"SCHMAP\",E:E)","v":13829},6078.688848993811,1088.2035945789821,4774.801806738611,1887.305749688597,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":0.43281923253404248},7.9188139695999277E-2,0.34951873105478648,0.1384738967151718,0]
[{"$f":"IF(C16=\"\",\"\",B16&\"-\"&C16)","v":""},"SCHMAP FACTOR",null,null,{"$f":"SUM(F16:J16)","v":1},0.43956098409095457,7.8689969960154899E-2,0.34527455396186357,0.13647449198702705,0]
[]
[{"$f":"IF(C18=\"\",\"\",B18&\"-\"&C18)","v":"SCHMAT-CIAC"},"SCHMAT","CIAC","DPW",27829,{"$f":"VLOOKUP($D18,'Page 10'!$D$30:$J$41,3,FALSE)*$E18","v":0},{"$f":"VLOOKUP($D18,'Page 10'!$D$30:$J$41,4,FALSE)*$E18","v":0},{"$f":"VLOOKUP($D18,'Page 10'!$D$30:$J$41,5,FALSE)*$E18","v":27829},{"$f":"VLOOKUP($D18,'Page 10'!$D$30:$J$41,6,FALSE)*$E18","v":0},{"$f":"VLOOKUP($D18,'Page 10'!$D$30:$J$41,7,FALSE)*$E18","v":0}]
["SCHMAT-BADDEBT","SCHMAT","BADDEBT","CUST",1315,{"$f":"VLOOKUP($D19,'Page 10'!$D$30:$J$41,3,FALSE)*$E19","v":0},{"$f":"VLOOKUP($D19,'Page 10'!$D$30:$J$41,4,FALSE)*$E19","v":0},{"$f":"VLOOKUP($D19,'Page 10'!$D$30:$J$41,5,FALSE)*$E19","v":0},{"$f":"VLOOKUP($D19,'Page 10'!$D$30:$J$41,6,FALSE)*$E19","v":1315},{"$f":"VLOOKUP($D19,'Page 10'!$D$30:$J$41,7,FALSE)*$E19","v":0}]
["SCHMAT-SCHMDEXP","SCHMAT","SCHMDEXP","GP",568694,{"$f":"VLOOKUP($D20,'Page 10'!$D$30:$J$41,3,FALSE)*$E20","v":289616.778115238},{"$f":"VLOOKUP($D20,'Page 10'!$D$30:$J$41,4,FALSE)*$E20","v":122701.45712483623},{"$f":"VLOOKUP($D20,'Page 10'!$D$30:$J$41,5,FALSE)*$E20","v":152793.91217311221},{"$f":"VLOOKUP($D20,'Page 10'!$D$30:$J$41,6,FALSE)*$E20","v":3581.8525868135689},{"$f":"VLOOKUP($D20,'Page 10'!$D$30:$J$41,7,FALSE)*$E20","v":0}]
["SCHMAT-SE","SCHMAT","SE","LABOR",17,{"$f":"VLOOKUP($D21,'Page 10'!$D$30:$J$41,3,FALSE)*$E21","v":7.2611937733984133},{"$f":"VLOOKUP($D21,'Page 10'!$D$30:$J$41,4,FALSE)*$E21","v":1.1653600839935125},{"$f":"VLOOKUP($D21,'Page 10'!$D$30:$J$41,5,FALSE)*$E21","v":6.0407497623818234},{"$f":"VLOOKUP($D21,'Page 10'!$D$30:$J$41,6,FALSE)*$E21","v":2.532696380226251},{"$f":"VLOOKUP($D21,'Page 10'!$D$30:$J$41,7,FALSE)*$E21","v":0}]
["SCHMAT-SE","SCHMAT","SE","P",32744,{"$f":"VLOOKUP($D22,'Page 10'!$D$30:$J$41,3,FALSE)*$E22","v":32744},{"$f":"VLOOKUP($D22,'Page 10'!$D$30:$J$41,4,FALSE)*$E22","v":0},{"$f":"VLOOKUP($D22,'Page 10'!$D$30:$J$41,5,FALSE)*$E22","v":0},{"$f":"VLOOKUP($D22,'Page 10'!$D$30:$J$41,6,FALSE)*$E22","v":0},{"$f":"VLOOKUP($D22,'Page 10'!$D$30:$J$41,7,FALSE)*$E22","v":0}]
["SCHMAT-SG","SCHMAT","SG","DPW",1,{"$f":"VLOOKUP($D23,'Page 10'!$D$30:$J$41,3,FALSE)*$E23","v":0},{"$f":"VLOOKUP($D23,'Page 10'!$D$30:$J$41,4,FALSE)*$E23","v":0},{"$f":"VLOOKUP($D23,'Page 10'!$D$30:$J$41,5,FALSE)*$E23","v":1},{"$f":"VLOOKUP($D23,'Page 10'!$D$30:$J$41,6,FALSE)*$E23","v":0},{"$f":"VLOOKUP($D23,'Page 10'!$D$30:$J$41,7,FALSE)*$E23","v":0}]
["SCHMAT-SG","SCHMAT","SG","P",16463,{"$f":"VLOOKUP($D24,'Page 10'!$D$30:$J$41,3,FALSE)*$E24","v":16463},{"$f":"VLOOKUP($D24,'Page 10'!$D$30:$J$41,4,FALSE)*$E24","v":0},{"$f":"VLOOKUP($D24,'Page 10'!$D$30:$J$41,5,FALSE)*$E24","v":0},{"$f":"VLOOKUP($D24,'Page 10'!$D$30:$J$41,6,FALSE)*$E24","v":0},{"$f":"VLOOKUP($D24,'Page 10'!$D$30:$J$41,7,FALSE)*$E24","v":0}]
["SCHMAT-SG","SCHMAT","SG","T",419,{"$f":"VLOOKUP($D25,'Page 10'!$D$30:$J$41,3,FALSE)*$E25","v":0},{"$f":"VLOOKUP($D25,'Page 10'!$D$30:$J$41,4,FALSE)*$E25","v":419},{"$f":"VLOOKUP($D25,'Page 10'!$D$30:$J$41,5,FALSE)*$E25","v":0},{"$f":"VLOOKUP($D25,'Page 10'!$D$30:$J$41,6,FALSE)*$E25","v":0},{"$f":"VLOOKUP($D25,'Page 10'!$D$30:$J$41,7,FALSE)*$E25","v":0}]
["SCHMAT-SGCT","SCHMAT","SGCT","P",1122,{"$f":"VLOOKUP($D26,'Page 10'!$D$30:$J$41,3,FALSE)*$E26","v":1122},{"$f":"VLOOKUP($D26,'Page 10'!$D$30:$J$41,4,FALSE)*$E26","v":0},{"$f":"VLOOKUP($D26,'Page 10'!$D$30:$J$41,5,FALSE)*$E26","v":0},{"$f":"VLOOKUP($D26,'Page 10'!$D$30:$J$41,6,FALSE)*$E26","v":0},{"$f":"VLOOKUP($D26,'Page 10'!$D$30:$J$41,7,FALSE)*$E26","v":0}]
["SCHMAT-SNP","SCHMAT","SNP","GP",2331,{"$f":"VLOOKUP($D27,'Page 10'!$D$30:$J$41,3,FALSE)*$E27","v":1187.1001097015615},{"$f":"VLOOKUP($D27,'Page 10'!$D$30:$J$41,4,FALSE)*$E27","v":502.936722662791},{"$f":"VLOOKUP($D27,'Page 10'!$D$30:$J$41,5,FALSE)*$E27","v":626.28163700606058},{"$f":"VLOOKUP($D27,'Page 10'!$D$30:$J$41,6,FALSE)*$E27","v":14.68153062958714},{"$f":"VLOOKUP($D27,'Page 10'!$D$30:$J$41,7,FALSE)*$E27","v":0}]
["SCHMAT-SNP","SCHMAT","SNP","PTD",48346,{"$f":"VLOOKUP($D28,'Page 10'!$D$30:$J$41,3,FALSE)*$E28","v":24550.219456345516},{"$f":"VLOOKUP($D28,'Page 10'!$D$30:$J$41,4,FALSE)*$E28","v":10605.466137847683},{"$f":"VLOOKUP($D28,'Page 10'!$D$30:$J$41,5,FALSE)*$E28","v":13190.314405806806},{"$f":"VLOOKUP($D28,'Page 10'!$D$30:$J$41,6,FALSE)*$E28","v":0},{"$f":"VLOOKUP($D28,'Page 10'!$D$30:$J$41,7,FALSE)*$E28","v":0}]
["SCHMAT-SNPD","SCHMAT","SNPD","DPW",9587,{"$f":"VLOOKUP($D29,'Page 10'!$D$30:$J$41,3,FALSE)*$E29","v":0},{"$f":"VLOOKUP($D29,'Page 10'!$D$30:$J$41,4,FALSE)*$E29","v":0},{"$f":"VLOOKUP($D29,'Page 10'!$D$30:$J$41,5,FALSE)*$E29","v":9587},{"$f":"VLOOKUP($D29,'Page 10'!$D$30:$J$41,6,FALSE)*$E29","v":0},{"$f":"VLOOKUP($D29,'Page 10'!$D$30:$J$41,7,FALSE)*$E29","v":0}]
["SCHMAT-SO","SCHMAT","SO","DMSC",0,{"$f":"VLOOKUP($D30,'Page 10'!$D$30:$J$41,3,FALSE)*$E30","v":0},{"$f":"VLOOKUP($D30,'Page 10'!$D$30:$J$41,4,FALSE)*$E30","v":0},{"$f":"VLOOKUP($D30,'Page 10'!$D$30:$J$41,5,FALSE)*$E30","v":0},{"$f":"VLOOKUP($D30,'Page 10'!$D$30:$J$41,6,FALSE)*$E30","v":0},{"$f":"VLOOKUP($D30,'Page 10'!$D$30:$J$41,7,FALSE)*$E30","v":0}]
["SCHMAT-SO","SCHMAT","SO","LABOR",15866,{"$f":"VLOOKUP($D31,'Page 10'!$D$30:$J$41,3,FALSE)*$E31","v":6776.8294358081894},{"$f":"VLOOKUP($D31,'Page 10'!$D$30:$J$41,4,FALSE)*$E31","v":1087.6237113318275},{"$f":"VLOOKUP($D31,'Page 10'!$D$30:$J$41,5,FALSE)*$E31","v":5637.7962194088241},{"$f":"VLOOKUP($D31,'Page 10'!$D$30:$J$41,6,FALSE)*$E31","v":2363.750633451159},{"$f":"VLOOKUP($D31,'Page 10'!$D$30:$J$41,7,FALSE)*$E31","v":0}]
["SCHMAT-SO","SCHMAT","SO","PTD",29415,{"$f":"VLOOKUP($D32,'Page 10'!$D$30:$J$41,3,FALSE)*$E32","v":14937.010410549028},{"$f":"VLOOKUP($D32,'Page 10'!$D$30:$J$41,4,FALSE)*$E32","v":6452.6493700572864},{"$f":"VLOOKUP($D32,'Page 10'!$D$30:$J$41,5,FALSE)*$E32","v":8025.3402193936872},{"$f":"VLOOKUP($D32,'Page 10'!$D$30:$J$41,6,FALSE)*$E32","v":0},{"$f":"VLOOKUP($D32,'Page 10'!$D$30:$J$41,7,FALSE)*$E32","v":0}]
["SCHMAT-OTHER","SCHMAT","OTHER","DMSC",1150,{"$f":"VLOOKUP($D33,'Page 10'!$D$30:$J$41,3,FALSE)*$E33","v":0},{"$f":"VLOOKUP($D33,'Page 10'!$D$30:$J$41,4,FALSE)*$E33","v":0},{"$f":"VLOOKUP($D33,'Page 10'!$D$30:$J$41,5,FALSE)*$E33","v":0},{"$f":"VLOOKUP($D33,'Page 10'!$D$30:$J$41,6,FALSE)*$E33","v":0},{"$f":"VLOOKUP($D33,'Page 10'!$D$30:$J$41,7,FALSE)*$E33","v":1150}]
["SCHMAT-OTHER","SCHMAT","OTHER","GP",795,{"$f":"VLOOKUP($D34,'Page 10'!$D$30:$J$41,3,FALSE)*$E34","v":404.86683278109876},{"$f":"VLOOKUP($D34,'Page 10'!$D$30:$J$41,4,FALSE)*$E34","v":171.52925547701366},{"$f":"VLOOKUP($D34,'Page 10'!$D$30:$J$41,5,FALSE)*$E34","v":213.59669730579927},{"$f":"VLOOKUP($D34,'Page 10'!$D$30:$J$41,6,FALSE)*$E34","v":5.0072144360882778},{"$f":"VLOOKUP($D34,'Page 10'!$D$30:$J$41,7,FALSE)*$E34","v":0}]
["SCHMAT-OTHER","SCHMAT","OTHER","P",20091,{"$f":"VLOOKUP($D35,'Page 10'!$D$30:$J$41,3,FALSE)*$E35","v":20091},{"$f":"VLOOKUP($D35,'Page 10'!$D$30:$J$41,4,FALSE)*$E35","v":0},{"$f":"VLOOKUP($D35,'Page 10'!$D$30:$J$41,5,FALSE)*$E35","v":0},{"$f":"VLOOKUP($D35,'Page 10'!$D$30:$J$41,6,FALSE)*$E35","v":0},{"$f":"VLOOKUP($D35,'Page 10'!$D$30:$J$41,7,FALSE)*$E35","v":0}]
["SCHMAT-OTHER","SCHMAT","OTHER","PTD",8675,{"$f":"VLOOKUP($D36,'Page 10'!$D$30:$J$41,3,FALSE)*$E36","v":4405.186650059929},{"$f":"VLOOKUP($D36,'Page 10'!$D$30:$J$41,4,FALSE)*$E36","v":1902.999601742205},{"$f":"VLOOKUP($D36,'Page 10'!$D$30:$J$41,5,FALSE)*$E36","v":2366.8137481978665},{"$f":"VLOOKUP($D36,'Page 10'!$D$30:$J$41,6,FALSE)*$E36","v":0},{"$f":"VLOOKUP($D36,'Page 10'!$D$30:$J$41,7,FALSE)*$E36","v":0}]
["SCHMAT-TROJD","SCHMAT","TROJD","P",1902,{"$f":"VLOOKUP($D37,'Page 10'!$D$30:$J$41,3,FALSE)*$E37","v":1902},{"$f":"VLOOKUP($D37,'Page 10'!$D$30:$J$41,4,FALSE)*$E37","v":0},{"$f":"VLOOKUP($D37,'Page 10'!$D$30:$J$41,5,FALSE)*$E37","v":0},{"$f":"VLOOKUP($D37,'Page 10'!$D$30:$J$41,6,FALSE)*$E37","v":0},{"$f":"VLOOKUP($D37,'Page 10'!$D$30:$J$41,7,FALSE)*$E37","v":0}]
["SCHMAT-SITUS","SCHMAT","SITUS","DMSC",2742,{"$f":"VLOOKUP($D38,'Page 10'!$D$30:$J$41,3,FALSE)*$E38","v":0},{"$f":"VLOOKUP($D38,'Page 10'!$D$30:$J$41,4,FALSE)*$E38","v":0},{"$f":"VLOOKUP($D38,'Page 10'!$D$30:$J$41,5,FALSE)*$E38","v":0},{"$f":"VLOOKUP($D38,'Page 10'!$D$30:$J$41,6,FALSE)*$E38","v":0},{"$f":"VLOOKUP($D38,'Page 10'!$D$30:$J$41,7,FALSE)*$E38","v":2742}]
["SCHMAT-SITUS","SCHMAT","SITUS","DPW",2868,{"$f":"VLOOKUP($D39,'Page 10'!$D$30:$J$41,3,FALSE)*$E39","v":0},{"$f":"VLOOKUP($D39,'Page 10'!$D$30:$J$41,4,FALSE)*$E39","v":0},{"$f":"VLOOKUP($D39,'Page 10'!$D$30:$J$41,5,FALSE)*$E39","v":2868},{"$f":"VLOOKUP($D39,'Page 10'!$D$30:$J$41,6,FALSE)*$E39","v":0},{"$f":"VLOOKUP($D39,'Page 10'!$D$30:$J$41,7,FALSE)*$E39","v":0}]
["SCHMAT-SITUS","SCHMAT","SITUS","ESD",58,{"$f":"VLOOKUP($D40,'Page 10'!$D$30:$J$41,3,FALSE)*$E40","v":17.399999999999999},{"$f":"VLOOKUP($D40,'Page 10'!$D$30:$J$41,4,FALSE)*$E40","v":5.8000000000000007},{"$f":"VLOOKUP($D40,'Page 10'!$D$30:$J$41,5,FALSE)*$E40","v":34.799999999999997},{"$f":"VLOOKUP($D40,'Page 10'!$D$30:$J$41,6,FALSE)*$E40","v":0},{"$f":"VLOOKUP($D40,'Page 10'!$D$30:$J$41,7,FALSE)*$E40","v":0}]
["SCHMAT-SITUS","SCHMAT","SITUS","GP",643,{"$f":"VLOOKUP($D41,'Page 10'!$D$30:$J$41,3,FALSE)*$E41","v":327.45833141917802},{"$f":"VLOOKUP($D41,'Page 10'!$D$30:$J$41,4,FALSE)*$E41","v":138.73372487008777},{"$f":"VLOOKUP($D41,'Page 10'!$D$30:$J$41,5,FALSE)*$E41","v":172.75808348129425},{"$f":"VLOOKUP($D41,'Page 10'!$D$30:$J$41,6,FALSE)*$E41","v":4.0498602294399531},{"$f":"VLOOKUP($D41,'Page 10'!$D$30:$J$41,7,FALSE)*$E41","v":0}]
["SCHMAT-SITUS","SCHMAT","SITUS","LABOR",5131,{"$f":"VLOOKUP($D42,'Page 10'!$D$30:$J$41,3,FALSE)*$E42","v":2191.5991324298388},{"$f":"VLOOKUP($D42,'Page 10'!$D$30:$J$41,4,FALSE)*$E42","v":351.7330935865125},{"$f":"VLOOKUP($D42,'Page 10'!$D$30:$J$41,5,FALSE)*$E42","v":1823.2404135753609},{"$f":"VLOOKUP($D42,'Page 10'!$D$30:$J$41,6,FALSE)*$E42","v":764.42736040828788},{"$f":"VLOOKUP($D42,'Page 10'!$D$30:$J$41,7,FALSE)*$E42","v":0}]
["SCHMAT-SITUS","SCHMAT","SITUS","P",9475,{"$f":"VLOOKUP($D43,'Page 10'!$D$30:$J$41,3,FALSE)*$E43","v":9475},{"$f":"VLOOKUP($D43,'Page 10'!$D$30:$J$41,4,FALSE)*$E43","v":0},{"$f":"VLOOKUP($D43,'Page 10'!$D$30:$J$41,5,FALSE)*$E43","v":0},{"$f":"VLOOKUP($D43,'Page 10'!$D$30:$J$41,6,FALSE)*$E43","v":0},{"$f":"VLOOKUP($D43,'Page 10'!$D$30:$J$41,7,FALSE)*$E43","v":0}]
["SCHMAT-SITUS","SCHMAT","SITUS","PTD",49,{"$f":"VLOOKUP($D44,'Page 10'!$D$30:$J$41,3,FALSE)*$E44","v":24.882322288522943},{"$f":"VLOOKUP($D44,'Page 10'!$D$30:$J$41,4,FALSE)*$E44","v":10.748931468053954},{"$f":"VLOOKUP($D44,'Page 10'!$D$30:$J$41,5,FALSE)*$E44","v":13.368746243423107},{"$f":"VLOOKUP($D44,'Page 10'!$D$30:$J$41,6,FALSE)*$E44","v":0},{"$f":"VLOOKUP($D44,'Page 10'!$D$30:$J$41,7,FALSE)*$E44","v":0}]
["SCHMAT-SITUS","SCHMAT","SITUS","T",462,{"$f":"VLOOKUP($D45,'Page 10'!$D$30:$J$41,3,FALSE)*$E45","v":0},{"$f":"VLOOKUP($D45,'Page 10'!$D$30:$J$41,4,FALSE)*$E45","v":462},{"$f":"VLOOKUP($D45,'Page 10'!$D$30:$J$41,5,FALSE)*$E45","v":0},{"$f":"VLOOKUP($D45,'Page 10'!$D$30:$J$41,6,FALSE)*$E45","v":0},{"$f":"VLOOKUP($D45,'Page 10'!$D$30:$J$41,7,FALSE)*$E45","v":0}]
[null,"Total-SE",null,null,{"$f":"SUMIF($A:$A,\"SCHMAT-SE\",E:E)","v":32761},32751.2611937734,1.1653600839935125,6.0407497623818234,2.532696380226251,0]
[{"$f":"IF(C47=\"\",\"\",B47&\"-\"&C47)","v":""},"Total-SNP",null,null,{"$f":"SUMIF($A:$A,\"SCHMAT-SNP\",E:E)","v":50677},25737.319566047077,11108.402860510474,13816.596042812867,14.68153062958714,0]
[{"$f":"IF(C48=\"\",\"\",B48&\"-\"&C48)","v":""},"Total-SITUS",null,null,{"$f":"SUMIF($A:$A,\"SCHMAT-SITUS\",E:E)","v":21428},12036.339786137538,969.0157499246543,4912.1672433000786,768.47722063772778,2742]
[null,"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"SCHMAT-SO\",E:E)","v":45281},21713.839846357216,7540.2730813891139,13663.13643880251,2363.750633451159,0]
[{"$f":"IF(C50=\"\",\"\",B50&\"-\"&C50)","v":""},"Total-SCHMAT",null,null,{"$f":"SUMIF($B:$B,\"SCHMAT\",E:E)","v":808190},426243.59199039434,144813.84303396367,225189.2630932937,8051.301882348359,3892]
[null,"SCHMAT-SE",null,null,{"$f":"SUM(F51:J51)","v":1},{"$f":"IF(ISERROR(F46/$E46),\" \",(F46/$E46))","v":0.99970273171677915},3.5571566313406565E-5,1.8438844242794246E-4,7.7308274479602295E-5,0]
[{"$f":"IF(C52=\"\",\"\",B52&\"-\"&C52)","v":""},"SCHMAT-SNP",null,null,{"$f":"SUM(F52:J52)","v":1},0.50786983377167305,0.21920008801843979,0.2726403702431649,2.8970796672232258E-4,0]
[{"$f":"IF(C53=\"\",\"\",B53&\"-\"&C53)","v":""},"SCHMAT-SITUS",null,null,{"$f":"SUM(F53:J53)","v":1},0.56171083564203561,4.5221940914908262E-2,0.22924058443625531,3.5863226649137943E-2,0.12796341235766287]
[null,"SCHMAT-SO",null,null,{"$f":"SUM(F54:J54)","v":0.99999999999999989},0.47953534255774422,0.16652178797705691,0.30174104897865572,5.2201820486543121E-2,0]
[{"$f":"IF(C55=\"\",\"\",B55&\"-\"&C55)","v":""},"SCHMAT FACTOR",null,null,{"$f":"SUM(F55:J55)","v":1},0.52740517946323806,0.17918291866264574,0.27863406265023533,9.9621399452459927E-3,4.8156992786349741E-3]

{"sheet":"Page 9","index":8,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"+'Page 1'!A1","v":"PacifiCorp"}]
[null,{"$f":"+'Page 1'!A2","v":"12 Months Ended June 2011"}]
[null,"Schedule M"]
[null,"Primary","PITA"]
[null,"Account","Factor","Function","Amount","Production","Transmission","Poles & Wires","Customers","Miscellaneous"]
[{"$f":"IF(C6=\"\",\"\",B6&\"-\"&C6)","v":"SCHMAF-DGP"},"SCHMAF","DGP","P",0,{"$f":"VLOOKUP($D6,'Page 10'!$D$30:$J$41,3,FALSE)*$E6","v":0},{"$f":"VLOOKUP($D6,'Page 10'!$D$30:$J$41,4,FALSE)*$E6","v":0},{"$f":"VLOOKUP($D6,'Page 10'!$D$30:$J$41,5,FALSE)*$E6","v":0},{"$f":"VLOOKUP($D6,'Page 10'!$D$30:$J$41,6,FALSE)*$E6","v":0},{"$f":"VLOOKUP($D6,'Page 10'!$D$30:$J$41,7,FALSE)*$E6","v":0}]
[{"$f":"IF(C7=\"\",\"\",B7&\"-\"&C7)","v":"SCHMAF-TROJP"},"SCHMAF","TROJP","P",0,{"$f":"VLOOKUP($D7,'Page 10'!$D$30:$J$41,3,FALSE)*$E7","v":0},{"$f":"VLOOKUP($D7,'Page 10'!$D$30:$J$41,4,FALSE)*$E7","v":0},{"$f":"VLOOKUP($D7,'Page 10'!$D$30:$J$41,5,FALSE)*$E7","v":0},{"$f":"VLOOKUP($D7,'Page 10'!$D$30:$J$41,6,FALSE)*$E7","v":0},{"$f":"VLOOKUP($D7,'Page 10'!$D$30:$J$41,7,FALSE)*$E7","v":0}]
[{"$f":"IF(C8=\"\",\"\",B8&\"-\"&C8)","v":""},"Total-SCHMAF",null,null,{"$f":"SUMIF($A$6:$A$59,\"SCHMAF\",E$6:E$59)","v":0},0,0,0,0,0]
[{"$f":"IF(C9=\"\",\"\",B9&\"-\"&C9)","v":""},"SCHMAF FACTOR",null,null,{"$f":"SUM(F9:J9)","v":0},{"$f":"IF(ISERROR(F8/$E8),\" \",(F8/$E8))","v":" "},{"$f":"IF(ISERROR(G8/$E8),\" \",(G8/$E8))","v":" "},{"$f":"IF(ISERROR(H8/$E8),\" \",(H8/$E8))","v":" "},{"$f":"IF(ISERROR(I8/$E8),\" \",(I8/$E8))","v":" "},{"$f":"IF(ISERROR(J8/$E8),\" \",(J8/$E8))","v":" "}]
[]
[{"$f":"IF(C11=\"\",\"\",B11&\"-\"&C11)","v":""},"Total-SCHMA",null,null,{"$f":"SUM(E8,'Page 8'!E50,'Page 8'!E14)","v":822019},{"$f":"SUM(F8,'Page 8'!F50,'Page 8'!F14)","v":432322.28083938814},{"$f":"SUM(G8,'Page 8'!G50,'Page 8'!G14)","v":145902.04662854265},{"$f":"SUM(H8,'Page 8'!H50,'Page 8'!H14)","v":229964.0649000323},{"$f":"SUM(I8,'Page 8'!I50,'Page 8'!I14)","v":9938.6076320369557},{"$f":"SUM(J8,'Page 8'!J50,'Page 8'!J14)","v":3892}]
[{"$f":"IF(C12=\"\",\"\",B12&\"-\"&C12)","v":""},"SCHMA FACTOR",null,null,{"$f":"SUM(F12:J12)","v":1.0000000000000002},{"$f":"IF(ISERROR(F11/$E11),\" \",(F11/$E11))","v":0.52592735793137158},{"$f":"IF(ISERROR(G11/$E11),\" \",(G11/$E11))","v":0.17749230447050818},{"$f":"IF(ISERROR(H11/$E11),\" \",(H11/$E11))","v":0.2797551697710543},{"$f":"IF(ISERROR(I11/$E11),\" \",(I11/$E11))","v":1.2090484078880118E-2},{"$f":"IF(ISERROR(J11/$E11),\" \",(J11/$E11))","v":4.7346837481858691E-3}]
[]
[{"$f":"IF(C14=\"\",\"\",B14&\"-\"&C14)","v":""},"DEDUCTIONS"]
["SCHMDP-SCHMDEXP","SCHMDP","SCHMDEXP","LABOR",109,{"$f":"VLOOKUP($D15,'Page 10'!$D$30:$J$41,3,FALSE)*$E15","v":46.557065958848646},{"$f":"VLOOKUP($D15,'Page 10'!$D$30:$J$41,4,FALSE)*$E15","v":7.4720146561936973},{"$f":"VLOOKUP($D15,'Page 10'!$D$30:$J$41,5,FALSE)*$E15","v":38.731866123506983},{"$f":"VLOOKUP($D15,'Page 10'!$D$30:$J$41,6,FALSE)*$E15","v":16.239053261450671},{"$f":"VLOOKUP($D15,'Page 10'!$D$30:$J$41,7,FALSE)*$E15","v":0}]
["SCHMDP-SE","SCHMDP","SE","P",574,{"$f":"VLOOKUP($D16,'Page 10'!$D$30:$J$41,3,FALSE)*$E16","v":574},{"$f":"VLOOKUP($D16,'Page 10'!$D$30:$J$41,4,FALSE)*$E16","v":0},{"$f":"VLOOKUP($D16,'Page 10'!$D$30:$J$41,5,FALSE)*$E16","v":0},{"$f":"VLOOKUP($D16,'Page 10'!$D$30:$J$41,6,FALSE)*$E16","v":0},{"$f":"VLOOKUP($D16,'Page 10'!$D$30:$J$41,7,FALSE)*$E16","v":0}]
["SCHMDP-SG","SCHMDP","SG","P",0,{"$f":"VLOOKUP($D17,'Page 10'!$D$30:$J$41,3,FALSE)*$E17","v":0},{"$f":"VLOOKUP($D17,'Page 10'!$D$30:$J$41,4,FALSE)*$E17","v":0},{"$f":"VLOOKUP($D17,'Page 10'!$D$30:$J$41,5,FALSE)*$E17","v":0},{"$f":"VLOOKUP($D17,'Page 10'!$D$30:$J$41,6,FALSE)*$E17","v":0},{"$f":"VLOOKUP($D17,'Page 10'!$D$30:$J$41,7,FALSE)*$E17","v":0}]
["SCHMDP-SNP","SCHMDP","SNP","PTD",361,{"$f":"VLOOKUP($D18,'Page 10'!$D$30:$J$41,3,FALSE)*$E18","v":183.31670094197517},{"$f":"VLOOKUP($D18,'Page 10'!$D$30:$J$41,4,FALSE)*$E18","v":79.191107346275047},{"$f":"VLOOKUP($D18,'Page 10'!$D$30:$J$41,5,FALSE)*$E18","v":98.492191711749825},{"$f":"VLOOKUP($D18,'Page 10'!$D$30:$J$41,6,FALSE)*$E18","v":0},{"$f":"VLOOKUP($D18,'Page 10'!$D$30:$J$41,7,FALSE)*$E18","v":0}]
["SCHMDP-SO","SCHMDP","SO","LABOR",20812,{"$f":"VLOOKUP($D19,'Page 10'!$D$30:$J$41,3,FALSE)*$E19","v":8889.4096948216338},{"$f":"VLOOKUP($D19,'Page 10'!$D$30:$J$41,4,FALSE)*$E19","v":1426.6749451807636},{"$f":"VLOOKUP($D19,'Page 10'!$D$30:$J$41,5,FALSE)*$E19","v":7395.2990620406181},{"$f":"VLOOKUP($D19,'Page 10'!$D$30:$J$41,6,FALSE)*$E19","v":3100.6162979569849},{"$f":"VLOOKUP($D19,'Page 10'!$D$30:$J$41,7,FALSE)*$E19","v":0}]
["SCHMDP-SITUS","SCHMDP","SITUS","PTD",0,{"$f":"VLOOKUP($D20,'Page 10'!$D$30:$J$41,3,FALSE)*$E20","v":0},{"$f":"VLOOKUP($D20,'Page 10'!$D$30:$J$41,4,FALSE)*$E20","v":0},{"$f":"VLOOKUP($D20,'Page 10'!$D$30:$J$41,5,FALSE)*$E20","v":0},{"$f":"VLOOKUP($D20,'Page 10'!$D$30:$J$41,6,FALSE)*$E20","v":0},{"$f":"VLOOKUP($D20,'Page 10'!$D$30:$J$41,7,FALSE)*$E20","v":0}]
[null,"Total-SO",null,null,{"$f":"SUMIF($A$6:$A$59,\"SCHMDP-SO\",E$6:E$59)","v":20812},8889.4096948216338,1426.6749451807636,7395.2990620406181,3100.6162979569849,0]
[{"$f":"IF(C22=\"\",\"\",B22&\"-\"&C22)","v":""},"Total-SCHMDP",null,null,{"$f":"SUMIF($B$6:$B$59,\"SCHMDP\",E$6:E$59)","v":21856},9693.283461722458,1513.3380671832324,7532.5231198758747,3116.8553512184358,0]
[{"$f":"IF(C23=\"\",\"\",B23&\"-\"&C23)","v":""},"SCHMDP-SO",null,null,{"$f":"SUM(F23:J23)","v":1},{"$f":"IF(ISERROR(F21/$E21),\" \",(F21/$E21))","v":0.42712904549402431},6.855059317608897E-2,0.35533822131657783,0.14898214001330889,0]
[{"$f":"IF(C24=\"\",\"\",B24&\"-\"&C24)","v":""},"SCHMDP FACTOR",null,null,{"$f":"SUM(F24:J24)","v":1},0.44350674696753561,6.9241309808896062E-2,0.34464326134131928,0.14260868188224907,0]
[]
[{"$f":"IF(C26=\"\",\"\",B26&\"-\"&C26)","v":"SCHMDT-BADDEBT"},"SCHMDT","BADDEBT","CUST",0,{"$f":"VLOOKUP($D26,'Page 10'!$D$30:$J$41,3,FALSE)*$E26","v":0},{"$f":"VLOOKUP($D26,'Page 10'!$D$30:$J$41,4,FALSE)*$E26","v":0},{"$f":"VLOOKUP($D26,'Page 10'!$D$30:$J$41,5,FALSE)*$E26","v":0},{"$f":"VLOOKUP($D26,'Page 10'!$D$30:$J$41,6,FALSE)*$E26","v":0},{"$f":"VLOOKUP($D26,'Page 10'!$D$30:$J$41,7,FALSE)*$E26","v":0}]
["SCHMDT-CN","SCHMDT","CN","CUST",48,{"$f":"VLOOKUP($D27,'Page 10'!$D$30:$J$41,3,FALSE)*$E27","v":0},{"$f":"VLOOKUP($D27,'Page 10'!$D$30:$J$41,4,FALSE)*$E27","v":0},{"$f":"VLOOKUP($D27,'Page 10'!$D$30:$J$41,5,FALSE)*$E27","v":0},{"$f":"VLOOKUP($D27,'Page 10'!$D$30:$J$41,6,FALSE)*$E27","v":48},{"$f":"VLOOKUP($D27,'Page 10'!$D$30:$J$41,7,FALSE)*$E27","v":0}]
["SCHMDT-GPS","SCHMDT","GPS","GP",4908,{"$f":"VLOOKUP($D28,'Page 10'!$D$30:$J$41,3,FALSE)*$E28","v":2499.4797676599155},{"$f":"VLOOKUP($D28,'Page 10'!$D$30:$J$41,4,FALSE)*$E28","v":1058.950422492054},{"$f":"VLOOKUP($D28,'Page 10'!$D$30:$J$41,5,FALSE)*$E28","v":1318.6573463859911},{"$f":"VLOOKUP($D28,'Page 10'!$D$30:$J$41,6,FALSE)*$E28","v":30.91246346203933},{"$f":"VLOOKUP($D28,'Page 10'!$D$30:$J$41,7,FALSE)*$E28","v":0}]
["SCHMDT-GPS","SCHMDT","GPS","P",0,{"$f":"VLOOKUP($D29,'Page 10'!$D$30:$J$41,3,FALSE)*$E29","v":0},{"$f":"VLOOKUP($D29,'Page 10'!$D$30:$J$41,4,FALSE)*$E29","v":0},{"$f":"VLOOKUP($D29,'Page 10'!$D$30:$J$41,5,FALSE)*$E29","v":0},{"$f":"VLOOKUP($D29,'Page 10'!$D$30:$J$41,6,FALSE)*$E29","v":0},{"$f":"VLOOKUP($D29,'Page 10'!$D$30:$J$41,7,FALSE)*$E29","v":0}]
["SCHMDT-GPS","SCHMDT","GPS","PTD",63651,{"$f":"VLOOKUP($D30,'Page 10'!$D$30:$J$41,3,FALSE)*$E30","v":32322.136652791305},{"$f":"VLOOKUP($D30,'Page 10'!$D$30:$J$41,4,FALSE)*$E30","v":13962.861977002085},{"$f":"VLOOKUP($D30,'Page 10'!$D$30:$J$41,5,FALSE)*$E30","v":17366.001370206617},{"$f":"VLOOKUP($D30,'Page 10'!$D$30:$J$41,6,FALSE)*$E30","v":0},{"$f":"VLOOKUP($D30,'Page 10'!$D$30:$J$41,7,FALSE)*$E30","v":0}]
["SCHMDT-SG","SCHMDT","SG","P",62164,{"$f":"VLOOKUP($D31,'Page 10'!$D$30:$J$41,3,FALSE)*$E31","v":62164},{"$f":"VLOOKUP($D31,'Page 10'!$D$30:$J$41,4,FALSE)*$E31","v":0},{"$f":"VLOOKUP($D31,'Page 10'!$D$30:$J$41,5,FALSE)*$E31","v":0},{"$f":"VLOOKUP($D31,'Page 10'!$D$30:$J$41,6,FALSE)*$E31","v":0},{"$f":"VLOOKUP($D31,'Page 10'!$D$30:$J$41,7,FALSE)*$E31","v":0}]
["SCHMDT-SG","SCHMDT","SG","GP",0,{"$f":"VLOOKUP($D32,'Page 10'!$D$30:$J$41,3,FALSE)*$E32","v":0},{"$f":"VLOOKUP($D32,'Page 10'!$D$30:$J$41,4,FALSE)*$E32","v":0},{"$f":"VLOOKUP($D32,'Page 10'!$D$30:$J$41,5,FALSE)*$E32","v":0},{"$f":"VLOOKUP($D32,'Page 10'!$D$30:$J$41,6,FALSE)*$E32","v":0},{"$f":"VLOOKUP($D32,'Page 10'!$D$30:$J$41,7,FALSE)*$E32","v":0}]
["SCHMDT-SE","SCHMDT","SE","P",48399,{"$f":"VLOOKUP($D33,'Page 10'!$D$30:$J$41,3,FALSE)*$E33","v":48399},{"$f":"VLOOKUP($D33,'Page 10'!$D$30:$J$41,4,FALSE)*$E33","v":0},{"$f":"VLOOKUP($D33,'Page 10'!$D$30:$J$41,5,FALSE)*$E33","v":0},{"$f":"VLOOKUP($D33,'Page 10'!$D$30:$J$41,6,FALSE)*$E33","v":0},{"$f":"VLOOKUP($D33,'Page 10'!$D$30:$J$41,7,FALSE)*$E33","v":0}]
["SCHMDT-SNP","SCHMDT","SNP","PTD",88835,{"$f":"VLOOKUP($D34,'Page 10'!$D$30:$J$41,3,FALSE)*$E34","v":45110.634704100732},{"$f":"VLOOKUP($D34,'Page 10'!$D$30:$J$41,4,FALSE)*$E34","v":19487.374019685161},{"$f":"VLOOKUP($D34,'Page 10'!$D$30:$J$41,5,FALSE)*$E34","v":24236.991276214118},{"$f":"VLOOKUP($D34,'Page 10'!$D$30:$J$41,6,FALSE)*$E34","v":0},{"$f":"VLOOKUP($D34,'Page 10'!$D$30:$J$41,7,FALSE)*$E34","v":0}]
["SCHMDT-SO","SCHMDT","SO","ESD",6710,{"$f":"VLOOKUP($D35,'Page 10'!$D$30:$J$41,3,FALSE)*$E35","v":2013},{"$f":"VLOOKUP($D35,'Page 10'!$D$30:$J$41,4,FALSE)*$E35","v":671},{"$f":"VLOOKUP($D35,'Page 10'!$D$30:$J$41,5,FALSE)*$E35","v":4026},{"$f":"VLOOKUP($D35,'Page 10'!$D$30:$J$41,6,FALSE)*$E35","v":0},{"$f":"VLOOKUP($D35,'Page 10'!$D$30:$J$41,7,FALSE)*$E35","v":0}]
["SCHMDT-SO","SCHMDT","SO","GP",10615,{"$f":"VLOOKUP($D36,'Page 10'!$D$30:$J$41,3,FALSE)*$E36","v":5405.8634339262435},{"$f":"VLOOKUP($D36,'Page 10'!$D$30:$J$41,4,FALSE)*$E36","v":2290.2931407402516},{"$f":"VLOOKUP($D36,'Page 10'!$D$30:$J$41,5,FALSE)*$E36","v":2851.9860904415841},{"$f":"VLOOKUP($D36,'Page 10'!$D$30:$J$41,6,FALSE)*$E36","v":66.857334891920843},{"$f":"VLOOKUP($D36,'Page 10'!$D$30:$J$41,7,FALSE)*$E36","v":0}]
["SCHMDT-SO","SCHMDT","SO","LABOR",279,{"$f":"VLOOKUP($D37,'Page 10'!$D$30:$J$41,3,FALSE)*$E37","v":119.16900369283279},{"$f":"VLOOKUP($D37,'Page 10'!$D$30:$J$41,4,FALSE)*$E37","v":19.125615496128823},{"$f":"VLOOKUP($D37,'Page 10'!$D$30:$J$41,5,FALSE)*$E37","v":99.13936374732522},{"$f":"VLOOKUP($D37,'Page 10'!$D$30:$J$41,6,FALSE)*$E37","v":41.566017063713183},{"$f":"VLOOKUP($D37,'Page 10'!$D$30:$J$41,7,FALSE)*$E37","v":0}]
["SCHMDT-SO","SCHMDT","SO","PTD",5740,{"$f":"VLOOKUP($D38,'Page 10'!$D$30:$J$41,3,FALSE)*$E38","v":2914.7863252269735},{"$f":"VLOOKUP($D38,'Page 10'!$D$30:$J$41,4,FALSE)*$E38","v":1259.160543400606},{"$f":"VLOOKUP($D38,'Page 10'!$D$30:$J$41,5,FALSE)*$E38","v":1566.0531313724211},{"$f":"VLOOKUP($D38,'Page 10'!$D$30:$J$41,6,FALSE)*$E38","v":0},{"$f":"VLOOKUP($D38,'Page 10'!$D$30:$J$41,7,FALSE)*$E38","v":0}]
["SCHMDT-OTHER","SCHMDT","OTHER","CUST",604,{"$f":"VLOOKUP($D39,'Page 10'!$D$30:$J$41,3,FALSE)*$E39","v":0},{"$f":"VLOOKUP($D39,'Page 10'!$D$30:$J$41,4,FALSE)*$E39","v":0},{"$f":"VLOOKUP($D39,'Page 10'!$D$30:$J$41,5,FALSE)*$E39","v":0},{"$f":"VLOOKUP($D39,'Page 10'!$D$30:$J$41,6,FALSE)*$E39","v":604},{"$f":"VLOOKUP($D39,'Page 10'!$D$30:$J$41,7,FALSE)*$E39","v":0}]
["SCHMDT-OTHER","SCHMDT","OTHER","DMSC",52131,{"$f":"VLOOKUP($D40,'Page 10'!$D$30:$J$41,3,FALSE)*$E40","v":0},{"$f":"VLOOKUP($D40,'Page 10'!$D$30:$J$41,4,FALSE)*$E40","v":0},{"$f":"VLOOKUP($D40,'Page 10'!$D$30:$J$41,5,FALSE)*$E40","v":0},{"$f":"VLOOKUP($D40,'Page 10'!$D$30:$J$41,6,FALSE)*$E40","v":0},{"$f":"VLOOKUP($D40,'Page 10'!$D$30:$J$41,7,FALSE)*$E40","v":52131}]
["SCHMDT-OTHER","SCHMDT","OTHER","DPW",386,{"$f":"VLOOKUP($D41,'Page 10'!$D$30:$J$41,3,FALSE)*$E41","v":0},{"$f":"VLOOKUP($D41,'Page 10'!$D$30:$J$41,4,FALSE)*$E41","v":0},{"$f":"VLOOKUP($D41,'Page 10'!$D$30:$J$41,5,FALSE)*$E41","v":386},{"$f":"VLOOKUP($D41,'Page 10'!$D$30:$J$41,6,FALSE)*$E41","v":0},{"$f":"VLOOKUP($D41,'Page 10'!$D$30:$J$41,7,FALSE)*$E41","v":0}]
["SCHMDT-OTHER","SCHMDT","OTHER","LABOR",2969,{"$f":"VLOOKUP($D42,'Page 10'!$D$30:$J$41,3,FALSE)*$E42","v":1268.1461360717581},{"$f":"VLOOKUP($D42,'Page 10'!$D$30:$J$41,4,FALSE)*$E42","v":203.52671113980816},{"$f":"VLOOKUP($D42,'Page 10'!$D$30:$J$41,5,FALSE)*$E42","v":1054.9991790889196},{"$f":"VLOOKUP($D42,'Page 10'!$D$30:$J$41,6,FALSE)*$E42","v":442.32797369951413},{"$f":"VLOOKUP($D42,'Page 10'!$D$30:$J$41,7,FALSE)*$E42","v":0}]
["SCHMDT-OTHER","SCHMDT","OTHER","P",42312,{"$f":"VLOOKUP($D43,'Page 10'!$D$30:$J$41,3,FALSE)*$E43","v":42312},{"$f":"VLOOKUP($D43,'Page 10'!$D$30:$J$41,4,FALSE)*$E43","v":0},{"$f":"VLOOKUP($D43,'Page 10'!$D$30:$J$41,5,FALSE)*$E43","v":0},{"$f":"VLOOKUP($D43,'Page 10'!$D$30:$J$41,6,FALSE)*$E43","v":0},{"$f":"VLOOKUP($D43,'Page 10'!$D$30:$J$41,7,FALSE)*$E43","v":0}]
["SCHMDT-OTHER","SCHMDT","OTHER","PT",15725,{"$f":"VLOOKUP($D44,'Page 10'!$D$30:$J$41,3,FALSE)*$E44","v":10981.216677361541},{"$f":"VLOOKUP($D44,'Page 10'!$D$30:$J$41,4,FALSE)*$E44","v":4743.7833226384591},{"$f":"VLOOKUP($D44,'Page 10'!$D$30:$J$41,5,FALSE)*$E44","v":0},{"$f":"VLOOKUP($D44,'Page 10'!$D$30:$J$41,6,FALSE)*$E44","v":0},{"$f":"VLOOKUP($D44,'Page 10'!$D$30:$J$41,7,FALSE)*$E44","v":0}]
["SCHMDT-OTHER","SCHMDT","OTHER","TD",1230,{"$f":"VLOOKUP($D45,'Page 10'!$D$30:$J$41,3,FALSE)*$E45","v":0},{"$f":"VLOOKUP($D45,'Page 10'!$D$30:$J$41,4,FALSE)*$E45","v":548.19480813505925},{"$f":"VLOOKUP($D45,'Page 10'!$D$30:$J$41,5,FALSE)*$E45","v":681.80519186494064},{"$f":"VLOOKUP($D45,'Page 10'!$D$30:$J$41,6,FALSE)*$E45","v":0},{"$f":"VLOOKUP($D45,'Page 10'!$D$30:$J$41,7,FALSE)*$E45","v":0}]
["SCHMDT-TAXDEPR","SCHMDT","TAXDEPR","TAXDEPR",2847400,{"$f":"VLOOKUP($D46,'Page 10'!$D$30:$J$41,3,FALSE)*$E46","v":1644300.924438566},{"$f":"VLOOKUP($D46,'Page 10'!$D$30:$J$41,4,FALSE)*$E46","v":557824.23558642645},{"$f":"VLOOKUP($D46,'Page 10'!$D$30:$J$41,5,FALSE)*$E46","v":632414.44580870436},{"$f":"VLOOKUP($D46,'Page 10'!$D$30:$J$41,6,FALSE)*$E46","v":12860.394166303218},{"$f":"VLOOKUP($D46,'Page 10'!$D$30:$J$41,7,FALSE)*$E46","v":0}]
["SCHMDT-SITUS","SCHMDT","SITUS","DMSC",591,{"$f":"VLOOKUP($D47,'Page 10'!$D$30:$J$41,3,FALSE)*$E47","v":0},{"$f":"VLOOKUP($D47,'Page 10'!$D$30:$J$41,4,FALSE)*$E47","v":0},{"$f":"VLOOKUP($D47,'Page 10'!$D$30:$J$41,5,FALSE)*$E47","v":0},{"$f":"VLOOKUP($D47,'Page 10'!$D$30:$J$41,6,FALSE)*$E47","v":0},{"$f":"VLOOKUP($D47,'Page 10'!$D$30:$J$41,7,FALSE)*$E47","v":591}]
["SCHMDT-SITUS","SCHMDT","SITUS","DPW",41,{"$f":"VLOOKUP($D48,'Page 10'!$D$30:$J$41,3,FALSE)*$E48","v":0},{"$f":"VLOOKUP($D48,'Page 10'!$D$30:$J$41,4,FALSE)*$E48","v":0},{"$f":"VLOOKUP($D48,'Page 10'!$D$30:$J$41,5,FALSE)*$E48","v":41},{"$f":"VLOOKUP($D48,'Page 10'!$D$30:$J$41,6,FALSE)*$E48","v":0},{"$f":"VLOOKUP($D48,'Page 10'!$D$30:$J$41,7,FALSE)*$E48","v":0}]
["SCHMDT-SITUS","SCHMDT","SITUS","GP",26,{"$f":"VLOOKUP($D49,'Page 10'!$D$30:$J$41,3,FALSE)*$E49","v":13.24092786453908},{"$f":"VLOOKUP($D49,'Page 10'!$D$30:$J$41,4,FALSE)*$E49","v":5.6097618143425851},{"$f":"VLOOKUP($D49,'Page 10'!$D$30:$J$41,5,FALSE)*$E49","v":6.9855523647179636},{"$f":"VLOOKUP($D49,'Page 10'!$D$30:$J$41,6,FALSE)*$E49","v":0.16375795640037136},{"$f":"VLOOKUP($D49,'Page 10'!$D$30:$J$41,7,FALSE)*$E49","v":0}]
["SCHMDT-SITUS","SCHMDT","SITUS","LABOR",1593,{"$f":"VLOOKUP($D50,'Page 10'!$D$30:$J$41,3,FALSE)*$E50","v":680.41656947198067},{"$f":"VLOOKUP($D50,'Page 10'!$D$30:$J$41,4,FALSE)*$E50","v":109.20109492950972},{"$f":"VLOOKUP($D50,'Page 10'!$D$30:$J$41,5,FALSE)*$E50","v":566.05378655730851},{"$f":"VLOOKUP($D50,'Page 10'!$D$30:$J$41,6,FALSE)*$E50","v":237.32854904120106},{"$f":"VLOOKUP($D50,'Page 10'!$D$30:$J$41,7,FALSE)*$E50","v":0}]
["SCHMDT-SITUS","SCHMDT","SITUS","P",7399,{"$f":"VLOOKUP($D51,'Page 10'!$D$30:$J$41,3,FALSE)*$E51","v":7399},{"$f":"VLOOKUP($D51,'Page 10'!$D$30:$J$41,4,FALSE)*$E51","v":0},{"$f":"VLOOKUP($D51,'Page 10'!$D$30:$J$41,5,FALSE)*$E51","v":0},{"$f":"VLOOKUP($D51,'Page 10'!$D$30:$J$41,6,FALSE)*$E51","v":0},{"$f":"VLOOKUP($D51,'Page 10'!$D$30:$J$41,7,FALSE)*$E51","v":0}]
["SCHMDT-SITUS","SCHMDT","SITUS","PTD",0,{"$f":"VLOOKUP($D52,'Page 10'!$D$30:$J$41,3,FALSE)*$E52","v":0},{"$f":"VLOOKUP($D52,'Page 10'!$D$30:$J$41,4,FALSE)*$E52","v":0},{"$f":"VLOOKUP($D52,'Page 10'!$D$30:$J$41,5,FALSE)*$E52","v":0},{"$f":"VLOOKUP($D52,'Page 10'!$D$30:$J$41,6,FALSE)*$E52","v":0},{"$f":"VLOOKUP($D52,'Page 10'!$D$30:$J$41,7,FALSE)*$E52","v":0}]
["","Total-GPS",null,null,{"$f":"SUMIF($A$6:$A$59,\"SCHMDT-GPS\",E$6:E$59)","v":68559},34821.616420451217,15021.81239949414,18684.658716592607,30.91246346203933,0]
["","Total-CN",null,null,{"$f":"SUMIF($A$6:$A$59,\"SCHMDT-CN\",E$6:E$59)","v":48},0,0,0,48,0]
["","Total-SG",null,null,{"$f":"SUMIF($A$6:$A$59,\"SCHMDT-SG\",E$6:E$59)","v":62164},62164,0,0,0,0]
["","Total-SE",null,null,{"$f":"SUMIF($A$6:$A$59,\"SCHMDT-SE\",E$6:E$59)","v":48399},48399,0,0,0,0]
["","Total-SNP",null,null,{"$f":"SUMIF($A$6:$A$59,\"SCHMDT-SNP\",E$6:E$59)","v":88835},45110.634704100732,19487.374019685161,24236.991276214118,0,0]
["","Total SO",null,null,{"$f":"SUMIF($A$6:$A$59,\"SCHMDT-SO\",E$6:E$59)","v":23344},10452.818762846051,4239.5792996369864,8543.1785855613307,108.42335195563402,0]
["","Total OTHER",null,null,{"$f":"SUMIF($A$6:$A$59,\"SCHMDT-OTHER\",E$6:E$59)","v":115357},54561.362813433298,5495.5048419133263,2122.8043709538601,1046.3279736995141,52131]

{"sheet":"Page 10","index":9,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"+'Page 1'!A1","v":"PacifiCorp"}]
[null,{"$f":"+'Page 1'!A2","v":"12 Months Ended June 2011"}]
[null,"Schedule M"]
[null,"Primary","PITA"]
[null,"Account","Factor","Function","Amount","Production","Transmission","Poles & Wires","Customers","Miscellaneous"]
[{"$f":"IF(C6=\"\",\"\",B6&\"-\"&C6)","v":""},"Total TAXDEPR",null,null,{"$f":"+'Page 9'!E46","v":2847400},{"$f":"+'Page 9'!F46","v":1644300.924438566},{"$f":"+'Page 9'!G46","v":557824.23558642645},{"$f":"+'Page 9'!H46","v":632414.44580870436},{"$f":"+'Page 9'!I46","v":12860.394166303218},{"$f":"+'Page 9'!J46","v":0}]
["","Total-SITUS",null,null,{"$f":"SUM('Page 9'!E47:E52)+SUM('Page 9'!E27)","v":9698},{"$f":"SUM('Page 9'!F47:F52)+SUM('Page 9'!F27)","v":8092.6574973365196},{"$f":"SUM('Page 9'!G47:G52)+SUM('Page 9'!G27)","v":114.81085674385231},{"$f":"SUM('Page 9'!H47:H52)+SUM('Page 9'!H27)","v":614.03933892202645},{"$f":"SUM('Page 9'!I47:I52)+SUM('Page 9'!I27)","v":285.49230699760142},{"$f":"SUM('Page 9'!J47:J52)+SUM('Page 9'!J27)","v":591}]
["","Total SCHMDT",null,null,{"$f":"SUM('Page 9'!E26:E52)","v":3263756},{"$f":"SUM('Page 9'!F26:F52)","v":1907903.0146367338},{"$f":"SUM('Page 9'!G26:G52)","v":602183.31700389984},{"$f":"SUM('Page 9'!H26:H52)","v":686616.11809694825},{"$f":"SUM('Page 9'!I26:I52)","v":14331.550262418008},{"$f":"SUM('Page 9'!J26:J52)","v":52722}]
["","SCHMDT-GPS",null,null,{"$f":"SUM(F9:J9)","v":1},{"$f":"IF(ISERROR('Page 9'!F53/'Page 9'!$E53),\" \",('Page 9'!F53/'Page 9'!$E53))","v":0.50790729766261489},{"$f":"IF(ISERROR('Page 9'!G53/'Page 9'!$E53),\" \",('Page 9'!G53/'Page 9'!$E53))","v":0.21910781078332736},{"$f":"IF(ISERROR('Page 9'!H53/'Page 9'!$E53),\" \",('Page 9'!H53/'Page 9'!$E53))","v":0.27253400307169895},{"$f":"IF(ISERROR('Page 9'!I53/'Page 9'!$E53),\" \",('Page 9'!I53/'Page 9'!$E53))","v":4.5088848235883444E-4},{"$f":"IF(ISERROR('Page 9'!J53/'Page 9'!$E53),\" \",('Page 9'!J53/'Page 9'!$E53))","v":0}]
["","SCHMDT-CN",null,null,1,{"$f":"IF(ISERROR('Page 9'!F54/'Page 9'!$E54),\" \",('Page 9'!F54/'Page 9'!$E54))","v":0},{"$f":"IF(ISERROR('Page 9'!G54/'Page 9'!$E54),\" \",('Page 9'!G54/'Page 9'!$E54))","v":0},{"$f":"IF(ISERROR('Page 9'!H54/'Page 9'!$E54),\" \",('Page 9'!H54/'Page 9'!$E54))","v":0},{"$f":"IF(ISERROR('Page 9'!I54/'Page 9'!$E54),\" \",('Page 9'!I54/'Page 9'!$E54))","v":1},{"$f":"IF(ISERROR('Page 9'!J54/'Page 9'!$E54),\" \",('Page 9'!J54/'Page 9'!$E54))","v":0}]
["","SCHMDT-SG",null,null,1,{"$f":"IF(ISERROR('Page 9'!F55/'Page 9'!$E55),\" \",('Page 9'!F55/'Page 9'!$E55))","v":1},{"$f":"IF(ISERROR('Page 9'!G55/'Page 9'!$E55),\" \",('Page 9'!G55/'Page 9'!$E55))","v":0},{"$f":"IF(ISERROR('Page 9'!H55/'Page 9'!$E55),\" \",('Page 9'!H55/'Page 9'!$E55))","v":0},{"$f":"IF(ISERROR('Page 9'!I55/'Page 9'!$E55),\" \",('Page 9'!I55/'Page 9'!$E55))","v":0},{"$f":"IF(ISERROR('Page 9'!J55/'Page 9'!$E55),\" \",('Page 9'!J55/'Page 9'!$E55))","v":0}]
["","SCHMDT-SE",null,null,1,{"$f":"IF(ISERROR('Page 9'!F56/'Page 9'!$E56),\" \",('Page 9'!F56/'Page 9'!$E56))","v":1},{"$f":"IF(ISERROR('Page 9'!G56/'Page 9'!$E56),\" \",('Page 9'!G56/'Page 9'!$E56))","v":0},{"$f":"IF(ISERROR('Page 9'!H56/'Page 9'!$E56),\" \",('Page 9'!H56/'Page 9'!$E56))","v":0},{"$f":"IF(ISERROR('Page 9'!I56/'Page 9'!$E56),\" \",('Page 9'!I56/'Page 9'!$E56))","v":0},{"$f":"IF(ISERROR('Page 9'!J56/'Page 9'!$E56),\" \",('Page 9'!J56/'Page 9'!$E56))","v":0}]
["","SCHMDT-SNP",null,null,1,{"$f":"IF(ISERROR('Page 9'!F57/'Page 9'!$E57),\" \",('Page 9'!F57/'Page 9'!$E57))","v":0.50780249568414171},{"$f":"IF(ISERROR('Page 9'!G57/'Page 9'!$E57),\" \",('Page 9'!G57/'Page 9'!$E57))","v":0.2193659483276317},{"$f":"IF(ISERROR('Page 9'!H57/'Page 9'!$E57),\" \",('Page 9'!H57/'Page 9'!$E57))","v":0.27283155598822667},{"$f":"IF(ISERROR('Page 9'!I57/'Page 9'!$E57),\" \",('Page 9'!I57/'Page 9'!$E57))","v":0},{"$f":"IF(ISERROR('Page 9'!J57/'Page 9'!$E57),\" \",('Page 9'!J57/'Page 9'!$E57))","v":0}]
["","SCHMDT-SO",null,null,1,{"$f":"IF(ISERROR('Page 9'!F58/'Page 9'!$E58),\" \",('Page 9'!F58/'Page 9'!$E58))","v":0.44777325063596862},{"$f":"IF(ISERROR('Page 9'!G58/'Page 9'!$E58),\" \",('Page 9'!G58/'Page 9'!$E58))","v":0.18161323250672493},{"$f":"IF(ISERROR('Page 9'!H58/'Page 9'!$E58),\" \",('Page 9'!H58/'Page 9'!$E58))","v":0.36596892501547851},{"$f":"IF(ISERROR('Page 9'!I58/'Page 9'!$E58),\" \",('Page 9'!I58/'Page 9'!$E58))","v":4.6445918418280508E-3},{"$f":"IF(ISERROR('Page 9'!J58/'Page 9'!$E58),\" \",('Page 9'!J58/'Page 9'!$E58))","v":0}]
["","SCHMDT-OTHER",null,null,1,{"$f":"IF(ISERROR('Page 9'!F59/'Page 9'!$E59),\" \",('Page 9'!F59/'Page 9'!$E59))","v":0.47297834386672066},{"$f":"IF(ISERROR('Page 9'!G59/'Page 9'!$E59),\" \",('Page 9'!G59/'Page 9'!$E59))","v":4.7639110256970332E-2},{"$f":"IF(ISERROR('Page 9'!H59/'Page 9'!$E59),\" \",('Page 9'!H59/'Page 9'!$E59))","v":1.8402042103676935E-2},{"$f":"IF(ISERROR('Page 9'!I59/'Page 9'!$E59),\" \",('Page 9'!I59/'Page 9'!$E59))","v":9.0703466083507205E-3},{"$f":"IF(ISERROR('Page 9'!J59/'Page 9'!$E59),\" \",('Page 9'!J59/'Page 9'!$E59))","v":0.45191015716428135}]
["","SCHMDT-TAXDEPR",null,null,1,{"$f":"IF(ISERROR(F6/$E6),\" \",(F6/$E6))","v":0.57747451163818431},0.1959065237010699,0.22210242530333088,4.516539357414911E-3,0]
["","SCHMDT-SITUS",null,null,1,0.83446664233208079,1.1838611749211416E-2,6.3316079492887853E-2,2.9438266343328669E-2,6.0940400082491235E-2]
["","SCHMDT FACTOR",null,null,0.99999999999999989,0.58457280955951785,0.18450623055274348,0.21037605694082162,4.3911218431825199E-3,1.6153781103734471E-2]
[]
[null,"SCHMDF","DGP","P",0,{"$f":"VLOOKUP($D20,$D$30:$J$41,3,FALSE)*$E20","v":0},{"$f":"VLOOKUP($D20,$D$30:$J$41,4,FALSE)*$E20","v":0},{"$f":"VLOOKUP($D20,$D$30:$J$41,5,FALSE)*$E20","v":0},{"$f":"VLOOKUP($D20,$D$30:$J$41,6,FALSE)*$E20","v":0},{"$f":"VLOOKUP($D20,$D$30:$J$41,7,FALSE)*$E20","v":0}]
[{"$f":"IF(C21=\"\",\"\",B21&\"-\"&C21)","v":""},"Total-SCHMDF",null,null,{"$f":"SUMIF($A$6:$A$41,\"SCHMDF\",E$6:E$41)","v":0},0,0,0,0,0]
[{"$f":"IF(C22=\"\",\"\",B22&\"-\"&C22)","v":""},"SCHMDF FACTOR",null,null,{"$f":"SUM(F22:J22)","v":0},{"$f":"IF(ISERROR(F21/$E21),\" \",(F21/$E21))","v":" "},{"$f":"IF(ISERROR(G21/$E21),\" \",(G21/$E21))","v":" "},{"$f":"IF(ISERROR(H21/$E21),\" \",(H21/$E21))","v":" "},{"$f":"IF(ISERROR(I21/$E21),\" \",(I21/$E21))","v":" "},{"$f":"IF(ISERROR(J21/$E21),\" \",(J21/$E21))","v":" "}]
[]
[{"$f":"IF(C24=\"\",\"\",B24&\"-\"&C24)","v":""},"Total-SCHMD",null,null,{"$f":"SUM(E21,E8,'Page 9'!E22)","v":3285612},{"$f":"SUM(F21,F8,'Page 9'!F22)","v":1917596.2980984563},{"$f":"SUM(G21,G8,'Page 9'!G22)","v":603696.65507108311},{"$f":"SUM(H21,H8,'Page 9'!H22)","v":694148.64121682418},{"$f":"SUM(I21,I8,'Page 9'!I22)","v":17448.405613636445},{"$f":"SUM(J21,J8,'Page 9'!J22)","v":52722}]
[{"$f":"IF(C25=\"\",\"\",B25&\"-\"&C25)","v":""},"SCHMD FACTOR",null,null,{"$f":"SUM(F25:J25)","v":1},{"$f":"IF(ISERROR(F24/$E24),\" \",(F24/$E24))","v":0.58363443343232746},{"$f":"IF(ISERROR(G24/$E24),\" \",(G24/$E24))","v":0.18373948447688987},{"$f":"IF(ISERROR(H24/$E24),\" \",(H24/$E24))","v":0.21126920683782022},{"$f":"IF(ISERROR(I24/$E24),\" \",(I24/$E24))","v":5.3105496369128327E-3},{"$f":"IF(ISERROR(J24/$E24),\" \",(J24/$E24))","v":1.6046325616049614E-2}]
[]
[{"$f":"IF(C27=\"\",\"\",B27&\"-\"&C27)","v":""},"Net SCHM"]
[{"$f":"IF(C28=\"\",\"\",B28&\"-\"&C28)","v":""}]
[null,null,null,null,"Total","Production","Transmission","Poles & Wires","Customers","Miscellaneous"]
[null,null,null,"DMSC",{"$f":"SUM(F30:J30)","v":1},0,0,0,0,1]
[null,null,null,"DPW",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,{"$f":"'Page 4'!E43","v":0.50926645632842615},{"$f":"'Page 4'!F43","v":0.21576006978240711},{"$f":"'Page 4'!G43","v":0.26867509095069092},{"$f":"'Page 4'!H43","v":6.2983829384758213E-3},{"$f":"'Page 4'!I43","v":0}]
[null,null,null,"LABOR",1,{"$f":"'Page 14'!C25","v":0.42712904549402431},{"$f":"'Page 14'!D25","v":6.855059317608897E-2},{"$f":"'Page 14'!E25","v":0.35533822131657783},{"$f":"'Page 14'!F25","v":0.14898214001330889},{"$f":"'Page 14'!G25","v":0}]
[null,null,null,"P",1,{"$f":"'Page 14'!C13","v":1},{"$f":"'Page 14'!D13","v":0},{"$f":"'Page 14'!E13","v":0},{"$f":"'Page 14'!F13","v":0},{"$f":"'Page 14'!G13","v":0}]
[null,null,null,"PT",1,{"$f":"+'Page 14'!C17","v":0.69832856453809478},{"$f":"+'Page 14'!D17","v":0.30167143546190517},0,0,0]
[null,null,null,"PTD",1,{"$f":"'Page 14'!C16","v":0.50780249568414171},{"$f":"'Page 14'!D16","v":0.2193659483276317},{"$f":"'Page 14'!E16","v":0.27283155598822667},{"$f":"'Page 14'!F16","v":0},{"$f":"'Page 14'!G16","v":0}]
[null,null,null,"T",1,{"$f":"'Page 14'!C14","v":0},{"$f":"'Page 14'!D14","v":1},{"$f":"'Page 14'!E14","v":0},{"$f":"'Page 14'!F14","v":0},{"$f":"'Page 14'!G14","v":0}]
[null,null,null,"TAXDEPR",1,{"$f":"'Page 11'!C24","v":0.57747451163818431},{"$f":"'Page 11'!D24","v":0.1959065237010699},{"$f":"'Page 11'!E24","v":0.22210242530333088},{"$f":"'Page 11'!F24","v":4.516539357414911E-3},{"$f":"'Page 11'!G24","v":0}]
[null,null,null,"TD",1,{"$f":"'Page 14'!C18","v":0},{"$f":"'Page 14'!D18","v":0.44568683588216201},{"$f":"'Page 14'!E18","v":0.55431316411783793},{"$f":"'Page 14'!F18","v":0},{"$f":"'Page 14'!G18","v":0}]

{"sheet":"Page 11","index":10,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6]]}
[{"$f":"+'Page 1'!$A$1","v":"PacifiCorp"}]
[{"$f":"+'Page 1'!A2","v":"12 Months Ended June 2011"}]
["Tax Depreciation"]
[]
[null,"Total","Production","Transmission","Distribution","General","Mining"]
[]
[]
["Total",{"$f":"SUM(C8:G8)","v":1058690506},{"$f":"571941475-G8","v":563980234},192892391,215853777,78002863,7961241]
[]
[]
[]
["Conversion to COS Functions","Total","Pro","Trn","Dis","Retail","Misc"]
[]
["Percent of GenPlant in Functions",{"$f":"SUM(C14:F14)","v":1},0.50543411372390579,0.18604427001335411,0.24722107992639428,6.1300536336345843E-2,0]
[" (%'s developed in JAM May 2013 - "]
["use \"Total Plant\" variable)"]
[]
["Allocation of GenPlant to Functions",{"$f":"SUM(C18:F18)","v":78002863},{"$f":"+$F$8*C14","v":39425307.928332239},{"$f":"+$F$8*D14","v":14511985.705786668},{"$f":"+$F$8*E14","v":19283952.028210584},{"$f":"+$F$8*F14","v":4781617.3376705069},{"$f":"+$F$8*G14","v":0}]
["Assignment of Mining to Prod Function",{"$f":"SUM(C19:F19)","v":7961241},{"$f":"G8","v":7961241}]
[]
["Adjusted Totals",{"$f":"SUM(C21:F21)","v":1058690506},{"$f":"+C8+C18+C19","v":611366782.92833221},{"$f":"+D8+D18+D19","v":207404376.70578668},{"$f":"+E8+E18+E19","v":235137729.02821058},{"$f":"+F18+F19","v":4781617.3376705069},{"$f":"+G18+G19","v":0}]
[]
[]
["TAXDEPR FACTOR",{"$f":"SUM(C24:F24)","v":1},{"$f":"+C21/$B$21","v":0.57747451163818431},{"$f":"+D21/$B$21","v":0.1959065237010699},{"$f":"+E21/$B$21","v":0.22210242530333088},{"$f":"+F21/$B$21","v":4.516539357414911E-3},{"$f":"+G21/$B$21","v":0}]

{"sheet":"Page 12","index":11,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,1,0,9],[1,1,1,9],[2,1,2,9]]}
[null,{"$f":"+'Page 1'!A1","v":"PacifiCorp"}]
[null,{"$f":"+'Page 1'!A2","v":"12 Months Ended June 2011"}]
[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",0,{"$f":"VLOOKUP($D6,'Page 13'!$D$21:$J$33,3,FALSE)*$E6","v":0},{"$f":"VLOOKUP($D6,'Page 13'!$D$21:$J$33,4,FALSE)*$E6","v":0},{"$f":"VLOOKUP($D6,'Page 13'!$D$21:$J$33,5,FALSE)*$E6","v":0},{"$f":"VLOOKUP($D6,'Page 13'!$D$21:$J$33,6,FALSE)*$E6","v":0},{"$f":"VLOOKUP($D6,'Page 13'!$D$21:$J$33,7,FALSE)*$E6","v":0}]
["RA-SG","182M","SG","P",0,{"$f":"VLOOKUP($D7,'Page 13'!$D$21:$J$33,3,FALSE)*$E7","v":0},{"$f":"VLOOKUP($D7,'Page 13'!$D$21:$J$33,4,FALSE)*$E7","v":0},{"$f":"VLOOKUP($D7,'Page 13'!$D$21:$J$33,5,FALSE)*$E7","v":0},{"$f":"VLOOKUP($D7,'Page 13'!$D$21:$J$33,6,FALSE)*$E7","v":0},{"$f":"VLOOKUP($D7,'Page 13'!$D$21:$J$33,7,FALSE)*$E7","v":0}]
["RA-SGCT","182M","SGCT","P",6828,{"$f":"VLOOKUP($D8,'Page 13'!$D$21:$J$33,3,FALSE)*$E8","v":6828},{"$f":"VLOOKUP($D8,'Page 13'!$D$21:$J$33,4,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,'Page 13'!$D$21:$J$33,5,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,'Page 13'!$D$21:$J$33,6,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,'Page 13'!$D$21:$J$33,7,FALSE)*$E8","v":0}]
["RA-SG-P","182M","SG-P","P",0,{"$f":"VLOOKUP($D9,'Page 13'!$D$21:$J$33,3,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,'Page 13'!$D$21:$J$33,4,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,'Page 13'!$D$21:$J$33,5,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,'Page 13'!$D$21:$J$33,6,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,'Page 13'!$D$21:$J$33,7,FALSE)*$E9","v":0}]
["RA-SO","182M","SO","DMSC",5547,{"$f":"VLOOKUP($D10,'Page 13'!$D$21:$J$33,3,FALSE)*$E10","v":0},{"$f":"VLOOKUP($D10,'Page 13'!$D$21:$J$33,4,FALSE)*$E10","v":0},{"$f":"VLOOKUP($D10,'Page 13'!$D$21:$J$33,5,FALSE)*$E10","v":0},{"$f":"VLOOKUP($D10,'Page 13'!$D$21:$J$33,6,FALSE)*$E10","v":0},{"$f":"VLOOKUP($D10,'Page 13'!$D$21:$J$33,7,FALSE)*$E10","v":5547}]
["RA-SO","182M","SO","DPW",0,{"$f":"VLOOKUP($D11,'Page 13'!$D$21:$J$33,3,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,'Page 13'!$D$21:$J$33,4,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,'Page 13'!$D$21:$J$33,5,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,'Page 13'!$D$21:$J$33,6,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,'Page 13'!$D$21:$J$33,7,FALSE)*$E11","v":0}]
["RA-SO","182M","SO","ESD",3294,{"$f":"VLOOKUP($D12,'Page 13'!$D$21:$J$33,3,FALSE)*$E12","v":988.19999999999993},{"$f":"VLOOKUP($D12,'Page 13'!$D$21:$J$33,4,FALSE)*$E12","v":329.40000000000003},{"$f":"VLOOKUP($D12,'Page 13'!$D$21:$J$33,5,FALSE)*$E12","v":1976.3999999999999},{"$f":"VLOOKUP($D12,'Page 13'!$D$21:$J$33,6,FALSE)*$E12","v":0},{"$f":"VLOOKUP($D12,'Page 13'!$D$21:$J$33,7,FALSE)*$E12","v":0}]
["RA-SO","182M","SO","P",0,{"$f":"VLOOKUP($D13,'Page 13'!$D$21:$J$33,3,FALSE)*$E13","v":0},{"$f":"VLOOKUP($D13,'Page 13'!$D$21:$J$33,4,FALSE)*$E13","v":0},{"$f":"VLOOKUP($D13,'Page 13'!$D$21:$J$33,5,FALSE)*$E13","v":0},{"$f":"VLOOKUP($D13,'Page 13'!$D$21:$J$33,6,FALSE)*$E13","v":0},{"$f":"VLOOKUP($D13,'Page 13'!$D$21:$J$33,7,FALSE)*$E13","v":0}]
["RA-SO","182M","SO","TD",0,{"$f":"VLOOKUP($D14,'Page 13'!$D$21:$J$33,3,FALSE)*$E14","v":0},{"$f":"VLOOKUP($D14,'Page 13'!$D$21:$J$33,4,FALSE)*$E14","v":0},{"$f":"VLOOKUP($D14,'Page 13'!$D$21:$J$33,5,FALSE)*$E14","v":0},{"$f":"VLOOKUP($D14,'Page 13'!$D$21:$J$33,6,FALSE)*$E14","v":0},{"$f":"VLOOKUP($D14,'Page 13'!$D$21:$J$33,7,FALSE)*$E14","v":0}]
["RA-OTHER","182M","OTHER","CUST",1579,{"$f":"VLOOKUP($D15,'Page 13'!$D$21:$J$33,3,FALSE)*$E15","v":0},{"$f":"VLOOKUP($D15,'Page 13'!$D$21:$J$33,4,FALSE)*$E15","v":0},{"$f":"VLOOKUP($D15,'Page 13'!$D$21:$J$33,5,FALSE)*$E15","v":0},{"$f":"VLOOKUP($D15,'Page 13'!$D$21:$J$33,6,FALSE)*$E15","v":1579},{"$f":"VLOOKUP($D15,'Page 13'!$D$21:$J$33,7,FALSE)*$E15","v":0}]
["RA-OTHER","182M","OTHER","DMSC",5453,{"$f":"VLOOKUP($D16,'Page 13'!$D$21:$J$33,3,FALSE)*$E16","v":0},{"$f":"VLOOKUP($D16,'Page 13'!$D$21:$J$33,4,FALSE)*$E16","v":0},{"$f":"VLOOKUP($D16,'Page 13'!$D$21:$J$33,5,FALSE)*$E16","v":0},{"$f":"VLOOKUP($D16,'Page 13'!$D$21:$J$33,6,FALSE)*$E16","v":0},{"$f":"VLOOKUP($D16,'Page 13'!$D$21:$J$33,7,FALSE)*$E16","v":5453}]
["RA-OTHER","182M","OTHER","LABOR",14218,{"$f":"VLOOKUP($D17,'Page 13'!$D$21:$J$33,3,FALSE)*$E17","v":6072.9207688340375},{"$f":"VLOOKUP($D17,'Page 13'!$D$21:$J$33,4,FALSE)*$E17","v":974.65233377763298},{"$f":"VLOOKUP($D17,'Page 13'!$D$21:$J$33,5,FALSE)*$E17","v":5052.1988306791036},{"$f":"VLOOKUP($D17,'Page 13'!$D$21:$J$33,6,FALSE)*$E17","v":2118.2280667092259},{"$f":"VLOOKUP($D17,'Page 13'!$D$21:$J$33,7,FALSE)*$E17","v":0}]
["RA-OTHER","182M","OTHER","P",51178,{"$f":"VLOOKUP($D18,'Page 13'!$D$21:$J$33,3,FALSE)*$E18","v":51178},{"$f":"VLOOKUP($D18,'Page 13'!$D$21:$J$33,4,FALSE)*$E18","v":0},{"$f":"VLOOKUP($D18,'Page 13'!$D$21:$J$33,5,FALSE)*$E18","v":0},{"$f":"VLOOKUP($D18,'Page 13'!$D$21:$J$33,6,FALSE)*$E18","v":0},{"$f":"VLOOKUP($D18,'Page 13'!$D$21:$J$33,7,FALSE)*$E18","v":0}]
["RA-OTHER","182M","OTHER","PT",10922,{"$f":"VLOOKUP($D19,'Page 13'!$D$21:$J$33,3,FALSE)*$E19","v":7627.1445818850707},{"$f":"VLOOKUP($D19,'Page 13'!$D$21:$J$33,4,FALSE)*$E19","v":3294.8554181149284},{"$f":"VLOOKUP($D19,'Page 13'!$D$21:$J$33,5,FALSE)*$E19","v":0},{"$f":"VLOOKUP($D19,'Page 13'!$D$21:$J$33,6,FALSE)*$E19","v":0},{"$f":"VLOOKUP($D19,'Page 13'!$D$21:$J$33,7,FALSE)*$E19","v":0}]
["RA-OTHER","182M","OTHER","PTD",14703,{"$f":"VLOOKUP($D20,'Page 13'!$D$21:$J$33,3,FALSE)*$E20","v":7466.2200940439352},{"$f":"VLOOKUP($D20,'Page 13'!$D$21:$J$33,4,FALSE)*$E20","v":3225.3375382611689},{"$f":"VLOOKUP($D20,'Page 13'!$D$21:$J$33,5,FALSE)*$E20","v":4011.4423676948968},{"$f":"VLOOKUP($D20,'Page 13'!$D$21:$J$33,6,FALSE)*$E20","v":0},{"$f":"VLOOKUP($D20,'Page 13'!$D$21:$J$33,7,FALSE)*$E20","v":0}]
["RA-OTHER","182M","OTHER","TD",664,{"$f":"VLOOKUP($D21,'Page 13'!$D$21:$J$33,3,FALSE)*$E21","v":0},{"$f":"VLOOKUP($D21,'Page 13'!$D$21:$J$33,4,FALSE)*$E21","v":295.93605902575558},{"$f":"VLOOKUP($D21,'Page 13'!$D$21:$J$33,5,FALSE)*$E21","v":368.06394097424436},{"$f":"VLOOKUP($D21,'Page 13'!$D$21:$J$33,6,FALSE)*$E21","v":0},{"$f":"VLOOKUP($D21,'Page 13'!$D$21:$J$33,7,FALSE)*$E21","v":0}]
["RA-TROJD","182M","TROJD","P",0,{"$f":"VLOOKUP($D22,'Page 13'!$D$21:$J$33,3,FALSE)*$E22","v":0},{"$f":"VLOOKUP($D22,'Page 13'!$D$21:$J$33,4,FALSE)*$E22","v":0},{"$f":"VLOOKUP($D22,'Page 13'!$D$21:$J$33,5,FALSE)*$E22","v":0},{"$f":"VLOOKUP($D22,'Page 13'!$D$21:$J$33,6,FALSE)*$E22","v":0},{"$f":"VLOOKUP($D22,'Page 13'!$D$21:$J$33,7,FALSE)*$E22","v":0}]
["RA-TROJP","182M","TROJP","P",0,{"$f":"VLOOKUP($D23,'Page 13'!$D$21:$J$33,3,FALSE)*$E23","v":0},{"$f":"VLOOKUP($D23,'Page 13'!$D$21:$J$33,4,FALSE)*$E23","v":0},{"$f":"VLOOKUP($D23,'Page 13'!$D$21:$J$33,5,FALSE)*$E23","v":0},{"$f":"VLOOKUP($D23,'Page 13'!$D$21:$J$33,6,FALSE)*$E23","v":0},{"$f":"VLOOKUP($D23,'Page 13'!$D$21:$J$33,7,FALSE)*$E23","v":0}]
["RA-SITUS","182M","SITUS","DMSC",-623,{"$f":"VLOOKUP($D24,'Page 13'!$D$21:$J$33,3,FALSE)*$E24","v":0},{"$f":"VLOOKUP($D24,'Page 13'!$D$21:$J$33,4,FALSE)*$E24","v":0},{"$f":"VLOOKUP($D24,'Page 13'!$D$21:$J$33,5,FALSE)*$E24","v":0},{"$f":"VLOOKUP($D24,'Page 13'!$D$21:$J$33,6,FALSE)*$E24","v":0},{"$f":"VLOOKUP($D24,'Page 13'!$D$21:$J$33,7,FALSE)*$E24","v":-623}]
["RA-SITUS","182M","SITUS","LABOR",-544,{"$f":"VLOOKUP($D25,'Page 13'!$D$21:$J$33,3,FALSE)*$E25","v":-232.35820074874923},{"$f":"VLOOKUP($D25,'Page 13'!$D$21:$J$33,4,FALSE)*$E25","v":-37.291522687792401},{"$f":"VLOOKUP($D25,'Page 13'!$D$21:$J$33,5,FALSE)*$E25","v":-193.30399239621835},{"$f":"VLOOKUP($D25,'Page 13'!$D$21:$J$33,6,FALSE)*$E25","v":-81.046284167240032},{"$f":"VLOOKUP($D25,'Page 13'!$D$21:$J$33,7,FALSE)*$E25","v":0}]
["RA-SITUS","182M","SITUS","P",17963,{"$f":"VLOOKUP($D26,'Page 13'!$D$21:$J$33,3,FALSE)*$E26","v":17963},{"$f":"VLOOKUP($D26,'Page 13'!$D$21:$J$33,4,FALSE)*$E26","v":0},{"$f":"VLOOKUP($D26,'Page 13'!$D$21:$J$33,5,FALSE)*$E26","v":0},{"$f":"VLOOKUP($D26,'Page 13'!$D$21:$J$33,6,FALSE)*$E26","v":0},{"$f":"VLOOKUP($D26,'Page 13'!$D$21:$J$33,7,FALSE)*$E26","v":0}]
["RA-SITUS","182M","SITUS","PTD",1268,{"$f":"VLOOKUP($D27,'Page 13'!$D$21:$J$33,3,FALSE)*$E27","v":643.89356452749166},{"$f":"VLOOKUP($D27,'Page 13'!$D$21:$J$33,4,FALSE)*$E27","v":278.15602247943701},{"$f":"VLOOKUP($D27,'Page 13'!$D$21:$J$33,5,FALSE)*$E27","v":345.95041299307144},{"$f":"VLOOKUP($D27,'Page 13'!$D$21:$J$33,6,FALSE)*$E27","v":0},{"$f":"VLOOKUP($D27,'Page 13'!$D$21:$J$33,7,FALSE)*$E27","v":0}]
["RA-SITUS","182M","SITUS","CUST",3168,{"$f":"VLOOKUP($D28,'Page 13'!$D$21:$J$33,3,FALSE)*$E28","v":0},{"$f":"VLOOKUP($D28,'Page 13'!$D$21:$J$33,4,FALSE)*$E28","v":0},{"$f":"VLOOKUP($D28,'Page 13'!$D$21:$J$33,5,FALSE)*$E28","v":0},{"$f":"VLOOKUP($D28,'Page 13'!$D$21:$J$33,6,FALSE)*$E28","v":3168},{"$f":"VLOOKUP($D28,'Page 13'!$D$21:$J$33,7,FALSE)*$E28","v":0}]
[null,"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"RA-SO\",E:E)","v":8841},988.19999999999993,329.40000000000003,1976.3999999999999,0,5547]
[null,"Total-OTHER",null,null,{"$f":"SUMIF($A:$A,\"RA-OTHER\",E:E)","v":98717},72344.285444763038,7790.781349179485,9431.7051393482434,3697.2280667092259,5453]
[null,"Total SITUS",null,null,{"$f":"SUMIF($A:$A,\"RA-SITUS\",E:E)","v":21232},18374.535363778741,240.86449979164462,152.64642059685309,3086.9537158327598,-623]
[null,"Total RA",null,null,{"$f":"SUMIF($B:$B,\"182M\",E:E)","v":135618},98535.020808541798,8361.0458489711309,11560.751559945098,6784.1817825419857,10377]
[null,"DDSO2 FACTOR",null,null,{"$f":"SUM(F33:J33)","v":1},{"$f":"F29/$E29","v":0.11177468612147946},{"$f":"G29/$E29","v":3.7258228707159828E-2},{"$f":"H29/$E29","v":0.22354937224295893},{"$f":"I29/$E29","v":0},{"$f":"J29/$E29","v":0.62741771292840176}]
[null,"DDS2 FACTOR",null,null,{"$f":"SUM(F34:J34)","v":0.99999999999999989},{"$f":"F31/$E31","v":0.8654170762895036},{"$f":"G31/$E31","v":1.1344409372251537E-2},{"$f":"H31/$E31","v":7.1894508570484687E-3},{"$f":"I31/$E31","v":0.14539156536514505},{"$f":"J31/$E31","v":-2.9342501883948758E-2}]
[]
[{"$f":"\"DD\"&\"-\"&C36","v":"DD-SE"},"186M","SE","P",13137,{"$f":"VLOOKUP($D36,'Page 13'!$D$21:$J$33,3,FALSE)*$E36","v":13137},{"$f":"VLOOKUP($D36,'Page 13'!$D$21:$J$33,4,FALSE)*$E36","v":0},{"$f":"VLOOKUP($D36,'Page 13'!$D$21:$J$33,5,FALSE)*$E36","v":0},{"$f":"VLOOKUP($D36,'Page 13'!$D$21:$J$33,6,FALSE)*$E36","v":0},{"$f":"VLOOKUP($D36,'Page 13'!$D$21:$J$33,7,FALSE)*$E36","v":0}]
["DD-SG","186M","SG","P",31278,{"$f":"VLOOKUP($D37,'Page 13'!$D$21:$J$33,3,FALSE)*$E37","v":31278},{"$f":"VLOOKUP($D37,'Page 13'!$D$21:$J$33,4,FALSE)*$E37","v":0},{"$f":"VLOOKUP($D37,'Page 13'!$D$21:$J$33,5,FALSE)*$E37","v":0},{"$f":"VLOOKUP($D37,'Page 13'!$D$21:$J$33,6,FALSE)*$E37","v":0},{"$f":"VLOOKUP($D37,'Page 13'!$D$21:$J$33,7,FALSE)*$E37","v":0}]
["DD-SG","186M","SG","T",18006,{"$f":"VLOOKUP($D38,'Page 13'!$D$21:$J$33,3,FALSE)*$E38","v":0},{"$f":"VLOOKUP($D38,'Page 13'!$D$21:$J$33,4,FALSE)*$E38","v":18006},{"$f":"VLOOKUP($D38,'Page 13'!$D$21:$J$33,5,FALSE)*$E38","v":0},{"$f":"VLOOKUP($D38,'Page 13'!$D$21:$J$33,6,FALSE)*$E38","v":0},{"$f":"VLOOKUP($D38,'Page 13'!$D$21:$J$33,7,FALSE)*$E38","v":0}]
["DD-SO","186M","SO","DMSC",0,{"$f":"VLOOKUP($D39,'Page 13'!$D$21:$J$33,3,FALSE)*$E39","v":0},{"$f":"VLOOKUP($D39,'Page 13'!$D$21:$J$33,4,FALSE)*$E39","v":0},{"$f":"VLOOKUP($D39,'Page 13'!$D$21:$J$33,5,FALSE)*$E39","v":0},{"$f":"VLOOKUP($D39,'Page 13'!$D$21:$J$33,6,FALSE)*$E39","v":0},{"$f":"VLOOKUP($D39,'Page 13'!$D$21:$J$33,7,FALSE)*$E39","v":0}]
["DD-SITUS","186M","SITUS","T",0,{"$f":"VLOOKUP($D40,'Page 13'!$D$21:$J$33,3,FALSE)*$E40","v":0},{"$f":"VLOOKUP($D40,'Page 13'!$D$21:$J$33,4,FALSE)*$E40","v":0},{"$f":"VLOOKUP($D40,'Page 13'!$D$21:$J$33,5,FALSE)*$E40","v":0},{"$f":"VLOOKUP($D40,'Page 13'!$D$21:$J$33,6,FALSE)*$E40","v":0},{"$f":"VLOOKUP($D40,'Page 13'!$D$21:$J$33,7,FALSE)*$E40","v":0}]
["DD-SITUS","186M","SITUS","LABOR",0,{"$f":"VLOOKUP($D41,'Page 13'!$D$21:$J$33,3,FALSE)*$E41","v":0},{"$f":"VLOOKUP($D41,'Page 13'!$D$21:$J$33,4,FALSE)*$E41","v":0},{"$f":"VLOOKUP($D41,'Page 13'!$D$21:$J$33,5,FALSE)*$E41","v":0},{"$f":"VLOOKUP($D41,'Page 13'!$D$21:$J$33,6,FALSE)*$E41","v":0},{"$f":"VLOOKUP($D41,'Page 13'!$D$21:$J$33,7,FALSE)*$E41","v":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":49284},31278,18006,0,0,0]
[null,"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"DD-SO\",E:E)","v":0},0,0,0,0,0]
[null,"Total-DD",null,null,{"$f":"SUMIF($B:$B,\"186M\",E:E)","v":62421},44415,18006,0,0,0]
[null,"DDS6 FACTOR",null,null,{"$f":"SUM(F46:J46)","v":0},{"$f":"IFERROR(F42/$E42,0)","v":0},{"$f":"IFERROR(G42/$E42,0)","v":0},{"$f":"IFERROR(H42/$E42,0)","v":0},{"$f":"IFERROR(I42/$E42,0)","v":0},{"$f":"IFERROR(J42/$E42,0)","v":0}]
[null,"DEFSG FACTOR",null,null,{"$f":"SUM(F47:J47)","v":1},{"$f":"F43/$E43","v":0.63464816167518867},{"$f":"G43/$E43","v":0.36535183832481127},{"$f":"H43/$E43","v":0},{"$f":"I43/$E43","v":0},{"$f":"J43/$E43","v":0}]
[null,"DDSO6 FACTOR",null,null,{"$f":"SUM(F48:J48)","v":0},{"$f":"IFERROR(F44/$E44,0)","v":0},{"$f":"IFERROR(G44/$E44,0)","v":0},{"$f":"IFERROR(H44/$E44,0)","v":0},{"$f":"IFERROR(I44/$E44,0)","v":0},{"$f":"IFERROR(J44/$E44,0)","v":0}]

{"sheet":"Page 13","index":12,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,9],[1,1,1,9],[2,1,2,9]]}
[null,{"$f":"+'Page 1'!A1","v":"PacifiCorp"}]
[null,{"$f":"+'Page 1'!A2","v":"12 Months Ended June 2011"}]
[null,"Reg Assets / Deferred Debits"]
[]
[null,"Pri-Acct","Factor","Function","Total","Production","Transmission","DPW","CUST","DMSC"]
[null,"Major Adjustment"]
[null,"1998 Early Retirement",null,"LABOR",0,{"$f":"VLOOKUP($D7,$D$21:$J$33,3,FALSE)*$E7","v":0},{"$f":"VLOOKUP($D7,$D$21:$J$33,4,FALSE)*$E7","v":0},{"$f":"VLOOKUP($D7,$D$21:$J$33,5,FALSE)*$E7","v":0},{"$f":"VLOOKUP($D7,$D$21:$J$33,6,FALSE)*$E7","v":0},{"$f":"VLOOKUP($D7,$D$21:$J$33,7,FALSE)*$E7","v":0}]
[null,"1999 Early Retirement",null,"LABOR",0,{"$f":"VLOOKUP($D8,$D$21:$J$33,3,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,$D$21:$J$33,4,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,$D$21:$J$33,5,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,$D$21:$J$33,6,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,$D$21:$J$33,7,FALSE)*$E8","v":0}]
[null,"Transition Planning",null,"PTD",0,{"$f":"VLOOKUP($D9,$D$21:$J$33,3,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,$D$21:$J$33,4,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,$D$21:$J$33,5,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,$D$21:$J$33,6,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,$D$21:$J$33,7,FALSE)*$E9","v":0}]
[null,"Environmental Clean-up",null,"ESD",0,{"$f":"VLOOKUP($D10,$D$21:$J$33,3,FALSE)*$E10","v":0},{"$f":"VLOOKUP($D10,$D$21:$J$33,4,FALSE)*$E10","v":0},{"$f":"VLOOKUP($D10,$D$21:$J$33,5,FALSE)*$E10","v":0},{"$f":"VLOOKUP($D10,$D$21:$J$33,6,FALSE)*$E10","v":0},{"$f":"VLOOKUP($D10,$D$21:$J$33,7,FALSE)*$E10","v":0}]
[null,"Y2K",null,"PTD",0,{"$f":"VLOOKUP($D11,$D$21:$J$33,3,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,$D$21:$J$33,4,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,$D$21:$J$33,5,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,$D$21:$J$33,6,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,$D$21:$J$33,7,FALSE)*$E11","v":0}]
[null,"Subtotal Major Adjustments",null,null,{"$f":"SUM(E7:E11)","v":0},0,0,0,0,0]
[]
[null,"Total 186M SO",null,null,{"$f":"+'Page 12'!E44+E12","v":0},{"$f":"+'Page 12'!F44+F12","v":0},{"$f":"+'Page 12'!G44+G12","v":0},{"$f":"+'Page 12'!H44+H12","v":0},{"$f":"+'Page 12'!I44+I12","v":0},{"$f":"+'Page 12'!J44+J12","v":0}]
[]
[null,"Total 182 &186",null,null,{"$f":"SUM('Page 12'!E45,'Page 12'!E32)","v":198039},{"$f":"SUM('Page 12'!F32,'Page 12'!F45)","v":142950.0208085418},{"$f":"SUM('Page 12'!G32,'Page 12'!G45)","v":26367.045848971131},{"$f":"SUM('Page 12'!H32,'Page 12'!H45)","v":11560.751559945098},{"$f":"SUM('Page 12'!I32,'Page 12'!I45)","v":6784.1817825419857},{"$f":"SUM('Page 12'!J32,'Page 12'!J45)","v":10377}]
[]
[]
[]
[null,null,null,null,"Total","Production","Transmission","Poles & Wires","Customers","Miscellaneous"]
[null,null,null,"DMSC",{"$f":"SUM(F21:J21)","v":1},0,0,0,0,1]
[null,null,null,"DPW",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,{"$f":"'Page 4'!$E$43","v":0.50926645632842615},{"$f":"'Page 4'!$F$43","v":0.21576006978240711},{"$f":"'Page 4'!$G$43","v":0.26867509095069092},{"$f":"'Page 4'!$H$43","v":6.2983829384758213E-3},{"$f":"'Page 4'!$I$43","v":0}]
[null,null,null,"RETAIL",1,0,0,0,1,0]
[null,null,null,"LABOR",1,{"$f":"'Page 14'!$C$25","v":0.42712904549402431},{"$f":"'Page 14'!$D$25","v":6.855059317608897E-2},{"$f":"'Page 14'!$E$25","v":0.35533822131657783},{"$f":"'Page 14'!$F$25","v":0.14898214001330889},{"$f":"'Page 14'!$G$25","v":0}]
[null,null,null,"P",1,{"$f":"'Page 14'!$C$13","v":1},{"$f":"'Page 14'!$D$13","v":0},{"$f":"'Page 14'!$E$13","v":0},{"$f":"'Page 14'!$F$13","v":0},{"$f":"'Page 14'!$G$13","v":0}]
[null,null,null,"PT",1,{"$f":"'Page 14'!$C$17","v":0.69832856453809478},{"$f":"'Page 14'!$D$17","v":0.30167143546190517},{"$f":"'Page 14'!$E$17","v":0},{"$f":"'Page 14'!$F$17","v":0},{"$f":"'Page 14'!$G$17","v":0}]
[null,null,null,"PTD",1,{"$f":"'Page 14'!$C$16","v":0.50780249568414171},{"$f":"'Page 14'!$D$16","v":0.2193659483276317},{"$f":"'Page 14'!$E$16","v":0.27283155598822667},{"$f":"'Page 14'!$F$16","v":0},{"$f":"'Page 14'!$G$16","v":0}]
[null,null,null,"T",1,{"$f":"'Page 14'!$C$14","v":0},{"$f":"'Page 14'!$D$14","v":1},{"$f":"'Page 14'!$E$14","v":0},{"$f":"'Page 14'!$F$14","v":0},{"$f":"'Page 14'!$G$14","v":0}]
[null,null,null,"TAXDEPR",1,{"$f":"'Page 11'!C24","v":0.57747451163818431},{"$f":"'Page 11'!D24","v":0.1959065237010699},{"$f":"'Page 11'!E24","v":0.22210242530333088},{"$f":"'Page 11'!F24","v":4.516539357414911E-3},{"$f":"'Page 11'!G24","v":0}]
[null,null,null,"TD",1,{"$f":"'Page 14'!$C$18","v":0},{"$f":"'Page 14'!$D$18","v":0.44568683588216201},{"$f":"'Page 14'!$E$18","v":0.55431316411783793},{"$f":"'Page 14'!$F$18","v":0},{"$f":"'Page 14'!$G$18","v":0}]

{"sheet":"Page 14","index":13,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
[{"$f":"+'Page 1'!A1","v":"PacifiCorp"}]
[{"$f":"+'Page 1'!A2","v":"12 Months Ended June 2011"}]
["FERC FORM 1 Funtionalization Factors"]
[]
[]
["Factor","Total","Production","Transmission","DPW","CUST","DMSC"]
[]
["PLANT",{"$f":"SUM(C8:G8)","v":21177828.874217849},{"$f":"+'Page 4'!D9","v":10754154.3554995},{"$f":"+'Page 4'!D10","v":4645694.5145130996},{"$f":"+'Page 4'!D11","v":5777980.0042052502},0,0]
["UNCLASSIFIED PLANT",{"$f":"SUM(C9:G9)","v":0},null,null,null,0,0]
["TOTAL PLANT",{"$f":"SUM(C10:G10)","v":21177828.874217849},{"$f":"C8+C9","v":10754154.3554995},{"$f":"D8+D9","v":4645694.5145130996},{"$f":"E8+E9","v":5777980.0042052502},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.50780249568414171},{"$f":"D10/$B10","v":0.2193659483276317},{"$f":"E10/$B10","v":0.27283155598822667},{"$f":"F10/$B10","v":0},{"$f":"G10/$B10","v":0}]
["PT",1,{"$f":"C10/(C10+D10)","v":0.69832856453809478},{"$f":"D10/(C10+D10)","v":0.30167143546190517}]
["TD",1,null,{"$f":"D10/(D10+E10)","v":0.44568683588216201},{"$f":"E10/(D10+E10)","v":0.55431316411783793}]
[]
[]
[]
[]
["LABOR",{"$f":"SUM(C23:G23)","v":312530804},133490984,21424172,111054140,{"$f":"41273457+5288051","v":46561508},0]
[]
["LABOR %",{"$f":"B23/$B23","v":1},{"$f":"C23/$B23","v":0.42712904549402431},{"$f":"D23/$B23","v":6.855059317608897E-2},{"$f":"E23/$B23","v":0.35533822131657783},{"$f":"F23/$B23","v":0.14898214001330889},{"$f":"G23/$B23","v":0}]
[]
["Source: Ferc Form 1 (Dec 2010) - pg. 354"]
[]
[]
["Material & Supplies",{"$f":"SUM(C30:G30)","v":110731982},93357638,718031,16656313,0,0]
[]
["Material & Supplies %",{"$f":"B30/$B30","v":1},0.84309552049741154,6.4844048397869371E-3,0.15042007466280158,0,0]
[]
["Source: Ferc Form 1 (Dec 2010) - pg. 227 "]
[]
[]
["FERC (mWh)",28449800,{"$f":"B37-D37","v":15285755},13164045,0,0,0]
[]
["FERC %",{"$f":"B37/$B37","v":1},{"$f":"C37/$B37","v":0.53728866283770005},{"$f":"D37/$B37","v":0.4627113371622999},0,0,0]
[]
["Source: FERC reporting requirment No. 582"]