{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Enter MW at POD","Enter MW at POR","PORCalcs","PODCalcs"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"Enter MW at POD","index":0,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Enter MWs at the POD"]
[null,"This calculator will back calculate and show the MWs at the POR, when the MWs at POD are entered."]
[null,"If the user needs to Enter MW at POR values, please select the appropriate worksheet tab below or click:",null,null,null,null,null,null,"Enter MW at POR"]
[]
[]
[]
[]
[null,"Loss Percentage:",null,null,0.03,null,null,"TO USE THIS CALCULATOR CORRECTLY:"]
[null,"Start","Stop","MW at POR","LOSS","MW at POD",null,"1) Enter MW at POD values from the tag you are checking into the MW at POD column of this calculator."]
[null,"00:00:00","01:00:00",{"$f":"SUM(E10:F10)","v":0},{"$f":"IF(PORCalcs!D2<0,0,ROUNDUP(PORCalcs!D2,0))","v":0},null,null,"2) The MW at POR will then populate with the staggered losses required to deliver the MWs at POD."]
[null,"01:00:00","02:00:00",{"$f":"SUM(E11:F11)","v":0},{"$f":"IF(PORCalcs!D3<0,0,ROUNDUP(PORCalcs!D3,0))","v":0},null,null,"3) If the same amount of MW is wanted every hour, click \"FULL-DAY\" and it will auto-fill the sheet."]
[null,"02:00:00","03:00:00",{"$f":"SUM(E12:F12)","v":0},{"$f":"IF(PORCalcs!D4<0,0,ROUNDUP(PORCalcs!D4,0))","v":0},null,null,"4) Each Tag Request (Creation, Adjustment,etc.) is evaluated independent of each other.  Surplus (partial) MW can not be carried over to the next Request on that Tag."]
[null,"03:00:00","04:00:00",0,{"$f":"IF(PORCalcs!D5<0,0,ROUNDUP(PORCalcs!D5,0))","v":0}]
[null,"04:00:00","05:00:00",0,{"$f":"IF(PORCalcs!D6<0,0,ROUNDUP(PORCalcs!D6,0))","v":0}]
[null,"05:00:00","06:00:00",0,{"$f":"IF(PORCalcs!D7<0,0,ROUNDUP(PORCalcs!D7,0))","v":0}]
[null,"06:00:00","07:00:00",0,{"$f":"IF(PORCalcs!D8<0,0,ROUNDUP(PORCalcs!D8,0))","v":0}]
[null,"07:00:00","08:00:00",0,{"$f":"IF(PORCalcs!D9<0,0,ROUNDUP(PORCalcs!D9,0))","v":0}]
[null,"08:00:00","09:00:00",0,{"$f":"IF(PORCalcs!D10<0,0,ROUNDUP(PORCalcs!D10,0))","v":0}]
[null,"09:00:00","10:00:00",0,{"$f":"IF(PORCalcs!D11<0,0,ROUNDUP(PORCalcs!D11,0))","v":0}]
[null,"10:00:00","11:00:00",0,{"$f":"IF(PORCalcs!D12<0,0,ROUNDUP(PORCalcs!D12,0))","v":0}]
[null,"11:00:00","12:00:00",0,{"$f":"IF(PORCalcs!D13<0,0,ROUNDUP(PORCalcs!D13,0))","v":0}]
[null,"12:00:00","13:00:00",0,{"$f":"IF(PORCalcs!D14<0,0,ROUNDUP(PORCalcs!D14,0))","v":0}]
[null,"13:00:00","14:00:00",0,{"$f":"IF(PORCalcs!D15<0,0,ROUNDUP(PORCalcs!D15,0))","v":0}]
[null,"14:00:00","15:00:00",0,{"$f":"IF(PORCalcs!D16<0,0,ROUNDUP(PORCalcs!D16,0))","v":0}]
[null,"15:00:00","16:00:00",0,{"$f":"IF(PORCalcs!D17<0,0,ROUNDUP(PORCalcs!D17,0))","v":0}]
[null,"16:00:00","17:00:00",0,{"$f":"IF(PORCalcs!D18<0,0,ROUNDUP(PORCalcs!D18,0))","v":0}]
[null,"17:00:00","18:00:00",0,{"$f":"IF(PORCalcs!D19<0,0,ROUNDUP(PORCalcs!D19,0))","v":0}]
[null,"18:00:00","19:00:00",0,{"$f":"IF(PORCalcs!D20<0,0,ROUNDUP(PORCalcs!D20,0))","v":0}]
[null,"19:00:00","20:00:00",0,{"$f":"IF(PORCalcs!D21<0,0,ROUNDUP(PORCalcs!D21,0))","v":0}]
[null,"20:00:00","21:00:00",0,{"$f":"IF(PORCalcs!D22<0,0,ROUNDUP(PORCalcs!D22,0))","v":0}]
[null,"21:00:00","22:00:00",0,{"$f":"IF(PORCalcs!D23<0,0,ROUNDUP(PORCalcs!D23,0))","v":0}]
[null,"22:00:00","23:00:00",0,{"$f":"IF(PORCalcs!D24<0,0,ROUNDUP(PORCalcs!D24,0))","v":0}]
[null,"23:00:00","00:00:00",0,{"$f":"IF(PORCalcs!D25<0,0,ROUNDUP(PORCalcs!D25,0))","v":0}]
[null,null,"TOTAL",{"$f":"SUM(D10:D33)","v":0},{"$f":"SUM(E10:E33)","v":0},{"$f":"SUM(F10:F33)","v":0}]

{"sheet":"Enter MW at POR","index":1,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Enter MWs at the POR"]
[null,"This calculator will calculate the MWs at the POD, when the MWs at POR are entered."]
[null,"If the user needs to Enter MW at POD values, please select the appropriate worksheet tab below or click:",null,null,null,null,null,null,"Enter MW at POD"]
[]
[]
[]
[]
[null,"Loss Percentage",null,null,0.03,null,null,"TO USE THIS CALCULATOR CORRECTLY:"]
[null,"Start","Stop","MW at POR","LOSS","MW at POD",null,"1) Enter MW at POR values from the tag you are checking into the MW at POR column of this calculator."]
[null,"00:00:00","01:00:00",null,{"$f":"IF(PODCalcs!D2<0,0,ROUNDUP(PODCalcs!D2,0))","v":0},{"$f":"D10-E10","v":0},null,"2) The MW at POR will then populate with the staggered losses required to deliver the MWs at POD."]
[null,"01:00:00","02:00:00",null,{"$f":"IF(PODCalcs!D3<0,0,ROUNDUP(PODCalcs!D3,0))","v":0},{"$f":"D11-E11","v":0},null,"3) If the same amount of MW is wanted every hour, click \"FULL-DAY\" and it will auto-fill the sheet."]
[null,"02:00:00","03:00:00",null,{"$f":"IF(PODCalcs!D4<0,0,ROUNDUP(PODCalcs!D4,0))","v":0},0,null,"4) Each Tag Request (Creation, Adjustment,etc.) is evaluated independent of each other.  Surplus (partial) MW can not be carried over to the next Request on that Tag."]
[null,"03:00:00","04:00:00",null,{"$f":"IF(PODCalcs!D5<0,0,ROUNDUP(PODCalcs!D5,0))","v":0},0]
[null,"04:00:00","05:00:00",null,{"$f":"IF(PODCalcs!D6<0,0,ROUNDUP(PODCalcs!D6,0))","v":0},0]
[null,"05:00:00","06:00:00",null,{"$f":"IF(PODCalcs!D7<0,0,ROUNDUP(PODCalcs!D7,0))","v":0},0]
[null,"06:00:00","07:00:00",null,{"$f":"IF(PODCalcs!D8<0,0,ROUNDUP(PODCalcs!D8,0))","v":0},0]
[null,"07:00:00","08:00:00",null,{"$f":"IF(PODCalcs!D9<0,0,ROUNDUP(PODCalcs!D9,0))","v":0},0]
[null,"08:00:00","09:00:00",null,{"$f":"IF(PODCalcs!D10<0,0,ROUNDUP(PODCalcs!D10,0))","v":0},0]
[null,"09:00:00","10:00:00",null,{"$f":"IF(PODCalcs!D11<0,0,ROUNDUP(PODCalcs!D11,0))","v":0},0]
[null,"10:00:00","11:00:00",null,{"$f":"IF(PODCalcs!D12<0,0,ROUNDUP(PODCalcs!D12,0))","v":0},0]
[null,"11:00:00","12:00:00",null,{"$f":"IF(PODCalcs!D13<0,0,ROUNDUP(PODCalcs!D13,0))","v":0},0]
[null,"12:00:00","13:00:00",null,{"$f":"IF(PODCalcs!D14<0,0,ROUNDUP(PODCalcs!D14,0))","v":0},0]
[null,"13:00:00","14:00:00",null,{"$f":"IF(PODCalcs!D15<0,0,ROUNDUP(PODCalcs!D15,0))","v":0},0]
[null,"14:00:00","15:00:00",null,{"$f":"IF(PODCalcs!D16<0,0,ROUNDUP(PODCalcs!D16,0))","v":0},0]
[null,"15:00:00","16:00:00",null,{"$f":"IF(PODCalcs!D17<0,0,ROUNDUP(PODCalcs!D17,0))","v":0},0]
[null,"16:00:00","17:00:00",null,{"$f":"IF(PODCalcs!D18<0,0,ROUNDUP(PODCalcs!D18,0))","v":0},0]
[null,"17:00:00","18:00:00",null,{"$f":"IF(PODCalcs!D19<0,0,ROUNDUP(PODCalcs!D19,0))","v":0},0]
[null,"18:00:00","19:00:00",null,{"$f":"IF(PODCalcs!D20<0,0,ROUNDUP(PODCalcs!D20,0))","v":0},0]
[null,"19:00:00","20:00:00",null,{"$f":"IF(PODCalcs!D21<0,0,ROUNDUP(PODCalcs!D21,0))","v":0},0]
[null,"20:00:00","21:00:00",null,{"$f":"IF(PODCalcs!D22<0,0,ROUNDUP(PODCalcs!D22,0))","v":0},0]
[null,"21:00:00","22:00:00",null,{"$f":"IF(PODCalcs!D23<0,0,ROUNDUP(PODCalcs!D23,0))","v":0},0]
[null,"22:00:00","23:00:00",null,{"$f":"IF(PODCalcs!D24<0,0,ROUNDUP(PODCalcs!D24,0))","v":0},0]
[null,"23:00:00","00:00:00",null,{"$f":"IF(PODCalcs!D25<0,0,ROUNDUP(PODCalcs!D25,0))","v":0},0]
[null,null,"TOTAL",{"$f":"SUM(D10:D33)","v":0},{"$f":"SUM(E10:E33)","v":0},{"$f":"SUM(F10:F33)","v":0}]

{"sheet":"PORCalcs","index":2,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["MW * Loss Percentage","“True” Loss Provision","Prior Carry Forward","“True” + Prior Carry Forward","Carry Forward"]
[{"$f":"'Enter MW at POD'!F10*'Enter MW at POD'!$E$8","v":0},{"$f":"ROUND(A2,4)","v":0},0,{"$f":"C2+B2","v":0},{"$f":"D2-'Enter MW at POD'!E10","v":0}]
[{"$f":"'Enter MW at POD'!F11*'Enter MW at POD'!$E$8","v":0},{"$f":"ROUND(A3,4)","v":0},{"$f":"E2","v":0},0,{"$f":"D3-'Enter MW at POD'!E11","v":0}]
[{"$f":"'Enter MW at POD'!F12*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D4-'Enter MW at POD'!E12","v":0}]
[{"$f":"'Enter MW at POD'!F13*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D5-'Enter MW at POD'!E13","v":0}]
[{"$f":"'Enter MW at POD'!F14*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D6-'Enter MW at POD'!E14","v":0}]
[{"$f":"'Enter MW at POD'!F15*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D7-'Enter MW at POD'!E15","v":0}]
[{"$f":"'Enter MW at POD'!F16*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D8-'Enter MW at POD'!E16","v":0}]
[{"$f":"'Enter MW at POD'!F17*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D9-'Enter MW at POD'!E17","v":0}]
[{"$f":"'Enter MW at POD'!F18*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D10-'Enter MW at POD'!E18","v":0}]
[{"$f":"'Enter MW at POD'!F19*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D11-'Enter MW at POD'!E19","v":0}]
[{"$f":"'Enter MW at POD'!F20*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D12-'Enter MW at POD'!E20","v":0}]
[{"$f":"'Enter MW at POD'!F21*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D13-'Enter MW at POD'!E21","v":0}]
[{"$f":"'Enter MW at POD'!F22*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D14-'Enter MW at POD'!E22","v":0}]
[{"$f":"'Enter MW at POD'!F23*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D15-'Enter MW at POD'!E23","v":0}]
[{"$f":"'Enter MW at POD'!F24*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D16-'Enter MW at POD'!E24","v":0}]
[{"$f":"'Enter MW at POD'!F25*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D17-'Enter MW at POD'!E25","v":0}]
[{"$f":"'Enter MW at POD'!F26*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D18-'Enter MW at POD'!E26","v":0}]
[{"$f":"'Enter MW at POD'!F27*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D19-'Enter MW at POD'!E27","v":0}]
[{"$f":"'Enter MW at POD'!F28*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D20-'Enter MW at POD'!E28","v":0}]
[{"$f":"'Enter MW at POD'!F29*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D21-'Enter MW at POD'!E29","v":0}]
[{"$f":"'Enter MW at POD'!F30*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D22-'Enter MW at POD'!E30","v":0}]
[{"$f":"'Enter MW at POD'!F31*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D23-'Enter MW at POD'!E31","v":0}]
[{"$f":"'Enter MW at POD'!F32*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D24-'Enter MW at POD'!E32","v":0}]
[{"$f":"'Enter MW at POD'!F33*'Enter MW at POD'!$E$8","v":0},0,0,0,{"$f":"D25-'Enter MW at POD'!E33","v":0}]
[]
[{"$f":"'Enter MW at POD'!F34*'Enter MW at POD'!$E$8","v":0}]
[]
["Note: ","Changed the rounding to 4 decimal "]

{"sheet":"PODCalcs","index":3,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["MW * Loss Percentage","“True” Loss Provision","Prior Carry Forward","“True” + Prior Carry Forward","Carry Forward"]
[{"$f":"'Enter MW at POR'!D10-'Enter MW at POR'!D10/(1+'Enter MW at POR'!$E$8)","v":0},{"$f":"ROUND(A2,4)","v":0},0,{"$f":"C2+B2","v":0},{"$f":"D2-'Enter MW at POR'!E10","v":0}]
[{"$f":"'Enter MW at POR'!D11-'Enter MW at POR'!D11/(1+'Enter MW at POR'!$E$8)","v":0},{"$f":"ROUND(A3,4)","v":0},{"$f":"E2","v":0},0,{"$f":"D3-'Enter MW at POR'!E11","v":0}]
[{"$f":"'Enter MW at POR'!D12-'Enter MW at POR'!D12/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D4-'Enter MW at POR'!E12","v":0}]
[{"$f":"'Enter MW at POR'!D13-'Enter MW at POR'!D13/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D5-'Enter MW at POR'!E13","v":0}]
[{"$f":"'Enter MW at POR'!D14-'Enter MW at POR'!D14/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D6-'Enter MW at POR'!E14","v":0}]
[{"$f":"'Enter MW at POR'!D15-'Enter MW at POR'!D15/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D7-'Enter MW at POR'!E15","v":0}]
[{"$f":"'Enter MW at POR'!D16-'Enter MW at POR'!D16/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D8-'Enter MW at POR'!E16","v":0}]
[{"$f":"'Enter MW at POR'!D17-'Enter MW at POR'!D17/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D9-'Enter MW at POR'!E17","v":0}]
[{"$f":"'Enter MW at POR'!D18-'Enter MW at POR'!D18/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D10-'Enter MW at POR'!E18","v":0}]
[{"$f":"'Enter MW at POR'!D19-'Enter MW at POR'!D19/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D11-'Enter MW at POR'!E19","v":0}]
[{"$f":"'Enter MW at POR'!D20-'Enter MW at POR'!D20/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D12-'Enter MW at POR'!E20","v":0}]
[{"$f":"'Enter MW at POR'!D21-'Enter MW at POR'!D21/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D13-'Enter MW at POR'!E21","v":0}]
[{"$f":"'Enter MW at POR'!D22-'Enter MW at POR'!D22/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D14-'Enter MW at POR'!E22","v":0}]
[{"$f":"'Enter MW at POR'!D23-'Enter MW at POR'!D23/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D15-'Enter MW at POR'!E23","v":0}]
[{"$f":"'Enter MW at POR'!D24-'Enter MW at POR'!D24/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D16-'Enter MW at POR'!E24","v":0}]
[{"$f":"'Enter MW at POR'!D25-'Enter MW at POR'!D25/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D17-'Enter MW at POR'!E25","v":0}]
[{"$f":"'Enter MW at POR'!D26-'Enter MW at POR'!D26/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D18-'Enter MW at POR'!E26","v":0}]
[{"$f":"'Enter MW at POR'!D27-'Enter MW at POR'!D27/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D19-'Enter MW at POR'!E27","v":0}]
[{"$f":"'Enter MW at POR'!D28-'Enter MW at POR'!D28/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D20-'Enter MW at POR'!E28","v":0}]
[{"$f":"'Enter MW at POR'!D29-'Enter MW at POR'!D29/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D21-'Enter MW at POR'!E29","v":0}]
[{"$f":"'Enter MW at POR'!D30-'Enter MW at POR'!D30/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D22-'Enter MW at POR'!E30","v":0}]
[{"$f":"'Enter MW at POR'!D31-'Enter MW at POR'!D31/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D23-'Enter MW at POR'!E31","v":0}]
[{"$f":"'Enter MW at POR'!D32-'Enter MW at POR'!D32/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D24-'Enter MW at POR'!E32","v":0}]
[{"$f":"'Enter MW at POR'!D33-'Enter MW at POR'!D33/(1+'Enter MW at POR'!$E$8)","v":0},0,0,0,{"$f":"D25-'Enter MW at POR'!E33","v":0}]
[]
[{"$f":"'Enter MW at POR'!D34*'Enter MW at POR'!$E$8","v":0}]
[]
[]
[]
["*** Note - changed formula for column 1 "]
["before:","mw@por * loss percentage"]
["after:","mw@por - (mw@por / (1 + loss percentage))"]
[]
["*** Note - changed rounding to 4 decimal points"]