{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Frais annuel 22","Feuil1","DATA"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"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":145,"rows_kept":435,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[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],[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]]}
[]
[null,null,null,null,null,null,null,"SOLDE",null,null,null,null,null,null,"Frais Annuel   "]
["KIKO"]
["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,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,"Explication de la formule =DECALER(debutdebits;;EQUIV(K6;SCdebits;0);INDEX(nombreSCdebits;;EQUIV(K6;SCdebits;0)))",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(G6,OFFSET(departRV,,MATCH(F6,SCcredits,0)),2,0))","v":"Retraite"},null,null,"REV","RET",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(departRV,,MATCH(K6,SCdebits,0)),2,0))","v":"Electro menager"},null,2,null,"(Elle comporte 3 plages nommées de DATA)"]
[null,null,"Remboursement CPAM",null,null,"REM","CPA",0,0,0,"LO","RES",null,null,"Resto",null,3,null,"DECALER(cellule de départ;nombre de lignes (ici rien); nombre de colonnes (ici le 1er EQUIV); sur une hauteur de (ici l'INDEX EQUIV)"]
[null,null,"",null,null,null,null,0,0,0,"CO","ALI",null,null,"Alimentation",null,4,"D"]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,5,"V"]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,6]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,7,"V"]
[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(H16<>\"\",H16+I15+J16)","v":0},0,null,null,null,null,"",null,12]
[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,"En K6 il y a MA  celui se trouve en 7eme position dans la plage horizontale Scdebits, on va donc décaler de 7 colonnes"]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,15,null,null,"on se trouve alors sur la cellule où il y a DEC"]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,16,null,null,"on va décaler ensuite en hauteur du nombre situé dans nombreSCdebits qu'on trouve avec INDEX comme positionné dans la même colonne que K6 dans SCdebits donc la 7eme"]
[null,null,"",null,null,null,null,0,0,0,null,null,null,null,"",null,17,null,null,"le 7eme nombre dans la plage nombredebits etant 5 on prend 5 veleurs en hauteur donc la liste déroulante comprendra DEC MEU DEP ELM et vide"]
[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,"S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,"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(N41:N70,M41:M70,\"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,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31]
[]
[]
[]
[]
[null,"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(N77:N106,M77:M106,\"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,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31]
[]
[]
[]
[]
[null,"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(N113:N142,M113:M142,\"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,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,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":0},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(N149:N178,M149:M178,\"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,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,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(N185:N214,M185:M214,\"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,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,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(N221:N250,M221:M250,\"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,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,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(N257:N286,M257:M286,\"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,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,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(N293:N322,M293:M322,\"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,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,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(N329:N358,M329:M358,\"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,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,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(N365:N394,M365:M394,\"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,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,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":"DATA","index":2,"n_rows":30,"n_cols":42,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["20 emplacements de code en col B reportés par formule ligne 3",null,null,1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9,null,10,null,11,null,12,null,13,null,14,null,15,null,16,null,17,null,18,null,19,null,20]
["20 emplacements par sous-codes",null,null,{"$f":"COUNTA(D4:D24)","v":4},null,{"$f":"COUNTA(F4:F24)","v":4},null,{"$f":"COUNTA(H4:H24)","v":6},null,{"$f":"COUNTA(J4:J24)","v":5},null,{"$f":"COUNTA(L4:L24)","v":0},null,{"$f":"COUNTA(N4:N24)","v":0},null,{"$f":"COUNTA(P4:P24)","v":0},null,{"$f":"COUNTA(R4:R24)","v":0},null,{"$f":"COUNTA(T4:T24)","v":0},null,{"$f":"COUNTA(V4:V24)","v":0},null,{"$f":"COUNTA(X4:X24)","v":0},null,{"$f":"COUNTA(Z4:Z24)","v":0},null,{"$f":"COUNTA(AB4:AB24)","v":0},null,{"$f":"COUNTA(AD4:AD24)","v":0},null,{"$f":"COUNTA(AF4:AF24)","v":0},null,{"$f":"COUNTA(AH4:AH24)","v":0},null,{"$f":"COUNTA(AJ4:AJ24)","v":0},null,{"$f":"COUNTA(AL4:AL24)","v":0},null,{"$f":"COUNTA(AN4:AN24)","v":0},null,{"$f":"COUNTA(AP4:AP24)","v":0}]
["CODES DEBITS",null,"SS/CODES",{"$f":"IF(D1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,D1),\"\")","v":"CO"},null,{"$f":"IF(F1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,F1),\"\")","v":"VO"},null,{"$f":"IF(H1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,H1),\"\")","v":"LO"},null,{"$f":"IF(J1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,J1),\"\")","v":"MA"},null,{"$f":"IF(L1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,L1),\"\")","v":""},null,{"$f":"IF(N1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,N1),\"\")","v":""},null,{"$f":"IF(P1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,P1),\"\")","v":""},null,{"$f":"IF(R1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,R1),\"\")","v":""},null,{"$f":"IF(T1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,T1),\"\")","v":""},null,{"$f":"IF(V1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,V1),\"\")","v":""},null,{"$f":"IF(X1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,X1),\"\")","v":""},null,{"$f":"IF(Z1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,Z1),\"\")","v":""},null,{"$f":"IF(AB1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,AB1),\"\")","v":""},null,{"$f":"IF(AD1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,AD1),\"\")","v":""},null,{"$f":"IF(AF1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,AF1),\"\")","v":""},null,{"$f":"IF(AH1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,AH1),\"\")","v":""},null,{"$f":"IF(AJ1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,AJ1),\"\")","v":""},null,{"$f":"IF(AL1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,AL1),\"\")","v":""},null,{"$f":"IF(AN1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,AN1),\"\")","v":""},null,{"$f":"IF(AP1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,AP1),\"\")","v":""}]
["Courses","CO","départ des decalages","ALI","Alimentation","ESS","Essence","CIN","Ciné","DEC","Déco"]
["Voiture","VO",null,"BRI","Bricolage","REP","Réparation","RES","Resto","MEU","Meuble"]
["Loisirs","LO",null,"PHA","Pharmacie","REV","Révision","THE","Théatre","DEP","Dépannage"]
["Maison","MA",null," ",null," ",null,"VIS","Visite","ELM","Electro menager"]
[null,null,null,null,null,null,null,"LIV","Livres"," "]
[null,null,"mis un espace dans les cellules bleues",null,null,null,null," "]
[null,null,"pour vide dans menu déroulant"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9,null,10,null,11,null,12,null,13,null,14,null,15,null,16,null,17,null,18,null,19,null,20]
[null,null,null,{"$f":"COUNTA(D28:D48)","v":3},null,{"$f":"COUNTA(F28:F48)","v":3},null,{"$f":"COUNTA(H28:H48)","v":3},null,{"$f":"COUNTA(J28:J48)","v":0},null,{"$f":"COUNTA(L28:L48)","v":0},null,{"$f":"COUNTA(N28:N48)","v":0},null,{"$f":"COUNTA(P28:P48)","v":0},null,{"$f":"COUNTA(R28:R48)","v":0},null,{"$f":"COUNTA(T28:T48)","v":0},null,{"$f":"COUNTA(V28:V48)","v":0},null,{"$f":"COUNTA(X28:X48)","v":0},null,{"$f":"COUNTA(Z28:Z48)","v":0},null,{"$f":"COUNTA(AB28:AB48)","v":0},null,{"$f":"COUNTA(AD28:AD48)","v":0},null,{"$f":"COUNTA(AF28:AF48)","v":0},null,{"$f":"COUNTA(AH28:AH48)","v":0},null,{"$f":"COUNTA(AJ28:AJ48)","v":0},null,{"$f":"COUNTA(AL28:AL48)","v":0},null,{"$f":"COUNTA(AN28:AN48)","v":0},null,{"$f":"COUNTA(AP28:AP48)","v":0}]
["CODES CREDITS",null,"SS/CODES",{"$f":"IF(D25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,D25),\"\")","v":"REV"},null,{"$f":"IF(F25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,F25),\"\")","v":"REM"},null,{"$f":"IF(H25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,H25),\"\")","v":"VIR"},null,{"$f":"IF(J25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,J25),\"\")","v":""},null,{"$f":"IF(L25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,L25),\"\")","v":""},null,{"$f":"IF(N25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,N25),\"\")","v":""},null,{"$f":"IF(P25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,P25),\"\")","v":""},null,{"$f":"IF(R25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,R25),\"\")","v":""},null,{"$f":"IF(T25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,T25),\"\")","v":""},null,{"$f":"IF(V25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,V25),\"\")","v":""},null,{"$f":"IF(X25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,X25),\"\")","v":""},null,{"$f":"IF(Z25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,Z25),\"\")","v":""},null,{"$f":"IF(AB25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,AB25),\"\")","v":""},null,{"$f":"IF(AD25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,AD25),\"\")","v":""},null,{"$f":"IF(AF25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,AF25),\"\")","v":""},null,{"$f":"IF(AH25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,AH25),\"\")","v":""},null,{"$f":"IF(AJ25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,AJ25),\"\")","v":""},null,{"$f":"IF(AL25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,AL25),\"\")","v":""},null,{"$f":"IF(AN25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,AN25),\"\")","v":""},null,{"$f":"IF(AP25<=COUNTA($B$28:$B$47),INDEX($B$28:$B$47,AP25),\"\")","v":""}]
["Revenus","REV","départ des decalages","RET","Retraite","CPA","Remboursement CPAM","VBP","Virement du compte BP"]
["Remboursements","REM",null,"LOC","Location","DIV","Remboursement autre","DIV","Autre Virement"]
["Virements","VIR",null," ",null," ",null," "]