{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Frais annuel 22","Feuil1","Feuil2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"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":"Frais annuel 22","index":0,"n_rows":435,"n_cols":171,"rows_kept":435,"cut":false,"hidden":false,"merged":[[2,0,2,1],[431,10,431,12],[431,13,431,14],[431,4,431,5],[431,1,431,3],[429,7,429,9],[358,14,358,15],[394,14,394,15],[394,10,394,12],[394,4,394,5],[362,0,393,0],[396,3,396,5],[428,4,428,5],[395,0,395,2],[428,10,428,12],[398,0,427,0],[395,14,395,15],[359,14,359,15],[214,4,214,5],[36,3,36,5],[72,3,72,5],[144,3,144,5],[178,4,178,5],[252,3,252,5],[432,5,432,7],[432,1,432,2],[434,12,434,13],[433,10,433,12],[322,14,322,15],[322,4,322,5],[288,3,288,5],[286,4,286,5],[286,10,286,12],[428,14,428,15],[324,3,324,5],[360,3,360,5],[358,4,358,5],[358,10,358,12],[325,0,325,1],[429,0,429,1],[216,3,216,5],[250,4,250,5],[1,7,1,9],[2,7,2,9],[106,10,106,12],[106,14,106,15],[142,4,142,5],[106,4,106,5],[70,10,70,12],[70,14,70,15],[70,4,70,5],[34,4,34,5],[34,10,34,12],[34,14,34,15],[178,14,178,15],[142,10,142,12],[142,14,142,15],[178,10,178,12],[107,14,107,15],[71,14,71,15],[35,14,35,15],[180,3,180,5],[108,3,108,5],[143,14,143,15],[443,0,443,1],[442,0,442,1],[251,0,251,2],[143,0,143,2],[323,0,323,2],[215,0,215,2],[146,0,177,0],[182,0,213,0],[287,0,287,2],[253,0,253,1],[289,0,289,1],[217,0,217,1],[3,0,33,0],[38,0,69,0],[74,0,105,0],[110,0,141,0],[218,0,249,0],[361,0,361,1],[326,0,357,0],[254,0,285,0],[73,0,73,1],[109,0,109,1],[35,0,35,2],[71,0,71,2],[107,0,107,2],[37,0,37,1],[359,0,359,2],[290,0,321,0],[445,0,445,1],[438,0,438,1],[439,0,439,1],[440,0,440,1],[441,0,441,1],[397,0,397,1],[145,0,145,1],[181,0,181,1],[179,14,179,15],[179,0,179,2],[214,10,214,12],[214,14,214,15],[323,14,323,15],[287,14,287,15],[251,14,251,15],[215,14,215,15],[322,10,322,12],[286,14,286,15],[250,10,250,12],[250,14,250,15],[444,0,444,1],[436,0,436,1],[437,0,437,1],[435,0,435,1]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(V3:V11)","v":3},null,{"$f":"COUNTA(X3:X11)","v":3},null,5,null,4]
[null,null,null,null,null,null,null,"SOLDE",null,null,null,null,null,null,"Frais Annuel   ",null,null,null,"CODES",null,"SS/CODES","CO",null,"VO",null,"LO",null,"MA"]
["VALIDE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Courses","CO",null,"ALI","Alimentation","ESS","Essence","CIN","Ciné","DEC","Déco"]
["JANVIER","Date","Désignation","Crédit","   V","Code","S/C","Valeur","Solde","Valeur","Code","S/C","V/D","Débit","Désignation","Date",null,null,"Voiture","VO",null,"BRI","Bricolage","REP","Réparation","RES","Resto","MEU","Meuble"]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(D5,E5,\"V\")","v":0},{"$f":"IF(H5<>\"\",H5+H3+J5)","v":0},{"$f":"(SUMIFS(N5,M5,\"V\"))*-1","v":0},null,null,"v",null,"Cartes Mois précédent",null,1,null,"Loisirs","LO",null,"PHA","Pharmacie","REV","Révision","THE","Théatre","DEP","Dépannage",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,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,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,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,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,null,null,null,null,null,null,null,null,null,null,null,"S"]
[null,null,{"$f":"IF(F6=\"\",\"\",VLOOKUP(F6,X:Z,2,0))","v":""},null,null,null,null,0,{"$f":"IF(H6<>\"\",H6+I5+J6)","v":0},{"$f":"(SUMIFS(N6,M6,\"V\"))*-1","v":0},"MA","ELM",null,null,{"$f":"IF(K6=\"\",\"\",VLOOKUP(L6,OFFSET(U:V,,MATCH(K6,$V$2:$AB$2,0)),2,0))","v":"Electro menager"},null,2,null,"Maison","MA",null,null,null,null,null,"VIS","Visite","ELM","Electro menager"]
[null,null,{"$f":"IF(F7=\"\",\"\",VLOOKUP(F7,X:Z,2,0))","v":""},null,null,null,null,0,0,0,"LO","RES",null,null,{"$f":"IF(K7=\"\",\"\",VLOOKUP(L7,OFFSET(U:V,,MATCH(K7,$V$2:$AB$2,0)),2,0))","v":"Resto"},null,3,null,null,null,null,null,null,null,null,"LIV","Livres"]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,4,"D","La liste des codes est établie une fois pour toute"]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,5,"V","en principe en colo,nne T"]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,6,null,"Puis retransposée en ligne 2"]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,7,"V","Les listes des sous code peuvent s'allonger"]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,8,null,"elles sont rendues dynamiques "]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,9,null,"par la formule de validation de données"]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,10,null,"des cellules de la colonne L"]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,11,null,"=DECALER($U$3;;EQUIV(K6;$V$2:$AB$2;0);INDEX($V$1:$AB$1;;EQUIV(K6;$V$2:$AB$2;0)))"]
[null,null,"",null,null,null,null,0,{"$f":"IF(H16<>\"\",H16+I15+J16)","v":0},0,null,null,null,null,"",null,12,null,"le nombre d'items de chaque liste étant comptabilisé en ligne 1"]
[null,null,"",null,null,null,null,0,{"$f":"IF(H17<>\"\",H17+I16+J17)","v":0},0,null,null,null,null,"",null,13,"KIKO"]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,14,"VALIDE"]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,15]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,16]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,17]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,18]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,19]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,20]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,21]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,22]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,23]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,24]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,25]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,26]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,27]
[null,null,"",null,null,null,null,0,{"$f":"IF(H32<>\"\",H32+I31+J32)","v":0},0,null,null,null,null,"",null,28]
[null,null,"",null,null,null,null,0,{"$f":"IF(H33<>\"\",H33+I32+J33)","v":0},0,null,null,null,null,"",null,29]
[null,null,"",null,null,null,null,0,{"$f":"IF(H34<>\"\",H34+I33+J34)","v":0},0,null,null,null,null,"",null,30]
[null,null,"Crédit non Validé",{"$f":"SUM(D5:D34)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(H5:H34,E5:E34,\"V\")","v":0},{"$f":"H35+J35","v":0},{"$f":"SUMIFS(J5:J34,M5:M34,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(N5:N34)-N40","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,{"$f":"E432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"P434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A4","v":"JANVIER"},null,null,null,null,{"$f":"VLOOKUP(9^9,I$5:I$34,1)","v":0},null,null,null,null,null,{"$f":"C2","v":0}]
["KIKO"]
["FEVRIER","Date","Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(D40,E40,\"V\")","v":0},{"$f":"IF(H40<>\"\",H40+H38+J40)","v":0},{"$f":"(SUMIFS(N40,M40,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(N5:N34,M5:M34,\"D\")","v":0},"Cartes Mois précédent",null,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,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,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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S"]
[null,null,null,null,null,null,null,0,{"$f":"IF(H41<>\"\",H41+I40+J41)","v":0},0,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,5]
[null,null,{"$f":"IF(F45=\"\",\"\",VLOOKUP(F45,X:Z,2,0))","v":""},null,null,null,null,0,0,0,null,null,null,null,{"$f":"IF(K45=\"\",\"\",VLOOKUP(K45,T:U,2,0))","v":""},null,6]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,7]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,8]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,9]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,10]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,11]
[null,null,"",null,null,null,null,0,{"$f":"IF(H51<>\"\",H51+I50+J51)","v":0},0,null,null,null,null,"",null,12]
[null,null,"",null,null,null,null,0,{"$f":"IF(H52<>\"\",H52+I51+J52)","v":0},0,null,null,null,null,"",null,13]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,14]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,15]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,16]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,17]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,18]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,19]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,20]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,21]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,22]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,23]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,24]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,25]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,26]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,27]
[null,null,"",null,null,null,null,0,{"$f":"IF(H67<>\"\",H67+I66+J67)","v":0},0,null,null,null,null,"",null,28]
[null,null,"",null,null,null,null,0,{"$f":"IF(H68<>\"\",H68+I67+J68)","v":0},0,null,null,null,null,"",null,29]
[null,null,"",null,null,null,null,0,{"$f":"IF(H69<>\"\",H69+I68+J69)","v":0},0,null,null,null,null,"",null,30]
[null,null,{"$f":"IF(F70=\"\",\"\",VLOOKUP(F70,X:Z,2,0))","v":""},null,null,null,null,{"$f":"SUMIFS(D70,E70,\"V\")","v":0},{"$f":"IF(H70<>\"\",H70+I69+J70)","v":0},{"$f":"(SUMIFS(N70,M70,\"V\"))*-1","v":0},null,null,null,null,{"$f":"IF(K70=\"\",\"\",VLOOKUP(K70,T:U,2,0))","v":""},null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D40:D70)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(H40:H70,E40:E70,\"V\")","v":0},{"$f":"H71+J71","v":0},{"$f":"SUMIFS(J40:J70,M40:M70,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(N40:N70)-N76","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,{"$f":"E432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"P434","v":0},"Possibilité investissement SUR Validé"]
["P",null,"Protection données du mois",{"$f":"A39","v":"FEVRIER"},null,null,null,null,{"$f":"VLOOKUP(9^9,I$40:I$70,1)","v":0},null,null,null,null,null,{"$f":"O37","v":0}]
["KIKO"]
["MARS","Date","Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(D76,E76,\"V\")","v":0},{"$f":"IF(H76<>\"\",H76+H74+J76)","v":0},{"$f":"(SUMIFS(N76,M76,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(N40:N70,M40:M70,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,null,0,{"$f":"IF(H77<>\"\",H77+I76+J77)","v":0},0,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,5]
[null,null,{"$f":"IF(F81=\"\",\"\",VLOOKUP(F81,X:Z,2,0))","v":""},null,null,null,null,0,0,0,null,null,null,null,{"$f":"IF(K81=\"\",\"\",VLOOKUP(K81,T:U,2,0))","v":""},null,6]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,7]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,8]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,9]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,10]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,11]
[null,null,"",null,null,null,null,0,{"$f":"IF(H87<>\"\",H87+I86+J87)","v":0},0,null,null,null,null,"",null,12]
[null,null,"",null,null,null,null,0,{"$f":"IF(H88<>\"\",H88+I87+J88)","v":0},0,null,null,null,null,"",null,13]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,14]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,15]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,16]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,17]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,18]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,19]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,20]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,21]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,22]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,23]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,24]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,25]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,26]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,27]
[null,null,"",null,null,null,null,0,{"$f":"IF(H103<>\"\",H103+I102+J103)","v":0},0,null,null,null,null,"",null,28]
[null,null,"",null,null,null,null,0,{"$f":"IF(H104<>\"\",H104+I103+J104)","v":0},0,null,null,null,null,"",null,29]
[null,null,"",null,null,null,null,0,{"$f":"IF(H105<>\"\",H105+I104+J105)","v":0},0,null,null,null,null,"",null,30]
[null,null,"",null,null,null,null,0,{"$f":"IF(H106<>\"\",H106+I105+J106)","v":0},0,null,null,null,null,"",null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D76:D106)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(H76:H106,E76:E106,\"V\")","v":0},{"$f":"H107+J107","v":0},{"$f":"SUMIFS(J76:J106,M76:M106,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(N76:N106)-N112","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,{"$f":"E432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"P434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A75","v":"MARS"},null,null,null,null,{"$f":"VLOOKUP(9^9,I$76:I$106,1)","v":0},null,null,null,null,null,{"$f":"O73","v":0}]
["KIKO"]
["AVRIL","Date","Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(D112,E112,\"V\")","v":0},{"$f":"IF(H112<>\"\",H112+H110+J112)","v":0},{"$f":"(SUMIFS(N112,M112,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(N76:N106,M76:M106,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,null,0,{"$f":"IF(H113<>\"\",H113+I112+J113)","v":0},0,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,5]
[null,null,{"$f":"IF(F117=\"\",\"\",VLOOKUP(F117,X:Z,2,0))","v":""},null,null,null,null,0,0,0,null,null,null,null,{"$f":"IF(K117=\"\",\"\",VLOOKUP(K117,T:U,2,0))","v":""},null,6]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,7]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,8]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,9]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,10]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,11]
[null,null,"",null,null,null,null,0,{"$f":"IF(H123<>\"\",H123+I122+J123)","v":0},0,null,null,null,null,"",null,12]
[null,null,"",null,null,null,null,0,{"$f":"IF(H124<>\"\",H124+I123+J124)","v":0},0,null,null,null,null,"",null,13]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,14]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,15]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,16]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,17]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,18]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,19]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,20]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,21]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,22]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,23]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,24]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,25]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,26]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,27]
[null,null,"",null,null,null,null,0,{"$f":"IF(H139<>\"\",H139+I138+J139)","v":0},0,null,null,null,null,"",null,28]
[null,null,"",null,null,null,null,0,{"$f":"IF(H140<>\"\",H140+I139+J140)","v":0},0,null,null,null,null,"",null,29]
[null,null,"",null,null,null,null,0,{"$f":"IF(H141<>\"\",H141+I140+J141)","v":0},0,null,null,null,null,"",null,30]
[null,null,"",null,null,null,null,0,{"$f":"IF(H142<>\"\",H142+I141+J142)","v":0},0,null,null,null,null,"",null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D112:D142)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(H112:H142,E112:E142,\"V\")","v":0},{"$f":"H143+J143","v":0},{"$f":"SUMIFS(J112:J142,M112:M142,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(N112:N142)-N148","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,{"$f":"E432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"P434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A111","v":"AVRIL"},null,null,null,null,{"$f":"VLOOKUP(9^9,I$112:I$142,1)","v":0},null,null,null,null,null,{"$f":"O109","v":0}]
["KIKO"]
["MAI","Date","Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(D148,E148,\"V\")","v":0},{"$f":"IF(H148<>\"\",H148+H146+J148)","v":0},{"$f":"(SUMIFS(N148,M148,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(N112:N142,M112:M142,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,null,0,{"$f":"IF(H149<>\"\",H149+I148+J149)","v":0},0,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,5]
[null,null,{"$f":"IF(F153=\"\",\"\",VLOOKUP(F153,X:Z,2,0))","v":""},null,null,null,null,0,0,0,null,null,null,null,{"$f":"IF(K153=\"\",\"\",VLOOKUP(K153,T:U,2,0))","v":""},null,6]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,7]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,8]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,9]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,10]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,11]
[null,null,"",null,null,null,null,0,{"$f":"IF(H159<>\"\",H159+I158+J159)","v":0},0,null,null,null,null,"",null,12]
[null,null,"",null,null,null,null,0,{"$f":"IF(H160<>\"\",H160+I159+J160)","v":0},0,null,null,null,null,"",null,13]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,14]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,15]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,16]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,17]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,18]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,19]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,20]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,21]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,22]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,23]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,24]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,25]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,26]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,27]
[null,null,"",null,null,null,null,0,{"$f":"IF(H175<>\"\",H175+I174+J175)","v":0},0,null,null,null,null,"",null,28]
[null,null,"",null,null,null,null,0,{"$f":"IF(H176<>\"\",H176+I175+J176)","v":0},0,null,null,null,null,"",null,29]
[null,null,"",null,null,null,null,0,{"$f":"IF(H177<>\"\",H177+I176+J177)","v":0},0,null,null,null,null,"",null,30]
[null,null,"",null,null,null,null,0,{"$f":"IF(H178<>\"\",H178+I177+J178)","v":0},0,null,null,null,null,"",null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D148:D178)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(H148:H178,E148:E178,\"V\")","v":0},{"$f":"H179+J179","v":0},{"$f":"SUMIFS(J148:J178,M148:M178,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(N148:N178)-N184","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,{"$f":"E432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"P434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A147","v":"MAI"},null,null,null,null,{"$f":"VLOOKUP(9^9,I$148:I$178,1)","v":0},null,null,null,null,null,{"$f":"O145","v":0}]
["KIKO"]
["JUIN","Date","Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(D184,E184,\"V\")","v":0},{"$f":"IF(H184<>\"\",H184+H182+J184)","v":0},{"$f":"(SUMIFS(N184,M184,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(N148:N178,M148:M178,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,null,0,{"$f":"IF(H185<>\"\",H185+I184+J185)","v":0},0,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,5]
[null,null,{"$f":"IF(F189=\"\",\"\",VLOOKUP(F189,X:Z,2,0))","v":""},null,null,null,null,0,0,0,null,null,null,null,{"$f":"IF(K189=\"\",\"\",VLOOKUP(K189,T:U,2,0))","v":""},null,6]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,7]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,8]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,9]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,10]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,11]
[null,null,"",null,null,null,null,0,{"$f":"IF(H195<>\"\",H195+I194+J195)","v":0},0,null,null,null,null,"",null,12]
[null,null,"",null,null,null,null,0,{"$f":"IF(H196<>\"\",H196+I195+J196)","v":0},0,null,null,null,null,"",null,13]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,14]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,15]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,16]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,17]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,18]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,19]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,20]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,21]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,22]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,23]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,24]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,25]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,26]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,27]
[null,null,"",null,null,null,null,0,{"$f":"IF(H211<>\"\",H211+I210+J211)","v":0},0,null,null,null,null,"",null,28]
[null,null,"",null,null,null,null,0,{"$f":"IF(H212<>\"\",H212+I211+J212)","v":0},0,null,null,null,null,"",null,29]
[null,null,"",null,null,null,null,0,{"$f":"IF(H213<>\"\",H213+I212+J213)","v":0},0,null,null,null,null,"",null,30]
[null,null,"",null,null,null,null,0,{"$f":"IF(H214<>\"\",H214+I213+J214)","v":0},0,null,null,null,null,"",null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D184:D214)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(H184:H214,E184:E214,\"V\")","v":0},{"$f":"H215+J215","v":0},{"$f":"SUMIFS(J184:J214,M184:M214,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(N184:N214)-N220","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,{"$f":"E432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"P434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A183","v":"JUIN"},null,null,null,null,{"$f":"VLOOKUP(9^9,I$184:I$214,1)","v":0},null,null,null,null,null,{"$f":"O181","v":0}]
["KIKO"]
["JUILLET","Date","Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(D220,E220,\"V\")","v":0},{"$f":"IF(H220<>\"\",H220+H218+J220)","v":0},{"$f":"(SUMIFS(N220,M220,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(N184:N214,M184:M214,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,null,0,{"$f":"IF(H221<>\"\",H221+I220+J221)","v":0},0,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,5]
[null,null,{"$f":"IF(F225=\"\",\"\",VLOOKUP(F225,X:Z,2,0))","v":""},null,null,null,null,0,0,0,null,null,null,null,{"$f":"IF(K225=\"\",\"\",VLOOKUP(K225,T:U,2,0))","v":""},null,6]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,7]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,8]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,9]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,10]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,11]
[null,null,"",null,null,null,null,0,{"$f":"IF(H231<>\"\",H231+I230+J231)","v":0},0,null,null,null,null,"",null,12]
[null,null,"",null,null,null,null,0,{"$f":"IF(H232<>\"\",H232+I231+J232)","v":0},0,null,null,null,null,"",null,13]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,14]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,15]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,16]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,17]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,18]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,19]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,20]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,21]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,22]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,23]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,24]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,25]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,26]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,27]
[null,null,"",null,null,null,null,0,{"$f":"IF(H247<>\"\",H247+I246+J247)","v":0},0,null,null,null,null,"",null,28]
[null,null,"",null,null,null,null,0,{"$f":"IF(H248<>\"\",H248+I247+J248)","v":0},0,null,null,null,null,"",null,29]
[null,null,"",null,null,null,null,0,{"$f":"IF(H249<>\"\",H249+I248+J249)","v":0},0,null,null,null,null,"",null,30]
[null,null,"",null,null,null,null,0,{"$f":"IF(H250<>\"\",H250+I249+J250)","v":0},0,null,null,null,null,"",null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D220:D250)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(H220:H250,E220:E250,\"V\")","v":0},{"$f":"H251+J251","v":0},{"$f":"SUMIFS(J220:J250,M220:M250,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(N220:N250)-N256","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,{"$f":"E432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"P434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A219","v":"JUILLET"},null,null,null,null,{"$f":"VLOOKUP(9^9,I$220:I$250,1)","v":0},null,null,null,null,null,{"$f":"O217","v":0}]
["KIKO"]
["AOÛT","Date","Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(D256,E256,\"V\")","v":0},{"$f":"IF(H256<>\"\",H256+H254+J256)","v":0},{"$f":"(SUMIFS(N256,M256,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(N220:N250,M220:M250,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,null,0,{"$f":"IF(H257<>\"\",H257+I256+J257)","v":0},0,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,5]
[null,null,{"$f":"IF(F261=\"\",\"\",VLOOKUP(F261,X:Z,2,0))","v":""},null,null,null,null,0,0,0,null,null,null,null,{"$f":"IF(K261=\"\",\"\",VLOOKUP(K261,T:U,2,0))","v":""},null,6]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,7]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,8]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,9]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,10]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,11]
[null,null,"",null,null,null,null,0,{"$f":"IF(H267<>\"\",H267+I266+J267)","v":0},0,null,null,null,null,"",null,12]
[null,null,"",null,null,null,null,0,{"$f":"IF(H268<>\"\",H268+I267+J268)","v":0},0,null,null,null,null,"",null,13]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,14]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,15]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,16]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,17]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,18]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,19]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,20]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,21]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,22]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,23]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,24]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,25]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,26]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,27]
[null,null,"",null,null,null,null,0,{"$f":"IF(H283<>\"\",H283+I282+J283)","v":0},0,null,null,null,null,"",null,28]
[null,null,"",null,null,null,null,0,{"$f":"IF(H284<>\"\",H284+I283+J284)","v":0},0,null,null,null,null,"",null,29]
[null,null,"",null,null,null,null,0,{"$f":"IF(H285<>\"\",H285+I284+J285)","v":0},0,null,null,null,null,"",null,30]
[null,null,"",null,null,null,null,0,{"$f":"IF(H286<>\"\",H286+I285+J286)","v":0},0,null,null,null,null,"",null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D256:D286)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(H256:H286,E256:E286,\"V\")","v":0},{"$f":"H287+J287","v":0},{"$f":"SUMIFS(J256:J286,M256:M286,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(N256:N286)-N292","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,{"$f":"E432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"P434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A255","v":"AOÛT"},null,null,null,null,{"$f":"VLOOKUP(9^9,I$256:I$286,1)","v":0},null,null,null,null,null,{"$f":"O253","v":0}]
["KIKO"]
["SEPTEMBRE","Date","Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(D292,E292,\"V\")","v":0},{"$f":"IF(H292<>\"\",H292+H290+J292)","v":0},{"$f":"(SUMIFS(N292,M292,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(N256:N286,M256:M286,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,null,0,{"$f":"IF(H293<>\"\",H293+I292+J293)","v":0},0,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,5]
[null,null,{"$f":"IF(F297=\"\",\"\",VLOOKUP(F297,X:Z,2,0))","v":""},null,null,null,null,0,0,0,null,null,null,null,{"$f":"IF(K297=\"\",\"\",VLOOKUP(K297,T:U,2,0))","v":""},null,6]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,7]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,8]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,9]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,10]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,11]
[null,null,"",null,null,null,null,0,{"$f":"IF(H303<>\"\",H303+I302+J303)","v":0},0,null,null,null,null,"",null,12]
[null,null,"",null,null,null,null,0,{"$f":"IF(H304<>\"\",H304+I303+J304)","v":0},0,null,null,null,null,"",null,13]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,14]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,15]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,16]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,17]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,18]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,19]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,20]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,21]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,22]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,23]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,24]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,25]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,26]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,27]
[null,null,"",null,null,null,null,0,{"$f":"IF(H319<>\"\",H319+I318+J319)","v":0},0,null,null,null,null,"",null,28]
[null,null,"",null,null,null,null,0,{"$f":"IF(H320<>\"\",H320+I319+J320)","v":0},0,null,null,null,null,"",null,29]
[null,null,"",null,null,null,null,0,{"$f":"IF(H321<>\"\",H321+I320+J321)","v":0},0,null,null,null,null,"",null,30]
[null,null,"",null,null,null,null,0,{"$f":"IF(H322<>\"\",H322+I321+J322)","v":0},0,null,null,null,null,"",null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D292:D322)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(H292:H322,E292:E322,\"V\")","v":0},{"$f":"H323+J323","v":0},{"$f":"SUMIFS(J292:J322,M292:M322,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(N292:O322)-N328","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,{"$f":"E468","v":0},null,null,null,null,null,null,null,null,null,{"$f":"P434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A291","v":"SEPTEMBRE"},null,null,null,null,{"$f":"VLOOKUP(9^9,I$292:I$322,1)","v":0},null,null,null,null,null,{"$f":"O289","v":0}]
["KIKO"]
["OCTOBRE","Date","Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(D328,E328,\"V\")","v":0},{"$f":"IF(H328<>\"\",H328+H326+J328)","v":0},{"$f":"(SUMIFS(N328,M328,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(N292:N322,M292:M322,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,null,0,{"$f":"IF(H329<>\"\",H329+I328+J329)","v":0},0,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,5]
[null,null,{"$f":"IF(F333=\"\",\"\",VLOOKUP(F333,X:Z,2,0))","v":""},null,null,null,null,0,0,0,null,null,null,null,{"$f":"IF(K333=\"\",\"\",VLOOKUP(K333,T:U,2,0))","v":""},null,6]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,7]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,8]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,9]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,10]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,11]
[null,null,"",null,null,null,null,0,{"$f":"IF(H339<>\"\",H339+I338+J339)","v":0},0,null,null,null,null,"",null,12]
[null,null,"",null,null,null,null,0,{"$f":"IF(H340<>\"\",H340+I339+J340)","v":0},0,null,null,null,null,"",null,13]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,14]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,15]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,16]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,17]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,18]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,19]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,20]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,21]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,22]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,23]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,24]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,25]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,26]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,27]
[null,null,"",null,null,null,null,0,{"$f":"IF(H355<>\"\",H355+I354+J355)","v":0},0,null,null,null,null,"",null,28]
[null,null,"",null,null,null,null,0,{"$f":"IF(H356<>\"\",H356+I355+J356)","v":0},0,null,null,null,null,"",null,29]
[null,null,"",null,null,null,null,0,{"$f":"IF(H357<>\"\",H357+I356+J357)","v":0},0,null,null,null,null,"",null,30]
[null,null,"",null,null,null,null,0,{"$f":"IF(H358<>\"\",H358+I357+J358)","v":0},0,null,null,null,null,"",null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D328:D358)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(H328:H358,E328:E358,\"V\")","v":0},{"$f":"H359+J359","v":0},{"$f":"SUMIFS(J328:J358,M328:M358,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(N328:N358)-N364","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,{"$f":"E432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"P434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A327","v":"OCTOBRE"},null,null,null,null,{"$f":"VLOOKUP(9^9,I$328:I$358,1)","v":0},null,null,null,null,null,{"$f":"O325","v":0}]
["KIKO"]
["NOVEMBRE","Date","Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(D364,E364,\"V\")","v":0},{"$f":"IF(H364<>\"\",H364+H362+J364)","v":0},{"$f":"(SUMIFS(N364,M364,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(N328:N358,M328:M358,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,null,0,{"$f":"IF(H365<>\"\",H365+I364+J365)","v":0},0,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,0,{"$f":"IF(H375<>\"\",H375+I374+J375)","v":0},0,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,0,{"$f":"IF(H376<>\"\",H376+I375+J376)","v":0},0,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,0,{"$f":"IF(H391<>\"\",H391+I390+J391)","v":0},0,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,0,{"$f":"IF(H392<>\"\",H392+I391+J392)","v":0},0,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,0,{"$f":"IF(H393<>\"\",H393+I392+J393)","v":0},0,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,0,{"$f":"IF(H394<>\"\",H394+I393+J394)","v":0},0,null,null,null,null,null,null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D364:D394)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(H364:H394,E364:E394,\"V\")","v":0},{"$f":"H395+J395","v":0},{"$f":"SUMIFS(J364:J394,M364:M394,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(N364:N394)-N400","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,{"$f":"E432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"P434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A363","v":"NOVEMBRE"},null,null,null,null,{"$f":"VLOOKUP(9^9,I$364:I$394,1)","v":0},null,null,null,null,null,{"$f":"O361","v":0}]
["KIKO"]
["DÉCEMBRE","Date","Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(D400,E400,\"V\")","v":0},{"$f":"IF(H400<>\"\",H400+H398+J400)","v":0},{"$f":"(SUMIFS(N400,M400,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(N364:N394,M364:M394,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,null,0,{"$f":"IF(H401<>\"\",H401+I400+J401)","v":0},0,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,0,{"$f":"IF(H411<>\"\",H411+I410+J411)","v":0},0,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,0,{"$f":"IF(H412<>\"\",H412+I411+J412)","v":0},0,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,0,{"$f":"IF(H427<>\"\",H427+I426+J427)","v":0},0,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,{"$f":"SUMIFS(D428,E428,\"V\")","v":0},{"$f":"IF(H428<>\"\",H428+I427+J428)","v":0},{"$f":"(SUMIFS(N428,M428,\"V\"))*-1","v":0},null,null,null,null,null,null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D400:D428)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(H400:H428,E400:E428,\"V\")","v":0},{"$f":"H429+J429","v":0},{"$f":"SUMIFS(J400:J428,M400:M428,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(N400:N428)-N430","v":0}," Débit non Validé moins Différé"]
[null,null,null,null,null,null,null,{"$f":"O397","v":0},null,null,null,null,"D",{"$f":"SUMIFS(N400:N428,M400:M428,\"D\")","v":0},"Cartes Mois précédent"]
[]
[null,"Possibilité investissement sur  NON Validé",null,null,{"$f":"Feuil1!B42","v":0},null,null,{"$f":"SUMIFS(D432,E432,\"V\")","v":0},null,null,{"$f":"P434","v":0},null,null,"Possibilité investissement SUR Validé"]
[null,"A valider pour proportionnel",null,null,null,{"$f":"A399","v":"DÉCEMBRE"},null,null,{"$f":"VLOOKUP(9^9,I$400:I$428,1)","v":0},null,null,null,null,null,"A valider pour proportionnel"]
["MOIS",12,"BUDGET DEPENSES",{"$f":"H434/B434","v":0},null,null,null,{"$f":"Feuil1!G42","v":0},{"$f":"P434*N434","v":0},null,"MOIS",null,null,12,"BUDGET DEPENSES",{"$f":"I433/N434","v":0}]
[null,null,"Montant a ajouter",{"$f":"E432*B434","v":0},null,null,null,null,null,null,null,null,"Montant a ajouter",null,{"$f":"K432*N434","v":0}]

{"sheet":"Feuil1","index":1,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["V","P"]
[]
["D"]
[null,{"$f":"'Frais annuel 22'!N433","v":0},null,"mois","POSSIBILITE EN PROPORTIONNALITE SUR L ANNEE"]
[null,null,null,{"$f":"C19","v":12}]
[1,"JANVIER",{"$f":"'Frais annuel 22'!I37","v":0},{"$f":"C6/D$5","v":0},{"$f":"D$19-C6","v":0},{"$f":"G6-E6","v":0},{"$f":"C6+E6","v":0},{"$f":"G6-F6","v":0},{"$f":"H6/G6","v":{"$error":"#DIV/0!"}}]
[2,"FEVRIER",{"$f":"'Frais annuel 22'!I73","v":0},{"$f":"C7/D$5","v":0},{"$f":"D$19-C7","v":0},{"$f":"G7-E7","v":0},{"$f":"C7+E7","v":0},{"$f":"G7-F7","v":0},{"$f":"H7/G7","v":{"$error":"#DIV/0!"}}]
[3,"MARS",{"$f":"'Frais annuel 22'!I109","v":0},0,{"$f":"D$19-C8","v":0},{"$f":"G8-E8","v":0},0,0,{"$f":"H8/G8","v":{"$error":"#DIV/0!"}}]
[4,"AVRIL",{"$f":"'Frais annuel 22'!I145","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[5,"MAI",{"$f":"'Frais annuel 22'!I181","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[6,"JUIN",{"$f":"'Frais annuel 22'!I217","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[7,"JUILLET",{"$f":"'Frais annuel 22'!I253","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[8,"AOÛT",{"$f":"'Frais annuel 22'!I289","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[9,"SEPTEMBRE",{"$f":"'Frais annuel 22'!I325","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[10,"OCTOBRE",{"$f":"'Frais annuel 22'!I361","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[11,"NOVEMBRE",{"$f":"'Frais annuel 22'!I397","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[12,"DÉCEMBRE",{"$f":"'Frais annuel 22'!I433","v":0},0,0,0,0,0,{"$f":"G17/F17","v":{"$error":"#DIV/0!"}}]
[]
[null,{"$f":"C17/C19","v":0},{"$f":"'Frais annuel 22'!N434","v":12},{"$f":"B4/C19","v":0},null,null,{"$f":"SUM(G6:G18)","v":0}]
[null,null,null,null,null,null,12]
[null,null,null,null,null,null,{"$f":"G19/G20","v":0}]
[]
[]
[]
[null,"SOLDE",{"$f":"'Frais annuel 22'!H3","v":0}]
[null,{"$f":"F41","v":0},null,"mois","POSSIBILITE EN PROPORTIONNALITE SUR L ANNEE SUR MONTANTS NON  VALIDES"]
[null,null,"DEBIT",{"$f":"C42","v":12},null,null,null,null,null,"CREDIT"]
[1,"JANVIER",{"$f":"'Frais annuel 22'!N35","v":0},{"$f":"C28/D$27","v":0},{"$f":"D$42-C28","v":0},{"$f":"G28-E28","v":0},{"$f":"C28+E28","v":0},{"$f":"G28-F28","v":0},{"$f":"H28/G28","v":{"$error":"#DIV/0!"}},{"$f":"'Frais annuel 22'!D35","v":0}]
[2,"FEVRIER",{"$f":"'Frais annuel 22'!N71","v":0},0,0,{"$f":"G29-E29","v":0},{"$f":"C29+E29","v":0},{"$f":"G29-F29","v":0},{"$f":"H29/G29","v":{"$error":"#DIV/0!"}},{"$f":"'Frais annuel 22'!D71","v":0}]
[3,"MARS",{"$f":"'Frais annuel 22'!N107","v":0},0,0,{"$f":"G30-E30","v":0},0,0,{"$f":"H30/G30","v":{"$error":"#DIV/0!"}},{"$f":"'Frais annuel 22'!D107","v":0}]
[4,"AVRIL",{"$f":"'Frais annuel 22'!N143","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!D143","v":0}]
[5,"MAI",{"$f":"'Frais annuel 22'!N179","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!D179","v":0}]
[6,"JUIN",{"$f":"'Frais annuel 22'!N215","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!D215","v":0}]
[7,"JUILLET",{"$f":"'Frais annuel 22'!N251","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!D251","v":0}]
[8,"AOÛT",{"$f":"'Frais annuel 22'!N287","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!D287","v":0}]
[9,"SEPTEMBRE",{"$f":"'Frais annuel 22'!N323","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!D323","v":0}]
[10,"OCTOBRE",{"$f":"'Frais annuel 22'!N359","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!D359","v":0}]
[11,"NOVEMBRE",{"$f":"'Frais annuel 22'!N395","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!D395","v":0}]
[12,"DÉCEMBRE",{"$f":"'Frais annuel 22'!N429","v":0},0,0,0,0,0,{"$f":"G39/F39","v":{"$error":"#DIV/0!"}},{"$f":"'Frais annuel 22'!D429","v":0}]
[null,null,{"$f":"SUM(C28:C39)","v":0},null,null,null,null,null,null,{"$f":"SUM(J28:J39)","v":0}]
[null,null,null,null,null,{"$f":"J42-C40","v":0},null,null,null,{"$f":"+C25","v":0}]
[{"$f":"B42*C42","v":0},{"$f":"C44/C42","v":0},{"$f":"'Frais annuel 22'!B434","v":12},{"$f":"B26/C42","v":0},null,null,{"$f":"SUM(G28:G40)","v":0},null,null,{"$f":"SUM(J40:J41)","v":0}]
[null,null,null,null,null,null,{"$f":"C42","v":12}]
[null,"validation",{"$f":"F41","v":0},{"$f":"J42-C40","v":0},null,null,{"$f":"G42/G43","v":0}]

{"sheet":"Feuil2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}