{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Relació de despeses","Relació d'ingressos ","Relació de despeses i ingressos","Full1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":6,"comments":3,"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":"Relació de despeses","index":0,"n_rows":179,"n_cols":12,"rows_kept":179,"cut":false,"hidden":false,"merged":[[3,0,3,1],[68,11,68,12],[0,0,0,12],[4,0,4,1],[2,2,2,3],[3,2,3,3],[4,2,4,3],[11,11,11,12],[2,0,2,1],[49,11,49,12],[2,4,2,6],[3,4,3,6],[4,4,4,6],[48,11,48,12],[47,11,47,12],[46,11,46,12],[45,11,45,12],[7,2,8,2],[12,11,12,12],[2,9,2,10],[3,9,3,10],[4,9,4,10],[26,0,26,8],[35,0,35,8],[52,11,52,12],[36,0,36,12],[43,0,43,12],[16,11,16,12],[15,11,15,12],[14,11,14,12],[26,11,26,12],[44,11,44,12],[42,11,42,12],[41,11,41,12],[40,11,40,12],[39,11,39,12],[38,11,38,12],[31,11,31,12],[30,11,30,12],[6,0,6,4],[86,11,86,12],[65,11,65,12],[76,11,76,12],[75,11,75,12],[66,11,66,12],[51,11,51,12],[63,11,63,12],[62,11,62,12],[61,11,61,12],[60,11,60,12],[59,11,59,12],[58,11,58,12],[56,11,56,12],[55,11,55,12],[80,11,80,12],[81,11,81,12],[27,0,27,12],[35,11,35,12],[34,11,34,12],[32,11,32,12],[49,0,49,8],[67,11,67,12],[83,11,83,12],[7,11,7,12],[8,11,8,12],[10,0,10,12],[25,11,25,12],[71,0,71,12],[57,0,57,12],[29,11,29,12],[28,11,28,12],[7,3,7,4],[64,0,64,12],[7,1,8,1],[7,0,8,0],[70,11,70,12],[69,11,69,12],[9,0,9,10],[56,0,56,8],[63,0,63,8],[70,0,70,8],[42,0,42,8],[50,0,50,12],[37,11,37,12],[13,11,13,12],[54,11,54,12],[53,11,53,12],[105,11,105,12],[106,0,106,8],[106,11,106,12],[178,0,178,12],[176,0,176,12],[174,0,174,12],[175,0,175,12],[172,0,172,12],[165,0,165,12],[166,0,166,12],[169,1,169,3],[169,5,169,12],[107,0,107,12],[108,11,108,12],[109,11,109,12],[110,11,110,12],[111,11,111,12],[112,11,112,12],[113,0,113,8],[113,11,113,12],[114,0,114,12],[115,11,115,12],[116,11,116,12],[117,11,117,12],[81,0,81,8],[86,0,86,8],[84,11,84,12],[104,11,104,12],[74,11,74,12],[73,11,73,12],[82,0,82,12],[77,0,77,12],[85,11,85,12],[78,11,78,12],[87,0,87,2],[87,3,87,8],[87,11,87,12],[88,0,88,10],[89,0,89,12],[90,11,90,12],[79,11,79,12],[76,0,76,8],[118,11,118,12],[119,0,119,8],[119,11,119,12],[120,0,120,12],[121,11,121,12],[122,11,122,12],[123,11,123,12],[124,11,124,12],[125,0,125,8],[125,11,125,12],[126,0,126,12],[127,11,127,12],[128,11,128,12],[129,11,129,12],[130,11,130,12],[131,0,131,8],[131,11,131,12],[132,0,132,12],[133,11,133,12],[134,11,134,12],[135,11,135,12],[136,11,136,12],[137,0,137,8],[137,11,137,12],[138,0,138,12],[139,11,139,12],[140,11,140,12],[141,11,141,12],[142,11,142,12],[143,0,143,8],[143,11,143,12],[144,0,144,12],[145,11,145,12],[146,11,146,12],[147,11,147,12],[148,11,148,12],[149,0,149,8],[149,11,149,12],[150,0,150,12],[151,11,151,12],[152,11,152,12],[153,11,153,12],[162,0,162,2],[162,3,162,8],[162,11,162,12],[163,0,163,5],[163,6,163,8],[163,11,163,12],[154,11,154,12],[155,0,155,8],[155,11,155,12],[156,0,156,12],[157,11,157,12],[158,11,158,12],[159,11,159,12],[160,11,160,12],[161,0,161,8],[161,11,161,12]]}
["Relació classificada de totes les despeses realitzades per a l'execució de l'activitat  subvencionada"]
[]
["Persona física/jurídica beneficiària:         ",null,null,null,"Import total del projecte:",null,null,null,null,null,null,"euros"]
["Codi de subvenció:",null,null,null,"Import de la subvenció atorgada:",null,null,null,null,null,null,"euros"]
["Nom del projecte subvencionat:",null,null,null,"Període d'execució del projecte subvencionat:",null,null,null,null,null,null,"a"]
[]
["Despeses del projecte/activitat/servei subvencionat (*)"]
["núm. d'ordre (0)","número de document: justificants despesa personal (1), factura o rebut/tiquet(2)","Concepte de la factura / \ndocument probatori equivalent","Emissor de la factura",null,"data d'emissió","Import total de la factura","Percentatge d'iva deduït o el de després d'aplicar la Prorrata","Import després de deduïr l'IVA corresponent","Import imputable (dedicat) al projecte (3)","Import imputable a la subvenció municipal (4)","Observacions"]
[null,null,null,"NIF","Nom","dd/mm/aaaa","euros","%","euros","euros","euros","(2)"]
["DESPESES DIRECTES (Aquelles que s'identifiquen directament amb el projecte)"]
["A. Retribucions del personal vinculat íntegrament al projecte i Seguretat Social del personal vinculat íntegrament al projecte."]
[{"$f":"IF(B12<>\"\",1,\"\")","v":""}]
[{"$f":"IF(B13<>\"\",MAX($A$12:A12)+1,\"\")","v":""}]
[{"$f":"IF(B14<>\"\",MAX($A$12:A13)+1,\"\")","v":""}]
[{"$f":"IF(B15<>\"\",MAX($A$12:A14)+1,\"\")","v":""}]
[{"$f":"IF(B16<>\"\",MAX($A$12:A15)+1,\"\")","v":""}]
[{"$f":"IF(B17<>\"\",MAX($A$12:A16)+1,\"\")","v":""}]
[{"$f":"IF(B18<>\"\",MAX($A$12:A17)+1,\"\")","v":""}]
[{"$f":"IF(B19<>\"\",MAX($A$12:A18)+1,\"\")","v":""}]
[{"$f":"IF(B20<>\"\",MAX($A$12:A19)+1,\"\")","v":""}]
[{"$f":"IF(B21<>\"\",MAX($A$12:A20)+1,\"\")","v":""}]
[{"$f":"IF(B22<>\"\",MAX($A$12:A21)+1,\"\")","v":""}]
[{"$f":"IF(B23<>\"\",MAX($A$12:A22)+1,\"\")","v":""}]
[{"$f":"IF(B24<>\"\",MAX($A$12:A23)+1,\"\")","v":""}]
[{"$f":"IF(B25<>\"\",MAX($A$12:A24)+1,\"\")","v":""}]
[{"$f":"IF(B26<>\"\",MAX($A$12:A25)+1,\"\")","v":""}]
["Subtotal A",null,null,null,null,null,null,null,null,{"$f":"SUM(J12:J26)","v":0},{"$f":"SUM(K12:K26)","v":0}]
["B. Lloguers de bens mobles/immobles directament vinculats al projecte."]
[{"$f":"IF(B29<>\"\",MAX($A$12:A28)+1,\"\")","v":""}]
[{"$f":"IF(B30<>\"\",MAX($A$28:A29)+1,\"\")","v":""}]
[{"$f":"IF(B31<>\"\",MAX($A$28:A30)+1,\"\")","v":""}]
[{"$f":"IF(B32<>\"\",MAX($A$28:A31)+1,\"\")","v":""}]
[{"$f":"IF(B33<>\"\",MAX($A$28:A32)+1,\"\")","v":""}]
[{"$f":"IF(B34<>\"\",MAX($A$28:A33)+1,\"\")","v":""}]
[{"$f":"IF(B35<>\"\",MAX($A$28:A34)+1,\"\")","v":""}]
["Subtotal B",null,null,null,null,null,null,null,null,{"$f":"SUM(J29:J35)","v":0},{"$f":"SUM(K29:K35)","v":0}]
["C. Adquisició de materials i bens consumibles íntegrament imputables al projecte."]
[{"$f":"IF(B38<>\"\",MAX($A$12:A37)+1,\"\")","v":""}]
[{"$f":"IF(B39<>\"\",MAX($A$28:A38)+1,\"\")","v":""}]
[{"$f":"IF(B40<>\"\",MAX($A$28:A39)+1,\"\")","v":""}]
[{"$f":"IF(B41<>\"\",MAX($A$28:A40)+1,\"\")","v":""}]
[{"$f":"IF(B42<>\"\",MAX($A$28:A41)+1,\"\")","v":""}]
["Subtotal C",null,null,null,null,null,null,null,null,{"$f":"SUM(J38:J42)","v":0},{"$f":"SUM(K38:K42)","v":0}]
["D. Transport - Missatgeria"]
[{"$f":"IF(B45<>\"\",MAX($A$12:A44)+1,\"\")","v":""}]
[{"$f":"IF(B46<>\"\",MAX($A$28:A45)+1,\"\")","v":""}]
[{"$f":"IF(B47<>\"\",MAX($A$28:A46)+1,\"\")","v":""}]
[{"$f":"IF(B48<>\"\",MAX($A$28:A47)+1,\"\")","v":""}]
[{"$f":"IF(B49<>\"\",MAX($A$28:A48)+1,\"\")","v":""}]
["Subtotal D",null,null,null,null,null,null,null,null,{"$f":"SUM(J45:J49)","v":0},{"$f":"SUM(K45:K49)","v":0}]
["E. Publicitat i propaganda"]
[{"$f":"IF(B52<>\"\",MAX($A$12:A51)+1,\"\")","v":""}]
[{"$f":"IF(B53<>\"\",MAX($A$28:A52)+1,\"\")","v":""}]
[{"$f":"IF(B54<>\"\",MAX($A$28:A53)+1,\"\")","v":""}]
[{"$f":"IF(B55<>\"\",MAX($A$28:A54)+1,\"\")","v":""}]
[{"$f":"IF(B56<>\"\",MAX($A$28:A55)+1,\"\")","v":""}]
["Subtotal E",null,null,null,null,null,null,null,null,{"$f":"SUM(J52:J56)","v":0},{"$f":"SUM(K52:K56)","v":0}]
["F. Assegurances"]
[{"$f":"IF(B59<>\"\",MAX($A$12:A58)+1,\"\")","v":""}]
[{"$f":"IF(B60<>\"\",MAX($A$28:A59)+1,\"\")","v":""}]
[{"$f":"IF(B61<>\"\",MAX($A$28:A60)+1,\"\")","v":""}]
[{"$f":"IF(B62<>\"\",MAX($A$28:A61)+1,\"\")","v":""}]
[{"$f":"IF(B63<>\"\",MAX($A$28:A62)+1,\"\")","v":""}]
["Subtotal F",null,null,null,null,null,null,null,null,{"$f":"SUM(J59:J63)","v":0},{"$f":"SUM(K59:K63)","v":0}]
["G. Allotjament i dietes"]
[{"$f":"IF(B66<>\"\",MAX($A$12:A65)+1,\"\")","v":""}]
[{"$f":"IF(B67<>\"\",MAX($A$28:A66)+1,\"\")","v":""}]
[{"$f":"IF(B68<>\"\",MAX($A$28:A67)+1,\"\")","v":""}]
[{"$f":"IF(B69<>\"\",MAX($A$28:A68)+1,\"\")","v":""}]
[{"$f":"IF(B70<>\"\",MAX($A$28:A69)+1,\"\")","v":""}]
["Subtotal G",null,null,null,null,null,null,null,null,{"$f":"SUM(J66:J70)","v":0},{"$f":"SUM(K66:K70)","v":0}]
["H. Viatges i desplaçaments"]
[{"$f":"IF(B73<>\"\",MAX($A$12:A72)+1,\"\")","v":""}]
[{"$f":"IF(B74<>\"\",MAX($A$28:A73)+1,\"\")","v":""}]
[{"$f":"IF(B75<>\"\",MAX($A$28:A74)+1,\"\")","v":""}]
[{"$f":"IF(B76<>\"\",MAX($A$28:A75)+1,\"\")","v":""}]
["Subtotal H",null,null,null,null,null,null,null,null,{"$f":"SUM(J73:J76)","v":0},{"$f":"SUM(K73:K76)","v":0}]
["I. Treballs realitzats per empreses externes (neteja, seguretat, altres treballs directament relacionats amb l'activitat i/o projecte)"]
[{"$f":"IF(B79<>\"\",MAX($A$12:A78)+1,\"\")","v":""}]
[{"$f":"IF(B80<>\"\",MAX($A$28:A79)+1,\"\")","v":""}]
[{"$f":"IF(B81<>\"\",MAX($A$28:A80)+1,\"\")","v":""}]
["Subtotal I",null,null,null,null,null,null,null,null,{"$f":"SUM(J79:J81)","v":0},{"$f":"SUM(K79:K81)","v":0}]
["J. Altres despeses (no incloses en els apartats anteriors)"]
[{"$f":"IF(B84<>\"\",MAX($A$12:A83)+1,\"\")","v":""}]
[{"$f":"IF(B85<>\"\",MAX($A$28:A84)+1,\"\")","v":""}]
[{"$f":"IF(B86<>\"\",MAX($A$28:A85)+1,\"\")","v":""}]
["Subtotal J",null,null,null,null,null,null,null,null,{"$f":"SUM(J84:J86)","v":0},{"$f":"SUM(K84:K86)","v":0}]
["TOTAL DESPESES DIRECTES ",null,null,"TOTAL DESPESES DIRECTES",null,null,null,null,null,{"$f":"+J27+J36+J43+J50+J57+J64+J71+J77+J82+J87","v":0},{"$f":"+K27+K36+K43+K50+K57+K64+K71+K77+K82+K87","v":0}]
["DESPESES INDIRECTES (no es poden assignar directament al projecte sense fer servir algun % d'assignació)"]
["A. Personal de suport al projecte"]
[{"$f":"IF(B91<>\"\",MAX($A$11:A90)+1,\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(B105<>\"\",MAX($A$28:A91)+1,\"\")","v":""}]
[{"$f":"IF(B106<>\"\",MAX($A$28:A105)+1,\"\")","v":""}]
["Subtotal A",null,null,null,null,null,null,null,null,{"$f":"SUM(J91:J106)","v":0},{"$f":"SUM(K91:K106)","v":0}]
["B. Amortització"]
[{"$f":"IF(B109<>\"\",MAX($A$11:A108)+1,\"\")","v":""}]
[{"$f":"IF(B110<>\"\",MAX($A$28:A109)+1,\"\")","v":""}]
[{"$f":"IF(B111<>\"\",MAX($A$28:A110)+1,\"\")","v":""}]
[{"$f":"IF(B112<>\"\",MAX($A$28:A111)+1,\"\")","v":""}]
[{"$f":"IF(B113<>\"\",MAX($A$28:A112)+1,\"\")","v":""}]
["Subtotal B",null,null,null,null,null,null,null,null,{"$f":"SUM(J109:J113)","v":0},{"$f":"SUM(K109:K113)","v":0}]
["C. Lloguer de bens inmobles (locals)"]
[{"$f":"IF(B116<>\"\",MAX($A$11:A115)+1,\"\")","v":""}]
[{"$f":"IF(B117<>\"\",MAX($A$28:A116)+1,\"\")","v":""}]
[{"$f":"IF(B118<>\"\",MAX($A$28:A117)+1,\"\")","v":""}]
[{"$f":"IF(B119<>\"\",MAX($A$28:A118)+1,\"\")","v":""}]
["Subtotal C",null,null,null,null,null,null,null,null,{"$f":"SUM(J116:J119)","v":0},{"$f":"SUM(K116:K119)","v":0}]
["D. Adquisició de materials i bens consumibles parcialment imputades al projecte"]
[{"$f":"IF(B122<>\"\",MAX($A$11:A121)+1,\"\")","v":""}]
[{"$f":"IF(B123<>\"\",MAX($A$28:A122)+1,\"\")","v":""}]
[{"$f":"IF(B124<>\"\",MAX($A$28:A123)+1,\"\")","v":""}]
[{"$f":"IF(B125<>\"\",MAX($A$28:A124)+1,\"\")","v":""}]
["Subtotal D",null,null,null,null,null,null,null,null,{"$f":"SUM(J122:J125)","v":0},{"$f":"SUM(K122:K125)","v":0}]
["E. Manteniment d'edificis i/o instal·lacions"]
[{"$f":"IF(B128<>\"\",MAX($A$11:A127)+1,\"\")","v":""}]
[{"$f":"IF(B129<>\"\",MAX($A$28:A128)+1,\"\")","v":""}]
[{"$f":"IF(B130<>\"\",MAX($A$28:A129)+1,\"\")","v":""}]
[{"$f":"IF(B131<>\"\",MAX($A$28:A130)+1,\"\")","v":""}]
["Subtotal E",null,null,null,null,null,null,null,null,{"$f":"SUM(J128:J131)","v":0},{"$f":"SUM(K128:K131)","v":0}]
["F. Comunicacions (telèfon, correu, connexió a internet...)"]
[{"$f":"IF(B134<>\"\",MAX($A$11:A133)+1,\"\")","v":""}]
[{"$f":"IF(B135<>\"\",MAX($A$28:A134)+1,\"\")","v":""}]
[{"$f":"IF(B136<>\"\",MAX($A$28:A135)+1,\"\")","v":""}]
[{"$f":"IF(B137<>\"\",MAX($A$28:A136)+1,\"\")","v":""}]
["Subtotal F",null,null,null,null,null,null,null,null,{"$f":"SUM(J134:J137)","v":0},{"$f":"SUM(K134:K137)","v":0}]
["G. Despeses financeres"]
[{"$f":"IF(B140<>\"\",MAX($A$11:A139)+1,\"\")","v":""}]
[{"$f":"IF(B141<>\"\",MAX($A$28:A140)+1,\"\")","v":""}]
[{"$f":"IF(B142<>\"\",MAX($A$28:A141)+1,\"\")","v":""}]
[{"$f":"IF(B143<>\"\",MAX($A$28:A142)+1,\"\")","v":""}]
["Subtotal G",null,null,null,null,null,null,null,null,{"$f":"SUM(J140:J143)","v":0},{"$f":"SUM(K140:K143)","v":0}]
["H. Subministraments"]
[{"$f":"IF(B146<>\"\",MAX($A$11:A145)+1,\"\")","v":""}]
[{"$f":"IF(B147<>\"\",MAX($A$28:A146)+1,\"\")","v":""}]
[{"$f":"IF(B148<>\"\",MAX($A$28:A147)+1,\"\")","v":""}]
[{"$f":"IF(B149<>\"\",MAX($A$28:A148)+1,\"\")","v":""}]
["Subtotal H",null,null,null,null,null,null,null,null,{"$f":"SUM(J146:J149)","v":0},{"$f":"SUM(K146:K149)","v":0}]
["I. Treballs realitzats per empreses externes (neteja, seguretat, manteniment, parcialment imputables al projecte)"]
[{"$f":"IF(B152<>\"\",MAX($A$11:A151)+1,\"\")","v":""}]
[{"$f":"IF(B153<>\"\",MAX($A$28:A152)+1,\"\")","v":""}]
[{"$f":"IF(B154<>\"\",MAX($A$28:A153)+1,\"\")","v":""}]
[{"$f":"IF(B155<>\"\",MAX($A$28:A154)+1,\"\")","v":""}]
["Subtotal I",null,null,null,null,null,null,null,null,{"$f":"SUM(J152:J155)","v":0},{"$f":"SUM(K152:K155)","v":0}]
["J. Altres despeses (no incloses en els apartats anteriors)"]
[{"$f":"IF(B158<>\"\",MAX($A$11:A157)+1,\"\")","v":""}]
[{"$f":"IF(B159<>\"\",MAX($A$28:A158)+1,\"\")","v":""}]
[{"$f":"IF(B160<>\"\",MAX($A$28:A159)+1,\"\")","v":""}]
[{"$f":"IF(B161<>\"\",MAX($A$28:A160)+1,\"\")","v":""}]
["Subtotal J",null,null,null,null,null,null,null,null,{"$f":"SUM(J158:J161)","v":0},{"$f":"SUM(K158:K161)","v":0}]
["TOTAL DESPESES INDIRECTES ",null,null,"TOTAL DESPESES INDIRECTES",null,null,null,null,null,{"$f":"+J107+J114+J120+J126+J132+J138+J144+J150+J156+J162","v":0},{"$f":"+K107+K114+K120+K126+K132+K138+K144+K150+K156+K162","v":0}]
["TOTAL DESPESES",null,null,null,null,null,"TOTAL",null,null,{"$f":"+J163+J88","v":0},{"$f":"+K163+K88","v":0}]
[]
["El Sr./Sra. (indicar el nom i cognoms de la persona representant que signa la justificació)  amb DNI/NIE (indicar el núm. DNI) en qualitat de persona física beneficiària o representant legal de la persona jurídica beneficiària (indicar nom i cognoms) amb NIF (indicar núm DNI)."]
["CERTIFICA que els rebuts/tiquets que s'han identificat com a tals en el camp d'observacions corresponen a despeses generades per l'esmentada activitat, que pels seus imports i característiques no han pogut ser objecte de factura; que els justificants relacionats imputats al projecte/activitat/servei subvencionat durant el seu període d'execució han estat efectivament pagats; que custodiarà la documentació suport que ho acredita; que aquesta documentació es troba a disposició de l'Ajuntament de Barcelona o dels altres ens municipals en els arxius d'aquesta Entitat, durant un període mínim de 4 anys a comptar des de la data de presentació de la present justificació."]
[]
[]
[null,"Població i data: ",null,null,null,"Signatura i segell"]
[]
["Notes:"]
["(*) S'han de relacionar totes les despeses del projecte/activitat/servei subvencionat. En el cas que el nombre de files de cada concepte sigui insuficient podeu inserir línies dins del mateix concepte seleccionant una cel·la verda i fent clic sobre el botó d'inserir línia."]
["(0) El número d'ordre ha de ser correlatiu començant per 1"]
["(1) Respecte a les despeses de recursos humans, pot ser subvencionable el cost total salarial mensual, que correspon a la suma de la retribució bruta que apareix a la nòmina del treballador/a més la quota de l'empresa a la Seg. Social. Les despeses de personal es justifiquen amb la nòmina del treballador acompanyada dels corresponents TC1 i TC2 de la TGSS i el model 111 de l'IRPF."]
["(2) En el cas que el document justificatiu de la resta de despeses, no sigui una factura, sinó un altre document probatori equivalent, com un rebut o justificant (com per dietes o transport públic), indiqueu-lo en el camp d'observacions."]
["(3) En el cas que un justificant inclogui conceptes que no tenen a veure amb el projecte/activitat/servei per al qual s'ha atorgat la subvenció, aquí només s'ha d'indicar la part que realment s'ha dedicat al projecte."]
[]
["(4) En aquesta columna s'ha d'indicar l'import total o parcial de la factura  que s'imputa a la subvenció rebuda de l'Ajuntament de Barcelona/IBE/ICUB/IMD. El total imputat, en aquesta columna, ha de ser igual  a l'import de la subvenció rebuda."]

{"sheet":"Relació d'ingressos ","index":1,"n_rows":96,"n_cols":10,"rows_kept":96,"cut":false,"hidden":false,"merged":[[80,6,80,9],[76,6,76,9],[74,6,74,9],[71,6,71,9],[82,6,82,9],[82,0,82,3],[81,0,81,3],[84,0,84,9],[85,0,86,9],[81,6,81,9],[62,0,62,9],[69,0,69,9],[58,6,58,9],[68,6,68,9],[70,6,70,9],[68,0,68,3],[61,0,61,3],[59,6,59,9],[67,6,67,9],[65,6,65,9],[64,6,64,9],[63,6,63,9],[41,6,41,9],[40,6,40,9],[53,6,53,9],[52,6,52,9],[51,6,51,9],[49,6,49,9],[48,6,48,9],[47,6,47,9],[46,6,46,9],[22,6,22,9],[21,6,21,9],[20,6,20,9],[19,6,19,9],[18,6,18,9],[0,0,0,9],[9,0,9,9],[17,0,17,9],[24,0,24,9],[7,6,8,9],[10,6,10,9],[11,6,11,9],[7,0,8,0],[12,6,12,9],[15,6,15,9],[3,2,3,3],[2,2,2,3],[6,0,6,3],[4,2,4,3],[7,2,7,3],[7,1,8,1],[16,0,16,3],[53,0,53,3],[31,0,31,9],[39,0,39,9],[45,0,45,9],[44,0,44,3],[38,0,38,3],[16,6,16,9],[23,6,23,9],[33,6,33,9],[32,6,32,9],[44,6,44,9],[43,6,43,9],[34,6,34,9],[38,6,38,9],[37,6,37,9],[57,6,57,9],[30,0,30,3],[61,6,61,9],[60,6,60,9],[23,0,23,3],[54,0,54,9],[56,6,56,9],[55,6,55,9],[36,6,36,9],[35,6,35,9],[30,6,30,9],[29,6,29,9],[27,6,27,9],[26,6,26,9],[25,6,25,9],[42,6,42,9]]}
["Detall de tots els ingressos obtinguts i aportacions del propi beneficiari per a l'execució de l'activitat subvencionada"]
[]
[null,"Nom de la persona física/jurídica beneficiària:        ",{"$f":"IF('Relació de despeses'!C3:D3<>\"\",'Relació de despeses'!C3:D3,\"\")","v":""},null,"Import total del projecte :",null,null,{"$f":"IF(+'Relació de despeses'!J3=\"\",\"\",+'Relació de despeses'!J3)","v":""},"euros"]
[null,"Codi de subvenció",{"$f":"IF('Relació de despeses'!C4:D4<>\"\",'Relació de despeses'!C4:D4,\"\")","v":""},null,"Import de la subvenció atorgada:",null,null,{"$f":"IF(+'Relació de despeses'!J4=\"\",\"\",+'Relació de despeses'!J4)","v":""},"euros"]
[null,"Nom del projecte subvencionat",{"$f":"IF('Relació de despeses'!C5:D5<>\"\",'Relació de despeses'!C5:D5,\"\")","v":""},null,"Període d'execució del projecte subvencionat:",null,null,{"$f":"IF(+'Relació de despeses'!J5=\"\",\"\",+'Relació de despeses'!J5)","v":""},"a",{"$f":"IF(+'Relació de despeses'!M5=\"\",\"\",+'Relació de despeses'!M5)","v":""}]
[]
["Ingressos del projecte/activitat/servei subvencionat"]
["núm. d'ordre (0)","Concepte de l'ingrés","Emissor de l'ingrés",null,"Data de cobrament\n(dd/mm/aaaa)","Import","Observacions"]
[null,null,"NIF","Nom","(2)","euros"]
["A. Subvenció municipal "]
[{"$f":"IF(B11<>\"\",1,\"\")","v":""}]
[]
[]
[]
[{"$f":"IF(B15<>\"\",MAX($A$10:A14)+1,\"\")","v":""}]
[{"$f":"IF(B16<>\"\",MAX($A$10:A15)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal A",{"$f":"SUM(F11:F16)","v":0}]
["B. Subvencions d'altres administracions"]
[{"$f":"IF(B19<>\"\",MAX($A$10:A18)+1,\"\")","v":""}]
[{"$f":"IF(B20<>\"\",MAX($A$10:A19)+1,\"\")","v":""}]
[{"$f":"IF(B21<>\"\",MAX($A$10:A20)+1,\"\")","v":""}]
[{"$f":"IF(B22<>\"\",MAX($A$10:A21)+1,\"\")","v":""}]
[{"$f":"IF(B23<>\"\",MAX($A$10:A22)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal B",{"$f":"SUM(F19:F23)","v":0}]
["C. Aportacions d'ens privats"]
[{"$f":"IF(B26<>\"\",MAX($A$10:A25)+1,\"\")","v":""}]
[{"$f":"IF(B27<>\"\",MAX($A$10:A26)+1,\"\")","v":""}]
[{"$f":"IF(B28<>\"\",MAX($A$10:A27)+1,\"\")","v":""}]
[{"$f":"IF(B29<>\"\",MAX($A$10:A28)+1,\"\")","v":""}]
[{"$f":"IF(B30<>\"\",MAX($A$10:A29)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal C",{"$f":"SUM(F26:F30)","v":0}]
["D. Recursos propis de l'entitat aplicats al projecte"]
[{"$f":"IF(B33<>\"\",MAX($A$10:A32)+1,\"\")","v":""}]
[{"$f":"IF(B34<>\"\",MAX($A$10:A33)+1,\"\")","v":""}]
[{"$f":"IF(B35<>\"\",MAX($A$10:A34)+1,\"\")","v":""}]
[{"$f":"IF(B36<>\"\",MAX($A$10:A35)+1,\"\")","v":""}]
[{"$f":"IF(B37<>\"\",MAX($A$10:A36)+1,\"\")","v":""}]
[{"$f":"IF(B38<>\"\",MAX($A$10:A37)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal D",{"$f":"SUM(F33:F38)","v":0}]
["E. Taquillatge"]
[{"$f":"IF(B41<>\"\",MAX($A$10:A40)+1,\"\")","v":""}]
[{"$f":"IF(B42<>\"\",MAX($A$10:A41)+1,\"\")","v":""}]
[{"$f":"IF(B43<>\"\",MAX($A$10:A42)+1,\"\")","v":""}]
[{"$f":"IF(B44<>\"\",MAX($A$10:A43)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal E",{"$f":"SUM(F41:F44)","v":0}]
["F. Quotes d'inscripció"]
[{"$f":"IF(B47<>\"\",MAX($A$10:A46)+1,\"\")","v":""}]
[{"$f":"IF(B48<>\"\",MAX($A$10:A47)+1,\"\")","v":""}]
[{"$f":"IF(B49<>\"\",MAX($A$10:A48)+1,\"\")","v":""}]
[{"$f":"IF(B50<>\"\",MAX($A$10:A49)+1,\"\")","v":""}]
[{"$f":"IF(B51<>\"\",MAX($A$10:A50)+1,\"\")","v":""}]
[{"$f":"IF(B52<>\"\",MAX($A$10:A51)+1,\"\")","v":""}]
[{"$f":"IF(B53<>\"\",MAX($A$10:A52)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal F",{"$f":"SUM(F47:F53)","v":0}]
["G. Venda de Productes"]
[{"$f":"IF(B56<>\"\",MAX($A$10:A55)+1,\"\")","v":""}]
[{"$f":"IF(B57<>\"\",MAX($A$10:A56)+1,\"\")","v":""}]
[{"$f":"IF(B58<>\"\",MAX($A$10:A57)+1,\"\")","v":""}]
[{"$f":"IF(B59<>\"\",MAX($A$10:A58)+1,\"\")","v":""}]
[{"$f":"IF(B60<>\"\",MAX($A$10:A59)+1,\"\")","v":""}]
[{"$f":"IF(B61<>\"\",MAX($A$10:A60)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal G",{"$f":"SUM(F56:F61)","v":0}]
["H. Publicitat i/o Esponsorització"]
[{"$f":"IF(B64<>\"\",MAX($A$10:A63)+1,\"\")","v":""}]
[{"$f":"IF(B65<>\"\",MAX($A$10:A64)+1,\"\")","v":""}]
[{"$f":"IF(B66<>\"\",MAX($A$10:A65)+1,\"\")","v":""}]
[{"$f":"IF(B67<>\"\",MAX($A$10:A66)+1,\"\")","v":""}]
[{"$f":"IF(B68<>\"\",MAX($A$10:A67)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal H",{"$f":"SUM(F64:F68)","v":0}]
["I. Altres ingressos"]
[{"$f":"IF(B71<>\"\",MAX($A$10:A70)+1,\"\")","v":""}]
[{"$f":"IF(B72<>\"\",MAX($A$10:A71)+1,\"\")","v":""}]
[{"$f":"IF(B73<>\"\",MAX($A$10:A72)+1,\"\")","v":""}]
[{"$f":"IF(B74<>\"\",MAX($A$10:A73)+1,\"\")","v":""}]
[{"$f":"IF(B75<>\"\",MAX($A$10:A74)+1,\"\")","v":""}]
[{"$f":"IF(B76<>\"\",MAX($A$10:A75)+1,\"\")","v":""}]
[{"$f":"IF(B77<>\"\",MAX($A$10:A76)+1,\"\")","v":""}]
[{"$f":"IF(B78<>\"\",MAX($A$10:A77)+1,\"\")","v":""}]
[{"$f":"IF(B79<>\"\",MAX($A$10:A78)+1,\"\")","v":""}]
[{"$f":"IF(B80<>\"\",MAX($A$10:A79)+1,\"\")","v":""}]
[{"$f":"IF(B81<>\"\",MAX($A$10:A80)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal I",{"$f":"SUM(F71:F81)","v":0}]
["Total INGRESSOS",null,null,null,"TOTAL",{"$f":"+F17+F24+F31+F39+F45+F54+F62+F69+F82","v":0}]
[]
[{"$f":"'Relació de despeses'!A166:M166","v":"El Sr./Sra. (indicar el nom i cognoms de la persona representant que signa la justificació)  amb DNI/NIE (indicar el núm. DNI) en qualitat de persona física beneficiària o representant legal de la persona jurídica beneficiària (indicar nom i cognoms) amb NIF (indicar núm DNI)."}]
["CERTIFICA que els ingressos imputats al projecte/activitat/servei subvencionat han estat efectivament ingressats; que custodiarà la documentació suport que ho acredita; que  aquesta documentació es troba a disposició de l'Ajuntament de Barcelona o dels altres ens municipals en els arxius d'aquesta Entitat, durant un període mínim de 4 anys a comptar des de la data de presentació de la present justificació."]
[]
[]
[]
[]
[null,"Població i data: ",null,null,"Signatura i segell"]
[]
[null,"Nota:"]
[null,"(0) El número d'ordre ha de ser correlatiu començant pel número 1"]
[null,"(1) Si per part de l'Ajuntament només s'ha rebut subvenció d'un sector o districte o institut, es poden esborrar la resta, que s'han indicat a mode d'exemple."]
[null,"(2) En cas que l'ingrés estigui pendent cobrament, indicar \"P. Cobrament\" "]

{"sheet":"Relació de despeses i ingressos","index":2,"n_rows":111,"n_cols":11,"rows_kept":111,"cut":false,"hidden":false,"merged":[[4,0,4,1],[4,2,4,3],[4,5,4,6],[5,0,5,1],[5,2,5,3],[5,5,5,6],[23,0,24,1],[23,2,24,2],[23,3,24,3],[25,6,25,7],[6,0,6,1],[6,2,6,3],[9,0,9,1],[9,6,9,7],[10,0,11,1],[10,2,11,2],[10,3,11,3],[10,6,11,7],[26,6,26,7],[26,8,26,9],[34,7,36,10],[10,8,11,8],[10,9,11,9]]}
[]
[]
["Estat de les despeses realitzades i dels ingressos obtinguts per a l'execució de l'activitat subvencionada (*)"]
[]
["Nom de la persona física/jurídica beneficiària:         ",null,{"$f":"IF('Relació de despeses'!C3:D3<>\"\",'Relació de despeses'!C3:D3,\"\")","v":""},null,null,"Import total del projecte:",null,{"$f":"'Relació d''ingressos '!H3","v":""},"euros"]
["Codi de subvenció:",null,{"$f":"IF('Relació de despeses'!C4:D4<>\"\",'Relació de despeses'!C4:D4,\"\")","v":""},null,null,"Import de la subvenció atorgada:",null,{"$f":"'Relació d''ingressos '!H4","v":""},"euros"]
["Nom del projecte subvencionat:",null,{"$f":"IF('Relació de despeses'!C5:D5<>\"\",'Relació de despeses'!C5:D5,\"\")","v":""},null,null,"Període d'execució del projecte subvencionat:",null,null,{"$f":"'Relació d''ingressos '!H5","v":""},"a",{"$f":"'Relació d''ingressos '!J5","v":""}]
[]
["SUBVENCIONS PER A LA PROMOCIÓ I REFORÇ DE L'ECONOMIA SOCIAL I SOLIDÀRIA 2018"]
["DESPESES PREVISTES",null,null,null,"import en euros",null,"INGRESSOS PREVISTOS"]
["Despeses directes \n(aquelles que s'identifiquen directament amb el projecte)",null,"Previsió inicial o reformulada ja aprovada","Despeses realitzades","Diferència\n",null,"Ingressos previstos",null,"Previsió inicial","Ingressos obtinguts"]
[null,null,null,null,"(2-1)"]
["A.","Retribucions del personal vinculat íntegrament al projecte i Seguretat Social del personal vinculat íntegrament al projecte. ",null,{"$f":"'Relació de despeses'!J28","v":0},{"$f":"+C13-D13","v":0},{"$f":"+IF(D13<0,\"No s'admeten valors negatius\",\"\")","v":""},"A.","Subvenció municipal (import sol·licitat a la instància/atorgat)",null,{"$f":"'Relació d''ingressos '!F17","v":0},{"$f":"+IF(J13<0,\"No s'admeten valors negatius\",IF(J13<>'Relació d''ingressos '!F17,\"No coincideix amb import pestanya anterior\",\"\"))","v":""}]
["B.","Lloguer de bens mobles/immobles directament vinculats al projecte.",null,{"$f":"'Relació de despeses'!J37","v":0},{"$f":"+C14-D14","v":0},{"$f":"+IF(D14<0,\"No s'admeten valors negatius\",\"\")","v":""},"B.","Subvencions d'altres administracions",null,{"$f":"'Relació d''ingressos '!F24","v":0},{"$f":"+IF(J14<0,\"No s'admeten valors negatius\",\"\")","v":""}]
["C.","Adquisició de materials i bens consumibles íntegrament imputables al projecte ",null,{"$f":"'Relació de despeses'!J44","v":0},0,"","C.","Subvencions d'ens privats",null,{"$f":"'Relació d''ingressos '!F31","v":0},""]
["D.","Transport - Missatgeria",null,{"$f":"'Relació de despeses'!J51","v":0},0,"","D.","Recursos propis de l'entitat aplicats al projecte",null,{"$f":"'Relació d''ingressos '!F39","v":0},""]
["E.","Publicitat i Propaganda",null,{"$f":"'Relació de despeses'!J58","v":0},0,"","E.","Taquillatge",null,{"$f":"'Relació d''ingressos '!F45","v":0},""]
["F.","Assegurances",null,{"$f":"'Relació de despeses'!J65","v":0},0,"","F.","Quotes d'inscripció",null,{"$f":"'Relació d''ingressos '!F54","v":0},""]
["G.","Allotjament i dietes",null,{"$f":"'Relació de despeses'!J72","v":0},0,"","G.","Venda de Productes",null,{"$f":"'Relació d''ingressos '!F62","v":0},""]
["H.","Viatges i desplaçaments",null,{"$f":"'Relació de despeses'!J78","v":0},0,"","H","Publicitat i/o Esponsorització",null,{"$f":"'Relació d''ingressos '!F69","v":0},""]
["I.","Treballs realitzats per empreses externes (neteja, seguretat, manteniment, altres relacionades directament amb el projecte)",null,{"$f":"'Relació de despeses'!J83","v":0},{"$f":"+C21-D21","v":0},{"$f":"+IF(D21<0,\"No s'admeten valors negatius\",\"\")","v":""},"I.","Altres ingressos",null,{"$f":"'Relació d''ingressos '!F82","v":0},""]
["J.","Altres despeses (no incloses en els apartats anteriors)",null,{"$f":"'Relació de despeses'!J88","v":0},0,"",null,"Total Ingressos",{"$f":"SUM(I13:I21)","v":0},{"$f":"SUM(J13:J21)","v":0}]
[null,"Total Despeses Directes   ",{"$f":"SUM(C13:C22)","v":0},{"$f":"SUM(D13:D22)","v":0},{"$f":"SUM(E13:E22)","v":0}]
["Despeses indirectes \n(no es poden assignar directament al projecte sense fer servir algun % d'assignació)",null,"Previsió inicial o reformulada ja aprovada","Despeses realitzades","Diferència\n"]
[null,null,null,null,"(2-1)"]
["A.","Personal de suport al projecte",null,{"$f":"'Relació de despeses'!J108","v":0},{"$f":"+C26-D26","v":0},{"$f":"+IF(D26<0,\"No s'admeten valors negatius\",\"\")","v":""},"Ingressos menys despeses ",null,{"$f":"+I22-C37","v":0},{"$f":"+J22-D37","v":0}]
["B.","Amortització",null,{"$f":"'Relació de despeses'!J115","v":0},0,{"$f":"+IF(D27<0,\"No s'admeten valors negatius\",\"\")","v":""},"Desviació de Despeses (4)",null,"Desviació d'ingressos (4)"]
["C.","Lloguer de bens immobles (locals)",null,{"$f":"'Relació de despeses'!J121","v":0},0,"","Import"," % (6)","Import","%"]
["D.","Adquisició de materials i bens consumibles parcialment imputables al projecte ",null,{"$f":"'Relació de despeses'!J127","v":0},0,"",{"$f":"D37","v":0},{"$f":"G29/C37","v":{"$error":"#DIV/0!"}},{"$f":"J22","v":0},{"$f":"I29/I22","v":{"$error":"#DIV/0!"}}]
["E.","Manteniment d'edificis i/o instal·lacions",null,{"$f":"'Relació de despeses'!J133","v":0},0,"",null,null,"% subvencionat inicialment o després de reformulació",{"$f":"I13/I22","v":{"$error":"#DIV/0!"}}]
["F.","Comunicacions (telèfon, correu, connexió a Internet…)",null,{"$f":"'Relació de despeses'!J139","v":0},0,"",null,null,"% subvencionat després de justificació",{"$f":"+J13/J22","v":{"$error":"#DIV/0!"}}]
["G.","Despeses financeres",null,{"$f":"'Relació de despeses'!J145","v":0},0,""]
["H.","Subministraments",null,{"$f":"'Relació de despeses'!J151","v":0},0,""]
["I.","Treballs realitzats per empreses externes (neteja, seguretat, manteniment, parcialment imputables al projecte)",null,{"$f":"'Relació de despeses'!J157","v":0},0,"",{"$f":"+OR(F26<>\"\",F27<>\"\",F28<>\"\",F29<>\"\",F30<>\"\",F31<>\"\",F32<>\"\",F33<>\"\",F34<>\"\",F35<>\"\")","v":false}]
["J.","Altres despeses (no incloses en els apartats anteriors)",null,{"$f":"'Relació de despeses'!J163","v":0},0,"",{"$f":"+OR(F13<>\"\",F14<>\"\",F15<>\"\",F16<>\"\",F17<>\"\",F18<>\"\",F19<>\"\",F20<>\"\",F21<>\"\",F22<>\"\")","v":false},{"$f":"+IFERROR(IF(G35<>FALSE,\"Revisar despeses directes justificades\",IF(G34<>FALSE,\"Revisar despeses indirectes justificades\",IF(G36<>FALSE,\"Revisar ingressos justificats\",IF((ROUND(J26,2)<>0),\"Despeses justificades i ingressos no quadren\",IF(ROUND(J31,2)>J30,\"% subvencionat supera % inicial\",IF(ROUND(J31,2)>0.8,\"El % subvencionat després de justificar no pot superar el 80%\",IF('Relació de despeses'!K163>'Relació de despeses i ingressos'!D36*0.1,\" Les despeses indirectes superen el 10% de la subvenció atorgada\",IF(D21>D37/2,\"Els treballs realitzats per empreses externes superen el 50% del cost del projecte\",IF(J13<>'Relació d''ingressos '!F17,\"Import atorgat no coincideix amb l'indicat a la pestanya Relació d'ingressos\",IF(ROUND(C37,2)<>ROUND('Relació de despeses'!J165,2),\"Import total projecte no coincideix amb l'indicat a la pestanya Relació de despeses\", \"\")))))))))),\"\")","v":""}]
[null,"Total Despeses Indirectes   ",{"$f":"SUM(C26:C35)","v":0},{"$f":"SUM(D26:D35)","v":0},{"$f":"SUM(E26:E35)","v":0},null,{"$f":"+OR(K13<>\"\",K14<>\"\",K15<>\"\",K16<>\"\",K17<>\"\",K18<>\"\",K19<>\"\",K20<>\"\",K21<>\"\")","v":false}]
[null,"Total Despeses ",{"$f":"+C23+C36","v":0},{"$f":"+D23+D36","v":0},{"$f":"+E36+E23","v":0},null,{"$f":"+J13*0.1","v":0}]
[null,null,null,null,"import en euros",null,{"$f":"+D23+D36","v":0}]
[]
[null,null,null,null,{"$f":"+#REF!-E37","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"+IF(J31>80%, \"La subvenció atorgada no pot superar el 80% del cost del projecte. Cal reduir ingressos i despeses del projecte.\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,0]

{"sheet":"Full1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}