{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Losses - Day","Config"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":3,"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":"Losses - Day","index":0,"n_rows":74,"n_cols":7,"rows_kept":74,"cut":false,"hidden":false,"merged":[[13,0,15,0],[48,0,51,0],[6,0,6,8]]}
[]
[null,null,"Duke Energy Progress"]
[null,null,"Loss Calculation Tool"]
[null,null,{"$f":"\"Transmission Loss Rate is \" & LOSS_PERCENTAGE*100 & \"%\"","v":"Transmission Loss Rate is 2.09%"}]
[]
[]
["This tool is provided to assist transmission customers in scheduling transmission transactions where transmission losses will be taken from the MWHs scheduled.  Losses are accounted for in whole MWHs.  If a MWH schedule is desired at the Point of Delivery each hour, the tool will calculate the quantity of MWHs required at the Point of Receipt to supply the appropriate losses.  The tool will also calculate the quantity of MWHs delivered to the Point of Delivery if MWHs are specified at the Point of Receipt on the transmission system.  If multiple day transactions are being scheduled, simply repeat the use of the tool for each day."]
[]
["If a Fixed Schedule is required\neach hour, where do you want the\nfixed schedule to be applied?"]
[]
["Point of Receipt Calculator"]
[]
[null,"Hour Ending","Point of Receipt (MWH)","Point of Delivery (MWH)","SUM","EXACT\nLOSSES","Losses"]
["Fill in MWHs To be Scheduled at Point of Receipt.  MWHs at Point of Delivery will be reduced by calculated losses.","01:00:00",null,{"$f":"C14-G14","v":0},{"$f":"SUM($C$14:C14)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"C14-E14","v":0},{"$f":"ROUND(F14,0)","v":0}]
[null,"02:00:00",null,0,{"$f":"SUM($C$14:C15)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C15)-E15)-SUM($G$14:G14)","v":0},{"$f":"ROUND(F15,0)","v":0}]
[null,"03:00:00",null,0,{"$f":"SUM($C$14:C16)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C16)-E16)-SUM($G$14:G15)","v":0},0]
[null,"04:00:00",null,0,{"$f":"SUM($C$14:C17)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C17)-E17)-SUM($G$14:G16)","v":0},0]
[null,"05:00:00",null,0,{"$f":"SUM($C$14:C18)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C18)-E18)-SUM($G$14:G17)","v":0},0]
[null,"06:00:00",null,0,{"$f":"SUM($C$14:C19)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C19)-E19)-SUM($G$14:G18)","v":0},0]
[null,"07:00:00",null,0,{"$f":"SUM($C$14:C20)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C20)-E20)-SUM($G$14:G19)","v":0},0]
[null,"08:00:00",null,0,{"$f":"SUM($C$14:C21)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C21)-E21)-SUM($G$14:G20)","v":0},{"$f":"ROUND(F21,0)","v":0}]
[null,"09:00:00",null,0,{"$f":"SUM($C$14:C22)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C22)-E22)-SUM($G$14:G21)","v":0},{"$f":"ROUND(F22,0)","v":0}]
[null,"10:00:00",null,0,{"$f":"SUM($C$14:C23)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C23)-E23)-SUM($G$14:G22)","v":0},{"$f":"ROUND(F23,0)","v":0}]
[null,"11:00:00",null,0,{"$f":"SUM($C$14:C24)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C24)-E24)-SUM($G$14:G23)","v":0},0]
[null,"12:00:00",null,0,{"$f":"SUM($C$14:C25)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C25)-E25)-SUM($G$14:G24)","v":0},0]
[null,"13:00:00",null,0,{"$f":"SUM($C$14:C26)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C26)-E26)-SUM($G$14:G25)","v":0},0]
[null,"14:00:00",null,0,{"$f":"SUM($C$14:C27)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C27)-E27)-SUM($G$14:G26)","v":0},0]
[null,"15:00:00",null,0,{"$f":"SUM($C$14:C28)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C28)-E28)-SUM($G$14:G27)","v":0},0]
[null,"16:00:00",null,0,{"$f":"SUM($C$14:C29)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C29)-E29)-SUM($G$14:G28)","v":0},0]
[null,"17:00:00",null,0,{"$f":"SUM($C$14:C30)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C30)-E30)-SUM($G$14:G29)","v":0},0]
[null,"18:00:00",null,0,{"$f":"SUM($C$14:C31)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C31)-E31)-SUM($G$14:G30)","v":0},0]
[null,"19:00:00",null,0,{"$f":"SUM($C$14:C32)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C32)-E32)-SUM($G$14:G31)","v":0},0]
[null,"20:00:00",null,0,{"$f":"SUM($C$14:C33)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C33)-E33)-SUM($G$14:G32)","v":0},0]
[null,"21:00:00",null,0,{"$f":"SUM($C$14:C34)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C34)-E34)-SUM($G$14:G33)","v":0},0]
[null,"22:00:00",null,0,{"$f":"SUM($C$14:C35)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C35)-E35)-SUM($G$14:G34)","v":0},0]
[null,"23:00:00",null,0,{"$f":"SUM($C$14:C36)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C36)-E36)-SUM($G$14:G35)","v":0},0]
[null,"24:00",null,0,{"$f":"SUM($C$14:C37)/(1+LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$14:C37)-E37)-SUM($G$14:G36)","v":0},0]
[]
["Total",null,{"$f":"SUM(C14:C37)","v":0},{"$f":"SUM(D14:D37)","v":0},{"$f":"E37","v":0},{"$f":"SUM(F14:F37)","v":0},{"$f":"SUM(G14:G37)","v":0}]
[]
[]
[]
[]
[]
[]
["Point of Delivery Calculator"]
[]
[null,"Hour Ending","Point of Receipt (MWH)","Point of Delivery (MWH)","SUM","EXACT\nLOSSES","Losses"]
["Fill in MWHs To be Scheduled at Point of Delivery.  Losses will be added to determine MWHs needed at Point of Receipt.","01:00:00",{"$f":"D49+G49","v":0},null,{"$f":"SUM($D$49:D49)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"E49-D49","v":0},{"$f":"ROUND(F49,0)","v":0}]
[null,"02:00:00",0,null,{"$f":"SUM($D$49:D50)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E50-SUM($D$49:D50))-SUM($G$49:G49)","v":0},{"$f":"ROUND(F50,0)","v":0}]
[null,"03:00:00",0,null,{"$f":"SUM($D$49:D51)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E51-SUM($D$49:D51))-SUM($G$49:G50)","v":0},0]
[null,"04:00:00",0,null,{"$f":"SUM($D$49:D52)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E52-SUM($D$49:D52))-SUM($G$49:G51)","v":0},0]
[null,"05:00:00",0,null,{"$f":"SUM($D$49:D53)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E53-SUM($D$49:D53))-SUM($G$49:G52)","v":0},0]
[null,"06:00:00",0,null,{"$f":"SUM($D$49:D54)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E54-SUM($D$49:D54))-SUM($G$49:G53)","v":0},0]
[null,"07:00:00",0,null,{"$f":"SUM($D$49:D55)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E55-SUM($D$49:D55))-SUM($G$49:G54)","v":0},0]
[null,"08:00:00",0,null,{"$f":"SUM($D$49:D56)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E56-SUM($D$49:D56))-SUM($G$49:G55)","v":0},{"$f":"ROUND(F56,0)","v":0}]
[null,"09:00:00",0,null,{"$f":"SUM($D$49:D57)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E57-SUM($D$49:D57))-SUM($G$49:G56)","v":0},{"$f":"ROUND(F57,0)","v":0}]
[null,"10:00:00",0,null,{"$f":"SUM($D$49:D58)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E58-SUM($D$49:D58))-SUM($G$49:G57)","v":0},{"$f":"ROUND(F58,0)","v":0}]
[null,"11:00:00",0,null,{"$f":"SUM($D$49:D59)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E59-SUM($D$49:D59))-SUM($G$49:G58)","v":0},0]
[null,"12:00:00",0,null,{"$f":"SUM($D$49:D60)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E60-SUM($D$49:D60))-SUM($G$49:G59)","v":0},0]
[null,"13:00:00",0,null,{"$f":"SUM($D$49:D61)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E61-SUM($D$49:D61))-SUM($G$49:G60)","v":0},0]
[null,"14:00:00",0,null,{"$f":"SUM($D$49:D62)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E62-SUM($D$49:D62))-SUM($G$49:G61)","v":0},0]
[null,"15:00:00",0,null,{"$f":"SUM($D$49:D63)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E63-SUM($D$49:D63))-SUM($G$49:G62)","v":0},0]
[null,"16:00:00",0,null,{"$f":"SUM($D$49:D64)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E64-SUM($D$49:D64))-SUM($G$49:G63)","v":0},0]
[null,"17:00:00",0,null,{"$f":"SUM($D$49:D65)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E65-SUM($D$49:D65))-SUM($G$49:G64)","v":0},0]
[null,"18:00:00",0,null,{"$f":"SUM($D$49:D66)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E66-SUM($D$49:D66))-SUM($G$49:G65)","v":0},0]
[null,"19:00:00",0,null,{"$f":"SUM($D$49:D67)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E67-SUM($D$49:D67))-SUM($G$49:G66)","v":0},0]
[null,"20:00:00",0,null,{"$f":"SUM($D$49:D68)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E68-SUM($D$49:D68))-SUM($G$49:G67)","v":0},0]
[null,"21:00:00",0,null,{"$f":"SUM($D$49:D69)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E69-SUM($D$49:D69))-SUM($G$49:G68)","v":0},0]
[null,"22:00:00",0,null,{"$f":"SUM($D$49:D70)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E70-SUM($D$49:D70))-SUM($G$49:G69)","v":0},0]
[null,"23:00:00",0,null,{"$f":"SUM($D$49:D71)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E71-SUM($D$49:D71))-SUM($G$49:G70)","v":0},0]
[null,"24:00",0,null,{"$f":"SUM($D$49:D72)*(1+LOSS_PERCENTAGE)","v":0},{"$f":"(E72-SUM($D$49:D72))-SUM($G$49:G71)","v":0},0]
[]
["Total",null,{"$f":"SUM(C49:C72)","v":0},{"$f":"SUM(D49:D72)","v":0},{"$f":"E72","v":0},{"$f":"SUM(F49:F72)","v":0},{"$f":"SUM(G49:G72)","v":0}]

{"sheet":"Config","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Loss Percentage",2.0899999999999998E-2]
["Effective Date","11/01/2017"]