{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["PLA VIABILITAT","PLA VIABILITAT-ORIG","Taules"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":7,"comments":2,"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":"PLA VIABILITAT","index":0,"n_rows":89,"n_cols":23,"rows_kept":89,"cut":false,"hidden":false,"merged":[[84,2,84,4],[85,2,85,4],[86,2,86,4],[86,5,86,6],[82,1,82,4],[82,5,82,7],[51,1,51,20],[82,9,82,11],[82,12,82,14],[82,15,82,17],[83,2,83,4],[80,1,80,4],[80,5,80,7],[71,1,71,20],[1,2,1,20],[6,1,6,20],[3,1,5,1],[3,6,4,6],[3,7,4,7],[3,8,4,17],[3,20,5,20],[4,2,5,2],[4,3,5,3],[4,4,5,4],[3,2,3,5],[4,5,5,5]]}
[]
[null,null,"PLA PREVISIONAL DE TRESORERIA (per un any)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PERIODICITATS"]
[null,null,"p Imports acumulats en trimestres, en funció de la liquidació d'impostos"]
[null,"CONCEPTES\nImports / Factures (IVA i IRPF inclosos)","Import",null,null,null,null,null,"Trimestral",null,null,null,null,null,null,null,null,null,null,null,"Acumulat\nAny"]
[null,null,"Puntual >","Trimes-tre","Periòdic >","Perio- dicitat"]
[null,null,null,null,null,null,"%IVA","%IRPF","1T","iva","irpf","2T","iva","irpf","3T","iva","irpf","4T","iva","irpf"]
[null,"DESPESES"]
[null,"Despeses de pesonal",{"$f":"C13","v":0},null,{"$f":"E13","v":0},null,null,null,{"$f":"SUM(I9:I13)","v":0},{"$f":"J13","v":0},{"$f":"K13","v":0},{"$f":"SUM(L9:L13)","v":0},{"$f":"M13","v":0},{"$f":"N13","v":0},{"$f":"SUM(O9:O13)","v":0},{"$f":"P13","v":0},{"$f":"Q13","v":0},{"$f":"SUM(R9:R13)","v":0},{"$f":"S13","v":0},{"$f":"T13","v":0},{"$f":"SUM(U9:U13)","v":0}]
[null,"   Sous i salaris                                   ",null,null,null,null,null,null,{"$f":"Import1T($C9,$D9,$E9,$F9)","v":0},null,null,{"$f":"Import2T($C9,$D9,$E9,$F9)","v":0},null,null,{"$f":"Import3T($C9,$D9,$E9,$F9)","v":0},null,null,{"$f":"Import4T($C9,$D9,$E9,$F9)","v":0},null,null,{"$f":"SUM(I9,L9,O9,R9)","v":0}]
[null,"        IRPF Sous i Salaris",null,null,null,null,null,null,{"$f":"Import1T($C10,$D10,$E10,$F10)","v":0},null,null,{"$f":"Import2T($C10,$D10,$E10,$F10)","v":0},null,null,{"$f":"Import3T($C10,$D10,$E10,$F10)","v":0},null,null,{"$f":"Import4T($C10,$D10,$E10,$F10)","v":0},null,null,{"$f":"SUM(I10,L10,O10,R10)","v":0}]
[null,"        Seg. Social",null,null,null,null,null,null,{"$f":"Import1T($C11,$D11,$E11,$F11)","v":0},null,null,{"$f":"Import2T($C11,$D11,$E11,$F11)","v":0},null,null,{"$f":"Import3T($C11,$D11,$E11,$F11)","v":0},null,null,{"$f":"Import4T($C11,$D11,$E11,$F11)","v":0},null,null,{"$f":"SUM(I11,L11,O11,R11)","v":0}]
[null,"        Autònoms (no administradors)",null,null,null,null,null,null,{"$f":"Import1T($C12,$D12,$E12,$F12)","v":0},null,null,{"$f":"Import2T($C12,$D12,$E12,$F12)","v":0},null,null,{"$f":"Import3T($C12,$D12,$E12,$F12)","v":0},null,null,{"$f":"Import4T($C12,$D12,$E12,$F12)","v":0},null,null,{"$f":"SUM(I12,L12,O12,R12)","v":0}]
[null,"   Formació                                          ",null,null,null,null,null,null,{"$f":"Import1T($C13,$D13,$E13,$F13)","v":0},{"$f":"CalcIva($G13,$H13,$I13)","v":0},{"$f":"CalcIrpf($G13,$H13,$I13)","v":0},{"$f":"Import2T($C13,$D13,$E13,$F13)","v":0},{"$f":"CalcIva($G13,$H13,$L13)","v":0},{"$f":"CalcIrpf($G13,$H13,$L13)","v":0},{"$f":"Import3T($C13,$D13,$E13,$F13)","v":0},{"$f":"CalcIva($G13,$H13,$O13)","v":0},{"$f":"CalcIrpf($G13,$H13,$O13)","v":0},{"$f":"Import4T($C13,$D13,$E13,$F13)","v":0},{"$f":"CalcIva($G13,$H13,$R13)","v":0},{"$f":"CalcIrpf($G13,$H13,$R13)","v":0},{"$f":"SUM($I13,$L13,$O13,$R13)","v":0}]
[null,"Tributs / Taxes / Cànons",{"$f":"C15","v":0},null,{"$f":"E15","v":0},null,null,null,{"$f":"I15","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Tributs / Taxes / Cànons",null,null,null,null,null,null,{"$f":"Import1T($C15,$D15,$E15,$F15)","v":0},{"$f":"CalcIva($G15,$H15,$I15)","v":0},{"$f":"CalcIrpf($G15,$H15,$I15)","v":0},{"$f":"Import2T($C15,$D15,$E15,$F15)","v":0},{"$f":"CalcIva($G15,$H15,$L15)","v":0},{"$f":"CalcIrpf($G15,$H15,$L15)","v":0},{"$f":"Import3T($C15,$D15,$E15,$F15)","v":0},{"$f":"CalcIva($G15,$H15,$O15)","v":0},{"$f":"CalcIrpf($G15,$H15,$O15)","v":0},{"$f":"Import4T($C15,$D15,$E15,$F15)","v":0},{"$f":"CalcIva($G15,$H15,$R15)","v":0},{"$f":"CalcIrpf($G15,$H15,$R15)","v":0},{"$f":"SUM($I15,$L15,$O15,$R15)","v":0}]
[null,"Serveis exteriors",{"$f":"SUM(C17:C18)","v":0},null,{"$f":"SUM(E17:E18)","v":0},null,null,null,{"$f":"SUM(I17:I18)","v":0},0,0,{"$f":"SUM(L17:L18)","v":0},0,0,{"$f":"SUM(O17:O18)","v":0},{"$f":"SUM(P17:P18)","v":0},0,0,0,0,0]
[null,"   Arrendaments",null,null,null,null,null,null,{"$f":"Import1T($C17,$D17,$E17,$F17)","v":0},{"$f":"CalcIva($G17,$H17,$I17)","v":0},{"$f":"CalcIrpf($G17,$H17,$I17)","v":0},{"$f":"Import2T($C17,$D17,$E17,$F17)","v":0},{"$f":"CalcIva($G17,$H17,$L17)","v":0},{"$f":"CalcIrpf($G17,$H17,$L17)","v":0},{"$f":"Import3T($C17,$D17,$E17,$F17)","v":0},{"$f":"CalcIva($G17,$H17,$O17)","v":0},{"$f":"CalcIrpf($G17,$H17,$O17)","v":0},{"$f":"Import4T($C17,$D17,$E17,$F17)","v":0},{"$f":"CalcIva($G17,$H17,$R17)","v":0},{"$f":"CalcIrpf($G17,$H17,$R17)","v":0},{"$f":"SUM($I17,$L17,$O17,$R17)","v":0}]
[null,"   Manteniments",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM($I18,$L18,$O18,$R18)","v":0}]
[null,"Subministraments",{"$f":"SUM(C20:C25)","v":0},null,{"$f":"SUM(E20:E25)","v":0},null,null,null,{"$f":"SUM(I20:I25)","v":0},{"$f":"SUM(J20:J25)","v":0},{"$f":"SUM(K20:K25)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"   Aigua",null,null,null,null,null,null,{"$f":"Import1T($C20,$D20,$E20,$F20)","v":0},{"$f":"CalcIva($G20,$H20,$I20)","v":0},null,{"$f":"Import2T($C20,$D20,$E20,$F20)","v":0},{"$f":"CalcIva($G20,$H20,$L20)","v":0},null,{"$f":"Import3T($C20,$D20,$E20,$F20)","v":0},{"$f":"CalcIva($G20,$H20,$O20)","v":0},null,{"$f":"Import4T($C20,$D20,$E20,$F20)","v":0},{"$f":"CalcIva($G20,$H20,$R20)","v":0},null,{"$f":"SUM($I20,$L20,$O20,$R20)","v":0}]
[null,"   Gas",null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"SUM($I21,$L21,$O21,$R21)","v":0}]
[null,"   Electricitat",null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[null,"   Carburants i combustibles",null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,{"$f":"SUM($I23,$L23,$O23,$R23)","v":0}]
[null,"   Telèfon",null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[null,"   Transmissió de dades",null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[null,"Despeses ordinaries",{"$f":"SUM(C27:C38)","v":0},null,{"$f":"SUM(E27:E38)","v":0},null,null,null,{"$f":"SUM(I27:I38)","v":0},{"$f":"SUM(J27:J38)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"   Aprovisionaments / Mats. Primes / Articles",null,null,null,null,null,null,{"$f":"Import1T($C27,$D27,$E27,$F27)","v":0},{"$f":"CalcIva($G27,$H27,$I27)","v":0},{"$f":"CalcIrpf($G27,$H27,$I27)","v":0},{"$f":"Import2T($C27,$D27,$E27,$F27)","v":0},{"$f":"CalcIva($G27,$H27,$L27)","v":0},{"$f":"CalcIrpf($G27,$H27,$L27)","v":0},{"$f":"Import3T($C27,$D27,$E27,$F27)","v":0},{"$f":"CalcIva($G27,$H27,$O27)","v":0},{"$f":"CalcIrpf($G27,$H27,$O27)","v":0},{"$f":"Import4T($C27,$D27,$E27,$F27)","v":0},{"$f":"CalcIva($G27,$H27,$R27)","v":0},{"$f":"CalcIrpf($G27,$H27,$R27)","v":0},{"$f":"SUM($I27,$L27,$O27,$R27)","v":0}]
[null,"   Reparació i conservació",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Material oficina i fungible",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Correus i misatgeria",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Serveis bancaris, TPV i similars ",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Quotes, Subscripcions i documentació",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Despeses de viatge",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Transports ",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Primes d'assegurances",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"   Publicitat, propaganda i xarxes socials",null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[null,"   Serveis professionals independents",null,null,null,null,null,null,{"$f":"Import1T($C37,$D37,$E37,$F37)","v":0},{"$f":"CalcIva($G37,$H37,$I37)","v":0},{"$f":"CalcIrpf($G37,$H37,$I37)","v":0},{"$f":"Import2T($C37,$D37,$E37,$F37)","v":0},{"$f":"CalcIva($G37,$H37,$L37)","v":0},{"$f":"CalcIrpf($G37,$H37,$L37)","v":0},{"$f":"Import3T($C37,$D37,$E37,$F37)","v":0},{"$f":"CalcIva($G37,$H37,$O37)","v":0},{"$f":"CalcIrpf($G37,$H37,$O37)","v":0},{"$f":"Import4T($C37,$D37,$E37,$F37)","v":0},{"$f":"CalcIva($G37,$H37,$R37)","v":0},{"$f":"CalcIrpf($G37,$H37,$R37)","v":0},{"$f":"SUM($I37,$L37,$O37,$R37)","v":0}]
[null,"   Contractacions temporals / Freelance",null,null,null,null,null,null,{"$f":"Import1T($C38,$D38,$E38,$F38)","v":0},{"$f":"CalcIva($G38,$H38,$I38)","v":0},{"$f":"CalcIrpf($G38,$H38,$I38)","v":0},{"$f":"Import2T($C38,$D38,$E38,$F38)","v":0},{"$f":"CalcIva($G38,$H38,$L38)","v":0},{"$f":"CalcIrpf($G38,$H38,$L38)","v":0},{"$f":"Import3T($C38,$D38,$E38,$F38)","v":0},{"$f":"CalcIva($G38,$H38,$O38)","v":0},{"$f":"CalcIrpf($G38,$H38,$O38)","v":0},{"$f":"Import4T($C38,$D38,$E38,$F38)","v":0},{"$f":"CalcIva($G38,$H38,$R38)","v":0},{"$f":"CalcIrpf($G38,$H38,$R38)","v":0},{"$f":"SUM($I38,$L38,$O38,$R38)","v":0}]
[null,"Altres despeses",{"$f":"SUM(C40:C42)","v":0},null,{"$f":"SUM(E40:E42)","v":0},null,null,null,{"$f":"SUM(I40:I42)","v":0},{"$f":"SUM(J40:J42)","v":0},0,{"$f":"SUM(L40:L42)","v":0},{"$f":"SUM(M40:M42)","v":0},0,{"$f":"SUM(O40:O42)","v":0},{"$f":"SUM(P40:P42)","v":0},0,{"$f":"SUM(R40:R42)","v":0},{"$f":"SUM(S40:S42)","v":0},0,{"$f":"SUM(U40:U42)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"Import1T($C40,$D40,$E40,$F40)","v":0},{"$f":"CalcIva($G40,$H40,$I40)","v":0},{"$f":"CalcIrpf($G40,$H40,$I40)","v":0},{"$f":"Import2T($C40,$D40,$E40,$F40)","v":0},{"$f":"CalcIva($G40,$H40,$L40)","v":0},{"$f":"CalcIrpf($G40,$H40,$L40)","v":0},{"$f":"Import3T($C40,$D40,$E40,$F40)","v":0},{"$f":"CalcIva($G40,$H40,$O40)","v":0},{"$f":"CalcIrpf($G40,$H40,$O40)","v":0},{"$f":"Import4T($C40,$D40,$E40,$F40)","v":0},{"$f":"CalcIva($G40,$H40,$R40)","v":0},{"$f":"CalcIrpf($G40,$H40,$R40)","v":0},{"$f":"SUM($I40,$L40,$O40,$R40)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"Import1T($C41,$D41,$E41,$F41)","v":0},{"$f":"CalcIva($G41,$H41,$I41)","v":0},{"$f":"CalcIrpf($G41,$H41,$I41)","v":0},{"$f":"Import2T($C41,$D41,$E41,$F41)","v":0},{"$f":"CalcIva($G41,$H41,$L41)","v":0},{"$f":"CalcIrpf($G41,$H41,$L41)","v":0},{"$f":"Import3T($C41,$D41,$E41,$F41)","v":0},{"$f":"CalcIva($G41,$H41,$O41)","v":0},{"$f":"CalcIrpf($G41,$H41,$O41)","v":0},{"$f":"Import4T($C41,$D41,$E41,$F41)","v":0},{"$f":"CalcIva($G41,$H41,$R41)","v":0},{"$f":"CalcIrpf($G41,$H41,$R41)","v":0},{"$f":"SUM($I41,$L41,$O41,$R41)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"Import1T($C42,$D42,$E42,$F42)","v":0},{"$f":"CalcIva($G42,$H42,$I42)","v":0},{"$f":"CalcIrpf($G42,$H42,$I42)","v":0},{"$f":"Import2T($C42,$D42,$E42,$F42)","v":0},{"$f":"CalcIva($G42,$H42,$L42)","v":0},{"$f":"CalcIrpf($G42,$H42,$L42)","v":0},{"$f":"Import3T($C42,$D42,$E42,$F42)","v":0},{"$f":"CalcIva($G42,$H42,$O42)","v":0},{"$f":"CalcIrpf($G42,$H42,$O42)","v":0},{"$f":"Import4T($C42,$D42,$E42,$F42)","v":0},{"$f":"CalcIva($G42,$H42,$R42)","v":0},{"$f":"CalcIrpf($G42,$H42,$R42)","v":0},{"$f":"SUM($I42,$L42,$O42,$R42)","v":0}]
[null,"Despeses per endeutament",{"$f":"SUM(C44:C47)","v":0},null,{"$f":"SUM(E44:E47)","v":0},null,null,null,{"$f":"SUM(I44:I47)","v":0},{"$f":"SUM(J44:J49)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"   Interesos deutes (Préstecs i Crèdits bancaris)",null,null,null,null,null,null,{"$f":"Import1T($C44,$D44,$E44,$F44)","v":0},null,null,{"$f":"Import2T($C44,$D44,$E44,$F44)","v":0},null,null,{"$f":"Import3T($C44,$D44,$E44,$F44)","v":0},null,null,{"$f":"Import4T($C44,$D44,$E44,$F44)","v":0},null,null,{"$f":"SUM($I44,$L44,$O44,$R44)","v":0}]
[null,"   Amortització capital (Préstecs)",null,null,null,null,null,null,{"$f":"Import1T($C45,$D45,$E45,$F45)","v":0},null,null,0,null,null,0,null,null,0,null,null,0]
[null,"   Leasing",null,null,null,null,null,null,0,{"$f":"CalcIva($G46,$H46,$I46)","v":0},null,0,{"$f":"CalcIva($G46,$H46,$L46)","v":0},null,0,{"$f":"CalcIva($G46,$H46,$O46)","v":0},null,0,{"$f":"CalcIva($G46,$H46,$R46)","v":0},null,0]
[null,"   Renting",null,null,null,null,null,null,0,{"$f":"CalcIva($G47,$H47,$I47)","v":0},null,0,{"$f":"CalcIva($G47,$H47,$L47)","v":0},null,0,{"$f":"CalcIva($G47,$H47,$O47)","v":0},null,0,{"$f":"CalcIva($G47,$H47,$R47)","v":0},null,0]
[null,"   Interesos de préstecs de particulars",null,null,null,null,null,null,0,{"$f":"CalcIva($G48,$H48,$I48)","v":0},{"$f":"CalcIrpf($G48,$H48,$I48)","v":0},0,{"$f":"CalcIva($G48,$H48,$L48)","v":0},{"$f":"CalcIrpf($G48,$H48,$L48)","v":0},0,{"$f":"CalcIva($G48,$H48,$O48)","v":0},{"$f":"CalcIrpf($G48,$H48,$O48)","v":0},0,{"$f":"CalcIva($G48,$H48,$R48)","v":0},{"$f":"CalcIrpf($G48,$H48,$R48)","v":0},0]
[null,null,null,null,null,null,null,null,0,0,{"$f":"CalcIrpf($G49,$H49,$I49)","v":0},0,0,{"$f":"CalcIrpf($G49,$H49,$L49)","v":0},0,0,0,0,0,{"$f":"CalcIrpf($G49,$H49,$R49)","v":0},0]
[null,"Total",{"$f":"SUM(C8,C14,C16,C19,C26,C39,C43)","v":0},null,{"$f":"SUM(E8,E14,E16,E19,E26,E39,E43)","v":0},null,null,null,{"$f":"SUM(I8,I14,I16,I19,I26,I39,I43)","v":0},{"$f":"SUM(J8,J14,J16,J19,J26,J39,J43)","v":0},{"$f":"SUM(K8,K14,K16,K19,K26,K39,K43)","v":0},0,{"$f":"SUM(M8,M14,M16,M19,M26,M39,M43)","v":0},{"$f":"SUM(N8,N14,N16,N19,N26,N39,N43)","v":0},0,{"$f":"SUM(P8,P14,P16,P19,P26,P39,P43)","v":0},{"$f":"SUM(Q8,Q14,Q16,Q19,Q26,Q39,Q43)","v":0},0,{"$f":"SUM(S8,S14,S16,S19,S26,S39,S43)","v":0},{"$f":"SUM(T8,T14,T16,T19,T26,T39,T43)","v":0},{"$f":"SUM(U8,U14,U16,U19,U26,U43,U39)","v":0}]
[]
[null,"INGRESSOS"]
[null,"INGRESSOS PER ACTIVITAT ORDINÀRIA"]
[null," Per venda de productes",{"$f":"SUM(C55:C59)","v":0},null,{"$f":"SUM(E55:E59)","v":0},null,null,null,{"$f":"SUM(I55:I59)","v":0},{"$f":"SUM(J55:J59)","v":0},0,{"$f":"SUM(L55:L59)","v":0},{"$f":"SUM(M55:M59)","v":0},0,{"$f":"SUM(O55:O59)","v":0},{"$f":"SUM(P55:P59)","v":0},0,{"$f":"SUM(R55:R59)","v":0},{"$f":"SUM(S55:S59)","v":0},0,{"$f":"SUM(U55:U59)","v":0}]
[null,"   Producte 1",null,null,null,null,null,null,{"$f":"Import1T($C55,$D55,$E55,$F55)","v":0},{"$f":"CalcIva($G55,$H55,$I55)","v":0},null,{"$f":"Import2T($C55,$D55,$E55,$F55)","v":0},{"$f":"CalcIva($G55,$H55,$L55)","v":0},null,{"$f":"Import3T($C55,$D55,$E55,$F55)","v":0},{"$f":"CalcIva($G55,$H55,$O55)","v":0},null,{"$f":"Import4T($C55,$D55,$E55,$F55)","v":0},{"$f":"CalcIva($G55,$H55,$R55)","v":0},null,{"$f":"SUM($I55,$L55,$O55,$R55)","v":0}]
[null,"   Producte 2",null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[null,"   Producte 3",null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[null,"   Producte 4",null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[null,"   Producte 5",null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[null," Per abonaments",{"$f":"SUM(C61:C62)","v":0},null,{"$f":"SUM(E61:E62)","v":0},null,null,null,{"$f":"SUM(I61:I62)","v":0},{"$f":"SUM(J61:J62)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"   ",null,null,null,null,null,null,{"$f":"Import1T($C61,$D61,$E61,$F61)","v":0},{"$f":"CalcIva($G61,$H61,$I61)","v":0},null,{"$f":"Import2T($C61,$D61,$E61,$F61)","v":0},{"$f":"CalcIva($G61,$H61,$L61)","v":0},null,{"$f":"Import3T($C61,$D61,$E61,$F61)","v":0},{"$f":"CalcIva($G61,$H61,$O61)","v":0},null,{"$f":"Import4T($C61,$D61,$E61,$F61)","v":0},{"$f":"CalcIva($G61,$H61,$R61)","v":0},null,{"$f":"SUM($I61,$L61,$O61,$R61)","v":0}]
[null,"   ",null,null,null,null,null,null,{"$f":"Import1T($C62,$D62,$E62,$F62)","v":0},{"$f":"CalcIva($G62,$H62,$I62)","v":0},null,{"$f":"Import2T($C62,$D62,$E62,$F62)","v":0},{"$f":"CalcIva($G62,$H62,$L62)","v":0},null,{"$f":"Import3T($C62,$D62,$E62,$F62)","v":0},{"$f":"CalcIva($G62,$H62,$O62)","v":0},null,{"$f":"Import4T($C62,$D62,$E62,$F62)","v":0},{"$f":"CalcIva($G62,$H62,$R62)","v":0},null,{"$f":"SUM($I62,$L62,$O62,$R62)","v":0}]
[null," Per prestacions de serveis",{"$f":"SUM(C64:C67)","v":0},null,{"$f":"SUM(E64:E67)","v":0},null,null,null,{"$f":"SUM(I64:I67)","v":0},{"$f":"SUM(J64:J67)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(R64:R67)","v":0},{"$f":"SUM(S64:S67)","v":0},0,{"$f":"SUM(U64:U67)","v":0}]
[null,"   ",null,null,null,null,null,null,{"$f":"Import1T($C64,$D64,$E64,$F64)","v":0},{"$f":"CalcIva($G64,$H64,$I64)","v":0},{"$f":"CalcIrpf($G64,$H64,$I64)","v":0},{"$f":"Import2T($C64,$D64,$E64,$F64)","v":0},{"$f":"CalcIva($G64,$H64,$L64)","v":0},{"$f":"CalcIrpf($G64,$H64,$L64)","v":0},{"$f":"Import3T($C64,$D64,$E64,$F64)","v":0},{"$f":"CalcIva($G64,$H64,$O64)","v":0},{"$f":"CalcIrpf($G64,$H64,$O64)","v":0},{"$f":"Import4T($C64,$D64,$E64,$F64)","v":0},{"$f":"CalcIva($G64,$H64,$R64)","v":0},{"$f":"CalcIrpf($G64,$H64,$R64)","v":0},{"$f":"SUM($I64,$L64,$O64,$R64)","v":0}]
[null,"   ",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   ",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   ",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null," Per lloguers",{"$f":"SUM(C69:C70)","v":0},null,{"$f":"SUM(E69:E70)","v":0},null,null,null,{"$f":"SUM(I69:I70)","v":0},{"$f":"SUM(J69:J70)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U69:U70)","v":0}]
[null,"   Subjectes a IRPF ",null,null,null,null,null,null,0,{"$f":"CalcIva($G69,$H69,$I69)","v":0},{"$f":"CalcIrpf($G69,$H69,$I69)","v":0},0,{"$f":"CalcIva($G69,$H69,$L69)","v":0},{"$f":"CalcIrpf($G69,$H69,$L69)","v":0},0,{"$f":"CalcIva($G69,$H69,$O69)","v":0},{"$f":"CalcIrpf($G69,$H69,$O69)","v":0},0,{"$f":"CalcIva($G69,$H69,$R69)","v":0},{"$f":"CalcIrpf($G69,$H69,$R69)","v":0},0]
[null,"   No subjectes a IRPF ",null,null,null,null,null,null,0,0,null,0,{"$f":"CalcIva($G70,$H70,$L70)","v":0},null,0,{"$f":"CalcIva($G70,$H70,$O70)","v":0},null,0,{"$f":"CalcIva($G70,$H70,$R70)","v":0},null,0]
[]
[null,"TRESORERIA INICAL I INGRESSOS ATÍPICS"]
[null," Per aportacions de fons",{"$f":"SUM(C74:C75)","v":0},null,{"$f":"SUM(E74:E75)","v":0},null,null,null,{"$f":"SUM(I74:I75)","v":0},null,null,{"$f":"SUM(L74:L75)","v":0},null,null,{"$f":"SUM(O74:O75)","v":0},null,null,{"$f":"SUM(R74:R75)","v":0},null,null,{"$f":"SUM(U74:U75)","v":0}]
[null,"   1a aportació",null,null,null,null,null,null,{"$f":"Import1T($C74,$D74,$E74,$F74)","v":0},null,null,{"$f":"Import2T($C74,$D74,$E74,$F74)","v":0},null,null,{"$f":"Import3T($C74,$D74,$E74,$F74)","v":0},null,null,{"$f":"Import4T($C74,$D74,$E74,$F74)","v":0},null,null,{"$f":"SUM($I74,$L74,$O74,$R74)","v":0}]
[null,"   2a aportació",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null," Per obtenció de préstecs",{"$f":"SUM(C77:C78)","v":0},null,{"$f":"SUM(E77:E78)","v":0},null,null,null,{"$f":"SUM(I77:I78)","v":0},null,null,{"$f":"SUM(L77:L78)","v":0},null,null,{"$f":"SUM(O77:O78)","v":0},null,null,{"$f":"SUM(R77:R78)","v":0},null,null,{"$f":"SUM(U77:U78)","v":0}]
[null,"   Préstec 1",null,null,null,null,null,null,{"$f":"Import1T($C77,$D77,$E77,$F77)","v":0},null,null,{"$f":"Import2T($C77,$D77,$E77,$F77)","v":0},null,null,{"$f":"Import3T($C77,$D77,$E77,$F77)","v":0},null,null,{"$f":"Import4T($C77,$D77,$E77,$F77)","v":0},null,null,{"$f":"SUM($I77,$L77,$O77,$R77)","v":0}]
[null,"   Préstec 2",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Total",{"$f":"SUM(C54,C60,C63,C68,C73,C76)","v":0},null,{"$f":"SUM(E54,E60,E63,E68,E73,E76)","v":0},null,null,null,{"$f":"SUM(I54,I60,I63,I68,I73,I76)","v":0},{"$f":"SUM(J54,J60,J63,J68)","v":0},{"$f":"SUM(K54,K60,K63,K68)","v":0},{"$f":"SUM(L54,L60,L63,L68,L73,L76)","v":0},0,{"$f":"SUM(N54,N60,N63,N68)","v":0},{"$f":"SUM(O54,O60,O63,O68,O73,O76)","v":0},0,0,{"$f":"SUM(R54,R60,R63,R68,R73,R76)","v":0},0,0,{"$f":"SUM(U54,U60,U63,U68,U73,U76)","v":0}]
[]
[null,"     TRESORERIA NETA TRIMESTRAL",null,null,null,null,null,null,{"$f":"I79-I50","v":0},null,null,{"$f":"IF(I$81 < 0,(L$79-L$50),(L$79-L$50)+I$81)","v":0},null,null,{"$f":"IF(L$81 < 0,(O$79-O$50),(O$79-O$50)+L$81)","v":0},null,null,{"$f":"IF(O$81 < 0,(R$79-R$50),(R$79-R$50)+O$81)","v":0}]
[]
[null,"     LIQUIDACIONS TRIBUTS",null,null,null,"MENSUAL",null,null,"1er TRIM","2on TRIM",null,null,"3er TRIM",null,null,"4rt TRIM",null,null,null,null,"Acumulat"]
[null,null,"IVA",null,null,null,null,null,{"$f":"J79-J50","v":0},null,null,{"$f":"IF(I$84 < 0,(M$79-M$50)+I$84,(M$79-M$50))","v":0},null,null,{"$f":"IF(L$84 < 0,(P$79-P$50)+L$84,(P$79-P$50))","v":0},null,null,{"$f":"IF(O$84<0,(S$79-S$50)+O$84,(S$79-S$50))","v":0},null,null,{"$f":"IF(R$84 < 0,R$84,0)","v":0}]
[null,null,"IRPF DESPESES  (Jo retinc i liquido)",null,null,null,null,null,{"$f":"K50","v":0},null,null,{"$f":"N50","v":0},null,null,{"$f":"Q50","v":0},null,null,{"$f":"T50","v":0},null,null,{"$f":"I85+L85+O85+R85","v":0}]
[null,null,"IRPF INGRESSOS (Em retenen)",null,null,null,null,null,{"$f":"K79","v":0},null,null,{"$f":"N79","v":0},null,null,{"$f":"Q79","v":0},null,null,{"$f":"T79","v":0},null,null,{"$f":"I86+L86+O86+R86","v":0}]
[null,null,"SEG.SOCIAL",null,null,{"$f":"E11","v":0},null,null,{"$f":"I11","v":0},null,null,{"$f":"L11","v":0},{"$f":"O11","v":0},null,{"$f":"O11","v":0},null,null,{"$f":"R11","v":0}]
[]
[null,null,"Consultes:"]

{"sheet":"PLA VIABILITAT-ORIG","index":1,"n_rows":79,"n_cols":24,"rows_kept":79,"cut":false,"hidden":true,"merged":[[78,5,78,6],[1,2,1,20],[3,1,3,20],[4,1,6,1],[4,2,4,5],[4,8,5,17],[4,20,6,20],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[75,2,75,4],[76,2,76,4],[78,2,78,4],[51,2,52,2],[74,15,74,17],[74,12,74,14],[74,9,74,11],[51,4,52,4],[77,2,77,4],[72,1,72,4],[72,5,72,7],[74,1,74,4],[74,5,74,7],[50,1,52,1],[50,2,50,5],[50,6,52,6],[51,3,52,3],[50,7,52,7],[1,22,1,23],[4,6,5,6],[4,7,5,7],[3,22,6,23],[51,5,52,5],[49,1,49,20],[50,8,51,17],[50,20,52,20]]}
[]
[null,null,"PLA ANUAL TRESORERIA (PREVISIONAL)"]
[]
[null,"DESPESES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PERIODICITATS\nImports acumulats en Trimestres en funció de la liquidació d'impostos"]
[null,"CONCEPTES\nImports / Factures (IVA i IRPF inclosos)","Import",null,null,null,null,null,"Trimestral",null,null,null,null,null,null,null,null,null,null,null,"Acumulat\nAny"]
[null,null,"Puntual","Trimestre","Periòdic","Perio dicitat"]
[null,null,null,null,null,null,"%IVA","%IRPF","1T","iva","irpf","2T","iva","irpf","3T","iva","irpf","4T","iva","irpf"]
[null,"Despeses de pesonal",null,null,null,null,null,null,{"$f":"SUM(I9:I13)","v":0},{"$f":"J13","v":0},{"$f":"K13","v":0},{"$f":"SUM(L9:L13)","v":0},{"$f":"M13","v":0},{"$f":"N13","v":0},{"$f":"SUM(O9:O13)","v":0},{"$f":"P13","v":0},{"$f":"Q13","v":0},{"$f":"SUM(R9:R13)","v":0},{"$f":"S13","v":0},{"$f":"T13","v":0},{"$f":"SUM(I8,L8,O8,R8)","v":0},null,"M","Mensual"]
[null,"   Sous i salaris                                   ",null,null,null,"M",null,null,{"$f":"Import1T($C9,$D9,$E9,$F9)","v":0},null,null,{"$f":"Import2T($C9,$D9,$E9,$F9)","v":0},null,null,{"$f":"Import3T($C9,$D9,$E9,$F9)","v":0},null,null,{"$f":"Import4T($C9,$D9,$E9,$F9)","v":0},null,null,{"$f":"SUM(I9,L9,O9,R9)","v":0},null,"T","Trimestral"]
[null,"        IRPF Sous i Salaris",null,null,null,"M",null,null,{"$f":"Import1T($C10,$D10,$E10,$F10)","v":0},null,null,{"$f":"Import2T($C10,$D10,$E10,$F10)","v":0},null,null,{"$f":"Import3T($C10,$D10,$E10,$F10)","v":0},null,null,{"$f":"Import4T($C10,$D10,$E10,$F10)","v":0},null,null,{"$f":"SUM(I10,L10,O10,R10)","v":0},null,"A 1T","Anual, 1er Trimestre"]
[null,"        Seg. Social",null,null,null,"M",null,null,{"$f":"Import1T($C11,$D11,$E11,$F11)","v":0},null,null,{"$f":"Import2T($C11,$D11,$E11,$F11)","v":0},null,null,{"$f":"Import3T($C11,$D11,$E11,$F11)","v":0},null,null,{"$f":"Import4T($C11,$D11,$E11,$F11)","v":0},null,null,{"$f":"SUM(I11,L11,O11,R11)","v":0},null,"A 2T","Anual, 2n Trimestre"]
[null,"        Autònoms",null,null,null,"M",null,null,{"$f":"Import1T($C12,$D12,$E12,$F12)","v":0},null,null,{"$f":"Import2T($C12,$D12,$E12,$F12)","v":0},null,null,{"$f":"Import3T($C12,$D12,$E12,$F12)","v":0},null,null,{"$f":"Import4T($C12,$D12,$E12,$F12)","v":0},null,null,{"$f":"SUM(I12,L12,O12,R12)","v":0},null,"A 3T","Anual, 3er Trimestre"]
[null,"   Formació                                          ",null,null,null,null,null,null,{"$f":"Import1T($C13,$D13,$E13,$F13)","v":0},{"$f":"CalcIva($G13,$H13,$I13)","v":0},{"$f":"CalcIrpf($G13,$H13,$I13)","v":0},{"$f":"Import2T($C13,$D13,$E13,$F13)","v":0},{"$f":"CalcIva($G13,$H13,$L13)","v":0},{"$f":"CalcIrpf($G13,$H13,$L13)","v":0},{"$f":"Import3T($C13,$D13,$E13,$F13)","v":0},{"$f":"CalcIva($G13,$H13,$O13)","v":0},{"$f":"CalcIrpf($G13,$H13,$O13)","v":0},{"$f":"Import4T($C13,$D13,$E13,$F13)","v":0},{"$f":"CalcIva($G13,$H13,$R13)","v":0},{"$f":"CalcIrpf($G13,$H13,$R13)","v":0},{"$f":"SUM($I13,$L13,$O13,$R13)","v":0},null,"A 4T","Anual, 4rt Trimestre"]
[null,"Tributs / Taxes / Cànons",{"$f":"C15","v":0},null,{"$f":"E15","v":0},null,null,null,{"$f":"I15","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(I14,L14,O14,R14)","v":0},null," S 1/3","Semestral, 1er i 3er Trimestre"]
[null,"   Tributs / Taxes / Cànons",null,null,null,null,null,null,{"$f":"Import1T($C15,$D15,$E15,$F15)","v":0},{"$f":"CalcIva($G15,$H15,$I15)","v":0},{"$f":"CalcIrpf($G15,$H15,$I15)","v":0},{"$f":"Import2T($C15,$D15,$E15,$F15)","v":0},{"$f":"CalcIva($G15,$H15,$L15)","v":0},{"$f":"CalcIrpf($G15,$H15,$L15)","v":0},{"$f":"Import3T($C15,$D15,$E15,$F15)","v":0},{"$f":"CalcIva($G15,$H15,$O15)","v":0},{"$f":"CalcIrpf($G15,$H15,$O15)","v":0},{"$f":"Import4T($C15,$D15,$E15,$F15)","v":0},{"$f":"CalcIva($G15,$H15,$R15)","v":0},{"$f":"CalcIrpf($G15,$H15,$R15)","v":0},{"$f":"SUM($I15,$L15,$O15,$R15)","v":0},null,"S 2/4","Semestral, 2n i 4rt Trimestre"]
[null,"Serveis exteriors",{"$f":"SUM(C17:C18)","v":0},null,{"$f":"SUM(E17:E18)","v":0},null,null,null,{"$f":"SUM(I17:I18)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(I16,L16,O16,R16)","v":0}]
[null,"   Arrendaments",null,null,null,null,null,null,{"$f":"Import1T($C17,$D17,$E17,$F17)","v":0},{"$f":"CalcIva($G17,$H17,$I17)","v":0},{"$f":"CalcIrpf($G17,$H17,$I17)","v":0},{"$f":"Import2T($C17,$D17,$E17,$F17)","v":0},{"$f":"CalcIva($G17,$H17,$L17)","v":0},{"$f":"CalcIrpf($G17,$H17,$L17)","v":0},{"$f":"Import3T($C17,$D17,$E17,$F17)","v":0},{"$f":"CalcIva($G17,$H17,$O17)","v":0},{"$f":"CalcIrpf($G17,$H17,$O17)","v":0},{"$f":"Import4T($C17,$D17,$E17,$F17)","v":0},{"$f":"CalcIva($G17,$H17,$R17)","v":0},{"$f":"CalcIrpf($G17,$H17,$R17)","v":0},{"$f":"SUM($I17,$L17,$O17,$R17)","v":0}]
[null,"   Manteniments",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM($I18,$L18,$O18,$R18)","v":0}]
[null,"Subministraments",{"$f":"SUM(C20:C25)","v":0},null,{"$f":"SUM(E20:E25)","v":0},null,null,null,{"$f":"SUM(I20:I25)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(I19,L19,O19,R19)","v":0}]
[null,"   Aigua",null,null,null,null,null,null,{"$f":"Import1T($C20,$D20,$E20,$F20)","v":0},{"$f":"CalcIva($G20,$H20,$I20)","v":0},{"$f":"CalcIrpf($G20,$H20,$I20)","v":0},{"$f":"Import2T($C20,$D20,$E20,$F20)","v":0},{"$f":"CalcIva($G20,$H20,$L20)","v":0},{"$f":"CalcIrpf($G20,$H20,$L20)","v":0},{"$f":"Import3T($C20,$D20,$E20,$F20)","v":0},{"$f":"CalcIva($G20,$H20,$O20)","v":0},{"$f":"CalcIrpf($G20,$H20,$O20)","v":0},{"$f":"Import4T($C20,$D20,$E20,$F20)","v":0},{"$f":"CalcIva($G20,$H20,$R20)","v":0},{"$f":"CalcIrpf($G20,$H20,$R20)","v":0},{"$f":"SUM($I20,$L20,$O20,$R20)","v":0}]
[null,"   Gas",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Electricitat",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Carburants i combustibles",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Telèfon",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Transmissió de dades",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Despeses ordinaries",{"$f":"SUM(C27:C36)","v":0},null,{"$f":"SUM(E27:E36)","v":0},null,null,null,{"$f":"SUM(I27:I38)","v":0},{"$f":"SUM(J27:J38)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(I26,L26,O26,R26)","v":0}]
[null,"   Aprovisionaments / Mats. Primes / Articles",null,null,null,null,null,null,{"$f":"Import1T($C27,$D27,$E27,$F27)","v":0},{"$f":"CalcIva($G27,$H27,$I27)","v":0},{"$f":"CalcIrpf($G27,$H27,$I27)","v":0},{"$f":"Import2T($C27,$D27,$E27,$F27)","v":0},{"$f":"CalcIva($G27,$H27,$L27)","v":0},{"$f":"CalcIrpf($G27,$H27,$L27)","v":0},{"$f":"Import3T($C27,$D27,$E27,$F27)","v":0},{"$f":"CalcIva($G27,$H27,$O27)","v":0},{"$f":"CalcIrpf($G27,$H27,$O27)","v":0},{"$f":"Import4T($C27,$D27,$E27,$F27)","v":0},{"$f":"CalcIva($G27,$H27,$R27)","v":0},{"$f":"CalcIrpf($G27,$H27,$R27)","v":0},{"$f":"SUM($I27,$L27,$O27,$R27)","v":0}]
[null,"   Reparació i conservació",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Material oficina i fungible",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Correus i misatgeria",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Serveis bancaris, TPV i similars ",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Quotes, Subscripcions i documentació",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Despeses de viatge",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Transports ",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   Primes d'assegurances",null,null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"   Publicitat, propaganda i xarxes socials",null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[null,"   Serveis professionals independents",null,null,null,null,null,null,{"$f":"Import1T($C37,$D37,$E37,$F37)","v":0},{"$f":"CalcIva($G37,$H37,$I37)","v":0},{"$f":"CalcIrpf($G37,$H37,$I37)","v":0},{"$f":"Import2T($C37,$D37,$E37,$F37)","v":0},{"$f":"CalcIva($G37,$H37,$L37)","v":0},{"$f":"CalcIrpf($G37,$H37,$L37)","v":0},{"$f":"Import3T($C37,$D37,$E37,$F37)","v":0},{"$f":"CalcIva($G37,$H37,$O37)","v":0},{"$f":"CalcIrpf($G37,$H37,$O37)","v":0},{"$f":"Import4T($C37,$D37,$E37,$F37)","v":0},{"$f":"CalcIva($G37,$H37,$R37)","v":0},{"$f":"CalcIrpf($G37,$H37,$R37)","v":0},{"$f":"SUM($I37,$L37,$O37,$R37)","v":0}]
[null,"   Contractacions temporals / Freelance",null,null,null,null,null,null,{"$f":"Import1T($C38,$D38,$E38,$F38)","v":0},{"$f":"CalcIva($G38,$H38,$I38)","v":0},{"$f":"CalcIrpf($G38,$H38,$I38)","v":0},{"$f":"Import2T($C38,$D38,$E38,$F38)","v":0},{"$f":"CalcIva($G38,$H38,$L38)","v":0},{"$f":"CalcIrpf($G38,$H38,$L38)","v":0},{"$f":"Import3T($C38,$D38,$E38,$F38)","v":0},{"$f":"CalcIva($G38,$H38,$O38)","v":0},{"$f":"CalcIrpf($G38,$H38,$O38)","v":0},{"$f":"Import4T($C38,$D38,$E38,$F38)","v":0},{"$f":"CalcIva($G38,$H38,$R38)","v":0},{"$f":"CalcIrpf($G38,$H38,$R38)","v":0},{"$f":"SUM($I38,$L38,$O38,$R38)","v":0}]
[null,"Altres despeses",{"$f":"SUM(C40:C42)","v":0},null,{"$f":"SUM(E40:E42)","v":0},null,null,null,{"$f":"SUM(I40:I42)","v":0},{"$f":"SUM(J40:J42)","v":0},0,{"$f":"SUM(L40:L42)","v":0},{"$f":"SUM(M40:M42)","v":0},0,{"$f":"SUM(O40:O42)","v":0},{"$f":"SUM(P40:P42)","v":0},0,{"$f":"SUM(R40:R42)","v":0},{"$f":"SUM(S40:S42)","v":0},0,{"$f":"SUM(I39,L39,O39,R39)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"Import1T($C40,$D40,$E40,$F40)","v":0},{"$f":"CalcIva($G40,$H40,$I40)","v":0},{"$f":"CalcIrpf($G40,$H40,$I40)","v":0},{"$f":"Import2T($C40,$D40,$E40,$F40)","v":0},{"$f":"CalcIva($G40,$H40,$L40)","v":0},{"$f":"CalcIrpf($G40,$H40,$L40)","v":0},{"$f":"Import3T($C40,$D40,$E40,$F40)","v":0},{"$f":"CalcIva($G40,$H40,$O40)","v":0},{"$f":"CalcIrpf($G40,$H40,$O40)","v":0},{"$f":"Import4T($C40,$D40,$E40,$F40)","v":0},{"$f":"CalcIva($G40,$H40,$R40)","v":0},{"$f":"CalcIrpf($G40,$H40,$R40)","v":0},{"$f":"SUM($I40,$L40,$O40,$R40)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"Import1T($C41,$D41,$E41,$F41)","v":0},{"$f":"CalcIva($G41,$H41,$I41)","v":0},{"$f":"CalcIrpf($G41,$H41,$I41)","v":0},{"$f":"Import2T($C41,$D41,$E41,$F41)","v":0},{"$f":"CalcIva($G41,$H41,$L41)","v":0},{"$f":"CalcIrpf($G41,$H41,$L41)","v":0},{"$f":"Import3T($C41,$D41,$E41,$F41)","v":0},{"$f":"CalcIva($G41,$H41,$O41)","v":0},{"$f":"CalcIrpf($G41,$H41,$O41)","v":0},{"$f":"Import4T($C41,$D41,$E41,$F41)","v":0},{"$f":"CalcIva($G41,$H41,$R41)","v":0},{"$f":"CalcIrpf($G41,$H41,$R41)","v":0},{"$f":"SUM($I41,$L41,$O41,$R41)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"Import1T($C42,$D42,$E42,$F42)","v":0},{"$f":"CalcIva($G42,$H42,$I42)","v":0},{"$f":"CalcIrpf($G42,$H42,$I42)","v":0},{"$f":"Import2T($C42,$D42,$E42,$F42)","v":0},{"$f":"CalcIva($G42,$H42,$L42)","v":0},{"$f":"CalcIrpf($G42,$H42,$L42)","v":0},{"$f":"Import3T($C42,$D42,$E42,$F42)","v":0},{"$f":"CalcIva($G42,$H42,$O42)","v":0},{"$f":"CalcIrpf($G42,$H42,$O42)","v":0},{"$f":"Import4T($C42,$D42,$E42,$F42)","v":0},{"$f":"CalcIva($G42,$H42,$R42)","v":0},{"$f":"CalcIrpf($G42,$H42,$R42)","v":0},{"$f":"SUM($I42,$L42,$O42,$R42)","v":0}]
[null,"Despeses per endeutament",{"$f":"SUM(C44:C45)","v":0},null,{"$f":"SUM(E44:E45)","v":0},null,null,null,{"$f":"SUM(I44:I45)","v":0},{"$f":"SUM(J44:J47)","v":0},{"$f":"SUM(K44:K47)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(I43,L43,O43,R43)","v":0}]
[null,"   Interesos deutes (Préstecs / Crèdits)",null,null,null,null,null,null,{"$f":"Import1T($C44,$D44,$E44,$F44)","v":0},null,null,{"$f":"Import2T($C44,$D44,$E44,$F44)","v":0},null,null,{"$f":"Import3T($C44,$D44,$E44,$F44)","v":0},null,null,{"$f":"Import4T($C44,$D44,$E44,$F44)","v":0},null,null,{"$f":"SUM($I44,$L44,$O44,$R44)","v":0}]
[null,"   Amortització capital (Préstecs)",null,null,null,null,null,null,{"$f":"Import1T($C45,$D45,$E45,$F45)","v":0},null,null,0,null,null,0,null,null,0,null,null,0]
[null,"   Leasing",null,null,null,null,null,null,0,{"$f":"CalcIva($G46,$H46,$I46)","v":0},null,0,{"$f":"CalcIva($G46,$H46,$L46)","v":0},null,0,{"$f":"CalcIva($G46,$H46,$O46)","v":0},null,0,{"$f":"CalcIva($G46,$H46,$R46)","v":0},null,0]
[null,"   Renting",null,null,null,null,null,null,0,{"$f":"CalcIva($G47,$H47,$I47)","v":0},null,0,{"$f":"CalcIva($G47,$H47,$L47)","v":0},null,0,{"$f":"CalcIva($G47,$H47,$O47)","v":0},null,0,{"$f":"CalcIva($G47,$H47,$R47)","v":0},null,0]
[null,"Total",{"$f":"SUM(C8,C14,C16,C19,C26,C43)","v":0},null,{"$f":"SUM(E8,E14,E16,E19,E26,E43)","v":0},null,null,null,{"$f":"SUM(I8,I14,I16,I19,I26,I39,I43)","v":0},{"$f":"SUM(J8,J14,J16,J19,J26,J39,J43)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U8,U14,U16,U19,U26,U43,U39)","v":0}]
[]
[null,"INGRESSOS"]
[null,"CONCEPTES\nImports / Factures (IVA i IRPF inclosos)","Import",null,null,null,"% IVA","% IRPF","Trimestral",null,null,null,null,null,null,null,null,null,null,null,"Acumulat\nAny"]
[null,null,"Puntual","Trimestre","Periòdic","Perio dicitat"]
[null,null,null,null,null,null,null,null,"1T",null,null,"2T",null,null,"3T",null,null,"4T"]
[null,"Per venda de productes",{"$f":"SUM(C55:C59)","v":0},null,{"$f":"SUM(E55:E59)","v":0},null,null,null,{"$f":"SUM(I55:I59)","v":0},{"$f":"SUM(J55:J59)","v":0},0,{"$f":"SUM(L55:L59)","v":0},{"$f":"SUM(M55:M59)","v":0},0,{"$f":"SUM(O55:O59)","v":0},{"$f":"SUM(P55:P59)","v":0},0,{"$f":"SUM(R55:R59)","v":0},{"$f":"SUM(S55:S59)","v":0},0,{"$f":"SUM(I54,L54,O54,R54)","v":0}]
[null,"   Producte 1",null,null,null,null,null,null,{"$f":"Import1T($C55,$D55,$E55,$F55)","v":0},{"$f":"CalcIva($G55,$H55,$I55)","v":0},null,{"$f":"Import2T($C55,$D55,$E55,$F55)","v":0},{"$f":"CalcIva($G55,$H55,$L55)","v":0},null,{"$f":"Import3T($C55,$D55,$E55,$F55)","v":0},{"$f":"CalcIva($G55,$H55,$O55)","v":0},null,{"$f":"Import4T($C55,$D55,$E55,$F55)","v":0},{"$f":"CalcIva($G55,$H55,$R55)","v":0},null,{"$f":"SUM($I55,$L55,$O55,$R55)","v":0}]
[null,"   Producte 2",null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[null,"   Producte 3",null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[null,"   Producte 4",null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[null,"   Producte 5",null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[null,"Per abonaments",{"$f":"SUM(C61:C62)","v":0},null,{"$f":"SUM(E61:E62)","v":0},null,null,null,{"$f":"SUM(I61:I62)","v":0},{"$f":"SUM(J61:J62)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(I60,L60,O60,R60)","v":0}]
[null,"   ",null,null,null,null,null,null,{"$f":"Import1T($C61,$D61,$E61,$F61)","v":0},{"$f":"CalcIva($G61,$H61,$I61)","v":0},null,{"$f":"Import2T($C61,$D61,$E61,$F61)","v":0},{"$f":"CalcIva($G61,$H61,$L61)","v":0},null,{"$f":"Import3T($C61,$D61,$E61,$F61)","v":0},{"$f":"CalcIva($G61,$H61,$O61)","v":0},null,{"$f":"Import4T($C61,$D61,$E61,$F61)","v":0},{"$f":"CalcIva($G61,$H61,$R61)","v":0},null,{"$f":"SUM($I61,$L61,$O61,$R61)","v":0}]
[null,"   ",null,null,null,null,null,null,{"$f":"Import1T($C62,$D62,$E62,$F62)","v":0},{"$f":"CalcIva($G62,$H62,$I62)","v":0},null,{"$f":"Import2T($C62,$D62,$E62,$F62)","v":0},{"$f":"CalcIva($G62,$H62,$L62)","v":0},null,{"$f":"Import3T($C62,$D62,$E62,$F62)","v":0},{"$f":"CalcIva($G62,$H62,$O62)","v":0},null,{"$f":"Import4T($C62,$D62,$E62,$F62)","v":0},{"$f":"CalcIva($G62,$H62,$R62)","v":0},null,{"$f":"SUM($I62,$L62,$O62,$R62)","v":0}]
[null,"Per prestacions de serveis",{"$f":"SUM(C64:C67)","v":0},null,{"$f":"SUM(E64:E67)","v":0},null,null,null,{"$f":"SUM(I64:I67)","v":0},{"$f":"SUM(J64:J67)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(R64:R67)","v":0},{"$f":"SUM(S64:S67)","v":0},0,{"$f":"SUM(I63,L63,O63,R63)","v":0}]
[null,"   ",null,null,null,null,null,null,{"$f":"Import1T($C64,$D64,$E64,$F64)","v":0},{"$f":"CalcIva($G64,$H64,$I64)","v":0},{"$f":"CalcIrpf($G64,$H64,$I64)","v":0},{"$f":"Import2T($C64,$D64,$E64,$F64)","v":0},{"$f":"CalcIva($G64,$H64,$L64)","v":0},{"$f":"CalcIrpf($G64,$H64,$L64)","v":0},{"$f":"Import3T($C64,$D64,$E64,$F64)","v":0},{"$f":"CalcIva($G64,$H64,$O64)","v":0},{"$f":"CalcIrpf($G64,$H64,$O64)","v":0},{"$f":"Import4T($C64,$D64,$E64,$F64)","v":0},{"$f":"CalcIva($G64,$H64,$R64)","v":0},{"$f":"CalcIrpf($G64,$H64,$R64)","v":0},{"$f":"SUM($I64,$L64,$O64,$R64)","v":0}]
[null,"   ",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   ",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"   ",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Per lloguers",{"$f":"SUM(C70:C71)","v":0},null,{"$f":"SUM(E70:E71)","v":0},null,null,null,{"$f":"SUM(I69:I70)","v":0},{"$f":"SUM(J69:J70)","v":0},0,{"$f":"SUM(L69:L70)","v":0},{"$f":"SUM(M69:M70)","v":0},{"$f":"SUM(N69:N70)","v":0},{"$f":"SUM(O69:O70)","v":0},{"$f":"SUM(P69:P70)","v":0},{"$f":"SUM(Q69:Q70)","v":0},{"$f":"SUM(R69:R70)","v":0},{"$f":"SUM(S69:S70)","v":0},{"$f":"SUM(T69:T70)","v":0},{"$f":"SUM(I68,L68,O68,R68)","v":0}]
[null,"   Subjectes a IRPF ",null,null,null,null,null,null,0,{"$f":"CalcIva($G69,$H69,$I69)","v":0},{"$f":"CalcIrpf($G69,$H69,$I69)","v":0},0,{"$f":"CalcIva($G69,$H69,$L69)","v":0},{"$f":"CalcIrpf($G69,$H69,$L69)","v":0},0,{"$f":"CalcIva($G69,$H69,$O69)","v":0},{"$f":"CalcIrpf($G69,$H69,$O69)","v":0},0,{"$f":"CalcIva($G69,$H69,$R69)","v":0},{"$f":"CalcIrpf($G69,$H69,$R69)","v":0},0]
[null,"   No Subjectes a IRPF ",null,null,null,null,null,null,{"$f":"Import1T($C70,$D70,$E70,$F70)","v":0},0,null,0,{"$f":"CalcIva($G70,$H70,$L70)","v":0},null,0,{"$f":"CalcIva($G70,$H70,$O70)","v":0},null,0,{"$f":"CalcIva($G70,$H70,$R70)","v":0},null,0]
[null,"Total",{"$f":"SUM(C54,C63,C60)","v":0},null,{"$f":"SUM(E54,E63,E60)","v":0},null,null,null,{"$f":"SUM(I54,I60,I63,I68)","v":0},{"$f":"SUM(J54,J60,J63,J68)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U54,U63,U60)","v":0}]
[]
[null,"     TRESORERIA NETA TRIMESTRAL",null,null,null,null,null,null,{"$f":"I71-I48","v":0},null,null,{"$f":"L71-L48","v":0},null,null,{"$f":"O71-O48","v":0},null,null,{"$f":"R71-R48","v":0}]
[]
[null,"     LIQUIDACIONS TRIBUTS",null,null,null,"MENSUAL",null,null,"1er TRIM","2on TRIM",null,null,"3er TRIM",null,null,"4rt TRIM",null,null,null,null,"Acumulat"]
[null,null,"IVA",null,null,null,null,null,{"$f":"J71-J48","v":0},null,null,{"$f":"IF(I$76 < 0,(M$71-M$48)+I$76,(M$71-M$48))","v":0},null,null,{"$f":"IF(L$76 < 0,(P$71-P$48)+L$76,(P$71-P$48))","v":0},null,null,{"$f":"IF(O$76<0,(S$71-S$48)+O$76,(S$71-S$48))","v":0},null,null,{"$f":"IF(R$76 < 0,R$76,0)","v":0}]
[null,null,"IRPF DESPESES  (Jo reting i liquido)",null,null,null,null,null,{"$f":"K48","v":0},null,null,{"$f":"N48","v":0},null,null,{"$f":"Q48","v":0},null,null,{"$f":"T48","v":0},null,null,{"$f":"I77+L77+O77+R77","v":0}]
[null,null,"IRPF INGRESSOS (Em retenen)",null,null,null,null,null,{"$f":"K71","v":0},null,null,{"$f":"N71","v":0},null,null,{"$f":"Q71","v":0},null,null,{"$f":"T71","v":0},null,null,{"$f":"I78+L78+O78+R78","v":0}]
[null,null,"SEG.SOCIAL",null,null,{"$f":"E11","v":0},null,null,{"$f":"I11","v":0},null,null,{"$f":"L11","v":0},{"$f":"O11","v":0},null,{"$f":"O11","v":0},null,null,{"$f":"R11","v":0}]

{"sheet":"Taules","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"IVA","IRPF","Puntual","Periòde"]
[null,21,19,"1T","M"]
[null,10,15,"2T","T"]
[null,4,7,"3T","A 1T"]
[null,0,2,"4T","A 2T"]
[null,null,1,null,"A 3T"]
[null,null,0,null,"A 4T"]
[null,null,null,null,"S 1/3"]
[null,null,null,null,"S 2/4"]