{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Relació de despeses","Relació d'ingressos ","Resum estat despeses-ingressos","Full1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"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":293,"n_cols":12,"rows_kept":293,"cut":false,"hidden":false,"merged":[[0,0,0,11],[4,0,4,1],[47,0,47,6],[2,2,2,3],[3,2,3,3],[4,2,4,3],[12,10,12,11],[2,0,2,1],[113,10,113,11],[2,4,2,6],[3,4,3,6],[4,4,4,6],[112,10,112,11],[102,10,102,11],[101,10,101,11],[100,10,100,11],[9,2,10,2],[13,10,13,11],[2,7,2,8],[3,7,3,8],[4,7,4,9],[203,10,203,11],[204,10,204,11],[216,10,216,11],[191,10,191,11],[192,10,192,11],[114,0,114,11],[113,0,113,6],[89,10,89,11],[14,10,14,11],[118,10,118,11],[117,10,117,11],[116,10,116,11],[88,0,88,11],[98,0,98,11],[17,10,17,11],[16,10,16,11],[15,10,15,11],[47,10,47,11],[99,10,99,11],[97,10,97,11],[96,10,96,11],[92,10,92,11],[91,10,91,11],[90,10,90,11],[234,10,234,11],[235,10,235,11],[248,10,248,11],[249,10,249,11],[219,10,219,11],[220,10,220,11],[231,10,231,11],[232,10,232,11],[251,10,251,11],[282,1,282,3],[282,5,282,11],[249,0,249,6],[217,0,217,6],[87,0,87,6],[97,0,97,6],[48,0,48,11],[87,10,87,11],[86,10,86,11],[53,10,53,11],[52,10,52,11],[51,10,51,11],[275,10,275,11],[276,10,276,11],[276,0,276,5],[252,10,252,11],[175,10,175,11],[174,10,174,11],[171,10,171,11],[232,0,232,6],[274,10,274,11],[170,10,170,11],[161,10,161,11],[160,10,160,11],[285,0,285,11],[3,0,3,1],[9,1,10,1],[9,0,10,0],[6,0,6,4],[275,0,275,6],[217,10,217,11],[158,10,158,11],[189,10,189,11],[188,10,188,11],[159,10,159,11],[115,10,115,11],[156,10,156,11],[155,10,155,11],[133,10,133,11],[132,10,132,11],[131,10,131,11],[130,10,130,11],[128,10,128,11],[127,10,127,11],[278,0,278,11],[279,0,279,11],[200,10,200,11],[201,10,201,11],[292,0,292,11],[290,0,290,11],[9,10,9,11],[10,10,10,11],[11,0,11,11],[46,10,46,11],[172,0,172,11],[189,0,189,6],[171,0,171,6],[233,0,233,11],[250,0,250,11],[156,0,156,6],[129,0,129,11],[50,10,50,11],[49,10,49,11],[9,3,9,4],[202,0,202,11],[190,0,190,11],[201,0,201,6],[218,0,218,11],[157,0,157,11],[128,0,128,6],[287,0,287,11],[288,0,288,11]]}
["Relación clasificada de todos los gastos realizados para la ejecución de la actividad subvencionada"]
[]
["Persona física/jurídica beneficiaria:         ",null,null,null,"Importe total del proyecto:",null,null,null,null,null,"euros"]
["Código de subvención:",null,null,null,"Importe de la subvención otorgada:",null,null,null,null,null,"euros"]
["Nombre del proyecto subvencionado:",null,null,null,"Periodo de ejecución del proyecto subvencionado:",null,null,"2020-01-01",null,null,"a","2021-12-31"]
[]
["Gastos del proyecto/actividad/servicio subvencionado (*)"]
[]
[]
["núm. De órden (0)","número de documento: justificantes gasto personal (1), factura o recibo/tiquet(2)","Concepto de la factura / \ndocument probatori equivalent","Emissor de la factura",null,"fecha de emisión","Importe total de la factura","Import imputable (dedicado) al proyecto (3)","Import imputable a la subvención municipal (4)","Actividad a la que se ha d'imputar l'import","Observaciones"]
[null,null,null,"NIF","Nombre","dd/mm/aaaa","euros","euros","euros",null,"(2)"]
["A. Recursos Humans (retribuciones brutas y Seguridad Social del personal fijo o eventual contractado)"]
[{"$f":"IF(B13<>\"\",1,\"\")","v":""}]
[{"$f":"IF(B14<>\"\",MAX($A$13:A13)+1,\"\")","v":""}]
[{"$f":"IF(B15<>\"\",MAX($A$13:A14)+1,\"\")","v":""}]
[{"$f":"IF(B16<>\"\",MAX($A$13:A15)+1,\"\")","v":""}]
[{"$f":"IF(B17<>\"\",MAX($A$13:A16)+1,\"\")","v":""}]
[{"$f":"IF(B18<>\"\",MAX($A$13:A17)+1,\"\")","v":""}]
[{"$f":"IF(B19<>\"\",MAX($A$13:A18)+1,\"\")","v":""}]
[{"$f":"IF(B20<>\"\",MAX($A$13:A19)+1,\"\")","v":""}]
[{"$f":"IF(B21<>\"\",MAX($A$13:A20)+1,\"\")","v":""}]
[{"$f":"IF(B22<>\"\",MAX($A$13:A21)+1,\"\")","v":""}]
[{"$f":"IF(B23<>\"\",MAX($A$13:A22)+1,\"\")","v":""}]
[{"$f":"IF(B24<>\"\",MAX($A$13:A23)+1,\"\")","v":""}]
[{"$f":"IF(B25<>\"\",MAX($A$13:A24)+1,\"\")","v":""}]
[{"$f":"IF(B26<>\"\",MAX($A$13:A25)+1,\"\")","v":""}]
[{"$f":"IF(B27<>\"\",MAX($A$13:A26)+1,\"\")","v":""}]
[{"$f":"IF(B28<>\"\",MAX($A$13:A27)+1,\"\")","v":""}]
[{"$f":"IF(B29<>\"\",MAX($A$13:A28)+1,\"\")","v":""}]
[{"$f":"IF(B30<>\"\",MAX($A$13:A29)+1,\"\")","v":""}]
[{"$f":"IF(B31<>\"\",MAX($A$13:A30)+1,\"\")","v":""}]
[{"$f":"IF(B32<>\"\",MAX($A$13:A31)+1,\"\")","v":""}]
[{"$f":"IF(B33<>\"\",MAX($A$13:A32)+1,\"\")","v":""}]
[{"$f":"IF(B34<>\"\",MAX($A$13:A33)+1,\"\")","v":""}]
[{"$f":"IF(B35<>\"\",MAX($A$13:A34)+1,\"\")","v":""}]
[{"$f":"IF(B36<>\"\",MAX($A$13:A35)+1,\"\")","v":""}]
[{"$f":"IF(B37<>\"\",MAX($A$13:A36)+1,\"\")","v":""}]
[{"$f":"IF(B38<>\"\",MAX($A$13:A37)+1,\"\")","v":""}]
[{"$f":"IF(B39<>\"\",MAX($A$13:A38)+1,\"\")","v":""}]
[{"$f":"IF(B40<>\"\",MAX($A$13:A39)+1,\"\")","v":""}]
[{"$f":"IF(B41<>\"\",MAX($A$13:A40)+1,\"\")","v":""}]
[{"$f":"IF(B42<>\"\",MAX($A$13:A41)+1,\"\")","v":""}]
[{"$f":"IF(B43<>\"\",MAX($A$13:A42)+1,\"\")","v":""}]
[{"$f":"IF(B44<>\"\",MAX($A$13:A43)+1,\"\")","v":""}]
[{"$f":"IF(B45<>\"\",MAX($A$13:A44)+1,\"\")","v":""}]
[{"$f":"IF(B46<>\"\",MAX($A$13:A45)+1,\"\")","v":""}]
[{"$f":"IF(B47<>\"\",MAX($A$13:A46)+1,\"\")","v":""}]
["Subtotal A",null,null,null,null,null,null,{"$f":"SUM(H13:H47)","v":0},{"$f":"SUM(I13:I47)","v":0}]
["B. Alquileres (materiales, infraestructuras)"]
[{"$f":"IF(B50<>\"\",MAX($A$13:A49)+1,\"\")","v":""}]
[{"$f":"IF(B51<>\"\",MAX($A$49:A50)+1,\"\")","v":""}]
[{"$f":"IF(B52<>\"\",MAX($A$49:A51)+1,\"\")","v":""}]
[{"$f":"IF(B53<>\"\",MAX($A$49:A52)+1,\"\")","v":""}]
[{"$f":"IF(B54<>\"\",MAX($A$49:A53)+1,\"\")","v":""}]
[{"$f":"IF(B55<>\"\",MAX($A$49:A54)+1,\"\")","v":""}]
[{"$f":"IF(B56<>\"\",MAX($A$49:A55)+1,\"\")","v":""}]
[{"$f":"IF(B57<>\"\",MAX($A$49:A56)+1,\"\")","v":""}]
[{"$f":"IF(B58<>\"\",MAX($A$49:A57)+1,\"\")","v":""}]
[{"$f":"IF(B59<>\"\",MAX($A$49:A58)+1,\"\")","v":""}]
[{"$f":"IF(B60<>\"\",MAX($A$49:A59)+1,\"\")","v":""}]
[{"$f":"IF(B61<>\"\",MAX($A$49:A60)+1,\"\")","v":""}]
[{"$f":"IF(B62<>\"\",MAX($A$49:A61)+1,\"\")","v":""}]
[{"$f":"IF(B63<>\"\",MAX($A$49:A62)+1,\"\")","v":""}]
[{"$f":"IF(B64<>\"\",MAX($A$49:A63)+1,\"\")","v":""}]
[{"$f":"IF(B65<>\"\",MAX($A$49:A64)+1,\"\")","v":""}]
[{"$f":"IF(B66<>\"\",MAX($A$49:A65)+1,\"\")","v":""}]
[{"$f":"IF(B67<>\"\",MAX($A$49:A66)+1,\"\")","v":""}]
[{"$f":"IF(B68<>\"\",MAX($A$49:A67)+1,\"\")","v":""}]
[{"$f":"IF(B69<>\"\",MAX($A$49:A68)+1,\"\")","v":""}]
[{"$f":"IF(B70<>\"\",MAX($A$49:A69)+1,\"\")","v":""}]
[{"$f":"IF(B71<>\"\",MAX($A$49:A70)+1,\"\")","v":""}]
[{"$f":"IF(B72<>\"\",MAX($A$49:A71)+1,\"\")","v":""}]
[{"$f":"IF(B73<>\"\",MAX($A$49:A72)+1,\"\")","v":""}]
[{"$f":"IF(B74<>\"\",MAX($A$49:A73)+1,\"\")","v":""}]
[{"$f":"IF(B75<>\"\",MAX($A$49:A74)+1,\"\")","v":""}]
[{"$f":"IF(B76<>\"\",MAX($A$49:A75)+1,\"\")","v":""}]
[{"$f":"IF(B77<>\"\",MAX($A$49:A76)+1,\"\")","v":""}]
[{"$f":"IF(B78<>\"\",MAX($A$49:A77)+1,\"\")","v":""}]
[{"$f":"IF(B79<>\"\",MAX($A$49:A78)+1,\"\")","v":""}]
[{"$f":"IF(B80<>\"\",MAX($A$49:A79)+1,\"\")","v":""}]
[{"$f":"IF(B81<>\"\",MAX($A$49:A80)+1,\"\")","v":""}]
[{"$f":"IF(B82<>\"\",MAX($A$49:A81)+1,\"\")","v":""}]
[{"$f":"IF(B83<>\"\",MAX($A$49:A82)+1,\"\")","v":""}]
[{"$f":"IF(B84<>\"\",MAX($A$49:A83)+1,\"\")","v":""}]
[{"$f":"IF(B85<>\"\",MAX($A$49:A84)+1,\"\")","v":""}]
[{"$f":"IF(B86<>\"\",MAX($A$49:A85)+1,\"\")","v":""}]
[{"$f":"IF(B87<>\"\",MAX($A$49:A86)+1,\"\")","v":""}]
["Subtotal B",null,null,null,null,null,null,{"$f":"SUM(H50:H87)","v":0},{"$f":"SUM(I50:I87)","v":0}]
["C. Suministros (luz, agua, gas)"]
[{"$f":"IF(B90<>\"\",MAX($A$13:A89)+1,\"\")","v":""}]
[{"$f":"IF(B91<>\"\",MAX($A$49:A90)+1,\"\")","v":""}]
[{"$f":"IF(B92<>\"\",MAX($A$49:A91)+1,\"\")","v":""}]
[{"$f":"IF(B93<>\"\",MAX($A$49:A92)+1,\"\")","v":""}]
[{"$f":"IF(B94<>\"\",MAX($A$49:A93)+1,\"\")","v":""}]
[{"$f":"IF(B95<>\"\",MAX($A$49:A94)+1,\"\")","v":""}]
[{"$f":"IF(B96<>\"\",MAX($A$49:A95)+1,\"\")","v":""}]
[{"$f":"IF(B97<>\"\",MAX($A$49:A96)+1,\"\")","v":""}]
["Subtotal C",null,null,null,null,null,null,{"$f":"SUM(H90:H97)","v":0},{"$f":"SUM(I90:I97)","v":0}]
["D. Comunicaciones (teléfono, fax, correos)"]
[{"$f":"IF(B100<>\"\",MAX($A$13:A99)+1,\"\")","v":""}]
[{"$f":"IF(B101<>\"\",MAX($A$49:A100)+1,\"\")","v":""}]
[{"$f":"IF(B102<>\"\",MAX($A$49:A101)+1,\"\")","v":""}]
[{"$f":"IF(B103<>\"\",MAX($A$49:A102)+1,\"\")","v":""}]
[{"$f":"IF(B104<>\"\",MAX($A$49:A103)+1,\"\")","v":""}]
[{"$f":"IF(B105<>\"\",MAX($A$49:A104)+1,\"\")","v":""}]
[{"$f":"IF(B106<>\"\",MAX($A$49:A105)+1,\"\")","v":""}]
[{"$f":"IF(B107<>\"\",MAX($A$49:A106)+1,\"\")","v":""}]
[{"$f":"IF(B108<>\"\",MAX($A$49:A107)+1,\"\")","v":""}]
[{"$f":"IF(B109<>\"\",MAX($A$49:A108)+1,\"\")","v":""}]
[{"$f":"IF(B110<>\"\",MAX($A$49:A109)+1,\"\")","v":""}]
[{"$f":"IF(B111<>\"\",MAX($A$49:A110)+1,\"\")","v":""}]
[{"$f":"IF(B112<>\"\",MAX($A$49:A111)+1,\"\")","v":""}]
[{"$f":"IF(B113<>\"\",MAX($A$49:A112)+1,\"\")","v":""}]
["Subtotal D",null,null,null,null,null,null,{"$f":"SUM(H100:H113)","v":0},{"$f":"SUM(I100:I113)","v":0}]
["E. Mantenimiento de edificios y/o instalaciones"]
[{"$f":"IF(B116<>\"\",MAX($A$13:A115)+1,\"\")","v":""}]
[{"$f":"IF(B117<>\"\",MAX($A$49:A116)+1,\"\")","v":""}]
[{"$f":"IF(B118<>\"\",MAX($A$49:A117)+1,\"\")","v":""}]
[{"$f":"IF(B119<>\"\",MAX($A$49:A118)+1,\"\")","v":""}]
[{"$f":"IF(B120<>\"\",MAX($A$49:A119)+1,\"\")","v":""}]
[{"$f":"IF(B121<>\"\",MAX($A$49:A120)+1,\"\")","v":""}]
[{"$f":"IF(B122<>\"\",MAX($A$49:A121)+1,\"\")","v":""}]
[{"$f":"IF(B123<>\"\",MAX($A$49:A122)+1,\"\")","v":""}]
[{"$f":"IF(B124<>\"\",MAX($A$49:A123)+1,\"\")","v":""}]
[{"$f":"IF(B125<>\"\",MAX($A$49:A124)+1,\"\")","v":""}]
[{"$f":"IF(B126<>\"\",MAX($A$49:A125)+1,\"\")","v":""}]
[{"$f":"IF(B127<>\"\",MAX($A$49:A126)+1,\"\")","v":""}]
[{"$f":"IF(B128<>\"\",MAX($A$49:A127)+1,\"\")","v":""}]
["Subtotal E",null,null,null,null,null,null,{"$f":"SUM(H116:H128)","v":0},{"$f":"SUM(I116:I128)","v":0}]
["F. Adquisición de material fungible (de oficina, etc.)"]
[{"$f":"IF(B131<>\"\",MAX($A$13:A130)+1,\"\")","v":""}]
[{"$f":"IF(B132<>\"\",MAX($A$49:A131)+1,\"\")","v":""}]
[{"$f":"IF(B133<>\"\",MAX($A$49:A132)+1,\"\")","v":""}]
[{"$f":"IF(B134<>\"\",MAX($A$49:A133)+1,\"\")","v":""}]
[{"$f":"IF(B135<>\"\",MAX($A$49:A134)+1,\"\")","v":""}]
[{"$f":"IF(B136<>\"\",MAX($A$49:A135)+1,\"\")","v":""}]
[{"$f":"IF(B137<>\"\",MAX($A$49:A136)+1,\"\")","v":""}]
[{"$f":"IF(B138<>\"\",MAX($A$49:A137)+1,\"\")","v":""}]
[{"$f":"IF(B139<>\"\",MAX($A$49:A138)+1,\"\")","v":""}]
[{"$f":"IF(B140<>\"\",MAX($A$49:A139)+1,\"\")","v":""}]
[{"$f":"IF(B141<>\"\",MAX($A$49:A140)+1,\"\")","v":""}]
[{"$f":"IF(B142<>\"\",MAX($A$49:A141)+1,\"\")","v":""}]
[{"$f":"IF(B143<>\"\",MAX($A$49:A142)+1,\"\")","v":""}]
[{"$f":"IF(B144<>\"\",MAX($A$49:A143)+1,\"\")","v":""}]
[{"$f":"IF(B145<>\"\",MAX($A$49:A144)+1,\"\")","v":""}]
[{"$f":"IF(B146<>\"\",MAX($A$49:A145)+1,\"\")","v":""}]
[{"$f":"IF(B147<>\"\",MAX($A$49:A146)+1,\"\")","v":""}]
[{"$f":"IF(B148<>\"\",MAX($A$49:A147)+1,\"\")","v":""}]
[{"$f":"IF(B149<>\"\",MAX($A$49:A148)+1,\"\")","v":""}]
[{"$f":"IF(B150<>\"\",MAX($A$49:A149)+1,\"\")","v":""}]
[{"$f":"IF(B151<>\"\",MAX($A$49:A150)+1,\"\")","v":""}]
[{"$f":"IF(B152<>\"\",MAX($A$49:A151)+1,\"\")","v":""}]
[{"$f":"IF(B153<>\"\",MAX($A$49:A152)+1,\"\")","v":""}]
[{"$f":"IF(B154<>\"\",MAX($A$49:A153)+1,\"\")","v":""}]
[{"$f":"IF(B155<>\"\",MAX($A$49:A154)+1,\"\")","v":""}]
[{"$f":"IF(B156<>\"\",MAX($A$49:A155)+1,\"\")","v":""}]
["Subtotal F",null,null,null,null,null,null,{"$f":"SUM(H131:H156)","v":0},{"$f":"SUM(I131:I156)","v":0}]
["G. Transporte - Mensageria"]
[{"$f":"IF(B159<>\"\",MAX($A$13:A158)+1,\"\")","v":""}]
[{"$f":"IF(B160<>\"\",MAX($A$49:A159)+1,\"\")","v":""}]
[{"$f":"IF(B161<>\"\",MAX($A$49:A160)+1,\"\")","v":""}]
[{"$f":"IF(B162<>\"\",MAX($A$49:A161)+1,\"\")","v":""}]
[{"$f":"IF(B163<>\"\",MAX($A$49:A162)+1,\"\")","v":""}]
[{"$f":"IF(B164<>\"\",MAX($A$49:A163)+1,\"\")","v":""}]
[{"$f":"IF(B165<>\"\",MAX($A$49:A164)+1,\"\")","v":""}]
[{"$f":"IF(B166<>\"\",MAX($A$49:A165)+1,\"\")","v":""}]
[{"$f":"IF(B167<>\"\",MAX($A$49:A166)+1,\"\")","v":""}]
[{"$f":"IF(B168<>\"\",MAX($A$49:A167)+1,\"\")","v":""}]
[{"$f":"IF(B169<>\"\",MAX($A$49:A168)+1,\"\")","v":""}]
[{"$f":"IF(B170<>\"\",MAX($A$49:A169)+1,\"\")","v":""}]
[{"$f":"IF(B171<>\"\",MAX($A$49:A170)+1,\"\")","v":""}]
["Subtotal G",null,null,null,null,null,null,{"$f":"SUM(H159:H171)","v":0},{"$f":"SUM(I159:I171)","v":0}]
["H. Publicidad y Propaganda"]
[{"$f":"IF(B174<>\"\",MAX($A$13:A173)+1,\"\")","v":""}]
[{"$f":"IF(B175<>\"\",MAX($A$49:A174)+1,\"\")","v":""}]
[{"$f":"IF(B176<>\"\",MAX($A$49:A175)+1,\"\")","v":""}]
[{"$f":"IF(B177<>\"\",MAX($A$49:A176)+1,\"\")","v":""}]
[{"$f":"IF(B178<>\"\",MAX($A$49:A177)+1,\"\")","v":""}]
[{"$f":"IF(B179<>\"\",MAX($A$49:A178)+1,\"\")","v":""}]
[{"$f":"IF(B180<>\"\",MAX($A$49:A179)+1,\"\")","v":""}]
[{"$f":"IF(B181<>\"\",MAX($A$49:A180)+1,\"\")","v":""}]
[{"$f":"IF(B182<>\"\",MAX($A$49:A181)+1,\"\")","v":""}]
[{"$f":"IF(B183<>\"\",MAX($A$49:A182)+1,\"\")","v":""}]
[{"$f":"IF(B184<>\"\",MAX($A$49:A183)+1,\"\")","v":""}]
[{"$f":"IF(B185<>\"\",MAX($A$49:A184)+1,\"\")","v":""}]
[{"$f":"IF(B186<>\"\",MAX($A$49:A185)+1,\"\")","v":""}]
[{"$f":"IF(B187<>\"\",MAX($A$49:A186)+1,\"\")","v":""}]
[{"$f":"IF(B188<>\"\",MAX($A$49:A187)+1,\"\")","v":""}]
[{"$f":"IF(B189<>\"\",MAX($A$49:A188)+1,\"\")","v":""}]
["Subtotal H",null,null,null,null,null,null,{"$f":"SUM(H174:H189)","v":0},{"$f":"SUM(I174:I189)","v":0}]
["I. Seguros"]
[{"$f":"IF(B192<>\"\",MAX($A$13:A191)+1,\"\")","v":""}]
[{"$f":"IF(B193<>\"\",MAX($A$49:A192)+1,\"\")","v":""}]
[{"$f":"IF(B194<>\"\",MAX($A$49:A193)+1,\"\")","v":""}]
[{"$f":"IF(B195<>\"\",MAX($A$49:A194)+1,\"\")","v":""}]
[{"$f":"IF(B196<>\"\",MAX($A$49:A195)+1,\"\")","v":""}]
[{"$f":"IF(B197<>\"\",MAX($A$49:A196)+1,\"\")","v":""}]
[{"$f":"IF(B198<>\"\",MAX($A$49:A197)+1,\"\")","v":""}]
[{"$f":"IF(B199<>\"\",MAX($A$49:A198)+1,\"\")","v":""}]
[{"$f":"IF(B200<>\"\",MAX($A$49:A199)+1,\"\")","v":""}]
[{"$f":"IF(B201<>\"\",MAX($A$49:A200)+1,\"\")","v":""}]
["Subtotal I",null,null,null,null,null,null,{"$f":"SUM(H192:H201)","v":0},{"$f":"SUM(I192:I201)","v":0}]
["J. Alotjamiento y dietas (2)"]
[{"$f":"IF(B204<>\"\",MAX($A$13:A203)+1,\"\")","v":""}]
[{"$f":"IF(B205<>\"\",MAX($A$49:A204)+1,\"\")","v":""}]
[{"$f":"IF(B206<>\"\",MAX($A$49:A205)+1,\"\")","v":""}]
[{"$f":"IF(B207<>\"\",MAX($A$49:A206)+1,\"\")","v":""}]
[{"$f":"IF(B208<>\"\",MAX($A$49:A207)+1,\"\")","v":""}]
[{"$f":"IF(B209<>\"\",MAX($A$49:A208)+1,\"\")","v":""}]
[{"$f":"IF(B210<>\"\",MAX($A$49:A209)+1,\"\")","v":""}]
[{"$f":"IF(B211<>\"\",MAX($A$49:A210)+1,\"\")","v":""}]
[{"$f":"IF(B212<>\"\",MAX($A$49:A211)+1,\"\")","v":""}]
[{"$f":"IF(B213<>\"\",MAX($A$49:A212)+1,\"\")","v":""}]
[{"$f":"IF(B214<>\"\",MAX($A$49:A213)+1,\"\")","v":""}]
[{"$f":"IF(B215<>\"\",MAX($A$49:A214)+1,\"\")","v":""}]
[{"$f":"IF(B216<>\"\",MAX($A$49:A215)+1,\"\")","v":""}]
[{"$f":"IF(B217<>\"\",MAX($A$49:A216)+1,\"\")","v":""}]
["Subtotal J",null,null,null,null,null,null,{"$f":"SUM(H204:H217)","v":0},{"$f":"SUM(I204:I217)","v":0}]
["K. Viajes y desplazamientos (2)"]
[{"$f":"IF(B220<>\"\",MAX($A$13:A219)+1,\"\")","v":""}]
[{"$f":"IF(B221<>\"\",MAX($A$49:A220)+1,\"\")","v":""}]
[{"$f":"IF(B222<>\"\",MAX($A$49:A221)+1,\"\")","v":""}]
[{"$f":"IF(B223<>\"\",MAX($A$49:A222)+1,\"\")","v":""}]
[{"$f":"IF(B224<>\"\",MAX($A$49:A223)+1,\"\")","v":""}]
[{"$f":"IF(B225<>\"\",MAX($A$49:A224)+1,\"\")","v":""}]
[{"$f":"IF(B226<>\"\",MAX($A$49:A225)+1,\"\")","v":""}]
[{"$f":"IF(B227<>\"\",MAX($A$49:A226)+1,\"\")","v":""}]
[{"$f":"IF(B228<>\"\",MAX($A$49:A227)+1,\"\")","v":""}]
[{"$f":"IF(B229<>\"\",MAX($A$49:A228)+1,\"\")","v":""}]
[{"$f":"IF(B230<>\"\",MAX($A$49:A229)+1,\"\")","v":""}]
[{"$f":"IF(B231<>\"\",MAX($A$49:A230)+1,\"\")","v":""}]
[{"$f":"IF(B232<>\"\",MAX($A$49:A231)+1,\"\")","v":""}]
["Subtotal K",null,null,null,null,null,null,{"$f":"SUM(H220:H232)","v":0},{"$f":"SUM(I220:I232)","v":0}]
["L. Trabajos realitzados por empresas externas (limpieza, seguridad, otros trabajos directamente relacionados con la actividad y/o proyecto)"]
[{"$f":"IF(B235<>\"\",MAX($A$13:A234)+1,\"\")","v":""}]
[{"$f":"IF(B236<>\"\",MAX($A$49:A235)+1,\"\")","v":""}]
[{"$f":"IF(B237<>\"\",MAX($A$49:A236)+1,\"\")","v":""}]
[{"$f":"IF(B238<>\"\",MAX($A$49:A237)+1,\"\")","v":""}]
[{"$f":"IF(B239<>\"\",MAX($A$49:A238)+1,\"\")","v":""}]
[{"$f":"IF(B240<>\"\",MAX($A$49:A239)+1,\"\")","v":""}]
[{"$f":"IF(B241<>\"\",MAX($A$49:A240)+1,\"\")","v":""}]
[{"$f":"IF(B242<>\"\",MAX($A$49:A241)+1,\"\")","v":""}]
[{"$f":"IF(B243<>\"\",MAX($A$49:A242)+1,\"\")","v":""}]
[{"$f":"IF(B244<>\"\",MAX($A$49:A243)+1,\"\")","v":""}]
[{"$f":"IF(B245<>\"\",MAX($A$49:A244)+1,\"\")","v":""}]
[{"$f":"IF(B246<>\"\",MAX($A$49:A245)+1,\"\")","v":""}]
[{"$f":"IF(B247<>\"\",MAX($A$49:A246)+1,\"\")","v":""}]
[{"$f":"IF(B248<>\"\",MAX($A$49:A247)+1,\"\")","v":""}]
[{"$f":"IF(B249<>\"\",MAX($A$49:A248)+1,\"\")","v":""}]
["Subtotal L",null,null,null,null,null,null,{"$f":"SUM(H235:H249)","v":0},{"$f":"SUM(I235:I249)","v":0}]
["M. Otros gastos (a especificar)"]
[{"$f":"IF(B252<>\"\",MAX($A$13:A251)+1,\"\")","v":""}]
[{"$f":"IF(B253<>\"\",MAX($A$49:A252)+1,\"\")","v":""}]
[{"$f":"IF(B254<>\"\",MAX($A$49:A253)+1,\"\")","v":""}]
[{"$f":"IF(B255<>\"\",MAX($A$49:A254)+1,\"\")","v":""}]
[{"$f":"IF(B256<>\"\",MAX($A$49:A255)+1,\"\")","v":""}]
[{"$f":"IF(B257<>\"\",MAX($A$49:A256)+1,\"\")","v":""}]
[{"$f":"IF(B258<>\"\",MAX($A$49:A257)+1,\"\")","v":""}]
[{"$f":"IF(B259<>\"\",MAX($A$49:A258)+1,\"\")","v":""}]
[{"$f":"IF(B260<>\"\",MAX($A$49:A259)+1,\"\")","v":""}]
[{"$f":"IF(B261<>\"\",MAX($A$49:A260)+1,\"\")","v":""}]
[{"$f":"IF(B262<>\"\",MAX($A$49:A261)+1,\"\")","v":""}]
[{"$f":"IF(B263<>\"\",MAX($A$49:A262)+1,\"\")","v":""}]
[{"$f":"IF(B264<>\"\",MAX($A$49:A263)+1,\"\")","v":""}]
[{"$f":"IF(B265<>\"\",MAX($A$49:A264)+1,\"\")","v":""}]
[{"$f":"IF(B266<>\"\",MAX($A$49:A265)+1,\"\")","v":""}]
[{"$f":"IF(B267<>\"\",MAX($A$49:A266)+1,\"\")","v":""}]
[{"$f":"IF(B268<>\"\",MAX($A$49:A267)+1,\"\")","v":""}]
[{"$f":"IF(B269<>\"\",MAX($A$49:A268)+1,\"\")","v":""}]
[{"$f":"IF(B270<>\"\",MAX($A$49:A269)+1,\"\")","v":""}]
[{"$f":"IF(B271<>\"\",MAX($A$49:A270)+1,\"\")","v":""}]
[{"$f":"IF(B272<>\"\",MAX($A$49:A271)+1,\"\")","v":""}]
[{"$f":"IF(B273<>\"\",MAX($A$49:A272)+1,\"\")","v":""}]
[{"$f":"IF(B274<>\"\",MAX($A$49:A273)+1,\"\")","v":""}]
[{"$f":"IF(B275<>\"\",MAX($A$49:A274)+1,\"\")","v":""}]
["Subtotal M",null,null,null,null,null,null,{"$f":"SUM(H252:H275)","v":0},{"$f":"SUM(I252:I275)","v":0}]
["TOTAL DE GASTOS",null,null,null,null,null,"TOTAL",{"$f":"+H48+H88+H98+H114+H129+H157+H172+H190+H202+H218+H233+H250+H276","v":0},{"$f":"+I48+I88+I98+I114+I129+I157+I172+I190+I202+I218+I233+I250+I276","v":0}]
[]
["El Sr./Sra. (indicar el nombre y apellidos de la persona representante que firma la justificación)  con DNI/NIE (indicar el núm. DNI) en calidad de persona física beneficiaria o representante legal de la persona jurídica beneficiaria (indicar nombre y apellidos) con NIF (indicar núm DNI)."]
["CERTIFICA que los recibos/tiquets que se han identificado como tales en el campo de observaciones corresponden a gastos generados para la nombrada actividad, que por sus imports y características no han podido ser objecto de factura; que los justificantes relacionados imputados al proyecto/actividad/servicio subvencionado durante su periodo de ejecución han sido efectivamente pagados; que custodiará la documentació que lo acredita; que esta documentación se encuentra a disposición del Ajuntament de Barcelona o de otros entes municipales en los archivos de esta entidad, durante un periodo mínimo de 4 años a contar desde la fecha de presentación de la present justificación."]
[]
[]
[null,"Población y fecha: ",null,null,null,"Firma y sello"]
[]
["Notas:"]
["(*) Se deben relacionar todos los gastos del proyecto/actividad/servicio subvencionado. En caso de que el número de filas de cada concepto sea insuficiente puede insertar líneas dentro del mismo concepto seleccionando una celda verde y haciendo click sobre el botón de insertar linea."]
["(0) El número de orden ha de ser correlativo comenzando por 1"]
["(1) Respecto a los gastos de recursos humanos, puede ser subvencionable el coste total salarial mensual, que corresponde a la suma de la retribución bruta que aparece en la nómina del trabajador/a más la cuota de la empresa a la Seg. Social. Los gastos de personal se justifican amb la nòmina del trabajador acompañada de los correspondientes TC1 y TC2 de la TGSS y el modelo 111 del IRPF."]
["(2) En caso de que el documento justificativo del resto de gastos, no sea una factura, sino un otro document probatorio equivalente, como un recibo o justificante (como por dietas o transporte público), indiquelo en el campo de observaciones."]
[]
["(3) En caso de que un justificante incluya conceptos que no tienen que ver con el proyecto/actividad/servicio por el que se ha otorgado la subvención, aquí solo se ha de indicar la parte que realmente se ha dedicado al proyecto."]
[]
["(4) En esta columna se ha de indicar el importe total o parcial de la factura  que se imputa a la subvención recibida del Ajuntament de Barcelona/IBE/ICUB/IMD. El total imputado, en esta columna, ha de ser igual  al importe de la subvención recibida."]

{"sheet":"Relació d'ingressos ","index":1,"n_rows":128,"n_cols":10,"rows_kept":128,"cut":false,"hidden":false,"merged":[[112,6,112,9],[108,6,108,9],[106,6,106,9],[103,6,103,9],[114,6,114,9],[114,0,114,3],[113,0,113,3],[116,0,116,9],[117,0,118,9],[113,6,113,9],[94,0,94,9],[101,0,101,9],[90,6,90,9],[100,6,100,9],[102,6,102,9],[100,0,100,3],[93,0,93,3],[91,6,91,9],[99,6,99,9],[97,6,97,9],[96,6,96,9],[95,6,95,9],[73,6,73,9],[72,6,72,9],[85,6,85,9],[84,6,84,9],[83,6,83,9],[81,6,81,9],[80,6,80,9],[79,6,79,9],[78,6,78,9],[49,6,49,9],[44,6,44,9],[43,6,43,9],[42,6,42,9],[41,6,41,9],[0,0,0,9],[15,0,15,9],[40,0,40,9],[51,0,51,9],[12,6,13,9],[16,6,16,9],[17,6,17,9],[12,0,13,0],[21,6,21,9],[38,6,38,9],[3,2,3,3],[2,2,2,3],[9,0,9,3],[4,2,4,3],[12,2,12,3],[12,1,13,1],[39,0,39,3],[85,0,85,3],[63,0,63,9],[71,0,71,9],[77,0,77,9],[76,0,76,3],[70,0,70,3],[39,6,39,9],[50,6,50,9],[65,6,65,9],[64,6,64,9],[76,6,76,9],[75,6,75,9],[66,6,66,9],[70,6,70,9],[69,6,69,9],[89,6,89,9],[62,0,62,3],[93,6,93,9],[92,6,92,9],[50,0,50,3],[86,0,86,9],[88,6,88,9],[87,6,87,9],[68,6,68,9],[67,6,67,9],[62,6,62,9],[61,6,61,9],[54,6,54,9],[53,6,53,9],[52,6,52,9],[74,6,74,9]]}
["Detall de tots els ingressos obtinguts i aportacions del propi beneficiari per a l'execució de l'activitat subvencionada"]
[]
[null,"Nombre de la persona física/jurídica beneficiaria:        ",{"$f":"IF('Relació de despeses'!C3:D3<>\"\",'Relació de despeses'!C3:D3,\"\")","v":""},null,"Importe total del proyecto :",null,null,{"$f":"IF(+'Relació de despeses'!H3=\"\",\"\",+'Relació de despeses'!H3)","v":""},"euros"]
[null,"Código de subvención",{"$f":"IF('Relació de despeses'!C4:D4<>\"\",'Relació de despeses'!C4:D4,\"\")","v":""},null,"Importe de la subvención otorgada:",null,null,{"$f":"IF(+'Relació de despeses'!H4=\"\",\"\",+'Relació de despeses'!H4)","v":""},"euros"]
[null,"Nombre del proyecto subvencionado",{"$f":"IF('Relació de despeses'!C5:D5<>\"\",'Relació de despeses'!C5:D5,\"\")","v":""},null,"Periodo de ejecución del proyecto subvencionado:",null,null,{"$f":"IF(+'Relació de despeses'!H5=\"\",\"\",+'Relació de despeses'!H5)","v":"2020-01-01"},"a",{"$f":"IF(+'Relació de despeses'!L5=\"\",\"\",+'Relació de despeses'!L5)","v":"2021-12-31"}]
[]
[]
[]
[]
["Ingressos del projecte/activitat/servei subvencionat"]
[]
[]
["número de órden (0)","Concepto del ingreso","Emisor del ingreso",null,"Fecha de cobro\n(dd/mm/aaaa)","Importe","Observaciones"]
[null,null,"NIF","Nombre","(2)","euros"]
[]
["A. Subvenciones del Ayuntamiento de Barcelona (1)"]
[{"$f":"IF(B17<>\"\",1,\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(B25<>\"\",MAX($A$16:A24)+1,\"\")","v":""}]
[{"$f":"IF(B26<>\"\",MAX($A$16:A25)+1,\"\")","v":""}]
[{"$f":"IF(B27<>\"\",MAX($A$16:A26)+1,\"\")","v":""}]
[{"$f":"IF(B28<>\"\",MAX($A$16:A27)+1,\"\")","v":""}]
[{"$f":"IF(B29<>\"\",MAX($A$16:A28)+1,\"\")","v":""}]
[{"$f":"IF(B30<>\"\",MAX($A$16:A29)+1,\"\")","v":""}]
[{"$f":"IF(B31<>\"\",MAX($A$16:A30)+1,\"\")","v":""}]
[{"$f":"IF(B32<>\"\",MAX($A$16:A31)+1,\"\")","v":""}]
[{"$f":"IF(B33<>\"\",MAX($A$16:A32)+1,\"\")","v":""}]
[{"$f":"IF(B34<>\"\",MAX($A$16:A33)+1,\"\")","v":""}]
[{"$f":"IF(B35<>\"\",MAX($A$16:A34)+1,\"\")","v":""}]
[{"$f":"IF(B36<>\"\",MAX($A$16:A35)+1,\"\")","v":""}]
[{"$f":"IF(B37<>\"\",MAX($A$16:A36)+1,\"\")","v":""}]
[{"$f":"IF(B38<>\"\",MAX($A$16:A37)+1,\"\")","v":""}]
[{"$f":"IF(B39<>\"\",MAX($A$16:A38)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal A",{"$f":"SUM(F17:F39)","v":0}]
["B. Subvenciones de otras administraciones"]
[{"$f":"IF(B42<>\"\",MAX($A$16:A41)+1,\"\")","v":""}]
[]
[{"$f":"IF(B44<>\"\",MAX($A$16:A43)+1,\"\")","v":""}]
[{"$f":"IF(B45<>\"\",MAX($A$16:A44)+1,\"\")","v":""}]
[{"$f":"IF(B46<>\"\",MAX($A$16:A45)+1,\"\")","v":""}]
[{"$f":"IF(B47<>\"\",MAX($A$16:A46)+1,\"\")","v":""}]
[{"$f":"IF(B48<>\"\",MAX($A$16:A47)+1,\"\")","v":""}]
[{"$f":"IF(B49<>\"\",MAX($A$16:A48)+1,\"\")","v":""}]
[{"$f":"IF(B50<>\"\",MAX($A$16:A49)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal B",{"$f":"SUM(F42:F50)","v":0}]
["C. Aportaciones de entes privados"]
[{"$f":"IF(B53<>\"\",MAX($A$16:A52)+1,\"\")","v":""}]
[{"$f":"IF(B54<>\"\",MAX($A$16:A53)+1,\"\")","v":""}]
[{"$f":"IF(B55<>\"\",MAX($A$16:A54)+1,\"\")","v":""}]
[{"$f":"IF(B56<>\"\",MAX($A$16:A55)+1,\"\")","v":""}]
[{"$f":"IF(B57<>\"\",MAX($A$16:A56)+1,\"\")","v":""}]
[{"$f":"IF(B58<>\"\",MAX($A$16:A57)+1,\"\")","v":""}]
[{"$f":"IF(B59<>\"\",MAX($A$16:A58)+1,\"\")","v":""}]
[{"$f":"IF(B60<>\"\",MAX($A$16:A59)+1,\"\")","v":""}]
[{"$f":"IF(B61<>\"\",MAX($A$16:A60)+1,\"\")","v":""}]
[{"$f":"IF(B62<>\"\",MAX($A$16:A61)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal C",{"$f":"SUM(F53:F62)","v":0}]
["D. Recursos propios de la entidad"]
[{"$f":"IF(B65<>\"\",MAX($A$16:A64)+1,\"\")","v":""}]
[{"$f":"IF(B66<>\"\",MAX($A$16:A65)+1,\"\")","v":""}]
[{"$f":"IF(B67<>\"\",MAX($A$16:A66)+1,\"\")","v":""}]
[{"$f":"IF(B68<>\"\",MAX($A$16:A67)+1,\"\")","v":""}]
[{"$f":"IF(B69<>\"\",MAX($A$16:A68)+1,\"\")","v":""}]
[{"$f":"IF(B70<>\"\",MAX($A$16:A69)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal D",{"$f":"SUM(F65:F70)","v":0}]
["E. Taquillage"]
[{"$f":"IF(B73<>\"\",MAX($A$16:A72)+1,\"\")","v":""}]
[{"$f":"IF(B74<>\"\",MAX($A$16:A73)+1,\"\")","v":""}]
[{"$f":"IF(B75<>\"\",MAX($A$16:A74)+1,\"\")","v":""}]
[{"$f":"IF(B76<>\"\",MAX($A$16:A75)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal E",{"$f":"SUM(F73:F76)","v":0}]
["F. Cuotas de inscripción"]
[{"$f":"IF(B79<>\"\",MAX($A$16:A78)+1,\"\")","v":""}]
[{"$f":"IF(B80<>\"\",MAX($A$16:A79)+1,\"\")","v":""}]
[{"$f":"IF(B81<>\"\",MAX($A$16:A80)+1,\"\")","v":""}]
[{"$f":"IF(B82<>\"\",MAX($A$16:A81)+1,\"\")","v":""}]
[{"$f":"IF(B83<>\"\",MAX($A$16:A82)+1,\"\")","v":""}]
[{"$f":"IF(B84<>\"\",MAX($A$16:A83)+1,\"\")","v":""}]
[{"$f":"IF(B85<>\"\",MAX($A$16:A84)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal F",{"$f":"SUM(F79:F85)","v":0}]
["G. Venta de Productos"]
[{"$f":"IF(B88<>\"\",MAX($A$16:A87)+1,\"\")","v":""}]
[{"$f":"IF(B89<>\"\",MAX($A$16:A88)+1,\"\")","v":""}]
[{"$f":"IF(B90<>\"\",MAX($A$16:A89)+1,\"\")","v":""}]
[{"$f":"IF(B91<>\"\",MAX($A$16:A90)+1,\"\")","v":""}]
[{"$f":"IF(B92<>\"\",MAX($A$16:A91)+1,\"\")","v":""}]
[{"$f":"IF(B93<>\"\",MAX($A$16:A92)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal G",{"$f":"SUM(F88:F93)","v":0}]
["H. Publicidad y/o Esponsorización"]
[{"$f":"IF(B96<>\"\",MAX($A$16:A95)+1,\"\")","v":""}]
[{"$f":"IF(B97<>\"\",MAX($A$16:A96)+1,\"\")","v":""}]
[{"$f":"IF(B98<>\"\",MAX($A$16:A97)+1,\"\")","v":""}]
[{"$f":"IF(B99<>\"\",MAX($A$16:A98)+1,\"\")","v":""}]
[{"$f":"IF(B100<>\"\",MAX($A$16:A99)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal H",{"$f":"SUM(F96:F100)","v":0}]
["I. Otros ingresos"]
[{"$f":"IF(B103<>\"\",MAX($A$16:A102)+1,\"\")","v":""}]
[{"$f":"IF(B104<>\"\",MAX($A$16:A103)+1,\"\")","v":""}]
[{"$f":"IF(B105<>\"\",MAX($A$16:A104)+1,\"\")","v":""}]
[{"$f":"IF(B106<>\"\",MAX($A$16:A105)+1,\"\")","v":""}]
[{"$f":"IF(B107<>\"\",MAX($A$16:A106)+1,\"\")","v":""}]
[{"$f":"IF(B108<>\"\",MAX($A$16:A107)+1,\"\")","v":""}]
[{"$f":"IF(B109<>\"\",MAX($A$16:A108)+1,\"\")","v":""}]
[{"$f":"IF(B110<>\"\",MAX($A$16:A109)+1,\"\")","v":""}]
[{"$f":"IF(B111<>\"\",MAX($A$16:A110)+1,\"\")","v":""}]
[{"$f":"IF(B112<>\"\",MAX($A$16:A111)+1,\"\")","v":""}]
[{"$f":"IF(B113<>\"\",MAX($A$16:A112)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal I",{"$f":"SUM(F103:F113)","v":0}]
["Total INGRESOS",null,null,null,"TOTAL",{"$f":"+F40+F51+F63+F71+F77+F86+F94+F101+F114","v":0}]
[]
[{"$f":"'Relació de despeses'!A279:L279","v":"El Sr./Sra. (indicar el nombre y apellidos de la persona representante que firma la justificación)  con DNI/NIE (indicar el núm. DNI) en calidad de persona física beneficiaria o representante legal de la persona jurídica beneficiaria (indicar nombre y apellidos) con NIF (indicar núm DNI)."}]
["CERTIFICA que los ingresos imputados al proyecto/actividad/servicio subvencionado han sido efectivamente ingresados; que custodiará la documentació que lo acredita; que esta documentación se encuentra a disposición del Ajuntament de Barcelona o de los otros entes municipales en los archivos de esta Entitat, durante un periodo mínimo de 4 sños a contar desde la fecha de presentación de la presente justificación."]
[]
[]
[]
[]
[null,"Población y fecha: "]
[]
[null,"Nota:"]
[null,"(0) El número de orden ha de ser correlativo comenzando por el número 1"]
[null,"(1) Si por parte del Ajuntament solo se ha recibido subvención de un sector o distrito o instituto, ses puede borrar el resto, que se han indicado a modo de ejemplo."]
[null,"(2) En caso de que el ingreso este pendiente de cobro, indicar \"P. Cobro\" "]

{"sheet":"Resum estat despeses-ingressos","index":2,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":false,"merged":[[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[24,0,24,8],[25,0,31,10],[33,0,33,10],[41,0,41,10],[34,0,35,10],[37,0,37,1],[47,0,47,10],[42,0,42,10],[43,0,43,10],[44,0,44,10],[45,0,45,10],[46,0,46,10],[11,5,11,6],[5,0,5,3],[20,7,20,8],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[19,5,19,6],[17,5,17,6],[16,5,16,6],[7,0,7,1],[8,0,8,1],[9,0,9,1],[20,5,20,6],[20,0,20,1],[15,0,15,1],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,5,5,8],[2,0,2,1],[3,0,3,1],[2,5,2,6],[3,5,3,6],[6,5,6,6],[2,2,2,3],[3,2,3,3],[4,2,4,3],[4,0,4,1],[6,0,6,1]]}
["Estado de los gastos realizados y de los ingresos obtenidos para la ejecución de la actividad subvencionada (*)"]
[]
["Persona física/jurídica beneficiaria:         ",null,{"$f":"IF('Relació de despeses'!C3:D3<>\"\",'Relació de despeses'!C3:D3,\"\")","v":""},null,null,"Importe total del proyecto:",null,{"$f":"IF(+'Relació de despeses'!H3=\"\",\"\",+'Relació de despeses'!H3)","v":""},"euros"]
["Código de subvención:",null,{"$f":"IF('Relació de despeses'!C4:D4<>\"\",'Relació de despeses'!C4:D4,\"\")","v":""},null,null,"Importe de la subvención otorgada:",null,{"$f":"IF(+'Relació de despeses'!H4=\"\",\"\",+'Relació de despeses'!H4)","v":""},"euros"]
["Nombre del proyecto subvencionado:",null,{"$f":"IF('Relació de despeses'!C5:D5<>\"\",'Relació de despeses'!C5:D5,\"\")","v":""},null,null,"Periodo de ejecución del proyecto subvencionado:",null,null,{"$f":"IF(+'Relació de despeses'!H5=\"\",\"\",+'Relació de despeses'!H5)","v":"2020-01-01"},"a",{"$f":"IF(+'Relació de despeses'!L5=\"\",\"\",+'Relació de despeses'!L5)","v":"2021-12-31"}]
["Gastos del proyecto/actividad/servicio subvencionado",null,null,null,null,"Ingresos del proyecto/actividad/servicio subvencionado"]
["Concepto",null,"Previsión inicial o reformulación ya aprobada (1)","Gastos realizados\n(2)",null,"Concepto",null,"Previsión inicial o reformulación ya aprobada (1)","Ingresos obtenidos\n(3)"]
["A. Recursos Humanos \n(retribuciones, S.Social)",null,null,{"$f":"'Relació de despeses'!H48","v":0},null,"A. Subvenciones municipales",null,null,{"$f":"'Relació d''ingressos '!F40","v":0}]
["B. Aquileres \n(materiales, infraestructuras etc.)",null,null,{"$f":"'Relació de despeses'!H88","v":0},null,"B. Subvenciones de otras administraciones",null,null,{"$f":"'Relació d''ingressos '!F51","v":0}]
["C. Suministros \n(electricidad, agua, gas)",null,null,{"$f":"'Relació de despeses'!H98","v":0},null,"C. Aportaciones de entes privados",null,null,{"$f":"'Relació d''ingressos '!F63","v":0}]
["D. Comunicaciones (teléfono, fax, correos)",null,null,{"$f":"'Relació de despeses'!H114","v":0},null,"D. Recursos propios de la persona jurídica (la entidad)",null,null,{"$f":"'Relació d''ingressos '!F71","v":0}]
["E. Mantenimiento de edificios y/o instalaciones",null,null,{"$f":"'Relació de despeses'!H129","v":0},null,"E. Taquillaje",null,null,{"$f":"'Relació d''ingressos '!F77","v":0}]
["F. Adquisición de material fungible\n(de oficina, etc.)",null,null,{"$f":"'Relació de despeses'!H157","v":0},null,"F. Cuotas de inscripción",null,null,{"$f":"'Relació d''ingressos '!F86","v":0}]
["G. Transporte - Mensageria",null,null,{"$f":"'Relació de despeses'!H172","v":0},null,"G. Venta de Productos",null,null,{"$f":"'Relació d''ingressos '!F94","v":0}]
["H. Publicidad y Propaganda",null,null,{"$f":"'Relació de despeses'!H190","v":0},null,"H. Publicidad y/o Esponsorización",null,null,{"$f":"'Relació d''ingressos '!F101","v":0}]
["I. Seguross",null,null,{"$f":"'Relació de despeses'!H202","v":0},null,"I. Otros ingresos",null,null,{"$f":"'Relació d''ingressos '!F114","v":0}]
["J. Alojamiento y dietas",null,null,{"$f":"'Relació de despeses'!H218","v":0},null,"Total Ingresos",null,{"$f":"SUM(H8:H16)","v":0},{"$f":"SUM(I8:I16)","v":0}]
["K. Viajes y desplazamientos",null,null,{"$f":"'Relació de despeses'!H233","v":0},null,"% financiación municipal (5)",null,{"$f":"IF(H8=\"\",\"- %\",+H8/H17)","v":"- %"},{"$f":"IF(I8=\"\",\"- %\",+I8/I17)","v":{"$error":"#DIV/0!"}}]
["L. Trabajos realizados por empresas externas\n(limpieza, seguridad, otros directamente relacionados con el proyecto)",null,null,{"$f":"'Relació de despeses'!H250","v":0},null,null,null,"Previsión inicial","Real"]
["M. Otros gastos (no incluidod en niguno de los apartados anteriores, como por ejemplo amortizaciones de los bienes adquiridos, etc)",null,null,{"$f":"'Relació de despeses'!H276","v":0},null,"Diferencia Ingresos - Gastos ",null,{"$f":"+H17-B21","v":0},{"$f":"+I17-D21","v":0}]
["Total gastos",null,{"$f":"SUM(C8:C20)","v":0},{"$f":"SUM(D8:D20)","v":0},null,"Desviación de Gastos (4)",null,"Desviación de ingresos (4)"]
[null,null,null,null,null,"Importe"," % (6)","Importe","%"]
[null,null,null,null,null,{"$f":"+D21-C21","v":0},{"$f":"+F23/C21","v":{"$error":"#DIV/0!"}},{"$f":"+I17-H17","v":0},{"$f":"+H23/H17","v":{"$error":"#DIV/0!"}}]
[]
["Explicar los motivos por los cuales existe una desviación entre el gasto previsto en la solicitud de subvención y la finalmente realizada, así como entre los ingresos previstos y los obtenidos."]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"+'Relació de despeses'!A279:M279","v":"El Sr./Sra. (indicar el nombre y apellidos de la persona representante que firma la justificación)  con DNI/NIE (indicar el núm. DNI) en calidad de persona física beneficiaria o representante legal de la persona jurídica beneficiaria (indicar nombre y apellidos) con NIF (indicar núm DNI)."}]
["DECLARA que en relación al proyecto/actividad/servicio subvencionado se han producido los ingressos y gastos que figuran en el presente documento y que las desviaciones respecto al presupuesto inicial se han producido por las motivacions a arriba mencionadas y para que así conste, a efectos de justificar el cumplimento del objeto de la subvención concedida, firmo la presente declaración responsable."]
[]
[]
["Población y fecha: "]
[]
[]
["Notas:"]
["(*) Las columnas sombreadas en color  se iran rellenando automáticamente a partir de los datos introducidos en los documentos de gastos -detalle e ingresos-detalle. Por tanto, no imprima esta hoja hasta haber rellenado las otras."]
["(1) Previsión inicial o reformulación ya aprovada= Se deben indicar la previsión inicial de gastos y de ingresos según aquello que se indicó en el proyecto original en el \"plan de viabilidad económica del proyecto - presupuesto general\" . En el caso de que ya se haya aprovado una reformulación, se deben indicar las cantidades reformuladas. "]
["(2) Gastos reales = Coste real total del proyecto subvencionado. Automáticamente se introducirán los subtotales de los gastos relacionados en la hoja gastos detalle."]
["(3) Ingresos reales = Total de ingresos obtenidos para la realización del proyecto subvencionado. Automáticamente se introducirán los subtotales de los ingresos relacionados en la hoja Ingresos-detalle"]
["(4) Desviación: En el caso de los gastos, la desviación es la diferencia entre gastos reales y la previsión inicial de gastos; y en el caso de ingresos, la diferencia entre los ingresos reales y la previsión inicial de ingresos. "]
["(5) % financiación municipal = porcentaje que suponen las subvenciones municipales (A) respecto del  total de ingresos del proyecto subvencionado."]
["(6) El % de la desviación final de gastos se calcula dividiendo el importe resultante de gastps reales - gastos previstos, entre el total de gastos previstos y de la misma manera los ingresos, En caso de existir una desviación siempre se ha de motivar."]

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