{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":93,"n_cols":16,"rows_kept":93,"cut":false,"hidden":false,"merged":[[2,7,2,9],[3,0,3,11],[4,0,4,11],[8,12,8,15],[9,0,9,11],[9,12,9,15],[11,2,11,7],[11,8,11,9],[11,10,11,11],[11,12,11,13],[11,14,11,15],[12,14,13,14],[12,15,13,15],[86,1,86,3],[12,8,13,8],[12,9,13,9],[12,10,13,10],[12,11,13,11],[12,12,13,12],[12,13,13,13],[12,2,13,2],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6]]}
["ENTREPRISES FRANCE EUROPE"]
["SOCIÉTÉ :"]
["DATE :"]
["1 - PRÉVISIONS  2016  PC - ACTIVITE - MARGES"]
["ACTUALISATION OCTOBRE 2016"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"FACULTATIF : POUR BOUCALGE"]
["DIR.  PRODUCTION : exemple1",null,null,null,null,null,null,null,null,null,null,null,"NE PAS L'EDITER DANS LA BROCHURE"]
["En K€ ou KCHF"]
[null,null,"COMMANDES",null,null,null,null,null,"ACTIVITÉ",null,"MARGES",null,"ACTIVITÉ",null,"MARGES"]
["AFFAIRES",null,"Nature d'ouvrage"," Clt ","Coef. Commer-cial","Date","Montant affaire pour la filiale","Montant ",2016,2017,2016,2017,"AU DELA","FINALE","AU DELA","FINALE"]
[null,null,null,null,null,null,null,"retenu"]
["EN COURS AU 01/01/2016",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Variation 2016 des en cours",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,".","HAB. NEUF","PR",null,null,null,null,null,null,null,null,null,0,null,0]
[null,".","OF NEUF","ET",null,null,null,null,null,null,null,null,null,0,null,0]
[null,".",null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["EN COURS AU 01/01/2016 corrigés",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[]
[]
["Total  PC Janvier 2016"]
["Total  PC Février 2016"]
[]
["Opération A"]
["Opération B"]
["-----------"]
[]
[]
["Total  PC Mars 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["TOTAL  Trim. 1",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[]
["Total  PC Avril 2016"]
["Total  PC Mai 2016"]
[]
["Opération A"]
["Opération B"]
["-----------"]
[]
[]
["Total  PC Juin 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["TOTAL  Trim. 2",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["TOTAL 1er Semestre 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["Total  PC Juillet 2016"]
["Total  PC Août 2016"]
[]
["Opération A * (1)",null,"HAB. NEUF","CO","Traité","2009-09-01",10000,10000,7000,3000,350,150]
["Opération B * (2)",null,"OF NEUF","PU",0.8,"2009-09-02",8000,8000,6000,2000,120,40]
["-----------"]
[]
[]
["Total  PC Septembre 2016",null,null,null,null,null,18000,18000,13000,5000,470,190,0,0,0,0]
["TOTAL  Trim. 3",null,null,null,null,null,18000,18000,13000,5000,470,190,0,0,0,0]
[]
["Opération C"]
["-----------"]
["Total  PC Octobre 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[]
["Opération D"]
["-----------"]
["Total  PC Novembre 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[]
["Opération E"]
["-----------"]
[]
[]
[]
["Total  PC Décembre 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["TOTAL  Trim. 4",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["TOTAL  ISSU DE LA PC 2016",null,null,null,null,null,18000,18000,13000,5000,470,190,0,0,0,0]
[]
["TOTAL PRODUCTION 2016",null,null,null,null,null,18000,18000,13000,5000,470,190,0,0,0,0]
["ALEAS",null,null,null,null,null,null,-10000,-7000,-3000,-350,-150]
["ACTUALISATION OCTOBRE 2016",null,null,null,null,null,null,8000,6000,2000,120,40]
[]
["Rappel ACTUA JUIN 2015"]
["Rappel PLAN 2016"]
[]
[]
["Rappel REALISE 2015"]
[]
["*(1) Affaire neutralisée par l'aléa DP "]
["*(2) Affaire neutralisée par l'aléa DG  "]
[]
[null,"Décomposition de la PC par nature juridique du client :"]
[]
[null,"Etat (ET)","ET",0]
[null,"Collectivités territoriales (CO)","CO",10000]
[null,"Entreprises publiques (PU)","PU",8000]
[null,"Entreprises Privées (PR)","PR",0]
[null,"Total hors aléas :",null,18000]

{"sheet":"Feuil2","index":1,"n_rows":93,"n_cols":16,"rows_kept":93,"cut":false,"hidden":true,"merged":[[2,7,2,9],[3,0,3,11],[4,0,4,11],[8,12,8,15],[9,0,9,11],[9,12,9,15],[11,2,11,7],[11,8,11,9],[11,10,11,11],[11,12,11,13],[11,14,11,15],[12,14,13,14],[12,15,13,15],[86,1,86,3],[12,8,13,8],[12,9,13,9],[12,10,13,10],[12,11,13,11],[12,12,13,12],[12,13,13,13],[12,2,13,2],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6]]}
["ENTREPRISES FRANCE EUROPE"]
["SOCIÉTÉ :"]
["DATE :"]
["1 - PRÉVISIONS  2016  PC - ACTIVITE - MARGES"]
["ACTUALISATION OCTOBRE 2016"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"FACULTATIF : POUR BOUCALGE"]
["DIR.  PRODUCTION : ",null,null,null,null,null,null,null,null,null,null,null,"NE PAS L'EDITER DANS LA BROCHURE"]
["En K€ ou KCHF"]
[null,null,"COMMANDES",null,null,null,null,null,"ACTIVITÉ",null,"MARGES",null,"ACTIVITÉ",null,"MARGES"]
["AFFAIRES",null,"Nature d'ouvrage"," Clt ","Coef. Commer-cial","Date","Montant affaire pour la filiale","Montant ",2016,2017,2016,2017,"AU DELA","FINALE","AU DELA","FINALE"]
[null,null,null,null,null,null,null,"retenu"]
["EN COURS AU 01/01/2016",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Variation 2016 des en cours",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,".","HAB. NEUF","PR",null,null,null,null,null,null,null,null,null,0,null,0]
[null,".","OF NEUF","ET",null,null,null,null,null,null,null,null,null,0,null,0]
[null,".",null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["EN COURS AU 01/01/2016 corrigés",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[]
[]
["Total  PC Janvier 2016"]
["Total  PC Février 2016"]
[]
["Opération A"]
["Opération B"]
["-----------"]
[]
[]
["Total  PC Mars 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["TOTAL  Trim. 1",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[]
["Total  PC Avril 2016"]
["Total  PC Mai 2016"]
[]
["Opération A"]
["Opération B"]
["-----------"]
[]
[]
["Total  PC Juin 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["TOTAL  Trim. 2",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["TOTAL 1er Semestre 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["Total  PC Juillet 2016"]
["Total  PC Août 2016"]
[]
["Opération A * (1)",null,"HAB. NEUF","CO","Traité","2009-09-01",10000,10000,7000,3000,350,150]
["Opération B * (2)",null,"OF NEUF","PU",0.8,"2009-09-02",8000,8000,6000,2000,120,40]
["-----------"]
[]
[]
["Total  PC Septembre 2016",null,null,null,null,null,18000,18000,13000,5000,470,190,0,0,0,0]
["TOTAL  Trim. 3",null,null,null,null,null,18000,18000,13000,5000,470,190,0,0,0,0]
[]
["Opération C"]
["-----------"]
["Total  PC Octobre 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[]
["Opération D"]
["-----------"]
["Total  PC Novembre 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[]
["Opération E"]
["-----------"]
[]
[]
[]
["Total  PC Décembre 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["TOTAL  Trim. 4",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["TOTAL  ISSU DE LA PC 2016",null,null,null,null,null,18000,18000,13000,5000,470,190,0,0,0,0]
[]
["TOTAL PRODUCTION 2016",null,null,null,null,null,18000,18000,13000,5000,470,190,0,0,0,0]
["ALEAS",null,null,null,null,null,null,-10000,-7000,-3000,-350,-150]
["ACTUALISATION OCTOBRE 2016",null,null,null,null,null,null,8000,6000,2000,120,40]
[]
["Rappel ACTUA JUIN 2015"]
["Rappel PLAN 2016"]
[]
[]
["Rappel REALISE 2015"]
[]
["*(1) Affaire neutralisée par l'aléa DP "]
["*(2) Affaire neutralisée par l'aléa DG  "]
[]
[null,"Décomposition de la PC par nature juridique du client :"]
[]
[null,"Etat (ET)","ET",0]
[null,"Collectivités territoriales (CO)","CO",10000]
[null,"Entreprises publiques (PU)","PU",8000]
[null,"Entreprises Privées (PR)","PR",0]
[null,"Total hors aléas :",null,18000]

{"sheet":"Feuil3","index":2,"n_rows":93,"n_cols":16,"rows_kept":93,"cut":false,"hidden":false,"merged":[[2,7,2,9],[3,0,3,11],[4,0,4,11],[8,12,8,15],[9,0,9,11],[9,12,9,15],[11,2,11,7],[11,8,11,9],[11,10,11,11],[11,12,11,13],[11,14,11,15],[12,14,13,14],[12,15,13,15],[86,1,86,3],[12,8,13,8],[12,9,13,9],[12,10,13,10],[12,11,13,11],[12,12,13,12],[12,13,13,13],[12,2,13,2],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6]]}
["ENTREPRISES FRANCE EUROPE"]
["SOCIÉTÉ :"]
["DATE :"]
["1 - PRÉVISIONS  2016  PC - ACTIVITE - MARGES"]
["ACTUALISATION OCTOBRE 2016"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"FACULTATIF : POUR BOUCALGE"]
["DIR.  PRODUCTION : exemple3",null,null,null,null,null,null,null,null,null,null,null,"NE PAS L'EDITER DANS LA BROCHURE"]
["En K€ ou KCHF"]
[null,null,"COMMANDES",null,null,null,null,null,"ACTIVITÉ",null,"MARGES",null,"ACTIVITÉ",null,"MARGES"]
["AFFAIRES",null,"Nature d'ouvrage"," Clt ","Coef. Commer-cial","Date","Montant affaire pour la filiale","Montant ",2016,2017,2016,2017,"AU DELA","FINALE","AU DELA","FINALE"]
[null,null,null,null,null,null,null,"retenu"]
["EN COURS AU 01/01/2016",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Variation 2016 des en cours",null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,".","HAB. NEUF","PR",null,null,null,null,null,null,null,null,null,0,null,0]
[null,".","OF NEUF","ET",null,null,null,null,null,null,null,null,null,0,null,0]
[null,".",null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["EN COURS AU 01/01/2016 corrigés",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[]
[]
["Total  PC Janvier 2016"]
["Total  PC Février 2016"]
[]
["Opération A"]
["Opération B"]
["-----------"]
[]
[]
["Total  PC Mars 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["TOTAL  Trim. 1",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[]
["Total  PC Avril 2016"]
["Total  PC Mai 2016"]
[]
["Opération A"]
["Opération B"]
["-----------"]
[]
[]
["Total  PC Juin 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["TOTAL  Trim. 2",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["TOTAL 1er Semestre 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["Total  PC Juillet 2016"]
["Total  PC Août 2016"]
[]
["Opération A * (1)",null,"HAB. NEUF","CO","Traité","2009-09-01",10000,10000,7000,3000,350,150]
["Opération B * (2)",null,"OF NEUF","PU",0.8,"2009-09-02",8000,8000,6000,2000,120,40]
["-----------"]
[]
[]
["Total  PC Septembre 2016",null,null,null,null,null,18000,18000,13000,5000,470,190,0,0,0,0]
["TOTAL  Trim. 3",null,null,null,null,null,18000,18000,13000,5000,470,190,0,0,0,0]
[]
["Opération C"]
["-----------"]
["Total  PC Octobre 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[]
["Opération D"]
["-----------"]
["Total  PC Novembre 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[]
["Opération E"]
["-----------"]
[]
[]
[]
["Total  PC Décembre 2016",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["TOTAL  Trim. 4",null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["TOTAL  ISSU DE LA PC 2016",null,null,null,null,null,18000,18000,13000,5000,470,190,0,0,0,0]
[]
["TOTAL PRODUCTION 2016",null,null,null,null,null,18000,18000,13000,5000,470,190,0,0,0,0]
["ALEAS",null,null,null,null,null,null,-10000,-7000,-3000,-350,-150]
["ACTUALISATION OCTOBRE 2016",null,null,null,null,null,null,8000,6000,2000,120,40]
[]
["Rappel ACTUA JUIN 2015"]
["Rappel PLAN 2016"]
[]
[]
["Rappel REALISE 2015"]
[]
["*(1) Affaire neutralisée par l'aléa DP "]
["*(2) Affaire neutralisée par l'aléa DG  "]
[]
[null,"Décomposition de la PC par nature juridique du client :"]
[]
[null,"Etat (ET)","ET",0]
[null,"Collectivités territoriales (CO)","CO",10000]
[null,"Entreprises publiques (PU)","PU",8000]
[null,"Entreprises Privées (PR)","PR",0]
[null,"Total hors aléas :",null,18000]