{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Notice générale","Outils complémentaires","Etat des stocks complet","Etat des stocks synthétique","Synth_Site"],"not_rendered":{"images":9,"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Notice générale","index":0,"n_rows":39,"n_cols":6,"rows_kept":39,"merged":[[5,2,5,5],[6,2,6,5],[19,3,19,5],[20,3,20,5],[22,3,22,5],[23,3,23,5],[24,3,24,5]]}
[]
[]
[{"$nulls":5},"Version pilote"]
[]
[]
[null,null,"Objectif du fichier : Mettre en forme l'Etat des stocks complet et"]
[null,null,"générer un Etat des stocks synthétique à partir des données renseignées dans l'Etat des stocks complet."]
[]
[]
[]
[null,null," Etape 0 :"]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"Les calculs automatiques du tableau ‘Etat des stocks complets’ se mettront à jour lorsque vous lancerez l’étape 1"]
[]
[{"$nulls":3},"Une même substance peut avoir plusieurs mentions de dangers. Dans ce cas la quantité de la substance apparait sur chaque "]
[{"$nulls":3},"ligne concernée par les mentions de dangers associées à la substance (la substance sera donc comptabilisée plusieurs fois)."]
[]
[{"$nulls":3},"La quantité réelle des substances dans chaque zone de stockage ne correspond pas à la somme des quantités par mention de "]
[{"$nulls":3},"danger. Il est donc important en complément de l’état par famille d’indiquer le total réel de matières stockées sur chaque zone et "]
[{"$nulls":3},"donc sur chaque fiche."]
[]
[null,null," Etape 1 :","Mettre en forme l'Etat des stocks complet"]
[{"$nulls":3},"Objectif : Saisie automatique des lignes et colonnes TOTAUX"]
[]
[]
[]
[null,null," Etape 2 :","Vérifier l'Etat des stocks complet"]
[{"$nulls":3},"Utilisateur : Vérifier que l'étape 1 s'est terminée sans beug, corriger les éventuelles erreurs de saisie"]
[]
[null,null," Etape 3 :","Générer                                                      à partir de l'Etat des stocks complet"]
[]
[]
[]
[null,null," Etape 4 :","Générer l'Etat des stocks synthétique d'une zone spécifique"]

{"sheet":"Outils complémentaires","index":1,"n_rows":14,"n_cols":4,"rows_kept":14}
[]
[]
[]
[]
[]
[]
[null,null,"Outil 1 :","Générer l'ensemble des Etats des stocks synthétiques"]
[{"$nulls":3},"Objectif : Permet de lancer l'Etape 4 pour toutes les zones du site (vs un état zone par zone)"]
[{"$nulls":3},"Attention cette étape prend du temps "]
[]
[]
[]
[null,null,"Outil 2 :","Supprimer les onglets inutiles"]
[{"$nulls":3},"Objectif : Permet de supprimer les onglets générés par l'étape 4 ou l'outil 1"]

{"sheet":"Etat des stocks complet","index":2,"n_rows":59,"n_cols":41,"rows_kept":59,"merged":[[2,3,2,8],[2,9,2,12],[2,13,2,15],[2,16,2,17],[2,18,2,20],[2,21,2,22],[2,23,2,24],[2,25,2,26],[2,27,2,30],[2,31,2,40]]}
[6,"zones"]
[59,"index dernière ligne Etat des stocks complet",{"$nulls":3},"Etat des stocks complet [t]"]
[{"$nulls":3},"TOXIQUE",{"$nulls":5},"INFLAMMABLE",{"$nulls":3},"EXPLOSIBLE",null,null,"COMBURANT",null,"PYROPHORIQUE, HYDROREACTIF",null,null,"ECOTOXIQUE ",null,"PEROXYDES ORGANIQUES, AUTO REACTIFS",null,"COMBUSTIBLE",null,"FDS : \nRisque en cas d’incendie",{"$nulls":3},"DECHETS "]
["Zone","Produit","Quantité [t]","Ingestion (H300/H301)","Contact cutané (H310/H311)","Inhalation (H330/H331)","Effets graves sur les organes (H370)","Effet chronique (H340, H341, H350, H351, H360, H361)","Total mat,\nTOXIQUE","Gaz et aérosols (H220/H221/H222/H223)","Liquides (H224/H225/H226)","Solides (H228)","Total mat,\nINFLAMMABLE","Toutes mentions (H200/H201/H202/H203/H204/H205)","Sans mention H explosible division 1,6","Total mat,\nEXPLOSIBLE","H270/H271/H272","Total mat,\nCOMBURANT","S’enflamme ou dégage au contact de l’eau des gaz inflammables (H250, H260)","Réagit au contact de l’eau (EUH014, EUH029)","Total mat,\nPYROPHORIQUE, HYDROREACTIF","Toxiques pour les organismes aquatiques (H400/H410/H411)","Total mat,\nECOTOXIQUE ","H240, H241, H242","Total mat,\nPEROXYDES ORGANIQUES, AUTO REACTIFS","Liquide ou solide sans mention danger inflammable selon CLP","Total mat,\nCOMBUSTIBLE","Matières corrosives (H314)","Matières radioactives","Piles / Batteries","Total mat,\nRisque en cas d’incendie","HP1 Explosif","HP2 Comburant","HP3 Inflammable","HP5, HP6 Nocif et Toxique","HP7, HP10, HP11 Cancérigène, Reprotox, Mutagène","HP12 EUH (dégage gaz toxicité aigüe au contact de l’eau)","HP14 Ecotox","HP15 peut donner naissance à une autre substance","Déchets combustibles : Liquide ou solide sans mention danger inflammable selon CLP","Total mat,\nDECHETS "]
["Bâtiment process","Divers",3,"X",{"$nulls":4},3]
["Bâtiment process","Divers Futs A\net Conteneurs A",5,{"$nulls":6},"X",null,null,5]
["Bâtiment process","Fûts B",0.5,{"$nulls":13},"X",0.5]
["Bâtiment process","Fûts C",1,{"$nulls":18},"X",1]
["Bâtiment process","Fûts D et Conteneurs D",5,{"$nulls":22},"X",5]
["Bâtiment process","Fûts E et Conteneurs E",0.5,{"$nulls":15},"X",null,0.5]
["Bâtiment process","Fûts F et Conteneurs F",2,{"$nulls":24},"X",null,null,2]
["Bâtiment process","Sources scellées (matière radioactive)",{"$nulls":26},"1 unité"]
["Total : Bâtiment process",null,17,3,0,0,0,0,3,5,0,0,5,0,0,0,0.5,0.5,0.5,0,0.5,1,1,0,0,5,5,2,0,0,2,0,0,0,0,0,0,0,0,0,0]
["Cuves","Dichlorométhane",40,{"$nulls":4},"X",40,{"$nulls":16},"X",40]
["Cuves","Toluène",160,{"$nulls":4},"X",160,null,"X",null,160]
["Cuves","Ethanol",185,{"$nulls":7},"X",null,185]
["Cuves","Acétone",185,{"$nulls":7},"X",null,185]
["Cuves","Eau oxygénée < 70%",35,{"$nulls":13},"X",35]
["Cuves","Glycol",80,{"$nulls":22},"X",80]
["Cuves","Acide chlorhydrique",200,{"$nulls":24},"X",null,null,200]
["Total : Cuves",null,885,0,0,0,0,200,200,0,530,0,530,0,0,0,35,35,0,0,0,0,0,0,0,120,120,200,0,0,200,0,0,0,0,0,0,0,0,0,0]
["Déchets","Conteneurs",16,{"$nulls":29},"X",{"$nulls":7},16]
["Déchets","VRAC 1",26,{"$nulls":31},"X",{"$nulls":5},26]
["Déchets","VRAC 2",56,{"$nulls":30},"X",{"$nulls":6},56]
["Déchets","Fûts",4,{"$nulls":29},"X","X","X","X",null,"X",null,null,4]
["Déchets","Bidons",1,{"$nulls":32},"X",null,"X","X",null,1]
["Déchets","Palettes de carton",0.5,{"$nulls":36},"X",0.5]
["Total : Déchets",null,103.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,20,60,30,5,0,5,1,0.5,103.5]
["Entrepôt","Hydrazine",61,"X","X","X",null,"X",61,null,"X",null,61,{"$nulls":8},"X",61,{"$nulls":4},"X",null,null,61]
["Entrepôt","Phosgène",55,null,null,"X",null,null,55,{"$nulls":18},"X",null,null,55]
["Entrepôt","Acide borique",34,{"$nulls":4},"X",34]
["Entrepôt","Spray",2,{"$nulls":6},"X",null,null,2]
["Entrepôt","Divers",150,{"$nulls":7},"X",null,150]
["Entrepôt","Perchlorate d'ammonium",10,{"$nulls":10},"X",null,10,"X",10]
["Entrepôt","Perox, TEA150",5,{"$nulls":18},"X",5,"X",5]
["Entrepôt","Glycol",20,{"$nulls":22},"X",20]
["Entrepôt","Divers combustible",20,{"$nulls":22},"X",20]
["Entrepôt","Palettes bois",15,{"$nulls":22},"X",15]
["Entrepôt","Cartons",5,{"$nulls":22},"X",5]
["Entrepôt","Plastic film",0.5,{"$nulls":22},"X",0.5]
["Entrepôt","Polystyrène",2,{"$nulls":22},"X",2]
["Entrepôt","Huiles moteur",2,{"$nulls":22},"X",2]
["Entrepôt","Acide sulfurique",51,{"$nulls":16},"X",51,{"$nulls":6},"X",null,null,51]
["Entrepôt","Sources scellées (matière radioactive)",{"$nulls":26},"2 unités"]
["Total : Entrepôt",null,432.5,61,61,116,0,95,150,2,211,0,213,10,0,10,10,10,0,51,51,66,66,5,5,64.5,64.5,167,0,0,167,0,0,0,0,0,0,0,0,0,0]
["Laboratoire","mat, Inflammables",5,{"$nulls":6},"X",null,null,5]
["Laboratoire","mat, Toxiques",0.5,"X",{"$nulls":4},0.5]
["Laboratoire","mat, Ecotoxiques",1,{"$nulls":18},"X",1]
["Laboratoire","mat, Comburants",0.2,{"$nulls":13},"X",0.2]
["Laboratoire","Chlore",0.01,null,null,"X",null,null,0.01,{"$nulls":12},"X",0.01]
["Laboratoire","Hydrogène",0.01,{"$nulls":6},"X",null,null,0.01]
["Laboratoire","Ammoniac",0.01,null,null,"X",null,null,0.01,"X",null,null,0.01,{"$nulls":8},"X",0.01,{"$nulls":4},"X",null,null,0.01]
["Total : Laboratoire",null,6.7299999999999995,0.5,0,0.02,0,0,0.52,5.02,0,0,5.02,0,0,0,0.2,0.2,0,0,0,1.02,1.02,0,0,0,0,0.01,0,0,0.01,0,0,0,0,0,0,0,0,0,0]
["Stockage extérieur","Méthanol",20,"X","X","X","X",null,20,null,"X",null,20]
["Stockage extérieur","Acétonitrile",20,{"$nulls":7},"X",null,20]
["Stockage extérieur","Glycol",20,{"$nulls":22},"X",20]
["Stockage extérieur","Soude",30,{"$nulls":24},"X",null,null,30]
["Total : Stockage extérieur",null,90,20,20,20,20,0,20,0,40,0,40,0,0,0,0,0,0,0,0,0,0,0,0,20,20,30,0,0,30,0,0,0,0,0,0,0,0,0,0]
["Total : Site",null,1534.73,84.5,81,136.02,20,295,373.52,12.02,781,null,793.02,10,null,10,45.7,45.7,0.5,51,51.5,68.02000000000001,68.02000000000001,5,5,209.5,209.5,399.01,0,null,399.01,null,20,60,30,5,null,5,1,0.5,103.5]

{"sheet":"Etat des stocks synthétique","index":3,"n_rows":46,"n_cols":8,"rows_kept":46}
[6]
[59]
[]
["Etat des stocks synthétique [t]"]
["Mention de danger","Total : Bâtiment process","Total : Cuves","Total : Déchets","Total : Entrepôt","Total : Laboratoire","Total : Stockage extérieur","Total : Site"]
["Ingestion (H300/H301)"," Divers; ",null,null," Hydrazine; "," mat, Toxiques; "," Méthanol; "," Divers;  Hydrazine;  mat, Toxiques;  Méthanol; "]
["Contact cutané (H310/H311)",{"$nulls":3}," Hydrazine; ",null," Méthanol; "," Hydrazine;  Méthanol; "]
["Inhalation (H330/H331)",{"$nulls":3}," Hydrazine;  Phosgène; "," Chlore;  Ammoniac; "," Méthanol; "," Hydrazine;  Phosgène;  Chlore;  Ammoniac;  Méthanol; "]
["Effets graves sur les organes (H370)",{"$nulls":5}," Méthanol; "," Méthanol; "]
["Effet chronique (H340, H341, H350, H351, H360, H361)",null," Dichlorométhane;  Toluène; ",null," Hydrazine;  Acide borique; ",null,null," Dichlorométhane;  Toluène;  Hydrazine;  Acide borique; "]
["TOXIQUE",3,200,0,150,0.52,20,{"v":373.52,"d":"374"}]
["Gaz et aérosols (H220/H221/H222/H223)"," Divers Futs A\net Conteneurs A; ",null,null," Spray; "," mat, Inflammables;  Hydrogène;  Ammoniac; ",null," Divers Futs A\net Conteneurs A;  Spray;  mat, Inflammables;  Hydrogène;  Ammoniac; "]
["Liquides (H224/H225/H226)",null," Toluène;  Ethanol;  Acétone; ",null," Hydrazine;  Divers; ",null," Méthanol;  Acétonitrile; "," Toluène;  Ethanol;  Acétone;  Hydrazine;  Divers;  Méthanol;  Acétonitrile; "]
["Solides (H228)"]
["INFLAMMABLE",5,530,0,213,5.02,40,{"v":793.02,"d":"793"}]
["Toutes mentions (H200/H201/H202/H203/H204/H205)",{"$nulls":3}," Perchlorate d'ammonium; ",null,null," Perchlorate d'ammonium; "]
["Sans mention H explosible division 1.6"]
["EXPLOSIBLE",0,0,0,10,0,0,10]
["H270/H271/H272"," Fûts B; "," Eau oxygénée < 70%; ",null," Perchlorate d'ammonium; "," mat, Comburants; ",null," Fûts B;  Eau oxygénée < 70%;  Perchlorate d'ammonium;  mat, Comburants; "]
["COMBURANT",0.5,35,0,10,0.2,0,45.7]
["S’enflamme ou dégage au contact de l’eau des gaz inflammables (H250, H260)"," Fûts E et Conteneurs E; ",{"$nulls":5}," Fûts E et Conteneurs E; "]
["Réagit au contact de l’eau (EUH014, EUH029)",{"$nulls":3}," Acide sulfurique; ",null,null," Acide sulfurique; "]
["PYROPHORIQUE, HYDROREACTIF",0.5,0,0,51,0,0,51.5]
["Toxiques pour les organismes aquatiques (H400/H410/H411)"," Fûts C; ",null,null," Hydrazine;  Perox, TEA150; "," mat, Ecotoxiques;  Chlore;  Ammoniac; ",null," Fûts C;  Hydrazine;  Perox, TEA150;  mat, Ecotoxiques;  Chlore;  Ammoniac; "]
["ECOTOXIQUE",1,0,0,66,1.02,0,{"v":68.02,"d":"68"}]
["H240, H241, H242",{"$nulls":3}," Perox, TEA150; ",null,null," Perox, TEA150; "]
["PEROXYDES ORGANIQUES, AUTO REACTIFS",0,0,0,5,0,0,5]
["Liquide ou solide sans mention danger inflammable selon CLP"," Fûts D et Conteneurs D; "," Dichlorométhane;  Glycol; ",null," Glycol;  Divers combustible;  Palettes bois;  Cartons;  Plastic film;  Polystyrène;  Huiles moteur; ",null," Glycol; "," Fûts D et Conteneurs D;  Dichlorométhane;  Glycol;  Glycol;  Divers combustible;  Palettes bois;  Cartons;  Plastic film;  Polystyrène;  Huiles moteur;  Glycol; "]
["COMBUSTIBLES",5,120,0,64.5,0,20,{"v":209.5,"d":"210"}]
["Matières corrosives (H314)"," Fûts F et Conteneurs F; "," Acide chlorhydrique; ",null," Hydrazine;  Phosgène;  Acide sulfurique; "," Ammoniac; "," Soude; "," Fûts F et Conteneurs F;  Acide chlorhydrique;  Hydrazine;  Phosgène;  Acide sulfurique;  Ammoniac;  Soude; "]
["Matières radioactives"," Sources scellées (matière radioactive); ",null,null," Sources scellées (matière radioactive); ",null,null," Sources scellées (matière radioactive);  Sources scellées (matière radioactive); "]
["Piles / Batteries"]
["FDS : Risque en cas d’incendie",2,200,0,167,0.01,30,{"v":399.01,"d":"399"}]
["HP1 Explosif"]
["HP2 Comburant",null,null," Conteneurs;  Fûts; ",{"$nulls":3}," Conteneurs;  Fûts; "]
["HP3 Inflammable",null,null," VRAC 2;  Fûts; ",{"$nulls":3}," VRAC 2;  Fûts; "]
["HP5, HP6 Nocif et Toxique",null,null," VRAC 1;  Fûts; ",{"$nulls":3}," VRAC 1;  Fûts; "]
["HP7, HP10, HP11 Cancérigène, Reprotox, Mutagène",null,null," Fûts;  Bidons; ",{"$nulls":3}," Fûts;  Bidons; "]
["HP12 EUH (dégage gaz toxicité aigüe au contact de l’eau)"]
["HP14 Ecotox",null,null," Fûts;  Bidons; ",{"$nulls":3}," Fûts;  Bidons; "]
["HP15 peut donner naissance à une autre substance",null,null," Bidons; ",{"$nulls":3}," Bidons; "]
["Déchets combustibles : Liquide ou solide sans mention danger inflammable selon CLP",null,null," Palettes de carton; ",{"$nulls":3}," Palettes de carton; "]
["DECHETS",0,0,103.5,0,0,0,{"v":103.5,"d":"104"}]
[]
[]
["TOTAL Matières :",17,885,103.5,432.5,6.7299999999999995,90,1534.73]

{"sheet":"Synth_Site","index":4,"n_rows":46,"n_cols":3,"rows_kept":46}
[]
[]
[]
["Etat des stocks synthétique [t]"]
["Mention de danger","Total : Site","Quantité Produit [T]"]
["Ingestion (H300/H301)"," Divers;  Hydrazine;  mat, Toxiques;  Méthanol; ",84.5]
["Contact cutané (H310/H311)"," Hydrazine;  Méthanol; ",81]
["Inhalation (H330/H331)"," Hydrazine;  Phosgène;  Chlore;  Ammoniac;  Méthanol; ",136.02]
["Effets graves sur les organes (H370)"," Méthanol; ",20]
["Effet chronique (H340, H341, H350, H351, H360, H361)"," Dichlorométhane;  Toluène;  Hydrazine;  Acide borique; ",295]
["TOXIQUE",null,373.52]
["Gaz et aérosols (H220/H221/H222/H223)"," Divers Futs A\net Conteneurs A;  Spray;  mat, Inflammables;  Hydrogène;  Ammoniac; ",12.02]
["Liquides (H224/H225/H226)"," Toluène;  Ethanol;  Acétone;  Hydrazine;  Divers;  Méthanol;  Acétonitrile; ",781]
["Solides (H228)"]
["INFLAMMABLE",null,793.02]
["Toutes mentions (H200/H201/H202/H203/H204/H205)"," Perchlorate d'ammonium; ",10]
["Sans mention H explosible division 1.6"]
["EXPLOSIBLE",null,10]
["H270/H271/H272"," Fûts B;  Eau oxygénée < 70%;  Perchlorate d'ammonium;  mat, Comburants; ",45.7]
["COMBURANT",null,45.7]
["S’enflamme ou dégage au contact de l’eau des gaz inflammables (H250, H260)"," Fûts E et Conteneurs E; ",0.5]
["Réagit au contact de l’eau (EUH014, EUH029)"," Acide sulfurique; ",51]
["PYROPHORIQUE, HYDROREACTIF",null,51.5]
["Toxiques pour les organismes aquatiques (H400/H410/H411)"," Fûts C;  Hydrazine;  Perox, TEA150;  mat, Ecotoxiques;  Chlore;  Ammoniac; ",68.02000000000001]
["ECOTOXIQUE",null,68.02000000000001]
["H240, H241, H242"," Perox, TEA150; ",5]
["PEROXYDES ORGANIQUES, AUTO REACTIFS",null,5]
["Liquide ou solide sans mention danger inflammable selon CLP"," Fûts D et Conteneurs D;  Dichlorométhane;  Glycol;  Glycol;  Divers combustible;  Palettes bois;  Cartons;  Plastic film;  Polystyrène;  Huiles moteur;  Glycol; ",209.5]
["COMBUSTIBLES",null,209.5]
["Matières corrosives (H314)"," Fûts F et Conteneurs F;  Acide chlorhydrique;  Hydrazine;  Phosgène;  Acide sulfurique;  Ammoniac;  Soude; ",399.01]
["Matières radioactives"," Sources scellées (matière radioactive);  Sources scellées (matière radioactive); "]
["Piles / Batteries"]
["FDS : Risque en cas d’incendie",null,399.01]
["HP1 Explosif"]
["HP2 Comburant"," Conteneurs;  Fûts; ",20]
["HP3 Inflammable"," VRAC 2;  Fûts; ",60]
["HP5, HP6 Nocif et Toxique"," VRAC 1;  Fûts; ",30]
["HP7, HP10, HP11 Cancérigène, Reprotox, Mutagène"," Fûts;  Bidons; ",5]
["HP12 EUH (dégage gaz toxicité aigüe au contact de l’eau)"]
["HP14 Ecotox"," Fûts;  Bidons; ",5]
["HP15 peut donner naissance à une autre substance"," Bidons; ",1]
["Déchets combustibles : Liquide ou solide sans mention danger inflammable selon CLP"," Palettes de carton; ",0.5]
["DECHETS",null,103.5]
[]
[]
["TOTAL Matières :",1534.73]