{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Annex XVI","Factura","IRPF","Dades"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":23,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Annex XVI","index":0,"n_rows":52,"n_cols":27,"rows_kept":52,"cut":false,"hidden":false,"merged":[[8,0,21,0],[11,2,11,7],[13,2,13,7],[15,2,15,7],[13,9,13,16],[11,9,11,16],[17,2,17,7],[19,2,19,7],[15,9,15,16],[17,9,17,16],[19,9,19,16],[11,19,11,22],[13,19,13,22],[15,19,15,22],[15,24,15,26],[17,19,17,26],[19,19,19,26],[8,2,8,3],[9,2,9,3],[8,4,8,26],[9,4,9,26],[48,19,48,20],[39,20,42,27],[42,3,42,9],[43,3,43,9],[31,4,31,5],[32,4,32,5],[33,4,33,5],[34,4,34,5],[11,24,11,26],[13,24,13,26],[12,24,12,26],[12,2,12,7],[12,9,12,16],[12,19,12,22],[20,2,20,7],[16,2,16,7],[20,19,20,26],[18,2,18,7],[49,24,49,25],[36,2,36,6],[24,21,24,26],[25,21,25,24],[25,20,26,20],[25,25,25,26],[34,7,34,16],[40,15,40,16],[28,7,28,16],[29,7,29,16],[48,24,48,25],[43,15,43,16],[26,18,26,19],[49,19,49,20],[48,21,48,22],[49,21,49,22],[34,18,34,19],[36,18,36,19],[27,18,27,19],[28,18,28,19],[29,18,29,19],[44,15,44,16],[39,15,39,16],[40,3,40,9],[25,17,25,19],[24,3,26,3],[36,9,36,15],[45,20,45,23],[30,7,30,16],[27,7,27,16],[48,0,48,14],[40,1,44,1],[39,0,46,0],[41,15,41,16],[42,15,42,16],[23,0,37,0],[24,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[30,4,30,5],[31,18,31,19],[32,18,32,19],[33,18,33,19],[31,7,31,16],[32,7,32,16],[33,7,33,16],[30,18,30,19],[44,3,44,9],[45,3,45,10],[46,20,46,26],[41,3,41,9],[51,21,51,22],[49,0,50,17],[6,25,6,26],[5,25,5,26],[3,22,3,26],[14,24,14,26],[16,24,16,26],[14,19,14,22],[18,9,18,16],[20,9,20,16],[18,19,18,26],[14,9,14,16],[16,9,16,16],[16,19,16,22],[14,2,14,7],[51,0,51,14],[24,2,26,2],[24,6,26,6],[24,7,24,20],[25,7,26,16],[0,21,1,27],[1,4,1,20],[6,0,7,3],[6,22,6,23],[5,22,5,23],[2,5,2,20],[2,22,2,26],[4,22,4,23],[4,25,4,26],[3,5,3,6],[3,7,3,20],[4,5,4,6],[4,7,4,20],[5,7,6,20],[5,5,6,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDEMNITZACIONS PER LA INTERVENCIÓ EN ACTIVITATS DE FORMACIÓ DEL PROFESSORAT"]
[null,null,null,null,"Servei de xxxxx"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modalitat"]
[null,null,null,null,null,"Títol"]
[null,null,null,null,null,"Lloc(s) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Esdeveniment",null,null,"Activitat"]
[null,null,null,null,null,"Dates i hores"]
[]
[]
["Dades personals",null,"Personal CAIB",null,"emplenar nom, llinatges, NIF, centre de treball i localitat del centre"]
[null,null,"Personal no CAIB ",null,"emplenar nom, llinatges, NIF, domicili, codi postal i localitat i IBAN"]
[]
[null,null,"Llinatges",null,null,null,null,null,null,"Nom",null,null,null,null,null,null,null,null,null,"NIF",null,null,null,null,"Personal CAIB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,{"$f":"IF(ESCAIB=\"Si\",\"\",\"Domicili\")","v":"Domicili"},null,null,null,null,null,null,{"$f":"IF(ESCAIB=\"Si\",\"\",\"Codi postal i localitat\")","v":"Codi postal i localitat"}]
[]
[null,null,{"$f":"IF(ESCAIB=\"No\",\"\",\"Centre de treball\")","v":""},null,null,null,null,null,null,{"$f":"IF(ESCAIB=\"No\",\"\",\"Localitat\")","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ESCAIB=\"Si\",\"\",\"IBAN\")","v":"IBAN"}]
[]
[]
[]
["Declaració de desplaçaments"]
[null,null,"Data de sortida","Hora de sortida","Data de tornada",null,"Hora de tornada","Despeses de locomoció",null,null,null,null,null,null,null,null,null,null,null,null,null,"Despeses d'estada"]
[null,null,null,null,null,null,null,"Itinerari",null,null,null,null,null,null,null,null,null,"Quilòmetres",null,null,"Tíquets i bitllets","Dietes",null,null,null,"Allotjaments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Num.","Import",null,null,"I","F","S","M","Núm","Import"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R28=\"\",\"\",R28*IRPF!B$5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R29=\"\",\"\",R29*IRPF!B$5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R30=\"\",\"\",R30*IRPF!B$5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R31=\"\",\"\",R31*IRPF!B$5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R32=\"\",\"\",R32*IRPF!B$5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R33=\"\",\"\",R33*IRPF!B$5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R34=\"\",\"\",R34*IRPF!B$5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R35=\"\",\"\",R35*IRPF!B$5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V28:V35)","v":0},{"$f":"SUM(W28:W35)","v":0},{"$f":"SUM(X28:X35)","v":0},{"$f":"SUM(Y28:Y35)","v":0}]
[null,null,{"$f":"IF(ESCAIB=\"Si\",\"\",\"Base imposable subjecta a IRPF\")","v":"Base imposable subjecta a IRPF"},null,null,null,null,{"$f":"IF(ESCAIB=\"Si\",\"\",ROUND(IRPF!C21,2))","v":0},null,{"$f":"IF(ESCAIB=\"Si\",\"\",\"Base no subjecta a IRPF\")","v":"Base no subjecta a IRPF"},null,null,null,null,null,null,{"$f":"IF(ESCAIB=\"Si\",\"\",ROUND(S37+U37+V37+W37+X37+Y37+AA37-H37,2))","v":0},{"$f":"SUM(R28:R35)","v":0},{"$f":"SUM(S28:S35)","v":0},null,{"$f":"SUM(U28:U35)","v":0},{"$f":"V36*IRPF!B$8","v":0},{"$f":"W36*IRPF!B$9","v":0},{"$f":"X36*IRPF!B$10","v":0},{"$f":"Y36*IRPF!B$11","v":0},{"$f":"SUM(Z28:Z35)","v":0},{"$f":"SUM(AA28:AA35)","v":0}]
[]
[]
["Despeses ensenyament",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ESCAIB=\"Si\",\"\",\"Retencions IRPF\")","v":"Retencions IRPF"},null,{"$f":"IF(ESCAIB=\"Si\",\"\",CONCATENATE(IRPF!B2,\"%\"))","v":"15%"},null,null,"Així mateix declara no incórrer en les incompatibilitats a les que fa referència l'article 7 de l'Ordre del conseller d'Educació i Cultura de 20 de maig de 2011 de regulació de les indemnitzacions per la intervenció en activitats de formació permanent del professorat no universitari."]
[null,null,"Hores / Unitats","Concepte",null,null,null,null,null,null,"Mòdul assignat","Total\nparcial",null,null,null,{"$f":"IF(ESCAIB=\"Si\",\"\",\"Concepte\")","v":"Concepte"},null,{"$f":"IF(ESCAIB=\"Si\",\"\",\"TOTAL\")","v":"TOTAL"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C42=0,K42,C42*K42)","v":0},null,null,null,{"$f":"IF(ESCAIB=\"Si\",\"\",\"Indem. Intervenció\")","v":"Indem. Intervenció"},null,{"$f":"IF(ESCAIB=\"Si\",\"\",L46*IRPF!B$2/100)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C43=0,K43,C43*K43)","v":0},null,null,null,{"$f":"IF(ESCAIB=\"Si\",\"\",\"Indem. raó del servei\")","v":"Indem. raó del servei"},null,{"$f":"IF(ESCAIB=\"Si\",\"\",IRPF!D$21)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(ESCAIB=\"Si\",\"\",\"Total IRPF\")","v":"Total IRPF"},null,{"$f":"IF(ESCAIB=\"Si\",\"\",SUM(R42:R43))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Total",null,null,null,null,null,null,null,{"$f":"SUM(L42:L45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La persona interessada"]
[]
["xxxxxxx, cap del Servei de xxxxxxx",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total brut:",null,{"$f":"S37+U37+IRPF!B33+AA37+L46","v":0},null,null,{"$f":"IF(ESCAIB=\"Si\",\"\",\"Amb IRPF:\")","v":"Amb IRPF:"},null,{"$f":"IF(ESCAIB=\"Si\",\"\",L46+H37)","v":0}]
["certifica que el participant indicat ha assistit a l'activitat esmentada i ha realitzat els  desplaçaments i treballs reflectits en el present document.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ESCAIB=\"Si\",\"\",\"Total liquid:\")","v":"Total liquid:"},null,{"$f":"IF(ESCAIB=\"Si\",\"\",V49-R44)","v":0},null,null,{"$f":"IF(ESCAIB=\"Si\",\"\",\"Sense IRPF:\")","v":"Sense IRPF:"},null,{"$f":"IF(ESCAIB=\"Si\",\"\",Q37)","v":0}]
[]
["Palma, 1 de gener de 2025"]

{"sheet":"Factura","index":1,"n_rows":59,"n_cols":24,"rows_kept":59,"cut":false,"hidden":false,"merged":[[58,1,58,7],[58,8,58,25],[52,12,52,21],[52,22,52,25],[4,12,4,15],[49,12,49,21],[49,22,49,25],[48,12,48,21],[48,22,48,25],[51,12,51,21],[51,22,51,25],[43,22,43,25],[45,22,45,25],[46,22,46,25],[45,12,45,21],[46,12,46,21],[3,13,3,25],[4,16,4,17],[10,2,10,22],[34,23,34,25],[34,1,34,22],[27,1,27,22],[17,7,17,25],[20,7,20,25],[18,1,18,6],[18,7,18,25],[19,1,19,6],[19,7,19,25],[20,1,20,6],[15,1,15,6],[16,1,16,6],[16,7,16,25],[24,23,24,25],[24,1,24,22],[25,23,25,25],[26,23,26,25],[27,23,27,25],[25,1,25,22],[26,1,26,22],[23,1,23,22],[29,1,29,22],[31,1,31,22],[32,1,32,22],[33,1,33,22],[35,1,36,25],[28,23,28,25],[30,23,30,25],[40,12,40,21],[39,12,39,21],[40,22,40,25],[39,22,39,25],[15,7,15,25],[22,1,22,25],[32,23,32,25],[17,1,17,6],[0,12,0,25],[1,12,1,25],[2,12,2,25],[13,1,13,25],[7,1,7,20],[8,1,8,20],[9,1,9,20],[11,1,11,2],[11,3,11,20],[6,1,6,22],[28,1,28,22],[30,1,30,22],[56,1,56,25],[54,1,54,25],[38,12,38,21],[47,12,47,21],[50,12,50,21],[38,22,38,25],[47,22,47,25],[50,22,50,25],[41,12,41,21],[44,12,44,21],[44,22,44,25],[42,12,42,21],[42,22,42,25],[43,12,43,21],[41,22,41,25]]}
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CONCATENATE(nom,\" \",llinatges)=\" \",\"Nom i llinatges\",CONCATENATE(nom,\" \",llinatges))","v":"Nom i llinatges"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(domicili=0,\"Domicili\",domicili)","v":"Domicili"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(localitat=0,\"Localitat\",localitat)","v":"Localitat"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"NIF: ",{"$f":"IF(NIF=0,\"\",NIF)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Personal CAIB:",null,null,null,{"$f":"'Annex XVI'!Y13","v":"No"}]
[]
[null,"Conselleria d'Educació i Universitats"]
[null,"Servei de Formació Permanent del Professorat"]
[null,"C/ Carrer del Ter, 16"]
[null,"07009 Palma"]
[null,"NIF:","S0711001H"]
[]
[]
[null,"MINUTA NÚM. XXXX/2024"]
[]
[null,"Modalitat:",null,null,null,null,null,{"$f":"IF(modalitat=0,\"\",modalitat)","v":""}]
[null,"Codi activitat:",null,null,null,null,null,{"$f":"IF(activitat=0,\"\",activitat)","v":""}]
[null,"Codi esdeveniment:",null,null,null,null,null,{"$f":"IF(esdeveniment=0,\"\",esdeveniment)","v":""}]
[null,"Títol de l'activitat:",null,null,null,null,null,{"$f":"IF(titol=0,\"\",titol)","v":""}]
[null,"Lloc de celebració:",null,null,null,null,null,{"$f":"IF(lloc=0,\"\",lloc)","v":""}]
[null,"Dates i hores: ",null,null,null,null,null,{"$f":"IF(dates=0,\"\",dates)","v":""}]
[]
[null,"CONCEPTES:"]
[null,"Ensenyament"]
[null,{"$f":"IF('Annex XVI'!D42=0,\" \",IF('Annex XVI'!C42=0,CONCATENATE(\"•  \",'Annex XVI'!D42),CONCATENATE(\"• \",'Annex XVI'!C42,\" \",LOWER('Annex XVI'!D42),\". Mòdul \",'Annex XVI'!K42,\" €\")))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Annex XVI'!L42=0,\" \",'Annex XVI'!L42)","v":" "}]
[null,{"$f":"IF('Annex XVI'!D43=0,\" \",IF('Annex XVI'!C43=0,CONCATENATE(\"•  \",'Annex XVI'!D43),CONCATENATE(\"• \",'Annex XVI'!C43,\" \",LOWER('Annex XVI'!D43),\". Mòdul \",'Annex XVI'!K43,\" €\")))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Annex XVI'!L43=0,\" \",'Annex XVI'!L43)","v":" "}]
[null,{"$f":"IF('Annex XVI'!D44=0,\" \",IF('Annex XVI'!C44=0,CONCATENATE(\"•  \",'Annex XVI'!D44),CONCATENATE(\"• \",'Annex XVI'!C44,\" \",LOWER('Annex XVI'!D44),\". Mòdul \",'Annex XVI'!K44,\" €\")))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Annex XVI'!L44=0,\" \",'Annex XVI'!L44)","v":" "}]
[null,{"$f":"IF('Annex XVI'!D45=0,\" \",IF('Annex XVI'!C45=0,CONCATENATE(\"•  \",'Annex XVI'!D45),CONCATENATE(\"• \",'Annex XVI'!C45,\" \",LOWER('Annex XVI'!D45),\". Mòdul \",'Annex XVI'!K45,\" €\")))","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[null,"Honoraris d'acord amb els mòduls econòmics fixats a l'Ordre del conseller d'Educació i Cultura de 20-05-2011 (BOIB de dia 07-06-2011)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Import íntegre (brut)",null,null,null,null,null,null,null,null,null,{"$f":"'Annex XVI'!V49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"• Ensenyament",null,null,null,null,null,null,null,null,null,{"$f":"'Annex XVI'!L46","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"• Desplaçaments",null,null,null,null,null,null,null,null,null,{"$f":"'Annex XVI'!H37+'Annex XVI'!Q37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Subjecte a retenció IRPF",null,null,null,null,null,null,null,null,null,{"$f":"'Annex XVI'!AA49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"• Ensenyament",null,null,null,null,null,null,null,null,null,{"$f":"'Annex XVI'!L46","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"• Desplaçaments",null,null,null,null,null,null,null,null,null,{"$f":"'Annex XVI'!H37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"No subjecte a retenció IRPF",null,null,null,null,null,null,null,null,null,{"$f":"'Annex XVI'!AA50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"• Ensenyament",null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"• Desplaçaments",null,null,null,null,null,null,null,null,null,{"$f":"'Annex XVI'!Q37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Retenció IRPF (15%)",null,null,null,null,null,null,null,null,null,{"$f":"'Annex XVI'!$R$44","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"• Ensenyament",null,null,null,null,null,null,null,null,null,{"$f":"'Annex XVI'!R42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"• Desplaçaments",null,null,null,null,null,null,null,null,null,{"$f":"'Annex XVI'!R43","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total a percebre (líquid)",null,null,null,null,null,null,null,null,null,{"$f":"'Annex XVI'!V50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"• Ensenyament",null,null,null,null,null,null,null,null,null,{"$f":"W40-W49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"• Desplaçaments",null,null,null,null,null,null,null,null,null,{"$f":"W41-W50","v":0}]
[]
[null,"(Exempt d'IVA d'acord amb l'art. 20.9 de la Llei 37/1992 de l'IVA)"]
[]
[null,{"$f":"'Annex XVI'!$A$52","v":"Palma, 1 de gener de 2025"}]
[]
[null,{"$f":"IF('Annex XVI'!$T$21=0,\" \",\"A ingressar en el compte:\")","v":" "},null,null,null,null,null,null,{"$f":"IF('Annex XVI'!$T$21=0,\" \",'Annex XVI'!$T$21)","v":" "}]

{"sheet":"IRPF","index":2,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
["Retencions IRPF",15,null,null,null,null,null,null,"Hora/es de docència en activitats de formació permanent presencial"]
[null,null,null,null,null,null,null,null,"Hora/es de docència en activitats de formació permanent a distància"]
[null,null,"Asignacions actuals",null,"No té IRPF","Té IRPF",null,null,"Hora/es de docència en activitats per a l'aprenentatge d'idiomes"]
["Per kilometratge automobil",0.26238400000000001,null,null,{"$f":"IF(ESCAIB=\"Si\",0.26,0)","v":0},{"$f":"IF(B5-E5<=0,0,B5-E5)","v":0.26238400000000001},null,null,"Conferència"]
[null,null,null,null,null,null,null,null,"Ponència de professional de reconegut prestigi"]
["Dietes a l'estat espanyol",null,null,null,null,null,null,null,"Participació en taules rodones"]
["Dins l'Illa   (I)",16.37,null,26.67,{"$f":"IF(ESCAIB=\"Si\",26.67,0)","v":0},{"$f":"IF(B8-E8<=0,0,B8-E8)","v":16.37},null,null,"Elaboració de material de formació per activitats presencials"]
["Fora illa, retorn el mateix dia",78.23,null,null,{"$f":"IF(ESCAIB=\"Si\",26.67,0)","v":0},{"$f":"IF(B9-E9<=0,0,B9-E9)","v":78.23},null,null,"Traducció de materials didàctics formatius"]
["Fora illa amb pernoctació",94.58,null,null,{"$f":"IF(ESCAIB=\"Si\",53.34,0)","v":0},{"$f":"IF(B10-E10<=0,0,B10-E10)","v":94.58},null,null,"Organització, coordinació i direcció activitats formació fins a 40 h"]
["mitja S, sortida després 15 h. i / o retorn abans 15h.",47.29,null,null,{"$f":"IF(ESCAIB=\"Si\",53.34,0)","v":0},{"$f":"IF(B11-E11<=0,0,B11-E11)","v":47.29},null,null,"Organització, coordinació i direcció activitats formació fins a 20 h"]
[null,null,null,null,null,null,null,null,"Organització, coordinació i direcció activitats formació de més de 40 h"]
[null,null,null,null,null,null,null,null,"Elaboració de materials activitat formació a distància d'entre 10 i 19 h"]
["Càlculs IRPF ",null,null,null,null,null,null,null,"Elaboració de materials activitat formació a distància d'entre 20 i 29 h"]
[null,"Retenció ","Base imponible","IRPF",null,null,null,null,"Elaboració de materials activitat formació a distància d'entre 30 i 39 h"]
["Per kilometratge automobil",{"$f":"IF(E5<B5,ROUND((B5-E5)*'Annex XVI'!R37,2),0)*IRPF!B$2/100","v":0},{"$f":"ROUND(F5*'Annex XVI'!R37,2)","v":0},{"$f":"C16*(15/100)","v":0},null,null,null,null,"Elaboració de materials activitat formació a distància a partir de 40 h"]
["Dins l'Illa   (I)",{"$f":"IF(E8<B8,ROUND((B8-E8)*'Annex XVI'!V36,2)*IRPF!B$2/100,0)","v":0},{"$f":"ROUND(F8*'Annex XVI'!V36,2)","v":0},{"$f":"C17*(15/100)","v":0},null,null,null,null,"Actualització de materials activitat formació a distància d'entre 10 i 19 h"]
["Fora illa, retorn el mateix dia",{"$f":"IF(E9<B9,ROUND((B9-E9)*'Annex XVI'!W36,2)*IRPF!B$2/100,0)","v":0},{"$f":"ROUND(F9*'Annex XVI'!W36,2)","v":0},0,null,null,null,null,"Actualització de materials activitat formació a distància d'entre 20 i 29 h"]
["Fora illa amb pernoctació",{"$f":"IF(E10<B10,ROUND((B10-E10)*'Annex XVI'!X36,2)*IRPF!B$2/100,0)","v":0},{"$f":"ROUND(F10*'Annex XVI'!X36,2)","v":0},0,null,null,null,null,"Actualització de materials activitat formació a distància d'entre 30 i 39 h"]
["mitja S, sortida després 15 h. i / o retorn abans 15h.",{"$f":"IF(E11<B11,ROUND((B11-E11)*'Annex XVI'!Y36,2)*IRPF!B$2/100,0)","v":0},{"$f":"ROUND(F11*'Annex XVI'!Y36,2)","v":0},0,null,null,null,null,"Actualització de materials activitat formació a distància a partir de 40 h"]
["Total IRPF",{"$f":"ROUND(SUM(B16:B20),2)","v":0},{"$f":"ROUND(SUM(C16:C20),2)","v":0},{"$f":"ROUND(SUM(D16:D20),2)","v":0}]
[]
[]
[null,7.6845119999999998]
[]
[null,{"$f":"B24-B18","v":7.6845119999999998}]
[]
[]
[]
[]
[]
[]
["Total dietes",{"$f":"B8*'Annex XVI'!V36+B9*'Annex XVI'!W36+B10*'Annex XVI'!X36+B11*'Annex XVI'!Y36","v":0}]

{"sheet":"Dades","index":3,"n_rows":93,"n_cols":2,"rows_kept":93,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Modalitats"]
["Activitat puntual de formació"]
["Formació de centre"]
["Formació en el centre"]
["Formació especialitzada"]
["Formació intercentres"]
["Formació per àmbits"]
["Programa d'experiència formativa"]
[]
[]
["CEP"]
["Servei de Formació Permanent del Professorat"]
["CEP de Palma"]
["CEP d'Inca"]
["CEP de Manacor"]
["CEP de Menorca"]
["CEP d'Eivissa"]
["CEP de Formentera"]
["CEP de Calvià"]
["CEP IBSTEAM"]
["CFIRDE-IB"]
["Equip DINAMICAT"]
[]
["Directors"]
["Rafel Maura Reus, cap del Servei de Formació Permanent del Professorat","SFP"]
["Catalina E. Ribot Mayol, director del CEP de Palma","Palma"]
["Irma Alanzol Pereira-Rocha, directora del CEP d'Inca","Inca"]
["Bartomeu A. Frau Llull, director del CEP de Manacor","Manacor"]
["Caterina Antonio Florit, directora del CEP de Menorca","Menorca"]
["Salvador Ruiz Borràs, director del CEP d'Eivissa","Eivissa"]
["Rosa Martí Julià, directora del CEP de Formentera","Formentera"]
["Lorena Valenzuela Porras, directora del CEP de Calvià","Calvià"]
["Tomeu Parets Amengual, director del CEP IBSTEAM","IBSTEAM"]
["Antonio Márquez Muñiz, director del CFIRDE-IB","CFIRDE-IB"]
[", gestora econòmica de l'Equip DINAMICAT","Dinamicat"]
[]
["Adreces1"]
["C/ Carrer del Ter, 16","SFP"]
["C/ Gregorio Marañón, s/n","Palma"]
["C/ Mestre Antoni Torrandell, 59","Inca"]
["Camí de Bendrís s/n","Manacor"]
["C/Mallorca, 67","Menorca"]
["Via Púnica, 23, baixos dreta","Eivissa"]
["Avinguda de Porto-salè 87","Formentera"]
["Passeig d’Illetes, 4, local 15-16","Calvià"]
["C/ Gregorio Marañón, s/n","IBSTEAM"]
["C/ Gregorio Marañón, s/n","CFIRDE-IB"]
["C/ Carrer del Ter, 16","Dinamicat"]
[]
["Adreces2"]
["07009 Palma","SFP"]
["07007 Palma","Palma"]
["07300 Inca","Inca"]
["07500 Manacor","Manacor"]
["07760 Ciutadella","Menorca"]
["07800 Eivissa","Eivissa"]
["07860 Sant Francesc Xavier","Formentera"]
["07181 Ses Illetes","Calvià"]
["07007 Palma","Palma"]
["07007 Palma","Palma"]
["07009 Palma","Dinamicat"]
[]
["NIF"]
["S0711001H","SFP"]
["S0718181A","Palma"]
["S0718177I","Inca"]
["S0718179E","Manacor"]
["S0718002I","Menorca"]
["S0718175C","Eivissa"]
["S0700092J","Formentera"]
["Q0700727A","Calvià"]
["S0700134J","IBSTEAM"]
["S0700137C","CFIRDE-IB"]
["Q0700440A","Dinamicat"]
[]
["Signatura"]
["Palma, 1 de gener de 2025","SFP"]
["Palma, 1 de gener de 2025","Palma"]
["Inca, 1 de gener de 2025","Inca"]
["Manacor, 1 de gener de 2025","Manacor"]
["Ciutadella, 1 de gener de 2025","Menorca"]
["Eivissa, 1 de gener de 2025","Eivissa"]
["Sant Francesc Xavier, 1 de gener de 2025","Formentera"]
["Ses Illetes, 1 de gener de 2025","Calvià"]
["Palma, 1 de gener de 2025","IBSTEAM"]
["Palma, 1 de gener de 2025","CFIRDE-IB"]
["Palma, 1 de gener de 2025","Dinamicat"]
[]
["Personal CAIB"]
["Si"]
["No"]