{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":46,"n_cols":16,"rows_kept":46,"merged":[[0,1,0,3],[1,1,1,2],[2,1,6,1],[7,1,15,1],[16,1,24,1],[25,1,36,1],[25,2,26,2],[27,2,28,2],[29,2,30,2],[31,2,32,2],[33,2,34,2],[35,2,36,2],[37,1,41,1],[42,1,45,1]]}
[null,{"$f":"IF(ISBLANK(D2),\"renseigner le 1er mois de l'exercice (xx/xx/xxxx)\",\" \")","v":" "}]
[null,"Tableau de bord mensuel",null,"2019-01-31",{"$f":"IF(ISBLANK($D$2),\" \",EOMONTH(D2,1))","v":"2019-02-28"},{"$f":"IF(ISBLANK($D$2),\" \",EOMONTH(E2,1))","v":"2019-03-31"},"2019-04-30","2019-05-31","2019-06-30","2019-07-31","2019-08-31","2019-09-30","2019-10-31","2019-11-30","2019-12-31","Total"]
[null,"Données \nstatistiques"," nombre de jours ouvrables",{"$nulls":12},{"$f":"SUM(D3:O3)","v":{"v":0,"d":"0 J"}}]
[null,null," nombre de jours de visite réalisées",{"$nulls":12},{"v":0,"d":"0 J"}]
[null,null," nombre de jours d'absences",{"$nulls":12},{"v":0,"d":"0 J"}]
[null,null," nombre de kilomètres parcourus",{"$nulls":12},{"$f":"SUM(D6:O6)","v":{"v":0,"d":"0 Kms"}}]
[null,null," nombre de kilomètres par jour de visite",{"$f":"IF(ISERROR(D6/D4),\" \",D6/D4)","v":" "}," "," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(ISERROR(P6/P4),\" \",P6/P4)","v":" "}]
[null,"Ensembles \ndes frais engagés"," rémunération brute",{"$nulls":12},{"$f":"SUM(D8:O8)","v":{"v":0,"d":"0 € "}}]
[null,null," charges sociales",{"$nulls":12},{"v":0,"d":"0 € "}]
[null,null," remboursement de frais s/ justificatifs",{"$nulls":12},{"v":0,"d":"0 € "}]
[null,null," remboursements kilométriques",{"$nulls":12},{"v":0,"d":"0 € "}]
[null,null," coût de mise à disposition",{"$nulls":12},{"v":0,"d":"0 € "}]
[null,null," coût de secrétariat",{"$nulls":12},{"v":0,"d":"0 € "}]
[null,null," Autres",{"$nulls":12},{"v":0,"d":"0 € "}]
[null,null," Frais par jour jour de visite",{"$f":"IF(ISERROR((D10+D11)/D4),\" \",(D10+D11)/D4)","v":" "},{"$f":"IF(ISERROR((E10+E11)/E4),\" \",(E10+E11)/E4)","v":" "}," "," "," "," "," "," "," "," "," "," "," "]
[null,null," Coût total",{"$f":"SUM(D8:D14)","v":{"v":0,"d":"0 € "}},{"$f":"SUM(E8:E14)","v":{"v":0,"d":"0 € "}},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"$f":"SUM(P8:P14)","v":{"v":0,"d":"0 € "}}]
[null,"Activité et marge"," nombre total de visites",{"$nulls":12},{"$f":"SUM(D17:O17)","v":0}]
[null,null," nombre de commandes obtenues",{"$nulls":12},0]
[null,null," Chiffre d'affaires total réalisé",{"$nulls":12},{"v":0,"d":"0 € "}]
[null,null," Coût d'achat ou coût de production \n des marchandises ou produits vendus",{"$nulls":12},{"$f":"SUM(D20:O20)","v":{"v":0,"d":"0 € "}}]
[null,null," Total des coûts",{"$f":"D16+D20","v":{"v":0,"d":"0 € "}},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"$f":"SUM(D21:O21)","v":{"v":0,"d":"0 € "}}]
[null,null," Marge commerciale",{"$f":"D19-D20","v":{"v":0,"d":"0 € "}},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "}]
[null,null," Taux de marge commerciale",{"$f":"IF(ISERROR(D22/D19),\" \",D22/D19)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null," Marge/coûts",{"$f":"D19-D21","v":{"v":0,"d":"0 € "}},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "},{"v":0,"d":"0 € "}]
[null,null," Taux de marge",{"$f":"IF(ISERROR(D24/D19),\" \",D24/D19)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "]
[null,"Chiffre d'affairespar \nfamille de produits",{"$nulls":13},{"$f":"SUM(D26:O26)","v":{"v":0,"d":"0 € "}}]
[{"$nulls":3},{"$f":"IF(ISERROR(D26/D19),\" \",D26/D19)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "]
[{"$nulls":15},{"$f":"SUM(D28:O28)","v":{"v":0,"d":"0 € "}}]
[{"$nulls":3},{"$f":"IF(ISERROR(D28/D19),\" \",D28/D19)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "]
[{"$nulls":15},{"$f":"SUM(D30:O30)","v":{"v":0,"d":"0 € "}}]
[{"$nulls":3},{"$f":"IF(ISERROR(D30/D19),\" \",D30/D19)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "]
[{"$nulls":15},{"$f":"SUM(D32:O32)","v":{"v":0,"d":"0 € "}}]
[{"$nulls":3},{"$f":"IF(ISERROR(D32/D19),\" \",D32/D19)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "]
[{"$nulls":15},{"v":0,"d":"0 € "}]
[{"$nulls":3},{"$f":"IF(ISERROR(D34/D19),\" \",D34/D19)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "]
[{"$nulls":15},{"v":0,"d":"0 € "}]
[{"$nulls":3},{"$f":"IF(ISERROR(D36/D19),\" \",D36/D19)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "]
[null,"Productivité"," Chiffre d'affaires moyen par visite",{"$f":"IF(ISERROR(D19/D17),\" \",D19/D17)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null," Coût moyen de la visite",{"$f":"IF(ISERROR(D16/D17),\" \",D16/D17)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null," Chiffre d'affaires moyen par commande",{"$f":"IF(ISERROR(D19/D18),\" \",D19/D18)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null," Coût moyen de la commande",{"$f":"IF(ISERROR(D16/D18),\" \",D16/D18)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null," Coût représentant /chiffre d'affaires",{"$f":"IF(ISERROR(D16/D19),\" \",D16/D19)","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "]
[null,"Conditions"," Prix tarif des produits vendus",{"$nulls":12},{"$f":"SUM(D43:O43)","v":{"v":0,"d":"0 € "}}]
[null,null," Taux de remise moyen accordé",{"$f":"IF(ISERROR(1-(D19/D43)),\" \",1-(D19/D43))","v":" "}," "," "," "," "," "," "," "," "," "," "," "," "]
[null,null," Encours créances clients",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(D45:O45)),\" \",AVERAGE(D45:O45))","v":" "}]
[null,null," Délai moyen de paiement des clients",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(D46:O46)),\" \",AVERAGE(D46:O46))","v":" "}]