Re: JAMAシート入力方法を教えて下さい
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
返信する
この投稿に返信する
投稿ツリー
-
JAMAシート入力方法を教えて下さい
(ゆたか, 2010-4-29 15:40)
-
Re: JAMAシート入力方法を教えて下さい
(TR_wada, 2010-5-6 9:07)
- Re: JAMAシート入力方法を教えて下さい (ゆたか, 2010-5-25 17:51)
- Re: JAMAシート入力方法を教えて下さい (TR_wada, 2010-5-6 10:07)
- Re: JAMAシート入力方法を教えて下さい (TR_wada, 2010-5-6 10:12)
- Re: JAMAシート入力方法を教えて下さい (TR_wada, 2010-5-6 10:17)
- Re: JAMAシート入力方法を教えて下さい (TR_wada, 2010-5-7 10:08)
- Re: JAMAシート入力方法を教えて下さい (TR_wada, 2010-5-26 8:27)
-
Re: JAMAシート入力方法を教えて下さい
(TR_wada, 2010-5-6 9:07)