{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Elolap","Tamogatastartalom","Szamitasok","Adatok"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":79,"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":46,"n_cols":48,"rows_kept":46,"cut":false,"hidden":false,"merged":[[7,6,7,8],[5,1,5,2],[9,6,9,9],[2,47,3,47],[3,5,4,5],[2,20,3,20],[2,21,3,21],[2,44,2,45],[2,40,2,42],[2,22,2,25],[2,27,2,31],[2,37,2,39],[2,12,3,12],[2,13,3,13],[2,6,2,8],[3,6,3,8],[4,6,4,8],[5,6,5,8],[6,6,6,8],[0,12,1,13],[3,1,3,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"A folyósítások összege kevesebb, mint a hitelösszeg"]
[]
[null,"Ügyfél neve: ",null,null,null,null,"Hitelösszeg (EUR)",null,null,{"$f":"D23/C24","v":2000000},null,null,"Egyedi folyósítás dátuma","Folyósítás összege",null,null,null,null,null,null,"Egyedi törlesztés dátuma","Tőkeamortizáció egyedi törlesztés esetén","periódusközi kamatszámítás",null,null,null,null,"maradék kamatszámítás",null,null,null,null,null,null,null,null,null,"Piaci konstrukció",null,null,"Támogatott konstruckió",null,null,null,"Támogatástartalom",null,null,"Támogatástartalom + egyéb kedvezmények"]
[null,null,null,null,-0.04,null,"Ténylegesen felvett hitel támogatástartalma (EUR)",null,null,{"$f":"(AS5)/C24","v":23024.130663856704},null,null,null,null,null,null,"kamat","támogatott",null,null,null,null,"dátumtól","tőke","kamat","támogatott",null,"dátumtól","amort","tőke","maradék","t maradék",null,null,null,"Periodus","Dátum","Tőke","Tőkeamt.","Kamatfiz.","Tőke","Tőkeamt.","Kamatfiz.",null,"FV","PV"]
[null,"Pénzügyi intézmény neve refinanszírozás esetén: ",null,null,null,null,"Mezőgazdasági tevékenység",null,null,{"$f":"tenylegestt*(SUMIF(C20:C22,\"=Mezőgazdasági\",D20:D22)/D23)","v":23024.130663856704},null,null,null,null,null,null,{"$f":"SUM(Q7:Q46)","v":-3691780.8219178086},{"$f":"SUM(R7:R46)","v":-671232.87671232875},null,null,null,null,null,null,{"$f":"SUM(Y7:Y46)","v":0},{"$f":"SUM(Z7:Z46)","v":0},null,null,null,null,{"$f":"SUM(AE7:AE46)","v":-9459257.1127502676},{"$f":"SUM(AF7:AF46)","v":-1400811.380400422},null,null,null,null,null,{"$f":"+AL7","v":700000000},{"$f":"SUM(AM7:AM46)","v":-699999999.99999964},{"$f":"SUM(AN7:AN46)","v":-9459257.1127502676},{"$f":"+AO7","v":700000000},{"$f":"SUM(AP7:AP46)","v":-699999999.99999964},{"$f":"SUM(AQ7:AQ46)","v":-1400811.380400422},null,{"$f":"SUM(AS7:AS46)","v":8058445.7323498465},{"$f":"SUM(AT7:AT46)","v":7906561.6122428346},null,{"$f":"AT5","v":7906561.6122428346}]
[null,null,null,null,null,null,"Halászati tevékenység",null,null,{"$f":"tenylegestt*(SUMIF(C20:C22,\"=Halászati\",D20:D22)/D23)","v":0},"Törlesztésiidőszak vége?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"MAX(C26,MIN(M7:M46))","v":"2020-05-30"}]
[null,null,null,null,null,null,"Egyéb tevékenység",null,null,{"$f":"tenylegestt*(SUMIF(C20:C22,\"=Egyéb\",D20:D22)/D23)","v":0},{"$f":"AJ7>$E$15","v":false},null,null,null,{"$f":"C26","v":"2020-05-30"},{"$f":"IF(ISBLANK(M7),D23,0)","v":700000000},{"$f":"IF(AND(ISBLANK(M6),AI7<>1),0,IFERROR(IF(IF(ISBLANK(M7),$C$27,M7)<=$E$22,-P7*piacikamat/365*(IF(ISBLANK(M7),$C$27,M7)-O7),IF(O7>$E$22,-P7*piacikamat2/365*(IF(ISBLANK(M7),$C$27,M7)-O7),(-P7*piacikamat/365*($E$22-O7))+(-P7*piacikamat2/365*(IF(ISBLANK(M7),$C$27,M7)-$E$22)))),\"\"))","v":-3691780.8219178086},{"$f":"IF(AND(ISBLANK(M6),AI7<>1),0,IFERROR(-P7*tenylegeskamat/365*(IF(ISBLANK(M7),$C$27,M7)-O7),\"\"))","v":-671232.87671232875},{"$f":"IFERROR(IF(ISBLANK(M7),$C$27,M7)-O7,\"\")","v":350},null,null,null,{"$f":"IF(ISNA(MAX(U6,INDEX(AK$6:AK$46,MATCH(U7-1,AK$6:AK$46,1)))),\"\",MAX(U6,INDEX(AK$6:AK$46,MATCH(U7-1,AK$6:AK$46,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(X6),X6=\"\"),INDEX(AL$7:AL$46,MATCH(U7,AK$7:AK$46,1)),X6-V6),INDEX(AL$7:AL$46,MATCH(U7,AK$7:AK$46,1)))),\"\",MIN(IF(OR(ISBLANK(X6),X6=\"\"),INDEX(AL$7:AL$46,MATCH(U7,AK$7:AK$46,1)),X6-V6),INDEX(AL$7:AL$46,MATCH(U7,AK$7:AK$46,1))))","v":""},{"$f":"IFERROR(IF(U7<=$E$22,-X7*piacikamat/365*(U7-W7),IF(W7>$E$22,-X7*piacikamat2/365*(U7-W7),(-X7*piacikamat/365*($E$22-W7))+(-X7*piacikamat2/365*(U7-$E$22)))),\"\")","v":""},{"$f":"IFERROR(-X7*tenylegeskamat/365*(U7-W7),\"\")","v":""},{"$f":"IFERROR(U7-W7,\"\")","v":""},{"$f":"MAX(AK6,IF(ISNA(INDEX(U$7:U$46,MATCH(AK7,U$7:U$46,1))),0,INDEX(U$7:U$46,MATCH(AK7,U$7:U$46,1))))","v":"2020-05-30"},{"$f":"IF(ISNA(INDEX(V$7:V$46,MATCH(AK7,U$7:U$46,1))),0,INDEX(V$7:V$46,MATCH(AK7,U$7:U$46,1)))","v":0},{"$f":"IF(ISNA(INDEX(X$7:X$46,MATCH(AK7,U$7:U$46,1))),AL7,INDEX(X$7:X$46,MATCH(AK7,U$7:U$46,1)))","v":700000000},{"$f":"IFERROR(IF(AK7<=$E$22,-(AD7-AC7)*piacikamat/365*(AK7-AB7),IF(AB7>$E$22,-(AD7-AC7)*piacikamat2/365*(AK7-AB7),(-(AD7-AC7)*piacikamat/365*($E$22-AB7))+(-(AD7-AC7)*piacikamat2/365*(AK7-$E$22)))),0)","v":-3691780.8219178086},{"$f":"IFERROR(-(AD7-AC7)*tenylegeskamat/365*(AK7-AB7),0)","v":-671232.87671232875},{"$f":"IFERROR(AK7-AB7,\"\")","v":350},null,1,{"$f":"+IF(C28-C27<>0,1,\"\")","v":1},{"$f":"C27","v":"2021-05-15"},{"$f":"IF(+D23<>0,D23,IF(AJ7>0,D23*K7,\"\"))","v":700000000},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK6,U$7:U$46,\"<=\"&AK7),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL7)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},{"$f":"SUM(Q7:Q46)","v":-3691780.8219178086},{"$f":"+AL7","v":700000000},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK6,U$7:U$46,\"<=\"&AK7),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO7)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},{"$f":"SUM(R7:R46)","v":-671232.87671232875},null,{"$f":"IFERROR(MAX((ABS(AN7)-ABS(AQ7)),0),\"\")","v":3020547.9452054799},{"$f":"IFERROR(AS7/(1+($C$9+1%)/365*(AK7-C25)),\"\")","v":2981784.743539467},{"$f":"IFERROR(AK7-AK6,\"\")","v":350}]
[null,"PIACI KAMAT MEGHATÁROZÁSA",null,null,null,null,"Hitelösszeg (HUF)",null,null,{"$f":"J3*C24","v":700000000},{"$f":"AJ8>$E$15","v":false},null,null,null,{"$f":"IF(ISBLANK(M7),\"\",M7)","v":""},{"$f":"IF(ISBLANK(M7),0,N7+P7)","v":0},0,0,"",null,null,null,"","","","","","2021-05-15",0,673076923.07692313,-388171.75974710227,-57165.437302423612,31,null,2,{"$f":"IF(COUNT(AK8)=1,AJ7+1,\"\")","v":2},{"$f":"IF(OR(AK7=$C$28,AK7=\"\"),\"\",IFERROR(IF(EDATE($C$27,(AI8-1)*12/$E$19)<=$C$28,EDATE($C$27,(AI8-1)*12/$E$19),$C$28),\"\"))","v":"2021-06-15"},{"$f":"+IF(COUNT(AL7)<>0,SUM(AL7:AM7)*(1-K8),\"\")","v":673076923.07692313},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK7,U$7:U$46,\"<=\"&AK8),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL8)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Y$7:Y$46,U$7:U$46,\">\"&AK7,U$7:U$46,\"<=\"&AK8)+AE8,IFERROR(IF(AK8<=$E$22,-AL8*piacikamat/365*(AK8-AK7),IF(AK7>$E$22,-AL8*piacikamat2/365*(AK8-AK7),(-AL8*piacikamat/365*($E$22-AK7))+(-AL8*piacikamat2/365*(AK8-$E$22)))),\"\"))","v":-388171.75974710227},{"$f":"+IF(COUNT(AO7)<>0,SUM(AO7:AP7)*(1-K8),\"\")","v":673076923.07692313},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK7,U$7:U$46,\"<=\"&AK8),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO8)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Z$7:Z$46,U$7:U$46,\">\"&AK7,U$7:U$46,\"<=\"&AK8)+AF8,IFERROR(-AO8*tenylegeskamat/365*(AK8-AK7),\"\"))","v":-57165.437302423612},null,{"$f":"IFERROR(MAX((ABS(AN8)-ABS(AQ8)),0),\"\")","v":331006.32244467863},{"$f":"IFERROR(AS8/POWER(1+($C$9+1%)/$E$19,AJ8-1)/(1+($C$9+1%)/365*($AK$7-$C$25)),\"\")","v":326404.85717111366},31]
[null,"Referencia alapkamat",3.0000000000000001E-3,null,"Makrohoz kellenek (ne töröld ki!):",null,null,null,null,null,false,null,null,null,{"$f":"IF(ISBLANK(M8),\"\",M8)","v":""},{"$f":"IF(ISBLANK(M8),0,N8+P8)","v":0},0,0,"",null,null,null,"","","","","","2021-06-15",0,646153846.15384626,-424868.28240252903,-53108.535300316129,30,null,3,{"$f":"IF(COUNT(AK9)=1,AJ8+1,\"\")","v":3},"2021-07-15",646153846.15384626,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK8,U$7:U$46,\"<=\"&AK9),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL9)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-424868.28240252903,646153846.15384626,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK8,U$7:U$46,\"<=\"&AK9),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO9)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-53108.535300316129,null,371759.74710221292,366195.03915714257,30]
[null,"Futamidő:","12 hónap felett",null,{"$f":"+C13/E19","v":4.5833333333333332E-4},null,"COVID Közlemény 3.1 alapján megítélt támogatásokon felül igénybe vehető szabad keret",null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2021-07-15",0,619230769.2307694,-420737.61854583782,-52592.202318229727,31,null,4,{"$f":"IF(COUNT(AK10)=1,AJ9+1,\"\")","v":4},"2021-08-15",619230769.2307694,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK9,U$7:U$46,\"<=\"&AK10),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL10)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-420737.61854583782,619230769.2307694,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK9,U$7:U$46,\"<=\"&AK10),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO10)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-52592.202318229727,null,368145.4162276081,362242.38036438666,31]
[null,"Kockázati felár (bázispont) az első évben:",25,null,null,null,null,"Általános szabály","Mezőgazdasági szabály","Halászati szabály",false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2021-08-15",0,592307692.30769253,-402444.67860906228,-50305.584826132785,31,null,5,5,"2021-09-15",592307692.30769253,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK10,U$7:U$46,\"<=\"&AK11),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL11)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-402444.67860906228,592307692.30769253,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK10,U$7:U$46,\"<=\"&AK11),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO11)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-50305.584826132785,null,352139.09378292947,346117.75075623899,31]
[null,"Kockázati felár (bázispont) az első éven túl:",{"$f":"IF(C10=\"12 hónap felett\",50,)","v":50},null,1E-4,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2021-09-15",0,565384615.38461566,-371759.74710221309,-46469.968387776637,30,null,6,6,"2021-10-15",565384615.38461566,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK11,U$7:U$46,\"<=\"&AK12),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL12)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-371759.74710221309,565384615.38461566,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK11,U$7:U$46,\"<=\"&AK12),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO12)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-46469.968387776637,null,325289.77871443646,319381.54434811557,30]
[null,"Ügyfél kamat támogatás nélkül az első évben:",{"$f":"+(C9+C11/10000)","v":5.4999999999999997E-3},null,null,null,"Maximális hitelösszeghez tartozó támogatástartalom (EUR)",{"$f":"IF(1800000-C36<=0,\"Nem jogosult\",1800000-C36)","v":1800000},{"$f":"IF(mezogazdkizarok=0,\"Nem releváns\",IF(MIN(225000-C33,1800000-C36,270000-C33-C34)<=0,\"Nem jogosult\",MIN(225000-C33,1800000-C36,270000-C33-C34)))","v":225000},{"$f":"IF(halaszatikizarok=0,\"Nem releváns\",IF(MIN(270000-C34,1800000-C36,270000-C33-C34)<=0,\"Nem jogosult\",MIN(270000-C34,1800000-C36,270000-C33-C34)))","v":"Nem releváns"},false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2021-10-15",0,538461538.46153879,-365858.79873551131,-45732.349841938914,31,null,7,7,"2021-11-15",538461538.46153879,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK12,U$7:U$46,\"<=\"&AK13),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL13)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-365858.79873551131,538461538.46153879,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK12,U$7:U$46,\"<=\"&AK13),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO13)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-45732.349841938914,null,320126.44889357238,313971.85984363226,31]
[null,"Ügyfél kamat támogatás nélkül az első éven túl:",{"$f":"IF(C10=\"12 hónap felett\",+(C9+C12/10000),0)","v":8.0000000000000002E-3},null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2021-11-15",0,511538461.53846186,-336354.05690200231,-42044.257112750289,30,null,8,8,"2021-12-15",511538461.53846186,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK13,U$7:U$46,\"<=\"&AK14),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL14)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-336354.05690200231,511538461.53846186,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK13,U$7:U$46,\"<=\"&AK14),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO14)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-42044.257112750289,null,294309.79978925199,288339.18111970695,30]
[null,null,null,null,{"$f":"COUNT(AJ7:AJ46)","v":26},null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2021-12-15",0,484615384.61538494,-329272.91886196018,-41159.114857745022,31,null,9,9,"2022-01-15",484615384.61538494,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK14,U$7:U$46,\"<=\"&AK15),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL15)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-329272.91886196018,484615384.61538494,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK14,U$7:U$46,\"<=\"&AK15),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO15)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-41159.114857745022,null,288113.80400421517,281963.42219577299,31]
[null,"HITELKARAKTERISZTIKA",null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-01-15",0,457692307.69230801,-310979.97892518464,-38872.49736564808,31,null,10,{"$f":"IF(COUNT(AK16)=1,AJ15+1,\"\")","v":10},"2022-02-15",457692307.69230801,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK15,U$7:U$46,\"<=\"&AK16),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL16)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-310979.97892518464,457692307.69230801,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK15,U$7:U$46,\"<=\"&AK16),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO16)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-38872.49736564808,null,272107.48155953654,266010.60946908296,31]
[null,"Hitel fajtája/célja:","Forgóeszközhitel",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-02-15",0,430769230.76923108,-264362.48682824045,-33045.310853530056,28,null,11,{"$f":"IF(COUNT(AK17)=1,AJ16+1,\"\")","v":11},"2022-03-15",430769230.76923108,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK16,U$7:U$46,\"<=\"&AK17),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL17)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-264362.48682824045,430769230.76923108,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK16,U$7:U$46,\"<=\"&AK17),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO17)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-33045.310853530056,null,231317.17597471038,225889.54257583854,28]
[null,"Hitel devizaneme:","HUF",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-03-15",0,403846153.84615415,-274394.0990516335,-34299.262381454188,31,null,12,12,"2022-04-15",403846153.84615415,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK17,U$7:U$46,\"<=\"&AK18),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL18)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-274394.0990516335,403846153.84615415,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK17,U$7:U$46,\"<=\"&AK18),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO18)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-34299.262381454188,null,240094.83667017933,234207.51915580654,31]
[null,"Egy vagy több tevékenységhez igényli a forgóeszközhitelt?:","Egy tevékenység","Hitelösszeg (HUF)",{"$f":"VLOOKUP($C$31,Adatok!P3:Q5,2,0)","v":12},null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-04-15",0,376923076.92307723,-247839.83140147541,-30979.978925184427,30,null,13,13,"2022-05-15",376923076.92307723,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK18,U$7:U$46,\"<=\"&AK19),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL19)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-247839.83140147541,376923076.92307723,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK18,U$7:U$46,\"<=\"&AK19),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO19)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-30979.978925184427,null,216859.85247629098,211313.35256791962,30]
[null,"Kérem nevezze meg a tevékenységet!","Mezőgazdasági",700000000,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-05-15",0,350000000.0000003,-237808.21917808239,-29726.027397260299,31,null,14,14,"2022-06-15",350000000.0000003,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK19,U$7:U$46,\"<=\"&AK20),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL20)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-237808.21917808239,350000000.0000003,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK19,U$7:U$46,\"<=\"&AK20),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO20)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-29726.027397260299,null,208082.19178082209,202540.77388750672,31]
[null,"Kérem nevezze meg a tevékenységet!",null,0,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-06-15",0,323076923.07692337,-212434.14120126466,-26554.267650158083,30,null,15,15,"2022-07-15",323076923.07692337,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK20,U$7:U$46,\"<=\"&AK21),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL21)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-212434.14120126466,323076923.07692337,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK20,U$7:U$46,\"<=\"&AK21),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO21)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-26554.267650158083,null,185879.87355110658,180733.92848277657,30]
[null,"Kérem nevezze meg a tevékenységet!",null,0,{"$f":"DATE(YEAR($C$26)+1,MONTH($C$26),DAY($C$26))","v":"2021-05-30"},null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-07-15",0,296153846.15384644,-201222.33930453128,-25152.792413066411,31,null,16,16,"2022-08-15",296153846.15384644,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK21,U$7:U$46,\"<=\"&AK22),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL22)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-201222.33930453128,296153846.15384644,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK21,U$7:U$46,\"<=\"&AK22),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO22)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-25152.792413066411,null,176069.54689146488,171009.93260808242,31]
[null,"Hitelösszeg összesen:",null,{"$f":"IF(SUM(D20:D22)>720000000,\"A hitelösszeg nem haladhatja meg a 720 milló forintot!\",SUM(D20:D22))","v":700000000},null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-08-15",0,269230769.23076952,-182929.39936775574,-22866.174920969468,31,null,17,17,"2022-09-15",269230769.23076952,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK22,U$7:U$46,\"<=\"&AK23),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL23)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-182929.39936775574,269230769.23076952,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK22,U$7:U$46,\"<=\"&AK23),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO23)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-22866.174920969468,null,160063.22444678628,155295.33848156838,31]
[null,"HUF/EUR árfolyam",350,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-09-15",0,242307692.30769259,-159325.60590094858,-19915.700737618572,30,null,18,18,"2022-10-15",242307692.30769259,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK23,U$7:U$46,\"<=\"&AK24),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL24)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-159325.60590094858,242307692.30769259,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK23,U$7:U$46,\"<=\"&AK24),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO24)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-19915.700737618572,null,139409.90516333,135110.86019185709,30]
[null,"Hitel jóváhagyásának várható időpontja (EXIM döntés dátuma)","2020-05-15",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-10-15",0,215384615.38461566,-146343.51949420461,-18292.939936775576,31,null,19,19,"2022-11-15",215384615.38461566,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK24,U$7:U$46,\"<=\"&AK25),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL25)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-146343.51949420461,215384615.38461566,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK24,U$7:U$46,\"<=\"&AK25),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO25)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-18292.939936775576,null,128050.57955742904,123967.52898278923,31]
[null,{"$f":"\"Szerződéskötés várható dátuma\"&IF(C26>DATE(2021,12,31),\" - Nem lehet későbbi, mint 2021.12.31\",\"\")","v":"Szerződéskötés várható dátuma"},"2020-05-30",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-11-15",0,188461538.46153873,-123919.91570073779,-15489.989462592224,30,null,20,20,"2022-12-15",188461538.46153873,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK25,U$7:U$46,\"<=\"&AK26),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL26)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-123919.91570073779,188461538.46153873,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK25,U$7:U$46,\"<=\"&AK26),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO26)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-15489.989462592224,null,108429.92623814556,104858.90723108732,30]
[null,"Első törlesztés várható dátuma","2021-05-15",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-12-15",0,161538461.5384618,-109757.6396206535,-13719.704952581687,31,null,21,21,"2023-01-15",161538461.5384618,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK26,U$7:U$46,\"<=\"&AK27),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL27)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-109757.6396206535,161538461.5384618,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK26,U$7:U$46,\"<=\"&AK27),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO27)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-13719.704952581687,null,96037.934668071815,92774.526382049196,31]
[null,"Hitel végső lejáratának várható dátuma","2023-05-30",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-01-15",0,134615384.61538488,-91464.699683877945,-11433.087460484743,31,null,22,22,"2023-02-15",134615384.61538488,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK27,U$7:U$46,\"<=\"&AK28),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL28)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-91464.699683877945,134615384.61538488,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK27,U$7:U$46,\"<=\"&AK28),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO28)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-11433.087460484743,null,80031.612223393196,77228.441173769432,31]
[null,"Tényleges ügyleti kamat",1E-3,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-02-15",0,107692307.69230795,-66090.621707060229,-8261.3277133825286,28,null,23,{"$f":"IF(COUNT(AK29)=1,AJ28+1,\"\")","v":23},"2023-03-15",107692307.69230795,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK28,U$7:U$46,\"<=\"&AK29),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL29)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-66090.621707060229,107692307.69230795,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK28,U$7:U$46,\"<=\"&AK29),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO29)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-8261.3277133825286,null,57829.293993677697,55743.388177617351,28]
[null,"Törlesztés módja","Egyenlő tőke",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-03-15",0,80769230.769231021,-54878.819810326837,-6859.8524762908546,31,null,24,24,"2023-04-15",80769230.769231021,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK29,U$7:U$46,\"<=\"&AK30),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL30)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-54878.819810326837,80769230.769231021,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK29,U$7:U$46,\"<=\"&AK30),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO30)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-6859.8524762908546,null,48018.96733403598,46236.830640482476,31]
[null,{"$f":"IF(torlesztes=\"Egyenlő tőke\",\"Kamatfizetés/tőketörlesztés gyakorisága\",\"Kamatfizetés gyakorisága\")","v":"Kamatfizetés/tőketörlesztés gyakorisága"},"Havi",null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-04-15",0,53846153.846154094,-35405.690200210913,-4425.7112750263641,30,null,25,25,"2023-05-15",53846153.846154094,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK30,U$7:U$46,\"<=\"&AK31),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL31)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-35405.690200210913,53846153.846154094,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK30,U$7:U$46,\"<=\"&AK31),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO31)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-4425.7112750263641,null,30979.97892518455,29797.932223198557,30]
[null,"COVID Közlemény 3.1 alapján megítélt állami támogatások",null,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-05-15",0,26923076.92307717,-8851.4225500527682,-1106.427818756596,15,null,26,26,"2023-05-30",26923076.92307717,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK31,U$7:U$46,\"<=\"&AK32),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL32)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-8851.4225500527682,26923076.92307717,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK31,U$7:U$46,\"<=\"&AK32),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO32)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":-26923076.923076924},-1106.427818756596,null,7744.9947312961722,7441.4215158241968,15]
[null,"Mezőgazdasági ágazatra megítélt támogatás teljes összege (EUR):",null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2023-05-30",0,0,0,0,"",null,27,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK32,U$7:U$46,\"<=\"&AK33),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL33)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK32,U$7:U$46,\"<=\"&AK33),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO33)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",null,"","",""]
[null,"Halászati, akvakultúra ágazatra  megítélt támogatás teljes összeg (EUR):",null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,28,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK33,U$7:U$46,\"<=\"&AK34),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL34)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK33,U$7:U$46,\"<=\"&AK34),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO34)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",null,"","",""]
[null,"Egyéb ágazatra megítélt támogatás tejes összege (EUR):",null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,29,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK34,U$7:U$46,\"<=\"&AK35),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL35)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK34,U$7:U$46,\"<=\"&AK35),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO35)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",null,"","",""]
[null,"COVID Közlemény 3.1 szakasza alapján megítélt támogatások teljes összege (EUR)",{"$f":"SUM(C33:C35)","v":0},null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,30,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK35,U$7:U$46,\"<=\"&AK36),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL36)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK35,U$7:U$46,\"<=\"&AK36),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO36)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,31,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK36,U$7:U$46,\"<=\"&AK37),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL37)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK36,U$7:U$46,\"<=\"&AK37),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO37)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,32,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK37,U$7:U$46,\"<=\"&AK38),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL38)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK37,U$7:U$46,\"<=\"&AK38),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO38)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,33,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK38,U$7:U$46,\"<=\"&AK39),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL39)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK38,U$7:U$46,\"<=\"&AK39),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO39)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,34,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK39,U$7:U$46,\"<=\"&AK40),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL40)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK39,U$7:U$46,\"<=\"&AK40),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO40)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,35,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK40,U$7:U$46,\"<=\"&AK41),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL41)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK40,U$7:U$46,\"<=\"&AK41),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO41)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,36,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK41,U$7:U$46,\"<=\"&AK42),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL42)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK41,U$7:U$46,\"<=\"&AK42),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO42)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,37,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK42,U$7:U$46,\"<=\"&AK43),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL43)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK42,U$7:U$46,\"<=\"&AK43),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO43)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",null,"","",{"$f":"IFERROR(AK43-AK42,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,38,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK43,U$7:U$46,\"<=\"&AK44),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL44)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK43,U$7:U$46,\"<=\"&AK44),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO44)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,{"$f":"IF(ISBLANK(M44),\"\",M44)","v":""},{"$f":"IF(ISBLANK(M44),0,N44+P44)","v":0},0,0,null,null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,39,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK44,U$7:U$46,\"<=\"&AK45),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL45)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK44,U$7:U$46,\"<=\"&AK45),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO45)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"","","","","","00:00:00",0,0,0,0,"",null,40,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK45,U$7:U$46,\"<=\"&AK46),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AL$7:AL46)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(V$7:V$46,U$7:U$46,\">\"&AK45,U$7:U$46,\"<=\"&AK46),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AO$7:AO46)>$E$15,\"\",-$AL$5/$E$15),0),\"\"))","v":""},"",null,"","",""]

{"sheet":"Szamitasok","index":2,"n_rows":25,"n_cols":6,"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,null,"Mezőgazdasági","Halászat/akvakultúra"]
["Szorzó értéke"]
[{"$f":"PRODUCT(C4:W4)","v":0},"általános"]
[{"$f":"PRODUCT(E5:F5)","v":1},"mezőgazdasági",null,null,{"$f":"IF(OR(Tamogatastartalom!C20=\"Mezőgazdasági\",Tamogatastartalom!C21=\"Mezőgazdasági\",Tamogatastartalom!C22=\"Mezőgazdasági\"),1,0)","v":1}]
[{"$f":"PRODUCT(E6:F6)","v":0},"halászati",null,null,null,{"$f":"IF(OR(Tamogatastartalom!C20=\"Halászati\",Tamogatastartalom!C21=\"Halászati\",Tamogatastartalom!C22=\"Halászati\"),1,0)","v":0}]
["14-es cikk"]
["R szorzó értéke"]
["Elszámolható ktg-ek EUR-ban",0]
["A Elszámolható költségek",0,50000000]
["B Elszámolható költségek",{"$f":"0","v":0},100000000]
["C elszámolható költségek","nincs!"]
["KKV bónusz",0.2]
["Kaphat?",{"$f":"IF(B15>0,1,0)","v":1}]
["Alap intenzitás",0.35]
["R szorzó értéke a támogatási térkép alapján",0.55000000000000004]
["Max. TT (EUR)",{"$f":"VLOOKUP(B15,Adatok!D12:E16,2,FALSE)*10^6","v":26250000}]
["17-es cikk"]
["Vállalatméret-szorzó",{"$f":"IF(D3=\"Nagy\",0,IF(D3=\"Mikró/Kis\",0.2,0.1))","v":0.1}]
["HUF érték"]
["Elszámolható ktg-ek HUF-ban",0]
["Hitel/támogatástartalom arány"]
["Hitelösszeg",{"$f":"Tamogatastartalom!D23","v":700000000}]
["Támogatástartalom a futamidő alatt",{"$f":"Tamogatastartalom!AT5","v":7906561.6122428346}]
["Hitelösszeg/támogatástartalom",{"$f":"B23/B24","v":88.534059978245423}]

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