{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["CC vide","Exemple"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"CC vide","index":0,"n_rows":57,"n_cols":25,"rows_kept":57,"merged":[[3,14,3,17],[4,3,4,4],[4,8,4,10],[4,17,4,18]]}
[]
[null,"COMPTE COURANT",{"$nulls":3},"Taux créancier :",{"$nulls":8},1.25,null,1.25,"%"]
[{"$nulls":5},"Taux débiteur  :",{"$nulls":8},7,null,7,"%",{"$nulls":6},"Nb de fautes"]
[{"$nulls":5},"Clôture au       :",{"$nulls":4},31,{"$nulls":3},"mars",{"$nulls":3},2007,{"$nulls":5},"par ligne"]
[null,"Date","Libellé","Mouvement",null,"Solde D/C","Solde","D","Val",{"$nulls":5},"n","arrondi","N","Nombres"]
[{"$nulls":3},"Débit","Crédit","C en négatif",null,"C","j",".","m",{"$nulls":4},"solde",null,"Débit","Crédit",{"$nulls":3},"solde débiteur pour comm."]
[{"$nulls":6},{"$f":"D7-E7","v":0},{"$nulls":13},"août",8]
[0,null,"Solde",null,null,{"$f":"IF(D8+E8<>0,F7+D8-E8,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(D8+E8<>0,ABS(F8),0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(G8<>0,IF(F8>0,\"D\",\"C\"),0)","v":0},null,{"$f":"IF(I8>0,\".\",\"\")","v":""},null,{"$f":"IF(I8>0,IF(K8<>2,IF(I8=31,30,I8),IF($L$29=1,IF(I8=29,30,I8),IF(I8=28,30,I8))),$L$23)","v":30},{"$f":"IF(K8=0,$M$23,K8)","v":3},{"$f":"IF(D8+E8<>0,((M9-M8)*30)+(L9-L8),0)","v":0},{"$f":"IF(N8<-200,N8+360,N8)","v":0},{"$f":"ROUND(G8,0)","v":0},{"$f":"ROUND(P8*O8/100,0)","v":0},{"$f":"IF(Q8<>0,IF(H8=\"D\",Q8,0),0)","v":0},{"$f":"IF(Q8<>0,IF(H8=\"C\",Q8,0),0)","v":0},null,"avril",4]
[1,{"$nulls":4},{"$f":"IF(D9+E9<>0,F8+D9-E9,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(D9+E9<>0,ABS(F9),0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(G9<>0,IF(F9>0,\"D\",\"C\"),0)","v":0},null,{"$f":"IF(I9>0,\".\",\"\")","v":""},null,{"$f":"IF(I9>0,IF(K9<>2,IF(I9=31,30,I9),IF($L$29=1,IF(I9=29,30,I9),IF(I9=28,30,I9))),$L$23)","v":30},3,{"$f":"IF(D9+E9<>0,((M10-M9)*30)+(L10-L9),0)","v":0},0,0,0,{"$f":"IF(Q9<>0,IF(H9=\"D\",Q9,0),0)","v":0},{"$f":"IF(Q9<>0,IF(H9=\"C\",Q9,0),0)","v":0},null,"décembre",12,{"$f":"IF(H9=\"D\",G9,0)","v":0},null,0]
[2,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,"février",2,{"$f":"IF(H10=\"D\",G10,0)","v":0},null,0]
[3,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,"janvier",1,0,null,0]
[4,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,"juillet",7,0,null,0]
[5,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,"juin",6,0,null,0]
[6,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,"mai",5,0,null,0]
[7,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,"mars",3,0,null,0]
[8,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,"novembre",11,0,null,0]
[9,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,"octobre",10,0,null,0]
[10,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,"septembre",9,0,null,0]
[11,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,{"$nulls":3},0,null,0]
[12,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,null,{"$f":"LOOKUP(O4,U7:U18,V7:V18)","v":3},0,null,0]
[13,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,{"$nulls":3},0,null,0]
[14,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,{"$nulls":3},0,null,0]
[null,null,"Totaux",{"$f":"SUM(D8:D22)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(E8:E22)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"IF(D23+E23<>0,ABS(F23))","v":false},{"$f":"IF(G23<>0,IF(F23>0,\"D\",\"C\"))","v":"C"},{"$f":"K4","v":31},{"$f":"IF(I23>0,\".\")","v":"."},{"$f":"V20","v":3},30,{"$f":"IF(K23=0,$K$23,K23)","v":3},{"$f":"IF(I24=0,K23,IF(K23<>0,IF(K24<K23,K23-12,K23)))","v":3},{"$f":"SUM(O8:O22)","v":0},0,0,{"$f":"SUM(R8:R22)","v":0},{"$f":"SUM(S8:S22)","v":0},{"$nulls":5},0]
[null,null,"Rés. clôture",{"$f":"E36","v":{"v":9,"d":"9.00"}},{"$f":"F36","v":{"v":0,"d":"0.00"}},{"v":9,"d":"9.00"},{"$f":"IF(D24+E24<>0,ABS(F24))","v":{"v":9,"d":"9.00"}},{"$f":"IF(SUM(E23:E24)>SUM(D23:D24),\"C\",\"D\")","v":"D"},{"$f":"I23","v":31},{"$f":"IF(I24>0,\".\")","v":"."},{"$f":"K23","v":3},{"$nulls":13},0]
[]
[]
[null,"Décompte de clôture :"]
[{"$nulls":4},"Débit","Crédit",{"$nulls":5},"Année :","1=bissextile"]
[null,"Intérêt créancier",null,{"$f":"CONCATENATE(TEXT(O2,\"0.000\"),\" %\")","v":"1.250 %"},null,{"$f":"S23/(360/O2)","v":{"v":0,"d":"0.00"}},null,"C",{"$nulls":3},{"$f":"IF(S4/100=INT(S4/100),IF(S4/400=INT(S4/400),1,0),IF(S4/4=INT(S4/4),1,0))","v":0}]
[null,"Intérêt débiteur",null,{"$f":"CONCATENATE(TEXT(O3,\"0.000\"),\" %\")","v":"7.000 %"},{"$f":"R23/(360/O3)","v":{"v":0,"d":"0.00"}},null,null,"D"]
[null,{"$f":"IF(E31>0,\"Int. débiteur net\",\"Int. créancier net\")","v":"Int. créancier net"},null,null,{"$f":"IF(E30>F29,E30-F29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(F29>E30,F29-E30,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(E31>0,\"D\",\"C\")","v":"C"}]
[null,"Impôt anticipé",null,{"v":0.35,"d":"35%"},{"$f":"F31*0.35","v":{"v":0,"d":"0.00"}},null,null,"D"]
[null,"Frais",null,null,{"v":8,"d":"8.00"},null,null,"D"]
[null,{"$f":"IF(C53=1,\"Commission 1/4 % sur \",IF(C53=3,\"Commission\",\"Commission 1/8 % sur \"))","v":"Commission 1/4 % sur "},null,{"$f":"IF(C53=3,\"\",ROUND(MAX(W9:W22),0))","v":0},{"$f":"IF(MAX(W9:W22)>0,MAX(W9:W22)*C54,0)","v":{"v":0,"d":"0.00"}},null,null,"D"]
[null,"Arrondi",null,null,{"$f":"IF(C55=FALSE,0,ABS(E41-E40))","v":{"v":1,"d":"1.00"}},null,null,"D"]
[null,"Résultat clôture",null,null,{"$f":"IF(E43>F43,E43-F43,0)","v":{"v":9,"d":"9.00"}},{"$f":"IF(F43>E43,F43-E43,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(E39>0,\"D\",\"C\")","v":"D"}]
[{"$nulls":18},"Total fautes",{"$nulls":5},{"$f":"SUM(Y8:Y36)","v":0}]
[null,null,"Totaux clôture avant arrondi",null,{"$f":"SUM(E31:E34)","v":{"v":8,"d":"8.00"}},{"$f":"SUM(F31:F34)","v":{"v":0,"d":"0.00"}}]
[null,null,"résultat clôture avant arrondi",null,{"$f":"IF(E38>F38,E38-F38,0)","v":{"v":8,"d":"8.00"}},{"$f":"IF(F38>E38,F38-E38,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"Résultat final avant arrondi",null,{"$f":"F23+E39-F39","v":{"v":8,"d":"8.00"}}]
[null,null,"Résultat souhaité",null,{"$f":"IF(E40>0,INT(E40+1),INT(E40)+1)","v":{"v":9,"d":"9.00"}}]
[]
[null,null,"Totaux clôture après arrondi",null,{"$f":"E38+E35","v":{"v":9,"d":"9.00"}},{"$f":"F38","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":7}
[null,null,"                     avec couleur  = Ctrl + a"]
[null,null,"                     sans couleur = Ctrl + s"]
[null,"Commission",1]
[null,"Com  %",{"$f":"IF(C53=1,0.0025,IF(C53=3,0,0.00125))","v":0.0025}]
[null,"Arrondi",true]
[null,"Protection",true]
[null,"Fautes",false]

{"sheet":"Exemple","index":1,"n_rows":57,"n_cols":25,"rows_kept":57,"merged":[[3,14,3,17],[4,3,4,4],[4,8,4,10],[4,17,4,18]]}
[]
[null,"COMPTE COURANT",{"$nulls":3},"Taux créancier :",{"$nulls":8},1.25,null,1.25,"%"]
[{"$nulls":5},"Taux débiteur  :",{"$nulls":8},7,null,7,"%",{"$nulls":6},"Nb de fautes"]
[{"$nulls":5},"Clôture au       :",{"$nulls":4},31,{"$nulls":3},"mars",{"$nulls":3},2007,{"$nulls":5},"par ligne"]
[null,"Date","Libellé","Mouvement",null,"Solde","Solde","D","Val",{"$nulls":5},"n","arrondi","N","Nombres"]
[{"$nulls":3},"Débit","Crédit"," !   C = -   ! ",null,"C","j",".","m",{"$nulls":4},"solde",null,"Débit","Crédit",{"$nulls":3},"solde débiteur pour comm."]
[{"$nulls":6},{"$f":"D7-E7","v":0},{"$nulls":13},"août",8]
[0,"2005-12-31","Solde",{"v":3525.3,"d":"3,525.30"},null,{"$f":"IF(D8+E8<>0,F7+D8-E8,0)","v":{"v":3525.3,"d":"3,525.30"}},{"$f":"IF(D8+E8<>0,ABS(F8),0)","v":{"v":3525.3,"d":"3,525.30"}},{"$f":"IF(G8<>0,IF(F8>0,\"D\",\"C\"),0)","v":"D"},30,{"$f":"IF(I8>0,\".\",\"\")","v":"."},12,{"$f":"IF(I8>0,IF(K8<>2,IF(I8=31,30,I8),IF($L$29=1,IF(I8=29,30,I8),IF(I8=28,30,I8))),$L$23)","v":30},{"$f":"IF(K8=0,$M$23,K8)","v":12},{"$f":"IF(D8+E8<>0,((M9-M8)*30)+(L9-L8),0)","v":-349},{"$f":"IF(N8<-200,N8+360,N8)","v":11},{"$f":"ROUND(G8,0)","v":3525},{"$f":"ROUND(P8*O8/100,0)","v":388},{"$f":"IF(Q8<>0,IF(H8=\"D\",Q8,0),0)","v":388},{"$f":"IF(Q8<>0,IF(H8=\"C\",Q8,0),0)","v":0},null,"avril",4]
[1,"2006-01-10","Versement",null,{"v":22000,"d":"22,000.00"},{"v":-18474.7,"d":"-18,474.70"},{"v":18474.7,"d":"18,474.70"},"C",11,".",1,11,1,79,79,18475,14595,0,14595,null,"décembre",12,{"$f":"IF(H9=\"D\",G9,0)","v":0},null,0]
[2,null,null,{"v":50000,"d":"50,000.00"},null,{"v":31525.3,"d":"31,525.30"},{"v":31525.3,"d":"31,525.30"},"D",null,"",null,30,3,0,0,31525,0,0,0,null,"février",2,31525.3,null,0]
[3,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,"janvier",1,0,null,0]
[4,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,"juillet",7,0,null,0]
[5,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,"juin",6,0,null,0]
[6,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,"mai",5,0,null,0]
[7,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,"mars",3,0,null,0]
[8,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,"novembre",11,0,null,0]
[9,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,"octobre",10,0,null,0]
[10,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,"septembre",9,0,null,0]
[11,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,{"$nulls":3},0,null,0]
[12,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,null,null,{"$f":"LOOKUP(O4,U7:U18,V7:V18)","v":3},0,null,0]
[13,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,{"$nulls":3},0,null,0]
[14,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0,null,"",null,30,3,0,0,0,0,0,0,{"$nulls":3},0,null,0]
[null,null,"Totaux",{"$f":"SUM(D8:D22)","v":{"v":53525.3,"d":"53,525.30"}},{"$f":"SUM(E8:E22)","v":{"v":22000,"d":"22,000.00"}},{"v":31525.300000000003,"d":"31,525.30"},{"$f":"IF(D23+E23<>0,ABS(F23))","v":{"v":31525.300000000003,"d":"31,525.30"}},{"$f":"IF(G23<>0,IF(F23>0,\"D\",\"C\"))","v":"D"},{"$f":"K4","v":31},{"$f":"IF(I23>0,\".\")","v":"."},{"$f":"V20","v":3},30,{"$f":"IF(K23=0,$K$23,K23)","v":3},{"$f":"IF(I24=0,K23,IF(K23<>0,IF(K24<K23,K23-12,K23)))","v":3},{"$f":"SUM(O8:O22)","v":90},31525,28373,{"$f":"SUM(R8:R22)","v":388},{"$f":"SUM(S8:S22)","v":14595},{"$nulls":5},0]
[null,null,"Rés. clôture",{"$f":"E36","v":{"v":19.699999999997644,"d":"19.70"}},{"$f":"F36","v":{"v":0,"d":"0.00"}},{"v":31545,"d":"31,545.00"},{"$f":"IF(D24+E24<>0,ABS(F24))","v":{"v":31545,"d":"31,545.00"}},{"$f":"IF(SUM(E23:E24)>SUM(D23:D24),\"C\",\"D\")","v":"D"},{"$f":"I23","v":31},{"$f":"IF(I24>0,\".\")","v":"."},{"$f":"K23","v":3},{"$nulls":13},0]
[]
[]
[null,"Décompte de clôture :",{"$nulls":16},"zone à remplir"]
[{"$nulls":4},"Débit","Crédit",{"$nulls":5},"Année :","1=bissextile"]
[null,"Intérêt créancier",null,{"$f":"CONCATENATE(TEXT(O2,\"0.000\"),\" %\")","v":"1.250 %"},null,{"$f":"S23/(360/O2)","v":{"v":50.677083333333336,"d":"50.68"}},null,"C",{"$nulls":3},{"$f":"IF(S4/100=INT(S4/100),IF(S4/400=INT(S4/400),1,0),IF(S4/4=INT(S4/4),1,0))","v":0},{"$nulls":6},"zone protégée"]
[null,"Intérêt débiteur",null,{"$f":"CONCATENATE(TEXT(O3,\"0.000\"),\" %\")","v":"7.000 %"},{"$f":"R23/(360/O3)","v":{"v":7.544444444444444,"d":"7.54"}},null,null,"D"]
[null,{"$f":"IF(E31>0,\"Int. débiteur net\",\"Int. créancier net\")","v":"Int. créancier net"},null,null,{"$f":"IF(E30>F29,E30-F29,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(F29>E30,F29-E30,0)","v":{"v":43.13263888888889,"d":"43.13"}},null,{"$f":"IF(E31>0,\"D\",\"C\")","v":"C"}]
[null,"Impôt anticipé",null,{"v":0.35,"d":"35%"},{"$f":"F31*0.35","v":{"v":15.096423611111112,"d":"15.10"}},null,null,"D"]
[null,"Frais",null,null,{"v":8,"d":"8.00"},null,null,"D"]
[null,{"$f":"IF(C53=1,\"Commission 1/4 % sur \",IF(C53=3,\"Commission\",\"Commission 1/8 % sur \"))","v":"Commission 1/8 % sur "},null,{"$f":"IF(C53=3,\"\",ROUND(MAX(W9:W22),0))","v":31525},{"$f":"IF(MAX(W9:W22)>0,MAX(W9:W22)*C54,0)","v":{"v":39.406625,"d":"39.41"}},null,null,"D"]
[null,"Arrondi",null,null,{"$f":"IF(C55=FALSE,0,ABS(E41-E40))","v":{"v":0.3295902777754236,"d":"0.33"}},null,null,"D"]
[null,"Résultat clôture",null,null,{"$f":"IF(E43>F43,E43-F43,0)","v":{"v":19.699999999997644,"d":"19.70"}},{"$f":"IF(F43>E43,F43-E43,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(E39>0,\"D\",\"C\")","v":"D"}]
[{"$nulls":18},"Total fautes",{"$nulls":5},{"$f":"SUM(Y8:Y36)","v":0}]
[null,null,"Totaux clôture avant arrondi",null,{"$f":"SUM(E31:E34)","v":{"v":62.50304861111111,"d":"62.50"}},{"$f":"SUM(F31:F34)","v":{"v":43.13263888888889,"d":"43.13"}}]
[null,null,"résultat clôture avant arrondi",null,{"$f":"IF(E38>F38,E38-F38,0)","v":{"v":19.37040972222222,"d":"19.37"}},{"$f":"IF(F38>E38,F38-E38,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"Résultat final avant arrondi",null,{"$f":"F23+E39-F39","v":{"v":31544.670409722225,"d":"31,544.67"}}]
[null,null,"Résultat souhaité",null,{"$f":"IF(E40>0,INT(E40+1),INT(E40)+1)","v":{"v":31545,"d":"31,545.00"}}]
[]
[null,null,"Totaux clôture après arrondi",null,{"$f":"E38+E35","v":{"v":62.832638888886535,"d":"62.83"}},{"$f":"F38","v":{"v":43.13263888888889,"d":"43.13"}}]
{"$rows_empty":7}
[null,null,"                     avec couleur = Ctrl + a"]
[null,null,"                     sans couleur = Ctrl + s"]
[null,"Commission",2]
[null,"Com  %",{"$f":"IF(C53=1,0.0025,IF(C53=3,0,0.00125))","v":1.25E-3}]
[null,"Arrondi",true]
[null,"Protection",true]
[null,"Fautes",false]