{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["（記載例）","ケースＡ","ケースＢ"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":13,"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":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[[2,1,2,7],[66,0,66,8],[0,0,0,8],[25,0,26,8],[40,0,40,8],[19,5,20,8],[27,0,30,8],[5,0,6,8],[34,1,34,3],[35,1,35,3],[36,0,36,8],[60,0,60,8],[44,0,44,8],[45,0,45,8],[37,0,37,8],[19,1,19,3],[31,0,31,8],[4,0,4,6],[15,1,15,3],[16,1,16,3],[9,1,9,3],[10,1,10,3],[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
["1人あたりの年間実労働時間(正社員)計算表【記載例】"]
[]
[null,"　こちらの計算表は、「東京ライフ・ワーク・バランス認定企業」一次申請\n「⑫一人あたりの年間実労働時間(当該年度に1年通じて在職していた正社員）」\nを算出するための計算表になります。\n計算表で計算して算出された数字を電子申請システムへご記入いただき、併せて、\n当計算表も電子申請システムへアップロードをお願いいたします。"]
[]
["ケースＡ　当該年度に1年通じて在職していた正社員が、フルタイム正社員のみの場合"]
["※フルタイム正社員とは\n　1週間の所定労働時間が40時間程度（1日8時間・週５日勤務等）で、期間の定めのない労働契約（無期労働契約）を締結した正社員"]
[]
[]
["　（１）以下タブでケース①を選択してください。"]
[]
[]
["　（２）該当する年度の表（白枠部分）に数字を記入してください。"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"\n\n（３）算出された①～③（オレンジ枠部分）\n　　の数字を電子申請システムへ\n　　転記してください。"]
[]
[]
[]
[]
[]
["ケースＢ　当該年度に1年通じて在職していた正社員のうち、短時間正社員がいる場合"]
[]
["※短時間正社員とは…\n　フルタイム正社員と比較して、1週間の所定労働時間が短い正規型の社員であって、いずれにも該当する社員のことを言います。\n　・期間の定めのない労働契約（無期労働契約）を締結している\n　・時間当たりの基本給及び賞与・退職金等の算定方法等が負う種のフルタイム正社員と同等"]
[]
[]
[]
["※当該年度に1年通じて在籍し、６ヵ月以上、短時間勤務制度を活用した正社員については、短時間正社員として算入してください。"]
[]
["　（１）以下タブでケース②を選択してください。"]
[]
[]
["　（２）①正社員換算表のフルタイム正社員の週の所定労働時間（緑枠部分）に数値を入力。"]
["　　　　（例：週の所定労働時間40時間）"]
[]
[]
["　（３）当該年度に1年通じて在籍したフルタイム正社員・短時間正社員の人数を入力してください。"]
[]
[]
[]
["　（４）（３）で入力した短時間正社員全員分の所定労働時間を入力してください。（グレー掛け部分は記入不要です。）"]
[]
[]
[]
[null,null,null,null,"　","１→１週間の所定労働時間20時間"]
[null,null,null,null,null,"２→１週間の所定労働時間30時間"]
[null,null,null,null,null,"３→１週間の所定労働時間30時間"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["　（５）年間実労働時間計算表の以下の項目に数値を記入してください。（以下は例）"]
[]
[]
[]
[]
[]
["（６）算出された①～③（オレンジ枠部分）の数字を電子申請システムへ転記してください。"]

{"sheet":"ケースＡ","index":1,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[17,10,19,12],[18,2,18,4],[19,2,19,4],[4,2,4,4],[5,2,5,4],[7,2,7,7],[9,2,9,4],[10,2,10,4],[4,10,7,12],[11,2,11,4],[12,2,12,4],[13,2,13,4],[15,2,15,7],[17,2,17,4],[8,2,8,4],[16,2,16,4],[16,7,16,8],[16,5,16,6],[1,1,1,13],[4,7,4,8],[4,5,4,6],[8,7,8,8],[8,5,8,6]]}
[]
[null,"1人あたりの年間実労働時間(正社員)計算表（ケースＡ　当該年度に1年通じて在職していた正社員がフルタイム正社員のみの場合）"]
[]
[null,null,"１．当該年度に1年通じて在職していたフルタイム正社員の人数"]
[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,null,"時間",null,"時間"]
[null,null,"年間所定外労働時間数",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人あたりの年間実労働時間（自動計算）"]
[null,null,null,null,null,"前年",null,"前々年"]
[null,null,"①一人当たりの年間実労働時間",null,null,{"$f":"IFERROR(ROUND(((F10+F11-F12-F13-F14)/F6),0),\"\")","v":""},"時間",{"$f":"IFERROR(ROUND(((H10+H11-H12-H13-H14)/H6),0),\"\")","v":""},"時間",null,"①～③の項目について\n電子申請システムへ\n転記してください。"]
[null,null,"②（うち、所定内労働時間）",null,null,{"$f":"IFERROR(ROUND((F18-F20),0),\"\")","v":""},"時間",{"$f":"IFERROR(ROUND((H18-H20),0),\"\")","v":""},"時間"]
[null,null,"③（うち、所定外労働時間）",null,null,{"$f":"IFERROR(ROUND((F11/F6),0),\"\")","v":""},"時間",{"$f":"IFERROR(ROUND((H11/H6),0),\"\")","v":""},"時間"]
[null,null,"①～③は計算式が組まれていますので、入力いただく必要はございません。"]

{"sheet":"ケースＢ","index":2,"n_rows":156,"n_cols":8,"rows_kept":156,"cut":false,"hidden":false,"merged":[[153,2,153,4],[153,6,155,7],[154,2,154,4],[155,2,155,4],[64,3,64,4],[65,3,65,4],[66,3,66,4],[12,2,12,4],[67,2,67,4],[86,2,86,4],[89,2,89,4],[89,6,89,7],[90,2,90,4],[75,6,77,7],[72,2,72,3],[71,2,71,3],[113,3,113,4],[114,3,114,4],[115,3,115,4],[116,3,116,4],[105,3,105,4],[106,3,106,4],[107,3,107,4],[93,2,93,5],[0,1,0,7],[8,2,8,4],[11,6,11,7],[11,2,11,4],[60,3,60,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[15,2,15,5],[59,3,59,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[108,3,108,4],[109,3,109,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[61,3,61,4],[62,3,62,4],[63,3,63,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[58,3,58,4],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[75,2,75,4],[94,3,94,4],[77,2,77,4],[76,2,76,4],[120,3,120,4],[121,3,121,4],[122,3,122,4],[123,3,123,4],[124,3,124,4],[117,3,117,4],[118,3,118,4],[119,3,119,4],[95,3,95,4],[96,3,96,4],[104,3,104,4],[112,3,112,4],[102,3,102,4],[103,3,103,4],[97,3,97,4],[98,3,98,4],[99,3,99,4],[100,3,100,4],[101,3,101,4],[110,3,110,4],[111,3,111,4],[140,3,140,4],[141,3,141,4],[142,3,142,4],[143,3,143,4],[144,3,144,4],[145,2,145,4],[149,2,149,3],[150,2,150,3],[5,2,5,7],[135,3,135,4],[136,3,136,4],[137,3,137,4],[138,3,138,4],[139,3,139,4],[130,3,130,4],[131,3,131,4],[132,3,132,4],[133,3,133,4],[134,3,134,4],[125,3,125,4],[126,3,126,4],[127,3,127,4],[128,3,128,4],[129,3,129,4]]}
[null,"1人あたりの年間実労働時間(正社員)計算表　（ケースＢ　短時間正社員がいる場合）"]
[]
[null,"１．前年度分"]
[]
[null,"（１）正社員数換算表"]
[null,null,"※短時間正社員がいる場合は、以下の表に数字を記載いただき、\n　所定労働時間に応じて算定基礎となる分母の社員数を調整願います。"]
[]
[null,null,"(ア)フルタイム正社員の週の所定労働時間を記入してください。"]
[null,null,"フルタイム正社員の週の所定労働時間",null,null,null,"時間"]
[]
[null,null,"(イ)当該年度に1年通じて在職していたフルタイム正社員と短時間正社員の社員数を記入してください。"]
[null,null,"フルタイム正社員（通年在職）数",null,null,null,"人"]
[null,null,"短時間正社員（通年在職）数",null,null,null,"人"]
[]
[null,null,"(ウ)（イ）で回答した短時間正社員の所定労働時間を全員分記入してください。"]
[null,null,"所定労働時間に応じた換算率"]
[null,null,"人数","当該短時間正社員の\n週の所定労働時間（時間）",null,"所定労働時間に応じた換算社員数（人）"]
[null,null,1,null,null,{"$f":"IFERROR((D18/$F$9),\"0\")","v":"0"}]
[null,null,2,null,null,{"$f":"IFERROR((D19/$F$9),\"0\")","v":"0"}]
[null,null,3,null,null,"0"]
[null,null,4,null,null,"0"]
[null,null,5,null,null,"0"]
[null,null,6,null,null,"0"]
[null,null,7,null,null,"0"]
[null,null,8,null,null,"0"]
[null,null,9,null,null,"0"]
[null,null,10,null,null,"0"]
[null,null,11,null,null,"0"]
[null,null,12,null,null,"0"]
[null,null,13,null,null,"0"]
[null,null,14,null,null,"0"]
[null,null,15,null,null,"0"]
[null,null,16,null,null,"0"]
[null,null,17,null,null,"0"]
[null,null,18,null,null,"0"]
[null,null,19,null,null,"0"]
[null,null,20,null,null,"0"]
[null,null,21,null,null,"0"]
[null,null,22,null,null,"0"]
[null,null,23,null,null,"0"]
[null,null,24,null,null,"0"]
[null,null,25,null,null,"0"]
[null,null,26,null,null,"0"]
[null,null,27,null,null,"0"]
[null,null,28,null,null,"0"]
[null,null,29,null,null,"0"]
[null,null,30,null,null,"0"]
[null,null,31,null,null,"0"]
[null,null,32,null,null,"0"]
[null,null,33,null,null,"0"]
[null,null,34,null,null,"0"]
[null,null,35,null,null,"0"]
[null,null,36,null,null,"0"]
[null,null,37,null,null,"0"]
[null,null,38,null,null,"0"]
[null,null,39,null,null,"0"]
[null,null,40,null,null,"0"]
[null,null,41,null,null,"0"]
[null,null,42,null,null,"0"]
[null,null,43,null,null,"0"]
[null,null,44,null,null,"0"]
[null,null,45,null,null,"0"]
[null,null,46,null,null,"0"]
[null,null,47,null,null,"0"]
[null,null,48,null,null,"0"]
[null,null,49,null,null,"0"]
[null,null,50,null,null,"0"]
[null,null,"算定基礎となる正社員数（合計）",null,null,{"$f":"SUM(F18:F67)+F12","v":0}]
[]
[null,"（２）年間実労働時間算出表"]
[null,null,"当該年度に1年通じて在職していたフルタイム正社員及び短時間正社員全員の合計値をご記入ください。"]
[null,null,"年間所定労働時間",null,"年間所定外労働時間","年次有給休暇時間数","欠勤・遅刻・早退時間","その他の\n休暇時間数"]
[]
[]
[null,null,"①～③は計算式が組まれています。ご記入いただく必要はございません。"]
[null,null,"①　1人あたりの年間実労働時間",null,null,{"$f":"IFERROR(ROUND(((C73+E73-F73-G73-H73)/F68),0),\"\")","v":""},"①～③の項目について\n電子申請システムへ\n転記してください。"]
[null,null,"②　うち、所定内労働時間",null,null,{"$f":"IFERROR(ROUND((F76-F78),0),\"\")","v":""}]
[null,null,"③　うち、所定外労働時間",null,null,{"$f":"IFERROR(ROUND((E73/F68),0),\"\")","v":""}]
[]
[]
[null,"２．前々年度分"]
[]
[null,"（１）正社員数換算表"]
[null,null,"※短時間正社員がいる場合は、以下の表に数字を記載いただき、所定労働時間に応じて算定基礎となる分母の社員数を調整願います。"]
[]
[null,null,"(ア)フルタイム正社員の週の所定労働時間を記入してください。"]
[null,null,"フルタイム正社員の週の所定労働時間",null,null,null,"時間"]
[]
[null,null,"(イ)当該年度に1年通じて在職していたフルタイム正社員と短時間正社員の社員数を記入してください。"]
[null,null,"フルタイム正社員（通年在職）数",null,null,null,"人"]
[null,null,"短時間正社員（通年在職）数",null,null,null,"人"]
[]
[null,null,"(ウ)（イ）で回答した短時間正社員の所定労働時間を全員分記入してください。"]
[null,null,"所定労働時間に応じた換算率"]
[null,null,"人数","当該短時間正社員の\n週の所定労働時間（時間）",null,"所定労働時間に応じた換算社員数（人）"]
[null,null,1,null,null,{"$f":"IFERROR((D96/$F$9),\"0\")","v":"0"}]
[null,null,2,null,null,{"$f":"IFERROR((D97/$F$9),\"0\")","v":"0"}]
[null,null,3,null,null,"0"]
[null,null,4,null,null,"0"]
[null,null,5,null,null,"0"]
[null,null,6,null,null,"0"]
[null,null,7,null,null,"0"]
[null,null,8,null,null,"0"]
[null,null,9,null,null,"0"]
[null,null,10,null,null,"0"]
[null,null,11,null,null,"0"]
[null,null,12,null,null,"0"]
[null,null,13,null,null,"0"]
[null,null,14,null,null,"0"]
[null,null,15,null,null,"0"]
[null,null,16,null,null,"0"]
[null,null,17,null,null,"0"]
[null,null,18,null,null,"0"]
[null,null,19,null,null,"0"]
[null,null,20,null,null,"0"]
[null,null,21,null,null,"0"]
[null,null,22,null,null,"0"]
[null,null,23,null,null,"0"]
[null,null,24,null,null,"0"]
[null,null,25,null,null,"0"]
[null,null,26,null,null,"0"]
[null,null,27,null,null,"0"]
[null,null,28,null,null,"0"]
[null,null,29,null,null,"0"]
[null,null,30,null,null,"0"]
[null,null,31,null,null,"0"]
[null,null,32,null,null,"0"]
[null,null,33,null,null,"0"]
[null,null,34,null,null,"0"]
[null,null,35,null,null,"0"]
[null,null,36,null,null,"0"]
[null,null,37,null,null,"0"]
[null,null,38,null,null,"0"]
[null,null,39,null,null,"0"]
[null,null,40,null,null,"0"]
[null,null,41,null,null,"0"]
[null,null,42,null,null,"0"]
[null,null,43,null,null,"0"]
[null,null,44,null,null,"0"]
[null,null,45,null,null,"0"]
[null,null,46,null,null,"0"]
[null,null,47,null,null,"0"]
[null,null,48,null,null,"0"]
[null,null,49,null,null,"0"]
[null,null,50,null,null,"0"]
[null,null,"算定基礎となる正社員数（合計）",null,null,{"$f":"SUM(F96:F145)+F90","v":0}]
[]
[null,"（２）年間実労働時間算出表"]
[null,null,"当該年度に1年通じて在職していたフルタイム正社員及び短時間正社員全員の合計値をご記入ください。"]
[null,null,"年間所定労働時間",null,"年間所定外労働時間","年次有給休暇時間数","欠勤・遅刻・早退時間","その他の\n休暇時間数"]
[]
[]
[null,null,"①～③は計算式が組まれています。ご記入いただく必要はございません。"]
[null,null,"①　1人あたりの年間実労働時間",null,null,{"$f":"IFERROR(ROUND(((C151+E151-F151-G151-H151)/F146),0),\"\")","v":""},"①～③の項目について\n電子申請システムへ\n転記してください。"]
[null,null,"②　うち、所定内労働時間",null,null,{"$f":"IFERROR(ROUND((F154-F156),0),\"\")","v":""}]
[null,null,"③　うち、所定外労働時間",null,null,{"$f":"IFERROR(ROUND((E151/F146),0),\"\")","v":""}]