{"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":289,"n_cols":13,"rows_kept":289,"cut":false,"hidden":false,"merged":[[200,0,200,12],[231,0,231,12],[216,0,216,12],[248,0,248,12],[9,0,9,12],[46,0,46,12],[86,0,86,12],[96,0,96,12],[155,0,155,12],[127,0,127,12],[170,0,170,12],[112,0,112,12],[188,0,188,12],[0,0,0,11],[4,0,4,1],[45,0,45,6],[2,2,2,3],[3,2,3,3],[4,2,4,3],[10,10,10,11],[2,0,2,1],[111,10,111,11],[2,4,2,6],[3,4,3,6],[4,4,4,6],[110,10,110,11],[100,10,100,11],[99,10,99,11],[98,10,98,11],[7,2,8,2],[11,10,11,11],[2,7,2,8],[3,7,3,8],[4,7,4,9],[201,10,201,11],[202,10,202,11],[214,10,214,11],[189,10,189,11],[190,10,190,11],[111,0,111,6],[87,10,87,11],[12,10,12,11],[116,10,116,11],[115,10,115,11],[114,10,114,11],[15,10,15,11],[14,10,14,11],[13,10,13,11],[45,10,45,11],[97,10,97,11],[95,10,95,11],[94,10,94,11],[90,10,90,11],[89,10,89,11],[88,10,88,11],[232,10,232,11],[233,10,233,11],[246,10,246,11],[247,10,247,11],[217,10,217,11],[218,10,218,11],[229,10,229,11],[230,10,230,11],[249,10,249,11],[280,1,280,3],[280,5,280,11],[247,0,247,6],[215,0,215,6],[85,0,85,6],[95,0,95,6],[85,10,85,11],[84,10,84,11],[51,10,51,11],[50,10,50,11],[49,10,49,11],[273,10,273,11],[274,10,274,11],[274,0,274,5],[250,10,250,11],[173,10,173,11],[172,10,172,11],[169,10,169,11],[230,0,230,6],[272,10,272,11],[168,10,168,11],[159,10,159,11],[158,10,158,11],[283,0,283,11],[3,0,3,1],[7,1,8,1],[7,0,8,0],[6,0,6,4],[273,0,273,6],[215,10,215,11],[156,10,156,11],[187,10,187,11],[186,10,186,11],[157,10,157,11],[113,10,113,11],[154,10,154,11],[153,10,153,11],[131,10,131,11],[130,10,130,11],[129,10,129,11],[128,10,128,11],[126,10,126,11],[125,10,125,11],[276,0,276,11],[277,0,277,11],[198,10,198,11],[199,10,199,11],[288,0,288,11],[287,0,287,11],[7,10,7,11],[8,10,8,11],[44,10,44,11],[187,0,187,6],[169,0,169,6],[154,0,154,6],[48,10,48,11],[47,10,47,11],[7,3,7,4],[199,0,199,6],[126,0,126,6],[285,0,285,11],[286,0,286,11]]}
["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,"euros"]
["Codi de subvenció:",null,null,null,"Import de la subvenció atorgada:",null,null,null,null,null,"euros"]
["Nom del projecte subvencionat:",null,null,null,"Període d'execució del projecte subvencionat:",null,null,"2022-01-01",null,null,"a","2023-12-31"]
[]
["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)","Activitat a la que s'ha d'imputar l'import","Observacions",null,"Any "]
[null,null,null,"NIF","Nom","dd/mm/aaaa","euros","euros","euros",null,"(2)"]
["A. Recursos Humans (retribucions brutes i Seguretat Social del personal fix o eventual contractat)"]
[{"$f":"IF(B11<>\"\",1,\"\")","v":""}]
[{"$f":"IF(B12<>\"\",MAX($A$11:A11)+1,\"\")","v":""}]
[{"$f":"IF(B13<>\"\",MAX($A$11:A12)+1,\"\")","v":""}]
[{"$f":"IF(B14<>\"\",MAX($A$11:A13)+1,\"\")","v":""}]
[{"$f":"IF(B15<>\"\",MAX($A$11:A14)+1,\"\")","v":""}]
[{"$f":"IF(B16<>\"\",MAX($A$11:A15)+1,\"\")","v":""}]
[{"$f":"IF(B17<>\"\",MAX($A$11:A16)+1,\"\")","v":""}]
[{"$f":"IF(B18<>\"\",MAX($A$11:A17)+1,\"\")","v":""}]
[{"$f":"IF(B19<>\"\",MAX($A$11:A18)+1,\"\")","v":""}]
[{"$f":"IF(B20<>\"\",MAX($A$11:A19)+1,\"\")","v":""}]
[{"$f":"IF(B21<>\"\",MAX($A$11:A20)+1,\"\")","v":""}]
[{"$f":"IF(B22<>\"\",MAX($A$11:A21)+1,\"\")","v":""}]
[{"$f":"IF(B23<>\"\",MAX($A$11:A22)+1,\"\")","v":""}]
[{"$f":"IF(B24<>\"\",MAX($A$11:A23)+1,\"\")","v":""}]
[{"$f":"IF(B25<>\"\",MAX($A$11:A24)+1,\"\")","v":""}]
[{"$f":"IF(B26<>\"\",MAX($A$11:A25)+1,\"\")","v":""}]
[{"$f":"IF(B27<>\"\",MAX($A$11:A26)+1,\"\")","v":""}]
[{"$f":"IF(B28<>\"\",MAX($A$11:A27)+1,\"\")","v":""}]
[{"$f":"IF(B29<>\"\",MAX($A$11:A28)+1,\"\")","v":""}]
[{"$f":"IF(B30<>\"\",MAX($A$11:A29)+1,\"\")","v":""}]
[{"$f":"IF(B31<>\"\",MAX($A$11:A30)+1,\"\")","v":""}]
[{"$f":"IF(B32<>\"\",MAX($A$11:A31)+1,\"\")","v":""}]
[{"$f":"IF(B33<>\"\",MAX($A$11:A32)+1,\"\")","v":""}]
[{"$f":"IF(B34<>\"\",MAX($A$11:A33)+1,\"\")","v":""}]
[{"$f":"IF(B35<>\"\",MAX($A$11:A34)+1,\"\")","v":""}]
[{"$f":"IF(B36<>\"\",MAX($A$11:A35)+1,\"\")","v":""}]
[{"$f":"IF(B37<>\"\",MAX($A$11:A36)+1,\"\")","v":""}]
[{"$f":"IF(B38<>\"\",MAX($A$11:A37)+1,\"\")","v":""}]
[{"$f":"IF(B39<>\"\",MAX($A$11:A38)+1,\"\")","v":""}]
[{"$f":"IF(B40<>\"\",MAX($A$11:A39)+1,\"\")","v":""}]
[{"$f":"IF(B41<>\"\",MAX($A$11:A40)+1,\"\")","v":""}]
[{"$f":"IF(B42<>\"\",MAX($A$11:A41)+1,\"\")","v":""}]
[{"$f":"IF(B43<>\"\",MAX($A$11:A42)+1,\"\")","v":""}]
[{"$f":"IF(B44<>\"\",MAX($A$11:A43)+1,\"\")","v":""}]
[{"$f":"IF(B45<>\"\",MAX($A$11:A44)+1,\"\")","v":""}]
["Subtotal A",null,null,null,null,null,null,{"$f":"SUM(H11:H45)","v":0},{"$f":"SUM(I11:I45)","v":0}]
["B. Lloguers (materials, infraestructures)"]
[{"$f":"IF(B48<>\"\",MAX($A$11:A47)+1,\"\")","v":""}]
[{"$f":"IF(B49<>\"\",MAX($A$47:A48)+1,\"\")","v":""}]
[{"$f":"IF(B50<>\"\",MAX($A$47:A49)+1,\"\")","v":""}]
[{"$f":"IF(B51<>\"\",MAX($A$47:A50)+1,\"\")","v":""}]
[{"$f":"IF(B52<>\"\",MAX($A$47:A51)+1,\"\")","v":""}]
[{"$f":"IF(B53<>\"\",MAX($A$47:A52)+1,\"\")","v":""}]
[{"$f":"IF(B54<>\"\",MAX($A$47:A53)+1,\"\")","v":""}]
[{"$f":"IF(B55<>\"\",MAX($A$47:A54)+1,\"\")","v":""}]
[{"$f":"IF(B56<>\"\",MAX($A$47:A55)+1,\"\")","v":""}]
[{"$f":"IF(B57<>\"\",MAX($A$47:A56)+1,\"\")","v":""}]
[{"$f":"IF(B58<>\"\",MAX($A$47:A57)+1,\"\")","v":""}]
[{"$f":"IF(B59<>\"\",MAX($A$47:A58)+1,\"\")","v":""}]
[{"$f":"IF(B60<>\"\",MAX($A$47:A59)+1,\"\")","v":""}]
[{"$f":"IF(B61<>\"\",MAX($A$47:A60)+1,\"\")","v":""}]
[{"$f":"IF(B62<>\"\",MAX($A$47:A61)+1,\"\")","v":""}]
[{"$f":"IF(B63<>\"\",MAX($A$47:A62)+1,\"\")","v":""}]
[{"$f":"IF(B64<>\"\",MAX($A$47:A63)+1,\"\")","v":""}]
[{"$f":"IF(B65<>\"\",MAX($A$47:A64)+1,\"\")","v":""}]
[{"$f":"IF(B66<>\"\",MAX($A$47:A65)+1,\"\")","v":""}]
[{"$f":"IF(B67<>\"\",MAX($A$47:A66)+1,\"\")","v":""}]
[{"$f":"IF(B68<>\"\",MAX($A$47:A67)+1,\"\")","v":""}]
[{"$f":"IF(B69<>\"\",MAX($A$47:A68)+1,\"\")","v":""}]
[{"$f":"IF(B70<>\"\",MAX($A$47:A69)+1,\"\")","v":""}]
[{"$f":"IF(B71<>\"\",MAX($A$47:A70)+1,\"\")","v":""}]
[{"$f":"IF(B72<>\"\",MAX($A$47:A71)+1,\"\")","v":""}]
[{"$f":"IF(B73<>\"\",MAX($A$47:A72)+1,\"\")","v":""}]
[{"$f":"IF(B74<>\"\",MAX($A$47:A73)+1,\"\")","v":""}]
[{"$f":"IF(B75<>\"\",MAX($A$47:A74)+1,\"\")","v":""}]
[{"$f":"IF(B76<>\"\",MAX($A$47:A75)+1,\"\")","v":""}]
[{"$f":"IF(B77<>\"\",MAX($A$47:A76)+1,\"\")","v":""}]
[{"$f":"IF(B78<>\"\",MAX($A$47:A77)+1,\"\")","v":""}]
[{"$f":"IF(B79<>\"\",MAX($A$47:A78)+1,\"\")","v":""}]
[{"$f":"IF(B80<>\"\",MAX($A$47:A79)+1,\"\")","v":""}]
[{"$f":"IF(B81<>\"\",MAX($A$47:A80)+1,\"\")","v":""}]
[{"$f":"IF(B82<>\"\",MAX($A$47:A81)+1,\"\")","v":""}]
[{"$f":"IF(B83<>\"\",MAX($A$47:A82)+1,\"\")","v":""}]
[{"$f":"IF(B84<>\"\",MAX($A$47:A83)+1,\"\")","v":""}]
[{"$f":"IF(B85<>\"\",MAX($A$47:A84)+1,\"\")","v":""}]
["Subtotal B",null,null,null,null,null,null,{"$f":"SUM(H48:H85)","v":0},{"$f":"SUM(I48:I85)","v":0}]
["C. Subministraments (llum, aigua, gas)"]
[{"$f":"IF(B88<>\"\",MAX($A$11:A87)+1,\"\")","v":""}]
[{"$f":"IF(B89<>\"\",MAX($A$47:A88)+1,\"\")","v":""}]
[{"$f":"IF(B90<>\"\",MAX($A$47:A89)+1,\"\")","v":""}]
[{"$f":"IF(B91<>\"\",MAX($A$47:A90)+1,\"\")","v":""}]
[{"$f":"IF(B92<>\"\",MAX($A$47:A91)+1,\"\")","v":""}]
[{"$f":"IF(B93<>\"\",MAX($A$47:A92)+1,\"\")","v":""}]
[{"$f":"IF(B94<>\"\",MAX($A$47:A93)+1,\"\")","v":""}]
[{"$f":"IF(B95<>\"\",MAX($A$47:A94)+1,\"\")","v":""}]
["Subtotal C",null,null,null,null,null,null,{"$f":"SUM(H88:H95)","v":0},{"$f":"SUM(I88:I95)","v":0}]
["D. Comunicacions (telèfon, fax, correus)"]
[{"$f":"IF(B98<>\"\",MAX($A$11:A97)+1,\"\")","v":""}]
[{"$f":"IF(B99<>\"\",MAX($A$47:A98)+1,\"\")","v":""}]
[{"$f":"IF(B100<>\"\",MAX($A$47:A99)+1,\"\")","v":""}]
[{"$f":"IF(B101<>\"\",MAX($A$47:A100)+1,\"\")","v":""}]
[{"$f":"IF(B102<>\"\",MAX($A$47:A101)+1,\"\")","v":""}]
[{"$f":"IF(B103<>\"\",MAX($A$47:A102)+1,\"\")","v":""}]
[{"$f":"IF(B104<>\"\",MAX($A$47:A103)+1,\"\")","v":""}]
[{"$f":"IF(B105<>\"\",MAX($A$47:A104)+1,\"\")","v":""}]
[{"$f":"IF(B106<>\"\",MAX($A$47:A105)+1,\"\")","v":""}]
[{"$f":"IF(B107<>\"\",MAX($A$47:A106)+1,\"\")","v":""}]
[{"$f":"IF(B108<>\"\",MAX($A$47:A107)+1,\"\")","v":""}]
[{"$f":"IF(B109<>\"\",MAX($A$47:A108)+1,\"\")","v":""}]
[{"$f":"IF(B110<>\"\",MAX($A$47:A109)+1,\"\")","v":""}]
[{"$f":"IF(B111<>\"\",MAX($A$47:A110)+1,\"\")","v":""}]
["Subtotal D",null,null,null,null,null,null,{"$f":"SUM(H98:H111)","v":0},{"$f":"SUM(I98:I111)","v":0}]
["E. Manteniment d'edificis i/o instal·lacions"]
[{"$f":"IF(B114<>\"\",MAX($A$11:A113)+1,\"\")","v":""}]
[{"$f":"IF(B115<>\"\",MAX($A$47:A114)+1,\"\")","v":""}]
[{"$f":"IF(B116<>\"\",MAX($A$47:A115)+1,\"\")","v":""}]
[{"$f":"IF(B117<>\"\",MAX($A$47:A116)+1,\"\")","v":""}]
[{"$f":"IF(B118<>\"\",MAX($A$47:A117)+1,\"\")","v":""}]
[{"$f":"IF(B119<>\"\",MAX($A$47:A118)+1,\"\")","v":""}]
[{"$f":"IF(B120<>\"\",MAX($A$47:A119)+1,\"\")","v":""}]
[{"$f":"IF(B121<>\"\",MAX($A$47:A120)+1,\"\")","v":""}]
[{"$f":"IF(B122<>\"\",MAX($A$47:A121)+1,\"\")","v":""}]
[{"$f":"IF(B123<>\"\",MAX($A$47:A122)+1,\"\")","v":""}]
[{"$f":"IF(B124<>\"\",MAX($A$47:A123)+1,\"\")","v":""}]
[{"$f":"IF(B125<>\"\",MAX($A$47:A124)+1,\"\")","v":""}]
[{"$f":"IF(B126<>\"\",MAX($A$47:A125)+1,\"\")","v":""}]
["Subtotal E",null,null,null,null,null,null,{"$f":"SUM(H114:H126)","v":0},{"$f":"SUM(I114:I126)","v":0}]
["F. Adquisició de material fungible (d'oficina, etc.)"]
[{"$f":"IF(B129<>\"\",MAX($A$11:A128)+1,\"\")","v":""}]
[{"$f":"IF(B130<>\"\",MAX($A$47:A129)+1,\"\")","v":""}]
[{"$f":"IF(B131<>\"\",MAX($A$47:A130)+1,\"\")","v":""}]
[{"$f":"IF(B132<>\"\",MAX($A$47:A131)+1,\"\")","v":""}]
[{"$f":"IF(B133<>\"\",MAX($A$47:A132)+1,\"\")","v":""}]
[{"$f":"IF(B134<>\"\",MAX($A$47:A133)+1,\"\")","v":""}]
[{"$f":"IF(B135<>\"\",MAX($A$47:A134)+1,\"\")","v":""}]
[{"$f":"IF(B136<>\"\",MAX($A$47:A135)+1,\"\")","v":""}]
[{"$f":"IF(B137<>\"\",MAX($A$47:A136)+1,\"\")","v":""}]
[{"$f":"IF(B138<>\"\",MAX($A$47:A137)+1,\"\")","v":""}]
[{"$f":"IF(B139<>\"\",MAX($A$47:A138)+1,\"\")","v":""}]
[{"$f":"IF(B140<>\"\",MAX($A$47:A139)+1,\"\")","v":""}]
[{"$f":"IF(B141<>\"\",MAX($A$47:A140)+1,\"\")","v":""}]
[{"$f":"IF(B142<>\"\",MAX($A$47:A141)+1,\"\")","v":""}]
[{"$f":"IF(B143<>\"\",MAX($A$47:A142)+1,\"\")","v":""}]
[{"$f":"IF(B144<>\"\",MAX($A$47:A143)+1,\"\")","v":""}]
[{"$f":"IF(B145<>\"\",MAX($A$47:A144)+1,\"\")","v":""}]
[{"$f":"IF(B146<>\"\",MAX($A$47:A145)+1,\"\")","v":""}]
[{"$f":"IF(B147<>\"\",MAX($A$47:A146)+1,\"\")","v":""}]
[{"$f":"IF(B148<>\"\",MAX($A$47:A147)+1,\"\")","v":""}]
[{"$f":"IF(B149<>\"\",MAX($A$47:A148)+1,\"\")","v":""}]
[{"$f":"IF(B150<>\"\",MAX($A$47:A149)+1,\"\")","v":""}]
[{"$f":"IF(B151<>\"\",MAX($A$47:A150)+1,\"\")","v":""}]
[{"$f":"IF(B152<>\"\",MAX($A$47:A151)+1,\"\")","v":""}]
[{"$f":"IF(B153<>\"\",MAX($A$47:A152)+1,\"\")","v":""}]
[{"$f":"IF(B154<>\"\",MAX($A$47:A153)+1,\"\")","v":""}]
["Subtotal F",null,null,null,null,null,null,{"$f":"SUM(H129:H154)","v":0},{"$f":"SUM(I129:I154)","v":0}]
["G. Transport - Missatgeria"]
[{"$f":"IF(B157<>\"\",MAX($A$11:A156)+1,\"\")","v":""}]
[{"$f":"IF(B158<>\"\",MAX($A$47:A157)+1,\"\")","v":""}]
[{"$f":"IF(B159<>\"\",MAX($A$47:A158)+1,\"\")","v":""}]
[{"$f":"IF(B160<>\"\",MAX($A$47:A159)+1,\"\")","v":""}]
[{"$f":"IF(B161<>\"\",MAX($A$47:A160)+1,\"\")","v":""}]
[{"$f":"IF(B162<>\"\",MAX($A$47:A161)+1,\"\")","v":""}]
[{"$f":"IF(B163<>\"\",MAX($A$47:A162)+1,\"\")","v":""}]
[{"$f":"IF(B164<>\"\",MAX($A$47:A163)+1,\"\")","v":""}]
[{"$f":"IF(B165<>\"\",MAX($A$47:A164)+1,\"\")","v":""}]
[{"$f":"IF(B166<>\"\",MAX($A$47:A165)+1,\"\")","v":""}]
[{"$f":"IF(B167<>\"\",MAX($A$47:A166)+1,\"\")","v":""}]
[{"$f":"IF(B168<>\"\",MAX($A$47:A167)+1,\"\")","v":""}]
[{"$f":"IF(B169<>\"\",MAX($A$47:A168)+1,\"\")","v":""}]
["Subtotal G",null,null,null,null,null,null,{"$f":"SUM(H157:H169)","v":0},{"$f":"SUM(I157:I169)","v":0}]
["H. Publicitat i Propaganda"]
[{"$f":"IF(B172<>\"\",MAX($A$11:A171)+1,\"\")","v":""}]
[{"$f":"IF(B173<>\"\",MAX($A$47:A172)+1,\"\")","v":""}]
[{"$f":"IF(B174<>\"\",MAX($A$47:A173)+1,\"\")","v":""}]
[{"$f":"IF(B175<>\"\",MAX($A$47:A174)+1,\"\")","v":""}]
[{"$f":"IF(B176<>\"\",MAX($A$47:A175)+1,\"\")","v":""}]
[{"$f":"IF(B177<>\"\",MAX($A$47:A176)+1,\"\")","v":""}]
[{"$f":"IF(B178<>\"\",MAX($A$47:A177)+1,\"\")","v":""}]
[{"$f":"IF(B179<>\"\",MAX($A$47:A178)+1,\"\")","v":""}]
[{"$f":"IF(B180<>\"\",MAX($A$47:A179)+1,\"\")","v":""}]
[{"$f":"IF(B181<>\"\",MAX($A$47:A180)+1,\"\")","v":""}]
[{"$f":"IF(B182<>\"\",MAX($A$47:A181)+1,\"\")","v":""}]
[{"$f":"IF(B183<>\"\",MAX($A$47:A182)+1,\"\")","v":""}]
[{"$f":"IF(B184<>\"\",MAX($A$47:A183)+1,\"\")","v":""}]
[{"$f":"IF(B185<>\"\",MAX($A$47:A184)+1,\"\")","v":""}]
[{"$f":"IF(B186<>\"\",MAX($A$47:A185)+1,\"\")","v":""}]
[{"$f":"IF(B187<>\"\",MAX($A$47:A186)+1,\"\")","v":""}]
["Subtotal H",null,null,null,null,null,null,{"$f":"SUM(H172:H187)","v":0},{"$f":"SUM(I172:I187)","v":0}]
["I. Assegurances"]
[{"$f":"IF(B190<>\"\",MAX($A$11:A189)+1,\"\")","v":""}]
[{"$f":"IF(B191<>\"\",MAX($A$47:A190)+1,\"\")","v":""}]
[{"$f":"IF(B192<>\"\",MAX($A$47:A191)+1,\"\")","v":""}]
[{"$f":"IF(B193<>\"\",MAX($A$47:A192)+1,\"\")","v":""}]
[{"$f":"IF(B194<>\"\",MAX($A$47:A193)+1,\"\")","v":""}]
[{"$f":"IF(B195<>\"\",MAX($A$47:A194)+1,\"\")","v":""}]
[{"$f":"IF(B196<>\"\",MAX($A$47:A195)+1,\"\")","v":""}]
[{"$f":"IF(B197<>\"\",MAX($A$47:A196)+1,\"\")","v":""}]
[{"$f":"IF(B198<>\"\",MAX($A$47:A197)+1,\"\")","v":""}]
[{"$f":"IF(B199<>\"\",MAX($A$47:A198)+1,\"\")","v":""}]
["Subtotal I",null,null,null,null,null,null,{"$f":"SUM(H190:H199)","v":0},{"$f":"SUM(I190:I199)","v":0}]
["J. Allotjament i dietes (2)"]
[{"$f":"IF(B202<>\"\",MAX($A$11:A201)+1,\"\")","v":""}]
[{"$f":"IF(B203<>\"\",MAX($A$47:A202)+1,\"\")","v":""}]
[{"$f":"IF(B204<>\"\",MAX($A$47:A203)+1,\"\")","v":""}]
[{"$f":"IF(B205<>\"\",MAX($A$47:A204)+1,\"\")","v":""}]
[{"$f":"IF(B206<>\"\",MAX($A$47:A205)+1,\"\")","v":""}]
[{"$f":"IF(B207<>\"\",MAX($A$47:A206)+1,\"\")","v":""}]
[{"$f":"IF(B208<>\"\",MAX($A$47:A207)+1,\"\")","v":""}]
[{"$f":"IF(B209<>\"\",MAX($A$47:A208)+1,\"\")","v":""}]
[{"$f":"IF(B210<>\"\",MAX($A$47:A209)+1,\"\")","v":""}]
[{"$f":"IF(B211<>\"\",MAX($A$47:A210)+1,\"\")","v":""}]
[{"$f":"IF(B212<>\"\",MAX($A$47:A211)+1,\"\")","v":""}]
[{"$f":"IF(B213<>\"\",MAX($A$47:A212)+1,\"\")","v":""}]
[{"$f":"IF(B214<>\"\",MAX($A$47:A213)+1,\"\")","v":""}]
[{"$f":"IF(B215<>\"\",MAX($A$47:A214)+1,\"\")","v":""}]
["Subtotal J",null,null,null,null,null,null,{"$f":"SUM(H202:H215)","v":0},{"$f":"SUM(I202:I215)","v":0}]
["K. Viatges i desplaçaments (2)"]
[{"$f":"IF(B218<>\"\",MAX($A$11:A217)+1,\"\")","v":""}]
[{"$f":"IF(B219<>\"\",MAX($A$47:A218)+1,\"\")","v":""}]
[{"$f":"IF(B220<>\"\",MAX($A$47:A219)+1,\"\")","v":""}]
[{"$f":"IF(B221<>\"\",MAX($A$47:A220)+1,\"\")","v":""}]
[{"$f":"IF(B222<>\"\",MAX($A$47:A221)+1,\"\")","v":""}]
[{"$f":"IF(B223<>\"\",MAX($A$47:A222)+1,\"\")","v":""}]
[{"$f":"IF(B224<>\"\",MAX($A$47:A223)+1,\"\")","v":""}]
[{"$f":"IF(B225<>\"\",MAX($A$47:A224)+1,\"\")","v":""}]
[{"$f":"IF(B226<>\"\",MAX($A$47:A225)+1,\"\")","v":""}]
[{"$f":"IF(B227<>\"\",MAX($A$47:A226)+1,\"\")","v":""}]
[{"$f":"IF(B228<>\"\",MAX($A$47:A227)+1,\"\")","v":""}]
[{"$f":"IF(B229<>\"\",MAX($A$47:A228)+1,\"\")","v":""}]
[{"$f":"IF(B230<>\"\",MAX($A$47:A229)+1,\"\")","v":""}]
["Subtotal K",null,null,null,null,null,null,{"$f":"SUM(H218:H230)","v":0},{"$f":"SUM(I218:I230)","v":0}]
["L. Treballs realitzats per empreses externes (neteja, seguretat, altres treballs directament relacionats amb l'activitat i/o projecte)"]
[{"$f":"IF(B233<>\"\",MAX($A$11:A232)+1,\"\")","v":""}]
[{"$f":"IF(B234<>\"\",MAX($A$47:A233)+1,\"\")","v":""}]
[{"$f":"IF(B235<>\"\",MAX($A$47:A234)+1,\"\")","v":""}]
[{"$f":"IF(B236<>\"\",MAX($A$47:A235)+1,\"\")","v":""}]
[{"$f":"IF(B237<>\"\",MAX($A$47:A236)+1,\"\")","v":""}]
[{"$f":"IF(B238<>\"\",MAX($A$47:A237)+1,\"\")","v":""}]
[{"$f":"IF(B239<>\"\",MAX($A$47:A238)+1,\"\")","v":""}]
[{"$f":"IF(B240<>\"\",MAX($A$47:A239)+1,\"\")","v":""}]
[{"$f":"IF(B241<>\"\",MAX($A$47:A240)+1,\"\")","v":""}]
[{"$f":"IF(B242<>\"\",MAX($A$47:A241)+1,\"\")","v":""}]
[{"$f":"IF(B243<>\"\",MAX($A$47:A242)+1,\"\")","v":""}]
[{"$f":"IF(B244<>\"\",MAX($A$47:A243)+1,\"\")","v":""}]
[{"$f":"IF(B245<>\"\",MAX($A$47:A244)+1,\"\")","v":""}]
[{"$f":"IF(B246<>\"\",MAX($A$47:A245)+1,\"\")","v":""}]
[{"$f":"IF(B247<>\"\",MAX($A$47:A246)+1,\"\")","v":""}]
["Subtotal L",null,null,null,null,null,null,{"$f":"SUM(H233:H247)","v":0},{"$f":"SUM(I233:I247)","v":0}]
["M. Altres despeses (a especificar)"]
[{"$f":"IF(B250<>\"\",MAX($A$11:A249)+1,\"\")","v":""}]
[{"$f":"IF(B251<>\"\",MAX($A$47:A250)+1,\"\")","v":""}]
[{"$f":"IF(B252<>\"\",MAX($A$47:A251)+1,\"\")","v":""}]
[{"$f":"IF(B253<>\"\",MAX($A$47:A252)+1,\"\")","v":""}]
[{"$f":"IF(B254<>\"\",MAX($A$47:A253)+1,\"\")","v":""}]
[{"$f":"IF(B255<>\"\",MAX($A$47:A254)+1,\"\")","v":""}]
[{"$f":"IF(B256<>\"\",MAX($A$47:A255)+1,\"\")","v":""}]
[{"$f":"IF(B257<>\"\",MAX($A$47:A256)+1,\"\")","v":""}]
[{"$f":"IF(B258<>\"\",MAX($A$47:A257)+1,\"\")","v":""}]
[{"$f":"IF(B259<>\"\",MAX($A$47:A258)+1,\"\")","v":""}]
[{"$f":"IF(B260<>\"\",MAX($A$47:A259)+1,\"\")","v":""}]
[{"$f":"IF(B261<>\"\",MAX($A$47:A260)+1,\"\")","v":""}]
[{"$f":"IF(B262<>\"\",MAX($A$47:A261)+1,\"\")","v":""}]
[{"$f":"IF(B263<>\"\",MAX($A$47:A262)+1,\"\")","v":""}]
[{"$f":"IF(B264<>\"\",MAX($A$47:A263)+1,\"\")","v":""}]
[{"$f":"IF(B265<>\"\",MAX($A$47:A264)+1,\"\")","v":""}]
[{"$f":"IF(B266<>\"\",MAX($A$47:A265)+1,\"\")","v":""}]
[{"$f":"IF(B267<>\"\",MAX($A$47:A266)+1,\"\")","v":""}]
[{"$f":"IF(B268<>\"\",MAX($A$47:A267)+1,\"\")","v":""}]
[{"$f":"IF(B269<>\"\",MAX($A$47:A268)+1,\"\")","v":""}]
[{"$f":"IF(B270<>\"\",MAX($A$47:A269)+1,\"\")","v":""}]
[{"$f":"IF(B271<>\"\",MAX($A$47:A270)+1,\"\")","v":""}]
[{"$f":"IF(B272<>\"\",MAX($A$47:A271)+1,\"\")","v":""}]
[{"$f":"IF(B273<>\"\",MAX($A$47:A272)+1,\"\")","v":""}]
["Subtotal M",null,null,null,null,null,null,{"$f":"SUM(H250:H273)","v":0},{"$f":"SUM(I250:I273)","v":0}]
["TOTAL DESPESES",null,null,null,null,null,"TOTAL",{"$f":"+H46+H86+H96+H112+H127+H155+H170+H188+H200+H216+H231+H248+H274","v":0},{"$f":"+I46+I86+I96+I112+I127+I155+I170+I188+I200+I216+I231+I248+I274","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":114,"n_cols":10,"rows_kept":114,"cut":false,"hidden":false,"merged":[[98,6,98,9],[94,6,94,9],[92,6,92,9],[89,6,89,9],[100,6,100,9],[100,0,100,3],[99,0,99,3],[102,0,102,9],[103,0,104,9],[99,6,99,9],[80,0,80,9],[87,0,87,9],[76,6,76,9],[86,6,86,9],[88,6,88,9],[86,0,86,3],[79,0,79,3],[77,6,77,9],[85,6,85,9],[83,6,83,9],[82,6,82,9],[81,6,81,9],[59,6,59,9],[58,6,58,9],[71,6,71,9],[70,6,70,9],[69,6,69,9],[67,6,67,9],[66,6,66,9],[65,6,65,9],[64,6,64,9],[35,6,35,9],[30,6,30,9],[29,6,29,9],[28,6,28,9],[27,6,27,9],[0,0,0,9],[9,0,9,9],[26,0,26,9],[37,0,37,9],[7,6,8,9],[10,6,10,9],[11,6,11,9],[7,0,8,0],[12,6,12,9],[24,6,24,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],[25,0,25,3],[71,0,71,3],[49,0,49,9],[57,0,57,9],[63,0,63,9],[62,0,62,3],[56,0,56,3],[25,6,25,9],[36,6,36,9],[51,6,51,9],[50,6,50,9],[62,6,62,9],[61,6,61,9],[52,6,52,9],[56,6,56,9],[55,6,55,9],[75,6,75,9],[48,0,48,3],[79,6,79,9],[78,6,78,9],[36,0,36,3],[72,0,72,9],[74,6,74,9],[73,6,73,9],[54,6,54,9],[53,6,53,9],[48,6,48,9],[47,6,47,9],[40,6,40,9],[39,6,39,9],[38,6,38,9],[60,6,60,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":"2022-01-01"},"a",{"$f":"IF(+'Relació de despeses'!L5=\"\",\"\",+'Relació de despeses'!L5)","v":"2023-12-31"}]
[]
["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. Subvencions de l'Ajuntament de Barcelona (1)"]
[{"$f":"IF(B11<>\"\",1,\"\")","v":""}]
[]
[]
[]
[{"$f":"IF(B15<>\"\",MAX($A$10:A14)+1,\"\")","v":""}]
[{"$f":"IF(B16<>\"\",MAX($A$10:A15)+1,\"\")","v":""}]
[{"$f":"IF(B17<>\"\",MAX($A$10:A16)+1,\"\")","v":""}]
[{"$f":"IF(B18<>\"\",MAX($A$10:A17)+1,\"\")","v":""}]
[{"$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":""}]
[{"$f":"IF(B24<>\"\",MAX($A$10:A23)+1,\"\")","v":""}]
[{"$f":"IF(B25<>\"\",MAX($A$10:A24)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal A",{"$f":"SUM(F11:F25)","v":0}]
["B. Subvencions d'altres administracions"]
[{"$f":"IF(B28<>\"\",MAX($A$10:A27)+1,\"\")","v":""}]
[]
[{"$f":"IF(B30<>\"\",MAX($A$10:A29)+1,\"\")","v":""}]
[{"$f":"IF(B31<>\"\",MAX($A$10:A30)+1,\"\")","v":""}]
[{"$f":"IF(B32<>\"\",MAX($A$10:A31)+1,\"\")","v":""}]
[{"$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":""}]
[null,null,null,null,"Subtotal B",{"$f":"SUM(F28:F36)","v":0}]
["C. Aportacions d'ens privats"]
[{"$f":"IF(B39<>\"\",MAX($A$10:A38)+1,\"\")","v":""}]
[{"$f":"IF(B40<>\"\",MAX($A$10:A39)+1,\"\")","v":""}]
[{"$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":""}]
[{"$f":"IF(B45<>\"\",MAX($A$10:A44)+1,\"\")","v":""}]
[{"$f":"IF(B46<>\"\",MAX($A$10:A45)+1,\"\")","v":""}]
[{"$f":"IF(B47<>\"\",MAX($A$10:A46)+1,\"\")","v":""}]
[{"$f":"IF(B48<>\"\",MAX($A$10:A47)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal C",{"$f":"SUM(F39:F48)","v":0}]
["D. Recursos propis de l'entitat"]
[{"$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":""}]
[{"$f":"IF(B54<>\"\",MAX($A$10:A53)+1,\"\")","v":""}]
[{"$f":"IF(B55<>\"\",MAX($A$10:A54)+1,\"\")","v":""}]
[{"$f":"IF(B56<>\"\",MAX($A$10:A55)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal D",{"$f":"SUM(F51:F56)","v":0}]
["E. Taquillatge"]
[{"$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":""}]
[{"$f":"IF(B62<>\"\",MAX($A$10:A61)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal E",{"$f":"SUM(F59:F62)","v":0}]
["F. Quotes d'inscripció"]
[{"$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":""}]
[{"$f":"IF(B69<>\"\",MAX($A$10:A68)+1,\"\")","v":""}]
[{"$f":"IF(B70<>\"\",MAX($A$10:A69)+1,\"\")","v":""}]
[{"$f":"IF(B71<>\"\",MAX($A$10:A70)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal F",{"$f":"SUM(F65:F71)","v":0}]
["G. Venda de Productes"]
[{"$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":""}]
[null,null,null,null,"Subtotal G",{"$f":"SUM(F74:F79)","v":0}]
["H. Publicitat i/o Esponsorització"]
[{"$f":"IF(B82<>\"\",MAX($A$10:A81)+1,\"\")","v":""}]
[{"$f":"IF(B83<>\"\",MAX($A$10:A82)+1,\"\")","v":""}]
[{"$f":"IF(B84<>\"\",MAX($A$10:A83)+1,\"\")","v":""}]
[{"$f":"IF(B85<>\"\",MAX($A$10:A84)+1,\"\")","v":""}]
[{"$f":"IF(B86<>\"\",MAX($A$10:A85)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal H",{"$f":"SUM(F82:F86)","v":0}]
["I. Altres ingressos"]
[{"$f":"IF(B89<>\"\",MAX($A$10:A88)+1,\"\")","v":""}]
[{"$f":"IF(B90<>\"\",MAX($A$10:A89)+1,\"\")","v":""}]
[{"$f":"IF(B91<>\"\",MAX($A$10:A90)+1,\"\")","v":""}]
[{"$f":"IF(B92<>\"\",MAX($A$10:A91)+1,\"\")","v":""}]
[{"$f":"IF(B93<>\"\",MAX($A$10:A92)+1,\"\")","v":""}]
[{"$f":"IF(B94<>\"\",MAX($A$10:A93)+1,\"\")","v":""}]
[{"$f":"IF(B95<>\"\",MAX($A$10:A94)+1,\"\")","v":""}]
[{"$f":"IF(B96<>\"\",MAX($A$10:A95)+1,\"\")","v":""}]
[{"$f":"IF(B97<>\"\",MAX($A$10:A96)+1,\"\")","v":""}]
[{"$f":"IF(B98<>\"\",MAX($A$10:A97)+1,\"\")","v":""}]
[{"$f":"IF(B99<>\"\",MAX($A$10:A98)+1,\"\")","v":""}]
[null,null,null,null,"Subtotal I",{"$f":"SUM(F89:F99)","v":0}]
["Total INGRESSOS",null,null,null,"TOTAL",{"$f":"+F26+F37+F49+F57+F63+F72+F80+F87+F100","v":0}]
[]
[{"$f":"'Relació de despeses'!A277:L277","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,"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":"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]]}
["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":"IF(+'Relació de despeses'!H3=\"\",\"\",+'Relació de despeses'!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":"IF(+'Relació de despeses'!H4=\"\",\"\",+'Relació de despeses'!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":"IF(+'Relació de despeses'!H5=\"\",\"\",+'Relació de despeses'!H5)","v":"2022-01-01"},"a",{"$f":"IF(+'Relació de despeses'!L5=\"\",\"\",+'Relació de despeses'!L5)","v":"2023-12-31"}]
["Despeses del projecte/activitat/servei subvencionat",null,null,null,null,"Ingressos del projecte/activitat/servei subvencionat"]
["Concepte",null,"Previsió inicial o reformulació ja aprovada (1)","Despeses realitzades\n(2)",null,"Concepte",null,"Previsió inicial o reformulació ja aprovada (1)","Ingressos obtinguts\n(3)"]
["A. Recursos Humans \n(retribucions, S.Social)",null,null,{"$f":"'Relació de despeses'!H46","v":0},null,"A. Subvencions municipals",null,null,{"$f":"'Relació d''ingressos '!F26","v":0}]
["B. Lloguers \n(materials, infraestructures etc.)",null,null,{"$f":"'Relació de despeses'!H86","v":0},null,"B. Subvencions d'altres administracions",null,null,{"$f":"'Relació d''ingressos '!F37","v":0}]
["C. Subministraments \n(electricitat, aigua, gas)",null,null,{"$f":"'Relació de despeses'!H96","v":0},null,"C. Aportacions d'ens privats",null,null,{"$f":"'Relació d''ingressos '!F49","v":0}]
["D. Comunicacions (telefon, fax, correus)",null,null,{"$f":"'Relació de despeses'!H112","v":0},null,"D. Recursos propis de la persona jurídica (l'entitat)",null,null,{"$f":"'Relació d''ingressos '!F57","v":0}]
["E. Manteniment d'edificis i/o instal·lacions",null,null,{"$f":"'Relació de despeses'!H127","v":0},null,"E. Taquillatge",null,null,{"$f":"'Relació d''ingressos '!F63","v":0}]
["F. Adquisició de material fungible\n(d'oficina, etc.)",null,null,{"$f":"'Relació de despeses'!H155","v":0},null,"F. Quotes d'inscripció",null,null,{"$f":"'Relació d''ingressos '!F72","v":0}]
["G. Transport - Missatgeria",null,null,{"$f":"'Relació de despeses'!H170","v":0},null,"G. Venda de Productes",null,null,{"$f":"'Relació d''ingressos '!F80","v":0}]
["H. Publicitat i Propaganda",null,null,{"$f":"'Relació de despeses'!H188","v":0},null,"H. Publicitat i/o Esponsorització",null,null,{"$f":"'Relació d''ingressos '!F87","v":0}]
["I. Assegurances",null,null,{"$f":"'Relació de despeses'!H200","v":0},null,"I. Altres ingressos",null,null,{"$f":"'Relació d''ingressos '!F100","v":0}]
["J. Allotjament i dietes",null,null,{"$f":"'Relació de despeses'!H216","v":0},null,"Total Ingressos",null,{"$f":"SUM(H8:H16)","v":0},{"$f":"SUM(I8:I16)","v":0}]
["K. Viatges i desplaçaments",null,null,{"$f":"'Relació de despeses'!H231","v":0},null,"% finançament municipal (5)",null,{"$f":"IF(H8=\"\",\"- %\",+H8/H17)","v":"- %"},{"$f":"IF(I8=\"\",\"- %\",+I8/I17)","v":{"$error":"#DIV/0!"}}]
["L. Treballs realitzats per empreses externes\n(neteja, seguretat, altres directament relacionats amb el projecte)",null,null,{"$f":"'Relació de despeses'!H248","v":0},null,null,null,"Previsió inicial","Real"]
["M. Altres despeses (no incloses en cap dels apartats anteriors, com per exemple amortizacions dels bens adquirits, etc)",null,null,{"$f":"'Relació de despeses'!H274","v":0},null,"Diferència Ingressos - Despeses ",null,{"$f":"+H17-B21","v":0},{"$f":"+I17-D21","v":0}]
["Total Despeses",null,{"$f":"SUM(C8:C20)","v":0},{"$f":"SUM(D8:D20)","v":0},null,"Desviació de Despeses (4)",null,"Desviació d'ingressos (4)"]
[null,null,null,null,null,"Import"," % (6)","Import","%"]
[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 els motius pels quals existeix una desviació entre la despesa prevista en la sol·licitud de subvenció i la finalment realitzada , així com entre els ingressos previstos i els obtinguts."]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"+'Relació de despeses'!A277:M277","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)."}]
["DECLARA que en relació al projecte/activitat/servei subvencionat s'han produït els ingressos i despeses que figuren en el present document, i que les desviacions respecte al pressupost inicial s'han produït per les motivacions a dalt esmentades, i perquè així consti, als efectes de justificar el compliment de l'objecte de la subvenció concedida, signo la present declaració responsable."]
[]
[]
["Població i data: "]
[]
[]
["Notes:"]
["(*) Les columnes ombrejades en color  s'aniran emplenant automàticament a partir de les dades introduïdes en els documents de despeses -detall i ingressos-detall. Per tant, no imprimiu aquest full fins haver emplenat els altres."]
["(1) Previsió inicial o reformulació ja aprovada= S'han d'indicar la previsió inicial de despeses i d'ingressos segons allò que es va indicar al projecte original en el \"pla de viabilitat econòmica del projecte - pressupost general\" . En cas que ja s'hagi aprovat una reformulació, s'han d'indicar les quantitats reformulades. "]
["(2) Despeses reals = Cost real total del projecte subvencionat. Automàticament s'introduiran els subtotals de les despeses relacionades al full Despeses-detall."]
["(3) Ingresos reals = Total d'ingressos obtinguts per a la realització del projecte subvencionat. Automàticament s'introduiran els subtotals dels ingressos relacionats al full Ingressos-detall"]
["(4) Desviació: En el cas de les despeses, la desviació és la diferència entre despeses reals i la previsió inicial de despeses; i en el cas d'ingressos, la diferència entre els ingressos reals i la previsió inicial d'ingressos. "]
["(5) % finançament municipal = percentatge que suposen les subvencions municipals (A) respecte del  total d'ingressos del projecte subvencionat."]
["(6) El % de la desviació final de despeses es calcula dividint l'import resultant de despeses reals - despeses previstes, entre el total de despeses previstes i de la mateixa manera els ingressos, En cas d'existir una desviació sempre s'ha de motivar."]

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