{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Elolap","Tamogatastartalom","Szamitasok","Adatok"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":59,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Elolap","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Tamogatastartalom","index":1,"n_rows":134,"n_cols":50,"rows_kept":134,"cut":false,"hidden":false,"merged":[[10,6,12,6],[0,22,1,23],[0,14,1,15],[3,1,3,2],[5,1,5,2],[7,6,9,6],[2,49,3,49],[3,5,4,5],[2,22,3,22],[2,23,3,23],[2,46,2,47],[2,42,2,44],[2,24,2,27],[2,29,2,33],[2,39,2,41],[2,14,3,14],[2,15,3,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P7:P134)<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(X7:X134)<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,null,null,null,"EUR","HUF",null,null,null,null,"Egyedi folyósítás dátuma","Folyósítás összege",null,null,null,null,null,null,"Egyedi törlesztés dátuma","Tőkeamortizáció egyedi törlesztés esetén","periódusközi kamatszámítás",null,null,null,null,"maradék kamatszámítás",null,null,null,null,null,null,null,null,null,"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,null,-0.04,null,"Hitelösszeg",null,{"$f":"IF(C9=\"HUF\",C24/C10,C24)","v":0},{"$f":"IF(C9=\"HUF\",C24,C24*arfolyam)","v":0},null,null,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,{"$f":"IF(C22=\"Halászati\",K10,IF(C22=\"Mezőgazdasági\",K9,K8))","v":2250000},null,"Ténylegesen felvett hitel támogatástartalma 2.1",null,{"$f":"IF(C9=\"HUF\",AU5/C10,AU5)","v":0},{"$f":"IF(C9=\"HUF\",AU5,AU5*C10)","v":0},{"$f":"IFERROR(IF(E5-I5<=0,\"Nem elegendő a 2.1 szabad keret\",IF(C30>C17,\"Az Ideiglenes Válság- és Átállási Közlemény 2.1 szakasz alapján önállóan nyújtott kamattámogatás esetén a Kölcsön Kamatlábnak minden esetben legalább 1 bázispont (0,01% p.a.) támogatástartalommal kell rendelkeznie.\",\"\")),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"SUM(S7:S134)","v":0},{"$f":"SUM(T7:T134)","v":0},null,null,null,null,null,null,{"$f":"SUM(AA7:AA134)","v":0},{"$f":"SUM(AB7:AB134)","v":0},null,null,null,null,{"$f":"SUM(AG7:AG134)","v":0},{"$f":"SUM(AH7:AH134)","v":0},null,null,null,null,null,{"$f":"+AN7","v":0},{"$f":"SUM(AO7:AO134)","v":0},{"$f":"SUM(AP7:AP134)","v":0},{"$f":"+AQ7","v":0},{"$f":"SUM(AR7:AR134)","v":0},{"$f":"SUM(AS7:AS134)","v":0},null,{"$f":"SUM(AU7:AU134)","v":0},{"$f":"SUM(AV7:AV134)","v":0},null,{"$f":"AV5","v":0}]
[null,null,null,null,{"$f":"IF(C22=\"Halászati\",K13,IF(C22=\"Mezőgazdasági\",K12,K11))","v":2300000},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(C27,MIN(O7:O134))","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AL7>$E$15","v":true},null,null,null,{"$f":"C27","v":"00:00:00"},{"$f":"IF(ISBLANK(O7),C24,0)","v":0},{"$f":"IF(AND(ISBLANK(O6),AK7<>1),0,IFERROR(-R7*piacikamat/365*(IF(ISBLANK(O7),$C$28,O7)-Q7),\"\"))","v":""},{"$f":"IF(AND(ISBLANK(O6),AK7<>1),0,IFERROR(-R7*tenylegeskamat/365*(IF(ISBLANK(O7),$C$28,O7)-Q7),\"\"))","v":0},{"$f":"IFERROR(IF(ISBLANK(O7),$C$28,O7)-Q7,\"\")","v":0},null,null,null,{"$f":"IF(ISNA(MAX(W6,INDEX(AM$6:AM$134,MATCH(W7-1,AM$6:AM$134,1)))),\"\",MAX(W6,INDEX(AM$6:AM$134,MATCH(W7-1,AM$6:AM$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(Z6),Z6=\"\"),INDEX(AN$7:AN$134,MATCH(W7,AM$7:AM$134,1)),Z6-X6),INDEX(AN$7:AN$134,MATCH(W7,AM$7:AM$134,1)))),\"\",MIN(IF(OR(ISBLANK(Z6),Z6=\"\"),INDEX(AN$7:AN$134,MATCH(W7,AM$7:AM$134,1)),Z6-X6),INDEX(AN$7:AN$134,MATCH(W7,AM$7:AM$134,1))))","v":0},{"$f":"IFERROR(-Z7*piacikamat/365*(W7-Y7),\"\")","v":""},{"$f":"IFERROR(-Z7*tenylegeskamat/365*(W7-Y7),\"\")","v":""},{"$f":"IFERROR(W7-Y7,\"\")","v":""},{"$f":"MAX(AM6,IF(ISNA(INDEX(W$7:W$134,MATCH(AM7,W$7:W$134,1))),0,INDEX(W$7:W$134,MATCH(AM7,W$7:W$134,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(X$7:X$134,MATCH(AM7,W$7:W$134,1))),0,INDEX(X$7:X$134,MATCH(AM7,W$7:W$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(Z$7:Z$134,MATCH(AM7,W$7:W$134,1))),AN7,INDEX(Z$7:Z$134,MATCH(AM7,W$7:W$134,1)))","v":0},{"$f":"IFERROR(-(AF7-AE7)*piacikamat/365*(AM7-AD7),0)","v":0},{"$f":"IFERROR(-(AF7-AE7)*tenylegeskamat/365*(AM7-AD7),0)","v":0},{"$f":"IFERROR(AM7-AD7,\"\")","v":0},null,1,{"$f":"+IF(C29-C28<>0,1,\"\")","v":""},{"$f":"C28","v":"00:00:00"},{"$f":"IF(+C24<>0,C24,IF(AL7>0,C24*M7,\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM6,W$7:W$134,\"<=\"&AM7),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN7)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"SUM(S7:S134)","v":0},{"$f":"+AN7","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM6,W$7:W$134,\"<=\"&AM7),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ7)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"SUM(T7:T134)","v":0},null,{"$f":"IFERROR(MAX((ABS(AP7)-ABS(AS7)),0),\"\")","v":0},{"$f":"IFERROR(AU7/(1+($C$11+1%)/365*(AM7-C26)),\"\")","v":0},{"$f":"IFERROR(AM7-AM6,\"\")","v":0}]
[null,"PIACI KAMAT MEGHATÁROZÁSA",null,null,null,null,"Válságkezelési közlemény 2.1 alapján megítélt támogatásokon felül igénybe vehető szabad keret (EUR)","Általános szabály",null,null,{"$f":"IF(2250000-C40-C41-C42-C45-C46-C47-C51-C52-C53<=0,\"Nincs szabad keret, nem finanszírozható\",2250000-C40-C41-C42-C45-C46-C47-C51-C52-C53)","v":2250000},null,true,null,null,null,{"$f":"IF(ISBLANK(O7),\"\",O7)","v":""},{"$f":"IF(ISBLANK(O7),0,P7+R7)","v":0},0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,2,{"$f":"IF(COUNT(AM8)=1,AL7+1,\"\")","v":""},{"$f":"IF(OR(AM7=$C$29,AM7=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AK8-1)*12/$E$19)<=$C$29,EDATE($C$28,(AK8-1)*12/$E$19),$C$29),\"\"))","v":""},{"$f":"+IF(COUNT(AN7)<>0,SUM(AN7:AO7)*(1-M8),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM7,W$7:W$134,\"<=\"&AM8),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN8)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AA$7:AA$134,W$7:W$134,\">\"&AM7,W$7:W$134,\"<=\"&AM8)+AG8,IFERROR(-AN8*piacikamat/365*(AM8-AM7),\"\"))","v":""},{"$f":"+IF(COUNT(AQ7)<>0,SUM(AQ7:AR7)*(1-M8),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM7,W$7:W$134,\"<=\"&AM8),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ8)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,W$7:W$134,\">\"&AM7,W$7:W$134,\"<=\"&AM8)+AH8,IFERROR(-AQ8*tenylegeskamat/365*(AM8-AM7),\"\"))","v":""},null,"",{"$f":"IFERROR(AU8/POWER(1+($C$11+1%)/$E$19,AL8-1)/(1+($C$11+1%)/365*($AM$7-$C$26)),\"\")","v":""},""]
[null,"Hitel devizaneme","EUR",null,"Makrohoz kellenek (ne töröld ki!):",null,null,"Mezőgazdasági szabály",null,null,{"$f":"IF(mezogazdkizarok=0,\"Nem releváns\",IF(MIN(280000-C40-C45-C52,2250000-C40-C41-C42-C45-C46-C47-C51-C52-C53,335000-C40-C41-C45-C46-C52-C53)<=0,\"Nincs szabad keret, nem finanszírozható\",MIN(280000-C40-C45-C52,2250000-C40-C41-C42-C45-C46-C47-C51-C52-C53,335000-C40-C41-C45-C46-C52-C53)))","v":"Nem releváns"},null,true,null,null,null,{"$f":"IF(ISBLANK(O8),\"\",O8)","v":""},{"$f":"IF(ISBLANK(O8),0,P8+R8)","v":0},0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,3,{"$f":"IF(COUNT(AM9)=1,AL8+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM8,W$7:W$134,\"<=\"&AM9),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN9)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM8,W$7:W$134,\"<=\"&AM9),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ9)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"HUF/EUR árfolyam",null,null,{"$f":"+C17/E19","v":{"$error":"#N/A"}},null,null,"Halászati szabály",null,null,{"$f":"IF(halaszatikizarok=0,\"Nem releváns\",IF(MIN(335000-C41-C46-C53,2250000-C40-C41-C42-C45-C46-C47-C51-C52-C53,335000-C40-C41-C45-C46-C52-C53)<=0,\"Nincs szabad keret, nem finanszírozható\",MIN(335000-C41-C46-C53,2250000-C40-C41-C42-C45-C46-C47-C51-C52-C53,335000-C40-C41-C45-C46-C52-C53)))","v":"Nem releváns"},null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,4,{"$f":"IF(COUNT(AM10)=1,AL9+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM9,W$7:W$134,\"<=\"&AM10),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN10)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM9,W$7:W$134,\"<=\"&AM10),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ10)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Reference and discount rates (europa.eu) - Kérjük adja meg a hatályos, devizanem szerinti értéket!",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 (EUR)","Általános szabály",null,null,{"$f":"IF(2300000-C45-C46-C47-C51-C52-C53-C56-C57-C58<=0,\"Nincs szabad keret, nem finanszírozható\",2300000-C45-C46-C47-C51-C52-C53-C56-C57-C58)","v":2300000},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(X$7:X$134,W$7:W$134,\">\"&AM10,W$7:W$134,\"<=\"&AM11),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN11)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM10,W$7:W$134,\"<=\"&AM11),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ11)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Van hitelfelvevői múltja vagy mérleg alapú hitelminősítése a hitelfelvevőnek?",null,null,1E-4,null,null,"Mezőgazdasági szabály",null,null,{"$f":"IF(mezogazdkizarok=0,\"Nem releváns\",IF(MIN(290000-C45-C52-C56,2300000-C45-C46-C47-C51-C52-C53-C56-C57-C58,345000-C45-C46-C52-C53-C56-C57)<=0,\"Nincs szabad keret, nem finanszírozható\",MIN(290000-C45-C52-C56,2300000-C45-C46-C47-C51-C52-C53-C56-C57-C58,345000-C45-C46-C52-C53-C56-C57)))","v":"Nem releváns"},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(X$7:X$134,W$7:W$134,\">\"&AM11,W$7:W$134,\"<=\"&AM12),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN12)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM11,W$7:W$134,\"<=\"&AM12),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ12)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Cégbesorolás",null,null,null,null,null,"Halászati szabály",null,null,{"$f":"IF(halaszatikizarok=0,\"Nem releváns\",IF(MIN(345000-C46-C53-C57,2300000-C45-C46-C47-C51-C52-C53-C56-C57-C58,345000-C45-C46-C52-C53-C56-C57)<=0,\"Nincs szabad keret, nem finanszírozható\",MIN(345000-C46-C53-C57,2300000-C45-C46-C47-C51-C52-C53-C56-C57-C58,345000-C45-C46-C52-C53-C56-C57)))","v":"Nem releváns"},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(X$7:X$134,W$7:W$134,\">\"&AM12,W$7:W$134,\"<=\"&AM13),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN13)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM12,W$7:W$134,\"<=\"&AM13),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ13)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Adósminősítés",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,8,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM13,W$7:W$134,\"<=\"&AM14),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN14)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM13,W$7:W$134,\"<=\"&AM14),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ14)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Fedezettség",null,null,{"$f":"COUNT(AL7:AL134)","v":0},null,"Teljes(kumulált) támogatás intenzítása",null,null,null,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(X$7:X$134,W$7:W$134,\">\"&AM14,W$7:W$134,\"<=\"&AM15),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN15)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM14,W$7:W$134,\"<=\"&AM15),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ15)>$E$15,\"\",-$AN$5/$E$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,null,"Beruházás elszámolható költsége (HUF)",{"$f":"C23*IF(C9=\"EUR\",arfolyam,1)","v":0},null,null,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(AM16)=1,AL15+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM15,W$7:W$134,\"<=\"&AM16),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN16)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM15,W$7:W$134,\"<=\"&AM16),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ16)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Egyéni referencia kamatláb",{"$f":"+(C11+C16/10000)","v":{"$error":"#N/A"}},null,null,null,"Hitelre jutó támogatás intenzítása",{"$f":"(J5+J6)/forintelszamolhato","v":{"$error":"#DIV/0!"}},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(AM17)=1,AL16+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM16,W$7:W$134,\"<=\"&AM17),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN17)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM16,W$7:W$134,\"<=\"&AM17),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ17)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,"Adott beruházási költséghez kapcsolódó teljes támogatás összege (HUF)",{"$f":"J5+J6+IF(C35=\"Egyéb támogatások: pl. Egyéb GBER (pl. 38, 41, stb), EMVA\",SUM(D45:D53)+C68,IF(C35=\"GBER 14, 17-es jogcímek\",SUM(D45:D53)+D61+D63,SUM(D45:D53)))","v":0},null,null,null,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(X$7:X$134,W$7:W$134,\">\"&AM17,W$7:W$134,\"<=\"&AM18),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN18)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM17,W$7:W$134,\"<=\"&AM18),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ18)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"HITELKARAKTERISZTIKA",null,null,{"$f":"VLOOKUP($C$32,Adatok!P3:Q5,2,0)","v":{"$error":"#N/A"}},null,"Teljes támogatás intenzítása",{"$f":"H18/forintelszamolhato","v":{"$error":"#DIV/0!"}},null,null,null,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(X$7:X$134,W$7:W$134,\">\"&AM18,W$7:W$134,\"<=\"&AM19),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN19)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM18,W$7:W$134,\"<=\"&AM19),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ19)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Hitel fajtája/célja","Lízing",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,14,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM19,W$7:W$134,\"<=\"&AM20),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN20)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM19,W$7:W$134,\"<=\"&AM20),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ20)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Vállalat mérete",null,null,null,null,"Maximális támogatási mértékek",{"$f":"IF(H19>H23,\"Nem finanszírozható\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(H19>I23,\"Nem finanszírozható\",\"\")","v":{"$error":"#DIV/0!"}},null,null,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(X$7:X$134,W$7:W$134,\">\"&AM20,W$7:W$134,\"<=\"&AM21),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN21)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM20,W$7:W$134,\"<=\"&AM21),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ21)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Válságkezelési közlemény 2.1 szakasza szerinti ágazat (a hitel céljához kapcsolódó TEÁOR alapján) ",null,null,null,null,null,"14-es cikk","17-es cikk",null,null,null,true,null,null,null,{"$f":"IF(ISBLANK(O21),\"\",O21)","v":""},{"$f":"IF(ISBLANK(O21),0,P21+R21)","v":0},0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,16,{"$f":"IF(COUNT(AM22)=1,AL21+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM21,W$7:W$134,\"<=\"&AM22),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN22)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM21,W$7:W$134,\"<=\"&AM22),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ22)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,{"$f":"\"Beruházás elszámolható költsége (\"&C9&\")\"&IF(C23<C24,\" - Nem lehet kisebb, mint a hitelösszeg!\",\"\")","v":"Beruházás elszámolható költsége (EUR)"},null,null,null,null,"Maximális támogatásintenzitás (%)",{"$f":"IF(tizennegyeskizarok=0,\"Nem jogosult\",IF(ttmax14es=0,0,(H25+C61+C51)/eurelszamolhato))","v":{"$error":"#N/A"}},{"$f":"IF(tizenheteskizarok=0,\"Nem jogosult\",IF(ttmax17es=0,0,(I25+C63+C51)/(eurelszamolhato)))","v":0},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(X$7:X$134,W$7:W$134,\">\"&AM22,W$7:W$134,\"<=\"&AM23),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN23)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM22,W$7:W$134,\"<=\"&AM23),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ23)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,{"$f":"\"Hitelösszeg (\"&C9&\")\"","v":"Hitelösszeg (EUR)"},null,null,null,null,"Maximális hitelösszeg (EUR)",{"$f":"IF(tizennegyeskizarok=0,\"Nem jogosult\",hitelpertamogatasarany*H25)","v":{"$error":"#DIV/0!"}},{"$f":"IF(tizenheteskizarok=0,\"Nem jogosult\",hitelpertamogatasarany*I25)","v":{"$error":"#DIV/0!"}},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(X$7:X$134,W$7:W$134,\">\"&AM23,W$7:W$134,\"<=\"&AM24),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN24)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM23,W$7:W$134,\"<=\"&AM24),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ24)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,{"$f":"\"Futamidő (hónap)\"&IF(OR(C25<13,C25>E25),\" - Minimum 13 hónap, maximum \"&E25&\" hónap lehet!\",\"\")","v":"Futamidő (hónap) - Minimum 13 hónap, maximum 60 hónap lehet!"},null,null,60,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)-C61-C51),0),Szamitasok!B17))","v":{"$error":"#N/A"}},{"$f":"IF(tizenheteskizarok=0,\"Nem jogosult\",MAX(MIN(((((eurelszamolhato)*vallmeret)-C63-C51)),7.5*1000000),0))","v":0},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(X$7:X$134,W$7:W$134,\">\"&AM24,W$7:W$134,\"<=\"&AM25),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN25)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM24,W$7:W$134,\"<=\"&AM25),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ25)>$E$15,\"\",-$AN$5/$E$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,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(X$7:X$134,W$7:W$134,\">\"&AM25,W$7:W$134,\"<=\"&AM26),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN26)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM25,W$7:W$134,\"<=\"&AM26),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ26)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,{"$f":"\"Szerződéskötés várható dátuma\"&IF(C27>DATE(2024,6,30),\" - Nem lehet későbbi, mint 2024.06.30!\",IF(C26>C27,\" - Korábbi, mint az Exim döntés dátuma!\",\"\"))","v":"Szerződéskötés várható dátuma"},null,null,null,null,"Maximális támogatási mértékek",{"$f":"IF(H19>H29,\"Nem finanszírozható\",\"\")","v":{"$error":"#DIV/0!"}},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(X$7:X$134,W$7:W$134,\">\"&AM26,W$7:W$134,\"<=\"&AM27),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN27)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM26,W$7:W$134,\"<=\"&AM27),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ27)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,{"$f":"\"Első törlesztés várható dátuma\"&IF(C28>EDATE(C27,36),\" - A türelmi idő max. 36 hónap lehet!\",IF(C28>C29,\" - Első törlesztés várható dátuma későbbi mint a véglejárat!\",\"\"))","v":"Első törlesztés várható dátuma"},null,null,null,null,null,"Egyéb támogatások",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(X$7:X$134,W$7:W$134,\">\"&AM27,W$7:W$134,\"<=\"&AM28),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN28)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM27,W$7:W$134,\"<=\"&AM28),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ28)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,{"$f":"\"Hitel végső lejáratának várható dátuma\"&IF(C29>EDATE(C27,C25),\" - A futamidő meghaladja a „Futamidő (hónap)” cellába írt hónapok számát!\",\"\")","v":"Hitel végső lejáratának várható dátuma"},null,null,{"$f":"IF($C$9=\"HUF\",IF($C$20=\"Zöld beruházási hitel\",Adatok!$G$14,Adatok!$J$14),IF($C$20=\"Zöld beruházási hitel\",Adatok!$H$14,Adatok!$K$14))","v":0.01},null,"Maximális támogatásintenzitás (%)",{"$f":"C69","v":0},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(AM29)=1,AL28+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM28,W$7:W$134,\"<=\"&AM29),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN29)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM28,W$7:W$134,\"<=\"&AM29),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ29)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,{"$f":"\"Tényleges ügyleti kamat\"&IF(OR(tenylegeskamat<E29,tenylegeskamat>E30),\" - Nem megfelelő kamatérték!\",\"\")","v":"Tényleges ügyleti kamat - Nem megfelelő kamatérték!"},null,null,{"$f":"IF($C$9=\"HUF\",IF($C$20=\"Zöld beruházási hitel\",Adatok!$G$15,Adatok!$J$15),IF($C$20=\"Zöld beruházási hitel\",Adatok!$H$15,Adatok!$K$15))","v":0.08},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(X$7:X$134,W$7:W$134,\">\"&AM29,W$7:W$134,\"<=\"&AM30),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN30)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM29,W$7:W$134,\"<=\"&AM30),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ30)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Törlesztés módja",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,25,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM30,W$7:W$134,\"<=\"&AM31),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN31)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM30,W$7:W$134,\"<=\"&AM31),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ31)>$E$15,\"\",-$AN$5/$E$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,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(X$7:X$134,W$7:W$134,\">\"&AM31,W$7:W$134,\"<=\"&AM32),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN32)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM31,W$7:W$134,\"<=\"&AM32),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ32)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"A beruházási hitel kapcsolódik-e ugyanazon elszámolható költségek tekintetében megítélt támogatáshoz vagy a TCF 2.1 alapján megítélt támogatásokhoz?",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(X$7:X$134,W$7:W$134,\">\"&AM32,W$7:W$134,\"<=\"&AM33),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN33)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM32,W$7:W$134,\"<=\"&AM33),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ33)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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,28,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM33,W$7:W$134,\"<=\"&AM34),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN34)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM33,W$7:W$134,\"<=\"&AM34),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ34)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Kérjük az alább található táblázatot is kitölteni! ",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(X$7:X$134,W$7:W$134,\">\"&AM34,W$7:W$134,\"<=\"&AM35),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN35)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM34,W$7:W$134,\"<=\"&AM35),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ35)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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,30,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM35,W$7:W$134,\"<=\"&AM36),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN36)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM35,W$7:W$134,\"<=\"&AM36),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ36)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Beruházás helyszíne ",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(X$7:X$134,W$7:W$134,\">\"&AM36,W$7:W$134,\"<=\"&AM37),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN37)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM36,W$7:W$134,\"<=\"&AM37),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ37)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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,32,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM37,W$7:W$134,\"<=\"&AM38),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN38)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM37,W$7:W$134,\"<=\"&AM38),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ38)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Nem azonos elszámolható költségekre megítélt Válságkezelési Közlemény 2.1 szerinti állami támogatások",null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,33,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM38,W$7:W$134,\"<=\"&AM39),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN39)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM38,W$7:W$134,\"<=\"&AM39),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ39)>$E$15,\"\",-$AN$5/$E$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,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,34,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM39,W$7:W$134,\"<=\"&AM40),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN40)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM39,W$7:W$134,\"<=\"&AM40),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ40)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Halászati, akvakultúra ágazatra  megítélt támogatás teljes összeg (EUR):",0,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,35,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM40,W$7:W$134,\"<=\"&AM41),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN41)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM40,W$7:W$134,\"<=\"&AM41),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ41)>$E$15,\"\",-$AN$5/$E$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,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(X$7:X$134,W$7:W$134,\">\"&AM41,W$7:W$134,\"<=\"&AM42),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN42)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM41,W$7:W$134,\"<=\"&AM42),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ42)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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,37,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM42,W$7:W$134,\"<=\"&AM43),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN43)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM42,W$7:W$134,\"<=\"&AM43),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ43)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Azonos elszámolható költségekre megítélt Válságkezelési  Közlemény 2.1, COVID Közlemény 3.1 és de minimis szerinti állami támogatások","EUR","HUF",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,38,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM43,W$7:W$134,\"<=\"&AM44),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN44)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM43,W$7:W$134,\"<=\"&AM44),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ44)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Azonos elszámolható költségekhez kapcsolódó mezőgazdasági ágazatra megítélt 2.1 támogatás összege",0,0,null,null,null,null,null,null,null,null,true,null,null,null,"",{"$f":"IF(ISBLANK(O44),0,P44+R44)","v":0},0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,39,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM44,W$7:W$134,\"<=\"&AM45),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN45)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM44,W$7:W$134,\"<=\"&AM45),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ45)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Azonos elszámolható költségekhez kapcsolódó halászati, akvakultúra ágazatra megítélt 2.1 támogatás összege",0,0]
[null,"Azonos elszámolható költségekhez kapcsolódó egyéb ágazatra megítélt 2.1 támogatás összege",0,0]
[null,"Azonos elszámolható költségekhez kapcsolódó mezőgazdasági ágazatra megítélt 3.1 támogatás összege",0,0,null,null,null,null,null,null,null,null,{"$f":"AL48>$E$15","v":true},null,null,null,{"$f":"IF(ISBLANK(O45),\"\",O45)","v":""},{"$f":"IF(ISBLANK(O45),0,P45+R45)","v":0},{"$f":"IF(AND(ISBLANK(O45),AK48<>1),0,IFERROR(-R48*piacikamat/365*(IF(ISBLANK(O48),$C$28,O48)-Q48),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O45),AK48<>1),0,IFERROR(-R48*tenylegeskamat/365*(IF(ISBLANK(O48),$C$28,O48)-Q48),\"\"))","v":0},{"$f":"IFERROR(IF(ISBLANK(O48),$C$28,O48)-Q48,\"\")","v":""},null,null,null,{"$f":"IF(ISNA(MAX(W45,INDEX(AM$6:AM$134,MATCH(W48-1,AM$6:AM$134,1)))),\"\",MAX(W45,INDEX(AM$6:AM$134,MATCH(W48-1,AM$6:AM$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(Z45),Z45=\"\"),INDEX(AN$7:AN$134,MATCH(W48,AM$7:AM$134,1)),Z45-X45),INDEX(AN$7:AN$134,MATCH(W48,AM$7:AM$134,1)))),\"\",MIN(IF(OR(ISBLANK(Z45),Z45=\"\"),INDEX(AN$7:AN$134,MATCH(W48,AM$7:AM$134,1)),Z45-X45),INDEX(AN$7:AN$134,MATCH(W48,AM$7:AM$134,1))))","v":0},"",{"$f":"IFERROR(-Z48*tenylegeskamat/365*(W48-Y48),\"\")","v":""},{"$f":"IFERROR(W48-Y48,\"\")","v":""},{"$f":"MAX(AM45,IF(ISNA(INDEX(W$7:W$134,MATCH(AM48,W$7:W$134,1))),0,INDEX(W$7:W$134,MATCH(AM48,W$7:W$134,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(X$7:X$134,MATCH(AM48,W$7:W$134,1))),0,INDEX(X$7:X$134,MATCH(AM48,W$7:W$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(Z$7:Z$134,MATCH(AM48,W$7:W$134,1))),AN48,INDEX(Z$7:Z$134,MATCH(AM48,W$7:W$134,1)))","v":0},{"$f":"IFERROR(-(AF48-AE48)*piacikamat/365*(AM48-AD48),0)","v":0},{"$f":"IFERROR(-(AF48-AE48)*tenylegeskamat/365*(AM48-AD48),0)","v":0},{"$f":"IFERROR(AM48-AD48,\"\")","v":""},null,40,{"$f":"IF(COUNT(AM48)=1,AL45+1,\"\")","v":""},{"$f":"IF(OR(AM45=$C$29,AM45=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AK48-1)*12/$E$19)<=$C$29,EDATE($C$28,(AK48-1)*12/$E$19),$C$29),\"\"))","v":""},{"$f":"+IF(COUNT(AN45)<>0,SUM(AN45:AO45)*(1-M48),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM45,W$7:W$134,\"<=\"&AM48),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN48)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AA$7:AA$134,W$7:W$134,\">\"&AM45,W$7:W$134,\"<=\"&AM48)+AG48,IFERROR(-AN48*piacikamat/365*(AM48-AM45),\"\"))","v":""},{"$f":"+IF(COUNT(AQ45)<>0,SUM(AQ45:AR45)*(1-M48),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM45,W$7:W$134,\"<=\"&AM48),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ48)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,W$7:W$134,\">\"&AM45,W$7:W$134,\"<=\"&AM48)+AH48,IFERROR(-AQ48*tenylegeskamat/365*(AM48-AM45),\"\"))","v":""},null,{"$f":"IFERROR(MAX((ABS(AP48)-ABS(AS48)),0),\"\")","v":""},{"$f":"IFERROR(AU48/POWER(1+($C$11+1%)/$E$19,AL48-1)/(1+($C$11+1%)/365*($AM$7-$C$26)),\"\")","v":""},{"$f":"IFERROR(AM48-AM45,\"\")","v":""}]
[null,"Azonos elszámolható költségekhez kapcsolódó halászati, akvakultúra ágazatra megítélt 3.1 támogatás összege",0,0]
[null,"Azonos elszámolható költségekhez kapcsolódó egyéb ágazatra megítélt 3.1 támogatás összege",0,0]
[null,{"$f":"IF(C51>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\")","v":"Az igényelt hitelhez megítélt ugyanazon elszámolható költségekhez kapcsolódó de minimis támogatások összege"},0,0,null,null,null,null,null,null,null,null,{"$f":"AL51>$E$15","v":true},null,null,null,{"$f":"IF(ISBLANK(O48),\"\",O48)","v":""},{"$f":"IF(ISBLANK(O48),0,P48+R48)","v":0},{"$f":"IF(AND(ISBLANK(O48),AK51<>1),0,IFERROR(-R51*piacikamat/365*(IF(ISBLANK(O51),$C$28,O51)-Q51),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O48),AK51<>1),0,IFERROR(-R51*tenylegeskamat/365*(IF(ISBLANK(O51),$C$28,O51)-Q51),\"\"))","v":0},{"$f":"IFERROR(IF(ISBLANK(O51),$C$28,O51)-Q51,\"\")","v":""},null,null,null,{"$f":"IF(ISNA(MAX(W48,INDEX(AM$6:AM$134,MATCH(W51-1,AM$6:AM$134,1)))),\"\",MAX(W48,INDEX(AM$6:AM$134,MATCH(W51-1,AM$6:AM$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(Z48),Z48=\"\"),INDEX(AN$7:AN$134,MATCH(W51,AM$7:AM$134,1)),Z48-X48),INDEX(AN$7:AN$134,MATCH(W51,AM$7:AM$134,1)))),\"\",MIN(IF(OR(ISBLANK(Z48),Z48=\"\"),INDEX(AN$7:AN$134,MATCH(W51,AM$7:AM$134,1)),Z48-X48),INDEX(AN$7:AN$134,MATCH(W51,AM$7:AM$134,1))))","v":0},{"$f":"IFERROR(-Z51*piacikamat/365*(W51-Y51),\"\")","v":""},{"$f":"IFERROR(-Z51*tenylegeskamat/365*(W51-Y51),\"\")","v":""},{"$f":"IFERROR(W51-Y51,\"\")","v":""},{"$f":"MAX(AM48,IF(ISNA(INDEX(W$7:W$134,MATCH(AM51,W$7:W$134,1))),0,INDEX(W$7:W$134,MATCH(AM51,W$7:W$134,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(X$7:X$134,MATCH(AM51,W$7:W$134,1))),0,INDEX(X$7:X$134,MATCH(AM51,W$7:W$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(Z$7:Z$134,MATCH(AM51,W$7:W$134,1))),AN51,INDEX(Z$7:Z$134,MATCH(AM51,W$7:W$134,1)))","v":0},{"$f":"IFERROR(-(AF51-AE51)*piacikamat/365*(AM51-AD51),0)","v":0},{"$f":"IFERROR(-(AF51-AE51)*tenylegeskamat/365*(AM51-AD51),0)","v":0},{"$f":"IFERROR(AM51-AD51,\"\")","v":""},null,41,{"$f":"IF(COUNT(AM51)=1,AL48+1,\"\")","v":""},{"$f":"IF(OR(AM48=$C$29,AM48=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AK51-1)*12/$E$19)<=$C$29,EDATE($C$28,(AK51-1)*12/$E$19),$C$29),\"\"))","v":""},{"$f":"+IF(COUNT(AN48)<>0,SUM(AN48:AO48)*(1-M51),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM48,W$7:W$134,\"<=\"&AM51),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN51)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AA$7:AA$134,W$7:W$134,\">\"&AM48,W$7:W$134,\"<=\"&AM51)+AG51,IFERROR(-AN51*piacikamat/365*(AM51-AM48),\"\"))","v":""},{"$f":"+IF(COUNT(AQ48)<>0,SUM(AQ48:AR48)*(1-M51),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM48,W$7:W$134,\"<=\"&AM51),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ51)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,W$7:W$134,\">\"&AM48,W$7:W$134,\"<=\"&AM51)+AH51,IFERROR(-AQ51*tenylegeskamat/365*(AM51-AM48),\"\"))","v":""},null,{"$f":"IFERROR(MAX((ABS(AP51)-ABS(AS51)),0),\"\")","v":""},{"$f":"IFERROR(AU51/POWER(1+($C$11+1%)/$E$19,AL51-1)/(1+($C$11+1%)/365*($AM$7-$C$26)),\"\")","v":""},{"$f":"IFERROR(AM51-AM48,\"\")","v":""}]
[null,{"$f":"IF(C52>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\")","v":"Az igényelt hitelhez megítélt ugyanazon elszámolható költségekhez kapcsolódó agrár de minimis támogatások összege"},0,0,null,null,null,null,null,null,null,null,{"$f":"AL52>$E$15","v":true},null,null,null,"",{"$f":"IF(ISBLANK(O51),0,P51+R51)","v":0},{"$f":"IF(AND(ISBLANK(O51),AK52<>1),0,IFERROR(-R52*piacikamat/365*(IF(ISBLANK(O52),$C$28,O52)-Q52),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O51),AK52<>1),0,IFERROR(-R52*tenylegeskamat/365*(IF(ISBLANK(O52),$C$28,O52)-Q52),\"\"))","v":0},{"$f":"IFERROR(IF(ISBLANK(O52),$C$28,O52)-Q52,\"\")","v":""},null,null,null,{"$f":"IF(ISNA(MAX(W51,INDEX(AM$6:AM$134,MATCH(W52-1,AM$6:AM$134,1)))),\"\",MAX(W51,INDEX(AM$6:AM$134,MATCH(W52-1,AM$6:AM$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(Z51),Z51=\"\"),INDEX(AN$7:AN$134,MATCH(W52,AM$7:AM$134,1)),Z51-X51),INDEX(AN$7:AN$134,MATCH(W52,AM$7:AM$134,1)))),\"\",MIN(IF(OR(ISBLANK(Z51),Z51=\"\"),INDEX(AN$7:AN$134,MATCH(W52,AM$7:AM$134,1)),Z51-X51),INDEX(AN$7:AN$134,MATCH(W52,AM$7:AM$134,1))))","v":0},"",{"$f":"IFERROR(-Z52*tenylegeskamat/365*(W52-Y52),\"\")","v":""},{"$f":"IFERROR(W52-Y52,\"\")","v":""},{"$f":"MAX(AM51,IF(ISNA(INDEX(W$7:W$134,MATCH(AM52,W$7:W$134,1))),0,INDEX(W$7:W$134,MATCH(AM52,W$7:W$134,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(X$7:X$134,MATCH(AM52,W$7:W$134,1))),0,INDEX(X$7:X$134,MATCH(AM52,W$7:W$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(Z$7:Z$134,MATCH(AM52,W$7:W$134,1))),AN52,INDEX(Z$7:Z$134,MATCH(AM52,W$7:W$134,1)))","v":0},{"$f":"IFERROR(-(AF52-AE52)*piacikamat/365*(AM52-AD52),0)","v":0},{"$f":"IFERROR(-(AF52-AE52)*tenylegeskamat/365*(AM52-AD52),0)","v":0},{"$f":"IFERROR(AM52-AD52,\"\")","v":""},null,42,{"$f":"IF(COUNT(AM52)=1,AL51+1,\"\")","v":""},{"$f":"IF(OR(AM51=$C$29,AM51=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AK52-1)*12/$E$19)<=$C$29,EDATE($C$28,(AK52-1)*12/$E$19),$C$29),\"\"))","v":""},{"$f":"+IF(COUNT(AN51)<>0,SUM(AN51:AO51)*(1-M52),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM51,W$7:W$134,\"<=\"&AM52),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN52)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AA$7:AA$134,W$7:W$134,\">\"&AM51,W$7:W$134,\"<=\"&AM52)+AG52,IFERROR(-AN52*piacikamat/365*(AM52-AM51),\"\"))","v":""},{"$f":"+IF(COUNT(AQ51)<>0,SUM(AQ51:AR51)*(1-M52),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM51,W$7:W$134,\"<=\"&AM52),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ52)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,W$7:W$134,\">\"&AM51,W$7:W$134,\"<=\"&AM52)+AH52,IFERROR(-AQ52*tenylegeskamat/365*(AM52-AM51),\"\"))","v":""},null,{"$f":"IFERROR(MAX((ABS(AP52)-ABS(AS52)),0),\"\")","v":""},{"$f":"IFERROR(AU52/POWER(1+($C$11+1%)/$E$19,AL52-1)/(1+($C$11+1%)/365*($AM$7-$C$26)),\"\")","v":""},{"$f":"IFERROR(AM52-AM51,\"\")","v":""}]
[null,{"$f":"IF(C53>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\")","v":"Az igényelt hitelhez megítélt ugyanazon elszámolható költségekhez kapcsolódó halászati de minimis támogatások összege"},0,0]
[]
[null,"COVID Közlemény 3.1 szakasza szerinti (a vállalkozás kapcsolt vállalkozásait is figyelembe véve) megítélt támogatás teljes összege, ami tartalmazza az azonos elszámolható költségekre megítélt támogatás összegét is!",null,null,null,null,null,null,null,null,null,null,{"$f":"AL55>$E$15","v":true},null,null,null,{"$f":"IF(ISBLANK(O52),\"\",O52)","v":""},{"$f":"IF(ISBLANK(O52),0,P52+R52)","v":0},{"$f":"IF(AND(ISBLANK(O52),AK55<>1),0,IFERROR(-R55*piacikamat/365*(IF(ISBLANK(O55),$C$28,O55)-Q55),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O52),AK55<>1),0,IFERROR(-R55*tenylegeskamat/365*(IF(ISBLANK(O55),$C$28,O55)-Q55),\"\"))","v":0},{"$f":"IFERROR(IF(ISBLANK(O55),$C$28,O55)-Q55,\"\")","v":""},null,null,null,{"$f":"IF(ISNA(MAX(W52,INDEX(AM$6:AM$134,MATCH(W55-1,AM$6:AM$134,1)))),\"\",MAX(W52,INDEX(AM$6:AM$134,MATCH(W55-1,AM$6:AM$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(Z52),Z52=\"\"),INDEX(AN$7:AN$134,MATCH(W55,AM$7:AM$134,1)),Z52-X52),INDEX(AN$7:AN$134,MATCH(W55,AM$7:AM$134,1)))),\"\",MIN(IF(OR(ISBLANK(Z52),Z52=\"\"),INDEX(AN$7:AN$134,MATCH(W55,AM$7:AM$134,1)),Z52-X52),INDEX(AN$7:AN$134,MATCH(W55,AM$7:AM$134,1))))","v":0},"",{"$f":"IFERROR(-Z55*tenylegeskamat/365*(W55-Y55),\"\")","v":""},{"$f":"IFERROR(W55-Y55,\"\")","v":""},{"$f":"MAX(AM52,IF(ISNA(INDEX(W$7:W$134,MATCH(AM55,W$7:W$134,1))),0,INDEX(W$7:W$134,MATCH(AM55,W$7:W$134,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(X$7:X$134,MATCH(AM55,W$7:W$134,1))),0,INDEX(X$7:X$134,MATCH(AM55,W$7:W$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(Z$7:Z$134,MATCH(AM55,W$7:W$134,1))),AN55,INDEX(Z$7:Z$134,MATCH(AM55,W$7:W$134,1)))","v":0},{"$f":"IFERROR(-(AF55-AE55)*piacikamat/365*(AM55-AD55),0)","v":0},{"$f":"IFERROR(-(AF55-AE55)*tenylegeskamat/365*(AM55-AD55),0)","v":0},{"$f":"IFERROR(AM55-AD55,\"\")","v":""},null,43,{"$f":"IF(COUNT(AM55)=1,AL52+1,\"\")","v":""},{"$f":"IF(OR(AM52=$C$29,AM52=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AK55-1)*12/$E$19)<=$C$29,EDATE($C$28,(AK55-1)*12/$E$19),$C$29),\"\"))","v":""},{"$f":"+IF(COUNT(AN52)<>0,SUM(AN52:AO52)*(1-M55),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM52,W$7:W$134,\"<=\"&AM55),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN55)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AA$7:AA$134,W$7:W$134,\">\"&AM52,W$7:W$134,\"<=\"&AM55)+AG55,IFERROR(-AN55*piacikamat/365*(AM55-AM52),\"\"))","v":""},{"$f":"+IF(COUNT(AQ52)<>0,SUM(AQ52:AR52)*(1-M55),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM52,W$7:W$134,\"<=\"&AM55),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ55)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,W$7:W$134,\">\"&AM52,W$7:W$134,\"<=\"&AM55)+AH55,IFERROR(-AQ55*tenylegeskamat/365*(AM55-AM52),\"\"))","v":""},null,{"$f":"IFERROR(MAX((ABS(AP55)-ABS(AS55)),0),\"\")","v":""},{"$f":"IFERROR(AU55/POWER(1+($C$11+1%)/$E$19,AL55-1)/(1+($C$11+1%)/365*($AM$7-$C$26)),\"\")","v":""},{"$f":"IFERROR(AM55-AM52,\"\")","v":""}]
[null,{"$f":"IF(C56<C48,\"Nem lehet kevesebb mint az azonos elszámolható költségekhez kapcsolódó mezőgazdasági ágazatra megítélt 3.1 támogatás összege\",\"Mezőgazdasági ágazatra megítélt 3.1 támogatás teljes összege (EUR)\")","v":"Mezőgazdasági ágazatra megítélt 3.1 támogatás teljes összege (EUR)"},0,null,null,null,null,null,null,null,null,null,{"$f":"AL56>$E$15","v":true},null,null,null,{"$f":"IF(ISBLANK(O55),\"\",O55)","v":""},{"$f":"IF(ISBLANK(O55),0,P55+R55)","v":0},{"$f":"IF(AND(ISBLANK(O55),AK56<>1),0,IFERROR(-R56*piacikamat/365*(IF(ISBLANK(O56),$C$28,O56)-Q56),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O55),AK56<>1),0,IFERROR(-R56*tenylegeskamat/365*(IF(ISBLANK(O56),$C$28,O56)-Q56),\"\"))","v":0},{"$f":"IFERROR(IF(ISBLANK(O56),$C$28,O56)-Q56,\"\")","v":""},null,null,null,{"$f":"IF(ISNA(MAX(W55,INDEX(AM$6:AM$134,MATCH(W56-1,AM$6:AM$134,1)))),\"\",MAX(W55,INDEX(AM$6:AM$134,MATCH(W56-1,AM$6:AM$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(Z55),Z55=\"\"),INDEX(AN$7:AN$134,MATCH(W56,AM$7:AM$134,1)),Z55-X55),INDEX(AN$7:AN$134,MATCH(W56,AM$7:AM$134,1)))),\"\",MIN(IF(OR(ISBLANK(Z55),Z55=\"\"),INDEX(AN$7:AN$134,MATCH(W56,AM$7:AM$134,1)),Z55-X55),INDEX(AN$7:AN$134,MATCH(W56,AM$7:AM$134,1))))","v":0},"",{"$f":"IFERROR(-Z56*tenylegeskamat/365*(W56-Y56),\"\")","v":""},{"$f":"IFERROR(W56-Y56,\"\")","v":""},{"$f":"MAX(AM55,IF(ISNA(INDEX(W$7:W$134,MATCH(AM56,W$7:W$134,1))),0,INDEX(W$7:W$134,MATCH(AM56,W$7:W$134,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(X$7:X$134,MATCH(AM56,W$7:W$134,1))),0,INDEX(X$7:X$134,MATCH(AM56,W$7:W$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(Z$7:Z$134,MATCH(AM56,W$7:W$134,1))),AN56,INDEX(Z$7:Z$134,MATCH(AM56,W$7:W$134,1)))","v":0},{"$f":"IFERROR(-(AF56-AE56)*piacikamat/365*(AM56-AD56),0)","v":0},{"$f":"IFERROR(-(AF56-AE56)*tenylegeskamat/365*(AM56-AD56),0)","v":0},{"$f":"IFERROR(AM56-AD56,\"\")","v":""},null,44,{"$f":"IF(COUNT(AM56)=1,AL55+1,\"\")","v":""},{"$f":"IF(OR(AM55=$C$29,AM55=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AK56-1)*12/$E$19)<=$C$29,EDATE($C$28,(AK56-1)*12/$E$19),$C$29),\"\"))","v":""},{"$f":"+IF(COUNT(AN55)<>0,SUM(AN55:AO55)*(1-M56),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM55,W$7:W$134,\"<=\"&AM56),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN56)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AA$7:AA$134,W$7:W$134,\">\"&AM55,W$7:W$134,\"<=\"&AM56)+AG56,IFERROR(-AN56*piacikamat/365*(AM56-AM55),\"\"))","v":""},{"$f":"+IF(COUNT(AQ55)<>0,SUM(AQ55:AR55)*(1-M56),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM55,W$7:W$134,\"<=\"&AM56),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ56)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,W$7:W$134,\">\"&AM55,W$7:W$134,\"<=\"&AM56)+AH56,IFERROR(-AQ56*tenylegeskamat/365*(AM56-AM55),\"\"))","v":""},null,{"$f":"IFERROR(MAX((ABS(AP56)-ABS(AS56)),0),\"\")","v":""},{"$f":"IFERROR(AU56/POWER(1+($C$11+1%)/$E$19,AL56-1)/(1+($C$11+1%)/365*($AM$7-$C$26)),\"\")","v":""},{"$f":"IFERROR(AM56-AM55,\"\")","v":""}]
[null,{"$f":"IF(C57<C49,\"Nem lehet kevesebb mint az azonos elszámolható költségekhez kapcsolódó halászati, akvakultúra ágazatra megítélt 3.1 támogatás összege\",\"Halászati, akvakultúra ágazatra  megítélt 3.1 támogatás teljes összeg (EUR)\")","v":"Halászati, akvakultúra ágazatra  megítélt 3.1 támogatás teljes összeg (EUR)"},0]
[null,{"$f":"IF(C58<C50,\"Nem lehet kevesebb mint az azonos elszámolható költségekhez kapcsolódó egyéb ágazatra megítélt 3.1 támogatás összege\",\"Egyéb ágazatra megítélt 3.1 támogatás teljes összege (EUR)\")","v":"Egyéb ágazatra megítélt 3.1 támogatás teljes összege (EUR)"},0]
[null,null,0,null,null,null,null,null,null,null,null,null,{"$f":"AL59>$E$15","v":true},null,null,null,{"$f":"IF(ISBLANK(O56),\"\",O56)","v":""},{"$f":"IF(ISBLANK(O56),0,P56+R56)","v":0},{"$f":"IF(AND(ISBLANK(O56),AK59<>1),0,IFERROR(-R59*piacikamat/365*(IF(ISBLANK(O59),$C$28,O59)-Q59),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O56),AK59<>1),0,IFERROR(-R59*tenylegeskamat/365*(IF(ISBLANK(O59),$C$28,O59)-Q59),\"\"))","v":0},{"$f":"IFERROR(IF(ISBLANK(O59),$C$28,O59)-Q59,\"\")","v":""},null,null,null,{"$f":"IF(ISNA(MAX(W56,INDEX(AM$6:AM$134,MATCH(W59-1,AM$6:AM$134,1)))),\"\",MAX(W56,INDEX(AM$6:AM$134,MATCH(W59-1,AM$6:AM$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(Z56),Z56=\"\"),INDEX(AN$7:AN$134,MATCH(W59,AM$7:AM$134,1)),Z56-X56),INDEX(AN$7:AN$134,MATCH(W59,AM$7:AM$134,1)))),\"\",MIN(IF(OR(ISBLANK(Z56),Z56=\"\"),INDEX(AN$7:AN$134,MATCH(W59,AM$7:AM$134,1)),Z56-X56),INDEX(AN$7:AN$134,MATCH(W59,AM$7:AM$134,1))))","v":0},"",{"$f":"IFERROR(-Z59*tenylegeskamat/365*(W59-Y59),\"\")","v":""},{"$f":"IFERROR(W59-Y59,\"\")","v":""},{"$f":"MAX(AM56,IF(ISNA(INDEX(W$7:W$134,MATCH(AM59,W$7:W$134,1))),0,INDEX(W$7:W$134,MATCH(AM59,W$7:W$134,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(X$7:X$134,MATCH(AM59,W$7:W$134,1))),0,INDEX(X$7:X$134,MATCH(AM59,W$7:W$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(Z$7:Z$134,MATCH(AM59,W$7:W$134,1))),AN59,INDEX(Z$7:Z$134,MATCH(AM59,W$7:W$134,1)))","v":0},{"$f":"IFERROR(-(AF59-AE59)*piacikamat/365*(AM59-AD59),0)","v":0},{"$f":"IFERROR(-(AF59-AE59)*tenylegeskamat/365*(AM59-AD59),0)","v":0},{"$f":"IFERROR(AM59-AD59,\"\")","v":""},null,45,{"$f":"IF(COUNT(AM59)=1,AL56+1,\"\")","v":""},{"$f":"IF(OR(AM56=$C$29,AM56=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AK59-1)*12/$E$19)<=$C$29,EDATE($C$28,(AK59-1)*12/$E$19),$C$29),\"\"))","v":""},{"$f":"+IF(COUNT(AN56)<>0,SUM(AN56:AO56)*(1-M59),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM56,W$7:W$134,\"<=\"&AM59),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN59)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AA$7:AA$134,W$7:W$134,\">\"&AM56,W$7:W$134,\"<=\"&AM59)+AG59,IFERROR(-AN59*piacikamat/365*(AM59-AM56),\"\"))","v":""},{"$f":"+IF(COUNT(AQ56)<>0,SUM(AQ56:AR56)*(1-M59),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM56,W$7:W$134,\"<=\"&AM59),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ59)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,W$7:W$134,\">\"&AM56,W$7:W$134,\"<=\"&AM59)+AH59,IFERROR(-AQ59*tenylegeskamat/365*(AM59-AM56),\"\"))","v":""},null,{"$f":"IFERROR(MAX((ABS(AP59)-ABS(AS59)),0),\"\")","v":""},{"$f":"IFERROR(AU59/POWER(1+($C$11+1%)/$E$19,AL59-1)/(1+($C$11+1%)/365*($AM$7-$C$26)),\"\")","v":""},{"$f":"IFERROR(AM59-AM56,\"\")","v":""}]
[null,"Azonos megyében folytatott működés során megítélt regionális beruházási támogatások",0,"HUF",null,null,null,null,null,null,null,null,true,null,null,null,"",0,{"$f":"IF(AND(ISBLANK(O59),AK60<>1),0,IFERROR(-R60*piacikamat/365*(IF(ISBLANK(O60),$C$28,O60)-Q60),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O59),AK60<>1),0,IFERROR(-R60*tenylegeskamat/365*(IF(ISBLANK(O60),$C$28,O60)-Q60),\"\"))","v":0},"",null,null,null,{"$f":"IF(ISNA(MAX(W59,INDEX(AM$6:AM$134,MATCH(W60-1,AM$6:AM$134,1)))),\"\",MAX(W59,INDEX(AM$6:AM$134,MATCH(W60-1,AM$6:AM$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(Z59),Z59=\"\"),INDEX(AN$7:AN$134,MATCH(W60,AM$7:AM$134,1)),Z59-X59),INDEX(AN$7:AN$134,MATCH(W60,AM$7:AM$134,1)))),\"\",MIN(IF(OR(ISBLANK(Z59),Z59=\"\"),INDEX(AN$7:AN$134,MATCH(W60,AM$7:AM$134,1)),Z59-X59),INDEX(AN$7:AN$134,MATCH(W60,AM$7:AM$134,1))))","v":0},"","","",{"$f":"MAX(AM59,IF(ISNA(INDEX(W$7:W$134,MATCH(AM60,W$7:W$134,1))),0,INDEX(W$7:W$134,MATCH(AM60,W$7:W$134,1))))","v":"00:00:00"},0,0,0,0,"",null,46,"",{"$f":"IF(OR(AM59=$C$29,AM59=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AK60-1)*12/$E$19)<=$C$29,EDATE($C$28,(AK60-1)*12/$E$19),$C$29),\"\"))","v":""},{"$f":"+IF(COUNT(AN59)<>0,SUM(AN59:AO59)*(1-M60),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM59,W$7:W$134,\"<=\"&AM60),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN60)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AA$7:AA$134,W$7:W$134,\">\"&AM59,W$7:W$134,\"<=\"&AM60)+AG60,IFERROR(-AN60*piacikamat/365*(AM60-AM59),\"\"))","v":""},{"$f":"+IF(COUNT(AQ59)<>0,SUM(AQ59:AR59)*(1-M60),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM59,W$7:W$134,\"<=\"&AM60),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ60)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,W$7:W$134,\">\"&AM59,W$7:W$134,\"<=\"&AM60)+AH60,IFERROR(-AQ60*tenylegeskamat/365*(AM60-AM59),\"\"))","v":""},null,"","",{"$f":"IFERROR(AM60-AM59,\"\")","v":""}]
[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",0,0,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,47,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM60,W$7:W$134,\"<=\"&AM61),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN61)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM60,W$7:W$134,\"<=\"&AM61),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ61)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"KKV-ék részére megítélt beruházási támogatások","EUR","HUF",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,48,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM61,W$7:W$134,\"<=\"&AM62),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN62)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM61,W$7:W$134,\"<=\"&AM62),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ62)>$E$15,\"\",-$AN$5/$E$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",0,0,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(X$7:X$134,W$7:W$134,\">\"&AM62,W$7:W$134,\"<=\"&AM63),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN63)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM62,W$7:W$134,\"<=\"&AM63),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ63)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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,50,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM63,W$7:W$134,\"<=\"&AM64),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN64)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM63,W$7:W$134,\"<=\"&AM64),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ64)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Korábban megítélt egyéb támogatások adatai",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,51,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM64,W$7:W$134,\"<=\"&AM65),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN65)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM64,W$7:W$134,\"<=\"&AM65),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ65)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Korábban megítélt állami támogatások rendeleti alapja",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,52,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM65,W$7:W$134,\"<=\"&AM66),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN66)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM65,W$7:W$134,\"<=\"&AM66),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ66)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Korábban megítélt állami támogatások jogcíme",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,53,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM66,W$7:W$134,\"<=\"&AM67),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN67)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM66,W$7:W$134,\"<=\"&AM67),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ67)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Korábban megítélt állami támogatás összege (HUF)",0,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(X$7:X$134,W$7:W$134,\">\"&AM67,W$7:W$134,\"<=\"&AM68),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN68)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM67,W$7:W$134,\"<=\"&AM68),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ68)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Korábban megítélt egyéb támogatás keretében adható max. támogatás intenzitás mértéke",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(X$7:X$134,W$7:W$134,\">\"&AM68,W$7:W$134,\"<=\"&AM69),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN69)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM68,W$7:W$134,\"<=\"&AM69),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ69)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM69,W$7:W$134,\"<=\"&AM70),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN70)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM69,W$7:W$134,\"<=\"&AM70),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ70)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM70,W$7:W$134,\"<=\"&AM71),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN71)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM70,W$7:W$134,\"<=\"&AM71),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ71)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM71,W$7:W$134,\"<=\"&AM72),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN72)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM71,W$7:W$134,\"<=\"&AM72),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ72)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM72,W$7:W$134,\"<=\"&AM73),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN73)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM72,W$7:W$134,\"<=\"&AM73),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ73)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM73,W$7:W$134,\"<=\"&AM74),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN74)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM73,W$7:W$134,\"<=\"&AM74),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ74)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM74,W$7:W$134,\"<=\"&AM75),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN75)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM74,W$7:W$134,\"<=\"&AM75),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ75)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM75,W$7:W$134,\"<=\"&AM76),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN76)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM75,W$7:W$134,\"<=\"&AM76),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ76)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM76,W$7:W$134,\"<=\"&AM77),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN77)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM76,W$7:W$134,\"<=\"&AM77),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ77)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM77,W$7:W$134,\"<=\"&AM78),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN78)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM77,W$7:W$134,\"<=\"&AM78),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ78)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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,65,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM78,W$7:W$134,\"<=\"&AM79),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN79)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM78,W$7:W$134,\"<=\"&AM79),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ79)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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,66,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM79,W$7:W$134,\"<=\"&AM80),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN80)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM79,W$7:W$134,\"<=\"&AM80),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ80)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,{"$f":"IF(ISBLANK(O80),\"\",O80)","v":""},0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,67,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM80,W$7:W$134,\"<=\"&AM81),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN81)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM80,W$7:W$134,\"<=\"&AM81),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ81)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM81,W$7:W$134,\"<=\"&AM82),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN82)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM81,W$7:W$134,\"<=\"&AM82),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ82)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM82,W$7:W$134,\"<=\"&AM83),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN83)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM82,W$7:W$134,\"<=\"&AM83),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ83)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM83,W$7:W$134,\"<=\"&AM84),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN84)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM83,W$7:W$134,\"<=\"&AM84),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ84)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM84,W$7:W$134,\"<=\"&AM85),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN85)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM84,W$7:W$134,\"<=\"&AM85),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ85)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM85,W$7:W$134,\"<=\"&AM86),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN86)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM85,W$7:W$134,\"<=\"&AM86),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ86)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM86,W$7:W$134,\"<=\"&AM87),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN87)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM86,W$7:W$134,\"<=\"&AM87),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ87)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM87,W$7:W$134,\"<=\"&AM88),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN88)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM87,W$7:W$134,\"<=\"&AM88),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ88)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM88,W$7:W$134,\"<=\"&AM89),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN89)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM88,W$7:W$134,\"<=\"&AM89),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ89)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM89,W$7:W$134,\"<=\"&AM90),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN90)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM89,W$7:W$134,\"<=\"&AM90),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ90)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AL91>$E$15","v":true},null,null,null,"",0,0,0,{"$f":"IFERROR(IF(ISBLANK(O91),$C$28,O91)-Q91,\"\")","v":""},null,null,null,"",0,"",{"$f":"IFERROR(-Z91*tenylegeskamat/365*(W91-Y91),\"\")","v":""},{"$f":"IFERROR(W91-Y91,\"\")","v":""},"00:00:00",{"$f":"IF(ISNA(INDEX(X$7:X$134,MATCH(AM91,W$7:W$134,1))),0,INDEX(X$7:X$134,MATCH(AM91,W$7:W$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(Z$7:Z$134,MATCH(AM91,W$7:W$134,1))),AN91,INDEX(Z$7:Z$134,MATCH(AM91,W$7:W$134,1)))","v":0},{"$f":"IFERROR(-(AF91-AE91)*piacikamat/365*(AM91-AD91),0)","v":0},{"$f":"IFERROR(-(AF91-AE91)*tenylegeskamat/365*(AM91-AD91),0)","v":0},{"$f":"IFERROR(AM91-AD91,\"\")","v":""},null,77,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM90,W$7:W$134,\"<=\"&AM91),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN91)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM90,W$7:W$134,\"<=\"&AM91),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ91)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,{"$f":"IFERROR(MAX((ABS(AP91)-ABS(AS91)),0),\"\")","v":""},{"$f":"IFERROR(AU91/POWER(1+($C$11+1%)/$E$19,AL91-1)/(1+($C$11+1%)/365*($AM$7-$C$26)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,{"$f":"IF(AND(ISBLANK(O91),AK92<>1),0,IFERROR(-R92*piacikamat/365*(IF(ISBLANK(O92),$C$28,O92)-Q92),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O91),AK92<>1),0,IFERROR(-R92*tenylegeskamat/365*(IF(ISBLANK(O92),$C$28,O92)-Q92),\"\"))","v":0},"",null,null,null,{"$f":"IF(ISNA(MAX(W91,INDEX(AM$6:AM$134,MATCH(W92-1,AM$6:AM$134,1)))),\"\",MAX(W91,INDEX(AM$6:AM$134,MATCH(W92-1,AM$6:AM$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(Z91),Z91=\"\"),INDEX(AN$7:AN$134,MATCH(W92,AM$7:AM$134,1)),Z91-X91),INDEX(AN$7:AN$134,MATCH(W92,AM$7:AM$134,1)))),\"\",MIN(IF(OR(ISBLANK(Z91),Z91=\"\"),INDEX(AN$7:AN$134,MATCH(W92,AM$7:AM$134,1)),Z91-X91),INDEX(AN$7:AN$134,MATCH(W92,AM$7:AM$134,1))))","v":0},"","","",{"$f":"MAX(AM91,IF(ISNA(INDEX(W$7:W$134,MATCH(AM92,W$7:W$134,1))),0,INDEX(W$7:W$134,MATCH(AM92,W$7:W$134,1))))","v":"00:00:00"},0,0,0,0,"",null,78,"",{"$f":"IF(OR(AM91=$C$29,AM91=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AK92-1)*12/$E$19)<=$C$29,EDATE($C$28,(AK92-1)*12/$E$19),$C$29),\"\"))","v":""},{"$f":"+IF(COUNT(AN91)<>0,SUM(AN91:AO91)*(1-M92),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM91,W$7:W$134,\"<=\"&AM92),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN92)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AA$7:AA$134,W$7:W$134,\">\"&AM91,W$7:W$134,\"<=\"&AM92)+AG92,IFERROR(-AN92*piacikamat/365*(AM92-AM91),\"\"))","v":""},{"$f":"+IF(COUNT(AQ91)<>0,SUM(AQ91:AR91)*(1-M92),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM91,W$7:W$134,\"<=\"&AM92),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ92)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,W$7:W$134,\">\"&AM91,W$7:W$134,\"<=\"&AM92)+AH92,IFERROR(-AQ92*tenylegeskamat/365*(AM92-AM91),\"\"))","v":""},null,"","",{"$f":"IFERROR(AM92-AM91,\"\")","v":""}]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM92,W$7:W$134,\"<=\"&AM93),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN93)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM92,W$7:W$134,\"<=\"&AM93),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ93)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM93,W$7:W$134,\"<=\"&AM94),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN94)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM93,W$7:W$134,\"<=\"&AM94),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ94)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM94,W$7:W$134,\"<=\"&AM95),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN95)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM94,W$7:W$134,\"<=\"&AM95),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ95)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM95,W$7:W$134,\"<=\"&AM96),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN96)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM95,W$7:W$134,\"<=\"&AM96),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ96)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM96,W$7:W$134,\"<=\"&AM97),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN97)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM96,W$7:W$134,\"<=\"&AM97),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ97)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM97,W$7:W$134,\"<=\"&AM98),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN98)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM97,W$7:W$134,\"<=\"&AM98),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ98)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM98,W$7:W$134,\"<=\"&AM99),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN99)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM98,W$7:W$134,\"<=\"&AM99),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ99)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM99,W$7:W$134,\"<=\"&AM100),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN100)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM99,W$7:W$134,\"<=\"&AM100),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ100)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM100,W$7:W$134,\"<=\"&AM101),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN101)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM100,W$7:W$134,\"<=\"&AM101),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ101)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM101,W$7:W$134,\"<=\"&AM102),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN102)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM101,W$7:W$134,\"<=\"&AM102),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ102)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM102,W$7:W$134,\"<=\"&AM103),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN103)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM102,W$7:W$134,\"<=\"&AM103),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ103)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM103,W$7:W$134,\"<=\"&AM104),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN104)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM103,W$7:W$134,\"<=\"&AM104),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ104)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM104,W$7:W$134,\"<=\"&AM105),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN105)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM104,W$7:W$134,\"<=\"&AM105),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ105)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM105,W$7:W$134,\"<=\"&AM106),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN106)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM105,W$7:W$134,\"<=\"&AM106),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ106)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM106,W$7:W$134,\"<=\"&AM107),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN107)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM106,W$7:W$134,\"<=\"&AM107),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ107)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM107,W$7:W$134,\"<=\"&AM108),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN108)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM107,W$7:W$134,\"<=\"&AM108),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ108)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM108,W$7:W$134,\"<=\"&AM109),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN109)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM108,W$7:W$134,\"<=\"&AM109),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ109)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM109,W$7:W$134,\"<=\"&AM110),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN110)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM109,W$7:W$134,\"<=\"&AM110),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ110)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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,97,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM110,W$7:W$134,\"<=\"&AM111),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN111)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM110,W$7:W$134,\"<=\"&AM111),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ111)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM111,W$7:W$134,\"<=\"&AM112),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN112)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM111,W$7:W$134,\"<=\"&AM112),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ112)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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,99,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM112,W$7:W$134,\"<=\"&AM113),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN113)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM112,W$7:W$134,\"<=\"&AM113),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ113)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM113,W$7:W$134,\"<=\"&AM114),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN114)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM113,W$7:W$134,\"<=\"&AM114),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ114)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM114,W$7:W$134,\"<=\"&AM115),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN115)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM114,W$7:W$134,\"<=\"&AM115),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ115)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM115,W$7:W$134,\"<=\"&AM116),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN116)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM115,W$7:W$134,\"<=\"&AM116),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ116)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM116,W$7:W$134,\"<=\"&AM117),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN117)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM116,W$7:W$134,\"<=\"&AM117),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ117)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM117,W$7:W$134,\"<=\"&AM118),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN118)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM117,W$7:W$134,\"<=\"&AM118),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ118)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",{"$f":"IF(ISBLANK(O118),0,P118+R118)","v":0},0,0,"",null,null,null,"",0,{"$f":"IFERROR(-Z119*piacikamat/365*(W119-Y119),\"\")","v":""},"","","00:00:00",0,0,0,0,"",null,105,{"$f":"IF(COUNT(AM119)=1,AL118+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM118,W$7:W$134,\"<=\"&AM119),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN119)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM118,W$7:W$134,\"<=\"&AM119),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ119)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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,106,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM119,W$7:W$134,\"<=\"&AM120),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN120)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM119,W$7:W$134,\"<=\"&AM120),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ120)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM120,W$7:W$134,\"<=\"&AM121),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN121)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM120,W$7:W$134,\"<=\"&AM121),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ121)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM121,W$7:W$134,\"<=\"&AM122),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN122)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM121,W$7:W$134,\"<=\"&AM122),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ122)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AL123>$E$15","v":true},null,null,null,"",0,0,0,{"$f":"IFERROR(IF(ISBLANK(O123),$C$28,O123)-Q123,\"\")","v":""},null,null,null,"",0,"",{"$f":"IFERROR(-Z123*tenylegeskamat/365*(W123-Y123),\"\")","v":""},{"$f":"IFERROR(W123-Y123,\"\")","v":""},"00:00:00",{"$f":"IF(ISNA(INDEX(X$7:X$134,MATCH(AM123,W$7:W$134,1))),0,INDEX(X$7:X$134,MATCH(AM123,W$7:W$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(Z$7:Z$134,MATCH(AM123,W$7:W$134,1))),AN123,INDEX(Z$7:Z$134,MATCH(AM123,W$7:W$134,1)))","v":0},{"$f":"IFERROR(-(AF123-AE123)*piacikamat/365*(AM123-AD123),0)","v":0},{"$f":"IFERROR(-(AF123-AE123)*tenylegeskamat/365*(AM123-AD123),0)","v":0},{"$f":"IFERROR(AM123-AD123,\"\")","v":""},null,109,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM122,W$7:W$134,\"<=\"&AM123),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN123)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM122,W$7:W$134,\"<=\"&AM123),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ123)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,{"$f":"IFERROR(MAX((ABS(AP123)-ABS(AS123)),0),\"\")","v":""},{"$f":"IFERROR(AU123/POWER(1+($C$11+1%)/$E$19,AL123-1)/(1+($C$11+1%)/365*($AM$7-$C$26)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,{"$f":"IF(AND(ISBLANK(O123),AK124<>1),0,IFERROR(-R124*piacikamat/365*(IF(ISBLANK(O124),$C$28,O124)-Q124),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O123),AK124<>1),0,IFERROR(-R124*tenylegeskamat/365*(IF(ISBLANK(O124),$C$28,O124)-Q124),\"\"))","v":0},"",null,null,null,{"$f":"IF(ISNA(MAX(W123,INDEX(AM$6:AM$134,MATCH(W124-1,AM$6:AM$134,1)))),\"\",MAX(W123,INDEX(AM$6:AM$134,MATCH(W124-1,AM$6:AM$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(Z123),Z123=\"\"),INDEX(AN$7:AN$134,MATCH(W124,AM$7:AM$134,1)),Z123-X123),INDEX(AN$7:AN$134,MATCH(W124,AM$7:AM$134,1)))),\"\",MIN(IF(OR(ISBLANK(Z123),Z123=\"\"),INDEX(AN$7:AN$134,MATCH(W124,AM$7:AM$134,1)),Z123-X123),INDEX(AN$7:AN$134,MATCH(W124,AM$7:AM$134,1))))","v":0},"","","",{"$f":"MAX(AM123,IF(ISNA(INDEX(W$7:W$134,MATCH(AM124,W$7:W$134,1))),0,INDEX(W$7:W$134,MATCH(AM124,W$7:W$134,1))))","v":"00:00:00"},0,0,0,0,"",null,110,"",{"$f":"IF(OR(AM123=$C$29,AM123=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AK124-1)*12/$E$19)<=$C$29,EDATE($C$28,(AK124-1)*12/$E$19),$C$29),\"\"))","v":""},{"$f":"+IF(COUNT(AN123)<>0,SUM(AN123:AO123)*(1-M124),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM123,W$7:W$134,\"<=\"&AM124),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN124)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AA$7:AA$134,W$7:W$134,\">\"&AM123,W$7:W$134,\"<=\"&AM124)+AG124,IFERROR(-AN124*piacikamat/365*(AM124-AM123),\"\"))","v":""},{"$f":"+IF(COUNT(AQ123)<>0,SUM(AQ123:AR123)*(1-M124),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM123,W$7:W$134,\"<=\"&AM124),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ124)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,W$7:W$134,\">\"&AM123,W$7:W$134,\"<=\"&AM124)+AH124,IFERROR(-AQ124*tenylegeskamat/365*(AM124-AM123),\"\"))","v":""},null,"","",{"$f":"IFERROR(AM124-AM123,\"\")","v":""}]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM124,W$7:W$134,\"<=\"&AM125),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN125)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM124,W$7:W$134,\"<=\"&AM125),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ125)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM125,W$7:W$134,\"<=\"&AM126),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN126)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM125,W$7:W$134,\"<=\"&AM126),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ126)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM126,W$7:W$134,\"<=\"&AM127),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN127)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM126,W$7:W$134,\"<=\"&AM127),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ127)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM127,W$7:W$134,\"<=\"&AM128),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN128)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM127,W$7:W$134,\"<=\"&AM128),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ128)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM128,W$7:W$134,\"<=\"&AM129),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN129)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM128,W$7:W$134,\"<=\"&AM129),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ129)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM129,W$7:W$134,\"<=\"&AM130),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN130)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM129,W$7:W$134,\"<=\"&AM130),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ130)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM130,W$7:W$134,\"<=\"&AM131),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN131)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM130,W$7:W$134,\"<=\"&AM131),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ131)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM131,W$7:W$134,\"<=\"&AM132),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN132)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM131,W$7:W$134,\"<=\"&AM132),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ132)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM132,W$7:W$134,\"<=\"&AM133),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN133)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM132,W$7:W$134,\"<=\"&AM133),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ133)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,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(X$7:X$134,W$7:W$134,\">\"&AM133,W$7:W$134,\"<=\"&AM134),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN134)>$E$15,\"\",-$AN$5/$E$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(X$7:X$134,W$7:W$134,\">\"&AM133,W$7:W$134,\"<=\"&AM134),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ134)>$E$15,\"\",-$AN$5/$E$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!C37","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":0}]
["A Elszámolható költségek",{"$f":"IF((B9-C10)>0,C10,B9)","v":0},55000000]
["B Elszámolható költségek",{"$f":"IF(B10<C10,0,IF(B9-C11<0,B9-C10,C10))","v":0},110000000]
["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}]
["Kaphat?",{"$f":"IF(B15>0,1,0)","v":{"$error":"#N/A"}}]
["Alap intenzitás",{"$f":"VLOOKUP(Tamogatastartalom!C37,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=\"Mikró/Kis\",0.2,IF(D3=\"Közepes\",0.1,0))","v":0}]
["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!AU5","v":0}]
["Hitelösszeg/támogatástartalom",{"$f":"B23/B24","v":{"$error":"#DIV/0!"}}]

{"sheet":"Adatok","index":3,"n_rows":25,"n_cols":21,"rows_kept":25,"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,"Annuitás",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,"Egyedi"]
[null,null,null,null,"Kielégítő",100,220,400,null,"Max",{"$f":"refkammin+4%","v":4.1000000000000002E-2}]
[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,"zöld ügyleti kamat","HUF","EUR","ügyleti kamat","HUF","EUR"]
["Dél-Dunántúl",0.5,null,0.3,22.5,"min",0.03,5.0000000000000001E-3,"min",{"$f":"IF(Tamogatastartalom!$C$9=\"HUF\",0.035,0.01)","v":0.01},0.01]
["Észak-Alföld",0.5,null,0.25,18.75,"max",0.115,7.4999999999999997E-2,"max",0.12,0.08]
["Észak-Magyarország",0.5,null,0.2,15]
["Közép-Dunántúl",0.3,null,0,0,null,null,null,"2.3 min kamat"," "]
["Pest",0.5,null,null,null,null,null,null,"EUR",13,25,37,49,61,73,85]
["Nyugat-Dunántúl",0.3,null,null,null,null,null,null,"Mikró/Kis",1.46E-2,1.5099999999999999E-2,1.7600000000000001E-2,1.8800000000000001E-2,1.95E-2,2.98E-2,3.1699999999999999E-2]
["Budapest",0,null,null,null,null,null,null,"Közepes",1.46E-2,1.5099999999999999E-2,1.7600000000000001E-2,1.8800000000000001E-2,1.95E-2,2.98E-2,3.1699999999999999E-2]
[null,null,null,null,null,null,null,null,"Nagy",1.89E-2,1.9900000000000001E-2,2.4899999999999999E-2,2.7199999999999998E-2,2.87E-2,4.0300000000000002E-2,4.2700000000000002E-2]
[null,null,null,null,null,null,null,null,"HUF",13,25,37,49,61,73,85]
[null,null,null,null,null,null,null,null,"Mikró/Kis",0.1158,0.1163,0.1188,0.12,0.1207,0.13100000000000001,0.13289999999999999]
[null,null,null,null,null,null,null,null,"Közepes",0.1158,0.1163,0.1188,0.12,0.1207,0.13100000000000001,0.13289999999999999]
[null,null,null,null,null,null,null,null,"Nagy",0.1201,0.1211,0.12609999999999999,0.12840000000000001,0.12990000000000002,0.14150000000000001,0.1439]