{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Saisie des prévisions","Prévision des ventes","Listes"],"not_rendered":{"charts":1,"images":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Saisie des prévisions","index":0,"n_rows":29,"n_cols":11,"rows_kept":29}
[{"$nulls":10}," "]
[null,"Confidentiel société"]
[null,"Nom de la société"]
[null,"Prévision des ventes"]
[]
[null,"Nom de l’opportunité","Agent commercial","Région des ventes","Catégories commerciales","Montant de la prévision","Phase de vente","Probabilité de la vente","Clôture de la prévision","Prévision pondérée"]
[null,"Adatum Corporation"," Agent commercial 1","US : Nord-est","Conseil",{"v":150000,"d":"150,000.00 €"},"Approbation formelle",{"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"," Agent commercial 2","US : Sud-est","Produits",{"v":145200,"d":"145,200.00 €"},"Opportunité",{"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"," Agent commercial 3","US : Central nord","Formation",{"v":162500,"d":"162,500.00 €"},"Besoin identifié",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2020-03-01"},{"v":32500,"d":"32,500.00 €"}]
[null,"Baldwin Museum of Science"," Agent commercial 4","US : Central sud","Mixte",{"v":147500,"d":"147,500.00 €"},"Parrainage",{"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"," Agent commercial 5","US : Nord-ouest","Services pro.",{"v":148000,"d":"148,000.00 €"},"Budget validé",{"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"," Agent commercial 1","US : Sud-ouest","Support",{"v":175000,"d":"175,000.00 €"},"Analyse des besoins",{"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"," Agent commercial 3","Canada : Est","Mixte",{"v":149000,"d":"149,000.00 €"},"Solution proposée",{"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"," Agent commercial 5","Canada : Ouest","Formation",{"v":142000,"d":"142,000.00 €"},"Proposition écrite",{"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."," Agent commercial 3","EMEA : France","Mixte",{"v":172500,"d":"172,500.00 €"},"Approbation orale",{"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"," Agent commercial 4","EMEA : Allemagne","Produits",{"v":163500,"d":"163,500.00 €"},"Parrainage",{"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"," Agent commercial 5","EMEA : Italie","Produits",{"v":155500,"d":"155,500.00 €"},"Approbation formelle",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2020-12-01"},{"v":155500,"d":"155,500.00 €"}]
[null,"Fabrikam, Inc."," Agent commercial 4","EMEA : Autres","Conseil",{"v":166000,"d":"166,000.00 €"},"Opportunité",{"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"," Agent commercial 3","APSA : Asie","Formation",{"v":180000,"d":"180,000.00 €"},"Budget validé",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2020-03-01"},{"v":54000,"d":"54,000.00 €"}]
[null,"Graphic Design Institute"," Agent commercial 2","APSA : Pacifique","Services",{"v":140000,"d":"140,000.00 €"},"Solution proposée",{"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"," Agent commercial 1","APSA : Mexique","Support",{"v":155000,"d":"155,000.00 €"},"Parrainage",{"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."," Agent commercial 2","APSA : Australie","Services pro.",{"v":173200,"d":"173,200.00 €"},"Analyse des besoins",{"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"," Agent commercial 5","APSA : Autres","Services",{"v":146500,"d":"146,500.00 €"},"Solution proposée",{"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"," Agent commercial 4","US : Nord-est","Support",{"v":156750,"d":"156,750.00 €"},"Proposition écrite",{"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"," Agent commercial 3","US : Central sud","Services pro.",{"v":162000,"d":"162,000.00 €"},"Approbation orale",{"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."," Agent commercial 4","Canada : Est","Mixte",{"v":157000,"d":"157,000.00 €"},"Approbation formelle",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2020-03-01"},{"v":157000,"d":"157,000.00 €"}]
[null,"École des Beaux-Arts"," Agent commercial 3","EMEA : France","Services",{"v":173000,"d":"173,000.00 €"},"Budget validé",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2020-04-01"},{"v":69200,"d":"69,200.00 €"}]
[null,"Sud Vidéo"," Agent commercial 5","EMEA : Royaume-uni","Mixte",{"v":171000,"d":"171,000.00 €"},"Analyse des besoins",{"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"," Agent commercial 1","APSA : Australie","Produits",{"v":168000,"d":"168,000.00 €"},"Solution proposée",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,9,1)","v":"2020-09-01"},{"v":100800,"d":"100,800.00 €"}]

{"sheet":"Prévision des ventes","index":1,"n_rows":20,"n_cols":18,"rows_kept":20}
[{"$nulls":10}," "]
[null,"Confidentiel société"]
[]
[null,"Graphique de prévision des ventes"]
[]
[null,"Mois de départ",{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2020-01-01"}]
[]
[null,"Mois","Prévision mensuelle","Cumulé",{"$nulls":11},{"$f":"B8","v":"Mois"},"Prévision mensuelle","Cumulé"]
[null,{"$f":"DATE(YEAR(Starting_Month),MONTH(Starting_Month)+0,1)","v":"2020-01-01"},{"$f":"SUMIFS(Table_ForecastInput[Prévision pondérée],Table_ForecastInput[Clôture de la prévision],\">=\"&'Prévision des ventes'!B9,Table_ForecastInput[Clôture de la prévision],\"<=\"&DATE(YEAR('Prévision des ventes'!B9),MONTH('Prévision des ventes'!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(Starting_Month),MONTH(Starting_Month)+1,1)","v":"2020-02-01"},{"$f":"SUMIFS(Table_ForecastInput[Prévision pondérée],Table_ForecastInput[Clôture de la prévision],\">=\"&'Prévision des ventes'!B10,Table_ForecastInput[Clôture de la prévision],\"<=\"&DATE(YEAR('Prévision des ventes'!B10),MONTH('Prévision des ventes'!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(Starting_Month),MONTH(Starting_Month)+2,1)","v":"2020-03-01"},{"$f":"SUMIFS(Table_ForecastInput[Prévision pondérée],Table_ForecastInput[Clôture de la prévision],\">=\"&'Prévision des ventes'!B11,Table_ForecastInput[Clôture de la prévision],\"<=\"&DATE(YEAR('Prévision des ventes'!B11),MONTH('Prévision des ventes'!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(Starting_Month),MONTH(Starting_Month)+3,1)","v":"2020-04-01"},{"$f":"SUMIFS(Table_ForecastInput[Prévision pondérée],Table_ForecastInput[Clôture de la prévision],\">=\"&'Prévision des ventes'!B12,Table_ForecastInput[Clôture de la prévision],\"<=\"&DATE(YEAR('Prévision des ventes'!B12),MONTH('Prévision des ventes'!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(Starting_Month),MONTH(Starting_Month)+4,1)","v":"2020-05-01"},{"$f":"SUMIFS(Table_ForecastInput[Prévision pondérée],Table_ForecastInput[Clôture de la prévision],\">=\"&'Prévision des ventes'!B13,Table_ForecastInput[Clôture de la prévision],\"<=\"&DATE(YEAR('Prévision des ventes'!B13),MONTH('Prévision des ventes'!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(Starting_Month),MONTH(Starting_Month)+5,1)","v":"2020-06-01"},{"$f":"SUMIFS(Table_ForecastInput[Prévision pondérée],Table_ForecastInput[Clôture de la prévision],\">=\"&'Prévision des ventes'!B14,Table_ForecastInput[Clôture de la prévision],\"<=\"&DATE(YEAR('Prévision des ventes'!B14),MONTH('Prévision des ventes'!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(Starting_Month),MONTH(Starting_Month)+6,1)","v":"2020-07-01"},{"$f":"SUMIFS(Table_ForecastInput[Prévision pondérée],Table_ForecastInput[Clôture de la prévision],\">=\"&'Prévision des ventes'!B15,Table_ForecastInput[Clôture de la prévision],\"<=\"&DATE(YEAR('Prévision des ventes'!B15),MONTH('Prévision des ventes'!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(Starting_Month),MONTH(Starting_Month)+7,1)","v":"2020-08-01"},{"$f":"SUMIFS(Table_ForecastInput[Prévision pondérée],Table_ForecastInput[Clôture de la prévision],\">=\"&'Prévision des ventes'!B16,Table_ForecastInput[Clôture de la prévision],\"<=\"&DATE(YEAR('Prévision des ventes'!B16),MONTH('Prévision des ventes'!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(Starting_Month),MONTH(Starting_Month)+8,1)","v":"2020-09-01"},{"$f":"SUMIFS(Table_ForecastInput[Prévision pondérée],Table_ForecastInput[Clôture de la prévision],\">=\"&'Prévision des ventes'!B17,Table_ForecastInput[Clôture de la prévision],\"<=\"&DATE(YEAR('Prévision des ventes'!B17),MONTH('Prévision des ventes'!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(Starting_Month),MONTH(Starting_Month)+9,1)","v":"2020-10-01"},{"$f":"SUMIFS(Table_ForecastInput[Prévision pondérée],Table_ForecastInput[Clôture de la prévision],\">=\"&'Prévision des ventes'!B18,Table_ForecastInput[Clôture de la prévision],\"<=\"&DATE(YEAR('Prévision des ventes'!B18),MONTH('Prévision des ventes'!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(Starting_Month),MONTH(Starting_Month)+10,1)","v":"2020-11-01"},{"$f":"SUMIFS(Table_ForecastInput[Prévision pondérée],Table_ForecastInput[Clôture de la prévision],\">=\"&'Prévision des ventes'!B19,Table_ForecastInput[Clôture de la prévision],\"<=\"&DATE(YEAR('Prévision des ventes'!B19),MONTH('Prévision des ventes'!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(Starting_Month),MONTH(Starting_Month)+11,1)","v":"2020-12-01"},{"$f":"SUMIFS(Table_ForecastInput[Prévision pondérée],Table_ForecastInput[Clôture de la prévision],\">=\"&'Prévision des ventes'!B20,Table_ForecastInput[Clôture de la prévision],\"<=\"&DATE(YEAR('Prévision des ventes'!B20),MONTH('Prévision des ventes'!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":"Listes","index":2,"n_rows":21,"n_cols":8,"rows_kept":21}
[null,"Listes"]
[]
[null,"Agents commerciaux",null,"Régions commerciales",null,"Catégories commerciales",null,"Phases de vente"]
[null," Agent commercial 1",null,"US : Nord-est",null,"Conseil",null,"Besoin identifié"]
[null," Agent commercial 2",null,"US : Sud-est",null,"Mixte",null,"Opportunité"]
[null," Agent commercial 3",null,"US : Central nord",null,"Produits",null,"Analyse des besoins"]
[null," Agent commercial 4",null,"US : Central sud",null,"Services pro.",null,"Solution proposée"]
[null," Agent commercial 5",null,"US : Nord-ouest",null,"Services",null,"Proposition écrite"]
[{"$nulls":3},"US : Sud-ouest",null,"Support",null,"Approbation orale"]
[{"$nulls":3},"Canada : Est",null,"Formation",null,"Approbation formelle"]
[{"$nulls":3},"Canada : Ouest",{"$nulls":3},"Budget validé"]
[{"$nulls":3},"EMEA : France",{"$nulls":3},"Parrainage"]
[{"$nulls":3},"EMEA : Allemagne"]
[{"$nulls":3},"EMEA : Italie"]
[{"$nulls":3},"EMEA : Autres"]
[{"$nulls":3},"APSA : Asie"]
[{"$nulls":3},"APSA : Pacifique"]
[{"$nulls":3},"APSA : Mexique"]
[{"$nulls":3},"APSA : Australie"]
[{"$nulls":3},"APSA : Autres"]
[{"$nulls":3},"EMEA : Royaume-uni"]