{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Total","México"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Total","index":0,"n_rows":64,"n_cols":24,"rows_kept":64,"cut":false,"hidden":false,"merged":[[44,3,44,4],[44,6,44,7]]}
[]
["Nº PRESUPUESTO:",null,"Nº BRIEFING",null,"CLIENTE:",null,{"$f":"TODAY()","v":"2019-06-28"},"Validez: 30 días"]
[]
["COSTES INTERNOS","INTERNO","VENTA",null,null,"Margen  3as","Mínimo 15%",null,"ESTUDIOS"]
["Jefatura de Línea",55.19,85,null,null,"General",0.25,null,"Descuento"]
["Jefatura de Proyectos",49.97,65,null,null,"Impresión",0.23080000000000001,null,"Nº Investigadores"]
["Administración",49.29,55,null,null,"Acreditación",0.92337170000000002,null,"DURACIÓN"]
["Diseño y Maquetación",56.38,80,null,null,"tipo 4"]
["IT",47.22,80,null,null,"tipo 5"]
["Coordinación",63.44,85,null,null,"tipo 6"]
["Dirección",0,150,null,null,"tipo 7",null,null,"IVA",0.21]
["KAM",0,80,null,null,"tipo 8"]
["Marketing",0,75,null,null,"tipo 9"]
[]
["È","È",null,"È",null,null,null,null,null,null,null,null,null,null,null,"È","È","È"]
[null,null,null,null,null,"SERVICIOS INTERNOS SANED",null,null,null,null,null,"SERVICIOS DE TERCERAS PARTES"]
["DESCRIPCIÓN","UDS","PERFIL","HORAS","HORA/ HOMBRE","COSTE HORA/HOMBRE","TOTAL COSTE","VALOR SANED","TOTAL VALOR SANED","PRECIO HORA/ HOMBRE"," GESTIÓN","COSTE UNITARIO","TOTAL COSTE","PRECIO UNITARIO","TOTAL ","PRECIO UNITARIO","TOTAL PROYECTO","PRECIO ESPECIAL CLIENTE","BENEFICIO","MARGEN","DTO APLICADO","% DTO APLICADO","BENEFICIO DESCUENTO","MARGEN DESCUENTO"]
["DIAGNÓSTICO  Y GESTIÓN INTEGRAL",null,null,null,null,null,{"$f":"SUM(G19:G21)","v":0},null,null,null,{"$f":"SUM(K19:K21)","v":0},null,{"$f":"SUM(M19:M21)","v":0},null,{"$f":"SUM(O19:O21)","v":0},null,{"$f":"O18+K18","v":0},{"$f":"SUM(R19:R21)","v":0},{"$f":"Q18-(M18+G18)","v":0},{"$f":"IF(S18>0,S18/Q18,\"-\")","v":"-"},{"$f":"+R18-Q18","v":0},{"$f":"IF(U18<0,1-(R18/Q18),\"-\")","v":"-"},{"$f":"R18-(M18+G18)","v":0},{"$f":"IF(R18>0,W18/R18,\"-\")","v":"-"}]
[null,null,null,{"$f":"E19","v":0},null,{"$f":"SUMIF($A$5:$A$13,C19,$B$5:$B$13)","v":0},{"$f":"F19*E19","v":0},0,{"$f":"+H19*B19","v":0},{"$f":"SUMIF($A$5:$A$13,C19,$C$5:$C$13)","v":0},{"$f":"(E19*J19)+I19","v":0},null,{"$f":"L19*B19","v":0},{"$f":"L19/(1-$G$5)","v":0},{"$f":"N19*B19","v":0},{"$f":"+N19+J19+H19","v":0},0,{"$f":"+Q19","v":0},{"$f":"R19-(M19+G19)","v":0},"-",{"$f":"+R19-Q19","v":0},{"$f":"IF(U19<0,1-(R19/Q19),\"-\")","v":"-"},0,{"$f":"IF(W19>0,W19/R19,\"-\")","v":"-"}]
[null,null,null,{"$f":"E20","v":0},null,{"$f":"SUMIF($A$5:$A$13,C20,$B$5:$B$13)","v":0},{"$f":"F20*E20","v":0},0,{"$f":"+H20*B20","v":0},{"$f":"SUMIF($A$5:$A$13,C20,$C$5:$C$13)","v":0},{"$f":"(E20*J20)+I20","v":0},null,{"$f":"L20*B20","v":0},{"$f":"L20/(1-$G$5)","v":0},{"$f":"N20*B20","v":0},{"$f":"+N20+J20+H20","v":0},0,{"$f":"Q20","v":0},{"$f":"R20-(M20+G20)","v":0},"-",{"$f":"+R20-Q20","v":0},{"$f":"IF(U20<0,1-(R20/Q20),\"-\")","v":"-"},0,"-"]
[null,null,null,{"$f":"E21","v":0},null,{"$f":"SUMIF($A$5:$A$13,C21,$B$5:$B$13)","v":0},{"$f":"F21*E21","v":0},0,{"$f":"+H21*B21","v":0},{"$f":"SUMIF($A$5:$A$13,C21,$C$5:$C$13)","v":0},{"$f":"(E21*J21)+I21","v":0},null,{"$f":"L21*B21","v":0},{"$f":"L21/(1-$G$5)","v":0},{"$f":"N21*B21","v":0},{"$f":"+N21+J21+H21","v":0},0,{"$f":"+Q21","v":0},{"$f":"Q21-(M21+G21)","v":0},"-",0,"-",0,"-"]
["SERVICIOS",null,null,null,null,null,{"$f":"+G23+G26","v":333.13000199999999},null,null,null,{"$f":"+K23+K26","v":433.32900000000001},null,{"$f":"+M23+M26","v":0},null,{"$f":"+O23+O26","v":0},null,433.32900000000001,{"$f":"+R23+R26","v":433.32900000000001},100.19899800000002,0.23123076923076927,{"$f":"+R22-Q22","v":0},{"$f":"IF(U22<0,1-(R22/Q22),\"-\")","v":"-"},100.19899800000002,0.23123076923076927]
["Subservicios",null,null,null,null,null,{"$f":"+G24+G25","v":333.13000199999999},null,null,null,{"$f":"+K24+K25","v":433.32900000000001},null,{"$f":"+M24+M25","v":0},null,{"$f":"+O24+O25","v":0},null,433.32900000000001,{"$f":"+R24+R25","v":433.32900000000001},100.19899800000002,0.23123076923076927,0,"-",100.19899800000002,0.23123076923076927]
[null,1,"Jefatura de Proyectos",null,6.6665999999999999,{"$f":"SUMIF($A$5:$A$13,C24,$B$5:$B$13)","v":49.97},{"$f":"F24*E24","v":333.13000199999999},0,{"$f":"+H24*B24","v":0},{"$f":"SUMIF($A$5:$A$13,C24,$C$5:$C$13)","v":65},{"$f":"(E24*J24)+I24","v":433.32900000000001},null,{"$f":"L24*B24","v":0},{"$f":"L24/(1-$G$5)","v":0},{"$f":"N24*B24","v":0},{"$f":"+N24+J24+H24","v":65},433.32900000000001,{"$f":"Q24","v":433.32900000000001},100.19899800000002,0.23123076923076927,0,"-",100.19899800000002,0.23123076923076927]
[null,null,null,null,null,{"$f":"SUMIF($A$5:$A$13,C25,$B$5:$B$13)","v":0},{"$f":"F25*E25","v":0},0,{"$f":"+H25*B25","v":0},{"$f":"SUMIF($A$5:$A$13,C25,$C$5:$C$13)","v":0},{"$f":"(E25*J25)+I25","v":0},null,{"$f":"L25*B25","v":0},{"$f":"L25/(1-$G$5)","v":0},{"$f":"N25*B25","v":0},{"$f":"+N25+J25+H25","v":0},0,{"$f":"Q25","v":0},0,"-",0,"-",0,"-"]
[null,null,null,null,null,null,{"$f":"+G27","v":0},null,null,null,{"$f":"+K27","v":0},null,{"$f":"+M27","v":0},null,{"$f":"+O27","v":0},null,0,{"$f":"+R27","v":0},0,"-",0,"-",0,"-"]
[null,null,null,null,null,{"$f":"SUMIF($A$5:$A$13,C27,$B$5:$B$13)","v":0},{"$f":"F27*E27","v":0},0,{"$f":"+H27*B27","v":0},{"$f":"SUMIF($A$5:$A$13,C27,$C$5:$C$13)","v":0},{"$f":"(E27*J27)+I27","v":0},null,{"$f":"L27*B27","v":0},{"$f":"L27/(1-$G$5)","v":0},{"$f":"N27*B27","v":0},{"$f":"+N27+J27+H27","v":0},0,{"$f":"Q27","v":0},0,"-",0,"-",0,"-"]
["SERVICIOS 1",null,null,null,null,null,{"$f":"SUM(G29:G31)","v":0},null,null,null,{"$f":"SUM(K29:K31)","v":0},null,{"$f":"SUM(M29:M31)","v":0},null,{"$f":"SUM(O29:O31)","v":0},null,0,{"$f":"SUM(R29:R31)","v":0},0,"-",0,"-",0,"-"]
[null,null,null,null,null,{"$f":"SUMIF($A$5:$A$13,C29,$B$5:$B$13)","v":0},{"$f":"F29*E29","v":0},0,{"$f":"+H29*B29","v":0},{"$f":"SUMIF($A$5:$A$13,C29,$C$5:$C$13)","v":0},{"$f":"(E29*J29)+I29","v":0},null,{"$f":"L29*B29","v":0},{"$f":"L29/(1-$G$5)","v":0},{"$f":"N29*B29","v":0},{"$f":"+N29+J29+H29","v":0},0,0,0,"-",0,"-",0,"-"]
[null,null,null,null,null,{"$f":"SUMIF($A$5:$A$13,C30,$B$5:$B$13)","v":0},{"$f":"F30*E30","v":0},0,{"$f":"+H30*B30","v":0},{"$f":"SUMIF($A$5:$A$13,C30,$C$5:$C$13)","v":0},{"$f":"(E30*J30)+I30","v":0},null,{"$f":"L30*B30","v":0},{"$f":"L30/(1-$G$5)","v":0},{"$f":"N30*B30","v":0},{"$f":"+N30+J30+H30","v":0},0,0,0,"-",0,"-",0,"-"]
[null,null,null,null,null,{"$f":"SUMIF($A$5:$A$13,C31,$B$5:$B$13)","v":0},{"$f":"F31*E31","v":0},0,{"$f":"+H31*B31","v":0},{"$f":"SUMIF($A$5:$A$13,C31,$C$5:$C$13)","v":0},{"$f":"(E31*J31)+I31","v":0},null,{"$f":"L31*B31","v":0},{"$f":"L31/(1-$G$7)","v":0},{"$f":"N31*B31","v":0},{"$f":"+N31+J31+H31","v":0},0,0,0,"-",0,"-",0,"-"]
["TOTAL SERVICIOS",null,null,null,null,null,{"$f":"SUM(G18,G22,G28,G34)","v":333.13000199999999},null,null,null,{"$f":"+K28+K22+K18","v":433.32900000000001},null,{"$f":"SUM(M18,M22,M28)","v":0},null,{"$f":"+O28+O22+O18","v":0},null,{"$f":"+O32+K32","v":433.32900000000001},{"$f":"+R28+R22+R18","v":433.32900000000001},{"$f":"Q32-L47","v":100.19899800000002},{"$f":"IF(S32>0,S32/Q32,\"-\")","v":0.23123076923076927},{"$f":"+R32-Q32","v":0},"-",{"$f":"R32-L47","v":100.19899800000002},{"$f":"IF(W32>0,W32/R32,\"-\")","v":0.23123076923076927}]
[]
["HONORARIOS",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M35:M39)","v":0},null,{"$f":"SUM(O35:O38)","v":0},null,{"$f":"O34","v":0},{"$f":"SUM(R35:R38)","v":0},0,"-",0,"-",0,"-"]
["Autores",null,null,null,null,null,null,null,null,null,null,null,{"$f":"L35*B35","v":0},{"$f":"L35","v":0},{"$f":"M35","v":0},{"$f":"+N35","v":0},0,0,0,"-",0,"-",0,"-"]
["Coordinadores",null,null,null,null,null,null,null,null,null,null,null,{"$f":"L36*B36","v":0},{"$f":"L36","v":0},{"$f":"M36","v":0},{"$f":"+N36","v":0},{"$f":"+O36","v":0},{"$f":"Q36","v":0},{"$f":"Q36-(M36+G36)","v":0},{"$f":"IF(S36>0,S36/Q36,\"-\")","v":"-"},{"$f":"+R36-Q36","v":0},{"$f":"IF(U36<0,1-(R36/Q36),\"-\")","v":"-"},{"$f":"R36-(M36+G36)","v":0},{"$f":"IF(R36>0,W36/R36,\"-\")","v":"-"}]
["Aval Sociedad",null,null,null,null,null,null,null,null,null,null,null,{"$f":"L37*B37","v":0},{"$f":"L37","v":0},0,0,0,0,0,"-",0,"-",0,{"$f":"IF(R37>0,W37/R37,\"-\")","v":"-"}]
["Becas",null,null,null,null,null,null,null,null,null,null,null,{"$f":"L38*B38","v":0},{"$f":"L38","v":0},{"$f":"M38","v":0},{"$f":"+N38","v":0},{"$f":"+O38","v":0},{"$f":"Q38","v":0},{"$f":"Q38-(M38+G38)","v":0},{"$f":"IF(S38>0,S38/Q38,\"-\")","v":"-"},{"$f":"+R38-Q38","v":0},{"$f":"IF(U38<0,1-(R38/Q38),\"-\")","v":"-"},{"$f":"R38-(M38+G38)","v":0},{"$f":"IF(R38>0,W38/R38,\"-\")","v":"-"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL BRUTO",{"$f":"+Q32+Q34","v":433.32900000000001},{"$f":"+R32+R34","v":433.32900000000001},{"$f":"Q40-(L46+L45)","v":100.19899800000002},{"$f":"IF(S40>0,S40/Q40,\"-\")","v":0.23123076923076927},{"$f":"+R40-Q40","v":0},"-",{"$f":"R40-(L45+L46)","v":100.19899800000002},{"$f":"IF(W40>0,W40/R40,\"-\")","v":0.23123076923076927}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IVA",{"$f":"+Q40*J11","v":90.999089999999995},{"$f":"+R40*J11","v":90.999089999999995}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Presupuesto",{"$f":"+Q40+Q41","v":524.32808999999997},{"$f":"+R40+R41","v":524.32808999999997}]
[]
[]
["A tener en cuenta:",null,null,"Cálculo horas corrección y edición",null,null,"Cálculo Diseño y Maquetación",null,null,null,"COSTE INTERNO",{"$f":"+G32","v":333.13000199999999}]
["Secretaría técnica ","4,5h/mes",null,"Nº págs","Horas",null,"Nº págs","EUROS",null,null,"COSTE EXTERNO",{"$f":"+M34+M32","v":0}]
["Acreditación jefa proyecto"," 6h",null,40,{"$f":"+(D47*5)/60*2","v":6.666666666666667},null,0,{"$f":"+(G47*8)+250","v":250},null,null,"TOTAL COSTE (SIN HONORARIOS)",{"$f":"+G32+M32","v":333.13000199999999}]
[]
[]
[]
[]
[]
[]
["TIPOLOGÍA","COSTE","PRECIO","BENEFICIO","MARGEN %","PRECIO DESCUENTO","BENEFICIO DESCUENTO","MARGEN % DESCUENTO",null,null,null,"CARGA DE TRABAJO","HORAS","COSTE","PRECIO"]
["INTERNO",{"$f":"G32","v":333.13000199999999},{"$f":"+K32","v":433.32900000000001},{"$f":"C55-B55","v":100.19899800000002},{"$f":"IF(C55>0,(C55-B55)/C55,\"-\")","v":0.23123076923076927},null,null,null,null,null,null,{"$f":"A5","v":"Jefatura de Línea"},{"$f":"SUMIF(C:C,L55,E:E)","v":0},{"$f":"SUMIF(C:C,L55,G:G)","v":0},{"$f":"SUMIF(C:C,L55,K:K)","v":0}]
["EXTERNO",{"$f":"+M32","v":0},{"$f":"+O32","v":0},0,"-",null,null,null,null,null,null,"Jefatura de Proyectos",{"$f":"SUMIF(C:C,L56,E:E)","v":6.6665999999999999},{"$f":"SUMIF(C:C,L56,G:G)","v":333.13000199999999},{"$f":"SUMIF(C:C,L56,K:K)","v":433.32900000000001}]
["SUBTOTAL",{"$f":"SUM(B55:B56)","v":333.13000199999999},{"$f":"SUM(C55:C56)","v":433.32900000000001},{"$f":"C57-B57","v":100.19899800000002},{"$f":"IF(D57>0,D57/C57,\"-\")","v":0.23123076923076927},{"$f":"R32","v":433.32900000000001},{"$f":"F57-B57","v":100.19899800000002},{"$f":"IF(G57>0,G57/F57,\"-\")","v":0.23123076923076927},null,null,null,"Administración",{"$f":"SUMIF(C:C,L57,E:E)","v":0},0,{"$f":"SUMIF(C:C,L57,K:K)","v":0}]
["HONORARIOS",{"$f":"SUM(M35:M37)","v":0},{"$f":"SUM(O35:O37)","v":0},0,"-",null,null,null,null,null,null,"Diseño y Maquetación",{"$f":"SUMIF(C:C,L58,E:E)","v":0},0,0]
["BECAS",{"$f":"M38","v":0},{"$f":"O38","v":0},0,"-",null,null,null,null,null,null,"IT",{"$f":"SUMIF(C:C,L59,E:E)","v":0},0,0]
["SUBTOTAL",{"$f":"SUM(B58:B59)","v":0},{"$f":"SUM(C58:C59)","v":0},0,{"$f":"IF(D60>0,D60/C60,\"-\")","v":"-"},{"$f":"+R34","v":0},{"$f":"F60-B60","v":0},{"$f":"IF(G60>0,G60/F60,\"-\")","v":"-"},null,null,null,"Coordinación",0,{"$f":"SUMIF(C:C,L60,G:G)","v":0},0]
["TOTAL",{"$f":"B57+B60","v":333.13000199999999},{"$f":"C57+C60","v":433.32900000000001},100.19899800000002,{"$f":"IF(D61>0,D61/C61,\"-\")","v":0.23123076923076927},{"$f":"+F57+F60","v":433.32900000000001},{"$f":"+G60+G57","v":100.19899800000002},{"$f":"IF(G61>0,G61/F61,\"-\")","v":0.23123076923076927},null,null,null,"Dirección",{"$f":"SUMIF(C:C,L61,E:E)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,"KAM",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"Marketing",{"$f":"SUMIF(C:C,L63,E:E)","v":0},{"$f":"SUMIF(C:C,L63,G:G)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(M55:M63)","v":6.6665999999999999},{"$f":"SUM(N55:N63)","v":333.13000199999999},{"$f":"SUM(O55:O63)","v":433.32900000000001}]

{"sheet":"México","index":1,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
["Nº PRESUPUESTO:",null,"Nº BRIEFING",null,"CLIENTE:",null,{"$f":"TODAY()","v":"2019-06-28"},"Validez: 30 días"]
[]
["COSTES INTERNOS","INTERNO","VENTA",null,"Margen  3as","Mínimo 15%",null,"ESTUDIOS"]
["Jefatura de Línea",{"$f":"+Total!B5*20","v":1103.8},{"$f":"+Total!C5*20","v":1700},null,"General",0.25,null,"Descuento"]
["Jefatura de Proyectos",{"$f":"+Total!B6*20","v":999.4},{"$f":"+Total!C6*20","v":1300},null,"Impresión",0.23080000000000001,null,"Nº Investigadores"]
["Administración",{"$f":"+Total!B7*20","v":985.8},{"$f":"+Total!C7*20","v":1100},null,"Acreditación",0.92,null,"DURACIÓN"]
["Diseño y Maquetación",{"$f":"+Total!B8*20","v":1127.6000000000001},{"$f":"+Total!C8*20","v":1600},null,"tipo 4"]
["IT",{"$f":"+Total!B9*20","v":944.4},{"$f":"+Total!C9*20","v":1600},null,"tipo 5"]
["Coordinación",{"$f":"+Total!B10*20","v":1268.8},{"$f":"+Total!C10*20","v":1700},null,"tipo 6"]
["Dirección",{"$f":"+Total!B11*20","v":0},{"$f":"+Total!C11*20","v":3000},null,"tipo 7",null,null,"IVA",0.16]
["KAM",{"$f":"+Total!B12*20","v":0},{"$f":"+Total!C12*20","v":1600},null,"tipo 8"]
["Marketing",{"$f":"+Total!B13*20","v":0},{"$f":"+Total!C13*20","v":1500},null,"tipo 9"]
[]
["È","È",null,"È",null,null,null,null,null,null,null,null,null,null,null,"È","È","È"]
[null,null,null,null,null,"SERVICIOS INTERNOS SANED",null,null,null,null,null,"SERVICIOS DE TERCERAS PARTES"]
["DESCRIPCIÓN","UDS","PERFIL","HORAS","HORA/ HOMBRE","COSTE HORA/ HOMBRE","TOTAL COSTE","VALOR SANED","TOTAL VALOR SANED","PRECIO HORA/ HOMBRE"," GESTIÓN","COSTE UNITARIO","TOTAL COSTE","PRECIO UNITARIO","TOTAL ","PRECIO UNITARIO","TOTAL PROYECTO","PRECIO ESPECIAL CLIENTE","BENEFICIO","MARGEN","DTO APLICADO","% DTO APLICADO","BENEFICIO DESCUENTO","MARGEN DESCUENTO"]
["DIAGNÓSTICO  Y GESTIÓN INTEGRAL",null,null,null,null,null,{"$f":"SUM(G19:G21)","v":0},null,null,null,{"$f":"SUM(K19:K21)","v":0},null,{"$f":"SUM(M19:M21)","v":0},null,{"$f":"SUM(O19:O21)","v":0},null,{"$f":"O18+K18","v":0},{"$f":"SUM(R19:R21)","v":0},{"$f":"Q18-(M18+G18)","v":0},{"$f":"IF(S18>0,S18/Q18,\"-\")","v":"-"},{"$f":"+R18-Q18","v":0},{"$f":"IF(U18<0,1-(R18/Q18),\"-\")","v":"-"},{"$f":"R18-(M18+G18)","v":0},{"$f":"IF(R18>0,W18/R18,\"-\")","v":"-"}]
[null,null,null,null,null,{"$f":"SUMIF($A$5:$A$13,C19,$B$5:$B$13)","v":0},{"$f":"F19*E19","v":0},0,{"$f":"+H19*B19","v":0},{"$f":"SUMIF($A$5:$A$13,C19,$C$5:$C$13)","v":0},{"$f":"(E19*J19)+I19","v":0},null,{"$f":"L19*B19","v":0},{"$f":"L19/(1-$G$5)","v":0},{"$f":"N19*B19","v":0},{"$f":"+N19+J19+H19","v":0},0,{"$f":"+Q19","v":0},{"$f":"R19-(M19+G19)","v":0},"-",{"$f":"+R19-Q19","v":0},{"$f":"IF(U19<0,1-(R19/Q19),\"-\")","v":"-"},0,{"$f":"IF(W19>0,W19/R19,\"-\")","v":"-"}]
[null,null,null,null,null,{"$f":"SUMIF($A$5:$A$13,C20,$B$5:$B$13)","v":0},{"$f":"F20*E20","v":0},0,{"$f":"+H20*B20","v":0},{"$f":"SUMIF($A$5:$A$13,C20,$C$5:$C$13)","v":0},{"$f":"(E20*J20)+I20","v":0},null,{"$f":"L20*B20","v":0},{"$f":"L20/(1-$G$5)","v":0},{"$f":"N20*B20","v":0},{"$f":"+N20+J20+H20","v":0},0,{"$f":"Q20","v":0},{"$f":"R20-(M20+G20)","v":0},"-",{"$f":"+R20-Q20","v":0},{"$f":"IF(U20<0,1-(R20/Q20),\"-\")","v":"-"},0,"-"]
[null,null,null,null,null,{"$f":"SUMIF($A$5:$A$13,C21,$B$5:$B$13)","v":0},{"$f":"F21*E21","v":0},0,{"$f":"+H21*B21","v":0},{"$f":"SUMIF($A$5:$A$13,C21,$C$5:$C$13)","v":0},{"$f":"(E21*J21)+I21","v":0},null,{"$f":"L21*B21","v":0},{"$f":"L21/(1-$G$5)","v":0},{"$f":"N21*B21","v":0},{"$f":"+N21+J21+H21","v":0},0,{"$f":"+Q21","v":0},{"$f":"Q21-(M21+G21)","v":0},"-",0,"-",0,"-"]
["SERVICIOS",null,null,null,null,null,{"$f":"+G23+G26","v":0},null,null,null,{"$f":"+K23+K26","v":0},null,{"$f":"+M23+M26","v":0},null,{"$f":"+O23+O26","v":0},null,0,{"$f":"+R23+R26","v":0},0,"-",0,"-",0,"-"]
["Subservicios",null,null,null,null,null,{"$f":"+G24+G25","v":0},null,null,null,{"$f":"+K24+K25","v":0},null,{"$f":"+M24+M25","v":0},null,{"$f":"+O24+O25","v":0},null,0,{"$f":"+R24+R25","v":0},0,"-",0,"-",0,"-"]
[null,null,null,null,null,{"$f":"SUMIF($A$5:$A$13,C24,$B$5:$B$13)","v":0},{"$f":"F24*E24","v":0},0,{"$f":"+H24*B24","v":0},{"$f":"SUMIF($A$5:$A$13,C24,$C$5:$C$13)","v":0},{"$f":"(E24*J24)+I24","v":0},null,{"$f":"L24*B24","v":0},{"$f":"L24/(1-$G$5)","v":0},{"$f":"N24*B24","v":0},{"$f":"+N24+J24+H24","v":0},0,{"$f":"Q24","v":0},0,"-",0,"-",0,"-"]
[null,null,null,null,null,{"$f":"SUMIF($A$5:$A$13,C25,$B$5:$B$13)","v":0},{"$f":"F25*E25","v":0},0,{"$f":"+H25*B25","v":0},{"$f":"SUMIF($A$5:$A$13,C25,$C$5:$C$13)","v":0},{"$f":"(E25*J25)+I25","v":0},null,{"$f":"L25*B25","v":0},{"$f":"L25/(1-$G$5)","v":0},{"$f":"N25*B25","v":0},{"$f":"+N25+J25+H25","v":0},0,{"$f":"Q25","v":0},0,"-",0,"-",0,"-"]
[null,null,null,null,null,null,{"$f":"+G27","v":0},null,null,null,{"$f":"+K27","v":0},null,{"$f":"+M27","v":0},null,{"$f":"+O27","v":0},null,0,{"$f":"+R27","v":0},0,"-",0,"-",0,"-"]
[null,null,null,null,null,{"$f":"SUMIF($A$5:$A$13,C27,$B$5:$B$13)","v":0},{"$f":"F27*E27","v":0},0,{"$f":"+H27*B27","v":0},{"$f":"SUMIF($A$5:$A$13,C27,$C$5:$C$13)","v":0},{"$f":"(E27*J27)+I27","v":0},null,{"$f":"L27*B27","v":0},{"$f":"L27/(1-$G$5)","v":0},{"$f":"N27*B27","v":0},{"$f":"+N27+J27+H27","v":0},0,{"$f":"Q27","v":0},0,"-",0,"-",0,"-"]
["SERVICIOS 1",null,null,null,null,null,{"$f":"SUM(G29:G31)","v":0},null,null,null,{"$f":"SUM(K29:K31)","v":0},null,{"$f":"SUM(M29:M31)","v":0},null,{"$f":"SUM(O29:O31)","v":0},null,0,{"$f":"SUM(R29:R31)","v":0},0,"-",0,"-",0,"-"]
[null,null,null,null,null,{"$f":"SUMIF($A$5:$A$13,C29,$B$5:$B$13)","v":0},{"$f":"F29*E29","v":0},0,{"$f":"+H29*B294","v":0},{"$f":"SUMIF($A$5:$A$13,C29,$C$5:$C$13)","v":0},{"$f":"(E29*J29)+I29","v":0},null,{"$f":"L29*B29","v":0},{"$f":"L29/(1-$G$5)","v":0},{"$f":"N29*B29","v":0},{"$f":"+N29+J29+H29","v":0},0,0,0,"-",0,"-",0,"-"]
[null,null,null,null,null,{"$f":"SUMIF($A$5:$A$13,C30,$B$5:$B$13)","v":0},{"$f":"F30*E30","v":0},0,{"$f":"+H30*B30","v":0},{"$f":"SUMIF($A$5:$A$13,C30,$C$5:$C$13)","v":0},{"$f":"(E30*J30)+I30","v":0},null,{"$f":"L30*B30","v":0},{"$f":"L30/(1-$G$5)","v":0},{"$f":"N30*B30","v":0},{"$f":"+N30+J30+H30","v":0},0,0,0,"-",0,"-",0,"-"]
[null,null,null,null,null,{"$f":"SUMIF($A$5:$A$13,C31,$B$5:$B$13)","v":0},{"$f":"F31*E31","v":0},0,{"$f":"+H31*B31","v":0},{"$f":"SUMIF($A$5:$A$13,C31,$C$5:$C$13)","v":0},{"$f":"(E31*J31)+I31","v":0},null,{"$f":"L31*B31","v":0},{"$f":"L31/(1-$G$5)","v":0},{"$f":"N31*B31","v":0},{"$f":"+N31+J31+H31","v":0},0,0,0,"-",0,"-",0,"-"]
["TOTAL SERVICIOS",null,null,null,null,null,{"$f":"SUM(G18,G22,G28,G34)","v":0},null,null,null,{"$f":"+K28+K22+K18","v":0},null,{"$f":"SUM(M18,M22,M28)","v":0},null,{"$f":"+O28+O22+O18","v":0},null,{"$f":"+O32+K32","v":0},{"$f":"+R28+R22+R18","v":0},{"$f":"Q32-L47","v":0},{"$f":"IF(S32>0,S32/Q32,\"-\")","v":"-"},{"$f":"+R32-Q32","v":0},"-",{"$f":"R32-L47","v":0},{"$f":"IF(W32>0,W32/R32,\"-\")","v":"-"}]
[]
["HONORARIOS",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M35:M39)","v":0},null,{"$f":"SUM(O35:O38)","v":0},null,{"$f":"O34","v":0},{"$f":"SUM(R35:R38)","v":0},0,"-",0,"-",0,"-"]
["Autores",null,null,null,null,null,null,null,null,null,null,null,{"$f":"L35*B35","v":0},{"$f":"L35","v":0},{"$f":"M35","v":0},{"$f":"+N35","v":0},0,0,0,"-",0,"-",0,"-"]
["Coordinadores",null,null,null,null,null,null,null,null,null,null,null,{"$f":"L36*B36","v":0},{"$f":"L36","v":0},{"$f":"M36","v":0},{"$f":"+N36","v":0},{"$f":"+O36","v":0},{"$f":"Q36","v":0},0,"-",0,"-",0,{"$f":"IF(R36>0,W36/R36,\"-\")","v":"-"}]
["Aval Sociedad",null,null,null,null,null,null,null,null,null,null,null,{"$f":"L37*B37","v":0},{"$f":"L37","v":0},0,0,0,0,0,"-",0,"-",0,{"$f":"IF(R37>0,W37/R37,\"-\")","v":"-"}]
["Becas",null,null,null,null,null,null,null,null,null,null,null,{"$f":"L38*B38","v":0},{"$f":"L38","v":0},0,0,0,0,0,"-",0,"-",0,{"$f":"IF(R38>0,W38/R38,\"-\")","v":"-"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL BRUTO",{"$f":"+Q32+Q34","v":0},{"$f":"+R32+R34","v":0},{"$f":"Q40-(L46+L45)","v":0},{"$f":"IF(S40>0,S40/Q40,\"-\")","v":"-"},0,"-",{"$f":"R40-(L46+L45)","v":0},{"$f":"IF(W40>0,W40/R40,\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IVA",{"$f":"+Q40*I11","v":0},{"$f":"+R40*I11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Presupuesto",{"$f":"+Q40+Q41","v":0},{"$f":"+R40+R41","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"COSTE INTERNO",{"$f":"+G32","v":0}]
[null,null,null,null,null,null,null,null,null,null,"COSTE EXTERNO",{"$f":"+M34+M32","v":0}]
[null,null,null,null,null,null,null,null,null,null,"TOTAL COSTE (SIN HONORARIOS)",{"$f":"+G32+M32","v":0}]