{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Loss Calculation ","Attachment A","Attachment B","Attachment C","Attachment D ","Attachment E","Attachment F","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":7,"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":"Loss Calculation ","index":0,"n_rows":79,"n_cols":11,"rows_kept":79,"cut":false,"hidden":false,"merged":[[42,2,42,6],[4,2,5,5],[4,6,5,9],[23,2,23,3],[23,6,24,8],[41,2,41,6],[43,2,43,6],[44,2,44,6],[45,2,45,6],[50,9,51,9],[67,2,67,3]]}
[null,null," Amounts in thousands of MWh"]
[]
[]
[null,null,null,"Input Data from 2014 FERC Form No.1, Page 401a"]
[null,null,"SOURCES",null,null,null,"USES"]
[]
[null,null,"Net Generation, Ln 9",null,null,60205.324000000001,"Sales to Ultimate Consumers, Ln 22",null,null,54999.277000000002]
[null,null,"Purchases, Ln 10",null,null,9846.3520000000008,"Requirements Sales for Resale, Ln 23",null,null,225.49700000000001]
[null,null,null,null,null,70051.676000000007]
[null,null,"Net Exchanges, Ln 14",null,null,362.61799999999999,"Non-requirements Sales for Resale, Ln 24",null,null,10044.75]
[null,null,null,null,null,null,"Energy Used by the Company, Ln 26",null,null,134.392]
[null,null,"Received, Ln 16",null,null,13675,"Total Energy Losses, Ln 27",null,null,4637.9279999999999]
[null,null,"Delivered, Ln 17",null,null,-13564]
[null,1,"Transmission By Others Losses, Ln 19",null,null,-483.28199999999998]
[null,null,"  Total",null,null,70042.012000000002,"  Total",null,null,70041.844000000012]
[]
[]
[null,null,"Recalculated and Adjusted Received and Delivered Energy"]
[null,"REF ","Sources",null,null,null,"Uses",null,null,null,"REF "]
[null,1,"Generation, 401a lines 9,10",null,null,{"$f":"F7+F8","v":70051.676000000007},"Sales to Ultimate Consumers, 401a line 22",null,null,{"$f":"ROUND(J7,0)","v":54999},18]
[null,2,"Net exchange, 401a line 14",null,null,{"$f":"F10","v":362.61799999999999},"Requirements Sales for Resale, 401a line 23",null,null,{"$f":"+J8","v":225.49700000000001},19]
[null,3,"Transmission by Others Losses, 401a line 19",null,null,{"$f":"F14","v":-483.28199999999998}]
[null,null,null,null,null,{"$f":"SUM(F20:F22)","v":69931.012000000002}]
[null,4,"Reconciliation of Transmission Received (401a line 16):",null,null,null,"On-system non-requirements sales for resale subject to losses",null,null,{"$f":"+F68","v":3787.5119196240166},20]
[null,5,"Pt-to-Pt transmission received - losses financially settled","Att. A",{"$f":"'Attachment A'!J105/1000","v":3608.8690000000001}]
[null,6,"Network transmission received - losses financially settled","Att. B",{"$f":"'Attachment B'!J23/1000","v":89.375}]
[null,7,"WAPA RS 262 delivered","Att. C",{"$f":"'Attachment C'!E22/1000","v":1648.723},null,"Company sales, 401a line 26",null,null,{"$f":"+J11","v":134.392},21]
[null,8,"WAPA RS 263 delivered","Att. C",{"$f":"'Attachment C'!F22/1000","v":87.355000000000004}]
[null,9,"WAPA losses received","Att. C",{"$f":"-'Attachment C'!I8/1000","v":110.83199999999999}]
[null,10,"Black Hills transmission received - losses financially settled","Att. D",{"$f":"'Attachment D '!L20/1000","v":222.33500000000001}]
[null,11,"Transmission received - losses physically settled","Att. D",{"$f":"'Attachment C'!I37/1000","v":17.234000000000002}]
[null,12,"Transmission received -- supplied losses - network customers","Att. C",{"$f":"'Attachment C'!I38/1000","v":7889.8760000000002}]
[null,13,"Total Transmission Received: ",null,null,{"$f":"SUM(E25:E32)","v":13674.599000000002},"Transmission delivered without losses",null,null,{"$f":"+H78","v":13081.078},22]
[]
[null,14,"Gross Received",null,null,{"$f":"+F23+F33","v":83605.611000000004}]
[]
[null,15,"Less third-party sales on-system (reported in Energy Received (duplicate transactions))",null,null,{"$f":"+E67","v":-391.09}]
[null,16,"Less off-system sales/purchases w/o losses","Att. F",null,{"$f":"+E66","v":-5691.7820000000002}]
[null,17,"Net on-system received",null,null,{"$f":"SUM(F35:F38)","v":77522.739000000001},"Total delivered with on-system losses ",null,null,{"$f":"SUM(J20:J34)","v":72227.478919624016},23]
[null,null,null,null,null,null,"Total system delivered loss rate including off-system",null,null,{"$f":"H42/J39","v":7.3313649591295327E-2},24]
[]
[null,null,"Total losses (Sources-Uses) ",null,null,null,null,{"$f":"F39-J39","v":5295.2600803759851},null,null,25]
[null,null,"Distribution losses / Fixed 4.64% Loss Rate (see page 2)",null,null,null,null,{"$f":"+J79","v":1995.2448136247328},null,null,26]
[null,null,"Transmission losses (total losses - distribution losses)",null,null,null,null,{"$f":"H42-H43","v":3300.0152667512521},null,null,27]
[null,null,"  Transmission deliveries = Total delivered (Uses) + Distribution losses = ",null,null,null,null,{"$f":"J39+H43","v":74222.723733248742},null,null,28]
[null,null,"    Transmission loss rate @ delivery = ",null,null,null,null,{"$f":"H44/H45","v":4.4460983116319942E-2},null,null,29]
[]
[null,null," Amounts in thousands of MWh"]
[]
[null,null,"Transmission and Distribution Losses Adjustments and Allocation"]
[null,null,null,null,null,null,"Current Tran Loss Factor",null,"Distribution Loss Factor"]
[null,"REF ","Schedule 10 loss factor (prior to update)",null,null,null,4.2590000000000003E-2,null,4.6440000000000002E-2]
[null,null,null,null,null,"FERC # w/ Current Loss Factor","Trans Loss embedded in current #s","Adjusted to remove current Loss Factor (total delivered)","Retail Load w/ Dist. Loss","Dist. Loss"]
[null,null,null,null,null,"A","C  =A-B","B"]
[null,30,"TRANSMISSION: Sales to ultimate consumers transmission (including interdepartmental sales) ",null,null,{"$f":"14166","v":14166},null,{"$f":"+F55","v":14166},{"$f":"+H55","v":14166}]
[]
[null,31,"DISTRIBUTION: Sales to ultimate consumers distribution (including interdepartmental sales) ",null,null,40833,null,{"$f":"F57","v":40833},{"$f":"(F57)/(1-I52)","v":42821.636813624733},{"$f":"I57-H57","v":1988.6368136247329}]
[]
[null,32,"Requirements sales for resale ",null,null,{"$f":"J8","v":225.49700000000001},null,{"$f":"F59","v":225.49700000000001}]
[]
[null,null,"Adjustments:"]
[null,33," Non-requirements sales for resale, 401a line 24",null,{"$f":"J10","v":10044.75}]
[null,null,"Adjustments to remove financial transactions, duplicate transactions and off-system activity:"]
[null,34,"Less losses included paid by Black Hills","Att. E",-14.018080375983089]
[null,35,"Less Pt-to-Pt, network, and OS losses - financially settled ","Att. E",{"$f":"-'Attachment E'!K62/1000","v":-160.34800000000001}]
[null,36,"Off system sales/purchases w/o losses","Att. F",{"$f":"-'Attachment F'!C9","v":-5691.7820000000002}]
[null,37,"Third party sales on-system (reported in Energy Received (duplicate transactions))",null,-391.09]
[null,38,"Total on-system non-requirements sales for resale subject to losses",null,null,{"$f":"SUM(E62:E67)","v":3787.5119196240166},null,{"$f":"F68-G68","v":3787.5119196240166}]
[]
[null,39,"Energy used by the company (electric dept only, excluding station use, 401a line 26) ",null,null,{"$f":"J27","v":134.392},null,{"$f":"F70-G70","v":134.392},{"$f":"ROUND(F70/(1-I52),0)","v":141},{"$f":"I70-H70","v":6.6080000000000041}]
[]
[null,null,"Transmission received/delivered (adjusted 401a lines 16 & 17):"]
[null,40,"Transmission received - losses financially settled",null,"Att. A, B",{"$f":"+E25+E26","v":3698.2440000000001},{"$f":"+F73-H73","v":151.24400000000014},{"$f":"ROUND(F73/(1+G$52),0)","v":3547}]
[null,41,"WAPA adjustments (losses and RS 262 & 263 adj.)",null,"Att. C",{"$f":"+E27+E28+E29","v":1846.9099999999999},{"$f":"+E29","v":110.83199999999999},{"$f":"+F74-G74","v":1736.078}]
[null,42,"Transmission pt-to-pt Black Hills - losses financially settled",null,"Att. D",{"$f":"+E30","v":222.33500000000001},{"$f":"+F75-H75","v":9.335000000000008},{"$f":"ROUND(F75/(1+G$52),0)","v":213}]
[null,43,"Transmission other - losses physically settled",null,"Att. D",{"$f":"+E31","v":17.234000000000002},{"$f":"+F76-H76","v":0.23400000000000176},{"$f":"ROUND(F76/(1+G$52),0)","v":17}]
[null,44,"Transmission received - supplied losses",null,"Att. C",{"$f":"+E32","v":7889.8760000000002},{"$f":"+F77-H77","v":321.8760000000002},{"$f":"ROUND(F77/(1+G52),0)","v":7568}]
[null,45,"Total Transmission: ",null,null,{"$f":"SUM(F73:F77)","v":13674.599000000002},{"$f":"SUM(G73:G77)","v":593.52100000000041},{"$f":"SUM(H73:H77)","v":13081.078}]
[null,46,"Total",null,null,{"$f":"SUM(F55:F59)+F68+F70+F78","v":72820.999919624024},{"$f":"SUM(G73:G77)","v":593.52100000000041},{"$f":"SUM(H55:H59)+H68+H70+H78","v":72227.478919624016},{"$f":"SUM(I57:I77)","v":42962.636813624733},{"$f":"SUM(J57:J77)","v":1995.2448136247328}]

{"sheet":"Attachment A","index":1,"n_rows":106,"n_cols":10,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[]
["FF1 2014 328 MWH RECEIVED/DELIVERED"]
["TRANSMISSION MWH FINANCIAL SETTLEMENT of LOSSES"]
[]
[null,null,null,null,null,null,null,"Statistical","Rate Schedule"]
[null,"Page #",null,"Line #",null,"Customer",null,"Classification","Tariff Number","MWH"]
[]
[null,329,null,4,null,"Basin Electric Power Cooperative",null,"NF","V11-1,2,8",2688]
[null,329,null,14,null,"Black Hills Wyoming",null,"SFP","V11-1,2,7",215]
[null,329,null,15,null,"Black Hills Wyoming",null,"NF","V11-1,2,8",427]
[null,329,null,19,null,"Bonneville Power Administration",null,"LFP","V11-2,7",241995]
[null,329,null,20,null,"Bonneville Power Administration",null,"AD","V11-2,7",13872]
[null,329,null,27,null,"Bonneville Power Administration",null,"LFP","V11-2,7",68312]
[null,329.1,null,1,null,"Bonneville Power Administration",null,"NF","V11-1,2,8",298]
[null,329.1,null,4,null,"Cargill Power Markets, LLC",null,"NF","V11-1,2,8",39210]
[null,329.1,null,5,null,"Cargill Power Markets, LLC",null,"AD","V11-1,2,8",13699]
[null,329.1,null,7,null,"Cargill Power Markets, LLC",null,"AD","V11-1,2,7",1263]
[null,329.1,null,8,null,"Constellation Energy Commodities Group",null,"NF","V11-5,6,11",1789]
[null,329.1,null,9,null,"Constellation Energy Commodities Group",null,"SFP","V11-1-3,7",1650]
[null,329.1,null,10,null,"Coral Power, LLC",null,"NF","V11-1,2,8",50003]
[null,329.1,null,11,null,"Coral Power, LLC",null,"AD","V11-1,2,8",1208]
[null,329.1,null,12,null,"Coral Power, LLC",null,"SFP","V11-1,2,7",115557]
[null,329.1,null,13,null,"Coral Power, LLC",null,"AD","V11-1,2,7",10375]
[null,329.1,null,18,null,"Deseret Generation & Trans.",null,"NF","V11-1,2",6386]
[null,329.1,null,21,null,"Enel Cove Fort, LLC",null,"AD","V11",13969]
[null,329.1,null,26,null,"Iberdrola Renewables, LLC",null,"NF","V11-1-3,8,9,11",248249]
[null,329.1,null,27,null,"Iberdrola Renewables, LLC",null,"AD","V11-1-3,8,9",30155]
[null,329.1,null,28,null,"Iberdrola Renewables, LLC",null,"SFP","V11-1,2,3,7",67933]
[null,329.1,null,29,null,"Iberdrola Renewables, LLC",null,"AD","V11-1,2,3,7",13621]
[null,329.1,null,32,null,"Iberdrola Renewables, LLC",null,"LFP","V11-1,2,7",81958]
[null,329.1,null,33,null,"Iberdrola Renewables, LLC",null,"AD","V11-1,2,7",11604]
[null,329.2,null,3,null,"Idaho Power Company",null,"LFP","V11-1,2,7",59643]
[null,329.2,null,9,null,"Idaho Power Company",null,"NF","V11-1,2,8",54046]
[null,329.2,null,10,null,"Idaho Power Company",null,"AD","V11-1,2,8",81]
[null,329.2,null,11,null,"Idaho Power Company",null,"SFP","V11-1,2,7",3080]
[null,329.2,null,13,null,"Idaho Power Marketing Operations",null,"NF","V11-1,2,8",811]
[null,329.2,null,14,null,"JP Morgan Ventures Energy Corp.",null,"NF","V11-1-3,8,9,11",28479]
[null,329.2,null,15,null,"JP Morgan Ventures Energy Corp.",null,"AD","V11-1,2,3",6172]
[null,329.2,null,16,null,"Los Angeles Department of Water & Power",null,"NF","V11-1,2,8",4356]
[null,329.2,null,17,null,"Macquarie Energy, LLC",null,"NF","V11-1,2,8",5642]
[null,329.2,null,18,null,"Macquarie Energy, LLC",null,"AD","V11-1,2,8",9248]
[null,329.2,null,19,null,"Macquarie Energy, LLC",null,"SFP","V11-1,2,7",6687]
[null,329.2,null,20,null,"Macquarie Energy, LLC",null,"AD","V11-1,2,7",8050]
[null,329.2,null,23,null,"Morgan Stanley Capital Group, Inc.",null,"NF","V11-1-3,8",149158]
[null,329.2,null,24,null,"Morgan Stanley Capital Group, Inc.",null,"AD","V11-1-3,8",10975]
[null,329.2,null,25,null,"Morgan Stanley Capital Group, Inc.",null,"SFP","V11-1,2,7",10892]
[null,329.2,null,26,null,"Morgan Stanley Capital Group, Inc.",null,"AD","V11-1,2,7",1582]
[null,329.2,null,27,null,"Nevada Power Company",null,"NF","V11-1,2,8",4001]
[null,329.2,null,28,null,"Nevada Power Company",null,"AD","V11-1,2,8",466]
[null,329.2,null,29,null,"Nevada Power Company",null,"SFP","V11-1,2,7",1500]
[null,329.2,null,30,null,"NextEra Energy Resources, LLC",null,"LFP","V11-1-3,5-6,7,9",211794]
[null,329.2,null,31,null,"NextEra Energy Resources, LLC",null,"AD","V11-5,6,7,9",25327]
[null,329.2,null,32,null,"NextEra Energy Resources, LLC",null,"NF","V11-1,2,3,8,11",1048]
[null,329.2,null,33,null,"NextEra Energy Resources, LLC",null,"AD","V11-1,2,8",42]
[null,329.3,null,5,null,"Pacific Gas & Electric Company",null,"NF","V11-1,2,8",260]
[null,329.3,null,6,null,"Portland General Electric Company",null,"NF","V11-1,2,8",9388]
[null,329.3,null,7,null,"Portland General Electric Company",null,"AD","V11-1,2,8",1149]
[null,329.3,null,8,null,"Portland General Electric Company",null,"SFP","V11-1,2,7",1768]
[null,329.3,null,9,null,"Portland General Electric Company",null,"AD","V11-1,2,7",1210]
[null,329.3,null,13,null,"Powerex Corporation",null,"LFP","V11-1,2,7",620286]
[null,329.3,null,14,null,"Powerex Corporation",null,"AD","V11-1,2,7",13947]
[null,329.3,null,23,null,"Powerex Corporation",null,"NF","V11-1,2,3,8",488152]
[null,329.3,null,24,null,"Powerex Corporation",null,"AD","V11-1,2,8",4162]
[null,329.3,null,25,null,"Powerex Corporation",null,"SFP","V11-1,2,3,7",33375]
[null,329.3,null,26,null,"Powerex Corporation",null,"AD","V11-1,2,7",611]
[null,329.3,null,27,null,"PPL Energy Plus, LLC",null,"NF","V11-1,2,8",4136]
[null,329.3,null,28,null,"PPL Energy Plus, LLC",null,"AD","V11-1,2,8",641]
[null,329.3,null,29,null,"PPL Energy Plus, LLC",null,"SFP","V11-1,2,7",4626]
[null,329.3,null,32,null,"Puget Sound Power  & Light Company",null,"NF","V11-1,2,8",1976]
[null,329.3,null,33,null,"Rainbow Energy Marketing Corporation",null,"NF","V11-1,2,8",492]
[null,329.3,null,34,null,"Rainbow Energy Marketing Corporation",null,"AD","V11-1,2",1200]
[null,329.4,null,1,null,"Rainbow Energy Marketing Corporation",null,"SFP","V11-1,2,7",17328]
[null,329.4,null,2,null,"Sacramento Municipal Utility District",null,"LFP","V11-1,2,7",105118]
[null,329.4,null,3,null,"Sacramento Municipal Utility District",null,"AD","V11-1,2,7",1632]
[null,329.4,null,5,null,"Salt River Project",null,"LFP","V11-1,2,7",121700]
[null,329.4,null,6,null,"Salt River Project",null,"NF","V11-1,2,3,8",3577]
[null,329.4,null,7,null,"Salt River Project",null,"AD","V11-1,2,3,7",1586]
[null,329.4,null,11,null,"Sierra Pacific Power Company",null,"NF","V11-1,2,8",280]
[null,329.4,null,12,null,"Southern California Edison Company",null,"NF","V11-1-3,8,9,11",315360]
[null,329.4,null,13,null,"Southern California Edison Company",null,"AD","V11-1-3,8,9,11",17895]
[null,329.4,null,14,null,"Southern California Edison Company",null,"SFP","V11-1-3,7",1000]
[null,329.4,null,15,null,"Southern California Edison Company",null,"AD","V11-1-3,7",270]
[null,329.4,null,17,null,"Southern California Public Power Authority",null,"OS","V11-9,11",1144]
[null,329.4,null,21,null,"Tenaska Power Services Co",null,"NF","V11-1,2,8",43092]
[null,329.4,null,22,null,"Tenaska Power Services Co",null,"AD","V11-1,2,8",8321]
[null,329.4,null,23,null,"Tenaska Power Services Co",null,"SFP","V11-1,2,7",40590]
[null,329.4,null,24,null,"Tenaska Power Services Co",null,"AD","V11-1,2,7",11080]
[null,329.4,null,25,null,"The Energy Authority, Inc.",null,"NF","V11-1,2,8",2661]
[null,329.4,null,26,null,"Thermo No. 1 BE -01 ",null,"LFP","V11-1-3,5-6,7,9",53417]
[null,329.4,null,27,null,"Thermo No. 1 BE -01 ",null,"AD","V11-1-3,5-6,7,9",5984]
[null,329.4,null,28,null,"TransAlta Energy Marketing",null,"NF","V11-1,2,8",54023]
[null,329.4,null,29,null,"TransAlta Energy Marketing",null,"AD","V11-1,2,8",1813]
[null,329.4,null,34,null,"Tri-State Generation & Trans.",null,"NF","V11-1,2,8",14522]
[null,329.5,null,1,null,"Tri-State Generation & Trans.",null,"AD","V11-1,2,8",246]
[null,329.5,null,2,null,"Tri-State Generation & Trans.",null,"SFP","V11-1,2,7",244]
[null,329.5,null,3,null,"Tri-State Generation & Trans.",null,"AD","V11-1,2,7",9]
[null,329.5,null,11,null,"Utah Associated Municipal Power Systems",null,"NF","V11-1,2,3,8",4241]
[null,329.5,null,12,null,"Utah Associated Municipal Power Systems",null,"AD","V11-1,2,8",105]
[null,329.5,null,15,null,"Utah Municipal Power Agency",null,"NF","V11-1,2,8",40]
[null,329.5,null,26,null,"Western Area Power Administration Colorado River Storage Project",null,"SFP","V11-1,2,7",63]
[null,329.5,null,27,null,"Western Area Power Administration Colorado Missouri",null,"NF","V11-1,2,8",636]
[]
[null,null,null,null,null,"Total MWH",null,null,null,{"$f":"SUM(J8:J102)","v":3654872}]
[null,null,null,null,null,"Accrual Adjustment",null,null,null,-46003]
[null,null,null,null,null,"Total point-to-point schedules subject to losses (as reported on FERC Form No. 1, page 329)",null,null,null,{"$f":"J103+J104","v":3608869}]
[null,null,null,null,null,null,null,null,"REF",5]

{"sheet":"Attachment B","index":2,"n_rows":106,"n_cols":10,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[]
["FF1 2014 328 MWH RECEIVED/DELIVERED"]
["TRANSMISSION MWH FINANCIAL SETTLEMENT of LOSSES - Network customers"]
[]
[]
[]
[null,null,null,null,null,null,null,"Statistical","Rate Schedule"]
[null,"Page #",null,"Line #",null,"Customer",null,"Classification","Tariff Number","MWH"]
[]
[null,329,null,2,null,"Basin Electric Power Cooperative",null,"FNO","V11-1,2,3",335]
[null,329,null,21,null,"Bonneville Power Administration",null,"FNO","V11-1,2,3",2047]
[null,329,null,23,null,"Bonneville Power Administration",null,"FNO","V11-1,2,3",617]
[null,329,null,25,null,"Bonneville Power Administration",null,"FNO","V11-1,2,3",126]
[null,329,null,31,null,"Bonneville Power Administration",null,"FNO","V11-1,2,3,4",3230]
[null,329.1,null,2,null,"Bonneville Power Administration",null,"FNO","V11-1,2,3,4",11986]
[null,329.1,null,34,null,"Iberdrola Renewables, LLC",null,"FNO","V11-1,2,3",3540]
[null,329.2,null,34,null,"Noble Americas Energy Solutions LLC",null,"FNO","V11-1,2,3,4",0]
[null,329.4,null,32,null,"Tri-State Generation & Transmission",null,"FNO","V11-1,2,3,4",12796]
[null,329.5,null,4,null,"U.S. Department of the Interior, Bureau of Reclamation",null,"FNO","V11-1,2,3",3]
[null,329.5,null,23,null,"Western Area Power Administration",null,"FNO","V11-1,2",2]
[null,null,null,null,null,null,null,"Total MWH",null,{"$f":"SUM(J10:J20)","v":34682}]
[null,null,null,null,null,null,null,"Accrual",null,54693]
[null,null,null,null,null,null,null,"Total",null,{"$f":"J21+J22","v":89375}]
[null,null,null,null,null,null,null,null,"REF",6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Total point-to-point schedules subject to losses (as reported on FERC Form 1, page 329)"]

{"sheet":"Attachment C","index":3,"n_rows":103,"n_cols":10,"rows_kept":103,"cut":false,"hidden":false,"merged":[[36,3,36,5],[37,3,37,5],[39,3,39,5],[34,3,34,5],[35,3,35,5],[4,9,5,9],[4,3,4,8],[31,3,31,5],[32,3,32,5],[33,3,33,5]]}
[]
["Western Area Power Administration Total Received/Delivered & Total Received Per FF1 2014 328 and 401a Summary"]
[2014]
[]
["Amounts in MWh",null,null,"Western Rec./Del. Reconciliation",null,null,null,null,null,"REF Loss Factor Clauclation Worksheet"]
[null,null,null,null,"RS 262","RS 263","Subtotal","Energy Return (Variation)","Net"]
[null,null,null,"Energy Received",1753557,93353,{"$f":"SUM(E7:F7)","v":1846910},0,{"$f":"SUM(G7:H7)","v":1846910}]
[null,null,null,"Losses",-104834,-5998,{"$f":"SUM(E8:F8)","v":-110832},null,{"$f":"SUM(G8:H8)","v":-110832},9]
[null,null,null,"Energy Delivered",{"$f":"SUM(E7:E8)","v":1648723},{"$f":"SUM(F7:F8)","v":87355},{"$f":"SUM(G7:G8)","v":1736078},{"$f":"SUM(H7:H8)","v":0},{"$f":"SUM(I7:I8)","v":1736078}]
[]
[null,null,null,"Details:"]
["Page #",null,"Line #","Total Received: Reported"]
["FF1 Pg 328.5",null,"18,20(i)","OS Reported",1583864,84635,{"$f":"SUM(E13:F13)","v":1668499},0,{"$f":"SUM(G13:H13)","v":1668499}]
["FF1 Pg 328.5",null,"19,21(i)","AD Reported",187719,8557,{"$f":"+E14+F14","v":196276},0,{"$f":"SUM(G14:H14)","v":196276}]
["FF1 Pg 328.5",null,null,"Accrual Adjustment (included in total Accrual)",-18026,161,{"$f":"+E15+F15","v":-17865},0,{"$f":"SUM(G15:H15)","v":-17865}]
[null,null,null,"Total Received",{"$f":"SUM(E13:E15)","v":1753557},{"$f":"SUM(F13:F15)","v":93353},{"$f":"SUM(G13:G15)","v":1846910},{"$f":"SUM(H13:H15)","v":0},{"$f":"SUM(I13:I15)","v":1846910}]
[]
[null,null,null,"Total Delivered: Reported"]
["FF1 Pg 328.5",null,"18,20(j)","OS Reported",1489212,79280,{"$f":"SUM(E19:F19)","v":1568492},null,{"$f":"SUM(G19:H19)","v":1568492}]
["FF1 Pg 328.5",null,"19,21(j)","AD Reported",176455,8075,{"$f":"+E20+F20","v":184530},null,{"$f":"SUM(G20:H20)","v":184530}]
["FF1 Pg 328.5",null,null,"Accrual Adjustment (included in total Accrual)",-16944,0,{"$f":"+E21+F21","v":-16944},null,{"$f":"SUM(G21:H21)","v":-16944}]
[null,null,null,"Total Delivered ",{"$f":"SUM(E19:E21)","v":1648723},{"$f":"SUM(F19:F21)","v":87355},{"$f":"SUM(G19:G21)","v":1736078},null,{"$f":"SUM(I19:I21)","v":1736078},"7, 8"]
[]
[]
[]
[]
[null,null,null,"Total Received per 328 and 401a-lines 16/17 as reported"]
[null,null,null,null,null,null,null,"Accrual","Total"]
[null,null,null,null,null,null,"Received","Received","Received"]
[null,null,null,null,null,null,"per 328 ","FF1 Pg 328.5","Per 401a"]
[]
[null,null,null,"Total point-to-point schedules subject to losses - as reported on 328 (financial settlement)",null,null,{"$f":"+'Attachment A'!J103","v":3654872},{"$f":"+'Attachment A'!J104","v":-46003},{"$f":"+G32+H32","v":3608869},5]
[null,null,null,"Total network schedules financially settled - subst of total report on 328",null,null,{"$f":"+'Attachment B'!J21","v":34682},{"$f":"+'Attachment B'!J22","v":54693},89375,6]
[null,null,null,"Western RS 262 Received reported on page 328",null,null,{"$f":"+E13+E14","v":1771583},{"$f":"+E15","v":-18026},1753557,"see above"]
[null,null,null,"Western RS 263 Received reported on page 328",null,null,{"$f":"+F13+F14","v":93192},{"$f":"+F15","v":161},93353,"see above"]
[null,null,null,"Black Hills (losses paid financially to PacifiCorp Energy)",null,null,{"$f":"+'Attachment D '!L18","v":210175},{"$f":"+'Attachment D '!L19","v":12160},222335,10]
[null,null,null,"State of South Dakota - losses physically settled",null,null,{"$f":"+'Attachment D '!N18","v":17212},{"$f":"+'Attachment D '!N19","v":22},17234,11]
[null,null,null,"Network/OS/and other rate schedules [1]",null,null,8021359,-131483,7889876,12]
[]
[null,null,null,"Total Received per 401a Line 16",null,null,{"$f":"SUM(G32:G38)","v":13803075},{"$f":"SUM(H32:H38)","v":-128476},{"$f":"SUM(I32:I38)","v":13674599}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Total point-to-point schedules subject to losses (as reported on FERC Form 1, page 329)"]

{"sheet":"Attachment D ","index":4,"n_rows":21,"n_cols":16,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
["2014 328 MWH RECEIVED/DELIVERED"]
["PT-TO-PT MW PHYSICAL SETTLEMENT AND BLACK HILLS"]
[]
[null,null,null,null,null,null,null,"Statistical","Rate Schedule",null,null,"Black"]
[null,"Page #",null,"Line #",null,"Customer",null,"Classification","Tariff Number","MWH",null,"Hills",null,"Physical",null,"Total "]
[]
[null,329,null,5,null,"Black Hills/Colorado Electric Utility Company, L.P.",null,"NF","V11-1,2,8",1398,null,{"$f":"+J8","v":1398},null,null,null,{"$f":"SUM(L8:N8)","v":1398}]
[null,329,null,6,null,"Black Hills/Colorado Electric Utility Company, L.P.",null,"SFP","V11-1,2,7",1829,null,1829,null,null,null,1829]
[null,329,null,9,null,"Black Hills Corporation",null,"NF","V11-1,2,8",13155,null,13155,null,null,null,13155]
[null,329,null,10,null,"Black Hills Corporation",null,"AD","V11-1,2,8",397,null,397,null,null,null,397]
[null,329,null,11,null,"Black Hills Corporation",null,"SFP","V11-1,2,7",4035,null,4035,null,null,null,4035]
[null,329,null,14,null,"Black Hills Corporation",null,"LFP","V11-1,2,7",182880,null,182880,null,null,null,182880]
[null,329,null,15,null,"Black Hills Corporation",null,"AD","V11-1,2,7",6481,null,6481,null,null,null,6481]
[null,329.4,null,18,null,"State of South Dakota",null,"LFP","7V11-7",12235,null,null,null,{"$f":"+J15","v":12235},null,12235]
[null,329.4,null,19,null,"State of South Dakota",null,"AD","7V11-7",1496,null,null,null,1496,null,1496]
[null,329.4,null,20,null,"State of South Dakota",null,"SFP","7V11-7",3481,null,null,null,3481,null,3481]
[null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(J8:J17)","v":227387},null,{"$f":"SUM(L8:L17)","v":210175},null,{"$f":"SUM(N8:N17)","v":17212},null,{"$f":"SUM(P8:P17)","v":227387}]
[null,null,null,null,null,"Accruals",null,null,null,{"$f":"+L19+N19","v":12182},null,12160,null,22,null,{"$f":"SUM(L19:N19)","v":12182}]
[null,null,null,null,null,"Total Black Hills and Physical received/delivered",null,null,null,{"$f":"+J18+J19","v":239569},null,{"$f":"+L18+L19","v":222335},null,{"$f":"+N18+N19","v":17234},null,{"$f":"+P18+P19","v":239569}]
[null,null,null,null,null,null,null,null,null,"REF",null,10,null,11]

{"sheet":"Attachment E","index":5,"n_rows":103,"n_cols":12,"rows_kept":103,"cut":false,"hidden":false,"merged":[[5,8,5,9]]}
[]
["2014 FERC FORM 1 PAGES 310 AND 311"]
["SALES FOR RESALE (Account 447)"]
["TRANSMISSION AGREEMENTS FINANCIALLY SETTLED"]
[]
[null,null,null,null,null,null,null,null,"Actual Demand"]
[null,null,null,null,"Statistical","Footnote","FERC Rate","Average","Average","Average"]
["Page ",null,"Line","Name of Company or Public Authority","Classifi-","for","Schedule or","Monthly Billing","Monthly","Monthly","Megawatthours"]
["No.",null,"No.","[Footnote Affiliations]","cations","col (b)","Tariff Number","Demand (MW)","NCP Demand","CP Demand","Sold"]
[null,null,null,"(a)","(b)",null,"(c)","(d)","(e)","(f)","(g)","REF"]
[null,null,null,"Nonrequirement Sales"]
[311.10000000000002,null,5,"Basin Electric Power Cooperative","SF",null,"T-11","NA","NA","NA",173]
[311.10000000000002,null,9,"Black Hills Wyoming, Inc.","SF",null,"T-11","NA","NA","NA",39]
[311.10000000000002,null,11,"Bonneville Power Administration","LF",3,368,"NA","NA","NA",2748]
[311.10000000000002,null,12,"Bonneville Power Administration","LF",4,"T-11","NA","NA","NA",16022]
[311.10000000000002,null,14,"Bonneville Power Administration","SF",null,"T-11","NA","NA","NA",13]
["311.2",null,8,"Cargill Power Markets, LLC","SF",null,"T-11","NA","NA","NA",1706]
["311.3",null,3,"Constellation Energy Commodities Group, Inc.","SF",null,"T-11","NA","NA","NA",122]
["311.3",null,4,"Constellation Energy Commodities Group, Inc.","SF",null,"T-11","NA","NA","NA",26]
[311.3,null,5,"Coral Power, LLC","SF",null,"T-11","NA","NA","NA",7367]
["311.3",null,6,"Deseret Generation & Transmission Cooperative","SF",null,"T-11","NA","NA","NA",273]
["311.4",null,2,"Iberdrola Renewables, LLC","LF",5,"T-11","NA","NA","NA",3787]
["311.4",null,3,"Iberdrola Renewables, LLC","SF",null,"T-11","NA","NA","NA",14435]
["311.4",null,4,"Iberdrola Renewables, LLC","SF",null,"T-11","NA","NA","NA",34]
["311.4",null,7,"Idaho Power Company","LF",6,"T-11","NA","NA","NA",2737]
["311.4",null,8,"Idaho Power Company","SF",null,"T-11","NA","NA","NA",2468]
["311.4",null,12,"J.P. Morgan Ventures Energy Corporation","SF",null,"T-11","NA","NA","NA",997]
["311.4",null,13,"J.P. Morgan Ventures Energy Corporation","SF",null,"T-11","NA","NA","NA",224]
[311.5,null,1,"Los Angeles Department of Water and Power","SF",null,"T-11","NA","NA","NA",186]
["311.5",null,3,"Macquarie Energy LLC","SF",null,"T-11","NA","NA","NA",525]
["311.5",null,7,"Morgan Stanley Capital Group Inc.","SF",null,"T-11","NA","NA","NA",6959]
["311.5",null,11,"Nevada Power Company","SF",7,"T-11","NA","NA","NA",234]
["311.5",null,13,"NextEra Energy Power Marketing, LLC","LF",8,"T-11","NA","NA","NA",9697]
["311.5",null,14,"NextEra Energy Power Marketing, LLC","SF",null,"T-11","NA","NA","NA",47]
[311.60000000000002,null,1,"NextEra Energy Power Marketing, LLC","SF",null,"T-11","NA","NA","NA",7]
["311.6",null,3,"Noble Americas Energy Solutions LLC","LF",9,"T-11","NA","NA","NA",923]
["311.6",null,8,"PPL EnergyPlus, LLC","SF",null,"T-11","NA","NA","NA",427]
["311.6",null,10,"Pacific Gas & Electric Company","SF",null,"T-11","NA","NA","NA",22]
["311.6",null,11,"Portland General Electric Company","SF",null,"T-11","NA","NA","NA",475]
["311.6",null,14,"Powerex Corporation","LF",10,"T-11","NA","NA","NA",28390]
[311.7,null,1,"Powerex Corporation","SF",null,"T-11","NA","NA","NA",22426]
["311.7",null,4,"Public Service Company of Colorado","SF",null,"T-11","NA","NA","NA",27]
[311.8,null,1,"Puget Sound Energy, Inc.","SF",null,"T-11","NA","NA","NA",84]
["311.8",null,4,"Rainbow Energy Marketing Corporation","SF",null,"T-11","NA","NA","NA",759]
["311.8",null,8,"Sacramento Municipal Utility District","LF",12,"T-11","NA","NA","NA",5027]
["311.8",null,10,"Salt River Project","LF",13,"T-11","NA","NA","NA",5655]
["311.8",null,11,"Salt River Project","SF",null,"T-11","NA","NA","NA",188]
["311.9",null,5,"Sierra Pacific Power Company","SF",14,"T-11","NA","NA","NA",12]
["311.9",null,8,"Southern California Edison Company","SF",null,"T-11","NA","NA","NA",13694]
["311.9",null,9,"Southern California Edison Company","SF",null,"T-11","NA","NA","NA",9]
["311.9",null,11,"Southern California Public Power Authority","SF",null,"T-11","NA","NA","NA",49]
["311.10",null,1,"Tenaska Power Services Co.","SF",null,"T-11","NA","NA","NA",3857]
["311.10",null,5,"The Energy Authority, Inc.","SF",null,"T-11","NA","NA","NA",146]
["311.10",null,7,"Thermo No. 1 BE-01, LLC","LF",15,"T-11","NA","NA","NA",2510]
["311.10",null,8,"TransAlta Energy Marketing (U.S.) Inc.","SF",null,"T-11","NA","NA","NA",2624]
["311.10",null,11,"Tri-State Generation and Transmission Association, Inc.","LF",16,"T-11","NA","NA","NA",1257]
["311.10",null,12,"Tri-State Generation and Transmission Association, Inc.","SF",null,"T-11","NA","NA","NA",631]
["311.11",null,4,"Utah Associated Municipal Power Systems","SF",null,"T-11","NA","NA","NA",288]
["311.11",null,8,"Utah Municipal Power Agency","SF",null,"T-11","NA","NA","NA",2]
["311.11",null,11,"Western Area Power Administration","SF",null,"T-11","NA","NA","NA",40]
[]
[null,null,null,null,null,null,null,null,"Total Pt-to-Pt, Network, and OS Financially Settled",null,{"$f":"SUM(K12:K61)","v":160348},35]
[]
[311.10000000000002,null,7,"Black Hills Power, Inc (sales plus losses)","LF",null,441,"NA","NA","NA",343081]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Total point-to-point schedules subject to losses (as reported on FERC Form 1, page 329)"]

{"sheet":"Attachment F","index":6,"n_rows":50,"n_cols":4,"rows_kept":50,"cut":false,"hidden":false,"merged":[[14,1,14,2],[44,1,44,7],[50,1,50,7],[45,1,45,7],[47,1,47,7],[48,1,48,7]]}
[null,"2014 Off System Sales/Purchases Summary"]
[]
[]
[null," Amounts in thousands of MWh","MWh","REF"]
[null,"PAC01 Off System Sales (MidC)-purchases",1823.422]
[null,"PAC01 Off System Sales (Cholla, Col, Herm, Wyo, YTP etc) - sales",2500.4639999999999]
[null,"Craig generation sales [1]",788.38300000000004]
[null,"Hayden generation sales [1]",579.51300000000003]
[null,"Total third-party off system sales/purchases",{"$f":"SUM(C5:C8)","v":5691.7820000000002},"16, 36"]
[]
[null,"MidC filter"]
[null,"LoadPoint Does Not=CHEHALIS"]
[null,"LCA Does Not=PACW"]
[null,"AssignmentRef=212;213;NOR"]
[null,"ContractMkt Does Not=ALCOA Exchange;No Spill Exch;RR CEA"]
[null,"Path=MIDC/MIDC;MIDC/MIDCRemote"]
[null,"TSSubClass Does Not=FCR_PHYSICAL;SECONDARY"]
[null,"ScheduleType=Energy"]
[null,"TagNotes Does Not=DOPD Settlement"]
[null,"FlowType=Export"]
[null,"LSE Does Not=PAC01",null,"WYOEASTNNH"]
[null,null,null,960]
[null,"Cholla, Colstrip, Hermiston, Wyodak and YTP filter:",null,56]
[null,"GPE=PAC01 [2]",null,0]
[null,"Scheduletype = Energy",null,0]
[null,"TagNotes does not = Coal Feed; Colstrip Startup",null,0]
[null,"LSE does not = PAC01 ",null,0]
[null,"LoadPoint does not = NWMTLosses",null,0]
[null,"TSSubClass does not = FCR_PHYSICAL;SECONDARY",null,0]
[null,"Assignment Ref = 201;204;205;207;215;216;217;218;NOR; 230SI;231SI; 235SI; 250SI [3]"]
[null,"FlowType=Export [4]",null,0]
[null,"GeneratorPointDoes Not = PACENNH and PACWNNH [5]",null,595]
[null,null,null,2400]
[null,"Jim Bridger filter [6]"]
[null,"Path=JBSN/JBSN",null,{"$f":"SUM(D22:D33)","v":4011}]
[null,"ScheduleType=Energy"]
[null,"TagTransOwner=BHPM01"]
[null,"GCA=PACW"]
[null,"LSE Does Not=PAC01"]
[null,"TagNotes Does Not=54234800"]
[null,"AssignmentRef=206;NOR"]
[null,"LoadPoint Does Not=IPCO_LOSS "]
[]
["Notes and adjustments to 2010 query :"]
["[1]","Off system sales at Craig and Hyden generation bus are not captured in the E-Tag query due to different tagging conventions. Data obtained from company records."]
["[2]","Replaced \"Path=.....\" with \"GPE=PAC01\" which has the same effect on the filter except there is no need to add a new path to this list whenever there is a new path to add.\n\n"]
["[3]","Added 230SI (Juniper Wind), 231SI (Goodnoe Hills), 235SI (Chehalis Gen) and 250SI (Hermiston Gen) to this list."]
["[4]","Added \"FlowType=Export\" to limit the view to Export tags only as opposed to Export AND an Import which would cancel each other when tags are totaled.\n\n\n"]
["[5]","Added \"GeneratorPointDoes Not = PACENNH and PACWNNH\" to exclude non-generator bus transactions."]
["[6]","No off system sales at Jim Bridger generation bus have been identified in 2014."]

{"sheet":"Sheet1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}