{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["加工DT","製作指示書注文","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"加工DT","index":0,"n_rows":789,"n_cols":33,"rows_kept":789,"cut":false,"hidden":false,"merged":[[2,6,2,11],[1,0,1,2],[1,6,1,13]]}
[null,"B5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["加工注文データベース",null,null,null,"【加工部品】",null,"ファイル名を加工部品注文データベース.xlsmでEドライブに保存してください。"]
[null,null,null,null,null,null,"マクロではその名前になっていますから。"]
[]
[null,"製　番","品番1","品番2","　　　　品名",null,null,"備考","数量","単価","金額","仕入先名","仕入先コード","納","期","製品納期","注文書No","入荷","印刷済",null,null,"製番",null,null,"品名",null,null,null,"数量","単価","金額","仕入先","仕入先コード"]
[null,"A-3544","A1","01","ガイドフランジ",null,null,"A-900",1,500,500,"AAAA",166,11,30,"2018-02-02","OZ19567","●"]
[null,"A-3544","A1","02","ガイドフランジ",null,null,"A-900",2,600,1200,"AAAA",166,11,30,"2018-02-02","OZ19568","●"]
[null,"A-3544","A1","03","ガイドフランジ",null,null,"A-900",2,800,1600,"AAAA",166,11,30,"2018-02-02","OZ19568","●"]
[null,"A-3544","A1","04","ガイドフランジ",null,null,"A-900",1,500,500,"AAAA",166,11,30,"2018-02-02","OZ19568","●"]
[null,"A-3544","A1","05","ガイドフランジ",null,null,"A-900",1,500,500,"AAAA",166,11,30,"2018-02-02","OZ19568","●"]
[null,"A-3544","A1","06","ガイドフランジ",null,null,"A-900",2,1000,2000,"AAAA",166,11,30,"2017-12-08","OZ19569","●"]
[null,"A-3544","A1","07","ガイドフランジ",null,null,"A-900",2,1000,2000,"AAAA",166,11,30,"2017-12-08","OZ19569","●"]
[null,"A-3544","A1","08","ガイドフランジ",null,null,"A-900",2,1500,3000,"AAAA",166,11,30,"2017-12-08","OZ19569","●"]
[null,"A-3544","A1","09","ガイドフランジ",null,null,"A-900",1,1000,1000,"AAAA",166,11,30,"2017-12-08","OZ19570","●"]
[null,"A-3544","A1","10","ガイドフランジ",null,null,"A-900",1,1000,1000,"AAAA",166,11,30,"2017-12-08","OZ19570","●"]
[null,"A-3544","A1","11","ガイドフランジ",null,null,"A-900",1,1500,1500,"AAAA",166,11,30,"2017-12-08","OZ19570","●"]
[null,"A-3544","A1","12","ガイドフランジ",null,null,"A-900",2,1500,3000,"AAAA",166,11,30,"2017-12-08","OZ19571","●"]
[null,"CC-1863","01","02","AAAA",null,null,null,1,100,100,"AAAA",6,2,17,null,null,"●"]
[null,"A-3544","A1","14","ガイドフランジ",null,null,"A-900",9,1000,9000,"AAAA",166,2,17,"2017-11-30","OZ19573","●"]
[null,"A-3545","A1","01","ガイドフランジ",null,null,"A-900",1,4500,4500,"AAAA",166,2,17,"2017-11-30","OZ19573","●"]
[null,"A-3545","A1","02","ガイドフランジ",null,null,"A-900",2,3500,7000,"AAAA",166,2,17,"2017-11-30","OZ19573","●"]
[null,"A-3545","A1","03","ガイドフランジ",null,null,"A-900",2,5000,10000,"AAAA",166,2,17,"2017-11-30","OZ19573","●"]
[null,"A-3545","A1","04","ガイドフランジ",null,null,"A-900",10,9400,94000,"AAAA",166,2,17,"2017-11-30","OZ19574","●"]
[null,"A-3545","A1","05","ガイドフランジ",null,null,"A-900",10,9400,94000,"AAAA",166,2,17,"2017-11-30","OZ19574","●"]
[null,"A-3545","A1","06","ガイドフランジ",null,null,"A-900",1,1000,1000,"AAAA",166,2,17,"2017-12-22","HA8126","●"]
[null,"A-3545","A1","07","ガイドフランジ",null,null,"A-900",1,1000,1000,"AAAA",166,2,17,"2017-12-22","HA8127","●"]
[null,"A-3545","A1","08","ガイドフランジ",null,null,"A-900",1,1000,1000,"AAAA",166,2,17,"2017-12-22","HA8128","●"]
[null,"A-3545","A1","09","ガイドフランジ",null,null,"A-900",1,1000,1000,"AAAA",166,2,17,"2017-12-15","HA8129","●"]
[null,"A-3545","A1","10","ガイドフランジ",null,null,"A-900",1,1000,1000,"AAAA",166,2,17,"2018-01-10","HA8130","●"]
[null,"A-3545","A1","11","ガイドフランジ",null,null,"A-900",1,1000,1000,"AAAA",166,2,17,"2018-01-17","HA8131","●"]
[null,"A-1234","01","1","ｂ",null,null,"s",1,100,100,"BBBB",2,2,17,"2020-09-12","HA9101","●"]
[null,"A-1234","02","2","ｎ",null,null,null,2,200,400,"BBBB",2,2,17,"2020-09-12","HA9101","●"]
[null,"A-1234","03","3","ｍ",null,null,null,1,300,300,"BBBB",2,2,17,"2020-09-12","HA9101","●"]
[null,"A-1235","01","1","ｂ",null,null,"s",1,100,100,"BBBB",2,2,17,"2020-09-12","HA9102","●"]
[null,"A-1235","02","2","ｎ",null,null,null,2,200,400,"BBBB",2,2,17,"2020-09-12","HA9102","●"]
[null,"A-1235","03","3","ｍ",null,null,null,1,300,300,"BBBB",2,2,17,"2020-09-12","HA9102","●"]
[null,"A-1236","01","1","ｂ",null,null,"s",1,100,100,"BBBB",2,2,17,"2020-09-12","HA9103","●"]
[null,"A-1236","02","2","ｎ",null,null,null,2,200,400,"BBBB",2,2,17,"2020-09-12","HA9103","●"]
[null,"A-1236","03","3","ｍ",null,null,null,1,300,300,"BBBB",2,2,17,"2020-09-12","HA9103","●"]
[null,"A-1234","01","1","ｂ",null,null,"s",1,100,0,"BBBB",2,2,17,"2020-09-12","HA9101","●"]
[null,"A-1234","02","2","ｎ",null,null,"p",2,200,0,"BBBB",2,2,17,"2020-09-12","HA9101","●"]
["★","A-1234","03","3","mix",null,null,"q",2,300,0,"BBBB",2,2,17,"2020-09-12","HA9101","●"]
[null,"A-1235","01","1","ｂ",null,null,"s",1,100,0,"BBBB",2,2,17,"2020-09-12","HA9102","●"]
[null,"A-1235","02","2","ｎ",null,null,"p",2,200,0,"BBBB",2,2,17,"2020-09-12","HA9102","●"]
[null,"A-1235","03","3","ｍ",null,null,"q",1,300,0,"BBBB",2,2,17,"2020-09-12","HA9102","●"]
[null,"A-1236","01","1","ｂ",null,null,"s",1,100,0,"BBBB",2,2,17,"2020-09-12","HA9103","●"]
[null,"A-1236","02","2","ｎ",null,null,"p",2,200,0,"BBBB",2,2,17,"2020-09-12","HA9103","●"]
[null,"A-1236","03","3","ｍ",null,null,"q",1,300,0,"BBBB",2,2,17,"2020-09-12","HA9103","●"]
[null,"A-1237","01","01","ｓｓ",null,null,"y",1,100,0,"CCCC",3,2,17,"2020-08-18","HA9113","●"]
[null,"A-1237","02","01","ｄｄ",null,null,"y",3,200,0,"CCCC",3,2,17,"2020-08-18","HA9113","●"]
["★","A-1237","03","01","gg",null,null,"y",2,300,0,"CCCC",3,2,17,"2020-08-18","HA9113","●"]
[null,"A-1238","01","01","ｓｓ",null,null,"y",1,100,0,"CCCC",3,2,17,"2020-08-18","HA9114","●"]
[null,"A-1238","02","01","ｄｄ",null,null,"y",3,200,0,"CCCC",3,2,17,"2020-08-18","HA9114","●"]
["★","A-1238","03","01","ｇｇ",null,null,"y",2,300,0,"CCCC",3,2,17,"2020-08-18","HA9114","●"]
[null,"A-1239","01","01","ｓｓ",null,null,"y",1,100,0,"CCCC",3,2,17,"2020-08-18","HA9115","●"]
[null,"A-1239","02","01","ｄｄ",null,null,"y",3,200,0,"CCCC",3,2,17,"2020-08-18","HA9115","●"]
[null,"A-1239","03","01","ｇｇ",null,null,"y",1,300,0,"CCCC",3,2,17,"2020-08-18","HA9115","●"]
[null,"B-1234","01","01","ｓ",null,null,"v",1,100,0,"CCCC",3,2,17,"2020-08-18","HA9116","●"]
["★","B-1234","02","02","ｆ",null,null,"v",3,200,0,"CCCC",3,2,17,"2020-08-18","HA9116","●"]
[null,"B-1235","01","01","ｓ",null,null,"v",1,100,0,"CCCC",3,2,17,"2020-08-18","HA9117","●"]
[null,"B-1235","02","02","ｆ",null,null,"v",2,200,0,"CCCC",3,2,17,"2020-08-18","HA9117","●"]
[null,"B-1236","01","01","ｓ",null,null,"v",1,100,0,"CCCC",3,2,17,"2020-08-18","HA9118","●"]
[null,"B-1236","02","02","ｆ",null,null,"v",2,200,0,"CCCC",3,2,17,"2020-08-18","HA9118","●"]
[null,"B-1237","01","01","ｓ",null,null,"v",1,100,0,"CCCC",3,2,17,"2020-08-18","HA9119","●"]
[null,"B-1237","02","02","ｆ",null,null,"v",2,200,0,"CCCC",3,2,17,"2020-08-18","HA9119","●"]
[null,"B-1238","01","01","ｓ",null,null,"v",1,100,0,"CCCC",3,2,17,"2020-08-18","HA9120","●"]
[null,"B-1238","02","02","ｆ",null,null,"v",2,200,0,"CCCC",3,2,17,"2020-08-18","HA9120","●"]
[null,"B-2135","01","01","ｓ",null,null,"v",1,100,0,"CCCC",3,2,17,"2020-08-18","HA9121","●"]
[null,"B-2135","02","02","ｆ",null,null,"v",2,200,0,"CCCC",3,2,17,"2020-08-18","HA9121","●"]
[null,"B-2136","01","01","ｓ",null,null,"v",1,100,0,"CCCC",3,2,17,"2020-08-18","HA9122","●"]
[null,"B-2136","02","02","ｆ",null,null,"v",2,200,0,"CCCC",3,2,17,"2020-08-18","HA9122","●"]
[null,"B-2137","01","01","ｓ",null,null,"v",1,100,0,"CCCC",3,2,17,"2020-08-18","HA9123","●"]
[null,"B-2137","02","02","ｆ",null,null,"v",2,200,0,"CCCC",3,2,17,"2020-08-18","HA9123","●"]
[null,"B-2138","01","01","ｓ",null,null,"v",1,100,0,"CCCC",3,2,17,"2020-08-18","HA9124","●"]
[null,"B-2138","02","02","ｆ",null,null,"v",2,200,0,"CCCC",3,2,17,"2020-08-18","HA9124","●"]
[null,"B-2212","01","01","ｓ",null,null,"v",1,100,0,"CCCC",3,2,17,"2020-08-18","HA9125","●"]
[null,"B-2212","02","02","ｆ",null,null,"v",2,200,0,"CCCC",3,2,17,"2020-08-18","HA9125","●"]
[null,"B-2213","01","01","ｓ",null,null,"v",1,100,0,"CCCC",3,2,17,"2020-08-18","HA9126","●"]
[null,"B-2213","02","02","ｆ",null,null,"v",2,200,0,"CCCC",3,2,17,"2020-08-18","HA9126","●"]
[null,"B-2214","01","01","ｓ",null,null,"v",1,100,0,"CCCC",3,2,17,"2020-08-18","HA9127","●"]
[null,"B-2214","02","02","ｆ",null,null,"v",2,200,0,"CCCC",3,2,17,"2020-08-18","HA9127","●"]
[null,"B-2215","01","01","ｓ",null,null,"v",1,100,0,"CCCC",3,2,17,"2020-08-18","HA9128","●"]
[null,"B-2215","02","02","ｆ",null,null,"v",2,200,0,"CCCC",3,2,17,"2020-08-18","HA9128","●"]
[null,"B-1313","01","01","ｓｓ",null,null,"y",1,100,100,"CCCC",3,2,17,"2017-07-19","HA9146","●"]
[null,"B-1313","02","01","ｄｄ",null,null,"y",3,200,600,"CCCC",3,2,17,"2017-07-19","HA9146","●"]
[null,"B-1313","03","01","ｇｇ",null,null,"y",1,300,300,"CCCC",3,2,17,"2017-07-19","HA9146","●"]
[null,"A-1234","A1","01","ｓｓｓｓ",null,null,null,1,100,100,"CCCC",3,2,17,"2017-06-01","SI2003","●"]
[null,"A-1234","A1","02","ｄｄｄｄ",null,null,null,2,200,400,"CCCC",3,2,17,"2017-06-01","SI2003","●"]
["★","A-1234","A1","03","ｃｃｃｃ",null,null,null,2,300,600,"CCCC",3,2,17,"2017-06-01","SI2003","●"]
[null,"A-1235","A1","01","ｓｓｓｓ",null,null,null,1,100,100,"CCCC",3,2,17,"2017-06-01","SI2004","●"]
[null,"A-1235","A1","02","ｄｄｄｄ",null,null,null,2,200,400,"CCCC",3,2,17,"2017-06-01","SI2004","●"]
[null,"A-1235","A1","03","ｃｃｃｃ",null,null,null,1,300,300,"CCCC",3,2,17,"2017-06-01","SI2004","●"]
[null,"A-1236","A1","01","ｓｓｓｓ",null,null,null,1,100,100,"CCCC",3,2,17,"2017-06-01","SI2005","●"]
[null,"A-1236","A1","02","ｄｄｄｄ",null,null,null,2,200,400,"CCCC",3,2,17,"2017-06-01","SI2005","●"]
[null,"A-1236","A1","03","ｃｃｃｃ",null,null,null,1,300,300,"CCCC",3,2,17,"2017-06-01","SI2005","●"]
[null,"A-1240","A1","01","ｓｓｓｓ",null,null,null,1,100,100,"CCCC",3,2,17,"2017-06-01","SI2006","●"]
[null,"A-1240","A1","02","ｄｄｄｄ",null,null,null,2,200,400,"CCCC",3,2,17,"2017-06-01","SI2006","●"]
[null,"A-1240","A1","03","ｃｃｃｃ",null,null,null,1,300,300,"CCCC",3,2,17,"2017-06-01","SI2006","●"]
[null,"A-1241","A1","01","ｓｓｓｓ",null,null,null,1,100,100,"CCCC",3,2,17,"2017-06-01","SI2007","●"]
[null,"A-1241","A1","02","ｄｄｄｄ",null,null,null,2,200,400,"CCCC",3,2,17,"2017-06-01","SI2007","●"]
[null,"A-1241","A1","03","ｃｃｃｃ",null,null,null,1,300,300,"CCCC",3,2,17,"2017-06-01","SI2007","●"]
[null,"A-1242","A1","01","ｓｓｓｓ",null,null,null,1,100,100,"CCCC",3,2,17,"2017-06-01","SI2008","●"]
[null,"A-1242","A1","02","ｄｄｄｄ",null,null,null,2,200,400,"CCCC",3,2,17,"2017-06-01","SI2008","●"]
[null,"A-1242","A1","03","ｃｃｃｃ",null,null,null,1,300,300,"CCCC",3,2,17,"2017-06-01","SI2008","●"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]

{"sheet":"製作指示書注文","index":1,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,3,1,8],[2,3,2,8]]}
[]
[null,null,null,"ファイル名を加工注文データベース.xlsmでEドライブに保存してください。"]
[null,null,null,"マクロではその名前になっていますから。"]
[]
[null,"コードNo","品名","型式","メーカー","数量","単価","金額","注番","仕入先コード","仕入先名"]
[null,900035,"aaa","a-1234",null,10,1000,10000,"G-1035",403,"THN㈱"]
[null,900035,"bbbb","b-1234",null,10,1200,12000,"G-1035",403,"THN㈱"]
[null,900035,"ccc","c-1234",null,10,1400,14000,"G-1035",403,"THN㈱"]
[null,900035,"dddd","d-1234",null,10,1600,16000,"G-1035",403,"THN㈱"]
[null,900035,"eee","e-1234",null,10,1800,18000,"G-1035",403,"THN㈱"]
[null,900035,"ffff","f-1234",null,10,2000,20000,"G-1035",403,"THN㈱"]
[null,900035,"ggg","g-1234",null,10,2200,22000,"G-1035",403,"THN㈱"]
[null,900036,"aaa","a-1234",null,10,1000,10000,"G-1036",403,"THN㈱"]
[null,900036,"bbbb","b-1234",null,10,1200,12000,"G-1036",403,"THN㈱"]
[null,900036,"ccc","c-1234",null,10,1400,14000,"G-1036",403,"THN㈱"]
[null,900036,"dddd","d-1234",null,10,1600,16000,"G-1036",403,"THN㈱"]
[null,900036,"eee","e-1234",null,10,1800,18000,"G-1036",403,"THN㈱"]
[null,900036,"ffff","f-1234",null,10,2000,20000,"G-1036",403,"THN㈱"]
[null,900037,"aaa","a-1234",null,10,1000,10000,"G-1037",403,"THN㈱"]
[null,900037,"bbbb","b-1234",null,10,1200,12000,"G-1037",403,"THN㈱"]
[null,900040,"aaaa","a-1234",null,10,1000,10000,"G-1040",403,"THN㈱"]
[null,900040,"bbbb","b-1234",null,10,1200,12000,"G-1040",403,"THN㈱"]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet2","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}