{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ajantasaiset palkat","Taul2","Käyttöohje","Laskuri"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":18,"comments":0,"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":"row_number_cap","date_system":"1900"}

{"sheet":"ajantasaiset palkat","index":0,"n_rows":307,"n_cols":9,"rows_kept":307,"cut":false,"hidden":true,"merged":[[0,0,0,1],[5,3,5,5],[5,6,5,8],[46,3,46,5],[46,6,46,8],[127,3,127,5],[127,6,127,8],[131,3,131,5],[131,6,131,8],[135,3,135,5],[135,6,135,8],[141,3,141,5],[141,6,141,8],[145,3,145,5],[145,6,145,8],[149,3,149,5],[149,6,149,8],[155,3,155,5],[155,6,155,8],[189,3,189,5],[189,6,189,8],[236,3,236,5],[236,6,236,8],[58,6,58,8],[71,3,71,5],[71,6,71,8],[115,3,115,5],[115,6,115,8],[78,3,78,5],[78,6,78,8],[58,3,58,5],[185,3,185,5],[185,6,185,8],[281,3,281,5],[281,6,281,8],[293,3,293,5],[293,6,293,8],[287,3,287,5],[287,6,287,8],[247,3,247,5],[247,6,247,8],[269,3,269,5],[269,6,269,8],[160,3,160,5],[160,6,160,8],[168,3,168,5],[168,6,168,8],[176,3,176,5],[176,6,176,8]]}
["SIVISTYSTYÖNANTAJAT ry"]
["Opetushenkilöstön palkat  (muut kuin AMK)"]
[null,null,null,"1.2.2016 lukien"]
[]
["LUKIO-OPETUS JA PERUSOPETUS"]
["Tilastokoodi",null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["011064","Peruskoulun rehtori (64 - 68)",null,3735.06,"-",4446.63,3632.2,"-",4324.1400000000003]
["011065","Lukion rehtori (65 - 70)",null,3893.34,"-",4883.16,3786.15,"-",4748.8100000000004]
[]
[null,null,null,"I kalleusluokka ",null,"II kalleusluokka "]
["011261","Johtaja (61)",null,3254.46,null,3164.98]
["011259","Johtaja (59)",null,3040.75,null,2957.37]
["011154","Apulaisjohtaja (54)",null,2500.0100000000002,null,2431.36]
[]
["1. Lehtori ja opinto-ohjaaja(lukio)",null,null,"I kalleusluokka ",null,"II kalleusluokka "]
["012151","a. Ylempi korkeakoulututkinto ja lukio-opetusta antavan \nopettajan kelpoisuus taikka aiempi vanhemman lehtorin kelpoisuus (51)",null,2940.36,null,2859.29]
["012150","b. Perusopetusta antavan opettajan tai aiempi lukio-opetusta \nantavan opettajan kelpoisuus (50)",null,2827.04,null,2749.52]
["012145","c. Ylempi tai alempi korkeakoulututkinto (45)",null,2421.7600000000002,null,2363.62]
["012139","d. Muu kuin edellä mainittu (39) ",null,2057.52,null,2011.03]
["                                                       "]
["2. Lehtori (peruskoulu)"]
["012249","a. Ylempi korkeakoulututkinto ja perus-/lukio-opetusta antavan\n opettajan kelpoisuus tai aiempi vanhemman lehtorin kelpoisuus (49)",null,2736.59,null,2663.25]
["012248","b. Perusopetusta antavan opettajan tai aiempi peruskoulun/lukion opettajan kelpoisuus (48)",null,2623.28,null,2555.29]
["012244","c. Ylempi korkeakoulututkinto (44)",null,2297.54,null,2243.06]
["012242","d. Alempi korkeakoulututkinto (42)",null,2191.02,null,2139.16]
["012239","e. Muu kuin edellä mainittu (39)",null,2057.52,null,2011.03]
[]
["3. Erityisopettaja ja erityisluokanopettaja"]
["012349","a. Ylempi korkeakoulututkinto ja erityisopetusta antavan opettajan kelpoisuus (49)",null,2736.59,null,2663.25]
["012348","b. Alempi korkeakoulututkinto ja erityisopetusta antavan opettajan kelpoisuus (48)",null,2623.28,null,2555.29]
["012347","c. Erityisopetusta antavan opettajan kelpoisuus taikka ylempi korkeakoulututkinto\n ja perus-/lukio-opetusta antavan opettajan kelpoisuus (47)",null,2563.48,null,2499.2199999999998]
["012346","d. Perus-/lukio-opetusta antavan opettajan kelpoisuus (46)",null,2474.14,null,2413.2399999999998]
["012341","e. Muu kuin edellä mainittu (41)",null,2149.11,null,2098.5300000000002]
[]
["f. Muita määräyksiä"]
["012341","Jos vaikeimmin kehitysvammaisten opettajalla on soveltuva\n  vähintään opistoasteinen tutkinto (41), on hänen peruspalkkansa",null,2149.11,null,2098.5300000000002]
["012344","ja jos hänellä on lisäksi 35 opintoviikon erityisopinnot (44), ",null,2297.54,null,2243.06]
[]
["4. Luokanopettaja"]
["012449","a. Ylempi korkeakoulututkinto, aineen opettajan kelpoisuus  sekä perus-/lukio-opetusta antavan opettajan kelpoisuus (49)",null,2736.59,null,2663.25]
["012448","b. Aineenopettajan kelpoisuus ja perus/lukio-opetusta antavan opettajan kelpoisuus (48), ",null,2623.28,null,2555.29]
["012446","c. Perus/lukio-opetusta antavan opettajan kelpoisuus (46), ",null,2474.14,null,2413.2399999999998]
["012435","d. Muu kuin edellä mainittu (35)",null,1920.08,null,1877.36]
[]
[]
["12 § Oppilaan ohjauksen lehtori"]
[null,"Ylempi korkeakoulututkinto ja perus-/lukio-opetusta antavan opettajan kelpoisuus taikka aiempi vanhemman lehtorin kelpoisuus ",null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["015156","- määrävuosilisään oikeuttavaa aikaa alle 15 vuotta (56 - 59)",null,2853.7," -",3101.57,2775.47," -",3016.51]
["015159","- määrävuosilisään oikeuttavaa aikaa vähintään 15 vuotta (59 - 63)",null,3101.57," -",3588.93,3016.51," -",3490.16]
[null,"Perus-/lukio-opetusta antavan opettajan kelpoisuus"]
["015155","- määrävuosilisään oikeuttavaa aikaa alle 15 vuotta (55 - 58)",null,2789.2," -",3011.46,2712.56," -",2928.45]
["015158","- määrävuosilisään oikeuttavaa aikaa vähintään 15 vuotta (58 - 61)",null,3011.46," -",3319.54,2928.45," -",3228.26]
[null,"Muu kuin edellä mainittu"]
["015143","- määrävuosilisään oikeuttavaa aikaa alle 15 vuotta (43 - 50)",null,1952.75," -",2293.86,1908.2," -",2230.92]
["015146","- määrävuosilisään oikeuttavaa aikaa vähintään 15 vuotta (46 - 53)",null,2078.5500000000002," -",2482.73,2027.36," -",2414.58]
[]
[]
["AIKUISLUKIO JA LUKION AIKUISLINJA"]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["011065","Aikuislukion ja lukion aikuislinjan rehtori (65 - 70)",null,3893.34," -",4883.16,3786.15," -",4748.8100000000004]
[]
["1. Aikuislukion lehtori ",null,null,"I kalleusluokka ",null,"II kalleusluokka "]
["012151","a. Ylempi korkeakoulututkinto ja lukio-opetusta antavan opettajan kelpoisuus taikka aiempi vanhemman lehtorin kelpoisuus (51)",null,2940.36,null,2859.29]
["012150","b. Perusopetusta antavan opettajan tai aiempi lukio-opetusta antavan opettajan kelpoisuus (50)",null,2827.04,null,2749.52]
["012145","c. Ylempi tai alempi korkeakoulututkinto (45)",null,2421.7600000000002,null,2363.62]
["012139","d. Muu kuin edellä mainittu (39)",null,2057.52,null,2011.03]
[]
["                                                       "]
["VAPAAN SIVISTYSTYÖN OPPILAITOKSET"]
[]
["KANSANOPISTOT"]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["021060","Kansanopiston rehtori (60 - 63)",null,3328.82," -",3718.89,3236.89," -",3616.5]
[null,null,null,"I kalleusluokka ",null,"II kalleusluokka "]
["022650","1) ylempi korkeakoulututkinto (50)",null,2528.25,null,2458.9299999999998]
["022645","2) Opetustoimen henkilöstön kelpoisuusvaatimuksista annetun asetuksen 18 §:ssä tarkoitettu muu kelpoisuus 27 §:n siirtymäsäännös huomioiden tai erivapauden nojalla vapaan sivistys-työn opettajan kelpoisuuden saanut henkilö (45)",null,2187.77,null,2135.27]
[]
["KOKONAISTYÖAJASSA OLEVAT KANSANOPISTOT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["KANSALAIS- JA TYÖVÄENOPISTOT"]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["021060","Kansalais- ja työväenopiston rehtori (60 - 63)",null,3203.68," -",3579.07,3115.21," -",3480.54]
["021061","Rehtorille, jolla on ylempi korkeakoulututkinto tai jolla on rehtori- tai johtajapalvelua vähintään 5 vuotta ",null,3310.42," -",3735.06,3219.4," -",3632.2]
["021159","Kokonaispalkkauksessa oleva apulaisrehtori (59 - 60)",null,3172.17," -",3269.29,3085.19," -",3179]
[null,null,null,"I kalleusluokka ",null,"II kalleusluokka "]
["022650","1) ylempi korkeakoulututkinto (50)",null,2528.25,null,2458.9299999999998]
["022645","2) toimeen soveltuva alempi korkeakoulututkinto, ammattikorkeakoulututkinto tai opistoasteen tutkinto tai erivapauden nojalla opettajan toimeen kelpoisuuden saanut (45)",null,2187.77,null,2135.27]
[]
["TUNTIOPETTAJAT (kansanopistojen, kansalais- ja työväenopistojen) sekä opintokeskukset "]
[]
["Tuntiopettajan tuntipalkkiot:"]
[]
[null,null,null,"I kalleusluokka",null,null,"II kalleusluokka"]
[null,null,null,"A-palkkio",null,"B-palkkio","A-palkkio",null,"B-palkkio"]
[null,null,null,"022942",null,"022946","022942",null,"022946"]
[null,"A) ylemmän korkeakoulututkinnon tai ylempi AMK-tutkinnon suorittanut tuntiopettaja",null,27.55,null,29.91,26.92,null,29.2]
[null,null,null,"I kalleusluokka",null,null,"II kalleusluokka"]
[null,null,null,"A-palkkio",null,"B-palkkio","A-palkkio",null,"B-palkkio"]
[null,null,null,"022939",null,"022943","022939",null,"022943"]
[null,"B) alemman korkeakoulututkinnon, ammattikorkeakoulututkinnon, voimistelun-, kuvaamataidon-, musiikin-, kotitalous-, kotiteollisuus- ja käsityönopettajan tutkinnon suorittanut tai opistoinsinöörin tutkinnon  suorittanut tuntiopettaja",null,26.16,null,28.1,25.53,null,27.44]
[null,null,null,"I kalleusluokka",null,null,"II kalleusluokka"]
[null,null,null,"A-palkkio",null,"B-palkkio","A-palkkio",null,"B-palkkio"]
[null,null,null,"022937",null,"022941","022937",null,"022941"]
[null,"C) muu tuntiopettaja",null,25.37,null,27.08,24.8,null,26.41]
[]
["Opintokeskusten tuntiopettajien tuntipalkkiot"]
[null,null,null,"I kalleusluokka",null,null,"II kalleusluokka"]
[null,null,null,"A-palkkio",null,"B-palkkio","A-palkkio",null,"B-palkkio"]
[null,null,null,"022941",null,"022945","022941",null,"022945"]
[null,"D) ylemmän korkeakoulututkinnon tai ylemmän AMK-tutkinnon suorittanut tuntiopettaja",null,27.08,null,29.28,26.41,null,28.6]
[null,null,null,"I kalleusluokka",null,null,"II kalleusluokka"]
[null,null,null,"A-palkkio",null,"B-palkkio","A-palkkio",null,"B-palkkio"]
[null,null,null,"022938",null,"022942","022938",null,"022942"]
[null,"E) alemman korkeakoulututkinnon, ammattikorkeakoulututkinnon, voimistelun-, kuvaamataidon-, musiikin-, kotitalous-, kotiteollisuus- ja käsityönopettajan tutkinnon suorittanut tai opistoinsinöörin tutkinnon suorittanut tuntiopettaja",null,25.77,null,27.55,25.17,null,26.92]
[null,null,null,"I kalleusluokka",null,null,"II kalleusluokka"]
[null,null,null,"A-palkkio",null,"B-palkkio","A-palkkio",null,"B-palkkio"]
[null,null,null,"022936",null,"022940","022936",null,"022940"]
[null,"F) muu tuntiopettaja",null,25.08,null,26.61,24.52,null,25.97]
[]
["URHEILUOPISTOT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MUSIIKKIOPPILAITOKSET"]
[]
["Rehtori",null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["041061","- ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (61 - 66) ",null,3544.13," -",4342.55,3446.68," -",4222.66]
["041060","- muu tutkinto (60 - 65) ",null,3429.86," -",4168.2299999999996,3335.13," -",4053.46]
[]
["Apulaisrehtori "]
["041159","- ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (59 - 63)",null,3252.19," -",3763.24,3163.01," -",3659.63]
["041158","- muu tutkinto (58 - 62)",null,3157.72," -",3616.46,3070.69," -",3517.2]
[]
["1. Konservatorio"]
["043152","a. Yliopettaja (52 - 54)",null,2724.64," -",2906.72,2649.54," -",2826.91]
["043249","b. Lehtori - ylempi KK tai ylempi AMK-tutkinto (49 - 51)",null,2512.5300000000002," -",2662.37,2445.1799999999998," -",2588.94]
["043248","c. Lehtori (48 - 50)",null,2338.62," -",2570.41,2277.9699999999998," -",2526.2600000000002]
[null,"d. Yleisaineiden opettajat "]
["043346"," - ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (46 - 48)",null,2231.0100000000002," -",2338.62,2176.08," -",2277.9699999999998]
["043341","- alempi korkeakoulututkinto (41 - 43)",null,2021.05," -",2095.9899999999998,1975.17," -",2048.15]
[]
["2. Musiikin perusopetus "]
["043449","a. Ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (49 - 51)",null,2512.5300000000002," -",2662.37,2445.1799999999998," -",2588.94]
["043448","b. Soveltuva ammattikorkea-",null,2338.62," -",2570.41,2277.9699999999998," -",2499.94]
["043444","c. Muu soveltuva tutkinto (44 - 46)",null,2137.9699999999998," -",2231.0100000000002,2087.61," -",2176.08]
[]
["PÄÄTOIMISET TUNTIOPETTAJAT"]
[]
["042543","a. Ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (43 - 45)",null,2126.65," -",2215.69,2078.1," -",2162.54]
["042542","b. Soveltuva ammattikorkeakoulututkinto, konservatorion jatkotutkinto tai entinen lehtorin kelpoisuus (42 - 44)",null,2087.3000000000002," -",2169.23,2039.64," -",2118.15]
["042539","c. Muu soveltuva tutkinto (39 - 41)",null,1983.93," -",2050.6,1939.21," -",2004.06]
[null,"d. Yleisaineet "]
["042543","- ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (43 - 45)",null,2126.65," -",2215.69,2078.1," -",2162.54]
["042538","- korkeakoulututkinto (38 - 40)",null,1955.56," -",2016.59,1911.69," -",1970.73]
[]
["SIVUTOIMISET TUNTIOPETTAJAT "]
[]
[null,null,null,"per tunti",null,"kk:ssa"]
[null,"Ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (42)",null,27.87,null,81.319999999999993]
[null,"Soveltuva ammattikorkeakoulututkinto, konservatorion jatkotutkinto tai entinen lehtorin kelpoisuus (41)",null,27.38,null,79.84]
[null,"Muu soveltuva tutkinto (38)",null,23.89,null,69.7]
["Yleisaineet "]
[null,"ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (42)"]
[null,"- opv 20 t/vko - kielet, matematiikka",null,30.69,null,89.44]
[null,"- opv 25 t/vko - liikunta",null,24.55,null,71.55]
[null,"- opv 21 t/vko - muut aineet",null,29.22,null,85.18]
[null,"korkeakoulututkinto (37)"]
[null,"- opv 20 t/vko - kielet, matematiikka",null,28.25,null,82.42]
[null,"- opv 25 t/vko - liikunta",null,22.61,null,65.930000000000007]
[null,"- opv 21 t/vko - muut aineet",null,26.91,null,78.48]
[]
["KUVATAIDEKOULU SEKÄ MONITAITEELLINEN KOULU"]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["051054","Rehtori (54 - 60)",null,2657.47," -",3347.92,2584.52," -",3255.44]
["053442","1. Opettaja (42 - 48)",null,2049.5," -",2330.86,2002.66," -",2270.46]
["053444","2. perusopetuksen, kuvataiteen tai musiikin opettajan kelpoisuus, musiikkioppilaitoksen opettajan kelpoisuus tai asetuksen 948/1998 mukainen pedagoginen kelpoisuus",null,2130.92," -",2453.9299999999998,2080.4," -",2386.67]
[]
["Tuntipalkkiot"]
[null,"7 § 1. Tuntipalkkiot",null,24.58," -",29.71]
[null,"7 § 2. Vähintään 16 viikkotuntia opettavan tuntipalkkio",null,26.11," -",31.48]
[]
[]
["ERÄÄT AMMATILLISET OPPILAITOKSET"]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["061062","Rehtori (62 - 65)",null,3473.86," -",3932.29,3378.54," -",3824.02]
["061160","Apulaisrehtori (60 - 64)",null,3177.85," -",3704.95,3090.08," -",3602.92]
["061359","Aikuiskoulutusjohtaja (59 - 63)",null,3068.12," -",3550.21,2983.99," -",3452.48]
[]
["1. Lehtori (ammatilliset aineet)",null,null,"I kalleusluokka ",null,"II kalleusluokka "]
["063551","ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (51)",null,2856.59,null,2777.81]
["063549","insinööri, rakennusarkkitehti, alempi korkeakoulututkinto, ammattikorkeakoulututkinto (49)",null,2640.32,null,2569.5500000000002]
["063544","ammatinopettajantutkinto  tai vastaava (44)",null,2230.04,null,2177.15]
["063545","opetusministeriön määräämät lisäopinnot suorittanut teknikko tai vastaava (45)",null,2350.6799999999998,null,2294.2399999999998]
["063541","alansa korkein muu koulutus (41)",null,2082.1,null,2033.1]
["063539","teknikon tutkinto tai vast. (39) ",null,1998.9,null,1953.71]
["     "]
["2. Lehtori (yhteiset aineet)"]
["063747","ylempi korkeakoulututkinto tai ylempi AMK-tutkinto(47)",null,2490.46,null,2428.0100000000002]
["063744","muu tutkinto (44)",null,2230.04,null,2177.15]
["3. Lehtori (liikunta ja terveystieto)"]
["063747","ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (47) ",null,2490.46,null,2428.0100000000002]
["063744","muu tutkinto (44) ",null,2230.04,null,2177.15]
[]
[]
["KAUPPAOPPILAITOKSET"]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["071062","Rehtori (62 - 68)",null,3473.86," -",4491.1000000000004,3378.54," -",4367.38]
["071161","Apulaisrehtori (61 - 65)",null,3289.55," -",3868.81,3199.1," -",3762.28]
["071359","Aikuiskoulutusjohtaja (59 - 64)",null,3073.55," -",3711.52,2989.26," -",3609.3]
[]
[null,null,null,"I kalleusluokka ",null,"II kalleusluokka "]
["073551","Lehtori ylempi korkeakoulututkinto tai ylempi AMK-tutkinto(51)",null,2581.69,null,2510.5]
["073547","Lehtori, alempi korkeakoulututkinto tai amk-tutkinto (47)",null,2257.35,null,2200.7600000000002]
["073544","Lehtori,  muu tutkinto (44) ",null,2113.6799999999998,null,2063.5100000000002]
[]
[" "]
["SOSIAALI- JA TERVEYSALAN OPPILAITOS "]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["081061","Rehtori (61 - 65)",null,3343.52," -",3932.29,3251.58," -",3824.02]
["081159","Apulaisrehtori ja ",null,3098.77," -",3550.21,3013.8," -",3452.48]
["081359","aikuiskoulutusjohtaja (59 - 63)"]
[]
["Lehtori ja tuntiopettaja"]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["083556","1. Ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (56 - 59)",null,3052.6," -",3347.61,2968.94," -",3255.79]
["083554","2. Muu tutkinto (54 - 57)",null,2866.72," -",3124.03,2788.01," -",3037.19]
[]
[]
["METSÄ- JA PUUTALOUSOPPILAITOS"]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["091062","Rehtori (62 - 65)",null,3528.17," -",3993.74,3431.31," -",3883.77]
["091161","Apulaisrehtori (61 - 63)",null,3335.03," -",3605.71,3243.36," -",3506.43]
["091359","Aikuiskoulutusjohtaja (59 - 60)",null,3116.04," -",3227.5,3030.6," -",3138.36]
[]
[null,"1. Lehtori (ammatilliset aineet)",null,"I kalleusluokka ",null,"II kalleusluokka "]
["093555","- ylempi korkeakoulututkinto (55)",null,3075.04,null,2990.56]
["093552","- soveltuva ammattikorkea- koulututkinto tai insinööri (52)",null,2751.54,null,2675.74]
["093550","- metsätalousinsinööri, puutalousinsinööri tai vastaava aikaisempi tutkinto (50)",null,2590.89,null,2519.85]
["093549","- teknikko tai opistoasteen tutkinto (49)",null,2532.52,null,2464.66]
["093547","- metsätalous-, sahateollisuus- tai levyteollisuusteknikko (47)",null,2388.96,null,2329.0700000000002]
["093545","- metsätyönopettajan koulutus (45) ",null,2199.0500000000002,null,2146.27]
[null,"2. Lehtori (yhteiset aineet)"]
["093755","- ylempi korkeakoulututkinto(55)",null,3075.04,null,2990.56]

{"sheet":"Taul2","index":1,"n_rows":125,"n_cols":27,"rows_kept":125,"cut":false,"hidden":true,"merged":[[2,13,2,19],[2,20,2,26]]}
[]
[null,null,null,null,null,null,null,null,null,null,"Onko ao. viesti vielä ajankohtainen?"]
[null,"Oppilaitosryhmät",null,"Tilastokoodit","tähän sanallinen, jos voi toisessa alasvedossa viitata 2 sarakkeeseen = hakee sekä koodin, että sanallisen, jos ne on eri sarakkeissa",null,null,null,null,null,"Nyt kaavat käyttävät pelkästään ylituntinpalkkiokerrointa pkl 1:lle. Laita laskuriin myös pkl 2:n ylituntipalkkiokerroin mukaan!",null,null,"Kok.lis.kertoimet haetaan tästä",null,null,null,null,null,null,"Kok.lis.prosentit haetaan tästä"]
[null,"Lukio- ja perusopetus","lukio","lukio","päivitä tähän pkl 1 alarajat","päivitä tähän pkl 2 alarajat","ilman nollaa","I-paikkakuntakalleusluokka","II-paikkakuntakalleusluokka","ylituntipalkkiokerroin pkl 1","ylituntipalkkiokerroin pkl 2","ylituntipalkkiojakaja","sanallinen nimike","alle 3v","3v","5v","8v","13v","15v","20v","alle 3v","3v","5v","8v","13v","15v","20v"]
[null,"Aikuislukio ja lukion aikuislinja","aikuislukio","012151",{"$f":"'ajantasaiset palkat'!D16","v":2940.36},{"$f":"'ajantasaiset palkat'!F16","v":2859.29},{"$f":"MID(D5,2,6)","v":"12151"},{"$f":"+E5","v":2940.36},{"$f":"+F5","v":2859.29},0.82099999999999995,0.84399999999999997,1.5,"Lehtori ja opinto-ohjaaja (lukio), ylempi korkeakoulututkinto ja lukio-opetusta antavan opettajan kelpoisuus taikka aiempi vanhemman lehtorin kelpoisuus (51)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,"Kansanopistot","kansanopistot","012150",{"$f":"'ajantasaiset palkat'!D17","v":2827.04},{"$f":"'ajantasaiset palkat'!F17","v":2749.52},"12150",2827.04,2749.52,0.83099999999999996,0.85499999999999998,1.5,"Lehtori ja opinto-ohjaaja (lukio), perusopetusta antavan opettajan tai aiempi lukio-opetusta antavan opettajan kelpoisuus (50)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,"Kansalais- ja työväen opistot","kansalais","012145",{"$f":"'ajantasaiset palkat'!D18","v":2421.7600000000002},{"$f":"'ajantasaiset palkat'!F18","v":2363.62},"12145",2421.7600000000002,2363.62,0.86399999999999999,0.88500000000000001,1.5,"Lehtori ja opinto-ohjaaja (lukio), ylempi tai alempi korkeakoulututkinto (45)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,"Musiikkioppilaitokset","musiikki","012139",{"$f":"'ajantasaiset palkat'!D19","v":2057.52},{"$f":"'ajantasaiset palkat'!F19","v":2011.03},"12139",2057.52,2011.03,0.90800000000000003,0.93,1.5,"Lehtori ja opinto-ohjaaja (lukio), muu kuin edellä mainittu (39) ",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,"Kuvataidekoulu sekä monitaiteellinen koulu","kuva","012249",{"$f":"'ajantasaiset palkat'!D22","v":2736.59},{"$f":"'ajantasaiset palkat'!F22","v":2663.25},"12249",2736.59,2663.25,0.83799999999999997,0.86099999999999999,1.5,"Lehtori (peruskoulu), ylempi korkeakoulututkinto ja perus-/lukio-opetusta antavan opettajan kelpoisuus tai aiempi vanhemman lehtorin kelpoisuus (49)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,"Eräät ammatilliset oppilaitokset","eraat","012248",{"$f":"'ajantasaiset palkat'!D23","v":2623.28},{"$f":"'ajantasaiset palkat'!F23","v":2555.29},"12248",2623.28,2555.29,0.85199999999999998,0.875,1.5,"Lehtori (peruskoulu), perusopetusta antavan opettajan tai aiempi peruskoulun/lukion opettajan kelpoisuus (48)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,"Kauppaoppilaitokset","kauppa","012244",{"$f":"'ajantasaiset palkat'!D24","v":2297.54},{"$f":"'ajantasaiset palkat'!F24","v":2243.06},"12244",2297.54,2243.06,0.89200000000000002,0.91300000000000003,1.5,"Lehtori (peruskoulu), ylempi korkeakoulututkinto (44)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,"Sosiaali- ja terveysalan oppilaitos","sote","012242",{"$f":"'ajantasaiset palkat'!D25","v":2191.02},{"$f":"'ajantasaiset palkat'!F25","v":2139.16},"12242",2191.02,2139.16,0.89900000000000002,0.92100000000000004,1.5,"Lehtori (peruskoulu), alempi korkeakoulututkinto (42)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,"Metsä- ja puutalousoppilaitos","metsa","012239",{"$f":"'ajantasaiset palkat'!D26","v":2057.52},{"$f":"'ajantasaiset palkat'!F26","v":2011.03},"12239",2057.52,2011.03,0.90800000000000003,0.93,1.5,"Lehtori (peruskoulu), muu kuin edellä mainittu (39)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,null,null,"012349",{"$f":"'ajantasaiset palkat'!D29","v":2736.59},{"$f":"'ajantasaiset palkat'!F29","v":2663.25},"12349",2736.59,2663.25,0.83799999999999997,0.86099999999999999,1.5,"Erityisopettaja ja erityisluokanopettaja, ylempi korkeakoulututkinto ja erityisopetusta antavan opettajan kelpoisuus (49)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,null,null,"012348",{"$f":"'ajantasaiset palkat'!D30","v":2623.28},{"$f":"'ajantasaiset palkat'!F30","v":2555.29},"12348",2623.28,2555.29,0.85199999999999998,0.875,1.5,"Erityisopettaja ja erityisluokanopettaja, alempi korkeakoulututkinto ja erityisopetusta antavan opettajan kelpoisuus (48)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,"Valittuna",null,"012347",{"$f":"'ajantasaiset palkat'!D31","v":2563.48},{"$f":"'ajantasaiset palkat'!F31","v":2499.2199999999998},"12347",2563.48,2499.2199999999998,0.85199999999999998,0.874,1.5,"Erityisopettaja ja erityisluokanopettaja, erityisopetusta antavan opettajan kelpoisuus taikka ylempi korkeakoulututkinto ja perus-/lukio-opetusta antavan opettajan kelpoisuus (47)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,"Kuvataidekoulu sekä monitaiteellinen koulu",null,"012346",{"$f":"'ajantasaiset palkat'!D32","v":2474.14},{"$f":"'ajantasaiset palkat'!F32","v":2413.2399999999998},"12346",2474.14,2413.2399999999998,0.86299999999999999,0.88500000000000001,1.5,"Erityisopettaja ja erityisluokanopettaja, perus-/lukio-opetusta antavan opettajan kelpoisuus (46)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,null,null,"012341",{"$f":"'ajantasaiset palkat'!D33","v":2149.11},{"$f":"'ajantasaiset palkat'!F33","v":2098.5300000000002},"12341",2149.11,2098.5300000000002,0.9,0.92200000000000004,1.5,"Erityisopettaja ja erityisluokanopettaja, muu kuin edellä mainittu (41)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,null,null,"012341",{"$f":"'ajantasaiset palkat'!D36","v":2149.11},{"$f":"'ajantasaiset palkat'!F36","v":2098.5300000000002},"12341",2149.11,2098.5300000000002,0.9,0.92200000000000004,1.5,"Muita määräyksiä, jos vaikeimmin kehitysvammaisten opettajalla on soveltuva vähintään opistoasteinen tutkinto (41)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,null,null,"012344",{"$f":"'ajantasaiset palkat'!D37","v":2297.54},{"$f":"'ajantasaiset palkat'!F37","v":2243.06},"12344",2297.54,2243.06,0.89200000000000002,0.91300000000000003,1.5,"Muita määräyksiä, jos vaikeimmin kehitysvammaisten opettajalla on soveltuva vähintään opistoasteinen tutkinto ja jos hänellä on lisäksi 35 opintoviikon erityisopinnot (44)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,null,null,"012449",{"$f":"'ajantasaiset palkat'!D40","v":2736.59},{"$f":"'ajantasaiset palkat'!F40","v":2663.25},"12449",2736.59,2663.25,0.83799999999999997,0.86099999999999999,1.5,"Luokanopettaja, ylempi korkeakoulututkinto, aineen opettajan kelpoisuus  sekä perus-/lukio-opetusta antavan opettajan kelpoisuus (49)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,null,null,"012448",{"$f":"'ajantasaiset palkat'!D41","v":2623.28},{"$f":"'ajantasaiset palkat'!F41","v":2555.29},"12448",2623.28,2555.29,0.85199999999999998,0.875,1.5,"Luokanopettaja, aineenopettajan kelpoisuus ja perus/lukio-opetusta antavan opettajan kelpoisuus (48)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,null,null,"012446",{"$f":"'ajantasaiset palkat'!D42","v":2474.14},{"$f":"'ajantasaiset palkat'!F42","v":2413.2399999999998},"12446",2474.14,2413.2399999999998,0.86299999999999999,0.88500000000000001,1.5,"Luokanopettaja, perus/lukio-opetusta antavan opettajan kelpoisuus (46)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,1,null,"012435",{"$f":"'ajantasaiset palkat'!D43","v":1920.08},{"$f":"'ajantasaiset palkat'!F43","v":1877.36},"12435",1920.08,1877.36,0.92500000000000004,0.94699999999999995,1.5,"Luokanopettaja, muu kuin edellä mainittu (35)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,1,null,"015156",{"$f":"'ajantasaiset palkat'!D48","v":2853.7},{"$f":"'ajantasaiset palkat'!G48","v":2775.47},"15156",2853.7,2775.47,1,1,1.5,"Oppilaan ohjauksen lehtori, ylempi korkeakoulututkinto ja perus-/lukio-opetusta antavan opettajan kelpoisuus taikka aiempi vanhemman lehtorin kelpoisuus, määrävuosilisään oikeuttavaa aikaa alle 15 vuotta (56 - 59)",0,0.05,0.10249999999999999,0.15762499999999999,0.21550625000000001,0.21550625000000001,0.21550625000000001,0,0.05,0.05,0.05,0.05,0,0]
[null,null,null,"015159",{"$f":"'ajantasaiset palkat'!D49","v":3101.57},{"$f":"'ajantasaiset palkat'!G49","v":3016.51},"15159",3101.57,3016.51,1,1,1.5,"Oppilaan ohjauksen lehtori, ylempi korkeakoulututkinto ja perus-/lukio-opetusta antavan opettajan kelpoisuus taikka aiempi vanhemman lehtorin kelpoisuus, määrävuosilisään oikeuttavaa aikaa vähintään 15 vuotta (59 - 63)",0,0.05,0.10249999999999999,0.15762499999999999,0.21550625000000001,0.21550625000000001,0.21550625000000001,0,0.05,0.05,0.05,0.05,0,0]
[null,null,null,"015155",{"$f":"'ajantasaiset palkat'!D51","v":2789.2},{"$f":"'ajantasaiset palkat'!G51","v":2712.56},"15155",2789.2,2712.56,1,1,1.5,"Oppilaan ohjauksen lehtori, perus-/lukio-opetusta antavan opettajan kelpoisuus, määrävuosilisään oikeuttavaa aikaa alle 15 vuotta (55 - 58)",0,0.05,0.10249999999999999,0.15762499999999999,0.21550625000000001,0.21550625000000001,0.21550625000000001,0,0.05,0.05,0.05,0.05,0,0]
[null,"Valittu oppilaitosryhmä",null,"015158",{"$f":"'ajantasaiset palkat'!D52","v":3011.46},{"$f":"'ajantasaiset palkat'!G52","v":2928.45},"15158",3011.46,2928.45,1,1,1.5,"Oppilaan ohjauksen lehtori, perus-/lukio-opetusta antavan opettajan kelpoisuus, määrävuosilisään oikeuttavaa aikaa vähintään 15 vuotta (58 - 61)",0,0.05,0.10249999999999999,0.15762499999999999,0.21550625000000001,0.21550625000000001,0.21550625000000001,0,0.05,0.05,0.05,0.05,0,0]
[null,{"$f":"INDEX(oppilaitosryhmat,B24)","v":"Lukio- ja perusopetus"},null,"015143",{"$f":"'ajantasaiset palkat'!D54","v":1952.75},{"$f":"'ajantasaiset palkat'!G54","v":1908.2},"15143",1952.75,1908.2,1,1,1.5,"Muu kuin edellä mainittu, määrävuosilisään oikeuttavaa aikaa alle 15 vuotta (43 - 50)",0,0.05,0.10249999999999999,0.15762499999999999,0.21550625000000001,0.21550625000000001,0.21550625000000001,0,0.05,0.05,0.05,0.05,0,0]
[null,null,null,"015146",{"$f":"'ajantasaiset palkat'!D55","v":2078.5500000000002},{"$f":"'ajantasaiset palkat'!G55","v":2027.36},"15146",2078.5500000000002,2027.36,1,1,1.5,"Muu kuin edellä mainittu, määrävuosilisään oikeuttavaa aikaa vähintään 15 vuotta (46 - 53)",0,0.05,0.10249999999999999,0.15762499999999999,0.21550625000000001,0.21550625000000001,0.21550625000000001,0,0.05,0.05,0.05,0.05,0,0]
[null,"Valittu tilastokoodi",null,"aikuislukio",null,null,"ikuisl",0,0,{"$f":"+G31","v":"ikuisl"},{"$f":"+J31","v":"ikuisl"},1.5,{"$f":"+K31","v":"ikuisl"},1,1,1,1,1,1,1]
[null,{"$f":"INDEX(oppryh,Taul2!$B$24)","v":"lukio"},null,"012151",{"$f":"'ajantasaiset palkat'!D63","v":2940.36},{"$f":"'ajantasaiset palkat'!F63","v":2859.29},"12151",2940.36,2859.29,0.82099999999999995,0.84399999999999997,1.5,"Aikuislukion lehtori, ylempi korkeakoulututkinto ja lukio-opetusta antavan opettajan kelpoisuus taikka aiempi vanhemman lehtorin kelpoisuus (51)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,{"$f":"INDEX(INDIRECT(INDEX(oppryh,Taul2!$B$24)),B25)","v":"012151"},null,"012150",{"$f":"'ajantasaiset palkat'!D64","v":2827.04},{"$f":"'ajantasaiset palkat'!F64","v":2749.52},"12150",2827.04,2749.52,0.83099999999999996,0.85499999999999998,1.5,"Aikuislukion lehtori, perusopetusta antavan opettajan tai aiempi lukio-opetusta antavan opettajan kelpoisuus (50)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
["tässä ilman nollaa",{"$f":"+MID(B33,2,6)","v":"12151"},null,"012145",{"$f":"'ajantasaiset palkat'!D65","v":2421.7600000000002},{"$f":"'ajantasaiset palkat'!F65","v":2363.62},"12145",2421.7600000000002,2363.62,0.86399999999999999,0.88500000000000001,1.5,"Aikuislukion lehtori, ylempi tai alempi korkeakoulututkinto (45)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,"PKL",null,"012139",{"$f":"'ajantasaiset palkat'!D66","v":2057.52},{"$f":"'ajantasaiset palkat'!F66","v":2011.03},"12139",2057.52,2011.03,0.90800000000000003,0.93,1.5,"Aikuislukion lehtori, muu kuin edellä mainittu (39)",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,1,null,"kansanopistot",null,null,"ansano",0,0,{"$f":"+G36","v":"ansano"},{"$f":"+J36","v":"ansano"},0,{"$f":"+K36","v":"ansano"},1,1,1,1,1,1,1]
[null,null,null,"022650",{"$f":"'ajantasaiset palkat'!D75","v":2528.25},{"$f":"'ajantasaiset palkat'!F75","v":2458.9299999999998},"22650",2528.25,2458.9299999999998,0.94899999999999995,0.97599999999999998,0,"Opettaja, ylempi korkeakoulututkinto (50)",0,0.05,0.11300000000000021,0.19091000000000036,0.2742737000000004,0.2742737000000004,0.35073012200000053,0,0.05,0.06,7.0000000000000007E-2,7.0000000000000007E-2,0,0.06]
[null,"Peruspalkka alarajalla",null,"022645",{"$f":"'ajantasaiset palkat'!D76","v":2187.77},{"$f":"'ajantasaiset palkat'!F76","v":2135.27},"22645",2187.77,2135.27,0.94599999999999995,1,0,"Opettaja, opetustoimen henkilöstön kelpoisuusvaatimuksista annetun asetuksen 18 §:ssä tarkoitettu muu kelpoisuus 27 §:n siirtymäsäännös huomioiden tai erivapauden nojalla vapaan sivistystyön opettajan kelpoisuuden saanut henkilö (45)",0,0.05,0.11300000000000021,0.19091000000000036,0.2742737000000004,0.2742737000000004,0.35073012200000053,0,0.05,0.06,7.0000000000000007E-2,7.0000000000000007E-2,0,0.06]
[null,{"$f":"VLOOKUP(B34,G5:I84,B36+1,FALSE)","v":2940.36},null,"kansalais",null,null,"ansala",0,0,{"$f":"+G39","v":"ansala"},{"$f":"+J39","v":"ansala"},0,{"$f":"+K39","v":"ansala"},1,1,1,1,1,1,1]
[null,null,null,"022650",{"$f":"'ajantasaiset palkat'!D121","v":2528.25},{"$f":"'ajantasaiset palkat'!F121","v":2458.9299999999998},"22650",2528.25,2458.9299999999998,1,1,0,"Opettaja, ylempi korkeakoulututkinto (50)",0,0.05,0.11300000000000021,0.19091000000000036,0.2742737000000004,0.2742737000000004,0.35073012200000053,0,0.05,0.06,7.0000000000000007E-2,7.0000000000000007E-2,0,0.06]
[null,"OPV",null,"022645",{"$f":"'ajantasaiset palkat'!D122","v":2187.77},{"$f":"'ajantasaiset palkat'!F122","v":2135.27},"22645",2187.77,2135.27,1,1,0,"Opettaja, toimeen soveltuva alempi korkeakoulututkinto, ammattikorkeakoulututkinto tai opistoasteen tutkinto tai erivapauden nojalla opettajan toimeen kelpoisuuden saanut (45)",0,0.05,0.11300000000000021,0.19091000000000036,0.2742737000000004,0.2742737000000004,0.35073012200000053,0,0.05,0.06,7.0000000000000007E-2,7.0000000000000007E-2,0,0.06]
[null,{"$f":"+Laskuri!O23","v":19},null,"musiikki",null,null,{"$f":"MID(D42,2,6)","v":"usiikk"},{"$f":"+E42","v":0},{"$f":"+F42","v":0},{"$f":"+G42","v":"usiikk"},{"$f":"+J42","v":"usiikk"},0,{"$f":"+K42","v":"usiikk"},1,1,1,1,1,1,1]
[null,"Ylitunnin kk-hinta",null,"043152",{"$f":"'ajantasaiset palkat'!D199","v":2724.64},{"$f":"'ajantasaiset palkat'!G199","v":2649.54},"43152",2724.64,2649.54,1,1,0,"Konservatorion yliopettaja (52 - 54)",0,0.05,0.11300000000000021,0.19091000000000036,0.2861828000000004,0.2861828000000004,0.32476828400000035,0,0.05,0.06,7.0000000000000007E-2,0.08,0,0.03]
["yt jakaja",{"$f":"+VLOOKUP(B34,G5:L84,6,FALSE)","v":1.5},null,"043249",{"$f":"'ajantasaiset palkat'!D200","v":2512.5300000000002},{"$f":"'ajantasaiset palkat'!G200","v":2445.1799999999998},"43249",2512.5300000000002,2445.1799999999998,1,1,0,"Konservatorion lehtori - ylempi KK tai ylempi AMK-tutkinto (49 - 51)",0,0.05,0.11300000000000021,0.19091000000000036,0.2861828000000004,0.2861828000000004,0.32476828400000035,0,0.05,0.06,7.0000000000000007E-2,0.08,0,0.03]
["yt kerroin",{"$f":"VLOOKUP(B34,G5:K84,B36+3,FALSE)","v":0.82099999999999995},null,"043248",{"$f":"'ajantasaiset palkat'!D201","v":2338.62},{"$f":"'ajantasaiset palkat'!G201","v":2277.9699999999998},"43248",2338.62,2277.9699999999998,1,1,0,"Konservatorion lehtori (48 - 50)",0,0.05,0.11300000000000021,0.19091000000000036,0.2861828000000004,0.2861828000000004,0.32476828400000035,0,0.05,0.06,7.0000000000000007E-2,0.08,0,0.03]
[null,{"$f":"((Laskuri!O29+B79+B80+B81+B82)*B122)/(B42-B44)","v":137.94488914285714},null,"043346",{"$f":"'ajantasaiset palkat'!D203","v":2231.0100000000002},{"$f":"'ajantasaiset palkat'!G203","v":2176.08},"43346",2231.0100000000002,2176.08,1,1,0,"Konservatorion yleisaineiden opettaja, ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (46 - 48)",0,0.05,0.11300000000000021,0.19091000000000036,0.2861828000000004,0.2861828000000004,0.32476828400000035,0,0.05,0.06,7.0000000000000007E-2,0.08,0,0.03]
[null,"Prosentuaalinen lisä",null,"043341",{"$f":"'ajantasaiset palkat'!D204","v":2021.05},{"$f":"'ajantasaiset palkat'!G204","v":1975.17},"43341",2021.05,1975.17,1,1,0,"Konservatorion yleisaineiden opettaja, alempi korkeakoulututkinto (41 - 43)",0,0.05,0.11300000000000021,0.19091000000000036,0.2861828000000004,0.2861828000000004,0.32476828400000035,0,0.05,0.06,7.0000000000000007E-2,0.08,0,0.03]
[null,{"$f":"+Laskuri!#REF!","v":{"$error":"#REF!"}},null,"043449",{"$f":"'ajantasaiset palkat'!D207","v":2512.5300000000002},{"$f":"'ajantasaiset palkat'!G207","v":2445.1799999999998},"43449",2512.5300000000002,2445.1799999999998,1,1,0,"Musiikin perusopetuksen opettaja, ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (49 - 51)",0,0.05,0.11300000000000021,0.19091000000000036,0.2861828000000004,0.2861828000000004,0.32476828400000035,0,0.05,0.06,7.0000000000000007E-2,0.08,0,0.03]
[null,null,null,"043448",{"$f":"'ajantasaiset palkat'!D208","v":2338.62},{"$f":"'ajantasaiset palkat'!G208","v":2277.9699999999998},"43448",2338.62,2277.9699999999998,1,1,0,"Musiikin perusopetuksen opettaja, soveltuva ammattikorkeakoulututkinto, konservatorion jatkotutkinto tai entinen lehtorin kelpoisuus (48 - 50)",0,0.05,0.11300000000000021,0.19091000000000036,0.2861828000000004,0.2861828000000004,0.32476828400000035,0,0.05,0.06,7.0000000000000007E-2,0.08,0,0.03]
[null,"Pros.lisä euroina",null,"043444",{"$f":"'ajantasaiset palkat'!D209","v":2137.9699999999998},{"$f":"'ajantasaiset palkat'!G209","v":2087.61},"43444",2137.9699999999998,2087.61,1,1,0,"Musiikin perusopetuksen opettaja, muu soveltuva tutkinto (44 - 46)",0,0.05,0.11300000000000021,0.19091000000000036,0.2861828000000004,0.2861828000000004,0.32476828400000035,0,0.05,0.06,7.0000000000000007E-2,0.08,0,0.03]
[null,{"$f":"+B48*B39","v":{"$error":"#REF!"}},null,"042543",{"$f":"'ajantasaiset palkat'!D213","v":2126.65},{"$f":"'ajantasaiset palkat'!G213","v":2078.1},"42543",2126.65,2078.1,1,1,0,"Päätoiminen tuntiopettaja, ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (43 - 45)",0,0.05,0.11300000000000021,0.19091000000000036,0.2861828000000004,0.2861828000000004,0.32476828400000035,0,0.05,0.06,7.0000000000000007E-2,0.08,0,0.03]
[null,null,null,"042542",{"$f":"'ajantasaiset palkat'!D214","v":2087.3000000000002},{"$f":"'ajantasaiset palkat'!G214","v":2039.64},"42542",2087.3000000000002,2039.64,1,1,0,"Päätoiminen tuntiopettaja, soveltuva ammattikorkeakoulututkinto, konservatorion jatkotutkinto tai entinen lehtorin kelpoisuus (42 - 44)",0,0.05,0.11300000000000021,0.19091000000000036,0.2861828000000004,0.2861828000000004,0.32476828400000035,0,0.05,0.06,7.0000000000000007E-2,0.08,0,0.03]
[null,"Tehtäväkoht. Lisä",null,"042539",{"$f":"'ajantasaiset palkat'!D215","v":1983.93},{"$f":"'ajantasaiset palkat'!G215","v":1939.21},"42539",1983.93,1939.21,1,1,0,"Päätoiminen tuntiopettaja, muu soveltuva tutkinto (39 - 41)",0,0.05,0.11300000000000021,0.19091000000000036,0.2861828000000004,0.2861828000000004,0.32476828400000035,0,0.05,0.06,7.0000000000000007E-2,0.08,0,0.03]
[null,{"$f":"+Laskuri!O20","v":0},null,"042543",{"$f":"'ajantasaiset palkat'!D217","v":2126.65},{"$f":"'ajantasaiset palkat'!G217","v":2078.1},"42543",2126.65,2078.1,1,1,0,"Päätoiminen tuntiopettaja, yleisaineet, ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (43 - 45)",0,0.05,0.11300000000000021,0.19091000000000036,0.2861828000000004,0.2861828000000004,0.32476828400000035,0,0.05,0.06,7.0000000000000007E-2,0.08,0,0.03]
[null,null,null,"042538",{"$f":"'ajantasaiset palkat'!D218","v":1955.56},{"$f":"'ajantasaiset palkat'!G218","v":1911.69},"42538",1955.56,1911.69,1,1,0,"Päätoiminen tuntiopettaja, yleisaineet, korkeakoulututkinto (38 - 40)",0,0.05,0.11300000000000021,0.19091000000000036,0.2861828000000004,0.2861828000000004,0.32476828400000035,0,0.05,0.06,7.0000000000000007E-2,0.08,0,0.03]
[null,"Kokemuslisäkerroin",null,"kuva",null,null,"uva",0,0,{"$f":"+G56","v":"uva"},{"$f":"+J56","v":"uva"},0,{"$f":"+K56","v":"uva"},1,1,1,1,1,1,1]
[null,{"$f":"VLOOKUP(B34,G5:T84,7+C89,FALSE)","v":0},null,"053442",{"$f":"'ajantasaiset palkat'!D239","v":2049.5},{"$f":"'ajantasaiset palkat'!G239","v":2002.66},"53442",2049.5,2002.66,1,1,0,"Opettaja (42 - 48)",0,0.05,0.10250000000000004,0.15762500000000013,0.25023500000000021,0.25023500000000021,0.2877420500000003,0,0.05,0.05,0.05,0.08,0,0.03]
[null,{"$f":"+B57*Laskuri!O29","v":0},null,"053444",{"$f":"'ajantasaiset palkat'!D240","v":2130.92},{"$f":"'ajantasaiset palkat'!G240","v":2080.4},"53444",2130.92,2080.4,1,1,0,"Opettaja, perusopetuksen, kuvataiteen tai musiikin opettajan kelpoisuus, musiikkioppilaitoksen opettajan kelpoisuus tai asetuksen 948/1998 mukainen pedagoginen kelpoisuus",0,0.05,0.10250000000000004,0.15762500000000013,0.25023500000000021,0.25023500000000021,0.2877420500000003,0,0.05,0.05,0.05,0.08,0,0.03]
[null,null,null,"eraat",null,null,"raat",0,0,{"$f":"+G59","v":"raat"},{"$f":"+J59","v":"raat"},0,{"$f":"+K59","v":"raat"},1,1,1,1,1,1,1]
[null,"Epäpätevyysalennus",null,"063551",{"$f":"'ajantasaiset palkat'!D254","v":2856.59},{"$f":"'ajantasaiset palkat'!F254","v":2777.81},"63551",2856.59,2777.81,1,1,0,"Lehtori (ammatilliset aineet), ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (51)",0,0.05,0.10250000000000004,0.20172500000000015,0.26181125000000027,0.33751992500000028,0.41777112050000031,0,0.05,0.05,0.09,0.05,0.06,0.06]
[null,{"$f":"+Laskuri!N21","v":0},null,"063549",{"$f":"'ajantasaiset palkat'!D255","v":2640.32},{"$f":"'ajantasaiset palkat'!F255","v":2569.5500000000002},"63549",2640.32,2569.5500000000002,1,1,0,"Lehtori (ammatilliset aineet), insinööri, rakennusarkkitehti, alempi korkeakoulututkinto, ammattikorkeakoulututkinto (49)",0,0.05,0.10250000000000004,0.20172500000000015,0.26181125000000027,0.33751992500000028,0.41777112050000031,0,0.05,0.05,0.09,0.05,0.06,0.06]
[null,{"$f":"+B61*-1","v":0},null,"063544",{"$f":"'ajantasaiset palkat'!D256","v":2230.04},{"$f":"'ajantasaiset palkat'!F256","v":2177.15},"63544",2230.04,2177.15,1,1,0,"Lehtori (ammatilliset aineet), ammatinopettajantutkinto  tai vastaava (44)",0,0.05,0.10250000000000004,0.20172500000000015,0.26181125000000027,0.33751992500000028,0.41777112050000031,0,0.05,0.05,0.09,0.05,0.06,0.06]
[null,{"$f":"+B62*B39","v":0},null,"063545",{"$f":"'ajantasaiset palkat'!D257","v":2350.6799999999998},{"$f":"'ajantasaiset palkat'!F257","v":2294.2399999999998},"63545",2350.6799999999998,2294.2399999999998,1,1,0,"Lehtori (ammatilliset aineet), opetusministeriön määräämät lisäopinnot suorittanut teknikko tai vastaava (45)",0,0.05,0.10250000000000004,0.20172500000000015,0.26181125000000027,0.33751992500000028,0.41777112050000031,0,0.05,0.05,0.09,0.05,0.06,0.06]
[null,null,null,"063541",{"$f":"'ajantasaiset palkat'!D258","v":2082.1},{"$f":"'ajantasaiset palkat'!F258","v":2033.1},"63541",2082.1,2033.1,1,1,0,"Lehtori (ammatilliset aineet), alansa korkein muu koulutus (41)",0,0.05,0.10250000000000004,0.20172500000000015,0.26181125000000027,0.33751992500000028,0.41777112050000031,0,0.05,0.05,0.09,0.05,0.06,0.06]
[null,null,null,"063539",{"$f":"'ajantasaiset palkat'!D259","v":1998.9},{"$f":"'ajantasaiset palkat'!F259","v":1953.71},"63539",1998.9,1953.71,1,1,0,"Lehtori (ammatilliset aineet), teknikon tutkinto tai vast. (39) ",0,0.05,0.10250000000000004,0.20172500000000015,0.26181125000000027,0.33751992500000028,0.41777112050000031,0,0.05,0.05,0.09,0.05,0.06,0.06]
[null,0.03,null,"063747",{"$f":"'ajantasaiset palkat'!D262","v":2490.46},{"$f":"'ajantasaiset palkat'!F262","v":2428.0100000000002},"63747",2490.46,2428.0100000000002,1,1,0,"Lehtori (yhteiset aineet), ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (47)",0,0.05,0.10250000000000004,0.20172500000000015,0.26181125000000027,0.33751992500000028,0.41777112050000031,0,0.05,0.05,0.09,0.05,0.06,0.06]
[null,"pätevyyslisät",null,"063744",{"$f":"'ajantasaiset palkat'!D263","v":2230.04},{"$f":"'ajantasaiset palkat'!F263","v":2177.15},"63744",2230.04,2177.15,1,1,0,"Lehtori (yhteiset aineet), muu tutkinto (44)",0,0.05,0.10250000000000004,0.20172500000000015,0.26181125000000027,0.33751992500000028,0.41777112050000031,0,0.05,0.05,0.09,0.05,0.06,0.06]
["erkka",false,{"$f":"IF(B68=TRUE,0.22,)","v":0},"063747",{"$f":"'ajantasaiset palkat'!D265","v":2490.46},{"$f":"'ajantasaiset palkat'!F265","v":2428.0100000000002},"63747",2490.46,2428.0100000000002,1,1,0,"Lehtori (liikunta ja terveystieto), ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (47) ",0,0.05,0.10250000000000004,0.20172500000000015,0.26181125000000027,0.33751992500000028,0.41777112050000031,0,0.05,0.05,0.09,0.05,0.06,0.06]
["luki",false,{"$f":"IF(B69=TRUE,0.06,)","v":0},"063744",{"$f":"'ajantasaiset palkat'!D266","v":2230.04},{"$f":"'ajantasaiset palkat'!F266","v":2177.15},"63744",2230.04,2177.15,1,1,0,"Lehtori (liikunta ja terveystieto), muu tutkinto (44) ",0,0.05,0.10250000000000004,0.20172500000000015,0.26181125000000027,0.33751992500000028,0.41777112050000031,0,0.05,0.05,0.09,0.05,0.06,0.06]
["opo",false,{"$f":"IF(B70=TRUE,B73,)","v":0},"kauppa",null,null,"auppa",0,0,{"$f":"+G70","v":"auppa"},{"$f":"+J70","v":"auppa"},0,{"$f":"+K70","v":"auppa"},1,1,1,1,1,1,1]
["viittoma",false,{"$f":"IF(B71=TRUE,0.03,)","v":0},"073551",{"$f":"'ajantasaiset palkat'!D276","v":2581.69},{"$f":"'ajantasaiset palkat'!F276","v":2510.5},"73551",2581.69,2510.5,1,1,0,"Lehtori ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (51)",0,7.0000000000000007E-2,0.14490000000000003,0.2250430000000001,0.32304644000000016,0.32304644000000016,0.40242922640000023,0,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,0.08,0,0.06]
[null,null,null,"073547",{"$f":"'ajantasaiset palkat'!D277","v":2257.35},{"$f":"'ajantasaiset palkat'!F277","v":2200.7600000000002},"73547",2257.35,2200.7600000000002,1,1,0,"Lehtori, alempi korkeakoulututkinto tai amk-tutkinto (47)",0,7.0000000000000007E-2,0.14490000000000003,0.2250430000000001,0.32304644000000016,0.32304644000000016,0.40242922640000023,0,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,0.08,0,0.06]
["opolisän haku",{"$f":"INDEX(J104:J113,B24)","v":0.03},null,"073544",{"$f":"'ajantasaiset palkat'!D278","v":2113.6799999999998},{"$f":"'ajantasaiset palkat'!F278","v":2063.5100000000002},"73544",2113.6799999999998,2063.5100000000002,1,1,0,"Lehtori, muu tutkinto (44) ",0,7.0000000000000007E-2,0.14490000000000003,0.2250430000000001,0.32304644000000016,0.32304644000000016,0.40242922640000023,0,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,0.08,0,0.06]
[null,0.22,null,"sote",null,null,"ote",0,0,{"$f":"+G74","v":"ote"},{"$f":"+J74","v":"ote"},0,{"$f":"+K74","v":"ote"},1,1,1,1,1,1,1]
[null,0.06,null,"083556",{"$f":"'ajantasaiset palkat'!D289","v":3052.6},{"$f":"'ajantasaiset palkat'!G289","v":2968.94},"83556",3052.6,2968.94,1,1,0,"Lehtori ja tuntiopettaja, ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (56 - 59)",0,0.05,0.11300000000000021,0.17978000000000027,0.23876900000000023,0.23876900000000023,0.28831976000000026,0,0.05,0.06,0.06,0.05,0,0.04]
[null,0.03,null,"083554",{"$f":"'ajantasaiset palkat'!D290","v":2866.72},{"$f":"'ajantasaiset palkat'!G290","v":2788.01},"83554",2866.72,2788.01,1,1,0,"Lehtori, muu tutkinto (54 - 57)",0,0.05,0.11300000000000021,0.17978000000000027,0.23876900000000023,0.23876900000000023,0.28831976000000026,0,0.05,0.06,0.06,0.05,0,0.04]
[null,0.03,null,"metsa",null,null,"etsa",0,0,{"$f":"+G77","v":"etsa"},{"$f":"+J77","v":"etsa"},0,{"$f":"+K77","v":"etsa"},1,1,1,1,1,1,1]
["euroina",null,null,"093555",{"$f":"'ajantasaiset palkat'!D300","v":3075.04},{"$f":"'ajantasaiset palkat'!F300","v":2990.56},"93555",3075.04,2990.56,1,1,0,"Lehtori (ammatilliset aineet), ylempi korkeakoulututkinto (55)",0,0.05,0.12350000000000017,0.22461500000000023,0.33483035000000028,0.33483035000000028,0.41492017100000034,0,0.05,7.0000000000000007E-2,0.09,0.09,0,0.06]
["erkka",{"$f":"+C68*Laskuri!O29","v":0},null,"093552",{"$f":"'ajantasaiset palkat'!D301","v":2751.54},{"$f":"'ajantasaiset palkat'!F301","v":2675.74},"93552",2751.54,2675.74,1,1,0,"Lehtori (ammatilliset aineet), soveltuva ammattikorkea- koulututkinto tai insinööri (52)",0,0.05,0.12350000000000017,0.22461500000000023,0.33483035000000028,0.33483035000000028,0.41492017100000034,0,0.05,7.0000000000000007E-2,0.09,0.09,0,0.06]
["luki",{"$f":"+C69*Laskuri!O29","v":0},null,"093550",{"$f":"'ajantasaiset palkat'!D302","v":2590.89},{"$f":"'ajantasaiset palkat'!F302","v":2519.85},"93550",2590.89,2519.85,1,1,0,"Lehtori (ammatilliset aineet), metsätalousinsinööri, puutalousinsinööri tai vastaava aikaisempi tutkinto (50)",0,0.05,0.12350000000000017,0.22461500000000023,0.33483035000000028,0.33483035000000028,0.41492017100000034,0,0.05,7.0000000000000007E-2,0.09,0.09,0,0.06]
["opo",{"$f":"+C70*Laskuri!O29","v":0},null,"093549",{"$f":"'ajantasaiset palkat'!D303","v":2532.52},{"$f":"'ajantasaiset palkat'!F303","v":2464.66},"93549",2532.52,2464.66,1,1,0,"Lehtori (ammatilliset aineet), teknikko tai opistoasteen tutkinto (49)",0,0.05,0.12350000000000017,0.22461500000000023,0.33483035000000028,0.33483035000000028,0.41492017100000034,0,0.05,7.0000000000000007E-2,0.09,0.09,0,0.06]
["viittoma",{"$f":"+Taul2!C71*Laskuri!O29","v":0},null,"093547",{"$f":"'ajantasaiset palkat'!D304","v":2388.96},{"$f":"'ajantasaiset palkat'!F304","v":2329.0700000000002},"93547",2388.96,2329.0700000000002,1,1,0,"Lehtori (ammatilliset aineet), metsätalous-, sahateollisuus- tai levyteollisuusteknikko (47)",0,0.05,0.12350000000000017,0.22461500000000023,0.33483035000000028,0.33483035000000028,0.41492017100000034,0,0.05,7.0000000000000007E-2,0.09,0.09,0,0.06]
[null,null,null,"093545",{"$f":"'ajantasaiset palkat'!D305","v":2199.0500000000002},{"$f":"'ajantasaiset palkat'!F305","v":2146.27},"93545",2199.0500000000002,2146.27,1,1,0,"Lehtori (ammatilliset aineet), metsätyönopettajan koulutus (45) ",0,0.05,0.12350000000000017,0.22461500000000023,0.33483035000000028,0.33483035000000028,0.41492017100000034,0,0.05,7.0000000000000007E-2,0.09,0.09,0,0.06]
[null,null,null,"093755",{"$f":"'ajantasaiset palkat'!D307","v":3075.04},{"$f":"'ajantasaiset palkat'!F307","v":2990.56},"93755",3075.04,2990.56,1,1,0,"Lehtori (yhteiset aineet), ylempi korkeakoulututkinto (55)",0,0.05,0.12350000000000017,0.22461500000000023,0.33483035000000028,0.33483035000000028,0.41492017100000034,0,0.05,7.0000000000000007E-2,0.09,0.09,0,0.06]
["kokonaispalkka ilman epäpät.alennusta",{"$f":"+Laskuri!O29+Laskuri!O30+Laskuri!O31+Laskuri!O32+Laskuri!O33+Laskuri!O34+Laskuri!O35+Laskuri!O36","v":2940.36}]
["epäpät.alennus",{"$f":"+B85*B62","v":0}]
[]
[]
[null,null,1]
[null,"kokemuslisätaulukot","alle 3 v.","3 v.","5 v.","8 v.","13 v.","15 v.","20 v."]
[null,"Lukio- ja perusopetus",0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,"Aikuislukio ja lukion aikuislinja",0,0.06,0.06,7.0000000000000007E-2,0.08,0,0.06]
[null,"Kansanopistot",0,0.05,0.06,7.0000000000000007E-2,7.0000000000000007E-2,0,0.06]
[null,"Kansalais- ja työväen opistot",0,0.05,0.06,7.0000000000000007E-2,7.0000000000000007E-2,0,0.06]
[null,"Musiikkioppilaitokset",0,0.05,0.06,7.0000000000000007E-2,0.08,0,0.03]
[null,"Kuvataidekoulu sekä monitaiteellinen koulu",0,0.05,0.05,0.05,0.08,0,0.03]
[null,"Eräät ammatilliset oppilaitokset",0,0.05,0.05,0.09,0.05,0.06,0.06]
[null,"Kauppaoppilaitokset",0,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,0.08,0,0.06]
[null,"Sosiaali- ja terveysalan oppilaitos",0,0.05,0.06,0.06,0.05,0,0.04]
[null,"Metsä- ja puutalousoppilaitos",0,0.05,7.0000000000000007E-2,0.09,0.09,0,0.06]
[]
[]
[null,"kokemuslisäkertoimet","alle 3 v.","3 v.","5 v.","8 v.","13 v.","15 v.","20 v.","opolisä haetaan tästä"]
[null,"Lukio- ja perusopetus",0,{"$f":"+D91","v":0.06},{"$f":"+(E91+1)*(D104+1)-1","v":0.12360000000000015},0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0.03]
[null,"Aikuislukio ja lukion aikuislinja",0,0.06,0.12360000000000015,0.20225200000000032,0.29843216000000039,0.29843216000000039,0.37633808960000059,0.03]
[null,"Kansanopistot",0,0.05,0.11300000000000021,0.19091000000000036,0.2742737000000004,0.2742737000000004,0.35073012200000053,0.03]
[null,"Kansalais- ja työväen opistot",0,0.05,0.11300000000000021,0.19091000000000036,0.2742737000000004,0.2742737000000004,0.35073012200000053,0.03]
[null,"Musiikkioppilaitokset",0,0.05,0.11300000000000021,0.19091000000000036,0.2861828000000004,0.2861828000000004,0.32476828400000035,0.03]
[null,"Kuvataidekoulu sekä monitaiteellinen koulu",0,0.05,0.10250000000000004,0.15762500000000013,0.25023500000000021,0.25023500000000021,0.2877420500000003,0.03]
[null,"Eräät ammatilliset oppilaitokset",0,0.05,0.10250000000000004,0.20172500000000015,0.26181125000000027,0.33751992500000028,0.41777112050000031,0.03]
[null,"Kauppaoppilaitokset",0,7.0000000000000007E-2,0.14490000000000003,0.2250430000000001,0.32304644000000016,0.32304644000000016,0.40242922640000023,0.03]
[null,"Sosiaali- ja terveysalan oppilaitos",0,0.05,0.11300000000000021,0.17978000000000027,0.23876900000000023,0.23876900000000023,0.28831976000000026,0.04]
[null,"Metsä- ja puutalousoppilaitos",0,0.05,0.12350000000000017,0.22461500000000023,0.33483035000000028,0.33483035000000028,0.41492017100000034,0.03]
[]
[]
["eräiden erkan yt kerroin veivaus"]
[]
[null,{"$f":"B24*1","v":1}]
[null,{"$f":"IF(B118=7,1,0)","v":0}]
[null,{"$f":"IF(B125=TRUE,1,0)","v":0}]
[null,{"$f":"+B120+B119","v":0}]
[null,{"$f":"IF(B121=2,0.95,B45)","v":0.82099999999999995}]
[]
["tämä on erityisopettaja täpän merkki (eri siis kuin erkkalisä)"]
[null,false]

{"sheet":"Käyttöohje","index":2,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
["Käyttöohje palkkalaskurille",null,null,null,null,null,null,null,null,null,"Sivistystyönantajat",null,"02/2016"]
[]
["Laskuri on ohjelmoitu VB (Visual Basic) -ohjelmointikielellä. Tarvitset sen käyttämiseen Microsoft Excel-ohjelman. "]
["Ohjelmassa täytyy olla asetettu makrojen käyttö sallituksi. Tarvittaessa sen saa asetettua valitsemalla Työkalut -> Makro -> Suojaus -> Normaali."]
[]
["Laskurissa pääset muuttamaan vihreällä pohjalla olevia kenttiä, oranssit sekä siniset kentät päivittyvät automaattisesti, eikä niihin tule koskea."]
[]
["Näin toimit (käy jokainen kohta läpi):"]
["1. Valitse alasvetovalikoista oppilaitosryhmä"]
["2. Valitse alasvetovalikoista tilastokoodi ja laita laatikkoon täppä, mikäli kyseessä on erityisopettaja "]
["    (HUOM! Ei erillisiä tilastokoodeja esim. eräiden ammatillisten oppilaitosten tai kauppaoppilaitosten erityisopettajille, vaan valintalaatikko)"]
["3. Valitse paikkakuntakalleusluokka"]
["4. Valitse kokemuslisien määrä (vuosia)"]
["5. Tarkista oikean palstan yläosasta, että valitut arvot ovat oikein"]
["6. Syötä tarvittaessa peruspalkka (mikäli suurempi kuin alarajan palkka) ja paina Enter"]
["7. Syötä tarvittaessa tehtäväkohtainen lisä, prosentuaalinen lisä (prosentteina!), muut mahdolliset lisät sekä epäpätevyysalennus (prosentteina!)"]
[]
["HUOM! Laskuri laskee suoraviivaisesti työehtosopimuksen vähimmäismääräysten mukaisen palkan."]
[]
["HUOM! Laskuria ei voi käyttää minkään oppilaitosryhmän rehtoreiden tai tuntiopettajien palkkojen laskentaan, "]
["eikä lainkaan kokonaistyöajassa olevien kansanopistojen tai ammattikorkeakoulujen palkkojen laskentaan!"]
[]
["HUOM! Mikäli käytät desimaalierotinta, käytä sitä, joka omassa Excel-ohjelmassasi on asetettu "]
["desimaalierottimeksi (pilkku tai piste)."]
[]
["Mikäli ohjelma ilmoittaa virheestä, kannattaa koko Excel sulkea ja avata laskuri uudelleen. Ole tarkka desimaalierottimen kanssa!"]
[]
["Laskuri löytyy alapalkista viereiseltä välilehdeltä."]

{"sheet":"Laskuri","index":3,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,12,5,18],[24,10,26,18]],"read":"row_number_cap"}
[null,"Opettajien palkkalaskuri 1.2.2016 alkaen",null,null,null,null,"Sivistystyönantajat",null,"02/2016"]
[]
[null,null,null,null,null,null,null,null,null,null,"Oppilaitosryhmä",{"$f":"+Taul2!B29","v":"Lukio- ja perusopetus"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Taul2!B34,Taul2!G5:M84,7,FALSE)","v":"Lehtori ja opinto-ohjaaja (lukio), ylempi korkeakoulututkinto ja lukio-opetusta antavan opettajan kelpoisuus taikka aiempi vanhemman lehtorin kelpoisuus (51)"}]
[null,null,null,null,null,null,null,null,null,null,"Tilastokoodi ja nimike",{"$f":"+Taul2!B33","v":"012151"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Taul2!H4:I4,Taul2!B36)","v":"I-paikkakuntakalleusluokka"}]
[]
[null,null,null,null,null,null,null,null,null,null,"Kokemuslisävuodet",{"$f":"INDEX(Taul2!C90:I90,Taul2!C89)","v":"alle 3 v."}]
[]
[]
[]
[null,null,null,null,null,null,"3 v. (5 v.)",{"$f":"VLOOKUP(Taul2!$B$34,Taul2!$G$5:$AA$84,15+2,FALSE)","v":0.06},null,null,{"$f":"+Taul2!B39","v":2940.36}]
[null,null,null,null,null,null,"5 v. (7 v.)",{"$f":"VLOOKUP(Taul2!$B$34,Taul2!$G$5:$AA$84,15+1,FALSE)","v":0.06}]
[null,null,null,null,null,null,"8 v. (10 v.)",{"$f":"VLOOKUP(Taul2!$B$34,Taul2!$G$5:$AA$84,15+3,FALSE)","v":7.0000000000000007E-2},null,null,"Syötä peruspalkka, mikäli alarajaa suurempi"]
[null,null,null,null,null,null,"13 v. (15 v.)",{"$f":"VLOOKUP(Taul2!$B$34,Taul2!$G$5:$AA$84,15+4,FALSE)","v":0.08},null,null,"Syötä ainoastaan ns. palkka-asteikon tapauksessa (esim. tilastokoodi 015156). "]
[null,null,null,null,null,null,"15 v.*",{"$f":"VLOOKUP(Taul2!$B$34,Taul2!$G$5:$AA$84,15+5,FALSE)","v":0},null,null,"Älä syötä asteikon ylärajaa suurempaa palkkaa (ylittävät osat käsitellään esimerkiksi henkilökohtaisena lisänä tms). "]
[null,null,null,null,null,null,"20 v.",{"$f":"VLOOKUP(Taul2!$B$34,Taul2!$G$5:$AA$84,15+6,FALSE)","v":0.06}]
[null,null,null,null,null,null,"* vain Eräät ammatilliset "]
[null,null,null,null,null,null,"oppilatokset",null,null,null,"Muut mahdolliset lisät (euroina)",null,null,null,0]
[null,null,null,null,null,null,"Suluissa Steiner-koulujen ",null,null,null,"Mahdollinen epäpätevyysalennus",null,null,0,{"$f":"+Taul2!B63","v":0}]
[null,null,null,null,null,null,"kokemuslisäportaat",null,null,null,"Ylituntien lukumäärä",null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Opetusvelvollisuus",null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,"Ylituntia vastaava kuukausipalkkio",null,null,null,{"$f":"+Taul2!B46","v":137.94488914285714}]
[null,null,null,null,null,null,null,null,null,null,"Yksittäiseltä ylitunnilta maksettavan palkkion saat kertomalla yllä olevan kuukausipalkkion luvulla 12 ja jakamalla saadun tulon oppilaitoksen työviikkojen lukumäärällä. Musiikkioppilaitoksissa jakajana on kuitenkin luku 35, peruskoulun opetuksen ohjauksessa luku 30 ja aikuislukioissa luku 33."]
[null," * vain Eräät ammattilliset oppilaitokset"]
[]
[]
[null,null,null,null,"Lisän määrä",null,null,null,null,null,"Peruspalkka (epäpätevyysalennuksella vähennettynä)",null,null,null,{"$f":"(MAX(K13,N15))*(1-N21)","v":2940.36}]
[null,null,null,null,{"$f":"IF(Taul2!B68=TRUE,Taul2!C68,Taul2!A72)","v":0},null,null,null,null,null,"Erityisopettajalisä",null,null,null,{"$f":"+(O29)*E30","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Luki- ja klinikkaopettajan lisä",null,null,null,{"$f":"(O29)*E32","v":0}]
[null,null,null,null,{"$f":"IF(Taul2!B69=TRUE,Taul2!C69,)","v":0},null,null,null,null,null,"Oppilaanohjaajan lisä",null,null,null,{"$f":"+(O29)*E34","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Viittomakielen lisä",null,null,null,{"$f":"+(O29)*E36","v":0}]
[null,null,null,null,{"$f":"IF(Taul2!B70=TRUE,Taul2!C70,)","v":0},null,null,null,null,null,"Kokemuslisät",null,null,null,{"$f":"+Taul2!B58","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Muut lisät",null,null,null,{"$f":"+O20","v":0}]
[null,null,null,null,{"$f":"IF(Taul2!B71=TRUE,Taul2!C71,)","v":0},null,null,null,null,null,"Ylituntipalkkiot",null,null,null,{"$f":"+O22*O24","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Yhteensä",null,null,null,{"$f":"SUM(O29:O36)","v":2940.36}]