{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Attach GG Proj #1- Year 1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":15,"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":"Attach GG Proj #1- Year 1","index":0,"n_rows":107,"n_cols":18,"rows_kept":107,"cut":false,"hidden":false,"merged":[[106,2,106,13],[105,2,105,13],[101,2,101,13],[102,2,102,13],[99,2,99,13],[100,2,100,13],[103,2,103,13],[104,2,104,13]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Attachment GG"]
[null,null,"Formula Rate calculation",null,null,null,"     Rate Formula Template",null,null,null,null,null,null,"For  the 12 months ended 12/31/14"]
[null,null,null,null," ",null," Utilizing Attachment O Data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 2"]
[null,null,null,null,null,null,"Montana-Dakota Utilities Co."]
[]
[null,null,"To be completed in conjunction with Attachment O."]
[]
[]
[null,null,"(1)",null,"(2)",null,"(3)",null,null,null,null,"(4)"]
[null,null,null,null,"Attachment O"]
["Line",null,null,null,"Page, Line, Col.",null,"Transmission",null,null,null,null,"Allocator"]
["No."]
[]
[1,null,"Gross Transmission Plant - Total",null,"Attach O, p 2, line 2 col 5 (Note A)",null,{"$f":"202858076+5562337","v":208420413}]
[2,null,"Net Transmission Plant - Total",null,"Attach O, p 2, line 14 and 23a col 5 (Note B)",null,{"$f":"113922645+5562337","v":119484982}]
[]
[null,null,"O&M EXPENSE"]
[3,null,"Total O&M Allocated to Transmission",null,"Attach O, p 3, line 8 col 5",null,7820774]
[4,null,"Annual Allocation Factor for O&M",null,"(line 3 divided by line 1 col 3)",null,{"$f":"IF(G22=0,0,G22/G18)","v":3.7524030815542044E-2},null,null,null,null,{"$f":"G23","v":3.7524030815542044E-2}]
[]
[null,null,"GENERAL AND COMMON (G&C) DEPRECIATION EXPENSE"]
["5",null,"Total G&C Depreciation Expense",null,"Attach O, p 3, lines 10 & 11, col 5 (Note H)",null,808390]
["6",null,"Annual Allocation Factor for G&C Depreciation Expense",null,"(line 5 divided by line 1 col 3)",null,{"$f":"IF(G26=0,0,G26/G18)","v":3.8786507922331007E-3},null,null,null,null,{"$f":"G27","v":3.8786507922331007E-3}]
[]
[null,null,"TAXES OTHER THAN INCOME TAXES"]
["7",null,"Total Other Taxes",null,"Attach O, p 3, line 20 col 5",null,1975179]
["8",null,"Annual Allocation Factor for Other Taxes",null,"(line 7 divided by line 1 col 3)",null,{"$f":"IF(G30=0,0,G30/G18)","v":9.4768980234196162E-3},null,null,null,null,{"$f":"G31","v":9.4768980234196162E-3}]
[]
["9",null,"Annual Allocation Factor for Expense",null,"Sum of line 4, 6, and 8",null,null,null,null,null,null,{"$f":"L23+L27+L31","v":5.0879579631194764E-2}]
[]
[null,null,"INCOME TAXES",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["10",null,"Total Income Taxes",null,"Attach O, p 3, line 27 col 5",null,4314455]
["11",null,"Annual Allocation Factor for Income Taxes",null,"(line 10 divided by line 2 col 3)",null,{"$f":"IF(G36=0,0,G36/G19)","v":3.610876386121898E-2},null,null,null,null,{"$f":"G37","v":3.610876386121898E-2}]
[]
[null,null,"RETURN "]
["12",null,"Return on Rate Base",null,"Attach O, p 3, line 28 col 5",null,9663552]
["13",null,"Annual Allocation Factor for Return on Rate Base",null,"(line 12 divided by line 2 col 3)",null,{"$f":"IF(G40=0,0,G40/G19)","v":8.0876708003353934E-2},null,null,null,null,{"$f":"G41","v":8.0876708003353934E-2}]
[]
["14",null,"Annual Allocation Factor for Return",null,"Sum of line 11 and 13",null,null,null,null,null,null,{"$f":"L37+L41","v":0.11698547186457292}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Attachment GG"]
[null,null,{"$f":"C5","v":"Formula Rate calculation"},null,null,null,{"$f":"G5","v":"     Rate Formula Template"},null,null,null,null,null,null,{"$f":"N5","v":"For  the 12 months ended 12/31/14"}]
[null,null,null,null,null,null,{"$f":"G6","v":" Utilizing Attachment O Data"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 2 of 2"]
[null,null,null,null,null,null,{"$f":"G8","v":"Montana-Dakota Utilities Co."}]
[]
[null,null,null,null,"                           Network Upgrade Charge Calculation By Project"]
[]
[null,null,-1,-2,-3,-4,-5,-6,-7,-8,-9,-10,-11,-12]
["Line No.",null,"Project Name","MTEP Project Number","Project Gross Plant ","Annual Allocation Factor for Expense","Annual Expense Charge","Project Net Plant ","Annual Allocation Factor for Return","Annual Return Charge","Project Depreciation Expense","Annual Revenue Requirement","True-Up Adjustment","Network Upgrade Charge"]
[null,null,null,null,"(Note C)","(Page 1 line 9)","(Col. 3 * Col. 4)","(Note D)","(Page 1 line 14)","(Col. 6 * Col. 7)","(Note E)","(Sum Col. 5, 8 & 9)","(Note F)","Sum Col. 10 & 11\n(Note G)"]
[]
["1a",null,"Heskett - Add. 230/115 kv Switchyard and 115kv Capacitor",1355,8329746,{"$f":"$L$33","v":5.0879579631194764E-2},{"$f":"E73*F73","v":423813.97491462604},{"$f":"+E73-K73","v":7876775},{"$f":"$L$43","v":0.11698547186457292},{"$f":"H73*I73","v":921468.24014607142},452971,{"$f":"G73+J73+K73","v":1798253.2150606974},0,{"$f":"L73+M73","v":1798253.2150606974}]
["1b",null,"Project 2","P2",0,{"$f":"$L$33","v":5.0879579631194764E-2},{"$f":"E74*F74","v":0},0,{"$f":"$L$43","v":0.11698547186457292},{"$f":"H74*I74","v":0},0,{"$f":"G74+J74+K74","v":0},0,{"$f":"L74+M74","v":0}]
["1c",null,"Project 3","P3",0,{"$f":"$L$33","v":5.0879579631194764E-2},{"$f":"E75*F75","v":0},0,{"$f":"$L$43","v":0.11698547186457292},{"$f":"H75*I75","v":0},0,{"$f":"G75+J75+K75","v":0},0,{"$f":"L75+M75","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2",null,"Annual Totals",null,null,null,null,null,null,null,null,{"$f":"SUM(L73:L92)","v":1798253.2150606974},{"$f":"SUM(M73:M92)","v":0},{"$f":"SUM(N73:N92)","v":1798253.2150606974}]
[]
[3,null,"Rev. Req. Adj For Attachment O",null,null,null,null,null,null,null,null,{"$f":"L93","v":1798253.2150606974}]
[]
[]
["Note"]
["Letter"]
["A",null,"Gross Transmission Plant is that identified on page 2 line 2 of Attachment O and includes any sub lines 2a or 2b etc. and is inclusive of any CWIP included in rate base when authorized by FERC order less any prefunded AFUDC, if applicable."]
["B",null,"Net Transmission Plant is that identified on page 2 line 14 of Attachment O and includes any sub lines 14a or 14b etc. and is inclusive of any CWIP included in rate base when authorized by FERC order less any prefunded AFUDC, if applicable."]
["C",null,"Project Gross Plant is the total capital investment for the project calculated in the same method as the gross plant value in line 1 and includes CWIP in rate base less any prefunded AFUDC, if applicable.  This value includes subsequent capital investments required to maintain the facilities to their original capabilities."]
["D",null,"Project Net Plant is the Project Gross Plant Identified in Column 3 less the associated Accumulated Depreciation."]
["E",null,"Project Depreciation Expense is the actual value booked for the project and included in the Depreciation Expense in Attachment O page 3 line 12."]
["F",null,"True-Up Adjustment is included pursuant to a FERC approved methodology if applicable."]
["G",null,"The Network Upgrade Charge is the value to be used in Schedule 26."]
["H",null,"The Total General and Common Depreciation Expense excludes any depreciation expense directly associated with a project and thereby included in page 2 column 9."]