{"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":[[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],[0,19,1,20],[0,11,1,12],[3,1,3,2],[6,5,6,8],[5,1,5,2]]}
[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 több, 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 több, mint a hitelösszeg"}]
[]
[null,"Ügyfél neve: ",null,null,null,"Hitelösszeg (EUR)",null,null,{"$f":"IF(C9=\"HUF\",C24/C10,C24)","v":0},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":"Az ügylet nem finanszírozható"},null,null,{"$f":"IF(C9=\"HUF\",AR5/C10,AR5)","v":0},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":0},null,null,null,null,null,null,{"$f":"SUM(P7:P126)","v":0},{"$f":"SUM(Q7:Q126)","v":0},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":0},{"$f":"SUM(AE7:AE126)","v":0},null,null,null,null,null,{"$f":"+AK7","v":0},{"$f":"SUM(AL7:AL126)","v":0},{"$f":"SUM(AM7:AM126)","v":0},{"$f":"+AN7","v":0},{"$f":"SUM(AO7:AO126)","v":0},{"$f":"SUM(AP7:AP126)","v":0},null,{"$f":"SUM(AR7:AR126)","v":0},{"$f":"SUM(AS7:AS126)","v":0},null,{"$f":"AS5","v":0}]
[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":"00:00:00"}]
[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":true},null,null,null,{"$f":"C26","v":"00:00:00"},{"$f":"IF(ISBLANK(L7),C24,0)","v":0},{"$f":"IF(AND(ISBLANK(L6),AH7<>1),0,IFERROR(-O7*piacikamat/365*(IF(ISBLANK(L7),$C$27,L7)-N7),\"\"))","v":""},{"$f":"IF(AND(ISBLANK(L6),AH7<>1),0,IFERROR(-O7*tenylegeskamat/365*(IF(ISBLANK(L7),$C$27,L7)-N7),\"\"))","v":0},{"$f":"IFERROR(IF(ISBLANK(L7),$C$27,L7)-N7,\"\")","v":0},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":0},{"$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":"00:00:00"},{"$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":0},{"$f":"IFERROR(-(AC7-AB7)*piacikamat/365*(AJ7-AA7),0)","v":0},{"$f":"IFERROR(-(AC7-AB7)*tenylegeskamat/365*(AJ7-AA7),0)","v":0},{"$f":"IFERROR(AJ7-AA7,\"\")","v":0},null,1,{"$f":"+IF(C28-C27<>0,1,\"\")","v":""},{"$f":"C27","v":"00:00:00"},{"$f":"IF(+C24<>0,C24,IF(AI7>0,C24*J7,\"\"))","v":0},{"$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":0},{"$f":"SUM(P7:P126)","v":0},{"$f":"+AK7","v":0},{"$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":0},{"$f":"SUM(Q7:Q126)","v":0},null,{"$f":"IFERROR(MAX((ABS(AM7)-ABS(AP7)),0),\"\")","v":0},{"$f":"IFERROR(AR7/(1+($C$11+1%)/365*(AJ7-C25)),\"\")","v":0},{"$f":"IFERROR(AJ7-AJ6,\"\")","v":0}]
[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":true},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":0},"","","",{"$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":"00:00:00"},{"$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":0},0,0,"",null,2,{"$f":"IF(COUNT(AJ8)=1,AI7+1,\"\")","v":""},{"$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":""},{"$f":"+IF(COUNT(AK7)<>0,SUM(AK7:AL7)*(1-J8),\"\")","v":0},{"$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":0},{"$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":""},{"$f":"+IF(COUNT(AN7)<>0,SUM(AN7:AO7)*(1-J8),\"\")","v":0},{"$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":0},{"$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":""},null,{"$f":"IFERROR(MAX((ABS(AM8)-ABS(AP8)),0),\"\")","v":""},{"$f":"IFERROR(AR8/POWER(1+($C$11+1%)/$D$19,AI8-1)/(1+($C$11+1%)/365*($AJ$7-$C$25)),\"\")","v":""},""]
[null,"Hitel devizaneme",null,"Makrohoz kellenek (ne töröld ki!):",null,null,null,null,null,true,null,null,null,{"$f":"IF(ISBLANK(L8),\"\",L8)","v":""},{"$f":"IF(ISBLANK(L8),0,M8+O8)","v":0},0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,3,{"$f":"IF(COUNT(AJ9)=1,AI8+1,\"\")","v":""},"",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"HUF/EUR árfolyam",null,{"$f":"+C17/D19","v":{"$error":"#N/A"}},null,"Maximális hitelösszeghez tartozó támogatástartalom (EUR)",{"$f":"IF(2300000-C39-C40-C41-C44-C45-C46-C47-C48-C49<=0,\"Nem jogosult\",2300000-C39-C40-C41-C44-C45-C46-C47-C48-C49)","v":2300000},{"$f":"IF(mezogazdkizarok=0,\"Nem releváns\",IF(MIN(290000-C39-C44-C48,2300000-C39-C40-C41-C44-C45-C46-C47-C48-C49,345000-C39-C40-C44-C45-C48-C49)<=0,\"Nem jogosult\",MIN(290000-C39-C44-C48,2300000-C39-C40-C41-C44-C45-C46-C47-C48-C49,345000-C39-C40-C44-C45-C48-C49)))","v":"Nem releváns"},{"$f":"IF(halaszatikizarok=0,\"Nem releváns\",IF(MIN(345000-C40-C45-C49,2300000-C39-C40-C41-C44-C45-C46-C47-C48-C49,345000-C39-C40-C44-C45-C48-C49)<=0,\"Nem jogosult\",MIN(345000-C40-C45-C49,2300000-C39-C40-C41-C44-C45-C46-C47-C48-C49,345000-C39-C40-C44-C45-C48-C49)))","v":"Nem releváns"},true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,4,{"$f":"IF(COUNT(AJ10)=1,AI9+1,\"\")","v":""},"",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Referencia alapkamat - Kérjük adja meg a hatályos, devizanem szerinti értéket!",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,5,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Van hitelfelvevői múltja vagy mérleg alapú hitelminősítése a hitelfelvevőnek?",null,1E-4,null,"Teljes(kumulált) támogatás intenzítása",null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,6,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Cégbesorolás",null,null,null,"Beruházás elszámolható költsége (EUR)",{"$f":"C23/IF(C9<>\"EUR\",arfolyam,1)","v":{"$error":"#DIV/0!"}},null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,7,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Adósminősítés",null,null,null,"Hitelre jutó támogatás intenzítása (EUR)",{"$f":"I4/eurelszamolhato","v":{"$error":"#DIV/0!"}},null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,8,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Fedezettség",null,{"$f":"COUNT(AI7:AI126)","v":0},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(C44:C49)+C59,IF(C34=\"GBER 14, 17-es jogcímek\",SUM(C44:C49)+C52+C54,SUM(C44:C49)))","v":0},null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,9,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[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":{"$error":"#N/A"}},null,null,"Teljes támogatás intenzítása",{"$f":"G15/eurelszamolhato","v":{"$error":"#DIV/0!"}},null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,10,{"$f":"IF(COUNT(AJ16)=1,AI15+1,\"\")","v":""},"",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Egyéni referencia kamatláb",{"$f":"+(C11+C16/10000)","v":{"$error":"#N/A"}},null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,11,{"$f":"IF(COUNT(AJ17)=1,AI16+1,\"\")","v":""},"",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,"Maximális támogatási mértékek",{"$f":"IF(G16>G20,\"Nem finanszírozható\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(G16>H20,\"Nem finanszírozható\",\"\")","v":{"$error":"#DIV/0!"}},null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,12,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"HITELKARAKTERISZTIKA",null,{"$f":"VLOOKUP($C$31,Adatok!P3:Q5,2,0)","v":{"$error":"#N/A"}},null,null,"14-es cikk","17-es cikk",null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,13,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Hitel fajtája/célja",null,null,null,"Maximális támogatásintenzitás (%)",{"$f":"IF(tizennegyeskizarok=0,\"Nem jogosult\",IF(ttmax14es=0,0,(G22+C52+C47)/(forintelszamolhato/arfolyam)))","v":{"$error":"#N/A"}},{"$f":"IF(tizenheteskizarok=0,\"Nem jogosult\",IF(ttmax17es=0,0,(H22+C54+C47)/(eurelszamolhato)))","v":{"$error":"#DIV/0!"}},null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,14,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Vállalat mérete",null,null,null,"Maximális hitelösszeg (EUR)",{"$f":"IF(tizennegyeskizarok=0,\"Nem jogosult\",hitelpertamogatasarany*G22)","v":{"$error":"#DIV/0!"}},{"$f":"IF(tizenheteskizarok=0,\"Nem jogosult\",hitelpertamogatasarany*H22)","v":{"$error":"#DIV/0!"}},null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,15,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Támogatás jogalapja",null,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)-C52-C47),0),Szamitasok!B17))","v":{"$error":"#N/A"}},{"$f":"IF(tizenheteskizarok=0,\"Nem jogosult\",MAX(MIN(((((eurelszamolhato)*vallmeret)-C54-C47)),7.5*1000000),0))","v":{"$error":"#DIV/0!"}},null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,16,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[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 ()"},null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,17,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[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 ()"},null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,18,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Hitel jóváhagyásának várható időpontja (EXIM döntés dátuma)",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,19,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[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"},null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,20,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Első törlesztés várható dátuma",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,21,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[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"},null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,22,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,{"$f":"IF(AND(tenylegeskamat>=Adatok!J14,tenylegeskamat<=Adatok!J15),\"Tényleges ügyleti kamat\",\"A kamat minimum \"&TEXT(Adatok!J14,\"0,0%\")&\" maximum \"&TEXT(Adatok!J15,\"0,0%\")&\" lehet!\")","v":"Tényleges ügyleti kamat"},null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,23,{"$f":"IF(COUNT(AJ29)=1,AI28+1,\"\")","v":""},"",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Törlesztés módja",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,24,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,{"$f":"IF(torlesztes=\"Egyenlő tőke\",\"Kamatfizetés/tőketörlesztés gyakorisága\",\"Kamatfizetés gyakorisága\")","v":"Kamatfizetés gyakorisága"},null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,25,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[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?",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,26,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,27,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[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",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,28,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,29,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Beruházás helyszíne ",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,30,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,31,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[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,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,32,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Mezőgazdasági ágazatra megítélt támogatás teljes összege (EUR):",null,null,null,null,null,null,null,true,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,"",0,"","","","00:00:00",0,0,0,0,"",null,33,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Halászati, akvakultúra ágazatra  megítélt támogatás teljes összeg (EUR):",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,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":""},0,{"$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":0},{"$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":""},0,{"$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":0},{"$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":""},null,"",{"$f":"IFERROR(AR40/POWER(1+($C$11+1%)/$D$19,AI40-1)/(1+($C$11+1%)/365*($AJ$7-$C$25)),\"\")","v":""},""]
[null,"Egyéb ágazatra megítélt támogatás tejes összege (EUR):",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,35,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,36,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[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,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,37,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",{"$f":"IFERROR(AJ43-AJ42,\"\")","v":""}]
[null,"Mezőgazdasági ágazatra megítélt támogatás teljes összege (EUR):",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,38,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Halászati, akvakultúra ágazatra  megítélt támogatás teljes összeg (EUR):",null,null,null,null,null,null,null,true,null,null,null,"",{"$f":"IF(ISBLANK(L44),0,M44+O44)","v":0},0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,39,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Egyéb ágazatra megítélt támogatás tejes összege (EUR):",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,40,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,{"$f":"IF(C47>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,true,null,null,null,"",{"$f":"IF(ISBLANK(L46),0,M46+O46)","v":0},0,0,"",null,null,null,"",0,{"$f":"IFERROR(-W47*piacikamat/365*(T47-V47),\"\")","v":""},{"$f":"IFERROR(-W47*tenylegeskamat/365*(T47-V47),\"\")","v":""},"","00:00:00",0,0,{"$f":"IFERROR(-(AC47-AB47)*piacikamat/365*(AJ47-AA47),0)","v":0},{"$f":"IFERROR(-(AC47-AB47)*tenylegeskamat/365*(AJ47-AA47),0)","v":0},{"$f":"IFERROR(AJ47-AA47,\"\")","v":""},null,41,{"$f":"IF(COUNT(AJ47)=1,AI46+1,\"\")","v":""},"",{"$f":"+IF(COUNT(AK46)<>0,SUM(AK46:AL46)*(1-J47),\"\")","v":0},{"$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":0},"",0,{"$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":0},"",null,{"$f":"IFERROR(MAX((ABS(AM47)-ABS(AP47)),0),\"\")","v":""},"",{"$f":"IFERROR(AJ47-AJ46,\"\")","v":""}]
[null,{"$f":"IF(C48>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,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,42,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,{"$f":"IF(C49>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,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,43,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,44,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[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,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,45,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[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,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,46,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"KKV-ék részére megítélt beruházási támogatások",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,47,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[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,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,48,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,49,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Korábban megítélt támogatások adatai",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,50,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Korábban megítélt állami támogatások rendeleti alapja",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,51,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Korábban megítélt állami támogatások jogcíme",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,52,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,"Korábban megítélt állami támogatás összege (EUR)",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,53,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,54,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,55,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,56,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,57,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,58,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,59,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,60,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,61,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,62,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,63,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,64,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,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,"",0,"","",{"$f":"IFERROR(T71-V71,\"\")","v":""},"00:00:00",0,0,0,0,"",null,65,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"AI72>$D$15","v":true},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":0},"","","",{"$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":"00:00:00"},{"$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":0},0,0,"",null,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":""},0,{"$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":0},{"$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":""},{"$f":"+IF(COUNT(AN71)<>0,SUM(AN71:AO71)*(1-J72),\"\")","v":0},{"$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":0},{"$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":""},null,"",{"$f":"IFERROR(AR72/POWER(1+($C$11+1%)/$D$19,AI72-1)/(1+($C$11+1%)/365*($AJ$7-$C$25)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,{"$f":"IF(ISBLANK(L72),\"\",L72)","v":""},0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,67,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,68,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,69,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,70,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,71,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,72,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,73,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,74,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,75,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,76,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,77,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,78,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,79,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,80,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,81,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,82,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,83,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,84,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,85,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,86,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,87,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,88,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,89,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,90,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,91,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,92,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,93,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,94,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,95,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,96,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,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,"",0,"","","","00:00:00",0,0,0,0,"",null,97,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,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":""},0,{"$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":0},{"$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":""},0,{"$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":0},{"$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":""},null,"",{"$f":"IFERROR(AR104/POWER(1+($C$11+1%)/$D$19,AI104-1)/(1+($C$11+1%)/365*($AJ$7-$C$25)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,99,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,100,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,101,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,102,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,103,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,104,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",{"$f":"IF(ISBLANK(L110),0,M110+O110)","v":0},0,0,"",null,null,null,"",0,{"$f":"IFERROR(-W111*piacikamat/365*(T111-V111),\"\")","v":""},{"$f":"IFERROR(-W111*tenylegeskamat/365*(T111-V111),\"\")","v":""},"","00:00:00",0,0,{"$f":"IFERROR(-(AC111-AB111)*piacikamat/365*(AJ111-AA111),0)","v":0},{"$f":"IFERROR(-(AC111-AB111)*tenylegeskamat/365*(AJ111-AA111),0)","v":0},{"$f":"IFERROR(AJ111-AA111,\"\")","v":""},null,105,{"$f":"IF(COUNT(AJ111)=1,AI110+1,\"\")","v":""},"",{"$f":"+IF(COUNT(AK110)<>0,SUM(AK110:AL110)*(1-J111),\"\")","v":0},{"$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":0},"",0,{"$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":0},"",null,{"$f":"IFERROR(MAX((ABS(AM111)-ABS(AP111)),0),\"\")","v":""},"",{"$f":"IFERROR(AJ111-AJ110,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,106,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,107,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,108,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,109,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,110,"","",0,{"$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":0},"",0,{"$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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",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},"",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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","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},"",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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","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},"",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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","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},"",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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","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},"",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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","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},"",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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","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},"",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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","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},"",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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","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},"",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":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","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},"",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":0},"",null,"","",""]

{"sheet":"Szamitasok","index":2,"n_rows":25,"n_cols":9,"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",null,null,"Régió"]
["Szorzó értéke",null,null,{"$f":"Tamogatastartalom!C21","v":0},null,null,null,null,{"$f":"Tamogatastartalom!C36","v":0}]
[{"$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,{"$f":"PRODUCT(I5)","v":1},{"$f":"IF(I3=\"Budapest\",0,1)","v":1}]
[{"$f":"PRODUCT(E6:F6)","v":0},"halászati",null,null,null,{"$f":"IF(Tamogatastartalom!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":{"$error":"#DIV/0!"}}]
["A Elszámolható költségek",{"$f":"IF((B9-C10)>0,C10,B9)","v":{"$error":"#DIV/0!"}},50000000]
["B Elszámolható költségek",{"$f":"IF(B10<C10,0,IF(B9-C11<0,B9-C10,C10))","v":{"$error":"#DIV/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":{"$error":"#DIV/0!"}}]
["Kaphat?",{"$f":"IF(B15>0,1,0)","v":{"$error":"#N/A"}}]
["Alap intenzitás",{"$f":"VLOOKUP(Tamogatastartalom!C36,Adatok!A12:B20,2,FALSE)","v":{"$error":"#N/A"}}]
["R szorzó értéke a támogatási térkép alapján",{"$f":"(B15+B13)*B14","v":{"$error":"#N/A"}}]
["Max. TT (EUR)",{"$f":"VLOOKUP(B15,Adatok!D12:E17,2,FALSE)*10^6","v":{"$error":"#N/A"}}]
["17-es cikk"]
["Vállalatméret-szorzó",{"$f":"IF(D3=\"Nagy\",0,IF(D3=\"Mikró/Kis\",0.2,0.1))","v":0.1}]
["HUF érték"]
["Elszámolható ktg-ek HUF-ban",{"$f":"IF(Tamogatastartalom!C9=\"EUR\",Tamogatastartalom!C23*arfolyam,Tamogatastartalom!C23)","v":0}]
["Hitel/támogatástartalom arány"]
["Hitelösszeg",{"$f":"Tamogatastartalom!C24","v":0}]
["Támogatástartalom a futamidő alatt",{"$f":"Tamogatastartalom!AR5","v":0}]
["Hitelösszeg/támogatástartalom",{"$f":"B23/B24","v":{"$error":"#DIV/0!"}}]

{"sheet":"Adatok","index":3,"n_rows":20,"n_cols":21,"rows_kept":20,"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":-3.5000000000000003E-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,null,null,null,"ügyleti kamat"]
["Dél-Dunántúl",0.5,null,0.3,22.5,null,null,null,"min",0]
["Észak-Alföld",0.5,null,0.25,18.75,null,null,null,"max",{"$f":"IF(Tamogatastartalom!C9=\"HUF\",0.055,0.006)","v":6.0000000000000001E-3}]
["Észak-Magyarország",0.5,null,0.2,15]
["Közép-Dunántúl",0.3,null,0,0,null,null,null,null," "]
["Pest",0.5]
["Nyugat-Dunántúl",0.3]
["Budapest",0]