{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["使い方","Menu-入力系","Menu-出力系","Inventory","PartsMaster","LocationMaster","ReceiptHistory","PickHistory","MoveHistory","StateChangeHistory","SerialNumberMaster","Year","Month","Day","OpenReceiptListForm","CancelReceiptListForm","ReceiptConfirmListForm","OpenPickListForm","CancelPickListForm","PickConfirmListForm"],"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":"使い方","index":0,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"＜本サンプルの説明＞"]
[]
[null,"●在庫管理における入庫用の予定登録、予定削除、実行確認のフォームと、出庫用の予定登録、予定削除、実行確認のフォームを提供しています。"]
[null,"●商品マスターや棚マスターはシート上で直接管理します。"]
[null,"●現状の在庫状況もシートで管理できます。"]
[]
[null,"＜使用方法＞"]
[]
[null,"●本ファイルを開いたとき、セキュリティに関する通知が表示された場合は、「マクロを有効にする」をクリックしてください。"]
[null,"●本ファイルを開いたとき、上部バーに「セキュリティの警告　マクロが無効にされました。　オプション」と表示された場合は、"]
[null,"　オプションボタンをクリックして、「○このコンテンツを有効にする」を選択の上、OKボタンを押してください。"]
[null,"●メニュータブより該当するボタンをクリックしてフォームを表示してください。"]
[null,"●あとはフォームに従って、操作してみてください。"]
[null,"●商品情報はPartsMasterタブシートに蓄積されます（直接操作することも可能、商品データの追加削除はこのシート上で行削除してください）。"]
[null,"●棚情報はLocationMasterタブシートに蓄積されます（直接操作することも可能、棚データの追加削除はこのシート上で行削除してください）。"]
[null,"●現状在庫情報はInventoryタブシートに蓄積されます（直接操作することも可能、在庫データの削除はこのシート上で行削除してください）。"]
[null,"●なお、本ファイルを開いたときに、自動的にバックアップファイルが生成されますので、予めご了承ください。"]

{"sheet":"Menu-入力系","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Menu-出力系","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Inventory","index":3,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["PartID","LocationID","Available","Not Available","PickAllocated","PutAway","LastUpdateDate"]

{"sheet":"PartsMaster","index":4,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["PartID","PartDescription"]
["商品１","商品１の説明文です。"]
["商品２","商品２の説明文です。"]
["商品３","商品３の説明文です。"]

{"sheet":"LocationMaster","index":5,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["LocationID"]
["棚１"]
["棚２"]
["棚３"]
["棚４"]
["棚５"]

{"sheet":"ReceiptHistory","index":6,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["SerialNumber","JobRef No","PartID","LocationID","QTY","Allocated","Cancelled","Confirmed","LastUpdateDate"]

{"sheet":"PickHistory","index":7,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["SerialNumber","JobRef No","PartID","LocationID","QTY","Allocated","Cancelled","Confirmed","LastUpdateDate"]

{"sheet":"MoveHistory","index":8,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["SerialNumber","JobRef No","PartID","LocationID","QTY","Allocated","Cancelled","Confirmed","LastUpdateDate"]

{"sheet":"StateChangeHistory","index":9,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["SerialNumber","JobRef No","PartID","LocationID","QTY-Avaiｌable","QTY-NotAvairable","LastUpdateDate"]

{"sheet":"SerialNumberMaster","index":10,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["SerialNumber",null,"※最初の1だけは入力しておく必要あり（エラーになるので）"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]

{"sheet":"Year","index":11,"n_rows":101,"n_cols":1,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[2014]
[2015]
[2016]
[2017]
[2018]
[2019]
[2020]
[2021]
[2022]
[2023]
[2024]
[2025]
[2026]
[2027]
[2028]
[2029]
[2030]
[2031]
[2032]
[2033]
[2034]
[2035]
[2036]
[2037]
[2038]
[2039]
[2040]
[2041]
[2042]
[2043]
[2044]
[2045]
[2046]
[2047]
[2048]
[2049]
[2050]
[2051]
[2052]
[2053]
[2054]
[2055]
[2056]
[2057]
[2058]
[2059]
[2060]
[2061]
[2062]
[2063]
[2064]
[2065]
[2066]
[2067]
[2068]
[2069]
[2070]
[2071]
[2072]
[2073]
[2074]
[2075]
[2076]
[2077]
[2078]
[2079]
[2080]
[2081]
[2082]
[2083]
[2084]
[2085]
[2086]
[2087]
[2088]
[2089]
[2090]
[2091]
[2092]
[2093]
[2094]
[2095]
[2096]
[2097]
[2098]
[2099]
[2100]
[2101]
[2102]
[2103]
[2104]
[2105]
[2106]
[2107]
[2108]
[2109]
[2110]
[2111]
[2112]
[2113]
[2114]

{"sheet":"Month","index":12,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]

{"sheet":"Day","index":13,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]

{"sheet":"OpenReceiptListForm","index":14,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["入庫予定リスト"]
[]
["棚番号","商品番号","商品説明","数量","作業番号"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"書類チェック","入庫確認","最終確認"]

{"sheet":"CancelReceiptListForm","index":15,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["入庫予定削除リスト"]
[]
["棚番号","商品番号","商品説明","数量","作業番号"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"書類チェック","入庫確認","最終確認"]

{"sheet":"ReceiptConfirmListForm","index":16,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["入庫作業確認リスト"]
[]
["棚番号","商品番号","商品説明","数量","作業番号"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"書類チェック","入庫確認","最終確認"]

{"sheet":"OpenPickListForm","index":17,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["出庫予定リスト"]
[]
["棚番号","商品番号","商品説明","数量","作業番号"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"書類チェック","ピッキング確認","最終確認"]

{"sheet":"CancelPickListForm","index":18,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["出庫予定削除リスト"]
[]
["棚番号","商品番号","商品説明","数量","作業番号"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"書類チェック","ピッキング確認","最終確認"]

{"sheet":"PickConfirmListForm","index":19,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["出庫作業確認リスト"]
[]
["棚番号","商品番号","商品説明","数量","作業番号"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"書類チェック","ピッキング確認","最終確認"]