{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Menu","Nouveau Client","Modifier le client","Fiche Client","pour imprimer","Types","PARAM","BD"],"not_rendered":{"macros":1,"external_links":2,"defined_names":48},"read":"whole","date_system":"1904"}

{"sheet":"Menu","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"merged":[[2,0,2,3]]}
[]
[]
["Ficher Client"]
{"$rows_empty":19}
[null,"total de clients enregistré:",{"$f":"nb_enreg_bd","v":0}]

{"sheet":"Nouveau Client","index":1,"n_rows":39,"n_cols":24,"rows_kept":39,"merged":[[3,1,3,3],[38,1,42,3]]}
["No","CLIENT / PHOTOGRAPHE 1","TYPE","TELEPHONE 1","Mail 1","CONTACT 2","TEL 2","MAIL 2","CONTACT 3","TEL 3","MAIL 3","CONTACT 4","TEL 4","MAIL 4","CONTACT 5","TEL 5","MAIL 5","CONTACT 6","TEL 6","MAIL 6","INFOS SUP","ADRESSE","CODE","VILLE"]
[{"$f":"MAX(BD!A:A)+1","v":1},{"$f":"C6&\"\"","v":"a"},{"$f":"C9&\"\"","v":"M."},{"$f":"C8&\"\"","v":"c"},{"$f":"#REF!&\"\"","v":{"$error":"#REF!"}},{"$f":"C13&\"\"","v":"g"},{"$f":"C14&\"\"","v":"h"},{"$f":"C15&\"\"","v":"i"},{"$f":"C17&\"\"","v":"k"},{"$f":"C18&\"\"","v":"l"},{"$f":"C19&\"\"","v":"m"},{"$f":"C20&\"\"","v":"n"},{"$f":"C21&\"\"","v":"o"},{"$f":"C22&\"\"","v":"p"},{"$f":"C23&\"\"","v":"q"},{"$f":"C24&\"\"","v":"r"},{"$f":"C25&\"\"","v":"s"},{"$f":"C26&\"\"","v":"t"},{"$f":"#REF!&\"\"","v":{"$error":"#REF!"}},{"$f":"#REF!&\"\"","v":{"$error":"#REF!"}},{"$f":"B39&\"\"","v":"ae"},{"$f":"C10&\"\"","v":"d"},{"$f":"C11&\"\"","v":"e"},{"$f":"C12&\"\"","v":"f"}]
[null,null,"Total de clients enregistrés :",{"$f":"nb_enreg_bd","v":0}]
[null,"NOUVEAU CLIENT"]
[]
[null,"Code N°","a"]
[null,"Destinataire Nom","b"]
[null,"Destinataire Prénom","c"]
[null,"Civilité","M."]
[null,"Chez M.","d"]
[null,"Téléphone fixe","e"]
[null,"Téléphone portable","f"]
[null,"Adresse","g"]
[null,"Code Postal","h"]
[null,"Ville","i"]
[null,"Pays","j"]
[null,"Bât/Etage/Porte/Digicode","k"]
[null,"Jour et date de livraison","l"]
[null,"Le moment de la livraison/Cérémonie","m"]
[null,"Nom du client (donneur d'ordre)","n"]
[null,"Téléphone du client (donneur d'ordre)","o"]
[null,"Date de la vente","p"]
[null,"Transmetteur N°","q"]
[null,"Initiales du vendeur","r"]
[null,"Choix floral Interflora Ref.","s"]
[null,"Produit","t"]
[null,"Produit défini occasionnellement - PDO","u"]
[null,"Prix de vente du produit","v"]
[null,"Ruban deuil","w"]
[null,"Livraison exceptionnelle (colivex)","x"]
[null,"Complément de prix Interflora","y"]
[null,"TOTAL TTC","z"]
[null,"Dont TVA à %","aa"]
[null,"Coût TVA","ab"]
[null,"Mode de paiement","ac"]
[null,"Texte (si ruban de deuil)","ad"]
[]
[null,"Message :"]
[null,"ae"]

{"sheet":"Modifier le client","index":2,"n_rows":80,"n_cols":24,"rows_kept":80,"merged":[[3,2,4,4],[70,2,70,4],[71,2,77,4],[79,2,79,4],[80,2,86,4]]}
["No","CLIENT / PHOTOGRAPHE 1","TYPE","TELEPHONE 1","Mail 1","CONTACT 2","TEL 2","MAIL 2","CONTACT 3","TEL 3","MAIL 3","CONTACT 4","TEL 4","MAIL 4","CONTACT 5","TEL 5","MAIL 5","CONTACT 6","TEL 6","MAIL 6","INFOS SUP","ADRESSE","CODE","VILLE"]
[{"$f":"INDEX(BD!A:A,PARAM_NO_LIGNE+1)","v":0},{"$f":"IF(D10=\"\",D10&\"\",D10&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(D15=\"\",D14&\"\",D15&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(D17=\"\",D16&\"\",D17&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(D19=\"\",D18&\"\",D19&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",#REF!&\"\",#REF!&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",#REF!&\"\",#REF!&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",#REF!&\"\",#REF!&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",#REF!&\"\",#REF!&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",#REF!&\"\",#REF!&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",#REF!&\"\",#REF!&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",#REF!&\"\",#REF!&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",#REF!&\"\",#REF!&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",#REF!&\"\",#REF!&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",#REF!&\"\",#REF!&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",#REF!&\"\",#REF!&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",#REF!&\"\",#REF!&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",#REF!&\"\",#REF!&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",#REF!&\"\",#REF!&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",#REF!&\"\",#REF!&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(C81=\"\",C72&\"\",C81&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(D21=\"\",D20&\"\",D21&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(D23=\"\",D22&\"\",D23&\"\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",#REF!&\"\",#REF!&\"\")","v":{"$error":"#REF!"}}]
[null,null,"total de clients enregistré:",{"$f":"nb_enreg_bd","v":0}]
[null,null,"Modifications de Client"]
[]
[]
[]
[{"$nulls":3},{"$f":"INDEX(Code_N°,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Code N°"]
[{"$nulls":3},{"$f":"INDEX(Destinataire_Nom,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Destinataire Nom"]
[{"$nulls":3},{"$f":"INDEX(Destinataire_Prénom,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Destinataire Prénom"]
[{"$nulls":3},{"$f":"INDEX(Civilité,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Civilité"]
[{"$nulls":3},{"$f":"INDEX(Chez_M.,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Chez M."]
[{"$nulls":3},{"$f":"INDEX(Téléphone_fixe_destinataire,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Téléphone fixe"]
[{"$nulls":3},{"$f":"INDEX(Téléphone_portable_destinataire,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Téléphone portable"]
[{"$nulls":3},{"$f":"INDEX(Adresse_destinataire,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Adresse"]
[{"$nulls":3},{"$f":"INDEX(Code_Postal,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Code Postal"]
[{"$nulls":3},{"$f":"INDEX(Ville,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Ville"]
[{"$nulls":3},{"$f":"INDEX(Pays,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Pays"]
[{"$nulls":3},{"$f":"INDEX(Bât_Etage_Porte_Digicode,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Bât/Etage/Porte/Digicode"]
[{"$nulls":3},{"$f":"INDEX(Jour_et_date_de_livraison,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Jour et date de livraison"]
[{"$nulls":3},{"$f":"INDEX(Le_moment_de_la_livraison_Cérémonie,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Le moment de la livraison/Cérémonie"]
[{"$nulls":3},{"$f":"INDEX(Nom_du_client__donneur_d_ordre,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Nom du client (donneur d'ordre)"]
[{"$nulls":3},{"$f":"INDEX(Téléphone_du_client__donneur_d_ordre,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Téléphone du client (donneur d'ordre)"]
[{"$nulls":3},{"$f":"INDEX(Date_de_la_vente,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Date de la vente"]
[{"$nulls":3},{"$f":"INDEX(Transmetteur_N°,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Transmetteur N°"]
[{"$nulls":3},{"$f":"INDEX(Initiales_du_vendeur,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Initiales du vendeur"]
[{"$nulls":3},{"$f":"INDEX(Choix_floral_Interflora_Ref.,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Choix floral Interflora Ref."]
[{"$nulls":3},{"$f":"INDEX(Produit,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Produit"]
[{"$nulls":3},{"$f":"INDEX(Produit_défini_occasionnellement___PDO,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Produit défini occasionnellement - PDO"]
[{"$nulls":3},{"$f":"INDEX(Prix_de_vente_du_produit,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Prix de vente du produit"]
[{"$nulls":3},{"$f":"INDEX(Ruban_deuil,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Ruban deuil"]
[{"$nulls":3},{"$f":"INDEX(Livraison_exceptionnelle__colivex,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Livraison exceptionnelle (colivex)"]
[{"$nulls":3},{"$f":"INDEX(Complément_de_prix_Interflora,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Complément de prix Interflora"]
[{"$nulls":3},{"$f":"INDEX(TOTAL_TTC,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"TOTAL TTC"]
[{"$nulls":3},{"$f":"INDEX(Dont_TVA_à,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Dont TVA à %"]
[{"$nulls":3},{"$f":"INDEX(Coût_TVA,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Coût TVA"]
[{"$nulls":3},{"$f":"INDEX(Mode_de_paiement,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Mode de paiement"]
[{"$nulls":3},{"$f":"INDEX(Texte__si_ruban_de_deuil,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[null,null,"Texte (si ruban de deuil)"]
[]
[null,null,"Message"]
[null,null,{"$f":"INDEX(Message,PARAM!B3)","v":{"$error":"#REF!"}},{"$f":"INDEX(Message,PARAM!A52)","v":{"$error":"#REF!"}},{"$f":"INDEX(Message,PARAM!B52)","v":{"$error":"#REF!"}}]
[null,null,{"$f":"INDEX(Message,PARAM!#REF!)","v":{"$error":"#REF!"}},{"$f":"INDEX(Message,PARAM!A53)","v":{"$error":"#REF!"}},{"$f":"INDEX(Message,PARAM!B53)","v":{"$error":"#REF!"}}]
[null,null,{"$f":"INDEX(Message,PARAM!#REF!)","v":{"$error":"#REF!"}},{"$f":"INDEX(Message,PARAM!A54)","v":{"$error":"#REF!"}},{"$f":"INDEX(Message,PARAM!B54)","v":{"$error":"#REF!"}}]
[null,null,{"$f":"INDEX(Message,PARAM!#REF!)","v":{"$error":"#REF!"}},{"$f":"INDEX(Message,PARAM!A55)","v":{"$error":"#REF!"}},{"$f":"INDEX(Message,PARAM!B55)","v":{"$error":"#REF!"}}]
[null,null,{"$f":"INDEX(Message,PARAM!#REF!)","v":{"$error":"#REF!"}},{"$f":"INDEX(Message,PARAM!A56)","v":{"$error":"#REF!"}},{"$f":"INDEX(Message,PARAM!B56)","v":{"$error":"#REF!"}}]
[null,null,{"$f":"INDEX(Message,PARAM!#REF!)","v":{"$error":"#REF!"}},{"$f":"INDEX(Message,PARAM!A57)","v":{"$error":"#REF!"}},{"$f":"INDEX(Message,PARAM!B57)","v":{"$error":"#REF!"}}]
[null,null,{"$f":"INDEX(Message,PARAM!#REF!)","v":{"$error":"#REF!"}},{"$f":"INDEX(Message,PARAM!A58)","v":{"$error":"#REF!"}},{"$f":"INDEX(Message,PARAM!B58)","v":{"$error":"#REF!"}}]
[]
[null,null,"Message"]

{"sheet":"Fiche Client","index":3,"n_rows":39,"n_cols":7,"rows_kept":39,"merged":[[2,3,4,6],[17,6,39,6],[28,3,29,3],[28,4,29,4],[38,3,39,3],[38,4,39,4]]}
[{"$nulls":4},"Total de clients enregistrés :",null,{"$f":"nb_enreg_bd","v":0}]
[]
[{"$nulls":3},"Fiche Client"]
[]
[]
[]
[{"$nulls":3},"Code N°",{"$f":"INDEX(Code_N°,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Destinataire Nom",{"$f":"INDEX(Destinataire_Nom,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Destinataire Prénom",{"$f":"INDEX(Destinataire_Prénom,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Civilité",{"$f":"INDEX(Civilité,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Chez M.",{"$f":"INDEX(Chez_M.,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Téléphone fixe",{"$f":"INDEX(Téléphone_fixe_destinataire,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Téléphone portable",{"$f":"INDEX(Téléphone_portable_destinataire,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Adresse",{"$f":"INDEX(Adresse_destinataire,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Code Postal",{"$f":"INDEX(Code_Postal,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Ville",{"$f":"INDEX(Ville,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}},null,"Message :"]
[{"$nulls":3},"Pays",{"$f":"INDEX(Pays,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Bât/Etage/Porte/Digicode",{"$f":"INDEX(Bât_Etage_Porte_Digicode,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}},null,{"$f":"INDEX(Message,PARAM!B3)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Jour et date de livraison",{"$f":"INDEX(Jour_et_date_de_livraison,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Le moment de la livraison/Cérémonie",{"$f":"INDEX(Le_moment_de_la_livraison_Cérémonie,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Nom du client (donneur d'ordre)",{"$f":"INDEX(Nom_du_client__donneur_d_ordre,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Téléphone du client (donneur d'ordre)",{"$f":"INDEX(Téléphone_du_client__donneur_d_ordre,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Date de la vente",{"$f":"INDEX(Date_de_la_vente,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Transmetteur N°",{"$f":"INDEX(Transmetteur_N°,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Initiales du vendeur",{"$f":"INDEX(Initiales_du_vendeur,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[]
[{"$nulls":3},"Choix floral Interflora Ref.",{"$f":"INDEX(Choix_floral_Interflora_Ref.,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Produit",{"$f":"INDEX(Produit,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Produit défini occasionnellement - PDO",{"$f":"INDEX(Produit_défini_occasionnellement___PDO,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[]
[{"$nulls":3},"Prix de vente du produit",{"$f":"INDEX(Prix_de_vente_du_produit,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Ruban deuil",{"$f":"INDEX(Ruban_deuil,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Livraison exceptionnelle (colivex)",{"$f":"INDEX(Livraison_exceptionnelle__colivex,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Complément de prix Interflora",{"$f":"INDEX(Complément_de_prix_Interflora,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"TOTAL TTC",{"$f":"INDEX(TOTAL_TTC,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Dont TVA à %",{"$f":"INDEX(Dont_TVA_à,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Coût TVA",{"$f":"INDEX(Coût_TVA,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Mode de paiement",{"$f":"INDEX(Mode_de_paiement,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Texte (si ruban de deuil)",{"$f":"INDEX(Texte__si_ruban_de_deuil,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]

{"sheet":"pour imprimer","index":4,"n_rows":23,"n_cols":6,"rows_kept":23,"merged":[[2,3,4,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[21,3,21,5],[22,3,28,5]]}
[]
[]
[{"$nulls":3},{"$f":"E7","v":{"$error":"#NAME?"}}]
[]
[]
[]
[{"$nulls":3},"Destinataire",{"$f":"INDEX(CLIENT___PHOTOGRAPHE_1,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}}]
[{"$nulls":3},"Civilité",{"$f":"INDEX(TYPE,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[{"$nulls":3},"TELEPHONE 1",{"$f":"INDEX(TEL_1,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}}]
[{"$nulls":3},"Mail 1",{"$f":"INDEX(MAIL_1,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}}]
[{"$nulls":3},"ADRESSE",{"$f":"INDEX(ADRESSE,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}}]
[{"$nulls":3},"CODE",{"$f":"INDEX(CODE_POSTE,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}}]
[{"$nulls":3},"VILLE",{"$f":"INDEX(Ville,PARAM_NO_LIGNE)","v":{"$error":"#REF!"}}]
[]
[{"$nulls":3},"CONTACT","TEL","MAIL"]
[{"$nulls":3},{"$f":"INDEX(CONTACT_2,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}},{"$f":"INDEX(TEL_2,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}},{"$f":"INDEX(MAIL_2,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}}]
[{"$nulls":3},{"$f":"INDEX(CONTACT_3,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}},{"$f":"INDEX(TEL_3,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}},{"$f":"INDEX(MAIL_3,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}}]
[{"$nulls":3},{"$f":"INDEX(CONTACT_4,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}},{"$f":"INDEX(TEL_4,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}},{"$f":"INDEX(MAIL_4,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}}]
[{"$nulls":3},{"$f":"INDEX(CONTACT_5,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}},{"$f":"INDEX(TEL_5,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}},{"$f":"INDEX(MAIL_5,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}}]
[{"$nulls":3},{"$f":"INDEX(CONTACT_6,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}},{"$f":"INDEX(TEL_6,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}},{"$f":"INDEX(MAIL_6,PARAM_NO_LIGNE)","v":{"$error":"#NAME?"}}]
[]
[{"$nulls":3},"Message"]
[{"$nulls":3},{"$f":"INDEX(Message,PARAM!B3)","v":{"$error":"#REF!"}}]

{"sheet":"Types","index":5,"n_rows":8,"n_cols":1,"rows_kept":8}
["Types"]
["Civilité"]
["Defunt"]
["M."]
["M. & Defunt"]
["M. & Mme"]
["Mlle"]
["Mme"]

{"sheet":"PARAM","index":6,"n_rows":9,"n_cols":2,"rows_kept":9}
[]
[]
["N° de la ligne de l'enregistrement courant",68]
[]
["Nombre d'enregistrements dans la BD",{"$f":"COUNTA(BD!A:A)-1","v":0}]
[]
[]
["Resultat de la recherche client","BERTIN/PERSICHINI"]
["Position de la recherche dans sa zone",{"$f":"MATCH(liste_alpha,Destinataire_Nom,0)","v":{"$error":"#REF!"}}]

{"sheet":"BD","index":7,"n_rows":1,"n_cols":33,"rows_kept":1}
["No","Code N°","Destinataire Nom","Destinataire Prénom","Civilité","Chez M.","Téléphone fixe destinataire","Téléphone portable destinataire","Adresse destinataire","Code Postal","Ville","Pays","Bât/Etage/Porte/Digicode","Jour et date de livraison","Le moment de la livraison/Cérémonie","Nom du client (donneur d'ordre)","Téléphone du client (donneur d'ordre)","Date de la vente","Transmetteur N°","Initiales du vendeur","Choix floral Interflora Ref.","Produit","Produit défini occasionnellement - PDO","Prix de vente du produit","Ruban deuil","Livraison exceptionnelle (colivex)","Complément de prix Interflora","TOTAL TTC","Dont TVA à %","Coût TVA","Texte (si ruban de deuil)","Mode de paiement","Message :"]