{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Inicio","Presupuesto marketing de canal"],"not_rendered":{"images":1,"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 marketing de canal."]
[null,"Escriba 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 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":70,"n_cols":17,"rows_kept":70,"merged":[[0,1,0,19],[1,16,1,19],[2,16,2,19],[4,16,4,19],[5,16,5,19],[30,16,30,19],[31,16,31,19],[32,16,32,19],[33,16,33,17],[34,16,34,19],[35,16,35,19],[36,16,36,19],[37,16,37,19],[38,16,38,19],[39,16,39,19],[40,16,40,19],[41,16,41,17],[48,16,48,17],[61,16,61,17],[67,16,67,17]]}
["Cree un presupuesto 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."]
["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+D36+D44+D51","v":{"v":1.1,"d":"110%"}},{"v":1.1,"d":"110%"},{"$f":"F11+F36+F44+F51","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":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 online a partir de la celda a la derecha. El total de marketing online de cada mes se calcula automáticamente al final de la tabla, y el total anual en la celda Q27. El minigráfico se actualiza en la celda S27. La instrucción siguiente se encuentra en la celda A28.","ELEMENTOS DE MARKETING ONLINE","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 ONLINE (% 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,"Facebook",null,null,100,null,100,null,100,null,100,null,100,null,100,null,{"$f":"SUM('Presupuesto marketing de canal'!$D24:$O24)","v":{"v":600,"d":"600.00"}}]
[null,"Twitter",null,100,null,100,null,100,null,100,null,100,null,100,null,null,{"$f":"SUM('Presupuesto marketing de canal'!$D25:$O25)","v":{"v":600,"d":"600.00"}}]
[null,"YouTube",null,null,100,null,100,100,{"$nulls":3},100,100,null,100,null,{"$f":"SUM('Presupuesto marketing de canal'!$D26:$O26)","v":{"v":600,"d":"600.00"}}]
[null,"Total de marketing online (000) €",null,{"$f":"SUM(D20:D26)","v":635.25},{"$f":"SUM(E20:E26)","v":210.25},110.25,210.25,210.25,110.25,110.25,110.25,210.25,210.25,135.25,{"$f":"SUM(O20:O26)","v":210.25},null,{"$f":"SUM(Q20:Q26)","v":{"v":2473,"d":"2,473.00"}}]
["Escriba los detalles en la tabla Correo Directo a partir de la celda a la 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 Q34. La instrucción siguiente se encuentra en la celda A35.","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'!$D30:$O30)","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'!$D31:$O31)","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'!$D32:$O32)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Total de correo directo (000) €",null,{"$f":"SUM(D30:D32)","v":{"v":1250,"d":"1,250.00"}},{"$f":"SUM(E30:E32)","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(Q30:Q32)","v":{"v":15000,"d":"15,000.00"}}]
["El total de marketing directo se calcula automáticamente en esta fila (de celda 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]],MarketingOnline[[#Totals],[Mes 1]],MarketingDirecto[[#Totals],[Mes 1]])","v":{"v":1939,"d":"1,939.00"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 2]],MarketingOnline[[#Totals],[Mes 2]],MarketingDirecto[[#Totals],[Mes 2]])","v":{"v":1481.85,"d":"1,481.85"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 3]],MarketingOnline[[#Totals],[Mes 3]],MarketingDirecto[[#Totals],[Mes 3]])","v":{"v":1411.9375,"d":"1,411.94"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 4]],MarketingOnline[[#Totals],[Mes 4]],MarketingDirecto[[#Totals],[Mes 4]])","v":{"v":1482.05,"d":"1,482.05"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 5]],MarketingOnline[[#Totals],[Mes 5]],MarketingDirecto[[#Totals],[Mes 5]])","v":{"v":1511.948,"d":"1,511.95"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 6]],MarketingOnline[[#Totals],[Mes 6]],MarketingDirecto[[#Totals],[Mes 6]])","v":{"v":1381.9375,"d":"1,381.94"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 7]],MarketingOnline[[#Totals],[Mes 7]],MarketingDirecto[[#Totals],[Mes 7]])","v":{"v":1411.9,"d":"1,411.90"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 8]],MarketingOnline[[#Totals],[Mes 8]],MarketingDirecto[[#Totals],[Mes 8]])","v":{"v":1381.84,"d":"1,381.84"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 9]],MarketingOnline[[#Totals],[Mes 9]],MarketingDirecto[[#Totals],[Mes 9]])","v":{"v":1511.8,"d":"1,511.80"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 10]],MarketingOnline[[#Totals],[Mes 10]],MarketingDirecto[[#Totals],[Mes 10]])","v":{"v":1481.8,"d":"1,481.80"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 11]],MarketingOnline[[#Totals],[Mes 11]],MarketingDirecto[[#Totals],[Mes 11]])","v":{"v":1436.8,"d":"1,436.80"}},{"$f":"SUM(CorreoDirecto[[#Totals],[Mes 12]],MarketingOnline[[#Totals],[Mes 12]],MarketingDirecto[[#Totals],[Mes 12]])","v":{"v":1481.8,"d":"1,481.80"}},null,{"$f":"SUM(Q33,Q27,Q17,Q9)","v":{"v":18231.613,"d":"18,231.61"}}]
["Escriba los detalles en la tabla Agente y Corredor a partir de la celda a la derecha. El total de agentes y corredores de cada mes se calcula automáticamente al final de la tabla, y el total anual en la celda Q42. El minigráfico se actualiza en la celda S42. La instrucción siguiente se encuentra en la celda A43.","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'!$D37:$O37)","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'!$D38:$O38)","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'!$D39:$O39)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Descuentos",{"v":0.1,"d":"10.00%"},{"$f":"D3*D36*$C$40","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'!$D40:$O40)","v":{"v":169.5,"d":"169.50"}}]
[null,"Comisión (% de ventas de agentes)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D36*$C$41","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'!$D41:$O41)","v":{"v":169.5,"d":"169.50"}}]
[null,"Total de agente/corredor (000) €",null,{"$f":"SUM(D37:D41)","v":{"v":915,"d":"915.00"}},{"$f":"SUM(E37:E41)","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(Q37:Q41)","v":{"v":11139,"d":"11,139.00"}}]
["Escriba los detalles en la tabla Distribuidores a partir de la celda a la derecha. El total de distribuidores de cada mes se calcula automáticamente al final de la tabla, y el total anual en la celda Q49. El minigráfico se actualiza en la celda S49. La instrucción siguiente se encuentra en la celda A50.","ELEMENTOS DE DISTRIBUIDORES","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'!$D45:$O45)","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*D44*$C$48","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(D45:D48)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E45:E48)","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(Q45:Q48)","v":{"v":11466.75,"d":"11,466.75"}}]
["Escriba los detalles en la tabla Minorista a partir de la celda a la derecha. El total de minoristas de cada mes se calcula automáticamente al final de la tabla, y el total anual en la celda Q56. El minigráfico se actualiza en la celda S56. La instrucción siguiente se encuentra en la celda A57.","ELEMENTOS MINORISTAS","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'!$D52:$O52)","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'!$D53:$O53)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Comisiones/descuentos (% de ventas minoristas)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D51*$C$55","v":0},0,12.5,90,80.4,90,90,90,60,60,60,60,null,{"$f":"SUM('Presupuesto marketing de canal'!$D55:$O55)","v":{"v":692.9,"d":"692.90"}}]
[null,"Total de minorista (000) €",null,{"$f":"SUM(D52:D55)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E52:E55)","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(Q53:Q55)","v":{"v":4292.9,"d":"4,292.90"}}]
["Escriba los detalles en la tabla Adquisición y Retención de Clientes a partir de la celda a la 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 Q62. El minigráfico se actualiza en la celda S62. La instrucción siguiente se encuentra en la celda A63.","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'!$D59:$O59)","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'!$D60:$O60)","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'!$D61:$O61)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Total de adquisición y retención de clientes (000) €",null,{"$f":"SUM(D59:D61)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E59:E61)","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(Q59:Q61)","v":{"v":10800,"d":"10,800.00"}}]
["Escriba los detalles en la tabla Otros Gastos, a partir de la celda a la 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 Q68. El minigráfico se actualiza en la celda S68. La instrucción siguiente se encuentra en la celda A70.","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'!$D65:$O65)","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'!$D66:$O66)","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'!$D67:$O67)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Total de otros gastos (000) €",null,{"$f":"SUM(D65:D67)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E65:E67)","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(Q65:Q67)","v":{"v":10800,"d":"10,800.00"}}]
[]
["El total de presupuesto de marketing cada mes se calcula automáticamente en esta fila (de celda D70 a O70), y el total anual en la celda Q70. El minigráfico se actualiza automáticamente en la celda S70.","TOTAL DE PRESUPUESTO DE MARKETING:",null,{"$f":"SUM(D34,AgenteYCorredor[[#Totals],[Mes 1]],Distribuidores[[#Totals],[Mes 1]],Minorista[[#Totals],[Mes 1]],AdquisiciónRetenciónClientes[[#Totals],[Mes 1]],OtrosGastos[[#Totals],[Mes 1]])","v":{"v":6454,"d":"6,454.00"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 2]],AdquisiciónRetenciónClientes[[#Totals],[Mes 2]],Minorista[[#Totals],[Mes 2]],Distribuidores[[#Totals],[Mes 2]],AgenteYCorredor[[#Totals],[Mes 2]],E34)","v":{"v":5985.85,"d":"5,985.85"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 3]],AdquisiciónRetenciónClientes[[#Totals],[Mes 3]],Minorista[[#Totals],[Mes 3]],Distribuidores[[#Totals],[Mes 3]],AgenteYCorredor[[#Totals],[Mes 3]],F34)","v":{"v":5934.4375,"d":"5,934.44"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 4]],AdquisiciónRetenciónClientes[[#Totals],[Mes 4]],Minorista[[#Totals],[Mes 4]],Distribuidores[[#Totals],[Mes 4]],AgenteYCorredor[[#Totals],[Mes 4]],G34)","v":{"v":6102.05,"d":"6,102.05"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 5]],AdquisiciónRetenciónClientes[[#Totals],[Mes 5]],Minorista[[#Totals],[Mes 5]],Distribuidores[[#Totals],[Mes 5]],AgenteYCorredor[[#Totals],[Mes 5]],H34)","v":{"v":6116.348,"d":"6,116.35"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 6]],AdquisiciónRetenciónClientes[[#Totals],[Mes 6]],Minorista[[#Totals],[Mes 6]],Distribuidores[[#Totals],[Mes 6]],AgenteYCorredor[[#Totals],[Mes 6]],I34)","v":{"v":6035.6875,"d":"6,035.69"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 7]],AdquisiciónRetenciónClientes[[#Totals],[Mes 7]],Minorista[[#Totals],[Mes 7]],Distribuidores[[#Totals],[Mes 7]],AgenteYCorredor[[#Totals],[Mes 7]],J34)","v":{"v":6076.9,"d":"6,076.90"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 8]],AdquisiciónRetenciónClientes[[#Totals],[Mes 8]],Minorista[[#Totals],[Mes 8]],Distribuidores[[#Totals],[Mes 8]],AgenteYCorredor[[#Totals],[Mes 8]],K34)","v":{"v":6115.84,"d":"6,115.84"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 9]],AdquisiciónRetenciónClientes[[#Totals],[Mes 9]],Minorista[[#Totals],[Mes 9]],Distribuidores[[#Totals],[Mes 9]],AgenteYCorredor[[#Totals],[Mes 9]],L34)","v":{"v":6231.8,"d":"6,231.80"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 10]],AdquisiciónRetenciónClientes[[#Totals],[Mes 10]],Minorista[[#Totals],[Mes 10]],Distribuidores[[#Totals],[Mes 10]],AgenteYCorredor[[#Totals],[Mes 10]],M34)","v":{"v":6201.8,"d":"6,201.80"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 11]],AdquisiciónRetenciónClientes[[#Totals],[Mes 11]],Minorista[[#Totals],[Mes 11]],Distribuidores[[#Totals],[Mes 11]],AgenteYCorredor[[#Totals],[Mes 11]],N34)","v":{"v":6156.8,"d":"6,156.80"}},{"$f":"SUM(OtrosGastos[[#Totals],[Mes 12]],AdquisiciónRetenciónClientes[[#Totals],[Mes 12]],Minorista[[#Totals],[Mes 12]],Distribuidores[[#Totals],[Mes 12]],AgenteYCorredor[[#Totals],[Mes 12]],O34)","v":{"v":6201.8,"d":"6,201.80"}},null,{"$f":"SUM(D70:O70)","v":{"v":73613.31300000001,"d":"73,613.31"}}]