{"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":58,"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":47,"rows_kept":126,"cut":false,"hidden":false,"merged":[[0,19,1,20],[0,11,1,12],[3,1,3,2],[6,5,6,8],[5,1,5,2],[2,46,3,46],[3,4,4,4],[2,19,3,19],[2,20,3,20],[2,43,2,44],[2,39,2,41],[2,21,2,24],[2,26,2,30],[2,36,2,38],[2,11,3,11],[2,12,3,12],[2,5,2,7],[3,5,3,7],[4,5,4,7]]}
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(M7:M126)<C24,\"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(U7:U126)<C24,\"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,"Hitelösszeg (EUR)",null,null,{"$f":"IF(C9=\"HUF\",C24/C10,C24)","v":277777.77777777775},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,"Piaci konstrukció",null,null,"Támogatott konstruckió",null,null,null,"Támogatástartalom",null,null,"Támogatástartalom + egyéb kedvezmények"]
[null,null,null,-0.04,null,{"$f":"IF(tenylegestt=0,\"Az ügylet nem finanszírozható\",\"Ténylegesen felvett hitel támogatástartalma (EUR)\")","v":"Ténylegesen felvett hitel támogatástartalma (EUR)"},null,null,{"$f":"IF(C9=\"HUF\",AR5/C10,AR5)","v":167447.72727272761},null,null,null,null,null,null,"kamat","támogatott",null,null,null,null,"dátumtól","tőke","kamat","támogatott",null,"dátumtól","amort","tőke","maradék","t maradék",null,null,null,"Periodus","Dátum","Tőke","Tőkeamt.","Kamatfiz.","Tőke","Tőkeamt.","Kamatfiz.",null,"FV","PV"]
[null,"Pénzügyi intézmény neve refinanszírozás esetén: ",null,null,null,"Hitelösszeg (HUF)",null,null,{"$f":"I3*C10","v":99999999.999999985},null,null,null,null,null,null,{"$f":"SUM(P7:P126)","v":-11938356.16438356},{"$f":"SUM(Q7:Q126)","v":-1438356.1643835616},null,null,null,null,null,null,{"$f":"SUM(X7:X126)","v":0},{"$f":"SUM(Y7:Y126)","v":0},null,null,null,null,{"$f":"SUM(AD7:AD126)","v":-68538877.957658961},{"$f":"SUM(AE7:AE126)","v":-8257696.1394769782},null,null,null,null,null,{"$f":"+AK7","v":100000000},{"$f":"SUM(AL7:AL126)","v":-99999999.999999821},{"$f":"SUM(AM7:AM126)","v":-68538877.957658961},{"$f":"+AN7","v":100000000},{"$f":"SUM(AO7:AO126)","v":-99999999.999999821},{"$f":"SUM(AP7:AP126)","v":-8257696.1394769782},null,{"$f":"SUM(AR7:AR126)","v":60281181.818181939},{"$f":"SUM(AS7:AS126)","v":53541098.626744486},null,{"$f":"AS5","v":53541098.626744486}]
[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(C26,MIN(L7:L126))","v":"2020-05-30"}]
[null,null,null,null,null,"COVID Közlemény 3.1 alapján megítélt támogatásokon felül igénybe vehető szabad keret",null,null,null,{"$f":"AI7>$D$15","v":false},null,null,null,{"$f":"C26","v":"2020-05-30"},{"$f":"IF(ISBLANK(L7),C24,0)","v":100000000},{"$f":"IF(AND(ISBLANK(L6),AH7<>1),0,IFERROR(-O7*piacikamat/365*(IF(ISBLANK(L7),$C$27,L7)-N7),\"\"))","v":-11938356.16438356},{"$f":"IF(AND(ISBLANK(L6),AH7<>1),0,IFERROR(-O7*tenylegeskamat/365*(IF(ISBLANK(L7),$C$27,L7)-N7),\"\"))","v":-1438356.1643835616},{"$f":"IFERROR(IF(ISBLANK(L7),$C$27,L7)-N7,\"\")","v":350},null,null,null,{"$f":"IF(ISNA(MAX(T6,INDEX(AJ$6:AJ$126,MATCH(T7-1,AJ$6:AJ$126,1)))),\"\",MAX(T6,INDEX(AJ$6:AJ$126,MATCH(T7-1,AJ$6:AJ$126,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(W6),W6=\"\"),INDEX(AK$7:AK$126,MATCH(T7,AJ$7:AJ$126,1)),W6-U6),INDEX(AK$7:AK$126,MATCH(T7,AJ$7:AJ$126,1)))),\"\",MIN(IF(OR(ISBLANK(W6),W6=\"\"),INDEX(AK$7:AK$126,MATCH(T7,AJ$7:AJ$126,1)),W6-U6),INDEX(AK$7:AK$126,MATCH(T7,AJ$7:AJ$126,1))))","v":""},{"$f":"IFERROR(-W7*piacikamat/365*(T7-V7),\"\")","v":""},{"$f":"IFERROR(-W7*tenylegeskamat/365*(T7-V7),\"\")","v":""},{"$f":"IFERROR(T7-V7,\"\")","v":""},{"$f":"MAX(AJ6,IF(ISNA(INDEX(T$7:T$126,MATCH(AJ7,T$7:T$126,1))),0,INDEX(T$7:T$126,MATCH(AJ7,T$7:T$126,1))))","v":"2020-05-30"},{"$f":"IF(ISNA(INDEX(U$7:U$126,MATCH(AJ7,T$7:T$126,1))),0,INDEX(U$7:U$126,MATCH(AJ7,T$7:T$126,1)))","v":0},{"$f":"IF(ISNA(INDEX(W$7:W$126,MATCH(AJ7,T$7:T$126,1))),AK7,INDEX(W$7:W$126,MATCH(AJ7,T$7:T$126,1)))","v":100000000},{"$f":"IFERROR(-(AC7-AB7)*piacikamat/365*(AJ7-AA7),0)","v":-11938356.16438356},{"$f":"IFERROR(-(AC7-AB7)*tenylegeskamat/365*(AJ7-AA7),0)","v":-1438356.1643835616},{"$f":"IFERROR(AJ7-AA7,\"\")","v":350},null,1,{"$f":"+IF(C28-C27<>0,1,\"\")","v":1},{"$f":"C27","v":"2021-05-15"},{"$f":"IF(+C24<>0,C24,IF(AI7>0,C24*J7,\"\"))","v":100000000},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ6,T$7:T$126,\"<=\"&AJ7),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK7)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},{"$f":"SUM(P7:P126)","v":-11938356.16438356},{"$f":"+AK7","v":100000000},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ6,T$7:T$126,\"<=\"&AJ7),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN7)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},{"$f":"SUM(Q7:Q126)","v":-1438356.1643835616},null,{"$f":"IFERROR(MAX((ABS(AM7)-ABS(AP7)),0),\"\")","v":10499999.999999998},{"$f":"IFERROR(AR7/(1+($C$11+1%)/365*(AJ7-C25)),\"\")","v":10149830.836152729},{"$f":"IFERROR(AJ7-AJ6,\"\")","v":350}]
[null,"PIACI KAMAT MEGHATÁROZÁSA",null,null,null,null,"Általános szabály","Mezőgazdasági szabály","Halászati szabály",{"$f":"AI8>$D$15","v":false},null,null,null,{"$f":"IF(ISBLANK(L7),\"\",L7)","v":""},{"$f":"IF(ISBLANK(L7),0,M7+O7)","v":0},0,0,"",null,null,null,{"$f":"IF(ISNA(MAX(T7,INDEX(AJ$6:AJ$126,MATCH(T8-1,AJ$6:AJ$126,1)))),\"\",MAX(T7,INDEX(AJ$6:AJ$126,MATCH(T8-1,AJ$6:AJ$126,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(W7),W7=\"\"),INDEX(AK$7:AK$126,MATCH(T8,AJ$7:AJ$126,1)),W7-U7),INDEX(AK$7:AK$126,MATCH(T8,AJ$7:AJ$126,1)))),\"\",MIN(IF(OR(ISBLANK(W7),W7=\"\"),INDEX(AK$7:AK$126,MATCH(T8,AJ$7:AJ$126,1)),W7-U7),INDEX(AK$7:AK$126,MATCH(T8,AJ$7:AJ$126,1))))","v":""},"","","",{"$f":"MAX(AJ7,IF(ISNA(INDEX(T$7:T$126,MATCH(AJ8,T$7:T$126,1))),0,INDEX(T$7:T$126,MATCH(AJ8,T$7:T$126,1))))","v":"2021-05-15"},{"$f":"IF(ISNA(INDEX(U$7:U$126,MATCH(AJ8,T$7:T$126,1))),0,INDEX(U$7:U$126,MATCH(AJ8,T$7:T$126,1)))","v":0},{"$f":"IF(ISNA(INDEX(W$7:W$126,MATCH(AJ8,T$7:T$126,1))),AK8,INDEX(W$7:W$126,MATCH(AJ8,T$7:T$126,1)))","v":99090909.090909094},-1047784.5579078455,-126239.10336239102,31,null,2,{"$f":"IF(COUNT(AJ8)=1,AI7+1,\"\")","v":2},{"$f":"IF(OR(AJ7=$C$28,AJ7=\"\"),\"\",IFERROR(IF(EDATE($C$27,(AH8-1)*12/$D$19)<=$C$28,EDATE($C$27,(AH8-1)*12/$D$19),$C$28),\"\"))","v":"2021-06-15"},{"$f":"+IF(COUNT(AK7)<>0,SUM(AK7:AL7)*(1-J8),\"\")","v":99090909.090909094},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ7,T$7:T$126,\"<=\"&AJ8),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK8)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(X$7:X$126,T$7:T$126,\">\"&AJ7,T$7:T$126,\"<=\"&AJ8)+AD8,IFERROR(-AK8*piacikamat/365*(AJ8-AJ7),\"\"))","v":-1047784.5579078455},{"$f":"+IF(COUNT(AN7)<>0,SUM(AN7:AO7)*(1-J8),\"\")","v":99090909.090909094},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ7,T$7:T$126,\"<=\"&AJ8),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN8)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Y$7:Y$126,T$7:T$126,\">\"&AJ7,T$7:T$126,\"<=\"&AJ8)+AE8,IFERROR(-AN8*tenylegeskamat/365*(AJ8-AJ7),\"\"))","v":-126239.10336239102},null,{"$f":"IFERROR(MAX((ABS(AM8)-ABS(AP8)),0),\"\")","v":921545.45454545447},{"$f":"IFERROR(AR8/POWER(1+($C$11+1%)/$D$19,AI8-1)/(1+($C$11+1%)/365*($AJ$7-$C$25)),\"\")","v":888258.68214234919},31]
[null,"Hitel devizaneme","HUF","Makrohoz kellenek (ne töröld ki!):",null,null,null,null,null,false,null,null,null,{"$f":"IF(ISBLANK(L8),\"\",L8)","v":""},{"$f":"IF(ISBLANK(L8),0,M8+O8)","v":0},0,0,"",null,null,null,"","","","","","2021-06-15",0,98181818.181818187,-1004682.4408468244,-121046.07721046077,30,null,3,{"$f":"IF(COUNT(AJ9)=1,AI8+1,\"\")","v":3},"2021-07-15",98181818.181818187,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ8,T$7:T$126,\"<=\"&AJ9),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK9)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-1004682.4408468244,98181818.181818187,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ8,T$7:T$126,\"<=\"&AJ9),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN9)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-121046.07721046077,null,883636.36363636365,849277.21824354329,30]
[null,"HUF/EUR árfolyam",360,{"$f":"+C17/D19","v":1.0375000000000001E-2},null,"Maximális hitelösszeghez tartozó támogatástartalom (EUR)",{"$f":"IF(2300000-C40-C41-C42-C45-C46-C47-C48-C49-C50<=0,\"Nem jogosult\",2300000-C40-C41-C42-C45-C46-C47-C48-C49-C50)","v":2300000},{"$f":"IF(mezogazdkizarok=0,\"Nem releváns\",IF(MIN(290000-C40-C45-C49,2300000-C40-C41-C42-C45-C46-C47-C48-C49-C50,345000-C40-C41-C45-C46-C49-C50)<=0,\"Nem jogosult\",MIN(290000-C40-C45-C49,2300000-C40-C41-C42-C45-C46-C47-C48-C49-C50,345000-C40-C41-C45-C46-C49-C50)))","v":"Nem releváns"},{"$f":"IF(halaszatikizarok=0,\"Nem releváns\",IF(MIN(345000-C41-C46-C50,2300000-C40-C41-C42-C45-C46-C47-C48-C49-C50,345000-C40-C41-C45-C46-C49-C50)<=0,\"Nem jogosult\",MIN(345000-C41-C46-C50,2300000-C40-C41-C42-C45-C46-C47-C48-C49-C50,345000-C40-C41-C45-C46-C49-C50)))","v":"Nem releváns"},false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2021-07-15",0,97272727.272727281,-1028559.1531755917,-123922.7895392279,31,null,4,{"$f":"IF(COUNT(AJ10)=1,AI9+1,\"\")","v":4},"2021-08-15",97272727.272727281,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ9,T$7:T$126,\"<=\"&AJ10),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK10)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-1028559.1531755917,97272727.272727281,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ9,T$7:T$126,\"<=\"&AJ10),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN10)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-123922.7895392279,null,904636.36363636376,866968.12494751462,31]
[null,"Referencia alapkamat - Kérjük adja meg a hatályos, devizanem szerinti értéket!",2.4500000000000001E-2,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2021-08-15",0,96363636.363636374,-1018946.4508094647,-122764.63262764635,31,null,5,5,"2021-09-15",96363636.363636374,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ10,T$7:T$126,\"<=\"&AJ11),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK11)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-1018946.4508094647,96363636.363636374,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ10,T$7:T$126,\"<=\"&AJ11),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN11)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-122764.63262764635,null,896181.81818181835,856403.45916179346,31]
[null,"Van hitelfelvevői múltja vagy mérleg alapú hitelminősítése a hitelfelvevőnek?","Van",1E-4,null,"Teljes(kumulált) támogatás intenzítása",null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2021-09-15",0,95454545.454545468,-976774.59526774602,-117683.68617683687,30,null,6,6,"2021-10-15",95454545.454545468,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ11,T$7:T$126,\"<=\"&AJ12),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK12)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-976774.59526774602,95454545.454545468,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ11,T$7:T$126,\"<=\"&AJ12),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN12)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-117683.68617683687,null,859090.90909090918,818605.39456659474,30]
[null,"Cégbesorolás",null,null,null,"Beruházás elszámolható költsége (EUR)",{"$f":"C23/IF(C9<>\"EUR\",arfolyam,1)","v":388888.88888888888},null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2021-10-15",0,94545454.545454562,-999721.04607721069,-120448.31880448319,31,null,7,7,"2021-11-15",94545454.545454562,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ12,T$7:T$126,\"<=\"&AJ13),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK13)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-999721.04607721069,94545454.545454562,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ12,T$7:T$126,\"<=\"&AJ13),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN13)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-120448.31880448319,null,879272.72727272753,835434.25099907664,31]
[null,"Adósminősítés","Rossz",null,null,"Hitelre jutó támogatás intenzítása (EUR)",{"$f":"I4/eurelszamolhato","v":0.43057987012987103},null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2021-11-15",0,93636363.636363655,-958169.36488169385,-115442.09215442094,30,null,8,8,"2021-12-15",93636363.636363655,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ13,T$7:T$126,\"<=\"&AJ14),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK14)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-958169.36488169385,93636363.636363655,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ13,T$7:T$126,\"<=\"&AJ14),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN14)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-115442.09215442094,null,842727.27272727294,798415.42277711711,30]
[null,"Fedezettség","Alacsony",{"$f":"COUNT(AI7:AI126)","v":110},null,"Adott beruházási költséghez kapcsolódó teljes támogatás összege (EUR)",{"$f":"I4+IF(C34=\"Egyéb támogatások: pl. Egyéb GBER, ABER\",SUM(C45:C50)+C60,IF(C34=\"GBER 14, 17-es jogcímek\",SUM(C45:C50)+C53+C55,SUM(C45:C50)))","v":167447.72727272761},null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2021-12-15",0,92727272.727272749,-980495.6413449567,-118132.00498132009,31,null,9,9,"2022-01-15",92727272.727272749,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ14,T$7:T$126,\"<=\"&AJ15),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK15)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-980495.6413449567,92727272.727272749,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ14,T$7:T$126,\"<=\"&AJ15),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN15)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-118132.00498132009,null,862363.63636363659,814677.08068146929,31]
[null,"Kockázati felár (bázispont)",{"$f":"IF(C12=\"Van\",OFFSET(Adatok!$E$4,MATCH(C14,Adatok!$E$5:$E$9,0),MATCH(C15,Adatok!$F$4:$H$4,0),),MAX(OFFSET(Adatok!$E$4,MATCH(C14,Adatok!$E$5:$E$9,0),MATCH(C15,Adatok!$F$4:$H$4,0),),400))","v":1000},null,null,"Teljes támogatás intenzítása",{"$f":"G15/eurelszamolhato","v":0.43057987012987103},null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-01-15",0,91818181.818181843,-970882.93897882954,-116973.84806973851,31,null,10,{"$f":"IF(COUNT(AJ16)=1,AI15+1,\"\")","v":10},"2022-02-15",91818181.818181843,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ15,T$7:T$126,\"<=\"&AJ16),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK16)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-970882.93897882954,91818181.818181843,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ15,T$7:T$126,\"<=\"&AJ16),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN16)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-116973.84806973851,null,853909.09090909106,804377.46526606986,31]
[null,"Egyéni referencia kamatláb",{"$f":"+(C11+C16/10000)","v":0.1245},null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-02-15",0,90909090.909090936,-868244.0846824412,-104607.72104607723,28,null,11,{"$f":"IF(COUNT(AJ17)=1,AI16+1,\"\")","v":11},"2022-03-15",90909090.909090936,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ16,T$7:T$126,\"<=\"&AJ17),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK17)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-868244.0846824412,90909090.909090936,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ16,T$7:T$126,\"<=\"&AJ17),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN17)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-104607.72104607723,null,763636.363636364,717278.89718687523,28]
[null,null,null,null,null,"Maximális támogatási mértékek",{"$f":"IF(G16>G20,\"Nem finanszírozható\",\"\")","v":""},{"$f":"IF(G16>H20,\"Nem finanszírozható\",\"\")","v":"Nem finanszírozható"},null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-03-15",0,90000000.00000003,-951657.53424657567,-114657.53424657538,31,null,12,12,"2022-04-15",90000000.00000003,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ17,T$7:T$126,\"<=\"&AJ18),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK18)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-951657.53424657567,90000000.00000003,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ17,T$7:T$126,\"<=\"&AJ18),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN18)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-114657.53424657538,null,837000.00000000023,783935.09213387221,31]
[null,"HITELKARAKTERISZTIKA",null,{"$f":"VLOOKUP($C$31,Adatok!P3:Q5,2,0)","v":12},null,null,"14-es cikk","17-es cikk",null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-04-15",0,89090909.090909123,-911656.28891656315,-109838.10709838109,30,null,13,13,"2022-05-15",89090909.090909123,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ18,T$7:T$126,\"<=\"&AJ19),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK19)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-911656.28891656315,89090909.090909123,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ18,T$7:T$126,\"<=\"&AJ19),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN19)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-109838.10709838109,null,801818.18181818211,748830.87495999795,30]
[null,"Hitel fajtája/célja","Beruházási hitel",null,null,"Maximális támogatásintenzitás (%)",{"$f":"IF(tizennegyeskizarok=0,\"Nem jogosult\",IF(ttmax14es=0,0,(G22+C53+C48)/(forintelszamolhato/arfolyam)))","v":0.55000000000000004},{"$f":"IF(tizenheteskizarok=0,\"Nem jogosult\",IF(ttmax17es=0,0,(H22+C55+C48)/(eurelszamolhato)))","v":0.2},null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-05-15",0,88181818.181818217,-932432.1295143218,-112341.22042341225,31,null,14,14,"2022-06-15",88181818.181818217,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ19,T$7:T$126,\"<=\"&AJ20),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK20)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-932432.1295143218,88181818.181818217,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ19,T$7:T$126,\"<=\"&AJ20),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN20)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-112341.22042341225,null,820090.90909090952,763700.42963375349,31]
[null,"Vállalat mérete","Mikró/Kis",null,null,"Maximális hitelösszeg (EUR)",{"$f":"IF(tizennegyeskizarok=0,\"Nem jogosult\",hitelpertamogatasarany*G22)","v":354818.67215877312},{"$f":"IF(tizenheteskizarok=0,\"Nem jogosult\",hitelpertamogatasarany*H22)","v":129024.97169409931},null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-06-15",0,87272727.272727311,-893051.05853051099,-107596.51307596517,30,null,15,15,"2022-07-15",87272727.272727311,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ20,T$7:T$126,\"<=\"&AJ21),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK21)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-893051.05853051099,87272727.272727311,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ20,T$7:T$126,\"<=\"&AJ21),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN21)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-107596.51307596517,null,785454.54545454588,729348.82792125957,30]
[null,"Támogatás jogalapja","Egyéb",null,null,"Maximális hitelösszeghez tartozó támogatástartalom (EUR)",{"$f":"IF(tizennegyeskizarok=0,\"Nem jogosult\",MIN(MAX((Szamitasok!B16*(Szamitasok!B10+0.5*Szamitasok!B11)-C53-C48),0),Szamitasok!B17))","v":213888.88888888891},{"$f":"IF(tizenheteskizarok=0,\"Nem jogosult\",MAX(MIN(((((eurelszamolhato)*vallmeret)-C55-C48)),7.5*1000000),0))","v":77777.777777777781},null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-07-15",0,86363636.363636404,-913206.72478206758,-110024.90660024912,31,null,16,16,"2022-08-15",86363636.363636404,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ21,T$7:T$126,\"<=\"&AJ22),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK22)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-913206.72478206758,86363636.363636404,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ21,T$7:T$126,\"<=\"&AJ22),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN22)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-110024.90660024912,null,803181.81818181847,743671.76943651889,31]
[null,{"$f":"IF(C23<C24,\"Nem lehet kisebb, mint a hitelösszeg\",\"Beruházás elszámolható költsége (\"&C9&\")\")","v":"Beruházás elszámolható költsége (HUF)"},140000000,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-08-15",0,85454545.454545498,-903594.02241594065,-108866.74968866754,31,null,17,17,"2022-09-15",85454545.454545498,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ22,T$7:T$126,\"<=\"&AJ23),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK23)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-903594.02241594065,85454545.454545498,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ22,T$7:T$126,\"<=\"&AJ23),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN23)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-108866.74968866754,null,794727.27272727317,733734.15983817889,31]
[null,{"$f":"IF(C9=\"HUF\",IF(C24>3500000000,\"A hitelösszeg nem haladhatja meg a 3,5 milliárd forintot!\",\"Hitelösszeg (\"&C9&\")\"),IF(C24>10000000,\"A hitelösszeg nem haladhatja meg a 10 millió eurót!\",\"Hitelösszeg (\"&C9&\")\"))","v":"Hitelösszeg (HUF)"},100000000,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-09-15",0,84545454.545454592,-865143.21295143268,-104234.12204234127,30,null,18,18,"2022-10-15",84545454.545454592,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ23,T$7:T$126,\"<=\"&AJ24),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK24)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-865143.21295143268,84545454.545454592,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ23,T$7:T$126,\"<=\"&AJ24),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN24)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-104234.12204234127,null,760909.09090909141,700497.49932174897,30]
[null,"Hitel jóváhagyásának várható időpontja (EXIM döntés dátuma)","2020-05-15",null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-10-15",0,83636363.636363685,-884368.61768368667,-106550.43586550442,31,null,19,19,"2022-11-15",83636363.636363685,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ24,T$7:T$126,\"<=\"&AJ25),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK25)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-884368.61768368667,83636363.636363685,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ24,T$7:T$126,\"<=\"&AJ25),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN25)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-106550.43586550442,null,777818.18181818223,714011.32785021851,31]
[null,{"$f":"\"Szerződéskötés várható dátuma\"&IF(C26>DATE(2022,6,30),\" - Nem lehet későbbi, mint 2022.06.30\",\"\")","v":"Szerződéskötés várható dátuma"},"2020-05-30",null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-11-15",0,82727272.727272779,-846537.9825653804,-101992.52801992533,30,null,20,20,"2022-12-15",82727272.727272779,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ25,T$7:T$126,\"<=\"&AJ26),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK26)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-846537.9825653804,82727272.727272779,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ25,T$7:T$126,\"<=\"&AJ26),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN26)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-101992.52801992533,null,744545.45454545505,681508.72868521814,30]
[null,"Első törlesztés várható dátuma","2021-05-15",null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-12-15",0,81818181.818181872,-865143.21295143268,-104234.12204234129,31,null,21,21,"2023-01-15",81818181.818181872,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ26,T$7:T$126,\"<=\"&AJ27),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK27)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-865143.21295143268,81818181.818181872,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ26,T$7:T$126,\"<=\"&AJ27),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN27)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-104234.12204234129,null,760909.09090909141,694490.28293902602,31]
[null,{"$f":"IF(C28>EDATE(C26,120),\"A futamidő nem haladhatja meg a 10 évet\",\"Hitel végső lejáratának várható dátuma\")","v":"Hitel végső lejáratának várható dátuma"},"2030-05-30",null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-01-15",0,80909090.909090966,-855530.51058530575,-103075.96513075972,31,null,22,22,"2023-02-15",80909090.909090966,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ27,T$7:T$126,\"<=\"&AJ28),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK28)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-855530.51058530575,80909090.909090966,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ27,T$7:T$126,\"<=\"&AJ28),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN28)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-103075.96513075972,null,752454.54545454599,684804.91012309969,31]
[null,"Tényleges ügyleti kamat",{"$f":"IF(C9=\"EUR\",0.005,0.015)","v":1.4999999999999999E-2},null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-02-15",0,80000000.00000006,-764054.79452054854,-92054.794520548021,28,null,23,{"$f":"IF(COUNT(AJ29)=1,AI28+1,\"\")","v":23},"2023-03-15",80000000.00000006,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ28,T$7:T$126,\"<=\"&AJ29),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK29)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-764054.79452054854,80000000.00000006,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ28,T$7:T$126,\"<=\"&AJ29),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN29)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-92054.794520548021,null,672000.00000000047,609830.39059670374,28]
[null,"Törlesztés módja","Egyenlő tőke",null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-03-15",0,79090909.090909153,-836305.10585305176,-100759.65130759658,31,null,24,24,"2023-04-15",79090909.090909153,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ29,T$7:T$126,\"<=\"&AJ30),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK30)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-836305.10585305176,79090909.090909153,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ29,T$7:T$126,\"<=\"&AJ30),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN30)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-100759.65130759658,null,735545.45454545517,665583.42955533287,31]
[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",null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-04-15",0,78181818.181818247,-800024.90660024981,-96388.542963885513,30,null,25,25,"2023-05-15",78181818.181818247,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ30,T$7:T$126,\"<=\"&AJ31),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK31)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-800024.90660024981,78181818.181818247,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ30,T$7:T$126,\"<=\"&AJ31),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN31)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-96388.542963885513,null,703636.36363636435,634884.10687747295,30]
[null,"A beruházási hitel kapcsolódik-e ugyanazon elszámolható költéségek tekintetében megítélt támogatáshoz vagy a TF 3.1 alapján megítélt támogatásokhoz?","Igen",null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-05-15",0,77272727.27272734,-817079.70112079778,-98443.337484433461,31,null,26,26,"2023-06-15",77272727.27272734,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ31,T$7:T$126,\"<=\"&AJ32),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK32)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-817079.70112079778,77272727.27272734,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ31,T$7:T$126,\"<=\"&AJ32),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN32)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-98443.337484433461,null,718636.36363636435,646559.59914553456,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-06-15",0,76363636.363636434,-781419.67621419742,-94146.948941469585,30,null,27,27,"2023-07-15",76363636.363636434,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ32,T$7:T$126,\"<=\"&AJ33),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK33)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-781419.67621419742,76363636.363636434,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ32,T$7:T$126,\"<=\"&AJ33),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN33)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-94146.948941469585,null,687272.72727272788,616568.99217283411,30]
[null,"ÁCSR/Agrár/Halászati csoportmentességi támogatásokhoz  kapcsoldódó azonos elszámolható költségekhez megítélt állami támogatások","GBER 14, 17-es jogcímek",null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-07-15",0,75454545.454545528,-797854.29638854368,-96127.023661270316,31,null,28,28,"2023-08-15",75454545.454545528,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ33,T$7:T$126,\"<=\"&AJ34),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK34)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-797854.29638854368,75454545.454545528,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ33,T$7:T$126,\"<=\"&AJ34),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN34)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-96127.023661270316,null,701727.2727272734,627731.78574325086,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-08-15",0,74545454.545454621,-788241.59402241686,-94968.866749688765,31,null,29,29,"2023-09-15",74545454.545454621,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ34,T$7:T$126,\"<=\"&AJ35),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK35)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-788241.59402241686,74545454.545454621,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ34,T$7:T$126,\"<=\"&AJ35),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN35)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-94968.866749688765,null,693272.72727272811,618390.87840466585,31]
[null,"Beruházás helyszíne ","Közép_Magyarország",null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-09-15",0,73636363.636363715,-753511.83063511911,-90784.557907845679,30,null,30,30,"2023-10-15",73636363.636363715,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ35,T$7:T$126,\"<=\"&AJ36),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK36)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-753511.83063511911,73636363.636363715,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ35,T$7:T$126,\"<=\"&AJ36),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN36)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-90784.557907845679,null,662727.2727272734,589450.03395463759,30]
[null,"Melyik település?","Áporka",null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-10-15",0,72727272.727272809,-769016.18929016276,-92652.552926525619,31,null,31,31,"2023-11-15",72727272.727272809,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ36,T$7:T$126,\"<=\"&AJ37),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK37)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-769016.18929016276,72727272.727272809,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ36,T$7:T$126,\"<=\"&AJ37),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN37)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-92652.552926525619,null,676363.63636363717,599854.05506801768,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-11-15",0,71818181.818181902,-734906.60024906683,-88542.963885429737,30,null,32,32,"2023-12-15",71818181.818181902,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ37,T$7:T$126,\"<=\"&AJ38),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK38)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-734906.60024906683,71818181.818181902,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ37,T$7:T$126,\"<=\"&AJ38),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN38)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-88542.963885429737,null,646363.63636363705,571604.26295014797,30]
[null,"Nem azonos elszámolható költségekre megítélt COVID Közlemény 3.1 szerinti állami támogatások",null,null,null,null,null,null,null,false,null,null,null,"",0,{"$f":"IF(AND(ISBLANK(L38),AH39<>1),0,IFERROR(-O39*piacikamat/365*(IF(ISBLANK(L39),$C$27,L39)-N39),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(L38),AH39<>1),0,IFERROR(-O39*tenylegeskamat/365*(IF(ISBLANK(L39),$C$27,L39)-N39),\"\"))","v":0},{"$f":"IFERROR(IF(ISBLANK(L39),$C$27,L39)-N39,\"\")","v":""},null,null,null,"","","","","","2023-12-15",0,70909090.909090996,-749790.78455790877,-90336.239103362503,31,null,33,33,"2024-01-15",70909090.909090996,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ38,T$7:T$126,\"<=\"&AJ39),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK39)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-749790.78455790877,70909090.909090996,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ38,T$7:T$126,\"<=\"&AJ39),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN39)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-90336.239103362503,null,659454.54545454623,581509.21914409904,31]
[null,"Mezőgazdasági ágazatra megítélt támogatás teljes összege (EUR):",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2024-01-15",0,70000000.000000089,-740178.08219178172,-89178.082191780937,31,null,34,34,{"$f":"IF(OR(AJ39=$C$28,AJ39=\"\"),\"\",IFERROR(IF(EDATE($C$27,(AH40-1)*12/$D$19)<=$C$28,EDATE($C$27,(AH40-1)*12/$D$19),$C$28),\"\"))","v":"2024-02-15"},70000000.000000089,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ39,T$7:T$126,\"<=\"&AJ40),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK40)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(X$7:X$126,T$7:T$126,\">\"&AJ39,T$7:T$126,\"<=\"&AJ40)+AD40,IFERROR(-AK40*piacikamat/365*(AJ40-AJ39),\"\"))","v":-740178.08219178172},70000000.000000089,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ39,T$7:T$126,\"<=\"&AJ40),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN40)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Y$7:Y$126,T$7:T$126,\">\"&AJ39,T$7:T$126,\"<=\"&AJ40)+AE40,IFERROR(-AN40*tenylegeskamat/365*(AJ40-AJ39),\"\"))","v":-89178.082191780937},null,651000.00000000081,{"$f":"IFERROR(AR40/POWER(1+($C$11+1%)/$D$19,AI40-1)/(1+($C$11+1%)/365*($AJ$7-$C$25)),\"\")","v":572408.29888551997},31]
[null,"Halászati, akvakultúra ágazatra  megítélt támogatás teljes összeg (EUR):",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2024-02-15",0,69090909.090909183,-683432.12951432215,-82341.22042341232,29,null,35,35,"2024-03-15",69090909.090909183,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ40,T$7:T$126,\"<=\"&AJ41),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK41)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-683432.12951432215,69090909.090909183,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ40,T$7:T$126,\"<=\"&AJ41),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN41)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-82341.22042341232,null,601090.90909090987,527009.31021206209,29]
[null,"Egyéb ágazatra megítélt támogatás tejes összege (EUR):",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2024-03-15",0,68181818.181818277,-720952.67745952785,-86861.768368617806,31,null,36,36,"2024-04-15",68181818.181818277,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ41,T$7:T$126,\"<=\"&AJ42),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK42)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-720952.67745952785,68181818.181818277,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ41,T$7:T$126,\"<=\"&AJ42),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN42)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-86861.768368617806,null,634090.90909091011,554348.46515136701,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2024-04-15",0,67272727.27272737,-688393.52428393625,-82938.978829389918,30,null,37,37,"2024-05-15",67272727.27272737,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ42,T$7:T$126,\"<=\"&AJ43),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK43)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-688393.52428393625,67272727.27272737,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ42,T$7:T$126,\"<=\"&AJ43),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN43)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-82938.978829389918,null,605454.54545454634,527795.95979238604,{"$f":"IFERROR(AJ43-AJ42,\"\")","v":30}]
[null,"Azonos elszámolható költségekre megítélt COVID Közlemény 3.1 és de minimis szerinti állami támogatások",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2024-05-15",0,66363636.363636464,-701727.27272727375,-84545.454545454661,31,null,38,38,"2024-06-15",66363636.363636464,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ43,T$7:T$126,\"<=\"&AJ44),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK44)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-701727.27272727375,66363636.363636464,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ43,T$7:T$126,\"<=\"&AJ44),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN44)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-84545.454545454661,null,617181.81818181905,536476.66427946207,31]
[null,"Mezőgazdasági ágazatra megítélt támogatás teljes összege (EUR):",null,null,null,null,null,null,null,false,null,null,null,"",{"$f":"IF(ISBLANK(L44),0,M44+O44)","v":0},0,0,"",null,null,null,"","","","","","2024-06-15",0,65454545.454545557,-669788.29389788408,-80697.384806973962,30,null,39,39,"2024-07-15",65454545.454545557,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ44,T$7:T$126,\"<=\"&AJ45),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK45)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-669788.29389788408,65454545.454545557,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ44,T$7:T$126,\"<=\"&AJ45),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN45)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-80697.384806973962,null,589090.90909091011,510591.08502896799,30]
[null,"Halászati, akvakultúra ágazatra  megítélt támogatás teljes összeg (EUR):",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2024-07-15",0,64545454.545454651,-682501.86799501977,-82229.140722291544,31,null,40,40,"2024-08-15",64545454.545454651,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ45,T$7:T$126,\"<=\"&AJ46),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK46)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-682501.86799501977,64545454.545454651,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ45,T$7:T$126,\"<=\"&AJ46),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN46)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-82229.140722291544,null,600272.72727272823,518791.33516545407,31]
[null,"Egyéb ágazatra megítélt támogatás tejes összege (EUR):",null,null,null,null,null,null,null,false,null,null,null,"",{"$f":"IF(ISBLANK(L46),0,M46+O46)","v":0},0,0,"",null,null,null,"","",{"$f":"IFERROR(-W47*piacikamat/365*(T47-V47),\"\")","v":""},{"$f":"IFERROR(-W47*tenylegeskamat/365*(T47-V47),\"\")","v":""},"","2024-08-15",0,63636363.636363745,{"$f":"IFERROR(-(AC47-AB47)*piacikamat/365*(AJ47-AA47),0)","v":-672889.16562889284},{"$f":"IFERROR(-(AC47-AB47)*tenylegeskamat/365*(AJ47-AA47),0)","v":-81070.983810709979},{"$f":"IFERROR(AJ47-AA47,\"\")","v":31},null,41,{"$f":"IF(COUNT(AJ47)=1,AI46+1,\"\")","v":41},"2024-09-15",{"$f":"+IF(COUNT(AK46)<>0,SUM(AK46:AL46)*(1-J47),\"\")","v":63636363.636363745},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ46,T$7:T$126,\"<=\"&AJ47),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK47)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-672889.16562889284,63636363.636363745,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ46,T$7:T$126,\"<=\"&AJ47),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN47)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-81070.983810709979,null,{"$f":"IFERROR(MAX((ABS(AM47)-ABS(AP47)),0),\"\")","v":591818.18181818281},510018.11287733389,{"$f":"IFERROR(AJ47-AJ46,\"\")","v":31}]
[null,{"$f":"IF(C48>200000,\"A megadott érték nem haladhatja meg a 200 000 eurót\",\"Az igényelt hitelhez megítélt ugyanazon elszámolható költségekhez kapcsolódó de minimis támogatások összege (EUR)\")","v":"Az igényelt hitelhez megítélt ugyanazon elszámolható költségekhez kapcsolódó de minimis támogatások összege (EUR)"},null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2024-09-15",0,62727272.727272838,-641880.44831880566,-77334.99377335007,30,null,42,42,"2024-10-15",62727272.727272838,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ47,T$7:T$126,\"<=\"&AJ48),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK48)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-641880.44831880566,62727272.727272838,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ47,T$7:T$126,\"<=\"&AJ48),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN48)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-77334.99377335007,null,564545.45454545564,485120.25330680347,30]
[null,{"$f":"IF(C49>15000,\"A megadott érték nem haladhatja meg a 15 000 eurót\",\"Az igényelt hitelhez megítélt ugyanazon elszámolható költségekhez kapcsolódó agrár de minimis támogatások összege (EUR)\")","v":"Az igényelt hitelhez megítélt ugyanazon elszámolható költségekhez kapcsolódó agrár de minimis támogatások összege (EUR)"},null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2024-10-15",0,61818181.818181932,-653663.76089663885,-78754.669987546833,31,null,43,43,"2024-11-15",61818181.818181932,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ48,T$7:T$126,\"<=\"&AJ49),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK49)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-653663.76089663885,61818181.818181932,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ48,T$7:T$126,\"<=\"&AJ49),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN49)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-78754.669987546833,null,574909.09090909199,492609.58992690302,31]
[null,{"$f":"IF(C50>30000,\"A megadott érték nem haladhatja meg a 30 000 eurót\",\"Az igényelt hitelhez megítélt ugyanazon elszámolható költségekhez kapcsolódó halászati de minimis támogatások összege (EUR)\")","v":"Az igényelt hitelhez megítélt ugyanazon elszámolható költségekhez kapcsolódó halászati de minimis támogatások összege (EUR)"},null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2024-11-15",0,60909090.909091026,-623275.21793275338,-75093.399750934143,30,null,44,44,"2024-12-15",60909090.909091026,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ49,T$7:T$126,\"<=\"&AJ50),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK50)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-623275.21793275338,60909090.909091026,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ49,T$7:T$126,\"<=\"&AJ50),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN50)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-75093.399750934143,null,548181.81818181928,468361.84477836615,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2024-12-15",0,60000000.000000119,-634438.35616438475,-76438.356164383717,31,null,45,45,"2025-01-15",60000000.000000119,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ50,T$7:T$126,\"<=\"&AJ51),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK51)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-634438.35616438475,60000000.000000119,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ50,T$7:T$126,\"<=\"&AJ51),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN51)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-76438.356164383717,null,558000.00000000105,475383.68703238736,31]
[null,"Azonos megyében folytatott működés során megítélt regionális beruházási támogatások",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2025-01-15",0,59090909.090909213,-624825.65379825782,-75280.199252802151,31,null,46,46,"2025-02-15",59090909.090909213,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ51,T$7:T$126,\"<=\"&AJ52),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK52)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-624825.65379825782,59090909.090909213,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ51,T$7:T$126,\"<=\"&AJ52),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN52)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-75280.199252802151,null,549545.45454545564,466838.74251081439,31]
[null,"Regionális alapon megítélt beruházási támogatások teljes összege (14. cikk), az azonos tevékenységre, azonos megyében (EUR)",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2025-02-15",0,58181818.181818306,-555676.21419676335,-66948.941469489553,28,null,47,47,"2025-03-15",58181818.181818306,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ52,T$7:T$126,\"<=\"&AJ53),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK53)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-555676.21419676335,58181818.181818306,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ52,T$7:T$126,\"<=\"&AJ53),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN53)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-66948.941469489553,null,488727.27272727381,413983.50787608686,28]
[null,"KKV-ék részére megítélt beruházási támogatások",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2025-03-15",0,57272727.2727274,-605600.24906600383,-72963.885429639005,31,null,48,48,"2025-04-15",57272727.2727274,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ53,T$7:T$126,\"<=\"&AJ54),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK54)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-605600.24906600383,57272727.2727274,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ53,T$7:T$126,\"<=\"&AJ54),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN54)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-72963.885429639005,null,532636.36363636481,449883.92238497228,31]
[null,"17-es cikk alapján elszámolható költségre (KKV-ék részére nyújtott beruházási támogatások) megítélt támogatások összege (EUR)",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2025-04-15",0,56363636.363636494,-576762.14196762268,-69489.414694894309,30,null,49,49,"2025-05-15",56363636.363636494,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ54,T$7:T$126,\"<=\"&AJ55),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK55)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-576762.14196762268,56363636.363636494,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ54,T$7:T$126,\"<=\"&AJ55),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN55)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-69489.414694894309,null,507272.72727272834,427232.58478063403,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2025-05-15",0,55454545.454545587,-586374.84433374996,-70647.571606475874,31,null,50,50,"2025-06-15",55454545.454545587,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ55,T$7:T$126,\"<=\"&AJ56),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK56)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-586374.84433374996,55454545.454545587,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ55,T$7:T$126,\"<=\"&AJ56),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN56)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-70647.571606475874,null,515727.2727272741,433107.94252555049,31]
[null,"Korábban megítélt támogatások adatai",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2025-06-15",0,54545454.545454681,-558156.91158157052,-67247.820672478381,30,null,51,51,"2025-07-15",54545454.545454681,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ56,T$7:T$126,\"<=\"&AJ57),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK57)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-558156.91158157052,54545454.545454681,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ56,T$7:T$126,\"<=\"&AJ57),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN57)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-67247.820672478381,null,490909.0909090921,411083.75901883392,30]
[null,"Korábban megítélt állami támogatások rendeleti alapja","ABER",null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2025-07-15",0,53636363.636363775,-567149.43960149586,-68331.257783312758,31,null,52,52,"2025-08-15",53636363.636363775,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ57,T$7:T$126,\"<=\"&AJ58),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK58)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-567149.43960149586,53636363.636363775,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ57,T$7:T$126,\"<=\"&AJ58),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN58)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-68331.257783312758,null,498818.1818181831,416509.31086761528,31]
[null,"Korábban megítélt állami támogatások jogcíme",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2025-08-15",0,52727272.727272868,-557536.73723536893,-67173.100871731178,31,null,53,53,"2025-09-15",52727272.727272868,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ58,T$7:T$126,\"<=\"&AJ59),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK59)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-557536.73723536893,52727272.727272868,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ58,T$7:T$126,\"<=\"&AJ59),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN59)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-67173.100871731178,null,490363.63636363775,408276.0374148339,31]
[null,"Korábban megítélt állami támogatás összege (EUR)",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2025-09-15",0,51818181.818181962,-530249.06600249221,-63885.429638854468,30,null,54,54,"2025-10-15",51818181.818181962,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ59,T$7:T$126,\"<=\"&AJ60),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK60)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-530249.06600249221,51818181.818181962,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ59,T$7:T$126,\"<=\"&AJ60),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN60)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-63885.429638854468,null,466363.63636363775,387180.5289377945,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2025-10-15",0,50909090.909091055,-538311.33250311483,-64856.787048568061,31,null,55,55,"2025-11-15",50909090.909091055,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ60,T$7:T$126,\"<=\"&AJ61),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK61)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-538311.33250311483,50909090.909091055,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ60,T$7:T$126,\"<=\"&AJ61),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN61)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-64856.787048568061,null,473454.54545454675,391940.65496551857,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2025-11-15",0,50000000.000000149,-511643.83561643987,-61643.83561643854,30,null,56,56,"2025-12-15",50000000.000000149,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ61,T$7:T$126,\"<=\"&AJ62),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK62)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-511643.83561643987,50000000.000000149,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ61,T$7:T$126,\"<=\"&AJ62),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN62)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-61643.83561643854,null,450000.00000000134,371456.30315900879,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2025-12-15",0,49090909.090909243,-519085.9277708609,-62540.473225404916,31,null,57,57,"2026-01-15",49090909.090909243,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ62,T$7:T$126,\"<=\"&AJ63),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK63)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-519085.9277708609,49090909.090909243,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ62,T$7:T$126,\"<=\"&AJ63),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN63)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-62540.473225404916,null,456545.45454545598,375778.9394812223,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2026-01-15",0,48181818.181818336,-509473.22540473391,-61382.316313823358,31,null,58,58,"2026-02-15",48181818.181818336,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ63,T$7:T$126,\"<=\"&AJ64),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK64)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-509473.22540473391,48181818.181818336,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ63,T$7:T$126,\"<=\"&AJ64),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN64)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-61382.316313823358,null,448090.90909091057,367762.75231865398,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2026-02-15",0,47272727.27272743,-451486.92403487081,-54396.014943960326,28,null,59,59,"2026-03-15",47272727.27272743,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ64,T$7:T$126,\"<=\"&AJ65),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK65)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-451486.92403487081,47272727.27272743,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ64,T$7:T$126,\"<=\"&AJ65),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN65)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-54396.014943960326,null,397090.90909091046,324971.10513661557,28]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2026-03-15",0,46363636.363636523,-490247.82067247992,-59066.002490660227,31,null,60,60,"2026-04-15",46363636.363636523,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ65,T$7:T$126,\"<=\"&AJ66),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK66)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-490247.82067247992,46363636.363636523,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ65,T$7:T$126,\"<=\"&AJ66),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN66)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-59066.002490660227,null,431181.81818181969,351858.81608301221,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2026-04-15",0,45454545.454545617,-465130.75965130929,-56039.8505603987,30,null,61,61,"2026-05-15",45454545.454545617,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ66,T$7:T$126,\"<=\"&AJ67),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK67)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-465130.75965130929,45454545.454545617,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ66,T$7:T$126,\"<=\"&AJ67),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN67)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-56039.8505603987,null,409090.90909091057,332874.87854109384,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2026-05-15",0,44545454.545454711,-471022.41594022588,-56749.688667497096,31,null,62,62,"2026-06-15",44545454.545454711,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ67,T$7:T$126,\"<=\"&AJ68),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK68)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-471022.41594022588,44545454.545454711,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ67,T$7:T$126,\"<=\"&AJ68),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN68)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-56749.688667497096,null,414272.72727272881,336124.93448264361,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2026-06-15",0,43636363.636363804,-446525.52926525701,-53798.256537982772,30,null,63,63,"2026-07-15",43636363.636363804,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ68,T$7:T$126,\"<=\"&AJ69),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK69)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-446525.52926525701,43636363.636363804,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ68,T$7:T$126,\"<=\"&AJ69),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN69)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-53798.256537982772,null,392727.27272727422,317730.30788950948,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2026-07-15",0,42727272.727272898,-451797.0112079719,-54433.374844333965,31,null,64,64,"2026-08-15",42727272.727272898,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ69,T$7:T$126,\"<=\"&AJ70),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK70)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-451797.0112079719,42727272.727272898,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ69,T$7:T$126,\"<=\"&AJ70),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN70)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-54433.374844333965,null,397363.63636363792,320559.68160636449,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,{"$f":"IF(AND(ISBLANK(L70),AH71<>1),0,IFERROR(-O71*piacikamat/365*(IF(ISBLANK(L71),$C$27,L71)-N71),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(L70),AH71<>1),0,IFERROR(-O71*tenylegeskamat/365*(IF(ISBLANK(L71),$C$27,L71)-N71),\"\"))","v":0},{"$f":"IFERROR(IF(ISBLANK(L71),$C$27,L71)-N71,\"\")","v":""},null,null,null,"","","","",{"$f":"IFERROR(T71-V71,\"\")","v":""},"2026-08-15",0,41818181.818181992,-442184.3088418449,-53275.217932752399,31,null,65,65,"2026-09-15",41818181.818181992,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ70,T$7:T$126,\"<=\"&AJ71),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK71)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-442184.3088418449,41818181.818181992,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ70,T$7:T$126,\"<=\"&AJ71),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN71)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-53275.217932752399,null,388909.09090909251,312839.84828496317,31]
[null,null,null,null,null,null,null,null,null,{"$f":"AI72>$D$15","v":false},null,null,null,"",0,0,0,"",null,null,null,{"$f":"IF(ISNA(MAX(T71,INDEX(AJ$6:AJ$126,MATCH(T72-1,AJ$6:AJ$126,1)))),\"\",MAX(T71,INDEX(AJ$6:AJ$126,MATCH(T72-1,AJ$6:AJ$126,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(W71),W71=\"\"),INDEX(AK$7:AK$126,MATCH(T72,AJ$7:AJ$126,1)),W71-U71),INDEX(AK$7:AK$126,MATCH(T72,AJ$7:AJ$126,1)))),\"\",MIN(IF(OR(ISBLANK(W71),W71=\"\"),INDEX(AK$7:AK$126,MATCH(T72,AJ$7:AJ$126,1)),W71-U71),INDEX(AK$7:AK$126,MATCH(T72,AJ$7:AJ$126,1))))","v":""},"","","",{"$f":"MAX(AJ71,IF(ISNA(INDEX(T$7:T$126,MATCH(AJ72,T$7:T$126,1))),0,INDEX(T$7:T$126,MATCH(AJ72,T$7:T$126,1))))","v":"2026-09-15"},{"$f":"IF(ISNA(INDEX(U$7:U$126,MATCH(AJ72,T$7:T$126,1))),0,INDEX(U$7:U$126,MATCH(AJ72,T$7:T$126,1)))","v":0},{"$f":"IF(ISNA(INDEX(W$7:W$126,MATCH(AJ72,T$7:T$126,1))),AK72,INDEX(W$7:W$126,MATCH(AJ72,T$7:T$126,1)))","v":40909090.909091085},-418617.68368617859,-50435.865504358866,30,null,66,66,{"$f":"IF(OR(AJ71=$C$28,AJ71=\"\"),\"\",IFERROR(IF(EDATE($C$27,(AH72-1)*12/$D$19)<=$C$28,EDATE($C$27,(AH72-1)*12/$D$19),$C$28),\"\"))","v":"2026-10-15"},40909090.909091085,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ71,T$7:T$126,\"<=\"&AJ72),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK72)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(X$7:X$126,T$7:T$126,\">\"&AJ71,T$7:T$126,\"<=\"&AJ72)+AD72,IFERROR(-AK72*piacikamat/365*(AJ72-AJ71),\"\"))","v":-418617.68368617859},{"$f":"+IF(COUNT(AN71)<>0,SUM(AN71:AO71)*(1-J72),\"\")","v":40909090.909091085},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ71,T$7:T$126,\"<=\"&AJ72),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN72)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Y$7:Y$126,T$7:T$126,\">\"&AJ71,T$7:T$126,\"<=\"&AJ72)+AE72,IFERROR(-AN72*tenylegeskamat/365*(AJ72-AJ71),\"\"))","v":-50435.865504358866},null,368181.81818181975,{"$f":"IFERROR(AR72/POWER(1+($C$11+1%)/$D$19,AI72-1)/(1+($C$11+1%)/365*($AJ$7-$C$25)),\"\")","v":295317.71835125505},30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,{"$f":"IF(ISBLANK(L72),\"\",L72)","v":""},0,0,0,"",null,null,null,"","","","","","2026-10-15",0,40000000.000000179,-422958.90410959092,-50958.904109589268,31,null,67,67,"2026-11-15",40000000.000000179,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ72,T$7:T$126,\"<=\"&AJ73),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK73)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-422958.90410959092,40000000.000000179,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ72,T$7:T$126,\"<=\"&AJ73),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN73)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-50958.904109589268,null,372000.00000000163,297524.88841330208,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2026-11-15",0,39090909.090909272,-400012.45330012636,-48194.271481942931,30,null,68,68,"2026-12-15",39090909.090909272,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ73,T$7:T$126,\"<=\"&AJ74),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK74)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-400012.45330012636,39090909.090909272,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ73,T$7:T$126,\"<=\"&AJ74),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN74)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-48194.271481942931,null,351818.18181818345,280576.85039175116,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2026-12-15",0,38181818.181818366,-403733.49937733694,-48642.590286426144,31,null,69,69,"2027-01-15",38181818.181818366,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ74,T$7:T$126,\"<=\"&AJ75),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK75)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-403733.49937733694,38181818.181818366,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ74,T$7:T$126,\"<=\"&AJ75),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN75)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-48642.590286426144,null,355090.90909091081,282375.03936651896,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2027-01-15",0,37272727.27272746,-394120.79701121,-47484.433374844564,31,null,70,70,"2027-02-15",37272727.27272746,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ75,T$7:T$126,\"<=\"&AJ76),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK76)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-394120.79701121,37272727.27272746,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ75,T$7:T$126,\"<=\"&AJ76),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN76)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-47484.433374844564,null,346636.36363636545,274861.5970519823,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2027-02-15",0,36363636.363636553,-347297.63387297816,-41843.088418431107,28,null,71,71,"2027-03-15",36363636.363636553,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ76,T$7:T$126,\"<=\"&AJ77),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK77)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-347297.63387297816,36363636.363636553,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ76,T$7:T$126,\"<=\"&AJ77),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN77)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-41843.088418431107,null,305454.54545454704,241512.56616238554,28]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2027-03-15",0,35454545.454545647,-374895.39227895602,-45168.119551681433,31,null,72,72,"2027-04-15",35454545.454545647,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ77,T$7:T$126,\"<=\"&AJ78),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK78)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-374895.39227895602,35454545.454545647,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ77,T$7:T$126,\"<=\"&AJ78),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN78)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-45168.119551681433,null,329727.27272727457,259956.81388358847,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2027-04-15",0,34545454.545454741,-353499.37733499578,-42590.286425903105,30,null,73,73,"2027-05-15",34545454.545454741,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ78,T$7:T$126,\"<=\"&AJ79),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK79)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-353499.37733499578,34545454.545454741,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ78,T$7:T$126,\"<=\"&AJ79),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN79)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-42590.286425903105,null,310909.09090909269,244417.86755327473,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2027-05-15",0,33636363.636363834,-355669.98754670192,-42851.805728518309,31,null,74,74,"2027-06-15",33636363.636363834,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ79,T$7:T$126,\"<=\"&AJ80),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK80)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-355669.98754670192,33636363.636363834,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ79,T$7:T$126,\"<=\"&AJ80),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN80)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-42851.805728518309,null,312818.18181818363,245213.68966292628,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2027-06-15",0,32727272.727272924,-334894.14694894344,-40348.692403487163,30,null,75,75,"2027-07-15",32727272.727272924,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ80,T$7:T$126,\"<=\"&AJ81),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK81)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-334894.14694894344,32727272.727272924,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ80,T$7:T$126,\"<=\"&AJ81),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN81)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-40348.692403487163,null,294545.45454545628,230228.05496617482,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2027-07-15",0,31818181.818182014,-336444.58281444793,-40535.491905355171,31,null,76,76,"2027-08-15",31818181.818182014,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ81,T$7:T$126,\"<=\"&AJ82),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK82)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-336444.58281444793,31818181.818182014,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ81,T$7:T$126,\"<=\"&AJ82),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN82)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-40535.491905355171,null,295909.09090909275,230630.8618631617,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2027-08-15",0,30909090.909091104,-326831.88044832088,-39377.334993773598,31,null,77,77,"2027-09-15",30909090.909091104,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ82,T$7:T$126,\"<=\"&AJ83),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK83)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-326831.88044832088,30909090.909091104,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ82,T$7:T$126,\"<=\"&AJ83),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN83)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-39377.334993773598,null,287454.54545454727,223399.13615063831,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2027-09-15",0,30000000.000000194,-306986.30136986496,-36986.301369863249,30,null,78,78,"2027-10-15",30000000.000000194,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ83,T$7:T$126,\"<=\"&AJ84),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK84)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-306986.30136986496,30000000.000000194,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ83,T$7:T$126,\"<=\"&AJ84),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN84)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-36986.301369863249,null,270000.00000000169,209232.55960662614,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2027-10-15",0,29090909.090909284,-307606.47571606678,-37061.02117061046,31,null,79,79,"2027-11-15",29090909.090909284,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ84,T$7:T$126,\"<=\"&AJ85),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK85)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-307606.47571606678,29090909.090909284,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ84,T$7:T$126,\"<=\"&AJ85),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN85)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-37061.02117061046,null,270545.45454545633,209054.22076154608,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2027-11-15",0,28181818.181818374,-288381.07098381268,-34744.707347447307,30,null,80,80,"2027-12-15",28181818.181818374,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ85,T$7:T$126,\"<=\"&AJ86),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK86)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-288381.07098381268,28181818.181818374,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ85,T$7:T$126,\"<=\"&AJ86),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN86)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-34744.707347447307,null,253636.36363636536,195426.48083155876,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2027-12-15",0,27272727.272727463,-288381.07098381274,-34744.707347447315,31,null,81,81,"2028-01-15",27272727.272727463,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ86,T$7:T$126,\"<=\"&AJ87),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK87)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-288381.07098381274,27272727.272727463,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ86,T$7:T$126,\"<=\"&AJ87),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN87)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-34744.707347447315,null,253636.36363636542,194866.24039043632,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2028-01-15",0,26363636.363636553,-278768.36861768569,-33586.550435865742,31,null,82,82,"2028-02-15",26363636.363636553,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ87,T$7:T$126,\"<=\"&AJ88),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK88)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-278768.36861768569,26363636.363636553,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ87,T$7:T$126,\"<=\"&AJ88),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN88)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-33586.550435865742,null,245181.81818181995,187830.68582234927,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2028-02-15",0,25454545.454545643,-251790.7845579097,-30336.239103362612,29,null,83,83,"2028-03-15",25454545.454545643,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ88,T$7:T$126,\"<=\"&AJ89),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK89)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-251790.7845579097,25454545.454545643,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ88,T$7:T$126,\"<=\"&AJ89),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN89)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-30336.239103362612,null,221454.5454545471,169167.16707291635,29]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2028-03-15",0,24545454.545454733,-259542.96388543161,-31270.236612702603,31,null,84,84,"2028-04-15",24545454.545454733,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ89,T$7:T$126,\"<=\"&AJ90),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK90)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-259542.96388543161,24545454.545454733,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ89,T$7:T$126,\"<=\"&AJ90),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN90)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-31270.236612702603,null,228272.72727272901,173875.62339558374,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2028-04-15",0,23636363.636363823,-241867.99501868183,-29140.722291407448,30,null,85,85,"2028-05-15",23636363.636363823,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ90,T$7:T$126,\"<=\"&AJ91),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK91)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-241867.99501868183,23636363.636363823,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ90,T$7:T$126,\"<=\"&AJ91),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN91)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-29140.722291407448,null,212727.27272727439,161570.11703485737,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2028-05-15",0,22727272.727272913,-240317.55915317757,-28953.922789539462,31,null,86,86,"2028-06-15",22727272.727272913,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ91,T$7:T$126,\"<=\"&AJ92),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK92)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-240317.55915317757,22727272.727272913,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ91,T$7:T$126,\"<=\"&AJ92),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN92)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-28953.922789539462,null,211363.6363636381,160074.19783764562,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2028-06-15",0,21818181.818182003,-223262.76463262955,-26899.12826899151,30,null,87,87,"2028-07-15",21818181.818182003,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ92,T$7:T$126,\"<=\"&AJ93),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK93)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-223262.76463262955,21818181.818182003,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ92,T$7:T$126,\"<=\"&AJ93),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN93)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-26899.12826899151,null,196363.63636363804,148287.76614730054,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2028-07-15",0,20909090.909091093,-221092.1544209235,-26637.608966376323,31,null,88,88,"2028-08-15",20909090.909091093,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ93,T$7:T$126,\"<=\"&AJ94),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK94)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-221092.1544209235,20909090.909091093,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ93,T$7:T$126,\"<=\"&AJ94),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN94)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-26637.608966376323,null,194454.54545454719,146425.10734835311,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2028-08-15",0,20000000.000000183,-211479.45205479645,-25479.45205479475,31,null,89,89,"2028-09-15",20000000.000000183,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ94,T$7:T$126,\"<=\"&AJ95),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK95)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-211479.45205479645,20000000.000000183,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ94,T$7:T$126,\"<=\"&AJ95),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN95)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-25479.45205479475,null,186000.00000000169,139657.28364273449,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2028-09-15",0,19090909.090909272,-195354.91905355104,-23536.737235367596,30,null,90,90,"2028-10-15",19090909.090909272,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ95,T$7:T$126,\"<=\"&AJ96),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK96)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-195354.91905355104,19090909.090909272,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ95,T$7:T$126,\"<=\"&AJ96),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN96)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-23536.737235367596,null,171818.18181818345,128639.09032049392,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2028-10-15",0,18181818.181818362,-192254.04732254238,-23163.138231631612,31,null,91,91,"2028-11-15",18181818.181818362,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ96,T$7:T$126,\"<=\"&AJ97),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK97)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-192254.04732254238,18181818.181818362,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ96,T$7:T$126,\"<=\"&AJ97),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN97)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-23163.138231631612,null,169090.90909091078,126234.2764531437,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2028-11-15",0,17272727.272727452,-176749.68866749873,-21295.143212951651,30,null,92,92,"2028-12-15",17272727.272727452,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ97,T$7:T$126,\"<=\"&AJ98),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK98)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-176749.68866749873,17272727.272727452,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ97,T$7:T$126,\"<=\"&AJ98),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN98)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-21295.143212951651,null,155454.54545454707,115721.39386086281,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2028-12-15",0,16363636.363636544,-173028.64259028833,-20846.82440846847,31,null,93,93,"2029-01-15",16363636.363636544,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ98,T$7:T$126,\"<=\"&AJ99),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK99)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-173028.64259028833,16363636.363636544,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ98,T$7:T$126,\"<=\"&AJ99),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN99)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-20846.82440846847,null,152181.81818181986,112960.39286063354,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2029-01-15",0,15454545.454545636,-163415.94022416128,-19688.667496886908,31,null,94,94,"2029-02-15",15454545.454545636,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ99,T$7:T$126,\"<=\"&AJ100),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK100)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-163415.94022416128,15454545.454545636,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ99,T$7:T$126,\"<=\"&AJ100),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN100)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-19688.667496886908,null,143727.27272727437,106378.97592370662,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2029-02-15",0,14545454.545454727,-138919.05354919229,-16737.235367372563,28,null,95,95,"2029-03-15",14545454.545454727,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ100,T$7:T$126,\"<=\"&AJ101),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK101)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-138919.05354919229,14545454.545454727,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ100,T$7:T$126,\"<=\"&AJ101),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN101)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-16737.235367372563,null,122181.81818181973,90172.975113665161,28]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2029-03-15",0,13636363.636363819,-144190.5354919073,-17372.35367372377,31,null,96,96,"2029-04-15",13636363.636363819,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ101,T$7:T$126,\"<=\"&AJ102),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK102)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-144190.5354919073,13636363.636363819,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ101,T$7:T$126,\"<=\"&AJ102),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN102)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-17372.35367372377,null,126818.18181818353,93326.40406121315,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,{"$f":"IF(AND(ISBLANK(L102),AH103<>1),0,IFERROR(-O103*piacikamat/365*(IF(ISBLANK(L103),$C$27,L103)-N103),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(L102),AH103<>1),0,IFERROR(-O103*tenylegeskamat/365*(IF(ISBLANK(L103),$C$27,L103)-N103),\"\"))","v":0},{"$f":"IFERROR(IF(ISBLANK(L103),$C$27,L103)-N103,\"\")","v":""},null,null,null,"","","","","","2029-04-15",0,12727272.727272911,-130236.61270236799,-15691.158156911804,30,null,97,97,"2029-05-15",12727272.727272911,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ102,T$7:T$126,\"<=\"&AJ103),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK103)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-130236.61270236799,12727272.727272911,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ102,T$7:T$126,\"<=\"&AJ103),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN103)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-15691.158156911804,null,114545.45454545619,84053.163725706996,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2029-05-15",0,11818181.818182003,-124965.13075965326,-15056.039850560632,31,null,98,98,{"$f":"IF(OR(AJ103=$C$28,AJ103=\"\"),\"\",IFERROR(IF(EDATE($C$27,(AH104-1)*12/$D$19)<=$C$28,EDATE($C$27,(AH104-1)*12/$D$19),$C$28),\"\"))","v":"2029-06-15"},11818181.818182003,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ103,T$7:T$126,\"<=\"&AJ104),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK104)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(X$7:X$126,T$7:T$126,\">\"&AJ103,T$7:T$126,\"<=\"&AJ104)+AD104,IFERROR(-AK104*piacikamat/365*(AJ104-AJ103),\"\"))","v":-124965.13075965326},11818181.818182003,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ103,T$7:T$126,\"<=\"&AJ104),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN104)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Y$7:Y$126,T$7:T$126,\">\"&AJ103,T$7:T$126,\"<=\"&AJ104)+AE104,IFERROR(-AN104*tenylegeskamat/365*(AJ104-AJ103),\"\"))","v":-15056.039850560632},null,109909.09090909263,{"$f":"IFERROR(AR104/POWER(1+($C$11+1%)/$D$19,AI104-1)/(1+($C$11+1%)/365*($AJ$7-$C$25)),\"\")","v":80419.804921469738},31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2029-06-15",0,10909090.909091095,-111631.38231631572,-13449.564134495869,30,null,99,99,"2029-07-15",10909090.909091095,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ104,T$7:T$126,\"<=\"&AJ105),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK105)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-111631.38231631572,10909090.909091095,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ104,T$7:T$126,\"<=\"&AJ105),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN105)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-13449.564134495869,null,98181.81818181985,71633.086567753315,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2029-07-15",0,10000000.000000186,-105739.72602739924,-12739.726027397497,31,null,100,100,"2029-08-15",10000000.000000186,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ105,T$7:T$126,\"<=\"&AJ106),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK106)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-105739.72602739924,10000000.000000186,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ105,T$7:T$126,\"<=\"&AJ106),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN106)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-12739.726027397497,null,93000.000000001746,67657.934880562607,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2029-08-15",0,9090909.090909278,-96127.023661272222,-11581.569115815932,31,null,101,101,"2029-09-15",9090909.090909278,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ106,T$7:T$126,\"<=\"&AJ107),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK107)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-96127.023661272222,9090909.090909278,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ106,T$7:T$126,\"<=\"&AJ107),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN107)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-11581.569115815932,null,84545.45454545629,61330.887227006657,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2029-09-15",0,8181818.1818183688,-83723.536737237286,-10087.173100871962,30,null,102,102,"2029-10-15",8181818.1818183688,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ107,T$7:T$126,\"<=\"&AJ108),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK108)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-83723.536737237286,8181818.1818183688,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ107,T$7:T$126,\"<=\"&AJ108),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN108)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-10087.173100871962,null,73636.36363636532,53264.090099968518,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2029-10-15",0,7272727.2727274597,-76901.618929018165,-9265.2552926527915,31,null,103,103,"2029-11-15",7272727.2727274597,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ108,T$7:T$126,\"<=\"&AJ109),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK109)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-76901.618929018165,7272727.2727274597,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ108,T$7:T$126,\"<=\"&AJ109),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN109)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-9265.2552926527915,null,67636.363636365379,48783.799704709068,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2029-11-15",0,6363636.3636365505,-65118.306351184976,-7845.5790784560204,30,null,104,104,"2029-12-15",6363636.3636365505,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ109,T$7:T$126,\"<=\"&AJ110),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK110)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-65118.306351184976,6363636.3636365505,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ109,T$7:T$126,\"<=\"&AJ110),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN110)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-7845.5790784560204,null,57272.727272728953,41190.440137785088,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",{"$f":"IF(ISBLANK(L110),0,M110+O110)","v":0},0,0,"",null,null,null,"","",{"$f":"IFERROR(-W111*piacikamat/365*(T111-V111),\"\")","v":""},{"$f":"IFERROR(-W111*tenylegeskamat/365*(T111-V111),\"\")","v":""},"","2029-12-15",0,5454545.4545456413,{"$f":"IFERROR(-(AC111-AB111)*piacikamat/365*(AJ111-AA111),0)","v":-57676.214196764115},{"$f":"IFERROR(-(AC111-AB111)*tenylegeskamat/365*(AJ111-AA111),0)","v":-6948.9414694896523},{"$f":"IFERROR(AJ111-AA111,\"\")","v":31},null,105,{"$f":"IF(COUNT(AJ111)=1,AI110+1,\"\")","v":105},"2030-01-15",{"$f":"+IF(COUNT(AK110)<>0,SUM(AK110:AL110)*(1-J111),\"\")","v":5454545.4545456413},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ110,T$7:T$126,\"<=\"&AJ111),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK111)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-57676.214196764115,5454545.4545456413,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ110,T$7:T$126,\"<=\"&AJ111),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN111)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-6948.9414694896523,null,{"$f":"IFERROR(MAX((ABS(AM111)-ABS(AP111)),0),\"\")","v":50727.27272727446},36378.373441251933,{"$f":"IFERROR(AJ111-AJ110,\"\")","v":31}]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2030-01-15",0,4545454.5454547321,-48063.511830637093,-5790.7845579080831,31,null,106,106,"2030-02-15",4545454.5454547321,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ111,T$7:T$126,\"<=\"&AJ112),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK112)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-48063.511830637093,4545454.5454547321,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ111,T$7:T$126,\"<=\"&AJ112),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN112)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-5790.7845579080831,null,42272.727272729011,30228.404537996754,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2030-02-15",0,3636363.636363823,-34729.763387299419,-4184.3088418433035,28,null,107,107,"2030-03-15",3636363.636363823,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ112,T$7:T$126,\"<=\"&AJ113),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK113)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-34729.763387299419,3636363.636363823,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ112,T$7:T$126,\"<=\"&AJ113),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN113)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-4184.3088418433035,null,30545.454545456116,21779.843004624097,28]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2030-03-15",0,2727272.7272729138,-28838.107098383043,-3474.4707347449448,31,null,108,108,"2030-04-15",2727272.7272729138,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ113,T$7:T$126,\"<=\"&AJ114),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK114)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-28838.107098383043,2727272.7272729138,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ113,T$7:T$126,\"<=\"&AJ114),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN114)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-3474.4707347449448,null,25363.636363638099,18033.202751287157,31]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2030-04-15",0,1818181.8181820046,-18605.230386054212,-2241.59402241617,30,null,109,109,"2030-05-15",1818181.8181820046,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ114,T$7:T$126,\"<=\"&AJ115),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK115)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-18605.230386054212,1818181.8181820046,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ114,T$7:T$126,\"<=\"&AJ115),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN115)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-2241.59402241617,null,16363.636363638043,11600.97156242755,30]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2030-05-15",0,909090.90909109556,-4651.3075965140297,-560.39850560410002,15,null,110,110,"2030-05-30",909090.90909109556,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ115,T$7:T$126,\"<=\"&AJ116),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK116)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-4651.3075965140297,909090.90909109556,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ115,T$7:T$126,\"<=\"&AJ116),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN116)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":-909090.90909090906},-560.39850560410002,null,4090.9090909099295,2891.9285958939886,15]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2030-05-30",0,0,0,0,"",null,111,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ116,T$7:T$126,\"<=\"&AJ117),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK117)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ116,T$7:T$126,\"<=\"&AJ117),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN117)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","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,112,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ117,T$7:T$126,\"<=\"&AJ118),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK118)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ117,T$7:T$126,\"<=\"&AJ118),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN118)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","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,113,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ118,T$7:T$126,\"<=\"&AJ119),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK119)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ118,T$7:T$126,\"<=\"&AJ119),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN119)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","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,114,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ119,T$7:T$126,\"<=\"&AJ120),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK120)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ119,T$7:T$126,\"<=\"&AJ120),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN120)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","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,115,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ120,T$7:T$126,\"<=\"&AJ121),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK121)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ120,T$7:T$126,\"<=\"&AJ121),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN121)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","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,116,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ121,T$7:T$126,\"<=\"&AJ122),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK122)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ121,T$7:T$126,\"<=\"&AJ122),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN122)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","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,117,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ122,T$7:T$126,\"<=\"&AJ123),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK123)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ122,T$7:T$126,\"<=\"&AJ123),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN123)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","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,118,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ123,T$7:T$126,\"<=\"&AJ124),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK124)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ123,T$7:T$126,\"<=\"&AJ124),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN124)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","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,119,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ124,T$7:T$126,\"<=\"&AJ125),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK125)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ124,T$7:T$126,\"<=\"&AJ125),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN125)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","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,120,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ125,T$7:T$126,\"<=\"&AJ126),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK126)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$126,T$7:T$126,\">\"&AJ125,T$7:T$126,\"<=\"&AJ126),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN126)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":""},"",null,"","",""]

{"sheet":"Szamitasok","index":2,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":true,"merged":[[19,0,19,9],[17,0,17,9],[21,0,21,9],[0,0,0,9],[2,0,2,1],[6,0,6,9],[7,0,7,9]]}
["Kizárók és KO-k"]
[null,null,null,"Váll. Méret","Mezőgazdasági","Halászat/akvakultúra"]
["Szorzó értéke",null,null,{"$f":"Tamogatastartalom!C21","v":"Mikró/Kis"}]
[{"$f":"PRODUCT(C4:W4)","v":1},"általános",null,null,null,null,null,1]
[{"$f":"PRODUCT(E5:F5)","v":0},"mezőgazdasági",null,null,{"$f":"IF(Tamogatastartalom!C22=\"Mezőgazdasági\",1,0)","v":0},null,null,1]
[{"$f":"PRODUCT(E6:F6)","v":0},"halászati",null,null,null,{"$f":"IF(Tamogatastartalom!C22=\"Halászati\",1,0)","v":0},null,1]
["14-es cikk"]
["R szorzó értéke"]
["Elszámolható ktg-ek EUR-ban",{"$f":"Tamogatastartalom!C23/IF(Tamogatastartalom!C9<>\"EUR\",arfolyam,1)","v":388888.88888888888}]
["A Elszámolható költségek",{"$f":"IF((B9-C10)>0,C10,B9)","v":388888.88888888888},50000000]
["B Elszámolható költségek",{"$f":"IF(B10<C10,0,IF(B9-C11<0,B9-C10,C10))","v":0},100000000]
["C elszámolható költségek","nincs!"]
["KKV bónusz",{"$f":"IF(D3=\"Mikró/Kis\",0.2,IF(D3=\"Közepes\",0.1,0))*IF(B9<50*10^6,1,0)","v":0.2}]
["Kaphat?",{"$f":"IF(B15>0,1,0)","v":1}]
["Alap intenzitás",{"$f":"VLOOKUP(Tamogatastartalom!C36,Adatok!A21:B216,2,FALSE)+IF(Tamogatastartalom!C36=\"Közép_Magyarország\",VLOOKUP(Tamogatastartalom!C37,Adatok!A21:'Adatok'!B216,2,FALSE))","v":0.35}]
["R szorzó értéke a támogatási térkép alapján",{"$f":"(B15+B13)*B14","v":0.55000000000000004}]
["Max. TT (EUR)",{"$f":"VLOOKUP(B15,Adatok!D12:E16,2,FALSE)*10^6","v":26250000}]
["17-es cikk"]
["Vállalatméret-szorzó",{"$f":"IF(D3=\"Nagy\",0,IF(D3=\"Mikró/Kis\",0.2,0.1))","v":0.2}]
["HUF érték"]
["Elszámolható ktg-ek HUF-ban",{"$f":"IF(Tamogatastartalom!C9=\"EUR\",Tamogatastartalom!C23*arfolyam,Tamogatastartalom!C23)","v":140000000}]
["Hitel/támogatástartalom arány"]
["Hitelösszeg",{"$f":"Tamogatastartalom!C24","v":100000000}]
["Támogatástartalom a futamidő alatt",{"$f":"Tamogatastartalom!AR5","v":60281181.818181939}]
["Hitelösszeg/támogatástartalom",{"$f":"B23/B24","v":1.6588924932098481}]

{"sheet":"Adatok","index":3,"n_rows":216,"n_cols":21,"rows_kept":216,"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,"Refin kamatok",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,"Min 1",{"$f":"refkam-3.5%","v":-1.0500000000000002E-2},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,"Min2",1E-3,null,"Egyedi",0,null,"Féléves",2,null,"Lízing"]
[null,null,null,null,"Jó",75,100,220,null,"Tényleges min",{"$f":"MAX(K4:K5)","v":1E-3}]
[null,null,null,null,"Kielégítő",100,220,400,null,"Max",{"$f":"refkammin+4%","v":4.1000000000000002E-2},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]
["Dél-Dunántúl",0.5,null,0.25,18.75]
["Észak-Alföld",0.5,null,0.2,15]
["Észak-Magyarország",0.5,null,0,0]
["Közép-Dunántúl",0.35,null,null,null,null,null,null,null," "]
["Közép_Magyarország",0]
["Nyugat-Dunántúl",0.25]
[null,"14-es cikk"]
["Select",0]
["Budapest",0]
["Abony",0.35]
["Acsa",0]
["Albertirsa",0]
["Alsónémedi",0.35]
["Apaj",0]
["Áporka",0.35]
["Aszód",0.35]
["Bag",0.35]
["Bénye",0]
["Bernecebaráti",0.35]
["Biatorbágy",0]
["Budajenő",0]
["Budakalász",0]
["Budakeszi",0]
["Budaörs",0]
["Budapest",0]
["Bugyi",0]
["Cegléd",0.35]
["Ceglédbercel",0]
["Csemő",0.35]
["Csévharaszt",0]
["Csobánka",0]
["Csomád",0]
["Csömör",0]
["Csörög",0]
["Csővár",0]
["Dabas",0.35]
["Dánszentmiklós",0]
["Dány",0]
["Délegyháza",0]
["Diósd",0]
["Domony",0.35]
["Dömösd",0]
["Dunabogdány",0]
["Dunaharaszti",0.35]
["Dunakeszi",0]
["Dunavarsány",0]
["Ecser",0.35]
["Érd",0.35]
["Erdőkertes",0]
["Farmos",0.35]
["Felsőpakony",0.35]
["Fót",0]
["Galagyörk",0]
["Galahévíz",0]
["Galamácsa",0]
["Gomba",0]
["Göd",0.35]
["Gödöllő",0.35]
["Gyál",0.35]
["Gyömörő",0]
["Halásztelek",0.35]
["Herceghalom",0]
["Hernád",0]
["Hévizgyörk",0]
["Iklad",0.35]
["Inárcs",0]
["Ipolydamásd",0.35]
["Ipolytölgyes",0.35]
["Isaszeg",0]
["Jászkarajenő",0.35]
["Kakucs",0]
["Kartal",0.35]
["Káva",0]
["Kemence",0.35]
["Kerepes",0]
["Kiskunlacháza",0.35]
["Kismaros",0]
["Kisnémedi",0.35]
["Kisoroszi",0]
["Kistarcsa",0]
["Kocsér",0.35]
["Kóka",0]
["Kosd",0]
["Kóspallag",0.35]
["Kőröstételen",0]
["Leányfalu",0]
["Letkés",0.35]
["Lórév",0.35]
["Maglód",0.35]
["Majosháza",0]
["Makád",0.35]
["Márianosztra",0.35]
["Mende",0]
["Mikebuda",0.35]
["Mogyoród",0]
["Monor",0.35]
["Nagybörzsöny",0.35]
["Nagykáta",0.35]
["Nagykovácsi",0]
["Nagykőrös",0.35]
["Nagymaros",0]
["Nagytarcsa",0.35]
["Nyáregyháza",0]
["Nyársapát",0.35]
["Ócsa",0.35]
["Őrbottyán",0]
["Örkény",0.35]
["Pánd",0]
["Páty",0]
["Pécel",0.35]
["Penc",0]
["Perbál",0]
["Perőcsény",0.35]
["Péteri",0.35]
["Pilis",0]
["Pilisborosjenő",0]
["Piliscsaba",0.2]
["Pilisjászfalu",0.2]
["Pilisszántó",0]
["Pilisszentiván",0]
["Pilisszentkereszt",0]
["Pilisszentlászló",0]
["Pilisvörösvár",0]
["Pócsmegyer",0]
["Pomáz",0]
["Pusztavacs",0]
["Pusztazámor",0]
["Püspökhatvan",0.35]
["Püspökszilágy",0.35]
["Ráckeve",0.35]
["Rád",0]
["Remeteszőlős",0]
["Solymár",0]
["Sóskút",0]
["Sülysáp",0]
["Szada",0]
["Százhalombatta",0]
["Szentendre",0]
["Szentmártonkáta",0.35]
["Szentlőrinckáta",0]
["Szigetbecse",0.35]
["Szigetcsép",0]
["Szigethalom",0]
["Szigetmonostor",0]
["Szigetszentmárton",0]
["Szigetszentmiklós",0.35]
["Szigetújfalu",0]
["Szob",0.35]
["Szokolya",0.35]
["Sződ",0]
["Sződliget",0.35]
["Táborfalva",0.35]
["Tahitótfalu",0]
["Taksony",0]
["Tápióbicske",0.35]
["Tápiógyörgye",0.35]
["Tápióság",0.35]
["Tápiószecső",0]
["Tápiószele",0.35]
["Tápiószentmárton",0.35]
["Tápiószőlős",0.35]
["Tárnok",0]
["Tatárszentgyörgy",0.35]
["Telki",0]
["Tésa",0.35]
["Tinnye",0]
["Tóalmás",0]
["Tök",0]
["Tököl",0]
["Törökbálint",0]
["Törtel",0.35]
["Tura",0.35]
["Újhartyán",0.35]
["Újlengyel",0]
["Újszilvás",0.35]
["Úri",0]
["Üllő",0.35]
["Üröm",0]
["Vác",0.35]
["Vácduka",0]
["Vácegres",0]
["Váchartyán",0]
["Váckisújfalu",0.35]
["Vácrátót",0]
["Vácaszentlászló",0]
["Valkó",0.35]
["Vámosmikola",0.35]
["Vasad",0]
["Vecsés",0.35]
["Veresegyház",0]
["Verőce",0.35]
["Verseg",0.35]
["Visegrád",0]
["Zebegény",0.35]
["Zsámbék",0]
["Zsámbok",0]
["Dél-Alföld",0.5]
["Dél-Dunántúl",0.5]
["Észak-Alföld",0.5]
["Észak-Magyarország",0.5]
["Közép-Dunántúl",0.35]
["Közép_Magyarország",0]
["Nyugat-Dunántúl",0.25]