M1 "*" Termeszeti kornyezet (Naturaszfera) = AVERAGE ( M11, M12, M14, M15, M16 ); M11 "*" Fold = AVERAGE ( M111, M112, M113, M114 ); M111 "*" Fekves = AVERAGE ( M1111, M1112, M1113, M1114); M1111 "*" Budapest megkozelitese = T + M - 1; T = EXIST("A1122") ? QUALIFY ( A1122, 5, 1, 30,60,100,200) : 1; M = EXIST("A11221") ? QUALIFY ( A11221, 5, 1, 30,60,100,200) : 1; M1112 "*" Makrokozpont megkozelitese = T + M - 1; T = EXIST("A1123") ? QUALIFY ( A1123, 5, 1, 25,50,75,100) : 1; M = EXIST("A11231") ? QUALIFY ( A11231, 5, 1, 20,40,80,100) : 1; M1113 "*" Mezokozpont megkozelitese = T + M - 1; T = EXIST("A1124") ? QUALIFY ( A1124, 5, 1, 15,30,45,60) : 1; M = EXIST("A11241") ? QUALIFY ( A11241, 5, 1, 15,30,45,60) : 1; M1114 "*" Mikrokozpont megkozelitese = (A > 9) ? 9 : A; T = EXIST("A1125") ? QUALIFY ( A1125, 4, 1, 10,15,20) : 1; M = EXIST("A11251") ? QUALIFY ( A11251, 4, 1, 10,15,20) : 1; G = EXIST("A11252") ? QUALIFY ( A11252, 2, 0, 30, 60 ) : 0; A = T + M + G; M112 "*" Terepviszonyok = AVERAGE ( M1121, M1122 ); M1121 "*" Tengerszint feletti magassag = M + R - 1; M = EXIST("A1131") ? QUALIFY ( A1131, 5, 1, 150, 200, 250, 300 ) : 1; R = (EXIST("A1132") && EXIST("A1131")) ? QUALIFY ( A1132 - A1131, 5, 1, 25, 50, 100, 200 ) : 1; M1122 "*" Tagoltsag = MIN(T + M + L, 9.0); T = 5 - EXIST1("A1161", 1, 4, 5); M = 5 - EXIST1("A1162", 1, 4, 5); L = (A1151 > 50) ? 4 : 0 + ((A1151 + A1152) > 50) ? 3 : 0 + ((A1151 + A1152 + A1153) > 50) ? 2 : 1; M113 "B" Banyakincs = AVERAGE ( M1131, M1132); M1131 "*" Banyakincs jelentosege = EXIST1("A19562", 1, 9, 0); M1132 "*" Lelohely megkozelitese = T + J - 1; T = EXIST("A19571") ? QUALIFY (A19571, 5, 1, 3, 5, 10, 20) : 1; J = EXIST("A19572") ? QUALIFY (A19572, 1, 5, 2, 3, 4, 5) : 1; M114 "B" Talajviszonyok = AVERAGE ( M1141, M1142, M1143 ); M1141 "B" Talajminoseg = QUALIFY ( A147, 1, 9, 15, 25, 35, 45, 55, 65, 75, 85 ); M1142 "B" Talajosszetetel = F + K; F = QUALIFY ( A1441, 1, 4, 40, 60, 80 ); K = (A148 < 6) ? QUALIFY (A148, 1, 5, 2, 3, 4, 5) : QUALIFY (A148, 5, 1, 6, 7, 8, 9 ); M1143 "B" Talajpusztulas = EXIST("A1438") ? QUALIFY (A1438 / A171 * 100, 9, 1, 5, 15, 25, 35, 45, 55, 65, 75 ) : 1; M12 "*" Eghajlat - levego = AVERAGE ( M121, M122); M121 "*" Napfenytartam = QUALIFY (A, 0, 9, 1, 1750, 1800, 1850, 1900, 1950, 2000, 2050, 2100 ); B = A124003 - A124001; H = (B < 45) ? 1.3 : (B < 50) ? 1.1 : (B < 55) ? 1.0 : (B < 60) ? 0.9 : 0.7; A = EXIST("A122") ? A122 * H : 0; M122 "*" Csapadekviszonyok mikroklima = QUALIFY (A, 1, 9, 15, 25, 35, 45, 55, 65, 75, 85); E = QUALIFY ( A123, 1, 5, 500,600,700,800); V = QUALIFY ( A12303 + A12304 + A12305 + A12306 + A12307 + A12308 + A12309 + A12310, 1, 5, 250,300,350,400 ); M = (A1252 != 0) ? 0.7 : (A1253 != 0) ? 0.9 : (1254 != 0) ? 1 : (A1255 != 0) ? 1.1 : (A1256 != 0) ? 1.3 : 0; A = (E + V - 1) * M * 10; M13 "*" Viz = AVERAGE(M131, M132, M133); M131 "*" Vizrajzi viszonyok = AVERAGE(M1311, M1312); M1311 "B" Vizrajzi jelleg = F + R + T - 1; F = 6 - EXIST1("A1514", 1, 5, 6); R = EXIST1("A1524", 1, 5, 0); T = (A1521 > 2 && A1521 < 6) ? 2 : 1; M1312 "B" Termal es gyogyviz = (A < 2) ? 1 : (A > 9) ? 9 : A; M = QUALIFY(A16104 + A16203, 1, 5, 50, 100, 250, 500); C = QUALIFY(A16106, 0, 4, 20, 30, 50, 80); T = QUALIFY(A16205, 0, 4, 20, 30, 50, 80); H = EXIST("A16210"); A = M + C + T + H - 1; M132 "*" Vizkeszlet = AVERAGE(M1321, M1322); M1321 "B" Felszini vizmennyiseg = F + A - 1; F = QUALIFY(A15123, 1, 7, 10, 50, 100, 500, 1000, 2000); A = QUALIFY(A151352 + A151362, 1, 3, 1000, 10000); M1322 "B" Felszin alatti vizmennyiseg = H + M - 1; H = QUALIFY(A16102, 1, 5, 10, 20, 50, 100); M = QUALIFY(A16103, 1, 5, 25, 50, 100, 250); M133 "B" Viz kartetele = A + B - 1; C = (A1882 * 5 + A1883 * 4 + A1884 * 3 + A1885 * 2 + A1886) / A171; A = (C > 5) ? 5 : (C < 1) ? 1 : C; D = (A1887 * 5 + A18871 * 4 + A18872 * 3 + A18873 * 2 + A18874) / A171; B = (D > 5) ? 5 : (D < 1) ? 1 : D; M14 "*" Elovilag, taj = AVERAGE ( M141, M142); M141 "B" Elovilag = F + V; F = QUALIFY ( A181 % A171, 1, 7, 10,20,30,40,50,60); V = EXIST1("A1810", 1, 2, 0); M142 "B" Tajvedelmi objektumok = (A < 2 ) ? 1 : A; T = EXIST1("A1741", 1, 4, 0); O = EXIST1("A1751", 1, 6, 0); A = T + O - 1; M15 "*" Termeszeti eroforrasok hasznositasa = AVERAGE (M151, M152, M153, M154 ); M151 "B" Banyakincs hasznositasa = H + I - 1; H = EXIST1("A19561", 1, 5, 0); I = QUALIFY(A195616, 1, 5, 10, 20, 30, 40); M152 "*" Foldhasznositas alap = AVERAGE (M1521, M1522, M1523 ); M1521 "B" Termoterulet hasznositasa = T - P + K - 1; T = QUALIFY(A1721, 1, 5, 1000, 5000, 10000, 15000); P = QUALIFY(A1721001 % A171 * 100, 0, 2, 5, 500); K = QUALIFY(A146, 1, 5, 10, 15, 25, 35); M1522 "B" Foldhasznositas intenzitasa = QUALIFY(A, 1, 9, 75, 95, 105, 125, 150, 175, 200, 250); A = (0.5 * A1722 + A17216 + 2 * A17212 + 4 * (A17213 + A17214 + A17215)) / A1721 * 100; M1523 "B" Muveles alol kivont terulet = QUALIFY(A, 1, 9, 50, 95, 105, 150, 200, 250, 300, 400); A = (0.1 * A17251 + 0.3 * A17252 + A17253 + 3 * A17254 + 6 * A17255) / A1725 * 100; M153 "*" Vizhasznositas = AVERAGE(M1531, M1532, M1533); M1531 "B" Ipari es energianyero vizhasznositas = MAX(I + E - 1, 0.0); I = A1531; E = A1532; M1532 "B" Mezogazdasagi es halaszati vizhasznositas = M + H - 1; M = QUALIFY(A1726, 1, 6, 50, 100, 200, 500, 1000); H = (A17574 < 1) ? 1 : (A17574 > 4) ? 4 : A17574; M1533 "B" Kozlekedesi es kommulais vizhasznositas = K + V - 1; K = (A17351 < 1) ? 1 : (A17351 > 6) ? 6 : A17351; V = EXIST1("A15203", 1, 4, 0); M154 "*" Tajhasznositas = AVERAGE(M1541, M1542); M1541 "B" Udules, gyogyudules = U + G - 1; U = (A1745 < 1) ? 1 : (A1745 > 5) ? 5 : A1745; G = (A44374 < 1) ? 1 : (A44374 > 5 ) ? 5 : A44374; M1542 "B" Turisztika, horgaszat, vadaszat = (T + U + V + H) / 2; T = (A17571 < 1) ? 1 : (A17571 > 5) ? 5 : A17571; U = (A17572 < 1) ? 1 : (A17572 > 4) ? 4 : A17572; V = (A17573 < 1) ? 1 : (A17573 > 5) ? 5 : A17573; H = (A17574 < 1) ? 4 : (A17574 > 5) ? 4 : A17574; M16 "*" Termeszeti kornyeet karosodasa, szennyezodese = AVERAGE ( M161, M162, M163); M161 "*" Talajszennyezes = AVERAGE(M1611, M1612, M1613); M1611 "B" Fizikai talajszennyezes = 10 - EXIST1("A189311", 1, 9, 10); M1612 "B" Kemia talajszennyezes = 10 - EXIST1("A189312", 1, 9, 10); M1613 "B" Biologiai talajszennyezes = 10 - EXIST1("A189313", 1, 9, 10); M162 "*" Levegoszennyezes = AVERAGE(M1621, M1622, M1623); M1621 "B" Fizikai levegoszennyezes = 10 - ("A189311", 1, 0, 10); M1622 "B" Kemia levegoszennyezes = 10 - EXIST1("A189322", 1, 9, 10); M1623 "B" Egyeb levegoszennyezes = 10 - EXIST1("A189323", 1, 9, 10); M163 "*" Vizszennyezes = AVERAGE(M1631, M1632, M1633); M1631 "B" Fizikai vizszennyezes = 10 - EXIST1("A189331", 1, 9, 10); M1632 "B" Kemia vizszennyezes = 10 - EXIST1("A189332", 1, 9, 10); M1633 "B" Biologiai levegoszennyezes = 10 - EXIST1("A189333", 1, 9, 10); M164 "*" Elovilag karosodasa = AVERAGE(M1641, M1642, M1643); M1641 "B" Elovilag fizikai karosodasa = 10 - EXIST1("A189341", 1, 9, 10); M1642 "B" Elovilag kemiai karosodasa = 10 - EXIST1("A189342", 1, 9, 10); M1643 "B" Elovilag biologiai es egyeb karosodasa = 10 - EXIST1("A189343", 1, 9, 10); M165 "*" Tajrombolas = AVERAGE(M1651, M1652, M1653); M1651 "B" Banyaszati tajrombolas = 10 - EXIST1("A189351", 1, 9, 10); M1652 "B" Epitesi epitoanyagipari tajrombolas = 10 - EXIST1("A189352", 1, 9, 10); M1653 "B" Egyeb tajrombolas (antropogen hatasok) = 10 - EXIST1("A189353", 1, 9, 10); M2 "*" Nepesseg (Socialszfera) = AVERAGE(M21, M22, M23, M24); M21 "*" Nepessegszam = AVERAGE(M211, M212, M213, M214); M211 "C" Nepessegszam = QUALIFY(A213 / 1000, 1, 9, 0.1, 0.5, 1, 3, 5, 10, 25, 50); M212 "A" Nepmozgalom = N + T - 1; N = QUALIFY((A213 - A2141) % A213, 1, 5, 0.5, 1, 2, 3); T = QUALIFY(A213 % A2141, 1, 5, 99, 100, 105, 110); M213 "A" Nepsuruseg = (A < 1000) ? QUALIFY(A, 1, 9, 40, 70, 100, 130, 200, 300, 400, 500) : (A < 1250) ? 8 : 7; A = A213 / A171; M214 "C" Neptomorules = B + L - 1; B = QUALIFY(A2131 % A213, 1, 5, 50, 75, 95, 99.9); L = QUALIFY(A2134, 5, 1, 1, 3, 10, 15); M22 "*" Nepesseg = AVERAGE(M221, M222, M223); M221 "*" Demografiai osszetetel = AVERAGE(M2211, M2212, M2213, M2214, M2215, M2216, M2217); M2211 "A" Nemek aranya = QUALIFY(A2312 % A2311, 1, 9, 85, 90, 95, 99, 101, 105, 110, 115); M2212 "A" Kormegoszlas = P + F - 1; P = QUALIFY(A2322 % A213, 1, 5, 57.5, 62, 62.5, 65); F = QUALIFY(A2323 % A2321, 1, 5, 30, 55, 80, 105); M2213 "A" Csaladi allapot = H + E - 1; H = QUALIFY((A24413 + A24414) % A213, 1, 6, 50, 51, 52, 53, 54); E = EXIST("A24417") ? QUALIFY(A24417 % A213, 4, 0, 1.1, 1.5, 2.5, 5.0) : 2; M2214 "C" Etnikai osszetetel = (H + V + E + S) / 2; H = EXIST1("A2451", 1, 9, 0); V = 4 - EXIST1("A2452", 1, 3, 4); E = 4 - EXIST1("A2463", 1, 3, 4); S = QUALIFY(A2454, 3, 1, 1, 2); M2215 "C" Vilagfelfogasbeli osszetetel = (H + N + E + S) / 2; H = EXIST1("A2461", 1, 9, 0); N = 4 - EXIST1("A2462", 1, 3, 4); E = 4 - EXIST1("A2463", 1, 3, 4); S = QUALIFY(A2462, 3, 1, 1, 2); M2216 "C" Szuletesi hely = QUALIFY((A2471 + 0.5 * A2472) % A213, 1, 9, 10, 20, 30, 40, 50, 60, 70, 80); M2217 "A" Iskolai vegzettseg = QUALIFY(((A262 + A26311) * 0.25 + A26312 * 0.5 + A2632 * 0.8 + A2633 + A2641 * 3 + A2642 * 4 + A2651 * 7 + A2652 * 10) / A261, 1, 9, 1.0, 1.2, 1.4, 1.6, 1.8, 2.0, 2.2, 2.5); M222 "*" Foglalkozasi, kereseti viszonyok = AVERAGE(M2221, M2222, M2223, M2224); M2221 "A" Foglalkoztatottsag merteke = E + I - 1; E = EXIST("A283") ? QUALIFY(A283 % A213, 5, 1, 37.5, 40, 42.5, 45) : 1; I = QUALIFY((A282 + A28531) % A283, 5, 1, 20, 24, 28, 32); M2222 "A" Foglalkoztatas iranya = D + B + C; A = A2841 + A2842 + A2844 + A2845; B = ((A2841 + A2842) % A281 - (A2843 + A2844 + A2845) % A281 < 10) ? 0 : 1; C = (A < 30 && A2841 % A281 > 50 && A2841 % A281 < 60) ? 1 : 0; D = (A < 30) ? 0 : (A < 70) ? 3 : 7; M2223 "C" Foglalkozasi viszony = (O > 75) ? 9 : (O > 50 && S > 25) ? 8 : (O > 50) ? 7 : (O > 25 && S > 25 && F < 25) ? 6 : (O > 25 && S < 25) ? 5 : (O > 25 && S > 50) ? 4 : (O > 25) ? 3 : (O < 25 && S > 50) ? 2 : 1; O = A294 % A281; F = A2931 % A281; S = A2932 % A281; M2224 "C" Kereseti jovedelmi viszonyok = QUALIFY(A28411, 1 , 9, 15, 25, 35, 45, 55, 65, 75, 85); M223 "*" Szocialis helyzet = AVERAGE(M2231, M2232, M2233); M2231 "C" Munkanelkuliek = M + P - 1; M = QUALIFY(A2851 % A281, 5, 1, 10, 20, 30, 40); P = QUALIFY(A2852 % A285, 5, 1, 2, 4, 6, 8); M2232 "C" Letminimum alatt elok, elszegenyedok = L + E - 1; L = QUALIFY(A2481 % A213, 5, 1, 10, 20, 30, 40); E = QUALIFY(0.7 * A2482 % A213, 5, 1, 5, 10, 25, 30); M2233 "C" Nagycsaladosok es kulonleges ellatast igenylok = C + O + F - 1; C = QUALIFY(A2421 % A213, 4, 1, 4, 8, 12); O = QUALIFY(A2422 % A213, 4, 1, 4, 8, 12); F = QUALIFY(A2423 % A213, 2, 1, 0.3); M23 "*" Devians jelensegek = AVERAGE(M231, M232, M233); M231 "A" Veszelyeztetett gyermekek = V + H - 1; V = QUALIFY(A2712 % A2321 % A27121, 5, 1, 80, 90, 110, 120); H = QUALIFY(A2711 % A2321 % A27111, 5, 1, 80, 90, 110, 120); M232 "A" Veszelyeztetett szemelyek = O + A - 1; O = QUALIFY(A2721 % A213 % A27211, 5, 1, 80, 90, 110, 120); A = QUALIFY(A2722 % A213 % A27221, 5, 1, 80, 90, 110, 120); M233 "C" Bunozesi alap = B + F - 1; B = QUALIFY(A2731 % A213 * 10 % A27311, 5, 1, 80, 90, 110, 120); F = QUALIFY(A2732 % A213 * 10 % A27311, 5, 1, 80, 90, 110, 120); M24 "*" Nepesseg egeszsegugyi helyzete = AVERAGE(M241, M242); M241 "A" Nepesseg morbiditasa es mortalitasa = B + H - 1; B = QUALIFY(A233111 % A213 % A233112, 5, 1, 80, 90, 110, 120); H = QUALIFY(A233121 % A213 % A233122, 5, 1, 80, 90, 110, 120); M242 "A" Gyermekek morbiditasa es mortalitasa = B + H - 1; B = QUALIFY(A233211 % A2321 % A233212, 5, 1, 80, 90, 110, 120); H = QUALIFY(A233221 % A2321 % A233222, 5, 1, 80, 90, 110, 120); M25 "*" Csaladhaztartas = AVERAGE(M251, M252); M251 "A" Csaladok = K + N - 1; K = QUALIFY(A2436 % A241, 5, 1, 30, 34, 38, 42); N = QUALIFY((A2434 + A2435) % A241, 1, 5, 25, 29, 33, 37); M252 "A" Haztartasok = L + C - 1; L = QUALIFY((A25211 % A213) % A25212, 5, 1, 80, 90, 110, 120); C = QUALIFY((A25211 % A241) % A25222, 5, 1, 80, 90, 110, 120); M3 "*" Termeloerok (Opuszszfera) = AVERAGE(M31, M32, M33, M34, M35, M36, M37); M31 "*" Mezogazdasag = AVERAGE(M311, M312, M313, M314, M315); M311 "*" Termelesi apparatus = AVERAGE(M3111, M3112, M3113); M3111 "B" Uzemek, gazdasagok szama = E; G = QUALIFY(A6111, 1, 9, 50, 100, 250, 500, 750, 1000, 1500, 2000); A = QUALIFY(A61111 % A6111, 0, 2, 25, 50); E = ((G - A) >= 0 ) ? G - A : 0; M3112 "*" Termelesi agak es specialis termekek = (A61114 < 2) ? 1 : (A61114 < 3) ? 2 : (A61114 < 4) ? 3 : (A61114 < 5) ? 4 : (A61114 < 6) ? 5 : (A61114 < 9) ? 6 : (A61114 < 11) ? 7 : (A61114 < 15) ? 8 : 9; M3113 "*" Funkcionalis kapcsolatok = (A > 9) ? 9 : A; A = A611151 + A611152 + A611153 + A611154 + A611155 + A611156 + A611157 + A611158 + 2 * A611159; M312 "*" Tulajdoni viszonyok = AVERAGE(M3121, M3122); M3121 "B" Osszes terulet = (K > 66) ? 1 : (E < 50 && K > 50) ? 2 : (E < 50 && K < 50) ? 3 : (E < 66 && K > M && K > T) ? 4 : (E < 66 && M > K && T > K) ? 6 : (E < 66 && (M > K || T > K)) ? 5 : (K > M && K > T) ? 7 : (M > K || T > K) ? 8 : 9 ; E = A611214 % A61121; M = A611211 % A61121; T = A6112121 % A61121; K = A611213 % A61121; M3122 "B" Osszes AK = (A > 9) ? 9 : A; A = (A6112141 + A6112111 + A6112121 + A6112131) / A6112101 * 10; M313 "*" Birtokmegoszlas = AVERAGE(M3131, M3132); M3131 "B" Teruletmegosztas = (K < 20 && S > N) ? 1 : (K < 20 && S <= N) ? 2 : (K < 40 && S > N) ? 3 : (K < 20 && S <= N) ? 4 : (K < 60 && S > N) ? 5 : (K < 20 && S <= N) ? 6 : (K < 80 && S > N) ? 7 : (K < 20 && S <= N) ? 8 : 9; S = A611221 % A61121; K = A611222 % A61121; N = A611223 % A61121; M3132 "B" Kataszteri tiszta jovedelem megoszlasa = (K < 20 && S > N) ? 1 : (K < 20 && S <= N) ? 2 : (K < 40 && S > N) ? 3 : (K < 20 && S <= N) ? 4 : (K < 60 && S > N) ? 5 : (K < 20 && S <= N) ? 6 : (K < 80 && S > N) ? 7 : (K < 20 && S <= N) ? 8 : 9; S = A6112211 % A6112101; K = A6112221 % A6112101; N = A6112231 % A6112101; M314 "*" Foglalkoztatottak = AVERAGE(M3141, M3142); M3141 "*" Foglalkoztatottak es helyben dolgozok = ((F + D) < 1) ? 1 : F + D; F = QUALIFY(A611231, 1, 7, 50, 100, 250, 500, 750, 1000); D = QUALIFY(A611232 % A611231, 0, 3, 98, 102, 110) - 1; M3142 "C" Munkaltatoi tulajdon es uzemnagysag = M + T + K - 1; M = QUALIFY(A611241 % A611231, 1, 6, 15, 30, 45, 60, 80); T = (A611244 >= A611243 && A611244 >= A611242) ? 2 : (A611243 >= A611244 && A611243 >= A611242) ? 1 : 0; K = QUALIFY(A6112452 % A611231, 0, 2, 25, 50); M315 "*" Gazdasagi helyzet = MAX(G + T + E - 1, 0.0); G = EXIST1("A61125", 1, 6, 0); T = EXIST1("A611257", 1, 2, 0); E = EXIST1("A615258", 1, 2, 0); M32 "*" Banyaszat es ipar = AVERAGE(M321, M322, M323); M321 "*" Termelesi apparatus = AVERAGE(M3211, M3212, M3213); M3211 "*" Uzemek szama = QUALIFY(A62111, 1, 9, 25, 50, 100, 250, 500, 1000, 1500, 2500); M3212 "*" Szakma szerinti uzemnagysag csoport = S + K + N; S = QUALIFY(A621121, 1, 4, 5, 15, 25); K = QUALIFY(A621122, 1, 3, 3, 5); N = QUALIFY(A621123, 1, 2, 2); M3213 "*" Funkcionalis kapcsolatok = (A > 9) ? 9 : A; A = A621151 + A621152 + A621153 + A621154 + A621155 + A621156 + A621157 + A621158 + 2 * A621159; M322 "*" Foglalkoztatottak = AVERAGE(M3221, M3222); M3221 "*" Foglalkoztatottak es helyben dolgozok = F + D; F = QUALIFY(A621231, 1, 7, 100, 500, 1000, 1500, 2000, 2500); D = QUALIFY(A621232 % A621231, 0, 2, 25, 50); M3222 "A" Munkaltatoi tulajdon es uzemnagysag = M + T + K - 1; M = QUALIFY(A621241 % A621231, 1, 6, 15, 30, 45, 60, 80); T = EXIST1("A62124", 2, 4, 2) - 2; K = QUALIFY(A6212452 % A621231, 0, 2, 25, 50); M323 "*" Gazdasagi helyzet = MAX(G + T + E - 1, 0.0); G = EXIST1("A62125", 1, 6, 0); T = EXIST1("A621257", 1, 2, 0); E = EXIST1("A621258", 1, 2, 0); M33 "*" Idegenforgalom, vendeglatas = AVERAGE(M331, M332, M333, M334, M335, M336); M331 "*" Szolgaltato apparatus = AVERAGE(M3311, M3312, M3313); M3311 "A" Idegenforgalmi es vendeglatoipari egysegek = QUALIFY(A6311, 1, 9, 3, 10, 25, 50, 75, 100, 200, 300); M3312 "A" Szakma szerinti uzemnagysag = S + K + N; S = QUALIFY(A631121, 1, 4, 5, 10, 15); K = QUALIFY(A631122, 1, 3, 3, 5); N = QUALIFY(A631123, 1, 2, 2); M3313 "*" Funkcionalis kapcsolatok = (A > 9) ? 9 : A; A = A631151 + A631152 + A631153 + A631154 + A631155 + A631156 + A631157 + A631158 + 2 * A631159; M332 "*" Allo es udulovendeg fogadasa = AVERAGE(M3321, M3322); M3321 "*" Fogadokepesseg nagysaga = A + E - 1; A = QUALIFY(A63116111 + A63116121 + A63116131 + A63116141 + A63116151 + A63116161 + A63116171 + A63116181 + A63116191, 1, 5, 100, 500, 1000, 2000); E = QUALIFY(A6311611 * 0.2 + A6311612 * 0.4 + A6311613 * 0.6 + A6311614 * 0.8 + A6311615 * 1.0 + A6311616 * 1.5 + A6311617 * 2.0 + A6311618 * 2.5 + A6311619 * 3.0, 1, 5, 5, 10, 15, 20); M3322 "*" Tulajdon es uzemnagysag = 0; #nincs adat M333 "*" Szallovendegfogadas = AVERAGE(M3331, M3332); M3331 "A" Ferohelyek sulyozott szama = QUALIFY(0.2 * A63117111 + 0.4 * A63117121 + 0.6 * A63117131 + 0.8 * A63117141 + A63117151 + 1.5 * A63117161 + 2 * A63117171 + 3 * A63117181 + 4 * A63117191 + 5 * A63117201, 1, 9, 50, 100, 250, 500, 750, 1000, 2000, 3000); M3332 "*" Tulajdon es uzemnagysag = 0; # nincs adat M334 "*" Vendegejszakak = AVERAGE(M3341, M3342); M3341 "A" Vendegejszakak szama = V + K; V = QUALIFY(A631181 / 1000, 1, 6, 5, 10, 25, 50, 100); K = QUALIFY(A6311811 % A631181, 1, 3, 10, 30); M3342 "*" Tulajdon es uzemnagysag = (A + 1) / 2 + B + C; P = A63117221 + A63117222 + A63117223 + A63117224; O = (P == 0) ? 1 : P; E = A63117221 % O; M = A63117222 % O; T = A63117223 % O; K = A63117224 % O; A = (K > 66) ? 1 : (E < 50 && K > 50) ? 2 : (E < 50 && K < 50) ? 3 : (E < 66 && K > M && K > T) ? 4 : (E < 66 && M > K && T > K) ? 6 : (E < 66 && (M > K || T > K)) ? 5 : (K > M && K > T) ? 7 : (M > K || T > K) ? 8 : 9 ; B = QUALIFY(A63117222 % O, 0, 2, 20, 40); C = QUALIFY((A6311717 + A6311718 + A6311719) % O, 0, 2, 20, 40); M335 "*" Foglalkoztatottak szama = AVERAGE(M3351, M3352); M3351 "*" Foglalkoztatottak es helyben dolgozok szama = F + D; F = QUALIFY(A631231, 1, 7, 25, 50, 100, 250, 500, 750); D = QUALIFY(A631232 % A631231, -1, 2, 98, 102, 110); M3352 "*" Munkaltatoi tulajdon es uzemnagysag = M + T + K - 1; M = QUALIFY(A631241 % A631231, 1, 6, 15, 30, 45, 60, 80); T = EXIST1("A63124", 4, 2, -1) + 1; K = QUALIFY(A6312452 % A631231, 0, 2, 25, 50); M336 "*" Gazdasagi helyzet = MAX(G + T + K - 1, 0.0); G = EXIST1("A63125", 1, 6, 0); T = EXIST1("A631257", 1, 2, 0); K = EXIST1("A631258", 1, 2, 0); M34 "*" Orszagos aramlasi halozatok = AVERAGE(M341, M342, M343, M344, M345, M346, M346, M348, M349); M341 "*" Szolgaltato apparatus = AVERAGE(M3411, M3412, M3413); M3411 "A64111" Egysegek reszlegek szama = QUALIFY(A64111, 1, 9, 5, 10, 20, 30, 40, 50, 60, 70); M3412 "A64111" Szakma es uzemnagysag = K + L + N; K = QUALIFY(A641121, 1, 4, 5, 10, 20); L = QUALIFY(A641122, 1, 3, 5, 10); N = QUALIFY(A641123, 1, 2, 3); M3413 "*" Funkcionalis kapcsolatok = (A > 9) ? 9 : A; A = A641151 + A641152 + A641153 + A641154 + A641155 + A641156 + A641157 + A641158 + 2 * A641159; M342 "*" Kozutak = F + E; F = EXIST1("A421161", 1, 7, 0); E = QUALIFY(A421163, 0, 2, 2, 3); M343 "*" Vasuti kozlekedes = AVERAGE(M3431, M3432, M3433, M3434); M3431 "*" Vasutvonal jellege = A + B; A = EXIST("A42215") ? 5 : EXIST("A42214") ? 4 : EXIST("A42213") ? 3 : EXIST("A42212") ? 2 : EXIST("A42211") ? 1 : 0; C = EXIST("A42211") + EXIST("A42212")+ EXIST("A42213")+ EXIST("A42214")+ EXIST("A42215"); B = (C > 2) ? 3 : (C > 1) ? 2 : (C > 0) ? 1 : 0; M3432 "*" Vasutallomas jelleg = MAX(A + M - 1, 0.0); A = (A42224 > 0) ? 5 : (A42223 > 0) ? 4 : (A42222 > 0) ? 3 : (A42221 > 0) ? 2 : (A422211 > 0) ? 1 : 0; M = QUALIFY(A42229, 5, 0, 10, 15, 20, 25, 30); M3433 "*" Vasutallomast erinto vonalak = I + V - 1; I = QUALIFY(A42231, 1, 5, 1, 2, 5, 8); V = QUALIFY(A42233, 1, 5, 2, 4, 8, 12); M3434 "*" Vasutallomas felszereltsege = EXIST1("A4224", 1, 9, 0); M344 "*" Egyeb kozlekedes = AVERAGE(M3441, M3442, M3443, M3444, M3445); M3441 "*" Kozuti kozlekedes = A + V - 1; A = EXIST1("A42125", 1, 3, 0); V = QUALIFY(A42121, 1, 7, 1, 2, 3, 4, 8, 12); M3442 "*" Kozuti jaratsuruseg = J + H + M; J = QUALIFY(A42126, 1, 6, 3, 7, 10, 15, 20); H = EXIST("A421261") ? 1 : 0; M = EXIST("A421262") ? 2 : 1; M3443 "*" Kozuti teherszallitas = EXIST1("A42151", 1, 7, 0) + EXIST("A421518") ? 1 : 0 + EXIST("A421519") ? 1 : 0; M3444 "*" Vizi kozlekedes = MAX(H + K - T, 0.0); H = QUALIFY(A4231, 1, 5, 50, 100, 500, 1000); K = EXIST1("A4233", 1, 4, 0); T = QUALIFY(A4232, 0, 9, 2, 5, 10, 15, 20, 25, 30, 40, 50); M3445 "*" Legi kozlekedes = (A > 0) ? A : 0; R = QUALIFY(A42251, 1, 9, 3, 10, 20, 50, 100, 150, 200, 300); M = QUALIFY(A42252, 1, 9, 30, 45, 60, 75, 90, 120, 150, 180); A = R - M; M345 "*" Hirkozles = AVERAGE(M3451, M3452, M3453); M3451 "*" Egyeni telefon = N + B + E; N = EXIST("A427116") ? 2 : EXIST("A427115") ? 1 : 0; B = EXIST("A427121") ? 2 : (EXIST("A427122") || EXIST("A427123") || EXIST("A427124")) ? 1 : 0; E = EXIST("A42781") ? 1 : 0 + EXIST("A42782") ? 1 : 0 + EXIST("A42783") ? 1 : 0 + EXIST("A42784" ) ? 2 : 0; M3452 "*" Radio = H + C + A; H = EXIST1("A42761", 1, 3, 0); C = EXIST1("A42762", 1, 2, 0); A = QUALIFY(A42763, 1, 4, 10, 25, 50); M3453 "*" Televizio = H + C + A; H = EXIST1("A42771", 1, 3, 0); C = EXIST1("A42772", 1, 2, 0); A = QUALIFY(A42773, 1, 4, 10, 25, 50); M346 "*" Energia es termekvezetek = AVERAGE(M3461, M3462, M3463); M3461 "*" Elektromos vezetek = K + I - 1; K = QUALIFY(A42412, 1, 5, 3, 6, 9, 12); I = QUALIFY(A4242, 1, 5, 30, 60, 90, 120); M3462 "*" Gaz es termekvezetek = G + T; G = QUALIFY(A4252, 1, 7, 5, 10, 20, 30, 40, 50); T = EXIST1("A42522", 1, 2, 0); M3463 "*" Egyeb energiaellatas = F + P + T + K; F = EXIST1("A42591", 1, 2, 0); P = EXIST("A42571") ? 2 : 1; T = EXIST("A42573") ? 2 : 1; K = QUALIFY(A42821, 1, 3, 6, 12); M347 "*" Vizgazdalkodas = EXIST1("A642", 1, 9, 0); M348 "*" Foglalkoztatottak = AVERAGE(M3481, M3482); M3481 "*" Foglalkoztatottak es helyben dolgozok = F + D; F = QUALIFY(A643231, 1, 7, 25, 50, 100, 250, 500, 750); D = QUALIFY(A643232 % A643231, -1, 2, 98, 102, 110); M3482 "*" Munkaltatoi tulajdon es uzemnagysag = M + T + K - 1; M = QUALIFY(A643241 % A643231, 1, 6, 15, 30, 45, 60, 80); T = EXIST1("A64324", 2, 4, 1) - 1; K = QUALIFY(A6432452 % A643231, 0, 2, 25, 50); M349 "*" Gazdasagi helyzet = MAX(G + T + E - 1, 0.0); G = EXIST1("A64325", 1, 6, 0); T = EXIST1("A643257", 1, 2, 0); E = EXIST1("A643258", 1, 2, 0); M35 "*" Egyeb agak = AVERAGE(M351, M352, M353, M354, M355); M351 "*" Szolgaltato apparatus = AVERAGE(M3511, M3512, M3513); M3511 "A4441" Egysegek, reszlegek szama = QUALIFY(A4441, 1, 9, 5, 10, 25, 50, 100, 150,200, 250); M3512 "A4442" Szakma es uzemnagysag szerinti csoportok = K + L + N; K = QUALIFY(A6511211, 1, 4, 5, 10, 20); L = QUALIFY(A6511221, 1, 3, 5, 10); N = QUALIFY(A6511231, 1, 3, 5, 10); M3513 "*" Funkcionalis kapcsolatok = (A > 9) ? 9 : A; A = A661151 + A661152 + A661153 + A661154 + A661155 + A661156 + A661157 + A661158 + 2 * A661159; M352 "*" Felvasarlo es eloszto nagykereskedelem = EXIST1("A652", 1, 8, 0) + (EXIST("A6529")) ? 1 : 0; M353 "*" Penz hitel es biztositas = EXIST1("A653", 1, 8, 0) + (EXIST("A6539")) ? 1 : 0; M354 "*" Foglalkoztataottak = AVERAGE(M3541, M3542); M3541 "*" Foglalkoztatottak es helyben dolgozok = MAX(F + D, 1.0); F = QUALIFY(A6543231, 1, 7, 5, 10, 40, 75, 120, 250); D = QUALIFY(A6543232 % A6543231, -1, 2, 98, 102, 110); M3542 "A6543231" Munkaltatoi tulajdon es uzemnagysag = M + T + K - 1; M = QUALIFY(A6543241 % A6543231, 1, 6, 15, 30, 45, 60, 80); T = EXIST1("A654324", 1, 3, 1) -1; K = QUALIFY(A65432452, 0, 2, 25, 50); M355 "*" Gazdasagi helyzet = MAX(G + T + E -1, 0.0); G = EXIST1("A6543251", 1, 6, 0); T = EXIST1("A6542257", 1, 2, 0); E = EXIST1("A6542258", 1, 2, 0); M36 "*" Termeloerok = AVERAGE(M361, M362); M361 "*" Szam szerint osszesitheto = AVERAGE(M3611, M3612); M3611 "A66111" Uzemek, egysegek szama = QUALIFY((M3111 + A66111 + M3211 * A66111 + M3311 * A66111 + M3411 * A66111 + M3511 * A66111) / nz(M3111 + M3211 + M3311 + M3411 + M3511), 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M3612 "A66111" Foglalkoztatottak es helybe dolgozok szama = QUALIFY((M3141 * A661231 + M3221 * A661231 + M3351 * A661231 + M3481 * A661231 + M3541 * A661231) / nz(M3141 + M3221 + M3351 + M3481 + M3541), 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M362 "*" Szam szerint nem osszesitheto = AVERAGE(M3621, M3622, M3623, M3624, M3625); M3621 "*" Az apparatus szakmai tagozodasa = QUALIFY((M3112 + M3212 + M3312 + M3412 + M3512) / 5, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M3622 "*" Funkcionalis kapcsolatok = QUALIFY((M3113 + M3213 + M3313 + M3413 + M3513) / 5, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M3623 "*" Munkaltatoi tulajdon es uzemnagysag = QUALIFY((M3142 + M3222 + M3352 + M3482 + M3542) / 5, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M3624 "*" Termelo es szolgaltato apparatus = QUALIFY((M311 + M321 + M331 + M341 + M351) / 5, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M3625 "*" Foglalkoztatottak = QUALIFY((M314 + M322 + M335 + M348 + M354) / 5, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M3626 "*" Gazdasagi helyzet es termelesi ertek = QUALIFY((M315 + M323 + M336 + M349 + M355) / 5, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M37 "*" A fejlesztes forrasai = AVERAGE(M371, M372); M371 "*" Onkormanyzati vagyon es kltsegvetes = AVERAGE(M3711, M3712); M3711 "A3511" Onkormanyzati brutto vagyonertek = MAX(A + B - 1, 1.0); A = QUALIFY(A3511, 1, 7, 100, 500, 1000, 5000, 15000, 30000); B = QUALIFY(A3512 % A3511, 3, -1, 0, 10, 25, 50); M3712 "A3521" Onkormanyzati koltsegvetes = K + S -1; K = QUALIFY(A3521, 1, 7, 50, 100, 500, 1000, 5000, 25000); S = QUALIFY(A35211 % A3521, 0, 3, 10, 25, 50); M372 "*" Fejlesztesi lehetosegek = AVERAGE(M3721, M3722); M3721 "A3531" Rendelkezesre allo lehetosegek = MAX(R + H - 1, 1.0); R = QUALIFY(A3531, 1, 7, 50, 100, 500, 1000, 5000, 15000); H = QUALIFY(A35311 % 3531, 0, 3, 10, 15, 30); M3722 "A3541" Elerheto forras = MAX(R + H - 1, 1.0); R = QUALIFY(A3541, 1, 7, 50, 100, 500, 1000, 5000, 15000); H = QUALIFY(A35411 % 3531, 0, 3, 60, 75, 90); M4 "*" Egyeb muvi kornyezet (Urbanoszfera) = AVERAGE(M41, M42, M43, M44, M45, M46); M41 "*" Altalanos jellemzok = AVERAGE(M411, M412, M413, M414); M411 "*" A telepules jellege = EXIST1("A401", 1, 9, 0); M412 "B" Beepitesi mod = EXIST1("A411", 1, 9, 0); M413 "*" Tradicio-apolas = AVERAGE(M4131, M4132, M4134); M4131 "*" Folyamatos fennallas = QUALIFY(A412, 9, 1, 12, 13, 14, 15, 16, 17, 18, 19); M4132 "*" Muemlekek = QUALIFY(A17561 + 0.8 * A175611 + 0.7 * A175612 + 0.7 * A175613 + 0.1 * A175614, 1, 9, 2, 5, 10, 25, 50, 75, 100, 150); M4133 "*" Muemlekek kora = M + V - 1; M = QUALIFY(A175631 + 1.5 * A175632 + 2 * A175633 + 2.5 * A175634 + 3 * A175635 + 3.5 * A175636 + 4 * A175637 + 4.5 * A175638 + 5 * A175639, 1, 5, 2, 4, 6, 8); V = QUALIFY(A175621 + 2 * A175622 + 3 * A175623 + 4 * A175624 + 5 * A175625, 1, 5, 2, 4, 6, 8); M4134 "*" Nepszokasok, nagymultu kollekivak = K + A - 1; K = QUALIFY(A46761, 1, 5, 2, 4, 6, 10); A = QUALIFY(A467611 * 5 + A467612 * 4 + A467613 * 3 + A467614 * 2 + A467615 * 1, 1, 5, 2, 4, 6, 8); M414 "*" Otthonossag = EXIST1("A467620", 0, 9, 0); M42 "*" Telepulesgazdasag = AVERAGE(M421, M422, M423, M424, M425, M426, M427, M428, M429); M421 "*" Szolgaltato apparatus = AVERAGE(M4211, M4212, M4213); M4211 "A65111", Egysegek, reszlegek szama = QUALIFY(A65111, 1, 9, 5, 15, 30, 45, 60, 75, 100, 125); M4212 "*" Szakma es uzemnagysag szerinti csoportok = QUALIFY(A6511501, 1, 9, 1, 2, 3, 4, 5, 6, 7, 10); M4213 "*" Funkcionalis kapcsolatok = (A > 9) ? 9 : A; A = A651151 + A651152 + A651153 + A651154 + A651155 + A651156 + A651157 + A651158 + 2 * A651159; M422 "*" Lakoepuletek = AVERAGE(M4221, M4222); M4221 "A4311", Lakoepuletek szama = QUALIFY((0.2 * A43121 + 0.5 * A43122 + 0.9 * A43123 + A43124) / A4311, 1, 9, 0.6, 0.65, 0.7, 0.8, 0.85, 0.9, 0.95, 0.99); M4222 "A4311" Szintek szerinti megoszlas = QUALIFY((A43251 + 1.3 * A43252 + 1.6 * A43253 + 1.5 * A43254 + 1.4 * A43255) / A4311, 1, 9, 1.1, 1.15, 1.20, 1.25, 1.30, 1.35, 1.40, 1.45); M423 "*" Lakasok es lakok = AVERAGE(M4231, M4232, M4233, M4234, M4235, M4236); M4231 "A4311" Lakasok = 8 - EXIST1("A4343", 1, 7, 8); M4232 "A4311" Lakoszobak = QUALIFY(A4371 % A4311, 1, 9, 125, 135, 145, 160, 175, 190, 210, 230); M4233 "A4311" Mellekhelyisegek = QUALIFY(A4375 % A4311, 1, 9, 210, 230, 260, 290, 310, 330, 350, 375); M4234 "A4352" Lakok = QUALIFY(A4352 % A4371, 9, 1, 125, 150, 175, 195, 205, 220, 250, 270); M4235 "A4352" Enegiaellatas = QUALIFY((A42451 + A4257 * 1.5 + A4255 * 2 + A42621 + 3) / A4311, 1, 9, 1.0, 1.25, 1.5, 1.75, 2.0, 2.3, 2.6, 3.0); M4236 "A4311" Lakasok kozmuellatasa = QUALIFY((1.2 * A423815 + 1.5 * A423812 + 1.8 * A423825 + 2.5 * A423822 + 1.8 * 423823 + 2.5 * 423824) / 4311, 1, 9, 1.2, 1.5, 1.8, 2.0, 2.5, 3.0, 3.5, 4.0); M4237 "A4352" Epitesi ido = QUALIFY((0.1 * A43421 + 0.2 * A43422 + 0.4 * A43423 + 0.6 * A43424 + 0.8 * A43425 + 0.9 * A43426 + A43427) / A4311, 1, 9, .55, .60, .65, .70, .75, .80, .85, .90); M424 "*" Helyi energiaellatas = AVERAGE(M4241, M4242, M4243, M4244, M4245, M4246); M4241 "A1711" Elekromos aramellatas = V + K - 1; V = QUALIFY(A42411, 1, 6, 3, 6, 9, 12, 15); K = QUALIFY(A42413 % A42411, 1, 4, 25, 50, 75); M4242 "A42411" Kozvilagitas = L + F - 1; L = QUALIFY(A424442 / A42411, 1, 5, 12, 20, 25, 30); F = QUALIFY(A4244421 % 424442, 1, 5, 20, 40, 60, 80); M4243 "A4341" Elektromos halozatba bekapcsolt lakasok = QUALIFY(A42451 % A4341, 1, 9, 60, 70, 75, 80, 85, 90, 95, 99); M4244 "A1711" Gazellatas = P + V + C -1; P = 4 - EXIST1("A4257", 1, 4, 4); V = QUALIFY(A4251 % A1711, 1, 5, 3, 6, 9, 12); C = (A4253 > 6000) ? 2 : 1; M4245 "A4341" Gazellatasba bekapcsolt lakasok = QUALIFY(A4255 % A4341, 1, 9, 50, 60, 70, 80, 85, 90, 95, 99); M4246 "A1711" Egyeb energiaellatas = A + T + L -1; A = EXIST("A4281") ? 2 : A4283 < 5 ? 1 : 0; T = QUALIFY(A42622, 1, 4, 5, 10, 20); L = QUALIFY(A42621 % A4341, 1, 4, 10, 20, 30); M425 "*" Kozmuellatas = AVERAGE(M4251, M4252, M4253, M4254); M4251 "A4341" Vizvezetekhalozat = QUALIFY(A423811 / A1711, 2, 9, 1, 2, 4, 6, 8, 10, 12); M4252 "A4352" Vizvezetekhalozatba bekapcsolt lakasok = QUALIFY(A423812 % A4311, 1, 9, 25, 35, 45, 55, 65, 75, 85, 95); M4253 "A4352" Szennyvizelvezetes = (Z == 0) ? U : (Z + T - 1); U = EXIST("A42382522") ? 1 : 0; Z = QUALIFY(A423821 % A1711, 2, 7, 1, 2, 4, 6, 8); T = EXIST1("A4238253", 1, 4, 0); M4254 "A4352" Csatornahalozatba bekapcsolt lakasok szama = QUALIFY(A423822 % A4311, 1, 9, 15, 25, 35, 45, 55, 65, 75, 85); M426 "*" Helyi kozlekedes, hirkozles = AVERAGE(M4261, M4262, M4263, M4264); M4261 "A1711" Utviszonyok = K + P - 1; K = QUALIFY(42131 / A1711, 1, 5, 3, 6, 9, 12); P = QUALIFY(A421311 % A42131, 1, 5, 50, 60, 70, 80); M4262 "A1711" Jardaviszonyok = K + P - 1; K = QUALIFY(A42133 / A1711, 1, 5, 5, 15, 25, 35); P = QUALIFY(A421331 % A42133, 1, 5, 50, 60, 70, 80); M4263 "A4352" Kozforgalmu kozlekedes = (H == 0) ? T : H + B - 1; T = QUALIFY(A421263, 0, 2, 2, 5); H = QUALIFY(A421411 + 421421, 3, 7, 2, 5, 10, 20); B = QUALIFY(A421441, 1, 3, 5, 15); M4264 "*" Hirkozles = (K + P + I + T + A + V) / 2; K = QUALIFY(A4811, 1, 2, 10); P = EXIST("A48121") + EXIST("A48122") + EXIST("A48123") + EXIST("A48134") + EXIST("A48125"); I = EXIST1("A4831", 1, 5, 0); T = EXIST1("A42711", 5, 6, 4) - 4; A = QUALIFY((A427125 + A427127) / A4352 * 1000, 1, 4, 10, 100, 300); V = (A427128 > 2) ? 2 : 1; M427 "*" Zoldterulet, koztisztasag = AVERAGE(M4271, M4272, M4273, M4274, M4275, M4276); M4271 "A4352" Zoldterulet, erdok = F + Z + E -1; F = QUALIFY(A42132 % A42131, 0, 2, 10, 40); Z = QUALIFY(A1736 * 10000 / A4352, 1, 5, 1, 2, 3, 4); E = EXIST1("A17221", 1, 4, 4) - 4; M4272 "A4352" Temetkezes = MIN(MAX(R + S + T + K + U - 1, 0.0), 9.0); R = EXIST1("A17362", 1, 2, 0); S = EXIST1("A173625", 1, 2, 1) - 1; T = QUALIFY(A173621, 0, 4, 2, 4, 6, 7); K = EXIST("A173622"); U = EXIST1("A173626", 1, 3, 1) - 1; M4273 "A4352" Kozterulettisztitas = R + G - 1; R = QUALIFY(A42912 % A42911, 1, 5, 30, 50, 70, 90); G = QUALIFY(A42913, 1, 5, 2, 3, 4, 5); M4274 "A4352" Kozterulet locsolas, hoeltakaritas = R + G + H -1; R = QUALIFY(A42916 % A42911, 1, 4, 20, 40, 60); G = QUALIFY(A42917, 1, 4, 2, 3, 5); H = EXIST1("A419182", 1, 3, 1) - 1; M4275 "A4352" Haztartasi szemet = MAX(L + P + G -1, 0.0); L = QUALIFY(A42921 % A4341, 1, 4, 30, 60, 90); P = QUALIFY(A429223 % A4341, 0, 3, 1, 30, 70); G = QUALIFY(A429221 + A429222, 1, 3, 2, 5); M4276 "A4352" Szemetkezeles = MIN(MAX(K + D + S -1, 0.0), 9.0); K = EXIST1("A4294", 0, 4, 0); D = EXIST1("A42932", 1, 4, 1) - 1; S = 4 - EXIST1("A42931", 1, 4, 4); M428 "*" Foglalkoztatottak = AVERAGE(M4281, M4282); M4281 " A4352" Foglalkoztatottak es helyben dolgozok = F + D; F = QUALIFY(A291, 1, 7, 5, 10, 40, 75, 120, 250); D = QUALIFY(100 - ((A2921 + A2922) % A291), -1, 2, 98, 102, 110); M4282 "A291", Munkaltatoi tulajdon es uzemnagysag = MAX(M + T + K -1, 0.0); M = QUALIFY(A661241 % A66123, 1, 6, 15, 30, 45, 60, 80); A = MAX(A661242, A661243, A661244); T = (A == A661244) ? 2 : (A == A661243) ? 1 : 0; K = QUALIFY(A6612452 % A661244, 0, 2, 25, 50); M429 "*" Gazdasagi helyzet = MAX(G + T + E -1, 0.0); G = EXIST1("A66125", 1, 6, 0); T = EXIST1("A661257", 1, 2, 0); E = EXIST1("A661258", 1, 2, 0); M43 "*" Kozintezmenyek = AVERAGE(M431, M432, M433, M434, M435, M436, M437, M438); M431 "*" Szolgaltato apparatus = AVERAGE(M4311, M4312); M4311 "A67111" Szolgaltato apparatus = QUALIFY(A67111, 1, 9, 10, 25, 50, 75, 100, 150, 200, 250); M4312 "A67111" Szakmak szerinti uzemnagysag = QUALIFY(A671121, 1, 9, 5, 10, 20, 30, 40, 50, 60, 70); M4313 "A67111" Funkcionalis kapcsolatok = (A > 9) ? 9 : A; A = A671151 + A671152 + A671153 + A671154 + A671155 + A671156 + A671157 + A671158 + 2 * A671159; M432 "*" Eloszto kiskereskedelem = AVERAGE(M4321, M4322, M4323, M4324); M4321 "A4352" Boltegysegek szama = (H + O + B + L + S) / 2; H = QUALIFY(A44101, 1, 2, 2); O = QUALIFY(A44102, 1, 3, 2, 4); B = QUALIFY(A4411, 1, 5, 5, 20, 50, 100); L = QUALIFY(A44111, 1, 3, 2, 4); S = QUALIFY(A44112, 1, 5, 3, 6, 9, 12); M4322 "*" Tulajdon es uzemnagysag = A + T + U; A = QUALIFY(A4412, 1, 4, 200, 1000, 10000); T = QUALIFY(A4414112 % A4412, 1, 3, 30, 60); U = QUALIFY(A4414122 % A4412, 1, 3, 30, 60); M4323 "*" Szakmak szerinti tagozodas = 10 - EXIST1("A44191", 1, 9, 10); M4324 "A4352" Szolgaltato (felvevo) helyek = E + K - 1; E = QUALIFY(A4441, 1, 5, 10, 50, 100, 250); K = QUALIFY(A4442, 1, 5, 5, 10, 20, 30); M433 "*" Egeszsegugyi, szocialis ellatas = AVERAGE(M4331, M4332, M4333, M4334, M4335, M4336, M4337); M4331 "A4352" Egeszsegugyi alapellatas = MAX(H + F + G + B - 1, 0.0); H = QUALIFY(A451121, 3, 0, 1, 5, 10); F = QUALIFY(A452131, 3, 0, 1, 5, 10); G = QUALIFY(A44173, 3, 0, 1, 5, 10); B = EXIST("A451131"); M4332 "A4352" Szakorvosi ellatas = R + M - 1; R = QUALIFY(A452113, 1, 5, 3, 6, 9, 12); M = QUALIFY(A452111, 1, 5, 30, 60, 90, 120); M4333 "A4352" Korhazi ellatas = MAX(K + M - 1, 0.0); K = QUALIFY(A45224, 1, 5, 1, 6, 9, 12); M = QUALIFY(A452221, 5, 0, 5, 30, 60, 90, 120); M4334 "A4352" Egyeb egeszsegugyi ellatas = MIN(MAX(F + E + M -1, 0.0), 9.0); F = QUALIFY(A4563, 1, 4, 2, 4, 6); E = EXIST("A456111") + EXIST("A456112") + EXIST("A456113"); M = QUALIFY(A45621, 4, 0, 15, 30, 60, 90); M4335 "A4352" Anya, csecsemo, gyerekvedelem = (V + K + B + C + I + T + H + G) / 2; V = EXIST1("A45113", 1, 2, 0); K = EXIST1("A45115", 2, 3, 0); B = EXIST("A4541") * 2; C = EXIST("A4551") * 2; I = 3 - EXIST1("A45116", 1, 2, 3); T = 3 - EXIST1("A45117", 1, 2, 3); H = EXIST("A451181") * 2; G = EXIST("A451182") * 2; M4336 "A4352" Szocialis es tarsadalombiztositasi ellatas = MIN(MAX(G + F + K + E + H + O + T - 1, 0.0), 9.0); G = EXIST("A4571"); F = EXIST("A4573"); K = EXIST("A45721"); E = EXIST("A4574"); H = EXIST("A4575"); O = EXIST("A4581"); T = QUALIFY(A4585, 3, 0, 15, 45, 90); M4337 "*" Fogyatekosok ellatasa = L + H + M + S + F; L = EXIST1("A4591", 1, 2, 0); H = EXIST1("A4592", 1, 2, 0); M = EXIST1("A4593", 1, 2, 0); S = EXIST1("A4594", 1, 2, 0); F = EXIST("A4595"); M434 "*" Oktatas = AVERAGE(M4341, M4342, M4343, M4344, M4345); M4341 "A4352" Ovodak = MIN(MAX(O + F + J - 1, 0.0), 9.0); O = QUALIFY(A46131 / A4614, 4, 0, 20, 25, 30, 40); F = QUALIFY(A46131 % A23212, 1, 4, 30, 60, 90); J = EXIST("A4615"); M4342 "A4352" Altalanos iskola = MIN(MAX((O + T + F + S) / 2 - M, 0.0), 9.0); O = EXIST1("A462911", 1, 7, 0); T = QUALIFY(A4622 / A4623, 3, 0, 25, 35, 45); F = EXIST("A462921") + EXIST("A46922") + EXIST("A46923") + EXIST("A46924"); S = EXIST("A462931") + EXIST("A462932") + EXIST("A462933") + EXIST("A462934"); M = EXIST1("A4625", 2, 3, 1) -1; M4343 "A4352" Szakmunkaskepzes = MIN(MAX(K + I + M - 1, 0.0), 9.0); K = QUALIFY(A4646, 1, 5, 3, 6, 10, 15); I = EXIST("A46451") + EXIST("A46452"); M = QUALIFY(A46441, 3, 0, 15, 30, 60); M4344 "A4352" Kozep es szakoktatas = MIN(MAX(A + T + K + M - 1, 0.0), 9.0); A = EXIST("A46285") ? 2 : 0; T = QUALIFY(A46551, 1, 7, 2, 4, 6, 8, 10, 12); K = EXIST1("A46591", 1, 3, 0); M = EXIST("A46541") ? EXIST("A46542") - 1 : 0; M4345 "A4352" Felsofoku oktatas = MAX(F - M, 0.0); F = EXIST1("A4663", 1, 5, -4) + 4; M = QUALIFY(A46641, 0, 9, 10, 20, 30, 40, 50, 60, 80, 100, 120); M435 "*" Egyeb kulturalis ellatas = AVERAGE(M4351, M4352, M4353, M4354, M4355, M4356); M4351 "A4352" Kozmuvelodes = (E + K + I) / 2; E = QUALIFY(A46721, 1, 5, 10, 25, 50, 100); K = QUALIFY(A46733, 1, 5, 3, 6, 9, 12); I = EXIST("A46711") + EXIST("A46731") + EXIST("A46732") + EXIST("A46734") + EXIST("A467332"); M4352 "A4352" Sportelet = MIN((L + K + B) / 2, 9.0); L = EXIST1("A471", 1, 4, 0) + EXIST1("A471", 5, 6, 4) - 1 + EXIST1("A471", 7, 8, 6) -1 + EXIST("A4719"); K = QUALIFY(A473, 1, 4, 3, 10, 20); B = EXIST1("A474", 1, 5, 0); M4353 "A4352" Eloado es alkotomuveszet = MAX(E + I - 1, 0.0); E = EXIST1("A46742", 1, 5, 0); I = EXIST("A467412") + EXIST("A467413") + EXIST("A367414") + EXIST("A467415") + EXIST("A467416"); M4354 "A4352" Tudomanyos elet = MAX(I + J + M -1, 0.0); I = EXIST1("A46816", 1, 3, 0); J = A46818; M = QUALIFY(A46815, 1, 5, 5, 10, 50, 100); M4355 "A4352" Sajto = MAX(H + F + J -1, 0.0); H = 4 - EXIST1("A468211", 1, 3, 4); F = QUALIFY(A4682132, 1, 4, 2, 4, 6); J = QUALIFY(A4682141, 1, 3, 1, 2); M4356 "A4352" Hitelet = (K + O + H) / 2; A = (A4622 + A4653 == 0) ? 1 : A4622 + A4653; K = EXIST1("A468311", 1, 7, 1) -1; O = QUALIFY(A468321 % A, 0, 6, 1, 15, 30, 45, 60, 75); H = QUALIFY(A468332 % A4352, 1, 6, 15, 30, 45, 60, 75); M436 "*" Egyeb kozintezmenyek = AVERAGE(M4361, M4362, M4363, M4364, M4365); M4361 "A4352" Altalanos igagatas = K + J + E; K = EXIST1("A4891", 1, 2, 0); J = EXIST1("A4892", 1, 3, 0); E = EXIST("A48934") ? 4 : EXIST("A48933") ? 3 : EXIST("A48932") ? 2 : EXIST("A48931") ? 1 : 0; M4362 "A4352" Szakigazgatas = MAX(H + I + E + M, 0.0); H = QUALIFY(A489511, 1, 2, 2); I = QUALIFY(A489521, 1, 3, 2, 4); E = QUALIFY(A489531, 1, 3, 2, 4); M = QUALIFY(A489523, 1, -1, 30, 60) + QUALIFY(A489533, 1, -1, 60, 120); M4363 "C" Rendbiztonsag = (H + I + E + O + M) / 2; H = EXIST("A489611") + EXIST("A489612") + EXIST("A489613") + EXIST("A489614"); I = EXIST("A489621") + EXIST("A489622") + EXIST("A489623"); E = EXIST("A489631") + EXIST("A489631") + EXIST("A489631") + EXIST("A489631"); #A489631 negyszer O = EXIST("A489641") + EXIST("A489641") + EXIST("A489641") + EXIST("A489641"); #A489641 negyszer M = (A489651 < 5) ? 1 : 0 + (A489652 < 10) ? 1 : 0 + (A489653 < 10) ? 1 : 0; M4364 "C" Jogbiztonsag = (K + A + U + S + L + P + M) / 2; K = EXIST("A489711"); A = EXIST("A489721") + EXIST("A489722") + EXIST("A489723"); U = EXIST("A489731") + EXIST("A489732") + EXIST("A489733"); S = EXIST("A489741") + EXIST("A489742") + EXIST("A489743") + EXIST("A489744") + EXIST("A489745"); L = EXIST("A489751") + EXIST("A489752") + EXIST("A489753"); P = EXIST("A489761"); M = QUALIFY(A4897212, 1, 0, 45) + QUALIFY(A4897222, 1, 0, 90); M4365 "A4352" Civil szervezodesek = MAX(K + H - 1, 0.0); K = A4898111; H = A4898112; M437 "*" Foglalkoztatottsag = AVERAGE(M4371, M4372); M4371 "C" Foglalkoztatottak es helyben dolgozok = F + D; F = QUALIFY(A291, 1, 7, 50, 150, 300, 500, 1000, 1500); D = QUALIFY(A2921 % A291, -1, 2, 98, 102, 110); M4372 "A5108" Munkaltatoi tulajdon = MAX(M + T + K - 1, 0.0); M = QUALIFY(A611244 % A61124, 1, 6, 15, 30, 45, 60, 80); A = MAX(A611242, A611243, A611244); T = (A == A611244) ? 2 : (A == A611243) ? 1 : 0; K = QUALIFY(A6112452 % A61124, 0, 2, 25, 50); M438 "*" Gazdasagi helyzet = MAX(G + T + E -1, 0.0); G = EXIST1("A67125", 1, 6, 0); T = EXIST1("A671257", 1, 2, 0); E = EXIST1("A671258", 1, 2, 0); M44 "*" Egyeb muvi kornyezet = AVERAGE(M441, M442); M441 "*" Szam szerint osszesitheto = AVERAGE(M4411, M4412); M4411 "A61111" Egysegek, reszlegek szama = QUALIFY((M4211 * A61111 + M4311 * A61111) / nz(M4211 + M4311), 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M4412 "A61111" Foglalkoztatottak es helyben dolgozok = QUALIFY((M4281 * A61111 + M4371 * A61111) / nz(M4281 + M4371), 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M442 "*" Nem osszesitheto osszevonhato alap = AVERAGE(M4421, M4422, M4423, M4425, M4426); M4421 "*" Apparatus szakmai megoszlasa = QUALIFY((M4212 + M4312) / 2, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M4422 "*" Funkcionalis kapcsolatok = QUALIFY((M4213 + M4313) / 2, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M4423 "*" Munkaltatoi tulajdon es uzemnagysag = QUALIFY((M4282 + M4372) / 2, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M4424 "*" Szolgaltato apparatus = QUALIFY((M421 + M431) / 2, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M4425 "*" Foglalkoztatottak = QUALIFY((M428 + M437) / 2, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M4426 "*" Gazdasagi helyzet = QUALIFY((M429 + M438) / 2, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M45 "*" Foosszesito = AVERAGE(M451, M452); M451 "A61111" Szam szerint is osszesitheto = QUALIFY((M3611 * A61111 + M4411 * A61111) / nz(M3611 + M4411), 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M4512 "A61111" Foglalkoztatottak = QUALIFY((M3612 * A61111 + M4412 * A61111) / nz(M3611 + M4411), 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M452 "*" Nem osszesitheto = AVERAGE(M4521, M4522, M4523, M4524, M4525, M4526); M4521 "*" Apparatus szakmai megosztasa = QUALIFY((M3621 + M4421) / 2, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M4522 "*" Funkcionalis kapcsolatok = QUALIFY((M3622 + M4422) / 2, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M4523 "*" Munkaltatoi tulajdon es uzemnagysag = QUALIFY((M3623 + M4423) / 2, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M4524 "*" Termelo, szolgaltato apparatus = QUALIFY((M3624 + M4424) / 2, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M4525 "*" Foglalkoztatottak = QUALIFY((M3625 + M4425) / 2, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M4526 "*" Gazdasagi helyzet = QUALIFY((M3626 + M4426) / 2, 1, 9, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5); M46 "*" Altalanos es specialis szerepkor = AVERAGE(M461, M462); M461 "A4352" Altalanos szerepkor = 0; #nincs adat vagy nem talalom M462 "A4352" Specialis szerepkor = 0; #nincs adat vagy nem talalom