{"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":2322580.6451612902},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":"(AV5)/C24","v":26233.752814814907},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":3643.5767798354041},null,null,null,null,null,null,{"$f":"SUM(Q7:Q46)","v":-3797260.273972603},{"$f":"SUM(R7:R46)","v":-690410.95890410966},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":-9729521.6016859841},{"$f":"SUM(AF7:AF46)","v":-1440834.5626975761},null,null,null,null,null,{"$f":"+AL7","v":720000000},{"$f":"SUM(AM7:AM46)","v":-720000000.00000024},{"$f":"SUM(AN7:AN46)","v":-9729521.6016859841},{"$f":"+AO7","v":720000000},{"$f":"SUM(AP7:AP46)","v":-720000000.00000024},{"$f":"SUM(AQ7:AQ46)","v":-1440834.5626975761},null,{"$f":"SUM(AS7:AS46)","v":8288687.0389884068},{"$f":"SUM(AT7:AT46)","v":8132463.3725926215},null,{"$f":"AT5","v":8132463.3725926215}]
[null,null,null,null,null,null,"Halászati tevékenység",null,null,{"$f":"tenylegestt*(SUMIF(C20:C22,\"=Halászati\",D20:D22)/D23)","v":3643.5767798354041},"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":18946.599255144098},{"$f":"AJ7>$E$15","v":false},null,null,null,{"$f":"C26","v":"2020-05-30"},{"$f":"IF(ISBLANK(M7),D23,0)","v":720000000},{"$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":-3797260.273972603},{"$f":"IF(AND(ISBLANK(M6),AI7<>1),0,IFERROR(-P7*tenylegeskamat/365*(IF(ISBLANK(M7),$C$27,M7)-O7),\"\"))","v":-690410.95890410966},{"$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":720000000},{"$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":-3797260.273972603},{"$f":"IFERROR(-(AD7-AC7)*tenylegeskamat/365*(AK7-AB7),0)","v":-690410.95890410966},{"$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":720000000},{"$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":-27692307.692307692},{"$f":"SUM(Q7:Q46)","v":-3797260.273972603},{"$f":"+AL7","v":720000000},{"$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":-27692307.692307692},{"$f":"SUM(R7:R46)","v":-690410.95890410966},null,{"$f":"IFERROR(MAX((ABS(AN7)-ABS(AQ7)),0),\"\")","v":3106849.3150684936},{"$f":"IFERROR(AS7/(1+($C$9+1%)/365*(AK7-C25)),\"\")","v":3066978.5933548803},{"$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":720000000},{"$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,692307692.30769229,-399262.38145416224,-58798.735511064275,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":692307692.30769229},{"$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":-27692307.692307692},{"$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":-399262.38145416224},{"$f":"+IF(COUNT(AO7)<>0,SUM(AO7:AP7)*(1-K8),\"\")","v":692307692.30769229},{"$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":-27692307.692307692},{"$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":-58798.735511064275},null,{"$f":"IFERROR(MAX((ABS(AN8)-ABS(AQ8)),0),\"\")","v":340463.64594309794},{"$f":"IFERROR(AS8/POWER(1+($C$9+1%)/$E$19,AJ8-1)/(1+($C$9+1%)/365*($AK$7-$C$25)),\"\")","v":335730.71023314545},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,664615384.61538458,-437007.37618545839,-54625.922023182298,30,null,3,{"$f":"IF(COUNT(AK9)=1,AJ8+1,\"\")","v":3},"2021-07-15",664615384.61538458,{"$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":-27692307.692307692},-437007.37618545839,664615384.61538458,{"$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":-27692307.692307692},-54625.922023182298,null,382381.45416227612,376657.75456163229,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,636923076.92307687,-432758.69336143305,-54094.836670179131,31,null,4,{"$f":"IF(COUNT(AK10)=1,AJ9+1,\"\")","v":4},"2021-08-15",636923076.92307687,{"$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":-27692307.692307692},-432758.69336143305,636923076.92307687,{"$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":-27692307.692307692},-54094.836670179131,null,378663.8566912539,372592.16266051185,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,609230769.23076916,-413943.09799789247,-51742.887249736559,31,null,5,5,"2021-09-15",609230769.23076916,{"$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":-27692307.692307692},-413943.09799789247,609230769.23076916,{"$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":-27692307.692307692},-51742.887249736559,null,362200.21074815589,356006.82934927428,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,581538461.53846145,-382381.45416227606,-47797.681770284507,30,null,6,6,"2021-10-15",581538461.53846145,{"$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":-27692307.692307692},-382381.45416227606,581538461.53846145,{"$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":-27692307.692307692},-47797.681770284507,null,334583.77239199157,328506.73132949008,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(800000-C36<=0,\"Nem jogosult\",800000-C36)","v":650000},{"$f":"IF(mezogazdkizarok=0,\"Nem releváns\",IF(MIN(100000-C33,800000-C36,120000-C33-C34)<=0,\"Nem jogosult\",MIN(100000-C33,800000-C36,120000-C33-C34)))","v":50000},{"$f":"IF(halaszatikizarok=0,\"Nem releváns\",IF(MIN(120000-C34,800000-C36,120000-C33-C34)<=0,\"Nem jogosult\",MIN(120000-C34,800000-C36,120000-C33-C34)))","v":50000},false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2021-10-15",0,553846153.84615374,-376311.90727081132,-47038.988408851415,31,null,7,7,"2021-11-15",553846153.84615374,{"$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":-27692307.692307692},-376311.90727081132,553846153.84615374,{"$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":-27692307.692307692},-47038.988408851415,null,329272.91886195989,322942.48441059294,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,526153846.15384603,-345964.17281348776,-43245.52160168597,30,null,8,8,"2021-12-15",526153846.15384603,{"$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":-27692307.692307692},-345964.17281348776,526153846.15384603,{"$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":-27692307.692307692},-43245.52160168597,null,302718.6512118018,296577.44343741261,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,498461538.46153831,-338680.71654373017,-42335.089567966272,31,null,9,9,"2022-01-15",498461538.46153831,{"$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":-27692307.692307692},-338680.71654373017,498461538.46153831,{"$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":-27692307.692307692},-42335.089567966272,null,296345.62697576388,290019.51997279475,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,470769230.7692306,-319865.12118018954,-39983.140147523693,31,null,10,{"$f":"IF(COUNT(AK16)=1,AJ15+1,\"\")","v":10},"2022-02-15",470769230.7692306,{"$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":-27692307.692307692},-319865.12118018954,470769230.7692306,{"$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":-27692307.692307692},-39983.140147523693,null,279881.98103266582,273610.91259677074,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,443076923.07692289,-271915.70073761843,-33989.462592202304,28,null,11,{"$f":"IF(COUNT(AK17)=1,AJ16+1,\"\")","v":11},"2022-03-15",443076923.07692289,{"$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":-27692307.692307692},-271915.70073761843,443076923.07692289,{"$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":-27692307.692307692},-33989.462592202304,null,237926.23814541614,232343.52950657651,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,415384615.38461518,-282233.93045310839,-35279.241306638549,31,null,12,12,"2022-04-15",415384615.38461518,{"$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":-27692307.692307692},-282233.93045310839,415384615.38461518,{"$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":-27692307.692307692},-35279.241306638549,null,246954.68914646984,240899.16256025783,31]
[null,"Egy vagy több tevékenységhez igényli a forgóeszközhitelt?:","Több 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,387692307.69230747,-254920.96944151723,-31865.121180189653,30,null,13,13,"2022-05-15",387692307.69230747,{"$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":-27692307.692307692},-254920.96944151723,387692307.69230747,{"$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":-27692307.692307692},-31865.121180189653,null,223055.84826132757,217350.87692700274,30]
[null,"Kérem nevezze meg a tevékenységet!","Halászati",100000000,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-05-15",0,359999999.99999976,-244602.73972602724,-30575.342465753405,31,null,14,14,"2022-06-15",359999999.99999976,{"$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":-27692307.692307692},-244602.73972602724,359999999.99999976,{"$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":-27692307.692307692},-30575.342465753405,null,214027.39726027384,208327.65314143518,31]
[null,"Kérem nevezze meg a tevékenységet!","Mezőgazdasági",100000000,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-06-15",0,332307692.30769205,-218503.68809272905,-27312.961011591131,30,null,15,15,"2022-07-15",332307692.30769205,{"$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":-27692307.692307692},-218503.68809272905,332307692.30769205,{"$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":-27692307.692307692},-27312.961011591131,null,191190.72708113791,185897.75501085562,30]
[null,"Kérem nevezze meg a tevékenységet!","Egyéb",520000000,{"$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,304615384.61538434,-206971.54899894606,-25871.443624868258,31,null,16,16,"2022-08-15",304615384.61538434,{"$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":-27692307.692307692},-206971.54899894606,304615384.61538434,{"$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":-27692307.692307692},-25871.443624868258,null,181100.1053740778,175895.9306825987,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":720000000},null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-08-15",0,276923076.92307663,-188155.95363540549,-23519.494204425686,31,null,17,17,"2022-09-15",276923076.92307663,{"$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":-27692307.692307692},-188155.95363540549,276923076.92307663,{"$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":-27692307.692307692},-23519.494204425686,null,164636.4594309798,159732.34815246999,31]
[null,"HUF/EUR árfolyam",310,null,null,null,null,null,null,null,false,null,null,null,"",0,0,0,"",null,null,null,"","","","","","2022-09-15",0,249230769.23076895,-163877.76606954672,-20484.72075869334,30,null,18,18,"2022-10-15",249230769.23076895,{"$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":-27692307.692307692},-163877.76606954672,249230769.23076895,{"$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":-27692307.692307692},-20484.72075869334,null,143393.04531085337,138971.17048305267,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,221538461.53846127,-150524.76290832437,-18815.595363540546,31,null,19,19,"2022-11-15",221538461.53846127,{"$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":-27692307.692307692},-150524.76290832437,221538461.53846127,{"$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":-27692307.692307692},-18815.595363540546,null,131709.16754478382,127509.45838229718,31]
[null,{"$f":"\"Szerződéskötés várható dátuma\"&IF(C26>DATE(2021,6,30),\" - Nem lehet későbbi, mint 2021.06.30\",\"\")","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,193846153.84615359,-127460.48472075853,-15932.560590094816,30,null,20,20,"2022-12-15",193846153.84615359,{"$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":-27692307.692307692},-127460.48472075853,193846153.84615359,{"$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":-27692307.692307692},-15932.560590094816,null,111527.92413066371,107854.87600911809,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,166153846.15384591,-112893.57218124326,-14111.696522655408,31,null,21,21,"2023-01-15",166153846.15384591,{"$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":-27692307.692307692},-112893.57218124326,166153846.15384591,{"$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":-27692307.692307692},-14111.696522655408,null,98781.875658587858,95425.227135821755,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,138461538.46153823,-94077.9768177027,-11759.747102212837,31,null,22,22,"2023-02-15",138461538.46153823,{"$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":-27692307.692307692},-94077.9768177027,138461538.46153823,{"$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":-27692307.692307692},-11759.747102212837,null,82318.22971548987,79434.968064448301,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,110769230.76923053,-67978.925184404492,-8497.3656480505615,28,null,23,{"$f":"IF(COUNT(AK29)=1,AJ28+1,\"\")","v":23},"2023-03-15",110769230.76923053,{"$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":-27692307.692307692},-67978.925184404492,110769230.76923053,{"$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":-27692307.692307692},-8497.3656480505615,null,59481.559536353932,57336.0564112633,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,83076923.076922834,-56446.786090621543,-7055.8482613276929,31,null,24,24,"2023-04-15",83076923.076922834,{"$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":-27692307.692307692},-56446.786090621543,83076923.076922834,{"$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":-27692307.692307692},-7055.8482613276929,null,49390.937829293849,47557.88294449597,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,55384615.384615138,-36417.281348788041,-4552.1601685985052,30,null,25,25,"2023-05-15",55384615.384615138,{"$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":-27692307.692307692},-36417.281348788041,55384615.384615138,{"$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":-27692307.692307692},-4552.1601685985052,null,31865.121180189537,30649.301715289668,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,27692307.692307446,-9104.3203371969685,-1138.0400421496211,15,null,26,26,"2023-05-30",27692307.692307446,{"$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":-27692307.692307692},-9104.3203371969685,27692307.692307446,{"$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":-27692307.692307692},-1138.0400421496211,null,7966.280295047347,7654.0335591333205,15]
[null,"Mezőgazdasági ágazatra megítélt támogatás teljes összege (EUR):",50000,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):",20000,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):",80000,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":150000},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":1},"halászati",null,null,null,{"$f":"IF(OR(Tamogatastartalom!C20=\"Halászati\",Tamogatastartalom!C21=\"Halászati\",Tamogatastartalom!C22=\"Halászati\"),1,0)","v":1}]
["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":720000000}]
["Támogatástartalom a futamidő alatt",{"$f":"Tamogatastartalom!AT5","v":8132463.3725926215}]
["Hitelösszeg/támogatástartalom",{"$f":"B23/B24","v":88.534059978245523}]

{"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]