{"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":339,"n_cols":9,"rows_kept":339,"cut":false,"hidden":true,"merged":[[301,3,301,5],[301,6,301,8],[185,3,185,5],[185,6,185,8],[193,3,193,5],[193,6,193,8],[201,3,201,5],[201,6,201,8],[279,3,279,5],[279,6,279,8],[313,3,313,5],[313,6,313,8],[325,3,325,5],[325,6,325,8],[319,3,319,5],[319,6,319,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],[155,3,155,5],[155,6,155,8],[221,3,221,5],[221,6,221,8],[268,3,268,5],[268,6,268,8],[176,3,176,5],[176,6,176,8],[160,3,160,5],[160,6,160,8],[168,3,168,5],[168,6,168,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],[127,3,127,5],[127,6,127,8],[131,3,131,5],[131,6,131,8],[135,3,135,5],[135,6,135,8],[0,0,0,1],[5,3,5,5],[5,6,5,8],[46,3,46,5],[46,6,46,8]]}
["SIVISTYSTYÖNANTAJAT ry"]
["Opetushenkilöstön palkat  (muut kuin AMK)"]
[null,null,null,"1.5.2018 lukien"]
[]
["LUKIO-OPETUS JA PERUSOPETUS"]
["Tilastokoodi",null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["011064","Peruskoulun rehtori (64 - 68)",null,3779.88,"-",4499.99,3675.79,"-",4376.03]
["011065","Lukion rehtori (65 - 70)",null,3940.06,"-",4941.76,3831.58,"-",4805.8]
[]
[null,null,null,"I kalleusluokka ",null,"II kalleusluokka "]
["011261","Johtaja (61)",null,3293.51,null,3202.96]
["011259","Johtaja (59)",null,3077.24,null,2992.86]
["011154","Apulaisjohtaja (54)",null,2530.0100000000002,null,2460.54]
[]
["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,2975.64,null,2893.6]
["012150","b. Perusopetusta antavan opettajan tai aiempi lukio-opetusta \nantavan opettajan kelpoisuus (50)",null,2860.96,null,2782.51]
["012145","c. Ylempi tai alempi korkeakoulututkinto (45)",null,2450.8200000000002,null,2391.98]
["012139","d. Muu kuin edellä mainittu (39) ",null,2082.21,null,2035.16]
["                                                       "]
["2. Lehtori (peruskoulu)"]
["012249","a. Ylempi korkeakoulututkinto ja perus-/lukio-opetusta antavan\n opettajan kelpoisuus tai aiempi vanhemman lehtorin kelpoisuus (49)",null,2769.43,null,2695.21]
["012248","b. Perusopetusta antavan opettajan tai aiempi peruskoulun/lukion opettajan kelpoisuus (48)",null,2654.76,null,2585.9499999999998]
["012244","c. Ylempi korkeakoulututkinto (44)",null,2325.11,null,2269.98]
["012242","d. Alempi korkeakoulututkinto (42)",null,2217.31,null,2164.83]
["012239","e. Muu kuin edellä mainittu (39)",null,2082.21,null,2035.16]
[]
["3. Erityisopettaja ja erityisluokanopettaja"]
["012349","a. Ylempi korkeakoulututkinto ja erityisopetusta antavan opettajan kelpoisuus (49)",null,2769.43,null,2695.21]
["012348","b. Alempi korkeakoulututkinto ja erityisopetusta antavan opettajan kelpoisuus (48)",null,2654.76,null,2585.9499999999998]
["012347","c. Erityisopetusta antavan opettajan kelpoisuus taikka ylempi korkeakoulututkinto\n ja perus-/lukio-opetusta antavan opettajan kelpoisuus (47)",null,2594.2399999999998,null,2529.21]
["012346","d. Perus-/lukio-opetusta antavan opettajan kelpoisuus (46)",null,2503.83,null,2442.1999999999998]
["012341","e. Muu kuin edellä mainittu (41)",null,2174.9,null,2123.71]
[]
["f. Muita määräyksiä"]
["012341","Jos vaikeimmin kehitysvammaisten opettajalla on soveltuva\n  vähintään opistoasteinen tutkinto (41), on hänen peruspalkkansa",null,2174.9,null,2123.71]
["012344","ja jos hänellä on lisäksi 35 opintoviikon erityisopinnot (44), ",null,2325.11,null,2269.98]
[]
["4. Luokanopettaja"]
["012449","a. Ylempi korkeakoulututkinto, aineen opettajan kelpoisuus  sekä perus-/lukio-opetusta antavan opettajan kelpoisuus (49)",null,2769.43,null,2695.21]
["012448","b. Aineenopettajan kelpoisuus ja perus/lukio-opetusta antavan opettajan kelpoisuus (48), ",null,2654.76,null,2585.9499999999998]
["012446","c. Perus/lukio-opetusta antavan opettajan kelpoisuus (46), ",null,2503.83,null,2442.1999999999998]
["012435","d. Muu kuin edellä mainittu (35)",null,1943.12,null,1899.89]
[]
[]
["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,2887.94," -",3138.79,2808.78," -",3052.71]
["015159","- määrävuosilisään oikeuttavaa aikaa vähintään 15 vuotta (59 - 63)",null,3138.79," -",3632,3052.71," -",3532.04]
[null,"Perus-/lukio-opetusta antavan opettajan kelpoisuus"]
["015155","- määrävuosilisään oikeuttavaa aikaa alle 15 vuotta (55 - 58)",null,2822.67," -",3047.6,2745.11," -",2963.59]
["015158","- määrävuosilisään oikeuttavaa aikaa vähintään 15 vuotta (58 - 61)",null,3047.6," -",3359.37,2963.59," -",3267]
[null,"Muu kuin edellä mainittu"]
["015143","- määrävuosilisään oikeuttavaa aikaa alle 15 vuotta (43 - 50)",null,1976.18," -",2321.39,1931.1," -",2257.69]
["015146","- määrävuosilisään oikeuttavaa aikaa vähintään 15 vuotta (46 - 53)",null,2103.4899999999998," -",2512.52,2051.69," -",2443.5500000000002]
[]
[]
["AIKUISLUKIO JA LUKION AIKUISLINJA"]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["011065","Aikuislukion ja lukion aikuislinjan rehtori (65 - 70)",null,3940.06," -",4941.76,3831.58," -",4805.8]
[]
["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,2975.64,null,2893.6]
["012150","b. Perusopetusta antavan opettajan tai aiempi lukio-opetusta antavan opettajan kelpoisuus (50)",null,2860.96,null,2782.51]
["012145","c. Ylempi tai alempi korkeakoulututkinto (45)",null,2450.8200000000002,null,2391.98]
["012139","d. Muu kuin edellä mainittu (39)",null,2082.21,null,2035.16]
[]
["                                                       "]
["VAPAAN SIVISTYSTYÖN OPPILAITOKSET"]
[]
["KANSANOPISTOT"]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["021060","Kansanopiston rehtori (60 - 63)",null,3368.77," -",3763.52,3275.73," -",3659.9]
[null,null,null,"I kalleusluokka ",null,"II kalleusluokka "]
["022650","1) ylempi korkeakoulututkinto (50)",null,2558.59,null,2488.44]
["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,2214.02,null,2160.89]
[]
["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,3242.12," -",3622.02,3152.59," -",3522.31]
["021061","Rehtorille, jolla on ylempi korkeakoulututkinto tai jolla on rehtori- tai johtajapalvelua vähintään 5 vuotta ",null,3350.15," -",3779.88,3258.03," -",3675.79]
["021159","Kokonaispalkkauksessa oleva apulaisrehtori (59 - 60)",null,3210.24," -",3308.52,3122.21," -",3217.15]
[null,null,null,"I kalleusluokka ",null,"II kalleusluokka "]
["022650","1) ylempi korkeakoulututkinto (50)",null,2558.59,null,2488.44]
["022645","2) toimeen soveltuva alempi korkeakoulututkinto, ammattikorkeakoulututkinto tai opistoasteen tutkinto tai erivapauden nojalla opettajan toimeen kelpoisuuden saanut (45)",null,2214.02,null,2160.89]
[]
["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.88,null,30.27,27.24,null,29.55]
[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.47,null,28.44,25.84,null,27.77]
[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.67,null,27.4,25.1,null,26.73]
[]
["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.4,null,29.63,26.73,null,28.94]
[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,26.08,null,27.88,25.47,null,27.24]
[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.38,null,26.93,24.81,null,26.28]
[]
["URHEILUOPISTOT"]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
[null,null,null,3955.01," -",4517.05,3846.11," -",4392.6099999999997]
[null,null,null,3431.46," -",3884.27,3337.27," -",3777.31]
[]
[]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
[null,null,null,3365.21," -",3696.1,3272.21," -",3594.54]
[null,null,null,3566.22," -",3916.99,3467.63," -",3809.33]
[null,null,null,3743.5," -",4111.8100000000004,3639.99," -",3998.78]
[null,null,null,3929.67," -",4316.3900000000003,3820.98," -",4197.7]
[null,null,null,4164.21," -",4574.1499999999996,4049," -",4448.33]
[null,null,null,4371.01," -",4801.3900000000003,4250.0600000000004," -",4669.3100000000004]
[]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
[null,null,null,3211.7," -",3466.05,3124.05," -",3371.07]
[null,null,null,3403.49," -",3673.12,3310.57," -",3572.43]
[null,null,null,3572.64," -",3855.76,3475.08," -",3750.04]
[null,null,null,3750.25," -",4047.52,3647.82," -",3936.53]
[null,null,null,3974.04," -",4289.16,3865.46," -",4171.49]
[null,null,null,4171.3500000000004," -",4502.18,4057.34," -",4378.6400000000003]
[]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
[null,null,null,2715.59," -",2938.03,2641.29," -",2857.94]
[null,null,null,2877.56," -",3113.36,2798.8," -",3028.47]
[null,null,null,3020.43," -",3268.02,2937.7," -",3178.86]
[null,null,null,3170.41," -",3430.4,3083.58," -",3336.8]
[null,null,null,3359.43," -",3634.99,3267.37," -",3535.78]
[null,null,null,3526.05," -",3815.37,3429.4," -",3711.21]
[]
[]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
[null,null,null,3466.05," -",3755.05,3371.07," -",3652.37]
[null,null,null,3673.12," -",3979.49,3572.43," -",3870.64]
[null,null,null,3855.76," -",4177.42,3750.04," -",4063.15]
[null,null,null,4047.52," -",4385.29,3936.53," -",4265.29]
[null,null,null,4289.16," -",4647.17,4171.49," -",4519.9799999999996]
[null,null,null,4502.18," -",4878.07,4378.6400000000003," -",4744.5200000000004]
[]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
[null,null,null,3285.51," -",3569.13,3196.01," -",3471.81]
[null,null,null,3481.74," -",3782.39,3386.84," -",3679.23]
[null,null,null,3654.8," -",3970.5,3555.17," -",3862.17]
[null,null,null,3836.52," -",4168,3731.9," -",4054.25]
[null,null,null,4065.49," -",4416.8500000000004,3954.59," -",4296.28]
[null,null,null,4267.3500000000004," -",4636.26,4150.92," -",4509.66]
[]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
[null,null,null,2783.87," -",3211.7,2707.74," -",3124.05]
[null,null,null,2949.95," -",3403.49,2869.24," -",3310.57]
[null,null,null,3096.44," -",3572.64,3011.67," -",3475.08]
[null,null,null,3250.23," -",3750.25,3161.24," -",3647.82]
[null,null,null,3444.02," -",3974.04,3349.69," -",3865.46]
[null,null,null,3614.86," -",4171.3500000000004,3515.83," -",4057.34]
[]
[null,null,null,"I kalleusluokka ",null,"II kalleusluokka "]
[null,null,null,28.76,null,28.08]
[null,null,null,27.22,null,26.58]
[null,null,null,26.36,null,25.76]
[]
[null,null,null,"I kalleusluokka ",null,"II kalleusluokka "]
[null,null,null,29.97,null,29.26]
[null,null,null,28.2,null,27.55]
[null,null,null,27.22,null,26.58]
[]
["MUSIIKKIOPPILAITOKSET"]
[]
["Rehtori",null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["041061","- ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (61 - 66) ",null,3586.66," -",4394.66,3488.04," -",4273.33]
["041060","- muu tutkinto (60 - 65) ",null,3471.02," -",4218.25,3375.15," -",4102.1000000000004]
[]
["Apulaisrehtori "]
["041159","- ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (59 - 63)",null,3291.22," -",3808.4,3200.97," -",3703.55]
["041158","- muu tutkinto (58 - 62)",null,3195.61," -",3659.86,3107.54," -",3559.41]
[]
["1. Konservatorio"]
["043152","a. Yliopettaja (52 - 54)",null,2757.34," -",2941.6,2681.33," -",2860.83]
["043249","b. Lehtori - ylempi KK tai ylempi AMK-tutkinto (49 - 51)",null,2542.6799999999998," -",2694.32,2474.52," -",2620.0100000000002]
["043248","c. Lehtori (48 - 50)",null,2366.6799999999998," -",2601.25,2305.31," -",2556.58]
[null,"d. Yleisaineiden opettajat "]
["043346"," - ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (46 - 48)",null,2257.7800000000002," -",2366.6799999999998,2202.19," -",2305.31]
["043341","- alempi korkeakoulututkinto (41 - 43)",null,2045.3," -",2121.14,1998.87," -",2072.73]
[]
["2. Musiikin perusopetus "]
["043449","a. Ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (49 - 51)",null,2542.6799999999998," -",2694.32,2474.52," -",2620.0100000000002]
["043448","b. Soveltuva ammattikorkea-",null,2366.6799999999998," -",2601.25,2305.31," -",2529.94]
["043444","c. Muu soveltuva tutkinto (44 - 46)",null,2163.63," -",2257.7800000000002,2112.66," -",2202.19]
[]
["PÄÄTOIMISET TUNTIOPETTAJAT"]
[]
["042543","a. Ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (43 - 45)",null,2152.17," -",2242.2800000000002,2103.04," -",2188.4899999999998]
["042542","b. Soveltuva ammattikorkeakoulututkinto, konservatorion jatkotutkinto tai entinen lehtorin kelpoisuus (42 - 44)",null,2112.35," -",2195.2600000000002,2064.12," -",2143.5700000000002]
["042539","c. Muu soveltuva tutkinto (39 - 41)",null,2007.74," -",2075.21,1962.48," -",2028.11]
[null,"d. Yleisaineet "]
["042543","- ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (43 - 45)",null,2152.17," -",2242.2800000000002,2103.04," -",2188.4899999999998]
["042538","- korkeakoulututkinto (38 - 40)",null,1979.03," -",2040.79,1934.63," -",1994.38]
[]
["SIVUTOIMISET TUNTIOPETTAJAT "]
[]
[null,null,null,"per tunti",null,"kk:ssa"]
[null,"Ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (42)",null,28.2,null,82.3]
[null,"Soveltuva ammattikorkeakoulututkinto, konservatorion jatkotutkinto tai entinen lehtorin kelpoisuus (41)",null,27.71,null,80.8]
[null,"Muu soveltuva tutkinto (38)",null,24.18,null,70.540000000000006]
["Yleisaineet "]
[null,"ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (42)"]
[null,"- opv 20 t/vko - kielet, matematiikka",null,31.06,null,90.51]
[null,"- opv 25 t/vko - liikunta",null,24.84,null,72.41]
[null,"- opv 21 t/vko - muut aineet",null,29.57,null,86.2]
[null,"korkeakoulututkinto (37)"]
[null,"- opv 20 t/vko - kielet, matematiikka",null,28.59,null,83.41]
[null,"- opv 25 t/vko - liikunta",null,22.88,null,66.72]
[null,"- opv 21 t/vko - muut aineet",null,27.23,null,79.42]
[]
["KUVATAIDEKOULU SEKÄ MONITAITEELLINEN KOULU"]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["051054","Rehtori (54 - 60)",null,2689.36," -",3388.1,2615.5300000000002," -",3294.51]
["053442","1. Opettaja (42 - 48)",null,2074.09," -",2358.83,2026.69," -",2297.71]
["053444","2. perusopetuksen, kuvataiteen tai musiikin opettajan kelpoisuus, musiikkioppilaitoksen opettajan kelpoisuus tai asetuksen 948/1998 mukainen pedagoginen kelpoisuus",null,2156.4899999999998," -",2483.38,2105.36," -",2415.31]
[]
["Tuntipalkkiot"]
[null,"7 § 1. Tuntipalkkiot",null,24.87," -",30.07]
[null,"7 § 2. Vähintään 16 viikkotuntia opettavan tuntipalkkio",null,26.42," -",31.86]
[]
[]
["ERÄÄT AMMATILLISET OPPILAITOKSET"]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["061062","Rehtori (62 - 65)",null,3515.55," -",3979.48,3419.08," -",3869.91]
["061160","Apulaisrehtori (60 - 64)",null,3215.98," -",3749.41,3127.16," -",3646.16]
["061359","Aikuiskoulutusjohtaja (59 - 63)",null,3104.94," -",3592.81,3019.8," -",3493.91]
[]
["1. Lehtori (ammatilliset aineet)",null,null,"I kalleusluokka ",null,"II kalleusluokka "]
["063551","ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (51)",null,2890.87,null,2811.14]
["063549","insinööri, rakennusarkkitehti, alempi korkeakoulututkinto, ammattikorkeakoulututkinto (49)",null,2672,null,2600.38]
["063544","ammatinopettajantutkinto  tai vastaava (44)",null,2256.8000000000002,null,2203.2800000000002]
["063545","opetusministeriön määräämät lisäopinnot suorittanut teknikko tai vastaava (45)",null,2378.89,null,2321.77]
["063541","alansa korkein muu koulutus (41)",null,2107.09,null,2057.5]
["063539","teknikon tutkinto tai vast. (39) ",null,2022.89,null,1977.15]
["     "]
["2. Lehtori (yhteiset aineet)"]
["063747","ylempi korkeakoulututkinto tai ylempi AMK-tutkinto(47)",null,2520.35,null,2457.15]
["063744","muu tutkinto (44)",null,2256.8000000000002,null,2203.2800000000002]
["3. Lehtori (liikunta ja terveystieto)"]
["063747","ylempi korkeakoulututkinto tai ylempi AMK-tutkinto (47) ",null,2520.35,null,2457.15]
["063744","muu tutkinto (44) ",null,2256.8000000000002,null,2203.2800000000002]
[]
[]
["KAUPPAOPPILAITOKSET"]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["071062","Rehtori (62 - 68)",null,3515.55," -",4544.99,3419.08," -",4419.79]
["071161","Apulaisrehtori (61 - 65)",null,3329.02," -",3915.24,3237.49," -",3807.43]
["071359","Aikuiskoulutusjohtaja (59 - 64)",null,3110.43," -",3756.06,3025.13," -",3652.61]
[]
[null,null,null,"I kalleusluokka ",null,"II kalleusluokka "]
["073551","Lehtori ylempi korkeakoulututkinto tai ylempi AMK-tutkinto(51)",null,2612.67,null,2540.63]
["073547","Lehtori, alempi korkeakoulututkinto tai amk-tutkinto (47)",null,2284.44,null,2227.17]
["073544","Lehtori,  muu tutkinto (44) ",null,2139.04,null,2088.27]
[]
[" "]
["SOSIAALI- JA TERVEYSALAN OPPILAITOS "]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["081061","Rehtori (61 - 65)",null,3383.64," -",3979.48,3290.6," -",3869.91]
["081159","Apulaisrehtori ja ",null,3135.96," -",3592.81,3049.97," -",3493.91]
["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,3089.23," -",3387.78,3004.57," -",3294.86]
["083554","2. Muu tutkinto (54 - 57)",null,2901.12," -",3161.52,2821.47," -",3073.64]
[]
[]
["METSÄ- JA PUUTALOUSOPPILAITOS"]
[null,null,null,"I kalleusluokka ",null,null,"II kalleusluokka "]
["091062","Rehtori (62 - 65)",null,3570.51," -",4041.66,3472.49," -",3930.38]
["091161","Apulaisrehtori (61 - 63)",null,3375.05," -",3648.98,3282.28," -",3548.51]
["091359","Aikuiskoulutusjohtaja (59 - 60)",null,3153.43," -",3266.23,3066.97," -",3176.02]
[]
[null,"1. Lehtori (ammatilliset aineet)",null,"I kalleusluokka ",null,"II kalleusluokka "]
["093555","- ylempi korkeakoulututkinto (55)",null,3111.94,null,3026.45]
["093552","- soveltuva ammattikorkea- koulututkinto tai insinööri (52)",null,2784.56,null,2707.85]
["093550","- metsätalousinsinööri, puutalousinsinööri tai vastaava aikaisempi tutkinto (50)",null,2621.98,null,2550.09]
["093549","- teknikko tai opistoasteen tutkinto (49)",null,2562.91,null,2494.2399999999998]
["093547","- metsätalous-, sahateollisuus- tai levyteollisuusteknikko (47)",null,2417.63,null,2357.02]
["093545","- metsätyönopettajan koulutus (45) ",null,2225.44,null,2172.0300000000002]
[null,"2. Lehtori (yhteiset aineet)"]
["093755","- ylempi korkeakoulututkinto(55)",null,3111.94,null,3026.45]

{"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,"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,null,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",2975.64,2893.6,{"$f":"MID(D5,2,6)","v":"12151"},{"$f":"+E5","v":2975.64},{"$f":"+F5","v":2893.6},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",2860.96,2782.51,"12150",2860.96,2782.51,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",2450.8200000000002,2391.98,"12145",2450.8200000000002,2391.98,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",2082.21,2035.16,"12139",2082.21,2035.16,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",2769.43,2695.21,"12249",2769.43,2695.21,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",2654.76,2585.9499999999998,"12248",2654.76,2585.9499999999998,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",2325.11,2269.98,"12244",2325.11,2269.98,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",2217.31,2164.83,"12242",2217.31,2164.83,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",2082.21,2035.16,"12239",2082.21,2035.16,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",2769.43,2695.21,"12349",2769.43,2695.21,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",2654.76,2585.9499999999998,"12348",2654.76,2585.9499999999998,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",2594.2399999999998,2529.21,"12347",2594.2399999999998,2529.21,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",2503.83,2442.1999999999998,"12346",2503.83,2442.1999999999998,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",2174.9,2123.71,"12341",2174.9,2123.71,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",2174.9,2123.71,"12341",2174.9,2123.71,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",2325.11,2269.98,"12344",2325.11,2269.98,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",2769.43,2695.21,"12449",2769.43,2695.21,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",2654.76,2585.9499999999998,"12448",2654.76,2585.9499999999998,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",2503.83,2442.1999999999998,"12446",2503.83,2442.1999999999998,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",1943.12,1899.89,"12435",1943.12,1899.89,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",2887.94,2808.78,"15156",2887.94,2808.78,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",3138.79,3052.71,"15159",3138.79,3052.71,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",2822.67,2745.11,"15155",2822.67,2745.11,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",3047.6,2963.59,"15158",3047.6,2963.59,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",1976.18,1931.1,"15143",1976.18,1931.1,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",2103.4899999999998,2051.69,"15146",2103.4899999999998,2051.69,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",2975.64,2893.6,"12151",2975.64,2893.6,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",2860.96,2782.51,"12150",2860.96,2782.51,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",2450.8200000000002,2391.98,"12145",2450.8200000000002,2391.98,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",2082.21,2035.16,"12139",2082.21,2035.16,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",2558.59,2488.44,"22650",2558.59,2488.44,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",2214.02,2160.89,"22645",2214.02,2160.89,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":2975.64},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",2558.59,2488.44,"22650",2558.59,2488.44,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",2214.02,2160.89,"22645",2214.02,2160.89,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",2757.34,2681.33,"43152",2757.34,2681.33,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",2542.6799999999998,2474.52,"43249",2542.6799999999998,2474.52,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",2366.6799999999998,2305.31,"43248",2366.6799999999998,2305.31,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":139.60002514285713},null,"043346",2257.7800000000002,2202.19,"43346",2257.7800000000002,2202.19,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",2045.3,1998.87,"43341",2045.3,1998.87,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",2542.6799999999998,2474.52,"43449",2542.6799999999998,2474.52,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",2366.6799999999998,2305.31,"43448",2366.6799999999998,2305.31,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",2163.63,2112.66,"43444",2163.63,2112.66,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",2152.17,2103.04,"42543",2152.17,2103.04,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",2112.35,2064.12,"42542",2112.35,2064.12,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",2007.74,1962.48,"42539",2007.74,1962.48,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",2152.17,2103.04,"42543",2152.17,2103.04,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",1979.03,1934.63,"42538",1979.03,1934.63,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",2074.09,2026.69,"53442",2074.09,2026.69,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",2156.4899999999998,2105.36,"53444",2156.4899999999998,2105.36,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",2890.87,2811.14,"63551",2890.87,2811.14,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",2672,2600.38,"63549",2672,2600.38,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",2256.8000000000002,2203.2800000000002,"63544",2256.8000000000002,2203.2800000000002,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",2378.89,2321.77,"63545",2378.89,2321.77,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",2107.09,2057.5,"63541",2107.09,2057.5,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",2022.89,1977.15,"63539",2022.89,1977.15,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",2520.35,2457.15,"63747",2520.35,2457.15,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",2256.8000000000002,2203.2800000000002,"63744",2256.8000000000002,2203.2800000000002,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",2520.35,2457.15,"63747",2520.35,2457.15,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",2256.8000000000002,2203.2800000000002,"63744",2256.8000000000002,2203.2800000000002,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",2612.67,2540.63,"73551",2612.67,2540.63,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",2284.44,2227.17,"73547",2284.44,2227.17,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",2139.04,2088.27,"73544",2139.04,2088.27,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",3089.23,3004.57,"83556",3089.23,3004.57,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",2901.12,2821.47,"83554",2901.12,2821.47,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",3111.94,3026.45,"93555",3111.94,3026.45,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",2784.56,2707.85,"93552",2784.56,2707.85,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",2621.98,2550.09,"93550",2621.98,2550.09,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",2562.91,2494.2399999999998,"93549",2562.91,2494.2399999999998,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",2417.63,2357.02,"93547",2417.63,2357.02,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",2225.44,2172.0300000000002,"93545",2225.44,2172.0300000000002,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",3111.94,3026.45,"93755",3111.94,3026.45,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":2975.64}]
["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,"05/2018"]
[]
["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.5.2018 alkaen",null,null,null,null,"Sivistystyönantajat",null,"05/2018"]
[]
[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+1,FALSE)","v":0.06},null,null,{"$f":"+Taul2!B39","v":2975.64}]
[null,null,null,null,null,null,"5 v. (7 v.)",{"$f":"VLOOKUP(Taul2!$B$34,Taul2!$G$5:$AA$84,15+2,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":139.60002514285713}]
[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":2975.64}]
[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":2975.64}]