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

{"sheet":"Entrada de previsión","index":0,"n_rows":29,"n_cols":11,"rows_kept":29}
[{"$nulls":10}," "]
[null,"Confidencia de la compañía"]
[null,"Nombre de la compañía"]
[null,"Previsión de ventas"]
[]
[null,"Nombre de oportunidad","Agente de ventas","Región de ventas","Categoría de ventas","Cantidad prevista","Fase de ventas","Probabilidad de venta","Cierre de previsión","Previsión ponderada"]
[null,"Adatum Corporation"," Agente de ventas 1","EE. UU. - Noreste","Consultoría",{"v":150000,"d":"$150,000.00"},"Aprobación formal",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2020-01-01"},{"v":135000,"d":"$135,000.00"}]
[null,"Adventure Works"," Agente de ventas 2","EE. UU. - Sudeste","Productos",{"v":145200,"d":"$145,200.00"},"Oportunidad",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2020-02-01"},{"v":14520,"d":"$14,520.00"}]
[null,"Alpine Ski House"," Agente de ventas 3","EE. UU. - Centro-Norte","Aprendizaje",{"v":162500,"d":"$162,500.00"},"Necesidad identificada",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2020-03-01"},{"v":32500,"d":"$32,500.00"}]
[null,"Museo de Ciencias de Baldwin"," Agente de ventas 4","EE. UU. - Centro-Sur","Mezcla",{"v":147500,"d":"$147,500.00"},"Patrocinio",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2020-04-01"},{"v":44250,"d":"$44,250.00"}]
[null,"Blue Yonder Airlines"," Agente de ventas 5","EE. UU. - Noroeste","Servicios profesionales",{"v":148000,"d":"$148,000.00"},"Presupuesto validado",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2020-05-01"},{"v":59200,"d":"$59,200.00"}]
[null,"City Power & Light"," Agente de ventas 1","EE. UU. - Sudoeste","Apoyo",{"v":175000,"d":"$175,000.00"},"Análisis de necesidades",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2020-06-01"},{"v":87500,"d":"$87,500.00"}]
[null,"Coho Vineyard"," Agente de ventas 3","Canadá - Este","Mezcla",{"v":149000,"d":"$149,000.00"},"Solución propuesta",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,7,1)","v":"2020-07-01"},{"v":89400,"d":"$89,400.00"}]
[null,"Coho Winery"," Agente de ventas 5","Canadá - Oeste","Aprendizaje",{"v":142000,"d":"$142,000.00"},"Propuesta escrita",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2020-08-01"},{"v":99400,"d":"$99,400.00"}]
[null,"Contoso, Ltd."," Agente de ventas 3","EMEA - Francia","Mezcla",{"v":172500,"d":"$172,500.00"},"Aprobación verbal",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2020-10-01"},{"v":155250,"d":"$155,250.00"}]
[null,"Contoso Pharmaceuticals"," Agente de ventas 4","EMEA - Alemania","Productos",{"v":163500,"d":"$163,500.00"},"Patrocinio",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2020-11-01"},{"v":32700,"d":"$32,700.00"}]
[null,"Consolidated Messenger"," Agente de ventas 5","EMEA - Italia","Productos",{"v":155500,"d":"$155,500.00"},"Aprobación formal",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2020-12-01"},{"v":155500,"d":"$155,500.00"}]
[null,"Fabrikam, Inc."," Agente de ventas 4","EMEA - Otros","Consultoría",{"v":166000,"d":"$166,000.00"},"Oportunidad",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2020-01-01"},{"v":16600,"d":"$16,600.00"}]
[null,"Fourth Coffee"," Agente de ventas 3","APSA - Asia","Aprendizaje",{"v":180000,"d":"$180,000.00"},"Presupuesto validado",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2020-03-01"},{"v":54000,"d":"$54,000.00"}]
[null,"Instituto de Diseño Gráfico"," Agente de ventas 2","APSA - Pacífico","Servicios",{"v":140000,"d":"$140,000.00"},"Solución propuesta",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2020-05-01"},{"v":84000,"d":"$84,000.00"}]
[null,"Humongous Insurance"," Agente de ventas 1","APSA - México","Apoyo",{"v":155000,"d":"$155,000.00"},"Patrocinio",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2020-06-01"},{"v":46500,"d":"$46,500.00"}]
[null,"Litware, Inc."," Agente de ventas 2","APSA - Australia","Servicios profesionales",{"v":173200,"d":"$173,200.00"},"Análisis de necesidades",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2020-10-01"},{"v":86600,"d":"$86,600.00"}]
[null,"Lucerne Publishing"," Agente de ventas 5","APSA - Otros","Servicios",{"v":146500,"d":"$146,500.00"},"Solución propuesta",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2020-12-01"},{"v":87900,"d":"$87,900.00"}]
[null,"Margie's Travel"," Agente de ventas 4","EE. UU. - Noreste","Apoyo",{"v":156750,"d":"$156,750.00"},"Propuesta escrita",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2020-11-01"},{"v":109725,"d":"$109,725.00"}]
[null,"Northwind Traders"," Agente de ventas 3","EE. UU. - Centro-Sur","Servicios profesionales",{"v":162000,"d":"$162,000.00"},"Aprobación verbal",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2020-02-01"},{"v":145800,"d":"$145,800.00"}]
[null,"Proseware, Inc."," Agente de ventas 4","Canadá - Este","Mezcla",{"v":157000,"d":"$157,000.00"},"Aprobación formal",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2020-03-01"},{"v":157000,"d":"$157,000.00"}]
[null,"Escuela de Bellas Artes"," Agente de ventas 3","EMEA - Francia","Servicios",{"v":173000,"d":"$173,000.00"},"Presupuesto validado",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2020-04-01"},{"v":69200,"d":"$69,200.00"}]
[null,"Southridge Video"," Agente de ventas 5","EMEA - Reino Unido","Mezcla",{"v":171000,"d":"$171,000.00"},"Análisis de necesidades",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2020-08-01"},{"v":85500,"d":"$85,500.00"}]
[null,"Tailspin Toys"," Agente de ventas 1","APSA - Australia","Productos",{"v":168000,"d":"$168,000.00"},"Solución propuesta",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,9,1)","v":"2020-09-01"},{"v":100800,"d":"$100,800.00"}]

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

{"sheet":"Listas","index":2,"n_rows":21,"n_cols":8,"rows_kept":21}
[null,"Listas"]
[]
[null,"Agentes de ventas",null,"Regiones de ventas",null,"Categorías de ventas",null,"Fases de ventas"]
[null," Agente de ventas 1",null,"EE. UU. - Noreste",null,"Consultoría",null,"Necesidad identificada"]
[null," Agente de ventas 2",null,"EE. UU. - Sudeste",null,"Mezcla",null,"Oportunidad"]
[null," Agente de ventas 3",null,"EE. UU. - Centro-Norte",null,"Productos",null,"Análisis de necesidades"]
[null," Agente de ventas 4",null,"EE. UU. - Centro-Sur",null,"Servicios profesionales",null,"Solución propuesta"]
[null," Agente de ventas 5",null,"EE. UU. - Noroeste",null,"Servicios",null,"Propuesta escrita"]
[{"$nulls":3},"EE. UU. - Sudoeste",null,"Apoyo",null,"Aprobación verbal"]
[{"$nulls":3},"Canadá - Este",null,"Aprendizaje",null,"Aprobación formal"]
[{"$nulls":3},"Canadá - Oeste",{"$nulls":3},"Presupuesto validado"]
[{"$nulls":3},"EMEA - Francia",{"$nulls":3},"Patrocinio"]
[{"$nulls":3},"EMEA - Alemania"]
[{"$nulls":3},"EMEA - Italia"]
[{"$nulls":3},"EMEA - Otros"]
[{"$nulls":3},"APSA - Asia"]
[{"$nulls":3},"APSA - Pacífico"]
[{"$nulls":3},"APSA - México"]
[{"$nulls":3},"APSA - Australia"]
[{"$nulls":3},"APSA - Otros"]
[{"$nulls":3},"EMEA - Reino Unido"]