{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["【使い方】","貼り付け","月計算","日別計算","単価表","カレンダー"],"not_rendered":{"charts":0,"images":6,"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":"【使い方】","index":0,"n_rows":77,"n_cols":15,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[]
[1,"諸注意","本エクセルブックは、マクロ（自動計算プログラム）が組み込まれています。"]
[null,null,"起動時に、セキュリティー上の確認をされますので、使用には「許可」してください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2,"使い方",1,"webシステム上の「注文リスト（日別）」の画面に移動しまうす"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"←ここ"]
[]
[]
[]
[]
[]
[]
[null,null,2,"「納品日」を選択します。"]
[null,null,null,"（○月分を選択すると1ヶ月分出力されます」"]
[]
[null,null,3,"「ロード」し、中身を確認します。"]
[]
[null,null,null,null,null,null,"日づげ→"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"ロード→"]
[]
[]
[null,null,4,"左上部、「CSV（自治体用）」ボタンを押し、CSVファイルをダウンロードします。"]
[]
[]
[null,null,5,"CSVファイルを開き、プログラムの、【貼り付け】シートに貼り付けます"]
[null,null,null,"（全選択ｃｔｒｌ+A、コピーctrl+C、画面移動Alt+Tab、貼り付けctrl+Vなどのショートカットキーをご利用いただくと簡便です）"]
[]
[]
[null,null,null,null,null,null,null,"↓ダウンロードデータ",null,null,null,"↓全体をコピーして【貼り付け】シートに貼り付ける"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,6,"【月計算】で、［データ取得］ボタンでデータを取得します"]
[]
[null,null,null,"［単価呼出］ボタンで、登録されてある単価を呼び出します。"]
[]
[null,null,null,"単価が登録されていない場合は、#N/Aのエラーになるので、新たに打ち込みます"]
[]
[null,null,null,"単価を登録する場合は［単価登録］ボタンを押し、【単価表】シートに登録します。"]
[]
[null,null,null,"（［データ張付］ボタンは現在は使えません。）"]
[]
[null,null,7,"【日別計算】シートも同様にデータを呼び出します。"]
[]
[null,null,8,"【単価表】シートは、単価の登録、確認にお使いください"]
[]
[null,null,9,"【カレンダー】シートでは、注文を月一覧で確認できます。"]
[null,null,null,"単月表示のため、複数月の場合は、コピーしてください。"]

{"sheet":"貼り付け","index":1,"n_rows":1,"n_cols":22,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["伝票番号","入力区分","工場コード","工場名","納品日","製造日","伝票日付","学校コード","学校名","センターコード","センター名","備考","製造備考","入力区分1","商品コード","製造名","特殊加工名","規格","食数","重量","包装名","登録日"]

{"sheet":"月計算","index":2,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["商品コード","製造名","特殊加工名","規格",{"$f":"SUMIF(貼り付け!O:O,A1,貼り付け!S:S)","v":0},"単価",{"$f":"E1*F1","v":{"$error":"#VALUE!"}}]
[null,null,null,null,{"$f":"SUMIF(貼り付け!O:O,A2,貼り付け!S:S)","v":0},null,{"$f":"SUM(G3:G102)","v":0}]
[null,null,null,null,{"$f":"SUMIF(貼り付け!O:O,A3,貼り付け!S:S)","v":0},null,{"$f":"E3*F3","v":0}]

{"sheet":"日別計算","index":3,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[{"$f":"B1&C1","v":"納品日商品コード"},"納品日","商品コード","製造名","特殊加工名","規格","食数","単価","合計","総計"]
[]
[{"$f":"B3&C3","v":""},null,null,null,null,null,{"$f":"SUMIFS(貼り付け!S:S,貼り付け!E:E,B:B,貼り付け!O:O,C:C)","v":0}]

{"sheet":"単価表","index":4,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["商品コード","製造名","規格","単価"]
[203000030,"ツイストパン","30g"]
[203000040,"ツイストパン","40g"]
[203000050,"ツイストパン","50g"]
[203000060,"ツイストパン","60g"]
[204000030,"パーカーハウス","30g"]
[204000040,"パーカーハウス","40g"]
[204000050,"パーカーハウス","50g"]
[218000030,"バンズパン   ","30g"]
[218000040,"バンズパン   ","40g"]
[218000050,"バンズパン   ","50g"]
[221000030,"ココアパン   ","30g"]
[221000040,"ココアパン   ","40g"]
[221000050,"ココアパン   ","50g"]
[301000030,"こめっこぱん ","30g"]
[301000040,"こめっこぱん ","40g"]
[301000050,"こめっこぱん ","50g"]

{"sheet":"カレンダー","index":5,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[{"$f":"INDIRECT(\"日別計算!B3\")+A2","v":0}]
[]
[null,{"$f":"YEAR(A1)","v":1900},null,null,"メニュー","食数","金額"]
[null,null,null,"計",null,{"$f":"SUM(F5:F35)","v":0},{"$f":"SUM(G5:G35)","v":0}]
[null,{"$f":"MONTH(A1)","v":1},1,{"$f":"DATE($B$3,$B$5,C5)","v":1},{"$f":"IF(ISERROR(VLOOKUP(D5,日別計算!B:D,3,0)),\"\",VLOOKUP(D5,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D5,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D5,日別計算!I:I)","v":0}]
[null,null,2,2,{"$f":"IF(ISERROR(VLOOKUP(D6,日別計算!B:D,3,0)),\"\",VLOOKUP(D6,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D6,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D6,日別計算!I:I)","v":0}]
[null,null,3,3,{"$f":"IF(ISERROR(VLOOKUP(D7,日別計算!B:D,3,0)),\"\",VLOOKUP(D7,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D7,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D7,日別計算!I:I)","v":0}]
[null,null,4,4,{"$f":"IF(ISERROR(VLOOKUP(D8,日別計算!B:D,3,0)),\"\",VLOOKUP(D8,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D8,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D8,日別計算!I:I)","v":0}]
[null,null,5,5,{"$f":"IF(ISERROR(VLOOKUP(D9,日別計算!B:D,3,0)),\"\",VLOOKUP(D9,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D9,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D9,日別計算!I:I)","v":0}]
[null,null,6,6,{"$f":"IF(ISERROR(VLOOKUP(D10,日別計算!B:D,3,0)),\"\",VLOOKUP(D10,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D10,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D10,日別計算!I:I)","v":0}]
[null,null,7,7,{"$f":"IF(ISERROR(VLOOKUP(D11,日別計算!B:D,3,0)),\"\",VLOOKUP(D11,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D11,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D11,日別計算!I:I)","v":0}]
[null,null,8,8,{"$f":"IF(ISERROR(VLOOKUP(D12,日別計算!B:D,3,0)),\"\",VLOOKUP(D12,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D12,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D12,日別計算!I:I)","v":0}]
[null,null,9,9,{"$f":"IF(ISERROR(VLOOKUP(D13,日別計算!B:D,3,0)),\"\",VLOOKUP(D13,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D13,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D13,日別計算!I:I)","v":0}]
[null,null,10,10,{"$f":"IF(ISERROR(VLOOKUP(D14,日別計算!B:D,3,0)),\"\",VLOOKUP(D14,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D14,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D14,日別計算!I:I)","v":0}]
[null,null,11,11,{"$f":"IF(ISERROR(VLOOKUP(D15,日別計算!B:D,3,0)),\"\",VLOOKUP(D15,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D15,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D15,日別計算!I:I)","v":0}]
[null,null,12,12,{"$f":"IF(ISERROR(VLOOKUP(D16,日別計算!B:D,3,0)),\"\",VLOOKUP(D16,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D16,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D16,日別計算!I:I)","v":0}]
[null,null,13,13,{"$f":"IF(ISERROR(VLOOKUP(D17,日別計算!B:D,3,0)),\"\",VLOOKUP(D17,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D17,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D17,日別計算!I:I)","v":0}]
[null,null,14,14,{"$f":"IF(ISERROR(VLOOKUP(D18,日別計算!B:D,3,0)),\"\",VLOOKUP(D18,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D18,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D18,日別計算!I:I)","v":0}]
[null,null,15,15,{"$f":"IF(ISERROR(VLOOKUP(D19,日別計算!B:D,3,0)),\"\",VLOOKUP(D19,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D19,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D19,日別計算!I:I)","v":0}]
[null,null,16,16,{"$f":"IF(ISERROR(VLOOKUP(D20,日別計算!B:D,3,0)),\"\",VLOOKUP(D20,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D20,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D20,日別計算!I:I)","v":0}]
[null,null,17,17,{"$f":"IF(ISERROR(VLOOKUP(D21,日別計算!B:D,3,0)),\"\",VLOOKUP(D21,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D21,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D21,日別計算!I:I)","v":0}]
[null,null,18,18,{"$f":"IF(ISERROR(VLOOKUP(D22,日別計算!B:D,3,0)),\"\",VLOOKUP(D22,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D22,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D22,日別計算!I:I)","v":0}]
[null,null,19,19,{"$f":"IF(ISERROR(VLOOKUP(D23,日別計算!B:D,3,0)),\"\",VLOOKUP(D23,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D23,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D23,日別計算!I:I)","v":0}]
[null,null,20,20,{"$f":"IF(ISERROR(VLOOKUP(D24,日別計算!B:D,3,0)),\"\",VLOOKUP(D24,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D24,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D24,日別計算!I:I)","v":0}]
[null,null,21,21,{"$f":"IF(ISERROR(VLOOKUP(D25,日別計算!B:D,3,0)),\"\",VLOOKUP(D25,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D25,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D25,日別計算!I:I)","v":0}]
[null,null,22,22,{"$f":"IF(ISERROR(VLOOKUP(D26,日別計算!B:D,3,0)),\"\",VLOOKUP(D26,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D26,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D26,日別計算!I:I)","v":0}]
[null,null,23,23,{"$f":"IF(ISERROR(VLOOKUP(D27,日別計算!B:D,3,0)),\"\",VLOOKUP(D27,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D27,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D27,日別計算!I:I)","v":0}]
[null,null,24,24,{"$f":"IF(ISERROR(VLOOKUP(D28,日別計算!B:D,3,0)),\"\",VLOOKUP(D28,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D28,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D28,日別計算!I:I)","v":0}]
[null,null,25,25,{"$f":"IF(ISERROR(VLOOKUP(D29,日別計算!B:D,3,0)),\"\",VLOOKUP(D29,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D29,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D29,日別計算!I:I)","v":0}]
[null,null,26,26,{"$f":"IF(ISERROR(VLOOKUP(D30,日別計算!B:D,3,0)),\"\",VLOOKUP(D30,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D30,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D30,日別計算!I:I)","v":0}]
[null,null,27,27,{"$f":"IF(ISERROR(VLOOKUP(D31,日別計算!B:D,3,0)),\"\",VLOOKUP(D31,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D31,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D31,日別計算!I:I)","v":0}]
[null,null,28,28,{"$f":"IF(ISERROR(VLOOKUP(D32,日別計算!B:D,3,0)),\"\",VLOOKUP(D32,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D32,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D32,日別計算!I:I)","v":0}]
[29,null,{"$f":"IF(D33=\"\",\"\",A33)","v":29},{"$f":"IF(MONTH(DATE($B$3,$B$5,A33))<>$B$5,\"\",DATE($B$3,$B$5,A33))","v":29},{"$f":"IF(ISERROR(VLOOKUP(D33,日別計算!B:D,3,0)),\"\",VLOOKUP(D33,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D33,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D33,日別計算!I:I)","v":0}]
[30,null,{"$f":"IF(D34=\"\",\"\",A34)","v":30},{"$f":"IF(MONTH(DATE($B$3,$B$5,A34))<>$B$5,\"\",DATE($B$3,$B$5,A34))","v":30},{"$f":"IF(ISERROR(VLOOKUP(D34,日別計算!B:D,3,0)),\"\",VLOOKUP(D34,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D34,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D34,日別計算!I:I)","v":0}]
[31,null,{"$f":"IF(D35=\"\",\"\",A35)","v":31},{"$f":"IF(MONTH(DATE($B$3,$B$5,A35))<>$B$5,\"\",DATE($B$3,$B$5,A35))","v":31},{"$f":"IF(ISERROR(VLOOKUP(D35,日別計算!B:D,3,0)),\"\",VLOOKUP(D35,日別計算!B:D,3,0))","v":""},{"$f":"SUMIF(日別計算!B:B,カレンダー!D35,日別計算!G:G)","v":0},{"$f":"SUMIF(日別計算!B:B,カレンダー!D35,日別計算!I:I)","v":0}]