{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Projet","Plan d'Actions","Planning","Process","Liste","Base_date","Base"],"not_rendered":{"macros":1,"external_links":9,"defined_names":31},"read":"whole","date_system":"1900"}

{"sheet":"Projet","index":0,"n_rows":143,"n_cols":4,"rows_kept":143,"merged":[[0,3,0,4],[1,3,1,4],[2,1,2,2],[4,1,4,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[14,3,14,4],[15,3,15,4],[19,3,19,4],[20,3,20,4]]}
["SUS - Concept Informatique & Réseau",null,null,{"$f":"\"Dernière MAJ le \"&TEXT(TODAY(),\"jj/mm/aa\")","v":"Dernière MAJ le 30/03/20"}]
[{"$nulls":3},"Version 2.2"]
["PROJET"]
[]
["Code Associé (CCA)"]
["Code Magasin (CCU)"]
["Enseigne"]
["Nom du PDV"]
["Gep/IP"]
[]
["Surface actuelle"]
["Surface future"]
[]
[]
["Associé ou Parrain",null,"Portable"]
["Contact PDV",null,"Portable"," "]
["Mail Associé"]
[]
[]
["Référent ULIS",null,"Référent ULIS 2 "]
["Référent Mona",null,"Référent Mona 2"]
[]
["Date d'adhésion"]
["Fermeture le "]
["Ouverture le ","2020-04-16"]
["Installation Matériel - Phase 1"]
["Installation Matériel - Phase 2"]
["Audit Formation"]
[]
[]
["Chargé de Projet IPV",null,"Portable",{"$f":"IF($B$31=\"Sylvie BOULET\",$B$81,IF($B$31=\"Alexis FOISSAC\",$B$82,\"---\"))","v":"---"}]
["Mail :   ",{"$f":"IF($B$31=\"Sylvie BOULET\",$C$81,IF($B$31=\"Alexis FOISSAC\",$C$82,\"---\"))","v":"---"}]
["Chargé de Concept",null,"Portable"]
["Mail :   "]
[]
["Formateur ULIS",null,"Portable"]
["Formateur MONA",null,"Portable"]
["Formateur CRLS",null,"Portable"]
["Formateur U Scanning",null,"Portable"]
["Formateur Courses U",null,"Portable"]
["Formateur Proshop",null,"Portable"]
["Assistant Parrain",null,"Portable"]
{"$rows_empty":11}
["A Faire"]
["En cours"]
["Non concerné"]
["Fait"]
[]
["Connectée"]
["Non connectée"]
[]
["Oui"]
["Non"]
[]
["Création"]
["Démission"]
["Passe Utlie à UE"]
["Ralliement"]
["Remodeling"]
["Station / Lavage"]
["Transfert"]
["UPF"]
{"$rows_empty":8}
["Sylvie Boulet","06 80 36 46 38","sylvie.boulet@systeme-u.fr"]
["Alexis Foissac",684420967,"alexis.foissac@systeme-u.fr"]
["Ivan RUNG",467876244]
{"$rows_empty":44}
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]

{"sheet":"Plan d'Actions","index":1,"n_rows":333,"n_cols":24,"rows_kept":333,"merged":[[2,3,2,5]]}
[{"$nulls":9},"Code Magasin (CCU):",{"$f":"Projet!$B$5","v":0},{"$nulls":9},"Chargé de Projet: ",{"$f":"Projet!$B$31","v":0},"Parrain:",{"$f":"Projet!$B$15","v":0}]
[{"$nulls":9},"Code Associé:",{"$f":"Projet!$B$6","v":0},{"$nulls":9},"Formateur Ulis: ",{"$f":"Projet!$B$36","v":0}]
[{"$nulls":9},"Enseigne:",{"$f":"Projet!$B$7","v":0},"Ville:",{"$f":"Projet!$B$8","v":0},null,"Affiliation:","U Enseigne",{"$nulls":4},"Formateur Mona:",{"$f":"Projet!$B$21","v":0}]
[]
["N° Action","UPF","Création ","Ralliement","Transfert","Remodeling","Passe Utile à UE","Démisison","Station / Lavage","Période","Début ","Fin","Phase","Action dépendante de l'action n° ","Action","ACTEUR","Statut","Info intervenants","Date souhaitée","Date planifiée","Commentaires"]
[1,"X","X","X","X","X",null,"X",null,"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Initialisation Projet",null,"Publication de la note d'information ","AC","A Faire"]
[3,"X","X","X","X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Compte",{"$f":"A6","v":"1900-01-01"},"Création Profil UNISVERS au nom de l'Associé","AC","A Faire"]
[5,"X","X",null,"X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Commandes",null,"Verification Ouverture Catanoma","AC","A Faire"]
[4,"X","X","X","X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Comptes",{"$f":"A6","v":"1900-01-01"},"Communication du profil UNISVERS à l'Associé + destinaitaires U","AC","A Faire"]
[2,"X","X","X","X","X",null,"X",null,"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Prestation","Doublon","Estimation chiffrage équipement et prestations informatiques (Hors formation)","Coordo Outils PDV","A Faire","OPDV","2019-10-18",null,"11:00:00"]
[6,null,"X","X","X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Commandes",null,"Planning des commandes (squelettes et remplissages)\nRemarque: Ne concerne pas les magasins UPF","CP dev","A Faire"]
[7,null,"X","X","X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Commandes",null,"Planning des commandes promos (liste des catalogues et engagements)\nRemarque: Ne concerne pas les magasins UPF","AC","A Faire"]
[8,null,"X","X","X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Commandes",{"$f":"A6","v":"1900-01-01"},"Ouverture des droits aux commandes CR\nRemarque: Ne concerne pas les magasins UPF","CP dev","A Faire"]
[9,null,"X","X","X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Commandes",{"$f":"A13","v":"1900-01-08"},"Ouverture des droits aux commandes CN\nRemarque: Ne concerne pas les magasins UPF","CP dev","A Faire"]
[10,null,"X","X","X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Commandes",{"$f":"A13","v":"1900-01-08"},"Ouverture des droits aux commandes COBAS\nRemarque: Ne concerne pas les magasins UPF","MONITORAT METIER","A Faire"]
[11,null,"X","X","X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Commandes",{"$f":"A13","v":"1900-01-08"},"Ouverture des droits aux commandes LUDIC\nRemarque: Ne concerne pas les magasins UPF","MONITORAT METIER","A Faire"]
[12,null,"X","X","X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Commandes",{"$f":"A19","v":"1900-01-14"},"Ouverture des droits aux commandes SPILEC\nRemarque: Ne concerne pas les magasins UPF","AC","A Faire"]
[13,null,"X","X","X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Commandes",{"$f":"A16","v":"1900-01-11"},"Ouverture des droits aux commandes LDD\nRemarque: Ne concerne pas les magasins UPF","Assistance Concepts & projets PDV","A Faire"]
[14,"X","X",null,"X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Commandes",{"$f":"A13","v":"1900-01-08"},"Ouverture des droits aux commandes produits dématérialisés","Assistance Concepts & projets PDV","A Faire"]
[15,"X","X","X","X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Commandes","1900-01-09","Vérifier que le positionnement PEPP est alimenté","Coordo Outils PDV","A Faire"]
[17,null,"X","X","X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Commandes",null,"Accompagnement et suivi du passage des Commandes\nRemarque: Ne concerne pas les magasins UPF","Assistance Concepts & projets PDV","A Faire"]
[18,"X","X","X","X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Préparation serveur",{"$f":"A18","v":"1900-01-13"},"Demande adressage IP + trigramme à IRIS_PROJETS","Coordo Outils PDV","A Faire"]
[19,"X","X","X","X","X",null,"X",null,"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Initialisation Projet",{"$f":"A47","v":"1900-02-07"},"Initialisation de la fiche projet (Drive)","Coordo Outils PDV","A Faire"]
[20,"X","X","X","X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Matériel",{"$f":"#REF!","v":{"$error":"#REF!"}},"Commande serveur USB","Coordo Outils PDV","A Faire"]
[21,"X","X","X","X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Préparation serveur",{"$f":"A22","v":"1900-01-18"},"Mise en biberonnage serveur USB","IRIS","A Faire"]
[22,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation serveur",{"$f":"A25","v":"1900-01-21"},"Initialisation du biberonnage","Coordo Etude\nOutils PDV","A Faire"]
[32,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation serveur",{"$f":"A15","v":"1900-01-10"},"Création 1er profil ULIS pour UPF","Parrain","A Faire"]
[30,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation serveur",{"$f":"A31","v":"1900-01-25"},"Vérification Ulis et Faire monter en version si besoin","Coordo Etude\nOutils PDV","A Faire"]
[23,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation serveur",null,"Abonnements aux flux CR et CN","Coordo Etude\nOutils PDV","A Faire"]
[24,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation serveur",null,"Abonnements aux flux MONA, LocationU…","Coordo Etude\nOutils PDV","A Faire"]
[25,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation serveur",null,"Inscription du magasin dans EDU CR et CN (demande ACT données)","Coordo Etude\nOutils PDV","A Faire"]
[27,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation serveur",{"$f":"A29","v":"1900-01-23"},"Communication du paramétrage Assortiment magasin","MONITORAT METIER","A Faire"]
[26,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation serveur",{"$f":"A26","v":"1900-01-22"},"Paramétrage Assortiment magasin dans ULIS","Coordo Etude\nOutils PDV","A Faire"]
[28,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation serveur",{"$f":"A29","v":"1900-01-23"},"Paramétrage files d'impression par défaut","Coordo Etude\nOutils PDV","A Faire"]
[29,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation serveur",{"$f":"A30","v":"1900-01-24"},"Vérifier l'activation des triggers","Coordo Etude\nOutils PDV","Fait"]
[31,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation serveur",{"$f":"A31","v":"1900-01-25"},"Informer que le serveur ULIS est prêt","Coordo Etude\nOutils PDV","Fait"]
[null,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation serveur",null,"Création acces distant au serveur en biberronnage","IRIS","Fait"]
[null,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation serveur",null,"Vérification ou ajout compte(s) AD","Coordo Outils PDV","Non concerné"]
[null,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation serveur",null,"Création profil(s) ULIS pour magasin","Parrain","Fait"]
[34,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation Ouverture",{"$f":"A45","v":"1900-02-05"},"Abonnement Flux Fournisseurs Directs","MONITORAT OPDV","A Faire"]
[null,"X","X","X","X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Matériel",null,"Devis et commande PC portable avec Junos","CP Outils PDV","Fait"]
[16,"X","X","X","X","X",{"$nulls":3},"J-6 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},{"$f":"EDATE(Projet!$B$25,-6)","v":"2019-10-16"},"Matériel",null,"Remise du portable au magasin et formation \"Commandes\"","Equipe Ralliement","A Faire"]
[35,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation serveur",null,"Assister le magasin pour ses premières commandes\nRemarque: Ne concerne pas les magasins UPF","Parrain","A Faire"]
[41,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Commandes ",null,"Suivi passage des commandes\nRemarque: Ne concerne pas les magasins UPF","Assistance Concepts & projets PDV","A Faire"]
[36,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation Ouverture",{"$f":"A33","v":"1900-01-26"},"Audit Orga ULIS + planning formation ULIS + date inventaire de cession","MONITORAT OPDV","A Faire"]
[37,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation Ouverture",null,"Définir un planning d'installation à échanger avec le monitorat","CP Outils PDV","A Faire"]
[38,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation Ouverture",{"$f":"A26","v":"1900-01-22"},"Première visite de chantier","CP Outils PDV","A Faire"]
[39,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation Ouverture",{"$f":"#REF!","v":{"$error":"#REF!"}},"Compte rendu de visite de chantier","CP Outils PDV","A Faire"]
[null,"X","X","X","X","X",{"$nulls":3},"J-5 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},{"$f":"EDATE(Projet!$B$25,-5)","v":"2019-11-16"},"Préparation Ouverture",null,"Alimenter ou completer la fiche Projet","Coordo Outils PDV \nCP Outils PDV","A Faire"]
[76,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"#REF!","v":{"$error":"#REF!"}},"Validation besoins courants faible selon besoin Réseau+BO+FO auprès du prestataire Courant faible","CP Outils PDV","A Faire"]
[77,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",null,"Validation besoins courant fort selon besoin Réseau+BO+FO auprès du prestataire Courant fort","CP Outils PDV","A Faire"]
[46,"X","X","X","X","X",{"$nulls":3},"J-4 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-4)","v":"2019-12-16"},{"$f":"EDATE(Projet!$B$25,-4)","v":"2019-12-16"},"Comptes",{"$f":"#REF!","v":{"$error":"#REF!"}},"Création compte UPLV (Nom Projet) + Vérification","Coordo Outils PDV","A Faire"]
[43,"X","X","X","X","X",{"$nulls":3},"J-4 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-4)","v":"2019-12-16"},{"$f":"EDATE(Projet!$B$25,-4)","v":"2019-12-16"},"Matériel",{"$f":"A56","v":"1900-02-21"},"Positionner les baies sur plan de masse et déposer le plan sur le DRIVE","CP Outils PDV","A Faire"]
[47,"X","X","X","X","X",{"$nulls":3},"J-4 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-4)","v":"2019-12-16"},{"$f":"EDATE(Projet!$B$25,-4)","v":"2019-12-16"},"Prestation",{"$error":"#REF!"},"Commande Audit WIFI","CP Outils PDV","A Faire"]
[51,"X","X","X","X","X",{"$nulls":3},"J-3 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-3)","v":"2020-01-16"},{"$f":"EDATE(Projet!$B$25,-3)","v":"2020-01-16"},"Prestation",{"$f":"A54","v":"1900-02-16"},"Audit WIFI ","PRESTATAIRE","A Faire"]
[52,"X","X","X","X","X",{"$nulls":3},"J-3 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-3)","v":"2020-01-16"},{"$f":"EDATE(Projet!$B$25,-3)","v":"2020-01-16"},"Prestation",{"$f":"#REF!","v":{"$error":"#REF!"}},"CR audit WIFI","PRESTATAIRE","A Faire"]
[53,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Installation",{"$f":"A23","v":"1900-01-19"},"Installation ou validation tête de ligne FT","ORANGE","A Faire"]
[54,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"}," @rmonie",{"$f":"A57","v":"1900-02-22"},"Commande ligne @rmonie à IRIS_PROJETS","Coordo Outils PDV","A Faire"]
[55,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation","1900-02-23","Local baie livré","PRESTATAIRE","A Faire"]
[56,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation","1900-02-24","Baie principale livrée et alimentée","PRESTATAIRE","A Faire"]
[57,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"A56","v":"1900-02-21"},"Visite site pour pré-requis ligne @rmonie et back-Office","ORANGE","Fait"]
[58,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"}," @rmonie",{"$f":"#REF!","v":{"$error":"#REF!"}},"Installation Support ligne @rmonie","ORANGE","A Faire"]
[59,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"}," @rmonie",{"$f":"A62","v":"1900-02-27"},"Installation Ligne  @rmonie","ORANGE","A Faire"]
[60,"X","X","X","X","X",{"$nulls":3},"J-2 de l'installation",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"}," @rmonie",{"$f":"A62","v":"1900-02-27"},"Installation routeur 4G secours (ligne  @rmonie)","ORANGE","Fait"]
[61,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"A144","v":"1900-06-16"},"Validation besoins BO avec l'Associé","CP Outils PDV","Fait"]
[78,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"A50","v":"1900-03-16"},"Validation des besoins meubles de caisses en ligne","CP Outils PDV","Fait"]
[79,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"A83","v":"1900-03-12"},"Validation des besoins meubles caisse à l'accueil","CP Outils PDV","Fait"]
[62,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"A83","v":72},"Commande équipement/Prestation meubles caisses","CP Dev","A Faire"]
[86,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"A83","v":72},"Production de la fiche de préparation pour commande phase 1","Assistance Concepts & projets PDV","A Faire"]
[87,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"A69","v":86},"Création des compte AD matériel BO phase 1","Assistance Concepts & projets PDV","A Faire"]
[63,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"A65","v":"1900-03-01"},"Commande équipement BO Phase 1","CP Outils PDV","Fait"]
[86,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"A86","v":75},"Production de la fiche de préparation pour commande phase 2 \n","Assistance Concepts & projets PDV","A Faire"]
[63,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"A66","v":"1900-03-18"},"Commande équipement BO Phase 2","CP Outils PDV","Non concerné"]
[{"$nulls":12},"Préparation serveur",null,"Renseigner l'onglet 4.3 fiche projet ","Coordo Outils PDV","Fait"]
[64,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"A71","v":"1900-03-03"},"Commande équipement et prestations WIFI","CP Outils PDV","Fait"]
[65,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"A71","v":"1900-03-03"},"Commande éléments actifs + installation","CP Outils PDV","Fait"]
[66,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"A75","v":"1900-03-04"},"Commande installation serveur USB  ","CP Outils PDV","Fait"]
[67,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"A80","v":69},"Commande prestation installation BO phase 1","Coordo Outils PDV","Fait"]
[68,"X",null,"X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"A64","v":60},"Commande prestation déplacement serveur USB + éléments actifs + SEGLAN","CP Outils PDV","Non concerné"]
[69,"X",null,"X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"A79","v":68},"Commande prestation déplacement BO installé en phase 1","Coordo Outils PDV","Non concerné"]
[70,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"A78","v":67},"Commande prestation installation BO phase 2 au GIE","Coordo Outils PDV","Non concerné"]
[71,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"A80","v":69},"Validation besoins FO + CATALINA avec l'Associé","CP Outils PDV","Fait"]
[72,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"A80","v":69},"Commande équipement FO phase 1 (ex caisse école)","CP Outils PDV","Fait"]
[73,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"A83","v":72},"Commande équipement FO Phase 2 + CATALINA ","CP Outils PDV","Non concerné"]
[74,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$error":"#REF!"},"Commande prestation installation FO phase 1 au GIE","CP Outils PDV","Fait"]
[75,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$error":"#REF!"},"Commande prestation installation FO phase 2 + CATALINA au GIE","CP Outils PDV","Non concerné"]
[80,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"A83","v":"1900-03-12"},"Validation des besoins EEG (Nbre adresse IP, …;)","CP Outils PDV","Fait"]
[81,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"A84","v":"1900-03-13"},"Validation des besoins Balances (Nbre, …;)","CP Outils PDV","Fait"]
[83,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"#REF!","v":{"$error":"#REF!"}},"Commande kit de démarrage consommables BO+FO","Coordo Outils PDV","Fait"]
[84,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"A89","v":83},"Commande économat V6","Coordo Outils PDV","Fait"]
[88,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"A85","v":74},"Commande du Traceur Canon","Assistance Concepts & projets PDV","A Faire"]
[89,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",75,"Commande imprimante Sato","Coordo Outils PDV","Fait"]
[90,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"A50","v":76},"Commande imprimante Ricoh + Proposer location + Contrat de maintenance","CP Outils PDV","Fait"]
[94,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"#REF!","v":{"$error":"#REF!"}},"Complétude fiche de préparation complète pour feuille de route complète prestation","Coordo Outils PDV","Fait"]
[96,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"#REF!","v":{"$error":"#REF!"}},"Commande prestation installation BO phase 2","Coordo Outils PDV","Non concerné"]
[97,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"#REF!","v":{"$error":"#REF!"}},"Commande prestation installation Réseau phase 2","IRIS","Non concerné"]
[99,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"#REF!","v":{"$error":"#REF!"}},"Commande prestation FO phase 2","CP Outils PDV","Non concerné"]
[100,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"A83","v":72},"Commande prestation CATALINA ","CP Outils PDV","A Faire"]
[101,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"A83","v":72},"Commande équipement + installation balances ","CP Dev","A Faire"]
[102,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"A83","v":72},"Coordination installation balances","Coordo Outils PDV","A Faire"]
[103,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"A83","v":72},"Commande équipement + installation EEG","CP Dev","A Faire"]
[104,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",null,"Coordination installation EEG","Coordo Outils PDV","A Faire"]
[105,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",{"$f":"A83","v":72},"Commande équipement + installation AUDIADIS","CP Dev","A Faire"]
[106,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",null,"Coordination installation AUDIADIS","Coordo Outils PDV","A Faire"]
[107,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"A84","v":73},"Audiadis Proposition Contrat","CP Dev","A Faire"]
[117,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Préparation Ouverture",{"$f":"A86","v":75},"Vérifier démarche Location U","Coordo Outils PDV","A Faire"]
[118,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Préparation Ouverture",{"$f":"A50","v":76},"Coordination/installation Courses U","Coordo Outils PDV","A Faire"]
[119,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"#REF!","v":{"$error":"#REF!"}},"Mise en œuvre câblage","PRESTATAIRE","A Faire"]
[120,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"A161","v":166},"Visite de contrôle des pré-requis courants fort et faible + phasing","CP Outils PDV","A Faire"]
[121,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Compte",null,"Validation fiche monétique","CP Outils PDV","A Faire"]
[122,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Préparation serveur",null,"Opération fin de biberonnage et GO GIE pour retirer le serveur du biberonnage + expédition","CP Outils PDV","A Faire"]
[123,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Préparation serveur",{"$f":"A109","v":"1900-04-29"},"Faire monter la dernière version ULIS si nouvelles versions depuis début de biberonnage","Coordo Etude\nOutils PDV","A Faire"]
[124,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",null,"Contrôle réception serveur + matériel BO Phase 1","Coordo Outils PDV","A Faire"]
[125,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",null,"Installation et brassage des éléménts actifs Phase 1","PRESTATAIRE","A Faire"]
[126,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",null,"Installation serveur USB (ULIS/MONA) Phase 1","PRESTATAIRE","A Faire"]
[127,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",null,"Brassage des serveurs USB, routeurs @rmonie, SWITCHes Phase 1","PRESTATAIRE","A Faire"]
[128,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Préparation Serveur",{"$f":"A55","v":51},"Finalisation technique serveur USB à distance","IRIS","A Faire"]
[129,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Préparation Serveur",{"$f":"A55","v":51},"Finalisation + contrôle des flux serveur USB","Coordo Etude\nOutils PDV","A Faire"]
[130,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Préparation serveur",{"$f":"A114","v":"1900-05-04"},"Vérifier l'activation des triggers","Coordo Etude\nOutils PDV","A Faire"]
[131,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Préparation Serveur",null,"Récupérer les flux CR et CN manuellement si délai 10j dépassé","Coordo Etude\nOutils PDV","A Faire"]
[132,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Préparation serveur",null,"Modification adressage sur EDU CR + CN","Coordo Etude\nOutils PDV","A Faire"]
[133,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Préparation serveur",null,"Abonner le magasin au flux U63 (ventes moyennes)","Coordo Etude\nOutils PDV","A Faire"]
[134,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",{"$f":"A55","v":51},"Installation BO phase 1","PRESTATAIRE","A Faire"]
[135,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",null,"Brassage des équipements BO, FO, balances, EEG, AUDIADIS …Phase 1","PRESTATAIRE","A Faire"]
[136,"X","X","X","X","X",{"$nulls":3},"J-1 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},"Prestation",{"$f":"#REF!","v":{"$error":"#REF!"}},"Coordination installation Station service","Coordo Outils PDV","A Faire"]
[137,"X","X","X","X","X",{"$nulls":3},"J-1 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},"Prestation",{"$f":"A83","v":72},"Coordination livraison + installation traceur CANON","Coordo Outils PDV","Non concerné"]
[138,"X","X","X","X","X",{"$nulls":3},"J-1 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},"Prestation",{"$f":"A83","v":72},"Coordination livraison + installation imprimantes RICOH","Coordo Outils PDV","A Faire"]
[139,"X","X","X","X","X",{"$nulls":3},"J-1 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},"Prestation",{"$f":"A83","v":72},"Coordination livraison + installation imprimantes SATO","Coordo Outils PDV","A Faire"]
[140,"X","X","X","X","X",{"$nulls":3},"J-1 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},"Prestation",null,"Faire \"fixer\" les adresses IP pour les postes concernés","Coordo Outils PDV","A Faire"]
[124,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Matériel",null,"Contrôle réception matériel FO phase 1","Coordo Outils PDV","A Faire"]
[141,"X","X","X","X","X",{"$nulls":3},"J-1 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},"Prestation",{"$f":"A55","v":51},"Installation FO phase 1 (caisses école)","PRESTATAIRE","A Faire"]
[125,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",null,"Déplacement et brassage des éléménts actifs Phase 2","PRESTATAIRE","A Faire"]
[126,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",null,"Déplacement serveur USB (ULIS/MONA) Phase 2","PRESTATAIRE","A Faire"]
[127,"X","X","X","X","X",{"$nulls":3},"J-2 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},{"$f":"EDATE(Projet!$B$25,-2)","v":"2020-02-16"},"Prestation",null,"Brassage des serveurs USB, routeurs @rmonie, SWITCHes Phase 2","PRESTATAIRE","A Faire"]
[142,"X","X","X","X","X",{"$nulls":3},"J-1 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},"Prestation",{"$f":"A55","v":51},"Brassage des équipements BO, FO, balances… phase 2","PRESTATAIRE","A Faire"]
[143,"X","X","X","X","X",{"$nulls":3},"J-1 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},"Prestation",{"$f":"A17","v":12},"Vérifier préparation référentiel EEG et paramétrage ULIS","MONITORAT OPDV","A Faire"]
[144,"X","X","X","X","X",{"$nulls":3},"J-1 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},"Prestation",{"$f":"A16","v":11},"Installation EEG","PRESTATAIRE","A Faire"]
[145,"X","X","X","X","X",{"$nulls":3},"J-1 mois de l'ouverture magasin",{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},{"$f":"EDATE(Projet!$B$25,-1)","v":"2020-03-16"},"Prestation",{"$f":"#REF!","v":{"$error":"#REF!"}},"Test liaison ULIS/EEG","HOTLINE OPDV","A Faire"]
[147,"X","X","X","X","X",{"$nulls":3},"20 jours avant l'ouverture magasin",{"$f":"Projet!$B$25-20","v":"2020-03-27"},{"$f":"Projet!$B$25-20","v":"2020-03-27"},"Formation",null,"Formation ULIS","MONITORAT OPDV","A Faire"]
[148,"X","X","X","X","X",{"$nulls":3},"10 jours avant l'ouverture magasin",{"$f":"Projet!$B$25-10","v":"2020-04-06"},{"$f":"Projet!$B$25-10","v":"2020-04-06"},"Prestation",null,"Contrôle réception matériel BO  Phase 2","Coordo Outils PDV","A Faire"]
[148,"X","X","X","X","X",{"$nulls":3},"10 jours avant l'ouverture magasin",{"$f":"Projet!$B$25-10","v":"2020-04-06"},{"$f":"Projet!$B$25-10","v":"2020-04-06"},"Prestation",null,"Contrôle réception matériel FO  Phase 2","Coordo Outils PDV","A Faire"]
[149,"X","X","X","X","X",{"$nulls":3},"10 jours avant l'ouverture magasin",{"$f":"Projet!$B$25-10","v":"2020-04-06"},{"$f":"Projet!$B$25-10","v":"2020-04-06"},"Prestation",null,"Contrôle réception matériel CATALINA (hors SWITCH)","Coordo Outils PDV","A Faire"]
[150,"X","X","X","X","X",{"$nulls":3},"10 jours avant l'ouverture magasin",{"$f":"Projet!$B$25-10","v":"2020-04-06"},{"$f":"Projet!$B$25-10","v":"2020-04-06"},"Compte",{"$f":"A7","v":"1900-01-03"},"Création compte INTERNET du magasin","Coordo Outils PDV","A Faire"]
[168,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-30","v":"2020-03-17"},"Compte",{"$f":"#REF!","v":{"$error":"#REF!"}},"Communication du compte INTERNET à l'Associé","Coordo Outils PDV","A Faire"]
[151,"X","X","X","X","X",{"$nulls":3},"10 jours avant l'ouverture magasin",{"$f":"Projet!$B$25-10","v":"2020-04-06"},{"$f":"Projet!$B$25-10","v":"2020-04-06"},"Compte",{"$f":"A84","v":73},"Ouvrir site Magasin U.com ","MKG CLTS","A Faire"]
[152,"X","X","X","X","X",{"$nulls":3},"10 jours avant l'ouverture magasin",{"$f":"Projet!$B$25-10","v":"2020-04-06"},{"$f":"Projet!$B$25-10","v":"2020-04-06"},"Compte",74,"Ouvrir site Facebook ","AC","A Faire"]
[153,"X",null,"X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"#REF!","v":{"$error":"#REF!"}},"Démontage FO ","PRESTATAIRE","A Faire"]
[154,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A56","v":52},"Installation Compta Paie","PRESTATAIRE","A Faire"]
[154,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A57","v":53},"Installation Solution Pointage","PRESTATAIRE","A Faire"]
[155,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A55","v":51},"Installation BO phase 2","PRESTATAIRE","A Faire"]
[156,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A55","v":51},"Installation traceur CANON","PRESTATAIRE","A Faire"]
[157,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A55","v":51},"Installation imprimantes RICOH","PRESTATAIRE","A Faire"]
[158,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A55","v":51},"Installation imprimante SATO","HOTLINE OPDV","A Faire"]
[159,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A19","v":14},"Vérifier préparation référentiel Balances et paramétrage ULIS","HOTLINE OPDV","A Faire"]
[160,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A55","v":51},"Installation balances","Prestataire","A Faire"]
[161,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A55","v":51},"Test liaison ULIS/balances","HOTLINE OPDV","A Faire"]
[162,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A55","v":51},"Installation FO phase 2","Prestataire","A Faire"]
[163,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A55","v":51},"Installation CATALINA","Prestataire","A Faire"]
[164,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A55","v":51},"Installation HOTSPOT","ORANGE","A Faire"]
[165,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A57","v":53},"Installation/ Déplacement AUDIADIS","Prestataire","A Faire"]
[166,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A108","v":119},"Installation des bornes WIFI","Prestataire","A Faire"]
[167,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A55","v":51},"Installation couverture WIFI + équipement PDA","Prestataire","A Faire"]
[170,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Formation",{"$f":"A143","v":"1900-05-29"},"Formation Unisvers","MONITORAT OPDV","A Faire"]
[171,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Formation",null,"Formation MONA","MONITORAT OPDV","A Faire"]
[146,"X","X","X","X","X",{"$nulls":3},"1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A55","v":51},"Vérifier préparation référentiel Station et paramétrage ULIS","Coordo Outils PDV","A Faire"]
[172,"X","X","X","X","X",null,null,"X","1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A56","v":52},"Installation Pupitre Station","PRESTATAIRE","A Faire"]
[173,"X","X","X","X","X",null,null,"X","1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A18","v":13},"Test Liaison ULIS/Station","HOTLINE OPDV","A Faire"]
[174,"X","X","X","X","X",null,null,"X","1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A19","v":14},"Installation Station Lavage","PRESTATAIRE","A Faire"]
[175,"X","X","X","X","X",null,null,"X","1 mois à 1 jour avant l'ouverture magasin",{"$f":"Projet!$B$25-30","v":"2020-03-17"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A20","v":15},"Test Liaison ULIS/Station Lavage","HOTLINE OPDV","A Faire"]
[175,"X","X","X","X","X",{"$nulls":3},"J-1",{"$f":"Projet!$B$25-1","v":"2020-04-15"},{"$f":"Projet!$B$25-1","v":"2020-04-15"},"Prestation",{"$f":"A55","v":51},"RAZ","PRESTATAIRE","A Faire"]
[176,"X","X","X","X","X",{"$nulls":3},"J",{"$f":"Projet!$B$25","v":"2020-04-16"},{"$f":"Projet!$B$25","v":"2020-04-16"},"Ouverture","Doublon","Assistance ouverture","PRESTATAIRE","A Faire"]
[177,"X","X","X","X","X",{"$nulls":3},"J",{"$f":"Projet!$B$25","v":"2020-04-16"},{"$f":"Projet!$B$25","v":"2020-04-16"},"Préparation serveur",null,"Activer les triggers de remontée CA ","Coordo Etude\nOutils PDV","A Faire"]
[178,"X","X","X","X","X",{"$nulls":3},"J",{"$f":"Projet!$B$25","v":"2020-04-16"},{"$f":"Projet!$B$25","v":"2020-04-16"},"Prestation",{"$f":"#REF!","v":{"$error":"#REF!"}},"Modification compte UPLV Nom de la ville","Coordo Outils PDV","A Faire"]
[179,"X","X","X","X","X",{"$nulls":3},"J",{"$f":"Projet!$B$25","v":"2020-04-16"},{"$f":"Projet!$B$25","v":"2020-04-16"},"Commandes",{"$f":"A172","v":"1900-06-25"},"Ouverture des droits aux commandes LDD","Assistance Concepts & projets PDV","A Faire"]
[180,"X","X","X","X","X",{"$nulls":3},"J",{"$f":"Projet!$B$25","v":"2020-04-16"},{"$f":"Projet!$B$25","v":"2020-04-16"},"Commandes",{"$f":"A167","v":173},"Ouverture des droits aux commandes produits dématérialisés","Assistance Concepts & projets PDV","A Faire"]
[181,"X","X","X","X","X",{"$nulls":3},"Après ouverture",{"$f":"Projet!$B$25+2","v":"2020-04-18"},{"$f":"Projet!$B$25+30","v":"2020-05-16"},"Prestation","Doublon","Chiffrage réel équipement et prestations informatiques","Coordo Outils PDV","A Faire"]
[182,"X","X","X","X","X",{"$nulls":3},"Après ouverture",{"$f":"Projet!$B$25","v":"2020-04-16"},{"$f":"Projet!$B$25+2","v":"2020-04-18"},"Prestation","Doublon","Bornage PVC MDD","HOTLINE OPDV","A Faire"]
{"$rows_empty":125}
["Audiadis"]
["Berkel"]
["Bizerba"]
["Canon"]
["Castres Equipement"]
["Catalina"]
["Contact SES"]
["Courrier"]
["Digi"]
["GIE Technique"]
["IRIS Projet"]
["Lavance"]
["Madic Bordeaux "]
["Madic Marseille"]
["Madic Toulouse"]
["Medialog"]
["Mettler "]
["Mistral"]
["Mobilité"]
["OPDV"]
["OPDV - HL"]
["Orange"]
["Pricer"]
["Proservia"]
["Proshop"]
["Ricoh"]
["SPIE"]
["Tokheim Bordeaux"]
["Tokheim Marseille"]
["Tokheim Toulouse"]
["Toshibatec"]

{"sheet":"Planning","index":2,"n_rows":120,"n_cols":187,"rows_kept":120,"merged":[[1,1,1,186]]}
[{"$f":"Projet!$B$5 & \" - \" & Projet!$B$8","v":" - "},"Date Ouverture",{"$f":"Projet!$B$25","v":"2020-04-16"}]
[null,{"$f":"\"Projet \" & Projet!$B$3 &\" du \"& $A$1 &\" du \"& \" \" & TEXT(B4,\"jj mmmm\") & \" au \" & TEXT(GE4,\"jj mmmm\")","v":"Projet  du  -  du  16 octobre au 18 avril"}]
[null,{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(B$4)","v":"Sem - 42"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(I$4)","v":"Sem - 43"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(P$4)","v":"Sem - 44"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(X$4)","v":"Sem - 45"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(AE$4)","v":"Sem - 46"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(AL$4)","v":"Sem - 47"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(AS$4)","v":"Sem - 48"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(AZ$4)","v":"Sem - 49"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(BG$4)","v":"Sem - 50"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(BN$4)","v":"Sem - 51"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(BU$4)","v":"Sem - 52"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(CB$4)","v":"Sem - 1"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(CI$4)","v":"Sem - 2"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(CP$4)","v":"Sem - 3"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(CW$4)","v":"Sem - 4"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(DD$4)","v":"Sem - 5"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(DK$4)","v":"Sem - 6"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(DR$4)","v":"Sem - 7"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(DY$4)","v":"Sem - 8"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(EF$4)","v":"Sem - 9"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(EM$4)","v":"Sem - 10"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(ET$4)","v":"Sem - 11"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(FA$4)","v":"Sem - 12"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(FH$4)","v":"Sem - 13"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(FO$4)","v":"Sem - 14"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(FV$4)","v":"Sem - 15"},{"$nulls":6},{"$f":"\"Sem - \" & _xlfn.ISOWEEKNUM(GC$4)","v":"Sem - 16"}]
[null,{"$f":"EDATE($C$1,-6)","v":"2019-10-16"},{"$f":"B4+1","v":"2019-10-17"},{"$f":"C4+1","v":"2019-10-18"},"2019-10-19","2019-10-20","2019-10-21","2019-10-22","2019-10-23","2019-10-24","2019-10-25","2019-10-26","2019-10-27","2019-10-28","2019-10-29","2019-10-30","2019-10-31","2019-11-01","2019-11-02","2019-11-03","2019-11-04","2019-11-05","2019-11-06","2019-11-07","2019-11-08","2019-11-09","2019-11-10","2019-11-11","2019-11-12","2019-11-13","2019-11-14","2019-11-15","2019-11-16","2019-11-17","2019-11-18","2019-11-19","2019-11-20","2019-11-21","2019-11-22","2019-11-23","2019-11-24","2019-11-25","2019-11-26","2019-11-27","2019-11-28","2019-11-29","2019-11-30","2019-12-01","2019-12-02","2019-12-03","2019-12-04","2019-12-05","2019-12-06","2019-12-07","2019-12-08","2019-12-09","2019-12-10","2019-12-11","2019-12-12","2019-12-13","2019-12-14","2019-12-15","2019-12-16","2019-12-17","2019-12-18","2019-12-19","2019-12-20",{"$f":"BO4+1","v":"2019-12-21"},"2019-12-22","2019-12-23","2019-12-24","2019-12-25","2019-12-26","2019-12-27","2019-12-28","2019-12-29","2019-12-30","2019-12-31","2020-01-01","2020-01-02","2020-01-03","2020-01-04","2020-01-05","2020-01-06","2020-01-07","2020-01-08","2020-01-09","2020-01-10","2020-01-11","2020-01-12","2020-01-13","2020-01-14","2020-01-15","2020-01-16","2020-01-17","2020-01-18","2020-01-19","2020-01-20","2020-01-21","2020-01-22","2020-01-23","2020-01-24","2020-01-25","2020-01-26","2020-01-27","2020-01-28","2020-01-29","2020-01-30","2020-01-31","2020-02-01","2020-02-02","2020-02-03","2020-02-04","2020-02-05","2020-02-06","2020-02-07","2020-02-08","2020-02-09","2020-02-10","2020-02-11","2020-02-12","2020-02-13","2020-02-14","2020-02-15","2020-02-16","2020-02-17","2020-02-18","2020-02-19","2020-02-20","2020-02-21","2020-02-22",{"$f":"EA4+1","v":"2020-02-23"},"2020-02-24","2020-02-25","2020-02-26","2020-02-27","2020-02-28","2020-02-29","2020-03-01","2020-03-02","2020-03-03","2020-03-04","2020-03-05","2020-03-06","2020-03-07","2020-03-08","2020-03-09","2020-03-10","2020-03-11","2020-03-12","2020-03-13","2020-03-14","2020-03-15","2020-03-16","2020-03-17","2020-03-18","2020-03-19","2020-03-20","2020-03-21","2020-03-22","2020-03-23","2020-03-24","2020-03-25","2020-03-26","2020-03-27","2020-03-28","2020-03-29","2020-03-30","2020-03-31","2020-04-01","2020-04-02","2020-04-03","2020-04-04","2020-04-05","2020-04-06","2020-04-07","2020-04-08","2020-04-09","2020-04-10","2020-04-11","2020-04-12","2020-04-13","2020-04-14","2020-04-15","2020-04-16",{"$f":"GC4+1","v":"2020-04-17"},{"$f":"GD4+1","v":"2020-04-18"}]
["Estimation chiffrage équipement et prestations informatiques (Hors formation)",null,{"$f":"IF(AND('Plan d''Actions'!O10=Planning!A5,'Plan d''Actions'!S10=Planning!C4),'Plan d''Actions'!Q10 &\" \"& TEXT('Plan d''Actions'!T10,\"hh:mm\"),\"\")","v":""}]
["Vérifier que le positionnement PEPP est alimenté"]
["Demande adressage IP + trigramme à IRIS_PROJETS"]
["Initialisation de la fiche projet (Drive)"]
["Commande serveur USB"]
["Création 1er profil ULIS pour UPF",{"$f":"IF(AND('Plan d''Actions'!O27=Planning!A10,'Plan d''Actions'!S27=Planning!B4),'Plan d''Actions'!R27 &\" \"& TEXT('Plan d''Actions'!U27,\"hh:mm\"),\"\")","v":""}]
["Vérification ou ajout compte(s) AD"]
["Création profil(s) ULIS pour magasin"]
["Devis et commande PC portable avec Junos"]
["Assister le magasin pour ses premières commandes\nRemarque: Ne concerne pas les magasins UPF"]
["Définir un planning d'installation à échanger avec le monitorat"]
["Première visite de chantier"]
["Compte rendu de visite de chantier"]
["Alimenter ou completer la fiche Projet"]
["Validation besoins courants faible selon besoin Réseau+BO+FO auprès du prestataire Courant faible"]
["Validation besoins courant fort selon besoin Réseau+BO+FO auprès du prestataire Courant fort"]
["Création compte UPLV (Nom Projet) + Vérification"]
["Positionner les baies sur plan de masse et déposer le plan sur le DRIVE"]
["Commande Audit WIFI"]
["Audit WIFI "]
["CR audit WIFI"]
["Installation ou validation tête de ligne FT"]
["Commande ligne @rmonie à IRIS_PROJETS"]
["Local baie livré"]
["Baie principale livrée et alimentée"]
["Visite site pour pré-requis ligne @rmonie et back-Office"]
["Installation Support ligne @rmonie"]
["Installation Ligne  @rmonie"]
["Installation routeur 4G secours (ligne  @rmonie)"]
["Validation besoins BO avec l'Associé"]
["Validation des besoins meubles de caisses en ligne"]
["Validation des besoins meubles caisse à l'accueil"]
["Commande équipement BO Phase 1"]
["Commande équipement BO Phase 2"]
["Renseigner l'onglet 4.3 fiche projet "]
["Commande équipement et prestations WIFI"]
["Commande éléments actifs + installation"]
["Commande installation serveur USB  "]
["Commande prestation installation BO phase 1"]
["Commande prestation déplacement serveur USB + éléments actifs + SEGLAN"]
["Commande prestation déplacement BO installé en phase 1"]
["Commande prestation installation BO phase 2 au GIE"]
["Validation besoins FO + CATALINA avec l'Associé"]
["Commande équipement FO phase 1 (ex caisse école)"]
["Commande équipement FO Phase 2 + CATALINA "]
["Commande prestation installation FO phase 1 au GIE"]
["Commande prestation installation FO phase 2 + CATALINA au GIE"]
["Validation des besoins EEG (Nbre adresse IP, …;)"]
["Validation des besoins Balances (Nbre, …;)"]
["Commande kit de démarrage consommables BO+FO"]
["Commande économat V6"]
["Commande imprimante Sato"]
["Commande imprimante Ricoh + Proposer location + Contrat de maintenance"]
["Complétude fiche de préparation complète pour feuille de route complète prestation"]
["Commande prestation installation BO phase 2"]
["Commande prestation FO phase 2"]
["Commande prestation CATALINA "]
["Coordination installation balances"]
["Coordination installation EEG"]
["Coordination installation AUDIADIS"]
["Vérifier démarche Location U"]
["Coordination/installation Courses U"]
["Mise en œuvre câblage"]
["Visite de contrôle des pré-requis courants fort et faible + phasing"]
["Validation fiche monétique"]
["Opération fin de biberonnage et GO GIE pour retirer le serveur du biberonnage + expédition"]
["Contrôle réception serveur + matériel BO Phase 1"]
["Installation et brassage des éléménts actifs Phase 1"]
["Installation serveur USB (ULIS/MONA) Phase 1"]
["Brassage des serveurs USB, routeurs @rmonie, SWITCHes Phase 1"]
["Installation BO phase 1"]
["Brassage des équipements BO, FO, balances, EEG, AUDIADIS …Phase 1"]
["Coordination installation Station service"]
["Coordination livraison + installation traceur CANON"]
["Coordination livraison + installation imprimantes RICOH"]
["Coordination livraison + installation imprimantes SATO"]
["Faire \"fixer\" les adresses IP pour les postes concernés"]
["Contrôle réception matériel FO phase 1"]
["Installation FO phase 1 (caisses école)"]
["Déplacement et brassage des éléménts actifs Phase 2"]
["Déplacement serveur USB (ULIS/MONA) Phase 2"]
["Brassage des serveurs USB, routeurs @rmonie, SWITCHes Phase 2"]
["Brassage des équipements BO, FO, balances… phase 2"]
["Installation EEG"]
["Test liaison ULIS/EEG"]
["Contrôle réception matériel BO  Phase 2"]
["Contrôle réception matériel FO  Phase 2"]
["Contrôle réception matériel CATALINA (hors SWITCH)"]
["Création compte INTERNET du magasin"]
["Communication du compte INTERNET à l'Associé"]
["Démontage FO "]
["Installation Compta Paie"]
["Installation Solution Pointage"]
["Installation BO phase 2"]
["Installation traceur CANON"]
["Installation imprimantes RICOH"]
["Installation imprimante SATO"]
["Vérifier préparation référentiel Balances et paramétrage ULIS"]
["Installation balances"]
["Test liaison ULIS/balances"]
["Installation FO phase 2"]
["Installation CATALINA"]
["Installation HOTSPOT"]
["Installation/ Déplacement AUDIADIS"]
["Installation des bornes WIFI"]
["Installation couverture WIFI + équipement PDA"]
["Vérifier préparation référentiel Station et paramétrage ULIS"]
["Installation Pupitre Station"]
["Test Liaison ULIS/Station"]
["Installation Station Lavage"]
["Test Liaison ULIS/Station Lavage"]
["RAZ"]
["Assistance ouverture"]
["Modification compte UPLV Nom de la ville"]
["Chiffrage réel équipement et prestations informatiques"]
["Bornage PVC MDD"]

{"sheet":"Process","index":3,"n_rows":46,"n_cols":2,"rows_kept":46,"hidden":true,"merged":[[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1]]}
[]
["Ouverture de compte Junos "]
["Associé : Jean-Luc Thémines"]
["CCU: 95457"]
["IP Serveur Ulis:  10.161.233.203"]
["IP Serveur Mona:10.162.233.85"]
[]
[]
["Questions ","Réponses"]
["16/05 SC: Validation process RAZ à distance par INFO U? Pas validé, en cours (info transmise aux chargés de projet)","Pas validée/ Sophie Martin \nVoir si ce serait possible avec une refactuaration"]
["12/06 SC: coût GEODIS pour montée du serveur USB à l'étage","Déménagement  + montée à l'étage serveur  630 €"]
["13/06 SC: SPI demande à Yann de communiquer le process d'ORANGE/ligne @ et avoir une visibilité sur la date et le PV de la 1ere visite ORANGE","1 Pose support\n2 Pose des Routeurs\n3 Pv d'installation ( Pas à ce jour)"]
["19/06 SC: Définir périmètre GIE / ORANGE","Dans le cas d'un Utile , La région envoie une fiche Projet à Orange pour le compte UPF\nPour tous les autres cas, la fiche projet est renseignée et envoyée à IRIS PROJET\n Mise en place d'un retour de Yann le mercredi sur réunion avec ORANGE du mardi à SPI et PR qui reviendront nous"]
["19/06 SC: Validation et pré-requis pour matériel hors (portable Associé). ","Pb lenteur portable référencé avec W10"]
["25/06 SC: Avec nouvelle solution WIFI, connexion des bornes sur le SWITCH FO\n","Oui le switch sur Juniper (FO)"]
["02/07 SC: Communiquer à la région les règles (nombre accès simultanés) et coûts des raccourcis (licence?)"]
["02/07 SC: Demande des magasins d'avoir l'identiant du réseau WIFI. Position du GIE?","Reponse GIE: NOK"]
["24/07: Manque d'infos sur mise en oeuvre de la solution WIFI dans les nouveaux projets PDV. Associer les CP UEns aux prestations d'audit sur site et d'installation","OK Doc sur DRIVE"]
["25/07: Schéma d'architecture WIFI + Couleur des câbles + n° des ports sur JUNIPER FO","cf Norme réseau groupe v65/Drive"]
["27/07 SC: Validation nouveaux flux en mode secours\n30/07 SPI un point sera fait avec U-enseigne","Info Webex + Documentation"]
["30/07 SC: La Région n'a pas été prévenu en amont du changement des types de forfaits et des coûts de biberonnage (1 seul forfait de 3 mois 987€ + 221€ par mois supplémentaire)","30/07 SPI a informé Franck sur le fait que la région souhaite une explication quant aux nouveaux tarifs de biberonnage USB"]
["30/07 SPI a remonté à Franck, son étonnement quant au contenu de la proposition commerciale. La région a dit qu'elle remonterait ces remarques sur le document.\nLa coordination projet aurait souhaité que le test soit fait jusqu'au la présentation au PDV afin d'avoir également les remontées PDV pour ce 1er pilote."]
["30/07 info SPI: pour les projets CRLS, initier une fiche projet à la carte. En attendant des livrables adaptés, déposer les documents habituels (dossier de pré-visite, deviseur...) sur le DRIVE, dans le dossier du magasin (04. Projets Sud). IRIS Projets fera le lien avec l'équipe déploiement ou INFO U.","13/08 SC: Retour N. Tranchand : les process CRLS ne changent pas. Vérifier passage info F. Fourcadier auprès de son équipe"]
["07/08 MPB: Process d'intégration VM Pricer dans Ustorebox en biberonnage : Attente Info GIE.","En mode Projet : Chargé de Projet communique à Pricer les adresses IP et les PC avec accès client. Pricer communique ensuite les IP au GIE IRIS.\nIRIS installe les racoucis sur PC ( à distance)\nHors mode projet: Pricer et le GIE IRIS communique directement"]
["14/08 PR: Règle de facturation encaissement","Facturation à la livraison de la caisse."]
["27/08 SC: Liste des applications hébergées à date recue. VM pour chaque application? Voir impacts UPLV, MTFA, PLANEXA sur process, accès fiche de prép","Envoyé \nhttps://drive.google.com/open?id=1In88_S0isksNpQWGKhQPPdJC3Hp-vF5BuXoXHMSqYwE"]
["27/08 SC: Proposition au GIE de faire un onglet \"points divers\" avec questions/réponses pour faciliter les recherches et d'alléger la présentation du CR par magasin","En cours"]
["28/08 PR: Va communiquer le dossier \"station de lavage\" aux régions."]
["28/08 SC: Demande au GIE de redonner les règles de facturation de CATALINA pour les ajouts d'imprimantes","La prestation Catalina comprend :\nLa configuration des imprimantes et la mise à jour du système\nLe suivi et la maintenance de la caisse\nLe câblage et les éventuels supports nécessaires sont de la responsabilité et à la charge du magasin\nPour l'ajout d'une caisse pas de facturation supplémentaire\nPour le mode Mode Projet à faire valider"]
["28/08 SC: PR nous informe de l'évolution sur le dossier \"TPV CAM\". PR pousse l'info à toutes les régions","Transmis Mail de Patrick 28/08"]
["28/08 SC: Demande au GIE de trouver une méthode pour informer systématiquement les régions sur les nouveaux projets ou les évolutions.","Points abordés en plénière le 22/11 avec le GIE"]
["28/08 SC: Régions en attente de l'organigramme et des missions de chaque entité dans la nouvelle organisation du GIE","transmis en interne le 31/08"]
["10/09 SC: Mettre la date de commande de la ligne @rmonie dans le phasing et déposer le bon de commande sur le DRIVE","Demande faite / Pas réalisée"]
["17/09 SC: suite à échange avec F. Fourcadier le 13/09 sur les règles GIE de reprise matériel: pas de reprise (motifs: manque de sécurité, pas de master disponible pour modèles non référencés, difficile d'autiser à la carte). ","Revenir vers le GIE dans le cas d'un nombre conséquent de PC d'un modèle référencé de moins d'un an"]
["18/09 SC: demander au GIE de préciser les règles de conservation des données dans le cas d'une démission. Envoi de données à l'Associé sur une clé USB après démontage du serveur. Pas de conservation des données au GIE? Process pour l'exploitation de ces données plus tard, contôle fiscal par ex?","Une extraction des données MONA et ULIS seront faites sur supports externes (clé USB et DVD) qui vous seront expédiés par courrier.\nEn cas de contrôle fiscal, le magasin doit revenir vers le GIE pour que le  GIE réalise les extractions demandées avec ses données. Ce sera au  magasin de fournir au GIE les informations (via la clé USB qu'il aura gardée). Cette prestation sera certainement facturable.  Si besoin, votre contact est INFO U - 04.67.16.14.14"]
["2/10: faire un retour à SPI sur une mesure \"temps\" du contrôle de l'installation BO (accès, vidage PDA, impressions...)"]
["12/10: Rappel de la règle: Quand projet Magasin passer en \"Mode Projet\" \n","Un projet PDV est géré en mode projet (donc en lien avec la coordo GIE) dès qu'un chargé de projet Coordo OPDV est sollicité pour le projet\"\nCependant, laissé à l'appréciation de la Coordo GIE si peu d'actions dans le projet"]
["Comment répartir le matériel à répartir ?","Info lors du Bilan de Narbonne\n16/10 PR: stockage sur palette de matériel BO/FO retirés: 1 palette avec SWITCHes+Pare-feu+matériel FO (retour chez PROSERVIA) + 1 palette avec serveur USB (retour au GIE)\n"]
[null,"11/06 Règles interco:"]
[null,"- Demande ouverture des routes entre les magasins souhaité entre un magasin et le serveur en biberonnage à la commande de la ligne @ si précisé dans le deviseur @"]
[null,"- Création des liens RDP, comptes JUNOS et PROXY à la commande du matériel si précisé dans la FP (Prépa Mat)"]
[null,"- demande modification de route auprès d'ORANGE pour JUNOS vers le serveur sur site au retrait du serveur de biberonnage. Pas d'action sur JUNOS côté magasin"]
[null,"- modification des accès au serveur sur les postes du magasin pour pinter sur le serveur sur site - Quelle action sur les postes du magasin distant?"]
[null,"Le but est que les accès soient opérationnels dès l'installation du serveur et BO sur site"]
[]
[null,"nouvelle règle: les interco BO et FO seront systématiquement demandées lors d'une demande d'interco"]

{"sheet":"Liste","index":4,"n_rows":19,"n_cols":12,"rows_kept":19,"hidden":true}
[null,"Statut",null,"Phase",null,"Acteur",null,"Affiliation",null,"Compte",null,"Matériel"]
[null,"A Faire",null," @rmonie",null,"AC",null,"DOM",null,"Accueil",null,"IMP Evolis"]
[null,"En cours",null,"Commandes",null,"Assistance Concepts & projets PDV",null,"U Enseigne",null,"Associé",null,"HP M404dn"]
[null,"Fait",null,"Compte",null,"Coordo Etude\nOutils PDV",null,"UPF",null,"Bazar",null,"M428fdn Multifonctions"]
[null,"Non concerné",null,"Formation",null,"Coordo Outils PDV",null,"UPSO",null,"Boucherie",null,"PC Prodesk 400 Mini G4 Std HP"]
[{"$nulls":3},"Initialisation Projet",null,"Coordo Outils PDV \nCP Outils PDV",{"$nulls":3},"Coffre",null,"Portable Probook 650 G5 (15.6’’)"]
[{"$nulls":3},"Installation",null,"CP Dev",{"$nulls":3},"Compta",null,"Ricoh IMC3000A"]
[{"$nulls":3},"Matériel",null,"CP Outils PDV",{"$nulls":3},"CoursesU",null,"Ricoh MPC307"]
[{"$nulls":3},"Materiel/Prestataires",null,"Equipe Ralliement",{"$nulls":3},"Direction",null,"Sato"]
[{"$nulls":3},"Ouverture",null,"HOTLINE OPDV",{"$nulls":3},"DriveU"]
[{"$nulls":3},"Préparation Ouverture",null,"IRIS",{"$nulls":3},"Gestion commerciale"]
[{"$nulls":3},"Préparation Serveur",null,"IRIS_PROJET",{"$nulls":3},"LocationU"]
[{"$nulls":3},"Prestation",null,"MKG CLTS"]
[{"$nulls":5},"MONITORAT METIER"]
[{"$nulls":5},"MONITORAT OPDV"]
[{"$nulls":5},"ORANGE"]
[{"$nulls":5},"PARRAIN"]
[{"$nulls":5},"PDV"]
[{"$nulls":5},"PRESTATAIRE"]

{"sheet":"Base_date","index":5,"n_rows":31,"n_cols":2,"rows_kept":31,"hidden":true}
["Janvier",2019]
["Février",2020]
["Mars",2021]
["Avril",2022]
["Mai",2023]
["Juin",2024]
["Juillet",2025]
["Août",2026]
["Septembre",2027]
["Octobre",2028]
["Novembre",2029]
["Décembre",2030]
[null,2031]
[null,2032]
[null,2033]
[null,2034]
[null,2035]
[null,2036]
[null,2037]
[null,2038]
[null,2039]
[null,2040]
[null,2041]
[null,2042]
[null,2043]
[null,2044]
[null,2045]
[null,2046]
[null,2047]
[null,2048]
[null,2049]

{"sheet":"Base","index":6,"n_rows":410,"n_cols":42,"rows_kept":410,"hidden":true}
["CCA","CCU","VILLE","Date\nouverture","FO","uLIS","Passerelle","Masque","Trig.","Enseigne","Date","SSID/Login","PSW/Clé de Sécurité","MAJ 06/04/18","UPF","UPSO","UENSEIGNE",{"$nulls":8},87,"10.103.",3.254,"255.255.255.0"]
[51123,91123,"ABAZIA (UPF)",null,"---","10.102.224.204","10.102.227.254","255.255.252.0","ABA","Utile",{"$nulls":4},{"$f":"COUNTIF(C2:C527,\"*UPF*\")","v":133},{"$f":"COUNTIF(C2:C527,\"*UPSO*\")","v":13},{"$f":"R2-(O2+P2)","v":263},{"$f":"COUNTIF(C2:C527,\"*\")","v":409},{"$f":"SUM(O2:Q2)","v":409}]
[50554,90503,"AGAY",null,"10.162.229.85","10.161.229.204","10.161.229.254","255.255.255.0","SRA","U Express"]
[50434,90434,"AGDE",null,"10.162.11.85","10.110.68.204","10.110.71.254","255.255.252.0","AGH","Hyper U",{"$nulls":7},"255.255.255.0","255.255.255.0"]
[55468,95468,"AGEN (UPSO)",null,"10.163.235.85","10.100.236.204","10.100.239.254","255.255.252.0","AGE","U Express",null,"W5AGHV1S4AG","HUAGDEDR50434",{"$nulls":5},"255.255.255.0"]
[50184,90184,"AIGUES MORTES",null,"10.162.140.85","10.109.224.204","10.109.227.254","255.255.252.0","AIG","Super U"]
[50426,90426,"AIMARGUES",null,"10.162.7.85","10.110.56.204","10.110.59.254","255.255.252.0","AIM","Super U"]
[55209,95209,"ANGRESSE","2021-03-01",{"$nulls":5},"Super U"]
[50453,90453,"AIX EN PROVENCE",null,"10.162.97.85","10.110.92.204","10.110.95.254","255.255.252.0","AIX","Super U",null,"Admin","SU-Aimargues*30"]
[51276,90895,"AJACCIO (UPF)",null,"---","10.103.40.204","10.103.43.254","255.255.252.0","AJC","Utile",{"$nulls":31},"255.255.255.0"]
[50897,90897,"ALBI  (UPF)",null,"---","10.103.52.204"," 10.103.55.254","255.255.252.0","ABL","Utile","2018-12-05"]
[50344,90344,"ALES Bilina",null,"10.162.67.85","10.161.67.204","10.161.67.253","255.255.255.0","ALB","Super U"]
[50232,90232,"ALES Rocade Sud HYPER",null,"10.162.47.85","10.103.160.204","10.103.163.254","255.255.252.0","ALR","Hyper U",null,"w5alrv1s3g","HUAles50232"]
[50355,90355,"ALES Salindres",null,"10.162.69.85","10.110.24.204","10.110.27.254","255.255.252.0","ALS","Super U",null,"W5ALSV1S4a","SUAlesSal50355",{"$f":"\"SSID : \"&L15&\"   /  \"&\" CLE : \"&M15","v":"SSID : W5ALA1S4ag   /   CLE : HUAlissas50189"}]
[50189,90189,"ALISSAS PAR PRIVAS",null,"10.162.38.85","10.103.152.204","10.103.155.254","255.255.252.0","ALA","Super U",null,"W5ALA1S4ag","HUAlissas50189"]
[50698,90698,"ALTHEN DES PALUDS (UPF)",null,"10.163.45.85","10.101.60.204","10.101.63.254","255.255.252.0","ALT","U Express"]
[55119,95119,"AMBARES",null,"10.162.121.85","10.103.208.204","10.103.211.254","255.255.252.0","AMB","U Express",null,"W5AMB1S4ag","UEAMBARES5119"]
[50381,90381,"ANDUZE",null,"10.162.72.85","10.110.36.204","10.110.39.254","255.255.252.0","AND","Super U",{"$nulls":4},"MEC_IP_Faite:",{"$f":"COUNTIFS(F2:F410,\">10.100.*\", F2:F410,\"<10.120.*\")","v":341}]
[50475,90475,"ANNONAY",null,"10.162.116.85","10.110.140.204","10.110.143.254","255.255.252.0","ANY","Super U",null,"w5annv1s2g","SUannonay50475",null,"Reste à faire",{"$f":"COUNTIFS(F2:F410,\">10.160.*\",F2:F410,\"<10.170.*\")","v":63}]
[50592,90592,"ANTIBES",null,"10.163.103.0","10.100.252.204","10.100.255.254","255.255.252.0","ATB","Super U",{"$nulls":5},{"$f":"COUNTIF(J2:J410,\"Utile\")","v":73}]
[50593,90593,"ANTIBES DRIVE",null,"10.163.104.0","10.101.112.204","10.101.115.254","255.255.252.0","ATD","U Express","2018-11-14",{"$nulls":3},"Total sans UPF",{"$f":"P18-P20","v":268}]
[56246,96246,"ARGENTAT",null,"10.162.152.85","10.111.156.204","10.111.159.254","255.255.252.0","ARG","Super U",null,"W5ARCV1S4ag","UEAurilla55196",null,null,{"$f":"P19-P20","v":-10}]
[51139,90718,"AUBAGNE (UPF)",null,"10.165.46.85","10.165.46.204","10.165.46.254","255.255.255.0","AUB","Utile"]
[50726,90726,"AUBENAS",null,"10.163.2.85","10.165.2.0","10.165.2.254","255.255.255.0","ABE","U Express"]
[55196,95196,"AURILLAC (UPSO)",null,"10.162.184.85","10.100.168.204","10.100.168.254","255.255.252.0",null,"U Express","2018-10-11"]
[55465,95465,"AUTERIVE",null,"10.163.127.85","10.165.127.0","10.165.127.254","255.255.255.0","ATV","U Express"]
[50619,90619,"AVIGNON (UPF)",null,"10.163.47.85","10.165.47.0","10.165.47.254","255.255.255.0","AVG","U Express"]
[50452,90452,"BANDOL",null,"10.162.96.85","10.110.88.204","10.110.91.254","255.255.252.0","BAN","Super U"]
[51288,90886,"BANON (UPF)",null,"---","10.103.24.204","10.103.27.254","255.255.252.0","BNN","Utile",null,"w5bahv1s3g","HUBastia50264"]
[55145,95145,"BASSENS",null,"10.162.221.85","10.111.8.204","10.111.11.254","255.255.252.0","BAS","Super U"]
[51314,91314,"BASTIA (UPF)","2020-04-09","10.163.136.0","10.109.76.204","10.109.79.254","255.255.252.0","BTA","U Express"]
[55467,95467,"BAYONNE  (UPSO)",null,"10.100.224.85","10.100.224.204","10.100.227.254","255.255.252.0","BYE","U Express"]
[55167,95167,"BAZAS",null,"10.162.247.85","10.161.247.204","10.161.247.254","255.255.255.0","BAZ","Super U",null,"W5BEA1S4ag","SuBeaulieu50521"]
[50620,90620,"BEAUCAIRE  (UPF)",null,"10.163.48.85","10.101.52.204","10.101.55.254","255.255.252.0","BCR","U Express"]
[50521,90465,"BEAULIEU SUR MER",null,"10.162.107.85","10.100.80.204","10.100.83.254","255.255.252.0","BEA","Super U"]
[50637,90637,"BEAUMES DE VENISE  (UPF)",null,"10.163.4.85","10.101.96.204","10.101.99.254","255.255.252.0","BDV","U Express"]
[50464,90464,"BEAUMONT LES VALENCE",null,"10.162.106.85","10.110.120.204","10.110.123.254","255.255.252.0","BEU","Super U"]
[59838,99838,"BEAUSEJOUR",null,"10.163.112.85","10.103.4.204","10.103.7.254","255.255.252.0","SME","U Express"]
[51243,91243,"BEAUVOISIN (UPF)",null,"10.162.188.85","10.101.216.204","10.101.219.254","255.255.252.0",null,"U Express"]
[51312,91312,"BEDARRIDES (UPF)",null,"---","10.109.92.0","10.109.95","255.255.252.0","BDR","Utile"]
[55153,95153,"BELBERAUD",null,"10.162.216.85","10.111.28.204","10.111.31.254","255.255.252.0","BLB","Super U",null,"W5BNJV1S4a","SUBenejac55173"]
[55273,95273,"BELIN BELIET",null,"10.162.128.85","10.161.128.204","10.161.128.254","255.255.255.0","BEL","Super U"]
[55173,95173,"BENEJACQ",null,"10.163.204.85","10.111.60.204","10.111.63.254","255.255.252.0","BNJ","Super U","2019-05-03"]
[55366,95366,"BESSIERES",null,"10.162.133.85","10.103.228.204","10.103.231.254","255.255.252.0","BES","Super U"]
[50913,90913,"BEZIERS (UPF)",null,"---","10.109.160.204","10.109.163.253","255.255.252.0","BZR","Utile"]
[50556,90556,"BIGUGLIA",null,"10.162.98.85","10.100.112.204","10.100.115.254","255.255.252.0","BGA","Super U"]
[50646,90646,"BIGUGLIA  (UPF)",null,"10.165.5.85","10.165.5.204","10.165.5.254","255.255.255.0","BGG","Utile"]
[56992,96992,"BISCARROSSE",null,"10.162.172.85","10.111.212.204","10.111.215.254","255.255.252.0","BIS","Super U"]
[50436,90436,"BLAYE LES MINES",null,"10.162.87.85","10.110.72.204","10.110.75.254","255.255.252.0","BLA","Super U","2019-05-03"]
[50547,90499,"BOMPAS",null,"10.162.214.85","10.161.214.204","10.161.214.254","255.255.255.0","BOM","Super U"]
[51300,91300,"BOMPAS (UPF)",null,"---","10.103.240.0","10.103.143.254","255.255.252.0","BPS","Utile"]
[50863,90863,"BONIFACIO (UPF)",null,"---","10.109.48.204","10.109.51.254","255.255.252.0","BOO","Utile"]
[50808,90808,"BONNIEUX (UPF)",null,"---","10.103.104.204","10.103.107.254","255.255.252.0","BNX","Utile"]
[55469,95469,"BORDEAUX BELCIER (DELACROIX) (UPSO)",null,"10.162.183.85","10.100.44.204","10.100.47.254","255.255.252.0","BRD","U Express"]
[55151,95151,"BORDEAUX CAPUCINS",null,"10.162.197.85","10.111.24.204","10.111.27.254","255.255.252.0","BCA","U Express"]
[55208,95208,"BORDEAUX NANSOUTY","2020-03-31","10.163.135.85","10.109.80.204","10.109.83.254","255.255.252.0","BCS","U Express"]
[55461,95461,"BORDEAUX STE CATHERINE (UPSO)",null,"10.163.150.85","10.100.228.204","10.100.231.254","255.255.252.0","BSC","U Express",null,"W5BBLV1S4AG","suBBAir50543"]
[50626,90626,"BORGO (UPF)",null,"---","10.101.204.204","10.101.207.254","255.255.252.0","BRG","U Express"]
[50543,90543,"BOUC BEL AIR",null,"10.162.162.85","10.100.8.204","10.100.11.254","255.255.252.0","BBL","Super U"]
[50618,90618,"BOUC BEL AIR (UPF)",null,"---","10.101.136.204","10.101.139.254","255.255.252.0","BBA","U Express"]
[55202,95202,"BRAX",null,"10.163.120.85","10.103.56.204","10.103.59.254","255.255.252.0","BRX","U Express"]
[55290,95290,"BRUGUIERES",null,"10.162.131.85","10.111.92.204","10.111.95.254","255.255.252.0","BRU","Super U"]
[50624,90624,"BUIS LES BARONNIES (UPF)",null,"10.163.51.85","10.101.108.204","10.101.111.254","255.255.252.0","BSB","U Express"]
["---","---","BUIS LES BARONNIES STATION (UPF)",null,"---","10.103.32.0","10.103.35.254","255.255.252.0",null,"Station"]
[51124,91124,"CADEROUSSE (UPF)",null,"---","10.103.252.0","10.103.255.254","255.255.252.0","CDE","Utile"]
[51113,91113,"CADOLIVE (UPF)",null,"---","10.102.236.204","10.102.239.254","255.255.252.0","CDO","Utile","2018-02-07"]
[50144,90144,"CALVI",null,"10.162.28.85","10.103.144.204","10.103.147.254","255.255.252.0","CAL","Super U",null,"W5CAM1S4ag","SUCamblanes5808"]
["50144S","90144S","CALVI Station déportée",null,null,"10.109.44.204","10.109.47.254","255.255.252.0"]
[51262,91262,"CALVISSON (UPF)",null,"10.162.251.85","10.101.224.204","10.101.227.254","255.255.252.0","CVS","U Express"]
[55808,95808,"CAMBLANES",null,"10.162.146.85","10.161.146.204","10.161.146.254","255.255.255.0","CAM","Super U"]
[50621,90621,"CANNES CENTER DISTRIB JUAS (UPF)",null,"10.163.52.85","10.101.188.204","10.101.191.254","255.255.252.0","CPJ","U Express"]
[50733,90733,"CANNES LE CERF (UPF)",null,"---","10.165.17.204","10.165.17.254","255.255.255.0","CAX","Utile"]
[50561,90561,"CARPENTRAS",null,"10.162.187.85","10.100.188.204","10.100.191.254","255.255.252.0","CAP","Super U"]
[51117,91117,"CARPENTRAS (UPF)",null,"10.101.144.85","10.101.144.204","10.101.147.254","255.255.252.0","CPR","U Express","2018-01-18"]
[50167,90167,"CASSIS",null,"10.162.32.85","10.161.32.204","10.161.32.254","255.255.255.0","CAS","U Express"]
[51256,91818,"CASSIS  (UPF)",null,"---","10.102.168.204","10.102.171.254","255.255.252.0",null,"Utile",null,"w5catv1s3ag","SUcastelnau50429"]
[55471,95471,"CASTELGINEST  (UPSO)",null,"10.162.235.85","10.100.52.204","10.100.55.254","255.255.252.0","CST","U Express",null,"W5CAR1S4ag","SUCastres50065"]
[50429,90429,"CASTELNAU LE LEZ",null,"10.162.2.85","10.110.60.204","10.110.63.254","255.255.252.0","CAT","Super U"]
["---","---","CASTELNAU-LE-LEZ Dive déporté",null,"---","10.109.96.0","10.109.99.254","255.255.252.0","CLD","Drive"]
[51305,91305,"CASTELNAUDARY (UPF)",null,"---","10.109.136.0","10.109.139.254","255.255.252.0","CNY","Utile"]
[50065,90065,"CASTRES",null,"10.162.22.85","10.103.132.204","10.103.135.254","255.255.252.0","CAR","Super U"]
[51119,91119,"CAUMONT SUR DURANCE (UPF)",null,"10.163.77.85","10.101.84.204","10.101.87.254","255.255.252.0","CAU","U Express"]
[55146,95146,"CAUSSADE",null,"10.162.238.85","10.103.116.204","10.103.119.254","255.255.252.0","COS","Super U",null,"W5CAGV1S4ag","SUcavign55373"]
[50587,90425,"CAVAILLON",null,"10.162.82.8","10.161.82.204","10.161.82.254","255.255.255.0","CAV","Super U"]
[55373,95373,"CAVIGNAC",null,"10.162.134.85","10.111.96.204","10.111.96.254","255.255.252.0","CAG","Super U"]
[50753,90753,"CERESTE",null,"---","10.102.16.204","10.102.19.0","255.255.252.0","CER","Utile","2019-05-15"]
[56245,96245,"CESTAS",null,"10.162.151.85","10.111.152.204","10.111.155.254","255.255.252.0","CES","Super U"]
[51302,90789,"CHAMP SUR DRAC (UPF)",null,"---","10.109.152.204","10.109.155.254","255.255.252.0","CSD","Utile"]
[50640,90640,"CHARBONNIERES LES BAINS  (UPF)",null,"---","10.165.7.204","10.165.7.254","255.255.255.0","CLB","Utile"]
[50653,90653,"CHATEAUNEUF DE GALAURE (UPF)",null,"10.163.8.85","10.101.128.204","10.101.131.254","255.255.252.0","CDG","U Express"]
[51265,91265,"CHATEAUNEUF DU PAPE (UPF)",null,"---","10.102.184.204","10.102.187.254","255.255.252.0","CDP","Utile"]
[51133,91133,"CHATEAUNEUF DU RHONE (UPF)",null,"10.163.83.85","10.101.0.204","10.101.3.254","255.255.252.0","CDR","U Express"]
[51168,91168,"CHATEAUNEUF LES MARTIGUES (UPF)",null,"---","10.101.36.204","10.101.39.254","255.255.252.0","CMA","U Express"]
[50076,90076,"CHATEAURENARD",null,"10.163.83.85","10.109.196.204","10.109.199.254","255.255.252.0","CHA","Super U"]
[51128,91128,"CHATUZANGE LE GOUBET (UPF)",null,"10.163.79.85","10.101.156.204","10.101.159.254","255.255.252.0","CGO","U Express",null,"W5CLAV1S4AG","suClaouey5382"]
[59230,99230,"CILAOS",null,"10.163.79.85","10.100.20.204","10.100.23.254","255.255.252.0","CIL","U Express"]
[55382,95382,"CLAOUEY LEGE CAP FERRET",null,"10.163.79.85","10.100.160.204","10.100.163.254","255.255.252.0","CLA","Super U"]
[50166,90166,"CLERMONT L HERAULT",null,"10.162.31.85","10.109.208.204","10.109.211.254","255.255.252.0","CLE","Hyper U"]
[50677,90677,"COLLONGES SOUS SALEVE (UPF)",null,"10.163.9.85","10.101.184.204","10.101.187.254","255.255.252.0","CSS","U Express"]
[55125,96995,"COLOMIERS",null,"10.162.125.85","10.103.216.204","10.103.219.254","255.255.252.0","COL","Super U"]
[50670,90670,"CORTE  (UPF)",null,"10.163.10.85","10.101.208.204","10.101.211.254","255.255.252.0","COR","U Express"]
[50005,90005,"COURSAN",null,"10.162.13.85","10.109.164.204","10.109.167.254","255.255.252.0","COU","Super U"]
[50643,90643,"COURTHEZON  (UPF)",null,"10.163.54.85","10.101.100.204","10.101.103.254","255.255.252.0","CRT","U Express"]
[50757,90757,"CREPOL  (UPF)",null,"---","10.103.48.204"," 10.103.51.254","255.255.252.0","CPL","Utile"]
[50628,90628,"DIE  (UPF)",null,"10.163.55.85","10.101.72.204","10.101.75.254","255.255.252.0","DIC","U Express"]
[50017,90017,"DIEULEFIT",null,"10.162.16.85","10.109.176.204","10.109.179.254","255.255.252.0","DIE","Super U",null,"w5eauv1s3g","SuEaunes55133"]
[50518,90518,"DONZERE",null,"10.162.239.85","10.110.188.204","10.110.191.254","255.255.252.0","DZR","Super U"]
[50727,90727,"DOMMARTIN (UPF)","2020-04-01",null,"10.109.64.0","10.109.67.254","255.255.252.0","DON","Utile"]
[55133,95133,"EAUNES",null,"10.162.210.85","10.110.248.204","10.110.251.254","255.255.252.0","EAU","Super U",null,"W5EMB1S4ag","SUEmbrun50282"]
[50303,90231,"EGAT",null,"10.162.46.85","10.161.46.204","10.161.46.254","255.255.255.0","EGA","Super U"]
[50282,90282,"EMBRUN ",null,"10.162.63.85","10.100.128.204","10.100.131.254","255.255.252.0","EMB","Super U"]
[50530,90530,"ENTRAIGUES - UPF",null,"10.165.1.85","10.165.1.204","10.165.1.254","255.255.252.0","MIS","COOP"]
[51316,90676,"ENTRAIGUES SUR SORGUES (UPF)",{"$nulls":6},"Utile"]
[55463,95463,"ENTRAYGUES-SUR-TRUYERE (UPSO)",null,"10.163.152.85","10.111.112.204","10.111.115.254","255.255.255.0","ETY","U Express"]
[59221,99221,"ENTRE-DEUX LA REUNION",null,"10.162.118.85","10.100.64.204","10.100.67.254","255.255.252.0","END","U Express",null,"w5espv1s3g","suespalion50504"]
[59698,99698,"EPERON",null,"---","10.103.80.0","10.103.83.254","255.255.252.0","EPR","Super U"]
[50504,90504,"ESPALION",null,"10.162.230.85","10.110.172.204","10.110.175.254","255.255.252.0","ESP","Super U"]
[59200,99200,"ETANG SALE  LA REUNION",null,"10.162.194.85","10.161.194.204","10.161.194.254","255.255.255.0","ETA","Super U",null,"W5EYS1S4ag","SUEysines5164"]
[50600,90600,"EYRAGUES (UPF)",null,"10.163.57.85","10.101.92.204","10.101.95.254","255.255.252.0","ERG","U Express"]
[55164,95524,"EYSINES",null,"10.162.137.85","10.111.116.204","10.111.119.254","255.255.252.0","EYS","Super U"]
[55626,95626,"FARGUES ST HILAIRE",null,"10.162.139.85","10.103.236.204","10.103.239.254","255.255.252.0","FAR","Super U"]
[50404,90404,"FAYENCE",null,"10.162.77.85","10.110.44.204","10.110.47.254","255.255.252.0","FAY","Super U",null,"W5FLO1S4ag","SuFLOURENS55162"]
[50535,90535,"FLASSANS SUR ISSOLE",null,"10.162.112.85","10.110.212.204","10.110.215.254","255.255.252.0","FSI","Super U"]
[55162,95162,"FLOURENS",null,"10.162.5.85","10.111.40.204","10.111.43.254","255.255.252.0","FLO","Super U"]
[50507,90400,"FOLELLI",null,"---","10.161.73.204","10.161.73.254","255.255.255.0","FOL","Hyper U"]
[55193,96953,"FONBEAUZARD",null,"10.162.157.85","10.161.157.204","10.161.157.254","255.255.255.0","FON","Super U"]
[59676,99676,"FOUR A CHAUX",null,"---","10.103.8.204","10.103.11.254","255.255.252.0","SPE","U Express"]
[51289,91289,"FRANGY (UPF)",null,"---","10.102.132.204","10.102.135.254","255.255.252.0",null,"Utile"]
[55207,95175,"GABARRET",null,"10.163.195.85","10.165.195.204","10.165.195.254","255.255.255.0","GAB","U Express"]
[55190,95190,"GAGNAC SUR GARONNE",null,"10.162.246.85","10.100.72.204","10.100.75.254","255.255.252.0","CSG","Super U"]
[55131,95762,"GALGON",null,"10.162.141.85","10.161.141.204","10.161.141.254","255.255.255.0","GAL","Super U"]
[51269,91269,"GALLARGUES LE MONTUEUX (UPF)",null,"10.102.192.85","10.102.192.204","10.102.195.254","255.255.252.0","GLM","Utile"]
[55126,95126,"GAN",null,"10.162.64.85","10.110.232.204","10.110.235.204","255.255.252.0","GAN","Super U",null,"w5gouv1s4ag","sugourdan55773"]
[50122,90122,"GANGES",null,"10.162.26.85","10.103.136.204","10.103.139.254","255.255.252.0","GAG","Super U"]
[50517,90517,"GOLFE-JUAN",null,"10.163.32.85"]
[55773,95773,"GOURDAN POLIGNAN",null,"10.162.145.85","10.103.212.204","10.103.215.254","255.255.252.0","GOU","Super U"]
[51271,91271,"GRANS (UPF)",null,"10.162.252.85","10.101.228.204","10.101.231.254","255.255.252.0","GRS","U Express",null,"W5GRES4ag","SUGrenade55280"]
[50615,90615,"GRAVESON (UPF)",null,"10.163.59.85","10.101.200.204","10.101.203.254","255.255.252.0","GVS","U Express"]
[55280,95280,"GRENADE SUR GARONNE",null,"10.162.129.85","10.111.84.204","10.111.87.254","255.255.252.0","GRE","Super U"]
[50667,90667,"GRENOBLE (UPF)",null,"10.163.16.85","10.101.180.204","10.101.183.254","255.255.252.0","GRV","U Express"]
[51268,91268,"GRENOBLE HOCHE (UPF)",null,null,"10.131.36.204","10.131.39.254","255.255.252.0",null,"Utile"]
[51275,91275,"GRENOBLE VIALLET (UPF)",null,"---","10.102.220.204","10.102.223.254","255.255.252.0","GNV","Utile"]
[55258,95258,"GUJAN MESTRAS",null,"10.162.126.85","10.111.76.204","10.111.79.254","255.255.252.0","GUJ","Hyper U"]
[50976,90976,"HOMPS (UPF)","2020-03-03",null,"10.109.68.0","10.109.71.254","255.255.252.0","HMS","Utile"]
[55166,95166,"IDRON",null,"10.162.241.85","10.111.48.203","10.111.51.254","255.255.252.0","IDR","Super U"]
[50585,90585,"ILLE SUR TET",null,"10.162.223.85","10.100.140.204","10.100.143.254","255.255.252.0","IST","Super U"]
[50596,90596,"ISTRES",null,"10.163.116.85","10.103.20.204","10.103.23.254","255.255.252.0","ITS","Super U"]
[51137,91137,"LA BEGUDE-DE-MAZENC (UPF)",null,"---","10.102.116.204","10.102.119.254","255.255.252.0",null,"Utile"]
[59233,99233,"LA CHALOUPE ST LEU",null,"10.162.130.85","10.100.116.204","10.100.119.254","255.255.252.0","LCE","U Express"]
[59210,99210,"LA CHATOIRE",null,"10.163.108.85","10.101.244.204","10.101.247.254","255.255.252.0","LTN","Hyper U"]
[50457,90457,"LA COLLE SUR LOUP",null,"10.162.100.85","10.110.100.204","10.110.103.254","255.255.252.0","LCO","U Express"]
[51223,91277,"LA CROIX VALMER (UPF)",null,"---","10.102.228.204","10.102.231.254","255.255.252.0","LCV","Utile"]
[50347,90347,"LA FARE LES OLIVIERS",null,"10.162.12.85","10.161.12.204","10.161.12.254","255.255.255.0","LFA","Super U"]
[50008,90008,"LA GRANDE MOTTE",null,"10.162.4.85","10.109.168.204","10.109.171.254","255.255.252.0","LGM","Super U",null,"W5TPVv1S4a","SUtrinite50576"]
[59217,99217,"LA RIVIERE LA REUNIO",null,"---","10.100.12.204","10.100.15.254","255.255.252.0","RVI","Super U"]
[55472,95472,"LA ROQUEBROU (UPSO)",null,"10.162.209.85","10.100.84.204","10.100.87.254","255.255.252.0","LRB","U Express"]
[50576,90576,"LA TRINITE PORTO VECCHIO",null,"10.162.186.85","10.100.92.204","10.100.95.254","255.255.252.0","TPV","Super U",null,"W5LNOV1S4AG","SUlacanau5165"]
[50803,90803,"LA VALETTE-DU-VAR (UPF)",null,null,"10.109.56.0","10.109.59.254","255.255.252.0","LVV","Utile"]
[55624,95624,"LABASTIDE ST PIERRE",null,"10.162.138.85","10.111.120.204","10.111.123.254","255.255.252.0","LBA","Super U",null,"W5LAO1S4ag","UeLacaOce55191"]
[55165,95165,"LACANAU",null,"10.162.243.85","10.100.164.204","10.100.167.254","255.255.252.0","LNO","Super U"]
[55191,95191,"LACANAU OCEAN",null,"10.162.90.85","10.100.96.204","10.100.99.254","255.255.252.0","LAO","U Express"]
[50320,90320,"LAMASTRE",null,"10.162.66.85","10.103.176.204","10.103.179.254","255.255.252.0","LAM","Super U"]
[55178,95178,"LANGON",null,"10.162.207.85","10.100.48.204","10.100.51.254","255.255.252.0","LGO","Super U","2018-07-10"]
[50883,90883,"LASALLE (UPF)",null,"---","10.109.88.0","10.109.91.254","255.255.252.0","LSL","Utile"]
[51284,91284,"LATTES (UPF)",null,"---","10.102.248.204","10.102.251.254","255.255.252.0","LTS","Utile",null,"W5LAA1S4ag","SULavardaC5130"]
[50432,90432,"LAUDUN",null,"10.162.85.85","10.110.64.204","10.110.67.254","255.255.252.0","LAU","U Express"]
[55130,95130,"LAVARDAC",null,"10.162.159.85","10.110.244.204","10.110.247.254","255.255.252.0","LAA","Super U"]
[55152,95152,"LAVAUR",null,"10.162.220.85","10.103.120.204","10.103.123.254","255.255.252.0","LAV","Super U"]
[50403,90403,"LAVELANET",null,"10.162.76.85","10.110.40.204","10.110.43.254","255.255.252.0","LAE","Super U"]
[50492,90492,"LE BARCARES",null,"10.162.104.85","10.110.148.204","10.110.151.254","255.255.252.0","LBC","Super U"]
[55765,95765,"LE BARP",null,"10.162.142.85","10.161.142.204","10.161.142.254","255.255.255.0","LBP","Super U","2019-05-09"]
[50063,90063,"LE CHEYLARD",null,"10.162.21.85","10.109.192.204","10.109.195.254","255.255.252.0","LCH","Super U",{"$nulls":3},"à verifier avec borne autonome"]
[50485,90485,"LE GRAU DU ROI Espiguette ",null,"10.162.189.85","10.103.112.204","10.103.115.254","255.255.252.0","LGE","U Express"]
[50053,90053,"LE GRAU DU ROI Port de Pêche",null,"10.162.1.85","10.109.188.204","10.109.191.254","255.255.252.0","LGP","Super U"]
[50052,90052,"LE GRAU DU ROI Port Royal",null,"10.109.184.85","10.109.184.204","10.109.187.254","255.255.252.0","LGR","U Express"]
[51132,91132,"LE PONTET (UPF)",null,"10.163.80.85","10.101.80.204","10.101.86.254","255.255.252.0","LEP","U Express"]
[59826,99826,"LE PORT CENTRE",null,"10.163.111.85","10.103.0.204","10.103.3.254","255.255.252.0","LPT","U Express"]
[59105,99105,"LE PORT SDP",null,"10.163.192.85","10.165.192.204","10.165.192.254","255.255.255.0","SDP","U Express"]
[59106,99106,"LE PORT SOCOZ",null,"10.162.192.85","10.161.192.204","10.161.192.254","255.255.255.0","SCZ","U Express"]
[59693,99693,"LE TAMPON 14",null,"10.163.115.85","10.103.16.204","10.103.19.254","255.255.252.0","LTA","U Express"]
[56927,96927,"LE TEICH",null,"10.162.164.85","10.161.164.204","10.161.164.254","255.255.255.0","LTE","Super U"]
[50358,90358,"LE VIGAN",null,"10.162.70.85","10.110.28.204","10.110.31.254","255.255.252.0","LVI","Super U"]
[51301,91301,"LEDIGNAN (UPF)",null,"---","10.109.156.204","10.109.159.254","255.255.252.0","LDG","Utile",null,"Admin","SU-grauduroi*30"]
[55192,96989,"LEGUEVIN",null,"10.162.171.85","10.111.208.204","10.111.211.254","255.255.252.0","LEG","Super U",null,"w5leav1s3g","huLESARCS50501"]
[56951,96951,"LEOGNAN",null,"10.162.166.85","10.161.166.204","10.161.166.209","255.255.255.0","LEO","Super U"]
[50501,90501,"LES ARCS",null,"10.162.227.85","10.110.164.204","10.110.167.254","255.255.252.0","LEA","Hyper U"]
[50301,90301,"LES ARCS DRIVE SOLO",null,"10.163.128.0/24","10.103.108.204","10.103.111.254","255.255.252.0","DSL","Drive"]
[55172,95172,"LES BORDES SUR ARIZES",null,"---","10.161.30.204","10.161.30.254","255.255.255.0","BSA","U Express"]
[50859,90859,"LES MAGES (UPF)",null,"10.101.132.85","10.101.132.204","10.101.135.254","255.255.252.0","LMG","U Express"]
[50190,90190,"LES VANS",null,"10.162.39.85","10.161.39.204","10.161.39.254","255.255.255.0","LEV","Super U"]
[55189,95189,"LIBOURNE",null,"10.162.249.85","10.100.76.204","10.100.79.254","255.255.252.0","LIB","U Express",null,"W5LIJ1S4ag","SUJOURDAIN5901"]
[51236,95516,"LIMOGNE-EN-QUERCY (UPSO)",null,"---","10.102.88.204","10.102.91.254","255.255.252.0","LEQ","Utile"]
[50473,90473,"LIMOUX",null,"10.162.114.85","10.110.136.204","10.110.139.254","255.255.252.0","LIM","Super U"]
[55901,95901,"L'ISLE JOURDAIN",null,"10.162.147.85","10.111.140.204","10.111.143.204","255.255.252.0","LIJ","Super U",{"$nulls":3},"à verifier avec borne autonome"]
[50445,90445,"L'ISLE SUR SORGUES",null,"10.162.93.85","10.110.80.204","10.110.83.254","255.255.252.0","LIS","Super U",null,"Admin","SU-Lodeve*34"]
[55135,95135,"LIT ET MIXE",null,"10.162.203.85","10.111.0.204","10.111.3.254","255.255.252.0","LIT","Super U"]
[50486,90423,"LODEVE",null,"10.162.80.85","10.103.184.204","10.103.187.254","255.255.252.0","LOD","Super U"]
[55187,95285,"LUBERSAC",null,"10.162.154.85","10.161.154.204","10.161.154.254","255.255.255.0","LUB","Super U"]
[50685,90685,"LYON (UPF)",null,"10.163.19.85","10.101.172.204","10.101.175.254","255.255.252.0","LCL","U Express"]
[50664,90664,"LYON 02 (UPF)",null,"---","10.165.18.204","10.165.18.254","255.255.255.0","LRC","Utile"]
[50012,90012,"MALAUCENE",null,"10.162.14.85","10.109.172.204","10.109.175.254","255.255.252.0","MAL","U Express"]
[55201,95201,"MALEMORT",null,"---","10.100.248.204","10.100.251.254","255.255.252.0","MLM","Super U",null,"w5manv1s3g","HuManosque50440"]
[51273,91273,"MANDELIEU (UPF)",null,"---","10.102.212.204","10.102.215.254","255.255.252.0","MDU","Utile"]
[50440,90440,"MANOSQUE",null,"10.162.9.85","10.110.76.204","10.110.79.254","255.255.252.0","MAN","Hyper U",null,"w5marv1s3g","SUmarguerittes50472"]
[51313,91313,"MARAUSSAN (UPF)","2020-03-05","10.163.131.0","10.109.84.0","10.109.87.254","255.255.252.0","MRN","U Express"]
[55160,95160,"MARCIAC",null,"10.162.237.85","10.111.32.204","10.111.35.254","255.255.252.0","MCI","Super U"]
[50472,90472,"MARGUERITTES",null,"10.162.204.85","10.110.132.204","10.110.135.254","255.255.252.0","MAR","Super U"]
[50728,90728,"MARIGNANE (UPF)",null,"---","10.165.20.204","10.165.20.254","255.255.255.0","MRG","Utile"]
[55205,95205,"MARMANDE","2020-03-11","10.163.131.0","10.109.124.0","10.109.127.254","255.255.252.0","MME","Super U"]
[51135,91135,"MARSEILLE Ste Marthe (UPF)","2020-03-19","---","10.109.72.204","10.109.75.254","255.255.252.0","MSM","Utile"]
[51260,91260,"MARSEILLE BRUN (UPF)",null,"---","10.102.172.204","10.102.175.254","255.255.252.0","MBN","Utile"]
[50656,90656,"MARSEILLE Capelette (UPF)",null,"----","10.165.60.204","10.165.60.254","255.255.255.0","MDL","Utile"]
[51146,91146,"MARSEILLE Capelette 2 (UPF)",null,"----","10.101.20.204","10.101.23.254","255.255.252.0","MCE","Utile"]
[50617,90617,"MARSEILLE CHUTES LAVIE (UPF)",null,"----","10.101.164.204","10.101.167.254","255.255.252.0","MCL","U Express"]
[50174,90174,"MARSEILLE EUGENE PIERRE",null,"10.162.34.85","10.109.216.204","10.109.219.254","255.255.252.0","MAE","U Express"]
[50639,90639,"MARSEILLE Gde Rue  (UPF)",null,"10.163.62.85","10.101.168.204","10.101.171.254","255.255.252.0","MGR","U Express"]
[50451,90451,"MARSEILLE SAKAKINI",null,"10.162.95.85","10.110.84.204","10.110.87.254","255.255.252.0","MAS","Super U",null,"W5MAT1S4ag","SUMartaddei513"]
[50249,90249,"MARSEILLE ST PIERRE",null,"10.162.52.85","10.110.4.204","10.110.7.254","255.255.252.0","MAP","Super U"]
[50513,90177,"MARSEILLE TADDEI",null,"10.162.36.85","10.109.220.204","10.109.223.204","255.255.252.0","MAT","Super U",null,"W5MTO1S4ag","SU-Martres*31"]
[50738,90738,"MARSEILLE THIERS (UPF)",null,"---","10.109.116.0","10.109.119.254","255.255.252.0","MTS","Utile"]
[50506,90367,"MARSILLARGUES",null,"10.162.71.85","10.110.32.204","10.110.35.254","255.255.252.0","MAI","U Express"]
[55148,95148,"MARTRES TOLOSANE",null,"10.162.190.85","10.111.16.204","10.111.19.254","255.255.252.0","MTO","Super U",null,"w5mbcv1s3g","suMAUBEC50524"]
[55136,95136,"MASSEUBE",null,"10.162.205.85","10.111.4.204","10.111.7.254","255.255.252.0","MAU","Super U"]
[50524,90524,"MAUBEC",null,"10.110.192.85","10.110.192.204","10.110.195.254","255.255.252.0","MBC","Super U",null,"W5MAV1S4ag","SUMauvezi55769"]
[56102,96102,"MAUBOURGUET",null,"10.162.149.85","10.111.148.204","10.111.151.254","255.255.252.0","MAB","Super U"]
[55769,95769,"MAUVEZIN",null,"10.162.144.85","10.100.200.204","10.100.203.254","255.255.252.0","MAV","Super U",null,"w5medv1s3g","huMENDE50424"]
[50614,90614,"MAZAN (UPF)",null,"10.163.64.85","10.101.88.204","10.101.91.254","255.255.252.0","MZN","U Express"]
[50424,90424,"MENDE",null,"10.162.84.85","10.103.44.204","10.103.47.254","255.255.252.0","MED","Hyper U",null,"Station: 10.161.85.90"]
[50460,90460,"MENTON Centre",null,"10.162.103.85","10.161.103.204","10.161.103.254","255.255.255.0","MEC","U Express"]
[50557,90467,"MENTON Garavan",null,"10.162.109.85","10.110.124.204","10.110.127.254","255.255.252.0","MEG","U Express"]
[56360,96360,"MESSANGES",null,"10.162.158.85","10.111.172.204","10.111.175.254","255.255.252.0","MES","Super U",null,"w5mirv1s2g","1_p0$rU<7$EnM"]
[55170,96357,"MEYSSAC",null,"10.162.156.85","10.161.156.204","10.161.156.254","255.255.255.0","MEY","Super U"]
[50237,90237,"MIREPOIX",null,"10.162.48.85","10.161.48.204","10.161.48.254","255.255.255.0","MIR","Super U",null,"W5MNO1S4ag","MUMONACO50586"]
[55188,95188,"MOLIETS ET MAA",null,"10.162.236.85","10.100.16.204","10.100.19.254","255.255.252.0","MOS","U Express","2019-03-12"]
[50586,90586,"MONACO",null,"10.162.234.85","10.100.148.204","10.100.151.254","255.255.252.0","MNO","Marché U"]
[51296,91296,"MONACO (UPF)",null,"---","10.103.124.204","10.103.127.254","255.255.252.0","MNC","Utile"]
[56018,96018,"MONT DE MARSAN",null,"10.162.148.85","10.111.144.204","10.111.147.254","255.255.252.0","MOD","U Express"]
[51308,91308,"MONT LOZERE ET GOULET (UPF)",null,"---","10.109.132.0","10.109.135.254","255.255.252.0","MLG","Utile"]
[50570,90570,"MONTARNAUD",null,"10.162.206.85","10.100.176.204","10.100.179.254","255.255.252.0","MTA","Super U"]
[55456,95456,"MONTBAZENS (UPSO)",null,"10.162.196.85","10.111.100.204","10.111.103.254","255.255.252.0","MON","U Express",null,"W5MOE1S4ag","UEMcarlo50466"]
[50612,90612,"MONTBRUN LES BAINS (UPF)",null,"10.163.65.85","10.101.116.204","10.101.119.254","255.255.252.0","MLB","U Express",null,"W5MTX1S4ag","SuMonteux50577"]
[50466,90466,"MONTE-CARLO",null,"10.162.108.85","10.100.144.204","10.100.147.254","255.255.252.0","MOE","Marché U",null,"W5MPP1S4ag","SUmppmpp50588"]
[50577,90577,"MONTEUX",null,"10.162.185.85","10.100.212.204","10.100.215.254","255.255.252.0","MTX","Super U",null,"w5mtbv1s3g","SUmontrabe55163"]
[50591,90568,"MONTPELLIER PAVELET",null,"10.162.224.85","10.100.172.204","10.100.175.254","255.255.252.0","MPP","Super U"]
[55163,95163,"MONTRABE",null,"10.162.242.85","10.111.44.204","10.111.47.254","255.255.252.0","MTB","Super U"]
[56332,96332,"MORCENX",null,"10.162.153.85","10.111.160.204","10.111.160.204","255.255.252.0","MOC","Super U"]
[57503,97503,"MORLAAS",null,"10.162.177.85","10.161.177.204","10.161.177.254","255.255.255.0","MOL","U Express"]
[51306,91306,"NANS-LES-PINS (UPF)",null,"---","10.103.248.0","10.103.251.254","255.255.252.0","NLP","Utile"]
[51287,90204,"NARBONNE HORTENEUVE (UPF)",null,"---","10.161.42.204","10.161.42.254","255.255.255.0","NAR","U Express"]
[50868,90868,"NARBONNE PLAGE (UPF)",null,"---","10.109.144.0","10.109.147.254","255.255.252.0","NBN","Utile"]
[55171,96419,"NEGREPELISSE",null,"10.162.120.85","10.111.180.204","10.111.183.254","255.255.252.0","NEG","Super U"]
[50725,90725,"NICE ARMEE (UPF)",null,"10.163.24.85","10.101.196.204","10.101.199.254","255.255.252.0","NAA","U Express"]
[50575,90575,"NICE ARMEE DES ALPES",null,"---","10.100.196.204","10.100.199.254","255.255.252.0","NAL","Super U",{"$nulls":3},"mdp différent dans borne autonome"]
[50622,90622,"NICE BAQUIS (UPF)",null,"10.163.25.85","10.101.192.204","10.101.195.254","255.255.252.0","NCB","U Express"]
[50515,90515,"NICE DUNANT",null,"10.162.51.85","10.161.51.204","10.161.51.254","255.255.255.0","NIU","U Express",null,"W5NIRV1S4ag","UENicemar50490"]
[50438,90438,"NICE MADELEINE",null,"10.162.88.85","10.103.188.204","10.103.191.254","255.255.252.0","NID","Super U"]
[50490,90490,"NICE MARGUERITTE",null,"10.162.226.85","10.110.144.204","10.110.147.254","255.255.252.0","NIR","U Express"]
[50540,90540,"NICE RUE DE France",null,"10.162.75.85","10.103.100.204","10.103.103.254","255.255.252.0","NFR","U Express",null,"W5NOEV1S4AG","SuperUNoe55168"]
[50313,90313,"NIMES CIGALE",null,"10.162.65.85","10.103.172.204","10.103.175.254","255.255.252.0","NIM","U Express"]
[55168,95168,"NOE",null,"10.162.119.85","10.111.56.204","10.111.59.254","255.255.252.0","NOE","Super U"]
[55124,95124,"NONTRON",null,"10.162.124.85","10.161.124.204","10.161.124.254","255.255.255.0","NON","Super U"]
[55169,95169,"NOTRE DAME DE SANILHAC",null,"10.162.17.85","10.103.220.204","10.103.223.254","255.255.252.0","NDS","U Express"]
[50681,90681,"NOVES (UPF)",null,"10.163.67.85","10.101.64.204","10.101.67.254","255.255.252.0","NOV","U Express",null,"w5olev1s3g","SuOlemps50505"]
[50115,90115,"NYONS",null,"10.162.25.85","10.109.200.204","10.109.203.254","255.255.252.0","NYO","Super U","2018-03-26"]
[50505,90505,"OLEMPS",null,"10.162.231.85","10.110.176.204","10.110.179.254","255.255.252.0","OLE","Super U",null,"W5OTHv1S4ag","SUothoth55197"]
[50668,90668,"OLLIOULES (UPF)",null,"---","10.102.12.204","10.102.15.254","255.255.252.0","OLL","Utile"]
[50305,90305,"ONET LE CHÂTEAU","2020-03-04","10.163.129.0","10.109.128.0","10.109.131.254","255.255.252.0","ONE","Super U"]
[55197,95197,"ORTHEZ",null,"10.162.218.85","10.100.220.204","10.100.223.254","255.255.252.0","OTH","Super U",null,"w5pegv1s3g","supegomas50481"]
[51318,91318,"OYTIER-SAINT-OBLAS (UPF)","2020-07-01",null,"10.109.52.204","10.109.55.254","255.255.252.0","OSO","Utile"]
[56413,96413,"PARENTIS EN BORN",null,"10.162.160.85","10.111.176.204","10.111.179.254","255.255.252.0","PAR","Super U"]
[55158,95158,"PAU"]
[50481,90481,"PEGOMAS",null,"10.162.27.85","10.103.200.204","10.103.203.254","255.255.252.0","PEG","Super U"]
[50609,90609,"PERNES LES FONTAINES (UPF)",null,"10.163.68.85","10.165.58.204","10.165.58.254","255.255.255.0","PLF","U Express"]
[50720,90720,"PERPIGNAN (UPF)",null,"10.165.29.85","10.165.29.204","10.165.29.254","255.255.255.0","PPC","Utile"]
[51145,91145,"PERPIGNAN CLEMENCEAU (UPF)",null,"10.163.84.85","10.101.16.204","10.101.19.254","255.255.252.0","PPG","U Express",null,"W5PERV1S2G\nW5PERV1S4AG","HUpertuis50532"]
[50498,90498,"PERPIGNAN DESNOYER",null,"10.162.213.85","10.161.213.204","10.161.213.254","255.255.255.0","PED","Super U"]
[50541,90461,"PERPIGNAN ST ASSISCLE",null,"10.162.212.85","10.161.212.204","10.161.212.254","255.255.255.0","PES","U Express"]
[50532,90273,"PERTUIS",null,"10.162.61.85","10.100.4.204","10.100.7.254","255.255.252.0","PER","Hyper U"]
[50573,90573,"PERTUIS DRIVE SOLO",null,"10.162.198.85","10.100.240.204","10.100.243.254","255.255.252.0","PRD","U Express"]
[59666,99666,"PETITE-ILE",null,"10.163.109.85","10.101.248.204","10.101.251.254","255.255.252.0","SJP","U Express"]
[51274,91274,"PIANOTTOLI (UPF)",null,"---","10.102.216.204","10.102.219.254","255.255.252.0","PNT","Utile"]
[50583,90583,"PIERREFEU DU VAR",null,"10.162.222.85","10.100.136.204","10.100.139.254","255.255.252.0","PFU","Super U"]
[50574,90574,"PIGNAN",null,"10.162.202.85","10.100.184.204","10.100.187.254","255.255.252.0","PIG","Super U"]
[55179,95179,"PINEUILH",null,"10.162.58.85","10.161.58.204","10.161.58.254","255.255.255.0","PIN","Super U"]
[51115,90625,"PIOLENC (UPF)",null,"10.163.70.85","10.101.160.204","10.101.163.254","255.255.252.0","PLN","U Express"]
[59087,99807,"PITON",null,"10.163.123.0","10.103.76.204","10.103.79.254","255.255.252.0","PSL","Super U",null,"255.255.255.0",null,"255.255.255.0"]
[59876,99876,"PLAINE DES PALMISTES","2020-06-11","10.163.132.0","10.109.112.0","10.109.115.254","255.255.252.0","PDP","U Express"]
[50168,90168,"PLASCASSIER DE GRASSE",null,"---","10.103.28.204","10.103.31.254","255.255.252.0","PLG","Super U",null,"W5PODV1S4G","SUpodensac5121"]
[55195,95195,"PLEAUX",null,"10.162.20.85","10.100.124.204","10.100.127.254","255.255.252.0","PLX","U Express"]
[55121,95121,"PODENSAC",null,"10.162.123.85","10.100.56.204","10.100.59.254","255.255.252.0","POD","Super U","2018-11-15"]
[50533,90533,"POMEROLS",null,"10.162.110.85","10.110.208.204","10.110.211.254","255.255.252.0","POM","Super U"]
[50768,90768,"PONT DE L'ISERE (UPF)",null,"---","10.102.252.204","10.102.255.254","255.255.252.0","PLI","Utile"]
[50258,90258,"PONTE LECCIA",null,"10.162.55.85","10.161.55.204","10.161.55.254","255.255.255.0","PON","Super U"]
[50229,90229,"PORT LA NOUVELLE",null,"10.162.45.85","10.109.248.204","10.109.251.254","255.255.252.0","POL","Super U"]
[50015,90015,"PORT VENDRES",null,"---","10.161.15.204","10.161.15.254","255.255.255.0","POV","U Express"]
[51255,90801,"POURRIERES (UPF)",null,"10.163.100.85","10.102.160.204","10.102.163.254","255.255.252.0","PRS","Utile"]
[50200,90200,"PRADES",null,"10.162.41.85","10.103.156.204","10.103.159.254","255.255.252.0","PRA","Super U",null,"W5PUY1S4ag","SUPUYVERT50422"]
[51279,91279,"PUJAUT (UPF)",null,"---","10.102.240.204","10.102.243.254","255.255.252.0","PJT","Utile"]
[55206,95206,"PUJOLS","2020-05-13","10.163.133.0","10.109.100.0","10.109.103.254","255.255.252.0","PJS","U Express"]
[50632,90632,"PUY ST MARTIN (UPF)",null,"---","10.101.120.204","10.101.123.254","255.255.252.0","PSM","U Express"]
[50422,90422,"PUYVERT",null,"10.162.79.85","10.103.180.204","10.103.183.254","255.255.252.0","PUY","Super U"]
[50876,50876,"QUINCIEUX (UPF)",null,"---","10.102.196.204","101.102.199.254","255.255.252.0","QCX","Utile"]
[51257,91038,"RAPHELE LES ARLES (UPF)",null,"---","10.102.188.204","10.102.191.254","255.255.252.0","RLA","Utile"]
[50525,90525,"REGUSSE",null,"10.162.248.85","10.110.196.204","10.110.199.254","255.255.252.0","RGS","Super U"]
[50597,90597,"REMOLLON",null,"10.163.122.0","10.103.64.204","10.103.67.254","255.255.252.0","DRC","U Express"]
[51272,91272,"REMUZAT (UPF)",null,"---","10.102.208.204","10.102.211.254","255.255.252.0","RZT","Utile"]
[51320,91320,"RIEUPEYROUX (UPF)",null,"---","10.111.108.0","10.111.111.254","255.255.252.0","RIU","Utile"]
[55464,95457,"RIGNAC (UPSO)",null,"10.162.233.85","10.111.104.0","10.111.107.254","255.255.252.0","RIG","U Express"]
[50519,90519,"ROCBARON",null,"10.162.244.85","10.103.204.204","10.103.207.254","255.255.252.0","RCB","Super U"]
[50629,90629,"ROCHEFORT DU GARD (UPF)",null,"10.163.71.85","10.101.76.204","10.101.79.254","255.255.252.0","RDG","U Express"]
[50611,90611,"ROGNONAS (UPF)",null,"10.163.72.85","10.101.4.204","10.101.7.254","255.255.252.0","RGN","U Express",{"$nulls":3},{"$f":"\"SSID : \"&L312&\"   /  \"&\" CLE : \"&M312","v":"SSID : W5ROY1S4ag   /   CLE : HURomans50477"}]
[50456,90456,"ROMANS - GAMBETTA",null,"10.162.99.85","10.110.96.204","10.110.99.254","255.255.252.0","ROS","Super U",null,"W5ROY1S4ag","HURomans50477"]
[50477,90477,"ROMANS ",null,"10.162.117.85","10.103.196.204","10.103.199.254","255.255.252.0","ROY","Hyper U"]
[50719,90719,"ROMANS (UPF)",null,"---","10.102.232.204","10.102.235.254","255.255.252.0","RNS","Utile"]
[50470,90470,"ROQUEBRUNE CAP MARTIN",null,"10.162.111.85","10.110.128.204","10.110.131.254","255.255.252.0","ROQ","U Express"]
[50527,90527,"ROUJAN",null,"10.162.57.85","10.110.200.204","10.110.203.254","255.255.252.0","ROJ","Super U"]
["-","-","ROUJAN (STATION  10.100.104.90)",null,"---","10.100.104.204","10.100.107.254","255.255.252.0","ROJ","-",null,"W5RUOS4ag","SuRuoms50188"]
[50188,90188,"RUOMS",null,"10.162.37.85","10.109.228.204","10.109.231.254","255.255.252.0","RUO","Super U"]
[50548,90548,"SAGONE - VICO",null,"10.162.62.85","10.100.88.204","10.100.91.254","255.255.252.0","SGO","Super U"]
[51303,91303,"SANARY-SUR-MER (UPF)",null,"---","10.109.148.204","10.109.151.254","255.255.252.0","SSM","Utile","2019-05-15"]
[55182,95182,"SAULT DE NAVAILLE  (UPSO)",null,"10.163.234.85","10.100.232.204","10.100.235.254","255.255.252.0","SNV","U Express",null,"W5SAU1S4ag","SuSauvet56973"]
[56973,96973,"SAUVETERRE DE GUYENNE",null,"---","10.100.120.204","10.100.123.254","255.255.252.0","SAU","Super U"]
[56987,96987,"SEILHAC",null,"---","10.161.170.204","10.161.170.253","255.255.255.0","SEI","Super U"]
[51141,90605,"SENAS  (UPF)",null,"---","10.101.12.204","10.101.15.254","255.255.252.0","SEN","U Express"]
[50442,90442,"SERRES",null,"10.162.91.85","10.103.192.204","10.103.195.254","255.255.252.0","SER","U Express"]
[50489,90211,"SERVIAN",null,"10.162.43.85","10.109.240.204","10.109.243.254","255.255.252.0","SEV","Super U",null,"W5SST1S4ag","SUsisteron50526"]
[51297,91297,"SEYNE LES ALPES (UPF)",null,"---","10.103.128.204","10.103.131.254","255.255.252.0","SAP","Utile"]
[50526,90526,"SISTERON",null,"10.162.54.85","10.100.204.204","10.100.207.254","255.255.252.0","SST","Super U"]
[51098,90402,"SISTERON  (UPF)",null,"10.163.43.85","10.101.68.204","10.101.71.254","255.255.252.0","SIS","U Express"]
[51111,91111,"SOREZE  (UPF)",null,"10.163.36.85","10.101.148.204","10.101.151.254","255.255.252.0","SOZ","U Express"]
[50198,90198,"SORGUES",null,"10.162.40.85","10.109.236.204","10.109.239.254","255.255.252.0","SOR","U Express"]
[55161,95161,"SOUAL",null,"10.162.240.85","10.111.36.204","10.111.39.254","255.255.252.0","SOU","Super U"]
[50406,90406,"ST AFFRIQUE",null,"10.162.94.85","10.161.78.204","10.161.78.254","255.255.255.0","SAM","U Express"]
[50552,90552,"ST AFFRIQUE ",null,"---","10.100.100.204","10.100.103.254","255.255.252.0","SAF","Super U"]
[59203,99203,"ST ANDRE  LA REUNION",null,"10.162.195.85","10.161.195.204","10.161.195.254","255.255.255.0","SAN","Super U"]
[51083,91083,"ST ANDRE LES ALPES (UPF)",null,"---","10.101.44.204","10.101.47.254","255.255.252.0","SAA","U Express"]
[51143,91143,"ST AYGULF (UPF)",null,"---","10.101.24.204","10.101.27.254","255.255.252.0","STA","U Express"]
[59108,99108,"ST BENOIT",null,"10.162.182.85","10.161.182.204","10.161.182.254","255.255.255.0","SBE","U Express"]
[51278,91278,"ST CANNAT (UPF)",null,"10.163.107.85","10.101.240.204","10.101.243.254","255.255.252.0","SCT","U Express"]
[50582,90582,"ST CHELY D'APCHER",null,"10.162.219.85","10.100.132.204","10.100.135.254","255.255.252.0","SCA","Super U"]
[55767,95767,"ST CIERS SUR GIRONDE",null,"10.162.143.85","10.111.132.204","10.111.135.254","255.255.252.0","SCI","Super U"]
[51307,90500,"ST CYPRIEN",null,"10.162.215.85","10.110.160.204","10.110.163.254","255.255.252.0","SCY","Utile",null,"W5sdov1s3g","SUstdonat50462"]
[50462,90462,"ST DONAT",null,"10.162.105.85","10.110.116.204","10.110.119.254","255.255.252.0","SDO","Super U"]
[51304,91118,"ST ETIENNE LES ORGUES (UPF)",null,"---","10.103.244.0","10.103.247.254","255.255.252.0","ELO","Utile"]
[55132,95132,"ST GAUDENS",null,"---","10.161.201.204","10.161.201.254","255.255.255.0","SGA","U Express"]
[50226,90226,"ST HIPPOLYTE DU FORT",null,"10.162.44.85","10.109.244.204","10.109.247.254","255.255.252.0","SHI","Super U"]
[50544,90544,"ST JEAN DE VEDAS",null,"10.162.83.85","10.100.40.204","10.100.43.254","255.255.252.0","SJV","U Express"]
[50021,90021,"ST JEAN DU GARD",null,"10.162.18.85","10.161.18.204","10.161.18.254","255.255.255.0","SJD","U Express"]
[51310,90458,"ST JEANNET",null,"10.162.101.85","10.161.101.204","10.161.101.254","255.255.255.0","SJN","U Express"]
[50531,90531,"ST LAURENT D'AIGOUZE",null,"10.162.8.85","10.110.204.204","10.110.207.254","255.255.252.0","SLZ","U Express"]
[51148,91148,"ST LAURENT DU VAR (UPF)",null,"---","10.101.32.204","10.101.35.254","255.255.252.0","SLV","U Express",null,"W5SLA1S4ag","SUsla56347"]
[56347,96347,"ST LAURENT MEDOC",null,"10.162.155.85","10.111.164.204","10.111.167.254","255.255.252.0","SLA","Super U"]
[50251,90251,"ST MARTIN DE CRAU",null,"10.162.53.85","10.110.8.204","10.110.11.254","255.255.252.0","SMC","Super U"]
[55129,95129,"ST MARTIN DE SEIGNANX",null,"10.162.175.85","10.161.175.204","10.161.175.254","255.255.255.0","SMS","Super U",null,"w5smxv1s3g","HuStmaximin50510"]
[50510,90510,"ST MAXIMIN LA STE BAUME",null,"10.162.113.85","10.110.180.204","10.110.183.254","255.255.252.0","SMX","Hyper U"]
[55147,95147,"ST MEDARD DE MUSSIDAN",null,"10.162.191.85","10.161.191.204","10.161.191.254","255.255.255.0","SMM","Super U"]
[59821,99821,"ST PAUL BOIS DE NEFLES",null,"10.163.110.85","10.101.252.204","10.101.255.254","255.255.252.0","SPL","U Express"]
[59101,99101,"ST PAUL LA REUNION",null,"10.162.132.85","10.161.132.204","10.161.132.254","255.255.255.0","SPS","Super U"]
[59205,99205,"ST PAUL PLATEAU CAILLOUX",null,"10.162.199.85","10.161.199.204","10.161.199.254","255.255.255.0","SPP","Marché U"]
[51264,91264,"ST PAUL TROIS CHATEAUX (UPF)",null,"---","10.102.180.204","10.102.183.254","255.255.252.0","SPC","Utile"]
[51293,91293,"ST PIERRE DE VASSOLS (UPF)",null,"---","10.103.72.204"," 10.103.75.254","255.255.252.0","PDV","Utile"]
[50156,90156,"ST PONS DE THOMIERES",null,"10.162.29.85","10.109.204.204","10.109.207.254","255.255.252.0","SPT","U Express"]
[50536,90536,"ST RAPHAEL",null,"10.162.176.85","10.110.216.204","10.110.219.254","255.255.252.0","RAF","Super U"]
[50659,90659,"ST REMY DE PROVENCE (UPF)",null,"10.163.40.85","10.101.140.204","10.101.143.254","255.255.252.0","SRP","U Express"]
[51249,91249,"ST SATURNIN LES AVIGNONS (UPF)",null,"---","10.101.220.204","10.101.223.254","255.255.252.0","SUN","U Express"]
[56977,96977,"ST SEURIN SUR L'ISLE",null,"10.162.169.85","10.111.200.204","10.111.203.254","255.255.252.0","SSE","Super U"]
[50555,90555,"ST SORLIN EN VALLOIRE",null,"10.162.211.85","10.110.224.204","10.110.227.254","255.255.252.0","SSO","Super U",null,"admin","SU-Stsulcam*173"]
[56994,96994,"ST SULPICE/CAMEYRAC",null,"10.162.173.85","10.111.216.204","10.111.219.254","255.255.252.0","SSU","Super U"]
[51140,91140,"ST VICTORET (UPF)",null,"10.163.23.85","10.101.28.204","10.101.31.254","255.255.252.0","STV","U Express",null,"w5szav1s3g","SuStzacharie50502"]
[50502,90502,"ST ZACHARIE JURAMY",null,"10.162.228.85","10.110.168.204","10.110.171.254","255.255.252.0","SZA","Super U"]
[55176,95176,"STE BAZEILLE",null,"10.162.179.85","10.111.68.204","10.111.71.254","255.255.252.0","BZL","Super U"]
[51230,91230,"STE CECILE LES VIGNES (UPF)",null,"---","10.102.44.204","10.102.47.254","255.255.252.0","SCV","Utile"]
[50594,90572,"STE LUCIE DE PORTO VECCHIO",null,"10.163.101.85","10.100.180.204","10.100.183.254","255.255.252.0","SPV","Super U"]
[59209,99209,"STE MARIE LA REUNION",null,"10.162.245.85","10.100.68.204","10.100.71.254","255.255.252.0","SMR","U Express",null,"W5PFU1S4ag","SUSILEXPFU50583"]
[59509,99509,"TAMARIN",null,"---","10.103.60.204","10.103.63.254","255.255.252.0","TMR","U Express"]
[59206,99206,"TAMPON CENTRE VILLE",null,"10.162.232.85","10.161.232.204","10.161.232.254","255.255.255.0","LTP","Marché U"]
[50241,90241,"TARASCON S/ARIEGE",null,"10.162.49.85","10.103.164.204","10.103.167.254","255.255.252.0","TAA","Super U"]
[51103,90474,"TARASCON SUR RHONE (UPF)","2020-04-17","10.163.66.85","10.101.56.204","10.101.59.254","255.255.252.0","TAR","U Express"]
[51170,91170,"TENCIN (UPF)",null,"10.163.88.85","10.101.40.204","10.101.43.254","255.255.252.0","TEC","U Express",null,"W5MURS4ag","SuThezan50175"]
[59688,99688,"TERRE SAINTE",null,"10.163.114.85","10.103.12.204","10.103.15.254","255.255.252.0","SPR","U Express"]
[50175,90175,"THEZAN LES BEZIERS",null,"10.162.35.85","10.103.148.204","10.103.151.254","255.255.252.0","MUR","Super U"]
[51317,91317,"THONON-LES-BAINS (UPF)",null,null,"10.109.60.0","10.109.63.254","255.255.252.0","TLB","Utile"]
[50550,90550,"THUIR",null,"10.162.208.85","10.100.60.204","10.100.63.254","255.255.252.0","THU","Super U"]
[51280,91280,"TOULON FLORANE (UPF)",null,"---","10.102.244.204","10.102.147.254","255.255.252.0","TNF","Utile"]
[50401,90401,"TREBES",null,"10.162.74.85","10.103.36.204","10.103.39.254","255.255.252.0","TRE","Super U"]
[59236,99236,"TROIS BASSINS",null,"---","10.100.216.204","10.100.219.254","255.255.252.0","TBS","Super U"]
[51081,91081,"TULETTE (UPF)",null,"10.163.73.85","10.101.48.204","10.101.51.254","255.255.252.0","TLT","U Express",null,"W5LAGV1S4AG","SuLaGue55185"]
[55199,95185,"TULLE LAGUENNE",null,"10.162.181.85","10.100.28.204","10.100.31.254","255.255.252.0","LAG","Super U"]
[50665,90665,"UPIE  (UPF)",null,"10.163.88.85","10.101.124.204","10.101.127.254","255.255.252.0","UPI","U Express",null,"W5UST1S4ag","SuUstaritz5184"]
[55184,95262,"USTARITZ",null,"10.162.127.85","10.103.224.204","10.103.227.254","255.255.252.0","UST","Super U"]
[55134,95134,"UZERCHE",null,"10.162.217.85","10.161.217.204","10.161.217.254","255.255.255.0","UZE","Super U"]
[50252,90252,"VAISON LA ROMAINE",null,"10.162.10.85","10.103.168.204","10.103.171.254","255.255.252.0","VAI","Super U"]
[50885,90517,"VALLAURIS GOLFE JUAN (UPF)",null,"10.163.32.85","10.101.152.204","10.101.155.254","255.255.252.0","GJU","U Express"]
[51291,91073,"VELLERON (UPF)",null,"---","10.103.68.204"," 10.103.71.254","255.255.252.0",null,"Utile"]
[51161,90459,"VENCE (UPF)",null,"---","10.102.4.204","10.102.7.254","255.255.252.0","VEN","Utile"]
[51309,90660,"VENELLES (UPF)",null,"10.163.74.85","10.101.176.204","10.101.179.254","255.255.252.0","VNL","U Express"]
[50613,90613,"VERCLAUSE (UPF)",null,"10.163.44.85","10.101.104.204","10.101.107.254","255.255.252.0","VCL","U Express"]
[56970,96970,"VERDUN SUR GARONNE",null,"10.162.167.85","10.111.196.204","10.111.199.204","255.255.252.0","VED","Super U",null,"w5vegv1s3g","SUvergeze50130"]
[50130,90130,"VERGEZE",null,"10.162.6.85","10.103.140.204","10.103.143.254","255.255.252.0","VEG","Super U"]
[51263,91263,"VERNEGUES (UPF)",null,"---","10.102.176.204","10.102.179.254","255.255.252.0","VNG","Utile"]
[50539,90539,"VERNIOLLE",null,"10.162.174.85","10.110.220.204","10.110.223.254","255.255.252.0","VOL","Super U"]
[50679,90679,"VESCOVATO (UPF)",null,"10.163.75.85","10.101.212.204","10.101.215.254","255.255.252.0","VSC","U Express",null,"W5VEYV1S4a","SUVeynes50265"]
[50265,90265,"VEYNES",null,"10.162.60.85","10.110.16.204","10.110.19.254","255.255.252.0","VEY","Super U",null,"W5VILV1S4AG\nchangé par PDV","SuperUvil55127\nchangé par PDV"]
[51295,91295,"VEYRIER DU LAC (UPF)",null,"---","10.103.92.204","10.103.95.254","255.255.252.0","VDL","Utile"]
[59868,99868,"VINCENDO","2020-08-07","10.163.125.85","10.103.84.204","10.103.87.254","255.255.252.0","VCD","Super U"]
[55198,95127,"VILLEFRANCHE DE LAURAGAIS",null,"10.162.178.85","10.110.236.204","10.110.239.254","255.255.252.0","VIL","Hyper U"]
[55455,95458,"VILLEFRANCHE/ROUERGUE COOP",null,"---","10.161.184.204","10.161.184.254","255.255.255.0","?","COOP"]
[55460,95460,"VILLENEUVE D'AVEYRON (UPSO)",null,"---","10.165.184.204","10.165.184.254","255.255.255.0","VLA","U Express"]
[50828,90828,"VILLEPINTE (UPF)",null,"---","10.109.104.204","10.109.107.254","255.255.252.0","VTE","Utile"]
[55150,95150,"YDES",null,"10.162.163.85","10.111.20.204","10.111.23.254","255.255.252.0","YDE","Super U"]