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

{"sheet":"Feuil1","index":0,"n_rows":98,"n_cols":20,"rows_kept":98,"merged":[[1,2,1,6],[1,7,1,18],[3,4,3,5],[5,1,5,3],[8,1,11,1],[8,2,11,2],[10,3,11,3],[12,1,12,2],[14,1,15,1],[14,2,15,2],[16,1,16,2],[18,1,21,2],[20,3,21,3],[22,1,22,3],[23,1,26,2],[25,3,26,3],[28,1,31,1],[28,2,31,2],[30,3,31,3],[33,1,35,1],[33,2,34,2],[37,1,37,3],[38,1,40,1],[38,2,40,2],[42,1,44,1],[42,2,44,2],[46,1,49,1],[46,2,49,2],[48,3,49,3],[51,1,53,1],[51,2,53,2],[56,1,57,2],[59,1,61,1],[59,2,61,2],[63,1,65,1],[63,2,65,2],[67,1,71,1],[67,2,68,2],[67,3,68,3],[69,2,70,2],[69,3,70,3],[73,1,73,3],[74,1,75,1],[74,2,75,2],[76,1,76,2],[77,1,77,3],[78,1,79,1],[78,2,79,2],[80,1,81,2],[80,3,81,3],[83,1,84,1],[83,2,84,2],[85,1,86,2],[85,3,86,3],[88,1,88,3],[89,1,90,1],[89,2,90,2],[93,1,96,2],[95,3,96,3]]}
[]
[null,"Entreprise",{"$nulls":5},"Tableau de bord de gestion"]
[]
[null,{"$f":"IF(ISBLANK(C4),\"Unité monétaire ?\",\"Unité monétaire\")","v":"Unité monétaire"},"K€",null,{"$f":"IF(ISBLANK(E6),\"Indiquer le premier mois\",\" \")","v":"Indiquer le premier mois"}]
[]
[null,"Indicateurs mensuels",{"$nulls":3},{"$f":"IF(ISBLANK($E$6),\" \",EOMONTH(E6,1))","v":" "},{"$f":"IF(ISBLANK($E$6),\" \",EOMONTH(F6,1))","v":" "}," "," "," "," "," "," "," "," "," ","Total \nMoyenne",null,"Annuel"]
[]
[null,"Commerce"]
[null," Entrées de \n commandes",{"$f":"IF(ISBLANK($C$4),\" \",$C$4)","v":"K€"}," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(SUM(E14:P14)),0,SUM(E14:P14))","v":{"v":0,"d":"0 "}},null,{"$f":"IF(ISERROR(SUM(E9:P9)),\" \",SUM(E9:P9))","v":{"v":0,"d":"0 "}},{"$f":"IF(UM=\"K€\",Q9,IF(UM=\"€\",Q9/1000,\" \"))","v":0}]
[{"$nulls":3}," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(SUM(E10:P10)),0,SUM(E10:P10))","v":{"v":0,"d":"0 "}},null,{"$f":"IF(ISBLANK(P10),\" \",Q10)","v":" "},{"$f":"IF(UM=\"K€\",Q10,IF(UM=\"€\",Q10/1000,\" \"))","v":0}]
[{"$nulls":3}," Ecart",{"$f":"IF(ISBLANK(E10),\" \",E10-E9)","v":" "},{"$f":"IF(ISBLANK(F10),\" \",F10-F9)","v":" "}," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(OR(Q9=0,Q10=0),\" \",Q10-Q9)","v":" "},null,{"$f":"IF(OR(ISBLANK(P9),ISBLANK(P10)),\" \",S10-S9)","v":" "}]
[{"$nulls":4},{"$f":"IF(ISERROR(E11/E9),\" \",E11/E9)","v":" "},{"$f":"IF(ISERROR(F11/F9),\" \",F11/F9)","v":" "},{"$f":"IF(ISERROR(G11/G9),\" \",G11/G9)","v":" "},{"$f":"IF(ISERROR(H11/H9),\" \",H11/H9)","v":" "},{"$f":"IF(ISERROR(I11/I9),\" \",I11/I9)","v":" "},{"$f":"IF(ISERROR(J11/J9),\" \",J11/J9)","v":" "},{"$f":"IF(ISERROR(K11/K9),\" \",K11/K9)","v":" "},{"$f":"IF(ISERROR(L11/L9),\" \",L11/L9)","v":" "},{"$f":"IF(ISERROR(M11/M9),\" \",M11/M9)","v":" "},{"$f":"IF(ISERROR(N11/N9),\" \",N11/N9)","v":" "},{"$f":"IF(ISERROR(O11/O9),\" \",O11/O9)","v":" "},{"$f":"IF(ISERROR(P11/P9),\" \",P11/P9)","v":" "}," ",null,{"$f":"IF(ISERROR(S11/S9),\" \",S11/S9)","v":" "}]
[null," Portefeuille fin de mois",null,{"$f":"IF(ISBLANK($C$4),\" \",$C$4)","v":"K€"},{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E13:P13)),\" \",AVERAGE(E13:P13))","v":" "}]
[{"$nulls":4},{"$f":"IF(E10=\"\",\" \",E9)","v":" "},{"$f":"IF(F10=\"\",\" \",F9)","v":" "}," "," "," "," "," "," "," "," "," "," "]
[null," Taux de \n transformation","%"," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E18:P18)),0,AVERAGE(E18:P18))","v":{"v":0,"d":"0.0%"}},null,{"$f":"IF(ISERROR(AVERAGE(E15:P15)),\" \",AVERAGE(E15:P15))","v":" "}]
[{"$nulls":3}," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E16:P16)),0,AVERAGE(E16:P16))","v":{"v":0,"d":"0.0%"}},null,{"$f":"IF(ISBLANK(P16),\" \",Q16)","v":" "}]
[null," Nombre de commandes\n sur nombre de devis",null," Ecart",{"$f":"IF(ISBLANK(E16),\" \",E16-E15)","v":" "},{"$f":"IF(ISBLANK(F16),\" \",F16-F15)","v":" "}," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(ISERROR(Q16-Q15),\" \",Q16-Q15)","v":{"v":0,"d":"0.0%"}},null,{"$f":"IF(OR(ISBLANK(P15),ISBLANK(P16)),\" \",S16-S15)","v":" "}]
[{"$nulls":4},{"$f":"IF(E16=\"\",\" \",E15)","v":" "}," "," "," "," "," "," "," "," "," "," "," "]
[null," Nombre \n de clients \n actifs",null," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E23:P23)),0,AVERAGE(E23:P23))","v":0},null,{"$f":"IF(ISERROR(AVERAGE(E19:P19)),\" \",AVERAGE(E19:P19))","v":" "}]
[{"$nulls":3}," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E20:P20)),0,AVERAGE(E20:P20))","v":0},null,{"$f":"IF(ISBLANK(P20),\" \",Q20)","v":" "}]
[{"$nulls":3}," Ecart",{"$f":"IF(ISBLANK(E20),\" \",E20-E19)","v":" "},{"$f":"IF(ISBLANK(F20),\" \",F20-F19)","v":" "},{"$f":"IF(ISBLANK(G20),\" \",G20-G19)","v":" "},{"$f":"IF(ISBLANK(H20),\" \",H20-H19)","v":" "},{"$f":"IF(ISBLANK(I20),\" \",I20-I19)","v":" "},{"$f":"IF(ISBLANK(J20),\" \",J20-J19)","v":" "},{"$f":"IF(ISBLANK(K20),\" \",K20-K19)","v":" "},{"$f":"IF(ISBLANK(L20),\" \",L20-L19)","v":" "},{"$f":"IF(ISBLANK(M20),\" \",M20-M19)","v":" "},{"$f":"IF(ISBLANK(N20),\" \",N20-N19)","v":" "},{"$f":"IF(ISBLANK(O20),\" \",O20-O19)","v":" "},{"$f":"IF(ISBLANK(P20),\" \",P20-P19)","v":" "},{"$f":"IF(OR(Q19=0,Q20=0),\" \",Q20-Q19)","v":" "},null,{"$f":"IF(OR(ISBLANK(P19),ISBLANK(P20)),\" \",S20-S19)","v":" "}]
[{"$nulls":4},{"$f":"IF(ISERROR(E21/E19),\" \",E21/E19)","v":" "},{"$f":"IF(ISERROR(F21/F19),\" \",F21/F19)","v":" "},{"$f":"IF(ISERROR(G21/G19),\" \",G21/G19)","v":" "},{"$f":"IF(ISERROR(H21/H19),\" \",H21/H19)","v":" "},{"$f":"IF(ISERROR(I21/I19),\" \",I21/I19)","v":" "},{"$f":"IF(ISERROR(J21/J19),\" \",J21/J19)","v":" "},{"$f":"IF(ISERROR(K21/K19),\" \",K21/K19)","v":" "},{"$f":"IF(ISERROR(L21/L19),\" \",L21/L19)","v":" "},{"$f":"IF(ISERROR(M21/M19),\" \",M21/M19)","v":" "},{"$f":"IF(ISERROR(N21/N19),\" \",N21/N19)","v":" "},{"$f":"IF(ISERROR(O21/O19),\" \",O21/O19)","v":" "},{"$f":"IF(ISERROR(P21/P19),\" \",P21/P19)","v":" "}," ",null,{"$f":"IF(ISERROR(S21/S19),\" \",S21/S19)","v":" "}]
[{"$nulls":4},{"$f":"IF(E20=\"\",\" \",E19)","v":" "},{"$f":"IF(F20=\"\",\" \",F19)","v":" "},{"$f":"IF(G20=\"\",\" \",G19)","v":" "},{"$f":"IF(H20=\"\",\" \",H19)","v":" "},{"$f":"IF(I20=\"\",\" \",I19)","v":" "},{"$f":"IF(J20=\"\",\" \",J19)","v":" "},{"$f":"IF(K20=\"\",\" \",K19)","v":" "},{"$f":"IF(L20=\"\",\" \",L19)","v":" "},{"$f":"IF(M20=\"\",\" \",M19)","v":" "},{"$f":"IF(N20=\"\",\" \",N19)","v":" "},{"$f":"IF(O20=\"\",\" \",O19)","v":" "},{"$f":"IF(P20=\"\",\" \",P19)","v":" "}]
[null," Nombre de \n nouveaux \n clients",null," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(SUM(E28:P28)),0,SUM(E28:P28))","v":0},null,{"$f":"IF(ISERROR(SUM(E24:P24)),\" \",SUM(E24:P24))","v":{"v":0,"d":"0 "}}]
[{"$nulls":3}," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(SUM(E25:P25)),0,SUM(E25:P25))","v":0},null,{"$f":"IF(ISBLANK(P25),\" \",Q25)","v":" "}]
[{"$nulls":3}," Ecart",{"$f":"IF(ISBLANK(E25),\" \",E25-E24)","v":" "},{"$f":"IF(ISBLANK(F25),\" \",F25-F24)","v":" "},{"$f":"IF(ISBLANK(G25),\" \",G25-G24)","v":" "},{"$f":"IF(ISBLANK(H25),\" \",H25-H24)","v":" "},{"$f":"IF(ISBLANK(I25),\" \",I25-I24)","v":" "},{"$f":"IF(ISBLANK(J25),\" \",J25-J24)","v":" "},{"$f":"IF(ISBLANK(K25),\" \",K25-K24)","v":" "},{"$f":"IF(ISBLANK(L25),\" \",L25-L24)","v":" "},{"$f":"IF(ISBLANK(M25),\" \",M25-M24)","v":" "},{"$f":"IF(ISBLANK(N25),\" \",N25-N24)","v":" "},{"$f":"IF(ISBLANK(O25),\" \",O25-O24)","v":" "},{"$f":"IF(ISBLANK(P25),\" \",P25-P24)","v":" "},{"$f":"IF(OR(Q24=0,Q25=0),\" \",Q25-Q24)","v":" "},null,{"$f":"IF(OR(ISBLANK(P24),ISBLANK(P25)),\" \",S25-S24)","v":" "}]
[{"$nulls":4},{"$f":"IF(ISERROR(E26/E24),\" \",E26/E24)","v":" "},{"$f":"IF(ISERROR(F26/F24),\" \",F26/F24)","v":" "},{"$f":"IF(ISERROR(G26/G24),\" \",G26/G24)","v":" "},{"$f":"IF(ISERROR(H26/H24),\" \",H26/H24)","v":" "},{"$f":"IF(ISERROR(I26/I24),\" \",I26/I24)","v":" "},{"$f":"IF(ISERROR(J26/J24),\" \",J26/J24)","v":" "},{"$f":"IF(ISERROR(K26/K24),\" \",K26/K24)","v":" "},{"$f":"IF(ISERROR(L26/L24),\" \",L26/L24)","v":" "},{"$f":"IF(ISERROR(M26/M24),\" \",M26/M24)","v":" "},{"$f":"IF(ISERROR(N26/N24),\" \",N26/N24)","v":" "},{"$f":"IF(ISERROR(O26/O24),\" \",O26/O24)","v":" "},{"$f":"IF(ISERROR(P26/P24),\" \",P26/P24)","v":" "}," ",null,{"$f":"IF(ISERROR(S26/S24),\" \",S26/S24)","v":" "}]
[{"$nulls":4},{"$f":"IF(E25=\"\",\" \",E24)","v":" "},{"$f":"IF(F25=\"\",\" \",F24)","v":" "},{"$f":"IF(G25=\"\",\" \",G24)","v":" "},{"$f":"IF(H25=\"\",\" \",H24)","v":" "},{"$f":"IF(I25=\"\",\" \",I24)","v":" "},{"$f":"IF(J25=\"\",\" \",J24)","v":" "},{"$f":"IF(K25=\"\",\" \",K24)","v":" "},{"$f":"IF(L25=\"\",\" \",L24)","v":" "},{"$f":"IF(M25=\"\",\" \",M24)","v":" "},{"$f":"IF(N25=\"\",\" \",N24)","v":" "},{"$f":"IF(O25=\"\",\" \",O24)","v":" "},{"$f":"IF(P25=\"\",\" \",P24)","v":" "}]
[null," Chiffre \n d'affaires",{"$f":"IF(ISBLANK($C$4),\" \",$C$4)","v":"K€"}," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(SUM(E33:P33)),0,SUM(E33:P33))","v":{"v":0,"d":"0 "}},null,{"$f":"IF(ISERROR(SUM(E29:P29)),\" \",SUM(E29:P29))","v":{"v":0,"d":"0 "}},{"$f":"IF(UM=\"K€\",Q29,IF(UM=\"€\",Q29/1000,\" \"))","v":0}]
[{"$nulls":3}," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(SUM(E30:P30)),0,SUM(E30:P30))","v":{"v":0,"d":"0 "}},null,{"$f":"IF(ISBLANK(P30),\" \",Q30)","v":" "},{"$f":"IF(UM=\"K€\",Q30,IF(UM=\"€\",Q30/1000,\" \"))","v":0}]
[{"$nulls":3}," Ecart",{"$f":"IF(ISBLANK(E30),\" \",E30-E29)","v":" "},{"$f":"IF(ISBLANK(F30),\" \",F30-F29)","v":" "},{"$f":"IF(ISBLANK(G30),\" \",G30-G29)","v":" "},{"$f":"IF(ISBLANK(H30),\" \",H30-H29)","v":" "},{"$f":"IF(ISBLANK(I30),\" \",I30-I29)","v":" "},{"$f":"IF(ISBLANK(J30),\" \",J30-J29)","v":" "},{"$f":"IF(ISBLANK(K30),\" \",K30-K29)","v":" "},{"$f":"IF(ISBLANK(L30),\" \",L30-L29)","v":" "},{"$f":"IF(ISBLANK(M30),\" \",M30-M29)","v":" "},{"$f":"IF(ISBLANK(N30),\" \",N30-N29)","v":" "},{"$f":"IF(ISBLANK(O30),\" \",O30-O29)","v":" "},{"$f":"IF(ISBLANK(P30),\" \",P30-P29)","v":" "},{"$f":"IF(OR(Q29=0,Q30=0),\" \",Q30-Q29)","v":" "},null,{"$f":"IF(ISBLANK(P30),\" \",S30-S29)","v":" "}]
[{"$nulls":4},{"$f":"IF(ISERROR(E31/E29),\" \",E31/E29)","v":" "},{"$f":"IF(ISERROR(F31/F29),\" \",F31/F29)","v":" "},{"$f":"IF(ISERROR(G31/G29),\" \",G31/G29)","v":" "},{"$f":"IF(ISERROR(H31/H29),\" \",H31/H29)","v":" "},{"$f":"IF(ISERROR(I31/I29),\" \",I31/I29)","v":" "},{"$f":"IF(ISERROR(J31/J29),\" \",J31/J29)","v":" "},{"$f":"IF(ISERROR(K31/K29),\" \",K31/K29)","v":" "},{"$f":"IF(ISERROR(L31/L29),\" \",L31/L29)","v":" "},{"$f":"IF(ISERROR(M31/M29),\" \",M31/M29)","v":" "},{"$f":"IF(ISERROR(N31/N29),\" \",N31/N29)","v":" "},{"$f":"IF(ISERROR(O31/O29),\" \",O31/O29)","v":" "},{"$f":"IF(ISERROR(P31/P29),\" \",P31/P29)","v":" "}," ",null,{"$f":"IF(ISERROR(S31/S29),\" \",S31/S29)","v":" "}]
[{"$nulls":4},{"$f":"IF(E30=\"\",\" \",E29)","v":" "},{"$f":"IF(F30=\"\",\" \",F29)","v":" "},{"$f":"IF(G30=\"\",\" \",G29)","v":" "},{"$f":"IF(H30=\"\",\" \",H29)","v":" "},{"$f":"IF(I30=\"\",\" \",I29)","v":" "},{"$f":"IF(J30=\"\",\" \",J29)","v":" "},{"$f":"IF(K30=\"\",\" \",K29)","v":" "},{"$f":"IF(L30=\"\",\" \",L29)","v":" "},{"$f":"IF(M30=\"\",\" \",M29)","v":" "},{"$f":"IF(N30=\"\",\" \",N29)","v":" "},{"$f":"IF(O30=\"\",\" \",O29)","v":" "},{"$f":"IF(P30=\"\",\" \",P29)","v":" "}]
[null," Marge brute\n ou marge \n commerciale","%"," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E37:P37)),0,AVERAGE(E37:P37))","v":{"v":0,"d":"0.0%"}},null,{"$f":"IF(ISERROR(AVERAGE(E34:P34)),\" \",AVERAGE(E34:P34))","v":" "}]
[{"$nulls":3}," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E35:P35)),0,AVERAGE(E35:P35))","v":{"v":0,"d":"0.0%"}},null,{"$f":"IF(ISBLANK(P35),\" \",Q35)","v":" "}]
[{"$nulls":3}," Ecart",{"$f":"IF(ISBLANK(E35),\" \",E35-E34)","v":" "},{"$f":"IF(ISBLANK(F35),\" \",F35-F34)","v":" "},{"$f":"IF(ISBLANK(G35),\" \",G35-G34)","v":" "},{"$f":"IF(ISBLANK(H35),\" \",H35-H34)","v":" "},{"$f":"IF(ISBLANK(I35),\" \",I35-I34)","v":" "},{"$f":"IF(ISBLANK(J35),\" \",J35-J34)","v":" "},{"$f":"IF(ISBLANK(K35),\" \",K35-K34)","v":" "},{"$f":"IF(ISBLANK(L35),\" \",L35-L34)","v":" "},{"$f":"IF(ISBLANK(M35),\" \",M35-M34)","v":" "},{"$f":"IF(ISBLANK(N35),\" \",N35-N34)","v":" "},{"$f":"IF(ISBLANK(O35),\" \",O35-O34)","v":" "},{"$f":"IF(ISBLANK(P35),\" \",P35-P34)","v":" "},{"$f":"IF(ISERROR(Q35-Q34),\" \",Q35-Q34)","v":{"v":0,"d":"0.0%"}},null,{"$f":"IF(OR(ISBLANK(P34),ISBLANK(P35)),\" \",S35-S34)","v":" "}]
[{"$nulls":4},{"$f":"IF(E35=\"\",\" \",E34)","v":" "},{"$f":"IF(F35=\"\",\" \",F34)","v":" "},{"$f":"IF(G35=\"\",\" \",G34)","v":" "},{"$f":"IF(H35=\"\",\" \",H34)","v":" "},{"$f":"IF(I35=\"\",\" \",I34)","v":" "},{"$f":"IF(J35=\"\",\" \",J34)","v":" "},{"$f":"IF(K35=\"\",\" \",K34)","v":" "},{"$f":"IF(L35=\"\",\" \",L34)","v":" "},{"$f":"IF(M35=\"\",\" \",M34)","v":" "},{"$f":"IF(N35=\"\",\" \",N34)","v":" "},{"$f":"IF(O35=\"\",\" \",O34)","v":" "},{"$f":"IF(P35=\"\",\" \",P34)","v":" "}]
[null,"Exploitation - finances"]
[null," Besoin en fond\n de roulement","jours de \nCA HT"," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E42:P42)),0,AVERAGE(E42:P42))","v":{"v":0,"d":"0 j"}},null,{"$f":"IF(ISERROR(AVERAGE(E39:P39)),\" \",AVERAGE(E39:P39))","v":" "}]
[{"$nulls":3}," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E40:P40)),0,AVERAGE(E40:P40))","v":{"v":0,"d":"0 j"}},null,{"$f":"IF(ISBLANK(P40),\" \",Q40)","v":" "}]
[{"$nulls":3}," Ecart",{"$f":"IF(ISBLANK(E40),\" \",E40-E39)","v":" "},{"$f":"IF(ISBLANK(F40),\" \",F40-F39)","v":" "}," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(ISERROR(Q40-Q39),\" \",Q40-Q39)","v":{"v":0,"d":"0 j"}},null,{"$f":"IF(OR(ISBLANK(P39),ISBLANK(P40)),\" \",S40-S39)","v":" "}]
[{"$nulls":4},{"$f":"IF(E40=\"\",\" \",E39)","v":" "},{"$f":"IF(F40=\"\",\" \",F39)","v":" "}," "," "," "," "," "," "," "," "," "," "]
[null," Rotation \n des stocks","jours de \nCA HT"," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E46:P46)),0,AVERAGE(E46:P46))","v":{"v":0,"d":"0 j"}},null,{"$f":"IF(ISERROR(AVERAGE(E43:P43)),\" \",AVERAGE(E43:P43))","v":" "}]
[{"$nulls":3}," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E44:P44)),0,AVERAGE(E44:P44))","v":{"v":0,"d":"0 j"}},null,{"$f":"IF(ISBLANK(P44),\" \",Q44)","v":" "}]
[{"$nulls":3}," Ecart",{"$f":"IF(ISBLANK(E44),\" \",E44-E43)","v":" "},{"$f":"IF(ISBLANK(F44),\" \",F44-F43)","v":" "}," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(ISERROR(Q44-Q43),\" \",Q44-Q43)","v":{"v":0,"d":"0 j"}},null,{"$f":"IF(OR(ISBLANK(P43),ISBLANK(P44)),\" \",S44-S43)","v":" "}]
[{"$nulls":4},{"$f":"IF(E44=\"\",\" \",E43)","v":" "},{"$f":"IF(F44=\"\",\" \",F43)","v":" "}," "," "," "," "," "," "," "," "," "," "]
[null," Stocks \n et produits \n périmés",{"$f":"IF(ISBLANK($C$4),\" \",$C$4)","v":"K€"}," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E51:P51)),0,AVERAGE(E51:P51))","v":{"v":0,"d":"0 "}},null,{"$f":"IF(ISERROR(AVERAGE(E47:P47)),\" \",AVERAGE(E47:P47))","v":" "},{"$f":"IF($T$28=\"K€\",Q47,Q47/1000)","v":0}]
[{"$nulls":3}," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E48:P48)),0,AVERAGE(E48:P48))","v":{"v":0,"d":"0 "}},null,{"$f":"IF(ISBLANK(P48),\" \",Q48)","v":" "},{"$f":"IF($T$28=\"K€\",Q48,Q48/1000)","v":0}]
[{"$nulls":3}," Ecart",{"$f":"IF(ISBLANK(E48),\" \",E48-E47)","v":" "},{"$f":"IF(ISBLANK(F48),\" \",F48-F47)","v":" "}," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(OR(Q47=0,Q48=0),\" \",Q48-Q47)","v":" "},null,{"$f":"IF(OR(ISBLANK(P47),ISBLANK(P48)),\" \",S48-S47)","v":" "}]
[{"$nulls":4},{"$f":"IF(ISERROR(E49/E47),\" \",E49/E47)","v":" "},{"$f":"IF(ISERROR(F49/F47),\" \",F49/F47)","v":" "}," "," "," "," "," "," "," "," "," "," "," ",null,{"$f":"IF(ISERROR(S49/S47),\" \",S49/S47)","v":" "}]
[{"$nulls":4},{"$f":"IF(E48=\"\",\" \",E47)","v":" "},{"$f":"IF(F48=\"\",\" \",F47)","v":" "}," "," "," "," "," "," "," "," "," "," "]
[null," Délai moyen \n de paiement\n clients","jours"," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E55:P55)),0,AVERAGE(E55:P55))","v":{"v":0,"d":"0 j"}},null,{"$f":"IF(ISERROR(AVERAGE(E52:P52)),\" \",AVERAGE(E52:P52))","v":" "}]
[{"$nulls":3}," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E53:P53)),0,AVERAGE(E53:P53))","v":{"v":0,"d":"0 j"}},null,{"$f":"IF(ISBLANK(P53),\" \",Q53)","v":" "}]
[{"$nulls":3}," Ecart",{"$f":"IF(ISBLANK(E53),\" \",E53-E52)","v":" "}," "," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(ISERROR(Q53-Q52),\" \",Q53-Q52)","v":{"v":0,"d":"0 j"}},null,{"$f":"IF(OR(ISBLANK(P52),ISBLANK(P53)),\" \",S53-S52)","v":" "}]
[{"$nulls":4},{"$f":"IF(E53=\"\",\" \",E52)","v":" "},{"$f":"IF(F53=\"\",\" \",F52)","v":" "}," "," "," "," "," "," "," "," "," "," "]
[null," Taux d'impayés","%"," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E59:P59)),0,AVERAGE(E59:P59))","v":{"v":0,"d":"0.0%"}},null,{"$f":"IF(ISERROR(AVERAGE(E56:P56)),\" \",AVERAGE(E56:P56))","v":" "}]
[null," Créances impayées (HT) \n sur CA facturé",null," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E57:P57)),0,AVERAGE(E57:P57))","v":{"v":0,"d":"0.0%"}},null,{"$f":"IF(ISBLANK(P57),\" \",Q57)","v":" "}]
[{"$nulls":3}," Ecart",{"$f":"IF(ISBLANK(E57),\" \",E57-E56)","v":" "},{"$f":"IF(ISBLANK(F57),\" \",F57-F56)","v":" "}," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(ISERROR(Q57-Q56),\" \",Q57-Q56)","v":{"v":0,"d":"0.0%"}},null,{"$f":"IF(OR(ISBLANK(P56),ISBLANK(P57)),\" \",S57-S56)","v":" "}]
[{"$nulls":4},{"$f":"IF(E57=\"\",\" \",E56)","v":" "},{"$f":"IF(F57=\"\",\" \",F56)","v":" "}," "," "," "," "," "," "," "," "," "," ",null,null,{"$f":"IF(ISERROR(S58/S56),\" \",S58/S56)","v":" "}]
[null," Trésorerie \n moyenne",{"$f":"IF(ISBLANK($C$4),\" \",$C$4)","v":"K€"}," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E63:P63)),0,AVERAGE(E63:P63))","v":{"v":0,"d":"0 "}},null,{"$f":"IF(ISERROR(AVERAGE(E60:P60)),\" \",AVERAGE(E60:P60))","v":" "}]
[{"$nulls":3}," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E61:P61)),0,AVERAGE(E61:P61))","v":{"v":0,"d":"0 "}},null,{"$f":"IF(ISBLANK(P61),\" \",Q61)","v":" "}]
[{"$nulls":3}," Ecart",{"$f":"IF(ISBLANK(E61),\" \",E61-E60)","v":" "},{"$f":"IF(ISBLANK(F61),\" \",F61-F60)","v":" "}," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(OR(Q60=0,Q61=0),\" \",Q61-Q60)","v":" "},null,{"$f":"IF(OR(ISBLANK(P60),ISBLANK(P61)),\" \",S61-S60)","v":" "}]
[{"$nulls":4},{"$f":"IF(E61=\"\",\" \",E60)","v":" "}," "," "," "," "," "," "," "," "," "," "," "]
[null," Trésorerie \n minimale \n (point bas)",{"$f":"IF(ISBLANK($C$4),\" \",$C$4)","v":"K€"}," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E67:P67)),0,AVERAGE(E67:P67))","v":{"v":0,"d":"0 "}},null,{"$f":"IF(ISERROR(AVERAGE(E64:P64)),\" \",AVERAGE(E64:P64))","v":" "}]
[{"$nulls":3}," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E65:P65)),0,AVERAGE(E65:P65))","v":{"v":0,"d":"0 "}},null,{"$f":"IF(ISBLANK(P65),\" \",Q65)","v":" "}]
[{"$nulls":3}," Ecart",{"$f":"IF(OR(ISBLANK(E64),ISBLANK(E65)),\" \",E65-E64)","v":" "},{"$f":"IF(OR(ISBLANK(F64),ISBLANK(F65)),\" \",F65-F64)","v":" "}," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(OR(Q64=0,Q65=0),\" \",Q65-Q64)","v":" "},null,{"$f":"IF(OR(ISBLANK(P64),ISBLANK(P65)),\" \",S65-S64)","v":" "}]
[{"$nulls":4},{"$f":"IF(E65=\"\",\" \",E64)","v":" "},{"$f":"IF(F65=\"\",\" \",F64)","v":" "}," "," "," "," "," "," "," "," "," "," "]
[null," Frais\n financiers",{"$f":"IF(ISBLANK($C$4),\" \",$C$4)","v":"K€"}," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(SUM(E73:P73)),0,SUM(E73:P73))","v":{"v":0,"d":"0 "}},null,{"$f":"IF(ISERROR(SUM(E68:P68)),\" \",SUM(E68:P68))","v":{"v":0,"d":"0 "}}]
[{"$nulls":4},{"$f":"IF(ISERROR(E68/E29),\" \",E68/E29)","v":" "},{"$f":"IF(ISERROR(F68/F29),\" \",F68/F29)","v":" "}," "," "," "," "," "," "," "," "," "," "," ",null," "]
[null,null,"%"," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(SUM(E70:P70)),0,SUM(E70:P70))","v":{"v":0,"d":"0 "}},null,{"$f":"IF(ISBLANK(P70),\" \",Q70)","v":" "}]
[{"$nulls":4},{"$f":"IF(ISERROR(E70/E30),\" \",E70/E30)","v":" "},{"$f":"IF(ISERROR(F70/F30),\" \",F70/F30)","v":" "}," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(ISERROR(Q70/Q30),\" \",Q70/Q30)","v":" "},null,{"$f":"IF(ISERROR(S70/S30),\" \",S70/S30)","v":" "}]
[{"$nulls":3}," Ecart",{"$f":"IF(ISERROR(IF(OR(ISBLANK(E68),ISBLANK(E70)),\" \",E71-E69)),\" \",IF(OR(ISBLANK(E68),ISBLANK(E70)),\" \",E71-E69))","v":" "},{"$f":"IF(ISERROR(IF(OR(ISBLANK(F68),ISBLANK(F70)),\" \",F71-F69)),\" \",IF(OR(ISBLANK(F68),ISBLANK(F70)),\" \",F71-F69))","v":" "}," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(ISERROR(IF(OR(Q69=0,Q71=0),\" \",Q71-Q69)),\" \",IF(OR(Q69=0,Q71=0),\" \",Q71-Q69))","v":" "},null,{"$f":"IF(OR(ISBLANK(P68),ISBLANK(P70)),\" \",S71-S69)","v":" "}]
[{"$nulls":4},{"$f":"IF(E70=\"\",\" \",E68)","v":" "},{"$f":"IF(F70=\"\",\" \",F68)","v":" "}," "," "," "," "," "," "," "," "," "," "]
[null,"Ressources humaines"]
[null," Effectif \n total  ETP","Nbre"," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E78:P78)),0,AVERAGE(E78:P78))","v":0},null,{"$f":"IF(ISERROR(AVERAGE(E75:P75)),\" \",AVERAGE(E75:P75))","v":" "},{"$f":"IF(UM=\"K€\",Q75,IF(UM=\"€\",Q75/1000,\" \"))","v":0}]
[{"$nulls":3}," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E76:P76)),0,AVERAGE(E76:P76))","v":0},null,{"$f":"IF(ISBLANK(P76),\" \",Q76)","v":" "},{"$f":"IF(UM=\"K€\",Q76,IF(UM=\"€\",Q76/1000,\" \"))","v":0}]
[null," (salariés  + intérimaires)",null," Ecart",{"$f":"IF(ISBLANK(E76),\" \",E76-E75)","v":" "},{"$f":"IF(ISBLANK(F76),\" \",F76-F75)","v":" "}," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(OR(Q75=0,Q76=0),\" \",Q76-Q75)","v":" "},null,{"$f":"IF(OR(ISBLANK(P75),ISBLANK(P76)),\" \",S76-S75)","v":" "}]
[{"$nulls":4},{"$f":"IF(E76=\"\",\" \",E75)","v":" "},{"$f":"IF(F76=\"\",\" \",F75)","v":" "}," "," "," "," "," "," "," "," "," "," "]
[null," Productivité \n apparente ",{"$f":"IF(ISBLANK($C$4),\" \",$C$4)","v":"K€"}," Objectif",{"$f":"IF(ISERROR(E29/E75),\" \",E29/E75)","v":" "},{"$f":"IF(ISERROR(F29/F75),\" \",F29/F75)","v":" "}," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(ISERROR(AVERAGE(E83:P83)),0,AVERAGE(E83:P83))","v":{"v":0,"d":"0 "}},null,{"$f":"IF(ISERROR(AVERAGE(E79:P79)),\" \",AVERAGE(E79:P79))","v":" "}]
[{"$nulls":3}," Réalisé",{"$f":"IF(ISERROR(E30/E76),\" \",E30/E76)","v":" "},{"$f":"IF(ISERROR(F30/F76),\" \",F30/F76)","v":" "}," "," ",null," "," "," "," "," "," "," ",{"$f":"IF(ISERROR(AVERAGE(E80:P80)),0,AVERAGE(E80:P80))","v":{"v":0,"d":"0 "}},null,{"$f":"IF(ISBLANK(P76),\" \",Q80)","v":" "}]
[null," Chiffre d'affaires \n par personne",null," Ecart",{"$f":"IF(ISERROR(IF(ISBLANK(E80),\" \",E80-E79)),\" \",IF(ISBLANK(E80),\" \",E80-E79))","v":" "}," ",{"$f":"IF(ISERROR(IF(ISBLANK(G80),\" \",G80-G79)),\" \",IF(ISBLANK(G80),\" \",G80-G79))","v":" "},{"$f":"IF(ISERROR(IF(ISBLANK(H80),\" \",H80-H79)),\" \",IF(ISBLANK(H80),\" \",H80-H79))","v":" "}," "," "," "," "," "," "," "," ",{"$f":"IF(ISBLANK(Q80),\" \",Q80-Q79)","v":{"v":0,"d":"0 "}},null,{"$f":"IF(OR(ISBLANK(P75),ISBLANK(P76)),\" \",S80-S79)","v":" "}]
[{"$nulls":4},{"$f":"IF(ISERROR(IF(ISBLANK(E81),\" \",E81/E79)),\" \",IF(ISBLANK(E81),\" \",E81/E79))","v":" "}," ",{"$f":"IF(ISERROR(IF(ISBLANK(G81),\" \",G81/G79)),\" \",IF(ISBLANK(G81),\" \",G81/G79))","v":" "},{"$f":"IF(ISERROR(IF(ISBLANK(H81),\" \",H81/H79)),\" \",IF(ISBLANK(H81),\" \",H81/H79))","v":" "}," "," "," "," "," "," "," "," ",{"$f":"IF(ISERROR(Q81/Q79),\" \",Q81/Q79)","v":" "},null,{"$f":"IF(OR(ISBLANK(P75),ISBLANK(P76)),\" \",S81-S80)","v":" "}]
[{"$nulls":4},{"$f":"IF(E80=\" \",\" \",E79)","v":" "},{"$f":"IF(F80=\" \",\" \",F79)","v":" "}," "," "," "," "," "," "," "," "," "," ",null,null,{"$f":"IF(ISERROR(S81/S79),\" \",S81/S79)","v":" "}]
[null," Taux \n d'absentéisme","%"," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E88:P88)),0,AVERAGE(E88:P88))","v":{"v":0,"d":"0.00%"}},null,{"$f":"IF(ISERROR(AVERAGE(E84:P84)),\" \",AVERAGE(E84:P84))","v":" "}]
[{"$nulls":3}," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E85:P85)),0,AVERAGE(E85:P85))","v":{"v":0,"d":"0.00%"}},null,{"$f":"IF(ISBLANK(P85),\" \",Q85)","v":" "}]
[null," Nbre de jours perdus sur \n nbre de jours travaillés",null," Ecart",{"$f":"IF(ISBLANK(E85),\" \",E85-E84)","v":" "},{"$f":"IF(ISBLANK(F85),\" \",F85-F84)","v":" "}," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(ISERROR(Q85-Q84),\" \",Q85-Q84)","v":{"v":0,"d":"0.00%"}},null,{"$f":"IF(OR(ISBLANK(P84),ISBLANK(P85)),\" \",S85-S84)","v":" "}]
[{"$nulls":4},{"$f":"IF(ISERROR(IF(ISBLANK(E86),\" \",E86-E85)),\" \",IF(ISBLANK(E86),\" \",E86-E85))","v":" "},{"$f":"IF(ISERROR(IF(ISBLANK(F86),\" \",F86-F85)),\" \",IF(ISBLANK(F86),\" \",F86-F85))","v":" "}," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(ISERROR(Q86-Q85),\" \",Q86-Q85)","v":{"v":0,"d":"0.00%"}},null,{"$f":"IF(OR(ISBLANK(P85),ISBLANK(P86)),\" \",S86-S85)","v":" "}]
[{"$nulls":4},{"$f":"IF(E85=\"\",\" \",E84)","v":" "},{"$f":"IF(F85=\"\",\" \",F84)","v":" "}," "," "," "," "," "," "," "," "," "," "]
[null,"Qualité"]
[null," Taux \n de retour","%"," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E93:P93)),0,AVERAGE(E93:P93))","v":{"v":0,"d":"0.00%"}},null,{"$f":"IF(ISERROR(AVERAGE(E90:P90)),\" \",AVERAGE(E90:P90))","v":" "}]
[{"$nulls":3}," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(AVERAGE(E91:P91)),0,AVERAGE(E91:P91))","v":{"v":0,"d":"0.00%"}},null,{"$f":"IF(ISBLANK(P91),\" \",Q91)","v":" "}]
[null," % des produits renvoyés ",null," Ecart",{"$f":"IF(ISBLANK(E91),\" \",E91-E90)","v":" "},{"$f":"IF(ISBLANK(F91),\" \",F91-F90)","v":" "}," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(ISERROR(Q91-Q90),\" \",Q91-Q90)","v":{"v":0,"d":"0.00%"}},null,{"$f":"IF(OR(ISBLANK(P90),ISBLANK(P91)),\" \",S91-S90)","v":" "}]
[{"$nulls":4},{"$f":"IF(E91=\"\",\" \",E90)","v":" "},{"$f":"IF(F91=\"\",\" \",F90)","v":" "}," "," "," "," "," "," "," "," "," "," "]
[null," Nombre de \n réclamations \n clients",null," Objectif",{"$nulls":12},{"$f":"IF(ISERROR(SUM(E98:P98)),0,SUM(E98:P98))","v":0},null,{"$f":"IF(ISERROR(SUM(E94:P94)),\" \",SUM(E94:P94))","v":{"v":0,"d":"0 "}}]
[{"$nulls":3}," Réalisé",{"$nulls":12},{"$f":"IF(ISERROR(SUM(E95:P95)),0,SUM(E95:P95))","v":0},null,{"$f":"IF(ISBLANK(P95),\" \",Q95)","v":" "}]
[{"$nulls":3}," Ecart",{"$f":"IF(ISBLANK(E95),\" \",E95-E94)","v":" "},{"$f":"IF(ISBLANK(F95),\" \",F95-F94)","v":" "}," "," "," "," "," "," "," "," "," "," ",{"$f":"IF(OR(Q94=0,Q95=0),\" \",Q95-Q94)","v":" "},null,{"$f":"IF(OR(ISBLANK(P94),ISBLANK(P95)),\" \",S95-S94)","v":" "}]
[{"$nulls":4},{"$f":"IF(ISERROR(E96/E94),\" \",E96/E94)","v":" "},{"$f":"IF(ISERROR(F96/F94),\" \",F96/F94)","v":" "}," "," "," "," "," "," "," "," "," "," "," ",null,{"$f":"IF(ISERROR(S96/S94),\" \",S96/S94)","v":" "}]
[{"$nulls":4},{"$f":"IF(E95=\"\",\" \",E94)","v":" "},{"$f":"IF(F95=\"\",\" \",F94)","v":" "}," "," "," "," "," "," "," "," "," "," "]