{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["①現状把握","②発注状況把握（入力）","③発注状況把握（金額）","③発注状況把握（件数）","④導入効果試算 (条件指定)","⑤導入効果試算","table"],"not_rendered":{"charts":31,"images":0,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":12},"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":131,"n_cols":51,"rows_kept":131,"cut":false,"hidden":false,"merged":[[130,1,130,5],[108,1,108,5],[84,1,84,5],[85,1,85,5],[86,1,86,5],[105,1,105,5],[106,1,106,5],[113,2,113,9],[112,1,112,9],[127,1,127,5],[128,1,128,5],[129,1,129,5],[117,2,117,9],[17,1,17,5],[18,1,18,5],[19,1,19,5],[20,1,20,5],[39,1,39,5],[64,1,64,5],[83,1,83,5],[107,1,107,5],[25,24,25,34],[25,13,25,23],[47,2,47,9],[48,2,48,9],[47,13,47,23],[47,24,47,34],[40,1,40,5],[41,1,41,5],[42,1,42,5],[61,1,61,5],[62,1,62,5],[91,38,91,39],[68,1,68,9],[90,1,90,9],[114,40,114,41],[114,2,114,9],[114,38,114,39],[91,40,91,41],[69,13,69,23],[69,24,69,34],[91,13,91,23],[91,24,91,34],[7,2,7,9],[92,2,92,9],[95,2,95,9],[69,2,69,9],[70,2,70,9],[73,2,73,9],[91,2,91,9],[51,2,51,9],[25,2,25,9],[26,2,26,9],[29,2,29,9],[16,1,16,5],[24,1,24,9],[46,1,46,9],[38,1,38,5],[63,1,63,5],[2,1,2,9],[6,1,6,9],[3,38,3,39],[3,40,3,41],[3,13,3,23],[3,24,3,34],[4,2,4,9],[3,2,3,9],[25,40,25,41],[47,38,47,39],[47,40,47,41],[69,38,69,39],[69,40,69,41],[25,38,25,39]]}
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"現状把握シート（\"&C4&C5&\"）\"","v":"現状把握シート（〇〇市〇〇課）"}]
[]
[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,"No.","業務内容","現状",null,null,null,null,null,null,null,null,null,null,"理想",null,null,null,null,null,null,null,null,null,null,null,"No.","業務内容","従事割合",null,"従事時間"]
[null,"課名","〇〇課",null,null,null,null,null,null,null,null,null,null,"職員A","職員B","職員C","職員D","職員E","職員F","職員G","職員H","職員I","職員J","合計","職員A","職員B","職員C","職員D","職員E","職員F","職員G","職員H","職員I","職員J","合計",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,{"$f":"SUM($N6:$W6)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($Y6:$AH6)","v":0},null,1,"窓口業務",{"$f":"$X6/$X$14","v":{"$error":"#DIV/0!"}},{"$f":"$AI6/$AI$14","v":{"$error":"#DIV/0!"}},{"$f":"$G$21*$X6","v":0},{"$f":"$G$21*$AI6","v":0}]
[null,"●職員数",null,null,null,null,null,null,null,null,null,{"$f":"L6+1","v":2},"巡回業務",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N7:$W7)","v":0},null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"AK6+1","v":2},"巡回業務",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$G$21*$X7","v":0},0]
[null,"職員区分","年齢層（単位：人）",null,null,null,null,null,null,null,null,{"$f":"L7+1","v":3},"維持作業（直営）",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"AK7+1","v":3},"維持作業（直営）",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$G$21*$X8","v":0},0]
[null,null,"10代","20代","30代","40代","50代","60代","70代","合計",null,4,"発注事務",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,4,"発注事務",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"技術職",null,null,null,null,null,null,null,{"$f":"SUM($C10:$I10)","v":0},null,5,"受注者との協議・指示",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,5,"受注者との協議・指示",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"事務職",null,null,null,null,null,null,null,{"$f":"SUM($C11:$I11)","v":0},null,6,"インフラ管理者としての計画策定",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,6,"インフラ管理者としての計画策定",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,"●技術系職員数"]
[null,"再任用",null,null,null,null,null,null,null,{"$f":"SUM($C12:$I12)","v":0},null,7,"技術力向上のための研修・学習等",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,7,"技術力向上のための研修・学習等",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"現業職",null,null,null,null,null,null,null,{"$f":"SUM($C13:$I13)","v":0},null,8,"その他の事務",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,8,"その他の事務",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"会計年度",null,null,null,null,null,null,null,{"$f":"SUM($C14:$I14)","v":0},null,null,"合計",{"$f":"SUM(N$6:N$13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"合計",{"$f":"SUM(AM$6:AM$13)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AN$6:AN$13)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AO$6:AO$13)","v":0},{"$f":"SUM(AP$6:AP$13)","v":0}]
[null,"合計",{"$f":"SUM(C$10:C$14)","v":0},0,0,0,0,0,0,0]
[]
[null,"●職員労働時間"]
[null,"年間の所定労働日数（A日）",null,null,null,null,null,"A日","※365日から休日（週5日勤務の場合は約105日）と国民の祝日（16日）、有給休暇、特別休暇の日数を差し引いた日数"]
[null,"１日の所定労働時間（B時間）",null,null,null,null,null,"B時間","※始業時刻から終業時刻までの時間から、休憩時間を差し引いた労働時間（8:30始業、17:15終業の12～13時が休憩時間の場合は7.75時間）　"]
[null,"1人当たりの月間時間外労働時間（C時間）",null,null,null,null,null,"C時間"]
[null,"1人当たりの年間労働時間（D時間）",null,null,null,null,{"$f":"G18*G19+G20*12","v":0},"D時間","自動計算：D=A×B＋C×12"]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"現状把握シート（\"&C25&C26&C27&\"）\"","v":"現状把握シート（〇〇市××課）"}]
[]
[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,"No.","業務内容","現状",null,null,null,null,null,null,null,null,null,null,"理想",null,null,null,null,null,null,null,null,null,null,null,"No.","業務内容","従事割合",null,"従事時間"]
[null,"課名","××課",null,null,null,null,null,null,null,null,null,null,"職員A","職員B","職員C","職員D","職員E","職員F","職員G","職員H","職員I","職員J","合計","職員A","職員B","職員C","職員D","職員E","職員F","職員G","職員H","職員I","職員J","合計",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,{"$f":"SUM($N28:$W28)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($Y28:$AH28)","v":0},null,1,"窓口業務",{"$f":"$X28/$X$36","v":{"$error":"#DIV/0!"}},{"$f":"$AI28/$AI$36","v":{"$error":"#DIV/0!"}},{"$f":"$G$43*$X28","v":0},{"$f":"$G$43*$AI28","v":0}]
[null,"●職員数",null,null,null,null,null,null,null,null,null,{"$f":"L28+1","v":2},"巡回業務",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N29:$W29)","v":0},null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"AK28+1","v":2},"巡回業務",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"職員区分","年齢層（単位：人）",null,null,null,null,null,null,null,null,{"$f":"L29+1","v":3},"維持作業（直営）",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"AK29+1","v":3},"維持作業（直営）",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,null,"10代","20代","30代","40代","50代","60代","70代","合計",null,4,"発注事務",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,4,"発注事務",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"技術職",null,null,null,null,null,null,null,{"$f":"SUM($C32:$I32)","v":0},null,5,"受注者との協議・指示",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,5,"受注者との協議・指示",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"事務職",null,null,null,null,null,null,null,{"$f":"SUM($C33:$I33)","v":0},null,6,"インフラ管理者としての計画策定",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,6,"インフラ管理者としての計画策定",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,"●技術系職員数"]
[null,"再任用",null,null,null,null,null,null,null,{"$f":"SUM($C34:$I34)","v":0},null,7,"技術力向上のための研修・学習等",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,7,"技術力向上のための研修・学習等",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"現業職",null,null,null,null,null,null,null,{"$f":"SUM($C35:$I35)","v":0},null,8,"その他の事務",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,8,"その他の事務",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"会計年度",null,null,null,null,null,null,null,{"$f":"SUM($C36:$I36)","v":0},null,null,"合計",{"$f":"SUM(N$28:N$35)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"合計",{"$f":"SUM(AM$28:AM$35)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AN$28:AN$35)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AO$28:AO$35)","v":0},{"$f":"SUM(AP$28:AP$35)","v":0}]
[null,"合計",{"$f":"SUM(C$32:C$36)","v":0},0,0,0,0,0,0,0]
[]
[null,"●職員労働時間"]
[null,"年間の所定労働日数（A日）",null,null,null,null,null,"A日","※365日から休日（週5日勤務の場合は約105日）と国民の祝日（16日）、有給休暇、特別休暇の日数を差し引いた日数"]
[null,"１日の所定労働時間（B時間）",null,null,null,null,null,"B時間","※始業時刻から終業時刻までの時間から、休憩時間を差し引いた労働時間（8:30始業、17:15終業の12～13時が休憩時間の場合は7.75時間）　"]
[null,"1人当たりの月間時間外労働時間（C時間）",null,null,null,null,null,"C時間"]
[null,"1人当たりの年間労働時間（D時間）",null,null,null,null,{"$f":"G40*G41+G42*12","v":0},"D時間","自動計算：D=A×B＋C×12"]
[]
[null,"入力欄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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"現状把握シート（\"&C47&C48&C49&\"）\"","v":"現状把握シート（〇〇市△△課）"}]
[]
[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,"No.","業務内容","現状",null,null,null,null,null,null,null,null,null,null,"理想",null,null,null,null,null,null,null,null,null,null,null,"No.","業務内容","従事割合",null,"従事時間"]
[null,"課名","△△課",null,null,null,null,null,null,null,null,null,null,"職員A","職員B","職員C","職員D","職員E","職員F","職員G","職員H","職員I","職員J","合計","職員A","職員B","職員C","職員D","職員E","職員F","職員G","職員H","職員I","職員J","合計",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,{"$f":"SUM($N50:$W50)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($Y50:$AH50)","v":0},null,1,"窓口業務",{"$f":"$X50/$X$58","v":{"$error":"#DIV/0!"}},{"$f":"$AI50/$AI$58","v":{"$error":"#DIV/0!"}},{"$f":"$G$65*$X50","v":0},{"$f":"$G$65*$AI50","v":0}]
[null,"●職員数",null,null,null,null,null,null,null,null,null,{"$f":"L50+1","v":2},"巡回業務",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"AK50+1","v":2},"巡回業務",{"$f":"$X51/$X$58","v":{"$error":"#DIV/0!"}},{"$f":"$AI51/$AI$58","v":{"$error":"#DIV/0!"}},0,0]
[null,"職員区分","年齢層（単位：人）",null,null,null,null,null,null,null,null,{"$f":"L51+1","v":3},"維持作業（直営）",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"AK51+1","v":3},"維持作業（直営）",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,null,"10代","20代","30代","40代","50代","60代","70代","合計",null,4,"発注事務",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,4,"発注事務",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"技術職",null,null,null,null,null,null,null,{"$f":"SUM($C54:$I54)","v":0},null,5,"受注者との協議・指示",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,5,"受注者との協議・指示",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"事務職",null,null,null,null,null,null,null,{"$f":"SUM($C55:$I55)","v":0},null,6,"インフラ管理者としての計画策定",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,6,"インフラ管理者としての計画策定",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,"●技術系職員数"]
[null,"再任用",null,null,null,null,null,null,null,{"$f":"SUM($C56:$I56)","v":0},null,7,"技術力向上のための研修・学習等",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,7,"技術力向上のための研修・学習等",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"現業職",null,null,null,null,null,null,null,{"$f":"SUM($C57:$I57)","v":0},null,8,"その他の事務",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,8,"その他の事務",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"会計年度",null,null,null,null,null,null,null,{"$f":"SUM($C58:$I58)","v":0},null,null,"合計",{"$f":"SUM(N$50:N$57)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"合計",{"$f":"SUM(AM$50:AM$57)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AN$50:AN$57)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AO$50:AO$57)","v":0},{"$f":"SUM(AP$50:AP$57)","v":0}]
[null,"合計",{"$f":"SUM(C$54:C$58)","v":0},0,0,0,0,0,0,0]
[]
[null,"●職員勤務時間"]
[null,"年間の所定労働日数（A日）",null,null,null,null,null,"A日","※365日から休日（週5日勤務の場合は約105日）と国民の祝日（16日）、有給休暇、特別休暇の日数を差し引いた日数"]
[null,"１日の所定労働時間（B時間）",null,null,null,null,null,"B時間","※始業時刻から終業時刻までの時間から、休憩時間を差し引いた労働時間（8:30始業、17:15終業の12～13時が休憩時間の場合は7.75時間）　"]
[null,"1人当たりの月間時間外労働時間（C時間）",null,null,null,null,null,"C時間"]
[null,"1人当たりの年間労働時間（D時間）",null,null,null,null,{"$f":"G62*G63+G64*12","v":0},"D時間","自動計算：D=A×B＋C×12"]
[]
[null,"入力欄4",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,{"$f":"\"現状把握シート（\"&C69&C70&C71&\"）\"","v":"現状把握シート（〇〇市〇〇課）"}]
[]
[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,"No.","業務内容","現状",null,null,null,null,null,null,null,null,null,null,"理想",null,null,null,null,null,null,null,null,null,null,null,"No.","業務内容","従事割合",null,"従事時間"]
[null,"課名","〇〇課",null,null,null,null,null,null,null,null,null,null,"職員A","職員B","職員C","職員D","職員E","職員F","職員G","職員H","職員I","職員J","合計","職員A","職員B","職員C","職員D","職員E","職員F","職員G","職員H","職員I","職員J","合計",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,{"$f":"SUM($N72:$W72)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($Y72:$AH72)","v":0},null,1,"窓口業務",{"$f":"$X72/$X$80","v":{"$error":"#DIV/0!"}},{"$f":"$AI72/$AI$80","v":{"$error":"#DIV/0!"}},{"$f":"$G$87*$X72","v":0},{"$f":"$G$87*$AI72","v":0}]
[null,"●職員数",null,null,null,null,null,null,null,null,null,{"$f":"L72+1","v":2},"巡回業務",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"AK72+1","v":2},"巡回業務",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"職員区分","年齢層（単位：人）",null,null,null,null,null,null,null,null,{"$f":"L73+1","v":3},"維持作業（直営）",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"AK73+1","v":3},"維持作業（直営）",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,null,"10代","20代","30代","40代","50代","60代","70代","合計",null,4,"発注事務",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,4,"発注事務",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"技術職",null,null,null,null,null,null,null,{"$f":"SUM($C76:$I76)","v":0},null,5,"受注者との協議・指示",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,5,"受注者との協議・指示",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"事務職",null,null,null,null,null,null,null,{"$f":"SUM($C77:$I77)","v":0},null,6,"インフラ管理者としての計画策定",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,6,"インフラ管理者としての計画策定",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,"●技術系職員数"]
[null,"再任用",null,null,null,null,null,null,null,{"$f":"SUM($C78:$I78)","v":0},null,7,"技術力向上のための研修・学習等",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,7,"技術力向上のための研修・学習等",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"現業職",null,null,null,null,null,null,null,{"$f":"SUM($C79:$I79)","v":0},null,8,"その他の事務",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,8,"その他の事務",{"$error":"#DIV/0!"},{"$f":"$AI79/$AI$80","v":{"$error":"#DIV/0!"}},0,0]
[null,"会計年度",null,null,null,null,null,null,null,{"$f":"SUM($C80:$I80)","v":0},null,null,"合計",{"$f":"SUM(N$72:N$79)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"合計",{"$f":"SUM(AM$72:AM$79)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AN$72:AN$79)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AO$72:AO$79)","v":0},{"$f":"SUM(AP$72:AP$79)","v":0}]
[null,"合計",{"$f":"SUM(C$76:C$80)","v":0},0,0,0,0,0,0,0]
[]
[null,"●職員勤務時間"]
[null,"年間の所定労働日数（A日）",null,null,null,null,null,"A日","※365日から休日（週5日勤務の場合は約105日）と国民の祝日（16日）、有給休暇、特別休暇の日数を差し引いた日数"]
[null,"１日の標準勤務時間（B時間）",null,null,null,null,null,"B時間","※始業時刻から終業時刻までの時間から、休憩時間を差し引いた労働時間（8:30始業、17:15終業の12～13時が休憩時間の場合は7.75時間）　"]
[null,"1人当たりの月間時間外労働時間（C時間）",null,null,null,null,null,"C時間"]
[null,"1人当たりの年間労働時間（D時間）",null,null,null,null,{"$f":"G84*G85+G86","v":0},"D時間","自動計算：D=A×B＋C×12"]
[]
[null,"入力欄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,{"$f":"\"現状把握シート（\"&C91&C92&C93&\"）\"","v":"現状把握シート（〇〇市〇〇課）"}]
[]
[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,"No.","業務内容","現状",null,null,null,null,null,null,null,null,null,null,"理想",null,null,null,null,null,null,null,null,null,null,null,"No.","業務内容","従事割合",null,"従事時間"]
[null,"課名","〇〇課",null,null,null,null,null,null,null,null,null,null,"職員A","職員B","職員C","職員D","職員E","職員F","職員G","職員H","職員I","職員J","合計","職員A","職員B","職員C","職員D","職員E","職員F","職員G","職員H","職員I","職員J","合計",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,{"$f":"SUM($N94:$W94)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($Y94:$AH94)","v":0},null,1,"窓口業務",{"$f":"$X94/$X$102","v":{"$error":"#DIV/0!"}},{"$f":"$AI94/$AI$102","v":{"$error":"#DIV/0!"}},{"$f":"$G$109*$X94","v":0},{"$f":"$G$109*$AI94","v":0}]
[null,"●職員数",null,null,null,null,null,null,null,null,null,{"$f":"L94+1","v":2},"巡回業務",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"AK94+1","v":2},"巡回業務",{"$f":"$X95/$X$102","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},0,0]
[null,"職員区分","年齢層（単位：人）",null,null,null,null,null,null,null,null,{"$f":"L95+1","v":3},"維持作業（直営）",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"AK95+1","v":3},"維持作業（直営）",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,null,"10代","20代","30代","40代","50代","60代","70代","合計",null,4,"発注事務",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,4,"発注事務",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"技術職",null,null,null,null,null,null,null,{"$f":"SUM($C98:$I98)","v":0},null,5,"受注者との協議・指示",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,5,"受注者との協議・指示",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"事務職",null,null,null,null,null,null,null,{"$f":"SUM($C99:$I99)","v":0},null,6,"インフラ管理者としての計画策定",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,6,"インフラ管理者としての計画策定",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,null,null,"●技術系職員数"]
[null,"再任用",null,null,null,null,null,null,null,{"$f":"SUM($C100:$I100)","v":0},null,7,"技術力向上のための研修・学習等",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,7,"技術力向上のための研修・学習等",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"現業職",null,null,null,null,null,null,null,{"$f":"SUM($C101:$I101)","v":0},null,8,"その他の事務",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,8,"その他の事務",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"会計年度",null,null,null,null,null,null,null,{"$f":"SUM($C102:$I102)","v":0},null,null,"合計",{"$f":"SUM(N$94:N$101)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"合計",{"$f":"SUM(AM$94:AM$101)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AN$94:AN$101)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AO$94:AO$101)","v":0},{"$f":"SUM(AP$94:AP$101)","v":0}]
[null,"合計",{"$f":"SUM(C$98:C$102)","v":0},0,0,0,0,0,0,0]
[]
[null,"●職員勤務時間"]
[null,"年間の所定労働日数（A日）",null,null,null,null,null,"A日","※365日から休日（週5日勤務の場合は約105日）と国民の祝日（16日）、有給休暇、特別休暇の日数を差し引いた日数"]
[null,"１日の標準勤務時間（B時間）",null,null,null,null,null,"B時間","※始業時刻から終業時刻までの時間から、休憩時間を差し引いた労働時間（8:30始業、17:15終業の12～13時が休憩時間の場合は7.75時間）　"]
[null,"1人当たりの月間時間外労働時間（C時間）",null,null,null,null,null,"C時間"]
[null,"1人当たりの年間労働時間（D時間）",null,null,null,null,{"$f":"G106*G107+G108","v":0},"D時間","自動計算：D=A×B＋C×12"]
[]
[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,{"$f":"\"現状把握シート（集計）\"","v":"現状把握シート（集計）"}]
[]
[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,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,"No.","業務内容","従事割合",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,null,null,null,null,null,null,null,null,null,null,1,"窓口業務",{"$f":"$AO117/$AO$125","v":{"$error":"#DIV/0!"}},{"$f":"$AP117/$AP$125","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AO6,AO28,AO50,AO72,AO94)","v":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,null,null,null,null,null,null,null,null,{"$f":"AK117+1","v":2},"巡回業務",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,null,"10代","20代","30代","40代","50代","60代","70代","合計",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":"AK118+1","v":3},"維持作業（直営）",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"技術職",{"$f":"SUM(C10,C32,C54,C76,C98)","v":0},{"$f":"SUM(D10,D32,D54,D76,D98)","v":0},0,0,0,0,0,{"$f":"SUM($C120:$I120)","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,null,4,"発注事務",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"事務職",0,0,0,0,0,0,0,{"$f":"SUM(C121:I121)","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,null,5,"受注者との協議・指示",{"$error":"#DIV/0!"},{"$f":"$AP121/$AP$125","v":{"$error":"#DIV/0!"}},0,0,null,null,"●技術系職員数"]
[null,"再任用",0,0,0,0,0,0,0,{"$f":"SUM(C122:I122)","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,null,6,"インフラ管理者としての計画策定",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"現業職",0,0,0,0,0,0,0,{"$f":"SUM(C123:I123)","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,null,7,"技術力向上のための研修・学習等",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0]
[null,"会計年度",0,0,0,0,0,0,0,{"$f":"SUM(C124:I124)","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,null,8,"その他の事務",{"$error":"#DIV/0!"},{"$f":"$AP124/$AP$125","v":{"$error":"#DIV/0!"}},0,0]
[null,"合計",{"$f":"SUM(C$120:C$124)","v":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,null,"合計",{"$f":"SUM(AM$117:AM$124)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AN$117:AN$124)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AO$117:AO$124)","v":0},{"$f":"SUM(AP$117:AP$124)","v":0}]
[]
[null,"●職員勤務時間"]
[null,"年間の所定労働日数（A日）",null,null,null,null,"―"]
[null,"１日の標準勤務時間（B時間）",null,null,null,null,"―"]
[null,"1人当たりの月間時間外労働時間（C時間）",null,null,null,null,"―"]
[null,"1人当たりの年間労働時間（D時間）",null,null,null,null,"―"]

{"sheet":"②発注状況把握（入力）","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,0,6,0]]}
[]
["記入例","課名","工事名／委託名","業務分類","地区","業種","域内・域外","契約金額（千円）"]
[null,"道路課","A地区舗装補修","維持作業","A地区","土木","域内",3000]
[null,"道路課","A地区街路樹剪定","維持作業","A地区","造園","域内",2000]
[null,"道路課","市内一円パトロール業務","巡回","市内一円","土木","域内",4000]
[null,"河川課","浚渫工事","補修工事","B地域","土木","域外",80000]
[null,"公園課","公園用地草刈業務","維持作業","C地域","シルバー人材・NPO","域内",500]
[]
[null,"課名","工事名／委託名","業務分類","地区","業種","域内・域外","契約金額（千円）"]

{"sheet":"③発注状況把握（金額）","index":2,"n_rows":29,"n_cols":27,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,"総計"]

{"sheet":"③発注状況把握（件数）","index":3,"n_rows":29,"n_cols":27,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,"総計"]

{"sheet":"④導入効果試算 (条件指定)","index":4,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"合計 / 契約金額（百万円）","列ラベル"]
[null,"行ラベル","総計"]
[null,"総計"]

{"sheet":"⑤導入効果試算","index":5,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[21,3,21,4],[22,3,22,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4]]}
[]
[null,"＜試算条件＞",null,null,null,null,"＜試算結果（グラフ）＞"]
[null,null,"入力欄","単位","備考"]
["a","現状の年間直営対応時間",{"$f":"①現状把握!$AO$125","v":0},"時間","①現状把握シートで設定"]
["b","想定する直営対応時間の縮減",null,"時間"]
["c","束ねた後の年間直営対応時間",{"$f":"C4-C5","v":0},"時間","c=a－b"]
["d","１日の標準勤務時間",{"$f":"①現状把握!$G$19","v":0},"時間/日","①現状把握シートで設定"]
[null,"（参考）職員数",24,"人","①現状把握シートで設定"]
[]
["e","職員単価",null,"円/日"]
["f","労務単価",null,"円/日"]
[]
[]
[]
[]
[]
[null,"＜試算結果＞"]
[null,null,"金額（千円）","備考"]
["C1","現状の直営対応コスト",{"$f":"C4*C10/C7/1000","v":{"$error":"#DIV/0!"}},"C1=a×e÷d"]
[null,"現状の対象業務の委託金額",{"$f":"SUMPRODUCT('③発注状況把握（金額）'!C6:J11,'④導入効果試算 (条件指定)'!C6:J11)","v":0}]
["C2","導入後の直営対応コスト",{"$f":"C6*C10/C7/1000","v":{"$error":"#DIV/0!"}},"C2=c×e÷d"]
["C3","新たに必要となる経費",{"$f":"C5*C11/C7/1000","v":{"$error":"#DIV/0!"}},"C3=b×f÷d"]
[null,"対象業務の委託金額（従前と同項目分）",315000]
[null,"概算導入効果",{"$f":"(C21+C22+C23)-(C19+C20)","v":{"$error":"#DIV/0!"}},"百万円"]
[null,null,{"$f":"((C21+C22+C23)-(C19+C20))/(C19+C20)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C25<0,\"コスト削減\",IF(C25>0,\"コスト増加\",\"変動なし\"))","v":{"$error":"#DIV/0!"}}]

{"sheet":"table","index":6,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null,"業務分類",null,"業種",null,"域内・域外"]
[null,"窓口業務",null,"土木",null,"域内"]
[null,"巡回",null,"造園",null,"域外"]
[null,"維持作業",null,"コンサル"]
[null,"計画策定",null,"シルバー人材・NPO"]
[null,"調査・点検",null,"その他"]
[null,"設計"]
[null,"補修工事"]
[null,"その他"]