{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Tableau de bord","Détails ventes","Analyse Vendeurs","Analyse Véhicules","Formules"],"not_rendered":{"charts":9,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":19},"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":"Tableau de bord","index":0,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,10,5,10],[0,0,1,10],[4,0,5,2],[4,3,5,4],[19,0,20,2],[19,3,20,4],[4,7,5,9]]}
["MON TABLEAU DE BORD VO"]
[]
[]
[]
[null,null,null,null,null,null,null,"FINANCEMENT"]

{"sheet":"Détails ventes","index":1,"n_rows":403,"n_cols":30,"rows_kept":403,"cut":false,"hidden":false,"merged":[[5,13,5,20],[5,0,5,12],[0,0,1,29],[3,3,3,5],[3,8,3,10],[3,13,3,15]]}
["TABLEAU DE BORD VO COMPLET"]
[]
[]
[null,{"$f":"TODAY()","v":"2016-03-04"},null,"OBJECTIF VOLUME",null,null,null,null,"OBJECTIF FINANCEMENT",null,null,null,null,"OBJECTIF MARGE"]
[]
["VEHICULE",null,null,null,null,null,null,null,null,null,null,null,null,"€"]
["N° VO","IMMAT'","1ère MEC","Age VO                             (nombre année-mois)","MARQUE","MODELE","FINITION","MOTEUR","CAROSSERIE","ENERGIE","BOITE","KM","COULEUR","PRIX D'ACHAT","PRIX AFFICHE","PRIX FACTURE","REMISE","FRE (en HT)","FRE ESTIME (en €TTC)","DIFFERENCE FRE (en HT)","MARGE BRUTE","VENDEUR","REPRENEUR","PROVENANCE VEHICULE","Date d'entrée en stock","Date de Facturation","Nombre de jours de stock","Financement","Montant Financé","PRESTA"]
[null,null,null,{"$f":"IF(C8=\"\",\"\",TODAY()-C8)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O8-P8","v":0},null,null,{"$f":"(S8/1.2)-R8","v":0},{"$f":"((P8-N8)/1.2)-R8","v":0},null,null,null,null,null,{"$f":"Z8-Y8","v":0}]
[null,null,null,{"$f":"IF(C9=\"\",\"\",TODAY()-C9)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O9-P9","v":0},null,null,{"$f":"(S9/1.2)-R9","v":0},{"$f":"((P9-N9)/1.2)-R9","v":0},null,null,null,null,null,{"$f":"Z9-Y9","v":0}]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C73=\"\",\"\",TODAY()-C73)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O73-P73","v":0},null,null,{"$f":"(S73/1.2)-R73","v":0},{"$f":"((P73-N73)/1.2)-R73","v":0},null,null,null,null,null,{"$f":"Z73-Y73","v":0}]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C137=\"\",\"\",TODAY()-C137)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O137-P137","v":0},null,null,{"$f":"(S137/1.2)-R137","v":0},{"$f":"((P137-N137)/1.2)-R137","v":0},null,null,null,null,null,{"$f":"Z137-Y137","v":0}]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C201=\"\",\"\",TODAY()-C201)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O201-P201","v":0},null,null,{"$f":"(S201/1.2)-R201","v":0},{"$f":"((P201-N201)/1.2)-R201","v":0},null,null,null,null,null,{"$f":"Z201-Y201","v":0}]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C265=\"\",\"\",TODAY()-C265)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O265-P265","v":0},null,null,{"$f":"(S265/1.2)-R265","v":0},{"$f":"((P265-N265)/1.2)-R265","v":0},null,null,null,null,null,{"$f":"Z265-Y265","v":0}]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(C329=\"\",\"\",TODAY()-C329)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O329-P329","v":0},null,null,{"$f":"(S329/1.2)-R329","v":0},{"$f":"((P329-N329)/1.2)-R329","v":0},null,null,null,null,null,{"$f":"Z329-Y329","v":0}]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,"ss",null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,"BDG",null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,"HDG",null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,"MDG",null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,108,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,"ion",null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,208,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,2008,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,308,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,3008,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,508,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,5008,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,"Premium"]
[null,null,null,"",null,4008,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,"Primo"]
[null,null,null,{"$f":"IF(C393=\"\",\"\",TODAY()-C393)","v":""},null,"Bipper",null,null,null,null,null,null,null,null,null,null,{"$f":"O393-P393","v":0},null,null,{"$f":"(S393/1.2)-R393","v":0},{"$f":"((P393-N393)/1.2)-R393","v":0},null,null,null,null,null,{"$f":"Z393-Y393","v":0},"PP"]
[null,null,null,"",null,"Partner",null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,"50/50"]
[null,null,null,{"$f":"IF(C395=\"\",\"\",TODAY()-C395)","v":""},null,"Expert",null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,"Pack ODL"]
[null,null,null,"",null,"Boxer",null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0,"Pro"]
[null,null,null,"",null,"308sw",null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,"508sw",null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,null,0]
[null,null,null,"",null,207,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,"Guillaume","Joseph",null,null,null,0]
[null,null,null,"",null,207,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,"Beunard","Guillaume",null,null,null,0]
[null,null,null,"",null,107,null,null,"Automatique",null,null,null,null,null,null,null,0,null,null,0,0,"Briand","Leandre",null,null,null,0]
[null,null,null,"",null,"206+",null,null,"Mecanique",null,null,null,null,null,null,null,0,null,null,0,0,"Joseph","Beunard",null,null,null,0]
[null,null,null,{"$f":"IF(C403=\"\",\"\",TODAY()-C403)","v":""},null,"207sw",null,null,"Pilotee",null,null,null,null,null,null,null,0,null,null,0,0,"Leandre","Briand",null,null,null,0]

{"sheet":"Analyse Vendeurs","index":2,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[[12,0,13,0],[12,9,12,10],[12,11,12,12],[0,2,0,12],[12,13,12,16],[10,1,10,14],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8]]}
[null,null,"ANALYSE DES RESULTATS VO PAR VENDEURS"]
[]
[null,null,"Vendeurs","Nombre de VOP vendues","Nombre de reprise client","Delta moyen entre FRE estimé et les FRE réels","Remise moyenne","Durée moyenne des reprises en stock","Nombre de Financement","% de Financement","Montant Financé","Dossier Moyen","Montant de Financement à la VO","MARGE MOYENNE DES REPRISES"]
[null,null,"Léandre",{"$f":"GETPIVOTDATA(\"MARQUE\",Formules!$K$2,\"VENDEUR\",\"Leandre\")","v":0},{"$f":"COUNTIF('Détails ventes'!W8:W398,\"leandre\")","v":0},{"$f":"GETPIVOTDATA(\"DIFFERENCE FRE (en HT)\",Formules!$K$110,\"REPRENEUR\",\"Leandre\")","v":0},{"$f":"GETPIVOTDATA(\"REMISE\",Formules!$A$14,\"VENDEUR\",\"Leandre\")","v":0},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$H$3,\"REPRENEUR\",\"Leandre\")","v":0},{"$f":"GETPIVOTDATA(\"Financement\",Formules!$A$133,\"VENDEUR\",\"Leandre\")","v":0},{"$f":"I4/D4","v":{"$error":"#DIV/0!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$A$34,\"VENDEUR\",\"Leandre\")","v":0},{"$f":"K4/I4","v":{"$error":"#DIV/0!"}},{"$f":"K4/D4","v":{"$error":"#DIV/0!"}},{"$f":"GETPIVOTDATA(\"MARGE BRUTE\",Formules!$A$53,\"REPRENEUR\",\"Leandre\")","v":0}]
[null,null,"Joseph",{"$f":"GETPIVOTDATA(\"MARQUE\",Formules!$K$2,\"VENDEUR\",\"Joseph\")","v":0},{"$f":"COUNTIF('Détails ventes'!W8:W398,\"joseph\")","v":0},{"$f":"GETPIVOTDATA(\"DIFFERENCE FRE (en HT)\",Formules!$K$110,\"REPRENEUR\",\"Joseph\")","v":0},{"$f":"GETPIVOTDATA(\"REMISE\",Formules!$A$14,\"VENDEUR\",\"Joseph\")","v":0},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$H$3,\"REPRENEUR\",\"Joseph\")","v":0},{"$f":"GETPIVOTDATA(\"Financement\",Formules!$A$133,\"VENDEUR\",\"Joseph\")","v":0},{"$error":"#DIV/0!"},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$A$34,\"VENDEUR\",\"Joseph\")","v":0},{"$f":"K5/I5","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"GETPIVOTDATA(\"MARGE BRUTE\",Formules!$A$53,\"REPRENEUR\",\"Joseph\")","v":0}]
[null,null,"Guillaume",{"$f":"GETPIVOTDATA(\"MARQUE\",Formules!$K$2,\"VENDEUR\",\"Guillaume\")","v":0},{"$f":"COUNTIF('Détails ventes'!W8:W398,\"guillaume\")","v":0},{"$f":"GETPIVOTDATA(\"DIFFERENCE FRE (en HT)\",Formules!$K$110,\"REPRENEUR\",\"Guillaume\")","v":0},{"$f":"GETPIVOTDATA(\"REMISE\",Formules!$A$14,\"VENDEUR\",\"Guillaume\")","v":0},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$H$3,\"REPRENEUR\",\"Guillaume\")","v":0},{"$f":"GETPIVOTDATA(\"Financement\",Formules!$A$133,\"VENDEUR\",\"Guillaume\")","v":0},{"$error":"#DIV/0!"},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$A$34,\"VENDEUR\",\"Guillaume\")","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"GETPIVOTDATA(\"MARGE BRUTE\",Formules!$A$53,\"REPRENEUR\",\"Guillaume\")","v":0}]
[null,null,"P.BEUNARD",{"$f":"GETPIVOTDATA(\"MARQUE\",Formules!$K$2,\"VENDEUR\",\"Beunard\")","v":0},{"$f":"COUNTIF('Détails ventes'!W8:W398,\"beunard\")","v":0},{"$f":"GETPIVOTDATA(\"DIFFERENCE FRE (en HT)\",Formules!$K$110,\"REPRENEUR\",\"Beunard\")","v":0},{"$f":"GETPIVOTDATA(\"REMISE\",Formules!$A$14,\"VENDEUR\",\"Beunard\")","v":0},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$H$3,\"REPRENEUR\",\"Beunard\")","v":0},{"$f":"GETPIVOTDATA(\"Financement\",Formules!$A$133,\"VENDEUR\",\"Beunard\")","v":0},{"$error":"#DIV/0!"},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$A$34,\"VENDEUR\",\"Beunard\")","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"GETPIVOTDATA(\"MARGE BRUTE\",Formules!$A$53,\"REPRENEUR\",\"Beunard\")","v":0}]
[null,null,"P.BRIAND",{"$f":"GETPIVOTDATA(\"MARQUE\",Formules!$K$2,\"VENDEUR\",\"Briand\")","v":0},{"$f":"COUNTIF('Détails ventes'!W8:W398,\"briand\")","v":0},{"$f":"GETPIVOTDATA(\"DIFFERENCE FRE (en HT)\",Formules!$K$110,\"REPRENEUR\",\"Briand\")","v":0},{"$f":"GETPIVOTDATA(\"REMISE\",Formules!$A$14,\"VENDEUR\",\"Briand\")","v":0},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$H$3,\"REPRENEUR\",\"Briand\")","v":0},{"$f":"GETPIVOTDATA(\"Financement\",Formules!$A$133,\"VENDEUR\",\"Briand\")","v":0},{"$error":"#DIV/0!"},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$A$34,\"VENDEUR\",\"Briand\")","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"GETPIVOTDATA(\"MARGE BRUTE\",Formules!$A$53,\"REPRENEUR\",\"Briand\")","v":0}]
[null,null,"TOTAL",{"$f":"D4+D5+D6+D7+D8","v":0},null,{"$f":"(F4+F5+F6+F7+F8)/D9","v":{"$error":"#DIV/0!"}},{"$f":"(G4+G5+G6+G7+G8)/D9","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(I4:I8)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(K4:K8)","v":0},{"$f":"K9/I9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[null,"RESULTATS DES VENDEURS PAR PRODUITS DE FINANCEMENT ET PAR MONTANT"]
[]
[null,"PREMIUM",null,"PRIMO",null,"Peugeot Perspectives",null,"VAC Ballon",null,"Pack Garantie ODL",null,"VO PRO",null,"TOTAL"]
[null,"Nombre","€","Nombre","€","Nombre","€","Nombre","€","Nombre","€","Nombre","€","NOMBRE","%","€","%"]
["Léandre",{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Leandre\",\"Financement\",\"Premium\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Leandre\",\"Financement\",\"Premium\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Leandre\",\"Financement\",\"Primo\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Leandre\",\"Financement\",\"Primo\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Leandre\",\"Financement\",\"PP\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Leandre\",\"Financement\",\"PP\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Leandre\",\"Financement\",\"50/50\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Leandre\",\"Financement\",\"50/50\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Leandre\",\"Financement\",\"Pack ODL\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Leandre\",\"Financement\",\"Pack ODL\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Leandre\",\"Financement\",\"Pro\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Leandre\",\"Financement\",\"Pro\")","v":0},{"$f":"B15+D15+F15+H15+J15+L15","v":{"$error":"#REF!"}},{"$f":"N15/N20","v":{"$error":"#REF!"}},{"$f":"C15+E15+G15+I15+K15+M15","v":0},{"$f":"P15/P20","v":{"$error":"#DIV/0!"}}]
["Joseph",{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Joseph\",\"Financement\",\"Premium\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Joseph\",\"Financement\",\"Premium\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Joseph\",\"Financement\",\"Primo\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Joseph\",\"Financement\",\"Primo\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Joseph\",\"Financement\",\"PP\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Joseph\",\"Financement\",\"PP\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Joseph\",\"Financement\",\"50/50\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Joseph\",\"Financement\",\"50/50\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Joseph\",\"Financement\",\"Pack ODL\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Joseph\",\"Financement\",\"Pack ODL\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Joseph\",\"Financement\",\"Pro\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Joseph\",\"Financement\",\"Pro\")","v":0},{"$f":"B16+D16+F16+H16+J16+L16","v":{"$error":"#REF!"}},{"$f":"N16/N20","v":{"$error":"#REF!"}},{"$f":"C16+E16+G16+I16+K16+M16","v":0},{"$f":"P16/P20","v":{"$error":"#DIV/0!"}}]
["Guillaume",{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Guillaume\",\"Financement\",\"Premium\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Guillaume\",\"Financement\",\"Premium\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Guillaume\",\"Financement\",\"Primo\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Guillaume\",\"Financement\",\"Primo\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Guillaume\",\"Financement\",\"PP\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Guillaume\",\"Financement\",\"PP\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Guillaume\",\"Financement\",\"50/50\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Guillaume\",\"Financement\",\"50/50\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Guillaume\",\"Financement\",\"Pack ODL\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Guillaume\",\"Financement\",\"Pack ODL\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Guillaume\",\"Financement\",\"Pro\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Guillaume\",\"Financement\",\"Pro\")","v":0},{"$f":"B17+D17+F17+H17+J17+L17","v":{"$error":"#REF!"}},{"$f":"N17/N20","v":{"$error":"#REF!"}},0,{"$f":"P17/P20","v":{"$error":"#DIV/0!"}}]
["P.BEUNARD",{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Beunard\",\"Financement\",\"Premium\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Beunard\",\"Financement\",\"Premium\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Beunard\",\"Financement\",\"Primo\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Beunard\",\"Financement\",\"Primo\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Beunard\",\"Financement\",\"PP\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Beunard\",\"Financement\",\"PP\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Beunard\",\"Financement\",\"50/50\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Beunard\",\"Financement\",\"50/50\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Beunard\",\"Financement\",\"Pack ODL\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Beunard\",\"Financement\",\"Pack ODL\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Beunard\",\"Financement\",\"Pro\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Beunard\",\"Financement\",\"Pro\")","v":0},{"$f":"B18+D18+F18+H18+J18+L18","v":{"$error":"#REF!"}},{"$f":"N18/N20","v":{"$error":"#REF!"}},0,{"$f":"P18/P20","v":{"$error":"#DIV/0!"}}]
["P.BRIAND",{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Briand\",\"Financement\",\"Premium\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Briand\",\"Financement\",\"Premium\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Briand\",\"Financement\",\"Primo\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Briand\",\"Financement\",\"Primo\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Briand\",\"Financement\",\"PP\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Briand\",\"Financement\",\"PP\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Briand\",\"Financement\",\"50/50\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Briand\",\"Financement\",\"50/50\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Briand\",\"Financement\",\"Pack ODL\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Briand\",\"Financement\",\"50/50\")","v":0},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$21,\"VENDEUR\",\"Briand\",\"Financement\",\"Pro\")","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Montant Financé\",Formules!$E$31,\"VENDEUR\",\"Briand\",\"Financement\",\"Pro\")","v":0},{"$f":"B19+D19+F19+H19+J19+L19","v":{"$error":"#REF!"}},{"$f":"N19/N20","v":{"$error":"#REF!"}},0,{"$f":"P19/P20","v":{"$error":"#DIV/0!"}}]
["TOTAL",{"$f":"SUM(B15:B19)","v":{"$error":"#REF!"}},{"$f":"C15+C16+C17+C18+C19","v":0},{"$f":"SUM(D15:D19)","v":{"$error":"#REF!"}},{"$f":"E15+E16+E17+E18+E19","v":0},{"$f":"SUM(F15:F19)","v":{"$error":"#REF!"}},{"$f":"G15+G16+G17+G18+G19","v":0},{"$f":"SUM(H15:H19)","v":{"$error":"#REF!"}},{"$f":"I15+I16+I17+I18+I19","v":0},{"$f":"SUM(J15:J19)","v":{"$error":"#REF!"}},{"$f":"K15+K16+K17+K18+K19","v":0},{"$f":"L15+L16+L17+L18+L19","v":{"$error":"#REF!"}},{"$f":"M19+M18+M17+M16+M15","v":0},{"$f":"SUM(N15:N19)","v":{"$error":"#REF!"}},null,0,{"$f":"Q15+Q16+Q17+Q18+Q19","v":{"$error":"#DIV/0!"}}]

{"sheet":"Analyse Véhicules","index":3,"n_rows":25,"n_cols":36,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,1,8],[13,6,13,8],[6,6,6,8],[19,6,19,8],[14,1,17,1],[18,1,19,1],[6,0,6,4],[7,0,10,0],[11,0,17,0],[18,0,21,0],[7,1,8,1],[9,1,10,1],[11,1,13,1],[20,1,21,1],[5,5,6,5],[7,5,22,5],[0,27,1,39],[3,28,3,29],[3,30,3,35],[3,17,3,20],[3,21,3,26],[0,10,1,26],[3,13,3,16],[3,11,3,12]]}
["ANALYSE VENTE VO PARTICULIER",null,null,null,null,null,null,null,null,null,"ANALYSE DES VO PEUGEOT VENDUS A PARTICULIERS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANALYSE DES VO PEUGEOT VENDUS A PARTICULIERS"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"VOLUME",null,"ENERGIE",null,null,null,"GAMME",null,null,null,"BOITE",null,null,null,null,null,null,"VOLUME",null,"€"]
[null,null,null,null,null,null,null,null,null,null,"Modèle","NBRE","% des ventes","ESSENCE","%","DIESEL","%","BAS DE GAMME","MILIEU DE GAMME","HAUT DE GAMME","SERIE SPECIALE","MECA","%","PILOTEE","%","AUTO","%","Modèle","NBRE","% des ventes","PRIX ACHAT MOYEN         (en € TTC)","PRIX DE VENTE MOYEN       (en € TTC)","FRE MOYEN          (en € HT)","MARGE BRUTE MOYENNE       (en € HT)","MARGE BRUTE CUMULEE       (en € HT)","ROTATION MOYENNE     (en jours)"]
[null,null,null,null,null,"TOTAL VOP",null,null,null,null,"Ion",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"Ion\")","v":{"$error":"#REF!"}},{"$f":"L6/L25","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Ion\",\"FINITION\",\"BDG\")/'Analyse Véhicules'!L6","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Ion\",\"FINITION\",\"MDG\")/'Analyse Véhicules'!L6","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Ion\",\"FINITION\",\"HDG\")/'Analyse Véhicules'!L6","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Ion\",\"FINITION\",\"ss\")/'Analyse Véhicules'!L6","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"Ion\",\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$f":"V6/L6","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"Ion\",\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$f":"X6/L6","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"Ion\",\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$f":"Z6/L6","v":{"$error":"#REF!"}},"Ion",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"Ion\")","v":{"$error":"#REF!"}},{"$f":"AC6/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",\"ion\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",\"ion\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",\"ion\")","v":0},{"$f":"((AF6-AE6)/1.2)-AG6","v":0},{"$f":"AH6*AC6","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",\"ion\")/'Analyse Véhicules'!AC6","v":{"$error":"#REF!"}}]
["ANALYSE DES MARQUES VENDUES",null,null,null,null,null,"ORIGINE",null,null,null,107,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",107)","v":{"$error":"#REF!"}},{"$f":"L7/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",107,\"ENERGIE\",\"Essence\")","v":{"$error":"#REF!"}},{"$f":"N7/L7","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",107,\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$f":"P7/L7","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",107,\"FINITION\",\"BDG\")/'Analyse Véhicules'!L7","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",107,\"FINITION\",\"MDG\")/L7","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",107,\"FINITION\",\"HDG\")/L7","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",107,\"FINITION\",\"ss\")/L7","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",107,\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",107,\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$f":"X7/L7","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",107,\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},107,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",107)","v":{"$error":"#REF!"}},{"$f":"AC7/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",107)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",107)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",107)","v":0},{"$f":"((AF7-AE7)/1.2)-AG7","v":0},{"$f":"AH7*AC7","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",107)/'Analyse Véhicules'!AC7","v":{"$error":"#REF!"}}]
["FRANCAISE",{"$f":"D8+D9+D10+D11","v":0},"Peugeot",{"$f":"COUNTIF('Détails ventes'!E8:E403,\"peugeot\")","v":0},{"$f":"D8/F8","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D8:D23)","v":0},{"$f":"H8/F8","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Détails ventes'!X8:X403,\"svo\")","v":0},"SVO",null,108,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",108)","v":{"$error":"#REF!"}},{"$f":"L8/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",108,\"ENERGIE\",\"Essence\")","v":{"$error":"#REF!"}},{"$f":"N8/L8","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",108,\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$f":"P8/L8","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",108,\"FINITION\",\"BDG\")/L8","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",108,\"FINITION\",\"MDG\")/L8","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",108,\"FINITION\",\"HDG\")/L8","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",108,\"FINITION\",\"ss\")/L8","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",108,\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",108,\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$f":"X8/L8","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",108,\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},108,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",108)","v":{"$error":"#REF!"}},{"$f":"AC8/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",108)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",108)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",108)","v":0},0,{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",108)/'Analyse Véhicules'!AC8","v":{"$error":"#REF!"}}]
[null,null,"Citroen",{"$f":"COUNTIF('Détails ventes'!E8:E403,\"citroen\")","v":0},{"$f":"D9/F8","v":{"$error":"#DIV/0!"}},null,{"$f":"H9/F8","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Détails ventes'!X8:X403,\"reprise\")","v":0},"REPRISE",null,"206+",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"206+\")","v":{"$error":"#REF!"}},{"$f":"L9/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",\"206+\",\"ENERGIE\",\"Essence\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",\"206+\",\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"206+\",\"FINITION\",\"BDG\")/L9","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"206+\",\"FINITION\",\"MDG\")/L9","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"206+\",\"FINITION\",\"HDG\")/L9","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"206+\",\"FINITION\",\"SS\")/L9","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"206+\",\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"206+\",\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$f":"X9/L8","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"206+\",\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},"206+",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"206+\")","v":{"$error":"#REF!"}},{"$f":"AC9/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",\"206+\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",\"206+\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",\"206+\")","v":0},0,{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",\"206+\")/'Analyse Véhicules'!AC9","v":{"$error":"#REF!"}}]
[null,{"$f":"B8/F8","v":{"$error":"#DIV/0!"}},"Renault",{"$f":"COUNTIF('Détails ventes'!E8:E403,\"renault\")","v":0},{"$f":"D10/F8","v":{"$error":"#DIV/0!"}},null,{"$f":"H10/F8","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Détails ventes'!X8:X403,\"gvo\")","v":0},"GVO",null,207,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",207)","v":{"$error":"#REF!"}},{"$f":"L10/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",207,\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",207,\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",207,\"FINITION\",\"BDG\")/L10","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",207,\"FINITION\",\"MDG\")/L10","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",207,\"FINITION\",\"HDG\")/L10","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",207,\"FINITION\",\"SS\")/L10","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",207,\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",207,\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$f":"X10/L10","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",207,\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},207,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",207)","v":{"$error":"#REF!"}},{"$f":"AC10/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",207)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",207)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",207)","v":0},0,{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",207)/'Analyse Véhicules'!AC10","v":{"$error":"#REF!"}}]
[null,null,"Dacia",{"$f":"COUNTIF('Détails ventes'!E8:E403,\"dacia\")","v":0},{"$f":"D11/F8","v":{"$error":"#DIV/0!"}},null,{"$f":"H11/F8","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Détails ventes'!X8:X403,\"gemy\")","v":0},"Concession GEMY",null,"207SW",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"207sw\")","v":{"$error":"#REF!"}},{"$f":"L11/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",\"207sw\",\"ENERGIE\",\"Essence\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",\"207sw\",\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"207sw\",\"FINITION\",\"BDG\")/L11","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"207sw\",\"FINITION\",\"MDG\")/L11","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"207sw\",\"FINITION\",\"HDG\")/L11","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"207sw\",\"FINITION\",\"SS\")/L11","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"207sw\",\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"207sw\",\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"207sw\",\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},"207SW",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"207sw\")","v":{"$error":"#REF!"}},{"$f":"AC11/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",\"207sw\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",\"207sw\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",\"207sw\")","v":0},0,{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",\"207sw\")/'Analyse Véhicules'!AC11","v":{"$error":"#REF!"}}]
["EUROPEENNE",{"$f":"SUM(D12:D18)","v":0},"Ford",{"$f":"COUNTIF('Détails ventes'!E8:E403,\"ford\")","v":0},{"$f":"D12/F8","v":{"$error":"#DIV/0!"}},null,{"$f":"H12/F8","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Détails ventes'!X8:X403,\"bb\")","v":0},"Buy-back CREDIPAR",null,208,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",208)","v":{"$error":"#REF!"}},{"$f":"L12/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",208,\"ENERGIE\",\"Essence\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",208,\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",208,\"FINITION\",\"BDG\")/L12","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",208,\"FINITION\",\"MDG\")/L12","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",208,\"FINITION\",\"HDG\")/L12","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",208,\"FINITION\",\"SS\")/L12","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",208,\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",208,\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",208,\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},208,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",208)","v":{"$error":"#REF!"}},{"$f":"AC12/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",208)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",208)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",208)","v":0},0,{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",208)/'Analyse Véhicules'!AC12","v":{"$error":"#REF!"}}]
[null,null,"Volkswagen",{"$f":"COUNTIF('Détails ventes'!E8:E403,\"volkswagen\")","v":0},{"$f":"D13/F8","v":{"$error":"#DIV/0!"}},null,null,null,null,null,2008,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",2008)","v":{"$error":"#REF!"}},{"$f":"L13/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",2008,\"ENERGIE\",\"Essence\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",2008,\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",2008,\"FINITION\",\"BDG\")/L13","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",2008,\"FINITION\",\"MDG\")/L13","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",2008,\"FINITION\",\"HDG\")/L13","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",2008,\"FINITION\",\"SS\")/L13","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",2008,\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",2008,\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",2008,\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},2008,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",2008)","v":{"$error":"#REF!"}},{"$f":"AC13/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",2008)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",2008)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",2008)","v":0},0,{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",2008)/'Analyse Véhicules'!AC13","v":{"$error":"#REF!"}}]
[null,null,"Mercedes",{"$f":"COUNTIF('Détails ventes'!E8:E403,\"mercedes\")","v":0},{"$f":"D14/F8","v":{"$error":"#DIV/0!"}},null,"ENERGIE",null,null,null,308,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",308)","v":{"$error":"#REF!"}},{"$f":"L14/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",308,\"ENERGIE\",\"Essence\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",308,\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",308,\"FINITION\",\"BDG\")/L14","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",308,\"FINITION\",\"MDG\")/L14","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",308,\"FINITION\",\"HDG\")/L14","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",308,\"FINITION\",\"SS\")/L14","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",308,\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",308,\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",308,\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},308,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",308)","v":{"$error":"#REF!"}},{"$f":"AC14/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",308)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",308)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",4008)","v":0},0,{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",308)/'Analyse Véhicules'!AC14","v":{"$error":"#REF!"}}]
[null,{"$f":"B12/F8","v":{"$error":"#DIV/0!"}},"Audi",{"$f":"COUNTIF('Détails ventes'!E8:E403,\"audi\")","v":0},{"$f":"D15/F8","v":{"$error":"#DIV/0!"}},null,{"$f":"H15/F8","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Détails ventes'!J8:J403,\"diesel\")","v":0},"Diesel",null,"308SW",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"308sw\")","v":{"$error":"#REF!"}},{"$f":"L15/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",\"308sw\",\"ENERGIE\",\"Essence\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",\"308sw\",\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"308sw\",\"FINITION\",\"BDG\")/L15","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"308sw\",\"FINITION\",\"MDG\")/L15","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"308sw\",\"FINITION\",\"HDG\")/L15","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"308sw\",\"FINITION\",\"SS\")/L15","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"308sw\",\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"308sw\",\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"308sw\",\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},"308SW",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"308sw\")","v":{"$error":"#REF!"}},{"$f":"AC15/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",\"308sw\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",\"308sw\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",\"308sw\")","v":0},0,{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",\"308sw\")/'Analyse Véhicules'!AC15","v":{"$error":"#REF!"}}]
[null,null,"BMW",{"$f":"COUNTIF('Détails ventes'!E8:E403,\"bmw\")","v":0},{"$f":"D16/F8","v":{"$error":"#DIV/0!"}},null,{"$f":"H16/F8","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Détails ventes'!J8:J403,\"essence\")","v":0},"Essence",null,3008,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",3008)","v":{"$error":"#REF!"}},{"$f":"L16/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",3008,\"ENERGIE\",\"Essence\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",3008,\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",3008,\"FINITION\",\"BDG\")/L16","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",3008,\"FINITION\",\"MDG\")/L16","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",3008,\"FINITION\",\"HDG\")/L16","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",3008,\"FINITION\",\"SS\")/L16","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",3008,\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",3008,\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",3008,\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},3008,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",3008)","v":{"$error":"#REF!"}},{"$f":"AC16/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",3008)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",3008)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",3008)","v":0},0,{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",3008)/'Analyse Véhicules'!AC16","v":{"$error":"#REF!"}}]
[null,null,"Fiat",{"$f":"COUNTIF('Détails ventes'!E8:E403,\"fiat\")","v":0},{"$f":"D17/F8","v":{"$error":"#DIV/0!"}},null,{"$f":"H17/F8","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Détails ventes'!J8:J403,\"Hybride\")","v":0},"Hybride",null,4008,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",4008)","v":{"$error":"#REF!"}},{"$f":"L17/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",4008,\"ENERGIE\",\"Essence\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",4008,\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",4008,\"FINITION\",\"BDG\")/L17","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",4008,\"FINITION\",\"MDG\")/L17","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",4008,\"FINITION\",\"HDG\")/L17","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",4008,\"FINITION\",\"SS\")/L17","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",4008,\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",4008,\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",4008,\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$f":"Z17/K17","v":{"$error":"#REF!"}},4008,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",4008)","v":{"$error":"#REF!"}},{"$f":"AC17/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",4008)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",4008)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",4008)","v":0},0,{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",4008)/'Analyse Véhicules'!AC17","v":{"$error":"#REF!"}}]
[null,null,"Opel",{"$f":"COUNTIF('Détails ventes'!E8:E403,\"opel\")","v":0},{"$f":"D18/F8","v":{"$error":"#DIV/0!"}},null,{"$f":"H18/F8","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Détails ventes'!J8:J403,\"electrique\")","v":0},"Electrique",null,508,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",508)","v":{"$error":"#REF!"}},{"$f":"L18/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",508,\"ENERGIE\",\"Essence\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",508,\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",508,\"FINITION\",\"BDG\")/L18","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",508,\"FINITION\",\"MDG\")/L18","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",508,\"FINITION\",\"HDG\")/L18","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",508,\"FINITION\",\"SS\")/L18","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",508,\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",508,\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",508,\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$f":"Z18/L18","v":{"$error":"#REF!"}},508,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",508)","v":{"$error":"#REF!"}},{"$f":"AC18/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",508)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",508)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",508)","v":0},0,{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",508)/'Analyse Véhicules'!AC18","v":{"$error":"#REF!"}}]
["ASIATIQUE",{"$f":"SUM(D19:D22)","v":0},"Toyota",{"$f":"COUNTIF('Détails ventes'!E8:E403,\"toyota\")","v":0},{"$f":"D19/F8","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"508SW",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"508sw\")","v":{"$error":"#REF!"}},{"$f":"L19/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",\"508sw\",\"ENERGIE\",\"Essence\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",\"508sw\",\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"508sw\",\"FINITION\",\"BDG\")/L19","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"508sw\",\"FINITION\",\"MDG\")/L19","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"508sw\",\"FINITION\",\"HDG\")/L19","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"508sw\",\"FINITION\",\"SS\")/L19","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"508sw\",\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"508sw\",\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"508sw\",\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},"508SW",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"508sw\")","v":{"$error":"#REF!"}},{"$f":"AC19/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",\"508sw\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",\"508sw\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",\"508sw\")","v":0},0,{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",\"508sw\")/'Analyse Véhicules'!AC19","v":{"$error":"#REF!"}}]
[null,null,"Kia",{"$f":"COUNTIF('Détails ventes'!E8:E403,\"kia\")","v":0},{"$f":"D20/F8","v":{"$error":"#DIV/0!"}},null,"BOITE",null,null,null,5008,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",5008)","v":{"$error":"#REF!"}},{"$f":"L20/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",5008,\"ENERGIE\",\"Essence\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",5008,\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",5008,\"FINITION\",\"BDG\")/L20","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",5008,\"FINITION\",\"MDG\")/L20","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",5008,\"FINITION\",\"HDG\")/L20","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",5008,\"FINITION\",\"SS\")/L20","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",5008,\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",5008,\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",5008,\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},5008,{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",5008)","v":{"$error":"#REF!"}},{"$f":"AC20/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",5008)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",5008)","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",5008)","v":0},0,{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",5008)/'Analyse Véhicules'!AC20","v":{"$error":"#REF!"}}]
[null,{"$f":"B19/F8","v":{"$error":"#DIV/0!"}},"Hyundai",{"$f":"COUNTIF('Détails ventes'!E8:E403,\"hyundai\")","v":0},{"$f":"D21/F8","v":{"$error":"#DIV/0!"}},null,{"$f":"H21/F8","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Détails ventes'!K8:K403,\"mecanique\")","v":0},"Mécanique",null,"Bipper",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"Bipper\")","v":{"$error":"#REF!"}},{"$f":"L21/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",\"Bipper\",\"ENERGIE\",\"Essence\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",\"Bipper\",\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Bipper\",\"FINITION\",\"BDG\")/L21","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Bipper\",\"FINITION\",\"MDG\")/L21","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Bipper\",\"FINITION\",\"HDG\")/L21","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Bipper\",\"FINITION\",\"SS\")/L21","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"Bipper\",\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"Bipper\",\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"Bipper\",\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Bipper",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"Bipper\")","v":{"$error":"#REF!"}},{"$f":"AC21/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",\"Bipper\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",\"Bipper\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",\"Bipper\")","v":0},0,{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",\"Bipper\")/'Analyse Véhicules'!AC21","v":{"$error":"#REF!"}}]
[null,null,"Nissan",{"$f":"COUNTIF('Détails ventes'!E8:E403,\"nissan\")","v":0},{"$f":"D22/F8","v":{"$error":"#DIV/0!"}},null,{"$f":"H22/F8","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Détails ventes'!K8:K403,\"automatique\")","v":0},"Automatique",null,"Partner",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"Partner\")","v":{"$error":"#REF!"}},{"$f":"L22/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",\"Partner\",\"ENERGIE\",\"Essence\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",\"Partner\",\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Partner\",\"FINITION\",\"BDG\")/L22","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Partner\",\"FINITION\",\"MDG\")/L22","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Partner\",\"FINITION\",\"HDG\")/L22","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Partner\",\"FINITION\",\"SS\")/L22","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"Partner\",\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"Partner\",\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"Partner\",\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Partner",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"Partner\")","v":{"$error":"#REF!"}},{"$f":"AC22/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",\"Partner\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",\"Partner\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",\"Partner\")","v":0},0,{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",\"Partner\")/'Analyse Véhicules'!AC22","v":{"$error":"#REF!"}}]
[null,{"$f":"E23","v":{"$error":"#DIV/0!"}},"Autres",{"$f":"COUNTIF('Détails ventes'!E8:E403,\"autres\")","v":0},{"$f":"D23/F8","v":{"$error":"#DIV/0!"}},null,{"$f":"H23/F8","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Détails ventes'!K8:K403,\"pilotée\")","v":0},"Pilotée",null,"Expert",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"Expert\")","v":{"$error":"#REF!"}},{"$f":"L23/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",\"Expert\",\"ENERGIE\",\"Essence\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",\"Expert\",\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Expert\",\"FINITION\",\"BDG\")/L23","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Expert\",\"FINITION\",\"MDG\")/L23","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Expert\",\"FINITION\",\"HDG\")/L23","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Expert\",\"FINITION\",\"SS\")/L23","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"Expert\",\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"Expert\",\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"Expert\",\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Expert",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"Expert\")","v":{"$error":"#REF!"}},{"$f":"AC23/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",\"Expert\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",\"Expert\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",\"Expert\")","v":0},0,{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",\"Expert\")/'Analyse Véhicules'!AC23","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,"Boxer",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"Boxer\")","v":{"$error":"#REF!"}},{"$f":"L24/L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",\"Boxer\",\"ENERGIE\",\"Essence\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"ENERGIE\",Formules!$E$52,\"MODELE\",\"Boxer\",\"ENERGIE\",\"Diesel\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Boxer\",\"FINITION\",\"BDG\")/L24","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Boxer\",\"FINITION\",\"MDG\")/L24","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Boxer\",\"FINITION\",\"HDG\")/L24","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"MODELE\",\"Boxer\",\"FINITION\",\"SS\")/L24","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"Boxer\",\"BOITE\",\"Mécanique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"Boxer\",\"BOITE\",\"PILOTEE\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"BOITE\",Formules!$I$80,\"MODELE\",\"Boxer\",\"BOITE\",\"Automatique\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Boxer",{"$f":"GETPIVOTDATA(\"MODELE\",Formules!$A$44,\"MARQUE\",\"Peugeot\",\"MODELE\",\"Boxer\")","v":{"$error":"#REF!"}},{"$f":"AC24/AC25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX D'ACHAT\",Formules!$A$109,\"MODELE\",\"Boxer\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de PRIX FACTURE\",Formules!$A$109,\"MODELE\",\"Boxer\")","v":0},{"$f":"GETPIVOTDATA(\"Moyenne de FRE (en HT)\",Formules!$A$109,\"MODELE\",\"Boxer\")","v":0},0,{"$error":"#REF!"},{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109,\"MODELE\",\"Boxer\")/'Analyse Véhicules'!AC24","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(L6:L24)","v":{"$error":"#REF!"}},{"$f":"SUM(M6:M24)","v":{"$error":"#REF!"}},{"$f":"SUM(N7:N24)","v":{"$error":"#REF!"}},1,{"$f":"SUM(P7:P24)","v":{"$error":"#REF!"}},1,{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"FINITION\",\"BDG\")/'Analyse Véhicules'!L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"FINITION\",\"MDG\")/'Analyse Véhicules'!L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"FINITION\",\"HDG\")/'Analyse Véhicules'!L25","v":{"$error":"#REF!"}},{"$f":"GETPIVOTDATA(\"FINITION\",Formules!$M$53,\"FINITION\",\"SS\")/'Analyse Véhicules'!L25","v":{"$error":"#REF!"}},{"$f":"SUM(V6:V24)","v":{"$error":"#REF!"}},null,{"$f":"SUM(X6:X24)","v":{"$error":"#REF!"}},null,{"$f":"SUM(Z6:Z24)","v":{"$error":"#REF!"}},null,"TOTAL",{"$f":"SUM(AC6:AC24)","v":{"$error":"#REF!"}},{"$f":"SUM(AD6:AD24)","v":{"$error":"#REF!"}},null,null,null,0,null,{"$f":"GETPIVOTDATA(\"Nombre de jours de stock\",Formules!$F$109)/'Analyse Véhicules'!AC25","v":{"$error":"#REF!"}}]

{"sheet":"Formules","index":4,"n_rows":139,"n_cols":37,"rows_kept":139,"cut":false,"hidden":false,"merged":[[19,4,19,9],[1,0,1,2],[12,0,12,1],[1,7,1,8],[22,0,22,1],[70,26,70,27],[77,26,77,27],[65,31,65,32],[64,31,64,35],[32,0,32,1],[69,26,69,29],[73,31,73,34]]}
[]
["DELTA FRAIS",null,null,null,null,null,null,"DUREE MOYENNE DE DETENTION EN STOCK",null,null,"Étiquettes de lignes","Nombre de MARQUE"]
["VENDEURS","MBA",null,null,null,null,null,"Étiquettes de lignes","Moyenne de Nombre de jours de stock",null,"Beunard"]
["Beunard",0,null,null,null,null,null,"Beunard",0,null,"Briand"]
["Briand",0,null,null,null,null,null,"Briand",0,null,"Guillaume"]
["Guillaume",0,null,null,null,null,null,"Guillaume",0,null,"Joseph"]
["Joseph",0,null,null,null,null,null,"Joseph",0,null,"Leandre"]
["Leandre",0,null,null,null,null,null,"Leandre",0,null,"Total général"]
["(vide)",0,null,null,null,null,null,"(vide)",0]
["Total général",0,null,null,null,null,null,"Total général",0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Étiquettes de colonnes"]
["REMISE MOYENNE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Étiquettes de lignes",0,"Total général"]
["Étiquettes de lignes","Moyenne de REMISE",null,null,null,null,null,null,null,null,null,null,null,null,null,"(vide)"]
["Beunard",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Joseph"]
["Briand",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Guillaume"]
["Guillaume",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leandre"]
["Joseph",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beunard"]
["Leandre",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Briand"]
["(vide)",0,null,null,"VENTILATION VENTE FINANCEMENT",null,null,null,null,null,null,null,null,null,null,"Total général"]
["Total général",0,null,null,"Nombre de Montant Financé","Étiquettes de colonnes"]
[null,null,null,null,"Étiquettes de lignes","Total général"]
["Nombre de Financement",null,null,null,"Total général"]
["Étiquettes de lignes","Nombre de Financement"]
["Beunard"]
["Briand"]
["Guillaume"]
["Joseph"]
["Leandre"]
["(vide)",6]
["Total général",6,null,null,"Somme de Montant Financé","Étiquettes de colonnes"]
[null,null,null,null,"Étiquettes de lignes","50/50","Pack ODL","PP","Premium","Primo","Pro","(vide)","Total général"]
["Montant Financé",null,null,null,"Beunard"]
["Étiquettes de lignes","Somme de Montant Financé",null,null,"Briand"]
["Beunard",null,null,null,"Guillaume"]
["Briand",null,null,null,"Joseph"]
["Guillaume",null,null,null,"Leandre"]
["Joseph",null,null,null,"(vide)"]
["Leandre",null,null,null,"Total général"]
["(vide)"]
["Total général"]
[]
[]
["Nombre de MODELE","Étiquettes de colonnes"]
["Étiquettes de lignes",108,207,208,308,508,2008,3008,4008,5008,"Bipper","Boxer","Expert","Partner","(vide)",107,"ion","308sw","508sw","206+","207sw","Total général"]
["(vide)",1,2,1,1,1,1,1,1,1,1,1,1,1,null,1,1,1,1,1,1,20]
["Total général",1,2,1,1,1,1,1,1,1,1,1,1,1,null,1,1,1,1,1,1,20]
[]
[]
[]
[]
[null,null,null,null,"Nombre de ENERGIE","Étiquettes de colonnes"]
["Étiquettes de lignes","Moyenne de MARGE BRUTE",null,null,"Étiquettes de lignes","(vide)","Total général",null,null,null,null,null,"Nombre de FINITION","Étiquettes de colonnes"]
["(vide)",0,null,null,107,null,null,null,null,null,null,null,"Étiquettes de lignes","(vide)","Total général"]
["Joseph",0,null,null,108,null,null,null,null,null,null,null,107]
["Guillaume",0,null,null,207,null,null,null,null,null,null,null,108]
["Leandre",0,null,null,208,null,null,null,null,null,null,null,207]
["Beunard",0,null,null,308,null,null,null,null,null,null,null,208]
["Briand",0,null,null,508,null,null,null,null,null,null,null,308]
["Total général",0,null,null,2008,null,null,null,null,null,null,null,508]
[null,null,null,null,3008,null,null,null,null,null,null,null,2008]
[null,null,null,null,4008,null,null,null,null,null,null,null,3008]
[null,null,null,null,5008,null,null,null,null,null,null,null,4008]
[null,null,null,null,"206+",null,null,null,null,null,null,null,5008]
[null,null,null,null,"207sw",null,null,null,null,null,null,null,"206+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FINANCEMENT",null,null,null,null,{"$f":"'Détails ventes'!L4","v":0}]
[null,null,null,null,"308sw",null,null,null,null,null,null,null,"207sw",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ETAT",null,null,"RESULTAT",{"$f":"'Analyse Vendeurs'!K9/Formules!AK65","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"508sw",null,null,null,null,null,null,null,"308sw",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mauvais",0.5,null,"Taille Aiguille",0.02]
[null,null,null,null,"Bipper",null,null,null,null,null,null,null,"508sw",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moyen",0.25,null,"Vide",{"$f":"AJ69-AJ67-AJ66","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Boxer",null,null,null,null,null,null,null,"Bipper",null,null,null,null,null,null,null,null,null,null,null,null,null,"Graphique",null,null,null,null,"Bon",0.25,null,"Invisible",1]
[null,null,null,null,"Expert",null,null,null,null,null,null,null,"Boxer",null,null,null,null,null,null,null,null,null,null,null,null,null,"VOLUME",null,null,null,null,"INVISIBLE",1]
[null,null,null,null,"ion",null,null,null,null,null,null,null,"Expert",null,null,null,null,null,null,null,null,null,null,null,null,null,"ETAT"]
[null,null,null,null,"Partner",null,null,null,null,null,null,null,"ion",null,null,null,null,null,null,null,null,null,null,null,null,null,"Médiocre",0.2]
[null,null,null,null,"(vide)",null,null,null,null,null,null,null,"Partner",null,null,null,null,null,null,null,null,null,null,null,null,null,"Mauvais",0.2]
[null,null,null,null,"Total général",null,null,null,null,null,null,null,"Total général",null,null,null,null,null,null,null,null,null,null,null,null,null,"Moyen",0.2,null,null,null,"MARGE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bon",0.2,null,null,null,"MAUVAIS",0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excellent",0.2,null,null,null,"MOYEN",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INVISIBLE",{"$f":"SUM(AB72:AB76)","v":1},null,null,null,"BON ",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VENTE VO",null,"Objectif",{"$f":"'Détails ventes'!G4","v":0},null,"INVISIBLE",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESULTAT",{"$f":"AC79/AD78","v":{"$error":"#DIV/0!"}},{"$f":"'Analyse Vendeurs'!D9","v":0}]
[null,null,null,null,null,null,null,null,"Nombre de BOITE","Étiquettes de colonnes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taille aiguille",0.02,null,null,null,"Marge","Objectif",{"$f":"'Détails ventes'!Q4","v":0}]
[null,null,null,null,null,null,null,null,"Étiquettes de lignes","(vide)","Total général",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vide",{"$f":"AB82-AB79-AB80","v":{"$error":"#DIV/0!"}},null,null,null,"Résultat",{"$f":"AI82/AH80","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,107,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invisible",1,null,null,null,"Taille Aiguille",0.02,null,{"$f":"SUM('Détails ventes'!U8:U378)","v":0}]
[null,null,null,null,null,null,null,null,108,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vide",{"$f":"AG84-AG81-AG82","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,207,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invisible",1]
[null,null,null,null,null,null,null,null,208]
[null,null,null,null,null,null,null,null,308]
[null,null,null,null,null,null,null,null,508]
[null,null,null,null,null,null,null,null,2008]
[null,null,null,null,null,null,null,null,3008]
[null,null,null,null,null,null,null,null,4008]
[null,null,null,null,null,null,null,null,5008]
[null,null,null,null,null,null,null,null,"206+"]
[null,null,null,null,null,null,null,null,"207sw"]
[null,null,null,null,null,null,null,null,"308sw"]
[null,null,null,null,null,null,null,null,"508sw"]
[null,null,null,null,null,null,null,null,"Bipper"]
[null,null,null,null,null,null,null,null,"Boxer"]
[null,null,null,null,null,null,null,null,"Expert"]
[null,null,null,null,null,null,null,null,"ion"]
[null,null,null,null,null,null,null,null,"Partner"]
[null,null,null,null,null,null,null,null,"Total général"]
[]
[]
[]
[]
[]
[]
[]
["Étiquettes de lignes","Moyenne de PRIX D'ACHAT","Moyenne de FRE (en HT)","Moyenne de PRIX FACTURE",null,"Étiquettes de lignes","Somme de Nombre de jours de stock"]
[107,null,null,null,null,107,0,null,null,null,"Étiquettes de lignes","Somme de DIFFERENCE FRE (en HT)"]
[108,null,null,null,null,108,0,null,null,null,"Beunard",0]
[207,null,null,null,null,207,0,null,null,null,"Briand",0]
[208,null,null,null,null,208,0,null,null,null,"Guillaume",0]
[308,null,null,null,null,308,0,null,null,null,"Joseph",0]
[508,null,null,null,null,508,0,null,null,null,"Leandre",0]
[2008,null,null,null,null,2008,0,null,null,null,"(vide)",0]
[3008,null,null,null,null,3008,0,null,null,null,"Total général",0]
[4008,null,null,null,null,4008,0]
[5008,null,null,null,null,5008,0]
["206+",null,null,null,null,"206+",0]
["207sw",null,null,null,null,"207sw",0]
["308sw",null,null,null,null,"308sw",0]
["508sw",null,null,null,null,"508sw",0]
["Bipper",null,null,null,null,"Bipper",0]
["Boxer",null,null,null,null,"Boxer",0]
["Expert",null,null,null,null,"Expert",0]
["ion",null,null,null,null,"ion",0]
["Partner",null,null,null,null,"Partner",0]
["Total général",null,null,null,null,"(vide)",0]
[null,null,null,null,null,"Total général",0]
[]
[]
["Étiquettes de lignes","Nombre de Financement"]
["Beunard"]
["Briand"]
["Guillaume"]
["Joseph"]
["Leandre"]
["Total général"]