{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Losses - Day","Losses - Week","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":14,"rows_kept":74,"cut":false,"hidden":false,"merged":[[13,0,15,0],[48,0,51,0],[6,0,6,8]]}
[]
[null,null,"Duke Energy Florida"]
[null,null,"Loss Calculation Tool"]
[null,null,{"$f":"\"Transmission Loss Rate is \" & LOSS_PERCENTAGE*100 & \"%\"","v":"Transmission Loss Rate is 1.38%"}]
[null,null,{"$f":"\"Transmission Loss Rate effective \" & LOSS_EFFECTIVE_DATE","v":"Transmission Loss Rate effective 05/01/2016"}]
[]
["This tool is provided to assist transmission customers in scheduling transmission transactions where transmission losses will be taken from the MWHs scheduled each hour.  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?"]
[]
[null,null,null,"Point of Receipt Calculator",null,null,null,null,null,null,"Point of Receipt Calculator        "]
[null,null,null,"Enter Values for Day #1:",null,null,null,null,null,null,"Enter Values for Day #2 (Optional):           "]
[null,"Hour Ending","Point of Receipt (MWH)","Point of Delivery (MWH)","SUM","EXACT\nLOSSES","Losses",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,"01:00:00",null,{"$f":"J14-N14","v":0},{"$f":"SUM($J$14:J14)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"J14-L14","v":0},{"$f":"ROUND(M14,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,"02:00:00",null,0,{"$f":"SUM($J$14:J15)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J15)-L15)-SUM($N$14:N14)","v":0},{"$f":"ROUND(M15,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,"03:00:00",null,0,{"$f":"SUM($J$14:J16)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J16)-L16)-SUM($N$14:N15)","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,"04:00:00",null,0,{"$f":"SUM($J$14:J17)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J17)-L17)-SUM($N$14:N16)","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,"05:00:00",null,0,{"$f":"SUM($J$14:J18)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J18)-L18)-SUM($N$14:N17)","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,"06:00:00",null,0,{"$f":"SUM($J$14:J19)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J19)-L19)-SUM($N$14:N18)","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,"07:00:00",null,0,{"$f":"SUM($J$14:J20)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J20)-L20)-SUM($N$14:N19)","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,"08:00:00",null,0,{"$f":"SUM($J$14:J21)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J21)-L21)-SUM($N$14:N20)","v":0},{"$f":"ROUND(M21,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,"09:00:00",null,0,{"$f":"SUM($J$14:J22)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J22)-L22)-SUM($N$14:N21)","v":0},{"$f":"ROUND(M22,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,"10:00:00",null,0,{"$f":"SUM($J$14:J23)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J23)-L23)-SUM($N$14:N22)","v":0},{"$f":"ROUND(M23,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,"11:00:00",null,0,{"$f":"SUM($J$14:J24)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J24)-L24)-SUM($N$14:N23)","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,"12:00:00",null,0,{"$f":"SUM($J$14:J25)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J25)-L25)-SUM($N$14:N24)","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,"13:00:00",null,0,{"$f":"SUM($J$14:J26)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J26)-L26)-SUM($N$14:N25)","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,"14:00:00",null,0,{"$f":"SUM($J$14:J27)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J27)-L27)-SUM($N$14:N26)","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,"15:00:00",null,0,{"$f":"SUM($J$14:J28)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J28)-L28)-SUM($N$14:N27)","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,"16:00:00",null,0,{"$f":"SUM($J$14:J29)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J29)-L29)-SUM($N$14:N28)","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,"17:00:00",null,0,{"$f":"SUM($J$14:J30)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J30)-L30)-SUM($N$14:N29)","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,"18:00:00",null,0,{"$f":"SUM($J$14:J31)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J31)-L31)-SUM($N$14:N30)","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,"19:00:00",null,0,{"$f":"SUM($J$14:J32)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J32)-L32)-SUM($N$14:N31)","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,"20:00:00",null,0,{"$f":"SUM($J$14:J33)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J33)-L33)-SUM($N$14:N32)","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,"21:00:00",null,0,{"$f":"SUM($J$14:J34)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J34)-L34)-SUM($N$14:N33)","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,"22:00:00",null,0,{"$f":"SUM($J$14:J35)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J35)-L35)-SUM($N$14:N34)","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,"23:00:00",null,0,{"$f":"SUM($J$14:J36)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J36)-L36)-SUM($N$14:N35)","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,null,"24:00",null,0,{"$f":"SUM($J$14:J37)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($J$14:J37)-L37)-SUM($N$14:N36)","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},null,"Total",{"$f":"SUM(J14:J37)","v":0},{"$f":"SUM(K14:K37)","v":0},{"$f":"L37","v":0},{"$f":"SUM(M14:M37)","v":0},{"$f":"SUM(N14:N37)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,"Point of Delivery Calculator",null,null,null,null,null,null,"Point of Delivery Calculator           "]
[null,null,null,"Enter Values for Day #1:",null,null,null,null,null,null,"Enter Values for Day #2 (Optional):             "]
[null,"Hour Ending","Point of Receipt (MWH)","Point of Delivery (MWH)","SUM","EXACT\nLOSSES","Losses",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,"01:00:00",{"$f":"K49+N49","v":0},null,{"$f":"SUM($K$49:K49)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"L49-K49","v":0},{"$f":"ROUND(M49,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,"02:00:00",0,null,{"$f":"SUM($K$49:K50)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L50-SUM($K$49:K50))-SUM($N$49:N49)","v":0},{"$f":"ROUND(M50,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,"03:00:00",0,null,{"$f":"SUM($K$49:K51)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L51-SUM($K$49:K51))-SUM($N$49:N50)","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,"04:00:00",0,null,{"$f":"SUM($K$49:K52)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L52-SUM($K$49:K52))-SUM($N$49:N51)","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,"05:00:00",0,null,{"$f":"SUM($K$49:K53)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L53-SUM($K$49:K53))-SUM($N$49:N52)","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,"06:00:00",0,null,{"$f":"SUM($K$49:K54)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L54-SUM($K$49:K54))-SUM($N$49:N53)","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,"07:00:00",0,null,{"$f":"SUM($K$49:K55)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L55-SUM($K$49:K55))-SUM($N$49:N54)","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,"08:00:00",0,null,{"$f":"SUM($K$49:K56)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L56-SUM($K$49:K56))-SUM($N$49:N55)","v":0},{"$f":"ROUND(M56,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,"09:00:00",0,null,{"$f":"SUM($K$49:K57)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L57-SUM($K$49:K57))-SUM($N$49:N56)","v":0},{"$f":"ROUND(M57,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,"10:00:00",0,null,{"$f":"SUM($K$49:K58)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L58-SUM($K$49:K58))-SUM($N$49:N57)","v":0},{"$f":"ROUND(M58,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,"11:00:00",0,null,{"$f":"SUM($K$49:K59)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L59-SUM($K$49:K59))-SUM($N$49:N58)","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,"12:00:00",0,null,{"$f":"SUM($K$49:K60)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L60-SUM($K$49:K60))-SUM($N$49:N59)","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,"13:00:00",0,null,{"$f":"SUM($K$49:K61)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L61-SUM($K$49:K61))-SUM($N$49:N60)","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,"14:00:00",0,null,{"$f":"SUM($K$49:K62)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L62-SUM($K$49:K62))-SUM($N$49:N61)","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,"15:00:00",0,null,{"$f":"SUM($K$49:K63)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L63-SUM($K$49:K63))-SUM($N$49:N62)","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,"16:00:00",0,null,{"$f":"SUM($K$49:K64)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L64-SUM($K$49:K64))-SUM($N$49:N63)","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,"17:00:00",0,null,{"$f":"SUM($K$49:K65)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L65-SUM($K$49:K65))-SUM($N$49:N64)","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,"18:00:00",0,null,{"$f":"SUM($K$49:K66)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L66-SUM($K$49:K66))-SUM($N$49:N65)","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,"19:00:00",0,null,{"$f":"SUM($K$49:K67)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L67-SUM($K$49:K67))-SUM($N$49:N66)","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,"20:00:00",0,null,{"$f":"SUM($K$49:K68)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L68-SUM($K$49:K68))-SUM($N$49:N67)","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,"21:00:00",0,null,{"$f":"SUM($K$49:K69)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L69-SUM($K$49:K69))-SUM($N$49:N68)","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,"22:00:00",0,null,{"$f":"SUM($K$49:K70)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L70-SUM($K$49:K70))-SUM($N$49:N69)","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,"23:00:00",0,null,{"$f":"SUM($K$49:K71)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L71-SUM($K$49:K71))-SUM($N$49:N70)","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,null,"24:00",0,null,{"$f":"SUM($K$49:K72)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(L72-SUM($K$49:K72))-SUM($N$49:N71)","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},null,"Total",{"$f":"SUM(J49:J72)","v":0},{"$f":"SUM(K49:K72)","v":0},{"$f":"L72","v":0},{"$f":"SUM(M49:M72)","v":0},{"$f":"SUM(N49:N72)","v":0}]

{"sheet":"Losses - Week","index":1,"n_rows":183,"n_cols":15,"rows_kept":183,"cut":false,"hidden":false,"merged":[[158,8,181,8],[6,1,6,12],[86,0,109,0],[110,0,133,0],[134,0,157,0],[158,0,181,0],[14,8,37,8],[38,8,61,8],[62,8,85,8],[86,8,109,8],[110,8,133,8],[134,8,157,8],[14,0,37,0],[38,0,61,0],[62,0,85,0]]}
[]
[null,null,null,null,null,null,null,"Duke Energy Florida"]
[null,null,null,null,null,null,null,"Loss Calculation Tool"]
[null,null,null,null,null,null,null,{"$f":"\"Transmission Loss Rate is \" & LOSS_PERCENTAGE*100 & \"%\"","v":"Transmission Loss Rate is 1.38%"}]
[null,null,null,null,null,null,null,{"$f":"\"Transmission Loss Rate effective \" & LOSS_EFFECTIVE_DATE","v":"Transmission Loss Rate effective 05/01/2016"}]
[]
[null,"This tool is provided to assist transmission customers in scheduling transmission transactions where transmission losses will be taken from the MWHs scheduled each hour.  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 each hour, where do you want the fixed schedule to be applied?"]
[]
[]
[null,null,null,"Point of Receipt Calculator",null,null,null,null,null,null,null,"Point of Delivery Calculator"]
[null,null,null,"Enter Values for Week #1:",null,null,null,null,null,null,null,"Enter Values for Week #1:"]
["Fill in MWHs To be Scheduled at Point of Receipt.  MWHs at Point of Delivery will be reduced by calculated losses.","Hour Ending","Point of Receipt (MWH)","Point of Delivery (MWH)","SUM","EXACT\nLOSSES","Losses",null,"Fill in MWHs To be Scheduled at Point of Delivery.  Losses will be added to determine MWHs needed at Point of Receipt.","Hour Ending","Point of Receipt (MWH)","Point of Delivery (MWH)","SUM","EXACT\nLOSSES","Losses"]
["Day 1","01:00:00",null,{"$f":"C15-G15","v":0},{"$f":"SUM($C$15:C15)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"C15-E15","v":0},{"$f":"ROUND(F15,0)","v":0},null,"Day 1","01:00:00",{"$f":"L15+O15","v":0},null,{"$f":"SUM($L$15:L15)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"M15-L15","v":0},{"$f":"ROUND(N15,0)","v":0}]
[null,"02:00:00",null,0,{"$f":"SUM($C$15:C16)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C16)-E16)-SUM($G$15:G15)","v":0},{"$f":"ROUND(F16,0)","v":0},null,null,"02:00:00",0,null,{"$f":"SUM($L$15:L16)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M16-SUM($L$15:L16))-SUM($O$15:O15)","v":0},{"$f":"ROUND(N16,0)","v":0}]
[null,"03:00:00",null,0,{"$f":"SUM($C$15:C17)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C17)-E17)-SUM($G$15:G16)","v":0},0,null,null,"03:00:00",0,null,{"$f":"SUM($L$15:L17)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M17-SUM($L$15:L17))-SUM($O$15:O16)","v":0},0]
[null,"04:00:00",null,0,{"$f":"SUM($C$15:C18)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C18)-E18)-SUM($G$15:G17)","v":0},0,null,null,"04:00:00",0,null,{"$f":"SUM($L$15:L18)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M18-SUM($L$15:L18))-SUM($O$15:O17)","v":0},0]
[null,"05:00:00",null,0,{"$f":"SUM($C$15:C19)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C19)-E19)-SUM($G$15:G18)","v":0},0,null,null,"05:00:00",0,null,{"$f":"SUM($L$15:L19)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M19-SUM($L$15:L19))-SUM($O$15:O18)","v":0},0]
[null,"06:00:00",null,0,{"$f":"SUM($C$15:C20)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C20)-E20)-SUM($G$15:G19)","v":0},0,null,null,"06:00:00",0,null,{"$f":"SUM($L$15:L20)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M20-SUM($L$15:L20))-SUM($O$15:O19)","v":0},0]
[null,"07:00:00",null,0,{"$f":"SUM($C$15:C21)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C21)-E21)-SUM($G$15:G20)","v":0},0,null,null,"07:00:00",0,null,{"$f":"SUM($L$15:L21)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M21-SUM($L$15:L21))-SUM($O$15:O20)","v":0},0]
[null,"08:00:00",null,0,{"$f":"SUM($C$15:C22)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C22)-E22)-SUM($G$15:G21)","v":0},{"$f":"ROUND(F22,0)","v":0},null,null,"08:00:00",0,null,{"$f":"SUM($L$15:L22)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M22-SUM($L$15:L22))-SUM($O$15:O21)","v":0},{"$f":"ROUND(N22,0)","v":0}]
[null,"09:00:00",null,0,{"$f":"SUM($C$15:C23)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C23)-E23)-SUM($G$15:G22)","v":0},{"$f":"ROUND(F23,0)","v":0},null,null,"09:00:00",0,null,{"$f":"SUM($L$15:L23)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M23-SUM($L$15:L23))-SUM($O$15:O22)","v":0},{"$f":"ROUND(N23,0)","v":0}]
[null,"10:00:00",null,0,{"$f":"SUM($C$15:C24)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C24)-E24)-SUM($G$15:G23)","v":0},{"$f":"ROUND(F24,0)","v":0},null,null,"10:00:00",0,null,{"$f":"SUM($L$15:L24)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M24-SUM($L$15:L24))-SUM($O$15:O23)","v":0},{"$f":"ROUND(N24,0)","v":0}]
[null,"11:00:00",null,0,{"$f":"SUM($C$15:C25)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C25)-E25)-SUM($G$15:G24)","v":0},0,null,null,"11:00:00",0,null,{"$f":"SUM($L$15:L25)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M25-SUM($L$15:L25))-SUM($O$15:O24)","v":0},0]
[null,"12:00:00",null,0,{"$f":"SUM($C$15:C26)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C26)-E26)-SUM($G$15:G25)","v":0},0,null,null,"12:00:00",0,null,{"$f":"SUM($L$15:L26)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M26-SUM($L$15:L26))-SUM($O$15:O25)","v":0},0]
[null,"13:00:00",null,0,{"$f":"SUM($C$15:C27)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C27)-E27)-SUM($G$15:G26)","v":0},0,null,null,"13:00:00",0,null,{"$f":"SUM($L$15:L27)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M27-SUM($L$15:L27))-SUM($O$15:O26)","v":0},0]
[null,"14:00:00",null,0,{"$f":"SUM($C$15:C28)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C28)-E28)-SUM($G$15:G27)","v":0},0,null,null,"14:00:00",0,null,{"$f":"SUM($L$15:L28)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M28-SUM($L$15:L28))-SUM($O$15:O27)","v":0},0]
[null,"15:00:00",null,0,{"$f":"SUM($C$15:C29)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C29)-E29)-SUM($G$15:G28)","v":0},0,null,null,"15:00:00",0,null,{"$f":"SUM($L$15:L29)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M29-SUM($L$15:L29))-SUM($O$15:O28)","v":0},0]
[null,"16:00:00",null,0,{"$f":"SUM($C$15:C30)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C30)-E30)-SUM($G$15:G29)","v":0},0,null,null,"16:00:00",0,null,{"$f":"SUM($L$15:L30)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M30-SUM($L$15:L30))-SUM($O$15:O29)","v":0},0]
[null,"17:00:00",null,0,{"$f":"SUM($C$15:C31)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C31)-E31)-SUM($G$15:G30)","v":0},0,null,null,"17:00:00",0,null,{"$f":"SUM($L$15:L31)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M31-SUM($L$15:L31))-SUM($O$15:O30)","v":0},0]
[null,"18:00:00",null,0,{"$f":"SUM($C$15:C32)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C32)-E32)-SUM($G$15:G31)","v":0},0,null,null,"18:00:00",0,null,{"$f":"SUM($L$15:L32)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M32-SUM($L$15:L32))-SUM($O$15:O31)","v":0},0]
[null,"19:00:00",null,0,{"$f":"SUM($C$15:C33)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C33)-E33)-SUM($G$15:G32)","v":0},0,null,null,"19:00:00",0,null,{"$f":"SUM($L$15:L33)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M33-SUM($L$15:L33))-SUM($O$15:O32)","v":0},0]
[null,"20:00:00",null,0,{"$f":"SUM($C$15:C34)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C34)-E34)-SUM($G$15:G33)","v":0},0,null,null,"20:00:00",0,null,{"$f":"SUM($L$15:L34)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M34-SUM($L$15:L34))-SUM($O$15:O33)","v":0},0]
[null,"21:00:00",null,0,{"$f":"SUM($C$15:C35)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C35)-E35)-SUM($G$15:G34)","v":0},0,null,null,"21:00:00",0,null,{"$f":"SUM($L$15:L35)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M35-SUM($L$15:L35))-SUM($O$15:O34)","v":0},0]
[null,"22:00:00",null,0,{"$f":"SUM($C$15:C36)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C36)-E36)-SUM($G$15:G35)","v":0},0,null,null,"22:00:00",0,null,{"$f":"SUM($L$15:L36)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M36-SUM($L$15:L36))-SUM($O$15:O35)","v":0},0]
[null,"23:00:00",null,0,{"$f":"SUM($C$15:C37)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C37)-E37)-SUM($G$15:G36)","v":0},0,null,null,"23:00:00",0,null,{"$f":"SUM($L$15:L37)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M37-SUM($L$15:L37))-SUM($O$15:O36)","v":0},0]
[null,"24:00",null,0,{"$f":"SUM($C$15:C38)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C38)-E38)-SUM($G$15:G37)","v":0},0,null,null,"24:00",0,null,{"$f":"SUM($L$15:L38)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M38-SUM($L$15:L38))-SUM($O$15:O37)","v":0},0]
["Day 2","01:00:00",null,0,{"$f":"SUM($C$15:C39)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C39)-E39)-SUM($G$15:G38)","v":0},0,null,"Day 2","01:00:00",0,null,{"$f":"SUM($L$15:L39)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M39-SUM($L$15:L39))-SUM($O$15:O38)","v":0},0]
[null,"02:00:00",null,0,{"$f":"SUM($C$15:C40)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C40)-E40)-SUM($G$15:G39)","v":0},0,null,null,"02:00:00",0,null,{"$f":"SUM($L$15:L40)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M40-SUM($L$15:L40))-SUM($O$15:O39)","v":0},0]
[null,"03:00:00",null,0,{"$f":"SUM($C$15:C41)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C41)-E41)-SUM($G$15:G40)","v":0},0,null,null,"03:00:00",0,null,{"$f":"SUM($L$15:L41)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M41-SUM($L$15:L41))-SUM($O$15:O40)","v":0},0]
[null,"04:00:00",null,0,{"$f":"SUM($C$15:C42)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C42)-E42)-SUM($G$15:G41)","v":0},0,null,null,"04:00:00",0,null,{"$f":"SUM($L$15:L42)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M42-SUM($L$15:L42))-SUM($O$15:O41)","v":0},0]
[null,"05:00:00",null,0,{"$f":"SUM($C$15:C43)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C43)-E43)-SUM($G$15:G42)","v":0},0,null,null,"05:00:00",0,null,{"$f":"SUM($L$15:L43)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M43-SUM($L$15:L43))-SUM($O$15:O42)","v":0},0]
[null,"06:00:00",null,0,{"$f":"SUM($C$15:C44)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C44)-E44)-SUM($G$15:G43)","v":0},0,null,null,"06:00:00",0,null,{"$f":"SUM($L$15:L44)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M44-SUM($L$15:L44))-SUM($O$15:O43)","v":0},0]
[null,"07:00:00",null,0,{"$f":"SUM($C$15:C45)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C45)-E45)-SUM($G$15:G44)","v":0},0,null,null,"07:00:00",0,null,{"$f":"SUM($L$15:L45)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M45-SUM($L$15:L45))-SUM($O$15:O44)","v":0},0]
[null,"08:00:00",null,0,{"$f":"SUM($C$15:C46)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C46)-E46)-SUM($G$15:G45)","v":0},0,null,null,"08:00:00",0,null,{"$f":"SUM($L$15:L46)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M46-SUM($L$15:L46))-SUM($O$15:O45)","v":0},0]
[null,"09:00:00",null,0,{"$f":"SUM($C$15:C47)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C47)-E47)-SUM($G$15:G46)","v":0},0,null,null,"09:00:00",0,null,{"$f":"SUM($L$15:L47)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M47-SUM($L$15:L47))-SUM($O$15:O46)","v":0},0]
[null,"10:00:00",null,0,{"$f":"SUM($C$15:C48)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C48)-E48)-SUM($G$15:G47)","v":0},0,null,null,"10:00:00",0,null,{"$f":"SUM($L$15:L48)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M48-SUM($L$15:L48))-SUM($O$15:O47)","v":0},0]
[null,"11:00:00",null,0,{"$f":"SUM($C$15:C49)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C49)-E49)-SUM($G$15:G48)","v":0},0,null,null,"11:00:00",0,null,{"$f":"SUM($L$15:L49)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M49-SUM($L$15:L49))-SUM($O$15:O48)","v":0},0]
[null,"12:00:00",null,0,{"$f":"SUM($C$15:C50)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C50)-E50)-SUM($G$15:G49)","v":0},0,null,null,"12:00:00",0,null,{"$f":"SUM($L$15:L50)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M50-SUM($L$15:L50))-SUM($O$15:O49)","v":0},0]
[null,"13:00:00",null,0,{"$f":"SUM($C$15:C51)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C51)-E51)-SUM($G$15:G50)","v":0},0,null,null,"13:00:00",0,null,{"$f":"SUM($L$15:L51)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M51-SUM($L$15:L51))-SUM($O$15:O50)","v":0},0]
[null,"14:00:00",null,0,{"$f":"SUM($C$15:C52)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C52)-E52)-SUM($G$15:G51)","v":0},0,null,null,"14:00:00",0,null,{"$f":"SUM($L$15:L52)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M52-SUM($L$15:L52))-SUM($O$15:O51)","v":0},0]
[null,"15:00:00",null,0,{"$f":"SUM($C$15:C53)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C53)-E53)-SUM($G$15:G52)","v":0},0,null,null,"15:00:00",0,null,{"$f":"SUM($L$15:L53)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M53-SUM($L$15:L53))-SUM($O$15:O52)","v":0},0]
[null,"16:00:00",null,0,{"$f":"SUM($C$15:C54)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C54)-E54)-SUM($G$15:G53)","v":0},0,null,null,"16:00:00",0,null,{"$f":"SUM($L$15:L54)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M54-SUM($L$15:L54))-SUM($O$15:O53)","v":0},0]
[null,"17:00:00",null,0,{"$f":"SUM($C$15:C55)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C55)-E55)-SUM($G$15:G54)","v":0},0,null,null,"17:00:00",0,null,{"$f":"SUM($L$15:L55)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M55-SUM($L$15:L55))-SUM($O$15:O54)","v":0},0]
[null,"18:00:00",null,0,{"$f":"SUM($C$15:C56)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C56)-E56)-SUM($G$15:G55)","v":0},0,null,null,"18:00:00",0,null,{"$f":"SUM($L$15:L56)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M56-SUM($L$15:L56))-SUM($O$15:O55)","v":0},0]
[null,"19:00:00",null,0,{"$f":"SUM($C$15:C57)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C57)-E57)-SUM($G$15:G56)","v":0},0,null,null,"19:00:00",0,null,{"$f":"SUM($L$15:L57)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M57-SUM($L$15:L57))-SUM($O$15:O56)","v":0},0]
[null,"20:00:00",null,0,{"$f":"SUM($C$15:C58)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C58)-E58)-SUM($G$15:G57)","v":0},0,null,null,"20:00:00",0,null,{"$f":"SUM($L$15:L58)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M58-SUM($L$15:L58))-SUM($O$15:O57)","v":0},0]
[null,"21:00:00",null,0,{"$f":"SUM($C$15:C59)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C59)-E59)-SUM($G$15:G58)","v":0},0,null,null,"21:00:00",0,null,{"$f":"SUM($L$15:L59)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M59-SUM($L$15:L59))-SUM($O$15:O58)","v":0},0]
[null,"22:00:00",null,0,{"$f":"SUM($C$15:C60)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C60)-E60)-SUM($G$15:G59)","v":0},0,null,null,"22:00:00",0,null,{"$f":"SUM($L$15:L60)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M60-SUM($L$15:L60))-SUM($O$15:O59)","v":0},0]
[null,"23:00:00",null,0,{"$f":"SUM($C$15:C61)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C61)-E61)-SUM($G$15:G60)","v":0},0,null,null,"23:00:00",0,null,{"$f":"SUM($L$15:L61)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M61-SUM($L$15:L61))-SUM($O$15:O60)","v":0},0]
[null,"24:00",null,0,{"$f":"SUM($C$15:C62)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C62)-E62)-SUM($G$15:G61)","v":0},0,null,null,"24:00",0,null,{"$f":"SUM($L$15:L62)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M62-SUM($L$15:L62))-SUM($O$15:O61)","v":0},0]
["Day 3","01:00:00",null,0,{"$f":"SUM($C$15:C63)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C63)-E63)-SUM($G$15:G62)","v":0},0,null,"Day 3","01:00:00",0,null,{"$f":"SUM($L$15:L63)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M63-SUM($L$15:L63))-SUM($O$15:O62)","v":0},0]
[null,"02:00:00",null,0,{"$f":"SUM($C$15:C64)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C64)-E64)-SUM($G$15:G63)","v":0},0,null,null,"02:00:00",0,null,{"$f":"SUM($L$15:L64)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M64-SUM($L$15:L64))-SUM($O$15:O63)","v":0},0]
[null,"03:00:00",null,0,{"$f":"SUM($C$15:C65)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C65)-E65)-SUM($G$15:G64)","v":0},0,null,null,"03:00:00",0,null,{"$f":"SUM($L$15:L65)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M65-SUM($L$15:L65))-SUM($O$15:O64)","v":0},0]
[null,"04:00:00",null,0,{"$f":"SUM($C$15:C66)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C66)-E66)-SUM($G$15:G65)","v":0},0,null,null,"04:00:00",0,null,{"$f":"SUM($L$15:L66)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M66-SUM($L$15:L66))-SUM($O$15:O65)","v":0},0]
[null,"05:00:00",null,0,{"$f":"SUM($C$15:C67)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C67)-E67)-SUM($G$15:G66)","v":0},0,null,null,"05:00:00",0,null,{"$f":"SUM($L$15:L67)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M67-SUM($L$15:L67))-SUM($O$15:O66)","v":0},0]
[null,"06:00:00",null,0,{"$f":"SUM($C$15:C68)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C68)-E68)-SUM($G$15:G67)","v":0},0,null,null,"06:00:00",0,null,{"$f":"SUM($L$15:L68)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M68-SUM($L$15:L68))-SUM($O$15:O67)","v":0},0]
[null,"07:00:00",null,0,{"$f":"SUM($C$15:C69)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C69)-E69)-SUM($G$15:G68)","v":0},0,null,null,"07:00:00",0,null,{"$f":"SUM($L$15:L69)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M69-SUM($L$15:L69))-SUM($O$15:O68)","v":0},0]
[null,"08:00:00",null,0,{"$f":"SUM($C$15:C70)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C70)-E70)-SUM($G$15:G69)","v":0},0,null,null,"08:00:00",0,null,{"$f":"SUM($L$15:L70)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M70-SUM($L$15:L70))-SUM($O$15:O69)","v":0},0]
[null,"09:00:00",null,0,{"$f":"SUM($C$15:C71)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C71)-E71)-SUM($G$15:G70)","v":0},0,null,null,"09:00:00",0,null,{"$f":"SUM($L$15:L71)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M71-SUM($L$15:L71))-SUM($O$15:O70)","v":0},0]
[null,"10:00:00",null,0,{"$f":"SUM($C$15:C72)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C72)-E72)-SUM($G$15:G71)","v":0},0,null,null,"10:00:00",0,null,{"$f":"SUM($L$15:L72)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M72-SUM($L$15:L72))-SUM($O$15:O71)","v":0},0]
[null,"11:00:00",null,0,{"$f":"SUM($C$15:C73)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C73)-E73)-SUM($G$15:G72)","v":0},0,null,null,"11:00:00",0,null,{"$f":"SUM($L$15:L73)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M73-SUM($L$15:L73))-SUM($O$15:O72)","v":0},0]
[null,"12:00:00",null,0,{"$f":"SUM($C$15:C74)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C74)-E74)-SUM($G$15:G73)","v":0},0,null,null,"12:00:00",0,null,{"$f":"SUM($L$15:L74)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M74-SUM($L$15:L74))-SUM($O$15:O73)","v":0},0]
[null,"13:00:00",null,0,{"$f":"SUM($C$15:C75)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C75)-E75)-SUM($G$15:G74)","v":0},0,null,null,"13:00:00",0,null,{"$f":"SUM($L$15:L75)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M75-SUM($L$15:L75))-SUM($O$15:O74)","v":0},0]
[null,"14:00:00",null,0,{"$f":"SUM($C$15:C76)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C76)-E76)-SUM($G$15:G75)","v":0},0,null,null,"14:00:00",0,null,{"$f":"SUM($L$15:L76)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M76-SUM($L$15:L76))-SUM($O$15:O75)","v":0},0]
[null,"15:00:00",null,0,{"$f":"SUM($C$15:C77)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C77)-E77)-SUM($G$15:G76)","v":0},0,null,null,"15:00:00",0,null,{"$f":"SUM($L$15:L77)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M77-SUM($L$15:L77))-SUM($O$15:O76)","v":0},0]
[null,"16:00:00",null,0,{"$f":"SUM($C$15:C78)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C78)-E78)-SUM($G$15:G77)","v":0},0,null,null,"16:00:00",0,null,{"$f":"SUM($L$15:L78)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M78-SUM($L$15:L78))-SUM($O$15:O77)","v":0},0]
[null,"17:00:00",null,{"$f":"C79-G79","v":0},{"$f":"SUM($C$15:C79)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C79)-E79)-SUM($G$15:G78)","v":0},0,null,null,"17:00:00",{"$f":"L79+O79","v":0},null,{"$f":"SUM($L$15:L79)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M79-SUM($L$15:L79))-SUM($O$15:O78)","v":0},0]
[null,"18:00:00",null,0,{"$f":"SUM($C$15:C80)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C80)-E80)-SUM($G$15:G79)","v":0},0,null,null,"18:00:00",0,null,{"$f":"SUM($L$15:L80)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M80-SUM($L$15:L80))-SUM($O$15:O79)","v":0},0]
[null,"19:00:00",null,0,{"$f":"SUM($C$15:C81)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C81)-E81)-SUM($G$15:G80)","v":0},0,null,null,"19:00:00",0,null,{"$f":"SUM($L$15:L81)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M81-SUM($L$15:L81))-SUM($O$15:O80)","v":0},0]
[null,"20:00:00",null,0,{"$f":"SUM($C$15:C82)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C82)-E82)-SUM($G$15:G81)","v":0},0,null,null,"20:00:00",0,null,{"$f":"SUM($L$15:L82)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M82-SUM($L$15:L82))-SUM($O$15:O81)","v":0},0]
[null,"21:00:00",null,0,{"$f":"SUM($C$15:C83)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C83)-E83)-SUM($G$15:G82)","v":0},0,null,null,"21:00:00",0,null,{"$f":"SUM($L$15:L83)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M83-SUM($L$15:L83))-SUM($O$15:O82)","v":0},0]
[null,"22:00:00",null,0,{"$f":"SUM($C$15:C84)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C84)-E84)-SUM($G$15:G83)","v":0},0,null,null,"22:00:00",0,null,{"$f":"SUM($L$15:L84)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M84-SUM($L$15:L84))-SUM($O$15:O83)","v":0},0]
[null,"23:00:00",null,0,{"$f":"SUM($C$15:C85)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C85)-E85)-SUM($G$15:G84)","v":0},0,null,null,"23:00:00",0,null,{"$f":"SUM($L$15:L85)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M85-SUM($L$15:L85))-SUM($O$15:O84)","v":0},0]
[null,"24:00",null,0,{"$f":"SUM($C$15:C86)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C86)-E86)-SUM($G$15:G85)","v":0},0,null,null,"24:00",0,null,{"$f":"SUM($L$15:L86)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M86-SUM($L$15:L86))-SUM($O$15:O85)","v":0},0]
["Day 4","01:00:00",null,0,{"$f":"SUM($C$15:C87)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C87)-E87)-SUM($G$15:G86)","v":0},0,null,"Day 4","01:00:00",0,null,{"$f":"SUM($L$15:L87)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M87-SUM($L$15:L87))-SUM($O$15:O86)","v":0},0]
[null,"02:00:00",null,0,{"$f":"SUM($C$15:C88)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C88)-E88)-SUM($G$15:G87)","v":0},{"$f":"ROUND(F88,0)","v":0},null,null,"02:00:00",0,null,{"$f":"SUM($L$15:L88)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M88-SUM($L$15:L88))-SUM($O$15:O87)","v":0},{"$f":"ROUND(N88,0)","v":0}]
[null,"03:00:00",null,0,{"$f":"SUM($C$15:C89)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C89)-E89)-SUM($G$15:G88)","v":0},0,null,null,"03:00:00",0,null,{"$f":"SUM($L$15:L89)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M89-SUM($L$15:L89))-SUM($O$15:O88)","v":0},0]
[null,"04:00:00",null,0,{"$f":"SUM($C$15:C90)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C90)-E90)-SUM($G$15:G89)","v":0},0,null,null,"04:00:00",0,null,{"$f":"SUM($L$15:L90)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M90-SUM($L$15:L90))-SUM($O$15:O89)","v":0},0]
[null,"05:00:00",null,0,{"$f":"SUM($C$15:C91)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C91)-E91)-SUM($G$15:G90)","v":0},0,null,null,"05:00:00",0,null,{"$f":"SUM($L$15:L91)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M91-SUM($L$15:L91))-SUM($O$15:O90)","v":0},0]
[null,"06:00:00",null,0,{"$f":"SUM($C$15:C92)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C92)-E92)-SUM($G$15:G91)","v":0},0,null,null,"06:00:00",0,null,{"$f":"SUM($L$15:L92)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M92-SUM($L$15:L92))-SUM($O$15:O91)","v":0},0]
[null,"07:00:00",null,0,{"$f":"SUM($C$15:C93)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C93)-E93)-SUM($G$15:G92)","v":0},0,null,null,"07:00:00",0,null,{"$f":"SUM($L$15:L93)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M93-SUM($L$15:L93))-SUM($O$15:O92)","v":0},0]
[null,"08:00:00",null,0,{"$f":"SUM($C$15:C94)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C94)-E94)-SUM($G$15:G93)","v":0},0,null,null,"08:00:00",0,null,{"$f":"SUM($L$15:L94)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M94-SUM($L$15:L94))-SUM($O$15:O93)","v":0},0]
[null,"09:00:00",null,0,{"$f":"SUM($C$15:C95)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C95)-E95)-SUM($G$15:G94)","v":0},0,null,null,"09:00:00",0,null,{"$f":"SUM($L$15:L95)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M95-SUM($L$15:L95))-SUM($O$15:O94)","v":0},0]
[null,"10:00:00",null,0,{"$f":"SUM($C$15:C96)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C96)-E96)-SUM($G$15:G95)","v":0},0,null,null,"10:00:00",0,null,{"$f":"SUM($L$15:L96)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M96-SUM($L$15:L96))-SUM($O$15:O95)","v":0},0]
[null,"11:00:00",null,0,{"$f":"SUM($C$15:C97)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C97)-E97)-SUM($G$15:G96)","v":0},0,null,null,"11:00:00",0,null,{"$f":"SUM($L$15:L97)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M97-SUM($L$15:L97))-SUM($O$15:O96)","v":0},0]
[null,"12:00:00",null,0,{"$f":"SUM($C$15:C98)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C98)-E98)-SUM($G$15:G97)","v":0},0,null,null,"12:00:00",0,null,{"$f":"SUM($L$15:L98)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M98-SUM($L$15:L98))-SUM($O$15:O97)","v":0},0]
[null,"13:00:00",null,0,{"$f":"SUM($C$15:C99)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C99)-E99)-SUM($G$15:G98)","v":0},0,null,null,"13:00:00",0,null,{"$f":"SUM($L$15:L99)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M99-SUM($L$15:L99))-SUM($O$15:O98)","v":0},0]
[null,"14:00:00",null,0,{"$f":"SUM($C$15:C100)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C100)-E100)-SUM($G$15:G99)","v":0},0,null,null,"14:00:00",0,null,{"$f":"SUM($L$15:L100)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M100-SUM($L$15:L100))-SUM($O$15:O99)","v":0},0]
[null,"15:00:00",null,0,{"$f":"SUM($C$15:C101)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C101)-E101)-SUM($G$15:G100)","v":0},0,null,null,"15:00:00",0,null,{"$f":"SUM($L$15:L101)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M101-SUM($L$15:L101))-SUM($O$15:O100)","v":0},0]
[null,"16:00:00",null,0,{"$f":"SUM($C$15:C102)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C102)-E102)-SUM($G$15:G101)","v":0},0,null,null,"16:00:00",0,null,{"$f":"SUM($L$15:L102)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M102-SUM($L$15:L102))-SUM($O$15:O101)","v":0},0]
[null,"17:00:00",null,0,{"$f":"SUM($C$15:C103)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C103)-E103)-SUM($G$15:G102)","v":0},0,null,null,"17:00:00",0,null,{"$f":"SUM($L$15:L103)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M103-SUM($L$15:L103))-SUM($O$15:O102)","v":0},0]
[null,"18:00:00",null,0,{"$f":"SUM($C$15:C104)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C104)-E104)-SUM($G$15:G103)","v":0},0,null,null,"18:00:00",0,null,{"$f":"SUM($L$15:L104)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M104-SUM($L$15:L104))-SUM($O$15:O103)","v":0},0]
[null,"19:00:00",null,0,{"$f":"SUM($C$15:C105)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C105)-E105)-SUM($G$15:G104)","v":0},0,null,null,"19:00:00",0,null,{"$f":"SUM($L$15:L105)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M105-SUM($L$15:L105))-SUM($O$15:O104)","v":0},0]
[null,"20:00:00",null,0,{"$f":"SUM($C$15:C106)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C106)-E106)-SUM($G$15:G105)","v":0},0,null,null,"20:00:00",0,null,{"$f":"SUM($L$15:L106)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M106-SUM($L$15:L106))-SUM($O$15:O105)","v":0},0]
[null,"21:00:00",null,0,{"$f":"SUM($C$15:C107)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C107)-E107)-SUM($G$15:G106)","v":0},0,null,null,"21:00:00",0,null,{"$f":"SUM($L$15:L107)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M107-SUM($L$15:L107))-SUM($O$15:O106)","v":0},0]
[null,"22:00:00",null,0,{"$f":"SUM($C$15:C108)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C108)-E108)-SUM($G$15:G107)","v":0},0,null,null,"22:00:00",0,null,{"$f":"SUM($L$15:L108)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M108-SUM($L$15:L108))-SUM($O$15:O107)","v":0},0]
[null,"23:00:00",null,0,{"$f":"SUM($C$15:C109)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C109)-E109)-SUM($G$15:G108)","v":0},0,null,null,"23:00:00",0,null,{"$f":"SUM($L$15:L109)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M109-SUM($L$15:L109))-SUM($O$15:O108)","v":0},0]
[null,"24:00",null,0,{"$f":"SUM($C$15:C110)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C110)-E110)-SUM($G$15:G109)","v":0},0,null,null,"24:00",0,null,{"$f":"SUM($L$15:L110)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M110-SUM($L$15:L110))-SUM($O$15:O109)","v":0},0]
["Day 5","01:00:00",null,0,{"$f":"SUM($C$15:C111)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C111)-E111)-SUM($G$15:G110)","v":0},0,null,"Day 5","01:00:00",0,null,{"$f":"SUM($L$15:L111)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M111-SUM($L$15:L111))-SUM($O$15:O110)","v":0},0]
[null,"02:00:00",null,0,{"$f":"SUM($C$15:C112)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C112)-E112)-SUM($G$15:G111)","v":0},0,null,null,"02:00:00",0,null,{"$f":"SUM($L$15:L112)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M112-SUM($L$15:L112))-SUM($O$15:O111)","v":0},0]
[null,"03:00:00",null,0,{"$f":"SUM($C$15:C113)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C113)-E113)-SUM($G$15:G112)","v":0},0,null,null,"03:00:00",0,null,{"$f":"SUM($L$15:L113)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M113-SUM($L$15:L113))-SUM($O$15:O112)","v":0},0]
[null,"04:00:00",null,0,{"$f":"SUM($C$15:C114)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C114)-E114)-SUM($G$15:G113)","v":0},0,null,null,"04:00:00",0,null,{"$f":"SUM($L$15:L114)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M114-SUM($L$15:L114))-SUM($O$15:O113)","v":0},0]
[null,"05:00:00",null,0,{"$f":"SUM($C$15:C115)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C115)-E115)-SUM($G$15:G114)","v":0},0,null,null,"05:00:00",0,null,{"$f":"SUM($L$15:L115)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M115-SUM($L$15:L115))-SUM($O$15:O114)","v":0},0]
[null,"06:00:00",null,0,{"$f":"SUM($C$15:C116)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C116)-E116)-SUM($G$15:G115)","v":0},0,null,null,"06:00:00",0,null,{"$f":"SUM($L$15:L116)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M116-SUM($L$15:L116))-SUM($O$15:O115)","v":0},0]
[null,"07:00:00",null,0,{"$f":"SUM($C$15:C117)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C117)-E117)-SUM($G$15:G116)","v":0},0,null,null,"07:00:00",0,null,{"$f":"SUM($L$15:L117)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M117-SUM($L$15:L117))-SUM($O$15:O116)","v":0},0]
[null,"08:00:00",null,0,{"$f":"SUM($C$15:C118)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C118)-E118)-SUM($G$15:G117)","v":0},0,null,null,"08:00:00",0,null,{"$f":"SUM($L$15:L118)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M118-SUM($L$15:L118))-SUM($O$15:O117)","v":0},0]
[null,"09:00:00",null,0,{"$f":"SUM($C$15:C119)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C119)-E119)-SUM($G$15:G118)","v":0},0,null,null,"09:00:00",0,null,{"$f":"SUM($L$15:L119)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M119-SUM($L$15:L119))-SUM($O$15:O118)","v":0},0]
[null,"10:00:00",null,0,{"$f":"SUM($C$15:C120)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C120)-E120)-SUM($G$15:G119)","v":0},0,null,null,"10:00:00",0,null,{"$f":"SUM($L$15:L120)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M120-SUM($L$15:L120))-SUM($O$15:O119)","v":0},0]
[null,"11:00:00",null,0,{"$f":"SUM($C$15:C121)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C121)-E121)-SUM($G$15:G120)","v":0},0,null,null,"11:00:00",0,null,{"$f":"SUM($L$15:L121)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M121-SUM($L$15:L121))-SUM($O$15:O120)","v":0},0]
[null,"12:00:00",null,0,{"$f":"SUM($C$15:C122)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C122)-E122)-SUM($G$15:G121)","v":0},0,null,null,"12:00:00",0,null,{"$f":"SUM($L$15:L122)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M122-SUM($L$15:L122))-SUM($O$15:O121)","v":0},0]
[null,"13:00:00",null,0,{"$f":"SUM($C$15:C123)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C123)-E123)-SUM($G$15:G122)","v":0},0,null,null,"13:00:00",0,null,{"$f":"SUM($L$15:L123)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M123-SUM($L$15:L123))-SUM($O$15:O122)","v":0},0]
[null,"14:00:00",null,0,{"$f":"SUM($C$15:C124)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C124)-E124)-SUM($G$15:G123)","v":0},0,null,null,"14:00:00",0,null,{"$f":"SUM($L$15:L124)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M124-SUM($L$15:L124))-SUM($O$15:O123)","v":0},0]
[null,"15:00:00",null,0,{"$f":"SUM($C$15:C125)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C125)-E125)-SUM($G$15:G124)","v":0},0,null,null,"15:00:00",0,null,{"$f":"SUM($L$15:L125)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M125-SUM($L$15:L125))-SUM($O$15:O124)","v":0},0]
[null,"16:00:00",null,0,{"$f":"SUM($C$15:C126)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C126)-E126)-SUM($G$15:G125)","v":0},0,null,null,"16:00:00",0,null,{"$f":"SUM($L$15:L126)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M126-SUM($L$15:L126))-SUM($O$15:O125)","v":0},0]
[null,"17:00:00",null,0,{"$f":"SUM($C$15:C127)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C127)-E127)-SUM($G$15:G126)","v":0},0,null,null,"17:00:00",0,null,{"$f":"SUM($L$15:L127)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M127-SUM($L$15:L127))-SUM($O$15:O126)","v":0},0]
[null,"18:00:00",null,0,{"$f":"SUM($C$15:C128)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C128)-E128)-SUM($G$15:G127)","v":0},0,null,null,"18:00:00",0,null,{"$f":"SUM($L$15:L128)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M128-SUM($L$15:L128))-SUM($O$15:O127)","v":0},0]
[null,"19:00:00",null,0,{"$f":"SUM($C$15:C129)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C129)-E129)-SUM($G$15:G128)","v":0},0,null,null,"19:00:00",0,null,{"$f":"SUM($L$15:L129)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M129-SUM($L$15:L129))-SUM($O$15:O128)","v":0},0]
[null,"20:00:00",null,0,{"$f":"SUM($C$15:C130)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C130)-E130)-SUM($G$15:G129)","v":0},0,null,null,"20:00:00",0,null,{"$f":"SUM($L$15:L130)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M130-SUM($L$15:L130))-SUM($O$15:O129)","v":0},0]
[null,"21:00:00",null,0,{"$f":"SUM($C$15:C131)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C131)-E131)-SUM($G$15:G130)","v":0},0,null,null,"21:00:00",0,null,{"$f":"SUM($L$15:L131)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M131-SUM($L$15:L131))-SUM($O$15:O130)","v":0},0]
[null,"22:00:00",null,0,{"$f":"SUM($C$15:C132)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C132)-E132)-SUM($G$15:G131)","v":0},0,null,null,"22:00:00",0,null,{"$f":"SUM($L$15:L132)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M132-SUM($L$15:L132))-SUM($O$15:O131)","v":0},0]
[null,"23:00:00",null,0,{"$f":"SUM($C$15:C133)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C133)-E133)-SUM($G$15:G132)","v":0},0,null,null,"23:00:00",0,null,{"$f":"SUM($L$15:L133)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M133-SUM($L$15:L133))-SUM($O$15:O132)","v":0},0]
[null,"24:00",null,0,{"$f":"SUM($C$15:C134)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C134)-E134)-SUM($G$15:G133)","v":0},0,null,null,"24:00",0,null,{"$f":"SUM($L$15:L134)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M134-SUM($L$15:L134))-SUM($O$15:O133)","v":0},0]
["Day 6","01:00:00",null,0,{"$f":"SUM($C$15:C135)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C135)-E135)-SUM($G$15:G134)","v":0},0,null,"Day 6","01:00:00",0,null,{"$f":"SUM($L$15:L135)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M135-SUM($L$15:L135))-SUM($O$15:O134)","v":0},0]
[null,"02:00:00",null,0,{"$f":"SUM($C$15:C136)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C136)-E136)-SUM($G$15:G135)","v":0},0,null,null,"02:00:00",0,null,{"$f":"SUM($L$15:L136)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M136-SUM($L$15:L136))-SUM($O$15:O135)","v":0},0]
[null,"03:00:00",null,0,{"$f":"SUM($C$15:C137)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C137)-E137)-SUM($G$15:G136)","v":0},0,null,null,"03:00:00",0,null,{"$f":"SUM($L$15:L137)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M137-SUM($L$15:L137))-SUM($O$15:O136)","v":0},0]
[null,"04:00:00",null,0,{"$f":"SUM($C$15:C138)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C138)-E138)-SUM($G$15:G137)","v":0},0,null,null,"04:00:00",0,null,{"$f":"SUM($L$15:L138)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M138-SUM($L$15:L138))-SUM($O$15:O137)","v":0},0]
[null,"05:00:00",null,0,{"$f":"SUM($C$15:C139)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C139)-E139)-SUM($G$15:G138)","v":0},0,null,null,"05:00:00",0,null,{"$f":"SUM($L$15:L139)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M139-SUM($L$15:L139))-SUM($O$15:O138)","v":0},0]
[null,"06:00:00",null,0,{"$f":"SUM($C$15:C140)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C140)-E140)-SUM($G$15:G139)","v":0},0,null,null,"06:00:00",0,null,{"$f":"SUM($L$15:L140)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M140-SUM($L$15:L140))-SUM($O$15:O139)","v":0},0]
[null,"07:00:00",null,0,{"$f":"SUM($C$15:C141)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C141)-E141)-SUM($G$15:G140)","v":0},0,null,null,"07:00:00",0,null,{"$f":"SUM($L$15:L141)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M141-SUM($L$15:L141))-SUM($O$15:O140)","v":0},0]
[null,"08:00:00",null,0,{"$f":"SUM($C$15:C142)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C142)-E142)-SUM($G$15:G141)","v":0},0,null,null,"08:00:00",0,null,{"$f":"SUM($L$15:L142)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M142-SUM($L$15:L142))-SUM($O$15:O141)","v":0},0]
[null,"09:00:00",null,{"$f":"C143-G143","v":0},{"$f":"SUM($C$15:C143)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C143)-E143)-SUM($G$15:G142)","v":0},0,null,null,"09:00:00",{"$f":"L143+O143","v":0},null,{"$f":"SUM($L$15:L143)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M143-SUM($L$15:L143))-SUM($O$15:O142)","v":0},0]
[null,"10:00:00",null,0,{"$f":"SUM($C$15:C144)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C144)-E144)-SUM($G$15:G143)","v":0},0,null,null,"10:00:00",0,null,{"$f":"SUM($L$15:L144)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M144-SUM($L$15:L144))-SUM($O$15:O143)","v":0},0]
[null,"11:00:00",null,0,{"$f":"SUM($C$15:C145)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C145)-E145)-SUM($G$15:G144)","v":0},0,null,null,"11:00:00",0,null,{"$f":"SUM($L$15:L145)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M145-SUM($L$15:L145))-SUM($O$15:O144)","v":0},0]
[null,"12:00:00",null,0,{"$f":"SUM($C$15:C146)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C146)-E146)-SUM($G$15:G145)","v":0},0,null,null,"12:00:00",0,null,{"$f":"SUM($L$15:L146)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M146-SUM($L$15:L146))-SUM($O$15:O145)","v":0},0]
[null,"13:00:00",null,0,{"$f":"SUM($C$15:C147)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C147)-E147)-SUM($G$15:G146)","v":0},0,null,null,"13:00:00",0,null,{"$f":"SUM($L$15:L147)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M147-SUM($L$15:L147))-SUM($O$15:O146)","v":0},0]
[null,"14:00:00",null,0,{"$f":"SUM($C$15:C148)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C148)-E148)-SUM($G$15:G147)","v":0},0,null,null,"14:00:00",0,null,{"$f":"SUM($L$15:L148)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M148-SUM($L$15:L148))-SUM($O$15:O147)","v":0},0]
[null,"15:00:00",null,0,{"$f":"SUM($C$15:C149)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C149)-E149)-SUM($G$15:G148)","v":0},0,null,null,"15:00:00",0,null,{"$f":"SUM($L$15:L149)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M149-SUM($L$15:L149))-SUM($O$15:O148)","v":0},0]
[null,"16:00:00",null,0,{"$f":"SUM($C$15:C150)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C150)-E150)-SUM($G$15:G149)","v":0},0,null,null,"16:00:00",0,null,{"$f":"SUM($L$15:L150)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M150-SUM($L$15:L150))-SUM($O$15:O149)","v":0},0]
[null,"17:00:00",null,0,{"$f":"SUM($C$15:C151)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C151)-E151)-SUM($G$15:G150)","v":0},0,null,null,"17:00:00",0,null,{"$f":"SUM($L$15:L151)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M151-SUM($L$15:L151))-SUM($O$15:O150)","v":0},0]
[null,"18:00:00",null,0,{"$f":"SUM($C$15:C152)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C152)-E152)-SUM($G$15:G151)","v":0},{"$f":"ROUND(F152,0)","v":0},null,null,"18:00:00",0,null,{"$f":"SUM($L$15:L152)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M152-SUM($L$15:L152))-SUM($O$15:O151)","v":0},{"$f":"ROUND(N152,0)","v":0}]
[null,"19:00:00",null,0,{"$f":"SUM($C$15:C153)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C153)-E153)-SUM($G$15:G152)","v":0},0,null,null,"19:00:00",0,null,{"$f":"SUM($L$15:L153)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M153-SUM($L$15:L153))-SUM($O$15:O152)","v":0},0]
[null,"20:00:00",null,0,{"$f":"SUM($C$15:C154)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C154)-E154)-SUM($G$15:G153)","v":0},0,null,null,"20:00:00",0,null,{"$f":"SUM($L$15:L154)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M154-SUM($L$15:L154))-SUM($O$15:O153)","v":0},0]
[null,"21:00:00",null,0,{"$f":"SUM($C$15:C155)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C155)-E155)-SUM($G$15:G154)","v":0},0,null,null,"21:00:00",0,null,{"$f":"SUM($L$15:L155)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M155-SUM($L$15:L155))-SUM($O$15:O154)","v":0},0]
[null,"22:00:00",null,0,{"$f":"SUM($C$15:C156)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C156)-E156)-SUM($G$15:G155)","v":0},0,null,null,"22:00:00",0,null,{"$f":"SUM($L$15:L156)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M156-SUM($L$15:L156))-SUM($O$15:O155)","v":0},0]
[null,"23:00:00",null,0,{"$f":"SUM($C$15:C157)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C157)-E157)-SUM($G$15:G156)","v":0},0,null,null,"23:00:00",0,null,{"$f":"SUM($L$15:L157)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M157-SUM($L$15:L157))-SUM($O$15:O156)","v":0},0]
[null,"24:00",null,0,{"$f":"SUM($C$15:C158)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C158)-E158)-SUM($G$15:G157)","v":0},0,null,null,"24:00",0,null,{"$f":"SUM($L$15:L158)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M158-SUM($L$15:L158))-SUM($O$15:O157)","v":0},0]
["Day 7","01:00:00",null,0,{"$f":"SUM($C$15:C159)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C159)-E159)-SUM($G$15:G158)","v":0},0,null,"Day 7","01:00:00",0,null,{"$f":"SUM($L$15:L159)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M159-SUM($L$15:L159))-SUM($O$15:O158)","v":0},0]
[null,"02:00:00",null,0,{"$f":"SUM($C$15:C160)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C160)-E160)-SUM($G$15:G159)","v":0},0,null,null,"02:00:00",0,null,{"$f":"SUM($L$15:L160)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M160-SUM($L$15:L160))-SUM($O$15:O159)","v":0},0]
[null,"03:00:00",null,0,{"$f":"SUM($C$15:C161)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C161)-E161)-SUM($G$15:G160)","v":0},0,null,null,"03:00:00",0,null,{"$f":"SUM($L$15:L161)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M161-SUM($L$15:L161))-SUM($O$15:O160)","v":0},0]
[null,"04:00:00",null,0,{"$f":"SUM($C$15:C162)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C162)-E162)-SUM($G$15:G161)","v":0},0,null,null,"04:00:00",0,null,{"$f":"SUM($L$15:L162)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M162-SUM($L$15:L162))-SUM($O$15:O161)","v":0},0]
[null,"05:00:00",null,0,{"$f":"SUM($C$15:C163)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C163)-E163)-SUM($G$15:G162)","v":0},0,null,null,"05:00:00",0,null,{"$f":"SUM($L$15:L163)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M163-SUM($L$15:L163))-SUM($O$15:O162)","v":0},0]
[null,"06:00:00",null,0,{"$f":"SUM($C$15:C164)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C164)-E164)-SUM($G$15:G163)","v":0},0,null,null,"06:00:00",0,null,{"$f":"SUM($L$15:L164)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M164-SUM($L$15:L164))-SUM($O$15:O163)","v":0},0]
[null,"07:00:00",null,0,{"$f":"SUM($C$15:C165)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C165)-E165)-SUM($G$15:G164)","v":0},0,null,null,"07:00:00",0,null,{"$f":"SUM($L$15:L165)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M165-SUM($L$15:L165))-SUM($O$15:O164)","v":0},0]
[null,"08:00:00",null,0,{"$f":"SUM($C$15:C166)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C166)-E166)-SUM($G$15:G165)","v":0},0,null,null,"08:00:00",0,null,{"$f":"SUM($L$15:L166)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M166-SUM($L$15:L166))-SUM($O$15:O165)","v":0},0]
[null,"09:00:00",null,0,{"$f":"SUM($C$15:C167)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C167)-E167)-SUM($G$15:G166)","v":0},0,null,null,"09:00:00",0,null,{"$f":"SUM($L$15:L167)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M167-SUM($L$15:L167))-SUM($O$15:O166)","v":0},0]
[null,"10:00:00",null,0,{"$f":"SUM($C$15:C168)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C168)-E168)-SUM($G$15:G167)","v":0},0,null,null,"10:00:00",0,null,{"$f":"SUM($L$15:L168)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M168-SUM($L$15:L168))-SUM($O$15:O167)","v":0},0]
[null,"11:00:00",null,0,{"$f":"SUM($C$15:C169)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C169)-E169)-SUM($G$15:G168)","v":0},0,null,null,"11:00:00",0,null,{"$f":"SUM($L$15:L169)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M169-SUM($L$15:L169))-SUM($O$15:O168)","v":0},0]
[null,"12:00:00",null,0,{"$f":"SUM($C$15:C170)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C170)-E170)-SUM($G$15:G169)","v":0},0,null,null,"12:00:00",0,null,{"$f":"SUM($L$15:L170)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M170-SUM($L$15:L170))-SUM($O$15:O169)","v":0},0]
[null,"13:00:00",null,0,{"$f":"SUM($C$15:C171)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C171)-E171)-SUM($G$15:G170)","v":0},0,null,null,"13:00:00",0,null,{"$f":"SUM($L$15:L171)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M171-SUM($L$15:L171))-SUM($O$15:O170)","v":0},0]
[null,"14:00:00",null,0,{"$f":"SUM($C$15:C172)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C172)-E172)-SUM($G$15:G171)","v":0},0,null,null,"14:00:00",0,null,{"$f":"SUM($L$15:L172)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M172-SUM($L$15:L172))-SUM($O$15:O171)","v":0},0]
[null,"15:00:00",null,0,{"$f":"SUM($C$15:C173)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C173)-E173)-SUM($G$15:G172)","v":0},0,null,null,"15:00:00",0,null,{"$f":"SUM($L$15:L173)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M173-SUM($L$15:L173))-SUM($O$15:O172)","v":0},0]
[null,"16:00:00",null,0,{"$f":"SUM($C$15:C174)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C174)-E174)-SUM($G$15:G173)","v":0},0,null,null,"16:00:00",0,null,{"$f":"SUM($L$15:L174)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M174-SUM($L$15:L174))-SUM($O$15:O173)","v":0},0]
[null,"17:00:00",null,0,{"$f":"SUM($C$15:C175)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C175)-E175)-SUM($G$15:G174)","v":0},0,null,null,"17:00:00",0,null,{"$f":"SUM($L$15:L175)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M175-SUM($L$15:L175))-SUM($O$15:O174)","v":0},0]
[null,"18:00:00",null,0,{"$f":"SUM($C$15:C176)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C176)-E176)-SUM($G$15:G175)","v":0},0,null,null,"18:00:00",0,null,{"$f":"SUM($L$15:L176)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M176-SUM($L$15:L176))-SUM($O$15:O175)","v":0},0]
[null,"19:00:00",null,0,{"$f":"SUM($C$15:C177)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C177)-E177)-SUM($G$15:G176)","v":0},0,null,null,"19:00:00",0,null,{"$f":"SUM($L$15:L177)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M177-SUM($L$15:L177))-SUM($O$15:O176)","v":0},0]
[null,"20:00:00",null,0,{"$f":"SUM($C$15:C178)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C178)-E178)-SUM($G$15:G177)","v":0},0,null,null,"20:00:00",0,null,{"$f":"SUM($L$15:L178)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M178-SUM($L$15:L178))-SUM($O$15:O177)","v":0},0]
[null,"21:00:00",null,0,{"$f":"SUM($C$15:C179)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C179)-E179)-SUM($G$15:G178)","v":0},0,null,null,"21:00:00",0,null,{"$f":"SUM($L$15:L179)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M179-SUM($L$15:L179))-SUM($O$15:O178)","v":0},0]
[null,"22:00:00",null,0,{"$f":"SUM($C$15:C180)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C180)-E180)-SUM($G$15:G179)","v":0},0,null,null,"22:00:00",0,null,{"$f":"SUM($L$15:L180)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M180-SUM($L$15:L180))-SUM($O$15:O179)","v":0},0]
[null,"23:00:00",null,0,{"$f":"SUM($C$15:C181)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C181)-E181)-SUM($G$15:G180)","v":0},0,null,null,"23:00:00",0,null,{"$f":"SUM($L$15:L181)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M181-SUM($L$15:L181))-SUM($O$15:O180)","v":0},0]
[null,"24:00",null,0,{"$f":"SUM($C$15:C182)*(1-LOSS_PERCENTAGE)","v":0},{"$f":"(SUM($C$15:C182)-E182)-SUM($G$15:G181)","v":0},0,null,null,"24:00",0,null,{"$f":"SUM($L$15:L182)/(1-LOSS_PERCENTAGE)","v":0},{"$f":"(M182-SUM($L$15:L182))-SUM($O$15:O181)","v":0},0]
["Total",null,{"$f":"SUM(C15:C182)","v":0},{"$f":"SUM(D15:D182)","v":0},{"$f":"E182","v":0},{"$f":"SUM(F15:F182)","v":0},{"$f":"SUM(G15:G182)","v":0},null,"Total",null,{"$f":"SUM(K15:K182)","v":0},{"$f":"SUM(L15:L182)","v":0},{"$f":"M182","v":0},{"$f":"SUM(N15:N182)","v":0},{"$f":"SUM(O15:O182)","v":0}]

{"sheet":"Config","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Loss Percentage",1.38E-2]
["Effective Date","05/01/2016"]