{"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":104,"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":210,"n_cols":47,"rows_kept":210,"cut":false,"hidden":false,"merged":[[3,5,3,7],[7,5,7,7],[5,5,5,7],[8,5,8,7],[5,1,5,2],[6,5,6,7],[4,5,4,7],[44,1,44,2],[2,46,3,46],[3,4,4,4],[2,19,3,19],[2,20,3,20],[2,43,2,44],[2,39,2,41],[2,21,2,24],[2,26,2,30],[2,36,2,38],[2,11,3,11],[2,12,3,12],[2,5,2,7],[4,19,5,20],[4,11,5,12],[3,1,3,2]]}
[]
[]
[null,"Ügyfél neve",null,null,null,"Hitelösszeg (EUR)",null,null,{"$f":"IF(C10=\"EUR\",+C11,C11/C12)","v":{"$error":"#DIV/0!"}},null,null,"Egyedi folyósítás dátuma","Folyósítás összege",null,null,null,null,null,null,"Egyedi törlesztés dátuma","Tőkeamortizáció egyedi törlesztés esetén","periódusközi kamatszámítás",null,null,null,null,"maradék kamatszámítás",null,null,null,null,null,null,null,null,null,"Piaci konstrukció",null,null,"Támogatott konstruckió",null,null,null,"Támogatástartalom",null,null,"Támogatástartalom + egyéb kedvezmények"]
[null,null,null,-0.04,null,"Ténylegesen felvett hitel támogatástartalma (EUR)",null,null,{"$f":"IF($C$10=\"EUR\",AU5,(AU5)/C12)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"kamat","támogatott",null,null,null,null,"dátumtól","tőke","kamat","támogatott",null,"dátumtól","amort","tőke","maradék","t maradék",null,null,null,"Periodus","Dátum","Tőke","Tőkeamt.","Kamatfiz.","Tőke","Tőkeamt.","Kamatfiz.",null,"FV","PV"]
[null,"Pénzügyi intézmény neve",null,null,null,{"$f":"\"Hitelösszeg (\"&C10&\")\"","v":"Hitelösszeg ()"},null,null,{"$f":"I3*C12","v":{"$error":"#DIV/0!"}},null,null,"A folyósítások összege kevesebb, mint a hitelösszeg",null,null,null,{"$f":"SUM(P7:P187)","v":0},{"$f":"SUM(Q7:Q187)","v":0},null,null,"A törlesztések összege nem egyezik meg a hitelösszeggel",null,null,null,{"$f":"SUM(X7:X187)","v":0},{"$f":"SUM(Y7:Y187)","v":0},null,null,null,null,{"$f":"SUM(AD7:AD187)","v":0},{"$f":"SUM(AE7:AE187)","v":0},null,null,null,null,null,{"$f":"+AK7","v":0},{"$f":"SUM(AL7:AL187)","v":0},{"$f":"SUM(AM7:AM187)","v":0},{"$f":"+AN7","v":0},{"$f":"SUM(AO7:AO187)","v":0},{"$f":"SUM(AP7:AP187)","v":0},null,{"$f":"SUM(AR7:AR187)","v":0},{"$f":"SUM(AS7:AS187)","v":0},null,{"$f":"AS5","v":0}]
[null,null,null,null,null,"Hitelre jutó támogatásintenzitás",null,null,{"$f":"IFERROR(I4*arfolyam/forintelszamolhato,0)","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(C25,MIN(L7:L210))","v":"00:00:00"}]
[null,null,null,null,null,"Kamatkedvezmény",null,null,{"$f":"MAX((C22-C28),0)","v":{"$error":"#N/A"}},{"$f":"AI7>$D$15","v":true},null,null,null,{"$f":"C25","v":"00:00:00"},{"$f":"IF(ISBLANK(L7),C11,0)","v":0},{"$f":"IF(AND(ISBLANK(L2),AH7<>1),0,IFERROR(-O7*piacikamat/365*(IF(ISBLANK(L7),$C$26,L7)-N7),\"\"))","v":""},{"$f":"IF(AND(ISBLANK(L2),AH7<>1),0,IFERROR(-O7*tenylegeskamat/365*(IF(ISBLANK(L7),$C$26,L7)-N7),\"\"))","v":0},{"$f":"IFERROR(IF(ISBLANK(L7),$C$26,L7)-N7,\"\")","v":0},null,null,null,{"$f":"IF(ISNA(MAX(T2,INDEX(AJ$6:AJ$210,MATCH(T7-1,AJ$6:AJ$210,1)))),\"\",MAX(T2,INDEX(AJ$6:AJ$210,MATCH(T7-1,AJ$6:AJ$210,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(W6),W6=\"\"),INDEX(AK$7:AK$210,MATCH(T7,AJ$7:AJ$210,1)),W6-U2),INDEX(AK$7:AK$210,MATCH(T7,AJ$7:AJ$210,1)))),\"\",MIN(IF(OR(ISBLANK(W6),W6=\"\"),INDEX(AK$7:AK$210,MATCH(T7,AJ$7:AJ$210,1)),W6-U2),INDEX(AK$7:AK$210,MATCH(T7,AJ$7:AJ$210,1))))","v":0},{"$f":"IFERROR(-W7*piacikamat/365*(T7-V7),\"\")","v":""},{"$f":"IFERROR(-W7*tenylegeskamat/365*(T7-V7),\"\")","v":""},{"$f":"IFERROR(T7-V7,\"\")","v":""},{"$f":"MAX(AJ6,IF(ISNA(INDEX(T$7:T$210,MATCH(AJ7,T$7:T$210,1))),0,INDEX(T$7:T$210,MATCH(AJ7,T$7:T$210,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(U$7:U$210,MATCH(AJ7,T$7:T$210,1))),0,INDEX(U$7:U$210,MATCH(AJ7,T$7:T$210,1)))","v":0},{"$f":"IF(ISNA(INDEX(W$7:W$210,MATCH(AJ7,T$7:T$210,1))),AK7,INDEX(W$7:W$210,MATCH(AJ7,T$7:T$210,1)))","v":0},{"$f":"IFERROR(-(AC7-AB7)*piacikamat/365*(AJ7-AA7),0)","v":0},{"$f":"IFERROR(-(AC7-AB7)*tenylegeskamat/365*(AJ7-AA7),0)","v":0},{"$f":"IFERROR(AJ7-AA7,\"\")","v":0},null,1,{"$f":"+IF(C27-C26<>0,1,\"\")","v":""},{"$f":"C26","v":"00:00:00"},{"$f":"IF(+C11<>0,C11,IF(AI7>0,C11*J7,\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ6,T$7:T$210,\"<=\"&AJ7),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK7)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},{"$f":"SUM(P7:P210)","v":0},{"$f":"+AK7","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ6,T$7:T$210,\"<=\"&AJ7),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN7)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},{"$f":"SUM(Q7:Q210)","v":0},null,{"$f":"IFERROR(MAX((ABS(AM7)-ABS(AP7)),0),\"\")","v":0},{"$f":"IFERROR(AR7/(1+($C$16+1%)/365*(AJ7-C24)),\"\")","v":0},{"$f":"IFERROR(AJ7-AJ6,\"\")","v":0}]
[null,"Hitel típusa, devizaneme",null,null,null,"Adott beruházási költséghez kapcsolódó támogatás teljes összege (EUR)",null,null,{"$f":"I4+C48+C52+C56+C61+C54","v":{"$error":"#DIV/0!"}},{"$f":"AI8>$D$15","v":true},null,null,null,{"$f":"IF(ISBLANK(L7),\"\",L7)","v":""},{"$f":"IF(ISBLANK(L7),0,M7+O7)","v":0},{"$f":"IF(AND(ISBLANK(L7),AH8<>1),0,IFERROR(-O8*piacikamat/365*(IF(ISBLANK(L8),$C$26,L8)-N8),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(L7),AH8<>1),0,IFERROR(-O8*tenylegeskamat/365*(IF(ISBLANK(L8),$C$26,L8)-N8),\"\"))","v":0},"",null,null,null,{"$f":"IF(ISNA(MAX(T7,INDEX(AJ$6:AJ$210,MATCH(T8-1,AJ$6:AJ$210,1)))),\"\",MAX(T7,INDEX(AJ$6:AJ$210,MATCH(T8-1,AJ$6:AJ$210,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(W7),W7=\"\"),INDEX(AK$7:AK$210,MATCH(T8,AJ$7:AJ$210,1)),W7-U7),INDEX(AK$7:AK$210,MATCH(T8,AJ$7:AJ$210,1)))),\"\",MIN(IF(OR(ISBLANK(W7),W7=\"\"),INDEX(AK$7:AK$210,MATCH(T8,AJ$7:AJ$210,1)),W7-U7),INDEX(AK$7:AK$210,MATCH(T8,AJ$7:AJ$210,1))))","v":0},"","","","00:00:00",0,0,0,0,"",null,2,{"$f":"IF(COUNT(AJ8)=1,AI7+1,\"\")","v":""},{"$f":"IF(OR(AJ7=$C$27,AJ7=\"\"),\"\",IFERROR(IF(EDATE($C$26,(AH8-1)*12/$D$19)<=$C$27,EDATE($C$26,(AH8-1)*12/$D$19),$C$27),\"\"))","v":""},{"$f":"+IF(COUNT(AK7)<>0,SUM(AK7:AL7)*(1-J8),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ7,T$7:T$210,\"<=\"&AJ8),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK8)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(X$7:X$210,T$7:T$210,\">\"&AJ7,T$7:T$210,\"<=\"&AJ8)+AD8,IFERROR(-AK8*piacikamat/365*(AJ8-AJ7),\"\"))","v":""},{"$f":"+IF(COUNT(AN7)<>0,SUM(AN7:AO7)*(1-J8),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ7,T$7:T$210,\"<=\"&AJ8),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN8)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Y$7:Y$210,T$7:T$210,\">\"&AJ7,T$7:T$210,\"<=\"&AJ8)+AE8,IFERROR(-AN8*tenylegeskamat/365*(AJ8-AJ7),\"\"))","v":""},null,{"$f":"IFERROR(MAX((ABS(AM8)-ABS(AP8)),0),\"\")","v":""},{"$f":"IFERROR(AR8/POWER(1+($C$16+1%)/$D$19,AI8-1)/(1+($C$16+1%)/365*($AJ$7-$C$24)),\"\")","v":""},""]
[null,"Hitel fajtája/célja","Beruházási hitel","Makrohoz kellenek (ne töröld ki!):",null,"Teljes (kumulált) támogatás intenzítása",null,null,{"$f":"I8*arfolyam/(forintelszamolhato)","v":{"$error":"#DIV/0!"}},true,null,null,null,{"$f":"IF(ISBLANK(L8),\"\",L8)","v":""},{"$f":"IF(ISBLANK(L8),0,M8+O8)","v":0},0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,3,{"$f":"IF(COUNT(AJ9)=1,AI8+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ8,T$7:T$210,\"<=\"&AJ9),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK9)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ8,T$7:T$210,\"<=\"&AJ9),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN9)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Hitel devizaneme",null,{"$f":"+C22/D19","v":{"$error":"#N/A"}},null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,4,{"$f":"IF(COUNT(AJ10)=1,AI9+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ9,T$7:T$210,\"<=\"&AJ10),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK10)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ9,T$7:T$210,\"<=\"&AJ10),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN10)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,{"$f":"\"Hitelösszeg (\"&C10&\")\"","v":"Hitelösszeg ()"},null,{"$f":"VLOOKUP(C19,Adatok!E4:H9,4,FALSE)/10000","v":{"$error":"#N/A"}},null,"Maximális támogatási mértékek",{"$f":"IF(OR(IF(ISERROR($I$9>G13),FALSE,$I$9>G13)),\"Nem jogosult\",IF($C$13/$C$12>30000000,\"Elérte a 30 millió eurót és emiatt nem finanszírozható\",\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(IF(ISERROR($I$9>H13),FALSE,$I$9>H13)),\"Nem jogosult\",IF($C$13/$C$12>30000000,\"Elérte a 30 millió eurót és emiatt nem finanszírozható\",\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(IF(ISERROR($I$9>I13),FALSE,$I$9>I13),C41=\"Nem éri el a 75%-ot\",C42=\"Nem\"),\"Nem jogosult\",IF(C41=\"Igen\", \"Egyedi intenzitás számítás szükséges\",IF($C$13/$C$12>30000000,\"Elérte a 30 millió eurót és emiatt nem finanszírozható\",\"\")))","v":{"$error":"#DIV/0!"}},true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,5,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ10,T$7:T$210,\"<=\"&AJ11),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK11)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ10,T$7:T$210,\"<=\"&AJ11),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN11)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,{"$f":"\"EUR/\"&C10&\" árfolyam\"","v":"EUR/ árfolyam"},null,1E-4,null,null,"38a cikk","38 cikk","41 cikk",true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,6,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ11,T$7:T$210,\"<=\"&AJ12),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK12)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ11,T$7:T$210,\"<=\"&AJ12),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN12)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,{"$f":"\"Elszámolható költségek (\"&C10&\")\"","v":"Elszámolható költségek ()"},null,null,null,"Maximális támogatásintenzitás (%)",{"$f":"IF(deminimiskizarok=0,\"Nem jogosult\",IF(C49<>\"ÁCSR 38 vagy 41-es jogcímen megítélt támogatás\",MIN(kalkulalt_alapintenzitas+Szamitasok!B13+Szamitasok!B15,C62),kalkulalt_alapintenzitas+Szamitasok!C13+Szamitasok!C15))","v":{"$error":"#N/A"}},{"$f":"IF(tizennegyeskizarok=0,\"Nem jogosult\",IF(C49<>\"ÁCSR 38 vagy 41-es jogcímen megítélt támogatás\",MIN(kalkulalt_alapintenzitas+Szamitasok!B13+Szamitasok!B15,C62),kalkulalt_alapintenzitas+Szamitasok!B13+Szamitasok!B15))/IF(C43=\"Nem\",2,1)","v":{"$error":"#N/A"}},{"$f":"IF(tizenheteskizarok=0,\"Nem jogosult\",IF(C49<>\"ÁCSR 38 vagy 41-es jogcímen megítélt támogatás\",MIN(kalkulalt_alapintenzitas+Szamitasok!B13,C62),kalkulalt_alapintenzitas+Szamitasok!B13))","v":{"$error":"#N/A"}},true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,7,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ12,T$7:T$210,\"<=\"&AJ13),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK13)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ12,T$7:T$210,\"<=\"&AJ13),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN13)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Az ügylet Zöld fejlesztési célú?","Igen",null,null,"Maximális hitelösszeg (az igényelt hitel devizanemében)",{"$f":"IF(deminimiskizarok=0,\"Nem jogosult\",IF(I9>G13,\"Nem finanszírozható\",hitelpertamogatasarany*G15))","v":{"$error":"#DIV/0!"}},{"$f":"IF(tizennegyeskizarok=0,\"Nem jogosult\",IF(I9>H13,\"Nem finanszírozható\",hitelpertamogatasarany*H15))","v":{"$error":"#DIV/0!"}},{"$f":"IF(tizenheteskizarok=0,\"Nem jogosult\",IF(I9>I13,\"Nem finanszírozható\",hitelpertamogatasarany*I15))","v":{"$error":"#DIV/0!"}},true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,8,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ13,T$7:T$210,\"<=\"&AJ14),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK14)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ13,T$7:T$210,\"<=\"&AJ14),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN14)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Piaci kamat meghatározása",null,{"$f":"COUNT(AI7:AI210)","v":0},null,"Maximális támogatástartalom (az igényelt hitel devizanemében)",{"$f":"IF(deminimiskizarok<>0,IF(I9>G13,\"Nem finanszírozható\",MAX(MAX((G13*(forintelszamolhato)-C52-C48),0)-C61,0)),\"Nem jogosult\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(tizennegyeskizarok<>0,IF(I9>H13,\"Nem finanszírozható\",MAX(MAX((H13*(forintelszamolhato)-C54-C48),0)-C61,0)),\"Nem jogosult\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(tizenheteskizarok<>0,IF(I9>I13,\"Nem finanszírozható\",MAX(MAX((I13*(forintelszamolhato)-C56-C48),0)-C61,0)),\"Nem jogosult\")","v":{"$error":"#DIV/0!"}},true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,9,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ14,T$7:T$210,\"<=\"&AJ15),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK15)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ14,T$7:T$210,\"<=\"&AJ15),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN15)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Referencia alapkamat",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,10,{"$f":"IF(COUNT(AJ16)=1,AI15+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ15,T$7:T$210,\"<=\"&AJ16),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK16)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ15,T$7:T$210,\"<=\"&AJ16),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN16)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Van hitelfelvevői múltja vagy mérleg alapú hitelminősítése a hitelfelvevőnek?",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,11,{"$f":"IF(COUNT(AJ17)=1,AI16+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ16,T$7:T$210,\"<=\"&AJ17),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK17)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ16,T$7:T$210,\"<=\"&AJ17),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN17)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Cégbesorolás",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,12,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ17,T$7:T$210,\"<=\"&AJ18),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK18)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ17,T$7:T$210,\"<=\"&AJ18),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN18)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Adósminősítés",null,{"$f":"VLOOKUP($C$30,Adatok!R3:S5,2,0)","v":{"$error":"#N/A"}},null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,13,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ18,T$7:T$210,\"<=\"&AJ19),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK19)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ18,T$7:T$210,\"<=\"&AJ19),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN19)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Fedezettség",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,14,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ19,T$7:T$210,\"<=\"&AJ20),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK20)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ19,T$7:T$210,\"<=\"&AJ20),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN20)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Kockázati felár (bázispont)",{"$f":"IF(C17=\"Van\",OFFSET(Adatok!$E$4,MATCH(C19,Adatok!$E$5:$E$9,0),MATCH(C20,Adatok!$F$4:$H$4,0),),MAX(OFFSET(Adatok!$E$4,MATCH(C19,Adatok!$E$5:$E$9,0),MATCH(C20,Adatok!$F$4:$H$4,0),),400))","v":{"$error":"#N/A"}},null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,15,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ20,T$7:T$210,\"<=\"&AJ21),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK21)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ20,T$7:T$210,\"<=\"&AJ21),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN21)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Egyéni referencia kamatláb",{"$f":"+(C16+C21/10000)","v":{"$error":"#N/A"}},null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,16,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ21,T$7:T$210,\"<=\"&AJ22),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK22)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ21,T$7:T$210,\"<=\"&AJ22),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN22)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Hitelkarakterisztika",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,17,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ22,T$7:T$210,\"<=\"&AJ23),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK23)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ22,T$7:T$210,\"<=\"&AJ23),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN23)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Hitel jóváhagyásának várható időpontja (EXIM döntés dátuma)",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,18,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ23,T$7:T$210,\"<=\"&AJ24),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK24)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ23,T$7:T$210,\"<=\"&AJ24),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN24)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Szerződéskötés várható dátuma",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,19,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ24,T$7:T$210,\"<=\"&AJ25),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK25)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ24,T$7:T$210,\"<=\"&AJ25),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN25)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,{"$f":"IF(C26>EDATE(C25,36),\"A türelmi időszak maximum 36 hónap lehet\",\"Első törlesztés várható dátuma\")","v":"Első törlesztés várható dátuma"},null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,20,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ25,T$7:T$210,\"<=\"&AJ26),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK26)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ25,T$7:T$210,\"<=\"&AJ26),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN26)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,{"$f":"IF(C27>EDATE(C25,180),\"A futamidő maximum 180 hónap lehet\",\"Hitel végső lejáratának várható dátuma\")","v":"Hitel végső lejáratának várható dátuma"},null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,21,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ26,T$7:T$210,\"<=\"&AJ27),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK27)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ26,T$7:T$210,\"<=\"&AJ27),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN27)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,{"$f":"\"Ügyleti kamat\"&IF(ROUND(piacikamat-tenylegeskamat,17)<0.0001,\" - Ezzel a kamatszinttel az ügylet nem finanszírozható!\",IF(tenylegeskamat>IF(C10=\"HUF\",refkammax_2,IF(AND(C10=\"EUR\"),refkammax_3,refkammax)),\" - A kamatfelár mértéke nem haladhatja meg a refinanszírozási kölcsön kamatláb + 4%-ot!\",\"\"))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,22,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ27,T$7:T$210,\"<=\"&AJ28),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK28)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ27,T$7:T$210,\"<=\"&AJ28),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN28)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Törlesztés módja",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,23,{"$f":"IF(COUNT(AJ29)=1,AI28+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ28,T$7:T$210,\"<=\"&AJ29),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK29)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ28,T$7:T$210,\"<=\"&AJ29),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN29)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,{"$f":"IF(torlesztes=\"Egyenlő tőke\",\"Kamatfizetés/tőketörlesztés gyakorisága\",\"Kamatfizetés gyakorisága\")","v":"Kamatfizetés gyakorisága"},null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,24,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ29,T$7:T$210,\"<=\"&AJ30),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK30)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ29,T$7:T$210,\"<=\"&AJ30),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN30)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Hiteligénylőre és hitelcélra vonatkozó adatok",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,25,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ30,T$7:T$210,\"<=\"&AJ31),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK31)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ30,T$7:T$210,\"<=\"&AJ31),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN31)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Hiteligénylő cég besorolása",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,26,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ31,T$7:T$210,\"<=\"&AJ32),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK32)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ31,T$7:T$210,\"<=\"&AJ32),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN32)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Megkezdte a beruházást a hitelkérelem beadását megelőzően?",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,27,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ32,T$7:T$210,\"<=\"&AJ33),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK33)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ32,T$7:T$210,\"<=\"&AJ33),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN33)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"37/2011. (III. 22.) Korm. Rendelet 6. §-a alapján nehéz helyzetben lévőnek minősül",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,28,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ33,T$7:T$210,\"<=\"&AJ34),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK34)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ33,T$7:T$210,\"<=\"&AJ34),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN34)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Beruházás helyszíne ",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,29,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ34,T$7:T$210,\"<=\"&AJ35),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK35)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ34,T$7:T$210,\"<=\"&AJ35),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN35)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Beruházás célja",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,30,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ35,T$7:T$210,\"<=\"&AJ36),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK36)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ35,T$7:T$210,\"<=\"&AJ36),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN36)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,31,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ36,T$7:T$210,\"<=\"&AJ37),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK37)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ36,T$7:T$210,\"<=\"&AJ37),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN37)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Ingatlan energiahatékonysági korszerűsítés esetében az energiahatékonysági javulás mértéke eléri a 40%-ot?",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,32,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ37,T$7:T$210,\"<=\"&AJ38),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK38)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ37,T$7:T$210,\"<=\"&AJ38),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN38)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"A beruházás a végrehajtásától számított 18 hónapon belül az épület energiahatékonyságát az uniós szabványnak minősülő energiahatékonysági minimumkövetelmények által előírt szint fölé javítja?",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,33,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ38,T$7:T$210,\"<=\"&AJ39),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK39)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ38,T$7:T$210,\"<=\"&AJ39),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN39)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"A megújuló energia beruházás tartalmaz megújuló energia tárolási kapacitás kialakítását is?",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,34,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ39,T$7:T$210,\"<=\"&AJ40),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK40)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ39,T$7:T$210,\"<=\"&AJ40),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN40)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"A beruházás célja legalább 75%-ban közvetlenül összekapcsolt megújuló energia tárolását jelentő kapacitás létrehozása továbbá megújuló energia előállítása vegyesen?",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,35,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ40,T$7:T$210,\"<=\"&AJ41),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK41)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ40,T$7:T$210,\"<=\"&AJ41),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN41)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"A beruházás célja kizárólag legalább 75%-ban közvetlenül összekapcsolt megújuló energia tárolását szolgáló kapacitás létrehozása",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,36,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ41,T$7:T$210,\"<=\"&AJ42),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK42)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ41,T$7:T$210,\"<=\"&AJ42),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN42)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Energiahatékonysági beruházás esetén az elszámolható költség kontrafaktuális forgatókönyv alapján került meghatározásra?",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,37,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ42,T$7:T$210,\"<=\"&AJ43),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK43)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ42,T$7:T$210,\"<=\"&AJ43),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN43)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",{"$f":"IFERROR(AJ43-AJ42,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,"",null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,38,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ43,T$7:T$210,\"<=\"&AJ44),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK44)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ43,T$7:T$210,\"<=\"&AJ44),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN44)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Korábban megítélt állami támogatások*",null,null,null,null,null,null,null,true,null,null,null,{"$f":"IF(ISBLANK(L44),\"\",L44)","v":""},{"$f":"IF(ISBLANK(L44),0,M44+O44)","v":0},0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,39,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ44,T$7:T$210,\"<=\"&AJ45),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK45)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ44,T$7:T$210,\"<=\"&AJ45),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN45)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,40,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ45,T$7:T$210,\"<=\"&AJ46),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK46)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ45,T$7:T$210,\"<=\"&AJ46),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN46)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Azonos elszámolható költségkörhöz kapcsolódó kapcsolódóan megítélt támogatások",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,41,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ46,T$7:T$210,\"<=\"&AJ47),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK47)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ46,T$7:T$210,\"<=\"&AJ47),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN47)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"De minimis alapon megítélt támogatások (EUR)",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,42,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ47,T$7:T$210,\"<=\"&AJ48),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK48)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ47,T$7:T$210,\"<=\"&AJ48),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN48)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"ÁCSR/EMVA csoportmentességi támogatásokhoz kapcsolódó azonos elszámolható költséghez megítélt állami támogatások",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,43,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ48,T$7:T$210,\"<=\"&AJ49),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK49)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ48,T$7:T$210,\"<=\"&AJ49),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN49)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,44,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ49,T$7:T$210,\"<=\"&AJ50),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK50)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ49,T$7:T$210,\"<=\"&AJ50),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN50)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Megítélt ÁCSR 38a. cikk szerinti beruházási támogatások",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,45,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ50,T$7:T$210,\"<=\"&AJ51),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK51)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ50,T$7:T$210,\"<=\"&AJ51),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN51)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"ÁCSR 38a. cikk szerint megítélt beruházási támogatások (EUR)",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,46,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ51,T$7:T$210,\"<=\"&AJ52),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK52)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ51,T$7:T$210,\"<=\"&AJ52),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN52)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Megítélt ÁCSR 38. cikk szerinti beruházási támogatások",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,47,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ52,T$7:T$210,\"<=\"&AJ53),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK53)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ52,T$7:T$210,\"<=\"&AJ53),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN53)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"ÁCSR 38. cikk szerint megítélt beruházási támogatások (EUR)",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,48,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ53,T$7:T$210,\"<=\"&AJ54),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK54)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ53,T$7:T$210,\"<=\"&AJ54),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN54)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Megítélt ÁCSR 41. cikk szerinti beruházási támogatások",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,49,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ54,T$7:T$210,\"<=\"&AJ55),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK55)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ54,T$7:T$210,\"<=\"&AJ55),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN55)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"ÁCSR 41. cikk szerint megítélt beruházási támogatások (EUR)",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,50,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ55,T$7:T$210,\"<=\"&AJ56),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK56)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ55,T$7:T$210,\"<=\"&AJ56),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN56)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,51,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ56,T$7:T$210,\"<=\"&AJ57),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK57)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ56,T$7:T$210,\"<=\"&AJ57),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN57)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Egyéb támogatás",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,52,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ57,T$7:T$210,\"<=\"&AJ58),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK58)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ57,T$7:T$210,\"<=\"&AJ58),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN58)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Korábban megítélt támogatások rendeleti alapja",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,53,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ58,T$7:T$210,\"<=\"&AJ59),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK59)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ58,T$7:T$210,\"<=\"&AJ59),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN59)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Korábban megítélt állami támogatások jogcíme",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,54,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ59,T$7:T$210,\"<=\"&AJ60),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK60)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ59,T$7:T$210,\"<=\"&AJ60),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN60)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Korábban megítélt állami támogatások összege (EUR)",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,55,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ60,T$7:T$210,\"<=\"&AJ61),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK61)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ60,T$7:T$210,\"<=\"&AJ61),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN61)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"Egyéb támogatás maximális támogatásintenzitása, %-ban",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,56,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ61,T$7:T$210,\"<=\"&AJ62),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK62)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ61,T$7:T$210,\"<=\"&AJ62),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN62)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,57,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ62,T$7:T$210,\"<=\"&AJ63),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK63)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ62,T$7:T$210,\"<=\"&AJ63),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN63)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"*Amennyiben az ügyfél nem a B37-B52 szerinti támogatásokat kapott, akkor az ügyletet az Eximbank egyedileg vizsgálja",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,58,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ63,T$7:T$210,\"<=\"&AJ64),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK64)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ63,T$7:T$210,\"<=\"&AJ64),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN64)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,59,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ64,T$7:T$210,\"<=\"&AJ65),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK65)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ64,T$7:T$210,\"<=\"&AJ65),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN65)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,"További kedvezmények igénybevétele",null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,60,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ65,T$7:T$210,\"<=\"&AJ66),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK66)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ65,T$7:T$210,\"<=\"&AJ66),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN66)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,{"$f":"IF($C$12=\"HUF\",\"Monitoring díj (HUF)\",\"Monitoring díj (EUR)\")","v":"Monitoring díj (EUR)"},null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,61,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ66,T$7:T$210,\"<=\"&AJ67),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK67)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ66,T$7:T$210,\"<=\"&AJ67),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN67)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,{"$f":"IF($C$12=\"HUF\",\"Egyszeri díj (HUF)\",\"Egyszeri díj (EUR)\")","v":"Egyszeri díj (EUR)"},null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,62,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ67,T$7:T$210,\"<=\"&AJ68),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK68)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ67,T$7:T$210,\"<=\"&AJ68),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN68)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,63,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ68,T$7:T$210,\"<=\"&AJ69),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK69)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ68,T$7:T$210,\"<=\"&AJ69),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN69)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,64,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ69,T$7:T$210,\"<=\"&AJ70),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK70)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ69,T$7:T$210,\"<=\"&AJ70),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN70)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,{"$f":"IF(ISNA(MAX(T70,INDEX(AJ$6:AJ$210,MATCH(T71-1,AJ$6:AJ$210,1)))),\"\",MAX(T70,INDEX(AJ$6:AJ$210,MATCH(T71-1,AJ$6:AJ$210,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(W70),W70=\"\"),INDEX(AK$7:AK$210,MATCH(T71,AJ$7:AJ$210,1)),W70-U70),INDEX(AK$7:AK$210,MATCH(T71,AJ$7:AJ$210,1)))),\"\",MIN(IF(OR(ISBLANK(W70),W70=\"\"),INDEX(AK$7:AK$210,MATCH(T71,AJ$7:AJ$210,1)),W70-U70),INDEX(AK$7:AK$210,MATCH(T71,AJ$7:AJ$210,1))))","v":0},{"$f":"IFERROR(-W71*piacikamat/365*(T71-V71),\"\")","v":""},{"$f":"IFERROR(-W71*tenylegeskamat/365*(T71-V71),\"\")","v":""},{"$f":"IFERROR(T71-V71,\"\")","v":""},{"$f":"MAX(AJ70,IF(ISNA(INDEX(T$7:T$210,MATCH(AJ71,T$7:T$210,1))),0,INDEX(T$7:T$210,MATCH(AJ71,T$7:T$210,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(U$7:U$210,MATCH(AJ71,T$7:T$210,1))),0,INDEX(U$7:U$210,MATCH(AJ71,T$7:T$210,1)))","v":0},{"$f":"IF(ISNA(INDEX(W$7:W$210,MATCH(AJ71,T$7:T$210,1))),AK71,INDEX(W$7:W$210,MATCH(AJ71,T$7:T$210,1)))","v":0},{"$f":"IFERROR(-(AC71-AB71)*piacikamat/365*(AJ71-AA71),0)","v":0},{"$f":"IFERROR(-(AC71-AB71)*tenylegeskamat/365*(AJ71-AA71),0)","v":0},{"$f":"IFERROR(AJ71-AA71,\"\")","v":""},null,65,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ70,T$7:T$210,\"<=\"&AJ71),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK71)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ70,T$7:T$210,\"<=\"&AJ71),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN71)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"AI72>$D$15","v":true},null,null,null,"",0,{"$f":"IF(AND(ISBLANK(L71),AH72<>1),0,IFERROR(-O72*piacikamat/365*(IF(ISBLANK(L72),$C$26,L72)-N72),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(L71),AH72<>1),0,IFERROR(-O72*tenylegeskamat/365*(IF(ISBLANK(L72),$C$26,L72)-N72),\"\"))","v":0},null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,66,"",{"$f":"IF(OR(AJ71=$C$27,AJ71=\"\"),\"\",IFERROR(IF(EDATE($C$26,(AH72-1)*12/$D$19)<=$C$27,EDATE($C$26,(AH72-1)*12/$D$19),$C$27),\"\"))","v":""},{"$f":"+IF(COUNT(AK71)<>0,SUM(AK71:AL71)*(1-J72),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ71,T$7:T$210,\"<=\"&AJ72),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK72)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(X$7:X$210,T$7:T$210,\">\"&AJ71,T$7:T$210,\"<=\"&AJ72)+AD72,IFERROR(-AK72*piacikamat/365*(AJ72-AJ71),\"\"))","v":""},{"$f":"+IF(COUNT(AN71)<>0,SUM(AN71:AO71)*(1-J72),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ71,T$7:T$210,\"<=\"&AJ72),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN72)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Y$7:Y$210,T$7:T$210,\">\"&AJ71,T$7:T$210,\"<=\"&AJ72)+AE72,IFERROR(-AN72*tenylegeskamat/365*(AJ72-AJ71),\"\"))","v":""},null,{"$f":"IFERROR(MAX((ABS(AM72)-ABS(AP72)),0),\"\")","v":""},{"$f":"IFERROR(AR72/POWER(1+($C$16+1%)/$D$19,AI72-1)/(1+($C$16+1%)/365*($AJ$7-$C$24)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,67,{"$f":"IF(COUNT(AJ73)=1,AI72+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ72,T$7:T$210,\"<=\"&AJ73),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK73)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ72,T$7:T$210,\"<=\"&AJ73),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN73)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,68,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ73,T$7:T$210,\"<=\"&AJ74),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK74)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ73,T$7:T$210,\"<=\"&AJ74),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN74)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,69,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ74,T$7:T$210,\"<=\"&AJ75),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK75)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ74,T$7:T$210,\"<=\"&AJ75),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN75)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,70,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ75,T$7:T$210,\"<=\"&AJ76),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK76)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ75,T$7:T$210,\"<=\"&AJ76),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN76)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,71,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ76,T$7:T$210,\"<=\"&AJ77),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK77)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ76,T$7:T$210,\"<=\"&AJ77),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN77)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,72,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ77,T$7:T$210,\"<=\"&AJ78),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK78)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ77,T$7:T$210,\"<=\"&AJ78),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN78)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,73,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ78,T$7:T$210,\"<=\"&AJ79),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK79)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ78,T$7:T$210,\"<=\"&AJ79),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN79)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,74,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ79,T$7:T$210,\"<=\"&AJ80),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK80)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ79,T$7:T$210,\"<=\"&AJ80),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN80)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,75,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ80,T$7:T$210,\"<=\"&AJ81),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK81)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ80,T$7:T$210,\"<=\"&AJ81),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN81)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,76,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ81,T$7:T$210,\"<=\"&AJ82),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK82)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ81,T$7:T$210,\"<=\"&AJ82),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN82)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,77,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ82,T$7:T$210,\"<=\"&AJ83),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK83)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ82,T$7:T$210,\"<=\"&AJ83),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN83)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,78,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ83,T$7:T$210,\"<=\"&AJ84),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK84)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ83,T$7:T$210,\"<=\"&AJ84),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN84)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,79,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ84,T$7:T$210,\"<=\"&AJ85),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK85)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ84,T$7:T$210,\"<=\"&AJ85),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN85)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,80,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ85,T$7:T$210,\"<=\"&AJ86),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK86)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ85,T$7:T$210,\"<=\"&AJ86),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN86)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,81,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ86,T$7:T$210,\"<=\"&AJ87),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK87)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ86,T$7:T$210,\"<=\"&AJ87),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN87)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,82,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ87,T$7:T$210,\"<=\"&AJ88),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK88)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ87,T$7:T$210,\"<=\"&AJ88),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN88)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,83,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ88,T$7:T$210,\"<=\"&AJ89),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK89)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ88,T$7:T$210,\"<=\"&AJ89),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN89)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,84,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ89,T$7:T$210,\"<=\"&AJ90),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK90)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ89,T$7:T$210,\"<=\"&AJ90),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN90)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,85,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ90,T$7:T$210,\"<=\"&AJ91),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK91)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ90,T$7:T$210,\"<=\"&AJ91),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN91)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,86,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ91,T$7:T$210,\"<=\"&AJ92),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK92)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ91,T$7:T$210,\"<=\"&AJ92),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN92)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,87,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ92,T$7:T$210,\"<=\"&AJ93),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK93)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ92,T$7:T$210,\"<=\"&AJ93),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN93)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,88,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ93,T$7:T$210,\"<=\"&AJ94),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK94)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ93,T$7:T$210,\"<=\"&AJ94),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN94)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,89,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ94,T$7:T$210,\"<=\"&AJ95),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK95)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ94,T$7:T$210,\"<=\"&AJ95),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN95)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,90,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ95,T$7:T$210,\"<=\"&AJ96),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK96)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ95,T$7:T$210,\"<=\"&AJ96),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN96)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,91,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ96,T$7:T$210,\"<=\"&AJ97),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK97)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ96,T$7:T$210,\"<=\"&AJ97),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN97)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,92,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ97,T$7:T$210,\"<=\"&AJ98),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK98)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ97,T$7:T$210,\"<=\"&AJ98),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN98)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,93,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ98,T$7:T$210,\"<=\"&AJ99),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK99)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ98,T$7:T$210,\"<=\"&AJ99),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN99)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,94,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ99,T$7:T$210,\"<=\"&AJ100),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK100)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ99,T$7:T$210,\"<=\"&AJ100),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN100)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,95,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ100,T$7:T$210,\"<=\"&AJ101),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK101)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ100,T$7:T$210,\"<=\"&AJ101),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN101)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,96,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ101,T$7:T$210,\"<=\"&AJ102),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK102)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ101,T$7:T$210,\"<=\"&AJ102),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN102)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,97,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ102,T$7:T$210,\"<=\"&AJ103),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK103)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ102,T$7:T$210,\"<=\"&AJ103),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN103)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,98,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ103,T$7:T$210,\"<=\"&AJ104),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK104)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ103,T$7:T$210,\"<=\"&AJ104),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN104)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,99,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ104,T$7:T$210,\"<=\"&AJ105),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK105)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ104,T$7:T$210,\"<=\"&AJ105),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN105)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,100,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ105,T$7:T$210,\"<=\"&AJ106),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK106)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ105,T$7:T$210,\"<=\"&AJ106),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN106)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,101,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ106,T$7:T$210,\"<=\"&AJ107),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK107)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ106,T$7:T$210,\"<=\"&AJ107),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN107)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",{"$f":"IFERROR(AJ107-AJ106,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,102,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ107,T$7:T$210,\"<=\"&AJ108),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK108)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ107,T$7:T$210,\"<=\"&AJ108),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN108)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,{"$f":"IF(ISBLANK(L108),\"\",L108)","v":""},{"$f":"IF(ISBLANK(L108),0,M108+O108)","v":0},0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,103,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ108,T$7:T$210,\"<=\"&AJ109),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK109)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ108,T$7:T$210,\"<=\"&AJ109),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN109)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,104,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ109,T$7:T$210,\"<=\"&AJ110),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK110)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ109,T$7:T$210,\"<=\"&AJ110),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN110)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,105,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ110,T$7:T$210,\"<=\"&AJ111),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK111)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ110,T$7:T$210,\"<=\"&AJ111),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN111)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,106,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ111,T$7:T$210,\"<=\"&AJ112),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK112)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ111,T$7:T$210,\"<=\"&AJ112),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN112)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,107,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ112,T$7:T$210,\"<=\"&AJ113),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK113)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ112,T$7:T$210,\"<=\"&AJ113),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN113)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,108,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ113,T$7:T$210,\"<=\"&AJ114),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK114)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ113,T$7:T$210,\"<=\"&AJ114),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN114)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,109,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ114,T$7:T$210,\"<=\"&AJ115),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK115)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ114,T$7:T$210,\"<=\"&AJ115),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN115)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,110,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ115,T$7:T$210,\"<=\"&AJ116),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK116)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ115,T$7:T$210,\"<=\"&AJ116),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN116)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,111,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ116,T$7:T$210,\"<=\"&AJ117),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK117)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ116,T$7:T$210,\"<=\"&AJ117),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN117)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,112,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ117,T$7:T$210,\"<=\"&AJ118),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK118)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ117,T$7:T$210,\"<=\"&AJ118),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN118)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,113,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ118,T$7:T$210,\"<=\"&AJ119),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK119)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ118,T$7:T$210,\"<=\"&AJ119),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN119)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,114,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ119,T$7:T$210,\"<=\"&AJ120),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK120)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ119,T$7:T$210,\"<=\"&AJ120),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN120)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,115,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ120,T$7:T$210,\"<=\"&AJ121),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK121)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ120,T$7:T$210,\"<=\"&AJ121),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN121)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,116,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ121,T$7:T$210,\"<=\"&AJ122),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK122)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ121,T$7:T$210,\"<=\"&AJ122),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN122)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,117,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ122,T$7:T$210,\"<=\"&AJ123),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK123)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ122,T$7:T$210,\"<=\"&AJ123),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN123)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,118,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ123,T$7:T$210,\"<=\"&AJ124),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK124)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ123,T$7:T$210,\"<=\"&AJ124),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN124)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,119,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ124,T$7:T$210,\"<=\"&AJ125),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK125)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ124,T$7:T$210,\"<=\"&AJ125),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN125)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,120,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ125,T$7:T$210,\"<=\"&AJ126),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK126)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ125,T$7:T$210,\"<=\"&AJ126),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN126)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,121,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ126,T$7:T$210,\"<=\"&AJ127),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK127)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ126,T$7:T$210,\"<=\"&AJ127),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN127)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,122,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ127,T$7:T$210,\"<=\"&AJ128),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK128)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ127,T$7:T$210,\"<=\"&AJ128),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN128)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,123,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ128,T$7:T$210,\"<=\"&AJ129),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK129)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ128,T$7:T$210,\"<=\"&AJ129),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN129)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,124,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ129,T$7:T$210,\"<=\"&AJ130),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK130)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ129,T$7:T$210,\"<=\"&AJ130),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN130)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,125,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ130,T$7:T$210,\"<=\"&AJ131),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK131)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ130,T$7:T$210,\"<=\"&AJ131),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN131)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,126,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ131,T$7:T$210,\"<=\"&AJ132),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK132)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ131,T$7:T$210,\"<=\"&AJ132),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN132)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,127,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ132,T$7:T$210,\"<=\"&AJ133),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK133)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ132,T$7:T$210,\"<=\"&AJ133),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN133)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,128,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ133,T$7:T$210,\"<=\"&AJ134),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK134)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ133,T$7:T$210,\"<=\"&AJ134),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN134)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,{"$f":"IF(ISNA(MAX(T134,INDEX(AJ$6:AJ$210,MATCH(T135-1,AJ$6:AJ$210,1)))),\"\",MAX(T134,INDEX(AJ$6:AJ$210,MATCH(T135-1,AJ$6:AJ$210,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(W134),W134=\"\"),INDEX(AK$7:AK$210,MATCH(T135,AJ$7:AJ$210,1)),W134-U134),INDEX(AK$7:AK$210,MATCH(T135,AJ$7:AJ$210,1)))),\"\",MIN(IF(OR(ISBLANK(W134),W134=\"\"),INDEX(AK$7:AK$210,MATCH(T135,AJ$7:AJ$210,1)),W134-U134),INDEX(AK$7:AK$210,MATCH(T135,AJ$7:AJ$210,1))))","v":0},{"$f":"IFERROR(-W135*piacikamat/365*(T135-V135),\"\")","v":""},{"$f":"IFERROR(-W135*tenylegeskamat/365*(T135-V135),\"\")","v":""},{"$f":"IFERROR(T135-V135,\"\")","v":""},{"$f":"MAX(AJ134,IF(ISNA(INDEX(T$7:T$210,MATCH(AJ135,T$7:T$210,1))),0,INDEX(T$7:T$210,MATCH(AJ135,T$7:T$210,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(U$7:U$210,MATCH(AJ135,T$7:T$210,1))),0,INDEX(U$7:U$210,MATCH(AJ135,T$7:T$210,1)))","v":0},{"$f":"IF(ISNA(INDEX(W$7:W$210,MATCH(AJ135,T$7:T$210,1))),AK135,INDEX(W$7:W$210,MATCH(AJ135,T$7:T$210,1)))","v":0},{"$f":"IFERROR(-(AC135-AB135)*piacikamat/365*(AJ135-AA135),0)","v":0},{"$f":"IFERROR(-(AC135-AB135)*tenylegeskamat/365*(AJ135-AA135),0)","v":0},{"$f":"IFERROR(AJ135-AA135,\"\")","v":""},null,129,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ134,T$7:T$210,\"<=\"&AJ135),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK135)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ134,T$7:T$210,\"<=\"&AJ135),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN135)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"AI136>$D$15","v":true},null,null,null,"",0,{"$f":"IF(AND(ISBLANK(L135),AH136<>1),0,IFERROR(-O136*piacikamat/365*(IF(ISBLANK(L136),$C$26,L136)-N136),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(L135),AH136<>1),0,IFERROR(-O136*tenylegeskamat/365*(IF(ISBLANK(L136),$C$26,L136)-N136),\"\"))","v":0},null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,130,"",{"$f":"IF(OR(AJ135=$C$27,AJ135=\"\"),\"\",IFERROR(IF(EDATE($C$26,(AH136-1)*12/$D$19)<=$C$27,EDATE($C$26,(AH136-1)*12/$D$19),$C$27),\"\"))","v":""},{"$f":"+IF(COUNT(AK135)<>0,SUM(AK135:AL135)*(1-J136),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ135,T$7:T$210,\"<=\"&AJ136),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK136)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(X$7:X$210,T$7:T$210,\">\"&AJ135,T$7:T$210,\"<=\"&AJ136)+AD136,IFERROR(-AK136*piacikamat/365*(AJ136-AJ135),\"\"))","v":""},{"$f":"+IF(COUNT(AN135)<>0,SUM(AN135:AO135)*(1-J136),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ135,T$7:T$210,\"<=\"&AJ136),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN136)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Y$7:Y$210,T$7:T$210,\">\"&AJ135,T$7:T$210,\"<=\"&AJ136)+AE136,IFERROR(-AN136*tenylegeskamat/365*(AJ136-AJ135),\"\"))","v":""},null,{"$f":"IFERROR(MAX((ABS(AM136)-ABS(AP136)),0),\"\")","v":""},{"$f":"IFERROR(AR136/POWER(1+($C$16+1%)/$D$19,AI136-1)/(1+($C$16+1%)/365*($AJ$7-$C$24)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,131,{"$f":"IF(COUNT(AJ137)=1,AI136+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ136,T$7:T$210,\"<=\"&AJ137),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK137)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ136,T$7:T$210,\"<=\"&AJ137),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN137)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,132,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ137,T$7:T$210,\"<=\"&AJ138),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK138)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ137,T$7:T$210,\"<=\"&AJ138),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN138)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,133,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ138,T$7:T$210,\"<=\"&AJ139),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK139)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ138,T$7:T$210,\"<=\"&AJ139),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN139)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,134,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ139,T$7:T$210,\"<=\"&AJ140),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK140)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ139,T$7:T$210,\"<=\"&AJ140),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN140)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,135,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ140,T$7:T$210,\"<=\"&AJ141),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK141)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ140,T$7:T$210,\"<=\"&AJ141),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN141)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,136,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ141,T$7:T$210,\"<=\"&AJ142),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK142)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ141,T$7:T$210,\"<=\"&AJ142),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN142)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,137,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ142,T$7:T$210,\"<=\"&AJ143),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK143)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ142,T$7:T$210,\"<=\"&AJ143),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN143)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,138,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ143,T$7:T$210,\"<=\"&AJ144),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK144)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ143,T$7:T$210,\"<=\"&AJ144),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN144)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,139,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ144,T$7:T$210,\"<=\"&AJ145),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK145)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ144,T$7:T$210,\"<=\"&AJ145),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN145)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,140,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ145,T$7:T$210,\"<=\"&AJ146),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK146)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ145,T$7:T$210,\"<=\"&AJ146),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN146)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,141,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ146,T$7:T$210,\"<=\"&AJ147),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK147)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ146,T$7:T$210,\"<=\"&AJ147),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN147)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,142,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ147,T$7:T$210,\"<=\"&AJ148),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK148)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ147,T$7:T$210,\"<=\"&AJ148),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN148)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,143,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ148,T$7:T$210,\"<=\"&AJ149),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK149)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ148,T$7:T$210,\"<=\"&AJ149),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN149)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,144,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ149,T$7:T$210,\"<=\"&AJ150),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK150)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ149,T$7:T$210,\"<=\"&AJ150),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN150)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,145,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ150,T$7:T$210,\"<=\"&AJ151),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK151)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ150,T$7:T$210,\"<=\"&AJ151),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN151)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,146,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ151,T$7:T$210,\"<=\"&AJ152),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK152)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ151,T$7:T$210,\"<=\"&AJ152),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN152)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,147,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ152,T$7:T$210,\"<=\"&AJ153),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK153)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ152,T$7:T$210,\"<=\"&AJ153),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN153)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,148,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ153,T$7:T$210,\"<=\"&AJ154),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK154)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ153,T$7:T$210,\"<=\"&AJ154),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN154)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,149,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ154,T$7:T$210,\"<=\"&AJ155),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK155)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ154,T$7:T$210,\"<=\"&AJ155),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN155)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,150,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ155,T$7:T$210,\"<=\"&AJ156),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK156)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ155,T$7:T$210,\"<=\"&AJ156),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN156)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,151,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ156,T$7:T$210,\"<=\"&AJ157),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK157)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ156,T$7:T$210,\"<=\"&AJ157),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN157)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,152,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ157,T$7:T$210,\"<=\"&AJ158),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK158)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ157,T$7:T$210,\"<=\"&AJ158),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN158)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,153,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ158,T$7:T$210,\"<=\"&AJ159),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK159)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ158,T$7:T$210,\"<=\"&AJ159),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN159)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,154,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ159,T$7:T$210,\"<=\"&AJ160),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK160)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ159,T$7:T$210,\"<=\"&AJ160),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN160)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,155,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ160,T$7:T$210,\"<=\"&AJ161),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK161)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ160,T$7:T$210,\"<=\"&AJ161),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN161)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,156,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ161,T$7:T$210,\"<=\"&AJ162),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK162)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ161,T$7:T$210,\"<=\"&AJ162),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN162)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,157,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ162,T$7:T$210,\"<=\"&AJ163),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK163)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ162,T$7:T$210,\"<=\"&AJ163),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN163)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,158,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ163,T$7:T$210,\"<=\"&AJ164),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK164)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ163,T$7:T$210,\"<=\"&AJ164),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN164)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,159,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ164,T$7:T$210,\"<=\"&AJ165),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK165)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ164,T$7:T$210,\"<=\"&AJ165),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN165)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,160,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ165,T$7:T$210,\"<=\"&AJ166),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK166)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ165,T$7:T$210,\"<=\"&AJ166),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN166)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,161,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ166,T$7:T$210,\"<=\"&AJ167),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK167)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ166,T$7:T$210,\"<=\"&AJ167),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN167)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,162,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ167,T$7:T$210,\"<=\"&AJ168),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK168)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ167,T$7:T$210,\"<=\"&AJ168),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN168)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,163,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ168,T$7:T$210,\"<=\"&AJ169),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK169)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ168,T$7:T$210,\"<=\"&AJ169),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN169)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,164,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ169,T$7:T$210,\"<=\"&AJ170),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK170)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ169,T$7:T$210,\"<=\"&AJ170),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN170)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,165,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ170,T$7:T$210,\"<=\"&AJ171),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK171)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ170,T$7:T$210,\"<=\"&AJ171),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN171)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",{"$f":"IFERROR(AJ171-AJ170,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,166,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ171,T$7:T$210,\"<=\"&AJ172),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK172)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ171,T$7:T$210,\"<=\"&AJ172),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN172)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,{"$f":"IF(ISBLANK(L172),\"\",L172)","v":""},{"$f":"IF(ISBLANK(L172),0,M172+O172)","v":0},0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,167,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ172,T$7:T$210,\"<=\"&AJ173),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK173)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ172,T$7:T$210,\"<=\"&AJ173),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN173)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,168,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ173,T$7:T$210,\"<=\"&AJ174),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK174)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ173,T$7:T$210,\"<=\"&AJ174),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN174)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,169,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ174,T$7:T$210,\"<=\"&AJ175),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK175)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ174,T$7:T$210,\"<=\"&AJ175),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN175)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,170,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ175,T$7:T$210,\"<=\"&AJ176),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK176)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ175,T$7:T$210,\"<=\"&AJ176),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN176)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,171,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ176,T$7:T$210,\"<=\"&AJ177),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK177)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ176,T$7:T$210,\"<=\"&AJ177),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN177)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,172,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ177,T$7:T$210,\"<=\"&AJ178),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK178)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ177,T$7:T$210,\"<=\"&AJ178),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN178)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,173,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ178,T$7:T$210,\"<=\"&AJ179),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK179)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ178,T$7:T$210,\"<=\"&AJ179),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN179)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,174,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ179,T$7:T$210,\"<=\"&AJ180),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK180)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ179,T$7:T$210,\"<=\"&AJ180),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN180)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,175,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ180,T$7:T$210,\"<=\"&AJ181),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK181)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ180,T$7:T$210,\"<=\"&AJ181),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN181)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,176,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ181,T$7:T$210,\"<=\"&AJ182),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK182)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ181,T$7:T$210,\"<=\"&AJ182),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN182)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,177,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ182,T$7:T$210,\"<=\"&AJ183),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK183)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ182,T$7:T$210,\"<=\"&AJ183),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN183)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,178,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ183,T$7:T$210,\"<=\"&AJ184),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK184)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ183,T$7:T$210,\"<=\"&AJ184),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN184)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,179,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ184,T$7:T$210,\"<=\"&AJ185),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK185)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ184,T$7:T$210,\"<=\"&AJ185),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN185)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,180,{"$f":"IF(COUNT(AJ186)=1,AI185+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ185,T$7:T$210,\"<=\"&AJ186),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK186)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ185,T$7:T$210,\"<=\"&AJ186),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN186)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,181,{"$f":"IF(COUNT(AJ187)=1,AI186+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ186,T$7:T$210,\"<=\"&AJ187),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK187)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ186,T$7:T$210,\"<=\"&AJ187),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN187)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,182,{"$f":"IF(COUNT(AJ188)=1,AI187+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ187,T$7:T$210,\"<=\"&AJ188),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK188)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ187,T$7:T$210,\"<=\"&AJ188),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN188)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,183,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ188,T$7:T$210,\"<=\"&AJ189),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK189)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ188,T$7:T$210,\"<=\"&AJ189),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN189)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,184,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ189,T$7:T$210,\"<=\"&AJ190),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK190)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ189,T$7:T$210,\"<=\"&AJ190),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN190)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,185,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ190,T$7:T$210,\"<=\"&AJ191),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK191)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ190,T$7:T$210,\"<=\"&AJ191),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN191)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,186,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ191,T$7:T$210,\"<=\"&AJ192),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK192)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ191,T$7:T$210,\"<=\"&AJ192),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN192)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,187,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ192,T$7:T$210,\"<=\"&AJ193),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK193)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ192,T$7:T$210,\"<=\"&AJ193),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN193)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,188,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ193,T$7:T$210,\"<=\"&AJ194),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK194)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ193,T$7:T$210,\"<=\"&AJ194),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN194)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,189,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ194,T$7:T$210,\"<=\"&AJ195),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK195)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ194,T$7:T$210,\"<=\"&AJ195),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN195)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,190,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ195,T$7:T$210,\"<=\"&AJ196),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK196)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ195,T$7:T$210,\"<=\"&AJ196),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN196)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,191,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ196,T$7:T$210,\"<=\"&AJ197),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK197)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ196,T$7:T$210,\"<=\"&AJ197),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN197)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,192,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ197,T$7:T$210,\"<=\"&AJ198),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK198)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ197,T$7:T$210,\"<=\"&AJ198),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN198)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,{"$f":"IF(ISNA(MAX(T198,INDEX(AJ$6:AJ$210,MATCH(T199-1,AJ$6:AJ$210,1)))),\"\",MAX(T198,INDEX(AJ$6:AJ$210,MATCH(T199-1,AJ$6:AJ$210,1))))","v":""},{"$f":"IF(ISNA(MIN(IF(OR(ISBLANK(W198),W198=\"\"),INDEX(AK$7:AK$210,MATCH(T199,AJ$7:AJ$210,1)),W198-U198),INDEX(AK$7:AK$210,MATCH(T199,AJ$7:AJ$210,1)))),\"\",MIN(IF(OR(ISBLANK(W198),W198=\"\"),INDEX(AK$7:AK$210,MATCH(T199,AJ$7:AJ$210,1)),W198-U198),INDEX(AK$7:AK$210,MATCH(T199,AJ$7:AJ$210,1))))","v":0},{"$f":"IFERROR(-W199*piacikamat/365*(T199-V199),\"\")","v":""},{"$f":"IFERROR(-W199*tenylegeskamat/365*(T199-V199),\"\")","v":""},{"$f":"IFERROR(T199-V199,\"\")","v":""},{"$f":"MAX(AJ198,IF(ISNA(INDEX(T$7:T$210,MATCH(AJ199,T$7:T$210,1))),0,INDEX(T$7:T$210,MATCH(AJ199,T$7:T$210,1))))","v":"00:00:00"},{"$f":"IF(ISNA(INDEX(U$7:U$210,MATCH(AJ199,T$7:T$210,1))),0,INDEX(U$7:U$210,MATCH(AJ199,T$7:T$210,1)))","v":0},{"$f":"IF(ISNA(INDEX(W$7:W$210,MATCH(AJ199,T$7:T$210,1))),AK199,INDEX(W$7:W$210,MATCH(AJ199,T$7:T$210,1)))","v":0},{"$f":"IFERROR(-(AC199-AB199)*piacikamat/365*(AJ199-AA199),0)","v":0},{"$f":"IFERROR(-(AC199-AB199)*tenylegeskamat/365*(AJ199-AA199),0)","v":0},{"$f":"IFERROR(AJ199-AA199,\"\")","v":""},null,193,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ198,T$7:T$210,\"<=\"&AJ199),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK199)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ198,T$7:T$210,\"<=\"&AJ199),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN199)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"AI200>$D$15","v":true},null,null,null,"",0,{"$f":"IF(AND(ISBLANK(L199),AH200<>1),0,IFERROR(-O200*piacikamat/365*(IF(ISBLANK(L200),$C$26,L200)-N200),\"\"))","v":0},{"$f":"IF(AND(ISBLANK(L199),AH200<>1),0,IFERROR(-O200*tenylegeskamat/365*(IF(ISBLANK(L200),$C$26,L200)-N200),\"\"))","v":0},null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,194,"",{"$f":"IF(OR(AJ199=$C$27,AJ199=\"\"),\"\",IFERROR(IF(EDATE($C$26,(AH200-1)*12/$D$19)<=$C$27,EDATE($C$26,(AH200-1)*12/$D$19),$C$27),\"\"))","v":""},{"$f":"+IF(COUNT(AK199)<>0,SUM(AK199:AL199)*(1-J200),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ199,T$7:T$210,\"<=\"&AJ200),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK200)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(X$7:X$210,T$7:T$210,\">\"&AJ199,T$7:T$210,\"<=\"&AJ200)+AD200,IFERROR(-AK200*piacikamat/365*(AJ200-AJ199),\"\"))","v":""},{"$f":"+IF(COUNT(AN199)<>0,SUM(AN199:AO199)*(1-J200),\"\")","v":0},{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ199,T$7:T$210,\"<=\"&AJ200),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN200)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},{"$f":"IF(torlesztes=\"Egyedi\",SUMIFS(Y$7:Y$210,T$7:T$210,\">\"&AJ199,T$7:T$210,\"<=\"&AJ200)+AE200,IFERROR(-AN200*tenylegeskamat/365*(AJ200-AJ199),\"\"))","v":""},null,{"$f":"IFERROR(MAX((ABS(AM200)-ABS(AP200)),0),\"\")","v":""},{"$f":"IFERROR(AR200/POWER(1+($C$16+1%)/$D$19,AI200-1)/(1+($C$16+1%)/365*($AJ$7-$C$24)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,195,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ200,T$7:T$210,\"<=\"&AJ201),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK201)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ200,T$7:T$210,\"<=\"&AJ201),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN201)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,196,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ201,T$7:T$210,\"<=\"&AJ202),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK202)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ201,T$7:T$210,\"<=\"&AJ202),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN202)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,197,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ202,T$7:T$210,\"<=\"&AJ203),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK203)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ202,T$7:T$210,\"<=\"&AJ203),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN203)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,198,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ203,T$7:T$210,\"<=\"&AJ204),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK204)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ203,T$7:T$210,\"<=\"&AJ204),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN204)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,199,{"$f":"IF(COUNT(AJ205)=1,AI204+1,\"\")","v":""},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ204,T$7:T$210,\"<=\"&AJ205),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK205)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ204,T$7:T$210,\"<=\"&AJ205),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN205)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,200,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ205,T$7:T$210,\"<=\"&AJ206),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK206)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ205,T$7:T$210,\"<=\"&AJ206),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN206)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,201,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ206,T$7:T$210,\"<=\"&AJ207),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK207)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ206,T$7:T$210,\"<=\"&AJ207),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN207)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,202,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ207,T$7:T$210,\"<=\"&AJ208),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK208)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ207,T$7:T$210,\"<=\"&AJ208),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN208)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,203,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ208,T$7:T$210,\"<=\"&AJ209),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK209)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ208,T$7:T$210,\"<=\"&AJ209),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN209)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]
[null,null,null,null,null,null,null,null,null,true,null,null,null,"",0,0,0,null,null,null,null,"",0,"","","","00:00:00",0,0,0,0,"",null,204,"","",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ209,T$7:T$210,\"<=\"&AJ210),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AK$7:AK210)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",0,{"$f":"IF(torlesztes=\"Egyedi\",-SUMIFS(U$7:U$210,T$7:T$210,\">\"&AJ209,T$7:T$210,\"<=\"&AJ210),IFERROR(IF(torlesztes=\"Egyenlő tőke\",IF(COUNT($AN$7:AN210)>$D$15,\"\",-$AK$5/$D$15),0),\"\"))","v":0},"",null,"","",""]

{"sheet":"Szamitasok","index":2,"n_rows":25,"n_cols":22,"rows_kept":25,"cut":false,"hidden":true,"merged":[[19,0,19,8],[17,0,17,8],[21,0,21,8],[0,0,0,8],[2,0,2,1],[6,0,6,8],[7,0,7,8]]}
["Kizárók és KO-k"]
[null,null,null,"Váll. Méret","Halászat/akvakultúra",null,"Szélessávú infrasrtukúra","Kutatási infrastruktúra","Külföldi hálózathoz?","Mezőgazdasági termékek?",null,"Katonai berendezések","Fizetésképtelen?","Kollektív fizetésképtelen?","Nehéz helyzetben?",null,null,"A létesítményt bezárták",null,"Az üzletet piaci feltételek mellett bonyolítják le a vásárlást","Amennyiben immateriális eszköz beruházásáról van szó, akkor értékcsökkenést lehet rá elszámolni","Megkezdte a beruházást a hitelkérelem beadását megelőzően?"]
["Szorzó értéke",null,null,{"$f":"Tamogatastartalom!C32","v":0},"Nem",null,"Nem","Nem","Nem","Nem",null,"Nem","Nem","Nem",{"$f":"Tamogatastartalom!C34","v":0},null,null,"Nem releváns",null,"Igen","Nem releváns",{"$f":"Tamogatastartalom!C33","v":0}]
[{"$f":"PRODUCT(C4:W4)","v":1},"De minimis (38A?)",null,1,{"$f":"IF($E$3=\"Igen\",0,1)","v":1},null,{"$f":"IF(G3=\"Igen\",0,1)","v":1},null,{"$f":"IF($I$3=\"Igen\",0,1)","v":1},{"$f":"IF($J$3=\"Igen\",0,1)","v":1},null,{"$f":"IF($L$3=\"Igen\",0,1)","v":1},{"$f":"IF($M$3=\"Igen\",0,1)","v":1},{"$f":"IF($N$3=\"Igen\",0,1)","v":1},{"$f":"IF($O$3=\"Igen\",0,1)","v":1},null,null,null,null,null,null,{"$f":"IF($V$3=\"Igen\",0,1)","v":1}]
[{"$f":"PRODUCT(C5:W5)","v":1},"38as ",null,1,{"$f":"IF($E$3=\"Igen\",0,1)","v":1},null,{"$f":"IF(G3=\"Igen\",0,1)","v":1},{"$f":"IF(H3=\"Igen\",0,1)","v":1},{"$f":"IF($I$3=\"Igen\",0,1)","v":1},{"$f":"IF($J$3=\"Igen\",0,1)","v":1},null,{"$f":"IF($L$3=\"Igen\",0,1)","v":1},{"$f":"IF($M$3=\"Igen\",0,1)","v":1},{"$f":"IF($N$3=\"Igen\",0,1)","v":1},{"$f":"IF($O$3=\"Igen\",0,1)","v":1},null,null,{"$f":"IF($R$3=\"Nem\",0,1)","v":1},null,{"$f":"IF($T$3=\"Nem\",0,1)","v":1},{"$f":"IF($U$3=\"Nem\",0,1)","v":1},{"$f":"IF($V$3=\"Igen\",0,1)","v":1}]
[{"$f":"PRODUCT(C6:W6)","v":1},"41-es",null,1,{"$f":"IF($E$3=\"Igen\",0,1)","v":1},null,{"$f":"IF(G3=\"Igen\",0,1)","v":1},{"$f":"IF(H3=\"Igen\",0,1)","v":1},{"$f":"IF($I$3=\"Igen\",0,1)","v":1},{"$f":"IF($J$3=\"Igen\",0,1)","v":1},null,{"$f":"IF($L$3=\"Igen\",0,1)","v":1},{"$f":"IF($M$3=\"Igen\",0,1)","v":1},{"$f":"IF($N$3=\"Igen\",0,1)","v":1},{"$f":"IF($O$3=\"Igen\",0,1)","v":1},null,null,{"$f":"IF($R$3=\"Nem\",0,1)","v":1},null,{"$f":"IF($T$3=\"Nem\",0,1)","v":1},{"$f":"IF($U$3=\"Nem\",0,1)","v":1},{"$f":"IF($V$3=\"Igen\",0,1)","v":1}]
["14-es cikk",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E feletti mező biztos jó így?"]
["R szorzó értéke"]
["Elszámolható ktg-ek EUR-ban",{"$f":"Tamogatastartalom!C13/arfolyam","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))","v":0}]
["38a jógcím",{"$f":"VLOOKUP(Tamogatastartalom!C36,Adatok!A17:B22,2)","v":{"$error":"#N/A"}}]
["Régió bónusz",{"$f":"VLOOKUP(Tamogatastartalom!C35,Adatok!A12:B14,2,FALSE)","v":{"$error":"#N/A"}}]
["R szorzó értéke a támogatási térkép alapján",{"$f":"(B15+B13)","v":{"$error":"#N/A"}}]
[]
["17-es cikk"]
["Vállalatméret-szorzó",{"$f":"IF(D3=\"Közepes\",0.1,0)","v":0}]
[{"$f":"Tamogatastartalom!C10&\" érték\"","v":" érték"}]
[{"$f":"\"Elszámolható ktg-ek \"&Tamogatastartalom!C10&\"-ban\"","v":"Elszámolható ktg-ek -ban"},{"$f":"Tamogatastartalom!C13","v":0}]
["Hitel/támogatástartalom arány"]
["Hitelösszeg",{"$f":"Tamogatastartalom!C11","v":0}]
["Támogatástartalom a futamidő alatt",{"$f":"Tamogatastartalom!AS5","v":0}]
["Hitelösszeg/támogatástartalom",{"$f":"B23/B24","v":{"$error":"#DIV/0!"}}]

{"sheet":"Adatok","index":3,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":true,"merged":[[9,0,9,11],[0,14,0,24],[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,null,null,"Segédszámítások"]
[null,null,null,"Piaci referencia",null,null,null,null,null,"Refin kamatok",null,null,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,"EUR nem zöld/USD","HUF nem zöld","HUF zöld","EUR zöld","Egyenlő összeg",1,null,"Havi",12,null,"Beruházási hitel"]
[null,null,null,null,null,"Magas","Általános","Alacsony",null,null,null,null,null,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,null,null,null,null,null,"Egyedi",0,null,"Féléves",2,null,"Lízing/Eszköz alapú kölcsön"]
[null,null,null,null,"Jó",75,100,220,null,"Min",1,1,{"$f":"refkam-5%","v":-0.05},{"$f":"refkam-0.005","v":-5.0000000000000001E-3}]
[null,null,null,null,"Kielégítő",100,220,400,null,"Max",{"$f":"refkammin+4%","v":1.04},{"$f":"refkammin_1+4%","v":1.04},{"$f":"refkammin_2+4%","v":-1.0000000000000002E-2},{"$f":"refkammin_3+4%","v":3.5000000000000003E-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,null,null,null,null,null,"Nem kapcsolódik"]
["Select",0,null,null,null,null,null,null,"ÁCSR 38 vagy 41-es jogcímen megítélt támogatás",null,null,null,null,null,null,null,"Egyéb ÁCSR"]
["Budapest",0,null,null,null,null,null,null,"Egyéb jogcímen megítélt támogatás",null,null,null,null,null,null,null,"EMVA"]
["Vidék",0.15,null,null,null,null,null,null,"ÁCSR 38 vagy 41-es és Egyéb jogcímen megítélt támogatás",null,null,null,null,null,null,null,"Egyéb"]
[]
[null,"Alapintenzitás",null,"Kalkulált alapintenzitás"]
["Select",0,null,{"$f":"VLOOKUP(Tamogatastartalom!C36,A17:B22,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null," "]
["energiahatékonysági beruházás – gép, technológia",0.3]
["energiahatékonysági – ingatlan korszerűsítés 1 épületelem (pl. falszigetelés vagy tetőszigetelés)",0.25]
["ingatlan energiahatékonysági korszerűsítés – ingatlan (komplett)",{"$f":"IF(AND(Tamogatastartalom!C38=\"Igen\",Tamogatastartalom!C39=\"Igen\"),0.45,0.3)","v":0.3}]
["új ingatlan építés",0.3]
["megújuló energia beruházás",{"$f":"IF(OR(Tamogatastartalom!C41=\"Igen\",Tamogatastartalom!C42=\"Igen\"),0.3,0.45)","v":0.45}]