メインメニュー
検索
読み物
これからはじめる環境報告
IMDSについて
JAMAシートについて
環境報告って何?
EnMa
環境法規
便利なサイト
ログイン
ユーザー名:

パスワード:


パスワード紛失

トップ  >  JAMAシートについて  >  チェックが通るから問題無いとか思ってたら大間違い(JAMAシート)
JAMAシートの『入力データのチェック』機能。
コレを使用してエラーも警告も出なければ、そのデータは承認されるデータと言えるのか?んなワケねぇ
データの精度とかまぁいろいろとあるとは思いますが、結局のところ『依頼者が欲しい情報が網羅されている』ということが重要です。
『入力データのチェック』は、JAMAシートの入力ルールに則って入力されているかをチェックするだけで、内容については全くのザルです。

試しに、

"C","Ver.2.10","","正常終了","","EXLIST-2009-10-01JP.xls"
"H","","","","",""
"D","1","1","1","4","","","1","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
"D","2","1","1","","","","2","1","","4","1","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
"D","3","1","1","","","","3","2","","4","1","","Iron/Other Iron alloy (Unalloyed, low alloyed)","","1","JAMAA4444","FE","","1.1.1","1","","","","7439-89-6","Iron","90","","0","0","0","0","","","","","","","","","","","","","1","","","1762",""
"D","4","1","1","","","","3","2","","","1","","Iron/Other Iron alloy (Unalloyed, low alloyed)","","","JAMAA4444","FE","","1.1.1","","","","","system","Misc., not to declare","10","","","","","","","","","","","","","","","","","","","","","9999",""
"D","5","1","1","","","","3","2","","","1","","Plastics PTFE (Filled)","","1","ISO1043","","PTFE-0","5.1.a","1","","","","-","PTFE","100","","0","0","0","0","","","","","","","","","","","","","1","","","1351310",""
"D","6","1","1","","","","3","2","","","1","","Rubber NBR","","1","ISO1629","","NBR","5.3","1","","","","-","NBR","100","","0","0","0","0","","","","","","","","","","","","","1","","","23383",""
"D","7","1","1","","","","3","2","","","1","","Oil","","1","JAMAA4444","OIL","","9.2","1","","","","-","Ester Oil, natural, for lubricants","100","","","","","","","","","","","","","","","","","","1","","","11061726",""

を、メモ帳(.txt)にでも貼り付けてみてください。"C"or"H"or"D"で始まる9行になるように調整してくださいね。
で、その拡張子を『.csv』に変更してください。
コレでJAMAシートで読み込みできるファイルになります。

で、読み込んで『入力データのチェック』をかけてみると、エラーの一つも出ません。
部品構成としては、1-1-2の三層で、Cは材料が4つ(全て1g)付いています。

製品情報としては品番、部品名称ともに入力があります。
構成部品名称、一切入っていません。JAMAシート上でユニークを取っているのが品番であることがわかります。

材料名称は外部リストからの参照になるので、基本的には自動入力になります。
1つめの材料:『JAMAA4444』の『Iron/Other Iron alloy (Unalloyed, low alloyed)』は、材料コードが『FE@』となり『@』の置換えを要求されます。……消すだけでokです。そんなバカな
2つめの材料:『ISO1043』の『Plastics PTFE (Filled)』は、材料記号が『PTFE-$』となり『$』の置換えを要求されます。……0でokです。文字さえ入ってれば良いみたい。何の冗談ですか?
3つめと4つめの材料は特にコレといったネタもないのでスルーしますが、エラーや警告の回避自体は簡単なんです
そういえばPTFEやNBR入ってるのに材質表示も警告出ないな。

あ、材料的には『その材料を構成する主成分が入っていれば警告も出ない』です。つまり、『鉄系』のVDAコードに属する材料であれば、鉄が入ってさえいれば(含有率の問題はありますが)特に問題無いってことです。
※※※2010/03/24:追記※※※
実験してみたら、何でも良いから物質が入っていれば良いみたい。
例えばVDAコードが1.1.1だったら鉄系なワケだけど、アルミ100でも何も言われない。鉄が入っていなくてもお咎めなし。
ザルにも程がある。
※※※

ちなみに、『エラー』は消滅させないといけませんが、『警告』は残っていても問題が無い場合があります。これも報告先の要求スタイルによりますが、回避方法はいくらでもあります。


JAMAシートは情報を収集するツールにすぎません。
報告先の要求に合わせた入力内容の把握と、サプライヤーからの成分情報収集方法の構築を推進しましょう。
環境報告・IMDS・JAMAシートにお困りなら株式会社シンク・リードへご相談ください。
環境報告実務駆け込み寺で公開中の知識と経験で御社のサポートをします!
プリンタ用画面
友達に伝える
投票数:227 平均点:5.29
前
(恐らく)ミスの少ない入力方法
カテゴリートップ
JAMAシートについて
次
csvファイルの書き出しと取り込み

Ferretアクセス解析