{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["マニュアル","入力","設定","計算"],"not_rendered":{"charts":0,"images":7,"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":126,"n_cols":18,"rows_kept":126,"cut":false,"hidden":true,"merged":[[125,0,127,18]]}
["✮管理者用マニュアル✮"]
[]
["1.年次更新時の変更方法"]
[]
[null,"「設定」シートを修正することにより、年度の更新を行うことができます。"]
[null,"変更可能な設定項目は以下の通りです。（「設定」シートの黄色いセル部分）"]
[null,"年度"]
[null,"基礎控除額"]
[null,"基礎分（均等割額，所得割率，限度額）"]
[null,"後期高齢者支援金分（均等割額，所得割率，限度額）"]
[null,"介護保険分（均等割額，所得割率，限度額）"]
[null,"給与所得計算表"]
[null,"年金所得計算表"]
[]
[null,"①年度の修正"]
[null,"[B4]のセルに西暦で入力してください。（例：2018）"]
[null,"自動的に年度[C４]，標題[E4]，月初[B7~M7]，月末[B8~M8]が更新されます。念のため確認してください。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"【図１】ファイル属性の例"]
[null,"未就学児の判定年月日を１年追加変更する"]
[]
[null,"②基礎控除額の修正"]
[null,"[B45]のセルに入力してください。（例:430000）"]
[]
[null,"③基礎分（均等割額，所得割率，限度額）の修正"]
[null,"[B52]のセルに均等割額を入力してください。（例:31200）"]
[null,"[C52]のセルに所得割率を％で入力してください。（例:5.98）"]
[null,"[D52]のセルに限度額を入力してください。（例:510000）"]
[]
[null,"④後期高齢者支援金分（均等割額，所得割率，限度額）の修正"]
[null,"[B56]のセルに均等割額を入力してください。（例:8700）"]
[null,"[C56]のセルに所得割率を％で入力してください。（例:1.81）"]
[null,"[D56]のセルに限度額を入力してください。（例:140000）"]
[]
[null,"⑤介護保険分（均等割額，所得割率，限度額）の修正"]
[null,"[B60]のセルに均等割額を入力してください。（例:13200）"]
[null,"[C60]のセルに所得割率を％で入力してください。（例:1.3）"]
[null,"[D60]のセルに限度額を入力してください。（例:120000）"]
[]
[null,"⑥ファイル属性の修正"]
[null,"必要によりブック属性を修正します。"]
[null,"[メニューバー]より[ファイル]-[プロパティ]を選択し、【図１】を参考に必要箇所を変更してください。"]
[]
[null,"⑦年度を変え、（設定シート、入力シート）現年度と区別するため、入力部分の色を変える。一度保存、コピーを作成し利用者用ワークシートを作成する。"]
[]
["2.利用者用ワークシートの作成方法"]
[]
[null,"「管理者用ワークシート」を元に「利用者用ワークシート」を作成します。"]
[]
[null,"①不要なシートを非表示にします。"]
[null,"マニュアル，設定，計算の各シートを選択します。（複数シートを選択するには、[Ctrl]を押しながら選択します。）"]
[null,"右クリックし、［非表示］を選択します。"]
[null,"[ファイル]→[ブックの保護]→[ブック構成の保護（Ｗ）]を選択します。"]
[null,"\"シート構成\"にチェック☑が入っていることを確認し、パスワードを設定します。（【図２】参照）"]
[]
[null,"②入力シートを保護し、必要な項目以外は修正できないようにします。"]
[null,"[ファイル]より[ファイル]-[オプション]-［詳細設定］を選択します。"]
[null,"次のブックで作業するときの表示設定という項目の「シート見出しを表示する」のチェックをはずします。"]
[null,"次のシートで作業するときの表示設定という項目の「枠線を表示する」「行列番号を表示する」のチェックをはずします。（【図３】参照）"]
[null,"[ファイル]→［ブックの保護］→［現在のシートの保護（P）］"]
[null,"\"シートとロックされたセルの内容を保護する\"にチェック☑が入っていることを確認します。（【図４】参照）"]
[null,"\"ロックされたセル範囲の選択\"と\"ロックされていないセル範囲の選択\"にチェック☑が入っていることを確認します。"]
[null,"※下までスクロールさせて他にチェックされていないか確認してください。"]
[null,"パスワードを設定します。"]
[]
[null,"③別名で保存する。"]
[null,"[メニューバー]より[ファイル]-[名前を付けて保存]を選択します。"]
[]
[]
[null,"【図２】シートの非表示を保護"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"【図３】表示の変更",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"【図４】シートの保護"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["　「加入月」は「データ」タブ→「データの入力規則」→「設定」の「元の値（Ｓ）」を修正する。"]

{"sheet":"入力","index":1,"n_rows":50,"n_cols":24,"rows_kept":50,"cut":false,"hidden":false,"merged":[[21,3,21,4],[16,9,16,10],[27,9,27,10],[24,9,24,10],[25,9,25,10],[26,9,26,10],[21,9,21,11],[21,6,21,7],[36,4,36,5],[36,20,38,22],[36,23,38,25],[28,17,29,25],[30,17,32,25],[30,14,32,16],[34,20,35,22],[34,23,35,25],[28,14,29,16],[37,4,37,5],[37,6,37,7],[32,6,32,7],[32,3,32,4],[36,6,36,7],[31,6,31,7],[31,3,31,4],[3,2,3,26],[4,2,4,26],[8,13,8,24],[9,6,10,6],[7,19,7,23],[5,19,5,23],[9,2,10,2],[9,3,10,3],[9,5,10,5],[9,4,10,4],[9,7,10,7],[9,8,10,8],[8,7,8,8],[7,3,7,5],[8,3,8,5],[31,9,31,11],[32,9,32,11],[22,9,22,10],[23,9,23,10],[17,9,17,10],[21,14,22,16],[23,14,26,25],[21,17,22,25],[9,11,10,11],[8,9,8,10],[9,9,10,10],[9,12,9,23],[15,9,15,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10]]}
[]
[]
[]
[null,null,"【入力手順】\n          ※初めに「入力リセット」を押下してください。\n\n①　加入される方の全員分の「生年月日」を入力してください。\n   　Ex)昭和５４年６月７日生まれの方の場合、S54.6.7と入力してください。(昭和：S　平成：H　令和：Ｒ）または西暦で1979/6/7と入力してください。\n　\n②～④　加入者ごとに前年中の給与収入・年金収入・その他の所得額を入力してください。\n　　非自発的失業者の軽減制度を反映させて計算する場合は、「非」欄に〇を入力してください。（給与所得額を手計算で30/100して入力する必要はありません。また給与収入と給与所得の両方に入力しないように注意してください。）\n\n⑤　加入日を入力してください。特に入力する必要のない場合は当年度の４月１日のままとしてください。（原則的に、加入月部分を直接削除しないでください。）\n\n*入力後は必ず２点をしてもらってください。２点者は、①～⑤の入力項目を確認してください。\n\n"]
[null,null,"【注意事項】\n\n・あくまで試算ですので実際の保険料と異なることがあります。 あらかじめご了承いただける場合のみ、ご利用ください。\n・国民健康保険の加入者が複数いる世帯で、加入者の加入・脱退月が一致しない場合（年度途中の加入・出生・後期加入）、一か月平均が正しく計算できません。\n・国民健康保険料の算定額が限度額を超えた場合は、世帯員の個人別内訳は正しく計算されません。 \n・国民健康保険の加入者が、専従者給与を支払い、又は受け取っている場合、計算が正しくならないことがあります。 \n・国民健康保険加入者に短期、長期譲渡所得があった場合、計算が正しくならないことがあります。 \n・均等割額の軽減制度、旧被扶養者の減免制度は、計算に反映されません。\n\n"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2025-03-11"}]
[null,null,null,null,null,null,null,null,"令和 ７年度 国民健康保険料試算表"]
[null,null,null,{"$f":"IF(F13=\"Error\",\"※収入か給与どちらか一方のみ\n入力してください\",\"\")","v":""}]
[null,null,"①","②",null,null,null,"③",null,"④"]
[null,null,"生年月日","給与収入","給与所得","給与所得\n(非自発所得)","非自発","年金収入","年金所得","その他の所得",null,"賦課基準額","加入月"]
[null,null,null,null,null,null,null,null,null,null,null,null,"4月","5月","6月","7月","8月","9月","10月","11月","12月","1月","2月","3月"]
[null,"入力例","1955-09-19",3000000,null,2020000,null,1400000,300000,200000,null,2090000,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"世帯員Ａ",null,null,null,{"$f":"IF(AND(D13<>0,E13<>0),\"Error\",計算!B3)","v":0},null,null,{"$f":"計算!C3","v":0},null,null,{"$f":"計算!D3","v":0},{"$f":"計算!E3","v":""},{"$f":"計算!F3","v":""},{"$f":"計算!G3","v":""},{"$f":"計算!H3","v":""},{"$f":"計算!I3","v":""},{"$f":"計算!J3","v":""},{"$f":"計算!K3","v":""},{"$f":"計算!L3","v":""},{"$f":"計算!M3","v":""},{"$f":"計算!N3","v":""},{"$f":"計算!O3","v":""},{"$f":"計算!P3","v":""}]
[null,"世帯員Ｂ",null,null,null,{"$f":"IF(AND(D14<>0,E14<>0),\"Error\",計算!B4)","v":0},null,null,{"$f":"計算!C4","v":0},null,null,{"$f":"計算!D4","v":0},{"$f":"計算!E4","v":""},{"$f":"計算!F4","v":""},{"$f":"計算!G4","v":""},{"$f":"計算!H4","v":""},{"$f":"計算!I4","v":""},{"$f":"計算!J4","v":""},{"$f":"計算!K4","v":""},{"$f":"計算!L4","v":""},{"$f":"計算!M4","v":""},{"$f":"計算!N4","v":""},{"$f":"計算!O4","v":""},{"$f":"計算!P4","v":""}]
[null,"世帯員Ｃ",null,null,null,{"$f":"IF(AND(D15<>0,E15<>0),\"Error\",計算!B5)","v":0},null,null,{"$f":"計算!C5","v":0},null,null,{"$f":"計算!D5","v":0},{"$f":"計算!E5","v":""},{"$f":"計算!F5","v":""},{"$f":"計算!G5","v":""},{"$f":"計算!H5","v":""},{"$f":"計算!I5","v":""},{"$f":"計算!J5","v":""},{"$f":"計算!K5","v":""},{"$f":"計算!L5","v":""},{"$f":"計算!M5","v":""},{"$f":"計算!N5","v":""},{"$f":"計算!O5","v":""},{"$f":"計算!P5","v":""}]
[null,"世帯員Ｄ",null,null,null,{"$f":"IF(AND(D16<>0,E16<>0),\"Error\",計算!B6)","v":0},null,null,{"$f":"計算!C6","v":0},null,null,{"$f":"計算!D6","v":0},{"$f":"計算!E6","v":""},{"$f":"計算!F6","v":""},{"$f":"計算!G6","v":""},{"$f":"計算!H6","v":""},{"$f":"計算!I6","v":""},{"$f":"計算!J6","v":""},{"$f":"計算!K6","v":""},{"$f":"計算!L6","v":""},{"$f":"計算!M6","v":""},{"$f":"計算!N6","v":""},{"$f":"計算!O6","v":""},{"$f":"計算!P6","v":""}]
[null,"世帯員Ｅ",null,null,null,{"$f":"IF(AND(D17<>0,E17<>0),\"Error\",計算!B7)","v":0},null,null,{"$f":"計算!C7","v":0},null,null,{"$f":"計算!D7","v":0},{"$f":"計算!E7","v":""},{"$f":"計算!F7","v":""},{"$f":"計算!G7","v":""},{"$f":"計算!H7","v":""},{"$f":"計算!I7","v":""},{"$f":"計算!J7","v":""},{"$f":"計算!K7","v":""},{"$f":"計算!L7","v":""},{"$f":"計算!M7","v":""},{"$f":"計算!N7","v":""},{"$f":"計算!O7","v":""},{"$f":"計算!P7","v":""}]
[null,"世帯員Ｆ",null,null,null,{"$f":"IF(AND(D18<>0,E18<>0),\"Error\",計算!B8)","v":0},null,null,{"$f":"計算!C8","v":0},null,null,{"$f":"計算!D8","v":0},{"$f":"計算!E8","v":""},{"$f":"計算!F8","v":""},{"$f":"計算!G8","v":""},{"$f":"計算!H8","v":""},{"$f":"計算!I8","v":""},{"$f":"計算!J8","v":""},{"$f":"計算!K8","v":""},{"$f":"計算!L8","v":""},{"$f":"計算!M8","v":""},{"$f":"計算!N8","v":""},{"$f":"計算!O8","v":""},{"$f":"計算!P8","v":""}]
[null,null,"⑤"]
[null,"加入月","2025-04-01"]
[]
[null,null,null,"個人別基礎分",null,null,"個人別後期高齢者支援金",null,null,"個人別介護保険分",null,null,null,null,"メモ欄"]
[null,null,null,"世帯員Ａ",{"$f":"計算!S3","v":0},null,"世帯員Ａ",{"$f":"計算!T3","v":0},null,"世帯員Ａ",null,{"$f":"計算!U3","v":0}]
[null,null,null,"世帯員Ｂ",{"$f":"計算!S4","v":0},null,"世帯員Ｂ",{"$f":"計算!T4","v":0},null,"世帯員Ｂ",null,{"$f":"計算!U4","v":0}]
[null,null,null,"世帯員Ｃ",{"$f":"計算!S5","v":0},null,"世帯員Ｃ",{"$f":"計算!T5","v":0},null,"世帯員Ｃ",null,{"$f":"計算!U5","v":0}]
[null,null,null,"世帯員Ｄ",{"$f":"計算!S6","v":0},null,"世帯員Ｄ",{"$f":"計算!T6","v":0},null,"世帯員Ｄ",null,{"$f":"計算!U6","v":0}]
[null,null,null,"世帯員Ｅ",{"$f":"計算!S7","v":0},null,"世帯員Ｅ",{"$f":"計算!T7","v":0},null,"世帯員Ｅ",null,{"$f":"計算!U7","v":0}]
[null,null,null,"世帯員Ｆ",{"$f":"計算!S8","v":0},null,"世帯員Ｆ",{"$f":"計算!T8","v":0},null,"世帯員Ｆ",null,{"$f":"計算!U8","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,"窓口　・　TEL",null,null,"確定申告書　・　源泉徴収票　・　住民税通知書"]
[null,null,null,"基礎分合計",null,null,"後期高齢者支援金分合計",null,null,"介護保険分合計"]
[null,null,null,{"$f":"計算!S10","v":0},null,null,{"$f":"計算!T10","v":0},null,null,{"$f":"計算!U10","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,{"$f":"計算!V10","v":0},null,"　※保険料は世帯単位で計算し、世帯主あてに通知します。"]
[null,null,null,null,"1ヶ月平均",null,{"$f":"計算!W10","v":0}]
[]
[]
[]
["＜ご承知おきください＞"]
["・この試算は、家族状況、収入・所得状況をお申し出いただくことにより保険料を試算するものです。このため、実際の課税資料をもとに算定した保険料決定額とは相違することがあります。"]
["  概算計算となりますので、目安としてご利用ください。正式な決定額は、加入手続き後にお送りする納入通知書でお知らせしますので、予めご了承いただきますよう、お願いします。"]
["・国民健康保険料は、通常、毎月払いではなく後払いのため、実際の一回あたりのお支払い金額は１か月平均金額より高くなる場合があります。"]
["・国民健康保険の加入者が複数いる世帯で、加入者の加入・脱退月が一致しない場合（年度途中の加入・出生・後期加入）、１か月平均が正しく計算できません。"]
["・国民健康保険料の算定額が限度額を超えた場合は、世帯員の個人別内訳は正しく計算されません。 "]
["・国民健康保険の加入者が、専従者給与を支払い、又は受け取っている場合、計算が正しくならないことがあります。 "]
["・国民健康保険加入者に短期、長期譲渡所得があった場合、計算が正しくならないことがあります。 "]
["・均等割額の軽減制度、非自発的失業者の軽減制度、旧被扶養者の減免制度は、計算に反映されません。（非自発的失業者の軽減制度については給与所得（非自発所得）欄を使用する場合を除く）"]

{"sheet":"設定","index":2,"n_rows":60,"n_cols":13,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
[null,"※　黄色のセル以外を修正する時は注意してください"]
[]
[null,"年","年度"]
[null,2025,{"$f":"DATE($B$4,1,1)","v":45658},null,{"$f":"TEXT(C4,\"[$-411]ggge\")&\"年度版　世田谷区　国民健康保険料　試算\"","v":"令和7年度版　世田谷区　国民健康保険料　試算"}]
[]
["月",4,5,6,7,8,9,10,11,12,1,2,3]
["月初",{"$f":"DATE($B$4,B6,1)","v":"2025-04-01"},{"$f":"DATE($B$4,C6,1)","v":"2025-05-01"},"2025-06-01","2025-07-01","2025-08-01","2025-09-01","2025-10-01","2025-11-01","2025-12-01",{"$f":"DATE($B$4+1,K6,1)","v":"2026-01-01"},{"$f":"DATE($B$4+1,L6,1)","v":"2026-02-01"},{"$f":"DATE($B$4+1,M6,1)","v":"2026-03-01"}]
["月末",{"$f":"DATE($B$4,B6+1,1-1)","v":"2025-04-30"},{"$f":"DATE($B$4,C6+1,1-1)","v":"2025-05-31"},"2025-06-30","2025-07-31","2025-08-31","2025-09-30","2025-10-31","2025-11-30","2025-12-31",{"$f":"DATE($B$4+1,K6+1,1-1)","v":"2026-01-31"},{"$f":"DATE($B$4+1,L6+1,1-1)","v":"2026-02-28"},{"$f":"DATE($B$4+1,M6+1,1-1)","v":"2026-03-31"}]
[]
[]
["給与所得計算"]
[null,"給与収入","定額","端数処理","率","定額控除"]
[null,0,0,1,0,0]
[null,551000,0,1,1,550000]
[null,1619000,1069000,1,0,0]
[null,1620000,1070000,1,0,0]
[null,1622000,1072000,1,0,0]
[null,1624000,1074000,1,0,0]
[null,1628000,0,4000,0.6,-100000]
[null,1800000,0,4000,0.7,80000]
[null,3600000,0,4000,0.8,440000]
[null,6600000,0,1,0.9,1100000]
[null,8500000,0,1,1,1950000]
[]
["年金所得計算"]
[null,"６５歳未満"]
[null,"年金収入","率","定額控除"]
[null,0,0,0]
[null,600000,1,600000]
[null,1300000,0.75,275000]
[null,4100000,0.85,685000]
[null,7700000,0.95,1455000]
[null,10000000,1,1955000]
[]
[null,"６５歳以上"]
[null,"年金収入","率","定額控除"]
[null,0,0,0]
[null,1100000,1,1100000]
[null,3300000,0.75,275000]
[null,4100000,0.85,685000]
[null,7700000,0.95,1455000]
[null,10000000,1,1955000]
[]
[]
["基礎控除"]
[null,"基礎控除額"]
[null,430000]
[]
[]
["医療保険分","右クリックし、［非表示］を選択します。"]
[null,"均等割額","所得割率","限度額"]
[null,47300,7.7100000000000002E-2,660000]
[]
["後期高齢者支援金分"]
[null,"均等割額","所得割率","限度額"]
[null,16800,2.69E-2,260000]
[]
["介護保険分"]
[null,"均等割額","所得割率","限度額"]
[null,16600,2.2499999999999999E-2,170000]

{"sheet":"計算","index":3,"n_rows":47,"n_cols":23,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[]
[null,"給与所得","年金所得","賦課基準額","4月","5月","6月","7月","8月","9月","10月","11月","12月","1月","2月","3月","加入月","介護月","基礎分","支援金分","介護分",null,"未就学児　　判定年月日"]
["世帯員Ａ",{"$f":"IF(入力!G13=\"〇\",INT(IF(入力!E13<>0,入力!E13,VLOOKUP(入力!D13,設定!$B$13:$F$23,2,TRUE)+INT(入力!D13/VLOOKUP(入力!D13,設定!$B$13:$F$23,3,TRUE))*VLOOKUP(入力!D13,設定!$B$13:$F$23,3,TRUE)*VLOOKUP(入力!D13,設定!$B$13:$F$23,4,TRUE)-VLOOKUP(入力!D13,設定!$B$13:$F$23,5,TRUE))*0.3),INT(IF(入力!E13<>0,入力!E13,VLOOKUP(入力!D13,設定!$B$13:$F$23,2,TRUE)+INT(入力!D13/VLOOKUP(入力!D13,設定!$B$13:$F$23,3,TRUE))*VLOOKUP(入力!D13,設定!$B$13:$F$23,3,TRUE)*VLOOKUP(入力!D13,設定!$B$13:$F$23,4,TRUE)-VLOOKUP(入力!D13,設定!$B$13:$F$23,5,TRUE))))","v":0},{"$f":"IF(入力!C13>=設定!$C$4,0,IF(DATEDIF(入力!C13,設定!$C$4,\"y\")<65,INT(入力!H13*VLOOKUP(入力!H13,設定!$B$28:$D$33,2,TRUE)-VLOOKUP(入力!H13,設定!$B$28:$D$33,3,TRUE)),INT(入力!H13*VLOOKUP(入力!H13,設定!$B$37:$D$42,2,TRUE)-VLOOKUP(入力!H13,設定!$B$37:$D$42,3,TRUE))))","v":0},{"$f":"MAX(B3+$C3+入力!$J13-設定!$B$47,0)","v":0},{"$f":"IF(入力!$C$20>設定!$B$8,\"\",IF(入力!$C$13>設定!$B$8,\"\",IF(ISBLANK(入力!$C13),\"\",IF(DATEDIF(入力!$C13,設定!B$8+1,\"y\")>=40,IF(DATEDIF(入力!$C13,設定!B$8+1,\"y\")>=65,IF(DATEDIF(入力!$C13,設定!B$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!C8,\"\",IF(入力!$C$13>設定!C8,\"\",IF(ISBLANK(入力!$C13),\"\",IF(DATEDIF(入力!$C13,設定!C$8+1,\"y\")>=40,IF(DATEDIF(入力!$C13,設定!C$8+1,\"y\")>=65,IF(DATEDIF(入力!$C13,設定!C$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!D8,\"\",IF(入力!$C$13>設定!D8,\"\",IF(ISBLANK(入力!$C13),\"\",IF(DATEDIF(入力!$C13,設定!D$8+1,\"y\")>=40,IF(DATEDIF(入力!$C13,設定!D$8+1,\"y\")>=65,IF(DATEDIF(入力!$C13,設定!D$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!E8,\"\",IF(入力!$C$13>設定!E8,\"\",IF(ISBLANK(入力!$C13),\"\",IF(DATEDIF(入力!$C13,設定!E$8+1,\"y\")>=40,IF(DATEDIF(入力!$C13,設定!E$8+1,\"y\")>=65,IF(DATEDIF(入力!$C13,設定!E$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!F8,\"\",IF(入力!$C$13>設定!F8,\"\",IF(ISBLANK(入力!$C13),\"\",IF(DATEDIF(入力!$C13,設定!F$8+1,\"y\")>=40,IF(DATEDIF(入力!$C13,設定!F$8+1,\"y\")>=65,IF(DATEDIF(入力!$C13,設定!F$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!G8,\"\",IF(入力!$C$13>設定!G8,\"\",IF(ISBLANK(入力!$C13),\"\",IF(DATEDIF(入力!$C13,設定!G$8+1,\"y\")>=40,IF(DATEDIF(入力!$C13,設定!G$8+1,\"y\")>=65,IF(DATEDIF(入力!$C13,設定!G$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!H8,\"\",IF(入力!$C$13>設定!H8,\"\",IF(ISBLANK(入力!$C13),\"\",IF(DATEDIF(入力!$C13,設定!H$8+1,\"y\")>=40,IF(DATEDIF(入力!$C13,設定!H$8+1,\"y\")>=65,IF(DATEDIF(入力!$C13,設定!H$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!I8,\"\",IF(入力!$C$13>設定!I8,\"\",IF(ISBLANK(入力!$C13),\"\",IF(DATEDIF(入力!$C13,設定!I$8+1,\"y\")>=40,IF(DATEDIF(入力!$C13,設定!I$8+1,\"y\")>=65,IF(DATEDIF(入力!$C13,設定!I$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!J8,\"\",IF(入力!$C$13>設定!J8,\"\",IF(ISBLANK(入力!$C13),\"\",IF(DATEDIF(入力!$C13,設定!J$8+1,\"y\")>=40,IF(DATEDIF(入力!$C13,設定!J$8+1,\"y\")>=65,IF(DATEDIF(入力!$C13,設定!J$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!K8,\"\",IF(入力!$C$13>設定!K8,\"\",IF(ISBLANK(入力!$C13),\"\",IF(DATEDIF(入力!$C13,設定!K$8+1,\"y\")>=40,IF(DATEDIF(入力!$C13,設定!K$8+1,\"y\")>=65,IF(DATEDIF(入力!$C13,設定!K$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!L8,\"\",IF(入力!$C$13>設定!L8,\"\",IF(ISBLANK(入力!$C13),\"\",IF(DATEDIF(入力!$C13,設定!L$8+1,\"y\")>=40,IF(DATEDIF(入力!$C13,設定!L$8+1,\"y\")>=65,IF(DATEDIF(入力!$C13,設定!L$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!M8,\"\",IF(入力!$C$13>設定!M8,\"\",IF(ISBLANK(入力!$C13),\"\",IF(DATEDIF(入力!$C13,設定!M$8+1,\"y\")>=40,IF(DATEDIF(入力!$C13,設定!M$8+1,\"y\")>=65,IF(DATEDIF(入力!$C13,設定!M$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"COUNTIF(入力!$M13:$X13,\">=1\")","v":0},{"$f":"COUNTIF(入力!$M13:$X13,\"=4\")","v":0},{"$f":"IF(入力!$C$13>W3,INT(INT((設定!B52/2)*$Q3/12)+INT(($D3*設定!$C$52)*$Q3/12)),INT(INT((設定!$B$52)*$Q3/12)+INT(($D3*設定!$C$52)*$Q3/12)))","v":0},{"$f":"IF(入力!$C$13>W3,INT(INT((設定!B56/2)*$Q3/12)+INT(($D3*設定!$C$56)*$Q3/12)),INT(INT((設定!$B$56)*$Q3/12)+INT(($D3*設定!$C$56)*$Q3/12)))","v":0},{"$f":"INT(INT((設定!$B$60)*$R3/12)+INT(($D3*設定!$C$60)*$R3/12))","v":0},null,"2019-04-01"]
["世帯員Ｂ",{"$f":"IF(入力!G14=\"〇\",INT(IF(入力!E14<>0,入力!E14,VLOOKUP(入力!D14,設定!$B$13:$F$23,2,TRUE)+INT(入力!D14/VLOOKUP(入力!D14,設定!$B$13:$F$23,3,TRUE))*VLOOKUP(入力!D14,設定!$B$13:$F$23,3,TRUE)*VLOOKUP(入力!D14,設定!$B$13:$F$23,4,TRUE)-VLOOKUP(入力!D14,設定!$B$13:$F$23,5,TRUE))*0.3),INT(IF(入力!E14<>0,入力!E14,VLOOKUP(入力!D14,設定!$B$13:$F$23,2,TRUE)+INT(入力!D14/VLOOKUP(入力!D14,設定!$B$13:$F$23,3,TRUE))*VLOOKUP(入力!D14,設定!$B$13:$F$23,3,TRUE)*VLOOKUP(入力!D14,設定!$B$13:$F$23,4,TRUE)-VLOOKUP(入力!D14,設定!$B$13:$F$23,5,TRUE))))","v":0},{"$f":"IF(入力!C14>=設定!$C$4,0,IF(DATEDIF(入力!C14,設定!$C$4,\"y\")<65,INT(入力!H14*VLOOKUP(入力!H14,設定!$B$28:$D$33,2,TRUE)-VLOOKUP(入力!H14,設定!$B$28:$D$33,3,TRUE)),INT(入力!H14*VLOOKUP(入力!H14,設定!$B$37:$D$42,2,TRUE)-VLOOKUP(入力!H14,設定!$B$37:$D$42,3,TRUE))))","v":0},{"$f":"MAX(B4+$C4+入力!$J14-設定!$B$47,0)","v":0},{"$f":"IF(入力!$C$20>設定!B8,\"\",IF(入力!$C$14>設定!B8,\"\",IF(ISBLANK(入力!$C14),\"\",IF(DATEDIF(入力!$C14,設定!B$8+1,\"y\")>=40,IF(DATEDIF(入力!$C14,設定!B$8+1,\"y\")>=65,IF(DATEDIF(入力!$C14,設定!B$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!C8,\"\",IF(入力!$C$14>設定!C8,\"\",IF(ISBLANK(入力!$C14),\"\",IF(DATEDIF(入力!$C14,設定!C$8+1,\"y\")>=40,IF(DATEDIF(入力!$C14,設定!C$8+1,\"y\")>=65,IF(DATEDIF(入力!$C14,設定!C$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!D8,\"\",IF(入力!$C$14>設定!D8,\"\",IF(ISBLANK(入力!$C14),\"\",IF(DATEDIF(入力!$C14,設定!D$8+1,\"y\")>=40,IF(DATEDIF(入力!$C14,設定!D$8+1,\"y\")>=65,IF(DATEDIF(入力!$C14,設定!D$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!E8,\"\",IF(入力!$C$14>設定!E8,\"\",IF(ISBLANK(入力!$C14),\"\",IF(DATEDIF(入力!$C14,設定!E$8+1,\"y\")>=40,IF(DATEDIF(入力!$C14,設定!E$8+1,\"y\")>=65,IF(DATEDIF(入力!$C14,設定!E$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!F8,\"\",IF(入力!$C$14>設定!F8,\"\",IF(ISBLANK(入力!$C14),\"\",IF(DATEDIF(入力!$C14,設定!F$8+1,\"y\")>=40,IF(DATEDIF(入力!$C14,設定!F$8+1,\"y\")>=65,IF(DATEDIF(入力!$C14,設定!F$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!G8,\"\",IF(入力!$C$14>設定!G8,\"\",IF(ISBLANK(入力!$C14),\"\",IF(DATEDIF(入力!$C14,設定!G$8+1,\"y\")>=40,IF(DATEDIF(入力!$C14,設定!G$8+1,\"y\")>=65,IF(DATEDIF(入力!$C14,設定!G$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!H8,\"\",IF(入力!$C$14>設定!H8,\"\",IF(ISBLANK(入力!$C14),\"\",IF(DATEDIF(入力!$C14,設定!H$8+1,\"y\")>=40,IF(DATEDIF(入力!$C14,設定!H$8+1,\"y\")>=65,IF(DATEDIF(入力!$C14,設定!H$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!I8,\"\",IF(入力!$C$14>設定!I8,\"\",IF(ISBLANK(入力!$C14),\"\",IF(DATEDIF(入力!$C14,設定!I$8+1,\"y\")>=40,IF(DATEDIF(入力!$C14,設定!I$8+1,\"y\")>=65,IF(DATEDIF(入力!$C14,設定!I$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!J8,\"\",IF(入力!$C$14>設定!J8,\"\",IF(ISBLANK(入力!$C14),\"\",IF(DATEDIF(入力!$C14,設定!J$8+1,\"y\")>=40,IF(DATEDIF(入力!$C14,設定!J$8+1,\"y\")>=65,IF(DATEDIF(入力!$C14,設定!J$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!K8,\"\",IF(入力!$C$14>設定!K8,\"\",IF(ISBLANK(入力!$C14),\"\",IF(DATEDIF(入力!$C14,設定!K$8+1,\"y\")>=40,IF(DATEDIF(入力!$C14,設定!K$8+1,\"y\")>=65,IF(DATEDIF(入力!$C14,設定!K$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!L8,\"\",IF(入力!$C$14>設定!L8,\"\",IF(ISBLANK(入力!$C14),\"\",IF(DATEDIF(入力!$C14,設定!L$8+1,\"y\")>=40,IF(DATEDIF(入力!$C14,設定!L$8+1,\"y\")>=65,IF(DATEDIF(入力!$C14,設定!L$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!M8,\"\",IF(入力!$C$14>設定!M8,\"\",IF(ISBLANK(入力!$C14),\"\",IF(DATEDIF(入力!$C14,設定!M$8+1,\"y\")>=40,IF(DATEDIF(入力!$C14,設定!M$8+1,\"y\")>=65,IF(DATEDIF(入力!$C14,設定!M$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"COUNTIF(入力!$M14:$X14,\">=1\")","v":0},{"$f":"COUNTIF(入力!$M14:$X14,\"=4\")","v":0},{"$f":"IF(入力!$C$14>W3,INT(INT((設定!B52/2)*$Q4/12)+INT(($D4*設定!$C$52)*$Q4/12)),INT(INT((設定!$B$52)*$Q4/12)+INT(($D4*設定!$C$52)*$Q4/12)))","v":0},{"$f":"IF(入力!$C$14>W3,INT(INT((設定!B56/2)*$Q4/12)+INT(($D4*設定!$C$56)*$Q4/12)),INT(INT((設定!$B$56)*$Q4/12)+INT(($D4*設定!$C$56)*$Q4/12)))","v":0},{"$f":"INT(INT((設定!$B$60)*$R4/12)+INT(($D4*設定!$C$60)*$R4/12))","v":0}]
["世帯員Ｃ",{"$f":"IF(入力!G15=\"〇\",INT(IF(入力!E15<>0,入力!E15,VLOOKUP(入力!D15,設定!$B$13:$F$23,2,TRUE)+INT(入力!D15/VLOOKUP(入力!D15,設定!$B$13:$F$23,3,TRUE))*VLOOKUP(入力!D15,設定!$B$13:$F$23,3,TRUE)*VLOOKUP(入力!D15,設定!$B$13:$F$23,4,TRUE)-VLOOKUP(入力!D15,設定!$B$13:$F$23,5,TRUE))*0.3),INT(IF(入力!E15<>0,入力!E15,VLOOKUP(入力!D15,設定!$B$13:$F$23,2,TRUE)+INT(入力!D15/VLOOKUP(入力!D15,設定!$B$13:$F$23,3,TRUE))*VLOOKUP(入力!D15,設定!$B$13:$F$23,3,TRUE)*VLOOKUP(入力!D15,設定!$B$13:$F$23,4,TRUE)-VLOOKUP(入力!D15,設定!$B$13:$F$23,5,TRUE))))","v":0},{"$f":"IF(入力!C15>=設定!$C$4,0,IF(DATEDIF(入力!C15,設定!$C$4,\"y\")<65,INT(入力!H15*VLOOKUP(入力!H15,設定!$B$28:$D$33,2,TRUE)-VLOOKUP(入力!H15,設定!$B$28:$D$33,3,TRUE)),INT(入力!H15*VLOOKUP(入力!H15,設定!$B$37:$D$42,2,TRUE)-VLOOKUP(入力!H15,設定!$B$37:$D$42,3,TRUE))))","v":0},{"$f":"MAX(B5+$C5+入力!$J15-設定!$B$47,0)","v":0},{"$f":"IF(入力!$C$20>設定!$B$8,\"\",IF(入力!$C15>設定!$B$8,\"\",IF(ISBLANK(入力!$C15),\"\",IF(DATEDIF(入力!$C15,設定!B$8+1,\"y\")>=40,IF(DATEDIF(入力!$C15,設定!B$8+1,\"y\")>=65,IF(DATEDIF(入力!$C15,設定!B$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!C8,\"\",IF(入力!$C$15>設定!C8,\"\",IF(ISBLANK(入力!$C15),\"\",IF(DATEDIF(入力!$C15,設定!C$8+1,\"y\")>=40,IF(DATEDIF(入力!$C15,設定!C$8+1,\"y\")>=65,IF(DATEDIF(入力!$C15,設定!C$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!D8,\"\",IF(入力!$C$15>設定!D8,\"\",IF(ISBLANK(入力!$C15),\"\",IF(DATEDIF(入力!$C15,設定!D$8+1,\"y\")>=40,IF(DATEDIF(入力!$C15,設定!D$8+1,\"y\")>=65,IF(DATEDIF(入力!$C15,設定!D$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!E8,\"\",IF(入力!$C$15>設定!E8,\"\",IF(ISBLANK(入力!$C15),\"\",IF(DATEDIF(入力!$C15,設定!E$8+1,\"y\")>=40,IF(DATEDIF(入力!$C15,設定!E$8+1,\"y\")>=65,IF(DATEDIF(入力!$C15,設定!E$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!F8,\"\",IF(入力!$C$15>設定!F8,\"\",IF(ISBLANK(入力!$C15),\"\",IF(DATEDIF(入力!$C15,設定!F$8+1,\"y\")>=40,IF(DATEDIF(入力!$C15,設定!F$8+1,\"y\")>=65,IF(DATEDIF(入力!$C15,設定!F$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!G8,\"\",IF(入力!$C$15>設定!G8,\"\",IF(ISBLANK(入力!$C15),\"\",IF(DATEDIF(入力!$C15,設定!G$8+1,\"y\")>=40,IF(DATEDIF(入力!$C15,設定!G$8+1,\"y\")>=65,IF(DATEDIF(入力!$C15,設定!G$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!H8,\"\",IF(入力!$C$15>設定!H8,\"\",IF(ISBLANK(入力!$C15),\"\",IF(DATEDIF(入力!$C15,設定!H$8+1,\"y\")>=40,IF(DATEDIF(入力!$C15,設定!H$8+1,\"y\")>=65,IF(DATEDIF(入力!$C15,設定!H$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!I8,\"\",IF(入力!$C$15>設定!I8,\"\",IF(ISBLANK(入力!$C15),\"\",IF(DATEDIF(入力!$C15,設定!I$8+1,\"y\")>=40,IF(DATEDIF(入力!$C15,設定!I$8+1,\"y\")>=65,IF(DATEDIF(入力!$C15,設定!I$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!J8,\"\",IF(入力!$C$15>設定!J8,\"\",IF(ISBLANK(入力!$C15),\"\",IF(DATEDIF(入力!$C15,設定!J$8+1,\"y\")>=40,IF(DATEDIF(入力!$C15,設定!J$8+1,\"y\")>=65,IF(DATEDIF(入力!$C15,設定!J$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!K8,\"\",IF(入力!$C$15>設定!K8,\"\",IF(ISBLANK(入力!$C15),\"\",IF(DATEDIF(入力!$C15,設定!K$8+1,\"y\")>=40,IF(DATEDIF(入力!$C15,設定!K$8+1,\"y\")>=65,IF(DATEDIF(入力!$C15,設定!K$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!L8,\"\",IF(入力!$C$15>設定!L8,\"\",IF(ISBLANK(入力!$C15),\"\",IF(DATEDIF(入力!$C15,設定!L$8+1,\"y\")>=40,IF(DATEDIF(入力!$C15,設定!L$8+1,\"y\")>=65,IF(DATEDIF(入力!$C15,設定!L$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!M8,\"\",IF(入力!$C$15>設定!M8,\"\",IF(ISBLANK(入力!$C15),\"\",IF(DATEDIF(入力!$C15,設定!M$8+1,\"y\")>=40,IF(DATEDIF(入力!$C15,設定!M$8+1,\"y\")>=65,IF(DATEDIF(入力!$C15,設定!M$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"COUNTIF(入力!$M15:$X15,\">=1\")","v":0},{"$f":"COUNTIF(入力!$M15:$X15,\"=4\")","v":0},{"$f":"IF(入力!$C$15>W3,INT(INT((設定!B52/2)*$Q5/12)+INT(($D5*設定!$C$52)*$Q5/12)),INT(INT((設定!$B$52)*$Q5/12)+INT(($D5*設定!$C$52)*$Q5/12)))","v":0},{"$f":"IF(入力!$C$15>W3,INT(INT((設定!B56/2)*$Q5/12)+INT(($D5*設定!$C$56)*$Q5/12)),INT(INT((設定!$B$56)*$Q5/12)+INT(($D5*設定!$C$56)*$Q5/12)))","v":0},{"$f":"INT(INT((設定!$B$60)*$R5/12)+INT(($D5*設定!$C$60)*$R5/12))","v":0}]
["世帯員Ｄ",{"$f":"IF(入力!G16=\"〇\",INT(IF(入力!E16<>0,入力!E16,VLOOKUP(入力!D16,設定!$B$13:$F$23,2,TRUE)+INT(入力!D16/VLOOKUP(入力!D16,設定!$B$13:$F$23,3,TRUE))*VLOOKUP(入力!D16,設定!$B$13:$F$23,3,TRUE)*VLOOKUP(入力!D16,設定!$B$13:$F$23,4,TRUE)-VLOOKUP(入力!D16,設定!$B$13:$F$23,5,TRUE))*0.3),INT(IF(入力!E16<>0,入力!E16,VLOOKUP(入力!D16,設定!$B$13:$F$23,2,TRUE)+INT(入力!D16/VLOOKUP(入力!D16,設定!$B$13:$F$23,3,TRUE))*VLOOKUP(入力!D16,設定!$B$13:$F$23,3,TRUE)*VLOOKUP(入力!D16,設定!$B$13:$F$23,4,TRUE)-VLOOKUP(入力!D16,設定!$B$13:$F$23,5,TRUE))))","v":0},{"$f":"IF(入力!C16>=設定!$C$4,0,IF(DATEDIF(入力!C16,設定!$C$4,\"y\")<65,INT(入力!H16*VLOOKUP(入力!H16,設定!$B$28:$D$33,2,TRUE)-VLOOKUP(入力!H16,設定!$B$28:$D$33,3,TRUE)),INT(入力!H16*VLOOKUP(入力!H16,設定!$B$37:$D$42,2,TRUE)-VLOOKUP(入力!H16,設定!$B$37:$D$42,3,TRUE))))","v":0},{"$f":"MAX(B6+$C6+入力!$J16-設定!$B$47,0)","v":0},{"$f":"IF(入力!$C$20>設定!B8,\"\",IF(入力!$C16>設定!B8,\"\",IF(ISBLANK(入力!$C16),\"\",IF(DATEDIF(入力!$C16,設定!B$8+1,\"y\")>=40,IF(DATEDIF(入力!$C16,設定!B$8+1,\"y\")>=65,IF(DATEDIF(入力!$C16,設定!B$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!C8,\"\",IF(入力!$C16>設定!C8,\"\",IF(ISBLANK(入力!$C16),\"\",IF(DATEDIF(入力!$C16,設定!C$8+1,\"y\")>=40,IF(DATEDIF(入力!$C16,設定!C$8+1,\"y\")>=65,IF(DATEDIF(入力!$C16,設定!C$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!D8,\"\",IF(入力!$C16>設定!D8,\"\",IF(ISBLANK(入力!$C16),\"\",IF(DATEDIF(入力!$C16,設定!D$8+1,\"y\")>=40,IF(DATEDIF(入力!$C16,設定!D$8+1,\"y\")>=65,IF(DATEDIF(入力!$C16,設定!D$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!E8,\"\",IF(入力!$C16>設定!E8,\"\",IF(ISBLANK(入力!$C16),\"\",IF(DATEDIF(入力!$C16,設定!E$8+1,\"y\")>=40,IF(DATEDIF(入力!$C16,設定!E$8+1,\"y\")>=65,IF(DATEDIF(入力!$C16,設定!E$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!F8,\"\",IF(入力!$C16>設定!F8,\"\",IF(ISBLANK(入力!$C16),\"\",IF(DATEDIF(入力!$C16,設定!F$8+1,\"y\")>=40,IF(DATEDIF(入力!$C16,設定!F$8+1,\"y\")>=65,IF(DATEDIF(入力!$C16,設定!F$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!G8,\"\",IF(入力!$C16>設定!G8,\"\",IF(ISBLANK(入力!$C16),\"\",IF(DATEDIF(入力!$C16,設定!G$8+1,\"y\")>=40,IF(DATEDIF(入力!$C16,設定!G$8+1,\"y\")>=65,IF(DATEDIF(入力!$C16,設定!G$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!H8,\"\",IF(入力!$C16>設定!H8,\"\",IF(ISBLANK(入力!$C16),\"\",IF(DATEDIF(入力!$C16,設定!H$8+1,\"y\")>=40,IF(DATEDIF(入力!$C16,設定!H$8+1,\"y\")>=65,IF(DATEDIF(入力!$C16,設定!H$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!I8,\"\",IF(入力!$C16>設定!I8,\"\",IF(ISBLANK(入力!$C16),\"\",IF(DATEDIF(入力!$C16,設定!I$8+1,\"y\")>=40,IF(DATEDIF(入力!$C16,設定!I$8+1,\"y\")>=65,IF(DATEDIF(入力!$C16,設定!I$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!J8,\"\",IF(入力!$C16>設定!J8,\"\",IF(ISBLANK(入力!$C16),\"\",IF(DATEDIF(入力!$C16,設定!J$8+1,\"y\")>=40,IF(DATEDIF(入力!$C16,設定!J$8+1,\"y\")>=65,IF(DATEDIF(入力!$C16,設定!J$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!K8,\"\",IF(入力!$C16>設定!K8,\"\",IF(ISBLANK(入力!$C16),\"\",IF(DATEDIF(入力!$C16,設定!K$8+1,\"y\")>=40,IF(DATEDIF(入力!$C16,設定!K$8+1,\"y\")>=65,IF(DATEDIF(入力!$C16,設定!K$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!L8,\"\",IF(入力!$C16>設定!L8,\"\",IF(ISBLANK(入力!$C16),\"\",IF(DATEDIF(入力!$C16,設定!L$8+1,\"y\")>=40,IF(DATEDIF(入力!$C16,設定!L$8+1,\"y\")>=65,IF(DATEDIF(入力!$C16,設定!L$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!M8,\"\",IF(入力!$C16>設定!M8,\"\",IF(ISBLANK(入力!$C16),\"\",IF(DATEDIF(入力!$C16,設定!M$8+1,\"y\")>=40,IF(DATEDIF(入力!$C16,設定!M$8+1,\"y\")>=65,IF(DATEDIF(入力!$C16,設定!M$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"COUNTIF(入力!$M16:$X16,\">=1\")","v":0},{"$f":"COUNTIF(入力!$M16:$X16,\"=4\")","v":0},{"$f":"IF(入力!$C$16>W3,INT(INT((設定!B52/2)*$Q6/12)+INT(($D6*設定!$C$52)*$Q6/12)),INT(INT((設定!$B$52)*$Q6/12)+INT(($D6*設定!$C$52)*$Q6/12)))","v":0},{"$f":"IF(入力!$C$16>W3,INT(INT((設定!B56/2)*$Q6/12)+INT(($D6*設定!$C$56)*$Q6/12)),INT(INT((設定!$B$56)*$Q6/12)+INT(($D6*設定!$C$56)*$Q6/12)))","v":0},{"$f":"INT(INT((設定!$B$60)*$R6/12)+INT(($D6*設定!$C$60)*$R6/12))","v":0}]
["世帯員Ｅ",{"$f":"IF(入力!G17=\"〇\",INT(IF(入力!E17<>0,入力!E17,VLOOKUP(入力!D17,設定!$B$13:$F$23,2,TRUE)+INT(入力!D17/VLOOKUP(入力!D17,設定!$B$13:$F$23,3,TRUE))*VLOOKUP(入力!D17,設定!$B$13:$F$23,3,TRUE)*VLOOKUP(入力!D17,設定!$B$13:$F$23,4,TRUE)-VLOOKUP(入力!D17,設定!$B$13:$F$23,5,TRUE))*0.3),INT(IF(入力!E17<>0,入力!E17,VLOOKUP(入力!D17,設定!$B$13:$F$23,2,TRUE)+INT(入力!D17/VLOOKUP(入力!D17,設定!$B$13:$F$23,3,TRUE))*VLOOKUP(入力!D17,設定!$B$13:$F$23,3,TRUE)*VLOOKUP(入力!D17,設定!$B$13:$F$23,4,TRUE)-VLOOKUP(入力!D17,設定!$B$13:$F$23,5,TRUE))))","v":0},{"$f":"IF(入力!C17>=設定!$C$4,0,IF(DATEDIF(入力!C17,設定!$C$4,\"y\")<65,INT(入力!H17*VLOOKUP(入力!H17,設定!$B$28:$D$33,2,TRUE)-VLOOKUP(入力!H17,設定!$B$28:$D$33,3,TRUE)),INT(入力!H17*VLOOKUP(入力!H17,設定!$B$37:$D$42,2,TRUE)-VLOOKUP(入力!H17,設定!$B$37:$D$42,3,TRUE))))","v":0},{"$f":"MAX(B7+$C7+入力!$J17-設定!$B$47,0)","v":0},{"$f":"IF(入力!$C$20>設定!B8,\"\",IF(入力!$C17>設定!B8,\"\",IF(ISBLANK(入力!$C17),\"\",IF(DATEDIF(入力!$C17,設定!B$8+1,\"y\")>=40,IF(DATEDIF(入力!$C17,設定!B$8+1,\"y\")>=65,IF(DATEDIF(入力!$C17,設定!B$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!C8,\"\",IF(入力!$C17>設定!C8,\"\",IF(ISBLANK(入力!$C17),\"\",IF(DATEDIF(入力!$C17,設定!C$8+1,\"y\")>=40,IF(DATEDIF(入力!$C17,設定!C$8+1,\"y\")>=65,IF(DATEDIF(入力!$C17,設定!C$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!D8,\"\",IF(入力!$C17>設定!D8,\"\",IF(ISBLANK(入力!$C17),\"\",IF(DATEDIF(入力!$C17,設定!D$8+1,\"y\")>=40,IF(DATEDIF(入力!$C17,設定!D$8+1,\"y\")>=65,IF(DATEDIF(入力!$C17,設定!D$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!E8,\"\",IF(入力!$C17>設定!E8,\"\",IF(ISBLANK(入力!$C17),\"\",IF(DATEDIF(入力!$C17,設定!E$8+1,\"y\")>=40,IF(DATEDIF(入力!$C17,設定!E$8+1,\"y\")>=65,IF(DATEDIF(入力!$C17,設定!E$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!F8,\"\",IF(入力!$C17>設定!F8,\"\",IF(ISBLANK(入力!$C17),\"\",IF(DATEDIF(入力!$C17,設定!F$8+1,\"y\")>=40,IF(DATEDIF(入力!$C17,設定!F$8+1,\"y\")>=65,IF(DATEDIF(入力!$C17,設定!F$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!G8,\"\",IF(入力!$C17>設定!G8,\"\",IF(ISBLANK(入力!$C17),\"\",IF(DATEDIF(入力!$C17,設定!G$8+1,\"y\")>=40,IF(DATEDIF(入力!$C17,設定!G$8+1,\"y\")>=65,IF(DATEDIF(入力!$C17,設定!G$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!H8,\"\",IF(入力!$C17>設定!H8,\"\",IF(ISBLANK(入力!$C17),\"\",IF(DATEDIF(入力!$C17,設定!H$8+1,\"y\")>=40,IF(DATEDIF(入力!$C17,設定!H$8+1,\"y\")>=65,IF(DATEDIF(入力!$C17,設定!H$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!I8,\"\",IF(入力!$C17>設定!I8,\"\",IF(ISBLANK(入力!$C17),\"\",IF(DATEDIF(入力!$C17,設定!I$8+1,\"y\")>=40,IF(DATEDIF(入力!$C17,設定!I$8+1,\"y\")>=65,IF(DATEDIF(入力!$C17,設定!I$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!J8,\"\",IF(入力!$C17>設定!J8,\"\",IF(ISBLANK(入力!$C17),\"\",IF(DATEDIF(入力!$C17,設定!J$8+1,\"y\")>=40,IF(DATEDIF(入力!$C17,設定!J$8+1,\"y\")>=65,IF(DATEDIF(入力!$C17,設定!J$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!K8,\"\",IF(入力!$C17>設定!K8,\"\",IF(ISBLANK(入力!$C17),\"\",IF(DATEDIF(入力!$C17,設定!K$8+1,\"y\")>=40,IF(DATEDIF(入力!$C17,設定!K$8+1,\"y\")>=65,IF(DATEDIF(入力!$C17,設定!K$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!L8,\"\",IF(入力!$C17>設定!L8,\"\",IF(ISBLANK(入力!$C17),\"\",IF(DATEDIF(入力!$C17,設定!L$8+1,\"y\")>=40,IF(DATEDIF(入力!$C17,設定!L$8+1,\"y\")>=65,IF(DATEDIF(入力!$C17,設定!L$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!M8,\"\",IF(入力!$C17>設定!M8,\"\",IF(ISBLANK(入力!$C17),\"\",IF(DATEDIF(入力!$C17,設定!M$8+1,\"y\")>=40,IF(DATEDIF(入力!$C17,設定!M$8+1,\"y\")>=65,IF(DATEDIF(入力!$C17,設定!M$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"COUNTIF(入力!$M17:$X17,\">=1\")","v":0},{"$f":"COUNTIF(入力!$M17:$X17,\"=4\")","v":0},{"$f":"IF(入力!$C$17>W3,INT(INT((設定!B52/2)*$Q7/12)+INT(($D7*設定!$C$52)*$Q7/12)),INT(INT((設定!$B$52)*$Q7/12)+INT(($D7*設定!$C$52)*$Q7/12)))","v":0},{"$f":"IF(入力!$C$17>W3,INT(INT((設定!B56/2)*$Q7/12)+INT(($D7*設定!$C$56)*$Q7/12)),INT(INT((設定!$B$56)*$Q7/12)+INT(($D7*設定!$C$56)*$Q7/12)))","v":0},{"$f":"INT(INT((設定!$B$60)*$R7/12)+INT(($D7*設定!$C$60)*$R7/12))","v":0}]
["世帯員Ｆ",{"$f":"IF(入力!G18=\"〇\",INT(IF(入力!E18<>0,入力!E18,VLOOKUP(入力!D18,設定!$B$13:$F$23,2,TRUE)+INT(入力!D18/VLOOKUP(入力!D18,設定!$B$13:$F$23,3,TRUE))*VLOOKUP(入力!D18,設定!$B$13:$F$23,3,TRUE)*VLOOKUP(入力!D18,設定!$B$13:$F$23,4,TRUE)-VLOOKUP(入力!D18,設定!$B$13:$F$23,5,TRUE))*0.3),INT(IF(入力!E18<>0,入力!E18,VLOOKUP(入力!D18,設定!$B$13:$F$23,2,TRUE)+INT(入力!D18/VLOOKUP(入力!D18,設定!$B$13:$F$23,3,TRUE))*VLOOKUP(入力!D18,設定!$B$13:$F$23,3,TRUE)*VLOOKUP(入力!D18,設定!$B$13:$F$23,4,TRUE)-VLOOKUP(入力!D18,設定!$B$13:$F$23,5,TRUE))))","v":0},{"$f":"IF(入力!C18>=設定!$C$4,0,IF(DATEDIF(入力!C18,設定!$C$4,\"y\")<65,INT(入力!H18*VLOOKUP(入力!H18,設定!$B$28:$D$33,2,TRUE)-VLOOKUP(入力!H18,設定!$B$28:$D$33,3,TRUE)),INT(入力!H18*VLOOKUP(入力!H18,設定!$B$37:$D$42,2,TRUE)-VLOOKUP(入力!H18,設定!$B$37:$D$42,3,TRUE))))","v":0},{"$f":"MAX(B8+$C8+入力!$J18-設定!$B$47,0)","v":0},{"$f":"IF(入力!$C$20>設定!B8,\"\",IF(入力!$C18>設定!B8,\"\",IF(ISBLANK(入力!$C18),\"\",IF(DATEDIF(入力!$C18,設定!B$8+1,\"y\")>=40,IF(DATEDIF(入力!$C18,設定!B$8+1,\"y\")>=65,IF(DATEDIF(入力!$C18,設定!B$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!C8,\"\",IF(入力!$C18>設定!C8,\"\",IF(ISBLANK(入力!$C18),\"\",IF(DATEDIF(入力!$C18,設定!C$8+1,\"y\")>=40,IF(DATEDIF(入力!$C18,設定!C$8+1,\"y\")>=65,IF(DATEDIF(入力!$C18,設定!C$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!D8,\"\",IF(入力!$C18>設定!D8,\"\",IF(ISBLANK(入力!$C18),\"\",IF(DATEDIF(入力!$C18,設定!D$8+1,\"y\")>=40,IF(DATEDIF(入力!$C18,設定!D$8+1,\"y\")>=65,IF(DATEDIF(入力!$C18,設定!D$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!E8,\"\",IF(入力!$C18>設定!E8,\"\",IF(ISBLANK(入力!$C18),\"\",IF(DATEDIF(入力!$C18,設定!E$8+1,\"y\")>=40,IF(DATEDIF(入力!$C18,設定!E$8+1,\"y\")>=65,IF(DATEDIF(入力!$C18,設定!E$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!F8,\"\",IF(入力!$C18>設定!F8,\"\",IF(ISBLANK(入力!$C18),\"\",IF(DATEDIF(入力!$C18,設定!F$8+1,\"y\")>=40,IF(DATEDIF(入力!$C18,設定!F$8+1,\"y\")>=65,IF(DATEDIF(入力!$C18,設定!F$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!G8,\"\",IF(入力!$C18>設定!G8,\"\",IF(ISBLANK(入力!$C18),\"\",IF(DATEDIF(入力!$C18,設定!G$8+1,\"y\")>=40,IF(DATEDIF(入力!$C18,設定!G$8+1,\"y\")>=65,IF(DATEDIF(入力!$C18,設定!G$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!H8,\"\",IF(入力!$C18>設定!H8,\"\",IF(ISBLANK(入力!$C18),\"\",IF(DATEDIF(入力!$C18,設定!H$8+1,\"y\")>=40,IF(DATEDIF(入力!$C18,設定!H$8+1,\"y\")>=65,IF(DATEDIF(入力!$C18,設定!H$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!I8,\"\",IF(入力!$C18>設定!I8,\"\",IF(ISBLANK(入力!$C18),\"\",IF(DATEDIF(入力!$C18,設定!I$8+1,\"y\")>=40,IF(DATEDIF(入力!$C18,設定!I$8+1,\"y\")>=65,IF(DATEDIF(入力!$C18,設定!I$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!J8,\"\",IF(入力!$C18>設定!J8,\"\",IF(ISBLANK(入力!$C18),\"\",IF(DATEDIF(入力!$C18,設定!J$8+1,\"y\")>=40,IF(DATEDIF(入力!$C18,設定!J$8+1,\"y\")>=65,IF(DATEDIF(入力!$C18,設定!J$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!K8,\"\",IF(入力!$C18>設定!K8,\"\",IF(ISBLANK(入力!$C18),\"\",IF(DATEDIF(入力!$C18,設定!K$8+1,\"y\")>=40,IF(DATEDIF(入力!$C18,設定!K$8+1,\"y\")>=65,IF(DATEDIF(入力!$C18,設定!K$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!L8,\"\",IF(入力!$C18>設定!L8,\"\",IF(ISBLANK(入力!$C18),\"\",IF(DATEDIF(入力!$C18,設定!L$8+1,\"y\")>=40,IF(DATEDIF(入力!$C18,設定!L$8+1,\"y\")>=65,IF(DATEDIF(入力!$C18,設定!L$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"IF(入力!$C$20>設定!M8,\"\",IF(入力!$C18>設定!M8,\"\",IF(ISBLANK(入力!$C18),\"\",IF(DATEDIF(入力!$C18,設定!M$8+1,\"y\")>=40,IF(DATEDIF(入力!$C18,設定!M$8+1,\"y\")>=65,IF(DATEDIF(入力!$C18,設定!M$8,\"y\")>=75,\"\",1),4),1))))","v":""},{"$f":"COUNTIF(入力!$M18:$X18,\">=1\")","v":0},{"$f":"COUNTIF(入力!$M18:$X18,\"=4\")","v":0},{"$f":"IF(入力!$C$18>W3,INT(INT((設定!B52/2)*$Q8/12)+INT(($D8*設定!$C$52)*$Q8/12)),INT(INT((設定!$B$52)*$Q8/12)+INT(($D8*設定!$C$52)*$Q8/12)))","v":0},{"$f":"IF(入力!$C$18>W3,INT(INT((設定!B56/2)*$Q8/12)+INT(($D8*設定!$C$56)*$Q8/12)),INT(INT((設定!$B$56)*$Q8/12)+INT(($D8*設定!$C$56)*$Q8/12)))","v":0},{"$f":"INT(INT((設定!$B$60)*$R8/12)+INT(($D8*設定!$C$60)*$R8/12))","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,{"$f":"MAX(E3:E8)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(E10:P10,\">=1\")","v":0},{"$f":"COUNTIF(E10:P10,\"=4\")","v":0},{"$f":"S23","v":0},{"$f":"S35","v":0},{"$f":"INT(SUM(F47:Q47))","v":0},{"$f":"SUM(S10:U10)","v":0},{"$f":"IF(MAX(Q3:Q8)=0,0,INT(V10/MAX(Q3:Q8)))","v":0}]
[]
[]
[]
[null,null,null,null,"基礎分保険料"]
[null,null,null,null,null,"4月","5月","6月","7月","8月","9月","10月","11月","12月","1月","2月","3月",null,"合計"]
[null,null,null,null,"Ａ",{"$f":"IF(AND($S3>(設定!$D$52*($Q3/12)),OR(E3=1,E3=4)),設定!$D$52/12,IF(OR(E3=1,E3=4),$S3/$Q3,0))","v":0},{"$f":"IF(AND($S3>(設定!$D$52*($Q3/12)),OR(F3=1,F3=4)),設定!$D$52/12,IF(OR(F3=1,F3=4),$S3/$Q3,0))","v":0},{"$f":"IF(AND($S3>(設定!$D$52*($Q3/12)),OR(G3=1,G3=4)),設定!$D$52/12,IF(OR(G3=1,G3=4),$S3/$Q3,0))","v":0},{"$f":"IF(AND($S3>(設定!$D$52*($Q3/12)),OR(H3=1,H3=4)),設定!$D$52/12,IF(OR(H3=1,H3=4),$S3/$Q3,0))","v":0},{"$f":"IF(AND($S3>(設定!$D$52*($Q3/12)),OR(I3=1,I3=4)),設定!$D$52/12,IF(OR(I3=1,I3=4),$S3/$Q3,0))","v":0},{"$f":"IF(AND($S3>(設定!$D$52*($Q3/12)),OR(J3=1,J3=4)),設定!$D$52/12,IF(OR(J3=1,J3=4),$S3/$Q3,0))","v":0},{"$f":"IF(AND($S3>(設定!$D$52*($Q3/12)),OR(K3=1,K3=4)),設定!$D$52/12,IF(OR(K3=1,K3=4),$S3/$Q3,0))","v":0},{"$f":"IF(AND($S3>(設定!$D$52*($Q3/12)),OR(L3=1,L3=4)),設定!$D$52/12,IF(OR(L3=1,L3=4),$S3/$Q3,0))","v":0},{"$f":"IF(AND($S3>(設定!$D$52*($Q3/12)),OR(M3=1,M3=4)),設定!$D$52/12,IF(OR(M3=1,M3=4),$S3/$Q3,0))","v":0},{"$f":"IF(AND($S3>(設定!$D$52*($Q3/12)),OR(N3=1,N3=4)),設定!$D$52/12,IF(OR(N3=1,N3=4),$S3/$Q3,0))","v":0},{"$f":"IF(AND($S3>(設定!$D$52*($Q3/12)),OR(O3=1,O3=4)),設定!$D$52/12,IF(OR(O3=1,O3=4),$S3/$Q3,0))","v":0},{"$f":"IF(AND($S3>(設定!$D$52*($Q3/12)),OR(P3=1,P3=4)),設定!$D$52/12,IF(OR(P3=1,P3=4),$S3/$Q3,0))","v":0},null,{"$f":"INT(SUM(F16:Q16))","v":0}]
[null,null,null,null,"Ｂ",{"$f":"IF(AND($S4>(設定!$D$52*($Q4/12)),OR(E4=1,E4=4)),設定!$D$52/12,IF(OR(E4=1,E4=4),$S4/$Q4,0))","v":0},{"$f":"IF(AND($S4>(設定!$D$52*($Q4/12)),OR(F4=1,F4=4)),設定!$D$52/12,IF(OR(F4=1,F4=4),$S4/$Q4,0))","v":0},{"$f":"IF(AND($S4>(設定!$D$52*($Q4/12)),OR(G4=1,G4=4)),設定!$D$52/12,IF(OR(G4=1,G4=4),$S4/$Q4,0))","v":0},{"$f":"IF(AND($S4>(設定!$D$52*($Q4/12)),OR(H4=1,H4=4)),設定!$D$52/12,IF(OR(H4=1,H4=4),$S4/$Q4,0))","v":0},{"$f":"IF(AND($S4>(設定!$D$52*($Q4/12)),OR(I4=1,I4=4)),設定!$D$52/12,IF(OR(I4=1,I4=4),$S4/$Q4,0))","v":0},{"$f":"IF(AND($S4>(設定!$D$52*($Q4/12)),OR(J4=1,J4=4)),設定!$D$52/12,IF(OR(J4=1,J4=4),$S4/$Q4,0))","v":0},{"$f":"IF(AND($S4>(設定!$D$52*($Q4/12)),OR(K4=1,K4=4)),設定!$D$52/12,IF(OR(K4=1,K4=4),$S4/$Q4,0))","v":0},{"$f":"IF(AND($S4>(設定!$D$52*($Q4/12)),OR(L4=1,L4=4)),設定!$D$52/12,IF(OR(L4=1,L4=4),$S4/$Q4,0))","v":0},{"$f":"IF(AND($S4>(設定!$D$52*($Q4/12)),OR(M4=1,M4=4)),設定!$D$52/12,IF(OR(M4=1,M4=4),$S4/$Q4,0))","v":0},{"$f":"IF(AND($S4>(設定!$D$52*($Q4/12)),OR(N4=1,N4=4)),設定!$D$52/12,IF(OR(N4=1,N4=4),$S4/$Q4,0))","v":0},{"$f":"IF(AND($S4>(設定!$D$52*($Q4/12)),OR(O4=1,O4=4)),設定!$D$52/12,IF(OR(O4=1,O4=4),$S4/$Q4,0))","v":0},{"$f":"IF(AND($S4>(設定!$D$52*($Q4/12)),OR(P4=1,P4=4)),設定!$D$52/12,IF(OR(P4=1,P4=4),$S4/$Q4,0))","v":0},null,0]
[null,null,null,null,"Ｃ",{"$f":"IF(AND($S5>(設定!$D$52*($Q5/12)),OR(E5=1,E5=4)),設定!$D$52/12,IF(OR(E5=1,E5=4),$S5/$Q5,0))","v":0},{"$f":"IF(AND($S5>(設定!$D$52*($Q5/12)),OR(F5=1,F5=4)),設定!$D$52/12,IF(OR(F5=1,F5=4),$S5/$Q5,0))","v":0},{"$f":"IF(AND($S5>(設定!$D$52*($Q5/12)),OR(G5=1,G5=4)),設定!$D$52/12,IF(OR(G5=1,G5=4),$S5/$Q5,0))","v":0},{"$f":"IF(AND($S5>(設定!$D$52*($Q5/12)),OR(H5=1,H5=4)),設定!$D$52/12,IF(OR(H5=1,H5=4),$S5/$Q5,0))","v":0},{"$f":"IF(AND($S5>(設定!$D$52*($Q5/12)),OR(I5=1,I5=4)),設定!$D$52/12,IF(OR(I5=1,I5=4),$S5/$Q5,0))","v":0},{"$f":"IF(AND($S5>(設定!$D$52*($Q5/12)),OR(J5=1,J5=4)),設定!$D$52/12,IF(OR(J5=1,J5=4),$S5/$Q5,0))","v":0},{"$f":"IF(AND($S5>(設定!$D$52*($Q5/12)),OR(K5=1,K5=4)),設定!$D$52/12,IF(OR(K5=1,K5=4),$S5/$Q5,0))","v":0},{"$f":"IF(AND($S5>(設定!$D$52*($Q5/12)),OR(L5=1,L5=4)),設定!$D$52/12,IF(OR(L5=1,L5=4),$S5/$Q5,0))","v":0},{"$f":"IF(AND($S5>(設定!$D$52*($Q5/12)),OR(M5=1,M5=4)),設定!$D$52/12,IF(OR(M5=1,M5=4),$S5/$Q5,0))","v":0},{"$f":"IF(AND($S5>(設定!$D$52*($Q5/12)),OR(N5=1,N5=4)),設定!$D$52/12,IF(OR(N5=1,N5=4),$S5/$Q5,0))","v":0},{"$f":"IF(AND($S5>(設定!$D$52*($Q5/12)),OR(O5=1,O5=4)),設定!$D$52/12,IF(OR(O5=1,O5=4),$S5/$Q5,0))","v":0},{"$f":"IF(AND($S5>(設定!$D$52*($Q5/12)),OR(P5=1,P5=4)),設定!$D$52/12,IF(OR(P5=1,P5=4),$S5/$Q5,0))","v":0},null,0]
[null,null,null,null,"Ｄ",{"$f":"IF(AND($S6>(設定!$D$52*($Q6/12)),OR(E6=1,E6=4)),設定!$D$52/12,IF(OR(E6=1,E6=4),$S6/$Q6,0))","v":0},{"$f":"IF(AND($S6>(設定!$D$52*($Q6/12)),OR(F6=1,F6=4)),設定!$D$52/12,IF(OR(F6=1,F6=4),$S6/$Q6,0))","v":0},{"$f":"IF(AND($S6>(設定!$D$52*($Q6/12)),OR(G6=1,G6=4)),設定!$D$52/12,IF(OR(G6=1,G6=4),$S6/$Q6,0))","v":0},{"$f":"IF(AND($S6>(設定!$D$52*($Q6/12)),OR(H6=1,H6=4)),設定!$D$52/12,IF(OR(H6=1,H6=4),$S6/$Q6,0))","v":0},{"$f":"IF(AND($S6>(設定!$D$52*($Q6/12)),OR(I6=1,I6=4)),設定!$D$52/12,IF(OR(I6=1,I6=4),$S6/$Q6,0))","v":0},{"$f":"IF(AND($S6>(設定!$D$52*($Q6/12)),OR(J6=1,J6=4)),設定!$D$52/12,IF(OR(J6=1,J6=4),$S6/$Q6,0))","v":0},{"$f":"IF(AND($S6>(設定!$D$52*($Q6/12)),OR(K6=1,K6=4)),設定!$D$52/12,IF(OR(K6=1,K6=4),$S6/$Q6,0))","v":0},{"$f":"IF(AND($S6>(設定!$D$52*($Q6/12)),OR(L6=1,L6=4)),設定!$D$52/12,IF(OR(L6=1,L6=4),$S6/$Q6,0))","v":0},{"$f":"IF(AND($S6>(設定!$D$52*($Q6/12)),OR(M6=1,M6=4)),設定!$D$52/12,IF(OR(M6=1,M6=4),$S6/$Q6,0))","v":0},{"$f":"IF(AND($S6>(設定!$D$52*($Q6/12)),OR(N6=1,N6=4)),設定!$D$52/12,IF(OR(N6=1,N6=4),$S6/$Q6,0))","v":0},{"$f":"IF(AND($S6>(設定!$D$52*($Q6/12)),OR(O6=1,O6=4)),設定!$D$52/12,IF(OR(O6=1,O6=4),$S6/$Q6,0))","v":0},{"$f":"IF(AND($S6>(設定!$D$52*($Q6/12)),OR(P6=1,P6=4)),設定!$D$52/12,IF(OR(P6=1,P6=4),$S6/$Q6,0))","v":0},null,0]
[null,null,null,null,"Ｅ",{"$f":"IF(AND($S7>(設定!$D$52*($Q7/12)),OR(E7=1,E7=4)),設定!$D$52/12,IF(OR(E7=1,E7=4),$S7/$Q7,0))","v":0},{"$f":"IF(AND($S7>(設定!$D$52*($Q7/12)),OR(F7=1,F7=4)),設定!$D$52/12,IF(OR(F7=1,F7=4),$S7/$Q7,0))","v":0},{"$f":"IF(AND($S7>(設定!$D$52*($Q7/12)),OR(G7=1,G7=4)),設定!$D$52/12,IF(OR(G7=1,G7=4),$S7/$Q7,0))","v":0},{"$f":"IF(AND($S7>(設定!$D$52*($Q7/12)),OR(H7=1,H7=4)),設定!$D$52/12,IF(OR(H7=1,H7=4),$S7/$Q7,0))","v":0},{"$f":"IF(AND($S7>(設定!$D$52*($Q7/12)),OR(I7=1,I7=4)),設定!$D$52/12,IF(OR(I7=1,I7=4),$S7/$Q7,0))","v":0},{"$f":"IF(AND($S7>(設定!$D$52*($Q7/12)),OR(J7=1,J7=4)),設定!$D$52/12,IF(OR(J7=1,J7=4),$S7/$Q7,0))","v":0},{"$f":"IF(AND($S7>(設定!$D$52*($Q7/12)),OR(K7=1,K7=4)),設定!$D$52/12,IF(OR(K7=1,K7=4),$S7/$Q7,0))","v":0},{"$f":"IF(AND($S7>(設定!$D$52*($Q7/12)),OR(L7=1,L7=4)),設定!$D$52/12,IF(OR(L7=1,L7=4),$S7/$Q7,0))","v":0},{"$f":"IF(AND($S7>(設定!$D$52*($Q7/12)),OR(M7=1,M7=4)),設定!$D$52/12,IF(OR(M7=1,M7=4),$S7/$Q7,0))","v":0},{"$f":"IF(AND($S7>(設定!$D$52*($Q7/12)),OR(N7=1,N7=4)),設定!$D$52/12,IF(OR(N7=1,N7=4),$S7/$Q7,0))","v":0},{"$f":"IF(AND($S7>(設定!$D$52*($Q7/12)),OR(O7=1,O7=4)),設定!$D$52/12,IF(OR(O7=1,O7=4),$S7/$Q7,0))","v":0},{"$f":"IF(AND($S7>(設定!$D$52*($Q7/12)),OR(P7=1,P7=4)),設定!$D$52/12,IF(OR(P7=1,P7=4),$S7/$Q7,0))","v":0},null,0]
[null,null,null,null,"Ｆ",{"$f":"IF(AND($S8>(設定!$D$52*($Q8/12)),OR(E8=1,E8=4)),設定!$D$52/12,IF(OR(E8=1,E8=4),$S8/$Q8,0))","v":0},{"$f":"IF(AND($S8>(設定!$D$52*($Q8/12)),OR(F8=1,F8=4)),設定!$D$52/12,IF(OR(F8=1,F8=4),$S8/$Q8,0))","v":0},{"$f":"IF(AND($S8>(設定!$D$52*($Q8/12)),OR(G8=1,G8=4)),設定!$D$52/12,IF(OR(G8=1,G8=4),$S8/$Q8,0))","v":0},{"$f":"IF(AND($S8>(設定!$D$52*($Q8/12)),OR(H8=1,H8=4)),設定!$D$52/12,IF(OR(H8=1,H8=4),$S8/$Q8,0))","v":0},{"$f":"IF(AND($S8>(設定!$D$52*($Q8/12)),OR(I8=1,I8=4)),設定!$D$52/12,IF(OR(I8=1,I8=4),$S8/$Q8,0))","v":0},{"$f":"IF(AND($S8>(設定!$D$52*($Q8/12)),OR(J8=1,J8=4)),設定!$D$52/12,IF(OR(J8=1,J8=4),$S8/$Q8,0))","v":0},{"$f":"IF(AND($S8>(設定!$D$52*($Q8/12)),OR(K8=1,K8=4)),設定!$D$52/12,IF(OR(K8=1,K8=4),$S8/$Q8,0))","v":0},{"$f":"IF(AND($S8>(設定!$D$52*($Q8/12)),OR(L8=1,L8=4)),設定!$D$52/12,IF(OR(L8=1,L8=4),$S8/$Q8,0))","v":0},{"$f":"IF(AND($S8>(設定!$D$52*($Q8/12)),OR(M8=1,M8=4)),設定!$D$52/12,IF(OR(M8=1,M8=4),$S8/$Q8,0))","v":0},{"$f":"IF(AND($S8>(設定!$D$52*($Q8/12)),OR(N8=1,N8=4)),設定!$D$52/12,IF(OR(N8=1,N8=4),$S8/$Q8,0))","v":0},{"$f":"IF(AND($S8>(設定!$D$52*($Q8/12)),OR(O8=1,O8=4)),設定!$D$52/12,IF(OR(O8=1,O8=4),$S8/$Q8,0))","v":0},{"$f":"IF(AND($S8>(設定!$D$52*($Q8/12)),OR(P8=1,P8=4)),設定!$D$52/12,IF(OR(P8=1,P8=4),$S8/$Q8,0))","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"世帯",{"$f":"IF(SUM(F16:F22)>=設定!$D$52/12,設定!$D$52/12,SUM(計算!F16:F22))","v":0},{"$f":"IF(SUM(G16:G22)>=設定!$D$52/12,設定!$D$52/12,SUM(計算!G16:G22))","v":0},{"$f":"IF(SUM(H16:H22)>=設定!$D$52/12,設定!$D$52/12,SUM(計算!H16:H22))","v":0},{"$f":"IF(SUM(I16:I22)>=設定!$D$52/12,設定!$D$52/12,SUM(計算!I16:I22))","v":0},{"$f":"IF(SUM(J16:J22)>=設定!$D$52/12,設定!$D$52/12,SUM(計算!J16:J22))","v":0},{"$f":"IF(SUM(K16:K22)>=設定!$D$52/12,設定!$D$52/12,SUM(計算!K16:K22))","v":0},{"$f":"IF(SUM(L16:L22)>=設定!$D$52/12,設定!$D$52/12,SUM(計算!L16:L22))","v":0},{"$f":"IF(SUM(M16:M22)>=設定!$D$52/12,設定!$D$52/12,SUM(計算!M16:M22))","v":0},{"$f":"IF(SUM(N16:N22)>=設定!$D$52/12,設定!$D$52/12,SUM(計算!N16:N22))","v":0},{"$f":"IF(SUM(O16:O22)>=設定!$D$52/12,設定!$D$52/12,SUM(計算!O16:O22))","v":0},{"$f":"IF(SUM(P16:P22)>=設定!$D$52/12,設定!$D$52/12,SUM(計算!P16:P22))","v":0},{"$f":"IF(SUM(Q16:Q22)>=設定!$D$52/12,設定!$D$52/12,SUM(計算!Q16:Q22))","v":0},null,{"$f":"INT(SUM(F23:Q23))","v":0}]
[]
[]
[null,null,null,null,"支援金分保険料"]
[null,null,null,null,null,"4月","5月","6月","7月","8月","9月","10月","11月","12月","1月","2月","3月",null,"合計"]
[null,null,null,null,"Ａ",{"$f":"IF(AND($T3>(設定!$D$56*($Q3/12)),OR(E3=1,E3=4)),設定!$D$56/12,IF(OR(E3=1,E3=4),$T3/$Q3,0))","v":0},{"$f":"IF(AND($T3>(設定!$D$56*($Q3/12)),OR(F3=1,F3=4)),設定!$D$56/12,IF(OR(F3=1,F3=4),$T3/$Q3,0))","v":0},{"$f":"IF(AND($T3>(設定!$D$56*($Q3/12)),OR(G3=1,G3=4)),設定!$D$56/12,IF(OR(G3=1,G3=4),$T3/$Q3,0))","v":0},{"$f":"IF(AND($T3>(設定!$D$56*($Q3/12)),OR(H3=1,H3=4)),設定!$D$56/12,IF(OR(H3=1,H3=4),$T3/$Q3,0))","v":0},{"$f":"IF(AND($T3>(設定!$D$56*($Q3/12)),OR(I3=1,I3=4)),設定!$D$56/12,IF(OR(I3=1,I3=4),$T3/$Q3,0))","v":0},{"$f":"IF(AND($T3>(設定!$D$56*($Q3/12)),OR(J3=1,J3=4)),設定!$D$56/12,IF(OR(J3=1,J3=4),$T3/$Q3,0))","v":0},{"$f":"IF(AND($T3>(設定!$D$56*($Q3/12)),OR(K3=1,K3=4)),設定!$D$56/12,IF(OR(K3=1,K3=4),$T3/$Q3,0))","v":0},{"$f":"IF(AND($T3>(設定!$D$56*($Q3/12)),OR(L3=1,L3=4)),設定!$D$56/12,IF(OR(L3=1,L3=4),$T3/$Q3,0))","v":0},{"$f":"IF(AND($T3>(設定!$D$56*($Q3/12)),OR(M3=1,M3=4)),設定!$D$56/12,IF(OR(M3=1,M3=4),$T3/$Q3,0))","v":0},{"$f":"IF(AND($T3>(設定!$D$56*($Q3/12)),OR(N3=1,N3=4)),設定!$D$56/12,IF(OR(N3=1,N3=4),$T3/$Q3,0))","v":0},{"$f":"IF(AND($T3>(設定!$D$56*($Q3/12)),OR(O3=1,O3=4)),設定!$D$56/12,IF(OR(O3=1,O3=4),$T3/$Q3,0))","v":0},{"$f":"IF(AND($T3>(設定!$D$56*($Q3/12)),OR(P3=1,P3=4)),設定!$D$56/12,IF(OR(P3=1,P3=4),$T3/$Q3,0))","v":0},null,{"$f":"INT(SUM(F28:Q28))","v":0}]
[null,null,null,null,"Ｂ",{"$f":"IF(AND($T4>(設定!$D$56*($Q4/12)),OR(E4=1,E4=4)),設定!$D$56/12,IF(OR(E4=1,E4=4),$T4/$Q4,0))","v":0},{"$f":"IF(AND($T4>(設定!$D$56*($Q4/12)),OR(F4=1,F4=4)),設定!$D$56/12,IF(OR(F4=1,F4=4),$T4/$Q4,0))","v":0},{"$f":"IF(AND($T4>(設定!$D$56*($Q4/12)),OR(G4=1,G4=4)),設定!$D$56/12,IF(OR(G4=1,G4=4),$T4/$Q4,0))","v":0},{"$f":"IF(AND($T4>(設定!$D$56*($Q4/12)),OR(H4=1,H4=4)),設定!$D$56/12,IF(OR(H4=1,H4=4),$T4/$Q4,0))","v":0},{"$f":"IF(AND($T4>(設定!$D$56*($Q4/12)),OR(I4=1,I4=4)),設定!$D$56/12,IF(OR(I4=1,I4=4),$T4/$Q4,0))","v":0},{"$f":"IF(AND($T4>(設定!$D$56*($Q4/12)),OR(J4=1,J4=4)),設定!$D$56/12,IF(OR(J4=1,J4=4),$T4/$Q4,0))","v":0},{"$f":"IF(AND($T4>(設定!$D$56*($Q4/12)),OR(K4=1,K4=4)),設定!$D$56/12,IF(OR(K4=1,K4=4),$T4/$Q4,0))","v":0},{"$f":"IF(AND($T4>(設定!$D$56*($Q4/12)),OR(L4=1,L4=4)),設定!$D$56/12,IF(OR(L4=1,L4=4),$T4/$Q4,0))","v":0},{"$f":"IF(AND($T4>(設定!$D$56*($Q4/12)),OR(M4=1,M4=4)),設定!$D$56/12,IF(OR(M4=1,M4=4),$T4/$Q4,0))","v":0},{"$f":"IF(AND($T4>(設定!$D$56*($Q4/12)),OR(N4=1,N4=4)),設定!$D$56/12,IF(OR(N4=1,N4=4),$T4/$Q4,0))","v":0},{"$f":"IF(AND($T4>(設定!$D$56*($Q4/12)),OR(O4=1,O4=4)),設定!$D$56/12,IF(OR(O4=1,O4=4),$T4/$Q4,0))","v":0},{"$f":"IF(AND($T4>(設定!$D$56*($Q4/12)),OR(P4=1,P4=4)),設定!$D$56/12,IF(OR(P4=1,P4=4),$T4/$Q4,0))","v":0},null,{"$f":"INT(SUM(F29:Q29))","v":0}]
[null,null,null,null,"Ｃ",{"$f":"IF(AND($T5>(設定!$D$56*($Q5/12)),OR(E5=1,E5=4)),設定!$D$56/12,IF(OR(E5=1,E5=4),$T5/$Q5,0))","v":0},{"$f":"IF(AND($T5>(設定!$D$56*($Q5/12)),OR(F5=1,F5=4)),設定!$D$56/12,IF(OR(F5=1,F5=4),$T5/$Q5,0))","v":0},{"$f":"IF(AND($T5>(設定!$D$56*($Q5/12)),OR(G5=1,G5=4)),設定!$D$56/12,IF(OR(G5=1,G5=4),$T5/$Q5,0))","v":0},{"$f":"IF(AND($T5>(設定!$D$56*($Q5/12)),OR(H5=1,H5=4)),設定!$D$56/12,IF(OR(H5=1,H5=4),$T5/$Q5,0))","v":0},{"$f":"IF(AND($T5>(設定!$D$56*($Q5/12)),OR(I5=1,I5=4)),設定!$D$56/12,IF(OR(I5=1,I5=4),$T5/$Q5,0))","v":0},{"$f":"IF(AND($T5>(設定!$D$56*($Q5/12)),OR(J5=1,J5=4)),設定!$D$56/12,IF(OR(J5=1,J5=4),$T5/$Q5,0))","v":0},{"$f":"IF(AND($T5>(設定!$D$56*($Q5/12)),OR(K5=1,K5=4)),設定!$D$56/12,IF(OR(K5=1,K5=4),$T5/$Q5,0))","v":0},{"$f":"IF(AND($T5>(設定!$D$56*($Q5/12)),OR(L5=1,L5=4)),設定!$D$56/12,IF(OR(L5=1,L5=4),$T5/$Q5,0))","v":0},{"$f":"IF(AND($T5>(設定!$D$56*($Q5/12)),OR(M5=1,M5=4)),設定!$D$56/12,IF(OR(M5=1,M5=4),$T5/$Q5,0))","v":0},{"$f":"IF(AND($T5>(設定!$D$56*($Q5/12)),OR(N5=1,N5=4)),設定!$D$56/12,IF(OR(N5=1,N5=4),$T5/$Q5,0))","v":0},{"$f":"IF(AND($T5>(設定!$D$56*($Q5/12)),OR(O5=1,O5=4)),設定!$D$56/12,IF(OR(O5=1,O5=4),$T5/$Q5,0))","v":0},{"$f":"IF(AND($T5>(設定!$D$56*($Q5/12)),OR(P5=1,P5=4)),設定!$D$56/12,IF(OR(P5=1,P5=4),$T5/$Q5,0))","v":0},null,0]
[null,null,null,null,"Ｄ",{"$f":"IF(AND($T6>(設定!$D$56*($Q6/12)),OR(E6=1,E6=4)),設定!$D$56/12,IF(OR(E6=1,E6=4),$T6/$Q6,0))","v":0},{"$f":"IF(AND($T6>(設定!$D$56*($Q6/12)),OR(F6=1,F6=4)),設定!$D$56/12,IF(OR(F6=1,F6=4),$T6/$Q6,0))","v":0},{"$f":"IF(AND($T6>(設定!$D$56*($Q6/12)),OR(G6=1,G6=4)),設定!$D$56/12,IF(OR(G6=1,G6=4),$T6/$Q6,0))","v":0},{"$f":"IF(AND($T6>(設定!$D$56*($Q6/12)),OR(H6=1,H6=4)),設定!$D$56/12,IF(OR(H6=1,H6=4),$T6/$Q6,0))","v":0},{"$f":"IF(AND($T6>(設定!$D$56*($Q6/12)),OR(I6=1,I6=4)),設定!$D$56/12,IF(OR(I6=1,I6=4),$T6/$Q6,0))","v":0},{"$f":"IF(AND($T6>(設定!$D$56*($Q6/12)),OR(J6=1,J6=4)),設定!$D$56/12,IF(OR(J6=1,J6=4),$T6/$Q6,0))","v":0},{"$f":"IF(AND($T6>(設定!$D$56*($Q6/12)),OR(K6=1,K6=4)),設定!$D$56/12,IF(OR(K6=1,K6=4),$T6/$Q6,0))","v":0},{"$f":"IF(AND($T6>(設定!$D$56*($Q6/12)),OR(L6=1,L6=4)),設定!$D$56/12,IF(OR(L6=1,L6=4),$T6/$Q6,0))","v":0},{"$f":"IF(AND($T6>(設定!$D$56*($Q6/12)),OR(M6=1,M6=4)),設定!$D$56/12,IF(OR(M6=1,M6=4),$T6/$Q6,0))","v":0},{"$f":"IF(AND($T6>(設定!$D$56*($Q6/12)),OR(N6=1,N6=4)),設定!$D$56/12,IF(OR(N6=1,N6=4),$T6/$Q6,0))","v":0},{"$f":"IF(AND($T6>(設定!$D$56*($Q6/12)),OR(O6=1,O6=4)),設定!$D$56/12,IF(OR(O6=1,O6=4),$T6/$Q6,0))","v":0},{"$f":"IF(AND($T6>(設定!$D$56*($Q6/12)),OR(P6=1,P6=4)),設定!$D$56/12,IF(OR(P6=1,P6=4),$T6/$Q6,0))","v":0},null,0]
[null,null,null,null,"Ｅ",{"$f":"IF(AND($T7>(設定!$D$56*($Q7/12)),OR(E7=1,E7=4)),設定!$D$56/12,IF(OR(E7=1,E7=4),$T7/$Q7,0))","v":0},{"$f":"IF(AND($T7>(設定!$D$56*($Q7/12)),OR(F7=1,F7=4)),設定!$D$56/12,IF(OR(F7=1,F7=4),$T7/$Q7,0))","v":0},{"$f":"IF(AND($T7>(設定!$D$56*($Q7/12)),OR(G7=1,G7=4)),設定!$D$56/12,IF(OR(G7=1,G7=4),$T7/$Q7,0))","v":0},{"$f":"IF(AND($T7>(設定!$D$56*($Q7/12)),OR(H7=1,H7=4)),設定!$D$56/12,IF(OR(H7=1,H7=4),$T7/$Q7,0))","v":0},{"$f":"IF(AND($T7>(設定!$D$56*($Q7/12)),OR(I7=1,I7=4)),設定!$D$56/12,IF(OR(I7=1,I7=4),$T7/$Q7,0))","v":0},{"$f":"IF(AND($T7>(設定!$D$56*($Q7/12)),OR(J7=1,J7=4)),設定!$D$56/12,IF(OR(J7=1,J7=4),$T7/$Q7,0))","v":0},{"$f":"IF(AND($T7>(設定!$D$56*($Q7/12)),OR(K7=1,K7=4)),設定!$D$56/12,IF(OR(K7=1,K7=4),$T7/$Q7,0))","v":0},{"$f":"IF(AND($T7>(設定!$D$56*($Q7/12)),OR(L7=1,L7=4)),設定!$D$56/12,IF(OR(L7=1,L7=4),$T7/$Q7,0))","v":0},{"$f":"IF(AND($T7>(設定!$D$56*($Q7/12)),OR(M7=1,M7=4)),設定!$D$56/12,IF(OR(M7=1,M7=4),$T7/$Q7,0))","v":0},{"$f":"IF(AND($T7>(設定!$D$56*($Q7/12)),OR(N7=1,N7=4)),設定!$D$56/12,IF(OR(N7=1,N7=4),$T7/$Q7,0))","v":0},{"$f":"IF(AND($T7>(設定!$D$56*($Q7/12)),OR(O7=1,O7=4)),設定!$D$56/12,IF(OR(O7=1,O7=4),$T7/$Q7,0))","v":0},{"$f":"IF(AND($T7>(設定!$D$56*($Q7/12)),OR(P7=1,P7=4)),設定!$D$56/12,IF(OR(P7=1,P7=4),$T7/$Q7,0))","v":0},null,0]
[null,null,null,null,"Ｆ",{"$f":"IF(AND($T8>(設定!$D$56*($Q8/12)),OR(E8=1,E8=4)),設定!$D$56/12,IF(OR(E8=1,E8=4),$T8/$Q8,0))","v":0},{"$f":"IF(AND($T8>(設定!$D$56*($Q8/12)),OR(F8=1,F8=4)),設定!$D$56/12,IF(OR(F8=1,F8=4),$T8/$Q8,0))","v":0},{"$f":"IF(AND($T8>(設定!$D$56*($Q8/12)),OR(G8=1,G8=4)),設定!$D$56/12,IF(OR(G8=1,G8=4),$T8/$Q8,0))","v":0},{"$f":"IF(AND($T8>(設定!$D$56*($Q8/12)),OR(H8=1,H8=4)),設定!$D$56/12,IF(OR(H8=1,H8=4),$T8/$Q8,0))","v":0},{"$f":"IF(AND($T8>(設定!$D$56*($Q8/12)),OR(I8=1,I8=4)),設定!$D$56/12,IF(OR(I8=1,I8=4),$T8/$Q8,0))","v":0},{"$f":"IF(AND($T8>(設定!$D$56*($Q8/12)),OR(J8=1,J8=4)),設定!$D$56/12,IF(OR(J8=1,J8=4),$T8/$Q8,0))","v":0},{"$f":"IF(AND($T8>(設定!$D$56*($Q8/12)),OR(K8=1,K8=4)),設定!$D$56/12,IF(OR(K8=1,K8=4),$T8/$Q8,0))","v":0},{"$f":"IF(AND($T8>(設定!$D$56*($Q8/12)),OR(L8=1,L8=4)),設定!$D$56/12,IF(OR(L8=1,L8=4),$T8/$Q8,0))","v":0},{"$f":"IF(AND($T8>(設定!$D$56*($Q8/12)),OR(M8=1,M8=4)),設定!$D$56/12,IF(OR(M8=1,M8=4),$T8/$Q8,0))","v":0},{"$f":"IF(AND($T8>(設定!$D$56*($Q8/12)),OR(N8=1,N8=4)),設定!$D$56/12,IF(OR(N8=1,N8=4),$T8/$Q8,0))","v":0},{"$f":"IF(AND($T8>(設定!$D$56*($Q8/12)),OR(O8=1,O8=4)),設定!$D$56/12,IF(OR(O8=1,O8=4),$T8/$Q8,0))","v":0},{"$f":"IF(AND($T8>(設定!$D$56*($Q8/12)),OR(P8=1,P8=4)),設定!$D$56/12,IF(OR(P8=1,P8=4),$T8/$Q8,0))","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"世帯",{"$f":"IF(SUM(F28:F34)>=設定!$D$56/12,設定!$D$56/12,SUM(計算!F28:F34))","v":0},{"$f":"IF(SUM(G28:G34)>=設定!$D$56/12,設定!$D$56/12,SUM(計算!G28:G34))","v":0},{"$f":"IF(SUM(H28:H34)>=設定!$D$56/12,設定!$D$56/12,SUM(計算!H28:H34))","v":0},{"$f":"IF(SUM(I28:I34)>=設定!$D$56/12,設定!$D$56/12,SUM(計算!I28:I34))","v":0},{"$f":"IF(SUM(J28:J34)>=設定!$D$56/12,設定!$D$56/12,SUM(計算!J28:J34))","v":0},{"$f":"IF(SUM(K28:K34)>=設定!$D$56/12,設定!$D$56/12,SUM(計算!K28:K34))","v":0},{"$f":"IF(SUM(L28:L34)>=設定!$D$56/12,設定!$D$56/12,SUM(計算!L28:L34))","v":0},{"$f":"IF(SUM(M28:M34)>=設定!$D$56/12,設定!$D$56/12,SUM(計算!M28:M34))","v":0},{"$f":"IF(SUM(N28:N34)>=設定!$D$56/12,設定!$D$56/12,SUM(計算!N28:N34))","v":0},{"$f":"IF(SUM(O28:O34)>=設定!$D$56/12,設定!$D$56/12,SUM(計算!O28:O34))","v":0},{"$f":"IF(SUM(P28:P34)>=設定!$D$56/12,設定!$D$56/12,SUM(計算!P28:P34))","v":0},{"$f":"IF(SUM(Q28:Q34)>=設定!$D$56/12,設定!$D$56/12,SUM(計算!Q28:Q34))","v":0},null,{"$f":"INT(SUM(F35:Q35))","v":0}]
[]
[]
[null,null,null,null,"介護保険料計算"]
[null,null,null,null,null,"4月","5月","6月","7月","8月","9月","10月","11月","12月","1月","2月","3月",null,"合計"]
[null,"右クリックし、［非表示］を選択します。",null,null,"Ａ",{"$f":"IF(AND($U3>設定!$D$60*(計算!$R3/12),計算!E$3=4),設定!$D$60/12,IF(E3=4,$U$3/$R$3,0))","v":0},{"$f":"IF(AND($U3>設定!$D$60*(計算!$R3/12),計算!F$3=4),設定!$D$60/12,IF(F3=4,$U$3/$R$3,0))","v":0},{"$f":"IF(AND($U3>設定!$D$60*(計算!$R3/12),計算!G$3=4),設定!$D$60/12,IF(G3=4,$U$3/$R$3,0))","v":0},{"$f":"IF(AND($U3>設定!$D$60*(計算!$R3/12),計算!H$3=4),設定!$D$60/12,IF(H3=4,$U$3/$R$3,0))","v":0},{"$f":"IF(AND($U3>設定!$D$60*(計算!$R3/12),計算!I$3=4),設定!$D$60/12,IF(I3=4,$U$3/$R$3,0))","v":0},{"$f":"IF(AND($U3>設定!$D$60*(計算!$R3/12),計算!J$3=4),設定!$D$60/12,IF(J3=4,$U$3/$R$3,0))","v":0},{"$f":"IF(AND($U3>設定!$D$60*(計算!$R3/12),計算!K$3=4),設定!$D$60/12,IF(K3=4,$U$3/$R$3,0))","v":0},{"$f":"IF(AND($U3>設定!$D$60*(計算!$R3/12),計算!L$3=4),設定!$D$60/12,IF(L3=4,$U$3/$R$3,0))","v":0},{"$f":"IF(AND($U3>設定!$D$60*(計算!$R3/12),計算!M$3=4),設定!$D$60/12,IF(M3=4,$U$3/$R$3,0))","v":0},{"$f":"IF(AND($U3>設定!$D$60*(計算!$R3/12),計算!N$3=4),設定!$D$60/12,IF(N3=4,$U$3/$R$3,0))","v":0},{"$f":"IF(AND($U3>設定!$D$60*(計算!$R3/12),計算!O$3=4),設定!$D$60/12,IF(O3=4,$U$3/$R$3,0))","v":0},{"$f":"IF(AND($U3>設定!$D$60*(計算!$R3/12),計算!P$3=4),設定!$D$60/12,IF(P3=4,$U$3/$R$3,0))","v":0},null,{"$f":"SUM(F40:Q40)","v":0}]
[null,null,null,null,"Ｂ",{"$f":"IF(AND($U4>設定!$D$60*(計算!$R4/12),計算!E$4=4),設定!$D$60/12,IF(E4=4,$U$4/$R$4,0))","v":0},{"$f":"IF(AND($U4>設定!$D$60*(計算!$R4/12),計算!F$4=4),設定!$D$60/12,IF(F4=4,$U$4/$R$4,0))","v":0},{"$f":"IF(AND($U4>設定!$D$60*(計算!$R4/12),計算!G$4=4),設定!$D$60/12,IF(G4=4,$U$4/$R$4,0))","v":0},{"$f":"IF(AND($U4>設定!$D$60*(計算!$R4/12),計算!H$4=4),設定!$D$60/12,IF(H4=4,$U$4/$R$4,0))","v":0},{"$f":"IF(AND($U4>設定!$D$60*(計算!$R4/12),計算!I$4=4),設定!$D$60/12,IF(I4=4,$U$4/$R$4,0))","v":0},{"$f":"IF(AND($U4>設定!$D$60*(計算!$R4/12),計算!J$4=4),設定!$D$60/12,IF(J4=4,$U$4/$R$4,0))","v":0},{"$f":"IF(AND($U4>設定!$D$60*(計算!$R4/12),計算!K$4=4),設定!$D$60/12,IF(K4=4,$U$4/$R$4,0))","v":0},{"$f":"IF(AND($U4>設定!$D$60*(計算!$R4/12),計算!L$4=4),設定!$D$60/12,IF(L4=4,$U$4/$R$4,0))","v":0},{"$f":"IF(AND($U4>設定!$D$60*(計算!$R4/12),計算!M$4=4),設定!$D$60/12,IF(M4=4,$U$4/$R$4,0))","v":0},{"$f":"IF(AND($U4>設定!$D$60*(計算!$R4/12),計算!N$4=4),設定!$D$60/12,IF(N4=4,$U$4/$R$4,0))","v":0},{"$f":"IF(AND($U4>設定!$D$60*(計算!$R4/12),計算!O$4=4),設定!$D$60/12,IF(O4=4,$U$4/$R$4,0))","v":0},{"$f":"IF(AND($U4>設定!$D$60*(計算!$R4/12),計算!P$4=4),設定!$D$60/12,IF(P4=4,$U$4/$R$4,0))","v":0},null,{"$f":"SUM(F41:Q41)","v":0}]
[null,null,null,null,"Ｃ",{"$f":"IF(AND($U5>設定!$D$60*(計算!$R5/12),計算!E$5=4),設定!$D$60/12,IF(E5=4,$U5/$R5,0))","v":0},{"$f":"IF(AND($U5>設定!$D$60*(計算!$R5/12),計算!F$5=4),設定!$D$60/12,IF(F5=4,$U5/$R5,0))","v":0},{"$f":"IF(AND($U5>設定!$D$60*(計算!$R5/12),計算!G$5=4),設定!$D$60/12,IF(G5=4,$U5/$R5,0))","v":0},{"$f":"IF(AND($U5>設定!$D$60*(計算!$R5/12),計算!H$5=4),設定!$D$60/12,IF(H5=4,$U5/$R5,0))","v":0},{"$f":"IF(AND($U5>設定!$D$60*(計算!$R5/12),計算!I$5=4),設定!$D$60/12,IF(I5=4,$U5/$R5,0))","v":0},{"$f":"IF(AND($U5>設定!$D$60*(計算!$R5/12),計算!J$5=4),設定!$D$60/12,IF(J5=4,$U5/$R5,0))","v":0},{"$f":"IF(AND($U5>設定!$D$60*(計算!$R5/12),計算!K$5=4),設定!$D$60/12,IF(K5=4,$U5/$R5,0))","v":0},{"$f":"IF(AND($U5>設定!$D$60*(計算!$R5/12),計算!L$5=4),設定!$D$60/12,IF(L5=4,$U5/$R5,0))","v":0},{"$f":"IF(AND($U5>設定!$D$60*(計算!$R5/12),計算!M$5=4),設定!$D$60/12,IF(M5=4,$U5/$R5,0))","v":0},{"$f":"IF(AND($U5>設定!$D$60*(計算!$R5/12),計算!N$5=4),設定!$D$60/12,IF(N5=4,$U5/$R5,0))","v":0},{"$f":"IF(AND($U5>設定!$D$60*(計算!$R5/12),計算!O$5=4),設定!$D$60/12,IF(O5=4,$U5/$R5,0))","v":0},{"$f":"IF(AND($U5>設定!$D$60*(計算!$R5/12),計算!P$5=4),設定!$D$60/12,IF(P5=4,$U5/$R5,0))","v":0},null,0]
[null,null,null,null,"Ｄ",{"$f":"IF(AND($U6>設定!$D$60*(計算!$R6/12),計算!E6=4),設定!$D$60/12,IF(E6=4,$U6/$R6,0))","v":0},{"$f":"IF(AND($U6>設定!$D$60*(計算!$R6/12),計算!F6=4),設定!$D$60/12,IF(F6=4,$U6/$R6,0))","v":0},{"$f":"IF(AND($U6>設定!$D$60*(計算!$R6/12),計算!G6=4),設定!$D$60/12,IF(G6=4,$U6/$R6,0))","v":0},{"$f":"IF(AND($U6>設定!$D$60*(計算!$R6/12),計算!H6=4),設定!$D$60/12,IF(H6=4,$U6/$R6,0))","v":0},{"$f":"IF(AND($U6>設定!$D$60*(計算!$R6/12),計算!I6=4),設定!$D$60/12,IF(I6=4,$U6/$R6,0))","v":0},{"$f":"IF(AND($U6>設定!$D$60*(計算!$R6/12),計算!J6=4),設定!$D$60/12,IF(J6=4,$U6/$R6,0))","v":0},{"$f":"IF(AND($U6>設定!$D$60*(計算!$R6/12),計算!K6=4),設定!$D$60/12,IF(K6=4,$U6/$R6,0))","v":0},{"$f":"IF(AND($U6>設定!$D$60*(計算!$R6/12),計算!L6=4),設定!$D$60/12,IF(L6=4,$U6/$R6,0))","v":0},{"$f":"IF(AND($U6>設定!$D$60*(計算!$R6/12),計算!M6=4),設定!$D$60/12,IF(M6=4,$U6/$R6,0))","v":0},{"$f":"IF(AND($U6>設定!$D$60*(計算!$R6/12),計算!N6=4),設定!$D$60/12,IF(N6=4,$U6/$R6,0))","v":0},{"$f":"IF(AND($U6>設定!$D$60*(計算!$R6/12),計算!O6=4),設定!$D$60/12,IF(O6=4,$U6/$R6,0))","v":0},{"$f":"IF(AND($U6>設定!$D$60*(計算!$R6/12),計算!P6=4),設定!$D$60/12,IF(P6=4,$U6/$R6,0))","v":0},null,0]
[null,null,null,null,"Ｅ",{"$f":"IF(AND($U7>設定!$D$60*(計算!$R7/12),計算!E7=4),設定!$D$60/12,IF(E7=4,$U7/$R7,0))","v":0},{"$f":"IF(AND($U7>設定!$D$60*(計算!$R7/12),計算!F7=4),設定!$D$60/12,IF(F7=4,$U7/$R7,0))","v":0},{"$f":"IF(AND($U7>設定!$D$60*(計算!$R7/12),計算!G7=4),設定!$D$60/12,IF(G7=4,$U7/$R7,0))","v":0},{"$f":"IF(AND($U7>設定!$D$60*(計算!$R7/12),計算!H7=4),設定!$D$60/12,IF(H7=4,$U7/$R7,0))","v":0},{"$f":"IF(AND($U7>設定!$D$60*(計算!$R7/12),計算!I7=4),設定!$D$60/12,IF(I7=4,$U7/$R7,0))","v":0},{"$f":"IF(AND($U7>設定!$D$60*(計算!$R7/12),計算!J7=4),設定!$D$60/12,IF(J7=4,$U7/$R7,0))","v":0},{"$f":"IF(AND($U7>設定!$D$60*(計算!$R7/12),計算!K7=4),設定!$D$60/12,IF(K7=4,$U7/$R7,0))","v":0},{"$f":"IF(AND($U7>設定!$D$60*(計算!$R7/12),計算!L7=4),設定!$D$60/12,IF(L7=4,$U7/$R7,0))","v":0},{"$f":"IF(AND($U7>設定!$D$60*(計算!$R7/12),計算!M7=4),設定!$D$60/12,IF(M7=4,$U7/$R7,0))","v":0},{"$f":"IF(AND($U7>設定!$D$60*(計算!$R7/12),計算!N7=4),設定!$D$60/12,IF(N7=4,$U7/$R7,0))","v":0},{"$f":"IF(AND($U7>設定!$D$60*(計算!$R7/12),計算!O7=4),設定!$D$60/12,IF(O7=4,$U7/$R7,0))","v":0},{"$f":"IF(AND($U7>設定!$D$60*(計算!$R7/12),計算!P7=4),設定!$D$60/12,IF(P7=4,$U7/$R7,0))","v":0},null,0]
[null,null,null,null,"Ｆ",{"$f":"IF(AND($U8>設定!$D$60*(計算!$R8/12),計算!E$5=4),設定!$D$60/12,IF(E8=4,$U8/$R8,0))","v":0},{"$f":"IF(AND($U8>設定!$D$60*(計算!$R8/12),計算!F$5=4),設定!$D$60/12,IF(F8=4,$U8/$R8,0))","v":0},{"$f":"IF(AND($U8>設定!$D$60*(計算!$R8/12),計算!G$5=4),設定!$D$60/12,IF(G8=4,$U8/$R8,0))","v":0},{"$f":"IF(AND($U8>設定!$D$60*(計算!$R8/12),計算!H$5=4),設定!$D$60/12,IF(H8=4,$U8/$R8,0))","v":0},{"$f":"IF(AND($U8>設定!$D$60*(計算!$R8/12),計算!I$5=4),設定!$D$60/12,IF(I8=4,$U8/$R8,0))","v":0},{"$f":"IF(AND($U8>設定!$D$60*(計算!$R8/12),計算!J$5=4),設定!$D$60/12,IF(J8=4,$U8/$R8,0))","v":0},{"$f":"IF(AND($U8>設定!$D$60*(計算!$R8/12),計算!K$5=4),設定!$D$60/12,IF(K8=4,$U8/$R8,0))","v":0},{"$f":"IF(AND($U8>設定!$D$60*(計算!$R8/12),計算!L$5=4),設定!$D$60/12,IF(L8=4,$U8/$R8,0))","v":0},{"$f":"IF(AND($U8>設定!$D$60*(計算!$R8/12),計算!M$5=4),設定!$D$60/12,IF(M8=4,$U8/$R8,0))","v":0},{"$f":"IF(AND($U8>設定!$D$60*(計算!$R8/12),計算!N$5=4),設定!$D$60/12,IF(N8=4,$U8/$R8,0))","v":0},{"$f":"IF(AND($U8>設定!$D$60*(計算!$R8/12),計算!O$5=4),設定!$D$60/12,IF(O8=4,$U8/$R8,0))","v":0},{"$f":"IF(AND($U8>設定!$D$60*(計算!$R8/12),計算!P$5=4),設定!$D$60/12,IF(P8=4,$U8/$R8,0))","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"世帯",{"$f":"IF(IF(MAX(F40:F45)=設定!$D$60/12,設定!$D$60/12,SUM(計算!F40:F45))>=設定!$D$60/12,設定!$D$60/12,SUM(F40:F45))","v":0},{"$f":"IF(IF(MAX(G40:G45)=設定!$D$60/12,設定!$D$60/12,SUM(計算!G40:G45))>=設定!$D$60/12,設定!$D$60/12,SUM(G40:G45))","v":0},{"$f":"IF(IF(MAX(H40:H45)=設定!$D$60/12,設定!$D$60/12,SUM(計算!H40:H45))>=設定!$D$60/12,設定!$D$60/12,SUM(H40:H45))","v":0},{"$f":"IF(IF(MAX(I40:I45)=設定!$D$60/12,設定!$D$60/12,SUM(計算!I40:I45))>=設定!$D$60/12,設定!$D$60/12,SUM(I40:I45))","v":0},{"$f":"IF(IF(MAX(J40:J45)=設定!$D$60/12,設定!$D$60/12,SUM(計算!J40:J45))>=設定!$D$60/12,設定!$D$60/12,SUM(J40:J45))","v":0},{"$f":"IF(IF(MAX(K40:K45)=設定!$D$60/12,設定!$D$60/12,SUM(計算!K40:K45))>=設定!$D$60/12,設定!$D$60/12,SUM(K40:K45))","v":0},{"$f":"IF(IF(MAX(L40:L45)=設定!$D$60/12,設定!$D$60/12,SUM(計算!L40:L45))>=設定!$D$60/12,設定!$D$60/12,SUM(L40:L45))","v":0},{"$f":"IF(IF(MAX(M40:M45)=設定!$D$60/12,設定!$D$60/12,SUM(計算!M40:M45))>=設定!$D$60/12,設定!$D$60/12,SUM(M40:M45))","v":0},{"$f":"IF(IF(MAX(N40:N45)=設定!$D$60/12,設定!$D$60/12,SUM(計算!N40:N45))>=設定!$D$60/12,設定!$D$60/12,SUM(N40:N45))","v":0},{"$f":"IF(IF(MAX(O40:O45)=設定!$D$60/12,設定!$D$60/12,SUM(計算!O40:O45))>=設定!$D$60/12,設定!$D$60/12,SUM(O40:O45))","v":0},{"$f":"IF(IF(MAX(P40:P45)=設定!$D$60/12,設定!$D$60/12,SUM(計算!P40:P45))>=設定!$D$60/12,設定!$D$60/12,SUM(P40:P45))","v":0},{"$f":"IF(IF(MAX(Q40:Q45)=設定!$D$60/12,設定!$D$60/12,SUM(計算!Q40:Q45))>=設定!$D$60/12,設定!$D$60/12,SUM(Q40:Q45))","v":0},null,0]