{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Entrada de previsión","Previsión de ventas","Listas"],"not_rendered":{"charts":1,"images":4,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Entrada de previsión","index":0,"n_rows":29,"n_cols":11,"rows_kept":29}
[{"$nulls":10}," "]
[null,"HLP Manufacturing INC"]
[null,"Previsión de ventas"]
[null,"Confidencial"]
[]
[null,"Nombre de la oportunidad","Ventas \nagente","Ventas \nregión","Ventas \ncategoría","Cantidad prevista","Ventas \nfase","Probabilidad de venta","Previsión \ncerrar","Previsión ponderada"]
[null,"Adatum Corporation","Rowan Murphy","Estados Unidos: nordeste","Consultoría",{"v":150000,"d":"150,000 €"},"Aprobación formal",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2025-01-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":135000,"d":"135,000 €"}}]
[null,"Adventure Works","Miho Kojima","Estados Unidos: sudeste","Productos",{"v":145200,"d":"145,200 €"},"Oportunidad",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2025-02-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":14520,"d":"14,520 €"}}]
[null,"Alpine Ski House","Cora Thomas","Estados Unidos: norte central","Aprendizaje",{"v":162500,"d":"162,500 €"},"Necesidad identificada",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2025-03-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":32500,"d":"32,500 €"}}]
[null,"Museo de ciencia Baldwin","Ellis Turner","Estados Unidos: sur central","Mezcla",{"v":147500,"d":"147,500 €"},"Patrocinio",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2025-04-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":44250,"d":"44,250 €"}}]
[null,"Blue Yonder Airlines","Suma Kini","Estados Unidos: noroeste","Servicios profesionales",{"v":148000,"d":"148,000 €"},"Presupuesto validado",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2025-05-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":59200,"d":"59,200 €"}}]
[null,"City Power & Light","Rowan Murphy","Estados Unidos: sudoeste","Apoyo",{"v":175000,"d":"175,000 €"},"Análisis de necesidades",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2025-06-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":87500,"d":"87,500 €"}}]
[null,"Coho Vineyard","Cora Thomas","Canadá: este","Mezcla",{"v":149000,"d":"149,000 €"},"Solución propuesta",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,7,1)","v":"2025-07-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":89400,"d":"89,400 €"}}]
[null,"Coho Winery","Suma Kini","Canadá: oeste","Aprendizaje",{"v":142000,"d":"142,000 €"},"Propuesta escrita",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2025-08-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":99400,"d":"99,400 €"}}]
[null,"Contoso, Ltd.","Cora Thomas","EMEA: Francia","Mezcla",{"v":172500,"d":"172,500 €"},"Aprobación verbal",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2025-10-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":155250,"d":"155,250 €"}}]
[null,"Contoso Pharmaceuticals","Ellis Turner","EMEA: Alemania","Productos",{"v":163500,"d":"163,500 €"},"Patrocinio",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2025-11-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":32700,"d":"32,700 €"}}]
[null,"Consolidated Messenger","Suma Kini","EMEA: Italia","Productos",{"v":155500,"d":"155,500 €"},"Aprobación formal",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2025-12-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":155500,"d":"155,500 €"}}]
[null,"Fabrikam, Inc.","Ellis Turner","EMEA: otro","Consultoría",{"v":166000,"d":"166,000 €"},"Oportunidad",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2025-01-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":16600,"d":"16,600 €"}}]
[null,"Fourth Coffee","Cora Thomas","APSA: Asia","Aprendizaje",{"v":180000,"d":"180,000 €"},"Presupuesto validado",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2025-03-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":54000,"d":"54,000 €"}}]
[null,"Graphic Design Institute","Miho Kojima","APSA: Pacífico","Servicios",{"v":140000,"d":"140,000 €"},"Solución propuesta",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2025-05-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":84000,"d":"84,000 €"}}]
[null,"Humongous Insurance","Rowan Murphy","APSA: México","Soporte",{"v":155000,"d":"155,000 €"},"Patrocinio",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2025-06-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":46500,"d":"46,500 €"}}]
[null,"Litware, Inc.","Miho Kojima","APSA: Australia","Servicios profesionales",{"v":173200,"d":"173,200 €"},"Análisis de necesidades",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2025-10-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":86600,"d":"86,600 €"}}]
[null,"Lucerne Publishing","Suma Kini","APSA: otro","Servicios",{"v":146500,"d":"146,500 €"},"Solución propuesta",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2025-12-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":87900,"d":"87,900 €"}}]
[null,"Margie's Travel","Ellis Turner","Estados Unidos: nordeste","Soporte técnico",{"v":156750,"d":"156,750 €"},"Propuesta escrita",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2025-11-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":109725,"d":"109,725 €"}}]
[null,"Northwind Traders","Cora Thomas","Estados Unidos: sur central","Servicios profesionales",{"v":162000,"d":"162,000 €"},"Aprobación verbal",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2025-02-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":145800,"d":"145,800 €"}}]
[null,"Proseware, Inc.","Ellis Turner","Canadá: este","Mezcla",{"v":157000,"d":"157,000 €"},"Aprobación formal",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2025-03-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":157000,"d":"157,000 €"}}]
[null,"School of Fine Art","Miho Kojima","EMEA: Francia","Servicios",{"v":173000,"d":"173,000 €"},"Presupuesto validado",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2025-04-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":69200,"d":"69,200 €"}}]
[null,"Vídeo de Southridge","Suma Kini","EMEA: Reino Unido","Mezcla",{"v":171000,"d":"171,000 €"},"Análisis de necesidades",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2025-08-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":85500,"d":"85,500 €"}}]
[null,"Tailspin Toys","Rowan Murphy","APSA: Australia","Productos",{"v":168000,"d":"168,000 €"},"Solución propuesta",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,9,1)","v":"2025-09-01"},{"$f":"Tabla_EntradaPrevisión[[#This Row],[Cantidad prevista]]*Tabla_EntradaPrevisión[[#This Row],[Probabilidad de venta]]","v":{"v":100800,"d":"100,800 €"}}]

{"sheet":"Previsión de ventas","index":1,"n_rows":19,"n_cols":18,"rows_kept":19}
[{"$nulls":14}," "]
[null,{"$f":"NombreEmpresa","v":"HLP Manufacturing INC"}]
[null,"Gráfico de previsión"]
[null,"Confidencial"]
[null,"Mes inicial",{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2025-01-01"}]
[null,"Mes","Mensualmente \nprevisión","Acumulado",{"$nulls":11},{"$f":"B6","v":"Mes"},"Previsión mensual","Acumulado"]
[null,{"$f":"DATE(YEAR(Mes_inicial),MONTH(Mes_inicial)+0,1)","v":"2025-01-01"},{"$f":"SUMIFS(Tabla_EntradaPrevisión[Previsión ponderada],Tabla_EntradaPrevisión[Previsión \ncerrar],\">=\"&'Previsión de ventas'!B7,Tabla_EntradaPrevisión[Previsión \ncerrar],\"<=\"&DATE(YEAR('Previsión de ventas'!B7),MONTH('Previsión de ventas'!B7)+1,0))","v":{"v":151600,"d":"151,600 €"}},{"$f":"IF(ISNUMBER(D6),D6+C7,C7)","v":{"v":151600,"d":"151,600 €"}},{"$nulls":11},{"$f":"B7","v":"2025-01-01"},{"$f":"C7","v":{"v":151600,"d":"151,600 €"}},{"$f":"D7-C7","v":0}]
[null,{"$f":"DATE(YEAR(Mes_inicial),MONTH(Mes_inicial)+1,1)","v":"2025-02-01"},{"$f":"SUMIFS(Tabla_EntradaPrevisión[Previsión ponderada],Tabla_EntradaPrevisión[Previsión \ncerrar],\">=\"&'Previsión de ventas'!B8,Tabla_EntradaPrevisión[Previsión \ncerrar],\"<=\"&DATE(YEAR('Previsión de ventas'!B8),MONTH('Previsión de ventas'!B8)+1,0))","v":{"v":160320,"d":"160,320 €"}},{"v":311920,"d":"311,920 €"},{"$nulls":11},"2025-02-01",{"$f":"C8","v":{"v":160320,"d":"160,320 €"}},{"$f":"D8-C8","v":{"v":151600,"d":"151,600 €"}}]
[null,{"$f":"DATE(YEAR(Mes_inicial),MONTH(Mes_inicial)+2,1)","v":"2025-03-01"},{"$f":"SUMIFS(Tabla_EntradaPrevisión[Previsión ponderada],Tabla_EntradaPrevisión[Previsión \ncerrar],\">=\"&'Previsión de ventas'!B9,Tabla_EntradaPrevisión[Previsión \ncerrar],\"<=\"&DATE(YEAR('Previsión de ventas'!B9),MONTH('Previsión de ventas'!B9)+1,0))","v":{"v":243500,"d":"243,500 €"}},{"$f":"IF(ISNUMBER(D8),D8+C9,C9)","v":{"v":555420,"d":"555,420 €"}},{"$nulls":11},{"$f":"B9","v":"2025-03-01"},{"$f":"C9","v":{"v":243500,"d":"243,500 €"}},{"$f":"D9-C9","v":{"v":311920,"d":"311,920 €"}}]
[null,{"$f":"DATE(YEAR(Mes_inicial),MONTH(Mes_inicial)+3,1)","v":"2025-04-01"},{"$f":"SUMIFS(Tabla_EntradaPrevisión[Previsión ponderada],Tabla_EntradaPrevisión[Previsión \ncerrar],\">=\"&'Previsión de ventas'!B10,Tabla_EntradaPrevisión[Previsión \ncerrar],\"<=\"&DATE(YEAR('Previsión de ventas'!B10),MONTH('Previsión de ventas'!B10)+1,0))","v":{"v":113450,"d":"113,450 €"}},{"v":668870,"d":"668,870 €"},{"$nulls":11},"2025-04-01",{"v":113450,"d":"113,450 €"},{"v":555420,"d":"555,420 €"}]
[null,{"$f":"DATE(YEAR(Mes_inicial),MONTH(Mes_inicial)+4,1)","v":"2025-05-01"},{"$f":"SUMIFS(Tabla_EntradaPrevisión[Previsión ponderada],Tabla_EntradaPrevisión[Previsión \ncerrar],\">=\"&'Previsión de ventas'!B11,Tabla_EntradaPrevisión[Previsión \ncerrar],\"<=\"&DATE(YEAR('Previsión de ventas'!B11),MONTH('Previsión de ventas'!B11)+1,0))","v":{"v":143200,"d":"143,200 €"}},{"v":812070,"d":"812,070 €"},{"$nulls":11},"2025-05-01",{"v":143200,"d":"143,200 €"},{"v":668870,"d":"668,870 €"}]
[null,{"$f":"DATE(YEAR(Mes_inicial),MONTH(Mes_inicial)+5,1)","v":"2025-06-01"},{"$f":"SUMIFS(Tabla_EntradaPrevisión[Previsión ponderada],Tabla_EntradaPrevisión[Previsión \ncerrar],\">=\"&'Previsión de ventas'!B12,Tabla_EntradaPrevisión[Previsión \ncerrar],\"<=\"&DATE(YEAR('Previsión de ventas'!B12),MONTH('Previsión de ventas'!B12)+1,0))","v":{"v":134000,"d":"134,000 €"}},{"v":946070,"d":"946,070 €"},{"$nulls":11},"2025-06-01",{"v":134000,"d":"134,000 €"},{"v":812070,"d":"812,070 €"}]
[null,{"$f":"DATE(YEAR(Mes_inicial),MONTH(Mes_inicial)+6,1)","v":"2025-07-01"},{"$f":"SUMIFS(Tabla_EntradaPrevisión[Previsión ponderada],Tabla_EntradaPrevisión[Previsión \ncerrar],\">=\"&'Previsión de ventas'!B13,Tabla_EntradaPrevisión[Previsión \ncerrar],\"<=\"&DATE(YEAR('Previsión de ventas'!B13),MONTH('Previsión de ventas'!B13)+1,0))","v":{"v":89400,"d":"89,400 €"}},{"v":1035470,"d":"1,035,470 €"},{"$nulls":11},"2025-07-01",{"v":89400,"d":"89,400 €"},{"v":946070,"d":"946,070 €"}]
[null,{"$f":"DATE(YEAR(Mes_inicial),MONTH(Mes_inicial)+7,1)","v":"2025-08-01"},{"$f":"SUMIFS(Tabla_EntradaPrevisión[Previsión ponderada],Tabla_EntradaPrevisión[Previsión \ncerrar],\">=\"&'Previsión de ventas'!B14,Tabla_EntradaPrevisión[Previsión \ncerrar],\"<=\"&DATE(YEAR('Previsión de ventas'!B14),MONTH('Previsión de ventas'!B14)+1,0))","v":{"v":184900,"d":"184,900 €"}},{"v":1220370,"d":"1,220,370 €"},{"$nulls":11},"2025-08-01",{"v":184900,"d":"184,900 €"},{"v":1035470,"d":"1,035,470 €"}]
[null,{"$f":"DATE(YEAR(Mes_inicial),MONTH(Mes_inicial)+8,1)","v":"2025-09-01"},{"$f":"SUMIFS(Tabla_EntradaPrevisión[Previsión ponderada],Tabla_EntradaPrevisión[Previsión \ncerrar],\">=\"&'Previsión de ventas'!B15,Tabla_EntradaPrevisión[Previsión \ncerrar],\"<=\"&DATE(YEAR('Previsión de ventas'!B15),MONTH('Previsión de ventas'!B15)+1,0))","v":{"v":100800,"d":"100,800 €"}},{"v":1321170,"d":"1,321,170 €"},{"$nulls":11},"2025-09-01",{"v":100800,"d":"100,800 €"},{"v":1220370,"d":"1,220,370 €"}]
[null,{"$f":"DATE(YEAR(Mes_inicial),MONTH(Mes_inicial)+9,1)","v":"2025-10-01"},{"$f":"SUMIFS(Tabla_EntradaPrevisión[Previsión ponderada],Tabla_EntradaPrevisión[Previsión \ncerrar],\">=\"&'Previsión de ventas'!B16,Tabla_EntradaPrevisión[Previsión \ncerrar],\"<=\"&DATE(YEAR('Previsión de ventas'!B16),MONTH('Previsión de ventas'!B16)+1,0))","v":{"v":241850,"d":"241,850 €"}},{"v":1563020,"d":"1,563,020 €"},{"$nulls":11},"2025-10-01",{"v":241850,"d":"241,850 €"},{"v":1321170,"d":"1,321,170 €"}]
[null,{"$f":"DATE(YEAR(Mes_inicial),MONTH(Mes_inicial)+10,1)","v":"2025-11-01"},{"$f":"SUMIFS(Tabla_EntradaPrevisión[Previsión ponderada],Tabla_EntradaPrevisión[Previsión \ncerrar],\">=\"&'Previsión de ventas'!B17,Tabla_EntradaPrevisión[Previsión \ncerrar],\"<=\"&DATE(YEAR('Previsión de ventas'!B17),MONTH('Previsión de ventas'!B17)+1,0))","v":{"v":142425,"d":"142,425 €"}},{"v":1705445,"d":"1,705,445 €"},{"$nulls":11},"2025-11-01",{"v":142425,"d":"142,425 €"},{"v":1563020,"d":"1,563,020 €"}]
[null,{"$f":"DATE(YEAR(Mes_inicial),MONTH(Mes_inicial)+11,1)","v":"2025-12-01"},{"$f":"SUMIFS(Tabla_EntradaPrevisión[Previsión ponderada],Tabla_EntradaPrevisión[Previsión \ncerrar],\">=\"&'Previsión de ventas'!B18,Tabla_EntradaPrevisión[Previsión \ncerrar],\"<=\"&DATE(YEAR('Previsión de ventas'!B18),MONTH('Previsión de ventas'!B18)+1,0))","v":{"v":243400,"d":"243,400 €"}},{"v":1948845,"d":"1,948,845 €"},{"$nulls":11},"2025-12-01",{"v":243400,"d":"243,400 €"},{"v":1705445,"d":"1,705,445 €"}]
[{"$nulls":14}," "]

{"sheet":"Listas","index":2,"n_rows":24,"n_cols":5,"rows_kept":24}
[]
[null,{"$f":"NombreEmpresa","v":"HLP Manufacturing INC"}]
[null,"Listas de ventas"]
[null,"Confidencial"]
[]
[null,"Agentes de ventas","Regiones de ventas","Categorías de ventas","Fases de ventas"]
[null,"Rowan Murphy","Estados Unidos: nordeste","Consultoría","Necesidad identificada"]
[null,"Miho Kojima","Estados Unidos: sudeste","Mezcla","Oportunidad"]
[null,"Cora Thomas","Estados Unidos: norte central","Productos","Análisis de necesidades"]
[null,"Ellis Turner","Estados Unidos: sur central","Servicios profesionales","Solución propuesta"]
[null,"Suma Kini","Estados Unidos: noroeste","Servicios","Propuesta escrita"]
[null,null,"Estados Unidos: sudoeste","Soporte técnico","Aprobación verbal"]
[null,null,"Canadá: este","Entrenamiento","Aprobación formal"]
[null,null,"Canadá: oeste",null,"Presupuesto validado"]
[null,null,"EMEA: Francia",null,"Patrocinio"]
[null,null,"EMEA: Alemania"]
[null,null,"EMEA: Italia"]
[null,null,"EMEA: otro"]
[null,null,"APSA: Asia"]
[null,null,"APSA: Pacífico"]
[null,null,"APSA: México"]
[null,null,"APSA: Australia"]
[null,null,"APSA: otro"]
[null,null,"EMEA: Reino Unido"]