{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["メニュー","部品","購入品","材料","コード","DAT1","発行番号","購入転送","加工転送","材料転送","契約一覧"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"メニュー","index":0,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[23,4,23,6],[2,3,2,5],[4,3,4,7],[7,4,7,6],[9,4,9,6],[11,4,11,6],[13,4,13,6],[15,4,15,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[21,4,21,6]]}
[" "]
[]
[null,null,null,"　　　　更新 2020/10/1",null,null," "]
[null,null,null,null,null,null,null,null,null,null,"使用者名"]
[null,null,null,"部品発注メニュー",null,null,null,null,null,null,"YAMADA"]
[]
[]
[null,null,null,null,"　"]
[]
[null,null,null,null,"　",null,null,null,null,null,"****"]
[]
[null,null,null,null,"　"]
[]
[null,null,null,null,"　"]

{"sheet":"部品","index":1,"n_rows":26,"n_cols":27,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,2,0,3],[1,2,1,3],[1,5,1,7],[1,8,1,17],[2,2,2,3],[2,4,2,5],[2,12,2,13],[2,14,2,17],[2,18,2,19],[3,12,3,17],[3,18,3,19],[4,6,5,6],[4,7,5,9],[4,13,4,17],[11,4,11,5],[11,7,11,11],[11,12,11,13],[11,14,11,17],[5,2,5,5],[5,13,5,17],[6,2,6,5],[6,13,6,17],[7,4,8,5],[8,2,8,3],[8,14,8,17],[10,2,10,3],[10,4,10,5],[10,7,10,11],[10,12,10,13],[10,14,10,17],[12,4,12,5],[12,7,12,11],[12,12,12,13],[12,14,12,17],[13,4,13,5],[13,7,13,11],[13,12,13,13],[13,14,13,17],[14,4,14,5],[14,7,14,11],[14,12,14,13],[14,14,14,17],[15,4,15,5],[15,7,15,11],[15,12,15,13],[15,14,15,17],[16,4,16,5],[16,7,16,11],[16,12,16,13],[16,14,16,17],[17,4,17,5],[17,7,17,11],[17,12,17,13],[17,14,17,17],[18,4,18,5],[18,7,18,11],[18,12,18,13],[18,14,18,17],[19,7,19,11],[19,14,19,17],[20,2,20,5],[20,6,22,13],[20,14,22,17],[21,2,21,5],[22,2,22,5]]}
[".",null,"仕入先コード",null,2,"加工部品注文書",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(加工転送!R5>0,加工転送!AR5>0),1,0)","v":1},0,0,0,0]
[null," ","注文書No",null,{"$f":"'DAT1'!D7","v":"YA3007"},"注文書　兼　納品書",null,null,"　　左記の納品書を丸で囲み金額欄に　　　　　　　　　　　　　　　記入すれば納品書になります。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1=不良製番","1=判定回避","部品は0","入力開始使用時1"]
[null,null,{"$f":"E1","v":2},null,{"$f":"VLOOKUP(E1,コード!B5:C25,2)","v":"BBBB"},null,"　御中　",null,null,null,null,"　","発注日",null,{"$f":"TODAY()","v":"2020-09-07"}]
[null,null,null,null,null,"様",null,null,null,null,null,null,"㈱ABCD"]
[null,null,"いつもお世話になり有難うございます。",null,null,null,"製品納期",null,null,null,null,null,null," "]
[null,null,"下記内容にて発注しますので手配宜しくお願い致します。",null,null,null,null,null,null,null,null,null,null,"   TEL（06）1234-1234"]
[null,null," ",null,null,null,null,null,null,null,null,null,null,"   FAX（06）1234-1235",null,null,null,null,null,null,null,null,"製番台数"]
[]
[null,null,"製番",null,null,null,"納入日",null,null,"月",null,"日",null,"発行者",{"$f":"メニュー!K5","v":"YAMADA"},null,null,null,null,null,null,null,{"$f":"COUNTA(W11:W26)-1","v":0},null,1]
[]
[1,null,"品　番",null,"品　　　　　名",null,"数　量","備　　考",null,null,null,null,"単　価",null,"金　　　額",null,null,null,null,null,null,null,"入力製番一覧","注番","検索結果製番",{"$f":"SUM(Z12:Z19)","v":6},"商品コード"]
[null,1,"01","1","ｂ",null,1,"s",null,null,null,null,100,null,{"$f":"+IF(M12=\"\",\"\",IF(CODE(M12)=32,\"\",IF(CODE(M12)=8481,\"\",IF(CODE(G12)>57,\"\",G12*M12))))","v":100},null,null,null,2000,null,null,1,null,null,null,{"$f":"IF(G12=\"\",\"\",1)","v":1}]
[null,2,"02","2","ｎ",null,2,null,null,null,null,null,200,null,400,null,null,null,null,null,null,2,null,null,null,1]
[null,3,"03","3","ｍ",null,1,null,null,null,null,null,300,null,300,null,null,null,null,null,null,3,null,null,null,1]
[null,4,"01","1","ｂ",null,1,"s",null,null,null,null,100,null,100,null,null,null,null,null,null,4,null,null,null,1]
[null,5,"02","2","ｎ",null,2,"p",null,null,null,null,200,null,400,null,null,null,null,null,null,5,null,null,null,1]
[null,6,"03","3","ｍ",null,1,"q",null,null,null,null,300,null,300,null,null,null,null,null,null,6,null,null,null,1]
[null,7,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,7,null,null,null,""]
[null,8,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(M19=\"\",\"\",IF(CODE(M19)=32,\"\",IF(CODE(M19)=8481,\"\",G19*M19)))","v":""},null,null,null,null,null,null,8,null,null,null,""]
[null,null," ",null," "," "," "," ",null,null,null,null," ","合計",{"$f":"IF(COUNT(G12:G19)=COUNT(M12:M19),SUM(O12:R19),\"\")","v":1600},null,null,null,null,null,null,9]
[null,null,null,null,null,null,"納入会社名",null,null,null,null,null,null,null,"納入日",null,null,null,null,null,null,10]
[null,"　",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,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,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]

{"sheet":"購入品","index":2,"n_rows":26,"n_cols":27,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,2,1,3],[1,5,1,7],[1,10,1,14],[1,15,1,17],[2,2,2,3],[2,4,2,5],[2,14,2,17],[3,12,3,17],[4,6,5,6],[4,7,5,9],[4,13,4,17],[5,2,5,5],[5,13,5,17],[12,7,12,11],[12,14,12,17],[6,2,6,5],[6,13,6,17],[7,4,8,5],[8,2,8,3],[8,6,8,7],[8,14,8,17],[10,2,10,3],[10,7,10,11],[10,14,10,17],[11,7,11,11],[11,14,11,17],[13,7,13,11],[13,14,13,17],[14,7,14,11],[14,14,14,17],[15,7,15,11],[15,14,15,17],[16,7,16,11],[16,14,16,17],[17,7,17,11],[17,14,17,17],[18,7,18,11],[18,14,18,17],[19,7,19,11],[19,14,19,17],[20,2,20,5],[20,6,22,13],[20,14,22,17],[21,2,21,5],[22,2,22,5]]}
["-",null,"仕入先コード",null,5,"購入品注文書",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"購入転送!R5","v":8},0,0,1,0]
[null,null,"注文書No",null,{"$f":"'DAT1'!D7","v":"YA3007"},"注文書　兼　納品書",null,null,"　",null,"左記の納品書を丸で囲み金額欄に　　　　　　　　　  　　記入すれば納品書になります。",null,null,null,null,null,null,null,null,null,null,null,null,"1=不良製番","1=判定回避","購入は1","入力開始使用時1"]
[null,null,null,null,{"$f":"VLOOKUP(E1,コード!B5:C25,2)","v":"EEEE"},null,"　御中　",null,null,null,null,"　",null,"発注日",{"$f":"TODAY()","v":"2020-09-07"}]
[null,null,null,null,null,"様",null,null,null,null,null,null,"㈱ABCD"]
[null,null,"いつもお世話になり有難うございます。",null,null,null,"製品納期",null,null,null,null,null,null," "]
[null,null,"下記内容にて発注しますので手配宜しくお願い致します。",null,null,null,null,null,null,null,null,null,null,"   TEL（06）1234-1234"]
[null,null," ",null,null,null,null,null,null,null,null,null,null,"   FAX（06）1234-1235",null,null,null,null,null,null,null,null,"製番台数"]
[]
[null,null,"製番",null,null,null,"納入日",null,null,"月",null,"日",null,"発行者",{"$f":"メニュー!K5","v":"YAMADA"},null,null,null,null,null,null,null,{"$f":"COUNTA(W11:W31)-1","v":0},null,null,"入力行数"]
[]
[null,null,"品　番",null,"品　　　　　名","型　　　　　式","メーカー","備　　考",null,null,null,null,"数　量","単　　価","金　　　額",null,null,null,null,null,null,null,"入力製番一覧","注番","検索結果製番",{"$f":"SUM(Z12:Z19)","v":3},"商品コード"]
[null,1,"01","01","ｇ","ff","a","ｈ",null,null,null,null,2,100,{"$f":"+IF(N12=\"\",\"\",IF(CODE(N12)=32,\"\",IF(CODE(N12)=8481,\"\",M12*N12)))","v":200},null,null,null,".",null,null,1,null,null,"HA9130",{"$f":"IF(M12=\"\",\"\",1)","v":1}]
[null,2,"01","02","ｈ","dddd","ｂ","ｈ",null,null,null,null,1,200,{"$f":"+IF(N13=\"\",\"\",IF(CODE(N13)=32,\"\",IF(CODE(N13)=8481,\"\",M13*N13)))","v":200},null,null,null,null,null,null,2,null,null,"HA9131",{"$f":"IF(M13=\"\",\"\",1)","v":1}]
[null,3,"01","03","ｊ","vvvv","ｃ","ｈ",null,null,null,null,2,300,600,null,null,null,null,null,null,3,null,null,"HA9132",1]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,4,null,null,"HA9133",""]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,5,null,null,"HA9134",""]
[null,6,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,6,null,null,"HA9135",""]
[null,7,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,7,null,null,"HA9136",""]
[null,8,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,8,null,null,"HA9137",""]
[null,null," ",null," "," "," "," ",null,null,null,null," ","合計",{"$f":"IF(SUM(O12:R19)=0,\"\",IF(COUNT(M12:M19)=COUNT(N12:N19),SUM(O12:R19),\"\"))","v":1000},null,null,null,null,null,null,9,null,null,"HA9138"]
[null,null,null,null,null,null,"納入会社名",null,null,null,null,null,null,null,"納入日",null,null,null,null,null,null,10]
[null,"　",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,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,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]

{"sheet":"材料","index":3,"n_rows":46,"n_cols":27,"rows_kept":46,"cut":false,"hidden":false,"merged":[[18,7,18,14],[18,17,18,20],[19,2,19,15],[19,17,19,20],[20,2,20,8],[20,9,22,16],[20,17,22,20],[21,2,21,8],[22,2,22,8],[15,7,15,14],[15,17,15,20],[16,7,16,14],[16,17,16,20],[17,7,17,14],[17,17,17,20],[12,7,12,14],[12,17,12,20],[13,7,13,14],[13,17,13,20],[14,7,14,14],[14,17,14,20],[10,2,10,3],[10,6,10,14],[10,17,10,20],[11,7,11,14],[11,17,11,20],[6,16,6,20],[7,4,8,7],[8,2,8,3],[8,9,8,10],[8,17,8,20],[3,15,3,20],[4,8,5,8],[4,9,5,11],[4,16,4,20],[5,16,5,20],[1,13,1,17],[1,18,1,20],[2,2,2,3],[2,4,2,7],[2,17,2,20],[0,4,0,5],[0,6,0,7],[1,2,1,3],[1,4,1,5],[1,6,1,10]]}
[null,null,"仕入先コード",null,5,null,"   材料注文書",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"材料転送!R5","v":6},0,0,2,1]
[null,null,"注文書No",null,{"$f":"'DAT1'!D7","v":"YA3007"},null,"注文書  兼  納品書",null,null,null,null,null,null,"左記の納品書を丸で囲み金額欄に　　　　　　記入すれば納品書になります。",null,null,null,null,null,null,null,null,null,"1=不良製番","1=判定回避","材料は2","入力開始使用時1"]
[null,null," ",null,{"$f":"VLOOKUP(E1,コード!B5:C25,2)","v":"EEEE"},null,null,null,"　御中　","　",null,null,null,null,"　",null,"発注日",{"$f":"TODAY()","v":"2020-09-07"}]
[null,null,null,null,null,null,null,"様",null,null,null,null,null,null,null,"㈱ABCD"]
[null,null,"いつもお世話になり有難うございます。",null,null,null,null," ","製品納期","2017-06-01",null,null,null,null,null,null," "]
[null,null,"下記内容にて発注しますので手配宜しくお願い致します。",null,null,null,null,null,null,null,null,null,null,null,null,null,"   TEL（06）1234-1234"]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,"   FAX（06）1234-1235",null,null,null,null,null,"製番台数"]
[null,null,null,null,"A-1234. 1235. 1236. 1237. 1238"]
[null,null,"製番",null,null,null,null,null,null,"納入日",null,10,"月",15,"日",null,"発行者",{"$f":"メニュー!K5","v":"YAMADA"},null,null,null,null,{"$f":"COUNTA(W11:W25)-1","v":5},null,null,"入力行数"]
[]
[null,null,"品　番",null,"細　　品番","材　質","形　　　　状　　・　　　　　　寸　　　　　法",null,null,null,null,null,null,null,null,"数　量","単価","金　　　額",null,null,null,null,"入力製番一覧","注番","検索結果製番",{"$f":"SUM(Z12:Z19)","v":2},"商品コード"]
[null,1,"A1","01","1","SS-400D","丸材","30*1000",null,null,null,null,null,null,null,5,100,{"$f":"IF(Q12=\"\",\"\",IF(CODE(Q12)=32,\"\",IF(CODE(Q12)=8481,\"\",P12*Q12)))","v":500},null,null,null,null,"A-1234","HA9153",null,{"$f":"IF(P12=\"\",\"\",1)","v":1}]
[null,2,"A1","02","1","S45C-D","角材","100*100*300",null,null,null,null,null,null,null,5,300,{"$f":"IF(Q13=\"\",\"\",IF(CODE(Q13)=32,\"\",IF(CODE(Q13)=8481,\"\",P13*Q13)))","v":1500},null,null,null,null,"A-1235","HA9154",null,1]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"A-1236","HA9155",null,""]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"A-1237","HA9156",null,""]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"A-1238","HA9157",null,""]
[null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,""]
[null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,""]
[null,8,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,"合　　計",{"$f":"IF(SUM(R12:U19)=0,\"\",IF(COUNT(P12:P19)=COUNT(Q12:Q19),SUM(R12:U19),\"\"))","v":2000}]
[null,null,"HA9153/HA9154/HA9155/HA9156/HA9157 /5台分手配",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,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,"SS-41","FB"]
[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,"SS-41D","ｱﾝｸﾞﾙ"]
[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,"SS-400","丸材"]
[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,"SS-400D","角材"]
[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,"S45C","六角材"]
[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,"S45C-D","丸パイプ"]
[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,"S35C","角パイプ"]
[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,"S35C-D","ﾁｬﾝﾈﾙ"]
[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,"SK-3","リップ溝鋼"]
[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,"SKS-3","H形鋼"]
[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,"STKM13A","姿切り"]
[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,"SCM-435","STKM13A"]
[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,"SKD-11"]
[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,"SUS308"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[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,2]
[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,3]

{"sheet":"コード","index":4,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"仕入先登録"]
[null,"コードNO","仕入先名"]
[null,0]
[null,1,"AAAA","コードNOの付けかた"]
[null,2,"BBBB","材料","1から100"]
[null,3,"CCCC","外注加工","101から200"]
[null,4,"DDDD","外注加工","601から700"]
[null,5,"EEEE"]
[null,6,"FFFF","購入品","201から300"]
[null,7,"GGGG","購入品","701から800"]
[null,8,"HHHH"]
[null,9,"JJJJ","外注設計","301から400"]
[null,10,"KKKK","外注電装","401から500"]
[null,11,"LLLL","外注組立","501から600"]
[null,12,"MMMM"]
[null,13,"NNNN"]
[null,14,"PPPP"]
[null,15,"QQQQ"]
[null,16,"RRRR"]
[null,17,"SSSS"]
[null,18,"TTTT"]
[null,19,"UUUU"]
[null,20,"VVVV"]

{"sheet":"DAT1","index":5,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,"メニューK5-ドロップDW"]
[null,null,"初期値",1001,null,null,null,null,"記号","名前",null,"標準製番",null,"月","日"]
[null,null,"前回値",3006,"印刷時に現在値を入れる",null,null,null,"KY",null,null,"A-1",null,1,1]
[null,null,"現在値",{"$f":"D4+1","v":3007}," ",null,null,null,"KR",null,null,"A-2",null,2,2]
[null,null,"担当者記号","YA",null," ",null,null,"HA",null,null,"B-1",null,3,3]
[null,null,{"$f":"部品!C2","v":"注文書No"},{"$f":"$D$6&D5","v":"YA3007"},null,null,null,null,"AN",null,null,"B-2",null,4,4]
[null,null,"ページ2",{"$f":"$D$6&$D$5+1","v":"YA3008"},null,null,null,null,"KW",null,null,"C-1",null,5,5]
[null,null,"ページ3",{"$f":"$D$6&$D$5+2","v":"YA3009"},null,null,null,null,"UB",null,"　","C-2",null,6,6]
[null,null,"ページ4",{"$f":"$D$6&$D$5+3","v":"YA3010"},null,null,null,null,"OZ",null,null,"D-1",null,7,7]
[null,null,"ページ5",{"$f":"$D$6&$D$5+4","v":"YA3011"},null,null,null,null,"TE",null,null,"D-2",null,8,8]
[null,null,"ページ6",{"$f":"$D$6&$D$5+5","v":"YA3012"},null,null,null,null,null,null,null,"E-1",null,9,9]
[null,null,"ページ7",{"$f":"$D$6&$D$5+6","v":"YA3013"},null,null,null,null,null,null,null,"E-2",null,10,10]
[null,null,"ページ8",{"$f":"$D$6&$D$5+7","v":"YA3014"},null,null,null,null,null,null,null,"T-1",null,11,11]
[null,null,"ページ9",{"$f":"$D$6&$D$5+8","v":"YA3015"},null,null,null,null,null,null,null,"T-2",null,12,12]
[null,null,"ページ10",{"$f":"$D$6&$D$5+9","v":"YA3016"},null,null,null,null,null,null,null,null,null,null,13]
[null,null,"ページ11",{"$f":"$D$6&$D$5+10","v":"YA3017"},null,null,null,null,null,null,null,null,null,null,14]
[null,null,"ページ12",{"$f":"$D$6&$D$5+11","v":"YA3018"},null,null,null,null,null,null,null,null,null,null,15]
[null,null,"ページ13",{"$f":"$D$6&$D$5+12","v":"YA3019"},null,null,null,null,null,null,null,null,null,null,16]
[null,null,"ページ14",{"$f":"$D$6&$D$5+13","v":"YA3020"},null,null,null,null,null,null,null,null,null,null,17]
[null,null,"ページ15",{"$f":"$D$6&$D$5+14","v":"YA3021"},null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,31]

{"sheet":"発行番号","index":6,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"前回値","3005"]
[null,null,"現在値","3006"]
[null,null,"担当者記号","YA"]
[null,null,"注文書No","YA3006"]

{"sheet":"購入転送","index":7,"n_rows":13,"n_cols":41,"rows_kept":13,"cut":false,"hidden":false,"merged":[[7,27,7,31],[4,27,4,31],[4,37,4,38],[5,27,5,31],[6,27,6,31],[8,27,8,31],[9,27,9,31],[10,27,10,31],[11,27,11,31],[12,27,12,31],[19,27,19,31],[13,27,13,31],[14,27,14,31],[15,27,15,31],[16,27,16,31],[17,27,17,31],[18,27,18,31]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ","G",null,"D","E","F","G","H","I","J","K","L","M",null,null,"D1"]
[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,"製番","品番1","品番2","品名","型式","　メーカ","備考","数量","単価","金額","仕入先名","仕入先コード","納期",null,"製品納期","注文書No",{"$f":"MAX(R6:R13)","v":8},null,"商品コード",null,"製番","品番1","品番2","品名","形状  寸法","　メーカ","備考",null,null,null,null,"数量","単価","金額","仕入先名","仕入先コード","納期",null,"製品納期","注文書No"]
[null,"C-1234. 1235. 1236. 1237. 1238. 2134. 2135. 2136. 2137. 2138","01","01","ｇ","ff","a","ｈ",11,100,1100,"EEEE",5,9,10,"2020-08-18","HA9146",{"$f":"IF(J6=\"\",0,6)","v":6},null,null,null,"C-1234","01","01","ｇ","ff","a","ｈ",null,null,null,null,2,100,200,"EEEE",5,9,10,44061,"HA9129"]
[null,"C-1234. 1235. 1236. 1237. 1238. 2134. 2135. 2136. 2137. 2138","01","02","ｈ","dddd","ｂ","ｈ",10,200,2000,"EEEE",5,9,10,"2020-08-18","HA9146",{"$f":"IF(J7=\"\",0,7)","v":7},null,null,null,"C-1234","01","02","ｈ","dddd","ｂ","ｈ",null,null,null,null,1,200,200,"EEEE",5,9,10,44061,"HA9129"]
[null,"C-1234. 1235. 1236. 1237. 1238. 2134. 2135. 2136. 2137. 2138","01","03","ｊ","vvvv","ｃ","ｈ",20,300,6000,"EEEE",5,9,10,"2020-08-18","HA9146",{"$f":"IF(J8=\"\",0,8)","v":8},null,null,null,"C-1234","01","03","ｊ","vvvv","ｃ","ｈ",null,null,null,null,2,300,600,"EEEE",5,9,10,44061,"HA9129"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J9=\"\",0,9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J10=\"\",0,10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J11=\"\",0,11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J12=\"\",0,12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J13=\"\",0,13)","v":0}]

{"sheet":"加工転送","index":8,"n_rows":17,"n_cols":44,"rows_kept":17,"cut":false,"hidden":false,"merged":[[4,13,4,14],[4,26,4,27],[4,28,4,32],[4,34,4,35],[4,39,4,40],[5,26,5,27],[5,28,5,32],[5,34,5,35],[8,26,8,27],[8,28,8,32],[8,34,8,35],[6,26,6,27],[6,28,6,32],[6,34,6,35],[7,26,7,27],[7,28,7,32],[7,34,7,35],[9,26,9,27],[9,28,9,32],[9,34,9,35],[10,26,10,27],[10,28,10,32],[10,34,10,35],[11,26,11,27],[11,28,11,32],[11,34,11,35],[12,26,12,27],[12,28,12,32],[12,34,12,35],[13,26,13,27],[13,28,13,32],[13,34,13,35],[14,26,14,27],[14,28,14,32],[14,34,14,35],[15,26,15,27],[15,28,15,32],[15,34,15,35],[16,26,16,27],[16,28,16,32],[16,34,16,35],[19,26,19,27],[19,28,19,32],[19,34,19,35],[17,26,17,27],[17,28,17,32],[17,34,17,35],[18,26,18,27],[18,28,18,32],[18,34,18,35]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ","C","D","E","F","H","I","J","K","L","G","M","N",null,null,"E1"]
[null,"加工部品注文データ転送用",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"部品既存データ用"]
[null,"製番","品番1","品番2","品名",null,null,"備考","数量","単価","金額","仕入先名","仕入先コード","納期",null,"製品納期","注文書No",{"$f":"MAX(R6:R13)","v":8},null,"商品コード",null,null,null,"製番","品番1","品番2","品名",null,"備考",null,null,null,null,"数量","単価",null,"金額","仕入先名","仕入先コード","納期",null,"製品納期","注文書No",{"$f":"MAX(AR6:AR13)","v":11}]
[null,"B-1313","01","01","ｓｓ",null,null,"y",1,100,100,"CCCC",3,9,10,"2017-07-19","HA9146",{"$f":"IF(I6=\"\",0,6)","v":6},null,null,null,null,null,"A-1236","01","1","ｂ",null,"s",null,null,null,null,1,100,null,null,null,2,8,11,44086,"HA9103",{"$f":"IF(AI6=\"\",0,6)","v":6}]
[null,"B-1313","02","01","ｄｄ",null,null,"y",3,200,600,"CCCC",3,9,10,"2017-07-19","HA9146",{"$f":"IF(I7=\"\",0,7)","v":7},null,null,null,null,null,"A-1236","02","2","ｎ",null,null,null,null,null,null,2,200,null,null,null,2,8,11,44086,"HA9103",{"$f":"IF(AI7=\"\",0,7)","v":7}]
[null,"B-1313","03","01","ｇｇ",null,null,"y",1,300,300,"CCCC",3,9,10,"2017-07-19","HA9146",{"$f":"IF(I8=\"\",0,8)","v":8},null,null,null,null,null,"A-1236","03","3","ｍ",null,null,null,null,null,null,1,300,null,null,null,2,8,11,44086,"HA9103",{"$f":"IF(AI8=\"\",0,8)","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I9=\"\",0,9)","v":0},null,null,null,null,null,"A-1236","01","1","ｂ",null,"s",null,null,null,null,1,100,null,null,null,2,8,11,44086,"HA9103",{"$f":"IF(AI9=\"\",0,9)","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I10=\"\",0,10)","v":0},null,null,null,null,null,"A-1236","02","2","ｎ",null,"p",null,null,null,null,2,200,null,null,null,2,8,11,44086,"HA9103",{"$f":"IF(AI10=\"\",0,10)","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I11=\"\",0,11)","v":0},null,null,null,null,null,"A-1236","03","3","ｍ",null,"q",null,null,null,null,1,300,null,null,null,2,8,11,44086,"HA9103",{"$f":"IF(AI11=\"\",0,11)","v":11}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",0,12)","v":0},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,{"$f":"IF(AI12=\"\",0,12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I13=\"\",0,13)","v":0},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,{"$f":"IF(AI13=\"\",0,13)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"材料転送","index":9,"n_rows":16,"n_cols":45,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,13,4,14],[4,27,4,34],[4,39,4,40],[4,41,4,42],[5,27,5,34],[5,39,5,40],[6,27,6,34],[6,39,6,40],[7,27,7,34],[7,39,7,40],[8,27,8,34],[8,39,8,40],[9,27,9,34],[9,39,9,40],[10,27,10,34],[10,39,10,40],[11,27,11,34],[11,39,11,40],[12,27,12,34],[12,39,12,40],[13,27,13,34],[13,39,13,40],[14,27,14,34],[14,39,14,40],[18,27,18,34],[18,39,18,40],[19,27,19,34],[19,39,19,40],[15,27,15,34],[15,39,15,40],[16,27,16,34],[16,39,16,40],[17,27,17,34],[17,39,17,40]]}
[]
[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,"C","D","E","F","H","I","J","K","L","M","N","O","P","Q",null,null,"E1","F1"]
[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,null,null,null," "]
[null,"製番","品番1","品番2","細品番","材質","形状","  寸法","数量","単価","金額","仕入先名","仕入先コード","納期",null,"製品納期","注文書No",{"$f":"MAX(R6:R13)","v":6},null,"商品コード",null,null,"製番","品番1","品番2","細品番","材質","形状  寸法",null,null,null,null,null,null,null,"数量","単価","金額","仕入先名","仕入先コード",null,"納期",null,"製品納期","注文書No"]
[null,"A-3350","A1","01","3","SS-400","角材","100*100*1000",1,250,250,"CCCC",3,9,10,"2017-06-22","HA9152",{"$f":"IF(K6=\"\",0,6)","v":6},null,"B1000"]
[null,"A-3350",null,null,null,null,null,null,null,null,null,"CCCC",3,9,10,"2017-06-22","HA9152",{"$f":"IF(K7=\"\",0,7)","v":0},null,"B1000"]
[null,"A-3350",null,null,null,null,null,null,null,null,null,"CCCC",3,9,10,"2017-06-22","HA9152",{"$f":"IF(K8=\"\",0,8)","v":0},null,"B1000"]
[null,"A-3350",null,null,null,null,null,null,null,null,null,"CCCC",3,9,10,"2017-06-22","HA9152",{"$f":"IF(K9=\"\",0,9)","v":0},null,"B1000"]
[null,"A-3350",null,null,null,null,null,null,null,null,null,"CCCC",3,9,10,"2017-06-22","HA9152",{"$f":"IF(K10=\"\",0,10)","v":0},null,"B1000"]
[null,"A-3350",null,null,null,null,null,null,null,null,null,"CCCC",3,9,10,"2017-06-22","HA9152",{"$f":"IF(K11=\"\",0,11)","v":0},null,"B1000"]
[null,"A-3350",null,null,null,null,null,null,null,null,null,"CCCC",3,9,10,"2017-06-22","HA9152",{"$f":"IF(K12=\"\",0,12)","v":0},null,"B1000"]
[null,"A-3350",null,null,null,null,null,null,null,null,null,"CCCC",3,9,10,"2017-06-22","HA9152",{"$f":"IF(K13=\"\",0,13)","v":0},null,"B1000"]
[]
[]
[null,null,null," "]

{"sheet":"契約一覧","index":10,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["期間:平成29年06月01日 ～ 平成30年06月30日"]
[]
[null,"商品コード","商品名/摘要",null,"受注番号","得意先コード","得意先名","担当者コード","担当者名","納品",null,null,null,"備考"]
[null,"A1000","A-10","2017-06-01","01204746","0049","AA","199","大阪業務","完納",1,20000,20000,"A-1234","2017-06-01"]
[null,"A1000","A-20","2017-06-05","01204751","0013","AB","199","大阪業務","完納",1,30000,30000,"A-1235","2017-06-23"]
[null,"A1000","A-10","2017-06-06","01204749","0580","AC","199","大阪業務","完納",1,157000,157000,"A-1236","2017-07-07"]
[null,"A1000","A-20","2017-06-06","01204750","0411","AD","199","大阪業務","未納",1,29000,29000,"A-1237","2017-06-27"]
[null,"A1000","A-10","2017-06-09","01204754","1830","AE","199","大阪業務","未納",3,45000,135000,"A-1238","2017-06-23"]
[null,"A1000","A-20","2017-06-09","01204754","1830","AF","199","大阪業務","完納",6,9500,57000,"A-1239","2017-06-23"]
[null,"A1000","A-10","2017-06-09","01204755","4330","AG","199","大阪業務","完納",10,8000,80000,"A-1240","2017-06-13"]
[null,"A1000","A-20","2017-06-19","01204770","0590","AO","199","大阪業務","完納",2,18200,36400,"A-1310","2017-07-31"]
[null,"A1000","A-10","2017-06-19","01204771","0160","AP","199","大阪業務","完納",1,52500,52500,"A-1320","2017-07-03"]
[null,"A1000","A-10","2017-06-23","01204781","0411","AW","199","大阪業務","完納",1,39500,39500,"A-1321","2017-07-21"]
[null,"A1000","A-20","2017-06-24","01204784","0910","AX","199","大阪業務","完納",2,19500,39000,"A-1322","2017-07-14"]
[null,"B1000","B-20","2017-06-12","01204756","0080","AH","199","大阪業務","未納",1,133680,133680,"B-1234","2017-07-07"]
[null,"B1000","B-20","2017-06-12","01204757","2156","AL","199","大阪業務","未納",1,22000,22000,"B-1235","2017-06-22"]
[null,"B1000","B-20","2017-06-15","01204760","7420","AM","199","大阪業務","未納",0,50000,50000,"B-1236","2017-07-03"]
[null,"B1000","B-20","2017-06-15","01204773","0049","AN","199","大阪業務","未納",1,13500,13500,"B-1237","2017-06-30"]
[null,"B1000","B-20","2017-06-19","01204772","0160","AQ","199","大阪業務","未納",1,60000,60000,"B-1238","2017-07-03"]
[null,"B1000","B-10","2017-06-19","01204775","3481","AR","199","大阪業務","未納",1,120000,120000,"B-1310","2017-06-24"]
[null,"B1000","B-20","2017-06-19","01204776","3481","AS","199","大阪業務","未納",1,125000,125000,"B-1311","2017-06-24"]
[null,"B1000","B-10","2017-06-20","01204774","0160","AT","199","大阪業務","未納",1,110000,110000,"B-1312","2017-07-07"]
[null,"B1000","B-20","2017-06-21","01204778","0017","AU","199","大阪業務","未納",4,92000,368000,"B-1313","2017-07-19"]
[null,"<<総合計>>",null,null,null,null,null,null,null,null,null,null,1677580]