{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["給与等【要入力】","勤務状況【要入力】","様式","プルダウン"],"not_rendered":{"charts":0,"images":0,"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":178,"n_cols":16,"rows_kept":178,"cut":false,"hidden":false,"merged":[[177,1,177,12],[33,14,33,19],[17,2,17,3],[19,2,19,3],[22,2,22,3],[25,2,25,3],[23,2,23,3],[22,4,23,4],[22,5,23,12],[47,1,59,1],[156,1,156,5],[143,6,143,7],[158,1,158,2],[158,5,158,6],[101,2,101,4],[150,1,150,7],[151,1,151,7],[141,1,141,2],[142,1,142,2],[143,1,143,2],[139,1,139,2],[132,1,132,12],[117,2,117,4],[105,7,117,8],[3,1,3,2],[20,2,20,3],[19,4,20,4],[19,5,20,12],[12,6,12,7],[12,8,12,10],[13,2,13,4],[10,2,10,4],[26,2,26,4],[25,5,26,12],[13,7,13,10],[12,11,12,13],[7,11,7,12],[1,0,1,13],[81,1,81,2],[28,1,28,3],[30,1,30,3],[71,7,71,11],[69,1,69,3],[69,4,69,5],[44,2,44,4],[12,1,12,2],[17,5,17,12],[71,1,71,3],[12,3,12,4],[77,1,77,5],[28,4,29,4],[29,1,29,3],[3,11,3,13],[7,8,7,9],[9,8,9,10],[7,1,7,2],[7,3,7,4],[9,1,9,2],[9,3,9,4],[7,6,7,7],[9,6,9,7],[156,7,156,12],[152,1,152,7],[158,9,158,10],[102,2,102,10],[128,1,128,4],[105,1,117,1],[150,10,150,11],[134,1,134,3],[134,4,134,5],[136,1,136,2],[138,1,138,2],[88,1,89,1],[135,1,135,5],[145,1,146,1],[122,1,122,12],[93,7,93,12],[93,1,93,5],[79,1,79,2],[83,1,83,2],[84,1,84,2],[85,1,85,2],[95,1,95,8],[96,1,97,4],[98,1,98,4],[99,1,99,4],[127,1,127,4],[127,8,127,10],[125,1,125,4],[126,1,126,4],[86,1,86,2],[126,8,126,10],[86,6,86,7],[100,1,100,4],[140,1,140,2],[82,1,82,2],[61,1,61,4],[39,1,40,4],[41,1,41,4],[27,5,30,12],[33,1,33,12],[39,11,40,12],[59,2,59,4],[43,1,43,4],[27,1,27,3],[37,1,37,5],[42,1,42,4],[63,1,67,1]]}
[]
["【平均給与額算定シート】　下記１～５について、記入してください。"]
[]
["※","緑色セル",null,"が入力箇所になります。その他セルは計算式が入っているため、修正・変更しないでください。"]
[]
["１　被災職員の基本情報"]
[]
[null,"被災職員氏名",null,null,null,null,"生年月日\n※年齢は作成日時点",null,null,null,{"$f":"IF($I$8=\"\",\"\",DATEDIF($I$8,TODAY(),\"Y\")&\"歳\")","v":""},{"$f":"IFERROR(IF($I$8=\"\",\"\",\"（被災当時\"&DATEDIF($I$8,D10,\"Y\")&\"歳）\"),\"\")","v":""}]
[]
[null,"災害発生の日",null,null,null,null,"補償の種類"]
[null,"解説","災害発生の日とは？・・・負傷若しくは死亡の原因である事故の発生の日又は診断によつて疾病の発生が確定した日"]
[]
[null,"補償事由発生日",null,null,null,null,"採用年月日",null,null,null,null,{"$f":"IFERROR(IF(AND(D10=I13,D10<>\"\"),\"（採用日当日に被災）\",IF(AND(D10<EDATE($I$13,1),D10>=EDATE($I$13,0),D10<>\"\"),\"（採用から1か月以内に被災）：特例計算に該当\",IF(AND(D10<EDATE($I$13,2),D10>=EDATE($I$13,1),D10<>\"\"),\"（採用から2か月以内に被災）\",IF(AND(D10<EDATE($I$13,3),D10>=EDATE($I$13,2),D10<>\"\"),\"（採用から3か月以内に被災）\",\"\")))),\"\")","v":""},null,null,{"$f":"DATE(YEAR(D13)-(MONTH(D13)<4),4,1)","v":"3799-04-01"}]
[null,"解説",{"$f":"IF(COUNTIF($I$10,\"*\"&\"休業\"&\"*\")=1,\"補償事由発生日（休業補償）とは？・・・「療養のため勤務することができず、給与を受けない日」\",IF(COUNTIF($I$10,\"*\"&\"傷病補償\"&\"*\")=1,\"補償事由発生日（傷病補償）とは？・・・「療養の開始後１年６か月を経過した日以後において治ゆせず、かつ、傷病による障害の程度が傷病等級に該当することとなった日」\",IF(COUNTIF($I$10,\"*\"&\"障害\"&\"*\")=1,\"補償事由発生日（障害補償）とは？・・・「負傷又は疾病が治り障害等級に該当することとなった日（症状固定日）」\",IF(COUNTIF($I$10,\"*\"&\"遺族\"&\"*\")=1,\"補償事由発生日（遺族補償）とは？・・・「死亡した日」\",IF(COUNTIF($I$10,\"*\"&\"葬祭\"&\"*\")=1,\"補償事由発生日（葬祭補償）とは？・・・「死亡した日」\",\"\")))))","v":""},null,null,null,"解説","採用年月日とは？・・・被災職員が採用された日。再任用職員の場合は再任用として採用された日を指すため注意。"]
[]
["２　災害発生の日の属する月の前月の末日から起算して過去３月間の給与の計算"]
[null,"以下、①～④について、「○」「×」を選択してください。"]
[null,"①","補償事由発生日の時点で職員は離職していますか。",null,null,{"$f":"IFERROR(IF(AND(E18=\"〇\",$P$155>=2),\"【様式（I）欄】　離職後に補償を行なうべき事由が生じ、かつ、補償事由発生日が災害発生の日の属する年度の翌々年度の計算に該当\",IF(E18=\"〇\",\"【様式（H）欄】　被災職員が離職した後に補償する事由が生じた場合の計算に該当\",\"\")),\"\")","v":""}]
[]
[null,"②","給与改定がありましたか。",null,null,{"$f":"IF(E20=\"〇\",\"【注意！】　遡って昇給や昇格があった場合等、給与が遡及して改定された場合には、再計算した金額を記入してください。\",\"\")","v":""}]
[null,"解説","災害発生の日の属する月の前月の末日から起算して過去３月間で給与改定があった。もしくは、災害発生日・補償事由発生日に給与改定があった。"]
[]
[null,"③","採用日当日起きた災害に該当しますか。",null,null,{"$f":"IF(E23=\"〇\",\"【様式（E）欄】　規則第３条第２項（採用された日に災害を受けた場合の計算）に該当\",\"\")","v":""}]
[null,"解説","再任用の場合は、再任用職員として採用された日を採用日とします。"]
[]
[null,"④","以下いずれかに該当しますか。",null,null,{"$f":"IF(O26=\"〇\",\"【様式（D）欄】　規則第３条第１項（採用の日の属する月に災害を受けた場合等）に該当\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF($E$28:$E$31,\"〇\")>=1,\"〇\",IF(COUNTIF($E$28:$E$31,\"×\")=3,\"×\",\"\"))","v":""}]
[null,"解説","災害発生の日時点で「再任用職員」の場合は、正職員の頃の給与期間は含めません。"]
[null,"給与を受けない期間が過去3か月の全日数にわたる場合",null,null,null,{"$f":"IF(AND($E$23=\"〇\",COUNTIF($E$28:$E$31,\"〇\")>=1),\"エラー！　③が「〇」の場合は、④は全て「×」（該当なし）になります。\",IF(COUNTIF($E$28:$E$31,\"〇\")>1,\"エラー！　「〇」はいずれか１つのみです。\",\"\"))","v":""}]
[null,"控除事由に掲げる日が過去3か月の全日数にわたる場合"]
[null,"⇒ 「控除事由」とは？（クリック）"]
[null,"採用の日の属する月に災害を受けた場合"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(P155>=2,E23=\"×\",O26=\"×\"),\"（１）原則計算　及び　（２）災害発生の日における基本的給与の月額　へ進む。\",IF(AND(E23=\"×\",O26=\"×\"),\"（１）原則計算　へ進む\",IF(AND(E23=\"〇\",O26=\"×\"),\"（２）災害発生の日における基本的給与の月額　へ進む\",IF(AND(AND(E18=\"〇\",P155>=2),E23=\"×\",O26=\"〇\"),\"（２）災害発生の日における基本的給与の月額　（３）過去３か月間に支払われた給与がない場合等の計算　へ進む\",IF(AND(E23=\"×\",O26=\"〇\"),\"（３）過去３か月間に支払われた給与がない場合等の計算　へ進む\",IF(OR(E18=\"\",E23=\"\",O26=\"\"),\"\",\"上記選択に誤り又は空欄があります。\")))))),\"\")","v":""}]
[]
["（１）【原則計算】",null,null,{"$f":"IF($L$13=\"（採用から2か月以内に被災）\",\"※災害発生の日の属する月の前月の末日から起算して「過去１月間」の給与で計算\",IF($L$13=\"（採用から3か月以内に被災）\",\"※災害発生の日の属する月の前月の末日から起算して「過去２月間」の給与で計算\",\"\"))","v":""}]
[]
[]
[]
[null,"給与期間",null,null,null,{"$f":"IF(OR(L13=\"（採用から2か月以内に被災）\",L13=\"（採用から3か月以内に被災）\"),\"\",IFERROR(DATE(YEAR(D10),MONTH(D10)-3,1),\"\"))","v":""},"から",{"$f":"IF(L13=\"（採用から2か月以内に被災）\",\"\",IFERROR(DATE(YEAR(D10),MONTH(D10)-2,1),\"\"))","v":""},"から",{"$f":"IFERROR(DATE(YEAR(D10),MONTH(D10)-1,1),\"\")","v":""},"から","計"]
[null,null,null,null,null,{"$f":"IF(OR(L13=\"（採用から2か月以内に被災）\",L13=\"（採用から3か月以内に被災）\"),\"\",IFERROR(DATE(YEAR(D10),MONTH(D10)-2,0),\"\"))","v":""},"まで",{"$f":"IF(L13=\"（採用から2か月以内に被災）\",\"\",IFERROR(DATE(YEAR(D10),MONTH(D10)-1,0),\"\"))","v":""},"まで",{"$f":"IFERROR(DATE(YEAR(D10),MONTH(D10),0),\"\")","v":"00:00:00"},"まで"]
[null,"総日数",null,null,null,{"$f":"IFERROR(IF(COUNTIF($B$34,\"*\"&\"原則計算\"&\"*\")=1,F41-F40+1,0),0)","v":0},"日",{"$f":"IFERROR(IF(COUNTIF($B$34,\"*\"&\"原則計算\"&\"*\")=1,H41-H40+1,0),0)","v":0},"日",{"$f":"IF(COUNTIF($B$34,\"*\"&\"原則計算\"&\"*\")=1,J41-J40+1,0)","v":0},"日",{"$f":"SUM(F42:K42)","v":0},"日"]
[null,"勤務した日数",null,null,null,{"$f":"勤務状況【要入力】!$S$19","v":0},"日",{"$f":"勤務状況【要入力】!$S$29","v":0},"日",{"$f":"勤務状況【要入力】!$S$39","v":0},"日",{"$f":"SUM(F43:K43)","v":0},"日"]
[null,"控除日数",null,null,null,{"$f":"勤務状況【要入力】!U19","v":0},"日",{"$f":"勤務状況【要入力】!U29","v":0},"日",{"$f":"勤務状況【要入力】!U39","v":0},"日",{"$f":"SUM(F44:K44)","v":0},"日",null,{"$f":"IF(COUNTIF($F$44:$J$44,0)<2,\"控除月複数\",\"控除月なし又は単月\")","v":"控除月なし又は単月"}]
[null,null,"控除日数のうち、勤務を要しない日数",null,null,{"$f":"勤務状況【要入力】!W19","v":0},"日",{"$f":"勤務状況【要入力】!W29","v":0},"日",{"$f":"勤務状況【要入力】!W39","v":0},"日",{"$f":"SUM(F45:K45)","v":0},"日"]
[null,null,"⇒　「勤務した日数」「控除日数」は【別シート】で算出（クリックして別シートへ移動）"]
[null,null,null,null,null,{"$f":"IF(OR($L$13=\"（採用から2か月以内に被災）\",$L$13=\"（採用から3か月以内に被災）\"),\"↓入力不要↓\",\"\")","v":""},null,{"$f":"IF($L$13=\"（採用から2か月以内に被災）\",\"↓入力不要↓\",\"\")","v":""}]
[null,"給与","給料","当月払い","固定給",0,"円",0,"円",0,"円",{"$f":"SUM(F48:K48)","v":0},"円"]
[null,null,"扶養手当","当月払い","固定給",0,"円",0,"円",0,"円",0,"円"]
[null,null,"地域手当","当月払い","固定給",0,"円",0,"円",0,"円",0,"円"]
[null,null,"住居手当","当月払い","固定給",0,"円",0,"円",0,"円",0,"円"]
[null,null,"通勤手当","当月払い","固定給",0,"円",0,"円",0,"円",0,"円"]
[null,null,"時間外勤務手当","翌月払い","実績給",0,"円",0,"円",0,"円",0,"円"]
[null,null,"宿日直手当","翌月払い","実績給",0,"円",0,"円",0,"円",0,"円"]
[null,null,null,null,null,0,"円",0,"円",0,"円",0,"円"]
[null,null,null,null,null,0,"円",0,"円",0,"円",{"$f":"SUM(F56:K56)","v":0},"円"]
[null,null,null,null,null,0,"円",0,"円",0,"円",{"$f":"SUM(F57:K57)","v":0},"円"]
[null,null,null,null,null,0,"円",0,"円",0,"円",0,"円"]
[null,null,null,null,null,0,"円",0,"円",0,"円",0,"円"]
[null,null,"計",null,null,{"$f":"SUM(F48:G59)","v":0},"円",{"$f":"SUM(H48:I59)","v":0},"円",{"$f":"SUM(J48:K59)","v":0},"円",0,"円"]
[]
[null,"減額された給与",null,null,null,0,"円",0,"円",0,"円",{"$f":"SUM(F62:K62)","v":0},"円"]
[]
[null,"補　足","※他に手当がある場合は適宜【緑色セル】に記入してください。"]
[null,null,"※期末勤勉手当は含めません。"]
[null,null,"※通勤手当について平均給与額の算定期間前にまとめて支給される場合は、その額を支給単位期間で除して1月当たりの通勤手当額を算出します。"]
[null,null,"　⇒除した結果、各月ごとの額に端数が生じる場合は、その端数は各月において端数処理を行いません。"]
[null,null,"※給与支給事務上、勤務した月の翌月に支払われる給与は、勤務した月に支払われた給与として取扱います。（時間外勤務手当等）"]
[]
[null,"控除日の勤務に対して支払われた時間外勤務手当等の合計（自動計算）",null,null,{"$f":"勤務状況【要入力】!$G$21+勤務状況【要入力】!G31+勤務状況【要入力】!G41","v":0},null,"円"]
[]
[null,"寒冷地手当の有無",null,null,null,null,"円",{"$f":"IF(E72=\"有\",\"※直近の支給日に支給された寒冷地手当の月額を記入\",\"※「無」の場合、金額記入不要\")","v":"※「無」の場合、金額記入不要"}]
[]
[null,"補足","※寒冷地手当の有無：災害発生日に支給地域に在勤しており、過去１年間に寒冷地手当が支給された場合は「有」を選択してください。"]
[]
["（２）災害発生の日における基本的給与の月額",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(P155>=2,$E$23=\"〇\"),\"下記表を記入願います。\",\"下記表は記入不要です。\"),\"下記表は記入不要です。\")","v":"下記表は記入不要です。"}]
[]
[null,"「災害発生の日」における給与情報を記入してください。"]
[]
[null,null,null,"職","給料表",null,"級",null,"号"]
[]
[null,"給料",null,0,"円"]
[null,"第二種初任給調整手当",null,0,"円"]
[null,"扶養手当",null,0,"円"]
[null,"地域手当",null,0,"円"]
[null,"特地勤務手当",null,0,"円"]
[null,"へき地勤務手当",null,0,"円","計",{"$f":"SUM($D$82:$D$87)","v":0},null,"円"]
[]
[null,"補足","※地域手当については、給料及び扶養手当の月額に対するものが対象であり、管理職手当の月額に対するものは含まれません。"]
[null,null,"※給与が遡及して改定された場合には、再計算した金額を記入してください。"]
[]
["（３）過去３か月間に支払われた給与がない場合等の計算"]
[null,"「給与期間」の特定"]
[null,{"$f":"IFERROR(INDEX($B$28:$D$31,MATCH(\"〇\",$E$28:$E$31,0),1),\"下記表は記入不要です。\")","v":"下記表は記入不要です。"},null,null,null,null,{"$f":"IF($B$94=\"下記表は記入不要です。\",\"\",\"⇒\")","v":""},{"$f":"IF($B$94=$B$28,\"「その期間経過後初めて給与を受けるに至った日から災害発生の日までの期間」＝「給与期間」となる\",IF($B$94=$B$29,\"「控除事由のやんだ日から災害発生の日までの期間」＝「給与期間」となる\",IF($B$94=$B$31,\"「採用の日から災害発生の日までの期間」＝「給与期間」となる\",\"\")))","v":""}]
[]
[null,"「上記で特定した給与期間」における給与情報を記入してください。"]
[null,"給与期間",null,null,null,null,"から",null,null,null,null,null,null,null,{"$f":"DATE(YEAR(F97),MONTH(F97),1)","v":"1900-01-01"}]
[null,null,null,null,null,null,"まで",null,null,null,null,null,null,null,{"$f":"DATE(YEAR(F98),MONTH(F98)+1,0)","v":"1900-01-31"},{"$f":"O98-O97+1","v":31}]
[null,"総日数",null,null,null,{"$f":"F98-F97+1","v":1},"日"]
[null,"勤務した日数",null,null,null,{"$f":"勤務状況【要入力】!S50","v":0},"日"]
[null,"控除日数",null,null,null,{"$f":"勤務状況【要入力】!U50","v":0},"日"]
[null,null,"控除日数のうち、勤務を要しない日数",null,null,{"$f":"勤務状況【要入力】!W50","v":0},"日"]
[null,null,"⇒　「勤務した日数」「控除日数」は【別シート】で算出（クリックして別シートへ移動）"]
[]
[null,"＜給与を受けた月の給与等の総額を記入＞"]
[null,"給与","給料","当月払い","固定給",0,"円","給与期間見合い分の算出→",null,{"$f":"IF(E106=\"固定給\",F106/(($O$98-$O$97+1)-勤務状況【要入力】!$G$52)*給与等【要入力】!$F$100,F106)","v":0},"円"]
[null,null,"扶養手当","当月払い","固定給",0,"円",null,null,{"$f":"IF(E107=\"固定給\",F107/(($O$98-$O$97+1)-勤務状況【要入力】!$G$52)*給与等【要入力】!$F$100,F107)","v":0},"円"]
[null,null,"地域手当","当月払い","固定給",0,"円",null,null,{"$f":"IF(E108=\"固定給\",F108/(($O$98-$O$97+1)-勤務状況【要入力】!$G$52)*給与等【要入力】!$F$100,F108)","v":0},"円"]
[null,null,"住居手当","当月払い","固定給",0,"円",null,null,{"$f":"IF(E109=\"固定給\",F109/(($O$98-$O$97+1)-勤務状況【要入力】!$G$52)*給与等【要入力】!$F$100,F109)","v":0},"円"]
[null,null,"通勤手当","当月払い","固定給",0,"円",null,null,{"$f":"IF(E110=\"固定給\",F110/(($O$98-$O$97+1)-勤務状況【要入力】!$G$52)*給与等【要入力】!$F$100,F110)","v":0},"円"]
[null,null,"時間外勤務手当","翌月払い","実績給",0,"円",null,null,{"$f":"IF(E111=\"固定給\",F111/(($O$98-$O$97+1)-勤務状況【要入力】!$G$52)*給与等【要入力】!$F$100,F111)","v":0},"円"]
[null,null,"宿日直手当","翌月払い","実績給",0,"円",null,null,{"$f":"IF(E112=\"固定給\",F112/(($O$98-$O$97+1)-勤務状況【要入力】!$G$52)*給与等【要入力】!$F$100,F112)","v":0},"円"]
[null,null,null,null,null,0,"円",null,null,{"$f":"IF(E113=\"固定給\",F113/(($O$98-$O$97+1)-勤務状況【要入力】!$G$52)*給与等【要入力】!$F$100,F113)","v":0},"円"]
[null,null,null,null,null,0,"円",null,null,{"$f":"IF(E114=\"固定給\",F114/(($O$98-$O$97+1)-勤務状況【要入力】!$G$52)*給与等【要入力】!$F$100,F114)","v":0},"円"]
[null,null,null,null,null,0,"円",null,null,{"$f":"IF(E115=\"固定給\",F115/(($O$98-$O$97+1)-勤務状況【要入力】!$G$52)*給与等【要入力】!$F$100,F115)","v":0},"円"]
[null,null,null,null,null,0,"円",null,null,{"$f":"IF(E116=\"固定給\",F116/(($O$98-$O$97+1)-勤務状況【要入力】!$G$52)*給与等【要入力】!$F$100,F116)","v":0},"円"]
[null,null,null,null,null,0,"円",null,null,{"$f":"IF(E117=\"固定給\",F117/(($O$98-$O$97+1)-勤務状況【要入力】!$G$52)*給与等【要入力】!$F$100,F117)","v":0},"円"]
[null,null,"計",null,null,{"$f":"SUM(F106:G117)","v":0},"円",null,null,{"$f":"SUM(J106:K117)","v":0},"円"]
[]
[null,"補足","※例）4月1日採用で4月8日負傷した場合⇒4月分の給与総額を記入してください。"]
[]
[]
[null,"【該当すれば自動計算されます】\n＜このような特例計算においても、法第２条第４項ただし書き（最低保障計算）及び同条第６項（控除計算）の規定が準用されます。＞"]
[null,"⇒",{"$f":"IF(AND(SUMIF(E106:E117,\"実績給\",F106:F117)>0,F101>0),\"「実績給がある」、かつ、「控除日数がある」ため法第2条第4項（最低保障計算）・同条第6項（控除計算）と比較する必要あり。\",IF(SUMIF(E106:E117,\"実績給\",F106:F117)>0,\"「実績給がある」ため法第2条第4項（最低保障計算）と比較する必要あり。\",IF(F101>0,\"「控除日数がある」ため、法第2条第6項（控除計算）と比較する必要あり。\",\"該当しないため比較不要\")))","v":"該当しないため比較不要"}]
[null,"⇒",{"$f":"IF(C124=\"該当しないため比較不要\",\"該当しないため比較不要\",\"比較計算の結果、「\"&I127&\"」が最も高い金額ため、当該金額が様式（D）欄に採用される。\")","v":"該当しないため比較不要"}]
[null,"規則第３条第１項による金額",null,null,null,{"$f":"J118/F99","v":0},"円",null,"最も高い金額↓"]
[null,"法第２条第４項ただし書き（最低保障計算）",null,null,null,{"$f":"IF(SUMIF(E106:E117,\"実績給\",F106:F117)>0,SUMIF(E106:E117,\"実績給\",J106:J117)/F100*0.6+SUMIF(E106:E117,\"固定給\",J106:J117)/F99,0)","v":0},"円",null,{"$f":"INDEX(B126:F129,MATCH(MAX(F126:F129),F126:F129,0),1)","v":"規則第３条第１項による金額"}]
[null,"法第２条第６項本文（控除計算）",null,null,null,{"$f":"IF(F101=0,0,(F118-(F118/P98*F101))/P98-F101)","v":0},"円",null,{"$f":"INDEX(B126:F129,MATCH(MAX(F126:F129),F126:F129,0),5)","v":0}]
[null,"法第２条第６項ただし書き（控除計算）",null,null,null,{"$f":"IF(F101=0,0,SUMIF(E106:E117,\"実績給\",J106:J117)/(F100-F101+F102)*0.6+(SUMIF(E106:E117,\"固定給\",J106:J117)-(F118/P98*F101))/F99-F101)","v":0},"円"]
[]
["３　補償事由発生日における基本的給与の月額"]
[]
[null,{"$f":"IF(COUNTIF($I$10,\"*\"&\"休業\"&\"*\")=1,\"「療養のため勤務することができず、給与を受けない日」が補償事由発生日となる。\",IF(COUNTIF($I$10,\"*\"&\"傷病補償\"&\"*\")=1,\"「療養の開始後１年６か月を経過した日以後において治ゆせず、かつ、傷病による障害の程度が傷病等級に該当することとなった日」が補償事由発生日となる。\",IF(COUNTIF($I$10,\"*\"&\"障害\"&\"*\")=1,\"「負傷又は疾病が治り障害等級に該当することとなった日」（症状固定日）が補償事由発生日となる。\",IF(COUNTIF($I$10,\"*\"&\"遺族\"&\"*\")=1,\"「死亡した日」が補償事由発生日となる。\",IF(COUNTIF($I$10,\"*\"&\"葬祭\"&\"*\")=1,\"「死亡した日」が補償事由発生日となる。\",\"１　被災職員の基本情報「補償の種類」を選択してください。\")))))","v":"１　被災職員の基本情報「補償の種類」を選択してください。"}]
[]
[null,"補償事由発生日",null,null,{"$f":"D13","v":"00:00:00"}]
[null,"「補償事由発生日」における給与情報を記入してください。"]
[null,null,null,"職","給料表",null,"級",null,"号"]
[]
[null,"給料",null,0,"円"]
[null,"第二種初任給調整手当",null,0,"円"]
[null,"扶養手当",null,0,"円"]
[null,"地域手当",null,0,"円"]
[null,"特地勤務手当",null,0,"円"]
[null,"へき地勤務手当",null,0,"円","計",{"$f":"SUM($D$139:$D$144)","v":0},null,"円"]
[]
[null,"補足","※補償事由発生日の時点で「離職」している場合、離職時に占めていた職に引き続き在職していたものとして記入してください。"]
[null,null,"※給与が遡及して改定された場合には、再計算した金額を記入してください。"]
[]
["４　スライド率"]
[]
[null,{"$f":"IFERROR(IF(AND($E$23=\"〇\",P155>=2),\"スライド率早見表を参考に記入してください。\",IF(P155>=2,\"スライド率早見表を参考に記入してください。\",\"記入不要です。\")),\"記入不要です。\")","v":"記入不要です。"},null,null,null,null,null,null,null,"スライド率",null,null,null,null,"災害発生日時",{"$f":"YEAR(EDATE($D$10,-3))","v":{"$error":"#NUM!"}}]
[null,{"$f":"IF(B151=\"スライド率早見表を参考に記入してください。\",\"※支給すべき年金の属する期間：補償事由発生日の属する期間\",\"\")","v":""}]
[null,{"$f":"IF(B151=\"スライド率早見表を参考に記入してください。\",\"※年金たる補償を支給すべき事由が生じた日の属する期間：災害発生の日の属する期間\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"補償事由発生日",{"$f":"YEAR(EDATE($E$135,-3))","v":{"$error":"#NUM!"}}]
["５　最低保障額　／　最低限度額・最高限度額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P154-P151","v":{"$error":"#NUM!"}}]
[]
[null,{"$f":"IF(OR(COUNTIF($I$10,\"*\"&\"年金\"&\"*\")=1,COUNTIF($I$10,\"*\"&\"休業\"&\"*\")=1),\"最低最高限度額早見表を参考に最低限度額・最高限度額を記入してください。\",IF($I$10=\"\",\"記入不要です。\",\"最低保障額早見表を参考に最低保障額を記入してください。\"))","v":"記入不要です。"},null,null,null,null,{"$f":"IF($B$157=\"記入不要です。\",\"\",\"⇒\")","v":""},{"$f":"IF($B$157=\"最低保障額早見表を参考に最低保障額を記入してください。\",\"最低保障額は、補償事由発生日の属する期間の区分の額を用いてください。\",IF($B$157=\"記入不要です。\",\"\",\"補償を支給すべき月の属する年度の４月１日現在の年齢で見る。遺族補償年金の場合には、被災職員が生存していると仮定した年齢。\"))","v":""}]
[]
[null,"最低保障額",null,null,"円","最高限度額",null,null,"円","最低限度額",null,null,"円"]
[]
[]
["６　入力完了したら、下記ボタンをクリックしてください。"]
[]
[]
[]
["７　印刷"]
[]
[]
[]
[]
[]
["８　その他"]
[null,"・添付書類一覧（チェックを入れてください）（下記書類のほか、別途書類の提出をお願いする場合がありますので、予めご了承願います。）"]
[]
[]
[]
[null,"・計算エラー等不具合が生じた場合、記入方法に疑義がある場合は、下記連絡先へお問い合わせ願います。"]
[null,"連絡先：地方公務員災害補償基金茨城県支部　TEL:029-301-2327"]

{"sheet":"勤務状況【要入力】","index":1,"n_rows":61,"n_cols":23,"rows_kept":61,"cut":false,"hidden":false,"merged":[[85,1,85,2],[85,3,85,4],[85,5,85,18],[85,19,85,22],[86,1,86,2],[86,3,86,4],[86,5,86,18],[86,19,86,22],[72,1,72,2],[72,3,72,4],[72,5,72,18],[72,19,72,22],[73,1,73,2],[73,3,73,4],[73,5,73,18],[73,19,73,22],[84,1,84,2],[84,3,84,4],[84,5,84,18],[84,19,84,22],[76,1,76,2],[76,3,76,4],[76,5,76,18],[76,19,76,22],[69,3,69,4],[69,5,69,18],[69,19,69,22],[70,1,70,2],[70,3,70,4],[70,5,70,18],[70,19,70,22],[71,1,71,2],[71,3,71,4],[71,5,71,18],[71,19,71,22],[65,1,65,2],[65,3,65,4],[65,5,65,18],[65,19,65,22],[60,19,60,22],[59,5,59,18],[59,19,59,22],[51,1,51,5],[51,6,51,7],[59,1,59,2],[60,1,60,2],[59,3,59,4],[60,3,60,4],[60,5,60,18],[63,1,63,2],[63,3,63,4],[63,5,63,18],[63,19,63,22],[64,1,64,2],[61,1,61,2],[61,3,61,4],[61,5,61,18],[61,19,61,22],[62,1,62,2],[62,3,62,4],[62,5,62,18],[62,19,62,22],[2,1,2,2],[2,3,2,4],[47,18,48,18],[16,22,17,22],[26,22,27,22],[36,22,37,22],[47,22,48,22],[47,20,48,20],[16,20,17,20],[26,20,27,20],[36,20,37,20],[16,18,17,18],[26,18,27,18],[36,18,37,18],[40,1,40,5],[40,6,40,7],[20,1,20,5],[20,6,20,7],[30,1,30,5],[30,6,30,7],[74,1,74,2],[74,3,74,4],[74,5,74,18],[74,19,74,22],[75,1,75,2],[75,3,75,4],[75,5,75,18],[75,19,75,22],[64,3,64,4],[64,5,64,18],[64,19,64,22],[66,1,66,2],[66,3,66,4],[66,5,66,18],[66,19,66,22],[67,1,67,2],[67,3,67,4],[67,5,67,18],[67,19,67,22],[68,1,68,2],[68,3,68,4],[68,5,68,18],[68,19,68,22],[69,1,69,2],[78,1,78,2],[78,3,78,4],[78,5,78,18],[78,19,78,22],[79,1,79,2],[79,3,79,4],[79,5,79,18],[79,19,79,22],[77,1,77,2],[77,3,77,4],[77,5,77,18],[77,19,77,22],[82,1,82,2],[82,3,82,4],[82,5,82,18],[82,19,82,22],[83,1,83,2],[83,3,83,4],[83,5,83,18],[83,19,83,22],[80,1,80,2],[80,3,80,4],[80,5,80,18],[80,19,80,22],[81,1,81,2],[81,3,81,4],[81,5,81,18],[81,19,81,22],[89,1,89,2],[89,3,89,4],[89,5,89,18],[89,19,89,22],[87,1,87,2],[87,3,87,4],[87,5,87,18],[87,19,87,22],[88,1,88,2],[88,3,88,4],[88,5,88,18],[88,19,88,22]]}
[]
["１．用語の解説・注意点"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["２．下記カレンダーに被災職員の勤務状況を入力（プルダウン選択）してください。"]
[]
[null,{"$f":"IF(COUNTIF(給与等【要入力】!O34,\"*\"&\"原則計算\"&\"*\")>0,給与等【要入力】!F40,\"\")","v":""},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=B14+1,B14+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=C14+1,C14+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=D14+1,D14+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=E14+1,E14+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=F14+1,F14+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=G14+1,G14+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=H14+1,H14+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=I14+1,I14+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=J14+1,J14+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=K14+1,K14+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=L14+1,L14+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=M14+1,M14+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=N14+1,N14+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=O14+1,O14+1,\"-\"),\"-\")","v":"-"}]
[null,{"$f":"TEXT(B14,\"aaa\")","v":""},{"$f":"TEXT(C14,\"aaa\")","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=P14+1,P14+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=B17+1,B17+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=C17+1,C17+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=D17+1,D17+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=E17+1,E17+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=F17+1,F17+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=G17+1,G17+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=H17+1,H17+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=I17+1,I17+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=J17+1,J17+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=K17+1,K17+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=L17+1,L17+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=M17+1,M17+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=N17+1,N17+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=O17+1,O17+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$41>=P17+1,P17+1,\"-\"),\"-\")","v":"-"},null,"勤務した日数",null,"控除日数",null,"控除に該当するが勤務を要しない日"]
[null,{"$f":"TEXT(B17,\"aaa\")","v":"-"},{"$f":"TEXT(C17,\"aaa\")","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,{"$f":"COUNTIF(B16:P16,\"勤務\")+COUNTIF(B16:P16,\"祝日\")+COUNTIF(B16:P16,\"有給休暇\")+COUNTIF(B16:P16,\"職専免\")+COUNTIF(B16:P16,\"代休\")+COUNTIF(B19:Q19,\"勤務\")+COUNTIF(B19:Q19,\"祝日\")+COUNTIF(B19:Q19,\"有給休暇\")+COUNTIF(B19:Q19,\"職専免\")+COUNTIF(B19:Q19,\"代休\")+COUNTIF(B16:P16,\"*\"&\"控除日\"&\"*\")+COUNTIF(B19:Q19,\"*\"&\"控除日\"&\"*\")","v":0},null,{"$f":"COUNTIF(B16:P16,\"*\"&\"控除\"&\"*\")+COUNTIF(B19:Q19,\"*\"&\"控除\"&\"*\")","v":0},null,{"$f":"COUNTIF(B16:P16,\"控除に該当するが勤務を要しない日\")+COUNTIF(B19:Q19,\"控除に該当するが勤務を要しない日\")","v":0}]
[]
[null,"控除日の勤務に対して支払われた時間外勤務手当等",null,null,null,null,0,null,"円","例）午前中：療養休暇、午後：出勤して時間外勤務まで行った場合の時間外勤務手当"]
[]
[]
[null,{"$f":"IF(COUNTIF(給与等【要入力】!O34,\"*\"&\"原則計算\"&\"*\")>0,給与等【要入力】!H40,\"\")","v":""},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=B24+1,B24+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=C24+1,C24+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=D24+1,D24+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=E24+1,E24+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=F24+1,F24+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=G24+1,G24+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=H24+1,H24+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=I24+1,I24+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=J24+1,J24+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=K24+1,K24+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=L24+1,L24+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=M24+1,M24+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=N24+1,N24+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=O24+1,O24+1,\"-\"),\"-\")","v":"-"}]
[null,{"$f":"TEXT(B24,\"aaa\")","v":""},{"$f":"TEXT(C24,\"aaa\")","v":"-"},{"$f":"TEXT(D24,\"aaa\")","v":"-"},{"$f":"TEXT(E24,\"aaa\")","v":"-"},{"$f":"TEXT(F24,\"aaa\")","v":"-"},{"$f":"TEXT(G24,\"aaa\")","v":"-"},{"$f":"TEXT(H24,\"aaa\")","v":"-"},{"$f":"TEXT(I24,\"aaa\")","v":"-"},{"$f":"TEXT(J24,\"aaa\")","v":"-"},{"$f":"TEXT(K24,\"aaa\")","v":"-"},{"$f":"TEXT(L24,\"aaa\")","v":"-"},{"$f":"TEXT(M24,\"aaa\")","v":"-"},{"$f":"TEXT(N24,\"aaa\")","v":"-"},{"$f":"TEXT(O24,\"aaa\")","v":"-"},{"$f":"TEXT(P24,\"aaa\")","v":"-"}]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=P24+1,P24+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=B27+1,B27+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=C27+1,C27+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=D27+1,D27+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=E27+1,E27+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=F27+1,F27+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=G27+1,G27+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=H27+1,H27+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=I27+1,I27+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=J27+1,J27+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=K27+1,K27+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=L27+1,L27+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=M27+1,M27+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=N27+1,N27+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=O27+1,O27+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$H$41>=P27+1,P27+1,\"-\"),\"-\")","v":"-"},null,"勤務した日数",null,"控除日数",null,"控除に該当するが勤務を要しない日"]
[null,{"$f":"TEXT(B27,\"aaa\")","v":"-"},{"$f":"TEXT(C27,\"aaa\")","v":"-"},{"$f":"TEXT(D27,\"aaa\")","v":"-"},{"$f":"TEXT(E27,\"aaa\")","v":"-"},{"$f":"TEXT(F27,\"aaa\")","v":"-"},{"$f":"TEXT(G27,\"aaa\")","v":"-"},{"$f":"TEXT(H27,\"aaa\")","v":"-"},{"$f":"TEXT(I27,\"aaa\")","v":"-"},{"$f":"TEXT(J27,\"aaa\")","v":"-"},{"$f":"TEXT(K27,\"aaa\")","v":"-"},{"$f":"TEXT(L27,\"aaa\")","v":"-"},{"$f":"TEXT(M27,\"aaa\")","v":"-"},{"$f":"TEXT(N27,\"aaa\")","v":"-"},{"$f":"TEXT(O27,\"aaa\")","v":"-"},{"$f":"TEXT(P27,\"aaa\")","v":"-"},{"$f":"TEXT(Q27,\"aaa\")","v":"-"}]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,{"$f":"COUNTIF(B26:P26,\"勤務\")+COUNTIF(B26:P26,\"祝日\")+COUNTIF(B26:P26,\"有給休暇\")+COUNTIF(B26:P26,\"職専免\")+COUNTIF(B26:P26,\"代休\")+COUNTIF(B29:Q29,\"勤務\")+COUNTIF(B29:Q29,\"祝日\")+COUNTIF(B29:Q29,\"有給休暇\")+COUNTIF(B29:Q29,\"職専免\")+COUNTIF(B29:Q29,\"代休\")+COUNTIF(B26:P26,\"*\"&\"控除日\"&\"*\")+COUNTIF(B29:Q29,\"*\"&\"控除日\"&\"*\")","v":0},null,{"$f":"COUNTIF(B26:P26,\"*\"&\"控除\"&\"*\")+COUNTIF(B29:Q29,\"*\"&\"控除\"&\"*\")","v":0},null,{"$f":"COUNTIF(B26:P26,\"控除に該当するが勤務を要しない日\")+COUNTIF(B29:Q29,\"控除に該当するが勤務を要しない日\")","v":0}]
[]
[null,"控除日の勤務に対して支払われた時間外勤務手当等",null,null,null,null,0,null,"円"]
[]
[]
[null,{"$f":"IF(COUNTIF(給与等【要入力】!O34,\"*\"&\"原則計算\"&\"*\")>0,給与等【要入力】!J40,\"\")","v":""},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=B34+1,B34+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=C34+1,C34+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=D34+1,D34+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=E34+1,E34+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=F34+1,F34+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=G34+1,G34+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=H34+1,H34+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=I34+1,I34+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=J34+1,J34+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=K34+1,K34+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=L34+1,L34+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=M34+1,M34+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=N34+1,N34+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=O34+1,O34+1,\"-\"),\"-\")","v":"-"}]
[null,{"$f":"TEXT(B34,\"aaa\")","v":""},{"$f":"TEXT(C34,\"aaa\")","v":"-"},{"$f":"TEXT(D34,\"aaa\")","v":"-"},{"$f":"TEXT(E34,\"aaa\")","v":"-"},{"$f":"TEXT(F34,\"aaa\")","v":"-"},{"$f":"TEXT(G34,\"aaa\")","v":"-"},{"$f":"TEXT(H34,\"aaa\")","v":"-"},{"$f":"TEXT(I34,\"aaa\")","v":"-"},{"$f":"TEXT(J34,\"aaa\")","v":"-"},{"$f":"TEXT(K34,\"aaa\")","v":"-"},{"$f":"TEXT(L34,\"aaa\")","v":"-"},{"$f":"TEXT(M34,\"aaa\")","v":"-"},{"$f":"TEXT(N34,\"aaa\")","v":"-"},{"$f":"TEXT(O34,\"aaa\")","v":"-"},{"$f":"TEXT(P34,\"aaa\")","v":"-"}]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=P34+1,P34+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=B37+1,B37+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=C37+1,C37+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=D37+1,D37+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=E37+1,E37+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=F37+1,F37+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=G37+1,G37+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=H37+1,H37+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=I37+1,I37+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=J37+1,J37+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=K37+1,K37+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=L37+1,L37+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=M37+1,M37+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=N37+1,N37+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=O37+1,O37+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$J$41>=P37+1,P37+1,\"-\"),\"-\")","v":"-"},null,"勤務した日数",null,"控除日数",null,"控除に該当するが勤務を要しない日"]
[null,{"$f":"TEXT(B37,\"aaa\")","v":"-"},{"$f":"TEXT(C37,\"aaa\")","v":"-"},{"$f":"TEXT(D37,\"aaa\")","v":"-"},{"$f":"TEXT(E37,\"aaa\")","v":"-"},{"$f":"TEXT(F37,\"aaa\")","v":"-"},{"$f":"TEXT(G37,\"aaa\")","v":"-"},{"$f":"TEXT(H37,\"aaa\")","v":"-"},{"$f":"TEXT(I37,\"aaa\")","v":"-"},{"$f":"TEXT(J37,\"aaa\")","v":"-"},{"$f":"TEXT(K37,\"aaa\")","v":"-"},{"$f":"TEXT(L37,\"aaa\")","v":"-"},{"$f":"TEXT(M37,\"aaa\")","v":"-"},{"$f":"TEXT(N37,\"aaa\")","v":"-"},{"$f":"TEXT(O37,\"aaa\")","v":"-"},{"$f":"TEXT(P37,\"aaa\")","v":"-"},{"$f":"TEXT(Q37,\"aaa\")","v":"-"}]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,{"$f":"COUNTIF(B36:P36,\"勤務\")+COUNTIF(B36:P36,\"祝日\")+COUNTIF(B36:P36,\"有給休暇\")+COUNTIF(B36:P36,\"職専免\")+COUNTIF(B36:P36,\"代休\")+COUNTIF(B39:Q39,\"勤務\")+COUNTIF(B39:Q39,\"祝日\")+COUNTIF(B39:Q39,\"有給休暇\")+COUNTIF(B39:Q39,\"職専免\")+COUNTIF(B39:Q39,\"代休\")+COUNTIF(B36:P36,\"*\"&\"控除日\"&\"*\")+COUNTIF(B39:Q39,\"*\"&\"控除日\"&\"*\")","v":0},null,{"$f":"COUNTIF(B36:P36,\"*\"&\"控除\"&\"*\")+COUNTIF(B39:Q39,\"*\"&\"控除\"&\"*\")","v":0},null,{"$f":"COUNTIF(B36:P36,\"控除に該当するが勤務を要しない日\")+COUNTIF(B39:Q39,\"控除に該当するが勤務を要しない日\")","v":0}]
[]
[null,"控除日の勤務に対して支払われた時間外勤務手当等",null,null,null,null,0,null,"円"]
[]
[]
[]
[null,{"$f":"給与等【要入力】!F97","v":"00:00:00"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=B45+1,B45+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=C45+1,C45+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=D45+1,D45+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=E45+1,E45+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=F45+1,F45+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=G45+1,G45+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=H45+1,H45+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=I45+1,I45+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=J45+1,J45+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=K45+1,K45+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=L45+1,L45+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=M45+1,M45+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=N45+1,N45+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=O45+1,O45+1,\"-\"),\"-\")","v":"-"}]
[null,{"$f":"TEXT(B45,\"aaa\")","v":"土"},{"$f":"TEXT(C45,\"aaa\")","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=P45+1,P45+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=B48+1,B48+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=C48+1,C48+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=D48+1,D48+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=E48+1,E48+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=F48+1,F48+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=G48+1,G48+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=H48+1,H48+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=I48+1,I48+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=J48+1,J48+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=K48+1,K48+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=L48+1,L48+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=M48+1,M48+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=N48+1,N48+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=O48+1,O48+1,\"-\"),\"-\")","v":"-"},{"$f":"IFERROR(IF(給与等【要入力】!$F$98>=P48+1,P48+1,\"-\"),\"-\")","v":"-"},null,"勤務した日数",null,"控除日数",null,"控除に該当するが勤務を要しない日"]
[null,{"$f":"TEXT(B48,\"aaa\")","v":"-"},{"$f":"TEXT(C48,\"aaa\")","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,{"$f":"COUNTIF(B47:P47,\"勤務\")+COUNTIF(B47:P47,\"祝日\")+COUNTIF(B47:P47,\"有給休暇\")+COUNTIF(B47:P47,\"職専免\")+COUNTIF(B47:P47,\"代休\")+COUNTIF(B50:Q50,\"勤務\")+COUNTIF(B50:Q50,\"祝日\")+COUNTIF(B50:Q50,\"有給休暇\")+COUNTIF(B50:Q50,\"職専免\")+COUNTIF(B50:Q50,\"代休\")+COUNTIF(B47:P47,\"*\"&\"控除日\"&\"*\")+COUNTIF(B50:Q50,\"*\"&\"控除日\"&\"*\")","v":0},null,{"$f":"COUNTIF(B47:P47,\"*\"&\"控除\"&\"*\")+COUNTIF(B50:Q50,\"*\"&\"控除\"&\"*\")","v":0},null,{"$f":"COUNTIF(B47:P47,\"控除に該当するが勤務を要しない日\")+COUNTIF(B50:Q50,\"控除に該当するが勤務を要しない日\")","v":0}]
[]
[null,"当該月のうち勤務を要しない日数",null,null,null,null,0,null,"日",{"$f":"IF(給与等【要入力】!B94=\"下記表は記入不要です。\",\"\",\"←\"&MONTH(B45)&\"月における勤務を要しない日を記入（週休日やその振替日、欠勤日）\")","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,"マラソン業務手伝いについて、所属の命令は出ている。"]

{"sheet":"様式","index":2,"n_rows":128,"n_cols":26,"rows_kept":128,"cut":false,"hidden":false,"merged":[[75,17,75,20],[24,4,24,7],[24,8,24,10],[24,11,24,13],[24,14,24,17],[44,16,45,18],[44,19,45,19],[44,20,45,20],[44,21,45,21],[46,4,47,4],[46,5,47,7],[46,8,47,8],[46,9,47,9],[46,10,47,10],[46,11,47,11],[46,12,47,12],[46,13,47,14],[46,15,47,15],[46,16,47,18],[46,19,47,19],[46,20,47,20],[46,21,47,21],[44,4,45,4],[44,5,45,7],[44,8,45,8],[44,9,45,9],[44,10,45,10],[44,11,45,11],[44,12,45,12],[44,13,45,14],[44,15,45,15],[116,4,116,6],[116,10,116,15],[118,10,118,15],[91,14,91,16],[93,5,93,6],[93,10,93,13],[93,15,93,16],[70,7,70,8],[70,10,70,14],[71,6,71,10],[69,3,69,5],[70,3,70,5],[69,7,69,8],[64,4,64,6],[64,7,64,8],[65,10,65,11],[75,6,75,9],[105,1,105,2],[106,5,106,6],[106,10,106,13],[106,15,106,16],[107,1,107,2],[108,1,108,2],[108,15,108,16],[110,15,110,16],[114,1,115,7],[114,8,115,16],[98,1,98,2],[99,1,99,2],[100,1,100,2],[101,1,101,2],[102,1,102,2],[102,6,102,9],[102,14,102,16],[103,1,103,2],[104,1,104,2],[104,14,104,16],[94,1,94,2],[95,1,95,2],[96,1,96,2],[97,1,97,2],[97,6,97,9],[97,14,97,16],[79,2,79,5],[79,6,79,9],[79,13,79,16],[79,17,79,20],[82,6,82,9],[82,14,82,16],[85,6,85,9],[85,14,85,16],[89,6,89,9],[89,14,89,16],[76,2,76,5],[76,6,76,9],[76,13,76,16],[76,17,76,20],[77,6,77,9],[77,17,77,20],[78,2,78,5],[78,6,78,9],[78,13,78,16],[78,17,78,20],[71,17,71,21],[73,2,73,5],[73,13,73,16],[74,2,74,5],[74,6,74,9],[74,13,74,16],[74,17,74,20],[1,1,1,21],[3,4,3,10],[3,11,4,12],[3,13,4,21],[4,4,4,10],[9,1,10,3],[9,4,9,7],[9,8,9,10],[9,11,9,13],[9,14,10,17],[9,18,10,21],[10,4,10,7],[10,8,10,10],[10,11,10,13],[11,1,11,3],[11,4,11,7],[11,8,11,10],[11,11,11,13],[11,14,11,17],[14,4,14,7],[14,8,14,10],[14,11,14,13],[14,14,14,17],[15,11,15,13],[15,14,15,17],[12,1,12,3],[12,4,12,7],[12,8,12,10],[12,11,12,13],[12,14,12,17],[13,1,13,3],[13,4,13,7],[13,8,13,10],[13,11,13,13],[13,14,13,17],[20,18,20,20],[21,4,21,7],[21,8,21,10],[21,11,21,13],[21,14,21,17],[18,8,18,10],[18,11,18,13],[18,14,18,17],[19,4,19,7],[19,8,19,10],[19,11,19,13],[19,14,19,17],[15,18,18,21],[16,4,16,7],[16,8,16,10],[16,11,16,13],[16,14,16,17],[17,4,17,7],[17,8,17,10],[17,11,17,13],[17,14,17,17],[18,4,18,7],[15,4,15,7],[15,8,15,10],[22,4,22,7],[22,8,22,10],[22,11,22,13],[22,14,22,17],[23,4,23,7],[23,8,23,10],[23,14,23,17],[20,4,20,7],[20,8,20,10],[20,11,20,13],[20,14,20,17],[23,11,23,13],[42,21,43,21],[38,3,38,4],[38,7,38,9],[39,11,39,12],[42,4,43,4],[42,5,43,7],[42,8,43,8],[42,9,43,9],[42,10,43,10],[42,11,43,11],[42,12,43,12],[42,13,43,14],[42,15,43,15],[42,16,43,18],[42,19,43,19],[42,20,43,20],[51,21,54,21],[54,4,54,6],[54,7,54,8],[48,16,48,18],[51,4,52,4],[51,5,52,6],[51,7,52,7],[51,8,52,9],[51,10,52,10],[51,11,52,11],[51,12,52,12],[51,13,52,13],[51,14,52,14],[51,15,54,15],[51,16,54,18],[51,19,54,19],[51,20,54,20],[62,21,63,21],[58,13,59,13],[58,14,59,15],[61,4,62,4],[61,5,62,6],[61,7,62,7],[61,8,62,9],[61,10,62,10],[61,11,62,11],[61,12,62,12],[61,13,62,13],[58,3,59,4],[58,5,59,6],[58,7,59,8],[58,9,59,9],[58,10,59,11],[58,12,59,12],[62,16,63,18],[62,19,63,19],[62,20,63,20],[61,14,62,14],[62,15,63,15],[31,11,31,12],[31,15,31,16],[34,6,35,9],[36,3,36,4],[36,7,36,8],[37,7,37,9],[25,4,25,7],[25,8,25,10],[25,11,25,13],[25,14,25,17],[26,2,26,3],[26,4,26,7],[26,8,26,10],[26,11,26,13],[26,14,26,17]]}
[]
[null,"平　均　給　与　額　算　定　書"]
[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":"給与等【要入力】!D8","v":0},null,null,null,null,null,null,"補 償 の 種 類",null,{"$f":"給与等【要入力】!I10","v":0}]
[null," 及び生年月日",null,null,{"$f":"給与等【要入力】!I8","v":"00:00:00"}]
[]
[null,"　１　平均給与額算定内訳",null,null,null,null,null,{"$f":"IF(E14>0,+E12,0)","v":0},null,null,{"$f":"IF(I14>0,+I12,)","v":0},null,null,{"$f":"IF(L14>0,+L12,0)","v":0},null,null,null,{"$f":"+H7+K7+N7","v":0}]
[null,"　　災害発生の日の属する月の前月の末日から起算して過去３月間の給与"]
[null,"　 （通勤手当については、地方公務員災害補償法施行規則第３条第５項に規定する各月ごとの合計額）"]
[null,"給与期間",null,null,{"$f":"給与等【要入力】!$F$40","v":""},null,null,null,{"$f":"給与等【要入力】!$H$40","v":""},null,null,{"$f":"給与等【要入力】!$J$40","v":""},null,null,"計",null,null,null,"備　　　考"]
[null,null,null,null,{"$f":"給与等【要入力】!$F$40","v":""},null,null,null,{"$f":"給与等【要入力】!$H$41","v":""},null,null,{"$f":"給与等【要入力】!$J$41","v":"00:00:00"}]
[null,"総　　日　　数",null,null,{"$f":"給与等【要入力】!$F$42","v":0},null,null,null,{"$f":"給与等【要入力】!$H$42","v":0},null,null,{"$f":"給与等【要入力】!$J$42","v":0},null,null,{"$f":"SUM(E12:N12)","v":0}]
[null,"勤務した日数",null,null,{"$f":"給与等【要入力】!$F$43","v":0},null,null,null,{"$f":"給与等【要入力】!$H$43","v":0},null,null,{"$f":"給与等【要入力】!$J$43","v":0},null,null,0]
[null,"控  除  日  数",null,null,{"$f":"給与等【要入力】!$F$44","v":0},null,null,null,{"$f":"給与等【要入力】!$H$44","v":0},null,null,{"$f":"給与等【要入力】!$J$44","v":0},null,null,{"$f":"SUM(E14:N14)","v":0}]
[null,null,null,{"$f":"給与等【要入力】!C48","v":"給料"},{"$f":"給与等【要入力】!F48","v":0},null,null,null,{"$f":"給与等【要入力】!H48","v":0},null,null,{"$f":"給与等【要入力】!J48","v":0},null,null,{"$f":"SUM(E15:N15)","v":0},null,null,null,null,null,null,null,null,{"$f":"給与等【要入力】!E48","v":"固定給"}]
[null,null,null,{"$f":"給与等【要入力】!C49","v":"扶養手当"},{"$f":"給与等【要入力】!F49","v":0},null,null,null,{"$f":"給与等【要入力】!H49","v":0},null,null,{"$f":"給与等【要入力】!J49","v":0},null,null,{"$f":"SUM(E16:N16)","v":0},null,null,null,{"$f":"IF(給与等【要入力】!$E$70=0,\"控除日に時間外勤務手当は支払われていない。\",\"控除日に時間外勤務手当\"&FIXED(給与等【要入力】!$E$70,0)&\"円支払われた。\")","v":"控除日に時間外勤務手当は支払われていない。"},null,null,null,null,{"$f":"給与等【要入力】!E49","v":"固定給"}]
[null,null,null,{"$f":"給与等【要入力】!C50","v":"地域手当"},{"$f":"給与等【要入力】!F50","v":0},null,null,null,{"$f":"給与等【要入力】!H50","v":0},null,null,{"$f":"給与等【要入力】!J50","v":0},null,null,0,null,null,null,null,null,null,null,null,{"$f":"給与等【要入力】!E50","v":"固定給"}]
[null,"給",null,{"$f":"給与等【要入力】!C51","v":"住居手当"},{"$f":"給与等【要入力】!F51","v":0},null,null,null,{"$f":"給与等【要入力】!H51","v":0},null,null,{"$f":"給与等【要入力】!J51","v":0},null,null,0,null,null,null,null,null,null,null,null,{"$f":"給与等【要入力】!E51","v":"固定給"}]
[null,null,null,{"$f":"給与等【要入力】!C52","v":"通勤手当"},{"$f":"給与等【要入力】!F52","v":0},null,null,null,{"$f":"給与等【要入力】!H52","v":0},null,null,{"$f":"給与等【要入力】!J52","v":0},null,null,0,null,null,null,null,null,null,null,null,{"$f":"給与等【要入力】!E52","v":"固定給"}]
[null,null,null,{"$f":"給与等【要入力】!C53","v":"時間外勤務手当"},{"$f":"給与等【要入力】!F53","v":0},null,null,null,{"$f":"給与等【要入力】!H53","v":0},null,null,{"$f":"給与等【要入力】!J53","v":0},null,null,0,null,null,null,{"$f":"IF(S21=0,\"寒冷地手当　無し\",\"寒冷地手当　有り\")","v":"寒冷地手当　無し"},null,null,null,null,{"$f":"給与等【要入力】!E53","v":"実績給"}]
[null,null,null,{"$f":"給与等【要入力】!C54","v":"宿日直手当"},{"$f":"給与等【要入力】!F54","v":0},null,null,null,{"$f":"給与等【要入力】!H54","v":0},null,null,{"$f":"給与等【要入力】!J54","v":0},null,null,0,null,null,null,{"$f":"IF(給与等【要入力】!F72=\"\",0,給与等【要入力】!F72)","v":0},null,null,null,null,{"$f":"給与等【要入力】!E54","v":"実績給"}]
[null,null,null,{"$f":"給与等【要入力】!C55","v":0},{"$f":"給与等【要入力】!F55","v":0},null,null,null,{"$f":"給与等【要入力】!H55","v":0},null,null,{"$f":"給与等【要入力】!J55","v":0},null,null,0,null,null,null,null,null,null,null,null,{"$f":"給与等【要入力】!E55","v":0}]
[null,"与",null,{"$f":"給与等【要入力】!C56","v":0},{"$f":"給与等【要入力】!F56","v":0},null,null,null,{"$f":"給与等【要入力】!H56","v":0},null,null,{"$f":"給与等【要入力】!J56","v":0},null,null,0,null,null,null,null,null,null,null,null,{"$f":"給与等【要入力】!E56","v":0}]
[null,null,null,{"$f":"給与等【要入力】!C57","v":0},{"$f":"給与等【要入力】!F57","v":0},null,null,null,{"$f":"給与等【要入力】!H57","v":0},null,null,{"$f":"給与等【要入力】!J57","v":0},null,null,0,null,null,null,null,null,null,null,null,{"$f":"給与等【要入力】!E57","v":0}]
[null,null,null,{"$f":"給与等【要入力】!C58","v":0},{"$f":"給与等【要入力】!F58","v":0},null,null,null,{"$f":"給与等【要入力】!H58","v":0},null,null,{"$f":"給与等【要入力】!J58","v":0},null,null,{"$f":"SUM(E25:N25)","v":0},null,null,null,null,null,null,null,null,{"$f":"給与等【要入力】!E58","v":0}]
[null,null,null,{"$f":"給与等【要入力】!C59","v":0},{"$f":"給与等【要入力】!F59","v":0},null,null,null,{"$f":"給与等【要入力】!H59","v":0},null,null,{"$f":"給与等【要入力】!J59","v":0},null,null,{"$f":"SUM(E26:N26)","v":0},null,null,null,null,null,null,null,null,{"$f":"給与等【要入力】!E59","v":0}]
[null,null,"計",null,{"$f":"SUM(E15:H26)","v":0},null,null,null,{"$f":"SUM(I15:K26)","v":0},null,null,{"$f":"SUM(L15:N26)","v":0},null,null,{"$f":"SUM(O15:R26)","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,null,null,null,null,null,"　　前における直近の寒冷地手当の支給日に",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(D32/F32,0)","v":0}]
[null,null,null,"（給与総額）",null,"（総日数）",null,null,null,null,null,"　　支給された寒冷地手当の額",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L32*5/365","v":0}]
[null,null,null,{"$f":"O27","v":0},"円÷",{"$f":"+O12","v":0},"＝",{"$f":"IFERROR(ROUNDDOWN(D32/F32,0),0)","v":0},"円",{"$f":"IFERROR(ROUNDDOWN(((D32/F32)-H32)*100,0),0)","v":0},"銭　（イ）",{"$f":"S21","v":0},null,"円×５÷３６５＝",null,{"$f":"ROUNDDOWN(L32*5/365,0)","v":0},null,"円",{"$f":"ROUNDDOWN(((L32*5/365)-P32)*100,0)","v":0},"銭　（ロ）",null,null,null,{"$f":"IFERROR(D32/F32+L32*5/365,0)","v":0},"A"]
[null,null,null,null,null,null,null,null,"（イ）＋（ロ）＝",null,null,{"$f":"IFERROR(ROUNDDOWN(X32,0),0)","v":0},null,{"$f":"IFERROR(ROUNDDOWN((X32-L33)*100,0),0)","v":0},"銭"]
[null,"  (Ｂ)",null,"法第２条第４項ただし書きによる金額"]
[null,null,null,"日、時間又は出来高払制に",null,null,"　　　　　　（勤務した日数）"]
[null,null,null,"よって定められた給与の総額"]
[null,null,null,{"$f":"SUMIF($X$15:$X$26,\"実績給\",$O$15:$R$26)","v":0},null,"　円÷",null,{"$f":"IF(D37=0,\"\",+O13)","v":""},null,"　　×60/100＝",null,{"$f":"IF(D37=0,\"\",INT(D37/H37*60/100))","v":""},"円",{"$f":"IF(D37=0,\"\",INT(D37/H37*60)-L37*100)","v":""},"銭　（ハ）",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(D37/H37*0.6,0)","v":0}]
[null,null,null,"（その他の給与の総額）",null,null,null,"　　　　（総日数）"]
[null,null,null,{"$f":"O27-D37","v":0},null,"　円÷",null,{"$f":"IF(D37=0,\"\",+O12)","v":""},null,null," ＝",{"$f":"IFERROR(ROUNDDOWN(D39/H39,0),\"\")","v":""},"円",{"$f":"IFERROR(ROUNDDOWN(((D39/H39)-L39)*100,0),\"\")","v":""},"銭　（ニ）",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(D39/H39,0)","v":0}]
[null,null,null,null,null,null,null,"　　　（ロ）＋（ハ）＋（ニ）　＝",null,null,null,{"$f":"IFERROR(ROUNDDOWN(X40,0),\"\")","v":0},{"$f":"ROUNDDOWN(Y39,0)","v":0},"円",{"$f":"IFERROR(ROUNDDOWN((X40-L40)*100,0),\"\")","v":0},"銭",null,null,null,null,null,null,null,{"$f":"IFERROR(L32*5/365+D37/H37*0.6+D39/H39,0)","v":0},"B"]
[null,"  (Ｃ)",null,"法第２条第６項による金額（同条第４項本文計算）"]
[null,null,"（寒冷地手当の額）（控除日の属する月の給与の月額）（その月の総日数）",null,null,null,null,null,null,null,null,"　（控除日数）",null,"（減額された給与の額）"]
[null,null,null,{"$f":"$S$21&\"×５\"","v":"0×５"},"＋",{"$f":"IF(COUNTIF($E$14:$N$14,0)>=2,IF($E$14>=1,SUMIF($X$15:$X$26,\"固定給\",$E$15:$H$26),0)+IF($I$14>=1,SUMIF($X$15:$X$26,\"固定給\",$I$15:$K$26),0)+IF($L$14>=1,SUMIF($X$15:$X$26,\"固定給\",$L$15:$N$26),0),IF($E$14>=1,SUMIF($X$15:$X$26,\"固定給\",$E$15:$H$26),0))","v":0},null,null,"÷",{"$f":"IF(COUNTIF($E$14:$N$14,0)>=2,IF($E$14>=1,$E$12,0)+IF($I$14>=1,$I$12,0)+IF($L$14>=1,$L$12,0),IF($E$14>=1,$E$12,0))","v":0},"　×",{"$f":"IF(COUNTIF($E$14:$N$14,0)>=2,IF($E$14>=1,$E$14,0)+IF($I$14>=1,$I$14,0)+IF($L$14>=1,$L$14,0),IF($E$14>=1,$E$14,0))","v":0},"－",{"$f":"IF(COUNTIF($E$14:$N$14,0)>=2,給与等【要入力】!$L$62,給与等【要入力】!$F$62)","v":0},null,"＝",{"$f":"IFERROR(ROUNDDOWN(((L32*5/365)+F43/J43)*L43-N43,0),0)","v":0},null,null,"円",{"$f":"IFERROR(ROUNDDOWN(((((L32*5/365)+F43/J43)*L43-N43)-Q43)*100,0),0)","v":0},"銭（ホ）",null,null,{"$f":"IFERROR((S21*5/365+F43/J43)*L43-N43,0)","v":0}]
[null,null,null,365]
[null,null,null,{"$f":"$S$21&\"×５\"","v":"0×５"},"＋",{"$f":"IF(COUNTIF($E$14:$N$14,0)>=2,0,IF($I$14>=1,SUMIF($X$15:$X$26,\"固定給\",$I$15:$K$26),0))","v":0},null,null,"÷",{"$f":"IF(COUNTIF($E$14:$N$14,0)>=2,0,IF($I$14>=1,$I$12,0))","v":0},"　×",{"$f":"IF(COUNTIF($E$14:$N$14,0)>=2,0,IF($I$14>=1,$I$14,0))","v":0},"－",{"$f":"給与等【要入力】!H62","v":0},null,"＝",{"$f":"IFERROR(ROUNDDOWN(((L34*5/365)+F45/J45)*L45-N45,0),0)","v":0},null,null,"円",{"$f":"IFERROR(ROUNDDOWN(((((L34*5/365)+F45/J45)*L45-N45)-Q45)*100,0),0)","v":0},"銭（ホ）'",null,null,{"$f":"IFERROR((S23*5/365+F45/J45)*L45-N45,0)","v":0}]
[null,null,null,365]
[null,null,null,{"$f":"$S$21&\"×５\"","v":"0×５"},"＋",{"$f":"IF(COUNTIF($E$14:$N$14,0)>=2,0,IF($L$14>=1,SUMIF($X$15:$X$26,\"固定給\",L15:N26),0))","v":0},null,null,"÷",{"$f":"IF(COUNTIF($E$14:$N$14,0)>=2,0,IF($L$14>=1,$L$12,0))","v":0},"　×",{"$f":"IF(COUNTIF($E$14:$N$14,0)>=2,0,IF($L$14>=1,$L$14,0))","v":0},"－",{"$f":"給与等【要入力】!J62","v":0},null,"＝",{"$f":"IFERROR(ROUNDDOWN(((L36*5/365)+F47/J47)*L47-N47,0),0)","v":0},null,null,"円",{"$f":"IFERROR(ROUNDDOWN(((((L36*5/365)+F47/J47)*L47-N47)-Q47)*100,0),0)","v":0},"銭（ホ）''",null,null,{"$f":"IFERROR((S26*5/365+F47/J47)*L47-N47,0)","v":0}]
[null,null,null,365]
[null,null,"（控除日の勤務に対して支払われた時間外勤務手当等の合計額）",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"給与等【要入力】!$E$70","v":0},null,null," 円",0,"銭（ヘ）",null,null,{"$f":"Q49","v":0}]
[null,null,null,null,null,null,null,"　　　　　（ホ）＋（ヘ）　＝",null,null,null,{"$f":"ROUNDDOWN(Y50,0)","v":0},"円",{"$f":"ROUNDDOWN((Y50-L50)*100,0)","v":0},"　銭（ト）",null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y43:Y49)","v":0}]
[null,null,"（寒冷地手当の額）",null,null,"（総日数）",null,null,"　（給与総額）",null,null,"　　　　（ト）"]
[null,null,null,{"$f":"$S$21&\"×５\"","v":"0×５"},"×",{"$f":"IF(COUNTIF($L$43:$L$48,0)=3,0,O12)","v":0},null,"　　＋",{"$f":"IF(COUNTIF($L$43:$L$48,0)=3,0,O27)","v":0},null,"－",{"$f":"L50","v":0},"円",{"$f":"N50","v":0},"銭","＝",{"$f":"ROUNDDOWN(X52,0)","v":0},null,null,"円",{"$f":"ROUNDDOWN((X52-Q52)*100,0)","v":0},"銭",null,{"$f":"IFERROR((S21*5/365*F52+I52-Y50)/(E55-J55),0)","v":0},"C"]
[null,null,null,365]
[null,null,null,null,"　（総日数）",null,null,null,"　（控除日数）"]
[null,null,null,null,{"$f":"IF(COUNTIF($L$43:$L$48,0)=3,0,O12)","v":0},null,null,"　      －",null,{"$f":"O14","v":0}]
[null,"  (Ｃ’)",null,"法第２条第６項による金額（同条第４項ただし書き計算）"]
[null,null,"  日、時間又は出来高払制によって定められた",null,null,null,null,"　　 　勤務した日数"]
[null,null,"  給与の総額（控除日に支払われたものを除く）",null,null,null,null,"       (控除日を除く)"]
[null,null,null,{"$f":"IF(COUNTIF($L$43:$L$48,0)=3,0,SUMIF($X$15:$X$26,\"実績給\",$O$15:$R$26)-$Q$49)","v":0},null,"円÷",null,{"$f":"IF(COUNTIF($L$43:$L$48,0)=3,0,O13-O14+給与等【要入力】!L45)","v":0},null,"×60/100＝",{"$f":"IFERROR(ROUNDDOWN(D59/H59*60/100,0),0)","v":0},null,"円",{"$f":"IFERROR(ROUNDDOWN(((D59/H59*60/100)-K59)*100,0),0)","v":0},"銭（チ）",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(D59/H59*0.6,0)","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,{"$f":"IFERROR((S21*5/365*F62+I62-Y43-Y45-Y47)/(E65-J65),0)","v":0}]
[null,null,null,{"$f":"$S$21&\"×５\"","v":"0×５"},"×",{"$f":"IF(D59=0,\"\",+O12)","v":""},null,"     ＋",{"$f":"IF(COUNTIF($L$43:$L$48,0)=3,0,D39)","v":0},null,"－",{"$f":"IF(COUNTIF($E$14:$N$14,0)>=2,ROUNDDOWN(Q43+U43/100+Q45+U45/100+Q47+U47/100,0),Q43)","v":0},"円",{"$f":"IF(COUNTIF($E$14:$N$14,0)>=2,(Q43*100+U43+Q45*100+U45+Q47*100+U47)-L62*100,U43)","v":0},"銭"]
[null,null,null,365,null,null,null,null,null,null,null,null,null,null,null,"＝",{"$f":"IFERROR(ROUNDDOWN(((S21*5/365*F62)+I62-(L62+N62/100))/(E65-J65),0),0)","v":0},null,null,"円",{"$f":"IFERROR(ROUNDDOWN((((S21*5/365*F62)+I62-(L62+N62/100))/(E65-J65)-Q63)*100,0),0)","v":0},"銭（リ）"]
[null,null,null,null,"　（総日数）",null,null,null,"　（控除日数）"]
[null,null,null,null,{"$f":"IF(COUNTIF($L$43:$L$48,0)=3,0,O12)","v":0},null,null,"　     －",null,{"$f":"+J55","v":0}]
[null,null,null,null,null,null,null,"　　　　　（チ）＋（リ）＝",null,null,{"$f":"ROUNDDOWN(X66,0)","v":0},null,"円",{"$f":"ROUNDDOWN((X66-K66)*100,0)","v":0},"銭",null,null,null,null,null,null,null,null,{"$f":"Y59+Y61","v":0},"C'"]
[]
[]
[null," (Ｄ)",null,null,"規則第３条第１項による金額",null,null,null,null,null,{"$f":"IF(給与等【要入力】!F118=0,\"\",\"※最低保障計算・控除計算の結果、\"&給与等【要入力】!I127&\"を採用\")","v":""}]
[null,null,null,"（給与総額）",null,null,null,"（総日数）"]
[null,null,null,{"$f":"IF(給与等【要入力】!I127=\"規則第３条第１項による金額\",給与等【要入力】!J118,\"-\")","v":0},null,null,"円÷",{"$f":"IF(AND(給与等【要入力】!I127=\"規則第３条第１項による金額\",給与等【要入力】!F99>1),給与等【要入力】!F99,IF(給与等【要入力】!F99=1,0,\"-\"))","v":0},null,"　＝",{"$f":"IF(D71=0,\"\",INT(X71))","v":""},null,null,null,null,"円",{"$f":"IF(D71=0,\"\",INT(X71*100)-K71*100)","v":""},"　銭",null,null,null,null,null,{"$f":"IFERROR(給与等【要入力】!$I$128,0)","v":0},"D"]
[null,null,"①災害発生の日",null,null,null,{"$f":"給与等【要入力】!$D$10","v":"00:00:00"},null,null,null,null,null,null,"②補償事由発生日",null,null,null,{"$f":"給与等【要入力】!$E$135","v":"00:00:00"}]
[null,null,null,"基本的給与の月額",null,null,null,null,null,null,null,null,null,null,"基本的給与の月額"]
[null,null,{"$f":"給与等【要入力】!$B$80","v":0},null,null,null,"職給料表",{"$f":"給与等【要入力】!$F$80","v":0},"級",{"$f":"給与等【要入力】!$H$80","v":0},"号級",null,null,{"$f":"給与等【要入力】!B137","v":0},null,null,null,"職給料表",{"$f":"給与等【要入力】!F137","v":0},"級",{"$f":"給与等【要入力】!$H$137","v":0},"号級"]
[null,null,"給　　　　　　　　　料",null,null,null,{"$f":"給与等【要入力】!D82","v":0},null,null,null,"   円",null,null,"給　　　　　　　　　料",null,null,null,{"$f":"給与等【要入力】!D139","v":0},null,null,null,"   円"]
[null,null,"第二種初任給調整手当",null,null,null,{"$f":"給与等【要入力】!D83","v":0},null,null,null,"   円",null,null,"第二種初任給調整手当",null,null,null,{"$f":"給与等【要入力】!D140","v":0},null,null,null,"   円"]
[null,null,"扶　　養　　手　　当",null,null,null,{"$f":"給与等【要入力】!D84","v":0},null,null,null,"   円",null,null,"扶　　養　　手　　当",null,null,null,{"$f":"給与等【要入力】!D141","v":0},null,null,null,"   円"]
[null,null,"地　　域　　手　　当",null,null,null,{"$f":"給与等【要入力】!D85","v":0},null,null,null,"   円",null,null,"地　　域　　手　　当",null,null,null,{"$f":"給与等【要入力】!D142","v":0},null,null,null,"   円"]
[null,null,"特地勤務手当又はへき地勤務手当",null,null,null,{"$f":"給与等【要入力】!D86+給与等【要入力】!D87","v":0},null,null,null,"   円",null,null,"特地勤務手当又はへき地勤務手当",null,null,null,{"$f":"給与等【要入力】!D143+給与等【要入力】!D144","v":0},null,null,null,"   円"]
[null,null,"計",null,null,null,{"$f":"SUM(G75:J79)","v":0},null,null,null,"   円",null,null,"計",null,null,null,{"$f":"SUM(R75:U79)","v":0},null,null,null,"   円"]
[null," (Ｅ)",null,null,"規則第３条第２項による金額"]
[null,null,null,null,null,null,"（基本的給与の月額①）"]
[null,null,null,null,null,null,{"$f":"IF(給与等【要入力】!$E$23=\"○\",給与等【要入力】!$G$87,0)","v":0},null,null,null,"円÷３０＝",null,null,null,{"$f":"INT(G83/30)","v":0},null,null,"円",{"$f":"INT(G83/30*100)-O83*100","v":0},"銭",null,null,null,{"$f":"G83/30","v":0},"E"]
[null," (Ｆ)",null,null,"規則第３条第３項による金額"]
[null,null,null,null,null,null,"（基本的給与の月額②）"]
[null,null,null,null,null,null,{"$f":"+R80","v":0},null,null,null,"円÷３０＝",null,null,null,{"$f":"ROUNDDOWN(G86/30,0)","v":0},null,null,"円",{"$f":"ROUNDDOWN(((G86/30)-O86)*100,0)","v":0},"銭",null,null,null,{"$f":"G86/30","v":0},"F"]
[null," (Ｇ)",null,null,"規則第３条第４項による金額"]
[null,null,null,"　災害発生の日を補償事由発生日とみなして(Ｆ)の例により計算した額"]
[null,null,null,null,null,null,"（基本的給与の月額①）"]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(給与等【要入力】!$P$155>=2,G80,0),0)","v":0},null,null,null,"円÷３０＝",null,null,null,{"$f":"ROUNDDOWN(G90/30,0)","v":0},null,null,"円",{"$f":"ROUNDDOWN(((G90/30)-O90)*100,0)","v":0},"銭","（ヌ）",null,null,null,{"$f":"G90/30","v":0}]
[null,null,null,"　（ヌ） 及び (Ａ) (Ｂ) (Ｃ) (Ｃ’) (Ｄ) (Ｅ)のうち最も高い金額"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O90=0,0,IF(給与等【要入力】!$P$155>=2,ROUNDDOWN(MAX($X$32,$X$40,$X$52,($Y$59+$Y$61),$X$71,$X$83,$Y$90),0),0))","v":0},null,null,"円",{"$f":"IFERROR(IF(給与等【要入力】!$P$155>=2,ROUNDDOWN(((Y92)-O92)*100,0),0),0)","v":0},"銭","（ル）",null,null,null,{"$f":"IF(O90=0,0,MAX($X$32,$X$40,$X$52,($Y$59+$Y$61),$X$71,$X$83,$Y$90))","v":0}]
[null,null,null,null,null,"　　　　（ル）",null,null,null,"　　　（総務大臣が定める率）"]
[null,null,null,null,null,{"$f":"O92","v":0},null,"　円",{"$f":"S92","v":0},"　銭×",{"$f":"給与等【要入力】!$K$151","v":0},null,null,null,"＝",{"$f":"ROUNDDOWN((F94+I94/100)*K94,0)","v":0},null,"円",{"$f":"ROUNDDOWN(((F94+I94/100)*K94-P94)*100,0)","v":0},"銭",null,null,null,{"$f":"Y92*K94","v":0},"G"]
[null,null,null," (Ｈ)","　離職後に補償を行なうべき事由が生じた場合の金額"]
[null,"規",null,null,"補償事由発生日を採用の日とみなして(Ｅ)の例により計算した額"]
[null,"則",null,null,null,null,"（基本的給与の月額②）"]
[null,3,null,null,null,null,{"$f":"IF(給与等【要入力】!$E$18=\"〇\",G86,0)","v":0},null,null,null,"円÷３０＝",null,null,null,{"$f":"ROUNDDOWN(G98/30,0)","v":0},null,null,"円",{"$f":"((G98/30)-O98)*100","v":0},"銭",null,null,null,{"$f":"G98/30","v":0},"H"]
[null,"条",null," (Ｉ)","　離職後に補償を行なうべき事由が生じ、かつ、補償事由発生日が災害発生の日の属する年度の翌々年度"]
[null,6,null,null,"以降に属する場合の金額"]
[null,"項",null,null,"　災害発生の日を補償事由発生日とみなして(Ｆ)の例により計算した額"]
[null,"に",null,null,null,null,"（基本的給与の月額①）"]
[null,"よ",null,null,null,null,{"$f":"IFERROR(IF(AND(給与等【要入力】!$E$18=\"〇\",給与等【要入力】!$P$155>=2),G80,0),0)","v":0},null,null,null,"円÷３０＝",null,null,null,{"$f":"ROUNDDOWN(G103/30,0)","v":0},null,null,"円",{"$f":"((G103/30)-O103)*100","v":0},"銭","（ヲ）",null,null,null,{"$f":"G103/30","v":0}]
[null,"る",null,null,"　（ヲ） 及び (Ａ) (Ｂ) (Ｃ) (Ｃ’) (Ｄ) (Ｅ)のうち最も高い金額"]
[null,"金",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(給与等【要入力】!$E$18=\"〇\",給与等【要入力】!$P$155>=2),ROUNDDOWN(MAX($X$32,$X$40,$X$52,($Y$59+$Y$61),$X$71,$X$83,$Y$103),0),0),0)","v":0},null,null,"円",{"$f":"IFERROR(IF(AND(給与等【要入力】!$E$18=\"〇\",給与等【要入力】!$P$155>=2),((Y105)-O105)*100,0),0)","v":0},"銭","（ワ）",null,null,null,{"$f":"IFERROR(IF(O105=0,0,MAX($X$32,$X$40,$X$52,($Y$59+$Y$61),$X$71,$X$83,$Y$103)),0)","v":0}]
[null,"額",null,null,null,"　　　　（ワ）",null,null,null,"　　　（総務大臣が定める率）"]
[null,null,null,null,null,{"$f":"+O105","v":0},null,"　円",{"$f":"+S105","v":0},"　銭×",{"$f":"給与等【要入力】!$K$151","v":0},null,null,null,"＝",{"$f":"IF(K107=0,\"\",INT((F107+I107/100)*K107))","v":""},null,"円",{"$f":"IF(K107=0,\"\",INT((F107+I107/100)*K107*100)-P107*100)","v":""},"銭",null,null,null,{"$f":"Y105*K107","v":0},"I"]
[null,null,null," (Ｊ)","　(Ｈ)　(Ｉ)以外の金額"]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"給与等【要入力】!D159","v":0},null,"円",null,null,null,null,null,{"$f":"P111","v":0},"K"]
[null," (Ｌ)",null,null,"法第２条第１１項又は第１３項による金額"]
[null,null,null,null,"法第２条第１１項又は第１３項の基準日における年齢",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(YEAR(給与等【要入力】!O13)-YEAR(E5)-IF(TODAY()-DATE(YEAR(TODAY()),MONTH(E5),DAY(E5))>=0,0,1),0)","v":1899}]
[]
[null,"最　高　限　度　額",null,null,null,null,null,null,"最　低　限　度　額",null,null,null,null,null,null,null,null,"昭和61年改正法附則第５条の"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"規定による経過措置の適用"]
[null,null,null,null,{"$f":"IF(給与等【要入力】!H159=\"\",\"\",給与等【要入力】!H159)","v":""},null,null,"円",null,null,{"$f":"給与等【要入力】!L159","v":0},null,null,null,null,null,"円",{"$f":"IF(給与等【要入力】!D13>DATE(1987,2,1),\"　□有　　　　　☑無\",\"　☑有　　　　　□無\")","v":"　☑有　　　　　□無"},null,null,null,null,null,{"$f":"K117","v":0},"L"]
[null,"　２　平均給与額"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(X119>E117,OR(COUNTIF(N4,\"*\"&\"年金\"&\"*\")=1,COUNTIF(N4,\"*\"&\"休業\"&\"*\")=1)),E117,IF(AND(X119<E117,OR(COUNTIF(N4,\"*\"&\"年金\"&\"*\")=1,COUNTIF(N4,\"*\"&\"休業\"&\"*\")=1)),X119,X120))","v":0},null,null,null,null,null,"　円（",{"$f":"IF(AND(X119>E117,OR(COUNTIF(N4,\"*\"&\"年金\"&\"*\")=1,COUNTIF(N4,\"*\"&\"休業\"&\"*\")=1)),\"Ｌ\",IF(AND(X119<E117,OR(COUNTIF(N4,\"*\"&\"年金\"&\"*\")=1,COUNTIF(N4,\"*\"&\"休業\"&\"*\")=1)),Z119,Z120))","v":"A"},"）による金額",null,null,null,null,{"$f":"ROUNDUP(MAX(X32,X40,X52,Y61,X71,X83,X86,X94,X107,K117),0)","v":0},"年金",{"$f":"INDEX($X$32:$Y$117,MATCH(MAX($X$32:$X$117),$X$32:$X$117,0),2)","v":"A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(MAX(X32,X40,X52,Y61,X71,X83,X86,X94,X107,P111),0)","v":0},"年金以外",{"$f":"INDEX($X$32:$Y$117,MATCH(MAX($X$32:$X$117),$X$32:$X$117,0),2)","v":"A"}]
[null,"　＊　平均給与額の算定内訳は上記のとおりであることを証明します。"]
[]
[null,null,null,null,null,"年",null,"月",null,"日"]
[]
[]
[null,null,null,null,null,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":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["勤務","当月払い","固定給","有","障害補償年金","災害発生日時の属する月の前月","〇"]
["週休日","翌月払い","実績給","無","障害補償一時金","災害発生日時の属する月の前々月","×"]
["有給休暇","-","-",null,"傷病補償年金","災害発生日時の属する月の前々々月"]
["祝日",null,null,null,"遺族補償年金"]
["欠勤",null,null,null,"葬祭補償"]
["職専免",null,null,null,"休業補償"]
["振替休日"]
["代休"]
["控除日①"]
["控除日②"]
["控除日③"]
["控除日④"]
["控除日⑤"]
["控除日⑥"]
["控除日⑦"]
["控除日⑧"]
["控除に該当するが勤務を要しない日"]
["-"]