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

{"sheet":"TOTAL FUNCFAC","index":0,"n_rows":72,"n_cols":8,"rows_kept":72,"cut":false,"hidden":false,"merged":[[2,0,2,7]]}
["PacifiCorp"]
["12 Months Ended June 2012"]
["FUNCTIONAL FACTORS "]
[]
[]
["Function","Description","Production","Transmission","DPW","CUST","DMSC","Total"]
["ACCMDIT","Deferred Income Tax",0.79018896309372733,8.1838038938181937E-2,0.12381804895537642,4.1549490127143719E-3,0,1]
["BOOKDEPR","Book Depreciation",0.54924231762625964,0.16151677382348767,0.28605968276493932,3.1812257853132309E-3,0,1]
["COM_EQ","Communication Equipment Acct 397",0,0,0,0,0,0]
["CUST","Distribution Retail",0,0,0,1,0,1]
["CWC","Cash Working Capital",0.69766203958339357,0.16080998255110926,9.5448542467147429E-2,3.8236250128966892E-2,7.8431852693827079E-3,1]
["DDS2","Deferred Debits - Situs",0.85553293171941447,1.076861356747129E-2,1.4751124199191758E-2,0.15777880740653,-3.8831476892607436E-2,1]
["DDS6","Deferred Debits - Situs",0,0,0,0,0,0]
["DDSO2","Deferred Debits - System Overhead",0.10749283238949794,3.5830944129832655E-2,0.21498566477899589,0,0.64169055870167357,1]
["DDSO6","Deferred Debits - System Overhead",0,0,0,0,1,1]
["DEFSG","Deferred Debit - System Generation",0.692942089401404,0.307057910598596,0,0,0,1]
["DITEXP","Deferred Income Tax - Expense",0.95405218631618194,-1.7802878900708932E-2,6.0565025163669579E-2,3.1856674208573287E-3,0,1]
["DMSC","Distribution Miscellaneous",0,0,0,0,1,1]
["DPW","Distribution Poles & Wires",0,0,1,0,0,1]
["ESD","Environmental Services Department",0.3,0.1,0.6,0,0,1]
["FERC","FERC Fees",0.51783654984003269,0.48216345015996731,0,0,0,1]
["FIT","Federal Income Taxes",1.1688844574871449,3.6083766826626958E-2,-0.17764648220792026,-1.7789925998270745E-2,-9.5318161075798238E-3,1]
["G","General Plant",0.33725965480133235,0.18510139570307821,0.45254539034670116,2.509355914888825E-2,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",0.50531041300874846,0.21296464671128551,0.27514783251038133,6.5771077695849136E-3,0,1]
["G-SG","General Plant - SG Factor",0.99898215951822222,1.017840481777828E-3,0,0,0,1]
["G-SITUS","General Plant - SITUS Factor",0,0.25401228549654764,0.74598771450345236,0,0,1]
["I","Intangible Plant",0.55582392599416641,0.14762997154346119,0.14245501010267919,0.15409109235969329,0,1]
["IBT","Income Before Taxes",1.3364001958537777,7.1875093825867972E-2,-0.35385323372358174,-3.5435674064311203E-2,-1.8986381891750555E-2,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",0.85536695399256235,0.14463304600743784,0,0,0,1]
["I-SITUS","Intangible Plant - SITUS Factor",2.5219270088888916E-2,0.45848484838651204,0.51629588152459904,0,0,1]
["LABOR","Direct Labor Expense",0.43577266359732098,7.2028278420365022E-2,0.34638820477027932,0.14581085321203469,0,1]
["MSS","Materials & Supplies",0.78180305398604233,6.0702949940319682E-3,0.21212665101992567,0,0,1]
["NONE","Not Functionalized",0,0,0,0,0,0]
["NUTIL","Non-Utility",0,0,0,0,0,0]
["OTHDGP","Other Revenues - DGP Factor",0.57874764096849529,0.42125235903150471,0,0,0,1]
["OTHDGU","Other Revenues - DGU Factor",0.57874764096849529,0.42125235903150471,0,0,0,1]
["OTHSE","Other Revenues - SE Factor",0,1,0,0,0,1]
["OTHSG","Other Revenues - SG Factor",0.57874764096849529,0.42125235903150471,0,0,0,1]
["OTHSGR","Other Revenues - Rolled-In SG Factor",0.57874764096849529,0.42125235903150471,0,0,0,1]
["OTHSITUS","Other Revenues - SITUS",5.7696681464325496E-3,0,0,0,0.99423033185356746,1]
["OTHSO","Other Revenues - SO Factor",0,0,0,0,1,1]
["P","Production",1,0,0,0,0,1]
["PT","Production / Transmission",0.72098325173517375,0.27901674826482614,0,0,0,1]
["PTD","Prod, Trans, Dist Plant",0.50891728264852409,0.19694832716103053,0.29413439019044535,0,0,1]
["REVREQ","Revenue Requirement",0.67154025321940569,0.1587111156255141,0.1359418575764659,2.8063040845227306E-2,5.7437327333868197E-3,1]
["SCHMA","Schedule M Additions",0.51577805211332484,0.17785176096280442,0.29207769541570439,1.2604298561731647E-2,1.6881929464348014E-3,1]
["SCHMAF","Schedule M Additions - Flow Through",1,0,0,0,0,1]
["SCHMAP","Schedule M Additions - Permanent",0.47220936057207102,0.138624571441712,0.31120786939259704,7.7958198593619923E-2,0,1]
["SCHMAP-SO","Schedule M Additions - Permanent-SO",0.46695715823437201,0.14000406596813605,0.31430479187857707,7.8733983918914854E-2,0,1]
["SCHMAT","Schedule M Additions - Temporary",0.5161602312280279,0.17819585696461496,0.2919098879214701,1.2031022322004977E-2,1.7030015638821614E-3,0]
["SCHMAT-GPS","Schedule M Additions - Temporary-GPS",0,0,0,0,0,0]
["SCHMAT-SE","Schedule M Additions - Temporary-SE",1,0,0,0,0,1]
["SCHMAT-SITUS","Schedule M Additions - Temporary-SITUS",0.68789997808111003,0.1122395497862909,0.16561182938630906,1.0258460638137939E-2,2.3990182108152083E-2,1]
["SCHMAT-SNP","Schedule M Additions - Temporary-SNP",0.50361932616077032,0.21956599431989174,0.27659585057984348,2.1882893949445097E-4,0,1]
["SCHMAT-SO","Schedule M Additions - Temporary-SO",0.46661318737226282,0.13925428020064187,0.31465867797871139,7.9473854448383993E-2,0,1]
["SCHMD","Schedule M Deductions",0.62691120168290648,0.14566463329808196,0.19770155852585497,5.2145868752490132E-3,2.4508019617907648E-2,1]
["SCHMDF","Schedule M Deductions - Flow Through",1,0,0,0,0,1]
["SCHMDP","Schedule M Deductions - Permanent",0.45907602575732509,7.3800298018591851E-2,0.33122834583438432,0.13589533038969875,0,1]
["SCHMDP-SO","Schedule M Deductions - Permanent- SO",0.43577266359732098,7.2028278420365022E-2,0.34638820477027932,0.14581085321203469,0,1]
["SCHMDT","Schedule M Deductions - Temporary",0.62801601740022717,0.14613769770006871,0.19682258609061767,4.3543492129729825E-3,2.4669349596113603E-2,1]
["SCHMDT-GPS","Schedule M Deductions - Temporary-GPS",0.5035611250734281,0.21979318880680054,0.27664568611977131,0,0,1]
["SCHMDT-SG","Schedule M Deductions - Temporary-SG",1,0,0,0,0,1]
["SCHMDT-SITUS","Schedule M Deductions - Temporary-SITUS",0.54030864816472712,7.1658766797031578E-2,0.1871749065492978,6.606595505664814E-2,0.13479172343229553,1]
["SCHMDT-SNP","Schedule M Deductions - Temporary-SNP",0.5035611250734281,0.21979318880680054,0.27664568611977131,0,0,1]
["SCHMDT-SO","Schedule M Deductions - Temporary-SO",0.44271776887128472,0.16081507666864175,0.36653269611301859,2.9934458347055E-2,0,1]
["T","Transmission",0,1,0,0,0,1]
["TAXDEPR ","Tax Depreciation ",0.57503857689425475,0.17851192951080661,0.24137635753524717,5.0731360596915614E-3,0,1]
["TD","Transmission / Distribution",0,0.44273968036711486,0.55726031963288514,0,0,1]

{"sheet":"TAX DEPR","index":1,"n_rows":330,"n_cols":7,"rows_kept":330,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6]]}
[{"$f":"+'TOTAL FUNCFAC'!$A$1","v":"PacifiCorp"}]
[{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended June 2012"}]
["Tax Depreciation"]
[]
[null,"Total","Production","Transmission","Distribution","General","Mining"]
[]
[]
["Total",{"$f":"SUM(C8:G8)","v":1476944796},{"$f":"800033740-G8","v":782816491},244142091,320791443,111977522,17217249]
[]
[]
[]
["Conversion to COS Functions","Total","Pro","Trn","Dis","Retail","Misc"]
[]
["Percent of GenPlant in Functions",{"$f":"SUM(C14:F14)","v":1.0672540996549307},0.47864140923216153,0.18623861198280273,0.33511997878503563,6.7254099654930843E-2,0]
[" (%'s developed in JAM June 2012 - "]
["use \"Total Plant\" variable)"]
[]
["Allocation of GenPlant to Functions",{"$f":"SUM(C18:F18)","v":119508469.42370018},{"$f":"+$F$8*C14","v":53597078.932405367},{"$f":"+$F$8*D14","v":20854538.270553757},{"$f":"+$F$8*E14","v":37525904.797040857},{"$f":"+$F$8*F14","v":7530947.4237002106},{"$f":"+$F$8*G14","v":0}]
["Assignment of Mining to Prod Function",{"$f":"SUM(C19:F19)","v":17217249},{"$f":"G8","v":17217249}]
[]
["Adjusted Totals",{"$f":"SUM(C21:F21)","v":1484475743.4237001},{"$f":"+C8+C18+C19","v":853630818.93240535},{"$f":"+D8+D18+D19","v":264996629.27055377},{"$f":"+E8+E18+E19","v":358317347.79704088},{"$f":"+F18+F19","v":7530947.4237002106},{"$f":"+G18+G19","v":0}]
[]
[]
["TAXDEPR FACTOR",{"$f":"SUM(C24:F24)","v":1.0000000000000002},{"$f":"+C21/$B$21","v":0.57503857689425475},{"$f":"+D21/$B$21","v":0.17851192951080661},{"$f":"+E21/$B$21","v":0.24137635753524717},{"$f":"+F21/$B$21","v":5.0731360596915614E-3},{"$f":"+G21/$B$21","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TAXDEPR Factor",null,{"$f":"#REF!/#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!/#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!/#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!/#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!/#REF!","v":{"$error":"#REF!"}}]

{"sheet":"GROSS PLANT","index":2,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended June 2012"}]
["Gross Plant"]
["(In 000's)"]
[]
[null,"Alloc."]
["Description","Factor","Funct.","Amount","Production","Transmisssion","DPW","CUSTOMER","DMISC"]
[]
["Production Plant",null,"P",10311125.355252501,{"$f":"$D9*VLOOKUP(+$C9,$C$46:$I$52,3)","v":10311125.355252501},{"$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",4500576.0158454096,{"$f":"$D10*VLOOKUP(+$C10,$C$46:$I$52,3)","v":0},{"$f":"$D10*VLOOKUP(+$C10,$C$46:$I$52,4)","v":4500576.0158454096},{"$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",5664711.20691624,{"$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":5664711.20691624},{"$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",290388.75550750003,{"$f":"$D12*VLOOKUP(+$C12,$C$46:$I$52,3)","v":290388.75550750003},{"$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":"'GENERAL PLANT'!B7","v":"CN"},{"$f":"'GENERAL PLANT'!C7","v":"CUST"},{"$f":"'GENERAL PLANT'!D7","v":24957},{"$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":24957},{"$f":"$D14*VLOOKUP(+$C14,$C$46:$I$52,7)","v":0}]
["Utah Mine",{"$f":"'GENERAL PLANT'!B8","v":"SE"},{"$f":"'GENERAL PLANT'!C8","v":"P"},{"$f":"'GENERAL PLANT'!D8","v":646},646,0,0,0,0]
[null,{"$f":"'GENERAL PLANT'!B9","v":"SG"},{"$f":"'GENERAL PLANT'!C9","v":"P"},{"$f":"'GENERAL PLANT'!D9","v":211998},211998,0,0,0,0]
[null,{"$f":"'GENERAL PLANT'!B10","v":"SG"},{"$f":"'GENERAL PLANT'!C10","v":"T"},{"$f":"'GENERAL PLANT'!D10","v":216},0,216,0,0,0]
[null,{"$f":"'GENERAL PLANT'!B12","v":"SO"},{"$f":"'GENERAL PLANT'!C12","v":"DPW"},{"$f":"'GENERAL PLANT'!D12","v":0},0,0,0,0,0]
[null,{"$f":"'GENERAL PLANT'!B16","v":"SG"},{"$f":"'GENERAL PLANT'!C16","v":"P"},{"$f":"'GENERAL PLANT'!D16","v":0},0,0,0,0,0]
[null,{"$f":"'GENERAL PLANT'!B17","v":"SG"},{"$f":"'GENERAL PLANT'!C17","v":"DPW"},{"$f":"'GENERAL PLANT'!D17","v":0},0,0,0,0,0]
[null,{"$f":"'GENERAL PLANT'!B18","v":"SG"},{"$f":"'GENERAL PLANT'!C18","v":"P"},{"$f":"'GENERAL PLANT'!D18","v":0},0,0,0,0,0]
["General Plant",{"$f":"'GENERAL PLANT'!B19","v":"SITUS"},{"$f":"'GENERAL PLANT'!C19","v":"DPW"},{"$f":"'GENERAL PLANT'!D19","v":218642},0,0,218642,0,0]
["General Plant",{"$f":"'GENERAL PLANT'!B20","v":"SITUS"},{"$f":"'GENERAL PLANT'!C20","v":"P"},{"$f":"'GENERAL PLANT'!D20","v":0},0,0,0,0,0]
["General Plant",{"$f":"'GENERAL PLANT'!B21","v":"SITUS"},{"$f":"'GENERAL PLANT'!C21","v":"TD"},{"$f":"'GENERAL PLANT'!D21","v":294275},0,130287.21944003273,163987.78055996727,0,0]
["Total General Plant",null,null,{"$f":"SUBTOTAL(9,D14:D24)","v":750734},212644,130503.21944003273,382629.78055996727,24957,0]
[]
["Intangible Plant"]
["Customer Service Sys",{"$f":"'INTANGIBLE PLANT'!A7","v":"CN"},{"$f":"'INTANGIBLE PLANT'!B7","v":"CUST"},{"$f":"'INTANGIBLE PLANT'!C7","v":121883.89039313339},{"$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":121883.89039313339},{"$f":"$D28*VLOOKUP(+$C28,$C$46:$I$53,7)","v":0}]
["Customer Service Sys",{"$f":"'INTANGIBLE PLANT'!A8","v":"SE"},{"$f":"'INTANGIBLE PLANT'!B8","v":"P"},{"$f":"'INTANGIBLE PLANT'!C8","v":3661.7304949999898},3661.7304949999898,0,0,0,0]
["Washington Hydro",{"$f":"'INTANGIBLE PLANT'!A9","v":"SG"},{"$f":"'INTANGIBLE PLANT'!B9","v":"P"},{"$f":"'INTANGIBLE PLANT'!C9","v":0},0,0,0,0,0]
["Utah Hydro",{"$f":"'INTANGIBLE PLANT'!A10","v":"SG"},{"$f":"'INTANGIBLE PLANT'!B10","v":"T"},{"$f":"'INTANGIBLE PLANT'!C10","v":47608},0,47608,0,0,0]
["Colorado Steam-UPD",{"$f":"'INTANGIBLE PLANT'!A11","v":"SG"},{"$f":"'INTANGIBLE PLANT'!B11","v":"P"},{"$f":"'INTANGIBLE PLANT'!C11","v":232664.63015916551},232664.63015916551,0,0,0,0]
[null,{"$f":"'INTANGIBLE PLANT'!A12","v":"SG"},{"$f":"'INTANGIBLE PLANT'!B12","v":"P"},{"$f":"'INTANGIBLE PLANT'!C12","v":48891.42545749995},48891.42545749995,0,0,0,0]
["Oregon Trans",{"$f":"'INTANGIBLE PLANT'!A15","v":"SO"},{"$f":"'INTANGIBLE PLANT'!B15","v":"P"},{"$f":"'INTANGIBLE PLANT'!C15","v":29274.9517208332},29274.9517208332,0,0,0,0]
["Utah Mine",{"$f":"'INTANGIBLE PLANT'!A16","v":"SO"},{"$f":"'INTANGIBLE PLANT'!B16","v":"PTD"},{"$f":"'INTANGIBLE PLANT'!C16","v":303714.48168208246},152938.80609692252,66754.374415709521,84021.301169450424,0,0]
["Utah",{"$f":"'INTANGIBLE PLANT'!A17","v":"SO"},{"$f":"'INTANGIBLE PLANT'!B17","v":"TD"},{"$f":"'INTANGIBLE PLANT'!C17","v":12687.82280125},0,5617.402611580017,7070.4201896699833,0,0]
["Utah G/O",{"$f":"'INTANGIBLE PLANT'!A18","v":"SO"},{"$f":"'INTANGIBLE PLANT'!B18","v":"LABOR"},{"$f":"'INTANGIBLE PLANT'!C18","v":0},0,0,0,0,0]
["Utah G/O",{"$f":"'INTANGIBLE PLANT'!A23","v":"SITUS"},{"$f":"'INTANGIBLE PLANT'!B23","v":"TD"},{"$f":"'INTANGIBLE PLANT'!C23","v":8135.8640895833278},0,3602.0698665324103,4533.794223050917,0,0]
["Total Intangible Plant",null,null,{"$f":"SUBTOTAL(9,D28:D38)","v":808522.79679854773},467431.54392942111,123581.84689382196,95625.515582171327,121883.89039313339,0]
[]
["Total Gross Plant",null,null,{"$f":"SUBTOTAL(9,D8:D39)","v":22326058.130320195},11281589.654689424,4754661.0821792642,6142966.5030583786,146840.89039313339,0]
[]
[null,"GP Factor",null,{"$f":"SUM(E43:I43)","v":1.0000000000000002},{"$f":"E41/$D41","v":0.50531041300874846},{"$f":"F41/$D41","v":0.21296464671128551},{"$f":"G41/$D41","v":0.27514783251038133},{"$f":"H41/$D41","v":6.5771077695849136E-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":"'FORM 1'!$C$13","v":1},{"$f":"'FORM 1'!$D$13","v":0},{"$f":"'FORM 1'!$E$13","v":0},{"$f":"'FORM 1'!$F$13","v":0},{"$f":"'FORM 1'!$G$13","v":0}]
[null,null,"T",{"$f":"SUM(E48:F48)","v":1},{"$f":"'FORM 1'!$C$14","v":0},{"$f":"'FORM 1'!$D$14","v":1},{"$f":"'FORM 1'!$E$14","v":0},{"$f":"'FORM 1'!$F$14","v":0},{"$f":"'FORM 1'!$G$14","v":0}]
[null,null,"TD",{"$f":"SUM(E49:I49)","v":1},{"$f":"'FORM 1'!$C$18","v":0},{"$f":"'FORM 1'!$D$18","v":0.44273968036711486},{"$f":"'FORM 1'!$E$18","v":0.55726031963288514},{"$f":"'FORM 1'!$F$18","v":0},{"$f":"'FORM 1'!$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":"'FORM 1'!$C$16","v":0.5035611250734281},{"$f":"'FORM 1'!$D$16","v":0.21979318880680054},{"$f":"'FORM 1'!$E$16","v":0.27664568611977131},{"$f":"'FORM 1'!$F$16","v":0},{"$f":"'FORM 1'!$G$16","v":0}]
[null,null,"LABOR",{"$f":"SUM(E53:I53)","v":1},{"$f":"'SCH M'!F140","v":0.43577266359732098},{"$f":"'SCH M'!G140","v":7.2028278420365022E-2},{"$f":"'SCH M'!H140","v":0.34638820477027932},{"$f":"'SCH M'!I140","v":0.14581085321203469},{"$f":"'SCH M'!J140","v":0}]

{"sheet":"FORM 1","index":3,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
[{"$f":"+'TOTAL FUNCFAC'!A1","v":"PacifiCorp"}]
[{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended June 2012"}]
["FERC FORM 1 Funtionalization Factors"]
[]
[]
["Factor","Total","Production","Transmission","DPW","CUST","DMSC"]
[]
["PLANT",{"$f":"SUM(C8:G8)","v":20476412.57801415},{"$f":"+'GROSS PLANT'!D9","v":10311125.355252501},{"$f":"+'GROSS PLANT'!D10","v":4500576.0158454096},{"$f":"+'GROSS PLANT'!D11","v":5664711.20691624},0,0]
["UNCLASSIFIED PLANT",{"$f":"SUM(C9:G9)","v":0},null,null,null,0,0]
["TOTAL PLANT",{"$f":"SUM(C10:G10)","v":20476412.57801415},{"$f":"C8+C9","v":10311125.355252501},{"$f":"D8+D9","v":4500576.0158454096},{"$f":"E8+E9","v":5664711.20691624},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.5035611250734281},{"$f":"D10/$B10","v":0.21979318880680054},{"$f":"E10/$B10","v":0.27664568611977131},{"$f":"F10/$B10","v":0},{"$f":"G10/$B10","v":0}]
["PT",1,{"$f":"C10/(C10+D10)","v":0.69614726201357335},{"$f":"D10/(C10+D10)","v":0.30385273798642665}]
["TD",1,null,{"$f":"D10/(D10+E10)","v":0.44273968036711486},{"$f":"E10/(D10+E10)","v":0.55726031963288514}]
[]
[]
[]
[]
["LABOR",{"$f":"SUM(C23:G23)","v":315263720},{"$f":"137383311","v":137383311},{"$f":"22707903","v":22707903},109203634,{"$f":"40029642+5939230","v":45968872},0]
[]
["LABOR %",{"$f":"B23/$B23","v":1},{"$f":"C23/$B23","v":0.43577266359732098},{"$f":"D23/$B23","v":7.2028278420365022E-2},{"$f":"E23/$B23","v":0.34638820477027932},{"$f":"F23/$B23","v":0.14581085321203469},{"$f":"G23/$B23","v":0}]
[]
["Source: Ferc Form 1 (Dec 2011) - pg. 354"]
[]
[]
["Material & Supplies",{"$f":"SUM(C30:G30)","v":83578640},65342036,507347,17729257,0,0]
[]
["Material & Supplies %",{"$f":"B30/$B30","v":1},0.78180305398604233,6.0702949940319682E-3,0.21212665101992567,0,0]
[]
["Source: Ferc Form 1 (Dec 2011) - pg. 227, Total Company"]
[]
[]
["FERC (mWh)",30244302,{"$f":"B37-D37","v":15661605},14582697,0,0,0]
[]
["FERC %",{"$f":"B37/$B37","v":1},{"$f":"C37/$B37","v":0.51783654984003269},{"$f":"D37/$B37","v":0.48216345015996731},0,0,0]
[]
["Source: FERC reporting requirment No. 582 - (from Transmissio Dept., 10-08-12)"]

{"sheet":"BOOKDPR","index":4,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6]]}
[{"$f":"+'TOTAL FUNCFAC'!$A$1","v":"PacifiCorp"}]
[{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended June 2012"}]
["Depreciation Expense"]
[]
[]
["Function","Amount","Production","Transmission","DPW","CUST","DMSC"]
["CUST",1748.0886100000012,{"$f":"VLOOKUP($A7,$A$16:$G$22,3,FALSE)*$B7","v":0},{"$f":"VLOOKUP($A7,$A$16:$G$22,4,FALSE)*$B7","v":0},{"$f":"VLOOKUP($A7,$A$16:$G$22,5,FALSE)*$B7","v":0},{"$f":"VLOOKUP($A7,$A$16:$G$22,6,FALSE)*$B7","v":1748.0886100000012},{"$f":"VLOOKUP($A7,$A$16:$G$22,7,FALSE)*$B7","v":0}]
["DPW",153055.8875000001,{"$f":"VLOOKUP($A8,$A$16:$G$22,3,FALSE)*$B8","v":0},{"$f":"VLOOKUP($A8,$A$16:$G$22,4,FALSE)*$B8","v":0},{"$f":"VLOOKUP($A8,$A$16:$G$22,5,FALSE)*$B8","v":153055.8875000001},{"$f":"VLOOKUP($A8,$A$16:$G$22,6,FALSE)*$B8","v":0},{"$f":"VLOOKUP($A8,$A$16:$G$22,7,FALSE)*$B8","v":0}]
["P",{"$f":"273964+354+13171+836+5959","v":294284},{"$f":"VLOOKUP($A9,$A$16:$G$22,3,FALSE)*$B9","v":294284},{"$f":"VLOOKUP($A9,$A$16:$G$22,4,FALSE)*$B9","v":0},{"$f":"VLOOKUP($A9,$A$16:$G$22,5,FALSE)*$B9","v":0},{"$f":"VLOOKUP($A9,$A$16:$G$22,6,FALSE)*$B9","v":0},{"$f":"VLOOKUP($A9,$A$16:$G$22,7,FALSE)*$B9","v":0}]
["PTD",14944.608490000241,{"$f":"VLOOKUP($A10,$A$16:$G$22,3,FALSE)*$B10","v":7525.5238650064266},{"$f":"VLOOKUP($A10,$A$16:$G$22,4,FALSE)*$B10","v":3284.7231554863374},{"$f":"VLOOKUP($A10,$A$16:$G$22,5,FALSE)*$B10","v":4134.3614695074757},{"$f":"VLOOKUP($A10,$A$16:$G$22,6,FALSE)*$B10","v":0},{"$f":"VLOOKUP($A10,$A$16:$G$22,7,FALSE)*$B10","v":0}]
["T",85469,{"$f":"VLOOKUP($A11,$A$16:$G$22,3,FALSE)*$B11","v":0},{"$f":"VLOOKUP($A11,$A$16:$G$22,4,FALSE)*$B11","v":85469},{"$f":"VLOOKUP($A11,$A$16:$G$22,5,FALSE)*$B11","v":0},{"$f":"VLOOKUP($A11,$A$16:$G$22,6,FALSE)*$B11","v":0},{"$f":"VLOOKUP($A11,$A$16:$G$22,7,FALSE)*$B11","v":0}]
["Book Depreciation",{"$f":"SUM(B7:B11)","v":549501.58460000041},301809.5238650064,88753.723155486339,157190.24896950758,1748.0886100000012,0]
["BookDepr Factor",{"$f":"B12/$B12","v":1},0.54924231762625964,0.16151677382348767,0.28605968276493932,3.1812257853132309E-3,0]
[]
[]
["P",{"$f":"'FORM 1'!$B$13","v":1},{"$f":"'FORM 1'!$C$13","v":1},{"$f":"'FORM 1'!$D$13","v":0},{"$f":"'FORM 1'!$E$13","v":0},{"$f":"'FORM 1'!$F$13","v":0},{"$f":"'FORM 1'!$G$13","v":0}]
["T",{"$f":"'FORM 1'!$B$14","v":1},{"$f":"'FORM 1'!$C$14","v":0},{"$f":"'FORM 1'!$D$14","v":1},{"$f":"'FORM 1'!$E$14","v":0},{"$f":"'FORM 1'!$F$14","v":0},{"$f":"'FORM 1'!$G$14","v":0}]
["DPW",{"$f":"'FORM 1'!$B$15","v":1},{"$f":"'FORM 1'!$C$15","v":0},{"$f":"'FORM 1'!$D$15","v":0},{"$f":"'FORM 1'!$E$15","v":1},{"$f":"'FORM 1'!$F$15","v":0},{"$f":"'FORM 1'!$G$15","v":0}]
["CUST",{"$f":"'FORM 1'!$B$15","v":1},0,0,0,1,0]
["PTD",{"$f":"'FORM 1'!$B$16","v":1},{"$f":"'FORM 1'!$C$16","v":0.5035611250734281},{"$f":"'FORM 1'!$D$16","v":0.21979318880680054},{"$f":"'FORM 1'!$E$16","v":0.27664568611977131},{"$f":"'FORM 1'!$F$16","v":0},{"$f":"'FORM 1'!$G$16","v":0}]
["TD",{"$f":"'FORM 1'!$B$18","v":1},{"$f":"'FORM 1'!$C$18","v":0},{"$f":"'FORM 1'!$D$18","v":0.44273968036711486},{"$f":"'FORM 1'!$E$18","v":0.55726031963288514},{"$f":"'FORM 1'!$F$18","v":0},{"$f":"'FORM 1'!$G$18","v":0}]
["G",{"$f":"'GENERAL PLANT'!$D$38","v":0.99999999999999989},{"$f":"'GENERAL PLANT'!$E$38","v":0.33725965480133235},{"$f":"'GENERAL PLANT'!$F$38","v":0.18510139570307821},{"$f":"'GENERAL PLANT'!$G$38","v":0.45254539034670116},{"$f":"'GENERAL PLANT'!$H$38","v":2.509355914888825E-2},{"$f":"'GENERAL PLANT'!$I$38","v":0}]

{"sheet":"OTHER REVENUE","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":"+'TOTAL FUNCFAC'!A1","v":"PacifiCorp"}]
[{"$f":"+'TOTAL FUNCFAC'!A2:A2","v":"12 Months Ended June 2012"}]
["Account 456"]
[]
["Main"]
["Account","Factor","Function","Amount","Production","Transmission","DPW","Customer","DMSC"]
["456","OTHER","DMSC",1869.8776800000001,{"$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":1869.8776800000001}]
["456","SG","P",31655.817439999999,{"$f":"$D8*VLOOKUP(+$C8,$C$29:$I36,3,FALSE)","v":31655.817439999999},{"$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",11357.47502,{"$f":"$D9*VLOOKUP(+$C9,$C$29:$I37,3,FALSE)","v":0},{"$f":"$D9*VLOOKUP(+$C9,$C$29:$I37,4,FALSE)","v":11357.47502},{"$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",55129.9460599999,{"$f":"$D10*VLOOKUP(+$C10,$C$29:$I38,3,FALSE)","v":55129.9460599999},{"$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",63168.650749999899,{"$f":"$D11*VLOOKUP(+$C11,$C$29:$I38,3,FALSE)","v":0},{"$f":"$D11*VLOOKUP(+$C11,$C$29:$I38,4,FALSE)","v":63168.650749999899},{"$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",-26.572119999999899,{"$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":-26.572119999999899}]
["456","SITUS","DMSC",51572.201209999999,{"$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":51572.201209999999}]
["456","SITUS","P",299.28124000000003,{"$f":"$D14*VLOOKUP(+$C14,$C$29:$I41,3,FALSE)","v":299.28124000000003},{"$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":51871.482449999996},299.28124000000003,0,0,0,51572.201209999999]
["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":11357.47502},0,11357.47502,0,0,0]
["Total SG Revenues",null,null,{"$f":"SUMIF($B:$B,\"SG\",D:D)","v":149954.4142499998},86785.763499999899,63168.650749999899,0,0,0]
["Total SO Revenues",null,null,{"$f":"SUMIF($B:$B,\"SO\",D:D)","v":-26.572119999999899},0,0,0,0,-26.572119999999899]
["Total Operation",null,null,{"$f":"SUM(D7:D14)","v":215026.6772799998},87085.044739999896,74526.125769999897,0,0,53415.50677]
["OTHSITUS",null,null,{"$f":"SUM(E21:I21)","v":1},{"$f":"E15/$D$15","v":5.7696681464325496E-3},{"$f":"F15/$D$15","v":0},{"$f":"G15/$D$15","v":0},{"$f":"H15/$D$15","v":0},{"$f":"I15/$D$15","v":0.99423033185356746}]
["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.57874764096849529},{"$f":"F18/$D$18","v":0.42125235903150471},{"$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.40499646760853292},{"$f":"F20/$D$20","v":0.34659013808298178},{"$f":"G20/$D$20","v":0},{"$f":"H20/$D$20","v":0},{"$f":"I20/$D$20","v":0.24841339430848527}]
[]
[null,null,null,"Total","Prod","Trans","DPW","CUST","DMSC"]
[null,null,"P",{"$f":"SUM(E29:I29)","v":1},{"$f":"'FORM 1'!$C$13","v":1},{"$f":"'FORM 1'!$D$13","v":0},{"$f":"'FORM 1'!$E$13","v":0},{"$f":"'FORM 1'!$F$13","v":0},{"$f":"'FORM 1'!$G$13","v":0}]
[null,null,"T",{"$f":"SUM(E30:I30)","v":1},{"$f":"'FORM 1'!$C$14","v":0},{"$f":"'FORM 1'!$D$14","v":1},{"$f":"'FORM 1'!$E$14","v":0},{"$f":"'FORM 1'!$F$14","v":0},{"$f":"'FORM 1'!$G$14","v":0}]
[null,null,"TD",1,{"$f":"'FORM 1'!$C$18","v":0},{"$f":"'FORM 1'!$D$18","v":0.44273968036711486},{"$f":"'FORM 1'!$E$18","v":0.55726031963288514},{"$f":"'FORM 1'!$F$18","v":0},{"$f":"'FORM 1'!$G$18","v":0}]
[null,null,"CUST",1,0,0,0,1,0]
[null,null,"DPW",1,0,0,1,0,0]
[null,null,"PTD",1,{"$f":"'FORM 1'!$C$16","v":0.5035611250734281},{"$f":"'FORM 1'!$D$16","v":0.21979318880680054},{"$f":"'FORM 1'!$E$16","v":0.27664568611977131},{"$f":"'FORM 1'!$F$16","v":0},{"$f":"'FORM 1'!$G$16","v":0}]
[null,null,"DMSC",1,0,0,0,0,1]

{"sheet":"GENERAL PLANT","index":6,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'TOTAL FUNCFAC'!$A$1","v":"PacifiCorp"}]
[{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended June 2012"}]
["General Plant"]
[]
[null,"Alloc."]
["Description","Factor","Funct.","Amount","Prod","Trans","DPW","CUST","DMISC"]
["Business Centers","CN","CUST",24957,{"$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":24957},{"$f":"$D7*VLOOKUP(+$C7,$B$45:$H$51,7)","v":0}]
[null,"SE","P",{"$f":"641+5","v":646},646,0,0,0,0]
[null,"SG","P",{"$f":"152342+44149+15507","v":211998},211998,0,0,0,0]
[null,"SG","T",{"$f":"32+45+139","v":216},0,216,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",243824,122780.28775990353,53590.854467629339,67452.85777246712,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",218642,0,0,218642,0,0]
[null,"SITUS","P",0,0,0,0,0,0]
[null,"SITUS","TD",294275,0,130287.21944003273,163987.78055996727,0,0]
["Total-CUST",null,null,{"$f":"SUMIF($C:$C,\"CUST\",D:D)","v":24957},0,0,0,24957,0]
["Total-TD",null,null,{"$f":"SUMIF($C:$C,\"TD\",D:D)","v":294275},0,130287.21944003273,163987.78055996727,0,0]
["Total-PTD",null,null,{"$f":"SUMIF($C:$C,\"PTD\",D:D)","v":243824},122780.28775990353,53590.854467629339,67452.85777246712,0,0]
["Total-DPW",null,null,{"$f":"SUMIF($C:$C,\"DPW\",D:D)","v":218642},0,0,218642,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":212214},211998,216,0,0,0]
["Total-SE",null,null,{"$f":"SUMIF($B:$B,\"SE\",D:D)","v":646},646,0,0,0,0]
["Total-G-Situs",null,null,{"$f":"SUMIF($B:$B,\"SITUS\",D:D)","v":512917},0,130287.21944003273,382629.78055996727,0,0]
["Total-SO",null,null,{"$f":"SUMIF($B:$B,\"SO\",D:D)","v":243824},122780.28775990353,53590.854467629339,67452.85777246712,0,0]
["Total-General Plant",null,null,{"$f":"SUM(D7:D21)","v":994558},335424.28775990353,184094.07390766207,450082.63833243441,24957,0]
[]
["G-SG Factor",null,null,{"$f":"SUM(E34:I34)","v":1},{"$f":"E28/$D$28","v":0.99898215951822222},{"$f":"F28/$D$28","v":1.017840481777828E-3},{"$f":"G28/$D$28","v":0},{"$f":"H28/$D$28","v":0},{"$f":"I28/$D$28","v":0}]
[".",null,null,{"$f":"SUM(E35:I35)","v":1},{"$f":"E29/$D$29","v":1},{"$f":"F29/$D$29","v":0},{"$f":"G29/$D$29","v":0},{"$f":"H29/$D$29","v":0},{"$f":"I29/$D$29","v":0}]
["G-SITUS Factor",null,null,{"$f":"SUM(E36:I36)","v":1},{"$f":"E30/$D$30","v":0},{"$f":"F30/$D$30","v":0.25401228549654764},{"$f":"G30/$D$30","v":0.74598771450345236},{"$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.5035611250734281},{"$f":"F31/$D$31","v":0.21979318880680054},{"$f":"G31/$D$31","v":0.27664568611977131},{"$f":"H31/$D$31","v":0},{"$f":"I31/$D$31","v":0}]
["G Allocator",null,null,{"$f":"SUM(E38:I38)","v":0.99999999999999989},{"$f":"E32/$D$32","v":0.33725965480133235},{"$f":"F32/$D$32","v":0.18510139570307821},{"$f":"G32/$D$32","v":0.45254539034670116},{"$f":"H32/$D$32","v":2.509355914888825E-2},{"$f":"I32/$D$32","v":0}]
["Total Gen. Plant",null,null,{"$f":"D32","v":994558}]
["Mining",null,"acct 399 from JAM",{"$f":"'GROSS PLANT'!D12","v":290388.75550750003},{"$f":"D29","v":646},{"$f":"SUM(D40+E40)","v":291034.75550750003}]
["Total ",null,"P",{"$f":"SUM(D39:D40)","v":1284946.7555074999}]
[]
[]
[null,"Functional Allocators:",null,"Prod","Trans","DPW","CUST","DMISC"]
[null,"P",{"$f":"SUM(D45:H45)","v":1},{"$f":"'FORM 1'!$C$13","v":1},{"$f":"'FORM 1'!$D$13","v":0},{"$f":"'FORM 1'!$E$13","v":0},{"$f":"'FORM 1'!$F$13","v":0},{"$f":"'FORM 1'!$G$13","v":0}]
[null,"T",1,{"$f":"'FORM 1'!$C$14","v":0},{"$f":"'FORM 1'!$D$14","v":1},{"$f":"'FORM 1'!$E$14","v":0},{"$f":"'FORM 1'!$F$14","v":0},{"$f":"'FORM 1'!$G$14","v":0}]
[null,"TD",1,{"$f":"'FORM 1'!$C$18","v":0},{"$f":"'FORM 1'!$D$18","v":0.44273968036711486},{"$f":"'FORM 1'!$E$18","v":0.55726031963288514},{"$f":"'FORM 1'!$F$18","v":0},{"$f":"'FORM 1'!$G$18","v":0}]
[null,"CUST",1,0,0,0,1,0]
[null,"DPW",1,0,0,1,0,0]
[null,"PTD",1,{"$f":"'FORM 1'!$C$16","v":0.5035611250734281},{"$f":"'FORM 1'!$D$16","v":0.21979318880680054},{"$f":"'FORM 1'!$E$16","v":0.27664568611977131},{"$f":"'FORM 1'!$F$16","v":0},{"$f":"'FORM 1'!$G$16","v":0}]
[null,"GP",{"$f":"SUM(D51:H51)","v":1.0000000000000002},{"$f":"+'GROSS PLANT'!E43","v":0.50531041300874846},{"$f":"+'GROSS PLANT'!F43","v":0.21296464671128551},{"$f":"+'GROSS PLANT'!G43","v":0.27514783251038133},{"$f":"+'GROSS PLANT'!H43","v":6.5771077695849136E-3},{"$f":"+'GROSS PLANT'!I43","v":0}]

{"sheet":"INTANGIBLE PLANT","index":7,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'TOTAL FUNCFAC'!A1","v":"PacifiCorp"}]
[{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended June 2012"}]
["Intangible Plant"]
["(In 000's)"]
["Alloc."]
["Factor","Funct.","Amount","Production","Transmisssion","DPW","Customer","DMSC"]
["CN","CUST",121883.89039313339,{"$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":121883.89039313339},{"$f":"$C7*VLOOKUP(+$B7,$B$37:$H$44,7)","v":0}]
["SE","P",3661.7304949999898,3661.7304949999898,0,0,0,0]
["SG","P",0,0,0,0,0,0]
["SG","T",{"$f":"26860+19167+1581","v":47608},0,47608,0,0,0]
["SG","P",232664.63015916551,232664.63015916551,0,0,0,0]
["SG","P",48891.42545749995,48891.42545749995,0,0,0,0]
["SO","CUST",7766.7513899999994,0,0,0,7766.7513899999994,0]
["SO","DPW",23999.95691999999,0,0,23999.95691999999,0,0]
["SO","P",29274.9517208332,29274.9517208332,0,0,0,0]
["SO","PTD",303714.48168208246,152938.80609692252,66754.374415709521,84021.301169450424,0,0]
["SO","TD",12687.82280125,0,5617.402611580017,7070.4201896699833,0,0]
["SO","LABOR",0,0,0,0,0,0]
["SO","DMSC",0,0,0,0,0,0]
["SITUS","DPW",106.72728333333301,0,0,106.72728333333301,0,0]
["SITUS","PTD",462.55360999999999,232.92401625837567,101.66613293599718,127.96346080562711,0,0]
["SITUS","T",530.80893000000003,0,530.80893000000003,0,0,0]
["SITUS","TD",8135.8640895833278,0,3602.0698665324103,4533.794223050917,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":329164.0556166654},{"$f":"SUMIF($A:$A,\"SG\",D:D)","v":281556.05561666546},47608,0,0,0]
["Total-SITUS",null,{"$f":"SUMIF($A:$A,\"SITUS\",C:C)","v":9235.9539129166606},{"$f":"SUMIF($A:$A,\"SITUS\",D:D)","v":232.92401625837567},4234.5449294684076,4768.4849671898774,0,0]
["Total-Intangible",null,{"$f":"SUM(C7:C23)","v":841389.59493188106},{"$f":"SUM(D7:D23)","v":467664.4679456795},124214.32195675795,119860.16324631027,129650.6417831334,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.0000000000000002},{"$f":"D26/$C$26","v":0.85536695399256235},{"$f":"E26/$C$26","v":0.14463304600743784},{"$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":1},{"$f":"D27/$C$27","v":2.5219270088888916E-2},{"$f":"E27/$C$27","v":0.45848484838651204},{"$f":"F27/$C$27","v":0.51629588152459904},{"$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.55582392599416641},{"$f":"E28/$C$28","v":0.14762997154346119},{"$f":"F28/$C$28","v":0.14245501010267919},{"$f":"G28/$C$28","v":0.15409109235969329},{"$f":"H28/$C$28","v":0}]
[]
[]
[null,"Functional Allocators:",null,"Prod","Trans","DPW","CUST","DMSC"]
[null,"P",{"$f":"SUM(D37:H37)","v":1},{"$f":"'FORM 1'!$C$13","v":1},{"$f":"'FORM 1'!$D$13","v":0},{"$f":"'FORM 1'!$E$13","v":0},{"$f":"'FORM 1'!$F$13","v":0},{"$f":"'FORM 1'!$G$13","v":0}]
[null,"T",1,{"$f":"'FORM 1'!$C$14","v":0},{"$f":"'FORM 1'!$D$14","v":1},{"$f":"'FORM 1'!$E$14","v":0},{"$f":"'FORM 1'!$F$14","v":0},{"$f":"'FORM 1'!$G$14","v":0}]
[null,"TD",1,{"$f":"'FORM 1'!$C$18","v":0},{"$f":"'FORM 1'!$D$18","v":0.44273968036711486},{"$f":"'FORM 1'!$E$18","v":0.55726031963288514},{"$f":"'FORM 1'!$F$18","v":0},{"$f":"'FORM 1'!$G$18","v":0}]
[null,"CUST",1,0,0,0,1,0]
[null,"DPW",1,0,0,1,0,0]
[null,"PTD",1,{"$f":"'FORM 1'!$C$16","v":0.5035611250734281},{"$f":"'FORM 1'!$D$16","v":0.21979318880680054},{"$f":"'FORM 1'!$E$16","v":0.27664568611977131},{"$f":"'FORM 1'!$F$16","v":0},{"$f":"'FORM 1'!$G$16","v":0}]
[null,"DMSC",1,{"$f":"'TOTAL FUNCFAC'!C18","v":0},{"$f":"'TOTAL FUNCFAC'!D18","v":0},{"$f":"'TOTAL FUNCFAC'!E18","v":0},{"$f":"'TOTAL FUNCFAC'!F18","v":0},{"$f":"'TOTAL FUNCFAC'!G18","v":1}]
[null,"LABOR",{"$f":"SUM(D44:H44)","v":1},{"$f":"'SCH M'!F140","v":0.43577266359732098},{"$f":"'SCH M'!G140","v":7.2028278420365022E-2},{"$f":"'SCH M'!H140","v":0.34638820477027932},{"$f":"'SCH M'!I140","v":0.14581085321203469},{"$f":"'SCH M'!J140","v":0}]

{"sheet":"SCH M","index":8,"n_rows":146,"n_cols":10,"rows_kept":146,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"+'TOTAL FUNCFAC'!A1","v":"PacifiCorp"}]
[null,{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended June 2012"}]
[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",0,{"$f":"VLOOKUP($D7,$D$135:$J$146,3,FALSE)*$E7","v":0},{"$f":"VLOOKUP($D7,$D$135:$J$146,4,FALSE)*$E7","v":0},{"$f":"VLOOKUP($D7,$D$135:$J$146,5,FALSE)*$E7","v":0},{"$f":"VLOOKUP($D7,$D$135:$J$146,6,FALSE)*$E7","v":0},{"$f":"VLOOKUP($D7,$D$135:$J$146,7,FALSE)*$E7","v":0}]
[{"$f":"IF(C8=\"\",\"\",B8&\"-\"&C8)","v":"SCHMAP-SE"},"SCHMAP","SE","P",82.06,{"$f":"VLOOKUP($D8,$D$135:$J$146,3,FALSE)*$E8","v":82.06},{"$f":"VLOOKUP($D8,$D$135:$J$146,4,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,$D$135:$J$146,5,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,$D$135:$J$146,6,FALSE)*$E8","v":0},{"$f":"VLOOKUP($D8,$D$135:$J$146,7,FALSE)*$E8","v":0}]
[{"$f":"IF(C9=\"\",\"\",B9&\"-\"&C9)","v":"SCHMAP-OTHER"},"SCHMAP","OTHER","P",-7.1369999999999996,{"$f":"VLOOKUP($D9,$D$135:$J$146,3,FALSE)*$E9","v":-7.1369999999999996},{"$f":"VLOOKUP($D9,$D$135:$J$146,4,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,$D$135:$J$146,5,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,$D$135:$J$146,6,FALSE)*$E9","v":0},{"$f":"VLOOKUP($D9,$D$135:$J$146,7,FALSE)*$E9","v":0}]
[{"$f":"IF(C10=\"\",\"\",B10&\"-\"&C10)","v":"SCHMAP-SO"},"SCHMAP","SO","LABOR",4065.442,{"$f":"VLOOKUP($D10,$D$135:$J$146,3,FALSE)*$E10","v":1771.6084890404197},{"$f":"VLOOKUP($D10,$D$135:$J$146,4,FALSE)*$E10","v":292.82678827784559},{"$f":"VLOOKUP($D10,$D$135:$J$146,5,FALSE)*$E10","v":1408.2211559776938},{"$f":"VLOOKUP($D10,$D$135:$J$146,6,FALSE)*$E10","v":592.78556670404066},{"$f":"VLOOKUP($D10,$D$135:$J$146,7,FALSE)*$E10","v":0}]
[{"$f":"IF(C11=\"\",\"\",B11&\"-\"&C11)","v":"SCHMAP-SO"},"SCHMAP","SO","PTD",3463.5250000000005,{"$f":"VLOOKUP($D11,$D$135:$J$146,3,FALSE)*$E11","v":1744.0965457199454},{"$f":"VLOOKUP($D11,$D$135:$J$146,4,FALSE)*$E11","v":761.25920426207392},{"$f":"VLOOKUP($D11,$D$135:$J$146,5,FALSE)*$E11","v":958.16925001798108},{"$f":"VLOOKUP($D11,$D$135:$J$146,6,FALSE)*$E11","v":0},{"$f":"VLOOKUP($D11,$D$135:$J$146,7,FALSE)*$E11","v":0}]
[]
[{"$f":"IF(C13=\"\",\"\",B13&\"-\"&C13)","v":""},"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"SCHMAP-SO\",E:E)","v":7528.9670000000006},3515.7050347603654,1054.0859925399195,2366.3904059956749,592.78556670404066,0]
[{"$f":"IF(C14=\"\",\"\",B14&\"-\"&C14)","v":""},"Total SCHMAP",null,null,{"$f":"SUMIF($B:$B,\"SCHMAP\",E:E)","v":7603.89},3590.6280347603652,1054.0859925399195,2366.3904059956749,592.78556670404066,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.46695715823437201},0.14000406596813605,0.31430479187857707,7.8733983918914854E-2,0]
[{"$f":"IF(C16=\"\",\"\",B16&\"-\"&C16)","v":""},"SCHMAP FACTOR",null,null,{"$f":"SUM(F16:J16)","v":1},0.47220936057207102,0.138624571441712,0.31120786939259704,7.7958198593619923E-2,0]
[]
[{"$f":"IF(C18=\"\",\"\",B18&\"-\"&C18)","v":"SCHMAT-CIAC"},"SCHMAT","CIAC","DPW",41147.934999999998,{"$f":"VLOOKUP($D18,$D$135:$J$146,3,FALSE)*$E18","v":0},{"$f":"VLOOKUP($D18,$D$135:$J$146,4,FALSE)*$E18","v":0},{"$f":"VLOOKUP($D18,$D$135:$J$146,5,FALSE)*$E18","v":41147.934999999998},{"$f":"VLOOKUP($D18,$D$135:$J$146,6,FALSE)*$E18","v":0},{"$f":"VLOOKUP($D18,$D$135:$J$146,7,FALSE)*$E18","v":0}]
["SCHMAT-BADDEBT","SCHMAT","BADDEBT","CUST",4402.9860044029801,0,0,0,4402.9860044029801,0]
["SCHMAT-SCHMDEXP","SCHMAT","SCHMDEXP","GP",626055.77599999995,316352.50273707247,133327.74715739969,172257.88979700481,4117.6363085231123,0]
[{"$f":"IF(C21=\"\",\"\",B21&\"-\"&C21)","v":"SCHMAT-SE"},"SCHMAT","SE","LABOR",0,0,0,0,0,0]
["SCHMAT-SE","SCHMAT","SE","P",26031.777999999995,26031.777999999995,0,0,0,0]
["SCHMAT-SG","SCHMAT","SG","DPW",0,0,0,0,0,0]
[{"$f":"IF(C24=\"\",\"\",B24&\"-\"&C24)","v":"SCHMAT-SG"},"SCHMAT","SG","P",-1993.8860000000002,-1993.8860000000002,0,0,0,0]
["SCHMAT-SG","SCHMAT","SG","T",0,0,0,0,0,0]
["SCHMAT-SGCT","SCHMAT","SGCT","P",1122.425,1122.425,0,0,0,0]
["SCHMAT-SNP","SCHMAT","SNP","GP",1770,894.39943102548477,376.94742467897538,487.01166354337494,11.641480752165297,0]
["SCHMAT-SNP","SCHMAT","SNP","PTD",51429,25897.645101401333,11303.743907144944,14227.610991453719,0,0]
["SCHMAT-SNPD","SCHMAT","SNPD","DPW",9557,0,0,9557,0,0]
[{"$f":"IF(C30=\"\",\"\",B30&\"-\"&C30)","v":"SCHMAT-SO"},"SCHMAT","SO","DMSC",0,0,0,0,0,0]
[{"$f":"IF(C31=\"\",\"\",B31&\"-\"&C31)","v":"SCHMAT-SO"},"SCHMAT","SO","LABOR",11567,5040.5823998302121,833.15109648836221,4006.6723645778206,1686.5941391036051,0]
["SCHMAT-SO","SCHMAT","SO","PTD",9655,4861.8826625839483,2122.1032379296594,2671.0140994863918,0,0]
[{"$f":"IF(C33=\"\",\"\",B33&\"-\"&C33)","v":"SCHMAT-OTHER"},"SCHMAT","OTHER","DMSC",984.62900000000002,0,0,0,0,984.62900000000002]
[{"$f":"IF(C34=\"\",\"\",B34&\"-\"&C34)","v":"SCHMAT-OTHER"},"SCHMAT","OTHER","GP",0,0,0,0,0,0]
["SCHMAT-OTHER","SCHMAT","OTHER","P",45481.64,45481.64,0,0,0,0]
["SCHMAT-OTHER","SCHMAT","OTHER","PTD",19132.215,9634.2397105467171,4205.1305437873016,5292.8447456659806,0,0]
["SCHMAT-TROJD","SCHMAT","TROJD","P",13,13,0,0,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","DMSC",491.61599999999999,0,0,0,0,491.61599999999999]
["SCHMAT-SITUS","SCHMAT","SITUS","DPW",648.12900000000002,0,0,648.12900000000002,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","ESD",100.17,30.050999999999998,10.017000000000001,60.101999999999997,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","GP",4582.3119999999999,2315.4899692549443,975.87045620088406,1260.8132146863104,30.138359857862184,0]
["SCHMAT-SITUS","SCHMAT","SITUS","LABOR",1235.038,538.1957989039081,88.957660923730771,427.80259564307624,180.0819445292849,0]
["SCHMAT-SITUS","SCHMAT","SITUS","P",9398.3150000000005,9398.3150000000005,0,0,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","PTD",3603.6499999999996,1814.658048370859,792.05772484362672,996.93422678551372,0,0]
["SCHMAT-SITUS","SCHMAT","SITUS","T",433.15299999999996,0,433.15299999999996,0,0,0]
[null,"Total-SE",null,null,{"$f":"SUMIF($A:$A,\"SCHMAT-SE\",E:E)","v":26031.777999999995},26031.777999999995,0,0,0,0]
[{"$f":"IF(C47=\"\",\"\",B47&\"-\"&C47)","v":""},"Total-SNP",null,null,{"$f":"SUMIF($A:$A,\"SCHMAT-SNP\",E:E)","v":53199},26792.044532426818,11680.69133182392,14714.622654997094,11.641480752165297,0]
["","Total-SITUS",null,null,{"$f":"SUMIF($A:$A,\"SCHMAT-SITUS\",E:E)","v":20492.383000000002},14096.709816529712,2300.0558419682416,3393.7810371149003,210.22030438714708,491.61599999999999]
[null,"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"SCHMAT-SO\",E:E)","v":21222},9902.4650624141614,2955.2543344180217,6677.6864640642125,1686.5941391036051,0]
["","Total-SCHMAT",null,null,{"$f":"SUMIF($B:$B,\"SCHMAT\",E:E)","v":866848.881004403},447432.9188589899,154468.87920939713,253041.75969884705,10429.078237169009,1476.2449999999999]
[null,"SCHMAT-SE",null,null,{"$f":"SUM(F51:J51)","v":1},{"$f":"IF(ISERROR(F46/$E46),\" \",(F46/$E46))","v":1},0,0,0,0]
["","SCHMAT-SNP",null,null,{"$f":"SUM(F52:J52)","v":1},0.50361932616077032,0.21956599431989174,0.27659585057984348,2.1882893949445097E-4,0]
["","SCHMAT-SITUS",null,null,{"$f":"SUM(F53:J53)","v":1},0.68789997808111003,0.1122395497862909,0.16561182938630906,1.0258460638137939E-2,2.3990182108152083E-2]
[null,"SCHMAT-SO",null,null,{"$f":"SUM(F54:J54)","v":1},0.46661318737226282,0.13925428020064187,0.31465867797871139,7.9473854448383993E-2,0]
["","SCHMAT FACTOR",null,null,{"$f":"SUM(F55:J55)","v":1},0.5161602312280279,0.17819585696461496,0.2919098879214701,1.2031022322004977E-2,1.7030015638821614E-3]
[]
[{"$f":"IF(C57=\"\",\"\",B57&\"-\"&C57)","v":"SCHMAF-DGP"},"SCHMAF","DGP","P",0,{"$f":"VLOOKUP($D57,$D$135:$J$146,3,FALSE)*$E57","v":0},{"$f":"VLOOKUP($D57,$D$135:$J$146,4,FALSE)*$E57","v":0},{"$f":"VLOOKUP($D57,$D$135:$J$146,5,FALSE)*$E57","v":0},{"$f":"VLOOKUP($D57,$D$135:$J$146,6,FALSE)*$E57","v":0},{"$f":"VLOOKUP($D57,$D$135:$J$146,7,FALSE)*$E57","v":0}]
[{"$f":"IF(C58=\"\",\"\",B58&\"-\"&C58)","v":"SCHMAF-TROJP"},"SCHMAF","TROJP","P",0,{"$f":"VLOOKUP($D58,$D$135:$J$146,3,FALSE)*$E58","v":0},{"$f":"VLOOKUP($D58,$D$135:$J$146,4,FALSE)*$E58","v":0},{"$f":"VLOOKUP($D58,$D$135:$J$146,5,FALSE)*$E58","v":0},{"$f":"VLOOKUP($D58,$D$135:$J$146,6,FALSE)*$E58","v":0},{"$f":"VLOOKUP($D58,$D$135:$J$146,7,FALSE)*$E58","v":0}]
[{"$f":"IF(C59=\"\",\"\",B59&\"-\"&C59)","v":""},"Total-SCHMAF",null,null,{"$f":"SUMIF($A:$A,\"SCHMAF\",E:E)","v":0},0,0,0,0,0]
["","SCHMAF FACTOR",null,null,{"$f":"SUM(F60:J60)","v":0},{"$f":"IF(ISERROR(F59/$E59),\" \",(F59/$E59))","v":" "},{"$f":"IF(ISERROR(G59/$E59),\" \",(G59/$E59))","v":" "},{"$f":"IF(ISERROR(H59/$E59),\" \",(H59/$E59))","v":" "},{"$f":"IF(ISERROR(I59/$E59),\" \",(I59/$E59))","v":" "},{"$f":"IF(ISERROR(J59/$E59),\" \",(J59/$E59))","v":" "}]
[]
["","Total-SCHMA",null,null,{"$f":"SUM(E59,E50,E14)","v":874452.77100440301},451023.54689375026,155522.96520193704,255408.15010484273,11021.86380387305,1476.2449999999999]
["","SCHMA FACTOR",null,null,{"$f":"SUM(F63:J63)","v":1},{"$f":"IF(ISERROR(F62/$E62),\" \",(F62/$E62))","v":0.51577805211332484},{"$f":"IF(ISERROR(G62/$E62),\" \",(G62/$E62))","v":0.17785176096280442},{"$f":"IF(ISERROR(H62/$E62),\" \",(H62/$E62))","v":0.29207769541570439},{"$f":"IF(ISERROR(I62/$E62),\" \",(I62/$E62))","v":1.2604298561731647E-2},{"$f":"IF(ISERROR(J62/$E62),\" \",(J62/$E62))","v":1.6881929464348014E-3}]
[]
["","DEDUCTIONS"]
["SCHMDP-SCHMDEXP","SCHMDP","SCHMDEXP","LABOR",257.02100000000002,{"$f":"VLOOKUP($D66,$D$135:$J$146,3,FALSE)*$E66","v":112.00272577044704},{"$f":"VLOOKUP($D66,$D$135:$J$146,4,FALSE)*$E66","v":18.51278014788064},{"$f":"VLOOKUP($D66,$D$135:$J$146,5,FALSE)*$E66","v":89.029042778261967},{"$f":"VLOOKUP($D66,$D$135:$J$146,6,FALSE)*$E66","v":37.476451303410371},{"$f":"VLOOKUP($D66,$D$135:$J$146,7,FALSE)*$E66","v":0}]
["SCHMDP-SE","SCHMDP","SE","P",474.85399999999998,474.85399999999998,0,0,0,0]
["SCHMDP-SG","SCHMDP","SG","P",0,0,0,0,0,0]
["SCHMDP-SNP","SCHMDP","SNP","PTD",382.69600000000003,192.71082832110065,84.11397418360734,105.87119749529201,0,0]
["SCHMDP-SO","SCHMDP","SO","LABOR",11495.969000000001,5009.6290317622306,828.03485584388534,3982.0680640047835,1676.2370483891013,0]
["SCHMDP-SITUS","SCHMDP","SITUS","PTD",0,0,0,0,0,0]
[null,"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"SCHMDP-SO\",E:E)","v":11495.969000000001},5009.6290317622306,828.03485584388534,3982.0680640047835,1676.2370483891013,0]
["","Total-SCHMDP",null,null,{"$f":"SUMIF($B:$B,\"SCHMDP\",E:E)","v":12610.54},5789.1965858537787,930.66161017537331,4176.9683042783372,1713.7134996925117,0]
["","SCHMDP-SO",null,null,{"$f":"SUM(F74:J74)","v":1},{"$f":"IF(ISERROR(F72/$E72),\" \",(F72/$E72))","v":0.43577266359732098},7.2028278420365022E-2,0.34638820477027932,0.14581085321203469,0]
["","SCHMDP FACTOR",null,null,{"$f":"SUM(F75:J75)","v":1},0.45907602575732509,7.3800298018591851E-2,0.33122834583438432,0.13589533038969875,0]
[]
["SCHMDT-BADDEBT","SCHMDT","BADDEBT","CUST",0,{"$f":"VLOOKUP($D77,$D$135:$J$146,3,FALSE)*$E77","v":0},{"$f":"VLOOKUP($D77,$D$135:$J$146,4,FALSE)*$E77","v":0},{"$f":"VLOOKUP($D77,$D$135:$J$146,5,FALSE)*$E77","v":0},{"$f":"VLOOKUP($D77,$D$135:$J$146,6,FALSE)*$E77","v":0},{"$f":"VLOOKUP($D77,$D$135:$J$146,7,FALSE)*$E77","v":0}]
["SCHMDT-CN","SCHMDT","CN","CUST",48.155999999999999,0,0,0,48.155999999999999,0]
["SCHMDT-GPS","SCHMDT","GPS","GP",0,0,0,0,0,0]
["SCHMDT-GPS","SCHMDT","GPS","P",0,0,0,0,0,0]
["SCHMDT-GPS","SCHMDT","GPS","PTD",105220.837,52985.123060887789,23126.823293150585,29108.890645961619,0,0]
["SCHMDT-SG","SCHMDT","SG","P",200371.17399999898,200371.17399999898,0,0,0,0]
[{"$f":"IF(C83=\"\",\"\",B83&\"-\"&C83)","v":"SCHMDT-SG"},"SCHMDT","SG","GP",0,0,0,0,0,0]
["SCHMDT-SE","SCHMDT","SE","P",33039.411999999997,33039.411999999997,0,0,0,0]
["SCHMDT-SNP","SCHMDT","SNP","PTD",78813.066999999995,39687.196689007469,17322.57531557402,21803.294995418506,0,0]
["SCHMDT-SO","SCHMDT","SO","ESD",4556.4350000000004,1366.9305000000002,455.64350000000007,2733.8610000000003,0,0]
["SCHMDT-SO","SCHMDT","SO","GP",6552.0839999999998,3310.8362721080125,1395.3622542826663,1802.7917110259493,43.093762583373,0]
["SCHMDT-SO","SCHMDT","SO","LABOR",3624.386,1579.4083411248398,261.05828391087312,1255.4445599345336,528.47481502975359,0]
["SCHMDT-SO","SCHMDT","SO","PTD",4361.0960000000005,2196.0784083132271,958.53919653258276,1206.4783951541904,0,0]
["SCHMDT-OTHER","SCHMDT","OTHER","CUST",0,0,0,0,0,0]
[{"$f":"IF(C91=\"\",\"\",B91&\"-\"&C91)","v":"SCHMDT-OTHER"},"SCHMDT","OTHER","DMSC",46653,0,0,0,0,46653]
["SCHMDT-OTHER","SCHMDT","OTHER","DPW",33.14,0,0,33.14,0,0]
["SCHMDT-OTHER","SCHMDT","OTHER","LABOR",5651.5450000000001,2462.7888180901214,407.07105676522184,1957.6285267284482,824.05659841620854,0]
["SCHMDT-OTHER","SCHMDT","OTHER","P",106235.027,106235.027,0,0,0,0]
["SCHMDT-OTHER","SCHMDT","OTHER","PT",5812,4046.0078868228884,1765.9921131771116,0,0,0]
[{"$f":"IF(C96=\"\",\"\",B96&\"-\"&C96)","v":"SCHMDT-OTHER"},"SCHMDT","OTHER","GP",1163,587.67601032917446,247.67788412522503,319.99692920957347,7.6491763360272547,0]
["SCHMDT-TAXDEPR","SCHMDT","TAXDEPR","TAXDEPR",1309115.0120000001,752791.63349138526,233692.64674368277,315989.41319127142,6641.318573660752,0]
["SCHMDT-SITUS","SCHMDT","SITUS","DMSC",606,0,0,0,0,606]
[{"$f":"IF(C99=\"\",\"\",B99&\"-\"&C99)","v":"SCHMDT-SITUS"},"SCHMDT","SITUS","DPW",3.7549999999999999,0,0,3.7549999999999999,0,0]
["SCHMDT-SITUS","SCHMDT","SITUS","GP",0,0,0,0,0,0]
["SCHMDT-SITUS","SCHMDT","SITUS","LABOR",1663.914,725.08823577687269,119.84886085954324,576.36018335213453,242.61672001144947,0]
["SCHMDT-SITUS","SCHMDT","SITUS","P",1224,1224,0,0,0,0]
["SCHMDT-SITUS","SCHMDT","SITUS","GP",950,480.04489235831102,202.31641437572122,261.39044088486224,6.2482523811056678,0]
["","Total-GPS",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-GPS\",E:E)","v":105220.837},52985.123060887789,23126.823293150585,29108.890645961619,0,0]
[{"$f":"IF(C105=\"\",\"\",B105&\"-\"&C105)","v":""},"Total-CN",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-CN\",E:E)","v":48.155999999999999},0,0,0,48.155999999999999,0]
["","Total-SG",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-SG\",E:E)","v":200371.17399999898},200371.17399999898,0,0,0,0]
[{"$f":"IF(C107=\"\",\"\",B107&\"-\"&C107)","v":""},"Total-SE",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-SE\",E:E)","v":33039.411999999997},33039.411999999997,0,0,0,0]
["","Total-SNP",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-SNP\",E:E)","v":78813.066999999995},39687.196689007469,17322.57531557402,21803.294995418506,0,0]
["","Total SO",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-SO\",E:E)","v":19094.001},8453.2535215460794,3070.6032347261225,6998.5756661146734,571.56857761312654,0]
[{"$f":"IF(C110=\"\",\"\",B110&\"-\"&C110)","v":""},"Total OTHER",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-OTHER\",E:E)","v":165547.712},113331.49971524219,2420.7410540675583,2310.7654559380217,831.70577475223581,46653]
[{"$f":"IF(C111=\"\",\"\",B111&\"-\"&C111)","v":""},"Total TAXDEPR",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-TAXDEPR\",E:E)","v":1309115.0120000001},752791.63349138526,233692.64674368277,315989.41319127142,6641.318573660752,0]
["","Total-SITUS",null,null,{"$f":"SUMIF($A:$A,\"SCHMDT-SITUS\",E:E)+SUMIF($A:$A,\"SCHMDT-CN\",E:E)","v":4495.8249999999998},2429.1331281351841,322.16527523526446,841.50562423699671,297.02097239255511,606]
["","Total SCHMDT",null,null,{"$f":"SUMIF($B:$B,\"SCHMDT\",E:E)","v":1915697.0399999991},1203088.425606203,279955.55491643632,377052.44557894126,8341.6138984186691,47259]
["","SCHMDT-GPS",null,null,{"$f":"SUM(F114:J114)","v":1},{"$f":"IF(ISERROR(F104/$E104),\" \",(F104/$E104))","v":0.5035611250734281},0.21979318880680054,0.27664568611977131,0,0]
[{"$f":"IF(C115=\"\",\"\",B115&\"-\"&C115)","v":""},"SCHMDT-CN",null,null,{"$f":"SUM(F115:J115)","v":1},0,0,0,1,0]
["","SCHMDT-SG",null,null,{"$f":"SUM(F116:J116)","v":1},1,0,0,0,0]
[{"$f":"IF(C117=\"\",\"\",B117&\"-\"&C117)","v":""},"SCHMDT-SE",null,null,{"$f":"SUM(F117:J117)","v":1},1,0,0,0,0]
["","SCHMDT-SNP",null,null,1,0.5035611250734281,0.21979318880680054,0.27664568611977131,0,0]
["","SCHMDT-SO",null,null,1.0000000000000002,0.44271776887128472,0.16081507666864175,0.36653269611301859,2.9934458347055E-2,0]
[{"$f":"IF(C120=\"\",\"\",B120&\"-\"&C120)","v":""},"SCHMDT-OTHER",null,null,{"$f":"SUM(F120:J120)","v":1},0.68458511655686416,1.4622618608389818E-2,1.3958304998730648E-2,5.0239641774827782E-3,0.28180999565853254]
[{"$f":"IF(C121=\"\",\"\",B121&\"-\"&C121)","v":""},"SCHMDT-TAXDEPR",null,null,{"$f":"SUM(F121:J121)","v":1.0000000000000002},0.57503857689425475,0.17851192951080661,0.24137635753524717,5.0731360596915614E-3,0]
[{"$f":"IF(C122=\"\",\"\",B122&\"-\"&C122)","v":""},"SCHMDT-SITUS",null,null,1.0000000000000002,{"$f":"IF(ISERROR(F112/$E112),\" \",(F112/$E112))","v":0.54030864816472712},7.1658766797031578E-2,0.1871749065492978,6.606595505664814E-2,0.13479172343229553]
["","SCHMDT FACTOR",null,null,1,0.62801601740022717,0.14613769770006871,0.19682258609061767,4.3543492129729825E-3,2.4669349596113603E-2]
[]
["SCHMDF-DGP","SCHMDF","DGP","P",0,{"$f":"VLOOKUP($D125,$D$135:$J$146,3,FALSE)*$E125","v":0},{"$f":"VLOOKUP($D125,$D$135:$J$146,4,FALSE)*$E125","v":0},{"$f":"VLOOKUP($D125,$D$135:$J$146,5,FALSE)*$E125","v":0},{"$f":"VLOOKUP($D125,$D$135:$J$146,6,FALSE)*$E125","v":0},{"$f":"VLOOKUP($D125,$D$135:$J$146,7,FALSE)*$E125","v":0}]
["","Total-SCHMDF",null,null,{"$f":"SUMIF($A:$A,\"SCHMDF\",E:E)","v":0},0,0,0,0,0]
["","SCHMDF FACTOR",null,null,{"$f":"SUM(F127:J127)","v":0},{"$f":"IF(ISERROR(F126/$E126),\" \",(F126/$E126))","v":" "},{"$f":"IF(ISERROR(G126/$E126),\" \",(G126/$E126))","v":" "},{"$f":"IF(ISERROR(H126/$E126),\" \",(H126/$E126))","v":" "},{"$f":"IF(ISERROR(I126/$E126),\" \",(I126/$E126))","v":" "},{"$f":"IF(ISERROR(J126/$E126),\" \",(J126/$E126))","v":" "}]
[]
["","Total-SCHMD",null,null,{"$f":"SUM(E126,E113,E73)","v":1928307.5799999991},1208877.6221920568,280886.21652661171,381229.41388321959,10055.327398111182,47259]
["","SCHMD FACTOR",null,null,{"$f":"SUM(F130:J130)","v":1},{"$f":"IF(ISERROR(F129/$E129),\" \",(F129/$E129))","v":0.62691120168290648},{"$f":"IF(ISERROR(G129/$E129),\" \",(G129/$E129))","v":0.14566463329808196},{"$f":"IF(ISERROR(H129/$E129),\" \",(H129/$E129))","v":0.19770155852585497},{"$f":"IF(ISERROR(I129/$E129),\" \",(I129/$E129))","v":5.2145868752490132E-3},{"$f":"IF(ISERROR(J129/$E129),\" \",(J129/$E129))","v":2.4508019617907648E-2}]
[]
["","Net SCHM"]
[""]
[null,null,null,null,"Total","Production","Transmission","Poles & Wires","Customers","Miscellaneous"]
[null,null,null,"DMSC",{"$f":"SUM(F135:J135)","v":1},0,0,0,0,1]
[null,null,null,"DPW",{"$f":"SUM(F136:J136)","v":1},0,0,1,0,0]
[null,null,null,"CUST",1,0,0,0,1,0]
[null,null,null,"ESD",1,0.3,0.1,0.6,0,0]
[null,null,null,"GP",1.0000000000000002,{"$f":"'GROSS PLANT'!E43","v":0.50531041300874846},{"$f":"'GROSS PLANT'!F43","v":0.21296464671128551},{"$f":"'GROSS PLANT'!G43","v":0.27514783251038133},{"$f":"'GROSS PLANT'!H43","v":6.5771077695849136E-3},{"$f":"'GROSS PLANT'!I43","v":0}]
[null,null,null,"LABOR",1,{"$f":"'FORM 1'!C25","v":0.43577266359732098},{"$f":"'FORM 1'!D25","v":7.2028278420365022E-2},{"$f":"'FORM 1'!E25","v":0.34638820477027932},{"$f":"'FORM 1'!F25","v":0.14581085321203469},{"$f":"'FORM 1'!G25","v":0}]
[null,null,null,"P",1,{"$f":"'FORM 1'!C13","v":1},{"$f":"'FORM 1'!D13","v":0},{"$f":"'FORM 1'!E13","v":0},{"$f":"'FORM 1'!F13","v":0},{"$f":"'FORM 1'!G13","v":0}]
[null,null,null,"PT",{"$f":"SUM(F142:J142)","v":1},{"$f":"+'FORM 1'!C17","v":0.69614726201357335},{"$f":"+'FORM 1'!D17","v":0.30385273798642665},0,0,0]
[null,null,null,"PTD",1,{"$f":"'FORM 1'!C16","v":0.5035611250734281},{"$f":"'FORM 1'!D16","v":0.21979318880680054},{"$f":"'FORM 1'!E16","v":0.27664568611977131},{"$f":"'FORM 1'!F16","v":0},{"$f":"'FORM 1'!G16","v":0}]
[null,null,null,"T",1,{"$f":"'FORM 1'!C14","v":0},{"$f":"'FORM 1'!D14","v":1},{"$f":"'FORM 1'!E14","v":0},{"$f":"'FORM 1'!F14","v":0},{"$f":"'FORM 1'!G14","v":0}]
[null,null,null,"TAXDEPR",1.0000000000000002,{"$f":"'TAX DEPR'!C24","v":0.57503857689425475},{"$f":"'TAX DEPR'!D24","v":0.17851192951080661},{"$f":"'TAX DEPR'!E24","v":0.24137635753524717},{"$f":"'TAX DEPR'!F24","v":5.0731360596915614E-3},{"$f":"'TAX DEPR'!G24","v":0}]
[null,null,null,"TD",1,{"$f":"'FORM 1'!C18","v":0},{"$f":"'FORM 1'!D18","v":0.44273968036711486},{"$f":"'FORM 1'!E18","v":0.55726031963288514},{"$f":"'FORM 1'!F18","v":0},{"$f":"'FORM 1'!G18","v":0}]

{"sheet":"DDS","index":9,"n_rows":77,"n_cols":10,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,1,0,9],[1,1,1,9],[2,1,2,9]]}
[null,{"$f":"+'TOTAL FUNCFAC'!A1","v":"PacifiCorp"}]
[null,{"$f":"+'TOTAL FUNCFAC'!A2","v":"12 Months Ended June 2012"}]
[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",10608.20882,{"$f":"VLOOKUP($D6,$D$65:$J$77,3,FALSE)*$E6","v":10608.20882},{"$f":"VLOOKUP($D6,$D$65:$J$77,4,FALSE)*$E6","v":0},{"$f":"VLOOKUP($D6,$D$65:$J$77,5,FALSE)*$E6","v":0},{"$f":"VLOOKUP($D6,$D$65:$J$77,6,FALSE)*$E6","v":0},{"$f":"VLOOKUP($D6,$D$65:$J$77,7,FALSE)*$E6","v":0}]
["RA-SG","182M","SG","P",0,0,0,0,0,0]
["RA-SGCT","182M","SGCT","P",6266.8731399999997,6266.8731399999997,0,0,0,0]
["RA-SG-P","182M","SG-P","P",0,0,0,0,0,0]
["RA-SO","182M","SO","DMSC",6094.7118366666664,0,0,0,0,6094.7118366666664]
["RA-SO","182M","SO","DPW",0,0,0,0,0,0]
["RA-SO","182M","SO","ESD",3403.1867283333231,1020.9560184999968,340.31867283333236,2041.9120369999937,0,0]
["RA-SO","182M","SO","P",0,0,0,0,0,0]
["RA-SO","182M","SO","TD",0,0,0,0,0,0]
[{"$f":"\"RA\"&\"-\"&C15","v":"RA-OTHER"},"182M","OTHER","CUST",-5035.7150691664256,0,0,0,-5035.7150691664256,0]
[{"$f":"\"RA\"&\"-\"&C16","v":"RA-OTHER"},"182M","OTHER","DMSC",10161.562515833326,0,0,0,0,10161.562515833326]
["RA-OTHER","182M","OTHER","LABOR",12370.30561374999,5390.6410268167256,891.01181689218868,4284.9279540065672,1803.7248160345084,0]
["RA-OTHER","182M","OTHER","P",122434,122434,0,0,0,0]
["RA-OTHER","182M","OTHER","PT",435.0674054166663,302.87098307216155,132.19642234450475,0,0,0]
["RA-OTHER","182M","OTHER","PTD",8545.514877916663,4303.1890862554337,1878.2459650132603,2364.0798266479687,0,0]
["RA-OTHER","182M","OTHER","TD",186.375434583333,0,82.515800335706984,103.85963424762602,0,0]
["RA-TROJD","182M","TROJD","P",0,0,0,0,0,0]
["RA-TROJP","182M","TROJP","P",0,0,0,0,0,0]
["RA-SITUS","182M","SITUS","DMSC",-735.85091750000004,0,0,0,0,-735.85091750000004]
["RA-SITUS","182M","SITUS","LABOR",88.703954166666591,38.654758378822976,6.3891931077039592,30.726003439816779,12.933999240322875,0]
["RA-SITUS","182M","SITUS","P",15720.685905833328,15720.685905833328,0,0,0,0]
["RA-SITUS","182M","SITUS","PTD",899.36585624999952,452.88568242587678,197.67448944914599,248.80568437497672,0,0]
["RA-SITUS","182M","SITUS","CUST",2976.9517708333315,0,0,0,2976.9517708333315,0]
[null,"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"RA-SO\",E:E)","v":9497.8985649999886},1020.9560184999968,340.31867283333236,2041.9120369999937,0,6094.7118366666664]
[null,"Total-OTHER",null,null,{"$f":"SUMIF($A:$A,\"RA-OTHER\",E:E)","v":149097.11077833356},132430.70109614433,2983.9700045856607,6752.8674149021617,-3231.9902531319171,10161.562515833326]
[null,"Total SITUS",null,null,{"$f":"SUMIF($A:$A,\"RA-SITUS\",E:E)","v":18949.856569583324},16212.226346638028,204.06368255684995,279.53168781479349,2989.8857700736544,-735.85091750000004]
[null,"Total RA",null,null,{"$f":"SUMIF($B:$B,\"182M\",E:E)","v":194419.94787291688},166538.96542128234,3528.3523599758437,9074.3111397169487,-242.10448305826276,15520.423434999993]
[null,"DDSO2 FACTOR",null,null,{"$f":"SUM(F33:J33)","v":1},{"$f":"F29/$E29","v":0.10749283238949794},{"$f":"G29/$E29","v":3.5830944129832655E-2},{"$f":"H29/$E29","v":0.21498566477899589},{"$f":"I29/$E29","v":0},{"$f":"J29/$E29","v":0.64169055870167357}]
[null,"DDS2 FACTOR",null,null,{"$f":"SUM(F34:J34)","v":1},{"$f":"F31/$E31","v":0.85553293171941447},{"$f":"G31/$E31","v":1.076861356747129E-2},{"$f":"H31/$E31","v":1.4751124199191758E-2},{"$f":"I31/$E31","v":0.15777880740653},{"$f":"J31/$E31","v":-3.8831476892607436E-2}]
[]
[{"$f":"\"DD\"&\"-\"&C36","v":"DD-SE"},"186M","SE","P",13380.829568333334,{"$f":"VLOOKUP($D36,$D$65:$J$77,3,FALSE)*$E36","v":13380.829568333334},{"$f":"VLOOKUP($D36,$D$65:$J$77,4,FALSE)*$E36","v":0},{"$f":"VLOOKUP($D36,$D$65:$J$77,5,FALSE)*$E36","v":0},{"$f":"VLOOKUP($D36,$D$65:$J$77,6,FALSE)*$E36","v":0},{"$f":"VLOOKUP($D36,$D$65:$J$77,7,FALSE)*$E36","v":0}]
["DD-SG","186M","SG","P",{"$f":"24044+11600+2754","v":38398},38398,0,0,0,0]
["DD-SG","186M","SG","T",{"$f":"16990+25","v":17015},0,17015,0,0,0]
["DD-SO","186M","SO","DMSC",15.021408749999839,0,0,0,0,15.021408749999839]
["DD-SITUS","186M","SITUS","T",0,0,0,0,0,0]
["DD-SITUS","186M","SITUS","LABOR",0,0,0,0,0,0]
[null,"Total SITUS",null,null,{"$f":"SUMIF($A:$A,\"DD-SITUS\",E:E)","v":0},0,0,0,0,0]
[null,"Total SG",null,null,{"$f":"SUMIF($A:$A,\"DD-SG\",E:E)","v":55413},38398,17015,0,0,0]
[null,"Total-SO",null,null,{"$f":"SUMIF($A:$A,\"DD-SO\",E:E)","v":15.021408749999839},0,0,0,0,15.021408749999839]
[null,"Total-DD",null,null,{"$f":"SUMIF($B:$B,\"186M\",E:E)","v":68808.850977083348},51778.829568333334,17015,0,0,15.021408749999839]
[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},0,0,0]
[null,"DEFSG FACTOR",null,null,{"$f":"SUM(F47:J47)","v":1},{"$f":"F43/$E43","v":0.692942089401404},0.307057910598596,0,0,0]
[null,"DDSO6 FACTOR",null,null,{"$f":"SUM(F48:J48)","v":1},{"$f":"IFERROR(F44/$E44,0)","v":0},{"$f":"IFERROR(G44/$E44,0)","v":0},0,0,1]
[]
[null,"Major Adjustment"]
[null,"1998 Early Retirement",null,"LABOR",0,{"$f":"VLOOKUP($D51,$D$65:$J$77,3,FALSE)*$E51","v":0},{"$f":"VLOOKUP($D51,$D$65:$J$77,4,FALSE)*$E51","v":0},{"$f":"VLOOKUP($D51,$D$65:$J$77,5,FALSE)*$E51","v":0},{"$f":"VLOOKUP($D51,$D$65:$J$77,6,FALSE)*$E51","v":0},{"$f":"VLOOKUP($D51,$D$65:$J$77,7,FALSE)*$E51","v":0}]
[null,"1999 Early Retirement",null,"LABOR",0,{"$f":"VLOOKUP($D52,$D$65:$J$77,3,FALSE)*$E52","v":0},{"$f":"VLOOKUP($D52,$D$65:$J$77,4,FALSE)*$E52","v":0},{"$f":"VLOOKUP($D52,$D$65:$J$77,5,FALSE)*$E52","v":0},{"$f":"VLOOKUP($D52,$D$65:$J$77,6,FALSE)*$E52","v":0},{"$f":"VLOOKUP($D52,$D$65:$J$77,7,FALSE)*$E52","v":0}]
[null,"Transition Planning",null,"PTD",0,{"$f":"VLOOKUP($D53,$D$65:$J$77,3,FALSE)*$E53","v":0},{"$f":"VLOOKUP($D53,$D$65:$J$77,4,FALSE)*$E53","v":0},{"$f":"VLOOKUP($D53,$D$65:$J$77,5,FALSE)*$E53","v":0},{"$f":"VLOOKUP($D53,$D$65:$J$77,6,FALSE)*$E53","v":0},{"$f":"VLOOKUP($D53,$D$65:$J$77,7,FALSE)*$E53","v":0}]
[null,"Environmental Clean-up",null,"ESD",0,{"$f":"VLOOKUP($D54,$D$65:$J$77,3,FALSE)*$E54","v":0},{"$f":"VLOOKUP($D54,$D$65:$J$77,4,FALSE)*$E54","v":0},{"$f":"VLOOKUP($D54,$D$65:$J$77,5,FALSE)*$E54","v":0},{"$f":"VLOOKUP($D54,$D$65:$J$77,6,FALSE)*$E54","v":0},{"$f":"VLOOKUP($D54,$D$65:$J$77,7,FALSE)*$E54","v":0}]
[null,"Y2K",null,"PTD",0,{"$f":"VLOOKUP($D55,$D$65:$J$77,3,FALSE)*$E55","v":0},{"$f":"VLOOKUP($D55,$D$65:$J$77,4,FALSE)*$E55","v":0},{"$f":"VLOOKUP($D55,$D$65:$J$77,5,FALSE)*$E55","v":0},{"$f":"VLOOKUP($D55,$D$65:$J$77,6,FALSE)*$E55","v":0},{"$f":"VLOOKUP($D55,$D$65:$J$77,7,FALSE)*$E55","v":0}]
[null,"Subtotal Major Adjustments",null,null,{"$f":"SUM(E51:E55)","v":0},0,0,0,0,0]
[]
[null,"Total 186M SO",null,null,{"$f":"+E44+E56","v":15.021408749999839},0,0,0,0,15.021408749999839]
[]
[null,"Total 182 &186",null,null,{"$f":"SUM(E45,E32)","v":263228.79885000025},{"$f":"SUM(F32,F45)","v":218317.79498961568},{"$f":"SUM(G32,G45)","v":20543.352359975845},{"$f":"SUM(H32,H45)","v":9074.3111397169487},{"$f":"SUM(I32,I45)","v":-242.10448305826276},{"$f":"SUM(J32,J45)","v":15535.444843749992}]
[]
[]
[]
[null,null,null,null,"Total","Production","Transmission","Poles & Wires","Customers","Miscellaneous"]
[null,null,null,"DMSC",{"$f":"SUM(F65:J65)","v":1},0,0,0,0,1]
[null,null,null,"DPW",{"$f":"SUM(F66:J66)","v":1},0,0,1,0,0]
[null,null,null,"CUST",1,0,0,0,1,0]
[null,null,null,"ESD",1,0.3,0.1,0.6,0,0]
[null,null,null,"GP",1.0000000000000002,{"$f":"'GROSS PLANT'!$E$43","v":0.50531041300874846},{"$f":"'GROSS PLANT'!$F$43","v":0.21296464671128551},{"$f":"'GROSS PLANT'!$G$43","v":0.27514783251038133},{"$f":"'GROSS PLANT'!$H$43","v":6.5771077695849136E-3},{"$f":"'GROSS PLANT'!$I$43","v":0}]
[null,null,null,"RETAIL",1,0,0,0,1,0]
[null,null,null,"LABOR",1,{"$f":"'FORM 1'!$C$25","v":0.43577266359732098},{"$f":"'FORM 1'!$D$25","v":7.2028278420365022E-2},{"$f":"'FORM 1'!$E$25","v":0.34638820477027932},{"$f":"'FORM 1'!$F$25","v":0.14581085321203469},{"$f":"'FORM 1'!$G$25","v":0}]
[null,null,null,"P",1,{"$f":"'FORM 1'!$C$13","v":1},{"$f":"'FORM 1'!$D$13","v":0},{"$f":"'FORM 1'!$E$13","v":0},{"$f":"'FORM 1'!$F$13","v":0},{"$f":"'FORM 1'!$G$13","v":0}]
[null,null,null,"PT",{"$f":"SUM(F73:J73)","v":1},{"$f":"'FORM 1'!$C$17","v":0.69614726201357335},{"$f":"'FORM 1'!$D$17","v":0.30385273798642665},{"$f":"'FORM 1'!$E$17","v":0},{"$f":"'FORM 1'!$F$17","v":0},{"$f":"'FORM 1'!$G$17","v":0}]
[null,null,null,"PTD",1,{"$f":"'FORM 1'!$C$16","v":0.5035611250734281},{"$f":"'FORM 1'!$D$16","v":0.21979318880680054},{"$f":"'FORM 1'!$E$16","v":0.27664568611977131},{"$f":"'FORM 1'!$F$16","v":0},{"$f":"'FORM 1'!$G$16","v":0}]
[null,null,null,"T",1,{"$f":"'FORM 1'!$C$14","v":0},{"$f":"'FORM 1'!$D$14","v":1},{"$f":"'FORM 1'!$E$14","v":0},{"$f":"'FORM 1'!$F$14","v":0},{"$f":"'FORM 1'!$G$14","v":0}]
[null,null,null,"TAXDEPR",1.0000000000000002,{"$f":"'TAX DEPR'!C24","v":0.57503857689425475},{"$f":"'TAX DEPR'!D24","v":0.17851192951080661},{"$f":"'TAX DEPR'!E24","v":0.24137635753524717},{"$f":"'TAX DEPR'!F24","v":5.0731360596915614E-3},{"$f":"'TAX DEPR'!G24","v":0}]
[null,null,null,"TD",1,{"$f":"'FORM 1'!$C$18","v":0},{"$f":"'FORM 1'!$D$18","v":0.44273968036711486},{"$f":"'FORM 1'!$E$18","v":0.55726031963288514},{"$f":"'FORM 1'!$F$18","v":0},{"$f":"'FORM 1'!$G$18","v":0}]