{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["Lists","CWE Market view","CWE Market graphs","CWE map","BorderDataOverview","Virgin domain initial comp.","PTDFs_Early Publication","LTN","PTDFs","Virgin domain final computation","ATCs","Max net pos","Max exchanges (Maxbex)","Shadow Auction ATC","Net Position","Allocated Capacities","Price Spread","Intraday ATC","Congestion Income","D2CF","Refprog","Final Flowbased domain","Intraday Implicit Allocation"],"not_rendered":{"charts":12,"images":1,"macros":1,"external_links":0,"defined_names":75,"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":"Lists","index":0,"n_rows":370,"n_cols":9,"rows_kept":370,"cut":false,"hidden":true,"merged":[]}
["Dates:",null,"Hours:",null,"Borders:",null,"Version:",null,"Refprog borders:"]
[{"$f":"A3+1","v":"2020-02-26"},null,1,null,"AT-DE",null,"4.1",null,"APG-CZ"]
[{"$f":"IF(G3=\"PR\",DATE(2015,5,19),TODAY())","v":"2020-02-25"},null,2,null,"AT-IT",null,"",null,"APG-HU"]
[{"$f":"IF(OR(A3-1>DATE(2015,5,19),$G$3=\"PR\"),A3-1,\"\")","v":"2020-02-24"},null,3,null,"AT-SI",null,"https://tennetnl-parallelrun-utilitytool.jao.eu/",null,"APG-SHB"]
[{"$f":"IF(A4=\"\",\"\",IF(OR(A4-1>DATE(2015,5,19),$G$3=\"PR\"),A4-1,\"\"))","v":"2020-02-23"},null,4,null,"BE-FR",null,null,null,"BE-NL"]
[{"$f":"IF(A5=\"\",\"\",IF(OR(A5-1>DATE(2015,5,19),$G$3=\"PR\"),A5-1,\"\"))","v":"2020-02-22"},null,5,null,"BE-NL",null,null,null,"BG-TR"]
[{"$f":"IF(A6=\"\",\"\",IF(OR(A6-1>DATE(2015,5,19),$G$3=\"PR\"),A6-1,\"\"))","v":"2020-02-21"},null,6,null,"DE-AT",null,null,null,"CH-APG"]
[{"$f":"IF(A7=\"\",\"\",IF(OR(A7-1>DATE(2015,5,19),$G$3=\"PR\"),A7-1,\"\"))","v":"2020-02-20"},null,7,null,"DE-DK1",null,null,null,"CH-DE+"]
[{"$f":"IF(A8=\"\",\"\",IF(OR(A8-1>DATE(2015,5,19),$G$3=\"PR\"),A8-1,\"\"))","v":"2020-02-19"},null,8,null,"DE-FR",null,null,null,"CH-FR"]
[{"$f":"IF(A9=\"\",\"\",IF(OR(A9-1>DATE(2015,5,19),$G$3=\"PR\"),A9-1,\"\"))","v":"2020-02-18"},null,9,null,"DE-NL",null,null,null,"CH-IT"]
[{"$f":"IF(A10=\"\",\"\",IF(OR(A10-1>DATE(2015,5,19),$G$3=\"PR\"),A10-1,\"\"))","v":"2020-02-17"},null,10,null,"DK1-DE",null,null,null,"CZ-SK"]
[{"$f":"IF(A11=\"\",\"\",IF(OR(A11-1>DATE(2015,5,19),$G$3=\"PR\"),A11-1,\"\"))","v":"2020-02-16"},null,11,null,"ES-FR",null,null,null,"DE+-APG"]
[{"$f":"IF(A12=\"\",\"\",IF(OR(A12-1>DATE(2015,5,19),$G$3=\"PR\"),A12-1,\"\"))","v":"2020-02-15"},null,12,null,"FR-BE",null,null,null,"DE-CZ"]
[{"$f":"IF(A13=\"\",\"\",IF(OR(A13-1>DATE(2015,5,19),$G$3=\"PR\"),A13-1,\"\"))","v":"2020-02-14"},null,13,null,"FR-DE",null,null,null,"DE-NL"]
[{"$f":"IF(A14=\"\",\"\",IF(OR(A14-1>DATE(2015,5,19),$G$3=\"PR\"),A14-1,\"\"))","v":"2020-02-13"},null,14,null,"FR-ES",null,null,null,"DE-PL"]
[{"$f":"IF(A15=\"\",\"\",IF(OR(A15-1>DATE(2015,5,19),$G$3=\"PR\"),A15-1,\"\"))","v":"2020-02-12"},null,15,null,"FR-IT",null,null,null,"ES-MA"]
[{"$f":"IF(A16=\"\",\"\",IF(OR(A16-1>DATE(2015,5,19),$G$3=\"PR\"),A16-1,\"\"))","v":"2020-02-11"},null,16,null,"HR-SI",null,null,null,"ES-PT"]
[{"$f":"IF(A17=\"\",\"\",IF(OR(A17-1>DATE(2015,5,19),$G$3=\"PR\"),A17-1,\"\"))","v":"2020-02-10"},null,17,null,"IT-AT",null,null,null,"FR-BE"]
[{"$f":"IF(A18=\"\",\"\",IF(OR(A18-1>DATE(2015,5,19),$G$3=\"PR\"),A18-1,\"\"))","v":"2020-02-09"},null,18,null,"IT-FR",null,null,null,"FR-DE"]
[{"$f":"IF(A19=\"\",\"\",IF(OR(A19-1>DATE(2015,5,19),$G$3=\"PR\"),A19-1,\"\"))","v":"2020-02-08"},null,19,null,"IT-SI",null,null,null,"FR-ES"]
[{"$f":"IF(A20=\"\",\"\",IF(OR(A20-1>DATE(2015,5,19),$G$3=\"PR\"),A20-1,\"\"))","v":"2020-02-07"},null,20,null,"NL-BE",null,null,null,"FR-IT"]
[{"$f":"IF(A21=\"\",\"\",IF(OR(A21-1>DATE(2015,5,19),$G$3=\"PR\"),A21-1,\"\"))","v":"2020-02-06"},null,21,null,"NL-DE",null,null,null,"GR-AL"]
[{"$f":"IF(A22=\"\",\"\",IF(OR(A22-1>DATE(2015,5,19),$G$3=\"PR\"),A22-1,\"\"))","v":"2020-02-05"},null,22,null,"SI-AT",null,null,null,"GR-BG"]
[{"$f":"IF(A23=\"\",\"\",IF(OR(A23-1>DATE(2015,5,19),$G$3=\"PR\"),A23-1,\"\"))","v":"2020-02-04"},null,23,null,"SI-HR",null,null,null,"GR-IT"]
[{"$f":"IF(A24=\"\",\"\",IF(OR(A24-1>DATE(2015,5,19),$G$3=\"PR\"),A24-1,\"\"))","v":"2020-02-03"},null,24,null,"SI-IT",null,null,null,"GR-SMM"]
[{"$f":"IF(A25=\"\",\"\",IF(OR(A25-1>DATE(2015,5,19),$G$3=\"PR\"),A25-1,\"\"))","v":"2020-02-02"},null,25,null,null,null,null,null,"GR-TR"]
[{"$f":"IF(A26=\"\",\"\",IF(OR(A26-1>DATE(2015,5,19),$G$3=\"PR\"),A26-1,\"\"))","v":"2020-02-01"},null,null,null,null,null,null,null,"IT-APG"]
[{"$f":"IF(A27=\"\",\"\",IF(OR(A27-1>DATE(2015,5,19),$G$3=\"PR\"),A27-1,\"\"))","v":"2020-01-31"},null,null,null,null,null,null,null,"IT-SHB"]
[{"$f":"IF(A28=\"\",\"\",IF(OR(A28-1>DATE(2015,5,19),$G$3=\"PR\"),A28-1,\"\"))","v":"2020-01-30"},null,null,null,null,null,null,null,"PL-CZ"]
[{"$f":"IF(A29=\"\",\"\",IF(OR(A29-1>DATE(2015,5,19),$G$3=\"PR\"),A29-1,\"\"))","v":"2020-01-29"},null,null,null,null,null,null,null,"PL-SK"]
[{"$f":"IF(A30=\"\",\"\",IF(OR(A30-1>DATE(2015,5,19),$G$3=\"PR\"),A30-1,\"\"))","v":"2020-01-28"},null,null,null,null,null,null,null,"RO-BG"]
[{"$f":"IF(A31=\"\",\"\",IF(OR(A31-1>DATE(2015,5,19),$G$3=\"PR\"),A31-1,\"\"))","v":"2020-01-27"},null,null,null,null,null,null,null,"RO-HU"]
[{"$f":"IF(A32=\"\",\"\",IF(OR(A32-1>DATE(2015,5,19),$G$3=\"PR\"),A32-1,\"\"))","v":"2020-01-26"},null,null,null,null,null,null,null,"SHB-HU"]
[{"$f":"IF(A33=\"\",\"\",IF(OR(A33-1>DATE(2015,5,19),$G$3=\"PR\"),A33-1,\"\"))","v":"2020-01-25"},null,null,null,null,null,null,null,"SK-HU"]
[{"$f":"IF(A34=\"\",\"\",IF(OR(A34-1>DATE(2015,5,19),$G$3=\"PR\"),A34-1,\"\"))","v":"2020-01-24"},null,null,null,null,null,null,null,"SMM-AL"]
[{"$f":"IF(A35=\"\",\"\",IF(OR(A35-1>DATE(2015,5,19),$G$3=\"PR\"),A35-1,\"\"))","v":"2020-01-23"},null,null,null,null,null,null,null,"SMM-BG"]
[{"$f":"IF(A36=\"\",\"\",IF(OR(A36-1>DATE(2015,5,19),$G$3=\"PR\"),A36-1,\"\"))","v":"2020-01-22"},null,null,null,null,null,null,null,"SMM-HU"]
[{"$f":"IF(A37=\"\",\"\",IF(OR(A37-1>DATE(2015,5,19),$G$3=\"PR\"),A37-1,\"\"))","v":"2020-01-21"},null,null,null,null,null,null,null,"SMM-RO"]
[{"$f":"IF(A38=\"\",\"\",IF(OR(A38-1>DATE(2015,5,19),$G$3=\"PR\"),A38-1,\"\"))","v":"2020-01-20"},null,null,null,null,null,null,null,"SMM-SHB"]
[{"$f":"IF(A39=\"\",\"\",IF(OR(A39-1>DATE(2015,5,19),$G$3=\"PR\"),A39-1,\"\"))","v":"2020-01-19"},null,null,null,null,null,null,null,"WPS-HU"]
[{"$f":"IF(A40=\"\",\"\",IF(OR(A40-1>DATE(2015,5,19),$G$3=\"PR\"),A40-1,\"\"))","v":"2020-01-18"},null,null,null,null,null,null,null,"WPS-RO"]
[{"$f":"IF(A41=\"\",\"\",IF(OR(A41-1>DATE(2015,5,19),$G$3=\"PR\"),A41-1,\"\"))","v":"2020-01-17"},null,null,null,null,null,null,null,"WPS-SK"]
[{"$f":"IF(A42=\"\",\"\",IF(OR(A42-1>DATE(2015,5,19),$G$3=\"PR\"),A42-1,\"\"))","v":"2020-01-16"}]
[{"$f":"IF(A43=\"\",\"\",IF(OR(A43-1>DATE(2015,5,19),$G$3=\"PR\"),A43-1,\"\"))","v":"2020-01-15"}]
[{"$f":"IF(A44=\"\",\"\",IF(OR(A44-1>DATE(2015,5,19),$G$3=\"PR\"),A44-1,\"\"))","v":"2020-01-14"}]
[{"$f":"IF(A45=\"\",\"\",IF(OR(A45-1>DATE(2015,5,19),$G$3=\"PR\"),A45-1,\"\"))","v":"2020-01-13"}]
[{"$f":"IF(A46=\"\",\"\",IF(OR(A46-1>DATE(2015,5,19),$G$3=\"PR\"),A46-1,\"\"))","v":"2020-01-12"}]
[{"$f":"IF(A47=\"\",\"\",IF(OR(A47-1>DATE(2015,5,19),$G$3=\"PR\"),A47-1,\"\"))","v":"2020-01-11"}]
[{"$f":"IF(A48=\"\",\"\",IF(OR(A48-1>DATE(2015,5,19),$G$3=\"PR\"),A48-1,\"\"))","v":"2020-01-10"}]
[{"$f":"IF(A49=\"\",\"\",IF(OR(A49-1>DATE(2015,5,19),$G$3=\"PR\"),A49-1,\"\"))","v":"2020-01-09"}]
[{"$f":"IF(A50=\"\",\"\",IF(OR(A50-1>DATE(2015,5,19),$G$3=\"PR\"),A50-1,\"\"))","v":"2020-01-08"}]
[{"$f":"IF(A51=\"\",\"\",IF(OR(A51-1>DATE(2015,5,19),$G$3=\"PR\"),A51-1,\"\"))","v":"2020-01-07"}]
[{"$f":"IF(A52=\"\",\"\",IF(OR(A52-1>DATE(2015,5,19),$G$3=\"PR\"),A52-1,\"\"))","v":"2020-01-06"}]
[{"$f":"IF(A53=\"\",\"\",IF(OR(A53-1>DATE(2015,5,19),$G$3=\"PR\"),A53-1,\"\"))","v":"2020-01-05"}]
[{"$f":"IF(A54=\"\",\"\",IF(OR(A54-1>DATE(2015,5,19),$G$3=\"PR\"),A54-1,\"\"))","v":"2020-01-04"}]
[{"$f":"IF(A55=\"\",\"\",IF(OR(A55-1>DATE(2015,5,19),$G$3=\"PR\"),A55-1,\"\"))","v":"2020-01-03"}]
[{"$f":"IF(A56=\"\",\"\",IF(OR(A56-1>DATE(2015,5,19),$G$3=\"PR\"),A56-1,\"\"))","v":"2020-01-02"}]
[{"$f":"IF(A57=\"\",\"\",IF(OR(A57-1>DATE(2015,5,19),$G$3=\"PR\"),A57-1,\"\"))","v":"2020-01-01"}]
[{"$f":"IF(A58=\"\",\"\",IF(OR(A58-1>DATE(2015,5,19),$G$3=\"PR\"),A58-1,\"\"))","v":"2019-12-31"}]
[{"$f":"IF(A59=\"\",\"\",IF(OR(A59-1>DATE(2015,5,19),$G$3=\"PR\"),A59-1,\"\"))","v":"2019-12-30"}]
[{"$f":"IF(A60=\"\",\"\",IF(OR(A60-1>DATE(2015,5,19),$G$3=\"PR\"),A60-1,\"\"))","v":"2019-12-29"}]
[{"$f":"IF(A61=\"\",\"\",IF(OR(A61-1>DATE(2015,5,19),$G$3=\"PR\"),A61-1,\"\"))","v":"2019-12-28"}]
[{"$f":"IF(A62=\"\",\"\",IF(OR(A62-1>DATE(2015,5,19),$G$3=\"PR\"),A62-1,\"\"))","v":"2019-12-27"}]
[{"$f":"IF(A63=\"\",\"\",IF(OR(A63-1>DATE(2015,5,19),$G$3=\"PR\"),A63-1,\"\"))","v":"2019-12-26"}]
[{"$f":"IF(A64=\"\",\"\",IF(OR(A64-1>DATE(2015,5,19),$G$3=\"PR\"),A64-1,\"\"))","v":"2019-12-25"}]
[{"$f":"IF(A65=\"\",\"\",IF(OR(A65-1>DATE(2015,5,19),$G$3=\"PR\"),A65-1,\"\"))","v":"2019-12-24"}]
[{"$f":"IF(A66=\"\",\"\",IF(OR(A66-1>DATE(2015,5,19),$G$3=\"PR\"),A66-1,\"\"))","v":"2019-12-23"}]
[{"$f":"IF(A67=\"\",\"\",IF(OR(A67-1>DATE(2015,5,19),$G$3=\"PR\"),A67-1,\"\"))","v":"2019-12-22"}]
[{"$f":"IF(A68=\"\",\"\",IF(OR(A68-1>DATE(2015,5,19),$G$3=\"PR\"),A68-1,\"\"))","v":"2019-12-21"}]
[{"$f":"IF(A69=\"\",\"\",IF(OR(A69-1>DATE(2015,5,19),$G$3=\"PR\"),A69-1,\"\"))","v":"2019-12-20"}]
[{"$f":"IF(A70=\"\",\"\",IF(OR(A70-1>DATE(2015,5,19),$G$3=\"PR\"),A70-1,\"\"))","v":"2019-12-19"}]
[{"$f":"IF(A71=\"\",\"\",IF(OR(A71-1>DATE(2015,5,19),$G$3=\"PR\"),A71-1,\"\"))","v":"2019-12-18"}]
[{"$f":"IF(A72=\"\",\"\",IF(OR(A72-1>DATE(2015,5,19),$G$3=\"PR\"),A72-1,\"\"))","v":"2019-12-17"}]
[{"$f":"IF(A73=\"\",\"\",IF(OR(A73-1>DATE(2015,5,19),$G$3=\"PR\"),A73-1,\"\"))","v":"2019-12-16"}]
[{"$f":"IF(A74=\"\",\"\",IF(OR(A74-1>DATE(2015,5,19),$G$3=\"PR\"),A74-1,\"\"))","v":"2019-12-15"}]
[{"$f":"IF(A75=\"\",\"\",IF(OR(A75-1>DATE(2015,5,19),$G$3=\"PR\"),A75-1,\"\"))","v":"2019-12-14"}]
[{"$f":"IF(A76=\"\",\"\",IF(OR(A76-1>DATE(2015,5,19),$G$3=\"PR\"),A76-1,\"\"))","v":"2019-12-13"}]
[{"$f":"IF(A77=\"\",\"\",IF(OR(A77-1>DATE(2015,5,19),$G$3=\"PR\"),A77-1,\"\"))","v":"2019-12-12"}]
[{"$f":"IF(A78=\"\",\"\",IF(OR(A78-1>DATE(2015,5,19),$G$3=\"PR\"),A78-1,\"\"))","v":"2019-12-11"}]
[{"$f":"IF(A79=\"\",\"\",IF(OR(A79-1>DATE(2015,5,19),$G$3=\"PR\"),A79-1,\"\"))","v":"2019-12-10"}]
[{"$f":"IF(A80=\"\",\"\",IF(OR(A80-1>DATE(2015,5,19),$G$3=\"PR\"),A80-1,\"\"))","v":"2019-12-09"}]
[{"$f":"IF(A81=\"\",\"\",IF(OR(A81-1>DATE(2015,5,19),$G$3=\"PR\"),A81-1,\"\"))","v":"2019-12-08"}]
[{"$f":"IF(A82=\"\",\"\",IF(OR(A82-1>DATE(2015,5,19),$G$3=\"PR\"),A82-1,\"\"))","v":"2019-12-07"}]
[{"$f":"IF(A83=\"\",\"\",IF(OR(A83-1>DATE(2015,5,19),$G$3=\"PR\"),A83-1,\"\"))","v":"2019-12-06"}]
[{"$f":"IF(A84=\"\",\"\",IF(OR(A84-1>DATE(2015,5,19),$G$3=\"PR\"),A84-1,\"\"))","v":"2019-12-05"}]
[{"$f":"IF(A85=\"\",\"\",IF(OR(A85-1>DATE(2015,5,19),$G$3=\"PR\"),A85-1,\"\"))","v":"2019-12-04"}]
[{"$f":"IF(A86=\"\",\"\",IF(OR(A86-1>DATE(2015,5,19),$G$3=\"PR\"),A86-1,\"\"))","v":"2019-12-03"}]
[{"$f":"IF(A87=\"\",\"\",IF(OR(A87-1>DATE(2015,5,19),$G$3=\"PR\"),A87-1,\"\"))","v":"2019-12-02"}]
[{"$f":"IF(A88=\"\",\"\",IF(OR(A88-1>DATE(2015,5,19),$G$3=\"PR\"),A88-1,\"\"))","v":"2019-12-01"}]
[{"$f":"IF(A89=\"\",\"\",IF(OR(A89-1>DATE(2015,5,19),$G$3=\"PR\"),A89-1,\"\"))","v":"2019-11-30"}]
[{"$f":"IF(A90=\"\",\"\",IF(OR(A90-1>DATE(2015,5,19),$G$3=\"PR\"),A90-1,\"\"))","v":"2019-11-29"}]
[{"$f":"IF(A91=\"\",\"\",IF(OR(A91-1>DATE(2015,5,19),$G$3=\"PR\"),A91-1,\"\"))","v":"2019-11-28"}]
[{"$f":"IF(A92=\"\",\"\",IF(OR(A92-1>DATE(2015,5,19),$G$3=\"PR\"),A92-1,\"\"))","v":"2019-11-27"}]
[{"$f":"IF(A93=\"\",\"\",IF(OR(A93-1>DATE(2015,5,19),$G$3=\"PR\"),A93-1,\"\"))","v":"2019-11-26"}]
[{"$f":"IF(A94=\"\",\"\",IF(OR(A94-1>DATE(2015,5,19),$G$3=\"PR\"),A94-1,\"\"))","v":"2019-11-25"}]
[{"$f":"IF(A95=\"\",\"\",IF(OR(A95-1>DATE(2015,5,19),$G$3=\"PR\"),A95-1,\"\"))","v":"2019-11-24"}]
[{"$f":"IF(A96=\"\",\"\",IF(OR(A96-1>DATE(2015,5,19),$G$3=\"PR\"),A96-1,\"\"))","v":"2019-11-23"}]
[{"$f":"IF(A97=\"\",\"\",IF(OR(A97-1>DATE(2015,5,19),$G$3=\"PR\"),A97-1,\"\"))","v":"2019-11-22"}]
[{"$f":"IF(A98=\"\",\"\",IF(OR(A98-1>DATE(2015,5,19),$G$3=\"PR\"),A98-1,\"\"))","v":"2019-11-21"}]
[{"$f":"IF(A99=\"\",\"\",IF(OR(A99-1>DATE(2015,5,19),$G$3=\"PR\"),A99-1,\"\"))","v":"2019-11-20"}]
[{"$f":"IF(A100=\"\",\"\",IF(OR(A100-1>DATE(2015,5,19),$G$3=\"PR\"),A100-1,\"\"))","v":"2019-11-19"}]
[{"$f":"IF(A101=\"\",\"\",IF(OR(A101-1>DATE(2015,5,19),$G$3=\"PR\"),A101-1,\"\"))","v":"2019-11-18"}]
[{"$f":"IF(A102=\"\",\"\",IF(OR(A102-1>DATE(2015,5,19),$G$3=\"PR\"),A102-1,\"\"))","v":"2019-11-17"}]
[{"$f":"IF(A103=\"\",\"\",IF(OR(A103-1>DATE(2015,5,19),$G$3=\"PR\"),A103-1,\"\"))","v":"2019-11-16"}]
[{"$f":"IF(A104=\"\",\"\",IF(OR(A104-1>DATE(2015,5,19),$G$3=\"PR\"),A104-1,\"\"))","v":"2019-11-15"}]
[{"$f":"IF(A105=\"\",\"\",IF(OR(A105-1>DATE(2015,5,19),$G$3=\"PR\"),A105-1,\"\"))","v":"2019-11-14"}]
[{"$f":"IF(A106=\"\",\"\",IF(OR(A106-1>DATE(2015,5,19),$G$3=\"PR\"),A106-1,\"\"))","v":"2019-11-13"}]
[{"$f":"IF(A107=\"\",\"\",IF(OR(A107-1>DATE(2015,5,19),$G$3=\"PR\"),A107-1,\"\"))","v":"2019-11-12"}]
[{"$f":"IF(A108=\"\",\"\",IF(OR(A108-1>DATE(2015,5,19),$G$3=\"PR\"),A108-1,\"\"))","v":"2019-11-11"}]
[{"$f":"IF(A109=\"\",\"\",IF(OR(A109-1>DATE(2015,5,19),$G$3=\"PR\"),A109-1,\"\"))","v":"2019-11-10"}]
[{"$f":"IF(A110=\"\",\"\",IF(OR(A110-1>DATE(2015,5,19),$G$3=\"PR\"),A110-1,\"\"))","v":"2019-11-09"}]
[{"$f":"IF(A111=\"\",\"\",IF(OR(A111-1>DATE(2015,5,19),$G$3=\"PR\"),A111-1,\"\"))","v":"2019-11-08"}]
[{"$f":"IF(A112=\"\",\"\",IF(OR(A112-1>DATE(2015,5,19),$G$3=\"PR\"),A112-1,\"\"))","v":"2019-11-07"}]
[{"$f":"IF(A113=\"\",\"\",IF(OR(A113-1>DATE(2015,5,19),$G$3=\"PR\"),A113-1,\"\"))","v":"2019-11-06"}]
[{"$f":"IF(A114=\"\",\"\",IF(OR(A114-1>DATE(2015,5,19),$G$3=\"PR\"),A114-1,\"\"))","v":"2019-11-05"}]
[{"$f":"IF(A115=\"\",\"\",IF(OR(A115-1>DATE(2015,5,19),$G$3=\"PR\"),A115-1,\"\"))","v":"2019-11-04"}]
[{"$f":"IF(A116=\"\",\"\",IF(OR(A116-1>DATE(2015,5,19),$G$3=\"PR\"),A116-1,\"\"))","v":"2019-11-03"}]
[{"$f":"IF(A117=\"\",\"\",IF(OR(A117-1>DATE(2015,5,19),$G$3=\"PR\"),A117-1,\"\"))","v":"2019-11-02"}]
[{"$f":"IF(A118=\"\",\"\",IF(OR(A118-1>DATE(2015,5,19),$G$3=\"PR\"),A118-1,\"\"))","v":"2019-11-01"}]
[{"$f":"IF(A119=\"\",\"\",IF(OR(A119-1>DATE(2015,5,19),$G$3=\"PR\"),A119-1,\"\"))","v":"2019-10-31"}]
[{"$f":"IF(A120=\"\",\"\",IF(OR(A120-1>DATE(2015,5,19),$G$3=\"PR\"),A120-1,\"\"))","v":"2019-10-30"}]
[{"$f":"IF(A121=\"\",\"\",IF(OR(A121-1>DATE(2015,5,19),$G$3=\"PR\"),A121-1,\"\"))","v":"2019-10-29"}]
[{"$f":"IF(A122=\"\",\"\",IF(OR(A122-1>DATE(2015,5,19),$G$3=\"PR\"),A122-1,\"\"))","v":"2019-10-28"}]
[{"$f":"IF(A123=\"\",\"\",IF(OR(A123-1>DATE(2015,5,19),$G$3=\"PR\"),A123-1,\"\"))","v":"2019-10-27"}]
[{"$f":"IF(A124=\"\",\"\",IF(OR(A124-1>DATE(2015,5,19),$G$3=\"PR\"),A124-1,\"\"))","v":"2019-10-26"}]
[{"$f":"IF(A125=\"\",\"\",IF(OR(A125-1>DATE(2015,5,19),$G$3=\"PR\"),A125-1,\"\"))","v":"2019-10-25"}]
[{"$f":"IF(A126=\"\",\"\",IF(OR(A126-1>DATE(2015,5,19),$G$3=\"PR\"),A126-1,\"\"))","v":"2019-10-24"}]
[{"$f":"IF(A127=\"\",\"\",IF(OR(A127-1>DATE(2015,5,19),$G$3=\"PR\"),A127-1,\"\"))","v":"2019-10-23"}]
[{"$f":"IF(A128=\"\",\"\",IF(OR(A128-1>DATE(2015,5,19),$G$3=\"PR\"),A128-1,\"\"))","v":"2019-10-22"}]
[{"$f":"IF(A129=\"\",\"\",IF(OR(A129-1>DATE(2015,5,19),$G$3=\"PR\"),A129-1,\"\"))","v":"2019-10-21"}]
[{"$f":"IF(A130=\"\",\"\",IF(OR(A130-1>DATE(2015,5,19),$G$3=\"PR\"),A130-1,\"\"))","v":"2019-10-20"}]
[{"$f":"IF(A131=\"\",\"\",IF(OR(A131-1>DATE(2015,5,19),$G$3=\"PR\"),A131-1,\"\"))","v":"2019-10-19"}]
[{"$f":"IF(A132=\"\",\"\",IF(OR(A132-1>DATE(2015,5,19),$G$3=\"PR\"),A132-1,\"\"))","v":"2019-10-18"}]
[{"$f":"IF(A133=\"\",\"\",IF(OR(A133-1>DATE(2015,5,19),$G$3=\"PR\"),A133-1,\"\"))","v":"2019-10-17"}]
[{"$f":"IF(A134=\"\",\"\",IF(OR(A134-1>DATE(2015,5,19),$G$3=\"PR\"),A134-1,\"\"))","v":"2019-10-16"}]
[{"$f":"IF(A135=\"\",\"\",IF(OR(A135-1>DATE(2015,5,19),$G$3=\"PR\"),A135-1,\"\"))","v":"2019-10-15"}]
[{"$f":"IF(A136=\"\",\"\",IF(OR(A136-1>DATE(2015,5,19),$G$3=\"PR\"),A136-1,\"\"))","v":"2019-10-14"}]
[{"$f":"IF(A137=\"\",\"\",IF(OR(A137-1>DATE(2015,5,19),$G$3=\"PR\"),A137-1,\"\"))","v":"2019-10-13"}]
[{"$f":"IF(A138=\"\",\"\",IF(OR(A138-1>DATE(2015,5,19),$G$3=\"PR\"),A138-1,\"\"))","v":"2019-10-12"}]
[{"$f":"IF(A139=\"\",\"\",IF(OR(A139-1>DATE(2015,5,19),$G$3=\"PR\"),A139-1,\"\"))","v":"2019-10-11"}]
[{"$f":"IF(A140=\"\",\"\",IF(OR(A140-1>DATE(2015,5,19),$G$3=\"PR\"),A140-1,\"\"))","v":"2019-10-10"}]
[{"$f":"IF(A141=\"\",\"\",IF(OR(A141-1>DATE(2015,5,19),$G$3=\"PR\"),A141-1,\"\"))","v":"2019-10-09"}]
[{"$f":"IF(A142=\"\",\"\",IF(OR(A142-1>DATE(2015,5,19),$G$3=\"PR\"),A142-1,\"\"))","v":"2019-10-08"}]
[{"$f":"IF(A143=\"\",\"\",IF(OR(A143-1>DATE(2015,5,19),$G$3=\"PR\"),A143-1,\"\"))","v":"2019-10-07"}]
[{"$f":"IF(A144=\"\",\"\",IF(OR(A144-1>DATE(2015,5,19),$G$3=\"PR\"),A144-1,\"\"))","v":"2019-10-06"}]
[{"$f":"IF(A145=\"\",\"\",IF(OR(A145-1>DATE(2015,5,19),$G$3=\"PR\"),A145-1,\"\"))","v":"2019-10-05"}]
[{"$f":"IF(A146=\"\",\"\",IF(OR(A146-1>DATE(2015,5,19),$G$3=\"PR\"),A146-1,\"\"))","v":"2019-10-04"}]
[{"$f":"IF(A147=\"\",\"\",IF(OR(A147-1>DATE(2015,5,19),$G$3=\"PR\"),A147-1,\"\"))","v":"2019-10-03"}]
[{"$f":"IF(A148=\"\",\"\",IF(OR(A148-1>DATE(2015,5,19),$G$3=\"PR\"),A148-1,\"\"))","v":"2019-10-02"}]
[{"$f":"IF(A149=\"\",\"\",IF(OR(A149-1>DATE(2015,5,19),$G$3=\"PR\"),A149-1,\"\"))","v":"2019-10-01"}]
[{"$f":"IF(A150=\"\",\"\",IF(OR(A150-1>DATE(2015,5,19),$G$3=\"PR\"),A150-1,\"\"))","v":"2019-09-30"}]
[{"$f":"IF(A151=\"\",\"\",IF(OR(A151-1>DATE(2015,5,19),$G$3=\"PR\"),A151-1,\"\"))","v":"2019-09-29"}]
[{"$f":"IF(A152=\"\",\"\",IF(OR(A152-1>DATE(2015,5,19),$G$3=\"PR\"),A152-1,\"\"))","v":"2019-09-28"}]
[{"$f":"IF(A153=\"\",\"\",IF(OR(A153-1>DATE(2015,5,19),$G$3=\"PR\"),A153-1,\"\"))","v":"2019-09-27"}]
[{"$f":"IF(A154=\"\",\"\",IF(OR(A154-1>DATE(2015,5,19),$G$3=\"PR\"),A154-1,\"\"))","v":"2019-09-26"}]
[{"$f":"IF(A155=\"\",\"\",IF(OR(A155-1>DATE(2015,5,19),$G$3=\"PR\"),A155-1,\"\"))","v":"2019-09-25"}]
[{"$f":"IF(A156=\"\",\"\",IF(OR(A156-1>DATE(2015,5,19),$G$3=\"PR\"),A156-1,\"\"))","v":"2019-09-24"}]
[{"$f":"IF(A157=\"\",\"\",IF(OR(A157-1>DATE(2015,5,19),$G$3=\"PR\"),A157-1,\"\"))","v":"2019-09-23"}]
[{"$f":"IF(A158=\"\",\"\",IF(OR(A158-1>DATE(2015,5,19),$G$3=\"PR\"),A158-1,\"\"))","v":"2019-09-22"}]
[{"$f":"IF(A159=\"\",\"\",IF(OR(A159-1>DATE(2015,5,19),$G$3=\"PR\"),A159-1,\"\"))","v":"2019-09-21"}]
[{"$f":"IF(A160=\"\",\"\",IF(OR(A160-1>DATE(2015,5,19),$G$3=\"PR\"),A160-1,\"\"))","v":"2019-09-20"}]
[{"$f":"IF(A161=\"\",\"\",IF(OR(A161-1>DATE(2015,5,19),$G$3=\"PR\"),A161-1,\"\"))","v":"2019-09-19"}]
[{"$f":"IF(A162=\"\",\"\",IF(OR(A162-1>DATE(2015,5,19),$G$3=\"PR\"),A162-1,\"\"))","v":"2019-09-18"}]
[{"$f":"IF(A163=\"\",\"\",IF(OR(A163-1>DATE(2015,5,19),$G$3=\"PR\"),A163-1,\"\"))","v":"2019-09-17"}]
[{"$f":"IF(A164=\"\",\"\",IF(OR(A164-1>DATE(2015,5,19),$G$3=\"PR\"),A164-1,\"\"))","v":"2019-09-16"}]
[{"$f":"IF(A165=\"\",\"\",IF(OR(A165-1>DATE(2015,5,19),$G$3=\"PR\"),A165-1,\"\"))","v":"2019-09-15"}]
[{"$f":"IF(A166=\"\",\"\",IF(OR(A166-1>DATE(2015,5,19),$G$3=\"PR\"),A166-1,\"\"))","v":"2019-09-14"}]
[{"$f":"IF(A167=\"\",\"\",IF(OR(A167-1>DATE(2015,5,19),$G$3=\"PR\"),A167-1,\"\"))","v":"2019-09-13"}]
[{"$f":"IF(A168=\"\",\"\",IF(OR(A168-1>DATE(2015,5,19),$G$3=\"PR\"),A168-1,\"\"))","v":"2019-09-12"}]
[{"$f":"IF(A169=\"\",\"\",IF(OR(A169-1>DATE(2015,5,19),$G$3=\"PR\"),A169-1,\"\"))","v":"2019-09-11"}]
[{"$f":"IF(A170=\"\",\"\",IF(OR(A170-1>DATE(2015,5,19),$G$3=\"PR\"),A170-1,\"\"))","v":"2019-09-10"}]
[{"$f":"IF(A171=\"\",\"\",IF(OR(A171-1>DATE(2015,5,19),$G$3=\"PR\"),A171-1,\"\"))","v":"2019-09-09"}]
[{"$f":"IF(A172=\"\",\"\",IF(OR(A172-1>DATE(2015,5,19),$G$3=\"PR\"),A172-1,\"\"))","v":"2019-09-08"}]
[{"$f":"IF(A173=\"\",\"\",IF(OR(A173-1>DATE(2015,5,19),$G$3=\"PR\"),A173-1,\"\"))","v":"2019-09-07"}]
[{"$f":"IF(A174=\"\",\"\",IF(OR(A174-1>DATE(2015,5,19),$G$3=\"PR\"),A174-1,\"\"))","v":"2019-09-06"}]
[{"$f":"IF(A175=\"\",\"\",IF(OR(A175-1>DATE(2015,5,19),$G$3=\"PR\"),A175-1,\"\"))","v":"2019-09-05"}]
[{"$f":"IF(A176=\"\",\"\",IF(OR(A176-1>DATE(2015,5,19),$G$3=\"PR\"),A176-1,\"\"))","v":"2019-09-04"}]
[{"$f":"IF(A177=\"\",\"\",IF(OR(A177-1>DATE(2015,5,19),$G$3=\"PR\"),A177-1,\"\"))","v":"2019-09-03"}]
[{"$f":"IF(A178=\"\",\"\",IF(OR(A178-1>DATE(2015,5,19),$G$3=\"PR\"),A178-1,\"\"))","v":"2019-09-02"}]
[{"$f":"IF(A179=\"\",\"\",IF(OR(A179-1>DATE(2015,5,19),$G$3=\"PR\"),A179-1,\"\"))","v":"2019-09-01"}]
[{"$f":"IF(A180=\"\",\"\",IF(OR(A180-1>DATE(2015,5,19),$G$3=\"PR\"),A180-1,\"\"))","v":"2019-08-31"}]
[{"$f":"IF(A181=\"\",\"\",IF(OR(A181-1>DATE(2015,5,19),$G$3=\"PR\"),A181-1,\"\"))","v":"2019-08-30"}]
[{"$f":"IF(A182=\"\",\"\",IF(OR(A182-1>DATE(2015,5,19),$G$3=\"PR\"),A182-1,\"\"))","v":"2019-08-29"}]
[{"$f":"IF(A183=\"\",\"\",IF(OR(A183-1>DATE(2015,5,19),$G$3=\"PR\"),A183-1,\"\"))","v":"2019-08-28"}]
[{"$f":"IF(A184=\"\",\"\",IF(OR(A184-1>DATE(2015,5,19),$G$3=\"PR\"),A184-1,\"\"))","v":"2019-08-27"}]
[{"$f":"IF(A185=\"\",\"\",IF(OR(A185-1>DATE(2015,5,19),$G$3=\"PR\"),A185-1,\"\"))","v":"2019-08-26"}]
[{"$f":"IF(A186=\"\",\"\",IF(OR(A186-1>DATE(2015,5,19),$G$3=\"PR\"),A186-1,\"\"))","v":"2019-08-25"}]
[{"$f":"IF(A187=\"\",\"\",IF(OR(A187-1>DATE(2015,5,19),$G$3=\"PR\"),A187-1,\"\"))","v":"2019-08-24"}]
[{"$f":"IF(A188=\"\",\"\",IF(OR(A188-1>DATE(2015,5,19),$G$3=\"PR\"),A188-1,\"\"))","v":"2019-08-23"}]
[{"$f":"IF(A189=\"\",\"\",IF(OR(A189-1>DATE(2015,5,19),$G$3=\"PR\"),A189-1,\"\"))","v":"2019-08-22"}]
[{"$f":"IF(A190=\"\",\"\",IF(OR(A190-1>DATE(2015,5,19),$G$3=\"PR\"),A190-1,\"\"))","v":"2019-08-21"}]
[{"$f":"IF(A191=\"\",\"\",IF(OR(A191-1>DATE(2015,5,19),$G$3=\"PR\"),A191-1,\"\"))","v":"2019-08-20"}]
[{"$f":"IF(A192=\"\",\"\",IF(OR(A192-1>DATE(2015,5,19),$G$3=\"PR\"),A192-1,\"\"))","v":"2019-08-19"}]
[{"$f":"IF(A193=\"\",\"\",IF(OR(A193-1>DATE(2015,5,19),$G$3=\"PR\"),A193-1,\"\"))","v":"2019-08-18"}]
[{"$f":"IF(A194=\"\",\"\",IF(OR(A194-1>DATE(2015,5,19),$G$3=\"PR\"),A194-1,\"\"))","v":"2019-08-17"}]
[{"$f":"IF(A195=\"\",\"\",IF(OR(A195-1>DATE(2015,5,19),$G$3=\"PR\"),A195-1,\"\"))","v":"2019-08-16"}]
[{"$f":"IF(A196=\"\",\"\",IF(OR(A196-1>DATE(2015,5,19),$G$3=\"PR\"),A196-1,\"\"))","v":"2019-08-15"}]
[{"$f":"IF(A197=\"\",\"\",IF(OR(A197-1>DATE(2015,5,19),$G$3=\"PR\"),A197-1,\"\"))","v":"2019-08-14"}]
[{"$f":"IF(A198=\"\",\"\",IF(OR(A198-1>DATE(2015,5,19),$G$3=\"PR\"),A198-1,\"\"))","v":"2019-08-13"}]
[{"$f":"IF(A199=\"\",\"\",IF(OR(A199-1>DATE(2015,5,19),$G$3=\"PR\"),A199-1,\"\"))","v":"2019-08-12"}]
[{"$f":"IF(A200=\"\",\"\",IF(OR(A200-1>DATE(2015,5,19),$G$3=\"PR\"),A200-1,\"\"))","v":"2019-08-11"}]
[{"$f":"IF(A201=\"\",\"\",IF(OR(A201-1>DATE(2015,5,19),$G$3=\"PR\"),A201-1,\"\"))","v":"2019-08-10"}]
[{"$f":"IF(A202=\"\",\"\",IF(OR(A202-1>DATE(2015,5,19),$G$3=\"PR\"),A202-1,\"\"))","v":"2019-08-09"}]
[{"$f":"IF(A203=\"\",\"\",IF(OR(A203-1>DATE(2015,5,19),$G$3=\"PR\"),A203-1,\"\"))","v":"2019-08-08"}]
[{"$f":"IF(A204=\"\",\"\",IF(OR(A204-1>DATE(2015,5,19),$G$3=\"PR\"),A204-1,\"\"))","v":"2019-08-07"}]
[{"$f":"IF(A205=\"\",\"\",IF(OR(A205-1>DATE(2015,5,19),$G$3=\"PR\"),A205-1,\"\"))","v":"2019-08-06"}]
[{"$f":"IF(A206=\"\",\"\",IF(OR(A206-1>DATE(2015,5,19),$G$3=\"PR\"),A206-1,\"\"))","v":"2019-08-05"}]
[{"$f":"IF(A207=\"\",\"\",IF(OR(A207-1>DATE(2015,5,19),$G$3=\"PR\"),A207-1,\"\"))","v":"2019-08-04"}]
[{"$f":"IF(A208=\"\",\"\",IF(OR(A208-1>DATE(2015,5,19),$G$3=\"PR\"),A208-1,\"\"))","v":"2019-08-03"}]
[{"$f":"IF(A209=\"\",\"\",IF(OR(A209-1>DATE(2015,5,19),$G$3=\"PR\"),A209-1,\"\"))","v":"2019-08-02"}]
[{"$f":"IF(A210=\"\",\"\",IF(OR(A210-1>DATE(2015,5,19),$G$3=\"PR\"),A210-1,\"\"))","v":"2019-08-01"}]
[{"$f":"IF(A211=\"\",\"\",IF(OR(A211-1>DATE(2015,5,19),$G$3=\"PR\"),A211-1,\"\"))","v":"2019-07-31"}]
[{"$f":"IF(A212=\"\",\"\",IF(OR(A212-1>DATE(2015,5,19),$G$3=\"PR\"),A212-1,\"\"))","v":"2019-07-30"}]
[{"$f":"IF(A213=\"\",\"\",IF(OR(A213-1>DATE(2015,5,19),$G$3=\"PR\"),A213-1,\"\"))","v":"2019-07-29"}]
[{"$f":"IF(A214=\"\",\"\",IF(OR(A214-1>DATE(2015,5,19),$G$3=\"PR\"),A214-1,\"\"))","v":"2019-07-28"}]
[{"$f":"IF(A215=\"\",\"\",IF(OR(A215-1>DATE(2015,5,19),$G$3=\"PR\"),A215-1,\"\"))","v":"2019-07-27"}]
[{"$f":"IF(A216=\"\",\"\",IF(OR(A216-1>DATE(2015,5,19),$G$3=\"PR\"),A216-1,\"\"))","v":"2019-07-26"}]
[{"$f":"IF(A217=\"\",\"\",IF(OR(A217-1>DATE(2015,5,19),$G$3=\"PR\"),A217-1,\"\"))","v":"2019-07-25"}]
[{"$f":"IF(A218=\"\",\"\",IF(OR(A218-1>DATE(2015,5,19),$G$3=\"PR\"),A218-1,\"\"))","v":"2019-07-24"}]
[{"$f":"IF(A219=\"\",\"\",IF(OR(A219-1>DATE(2015,5,19),$G$3=\"PR\"),A219-1,\"\"))","v":"2019-07-23"}]
[{"$f":"IF(A220=\"\",\"\",IF(OR(A220-1>DATE(2015,5,19),$G$3=\"PR\"),A220-1,\"\"))","v":"2019-07-22"}]
[{"$f":"IF(A221=\"\",\"\",IF(OR(A221-1>DATE(2015,5,19),$G$3=\"PR\"),A221-1,\"\"))","v":"2019-07-21"}]
[{"$f":"IF(A222=\"\",\"\",IF(OR(A222-1>DATE(2015,5,19),$G$3=\"PR\"),A222-1,\"\"))","v":"2019-07-20"}]
[{"$f":"IF(A223=\"\",\"\",IF(OR(A223-1>DATE(2015,5,19),$G$3=\"PR\"),A223-1,\"\"))","v":"2019-07-19"}]
[{"$f":"IF(A224=\"\",\"\",IF(OR(A224-1>DATE(2015,5,19),$G$3=\"PR\"),A224-1,\"\"))","v":"2019-07-18"}]
[{"$f":"IF(A225=\"\",\"\",IF(OR(A225-1>DATE(2015,5,19),$G$3=\"PR\"),A225-1,\"\"))","v":"2019-07-17"}]
[{"$f":"IF(A226=\"\",\"\",IF(OR(A226-1>DATE(2015,5,19),$G$3=\"PR\"),A226-1,\"\"))","v":"2019-07-16"}]
[{"$f":"IF(A227=\"\",\"\",IF(OR(A227-1>DATE(2015,5,19),$G$3=\"PR\"),A227-1,\"\"))","v":"2019-07-15"}]
[{"$f":"IF(A228=\"\",\"\",IF(OR(A228-1>DATE(2015,5,19),$G$3=\"PR\"),A228-1,\"\"))","v":"2019-07-14"}]
[{"$f":"IF(A229=\"\",\"\",IF(OR(A229-1>DATE(2015,5,19),$G$3=\"PR\"),A229-1,\"\"))","v":"2019-07-13"}]
[{"$f":"IF(A230=\"\",\"\",IF(OR(A230-1>DATE(2015,5,19),$G$3=\"PR\"),A230-1,\"\"))","v":"2019-07-12"}]
[{"$f":"IF(A231=\"\",\"\",IF(OR(A231-1>DATE(2015,5,19),$G$3=\"PR\"),A231-1,\"\"))","v":"2019-07-11"}]
[{"$f":"IF(A232=\"\",\"\",IF(OR(A232-1>DATE(2015,5,19),$G$3=\"PR\"),A232-1,\"\"))","v":"2019-07-10"}]
[{"$f":"IF(A233=\"\",\"\",IF(OR(A233-1>DATE(2015,5,19),$G$3=\"PR\"),A233-1,\"\"))","v":"2019-07-09"}]
[{"$f":"IF(A234=\"\",\"\",IF(OR(A234-1>DATE(2015,5,19),$G$3=\"PR\"),A234-1,\"\"))","v":"2019-07-08"}]
[{"$f":"IF(A235=\"\",\"\",IF(OR(A235-1>DATE(2015,5,19),$G$3=\"PR\"),A235-1,\"\"))","v":"2019-07-07"}]
[{"$f":"IF(A236=\"\",\"\",IF(OR(A236-1>DATE(2015,5,19),$G$3=\"PR\"),A236-1,\"\"))","v":"2019-07-06"}]
[{"$f":"IF(A237=\"\",\"\",IF(OR(A237-1>DATE(2015,5,19),$G$3=\"PR\"),A237-1,\"\"))","v":"2019-07-05"}]
[{"$f":"IF(A238=\"\",\"\",IF(OR(A238-1>DATE(2015,5,19),$G$3=\"PR\"),A238-1,\"\"))","v":"2019-07-04"}]
[{"$f":"IF(A239=\"\",\"\",IF(OR(A239-1>DATE(2015,5,19),$G$3=\"PR\"),A239-1,\"\"))","v":"2019-07-03"}]
[{"$f":"IF(A240=\"\",\"\",IF(OR(A240-1>DATE(2015,5,19),$G$3=\"PR\"),A240-1,\"\"))","v":"2019-07-02"}]
[{"$f":"IF(A241=\"\",\"\",IF(OR(A241-1>DATE(2015,5,19),$G$3=\"PR\"),A241-1,\"\"))","v":"2019-07-01"}]
[{"$f":"IF(A242=\"\",\"\",IF(OR(A242-1>DATE(2015,5,19),$G$3=\"PR\"),A242-1,\"\"))","v":"2019-06-30"}]
[{"$f":"IF(A243=\"\",\"\",IF(OR(A243-1>DATE(2015,5,19),$G$3=\"PR\"),A243-1,\"\"))","v":"2019-06-29"}]
[{"$f":"IF(A244=\"\",\"\",IF(OR(A244-1>DATE(2015,5,19),$G$3=\"PR\"),A244-1,\"\"))","v":"2019-06-28"}]
[{"$f":"IF(A245=\"\",\"\",IF(OR(A245-1>DATE(2015,5,19),$G$3=\"PR\"),A245-1,\"\"))","v":"2019-06-27"}]
[{"$f":"IF(A246=\"\",\"\",IF(OR(A246-1>DATE(2015,5,19),$G$3=\"PR\"),A246-1,\"\"))","v":"2019-06-26"}]
[{"$f":"IF(A247=\"\",\"\",IF(OR(A247-1>DATE(2015,5,19),$G$3=\"PR\"),A247-1,\"\"))","v":"2019-06-25"}]
[{"$f":"IF(A248=\"\",\"\",IF(OR(A248-1>DATE(2015,5,19),$G$3=\"PR\"),A248-1,\"\"))","v":"2019-06-24"}]
[{"$f":"IF(A249=\"\",\"\",IF(OR(A249-1>DATE(2015,5,19),$G$3=\"PR\"),A249-1,\"\"))","v":"2019-06-23"}]
[{"$f":"IF(A250=\"\",\"\",IF(OR(A250-1>DATE(2015,5,19),$G$3=\"PR\"),A250-1,\"\"))","v":"2019-06-22"}]
[{"$f":"IF(A251=\"\",\"\",IF(OR(A251-1>DATE(2015,5,19),$G$3=\"PR\"),A251-1,\"\"))","v":"2019-06-21"}]
[{"$f":"IF(A252=\"\",\"\",IF(OR(A252-1>DATE(2015,5,19),$G$3=\"PR\"),A252-1,\"\"))","v":"2019-06-20"}]
[{"$f":"IF(A253=\"\",\"\",IF(OR(A253-1>DATE(2015,5,19),$G$3=\"PR\"),A253-1,\"\"))","v":"2019-06-19"}]
[{"$f":"IF(A254=\"\",\"\",IF(OR(A254-1>DATE(2015,5,19),$G$3=\"PR\"),A254-1,\"\"))","v":"2019-06-18"}]
[{"$f":"IF(A255=\"\",\"\",IF(OR(A255-1>DATE(2015,5,19),$G$3=\"PR\"),A255-1,\"\"))","v":"2019-06-17"}]
[{"$f":"IF(A256=\"\",\"\",IF(OR(A256-1>DATE(2015,5,19),$G$3=\"PR\"),A256-1,\"\"))","v":"2019-06-16"}]
[{"$f":"IF(A257=\"\",\"\",IF(OR(A257-1>DATE(2015,5,19),$G$3=\"PR\"),A257-1,\"\"))","v":"2019-06-15"}]
[{"$f":"IF(A258=\"\",\"\",IF(OR(A258-1>DATE(2015,5,19),$G$3=\"PR\"),A258-1,\"\"))","v":"2019-06-14"}]
[{"$f":"IF(A259=\"\",\"\",IF(OR(A259-1>DATE(2015,5,19),$G$3=\"PR\"),A259-1,\"\"))","v":"2019-06-13"}]
[{"$f":"IF(A260=\"\",\"\",IF(OR(A260-1>DATE(2015,5,19),$G$3=\"PR\"),A260-1,\"\"))","v":"2019-06-12"}]
[{"$f":"IF(A261=\"\",\"\",IF(OR(A261-1>DATE(2015,5,19),$G$3=\"PR\"),A261-1,\"\"))","v":"2019-06-11"}]
[{"$f":"IF(A262=\"\",\"\",IF(OR(A262-1>DATE(2015,5,19),$G$3=\"PR\"),A262-1,\"\"))","v":"2019-06-10"}]
[{"$f":"IF(A263=\"\",\"\",IF(OR(A263-1>DATE(2015,5,19),$G$3=\"PR\"),A263-1,\"\"))","v":"2019-06-09"}]
[{"$f":"IF(A264=\"\",\"\",IF(OR(A264-1>DATE(2015,5,19),$G$3=\"PR\"),A264-1,\"\"))","v":"2019-06-08"}]
[{"$f":"IF(A265=\"\",\"\",IF(OR(A265-1>DATE(2015,5,19),$G$3=\"PR\"),A265-1,\"\"))","v":"2019-06-07"}]
[{"$f":"IF(A266=\"\",\"\",IF(OR(A266-1>DATE(2015,5,19),$G$3=\"PR\"),A266-1,\"\"))","v":"2019-06-06"}]
[{"$f":"IF(A267=\"\",\"\",IF(OR(A267-1>DATE(2015,5,19),$G$3=\"PR\"),A267-1,\"\"))","v":"2019-06-05"}]
[{"$f":"IF(A268=\"\",\"\",IF(OR(A268-1>DATE(2015,5,19),$G$3=\"PR\"),A268-1,\"\"))","v":"2019-06-04"}]
[{"$f":"IF(A269=\"\",\"\",IF(OR(A269-1>DATE(2015,5,19),$G$3=\"PR\"),A269-1,\"\"))","v":"2019-06-03"}]
[{"$f":"IF(A270=\"\",\"\",IF(OR(A270-1>DATE(2015,5,19),$G$3=\"PR\"),A270-1,\"\"))","v":"2019-06-02"}]
[{"$f":"IF(A271=\"\",\"\",IF(OR(A271-1>DATE(2015,5,19),$G$3=\"PR\"),A271-1,\"\"))","v":"2019-06-01"}]
[{"$f":"IF(A272=\"\",\"\",IF(OR(A272-1>DATE(2015,5,19),$G$3=\"PR\"),A272-1,\"\"))","v":"2019-05-31"}]
[{"$f":"IF(A273=\"\",\"\",IF(OR(A273-1>DATE(2015,5,19),$G$3=\"PR\"),A273-1,\"\"))","v":"2019-05-30"}]
[{"$f":"IF(A274=\"\",\"\",IF(OR(A274-1>DATE(2015,5,19),$G$3=\"PR\"),A274-1,\"\"))","v":"2019-05-29"}]
[{"$f":"IF(A275=\"\",\"\",IF(OR(A275-1>DATE(2015,5,19),$G$3=\"PR\"),A275-1,\"\"))","v":"2019-05-28"}]
[{"$f":"IF(A276=\"\",\"\",IF(OR(A276-1>DATE(2015,5,19),$G$3=\"PR\"),A276-1,\"\"))","v":"2019-05-27"}]
[{"$f":"IF(A277=\"\",\"\",IF(OR(A277-1>DATE(2015,5,19),$G$3=\"PR\"),A277-1,\"\"))","v":"2019-05-26"}]
[{"$f":"IF(A278=\"\",\"\",IF(OR(A278-1>DATE(2015,5,19),$G$3=\"PR\"),A278-1,\"\"))","v":"2019-05-25"}]
[{"$f":"IF(A279=\"\",\"\",IF(OR(A279-1>DATE(2015,5,19),$G$3=\"PR\"),A279-1,\"\"))","v":"2019-05-24"}]
[{"$f":"IF(A280=\"\",\"\",IF(OR(A280-1>DATE(2015,5,19),$G$3=\"PR\"),A280-1,\"\"))","v":"2019-05-23"}]
[{"$f":"IF(A281=\"\",\"\",IF(OR(A281-1>DATE(2015,5,19),$G$3=\"PR\"),A281-1,\"\"))","v":"2019-05-22"}]
[{"$f":"IF(A282=\"\",\"\",IF(OR(A282-1>DATE(2015,5,19),$G$3=\"PR\"),A282-1,\"\"))","v":"2019-05-21"}]
[{"$f":"IF(A283=\"\",\"\",IF(OR(A283-1>DATE(2015,5,19),$G$3=\"PR\"),A283-1,\"\"))","v":"2019-05-20"}]
[{"$f":"IF(A284=\"\",\"\",IF(OR(A284-1>DATE(2015,5,19),$G$3=\"PR\"),A284-1,\"\"))","v":"2019-05-19"}]
[{"$f":"IF(A285=\"\",\"\",IF(OR(A285-1>DATE(2015,5,19),$G$3=\"PR\"),A285-1,\"\"))","v":"2019-05-18"}]
[{"$f":"IF(A286=\"\",\"\",IF(OR(A286-1>DATE(2015,5,19),$G$3=\"PR\"),A286-1,\"\"))","v":"2019-05-17"}]
[{"$f":"IF(A287=\"\",\"\",IF(OR(A287-1>DATE(2015,5,19),$G$3=\"PR\"),A287-1,\"\"))","v":"2019-05-16"}]
[{"$f":"IF(A288=\"\",\"\",IF(OR(A288-1>DATE(2015,5,19),$G$3=\"PR\"),A288-1,\"\"))","v":"2019-05-15"}]
[{"$f":"IF(A289=\"\",\"\",IF(OR(A289-1>DATE(2015,5,19),$G$3=\"PR\"),A289-1,\"\"))","v":"2019-05-14"}]
[{"$f":"IF(A290=\"\",\"\",IF(OR(A290-1>DATE(2015,5,19),$G$3=\"PR\"),A290-1,\"\"))","v":"2019-05-13"}]
[{"$f":"IF(A291=\"\",\"\",IF(OR(A291-1>DATE(2015,5,19),$G$3=\"PR\"),A291-1,\"\"))","v":"2019-05-12"}]
[{"$f":"IF(A292=\"\",\"\",IF(OR(A292-1>DATE(2015,5,19),$G$3=\"PR\"),A292-1,\"\"))","v":"2019-05-11"}]
[{"$f":"IF(A293=\"\",\"\",IF(OR(A293-1>DATE(2015,5,19),$G$3=\"PR\"),A293-1,\"\"))","v":"2019-05-10"}]
[{"$f":"IF(A294=\"\",\"\",IF(OR(A294-1>DATE(2015,5,19),$G$3=\"PR\"),A294-1,\"\"))","v":"2019-05-09"}]
[{"$f":"IF(A295=\"\",\"\",IF(OR(A295-1>DATE(2015,5,19),$G$3=\"PR\"),A295-1,\"\"))","v":"2019-05-08"}]
[{"$f":"IF(A296=\"\",\"\",IF(OR(A296-1>DATE(2015,5,19),$G$3=\"PR\"),A296-1,\"\"))","v":"2019-05-07"}]
[{"$f":"IF(A297=\"\",\"\",IF(OR(A297-1>DATE(2015,5,19),$G$3=\"PR\"),A297-1,\"\"))","v":"2019-05-06"}]
[{"$f":"IF(A298=\"\",\"\",IF(OR(A298-1>DATE(2015,5,19),$G$3=\"PR\"),A298-1,\"\"))","v":"2019-05-05"}]
[{"$f":"IF(A299=\"\",\"\",IF(OR(A299-1>DATE(2015,5,19),$G$3=\"PR\"),A299-1,\"\"))","v":"2019-05-04"}]
[{"$f":"IF(A300=\"\",\"\",IF(OR(A300-1>DATE(2015,5,19),$G$3=\"PR\"),A300-1,\"\"))","v":"2019-05-03"}]
[{"$f":"IF(A301=\"\",\"\",IF(OR(A301-1>DATE(2015,5,19),$G$3=\"PR\"),A301-1,\"\"))","v":"2019-05-02"}]
[{"$f":"IF(A302=\"\",\"\",IF(OR(A302-1>DATE(2015,5,19),$G$3=\"PR\"),A302-1,\"\"))","v":"2019-05-01"}]
[{"$f":"IF(A303=\"\",\"\",IF(OR(A303-1>DATE(2015,5,19),$G$3=\"PR\"),A303-1,\"\"))","v":"2019-04-30"}]
[{"$f":"IF(A304=\"\",\"\",IF(OR(A304-1>DATE(2015,5,19),$G$3=\"PR\"),A304-1,\"\"))","v":"2019-04-29"}]
[{"$f":"IF(A305=\"\",\"\",IF(OR(A305-1>DATE(2015,5,19),$G$3=\"PR\"),A305-1,\"\"))","v":"2019-04-28"}]
[{"$f":"IF(A306=\"\",\"\",IF(OR(A306-1>DATE(2015,5,19),$G$3=\"PR\"),A306-1,\"\"))","v":"2019-04-27"}]
[{"$f":"IF(A307=\"\",\"\",IF(OR(A307-1>DATE(2015,5,19),$G$3=\"PR\"),A307-1,\"\"))","v":"2019-04-26"}]
[{"$f":"IF(A308=\"\",\"\",IF(OR(A308-1>DATE(2015,5,19),$G$3=\"PR\"),A308-1,\"\"))","v":"2019-04-25"}]
[{"$f":"IF(A309=\"\",\"\",IF(OR(A309-1>DATE(2015,5,19),$G$3=\"PR\"),A309-1,\"\"))","v":"2019-04-24"}]
[{"$f":"IF(A310=\"\",\"\",IF(OR(A310-1>DATE(2015,5,19),$G$3=\"PR\"),A310-1,\"\"))","v":"2019-04-23"}]
[{"$f":"IF(A311=\"\",\"\",IF(OR(A311-1>DATE(2015,5,19),$G$3=\"PR\"),A311-1,\"\"))","v":"2019-04-22"}]
[{"$f":"IF(A312=\"\",\"\",IF(OR(A312-1>DATE(2015,5,19),$G$3=\"PR\"),A312-1,\"\"))","v":"2019-04-21"}]
[{"$f":"IF(A313=\"\",\"\",IF(OR(A313-1>DATE(2015,5,19),$G$3=\"PR\"),A313-1,\"\"))","v":"2019-04-20"}]
[{"$f":"IF(A314=\"\",\"\",IF(OR(A314-1>DATE(2015,5,19),$G$3=\"PR\"),A314-1,\"\"))","v":"2019-04-19"}]
[{"$f":"IF(A315=\"\",\"\",IF(OR(A315-1>DATE(2015,5,19),$G$3=\"PR\"),A315-1,\"\"))","v":"2019-04-18"}]
[{"$f":"IF(A316=\"\",\"\",IF(OR(A316-1>DATE(2015,5,19),$G$3=\"PR\"),A316-1,\"\"))","v":"2019-04-17"}]
[{"$f":"IF(A317=\"\",\"\",IF(OR(A317-1>DATE(2015,5,19),$G$3=\"PR\"),A317-1,\"\"))","v":"2019-04-16"}]
[{"$f":"IF(A318=\"\",\"\",IF(OR(A318-1>DATE(2015,5,19),$G$3=\"PR\"),A318-1,\"\"))","v":"2019-04-15"}]
[{"$f":"IF(A319=\"\",\"\",IF(OR(A319-1>DATE(2015,5,19),$G$3=\"PR\"),A319-1,\"\"))","v":"2019-04-14"}]
[{"$f":"IF(A320=\"\",\"\",IF(OR(A320-1>DATE(2015,5,19),$G$3=\"PR\"),A320-1,\"\"))","v":"2019-04-13"}]
[{"$f":"IF(A321=\"\",\"\",IF(OR(A321-1>DATE(2015,5,19),$G$3=\"PR\"),A321-1,\"\"))","v":"2019-04-12"}]
[{"$f":"IF(A322=\"\",\"\",IF(OR(A322-1>DATE(2015,5,19),$G$3=\"PR\"),A322-1,\"\"))","v":"2019-04-11"}]
[{"$f":"IF(A323=\"\",\"\",IF(OR(A323-1>DATE(2015,5,19),$G$3=\"PR\"),A323-1,\"\"))","v":"2019-04-10"}]
[{"$f":"IF(A324=\"\",\"\",IF(OR(A324-1>DATE(2015,5,19),$G$3=\"PR\"),A324-1,\"\"))","v":"2019-04-09"}]
[{"$f":"IF(A325=\"\",\"\",IF(OR(A325-1>DATE(2015,5,19),$G$3=\"PR\"),A325-1,\"\"))","v":"2019-04-08"}]
[{"$f":"IF(A326=\"\",\"\",IF(OR(A326-1>DATE(2015,5,19),$G$3=\"PR\"),A326-1,\"\"))","v":"2019-04-07"}]
[{"$f":"IF(A327=\"\",\"\",IF(OR(A327-1>DATE(2015,5,19),$G$3=\"PR\"),A327-1,\"\"))","v":"2019-04-06"}]
[{"$f":"IF(A328=\"\",\"\",IF(OR(A328-1>DATE(2015,5,19),$G$3=\"PR\"),A328-1,\"\"))","v":"2019-04-05"}]
[{"$f":"IF(A329=\"\",\"\",IF(OR(A329-1>DATE(2015,5,19),$G$3=\"PR\"),A329-1,\"\"))","v":"2019-04-04"}]
[{"$f":"IF(A330=\"\",\"\",IF(OR(A330-1>DATE(2015,5,19),$G$3=\"PR\"),A330-1,\"\"))","v":"2019-04-03"}]
[{"$f":"IF(A331=\"\",\"\",IF(OR(A331-1>DATE(2015,5,19),$G$3=\"PR\"),A331-1,\"\"))","v":"2019-04-02"}]
[{"$f":"IF(A332=\"\",\"\",IF(OR(A332-1>DATE(2015,5,19),$G$3=\"PR\"),A332-1,\"\"))","v":"2019-04-01"}]
[{"$f":"IF(A333=\"\",\"\",IF(OR(A333-1>DATE(2015,5,19),$G$3=\"PR\"),A333-1,\"\"))","v":"2019-03-31"}]
[{"$f":"IF(A334=\"\",\"\",IF(OR(A334-1>DATE(2015,5,19),$G$3=\"PR\"),A334-1,\"\"))","v":"2019-03-30"}]
[{"$f":"IF(A335=\"\",\"\",IF(OR(A335-1>DATE(2015,5,19),$G$3=\"PR\"),A335-1,\"\"))","v":"2019-03-29"}]
[{"$f":"IF(A336=\"\",\"\",IF(OR(A336-1>DATE(2015,5,19),$G$3=\"PR\"),A336-1,\"\"))","v":"2019-03-28"}]
[{"$f":"IF(A337=\"\",\"\",IF(OR(A337-1>DATE(2015,5,19),$G$3=\"PR\"),A337-1,\"\"))","v":"2019-03-27"}]
[{"$f":"IF(A338=\"\",\"\",IF(OR(A338-1>DATE(2015,5,19),$G$3=\"PR\"),A338-1,\"\"))","v":"2019-03-26"}]
[{"$f":"IF(A339=\"\",\"\",IF(OR(A339-1>DATE(2015,5,19),$G$3=\"PR\"),A339-1,\"\"))","v":"2019-03-25"}]
[{"$f":"IF(A340=\"\",\"\",IF(OR(A340-1>DATE(2015,5,19),$G$3=\"PR\"),A340-1,\"\"))","v":"2019-03-24"}]
[{"$f":"IF(A341=\"\",\"\",IF(OR(A341-1>DATE(2015,5,19),$G$3=\"PR\"),A341-1,\"\"))","v":"2019-03-23"}]
[{"$f":"IF(A342=\"\",\"\",IF(OR(A342-1>DATE(2015,5,19),$G$3=\"PR\"),A342-1,\"\"))","v":"2019-03-22"}]
[{"$f":"IF(A343=\"\",\"\",IF(OR(A343-1>DATE(2015,5,19),$G$3=\"PR\"),A343-1,\"\"))","v":"2019-03-21"}]
[{"$f":"IF(A344=\"\",\"\",IF(OR(A344-1>DATE(2015,5,19),$G$3=\"PR\"),A344-1,\"\"))","v":"2019-03-20"}]
[{"$f":"IF(A345=\"\",\"\",IF(OR(A345-1>DATE(2015,5,19),$G$3=\"PR\"),A345-1,\"\"))","v":"2019-03-19"}]
[{"$f":"IF(A346=\"\",\"\",IF(OR(A346-1>DATE(2015,5,19),$G$3=\"PR\"),A346-1,\"\"))","v":"2019-03-18"}]
[{"$f":"IF(A347=\"\",\"\",IF(OR(A347-1>DATE(2015,5,19),$G$3=\"PR\"),A347-1,\"\"))","v":"2019-03-17"}]
[{"$f":"IF(A348=\"\",\"\",IF(OR(A348-1>DATE(2015,5,19),$G$3=\"PR\"),A348-1,\"\"))","v":"2019-03-16"}]
[{"$f":"IF(A349=\"\",\"\",IF(OR(A349-1>DATE(2015,5,19),$G$3=\"PR\"),A349-1,\"\"))","v":"2019-03-15"}]
[{"$f":"IF(A350=\"\",\"\",IF(OR(A350-1>DATE(2015,5,19),$G$3=\"PR\"),A350-1,\"\"))","v":"2019-03-14"}]
[{"$f":"IF(A351=\"\",\"\",IF(OR(A351-1>DATE(2015,5,19),$G$3=\"PR\"),A351-1,\"\"))","v":"2019-03-13"}]
[{"$f":"IF(A352=\"\",\"\",IF(OR(A352-1>DATE(2015,5,19),$G$3=\"PR\"),A352-1,\"\"))","v":"2019-03-12"}]
[{"$f":"IF(A353=\"\",\"\",IF(OR(A353-1>DATE(2015,5,19),$G$3=\"PR\"),A353-1,\"\"))","v":"2019-03-11"}]
[{"$f":"IF(A354=\"\",\"\",IF(OR(A354-1>DATE(2015,5,19),$G$3=\"PR\"),A354-1,\"\"))","v":"2019-03-10"}]
[{"$f":"IF(A355=\"\",\"\",IF(OR(A355-1>DATE(2015,5,19),$G$3=\"PR\"),A355-1,\"\"))","v":"2019-03-09"}]
[{"$f":"IF(A356=\"\",\"\",IF(OR(A356-1>DATE(2015,5,19),$G$3=\"PR\"),A356-1,\"\"))","v":"2019-03-08"}]
[{"$f":"IF(A357=\"\",\"\",IF(OR(A357-1>DATE(2015,5,19),$G$3=\"PR\"),A357-1,\"\"))","v":"2019-03-07"}]
[{"$f":"IF(A358=\"\",\"\",IF(OR(A358-1>DATE(2015,5,19),$G$3=\"PR\"),A358-1,\"\"))","v":"2019-03-06"}]
[{"$f":"IF(A359=\"\",\"\",IF(OR(A359-1>DATE(2015,5,19),$G$3=\"PR\"),A359-1,\"\"))","v":"2019-03-05"}]
[{"$f":"IF(A360=\"\",\"\",IF(OR(A360-1>DATE(2015,5,19),$G$3=\"PR\"),A360-1,\"\"))","v":"2019-03-04"}]
[{"$f":"IF(A361=\"\",\"\",IF(OR(A361-1>DATE(2015,5,19),$G$3=\"PR\"),A361-1,\"\"))","v":"2019-03-03"}]
[{"$f":"IF(A362=\"\",\"\",IF(OR(A362-1>DATE(2015,5,19),$G$3=\"PR\"),A362-1,\"\"))","v":"2019-03-02"}]
[{"$f":"IF(A363=\"\",\"\",IF(OR(A363-1>DATE(2015,5,19),$G$3=\"PR\"),A363-1,\"\"))","v":"2019-03-01"}]
[{"$f":"IF(A364=\"\",\"\",IF(OR(A364-1>DATE(2015,5,19),$G$3=\"PR\"),A364-1,\"\"))","v":"2019-02-28"}]
[{"$f":"IF(A365=\"\",\"\",IF(OR(A365-1>DATE(2015,5,19),$G$3=\"PR\"),A365-1,\"\"))","v":"2019-02-27"}]
[{"$f":"IF(A366=\"\",\"\",IF(OR(A366-1>DATE(2015,5,19),$G$3=\"PR\"),A366-1,\"\"))","v":"2019-02-26"}]
[{"$f":"IF(A367=\"\",\"\",IF(OR(A367-1>DATE(2015,5,19),$G$3=\"PR\"),A367-1,\"\"))","v":"2019-02-25"}]
[{"$f":"IF(A368=\"\",\"\",IF(OR(A368-1>DATE(2015,5,19),$G$3=\"PR\"),A368-1,\"\"))","v":"2019-02-24"}]
[{"$f":"IF(A369=\"\",\"\",IF(OR(A369-1>DATE(2015,5,19),$G$3=\"PR\"),A369-1,\"\"))","v":"2019-02-23"}]

{"sheet":"CWE Market view","index":1,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[19,1,24,1],[10,5,10,6],[11,5,17,6],[20,5,24,5],[20,6,24,6],[10,1,17,1],[5,3,8,6],[5,8,8,10],[3,8,3,10],[3,3,3,6],[1,3,1,10]]}
[]
[null,null,null,"Utility Tool  "]
[]
[null,"Reference \ntime:",null,"1) Check volume (interactive module)",null,null,null,null,"2) Max volume (information module)"]
[]
[null,"date:",null,"Here you can check the simultaneous execution of trading volumes of the markets involved in the CWE Market Coupling",null,null,null,null,"Here you can find the maximal  trade volumes (MWh/h) which can be physically transported between two Hubs under the condition that no other trade is executed between other Hubs."]
[null,"2020-02-26"]
[null,"hour:"]
[null,"1"]
[]
[null,"HUB TO HUB EXCHANGES ",null,null,"Hub-to-Hub \ntrade in MWh/h \n(please insert values)","Test 1: \n hub to hub \ninside FB space ",null,null,null,"direction\n-->","direction\n<--"]
[null,null,null,"DE=>AT",0,{"$f":"IF(PTDFs!M6>0,\"Constrained Transmission System\",\"Trades feasible\")","v":"Trades feasible"},null,null,"DE=>AT",{"$f":"INDEX('Max exchanges (Maxbex)'!N2:N41,$B$9,1)","v":0},{"$f":"INDEX('Max exchanges (Maxbex)'!G2:G41,$B$9,1)","v":0}]
[null,null,null,"DE=>BE",0,null,null,null,"DE=>BE",{"$f":"INDEX('Max exchanges (Maxbex)'!O2:O41,$B$9,1)","v":0},{"$f":"INDEX('Max exchanges (Maxbex)'!K2:K41,$B$9,1)","v":0}]
[null,null,null,"DE=>NL",0,null,null,null,"DE=>NL",{"$f":"INDEX('Max exchanges (Maxbex)'!Q2:Q41,$B$9,1)","v":0},{"$f":"INDEX('Max exchanges (Maxbex)'!X2:X41,$B$9,1)","v":0}]
[null,null,null,"DE=>FR",0,null,null,null,"DE=>FR",{"$f":"INDEX('Max exchanges (Maxbex)'!P2:P41,$B$9,1)","v":0},{"$f":"INDEX('Max exchanges (Maxbex)'!T2:T41,$B$9,1)","v":0}]
[null,null,null,"NL=>BE",0,null,null,null,"NL=>BE",{"$f":"INDEX('Max exchanges (Maxbex)'!W2:W41,$B$9,1)","v":0},{"$f":"INDEX('Max exchanges (Maxbex)'!M2:M41,$B$9,1)","v":0}]
[null,null,null,"NL=>FR",0,null,null,null,"NL=>FR",{"$f":"INDEX('Max exchanges (Maxbex)'!Y2:Y41,$B$9,1)","v":0},{"$f":"INDEX('Max exchanges (Maxbex)'!U2:U41,$B$9,1)","v":0}]
[null,null,null,"BE=>FR",0,null,null,null,"BE=>FR",{"$f":"INDEX('Max exchanges (Maxbex)'!L2:L41,$B$9,1)","v":0},{"$f":"INDEX('Max exchanges (Maxbex)'!S2:S41,$B$9,1)","v":0}]
[]
[null,"HUB \nPOSITION",null,null,"Hub Positions\ntrade in MWh/h \n(please insert values)","Test 1: \nsum hub positions = 0","Test 2: \n hub positions \ninside FB space ",null,null,"export","import"]
[null,null,null,"AT",0,{"$f":"IF(SUM(E21:E25)=0,\"OK\",\"KO\")","v":"OK"},{"$f":"IF(PTDFs!O6>0,\"Constrained Transmission System\",\"Trades feasible\")","v":"Trades feasible"},null,"AT",{"$f":"INDEX('Max net pos'!$K$2:$K$31,$B$9,1)","v":0},{"$f":"INDEX('Max net pos'!$J$2:$J$31,B9,1)","v":0}]
[null,null,null,"DE",0,null,null,null,"DE",{"$f":"INDEX('Max net pos'!$O$2:$O$31,B9,1)","v":0},{"$f":"INDEX('Max net pos'!$N$2:$N$31,B9,1)","v":0}]
[null,null,null,"BE",0,null,null,null,"BE",{"$f":"INDEX('Max net pos'!$M$2:$M$31,B9,1)","v":0},{"$f":"INDEX('Max net pos'!$L$2:$L$31,B9,1)","v":0}]
[null,null,null,"FR",0,null,null,null,"FR",{"$f":"INDEX('Max net pos'!$Q$2:$Q$31,B9,1)","v":0},{"$f":"INDEX('Max net pos'!$P$2:$P$31,B9,1)","v":0}]
[null,null,null,"NL",0,null,null,null,"NL",{"$f":"INDEX('Max net pos'!$S$2:$S$31,B9,1)","v":0},{"$f":"INDEX('Max net pos'!$R$2:$R$31,B9,1)","v":0}]

{"sheet":"CWE Market graphs","index":2,"n_rows":2,"n_cols":16,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,0,2,13],[1,15,2,25]]}
[]
["Maximum bilateral exchanges",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum / minimum net positions"]

{"sheet":"CWE map","index":3,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,4,2,16]]}
[]
["data shown for hour:",null,null,null,"CWE max net positions and bilateral exchanges"]
[{"$f":"'CWE Market view'!B9","v":"1"}]
[]
[]
[null,null,null,null,null,"NL",null,null,null,null,null,null,"DE"]
[]
[null,null,null,null,{"$f":"'CWE Market view'!J17","v":0},"←",null,"export",{"$f":"'CWE Market view'!J25","v":0},null,"←",{"$f":"'CWE Market view'!J14","v":0}]
[null,null,null,null,{"$f":"'CWE Market view'!K17","v":0},"→",null,"import",{"$f":"'CWE Market view'!K25","v":0},null,null,{"$f":"'CWE Market view'!K14","v":0},"→"]
[]
[null,null,null,null,null,null,null,null,"↑"]
[null,null,null,null,null,null,null,{"$f":"'CWE Market view'!J16","v":0},{"$f":"'CWE Market view'!K16","v":0}]
[null,null,null,null,null,"BE",null,"↓"]
[]
[null,null,null,null,null,null,null,"export",{"$f":"'CWE Market view'!J23","v":0},null,"←",{"$f":"'CWE Market view'!J13","v":0},null,null,"export",{"$f":"'CWE Market view'!J22","v":0}]
[null,null,null,null,null,null,null,"import",{"$f":"'CWE Market view'!K23","v":0},null,null,{"$f":"'CWE Market view'!K13","v":0},"→",null,"import",{"$f":"'CWE Market view'!K22","v":0}]
[]
[null,null,null,null,null,null,null,null,"↑"]
[null,null,null,null,null,null,null,{"$f":"'CWE Market view'!J18","v":0},{"$f":"'CWE Market view'!K18","v":0}]
[null,null,null,null,null,"FR",null,"↓"]
[]
[null,null,null,null,null,null,null,null,null,null,"←",{"$f":"'CWE Market view'!J15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'CWE Market view'!K15","v":0},"→"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SIGN(S24)=1,\"^\",IF(SIGN(S24)=0,\" \",\" \"))","v":" "},null,"↑"]
[null,null,null,null,{"$f":"'CWE Market view'!K17","v":0},"←",null,"export",{"$f":"'CWE Market view'!J24","v":0},null,null,null,null,null,{"$f":"+'CWE Market view'!J12","v":0},{"$f":"'CWE Market view'!K12","v":0}]
[null,null,null,null,{"$f":"'CWE Market view'!J17","v":0},"→",null,"import",{"$f":"'CWE Market view'!K24","v":0},null,null,null,"AT",{"$f":"IF(SIGN(S24)=1,\" \",IF(SIGN(S24)=0,\" \",\"v\"))","v":" "},"↓"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SIGN(S23)=1,\"<\",IF(SIGN(S23)=0,\" \",\" \"))","v":" "},null,{"$f":"IF(SIGN(S23)=1,\" \",IF(SIGN(S23)=0,\" \",\">\"))","v":" "},null,"export",{"$f":"'CWE Market view'!J21","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SIGN(U23)=1,\"<\",IF(SIGN(U23)=0,\" \",\" \"))","v":" "},null,{"$f":"IF(SIGN(U23)=1,\" \",IF(SIGN(U23)=0,\" \",\">\"))","v":" "},null,"import",{"$f":"'CWE Market view'!K21","v":0}]

{"sheet":"BorderDataOverview","index":4,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
["Date:","2019-02-15"]
[]
["Border:","FR-ES",null,"Choosing another Business Day on this sheet will also update the following sheets:"]
[null,null,null,"ATCs, Allocated Capacities, Price spread, Congestion Income, LTN, Shadow Auction ATC and ID ATC"]
["Hour","ATC (MW)","BEC (MW)","Price Spread (€/MWh)","Congestion Income (€)","LTN (MW)","Shadow Auction ATC (MW)","Intraday ATC (MW)"]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A6,'Allocated Capacities'!A6,'Price Spread'!A6,LTN!A6,'Intraday ATC'!A7,'Shadow Auction ATC'!A6,'Congestion Income'!A7)>0),Lists!C2,\"\")","v":""},{"$f":"IF($A7<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A7+1,FALSE),\"\")","v":""},{"$f":"IF($A7<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A7+1,FALSE),\"\")","v":""},{"$f":"IF($A7<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A7+1,FALSE),\"\")","v":""},{"$f":"IF($A7<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A7+1,FALSE),\"\")","v":""},{"$f":"IF($A7<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A7+1,FALSE),\"\")","v":""},{"$f":"IF($A7<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A7+1,FALSE),\"\")","v":""},{"$f":"IF($A7<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A7+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A7,'Allocated Capacities'!A7,'Price Spread'!A7,LTN!A7,'Intraday ATC'!A8,'Shadow Auction ATC'!A7,'Congestion Income'!A8)>0),Lists!C3,\"\")","v":""},{"$f":"IF($A8<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A8+1,FALSE),\"\")","v":""},{"$f":"IF($A8<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A8+1,FALSE),\"\")","v":""},{"$f":"IF($A8<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A8+1,FALSE),\"\")","v":""},{"$f":"IF($A8<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A8+1,FALSE),\"\")","v":""},{"$f":"IF($A8<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A8+1,FALSE),\"\")","v":""},{"$f":"IF($A8<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A8+1,FALSE),\"\")","v":""},{"$f":"IF($A8<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A8+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A8,'Allocated Capacities'!A8,'Price Spread'!A8,LTN!A8,'Intraday ATC'!A9,'Shadow Auction ATC'!A8,'Congestion Income'!A9)>0),Lists!C4,\"\")","v":""},{"$f":"IF($A9<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A9+1,FALSE),\"\")","v":""},{"$f":"IF($A9<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A9+1,FALSE),\"\")","v":""},{"$f":"IF($A9<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A9+1,FALSE),\"\")","v":""},{"$f":"IF($A9<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A9+1,FALSE),\"\")","v":""},{"$f":"IF($A9<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A9+1,FALSE),\"\")","v":""},{"$f":"IF($A9<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A9+1,FALSE),\"\")","v":""},{"$f":"IF($A9<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A9+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A9,'Allocated Capacities'!A9,'Price Spread'!A9,LTN!A9,'Intraday ATC'!A10,'Shadow Auction ATC'!A9,'Congestion Income'!A10)>0),Lists!C5,\"\")","v":""},{"$f":"IF($A10<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A10+1,FALSE),\"\")","v":""},{"$f":"IF($A10<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A10+1,FALSE),\"\")","v":""},{"$f":"IF($A10<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A10+1,FALSE),\"\")","v":""},{"$f":"IF($A10<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A10+1,FALSE),\"\")","v":""},{"$f":"IF($A10<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A10+1,FALSE),\"\")","v":""},{"$f":"IF($A10<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A10+1,FALSE),\"\")","v":""},{"$f":"IF($A10<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A10+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A10,'Allocated Capacities'!A10,'Price Spread'!A10,LTN!A10,'Intraday ATC'!A11,'Shadow Auction ATC'!A10,'Congestion Income'!A11)>0),Lists!C6,\"\")","v":""},{"$f":"IF($A11<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A11+1,FALSE),\"\")","v":""},{"$f":"IF($A11<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A11+1,FALSE),\"\")","v":""},{"$f":"IF($A11<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A11+1,FALSE),\"\")","v":""},{"$f":"IF($A11<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A11+1,FALSE),\"\")","v":""},{"$f":"IF($A11<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A11+1,FALSE),\"\")","v":""},{"$f":"IF($A11<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A11+1,FALSE),\"\")","v":""},{"$f":"IF($A11<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A11+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A11,'Allocated Capacities'!A11,'Price Spread'!A11,LTN!A11,'Intraday ATC'!A12,'Shadow Auction ATC'!A11,'Congestion Income'!A12)>0),Lists!C7,\"\")","v":""},{"$f":"IF($A12<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A12+1,FALSE),\"\")","v":""},{"$f":"IF($A12<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A12+1,FALSE),\"\")","v":""},{"$f":"IF($A12<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A12+1,FALSE),\"\")","v":""},{"$f":"IF($A12<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A12+1,FALSE),\"\")","v":""},{"$f":"IF($A12<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A12+1,FALSE),\"\")","v":""},{"$f":"IF($A12<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A12+1,FALSE),\"\")","v":""},{"$f":"IF($A12<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A12+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A12,'Allocated Capacities'!A12,'Price Spread'!A12,LTN!A12,'Intraday ATC'!A13,'Shadow Auction ATC'!A12,'Congestion Income'!A13)>0),Lists!C8,\"\")","v":""},{"$f":"IF($A13<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A13+1,FALSE),\"\")","v":""},{"$f":"IF($A13<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A13+1,FALSE),\"\")","v":""},{"$f":"IF($A13<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A13+1,FALSE),\"\")","v":""},{"$f":"IF($A13<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A13+1,FALSE),\"\")","v":""},{"$f":"IF($A13<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A13+1,FALSE),\"\")","v":""},{"$f":"IF($A13<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A13+1,FALSE),\"\")","v":""},{"$f":"IF($A13<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A13+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A13,'Allocated Capacities'!A13,'Price Spread'!A13,LTN!A13,'Intraday ATC'!A14,'Shadow Auction ATC'!A13,'Congestion Income'!A14)>0),Lists!C9,\"\")","v":""},{"$f":"IF($A14<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A14+1,FALSE),\"\")","v":""},{"$f":"IF($A14<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A14+1,FALSE),\"\")","v":""},{"$f":"IF($A14<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A14+1,FALSE),\"\")","v":""},{"$f":"IF($A14<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A14+1,FALSE),\"\")","v":""},{"$f":"IF($A14<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A14+1,FALSE),\"\")","v":""},{"$f":"IF($A14<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A14+1,FALSE),\"\")","v":""},{"$f":"IF($A14<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A14+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A14,'Allocated Capacities'!A14,'Price Spread'!A14,LTN!A14,'Intraday ATC'!A15,'Shadow Auction ATC'!A14,'Congestion Income'!A15)>0),Lists!C10,\"\")","v":""},{"$f":"IF($A15<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A15+1,FALSE),\"\")","v":""},{"$f":"IF($A15<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A15+1,FALSE),\"\")","v":""},{"$f":"IF($A15<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A15+1,FALSE),\"\")","v":""},{"$f":"IF($A15<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A15+1,FALSE),\"\")","v":""},{"$f":"IF($A15<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A15+1,FALSE),\"\")","v":""},{"$f":"IF($A15<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A15+1,FALSE),\"\")","v":""},{"$f":"IF($A15<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A15+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A15,'Allocated Capacities'!A15,'Price Spread'!A15,LTN!A15,'Intraday ATC'!A16,'Shadow Auction ATC'!A15,'Congestion Income'!A16)>0),Lists!C11,\"\")","v":""},{"$f":"IF($A16<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A16+1,FALSE),\"\")","v":""},{"$f":"IF($A16<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A16+1,FALSE),\"\")","v":""},{"$f":"IF($A16<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A16+1,FALSE),\"\")","v":""},{"$f":"IF($A16<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A16+1,FALSE),\"\")","v":""},{"$f":"IF($A16<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A16+1,FALSE),\"\")","v":""},{"$f":"IF($A16<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A16+1,FALSE),\"\")","v":""},{"$f":"IF($A16<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A16+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A16,'Allocated Capacities'!A16,'Price Spread'!A16,LTN!A16,'Intraday ATC'!A17,'Shadow Auction ATC'!A16,'Congestion Income'!A17)>0),Lists!C12,\"\")","v":""},{"$f":"IF($A17<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A17+1,FALSE),\"\")","v":""},{"$f":"IF($A17<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A17+1,FALSE),\"\")","v":""},{"$f":"IF($A17<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A17+1,FALSE),\"\")","v":""},{"$f":"IF($A17<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A17+1,FALSE),\"\")","v":""},{"$f":"IF($A17<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A17+1,FALSE),\"\")","v":""},{"$f":"IF($A17<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A17+1,FALSE),\"\")","v":""},{"$f":"IF($A17<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A17+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A17,'Allocated Capacities'!A17,'Price Spread'!A17,LTN!A17,'Intraday ATC'!A18,'Shadow Auction ATC'!A17,'Congestion Income'!A18)>0),Lists!C13,\"\")","v":""},{"$f":"IF($A18<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A18+1,FALSE),\"\")","v":""},{"$f":"IF($A18<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A18+1,FALSE),\"\")","v":""},{"$f":"IF($A18<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A18+1,FALSE),\"\")","v":""},{"$f":"IF($A18<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A18+1,FALSE),\"\")","v":""},{"$f":"IF($A18<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A18+1,FALSE),\"\")","v":""},{"$f":"IF($A18<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A18+1,FALSE),\"\")","v":""},{"$f":"IF($A18<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A18+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A18,'Allocated Capacities'!A18,'Price Spread'!A18,LTN!A18,'Intraday ATC'!A19,'Shadow Auction ATC'!A18,'Congestion Income'!A19)>0),Lists!C14,\"\")","v":""},{"$f":"IF($A19<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A19+1,FALSE),\"\")","v":""},{"$f":"IF($A19<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A19+1,FALSE),\"\")","v":""},{"$f":"IF($A19<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A19+1,FALSE),\"\")","v":""},{"$f":"IF($A19<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A19+1,FALSE),\"\")","v":""},{"$f":"IF($A19<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A19+1,FALSE),\"\")","v":""},{"$f":"IF($A19<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A19+1,FALSE),\"\")","v":""},{"$f":"IF($A19<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A19+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A19,'Allocated Capacities'!A19,'Price Spread'!A19,LTN!A19,'Intraday ATC'!A20,'Shadow Auction ATC'!A19,'Congestion Income'!A20)>0),Lists!C15,\"\")","v":""},{"$f":"IF($A20<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A20+1,FALSE),\"\")","v":""},{"$f":"IF($A20<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A20+1,FALSE),\"\")","v":""},{"$f":"IF($A20<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A20+1,FALSE),\"\")","v":""},{"$f":"IF($A20<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A20+1,FALSE),\"\")","v":""},{"$f":"IF($A20<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A20+1,FALSE),\"\")","v":""},{"$f":"IF($A20<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A20+1,FALSE),\"\")","v":""},{"$f":"IF($A20<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A20+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A20,'Allocated Capacities'!A20,'Price Spread'!A20,LTN!A20,'Intraday ATC'!A21,'Shadow Auction ATC'!A20,'Congestion Income'!A21)>0),Lists!C16,\"\")","v":""},{"$f":"IF($A21<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A21+1,FALSE),\"\")","v":""},{"$f":"IF($A21<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A21+1,FALSE),\"\")","v":""},{"$f":"IF($A21<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A21+1,FALSE),\"\")","v":""},{"$f":"IF($A21<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A21+1,FALSE),\"\")","v":""},{"$f":"IF($A21<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A21+1,FALSE),\"\")","v":""},{"$f":"IF($A21<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A21+1,FALSE),\"\")","v":""},{"$f":"IF($A21<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A21+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A21,'Allocated Capacities'!A21,'Price Spread'!A21,LTN!A21,'Intraday ATC'!A22,'Shadow Auction ATC'!A21,'Congestion Income'!A22)>0),Lists!C17,\"\")","v":""},{"$f":"IF($A22<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A22+1,FALSE),\"\")","v":""},{"$f":"IF($A22<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A22+1,FALSE),\"\")","v":""},{"$f":"IF($A22<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A22+1,FALSE),\"\")","v":""},{"$f":"IF($A22<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A22+1,FALSE),\"\")","v":""},{"$f":"IF($A22<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A22+1,FALSE),\"\")","v":""},{"$f":"IF($A22<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A22+1,FALSE),\"\")","v":""},{"$f":"IF($A22<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A22+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A22,'Allocated Capacities'!A22,'Price Spread'!A22,LTN!A22,'Intraday ATC'!A23,'Shadow Auction ATC'!A22,'Congestion Income'!A23)>0),Lists!C18,\"\")","v":""},{"$f":"IF($A23<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A23+1,FALSE),\"\")","v":""},{"$f":"IF($A23<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A23+1,FALSE),\"\")","v":""},{"$f":"IF($A23<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A23+1,FALSE),\"\")","v":""},{"$f":"IF($A23<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A23+1,FALSE),\"\")","v":""},{"$f":"IF($A23<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A23+1,FALSE),\"\")","v":""},{"$f":"IF($A23<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A23+1,FALSE),\"\")","v":""},{"$f":"IF($A23<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A23+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A23,'Allocated Capacities'!A23,'Price Spread'!A23,LTN!A23,'Intraday ATC'!A24,'Shadow Auction ATC'!A23,'Congestion Income'!A24)>0),Lists!C19,\"\")","v":""},{"$f":"IF($A24<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A24+1,FALSE),\"\")","v":""},{"$f":"IF($A24<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A24+1,FALSE),\"\")","v":""},{"$f":"IF($A24<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A24+1,FALSE),\"\")","v":""},{"$f":"IF($A24<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A24+1,FALSE),\"\")","v":""},{"$f":"IF($A24<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A24+1,FALSE),\"\")","v":""},{"$f":"IF($A24<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A24+1,FALSE),\"\")","v":""},{"$f":"IF($A24<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A24+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A24,'Allocated Capacities'!A24,'Price Spread'!A24,LTN!A24,'Intraday ATC'!A25,'Shadow Auction ATC'!A24,'Congestion Income'!A25)>0),Lists!C20,\"\")","v":""},{"$f":"IF($A25<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A25+1,FALSE),\"\")","v":""},{"$f":"IF($A25<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A25+1,FALSE),\"\")","v":""},{"$f":"IF($A25<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A25+1,FALSE),\"\")","v":""},{"$f":"IF($A25<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A25+1,FALSE),\"\")","v":""},{"$f":"IF($A25<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A25+1,FALSE),\"\")","v":""},{"$f":"IF($A25<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A25+1,FALSE),\"\")","v":""},{"$f":"IF($A25<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A25+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A25,'Allocated Capacities'!A25,'Price Spread'!A25,LTN!A25,'Intraday ATC'!A26,'Shadow Auction ATC'!A25,'Congestion Income'!A26)>0),Lists!C21,\"\")","v":""},{"$f":"IF($A26<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A26+1,FALSE),\"\")","v":""},{"$f":"IF($A26<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A26+1,FALSE),\"\")","v":""},{"$f":"IF($A26<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A26+1,FALSE),\"\")","v":""},{"$f":"IF($A26<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A26+1,FALSE),\"\")","v":""},{"$f":"IF($A26<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A26+1,FALSE),\"\")","v":""},{"$f":"IF($A26<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A26+1,FALSE),\"\")","v":""},{"$f":"IF($A26<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A26+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A26,'Allocated Capacities'!A26,'Price Spread'!A26,LTN!A26,'Intraday ATC'!A27,'Shadow Auction ATC'!A26,'Congestion Income'!A27)>0),Lists!C22,\"\")","v":""},{"$f":"IF($A27<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A27+1,FALSE),\"\")","v":""},{"$f":"IF($A27<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A27+1,FALSE),\"\")","v":""},{"$f":"IF($A27<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A27+1,FALSE),\"\")","v":""},{"$f":"IF($A27<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A27+1,FALSE),\"\")","v":""},{"$f":"IF($A27<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A27+1,FALSE),\"\")","v":""},{"$f":"IF($A27<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A27+1,FALSE),\"\")","v":""},{"$f":"IF($A27<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A27+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A27,'Allocated Capacities'!A27,'Price Spread'!A27,LTN!A27,'Intraday ATC'!A28,'Shadow Auction ATC'!A27,'Congestion Income'!A28)>0),Lists!C23,\"\")","v":""},{"$f":"IF($A28<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A28+1,FALSE),\"\")","v":""},{"$f":"IF($A28<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A28+1,FALSE),\"\")","v":""},{"$f":"IF($A28<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A28+1,FALSE),\"\")","v":""},{"$f":"IF($A28<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A28+1,FALSE),\"\")","v":""},{"$f":"IF($A28<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A28+1,FALSE),\"\")","v":""},{"$f":"IF($A28<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A28+1,FALSE),\"\")","v":""},{"$f":"IF($A28<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A28+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A28,'Allocated Capacities'!A28,'Price Spread'!A28,LTN!A28,'Intraday ATC'!A29,'Shadow Auction ATC'!A28,'Congestion Income'!A29)>0),Lists!C24,\"\")","v":""},{"$f":"IF($A29<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A29+1,FALSE),\"\")","v":""},{"$f":"IF($A29<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A29+1,FALSE),\"\")","v":""},{"$f":"IF($A29<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A29+1,FALSE),\"\")","v":""},{"$f":"IF($A29<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A29+1,FALSE),\"\")","v":""},{"$f":"IF($A29<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A29+1,FALSE),\"\")","v":""},{"$f":"IF($A29<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A29+1,FALSE),\"\")","v":""},{"$f":"IF($A29<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A29+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A29,'Allocated Capacities'!A29,'Price Spread'!A29,LTN!A29,'Intraday ATC'!A30,'Shadow Auction ATC'!A29,'Congestion Income'!A30)>0),Lists!C25,\"\")","v":""},{"$f":"IF($A30<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A30+1,FALSE),\"\")","v":""},{"$f":"IF($A30<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A30+1,FALSE),\"\")","v":""},{"$f":"IF($A30<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A30+1,FALSE),\"\")","v":""},{"$f":"IF($A30<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A30+1,FALSE),\"\")","v":""},{"$f":"IF($A30<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A30+1,FALSE),\"\")","v":""},{"$f":"IF($A30<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A30+1,FALSE),\"\")","v":""},{"$f":"IF($A30<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A30+1,FALSE),\"\")","v":""}]
[{"$f":"IF(AND($B$2<>\"\",SUM(ATCs!A30,'Allocated Capacities'!A30,'Price Spread'!A30,LTN!A30,'Intraday ATC'!A31,'Shadow Auction ATC'!A30,'Congestion Income'!A31)>0),Lists!C26,\"\")","v":""},{"$f":"IF($A31<>\"\",HLOOKUP($B$4,ATCs!$B$5:$M$36,$A31+1,FALSE),\"\")","v":""},{"$f":"IF($A31<>\"\",HLOOKUP($B$4,'Allocated Capacities'!$B$5:$W$42,$A31+1,FALSE),\"\")","v":""},{"$f":"IF($A31<>\"\",HLOOKUP($B$4,'Price Spread'!$B$5:$W$41,$A31+1,FALSE),\"\")","v":""},{"$f":"IF($A31<>\"\",HLOOKUP($B$4,'Congestion Income'!$N$6:$Y$36,$A31+1,FALSE),\"\")","v":""},{"$f":"IF($A31<>\"\",HLOOKUP($B$4,LTN!$B$5:$K$34,$A31+1,FALSE),\"\")","v":""},{"$f":"IF($A31<>\"\",HLOOKUP($B$4,'Shadow Auction ATC'!$B$5:$K$36,$A31+1,FALSE),\"\")","v":""},{"$f":"IF($A31<>\"\",HLOOKUP($B$4,'Intraday ATC'!$B$6:$Q$38,$A31+1,FALSE),\"\")","v":""}]

{"sheet":"Virgin domain initial comp.","index":5,"n_rows":4,"n_cols":27,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["Date:","2019-05-21"]
[]
["FileId","DeliveryDate","Period","Row","OutageName","EIC_Code","CriticalBranchName","EIC_Code","Presolved","RemainingAvailableMargin","Fmax","Fref","FRM","FAV","AMR","AMR_Exclusion","AMR_ExclusionJustification","BiddingArea_Shortname","Factor","BiddingArea_Shortname","Factor","BiddingArea_Shortname","Factor","BiddingArea_Shortname","Factor","BiddingArea_Shortname","Factor"]

{"sheet":"PTDFs_Early Publication","index":6,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[[7,13,8,13]]}
[]
["Date:","2020-02-26",null,""]
[]
[null,null,"AT-hub (MW)","BE-hub (MW)","DE-hub (MW)","FR-hub (MW)","NL-hub (MW)","Sum"]
[null,"Test Hub to Hub",{"$f":"-'CWE Market view'!E12","v":0},{"$f":"-'CWE Market view'!E13-'CWE Market view'!E16+'CWE Market view'!E18","v":0},{"$f":"'CWE Market view'!E12+'CWE Market view'!E13+'CWE Market view'!E14+'CWE Market view'!E15","v":0},{"$f":"-'CWE Market view'!E15-'CWE Market view'!E17-'CWE Market view'!E18","v":0},{"$f":"-'CWE Market view'!E14+'CWE Market view'!E16+'CWE Market view'!E17","v":0},{"$f":"SUM(C5:G5)","v":0}]
[null,"Test Hub Positions",{"$f":"'CWE Market view'!E21","v":0},{"$f":"'CWE Market view'!E23","v":0},{"$f":"'CWE Market view'!E22","v":0},{"$f":"'CWE Market view'!E24","v":0},{"$f":"'CWE Market view'!E25","v":0},{"$f":"SUM(C6:G6)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Test Hub to Hub","# of constraints violated","Test Hub positions"]
[null,"ID","Critical Branch name","EIC code","Critical Outage name","EIC code","AT-hub","BE-hub","DE-hub","FR-hub","NL-hub","RAM (MW)",{"$f":"SUM(M10:M2000)","v":0},null,{"$f":"SUM(O10:O2000)","v":0}]

{"sheet":"LTN","index":7,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[[3,1,3,10]]}
[]
["Date:","2020-02-26",null,""]
[]
[null,"LT Nominations (in MW)"]
["Hour","AT-DE","DE-AT","BE-NL","NL-BE","DE-NL","NL-DE","BE-FR","FR-BE","FR-DE","DE-FR"]

{"sheet":"PTDFs","index":8,"n_rows":6,"n_cols":15,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,null,"AT-hub (MW)","BE-hub (MW)","DE-hub (MW)","FR-hub (MW)","NL-hub (MW)","Sum"]
[null,"Test Hub to Hub",{"$f":"-'CWE Market view'!E12","v":0},{"$f":"-'CWE Market view'!E13-'CWE Market view'!E16+'CWE Market view'!E18","v":0},{"$f":"'CWE Market view'!E12+'CWE Market view'!E13+'CWE Market view'!E14+'CWE Market view'!E15","v":0},{"$f":"-'CWE Market view'!E15-'CWE Market view'!E17-'CWE Market view'!E18","v":0},{"$f":"-'CWE Market view'!E14+'CWE Market view'!E16+'CWE Market view'!E17","v":0},{"$f":"SUM(C2:G2)","v":0}]
[null,"Test Hub Positions",{"$f":"'CWE Market view'!E21","v":0},{"$f":"'CWE Market view'!E23","v":0},{"$f":"'CWE Market view'!E22","v":0},{"$f":"'CWE Market view'!E24","v":0},{"$f":"'CWE Market view'!E25","v":0},{"$f":"SUM(C3:G3)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Test Hub to Hub","# of constraints violated","Test Hub positions"]
[null,"ID","Critical Branch name","EIC code","Critical Outage name","EIC code","AT-hub","BE-hub","DE-hub","FR-hub","NL-hub","RAM (MW)",{"$f":"SUM(M7:M2000)","v":0},null,{"$f":"SUM(O7:O2000)","v":0}]

{"sheet":"Virgin domain final computation","index":9,"n_rows":4,"n_cols":27,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["Date:","2019-05-21",null,"An error has occured"]
[]
["FileId","DeliveryDate","Period","Row","OutageName","EIC_Code","CriticalBranchName","EIC_Code","Presolved","RemainingAvailableMargin","Fmax","Fref","FRM","FAV","AMR","AMR_Exclusion","AMR_ExclusionJustification","BiddingArea_Shortname","Factor","BiddingArea_Shortname","Factor","BiddingArea_Shortname","Factor","BiddingArea_Shortname","Factor","BiddingArea_Shortname","Factor"]

{"sheet":"ATCs","index":10,"n_rows":5,"n_cols":23,"rows_kept":5,"cut":false,"hidden":false,"merged":[[3,1,3,22]]}
[]
["Date:","2020-02-26",null,""]
[]
[null,"ATC (in MW)"]
["Hour","FR-ES","ES-FR","DK1-DE","DE-DK1","FR-IT","IT-FR","AT-IT","IT-AT","SI-IT","IT-SI","SI-AT","AT-SI","SI-HR","HR-SI","BE-GB","GB-BE","DE-D2","D2-DE","DK-NL","NL-DK","NO-NL","NL-NO"]

{"sheet":"Max net pos","index":11,"n_rows":1,"n_cols":19,"rows_kept":1,"cut":false,"hidden":false,"merged":[[141,0,150,0],[241,0,250,0],[1,0,10,0],[11,0,20,0],[21,0,30,0],[31,0,40,0],[41,0,50,0],[51,0,60,0],[61,0,70,0],[71,0,80,0],[81,0,90,0],[91,0,100,0],[101,0,110,0],[111,0,120,0],[121,0,130,0],[131,0,140,0],[211,0,220,0],[221,0,230,0],[231,0,240,0],[151,0,160,0],[161,0,170,0],[171,0,180,0],[181,0,190,0],[191,0,200,0],[201,0,210,0]]}
[null,"Prog","AT","BE","DE","FR","NL",null,"hour","Min AT","Max AT","Min BE","Max BE","Min DE","Max DE","Min FR","Max FR","Min NL","Max NL"]

{"sheet":"Max exchanges (Maxbex)","index":12,"n_rows":1,"n_cols":25,"rows_kept":1,"cut":false,"hidden":false,"merged":[[281,0,300,0],[481,0,500,0],[1,0,20,0],[21,0,40,0],[41,0,60,0],[61,0,80,0],[81,0,100,0],[101,0,120,0],[121,0,140,0],[141,0,160,0],[161,0,180,0],[181,0,200,0],[201,0,220,0],[221,0,240,0],[241,0,260,0],[261,0,280,0],[421,0,440,0],[441,0,460,0],[461,0,480,0],[301,0,320,0],[321,0,340,0],[341,0,360,0],[361,0,380,0],[381,0,400,0],[401,0,420,0]]}
[null,"Direction","Exchange",null,"hour","Max AT=>BE","Max AT=>DE","Max AT=>FR","Max AT=>NL","Max BE=>AT","Max BE=>DE","Max BE=>FR","Max BE=>NL","Max DE=>AT","Max DE=>BE","Max DE=>FR","Max DE=>NL","Max FR=>AT","Max FR=>BE","Max FR=>DE","Max FR=>NL","Max NL=>AT","Max NL=>BE","Max NL=>DE","Max NL=>FR"]

{"sheet":"Shadow Auction ATC","index":13,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[[3,1,3,10]]}
[]
["Date:","2020-02-26",null,""]
[]
[null,"Shadow Auction ATC (in MW)"]
["Hour","AT-DE","DE-AT","BE-NL","NL-BE","DE-NL","NL-DE","BE-FR","FR-BE","FR-DE","DE-FR"]

{"sheet":"Net Position","index":14,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[[3,1,3,5]]}
[]
["Date:","2020-02-26",null,""]
[]
[null,"Internal CWE Net Position (in MW)",null,null,null,null,"Import (-)     Export (+)"]
["Hour","AT","BE","DE","FR","NL"]

{"sheet":"Allocated Capacities","index":15,"n_rows":5,"n_cols":25,"rows_kept":5,"cut":false,"hidden":false,"merged":[[3,1,3,24]]}
[]
["Date:","2020-02-26",null,""]
[]
[null,"Bilateral Exchanges (in MW)"]
["Hour","AT-DE","DE-AT","FR-ES","ES-FR","DK1-DE","DE-DK1","BE-NL","NL-BE","DE-NL","NL-DE","BE-FR","FR-BE","FR-DE","DE-FR","FR-IT","IT-FR","AT-IT","IT-AT","SI-IT","IT-SI","SI-AT","AT-SI","SI-HR","HR-SI"]

{"sheet":"Price Spread","index":16,"n_rows":5,"n_cols":29,"rows_kept":5,"cut":false,"hidden":false,"merged":[[3,1,3,24],[3,25,3,28]]}
[]
["Date:","2020-02-26",null,""]
[]
[null,"Price Spread (in €/MWh)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loss-Adjusted Market Spread (in €/MWh)"]
["Hour","AT-DE","DE-AT","FR-ES","ES-FR","DK1-DE","DE-DK1","BE-NL","NL-BE","DE-NL","NL-DE","BE-FR","FR-BE","FR-DE","DE-FR","FR-IT","IT-FR","AT-IT","IT-AT","SI-IT","IT-SI","SI-AT","AT-SI","SI-HR","HR-SI","GB-IE","IE-GB","GB-NI","NI-GB"]

{"sheet":"Intraday ATC","index":17,"n_rows":6,"n_cols":21,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,2,2,12],[5,17,5,18],[5,19,5,20],[3,1,3,20],[5,1,5,2],[5,15,5,16],[5,13,5,14],[5,11,5,12],[5,9,5,10],[5,7,5,8],[5,5,5,6],[5,3,5,4]]}
[]
["Date:","2020-02-26",null,""]
[null,null,"Please note that the capacity values published here are the result of an automatic process using the day ahead flow based domain and the day ahead market clearing point. \nThese values do not necessarily represent the capacities being made available for intraday trading as they are published at a time when TSOs have not yet performed \ntheir grid analysis and capacity calculation processes based on the day ahead market results as day ahead left-overs and are therefore without commitment. \nAs soon as those processes are completed the TSOs will publish the final capacities available for intraday trading on the ENTSOE transparency platform."]
[null,"Intraday ATC (in MW)"]
["Hour","Initial","Increase/Decrease","Initial","Increase/Decrease","Initial","Increase/Decrease","Initial","Increase/Decrease","Initial","Increase/Decrease","Initial","Increase/Decrease","Initial","Increase/Decrease","Initial","Increase/Decrease","Initial","Increase/Decrease","Initial","Increase/Decrease"]
[null,"AT-DE",null,"DE-AT",null,"BE-NL",null,"NL-BE",null,"DE-NL",null,"NL-DE",null,"BE-FR",null,"FR-BE",null,"FR-DE",null,"DE-FR"]

{"sheet":"Congestion Income","index":18,"n_rows":6,"n_cols":27,"rows_kept":6,"cut":false,"hidden":false,"merged":[[4,1,4,5],[4,6,4,12],[3,1,3,26],[4,13,4,26]]}
[]
["Date:","2020-02-26",null,""]
[]
[null,"Congestion Income (in €)"]
[null,"Net Congestion Income Per Hub",null,null,null,null,"Net Congestion Income per TSO",null,null,null,null,null,null,"Gross Congestion Income per Border"]
["Hour","AT","BE","DE","FR","NL","Amprion","APG","Elia","RTE","Tennet BV","TenneT Gmbh","Transnet","DE-DK1","DK1-DE","FR-ES","ES-FR","FR-IT","IT-FR","AT-IT","IT-AT","SI-IT","IT-SI","SI-AT","AT-SI","SI-HR","HR-SI"]

{"sheet":"D2CF","index":19,"n_rows":6,"n_cols":43,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,40,5,42],[3,16,3,42],[3,1,3,15],[4,1,4,5],[4,6,4,10],[4,11,4,15],[5,28,5,30],[5,31,5,33],[5,34,5,36],[5,37,5,39],[5,16,5,18],[5,19,5,21],[5,22,5,24],[5,25,5,27]]}
[]
["Date:","2020-02-26",null,""]
[]
[null,"D2CF per Hub (in MW)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D2CF per TSO (in MW)"]
[null,"Vertical load",null,null,null,null,"Generation",null,null,null,null,"Best Forecast Net Positions ",null,null,null,null,"VertLoad","Gen","BFNP","VertLoad","Gen","BFNP","VertLoad","Gen","BFNP","VertLoad","Gen","BFNP","VertLoad","Gen","BFNP","VertLoad","Gen","BFNP","VertLoad","Gen","BFNP","VertLoad","Gen","BFNP","VertLoad","Gen","BFNP"]
["TimeStamps","AT","BE","DE","FR","NL","AT","BE","DE","FR","NL","AT","BE","DE","FR","NL","APG",null,null,"TenneT GmbH",null,null,"Transnet BW",null,null,"Amprion",null,null,"50Hertz",null,null,"Elia",null,null,"RTE",null,null,"TenneT BV",null,null,"Creos"]

{"sheet":"Refprog","index":20,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,1,3,11]]}
[]
["Date:","2020-02-26",null,""]
[]
[null,"Refprog Bilateral Exchanges (in MW)"]
["Hour","BE-NL","DE-NL","FR-BE","FR-DE","FR-ES","FR-IT","CH-DE","CH-FR","DE-CZ","DE-PL","APG-CZ","q"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes for extra borders:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WPS: part of Ukraine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zone ES+ includes ES and MA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zone DE+ includes DE, DKw and Luxemburg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zone SHB includes SI, HR and BA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zone SMM includes ME, RS and MK"]

{"sheet":"Final Flowbased domain","index":21,"n_rows":4,"n_cols":27,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["Date:","2019-05-21"]
[]
["FileId","DeliveryDate","Period","Row","OutageName","EIC_Code","CriticalBranchName","EIC_Code","Presolved","RemainingAvailableMargin (MW)","Fmax","Fref","FRM","FAV","AMR","AMR_Exclusion","AMR_ExclusionJustification","BiddingArea_Shortname","Factor","BiddingArea_Shortname","Factor","BiddingArea_Shortname","Factor","BiddingArea_Shortname","Factor","BiddingArea_Shortname","Factor"]

{"sheet":"Intraday Implicit Allocation","index":22,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[3,9,3,12],[4,9,4,10],[4,11,4,12],[3,1,3,4],[3,5,3,8],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8]]}
[]
["Date:","2020-02-26",null,""]
[]
[null,"Bilateral Exchanges (in MW)",null,null,null,"Price Spread (in €/MWh)",null,null,null,"Gross Congestion Income (in €)"]
[null,"Intraday 1",null,"Intraday 2",null,"Intraday 1",null,"Intraday 2",null,"Intraday 1",null,"Intraday 2"]
["Hour","CH-IT","IT-CH","CH-IT","IT-CH","CH-IT","IT-CH","CH-IT","IT-CH","CH-IT","IT-CH","CH-IT","IT-CH"]