JAMAシート入力方法を教えて下さい
- このフォーラムに新規トピックを投稿できます
- このフォーラムではゲスト投稿が許可されています
JAMAシート入力方法を教えて下さい
msg# 1
ゆたか
納入部品名称は、コンデンサブラケットです。
3個の部品(プレート)を溶接して、電着塗装をして完成です。
部品は、全て同じ材料ですが、質量は違います。
この場合だと、電着塗装は、部品ごとに入れるのか、1つにまとめてもいいのか、分かりません。
あと、溶接棒も記入したほうがいいのでしょうか?
3個の部品(プレート)を溶接して、電着塗装をして完成です。
部品は、全て同じ材料ですが、質量は違います。
この場合だと、電着塗装は、部品ごとに入れるのか、1つにまとめてもいいのか、分かりません。
あと、溶接棒も記入したほうがいいのでしょうか?
投票数:16
平均点:5.63
返信する
Re: JAMAシート入力方法を教えて下さい
msg# 1.1
TR_wada
投稿数: 1193
オンライン
GWを挟んでしまい、対応が遅れて申し訳ありません。
とりあえず溶接棒の材質は必須になります。
この場合、
・3個の部品はそれぞれ品番を持っているか
・塗装はどの段階で行うか
というのがキモになります。
各々品番が振られていて、溶接した後に塗装を行う場合、
親-A-材料A
親-B-材料A
親-C-材料A
親-溶接棒(便宜品番)-材料B
親-塗装(便宜品番)-材料C
という記述にすると良いと思います。
『便宜品番』というのは、溶接材や塗料そのものには品番が無いと思われますので、例えば親の品番の後ろに『-P』と付けて『Paint』といった感じで付与するものです。
個別に塗装してから溶接する場合は、
親-部品A-材料A
親-部品A-材料B(塗料)
親-部品B-材料A
親-部品B-材料B(塗料)
親-部品C-材料A
親-部品C-材料B(塗料)
親-溶接棒(便宜品番)-材料C
になりますね。
一応、JAMAシート上では、
親-(空欄)-材料A
親-部品A-材料B
親-部品B-材料C
という記述はできますが、確かコレの場合材料2つ(今回の場合、溶接棒と塗料になるので2つ)は記述できないんじゃなかったかと思います。
とりあえず溶接棒の材質は必須になります。
この場合、
・3個の部品はそれぞれ品番を持っているか
・塗装はどの段階で行うか
というのがキモになります。
各々品番が振られていて、溶接した後に塗装を行う場合、
親-A-材料A
親-B-材料A
親-C-材料A
親-溶接棒(便宜品番)-材料B
親-塗装(便宜品番)-材料C
という記述にすると良いと思います。
『便宜品番』というのは、溶接材や塗料そのものには品番が無いと思われますので、例えば親の品番の後ろに『-P』と付けて『Paint』といった感じで付与するものです。
個別に塗装してから溶接する場合は、
親-部品A-材料A
親-部品A-材料B(塗料)
親-部品B-材料A
親-部品B-材料B(塗料)
親-部品C-材料A
親-部品C-材料B(塗料)
親-溶接棒(便宜品番)-材料C
になりますね。
一応、JAMAシート上では、
親-(空欄)-材料A
親-部品A-材料B
親-部品B-材料C
という記述はできますが、確かコレの場合材料2つ(今回の場合、溶接棒と塗料になるので2つ)は記述できないんじゃなかったかと思います。
投票数:17
平均点:5.88
返信する
Re: JAMAシート入力方法を教えて下さい
msg# 1.2
TR_wada
投稿数: 1193
オンライン
"C","Ver.2.10","2010/05/06","正常終了","","EXLIST-2009-10-01JP.xls"
"H","","","","",""
"D","1","AAAAAAAAAA","BRACKET CONDENSER","13.1","","","1","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
"D","2","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","2","1","","Steel SPHC","","2","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","3","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","4","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","5","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","6","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
"D","7","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","4","1","","Steel SPHC","","4","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","8","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","9","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","10","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","11","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
"D","12","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","6","1","","Steel SPHC","","6","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","13","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","14","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","15","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","16","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
"D","17","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAAAAAAA-P","PAINT","1","1","1","Lacquer","","1","JAMAH4444","LACQUER","","6.1","1","","","","-","Basic Polymer: EP","100","","","","","","","","","","","","","","","","","","","","","1352233",""
"D","18","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAAAAAAA-W","WELDING","0.1","1","","Welding solid wires YGW11","","0.1","JISZ3312","YGW11","","1.1.1","1","","","","7439-89-6","Iron","100","","0","0","0","0","","","","","","","","","","","","","","","","1762",""
サンプルケースその1
メモ帳を開いて、上のテキスト(20行になります)を貼り付けて保存
その後に拡張子を『.txt』から『.csv』に変更して、JAMAシートのcsv読み込みをやってみてください
コレは
親-部品A-材料A
親-部品B-材料A
親-部品C-材料A
親-塗料-材料B
親-溶接材-材料C
の場合
"H","","","","",""
"D","1","AAAAAAAAAA","BRACKET CONDENSER","13.1","","","1","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
"D","2","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","2","1","","Steel SPHC","","2","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","3","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","4","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","5","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","6","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
"D","7","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","4","1","","Steel SPHC","","4","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","8","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","9","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","10","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","11","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
"D","12","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","6","1","","Steel SPHC","","6","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","13","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","14","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","15","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","16","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
"D","17","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAAAAAAA-P","PAINT","1","1","1","Lacquer","","1","JAMAH4444","LACQUER","","6.1","1","","","","-","Basic Polymer: EP","100","","","","","","","","","","","","","","","","","","","","","1352233",""
"D","18","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAAAAAAA-W","WELDING","0.1","1","","Welding solid wires YGW11","","0.1","JISZ3312","YGW11","","1.1.1","1","","","","7439-89-6","Iron","100","","0","0","0","0","","","","","","","","","","","","","","","","1762",""
サンプルケースその1
メモ帳を開いて、上のテキスト(20行になります)を貼り付けて保存
その後に拡張子を『.txt』から『.csv』に変更して、JAMAシートのcsv読み込みをやってみてください
コレは
親-部品A-材料A
親-部品B-材料A
親-部品C-材料A
親-塗料-材料B
親-溶接材-材料C
の場合
投票数:13
平均点:4.62
返信する
Re: JAMAシート入力方法を教えて下さい
msg# 1.3
TR_wada
投稿数: 1193
オンライン
"C","Ver.2.10","2010/05/06","正常終了","","EXLIST-2009-10-01JP.xls"
"H","","","","",""
"D","1","AAAAAAAAAA","BRACKET CONDENSER","13.1","","","1","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
"D","2","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","2.1","1","","Steel SPHC","","2","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","3","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","4","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","5","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","6","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
"D","7","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","1","Lacquer","","0.1","JAMAH4444","LACQUER","","6.1","1","","","","-","Basic Polymer: EP","100","","","","","","","","","","","","","","","","","","","","","1352233",""
"D","8","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","4.3","1","","Steel SPHC","","4","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","9","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","10","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","11","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","12","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
"D","13","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","1","Lacquer","","0.3","JAMAH4444","LACQUER","","6.1","1","","","","-","Basic Polymer: EP","100","","","","","","","","","","","","","","","","","","","","","1352233",""
"D","14","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","6.6","1","","Steel SPHC","","6","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","15","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","16","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","17","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","18","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
"D","19","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","1","Lacquer","","0.6","JAMAH4444","LACQUER","","6.1","1","","","","-","Basic Polymer: EP","100","","","","","","","","","","","","","","","","","","","","","1352233",""
"D","20","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAAAAAAA-W","WELDING","0.1","1","","Welding solid wires YGW11","","0.1","JISZ3312","YGW11","","1.1.1","1","","","","7439-89-6","Iron","100","","0","0","0","0","","","","","","","","","","","","","","","","1762",""
サンプルケースその2(22行)
(略)
コレは
親-部品A-材料A
親-部品A-材料B
親-部品B-材料A
親-部品B-材料B
親-部品C-材料A
親-部品C-材料B
親-溶接材-材料C
の場合
"H","","","","",""
"D","1","AAAAAAAAAA","BRACKET CONDENSER","13.1","","","1","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
"D","2","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","2.1","1","","Steel SPHC","","2","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","3","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","4","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","5","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","6","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
"D","7","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","1","Lacquer","","0.1","JAMAH4444","LACQUER","","6.1","1","","","","-","Basic Polymer: EP","100","","","","","","","","","","","","","","","","","","","","","1352233",""
"D","8","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","4.3","1","","Steel SPHC","","4","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","9","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","10","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","11","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","12","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
"D","13","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","1","Lacquer","","0.3","JAMAH4444","LACQUER","","6.1","1","","","","-","Basic Polymer: EP","100","","","","","","","","","","","","","","","","","","","","","1352233",""
"D","14","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","6.6","1","","Steel SPHC","","6","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","15","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","16","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","17","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","18","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
"D","19","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","1","Lacquer","","0.6","JAMAH4444","LACQUER","","6.1","1","","","","-","Basic Polymer: EP","100","","","","","","","","","","","","","","","","","","","","","1352233",""
"D","20","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAAAAAAA-W","WELDING","0.1","1","","Welding solid wires YGW11","","0.1","JISZ3312","YGW11","","1.1.1","1","","","","7439-89-6","Iron","100","","0","0","0","0","","","","","","","","","","","","","","","","1762",""
サンプルケースその2(22行)
(略)
コレは
親-部品A-材料A
親-部品A-材料B
親-部品B-材料A
親-部品B-材料B
親-部品C-材料A
親-部品C-材料B
親-溶接材-材料C
の場合
投票数:27
平均点:4.81
返信する
Re: JAMAシート入力方法を教えて下さい
msg# 1.4
TR_wada
投稿数: 1193
オンライン
"C","Ver.2.10","2010/05/06","正常終了","","EXLIST-2009-10-01JP.xls"
"H","","","","",""
"D","1","AAAAAAAAAA","BRACKET CONDENSER","13.1","","","1","","","","","","Welding solid wires YGW11","","0.1","JISZ3312","YGW11","","1.1.1","1","","","","7439-89-6","Iron","100","","0","0","0","0","","","","","","","","","","","","","","","","1762",""
"D","2","AAAAAAAAAA","BRACKET CONDENSER","","","","1","","","","","1","Lacquer","","1","JAMAH4444","LACQUER","","6.1","1","","","","-","Basic Polymer: EP","100","","","","","","","","","","","","","","","","","","","","","1352233",""
"D","3","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","2","1","","Steel SPHC","","2","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","4","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","5","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","6","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","7","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
"D","8","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","4","1","","Steel SPHC","","4","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","9","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","10","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","11","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","12","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
"D","13","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","6","1","","Steel SPHC","","6","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","14","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","15","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","16","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","17","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
サンプルケースその3(19行)
(略)
コレは
親-(空欄)-材料A
親-(空欄)-材料B
親-部品A-材料C
親-部品B-材料C
親-部品C-材料C
の場合
さっき『複数材料の記述ができないかも?』って言ってたけどできましたわ
この記述方法はJAMAシート限定になりますので注意
IMDS上では『材料と部品のデータを同レベルに置いてはいけない』というルールがあります
IMDS対応していない場合は関係ありませんが
"H","","","","",""
"D","1","AAAAAAAAAA","BRACKET CONDENSER","13.1","","","1","","","","","","Welding solid wires YGW11","","0.1","JISZ3312","YGW11","","1.1.1","1","","","","7439-89-6","Iron","100","","0","0","0","0","","","","","","","","","","","","","","","","1762",""
"D","2","AAAAAAAAAA","BRACKET CONDENSER","","","","1","","","","","1","Lacquer","","1","JAMAH4444","LACQUER","","6.1","1","","","","-","Basic Polymer: EP","100","","","","","","","","","","","","","","","","","","","","","1352233",""
"D","3","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","2","1","","Steel SPHC","","2","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","4","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","5","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","6","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","7","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00001","PARTS A","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
"D","8","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","4","1","","Steel SPHC","","4","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","9","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","10","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","11","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","12","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00002","PARTS B","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
"D","13","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","6","1","","Steel SPHC","","6","JISG3131","SPHC","","1.1.1","1","","","","7440-44-0","Carbon","0.075","","0","0","0","0","","","","","","","","","","","0","0.15","","","74761358","1995",""
"D","14","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","2","","","","7439-96-5","Manganese","0.30","","","","","","","","","","","","","","","","0","0.60","","","","2301",""
"D","15","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","3","","","","7723-14-0","Phosphorus","0.025","","","","","","","","","","","","","","","","0","0.050","","","","2835",""
"D","16","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","4","","","","7704-34-9","Sulphur","0.025","","","","","","","","","","","","","","","","0","0.050","","","","3065",""
"D","17","AAAAAAAAAA","BRACKET CONDENSER","","","","2","AAAAA00003","PARTS C","","1","","Steel SPHC","","","JISG3131","SPHC","","1.1.1","5","","","","7439-89-6","Iron","99.575","","","","","","","","","","","","","","","","","","1","","","1762",""
サンプルケースその3(19行)
(略)
コレは
親-(空欄)-材料A
親-(空欄)-材料B
親-部品A-材料C
親-部品B-材料C
親-部品C-材料C
の場合
さっき『複数材料の記述ができないかも?』って言ってたけどできましたわ
この記述方法はJAMAシート限定になりますので注意
IMDS上では『材料と部品のデータを同レベルに置いてはいけない』というルールがあります
IMDS対応していない場合は関係ありませんが
投票数:15
平均点:5.33
返信する
Re: JAMAシート入力方法を教えて下さい
msg# 1.5
TR_wada
投稿数: 1193
オンライン
おっといけない注釈を忘れてた
Steel SPHC
は仮に使用しています(登録済み材料なので成分的にはJIS基準)
Lacquer
Welding solid wires YGW11
の2つの材料は成分は仮のモノです
サプライヤーから成分を取り寄せてくださいね
溶接材は
▼コベルコ
http://www.kobelco.co.jp/welding/products/pamphlet/index.html
▼パナソニック溶接
http://industrial.panasonic.com/www-cgi/jvcr13pz.cgi?J+PS+5+AAK3003+0+4+JP
▼大同特殊鋼
http://www.daido.co.jp/products/weld/weld_5.html
といった感じに公開されてたりします(要Adobe Reader)
塗料については……溶剤揮発後の成分になるので、塗料メーカーにお願いするしかありません
成分開示を渋る可能性もありますが、
・最大10%までは情報秘匿OK
・GADSL記載物質の情報秘匿不可
▼GADSL
http://www.americanchemistry.com/s_plastics/blank.asp?CID=1106&DID=9290
・できればCAS No.で指定して欲しいですが、『エポキシ樹脂』等の広義的な名称で大体なんとかなります(エポキシ樹脂→ISOの表記で『EP』→『Basic Polymer: EP』で代用可能とかなります)
▼材料リスト補足説明資料(p.8)
http://www.japia.or.jp/work/data/Material_List_210_JP.pdf
といった感じでしょうか
Steel SPHC
は仮に使用しています(登録済み材料なので成分的にはJIS基準)
Lacquer
Welding solid wires YGW11
の2つの材料は成分は仮のモノです
サプライヤーから成分を取り寄せてくださいね
溶接材は
▼コベルコ
http://www.kobelco.co.jp/welding/products/pamphlet/index.html
▼パナソニック溶接
http://industrial.panasonic.com/www-cgi/jvcr13pz.cgi?J+PS+5+AAK3003+0+4+JP
▼大同特殊鋼
http://www.daido.co.jp/products/weld/weld_5.html
といった感じに公開されてたりします(要Adobe Reader)
塗料については……溶剤揮発後の成分になるので、塗料メーカーにお願いするしかありません
成分開示を渋る可能性もありますが、
・最大10%までは情報秘匿OK
・GADSL記載物質の情報秘匿不可
▼GADSL
http://www.americanchemistry.com/s_plastics/blank.asp?CID=1106&DID=9290
・できればCAS No.で指定して欲しいですが、『エポキシ樹脂』等の広義的な名称で大体なんとかなります(エポキシ樹脂→ISOの表記で『EP』→『Basic Polymer: EP』で代用可能とかなります)
▼材料リスト補足説明資料(p.8)
http://www.japia.or.jp/work/data/Material_List_210_JP.pdf
といった感じでしょうか
投票数:38
平均点:3.95
返信する
Re: JAMAシート入力方法を教えて下さい
msg# 1.1.1
ゆたか
返事が遅れてすいませんでした。
とても参考になりました。ありがとうございました。
また、分からないことがある時は、質問させてもらいます。
よろしくお願いします。
とても参考になりました。ありがとうございました。
また、分からないことがある時は、質問させてもらいます。
よろしくお願いします。
投票数:6
平均点:8.33
返信する
Re: JAMAシート入力方法を教えて下さい
msg# 1.6
TR_wada
投稿数: 1193
オンライン
お役に立てて何よりです。
『手近な聞ける人』が居ない方も多いと思いますので、何かありましたらどしどしご相談ください。私もまだまだとは思いますが、解る範囲でお答えします。
『手近な聞ける人』が居ない方も多いと思いますので、何かありましたらどしどしご相談ください。私もまだまだとは思いますが、解る範囲でお答えします。
投票数:1
平均点:0.00
返信する