{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Accueil","Feuil test","Indicateurs de pilotage","Etat des ventes","Analyses CA","Analyses APCO","Détail CA 2015","Mensualisation CA BU 2015","Table ref client","Table de ref compte compta","Mensualisation APCO BU 2015","Détail APCO 2015","Détail expat","Balance agée","Base de données","Contrôle","Expatriés"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":17,"comments":3,"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":"Accueil","index":0,"n_rows":172,"n_cols":15,"rows_kept":172,"cut":false,"hidden":false,"merged":[[0,0,0,2],[3,0,3,4],[1,0,2,4]]}
[null,null,null,null,null,null,null,null,null,null,"JANVIER"]
["ANNEE 2016",null,null,null,null,null,null,null,null,null,"FEVRIER"]
[null,null,null,null,null,null,null,null,null,null,"MARS"]
["TABLEAU DE BORD Ventes DPCG A FIN  :",null,null,null,null,"JANVIER",null,null,null,null,"AVRIL"]
[null,null,null,null,null,null,null,null,null,null,"MAI"]
[null,null,null,null,null,null,null,null,null,null,"JUILLET"]
[null,null,null,"Pilotage",null,null,null,null,null,null,"AOUT","AOUT"]
[null,null,null,null,null,null,null,null,null,null,"SEPTEMBRE","SEPTEMBRE"]
[null,null,null,"Suivi des Ventes ",null,null,null,null,null,null,"OCTOBRE"]
[null,null,null,null,null,null,null,null,null,null,"NOVEMBRE"]
[null,null,null,"Analyse CA vs BU",null,null,null,null,null,null,"DECEMBRE","DECEMBRE"]
[]
[null,null,null,"Analyse APCO vs BU"]
[]
[null,null,null,"Balance agée"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"AOÛT"]
[]
[]
[]
[null,null,null,"JANVIER","FEVRIER","MARS","AVRIL","MAI","JUIN","JUILLET",null,"SEPTEMBRE","OCTOBRE","NOVEMBRE","DÉCEMBRE"]

{"sheet":"Feuil test","index":1,"n_rows":141,"n_cols":45,"rows_kept":141,"cut":false,"hidden":true,"merged":[[135,0,137,0],[138,0,140,0],[1,9,1,10],[1,8,2,8],[0,0,2,0],[0,1,2,1],[0,4,2,4],[0,5,2,5],[0,8,0,11],[1,11,2,11],[0,2,2,2],[0,3,2,3],[0,6,2,6],[0,7,2,7],[0,27,0,29],[0,30,0,32],[1,15,2,15],[1,16,1,17],[1,18,2,18],[1,19,1,20],[1,21,2,21],[1,22,1,23],[1,24,2,24],[0,21,0,23],[1,27,2,27],[1,28,1,29],[1,30,2,30],[1,31,1,32],[0,15,0,17],[0,18,0,20],[1,25,1,26],[0,24,0,26],[0,12,0,14],[1,12,2,12],[1,13,1,14],[0,42,0,44],[1,39,2,39],[1,40,1,41],[1,42,2,42],[1,43,1,44],[0,39,0,41],[0,36,0,38],[1,33,2,33],[1,34,1,35],[1,36,2,36],[1,37,1,38],[0,33,0,35]]}
["Périmètre ","Type de ventes ","Client","Code client","CCS","Libellé","Total BU","Total réalisé","janvier",null,null,null,"février",null,null,"mars",null,null,"avril",null,null,"mai",null,null,"juin",null,null,"juillet",null,null,"août",null,null,"septembre",null,null,"octobre",null,null,"novembre",null,null,"décembre"]
[null,null,null,null,null,null,null,null,"BU","Réalisé",null,"Ecart","BU","Réalisé",null,"BU","Réalisé",null,"BU","Réalisé",null,"BU","Réalisé",null,"BU","Réalisé",null,"BU","Réalisé",null,"BU","Réalisé",null,"BU","Réalisé",null,"BU","Réalisé",null,"BU","Réalisé",null,"BU","Réalisé"]
[null,null,null,null,null,null,null,null,null,"Facture","PAR",null,null,"Facture","PAR",null,"Facture","PAR",null,"Facture","PAR",null,"Facture","PAR",null,"Facture","PAR",null,"Facture","PAR",null,"Facture","PAR",null,"Facture","PAR",null,"Facture","PAR",null,"Facture","PAR",null,"Facture","PAR"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["EM","Montant des factures à recouvrir                                                     TOTAL",null,null,null,null,null,null,3817832.4,null,null,null,3660488.15,null,null,4239148.4400000004,null,5224120,null,5361428.0599999996,null,5926617]
[null,"Dont à +90 jrs",null,null,null,null,null,null,611182.17000000004,null,null,null,1181031,null,null,1305394.44,null,1171174,null,815699.85,null,1318364]
[null,"dont à +180 jrs",null,null,null,null,null,null,1331476.1299999999,null,null,null,1580631,null,null,1606646.92,null,1823939,null,2036762.28,null,2194094]
["EM","Montant des factures à recouvrir     en  %"]
[null,"Dont à +90 jrs (objectif 50%)",null,null,null,null,null,null,{"$f":"I137/I136","v":0.16008617088586707},null,null,null,0.32264303327959143,null,null,0.30793789330009869,null,0.22418589159513946,null,0.15214227270635056,null,0.22244798339423655]
[null,"dont à +180 jrs (objectif 30 %)",null,null,null,null,null,null,{"$f":"I138/I136","v":0.3487518545863878},null,null,null,0.43180880123870913,null,null,0.37900227905206352,null,0.34913803664540632,null,0.37989174846822438,null,0.37021018905051567]

{"sheet":"Indicateurs de pilotage","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[2,0,26,0],[26,1,26,3],[66,21,66,22],[76,16,76,17],[77,16,77,17],[57,21,57,22],[58,21,58,22],[59,21,59,22],[60,21,60,22],[70,16,70,17],[71,16,71,17],[72,16,72,17],[73,16,73,17],[74,16,74,17],[75,16,75,17],[64,16,64,17],[65,16,65,17],[66,16,66,17],[67,16,67,17],[68,16,68,17],[61,21,61,22],[62,21,62,22],[63,21,63,22],[64,21,64,22],[0,9,0,13],[0,4,0,8],[79,21,79,22],[80,21,80,22],[0,59,0,63],[0,54,0,58],[0,49,0,53],[0,44,0,48],[0,39,0,43],[0,34,0,38],[0,29,0,33],[0,24,0,28],[73,21,73,22],[74,21,74,22],[75,21,75,22],[76,21,76,22],[77,21,77,22],[78,21,78,22],[67,21,67,22],[68,21,68,22],[79,16,79,17],[80,16,80,17],[56,21,56,22],[69,21,69,22],[65,21,65,22],[80,6,80,7],[74,6,74,7],[75,6,75,7],[79,11,79,12],[80,11,80,12],[74,11,74,12],[75,11,75,12],[76,11,76,12],[77,11,77,12],[78,11,78,12],[78,16,78,17],[70,21,70,22],[71,21,71,22],[72,21,72,22],[56,16,56,17],[57,16,57,17],[58,16,58,17],[59,16,59,17],[60,16,60,17],[61,16,61,17],[62,16,62,17],[63,16,63,17],[73,11,73,12],[67,11,67,12],[68,11,68,12],[69,11,69,12],[70,11,70,12],[71,11,71,12],[69,16,69,17],[59,6,59,7],[63,11,63,12],[64,11,64,12],[65,11,65,12],[66,11,66,12],[76,6,76,7],[77,6,77,7],[78,6,78,7],[79,6,79,7],[72,11,72,12],[61,11,61,12],[62,11,62,12],[31,0,80,0],[54,21,54,22],[61,2,63,2],[64,2,67,2],[68,1,68,3],[57,1,67,1],[69,1,79,1],[60,6,60,7],[61,6,61,7],[62,6,62,7],[63,6,63,7],[48,21,48,22],[49,21,49,22],[50,21,50,22],[51,21,51,22],[52,21,52,22],[53,21,53,22],[42,21,42,22],[43,21,43,22],[44,21,44,22],[56,11,56,12],[57,11,57,12],[58,11,58,12],[59,11,59,12],[47,21,47,22],[36,21,36,22],[37,21,37,22],[38,21,38,22],[39,21,39,22],[40,21,40,22],[41,21,41,22],[80,1,80,3],[69,2,72,2],[73,2,75,2],[76,2,79,2],[60,11,60,12],[70,6,70,7],[71,6,71,7],[72,6,72,7],[73,6,73,7],[64,6,64,7],[65,6,65,7],[66,6,66,7],[67,6,67,7],[68,6,68,7],[69,6,69,7],[56,6,56,7],[57,6,57,7],[51,16,51,17],[52,16,52,17],[53,16,53,17],[54,16,54,17],[30,21,30,22],[31,21,31,22],[32,21,32,22],[33,21,33,22],[34,21,34,22],[35,21,35,22],[45,16,45,17],[46,16,46,17],[47,16,47,17],[48,16,48,17],[49,16,49,17],[50,16,50,17],[39,16,39,17],[40,16,40,17],[41,16,41,17],[42,16,42,17],[43,16,43,17],[44,16,44,17],[45,21,45,22],[46,21,46,22],[54,11,54,12],[30,16,30,17],[31,16,31,17],[32,16,32,17],[33,16,33,17],[34,16,34,17],[35,16,35,17],[36,16,36,17],[37,16,37,17],[38,16,38,17],[48,11,48,12],[49,11,49,12],[50,11,50,12],[51,11,51,12],[52,11,52,12],[53,11,53,12],[42,11,42,12],[43,11,43,12],[44,11,44,12],[45,11,45,12],[46,11,46,12],[47,11,47,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[39,11,39,12],[40,11,40,12],[41,11,41,12],[30,11,30,12],[31,11,31,12],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[53,6,53,7],[54,6,54,7],[58,6,58,7],[44,6,44,7],[45,6,45,7],[46,6,46,7],[47,6,47,7],[48,6,48,7],[49,6,49,7],[40,6,40,7],[41,6,41,7],[42,6,42,7],[43,6,43,7],[54,1,54,3],[30,6,30,7],[31,6,31,7],[32,6,32,7],[33,6,33,7],[34,6,34,7],[35,6,35,7],[36,6,36,7],[37,6,37,7],[31,2,34,2],[35,2,37,2],[38,2,41,2],[42,1,42,3],[43,1,53,1],[43,2,46,2],[47,2,49,2],[50,2,53,2],[50,6,50,7],[51,6,51,7],[52,6,52,7],[97,0,98,0],[29,19,29,22],[0,64,0,66],[0,19,0,23],[0,14,0,18],[29,4,29,7],[29,9,29,12],[29,14,29,17],[93,0,94,0],[86,0,90,0],[2,1,12,1],[14,2,17,2],[18,2,20,2],[21,2,24,2],[14,1,24,1],[57,2,60,2],[2,2,5,2],[6,2,8,2],[9,2,12,2],[13,1,13,3],[25,1,25,3],[31,1,41,1],[38,6,38,7],[39,6,39,7]]}

{"sheet":"Etat des ventes","index":3,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,7],[5,0,5,2]]}
["SUIVI DES VENTES 2016 - Total Direction de Siège"]
[]
[null,null,null,"Valeurs"]
["Thème","Nature","Client"," Factures attendues"," Factures réalisées"," Reste à facturer"," Prévision budgétaire"," Montant réalisé","Somme de Ecarts"]
["Ventes liées aux prestations du siège",null,null,2,0,2]
["Total général",null,null,2,0,2]

{"sheet":"Analyses CA","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Analyses APCO","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Détail CA 2015","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Mensualisation CA BU 2015","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Table ref client","index":8,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Client","Nom 1","Rue","Pays","Code postal","Localité","Pays 2"]

{"sheet":"Table de ref compte compta","index":9,"n_rows":77,"n_cols":5,"rows_kept":77,"cut":false,"hidden":true,"merged":[]}
["Compte ","Libellé","Nature","Nature 2"]
[705100,"PREST MISSION ETUDE DELEGATION OUTREMER,","Conseils Audit","Divers "]
[706400,"PREST SCES A L'ETRANGER","Refact Pers","Refacturation des expatriés "]
[706820,"PRESTATIONS ENTRE LES SOCIETES DU GROUPE","FUSAC","Refacturation des Dir° d'expertise sur Projets "]
[706821,"PRESTATIONS A SOCIETES FILIALES ETABLIES","Refact Pers","Refacturation des expatriés "]
[706880,"AUTRES PRESTATIONS","Divers ","Divers ","Si K949100 alors prestations de siege eRDF - Si K939FF alors Fusac."]
[708300,"LOGEMENTS - LOYERS","Loyers","Divers "]
[708301,"LOGEMENTS - CHARGES LOCATIVES","Loyers","Divers "]
[708308,"LOCATIONS IMMOBILIER TERTIAIRE ET AUTRES","Loyers","Divers "]
[708380,"AUTRES LOCATIONS DIVERSES","Loyers","Divers "]
[708400,"MISE A DISPOSITION DE PERSONNEL FACTUREE","Refact Pers","Refacturation des expatriés "]
[708820,"PRESTATIONS AUTRES QU'IMMOBILIER FACT A","Divers ","Divers "]
[708880,"DIVERS PRODUITS DES ACTIVITES ANNEXES","Divers ","Divers "]
[708999,"LOYERS FACTURES NSIL INTERNE","Loyers","Divers "]
[709999,"RECETTES DU DPD -PRIMES-INDEMNITES KILOM","Loyers","Divers "]
[871106,null,"Loyers","Divers "]
[887081,"COE-EMA-IMMOBILIER-LOYERS ET AUTRES PROD","Loyers","Divers "]
[651200,"ACHATS DE DROITS D' UTILISATION DE LOGIC","Droit d'auteur /Licence logiciel","Autres"]
[651300,"REDEVANCES POUR UTILISATION DE LOGICIELS","Droit d'auteur /Licence logiciel","Autres"]
[651600,"DROITS D'AUTEUR ET DE REPRODUCTION","Droit d'auteur /Licence logiciel","Autres"]
[656211,"SUBVENTIONS DIRECTES","Subvention"]
[657110,"VNC DES IMMOBILISATIONS TERMINEES DEMOLI","Valeur Nette comptable sur Materiel"]
[656500,null,"Autres"]
[658400,"ACHATS,LOCATIONS & INDEMNITES(DRAPEAUX,.","Autres"]
[658811,"ECARTS SUR DETTES PROVISIONNEES (SAP)","Autres"]
[658830,"AN - Indemnités versées aux ELD, GDF ou","Autres"]
[658840,"FRAIS DE GESTION PLAN EPARGNE ENTREPRISE","Autres"]
[658880,"CHARGES DIVERSES DE GESTION COURANTE","Autres"]
[658920,"IRREC. (HORS CLIENTS) - TAXES NON RECUPE","Autres"]
[658930,"PENALITES ET AMENDES FISCALES ET PARAFIS","Autres"]
[658961,"COTIS IVD AG DETACH EXCPT PRIS EN CHARGE","Refact Pers"]
[658962,"COTIS IVD AG DETACH EXCPT PRIS EN CHARGE","Refact Pers"]
[658980,"CHARGES D'EXPLOI COURANTES INHABITUELLES","Autres"]
[659999,"COUTS DES AUTRES CHARGES DE GEST.COURAN","Ch DPD"]
[681721,"DOT AUX PROV DEPREC  AUTRES FRN DEBITEUR","Autres"]
[681748,"DOT. PROV. DEPREC. CLIENTS SAP VENTES DI","Prov creances douteuses"]
[681749,"DOT PROV DEPREC-AUTRES DEBITEURS DIVERS","Prov creances douteuses"]
[741000,"SUBVENTION PUBLIQUE D'EXPLOITATION","Subvention"]
[751000,"REDEV POUR CONCESSIONS ET DROITS SIMILAI","Redevances de marque"]
[753000,"JETONS PRESENCE & REMUNERATIONS ADMINIST","Jeton de Présence"]
[758440,"REMB FRAIS DE PERSONNEL","Refact Pers","Si K939HB en face, cela peut etre aide a l'apprentissage ou à l'embauche"]
[758450,"REMB FRAIS DE FORMATION PROFESSIONNELLE","Autres"]
[758480,null,"Autres"]
[758880,"DIVERS - AUTRES PRODUITS DIVERS","Autres"]
[758980,"AUTRES PRODUITS DIVERS","Autres"]
[759999,"AUTRES PRODUITS DE GESTION COURANTE DU D","Jeton de Présence"]
[775200,"IMMO CORPOR-ACTIF INDIVIDUALISE","Autres"]
[777000,"QP SUBVENT INVESTISST VIREES AU RESULTAT","Autres"]
[781501,"REP PROV RISQ ET GARANTIE DONNEE-RISQ LI","Reprise prov pour risque"]
[791440,"INDEMNITES SUITE A SINISTRES","Autres"]
[791460,"REMBOURSEMENTS DE L'AGEFOS PME","AGEFOS"]
[791470,"REMBOURSEMENTS DE FRAIS DE PERSONNEL","Refact Pers"]
[791480,"DEBOURS DIVERS POUR LE COMPTE DE TIERS","Autres"]
[886581,"COUT DU TARIF ELECTRIQUE AGENT","Tarif agent"]
[781501,null,"REP PROV RISQ ET GARANTIE "]
[]
[]
["AMADOE","AMADOE"]
["Droit d'auteur /Licence logiciel","Autres"]
["Autres","Autres"]
["Ch DPD","Autres"]
["Prov creances douteuses","Autres"]
["Refact Pers","Autres"]
["Subvention","Autres"]
["Valeur Nette comptable sur Materiel","Autres"]
["Tarif agent","Tarif agent"]
["AMADOE","AMADOE"]
["AGEFOS","Autres"]
["Aide à l'apprentissage","Autres"]
["Aide à l'embauche","Autres"]
["Autres","Autres"]
["CAP > 24 MOIS","Autres"]
["Gestion des cadres dirigeants mixtes GRDF","Autres"]
["Refact Pers","Autres"]
["Reprise prov pour risque","Autres"]
["Jeton de Présence","Jeton de Présence"]
["Redevances de marque","Redevances de marque"]

{"sheet":"Mensualisation APCO BU 2015","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Détail APCO 2015","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Détail expat","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Balance agée","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Base de données","index":14,"n_rows":3,"n_cols":25,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
["N° de document","Type","Client","Code client ","Montant réalisé","Nature","Thème","Processus de facturation","CCS","Exercice Concerné","Période","Date de la facturation\njj/mm/aa","N° pièce d'encaissement","Contrôleur de Gestion","Périmetre","A fait l'objet d'un produit à recevoir","Commentaire\nDescription","Prévision budgétaire","Factures attendues","Avoirs attendus","Factures réalisées","Avoirs réalisées","Reste à facturer","Montants 2015","Ecarts"]

{"sheet":"Contrôle","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Expatriés","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}