{"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":58,"rows_kept":134,"cut":false,"hidden":false,"merged":[[10,6,12,6],[0,23,1,24],[0,14,1,15],[3,1,3,2],[5,1,5,2],[7,6,9,6],[2,57,3,57],[3,5,4,5],[2,23,3,23],[2,24,3,24],[2,52,2,53],[2,48,2,50],[2,25,2,29],[2,31,2,36],[2,42,2,44],[2,14,3,14],[2,15,3,15],[2,45,2,47],[2,54,2,55]]}
[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,null,{"$f":"IF(SUM(Y7:Y134)<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,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,null,"maradék kamatszámítás",null,null,null,null,null,null,null,null,null,null,"Piaci konstrukció",null,null,"Minimum kamat 2.3",null,null,"Támogatott konstruckió",null,null,null,"Támogatástartalom",null,"Támogatástartalom (min 2.3)",null,null,"Támogatástartalom + egyéb kedvezmények"]
[null,null,null,null,-0.04,null,"Hitelösszeg (EUR)",null,{"$f":"IF(C9=\"HUF\",C24/C10,C24)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C9=\"HUF\",C24,C24*arfolyam)","v":0},null,null,null,null,null,null,null,null,"kamat","kamat (min 2.3)","támogatott",null,null,null,null,"dátumtól","tőke","kamat","kamat (min 2.3)","támogatott",null,"dátumtól","amort","tőke","maradék","maradék (min 2.3)","t maradék",null,null,null,"Periodus","Dátum","Tőke","Tőkeamt.","Kamatfiz.","Tőke","Tőkeamt.","Kamatfiz.","Tőke","Tőkeamt.","Kamatfiz.",null,"FV","PV","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":2000000},null,"Ténylegesen felvett hitel támogatástartalma 2.1",null,{"$f":"IF(C9=\"HUF\",BC5/C10,BC5)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C9=\"HUF\",BC5,BC5*C10)","v":0},{"$f":"IFERROR(IF(E5-I5<=0,\"Nem elegendő a 2.1 szabad keret\",\"Elegendő a 2.1 szabad keret\"),\"\")","v":""},{"$f":"IFERROR(IF(E6-I5<=0,\"Nem elegendő a 3.1 szabad keret\",\"Elegendő a 3.1 szabad keret\"),\"\")","v":""},null,null,null,null,null,null,{"$f":"SUM(S7:S134)","v":0},{"$f":"SUM(T7:T134)","v":0},{"$f":"SUM(U7:U134)","v":0},null,null,null,null,null,null,{"$f":"SUM(AB7:AB134)","v":0},{"$f":"SUM(AC7:AC134)","v":0},{"$f":"SUM(AD7:AD134)","v":0},null,null,null,null,{"$f":"SUM(AI7:AI134)","v":0},{"$f":"SUM(AJ7:AJ134)","v":0},{"$f":"SUM(AK7:AK134)","v":0},null,null,null,null,null,{"$f":"+AQ7","v":0},{"$f":"SUM(AR7:AR134)","v":0},{"$f":"SUM(AS7:AS134)","v":0},{"$f":"+AT7","v":0},{"$f":"SUM(AU7:AU134)","v":0},{"$f":"SUM(AV7:AV134)","v":0},{"$f":"+AW7","v":0},{"$f":"SUM(AX7:AX134)","v":0},{"$f":"SUM(AY7:AY134)","v":0},null,{"$f":"SUM(BA7:BA134)","v":0},{"$f":"SUM(BB7:BB134)","v":0},{"$f":"SUM(BC7:BC134)","v":0},{"$f":"SUM(BD7:BD134)","v":0},null,{"$f":"BB5","v":0}]
[null,null,null,null,{"$f":"IF(C22=\"Halászati\",K13,IF(C22=\"Mezőgazdasági\",K12,K11))","v":2300000},null,"Ténylegesen felvett hitel támogatástartalma 2.3",null,{"$f":"IF(C9=\"HUF\",BB5/C10,BB5)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C9=\"HUF\",BB5,BB5*C10)","v":0},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,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":"AO7>$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),AN7<>1),0,IFERROR(-R7*piacikamat/365*(IF(ISBLANK(O7),$C$28,O7)-Q7),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O6),AN7<>1),0,IFERROR(-R7*minkamat23/365*(IF(ISBLANK(O7),$C$28,O7)-Q7),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O6),AN7<>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(X6,INDEX(AP$6:AP$134,MATCH(X7-1,AP$6:AP$134,1)))),\"\",MAX(X6,INDEX(AP$6:AP$134,MATCH(X7-1,AP$6:AP$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(AA6),AA6=\"\"),INDEX(AQ$7:AQ$134,MATCH(X7,AP$7:AP$134,1)),AA6-Y6),INDEX(AQ$7:AQ$134,MATCH(X7,AP$7:AP$134,1)))),\"\",MIN(IF(OR(ISBLANK(AA6),AA6=\"\"),INDEX(AQ$7:AQ$134,MATCH(X7,AP$7:AP$134,1)),AA6-Y6),INDEX(AQ$7:AQ$134,MATCH(X7,AP$7:AP$134,1))))","v":0},{"$f":"IFERROR(-AA7*piacikamat/365*(X7-Z7),\"\")","v":""},{"$f":"IFERROR(-AA7*minkamat23/365*(X7-Z7),\"\")","v":""},{"$f":"IFERROR(-AA7*tenylegeskamat/365*(X7-Z7),\"\")","v":""},{"$f":"IFERROR(X7-Z7,\"\")","v":""},{"$f":"MAX(AP6,IF(ISNA(INDEX(X$7:X$134,MATCH(AP7,X$7:X$134,1))),0,INDEX(X$7:X$134,MATCH(AP7,X$7:X$134,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(Y$7:Y$134,MATCH(AP7,X$7:X$134,1))),0,INDEX(Y$7:Y$134,MATCH(AP7,X$7:X$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(AA$7:AA$134,MATCH(AP7,X$7:X$134,1))),AQ7,INDEX(AA$7:AA$134,MATCH(AP7,X$7:X$134,1)))","v":0},{"$f":"IFERROR(-(AH7-AG7)*piacikamat/365*(AP7-AF7),0)","v":0},{"$f":"IFERROR(-(AH7-AG7)*minkamat23/365*(AP7-AF7),0)","v":0},{"$f":"IFERROR(-(AH7-AG7)*tenylegeskamat/365*(AP7-AF7),0)","v":0},{"$f":"IFERROR(AP7-AF7,\"\")","v":0},null,1,{"$f":"+IF(C29-C28<>0,1,\"\")","v":""},{"$f":"C28","v":"00:00:00"},{"$f":"IF(+C24<>0,C24,IF(AO7>0,C24*M7,\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP6,X$7:X$134,\"<=\"&AP7),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ7)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"SUM(S7:S134)","v":0},{"$f":"IF(+C24<>0,C24,IF(AO7>0,C24*M7,\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP6,X$7:X$134,\"<=\"&AP7),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT7)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},{"$f":"SUM(T7:T134)","v":0},{"$f":"+AQ7","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP6,X$7:X$134,\"<=\"&AP7),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW7)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"SUM(U7:U134)","v":0},null,{"$f":"IFERROR(MAX((ABS(AS7)-ABS(AY7)),0),\"\")","v":0},{"$f":"IFERROR(BA7/(1+($C$11+1%)/365*(AP7-C26)),\"\")","v":0},{"$f":"IFERROR(MAX((ABS(AV7)-ABS(AY7)),0),\"\")","v":0},{"$f":"IFERROR(BC7/(1+($C$11+1%)/365*(AP7-C26)),\"\")","v":0},{"$f":"IFERROR(AP7-AP6,\"\")","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(2000000-C42-C43-C44-C47-C48-C49-C53-C54-C55<=0,\"Nincs szabad keret, nem finanszírozható\",2000000-C42-C43-C44-C47-C48-C49-C53-C54-C55)","v":2000000},null,{"$f":"AO8>$E$15","v":true},null,null,null,{"$f":"IF(ISBLANK(O7),\"\",O7)","v":""},{"$f":"IF(ISBLANK(O7),0,P7+R7)","v":0},0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,2,{"$f":"IF(COUNT(AP8)=1,AO7+1,\"\")","v":""},{"$f":"IF(OR(AP7=$C$29,AP7=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AN8-1)*12/$E$19)<=$C$29,EDATE($C$28,(AN8-1)*12/$E$19),$C$29),\"\"))","v":""},{"$f":"+IF(COUNT(AQ7)<>0,SUM(AQ7:AR7)*(1-M8),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP7,X$7:X$134,\"<=\"&AP8),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ8)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,X$7:X$134,\">\"&AP7,X$7:X$134,\"<=\"&AP8)+AI8,IFERROR(-AQ8*piacikamat/365*(AP8-AP7),\"\"))","v":""},{"$f":"+IF(COUNT(AT7)<>0,SUM(AT7:AU7)*(1-M8),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP7,X$7:X$134,\"<=\"&AP8),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT8)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AC$7:AC$134,X$7:X$134,\">\"&AP7,X$7:X$134,\"<=\"&AP8)+AJ8,IFERROR(-AT8*minkamat23/365*(AP8-AP7),\"\"))","v":""},{"$f":"+IF(COUNT(AW7)<>0,SUM(AW7:AX7)*(1-M8),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP7,X$7:X$134,\"<=\"&AP8),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW8)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AD$7:AD$134,X$7:X$134,\">\"&AP7,X$7:X$134,\"<=\"&AP8)+AK8,IFERROR(-AW8*tenylegeskamat/365*(AP8-AP7),\"\"))","v":""},null,{"$f":"IFERROR(MAX((ABS(AS8)-ABS(AY8)),0),\"\")","v":""},{"$f":"IFERROR(BA8/POWER(1+($C$11+1%)/$E$19,AO8-1)/(1+($C$11+1%)/365*($AP$7-$C$26)),\"\")","v":""},{"$f":"IFERROR(MAX((ABS(AV8)-ABS(AY8)),0),\"\")","v":""},{"$f":"IFERROR(BC8/POWER(1+($C$11+1%)/$E$19,AO8-1)/(1+($C$11+1%)/365*($AP$7-$C$26)),\"\")","v":""},""]
[null,"Hitel devizaneme","HUF",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(250000-C42-C47-C54,2000000-C42-C43-C44-C47-C48-C49-C53-C54-C55,300000-C42-C43-C47-C48-C54-C55)<=0,\"Nincs szabad keret, nem finanszírozható\",MIN(250000-C42-C47-C54,2000000-C42-C43-C44-C47-C48-C49-C53-C54-C55,300000-C42-C43-C47-C48-C54-C55)))","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,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,3,{"$f":"IF(COUNT(AP9)=1,AO8+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP8,X$7:X$134,\"<=\"&AP9),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ9)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",{"$f":"+IF(COUNT(AT8)<>0,SUM(AT8:AU8)*(1-M9),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP8,X$7:X$134,\"<=\"&AP9),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT9)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP8,X$7:X$134,\"<=\"&AP9),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW9)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"HUF/EUR árfolyam",null,null,{"$f":"+C17/E19","v":5.0000000000000001E-4},null,null,"Halászati szabály",null,null,{"$f":"IF(halaszatikizarok=0,\"Nem releváns\",IF(MIN(300000-C43-C48-C55,2000000-C42-C43-C44-C47-C48-C49-C53-C54-C55,300000-C42-C43-C47-C48-C54-C55)<=0,\"Nincs szabad keret, nem finanszírozható\",MIN(300000-C43-C48-C55,2000000-C42-C43-C44-C47-C48-C49-C53-C54-C55,300000-C42-C43-C47-C48-C54-C55)))","v":"Nem releváns"},null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,4,{"$f":"IF(COUNT(AP10)=1,AO9+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP9,X$7:X$134,\"<=\"&AP10),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ10)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP9,X$7:X$134,\"<=\"&AP10),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT10)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP9,X$7:X$134,\"<=\"&AP10),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW10)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",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-C47-C48-C49-C53-C54-C55-C58-C59-C60<=0,\"Nincs szabad keret, nem finanszírozható\",2300000-C47-C48-C49-C53-C54-C55-C58-C59-C60)","v":2300000},null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,5,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP10,X$7:X$134,\"<=\"&AP11),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ11)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP10,X$7:X$134,\"<=\"&AP11),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT11)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP10,X$7:X$134,\"<=\"&AP11),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW11)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"Van hitelfelvevői múltja vagy mérleg alapú hitelminősítése a hitelfelvevőnek?","Van",null,1E-4,null,null,"Mezőgazdasági szabály",null,null,{"$f":"IF(mezogazdkizarok=0,\"Nem releváns\",IF(MIN(290000-C47-C54-C58,2300000-C47-C48-C49-C53-C54-C55-C58-C59-C60,345000-C47-C48-C54-C55-C58-C59)<=0,\"Nincs szabad keret, nem finanszírozható\",MIN(290000-C47-C54-C58,2300000-C47-C48-C49-C53-C54-C55-C58-C59-C60,345000-C47-C48-C54-C55-C58-C59)))","v":"Nem releváns"},null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,6,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP11,X$7:X$134,\"<=\"&AP12),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ12)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP11,X$7:X$134,\"<=\"&AP12),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT12)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP11,X$7:X$134,\"<=\"&AP12),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW12)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",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-C48-C55-C59,2300000-C47-C48-C49-C53-C54-C55-C58-C59-C60,345000-C47-C48-C54-C55-C58-C59)<=0,\"Nincs szabad keret, nem finanszírozható\",MIN(345000-C48-C55-C59,2300000-C47-C48-C49-C53-C54-C55-C58-C59-C60,345000-C47-C48-C54-C55-C58-C59)))","v":"Nem releváns"},null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,7,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP12,X$7:X$134,\"<=\"&AP13),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ13)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP12,X$7:X$134,\"<=\"&AP13),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT13)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP12,X$7:X$134,\"<=\"&AP13),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW13)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"Adósminősítés","Kiváló",null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,8,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP13,X$7:X$134,\"<=\"&AP14),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ14)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP13,X$7:X$134,\"<=\"&AP14),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT14)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP13,X$7:X$134,\"<=\"&AP14),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW14)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"Fedezettség","Magas",null,{"$f":"COUNT(AO7:AO134)","v":0},null,"Teljes(kumulált) támogatás intenzítása",null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,9,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP14,X$7:X$134,\"<=\"&AP15),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ15)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP14,X$7:X$134,\"<=\"&AP15),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT15)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP14,X$7:X$134,\"<=\"&AP15),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW15)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",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":60},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,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,10,{"$f":"IF(COUNT(AP16)=1,AO15+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP15,X$7:X$134,\"<=\"&AP16),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ16)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP15,X$7:X$134,\"<=\"&AP16),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT16)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP15,X$7:X$134,\"<=\"&AP16),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW16)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"Egyéni referencia kamatláb",{"$f":"+(C11+C16/10000)","v":6.0000000000000001E-3},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,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,11,{"$f":"IF(COUNT(AP17)=1,AO16+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP16,X$7:X$134,\"<=\"&AP17),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ17)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP16,X$7:X$134,\"<=\"&AP17),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT17)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP16,X$7:X$134,\"<=\"&AP17),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW17)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",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(C37=\"Egyéb támogatások: pl. Egyéb GBER (pl. 38, 41, stb), EMVA\",SUM(D47:D55)+C70,IF(C37=\"GBER 14, 17-es jogcímek\",SUM(D47:D55)+D63+D65,SUM(D47:D55)))","v":0},null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,12,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP17,X$7:X$134,\"<=\"&AP18),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ18)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP17,X$7:X$134,\"<=\"&AP18),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT18)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP17,X$7:X$134,\"<=\"&AP18),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW18)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"HITELKARAKTERISZTIKA",null,null,{"$f":"VLOOKUP($C$34,Adatok!P3:Q5,2,0)","v":12},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,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,13,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP18,X$7:X$134,\"<=\"&AP19),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ19)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP18,X$7:X$134,\"<=\"&AP19),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT19)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP18,X$7:X$134,\"<=\"&AP19),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW19)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"Hitel fajtája/célja","Beruházási hitel",null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,14,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP19,X$7:X$134,\"<=\"&AP20),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ20)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP19,X$7:X$134,\"<=\"&AP20),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT20)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP19,X$7:X$134,\"<=\"&AP20),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW20)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"Vállalat mérete","Közepes",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,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,15,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP20,X$7:X$134,\"<=\"&AP21),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ21)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP20,X$7:X$134,\"<=\"&AP21),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT21)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP20,X$7:X$134,\"<=\"&AP21),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW21)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",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) ","Egyéb",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,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,16,{"$f":"IF(COUNT(AP22)=1,AO21+1,\"\")","v":""},"",{"$f":"+IF(COUNT(AQ21)<>0,SUM(AQ21:AR21)*(1-M22),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP21,X$7:X$134,\"<=\"&AP22),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ22)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",{"$f":"+IF(COUNT(AT21)<>0,SUM(AT21:AU21)*(1-M22),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP21,X$7:X$134,\"<=\"&AP22),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT22)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",{"$f":"+IF(COUNT(AW21)<>0,SUM(AW21:AX21)*(1-M22),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP21,X$7:X$134,\"<=\"&AP22),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW22)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",{"$f":"IFERROR(AP22-AP21,\"\")","v":""}]
[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 (HUF)"},0,null,null,null,"Maximális támogatásintenzitás (%)",{"$f":"IF(tizennegyeskizarok=0,\"Nem jogosult\",IF(ttmax14es=0,0,(H25+C63+C53)/eurelszamolhato))","v":{"$error":"#DIV/0!"}},{"$f":"IF(tizenheteskizarok=0,\"Nem jogosult\",IF(ttmax17es=0,0,(I25+C65+C53)/(eurelszamolhato)))","v":{"$error":"#DIV/0!"}},null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,17,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP22,X$7:X$134,\"<=\"&AP23),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ23)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP22,X$7:X$134,\"<=\"&AP23),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT23)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP22,X$7:X$134,\"<=\"&AP23),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW23)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,{"$f":"\"Hitelösszeg (\"&C9&\")\"","v":"Hitelösszeg (HUF)"},0,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,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,18,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP23,X$7:X$134,\"<=\"&AP24),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ24)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP23,X$7:X$134,\"<=\"&AP24),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT24)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP23,X$7:X$134,\"<=\"&AP24),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW24)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",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)"},96,null,96,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)-C63-C53),0),Szamitasok!B17))","v":{"$error":"#DIV/0!"}},{"$f":"IF(tizenheteskizarok=0,\"Nem jogosult\",MAX(MIN(((((eurelszamolhato)*vallmeret)-C65-C53)),7.5*1000000),0))","v":{"$error":"#DIV/0!"}},null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,19,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP24,X$7:X$134,\"<=\"&AP25),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ25)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP24,X$7:X$134,\"<=\"&AP25),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT25)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP24,X$7:X$134,\"<=\"&AP25),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW25)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",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,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,20,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP25,X$7:X$134,\"<=\"&AP26),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ26)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP25,X$7:X$134,\"<=\"&AP26),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT26)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP25,X$7:X$134,\"<=\"&AP26),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW26)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,{"$f":"\"Szerződéskötés várható dátuma\"&IF(C27>DATE(2023,12,31),\" - Nem lehet későbbi, mint 2023.12.31!\",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,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,21,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP26,X$7:X$134,\"<=\"&AP27),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ27)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP26,X$7:X$134,\"<=\"&AP27),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT27)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP26,X$7:X$134,\"<=\"&AP27),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW27)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,{"$f":"\"Első törlesztés várható dátuma\"&IF(C28>EDATE(C27,24),\" - A türelmi idő max. 24 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,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,22,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP27,X$7:X$134,\"<=\"&AP28),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ28)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP27,X$7:X$134,\"<=\"&AP28),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT28)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP27,X$7:X$134,\"<=\"&AP28),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW28)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",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(C20=\"Beruházási hitel\",Adatok!J14,Adatok!K14)","v":3.5000000000000003E-2},null,"Maximális támogatásintenzitás (%)",{"$f":"C71","v":0},null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,23,{"$f":"IF(COUNT(AP29)=1,AO28+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP28,X$7:X$134,\"<=\"&AP29),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ29)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP28,X$7:X$134,\"<=\"&AP29),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT29)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP28,X$7:X$134,\"<=\"&AP29),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW29)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,{"$f":"\"Tényleges ügyleti kamat\"&IF(OR(tenylegeskamat<E29,tenylegeskamat>E30),\" - Nem megfelelő kamatérték!\",\"\")","v":"Tényleges ügyleti kamat"},0.06,null,{"$f":"IF(C20=\"Beruházási hitel\",Adatok!J15,Adatok!K15)","v":0.06},null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,24,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP29,X$7:X$134,\"<=\"&AP30),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ30)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP29,X$7:X$134,\"<=\"&AP30),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT30)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP29,X$7:X$134,\"<=\"&AP30),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW30)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"Minimum kamat 2.3 alapján",{"$f":"IF(C9=\"EUR\",OFFSET(Adatok!$I$18,MATCH(C21,Adatok!$I$19:$I$21,0),MATCH(C25,Adatok!$J$18:$P$18,1),),OFFSET(Adatok!$I$22,MATCH(C21,Adatok!$I$19:$I$21,0),MATCH(C25,Adatok!$J$18:$P$18,1),))","v":0.13289999999999999},null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,25,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP30,X$7:X$134,\"<=\"&AP31),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ31)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP30,X$7:X$134,\"<=\"&AP31),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT31)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP30,X$7:X$134,\"<=\"&AP31),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW31)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"Támogatás jogalapja",{"$f":"IF(tenylegeskamat>=minkamat23,\"2.3 szerinti\",\"2.1 és 2.3 szerinti\")","v":"2.1 és 2.3 szerinti"},null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,26,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP31,X$7:X$134,\"<=\"&AP32),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ32)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP31,X$7:X$134,\"<=\"&AP32),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT32)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP31,X$7:X$134,\"<=\"&AP32),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW32)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"Törlesztés módja","Egyenlő tőke",null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,27,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP32,X$7:X$134,\"<=\"&AP33),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ33)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP32,X$7:X$134,\"<=\"&AP33),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT33)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP32,X$7:X$134,\"<=\"&AP33),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW33)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,{"$f":"IF(torlesztes=\"Egyenlő tőke\",\"Kamatfizetés/tőketörlesztés gyakorisága\",\"Kamatfizetés gyakorisága\")","v":"Kamatfizetés/tőketörlesztés gyakorisága"},"Havi",null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,28,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP33,X$7:X$134,\"<=\"&AP34),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ34)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP33,X$7:X$134,\"<=\"&AP34),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT34)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP33,X$7:X$134,\"<=\"&AP34),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW34)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",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?","Igen",null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,29,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP34,X$7:X$134,\"<=\"&AP35),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ35)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP34,X$7:X$134,\"<=\"&AP35),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT35)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP34,X$7:X$134,\"<=\"&AP35),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW35)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,30,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP35,X$7:X$134,\"<=\"&AP36),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ36)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP35,X$7:X$134,\"<=\"&AP36),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT36)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP35,X$7:X$134,\"<=\"&AP36),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW36)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"ÁCSR/Agrár/Halászati csoportmentességi támogatásokhoz  kapcsolódó azonos elszámolható költségekhez megítélt állami támogatások","Nem kapcsolódik",null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,31,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP36,X$7:X$134,\"<=\"&AP37),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ37)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP36,X$7:X$134,\"<=\"&AP37),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT37)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP36,X$7:X$134,\"<=\"&AP37),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW37)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,32,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP37,X$7:X$134,\"<=\"&AP38),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ38)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP37,X$7:X$134,\"<=\"&AP38),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT38)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP37,X$7:X$134,\"<=\"&AP38),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW38)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"Beruházás helyszíne ","Közép-Dunántúl",null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"",{"$f":"IFERROR(-AA39*minkamat23/365*(X39-Z39),\"\")","v":""},"","","00:00:00",0,0,0,{"$f":"IFERROR(-(AH39-AG39)*minkamat23/365*(AP39-AF39),0)","v":0},0,"",null,33,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP38,X$7:X$134,\"<=\"&AP39),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ39)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP38,X$7:X$134,\"<=\"&AP39),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT39)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP38,X$7:X$134,\"<=\"&AP39),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW39)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,34,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP39,X$7:X$134,\"<=\"&AP40),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ40)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP39,X$7:X$134,\"<=\"&AP40),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT40)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP39,X$7:X$134,\"<=\"&AP40),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW40)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"Nem azonos elszámolható költségekre megítélt Válságkezelési Közlemény 2.1 szerinti állami támogatások",null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,35,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP40,X$7:X$134,\"<=\"&AP41),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ41)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP40,X$7:X$134,\"<=\"&AP41),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT41)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP40,X$7:X$134,\"<=\"&AP41),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW41)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"Mezőgazdasági ágazatra megítélt támogatás teljes összege (EUR):",0,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,36,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP41,X$7:X$134,\"<=\"&AP42),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ42)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP41,X$7:X$134,\"<=\"&AP42),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT42)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP41,X$7:X$134,\"<=\"&AP42),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW42)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"Halászati, akvakultúra ágazatra  megítélt támogatás teljes összeg (EUR):",0,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,37,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP42,X$7:X$134,\"<=\"&AP43),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ43)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP42,X$7:X$134,\"<=\"&AP43),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT43)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP42,X$7:X$134,\"<=\"&AP43),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW43)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",{"$f":"IFERROR(AP43-AP42,\"\")","v":""}]
[null,"Egyéb ágazatra megítélt támogatás tejes összege (EUR):",0,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,38,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP43,X$7:X$134,\"<=\"&AP44),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ44)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP43,X$7:X$134,\"<=\"&AP44),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT44)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP43,X$7:X$134,\"<=\"&AP44),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW44)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",{"$f":"IF(ISBLANK(O44),0,P44+R44)","v":0},0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,39,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP44,X$7:X$134,\"<=\"&AP45),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ45)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP44,X$7:X$134,\"<=\"&AP45),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT45)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP44,X$7:X$134,\"<=\"&AP45),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW45)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",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,"Azonos elszámolható költségekhez kapcsolódó mezőgazdasági ágazatra megítélt 2.1 támogatás összege",0,0]
[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,null,null,null,null,null,null,null,true,null,null,null,{"$f":"IF(ISBLANK(O45),\"\",O45)","v":""},{"$f":"IF(ISBLANK(O45),0,P45+R45)","v":0},{"$f":"IF(AND(ISBLANK(O45),AN48<>1),0,IFERROR(-R48*piacikamat/365*(IF(ISBLANK(O48),$C$28,O48)-Q48),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O45),AN48<>1),0,IFERROR(-R48*minkamat23/365*(IF(ISBLANK(O48),$C$28,O48)-Q48),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O45),AN48<>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(X45,INDEX(AP$6:AP$134,MATCH(X48-1,AP$6:AP$134,1)))),\"\",MAX(X45,INDEX(AP$6:AP$134,MATCH(X48-1,AP$6:AP$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(AA45),AA45=\"\"),INDEX(AQ$7:AQ$134,MATCH(X48,AP$7:AP$134,1)),AA45-Y45),INDEX(AQ$7:AQ$134,MATCH(X48,AP$7:AP$134,1)))),\"\",MIN(IF(OR(ISBLANK(AA45),AA45=\"\"),INDEX(AQ$7:AQ$134,MATCH(X48,AP$7:AP$134,1)),AA45-Y45),INDEX(AQ$7:AQ$134,MATCH(X48,AP$7:AP$134,1))))","v":0},"","","","",{"$f":"MAX(AP45,IF(ISNA(INDEX(X$7:X$134,MATCH(AP48,X$7:X$134,1))),0,INDEX(X$7:X$134,MATCH(AP48,X$7:X$134,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(Y$7:Y$134,MATCH(AP48,X$7:X$134,1))),0,INDEX(Y$7:Y$134,MATCH(AP48,X$7:X$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(AA$7:AA$134,MATCH(AP48,X$7:X$134,1))),AQ48,INDEX(AA$7:AA$134,MATCH(AP48,X$7:X$134,1)))","v":0},0,0,0,"",null,40,{"$f":"IF(COUNT(AP48)=1,AO45+1,\"\")","v":""},{"$f":"IF(OR(AP45=$C$29,AP45=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AN48-1)*12/$E$19)<=$C$29,EDATE($C$28,(AN48-1)*12/$E$19),$C$29),\"\"))","v":""},{"$f":"+IF(COUNT(AQ45)<>0,SUM(AQ45:AR45)*(1-M48),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP45,X$7:X$134,\"<=\"&AP48),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ48)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,X$7:X$134,\">\"&AP45,X$7:X$134,\"<=\"&AP48)+AI48,IFERROR(-AQ48*piacikamat/365*(AP48-AP45),\"\"))","v":""},{"$f":"+IF(COUNT(AT45)<>0,SUM(AT45:AU45)*(1-M48),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP45,X$7:X$134,\"<=\"&AP48),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT48)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AC$7:AC$134,X$7:X$134,\">\"&AP45,X$7:X$134,\"<=\"&AP48)+AJ48,IFERROR(-AT48*minkamat23/365*(AP48-AP45),\"\"))","v":""},{"$f":"+IF(COUNT(AW45)<>0,SUM(AW45:AX45)*(1-M48),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP45,X$7:X$134,\"<=\"&AP48),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW48)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AD$7:AD$134,X$7:X$134,\">\"&AP45,X$7:X$134,\"<=\"&AP48)+AK48,IFERROR(-AW48*tenylegeskamat/365*(AP48-AP45),\"\"))","v":""},null,"",{"$f":"IFERROR(BA48/POWER(1+($C$11+1%)/$E$19,AO48-1)/(1+($C$11+1%)/365*($AP$7-$C$26)),\"\")","v":""},"",{"$f":"IFERROR(BC48/POWER(1+($C$11+1%)/$E$19,AO48-1)/(1+($C$11+1%)/365*($AP$7-$C$26)),\"\")","v":""},{"$f":"IFERROR(AP48-AP45,\"\")","v":""}]
[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,"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,null,null,null,null,null,null,null,true,null,null,null,{"$f":"IF(ISBLANK(O48),\"\",O48)","v":""},{"$f":"IF(ISBLANK(O48),0,P48+R48)","v":0},{"$f":"IF(AND(ISBLANK(O48),AN51<>1),0,IFERROR(-R51*piacikamat/365*(IF(ISBLANK(O51),$C$28,O51)-Q51),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O48),AN51<>1),0,IFERROR(-R51*minkamat23/365*(IF(ISBLANK(O51),$C$28,O51)-Q51),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O48),AN51<>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(X48,INDEX(AP$6:AP$134,MATCH(X51-1,AP$6:AP$134,1)))),\"\",MAX(X48,INDEX(AP$6:AP$134,MATCH(X51-1,AP$6:AP$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(AA48),AA48=\"\"),INDEX(AQ$7:AQ$134,MATCH(X51,AP$7:AP$134,1)),AA48-Y48),INDEX(AQ$7:AQ$134,MATCH(X51,AP$7:AP$134,1)))),\"\",MIN(IF(OR(ISBLANK(AA48),AA48=\"\"),INDEX(AQ$7:AQ$134,MATCH(X51,AP$7:AP$134,1)),AA48-Y48),INDEX(AQ$7:AQ$134,MATCH(X51,AP$7:AP$134,1))))","v":0},{"$f":"IFERROR(-AA51*piacikamat/365*(X51-Z51),\"\")","v":""},"",{"$f":"IFERROR(-AA51*tenylegeskamat/365*(X51-Z51),\"\")","v":""},"",{"$f":"MAX(AP48,IF(ISNA(INDEX(X$7:X$134,MATCH(AP51,X$7:X$134,1))),0,INDEX(X$7:X$134,MATCH(AP51,X$7:X$134,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(Y$7:Y$134,MATCH(AP51,X$7:X$134,1))),0,INDEX(Y$7:Y$134,MATCH(AP51,X$7:X$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(AA$7:AA$134,MATCH(AP51,X$7:X$134,1))),AQ51,INDEX(AA$7:AA$134,MATCH(AP51,X$7:X$134,1)))","v":0},{"$f":"IFERROR(-(AH51-AG51)*piacikamat/365*(AP51-AF51),0)","v":0},0,{"$f":"IFERROR(-(AH51-AG51)*tenylegeskamat/365*(AP51-AF51),0)","v":0},{"$f":"IFERROR(AP51-AF51,\"\")","v":""},null,41,{"$f":"IF(COUNT(AP51)=1,AO48+1,\"\")","v":""},{"$f":"IF(OR(AP48=$C$29,AP48=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AN51-1)*12/$E$19)<=$C$29,EDATE($C$28,(AN51-1)*12/$E$19),$C$29),\"\"))","v":""},{"$f":"+IF(COUNT(AQ48)<>0,SUM(AQ48:AR48)*(1-M51),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP48,X$7:X$134,\"<=\"&AP51),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ51)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,X$7:X$134,\">\"&AP48,X$7:X$134,\"<=\"&AP51)+AI51,IFERROR(-AQ51*piacikamat/365*(AP51-AP48),\"\"))","v":""},{"$f":"+IF(COUNT(AT48)<>0,SUM(AT48:AU48)*(1-M51),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP48,X$7:X$134,\"<=\"&AP51),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT51)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AC$7:AC$134,X$7:X$134,\">\"&AP48,X$7:X$134,\"<=\"&AP51)+AJ51,IFERROR(-AT51*minkamat23/365*(AP51-AP48),\"\"))","v":""},{"$f":"+IF(COUNT(AW48)<>0,SUM(AW48:AX48)*(1-M51),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP48,X$7:X$134,\"<=\"&AP51),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW51)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AD$7:AD$134,X$7:X$134,\">\"&AP48,X$7:X$134,\"<=\"&AP51)+AK51,IFERROR(-AW51*tenylegeskamat/365*(AP51-AP48),\"\"))","v":""},null,{"$f":"IFERROR(MAX((ABS(AS51)-ABS(AY51)),0),\"\")","v":""},{"$f":"IFERROR(BA51/POWER(1+($C$11+1%)/$E$19,AO51-1)/(1+($C$11+1%)/365*($AP$7-$C$26)),\"\")","v":""},"",{"$f":"IFERROR(BC51/POWER(1+($C$11+1%)/$E$19,AO51-1)/(1+($C$11+1%)/365*($AP$7-$C$26)),\"\")","v":""},{"$f":"IFERROR(AP51-AP48,\"\")","v":""}]
[null,"Azonos elszámolható költségekhez kapcsolódó egyéb ágazatra megítélt 3.1 támogatás összege",0,0,null,null,null,null,null,null,null,null,true,null,null,null,"",{"$f":"IF(ISBLANK(O51),0,P51+R51)","v":0},{"$f":"IF(AND(ISBLANK(O51),AN52<>1),0,IFERROR(-R52*piacikamat/365*(IF(ISBLANK(O52),$C$28,O52)-Q52),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O51),AN52<>1),0,IFERROR(-R52*minkamat23/365*(IF(ISBLANK(O52),$C$28,O52)-Q52),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O51),AN52<>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(X51,INDEX(AP$6:AP$134,MATCH(X52-1,AP$6:AP$134,1)))),\"\",MAX(X51,INDEX(AP$6:AP$134,MATCH(X52-1,AP$6:AP$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(AA51),AA51=\"\"),INDEX(AQ$7:AQ$134,MATCH(X52,AP$7:AP$134,1)),AA51-Y51),INDEX(AQ$7:AQ$134,MATCH(X52,AP$7:AP$134,1)))),\"\",MIN(IF(OR(ISBLANK(AA51),AA51=\"\"),INDEX(AQ$7:AQ$134,MATCH(X52,AP$7:AP$134,1)),AA51-Y51),INDEX(AQ$7:AQ$134,MATCH(X52,AP$7:AP$134,1))))","v":0},"","","","",{"$f":"MAX(AP51,IF(ISNA(INDEX(X$7:X$134,MATCH(AP52,X$7:X$134,1))),0,INDEX(X$7:X$134,MATCH(AP52,X$7:X$134,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(Y$7:Y$134,MATCH(AP52,X$7:X$134,1))),0,INDEX(Y$7:Y$134,MATCH(AP52,X$7:X$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(AA$7:AA$134,MATCH(AP52,X$7:X$134,1))),AQ52,INDEX(AA$7:AA$134,MATCH(AP52,X$7:X$134,1)))","v":0},0,0,0,"",null,42,{"$f":"IF(COUNT(AP52)=1,AO51+1,\"\")","v":""},{"$f":"IF(OR(AP51=$C$29,AP51=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AN52-1)*12/$E$19)<=$C$29,EDATE($C$28,(AN52-1)*12/$E$19),$C$29),\"\"))","v":""},{"$f":"+IF(COUNT(AQ51)<>0,SUM(AQ51:AR51)*(1-M52),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP51,X$7:X$134,\"<=\"&AP52),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ52)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,X$7:X$134,\">\"&AP51,X$7:X$134,\"<=\"&AP52)+AI52,IFERROR(-AQ52*piacikamat/365*(AP52-AP51),\"\"))","v":""},0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP51,X$7:X$134,\"<=\"&AP52),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT52)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AC$7:AC$134,X$7:X$134,\">\"&AP51,X$7:X$134,\"<=\"&AP52)+AJ52,IFERROR(-AT52*minkamat23/365*(AP52-AP51),\"\"))","v":""},0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP51,X$7:X$134,\"<=\"&AP52),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW52)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AD$7:AD$134,X$7:X$134,\">\"&AP51,X$7:X$134,\"<=\"&AP52)+AK52,IFERROR(-AW52*tenylegeskamat/365*(AP52-AP51),\"\"))","v":""},null,"",{"$f":"IFERROR(BA52/POWER(1+($C$11+1%)/$E$19,AO52-1)/(1+($C$11+1%)/365*($AP$7-$C$26)),\"\")","v":""},"",{"$f":"IFERROR(BC52/POWER(1+($C$11+1%)/$E$19,AO52-1)/(1+($C$11+1%)/365*($AP$7-$C$26)),\"\")","v":""},{"$f":"IFERROR(AP52-AP51,\"\")","v":""}]
[null,{"$f":"IF(C53>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,{"$f":"IF(C54>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,{"$f":"IF(C55>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,null,null,null,null,null,null,null,true,null,null,null,{"$f":"IF(ISBLANK(O52),\"\",O52)","v":""},{"$f":"IF(ISBLANK(O52),0,P52+R52)","v":0},{"$f":"IF(AND(ISBLANK(O52),AN55<>1),0,IFERROR(-R55*piacikamat/365*(IF(ISBLANK(O55),$C$28,O55)-Q55),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O52),AN55<>1),0,IFERROR(-R55*minkamat23/365*(IF(ISBLANK(O55),$C$28,O55)-Q55),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O52),AN55<>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(X52,INDEX(AP$6:AP$134,MATCH(X55-1,AP$6:AP$134,1)))),\"\",MAX(X52,INDEX(AP$6:AP$134,MATCH(X55-1,AP$6:AP$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(AA52),AA52=\"\"),INDEX(AQ$7:AQ$134,MATCH(X55,AP$7:AP$134,1)),AA52-Y52),INDEX(AQ$7:AQ$134,MATCH(X55,AP$7:AP$134,1)))),\"\",MIN(IF(OR(ISBLANK(AA52),AA52=\"\"),INDEX(AQ$7:AQ$134,MATCH(X55,AP$7:AP$134,1)),AA52-Y52),INDEX(AQ$7:AQ$134,MATCH(X55,AP$7:AP$134,1))))","v":0},"","","","",{"$f":"MAX(AP52,IF(ISNA(INDEX(X$7:X$134,MATCH(AP55,X$7:X$134,1))),0,INDEX(X$7:X$134,MATCH(AP55,X$7:X$134,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(Y$7:Y$134,MATCH(AP55,X$7:X$134,1))),0,INDEX(Y$7:Y$134,MATCH(AP55,X$7:X$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(AA$7:AA$134,MATCH(AP55,X$7:X$134,1))),AQ55,INDEX(AA$7:AA$134,MATCH(AP55,X$7:X$134,1)))","v":0},0,0,0,"",null,43,{"$f":"IF(COUNT(AP55)=1,AO52+1,\"\")","v":""},{"$f":"IF(OR(AP52=$C$29,AP52=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AN55-1)*12/$E$19)<=$C$29,EDATE($C$28,(AN55-1)*12/$E$19),$C$29),\"\"))","v":""},{"$f":"+IF(COUNT(AQ52)<>0,SUM(AQ52:AR52)*(1-M55),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP52,X$7:X$134,\"<=\"&AP55),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ55)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,X$7:X$134,\">\"&AP52,X$7:X$134,\"<=\"&AP55)+AI55,IFERROR(-AQ55*piacikamat/365*(AP55-AP52),\"\"))","v":""},{"$f":"+IF(COUNT(AT52)<>0,SUM(AT52:AU52)*(1-M55),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP52,X$7:X$134,\"<=\"&AP55),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT55)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AC$7:AC$134,X$7:X$134,\">\"&AP52,X$7:X$134,\"<=\"&AP55)+AJ55,IFERROR(-AT55*minkamat23/365*(AP55-AP52),\"\"))","v":""},{"$f":"+IF(COUNT(AW52)<>0,SUM(AW52:AX52)*(1-M55),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP52,X$7:X$134,\"<=\"&AP55),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW55)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AD$7:AD$134,X$7:X$134,\">\"&AP52,X$7:X$134,\"<=\"&AP55)+AK55,IFERROR(-AW55*tenylegeskamat/365*(AP55-AP52),\"\"))","v":""},null,"",{"$f":"IFERROR(BA55/POWER(1+($C$11+1%)/$E$19,AO55-1)/(1+($C$11+1%)/365*($AP$7-$C$26)),\"\")","v":""},"",{"$f":"IFERROR(BC55/POWER(1+($C$11+1%)/$E$19,AO55-1)/(1+($C$11+1%)/365*($AP$7-$C$26)),\"\")","v":""},{"$f":"IFERROR(AP55-AP52,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,{"$f":"IF(ISBLANK(O55),\"\",O55)","v":""},{"$f":"IF(ISBLANK(O55),0,P55+R55)","v":0},{"$f":"IF(AND(ISBLANK(O55),AN56<>1),0,IFERROR(-R56*piacikamat/365*(IF(ISBLANK(O56),$C$28,O56)-Q56),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O55),AN56<>1),0,IFERROR(-R56*minkamat23/365*(IF(ISBLANK(O56),$C$28,O56)-Q56),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O55),AN56<>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(X55,INDEX(AP$6:AP$134,MATCH(X56-1,AP$6:AP$134,1)))),\"\",MAX(X55,INDEX(AP$6:AP$134,MATCH(X56-1,AP$6:AP$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(AA55),AA55=\"\"),INDEX(AQ$7:AQ$134,MATCH(X56,AP$7:AP$134,1)),AA55-Y55),INDEX(AQ$7:AQ$134,MATCH(X56,AP$7:AP$134,1)))),\"\",MIN(IF(OR(ISBLANK(AA55),AA55=\"\"),INDEX(AQ$7:AQ$134,MATCH(X56,AP$7:AP$134,1)),AA55-Y55),INDEX(AQ$7:AQ$134,MATCH(X56,AP$7:AP$134,1))))","v":0},"","","","",{"$f":"MAX(AP55,IF(ISNA(INDEX(X$7:X$134,MATCH(AP56,X$7:X$134,1))),0,INDEX(X$7:X$134,MATCH(AP56,X$7:X$134,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(Y$7:Y$134,MATCH(AP56,X$7:X$134,1))),0,INDEX(Y$7:Y$134,MATCH(AP56,X$7:X$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(AA$7:AA$134,MATCH(AP56,X$7:X$134,1))),AQ56,INDEX(AA$7:AA$134,MATCH(AP56,X$7:X$134,1)))","v":0},0,0,0,"",null,44,{"$f":"IF(COUNT(AP56)=1,AO55+1,\"\")","v":""},{"$f":"IF(OR(AP55=$C$29,AP55=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AN56-1)*12/$E$19)<=$C$29,EDATE($C$28,(AN56-1)*12/$E$19),$C$29),\"\"))","v":""},{"$f":"+IF(COUNT(AQ55)<>0,SUM(AQ55:AR55)*(1-M56),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP55,X$7:X$134,\"<=\"&AP56),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ56)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,X$7:X$134,\">\"&AP55,X$7:X$134,\"<=\"&AP56)+AI56,IFERROR(-AQ56*piacikamat/365*(AP56-AP55),\"\"))","v":""},{"$f":"+IF(COUNT(AT55)<>0,SUM(AT55:AU55)*(1-M56),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP55,X$7:X$134,\"<=\"&AP56),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT56)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AC$7:AC$134,X$7:X$134,\">\"&AP55,X$7:X$134,\"<=\"&AP56)+AJ56,IFERROR(-AT56*minkamat23/365*(AP56-AP55),\"\"))","v":""},{"$f":"+IF(COUNT(AW55)<>0,SUM(AW55:AX55)*(1-M56),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP55,X$7:X$134,\"<=\"&AP56),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW56)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AD$7:AD$134,X$7:X$134,\">\"&AP55,X$7:X$134,\"<=\"&AP56)+AK56,IFERROR(-AW56*tenylegeskamat/365*(AP56-AP55),\"\"))","v":""},null,"",{"$f":"IFERROR(BA56/POWER(1+($C$11+1%)/$E$19,AO56-1)/(1+($C$11+1%)/365*($AP$7-$C$26)),\"\")","v":""},"",{"$f":"IFERROR(BC56/POWER(1+($C$11+1%)/$E$19,AO56-1)/(1+($C$11+1%)/365*($AP$7-$C$26)),\"\")","v":""},{"$f":"IFERROR(AP56-AP55,\"\")","v":""}]
[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,{"$f":"IF(C58<C50,\"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,{"$f":"IF(C59<C51,\"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,null,null,null,null,null,null,null,null,true,null,null,null,{"$f":"IF(ISBLANK(O56),\"\",O56)","v":""},{"$f":"IF(ISBLANK(O56),0,P56+R56)","v":0},{"$f":"IF(AND(ISBLANK(O56),AN59<>1),0,IFERROR(-R59*piacikamat/365*(IF(ISBLANK(O59),$C$28,O59)-Q59),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O56),AN59<>1),0,IFERROR(-R59*minkamat23/365*(IF(ISBLANK(O59),$C$28,O59)-Q59),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O56),AN59<>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(X56,INDEX(AP$6:AP$134,MATCH(X59-1,AP$6:AP$134,1)))),\"\",MAX(X56,INDEX(AP$6:AP$134,MATCH(X59-1,AP$6:AP$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(AA56),AA56=\"\"),INDEX(AQ$7:AQ$134,MATCH(X59,AP$7:AP$134,1)),AA56-Y56),INDEX(AQ$7:AQ$134,MATCH(X59,AP$7:AP$134,1)))),\"\",MIN(IF(OR(ISBLANK(AA56),AA56=\"\"),INDEX(AQ$7:AQ$134,MATCH(X59,AP$7:AP$134,1)),AA56-Y56),INDEX(AQ$7:AQ$134,MATCH(X59,AP$7:AP$134,1))))","v":0},"","","","",{"$f":"MAX(AP56,IF(ISNA(INDEX(X$7:X$134,MATCH(AP59,X$7:X$134,1))),0,INDEX(X$7:X$134,MATCH(AP59,X$7:X$134,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(Y$7:Y$134,MATCH(AP59,X$7:X$134,1))),0,INDEX(Y$7:Y$134,MATCH(AP59,X$7:X$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(AA$7:AA$134,MATCH(AP59,X$7:X$134,1))),AQ59,INDEX(AA$7:AA$134,MATCH(AP59,X$7:X$134,1)))","v":0},0,0,0,"",null,45,{"$f":"IF(COUNT(AP59)=1,AO56+1,\"\")","v":""},{"$f":"IF(OR(AP56=$C$29,AP56=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AN59-1)*12/$E$19)<=$C$29,EDATE($C$28,(AN59-1)*12/$E$19),$C$29),\"\"))","v":""},{"$f":"+IF(COUNT(AQ56)<>0,SUM(AQ56:AR56)*(1-M59),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP56,X$7:X$134,\"<=\"&AP59),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ59)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,X$7:X$134,\">\"&AP56,X$7:X$134,\"<=\"&AP59)+AI59,IFERROR(-AQ59*piacikamat/365*(AP59-AP56),\"\"))","v":""},{"$f":"+IF(COUNT(AT56)<>0,SUM(AT56:AU56)*(1-M59),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP56,X$7:X$134,\"<=\"&AP59),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT59)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AC$7:AC$134,X$7:X$134,\">\"&AP56,X$7:X$134,\"<=\"&AP59)+AJ59,IFERROR(-AT59*minkamat23/365*(AP59-AP56),\"\"))","v":""},{"$f":"+IF(COUNT(AW56)<>0,SUM(AW56:AX56)*(1-M59),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP56,X$7:X$134,\"<=\"&AP59),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW59)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AD$7:AD$134,X$7:X$134,\">\"&AP56,X$7:X$134,\"<=\"&AP59)+AK59,IFERROR(-AW59*tenylegeskamat/365*(AP59-AP56),\"\"))","v":""},null,"",{"$f":"IFERROR(BA59/POWER(1+($C$11+1%)/$E$19,AO59-1)/(1+($C$11+1%)/365*($AP$7-$C$26)),\"\")","v":""},"",{"$f":"IFERROR(BC59/POWER(1+($C$11+1%)/$E$19,AO59-1)/(1+($C$11+1%)/365*($AP$7-$C$26)),\"\")","v":""},{"$f":"IFERROR(AP59-AP56,\"\")","v":""}]
[null,{"$f":"IF(C60<C52,\"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,null,null,null,null,null,null,null,true,null,null,null,"",0,{"$f":"IF(AND(ISBLANK(O59),AN60<>1),0,IFERROR(-R60*piacikamat/365*(IF(ISBLANK(O60),$C$28,O60)-Q60),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O59),AN60<>1),0,IFERROR(-R60*minkamat23/365*(IF(ISBLANK(O60),$C$28,O60)-Q60),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O59),AN60<>1),0,IFERROR(-R60*tenylegeskamat/365*(IF(ISBLANK(O60),$C$28,O60)-Q60),\"\"))","v":0},"",null,null,null,{"$f":"IF(ISNA(MAX(X59,INDEX(AP$6:AP$134,MATCH(X60-1,AP$6:AP$134,1)))),\"\",MAX(X59,INDEX(AP$6:AP$134,MATCH(X60-1,AP$6:AP$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(AA59),AA59=\"\"),INDEX(AQ$7:AQ$134,MATCH(X60,AP$7:AP$134,1)),AA59-Y59),INDEX(AQ$7:AQ$134,MATCH(X60,AP$7:AP$134,1)))),\"\",MIN(IF(OR(ISBLANK(AA59),AA59=\"\"),INDEX(AQ$7:AQ$134,MATCH(X60,AP$7:AP$134,1)),AA59-Y59),INDEX(AQ$7:AQ$134,MATCH(X60,AP$7:AP$134,1))))","v":0},"","","","",{"$f":"MAX(AP59,IF(ISNA(INDEX(X$7:X$134,MATCH(AP60,X$7:X$134,1))),0,INDEX(X$7:X$134,MATCH(AP60,X$7:X$134,1))))","v":"00:00:00"},0,0,0,0,0,"",null,46,"",{"$f":"IF(OR(AP59=$C$29,AP59=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AN60-1)*12/$E$19)<=$C$29,EDATE($C$28,(AN60-1)*12/$E$19),$C$29),\"\"))","v":""},0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP59,X$7:X$134,\"<=\"&AP60),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ60)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,X$7:X$134,\">\"&AP59,X$7:X$134,\"<=\"&AP60)+AI60,IFERROR(-AQ60*piacikamat/365*(AP60-AP59),\"\"))","v":""},0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP59,X$7:X$134,\"<=\"&AP60),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT60)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AC$7:AC$134,X$7:X$134,\">\"&AP59,X$7:X$134,\"<=\"&AP60)+AJ60,IFERROR(-AT60*minkamat23/365*(AP60-AP59),\"\"))","v":""},0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP59,X$7:X$134,\"<=\"&AP60),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW60)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AD$7:AD$134,X$7:X$134,\">\"&AP59,X$7:X$134,\"<=\"&AP60)+AK60,IFERROR(-AW60*tenylegeskamat/365*(AP60-AP59),\"\"))","v":""},null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,47,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP60,X$7:X$134,\"<=\"&AP61),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ61)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP60,X$7:X$134,\"<=\"&AP61),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT61)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP60,X$7:X$134,\"<=\"&AP61),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW61)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"Azonos megyében folytatott működés során megítélt regionális beruházási támogatások","EUR","HUF",null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,48,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP61,X$7:X$134,\"<=\"&AP62),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ62)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP61,X$7:X$134,\"<=\"&AP62),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT62)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP61,X$7:X$134,\"<=\"&AP62),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW62)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"Regionális alapon megítélt beruházási támogatások teljes összege (14. cikk), az azonos tevékenységre, azonos megyében",0,0,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,49,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP62,X$7:X$134,\"<=\"&AP63),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ63)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP62,X$7:X$134,\"<=\"&AP63),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT63)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP62,X$7:X$134,\"<=\"&AP63),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW63)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",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,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,50,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP63,X$7:X$134,\"<=\"&AP64),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ64)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP63,X$7:X$134,\"<=\"&AP64),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT64)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP63,X$7:X$134,\"<=\"&AP64),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW64)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",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,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,51,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP64,X$7:X$134,\"<=\"&AP65),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ65)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP64,X$7:X$134,\"<=\"&AP65),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT65)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP64,X$7:X$134,\"<=\"&AP65),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW65)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,52,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP65,X$7:X$134,\"<=\"&AP66),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ66)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP65,X$7:X$134,\"<=\"&AP66),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT66)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP65,X$7:X$134,\"<=\"&AP66),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW66)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",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,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,53,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP66,X$7:X$134,\"<=\"&AP67),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ67)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP66,X$7:X$134,\"<=\"&AP67),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT67)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP66,X$7:X$134,\"<=\"&AP67),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW67)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"Korábban megítélt állami támogatások rendeleti alapja","EGYÉB",null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,54,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP67,X$7:X$134,\"<=\"&AP68),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ68)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP67,X$7:X$134,\"<=\"&AP68),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT68)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP67,X$7:X$134,\"<=\"&AP68),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW68)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",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,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,55,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP68,X$7:X$134,\"<=\"&AP69),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ69)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP68,X$7:X$134,\"<=\"&AP69),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT69)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP68,X$7:X$134,\"<=\"&AP69),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW69)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",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,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,56,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP69,X$7:X$134,\"<=\"&AP70),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ70)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP69,X$7:X$134,\"<=\"&AP70),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT70)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP69,X$7:X$134,\"<=\"&AP70),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW70)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,"Korábban megítélt egyéb támogatás keretében adható max. támogatás intenzitás mértéke",0,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,57,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP70,X$7:X$134,\"<=\"&AP71),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ71)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP70,X$7:X$134,\"<=\"&AP71),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT71)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP70,X$7:X$134,\"<=\"&AP71),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW71)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,58,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP71,X$7:X$134,\"<=\"&AP72),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ72)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP71,X$7:X$134,\"<=\"&AP72),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT72)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP71,X$7:X$134,\"<=\"&AP72),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW72)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,59,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP72,X$7:X$134,\"<=\"&AP73),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ73)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP72,X$7:X$134,\"<=\"&AP73),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT73)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP72,X$7:X$134,\"<=\"&AP73),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW73)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,60,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP73,X$7:X$134,\"<=\"&AP74),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ74)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP73,X$7:X$134,\"<=\"&AP74),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT74)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP73,X$7:X$134,\"<=\"&AP74),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW74)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,61,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP74,X$7:X$134,\"<=\"&AP75),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ75)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP74,X$7:X$134,\"<=\"&AP75),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT75)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP74,X$7:X$134,\"<=\"&AP75),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW75)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,62,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP75,X$7:X$134,\"<=\"&AP76),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ76)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP75,X$7:X$134,\"<=\"&AP76),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT76)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP75,X$7:X$134,\"<=\"&AP76),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW76)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,63,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP76,X$7:X$134,\"<=\"&AP77),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ77)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP76,X$7:X$134,\"<=\"&AP77),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT77)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP76,X$7:X$134,\"<=\"&AP77),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW77)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,64,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP77,X$7:X$134,\"<=\"&AP78),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ78)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP77,X$7:X$134,\"<=\"&AP78),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT78)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP77,X$7:X$134,\"<=\"&AP78),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW78)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"",{"$f":"IFERROR(-AA79*minkamat23/365*(X79-Z79),\"\")","v":""},"",{"$f":"IFERROR(X79-Z79,\"\")","v":""},"00:00:00",0,0,0,{"$f":"IFERROR(-(AH79-AG79)*minkamat23/365*(AP79-AF79),0)","v":0},0,"",null,65,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP78,X$7:X$134,\"<=\"&AP79),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ79)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP78,X$7:X$134,\"<=\"&AP79),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT79)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP78,X$7:X$134,\"<=\"&AP79),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW79)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AO80>$E$15","v":true},null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,66,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP79,X$7:X$134,\"<=\"&AP80),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ80)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP79,X$7:X$134,\"<=\"&AP80),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT80)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",{"$f":"+IF(COUNT(AW79)<>0,SUM(AW79:AX79)*(1-M80),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP79,X$7:X$134,\"<=\"&AP80),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW80)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","",{"$f":"IFERROR(MAX((ABS(AV80)-ABS(AY80)),0),\"\")","v":""},"",""]
[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,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,67,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP80,X$7:X$134,\"<=\"&AP81),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ81)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",{"$f":"+IF(COUNT(AT80)<>0,SUM(AT80:AU80)*(1-M81),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP80,X$7:X$134,\"<=\"&AP81),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT81)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP80,X$7:X$134,\"<=\"&AP81),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW81)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,68,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP81,X$7:X$134,\"<=\"&AP82),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ82)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP81,X$7:X$134,\"<=\"&AP82),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT82)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP81,X$7:X$134,\"<=\"&AP82),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW82)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,69,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP82,X$7:X$134,\"<=\"&AP83),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ83)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP82,X$7:X$134,\"<=\"&AP83),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT83)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP82,X$7:X$134,\"<=\"&AP83),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW83)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,70,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP83,X$7:X$134,\"<=\"&AP84),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ84)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP83,X$7:X$134,\"<=\"&AP84),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT84)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP83,X$7:X$134,\"<=\"&AP84),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW84)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,71,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP84,X$7:X$134,\"<=\"&AP85),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ85)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP84,X$7:X$134,\"<=\"&AP85),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT85)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP84,X$7:X$134,\"<=\"&AP85),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW85)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,72,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP85,X$7:X$134,\"<=\"&AP86),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ86)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP85,X$7:X$134,\"<=\"&AP86),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT86)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP85,X$7:X$134,\"<=\"&AP86),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW86)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,73,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP86,X$7:X$134,\"<=\"&AP87),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ87)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP86,X$7:X$134,\"<=\"&AP87),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT87)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP86,X$7:X$134,\"<=\"&AP87),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW87)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,74,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP87,X$7:X$134,\"<=\"&AP88),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ88)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP87,X$7:X$134,\"<=\"&AP88),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT88)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP87,X$7:X$134,\"<=\"&AP88),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW88)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,75,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP88,X$7:X$134,\"<=\"&AP89),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ89)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP88,X$7:X$134,\"<=\"&AP89),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT89)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP88,X$7:X$134,\"<=\"&AP89),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW89)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,76,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP89,X$7:X$134,\"<=\"&AP90),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ90)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP89,X$7:X$134,\"<=\"&AP90),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT90)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP89,X$7:X$134,\"<=\"&AP90),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW90)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,{"$f":"IFERROR(IF(ISBLANK(O91),$C$28,O91)-Q91,\"\")","v":""},null,null,null,"",0,"","","","","00:00:00",{"$f":"IF(ISNA(INDEX(Y$7:Y$134,MATCH(AP91,X$7:X$134,1))),0,INDEX(Y$7:Y$134,MATCH(AP91,X$7:X$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(AA$7:AA$134,MATCH(AP91,X$7:X$134,1))),AQ91,INDEX(AA$7:AA$134,MATCH(AP91,X$7:X$134,1)))","v":0},0,0,0,"",null,77,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP90,X$7:X$134,\"<=\"&AP91),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ91)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP90,X$7:X$134,\"<=\"&AP91),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT91)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP90,X$7:X$134,\"<=\"&AP91),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW91)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"",{"$f":"IFERROR(BA91/POWER(1+($C$11+1%)/$E$19,AO91-1)/(1+($C$11+1%)/365*($AP$7-$C$26)),\"\")","v":""},"",{"$f":"IFERROR(BC91/POWER(1+($C$11+1%)/$E$19,AO91-1)/(1+($C$11+1%)/365*($AP$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),AN92<>1),0,IFERROR(-R92*piacikamat/365*(IF(ISBLANK(O92),$C$28,O92)-Q92),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O91),AN92<>1),0,IFERROR(-R92*minkamat23/365*(IF(ISBLANK(O92),$C$28,O92)-Q92),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O91),AN92<>1),0,IFERROR(-R92*tenylegeskamat/365*(IF(ISBLANK(O92),$C$28,O92)-Q92),\"\"))","v":0},"",null,null,null,{"$f":"IF(ISNA(MAX(X91,INDEX(AP$6:AP$134,MATCH(X92-1,AP$6:AP$134,1)))),\"\",MAX(X91,INDEX(AP$6:AP$134,MATCH(X92-1,AP$6:AP$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(AA91),AA91=\"\"),INDEX(AQ$7:AQ$134,MATCH(X92,AP$7:AP$134,1)),AA91-Y91),INDEX(AQ$7:AQ$134,MATCH(X92,AP$7:AP$134,1)))),\"\",MIN(IF(OR(ISBLANK(AA91),AA91=\"\"),INDEX(AQ$7:AQ$134,MATCH(X92,AP$7:AP$134,1)),AA91-Y91),INDEX(AQ$7:AQ$134,MATCH(X92,AP$7:AP$134,1))))","v":0},"","","","",{"$f":"MAX(AP91,IF(ISNA(INDEX(X$7:X$134,MATCH(AP92,X$7:X$134,1))),0,INDEX(X$7:X$134,MATCH(AP92,X$7:X$134,1))))","v":"00:00:00"},0,0,0,0,0,"",null,78,"",{"$f":"IF(OR(AP91=$C$29,AP91=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AN92-1)*12/$E$19)<=$C$29,EDATE($C$28,(AN92-1)*12/$E$19),$C$29),\"\"))","v":""},0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP91,X$7:X$134,\"<=\"&AP92),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ92)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,X$7:X$134,\">\"&AP91,X$7:X$134,\"<=\"&AP92)+AI92,IFERROR(-AQ92*piacikamat/365*(AP92-AP91),\"\"))","v":""},0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP91,X$7:X$134,\"<=\"&AP92),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT92)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AC$7:AC$134,X$7:X$134,\">\"&AP91,X$7:X$134,\"<=\"&AP92)+AJ92,IFERROR(-AT92*minkamat23/365*(AP92-AP91),\"\"))","v":""},0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP91,X$7:X$134,\"<=\"&AP92),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW92)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AD$7:AD$134,X$7:X$134,\">\"&AP91,X$7:X$134,\"<=\"&AP92)+AK92,IFERROR(-AW92*tenylegeskamat/365*(AP92-AP91),\"\"))","v":""},null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,79,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP92,X$7:X$134,\"<=\"&AP93),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ93)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP92,X$7:X$134,\"<=\"&AP93),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT93)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP92,X$7:X$134,\"<=\"&AP93),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW93)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,80,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP93,X$7:X$134,\"<=\"&AP94),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ94)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP93,X$7:X$134,\"<=\"&AP94),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT94)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP93,X$7:X$134,\"<=\"&AP94),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW94)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,81,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP94,X$7:X$134,\"<=\"&AP95),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ95)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP94,X$7:X$134,\"<=\"&AP95),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT95)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP94,X$7:X$134,\"<=\"&AP95),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW95)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,82,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP95,X$7:X$134,\"<=\"&AP96),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ96)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP95,X$7:X$134,\"<=\"&AP96),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT96)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP95,X$7:X$134,\"<=\"&AP96),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW96)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,83,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP96,X$7:X$134,\"<=\"&AP97),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ97)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP96,X$7:X$134,\"<=\"&AP97),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT97)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP96,X$7:X$134,\"<=\"&AP97),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW97)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,84,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP97,X$7:X$134,\"<=\"&AP98),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ98)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP97,X$7:X$134,\"<=\"&AP98),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT98)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP97,X$7:X$134,\"<=\"&AP98),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW98)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,85,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP98,X$7:X$134,\"<=\"&AP99),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ99)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP98,X$7:X$134,\"<=\"&AP99),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT99)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP98,X$7:X$134,\"<=\"&AP99),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW99)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,86,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP99,X$7:X$134,\"<=\"&AP100),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ100)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP99,X$7:X$134,\"<=\"&AP100),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT100)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP99,X$7:X$134,\"<=\"&AP100),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW100)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,87,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP100,X$7:X$134,\"<=\"&AP101),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ101)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP100,X$7:X$134,\"<=\"&AP101),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT101)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP100,X$7:X$134,\"<=\"&AP101),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW101)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,88,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP101,X$7:X$134,\"<=\"&AP102),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ102)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP101,X$7:X$134,\"<=\"&AP102),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT102)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP101,X$7:X$134,\"<=\"&AP102),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW102)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,89,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP102,X$7:X$134,\"<=\"&AP103),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ103)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP102,X$7:X$134,\"<=\"&AP103),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT103)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP102,X$7:X$134,\"<=\"&AP103),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW103)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,90,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP103,X$7:X$134,\"<=\"&AP104),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ104)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP103,X$7:X$134,\"<=\"&AP104),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT104)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP103,X$7:X$134,\"<=\"&AP104),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW104)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,91,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP104,X$7:X$134,\"<=\"&AP105),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ105)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP104,X$7:X$134,\"<=\"&AP105),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT105)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP104,X$7:X$134,\"<=\"&AP105),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW105)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,92,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP105,X$7:X$134,\"<=\"&AP106),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ106)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP105,X$7:X$134,\"<=\"&AP106),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT106)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP105,X$7:X$134,\"<=\"&AP106),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW106)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,93,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP106,X$7:X$134,\"<=\"&AP107),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ107)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP106,X$7:X$134,\"<=\"&AP107),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT107)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP106,X$7:X$134,\"<=\"&AP107),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW107)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,94,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP107,X$7:X$134,\"<=\"&AP108),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ108)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP107,X$7:X$134,\"<=\"&AP108),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT108)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP107,X$7:X$134,\"<=\"&AP108),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW108)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,95,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP108,X$7:X$134,\"<=\"&AP109),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ109)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP108,X$7:X$134,\"<=\"&AP109),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT109)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP108,X$7:X$134,\"<=\"&AP109),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW109)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,96,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP109,X$7:X$134,\"<=\"&AP110),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ110)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP109,X$7:X$134,\"<=\"&AP110),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT110)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP109,X$7:X$134,\"<=\"&AP110),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW110)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"",{"$f":"IFERROR(-AA111*minkamat23/365*(X111-Z111),\"\")","v":""},"","","00:00:00",0,0,0,{"$f":"IFERROR(-(AH111-AG111)*minkamat23/365*(AP111-AF111),0)","v":0},0,"",null,97,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP110,X$7:X$134,\"<=\"&AP111),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ111)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP110,X$7:X$134,\"<=\"&AP111),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT111)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP110,X$7:X$134,\"<=\"&AP111),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW111)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,98,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP111,X$7:X$134,\"<=\"&AP112),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ112)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP111,X$7:X$134,\"<=\"&AP112),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT112)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP111,X$7:X$134,\"<=\"&AP112),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW112)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,99,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP112,X$7:X$134,\"<=\"&AP113),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ113)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP112,X$7:X$134,\"<=\"&AP113),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT113)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP112,X$7:X$134,\"<=\"&AP113),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW113)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,100,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP113,X$7:X$134,\"<=\"&AP114),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ114)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP113,X$7:X$134,\"<=\"&AP114),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT114)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP113,X$7:X$134,\"<=\"&AP114),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW114)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,101,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP114,X$7:X$134,\"<=\"&AP115),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ115)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP114,X$7:X$134,\"<=\"&AP115),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT115)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP114,X$7:X$134,\"<=\"&AP115),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW115)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,102,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP115,X$7:X$134,\"<=\"&AP116),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ116)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP115,X$7:X$134,\"<=\"&AP116),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT116)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP115,X$7:X$134,\"<=\"&AP116),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW116)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,103,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP116,X$7:X$134,\"<=\"&AP117),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ117)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP116,X$7:X$134,\"<=\"&AP117),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT117)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP116,X$7:X$134,\"<=\"&AP117),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW117)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,104,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP117,X$7:X$134,\"<=\"&AP118),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ118)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP117,X$7:X$134,\"<=\"&AP118),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT118)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP117,X$7:X$134,\"<=\"&AP118),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW118)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",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,0,"",null,null,null,"",0,{"$f":"IFERROR(-AA119*piacikamat/365*(X119-Z119),\"\")","v":""},"",{"$f":"IFERROR(-AA119*tenylegeskamat/365*(X119-Z119),\"\")","v":""},"","00:00:00",0,0,{"$f":"IFERROR(-(AH119-AG119)*piacikamat/365*(AP119-AF119),0)","v":0},0,{"$f":"IFERROR(-(AH119-AG119)*tenylegeskamat/365*(AP119-AF119),0)","v":0},{"$f":"IFERROR(AP119-AF119,\"\")","v":""},null,105,{"$f":"IF(COUNT(AP119)=1,AO118+1,\"\")","v":""},"",{"$f":"+IF(COUNT(AQ118)<>0,SUM(AQ118:AR118)*(1-M119),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP118,X$7:X$134,\"<=\"&AP119),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ119)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP118,X$7:X$134,\"<=\"&AP119),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT119)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP118,X$7:X$134,\"<=\"&AP119),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW119)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,{"$f":"IFERROR(MAX((ABS(AS119)-ABS(AY119)),0),\"\")","v":""},"","","",{"$f":"IFERROR(AP119-AP118,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,106,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP119,X$7:X$134,\"<=\"&AP120),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ120)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP119,X$7:X$134,\"<=\"&AP120),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT120)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP119,X$7:X$134,\"<=\"&AP120),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW120)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,107,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP120,X$7:X$134,\"<=\"&AP121),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ121)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP120,X$7:X$134,\"<=\"&AP121),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT121)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP120,X$7:X$134,\"<=\"&AP121),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW121)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,108,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP121,X$7:X$134,\"<=\"&AP122),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ122)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP121,X$7:X$134,\"<=\"&AP122),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT122)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP121,X$7:X$134,\"<=\"&AP122),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW122)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,{"$f":"IFERROR(IF(ISBLANK(O123),$C$28,O123)-Q123,\"\")","v":""},null,null,null,"",0,"","","","","00:00:00",{"$f":"IF(ISNA(INDEX(Y$7:Y$134,MATCH(AP123,X$7:X$134,1))),0,INDEX(Y$7:Y$134,MATCH(AP123,X$7:X$134,1)))","v":0},{"$f":"IF(ISNA(INDEX(AA$7:AA$134,MATCH(AP123,X$7:X$134,1))),AQ123,INDEX(AA$7:AA$134,MATCH(AP123,X$7:X$134,1)))","v":0},0,0,0,"",null,109,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP122,X$7:X$134,\"<=\"&AP123),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ123)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP122,X$7:X$134,\"<=\"&AP123),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT123)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP122,X$7:X$134,\"<=\"&AP123),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW123)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"",{"$f":"IFERROR(BA123/POWER(1+($C$11+1%)/$E$19,AO123-1)/(1+($C$11+1%)/365*($AP$7-$C$26)),\"\")","v":""},"",{"$f":"IFERROR(BC123/POWER(1+($C$11+1%)/$E$19,AO123-1)/(1+($C$11+1%)/365*($AP$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),AN124<>1),0,IFERROR(-R124*piacikamat/365*(IF(ISBLANK(O124),$C$28,O124)-Q124),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O123),AN124<>1),0,IFERROR(-R124*minkamat23/365*(IF(ISBLANK(O124),$C$28,O124)-Q124),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(O123),AN124<>1),0,IFERROR(-R124*tenylegeskamat/365*(IF(ISBLANK(O124),$C$28,O124)-Q124),\"\"))","v":0},"",null,null,null,{"$f":"IF(ISNA(MAX(X123,INDEX(AP$6:AP$134,MATCH(X124-1,AP$6:AP$134,1)))),\"\",MAX(X123,INDEX(AP$6:AP$134,MATCH(X124-1,AP$6:AP$134,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(AA123),AA123=\"\"),INDEX(AQ$7:AQ$134,MATCH(X124,AP$7:AP$134,1)),AA123-Y123),INDEX(AQ$7:AQ$134,MATCH(X124,AP$7:AP$134,1)))),\"\",MIN(IF(OR(ISBLANK(AA123),AA123=\"\"),INDEX(AQ$7:AQ$134,MATCH(X124,AP$7:AP$134,1)),AA123-Y123),INDEX(AQ$7:AQ$134,MATCH(X124,AP$7:AP$134,1))))","v":0},"","","","",{"$f":"MAX(AP123,IF(ISNA(INDEX(X$7:X$134,MATCH(AP124,X$7:X$134,1))),0,INDEX(X$7:X$134,MATCH(AP124,X$7:X$134,1))))","v":"00:00:00"},0,0,0,0,0,"",null,110,"",{"$f":"IF(OR(AP123=$C$29,AP123=\"\"),\"\",IFERROR(IF(EDATE($C$28,(AN124-1)*12/$E$19)<=$C$29,EDATE($C$28,(AN124-1)*12/$E$19),$C$29),\"\"))","v":""},0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP123,X$7:X$134,\"<=\"&AP124),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ124)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AB$7:AB$134,X$7:X$134,\">\"&AP123,X$7:X$134,\"<=\"&AP124)+AI124,IFERROR(-AQ124*piacikamat/365*(AP124-AP123),\"\"))","v":""},0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP123,X$7:X$134,\"<=\"&AP124),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT124)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AC$7:AC$134,X$7:X$134,\">\"&AP123,X$7:X$134,\"<=\"&AP124)+AJ124,IFERROR(-AT124*minkamat23/365*(AP124-AP123),\"\"))","v":""},0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP123,X$7:X$134,\"<=\"&AP124),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW124)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(AD$7:AD$134,X$7:X$134,\">\"&AP123,X$7:X$134,\"<=\"&AP124)+AK124,IFERROR(-AW124*tenylegeskamat/365*(AP124-AP123),\"\"))","v":""},null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,111,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP124,X$7:X$134,\"<=\"&AP125),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ125)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP124,X$7:X$134,\"<=\"&AP125),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT125)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP124,X$7:X$134,\"<=\"&AP125),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW125)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,112,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP125,X$7:X$134,\"<=\"&AP126),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ126)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP125,X$7:X$134,\"<=\"&AP126),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT126)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP125,X$7:X$134,\"<=\"&AP126),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW126)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,113,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP126,X$7:X$134,\"<=\"&AP127),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ127)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP126,X$7:X$134,\"<=\"&AP127),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT127)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP126,X$7:X$134,\"<=\"&AP127),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW127)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,114,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP127,X$7:X$134,\"<=\"&AP128),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ128)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP127,X$7:X$134,\"<=\"&AP128),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT128)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP127,X$7:X$134,\"<=\"&AP128),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW128)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,115,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP128,X$7:X$134,\"<=\"&AP129),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ129)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP128,X$7:X$134,\"<=\"&AP129),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT129)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP128,X$7:X$134,\"<=\"&AP129),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW129)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,116,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP129,X$7:X$134,\"<=\"&AP130),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ130)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP129,X$7:X$134,\"<=\"&AP130),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT130)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP129,X$7:X$134,\"<=\"&AP130),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW130)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,117,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP130,X$7:X$134,\"<=\"&AP131),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ131)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP130,X$7:X$134,\"<=\"&AP131),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT131)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP130,X$7:X$134,\"<=\"&AP131),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW131)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,118,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP131,X$7:X$134,\"<=\"&AP132),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ132)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP131,X$7:X$134,\"<=\"&AP132),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT132)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP131,X$7:X$134,\"<=\"&AP132),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW132)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,119,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP132,X$7:X$134,\"<=\"&AP133),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ133)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP132,X$7:X$134,\"<=\"&AP133),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT133)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP132,X$7:X$134,\"<=\"&AP133),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW133)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,0,"",null,null,null,"",0,"","","","","00:00:00",0,0,0,0,0,"",null,120,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP133,X$7:X$134,\"<=\"&AP134),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AQ$7:AQ134)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP133,X$7:X$134,\"<=\"&AP134),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AT$7:AT134)>$E$15,\"\",-$AT$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(Y$7:Y$134,X$7:X$134,\">\"&AP133,X$7:X$134,\"<=\"&AP134),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AW$7:AW134)>$E$15,\"\",-$AQ$5/$E$15),0),\"\"))","v":""},"",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":"Közepes"},null,null,null,null,{"$f":"Tamogatastartalom!C39","v":"Közép-Dunántúl"}]
[{"$f":"PRODUCT(C4:W4)","v":1},"általános",null,null,null,null,null,1]
[{"$f":"PRODUCT(E5:F5)","v":0},"mezőgazdasági",null,null,{"$f":"IF(Tamogatastartalom!C22=\"Mezőgazdasági\",1,0)","v":0},null,null,{"$f":"PRODUCT(I5)","v":1},{"$f":"IF(I3=\"Budapest\",0,1)","v":1}]
[{"$f":"PRODUCT(E6:F6)","v":0},"halászati",null,null,null,{"$f":"IF(Tamogatastartalom!C22=\"Halászati\",1,0)","v":0},null,1]
["14-es cikk"]
["R szorzó értéke"]
["Elszámolható ktg-ek EUR-ban",{"$f":"Tamogatastartalom!C23/IF(Tamogatastartalom!C9<>\"EUR\",arfolyam,1)","v":{"$error":"#DIV/0!"}}]
["A Elszámolható költségek",{"$f":"IF((B9-C10)>0,C10,B9)","v":{"$error":"#DIV/0!"}},50000000]
["B Elszámolható költségek",{"$f":"IF(B10<C10,0,IF(B9-C11<0,B9-C10,C10))","v":{"$error":"#DIV/0!"}},100000000]
["C elszámolható költségek","nincs!"]
["KKV bónusz",{"$f":"IF(D3=\"Mikró/Kis\",0.2,IF(D3=\"Közepes\",0.1,0))*IF(B9<50*10^6,1,0)","v":{"$error":"#DIV/0!"}}]
["Kaphat?",{"$f":"IF(B15>0,1,0)","v":1}]
["Alap intenzitás",{"$f":"VLOOKUP(Tamogatastartalom!C39,Adatok!A12:B20,2,FALSE)","v":0.3}]
["R szorzó értéke a támogatási térkép alapján",{"$f":"(B15+B13)*B14","v":{"$error":"#DIV/0!"}}]
["Max. TT (EUR)",{"$f":"VLOOKUP(B15,Adatok!D12:E17,2,FALSE)*10^6","v":22500000}]
["17-es cikk"]
["Vállalatméret-szorzó",{"$f":"IF(D3=\"Mikró/Kis\",0.2,IF(D3=\"Közepes\",0.1,0))","v":0.1}]
["HUF érték"]
["Elszámolható ktg-ek HUF-ban",{"$f":"IF(Tamogatastartalom!C9=\"EUR\",Tamogatastartalom!C23*arfolyam,Tamogatastartalom!C23)","v":0}]
["Hitel/támogatástartalom arány"]
["Hitelösszeg",{"$f":"Tamogatastartalom!C24","v":0}]
["Támogatástartalom a futamidő alatt",{"$f":"Tamogatastartalom!BA5","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,"Egyedi",0,null,"Féléves",2,null,"Lízing"]
[null,null,null,null,"Jó",75,100,220,null,"Tényleges min",{"$f":"MAX(K4:K5)","v":1E-3}]
[null,null,null,null,"Kielégítő",100,220,400,null,"Max",{"$f":"refkammin+4%","v":4.1000000000000002E-2},null,"Annuitás"]
[null,null,null,null,"Gyenge",220,400,650]
[null,null,null,null,"Rossz",400,650,1000]
["Regionális támogatási intenzitások"]
[null,"Nagyvállalat",null,"Intenzitás","MAX Támogatástartalom (mio EUR)"]
["Select",0,null,0.5,37.5]
["Dél-Alföld",0.5,null,0.35,26.25,null,null,null,"ügyleti kamat","beruh","zöld beruh"]
["Dél-Dunántúl",0.5,null,0.3,22.5,null,null,null,"min",{"$f":"IF(Tamogatastartalom!C9=\"HUF\",0.035,0.01)","v":3.5000000000000003E-2},{"$f":"IF(Tamogatastartalom!C9=\"HUF\",0.025,0.005)","v":2.5000000000000001E-2}]
["Észak-Alföld",0.5,null,0.25,18.75,null,null,null,"max",{"$f":"IF(Tamogatastartalom!C9=\"HUF\",0.06,0.035)","v":0.06},{"$f":"IF(Tamogatastartalom!C9=\"HUF\",0.05,0.03)","v":0.05}]
["É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]