{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Délai moyen de paiement","Jours effectifs de crédit"],"not_rendered":{"charts":2},"read":"whole","date_system":"1900"}

{"sheet":"Délai moyen de paiement","index":0,"n_rows":22,"n_cols":28,"rows_kept":22,"merged":[[1,2,1,3],[1,6,1,8],[1,13,1,14],[1,21,1,22],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,3,9],[3,13,4,13],[3,14,4,14],[3,15,3,19],[3,21,4,21],[3,22,4,22],[3,23,3,27],[4,5,4,8],[4,15,4,18],[4,23,4,26],[21,6,21,7],[21,16,21,17],[21,24,21,25]]}
[]
[{"$f":"IF(ISBLANK(J2),1,\" \")","v":1},null,"Ventes totales",{"$nulls":3},{"$f":"IF(ISBLANK(J2),\"Renseigner le délai cible\",\"Délai cible\")","v":"Renseigner le délai cible"},{"$nulls":6},"Ventes Export",{"$nulls":7},"Ventes France"]
[]
[null,null,"Mois","CA \nmensuel \nTTC","Créances clients","Délai moyen total",{"$nulls":7},"CA \nmensuel \nTTC","Créances clients","Délai moyen Export",{"$nulls":5},"CA \nmensuel \nTTC","Créances clients","Délai moyen France"]
[{"$nulls":5},"Méthode de l'épuisement",{"$nulls":3},"Ratio",{"$nulls":5},"Méthode de l'épuisement",{"$nulls":3},"Ratio",{"$nulls":3},"Méthode de l'épuisement",{"$nulls":3},"Ratio"]
[{"$nulls":8},{"$f":"SUM(F6:H6)","v":{"v":0,"d":"0 J"}},{"$nulls":9},{"$f":"SUM(P6:R6)","v":{"v":0,"d":"0 J"}},null,null,{"$f":"IF((D6-N6)=0,0,D6-N6)","v":{"v":0,"d":"0 "}},{"$f":"IF((E6-O6)=0,0,E6-O6)","v":{"v":0,"d":"0 "}},{"$nulls":3},{"$f":"SUM(X6:Z6)","v":{"v":0,"d":"0 J"}}]
[null,null,{"$f":"IF(ISBLANK($C$6),\" \",EOMONTH(C6,1))","v":" "},{"$nulls":5},{"v":0,"d":"0 J"},{"$nulls":9},{"v":0,"d":"0 J"},null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":3},{"v":0,"d":"0 J"}]
[{"$f":"$J$2","v":{"v":0,"d":"0 jours"}},{"$f":"IF(J8=0,0,1)","v":0},{"$f":"IF(ISBLANK($C$6),\" \",EOMONTH(C7,1))","v":" "},null,null,{"$f":"IF(ISBLANK(D8),0,IF(E8<=D8,E8*30/D8,30))","v":{"v":0,"d":"0 J"}},{"$f":"IF(E8<=D8,0,IF((E8-D8)<=D7,(E8-D8)*30/D7,30))","v":{"v":0,"d":"0 J"}},{"$f":"IF((E8-D8)<=D7,0,(E8-D8-D7)*30/D6)","v":{"v":0,"d":"0 J"}},{"v":0,"d":"0 J"},{"$f":"IF(ISBLANK(E8),0,E8*90/(D6+D7+D8))","v":{"v":0,"d":"0 J"}},null,{"$f":"IF(OR(ISBLANK($J$2),I8=0,J8=0),\" \",IF(J8<$J$2,\"J\",IF(J8>$J$2,\"L\",\"K\")))","v":" "},{"$nulls":3},{"$f":"IF(ISBLANK(N8),0,IF(O8<=N8,O8*30/N8,30))","v":{"v":0,"d":"0 J"}},{"$f":"IF(O8<=N8,0,IF((O8-N8)<=N7,(O8-N8)*30/N7,30))","v":{"v":0,"d":"0 J"}},{"$f":"IF((O8-N8)<=N7,0,(O8-N8-N7)*30/N6)","v":{"v":0,"d":"0 J"}},{"v":0,"d":"0 J"},{"$f":"IF(ISBLANK(O8),0,O8*90/(N6+N7+N8))","v":{"v":0,"d":"0 J"}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"IF(ISERROR(IF(W8<=V8,W8*30/V8,30)),0,IF(W8<=V8,W8*30/V8,30))","v":{"v":0,"d":"0 J"}},{"$f":"IF(W8<=V8,0,IF((W8-V8)<=V7,(W8-V8)*30/V7,30))","v":{"v":0,"d":"0 J"}},{"$f":"IF(ISERROR(IF((W8-V8)<=V7,0,(W8-V8-V7)*30/V6)),0,IF((W8-V8)<=V7,0,(W8-V8-V7)*30/V6))","v":{"v":0,"d":"0 J"}},{"v":0,"d":"0 J"},{"$f":"IF(W8=0,0,W8*90/(V6+V7+V8))","v":{"v":0,"d":"0 J"}}]
[{"$f":"$J$2","v":{"v":0,"d":"0 jours"}},{"$f":"IF(J9=0,0,1)","v":0}," ",null,null,{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"$f":"IF((E9-D9)<=D8,0,(E9-D9-D8)*30/D7)","v":{"v":0,"d":"0 J"}},{"v":0,"d":"0 J"},{"$f":"IF(ISBLANK(E9),0,E9*90/(D7+D8+D9))","v":{"v":0,"d":"0 J"}},null,{"$f":"IF(OR(ISBLANK($J$2),I9=0,J9=0),\" \",IF(J9<$J$2,\"J\",IF(J9>$J$2,\"L\",\"K\")))","v":" "},{"$nulls":3},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"$f":"IF((O9-N9)<=N8,0,(O9-N9-N8)*30/N7)","v":{"v":0,"d":"0 J"}},{"v":0,"d":"0 J"},{"$f":"IF(ISBLANK(O9),0,O9*90/(N7+N8+N9))","v":{"v":0,"d":"0 J"}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"$f":"IF(W9=0,0,W9*90/(V7+V8+V9))","v":{"v":0,"d":"0 J"}}]
[{"v":0,"d":"0 jours"},0," ",null,null,{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"$f":"IF((E10-D10)<=D9,0,(E10-D10-D9)*30/D8)","v":{"v":0,"d":"0 J"}},{"v":0,"d":"0 J"},{"$f":"IF(ISBLANK(E10),0,E10*90/(D8+D9+D10))","v":{"v":0,"d":"0 J"}},null," ",{"$nulls":3},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"$f":"IF((O10-N10)<=N9,0,(O10-N10-N9)*30/N8)","v":{"v":0,"d":"0 J"}},{"v":0,"d":"0 J"},{"$f":"IF(ISBLANK(O10),0,O10*90/(N8+N9+N10))","v":{"v":0,"d":"0 J"}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"$f":"IF(W10=0,0,W10*90/(V8+V9+V10))","v":{"v":0,"d":"0 J"}}]
[{"v":0,"d":"0 jours"},0," ",null,null,{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"$f":"IF((E11-D11)<=D10,0,(E11-D11-D10)*30/D9)","v":{"v":0,"d":"0 J"}},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},null," ",{"$nulls":3},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"$f":"IF((O11-N11)<=N10,0,(O11-N11-N10)*30/N9)","v":{"v":0,"d":"0 J"}},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"$f":"IF(W11=0,0,W11*90/(V9+V10+V11))","v":{"v":0,"d":"0 J"}}]
[{"v":0,"d":"0 jours"},0," ",null,null,{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"$f":"IF((E12-D12)<=D11,0,(E12-D12-D11)*30/D10)","v":{"v":0,"d":"0 J"}},{"v":0,"d":"0 J"},{"$f":"IF(ISBLANK(E12),0,E12*90/(D10+D11+D12))","v":{"v":0,"d":"0 J"}},null," ",{"$nulls":3},{"$f":"IF(ISBLANK(N12),0,IF(O12<=N12,O12*30/N12,30))","v":{"v":0,"d":"0 J"}},{"v":0,"d":"0 J"},{"$f":"IF((O12-N12)<=N11,0,(O12-N12-N11)*30/N10)","v":{"v":0,"d":"0 J"}},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"$f":"IF(W12=0,0,W12*90/(V10+V11+V12))","v":{"v":0,"d":"0 J"}}]
[{"v":0,"d":"0 jours"},0," ",null,null,{"v":0,"d":"0 J"},{"$f":"IF(E13<=D13,0,IF((E13-D13)<=D12,(E13-D13)*30/D12,30))","v":{"v":0,"d":"0 J"}},{"$f":"IF((E13-D13)<=D12,0,(E13-D13-D12)*30/D11)","v":{"v":0,"d":"0 J"}},{"$f":"SUM(F13:H13)","v":{"v":0,"d":"0 J"}},{"v":0,"d":"0 J"},null," ",{"$nulls":3},{"v":0,"d":"0 J"},{"$f":"IF(O13<=N13,0,IF((O13-N13)<=N12,(O13-N13)*30/N12,30))","v":{"v":0,"d":"0 J"}},{"$f":"IF((O13-N13)<=N12,0,(O13-N13-N12)*30/N11)","v":{"v":0,"d":"0 J"}},{"$f":"SUM(P13:R13)","v":{"v":0,"d":"0 J"}},{"v":0,"d":"0 J"},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 J"},{"$f":"IF(W13<=V13,0,IF((W13-V13)<=V12,(W13-V13)*30/V12,30))","v":{"v":0,"d":"0 J"}},{"v":0,"d":"0 J"},{"$f":"SUM(X13:Z13)","v":{"v":0,"d":"0 J"}},{"$f":"IF(W13=0,0,W13*90/(V11+V12+V13))","v":{"v":0,"d":"0 J"}}]
[{"v":0,"d":"0 jours"},0," ",null,null,{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},null," ",{"$nulls":3},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"}]
[{"v":0,"d":"0 jours"},0," ",null,null,{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"$f":"IF(ISBLANK(E15),0,E15*90/(D13+D14+D15))","v":{"v":0,"d":"0 J"}},null," ",{"$nulls":3},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},null,{"$f":"IF((D15-N15)=0,0,D15-N15)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"$f":"IF(ISERROR(IF(W15<=V15,W15*30/V15,30)),0,IF(W15<=V15,W15*30/V15,30))","v":{"v":0,"d":"0 J"}},{"v":0,"d":"0 J"},{"$f":"IF(ISERROR(IF((W15-V15)<=V14,0,(W15-V15-V14)*30/V13)),0,IF((W15-V15)<=V14,0,(W15-V15-V14)*30/V13))","v":{"v":0,"d":"0 J"}},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"}]
[{"v":0,"d":"0 jours"},0," ",null,null,{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"$f":"IF(ISBLANK(E16),0,E16*90/(D14+D15+D16))","v":{"v":0,"d":"0 J"}},null," ",{"$nulls":3},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"}]
[{"v":0,"d":"0 jours"},0," ",null,null,{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},null," ",{"$nulls":3},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"}]
[{"v":0,"d":"0 jours"},0," ",null,null,{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},null," ",{"$nulls":3},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"}]
[{"v":0,"d":"0 jours"},0," ",null,null,{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},null," ",{"$nulls":3},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"}]
[{"v":0,"d":"0 jours"},0," ",null,null,{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},null," ",{"$nulls":3},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"},{"v":0,"d":"0 J"}]
[]
[null,{"$f":"SUM(B8:B21)","v":0},{"$nulls":4},"Moyennes",null,{"$f":"AVERAGE(I8:I20)","v":{"v":0,"d":"0 J"}},{"$f":"AVERAGE(J8:J20)","v":{"v":0,"d":"0 J"}},null,{"$f":"IF(OR(ISBLANK($J$2),I22=0,J22=0,B22<13),\" \",IF(J22<$J$2,\"J\",IF(J22>$J$2,\"L\",\"K\")))","v":" "},{"$nulls":4},"Moyennes",null,{"$f":"AVERAGE(S8:S20)","v":{"v":0,"d":"0 J"}},{"$f":"AVERAGE(T8:T20)","v":{"v":0,"d":"0 J"}},{"$nulls":4},"Moyennes",null,{"$f":"AVERAGE(AA8:AA20)","v":{"v":0,"d":"0 J"}},{"$f":"AVERAGE(AB8:AB20)","v":{"v":0,"d":"0 J"}}]

{"sheet":"Jours effectifs de crédit","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"merged":[[1,1,1,2],[3,1,3,3],[11,1,11,3]]}
[]
[null,"Date de facture"]
[]
[null,"Conditions de règlement"]
[]
[null,"En jours nets \nde facturation",null,"En jours fin de mois de facturation"]
[]
[]
[null,"= Échéance",null,"= Échéance"]
[null,{"$f":"IF(OR(ISBLANK(D2),ISBLANK(B7)),\" \",D2+B7)","v":" "},null,{"$f":"IF(ISBLANK(D2),0,IF(D7=30,EOMONTH(D2,1),IF(D7=60,EOMONTH(D2,2),IF(D7=90,EOMONTH(D2,3),IF(D7=120,EOMONTH(D2,4),IF(D7=150,EOMONTH(D2,5),\" \"))))))","v":"00:00:00"}]
[]
[null,"= Nombre de jours effectifs de crédit"]
[null,{"$f":"IF(OR(ISBLANK(D2),ISBLANK(B7)),0,B10-D2)","v":{"v":0,"d":"0 jours"}},null,{"$f":"IF(OR(ISBLANK(D2),ISBLANK(D7)),0,D10-D2)","v":{"v":0,"d":"0 jours"}}]