{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Fournisseurs","Statistiques Commande","Menu","Synthèse commande","GestionLISTE","Gestion Mot DE Passe"],"not_rendered":{"charts":1,"images":9,"macros":1,"external_links":4,"defined_names":196,"comments":1,"pivot_tables":1},"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":"Fournisseurs","index":0,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Nom","Adresse","Code Postal","Ville","Téléphone","Fax","Mail"]
["ABOR DISTRIBUTION SAS"," 90 rue des Dinandiers, PA Bel Air","12850","onet le chateau","05 65 42 74 01 ","",""]
["Amazon.fr","CF SIte internet","12000","Rodez","","",""]
["Aquajulien","Pole commercial comtal nord","12740","Sebazac","05 63 36 11 59 ","","rodez@lemagjulien.com"]
["Aveyron store","Zone Commerciale Puy Laroque","12510","olemps","05 65 42 81 23 ","05 65 67 34 94 ","aveyron.stores@wanadoo.fr"]
["Brico dépot","Pole commercial comtal nord","12740","Sebazac","05 65 61 54 80","",""]
["Cédeo Rodez","Rue de la Prade ZI de Cantaranne","12033","Rodez cedex 9","05 65 42 64 51 ","05 65 42 86 15 ",""]
["DLM CREATIONS","155 rue Eugène FreysAsinet, ZA Grezan, 30034 Nîmes","30034","NÎMES","04 66 02 08 88 ","",""]
["Fauche Rodez","ZA bel Air - Avenue du causse - 12850 ONET LE CHATEAU","12850","onet le chateau","05 65 42 21 41 ","","pviala@fauche.com"]
["Malrieu","Bel Air","12032","Rodez ","05 65 42 64 51 ","05 65 42 86 15 ","malrieu@malrieu.fr"]
["Mon brico BQV","le Sablas, 12160 BARAQUEVILLE","12160","baraqueville","05 65 78 42 11","",""]
["PMP Piscine","Z.A. Les Molinières - Le Pereyret","12450","Calmont","05.65.69.17.89 ","06.81.56.40.04 ","pmp.laire@free.fr"]
["PRAXIS MEDICAL","107 Rue Dassin-Parc 2000-","34080","Montpellier","04 99 77 23 23 ","","www.praxismedical.com"]
["Raynal Batterie","7, Avenue des Fusillés",12000,"Rodez","05 65 77 17 97 ","09 71 70 11 36 ","c.dalibard@raynalbatterie.fr"]
["SCT tout electric","Rue St Christophe ZA du causse","12000","Rodez","05 65 77 36 36 ","05 65 42 96 05 ","sct.rodez@toutelectric.fr"]
["Sicli Toulouse","Immeuble Regent Park 2","31676","Toulouse","05 65 25 77 82 ","05 62 57 78 29 ",""]
["Sider Michel.Soulage Commercial","29,rue Thomas Edisson","90426","CANEJAN CEDEX","05 56 89 15 21 ","0688  94 08 63 ","msoulages@sider.biz"]
["Vitrine médicale","Rond point de saint Marc, ZAC de l'auterne","12850","onet le chateau","05 65 67 25 67 ","05 65 42 56 31 ","WWW.vitrine-medicale.com"]
["Briconaute","3 Avenue de Toulouse","12450","La primaube","05 65 69 40 49 ","",""]
["EDS Electronique","Parc d'activités de la gineste, 87 Avenue de la Gineste","12000","Rodez","05 65 68 38 29 ","",""]
["3A","Espace Commercial Saint-Marc","12850","Onet-le-Château","05 65 78 18 78 ","","fabrice.gayrard@3aengineering.com"]
["Maurel Dominique travaux Forestiers,élagages","Lot.\r\n\r\n\r\n\r\n\r\n\r\nLot.Bel Regard","12240","Colombies","05 65 69 96 08 ","06 07 60 81 24 ","maurel.elagage@orange.fr"]
["HF Métal Fredéric Hueso","6 rue st pierre","12450","Flavin","06 87 64 01 17 ","","hfmetal12@gmail.com"]
["Rexel","Boulevard des Balquières","12850","onet le chateau","05 65 76 50 50 ","05 65 76 50 59 ",""]
["Mauvertex","Lot.\r\n\r\n\r\nParc Commercial des Moutiers\r\n","12000","Rodez","05 65 67 40 88 ","06 77 02 56 09 ","mauvertex.thomas@wanadoo.fr"]
["Scopelec","","31250","Revel","05 62 71 31 13 ","","sav@groupe-scopelec.fr"]
["Aliexpress","","","","","","https://www.aliexpress.com/"]
["OfficeEasy","9,rue de l'abbé Stahl-Bat A","59700","Marcq-en-Baroeul","03 28 07 70 70 ","03 28 07 70 71 ","l.bordet@officeeasy.fr"]
["COMOTECH INDUSTRIE","6,Rue des Blonnières CS 82441","44115","HAUTE GOULAIN","02 40 05 05 05 ","02 40 05 05 03 ","commercial@comotech.fr"]
["Ribeiro","recoule la rougie","12160","MOYRAZES","05 65 67 20 88 ","06 83 14 94 91 ","ribeirojose@wibox.fr"]
["HILL-ROM","ZI du Talhouet- BP14","56330","PLUVIGNER","08 20 01 23 45 ","02 56 37 30 20 ","sav@hillrom.com"]
["MURATET","187 Avenue de Rodez","12160","Baraqueville","05 65 70 17 94 ","","...@..."]
["DAE-Défibrilateur.COM","235 rue Isaac Newton\r\nTechnoparc Epsilon 1\r\n","83700","SAINT RAPHAEL","04 94 17 29 05 ","09 57 11 85 92 ","contact@dae-defibrilateur.com"]
["DALLE LED ","Schurenbergweg 5A,\r\n1105 AP Amsterdam","1105","AMSTERDAM","02 02 60 00 08 ","","info@dalleled.fr"]
["Jardin Mélila","21 route de séverac","12850","ONET LE CHATEAU","05 65 67 04 52 ","",""]
["CIR RODEZ","847, rue Saint Christophe\r\nZA du Causse Bel Air","12032","Rodez","05 65 78 08 08 ","05 65 78 05 88 ",""]
["E.M DISTRIBUTION.FR","18 Ter Rue Jean Moulin","08700","Nouzonville","03 24 53 38 88 ","",""]
["APIC","16 rue des taillées","79182","CHAURAY CEDEX","05 49 26 74 50 ","05 49 26 74 51 ","www.apic-france.com"]
["Quincaillerie Angles","Boulevard des Balquières\r\nBP 3356 Onêt le Chateau","12033","Rodez Cedex 9","05 65 78 10 00 ","05 65 78 79 60 ","info@quincaillerie-angles.fr"]
["VGM","La Devèze Grande ZA Lioujas","12740","LIOUJAS LA LOUBIERE","05 65 46 92 34 ","","commercial3@vgm-aveyron.fr"]
["SOS ACCESSOIRE","12 Rue Jean Monnet, 78990 Élancourt","78990","Élancourt","0 892 43 05 40 ","","clients@sos-accessoire.com"]
["AllBatterie.fr"," 11C, rue des Aulnes,BP 10020","69542","Champagne au Mont d'Or","08 90 71 02 30 ","","industrie@allbatteries.com "]
["SCALEO MEDICAL(PRAXIS)","107 rue Dassin, Parc 2000"," 34080 ","Montpellier","04 97 77 23 33 ","","Chloe.Carlier@scaleomedical.com"]
["VLAD.COM","ZA du papillon,400 rue Emile Dewoitine","37210","Parçay-Meslay","05 65 67 25 67 ","05 65 42 56 31 ","contact@vlad.fr"]
["DELBES Couverture / Etanchéité","35, rue de la feronnerie\r\nParc d'activités de Bel-Air","12000","RODEZ","05 65 42 53 50 ","05 65 42 94 09 ","contact@delbes-aveyron.fr"]
["DISTREP","ZI Albasud\r\n170 impasse Louis Lépine","82000","MONTAUBAN","05 65 78 92 81 ","06 72 13 96 46 ",""]
["Vérinàgazenligne.fr","Protempo B.V.\r\nEnergieweg 4\r\n","6541 CX Nijmegen","Pays-Bas"," 0031-24371171 ","","leverinagazenligne@protempo.eu"]
["M-D-R.com","M-D-R\r\nSolutions de stockage\r\n23 Rue du Châtelier\r\n\r\n","72200","CRE SUR LOIR","02 43 45 01 10 ","","contact@m-d-r.com"]
["EIFFAGE","ZAC DE NAUJAC","12450","LA Primaube","05 65 71 43 71 ","05 65 69 40 29 ","William.RAPPELLE@eiffage.com"]
["SARL Segala Aliments","ZA DE MARENGO","12160","Baraqueville","05 65 70 19 67 ","05 65 69 10 84 ","segala-aliments@wanadoo.fr"]
["DELEAGE ( Lisa LE CASTREC)","5, rue du Groupe Manoukian\r\n","78990","ELANCOURT","01 30 68 60 00 ","","lisa@deleage.com"]
["SAS GASTON PERE ET FILS","40-45 route de Bonissard ","12300","DECAZEVILLE","05 65 43 17 42 ","","contact@gaston-aveyron.fr"]
["COMPOSANT DIFFUSION"," 13 Zac de la Bouverie ","83520","83520 Roquebrune sur Argens ","0498111515","04.98.11.15.23 ","compodif@wanadoo.fr"]
["ESAT SEBAZAC","Route de Villecomtal","12740","Sébazac-Concourès","05 65 74 57 20 ","",""]
["BASTIDE MEDICAL","Parc d'activité la gineste\r\n331 rue Theodor mathieu","12000","Rodez","07 78 26 66 41 ","05 65 73 62 90 ","celia.perez@bastide-medical.fr"]
["CMS","23 avenue de la gineste","12000","Rodez ","05 65 77 27 10 ","05 65 77 27 11 ",""]
["MODUGAME SARL","14 Rue des Acilloux","63800","Cournon-d'Auvergne","04 73 28 23 13 ","","isabelle.laurembourle@modugame.fr"]
["Renault","Route d'Espalion","12850","onet le chateau","05 65 67 04 10 ","",""]
["ECOTEL ","32 rue des Orfèvres ZA Bel-Air","12850","Onet-le-Château","05 65 67 40 40 ","","ecotel-rodez@orange.fr"]
["Vitae","Rond point de saint Marc, ZAC de l'auterne","12850","onet le chateau","05 65 67 25 67 ","","WWW.groupe-vitae.fr"]
["PITCH-TECHNOLOGIES","6, rue de la prévôté","78550","HOUDAN","01 34 85 54 68 ","06.81.56.40.04 ","adv@pitch-technologies.fr"]

{"sheet":"Statistiques Commande","index":1,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Date d'enregistrement de la commande","(Tous)"]
[]
["Étiquettes de lignes"]
["Validé"]
["Total général"]

{"sheet":"Menu","index":2,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,7,5,11],[5,13,5,15],[5,4,5,5]]}
[]
[]
[]
[]
[]
[null,null,null,null,"Nombre de commande Validé",null,{"$f":"COUNTIF('Synthèse commande'!K5:K503,\"Validé\")","v":3},"Nombre de commande en cours",null,null,null,null,{"$f":"COUNTIF('Synthèse commande'!K5:K503,\"En Cours\")","v":0},"Nombre de commande Refusé",null,null,{"$f":"COUNTIF('Synthèse commande'!K5:K503,\"refusé\")","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
["                                             "]

{"sheet":"Synthèse commande","index":3,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,8,0,9]]}
[]
[]
["N° ID","N° de Commande","Date d'enregistrement de la commande","Nom Fournisseur","Adresse","Code postal","Ville","Téléphone 1","Téléphone 2","Adresse mail Etablissement","Validation","Commentaires","Liens documents attachés"]
[1,"MAS _00000001","2020-01-01","reservation initiale"]
[2,"MAS _00000002","2020-01-08","OfficeEasy","9,rue de l'abbé Stahl-Bat A","59700","Marcq-en-Baroeul","03 28 07 70 70 ","03 28 07 70 71 ","l.bordet@officeeasy.fr","Validé","Housse DECT Aastra 612d","documents_2"]
[3,"MAS _00000003","2020-01-08","DAE-Défibrilateur.COM","235 rue Isaac Newton\r\nTechnoparc Epsilon 1\r\n","83700","SAINT RAPHAEL","04 94 17 29 05 ","09 57 11 85 92 ","contact@dae-defibrilateur.com","Validé","Batterie DAE PowerHeart G5 Cardiac Science","documents_3"]
[4,"MAS _00000004","2020-01-08","DALLE LED ","Schurenbergweg 5A,\r\n1105 AP Amsterdam","1105","AMSTERDAM","02 02 60 00 08 ","","info@dalleled.fr","Validé","Dalle LED 36W RGB dimmable pour LV1,LV2 et LV3","documents_4"]

{"sheet":"GestionLISTE","index":4,"n_rows":23,"n_cols":24,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,0,1,3],[5,15,5,16]]}
[]
["Paramètre GMAO",null,null,null,"Liste Nom Fournisseur","Liste ville",null,"Adresse Fournisseur",null,"Code Postal",null,null,null,{"$f":"YEAR(TODAY())","v":2021},null,null,null,null,null,null,null,"RechercheFournisseur","Ncol","Liste"]
["Couleur de fond des userform Valeurs RGB",96,138,195,"ABOR DISTRIBUTION SAS","Calmont",null," 90 rue des Dinandiers, PA Bel Air",null,"12000",null,null,null,{"$f":"DATE(N2,1,1)","v":"2021-01-01"},"1er  Janvier",null,null,null,null,null,null,"N° ID",1,1]
[null,null,null,null,"3A","Montpellier",null,"107 Rue Dassin-Parc 2000-",null,"12032",null,null,null,{"$f":"ROUND(DATE(N2,4,MOD(234-11*MOD(N2,19),30))/7,)*7-6","v":"2021-04-04"},"Pâques",null,null,null,null,null,null,"N°Commande",2,1]
["Sauvegarde pour multi utilisateur 1=Yes 2=No",1,null,null,"Amazon.fr","baraqueville",null,"155 rue Eugène FreysAsinet, ZA Grezan, 30034 Nîmes",null,"12033",null,null,null,{"$f":"SUM(N4+1)","v":"2021-04-05"},"Lundi de Pâques",null,null,null,null,null,null,"Date d'enregistrement de la commande",3,1]
[null,null,null,null,"Aquajulien","Calmont",null,"7, Avenue des Fusillés",null,"12160",null,null,null,{"$f":"DATE(N2,5,1)","v":"2021-05-01"},"1er  Mai","Permet de définir les type de recherche (col N3)",null,null,null,null,null,"Nom Fournisseur",4,1]
["Liste intervenant",2,null,null,"Aveyron store","Montpellier",null,"Bel Air",null,"12400",null,null,null,{"$f":"DATE(N2,5,8)","v":"2021-05-08"}," 8 Mai Victoire 1945","N°","Liste Recherche",null,null,null,null,"Adresse",5,1]
[null,null,null,null,"Brico dépot","NÎMES",null,"CF SIte internet",null,"12450",null,null,null,{"$f":"N4+39","v":"2021-05-13"},"Jeudi de l'Ascension",1,"Liste suivant feuille",null,null,null,null,"Code postal",6,1]
["blocage des touches 1= ok , autres = noOk","No",null,null,"Cédeo","olemps",null,"Immeuble Regent Park 2",null,"12510",null,null,null,{"$f":"N4+49","v":"2021-05-23"},"Pentecôte",2,"ListeRange",null,null,null,null,"Ville",7,1]
["date de la dernière purge du fichier synthèse","2018-01-12",null,null,"Cédeo Rodez","onet le chateau",null,"La deveze grande - ZA Lioujas-",null,"12740",null,null,null,{"$f":"SUM(N9+1)","v":"2021-05-24"},"Lundi de Pentecôte",3,"SansListe",null,null,null,null,"Tel.1",8,1]
["Dernière mise à jour date","2018-03-01",null,null,"DLM CREATIONS","Rodez ",null,"Onet le Chateau",null,"12850",null,null,null,{"$f":"DATE(N2,7,14)","v":"2021-07-14"},"Fête Nationale France",4,"Date",null,null,null,null,"Tel.2",9,1]
["Durée Maxi du prêt",360,null,null,"Fauche Rodez","Rodez cedex 9",null,"Onet le Chateau",null,"30034",null,null,null,{"$f":"DATE(N2,8,15)","v":"2021-08-15"},"Assomption",5,"Numerique",null,null,null,null,"Adresse mail Etablissement",10,1]
["Préfix Facture",null,null,null,"Malrieu","Sebazac",null,"Pole commercial comtal nord",null,"31676",null,null,null,{"$f":"DATE(N2,11,1)","v":"2021-11-01"},"Toussaint",6,"Lieux",null,null,null,null,"Validation",11,1]
["MAS _",null,null,null,"Mon brico BQV","Toulouse",null,"Rond point de saint Marc, ZAC de l'auterne",null,"34080",null,null,null,{"$f":"DATE(N2,11,11)","v":"2021-11-11"},"Armistice 1918",null,null,null,null,null,null,"Commentaires",12,1]
["Sufixe monnaie",null,null,null,"PMP Piscine",null,null,"Rue de la Prade ZI de Cantaranne",null,null,null,null,null,{"$f":"DATE(N2,12,25)","v":"2021-12-25"},"Noël",null,null,null,null,null,null,"Liens documents attachés",13,1]
[" €",null,null,null,"PRAXIS MEDICAL",null,null,"Rue St Christophe ZA du causse"]
["N° Réservation",null,null,null,"PUM PLASTIQUE",null,null,"Z.A. Les Molinières - Le Pereyret"]
[3,null,null,null,"Raynal Batterie",null,null,"ZA bel Air - Avenue du causse "]
[null,null,null,null,"SCT tout electric",null,null,"ZI DU MALAN IV"]
[null,null,null,null,"Sicli Toulouse",null,null,"Zone Commerciale Puy Laroque"]
[null,null,null,null,"Sider Michel.Soulage Commercial"]
[null,null,null,null,"VGM Lioujas"]
[null,null,null,null,"Vitrine médicale"]

{"sheet":"Gestion Mot DE Passe","index":5,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Users","Passworld","Niveau","Date"]
["Admin","Admin",1,"2016-02-02"]