{"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":[]}
[null,"B5",null,null,null,3,null,3878,{"$f":"COUNTA(#REF!)","v":1},null,{"$f":"COUNTIF(#REF!,\"<0\")","v":{"$error":"#REF!"}},null,"前回端末行→",{"$f":"H1","v":3878},null,{"$f":"(\"K\"&N1+1&\":\"&\"Q\"&N2)","v":"K3879:Q6"},"←コピー範囲",null,null," ","=COUNTA(B6:B10010)"]
[null," ",null,null,"【加工部品】",null,null,"前回cend値↑",{"$f":"SUBTOTAL(9,#REF!)","v":{"$error":"#REF!"}},null,{"$f":"SUBTOTAL(9,#REF!)","v":{"$error":"#REF!"}},null,"現在の行数→",{"$f":"(I1+5)","v":6},null,null,null,null,null,null,"=COUNTIF($K$6:$K$10020,\"<0\")"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=SUBTOTAL(9,I6:I10010)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=SUBTOTAL(9,K6:K10020)"]
[null,"製番",null,null,"品名",null,null,null,"数量","単価","金額","仕入先","仕入先コード",null,null,null,null,"入荷","印刷済",null,null,"製番",null,null,"品名",null,null,null,"数量","単価","金額","仕入先","仕入先コード"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":[]}