{"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":1,"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":147,"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,15,179,17],[179,0,179,3],[214,11,214,13],[214,15,214,17],[323,15,323,17],[287,15,287,17],[251,15,251,17],[215,15,215,17],[322,11,322,13],[286,15,286,17],[250,11,250,13],[250,15,250,17],[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,3],[71,0,71,3],[107,0,107,3],[37,0,37,1],[359,0,359,3],[290,0,321,0],[443,0,443,1],[442,0,442,1],[251,0,251,3],[143,0,143,3],[323,0,323,3],[215,0,215,3],[146,0,177,0],[182,0,213,0],[287,0,287,3],[253,0,253,1],[289,0,289,1],[217,0,217,1],[216,4,216,6],[250,5,250,6],[1,8,1,10],[2,8,2,10],[106,11,106,13],[106,15,106,17],[142,5,142,6],[106,5,106,6],[70,11,70,13],[70,15,70,17],[70,5,70,6],[34,5,34,6],[34,11,34,13],[34,15,34,17],[178,15,178,17],[142,11,142,13],[142,15,142,17],[178,11,178,13],[107,15,107,17],[71,15,71,17],[35,15,35,17],[180,4,180,6],[108,4,108,6],[143,15,143,17],[432,6,432,8],[432,1,432,3],[434,13,434,14],[433,11,433,13],[322,15,322,17],[322,5,322,6],[288,4,288,6],[286,5,286,6],[286,11,286,13],[428,15,428,17],[324,4,324,6],[360,4,360,6],[358,5,358,6],[358,11,358,13],[325,0,325,1],[429,0,429,1],[2,0,2,1],[431,11,431,13],[431,14,431,15],[431,5,431,6],[431,1,431,4],[429,8,429,10],[358,15,358,17],[394,15,394,17],[394,11,394,13],[394,5,394,6],[362,0,393,0],[396,4,396,6],[428,5,428,6],[395,0,395,3],[428,11,428,13],[398,0,427,0],[395,15,395,17],[359,15,359,17],[214,5,214,6],[36,4,36,6],[72,4,72,6],[144,4,144,6],[178,5,178,6],[252,4,252,6]]}
[]
[null,null,null,null,null,null,null,null,"SOLDE",null,null,null,null,null,null,"Frais Annuel   "]
["KIKO"]
["JANVIER","Date","Commentaire","Désignation","Crédit","   V","Code","S/C","Valeur","Solde","Valeur","Code","S/C","V/D","Débit","Désignation","Commentaire","Date"]
[null,null,null,{"$f":"IF(G5=\"\",\"\",VLOOKUP(H5,OFFSET(departRV,,MATCH(G5,SCcredits,0)),2,0))","v":" ALPRO ARRCO PREST BTP "},null,"V","REV","ARC",{"$f":"SUMIFS(E5,F5,\"V\")","v":0},{"$f":"IF(I5<>\"\",I5+I3+K5)","v":0},{"$f":"(SUMIFS(O5,N5,\"V\"))*-1","v":0},null,null,"v",null,"Cartes Mois précédent",null,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,null,"SCI MAAF",null,"V","REM","MA",0,{"$f":"IF(I6<>\"\",I6+J5+K6)","v":0},{"$f":"(SUMIFS(O6,N6,\"V\"))*-1","v":0},"PR","PRI","V",null,{"$f":"IF(L6=\"\",\"\",VLOOKUP(M6,OFFSET(departRV,,MATCH(L6,SCdebits,0)),2,0))","v":"PRLV PRIXTEL"},null,null,2,null,"(Elle comporte 3 plages nommées de DATA)"]
[null,null,null,"EAU SALAS",null,"V","REM","ES2",0,0,0,"PR","PRI","V",null,"PRLV PRIXTEL",null,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,"ORDURE SALAS",null,"V","REM","OR2",0,0,0,"M","MA","V",null," MAAF",null,null,4,"D"]
[null,null,null,"Caisse Ass Retraite ",null,"V","REV","RET",0,0,0,"CO","LE1","D",null,"ELECLERC",null,null,5,"V"]
[null,null,null,"Autre Virement",null,"V","VIR","DIV",0,0,0,"CO","1SU","D",null,"MAGASIN U",null,null,6]
[null,null,null,"PIERROT",null,"V","REV","BP",0,0,0,"PR","PBT","V",null,"MUTUELLE PRO BTP",null,null,7,"V"]
[null,null,null,"VIREMENT PRO BTP",null,"V","REM","PBP",0,0,0,"CO","DEN","D",null,"K GOURNAY COPPE Dentiste",null,null,8]
[null,null,null,"EAU PLN",null,"V","REM","EP3",0,0,{"$f":"(SUMIFS(O13,N13,\"V\"))*-1","v":0},"CO","1SU","D",null,"MAGASIN U",null,null,9]
[null,null,null,"Autre Virement",null,"V","VIR","DIV",0,0,0,"CO","GF","D",null,"GRAND FRAIS",null,null,10]
[null,null,null,"Autre Virement",null,"V","VIR","DIV",0,0,0,"CO","PH1","D",null,"PHARMACIE DU MARTINET",null,null,11]
[null,null,null,"",null,null,null,null,0,{"$f":"IF(I16<>\"\",I16+J15+K16)","v":0},0,"DV","CA","V",null,"CAROLE \"\"",null,null,12]
[null,null,null,"",null,null,null,null,0,{"$f":"IF(I17<>\"\",I17+J16+K17)","v":0},0,"PR","PAY ","D",null,"PAYPAL",null,null,13,"KIKO"]
[null,null,null,"",null,null,null,null,0,0,0,"PR","SFR","V",null,"SFR PRLV  FIXE ADSL",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,null,0,0,0,"PR","CE1","V",null,"Forfait Caisse Epargne",null,null,15,null,null,"on se trouve alors sur la cellule où il y a DEC"]
[null,null,null,"",null,null,null,null,0,0,0,"PR","PAY ","D",null,"PAYPAL",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,null,0,0,0,"PR","CSG","V",null,"IMPOT CSG",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,null,0,0,0,"VO","C1","D",null,"DS CARB  BARDOU",null,null,18]
[null,null,null,"",null,null,null,null,0,0,0,"CO","LE2","D",null,"CASTRESDIS Leclerc R StPons",null,null,19]
[null,null,null,"",null,null,null,null,0,0,0,"PR","AGI","V",null,"AGIPI RETRAITE PASCALE ",null,null,20]
[null,null,null,"",null,null,null,null,0,0,0,"M","OR1","V",null,"ORDURE MAISON",null,null,21]
[null,null,null,"",null,null,null,null,0,0,0,"M","OR2","V",null,"ORDURE SALAS",null,null,22]
[null,null,null,"",null,null,null,null,0,0,0,"M","DFP","V",null,"EDF PLN ",null,null,23]
[null,null,null,"",null,null,null,null,0,0,0,"PR","IM","V",null,"PR-IM",null,null,24]
[null,null,null,"",null,null,null,null,0,0,0,"PR","IM","V",null,{"$f":"IF(L29=\"\",\"\",VLOOKUP(M29,OFFSET(departRV,,MATCH(L29,SCdebits,0)),2,0))","v":"PR-IM"},null,null,25]
[null,null,null,"",null,null,null,null,0,0,0,"PR","PAY ","D",null,"PAYPAL",null,null,26]
[null,null,null,"",null,null,null,null,0,0,0,"PR","BTP","V",null,"PR PRO BTP",null,null,27]
[null,null,null,"",null,null,null,null,0,{"$f":"IF(I32<>\"\",I32+J31+K32)","v":0},0,"CO","1SU","D",null,"MAGASIN U",null,null,28]
[null,null,null,"",null,null,null,null,0,{"$f":"IF(I33<>\"\",I33+J32+K33)","v":0},0,"DV","D","D",null,"FRAIS",null,null,29]
[null,null,null,"",null,null,null,null,0,{"$f":"IF(I34<>\"\",I34+J33+K34)","v":0},0,"PR","PAY ","D",null,"PAYPAL",null,null,30]
[null,null,null,"Crédit non Validé",{"$f":"SUM(E5:E34)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(I5:I34,F5:F34,\"V\")","v":0},{"$f":"I35+K35","v":0},{"$f":"SUMIFS(K5:K34,N5:N34,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(O5:O34)-O40","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,null,{"$f":"F432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"R434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,null,{"$f":"A4","v":"JANVIER"},null,null,null,null,{"$f":"VLOOKUP(9^9,J$5:J$34,1)","v":0},null,null,null,null,null,{"$f":"D2","v":0}]
["VALIDE"]
["FEVRIER","Date","Commentaire","Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation","Commentaire","Date"]
[null,null,null,null,null,null,null,null,{"$f":"SUMIFS(E40,F40,\"V\")","v":0},{"$f":"IF(I40<>\"\",I40+I38+K40)","v":0},{"$f":"(SUMIFS(O40,N40,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(O5:O34,N5:N34,\"D\")","v":0},"Cartes Mois précédent",null,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,"V","REV",null,null,null,null,"PR",null,"V",null,null,null,null,2]
[null,null,null,null,null,"V",null,null,null,null,null,"PR",null,"V",null,null,null,null,3]
[null,null,null,null,null,"V","REM",null,null,null,null,"PR",null,"V",null,null,null,null,4]
[null,null,null,null,null,"V",null,null,null,null,null,null,null,"V",null,null,null,null,5]
[null,null,null,null,null,"V",null,null,null,null,null,null,null,"D",null,null,null,null,6]
[null,null,null,null,null,"V",null,null,null,null,null,null,null,"D",null,null,null,null,7]
[null,null,null,null,null,"V",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,"V",null,null,null,null,9]
[null,null,null,null,null,"V",null,null,null,null,null,null,null,"D",null,null,null,null,10]
[null,null,null,null,null,"V",null,null,null,null,null,null,null,"V",null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"V",null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"V",null,null,null,null,13]
[null,null,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,null,null,15]
[null,null,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,null,null,17]
[null,null,null,null,null,"V",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,null,null,19]
[null,null,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,null,null,21]
[null,null,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,null,null,23]
[null,null,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,null,null,25]
[null,null,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,null,null,27]
[null,null,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,null,null,29]
[null,null,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,null,null,31]
[null,null,null,"Crédit non Validé",{"$f":"SUM(E40:E70)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(I40:I70,F40:F70,\"V\")","v":0},{"$f":"I71+K71","v":0},{"$f":"SUMIFS(K40:K70,N40:N70,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(O40:O70)-O76","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,null,{"$f":"F432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"R434","v":0},"Possibilité investissement SUR Validé"]
["P",null,null,"Protection données du mois",{"$f":"A39","v":"FEVRIER"},null,null,null,null,{"$f":"VLOOKUP(9^9,J$40:J$70,1)","v":0},null,null,null,null,null,{"$f":"P37","v":0}]
["KIKO"]
[null,"Date",null,"Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation",null,"Date"]
[null,null,null,null,null,null,null,null,{"$f":"SUMIFS(E76,F76,\"V\")","v":0},{"$f":"IF(I76<>\"\",I76+I74+K76)","v":0},{"$f":"(SUMIFS(O76,N76,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(O41:O70,N41:N70,\"D\")","v":0},"Cartes Mois précédent",null,null,1]
[null,null,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,null,null,3]
[null,null,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,null,null,5]
[null,null,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,null,null,7]
[null,null,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,null,null,9]
[null,null,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,null,null,11]
[null,null,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,null,null,13]
[null,null,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,null,null,15]
[null,null,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,null,null,17]
[null,null,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,null,null,19]
[null,null,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,null,null,21]
[null,null,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,null,null,23]
[null,null,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,null,null,25]
[null,null,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,null,null,27]
[null,null,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,null,null,29]
[null,null,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,null,null,31]
[]
[]
[]
["KIKO"]
[null,"Date",null,"Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation",null,"Date"]
[null,null,null,null,null,null,null,null,{"$f":"SUMIFS(E112,F112,\"V\")","v":0},{"$f":"IF(I112<>\"\",I112+I110+K112)","v":0},{"$f":"(SUMIFS(O112,N112,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(O77:O106,N77:N106,\"D\")","v":0},"Cartes Mois précédent",null,null,1]
[null,null,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,null,null,3]
[null,null,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,null,null,5]
[null,null,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,null,null,7]
[null,null,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,null,null,9]
[null,null,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,null,null,11]
[null,null,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,null,null,13]
[null,null,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,null,null,15]
[null,null,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,null,null,17]
[null,null,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,null,null,19]
[null,null,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,null,null,21]
[null,null,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,null,null,23]
[null,null,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,null,null,25]
[null,null,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,null,null,27]
[null,null,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,null,null,29]
[null,null,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,null,null,31]
[]
[]
[]
["KIKO"]
[null,"Date",null,"Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation",null,"Date"]
[null,null,null,null,null,null,null,null,{"$f":"SUMIFS(E148,F148,\"V\")","v":0},{"$f":"IF(I148<>\"\",I148+I146+K148)","v":0},{"$f":"(SUMIFS(O148,N148,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(O113:O142,N113:N142,\"D\")","v":0},"Cartes Mois précédent",null,null,1]
[null,null,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,null,null,3]
[null,null,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,null,null,5]
[null,null,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,null,null,7]
[null,null,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,null,null,9]
[null,null,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,null,null,11]
[null,null,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,null,null,13]
[null,null,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,null,null,15]
[null,null,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,null,null,17]
[null,null,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,null,null,19]
[null,null,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,null,null,21]
[null,null,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,null,null,23]
[null,null,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,null,null,25]
[null,null,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,null,null,27]
[null,null,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,null,null,29]
[null,null,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,null,null,31]
[null,null,null,"Crédit non Validé",{"$f":"SUM(E148:E178)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(I148:I178,F148:F178,\"V\")","v":0},{"$f":"I179+K179","v":0},{"$f":"SUMIFS(K148:K178,N148:N178,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(O148:O178)-O184","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,null,{"$f":"F432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"R434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,null,{"$f":"A147","v":0},null,null,null,null,{"$f":"VLOOKUP(9^9,J$148:J$178,1)","v":0},null,null,null,null,null,{"$f":"P145","v":0}]
["KIKO"]
["JUIN","Date",null,"Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation",null,"Date"]
[null,null,null,null,null,null,null,null,{"$f":"SUMIFS(E184,F184,\"V\")","v":0},{"$f":"IF(I184<>\"\",I184+I182+K184)","v":0},{"$f":"(SUMIFS(O184,N184,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(O149:O178,N149:N178,\"D\")","v":0},"Cartes Mois précédent",null,null,1]
[null,null,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,null,null,3]
[null,null,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,null,null,5]
[null,null,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,null,null,7]
[null,null,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,null,null,9]
[null,null,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,null,null,11]
[null,null,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,null,null,13]
[null,null,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,null,null,15]
[null,null,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,null,null,17]
[null,null,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,null,null,19]
[null,null,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,null,null,21]
[null,null,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,null,null,23]
[null,null,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,null,null,25]
[null,null,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,null,null,27]
[null,null,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,null,null,29]
[null,null,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,null,null,31]
[null,null,null,"Crédit non Validé",{"$f":"SUM(E184:E214)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(I184:I214,F184:F214,\"V\")","v":0},{"$f":"I215+K215","v":0},{"$f":"SUMIFS(K184:K214,N184:N214,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(O184:O214)-O220","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,null,{"$f":"F432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"R434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,null,{"$f":"A183","v":"JUIN"},null,null,null,null,{"$f":"VLOOKUP(9^9,J$184:J$214,1)","v":0},null,null,null,null,null,{"$f":"P181","v":0}]
["KIKO"]
["JUILLET","Date",null,"Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation",null,"Date"]
[null,null,null,null,null,null,null,null,{"$f":"SUMIFS(E220,F220,\"V\")","v":0},{"$f":"IF(I220<>\"\",I220+I218+K220)","v":0},{"$f":"(SUMIFS(O220,N220,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(O185:O214,N185:N214,\"D\")","v":0},"Cartes Mois précédent",null,null,1]
[null,null,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,null,null,3]
[null,null,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,null,null,5]
[null,null,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,null,null,7]
[null,null,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,null,null,9]
[null,null,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,null,null,11]
[null,null,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,null,null,13]
[null,null,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,null,null,15]
[null,null,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,null,null,17]
[null,null,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,null,null,19]
[null,null,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,null,null,21]
[null,null,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,null,null,23]
[null,null,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,null,null,25]
[null,null,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,null,null,27]
[null,null,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,null,null,29]
[null,null,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,null,null,31]
[null,null,null,"Crédit non Validé",{"$f":"SUM(E220:E250)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(I220:I250,F220:F250,\"V\")","v":0},{"$f":"I251+K251","v":0},{"$f":"SUMIFS(K220:K250,N220:N250,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(O220:O250)-O256","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,null,{"$f":"F432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"R434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,null,{"$f":"A219","v":"JUILLET"},null,null,null,null,{"$f":"VLOOKUP(9^9,J$220:J$250,1)","v":0},null,null,null,null,null,{"$f":"P217","v":0}]
["KIKO"]
["AOÛT","Date",null,"Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation",null,"Date"]
[null,null,null,null,null,null,null,null,{"$f":"SUMIFS(E256,F256,\"V\")","v":0},{"$f":"IF(I256<>\"\",I256+I254+K256)","v":0},{"$f":"(SUMIFS(O256,N256,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(O221:O250,N221:N250,\"D\")","v":0},"Cartes Mois précédent",null,null,1]
[null,null,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,null,null,3]
[null,null,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,null,null,5]
[null,null,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,null,null,7]
[null,null,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,null,null,9]
[null,null,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,null,null,11]
[null,null,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,null,null,13]
[null,null,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,null,null,15]
[null,null,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,null,null,17]
[null,null,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,null,null,19]
[null,null,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,null,null,21]
[null,null,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,null,null,23]
[null,null,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,null,null,25]
[null,null,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,null,null,27]
[null,null,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,null,null,29]
[null,null,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,null,null,31]
[null,null,null,"Crédit non Validé",{"$f":"SUM(E256:E286)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(I256:I286,F256:F286,\"V\")","v":0},{"$f":"I287+K287","v":0},{"$f":"SUMIFS(K256:K286,N256:N286,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(O256:O286)-O292","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,null,{"$f":"F432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"R434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,null,{"$f":"A255","v":"AOÛT"},null,null,null,null,{"$f":"VLOOKUP(9^9,J$256:J$286,1)","v":0},null,null,null,null,null,{"$f":"P253","v":0}]
["KIKO"]
["SEPTEMBRE","Date",null,"Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation",null,"Date"]
[null,null,null,null,null,null,null,null,{"$f":"SUMIFS(E292,F292,\"V\")","v":0},{"$f":"IF(I292<>\"\",I292+I290+K292)","v":0},{"$f":"(SUMIFS(O292,N292,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(O257:O286,N257:N286,\"D\")","v":0},"Cartes Mois précédent",null,null,1]
[null,null,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,null,null,3]
[null,null,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,null,null,5]
[null,null,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,null,null,7]
[null,null,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,null,null,9]
[null,null,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,null,null,11]
[null,null,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,null,null,13]
[null,null,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,null,null,15]
[null,null,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,null,null,17]
[null,null,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,null,null,19]
[null,null,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,null,null,21]
[null,null,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,null,null,23]
[null,null,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,null,null,25]
[null,null,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,null,null,27]
[null,null,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,null,null,29]
[null,null,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,null,null,31]
[null,null,null,"Crédit non Validé",{"$f":"SUM(E292:E322)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(I292:I322,F292:F322,\"V\")","v":0},{"$f":"I323+K323","v":0},{"$f":"SUMIFS(K292:K322,N292:N322,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(O292:P322)-O328","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,null,{"$f":"F468","v":0},null,null,null,null,null,null,null,null,null,{"$f":"R434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,null,{"$f":"A291","v":"SEPTEMBRE"},null,null,null,null,{"$f":"VLOOKUP(9^9,J$292:J$322,1)","v":0},null,null,null,null,null,{"$f":"P289","v":0}]
["KIKO"]
["OCTOBRE","Date",null,"Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation",null,"Date"]
[null,null,null,null,null,null,null,null,{"$f":"SUMIFS(E328,F328,\"V\")","v":0},{"$f":"IF(I328<>\"\",I328+I326+K328)","v":0},{"$f":"(SUMIFS(O328,N328,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(O293:O322,N293:N322,\"D\")","v":0},"Cartes Mois précédent",null,null,1]
[null,null,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,null,null,3]
[null,null,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,null,null,5]
[null,null,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,null,null,7]
[null,null,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,null,null,9]
[null,null,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,null,null,11]
[null,null,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,null,null,13]
[null,null,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,null,null,15]
[null,null,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,null,null,17]
[null,null,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,null,null,19]
[null,null,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,null,null,21]
[null,null,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,null,null,23]
[null,null,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,null,null,25]
[null,null,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,null,null,27]
[null,null,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,null,null,29]
[null,null,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,null,null,31]
[null,null,null,"Crédit non Validé",{"$f":"SUM(E328:E358)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(I328:I358,F328:F358,\"V\")","v":0},{"$f":"I359+K359","v":0},{"$f":"SUMIFS(K328:K358,N328:N358,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(O328:O358)-O364","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,null,{"$f":"F432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"R434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,null,{"$f":"A327","v":"OCTOBRE"},null,null,null,null,{"$f":"VLOOKUP(9^9,J$328:J$358,1)","v":0},null,null,null,null,null,{"$f":"P325","v":0}]
["KIKO"]
["NOVEMBRE","Date",null,"Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation",null,"Date"]
[null,null,null,null,null,null,null,null,{"$f":"SUMIFS(E364,F364,\"V\")","v":0},{"$f":"IF(I364<>\"\",I364+I362+K364)","v":0},{"$f":"(SUMIFS(O364,N364,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(O329:O358,N329:N358,\"D\")","v":0},"Cartes Mois précédent",null,null,1]
[null,null,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,null,null,3]
[null,null,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,null,null,5]
[null,null,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,null,null,7]
[null,null,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,null,null,9]
[null,null,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,null,null,11]
[null,null,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,null,null,13]
[null,null,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,null,null,15]
[null,null,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,null,null,17]
[null,null,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,null,null,19]
[null,null,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,null,null,21]
[null,null,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,null,null,23]
[null,null,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,null,null,25]
[null,null,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,null,null,27]
[null,null,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,null,null,29]
[null,null,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,null,null,31]
[null,null,null,"Crédit non Validé",{"$f":"SUM(E364:E394)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(I364:I394,F364:F394,\"V\")","v":0},{"$f":"I395+K395","v":0},{"$f":"SUMIFS(K364:K394,N364:N394,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(O364:O394)-O400","v":0}," Débit non Validé moins Différé"]
["Possibilité investissement sur  NON Validé",null,null,null,{"$f":"F432","v":0},null,null,null,null,null,null,null,null,null,{"$f":"R434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,null,{"$f":"A363","v":"NOVEMBRE"},null,null,null,null,{"$f":"VLOOKUP(9^9,J$364:J$394,1)","v":0},null,null,null,null,null,{"$f":"P361","v":0}]
["KIKO"]
["DÉCEMBRE","Date",null,"Désignation","Crédit","   V","Code",null,"Valeur","Solde","Valeur","Code",null,"V/D","Débit","Désignation",null,"Date"]
[null,null,null,null,null,null,null,null,{"$f":"SUMIFS(E400,F400,\"V\")","v":0},{"$f":"IF(I400<>\"\",I400+I398+K400)","v":0},{"$f":"(SUMIFS(O400,N400,\"V\"))*-1","v":0},null,null,"v",{"$f":"SUMIFS(O365:O394,N365:N394,\"D\")","v":0},"Cartes Mois précédent",null,null,1]
[null,null,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,null,null,3]
[null,null,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,null,null,5]
[null,null,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,null,null,7]
[null,null,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,null,null,9]
[null,null,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,null,null,11]
[null,null,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,null,null,13]
[null,null,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,null,null,15]
[null,null,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,null,null,17]
[null,null,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,null,null,19]
[null,null,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,null,null,21]
[null,null,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,null,null,23]
[null,null,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,null,null,25]
[null,null,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,null,null,27]
[null,null,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,null,null,31]
[null,null,null,"Crédit non Validé",{"$f":"SUM(E400:E428)","v":0},"CREDIT",null,null,{"$f":"SUMIFS(I400:I428,F400:F428,\"V\")","v":0},{"$f":"I429+K429","v":0},{"$f":"SUMIFS(K400:K428,N400:N428,\"V\")","v":0},"DEBIT",null,null,{"$f":"SUM(O400:O428)-O430","v":0}," Débit non Validé moins Différé"]
[null,null,null,null,null,null,null,null,{"$f":"P397","v":0},null,null,null,null,"D",{"$f":"SUMIFS(O400:O428,N400:N428,\"D\")","v":0},"Cartes Mois précédent"]
[]
[null,"Possibilité investissement sur  NON Validé",null,null,null,{"$f":"Feuil1!B42","v":0},null,null,{"$f":"SUMIFS(E432,F432,\"V\")","v":0},null,null,{"$f":"R434","v":0},null,null,"Possibilité investissement SUR Validé"]
[null,"A valider pour proportionnel",null,null,null,null,{"$f":"A399","v":"DÉCEMBRE"},null,null,{"$f":"VLOOKUP(9^9,J$400:J$428,1)","v":0},null,null,null,null,null,"A valider pour proportionnel"]
["MOIS",12,null,"BUDGET DEPENSES",{"$f":"I434/B434","v":0},null,null,null,{"$f":"Feuil1!G42","v":0},{"$f":"R434*O434","v":0},null,"MOIS",null,null,12,"BUDGET DEPENSES",null,{"$f":"J433/O434","v":0}]
[null,null,null,"Montant a ajouter",{"$f":"F432*B434","v":0},null,null,null,null,null,null,null,null,"Montant a ajouter",null,{"$f":"L432*O434","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'!O433","v":0},null,"mois","POSSIBILITE EN PROPORTIONNALITE SUR L ANNEE"]
[null,null,null,{"$f":"C19","v":12}]
[1,"JANVIER",{"$f":"'Frais annuel 22'!J37","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'!J73","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'!J109","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'!J145","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[5,"MAI",{"$f":"'Frais annuel 22'!J181","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[6,"JUIN",{"$f":"'Frais annuel 22'!J217","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[7,"JUILLET",{"$f":"'Frais annuel 22'!J253","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[8,"AOÛT",{"$f":"'Frais annuel 22'!J289","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[9,"SEPTEMBRE",{"$f":"'Frais annuel 22'!J325","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[10,"OCTOBRE",{"$f":"'Frais annuel 22'!J361","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[11,"NOVEMBRE",{"$f":"'Frais annuel 22'!J397","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[12,"DÉCEMBRE",{"$f":"'Frais annuel 22'!J433","v":0},0,0,0,0,0,{"$f":"G17/F17","v":{"$error":"#DIV/0!"}}]
[]
[null,{"$f":"C17/C19","v":0},{"$f":"'Frais annuel 22'!O434","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'!I3","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'!O35","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'!E35","v":0}]
[2,"FEVRIER",{"$f":"'Frais annuel 22'!O71","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'!E71","v":0}]
[3,"MARS",{"$f":"'Frais annuel 22'!O107","v":0},0,0,{"$f":"G30-E30","v":0},0,0,{"$f":"H30/G30","v":{"$error":"#DIV/0!"}},{"$f":"'Frais annuel 22'!E107","v":0}]
[4,"AVRIL",{"$f":"'Frais annuel 22'!O143","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!E143","v":0}]
[5,"MAI",{"$f":"'Frais annuel 22'!O179","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!E179","v":0}]
[6,"JUIN",{"$f":"'Frais annuel 22'!O215","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!E215","v":0}]
[7,"JUILLET",{"$f":"'Frais annuel 22'!O251","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!E251","v":0}]
[8,"AOÛT",{"$f":"'Frais annuel 22'!O287","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!E287","v":0}]
[9,"SEPTEMBRE",{"$f":"'Frais annuel 22'!O323","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!E323","v":0}]
[10,"OCTOBRE",{"$f":"'Frais annuel 22'!O359","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!E359","v":0}]
[11,"NOVEMBRE",{"$f":"'Frais annuel 22'!O395","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!E395","v":0}]
[12,"DÉCEMBRE",{"$f":"'Frais annuel 22'!O429","v":0},0,0,0,0,0,{"$f":"G39/F39","v":{"$error":"#DIV/0!"}},{"$f":"'Frais annuel 22'!E429","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":38,"n_cols":42,"rows_kept":38,"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":9},null,{"$f":"COUNTA(F4:F24)","v":5},null,{"$f":"COUNTA(H4:H24)","v":6},null,{"$f":"COUNTA(J4:J24)","v":12},null,{"$f":"COUNTA(L4:L24)","v":12},null,{"$f":"COUNTA(N4:N24)","v":6},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":"DV"},null,{"$f":"IF(J1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,J1),\"\")","v":"PR"},null,{"$f":"IF(L1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,L1),\"\")","v":"M"},null,{"$f":"IF(N1<=COUNTA($B$4:$B$23),INDEX($B$4:$B$23,N1),\"\")","v":"R"},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","LE1","ELECLERC","C1","DS CARB  BARDOU","CA","CAROLE \"\"","PRI","PRLV PRIXTEL","MA"," MAAF","ARC","ALPRO ARRCO PREST BTP "]
["Voiture","VO",null,"LE2","CASTRESDIS Leclerc R StPons","EN1","DS ENTRETIEN","D","FRAIS","PBT","MUTUELLE PRO BTP","GA1","GAN ASSURANCE MAISON","RET","CAISSE D'ASS RET "]
["Loisirs","DV",null,"PH1","PHARMACIE DU MARTINET","C2","BOXER  CARB  BARDOU","THE","Théatre","SFR","SFR PRLV  FIXE ADSL","GA2","GAN ASSURANCE MAISON SALAS","GA0","RETRAITE SUP GAN"]
["Prélèvements","PR",null," ",null," ",null,"VIS","Visite","CSG","IMPOT CSG","GA3","GAN ASSURANCE MAISON PLN","BP","PIERROT"]
["Charges","M",null,"GF","GRAND FRAIS","EN2","BOXER ENTRETIEN","LIV","Livres"," ",null," ",null," "]
["RENTE","R","mis un espace dans les cellules bleues","1SU","MAGASIN U",null,null," ",null,"IM","PR-IM","OR1","ORDURE MAISON","AM","C.P.A.M. ALBI"]
[null,null,"pour vide dans menu déroulant","DEN","K GOURNAY COPPE Dentiste",null,null,null,null,"PAY ","PAYPAL","OR2","ORDURE SALAS"]
[null,null,null,"PH2","PHARMACIE BRASSAC",null,null,null,null,"CE1","Forfait Caisse Epargne","EM1","EAU MAISON"]
[null,null,null,"PH3","PHARMACIE PLN",null,null,null,null,"AGI","AGIPI RETRAITE PASCALE ","ES2","EAU SALAS"]
[null,null,null,null,null,null,null,null,null,"PRB","VIREMENT PRO BTP","EP3","EAU PLN"]
[null,null,null,null,null,null,null,null,null,"BT1","PRO BTP PRESTATIONS","DFM","EDF MAISON"]
[null,null,null,null,null,null,null,null,null,"BTP","PR PRO BTP","DFP","EDF PLN "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":5},null,{"$f":"COUNTA(F28:F48)","v":11},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","ARC"," ALPRO ARRCO PREST BTP ","CPA","Remboursement CPAM","VBP","Virement du compte BP"]
["Remboursements","REM",null,"RET","Caisse Ass Retraite ","DIV","Remboursement autre","DIV","Autre Virement"]
["Virements","VIR",null," ",null," ",null," "]
[null,null,null,"GA0","RETRAITE SUP GAN","AM","C.P.A.M. ALBI"]
[null,null,null,"BP","PIERROT","OR2","ORDURE SALAS"]
[null,null,null,null,null,"ES2","EAU SALAS"]
[null,null,null,null,null,"EP3","EAU PLN"]
[null,null,null,null,null,"DFP","EDF PLN "]
[null,null,null,null,null,"GA3","GAN ASSURANCE MAISON PLN"]
[null,null,null,null,null,"MA","SCI MAAF"]
[null,null,null,null,null,"PBP","VIREMENT PRO BTP"]