{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Relació classificada despeses","Quadre d'amortitzacions","CC3-E anvers","Relació class. desp. comp. clau","CC3-E comp. clau","Criteris imputació proves comp."],"not_rendered":{"images":5,"defined_names":2,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Relació classificada despeses","index":0,"n_rows":89,"n_cols":19,"rows_kept":89,"merged":[[8,11,8,19],[9,7,9,8],[9,12,9,19],[10,7,10,8],[11,7,11,8],[12,7,12,8],[16,3,16,5],[17,3,17,5],[18,3,18,5],[19,3,19,5],[23,18,23,19],[24,18,24,19],[25,1,25,8],[25,18,25,19],[26,18,26,19],[30,18,30,19],[31,18,31,19],[32,1,32,8],[32,18,32,19],[33,18,33,19],[35,18,35,19],[36,18,36,19],[37,18,37,19],[38,18,38,19],[41,18,41,19],[42,18,42,19],[43,18,43,19],[44,18,44,19],[45,18,45,19],[46,18,46,19],[47,18,47,19],[48,18,48,19],[49,18,49,19],[50,18,50,19],[51,18,51,19],[52,18,52,19],[53,18,53,19],[54,18,54,19],[55,18,55,19],[56,18,56,19],[57,18,57,19],[58,18,58,19],[59,18,59,19],[60,18,60,19],[61,18,61,19],[62,18,62,19],[63,18,63,19],[64,18,64,19],[65,18,65,19],[66,18,66,19],[67,18,67,19],[68,18,68,19],[69,18,69,19],[70,18,70,19],[71,18,71,19],[72,18,72,19],[73,18,73,19],[74,18,74,19],[75,18,75,19],[78,18,78,19],[79,18,79,19],[80,18,80,19],[81,18,81,19],[85,18,85,19]]}
{"$rows_empty":7}
[null,"NÚMEROS D'EXPEDIENT:"]
[null,"NOM DEL CENTRE:",{"$nulls":9},"Requisit a revisar"]
[null,"DATA DE COMENÇAMENT:",{"$nulls":3},"DATA D'ACABAMENT:",{"$nulls":5},"A","Hi ha document de despesa?"]
[]
[]
[]
[{"$nulls":11},"B","La naturalesa de la despesa és elegible?"]
[null,"RELACIÓ DE JUSTIFICANTS DE DESPESES DE LES ACCIONS FORMATIVES",{"$nulls":9},"E","Hi ha comprovació del pagament objectiu de la despesa?"]
[{"$nulls":11},"F","Hi ha segell de finançament del SOIB / cofinançament del FSE?"]
[null,"NOM DELS CURSOS:",{"$nulls":9},"G","L'import està dins els límits fixats a la convocatòria?"]
[]
[]
[]
[]
[null," COSTS DIRECTES DE LES ACTIVITATS FORMATIVES"]
[]
[null,"NÚM. D'ORDRE","DATA FRA. ","NÚM. FRA./NÒMINA","PERCEPTOR","CIF/NIF","CONCEPTE","DATA PAGAMENT","IMPORT TOTAL","IMPORT IMPUTAT","IMPORT ELEGIBLE","A","B","C","D","E","F","G","Observacions"]
[null,"1. SALARIS FORMADORS"]
[null,"1.1 COST DOCENT",{"$nulls":7},{"$f":"SUM(J27:J32)","v":0},{"$f":"SUM(K27:K32)","v":0}]
[]
[]
[]
[]
[]
[]
[null,"1.2 COST TUTORIA",{"$nulls":7},{"$f":"SUM(J34:J37)","v":0},{"$f":"SUM(K34:K37)","v":0}]
[]
[]
[]
[]
[null,"2. AMORTITZACIÓ D'INSTAL·LACIONS, EQUIPS, AULES, TALLERS…",{"$nulls":7},{"$f":"SUM(J39:J44)","v":0},{"$f":"SUM(K39:K44)","v":0}]
[]
[]
[]
[]
[]
[]
[null,"3. LLOGUER D'INSTAL·LACIONS",{"$nulls":7},{"$f":"SUM(J46:J49)","v":0},{"$f":"SUM(K46:K49)","v":0}]
[]
[]
[]
[]
[null,"4. MATERIALS I MITJANS DIDÀCTICS",{"$nulls":7},{"$f":"SUM(J51:J54)","v":0},{"$f":"SUM(K51:K54)","v":0}]
[]
[]
[]
[]
[null,"5. ASSEGURANÇA D'ACCIDENTS I RESPONSABILITAT CIVIL D'ALUMNES I PROFESSORS",{"$nulls":7},{"$f":"SUM(J56:J59)","v":0},{"$f":"SUM(K56:K59)","v":0}]
[]
[]
[]
[]
[null,"6. PUBLICITAT",{"$nulls":7},{"$f":"SUM(J61:J64)","v":0},{"$f":"SUM(K61:K64)","v":0}]
[]
[]
[]
[]
[null,"TOTAL DELS COSTS DIRECTES DE L'ACTIVITAT FORMATIVA (7)",{"$nulls":7},{"$f":"+J60+J55+J50+J45+J38+J33+J26","v":0},{"$f":"+K60+K55+K50+K45+K38+K33+K26","v":0}]
[]
[]
[null,"COSTS ASSOCIATS A L'ACTIVITAT FORMATIVA"]
[]
[null,"NÚM. D'ORDRE","DATA FRA. ","NÚM. FRA./NÒMINA","PERCEPTOR","CIF/NIF","CONCEPTE","DATA PAG.","IMPORT TOTAL","IMPORT IMPUTAT","IMPORT ELEGIBLE","A","B","C","D","E","F","G","Observacions"]
[null,"8. GESTIÓ (direcció i coordinació)"]
[]
[]
[]
[]
[null,"TOTAL COSTS ASSOCIATS A L'ACTIVITAT FORMATIVA (9)",{"$nulls":7},{"$f":"+SUM(J72:J75)","v":0},{"$f":"+SUM(K72:K75)","v":0}]
[]
[]
[null,"ALTRES DESPESES"]
[]
[null,"NÚM. D'ORDRE","DATA FRA. ","NÚM. FRA./NÒMINA","PERCEPTOR","CIF/NIF","CONCEPTE","DATA PAG.","IMPORT TOTAL","IMPORT IMPUTAT","IMPORT ELEGIBLE","A","B","C","D","E","F","G","Observacions"]
[null,"10. DESPESES D'AUDITORIA"]
[]
[]
[]
[null,"TOTAL DESPESES CORRESPONENTS A L'AUDITORIA (11)",{"$nulls":7},{"$f":"+SUM(J83:J85)","v":0},{"$f":"+SUM(K83:K85)","v":0}]
[]
[]
[{"$nulls":9},{"$f":"+J76+J65+J86","v":0},{"$f":"+K76+K65+K86","v":0}]

{"sheet":"Quadre d'amortitzacions","index":1,"n_rows":37,"n_cols":13,"rows_kept":37}
[]
[]
[]
[]
[{"$nulls":3},"QUADRE D'AMORTITZACIÓ"]
[]
[]
[]
[null,"El Sr. / La Sra.  …………………...……...…………..……………………… , en la seva qualitat de (càrrec)  …………..……...……………………………  del centre  ………………………………………………………………………………….."]
[null,"amb CIF núm.  ……………………………..  CERTIFICA que les despeses que s'imputen a l'acció formativa núm.  ………./………/……… en concepte d'amortització d'instal·lacions, equips, aules, tallers i "]
[null,"altres superfícies utilitzades en el desenvolupament de la formació, es corresponen amb els següents justificants individualitzats:"]
[]
[null,"Element amortitzable","Proveïdor","CIF Proveïdor","Data adquisició","Import adquisició","% Amortització anual","Quota anual","Hores totals d'ús anual","Hores imputades","Superfície total del centre, si escau","Superfícies destinades a l'operació, si escau","Cost imputat1"]
[{"$nulls":7},{"$f":"+G14*F14","v":0}]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":6},"TOTAL",{"$nulls":5},{"$f":"+SUM(M14:M28)","v":0}]
[]
[]
[{"$nulls":4},"Data:"]
[]
[{"$nulls":4},"Signatura:"]
[]
[]
[null,"1 Annexau detall sobre el càlcul del cost imputat"]

{"sheet":"CC3-E anvers","index":2,"n_rows":106,"n_cols":50,"rows_kept":106,"merged":[[3,7,3,21],[6,1,6,42],[7,1,7,42],[10,2,10,16],[10,19,10,26],[10,29,10,37],[13,2,13,26],[13,29,13,31],[13,32,13,38],[16,2,16,7],[16,10,16,19],[16,22,16,23],[16,24,16,25],[16,26,16,27],[16,28,16,29],[16,32,16,34],[16,35,16,39],[19,2,19,12],[19,13,19,16],[19,23,19,24],[19,33,19,34],[22,1,25,1],[22,2,22,3],[22,4,22,5],[22,7,25,7],[22,8,22,12],[22,14,25,14],[22,15,22,19],[22,21,25,21],[22,22,22,27],[22,32,22,34],[22,37,22,38],[23,2,23,3],[23,4,23,5],[23,8,23,12],[23,15,23,19],[23,22,23,27],[24,2,24,3],[24,4,24,5],[24,8,24,12],[24,15,24,19],[24,22,24,27],[25,2,25,3],[25,4,25,5],[25,8,25,12],[25,15,25,19],[25,22,25,27],[28,1,31,1],[28,2,28,40],[29,2,29,40],[30,2,30,40],[31,2,31,40],[35,2,35,19],[37,15,37,21],[38,17,38,21],[39,15,39,21],[41,15,41,21],[42,17,42,21],[42,46,42,48],[43,15,43,21],[43,23,43,31],[43,46,43,48],[44,17,44,21],[44,46,44,48],[45,15,45,21],[45,46,45,48],[46,46,46,48],[47,15,47,21],[47,46,47,48],[48,0,52,0],[48,46,48,48],[49,15,49,21],[49,46,49,48],[50,14,50,28],[50,30,50,39],[51,30,51,40],[51,41,51,42],[55,19,55,27],[57,30,57,40],[59,30,59,37],[59,38,59,40],[61,30,61,40],[66,19,66,27],[66,29,66,35],[67,19,67,27],[69,30,69,40],[72,30,72,40],[75,1,75,4],[75,16,75,19],[76,1,76,4],[76,16,76,19],[77,2,77,4],[77,7,77,8],[77,11,77,13],[77,22,77,29],[77,32,77,40],[78,1,79,4],[78,6,79,9],[78,11,79,14],[79,16,79,24],[81,23,82,32],[82,0,89,0],[85,22,85,25],[85,26,85,29],[85,30,85,31],[85,32,85,40],[88,22,88,25],[88,26,88,29],[88,30,88,31],[88,32,88,40],[89,6,89,18],[91,7,92,23],[91,26,91,35],[93,26,93,35],[95,0,98,0],[95,7,96,23],[95,26,95,35],[97,7,97,24],[97,26,97,35],[100,0,101,0],[100,1,100,36],[101,1,101,36],[104,13,104,19],[104,33,104,36]]}
[{"$nulls":38},"ANNEX "]
[{"$nulls":38},"CC3 - E"]
[]
[{"$nulls":7},"DECLARACIÓ DE DESPESES DE L'ACCIÓ FORMATIVA"]
[]
[]
[null,"PROGRAMA DE COMPETÈNCIES CLAU, IMPARTIDES A CENTRES EDUCATIUS PER A PERSONES ADULTES, DURANT EL PERÍODE 2015-2017"]
[null,"(RD 395/2007 de 23 de març, BOE núm. 87 d’11 d’abril de 2007. ORDRE TAS/718/2008 de 7 de març, BOE núm. 67 de 18 de març de 2008)"]
[]
[null,"NOM DEL CENTRE",{"$nulls":16},"NÚM. DE CENS",{"$nulls":9},"CIF/NIF"]
[null,"01",{"$nulls":16},"02",{"$nulls":9},"03"]
[]
["1.","TITULAR JURÍDIC O DENOMINACIÓ",{"$nulls":26},"PREF.",{"$nulls":3},"FAX"]
["IDENTIFICACIÓ","04",{"$nulls":26},"08"]
["DEL CENTRE"]
[null,"CARRER/PLAÇA/AV.",{"$nulls":7},"DOMICILI SOCIAL",{"$nulls":12},"NÚM.",null,"ESC.",null,null,"PIS",null,"PTA.",null,null,"PREF.",{"$nulls":3},"TELÈFON"]
[null,"05",{"$nulls":7},"06",{"$nulls":11},"07",{"$nulls":9},"08"]
[]
[null,"MUNICIPI",{"$nulls":11},"CODI",{"$nulls":5},"PROVÍNCIA",{"$nulls":3},"CODI",{"$nulls":3},"COMUNITAT AUTÒNOMA",{"$nulls":5},"CODI"]
[null,"09",{"$nulls":16},"10","Illes Balears",{"$nulls":3},{"v":7,"d":"07"},null,null,"11","Illes Balears",{"$nulls":5},{"v":4,"d":"04"}]
[]
[null,"CODI. ACCIONS FORMATIVES",{"$nulls":5},"DATA D'INICI",{"$nulls":6},"DATA D'ACABAMENT",{"$nulls":6},"CODI ESPECIALITATS FORMATIVES"]
["2.","12",{"$nulls":5},"13",{"$nulls":6},"14",{"$nulls":6},"15"]
["IDENTIFICACIÓ"]
["DE LES ACCIONS"]
["FORMATIVES"]
[]
[null,"NOM DE LES ESPECIALITATS FORMATIVES"]
[null,"16"]
[]
[]
[]
[]
[]
[]
[null,null,"DESPESES DIRECTES DE L'ACTIVITAT FORMATIVA:"]
[]
[null,null,"Cost docent",{"$nulls":11},"17"]
[]
[null,null,"Cost tutoria",{"$nulls":11},"18"]
[]
[null,null,"amortització d'instal·lacions, equips, aules, tallers…",{"$nulls":11},"19"]
[{"$nulls":23},{"$f":"IF(P43>R44,\"Màx. 10% despeses total del curs\",\"\")","v":""}]
[null,null,"Lloguer d'instal·lacions",{"$nulls":11},"20"]
[]
[null,null,"Materials i mitjans didàctics",{"$nulls":11},"21"]
[]
["3.",null,"Assegurança d'accidents i responsabilitat civil",{"$nulls":11},"22"]
["DESGLOSSAMENT DE LES DESPESES DEL CURS",{"$nulls":29},{"$f":"IF(Q49>0,\"MAXIM 10% de la subvenció\",\"\")","v":""}]
[null,null,"Despeses de publicitat (màxim 1.000 euros)",{"$nulls":11},"23"]
[{"$nulls":14},{"$f":"IF(P50>1000,\"Les despeses de publicitat no poden ser superiors a 1.000 €\",\"\")","v":""}]
[{"$nulls":27},"TOTAL DESPESES DIRECTES DE L'ACTIVITAT FORMATIVA",null,"24",{"$f":"+ROUND(P38+P40+P42+P44+P46+P48+IF(P50>1000,1000,P50),2)","v":0}]
[]
[null,null,"DESPESES ASSOCIADES A L'ACTIVITAT FORMATIVA:"]
[]
[null,null,"Gestió (direcció i coordinació)",{"$nulls":15},"25"]
[{"$nulls":30},"TOTAL DESPESES ASSOCIADES"]
[{"$nulls":30},{"$f":"+ROUND(T56,2)","v":0}]
[]
[{"$nulls":30},{"$f":"IF(AE58>AM60,\"Màx. 10% despeses totals justificades\",\"\")","v":""},{"$nulls":7},{"$f":"IF(AE58>(AE52+AE70)/9,(AE52+AE70)/9,\"\")","v":""},{"$nulls":9},"Gestió","subministraments"]
[{"$nulls":48},{"$f":"+AE62-AX61","v":0},{"$f":"+ROUND(IF(AE58>AE62,IF(T56<AE62,MIN((AE62-T56),(T60)),0),AE58-T56),2)","v":0}]
[{"$nulls":27},"TOTAL DESPESES ASSOCIADES A L'ACTIVITAT FORMATIVA",null,"26",{"$f":"+ROUND(IF(AE58>AM60,AM60,AE58),2)","v":0}]
[]
[]
[null,null,"ALTRES DESPESES"]
[]
[null,null,"Despeses d'auditoria",{"$nulls":15},"27",{"$nulls":10},{"$f":"+IF(T67>AG78*0.03,AG78*0.03,\"\")","v":""}]
[{"$nulls":19},{"$f":"+IF(T67>0.03*AG78,\"L'import de les despeses d'auditoria no pot ser superior al 3% del pressupost aprovat\",\"\")","v":""},{"$nulls":10},"TOTAL ALTRES DESPESES"]
[]
[{"$nulls":27},"TOTAL ALTRES DESPESES",null,"28",{"$f":"+MIN(T67,AD67)","v":0}]
[]
[]
[{"$nulls":6},"TOTAL DESPESES (24+26+28)",{"$nulls":22},"29",{"$f":"+ROUND(AE52+AE62+AE70,2)","v":0}]
[]
[]
[]
["4.","HORES PROGRAMADES",{"$nulls":4},"ALUMNES PROGRAMATS",{"$nulls":3},"MÒDUL",{"$nulls":10},"PRESENCIALS",{"$nulls":10},"PRESSUPOST PROGRAMAT"]
["PRESSUPOST",30,{"$nulls":4},31,{"$nulls":3},32,{"v":4.5,"d":"4.50"},{"$nulls":9},33,{"$f":"C78*L78","v":0},{"$nulls":8},"34",{"$f":"+C78*H78*L78","v":0}]
["PROGRAMAT","HORES TOTALS IMPARTIDES ",{"$nulls":4},"ALUMNES COMPUTABLES"]
[{"$nulls":16},"DATA DARRER PAGAMENT JUSTIFICATIU"]
[]
[]
["(PART D'IMPARTICIÓ TEÒRICA)"]
[]
[{"$nulls":22},"NÚM. C/C CLIENT"]
[{"$nulls":5},"IMPORT A INGRESSAR AL CENTRE COL·ABORADOR (45)"]
[{"$nulls":22},"NÚM. C/C CLIENT "]
[{"$nulls":5},"IMPORT A TORNAR A LA CONSELLERIA (46)",{"$nulls":16},"L' HA D' INDICAR LA CONSELLERIA "]
[]
[]
[]
[{"$nulls":7},"IMPORT PRESSUPOSTAT EN CONCEPTE DE GESTIÓ (DIRECCIÓ I COORDINACIÓ)",{"$nulls":17},"35",{"$f":"0.1*AG78","v":0}]
[]
["5.",{"$nulls":6},"IMPORT PERCEBUT A L'INICI DE L'ACCIÓ (34 - 35)",{"$nulls":17},"36",{"$f":"+ROUND(AG78-AA92,2)","v":0}]
["RESULTATS"]
["(No es tenen en compte els imports corresponents a despeses de direcció i coordinació)",{"$nulls":6},"IMPORT JUSTIFICAT (29-26)",{"$nulls":17},"37",{"$f":"+AE73-AE62","v":0}]
[]
[{"$nulls":7},"RESULTAT (Si la casella 37 té un import superior al de la 36, el resultat és zero; en cas contrari: 37 - 36)",{"$nulls":17},"38",{"$f":"+ROUND(IF(AA96>AA94,0,AA96-AA94),2)","v":0}]
[]
["6."]
["DECLARACIÓ I SIGNATURA DEL REPRESENTANT","El Sr.   /   Sra. ………………………………………………….., com a"]
[null,"representant legal del centre manifesta que totes les dades consignades en aquest document es corresponen amb despeses realitzades efectivament i pagades, relacionades a la relació de justificants de despeses que figuren registrades en els llibres comptables, en comptabilitat separada i que es troben en poder seu."]
[]
[]
[{"$nulls":20},",",null,null,"de",{"$nulls":8},"de"]
[{"$nulls":3},"Segell centre col·laborador",{"$nulls":7},"(Signatura)"]

{"sheet":"Relació class. desp. comp. clau","index":3,"n_rows":38,"n_cols":19,"rows_kept":38,"merged":[[8,11,8,19],[9,12,9,19],[12,18,12,19],[37,18,37,19]]}
{"$rows_empty":7}
[null,"NÚMEROS D'EXPEDIENT:"]
[null,"NOM DEL CENTRE:",{"$nulls":9},"Requisit a revisar"]
[{"$nulls":11},"A","Hi ha document de despesa?"]
[null,"RELACIÓ DE JUSTIFICANTS DE DESPESES DE L'ELABORACIÓ I CORRECCIÓ DE COMPETÈNCIES CLAU",{"$nulls":9},"E","Hi ha comprovació del pagament objectiu de la despesa?"]
[{"$nulls":11},"F","Hi ha segell de finançament del SOIB / cofinançament del FSE?"]
[null,"NÚM. D'ORDRE","DATA FRA. ","NÚM. FRA./NÒMINA","PERCEPTOR","CIF/NIF","CONCEPTE","DATA PAGAMENT","IMPORT TOTAL","IMPORT IMPUTAT","IMPORT ELEGIBLE","A","B","C","D","E","F","G","Observacions"]
{"$rows_empty":24}
[null,"TOTAL DESPESES CORRESPONENTS A L'ELABORACIÓ I CORRECCIÓ DE COMPETÈNCIES CLAU (2)",{"$nulls":7},{"$f":"+SUM(J14:J37)","v":0},{"$f":"+SUM(K14:K37)","v":0}]

{"sheet":"CC3-E comp. clau","index":4,"n_rows":50,"n_cols":39,"rows_kept":50,"merged":[[3,7,3,36],[6,1,6,42],[7,1,7,42],[10,2,10,16],[10,19,10,26],[10,29,10,37],[13,2,13,26],[13,29,13,31],[13,32,13,38],[16,2,16,7],[16,10,16,19],[16,22,16,23],[16,24,16,25],[16,26,16,27],[16,28,16,29],[16,32,16,34],[16,35,16,39],[19,2,19,12],[19,13,19,16],[19,23,19,24],[19,33,19,34],[22,1,25,1],[22,2,22,7],[22,32,22,34],[22,37,22,38],[23,2,23,7],[24,2,24,7],[25,2,25,7],[28,1,31,1],[28,2,28,40],[29,2,29,40],[30,2,30,40],[31,2,31,40],[33,0,37,0],[35,15,35,21],[38,0,42,0],[39,7,40,23],[39,26,39,35],[41,7,41,24],[41,26,41,35],[44,0,45,0],[44,1,44,36],[45,1,45,36],[48,13,48,19],[48,33,48,36]]}
[{"$nulls":38},"ANNEX "]
[{"$nulls":38},"CC3 - E"]
[]
[{"$nulls":7},"DECLARACIÓ DE DESPESES DE L'ELABORACIÓ I CORRECCIÓ DE PROVES DE COMPETÈNCIES CLAU"]
[]
[]
[null,"PROVES DE COMPETÈNCIES CLAU, REALITZADES A CENTRES EDUCATIUS PER A PERSONES ADULTES, DURANT EL PERÍODE 2015-2017"]
[null,"(RD 395/2007 de 23 de març, BOE núm. 87 d’11 d’abril de 2007. ORDRE TAS/718/2008 de 7 de març, BOE núm. 67 de 18 de març de 2008)"]
[]
[null,"NOM DEL CENTRE",{"$nulls":16},"NÚM. DE CENS",{"$nulls":9},"CIF/NIF"]
[null,"01",{"$nulls":16},"02",{"$nulls":9},"03"]
[]
["1.","TITULAR JURÍDIC O DENOMINACIÓ",{"$nulls":26},"PREF.",{"$nulls":3},"FAX"]
["IDENTIFICACIÓ","04",{"$nulls":26},"08"]
["DEL CENTRE"]
[null,"CARRER/PLAÇA/AV.",{"$nulls":7},"DOMICILI SOCIAL",{"$nulls":12},"NÚM.",null,"ESC.",null,null,"PIS",null,"PTA.",null,null,"PREF.",{"$nulls":3},"TELÈFON"]
[null,"05",{"$nulls":7},"06",{"$nulls":11},"07",{"$nulls":9},"08"]
[]
[null,"MUNICIPI",{"$nulls":11},"CODI",{"$nulls":5},"PROVÍNCIA",{"$nulls":3},"CODI",{"$nulls":3},"COMUNITAT AUTÒNOMA",{"$nulls":5},"CODI"]
[null,"09",{"$nulls":16},"10","Illes Balears",{"$nulls":3},{"v":7,"d":"07"},null,null,"11","Illes Balears",{"$nulls":5},{"v":4,"d":"04"}]
[]
[null,"CODI DE LES PROVES DE COMPETÈNCIES CLAU"]
["2.","12"]
["IDENTIFICACIÓ"]
["DE LES PROVES"]
[]
[]
[null,"NOM DE LES PROVES DE COMPETÈNCIES CLAU"]
[null,"13"]
[]
[]
[]
[]
["3. DESPESES JUSTIFICADES EN CONCEPTE DE PROVES DE COMPETÈNCIES CLAU"]
[]
[null,null,"Elaboració i correcció de proves de competències clau",{"$nulls":11},"14"]
[]
[]
["4. RESULTATS\n"]
["4.",{"$nulls":6},"IMPORT PRESSUPOSTAT EN CONCEPTE D'ELABORACIÓ I CORRECCIÓ DE LES PROVES DE COMPETÈNCIES CLAU",{"$nulls":17},"15"]
["Resultats"]
[{"$nulls":7},"RESULTAT (Si la casella 14 té un import superior al de la 15, el resultat és zero; en cas contrari: 14 - 15)",{"$nulls":17},"16",{"$f":"+ROUND(IF(P36>AA40,0,P36-AA40),2)","v":0}]
[]
["5."]
["DECLARACIÓ I SIGNATURA DEL REPRESENTANT","El Sr.   /   Sra. ………………………………………………….., com a"]
[null,"representant legal del centre manifesta que totes les dades consignades en aquest document es corresponen amb despeses realitzades efectivament i pagades, relacionades a la relació de justificants de despeses que figuren registrades en els llibres comptables, en comptabilitat separada i que es troben en poder seu."]
[]
[]
[{"$nulls":20},",",null,null,"de",{"$nulls":8},"de"]
[{"$nulls":3},"Segell centre col·laborador",{"$nulls":7},"(Signatura)"]

{"sheet":"Criteris imputació proves comp.","index":5,"n_rows":82,"n_cols":9,"rows_kept":82,"merged":[[0,1,1,7],[12,0,16,0],[12,7,12,8],[13,6,16,6],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[19,0,40,0],[19,7,19,8],[20,6,40,6],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[39,7,39,8],[40,7,40,8],[43,0,75,0],[43,7,43,8],[44,6,75,6],[44,7,44,8],[45,7,45,8],[46,7,46,8],[47,7,47,8],[48,7,48,8],[49,7,49,8],[50,7,50,8],[51,7,51,8],[52,7,52,8],[53,7,53,8],[54,7,54,8],[55,7,55,8],[56,7,56,8],[57,7,57,8],[58,7,58,8],[59,7,59,8],[60,7,60,8],[61,7,61,8],[62,7,62,8],[63,7,63,8],[64,7,64,8],[65,7,65,8],[66,7,66,8],[67,7,67,8],[68,7,68,8],[69,7,69,8],[70,7,70,8],[71,7,71,8],[72,7,72,8],[73,7,73,8],[74,7,74,8],[75,7,75,8],[77,0,81,2]]}
[null,"Criteris d'imputació de la despesa corresponent a l'elaboració, execució i correcció de les proves de competències clau"]
[]
[{"$nulls":4},"Castellà"]
[{"$nulls":4},"Català"]
[{"$nulls":4},"Matemàtiques"]
[{"$nulls":4},"Llengua estrangera"]
[]
[]
[]
[]
[]
[]
["Costos dels experts en l'elaboració de les proves","Número de factura/rebut","Nom del docent","Convocatòria número","Tipus de prova","Número de proves elaborades","Import unitari","Totals"]
[{"$nulls":6},{"v":250,"d":"250.00 €"},{"$f":"+F14*$G$14","v":0}]
[{"$nulls":7},{"$f":"+F15*$G$14","v":0}]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},"Total",{"$f":"+SUM(H14:I17)","v":0}]
[]
["Costos del personal docent per a l'execució","Número de factura/rebut","Nom del docent","Convocatòria número","Tipus de prova","Número d'hores que ha durat la realització (1)","Import unitari","Totals"]
[{"$nulls":5},{"$f":"+IF(E21=\"\",\"\",IF(E21=\"Matemàtiques\",1.5,3))","v":""},{"v":35,"d":"35.00 €"},{"$f":"+IF(F21=\"\",\"\",F21*$G$21)","v":""}]
[{"$nulls":5},{"$f":"+IF(E22=\"\",\"\",IF(E22=\"Matemàtiques\",1.5,3))","v":""},null,{"$f":"+IF(F22=\"\",\"\",F22*$G$21)","v":""}]
[{"$nulls":5},"",null,{"$f":"+IF(F23=\"\",\"\",F23*$G$21)","v":""}]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":5},"",null,""]
[{"$nulls":7},"Total",{"$f":"+SUM(H21:I41)","v":0}]
[]
["Costos del personal docent per a la correcció","Número de factura/rebut","Nom del docent","Convocatòria número","Tipus de prova","Número d'alumnes","Import unitari","Totals"]
[{"$nulls":6},{"v":3,"d":"3.00 €"},{"$f":"+F45*$G$45","v":0}]
[{"$nulls":7},{"$f":"+F46*$G$45","v":0}]
[{"$nulls":7},{"$f":"+F47*$G$45","v":0}]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},"Total",{"$f":"+SUM(H45:I76)","v":0}]
["(1) D'acord amb la resolució, la durada de les hores de les proves de competències clau és la següent:\n-Matemàtiques: 1,50 hores.\n-Llengua castellana: 3 hores.\n-Llengua catalana: 3 hores.\n-Llengua estrangera: 3 hores.",{"$nulls":3},"[Lloc i data]"]
[{"$nulls":4},"[Nom del representant del centre]",null,null,"Total",{"$f":"+I77+I42+I18","v":0}]
[]
[]
[{"$nulls":4},"[Signatura] [Segell]"]