{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Elolap","Tamogatastartalom","Szamitasok","Adatok"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":59,"comments":1,"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":"Elolap","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Tamogatastartalom","index":1,"n_rows":126,"n_cols":46,"rows_kept":126,"cut":false,"hidden":false,"merged":[[0,20,1,21],[0,12,1,13],[3,1,3,2],[5,1,5,2],[7,5,9,5],[3,4,4,4],[2,20,3,20],[2,21,3,21],[2,40,2,42],[2,22,2,25],[2,27,2,31],[2,12,3,12],[2,13,3,13],[2,37,2,39]]}
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(N7:N126)<C14,\"A folyósítások összege kevesebb, mint a hitelösszeg\",\"A folyósítások összege több, mint a hitelösszeg\")","v":"A folyósítások összege kevesebb, mint a hitelösszeg"},null,null,null,null,null,null,null,{"$f":"IF(SUM(V7:V126)<C14,\"A törlesztések összege kevesebb, mint a hitelösszeg\",\"A törlesztések összege több, mint a hitelösszeg\")","v":"A törlesztések összege kevesebb, mint a hitelösszeg"}]
[]
[null,"Ügyfél neve: ",null,null,null,null,null,"EUR","HUF",null,null,null,"Egyedi folyósítás dátuma","Folyósítás összege",null,null,null,null,null,null,"Egyedi törlesztés dátuma","Tőkeamortizáció egyedi törlesztés esetén","periódusközi kamatszámítás",null,null,null,null,"maradék kamatszámítás",null,null,null,null,null,null,null,null,null,"Minimum kamat 2.3",null,null,"Támogatott konstruckió",null,null,null,"Támogatástartalom (min 2.3)"]
[null,null,null,-0.04,null,"Hitelösszeg (EUR)",null,{"$f":"IF(C9=\"HUF\",C14/C10,C14)","v":1250},{"$f":"IF(C9=\"HUF\",C14,C14*arfolyam)","v":500000},null,null,null,null,null,null,null,"kamat (min 2.3)","támogatott",null,null,null,null,"dátumtól","tőke","kamat (min 2.3)","támogatott",null,"dátumtól","amort","tőke","maradék (min 2.3)","t maradék",null,null,null,"Periodus","Dátum","Tőke","Tőkeamt.","Kamatfiz.","Tőke","Tőkeamt.","Kamatfiz.",null,"FV"]
[null,"Pénzügyi intézmény neve refinanszírozás esetén: ",null,{"$f":"IF(C13=\"Halászati\",J10,IF(C13=\"Mezőgazdasági\",J9,J8))","v":250000},null,"Ténylegesen felvett hitel támogatástartalma 2.1",null,{"$f":"IF(C9=\"HUF\",AS5/C10,AS5)","v":46.364594309799813},{"$f":"IF(C9=\"HUF\",AS5,AS5*C10)","v":18545.837723919925},{"$f":"IFERROR(IF(D5-H5<=0,\"Nem elegendő a 2.1 szabad keret\",\"Elegendő a 2.1 szabad keret\"),\"\")","v":"Elegendő a 2.1 szabad keret"},null,null,null,null,null,null,{"$f":"SUM(Q7:Q126)","v":-4372.6027397260277},{"$f":"SUM(R7:R126)","v":-1917.8082191780823},null,null,null,null,null,null,{"$f":"SUM(Y7:Y126)","v":0},{"$f":"SUM(Z7:Z126)","v":0},null,null,null,null,{"$f":"SUM(AE7:AE126)","v":-33034.77344573236},{"$f":"SUM(AF7:AF126)","v":-14488.935721812441},null,null,null,null,null,{"$f":"+AL7","v":500000},{"$f":"SUM(AM7:AM126)","v":-499999.99999999988},{"$f":"SUM(AN7:AN126)","v":-33034.77344573236},{"$f":"+AO7","v":500000},{"$f":"SUM(AP7:AP126)","v":-499999.99999999988},{"$f":"SUM(AQ7:AQ126)","v":-14488.935721812441},null,{"$f":"SUM(AS7:AS126)","v":18545.837723919925}]
[null,null,null,null,null,null,null,null,null,null,"Törlesztésiidőszak vége?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"MAX(C17,MIN(M7:M126))","v":"2023-02-01"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AJ7>$D$15","v":false},null,null,null,{"$f":"C17","v":"2023-02-01"},{"$f":"IF(ISBLANK(M7),C14,0)","v":500000},{"$f":"IF(AND(ISBLANK(M6),AI7<>1),0,IFERROR(-P7*minkamat23/365*(IF(ISBLANK(M7),$C$18,M7)-O7),\"\"))","v":-4372.6027397260277},{"$f":"IF(AND(ISBLANK(M6),AI7<>1),0,IFERROR(-P7*tenylegeskamat/365*(IF(ISBLANK(M7),$C$18,M7)-O7),\"\"))","v":-1917.8082191780823},{"$f":"IFERROR(IF(ISBLANK(M7),$C$18,M7)-O7,\"\")","v":28},null,null,null,{"$f":"IF(ISNA(MAX(U6,INDEX(AK$6:AK$126,MATCH(U7-1,AK$6:AK$126,1)))),\"\",MAX(U6,INDEX(AK$6:AK$126,MATCH(U7-1,AK$6:AK$126,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(X6),X6=\"\"),INDEX(AL$7:AL$126,MATCH(U7,AK$7:AK$126,1)),X6-V6),INDEX(AL$7:AL$126,MATCH(U7,AK$7:AK$126,1)))),\"\",MIN(IF(OR(ISBLANK(X6),X6=\"\"),INDEX(AL$7:AL$126,MATCH(U7,AK$7:AK$126,1)),X6-V6),INDEX(AL$7:AL$126,MATCH(U7,AK$7:AK$126,1))))","v":""},{"$f":"IFERROR(-X7*minkamat23/365*(U7-W7),\"\")","v":""},{"$f":"IFERROR(-X7*tenylegeskamat/365*(U7-W7),\"\")","v":""},{"$f":"IFERROR(U7-W7,\"\")","v":""},{"$f":"MAX(AK6,IF(ISNA(INDEX(U$7:U$126,MATCH(AK7,U$7:U$126,1))),0,INDEX(U$7:U$126,MATCH(AK7,U$7:U$126,1))))","v":"2023-02-01"},{"$f":"IF(ISNA(INDEX(V$7:V$126,MATCH(AK7,U$7:U$126,1))),0,INDEX(V$7:V$126,MATCH(AK7,U$7:U$126,1)))","v":0},{"$f":"IF(ISNA(INDEX(X$7:X$126,MATCH(AK7,U$7:U$126,1))),AL7,INDEX(X$7:X$126,MATCH(AK7,U$7:U$126,1)))","v":500000},{"$f":"IFERROR(-(AD7-AC7)*minkamat23/365*(AK7-AB7),0)","v":-4372.6027397260277},{"$f":"IFERROR(-(AD7-AC7)*tenylegeskamat/365*(AK7-AB7),0)","v":-1917.8082191780823},{"$f":"IFERROR(AK7-AB7,\"\")","v":28},null,1,{"$f":"+IF(C19-C18<>0,1,\"\")","v":1},{"$f":"C18","v":"2023-03-01"},{"$f":"IF(+C14<>0,C14,IF(AJ7>0,C14*K7,\"\"))","v":500000},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK6,U$7:U$126,\"<=\"&AK7),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL7)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},{"$f":"SUM(Q7:Q126)","v":-4372.6027397260277},{"$f":"AL7","v":500000},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK6,U$7:U$126,\"<=\"&AK7),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO7)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},{"$f":"SUM(R7:R126)","v":-1917.8082191780823},null,{"$f":"IFERROR(MAX((ABS(AN7)-ABS(AQ7)),0),\"\")","v":2454.7945205479455},{"$f":"IFERROR(AK7-AK6,\"\")","v":28}]
[null,"HITELKARAKTERISZTIKA",null,null,null,"Válságkezelési közlemény 2.1 alapján megítélt támogatásokon felül igénybe vehető szabad keret (EUR)","Általános szabály",null,null,{"$f":"IF(2000000-C27-C28-C29<=0,\"Nincs szabad keret, nem finanszírozható\",2000000-C27-C28-C29)","v":2000000},false,null,null,null,{"$f":"IF(ISBLANK(M7),\"\",M7)","v":""},{"$f":"IF(ISBLANK(M7),0,N7+P7)","v":0},0,0,"",null,null,null,"","","","","","2023-03-01",0,461538.46153846156,-4468.7038988408858,-1959.9578503688094,31,null,2,{"$f":"IF(COUNT(AK8)=1,AJ7+1,\"\")","v":2},{"$f":"IF(OR(AK7=$C$19,AK7=\"\"),\"\",IFERROR(IF(EDATE($C$18,(AI8-1)*12/$D$19)<=$C$19,EDATE($C$18,(AI8-1)*12/$D$19),$C$19),\"\"))","v":"2023-04-01"},{"$f":"+IF(COUNT(AL7)<>0,SUM(AL7:AM7)*(1-K8),\"\")","v":461538.46153846156},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK7,U$7:U$126,\"<=\"&AK8),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL8)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Y$7:Y$126,U$7:U$126,\">\"&AK7,U$7:U$126,\"<=\"&AK8)+AE8,IFERROR(-AL8*minkamat23/365*(AK8-AK7),\"\"))","v":-4468.7038988408858},{"$f":"+IF(COUNT(AO7)<>0,SUM(AO7:AP7)*(1-K8),\"\")","v":461538.46153846156},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK7,U$7:U$126,\"<=\"&AK8),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO8)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Z$7:Z$126,U$7:U$126,\">\"&AK7,U$7:U$126,\"<=\"&AK8)+AF8,IFERROR(-AO8*tenylegeskamat/365*(AK8-AK7),\"\"))","v":-1959.9578503688094},null,{"$f":"IFERROR(MAX((ABS(AN8)-ABS(AQ8)),0),\"\")","v":2508.7460484720764},31]
[null,"Hitel devizaneme","HUF","Makrohoz kellenek (ne töröld ki!):",null,null,"Mezőgazdasági szabály",null,null,{"$f":"IF(mezogazdkizarok=0,\"Nem releváns\",IF(MIN(250000-C27,2000000-C27-C28-C29,300000-C27-C28)<=0,\"Nincs szabad keret, nem finanszírozható\",MIN(250000-C27,2000000-C27-C28-C29,300000-C27-C28)))","v":250000},false,null,null,null,{"$f":"IF(ISBLANK(M8),\"\",M8)","v":""},{"$f":"IF(ISBLANK(M8),0,N8+P8)","v":0},0,0,"",null,null,null,"","","","","","2023-04-01",0,423076.92307692312,-3964.1728134878826,-1738.6722866174923,30,null,3,{"$f":"IF(COUNT(AK9)=1,AJ8+1,\"\")","v":3},"2023-05-01",423076.92307692312,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK8,U$7:U$126,\"<=\"&AK9),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL9)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-3964.1728134878826,423076.92307692312,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK8,U$7:U$126,\"<=\"&AK9),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO9)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-1738.6722866174923,null,2225.5005268703903,30]
[null,"HUF/EUR árfolyam",400,null,null,null,"Halászati szabály",null,null,{"$f":"IF(halaszatikizarok=0,\"Nem releváns\",IF(MIN(300000-C28,2000000-C27-C28-C29,300000-C27-C28)<=0,\"Nincs szabad keret, nem finanszírozható\",MIN(300000-C28,2000000-C27-C28-C29,300000-C27-C28)))","v":"Nem releváns"},false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-05-01",0,384615.38461538468,-3723.9199157007388,-1633.2982086406746,31,null,4,{"$f":"IF(COUNT(AK10)=1,AJ9+1,\"\")","v":4},"2023-06-01",384615.38461538468,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK9,U$7:U$126,\"<=\"&AK10),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL10)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-3723.9199157007388,384615.38461538468,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK9,U$7:U$126,\"<=\"&AK10),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO10)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-1633.2982086406746,null,2090.6217070600642,31]
[null,"Hitel fajtája","Nem rulírozó",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-06-01",0,346153.84615384624,-3243.4141201264501,-1422.5500526870392,30,null,5,5,"2023-07-01",346153.84615384624,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK10,U$7:U$126,\"<=\"&AK11),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL11)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-3243.4141201264501,346153.84615384624,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK10,U$7:U$126,\"<=\"&AK11),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO11)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-1422.5500526870392,null,1820.864067439411,30]
[null,"Vállalat mérete","KKV",1E-4,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-07-01",0,307692.3076923078,-2979.1359325605918,-1306.63856691254,31,null,6,6,"2023-08-01",307692.3076923078,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK11,U$7:U$126,\"<=\"&AK12),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL12)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-2979.1359325605918,307692.3076923078,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK11,U$7:U$126,\"<=\"&AK12),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO12)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-1306.63856691254,null,1672.4973656480518,31]
[null,"Válságkezelési közlemény 2.1 szakasza szerinti ágazat (a hitel céljához kapcsolódó TEÁOR alapján) ","Mezőgazdasági",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-08-01",0,269230.76923076937,-2606.7439409905178,-1143.3087460484728,31,null,7,7,"2023-09-01",269230.76923076937,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK12,U$7:U$126,\"<=\"&AK13),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL13)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-2606.7439409905178,269230.76923076937,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK12,U$7:U$126,\"<=\"&AK13),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO13)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-1143.3087460484728,null,1463.435194942045,31]
[null,{"$f":"\"Hitelösszeg (\"&C9&\")\"","v":"Hitelösszeg (HUF)"},500000,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-09-01",0,230769.2307692309,-2162.2760800843007,-948.36670179136001,30,null,8,8,"2023-10-01",230769.2307692309,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK13,U$7:U$126,\"<=\"&AK14),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL14)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-2162.2760800843007,230769.2307692309,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK13,U$7:U$126,\"<=\"&AK14),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO14)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-948.36670179136001,null,1213.9093782929408,30]
[null,{"$f":"IF(OR(C15<6,C15>D24),\"Minimum 6 hónap, maximum \"&D24&\" hónap lehet\",\"Futamidő (hónap)\")","v":"Futamidő (hónap)"},12,{"$f":"COUNT(AJ7:AJ126)","v":13},null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-10-01",0,192307.69230769243,-1861.9599578503701,-816.64910432033787,31,null,9,9,"2023-11-01",192307.69230769243,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK14,U$7:U$126,\"<=\"&AK15),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL15)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-1861.9599578503701,192307.69230769243,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK14,U$7:U$126,\"<=\"&AK15),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO15)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-816.64910432033787,null,1045.3108535300321,31]
[null,"Hitel jóváhagyásának várható időpontja (EXIM döntés dátuma)","2023-01-01",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-11-01",0,153846.15384615396,-1441.5173867228673,-632.24446786090675,30,null,10,{"$f":"IF(COUNT(AK16)=1,AJ15+1,\"\")","v":10},"2023-12-01",153846.15384615396,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK15,U$7:U$126,\"<=\"&AK16),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL16)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-1441.5173867228673,153846.15384615396,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK15,U$7:U$126,\"<=\"&AK16),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO16)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-632.24446786090675,null,809.27291886196053,30]
[null,{"$f":"\"Szerződéskötés várható dátuma\"&IF(C17>DATE(2023,12,31),\" - Nem lehet későbbi, mint 2023.12.31\",\"\")","v":"Szerződéskötés várható dátuma"},"2023-02-01",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-12-01",0,115384.61538461549,-1117.1759747102224,-489.98946259220281,31,null,11,{"$f":"IF(COUNT(AK17)=1,AJ16+1,\"\")","v":11},"2024-01-01",115384.61538461549,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK16,U$7:U$126,\"<=\"&AK17),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL17)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-1117.1759747102224,115384.61538461549,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK16,U$7:U$126,\"<=\"&AK17),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO17)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-489.98946259220281,null,627.18651211801955,31]
[null,{"$f":"IF(C18>C19,\"Nem lehet későbbi, mint a végső lejárat!\",\"Első törlesztés várható dátuma\")","v":"Első törlesztés várható dátuma"},"2023-03-01",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2024-01-01",0,76923.076923077024,-744.78398314014839,-326.65964172813528,31,null,12,12,"2024-02-01",76923.076923077024,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK17,U$7:U$126,\"<=\"&AK18),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL18)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-744.78398314014839,76923.076923077024,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK17,U$7:U$126,\"<=\"&AK18),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO18)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-326.65964172813528,null,418.12434141201311,31]
[null,{"$f":"IF(C19>EDATE(C17,D24),\"A futamidő nem haladhatja meg a \"&D24&\" hónapot\",\"Hitel végső lejáratának várható dátuma\")","v":"Hitel végső lejáratának várható dátuma"},"2024-03-01",{"$f":"VLOOKUP($C$24,Adatok!P3:Q5,2,0)","v":12},null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2024-02-01",0,38461.538461538563,-348.3667017913603,-152.7924130663861,29,null,13,13,"2024-03-01",38461.538461538563,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK18,U$7:U$126,\"<=\"&AK19),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL19)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-348.3667017913603,38461.538461538563,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK18,U$7:U$126,\"<=\"&AK19),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO19)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":-38461.538461538461},-152.7924130663861,null,195.5742887249742,29]
[null,{"$f":"IF(AND(tenylegeskamat>=D21,tenylegeskamat<=D22),\"Tényleges ügyleti kamat\",\"Nem megfelelő kamatérték!\")","v":"Tényleges ügyleti kamat"},0.05,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2024-03-01",0,0,0,0,"",null,14,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK19,U$7:U$126,\"<=\"&AK20),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL20)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK19,U$7:U$126,\"<=\"&AK20),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO20)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,"Minimum kamat 2.3 alapján",{"$f":"IF(C9=\"EUR\",OFFSET(Adatok!$I$18,MATCH(C12,Adatok!$I$19:$I$20,0),MATCH(C15,Adatok!$J$18:$P$18,1),),OFFSET(Adatok!$I$21,MATCH(C12,Adatok!$I$19:$I$20,0),MATCH(C15,Adatok!$J$18:$P$18,1),))","v":0.114},{"$f":"IF(C9=\"EUR\",Adatok!J14,Adatok!K14)","v":3.5000000000000003E-2},null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,15,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK20,U$7:U$126,\"<=\"&AK21),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL21)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK20,U$7:U$126,\"<=\"&AK21),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO21)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,"Támogatás jogalapja",{"$f":"IF(tenylegeskamat>=minkamat23,\"2.3 szerinti\",\"2.1 szerinti\")","v":"2.1 szerinti"},{"$f":"IF(C9=\"EUR\",Adatok!J15,Adatok!K15)","v":0.06},null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,16,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK21,U$7:U$126,\"<=\"&AK22),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL22)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK21,U$7:U$126,\"<=\"&AK22),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO22)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,"Törlesztés módja","Egyenlő tőke",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,17,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK22,U$7:U$126,\"<=\"&AK23),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL23)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK22,U$7:U$126,\"<=\"&AK23),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO23)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,{"$f":"IF(torlesztes=\"Egyenlő tőke\",\"Kamatfizetés/tőketörlesztés gyakorisága\",\"Kamatfizetés gyakorisága\")","v":"Kamatfizetés/tőketörlesztés gyakorisága"},"Havi",{"$f":"IF(C11=\"Rulírozó\",24,36)","v":36},null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,18,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK23,U$7:U$126,\"<=\"&AK24),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL24)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK23,U$7:U$126,\"<=\"&AK24),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO24)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,19,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK24,U$7:U$126,\"<=\"&AK25),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL25)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK24,U$7:U$126,\"<=\"&AK25),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO25)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,"Nem azonos elszámolható költségekre megítélt Válságkezelési Közlemény 2.1 szerinti állami támogatások",null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,20,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK25,U$7:U$126,\"<=\"&AK26),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL26)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK25,U$7:U$126,\"<=\"&AK26),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO26)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,"Mezőgazdasági ágazatra megítélt támogatás teljes összege (EUR):",0,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,21,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK26,U$7:U$126,\"<=\"&AK27),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL27)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK26,U$7:U$126,\"<=\"&AK27),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO27)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,"Halászati, akvakultúra ágazatra  megítélt támogatás teljes összeg (EUR):",0,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,22,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK27,U$7:U$126,\"<=\"&AK28),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL28)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK27,U$7:U$126,\"<=\"&AK28),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO28)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,"Egyéb ágazatra megítélt támogatás tejes összege (EUR):",0,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,23,{"$f":"IF(COUNT(AK29)=1,AJ28+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK28,U$7:U$126,\"<=\"&AK29),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL29)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK28,U$7:U$126,\"<=\"&AK29),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO29)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,24,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK29,U$7:U$126,\"<=\"&AK30),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL30)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK29,U$7:U$126,\"<=\"&AK30),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO30)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,25,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK30,U$7:U$126,\"<=\"&AK31),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL31)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK30,U$7:U$126,\"<=\"&AK31),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO31)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,26,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK31,U$7:U$126,\"<=\"&AK32),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL32)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK31,U$7:U$126,\"<=\"&AK32),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO32)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,27,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK32,U$7:U$126,\"<=\"&AK33),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL33)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK32,U$7:U$126,\"<=\"&AK33),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO33)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,28,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK33,U$7:U$126,\"<=\"&AK34),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL34)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK33,U$7:U$126,\"<=\"&AK34),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO34)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,29,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK34,U$7:U$126,\"<=\"&AK35),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL35)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK34,U$7:U$126,\"<=\"&AK35),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO35)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,30,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK35,U$7:U$126,\"<=\"&AK36),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL36)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK35,U$7:U$126,\"<=\"&AK36),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO36)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,31,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK36,U$7:U$126,\"<=\"&AK37),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL37)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK36,U$7:U$126,\"<=\"&AK37),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO37)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,32,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK37,U$7:U$126,\"<=\"&AK38),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL38)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK37,U$7:U$126,\"<=\"&AK38),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO38)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AJ39>$D$15","v":true},null,null,null,"",0,{"$f":"IF(AND(ISBLANK(M38),AI39<>1),0,IFERROR(-P39*minkamat23/365*(IF(ISBLANK(M39),$C$18,M39)-O39),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(M38),AI39<>1),0,IFERROR(-P39*tenylegeskamat/365*(IF(ISBLANK(M39),$C$18,M39)-O39),\"\"))","v":0},{"$f":"IFERROR(IF(ISBLANK(M39),$C$18,M39)-O39,\"\")","v":""},null,null,null,{"$f":"IF(ISNA(MAX(U38,INDEX(AK$6:AK$126,MATCH(U39-1,AK$6:AK$126,1)))),\"\",MAX(U38,INDEX(AK$6:AK$126,MATCH(U39-1,AK$6:AK$126,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(X38),X38=\"\"),INDEX(AL$7:AL$126,MATCH(U39,AK$7:AK$126,1)),X38-V38),INDEX(AL$7:AL$126,MATCH(U39,AK$7:AK$126,1)))),\"\",MIN(IF(OR(ISBLANK(X38),X38=\"\"),INDEX(AL$7:AL$126,MATCH(U39,AK$7:AK$126,1)),X38-V38),INDEX(AL$7:AL$126,MATCH(U39,AK$7:AK$126,1))))","v":""},{"$f":"IFERROR(-X39*minkamat23/365*(U39-W39),\"\")","v":""},{"$f":"IFERROR(-X39*tenylegeskamat/365*(U39-W39),\"\")","v":""},{"$f":"IFERROR(U39-W39,\"\")","v":""},{"$f":"MAX(AK38,IF(ISNA(INDEX(U$7:U$126,MATCH(AK39,U$7:U$126,1))),0,INDEX(U$7:U$126,MATCH(AK39,U$7:U$126,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(V$7:V$126,MATCH(AK39,U$7:U$126,1))),0,INDEX(V$7:V$126,MATCH(AK39,U$7:U$126,1)))","v":0},{"$f":"IF(ISNA(INDEX(X$7:X$126,MATCH(AK39,U$7:U$126,1))),AL39,INDEX(X$7:X$126,MATCH(AK39,U$7:U$126,1)))","v":0},{"$f":"IFERROR(-(AD39-AC39)*minkamat23/365*(AK39-AB39),0)","v":0},{"$f":"IFERROR(-(AD39-AC39)*tenylegeskamat/365*(AK39-AB39),0)","v":0},{"$f":"IFERROR(AK39-AB39,\"\")","v":""},null,33,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK38,U$7:U$126,\"<=\"&AK39),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL39)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK38,U$7:U$126,\"<=\"&AK39),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO39)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",{"$f":"IFERROR(AK39-AK38,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,34,"",{"$f":"IF(OR(AK39=$C$19,AK39=\"\"),\"\",IFERROR(IF(EDATE($C$18,(AI40-1)*12/$D$19)<=$C$19,EDATE($C$18,(AI40-1)*12/$D$19),$C$19),\"\"))","v":""},{"$f":"+IF(COUNT(AL39)<>0,SUM(AL39:AM39)*(1-K40),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK39,U$7:U$126,\"<=\"&AK40),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL40)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Y$7:Y$126,U$7:U$126,\">\"&AK39,U$7:U$126,\"<=\"&AK40)+AE40,IFERROR(-AL40*minkamat23/365*(AK40-AK39),\"\"))","v":""},{"$f":"+IF(COUNT(AO39)<>0,SUM(AO39:AP39)*(1-K40),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK39,U$7:U$126,\"<=\"&AK40),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO40)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Z$7:Z$126,U$7:U$126,\">\"&AK39,U$7:U$126,\"<=\"&AK40)+AF40,IFERROR(-AO40*tenylegeskamat/365*(AK40-AK39),\"\"))","v":""},null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,35,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK40,U$7:U$126,\"<=\"&AK41),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL41)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK40,U$7:U$126,\"<=\"&AK41),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO41)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,36,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK41,U$7:U$126,\"<=\"&AK42),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL42)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK41,U$7:U$126,\"<=\"&AK42),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO42)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,37,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK42,U$7:U$126,\"<=\"&AK43),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL43)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK42,U$7:U$126,\"<=\"&AK43),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO43)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,38,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK43,U$7:U$126,\"<=\"&AK44),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL44)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK43,U$7:U$126,\"<=\"&AK44),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO44)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",{"$f":"IF(ISBLANK(M44),0,N44+P44)","v":0},0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,39,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK44,U$7:U$126,\"<=\"&AK45),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL45)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK44,U$7:U$126,\"<=\"&AK45),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO45)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,40,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK45,U$7:U$126,\"<=\"&AK46),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL46)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK45,U$7:U$126,\"<=\"&AK46),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO46)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",{"$f":"IF(ISBLANK(M46),0,N46+P46)","v":0},0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,41,{"$f":"IF(COUNT(AK47)=1,AJ46+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK46,U$7:U$126,\"<=\"&AK47),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL47)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK46,U$7:U$126,\"<=\"&AK47),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO47)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,42,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK47,U$7:U$126,\"<=\"&AK48),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL48)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK47,U$7:U$126,\"<=\"&AK48),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO48)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,43,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK48,U$7:U$126,\"<=\"&AK49),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL49)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK48,U$7:U$126,\"<=\"&AK49),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO49)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,44,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK49,U$7:U$126,\"<=\"&AK50),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL50)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK49,U$7:U$126,\"<=\"&AK50),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO50)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,45,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK50,U$7:U$126,\"<=\"&AK51),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL51)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK50,U$7:U$126,\"<=\"&AK51),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO51)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,46,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK51,U$7:U$126,\"<=\"&AK52),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL52)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK51,U$7:U$126,\"<=\"&AK52),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO52)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,47,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK52,U$7:U$126,\"<=\"&AK53),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL53)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK52,U$7:U$126,\"<=\"&AK53),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO53)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,48,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK53,U$7:U$126,\"<=\"&AK54),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL54)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK53,U$7:U$126,\"<=\"&AK54),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO54)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,49,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK54,U$7:U$126,\"<=\"&AK55),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL55)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK54,U$7:U$126,\"<=\"&AK55),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO55)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,50,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK55,U$7:U$126,\"<=\"&AK56),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL56)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK55,U$7:U$126,\"<=\"&AK56),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO56)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,51,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK56,U$7:U$126,\"<=\"&AK57),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL57)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK56,U$7:U$126,\"<=\"&AK57),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO57)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,52,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK57,U$7:U$126,\"<=\"&AK58),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL58)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK57,U$7:U$126,\"<=\"&AK58),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO58)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,53,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK58,U$7:U$126,\"<=\"&AK59),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL59)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK58,U$7:U$126,\"<=\"&AK59),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO59)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,54,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK59,U$7:U$126,\"<=\"&AK60),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL60)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK59,U$7:U$126,\"<=\"&AK60),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO60)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,55,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK60,U$7:U$126,\"<=\"&AK61),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL61)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK60,U$7:U$126,\"<=\"&AK61),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO61)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,56,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK61,U$7:U$126,\"<=\"&AK62),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL62)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK61,U$7:U$126,\"<=\"&AK62),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO62)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,57,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK62,U$7:U$126,\"<=\"&AK63),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL63)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK62,U$7:U$126,\"<=\"&AK63),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO63)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,58,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK63,U$7:U$126,\"<=\"&AK64),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL64)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK63,U$7:U$126,\"<=\"&AK64),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO64)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,59,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK64,U$7:U$126,\"<=\"&AK65),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL65)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK64,U$7:U$126,\"<=\"&AK65),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO65)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,60,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK65,U$7:U$126,\"<=\"&AK66),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL66)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK65,U$7:U$126,\"<=\"&AK66),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO66)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,61,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK66,U$7:U$126,\"<=\"&AK67),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL67)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK66,U$7:U$126,\"<=\"&AK67),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO67)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,62,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK67,U$7:U$126,\"<=\"&AK68),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL68)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK67,U$7:U$126,\"<=\"&AK68),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO68)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,63,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK68,U$7:U$126,\"<=\"&AK69),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL69)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK68,U$7:U$126,\"<=\"&AK69),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO69)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,64,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK69,U$7:U$126,\"<=\"&AK70),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL70)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK69,U$7:U$126,\"<=\"&AK70),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO70)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AJ71>$D$15","v":true},null,null,null,"",0,{"$f":"IF(AND(ISBLANK(M70),AI71<>1),0,IFERROR(-P71*minkamat23/365*(IF(ISBLANK(M71),$C$18,M71)-O71),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(M70),AI71<>1),0,IFERROR(-P71*tenylegeskamat/365*(IF(ISBLANK(M71),$C$18,M71)-O71),\"\"))","v":0},{"$f":"IFERROR(IF(ISBLANK(M71),$C$18,M71)-O71,\"\")","v":""},null,null,null,{"$f":"IF(ISNA(MAX(U70,INDEX(AK$6:AK$126,MATCH(U71-1,AK$6:AK$126,1)))),\"\",MAX(U70,INDEX(AK$6:AK$126,MATCH(U71-1,AK$6:AK$126,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(X70),X70=\"\"),INDEX(AL$7:AL$126,MATCH(U71,AK$7:AK$126,1)),X70-V70),INDEX(AL$7:AL$126,MATCH(U71,AK$7:AK$126,1)))),\"\",MIN(IF(OR(ISBLANK(X70),X70=\"\"),INDEX(AL$7:AL$126,MATCH(U71,AK$7:AK$126,1)),X70-V70),INDEX(AL$7:AL$126,MATCH(U71,AK$7:AK$126,1))))","v":""},{"$f":"IFERROR(-X71*minkamat23/365*(U71-W71),\"\")","v":""},{"$f":"IFERROR(-X71*tenylegeskamat/365*(U71-W71),\"\")","v":""},{"$f":"IFERROR(U71-W71,\"\")","v":""},{"$f":"MAX(AK70,IF(ISNA(INDEX(U$7:U$126,MATCH(AK71,U$7:U$126,1))),0,INDEX(U$7:U$126,MATCH(AK71,U$7:U$126,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(V$7:V$126,MATCH(AK71,U$7:U$126,1))),0,INDEX(V$7:V$126,MATCH(AK71,U$7:U$126,1)))","v":0},{"$f":"IF(ISNA(INDEX(X$7:X$126,MATCH(AK71,U$7:U$126,1))),AL71,INDEX(X$7:X$126,MATCH(AK71,U$7:U$126,1)))","v":0},{"$f":"IFERROR(-(AD71-AC71)*minkamat23/365*(AK71-AB71),0)","v":0},{"$f":"IFERROR(-(AD71-AC71)*tenylegeskamat/365*(AK71-AB71),0)","v":0},{"$f":"IFERROR(AK71-AB71,\"\")","v":""},null,65,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK70,U$7:U$126,\"<=\"&AK71),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL71)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK70,U$7:U$126,\"<=\"&AK71),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO71)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",{"$f":"IFERROR(AK71-AK70,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,66,"",{"$f":"IF(OR(AK71=$C$19,AK71=\"\"),\"\",IFERROR(IF(EDATE($C$18,(AI72-1)*12/$D$19)<=$C$19,EDATE($C$18,(AI72-1)*12/$D$19),$C$19),\"\"))","v":""},{"$f":"+IF(COUNT(AL71)<>0,SUM(AL71:AM71)*(1-K72),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK71,U$7:U$126,\"<=\"&AK72),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL72)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Y$7:Y$126,U$7:U$126,\">\"&AK71,U$7:U$126,\"<=\"&AK72)+AE72,IFERROR(-AL72*minkamat23/365*(AK72-AK71),\"\"))","v":""},{"$f":"+IF(COUNT(AO71)<>0,SUM(AO71:AP71)*(1-K72),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK71,U$7:U$126,\"<=\"&AK72),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO72)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Z$7:Z$126,U$7:U$126,\">\"&AK71,U$7:U$126,\"<=\"&AK72)+AF72,IFERROR(-AO72*tenylegeskamat/365*(AK72-AK71),\"\"))","v":""},null,{"$f":"IFERROR(MAX((ABS(AN72)-ABS(AQ72)),0),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,{"$f":"IF(ISBLANK(M72),\"\",M72)","v":""},0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,67,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK72,U$7:U$126,\"<=\"&AK73),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL73)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK72,U$7:U$126,\"<=\"&AK73),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO73)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,68,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK73,U$7:U$126,\"<=\"&AK74),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL74)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK73,U$7:U$126,\"<=\"&AK74),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO74)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,69,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK74,U$7:U$126,\"<=\"&AK75),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL75)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK74,U$7:U$126,\"<=\"&AK75),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO75)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,70,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK75,U$7:U$126,\"<=\"&AK76),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL76)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK75,U$7:U$126,\"<=\"&AK76),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO76)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,71,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK76,U$7:U$126,\"<=\"&AK77),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL77)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK76,U$7:U$126,\"<=\"&AK77),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO77)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,72,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK77,U$7:U$126,\"<=\"&AK78),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL78)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK77,U$7:U$126,\"<=\"&AK78),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO78)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,73,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK78,U$7:U$126,\"<=\"&AK79),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL79)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK78,U$7:U$126,\"<=\"&AK79),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO79)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,74,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK79,U$7:U$126,\"<=\"&AK80),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL80)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK79,U$7:U$126,\"<=\"&AK80),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO80)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,75,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK80,U$7:U$126,\"<=\"&AK81),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL81)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK80,U$7:U$126,\"<=\"&AK81),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO81)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,76,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK81,U$7:U$126,\"<=\"&AK82),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL82)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK81,U$7:U$126,\"<=\"&AK82),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO82)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,77,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK82,U$7:U$126,\"<=\"&AK83),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL83)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK82,U$7:U$126,\"<=\"&AK83),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO83)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,78,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK83,U$7:U$126,\"<=\"&AK84),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL84)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK83,U$7:U$126,\"<=\"&AK84),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO84)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,79,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK84,U$7:U$126,\"<=\"&AK85),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL85)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK84,U$7:U$126,\"<=\"&AK85),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO85)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,80,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK85,U$7:U$126,\"<=\"&AK86),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL86)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK85,U$7:U$126,\"<=\"&AK86),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO86)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,81,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK86,U$7:U$126,\"<=\"&AK87),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL87)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK86,U$7:U$126,\"<=\"&AK87),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO87)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,82,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK87,U$7:U$126,\"<=\"&AK88),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL88)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK87,U$7:U$126,\"<=\"&AK88),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO88)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,83,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK88,U$7:U$126,\"<=\"&AK89),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL89)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK88,U$7:U$126,\"<=\"&AK89),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO89)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,84,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK89,U$7:U$126,\"<=\"&AK90),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL90)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK89,U$7:U$126,\"<=\"&AK90),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO90)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,85,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK90,U$7:U$126,\"<=\"&AK91),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL91)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK90,U$7:U$126,\"<=\"&AK91),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO91)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,86,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK91,U$7:U$126,\"<=\"&AK92),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL92)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK91,U$7:U$126,\"<=\"&AK92),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO92)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,87,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK92,U$7:U$126,\"<=\"&AK93),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL93)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK92,U$7:U$126,\"<=\"&AK93),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO93)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,88,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK93,U$7:U$126,\"<=\"&AK94),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL94)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK93,U$7:U$126,\"<=\"&AK94),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO94)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,89,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK94,U$7:U$126,\"<=\"&AK95),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL95)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK94,U$7:U$126,\"<=\"&AK95),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO95)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,90,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK95,U$7:U$126,\"<=\"&AK96),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL96)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK95,U$7:U$126,\"<=\"&AK96),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO96)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,91,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK96,U$7:U$126,\"<=\"&AK97),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL97)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK96,U$7:U$126,\"<=\"&AK97),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO97)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,92,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK97,U$7:U$126,\"<=\"&AK98),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL98)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK97,U$7:U$126,\"<=\"&AK98),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO98)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,93,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK98,U$7:U$126,\"<=\"&AK99),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL99)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK98,U$7:U$126,\"<=\"&AK99),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO99)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,94,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK99,U$7:U$126,\"<=\"&AK100),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL100)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK99,U$7:U$126,\"<=\"&AK100),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO100)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,95,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK100,U$7:U$126,\"<=\"&AK101),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL101)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK100,U$7:U$126,\"<=\"&AK101),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO101)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,96,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK101,U$7:U$126,\"<=\"&AK102),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL102)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK101,U$7:U$126,\"<=\"&AK102),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO102)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AJ103>$D$15","v":true},null,null,null,"",0,{"$f":"IF(AND(ISBLANK(M102),AI103<>1),0,IFERROR(-P103*minkamat23/365*(IF(ISBLANK(M103),$C$18,M103)-O103),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(M102),AI103<>1),0,IFERROR(-P103*tenylegeskamat/365*(IF(ISBLANK(M103),$C$18,M103)-O103),\"\"))","v":0},{"$f":"IFERROR(IF(ISBLANK(M103),$C$18,M103)-O103,\"\")","v":""},null,null,null,{"$f":"IF(ISNA(MAX(U102,INDEX(AK$6:AK$126,MATCH(U103-1,AK$6:AK$126,1)))),\"\",MAX(U102,INDEX(AK$6:AK$126,MATCH(U103-1,AK$6:AK$126,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(X102),X102=\"\"),INDEX(AL$7:AL$126,MATCH(U103,AK$7:AK$126,1)),X102-V102),INDEX(AL$7:AL$126,MATCH(U103,AK$7:AK$126,1)))),\"\",MIN(IF(OR(ISBLANK(X102),X102=\"\"),INDEX(AL$7:AL$126,MATCH(U103,AK$7:AK$126,1)),X102-V102),INDEX(AL$7:AL$126,MATCH(U103,AK$7:AK$126,1))))","v":""},{"$f":"IFERROR(-X103*minkamat23/365*(U103-W103),\"\")","v":""},{"$f":"IFERROR(-X103*tenylegeskamat/365*(U103-W103),\"\")","v":""},{"$f":"IFERROR(U103-W103,\"\")","v":""},{"$f":"MAX(AK102,IF(ISNA(INDEX(U$7:U$126,MATCH(AK103,U$7:U$126,1))),0,INDEX(U$7:U$126,MATCH(AK103,U$7:U$126,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(V$7:V$126,MATCH(AK103,U$7:U$126,1))),0,INDEX(V$7:V$126,MATCH(AK103,U$7:U$126,1)))","v":0},{"$f":"IF(ISNA(INDEX(X$7:X$126,MATCH(AK103,U$7:U$126,1))),AL103,INDEX(X$7:X$126,MATCH(AK103,U$7:U$126,1)))","v":0},{"$f":"IFERROR(-(AD103-AC103)*minkamat23/365*(AK103-AB103),0)","v":0},{"$f":"IFERROR(-(AD103-AC103)*tenylegeskamat/365*(AK103-AB103),0)","v":0},{"$f":"IFERROR(AK103-AB103,\"\")","v":""},null,97,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK102,U$7:U$126,\"<=\"&AK103),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL103)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK102,U$7:U$126,\"<=\"&AK103),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO103)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",{"$f":"IFERROR(AK103-AK102,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,98,"",{"$f":"IF(OR(AK103=$C$19,AK103=\"\"),\"\",IFERROR(IF(EDATE($C$18,(AI104-1)*12/$D$19)<=$C$19,EDATE($C$18,(AI104-1)*12/$D$19),$C$19),\"\"))","v":""},{"$f":"+IF(COUNT(AL103)<>0,SUM(AL103:AM103)*(1-K104),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK103,U$7:U$126,\"<=\"&AK104),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL104)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Y$7:Y$126,U$7:U$126,\">\"&AK103,U$7:U$126,\"<=\"&AK104)+AE104,IFERROR(-AL104*minkamat23/365*(AK104-AK103),\"\"))","v":""},{"$f":"+IF(COUNT(AO103)<>0,SUM(AO103:AP103)*(1-K104),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK103,U$7:U$126,\"<=\"&AK104),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO104)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Z$7:Z$126,U$7:U$126,\">\"&AK103,U$7:U$126,\"<=\"&AK104)+AF104,IFERROR(-AO104*tenylegeskamat/365*(AK104-AK103),\"\"))","v":""},null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,99,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK104,U$7:U$126,\"<=\"&AK105),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL105)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK104,U$7:U$126,\"<=\"&AK105),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO105)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,100,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK105,U$7:U$126,\"<=\"&AK106),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL106)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK105,U$7:U$126,\"<=\"&AK106),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO106)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,101,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK106,U$7:U$126,\"<=\"&AK107),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL107)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK106,U$7:U$126,\"<=\"&AK107),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO107)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,102,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK107,U$7:U$126,\"<=\"&AK108),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL108)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK107,U$7:U$126,\"<=\"&AK108),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO108)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,103,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK108,U$7:U$126,\"<=\"&AK109),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL109)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK108,U$7:U$126,\"<=\"&AK109),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO109)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,104,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK109,U$7:U$126,\"<=\"&AK110),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL110)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK109,U$7:U$126,\"<=\"&AK110),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO110)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",{"$f":"IF(ISBLANK(M110),0,N110+P110)","v":0},0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,105,{"$f":"IF(COUNT(AK111)=1,AJ110+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK110,U$7:U$126,\"<=\"&AK111),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL111)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK110,U$7:U$126,\"<=\"&AK111),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO111)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",{"$f":"IFERROR(AK111-AK110,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,106,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK111,U$7:U$126,\"<=\"&AK112),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL112)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK111,U$7:U$126,\"<=\"&AK112),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO112)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,107,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK112,U$7:U$126,\"<=\"&AK113),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL113)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK112,U$7:U$126,\"<=\"&AK113),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO113)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,108,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK113,U$7:U$126,\"<=\"&AK114),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL114)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK113,U$7:U$126,\"<=\"&AK114),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO114)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,109,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK114,U$7:U$126,\"<=\"&AK115),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL115)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK114,U$7:U$126,\"<=\"&AK115),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO115)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,110,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK115,U$7:U$126,\"<=\"&AK116),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL116)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK115,U$7:U$126,\"<=\"&AK116),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO116)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,111,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK116,U$7:U$126,\"<=\"&AK117),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL117)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK116,U$7:U$126,\"<=\"&AK117),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO117)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,112,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK117,U$7:U$126,\"<=\"&AK118),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL118)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK117,U$7:U$126,\"<=\"&AK118),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO118)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,113,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK118,U$7:U$126,\"<=\"&AK119),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL119)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK118,U$7:U$126,\"<=\"&AK119),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO119)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,114,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK119,U$7:U$126,\"<=\"&AK120),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL120)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK119,U$7:U$126,\"<=\"&AK120),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO120)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,115,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK120,U$7:U$126,\"<=\"&AK121),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL121)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK120,U$7:U$126,\"<=\"&AK121),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO121)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,116,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK121,U$7:U$126,\"<=\"&AK122),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL122)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK121,U$7:U$126,\"<=\"&AK122),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO122)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,117,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK122,U$7:U$126,\"<=\"&AK123),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL123)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK122,U$7:U$126,\"<=\"&AK123),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO123)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,118,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK123,U$7:U$126,\"<=\"&AK124),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL124)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK123,U$7:U$126,\"<=\"&AK124),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO124)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,119,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK124,U$7:U$126,\"<=\"&AK125),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL125)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK124,U$7:U$126,\"<=\"&AK125),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO125)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,120,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK125,U$7:U$126,\"<=\"&AK126),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL126)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$126,U$7:U$126,\">\"&AK125,U$7:U$126,\"<=\"&AK126),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO126)>$D$15,\"\",-$AL$5/$D$15),0),\"\"))","v":""},"",null,"",""]

{"sheet":"Szamitasok","index":2,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,9],[2,0,2,1]]}
["Kizárók és KO-k"]
[null,null,null,"Váll. Méret","Mezőgazdasági","Halászat/akvakultúra",null,null,"Régió"]
["Szorzó értéke",null,null,{"$f":"Tamogatastartalom!C12","v":"KKV"},null,null,null,null,{"$f":"Tamogatastartalom!C38","v":0}]
[{"$f":"PRODUCT(C4:W4)","v":1},"általános",null,null,null,null,null,1]
[{"$f":"PRODUCT(E5:F5)","v":1},"mezőgazdasági",null,null,{"$f":"IF(Tamogatastartalom!C13=\"Mezőgazdasági\",1,0)","v":1},null,null,{"$f":"PRODUCT(I5)","v":1},{"$f":"IF(I3=\"Budapest\",0,1)","v":1}]
[{"$f":"PRODUCT(E6:F6)","v":0},"halászati",null,null,null,{"$f":"IF(Tamogatastartalom!C13=\"Halászati\",1,0)","v":0},null,1]

{"sheet":"Adatok","index":3,"n_rows":23,"n_cols":21,"rows_kept":23,"cut":false,"hidden":true,"merged":[[9,0,9,11],[0,12,0,22],[4,3,8,3],[1,3,1,7],[2,5,2,7],[0,0,0,11],[1,9,1,11]]}
["Felárak",null,null,null,null,null,null,null,null,null,null,null,"Segédszámítások"]
[null,null,null,"Piaci referencia",null,null,null,null,null,null,null,null,"Törlesztés",null,null,"Törlesztésgyakoriság",null,null,"Select",null,"Select"]
[null,null,null,null,null,"Fedezettség",null,null,null,null,null,null,"Egyenlő összeg",1,null,"Havi",12,null,"Beruházási hitel",null,"Beruházási hitel"]
[null,null,null,null,null,"Magas","Általános","Alacsony",null,null,null,null,"Egyenlő tőke",2,null,"Negyedéves",4,null,"Forgóeszközhitel",null,"Lízing"]
[null,null,null,"Hitelminősítés","Kiváló",60,75,100,null,null,null,null,"Egyedi",0,null,"Féléves",2,null,"Lízing"]
[null,null,null,null,"Jó",75,100,220]
[null,null,null,null,"Kielégítő",100,220,400,null,null,null,null,"Annuitás"]
[null,null,null,null,"Gyenge",220,400,650]
[null,null,null,null,"Rossz",400,650,1000]
["Regionális támogatási intenzitások"]
[null,"Nagyvállalat",null,"Intenzitás","MAX Támogatástartalom (mio EUR)"]
["Select",0,null,0.5,37.5]
["Dél-Alföld",0.5,null,0.35,26.25,null,null,null,"ügyleti kamat","EUR","HUF"]
["Dél-Dunántúl",0.5,null,0.3,22.5,null,null,null,"min",0.01,3.5000000000000003E-2]
["Észak-Alföld",0.5,null,0.25,18.75,null,null,null,"max",{"$f":"IF(Tamogatastartalom!C9=\"HUF\",0.05,0.035)","v":0.05},0.06]
["Észak-Magyarország",0.5,null,0.2,15]
["Közép-Dunántúl",0.3,null,0,0,null,null,null,"2.3 min kamat"," "]
["Pest",0.5,null,null,null,null,null,null,"EUR",6,13,25]
["Nyugat-Dunántúl",0.3,null,null,null,null,null,null,"KKV",1.2800000000000001E-2,1.46E-2,1.5100000000000001E-2]
["Budapest",0,null,null,null,null,null,null,"Nagyvállalat",1.5299999999999999E-2,1.89E-2,1.9900000000000001E-2]
[null,null,null,null,null,null,null,null,"HUF",6,13,25]
[null,null,null,null,null,null,null,null,"KKV",0.114,0.1158,0.1163]
[null,null,null,null,null,null,null,null,"Nagyvállalat",0.11650000000000001,0.1201,0.1211]