{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Répertoire","Bd variables","mdp","Modèle consult","Notice"],"not_rendered":{"images":1,"macros":1,"defined_names":16,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Répertoire","index":0,"n_rows":502,"n_cols":23,"rows_kept":502}
["Aller voir la notice",null,"Date du jour :",{"$f":"TODAY()","v":"2015-01-08"}]
["N°: de SS","Civilité","Nom","Prénom","Date \nde \nNaissance","Âge \n(à ce jour)","Num","Intitulé\nRue, Ave, etc.","Adresse","Code \npostal","Ville","Téléphone domicile","Téléphone portable","Email","Mode de \nrèglement","Type \nde \nConsult","Montant \nde \nConsult","Complt \nde \nConsult","Montant \ndu \nComplt \nde \nConsult","Prix \ntotal","Payé à ce jour","Reste devoir","Observations"]
[259086923811745,"Mme.","BRUET","Ludivine","1958-01-19",{"$f":"IF(E3=\"\",\"\",DATEDIF(E3,$D$1,\"y\")&\" a \"&DATEDIF(E3,$D$1,\"ym\")&\" m \"&DATEDIF(E3,$D$1,\"md\")&\" j\")","v":"56 a 11 m 20 j"},4,"Chemin","des grives",38080,"Saint-Alban de Roche",null,{"v":610112185,"d":"06 10 11 21 85"},{"$nulls":3},{"$f":"IF(P3=\"\",\"\",VLOOKUP(P3,bd_prix_consult,2,FALSE))","v":""},null,{"$f":"IF(R3=\"\",\"\",VLOOKUP(R3,bd_prix_consult,2,FALSE))","v":""},{"$f":"IF(P3=\"\",\"\",IF(R3=\"\",Q3,Q3+S3))","v":""},null,{"$f":"IF(U3=\"\",\"\",IF(U3=T3,\"Soldé\",T3-U3))","v":""}]
[null,"Mme.","CURATI","Axelle",null,{"$f":"IF(E4=\"\",\"\",DATEDIF(E4,$D$1,\"y\")&\" a \"&DATEDIF(E4,$D$1,\"ym\")&\" m \"&DATEDIF(E4,$D$1,\"md\")&\" j\")","v":""},93,"Rue","d'Alep",38080,"L'isle d'Abeau",null,{"v":636936255,"d":"06 36 93 62 55"},"ax_curati@yahoo.fr",null,null,"",null,"",{"$f":"IF(P4=\"\",\"\",IF(R4=\"\",Q4,Q4+S4))","v":""},null,{"$f":"IF(U4=\"\",\"\",IF(U4=T4,\"Soldé\",T4-U4))","v":""}]
[null,"Mme.","DANISEVICIUS","Chloé",null,"",1,"Lotissement","Bellevue",38300,"Ruy Monceau",null,{"v":658859248,"d":"06 58 85 92 48"},"chloe.danisevicius@gmail.com","CMU",null,"",null,"","",null,""]
[null,"Mme.","DAVID","Christelle",null,"",8,"Rue","du 8 mai 1945 ",38080,"Saint-Alban de Roche",{"v":437031942,"d":"04 37 03 19 42"},{"$nulls":4},"",null,"","",null,""]
[260096322233355,"Mme.","DESSON","Michèle","1996-04-21","18 a 8 m 18 j",null,null,"Les Cèdres chemin du Rousset",38080,"Saint-Alban de Roche",{"v":474939224,"d":"04 74 93 92 24"},{"$nulls":4},"",null,"",{"$f":"IF(P7=\"\",\"\",IF(R7=\"\",Q7,Q7+S7))","v":""},null,"","1 R"]
[null,"Mme.","EVANO","Katia",null,"",38,"Rue","des carrières",38080,"L'isle d'Abeau",null,{"v":658909561,"d":"06 58 90 95 61"},"kevano@smartps.fr",null,null,"",null,"","",null,""]
[null,"Mme.","FPITERI","Sandra",null,"",43,"Rue","de la Roche",38080,"Saint-Alban de Roche",null,{"v":672031326,"d":"06 72 03 13 26"},"sandfpiteri@yahoo.fr",null,null,"",null,"","",null,""]
[null,"Mme.","GARDETTE","Céline",null,"",6,"Place","de Chantalouette",38080,"L'isle d'Abeau",null,{"v":682273348,"d":"06 82 27 33 48"},"gardetteceline@hotmail.com",null,null,"",null,"","",null,""]
[null,"Mme.","LABROCHE","Annette",null,"",5,"Chemin","des sources",38300,"Domarin",null,{"v":660516506,"d":"06 60 51 65 06"},{"$nulls":3},"",null,"","",null,""]
[null,"Mme.","LEFEBRE","Alexandra",null,"",83,"Boulevard","Saint hubert",38080,"L'isle d'Abeau",null,{"v":671121719,"d":"06 71 12 17 19"},"alexandra.lefebre@orange.fr",null,null,"",null,"","",null,""]
[null,"Mme.","LIMACHER","Pascale",null,"",{"$nulls":6},{"v":612559910,"d":"06 12 55 99 10"},{"$nulls":3},"",null,"","",null,""]
[null,"Mme.","MALLARD","Christine",null,"",7,"Place","de chantalouette",38080,"L'isle d'Abeau",null,{"v":672969912,"d":"06 72 96 99 12"},"mallard_christine@yahoo.fr",null,null,"",null,"","",null,""]
[null,"Mme.","MALLIERE","Magali",null,"",530,"Chemin","du sibuet ",38300,"Chateauvilain",null,{"v":630125634,"d":"06 30 12 56 34"},"magali.malliere@neuf.fr",null,null,"",null,"","",null,""]
[null,"Mme.","MERCIER","Hatice",null,"",1075,"Route","de chappez ",38300,"Saint-Savin",null,{"v":671137063,"d":"06 71 13 70 63"},{"$nulls":3},"",null,"","",null,""]
[null,"Mme.","NOWAK","Sarah",null,"","4C","Chemin","au pré",38080,"Saint-Alban de Roche",null,{"v":629500624,"d":"06 29 50 06 24"},"sarah.nowak@hotmail.fr",null,null,"",null,"","",null,""]
[null,"Mme.","TISSERAND","Erika",null,"",{"$nulls":6},{"v":684149841,"d":"06 84 14 98 41"},{"$nulls":3},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},{"$f":"IF(P35=\"\",\"\",VLOOKUP(P35,bd_prix_consult,2,FALSE))","v":""},null,{"$f":"IF(R35=\"\",\"\",VLOOKUP(R35,bd_prix_consult,2,FALSE))","v":""},"",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},{"$f":"IF(P67=\"\",\"\",VLOOKUP(P67,bd_prix_consult,2,FALSE))","v":""},null,{"$f":"IF(R67=\"\",\"\",VLOOKUP(R67,bd_prix_consult,2,FALSE))","v":""},"",null,""]
[{"$nulls":5},{"$f":"IF(E68=\"\",\"\",DATEDIF(E68,$D$1,\"y\")&\" a \"&DATEDIF(E68,$D$1,\"ym\")&\" m \"&DATEDIF(E68,$D$1,\"md\")&\" j\")","v":""},{"$nulls":10},"",null,"","",null,{"$f":"IF(U68=\"\",\"\",IF(U68=T68,\"Soldé\",T68-U68))","v":""}]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"",{"$f":"IF(P71=\"\",\"\",IF(R71=\"\",Q71,Q71+S71))","v":""},null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},{"$f":"IF(P99=\"\",\"\",VLOOKUP(P99,bd_prix_consult,2,FALSE))","v":""},null,{"$f":"IF(R99=\"\",\"\",VLOOKUP(R99,bd_prix_consult,2,FALSE))","v":""},"",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},{"$f":"IF(P131=\"\",\"\",VLOOKUP(P131,bd_prix_consult,2,FALSE))","v":""},null,{"$f":"IF(R131=\"\",\"\",VLOOKUP(R131,bd_prix_consult,2,FALSE))","v":""},"",null,""]
[{"$nulls":5},{"$f":"IF(E132=\"\",\"\",DATEDIF(E132,$D$1,\"y\")&\" a \"&DATEDIF(E132,$D$1,\"ym\")&\" m \"&DATEDIF(E132,$D$1,\"md\")&\" j\")","v":""},{"$nulls":10},"",null,"","",null,{"$f":"IF(U132=\"\",\"\",IF(U132=T132,\"Soldé\",T132-U132))","v":""}]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"",{"$f":"IF(P135=\"\",\"\",IF(R135=\"\",Q135,Q135+S135))","v":""},null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},{"$f":"IF(P163=\"\",\"\",VLOOKUP(P163,bd_prix_consult,2,FALSE))","v":""},null,{"$f":"IF(R163=\"\",\"\",VLOOKUP(R163,bd_prix_consult,2,FALSE))","v":""},"",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},{"$f":"IF(P195=\"\",\"\",VLOOKUP(P195,bd_prix_consult,2,FALSE))","v":""},null,{"$f":"IF(R195=\"\",\"\",VLOOKUP(R195,bd_prix_consult,2,FALSE))","v":""},"",null,""]
[{"$nulls":5},{"$f":"IF(E196=\"\",\"\",DATEDIF(E196,$D$1,\"y\")&\" a \"&DATEDIF(E196,$D$1,\"ym\")&\" m \"&DATEDIF(E196,$D$1,\"md\")&\" j\")","v":""},{"$nulls":10},"",null,"","",null,{"$f":"IF(U196=\"\",\"\",IF(U196=T196,\"Soldé\",T196-U196))","v":""}]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"",{"$f":"IF(P199=\"\",\"\",IF(R199=\"\",Q199,Q199+S199))","v":""},null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},{"$f":"IF(E203=\"\",\"\",DATEDIF(E203,$D$1,\"y\")&\" a \"&DATEDIF(E203,$D$1,\"ym\")&\" m \"&DATEDIF(E203,$D$1,\"md\")&\" j\")","v":""},{"$nulls":10},{"$f":"IF(P203=\"\",\"\",VLOOKUP(P203,bd_prix_consult,2,FALSE))","v":""},null,{"$f":"IF(R203=\"\",\"\",VLOOKUP(R203,bd_prix_consult,2,FALSE))","v":""},{"$f":"IF(P203=\"\",\"\",IF(R203=\"\",Q203,Q203+S203))","v":""},null,{"$f":"IF(U203=\"\",\"\",IF(U203=T203,\"Soldé\",T203-U203))","v":""}]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},{"$f":"IF(E267=\"\",\"\",DATEDIF(E267,$D$1,\"y\")&\" a \"&DATEDIF(E267,$D$1,\"ym\")&\" m \"&DATEDIF(E267,$D$1,\"md\")&\" j\")","v":""},{"$nulls":10},{"$f":"IF(P267=\"\",\"\",VLOOKUP(P267,bd_prix_consult,2,FALSE))","v":""},null,{"$f":"IF(R267=\"\",\"\",VLOOKUP(R267,bd_prix_consult,2,FALSE))","v":""},{"$f":"IF(P267=\"\",\"\",IF(R267=\"\",Q267,Q267+S267))","v":""},null,{"$f":"IF(U267=\"\",\"\",IF(U267=T267,\"Soldé\",T267-U267))","v":""}]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},{"$f":"IF(E331=\"\",\"\",DATEDIF(E331,$D$1,\"y\")&\" a \"&DATEDIF(E331,$D$1,\"ym\")&\" m \"&DATEDIF(E331,$D$1,\"md\")&\" j\")","v":""},{"$nulls":10},{"$f":"IF(P331=\"\",\"\",VLOOKUP(P331,bd_prix_consult,2,FALSE))","v":""},null,{"$f":"IF(R331=\"\",\"\",VLOOKUP(R331,bd_prix_consult,2,FALSE))","v":""},{"$f":"IF(P331=\"\",\"\",IF(R331=\"\",Q331,Q331+S331))","v":""},null,{"$f":"IF(U331=\"\",\"\",IF(U331=T331,\"Soldé\",T331-U331))","v":""}]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},{"$f":"IF(E395=\"\",\"\",DATEDIF(E395,$D$1,\"y\")&\" a \"&DATEDIF(E395,$D$1,\"ym\")&\" m \"&DATEDIF(E395,$D$1,\"md\")&\" j\")","v":""},{"$nulls":10},{"$f":"IF(P395=\"\",\"\",VLOOKUP(P395,bd_prix_consult,2,FALSE))","v":""},null,{"$f":"IF(R395=\"\",\"\",VLOOKUP(R395,bd_prix_consult,2,FALSE))","v":""},{"$f":"IF(P395=\"\",\"\",IF(R395=\"\",Q395,Q395+S395))","v":""},null,{"$f":"IF(U395=\"\",\"\",IF(U395=T395,\"Soldé\",T395-U395))","v":""}]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},{"$f":"IF(E459=\"\",\"\",DATEDIF(E459,$D$1,\"y\")&\" a \"&DATEDIF(E459,$D$1,\"ym\")&\" m \"&DATEDIF(E459,$D$1,\"md\")&\" j\")","v":""},{"$nulls":10},{"$f":"IF(P459=\"\",\"\",VLOOKUP(P459,bd_prix_consult,2,FALSE))","v":""},null,{"$f":"IF(R459=\"\",\"\",VLOOKUP(R459,bd_prix_consult,2,FALSE))","v":""},{"$f":"IF(P459=\"\",\"\",IF(R459=\"\",Q459,Q459+S459))","v":""},null,{"$f":"IF(U459=\"\",\"\",IF(U459=T459,\"Soldé\",T459-U459))","v":""}]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]
[{"$nulls":5},"",{"$nulls":10},"",null,"","",null,""]

{"sheet":"Bd variables","index":1,"n_rows":76,"n_cols":2,"rows_kept":76}
["BD"]
["intitule_rue"]
["Rue"]
["Boulevard"]
["Lotissement"]
["Chemin"]
["Route"]
["Impasse"]
["Place"]
["Quai"]
["Esplanade"]
["Avenue"]
["Ruelle"]
[]
["BD"]
["civilite"]
["Mlle."]
["Mme."]
["Mr."]
[]
["BD"]
["mode_reglement"]
["Espèces"]
["Chèque"]
["CB"]
["CMU"]
["Aucun"]
[]
["BD","BD"]
["typ_consult","prix_consult"]
["GYN",{"v":23,"d":"23.00 €"}]
["DIU",{"v":38.36,"d":"38.36 €"}]
["CG",{"v":23,"d":"23.00 €"}]
["PPN EPI",{"v":42,"d":"42.00 €"}]
["PPN",{"v":33.6,"d":"33.60 €"}]
["ES S",{"v":42,"d":"42.00 €"}]
["ES M",{"v":61.6,"d":"61.60 €"}]
["PRADO 1",{"v":46.2,"d":"46.20 €"}]
["PRADO 2",{"v":46.2,"d":"46.20 €"}]
["PRADO 3",{"v":33.6,"d":"33.60 €"}]
["R TOT",{"v":196,"d":"196.00 €"}]
["VPN",{"v":27,"d":"27.00 €"}]
["CPN",{"v":23,"d":"23.00 €"}]
["R",{"v":19.6,"d":"19.60 €"}]
["PORT IND",{"v":35,"d":"35.00 €"}]
["PORT GRP",{"v":30,"d":"30.00 €"}]
["MASS IND",{"v":35,"d":"35.00 €"}]
["MASS GRP",{"v":30,"d":"30.00 €"}]
[]
["BD"]
["Oui/Non"]
["Oui"]
["Non"]
[]
["BD"]
["GroupeRh"]
["A+"]
["A-"]
["B+"]
["B-"]
["AB+"]
["AB-"]
["O+"]
["O-"]
[]
["BD"]
["Plus/Moins"]
["+"]
["-"]
[]
["BD"]
["Sitfamille"]
["Mariée"]
["Union libre"]
["Célibataire"]
["PACS"]

{"sheet":"mdp","index":2,"n_rows":3,"n_cols":3,"rows_kept":3}
[]
[]
["Le mot de passe est : ",null,"fichclients"]

{"sheet":"Modèle consult","index":3,"n_rows":135,"n_cols":12,"rows_kept":135,"merged":[[0,0,0,4],[1,0,1,4],[1,8,1,11],[2,0,2,4],[2,8,2,11],[3,0,3,4],[3,8,3,11],[4,8,4,11],[6,0,6,12],[8,1,8,4],[8,10,8,12],[9,1,9,4],[9,6,9,8],[9,10,9,12],[11,1,11,12],[13,0,13,2],[13,3,13,6],[13,8,13,9],[13,11,13,12],[15,1,15,2],[15,4,15,5],[15,7,15,8],[15,10,15,12],[16,1,16,2],[16,4,16,5],[16,7,16,8],[16,10,16,12],[17,1,17,2],[17,4,17,5],[17,7,17,8],[17,10,17,12],[18,1,18,2],[18,4,18,5],[18,7,18,8],[18,9,18,12],[19,1,19,2],[19,4,19,5],[19,7,19,8],[19,9,19,12],[20,0,21,0],[20,1,21,2],[20,4,20,5],[20,7,20,8],[20,9,20,12],[21,4,21,5],[21,7,21,8],[21,9,21,12],[23,0,23,12],[25,0,25,12],[26,0,26,3],[26,4,26,7],[26,8,26,12],[27,0,27,3],[27,4,27,7],[27,8,27,12],[29,0,29,12],[30,0,30,3],[30,4,30,12],[31,0,31,3],[31,4,31,12],[32,0,32,3],[32,4,32,12],[34,0,34,12],[35,0,35,12],[36,0,36,12],[37,0,37,12],[39,0,39,12],[40,0,40,12],[41,1,41,3],[41,4,41,5],[41,6,41,7],[41,8,41,9],[41,11,41,12],[42,1,42,3],[42,4,42,5],[42,6,42,7],[42,8,42,9],[42,10,42,12],[43,0,43,12],[44,0,44,12],[45,0,45,12],[46,0,46,12],[47,0,47,12],[48,0,48,12],[49,0,49,12],[50,0,50,12],[51,0,51,12],[52,0,52,12],[56,0,56,12],[57,0,57,12],[58,0,58,2],[58,3,58,4],[58,5,58,6],[58,7,58,8],[58,9,58,10],[58,11,58,12],[59,0,60,2],[59,3,59,12],[60,3,60,12],[61,0,61,12],[61,14,61,16],[62,1,62,5],[62,7,62,12],[64,0,64,12],[65,0,65,1],[65,2,65,4],[65,5,65,6],[65,7,65,9],[65,10,65,12],[66,0,66,1],[66,2,66,4],[66,5,66,6],[66,7,66,9],[66,10,66,12],[67,0,67,1],[67,2,67,4],[67,5,67,6],[67,7,67,9],[67,10,67,12],[68,0,68,1],[68,2,68,4],[68,5,68,6],[68,7,68,9],[68,10,68,12],[69,0,69,1],[69,2,69,4],[69,5,69,6],[69,7,69,9],[69,10,69,12],[70,0,70,1],[70,2,70,4],[70,5,70,6],[70,7,70,9],[70,10,70,12],[71,0,71,1],[71,2,71,4],[71,5,71,6],[71,7,71,9],[71,10,71,12],[72,0,72,1],[72,2,72,4],[72,5,72,6],[72,7,72,9],[72,10,72,12],[73,0,73,1],[73,2,73,4],[73,5,73,6],[73,7,73,9],[73,10,73,12],[74,0,74,1],[74,2,74,4],[74,5,74,6],[74,7,74,9],[74,10,74,12],[75,0,75,1],[75,2,75,4],[75,5,75,6],[75,7,75,9],[75,10,75,12],[77,0,77,5],[77,6,77,12],[78,0,78,5],[78,6,78,12],[79,0,79,5],[79,6,79,12],[80,0,80,5],[80,6,80,12],[81,0,81,5],[81,6,81,12],[82,0,82,5],[82,6,82,12],[83,0,83,5],[83,6,83,12],[98,4,98,7],[100,0,100,3],[100,4,100,7],[100,8,100,12],[101,0,101,3],[101,4,101,7],[101,8,101,12],[103,0,103,12],[104,1,104,5],[104,6,104,7],[104,8,104,12],[105,1,105,5],[105,6,105,7],[105,8,105,12],[106,1,106,5],[106,6,106,7],[106,8,106,12],[107,1,107,5],[107,6,107,7],[107,8,107,12],[109,0,109,12],[110,0,110,1],[110,2,110,5],[110,6,110,9],[110,10,110,12],[111,0,111,1],[111,2,111,5],[111,6,111,7],[111,8,111,12],[112,0,112,1],[112,2,112,5],[112,6,112,7],[112,8,112,12],[113,0,113,1],[113,2,113,5],[113,6,113,7],[113,8,113,12],[114,0,114,1],[114,2,114,5],[114,6,114,12],[116,0,116,12],[117,0,117,2],[117,3,117,5],[117,6,117,7],[117,8,117,12],[118,0,121,3],[118,4,118,12],[119,4,119,12],[120,4,120,12],[121,4,121,12],[123,0,124,1],[123,2,123,12],[124,2,124,12],[125,0,125,2],[126,0,128,1],[126,2,126,12],[127,2,127,12],[128,2,128,12],[130,0,130,12],[131,0,131,1],[131,2,131,4],[131,5,131,6],[131,7,131,9],[131,10,131,12],[132,0,132,1],[132,2,132,4],[132,5,132,6],[132,7,132,9],[132,10,132,12],[134,0,136,1],[134,2,134,4],[134,5,134,6],[134,7,134,9],[134,10,134,12],[135,2,135,4],[135,5,135,6],[135,7,135,9],[135,10,135,12],[136,2,136,4],[136,5,136,6],[136,7,136,9],[136,10,136,12]]}
["DUPUIS Aurélia",{"$nulls":7},"Maison médicale Saint Alban de Roche"]
["Sage-femme conventionnée diplômée d’état",{"$nulls":7},"41 chemin du Rousset"]
["N°RPPS 10100353720",{"$nulls":7},"38080 Saint Alban de roche"]
["N°ADELI 385003280",{"$nulls":7},"04.74.93.44.60 ou 06.64.49.37.90"]
[{"$nulls":8},"aurelia.dupuis@hotmail.fr"]
[]
["DOSSIER MEDICAL DE GROSSESSE"]
[]
["N° SS",260096322233355,{"$nulls":7},"DDN",{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,bd_patientes,5,FALSE))","v":"1996-04-21"}]
["Nom",{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,bd_patientes,3,FALSE))","v":"DESSON"},{"$nulls":3},"Prénom",{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,bd_patientes,4,FALSE))","v":"Michèle"},null,null,"Age",{"$f":"IF(K9=\"\",\"\",DATEDIF(K9,datedujour,\"y\")&\" a \"&DATEDIF(K9,datedujour,\"ym\")&\" m \"&DATEDIF(K9,datedujour,\"md\")&\" j\")","v":"18 a 8 m 18 j"}]
[]
["Adresse",{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,bd_patientes,7,FALSE)&\", \"&VLOOKUP(B9,bd_patientes,8,FALSE)&\" \"&VLOOKUP(B9,bd_patientes,9,FALSE)&\" \"&VLOOKUP(B9,bd_patientes,10,FALSE)&\" - \"&VLOOKUP(B9,bd_patientes,11,FALSE))","v":",  Les Cèdres chemin du Rousset 38080 - Saint-Alban de Roche"}]
[]
["Lieu d’accouchement",{"$nulls":6},"Gestité",3,null,"Parité",5]
[]
["DDR",null,null,"Gp",null,null,"HIV",null,null,"Gly"]
["DG","2014-11-11",null,"RAI",null,null,"Strepto B",null,null,"HGPO"]
["DPA",{"$f":"IF(B9=\"\",\"\",IF(B17=\"\",\"\",DATE(YEAR(B17),MONTH(B17),DAY(B17)+273)))","v":"2015-08-11"},null,"Toxo",null,null,"Herpès",null,null,"TTT"]
["Echo T1",null,null,"Rub",null,null,"Fer"]
["Echo T2",null,null,"Ag HBs",null,null,"NF"]
["Echo T3",null,null,"Hep C",null,null,"PQT"]
[{"$nulls":3},"BW",null,null,"MST21"]
[]
["REMARQUES IMPORTANTES"]
[]
["SUIVI MEDICAL"]
["Médecin généraliste ",{"$nulls":3},"Gynécologue",{"$nulls":3},"Médecin autre spécialité "]
[]
[]
["RENSEIGNEMENTS GENERAUX"]
["Situation familiale"]
["Situation professionnelle"]
["Contexte psycho-social"]
[]
["Traitement en cours"]
[]
[]
[]
[]
["ANTECEDENTS"]
["Personnels"]
["Taille (cm)",{"$nulls":3},"Poids",{"$nulls":3},"Valeur d'IMC",null,{"$f":"IF(B9=\"\",\"\",IF(G42=\"\",\"\",G42/((B42/100)*(B42/100))))","v":""},{"$f":"IF(K42=\"\",\"\",IF(K42<16.5,\"Dénutrition\",IF(AND(K42>=16.5,K42<=18.5),\"Maigreur\",IF(AND(K42>=18.5,K42<=25),\"Normal\",IF(AND(K42>=25,K42<=30),\"Surpoids\",IF(AND(K42>=30,K42<=35),\"Obèse modéré\",IF(K42>35,\"Obèse grave\")))))))","v":""}]
["Tabac",{"$nulls":3},"Substances",{"$nulls":3},"Allergies"]
["Médicaux"]
[]
[]
[]
[]
["Chirurgicaux"]
{"$rows_empty":7}
["ANTECEDENTS (Suite)"]
["Gynécologiques"]
["Atcd contraception",{"$nulls":4},"Hypofertilité",{"$nulls":3},"Date FCV"]
["Pathologies gynécologiques"]
[]
["Obstétricaux "]
["Gestité",{"$f":"IF(I14=\"\",\"\",I14)","v":3},{"$nulls":4},"Parité",{"$f":"IF(L14=\"\",\"\",L14)","v":5}]
[]
["Déroulement des grossesses"]
["Date"]
["G physio ou patho"]
["Terme"]
["Voie"]
["APD"]
["Délivrance"]
["Complications"]
["Enfant"]
["Poids"]
["Alimentation"]
["Etat de l’enfant"]
[]
["Atcd familiaux maternels",{"$nulls":5},"Atcd familiaux paternels"]
{"$rows_empty":20}
[{"$nulls":4},"CONSULTATION MEDICALE N° :",{"$nulls":3},1]
[]
["Date",{"$nulls":3},"Terme (en semaine d'aménorrhée)",{"$nulls":3},"Intervenant"]
["2015-01-08",{"$nulls":3},{"$f":"IF(A102=\"\",\"\",IF(dg=\"\",\"\",((A102-dg)+14)/7))","v":{"v":10.285714285714286,"d":"10"}}]
[]
["Signes fonctionnels"]
["CU",{"$nulls":5},"SFHTA"]
["MAF",{"$nulls":5},"LA/MTR/LEUCO"]
["SFU",{"$nulls":5},"PRURIT"]
["SFD",{"$nulls":5},"Autres"]
[]
["Examen médical"]
["TA",{"$nulls":5},"Pouls/ausc cardiaque/Temp"]
["MS et MI",{"$nulls":5},"Poids"]
["Etat cutané",{"$nulls":5},"Examen des seins"]
["Présentation",{"$nulls":5},"HU"]
["TV"]
[]
["Examens complémentaires"]
["BU : Alb= , S= , L= , N=",{"$nulls":5},"PV  ou amniotest "]
["Résultats d’examens / écho"]
[]
[]
[]
[]
["CCL  et CAT"]
[]
[]
["Prescriptions"]
[]
[]
[]
["Info/recommandations"]
["Tabac",null,"Toxo",null,null,"Alcool",null,"Alimentation",null,null,"Dépistage T21   "]
[]
[]
["Prochains rdv"]

{"sheet":"Notice","index":4,"n_rows":53,"n_cols":3,"rows_kept":53,"merged":[[1,0,3,0],[1,1,7,1],[1,2,7,2],[6,0,8,0],[9,1,12,1],[9,2,12,2],[14,1,50,1],[14,2,50,2],[52,1,58,1],[52,2,58,2]]}
[]
["Cliquer ici pour aller au modèle de consultation.",1,"Afin de remplir correctement les champs concernant une nouvelle patiente et, ce, sans faire d'erreur, il est très important de procéder de la façon suivante pour renseigner le champ N° SS : de la feuille \"Modèle consult\". Lequel N° SS est le seul qui puisse garantir l'identité.\nCliquer une seule fois sur le nom de la feuille \"Répertoire\" (tout en bas à gauche).\nEnsuite, faire un clic droit (et un seul) sur le N° SS de la patiente concernée et faire \"Copier\".\nEnsuite, faire un clic gauche (et un seul) sur le nom de la feuille \"Modèle consult\" (tout en bas).\nDans la cellule contigüe à N° SS (c.a.d la B9) faire un un clic droit (et un seul) et faire \"Copier\".\nA ce moment, les champs concernants l'identité de cette patiente sont actualisés instantanément dans la feuille \"Modèle consult\"."]
[]
[]
[]
[]
["Cliquer ici pour aller au Répertoire."]
[]
[]
[null,2,"Après avoir réussi (et seulement après) à remplir les champs concernant l'identité de la patiente il est impératif de créer une feuille EXCEL privée pour cette personne en cliquant sur le bouton \"Copier ce modèle\".\nA ce moment, EXCEL crée une nouvelle feuille, dans le \"Fichier patientes v2.01\", en la plaçant tout à la fin.\nLa nouvelle feuille créée porte le nom de la patiente additionné de la date du jour."]
[]
[]
[]
[]
[null,3,"Pour permettre de ne pas chercher cette dernière, EXCEL se place, par défault, dans la dernière feuille créée.\nA toutes fins utiles, et pour faciliter les recherches futures du dossier de cette patiente il est préférable de relier, par un lien Hypertexte, \nle nom de cette personne (qui se trouve dans le répertoire) avec le document nouvellement crée.\nCliquer une seule fois sur le nom de la feuille \"Répertoire\" (tout en bas à gauche).\nEnsuite, faire un clic droit (et un seul) sur le Nom de la patiente concernée (ici DESSON) et cliquer sur \"Lien hypertexte\".\nLa fenêtre suivante s'ouvre, puis, dans la rubrique \"Lier à :\" cliquer sur \"Emplacement dans ce document\". Laisser vide \"Texte à afficher :\",\nlaisser A1 dans \"Tapez la référence de la cellule :\" puis dans la rubrique \"Ou sélectionnez un emplacement dans ce document :\" chercher \nle nom de la feuille nouvellement créée (ici 'DESSON 30-12-2014') puis sélectionner cette feuille par un clic droit (et un seul) et enfin, \ncliquer sur OK. Le lien est maintenant crée.\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nRenseigner la totalité du document de la patiente, soit à l'aide de la souris pour changer de champ, soit à l'aide de la touche \"Tab\".\nA noter que les champs qui ne doivent pas être modifiés sont protégés contre la modification inopinée.\nA toutes fins utiles, et pour le cas ou une modification d'un (ou de plusieurs de ces champs), soit nécéssaire, il convient d'ôter la protection et, surtout, de bien penser à la remettre.\nPour ce faire, aller dans l'onglet \"Révision\" et cliquer sur l'onglet \"Ôter la protection\" taper le mot de passe (c.f. la feuille \"mdp\").\nFaire les modifications désirées et protéger la feuille de nouveau avec le même mot de passe (il doit être répété)."]
{"$rows_empty":37}
[null,4,"Lorsque la consultation est terminée, il est impératif de penser A ENREGISTRER TOUT LE TRAVAIL en cliquant simplement sur la disquette \nnon barrée du ruban.\nEnsuite seulement, on peut générer le document complet au format Pdf en cliquant sur le bouton  \"Enregistrer tout le document en Pdf\".\nA ce moment, EXCEL crée un nouveau document sur le disque \"C\" du PC.\nL'impression de la page 3 peut se faire depuis EXCEL en cliquant sur le bouton \"Imprimer la page 3 du document\" ou, directement depuis le fichier Pdf nouvellement crée."]