{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ツール","初期化"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":75,"comments":1,"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":48,"n_cols":32,"rows_kept":48,"cut":false,"hidden":false,"merged":[[47,26,47,33],[2,1,7,27],[5,28,7,29],[15,2,15,15],[15,16,17,16],[16,19,16,25],[16,18,17,18],[16,1,17,1],[33,1,34,1],[33,16,34,16],[16,27,17,27],[16,29,17,29],[16,26,17,26]]}
["■倉庫作業者シフトスケジューリング案作成ツール"]
[]
[null,"・物流倉庫作業者のシフトスケジューリングを行う上での、【案】を作成するためのツールです。\n・出力された案に対して、手動修正します。\n・あくまでも、シフトスケジューリング案作成のイメージを掴んで頂くための内容に留めており、必要最低限の条件のみとしています。\n・青枠（セルT19あたり）で条件を決めています。曜日毎の出勤可能日の設定、１週間の間で出勤可能な日数、曜日毎で最低必要なスタッフ数、\n   最大の上限数の４つです。\n・青枠は自由に数値を変更できますが、計算の実行が不可能な数値に変更した場合はエラーになります。初期化ボタンを押して下さい。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"月度","10月",null,null,null,null,null,null,null,null,null,null,null,null,null,"出勤日数"]
[null,"スタッフ名",1,2,3,4,5,6,7,8,9,10,11,12,13,14,null,null,"スタッフ名","曜日別出勤可能日",null,null,null,null,null,null,"週別\n出勤可能日数","半月希望日数",null,"評価"]
[null,null,"日","月","火","水","木","金","土","日","月","火","水","木","金","土",null,null,null,"日","月","火","水","木","金","土"]
[null,"スタッフ太郎",{"$f":"IF(C36=1,\"出\",\"欠\")","v":"欠"},{"$f":"IF(D36=1,\"出\",\"欠\")","v":"欠"},"欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠",{"$f":"COUNTIF(C19:P19,\"出\")","v":0},{"$f":"I19+P19","v":{"$error":"#VALUE!"}},"スタッフ太郎",1,1,1,1,1,1,0,6,{"$f":"AA19*2","v":12},null,{"$f":"ABS(Q36-AB19)","v":12},{"$f":"AB19-3","v":9},{"$f":"AB19+2","v":14}]
[null,"スタッフ次郎",{"$f":"IF(C37=1,\"出\",\"欠\")","v":"欠"},"欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠",{"$f":"COUNTIF(C20:P20,\"出\")","v":0},{"$f":"H20+O20","v":{"$error":"#VALUE!"}},"スタッフ次郎",1,1,1,1,1,0,1,6,{"$f":"AA20*2","v":12},null,{"$f":"ABS(Q37-AB20)","v":12},{"$f":"AB20-3","v":9},{"$f":"AB20+2","v":14}]
[null,"スタッフ三郎",{"$f":"IF(C38=1,\"出\",\"欠\")","v":"欠"},"欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠",0,{"$f":"D21+K21","v":{"$error":"#VALUE!"}},"スタッフ三郎",1,0,1,1,1,1,1,6,12,null,12,9,14]
[null,"スタッフ四郎",{"$f":"IF(C39=1,\"出\",\"欠\")","v":"欠"},"欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠",0,{"$f":"C22+J22","v":{"$error":"#VALUE!"}},"スタッフ四郎",0,1,1,1,1,1,1,6,12,null,12,9,14]
[null,"スタッフ五郎",{"$f":"IF(C40=1,\"出\",\"欠\")","v":"欠"},"欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠",0,{"$f":"+D23+I23+K23+P23","v":{"$error":"#VALUE!"}},"スタッフ五郎",1,0,1,1,1,1,0,5,10,null,10,7,12]
[null,"スタッフ六郎",{"$f":"IF(C41=1,\"出\",\"欠\")","v":"欠"},"欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠",0,{"$f":"I24+P24","v":{"$error":"#VALUE!"}},"スタッフ六郎",1,1,1,1,1,1,0,5,10,null,10,7,12]
[null,"スタッフ七郎",{"$f":"IF(C42=1,\"出\",\"欠\")","v":"欠"},"欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠",0,{"$f":"+G25+H25+N25+O25","v":{"$error":"#VALUE!"}},"スタッフ七郎",1,1,1,1,0,0,1,5,10,null,10,7,12]
[null,"スタッフ八郎",{"$f":"IF(C43=1,\"出\",\"欠\")","v":"欠"},"欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠",0,{"$f":"F26+I26+M26+P26","v":{"$error":"#VALUE!"}},"スタッフ八郎",1,1,1,0,1,1,0,5,10,null,10,7,12]
[null,"スタッフ九郎",{"$f":"IF(C44=1,\"出\",\"欠\")","v":"欠"},"欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠",0,{"$f":"C27+E27+J27+L27","v":{"$error":"#VALUE!"}},"スタッフ九郎",0,1,0,1,1,1,1,5,10,null,10,7,12]
[null,"スタッフ十郎",{"$f":"IF(C45=1,\"出\",\"欠\")","v":"欠"},"欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠","欠",0,{"$f":"D28+H28+I28+K28+O28+P28","v":{"$error":"#VALUE!"}},"スタッフ十郎",1,0,1,1,1,1,0,5,10,null,10,7,12]
[]
[null,"日別稼働人数",{"$f":"COUNTIF(C19:C28,\"出\")","v":0},{"$f":"COUNTIF(D19:D28,\"出\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,null,"最小稼働人数",2,4,4,4,4,4,2,null,"目的関数",null,{"$f":"SUM(AD19:AD28)","v":108}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"最大稼働人数",5,8,8,8,8,8,5]
[]
[null,null,"10月"]
[null,"スタッフ名",1,2,3,4,5,6,7,8,9,10,11,12,13,14,"出勤日数",null,"スタッフ名","1w","2w"]
[null,null,"日","月","火","水","木","金","土","日","月","火","水","木","金","土",null,null,"スタッフ太郎",{"$f":"SUM(C19:I19)","v":0},{"$f":"SUM(J19:P19)","v":0}]
[null,"スタッフ太郎",0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C36:P36)","v":0},null,"スタッフ次郎",0,0]
[null,"スタッフ次郎",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"スタッフ三郎",0,0]
[null,"スタッフ三郎",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"スタッフ四郎",0,0]
[null,"スタッフ四郎",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"スタッフ五郎",0,0]
[null,"スタッフ五郎",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"スタッフ六郎",0,0]
[null,"スタッフ六郎",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"スタッフ七郎",0,0]
[null,"スタッフ七郎",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"スタッフ八郎",0,0]
[null,"スタッフ八郎",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"スタッフ九郎",0,0]
[null,"スタッフ九郎",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"スタッフ十郎",0,0]
[null,"スタッフ十郎",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"日別稼働人数",{"$f":"SUM(C36:C45)","v":0},{"$f":"SUM(D36:D45)","v":0},0,0,0,0,0,0,0,0,0,0,0,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,null,"開発元：(株)日通総合研究所　"]

{"sheet":"初期化","index":1,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[1,1,1,1,1,1,0,6]
[1,1,1,1,1,0,1,6]
[1,0,1,1,1,1,1,6]
[0,1,1,1,1,1,1,6]
[1,0,1,1,1,1,0,5]
[1,1,1,1,1,1,0,5]
[1,1,1,1,0,0,1,5]
[1,1,1,0,1,1,0,5]
[0,1,0,1,1,1,1,5]
[1,0,1,1,1,1,0,5]
[]
[2,4,4,4,4,4,2]
[5,8,8,8,8,8,5]