{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Recapitulatif état dossier","Dossiers","Facturation","Recap par client"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":8,"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":"Recapitulatif état dossier","index":0,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Date",{"$f":"TODAY()","v":"2018-03-20"}]
[]
["Total Dossiers",{"$f":"SUM(Factures[Facturation totale])","v":62273.39},null,null,"Chiffre d'affaire"]
[null,null,null,null,null,null,"Honoraires HT "]
["Cash Dehors",{"$f":"B3-G6-G5-G7","v":6044.5},null,null,"Total encaissé en 2016",null,{"$f":"SUMIFS(Factures[Montant 1],Factures[Etat1],\"Facture close\",Factures[Date de paiement 1],\"<31/12/2016\")+SUMIFS(Factures[Montant 2],Factures[Etat2],\"Facture close\",Factures[Date de paiement 2],\"<31/12/2016\")+SUMIFS(Factures[Montant 4],Factures[Etat 4],\"Facture close\",Factures[Date de paiement 4],\"<31/12/2016\")","v":0}]
[null,null,null,null,"Total encaissé en 2017",null,{"$f":"SUMIFS(Factures[Montant 1],Factures[Etat1],\"Facture close\",Factures[Date de paiement 1],\"<31/12/2017\",Factures[Date de paiement 1],\">31/12/2016\")+SUMIFS(Factures[Montant 2],Factures[Etat2],\"Facture close\",Factures[Date de paiement 2],\"<31/12/2017\", Factures[Date de paiement 2],\">31/12/2016\")+SUMIFS(Factures[Montant 4],Factures[Etat 4],\"Facture close\",Factures[Date de paiement 4],\"<31/12/2017\",Factures[Date de paiement 4],\">31/12/2016\")","v":32798.89}]
["Dont a facturer",{"$f":"SUMIFS(Factures[Facturation totale],Factures[Etat1],\"A FACTURER\")+SUMIFS(Factures[Montant 2],Factures[Etat2],\"A FACTURER\")+SUMIFS(Factures[Montant 3],Factures[Etat 3],\"A FACTURER\")+SUMIFS(Factures[Montant 4],Factures[Etat 4],\"A FACTURER\")","v":3000},null,null,"Total encaissé en 2018",null,{"$f":"SUMIFS(Factures[Montant 1],Factures[Etat1],\"Facture close\",Factures[Date de paiement 1],\">31/12/2017\")+SUMIFS(Factures[Montant 2],Factures[Etat2],\"Facture close\",Factures[Date de paiement 2],\">31/12/2017\")+SUMIFS(Factures[Montant 4],Factures[Etat 4],\"Facture close\",Factures[Date de paiement 4],\">31/12/2017\")+SUMIFS(Factures[Montant 3],Factures[Etat 3],\"Facture close\",Factures[Date de paiement 3],\">31/12/2017\")","v":23430}]
[]
[]
["FACTURES EN ATTENTE DE PAIEMENT"]
["En attente de paiement dossiers 2016",null,{"$f":"SUMIFS(Factures[Montant 1],Factures[Etat1],\"En attente de paiement\",Factures[Date d''émission 1],\"<31/12/2016\")+SUMIFS(Factures[Montant 2],Factures[Etat2],\"En attente de paiement\",Factures[Date d''émission 2],\"<31/12/2016\")+SUMIFS(Factures[Montant 4],Factures[Etat 3],\"En attente de paiement\",Factures[Date d''émission 3],\"<31/12/2016\")","v":0},null,null,2017,2018]
["En attente de paiement dossiers 2017",null,{"$f":"SUMIFS(Factures[Montant 1],Factures[Etat1],\"En attente de paiement\",Factures[Date d''émission 1],\"<31/12/2017\")+SUMIFS(Factures[Montant 2],Factures[Etat2],\"En attente de paiement\",Factures[Date d''émission 2],\"<31/12/2017\")+SUMIFS(Factures[Montant 4],Factures[Etat 4],\"En attente de paiement\",Factures[Date d''émission 4],\"<31/12/2017\")+SUMIFS(Factures[Montant 3],Factures[Etat 3],\"En attente de paiement\",Factures[Date d''émission 3],\"<31/12/2017\")","v":0},null,"black encaissé",{"$f":"Facturation!F60+Facturation!L8+Facturation!F69+Facturation!F73+Facturation!F43","v":428.9},{"$f":"Facturation!R11","v":0}]
["En attente de paiement dossiers 2018",null,{"$f":"SUMIFS(Factures[Montant 1],Factures[Etat1],\"En attente de paiement\",Factures[Date d''émission 1],\">31/12/2017\")+SUMIFS(Factures[Montant 2],Factures[Etat2],\"En attente de paiement\",Factures[Date d''émission 2],\">31/12/2017\")+SUMIFS(Factures[Montant 4],Factures[Etat 4],\"En attente de paiement\",Factures[Date d''émission 4],\">31/12/2017\")+SUMIFS(Factures[Montant 3],Factures[Etat 3],\"En attente de paiement\",Factures[Date d''émission 3],\">31/12/2017\")","v":1750},null,"Imposable",{"$f":"G6-F12","v":32369.989999999998},{"$f":"G7-G12","v":23430}]
["Total",null,{"$f":"SUM(C11:C13)","v":1750}]
[]
[null,null,null,null,null,"Nouveaux dossiers entrant 2018"]
[null,null,"Ludo","Autres"]
["Rétrocession  au titre de 2017",null,{"$f":"SUMIFS(#REF!,#REF!,\"<31/12/2017\")","v":{"$error":"#REF!"}},null,null,{"$f":"SUMIFS(#REF!,Dossier[Date entrée],\">31/12/2017\")","v":{"$error":"#REF!"}}]
["rétrocessionau titre de 2018",null,{"$f":"SUMIFS(#REF!,#REF!,\">31/12/2017\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,\">31/12/2017\")","v":{"$error":"#REF!"}}]
["Total",null,{"$f":"SUM(C18:C19)","v":{"$error":"#REF!"}},{"$f":"SUM(D18:D19)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,null,null,null,"Honoraire HT fisca"]
[null,null,null,null,null,"Total facturé et payé en 2017 pour 2017",null,{"$f":"SUMIFS(Factures[Montant 1],Factures[Etat1],\"Facture close\",Factures[Date d''émission 1],\"<31/12/2017\",Factures[Date d''émission 1],\">31/12/2016\")+SUMIFS(Factures[Montant 2],Factures[Etat2],\"Facture close\",Factures[Date d''émission 2],\"<31/12/2017\",Factures[Date d''émission 2],\">31/12/2016\")+SUMIFS(Factures[Montant 4],Factures[Etat 4],\"Facture close\",Factures[Date d''émission 4],\"<31/12/2017\",Factures[Date d''émission 4],\">31/12/2016\")","v":36548.89}]
[null,null,null,null,null,"Total facturé et encaissé en 2017  pour 2017",null,{"$f":"SUMIFS(Factures[Montant 1],Factures[Etat1],\"Facture close\",Factures[Date d''émission 1],\"<31/12/2017\",Factures[Date d''émission 1],\">31/12/2016\",Factures[Date de paiement 1],\"<31/12/2017\")+SUMIFS(Factures[Montant 2],Factures[Etat2],\"Facture close\",Factures[Date d''émission 2],\"<31/12/2017\",Factures[Date d''émission 2],\">31/12/2016\",Factures[Date de paiement 2],\">31/12/2017\")+SUMIFS(Factures[Montant 4],Factures[Etat 4],\"Facture close\",Factures[Date d''émission 4],\"<31/12/2017\",Factures[Date d''émission 4],\">31/12/2016\",Factures[Date de paiement 4],\">31/12/2017\")","v":16775.099999999999}]
[null,null,null,null,null,"Provisions ",null,{"$f":"H24-H25","v":19773.79}]

{"sheet":"Dossiers","index":1,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["NOM","Nom du dossier","Type de Dossier","Date entrée","Etat facturation",null,null,null,null,"Corporate","oui","variable"]
["balot","c/ d1","Commercial",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"Dossier Clos"},null,null,null,null,"Social"]
["cdh","Cdh c/ annuaie","Commercial",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"En cours"},null,null,null,null,"Civil"]
["cdh","c/ Pierre","Commercial",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"Dossier Clos"},null,null,null,null,"Commercial"]
["cdh","c/sosie","Commercial",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"En cours"},null,null,null,null,"penal"]
["cote machin","Consultation Coté c/ Taurus","Commercial",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"Dossier Clos"}]
["dora","dora licenciement","Social",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"En cours"}]
["lesvins d alsace","Levée de fonds","Corporate",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"Dossier Clos"}]
["dotera","c/ L2","Civil",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"En cours"}]
["desire","c/ veolia","Social",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"Dossier Clos"}]
["Groupe C","Remboursement frais","Social",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"Dossier Clos"}]
["Groupe C","Demi-journées janvier février 2017","Social",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"Dossier Clos"}]
["Groupe C","Capital c/MORINA","Social",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"En cours"}]
["Groupe C","capital c/C6","Social",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"Dossier Clos"}]
["Groupe C","Postulation ","Social",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"Dossier Clos"}]
["Groupe C","Demi-journées mars avril 2017","Social",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"Dossier Clos"}]
["cdh","Demi-journées mai juin 2017","Social",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"En cours"}]
[null,null,"Social",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"Dossier Clos"}]
[null,null,"Social",null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"Dossier Clos"}]
[null,null,null,null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"Dossier Clos"}]
[null,null,null,null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"Dossier Clos"}]
[null,null,null,null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"Dossier Clos"}]
[null,null,null,null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"Dossier Clos"}]
[null,null,null,null,{"$f":"IF(Factures[[#This Row],[somme]]=Factures[[#This Row],[Facturation totale]],\"Dossier Clos\",\"En cours\")","v":"Dossier Clos"}]

{"sheet":"Facturation","index":2,"n_rows":106,"n_cols":39,"rows_kept":106,"cut":false,"hidden":false,"merged":[[0,5,0,10],[0,11,0,16],[0,17,0,22],[0,23,0,28]]}
[null,null,null,null,null,"Facture 1",null,null,null,null,null,"Facture 2",null,null,null,null,null,"Facture 3",null,null,null,null,null,"Facture 4"]
["Nom","Dossier","Etat de la procédure","Modalités factu","Facturation totale","Montant 1","N ° Facture 1","Date d'émission 1","Date de paiement 1","Restant dû 1","Etat1","Montant 2","N° Facture 2","Date d'émission 2","Date de paiement 2","Restant dû 2","Etat2","Montant 3","N° Facture 3","Date d'émission 3","Date de paiement 3","Montant dû 3","Etat 3","Montant 4","N° Facture ","Date d'émission 4","Date de paiement 4","Montant dû 4","Etat 4","somme",null,null,null,null,"Numérote clients",null,null,"Liste clients"]
[{"$f":"IF(ISERROR(Dossier[[#This Row],[NOM]]),\"\",Dossier[[#This Row],[NOM]])","v":"balot"},{"$f":"Dossier[[#This Row],[Nom du dossier]]","v":"c/ d1"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 4]]","v":1253.2},853.2,"17-8-2","2017-08-28","2017-10-23",{"$f":"IF(Factures[[#This Row],[Date de paiement 1]]<>\"\",Factures[[#This Row],[Facturation totale]]-Factures[[#This Row],[Montant 1]],Factures[[#This Row],[Facturation totale]])","v":400},{"$f":"IF(Factures[[#This Row],[Date d''émission 1]]=\"\",\"A FACTURER\",IF(Factures[[#This Row],[Date de paiement 1]]=\"\",\"En attente de paiement\", \"Facture close\"))","v":"Facture close"},400,"17-8-4","2017-08-31","2017-10-23",{"$f":"IF(Factures[[#This Row],[Date de paiement 2]]=\"\",Factures[[#This Row],[Restant dû 1]],Factures[[#This Row],[Restant dû 1]]-Factures[[#This Row],[Montant 2]])","v":0},{"$f":"IF(AND(Factures[[#This Row],[Restant dû 2]]<>Factures[[#This Row],[Montant 2]],Factures[[#This Row],[Date de paiement 2]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 2]]<>\"\",Factures[[#This Row],[Date de paiement 2]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 2]]<>\"\",\"A FACTURER\",\"\")))","v":"facture close"},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 3]]=\"\",Factures[[#This Row],[Restant dû 2]],Factures[[#This Row],[Restant dû 2]]-Factures[[#This Row],[Montant 3]])","v":0},{"$f":"IF(AND([Montant dû 3]<>Factures[[#This Row],[Montant 3]],Factures[[#This Row],[Date de paiement 3]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 3]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 3]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 4]]=\"\",Factures[[#This Row],[Montant dû 3]],Factures[[#This Row],[Montant dû 3]]-Factures[[#This Row],[Montant 4]])","v":0},{"$f":"IF(AND([Montant dû 4]<>Factures[[#This Row],[Montant 4]],Factures[[#This Row],[Date de paiement 4]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 4]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 4]]<>\"\",\"A FACTURER\",\"\")))","v":""},{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":1253.2},null,null,null,null,{"$f":"IF(A3=\"\",\"\",IF(COUNTIF(A$3:A3,A3)=1,MAX(AI$2:AI2)+1,\"\"))","v":1},null,1,{"$f":"IFERROR(INDEX(A:A,MATCH(AK3,AI:AI,0)),\"\")","v":"balot"}," La colonne A est triée par ordre alphabétique"]
[{"$f":"IF(ISERROR(Dossier[[#This Row],[NOM]]),\"\",Dossier[[#This Row],[NOM]])","v":"cdh"},{"$f":"Dossier[[#This Row],[Nom du dossier]]","v":"Cdh c/ annuaie"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 4]]","v":1750},1750,"18-3-1","2018-03-06",null,{"$f":"IF(Factures[[#This Row],[Date de paiement 1]]<>\"\",Factures[[#This Row],[Facturation totale]]-Factures[[#This Row],[Montant 1]],Factures[[#This Row],[Facturation totale]])","v":1750},{"$f":"IF(Factures[[#This Row],[Date d''émission 1]]=\"\",\"A FACTURER\",IF(Factures[[#This Row],[Date de paiement 1]]=\"\",\"En attente de paiement\", \"Facture close\"))","v":"En attente de paiement"},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 2]]=\"\",Factures[[#This Row],[Restant dû 1]],Factures[[#This Row],[Restant dû 1]]-Factures[[#This Row],[Montant 2]])","v":1750},{"$f":"IF(AND(Factures[[#This Row],[Restant dû 2]]<>Factures[[#This Row],[Montant 2]],Factures[[#This Row],[Date de paiement 2]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 2]]<>\"\",Factures[[#This Row],[Date de paiement 2]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 2]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 3]]=\"\",Factures[[#This Row],[Restant dû 2]],Factures[[#This Row],[Restant dû 2]]-Factures[[#This Row],[Montant 3]])","v":1750},{"$f":"IF(AND([Montant dû 3]<>Factures[[#This Row],[Montant 3]],Factures[[#This Row],[Date de paiement 3]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 3]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 3]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 4]]=\"\",Factures[[#This Row],[Montant dû 3]],Factures[[#This Row],[Montant dû 3]]-Factures[[#This Row],[Montant 4]])","v":1750},{"$f":"IF(AND([Montant dû 4]<>Factures[[#This Row],[Montant 4]],Factures[[#This Row],[Date de paiement 4]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 4]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 4]]<>\"\",\"A FACTURER\",\"\")))","v":""},{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":5250},null,null,null,null,{"$f":"IF(A4=\"\",\"\",IF(COUNTIF(A$3:A4,A4)=1,MAX(AI$2:AI3)+1,\"\"))","v":2},null,2,{"$f":"IFERROR(INDEX(A:A,MATCH(AK4,AI:AI,0)),\"\")","v":"cdh"}]
[{"$f":"IF(ISERROR(Dossier[[#This Row],[NOM]]),\"\",Dossier[[#This Row],[NOM]])","v":"cdh"},{"$f":"Dossier[[#This Row],[Nom du dossier]]","v":"c/ Pierre"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 4]]","v":250},250,"17-2-7","2017-02-22","2017-03-21",{"$f":"IF(Factures[[#This Row],[Date de paiement 1]]<>\"\",Factures[[#This Row],[Facturation totale]]-Factures[[#This Row],[Montant 1]],Factures[[#This Row],[Facturation totale]])","v":0},{"$f":"IF(Factures[[#This Row],[Date d''émission 1]]=\"\",\"A FACTURER\",IF(Factures[[#This Row],[Date de paiement 1]]=\"\",\"En attente de paiement\", \"Facture close\"))","v":"Facture close"},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 2]]=\"\",Factures[[#This Row],[Restant dû 1]],Factures[[#This Row],[Restant dû 1]]-Factures[[#This Row],[Montant 2]])","v":0},{"$f":"IF(AND(Factures[[#This Row],[Restant dû 2]]<>Factures[[#This Row],[Montant 2]],Factures[[#This Row],[Date de paiement 2]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 2]]<>\"\",Factures[[#This Row],[Date de paiement 2]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 2]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 3]]=\"\",Factures[[#This Row],[Restant dû 2]],Factures[[#This Row],[Restant dû 2]]-Factures[[#This Row],[Montant 3]])","v":0},{"$f":"IF(AND([Montant dû 3]<>Factures[[#This Row],[Montant 3]],Factures[[#This Row],[Date de paiement 3]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 3]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 3]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 4]]=\"\",Factures[[#This Row],[Montant dû 3]],Factures[[#This Row],[Montant dû 3]]-Factures[[#This Row],[Montant 4]])","v":0},{"$f":"IF(AND([Montant dû 4]<>Factures[[#This Row],[Montant 4]],Factures[[#This Row],[Date de paiement 4]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 4]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 4]]<>\"\",\"A FACTURER\",\"\")))","v":""},{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":250},null,null,null,null,{"$f":"IF(A5=\"\",\"\",IF(COUNTIF(A$3:A5,A5)=1,MAX(AI$2:AI4)+1,\"\"))","v":""},null,3,"cote machin","Liste dynamique qui s'adapte en longueur à la liste de noms"]
[{"$f":"IF(ISERROR(Dossier[[#This Row],[NOM]]),\"\",Dossier[[#This Row],[NOM]])","v":"cdh"},{"$f":"Dossier[[#This Row],[Nom du dossier]]","v":"c/sosie"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 4]]","v":6000},3000,"17-05-07","2017-05-15","2017-05-30",{"$f":"IF(Factures[[#This Row],[Date de paiement 1]]<>\"\",Factures[[#This Row],[Facturation totale]]-Factures[[#This Row],[Montant 1]],Factures[[#This Row],[Facturation totale]])","v":3000},{"$f":"IF(Factures[[#This Row],[Date d''émission 1]]=\"\",\"A FACTURER\",IF(Factures[[#This Row],[Date de paiement 1]]=\"\",\"En attente de paiement\", \"Facture close\"))","v":"Facture close"},3000,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 2]]=\"\",Factures[[#This Row],[Restant dû 1]],Factures[[#This Row],[Restant dû 1]]-Factures[[#This Row],[Montant 2]])","v":3000},{"$f":"IF(AND(Factures[[#This Row],[Restant dû 2]]<>Factures[[#This Row],[Montant 2]],Factures[[#This Row],[Date de paiement 2]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 2]]<>\"\",Factures[[#This Row],[Date de paiement 2]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 2]]<>\"\",\"A FACTURER\",\"\")))","v":"A FACTURER"},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 3]]=\"\",Factures[[#This Row],[Restant dû 2]],Factures[[#This Row],[Restant dû 2]]-Factures[[#This Row],[Montant 3]])","v":3000},{"$f":"IF(AND([Montant dû 3]<>Factures[[#This Row],[Montant 3]],Factures[[#This Row],[Date de paiement 3]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 3]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 3]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 4]]=\"\",Factures[[#This Row],[Montant dû 3]],Factures[[#This Row],[Montant dû 3]]-Factures[[#This Row],[Montant 4]])","v":3000},{"$f":"IF(AND([Montant dû 4]<>Factures[[#This Row],[Montant 4]],Factures[[#This Row],[Date de paiement 4]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 4]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 4]]<>\"\",\"A FACTURER\",\"\")))","v":""},{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":12000},null,null,null,null,{"$f":"IF(A6=\"\",\"\",IF(COUNTIF(A$3:A6,A6)=1,MAX(AI$2:AI5)+1,\"\"))","v":""},null,4,"dora","nommée clients (voir Gestionnaire de noms)"]
[{"$f":"IF(ISERROR(Dossier[[#This Row],[NOM]]),\"\",Dossier[[#This Row],[NOM]])","v":"cote machin"},{"$f":"Dossier[[#This Row],[Nom du dossier]]","v":"Consultation Coté c/ Taurus"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 4]]","v":500},500,"17-2-9","2017-03-01","2017-03-21",{"$f":"IF(Factures[[#This Row],[Date de paiement 1]]<>\"\",Factures[[#This Row],[Facturation totale]]-Factures[[#This Row],[Montant 1]],Factures[[#This Row],[Facturation totale]])","v":0},{"$f":"IF(Factures[[#This Row],[Date d''émission 1]]=\"\",\"A FACTURER\",IF(Factures[[#This Row],[Date de paiement 1]]=\"\",\"En attente de paiement\", \"Facture close\"))","v":"Facture close"},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 2]]=\"\",Factures[[#This Row],[Restant dû 1]],Factures[[#This Row],[Restant dû 1]]-Factures[[#This Row],[Montant 2]])","v":0},{"$f":"IF(AND(Factures[[#This Row],[Restant dû 2]]<>Factures[[#This Row],[Montant 2]],Factures[[#This Row],[Date de paiement 2]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 2]]<>\"\",Factures[[#This Row],[Date de paiement 2]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 2]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 3]]=\"\",Factures[[#This Row],[Restant dû 2]],Factures[[#This Row],[Restant dû 2]]-Factures[[#This Row],[Montant 3]])","v":0},{"$f":"IF(AND([Montant dû 3]<>Factures[[#This Row],[Montant 3]],Factures[[#This Row],[Date de paiement 3]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 3]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 3]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 4]]=\"\",Factures[[#This Row],[Montant dû 3]],Factures[[#This Row],[Montant dû 3]]-Factures[[#This Row],[Montant 4]])","v":0},{"$f":"IF(AND([Montant dû 4]<>Factures[[#This Row],[Montant 4]],Factures[[#This Row],[Date de paiement 4]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 4]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 4]]<>\"\",\"A FACTURER\",\"\")))","v":""},{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":500},null,null,null,null,{"$f":"IF(A7=\"\",\"\",IF(COUNTIF(A$3:A7,A7)=1,MAX(AI$2:AI6)+1,\"\"))","v":3},null,5,{"$f":"IFERROR(INDEX(A:A,MATCH(AK7,AI:AI,0)),\"\")","v":"lesvins d alsace"},"avec pour formule pour la référence :"]
[{"$f":"IF(ISERROR(Dossier[[#This Row],[NOM]]),\"\",Dossier[[#This Row],[NOM]])","v":"dora"},{"$f":"Dossier[[#This Row],[Nom du dossier]]","v":"dora licenciement"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 4]]","v":1293.0999999999999},432.4,"17-05-13","2017-05-31","2017-07-07",{"$f":"IF(Factures[[#This Row],[Date de paiement 1]]<>\"\",Factures[[#This Row],[Facturation totale]]-Factures[[#This Row],[Montant 1]],Factures[[#This Row],[Facturation totale]])","v":860.69999999999993},{"$f":"IF(Factures[[#This Row],[Date d''émission 1]]=\"\",\"A FACTURER\",IF(Factures[[#This Row],[Date de paiement 1]]=\"\",\"En attente de paiement\", \"Facture close\"))","v":"Facture close"},428.9,"17-6-3","2017-06-20","2017-07-07",{"$f":"IF(Factures[[#This Row],[Date de paiement 2]]=\"\",Factures[[#This Row],[Restant dû 1]],Factures[[#This Row],[Restant dû 1]]-Factures[[#This Row],[Montant 2]])","v":431.79999999999995},{"$f":"IF(AND(Factures[[#This Row],[Restant dû 2]]<>Factures[[#This Row],[Montant 2]],Factures[[#This Row],[Date de paiement 2]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 2]]<>\"\",Factures[[#This Row],[Date de paiement 2]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 2]]<>\"\",\"A FACTURER\",\"\")))","v":"facture close"},431.8,"17-6-6","2017-06-30","2017-07-07",{"$f":"IF(Factures[[#This Row],[Date de paiement 3]]=\"\",Factures[[#This Row],[Restant dû 2]],Factures[[#This Row],[Restant dû 2]]-Factures[[#This Row],[Montant 3]])","v":-5.6843418860808015E-14},{"$f":"IF(AND([Montant dû 3]<>Factures[[#This Row],[Montant 3]],Factures[[#This Row],[Date de paiement 3]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 3]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 3]]<>\"\",\"A FACTURER\",\"\")))","v":"facture close"},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 4]]=\"\",Factures[[#This Row],[Montant dû 3]],Factures[[#This Row],[Montant dû 3]]-Factures[[#This Row],[Montant 4]])","v":-5.6843418860808015E-14},{"$f":"IF(AND([Montant dû 4]<>Factures[[#This Row],[Montant 4]],Factures[[#This Row],[Date de paiement 4]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 4]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 4]]<>\"\",\"A FACTURER\",\"\")))","v":""},{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":1724.8999999999999},null,null,null,null,{"$f":"IF(A8=\"\",\"\",IF(COUNTIF(A$3:A8,A8)=1,MAX(AI$2:AI7)+1,\"\"))","v":4},null,6,"dotera","=DECALER(Facturation!$AL$3;;;NB.SI(Facturation!$AL:$AL;\">=a\")-1)"]
[{"$f":"IF(ISERROR(Dossier[[#This Row],[NOM]]),\"\",Dossier[[#This Row],[NOM]])","v":"lesvins d alsace"},{"$f":"Dossier[[#This Row],[Nom du dossier]]","v":"Levée de fonds"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 4]]","v":600},300,"17-2-8","2017-02-24","2017-03-01",{"$f":"IF(Factures[[#This Row],[Date de paiement 1]]<>\"\",Factures[[#This Row],[Facturation totale]]-Factures[[#This Row],[Montant 1]],Factures[[#This Row],[Facturation totale]])","v":300},{"$f":"IF(Factures[[#This Row],[Date d''émission 1]]=\"\",\"A FACTURER\",IF(Factures[[#This Row],[Date de paiement 1]]=\"\",\"En attente de paiement\", \"Facture close\"))","v":"Facture close"},300,"17-3-6","2017-03-22","2017-03-30",{"$f":"IF(Factures[[#This Row],[Date de paiement 2]]=\"\",Factures[[#This Row],[Restant dû 1]],Factures[[#This Row],[Restant dû 1]]-Factures[[#This Row],[Montant 2]])","v":0},{"$f":"IF(AND(Factures[[#This Row],[Restant dû 2]]<>Factures[[#This Row],[Montant 2]],Factures[[#This Row],[Date de paiement 2]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 2]]<>\"\",Factures[[#This Row],[Date de paiement 2]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 2]]<>\"\",\"A FACTURER\",\"\")))","v":"facture close"},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 3]]=\"\",Factures[[#This Row],[Restant dû 2]],Factures[[#This Row],[Restant dû 2]]-Factures[[#This Row],[Montant 3]])","v":0},{"$f":"IF(AND([Montant dû 3]<>Factures[[#This Row],[Montant 3]],Factures[[#This Row],[Date de paiement 3]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 3]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 3]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 4]]=\"\",Factures[[#This Row],[Montant dû 3]],Factures[[#This Row],[Montant dû 3]]-Factures[[#This Row],[Montant 4]])","v":0},{"$f":"IF(AND([Montant dû 4]<>Factures[[#This Row],[Montant 4]],Factures[[#This Row],[Date de paiement 4]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 4]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 4]]<>\"\",\"A FACTURER\",\"\")))","v":""},{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":600},null,null,null,null,{"$f":"IF(A9=\"\",\"\",IF(COUNTIF(A$3:A9,A9)=1,MAX(AI$2:AI8)+1,\"\"))","v":5},null,7,"desire"]
[{"$f":"IF(ISERROR(Dossier[[#This Row],[NOM]]),\"\",Dossier[[#This Row],[NOM]])","v":"dotera"},{"$f":"Dossier[[#This Row],[Nom du dossier]]","v":"c/ L2"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 4]]","v":21680},2500,"16 - 33","2016-12-06","2017-03-29",{"$f":"IF(Factures[[#This Row],[Date de paiement 1]]<>\"\",Factures[[#This Row],[Facturation totale]]-Factures[[#This Row],[Montant 1]],Factures[[#This Row],[Facturation totale]])","v":19180},{"$f":"IF(Factures[[#This Row],[Date d''émission 1]]=\"\",\"A FACTURER\",IF(Factures[[#This Row],[Date de paiement 1]]=\"\",\"En attente de paiement\", \"Facture close\"))","v":"Facture close"},2000,"17-05-11","2017-05-21","2017-05-30",{"$f":"IF(Factures[[#This Row],[Date de paiement 2]]=\"\",Factures[[#This Row],[Restant dû 1]],Factures[[#This Row],[Restant dû 1]]-Factures[[#This Row],[Montant 2]])","v":17180},{"$f":"IF(AND(Factures[[#This Row],[Restant dû 2]]<>Factures[[#This Row],[Montant 2]],Factures[[#This Row],[Date de paiement 2]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 2]]<>\"\",Factures[[#This Row],[Date de paiement 2]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 2]]<>\"\",\"A FACTURER\",\"\")))","v":"facture close"},17180,"17-12-3 et 11111","2017-12-26","2018-01-15",{"$f":"IF(Factures[[#This Row],[Date de paiement 3]]=\"\",Factures[[#This Row],[Restant dû 2]],Factures[[#This Row],[Restant dû 2]]-Factures[[#This Row],[Montant 3]])","v":0},{"$f":"IF(AND([Montant dû 3]<>Factures[[#This Row],[Montant 3]],Factures[[#This Row],[Date de paiement 3]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 3]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 3]]<>\"\",\"A FACTURER\",\"\")))","v":"facture close"},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 4]]=\"\",Factures[[#This Row],[Montant dû 3]],Factures[[#This Row],[Montant dû 3]]-Factures[[#This Row],[Montant 4]])","v":0},{"$f":"IF(AND([Montant dû 4]<>Factures[[#This Row],[Montant 4]],Factures[[#This Row],[Date de paiement 4]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 4]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 4]]<>\"\",\"A FACTURER\",\"\")))","v":""},{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":38860},null,null,null,null,{"$f":"IF(A10=\"\",\"\",IF(COUNTIF(A$3:A10,A10)=1,MAX(AI$2:AI9)+1,\"\"))","v":6},null,8,"Groupe C","Cette liste va servir à la liste de choix de Recap"]
[{"$f":"IF(ISERROR(Dossier[[#This Row],[NOM]]),\"\",Dossier[[#This Row],[NOM]])","v":"desire"},{"$f":"Dossier[[#This Row],[Nom du dossier]]","v":"c/ veolia"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 4]]","v":12182.17},1000,"17-2-6 ","2017-02-22","2017-05-30",{"$f":"IF(Factures[[#This Row],[Date de paiement 1]]<>\"\",Factures[[#This Row],[Facturation totale]]-Factures[[#This Row],[Montant 1]],Factures[[#This Row],[Facturation totale]])","v":11182.17},{"$f":"IF(Factures[[#This Row],[Date d''émission 1]]=\"\",\"A FACTURER\",IF(Factures[[#This Row],[Date de paiement 1]]=\"\",\"En attente de paiement\", \"Facture close\"))","v":"Facture close"},11182.17,"111111","2017-01-01","2017-11-02",{"$f":"IF(Factures[[#This Row],[Date de paiement 2]]=\"\",Factures[[#This Row],[Restant dû 1]],Factures[[#This Row],[Restant dû 1]]-Factures[[#This Row],[Montant 2]])","v":0},{"$f":"IF(AND(Factures[[#This Row],[Restant dû 2]]<>Factures[[#This Row],[Montant 2]],Factures[[#This Row],[Date de paiement 2]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 2]]<>\"\",Factures[[#This Row],[Date de paiement 2]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 2]]<>\"\",\"A FACTURER\",\"\")))","v":"facture close"},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 3]]=\"\",Factures[[#This Row],[Restant dû 2]],Factures[[#This Row],[Restant dû 2]]-Factures[[#This Row],[Montant 3]])","v":0},{"$f":"IF(AND([Montant dû 3]<>Factures[[#This Row],[Montant 3]],Factures[[#This Row],[Date de paiement 3]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 3]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 3]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 4]]=\"\",Factures[[#This Row],[Montant dû 3]],Factures[[#This Row],[Montant dû 3]]-Factures[[#This Row],[Montant 4]])","v":0},{"$f":"IF(AND([Montant dû 4]<>Factures[[#This Row],[Montant 4]],Factures[[#This Row],[Date de paiement 4]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 4]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 4]]<>\"\",\"A FACTURER\",\"\")))","v":""},{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":12182.17},null,null,null,null,{"$f":"IF(A11=\"\",\"\",IF(COUNTIF(A$3:A11,A11)=1,MAX(AI$2:AI10)+1,\"\"))","v":7},null,9,0]
[{"$f":"IF(ISERROR(Dossier[[#This Row],[NOM]]),\"\",Dossier[[#This Row],[NOM]])","v":"Groupe C"},{"$f":"Dossier[[#This Row],[Nom du dossier]]","v":"Remboursement frais"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 4]]","v":2500},2500,"17-03-04","2017-03-21","2017-03-02",{"$f":"IF(Factures[[#This Row],[Date de paiement 1]]<>\"\",Factures[[#This Row],[Facturation totale]]-Factures[[#This Row],[Montant 1]],Factures[[#This Row],[Facturation totale]])","v":0},{"$f":"IF(Factures[[#This Row],[Date d''émission 1]]=\"\",\"A FACTURER\",IF(Factures[[#This Row],[Date de paiement 1]]=\"\",\"En attente de paiement\", \"Facture close\"))","v":"Facture close"},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 2]]=\"\",Factures[[#This Row],[Restant dû 1]],Factures[[#This Row],[Restant dû 1]]-Factures[[#This Row],[Montant 2]])","v":0},{"$f":"IF(AND(Factures[[#This Row],[Restant dû 2]]<>Factures[[#This Row],[Montant 2]],Factures[[#This Row],[Date de paiement 2]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 2]]<>\"\",Factures[[#This Row],[Date de paiement 2]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 2]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 3]]=\"\",Factures[[#This Row],[Restant dû 2]],Factures[[#This Row],[Restant dû 2]]-Factures[[#This Row],[Montant 3]])","v":0},{"$f":"IF(AND([Montant dû 3]<>Factures[[#This Row],[Montant 3]],Factures[[#This Row],[Date de paiement 3]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 3]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 3]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 4]]=\"\",Factures[[#This Row],[Montant dû 3]],Factures[[#This Row],[Montant dû 3]]-Factures[[#This Row],[Montant 4]])","v":0},{"$f":"IF(AND([Montant dû 4]<>Factures[[#This Row],[Montant 4]],Factures[[#This Row],[Date de paiement 4]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 4]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 4]]<>\"\",\"A FACTURER\",\"\")))","v":""},{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":2500},null,null,null,null,{"$f":"IF(A12=\"\",\"\",IF(COUNTIF(A$3:A12,A12)=1,MAX(AI$2:AI11)+1,\"\"))","v":8},null,10,""]
[{"$f":"IF(ISERROR(Dossier[[#This Row],[NOM]]),\"\",Dossier[[#This Row],[NOM]])","v":"Groupe C"},{"$f":"Dossier[[#This Row],[Nom du dossier]]","v":"Demi-journées janvier février 2017"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 4]]","v":58.7},58.7,"17-1-7","2017-01-24","2017-05-09",{"$f":"IF(Factures[[#This Row],[Date de paiement 1]]<>\"\",Factures[[#This Row],[Facturation totale]]-Factures[[#This Row],[Montant 1]],Factures[[#This Row],[Facturation totale]])","v":0},{"$f":"IF(Factures[[#This Row],[Date d''émission 1]]=\"\",\"A FACTURER\",IF(Factures[[#This Row],[Date de paiement 1]]=\"\",\"En attente de paiement\", \"Facture close\"))","v":"Facture close"},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 2]]=\"\",Factures[[#This Row],[Restant dû 1]],Factures[[#This Row],[Restant dû 1]]-Factures[[#This Row],[Montant 2]])","v":0},{"$f":"IF(AND(Factures[[#This Row],[Restant dû 2]]<>Factures[[#This Row],[Montant 2]],Factures[[#This Row],[Date de paiement 2]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 2]]<>\"\",Factures[[#This Row],[Date de paiement 2]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 2]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 3]]=\"\",Factures[[#This Row],[Restant dû 2]],Factures[[#This Row],[Restant dû 2]]-Factures[[#This Row],[Montant 3]])","v":0},{"$f":"IF(AND([Montant dû 3]<>Factures[[#This Row],[Montant 3]],Factures[[#This Row],[Date de paiement 3]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 3]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 3]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 4]]=\"\",Factures[[#This Row],[Montant dû 3]],Factures[[#This Row],[Montant dû 3]]-Factures[[#This Row],[Montant 4]])","v":0},{"$f":"IF(AND([Montant dû 4]<>Factures[[#This Row],[Montant 4]],Factures[[#This Row],[Date de paiement 4]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 4]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 4]]<>\"\",\"A FACTURER\",\"\")))","v":""},{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":58.7},null,null,null,null,{"$f":"IF(A13=\"\",\"\",IF(COUNTIF(A$3:A13,A13)=1,MAX(AI$2:AI12)+1,\"\"))","v":""},null,11,""]
[{"$f":"IF(ISERROR(Dossier[[#This Row],[NOM]]),\"\",Dossier[[#This Row],[NOM]])","v":"Groupe C"},{"$f":"Dossier[[#This Row],[Nom du dossier]]","v":"Capital c/MORINA"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 4]]","v":1661.61},800,"17-1-4","2017-01-12","2017-05-09",{"$f":"IF(Factures[[#This Row],[Date de paiement 1]]<>\"\",Factures[[#This Row],[Facturation totale]]-Factures[[#This Row],[Montant 1]],Factures[[#This Row],[Facturation totale]])","v":861.6099999999999},{"$f":"IF(Factures[[#This Row],[Date d''émission 1]]=\"\",\"A FACTURER\",IF(Factures[[#This Row],[Date de paiement 1]]=\"\",\"En attente de paiement\", \"Facture close\"))","v":"Facture close"},430.81,"17-2-1","2017-02-09","2017-05-23",{"$f":"IF(Factures[[#This Row],[Date de paiement 2]]=\"\",Factures[[#This Row],[Restant dû 1]],Factures[[#This Row],[Restant dû 1]]-Factures[[#This Row],[Montant 2]])","v":430.7999999999999},{"$f":"IF(AND(Factures[[#This Row],[Restant dû 2]]<>Factures[[#This Row],[Montant 2]],Factures[[#This Row],[Date de paiement 2]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 2]]<>\"\",Factures[[#This Row],[Date de paiement 2]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 2]]<>\"\",\"A FACTURER\",\"\")))","v":"facture close"},430.8,"17-2-4","2017-02-22","2017-05-23",{"$f":"IF(Factures[[#This Row],[Date de paiement 3]]=\"\",Factures[[#This Row],[Restant dû 2]],Factures[[#This Row],[Restant dû 2]]-Factures[[#This Row],[Montant 3]])","v":-1.1368683772161603E-13},{"$f":"IF(AND([Montant dû 3]<>Factures[[#This Row],[Montant 3]],Factures[[#This Row],[Date de paiement 3]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 3]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 3]]<>\"\",\"A FACTURER\",\"\")))","v":"facture close"},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 4]]=\"\",Factures[[#This Row],[Montant dû 3]],Factures[[#This Row],[Montant dû 3]]-Factures[[#This Row],[Montant 4]])","v":-1.1368683772161603E-13},{"$f":"IF(AND([Montant dû 4]<>Factures[[#This Row],[Montant 4]],Factures[[#This Row],[Date de paiement 4]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 4]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 4]]<>\"\",\"A FACTURER\",\"\")))","v":""},{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":2092.41},null,null,null,null,{"$f":"IF(A14=\"\",\"\",IF(COUNTIF(A$3:A14,A14)=1,MAX(AI$2:AI13)+1,\"\"))","v":""},null,12,""]
[{"$f":"IF(ISERROR(Dossier[[#This Row],[NOM]]),\"\",Dossier[[#This Row],[NOM]])","v":"Groupe C"},{"$f":"Dossier[[#This Row],[Nom du dossier]]","v":"capital c/C6"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 4]]","v":2300},2300,"17-1-3","2017-01-24","2017-03-15",{"$f":"IF(Factures[[#This Row],[Date de paiement 1]]<>\"\",Factures[[#This Row],[Facturation totale]]-Factures[[#This Row],[Montant 1]],Factures[[#This Row],[Facturation totale]])","v":0},{"$f":"IF(Factures[[#This Row],[Date d''émission 1]]=\"\",\"A FACTURER\",IF(Factures[[#This Row],[Date de paiement 1]]=\"\",\"En attente de paiement\", \"Facture close\"))","v":"Facture close"},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 2]]=\"\",Factures[[#This Row],[Restant dû 1]],Factures[[#This Row],[Restant dû 1]]-Factures[[#This Row],[Montant 2]])","v":0},{"$f":"IF(AND(Factures[[#This Row],[Restant dû 2]]<>Factures[[#This Row],[Montant 2]],Factures[[#This Row],[Date de paiement 2]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 2]]<>\"\",Factures[[#This Row],[Date de paiement 2]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 2]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 3]]=\"\",Factures[[#This Row],[Restant dû 2]],Factures[[#This Row],[Restant dû 2]]-Factures[[#This Row],[Montant 3]])","v":0},{"$f":"IF(AND([Montant dû 3]<>Factures[[#This Row],[Montant 3]],Factures[[#This Row],[Date de paiement 3]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 3]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 3]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 4]]=\"\",Factures[[#This Row],[Montant dû 3]],Factures[[#This Row],[Montant dû 3]]-Factures[[#This Row],[Montant 4]])","v":0},{"$f":"IF(AND([Montant dû 4]<>Factures[[#This Row],[Montant 4]],Factures[[#This Row],[Date de paiement 4]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 4]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 4]]<>\"\",\"A FACTURER\",\"\")))","v":""},{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":2300},null,null,null,null,{"$f":"IF(A15=\"\",\"\",IF(COUNTIF(A$3:A15,A15)=1,MAX(AI$2:AI14)+1,\"\"))","v":""},null,13,""]
[{"$f":"IF(ISERROR(Dossier[[#This Row],[NOM]]),\"\",Dossier[[#This Row],[NOM]])","v":"Groupe C"},{"$f":"Dossier[[#This Row],[Nom du dossier]]","v":"Postulation "},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 4]]","v":2500},2500,"17-1-2","2017-01-24","2017-05-09",{"$f":"IF(Factures[[#This Row],[Date de paiement 1]]<>\"\",Factures[[#This Row],[Facturation totale]]-Factures[[#This Row],[Montant 1]],Factures[[#This Row],[Facturation totale]])","v":0},{"$f":"IF(Factures[[#This Row],[Date d''émission 1]]=\"\",\"A FACTURER\",IF(Factures[[#This Row],[Date de paiement 1]]=\"\",\"En attente de paiement\", \"Facture close\"))","v":"Facture close"},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 2]]=\"\",Factures[[#This Row],[Restant dû 1]],Factures[[#This Row],[Restant dû 1]]-Factures[[#This Row],[Montant 2]])","v":0},{"$f":"IF(AND(Factures[[#This Row],[Restant dû 2]]<>Factures[[#This Row],[Montant 2]],Factures[[#This Row],[Date de paiement 2]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 2]]<>\"\",Factures[[#This Row],[Date de paiement 2]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 2]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 3]]=\"\",Factures[[#This Row],[Restant dû 2]],Factures[[#This Row],[Restant dû 2]]-Factures[[#This Row],[Montant 3]])","v":0},{"$f":"IF(AND([Montant dû 3]<>Factures[[#This Row],[Montant 3]],Factures[[#This Row],[Date de paiement 3]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 3]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 3]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 4]]=\"\",Factures[[#This Row],[Montant dû 3]],Factures[[#This Row],[Montant dû 3]]-Factures[[#This Row],[Montant 4]])","v":0},{"$f":"IF(AND([Montant dû 4]<>Factures[[#This Row],[Montant 4]],Factures[[#This Row],[Date de paiement 4]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 4]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 4]]<>\"\",\"A FACTURER\",\"\")))","v":""},{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":2500},null,null,null,null,{"$f":"IF(A16=\"\",\"\",IF(COUNTIF(A$3:A16,A16)=1,MAX(AI$2:AI15)+1,\"\"))","v":""},null,14,""]
[{"$f":"IF(ISERROR(Dossier[[#This Row],[NOM]]),\"\",Dossier[[#This Row],[NOM]])","v":"Groupe C"},{"$f":"Dossier[[#This Row],[Nom du dossier]]","v":"Demi-journées mars avril 2017"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 4]]","v":200},200,"17-2-5","2017-02-22","2017-05-23",{"$f":"IF(Factures[[#This Row],[Date de paiement 1]]<>\"\",Factures[[#This Row],[Facturation totale]]-Factures[[#This Row],[Montant 1]],Factures[[#This Row],[Facturation totale]])","v":0},{"$f":"IF(Factures[[#This Row],[Date d''émission 1]]=\"\",\"A FACTURER\",IF(Factures[[#This Row],[Date de paiement 1]]=\"\",\"En attente de paiement\", \"Facture close\"))","v":"Facture close"},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 2]]=\"\",Factures[[#This Row],[Restant dû 1]],Factures[[#This Row],[Restant dû 1]]-Factures[[#This Row],[Montant 2]])","v":0},{"$f":"IF(AND(Factures[[#This Row],[Restant dû 2]]<>Factures[[#This Row],[Montant 2]],Factures[[#This Row],[Date de paiement 2]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 2]]<>\"\",Factures[[#This Row],[Date de paiement 2]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 2]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 3]]=\"\",Factures[[#This Row],[Restant dû 2]],Factures[[#This Row],[Restant dû 2]]-Factures[[#This Row],[Montant 3]])","v":0},{"$f":"IF(AND([Montant dû 3]<>Factures[[#This Row],[Montant 3]],Factures[[#This Row],[Date de paiement 3]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 3]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 3]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 4]]=\"\",Factures[[#This Row],[Montant dû 3]],Factures[[#This Row],[Montant dû 3]]-Factures[[#This Row],[Montant 4]])","v":0},{"$f":"IF(AND([Montant dû 4]<>Factures[[#This Row],[Montant 4]],Factures[[#This Row],[Date de paiement 4]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 4]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 4]]<>\"\",\"A FACTURER\",\"\")))","v":""},{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":200},null,null,null,null,{"$f":"IF(A17=\"\",\"\",IF(COUNTIF(A$3:A17,A17)=1,MAX(AI$2:AI16)+1,\"\"))","v":""},null,15,""]
[{"$f":"IF(ISERROR(Dossier[[#This Row],[NOM]]),\"\",Dossier[[#This Row],[NOM]])","v":"cdh"},{"$f":"Dossier[[#This Row],[Nom du dossier]]","v":"Demi-journées mai juin 2017"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 4]]","v":1294.6100000000001},430.8,"27-03-17","2017-03-27","2017-09-21",{"$f":"IF(Factures[[#This Row],[Date de paiement 1]]<>\"\",Factures[[#This Row],[Facturation totale]]-Factures[[#This Row],[Montant 1]],Factures[[#This Row],[Facturation totale]])","v":863.81000000000017},{"$f":"IF(Factures[[#This Row],[Date d''émission 1]]=\"\",\"A FACTURER\",IF(Factures[[#This Row],[Date de paiement 1]]=\"\",\"En attente de paiement\", \"Facture close\"))","v":"Facture close"},431.91,"17-5-4","2017-05-09","2017-07-07",{"$f":"IF(Factures[[#This Row],[Date de paiement 2]]=\"\",Factures[[#This Row],[Restant dû 1]],Factures[[#This Row],[Restant dû 1]]-Factures[[#This Row],[Montant 2]])","v":431.90000000000015},{"$f":"IF(AND(Factures[[#This Row],[Restant dû 2]]<>Factures[[#This Row],[Montant 2]],Factures[[#This Row],[Date de paiement 2]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 2]]<>\"\",Factures[[#This Row],[Date de paiement 2]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 2]]<>\"\",\"A FACTURER\",\"\")))","v":"facture close"},431.9,"17-5-10","2017-05-19","2017-07-07",{"$f":"IF(Factures[[#This Row],[Date de paiement 3]]=\"\",Factures[[#This Row],[Restant dû 2]],Factures[[#This Row],[Restant dû 2]]-Factures[[#This Row],[Montant 3]])","v":1.7053025658242404E-13},{"$f":"IF(AND([Montant dû 3]<>Factures[[#This Row],[Montant 3]],Factures[[#This Row],[Date de paiement 3]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 3]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 3]]<>\"\",\"A FACTURER\",\"\")))","v":"facture close"},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 4]]=\"\",Factures[[#This Row],[Montant dû 3]],Factures[[#This Row],[Montant dû 3]]-Factures[[#This Row],[Montant 4]])","v":1.7053025658242404E-13},{"$f":"IF(AND([Montant dû 4]<>Factures[[#This Row],[Montant 4]],Factures[[#This Row],[Date de paiement 4]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 4]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 4]]<>\"\",\"A FACTURER\",\"\")))","v":""},{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":1726.5100000000002},null,null,null,null,{"$f":"IF(A18=\"\",\"\",IF(COUNTIF(A$3:A18,A18)=1,MAX(AI$2:AI17)+1,\"\"))","v":""},null,16,""]
[{"$f":"IF(ISERROR(Dossier[[#This Row],[NOM]]),\"\",Dossier[[#This Row],[NOM]])","v":0},{"$f":"Dossier[[#This Row],[Nom du dossier]]","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 4]]","v":6250},4600,"17-11-2","2017-11-21","2018-01-15",{"$f":"IF(Factures[[#This Row],[Date de paiement 1]]<>\"\",Factures[[#This Row],[Facturation totale]]-Factures[[#This Row],[Montant 1]],Factures[[#This Row],[Facturation totale]])","v":1650},{"$f":"IF(Factures[[#This Row],[Date d''émission 1]]=\"\",\"A FACTURER\",IF(Factures[[#This Row],[Date de paiement 1]]=\"\",\"En attente de paiement\", \"Facture close\"))","v":"Facture close"},1650,"17-11-3","2017-11-21","2018-01-15",{"$f":"IF(Factures[[#This Row],[Date de paiement 2]]=\"\",Factures[[#This Row],[Restant dû 1]],Factures[[#This Row],[Restant dû 1]]-Factures[[#This Row],[Montant 2]])","v":0},{"$f":"IF(AND(Factures[[#This Row],[Restant dû 2]]<>Factures[[#This Row],[Montant 2]],Factures[[#This Row],[Date de paiement 2]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 2]]<>\"\",Factures[[#This Row],[Date de paiement 2]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 2]]<>\"\",\"A FACTURER\",\"\")))","v":"facture close"},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 3]]=\"\",Factures[[#This Row],[Restant dû 2]],Factures[[#This Row],[Restant dû 2]]-Factures[[#This Row],[Montant 3]])","v":0},{"$f":"IF(AND([Montant dû 3]<>Factures[[#This Row],[Montant 3]],Factures[[#This Row],[Date de paiement 3]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 3]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 3]]<>\"\",\"A FACTURER\",\"\")))","v":""},null,null,null,null,{"$f":"IF(Factures[[#This Row],[Date de paiement 4]]=\"\",Factures[[#This Row],[Montant dû 3]],Factures[[#This Row],[Montant dû 3]]-Factures[[#This Row],[Montant 4]])","v":0},{"$f":"IF(AND([Montant dû 4]<>Factures[[#This Row],[Montant 4]],Factures[[#This Row],[Date de paiement 4]]<>\"\"),\"facture close\",IF(AND(Factures[[#This Row],[Date d''émission 4]]<>\"\",Factures[[#This Row],[Date de paiement 4]]=\"\"),\"en attente de paiement\",IF(Factures[[#This Row],[Montant 4]]<>\"\",\"A FACTURER\",\"\")))","v":""},{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":6250},null,null,null,null,{"$f":"IF(A19=\"\",\"\",IF(COUNTIF(A$3:A19,A19)=1,MAX(AI$2:AI18)+1,\"\"))","v":9},null,17,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A20=\"\",\"\",IF(COUNTIF(A$3:A20,A20)=1,MAX(AI$2:AI19)+1,\"\"))","v":""},null,18,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A21=\"\",\"\",IF(COUNTIF(A$3:A21,A21)=1,MAX(AI$2:AI20)+1,\"\"))","v":""},null,19,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A22=\"\",\"\",IF(COUNTIF(A$3:A22,A22)=1,MAX(AI$2:AI21)+1,\"\"))","v":""},null,20,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A23=\"\",\"\",IF(COUNTIF(A$3:A23,A23)=1,MAX(AI$2:AI22)+1,\"\"))","v":""},null,21,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A24=\"\",\"\",IF(COUNTIF(A$3:A24,A24)=1,MAX(AI$2:AI23)+1,\"\"))","v":""},null,22,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A25=\"\",\"\",IF(COUNTIF(A$3:A25,A25)=1,MAX(AI$2:AI24)+1,\"\"))","v":""},null,23,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A26=\"\",\"\",IF(COUNTIF(A$3:A26,A26)=1,MAX(AI$2:AI25)+1,\"\"))","v":""},null,24,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A27=\"\",\"\",IF(COUNTIF(A$3:A27,A27)=1,MAX(AI$2:AI26)+1,\"\"))","v":""},null,25,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A28=\"\",\"\",IF(COUNTIF(A$3:A28,A28)=1,MAX(AI$2:AI27)+1,\"\"))","v":""},null,26,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A29=\"\",\"\",IF(COUNTIF(A$3:A29,A29)=1,MAX(AI$2:AI28)+1,\"\"))","v":""},null,27,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A30=\"\",\"\",IF(COUNTIF(A$3:A30,A30)=1,MAX(AI$2:AI29)+1,\"\"))","v":""},null,28,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,{"$f":"2166+1800","v":3966},"a imputer sur 2017",null,{"$f":"IF(A31=\"\",\"\",IF(COUNTIF(A$3:A31,A31)=1,MAX(AI$2:AI30)+1,\"\"))","v":""},null,29,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,"au lieu de ",{"$f":"3600+2160","v":5760},null,{"$f":"IF(A32=\"\",\"\",IF(COUNTIF(A$3:A32,A32)=1,MAX(AI$2:AI31)+1,\"\"))","v":""},null,30,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A33=\"\",\"\",IF(COUNTIF(A$3:A33,A33)=1,MAX(AI$2:AI32)+1,\"\"))","v":""},null,31,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A34=\"\",\"\",IF(COUNTIF(A$3:A34,A34)=1,MAX(AI$2:AI33)+1,\"\"))","v":""},null,32,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A35=\"\",\"\",IF(COUNTIF(A$3:A35,A35)=1,MAX(AI$2:AI34)+1,\"\"))","v":""},null,33,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A36=\"\",\"\",IF(COUNTIF(A$3:A36,A36)=1,MAX(AI$2:AI35)+1,\"\"))","v":""},null,34,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A37=\"\",\"\",IF(COUNTIF(A$3:A37,A37)=1,MAX(AI$2:AI36)+1,\"\"))","v":""},null,35,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A38=\"\",\"\",IF(COUNTIF(A$3:A38,A38)=1,MAX(AI$2:AI37)+1,\"\"))","v":""},null,36,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A39=\"\",\"\",IF(COUNTIF(A$3:A39,A39)=1,MAX(AI$2:AI38)+1,\"\"))","v":""},null,37,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A40=\"\",\"\",IF(COUNTIF(A$3:A40,A40)=1,MAX(AI$2:AI39)+1,\"\"))","v":""},null,38,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A41=\"\",\"\",IF(COUNTIF(A$3:A41,A41)=1,MAX(AI$2:AI40)+1,\"\"))","v":""},null,39,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A42=\"\",\"\",IF(COUNTIF(A$3:A42,A42)=1,MAX(AI$2:AI41)+1,\"\"))","v":""},null,40,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A43=\"\",\"\",IF(COUNTIF(A$3:A43,A43)=1,MAX(AI$2:AI42)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A44=\"\",\"\",IF(COUNTIF(A$3:A44,A44)=1,MAX(AI$2:AI43)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A45=\"\",\"\",IF(COUNTIF(A$3:A45,A45)=1,MAX(AI$2:AI44)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A46=\"\",\"\",IF(COUNTIF(A$3:A46,A46)=1,MAX(AI$2:AI45)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A47=\"\",\"\",IF(COUNTIF(A$3:A47,A47)=1,MAX(AI$2:AI46)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A48=\"\",\"\",IF(COUNTIF(A$3:A48,A48)=1,MAX(AI$2:AI47)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A49=\"\",\"\",IF(COUNTIF(A$3:A49,A49)=1,MAX(AI$2:AI48)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A50=\"\",\"\",IF(COUNTIF(A$3:A50,A50)=1,MAX(AI$2:AI49)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A51=\"\",\"\",IF(COUNTIF(A$3:A51,A51)=1,MAX(AI$2:AI50)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A52=\"\",\"\",IF(COUNTIF(A$3:A52,A52)=1,MAX(AI$2:AI51)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A53=\"\",\"\",IF(COUNTIF(A$3:A53,A53)=1,MAX(AI$2:AI52)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A54=\"\",\"\",IF(COUNTIF(A$3:A54,A54)=1,MAX(AI$2:AI53)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A55=\"\",\"\",IF(COUNTIF(A$3:A55,A55)=1,MAX(AI$2:AI54)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A56=\"\",\"\",IF(COUNTIF(A$3:A56,A56)=1,MAX(AI$2:AI55)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A57=\"\",\"\",IF(COUNTIF(A$3:A57,A57)=1,MAX(AI$2:AI56)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A58=\"\",\"\",IF(COUNTIF(A$3:A58,A58)=1,MAX(AI$2:AI57)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A59=\"\",\"\",IF(COUNTIF(A$3:A59,A59)=1,MAX(AI$2:AI58)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A60=\"\",\"\",IF(COUNTIF(A$3:A60,A60)=1,MAX(AI$2:AI59)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A61=\"\",\"\",IF(COUNTIF(A$3:A61,A61)=1,MAX(AI$2:AI60)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A62=\"\",\"\",IF(COUNTIF(A$3:A62,A62)=1,MAX(AI$2:AI61)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A63=\"\",\"\",IF(COUNTIF(A$3:A63,A63)=1,MAX(AI$2:AI62)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A64=\"\",\"\",IF(COUNTIF(A$3:A64,A64)=1,MAX(AI$2:AI63)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A65=\"\",\"\",IF(COUNTIF(A$3:A65,A65)=1,MAX(AI$2:AI64)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A66=\"\",\"\",IF(COUNTIF(A$3:A66,A66)=1,MAX(AI$2:AI65)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A67=\"\",\"\",IF(COUNTIF(A$3:A67,A67)=1,MAX(AI$2:AI66)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A68=\"\",\"\",IF(COUNTIF(A$3:A68,A68)=1,MAX(AI$2:AI67)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A69=\"\",\"\",IF(COUNTIF(A$3:A69,A69)=1,MAX(AI$2:AI68)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A70=\"\",\"\",IF(COUNTIF(A$3:A70,A70)=1,MAX(AI$2:AI69)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A71=\"\",\"\",IF(COUNTIF(A$3:A71,A71)=1,MAX(AI$2:AI70)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A72=\"\",\"\",IF(COUNTIF(A$3:A72,A72)=1,MAX(AI$2:AI71)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A73=\"\",\"\",IF(COUNTIF(A$3:A73,A73)=1,MAX(AI$2:AI72)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A74=\"\",\"\",IF(COUNTIF(A$3:A74,A74)=1,MAX(AI$2:AI73)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A75=\"\",\"\",IF(COUNTIF(A$3:A75,A75)=1,MAX(AI$2:AI74)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A76=\"\",\"\",IF(COUNTIF(A$3:A76,A76)=1,MAX(AI$2:AI75)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A77=\"\",\"\",IF(COUNTIF(A$3:A77,A77)=1,MAX(AI$2:AI76)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A78=\"\",\"\",IF(COUNTIF(A$3:A78,A78)=1,MAX(AI$2:AI77)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A79=\"\",\"\",IF(COUNTIF(A$3:A79,A79)=1,MAX(AI$2:AI78)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A80=\"\",\"\",IF(COUNTIF(A$3:A80,A80)=1,MAX(AI$2:AI79)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A81=\"\",\"\",IF(COUNTIF(A$3:A81,A81)=1,MAX(AI$2:AI80)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A82=\"\",\"\",IF(COUNTIF(A$3:A82,A82)=1,MAX(AI$2:AI81)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A83=\"\",\"\",IF(COUNTIF(A$3:A83,A83)=1,MAX(AI$2:AI82)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A84=\"\",\"\",IF(COUNTIF(A$3:A84,A84)=1,MAX(AI$2:AI83)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A85=\"\",\"\",IF(COUNTIF(A$3:A85,A85)=1,MAX(AI$2:AI84)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A86=\"\",\"\",IF(COUNTIF(A$3:A86,A86)=1,MAX(AI$2:AI85)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A87=\"\",\"\",IF(COUNTIF(A$3:A87,A87)=1,MAX(AI$2:AI86)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A88=\"\",\"\",IF(COUNTIF(A$3:A88,A88)=1,MAX(AI$2:AI87)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A89=\"\",\"\",IF(COUNTIF(A$3:A89,A89)=1,MAX(AI$2:AI88)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A90=\"\",\"\",IF(COUNTIF(A$3:A90,A90)=1,MAX(AI$2:AI89)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A91=\"\",\"\",IF(COUNTIF(A$3:A91,A91)=1,MAX(AI$2:AI90)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A92=\"\",\"\",IF(COUNTIF(A$3:A92,A92)=1,MAX(AI$2:AI91)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A93=\"\",\"\",IF(COUNTIF(A$3:A93,A93)=1,MAX(AI$2:AI92)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A94=\"\",\"\",IF(COUNTIF(A$3:A94,A94)=1,MAX(AI$2:AI93)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A95=\"\",\"\",IF(COUNTIF(A$3:A95,A95)=1,MAX(AI$2:AI94)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A96=\"\",\"\",IF(COUNTIF(A$3:A96,A96)=1,MAX(AI$2:AI95)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A97=\"\",\"\",IF(COUNTIF(A$3:A97,A97)=1,MAX(AI$2:AI96)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A98=\"\",\"\",IF(COUNTIF(A$3:A98,A98)=1,MAX(AI$2:AI97)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A99=\"\",\"\",IF(COUNTIF(A$3:A99,A99)=1,MAX(AI$2:AI98)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A100=\"\",\"\",IF(COUNTIF(A$3:A100,A100)=1,MAX(AI$2:AI99)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A101=\"\",\"\",IF(COUNTIF(A$3:A101,A101)=1,MAX(AI$2:AI100)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A102=\"\",\"\",IF(COUNTIF(A$3:A102,A102)=1,MAX(AI$2:AI101)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A103=\"\",\"\",IF(COUNTIF(A$3:A103,A103)=1,MAX(AI$2:AI102)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A104=\"\",\"\",IF(COUNTIF(A$3:A104,A104)=1,MAX(AI$2:AI103)+1,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Factures[[#This Row],[Montant dû 4]]+Factures[[#This Row],[Montant 4]]+Factures[[#This Row],[Montant 3]]+Factures[[#This Row],[Montant 2]]+Factures[[#This Row],[Montant 1]]+Factures[[#This Row],[Restant dû 2]]","v":0},null,null,null,null,{"$f":"IF(A105=\"\",\"\",IF(COUNTIF(A$3:A105,A105)=1,MAX(AI$2:AI104)+1,\"\"))","v":""}]
["Total",{"$f":"SUBTOTAL(103,[Dossier])","v":17},null,null,{"$f":"SUBTOTAL(109,[Facturation totale])","v":62273.39},{"$f":"SUBTOTAL(109,[Montant 1])","v":23975.1},null,null,null,null,null,{"$f":"SUBTOTAL(101,[Montant 2])","v":2202.6433333333334},null,null,null,null,null,{"$f":"SUBTOTAL(104,[Montant 3])","v":17180},null,null,null,null,null,{"$f":"SUBTOTAL(104,[Montant 4])","v":0},null,null,null,null,null,{"$f":"SUBTOTAL(109,[somme])","v":90247.89}]

{"sheet":"Recap par client","index":3,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Sélectionner le nom du client\ndans la liste","cdh","Groupe C","Liste déroulante à partir de la plage dynamique nommée clients basée sur la liste en AL de Facturation"]
[]
["Dossiers","Facturation totale"]
[{"$f":"IF(ROWS($1:1)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Dossier],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:1))),\"\")","v":"Remboursement frais"},{"$f":"IF(ROWS($1:1)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Facturation totale],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:1))),\"\")","v":2500}]
[{"$f":"IF(ROWS($1:2)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Dossier],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:2))),\"\")","v":"Demi-journées janvier février 2017"},{"$f":"IF(ROWS($1:2)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Facturation totale],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:2))),\"\")","v":58.7}]
[{"$f":"IF(ROWS($1:3)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Dossier],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:3))),\"\")","v":"Capital c/MORINA"},{"$f":"IF(ROWS($1:3)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Facturation totale],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:3))),\"\")","v":1661.61}]
[{"$f":"IF(ROWS($1:4)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Dossier],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:4))),\"\")","v":"capital c/C6"},{"$f":"IF(ROWS($1:4)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Facturation totale],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:4))),\"\")","v":2300}]
[{"$f":"IF(ROWS($1:5)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Dossier],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:5))),\"\")","v":"Postulation "},{"$f":"IF(ROWS($1:5)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Facturation totale],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:5))),\"\")","v":2500}]
[{"$f":"IF(ROWS($1:6)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Dossier],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:6))),\"\")","v":"Demi-journées mars avril 2017"},{"$f":"IF(ROWS($1:6)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Facturation totale],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:6))),\"\")","v":200}]
[{"$f":"IF(ROWS($1:7)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Dossier],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:7))),\"\")","v":""},{"$f":"IF(ROWS($1:7)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Facturation totale],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:7))),\"\")","v":""}]
[{"$f":"IF(ROWS($1:8)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Dossier],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:8))),\"\")","v":""},{"$f":"IF(ROWS($1:8)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Facturation totale],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:8))),\"\")","v":""}]
[{"$f":"IF(ROWS($1:9)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Dossier],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:9))),\"\")","v":""},{"$f":"IF(ROWS($1:9)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Facturation totale],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:9))),\"\")","v":""}]
[{"$f":"IF(ROWS($1:10)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Dossier],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:10))),\"\")","v":""},{"$f":"IF(ROWS($1:10)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Facturation totale],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:10))),\"\")","v":""}]
[{"$f":"IF(ROWS($1:11)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Dossier],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:11))),\"\")","v":""},{"$f":"IF(ROWS($1:11)<=COUNTIF(Factures[Nom],$C$1),INDEX(Factures[Facturation totale],SMALL(IF(Factures[Nom]=$C$1,ROW(INDIRECT(\"1:\"&ROWS(Factures[Nom])))),ROWS($1:11))),\"\")","v":""}]
[]
[null,null,"Les formules en A et B sont matricielles donc à valider par  CTRL+MAJ+ENTREE, la formule se met alors automatiquement entre accolades"]