{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Entry","バーコード納品書作成方法","例_バーコードー納品書","Label"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"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":"Entry","index":0,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Rev.1"]
[null,null,"Delivery Note (納品書番号):",null,"*"]
[null,null,"Quantity (数量):",null,"*"]
[null,null,"PO Number (PO番号):",null,"*"]
[null,null,"PO Line Item (PO Item番号):",null,"*"]
[null,null,"TI Part Number (TIパーツ番号):"]
[null,null,"Revision Letter (レビジョン):"]
[null,null,"Description (品名):",null,"*"]
[null,null,"Manufacture Date (製造年月日):",null,null,null,null,"(YYYYMMDD)"]
[null,null,"Expiration Date (有効期限):",null,null,null,null,"(YYYYMMDD)"]
[null,null,"Vendor Batch (ベンダーバッチ番号):"]
[null,null,"Package Count (箱数):",null,"of"]
[null,null,"Weight (重量):",null,"kg ",null,"lbs.","only one is required"]
[null,null,"From Address (貴社名):",null,"*"]
[null,null,"To Address (納入先):",null,"*"]
[null,null,"Date (出荷日):",null,"*"]

{"sheet":"バーコード納品書作成方法","index":1,"n_rows":57,"n_cols":2,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
["バーコード納品書作成方法"]
[]
[1,"Entryシートを開く"]
[null,"バーコード納品書を作成するために、CODE39のバーコードフォントが必要です。"]
[null,"インストールされていない場合は、インストールをしてください。"]
[]
[2,"必要な項目を入力"]
[null,"*は、必須項目"]
[null,"入力したら、Creae-a-Labelを実行"]
[]
[3,"印刷プレビュー画面が表示"]
[null,"印刷プレビュー画面が表示されるので、内容を確認"]
[null,"ズームを押すと、内容が確認できます。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[3,"印刷"]
[null,"印刷をクリックし、印刷"]
[]
[]
[]
[]
[]
[]
[]
[]
[4,"入力画面に戻る"]
[null,"入力画面に戻る場合は、印刷プレビューを閉じるをクリック"]

{"sheet":"例_バーコードー納品書","index":2,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,30,2],[30,3,30,4],[31,3,31,4],[24,1,24,4],[25,1,25,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[29,1,29,2],[29,3,29,4],[23,1,23,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[19,1,19,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[11,1,11,4],[2,1,2,2],[2,3,2,4],[3,1,3,2],[3,3,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4]]}
[]
[null,null,null,"出荷日","2016-03-04"]
[null,"From:",null,"To:"]
[null,"A会社　",null,"日本テキサスインスツルメンツセミコンダクタ\n会津工場"]
[null,"(14K) PO/Line"]
[null,"*14K4513044601+00010*"]
[null,"(14K) 4513044601+00010"]
[null,"(P) TI P/N"]
[null,"*P4712584-0001*"]
[null,"(P) 4712584-0001"]
[null,"(2P) Revision Letter"]
[null,"*2P*"]
[null,"(2P) "]
[null,"(Q) Quantity"]
[null,"*Q1*"]
[null,"(Q) 1"]
[null,"(11K) Delivery Note"]
[null,"*11Kabcdefg*"]
[null,"(11K) abcdefg"]
[null,"(16D) Manufacture Date"]
[null,"*16D*"]
[null,"(16D) "]
[null,"(14D) Expiration Date"]
[null,"*14D*"]
[null,"(14D) "]
[null,"(1T) Vendor Batch"]
[null,"*1T*"]
[null,"(1T) "]
[null,"Desk"]
[null,"Package Count:",null,"Weight:"]
[null,"1  of  1",null,"1kg   1lbs."]

{"sheet":"Label","index":3,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":true,"merged":[[2,1,2,2],[2,3,2,4],[3,1,3,2],[3,3,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[27,1,27,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[11,1,11,4],[15,1,15,4],[9,1,9,4],[10,1,10,4],[23,1,23,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[31,3,31,4],[19,1,19,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[30,1,30,2],[30,3,30,4],[24,1,24,4],[25,1,25,4],[26,1,26,4],[29,1,29,2],[29,3,29,4],[28,1,28,4]]}
[]
[null,null,null,"出荷日:",{"$f":"IF(Entry!D17=\"\",TODAY(),Entry!D17)","v":"2020-12-14"}]
[null,"From:",null,"To:"]
[null,{"$f":"Entry!D15","v":0},null,{"$f":"Entry!D16","v":0}]
[null,"(14K) PO/Line"]
[null,{"$f":"\"*14K\"&TEXT(Entry!D5,\"0000000000\")&\"+\"&TEXT(Entry!D6,\"00000\")&\"*\"","v":"*14K0000000000+00000*"}]
[null,{"$f":"\"(14K) \"&TEXT(Entry!D5,\"0000000000\")&\"+\"&TEXT(Entry!D6,\"00000\")","v":"(14K) 0000000000+00000"}]
[null,"(P) TI P/N"]
[null,{"$f":"\"*P\"&Entry!D7&\"*\"","v":"*P*"}]
[null,{"$f":"\"(P) \"&Entry!D7","v":"(P) "}]
[null,"(2P) Revision Letter"]
[null,{"$f":"\"*2P\"&Entry!D8&\"*\"","v":"*2P*"}]
[null,{"$f":"\"(2P) \"&Entry!D8","v":"(2P) "}]
[null,"(Q) Quantity"]
[null,{"$f":"\"*Q\"&Entry!D4&\"*\"","v":"*Q*"}]
[null,{"$f":"\"(Q) \"&Entry!D4","v":"(Q) "}]
[null,"(11K) Delivery Note"]
[null,{"$f":"\"*11K\"&Entry!D3&\"*\"","v":"*11K*"}]
[null,{"$f":"\"(11K) \"&Entry!D3","v":"(11K) "}]
[null,"(16D) Manufacture Date"]
[null,{"$f":"\"*16D\"&Entry!D10&\"*\"","v":"*16D*"}]
[null,{"$f":"\"(16D) \"&Entry!D10","v":"(16D) "}]
[null,"(14D) Expiration Date"]
[null,{"$f":"\"*14D\"&Entry!D11&\"*\"","v":"*14D*"}]
[null,{"$f":"\"(14D) \"&Entry!D11","v":"(14D) "}]
[null,"(1T) Vendor Batch"]
[null,{"$f":"\"*1T\"&Entry!D12&\"*\"","v":"*1T*"}]
[null,{"$f":"\"(1T) \"&Entry!D12","v":"(1T) "}]
[null,{"$f":"Entry!D9","v":0}]
[null,"Package Count:",null,"Weight:"]
[null,{"$f":"Entry!D13&\"  \"&Entry!E13&\"  \"&Entry!F13","v":"  of  "},null,{"$f":"Entry!D14&Entry!E14&\"  \"&Entry!F14&Entry!G14","v":"kg   lbs."}]