{"text_format":"2","workbook":"xls","n_sheets":7,"sheets":["spesa dett MIS-PROGR","SINTESI SPESA MIS-PROGR","7.B - Riep.Num.Personale","calcolo diff. CCNL ","DIFF CCNL DETTAGLIO","CAT.PROT.","PERS.CONV.DISTACCO"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":12,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"spesa dett MIS-PROGR","index":0,"n_rows":581,"n_cols":18,"rows_kept":581,"cut":false,"hidden":true,"merged":[[397,1,397,8],[398,1,398,5],[398,6,398,8],[399,0,399,14],[401,0,401,14],[391,0,391,14],[392,0,392,17],[393,0,393,17],[394,1,394,5],[394,6,394,8],[385,0,385,17],[386,1,386,5],[386,6,386,8],[387,1,387,8],[389,1,389,8],[390,1,390,5],[390,6,390,8],[317,0,317,17],[318,1,318,2],[318,15,318,17],[378,10,380,10],[381,15,381,17],[371,0,371,14],[373,0,373,17],[374,0,374,17],[375,0,375,17],[376,1,376,2],[309,1,309,8],[310,1,310,5],[310,6,310,8],[376,15,376,17],[367,1,367,8],[368,1,368,5],[368,6,368,8],[313,0,313,14],[315,0,315,17],[316,0,316,17],[303,0,303,14],[304,0,304,17],[305,0,305,17],[306,1,306,5],[306,6,306,8],[307,1,307,8],[287,1,287,2],[287,15,287,17],[295,15,295,17],[297,0,297,17],[298,1,298,5],[298,6,298,8],[279,6,279,8],[280,0,280,14],[282,0,282,14],[284,0,284,17],[285,0,285,17],[286,0,286,17],[241,0,241,17],[242,1,242,5],[242,6,242,8],[243,1,243,8],[245,1,245,8],[246,1,246,5],[246,6,246,8],[187,0,187,14],[189,0,189,14],[191,0,191,17],[192,0,192,17],[193,0,193,17],[194,1,194,2],[194,15,194,17],[181,0,181,17],[182,1,182,5],[182,6,182,8],[183,1,183,8],[185,1,185,8],[186,1,186,5],[186,6,186,8],[173,0,173,17],[174,1,174,5],[174,6,174,8],[196,10,198,10],[175,1,175,8],[177,1,177,8],[178,1,178,5],[178,6,178,8],[179,0,179,14],[180,0,180,17],[163,0,163,17],[164,0,164,17],[165,1,165,2],[165,15,165,17],[171,1,171,2],[171,15,171,17],[167,10,169,10],[156,1,156,8],[157,1,157,5],[157,6,157,8],[158,0,158,14],[160,0,160,14],[162,0,162,17],[150,0,150,14],[151,0,151,17],[152,0,152,17],[153,1,153,5],[153,6,153,8],[154,1,154,8],[144,0,144,17],[145,1,145,5],[145,6,145,8],[146,1,146,8],[148,1,148,8],[149,1,149,5],[149,6,149,8],[132,0,132,17],[133,0,133,17],[134,1,134,2],[134,15,134,17],[136,10,138,10],[199,15,199,17],[139,15,139,17],[140,15,140,17],[141,15,141,17],[142,15,142,17],[125,1,125,8],[126,1,126,5],[126,6,126,8],[127,0,127,14],[129,0,129,14],[131,0,131,17],[119,0,119,14],[120,0,120,17],[121,0,121,17],[122,1,122,5],[122,6,122,8],[123,1,123,8],[113,0,113,17],[114,1,114,5],[114,6,114,8],[115,1,115,8],[117,1,117,8],[118,1,118,5],[118,6,118,8],[105,10,107,10],[201,15,201,17],[202,1,202,2],[202,15,202,17],[108,15,108,17],[109,15,109,17],[110,15,110,17],[111,1,111,2],[111,15,111,17],[200,15,200,17],[95,0,95,14],[100,0,100,17],[101,0,101,17],[102,0,102,17],[103,1,103,2],[103,15,103,17],[89,0,89,17],[90,1,90,5],[90,6,90,8],[91,1,91,8],[93,1,93,8],[94,1,94,5],[94,6,94,8],[83,1,83,8],[85,1,85,8],[86,1,86,5],[86,6,86,8],[87,0,87,14],[88,0,88,17],[78,15,78,17],[79,1,79,2],[79,15,79,17],[81,0,81,17],[82,1,82,5],[82,6,82,8],[68,0,68,17],[69,0,69,17],[70,1,70,2],[70,15,70,17],[72,10,74,10],[204,0,204,17],[170,15,170,17],[75,15,75,17],[76,15,76,17],[77,15,77,17],[542,1,542,5],[542,6,542,8],[572,0,572,17],[539,0,539,14],[543,1,543,8],[545,1,545,8],[546,1,546,5],[546,6,546,8],[547,0,547,14],[549,0,549,14],[253,0,253,17],[254,1,254,2],[254,15,254,17],[538,6,538,8],[540,0,540,17],[541,0,541,17],[275,6,275,8],[276,1,276,8],[278,1,278,8],[279,1,279,5],[535,1,535,8],[537,1,537,8],[538,1,538,5],[31,6,31,8],[22,1,22,8],[32,0,32,14],[347,1,347,2],[264,1,264,2],[330,1,330,8],[331,1,331,5],[580,0,580,14],[256,10,258,10],[259,15,259,17],[260,15,260,17],[261,15,261,17],[262,15,262,17],[263,15,263,17],[344,0,344,17],[345,0,345,17],[346,0,346,17],[205,1,205,5],[205,6,205,8],[206,1,206,8],[347,15,347,17],[311,0,311,14],[289,10,291,10],[292,15,292,17],[293,15,293,17],[249,0,249,14],[251,0,251,17],[352,15,352,17],[353,1,353,2],[264,15,264,17],[266,0,266,17],[267,1,267,5],[267,6,267,8],[268,1,268,8],[324,1,324,2],[283,0,283,14],[327,1,327,5],[324,15,324,17],[326,0,326,17],[320,10,322,10],[323,15,323,17],[295,1,295,2],[328,1,328,8],[299,1,299,8],[301,1,301,8],[302,1,302,5],[302,6,302,8],[331,6,331,8],[349,10,351,10],[16,1,16,2],[49,1,49,2],[142,1,142,2],[209,6,209,8],[210,0,210,14],[338,1,338,8],[339,1,339,5],[213,1,213,5],[527,10,529,10],[530,15,530,17],[531,1,531,2],[531,15,531,17],[533,0,533,17],[534,1,534,5],[534,6,534,8],[357,1,357,8],[359,1,359,8],[360,1,360,5],[360,6,360,8],[524,0,524,17],[525,1,525,2],[525,15,525,17],[382,15,382,17],[383,1,383,2],[383,15,383,17],[522,0,522,17],[523,0,523,17],[25,0,25,17],[26,0,26,17],[27,1,27,5],[27,6,27,8],[46,15,46,17],[332,0,332,14],[49,15,49,17],[212,0,212,17],[314,19,314,33],[216,1,216,8],[217,1,217,5],[217,6,217,8],[218,0,218,14],[335,1,335,5],[335,6,335,8],[333,0,333,17],[334,0,334,17],[327,6,327,8],[214,1,214,8],[314,0,314,14],[211,0,211,17],[209,1,209,5],[208,1,208,8],[235,1,235,8],[220,0,220,14],[234,6,234,8],[227,10,229,10],[252,0,252,17],[222,0,222,17],[223,0,223,17],[224,0,224,17],[225,1,225,2],[225,15,225,17],[44,15,44,17],[48,15,48,17],[51,0,51,17],[52,1,52,5],[213,6,213,8],[230,15,230,17],[343,0,343,14],[45,15,45,17],[6,1,6,2],[24,0,24,14],[19,6,19,8],[23,6,23,8],[23,1,23,5],[237,1,237,8],[238,1,238,5],[520,0,520,14],[369,0,369,14],[231,1,231,2],[231,15,231,17],[233,0,233,17],[234,1,234,5],[339,6,339,8],[340,0,340,14],[342,0,342,14],[353,15,353,17],[514,1,514,8],[516,1,516,8],[517,1,517,5],[491,0,491,14],[517,6,517,8],[518,0,518,14],[510,0,510,14],[511,0,511,17],[512,0,512,17],[509,1,509,5],[513,1,513,5],[513,6,513,8],[361,0,361,14],[362,0,362,17],[364,1,364,5],[408,10,410,10],[411,15,411,17],[506,1,506,8],[508,1,508,8],[395,1,395,8],[239,0,239,14],[336,1,336,8],[504,0,504,17],[505,1,505,5],[505,6,505,8],[356,6,356,8],[412,1,412,2],[412,15,412,17],[414,0,414,17],[472,15,472,17],[509,6,509,8],[274,0,274,17],[275,1,275,5],[240,0,240,17],[270,1,270,8],[271,1,271,5],[363,0,363,17],[294,15,294,17],[355,0,355,17],[356,1,356,5],[18,0,18,17],[16,15,16,17],[364,6,364,8],[365,1,365,8],[20,1,20,8],[19,1,19,5],[28,1,28,8],[30,1,30,8],[31,1,31,5],[247,0,247,14],[3,0,3,17],[4,0,4,17],[12,15,12,17],[13,15,13,17],[14,15,14,17],[15,15,15,17],[5,0,5,17],[6,15,6,17],[11,15,11,17],[8,10,10,10],[34,0,34,14],[36,0,36,17],[37,0,37,17],[38,0,38,17],[39,15,39,17],[47,15,47,17],[39,1,39,2],[41,10,43,10],[52,6,52,8],[53,1,53,8],[55,1,55,8],[56,1,56,5],[56,6,56,8],[57,0,57,14],[58,0,58,17],[65,0,65,14],[97,0,97,14],[59,0,59,17],[60,1,60,5],[60,6,60,8],[61,1,61,8],[63,1,63,8],[64,1,64,5],[64,6,64,8],[67,0,67,17],[403,0,403,17],[404,0,404,17],[405,0,405,17],[406,1,406,2],[406,15,406,17],[271,6,271,8],[272,0,272,14],[273,0,273,17],[238,6,238,8],[415,1,415,5],[415,6,415,8],[502,1,502,2],[502,15,502,17],[416,1,416,8],[418,1,418,8],[419,1,419,5],[419,6,419,8],[420,0,420,14],[421,0,421,17],[422,0,422,17],[423,1,423,5],[423,6,423,8],[424,1,424,8],[426,1,426,8],[427,1,427,5],[427,6,427,8],[501,15,501,17],[428,0,428,14],[430,0,430,14],[432,0,432,17],[433,0,433,17],[434,0,434,17],[435,1,435,2],[435,15,435,17],[453,0,453,17],[437,10,439,10],[446,0,446,17],[447,1,447,5],[447,6,447,8],[498,10,500,10],[455,6,455,8],[456,1,456,8],[458,1,458,8],[459,1,459,5],[459,6,459,8],[448,1,448,8],[450,1,450,8],[451,1,451,5],[451,6,451,8],[452,0,452,14],[460,0,460,14],[462,0,462,14],[454,0,454,17],[455,1,455,5],[440,15,440,17],[441,15,441,17],[442,15,442,17],[443,15,443,17],[444,1,444,2],[444,15,444,17],[464,0,464,17],[465,0,465,17],[466,0,466,17],[467,1,467,2],[467,15,467,17],[469,10,471,10],[473,1,473,2],[473,15,473,17],[475,0,475,17],[476,1,476,5],[476,6,476,8],[477,1,477,8],[479,1,479,8],[480,1,480,5],[480,6,480,8],[481,0,481,14],[482,0,482,17],[483,0,483,17],[484,1,484,5],[484,6,484,8],[485,1,485,8],[487,1,487,8],[488,1,488,5],[488,6,488,8],[489,0,489,14],[493,0,493,17],[494,0,494,17],[495,0,495,17],[496,1,496,2],[496,15,496,17],[551,0,551,17],[552,0,552,17],[553,0,553,17],[578,0,578,14],[566,1,566,8],[568,1,568,8],[569,1,569,5],[569,6,569,8],[570,0,570,14],[571,0,571,17],[562,15,562,17],[573,6,573,8],[574,1,574,8],[576,1,576,8],[554,1,554,2],[554,15,554,17],[556,10,558,10],[577,1,577,5],[577,6,577,8],[564,0,564,17],[565,1,565,5],[565,6,565,8],[559,15,559,17],[560,15,560,17],[561,15,561,17],[573,1,573,5],[562,1,562,2]],"flags":["formulas_cached_only"]}
["PIANO TRIENNALE DEL FABBISOGNO DEL PERSONALE 2019-2021"]
["Composizione e spesa inerente"]
["."]
["SERVIZIO:   SEGRETERIA - ORGANIZZAZIONE (Area I)"]
["Missione 1 - Programma 2"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"Dir.","Segretario Generale",1,null,null,"    1 (*)","(*)","(*)",{"$nulls":6}," (*) in convenzione con Comune di San Pellegrino Terme"]
[1,"D3","Responsabile Area I",1,null,null,1]
[1,"D2","Istrutt.Direttivo",1,null,null,null,1,"24 h"]
[1,"B7","Collab.prof.amm.vo",1,null,null,1]
[1,"B5","Collab.prof.amm.vo",1,null,null,null,1,"22 h"]
[5,"Totali ",null,5,0,null,3,2,null,0,0,null,0,0]
["."]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 01.02.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},196400,196400,196400]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},50350,50350,50350]
["A","Totale",{"$nulls":13},246750,246750,246750]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 01.02.01.102",{"$nulls":8},16390,16390,16390]
["   TOTALE retribuzioni",{"$nulls":14},263140,263140,263140]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 01.02.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio ",{"$nulls":13},3747.68,3300,3300]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},940,820,820]
["A","Totale",{"$nulls":13},4687.68,4120,4120]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 01.02.01.102",{"$nulls":8},340,300,300]
["   TOTALE salario accessorio",{"$nulls":14},5027.68,4420,4420]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},268167.68,267560,267560]
[]
["SERVIZIO:   GESTIONE ECONOMICO - FINANZIARIA (Area II)"]
["Missione 1 - Programma 3"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"D4","Responsabile Area II",1,null,5,1,{"$nulls":8},"prevista mobilità in uscita previo congruo affiancamento "]
[1,"D3","Funzionario contabile",null,1,10,1]
[2,"C5","Istruttore contabile",2,null,null,1,"1*","25 h",{"$nulls":6},"*: parziale aspettativa nell'anno"]
[1,"C2","Istruttore contabile",1,null,null,1]
[1,"B6","Collab.prof.amm.vo",1,null,null,1]
[6,"Totali ",null,5,1,null,5,1,null,0,0,null,0,0]
[]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 01.03.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},140500,136600,136600]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},38900,37700,37700]
["A","Totale",{"$nulls":13},179400,174300,174300]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 01.03.01.102",{"$nulls":8},12100,11700,11700]
["   TOTALE retribuzioni",{"$nulls":14},191500,186000,186000]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 01.03.01.102",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 01.03.01.102"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["SERVIZIO:   GESTIONE TRIBUTI E SERV. TARIFFARI (Area II)"]
["Missione 1 - Programma 4"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"D1","Istrutt.Direttivo",1,null,null,1]
[1,"C4","Istr. amm.vo    ",1,null,null,1]
[1,"C3","Istr. amm.vo    ",1,null,null,1]
[1,"B7","Collab.prof.amm.vo",1,null,null,null,1,"22 h"]
[4,"Totali ",null,4,0,null,3,1,null,0,0,null,0,0]
[]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 01.04.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},86600,86600,86600]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},24700,24700,24700]
["A","Totale",{"$nulls":13},111300,111300,111300]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 01.04.01.102",{"$nulls":8},7500,7500,7500]
["   TOTALE retribuzioni",{"$nulls":14},118800,118800,118800]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 01.04.01.102",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 01.04.01.102"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},191500,186000,186000]
[]
[]
["SERVIZIO:  UFFICIO TECNICO (Area III LL.PP.-patrimonio)"]
["Missione 1 - Programma 6"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"D3","Funzionario - Responsabile di Area III-IV",1,null,null,1]
[1,"C2","Istr. tecnico",1,null,null,1]
[1,"B7","Collab.prof.amm.vo",1,null,null,1]
[3,"Totali ",null,3,0,null,3,0,null,0,0,null,0,0]
[]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 01.06.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},74800,74800,74800]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},21200,21200,21200]
["A","Totale",{"$nulls":13},96000,96000,96000]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 01.06.01.102",{"$nulls":8},6500,6500,6500]
["   TOTALE retribuzioni",{"$nulls":14},102500,102500,102500]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 01.06.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 01.06.01.102"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},191500,186000,186000]
[]
["SERVIZIO:  UFFICIO TECNICO (AREA IV - Urbanistica, edilizia privata ed ambiente)"]
["Missione 1 - Programma 6"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"D5","Resp. Area III e IV",1,null,null,1]
[1,"B7","Collab.prof.amm.vo",1,null,null,1]
[1,"C5","Istr. tecnico",1,null,null,1]
[3,"Totali ",null,3,0,null,3,0,null,0,0,null,0,0]
[]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 01.06.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},96500,96500,96500]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},26600,26600,26600]
["A","Totale",{"$nulls":13},123100,123100,123100]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 01.06.01.102",{"$nulls":8},8300,8300,8300]
["   TOTALE retribuzioni",{"$nulls":14},131400,131400,131400]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 01.06.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 01.06.01.101"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},191500,186000,186000]
[]
["SERVIZIO PATRIMONIO (Area III-IV)"]
["Missione 1 - Programma 5"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"B1","Esecutore operaio",1,null,null,null,1,"25h"]
[1,"Totali ",null,1,0,null,0,1,null,0,0,null,0,0]
[]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 01.05.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},13500,13500,13500]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},4400,4400,4400]
["A","Totale",{"$nulls":13},17900,17900,17900]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 01.05.01.102",{"$nulls":8},1300,1300,1300]
["   TOTALE retribuzioni",{"$nulls":14},19200,19200,19200]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 01.05.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 01.05.01.101"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},191500,186000,186000]
[]
["SERVIZIO: SERVIZI DEMOGRAFICI - ELETTORALI (Area I)"]
["Missione 1 - Programma 7"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[2,"C5","Istrutt. amm.vo",2,null,null,2]
[1,"B5","Collab.prof.amm.vo",1,null,null,null,1,"30h"]
[1,"B3","Collab.prof.amm.vo",1,null,null,null,1,"19h",{"$nulls":6},"(cat.protetta)"]
[4,"Totali ",null,4,0,null,2,2,null,0,0,null,0,0]
[]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 01.07.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},81200,81200,81200]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},22700,22700,22700]
["A","Totale",{"$nulls":13},103900,103900,103900]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 01.07.01.102",{"$nulls":8},7000,7000,7000]
["   TOTALE retribuzioni",{"$nulls":14},110900,110900,110900]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 01.02.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 01.02.01.102"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},191500,186000,186000]
[]
["ALTRI SERVIZI GENERALI (Area II)"]
["Missione 1 - Programma 11"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"B4","Esecutore operativo",1,null,null,null,1,"15h"]
[1,"Totali ",null,1,0,null,0,1,null,0,0,null,0,0]
[]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 01.11.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},9000,9000,9000]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},2500,2500,2500]
["A","Totale",{"$nulls":13},11500,11500,11500]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 01.11.01.102",{"$nulls":8},800,800,800]
["   TOTALE retribuzioni",{"$nulls":14},12300,12300,12300]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 01.11.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 01.11.01.102"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},191500,186000,186000]
[]
["SERVIZIO:  POLIZIA LOCALE (Area VII)"]
["Missione 3 - Programma 1"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"D4","Com.PL-resp.Area VII",1,null,null,1]
[1,"C4","Agente P.L.",1,null,null,1]
[2,"C3","Agente P.L.",2,null,null,2]
[1,"C4","Agente PL-Messo not.",1,null,null,1]
[2,"C1","Agente P.L.",2,null,null,2]
[7,"Totali ",null,7,0,null,7,0,null,0,0,null,0,0]
["."]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 03.01.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},194400,194400,194400]
["A2","   Oneri riflessi ed Inail c.to Ente - Previdenza complementare:",{"$nulls":13},65900,65900,65900]
["A","Totale",{"$nulls":13},260300,260300,260300]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 03.01.01.102",{"$nulls":8},17000,17000,17000]
["   TOTALE retribuzioni",{"$nulls":14},277300,277300,277300]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 03.01.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 03.01.01.102"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},277300,277300,277300]
[]
["SERVIZIO:  MENSA SCOLASTICA (Area II)"]
["Missione 4 - Programma 6"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"A5","Operat.aiuto.cuoca",1,null,null,1]
[2,"A5","Oper.Ausiliarie pulizie",2,null,null,null,2,"25 h"]
[1,"A5","Oper.Ausiliarie pulizie",1,null,null,null,1,"27 h"]
[4,"Totali ",null,4,0,null,1,3,null,0,0,null,0,0]
[]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 04.06.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},64000,64000,64000]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},18500,18500,18500]
["A","Totale",{"$nulls":13},82500,82500,82500]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 04.06.01.102",{"$nulls":8},5500,5500,5500]
["   TOTALE retribuzioni",{"$nulls":14},88000,88000,88000]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 04.06.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 04.06.01.102"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},277300,277300,277300]
[]
["SERVIZIO:  BIBLIOTECA - SERVIZI CULTURALI (Area I)"]
["Missione 5 - Programma 2"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"B7","Collab.assist.culturale",1,null,null,1]
[1,"Totali ",null,1,0,null,1,0,null,0,0,null,0,0]
[]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 05.02.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},23200,23200,23200]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},6500,6500,6500]
["A","Totale",{"$nulls":13},29700,29700,29700]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 05.02.01.102",{"$nulls":8},2000,2000,2000]
["   TOTALE retribuzioni",{"$nulls":14},31700,31700,31700]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 05.02.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 05.02.01.102"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},277300,277300,277300]
[]
["SERVIZIO: NETTEZZA URBANA (Area III-IV)"]
["Missione 9 - Programma 3"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"B2","Esecutore operaio",1,null,null,1]
[1,"Totali ",null,1,0,null,1,0,null,0,0,null,0,0]
[]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 09.03.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},21000,21000,21000]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},6700,6700,6700]
["A","Totale",{"$nulls":13},27700,27700,27700]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 09.03.01.102",{"$nulls":8},1800,1800,1800]
["   TOTALE retribuzioni",{"$nulls":14},29500,29500,29500]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 09.03.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 09.03.01.102"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},277300,277300,277300]
[]
["SERVIZIO:  VIABILITA' (Area III-IV)"]
["Missione 10 - Programma 5"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"B4","Capo operaio",1,null,null,1]
[1,"B4","Esecutore operaio",1,null,null,1,null,"18 h",{"$nulls":6},"(destinato per restante 50% al servizio cimiteriale)"]
[2,"Totali ",null,2,0,null,2,0,null,0,0,null,0,0]
[]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 10.05.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},32100,32100,32100]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},10000,10000,10000]
["A","Totale",{"$nulls":13},42100,42100,42100]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 10.05.01.102",{"$nulls":8},2800,2800,2800]
["   TOTALE retribuzioni",{"$nulls":14},44900,44900,44900]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 10.05.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 10.05.01.102"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},0,0,0]
[]
["SERVIZIO: SERVIZI SOCIALI - MINORI (servizio d'ambito) (Area V)"]
["Missione 12 - Programma 1"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"D2","Assistente sociale",1,null,null,1,{"$nulls":8},"in distacco presso l’Agenzia Minori dell’Ambito territoriale di Dalmine"]
[1,"Totali ",null,1,0,null,1,0,null,0,0,null,0,0]
[]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 12.01.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},25000,25000,25000]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},7700,7700,7700]
["A","Totale",{"$nulls":13},32700,32700,32700]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 12.01.01.102",{"$nulls":8},2300,2300,2300]
["   TOTALE retribuzioni",{"$nulls":14},35000,35000,35000]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 12.01.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 12.01.01.102"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},0,0,0]
[]
["SERVIZIO: SERVIZI SOCIALI (in ambito comunale) (Area V)"]
["Missione 12 - Programma 7"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"D2","Ass. soc.-Resp.Area V",1,null,null,1]
[1,"C1","Istruttore amm.vo",1,null,null,null,1,"18 h"]
[1,"C2","Istruttore amm.vo",1,null,null,1]
[1,"A5","Ausiliario",1,null,null,null,1,"34h",{"$nulls":6},"(cat. protette)"]
[4,"Totali ",null,4,0,null,3,2,null,0,0,null,0,0]
[]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 12.07.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},89500,89500,89500]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},25900,25900,25900]
["A","Totale",{"$nulls":13},115400,115400,115400]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 12.07.01.102",{"$nulls":8},7800,7800,7800]
["   TOTALE retribuzioni",{"$nulls":14},123200,123200,123200]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 12.07.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 12.07.01.102"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},0,0,0]
[]
["SERVIZIO: SERVIZI SOCIALI (SAD) (Area V)"]
["Missione 12 - Programma 3"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"A4","Assistente domiciliare",1,null,null,null,1,"27h"]
[1,"Totali ",null,1,0,null,0,1,null,0,0,null,0,0]
[]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 12.03.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},15100,15100,15100]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},4200,4200,4200]
["A","Totale",{"$nulls":13},19300,19300,19300]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 12.03.01.102",{"$nulls":8},1300,1300,1300]
["   TOTALE retribuzioni",{"$nulls":14},20600,20600,20600]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 12.03.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 12.03.01.102"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},123200,123200,123200]
[]
["SERVIZIO:  SERVIZI CIMITERIALI (Area III-IV)"]
["Missione 12 - Programma 9"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"B3","Esecutore Operaio",1,null,null,1,null,"18 h",{"$nulls":6},"(destinato per restante 50% al servizio viabilità)"]
[1,"Totali ",null,1,0,null,1,0,null,0,0,null,0,0]
[]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 12.09.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},10800,10800,10800]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},3200,3200,3200]
["A","Totale",{"$nulls":13},14000,14000,14000]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 12.09.01.102",{"$nulls":8},1000,1000,1000]
["   TOTALE retribuzioni",{"$nulls":14},15000,15000,15000]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 12.09.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 12.09.01.102"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},20600,20600,20600]
[]
["SERVIZIO:  SERVIZIO COMMERCIO  (Area I)"]
["Missione 14 - Programma 2"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"C3","Istruttore amm.vo",1,null,null,1]
[1,"Totali ",null,1,0,null,1,0,null,0,0,null,0,0]
[]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 14.02.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},23900,23900,23900]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},6700,6700,6700]
["A","Totale",{"$nulls":13},30600,30600,30600]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 14.02.01.102",{"$nulls":8},2100,2100,2100]
["   TOTALE retribuzioni",{"$nulls":14},32700,32700,32700]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 14.02.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 14.02.01.102"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},15000,15000,15000]
[]
["SERVIZIO:  FARMACIA COMUNALE (Area VI)"]
["Missione 14 - Programma 4"]
["composizione"]
["N.","figure",null,"tipo di rapporto ",{"$nulls":11},"note"]
[null,"Cat.","profilo","Ruolo",{"$nulls":5},"a tempo determinato"]
[null,null,null,"In","Vacante",null,"Orario",null,null,"In","Vacante","Periodo","Orario"]
[null,null,null,"servizio","N.","mesi","T.pieno","P.Time",null,"serv",null,"(mesi)","Tempo","P.Time"]
[{"$nulls":5},"copertura","N.","N.","h/sett",null,null,"di","pieno","N.","ore"]
[1,"D3","Dir.farm. - Resp.Area VI",1,null,null,1]
[1,"D3","Collab. dir. farmacia",1,null,null,1]
[2,"A5","Commesso",2,null,null,1,1,"18 h"]
[4,"Totali ",null,4,0,null,4,1,null,0,0,null,0,0]
[]
["Retribuzioni [1]"]
["A","Retribuzioni e oorr c.to Ente",{"$nulls":4},"mptm 14.04.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili retribuzioni e competenze (incluso ANF)",{"$nulls":13},100300,100300,100300]
["A2","   Oneri riflessi ed Inail c.to Ente:",{"$nulls":13},29400,29400,29400]
["A","Totale",{"$nulls":13},129700,129700,129700]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 14.04.01.102",{"$nulls":8},8800,8800,8800]
["   TOTALE retribuzioni",{"$nulls":14},138500,138500,138500]
["[1] da ccnl 2016-2018, esclusa IVC, elem. perequativo ed incrementi da rinnovi contrattuali di cui ad accantonamento ad hoc (Mptm 20.3.1.10)"]
["Salario accessorio (istituti CCDI)"]
["A","Valori imponibili e oorr c.to Ente",{"$nulls":4},"mptm 14.04.01.101",{"$nulls":8},2019,2020,2021]
["A1","Valori imponibili istituti salario accessorio "]
["A2","   Oneri riflessi ed Inail c.to Ente:"]
["A","Totale",{"$nulls":13},0,0,0]
["B","IRAP c.to Ente",{"$nulls":4},"mptm 14.04.01.102"]
["   TOTALE salario accessorio",{"$nulls":14},0,0,0]
[]
["   TOTALE SPESA del SERVIZIO",{"$nulls":14},32700,32700,32700]

{"sheet":"SINTESI SPESA MIS-PROGR","index":1,"n_rows":119,"n_cols":22,"rows_kept":119,"cut":false,"hidden":true,"merged":[[0,0,0,19],[16,0,16,1],[23,3,23,4],[23,0,23,1],[24,1,24,2],[2,3,2,7],[2,9,2,13],[2,15,2,19],[23,9,23,10],[23,15,23,16],[5,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[17,0,20,1],[26,9,26,10],[26,15,26,16],[31,9,31,10],[32,9,32,10],[34,9,34,10],[21,0,22,1],[26,0,26,4],[31,1,31,4],[32,1,32,4],[34,1,34,4],[36,1,36,4],[35,0,36,0],[29,1,29,4],[33,1,33,4],[35,19,36,19],[35,1,35,4],[28,0,29,0],[28,1,28,4],[35,13,36,13],[31,15,31,16],[35,11,36,11],[35,12,36,12],[28,19,29,19],[38,9,39,10],[38,13,39,13],[38,15,39,16],[32,15,32,16],[34,15,34,16],[35,15,36,16],[35,6,36,6],[28,9,29,10],[35,17,36,17],[35,18,36,18],[28,17,29,18],[38,0,39,0],[38,1,38,4],[38,7,39,7],[28,13,29,13],[28,15,29,16],[41,17,42,18],[28,7,29,7],[35,5,36,5],[41,0,42,0],[41,1,41,4],[41,7,42,7],[33,9,33,10],[42,1,42,4],[41,5,42,6],[35,9,36,10],[46,15,46,16],[41,9,42,10],[41,13,42,13],[46,5,46,6],[38,19,39,19],[39,1,39,4],[39,5,39,6],[39,11,39,12],[39,17,39,18],[41,19,42,19],[41,15,42,16],[49,0,50,0],[49,1,49,4],[49,7,50,7],[49,9,50,10],[49,15,50,16],[41,11,42,12],[47,1,47,4],[47,9,47,10],[46,1,46,4],[49,19,50,19],[44,11,44,12],[44,17,44,18],[52,0,53,0],[52,1,52,4],[52,5,53,6],[52,7,53,7],[52,9,53,10],[48,1,48,4],[46,17,46,18],[50,1,50,4],[4,0,4,1],[2,0,2,2],[44,0,44,4],[44,9,44,10],[44,15,44,16],[44,5,44,6],[33,15,33,16],[28,5,29,6],[28,11,29,12],[47,5,47,6],[48,5,48,6],[49,5,50,6],[46,11,46,12],[47,11,47,12],[48,11,48,12],[48,9,48,10],[46,9,46,10],[52,17,53,18],[48,15,48,16],[52,19,53,19],[35,7,36,7],[47,17,47,18],[48,17,48,18],[49,11,50,12],[49,17,50,18],[49,13,50,13],[47,15,47,16],[53,1,53,4],[55,1,55,4],[55,5,55,6],[55,9,55,10],[55,11,55,12],[55,15,55,16],[52,11,53,12],[52,13,53,13],[52,15,53,16],[55,17,55,18],[56,1,56,4],[56,5,56,6],[56,9,56,10],[56,11,56,12],[56,15,56,16],[56,17,56,18],[57,15,58,16],[57,17,58,18],[57,19,58,19],[58,1,58,4],[63,7,64,7],[57,0,58,0],[57,1,57,4],[57,5,58,6],[57,7,58,7],[57,9,58,10],[63,2,64,6],[63,9,64,12],[70,0,71,0],[70,1,70,4],[70,5,71,6],[57,13,58,13],[57,11,58,12],[70,7,71,7],[70,9,71,10],[70,11,71,12],[63,15,64,18],[76,15,77,16],[76,19,77,19],[77,1,77,4],[76,5,77,5],[76,6,77,6],[76,11,77,11],[63,13,64,13],[63,19,64,19],[63,0,64,1],[70,13,71,13],[70,15,71,16],[70,17,71,18],[70,19,71,19],[71,1,71,4],[66,0,66,4],[66,5,66,6],[66,9,66,10],[66,11,66,12],[66,15,66,16],[66,17,66,18],[68,1,68,4],[68,5,68,6],[68,9,68,10],[68,11,68,12],[68,15,68,16],[68,17,68,18],[69,1,69,4],[69,5,69,6],[69,9,69,10],[69,11,69,12],[69,15,69,16],[69,17,69,18],[73,0,74,0],[73,1,73,4],[73,7,74,7],[73,9,74,10],[73,13,74,13],[73,15,74,16],[73,19,74,19],[74,1,74,4],[74,5,74,6],[74,11,74,12],[74,17,74,18],[76,0,77,0],[76,1,76,4],[76,7,77,7],[76,9,77,10],[76,13,77,13],[80,17,80,18],[76,12,77,12],[76,17,77,17],[76,18,77,18],[79,1,79,4],[79,5,79,6],[79,9,79,10],[79,11,79,12],[79,15,79,16],[79,17,79,18],[81,11,82,12],[80,1,80,4],[80,5,80,6],[80,9,80,10],[80,11,80,12],[80,15,80,16],[81,19,82,19],[82,1,82,4],[84,1,84,4],[84,9,84,10],[84,15,84,16],[81,0,82,0],[81,1,81,4],[81,5,82,6],[81,7,82,7],[81,9,82,10],[91,0,92,0],[91,1,91,4],[91,7,92,7],[90,11,90,12],[91,11,92,12],[91,13,92,13],[86,0,87,0],[86,1,86,4],[86,7,87,7],[86,9,87,10],[60,19,61,19],[89,1,89,4],[89,9,89,10],[89,15,89,16],[85,1,85,4],[85,9,85,10],[60,0,61,0],[60,1,61,6],[86,15,87,16],[86,19,87,19],[87,1,87,4],[86,5,87,5],[86,6,87,6],[86,11,87,11],[86,12,87,12],[86,17,87,17],[60,7,61,7],[60,9,61,12],[60,13,61,13],[60,15,61,18],[86,18,87,18],[81,13,82,13],[81,15,82,16],[81,17,82,18],[85,15,85,16],[86,13,87,13],[91,19,92,19],[92,1,92,4],[89,5,89,6],[90,5,90,6],[91,5,92,6],[89,11,89,12],[90,1,90,4],[90,9,90,10],[90,15,90,16],[91,15,92,16],[106,7,107,7],[106,9,107,12],[89,17,89,18],[91,9,92,10],[90,17,90,18],[91,17,92,18],[94,7,95,7],[94,9,95,12],[94,13,95,13],[94,15,95,18],[112,2,113,6],[112,7,113,7],[94,19,95,19],[94,2,95,6],[94,0,95,1],[115,15,116,18],[115,19,116,19],[101,0,101,19],[106,0,107,1],[106,2,107,6],[98,0,100,19],[106,15,107,18],[109,0,110,1],[109,2,110,6],[115,0,116,1],[115,2,116,6],[115,7,116,7],[115,9,116,12],[115,13,116,13],[106,13,107,13],[109,13,110,13],[109,15,110,18],[112,19,113,19],[106,19,107,19],[104,0,104,1],[104,10,104,12],[104,16,104,18],[109,19,110,19],[109,7,110,7],[109,9,110,12],[112,0,113,1],[118,19,119,19],[118,2,119,6],[118,7,119,7],[118,9,119,12],[118,13,119,13],[118,15,119,18],[112,9,113,12],[112,13,113,13],[112,15,113,18]],"flags":["formulas_cached_only"]}
["SINTESI SPESA PERSONALE DIPENDENTE PROGRAMMA FABBISOGNO TRIENNIO 2019-2020 per COMPOSIZIONE, MISSIONI e PROGRAMMI"]
[]
["esercizio",null,null,2019,{"$nulls":5},2020,{"$nulls":5},2021]
[]
["Missione",null,"Programma","retrIbuzioni e oorr (val.vigenti)","irap su retribuzioni","salario acc., oo rr e Inail","irap su sal. acc","TOTALE",null,"retrIbuzioni e oorr (val.vigenti)","irap su retribuzioni","salario acc., oo rr e Inail","irap su sal. acc","TOTALE",null,"retrIbuzioni e oorr (val.vigenti)","irap su retribuzioni","salario acc., oo rr e Inail","irap su sal. acc","TOTALE"]
[1,null,2,246750,16390,4687.68,340,268167.68,null,246750,16390,4120,300,267560,null,246750,16390,4120,300,267560]
[null,null,3,179400,12100,0,0,191500,null,1422000,95500,112610,7820,1637930,null,1422000,95500,112610,7820,1637930,null,120884.92]
[null,null,4,111300,7500,116197.23999999999,8200,243197.24,{"$nulls":5},0,{"$nulls":5},0,null,8540]
[null,null,5,17900,76300,null,null,94200,{"$nulls":5},0,{"$nulls":5},0,null,116730]
[null,null,6,219100,null,null,null,219100,{"$nulls":5},0,{"$nulls":5},0,null,8120]
[null,null,7,103900,null,null,null,103900,{"$nulls":5},0,{"$nulls":5},0]
[null,null,11,11500,null,null,null,11500,{"$nulls":5},0,{"$nulls":5},0]
[3,null,1,260300,null,null,null,260300,{"$nulls":5},0,{"$nulls":5},0]
[4,null,6,82500,null,null,null,82500,{"$nulls":5},0,{"$nulls":5},0]
[5,null,2,29700,null,null,null,29700,{"$nulls":5},0,{"$nulls":5},0]
[9,null,3,27700,null,null,null,27700,{"$nulls":5},0,{"$nulls":5},0]
[10,null,5,42100,null,null,null,42100,{"$nulls":5},0,{"$nulls":5},0]
[12,null,1,32700,null,null,null,32700,{"$nulls":5},0,{"$nulls":5},0]
[null,null,3,19300,null,null,null,19300,{"$nulls":5},0,{"$nulls":5},0]
[null,null,7,115400,null,null,null,115400,{"$nulls":5},0,{"$nulls":5},0]
[null,null,9,14000,null,null,null,14000,{"$nulls":5},0,{"$nulls":5},0]
[14,null,2,30600,null,null,null,30600,{"$nulls":5},0,{"$nulls":5},0]
[null,null,4,129700,null,null,null,129700,{"$nulls":5},0,{"$nulls":5},0]
[1,null,10,"Sal.acc - Indennità dvs ",null,null,null,0,null,"Sal.acc - Indennità dvs ",null,null,null,0,null,"Sal.acc - Indennità dvs ",null,null,null,0]
["A]","TOTALE RETRIB. e SAL.ACCESSORIO",null,1673850,112290,120884.91999999998,8540,1915564.92,null,1668750,111890,116730,8120,1905490,null,1668750,111890,116730,8120,1905490]
["a sommare: ulteriori voci di spesa personale dipendente [da B ad H]"]
["oggetto",{"$nulls":4},"imponibile, oorr e Inail","Irap","TOTALE",null,"oggetto",null,"imponibile, oorr e Inail","Irap","TOTALE",null,"imponibile, oorr e Inail",null,"imponibile, oorr e Inail","Irap","TOTALE"]
[]
["B]","FONDO ACCANTONAMENTO RINNOVI CCNL 19-21",null,null,null,26500,null,26500,null,"B] FONDO RINN. CCNL",null,33500,null,33500,null,"B] FONDO RINN. CCNL",null,36500,null,36500]
[null,"(Missione - Programma 20.03)"]
[]
["C1","Lavoro straordinario personale dipendente",null,null,null,34900,2500,37400,null,"Lav. str. pers.dipendente",null,34900,2500,37400,null,"Lav. str. pers.dipendente",null,34900,2500,37400]
["C2","Lavoro straordinario PL (progetto vigilanza)",null,null,null,4460,310,4770,null,"Lav. str. PL (prog.vigil.)",null,4460,310,4770,null,"Lav. str. PL (prog.vigil.)",null,4460,310,4770]
["C3","Lavoro straordinario Elezioni amministrative",null,null,null,8400,600,9000,{"$nulls":5},0,{"$nulls":5},0]
["C4","Lavoro straordinario Elezioni europee",null,null,null,8400,600,9000,{"$nulls":5},0,{"$nulls":5},0]
["C]","TOTALE LAVORO STRAORDINARIO ",null,null,null,56160,4010,60170,null,"C] LAVORO STRAORD.",null,39360,2810,42170,null,"C] LAVORO STRAORD.",null,39360,2810,42170]
[null,"(Missioni - Programmi 1.10 - 3.1)"]
[]
["D]","RIPARTO DD di ROGITO a Segretario comunale",null,null,null,17220,1200,22620,null,"B] RIPARTO DDRR",null,17220,1200,22620,null,"B] RIPARTO DDRR",null,17220,1200,22620]
[null,"(Missioni - Programmi 1.2 - 20.03)",null,null,null,4200,{"$nulls":5},4200,{"$nulls":5},4200]
[]
["E]","LAVORO FLESSIBILE (nei limiti DL 78/2010)",null,null,null,12400,null,12400,null,"E] LAVORO FLESSIBILE",null,12400,null,12400,null,"E] LAVORO FLESSIBILE",null,12400,null,12400]
[null,"(Missioni - Programmi 1.3 - 14.4)"]
[{"$nulls":19},"segue "]
["oggetto",{"$nulls":4},"valore",null,"TOTALE",null,"oggetto",null,"valore",null,"TOTALE",null,"valore",null,"valore",null,"TOTALE"]
[]
["F1","mensa personale dipendente",null,null,null,40000,null,40000,null,"mensa",null,40000,null,40000,null,"mensa",null,40000,null,40000]
["F2","missioni personale dipendente",null,null,null,1300,null,1300,null,"missioni ",null,1300,null,1300,null,"missioni ",null,1300,null,1300]
["F3","formazione personale dipendente",null,null,null,5000,null,5000,null,"formazione",null,5000,null,5000,null,"formazione",null,5000,null,5000]
["F]","TOTALE SPESE PERSONALE MACRO 3",null,null,null,46300,null,46300,null,"F] SPESA PERSONALE M. 3",null,46300,null,46300,null,"F] SPESA PERSONALE M. 3",null,46300,null,46300]
[null,"(Missione - Programma 1.10)"]
[]
["G]","RIMBORSO A P.ADDA personale PLIS - quota Ente",null,null,null,2300,null,2300,null,"G] RIMBORSO PERS.PLIS",null,2300,null,2300,null,"G] RIMBORSO PERS.PLIS",null,2300,null,2300]
[null,"(Missione - Programma 9.5 - macro 4)"]
[]
["H1","Personale sist.interbibliotecario (q.Ente sp.fig)",null,null,null,2400,null,2400,null,"Sistema interbibliot.",null,2400,null,2400,null,"Sistema interbibliot.",null,2400,null,2400]
["H2","Personale Piano di Zona serv. sociali (q.Ente sp.fig)",null,null,null,22500,null,22500,null,"Piano di Zona",null,22500,null,22500,null,"Piano di Zona",null,22500,null,22500]
["H]","TOTALE SPESE PERSONALE SERV.SOVRACCOM.LI",null,null,null,24900,null,24900,null,"G] PERS.SERV.SOVRAC.",null,24900,null,24900,null,"G] PERS.SERV.SOVRAC.",null,24900,null,24900]
[null,"(Spesa figurativa)"]
[]
["I]","TOTALE ULTERIORI VOCI DI SPESA PERSONALE DIPENDENTE [da B ad H]",{"$nulls":5},195190,null,"[I] TOT. ULTERIORI VOCI SPESA PERSONALE",null,null,null,184190,null,"[I] TOT. ULTERIORI VOCI SPESA PERSONALE",null,null,null,187190]
[]
[]
[" [L]",null,"TOTALE SPESA LORDA PERSONALE DIPENDENTE [A - I]",{"$nulls":4},2110754.92,null,"[L] TOT. SPESA LORDA PERSONALE [A + I]",null,null,null,2089680,null,"[L] TOT. SPESA LORDA PERSONALE [A + I]",null,null,null,2092680]
[]
["a detrarre [da 1 a 6]:",{"$nulls":6},195190]
["oggetto",{"$nulls":4},"valore",null,"TOTALE",null,"oggetto",null,"valore",null,"TOTALE",null,"valore",null,"valore",null,"TOTALE"]
[]
["1.1","Incrementi CCNL 2016-2018 vs  CCNL 2008/2009",null,null,null,61420,null,61420,null,"Sistema interbibliot.",null,61330,null,61330,null,"Sistema interbibliot.",null,61330,null,61330]
["1.2","Fondo accanton. rinnovi CCNL 2019-2021",null,null,null,26500,null,26500,null,"Piano di Zona",null,33500,null,33500,null,"Piano di Zona",null,36500,null,36500]
["1]","INCREMENTI CCNL 2016-2018 e 2019-2021",null,null,null,87920,null,87920,null,"1] INCREMENTI CCNL",null,94830,null,94830,null,"1] INCREMENTI CCNL",null,97830,null,97830]
[null,"(Missione - Programma DVS)"]
[]
["2]","RIPARTO DD di ROGITO a Segretario comunale",null,null,null,17220,1200,22620,null,"2] RIPARTO DDRR",null,17220,1200,22620,null,"2] RIPARTO DDRR",null,17220,1200,22620]
[null,"(Missioni - Programmi 1.2 - 20.03)",null,null,null,4200,0,{"$nulls":4},4200,0,{"$nulls":4},4200,0]
[]
["3]","LAVORO STRAORDIN. ELEZIONI EUROPEE",null,null,null,8400,600,9000,null,"3] LAV.STR.RIMB. STATO/REG",null,0,0,0,null,"3] LAV.STR.RIMB. STATO/REG",null,0,0,0]
[null,"(Missione - Programma 1.10)"]
[]
["4.1","missioni personale dipendente",null,null,null,1300,null,1300,null,"missioni ",null,1300,null,1300,null,"missioni ",null,1300,null,1300]
["4.2","formazione personale dipendente",null,null,null,5000,null,5000,null,"formazione",null,5000,null,5000,null,"formazione",null,5000,null,5000]
["4]","SPESA PERSONALE MACRO 3",null,null,null,6300,null,6300,null,"4] SPESA PERSONALE M. 3",null,6300,null,6300,null,"4] SPESA PERSONALE M. 3",null,6300,null,6300]
[null,"(Missione - Programma 1.10)"]
[]
["5.1","personale cat. protette (cod.95)",null,null,null,14240,980,15220,null,"personale cat. protette",null,14450,990,15440,null,"personale cat. protette",null,14450,990,15440]
["5.2","personale cat. protette (cod 920)",null,null,null,25170,1680,26850,null,"personale cat. protette",null,24970,1660,26630,null,"personale cat. protette",null,24970,1660,26630]
["5]","SPESA PERSONALE CAT.PROTETTE",null,null,null,39410,2660,42070,null,"5] SPESA PERS.CAT.PROT.",null,39420,2650,42070,null,"5] SPESA PERS.CAT.PROT.",null,39420,2650,42070]
[null,"(Missioni - Programmi DVS)"]
[]
["6.1","rimborso spese pers. segreteria convenzionata ",null,null,null,39000,null,39000,null,"rimb.segreteria convenz.",null,39000,null,39000,null,"rimb.segreteria convenz.",null,39000,null,39000]
["6.2","rimborso spese personale distaccato Piano di Zona",null,null,null,37120,null,37120,null,"rimborso distacco PDZ",null,37120,null,37120,null,"rimborso distacco PDZ",null,37120,null,37120]
["6]","RIMBORSI PERSONALE IN CONVENZIONE-DISTACCO",null,null,null,76120,null,76120,null,"6] RIMB.PERSONALE CONV.DIST",null,76120,null,76120,null,"6] RIMB.PERSONALE CONV.DIST",null,76120,null,76120]
[null,"(Missioni - Programmi 1.02 - 12.01)"]
[]
["[7]",null,"TOTALE VOCI A DETRARRE [da 1 a 6]",{"$nulls":4},244030,null,"[7] TOTALE VOCI A DETRARRE",null,null,null,241940,null,"[7] TOTALE VOCI A DETRARRE",null,null,null,244940]
[]
[{"$nulls":19},"segue "]
[]
["SINTESI SPESA PERSONALE DIPENDENTE PROGRAMMA FABBISOGNO TRIENNIO 2019-2021 e VERIFICA RISPETTO OBIETTIVO di RIDUZIONE VS MEDIA TRIENNIO 2011-2013"]
[]
[]
["art. 1, commi 557-557 quater L. 296/2006 e smi"]
[]
[]
["esercizio",{"$nulls":6},2019,null,"esercizio",null,null,null,2020,null,"esercizio",null,null,null,2021]
[]
[" [L]",null,"TOTALE SPESA LORDA PERSONALE DIPENDENTE [A - I]",{"$nulls":4},2110754.92,null,"[L] TOT. SPESA LORDA PERSONALE [A + I]",null,null,null,2089680,null,"[L] TOT. SPESA LORDA PERSONALE [A + I]",null,null,null,2092680]
[]
[]
["[7]",null,"TOTALE VOCI A DETRARRE [da 1 a 6]",{"$nulls":4},244030,null,"[7] TOTALE VOCI A DETRARRE",null,null,null,241940,null,"[7] TOTALE VOCI A DETRARRE",null,null,null,244940]
[]
[]
[" [L - 7]",null,"TOTALE SPESA PERSONALE DIPENDENTE AGGREGATO art. 1 commi 557-557bis L. 296/2006  e smi",{"$nulls":4},1866724.92,null,"[L - 7] TOT. SPESA PERSONALE AGGREGATO commi 557-557bis ",null,null,null,1847740,null,"[L - 7] TOT. SPESA PERSONALE AGGREGATO commi 557-557bis ",null,null,null,1847740]
[]
[]
["PARAMETRO LIMITE",null,"TOTALE SPESA MEDIA TRIENNIO 2011-2013 PERSONALE DIPENDENTE AGGREGATO art. 1 commi 557-557bis L. 296/2006  e smi",{"$nulls":4},1960805.92,null,"TOT. SPESA MEDIA TRIENNIO 2011-2013 PERSONALE AGGREGATO commi 557-557bis ",null,null,null,1960805.92,null,"TOT. SPESA MEDIA TRIENNIO 2011-2013 PERSONALE AGGREGATO commi 557-557bis ",null,null,null,1960805.92]
[]
[]
[null,null,"RIDUZIONE SPESA PERSONALE VS PARAMETRO LIMITE                                                                    (media triennio 2011-2013)",{"$nulls":4},94081,null,"RIDUZIONE SPESA PERSONALE VS PARAMETRO LIMITE  (media triennio 2011-2013)",null,null,null,113065.91999999993,null,"RIDUZIONE SPESA PERSONALE VS PARAMETRO LIMITE  (media triennio 2011-2013)",null,null,null,113065.91999999993]

{"sheet":"7.B - Riep.Num.Personale","index":2,"n_rows":44,"n_cols":40,"rows_kept":44,"cut":false,"hidden":false,"merged":[[35,34,35,38],[36,29,36,30],[36,31,36,33],[36,34,36,38],[36,1,36,5],[36,6,36,13],[36,14,36,18],[36,19,36,22],[36,23,36,24],[36,25,36,28],[34,31,34,33],[34,34,34,38],[35,1,35,5],[35,6,35,13],[35,14,35,18],[35,19,35,22],[35,23,35,24],[35,25,35,28],[35,29,35,30],[35,31,35,33],[34,1,34,5],[34,6,34,13],[34,14,34,18],[34,19,34,24],[34,25,34,30],[4,4,4,5],[4,12,4,13],[29,29,29,30],[28,23,28,24],[29,23,29,24],[33,34,33,38],[4,8,4,9],[28,19,28,22],[29,19,29,22],[28,25,28,28],[29,25,29,28],[4,22,4,23],[29,14,29,18],[4,10,4,11],[0,38,4,39],[31,1,31,13],[33,1,33,18],[33,19,33,33],[3,4,3,5],[3,6,3,7],[3,10,3,13],[3,14,3,15],[3,18,3,19],[3,30,3,31],[1,28,1,33],[4,32,4,33],[1,26,1,27],[3,22,3,23],[1,18,1,19],[1,24,1,25],[3,20,3,21],[1,20,1,21],[2,20,2,21],[1,22,1,23],[4,36,4,37],[2,22,2,23],[14,0,15,0],[6,0,7,0],[12,0,13,0],[4,20,4,21],[0,0,5,0],[2,24,2,25],[3,24,3,25],[2,18,2,19],[20,0,22,0],[8,0,9,0],[10,0,11,0],[2,26,2,27],[4,24,4,25],[4,6,4,7],[3,16,3,17],[3,8,3,9],[4,16,4,17],[4,18,4,19],[0,2,0,37],[3,2,3,3],[4,28,4,29],[16,0,17,0],[0,1,5,1],[4,26,4,27],[1,34,1,37],[4,14,4,15],[1,2,1,17],[2,2,2,17],[3,32,3,33],[25,1,25,38],[4,30,4,31],[3,34,3,35],[4,34,4,35],[2,28,2,33],[4,2,4,3],[3,26,3,27],[2,34,2,37],[3,36,3,37],[30,34,30,38],[28,31,28,33],[29,31,29,33],[29,34,29,38],[28,29,28,30],[28,34,28,38],[27,19,27,24],[26,19,26,33],[27,34,27,38],[27,14,27,18],[27,31,27,33],[28,14,28,18],[26,34,26,38],[26,1,26,18],[27,25,27,30],[38,30,38,34],[39,30,39,34],[29,6,29,13],[29,1,29,5],[30,1,30,5],[3,28,3,29],[27,1,27,5],[27,6,27,13],[28,1,28,5],[28,6,28,13]],"flags":["formulas_cached_only"]}
["Categoria giuridica d'accesso","ruolo      tempo determinato","  UNITA' di PERSONALE per MISSIONE - PROGRAMMA di APPARTENENZA",{"$nulls":35},"TOTALE                  (dati di riferimento all'1.1.2020)"]
[null,null,"01",{"$nulls":15},"03",null,"04",null,"05",null,"09",null,"10",null,12,{"$nulls":5},"14"]
[null,null,"Servizi istituzionali, generali e di gestione",{"$nulls":15},"O.P. e sicur.",null,"Istruzione",null,"Cultura",null,"Territorio",null,"Viabilità",null,"Politiche sociali",{"$nulls":5},"Sviluppo economico"]
[null,null,"02",null,"03",null,"04",null,"05",null,"06",null,null,null,"07",null,"11",null,"01",null,"06",null,"02",null,"03",null,"05",null,"01 - 07",null,"03",null,"09",null,"02",null,"04"]
[null,null,"Segreteria",null,"Finanziario",null,"Tributi",null,"Patrimonio",null,"LL.PP.",null,"Territorio",null,"Demograf.",null,"Altri Ser. Gen",null,"PL",null,"Mensa",null,"Bibioteca",null,"R.S.U.",null,"Viabilità",null,"Soc e Min.",null,"SAD",null,"Cimitero",null,"Commercio",null,"Farmacia"]
[null,null,"ser","(vac)","ser","vac","ser","(vac)","ser","(vac)","ser","(vac)","ser","(vac)","ser","(vac)","ser","(vac)","ser","(vac)","ser","(vac)","ser","(vac)","ser","(vac)","ser","(vac)","ser","(vac)","ser","(vac)","ser","(vac)","ser","(vac)","ser","(vac)","in serv.","(vacante)"]
["A","ruolo",{"$nulls":18},4,{"$nulls":7},1,null,1,{"$nulls":5},2,null,8,0]
[null,"t.deter.",{"$nulls":36},0,0]
["B1","ruolo",{"$nulls":6},1,{"$nulls":7},1,{"$nulls":7},1,null,0.5,{"$nulls":5},0.5,{"$nulls":5},4,0]
[null,"t.deter.",{"$nulls":36},0,0]
["B3","ruolo",2,null,1,null,1,null,null,null,1,null,1,null,2,{"$nulls":7},1,null,null,null,1,{"$nulls":11},10,0]
[null,"t.deter.",{"$nulls":36},0,0]
["C","ruolo",null,null,3,null,2,{"$nulls":4},1,1,null,2,null,null,null,6,{"$nulls":4},1,{"$nulls":4},2,{"$nulls":5},1,null,null,null,17,2]
[null,"t.deter.",{"$nulls":36},0,0]
["D1","ruolo",1,null,1,null,1,{"$nulls":5},1,{"$nulls":5},1,{"$nulls":9},2,{"$nulls":9},7,0]
[null,"t.deter.",{"$nulls":36},0,0]
["D3","ruolo",1,{"$nulls":7},1,{"$nulls":7},1,{"$nulls":17},2,null,5,0]
[null,"t.deter.",{"$nulls":36},0,0]
["Dirig.","ruolo",1,{"$nulls":35},1,0]
["Segret.Gen.","t.deter.",{"$nulls":36},0,0]
["TOT.","ruolo",5,0,5,0,4,0,1,0,2,1,3,0,4,0,1,0,8,0,4,0,1,1,1,0,1.5,0,5,0,1,0,0.5,0,1,0,4,0,52,2]
[null,"t.deter.",0,0,0,"-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"tot.",5,0,5,0,4,0,1,0,2,1,3,0,4,0,1,0,8,0,4,0,1,1,1,0,1.5,0,5,0,1,0,0.5,0,1,0,4,0,52,2]
[]
[]
[null,"PREVISIONE COMPLESSIVA PER L'ESERCIZIO 2020"]
[null,"1) PERSONALE di RUOLO (situazione all'1.2.2020)",{"$nulls":17},"2) PERSONALE a TEMPO DETERMINATO (situazione all'1.2.2020)",{"$nulls":14},"TOTALE"]
[null,"a) In servizio",{"$nulls":4},"b) (Vacante)",{"$nulls":7},"Totale",{"$nulls":4},"a) In servizio",{"$nulls":5},"b) vacante ",{"$nulls":5},"Totale",null,null,"GENERALE"]
[{"$nulls":14},"a) + b)",{"$nulls":4},"Sostit.pers.in maternità",null,null,null,"Tot. a)",null,"Sostit.pers.in maternità",null,null,null,"Tot. b)",null,"a) + b)",null,null,"1) + 2)"]
[null,52,{"$nulls":4},2,{"$nulls":7},54,{"$nulls":19},54]
[]
[null,"** trattasi di n. 1 unità destinata al 50% al servizio viabilità ed al 50% ai servizi cimiteriali"]
[]
[null,"1) PERSONALE di RUOLO - situazione attuale",{"$nulls":17},"2) PERSONALE a TEMPO DETERMINATO e in COMANDO TEMPORANEO",{"$nulls":14},"TOTALE"]
[null,"a) In servizio",{"$nulls":4},"b) (Vacante)",{"$nulls":7},"Totale",{"$nulls":4},"a) In servizio",{"$nulls":5},"b) vacante (comando)",{"$nulls":5},"Totale",null,null,"GENERALE"]
[{"$nulls":14},"a) + b)",{"$nulls":4},"Sostit.pers.in maternità",null,null,null,"Tot. a)",null,"Sostit. temp.pers.in pension.",null,null,null,"Tot. b)",null,"a) + b)",null,null,"1) + 2)"]
[null,52,{"$nulls":4},1,{"$nulls":7},53,{"$nulls":19},53]
[]
[{"$nulls":30},"Il Segretario Generale"]
[{"$nulls":30},"-Dr. Gerlando Galluzzo-"]
[]
[{"$nulls":31},"Atto firmato digitalmente ai sensi"]
[{"$nulls":31},"dell’art. 21, secondo comma,"]
[{"$nulls":31},"del D. Lgs. 7 marzo 2005, n. 82"]

{"sheet":"calcolo diff. CCNL ","index":3,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":true,"merged":[[0,0,0,11],[2,2,2,4],[2,9,2,11],[20,1,21,1],[12,2,13,2],[4,2,5,2],[4,3,5,3],[4,9,5,9],[4,10,5,10],[12,9,13,9],[32,9,33,9],[32,10,33,10],[20,2,21,2],[20,3,21,3],[20,9,21,9],[20,10,21,10],[32,2,33,2],[32,3,33,3],[12,10,13,10],[12,3,13,3],[48,1,49,1],[48,2,49,2],[48,3,49,3],[48,9,49,9],[48,10,49,10],[28,0,28,11],[30,2,30,4],[30,9,30,11],[35,1,36,1],[42,1,43,1],[40,2,41,2],[40,3,41,3],[40,9,41,9],[40,10,41,10]],"flags":["formulas_cached_only"]}
["ESERCIZIO 2019"]
[]
[null,null,"PREV. BIL ORIGINARIA",{"$nulls":6},"PREV. BIL DEF BOZZA 6"]
[]
["A","PREV sw 10.10.2018 ccnl vigente","totale sw",1765479.77,null,null,"a detarre","-1 mese D3",3179.5475,"totale sw",1757989.1375]
[null,"(2016-2018, in pend. NEW)",{"$nulls":5},"- 2 mesi FIN asp. Cate",4311.085]
[null,null,"supl.segr.",1990,{"$nulls":5},"supl.segr.",1990]
[null,null,"f.do int.PO",4850.02,{"$nulls":5},"f.do int.PO",4850.02]
[null,null,"TOTALE",1772319.79,{"$nulls":5},"TOTALE",1764829.1575]
[null,null,"TOT PREV",1786440,{"$nulls":5},"TOT PREV",1779140]
[null,null,"arrot",14120.209999999963,0.007967077995557428,{"$nulls":4},"arrot",14310.842500000028,0.008108910961258315]
[]
["B","PREV sw gen 2019 ccnl 2008/09","totale sw",1701227.93,null,null,"a detarre","-1 mese D3","gia' ok","totale sw",1697059.3066666666]
[{"$nulls":7},"- 2 mesi FIN asp. Cate",4168.623333333334]
[null,null,"supl.segr.",1990,{"$nulls":5},"supl.segr.",1990]
[null,null,"f.do int.PO",4850.02,{"$nulls":5},"f.do int.PO",4850.02]
[null,null,"TOTALE",1708067.95,{"$nulls":5},"TOTALE",1703899.3266666667]
[null,null,"TOT PREV",1721680,{"$nulls":5},"TOT PREV",1717720]
[null,null,"arrot",13612.050000000047,0.007969267264806443,{"$nulls":4},"arrot",13820.67333333334,0.008111203001864367]
[]
["A-B","INCR. SPESA CCNL 16/18 VS 08/09","totale sw",64251.840000000084,null,null,"a detarre","-1 mese D3","gia' ok","totale sw",60929.83083333331]
[{"$nulls":7},"- 2 mesi FIN asp. Cate",4168.623333333334]
[null,null,"supl.segr.",0,{"$nulls":5},"supl.segr.",0]
[null,null,"f.do int.PO",0,{"$nulls":5},"f.do int.PO",0]
[null,null,"TOTALE",64251.840000000084,{"$nulls":5},"TOTALE",60929.83083333331]
[null,null,"TOT PREV",64760,{"$nulls":5},"TOT PREV",61420]
[null,null,"arrot",508.1599999999162,0.00790887856285385,{"$nulls":4},"arrot",490.1691666666884,0.008044814173331466]
[]
["ESERCIZI 2020/2021"]
[]
[null,null,"PREV. BIL ORIGINARIA",{"$nulls":6},"PREV. BIL DEF BOZZA 6"]
[]
["A","PREV sw 10.10.2018 ccnl vigente","totale sw",1752761.58,null,null,"a detarre","-1 mese D3",0,"totale sw",1752761.58]
[null,"(2016-2018, in pend. NEW)",{"$nulls":5},"- 2 mesi FIN asp. Cate",0]
[null,null,"supl.segr.",1990,{"$nulls":5},"supl.segr.",1990]
[null,"(DIFF vs 2019= no D3 affianc / no asp. cate)","f.do int.PO",4850.02,{"$nulls":5},"f.do int.PO",4850.02]
[null,null,"TOTALE",1759601.6,{"$nulls":5},"TOTALE",1759601.6]
[null,null,"TOT PREV",1773640,{"$nulls":5},"TOT PREV",1773640]
[null,null,"arrot",14038.399999999907,0.007978169603846636,{"$nulls":4},"arrot",14038.399999999907,0.007978169603846636]
[]
["B","PREV sw gen 2019 ccnl 2008/09","totale sw",1691914.25,null,null,"a detarre","-1 mese D3",0,"totale sw",1691914.25]
[{"$nulls":7},"- 2 mesi FIN asp. Cate",0]
[null,"(DIFF vs 2019= no D3 affianc / no asp. cate)","supl.segr.",1990,{"$nulls":5},"supl.segr.",1990]
[null,null,"f.do int.PO",4850.02,{"$nulls":5},"f.do int.PO",4850.02]
[null,null,"TOTALE",1698754.27,{"$nulls":5},"TOTALE",1698754.27]
[null,null,"TOT PREV",1712310,{"$nulls":5},"TOT PREV",1712310]
[null,null,"arrot",13555.729999999981,0.007979806284754759,{"$nulls":4},"arrot",13555.729999999981,0.007979806284754759]
[]
["A-B","INCR. SPESA CCNL 16/18 VS 08/09","totale sw",60847.330000000075,null,null,"a detarre","-1 mese D3",0,"totale sw",60847.330000000075]
[{"$nulls":7},"- 2 mesi FIN asp. Cate",0]
[null,null,"supl.segr.",0,{"$nulls":5},"supl.segr.",0]
[null,null,"f.do int.PO",0,{"$nulls":5},"f.do int.PO",0]
[null,null,"TOTALE",60847.330000000075,{"$nulls":5},"TOTALE",60847.330000000075]
[null,null,"TOT PREV",61330,{"$nulls":5},"TOT PREV",61330]
[null,null,"arrot",482.6699999999255,0.007932476248340311,{"$nulls":4},"arrot",482.6699999999255,0.007932476248340311]

{"sheet":"DIFF CCNL DETTAGLIO","index":4,"n_rows":55,"n_cols":15,"rows_kept":55,"cut":false,"hidden":true,"merged":[[0,0,0,11],[2,2,2,4],[2,9,2,11],[4,2,5,2],[4,3,5,3],[4,9,5,9],[4,10,5,10],[12,2,13,2],[12,3,13,3],[12,9,13,9],[12,10,13,10],[20,1,21,1],[20,2,21,2],[20,3,21,3],[20,9,21,9],[20,10,21,10],[40,9,41,9],[40,10,41,10],[42,1,43,1],[28,0,28,11],[30,2,30,4],[30,9,30,11],[32,2,33,2],[32,3,33,3],[32,9,33,9],[32,10,33,10],[48,1,49,1],[48,2,49,2],[48,3,49,3],[48,9,49,9],[48,10,49,10],[2,13,2,14],[30,13,30,14],[35,1,36,1],[40,2,41,2],[40,3,41,3],[4,14,5,14],[12,13,13,13],[12,14,13,14],[4,13,5,13],[20,13,21,13],[20,14,21,14],[32,13,33,13],[32,14,33,14],[40,13,41,13],[40,14,41,14],[48,13,49,13],[48,14,49,14]],"flags":["formulas_cached_only"]}
["ESERCIZIO 2019"]
[]
[null,null,"PREV. BIL ORIGINARIA",{"$nulls":6},"PREV. BIL DEF BOZZA 6",null,null,null,"PREV. BIL DEF BOZZA 6"]
[{"$nulls":13},"IMP.+OORR","IRAP"]
["A","PREV sw 10.10.2018 ccnl vigente","totale sw",1765479.77,null,null,"a detarre","-1 mese D3",3179.5475,"totale sw",1757989.1375,null,"DI CUI",1647675.7333333334,110313.40416666666]
[null,"(2016-2018, in pend. NEW)",{"$nulls":5},"- 2 mesi FIN asp. Cate",4311.085]
[null,null,"supl.segr.",1990,{"$nulls":5},"supl.segr.",1990,null,null,1860,130]
[null,null,"f.do int.PO",4850.02,{"$nulls":5},"f.do int.PO",4850.02,null,null,4620.02,230]
[null,null,"TOTALE",1772319.79,{"$nulls":5},"TOTALE",1764829.1575,null,null,1654155.7533333334,110673.40416666666]
[null,null,"TOT PREV",1786440,{"$nulls":5},"TOT PREV",1779140,null,null,1666850,112290]
[null,null,"arrot",14120.209999999963,0.007967077995557428,{"$nulls":4},"arrot",14310.842500000028,0.008108910961258315,null,12694.246666666586,1616.5958333333401]
[]
["B","PREV sw gen 2019 ccnl 2008/09","totale sw",1701227.93,null,null,"a detarre","-1 mese D3","gia' ok","totale sw",1697059.3066666666,null,"DI CUI",1590049.6016666666,107009.705]
[{"$nulls":7},"- 2 mesi FIN asp. Cate",4168.623333333334]
[null,null,"supl.segr.",1990,{"$nulls":5},"supl.segr.",1990,null,null,1860,130]
[null,null,"f.do int.PO",4850.02,{"$nulls":5},"f.do int.PO",4850.02,null,null,4620.02,230]
[null,null,"TOTALE",1708067.95,{"$nulls":5},"TOTALE",1703899.3266666667,null,null,1596529.6216666666,107369.705]
[null,null,"TOT PREV",1721680,{"$nulls":5},"TOT PREV",1717720,null,null,1609840,107880]
[null,null,"arrot",13612.050000000047,0.007969267264806443,{"$nulls":4},"arrot",13820.67333333334,0.008111203001864367,null,13310.378333333414,510.29499999999825]
[]
["A-B","INCR. SPESA CCNL 16/18 VS 08/09","totale sw",64251.840000000084,null,null,"a detarre","-1 mese D3","gia' ok","totale sw",60929.83083333331,null,null,57626.13166666683,3303.699166666658]
[{"$nulls":7},"- 2 mesi FIN asp. Cate",4168.623333333334]
[null,null,"supl.segr.",0,{"$nulls":5},"supl.segr.",0,null,null,0,0]
[null,null,"f.do int.PO",0,{"$nulls":5},"f.do int.PO",0,null,null,0,0]
[null,null,"TOTALE",64251.840000000084,{"$nulls":5},"TOTALE",60929.83083333331,null,null,57626.13166666683,3303.699166666658]
[null,null,"TOT PREV",64760,{"$nulls":5},"TOT PREV",61420,null,null,58090,3330]
[null,null,"arrot",508.1599999999162,0.00790887856285385,{"$nulls":4},"arrot",490.1691666666884,0.008044814173331466,null,463.8683333331719,26.30083333334187]
[]
["ESERCIZI 2020/2021"]
[]
[null,null,"PREV. BIL ORIGINARIA",{"$nulls":6},"PREV. BIL DEF BOZZA 6",null,null,null,"PREV. BIL DEF BOZZA 6"]
[{"$nulls":13},"IMP.+OORR","IRAP"]
["A","PREV sw 10.10.2018 ccnl vigente","totale sw",1752761.58,null,null,"a detarre","-1 mese D3",0,"totale sw",1752761.58,null,null,1642801.9000000001,109959.68]
[null,"(2016-2018, in pend. NEW)",{"$nulls":5},"- 2 mesi FIN asp. Cate",0,null,null,null,"DI CUI"]
[null,null,"supl.segr.",1990,{"$nulls":5},"supl.segr.",1990,null,null,1860,130]
[null,"(DIFF vs 2019= no D3 affianc / no asp. cate)","f.do int.PO",4850.02,{"$nulls":5},"f.do int.PO",4850.02,null,null,4620.02,230]
[null,null,"TOTALE",1759601.6,{"$nulls":5},"TOTALE",1759601.6,null,null,1649281.9200000002,110319.68]
[null,null,"TOT PREV",1773640,{"$nulls":5},"TOT PREV",1773640,null,null,1661750,111890]
[null,null,"arrot",14038.399999999907,0.007978169603846636,{"$nulls":4},"arrot",14038.399999999907,0.007978169603846636,null,12468.079999999842,1570.320000000007]
[]
["B","PREV sw gen 2019 ccnl 2008/09","totale sw",1691914.25,null,null,"a detarre","-1 mese D3",0,"totale sw",1691914.25,null,null,1585250.86,106663.39]
[{"$nulls":7},"- 2 mesi FIN asp. Cate",0,null,null,null,"DI CUI"]
[null,"(DIFF vs 2019= no D3 affianc / no asp. cate)","supl.segr.",1990,{"$nulls":5},"supl.segr.",1990,null,null,1860,130]
[null,null,"f.do int.PO",4850.02,{"$nulls":5},"f.do int.PO",4850.02,null,null,4620.02,230]
[null,null,"TOTALE",1698754.27,{"$nulls":5},"TOTALE",1698754.27,null,null,1591730.8800000001,107023.39]
[null,null,"TOT PREV",1712310,{"$nulls":5},"TOT PREV",1712310,null,null,1604800,107510]
[null,null,"arrot",13555.729999999981,0.007979806284754759,{"$nulls":4},"arrot",13555.729999999981,0.007979806284754759,null,13069.119999999879,486.6100000000006]
[]
["A-B","INCR. SPESA CCNL 16/18 VS 08/09","totale sw",60847.330000000075,null,null,"a detarre","-1 mese D3",0,"totale sw",60847.330000000075,null,null,57551.04000000004,3296.2899999999936]
[{"$nulls":7},"- 2 mesi FIN asp. Cate",0]
[null,null,"supl.segr.",0,{"$nulls":5},"supl.segr.",0,null,null,0,0]
[null,null,"f.do int.PO",0,{"$nulls":5},"f.do int.PO",0,null,null,0,0]
[null,null,"TOTALE",60847.330000000075,{"$nulls":5},"TOTALE",60847.330000000075,null,null,57551.04000000004,3296.2899999999936]
[null,null,"TOT PREV",61330,{"$nulls":5},"TOT PREV",61330,null,null,56950,4380]
[null,null,"arrot",482.6699999999255,0.007932476248340311,{"$nulls":4},"arrot",482.6699999999255,0.007932476248340311,null,-601.0400000000373,1083.7100000000064]

{"sheet":"CAT.PROT.","index":5,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":true,"merged":[[24,2,24,4],[24,6,24,8],[5,2,5,4],[5,6,5,8],[0,0,0,8],[2,0,2,8],[19,0,19,8],[21,0,21,8]],"flags":["formulas_cached_only"]}
["SPESA PERSONALE CAT. PROTETTE 2019"]
[]
["NB: Quale voce a detrarre considerare valori da CCNL 2009/08, in quanto differenziale+ per CCNL 2016/18 già detratto in voce incrementi CCNL"]
[]
[]
[null,null,"CCNL VIGENTE (2016/2018)",null,null,null,"CCNL 2008/2009"]
[]
[null,null,"imp.+oorr","irap","totale",null,"imp.+oorr","irap","totale"]
[]
["CATTANEO ","RETR",14011.5,950.39,14961.89,null,13357.4,916.5,14273.9]
[null,"PROD 2018 ESIG 2019",885.5166399999999,60.7988,946.31544,null,885.5166399999999,60.7988,946.31544]
[null,"TOTALE",14897.01664,1011.1888,15908.20544,null,14242.91664,977.2988,15220.21544]
[]
["BUGINI","RETR",24459.38,1651.87,26111.25,null,23640.38,1573.14,25213.52]
[null,"PROD 2018 ESIG 2019",1528.5586,104.94950000000001,1633.5081,null,1528.5586,104.94950000000001,1633.5081]
[null,"TOTALE",25987.9386,1756.8194999999998,27744.7581,null,25168.9386,1678.0895,26847.0281]
[]
[{"$nulls":4},43652.96354,null,null,null,42067.243539999996]
[]
["SPESA PERSONALE CAT. PROTETTE 2020-2021"]
[]
["NB: Quale voce a detrarre considerare valori da CCNL 2009/08, in quanto differenziale+ per CCNL 2016/18 già detratto in voce incrementi CCNL"]
[]
[]
[null,null,"CCNL VIGENTE (2016/2018)",null,null,null,"CCNL 2008/2009"]
[]
[null,null,"imp.+oorr","irap","totale",null,"imp.+oorr","irap","totale"]
[]
["CATTANEO ","RETR",14011.5,950.39,14961.89,null,13357.4,916.5,14273.9]
[null,"PROD 2019/20 ESIG 2020/21",1091.1113,74.91475000000001,1166.02605,null,1091.1113,74.91475000000001,1166.02605]
[null,"TOTALE",15102.6113,1025.30475,16127.91605,null,14448.5113,991.41475,15439.92605]
[]
["BUGINI","RETR",24459.38,1651.87,26111.25,null,23640.38,1573.14,25213.52]
[null,"PROD 2019/20 ESIG 2020/21",1331.7166,91.43450000000001,1423.1511,null,1331.7166,91.43450000000001,1423.1511]
[null,"TOTALE",25791.0966,1743.3045,27534.4011,null,24972.0966,1664.5745000000002,26636.6711]
[]
[{"$nulls":4},43662.31715,null,null,null,42076.59715]

{"sheet":"PERS.CONV.DISTACCO","index":6,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,0,0,10],[2,0,2,10],[5,2,5,5],[5,7,5,10],[15,0,15,4],[17,10,18,10],[22,0,22,10],[5,0,8,1],[24,0,27,1],[24,2,27,5],[24,6,24,10],[25,6,27,7],[25,10,27,10],[25,8,27,9]],"flags":["formulas_cached_only"]}
["SPESA PERSONALE IN DISTACCO 2019 / 2020 / 2021"]
[]
["NB: Quale voce a detrarre considerare valori da CCNL 2009/08, in quanto differenziale+ per CCNL 2016/18 già detratto in voce incrementi CCNL"]
[]
[]
["DISTACCO ASSISTENTE SOCIALE MINORI C/O AMBITO DI DALMINE PER PIANO DI ZONA",null,"CCNL VIGENTE (2016/2018)",{"$nulls":4},"CCNL 2008/2009"]
[]
[null,null,"imp.+oorr","irap","macro 3","totale",null,"imp.+oorr","irap","macro 3","totale"]
[]
["ADDABBO","RETR",32438.91,2211.51,null,34650.42,null,30833.050000000003,2133.29,null,32966.340000000004]
[null,"PROD 2019/21 - PREV",1670,530,null,2200,null,1670,530,null,2200]
[null,"BUONI PASTO prev 19/21",null,null,1400,1400,null,null,null,1400,1400]
[null,"RIMB.TRASFERTE PREV 19/21",null,null,550,550,null,null,null,550,550]
[null,"TOTALE",34108.91,2741.51,1950,38800.42,null,32503.050000000003,2663.29,1950,37116.340000000004]
[]
["E 2420 PREV 2019/2020",{"$nulls":4},39400]
[]
[{"$nulls":10},"= qp e 2420"]
[]
[]
[]
[]
["SPESA PERSONALE IN CONVENZIONE 2019 / 2020 / 2021"]
[]
["RIMBORSO SPESA SEGRETERIA CONVENZIONATA SANPELLEGRINO ",null,"PREV. SPESA ANCORA IN ASSENZA VAL.RINNOVI CCNL 2016/2018 (NON INTERCORSO ed in accantonamento)",null,null,null,"valore a detrarre pertanto pari a "]
[{"$nulls":6},"E 2400 PREV",null,"come da file di calcolo agli atti",null,39000]