{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Inicio","Presupuesto marketing de canal"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Inicio","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"INFORMACIÓN SOBRE ESTA PLANTILLA"]
[null,"Use esta plantilla para crear un presupuesto de marketing de canal."]
[null,"Especifique las ventas anticipadas de cada mes y otros detalles en las tablas."]
[null,"Los totales se calculan automáticamente y se actualizan los minigráficos."]
[null,"Nota: "]
[null,"Se proporcionan instrucciones adicionales en la columna A de la hoja de cálculo PRESUPUESTO DE MARKETING DE CANAL. Este texto se ocultó de forma intencionada. Para eliminar el texto, seleccione la columna A y, a continuación, ELIMINAR. Para mostrar el texto, seleccione la columna A y, a continuación, cambie el color de fuente."]
[null,"Para obtener más información sobre las tablas, presione las teclas MAYÚS y F10 dentro de una tabla, seleccione la opción TABLA y, después, TEXTO ALTERNATIVO."]

{"sheet":"Presupuesto marketing de canal","index":1,"n_rows":67,"n_cols":17,"rows_kept":67,"merged":[[0,1,0,19]]}
["Cree un presupuesto de marketing de canal en esta hoja de cálculo. El título de la hoja de cálculo está en la celda derecha. En las celdas de esta columna encontrará instrucciones útiles. Presione la flecha abajo para empezar. El título de la hoja de cálculo está en la celda derecha.","PRESUPUESTO DE MARKETING DE CANAL"]
["Las etiquetas Tasa y Meses están en esta fila, de las celdas C2 a O2, y la etiqueta Total está en la celda Q2."," ","Tasa","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12",null,"Total"]
["La etiqueta Total de ventas anticipadas está en la celda derecha. Escriba las ventas anticipadas de cada mes en las celdas D3 a O3. El total se calcula automáticamente en la celda Q3.","TOTAL DE VENTAS ANTICIPADAS (000) €"," ",750,200,500,{"v":1500,"d":"1,500"},{"v":1200,"d":"1,200"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1800,"d":"1,800"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},null,{"$f":"SUM(D3:O3)","v":{"v":16950,"d":"16,950"}}]
["Escriba los detalles en la tabla Personal. Para ello, empiece por la celda derecha. El total de personal de cada mes se calcula automáticamente al final de la tabla, y el total anual en la celda Q9. El minigráfico se actualiza en la celda S9. La instrucción siguiente está en la celda A10.","Elementos de personal","Tasa","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12"]
[null,"PERSONAL (% DEL TOTAL DE VENTAS)",null,{"$f":"D11+D33+D41+D48","v":{"v":1.1,"d":"110%"}},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":0.8500000000000001,"d":"85%"},{"v":0.8500000000000001,"d":"85%"},{"v":0.8500000000000001,"d":"85%"},{"v":0.8500000000000001,"d":"85%"}]
[null,"Recursos humanos: plantilla",5,{"$f":"+$C$6","v":5},5,5,5,5,5,5,5,5,5,5,5]
[null,"Recursos humanos: costo",null,{"$f":"$C$6*D6","v":{"v":25,"d":"25.00"}},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},null,{"$f":"SUM('Presupuesto marketing de canal'!$D7:$O7)","v":{"v":300,"d":"300.00"}}]
[null,"Comisión",{"v":1E-3,"d":"0.10%"},{"$f":"D3*$C$8","v":0.75},{"v":0.2,"d":"0.20"},{"v":0.5,"d":"0.50"},{"v":1.5,"d":"1.50"},{"v":1.2,"d":"1.20"},{"v":1.5,"d":"1.50"},{"v":1.5,"d":"1.50"},{"v":1.8,"d":"1.80"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},null,{"$f":"SUM('Presupuesto marketing de canal'!$D8:$O8)","v":{"v":16.950000000000003,"d":"16.95"}}]
[null,"Total de personal (000) €",null,{"$f":"SUM(D7:D8)","v":25.75},{"$f":"SUM(E7:E8)","v":{"v":25.2,"d":"25.20"}},{"v":25.5,"d":"25.50"},{"v":26.5,"d":"26.50"},{"v":26.2,"d":"26.20"},{"v":26.5,"d":"26.50"},{"v":26.5,"d":"26.50"},{"v":26.8,"d":"26.80"},{"v":27,"d":"27.00"},{"v":27,"d":"27.00"},{"v":27,"d":"27.00"},{"v":27,"d":"27.00"},null,{"$f":"SUM(Q7:Q8)","v":316.95}]
["Escriba los detalles en la tabla Marketing directo. Para ello, empiece por la celda derecha. El total de telemarketing de cada mes se calcula automáticamente al final de la tabla, y el total anual en la celda Q17. El minigráfico se actualiza en la celda S17. La instrucción siguiente está en la celda A18.","Elementos de marketing directo","Tasa","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12"]
[null,"MARKETING DIRECTO (% DEL TOTAL DE VENTAS)",null,{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":0.75,"d":"75%"},{"v":0.4,"d":"40%"},{"v":0.33,"d":"33%"},{"v":0.25,"d":"25%"},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"}]
[null,"Telemarketing (% de ventas directas)",null,{"v":1,"d":"100%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"}]
[null,"Recursos humanos: plantilla",3,{"$f":"$C$13*D12","v":3},1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,null,{"$f":"SUM('Presupuesto marketing de canal'!$D13:$O13)","v":{"v":19.5,"d":"19.50"}}]
[null,"Soporte de la infraestructura",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Presupuesto marketing de canal'!$D14:$O14)","v":{"v":210,"d":"210.00"}}]
[null,"Comisión",{"v":1E-3,"d":"0.10%"},{"$f":"$C$15*D3*D11*D12","v":0.75},{"v":0.1,"d":"0.10"},{"v":0.1875,"d":"0.19"},{"v":0.30000000000000004,"d":"0.30"},{"v":0.198,"d":"0.20"},{"v":0.1875,"d":"0.19"},{"v":0.15000000000000002,"d":"0.15"},{"v":0.09000000000000001,"d":"0.09"},0.05,0.05,0.05,0.05,null,{"$f":"SUM('Presupuesto marketing de canal'!$D15:$O15)","v":{"v":2.163,"d":"2.16"}}]
[null,"Aprendizaje",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Presupuesto marketing de canal'!$D16:$O16)","v":{"v":210,"d":"210.00"}}]
[null,"Total de telemarketing (000) €",null,{"$f":"SUM(D13:D16)","v":53.75},{"$f":"SUM(E13:E16)","v":{"v":21.6,"d":"21.60"}},{"$f":"SUM(F13:F16)","v":{"v":51.6875,"d":"51.69"}},{"v":21.8,"d":"21.80"},{"v":51.698,"d":"51.70"},{"v":21.6875,"d":"21.69"},51.65,21.59,51.55,21.55,51.55,21.55,null,{"$f":"SUM(Q13:Q16)","v":{"v":441.663,"d":"441.66"}}]
["Escriba los detalles en la tabla Marketing en Internet. Para ello, empiece por la celda derecha. El total de marketing en Internet de cada mes se calcula automáticamente al final de la tabla, y el total anual en la celda Q24. El minigráfico se actualiza en la celda S24. La instrucción siguiente está en la celda A25.","Elementos de marketing en Internet","Tasa","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12"]
[null,"Marketing en Internet (% de ventas directas)",null,{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"}]
[null,"Recursos humanos: plantilla",1,{"$f":"$C$20*D19","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,null,{"$f":"SUM('Presupuesto marketing de canal'!$D20:$O20)","v":{"v":3,"d":"3.00"}}]
[null,"Desarrollo de sitio web (costo único)",null,500,{"$nulls":12},{"$f":"SUM('Presupuesto marketing de canal'!$D21:$O21)","v":{"v":500,"d":"500.00"}}]
[null,"Hospedaje",null,10,10,10,10,10,10,10,10,10,10,10,10,null,{"$f":"SUM('Presupuesto marketing de canal'!$D22:$O22)","v":{"v":120,"d":"120.00"}}]
[null,"Soporte técnico y mantenimiento",null,25,{"$nulls":9},25,null,null,{"$f":"SUM('Presupuesto marketing de canal'!$D23:$O23)","v":{"v":50,"d":"50.00"}}]
[null,"Total de marketing en Internet (000) €",null,{"$f":"SUM(D20:D23)","v":535.25},{"$f":"SUM(E20:E23)","v":10.25},10.25,10.25,10.25,10.25,10.25,10.25,10.25,10.25,35.25,10.25,null,{"$f":"SUM(Q20:Q23)","v":{"v":673,"d":"673.00"}}]
["Escriba los detalles en la tabla Correo directo. Para ello, empiece por la celda derecha. El total de correo directo de cada mes se calcula automáticamente al final de la tabla, y el total anual en la celda Q30. La instrucción siguiente está en la celda A31."," Elementos de correo directo","Tasa","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12"]
[null,"Correo directo (% de ventas directas)"]
[null,"Recursos humanos: costo",{"$nulls":14},{"$f":"SUM('Presupuesto marketing de canal'!$D27:$O27)","v":{"v":0,"d":"0.00"}}]
[null,"Material",null,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,null,{"$f":"SUM('Presupuesto marketing de canal'!$D28:$O28)","v":{"v":12000,"d":"12,000.00"}}]
[null,"Gastos de envío",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM('Presupuesto marketing de canal'!$D29:$O29)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Total de correo directo (000) €",null,{"$f":"SUM(D27:D29)","v":{"v":1250,"d":"1,250.00"}},{"$f":"SUM(E27:E29)","v":{"v":1250,"d":"1,250.00"}},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},null,{"$f":"SUM(Q27:Q29)","v":{"v":15000,"d":"15,000.00"}}]
["El total de marketing directo se calcula automáticamente en esta fila (celdas D31 a O31), y el total anual en la celda Q31. El minigráfico se actualiza en la celda S31.","Total de marketing directo (000) €",null,{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 1]],MarketingDeInternet[[#Totals],[Mes 1]],MarketingDirecto[[#Totals],[Mes 1]])","v":{"v":1839,"d":"1,839.00"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 2]],MarketingDeInternet[[#Totals],[Mes 2]],MarketingDirecto[[#Totals],[Mes 2]])","v":{"v":1281.85,"d":"1,281.85"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 3]],MarketingDeInternet[[#Totals],[Mes 3]],MarketingDirecto[[#Totals],[Mes 3]])","v":{"v":1311.9375,"d":"1,311.94"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 4]],MarketingDeInternet[[#Totals],[Mes 4]],MarketingDirecto[[#Totals],[Mes 4]])","v":{"v":1282.05,"d":"1,282.05"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 5]],MarketingDeInternet[[#Totals],[Mes 5]],MarketingDirecto[[#Totals],[Mes 5]])","v":{"v":1311.948,"d":"1,311.95"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 6]],MarketingDeInternet[[#Totals],[Mes 6]],MarketingDirecto[[#Totals],[Mes 6]])","v":{"v":1281.9375,"d":"1,281.94"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 7]],MarketingDeInternet[[#Totals],[Mes 7]],MarketingDirecto[[#Totals],[Mes 7]])","v":{"v":1311.9,"d":"1,311.90"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 8]],MarketingDeInternet[[#Totals],[Mes 8]],MarketingDirecto[[#Totals],[Mes 8]])","v":{"v":1281.84,"d":"1,281.84"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 9]],MarketingDeInternet[[#Totals],[Mes 9]],MarketingDirecto[[#Totals],[Mes 9]])","v":{"v":1311.8,"d":"1,311.80"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 10]],MarketingDeInternet[[#Totals],[Mes 10]],MarketingDirecto[[#Totals],[Mes 10]])","v":{"v":1281.8,"d":"1,281.80"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 11]],MarketingDeInternet[[#Totals],[Mes 11]],MarketingDirecto[[#Totals],[Mes 11]])","v":{"v":1336.8,"d":"1,336.80"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 12]],MarketingDeInternet[[#Totals],[Mes 12]],MarketingDirecto[[#Totals],[Mes 12]])","v":{"v":1281.8,"d":"1,281.80"}},null,{"$f":"SUM(Q30,Q24,Q17,Q9)","v":{"v":16431.613,"d":"16,431.61"}}]
["Escriba los detalles en la tabla Agente y corredor. Para ello, empiece por la celda derecha. El total de agente y corredor de cada mes se calcula automáticamente al final de la tabla, y el total anual en la celda Q39. El minigráfico se actualiza en la celda S39. La instrucción siguiente está en la celda A40.","Elementos de agente/corredor","Tasa","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12"]
[null,"AGENTE/CORREDOR (% DEL TOTAL DE VENTAS)",null,{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"}]
[null,"Comunicación",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Presupuesto marketing de canal'!$D34:$O34)","v":{"v":600,"d":"600.00"}}]
[null,"Aprendizaje",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM('Presupuesto marketing de canal'!$D35:$O35)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promociones",null,{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},null,{"$f":"SUM('Presupuesto marketing de canal'!$D36:$O36)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Descuentos",{"v":0.1,"d":"10.00%"},{"$f":"D3*D33*$C$37","v":{"v":7.5,"d":"7.50"}},{"v":2,"d":"2.00"},{"v":5,"d":"5.00"},{"v":15,"d":"15.00"},{"v":12,"d":"12.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":18,"d":"18.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},null,{"$f":"SUM('Presupuesto marketing de canal'!$D37:$O37)","v":{"v":169.5,"d":"169.50"}}]
[null,"Comisión (% de ventas de agentes)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D33*$C$38","v":{"v":7.5,"d":"7.50"}},{"v":2,"d":"2.00"},{"v":5,"d":"5.00"},{"v":15,"d":"15.00"},{"v":12,"d":"12.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":18,"d":"18.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},null,{"$f":"SUM('Presupuesto marketing de canal'!$D38:$O38)","v":{"v":169.5,"d":"169.50"}}]
[null,"Total de agente/corredor (000) €",null,{"$f":"SUM(D34:D38)","v":{"v":915,"d":"915.00"}},{"$f":"SUM(E34:E38)","v":{"v":904,"d":"904.00"}},{"v":910,"d":"910.00"},{"v":930,"d":"930.00"},{"v":924,"d":"924.00"},{"v":930,"d":"930.00"},{"v":930,"d":"930.00"},{"v":936,"d":"936.00"},{"v":940,"d":"940.00"},{"v":940,"d":"940.00"},{"v":940,"d":"940.00"},{"v":940,"d":"940.00"},null,{"$f":"SUM(Q34:Q38)","v":{"v":11139,"d":"11,139.00"}}]
["Escriba los detalles en la tabla Distribuidores. Para ello, empiece por la celda derecha. El total de distribuidor de cada mes se calcula automáticamente al final de la tabla, y el total anual en la celda Q46. El minigráfico se actualiza en la celda S46. La instrucción siguiente está en la celda A47.","Elementos de distribuidor","Tasa","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12"]
[null,"DISTRIBUIDORES (% DEL TOTAL DE VENTAS)",null,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.15,"d":"15%"},{"v":0.2,"d":"20%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"}]
[null,"Comunicación",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Presupuesto marketing de canal'!$D42:$O42)","v":{"v":600,"d":"600.00"}}]
[null,"Aprendizaje",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM(Distribuidores[[#This Row],[Mes 1]:[Mes 12]])","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promociones",null,{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},null,{"$f":"SUM(Distribuidores[[#This Row],[Mes 1]:[Mes 12]])","v":{"v":7200,"d":"7,200.00"}}]
[null,"Comisiones/descuentos (% de ventas de distribuidores)",{"v":0.15,"d":"15.00%"},{"$f":"D3*D41*$C$45","v":0},0,0,0,0,33.75,45,108,120,120,120,120,null,{"$f":"SUM(Distribuidores[[#This Row],[Mes 1]:[Mes 12]])","v":666.75}]
[null,"Total de distribuidor (000) €",null,{"$f":"SUM(D42:D45)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E42:E45)","v":{"v":900,"d":"900.00"}},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},933.75,{"v":945,"d":"945.00"},{"v":1008,"d":"1,008.00"},{"v":1020,"d":"1,020.00"},{"v":1020,"d":"1,020.00"},{"v":1020,"d":"1,020.00"},{"v":1020,"d":"1,020.00"},null,{"$f":"SUM(Q42:Q45)","v":{"v":11466.75,"d":"11,466.75"}}]
["Escriba los detalles en la tabla Minorista. Para ello, empiece por la celda derecha. El total de minorista de cada mes se calcula automáticamente al final de la tabla y el total anual en la celda Q53. El minigráfico se actualiza en la celda S53. La instrucción siguiente está en la celda A54.","Artículos de minorista","Tasa","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12"]
[null,"MINORISTA (% DEL TOTAL DE VENTAS)",null,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.25,"d":"25%"},{"v":0.6,"d":"60%"},{"v":0.67,"d":"67%"},{"v":0.6,"d":"60%"},{"v":0.6,"d":"60%"},{"v":0.5,"d":"50%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"}]
[null,"Comunicación",null,50,50,50,50,50,50,50,50,50,50,50,50]
[null,"Aprendizaje",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM('Presupuesto marketing de canal'!$D49:$O49)","v":{"v":600,"d":"600.00"}}]
[null,"Promociones",null,{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},null,{"$f":"SUM('Presupuesto marketing de canal'!$D50:$O50)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Comisiones/descuentos (% de ventas minoristas)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D48*$C$52","v":0},0,12.5,90,80.4,90,90,90,60,60,60,60,null,{"$f":"SUM('Presupuesto marketing de canal'!$D52:$O52)","v":{"v":692.9,"d":"692.90"}}]
[null,"Total de minorista (000) €",null,{"$f":"SUM(D49:D52)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E49:E52)","v":{"v":900,"d":"900.00"}},{"v":912.5,"d":"912.50"},{"v":990,"d":"990.00"},{"v":980.4,"d":"980.40"},{"v":990,"d":"990.00"},{"v":990,"d":"990.00"},{"v":990,"d":"990.00"},{"v":960,"d":"960.00"},{"v":960,"d":"960.00"},{"v":960,"d":"960.00"},{"v":960,"d":"960.00"},null,{"$f":"SUM(Q50:Q52)","v":{"v":4292.9,"d":"4,292.90"}}]
["Escriba los detalles en la tabla Adquisición y retención de clientes. Para ello, empiece por la celda derecha. El total de adquisición y retención de clientes de cada mes se calcula automáticamente al final de la tabla, y el total anual en la celda Q59. El minigráfico se actualiza en la celda S59. La instrucción siguiente está en la celda A60.","Elementos de adquisición y retención de clientes","Tasa","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12"]
[null,"ADQUISICIÓN Y RETENCIÓN DE CLIENTES"]
[null,"Recursos humanos",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Presupuesto marketing de canal'!$D56:$O56)","v":{"v":600,"d":"600.00"}}]
[null,"Comunicaciones",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM('Presupuesto marketing de canal'!$D57:$O57)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promociones/cupones",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Presupuesto marketing de canal'!$D58:$O58)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Total de adquisición y retención de clientes (000) €",null,{"$f":"SUM(D56:D58)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E56:E58)","v":{"v":900,"d":"900.00"}},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},null,{"$f":"SUM(Q56:Q58)","v":{"v":10800,"d":"10,800.00"}}]
["Escriba los detalles en la tabla Otros gastos. Para ello, empiece por la celda derecha. El total de otros gastos de cada mes se calcula automáticamente al final de la tabla, y el total anual en la celda Q65. El minigráfico se actualiza en la celda S65. La instrucción siguiente está en la celda A67.","Elementos de otros gastos ","Tasa","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12"]
[null,"OTROS GASTOS"]
[null,"Viajes",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Presupuesto marketing de canal'!$D62:$O62)","v":{"v":600,"d":"600.00"}}]
[null,"Infraestructura (equipo, teléfono, etc.)",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM('Presupuesto marketing de canal'!$D63:$O63)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Soporte de canal",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Presupuesto marketing de canal'!$D64:$O64)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Total de otros gastos (000) €",null,{"$f":"SUM(D62:D64)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E62:E64)","v":{"v":900,"d":"900.00"}},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},null,{"$f":"SUM(Q62:Q64)","v":{"v":10800,"d":"10,800.00"}}]
[]
["El total del presupuesto de marketing de cada mes se calcula automáticamente en esta fila (celdas D67 a O67), y el total anual en la celda Q67. El minigráfico se actualiza automáticamente en la celda S67.","TOTAL DE PRESUPUESTO DE MARKETING:",null,{"$f":"SUM(OtrosGastos[[#Totals],[Mes 1]],Adquisición_y_retención_de_clientes[[#Totals],[Mes 1]],Minorista[[#Totals],[Mes 1]],Distribuidores[[#Totals],[Mes 1]],AgenteYCorredor[[#Totals],[Mes 1]],D31)","v":{"v":6354,"d":"6,354.00"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 2]],Adquisición_y_retención_de_clientes[[#Totals],[Mes 2]],Minorista[[#Totals],[Mes 2]],Distribuidores[[#Totals],[Mes 2]],AgenteYCorredor[[#Totals],[Mes 2]],E31)","v":{"v":5785.85,"d":"5,785.85"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 3]],Adquisición_y_retención_de_clientes[[#Totals],[Mes 3]],Minorista[[#Totals],[Mes 3]],Distribuidores[[#Totals],[Mes 3]],AgenteYCorredor[[#Totals],[Mes 3]],F31)","v":{"v":5834.4375,"d":"5,834.44"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 4]],Adquisición_y_retención_de_clientes[[#Totals],[Mes 4]],Minorista[[#Totals],[Mes 4]],Distribuidores[[#Totals],[Mes 4]],AgenteYCorredor[[#Totals],[Mes 4]],G31)","v":{"v":5902.05,"d":"5,902.05"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 5]],Adquisición_y_retención_de_clientes[[#Totals],[Mes 5]],Minorista[[#Totals],[Mes 5]],Distribuidores[[#Totals],[Mes 5]],AgenteYCorredor[[#Totals],[Mes 5]],H31)","v":{"v":5916.348,"d":"5,916.35"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 6]],Adquisición_y_retención_de_clientes[[#Totals],[Mes 6]],Minorista[[#Totals],[Mes 6]],Distribuidores[[#Totals],[Mes 6]],AgenteYCorredor[[#Totals],[Mes 6]],I31)","v":{"v":5935.6875,"d":"5,935.69"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 7]],Adquisición_y_retención_de_clientes[[#Totals],[Mes 7]],Minorista[[#Totals],[Mes 7]],Distribuidores[[#Totals],[Mes 7]],AgenteYCorredor[[#Totals],[Mes 7]],J31)","v":{"v":5976.9,"d":"5,976.90"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 8]],Adquisición_y_retención_de_clientes[[#Totals],[Mes 8]],Minorista[[#Totals],[Mes 8]],Distribuidores[[#Totals],[Mes 8]],AgenteYCorredor[[#Totals],[Mes 8]],K31)","v":{"v":6015.84,"d":"6,015.84"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 9]],Adquisición_y_retención_de_clientes[[#Totals],[Mes 9]],Minorista[[#Totals],[Mes 9]],Distribuidores[[#Totals],[Mes 9]],AgenteYCorredor[[#Totals],[Mes 9]],L31)","v":{"v":6031.8,"d":"6,031.80"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 10]],Adquisición_y_retención_de_clientes[[#Totals],[Mes 10]],Minorista[[#Totals],[Mes 10]],Distribuidores[[#Totals],[Mes 10]],AgenteYCorredor[[#Totals],[Mes 10]],M31)","v":{"v":6001.8,"d":"6,001.80"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 11]],Adquisición_y_retención_de_clientes[[#Totals],[Mes 11]],Minorista[[#Totals],[Mes 11]],Distribuidores[[#Totals],[Mes 11]],AgenteYCorredor[[#Totals],[Mes 11]],N31)","v":{"v":6056.8,"d":"6,056.80"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 12]],Adquisición_y_retención_de_clientes[[#Totals],[Mes 12]],Minorista[[#Totals],[Mes 12]],Distribuidores[[#Totals],[Mes 12]],AgenteYCorredor[[#Totals],[Mes 12]],O31)","v":{"v":6001.8,"d":"6,001.80"}},null,{"$f":"SUM(D67:O67)","v":{"v":71813.31300000001,"d":"71,813.31"}}]