{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Frais annuel 22","Feuil1","Feuil2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":166,"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,12,179,13],[179,0,179,2],[214,9,214,10],[214,12,214,13],[323,12,323,13],[287,12,287,13],[251,12,251,13],[215,12,215,13],[322,9,322,10],[286,12,286,13],[250,9,250,10],[250,12,250,13],[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,6,1,8],[2,6,2,8],[106,9,106,10],[106,12,106,13],[142,4,142,5],[106,4,106,5],[70,9,70,10],[70,12,70,13],[70,4,70,5],[34,4,34,5],[34,9,34,10],[34,12,34,13],[178,12,178,13],[142,9,142,10],[142,12,142,13],[178,9,178,10],[107,12,107,13],[71,12,71,13],[35,12,35,13],[180,3,180,5],[108,3,108,5],[143,12,143,13],[432,5,432,6],[432,1,432,2],[434,10,434,11],[433,9,433,10],[322,12,322,13],[322,4,322,5],[288,3,288,5],[286,4,286,5],[286,9,286,10],[428,12,428,13],[324,3,324,5],[360,3,360,5],[358,4,358,5],[358,9,358,10],[325,0,325,1],[429,0,429,1],[2,0,2,1],[431,9,431,10],[431,11,431,12],[431,4,431,5],[431,1,431,3],[429,6,429,8],[358,12,358,13],[394,12,394,13],[394,9,394,10],[394,4,394,5],[362,0,393,0],[396,3,396,5],[428,4,428,5],[395,0,395,2],[428,9,428,10],[398,0,427,0],[395,12,395,13],[359,12,359,13],[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,"SOLDE",null,null,null,null,null,"Frais Annuel   "]
["KIKO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AL","Alimentation"]
["JANVIER","Date","Désignation","Crédit","   V","Code","Valeur","Solde","Valeur","Code","V/D","Débit","Désignation","Date",null,null,null,"CI","Ciné"]
[null,null,null,null,null,null,{"$f":"SUMIFS(D5,E5,\"V\")","v":0},{"$f":"IF(G5<>\"\",G5+G3+I5)","v":0},{"$f":"(SUMIFS(L5,K5,\"V\"))*-1","v":0},null,"v",null,"Cartes Mois précédent",null,1,null,null,"DI","Divers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,0,{"$f":"IF(G6<>\"\",G6+H5+I6)","v":0},0,"AL",null,null,{"$f":"IF(J6=\"\",\"\",VLOOKUP(J6,R:S,2,0))","v":"Alimentation"},null,2,null,null,"ES","Essence"]
[null,null,null,null,null,null,0,0,0,"VO",null,null,{"$f":"IF(J7=\"\",\"\",VLOOKUP(J7,R:S,2,0))","v":"Voiture"},null,3,null,null,"LO","Loyer"]
[null,null,null,null,null,null,0,0,0,"CI",null,null,"Ciné",null,4,"D",null,"RE","Resto"]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,5,"V",null,"VO","Voiture"]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,6]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,7,"V"]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,8]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,9]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,10]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,11]
[null,null,null,null,null,null,0,{"$f":"IF(G16<>\"\",G16+H15+I16)","v":0},0,null,null,null,"",null,12]
[null,null,null,null,null,null,0,{"$f":"IF(G17<>\"\",G17+H16+I17)","v":0},0,null,null,null,"",null,13,"KIKO"]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,14,"VALIDE"]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,15]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,16]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,17]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,18]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,19]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,20]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,21]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,22]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,23]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,24]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,25]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,26]
[null,null,null,null,null,null,0,0,0,null,null,null,"",null,27]
[null,null,null,null,null,null,0,{"$f":"IF(G32<>\"\",G32+H31+I32)","v":0},0,null,null,null,"",null,28]
[null,null,null,null,null,null,0,{"$f":"IF(G33<>\"\",G33+H32+I33)","v":0},0,null,null,null,"",null,29]
[null,null,null,null,null,null,0,{"$f":"IF(G34<>\"\",G34+H33+I34)","v":0},0,null,null,null,"",null,30]
[null,null,"Crédit non Validé",{"$f":"SUM(D5:D34)","v":0},"CREDIT",null,{"$f":"SUMIFS(G5:G34,E5:E34,\"V\")","v":0},{"$f":"G35+I35","v":0},{"$f":"SUMIFS(I5:I34,K5:K34,\"V\")","v":0},"DEBIT",null,{"$f":"SUM(L5:L34)-L40","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,{"$f":"N434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A4","v":"JANVIER"},null,null,null,{"$f":"VLOOKUP(9^9,H$5:H$34,1)","v":0},null,null,null,null,{"$f":"C2","v":0}]
["KIKO"]
["FEVRIER","Date","Désignation","Crédit","   V","Code","Valeur","Solde","Valeur","Code","V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,{"$f":"SUMIFS(D40,E40,\"V\")","v":0},{"$f":"IF(G40<>\"\",G40+H37+I40)","v":0},{"$f":"(SUMIFS(L40,K40,\"V\"))*-1","v":0},null,"v",{"$f":"SUMIFS(L5:L34,K5:K34,\"D\")","v":0},"Cartes Mois précédent",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S"]
[null,null,null,null,null,null,0,{"$f":"IF(G41<>\"\",G41+H40+I41)","v":0},0,null,null,null,null,null,2]
[null,null,null,null,null,null,0,{"$f":"IF(G42<>\"\",G42+H41+I42)","v":0},0,null,null,null,null,null,3]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,4]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,5]
[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]
[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,0,0,null,null,null,null,null,12]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,13]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,14]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,15]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,16]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,17]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,18]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,19]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,20]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,21]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,22]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,23]
[null,null,null,null,null,null,0,{"$f":"IF(G63<>\"\",G63+H62+I63)","v":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,0,0,null,null,null,null,null,28]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,29]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,30]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D40:D70)","v":0},"CREDIT",null,{"$f":"SUMIFS(G40:G70,E40:E70,\"V\")","v":0},{"$f":"G71+I71","v":0},{"$f":"SUMIFS(I40:I70,K40:K70,\"V\")","v":0},"DEBIT",null,{"$f":"SUM(L40:L70)-L76","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,{"$f":"N434","v":0},"Possibilité investissement SUR Validé"]
["P",null,"Protection données du mois",{"$f":"A39","v":"FEVRIER"},null,null,null,{"$f":"VLOOKUP(9^9,H$40:H$70,1)","v":0},null,null,null,null,{"$f":"M37","v":0}]
["KIKO"]
["MARS","Date","Désignation","Crédit","   V","Code","Valeur","Solde","Valeur","Code","V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,{"$f":"SUMIFS(D76,E76,\"V\")","v":0},{"$f":"IF(G76<>\"\",G76+H73+I76)","v":0},{"$f":"(SUMIFS(L76,K76,\"V\"))*-1","v":0},null,"v",{"$f":"SUMIFS(L40:L70,K40:K70,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,0,{"$f":"IF(G77<>\"\",G77+H76+I77)","v":0},0,null,null,null,null,null,2]
[null,null,null,null,null,null,0,{"$f":"IF(G78<>\"\",G78+H77+I78)","v":0},0,null,null,null,null,null,3]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,4]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,5]
[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]
[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,0,0,null,null,null,null,null,12]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,13]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,14]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,15]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,16]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,17]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,18]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,19]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,20]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,21]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,22]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,23]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,24]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,25]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,26]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,27]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,28]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,29]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,30]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D76:D106)","v":0},"CREDIT",null,{"$f":"SUMIFS(G76:G106,E76:E106,\"V\")","v":0},{"$f":"G107+I107","v":0},{"$f":"SUMIFS(I76:I106,K76:K106,\"V\")","v":0},"DEBIT",null,{"$f":"SUM(L76:L106)-L112","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,{"$f":"N434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A75","v":"MARS"},null,null,null,{"$f":"VLOOKUP(9^9,H$76:H$106,1)","v":0},null,null,null,null,{"$f":"M73","v":0}]
["KIKO"]
["AVRIL","Date","Désignation","Crédit","   V","Code","Valeur","Solde","Valeur","Code","V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,{"$f":"SUMIFS(D112,E112,\"V\")","v":0},{"$f":"IF(G112<>\"\",G112+H109+I112)","v":0},{"$f":"(SUMIFS(L112,K112,\"V\"))*-1","v":0},null,"v",{"$f":"SUMIFS(L76:L106,K76:K106,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,0,{"$f":"IF(G113<>\"\",G113+H112+I113)","v":0},0,null,null,null,null,null,2]
[null,null,null,null,null,null,0,{"$f":"IF(G114<>\"\",G114+H113+I114)","v":0},0,null,null,null,null,null,3]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,4]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,5]
[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]
[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,0,0,null,null,null,null,null,12]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,13]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,14]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,15]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,16]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,17]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,18]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,19]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,20]
[null,null,null,null,null,null,0,{"$f":"IF(G132<>\"\",G132+H131+I132)","v":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,0,0,null,null,null,null,null,28]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,29]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,30]
[null,null,null,null,null,null,0,{"$f":"IF(G142<>\"\",G142+H141+I142)","v":0},0,null,null,null,null,null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D112:D142)","v":0},"CREDIT",null,{"$f":"SUMIFS(G112:G142,E112:E142,\"V\")","v":0},{"$f":"G143+I143","v":0},{"$f":"SUMIFS(I112:I142,K112:K142,\"V\")","v":0},"DEBIT",null,{"$f":"SUM(L112:L142)-L148","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,{"$f":"N434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A111","v":"AVRIL"},null,null,null,{"$f":"VLOOKUP(9^9,H$112:H$142,1)","v":0},null,null,null,null,{"$f":"M109","v":0}]
["KIKO"]
["MAI","Date","Désignation","Crédit","   V","Code","Valeur","Solde","Valeur","Code","V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,{"$f":"SUMIFS(D148,E148,\"V\")","v":0},{"$f":"IF(G148<>\"\",G148+H145+I148)","v":0},{"$f":"(SUMIFS(L148,K148,\"V\"))*-1","v":0},null,"v",{"$f":"SUMIFS(L112:L142,K112:K142,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,0,{"$f":"IF(G149<>\"\",G149+H148+I149)","v":0},0,null,null,null,null,null,2]
[null,null,null,null,null,null,0,{"$f":"IF(G150<>\"\",G150+H149+I150)","v":0},0,null,null,null,null,null,3]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,4]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,5]
[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]
[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,0,0,null,null,null,null,null,12]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,13]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,14]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,15]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,16]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,17]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,18]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,19]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,20]
[null,null,null,null,null,null,0,{"$f":"IF(G168<>\"\",G168+H167+I168)","v":0},0,null,null,null,null,null,21]
[null,null,null,null,null,null,0,{"$f":"IF(G169<>\"\",G169+H168+I169)","v":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,0,0,null,null,null,null,null,28]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,29]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,30]
[null,null,null,null,null,null,0,{"$f":"IF(G178<>\"\",G178+H177+I178)","v":0},0,null,null,null,null,null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D148:D178)","v":0},"CREDIT",null,{"$f":"SUMIFS(G148:G178,E148:E178,\"V\")","v":0},{"$f":"G179+I179","v":0},{"$f":"SUMIFS(I148:I178,K148:K178,\"V\")","v":0},"DEBIT",null,{"$f":"SUM(L148:L178)-L184","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,{"$f":"N434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A147","v":"MAI"},null,null,null,{"$f":"VLOOKUP(9^9,H$148:H$178,1)","v":0},null,null,null,null,{"$f":"M145","v":0}]
["KIKO"]
["JUIN","Date","Désignation","Crédit","   V","Code","Valeur","Solde","Valeur","Code","V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,{"$f":"SUMIFS(D184,E184,\"V\")","v":0},{"$f":"IF(G184<>\"\",G184+H181+I184)","v":0},{"$f":"(SUMIFS(L184,K184,\"V\"))*-1","v":0},null,"v",{"$f":"SUMIFS(L148:L178,K148:K178,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,0,{"$f":"IF(G185<>\"\",G185+H184+I185)","v":0},0,null,null,null,null,null,2]
[null,null,null,null,null,null,0,{"$f":"IF(G186<>\"\",G186+H185+I186)","v":0},0,null,null,null,null,null,3]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,4]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,5]
[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]
[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,0,0,null,null,null,null,null,12]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,13]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,14]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,15]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,16]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,17]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,18]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,19]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,20]
[null,null,null,null,null,null,0,{"$f":"IF(G204<>\"\",G204+H203+I204)","v":0},0,null,null,null,null,null,21]
[null,null,null,null,null,null,0,{"$f":"IF(G205<>\"\",G205+H204+I205)","v":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,0,0,null,null,null,null,null,28]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,29]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,30]
[null,null,null,null,null,null,0,{"$f":"IF(G214<>\"\",G214+H213+I214)","v":0},0,null,null,null,null,null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D184:D214)","v":0},"CREDIT",null,{"$f":"SUMIFS(G184:G214,E184:E214,\"V\")","v":0},{"$f":"G215+I215","v":0},{"$f":"SUMIFS(I184:I214,K184:K214,\"V\")","v":0},"DEBIT",null,{"$f":"SUM(L184:L214)-L220","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,{"$f":"N434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A183","v":"JUIN"},null,null,null,{"$f":"VLOOKUP(9^9,H$184:H$214,1)","v":0},null,null,null,null,{"$f":"M181","v":0}]
["KIKO"]
["JUILLET","Date","Désignation","Crédit","   V","Code","Valeur","Solde","Valeur","Code","V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,{"$f":"SUMIFS(D220,E220,\"V\")","v":0},{"$f":"IF(G220<>\"\",G220+H217+I220)","v":0},{"$f":"(SUMIFS(L220,K220,\"V\"))*-1","v":0},null,"v",{"$f":"SUMIFS(L184:L214,K184:K214,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,0,{"$f":"IF(G221<>\"\",G221+H220+I221)","v":0},0,null,null,null,null,null,2]
[null,null,null,null,null,null,0,{"$f":"IF(G222<>\"\",G222+H221+I222)","v":0},0,null,null,null,null,null,3]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,4]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,5]
[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]
[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,0,0,null,null,null,null,null,12]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,13]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,14]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,15]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,16]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,17]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,18]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,19]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,20]
[null,null,null,null,null,null,0,{"$f":"IF(G240<>\"\",G240+H239+I240)","v":0},0,null,null,null,null,null,21]
[null,null,null,null,null,null,0,{"$f":"IF(G241<>\"\",G241+H240+I241)","v":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,0,0,null,null,null,null,null,28]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,29]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,30]
[null,null,null,null,null,null,0,{"$f":"IF(G250<>\"\",G250+H249+I250)","v":0},0,null,null,null,null,null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D220:D250)","v":0},"CREDIT",null,{"$f":"SUMIFS(G220:G250,E220:E250,\"V\")","v":0},{"$f":"G251+I251","v":0},{"$f":"SUMIFS(I220:I250,K220:K250,\"V\")","v":0},"DEBIT",null,{"$f":"SUM(L220:L250)-L256","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,{"$f":"N434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A219","v":"JUILLET"},null,null,null,{"$f":"VLOOKUP(9^9,H$220:H$250,1)","v":0},null,null,null,null,{"$f":"M217","v":0}]
["KIKO"]
["AOÛT","Date","Désignation","Crédit","   V","Code","Valeur","Solde","Valeur","Code","V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,{"$f":"SUMIFS(D256,E256,\"V\")","v":0},{"$f":"IF(G256<>\"\",G256+H253+I256)","v":0},{"$f":"(SUMIFS(L256,K256,\"V\"))*-1","v":0},null,"v",{"$f":"SUMIFS(L220:L250,K220:K250,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,0,{"$f":"IF(G257<>\"\",G257+H256+I257)","v":0},0,null,null,null,null,null,2]
[null,null,null,null,null,null,0,{"$f":"IF(G258<>\"\",G258+H257+I258)","v":0},0,null,null,null,null,null,3]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,4]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,5]
[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]
[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,0,0,null,null,null,null,null,12]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,13]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,14]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,15]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,16]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,17]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,18]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,19]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,20]
[null,null,null,null,null,null,0,{"$f":"IF(G276<>\"\",G276+H275+I276)","v":0},0,null,null,null,null,null,21]
[null,null,null,null,null,null,0,{"$f":"IF(G277<>\"\",G277+H276+I277)","v":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,0,0,null,null,null,null,null,28]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,29]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,30]
[null,null,null,null,null,null,0,{"$f":"IF(G286<>\"\",G286+H285+I286)","v":0},0,null,null,null,null,null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D256:D286)","v":0},"CREDIT",null,{"$f":"SUMIFS(G256:G286,E256:E286,\"V\")","v":0},{"$f":"G287+I287","v":0},{"$f":"SUMIFS(I256:I286,K256:K286,\"V\")","v":0},"DEBIT",null,{"$f":"SUM(L256:L286)-L292","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,{"$f":"N434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A255","v":"AOÛT"},null,null,null,{"$f":"VLOOKUP(9^9,H$256:H$286,1)","v":0},null,null,null,null,{"$f":"M253","v":0}]
["KIKO"]
["SEPTEMBRE","Date","Désignation","Crédit","   V","Code","Valeur","Solde","Valeur","Code","V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,{"$f":"SUMIFS(D292,E292,\"V\")","v":0},{"$f":"IF(G292<>\"\",G292+H289+I292)","v":0},{"$f":"(SUMIFS(L292,K292,\"V\"))*-1","v":0},null,"v",{"$f":"SUMIFS(L256:L286,K256:K286,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,0,{"$f":"IF(G293<>\"\",G293+H292+I293)","v":0},0,null,null,null,null,null,2]
[null,null,null,null,null,null,0,{"$f":"IF(G294<>\"\",G294+H293+I294)","v":0},0,null,null,null,null,null,3]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,4]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,5]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,6]
[null,null,null,null,null,null,0,{"$f":"IF(G298<>\"\",G298+H297+I298)","v":0},0,null,null,null,null,null,7]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,8]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,9]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,10]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,11]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,12]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,13]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,14]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,15]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,16]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,17]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,18]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,19]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,20]
[null,null,null,null,null,null,0,{"$f":"IF(G312<>\"\",G312+H311+I312)","v":0},0,null,null,null,null,null,21]
[null,null,null,null,null,null,0,{"$f":"IF(G313<>\"\",G313+H312+I313)","v":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,0,0,null,null,null,null,null,28]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,29]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,30]
[null,null,null,null,null,null,0,{"$f":"IF(G322<>\"\",G322+H321+I322)","v":0},0,null,null,null,null,null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D292:D322)","v":0},"CREDIT",null,{"$f":"SUMIFS(G292:G322,E292:E322,\"V\")","v":0},{"$f":"G323+I323","v":0},{"$f":"SUMIFS(I292:I322,K292:K322,\"V\")","v":0},"DEBIT",null,{"$f":"SUM(L292:M322)-L328","v":0}," Débit non Validé moins Différé"]
["KIKO",null,null,{"$f":"E432","v":0},null,null,null,null,null,null,null,{"$f":"N434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A291","v":"SEPTEMBRE"},null,null,null,{"$f":"VLOOKUP(9^9,H$292:H$322,1)","v":0},null,null,null,null,{"$f":"M289","v":0}]
["KIKO"]
["OCTOBRE","Date","Désignation","Crédit","   V","Code","Valeur","Solde","Valeur","Code","V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,{"$f":"SUMIFS(D328,E328,\"V\")","v":0},{"$f":"IF(G328<>\"\",G328+H325+I328)","v":0},{"$f":"(SUMIFS(L328,K328,\"V\"))*-1","v":0},null,"v",{"$f":"SUMIFS(L292:L322,K292:K322,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,0,{"$f":"IF(G329<>\"\",G329+H328+I329)","v":0},0,null,null,null,null,null,2]
[null,null,null,null,null,null,0,{"$f":"IF(G330<>\"\",G330+H329+I330)","v":0},0,null,null,null,null,null,3]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,4]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,5]
[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]
[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,0,0,null,null,null,null,null,12]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,13]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,14]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,15]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,16]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,17]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,18]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,19]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,20]
[null,null,null,null,null,null,0,{"$f":"IF(G348<>\"\",G348+H347+I348)","v":0},0,null,null,null,null,null,21]
[null,null,null,null,null,null,0,{"$f":"IF(G349<>\"\",G349+H348+I349)","v":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,0,0,null,null,null,null,null,28]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,29]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,30]
[null,null,null,null,null,null,0,{"$f":"IF(G358<>\"\",G358+H357+I358)","v":0},0,null,null,null,null,null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D328:D358)","v":0},"CREDIT",null,{"$f":"SUMIFS(G328:G358,E328:E358,\"V\")","v":0},{"$f":"G359+I359","v":0},{"$f":"SUMIFS(I328:I358,K328:K358,\"V\")","v":0},"DEBIT",null,{"$f":"SUM(L328:L358)-L364","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,{"$f":"N434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A327","v":"OCTOBRE"},null,null,null,{"$f":"VLOOKUP(9^9,H$328:H$358,1)","v":0},null,null,null,null,{"$f":"M325","v":0}]
["KIKO"]
["NOVEMBRE","Date","Désignation","Crédit","   V","Code","Valeur","Solde","Valeur","Code","V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,{"$f":"SUMIFS(D364,E364,\"V\")","v":0},{"$f":"IF(G364<>\"\",G364+H361+I364)","v":0},{"$f":"(SUMIFS(L364,K364,\"V\"))*-1","v":0},null,"v",{"$f":"SUMIFS(L328:L358,K328:K358,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,0,{"$f":"IF(G365<>\"\",G365+H364+I365)","v":0},0,null,null,null,null,null,2]
[null,null,null,null,null,null,0,{"$f":"IF(G366<>\"\",G366+H365+I366)","v":0},0,null,null,null,null,null,3]
[null,null,null,null,null,null,0,{"$f":"IF(G367<>\"\",G367+H366+I367)","v":0},0,null,null,null,null,null,4]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,5]
[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]
[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,0,0,null,null,null,null,null,12]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,13]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,14]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,15]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,16]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,17]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,18]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,19]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,20]
[null,null,null,null,null,null,0,{"$f":"IF(G384<>\"\",G384+H383+I384)","v":0},0,null,null,null,null,null,21]
[null,null,null,null,null,null,0,{"$f":"IF(G385<>\"\",G385+H384+I385)","v":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,0,0,null,null,null,null,null,28]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,29]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,30]
[null,null,null,null,null,null,0,{"$f":"IF(G394<>\"\",G394+H393+I394)","v":0},0,null,null,null,null,null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D364:D394)","v":0},"CREDIT",null,{"$f":"SUMIFS(G364:G394,E364:E394,\"V\")","v":0},{"$f":"G395+I395","v":0},{"$f":"SUMIFS(I364:I394,K364:K394,\"V\")","v":0},"DEBIT",null,{"$f":"SUM(L364:L394)-L400","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,{"$f":"N434","v":0},"Possibilité investissement SUR Validé"]
[null,null,null,{"$f":"A363","v":"NOVEMBRE"},null,null,null,{"$f":"VLOOKUP(9^9,H$364:H$394,1)","v":0},null,null,null,null,{"$f":"M361","v":0}]
["KIKO"]
["DÉCEMBRE","Date","Désignation","Crédit","   V","Code","Valeur","Solde","Valeur","Code","V/D","Débit","Désignation","Date"]
[null,null,null,null,null,null,{"$f":"SUMIFS(D400,E400,\"V\")","v":0},{"$f":"IF(G400<>\"\",G400+H397+I400)","v":0},{"$f":"(SUMIFS(L400,K400,\"V\"))*-1","v":0},null,"v",{"$f":"SUMIFS(L364:L394,K364:K394,\"D\")","v":0},"Cartes Mois précédent",null,1]
[null,null,null,null,null,null,0,{"$f":"IF(G401<>\"\",G401+H400+I401)","v":0},0,null,null,null,null,null,2]
[null,null,null,null,null,null,0,{"$f":"IF(G402<>\"\",G402+H401+I402)","v":0},0,null,null,null,null,null,3]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,4]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,5]
[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]
[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,0,0,null,null,null,null,null,12]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,13]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,14]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,15]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,16]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,17]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,18]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,19]
[null,null,null,null,null,null,0,0,0,null,null,null,null,null,20]
[null,null,null,null,null,null,0,{"$f":"IF(G420<>\"\",G420+H419+I420)","v":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,0,0,null,null,null,null,null,28]
[null,null,null,null,null,null,0,{"$f":"IF(G428<>\"\",G428+H427+I428)","v":0},0,null,null,null,null,null,31]
[null,null,"Crédit non Validé",{"$f":"SUM(D400:D428)","v":0},"CREDIT",null,{"$f":"SUMIFS(G400:G428,E400:E428,\"V\")","v":0},{"$f":"G429+I429","v":0},{"$f":"SUMIFS(I400:I428,K400:K428,\"V\")","v":0},"DEBIT",null,{"$f":"SUM(L400:L428)-L430","v":0}," Débit non Validé moins Différé"]
[null,null,null,null,null,null,{"$f":"M397","v":0},null,null,null,"D",{"$f":"SUMIFS(L400:L428,K400:K428,\"D\")","v":0},"Cartes Mois précédent"]
[]
[null,"Possibilité investissement sur  NON Validé",null,null,{"$f":"Feuil1!B42","v":0},null,{"$f":"SUMIFS(D432,E432,\"V\")","v":0},null,null,{"$f":"N434","v":0},null,"Possibilité investissement SUR Validé"]
[null,"A valider pour proportionnel",null,null,null,{"$f":"A399","v":"DÉCEMBRE"},null,{"$f":"VLOOKUP(9^9,H$400:H$428,1)","v":0},null,null,null,null,"A valider pour proportionnel"]
["MOIS",12,"BUDGET DEPENSES",{"$f":"G434/B434","v":0},null,null,{"$f":"Feuil1!G42","v":0},{"$f":"N434*L434","v":0},null,"MOIS",null,12,"BUDGET DEPENSES",{"$f":"H433/L434","v":0}]
[null,null,"Montant a ajouter",{"$f":"E432*B434","v":0},null,null,null,null,null,null,"Montant a ajouter",null,{"$f":"J432*L434","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'!L433","v":0},null,"mois","POSSIBILITE EN PROPORTIONNALITE SUR L ANNEE"]
[null,null,null,{"$f":"C19","v":12}]
[1,"JANVIER",{"$f":"'Frais annuel 22'!H37","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'!H73","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'!H109","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'!H145","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[5,"MAI",{"$f":"'Frais annuel 22'!H181","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[6,"JUIN",{"$f":"'Frais annuel 22'!H217","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[7,"JUILLET",{"$f":"'Frais annuel 22'!H253","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[8,"AOÛT",{"$f":"'Frais annuel 22'!H289","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[9,"SEPTEMBRE",{"$f":"'Frais annuel 22'!H325","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[10,"OCTOBRE",{"$f":"'Frais annuel 22'!H361","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[11,"NOVEMBRE",{"$f":"'Frais annuel 22'!H397","v":0},0,0,0,0,0,{"$error":"#DIV/0!"}]
[12,"DÉCEMBRE",{"$f":"'Frais annuel 22'!H433","v":0},0,0,0,0,0,{"$f":"G17/F17","v":{"$error":"#DIV/0!"}}]
[]
[null,{"$f":"C17/C19","v":0},{"$f":"'Frais annuel 22'!L434","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'!G3","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'!L35","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'!L71","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'!L107","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'!L143","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!D143","v":0}]
[5,"MAI",{"$f":"'Frais annuel 22'!L179","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!D179","v":0}]
[6,"JUIN",{"$f":"'Frais annuel 22'!L215","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!D215","v":0}]
[7,"JUILLET",{"$f":"'Frais annuel 22'!L251","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!D251","v":0}]
[8,"AOÛT",{"$f":"'Frais annuel 22'!L287","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!D287","v":0}]
[9,"SEPTEMBRE",{"$f":"'Frais annuel 22'!L323","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!D323","v":0}]
[10,"OCTOBRE",{"$f":"'Frais annuel 22'!L359","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!D359","v":0}]
[11,"NOVEMBRE",{"$f":"'Frais annuel 22'!L395","v":0},0,0,0,0,0,{"$error":"#DIV/0!"},{"$f":"'Frais annuel 22'!D395","v":0}]
[12,"DÉCEMBRE",{"$f":"'Frais annuel 22'!L429","v":0},0,0,0,0,0,{"$f":"G39/F39","v":{"$error":"#DIV/0!"}},{"$f":"'Frais annuel 22'!D429","v":0}]
[null,null,{"$f":"SUM(C28:C39)","v":0},null,null,null,null,null,null,{"$f":"SUM(J28:J39)","v":0}]
[null,null,null,null,null,{"$f":"J42-C40","v":0},null,null,null,{"$f":"+C25","v":0}]
[{"$f":"B42*C42","v":0},{"$f":"C44/C42","v":0},{"$f":"'Frais annuel 22'!B434","v":12},{"$f":"B26/C42","v":0},null,null,{"$f":"SUM(G28:G40)","v":0},null,null,{"$f":"SUM(J40:J41)","v":0}]
[null,null,null,null,null,null,{"$f":"C42","v":12}]
[null,"validation",{"$f":"F41","v":0},{"$f":"J42-C40","v":0},null,null,{"$f":"G42/G43","v":0}]

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