{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Plantilla"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Plantilla","index":0,"n_rows":47,"n_cols":8,"rows_kept":47}
[]
[null,"Analisis del Canal de Venta"]
[null,"<---------------------------------------------------------  \"Introducir Fecha\""]
[]
[{"$nulls":3},"Volumen Anual","Volumen Anual","% de Ventas","Media al mes","Media al mes"]
[{"$nulls":3},"Unidad","Euros (€)","Totales","Unidades","Euros (€)"]
[null,"Tiendas de Empresa"]
[{"$nulls":5},{"$f":"IF(AND(SUM(D8),SUM(E8)),SUM(E8)/SUM($E$12),\"\")","v":""},{"$f":"IF(SUM(F8),D8/12,\"\")","v":""},{"$f":"IF(SUM(G8),+E8/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D9),SUM(E9)),SUM(E9)/SUM($E$12),\"\")","v":""},{"$f":"IF(SUM(F9),D9/12,\"\")","v":""},{"$f":"IF(SUM(G9),+E9/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D10),SUM(E10)),SUM(E10)/SUM($E$12),\"\")","v":""},{"$f":"IF(SUM(F10),D10/12,\"\")","v":""},{"$f":"IF(SUM(G10),+E10/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D11),SUM(E11)),SUM(E11)/SUM($E$12),\"\")","v":""},{"$f":"IF(SUM(F11),D11/12,\"\")","v":""},{"$f":"IF(SUM(G11),+E11/12,\"\")","v":""}]
[null,"Total",null,{"$f":"IF(SUM(D8:D11),SUM(D8:D11),\"\")","v":""},{"$f":"IF(SUM(E8:E11),SUM(E8:E11),\"\")","v":""},{"$f":"IF(AND(SUM(D12),SUM(E12)),E12/$E$47,\"\")","v":""},{"$f":"IF(SUM(G8:G11),SUM(G8:G11),\"\")","v":""},{"$f":"IF(SUM(H8:H11),SUM(H8:H11),\"\")","v":""}]
[null,"Tiendas Independientes"]
[{"$nulls":5},{"$f":"IF(AND(SUM(D14),SUM(E14)),SUM(E14)/SUM($E$18),\"\")","v":""},{"$f":"IF(SUM(F14),D14/12,\"\")","v":""},{"$f":"IF(SUM(G14),+E14/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D15),SUM(E15)),SUM(E15)/SUM($E$18),\"\")","v":""},{"$f":"IF(SUM(F15),D15/12,\"\")","v":""},{"$f":"IF(SUM(G15),+E15/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D16),SUM(E16)),SUM(E16)/SUM($E$18),\"\")","v":""},{"$f":"IF(SUM(F16),D16/12,\"\")","v":""},{"$f":"IF(SUM(G16),+E16/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D17),SUM(E17)),SUM(E17)/SUM($E$18),\"\")","v":""},{"$f":"IF(SUM(F17),D17/12,\"\")","v":""},{"$f":"IF(SUM(G17),+E17/12,\"\")","v":""}]
[null,"Total",null,{"$f":"IF(SUM(D14:D17),SUM(D14:D17),\"\")","v":""},{"$f":"IF(SUM(E14:E17),SUM(E14:E17),\"\")","v":""},{"$f":"IF(AND(SUM(D18),SUM(E18)),E18/$E$47,\"\")","v":""},{"$f":"IF(SUM(G14:G17),SUM(G14:G17),\"\")","v":""},{"$f":"IF(SUM(H14:H17),SUM(H14:H17),\"\")","v":""}]
[null,"Fuerza de Ventas"]
[{"$nulls":5},{"$f":"IF(AND(SUM(D20),SUM(E20)),SUM(E20)/SUM($E$24),\"\")","v":""},{"$f":"IF(SUM(F20),D20/12,\"\")","v":""},{"$f":"IF(SUM(G20),+E20/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D21),SUM(E21)),SUM(E21)/SUM($E$24),\"\")","v":""},{"$f":"IF(SUM(F21),D21/12,\"\")","v":""},{"$f":"IF(SUM(G21),+E21/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D22),SUM(E22)),SUM(E22)/SUM($E$24),\"\")","v":""},{"$f":"IF(SUM(F22),D22/12,\"\")","v":""},{"$f":"IF(SUM(G22),+E22/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D23),SUM(E23)),SUM(E23)/SUM($E$24),\"\")","v":""},{"$f":"IF(SUM(F23),D23/12,\"\")","v":""},{"$f":"IF(SUM(G23),+E23/12,\"\")","v":""}]
[null,"Total",null,{"$f":"IF(SUM(D20:D23),SUM(D20:D23),\"\")","v":""},{"$f":"IF(SUM(E20:E23),SUM(E20:E23),\"\")","v":""},{"$f":"IF(AND(SUM(D24),SUM(E24)),E24/$E$47,\"\")","v":""},{"$f":"IF(SUM(G20:G23),SUM(G20:G23),\"\")","v":""},{"$f":"IF(SUM(H20:H23),SUM(H20:H23),\"\")","v":""}]
[null,"Canal 4"]
[{"$nulls":5},{"$f":"IF(AND(SUM(D26),SUM(E26)),SUM(E26)/SUM($E$30),\"\")","v":""},{"$f":"IF(SUM(F26),D26/12,\"\")","v":""},{"$f":"IF(SUM(G26),+E26/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D27),SUM(E27)),SUM(E27)/SUM($E$30),\"\")","v":""},{"$f":"IF(SUM(F27),D27/12,\"\")","v":""},{"$f":"IF(SUM(G27),+E27/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D28),SUM(E28)),SUM(E28)/SUM($E$30),\"\")","v":""},{"$f":"IF(SUM(F28),D28/12,\"\")","v":""},{"$f":"IF(SUM(G28),+E28/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D29),SUM(E29)),SUM(E29)/SUM($E$30),\"\")","v":""},{"$f":"IF(SUM(F29),D29/12,\"\")","v":""},{"$f":"IF(SUM(G29),+E29/12,\"\")","v":""}]
[null,"Total",null,{"$f":"IF(SUM(D26:D29),SUM(D26:D29),\"\")","v":""},{"$f":"IF(SUM(E26:E29),SUM(E26:E29),\"\")","v":""},{"$f":"IF(AND(SUM(D30),SUM(E30)),E30/$E$47,\"\")","v":""},{"$f":"IF(SUM(G26:G29),SUM(G26:G29),\"\")","v":""},{"$f":"IF(SUM(H26:H29),SUM(H26:H29),\"\")","v":""}]
[null,"Distribuidores de Empresa"]
[{"$nulls":5},{"$f":"IF(AND(SUM(D32),SUM(E32)),SUM(E32)/SUM($E$36),\"\")","v":""},{"$f":"IF(SUM(F32),D32/12,\"\")","v":""},{"$f":"IF(SUM(G32),+E32/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D33),SUM(E33)),SUM(E33)/SUM($E$36),\"\")","v":""},{"$f":"IF(SUM(F33),D33/12,\"\")","v":""},{"$f":"IF(SUM(G33),+E33/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D34),SUM(E34)),SUM(E34)/SUM($E$36),\"\")","v":""},{"$f":"IF(SUM(F34),D34/12,\"\")","v":""},{"$f":"IF(SUM(G34),+E34/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D35),SUM(E35)),SUM(E35)/SUM($E$36),\"\")","v":""},{"$f":"IF(SUM(F35),D35/12,\"\")","v":""},{"$f":"IF(SUM(G35),+E35/12,\"\")","v":""}]
[null,"Total",null,{"$f":"IF(SUM(D32:D35),SUM(D32:D35),\"\")","v":""},{"$f":"IF(SUM(E32:E35),SUM(E32:E35),\"\")","v":""},{"$f":"IF(AND(SUM(D36),SUM(E36)),E36/$E$47,\"\")","v":""},{"$f":"IF(SUM(G32:G35),SUM(G32:G35),\"\")","v":""},{"$f":"IF(SUM(H32:H35),SUM(H32:H35),\"\")","v":""}]
[null,"Distribuidores independientes"]
[{"$nulls":5},{"$f":"IF(AND(SUM(D38),SUM(E38)),SUM(E38)/SUM($E$42),\"\")","v":""},{"$f":"IF(SUM(F38),D38/12,\"\")","v":""},{"$f":"IF(SUM(G38),+E38/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D39),SUM(E39)),SUM(E39)/SUM($E$42),\"\")","v":""},{"$f":"IF(SUM(F39),D39/12,\"\")","v":""},{"$f":"IF(SUM(G39),+E39/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D40),SUM(E40)),SUM(E40)/SUM($E$42),\"\")","v":""},{"$f":"IF(SUM(F40),D40/12,\"\")","v":""},{"$f":"IF(SUM(G40),+E40/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D41),SUM(E41)),SUM(E41)/SUM($E$42),\"\")","v":""},{"$f":"IF(SUM(F41),D41/12,\"\")","v":""},{"$f":"IF(SUM(G41),+E41/12,\"\")","v":""}]
[null,"Total",null,{"$f":"IF(SUM(D38:D41),SUM(D38:D41),\"\")","v":""},{"$f":"IF(SUM(E38:E41),SUM(E38:E41),\"\")","v":""},{"$f":"IF(AND(SUM(D42),SUM(E42)),E42/$E$47,\"\")","v":""},{"$f":"IF(SUM(G38:G41),SUM(G38:G41),\"\")","v":""},{"$f":"IF(SUM(H38:H41),SUM(H38:H41),\"\")","v":""}]
[null,"Otros"]
[{"$nulls":5},{"$f":"IF(AND(SUM(D44),SUM(E44)),SUM(E44)/SUM($E$46),\"\")","v":""},{"$f":"IF(SUM(F44),D44/12,\"\")","v":""},{"$f":"IF(SUM(G44),+E44/12,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D45),SUM(E45)),SUM(E45)/SUM($E$46),\"\")","v":""},{"$f":"IF(SUM(F45),D45/12,\"\")","v":""},{"$f":"IF(SUM(G45),+E45/12,\"\")","v":""}]
[null,"Total",null,null,{"$f":"IF(SUM(E42:E45),SUM(E42:E45),\"\")","v":""},{"$f":"IF(SUM(F44:F45),SUM(F44:F45),\"\")","v":""},{"$f":"IF(SUM(G44:G45),SUM(G44:G45),\"\")","v":""},{"$f":"IF(SUM(H44:H45),SUM(H44:H45),\"\")","v":""}]
[null,"Total para el Canal",null,{"$f":"IF(SUM(D12,D18,D24,D30,D36,D42,D46),SUM(D12,D18,D24,D30,D36,D42,D46),\"\")","v":""},{"$f":"IF(SUM(E12,E18,E24,E30,E36,E42,E46),SUM(E12,E18,E24,E30,E36,E42,E46),\"\")","v":""},{"$f":"IF(AND(SUM(D47:E47),SUM(E47)),SUM(E47)/SUM(E47),\"\")","v":""},{"$f":"IF(SUM(F47),D47/12,\"\")","v":""},{"$f":"IF(SUM(G47),+E47/12,\"\")","v":""}]