{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["general","map","nodes","lines","zones","GSK","b-matrix","b-inverse","PTDF","AAF + CP","CI","external data","algorithm","cwe example"],"not_rendered":{"charts":7,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"general","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
["number of nodes",null,null,33]
["number of lines",null,null,50]
["number of zones",null,null,6]
[]
[null,"physical"]
[null,"commercial"]
[]
[null,11,"A",null,null,null,null,null,null,null,"F"]
[]
[null,null,null,0,{"$f":"'AAF + CP'!D4","v":-7.9873608184082556},null,null,0,{"$f":"'AAF + CP'!D5","v":7.9873608183972422}]
[null,null,"B",0,{"$f":"-E11","v":7.9873608184082556},null,"C",0,{"$f":"-I11","v":-7.9873608183972422}]
[null,null,null,null,null,{"$f":"'AAF + CP'!D22","v":58},{"$f":"-F13","v":-58}]
[null,null,null,null,null,{"$f":"'AAF + CP'!D6","v":35.885919915597547},{"$f":"-F14","v":-35.885919915597547}]
[null,null,null,0,{"$f":"'AAF + CP'!D7","v":14.126719266004471},null,null,{"$f":"'AAF + CP'!D23","v":47},{"$f":"'AAF + CP'!D8","v":32.873280733998129}]
[null,null,"D",0,{"$f":"-E15","v":-14.126719266004471},null,"E",{"$f":"-H15","v":-47},{"$f":"-I15","v":-32.873280733998129}]
[null,null,null,null,null,0,0,null,null,{"$f":"'AAF + CP'!D24","v":48.5},{"$f":"-J17","v":-48.5}]
[null,null,null,null,null,{"$f":"'AAF + CP'!D9","v":14.126719265998773},{"$f":"-F18","v":-14.126719265998773},null,null,{"$f":"'AAF + CP'!D10","v":48.500000000011354},{"$f":"-J18","v":-48.500000000011354}]

{"sheet":"map","index":1,"n_rows":35,"n_cols":56,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,46,2,47],[1,1,2,2],[11,1,12,2],[23,1,24,2],[30,44,31,45],[20,44,21,45]]}
[]
[null,"A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,null,null,22,null,{"$f":"nodes!B24","v":200},{"$f":"nodes!C24","v":650}]
[null,null,null,null,null,null,null,null,null,null,"ac","ab","aa",null,null,null,null,null,null,null,null,null,27,{"$f":"nodes!B29","v":250},{"$f":"nodes!C29","v":200},null,null,null,null,null,null,null,null,null,null,null,null,23,null,{"$f":"nodes!B25","v":150},{"$f":"nodes!C25","v":400}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ab","ae",null,null,null,null,null,null,null,null,null,null,null,null,null,"aa","y","x"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,null,null,{"$f":"nodes!B27","v":500},{"$f":"nodes!C27","v":150}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,null,{"$f":"nodes!B28","v":300},{"$f":"nodes!C28","v":100},null,null,null,null,null,"ae","ad","h","z",null,null,null,null,null,null,null,24,null,{"$f":"nodes!B26","v":200},{"$f":"nodes!C26","v":100},null,null,null,null,null,null,null,17,{"$f":"nodes!B19","v":100},{"$f":"nodes!C19","v":80}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ac","g","ad",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"z","l","y",null,null,null,null,null,null,null,null,"at","au"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-PTDF!J3","v":-12.518316251968615},{"$f":"-PTDF!J4","v":73.050559503558276},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-PTDF!J6","v":37.292404213809256},null,null,null,null,{"$f":"-PTDF!J13","v":-97.824647465399948}]
[null,"B"]
[null,null,null,null,null,null,2,{"$f":"nodes!B4","v":200},{"$f":"nodes!C4","v":40},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PTDF!J5","v":10.305546042403453}]
[null,null,null,null,null,null,"b","c",null,null,null,null,null,null,null,"f","e","g","h","i",null,null,null,null,null,"j","i","k"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,{"$f":"nodes!B7","v":50},{"$f":"nodes!C7","v":200},null,null,null,null,7,null,{"$f":"nodes!B9","v":10},{"$f":"nodes!C9","v":50},null,null,null,null,null,null,"k","l","x","w",null,null,null,null,null,null,null,null,null,21,null,{"$f":"nodes!B23","v":70},{"$f":"nodes!C23","v":110}]
[null,null,1,{"$f":"nodes!B3","v":80},{"$f":"nodes!C3","v":30},null,null,null,null,"d","c","e",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,{"$f":"nodes!B10","v":5},{"$f":"nodes!C10","v":10},null,null,null,null,null,null,null,null,"at","as","aw"]
[null,null,"a","b",null,null,null,null,null,3,null,{"$f":"nodes!B5","v":0},{"$f":"nodes!C5","v":300},null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,{"$f":"nodes!B14","v":130},{"$f":"nodes!C14","v":50},null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"nodes!B11","v":5},{"$f":"nodes!C11","v":40}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"j","r","s","t",null,null,null,null,null,null,null,null,null,null,null,null,"v","w"]
[]
[null,null,null,null,null,4,null,null,{"$f":"nodes!B6","v":250},{"$f":"nodes!C6","v":50},null,null,null,null,null,6,null,null,null,{"$f":"nodes!B8","v":200},{"$f":"nodes!C8","v":100},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,{"$f":"nodes!B20","v":100},{"$f":"nodes!C20","v":200}]
[null,null,null,null,null,"d","a","m","n",null,null,null,null,null,null,"f","n","o","p","r",null,null,null,null,null,11,null,{"$f":"nodes!B13","v":75},{"$f":"nodes!C13","v":150},null,null,null,null,null,null,null,null,10,null,{"$f":"nodes!B12","v":75},{"$f":"nodes!C12","v":20},null,null,null,"C",null,null,null,null,null,null,null,"aw","av","au"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PTDF!J11","v":17.822004185330478},null,null,"p","q","s",null,null,null,null,null,null,null,null,null,"t","u","v"]
[null,null,null,null,null,null,null,{"$f":"PTDF!J7","v":2.9610103347789316},null,null,null,null,null,null,null,null,null,{"$f":"PTDF!J8","v":20.28121058522278},null,null,null,null,{"$f":"PTDF!J9","v":69.162472103852792},null,null,null,{"$f":"PTDF!J10","v":24.910783705666475},null,null,null,null,null,null,null,null,null,null,null,{"$f":"PTDF!J12","v":-8.1530046256689914}]
[null,"D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PTDF!J15","v":-54.648349694790781}]
[null,null,null,null,null,"af","m","al",null,null,null,null,null,null,null,null,"al","o","ak",null,null,null,{"$f":"-PTDF!J14","v":23.242220920002143},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ao","as","ax"]
[null,null,null,null,null,28,null,{"$f":"nodes!B30","v":200},{"$f":"nodes!C30","v":100},null,null,null,null,null,null,null,29,null,{"$f":"nodes!B31","v":75},{"$f":"nodes!C31","v":200},null,null,null,null,null,null,"ar","aj","q","am",null,null,null,null,null,null,null,null,null,"an","u","ao",null,null,null,null,null,null,20,null,{"$f":"nodes!B22","v":250},{"$f":"nodes!C22","v":120}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,null,null,{"$f":"nodes!B15","v":50},{"$f":"nodes!C15","v":175},null,null,null,null,null,null,null,null,14,null,{"$f":"nodes!B16","v":80},{"$f":"nodes!C16","v":110}]
[]
[null,null,33,{"$f":"nodes!B35","v":100},{"$f":"nodes!C35","v":35},null,null,null,null,null,null,null,null,null,null,null,null,30,null,{"$f":"nodes!B32","v":100},{"$f":"nodes!C32","v":150},null,null,null,null,null,null,null,null,null,null,15,null,null,{"$f":"nodes!B17","v":180},{"$f":"nodes!C17","v":65}]
[null,null,"ag","af",null,null,null,null,null,null,null,null,null,null,null,null,null,"ak","ai","aj",null,null,null,null,null,null,null,null,null,null,null,"aq","ap","an","am",null,null,null,null,null,null,null,null,null,"E",null,null,null,null,19,null,{"$f":"nodes!B21","v":250},{"$f":"nodes!C21","v":140}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ax","ap","av"]
[null,null,null,null,32,{"$f":"nodes!B34","v":100},{"$f":"nodes!C34","v":40},null,null,null,null,null,null,null,31,{"$f":"nodes!B33","v":25},{"$f":"nodes!C33","v":75},null,null,null,null,null,null,null,null,16,{"$f":"nodes!B18","v":0},{"$f":"nodes!C18","v":120}]
[null,null,null,null,"ag","ah",null,null,null,null,null,null,null,null,"ah","ai",null,null,null,null,null,null,null,null,null,"ar","aq"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PTDF!J16","v":-65.351650305209176}]

{"sheet":"nodes","index":2,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,15,7,15],[2,16,7,16],[2,17,7,17],[8,15,13,15],[8,16,13,16],[8,17,13,17],[14,15,17,15],[14,16,17,16],[14,17,17,17],[18,15,22,15],[18,16,22,16],[18,17,22,17],[23,15,28,15],[23,16,28,16],[23,17,28,17],[29,15,34,15],[29,16,34,16],[29,17,34,17]]}
["Nodes overview",null,null,null,null,null,null,null,null,null,"Reference"]
[null,"generation","load","balance","zone",null,"angle",null,null,null,"node","generation [MW]","load [MW]","balance [MW]","zone","NP [MW]","G [MW]","L [MW]"]
[1,80,30,{"$f":"B3-C3","v":50},"B",null,0.56564081246976061,null,null,null,1,80,30,{"$f":"L3-M3","v":50},"B",{"$f":"SUM(N3:N8)","v":60},{"$f":"SUM(L3:L8)","v":780},{"$f":"SUM(M3:M8)","v":720}]
[2,200,40,{"$f":"B4-C4","v":160},"B",null,0.53365895022112175,null,null,null,2,200,40,{"$f":"L4-M4","v":160},"B"]
[3,0,300,-300,"B",null,-3.9356602759722623,null,null,null,3,0,300,-300,"B"]
[4,250,50,200,"B",null,-0.3786766463194372,null,null,null,4,250,50,200,"B"]
[5,50,200,-150,"B",null,-3.9674086492630143,null,null,null,5,50,200,-150,"B"]
[6,200,100,100,"B",null,-2.1097458519218768,null,null,null,6,200,100,100,"B"]
[7,10,50,-40,"C",null,-4.2250473003231006,null,null,null,7,10,50,-40,"C",{"$f":"SUM(N9:N14)","v":-20},{"$f":"SUM(L9:L14)","v":300},{"$f":"SUM(M9:M14)","v":320}]
[8,5,10,-5,"C",null,-5.0835550084426115,null,null,null,8,5,10,-5,"C"]
[9,5,40,-35,"C",null,-4.475458176896284,null,null,null,9,5,40,-35,"C"]
[10,75,20,55,"C",null,-2.3567484175443756,null,null,null,10,75,20,55,"C"]
[11,75,150,-75,"C",null,-3.5506306874188098,null,null,null,11,75,150,-75,"C"]
[12,130,50,80,"C",null,-2.4524767016397706,null,null,null,12,130,50,80,"C"]
[13,50,175,-125,"E",null,-4.4403015340497554,null,null,null,13,50,175,-125,"E",{"$f":"SUM(N15:N18)","v":-160},{"$f":"SUM(L15:L18)","v":310},{"$f":"SUM(M15:M18)","v":470}]
[14,80,110,-30,"E",null,-2.1529233019026508,null,null,null,14,80,110,-30,"E"]
[15,180,65,115,"E",null,-2.4278457197213572,null,null,null,15,180,65,115,"E"]
[16,0,120,-120,"E",null,-4.9340736268855538,null,null,null,16,0,120,-120,"E"]
[17,100,80,20,"F",null,-2.2136902507809939,null,null,null,17,100,80,20,"F",{"$f":"SUM(N19:N23)","v":120},{"$f":"SUM(L19:L23)","v":770},{"$f":"SUM(M19:M23)","v":650}]
[18,100,200,-100,"F",null,-2.4371726603288222,null,null,null,18,100,200,-100,"F"]
[19,250,140,110,"F",null,-1.6852133298894347,null,null,null,19,250,140,110,"F"]
[20,250,120,130,"F",null,-1.469818930717766,null,null,null,20,250,120,130,"F"]
[21,70,110,-40,"F",null,-2.2178596002783859,null,null,null,21,70,110,-40,"F"]
[22,200,650,-450,"A",null,-6.5316861151219143,null,null,null,22,200,650,-450,"A",{"$f":"SUM(N24:N29)","v":0},{"$f":"SUM(L24:L29)","v":1600},{"$f":"SUM(M24:M29)","v":1600}]
[23,150,400,-250,"A",null,-6.7139657995326107,null,null,null,23,150,400,-250,"A"]
[24,200,100,100,"A",null,-4.1512449030973801,null,null,null,24,200,100,100,"A"]
[25,500,150,350,"A",null,-2.1411446616740575,null,null,null,25,500,150,350,"A"]
[26,300,100,200,"A",null,-4.5933244618614451,null,null,null,26,300,100,200,"A"]
[27,250,200,50,"A",null,-3.9342596395063705,null,null,null,27,250,200,50,"A"]
[28,200,100,100,"D",null,-0.44036436162733161,null,null,null,28,200,100,100,"D",{"$f":"SUM(N30:N35)","v":0},{"$f":"SUM(L30:L35)","v":600},{"$f":"SUM(M30:M35)","v":600}]
[29,75,200,-125,"D",null,-2.7435336827100887,null,null,null,29,75,200,-125,"D"]
[30,100,150,-50,"D",null,-3.8592460110497018,null,null,null,30,100,150,-50,"D"]
[31,25,75,-50,"D",null,-2.6164069151180196,null,null,null,31,25,75,-50,"D"]
[32,100,40,60,"D",null,-0.37213563837267261,null,null,null,32,100,40,60,"D"]
[33,100,35,65,"D",null,0,null,null,null,33,100,35,65,"D"]

{"sheet":"lines","index":3,"n_rows":52,"n_cols":18,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Lines overview",null,null,null,null,null,null,null,"B [S/km]",0.4,null,"Output"]
["line","start node","end node","B","in operation","CB","length [km]",null,"flow",null,null,"Reference","zone A","zone B","zone C","zone D","zone E","zone F"]
["A",1,4,{"$f":"G3*$J$1","v":52},1,0,130,null,49.104507857038286,null,null,49.104507857038286,49.178700595870616,49.597455951049682,49.148714322271459,49.110654938313857,49.136617578297418,49.138364203207672]
["B",1,2,28,1,0,70,null,0.89549214296188806,null,null,0.89549214296188806,0.82129940412944746,0.80254404895036968,0.85128567772870012,0.88934506168630856,0.8633824217029118,0.8616357967925441]
["C",2,3,36,1,0,90,null,160.89549214296184,null,null,160.89549214296184,160.82129940412932,161.20254404895039,160.85128567772861,160.88934506168627,160.86338242170274,160.86163579679237]
["D",3,4,40,1,0,100,null,-142.27934518611301,null,null,-142.27934518611301,-142.03384784516567,-142.10854013755247,-142.13306982496286,-142.25900502706929,-142.17309690209342,-142.16731747168191]
["E",3,5,100,1,0,250,null,3.1748373290751974,null,null,3.1748373290751974,2.8551472492941432,3.3110841865026774,2.9843555026916935,3.1483500887558247,3.0364793237966925,3.0289532684746323]
["F",5,6,52,1,0,130,null,-96.598465461739153,null,null,-96.598465461739153,-96.271327011416091,-96.386532797249799,-96.534739063992816,-96.606284565076265,-96.582268194622543,-96.573836268308881]
["G",5,26,20,1,1,50,null,12.518316251968615,null,null,12.518316251968615,12.305165120632209,12.536572558692898,12.476622960852,12.515287694781376,12.491235846844946,12.488067305016886]
["H",5,25,40,1,1,100,null,-73.050559503558276,null,null,-73.050559503558276,-73.429581246811239,-73.019283739005431,-73.121986302860677,-73.05574787177278,-73.096952259082911,-73.10238044177558]
["I",5,7,40,1,1,100,null,10.305546042403453,null,null,10.305546042403453,10.250890386889626,10.38032816406437,10.164457908692928,10.295094830823199,10.224463930656444,10.217102673541181]
["J",7,12,40,1,0,100,null,-70.902823947333204,null,null,-70.902823947333204,-70.706119141456995,-70.824169388931452,-70.917118994990162,-70.911572197099559,-70.953835511354825,-70.955127462168107]
["K",7,8,48,1,0,120,null,41.208369989736525,null,null,41.208369989736525,40.957009528347001,41.204497552995974,41.18157690368264,41.206667027922592,41.178299442010768,41.172230135708901]
["L",8,24,40,1,1,100,null,-37.292404213809256,null,null,-37.292404213809256,-37.455720474546439,-37.311026920979948,-37.249874146629374,-37.289314874081434,-37.264780310338956,-37.261548176506416]
["M",4,28,48,1,1,120,null,2.9610103347789316,null,null,2.9610103347789316,3.4632930311687442,3.5546852459402469,3.4116638397798891,3.0429222001674683,3.3230664148885278,3.3340481032750784]
["N",4,6,60,1,0,150,null,103.86415233614639,null,null,103.86415233614639,103.68155971953716,103.93423056755748,103.60398065752915,103.80872771107714,103.64045426131523,103.63699862825126]
["O",6,29,32,1,1,80,null,20.28121058522278,null,null,20.28121058522278,20.561897424710367,20.523449483342759,20.553011263446322,20.266574041169562,20.458098429750365,20.469362539279146]
["P",6,11,48,1,1,120,null,69.162472103852792,null,null,69.162472103852792,69.168805652931439,69.214709082041395,68.959950678282325,69.131005115912956,68.96600249722718,68.979395777567959]
["Q",11,13,28,1,1,70,null,24.910783705666475,null,null,24.910783705666475,24.99752889303786,25.000204166992319,25.033207222974696,24.870190311292152,24.700894006917906,24.732697547688986]
["R",6,12,52,1,1,130,null,17.822004185330478,null,null,17.822004185330478,17.67952963047852,17.809539204922594,17.556279651806413,17.804863988916999,17.634085139714649,17.614404043093877]
["S",11,12,28,1,0,70,null,-30.7483116018131,null,null,-30.7483116018131,-30.828723240106186,-30.785495084950441,-30.773256544692003,-30.739185195378536,-30.734891509690016,-30.753301770120501]
["T",10,12,40,1,0,100,null,3.8291313638158009,null,null,3.8291313638158009,3.8553127510854246,3.8001252689597287,3.9340958878756815,3.8458934035611314,4.0546418813305785,4.0940251891944079]
["U",10,14,40,1,1,100,null,-8.1530046256689914,null,null,-8.1530046256689914,-8.0227193489172421,-8.0783388962760583,-7.9978823262016263,-8.1796865526299989,-8.4820588515575324,-8.5361081902440006]
["V",9,10,28,1,0,70,null,-59.323873261853436,null,null,-59.323873261853436,-59.167406597832709,-59.278213627316774,-59.363786438326287,-59.333793149069145,-59.427416970227355,-59.442083001049497]
["W",8,9,40,1,0,100,null,-24.323873261853102,null,null,-24.323873261853102,-24.167406597832475,-24.278213627316241,-24.363786438325725,-24.333793149068832,-24.427416970226723,-24.44208300104922]
["X",8,23,60,1,1,150,null,97.824647465399948,null,null,97.824647465399948,97.580136600726405,97.793738101293442,97.895237488638941,97.829775051073767,97.870496722577812,97.875861313265858]
["Y",23,24,48,1,0,120,null,-123.01060302889107,null,null,-123.01060302889107,-123.01097385003685,-123.00822278621069,-123.0160389668664,-123.01099788975674,-123.014133750469,-123.01454686242039]
["Z",24,25,30,1,0,75,null,-60.303007242699678,null,null,-60.303007242699678,-60.266694324582694,-60.319249707189869,-60.265913113494818,-60.300312763837532,-60.278914060807026,-60.276095038925817]
["AA",22,23,160,1,0,400,null,29.164749505711427,null,null,29.164749505711427,29.208889549239387,29.198039112498293,29.088723544497554,29.159227059171684,29.115369526955703,29.109591824316396]
["AB",22,27,80,1,0,200,null,-207.79411804924351,null,null,-207.79411804924351,-207.77977753575939,-207.80600923996943,-207.76696124890478,-207.79214540758716,-207.77647930844537,-207.77441548821244]
["AC",22,26,140,1,0,350,null,-271.37063145646567,null,null,-271.37063145646567,-271.32911201347747,-271.39202987252861,-271.3217622955911,-271.36708165158268,-271.33889021850968,-271.3351763361037]
["AD",25,26,24,1,0,60,null,58.852315204497302,null,null,58.852315204497302,58.823946892845392,58.855457313834734,58.845139334738803,58.851793956801316,58.84765437166368,58.847109031085608]
["AE",25,27,88,1,0,220,null,157.79411804924354,null,null,157.79411804924354,157.6797775357598,157.80600923996946,157.76696124890429,157.79214540758713,157.77647930844489,157.77441548821207]
["AF",28,33,80,1,0,200,null,-35.229148930186525,null,null,-35.229148930186525,-34.442708070739755,-34.417656545459764,-34.464633136986734,-34.761979087893309,-34.52248938359817,-34.515445157030925]
["AG",32,33,{"$f":"G35*$J$1","v":80},1,0,200,null,-29.770851069813808,null,null,-29.770851069813808,-29.557291929260643,-29.582343454540627,-29.535366863013763,-29.33802091210703,-29.47751061640222,-29.484554842969466]
["AH",31,32,40,1,0,100,null,-89.770851069813887,null,null,-89.770851069813887,-89.557291929260657,-89.58234345454062,-89.53536686301382,-89.538020912107115,-89.477510616402299,-89.484554842969544]
["AI",30,31,32,1,0,80,null,-39.77085106981383,null,null,-39.77085106981383,-39.557291929260714,-39.582343454540649,-39.535366863013792,-39.738020912107046,-39.477510616402242,-39.484554842969487]
["AJ",13,30,40,1,1,100,null,-23.242220920002143,null,null,-23.242220920002143,-23.025190455879336,-23.078134729283324,-22.964675103226444,-23.309496241337495,-22.781164844639381,-22.803410642554685]
["AK",29,30,30,1,0,75,null,33.471369850188395,null,null,33.471369850188395,33.467898526618669,33.495791274742736,33.429308240212862,33.371475329230464,33.303654228237093,33.318855799585101]
["AL",28,29,60,1,0,150,null,138.19015926496544,null,null,138.19015926496544,137.90600110190817,137.97234179139986,137.87629697676613,138.00490128806072,137.84555579848649,137.84949326030582]
["AM",13,15,48,1,0,120,null,-96.597879087763118,null,null,-96.597879087763118,-96.689845165470075,-96.650584308511071,-96.707377181504768,-96.579044786378859,-96.78913492831245,-97.033335395122066]
["AN",14,15,60,1,0,150,null,16.495345069122386,null,null,16.495345069122386,16.582424835617935,16.545249973520761,16.599025346377935,16.477511465607442,16.609601403101443,16.552100791989652]
["AO",14,20,80,1,1,200,null,-54.648349694790781,null,null,-54.648349694790781,-54.605144184535206,-54.623588869795796,-54.596907672578752,-54.657198018236848,-54.591660254658265,-55.088208982232558]
["AP",15,19,88,1,1,220,null,-65.351650305209176,null,null,-65.351650305209176,-65.394855815464993,-65.376411130203991,-65.403092327421206,-65.342801981763088,-65.408339745341635,-65.911791017767428]
["AQ",15,16,40,1,0,100,null,100.24911628656787,null,null,100.24911628656787,100.28743548561253,100.27107679521285,100.29474049229356,100.24126866099115,100.32880622013002,100.43055641463403]
["AR",13,16,40,1,0,100,null,19.750883713431939,null,null,19.750883713431939,19.712564514387481,19.728923204786959,19.705259507706252,19.758731339008762,19.671193779869647,19.56944358536564]
["AS",20,21,80,1,0,200,null,59.84325356484959,null,null,59.84325356484959,59.856198277477191,59.850672103875979,59.858666001610175,59.840602537154979,59.860238169526383,59.597710997907996]
["AT",17,21,80,1,0,200,null,0.33354795979136043,null,null,0.33354795979136043,0.32949698286635964,0.33122636863083699,0.32872472211380455,0.3343775843899266,0.32823272077450838,0.41110039894775241]
["AU",17,18,88,1,0,220,null,19.666452040208888,null,null,19.666452040208888,19.670503017133242,19.668773631369241,19.671275277886501,19.665622415610265,19.671767279225797,19.638899601051939]
["AV",18,19,80,1,0,200,null,-60.156746435150993,null,null,-60.156746435150993,-60.143801722522824,-60.149327896124603,-60.141333998390408,-60.159397462845575,-60.1397618304742,-59.802289002092422]
["AW",18,21,92,1,0,230,null,-20.176801524640137,null,null,-20.176801524640137,-20.185695260342985,-20.181898472506017,-20.187390723723194,-20.174980121544134,-20.188470890299921,-20.058811396855294]
["AX",19,20,72,1,0,180,null,-15.508396740360146,null,null,-15.508396740360146,-15.53865753798822,-15.52573902632877,-15.544426325811591,-15.502199444608658,-15.548101575816466,-15.514080019859895]

{"sheet":"zones","index":4,"n_rows":35,"n_cols":21,"rows_kept":35,"cut":false,"hidden":false,"merged":[[22,0,22,6],[22,14,22,20]]}
["Zones overview"]
["zone","generation [MW]","load [MW]","net position [MW]"]
["A",{"$f":"SUMIF(nodes!O:O,zones!A3,nodes!L:L)","v":1600},{"$f":"SUMIF(nodes!O:O,zones!A3,nodes!M:M)","v":1600},{"$f":"B3-C3","v":0}]
["B",{"$f":"SUMIF(nodes!O:O,zones!A4,nodes!L:L)","v":780},{"$f":"SUMIF(nodes!O:O,zones!A4,nodes!M:M)","v":720},{"$f":"B4-C4","v":60}]
["C",{"$f":"SUMIF(nodes!O:O,zones!A5,nodes!L:L)","v":300},{"$f":"SUMIF(nodes!O:O,zones!A5,nodes!M:M)","v":320},-20]
["D",{"$f":"SUMIF(nodes!O:O,zones!A6,nodes!L:L)","v":600},{"$f":"SUMIF(nodes!O:O,zones!A6,nodes!M:M)","v":600},0]
["E",{"$f":"SUMIF(nodes!O:O,zones!A7,nodes!L:L)","v":310},{"$f":"SUMIF(nodes!O:O,zones!A7,nodes!M:M)","v":470},-160]
["F",{"$f":"SUMIF(nodes!O:O,zones!A8,nodes!L:L)","v":770},{"$f":"SUMIF(nodes!O:O,zones!A8,nodes!M:M)","v":650},120]
[]
[]
[]
[]
["Average - ref."]
[null,"generation","load","balance"]
["A",1600,1600,{"$f":"B15-C15","v":0}]
["B",780,720,{"$f":"B16-C16","v":60}]
["C",300,320,-20]
["D",600,600,0]
["E",310,470,-160]
["F",770,650,120]
[]
["Net Positions"]
["Net Position [MW]",null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Position [MW]"]
[null,"zone A","zone B","zone C","zone D","zone E","zone F",null,"balance check",null,null,null,null,null,null,"zone A","zone B","zone C","zone D","zone E","zone F"]
["reference",{"$f":"D3","v":0},{"$f":"D4","v":60},{"$f":"D5","v":-20},{"$f":"D6","v":0},{"$f":"D7","v":-160},{"$f":"D8","v":120},null,{"$f":"IF(SUM(B25:G25)=0,\"right\",\"wrong\")","v":"right"},null,null,null,null,null,11,0,58,-11,0,1.5,-48.5]
[11,{"$f":"'external data'!B12","v":0},{"$f":"'external data'!B13","v":58},{"$f":"'external data'!B14","v":-11},{"$f":"'external data'!B15","v":0},{"$f":"'external data'!B16","v":1.5},{"$f":"'external data'!B17","v":-48.5},null,{"$f":"IF(SUM(B26:G26)=0,\"right\",\"wrong\")","v":"right"},null,null,null,null,null,22,0,85,-46,0,-40.5,1.5]
[22,{"$f":"'external data'!C12","v":0},{"$f":"'external data'!C13","v":85},{"$f":"'external data'!C14","v":-46},{"$f":"'external data'!C15","v":0},{"$f":"'external data'!C16","v":-40.5},{"$f":"'external data'!C17","v":1.5},null,"right",null,null,null,null,null,33,0,130,-170,0,70,-30]
[33,{"$f":"'external data'!D12","v":0},{"$f":"'external data'!D13","v":130},{"$f":"'external data'!D14","v":-170},{"$f":"'external data'!D15","v":0},{"$f":"'external data'!D16","v":70},{"$f":"'external data'!D17","v":-30},null,"right",null,null,null,null,null,44,0,108,-140,0,30,2]
[44,{"$f":"'external data'!E12","v":0},{"$f":"'external data'!E13","v":108},{"$f":"'external data'!E14","v":-140},{"$f":"'external data'!E15","v":0},{"$f":"'external data'!E16","v":30},{"$f":"'external data'!E17","v":2},null,"right",null,null,null,null,null,55,0,-21.5,68.5,0,3.5,-50.5]
[55,{"$f":"'external data'!F12","v":0},{"$f":"'external data'!F13","v":-21.5},{"$f":"'external data'!F14","v":68.5},{"$f":"'external data'!F15","v":0},{"$f":"'external data'!F16","v":3.5},{"$f":"'external data'!F17","v":-50.5},null,"right",null,null,null,null,null,66,0,-27,65,0,-40,2]
[66,{"$f":"'external data'!G12","v":0},{"$f":"'external data'!G13","v":-27},{"$f":"'external data'!G14","v":65},{"$f":"'external data'!G15","v":0},{"$f":"'external data'!G16","v":-40},{"$f":"'external data'!G17","v":2},null,"right",null,null,null,null,null,77,0,-52,42,0,100,-90]
[77,{"$f":"'external data'!H12","v":0},{"$f":"'external data'!H13","v":-52},{"$f":"'external data'!H14","v":42},{"$f":"'external data'!H15","v":0},{"$f":"'external data'!H16","v":100},{"$f":"'external data'!H17","v":-90},null,"right",null,null,null,null,null,88,0,-62,30,0,30,2]
[88,{"$f":"'external data'!I12","v":0},{"$f":"'external data'!I13","v":-62},{"$f":"'external data'!I14","v":30},{"$f":"'external data'!I15","v":0},{"$f":"'external data'!I16","v":30},{"$f":"'external data'!I17","v":2},null,"right",null,null,null,null,null,"00",0,29,-4,0,-27,2]
["00",{"$f":"'external data'!J12","v":0},{"$f":"'external data'!J13","v":29},{"$f":"'external data'!J14","v":-4},0,{"$f":"'external data'!J16","v":-27},{"$f":"'external data'!J17","v":2},null,"right"]
["AVG",{"$f":"'external data'!K12","v":0},{"$f":"'external data'!K13","v":26},{"$f":"'external data'!K14","v":12},{"$f":"'external data'!K15","v":0},{"$f":"'external data'!K16","v":-7},{"$f":"'external data'!K17","v":-31},null,"right"]

{"sheet":"GSK","index":5,"n_rows":34,"n_cols":19,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,10,1,11],[1,0,1,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[15,0,15,1],[15,2,15,3],[15,4,15,5],[25,0,25,1],[25,2,25,3],[25,4,25,5]]}
["GSK",0]
["zone A",null,"zone B",null,"zone C",null,"zone D",null,"zone E",null,"zone F",null,null,null,null,null,null,"before","after"]
["node","value","node","value","node","value","node","value","node","value","node","value",null,null,null,null,"node","generation [MW]","generation [MW]"]
["sum",{"$f":"SUM(B5:B10)","v":0.99999999999999989},"sum",{"$f":"SUM(D5:D10)","v":1},"sum",{"$f":"SUM(F5:F10)","v":1},"sum",{"$f":"SUM(H5:H10)","v":0.99999999999999989},"sum",{"$f":"SUM(J5:J10)","v":1},"sum",{"$f":"SUM(L5:L10)","v":1},null,null,null,null,"N1",5,5.2]
[22,0.1,1,0.4,7,0.1,28,0.2,13,0.4,17,0.05,null,null,null,null,"N2",10,10.199999999999999]
[23,0.2,2,0.4,8,0.1,29,0.1,14,0.5,18,0.5,null,null,null,null,"N3",3,3]
[24,0.2,3,0,9,0,30,0.2,15,0.1,19,0.2,null,null,null,null,"N4",7,7.3]
[25,0.2,4,0,10,0.3,31,0.2,16,0,20,0.2,null,null,null,null,"N5",5,5.3]
[26,0.2,5,0.2,11,0.3,32,0.2,null,null,21,0.05,null,null,null,null,"NP",{"$f":"SUM(R4:R8)","v":30},{"$f":"SUM(S4:S8)","v":31}]
[27,0.1,6,0,12,0.2,33,0.1]
[]
[]
[]
[]
[]
["zone A",null,"zone B",null,"zone C"]
["hub","value","hub","value","hub","value"]
["sum",{"$f":"SUM(B19:B24)","v":0.99999999999999989},"sum",{"$f":"SUM(D19:D24)","v":1},"sum",{"$f":"SUM(F19:F24)","v":1}]
[22,0.1,1,0.4,7,0.1]
[23,0.2,2,0.4,8,0.1]
[24,0.2,3,0,9,0]
[25,0.2,4,0,10,0.3]
[26,0.2,5,0.2,11,0.3]
[27,0.1,6,0,12,0.2]
[]
["zone D",null,"zone E",null,"zone F"]
["node","value","node","value","node","value"]
["sum",{"$f":"SUM(B29:B34)","v":0.99999999999999989},"sum",{"$f":"SUM(D29:D34)","v":1},"sum",{"$f":"SUM(F29:F34)","v":1}]
[28,0.2,13,0.4,17,0.05]
[29,0.1,14,0.5,18,0.5]
[30,0.2,15,0.1,19,0.2]
[31,0.2,16,0,20,0.2]
[32,0.2,null,null,21,0.05]
[33,0.1]

{"sheet":"b-matrix","index":6,"n_rows":35,"n_cols":34,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["B-Matrix"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33]
[1,80,-28,0,-52,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2,-28,64,-36,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[3,0,-36,176,-40,-100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[4,-52,0,-40,200,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-48,0,0,0,0,0]
[5,0,0,-100,0,252,-52,-40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-40,-20,0,0,0,0,0,0,0]
[6,0,0,0,-60,-52,244,0,0,0,0,-48,-52,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-32,0,0,0,0]
[7,0,0,0,0,-40,0,128,-48,0,0,0,-40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[8,0,0,0,0,0,0,-48,188,-40,0,0,0,0,0,0,0,0,0,0,0,0,0,-60,-40,0,0,0,0,0,0,0,0,0]
[9,0,0,0,0,0,0,0,-40,68,-28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[10,0,0,0,0,0,0,0,0,-28,108,0,-40,0,-40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[11,0,0,0,0,0,-48,0,0,0,0,104,-28,-28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[12,0,0,0,0,0,-52,-40,0,0,-40,-28,160,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[13,0,0,0,0,0,0,0,0,0,0,-28,0,156,0,-48,-40,0,0,0,0,0,0,0,0,0,0,0,0,0,-40,0,0,0]
[14,0,0,0,0,0,0,0,0,0,-40,0,0,0,180,-60,0,0,0,0,-80,0,0,0,0,0,0,0,0,0,0,0,0,0]
[15,0,0,0,0,0,0,0,0,0,0,0,0,-48,-60,236,-40,0,0,-88,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[16,0,0,0,0,0,0,0,0,0,0,0,0,-40,0,-40,80,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[17,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,168,-88,0,0,-80,0,0,0,0,0,0,0,0,0,0,0,0]
[18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-88,260,-80,0,-92,0,0,0,0,0,0,0,0,0,0,0,0]
[19,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-88,0,0,-80,240,-72,0,0,0,0,0,0,0,0,0,0,0,0,0]
[20,0,0,0,0,0,0,0,0,0,0,0,0,0,-80,0,0,0,0,-72,232,-80,0,0,0,0,0,0,0,0,0,0,0,0]
[21,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-80,-92,0,-80,252,0,0,0,0,0,0,0,0,0,0,0,0]
[22,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,380,-160,0,0,-140,-80,0,0,0,0,0,0]
[23,0,0,0,0,0,0,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,-160,268,-48,0,0,0,0,0,0,0,0,0]
[24,0,0,0,0,0,0,0,-40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-48,118,-30,0,0,0,0,0,0,0,0]
[25,0,0,0,0,-40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-30,182,-24,-88,0,0,0,0,0,0]
[26,0,0,0,0,-20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-140,0,0,-24,184,0,0,0,0,0,0,0]
[27,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-80,0,0,-88,0,168,0,0,0,0,0,0]
[28,0,0,0,-48,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,188,-60,0,0,0,-80]
[29,0,0,0,0,0,-32,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-60,122,-30,0,0,0]
[30,0,0,0,0,0,0,0,0,0,0,0,0,-40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-30,102,-32,0,0]
[31,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-32,72,-40,0]
[32,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-40,120,-80]
[33,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-80,0,0,0,-80,160]

{"sheet":"b-inverse","index":7,"n_rows":34,"n_cols":33,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["B-Matrix-inverse"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32]
[1,3.8348553780396047E-2,3.0428279994796782E-2,2.4268067050441801E-2,2.3382547357257182E-2,2.2404598267747843E-2,2.0326702062209479E-2,2.1247728645500639E-2,2.1248124985538873E-2,2.0448063326296926E-2,1.9305118098808423E-2,1.9119963193784079E-2,2.0090383415207563E-2,1.6080847769345631E-2,1.7719791123167343E-2,1.7013393049134511E-2,1.6547120409240078E-2,1.7353523389767991E-2,1.7331117582378298E-2,1.7252361169403513E-2,1.7456926190871431E-2,1.7378169777896652E-2,2.1715669696769489E-2,2.1581163052088043E-2,2.154910515300295E-2,2.1899119404418903E-2,2.1814481459830122E-2,2.1811762400776334E-2,1.0251247273345889E-2,1.3414536904011367E-2,1.2368139996597669E-2,6.7462581799623642E-3,2.2487527266541211E-3]
[2,3.0428279994796779E-2,4.5135263590463701E-2,2.8796250831537987E-2,2.2509134981745352E-2,2.5429052578241764E-2,2.134712112463124E-2,2.3557250861410924E-2,2.3638179926351088E-2,2.2495611777563238E-2,2.086337156500916E-2,2.0259224540238388E-2,2.1588334266651892E-2,1.7065149240580002E-2,1.8995840714578587E-2,1.8163696799656816E-2,1.7614423020118414E-2,1.8564373703576668E-2,1.8537979440959557E-2,1.8445203607860408E-2,1.8686183225554633E-2,1.8593407392455484E-2,2.4362202737565272E-2,2.4153910617752981E-2,2.4104266915964297E-2,2.4646286312586689E-2,2.4515219056119877E-2,2.4511008419719361E-2,1.0143315330838452E-2,1.3775080051230858E-2,1.2961765680388589E-2,7.070054007484684E-3,2.3566846691615607E-3]
[3,2.4268067050441797E-2,2.8796250831537983E-2,3.2318171550168355E-2,2.1829814245236154E-2,2.7781405930848151E-2,2.2140780395403722E-2,2.5353545918230039E-2,2.5497111546982813E-2,2.4088149461881484E-2,2.2075346483165292E-2,2.1145316698591744E-2,2.2753407151108598E-2,1.783071705154007E-2,1.9988323730120668E-2,1.9058377494507502E-2,1.8444547273023793E-2,1.9506146169872306E-2,1.947664977541165E-2,1.9372969948882438E-2,1.9642272030308237E-2,1.9538592203779025E-2,2.6420617324850883E-2,2.6154936502159047E-2,2.6091614953823131E-2,2.6782971685606081E-2,2.6615792742123025E-2,2.661042199000838E-2,1.0059368264443778E-2,1.4055502499068241E-2,1.3423474545559304E-2,7.3218952066687118E-3,2.4406317355562365E-3]
[4,2.3382547357257186E-2,2.2509134981745359E-2,2.1829814245236164E-2,2.385284632868663E-2,2.0776045946712653E-2,1.9777245643982373E-2,2.0004139760010489E-2,1.9961172325101528E-2,1.9345537237153525E-2,1.8466058540084946E-2,1.8506514776462528E-2,1.9283794495199076E-2,1.5550839284834819E-2,1.7032687497022823E-2,1.6393998721930193E-2,1.5972419003382508E-2,1.6701527066947934E-2,1.668126888929608E-2,1.6610061394849801E-2,1.6795018556811245E-2,1.6723811062364972E-2,2.0290613444033302E-2,2.0195837439806925E-2,2.0173248819100688E-2,2.0419875684636248E-2,2.036023813875102E-2,2.0358322236730092E-2,1.0309364473157587E-2,1.3220398286277798E-2,1.2048495397633327E-2,6.5719065805272701E-3,2.1906355268424228E-3]
[5,2.2404598267747846E-2,2.5429052578241764E-2,2.7781405930848158E-2,2.0776045946712653E-2,3.1430397131440642E-2,2.3371911633450353E-2,2.8139974601972734E-2,2.8380702619162746E-2,2.6558507918127236E-2,2.3955372630933638E-2,2.2519830644450636E-2,2.456067845187682E-2,1.9018272570167794E-2,2.1527872108954953E-2,2.0446214053684672E-2,1.9732243311926238E-2,2.0967031898908483E-2,2.0932723450260631E-2,2.0812129253263419E-2,2.1125365389418324E-2,2.1004771192421119E-2,2.9613648128600734E-2,2.9258945445486077E-2,2.9174406701341284E-2,3.0097416820280994E-2,2.9874221110432957E-2,2.986705077662374E-2,9.9291488370561714E-3,1.4490496265405873E-2,1.4139681396191149E-2,7.7125534888315373E-3,2.5708511629438449E-3]
[6,2.0326702062209476E-2,2.1347121124631236E-2,2.2140780395403726E-2,1.977724564398237E-2,2.3371911633450346E-2,2.5644489624115946E-2,2.3535196881312014E-2,2.3314403363066408E-2,2.3009642600561288E-2,2.2574270082696822E-2,2.3437762755591524E-2,2.3963434351068413E-2,1.9129130814072783E-2,2.0880345051820123E-2,2.0125557302823786E-2,1.9627344058448289E-2,2.0488987249208619E-2,2.0465046599388383E-2,2.0380895215270225E-2,2.0599473348129033E-2,2.0515321964010888E-2,2.3337653089699675E-2,2.3330964440156476E-2,2.3329370288041683E-2,2.334677554462504E-2,2.3342566729880242E-2,2.3342431518470111E-2,9.8783339228849208E-3,1.513031644318685E-2,1.4419163424132995E-2,7.8649982313452708E-3,2.6216660771150894E-3]
[7,2.1247728645500643E-2,2.3557250861410924E-2,2.5353545918230046E-2,2.0004139760010486E-2,2.8139974601972741E-2,2.3535196881312018E-2,3.7745771213927796E-2,3.2974380146472901E-2,3.0595196999787626E-2,2.7196363933094343E-2,2.3958653335124508E-2,2.8077237106828728E-2,2.0565994912813114E-2,2.3936307612674682E-2,2.2483675101295265E-2,2.1524835007054193E-2,2.3183116972774354E-2,2.3137041812812269E-2,2.2975087625545509E-2,2.3395753835999407E-2,2.3233799648732657E-2,3.1019902875750644E-2,3.1582181035413888E-2,3.1716192678800853E-2,3.0253028017990589E-2,3.0606840038458285E-2,3.0618206521685863E-2,9.7852586005862888E-3,1.4657165140495308E-2,1.4931077696775508E-2,8.1442241982411876E-3,2.7147413994137288E-3]
[8,2.124812498553888E-2,2.3638179926351085E-2,2.5497111546982816E-2,1.9961172325101532E-2,2.838070261916275E-2,2.3314403363066404E-2,3.2974380146472908E-2,4.1673370974592498E-2,3.6313649154400905E-2,2.8656903696984298E-2,2.3681523578163791E-2,2.7129268680039547E-2,2.086312741645498E-2,2.4824816893737455E-2,2.3117296124247247E-2,2.1990211770351115E-2,2.3939466572206941E-2,2.38853067678679E-2,2.3694935055616127E-2,2.4189414069231672E-2,2.3999042356979902E-2,3.6299345579165587E-2,3.7845384079888349E-2,3.8213862130583885E-2,3.4190748553018575E-2,3.5163589123580918E-2,3.519484237499336E-2,9.7621521272705652E-3,1.4619138805366548E-2,1.5058163300011994E-2,8.2135436181883618E-3,2.7378478727294537E-3]
[9,2.0448063326296929E-2,2.2495611777563228E-2,2.4088149461881495E-2,1.9345537237153522E-2,2.6558507918127236E-2,2.3009642600561285E-2,3.0595196999787615E-2,3.6313649154400884E-2,4.992852371172652E-2,3.3664058793620229E-2,2.4153118299301102E-2,2.7769743495912068E-2,2.2496737157672694E-2,2.817324864865399E-2,2.5726625478241068E-2,2.4111681317956879E-2,2.6904673384860411E-2,2.6827070444639362E-2,2.655429610976235E-2,2.726281095398057E-2,2.6990036619103569E-2,3.2369792636059581E-2,3.3504389808575862E-2,3.3774806201348762E-2,3.0822348492382544E-2,3.1536290713196045E-2,3.1559226656038289E-2,9.6188254157151768E-3,1.4662556512851397E-2,1.5846460213566612E-2,8.643523752854515E-3,2.8811745842848378E-3]
[10,1.930511809880843E-2,2.0863371565009156E-2,2.2075346483165295E-2,1.8466058540084946E-2,2.3955372630933641E-2,2.2574270082696826E-2,2.7196363933094336E-2,2.8656903696984298E-2,3.3664058793620229E-2,4.081713750310012E-2,2.4826825043782981E-2,2.8684707518587111E-2,2.4830465359412284E-2,3.2956722584249053E-2,2.9454238841089383E-2,2.7142352100250823E-2,3.1140683117222498E-2,3.1029589982884298E-2,3.0639097615685527E-2,3.1653377932193277E-2,3.1262885564994521E-2,2.6756145574479563E-2,2.7302969420986596E-2,2.7433297731012878E-2,2.6010348405759644E-2,2.6354435841217647E-2,2.6365489914673905E-2,9.4140729706360463E-3,1.4724581809258317E-2,1.6972598661501779E-2,9.2577810880918789E-3,3.0859270293639592E-3]
[11,1.9119963193784079E-2,2.0259224540238385E-2,2.1145316698591744E-2,1.8506514776462524E-2,2.2519830644450633E-2,2.3437762755591521E-2,2.3958653335124501E-2,2.3681523578163787E-2,2.4153118299301113E-2,2.4826825043782988E-2,3.3807938536326312E-2,2.5730031734151226E-2,2.3949003819761058E-2,2.4395213074552065E-2,2.4202893213426301E-2,2.4075948516593674E-2,2.4295495136166325E-2,2.4289395060410182E-2,2.4267953294127322E-2,2.4323646985780937E-2,2.4302205219498087E-2,2.3211868640529508E-2,2.334698237040788E-2,2.337918496030748E-2,2.3027590947005086E-2,2.3112610898322117E-2,2.3115342229635773E-2,9.4788840820119163E-3,1.4895291635800646E-2,1.6616137548934491E-2,9.0633477539642689E-3,3.0211159179880888E-3]
[12,2.0090383415207563E-2,2.1588334266651889E-2,2.2753407151108598E-2,1.9283794495199069E-2,2.456067845187682E-2,2.3963434351068409E-2,2.8077237106828721E-2,2.7129268680039547E-2,2.7769743495912068E-2,2.8684707518587104E-2,2.5730031734151223E-2,3.2731357873927655E-2,2.1757158251088191E-2,2.5278531979119084E-2,2.3760790921363489E-2,2.275897458622584E-2,2.4491582527321119E-2,2.4443442229297146E-2,2.4274229081742864E-2,2.4713750002701766E-2,2.4544536855147497E-2,2.6090826378802612E-2,2.6389572971972353E-2,2.6460775314120791E-2,2.5683374573666585E-2,2.5871360064336428E-2,2.5877399242778987E-2,9.669096132095269E-3,1.4869465617739245E-2,1.5569971273476079E-2,8.4927116037142262E-3,2.8309038679047412E-3]
[13,1.6080847769345645E-2,1.7065149240580009E-2,1.7830717051540077E-2,1.5550839284834824E-2,1.9018272570167805E-2,1.9129130814072789E-2,2.0565994912813117E-2,2.0863127416454987E-2,2.2496737157672708E-2,2.4830465359412298E-2,2.3949003819761065E-2,2.1757158251088198E-2,3.4403488826756687E-2,2.9537382208954105E-2,3.163471420937914E-2,3.3019101518067917E-2,3.0624849836939042E-2,3.0691373824703456E-2,3.0925205641695385E-2,3.0317841633406239E-2,3.0551673450398175E-2,2.0117280417964727E-2,2.0331851077845811E-2,2.0382991187521262E-2,1.9824633724423689E-2,1.9959651735351025E-2,1.9963989292776568E-2,8.6039008761462747E-3,1.4518217984057134E-2,2.1428545181195476E-2,1.1688297371561173E-2,3.8960991238537229E-3]
[14,1.7719791123167343E-2,1.8995840714578584E-2,1.9988323730120664E-2,1.7032687497022823E-2,2.1527872108954956E-2,2.088034505182013E-2,2.3936307612674682E-2,2.4824816893737445E-2,2.8173248648653997E-2,3.295672258424906E-2,2.4395213074552068E-2,2.5278531979119095E-2,2.9537382208954095E-2,4.3983344944295573E-2,3.775701611480909E-2,3.3647199161881587E-2,4.0754990519777344E-2,4.0557501413242922E-2,3.9863327203774425E-2,4.1666402746433684E-2,4.0972228536965208E-2,2.3491911827050512E-2,2.3875371598688366E-2,2.3966764218669834E-2,2.2968922177216695E-2,2.3210213207713989E-2,2.3217964867613756E-2,9.015723097621435E-3,1.4623115708262241E-2,1.9163522963082092E-2,1.0452830707135688E-2,3.4842769023785613E-3]
[15,1.7013393049134507E-2,1.8163696799656813E-2,1.9058377494507502E-2,1.6393998721930186E-2,2.0446214053684672E-2,2.0125557302823786E-2,2.2483675101295269E-2,2.3117296124247243E-2,2.5726625478241064E-2,2.9454238841089383E-2,2.4202893213426297E-2,2.3760790921363496E-2,3.163471420937914E-2,3.7757016114809083E-2,4.1456609930720478E-2,3.6545662070049806E-2,3.9675257247200876E-2,3.9792602395080728E-2,4.0205070589878378E-2,3.9133709389735392E-2,3.9546177584533056E-2,2.2037417916452404E-2,2.2348085090962411E-2,2.242212854772304E-2,2.1613707976507784E-2,2.1809194460941404E-2,2.1815474614576648E-2,8.8382243308607489E-3,1.4577903925819532E-2,2.0139766180265875E-2,1.0985327007417752E-2,3.6617756691392487E-3]
[16,1.6547120409240074E-2,1.7614423020118411E-2,1.844454727302379E-2,1.5972419003382508E-2,1.9732243311926231E-2,1.9627344058448286E-2,2.1524835007054186E-2,2.1990211770351115E-2,2.4111681317956879E-2,2.7142352100250837E-2,2.4075948516593677E-2,2.2758974586225847E-2,3.3019101518067917E-2,3.3647199161881594E-2,3.6545662070049806E-2,4.7282381794058859E-2,3.5150053542069959E-2,3.524198810989209E-2,3.5565138115786883E-2,3.4725775511570814E-2,3.5048925517465614E-2,2.1077349167208562E-2,2.133996808440411E-2,2.1402559867622149E-2,2.0719170850465731E-2,2.0884423098146209E-2,2.0889731953676608E-2,8.7210626035035092E-3,1.4548060954938328E-2,2.0784155680730675E-2,1.1336812189489461E-2,3.7789373964964858E-3]
[17,1.7353523389767991E-2,1.8564373703576664E-2,1.9506146169872302E-2,1.6701527066947931E-2,2.0967031898908479E-2,2.0488987249208619E-2,2.3183116972774354E-2,2.3939466572206951E-2,2.6904673384860415E-2,3.1140683117222501E-2,2.4295495136166328E-2,2.4491582527321129E-2,3.0624849836939028E-2,4.0754990519777344E-2,3.9675257247200883E-2,3.5150053542069959E-2,5.8355492685638902E-2,5.2420183587080241E-2,4.5932572105646531E-2,4.6371944175487109E-2,5.2384332694053418E-2,2.2737756050780423E-2,2.3083472826594325E-2,2.3165869897291531E-2,2.226624297718649E-2,2.2483784329021234E-2,2.2490773012231218E-2,8.9236899036300339E-3,1.4599673377815758E-2,1.9669705530034807E-2,1.0728930289109897E-2,3.5763100963699655E-3]
[18,1.7331117582378295E-2,1.8537979440959553E-2,1.9476649775411647E-2,1.6681268889296073E-2,2.0932723450260628E-2,2.0465046599388376E-2,2.3137041812812262E-2,2.38853067678679E-2,2.6827070444639358E-2,3.1029589982884302E-2,2.4289395060410179E-2,2.4443442229297153E-2,3.0691373824703442E-2,4.0557501413242915E-2,3.9792602395080728E-2,3.5241988109892083E-2,5.2420183587080248E-2,5.3834062719265795E-2,4.6303847868898025E-2,4.5895131392043868E-2,5.086491654167611E-2,2.2691621850237809E-2,2.303502976229543E-2,2.311687654552189E-2,2.2223257768889542E-2,2.2439346274412266E-2,2.2446288283817287E-2,8.918059929078655E-3,1.4598239333009586E-2,1.9700670390067395E-2,1.0745820212764037E-2,3.5819400709213444E-3]
[19,1.7252361169403513E-2,1.8445203607860405E-2,1.9372969948882438E-2,1.6610061394849801E-2,2.0812129253263419E-2,2.0380895215270228E-2,2.2975087625545506E-2,2.3694935055616123E-2,2.6554296109762347E-2,3.0639097615685534E-2,2.4267953294127322E-2,2.4274229081742871E-2,3.0925205641695368E-2,3.9863327203774411E-2,4.0205070589878371E-2,3.5565138115786862E-2,4.5932572105646545E-2,4.6303847868898032E-2,4.7608882176727013E-2,4.421913445824089E-2,4.5524168766069892E-2,2.2529460135330526E-2,2.2864752391284812E-2,2.2944664914051602E-2,2.2072164761725771E-2,2.2283146512461754E-2,2.2289924463442322E-2,8.898270568530554E-3,1.4593198665515892E-2,1.9809511873081945E-2,1.0805188294408335E-2,3.6017294314694432E-3]
[20,1.7456926190871431E-2,1.8686183225554636E-2,1.9642272030308237E-2,1.6795018556811245E-2,2.1125365389418324E-2,2.0599473348129043E-2,2.339575383599941E-2,2.4189414069231675E-2,2.7262810953980577E-2,3.1653377932193291E-2,2.4323646985780947E-2,2.471375000270179E-2,3.0317841633406239E-2,4.1666402746433698E-2,3.9133709389735406E-2,3.4725775511570814E-2,4.6371944175487123E-2,4.5895131392043889E-2,4.4219134458240904E-2,4.8572435171077635E-2,4.6896438237274671E-2,2.2950665386284572E-2,2.3307037568333727E-2,2.3391974215708416E-2,2.2464619713476904E-2,2.2688865951041602E-2,2.269607003386151E-2,8.9496722361846488E-3,1.4606291494596239E-2,1.9526802700984412E-2,1.0650983291446044E-2,3.5503277638153476E-3]
[21,1.7378169777896656E-2,1.8593407392455488E-2,1.9538592203779029E-2,1.6723811062364972E-2,2.1004771192421119E-2,2.0515321964010888E-2,2.3233799648732657E-2,2.3999042356979909E-2,2.6990036619103572E-2,3.1262885564994521E-2,2.430220521949809E-2,2.4544536855147504E-2,3.0551673450398168E-2,4.0972228536965215E-2,3.9546177584533056E-2,3.5048925517465614E-2,5.2384332694053432E-2,5.0864916541676131E-2,4.5524168766069892E-2,4.6896438237274671E-2,5.405569046166845E-2,2.2788503671377296E-2,2.3136760197323112E-2,2.3219762584238132E-2,2.2313526706313133E-2,2.2532666189091093E-2,2.2539706213486544E-2,8.9298828756365512E-3,1.4601250827102548E-2,1.9635644183998963E-2,1.0710351373090343E-2,3.5701171243634477E-3]
[22,2.1715669696769496E-2,2.4362202737565279E-2,2.6420617324850893E-2,2.0290613444033302E-2,2.9613648128600737E-2,2.3337653089699678E-2,3.1019902875750655E-2,3.6299345579165601E-2,3.2369792636059595E-2,2.6756145574479574E-2,2.3211868640529522E-2,2.6090826378802622E-2,2.0117280417964727E-2,2.3491911827050523E-2,2.2037417916452407E-2,2.1077349167208569E-2,2.2737756050780423E-2,2.2691621850237816E-2,2.2529460135330533E-2,2.2950665386284579E-2,2.2788503671377299E-2,4.4100383772433562E-2,4.1419582496544038E-2,3.8883874390301915E-2,3.827277983516289E-2,4.176561634106863E-2,4.104782932910131E-2,9.8296663791381418E-3,1.4567130566072862E-2,1.4686834914740345E-2,8.011000862585646E-3,2.6703336208618819E-3]
[23,2.1581163052088039E-2,2.4153910617752974E-2,2.6154936502159044E-2,2.0195837439806918E-2,2.9258945445486066E-2,2.3330964440156469E-2,3.1582181035413881E-2,3.7845384079888342E-2,3.3504389808575862E-2,2.7302969420986603E-2,2.3346982370407877E-2,2.6389572971972353E-2,2.0331851077845808E-2,2.3875371598688376E-2,2.2348085090962415E-2,2.1339968084404116E-2,2.3083472826594321E-2,2.3035029762295437E-2,2.2864752391284816E-2,2.3307037568333723E-2,2.3136760197323109E-2,4.1419582496544025E-2,4.4142442806504936E-2,4.0256633914645283E-2,3.7254339467345729E-2,3.9554481552403195E-2,3.9237788528868736E-2,9.8102433907719944E-3,1.4582092672573377E-2,1.4793661350754158E-2,8.0692698276840901E-3,2.6897566092280297E-3]
[24,2.1549105153002953E-2,2.4104266915964297E-2,2.6091614953823138E-2,2.0173248819100684E-2,2.9174406701341277E-2,2.3329370288041679E-2,3.1716192678800853E-2,3.8213862130583878E-2,3.3774806201348768E-2,2.7433297731012874E-2,2.3379184960307477E-2,2.6460775314120784E-2,2.0382991187521259E-2,2.3966764218669837E-2,2.2422128547723044E-2,2.140255986762216E-2,2.3165869897291524E-2,2.3116876545521893E-2,2.2944664914051605E-2,2.3391974215708412E-2,2.3219762584238128E-2,3.8883874390301894E-2,4.0256633914645283E-2,4.7385963725866551E-2,3.7689026884197445E-2,3.7672647792879536E-2,3.8258001887104334E-2,9.805614175594949E-3,1.4585658694916953E-2,1.4819122034227899E-2,8.0831574732152193E-3,2.6943858244050734E-3]
[25,2.189911940441891E-2,2.4646286312586689E-2,2.6782971685606095E-2,2.0419875684636248E-2,3.0097416820281001E-2,2.3346775544625054E-2,3.0253028017990593E-2,3.4190748553018582E-2,3.0822348492382558E-2,2.6010348405759658E-2,2.30275909470051E-2,2.5683374573666595E-2,1.9824633724423685E-2,2.2968922177216692E-2,2.161370797650778E-2,2.0719170850465738E-2,2.2266242977186494E-2,2.2223257768889549E-2,2.2072164761725774E-2,2.2464619713476897E-2,2.2313526706313126E-2,3.8272779835162897E-2,3.7254339467345743E-2,3.7689026884197452E-2,4.3048897859398666E-2,3.8007125336706513E-2,4.0774555943095925E-2,9.8561568290775163E-3,1.454672418340054E-2,1.4541137440073763E-2,7.9315295127675069E-3,2.6438431709225022E-3]
[26,2.1814481459830112E-2,2.4515219056119867E-2,2.6615792742123015E-2,2.036023813875101E-2,2.9874221110432933E-2,2.3342566729880235E-2,3.0606840038458264E-2,3.5163589123580904E-2,3.1536290713196038E-2,2.6354435841217636E-2,2.3112610898322113E-2,2.5871360064336428E-2,1.9959651735351015E-2,2.3210213207713985E-2,2.18091944609414E-2,2.0884423098146209E-2,2.2483784329021227E-2,2.2439346274412263E-2,2.228314651246175E-2,2.2688865951041595E-2,2.2532666189091083E-2,4.1765616341068609E-2,3.9554481552403181E-2,3.7672647792879529E-2,3.8007125336706492E-2,4.5417618032821877E-2,3.9796882957831313E-2,9.8439349658604562E-3,1.4556139048695278E-2,1.460835768776762E-2,7.9681951024187028E-3,2.6560650341395683E-3]
[27,2.1811762400776331E-2,2.4511008419719354E-2,2.6610421990008383E-2,2.0358322236730085E-2,2.9867050776623733E-2,2.3342431518470111E-2,3.0618206521685863E-2,3.5194842374993353E-2,3.1559226656038289E-2,2.6365489914673905E-2,2.3115342229635776E-2,2.587739924277899E-2,1.9963989292776565E-2,2.3217964867613752E-2,2.1815474614576651E-2,2.0889731953676608E-2,2.2490773012231222E-2,2.2446288283817294E-2,2.2289924463442325E-2,2.269607003386151E-2,2.2539706213486544E-2,4.1047829329101317E-2,3.9237788528868743E-2,3.8258001887104341E-2,4.0774555943095925E-2,3.9796882957831327E-2,4.6857067079288967E-2,9.8435423291063848E-3,1.4556441508482596E-2,1.4610517189914993E-2,7.9693730126809068E-3,2.6564576708936359E-3]
[28,1.0251247273345887E-2,1.0143315330838447E-2,1.0059368264443775E-2,1.0309364473157584E-2,9.9291488370561662E-3,9.8783339228849174E-3,9.7852586005862836E-3,9.7621521272705618E-3,9.6188254157151716E-3,9.4140729706360428E-3,9.4788840820119128E-3,9.6690961320952638E-3,8.6039008761462712E-3,9.015723097621435E-3,8.8382243308607472E-3,8.721062603503511E-3,8.9236899036300305E-3,8.9180599290786516E-3,8.8982705685305523E-3,8.949672236184647E-3,8.9298828756365477E-3,9.8296663791381349E-3,9.8102433907719926E-3,9.8056141755949438E-3,9.8561568290775094E-3,9.843934965860451E-3,9.8435423291063813E-3,1.1119443134722599E-2,9.9267635769380771E-3,7.5930627590257236E-3,4.1416705958322135E-3,1.3805568652774046E-3]
[29,1.3414536904011369E-2,1.3775080051230857E-2,1.4055502499068239E-2,1.3220398286277798E-2,1.4490496265405868E-2,1.5130316443186848E-2,1.4657165140495304E-2,1.4619138805366548E-2,1.4662556512851393E-2,1.4724581809258317E-2,1.4895291635800645E-2,1.4869465617739245E-2,1.4518217984057134E-2,1.4623115708262241E-2,1.457790392581953E-2,1.4548060954938333E-2,1.4599673377815757E-2,1.4598239333009589E-2,1.4593198665515896E-2,1.4606291494596236E-2,1.4601250827102546E-2,1.4567130566072856E-2,1.4582092672573379E-2,1.4585658694916952E-2,1.4546724183400535E-2,1.455613904869528E-2,1.4556441508482598E-2,9.9267635769380788E-3,2.0527540578717075E-2,1.4152800326840612E-2,7.7197092691857899E-3,2.5732364230619301E-3]
[30,1.2368139996597671E-2,1.2961765680388589E-2,1.3423474545559306E-2,1.2048495397633328E-2,1.4139681396191147E-2,1.4419163424132995E-2,1.4931077696775508E-2,1.5058163300011994E-2,1.5846460213566612E-2,1.6972598661501779E-2,1.6616137548934495E-2,1.5569971273476082E-2,2.1428545181195479E-2,1.9163522963082092E-2,2.0139766180265879E-2,2.0784155680730679E-2,1.966970553003481E-2,1.9700670390067402E-2,1.9809511873081949E-2,1.9526802700984416E-2,1.9635644183998966E-2,1.4686834914740347E-2,1.4793661350754167E-2,1.4819122034227906E-2,1.4541137440073765E-2,1.4608357687767625E-2,1.4610517189914997E-2,7.5930627590257271E-3,1.4152800326840617E-2,2.6988154825358508E-2,1.4720811722922824E-2,4.9069372409742745E-3]
[31,6.7462581799623642E-3,7.0700540074846848E-3,7.3218952066687109E-3,6.5719065805272692E-3,7.7125534888315339E-3,7.8649982313452691E-3,8.1442241982411841E-3,8.2135436181883601E-3,8.6435237528545133E-3,9.2577810880918789E-3,9.0633477539642671E-3,8.4927116037142262E-3,1.1688297371561169E-2,1.0452830707135687E-2,1.0985327007417752E-2,1.1336812189489459E-2,1.0728930289109895E-2,1.0745820212764039E-2,1.0805188294408337E-2,1.0650983291446047E-2,1.0710351373090345E-2,8.0110008625856443E-3,8.0692698276840901E-3,8.083157473215221E-3,7.9315295127675069E-3,7.9681951024187046E-3,7.9693730126809068E-3,4.1416705958322144E-3,7.7197092691857917E-3,1.4720811722922823E-2,2.5074988212503358E-2,8.3583294041677855E-3]
[32,2.2487527266541216E-3,2.3566846691615616E-3,2.440631735556237E-3,2.1906355268424232E-3,2.5708511629438449E-3,2.6216660771150898E-3,2.7147413994137283E-3,2.7378478727294537E-3,2.8811745842848378E-3,3.0859270293639596E-3,3.0211159179880892E-3,2.8309038679047421E-3,3.8960991238537234E-3,3.4842769023785622E-3,3.6617756691392509E-3,3.7789373964964863E-3,3.576310096369965E-3,3.5819400709213457E-3,3.6017294314694449E-3,3.5503277638153489E-3,3.5701171243634482E-3,2.6703336208618814E-3,2.6897566092280297E-3,2.6943858244050734E-3,2.6438431709225022E-3,2.6560650341395683E-3,2.6564576708936359E-3,1.3805568652774049E-3,2.5732364230619306E-3,4.9069372409742745E-3,8.3583294041677855E-3,1.1119443134722596E-2]

{"sheet":"PTDF","index":8,"n_rows":16,"n_cols":63,"rows_kept":16,"cut":false,"hidden":false,"merged":[[5,44,11,46],[5,48,11,50],[0,22,1,22],[0,23,0,31],[5,37,11,42],[4,38,4,41],[5,36,11,36]]}
["PTDF matrix",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CB","Power Flow [MW]"]
["CB","zone A","zone B","zone C","zone D","zone E","zone F",null,null,"Ref. flow","PTDF flow",11,22,33,44,55,66,77,88,"00","AVG",null,null,11,22,33,44,55,66,77,88,"00","AVG"]
["G",-0.21315113133640651,1.8256306724282467E-2,-4.1693291116615683E-2,-3.0285571872390449E-3,-2.7080405123669493E-2,-3.0248946951729749E-2,null,null,12.518316251968615,{"$f":"SUMPRODUCT($B3:$G3,zones!$B$25:$G$25)","v":2.6322354113688107},{"$f":"SUMPRODUCT($B3:$G3,zones!$B$26:$G$26)","v":2.9439453117645442},{"$f":"SUMPRODUCT($B3:$G3,zones!$B$27:$G$27)","v":4.521060450009351},{"$f":"SUMPRODUCT($B3:$G3,zones!$B$28:$G$28)","v":8.4730194138764148},{"$f":"SUMPRODUCT($B3:$G3,zones!$B$29:$G$29)","v":6.9358318349351578},{"$f":"SUMPRODUCT($B3:$G3,zones!$B$30:$G$30)","v":-1.8157106329307382},{"$f":"SUMPRODUCT($B3:$G3,zones!$B$31:$G$31)","v":-2.1802658930923258},{"$f":"SUMPRODUCT($B3:$G3,zones!$B$32:$G$32)","v":-2.6860814632718188},{"$f":"SUMPRODUCT($B3:$G3,zones!$B$33:$G$33)","v":-3.2555997980175277},{"$f":"SUMPRODUCT($B3:$G3,zones!$B$34:$G$34)","v":1.3668791039062711},{"$f":"SUMPRODUCT($B3:$G3,zones!$B$35:$G$35)","v":1.1016246728012646},null,"G",{"$f":"L3","v":2.9439453117645442},{"$f":"M3","v":4.521060450009351},8.4730194138764148,6.9358318349351578,-1.8157106329307382,-2.1802658930923258,-2.6860814632718188,-3.2555997980175277,1.3668791039062711,{"$f":"U3","v":1.1016246728012646}]
["H",-0.37902174325296301,3.1275764552844976E-2,-7.1426799302400923E-2,-5.188368214504635E-3,-4.6392755524635731E-2,-5.1820938217304047E-2,null,null,-73.050559503558276,{"$f":"SUMPRODUCT($B4:$G4,zones!$B$25:$G$25)","v":4.5094101570839484},{"$f":"SUMPRODUCT($B4:$G4,zones!$B$26:$G$26)","v":5.0434155066437114},{"$f":"SUMPRODUCT($B4:$G4,zones!$B$27:$G$27)","v":7.7452479463240564},{"$f":"SUMPRODUCT($B4:$G4,zones!$B$28:$G$28)","v":14.515540533072624},{"$f":"SUMPRODUCT($B4:$G4,zones!$B$29:$G$29)","v":11.882109931869707},{"$f":"SUMPRODUCT($B4:$G4,zones!$B$30:$G$30)","v":-3.1105819544630009},{"$f":"SUMPRODUCT($B4:$G4,zones!$B$31:$G$31)","v":-3.7351192530320532},{"$f":"SUMPRODUCT($B4:$G4,zones!$B$32:$G$32)","v":-4.6016564403549864},{"$f":"SUMPRODUCT($B4:$G4,zones!$B$33:$G$33)","v":-5.5773259235220962},{"$f":"SUMPRODUCT($B4:$G4,zones!$B$34:$G$34)","v":2.3416668919726646},{"$f":"SUMPRODUCT($B4:$G4,zones!$B$35:$G$35)","v":1.8872466601540339},null,"H",{"$f":"L4","v":5.0434155066437114},7.7452479463240564,14.515540533072624,11.882109931869707,-3.1105819544630009,-3.7351192530320532,-4.6016564403549864,-5.5773259235220962,2.3416668919726646,{"$f":"U4","v":1.8872466601540339}]
["I",-5.4655655513826673E-2,7.47821216609168E-2,-0.1410881337105252,-1.0451211580253528E-2,-8.1082111747008412E-2,-8.8443368862272109E-2,null,null,10.305546042403453,{"$f":"SUMPRODUCT($B5:$G5,zones!$B$25:$G$25)","v":9.6686235899142048},{"$f":"SUMPRODUCT($B5:$G5,zones!$B$26:$G$26)","v":10.057212749348636},{"$f":"SUMPRODUCT($B5:$G5,zones!$B$27:$G$27)","v":15.99769496432252},{"$f":"SUMPRODUCT($B5:$G5,zones!$B$28:$G$28)","v":30.684211790286042},{"$f":"SUMPRODUCT($B5:$G5,zones!$B$29:$G$29)","v":25.219457768717746},{"$f":"SUMPRODUCT($B5:$G5,zones!$B$30:$G$30)","v":-7.0897500384504752},{"$f":"SUMPRODUCT($B5:$G5,zones!$B$31:$G$31)","v":-8.1234482438730993},{"$f":"SUMPRODUCT($B5:$G5,zones!$B$32:$G$32)","v":-9.9626799193060833},{"$f":"SUMPRODUCT($B5:$G5,zones!$B$33:$G$33)","v":-11.478485644427394},{"$f":"SUMPRODUCT($B5:$G5,zones!$B$34:$G$34)","v":4.7453643424533709},{"$f":"SUMPRODUCT($B5:$G5,zones!$B$35:$G$35)","v":3.5605967756170287},null,"I",10.057212749348636,15.99769496432252,30.684211790286042,25.219457768717746,-7.0897500384504752,-8.1234482438730993,-9.9626799193060833,-11.478485644427394,4.7453643424533709,3.5605967756170287,null,null,null,null,null,"Zones"]
["L",-0.16331626073718297,-1.8622707170692365E-2,4.253006717988228E-2,3.0893397278219936E-3,2.7623903470299638E-2,3.0856037302839923E-2,null,null,-37.292404213809256,{"$f":"SUMPRODUCT($B6:$G6,zones!$B$25:$G$25)","v":-2.6850638527463389},{"$f":"SUMPRODUCT($B6:$G6,zones!$B$26:$G$26)","v":-3.0030297088611491},{"$f":"SUMPRODUCT($B6:$G6,zones!$B$27:$G$27)","v":-4.6117972343763114},{"$f":"SUMPRODUCT($B6:$G6,zones!$B$28:$G$28)","v":-8.6430712289342182},{"$f":"SUMPRODUCT($B6:$G6,zones!$B$29:$G$29)","v":-7.0750326009036257},{"$f":"SUMPRODUCT($B6:$G6,zones!$B$30:$G$30)","v":1.8521515843444547},{"$f":"SUMPRODUCT($B6:$G6,zones!$B$31:$G$31)","v":2.2240233960947364},{"$f":"SUMPRODUCT($B6:$G6,zones!$B$32:$G$32)","v":2.7399905842054295},{"$f":"SUMPRODUCT($B6:$G6,zones!$B$33:$G$33)","v":3.320939038694064},{"$f":"SUMPRODUCT($B6:$G6,zones!$B$34:$G$34)","v":-1.3943120957620181},{"$f":"SUMPRODUCT($B6:$G6,zones!$B$35:$G$35)","v":-1.1237340609595492},null,"L",-3.0030297088611491,-4.6117972343763114,-8.6430712289342182,-7.0750326009036257,1.8521515843444547,2.2240233960947364,2.7399905842054295,3.320939038694064,-1.3943120957620181,-1.1237340609595492,null,null,null,"Critical Branches","PTDF",null,null,null,null,null,null,"Net Positions ",null,null,null,"Power flow on CBs",null,null,null,null,null,"Zone"]
["M",0.5022826963898126,0.59367491116131532,0.45065350500095747,8.1911865388536675E-2,0.36205608010959622,0.37303776849614678,null,null,2.9610103347789316,{"$f":"SUMPRODUCT($B7:$G7,zones!$B$25:$G$25)","v":13.442983971661988},{"$f":"SUMPRODUCT($B7:$G7,zones!$B$26:$G$26)","v":11.926708640447032},{"$f":"SUMPRODUCT($B7:$G7,zones!$B$27:$G$27)","v":15.628591626973332},{"$f":"SUMPRODUCT($B7:$G7,zones!$B$28:$G$28)","v":14.719435153595555},{"$f":"SUMPRODUCT($B7:$G7,zones!$B$29:$G$29)","v":12.63315764556819},{"$f":"SUMPRODUCT($B7:$G7,zones!$B$30:$G$30)","v":0.53454347392548129},{"$f":"SUMPRODUCT($B7:$G7,zones!$B$31:$G$31)","v":-0.47291244368483376},{"$f":"SUMPRODUCT($B7:$G7,zones!$B$32:$G$32)","v":-9.3114393240417712},{"$f":"SUMPRODUCT($B7:$G7,zones!$B$33:$G$33)","v":-11.680481401692646},{"$f":"SUMPRODUCT($B7:$G7,zones!$B$34:$G$34)","v":6.38451977770751},{"$f":"SUMPRODUCT($B7:$G7,zones!$B$35:$G$35)","v":6.7448263660579642},null,"M",11.926708640447032,15.628591626973332,14.719435153595555,12.63315764556819,0.53454347392548129,-0.47291244368483376,-9.3114393240417712,-11.680481401692646,6.38451977770751,6.7448263660579642,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line","A","B","C",null,"NP1","NP2",null,"PF1","PF2"]
["O",0.28068683948758633,0.24223889811997878,0.27180067822354204,-1.4636544053217904E-2,0.17688784452758455,0.18815195405636587,null,null,20.28121058522278,{"$f":"SUMPRODUCT($B8:$G8,zones!$B$25:$G$25)","v":3.3744996850782627},{"$f":"SUMPRODUCT($B8:$G8,zones!$B$26:$G$26)","v":2.2000106255574394},{"$f":"SUMPRODUCT($B8:$G8,zones!$B$27:$G$27)","v":1.2057453696326377},{"$f":"SUMPRODUCT($B8:$G8,zones!$B$28:$G$28)","v":-7.9774680471649617},{"$f":"SUMPRODUCT($B8:$G8,zones!$B$29:$G$29)","v":-6.2073547103979081},{"$f":"SUMPRODUCT($B8:$G8,zones!$B$30:$G$30)","v":4.5276439247331552},{"$f":"SUMPRODUCT($B8:$G8,zones!$B$31:$G$31)","v":4.427383962300155},{"$f":"SUMPRODUCT($B8:$G8,zones!$B$32:$G$32)","v":-0.42568562916460451},{"$f":"SUMPRODUCT($B8:$G8,zones!$B$33:$G$33)","v":-1.1818520927921554},{"$f":"SUMPRODUCT($B8:$G8,zones!$B$34:$G$34)","v":1.5380574384531656},{"$f":"SUMPRODUCT($B8:$G8,zones!$B$35:$G$35)","v":2.4888940023615191},null,"O",2.2000106255574394,1.2057453696326377,-7.9774680471649617,-6.2073547103979081,4.5276439247331552,4.427383962300155,-0.42568562916460451,-1.1818520927921554,1.5380574384531656,2.4888940023615191,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A-B",{"$f":"1/3","v":0.33333333333333331},{"$f":"-1/3","v":-0.33333333333333331},0,null,2000,1000,null,{"$f":"MMULT(BC8:BE10,BG8:BG10)","v":1000},{"$f":"MMULT(BC8:BE10,BH8:BH10)","v":0}]
["P",6.3335490786471382E-3,5.2236978188602734E-2,-0.20252142557046682,-3.1466987939836599E-2,-0.19646960662561241,-0.18307632628483361,null,null,69.162472103852792,{"$f":"SUMPRODUCT($B9:$G9,zones!$B$25:$G$25)","v":16.650625108643453},{"$f":"SUMPRODUCT($B9:$G9,zones!$B$26:$G$26)","v":13.841977831090105},{"$f":"SUMPRODUCT($B9:$G9,zones!$B$27:$G$27)","v":21.438533301182758},{"$f":"SUMPRODUCT($B9:$G9,zones!$B$28:$G$28)","v":32.958866836249854},{"$f":"SUMPRODUCT($B9:$G9,zones!$B$29:$G$29)","v":27.73435237289641},{"$f":"SUMPRODUCT($B9:$G9,zones!$B$30:$G$30)","v":-6.4381018284374818},{"$f":"SUMPRODUCT($B9:$G9,zones!$B$31:$G$31)","v":-7.0816594607177876},{"$f":"SUMPRODUCT($B9:$G9,zones!$B$32:$G$32)","v":-14.392314036693165},{"$f":"SUMPRODUCT($B9:$G9,zones!$B$33:$G$33)","v":-15.574576266145414},{"$f":"SUMPRODUCT($B9:$G9,zones!$B$34:$G$34)","v":7.2634847960732145},{"$f":"SUMPRODUCT($B9:$G9,zones!$B$35:$G$35)","v":5.9785576872671982},null,"P",13.841977831090105,21.438533301182758,32.958866836249854,27.73435237289641,-6.4381018284374818,-7.0816594607177876,-14.392314036693165,-15.574576266145414,7.2634847960732145,5.9785576872671982,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,"=",null,null,null,null,null,"A-C",{"$f":"2/3","v":0.66666666666666663},{"$f":"1/3","v":0.33333333333333331},0,"x",-1000,1000,"=",1000,1000]
["Q",8.6745187371384702E-2,8.9420461325843803E-2,0.12242351730822065,-4.0593394374322855E-2,-0.20988969874856878,-0.17808615797748928,null,null,24.910783705666475,{"$f":"SUMPRODUCT($B10:$G10,zones!$B$25:$G$25)","v":15.128770175858506},{"$f":"SUMPRODUCT($B10:$G10,zones!$B$26:$G$26)","v":12.16207218029389},{"$f":"SUMPRODUCT($B10:$G10,zones!$B$27:$G$27)","v":10.202660978869375},{"$f":"SUMPRODUCT($B10:$G10,zones!$B$28:$G$28)","v":-18.537032143112953},{"$f":"SUMPRODUCT($B10:$G10,zones!$B$29:$G$29)","v":-14.134745878371803},{"$f":"SUMPRODUCT($B10:$G10,zones!$B$30:$G$30)","v":14.722208049350691},{"$f":"SUMPRODUCT($B10:$G10,zones!$B$31:$G$31)","v":13.582591803224332},{"$f":"SUMPRODUCT($B10:$G10,zones!$B$32:$G$32)","v":-4.4692919188814528},{"$f":"SUMPRODUCT($B10:$G10,zones!$B$33:$G$33)","v":-8.524226361367738},{"$f":"SUMPRODUCT($B10:$G10,zones!$B$34:$G$34)","v":7.4143488594729661},{"$f":"SUMPRODUCT($B10:$G10,zones!$B$35:$G$35)","v":10.783912990712736},null,"Q",12.16207218029389,10.202660978869375,-18.537032143112953,-14.134745878371803,14.722208049350691,13.582591803224332,-4.4692919188814528,-8.524226361367738,7.4143488594729661,10.783912990712736,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B-C",{"$f":"1/3","v":0.33333333333333331},{"$f":"2/3","v":0.66666666666666663},0,null,-1000,-2000,null,0,1000]
["R",-0.14247455485195815,-1.2464980407884241E-2,-0.26572453352406455,-1.7140196413478748E-2,-0.1879190456158284,-0.2076001422366005,null,null,17.822004185330478,{"$f":"SUMPRODUCT($B11:$G11,zones!$B$25:$G$25)","v":9.7216220761487193},{"$f":"SUMPRODUCT($B11:$G11,zones!$B$26:$G$26)","v":11.986729335158806},{"$f":"SUMPRODUCT($B11:$G11,zones!$B$27:$G$27)","v":18.463126341522958},{"$f":"SUMPRODUCT($B11:$G11,zones!$B$28:$G$28)","v":36.62639432005605},{"$f":"SUMPRODUCT($B11:$G11,zones!$B$29:$G$29)","v":29.802445156369487},{"$f":"SUMPRODUCT($B11:$G11,zones!$B$30:$G$30)","v":-8.1080429443359847},{"$f":"SUMPRODUCT($B11:$G11,zones!$B$31:$G$31)","v":-9.8339786678913867},{"$f":"SUMPRODUCT($B11:$G11,zones!$B$32:$G$32)","v":-10.620143187089525},{"$f":"SUMPRODUCT($B11:$G11,zones!$B$33:$G$33)","v":-13.251678873381167},{"$f":"SUMPRODUCT($B11:$G11,zones!$B$34:$G$34)","v":5.3600276494217809},{"$f":"SUMPRODUCT($B11:$G11,zones!$B$35:$G$35)","v":4.2382538357516495},null,"R",11.986729335158806,18.463126341522958,36.62639432005605,29.802445156369487,-8.1080429443359847,-9.8339786678913867,-10.620143187089525,-13.251678873381167,5.3600276494217809,4.2382538357516495]
["U",0.13028527675174928,7.4665729392933144E-2,0.15512229946736511,-2.6681926961007463E-2,-0.32905422588854094,-0.38310356457500916,null,null,-8.1530046256689914,{"$f":"SUMPRODUCT($B12:$G12,zones!$B$25:$G$25)","v":8.053746167394138},{"$f":"SUMPRODUCT($B12:$G12,zones!$B$26:$G$26)","v":20.711208553704239},{"$f":"SUMPRODUCT($B12:$G12,zones!$B$27:$G$27)","v":11.963002024523917},{"$f":"SUMPRODUCT($B12:$G12,zones!$B$28:$G$28)","v":-28.204934963318351},{"$f":"SUMPRODUCT($B12:$G12,zones!$B$29:$G$29)","v":-24.291057056800582},{"$f":"SUMPRODUCT($B12:$G12,zones!$B$30:$G$30)","v":27.215604551994517},{"$f":"SUMPRODUCT($B12:$G12,zones!$B$31:$G$31)","v":20.462936678161157},{"$f":"SUMPRODUCT($B12:$G12,zones!$B$32:$G$32)","v":4.2064168720935413},{"$f":"SUMPRODUCT($B12:$G12,zones!$B$33:$G$33)","v":-10.613440144147148},{"$f":"SUMPRODUCT($B12:$G12,zones!$B$34:$G$34)","v":9.6630739243661878},{"$f":"SUMPRODUCT($B12:$G12,zones!$B$35:$G$35)","v":17.982366640869714},null,"U",20.711208553704239,11.963002024523917,-28.204934963318351,-24.291057056800582,27.215604551994517,20.462936678161157,4.2064168720935413,-10.613440144147148,9.6630739243661878,17.982366640869714]
["X",-0.24451086467354344,-3.0909364106506132E-2,7.0590023238992217E-2,5.1275856738186576E-3,4.5849257177863478E-2,5.1213847865909656E-2,null,null,97.824647465399948,{"$f":"SUMPRODUCT($B13:$G13,zones!$B$25:$G$25)","v":-4.45658171571921},{"$f":"SUMPRODUCT($B13:$G13,zones!$B$26:$G$26)","v":-4.9843311095360932},{"$f":"SUMPRODUCT($B13:$G13,zones!$B$27:$G$27)","v":-7.6545111619512696},{"$f":"SUMPRODUCT($B13:$G13,zones!$B$28:$G$28)","v":-14.34548871800132},{"$f":"SUMPRODUCT($B13:$G13,zones!$B$29:$G$29)","v":-11.742909165893849},{"$f":"SUMPRODUCT($B13:$G13,zones!$B$30:$G$30)","v":3.0741410030549332},{"$f":"SUMPRODUCT($B13:$G13,zones!$B$31:$G$31)","v":3.6913617500274398},{"$f":"SUMPRODUCT($B13:$G13,zones!$B$32:$G$32)","v":4.5477473194304707},{"$f":"SUMPRODUCT($B13:$G13,zones!$B$33:$G$33)","v":5.5119866828408703},{"$f":"SUMPRODUCT($B13:$G13,zones!$B$34:$G$34)","v":-2.3142339001151413},{"$f":"SUMPRODUCT($B13:$G13,zones!$B$35:$G$35)","v":-1.8651372719894965},null,"X",-4.9843311095360932,-7.6545111619512696,-14.34548871800132,-11.742909165893849,3.0741410030549332,3.6913617500274398,4.5477473194304707,5.5119866828408703,-2.3142339001151413,-1.8651372719894965]
["AJ",0.21703046412280713,0.16408619071881958,0.27754581677569945,-6.7275321335351634E-2,0.46105607536276239,0.43881027744745893,null,null,-23.242220920002143,{"$f":"SUMPRODUCT($B14:$G14,zones!$B$25:$G$25)","v":-16.817483656731724},{"$f":"SUMPRODUCT($B14:$G14,zones!$B$26:$G$26)","v":-14.126719265998773},{"$f":"SUMPRODUCT($B14:$G14,zones!$B$27:$G$27)","v":-16.834336996603199},{"$f":"SUMPRODUCT($B14:$G14,zones!$B$28:$G$28)","v":-6.741967106452762},{"$f":"SUMPRODUCT($B14:$G14,zones!$B$29:$G$29)","v":-6.4258029351876189},{"$f":"SUMPRODUCT($B14:$G14,zones!$B$30:$G$30)","v":-5.0621873986462163},{"$f":"SUMPRODUCT($B14:$G14,zones!$B$31:$G$31)","v":-3.954471518603242},{"$f":"SUMPRODUCT($B14:$G14,zones!$B$32:$G$32)","v":9.7371249532056936},{"$f":"SUMPRODUCT($B14:$G14,zones!$B$33:$G$33)","v":12.862333494481959},{"$f":"SUMPRODUCT($B14:$G14,zones!$B$34:$G$34)","v":-7.9225772161566965},{"$f":"SUMPRODUCT($B14:$G14,zones!$B$35:$G$35)","v":-9.233720368412861},null,"AJ",-14.126719265998773,-16.834336996603199,-6.741967106452762,-6.4258029351876189,-5.0621873986462163,-3.954471518603242,9.7371249532056936,12.862333494481959,-7.9225772161566965,-9.233720368412861]
["AO",4.3205510255575064E-2,2.4760824994984887E-2,5.1442022212029315E-2,-8.8483234460667859E-3,5.6689440132515756E-2,-0.43985928744177727,null,null,-54.648349694790781,{"$f":"SUMPRODUCT($B15:$G15,zones!$B$25:$G$25)","v":-61.396615858757286},{"$f":"SUMPRODUCT($B15:$G15,zones!$B$26:$G$26)","v":22.288475206501772},{"$f":"SUMPRODUCT($B15:$G15,zones!$B$27:$G$27)","v":-3.2173741537091871},{"$f":"SUMPRODUCT($B15:$G15,zones!$B$28:$G$28)","v":11.637802905832473},{"$f":"SUMPRODUCT($B15:$G15,zones!$B$29:$G$29)","v":-3.7067493811338181},{"$f":"SUMPRODUCT($B15:$G15,zones!$B$30:$G$30)","v":25.40272784040539},{"$f":"SUMPRODUCT($B15:$G15,zones!$B$31:$G$31)","v":-0.47210701126687127},{"$f":"SUMPRODUCT($B15:$G15,zones!$B$32:$G$32)","v":46.129281916177547},{"$f":"SUMPRODUCT($B15:$G15,zones!$B$33:$G$33)","v":0.8290541457637346},{"$f":"SUMPRODUCT($B15:$G15,zones!$B$34:$G$34)","v":-1.8980376224550355},{"$f":"SUMPRODUCT($B15:$G15,zones!$B$35:$G$35)","v":14.499897546181444},null,"AO",22.288475206501772,-3.2173741537091871,11.637802905832473,-3.7067493811338181,25.40272784040539,-0.47210701126687127,46.129281916177547,0.8290541457637346,-1.8980376224550355,14.499897546181444]
["AP",-4.3205510255816648E-2,-2.4760824994814357E-2,-5.1442022212029315E-2,8.8483234460881022E-3,-5.6689440132458913E-2,-0.56014071255825115,null,null,-65.351650305209176,{"$f":"SUMPRODUCT($B16:$G16,zones!$B$25:$G$25)","v":-58.603384141244987},{"$f":"SUMPRODUCT($B16:$G16,zones!$B$26:$G$26)","v":26.211524793509582},{"$f":"SUMPRODUCT($B16:$G16,zones!$B$27:$G$27)","v":1.7173741537213374},{"$f":"SUMPRODUCT($B16:$G16,zones!$B$28:$G$28)","v":18.362197094194528},{"$f":"SUMPRODUCT($B16:$G16,zones!$B$29:$G$29)","v":1.7067493811538839},{"$f":"SUMPRODUCT($B16:$G16,zones!$B$30:$G$30)","v":25.097272159592578},{"$f":"SUMPRODUCT($B16:$G16,zones!$B$31:$G$31)","v":-1.5278929887400636},{"$f":"SUMPRODUCT($B16:$G16,zones!$B$32:$G$32)","v":43.870718083821828},{"$f":"SUMPRODUCT($B16:$G16,zones!$B$33:$G$33)","v":-2.829054145772659},{"$f":"SUMPRODUCT($B16:$G16,zones!$B$34:$G$34)","v":-0.10196237754161075},{"$f":"SUMPRODUCT($B16:$G16,zones!$B$35:$G$35)","v":16.500102453823473},null,"AP",26.211524793509582,1.7173741537213374,18.362197094194528,1.7067493811538839,25.097272159592578,-1.5278929887400636,43.870718083821828,-2.829054145772659,-0.10196237754161075,16.500102453823473]

{"sheet":"AAF + CP","index":9,"n_rows":38,"n_cols":27,"rows_kept":38,"cut":false,"hidden":false,"merged":[[10,14,10,16],[19,0,19,11],[11,0,11,11],[25,14,25,25]]}
["AAF"]
[null,null,null,"physical flow",null,null,null,null,null,null,null,null,null,null,null,null,null,"absolute physical flow"]
["start","end","type",11,22,33,44,55,66,77,88,"00","AVG",null,"start","end","type",11,22,33,44,55,66,77,88,"00","AVG"]
["A","B","ext",{"$f":"-PTDF!L3-PTDF!L4","v":-7.9873608184082556},{"$f":"-PTDF!M3-PTDF!M4","v":-12.266308396333407},{"$f":"-PTDF!N3-PTDF!N4","v":-22.988559946949039},{"$f":"-PTDF!O3-PTDF!O4","v":-18.817941766804864},{"$f":"-PTDF!P3-PTDF!P4","v":4.9262925873937391},{"$f":"-PTDF!Q3-PTDF!Q4","v":5.9153851461243789},{"$f":"-PTDF!R3-PTDF!R4","v":7.2877379036268053},{"$f":"-PTDF!S3-PTDF!S4","v":8.832925721539624},{"$f":"-PTDF!T3-PTDF!T4","v":-3.7085459958789357},{"$f":"-PTDF!U3-PTDF!U4","v":-2.9888713329552985},null,"A","B","ext",{"$f":"ABS(D4)","v":7.9873608184082556},{"$f":"ABS(E4)","v":12.266308396333407},22.988559946949039,18.817941766804864,4.9262925873937391,5.9153851461243789,{"$f":"ABS(J4)","v":7.2877379036268053},{"$f":"ABS(K4)","v":8.832925721539624},{"$f":"ABS(L4)","v":3.7085459958789357},2.9888713329552985]
["A","C","ext",{"$f":"-PTDF!L6-PTDF!L13","v":7.9873608183972422},{"$f":"-PTDF!M6-PTDF!M13","v":12.266308396327581},{"$f":"-PTDF!N6-PTDF!N13","v":22.988559946935538},{"$f":"-PTDF!O6-PTDF!O13","v":18.817941766797475},{"$f":"-PTDF!P6-PTDF!P13","v":-4.9262925873993879},{"$f":"-PTDF!Q6-PTDF!Q13","v":-5.9153851461221763},{"$f":"-PTDF!R6-PTDF!R13","v":-7.2877379036359002},{"$f":"-PTDF!S6-PTDF!S13","v":-8.8329257215349344},{"$f":"-PTDF!T6-PTDF!T13","v":3.7085459958771594},{"$f":"-PTDF!U6-PTDF!U13","v":2.9888713329490457},null,"A","C","ext",{"$f":"ABS(D5)","v":7.9873608183972422},{"$f":"ABS(E5)","v":12.266308396327581},{"$f":"ABS(F5)","v":22.988559946935538},{"$f":"ABS(G5)","v":18.817941766797475},{"$f":"ABS(H5)","v":4.9262925873993879},{"$f":"ABS(I5)","v":5.9153851461221763},{"$f":"ABS(J5)","v":7.2877379036359002},{"$f":"ABS(K5)","v":8.8329257215349344},{"$f":"ABS(L5)","v":3.7085459958771594},2.9888713329490457]
["B","C","int",{"$f":"PTDF!L5+PTDF!L11+PTDF!L9","v":35.885919915597547},{"$f":"PTDF!M5+PTDF!M11+PTDF!M9","v":55.899354607028236},{"$f":"PTDF!N5+PTDF!N11+PTDF!N9","v":100.26947294659195},{"$f":"PTDF!O5+PTDF!O11+PTDF!O9","v":82.756255297983643},{"$f":"PTDF!P5+PTDF!P11+PTDF!P9","v":-21.635894811223942},{"$f":"PTDF!Q5+PTDF!Q11+PTDF!Q9","v":-25.039086372482274},{"$f":"PTDF!R5+PTDF!R11+PTDF!R9","v":-34.975137143088773},{"$f":"PTDF!S5+PTDF!S11+PTDF!S9","v":-40.304740783953974},{"$f":"PTDF!T5+PTDF!T11+PTDF!T9","v":17.368876787948366},{"$f":"PTDF!U5+PTDF!U11+PTDF!U9","v":13.777408298635876},null,"B","C","int",35.885919915597547,55.899354607028236,100.26947294659195,82.756255297983643,21.635894811223942,25.039086372482274,34.975137143088773,40.304740783953974,17.368876787948366,13.777408298635876]
["B","D","ext",{"$f":"PTDF!L7+PTDF!L8","v":14.126719266004471},{"$f":"PTDF!M7+PTDF!M8","v":16.83433699660597},{"$f":"PTDF!N7+PTDF!N8","v":6.741967106430593},{"$f":"PTDF!O7+PTDF!O8","v":6.4258029351702817},{"$f":"PTDF!P7+PTDF!P8","v":5.0621873986586365},{"$f":"PTDF!Q7+PTDF!Q8","v":3.9544715186153212},{"$f":"PTDF!R7+PTDF!R8","v":-9.7371249532063757},{"$f":"PTDF!S7+PTDF!S8","v":-12.862333494484801},{"$f":"PTDF!T7+PTDF!T8","v":7.9225772161606756},{"$f":"PTDF!U7+PTDF!U8","v":9.2337203684194833},null,"B","D","ext",14.126719266004471,16.83433699660597,6.741967106430593,6.4258029351702817,5.0621873986586365,3.9544715186153212,9.7371249532063757,12.862333494484801,7.9225772161606756,9.2337203684194833]
["C","E","int",{"$f":"PTDF!L12+PTDF!L10","v":32.873280733998129},{"$f":"PTDF!M12+PTDF!M10","v":22.165663003393291},{"$f":"PTDF!N12+PTDF!N10","v":-46.741967106431304},{"$f":"PTDF!O12+PTDF!O10","v":-38.425802935172385},{"$f":"PTDF!P12+PTDF!P10","v":41.937812601345207},{"$f":"PTDF!Q12+PTDF!Q10","v":34.045528481385489},{"$f":"PTDF!R12+PTDF!R10","v":-0.26287504678791151},{"$f":"PTDF!S12+PTDF!S10","v":-19.137666505514886},{"$f":"PTDF!T12+PTDF!T10","v":17.077422783839154},{"$f":"PTDF!U12+PTDF!U10","v":28.766279631582449},null,"C","E","int",32.873280733998129,22.165663003393291,46.741967106431304,38.425802935172385,41.937812601345207,34.045528481385489,0.26287504678791151,19.137666505514886,17.077422783839154,28.766279631582449]
["D","E","ext",{"$f":"-PTDF!L14","v":14.126719265998773},{"$f":"-PTDF!M14","v":16.834336996603199},{"$f":"-PTDF!N14","v":6.741967106452762},{"$f":"-PTDF!O14","v":6.4258029351876189},{"$f":"-PTDF!P14","v":5.0621873986462163},{"$f":"-PTDF!Q14","v":3.954471518603242},{"$f":"-PTDF!R14","v":-9.7371249532056936},{"$f":"-PTDF!S14","v":-12.862333494481959},{"$f":"-PTDF!T14","v":7.9225772161566965},{"$f":"-PTDF!U14","v":9.233720368412861},null,"D","E","ext",14.126719265998773,16.834336996603199,6.741967106452762,6.4258029351876189,5.0621873986462163,3.954471518603242,9.7371249532056936,12.862333494481959,7.9225772161566965,9.233720368412861]
["E","F","int",{"$f":"PTDF!L15+PTDF!L16","v":48.500000000011354},{"$f":"PTDF!M15+PTDF!M16","v":-1.4999999999878497},{"$f":"PTDF!N15+PTDF!N16","v":30.000000000027001},{"$f":"PTDF!O15+PTDF!O16","v":-1.9999999999799343},{"$f":"PTDF!P15+PTDF!P16","v":50.499999999997968},{"$f":"PTDF!Q15+PTDF!Q16","v":-2.0000000000069349},{"$f":"PTDF!R15+PTDF!R16","v":89.999999999999375},{"$f":"PTDF!S15+PTDF!S16","v":-2.0000000000089244},{"$f":"PTDF!T15+PTDF!T16","v":-1.9999999999966462},{"$f":"PTDF!U15+PTDF!U16","v":31.000000000004917},null,"E","F","int",48.500000000011354,1.4999999999878497,30.000000000027001,1.9999999999799343,50.499999999997968,2.0000000000069349,89.999999999999375,2.0000000000089244,1.9999999999966462,31.000000000004917]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sum",null,null,{"$f":"SUM(R4:R10)","v":161.48736081841577},{"$f":"SUM(S4:S10)","v":137.7663083962795},236.47249415981818,173.6695476370962,134.05066738466508,80.824328183339816,159.28773790355083,104.8329257215191,59.708545995857634,{"$f":"SUM(AA4:AA10)","v":97.988871332959931}]
["Physical flow [MW]"]
["start","end","type",11,22,33,44,55,66,77,88,"00","AVG",null,null,null,null,"relative physical flow"]
["B","C","int",{"$f":"D6","v":35.885919915597547},{"$f":"E6","v":55.899354607028236},100.26947294659195,82.756255297983643,-21.635894811223942,-25.039086372482274,-34.975137143088773,-40.304740783953974,17.368876787948366,{"$f":"M6","v":13.777408298635876},null,"start","end","type",11,22,33,44,55,66,77,88,"00","AVG"]
["C","E","int",{"$f":"D8","v":32.873280733998129},{"$f":"E8","v":22.165663003393291},-46.741967106431304,-38.425802935172385,41.937812601345207,34.045528481385489,-0.26287504678791151,-19.137666505514886,17.077422783839154,{"$f":"M8","v":28.766279631582449},null,"A","B","ext",{"$f":"R4/R$11","v":4.946121342208095E-2},{"$f":"S4/S$11","v":8.9037069651673045E-2},9.7214519720895703E-2,0.10835487293447242,3.6749481994427499E-2,7.3188175875784231E-2,4.5752033392799832E-2,8.4257170738548659E-2,6.2110807322895145E-2,3.0502150828937549E-2]
["E","F","int",{"$f":"D10","v":48.500000000011354},{"$f":"E10","v":-1.4999999999878497},30.000000000027001,-1.9999999999799343,50.499999999997968,-2.0000000000069349,89.999999999999375,-2.0000000000089244,-1.9999999999966462,{"$f":"M10","v":31.000000000004917},null,"A","C","ext",{"$f":"R5/R$11","v":4.9461213422012755E-2},8.903706965163076E-2,9.721451972083861E-2,0.10835487293442987,3.6749481994469639E-2,7.3188175875756989E-2,4.5752033392856932E-2,8.4257170738503917E-2,6.2110807322865391E-2,3.0502150828873736E-2]
["B","C","ext",{"$f":"D5","v":7.9873608183972422},{"$f":"E5","v":12.266308396327581},22.988559946935538,18.817941766797475,-4.9262925873993879,-5.9153851461221763,-7.2877379036359002,-8.8329257215349344,3.7085459958771594,{"$f":"M5","v":2.9888713329490457},null,"B","C","int",0.22222122978373163,0.40575489942167781,0.42402171678717765,0.47651563802603425,0.16140087351552426,0.30979640580103873,0.21957206250405989,0.3844664308141178,0.2908943183636285,0.14060176539661451]
["B","E","ext",{"$f":"D9","v":14.126719265998773},{"$f":"E9","v":16.834336996603199},6.741967106452762,6.4258029351876189,5.0621873986462163,3.954471518603242,-9.7371249532056936,-12.862333494481959,7.9225772161566965,{"$f":"M9","v":9.233720368412861},null,"B","D","ext",8.7478792113577494E-2,0.12219487618251805,2.8510576379653207E-2,3.700017085665349E-2,3.7763239060440018E-2,4.8926747768878454E-2,6.1129155836855638E-2,0.12269364234527458,0.13268749194981763,9.4232337231887189E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C","E","int",0.20356565719692726,0.16089320575851254,0.19766344188360907,0.22125815065441298,0.31285045736477063,0.42122872217579704,1.6503156504556746E-3,0.1825539674086048,0.28601304049547488,0.2935668024365386]
["Commercial flow [MW]",null,null,null,null,null,null,null,null,null,null,null,null,null,"D","E","ext",8.7478792113542203E-2,0.12219487618249793,2.8510576379746955E-2,3.700017085675332E-2,3.7763239060347363E-2,4.8926747768729004E-2,6.1129155836851357E-2,0.12269364234524748,0.13268749194975099,9.4232337231819605E-2]
["start","end","type",11,22,33,44,55,66,77,88,"00","AVG",null,"E","F","int",0.30033310194812773,1.0888003151490111E-2,0.12686464912807882,1.1516123737243672E-2,0.37672322701002076,2.4745024734015564E-2,0.56501524338612064,1.9077975609702778E-2,3.349604259556746E-2,0.31636245604532881]
["B","C","int",{"$f":"'external data'!B13","v":58},{"$f":"'external data'!C13","v":85},{"$f":"'external data'!D13","v":130},{"$f":"'external data'!E13","v":108},{"$f":"'external data'!F13","v":-21.5},{"$f":"'external data'!G13","v":-27},{"$f":"'external data'!H13","v":-52},{"$f":"'external data'!I13","v":-62},{"$f":"'external data'!J13","v":29},{"$f":"'external data'!K13","v":26}]
["C","E","int",{"$f":"-'external data'!B17-'external data'!B16","v":47},{"$f":"-'external data'!C17-'external data'!C16","v":39},{"$f":"-'external data'!D17-'external data'!D16","v":-40},{"$f":"-'external data'!E17-'external data'!E16","v":-32},{"$f":"-'external data'!F17-'external data'!F16","v":47},{"$f":"-'external data'!G17-'external data'!G16","v":38},{"$f":"-'external data'!H17-'external data'!H16","v":-10},{"$f":"-'external data'!I17-'external data'!I16","v":-32},{"$f":"-'external data'!J17-'external data'!J16","v":25},{"$f":"-'external data'!K17-'external data'!K16","v":38}]
["E","F","int",{"$f":"-'external data'!B17","v":48.5},{"$f":"-'external data'!C17","v":-1.5},{"$f":"-'external data'!D17","v":30},{"$f":"-'external data'!E17","v":-2},{"$f":"-'external data'!F17","v":50.5},{"$f":"-'external data'!G17","v":-2},{"$f":"-'external data'!H17","v":90},{"$f":"-'external data'!I17","v":-2},{"$f":"-'external data'!J17","v":-2},{"$f":"-'external data'!K17","v":31}]
["B","C","ext",0,0,0,0,0,0,0,0,0,0]
["B","E","ext",0,0,0,0,0,0,0,0,0,0,null,"Physical flow [MW]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"start","end","type",11,22,33,44,55,66,77,88,"00","AVG"]
["CP",null,null,null,null,null,null,null,null,null,null,null,null,null,"B","C","int",{"$f":"ABS(D14)-ABS(D22)","v":-22.114080084402453},{"$f":"ABS(E14)-ABS(E22)","v":-29.100645392971764},-29.730527053408053,-25.243744702016357,0.13589481122394176,-1.9609136275177264,-17.024862856911227,-21.695259216046026,-11.631123212051634]
[null,null,null,"spread",null,null,null,null,null,null,null,null,null,null,"C","E","int",{"$f":"ABS(D15)-ABS(D23)","v":-14.126719266001871},{"$f":"ABS(E15)-ABS(E23)","v":-16.834336996606709},{"$f":"ABS(F15)-ABS(F23)","v":6.7419671064313036},{"$f":"ABS(G15)-ABS(G23)","v":6.4258029351723849},{"$f":"ABS(H15)-ABS(H23)","v":-5.0621873986547925},{"$f":"ABS(I15)-ABS(I23)","v":-3.9544715186145112},{"$f":"ABS(J15)-ABS(J23)","v":-9.7371249532120885},{"$f":"ABS(K15)-ABS(K23)","v":-12.862333494485114},{"$f":"ABS(L15)-ABS(L23)","v":-7.9225772161608461}]
["start","end","type",11,22,33,44,55,66,77,88,"00","AVG",null,"E","F","int",1.1354472917446401E-11,-1.2150280781497713E-11,2.7000623958883807E-11,-2.0065726857865229E-11,-2.0321522242738865E-12,6.9348971010185778E-12,-6.2527760746888816E-13,8.9244167611468583E-12,-3.3537617127876729E-12]
["B","C","int",{"$f":"ABS('external data'!B22-'external data'!B23)","v":1.9999999999999964},{"$f":"ABS('external data'!C22-'external data'!C23)","v":1},{"$f":"ABS('external data'!D22-'external data'!D23)","v":5.5},{"$f":"ABS('external data'!E22-'external data'!E23)","v":10.600000000000001},{"$f":"ABS('external data'!F22-'external data'!F23)","v":0},{"$f":"ABS('external data'!G22-'external data'!G23)","v":0},{"$f":"ABS('external data'!H22-'external data'!H23)","v":0},{"$f":"ABS('external data'!I22-'external data'!I23)","v":0},{"$f":"ABS('external data'!J22-'external data'!J23)","v":1.7999999999999972},{"$f":"ABS('external data'!K22-'external data'!K23)","v":1.5},null,"B","C","ext",7.9873608183972422,12.266308396327581,22.988559946935538,18.817941766797475,4.9262925873993879,5.9153851461221763,7.2877379036359002,8.8329257215349344,3.7085459958771594]
["C","E","int",{"$f":"ABS('external data'!B23-'external data'!B25)","v":8.3000000000000043},{"$f":"ABS('external data'!C23-'external data'!C25)","v":10},{"$f":"ABS('external data'!D23-'external data'!D25)","v":0},{"$f":"ABS('external data'!E23-'external data'!E25)","v":0},{"$f":"ABS('external data'!F23-'external data'!F25)","v":10.099999999999998},{"$f":"ABS('external data'!G23-'external data'!G25)","v":7.9000000000000057},{"$f":"ABS('external data'!H23-'external data'!H25)","v":0},{"$f":"ABS('external data'!I23-'external data'!I25)","v":0},{"$f":"ABS('external data'!J23-'external data'!J25)","v":11.800000000000004},{"$f":"ABS('external data'!K23-'external data'!K25)","v":8.7000000000000028},null,"B","E","ext",14.126719265998773,16.834336996603199,6.741967106452762,6.4258029351876189,5.0621873986462163,3.954471518603242,9.7371249532056936,12.862333494481959,7.9225772161566965]
["E","F","int",{"$f":"ABS('external data'!B25-'external data'!B26)","v":0},{"$f":"ABS('external data'!C25-'external data'!C26)","v":13.399999999999999},{"$f":"ABS('external data'!D25-'external data'!D26)","v":0.10000000000000142},{"$f":"ABS('external data'!E25-'external data'!E26)","v":21.299999999999997},{"$f":"ABS('external data'!F25-'external data'!F26)","v":0.20000000000000284},{"$f":"ABS('external data'!G25-'external data'!G26)","v":12.400000000000002},{"$f":"ABS('external data'!H25-'external data'!H26)","v":4.8999999999999986},{"$f":"ABS('external data'!I25-'external data'!I26)","v":5.1999999999999957},{"$f":"ABS('external data'!J25-'external data'!J26)","v":18.5},{"$f":"ABS('external data'!K25-'external data'!K26)","v":0.39999999999999858}]
["B","C","ext",{"$f":"ABS('external data'!B22-'external data'!B23)","v":1.9999999999999964},{"$f":"ABS('external data'!C22-'external data'!C23)","v":1},{"$f":"ABS('external data'!D22-'external data'!D23)","v":5.5},{"$f":"ABS('external data'!E22-'external data'!E23)","v":10.600000000000001},{"$f":"ABS('external data'!F22-'external data'!F23)","v":0},{"$f":"ABS('external data'!G22-'external data'!G23)","v":0},{"$f":"ABS('external data'!H22-'external data'!H23)","v":0},{"$f":"ABS('external data'!I22-'external data'!I23)","v":0},{"$f":"ABS('external data'!J22-'external data'!J23)","v":1.7999999999999972},{"$f":"ABS('external data'!K22-'external data'!K23)","v":1.5}]
["B","E","ext",{"$f":"ABS('external data'!B22-'external data'!B25)","v":10.3},{"$f":"ABS('external data'!C22-'external data'!C25)","v":11},{"$f":"ABS('external data'!D22-'external data'!D25)","v":5.5},{"$f":"ABS('external data'!E22-'external data'!E25)","v":10.600000000000001},{"$f":"ABS('external data'!F22-'external data'!F25)","v":10.099999999999998},{"$f":"ABS('external data'!G22-'external data'!G25)","v":7.9000000000000057},{"$f":"ABS('external data'!H22-'external data'!H25)","v":0},{"$f":"ABS('external data'!I22-'external data'!I25)","v":0},{"$f":"ABS('external data'!J22-'external data'!J25)","v":13.600000000000001},{"$f":"ABS('external data'!K22-'external data'!K25)","v":10.200000000000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(R28)/D22","v":0.38127724283452502},0.34236053403496192,{"$f":"ABS(T28)/F22","v":0.22869636194929271},{"$f":"ABS(U28)/G22","v":0.23373837687052182},-6.3206888941368259E-3,-7.2626430648804682E-2,-0.32740120878675438,-0.34992353574267782,0.40107321420867703]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(R29)/D23","v":0.30056849502131638},{"$f":"ABS(S29)/E23","v":0.4316496665796592},-0.16854917766078259,{"$f":"ABS(U29)/G23","v":-0.20080634172413703},{"$f":"ABS(V29)/H23","v":0.10770611486499558},{"$f":"ABS(W29)/I23","v":0.10406503996353977},{"$f":"ABS(X29)/J23","v":-0.97371249532120885},{"$f":"ABS(Y29)/K23","v":-0.40194792170265981},{"$f":"ABS(Z29)/L23","v":0.31690308864643385}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.3411284365868866E-13,-8.1001871876651421E-12,{"$f":"ABS(T30)/F24","v":9.0002079862946027E-13},-1.0032863428932615E-11,4.0240638104433395E-14,-3.4674485505092889E-12,6.9475289718765349E-15,-4.4622083805734292E-12,-1.6768808563938364E-12]

{"sheet":"CI","index":10,"n_rows":90,"n_cols":34,"rows_kept":90,"cut":false,"hidden":false,"merged":[[2,0,2,2],[3,0,3,2]]}
["Congestion Income"]
[null,null,null,11,22,33,44,55,66,77,88,"00","AVG","sum"]
["Total Congestion Income",null,null,{"$f":"-SUMPRODUCT('external data'!B12:B17,'external data'!B21:B26)","v":506.09999999999991},{"$f":"-SUMPRODUCT('external data'!C12:C17,'external data'!C21:C26)","v":495.1},{"$f":"-SUMPRODUCT('external data'!D12:D17,'external data'!D21:D26)","v":718},{"$f":"-SUMPRODUCT('external data'!E12:E17,'external data'!E21:E26)","v":1187.4000000000001},{"$f":"-SUMPRODUCT('external data'!F12:F17,'external data'!F21:F26)","v":484.80000000000018},{"$f":"-SUMPRODUCT('external data'!G12:G17,'external data'!G21:G26)","v":324.99999999999989},{"$f":"-SUMPRODUCT('external data'!H12:H17,'external data'!H21:H26)","v":441},{"$f":"-SUMPRODUCT('external data'!I12:I17,'external data'!I21:I26)","v":10.399999999999906},{"$f":"-SUMPRODUCT('external data'!J12:J17,'external data'!J21:J26)","v":384.2000000000001},{"$f":"-SUMPRODUCT('external data'!K12:K17,'external data'!K21:K26)","v":382.00000000000023},{"$f":"SUM(D3:L3)","v":4551.9999999999991}]
["Number of situations",null,null,2689,887,26,103,1752,771,6,317,539]
[]
["Flow - Based world",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NTC world"]
[null,null,null,"k",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CI"]
["start","end","type",11,22,33,44,55,66,77,88,0,"AVG",null,null,null,null,"start","end","type",11,22,33,44,55,66,77,88,0,"AVG"]
["B","C","int",{"$f":"ABS('AAF + CP'!D31*'AAF + CP'!D6)","v":71.771839831194967},{"$f":"ABS('AAF + CP'!E31*'AAF + CP'!E6)","v":55.899354607028236},{"$f":"ABS('AAF + CP'!F31*'AAF + CP'!F6)","v":551.48210120625572},{"$f":"ABS('AAF + CP'!G31*'AAF + CP'!G6)","v":877.21630615862671},{"$f":"ABS('AAF + CP'!H31*'AAF + CP'!H6)","v":0},{"$f":"ABS('AAF + CP'!I31*'AAF + CP'!I6)","v":0},{"$f":"ABS('AAF + CP'!J31*'AAF + CP'!J6)","v":0},{"$f":"ABS('AAF + CP'!K31*'AAF + CP'!K6)","v":0},{"$f":"ABS('AAF + CP'!L31*'AAF + CP'!L6)","v":31.26397821830701},{"$f":"ABS('AAF + CP'!M31*'AAF + CP'!M6)","v":20.666112447953815},null,null,null,null,"B","C","int",{"$f":"ABS('AAF + CP'!D22)*'AAF + CP'!D31","v":115.9999999999998},{"$f":"ABS('AAF + CP'!E22)*'AAF + CP'!E31","v":85},{"$f":"ABS('AAF + CP'!F22)*'AAF + CP'!F31","v":715},{"$f":"ABS('AAF + CP'!G22)*'AAF + CP'!G31","v":1144.8000000000002},{"$f":"ABS('AAF + CP'!H22)*'AAF + CP'!H31","v":0},{"$f":"ABS('AAF + CP'!I22)*'AAF + CP'!I31","v":0},{"$f":"ABS('AAF + CP'!J22)*'AAF + CP'!J31","v":0},{"$f":"ABS('AAF + CP'!K22)*'AAF + CP'!K31","v":0},{"$f":"ABS('AAF + CP'!L22)*'AAF + CP'!L31","v":52.199999999999918},{"$f":"ABS('AAF + CP'!M22)*'AAF + CP'!M31","v":39}]
["C","E","int",{"$f":"ABS('AAF + CP'!D32*'AAF + CP'!D8)","v":272.84823009218462},{"$f":"ABS('AAF + CP'!E32*'AAF + CP'!E8)","v":221.65663003393291},{"$f":"ABS('AAF + CP'!F32*'AAF + CP'!F8)","v":0},{"$f":"ABS('AAF + CP'!G32*'AAF + CP'!G8)","v":0},{"$f":"ABS('AAF + CP'!H32*'AAF + CP'!H8)","v":423.57190727358653},{"$f":"ABS('AAF + CP'!I32*'AAF + CP'!I8)","v":268.95967500294557},{"$f":"ABS('AAF + CP'!J32*'AAF + CP'!J8)","v":0},{"$f":"ABS('AAF + CP'!K32*'AAF + CP'!K8)","v":0},{"$f":"ABS('AAF + CP'!L32*'AAF + CP'!L8)","v":201.5135888493021},{"$f":"ABS('AAF + CP'!M32*'AAF + CP'!M8)","v":250.26663279476739},null,null,null,null,"C","E","int",{"$f":"ABS('AAF + CP'!D23)*'AAF + CP'!D32","v":390.10000000000019},{"$f":"ABS('AAF + CP'!E23)*'AAF + CP'!E32","v":390},{"$f":"ABS('AAF + CP'!F23)*'AAF + CP'!F32","v":0},{"$f":"ABS('AAF + CP'!G23)*'AAF + CP'!G32","v":0},{"$f":"ABS('AAF + CP'!H23)*'AAF + CP'!H32","v":474.69999999999987},{"$f":"ABS('AAF + CP'!I23)*'AAF + CP'!I32","v":300.20000000000022},{"$f":"ABS('AAF + CP'!J23)*'AAF + CP'!J32","v":0},{"$f":"ABS('AAF + CP'!K23)*'AAF + CP'!K32","v":0},{"$f":"ABS('AAF + CP'!L23)*'AAF + CP'!L32","v":295.00000000000011},{"$f":"ABS('AAF + CP'!M23)*'AAF + CP'!M32","v":330.60000000000014}]
["E","F","int",{"$f":"ABS('AAF + CP'!D33*'AAF + CP'!D10)","v":0},{"$f":"ABS('AAF + CP'!E33*'AAF + CP'!E10)","v":20.099999999837184},{"$f":"ABS('AAF + CP'!F33*'AAF + CP'!F10)","v":3.0000000000027427},{"$f":"ABS('AAF + CP'!G33*'AAF + CP'!G10)","v":42.599999999572596},{"$f":"ABS('AAF + CP'!H33*'AAF + CP'!H10)","v":10.099999999999737},{"$f":"ABS('AAF + CP'!I33*'AAF + CP'!I10)","v":24.800000000085998},{"$f":"ABS('AAF + CP'!J33*'AAF + CP'!J10)","v":440.99999999999682},{"$f":"ABS('AAF + CP'!K33*'AAF + CP'!K10)","v":10.400000000046399},{"$f":"ABS('AAF + CP'!L33*'AAF + CP'!L10)","v":36.999999999937955},{"$f":"ABS('AAF + CP'!M33*'AAF + CP'!M10)","v":12.400000000001922},null,null,null,null,"E","F","int",{"$f":"ABS('AAF + CP'!D24)*'AAF + CP'!D33","v":0},{"$f":"ABS('AAF + CP'!E24)*'AAF + CP'!E33","v":20.099999999999998},{"$f":"ABS('AAF + CP'!F24)*'AAF + CP'!F33","v":3.0000000000000426},{"$f":"ABS('AAF + CP'!G24)*'AAF + CP'!G33","v":42.599999999999994},{"$f":"ABS('AAF + CP'!H24)*'AAF + CP'!H33","v":10.100000000000144},{"$f":"ABS('AAF + CP'!I24)*'AAF + CP'!I33","v":24.800000000000004},{"$f":"ABS('AAF + CP'!J24)*'AAF + CP'!J33","v":440.99999999999989},{"$f":"ABS('AAF + CP'!K24)*'AAF + CP'!K33","v":10.399999999999991},{"$f":"ABS('AAF + CP'!L24)*'AAF + CP'!L33","v":37},{"$f":"ABS('AAF + CP'!M24)*'AAF + CP'!M33","v":12.399999999999956}]
["B","C","ext",{"$f":"ABS('AAF + CP'!D5*'AAF + CP'!D34)","v":15.974721636794456},{"$f":"ABS('AAF + CP'!E5*'AAF + CP'!E34)","v":12.266308396327581},{"$f":"ABS('AAF + CP'!F5*'AAF + CP'!F34)","v":126.43707970814546},{"$f":"ABS('AAF + CP'!G5*'AAF + CP'!G34)","v":199.47018272805326},{"$f":"ABS('AAF + CP'!H5*'AAF + CP'!H34)","v":0},{"$f":"ABS('AAF + CP'!I5*'AAF + CP'!I34)","v":0},{"$f":"ABS('AAF + CP'!J5*'AAF + CP'!J34)","v":0},{"$f":"ABS('AAF + CP'!K5*'AAF + CP'!K34)","v":0},{"$f":"ABS('AAF + CP'!L5*'AAF + CP'!L34)","v":6.6753827925788762},{"$f":"ABS('AAF + CP'!M5*'AAF + CP'!M34)","v":4.4833069994235686},null,null,null,null,"B","C","ext",{"$f":"ABS('AAF + CP'!D25)*'AAF + CP'!D34","v":0},{"$f":"ABS('AAF + CP'!E25)*'AAF + CP'!E34","v":0},{"$f":"ABS('AAF + CP'!F25)*'AAF + CP'!F34","v":0},{"$f":"ABS('AAF + CP'!G25)*'AAF + CP'!G34","v":0},{"$f":"ABS('AAF + CP'!H25)*'AAF + CP'!H34","v":0},{"$f":"ABS('AAF + CP'!I25)*'AAF + CP'!I34","v":0},{"$f":"ABS('AAF + CP'!J25)*'AAF + CP'!J34","v":0},{"$f":"ABS('AAF + CP'!K25)*'AAF + CP'!K34","v":0},{"$f":"ABS('AAF + CP'!L25)*'AAF + CP'!L34","v":0},{"$f":"ABS('AAF + CP'!M25)*'AAF + CP'!M34","v":0}]
["B","E","ext",{"$f":"ABS('AAF + CP'!D9*'AAF + CP'!D35)","v":145.50520843978737},{"$f":"ABS('AAF + CP'!E9*'AAF + CP'!E35)","v":185.17770696263517},{"$f":"ABS('AAF + CP'!F9*'AAF + CP'!F35)","v":37.080819085490191},{"$f":"ABS('AAF + CP'!G9*'AAF + CP'!G35)","v":68.113511112988775},{"$f":"ABS('AAF + CP'!H9*'AAF + CP'!H35)","v":51.12809272632677},{"$f":"ABS('AAF + CP'!I9*'AAF + CP'!I35)","v":31.240324996965633},{"$f":"ABS('AAF + CP'!J9*'AAF + CP'!J35)","v":0},{"$f":"ABS('AAF + CP'!K9*'AAF + CP'!K35)","v":0},{"$f":"ABS('AAF + CP'!L9*'AAF + CP'!L35)","v":107.74705013973109},{"$f":"ABS('AAF + CP'!M9*'AAF + CP'!M35)","v":94.183947757811211},null,null,null,null,"B","E","ext",{"$f":"ABS('AAF + CP'!D26)*'AAF + CP'!D35","v":0},{"$f":"ABS('AAF + CP'!E26)*'AAF + CP'!E35","v":0},{"$f":"ABS('AAF + CP'!F26)*'AAF + CP'!F35","v":0},{"$f":"ABS('AAF + CP'!G26)*'AAF + CP'!G35","v":0},{"$f":"ABS('AAF + CP'!H26)*'AAF + CP'!H35","v":0},{"$f":"ABS('AAF + CP'!I26)*'AAF + CP'!I35","v":0},{"$f":"ABS('AAF + CP'!J26)*'AAF + CP'!J35","v":0},{"$f":"ABS('AAF + CP'!K26)*'AAF + CP'!K35","v":0},{"$f":"ABS('AAF + CP'!L26)*'AAF + CP'!L35","v":0},{"$f":"ABS('AAF + CP'!M26)*'AAF + CP'!M35","v":0}]
["sum",null,null,{"$f":"SUM(D9:D13)","v":506.09999999996137},495.09999999976105,717.99999999989404,1187.3999999992413,484.79999999991304,324.99999999999721,440.99999999999682,10.400000000046399,384.19999999985703,{"$f":"SUM(M9:M13)","v":381.99999999995788}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zone",11,22,33,44,55,66,77,88,0,"AVG","sum","sum (00 - 99)","rel. cases","rel. AVG"]
["start","end","type",11,22,33,44,55,66,77,88,0,"AVG",null,null,null,null,null,null,"A",0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U16:AC16)","v":0},{"$f":"SUMPRODUCT($D$4:$L$4,U16:AC16)","v":0},{"$f":"AF16/$AF$22","v":0},{"$f":"AD16/AD$22","v":0}]
["B","C","int",{"$f":"D9/$D$14","v":0.14181355429994161},{"$f":"E9/$E$14","v":0.11290517997789379},{"$f":"F9/$F$14","v":0.76808092090019098},{"$f":"G9/$G$14","v":0.73877068061241968},{"$f":"H9/$H$14","v":0},{"$f":"I9/$I$14","v":0},{"$f":"J9/$J$14","v":0},{"$f":"K9/$K$14","v":0},{"$f":"L9/$L$14","v":8.1374227533364513E-2},{"$f":"M9/$M$14","v":5.4099770806167784E-2},null,null,null,null,null,null,"B",{"$f":"0.5*U9","v":57.999999999999901},42.5,357.5,572.40000000000009,0,0,0,0,26.099999999999959,19.5,{"$f":"SUM(U17:AC17)","v":1056.5},275979.59999999974,8.4812467616759382E-2,{"$f":"AD17/AD$22","v":5.1047120418848152E-2}]
["C","E","int",{"$f":"D10/$D$14","v":0.53911920587276319},{"$f":"E10/$E$14","v":0.44770072719458676},{"$f":"F10/$F$14","v":0},{"$f":"G10/$G$14","v":0},{"$f":"H10/$H$14","v":0.87370442919484836},{"$f":"I10/$I$14","v":0.82756823077830122},{"$f":"J10/$J$14","v":0},{"$f":"K10/$K$14","v":0},{"$f":"L10/$L$14","v":0.52450179294476074},{"$f":"M10/$M$14","v":0.65514825338951566},null,null,null,null,null,null,"C",{"$f":"0.5*U9+0.5*U10","v":253.05},237.5,357.5,572.40000000000009,237.34999999999994,150.10000000000011,0,0,173.60000000000002,184.80000000000007,1981.5,1584500.85,0.48693971231697142,0.48376963350785346]
["E","F","int",{"$f":"D11/$D$14","v":0},{"$f":"E11/$E$14","v":4.0597859018070864E-2},{"$f":"F11/$F$14","v":4.1782729805058295E-3},{"$f":"G11/$G$14","v":3.5876705406434069E-2},{"$f":"H11/$H$14","v":2.0833333333336528E-2},{"$f":"I11/$I$14","v":7.6307692307957573E-2},{"$f":"J11/$J$14","v":1},{"$f":"K11/$K$14","v":1},{"$f":"L11/$L$14","v":9.6304008328869664E-2},3.2460732984301806E-2,null,null,null,null,null,null,"D",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["B","C","ext",{"$f":"D12/$D$14","v":3.1564358104713842E-2},{"$f":"E12/$E$14","v":2.4775415868175117E-2},{"$f":"F12/$F$14","v":0.17609621129270769},{"$f":"G12/$G$14","v":0.16798903716370281},{"$f":"H12/$H$14","v":0},{"$f":"I12/$I$14","v":0},{"$f":"J12/$J$14","v":0},{"$f":"K12/$K$14","v":0},{"$f":"L12/$L$14","v":1.7374760001513171E-2},1.1736405757654614E-2,null,null,null,null,null,null,"E",{"$f":"0.5*U10+0.5*U11","v":195.0500000000001},205.05,1.5000000000000213,21.299999999999997,242.4,162.50000000000011,220.49999999999994,5.1999999999999957,166.00000000000006,{"$f":"0.5*AD10+0.5*AD11","v":171.50000000000006},1219.5000000000002,1351019.4000000001,0.41518753238324063,0.44895287958115182]
["B","E","ext",{"$f":"D13/$D$14","v":0.28750288172258143},{"$f":"E13/$E$14","v":0.37402081794127356},{"$f":"F13/$F$14","v":5.1644594826595634E-2},{"$f":"G13/$G$14","v":5.7363576817443397E-2},{"$f":"H13/$H$14","v":0.10546223747181506},{"$f":"I13/$I$14","v":9.6124076913741238E-2},{"$f":"J13/$J$14","v":0},{"$f":"K13/$K$14","v":0},{"$f":"L13/$L$14","v":0.28044521119149191},0.2465548370623602,null,null,null,null,null,null,"F",{"$f":"0.5*U11","v":0},10.049999999999999,1.5000000000000213,21.299999999999997,5.0500000000000718,12.400000000000002,220.49999999999994,5.1999999999999957,18.5,{"$f":"0.5*AD11","v":6.199999999999978},294.50000000000006,42498.150000000125,1.3060287683028733E-2,1.6230366492146535E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sum",{"$f":"SUM(AD16:AD21)","v":382.00000000000011},null,{"$f":"SUM(AF16:AF21)","v":3253997.9999999995}]
["start","end","type",11,22,33,44,55,66,77,88,0,"AVG"]
["B","C","int",{"$f":"D17*D$3","v":71.771839831200438},55.899354607055216,551.48210120633712,877.21630615918718,0,0,0,0,31.263978218318655,20.666112447956106]
["C","E","int",{"$f":"D18*D$3","v":272.84823009220543},221.65663003403992,0,0,423.57190727366265,268.95967500294779,0,0,201.51358884937713,250.26663279479513,null,null,null,null,null,null,{"$f":"T15","v":"zone"},{"$f":"U15","v":11},22,33,44,55,66,77,88,0,{"$f":"AD15","v":"AVG"},{"$f":"AE15","v":"sum"},{"$f":"AF15","v":"sum (00 - 99)"},{"$f":"AG15","v":"rel. cases"},{"$f":"AH15","v":"rel. AVG"}]
["E","F","int",{"$f":"D19*D$3","v":0},20.099999999846887,3.0000000000031855,42.599999999599817,10.100000000001552,24.800000000086204,441,10.399999999999906,36.999999999951733,12.400000000003297,null,null,null,null,null,null,{"$f":"T17","v":"B"},{"$f":"U17","v":57.999999999999901},42.5,357.5,572.40000000000009,0,0,0,0,26.099999999999959,{"$f":"AD17","v":19.5},{"$f":"AE17","v":1056.5},275979.59999999974,8.4812467616759382E-2,5.1047120418848152E-2]
["B","C","ext",{"$f":"D20*D$3","v":15.974721636795673},12.266308396333502,126.43707970816412,199.47018272818073,0,0,0,0,6.6753827925813622,4.4833069994240651,null,null,null,null,null,null,{"$f":"T18","v":"C"},{"$f":"U18","v":253.05},237.5,357.5,572.40000000000009,237.34999999999994,150.10000000000011,0,0,173.60000000000002,{"$f":"AD18","v":184.80000000000007},1981.5,1584500.85,0.48693971231697142,0.48376963350785346]
["B","E","ext",{"$f":"D21*D$3","v":145.50520843979842},185.17770696272456,37.080819085495662,68.113511113032288,51.128092726335957,31.240324996965892,0,0,107.74705013977122,94.183947757821656,null,null,null,null,null,null,{"$f":"T20","v":"E"},{"$f":"U20","v":195.0500000000001},205.05,1.5000000000000213,21.299999999999997,242.4,162.50000000000011,220.49999999999994,5.1999999999999957,166.00000000000006,{"$f":"AD20","v":171.50000000000006},{"$f":"AE20","v":1219.5000000000002},1351019.4000000001,0.41518753238324063,0.44895287958115182]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T21","v":"F"},{"$f":"U21","v":0},10.049999999999999,1.5000000000000213,21.299999999999997,5.0500000000000718,12.400000000000002,220.49999999999994,5.1999999999999957,18.5,{"$f":"AD21","v":6.199999999999978},294.50000000000006,42498.150000000125,1.3060287683028733E-2,1.6230366492146535E-2]
["external borders",null,null,{"$f":"0.5*D27+0.5*D28","v":80.739965038297044},{"$f":"0.5*E27+0.5*E28","v":98.722007679529028},81.758949396829891,133.7918469206065,25.564046363167979,15.620162498482946,0,0,57.211216466176289,49.333627378622857]
[]
["start","end","type",11,22,33,44,55,66,77,88,0,"AVG"]
["A","B","ext",{"$f":"'AAF + CP'!R15*CI!D$30","v":3.9934966424505642},{"$f":"'AAF + CP'!S15*CI!E$30","v":8.7899182739152266},{"$f":"'AAF + CP'!T15*CI!F$30","v":7.9481569984978337},{"$f":"'AAF + CP'!U15*CI!G$30","v":14.496998572750703},{"$f":"'AAF + CP'!V15*CI!H$30","v":0.93946546152795141},{"$f":"'AAF + CP'!W15*CI!I$30","v":1.1432112001472992},{"$f":"'AAF + CP'!X15*CI!J$30","v":0},{"$f":"'AAF + CP'!Y15*CI!K$30","v":0},{"$f":"'AAF + CP'!Z15*CI!L$30","v":3.5534348426391213},{"$f":"'AAF + CP'!AA15*CI!M$30","v":1.5047817432413573}]
["A","C","ext",{"$f":"'AAF + CP'!R16*CI!D$30","v":3.9934966424450584},{"$f":"'AAF + CP'!S16*CI!E$30","v":8.7899182739110522},{"$f":"'AAF + CP'!T16*CI!F$30","v":7.9481569984931655},{"$f":"'AAF + CP'!U16*CI!G$30","v":14.49699857274501},{"$f":"'AAF + CP'!V16*CI!H$30","v":0.93946546152902866},{"$f":"'AAF + CP'!W16*CI!I$30","v":1.1432112001468735},{"$f":"'AAF + CP'!X16*CI!J$30","v":0},{"$f":"'AAF + CP'!Y16*CI!K$30","v":0},{"$f":"'AAF + CP'!Z16*CI!L$30","v":3.5534348426374192},{"$f":"'AAF + CP'!AA16*CI!M$30","v":1.5047817432382091}]
["B","C","int",{"$f":"'AAF + CP'!R17*CI!D$30","v":17.942134323505865},{"$f":"'AAF + CP'!S17*CI!E$30","v":40.056938296713405},{"$f":"'AAF + CP'!T17*CI!F$30","v":34.667570085959795},{"$f":"'AAF + CP'!U17*CI!G$30","v":63.753907298054315},{"$f":"'AAF + CP'!V17*CI!H$30","v":4.1260594136066731},{"$f":"'AAF + CP'!W17*CI!I$30","v":4.83907020005819},{"$f":"'AAF + CP'!X17*CI!J$30","v":0},{"$f":"'AAF + CP'!Y17*CI!K$30","v":0},{"$f":"'AAF + CP'!Z17*CI!L$30","v":16.64241781668235},{"$f":"'AAF + CP'!AA17*CI!M$30","v":6.9363951028531297}]
["B","D","ext",{"$f":"'AAF + CP'!R18*CI!D$30","v":7.0630346168427023},{"$f":"'AAF + CP'!S18*CI!E$30","v":12.063323504889645},{"$f":"'AAF + CP'!T18*CI!F$30","v":2.3309947714985202},{"$f":"'AAF + CP'!U18*CI!G$30","v":4.9503211952896695},{"$f":"'AAF + CP'!V18*CI!H$30","v":0.96538119416448465},{"$f":"'AAF + CP'!W18*CI!I$30","v":0.76424375067216943},{"$f":"'AAF + CP'!X18*CI!J$30","v":0},{"$f":"'AAF + CP'!Y18*CI!K$30","v":0},{"$f":"'AAF + CP'!Z18*CI!L$30","v":7.5912128242950399},{"$f":"'AAF + CP'!AA18*CI!M$30","v":4.6488230120146516}]
["C","E","int",{"$f":"'AAF + CP'!R19*CI!D$30","v":16.435884045077866},{"$f":"'AAF + CP'!S19*CI!E$30","v":15.883700294475918},{"$f":"'AAF + CP'!T19*CI!F$30","v":16.160755342565221},{"$f":"'AAF + CP'!U19*CI!G$30","v":29.602536622291712},{"$f":"'AAF + CP'!V19*CI!H$30","v":7.9977235968113032},{"$f":"'AAF + CP'!W19*CI!I$30","v":6.5796610894142766},{"$f":"'AAF + CP'!X19*CI!J$30","v":0},{"$f":"'AAF + CP'!Y19*CI!K$30","v":0},{"$f":"'AAF + CP'!Z19*CI!L$30","v":16.363153971935859},{"$f":"'AAF + CP'!AA19*CI!M$30","v":14.482715242137989}]
["D","E","ext",{"$f":"'AAF + CP'!R20*CI!D$30","v":7.063034616839853},{"$f":"'AAF + CP'!S20*CI!E$30","v":12.063323504887659},{"$f":"'AAF + CP'!T20*CI!F$30","v":2.3309947715061847},{"$f":"'AAF + CP'!U20*CI!G$30","v":4.9503211953030259},{"$f":"'AAF + CP'!V20*CI!H$30","v":0.96538119416211599},{"$f":"'AAF + CP'!W20*CI!I$30","v":0.76424375066983496},{"$f":"'AAF + CP'!X20*CI!J$30","v":0},{"$f":"'AAF + CP'!Y20*CI!K$30","v":0},{"$f":"'AAF + CP'!Z20*CI!L$30","v":7.5912128242912278},{"$f":"'AAF + CP'!AA20*CI!M$30","v":4.6488230120113174}]
["E","F","int",{"$f":"'AAF + CP'!R21*CI!D$30","v":24.248884151135133},{"$f":"'AAF + CP'!S21*CI!E$30","v":1.0748855307361429},{"$f":"'AAF + CP'!T21*CI!F$30","v":10.372320428309175},{"$f":"'AAF + CP'!U21*CI!G$30","v":1.5407634641720682},{"$f":"'AAF + CP'!V21*CI!H$30","v":9.6305700413664255},{"$f":"'AAF + CP'!W21*CI!I$30","v":0.38652130737430285},{"$f":"'AAF + CP'!X21*CI!J$30","v":0},{"$f":"'AAF + CP'!Y21*CI!K$30","v":0},{"$f":"'AAF + CP'!Z21*CI!L$30","v":1.9163493436952714},{"$f":"'AAF + CP'!AA21*CI!M$30","v":15.607307523126204}]
[]
[null,null,"zone",11,22,33,44,55,66,77,88,0,"AVG","sum","sum (00 - 99)","rel. cases","rel. AVG"]
[null,null,"A",0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D42:L42)","v":0},{"$f":"SUMPRODUCT($D$4:$L$4,D42:L42)","v":0},{"$f":"O42/$O$48","v":0},{"$f":"M42/M$48","v":0}]
[null,null,"B",{"$f":"0.5*D24+0.25*D27+0.25*D28+0.5*D35+D33+D36","v":96.283500855794941},118.19239207045371,344.23346211455981,556.82834995696442,16.749899544079764,12.137071300090037,0,0,63.703453917522808,{"$f":"0.5*M24+0.25*M27+0.25*M28+0.5*M35+M33+M36","v":44.621672219972062},{"$f":"SUM(D43:L43)","v":1208.1281297594653},503086.0432634129,0.15460551704807837,{"$f":"M43/M$48","v":0.11681066026170688}]
[null,null,"C",{"$f":"0.5*D24+0.5*D25+0.25*D27+D34+0.5*D35+0.5*D37","v":197.48622119763877},178.60480698913668,340.71264024296534,549.65091929455673,218.78731060356935,141.33241434635701,0,0,138.11384996893975,{"$f":"0.5*M24+0.5*M25+0.25*M27+M34+0.5*M35+0.5*M37","v":148.80153628696539},1764.6881626431637,1321661.5107052245,0.40616543424587981,0.38953281750514468]
[null,null,"D",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"E",{"$f":"0.5*D25+0.5*D26+0.25*D28+0.5*D37+D38+0.5*D39","v":200.20583587099867},187.71535817511824,26.36773742831889,58.850349016592901,239.39750483166705,158.93725369982261,220.5,5.1999999999999531,162.92452144171403,{"$f":"0.5*M25+0.5*M26+0.25*M28+0.5*M37+M38+0.5*M39","v":174.57313773149806},1260.0985604642324,1344356.9306050185,0.41314006050557456,0.4569977427526124]
[null,null,"F",{"$f":"0.5*D26+0.5*D39","v":12.124442075567567},10.587442765291515,6.68616021415618,22.070381731885941,9.8652850206839879,12.593260653730253,220.5,5.1999999999999531,19.458174671823503,{"$f":"0.5*M26+0.5*M39","v":14.003653761564751},319.08514713313889,84893.515426344282,2.6088988200467327E-2,3.6658779480535968E-2]
[null,null,null,null,null,null,null,null,null,null,null,"sum",{"$f":"SUM(M42:M47)","v":382.00000000000028},null,{"$f":"SUM(O42:O47)","v":3253998}]
[]
[null,null,"congestion income"]
[null,null,{"$f":"C41","v":"zone"},{"$f":"D41","v":11},22,33,44,55,66,77,88,0,"AVG",{"$f":"N41","v":"sum"},{"$f":"O41","v":"sum (00 - 99)"},{"$f":"P41","v":"rel. cases"},{"$f":"Q41","v":"rel. AVG"}]
[null,null,{"$f":"C43","v":"B"},{"$f":"D43","v":96.283500855794941},118.19239207045371,344.23346211455981,556.82834995696442,16.749899544079764,12.137071300090037,0,0,63.703453917522808,{"$f":"M43","v":44.621672219972062},{"$f":"N43","v":1208.1281297594653},503086.0432634129,0.15460551704807837,0.11681066026170688]
[null,null,{"$f":"C44","v":"C"},{"$f":"D44","v":197.48622119763877},178.60480698913668,340.71264024296534,549.65091929455673,218.78731060356935,141.33241434635701,0,0,138.11384996893975,{"$f":"M44","v":148.80153628696539},1764.6881626431637,1321661.5107052245,0.40616543424587981,0.38953281750514468]
[null,null,{"$f":"C46","v":"E"},{"$f":"D46","v":200.20583587099867},187.71535817511824,26.36773742831889,58.850349016592901,239.39750483166705,158.93725369982261,220.5,5.1999999999999531,162.92452144171403,{"$f":"M46","v":174.57313773149806},{"$f":"N46","v":1260.0985604642324},1344356.9306050185,0.41314006050557456,0.4569977427526124]
[null,null,{"$f":"C47","v":"F"},{"$f":"D47","v":12.124442075567567},10.587442765291515,6.68616021415618,22.070381731885941,9.8652850206839879,12.593260653730253,220.5,5.1999999999999531,19.458174671823503,{"$f":"M47","v":14.003653761564751},319.08514713313889,84893.515426344282,2.6088988200467327E-2,3.6658779480535968E-2]
[]
[]
[]
[]
[]
[{"$f":"A30","v":"external borders"},null,null,{"$f":"D30","v":80.739965038297044},98.722007679529028,81.758949396829891,133.7918469206065,25.564046363167979,15.620162498482946,0,0,57.211216466176289]
["internal borders",null,null,{"$f":"SUM(D24:D26)+0.5*D27+0.5*D28","v":425.36003496170292},{"$f":"SUM(E24:E26)+0.5*E27+0.5*E28","v":396.37799232047109},636.24105060317027,1053.6081530793936,459.23595363683216,309.37983750151693,441,10.399999999999906,326.98878353382378]
["sum",null,null,{"$f":"D61+D62","v":506.09999999999997},{"$f":"E61+E62","v":495.10000000000014},718.00000000000011,1187.4000000000001,484.80000000000013,324.99999999999989,441,10.399999999999906,384.20000000000005]
[]
[null,null,"relative"]
[null,null,"external pot",{"$f":"D61/D63","v":0.15953361991364759},{"$f":"E61/E63","v":0.19939811690472431},0.11387040305965164,0.1126763069905731,5.273111873590753E-2,4.8062038456870619E-2,0,0,0.14890998559650256]
[null,null,"internal pot",{"$f":"D62/D63","v":0.84046638008635244},{"$f":"E62/E63","v":0.80060188309527569},0.88612959694034843,0.88732369300942693,0.94726888126409248,0.95193796154312937,1,1,0.85109001440349752]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"zone",11,22,33,44,55,66,77,88,0,"sum","sum (00 - 99)","rel. cases"]
[null,null,"B",{"$f":"0.5*D24+0.25*D27+0.25*D28","v":76.255902434748748},{"$f":"0.5*E24+0.25*E27+0.25*E28","v":77.310681143292129},316.62052530158354,505.50407653989686,12.782023181583989,7.8100812492414731,0,0,44.237597342247469,{"$f":"SUM(D84:L84)","v":1040.5208871925943},{"$f":"SUMPRODUCT($D$4:$L$4,D84:L84)","v":386185.49158736184},{"$f":"N84/$N$90","v":0.11868031006391577}]
[null,null,"C",{"$f":"0.5*D25+0.5*D24+0.25*D27","v":176.30371537090187},{"$f":"0.5*E25+0.5*E24+0.25*E27","v":141.84456941963097},307.35032053020961,488.4756987616388,211.78595363683132,134.4798375014739,0,0,118.05762923199323,{"$f":"SUM(D85:L85)","v":1578.2977244526794},{"$f":"SUMPRODUCT($D$4:$L$4,D85:L85)","v":1196566.9366552113},{"$f":"N85/$N$90","v":0.36772208730773992}]
[null,null,"E",{"$f":"0.5*D25+0.5*D26+0.25*D28","v":172.80041715605233},{"$f":"0.5*E25+0.5*E26+0.25*E28","v":167.17274175762455},10.770204771375509,38.328377778057984,229.61797681841608,154.68991875075847,220.5,5.1999999999999531,146.19355695960724,1145.2731939918922,1220496.7418507615,0.37507605777593017]
[null,null,"F",{"$f":"0.5*D26","v":0},{"$f":"0.5*E26","v":10.049999999923443},1.5000000000015927,21.299999999799908,5.0500000000007761,12.400000000043102,220.5,5.1999999999999531,18.499999999975866,294.4999999997446,42498.149999933092,1.306028768300813E-2]
[null,null,"A",{"$f":"0.5*D27","v":7.9873608183978364},{"$f":"0.5*E27","v":6.1331541981667508},63.21853985408206,99.735091364090366,0,0,0,0,3.3376913962906811,180.41183763102771,40633.533123753812,1.2487264320308066E-2]
[null,null,"D",{"$f":"0.5*D28","v":72.752604219899212},{"$f":"0.5*E28","v":92.588853481362278},18.540409542747831,34.056755556516144,25.564046363167979,15.620162498482946,0,0,53.873525069885609,312.996356732062,367617.1467829789,0.1129739928490979]
[null,null,null,null,null,null,null,null,null,null,null,null,"sum",{"$f":"SUM(N84:N89)","v":3253998.0000000005}]

{"sheet":"external data","index":11,"n_rows":40,"n_cols":20,"rows_kept":40,"cut":false,"hidden":false,"merged":[[19,13,19,19]]}
["ENTSO-E Transparency 2015"]
[null,"AT","CZ","SK","HU","RO","PL"]
["generation",5539.7026439281217,7835.755707762557,3019.8340182648403,3098.6554223744292,8679.495720399429,16838.189044911222]
["load",6753.0595605022827,7248.2968678555098,3222.1649319455564,4747.9550411052751,6531.335893941271,18419.350045682961]
[]
["balance",-1213.356916574161,587.45883990704715,-202.33091368071609,-1649.2996187308459,2148.159826458158,-1581.1610007717391]
[]
[]
["OTE - ČR 4M MC 2015"]
[]
["balance",11,22,33,44,55,66,77,88,"00","AVG"]
["zone A",0,0,0,0,0,0,0,0,0,0]
["zone B",58,85,130,108,-21.5,-27,-52,-62,29,26]
["zone C",-11,-46,-170,-140,68.5,65,42,30,-4,12]
["zone D",0,0,0,0,0,0,0,0,0,0]
["zone E",1.5,-40.5,70,30,3.5,-40,100,30,-27,-7]
["zone F",-48.5,1.5,-30,2,-50.5,2,-90,2,2,-31]
[]
[]
["price",11,22,33,44,55,66,77,88,"00","AVG",null,null,"Clearing Price [EUR/MWh]"]
["zone A",0,0,0,0,0,0,0,0,0,0,null,null,null,"zone A","zone B","zone C","zone D","zone E","zone F"]
["zone B",31.8,40,46,49.9,28.3,34.799999999999997,21.5,34.299999999999997,39,32.9,null,null,11,0,31.8,33.799999999999997,0,42.1,42.1]
["zone C",33.799999999999997,41,51.5,60.5,28.3,34.799999999999997,21.5,34.299999999999997,40.799999999999997,34.4,null,null,22,0,40,41,0,51,37.6]
["zone D",0,0,0,0,0,0,0,0,0,0,null,null,33,0,46,51.5,0,51.5,51.6]
["zone E",42.1,51,51.5,60.5,38.4,42.7,21.5,34.299999999999997,52.6,43.1,null,null,44,0,49.9,60.5,0,60.5,39.200000000000003]
["zone F",42.1,37.6,51.6,39.200000000000003,38.6,30.3,26.4,29.1,34.1,43.5,null,null,55,0,28.3,28.3,0,38.4,38.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,66,0,34.799999999999997,34.799999999999997,0,42.7,30.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,77,0,21.5,21.5,0,21.5,26.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,88,0,34.299999999999997,34.299999999999997,0,34.299999999999997,29.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"00",0,39,40.799999999999997,0,52.6,34.1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["AVG",0,32.9,34.4,0,43.1,43.5]

{"sheet":"algorithm","index":12,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[4,4,7,4]]}
["macro name","shortcut",null,null,"algorithm"]
["flowComputation","A",null,null,null,"D"]
["inputChange","B",null,null,null,"A"]
["outputCopy","C",null,null,null,"C"]
["referenceCopy","D",null,null,"for all zones","D"]
["ptdf","E",null,null,null,"B (i)"]
[null,null,null,null,null,"A"]
[null,null,null,null,null,"C (i)"]
[null,null,null,null,null,"E"]
[]
[]
[]
[]
[]
[]
[]
["for right working of the computation the sheet \"nodes\" has to be renamed to \"hubs\""]

{"sheet":"cwe example","index":13,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Zone","Net Position [MW]","Clearing Price [EUR/MWh]"]
[null,"BE",-1317.6,49.29,null,null,{"$f":"-SUMPRODUCT(C3:C6,D3:D6)","v":50938.852000000014}]
[null,"FR",-1331.9,45.59,null,null,{"$f":"G3/SUM(C26:C30)","v":0.86474376185526969}]
[null,"DE",5434.8,39.96]
[null,"NL",-2784.9,51.15]
[]
[]
[null,"Zone","Net Position [MW]","Clearing Price [EUR/MWh]"]
[null,"BE",-1912.6,49.29]
[null,"FR",-756.9,45.59]
[null,"DE",5754.4,39.96]
[null,"NL",-3084.9,51.15]
[]
[]
["Border","Type","$AAF_{ij}$ [MW]","delta abs CP [EUR/MWh]","share"]
["BE-FR","int",-1299.5999999999999,{"$f":"D3-D4","v":3.6999999999999957},{"$f":"ABS(C17)/$C$22","v":0.16950567366636232}]
["FR-DE","int",-1049.4000000000001,{"$f":"D4-D5","v":5.6300000000000026},{"$f":"ABS(C18)/$C$22","v":0.13687230989956958}]
["DE-NL","int",3697.9,{"$f":"D6-D5","v":11.189999999999998},0.48231381244293725]
["NL-BE","int",613,{"$f":"D6-D3","v":1.8599999999999994},7.9953045519760013E-2]
["FR-DE","ext",-1007.1,{"$f":"D18","v":5.6300000000000026},0.1313551584713708]
["sum",null,{"$f":"SUM(ABS(C17)+ABS(C18)+ABS(C19)+ABS(C20)+ABS(C21))","v":7667}]
[]
[null,null,"Congestion Income"]
["Border","Type","unscaled","scaled","ext","ext"]
["BE-FR","int",{"$f":"ABS(C17*D17)","v":4808.5199999999941},{"$f":"C26*$G$4","v":4158.137673756296},{"$f":"0.5*$D$30*E17","v":415.54941219619792},{"$f":"0.5*$D$37*E17","v":195.92091082669228}]
["FR-DE","int",{"$f":"ABS(C18*D18)","v":5908.122000000003},{"$f":"C27*$G$4","v":5109.0116437798824},{"$f":"0.5*$D$30*E18","v":335.54751705039257},{"$f":"0.5*$D$37*E18","v":158.20206511352023}]
["DE-NL","int",{"$f":"ABS(C19*D19)","v":41379.500999999989},35782.665358433886,{"$f":"0.5*$D$30*E19","v":1182.4101041553713},{"$f":"0.5*$D$37*E19","v":557.47609737305743}]
["NL-BE","int",{"$f":"ABS(C20*D20)","v":1140.1799999999996},985.96354239214111,{"$f":"0.5*$D$30*E20","v":196.00784062501489},{"$f":"0.5*$D$37*E20","v":92.412679545061849}]
["FR-DE","ext",{"$f":"ABS(C21*D21)","v":5669.9730000000027},4903.0737816378114,{"$f":"0.5*$D$30*E21","v":322.02201679192905},{"$f":"0.5*$D$37*E21","v":151.82513796057387}]
[]
[null,"Zone","Resale Costs [EUR]","CI after RC [EUR]"]
[null,"BE",{"$f":"2073.81+443.8+0.73","v":2518.34},{"$f":"C43-C33","v":53.710608074218271}]
[null,"FR",{"$f":"2073.81+1374.1+17.53+17.79","v":3483.23},{"$f":"C44-C34","v":1150.3446587680896}]
[null,"DE",{"$f":"4191.2+1374.1+17.53+202.89+16.54","v":5802.2599999999993},14643.578501106884]
[null,"NL",{"$f":"4712.5+443.8+195.18+0.73","v":5352.21},13032.104450413015]
[null,"external",{"$f":"1253.2+1338.2","v":2591.4},{"$f":"D30-C37","v":2311.6737816378113}]
[]
[]
[]
[]
[null,"Zone","CI - internal","CI - external","CI"]
[null,"BE",{"$f":"0.5*D26+0.5*D29","v":2572.0506080742184},{"$f":"0.5*E26+0.5*E29","v":305.77862641060642},{"$f":"C43+D43","v":2877.8292344848251}]
[null,"FR",{"$f":"0.5*D26+0.5*D27","v":4633.5746587680896},{"$f":"0.5*E27+0.5*E26+0.25*D30+0.5*E30","v":1762.3279184287128},{"$f":"C44+D44","v":6395.9025771968027}]
[null,"DE",{"$f":"0.5*D27+0.5*D28","v":20445.838501106882},{"$f":"0.5*E27+0.5*E28+0.25*D30+0.5*E30","v":2145.7582644082991},22591.59676551518]
[null,"NL",{"$f":"0.5*D28+0.5*D29","v":18384.314450413014},{"$f":"0.5*E28+0.5*E29","v":689.20897239019314},19073.523422803206]
[]
[null,null,"Congestion Income"]
[null,"Zone","internal","external","total"]
[null,"BE",{"$f":"D33","v":53.710608074218271},{"$f":"0.5*F26+0.5*F29","v":144.16679518587705},{"$f":"C50+D50","v":197.87740326009532}]
[null,"FR",{"$f":"D34","v":1150.3446587680896},{"$f":"0.5*F27+0.5*F26+0.25*D37+0.5*F30","v":830.89250235984593},{"$f":"C51+D51","v":1981.2371611279355}]
[null,"DE",14643.578501106884,{"$f":"0.5*F27+0.5*F28+0.25*D37+0.5*F30","v":1011.6700956330286},15655.248596739912]
[null,"NL",13032.104450413015,{"$f":"0.5*F28+0.5*F29","v":324.94438845905961},13357.048838872075]