{"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":2,"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":164,"n_cols":10,"rows_kept":164,"cut":false,"hidden":false,"merged":[[160,9,160,10],[161,0,161,6],[161,9,161,10],[162,0,162,2],[162,3,162,6],[162,9,162,10],[163,0,163,5],[163,9,163,10],[152,9,152,10],[153,9,153,10],[154,9,154,10],[155,0,155,6],[155,9,155,10],[156,0,156,10],[157,9,157,10],[158,9,158,10],[159,9,159,10],[144,0,144,10],[145,9,145,10],[146,9,146,10],[147,9,147,10],[148,9,148,10],[149,0,149,6],[149,9,149,10],[150,0,150,10],[151,9,151,10],[136,9,136,10],[137,0,137,6],[137,9,137,10],[138,0,138,10],[139,9,139,10],[140,9,140,10],[141,9,141,10],[142,9,142,10],[143,0,143,6],[143,9,143,10],[128,9,128,10],[129,9,129,10],[130,9,130,10],[131,0,131,6],[131,9,131,10],[132,0,132,10],[133,9,133,10],[134,9,134,10],[135,9,135,10],[120,0,120,10],[121,9,121,10],[122,9,122,10],[123,9,123,10],[124,9,124,10],[125,0,125,6],[125,9,125,10],[126,0,126,10],[127,9,127,10],[113,0,113,6],[113,9,113,10],[115,9,115,10],[116,9,116,10],[117,9,117,10],[118,9,118,10],[114,0,114,10],[119,0,119,6],[119,9,119,10],[108,9,108,10],[109,9,109,10],[90,9,90,10],[107,0,107,10],[104,9,104,10],[105,9,105,10],[110,9,110,10],[111,9,111,10],[112,9,112,10],[33,9,33,10],[30,9,30,10],[87,0,87,2],[87,3,87,6],[87,9,87,10],[88,0,88,8],[89,0,89,10],[106,0,106,6],[106,9,106,10],[83,9,83,10],[84,9,84,10],[85,9,85,10],[7,9,7,10],[8,9,8,10],[10,0,10,10],[25,9,25,10],[71,0,71,10],[76,0,76,6],[70,0,70,6],[63,0,63,6],[57,0,57,10],[29,9,29,10],[28,9,28,10],[7,3,7,4],[82,0,82,10],[77,0,77,10],[81,0,81,6],[64,0,64,10],[56,0,56,6],[35,9,35,10],[34,9,34,10],[32,9,32,10],[31,9,31,10],[3,0,3,1],[7,1,8,1],[7,0,8,0],[6,0,6,4],[86,9,86,10],[65,9,65,10],[76,9,76,10],[75,9,75,10],[66,9,66,10],[51,9,51,10],[63,9,63,10],[62,9,62,10],[61,9,61,10],[60,9,60,10],[59,9,59,10],[58,9,58,10],[56,9,56,10],[55,9,55,10],[80,9,80,10],[81,9,81,10],[86,0,86,6],[35,0,35,6],[42,0,42,6],[27,0,27,10],[74,9,74,10],[73,9,73,10],[70,9,70,10],[69,9,69,10],[68,9,68,10],[67,9,67,10],[78,9,78,10],[79,9,79,10],[50,0,50,10],[72,9,72,10],[13,9,13,10],[54,9,54,10],[53,9,53,10],[52,9,52,10],[36,0,36,10],[43,0,43,10],[16,9,16,10],[15,9,15,10],[14,9,14,10],[26,9,26,10],[44,9,44,10],[42,9,42,10],[41,9,41,10],[40,9,40,10],[39,9,39,10],[38,9,38,10],[17,9,17,10],[18,9,18,10],[19,9,19,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[0,0,0,10],[4,0,4,1],[26,0,26,6],[2,2,2,3],[3,2,3,3],[4,2,4,3],[11,9,11,10],[2,0,2,1],[49,9,49,10],[2,4,2,6],[3,4,3,6],[4,4,4,6],[48,9,48,10],[47,9,47,10],[46,9,46,10],[45,9,45,10],[7,2,8,2],[12,9,12,10],[2,7,2,8],[3,7,3,8],[4,7,4,8],[9,0,9,8],[49,0,49,6],[37,9,37,10]]}
["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,"euros"]
["Codi de subvenció:",null,null,null,"Import de la subvenció atorgada:",null,null,null,null,"euros"]
["Nom del projecte subvencionat:",null,null,null,"Període d'execució del projecte subvencionat:",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","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","(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,{"$f":"SUM(H12:H26)","v":0},{"$f":"SUM(I12:I26)","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,{"$f":"SUM(H29:H35)","v":0},{"$f":"SUM(I29:I35)","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$30:A38)+1,\"\")","v":""}]
[{"$f":"IF(B40<>\"\",MAX($A$30:A39)+1,\"\")","v":""}]
[{"$f":"IF(B41<>\"\",MAX($A$30:A40)+1,\"\")","v":""}]
[{"$f":"IF(B42<>\"\",MAX($A$30:A41)+1,\"\")","v":""}]
["Subtotal C",null,null,null,null,null,null,{"$f":"SUM(H38:H42)","v":0},{"$f":"SUM(I38:I42)","v":0}]
["D. Transport - Missatgeria"]
[{"$f":"IF(B45<>\"\",MAX($A$12:A44)+1,\"\")","v":""}]
[{"$f":"IF(B46<>\"\",MAX($A$30:A45)+1,\"\")","v":""}]
[{"$f":"IF(B47<>\"\",MAX($A$30:A46)+1,\"\")","v":""}]
[{"$f":"IF(B48<>\"\",MAX($A$30:A47)+1,\"\")","v":""}]
[{"$f":"IF(B49<>\"\",MAX($A$30:A48)+1,\"\")","v":""}]
["Subtotal D",null,null,null,null,null,null,{"$f":"SUM(H45:H49)","v":0},{"$f":"SUM(I45:I49)","v":0}]
["E. Publicitat i propaganda"]
[{"$f":"IF(B52<>\"\",MAX($A$12:A51)+1,\"\")","v":""}]
[{"$f":"IF(B53<>\"\",MAX($A$30:A52)+1,\"\")","v":""}]
[{"$f":"IF(B54<>\"\",MAX($A$30:A53)+1,\"\")","v":""}]
[{"$f":"IF(B55<>\"\",MAX($A$30:A54)+1,\"\")","v":""}]
[{"$f":"IF(B56<>\"\",MAX($A$30:A55)+1,\"\")","v":""}]
["Subtotal E",null,null,null,null,null,null,{"$f":"SUM(H52:H56)","v":0},{"$f":"SUM(I52:I56)","v":0}]
["F. Assegurances"]
[{"$f":"IF(B59<>\"\",MAX($A$12:A58)+1,\"\")","v":""}]
[{"$f":"IF(B60<>\"\",MAX($A$30:A59)+1,\"\")","v":""}]
[{"$f":"IF(B61<>\"\",MAX($A$30:A60)+1,\"\")","v":""}]
[{"$f":"IF(B62<>\"\",MAX($A$30:A61)+1,\"\")","v":""}]
[{"$f":"IF(B63<>\"\",MAX($A$30:A62)+1,\"\")","v":""}]
["Subtotal F",null,null,null,null,null,null,{"$f":"SUM(H59:H63)","v":0},{"$f":"SUM(I59:I63)","v":0}]
["G. Allotjament i dietes"]
[{"$f":"IF(B66<>\"\",MAX($A$12:A65)+1,\"\")","v":""}]
[{"$f":"IF(B67<>\"\",MAX($A$30:A66)+1,\"\")","v":""}]
[{"$f":"IF(B68<>\"\",MAX($A$30:A67)+1,\"\")","v":""}]
[{"$f":"IF(B69<>\"\",MAX($A$30:A68)+1,\"\")","v":""}]
[{"$f":"IF(B70<>\"\",MAX($A$30:A69)+1,\"\")","v":""}]
["Subtotal G",null,null,null,null,null,null,{"$f":"SUM(H66:H70)","v":0},{"$f":"SUM(I66:I70)","v":0}]
["H. Viatges i desplaçaments"]
[{"$f":"IF(B73<>\"\",MAX($A$12:A72)+1,\"\")","v":""}]
[{"$f":"IF(B74<>\"\",MAX($A$30:A73)+1,\"\")","v":""}]
[{"$f":"IF(B75<>\"\",MAX($A$30:A74)+1,\"\")","v":""}]
[{"$f":"IF(B76<>\"\",MAX($A$30:A75)+1,\"\")","v":""}]
["Subtotal H",null,null,null,null,null,null,{"$f":"SUM(H73:H76)","v":0},{"$f":"SUM(I73:I76)","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$30:A79)+1,\"\")","v":""}]
[{"$f":"IF(B81<>\"\",MAX($A$30:A80)+1,\"\")","v":""}]
["Subtotal I",null,null,null,null,null,null,{"$f":"SUM(H79:H81)","v":0},{"$f":"SUM(I79:I81)","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$30:A84)+1,\"\")","v":""}]
[{"$f":"IF(B86<>\"\",MAX($A$30:A85)+1,\"\")","v":""}]
["Subtotal J",null,null,null,null,null,null,{"$f":"SUM(H84:H86)","v":0},{"$f":"SUM(I84:I86)","v":0}]
["TOTAL DESPESES DIRECTES ",null,null,"TOTAL DESPESES DIRECTES",null,null,null,{"$f":"+H27+H36+H43+H50+H57+H64+H71+H77+H82+H87","v":0},{"$f":"+I27+I36+I43+I50+I57+I64+I71+I77+I82+I87","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$12:A90)+1,\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(B105<>\"\",MAX($A$30:A91)+1,\"\")","v":""}]
[{"$f":"IF(B106<>\"\",MAX($A$30:A105)+1,\"\")","v":""}]
["Subtotal A",null,null,null,null,null,null,{"$f":"SUM(H91:H106)","v":0},{"$f":"SUM(I91:I106)","v":0}]
["B. Amortització"]
[{"$f":"IF(B109<>\"\",MAX($A$12:A108)+1,\"\")","v":""}]
[{"$f":"IF(B110<>\"\",MAX($A$30:A109)+1,\"\")","v":""}]
[{"$f":"IF(B111<>\"\",MAX($A$30:A110)+1,\"\")","v":""}]
[{"$f":"IF(B112<>\"\",MAX($A$30:A111)+1,\"\")","v":""}]
[{"$f":"IF(B113<>\"\",MAX($A$30:A112)+1,\"\")","v":""}]
["Subtotal B",null,null,null,null,null,null,{"$f":"SUM(H109:H113)","v":0},{"$f":"SUM(I109:I113)","v":0}]
["C. Lloguer de bens inmobles (locals)"]
[{"$f":"IF(B116<>\"\",MAX($A$12:A115)+1,\"\")","v":""}]
[{"$f":"IF(B117<>\"\",MAX($A$30:A116)+1,\"\")","v":""}]
[{"$f":"IF(B118<>\"\",MAX($A$30:A117)+1,\"\")","v":""}]
[{"$f":"IF(B119<>\"\",MAX($A$30:A118)+1,\"\")","v":""}]
["Subtotal C",null,null,null,null,null,null,{"$f":"SUM(H116:H119)","v":0},{"$f":"SUM(I116:I119)","v":0}]
["D. Adquisició de materials i bens consumibles parcialment imputades al projecte"]
[{"$f":"IF(B122<>\"\",MAX($A$12:A121)+1,\"\")","v":""}]
[{"$f":"IF(B123<>\"\",MAX($A$30:A122)+1,\"\")","v":""}]
[{"$f":"IF(B124<>\"\",MAX($A$30:A123)+1,\"\")","v":""}]
[{"$f":"IF(B125<>\"\",MAX($A$30:A124)+1,\"\")","v":""}]
["Subtotal D",null,null,null,null,null,null,{"$f":"SUM(H122:H125)","v":0},{"$f":"SUM(I122:I125)","v":0}]
["E. Manteniment d'edificis i/o instal·lacions"]
[{"$f":"IF(B128<>\"\",MAX($A$12:A127)+1,\"\")","v":""}]
[{"$f":"IF(B129<>\"\",MAX($A$30:A128)+1,\"\")","v":""}]
[{"$f":"IF(B130<>\"\",MAX($A$30:A129)+1,\"\")","v":""}]
[{"$f":"IF(B131<>\"\",MAX($A$30:A130)+1,\"\")","v":""}]
["Subtotal E",null,null,null,null,null,null,{"$f":"SUM(H128:H131)","v":0},{"$f":"SUM(I128:I131)","v":0}]
["F. Comunicacions (telèfon, correu, connexió a internet...)"]
[{"$f":"IF(B134<>\"\",MAX($A$12:A133)+1,\"\")","v":""}]
[{"$f":"IF(B135<>\"\",MAX($A$30:A134)+1,\"\")","v":""}]
[{"$f":"IF(B136<>\"\",MAX($A$30:A135)+1,\"\")","v":""}]
[{"$f":"IF(B137<>\"\",MAX($A$30:A136)+1,\"\")","v":""}]
["Subtotal F",null,null,null,null,null,null,{"$f":"SUM(H134:H137)","v":0},{"$f":"SUM(I134:I137)","v":0}]
["G. Despeses financeres"]
[{"$f":"IF(B140<>\"\",MAX($A$12:A139)+1,\"\")","v":""}]
[{"$f":"IF(B141<>\"\",MAX($A$30:A140)+1,\"\")","v":""}]
[{"$f":"IF(B142<>\"\",MAX($A$30:A141)+1,\"\")","v":""}]
[{"$f":"IF(B143<>\"\",MAX($A$30:A142)+1,\"\")","v":""}]
["Subtotal G",null,null,null,null,null,null,{"$f":"SUM(H140:H143)","v":0},{"$f":"SUM(I140:I143)","v":0}]
["H. Subministraments"]
[{"$f":"IF(B146<>\"\",MAX($A$12:A145)+1,\"\")","v":""}]
[{"$f":"IF(B147<>\"\",MAX($A$30:A146)+1,\"\")","v":""}]
[{"$f":"IF(B148<>\"\",MAX($A$30:A147)+1,\"\")","v":""}]
[{"$f":"IF(B149<>\"\",MAX($A$30:A148)+1,\"\")","v":""}]
["Subtotal H",null,null,null,null,null,null,{"$f":"SUM(H146:H149)","v":0},{"$f":"SUM(I146:I149)","v":0}]
["I. Treballs realitzats per empreses externes (neteja, seguretat, manteniment, parcialment imputables al projecte)"]
[{"$f":"IF(B152<>\"\",MAX($A$12:A151)+1,\"\")","v":""}]
[{"$f":"IF(B153<>\"\",MAX($A$30:A152)+1,\"\")","v":""}]
[{"$f":"IF(B154<>\"\",MAX($A$30:A153)+1,\"\")","v":""}]
[{"$f":"IF(B155<>\"\",MAX($A$30:A154)+1,\"\")","v":""}]
["Subtotal I",null,null,null,null,null,null,{"$f":"SUM(H152:H155)","v":0},{"$f":"SUM(I152:I155)","v":0}]
["J. Altres despeses (no incloses en els apartats anteriors)"]
[{"$f":"IF(B158<>\"\",MAX($A$12:A157)+1,\"\")","v":""}]
[{"$f":"IF(B159<>\"\",MAX($A$30:A158)+1,\"\")","v":""}]
[{"$f":"IF(B160<>\"\",MAX($A$30:A159)+1,\"\")","v":""}]
[{"$f":"IF(B161<>\"\",MAX($A$30:A160)+1,\"\")","v":""}]
["Subtotal J",null,null,null,null,null,null,{"$f":"SUM(H158:H161)","v":0},{"$f":"SUM(I158:I161)","v":0}]
["TOTAL DESPESES INDIRECTES ",null,null,"TOTAL DESPESES INDIRECTES",null,null,null,{"$f":"+H107+H114+H120+H126+H132+H138+H144+H150+H156+H162","v":0},{"$f":"+I107+I114+I120+I126+I132+I138+I144+I150+I156+I162","v":0}]
["TOTAL DESPESES",null,null,null,null,null,"TOTAL",{"$f":"+H163+H88","v":0},{"$f":"+I163+I88","v":0}]

{"sheet":"Relació d'ingressos ","index":1,"n_rows":96,"n_cols":10,"rows_kept":96,"cut":false,"hidden":false,"merged":[[13,6,13,9],[14,6,14,9],[28,6,28,9],[50,6,50,9],[57,6,57,9],[22,6,22,9],[21,6,21,9],[20,6,20,9],[19,6,19,9],[18,6,18,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],[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],[41,6,41,9],[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],[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],[47,6,47,9],[46,6,46,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],[64,6,64,9],[63,6,63,9],[82,0,82,3],[81,0,81,3],[84,0,84,9],[85,0,86,9],[81,6,81,9],[80,6,80,9],[76,6,76,9],[74,6,74,9],[71,6,71,9],[82,6,82,9],[72,6,72,9],[73,6,73,9],[75,6,75,9],[77,6,77,9],[78,6,78,9],[79,6,79,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'!H3=\"\",\"\",+'Relació de despeses'!H3)","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'!H4=\"\",\"\",+'Relació de despeses'!H4)","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'!H5=\"\",\"\",+'Relació de despeses'!H5)","v":""},"a",{"$f":"IF(+'Relació de despeses'!K5=\"\",\"\",+'Relació de despeses'!K5)","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$30:A66)+1,\"\")","v":""}]
[{"$f":"IF(B68<>\"\",MAX($A$30: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'!A108:K108","v":"B. Amortització"}]
["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":[[26,6,26,7],[26,8,26,9],[34,7,36,10],[10,8,11,8],[10,9,11,9],[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],[4,0,4,1],[4,2,4,3],[4,5,4,6],[5,0,5,1],[5,2,5,3],[5,5,5,6]]}
[]
[]
["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('[1]Relació de despeses'!C3:D3<>\"\",'[1]Relació de despeses'!C3:D3,\"\")","v":""},null,null,"Import total del projecte:",null,{"$f":"'[2]Relació d''ingressos '!H3","v":""},"euros"]
["Codi de subvenció:",null,{"$f":"IF('[1]Relació de despeses'!C4:D4<>\"\",'[1]Relació de despeses'!C4:D4,\"\")","v":""},null,null,"Import de la subvenció atorgada:",null,{"$f":"'[2]Relació d''ingressos '!H4","v":""},"euros"]
["Nom del projecte subvencionat:",null,{"$f":"IF('[1]Relació de despeses'!C5:D5<>\"\",'[1]Relació de despeses'!C5:D5,\"\")","v":""},null,null,"Període d'execució del projecte subvencionat:",null,null,{"$f":"'[2]Relació d''ingressos '!H5","v":""},"a",{"$f":"'[2]Relació d''ingressos '!J5","v":""}]
[]
["SUBVENCIONS PER A LA PROMOCIÓ I REFORÇ DE L'ECONOMIA SOCIAL I SOLIDÀRIA 2017"]
["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":"'[1]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":"'[1]Relació d''ingressos '!F17","v":0},{"$f":"+IF(J13<0,\"No s'admeten valors negatius\",IF(J13<>'[1]Relació d''ingressos '!F17,\"No coincideix amb import pestanya anterior\",\"\"))","v":""}]
["B.","Lloguer de bens mobles/immobles directament vinculats al projecte.",null,{"$f":"'[1]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":"'[1]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":"'[1]Relació de despeses'!J44","v":0},0,"","C.","Subvencions d'ens privats",null,{"$f":"'[1]Relació d''ingressos '!F31","v":0},""]
["D.","Transport - Missatgeria",null,{"$f":"'[1]Relació de despeses'!J51","v":0},0,"","D.","Recursos propis de l'entitat aplicats al projecte",null,{"$f":"'[1]Relació d''ingressos '!F39","v":0},""]
["E.","Publicitat i Propaganda",null,{"$f":"'[1]Relació de despeses'!J58","v":0},0,"","E.","Taquillatge",null,{"$f":"'[1]Relació d''ingressos '!F45","v":0},""]
["F.","Assegurances",null,{"$f":"'[1]Relació de despeses'!J65","v":0},0,"","F.","Quotes d'inscripció",null,{"$f":"'[1]Relació d''ingressos '!F54","v":0},""]
["G.","Allotjament i dietes",null,{"$f":"'[1]Relació de despeses'!J72","v":0},0,"","G.","Venda de Productes",null,{"$f":"'[1]Relació d''ingressos '!F62","v":0},""]
["H.","Viatges i desplaçaments",null,{"$f":"'[1]Relació de despeses'!J78","v":0},0,"","H","Publicitat i/o Esponsorització",null,{"$f":"'[1]Relació d''ingressos '!F69","v":0},""]
["I.","Treballs realitzats per empreses externes (neteja, seguretat, manteniment, altres relacionades directament amb el projecte)",null,{"$f":"'[1]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":"'[1]Relació d''ingressos '!F82","v":0},""]
["J.","Altres despeses (no incloses en els apartats anteriors)",null,{"$f":"'[1]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":"'[1]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":"'[1]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":"'[1]Relació de despeses'!J121","v":0},0,"","Import"," % (6)","Import","%"]
["D.","Adquisició de materials i bens consumibles parcialment imputables al projecte ",null,{"$f":"'[1]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":"'[1]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":"'[1]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":"'[1]Relació de despeses'!J145","v":0},0,""]
["H.","Subministraments",null,{"$f":"'[1]Relació de despeses'!J151","v":0},0,""]
["I.","Treballs realitzats per empreses externes (neteja, seguretat, manteniment, parcialment imputables al projecte)",null,{"$f":"'[1]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":"'[1]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(G37<D36,\" 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<>'[1]Relació d''ingressos '!F17,\"Import atorgat no coincideix amb l'indicat a la pestanya Relació d'ingressos\",IF(ROUND(C37,2)<>ROUND('[1]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":[]}