{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["年度更新について","試算","基本情報（毎年更新）","賦課試算","軽減計算","加入情報","給与所得計算","賦課額表示","年金所得計算","所得金額調整控除計算"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["年度更新について　R2.3.30塚本（R3.7追加修正）"]
[]
["更新が必要なシート（赤色）"]
[null,"①　試算（これだけ赤色にしていません）"]
[null,"②　軽減計算"]
[null,"③　給与所得計算"]
[null,"④　年金所得計算"]
[null,"⑤　基本情報（毎年更新）"]
[]
["更新事項について"]
["全般的事項"]
[null,"税制改正等が無ければ、基本的には赤色のシートのうち黄色のセルを更新すれば大丈夫です。"]
[null,"元号が変われば「賦課試算」シートの修正が必要。"]
[]
["個別事項"]
[null,"②　軽減計算"]
[null,"　軽減の計算については、給与・年金所得の控除額の改正があり、令和３年度算定分から影響を受けるため、"]
[null,"　適正な金額になるように数式を見直してください。⇒R3.7月修正済み"]
[]
[null,"③　給与所得計算"]
[null,"④　年金所得計算"]
[null,"　控除額等の修正が考えられるので、修正があった場合は、A・C列は金額の修正、"]
[null,"　E～L列については、IF関数の「真の場合」の数式を修正してください。⇒R3年度版対応済み"]
[]
[null,"⑤　基本情報（毎年更新）"]
[null,"　毎年入力してください。（数字が変わらない場合でも）"]
[null,"　基礎控除額が変わったときは、試算額に影響が出ると思うので、「賦課試算」シートの確認が必要となります。"]
[]
["修正履歴"]
[null,"R3.7月：給与・年金所得の計算方法変更に対応"]
[null,"R4.7月：未就学児の均等割軽減に対応"]

{"sheet":"試算","index":1,"n_rows":81,"n_cols":48,"rows_kept":81,"cut":false,"hidden":false,"merged":[[24,19,25,20],[21,19,23,20],[21,16,23,18],[24,16,25,18],[26,16,27,18],[28,16,29,18],[30,16,31,18],[21,21,23,22],[24,21,25,22],[26,21,27,22],[28,21,29,22],[30,21,31,22],[38,21,39,22],[38,23,39,24],[38,16,39,18],[26,19,27,20],[28,19,29,20],[30,19,31,20],[32,19,33,20],[34,19,35,20],[36,19,37,20],[38,19,39,20],[36,36,37,46],[36,47,37,57],[38,25,39,35],[38,36,39,46],[38,47,39,57],[30,36,31,46],[30,47,31,57],[32,25,33,35],[32,36,33,46],[32,47,33,57],[34,25,35,35],[34,36,35,46],[34,47,35,57],[30,25,31,35],[24,36,25,46],[24,47,25,57],[26,25,27,35],[26,36,27,46],[26,47,27,57],[28,25,29,35],[28,36,29,46],[28,47,29,57],[21,25,21,35],[22,25,23,35],[21,36,21,46],[22,36,23,46],[21,47,21,57],[22,47,23,57],[24,25,25,35],[38,5,39,6],[38,7,39,8],[38,9,39,9],[38,10,39,11],[38,12,39,12],[38,13,39,14],[38,15,39,15],[36,5,37,6],[36,7,37,8],[36,9,37,9],[36,10,37,11],[36,12,37,12],[36,13,37,14],[32,15,33,15],[34,5,35,6],[34,7,35,8],[34,9,35,9],[34,10,35,11],[34,12,35,12],[34,13,35,14],[34,15,35,15],[36,25,37,35],[32,5,33,6],[32,7,33,8],[32,9,33,9],[32,10,33,11],[32,12,33,12],[32,13,33,14],[36,23,37,24],[36,15,37,15],[36,16,37,18],[32,16,33,18],[34,16,35,18],[32,21,33,22],[34,21,35,22],[36,21,37,22],[30,7,31,8],[30,9,31,9],[30,10,31,11],[30,12,31,12],[30,13,31,14],[30,15,31,15],[28,5,29,6],[28,7,29,8],[28,9,29,9],[28,10,29,11],[28,12,29,12],[28,13,29,14],[0,0,0,2],[0,3,0,4],[24,1,25,1],[24,2,25,4],[26,1,27,1],[26,2,27,4],[21,1,23,4],[19,1,20,13],[19,14,20,22],[24,15,25,15],[26,5,27,6],[26,7,27,8],[26,9,27,9],[26,10,27,11],[26,12,27,12],[26,13,27,14],[26,15,27,15],[24,5,25,6],[24,7,25,8],[24,9,25,9],[24,10,25,11],[24,12,25,12],[24,13,25,14],[21,5,23,15],[40,23,40,24],[17,1,18,13],[17,14,18,22],[21,23,23,24],[24,23,25,24],[26,23,27,24],[28,23,29,24],[30,23,31,24],[32,23,33,24],[34,23,35,24],[28,2,29,4],[30,2,31,4],[32,2,33,4],[34,2,35,4],[36,2,37,4],[38,2,39,4],[28,1,29,1],[30,1,31,1],[32,1,33,1],[34,1,35,1],[36,1,37,1],[38,1,39,1],[28,15,29,15],[30,5,31,6],[42,1,43,6],[42,7,43,57],[41,23,41,24],[52,1,53,11],[52,12,53,30],[52,31,53,42],[52,43,53,54],[54,1,55,11],[54,12,55,30],[54,31,55,42],[54,43,55,54],[46,31,47,42],[46,43,47,54],[48,1,49,11],[48,12,49,30],[48,31,49,42],[48,43,49,54],[50,1,51,11],[50,12,51,30],[50,31,51,42],[50,43,51,54],[44,1,45,6],[46,1,47,11],[46,12,47,30],[44,7,45,11],[44,46,45,54],[44,39,45,45],[44,12,45,25],[44,26,45,38],[72,1,73,11],[72,12,73,30],[72,31,73,42],[72,43,73,54],[56,1,58,11],[56,12,58,30],[56,31,58,42],[56,43,58,54],[80,1,81,11],[80,12,81,30],[80,31,81,42],[80,43,81,54],[59,43,60,54],[59,1,60,20],[59,38,60,42],[70,1,71,11],[62,1,62,25],[74,1,75,11],[74,12,75,30],[74,31,75,42],[74,43,75,54],[76,1,77,11],[76,12,77,30],[76,31,77,42],[76,43,77,54],[78,1,79,11],[78,12,79,30],[78,31,79,42],[78,43,79,54],[59,25,60,37]]}
["令和",null,null,5,null,"年度　国保税額試算シート"]
[]
[null,"※次のような場合は、税額を計算することができませんので、直接窓口にてお尋ねください。"]
[null,null,"● 年度途中で国保に「加入」または「脱退」する世帯員がいる場合"]
[null,null,"● 年度途中に75歳になる国保加入者がいる場合"]
[null,null,"● 国保から後期高齢者医療制度に移行した世帯員がいる場合"]
[null,null,"● 分離課税の所得や専従者控除、専従者給与、純損失・雑損失の繰越控除などがある場合"]
[null,null,"● 非自発失業者に対する国保税の軽減措置の対象者がいる場合"]
[]
[]
[null,"試算方法"]
[null,null,"① 国保加入月を入力してください。"]
[null,null,"② 世帯主の国保加入の有無を入力してください。"]
[null,null,"③ 世帯主と国保に加入する世帯員の生年月日と収入（所得）を入力してください。"]
[null,null,null,"※世帯主は国保に加入しない場合でも必ず入力してください。"]
[]
[]
[null,"何月から国保に加入しますか？\n（数字を入力してください。）"]
[]
[null,"世帯主は国保に加入しますか？"]
[]
[null,null,null,null,null,"生　年　月　日\n（元号はリストから選択）",null,null,null,null,null,null,null,null,null,null,"生年月日\n（計算用）",null,null,"年齢",null,{"$f":"\"R\"&D1&\".1.1\"","v":"R5.1.1"},null,{"$f":"加入情報!T3","v":{"$error":"#VALUE!"}},null,{"$f":"\"令和\"&$D$1-1&\"年中の給与収入\"","v":"令和4年中の給与収入"},null,null,null,null,null,null,null,null,null,null,{"$f":"\"令和\"&$D$1-1&\"年中の年金収入\"","v":"令和4年中の年金収入"},null,null,null,null,null,null,null,null,null,null,{"$f":"\"令和\"&$D$1-1&\"年中のその他所得\"","v":"令和4年中のその他所得"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"総支給額を記入してください。\n（源泉徴収票の支払金額）",null,null,null,null,null,null,null,null,null,null,"総支給額を記入してください。\n（源泉徴収票の支払金額）",null,null,null,null,null,null,null,null,null,null,"※ 収入金額から必要経費を差引いた金額を入力してください"]
[]
[null,1,"世帯主",null,null,null,null,null,null,"年",null,null,"月",null,null,"日",{"$f":"CONCATENATE(F25,H25,J25,K25,M25,N25,P25)","v":"年月日"},null,null,{"$f":"IFERROR(DATEDIF(Q25,TODAY(),\"y\"),\"\")","v":""},null,{"$f":"IFERROR(DATEDIF(Q25,$V$22,\"y\"),\"\")","v":""},null,{"$f":"IFERROR(DATEDIF(Q25,$X$22,\"y\"),\"\")","v":""}]
[]
[null,2,"世帯員",null,null,null,null,null,null,"年",null,null,"月",null,null,"日",{"$f":"CONCATENATE(F27,H27,J27,K27,M27,N27,P27)","v":"年月日"},null,null,{"$f":"IFERROR(DATEDIF(Q27,TODAY(),\"y\"),\"\")","v":""},null,{"$f":"IFERROR(DATEDIF(Q27,$V$22,\"y\"),\"\")","v":""},null,{"$f":"IFERROR(DATEDIF(Q27,$X$22,\"y\"),\"\")","v":""}]
[]
[null,3,"世帯員",null,null,null,null,null,null,"年",null,null,"月",null,null,"日",{"$f":"CONCATENATE(F29,H29,J29,K29,M29,N29,P29)","v":"年月日"},null,null,{"$f":"IFERROR(DATEDIF(Q29,TODAY(),\"y\"),\"\")","v":""},null,{"$f":"IFERROR(DATEDIF(Q29,$V$22,\"y\"),\"\")","v":""},null,{"$f":"IFERROR(DATEDIF(Q29,$X$22,\"y\"),\"\")","v":""}]
[]
[null,4,"世帯員",null,null,null,null,null,null,"年",null,null,"月",null,null,"日",{"$f":"CONCATENATE(F31,H31,J31,K31,M31,N31,P31)","v":"年月日"},null,null,{"$f":"IFERROR(DATEDIF(Q31,TODAY(),\"y\"),\"\")","v":""},null,{"$f":"IFERROR(DATEDIF(Q31,$V$22,\"y\"),\"\")","v":""},null,{"$f":"IFERROR(DATEDIF(Q31,$X$22,\"y\"),\"\")","v":""}]
[]
[null,5,"世帯員",null,null,null,null,null,null,"年",null,null,"月",null,null,"日",{"$f":"CONCATENATE(F33,H33,J33,K33,M33,N33,P33)","v":"年月日"},null,null,{"$f":"IFERROR(DATEDIF(Q33,TODAY(),\"y\"),\"\")","v":""},null,{"$f":"IFERROR(DATEDIF(Q33,$V$22,\"y\"),\"\")","v":""},null,{"$f":"IFERROR(DATEDIF(Q33,$X$22,\"y\"),\"\")","v":""}]
[]
[null,6,"世帯員",null,null,null,null,null,null,"年",null,null,"月",null,null,"日",{"$f":"CONCATENATE(F35,H35,J35,K35,M35,N35,P35)","v":"年月日"},null,null,{"$f":"IFERROR(DATEDIF(Q35,TODAY(),\"y\"),\"\")","v":""},null,{"$f":"IFERROR(DATEDIF(Q35,$V$22,\"y\"),\"\")","v":""},null,{"$f":"IFERROR(DATEDIF(Q35,$X$22,\"y\"),\"\")","v":""}]
[]
[null,7,"世帯員",null,null,null,null,null,null,"年",null,null,"月",null,null,"日",{"$f":"CONCATENATE(F37,H37,J37,K37,M37,N37,P37)","v":"年月日"},null,null,{"$f":"IFERROR(DATEDIF(Q37,TODAY(),\"y\"),\"\")","v":""},null,{"$f":"IFERROR(DATEDIF(Q37,$V$22,\"y\"),\"\")","v":""},null,{"$f":"IFERROR(DATEDIF(Q37,$X$22,\"y\"),\"\")","v":""}]
[]
[null,8,"世帯員",null,null,null,null,null,null,"年",null,null,"月",null,null,"日",{"$f":"CONCATENATE(F39,H39,J39,K39,M39,N39,P39)","v":"年月日"},null,null,{"$f":"IFERROR(DATEDIF(Q39,TODAY(),\"y\"),\"\")","v":""},null,{"$f":"IFERROR(DATEDIF(Q39,$V$22,\"y\"),\"\")","v":""},null,{"$f":"IFERROR(DATEDIF(Q39,$X$22,\"y\"),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"被保数"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O20=\"はい\",COUNTIF(X27:Y40,\"<75\")+1,COUNTIF(X27:Y40,\"<75\"))","v":0}]
[null,"試算結果",null,null,null,null,null,"※このシートで試算される税額はあくまで概算額です。実際の課税額とは異なることがあります。"]
[]
[null,"加入者数",null,null,null,null,null,{"$f":"X42","v":0},null,null,null,null,"課税所得合計",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"軽減計算!O17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"軽減割合",null,null,null,null,null,null,{"$f":"IF(軽減計算!J18=0,\"なし\",軽減計算!J18&\"割軽減\")","v":"7割軽減"}]
[]
[null,"【課税内訳】",null,null,null,null,null,null,null,null,null,null,"基礎課税額（医療分）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"後期高齢者支援金等課税額",null,null,null,null,null,null,null,null,null,null,null,"介護納付金課税額\n（40歳～64歳）"]
[]
[null,"① 所得割額",null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!X184","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!AD184","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!AJ184","v":0}]
[]
[null,"② 均等割額",null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!AA184","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!AG184","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!AM184","v":0}]
[]
[null,"③ 平等割額",null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!X185","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!AD185","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!AJ185","v":0}]
[]
[null,"④ 課税限度超過額",null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!X186","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!AD186","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!AJ186","v":0}]
[]
[null,"合　　計\n（①＋②＋③－④）\n※100円未満切り捨て",null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!X187","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!AD187","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!AJ187","v":0}]
[]
[]
[null,{"$f":"O18&\"月から加入された場合の国保税額\"","v":"月から加入された場合の国保税額"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M57+AF57+AR57","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"（一月当たり）",null,null,null,null,{"$f":"IFERROR(ROUND(Z60/賦課試算!S159,0),0)","v":0}]
[]
[]
[null,"仮算定 《第1期（4月）～第3期（6月）》",null,null,null,null,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":"IF(D1=2,\"・・・平成30年中の所得で仮算定します\",\"・・・令和\"&D1-2&\"年中の所得で仮算定します\")","v":"・・・令和3年中の所得で仮算定します"}]
[null,null,{"$f":"\"令和\"&D1&\"年度の国保税は、令和\"&D1-1&\"年中の所得で算定しますが、所得が確定していない第1期（4月納期）から\"","v":"令和5年度の国保税は、令和4年中の所得で算定しますが、所得が確定していない第1期（4月納期）から"}]
[null,null,{"$f":"\"第3期（6月納期）までは、令和\"&D1-1&\"年度国保税（年税額）の12分の1相当額が各期の税額となります。\"","v":"第3期（6月納期）までは、令和4年度国保税（年税額）の12分の1相当額が各期の税額となります。"}]
[]
[null,"本算定 《第4期（7月）～第12期（3月）》",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"・・・令和\"&D1-1&\"年中の所得で算定し直します\"","v":"・・・令和4年中の所得で算定し直します"}]
[null,null,{"$f":"\"令和\"&D1&\"年度の国保税（年税額）は、7月に本課税します。\"","v":"令和5年度の国保税（年税額）は、7月に本課税します。"}]
[null,null,{"$f":"\"前年所得で算定し直した令和\"&D1&\"年度の年税額から、仮算定（第1期～第3期）の国保税を差し引いた額を\"","v":"前年所得で算定し直した令和5年度の年税額から、仮算定（第1期～第3期）の国保税を差し引いた額を"}]
[null,null,"第4期（7月納期）から第12期（3月納期）までの納期で納めていただくこととなります。"]
[null,"※税率等について"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"基礎課税額（医療分）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"後期高齢者支援金等課税額",null,null,null,null,null,null,null,null,null,null,null,"介護納付金課税額\n（40歳～64歳）"]
[]
[null,"① 所得割額",null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!K3","v":0.106},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!W3","v":3.3000000000000002E-2},null,null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!AI3","v":2.7E-2}]
[]
[null,"② 均等割額",null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!N3","v":29600},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!Z3","v":9300},null,null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!AL3","v":14900}]
[]
[null,"③ 平等割額",null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!Q3","v":22000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!AC3","v":6900},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(賦課試算!AO3=0,\"なし\",賦課試算!AO3&\"円\")","v":"なし"}]
[]
[null,"④ 課税限度額",null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!T3","v":650000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!AF3","v":220000},null,null,null,null,null,null,null,null,null,null,null,{"$f":"賦課試算!AR3","v":170000}]

{"sheet":"基本情報（毎年更新）","index":2,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":true,"merged":[[0,1,0,4],[0,5,0,8],[0,9,0,12],[0,13,1,13],[0,0,1,0]]}
[null,"医療",null,null,null,"後期",null,null,null,"介護",null,null,null,"基礎控除額"]
[null,"所得割","均等割","平等割","限度額","所得割","均等割","平等割","限度額","所得割","均等割","平等割","限度額"]
["H28",9.6000000000000002E-2,24800,19200,540000,3.9E-2,6200,4800,190000,2.9000000000000001E-2,8000,5700,160000,330000]
["H29",9.6000000000000002E-2,24800,19200,540000,3.9E-2,6200,4800,190000,2.9000000000000001E-2,8000,5700,160000,330000]
["H30",0.106,29600,22000,580000,3.3000000000000002E-2,9300,6900,190000,2.7E-2,14900,0,160000,330000]
["R1",0.106,29600,22000,610000,3.3000000000000002E-2,9300,6900,190000,2.7E-2,14900,0,160000,330000]
["R2",0.106,29600,22000,630000,3.3000000000000002E-2,9300,6900,190000,2.7E-2,14900,0,170000,330000]
["R3",0.106,29600,22000,630000,3.3000000000000002E-2,9300,6900,190000,2.7E-2,14900,0,170000,430000]
["R4",0.106,29600,22000,650000,3.3000000000000002E-2,9300,6900,200000,2.7E-2,14900,0,170000,430000]
["R5",0.106,29600,22000,650000,3.3000000000000002E-2,9300,6900,220000,2.7E-2,14900,0,170000,430000]
["R6"]
["R7"]
["R8"]
["R9"]
["R10"]
["R11"]
["R12"]
["R13"]
["R14"]
["R15"]
["R16"]
["R17"]
["R18"]
["R19"]
["R20"]

{"sheet":"賦課試算","index":3,"n_rows":187,"n_cols":47,"rows_kept":187,"cut":false,"hidden":true,"merged":[[152,3,154,3],[152,17,152,18],[152,21,152,22],[152,23,152,25],[152,26,152,28],[152,29,152,31],[152,32,152,34],[152,35,152,37],[152,38,152,40],[125,17,125,18],[125,21,125,22],[125,23,125,25],[125,26,125,28],[125,29,125,31],[125,32,125,34],[125,35,125,37],[125,38,125,40],[149,3,151,3],[149,17,149,18],[149,21,149,22],[149,23,149,25],[149,26,149,28],[149,29,149,31],[149,32,149,34],[149,35,149,37],[149,38,149,40],[140,17,140,18],[140,21,140,22],[140,23,140,25],[140,26,140,28],[140,29,140,31],[140,32,140,34],[140,35,140,37],[113,35,113,37],[113,38,113,40],[114,17,114,18],[114,19,114,20],[119,3,121,3],[119,17,119,18],[119,21,119,22],[134,35,134,37],[134,38,134,40],[119,23,119,25],[119,26,119,28],[119,29,119,31],[119,32,119,34],[119,35,119,37],[119,38,119,40],[122,3,124,3],[122,17,122,18],[122,21,122,22],[122,23,122,25],[122,26,122,28],[122,29,122,31],[122,32,122,34],[122,35,122,37],[122,38,122,40],[113,0,114,0],[113,1,113,3],[113,17,113,18],[113,19,113,20],[113,21,113,22],[113,23,113,25],[113,26,113,28],[113,29,113,31],[113,32,113,34],[129,17,129,18],[129,19,129,20],[134,3,136,3],[134,17,134,18],[134,21,134,22],[134,23,134,25],[134,26,134,28],[134,29,134,31],[134,32,134,34],[131,3,133,3],[131,17,131,18],[131,21,131,22],[131,23,131,25],[131,26,131,28],[131,29,131,31],[131,32,131,34],[128,17,128,18],[128,19,128,20],[128,21,128,22],[128,23,128,25],[128,26,128,28],[128,29,128,31],[128,32,128,34],[128,35,128,37],[128,38,128,40],[104,17,104,18],[104,21,104,22],[104,23,104,25],[104,26,104,28],[104,29,104,31],[104,32,104,34],[104,35,104,37],[104,38,104,40],[107,3,109,3],[107,17,107,18],[107,21,107,22],[107,23,107,25],[107,26,107,28],[107,29,107,31],[107,32,107,34],[107,35,107,37],[107,38,107,40],[89,17,89,18],[89,21,89,22],[89,23,89,25],[89,26,89,28],[89,29,89,31],[89,32,89,34],[89,35,89,37],[89,38,89,40],[92,3,94,3],[92,17,92,18],[92,21,92,22],[92,23,92,25],[92,26,92,28],[92,29,92,31],[92,32,92,34],[92,35,92,37],[92,38,92,40],[74,38,74,40],[77,3,79,3],[77,17,77,18],[77,21,77,22],[77,23,77,25],[77,26,77,28],[77,29,77,31],[77,32,77,34],[77,35,77,37],[77,38,77,40],[62,3,64,3],[62,17,62,18],[62,21,62,22],[62,23,62,25],[62,26,62,28],[62,29,62,31],[62,32,62,34],[62,35,62,37],[62,38,62,40],[47,17,47,18],[47,21,47,22],[47,23,47,25],[47,26,47,28],[47,29,47,31],[47,32,47,34],[47,35,47,37],[47,38,47,40],[59,17,59,18],[59,21,59,22],[59,23,59,25],[59,26,59,28],[59,29,59,31],[59,32,59,34],[59,35,59,37],[59,38,59,40],[29,26,29,28],[29,29,29,31],[29,32,29,34],[29,35,29,37],[29,38,29,40],[32,3,34,3],[32,17,32,18],[32,21,32,22],[32,23,32,25],[32,26,32,28],[32,29,32,31],[32,32,32,34],[32,35,32,37],[32,38,32,40],[4,0,4,8],[8,0,9,0],[23,0,24,0],[38,0,39,0],[53,0,54,0],[68,0,69,0],[83,0,84,0],[98,0,99,0],[143,0,144,0],[83,1,83,3],[50,3,52,3],[6,0,7,0],[17,3,19,3],[29,3,31,3],[44,3,46,3],[59,3,61,3],[74,3,76,3],[89,3,91,3],[104,3,106,3],[128,0,129,0],[128,1,128,3],[140,3,142,3],[125,3,127,3],[14,3,16,3],[185,23,185,25],[20,23,20,25],[183,21,183,22],[184,23,184,25],[184,21,184,22],[8,1,8,3],[8,17,8,18],[8,19,8,20],[8,21,8,22],[38,1,38,3],[38,17,38,18],[38,19,38,20],[38,21,38,22],[23,1,23,3],[23,17,23,18],[23,19,23,20],[20,3,22,3],[35,3,37,3],[143,19,143,20],[143,21,143,22],[98,1,98,3],[98,17,98,18],[98,19,98,20],[98,21,98,22],[184,29,184,31],[39,19,39,20],[54,19,54,20],[69,19,69,20],[84,19,84,20],[99,19,99,20],[144,19,144,20],[6,4,7,4],[6,1,7,3],[98,23,98,25],[143,23,143,25],[8,26,8,28],[23,26,23,28],[38,26,38,28],[53,26,53,28],[68,26,68,28],[7,23,7,25],[7,26,7,28],[35,23,35,25],[50,23,50,25],[65,23,65,25],[80,23,80,25],[95,23,95,25],[50,21,50,22],[183,32,183,34],[143,26,143,28],[155,21,155,22],[183,23,183,25],[68,17,68,18],[68,19,68,20],[68,21,68,22],[110,3,112,3],[155,3,157,3],[155,17,155,18],[143,1,143,3],[143,17,143,18],[80,3,82,3],[95,3,97,3],[80,32,80,34],[183,26,183,28],[143,29,143,31],[183,29,183,31],[110,29,110,31],[155,29,155,31],[110,26,110,28],[155,26,155,28],[110,23,110,25],[155,23,155,25],[2,1,2,3],[3,1,3,3],[7,32,7,34],[7,35,7,37],[7,38,7,40],[83,26,83,28],[98,26,98,28],[8,29,8,31],[23,29,23,31],[38,29,38,31],[53,29,53,31],[68,29,68,31],[83,29,83,31],[98,29,98,31],[53,23,53,25],[68,23,68,25],[83,23,83,25],[7,29,7,31],[8,23,8,25],[23,23,23,25],[2,10,2,12],[2,22,2,24],[53,1,53,3],[65,3,67,3],[186,21,186,22],[186,23,186,25],[9,17,9,18],[24,17,24,18],[39,17,39,18],[54,17,54,18],[69,17,69,18],[84,17,84,18],[99,17,99,18],[144,17,144,18],[10,17,10,18],[9,19,9,20],[20,17,20,18],[35,17,35,18],[50,17,50,18],[65,17,65,18],[80,17,80,18],[83,17,83,18],[83,19,83,20],[83,21,83,22],[95,21,95,22],[110,21,110,22],[95,17,95,18],[110,17,110,18],[95,29,95,31],[50,26,50,28],[65,26,65,28],[80,26,80,28],[95,26,95,28],[2,34,2,36],[20,32,20,34],[35,29,35,31],[2,31,2,33],[10,26,10,28],[20,26,20,28],[35,26,35,28],[23,32,23,34],[50,32,50,34],[65,32,65,34],[6,29,6,34],[6,35,6,40],[38,32,38,34],[53,32,53,34],[68,32,68,34],[83,32,83,34],[23,35,23,37],[23,38,23,40],[38,35,38,37],[0,46,0,48],[1,46,2,48],[83,35,83,37],[50,29,50,31],[65,29,65,31],[80,29,80,31],[0,10,0,21],[0,22,0,33],[0,34,0,45],[1,31,1,33],[1,43,1,45],[2,37,2,39],[2,40,2,42],[2,43,2,45],[1,28,1,30],[38,38,38,40],[8,35,8,37],[8,38,8,40],[1,10,1,12],[1,13,1,15],[17,29,17,31],[17,32,17,34],[17,35,17,37],[14,29,14,31],[1,16,1,18],[1,19,1,21],[1,22,1,24],[1,25,1,27],[23,21,23,22],[2,13,2,15],[2,16,2,18],[2,19,2,21],[2,25,2,27],[17,17,17,18],[17,21,17,22],[17,23,17,25],[17,26,17,28],[2,28,2,30],[6,23,6,28],[20,21,20,22],[6,19,6,20],[6,21,6,22],[7,19,7,20],[7,21,7,22],[14,17,14,18],[14,21,14,22],[14,23,14,25],[14,26,14,28],[38,23,38,25],[53,17,53,18],[53,19,53,20],[53,21,53,22],[65,21,65,22],[80,21,80,22],[68,1,68,3],[6,15,7,15],[6,5,7,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11],[6,12,7,12],[6,13,7,13],[6,14,7,14],[29,17,29,18],[29,21,29,22],[29,23,29,25],[44,17,44,18],[44,21,44,22],[44,23,44,25],[110,35,110,37],[110,38,110,40],[155,35,155,37],[155,38,155,40],[53,35,53,37],[1,37,1,39],[1,40,1,42],[1,34,1,36],[8,32,8,34],[110,32,110,34],[155,32,155,34],[98,32,98,34],[143,32,143,34],[20,38,20,40],[35,35,35,37],[35,38,35,40],[50,35,50,37],[50,38,50,40],[65,35,65,37],[65,38,65,40],[80,35,80,37],[80,38,80,40],[17,38,17,40],[140,38,140,40],[183,35,183,37],[95,32,95,34],[20,29,20,31],[183,38,183,40],[184,35,184,37],[185,35,185,37],[186,35,186,37],[6,17,7,18],[6,16,7,16],[53,38,53,40],[68,35,68,37],[68,38,68,40],[98,35,98,37],[98,38,98,40],[83,38,83,40],[24,19,24,20],[35,32,35,34],[143,35,143,37],[143,38,143,40],[185,29,185,31],[186,29,186,31],[20,35,20,37],[95,35,95,37],[95,38,95,40],[9,21,9,22],[24,21,24,22],[39,21,39,22],[54,21,54,22],[69,21,69,22],[84,21,84,22],[99,21,99,22],[114,21,114,22],[129,21,129,22],[35,21,35,22],[74,21,74,22],[11,38,11,40],[26,3,28,3],[26,17,26,18],[26,21,26,22],[26,23,26,25],[26,26,26,28],[26,29,26,31],[26,32,26,34],[26,35,26,37],[26,38,26,40],[11,3,13,3],[11,17,11,18],[11,21,11,22],[11,23,11,25],[11,26,11,28],[11,29,11,31],[11,32,11,34],[11,35,11,37],[14,32,14,34],[14,35,14,37],[14,38,14,40],[41,38,41,40],[56,3,58,3],[56,17,56,18],[56,21,56,22],[56,23,56,25],[56,26,56,28],[56,29,56,31],[56,32,56,34],[56,35,56,37],[56,38,56,40],[41,3,43,3],[41,17,41,18],[41,21,41,22],[41,23,41,25],[41,26,41,28],[41,29,41,31],[41,32,41,34],[41,35,41,37],[44,26,44,28],[44,29,44,31],[44,32,44,34],[44,35,44,37],[44,38,44,40],[47,3,49,3],[71,35,71,37],[71,38,71,40],[86,3,88,3],[86,17,86,18],[86,21,86,22],[86,23,86,25],[86,26,86,28],[86,29,86,31],[86,32,86,34],[86,35,86,37],[86,38,86,40],[71,3,73,3],[71,17,71,18],[71,21,71,22],[71,23,71,25],[71,26,71,28],[71,29,71,31],[71,32,71,34],[74,17,74,18],[74,23,74,25],[74,26,74,28],[74,29,74,31],[74,32,74,34],[74,35,74,37],[101,3,103,3],[101,17,101,18],[101,21,101,22],[101,23,101,25],[101,26,101,28],[101,29,101,31],[101,32,101,34],[101,35,101,37],[101,38,101,40],[116,3,118,3],[116,17,116,18],[116,21,116,22],[116,23,116,25],[116,26,116,28],[116,29,116,31],[116,32,116,34],[116,35,116,37],[116,38,116,40],[131,35,131,37],[131,38,131,40],[146,3,148,3],[146,17,146,18],[146,21,146,22],[146,23,146,25],[146,26,146,28],[146,29,146,31],[146,32,146,34],[146,35,146,37],[146,38,146,40],[144,21,144,22],[137,29,137,31],[137,32,137,34],[137,35,137,37],[137,38,137,40],[137,3,139,3],[137,17,137,18],[137,21,137,22],[137,23,137,25],[137,26,137,28]]}
[{"$f":"\"R\"&試算!D1","v":"R5"},"年度　国保税計算表",null,null,null,null,null,null,null,null,"医　　　療",null,null,null,null,null,null,null,null,null,null,null,"後　　　期",null,null,null,null,null,null,null,null,null,null,null,"介　　　護",null,null,null,null,null,null,null,null,null,null,null,"基礎控除額"]
[null,null,null,null,null,null,null,null,null,null,"所得割",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":"VLOOKUP($A$1,'基本情報（毎年更新）'!$A$3:$N$50,14,0)","v":430000}]
[null,"軽減区分",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($A$1,'基本情報（毎年更新）'!$A$3:$M$50,2,0)","v":0.106},null,null,{"$f":"VLOOKUP($A$1,'基本情報（毎年更新）'!$A$3:$M$50,3,0)","v":29600},null,null,{"$f":"VLOOKUP($A$1,'基本情報（毎年更新）'!$A$3:$M$50,4,0)","v":22000},null,null,{"$f":"VLOOKUP($A$1,'基本情報（毎年更新）'!$A$3:$M$50,5,0)","v":650000},null,null,{"$f":"VLOOKUP($A$1,'基本情報（毎年更新）'!$A$3:$M$50,6,0)","v":3.3000000000000002E-2},null,null,{"$f":"VLOOKUP($A$1,'基本情報（毎年更新）'!$A$3:$M$50,7,0)","v":9300},null,null,{"$f":"VLOOKUP($A$1,'基本情報（毎年更新）'!$A$3:$M$50,8,0)","v":6900},null,null,{"$f":"VLOOKUP($A$1,'基本情報（毎年更新）'!$A$3:$M$50,9,0)","v":220000},null,null,{"$f":"VLOOKUP($A$1,'基本情報（毎年更新）'!$A$3:$M$50,10,0)","v":2.7E-2},null,null,{"$f":"VLOOKUP($A$1,'基本情報（毎年更新）'!$A$3:$M$50,11,0)","v":14900},null,null,{"$f":"VLOOKUP($A$1,'基本情報（毎年更新）'!$A$3:$M$50,12,0)","v":0},null,null,{"$f":"VLOOKUP($A$1,'基本情報（毎年更新）'!$A$3:$M$50,13,0)","v":170000},null,null,{"$f":"VLOOKUP($A$1,'基本情報（毎年更新）'!$A$3:$M$11,13,0)","v":170000}]
[null,{"$f":"軽減計算!J18","v":7}]
["医療欄の入力は以下の番号で入力\n（介護欄はすべて「１」で入力）\n１：主　２：擬主　３：員　４：擬同\n５：同　６：擬継　７：継　８：旧被扶\n※４～７は特定同一世帯に該当する場合のみ入力！"]
[null,null,null,null,"軽減",{"$f":"$B$4","v":7},{"$f":"$B$4","v":7},7,7,7,7,7,7,7,7,7,7]
["No.","所得額\n（基礎控除前）",null,null,null,4,5,6,7,8,9,10,11,12,1,2,3,"加入\n月数",null,"同",null,"旧被扶",null,"医療分",null,null,null,null,null,"後期分",null,null,null,null,null,"介護分"]
[null,null,null,null,null,4,5,6,7,8,9,10,11,12,1,null,null,null,null,"継",null,"未就学",null,"所得割",null,null,"均等割",null,null,"所得割",null,null,"均等割",null,null,"所得割",null,null,"均等割"]
[1,{"$f":"給与所得計算!F26+年金所得計算!D74+試算!AV25","v":0},null,null,"医療",{"$f":"IF(加入情報!K7=0,\"\",加入情報!K7)","v":2},{"$f":"IF(加入情報!L7=0,\"\",加入情報!L7)","v":2},{"$f":"IF(加入情報!M7=0,\"\",加入情報!M7)","v":2},{"$f":"IF(加入情報!N7=0,\"\",加入情報!N7)","v":2},{"$f":"IF(加入情報!O7=0,\"\",加入情報!O7)","v":2},{"$f":"IF(加入情報!P7=0,\"\",加入情報!P7)","v":2},{"$f":"IF(加入情報!Q7=0,\"\",加入情報!Q7)","v":2},{"$f":"IF(加入情報!R7=0,\"\",加入情報!R7)","v":2},{"$f":"IF(加入情報!S7=0,\"\",加入情報!S7)","v":2},{"$f":"IF(加入情報!T7=0,\"\",加入情報!T7)","v":2},{"$f":"IF(加入情報!U7=0,\"\",加入情報!U7)","v":2},{"$f":"IF(加入情報!V7=0,\"\",加入情報!V7)","v":2},{"$f":"COUNTIF(F9:Q9,1)+COUNTIF(F9:Q9,3)+COUNTIF(F9:Q9,8)","v":0},null,{"$f":"COUNTIF(F9:Q9,4)+COUNTIF(F9:Q9,5)","v":0},null,{"$f":"COUNTIF(F9:Q9,8)","v":0},null,{"$f":"IF($R9=0,0,($R9-$V9)/$R9*$X21*$R9/12)","v":0},null,null,{"$f":"SUM(F18:Q18)+SUM(F15:Q15)","v":0},null,null,{"$f":"IF($R9=0,0,($R9-$V9)/$R9*AD21*$R9/12)","v":0},null,null,{"$f":"SUM(F19:Q19)+SUM(F16:Q16)","v":0},null,null,{"$f":"AJ21*$R10/12","v":0},null,null,{"$f":"SUM(F20:Q20)","v":0}]
[null,null,null,null,"介護",{"$f":"IFERROR(IF(AND(F9=1,加入情報!K9<65,加入情報!K9>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(G9=1,加入情報!L9<65,加入情報!L9>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(H9=1,加入情報!M9<65,加入情報!M9>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(I9=1,加入情報!N9<65,加入情報!N9>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(J9=1,加入情報!O9<65,加入情報!O9>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(K9=1,加入情報!P9<65,加入情報!P9>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(L9=1,加入情報!Q9<65,加入情報!Q9>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(M9=1,加入情報!R9<65,加入情報!R9>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(N9=1,加入情報!S9<65,加入情報!S9>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(O9=1,加入情報!T9<65,加入情報!T9>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(P9=1,加入情報!U9<65,加入情報!U9>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(Q9=1,加入情報!V9<65,加入情報!V9>=40),1,\"\"),\"\")","v":""},{"$f":"SUBTOTAL(9,F10:Q10)","v":0},null,{"$f":"COUNTIF(F9:Q9,6)+COUNTIF(F9:Q9,7)","v":0},null,{"$f":"IF(加入情報!V9<7,1,0)","v":0}]
[null,null,null,null,"特定"]
[null,null,null,"予備","医療"]
[null,null,null,null,"後期"]
[null,null,null,null,"介護"]
[null,null,null,"未就学軽減","医療",{"$f":"IF($V10=1,IF(OR(F9=1,F9=3),-$N$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V10=1,IF(OR(G9=1,G9=3),-$N$3/12*(1-G$6/10)/2,0),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF($V10=1,IF(OR(F9=1,F9=3),-$Z$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V10=1,IF(OR(G9=1,G9=3),-$Z$3/12*(1-G$6/10)/2,0),0)","v":0},{"$f":"IF($V10=1,IF(OR(H9=1,H9=3),-$Z$3/12*(1-H$6/10)/2,0),0)","v":0},0,0,0,0,0,0,0,{"$f":"IF($V10=1,IF(OR(P9=1,P9=3),-$Z$3/12*(1-P$6/10)/2,0),0)","v":0},0]
[null,null,null,null,"介護"]
[null,null,null,"均等割用","医療",{"$f":"IF(OR(F9=1,F9=3),$N$3/12*(1-F$6/10),IF(AND(F9=8,F$6<5),$N$3/12*0.5,IF(F9=8,$N$3/12*(1-F$6/10),0)))","v":0},{"$f":"IF(OR(G9=1,G9=3),$N$3/12*(1-G$6/10),IF(AND(G9=8,G$6<5),$N$3/12*0.5,IF(G9=8,$N$3/12*(1-G$6/10),0)))","v":0},{"$f":"IF(OR(H9=1,H9=3),$N$3/12*(1-H$6/10),IF(AND(H9=8,H$6<5),$N$3/12*0.5,IF(H9=8,$N$3/12*(1-H$6/10),0)))","v":0},0,0,{"$f":"IF(OR(K9=1,K9=3),$N$3/12*(1-K$6/10),IF(AND(K9=8,K$6<5),$N$3/12*0.5,IF(K9=8,$N$3/12*(1-K$6/10),0)))","v":0},{"$f":"IF(OR(L9=1,L9=3),$N$3/12*(1-L$6/10),IF(AND(L9=8,L$6<5),$N$3/12*0.5,IF(L9=8,$N$3/12*(1-L$6/10),0)))","v":0},0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF(OR(F9=1,F9=3),$Z$3/12*(1-F$6/10),IF(AND(F9=8,F$6<5),$Z$3/12*0.5,IF(F9=8,$Z$3/12*(1-F$6/10),0)))","v":0},{"$f":"IF(OR(G9=1,G9=3),$Z$3/12*(1-G$6/10),IF(AND(G9=8,G$6<5),$Z$3/12*0.5,IF(G9=8,$Z$3/12*(1-G$6/10),0)))","v":0},{"$f":"IF(OR(H9=1,H9=3),$Z$3/12*(1-H$6/10),IF(AND(H9=8,H$6<5),$Z$3/12*0.5,IF(H9=8,$Z$3/12*(1-H$6/10),0)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"介護",{"$f":"IF(F10=1,$AL$3/12*(1-F$6/10),0)","v":0},{"$f":"IF(G10=1,$AL$3/12*(1-G$6/10),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"限度額用","医療",{"$f":"IF(OR(F9=1,F9=3,F9=8),$X21+$AA21,0)","v":0},{"$f":"IF(OR(G9=1,G9=3,G9=8),$X21+$AA21,0)","v":0},{"$f":"IF(OR(H9=1,H9=3,H9=8),$X21+$AA21,0)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,"限度額判定用",null,{"$f":"IF(B9-$AU$2>0,ROUNDDOWN((B9-$AU$2)*$K$3,0),0)","v":0},null,null,{"$f":"IF(V10=0,$N$3*(1-0.1*$B$4),$N$3*(1-0.1*$B$4)/2)","v":8879.9999999999982},null,null,{"$f":"IF($B9-$AU$2>0,ROUNDDOWN(($B9-$AU$2)*$W$3,0),0)","v":0},null,null,{"$f":"IF(V10=0,$Z$3*(1-0.1*$B$4),$Z$3*(1-0.1*$B$4)/2)","v":2789.9999999999995},null,null,{"$f":"IF($B9-$AU$2>0,ROUNDDOWN(($B9-$AU$2)*$AI$3,0),0)","v":0},null,null,{"$f":"IF(V10=0,$AL$3*(1-0.1*$B$4),$AL$3*(1-0.1*$B$4)/2)","v":4469.9999999999991}]
[null,null,null,null,"後期",{"$f":"IF(OR(F9=1,F9=3,F9=8),$AD21+$AG21,0)","v":0},{"$f":"IF(OR(G9=1,G9=3,G9=8),$AD21+$AG21,0)","v":0},{"$f":"IF(OR(H9=1,H9=3,H9=8),$AD21+$AG21,0)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"介護",{"$f":"IF(F10=1,$AJ21+$AM21,0)","v":0},{"$f":"IF(G10=1,$AJ21+$AM21,0)","v":0},{"$f":"IF(H10=1,$AJ21+$AM21,0)","v":0},0,0,0,0,0,0,0,0,0]
[2,{"$f":"給与所得計算!F27+年金所得計算!D75+試算!AV27","v":0},null,null,"医療",{"$f":"IF(加入情報!K10=0,\"\",加入情報!K10)","v":""},{"$f":"IF(加入情報!L10=0,\"\",加入情報!L10)","v":""},{"$f":"IF(加入情報!M10=0,\"\",加入情報!M10)","v":""},{"$f":"IF(加入情報!N10=0,\"\",加入情報!N10)","v":""},{"$f":"IF(加入情報!O10=0,\"\",加入情報!O10)","v":""},{"$f":"IF(加入情報!P10=0,\"\",加入情報!P10)","v":""},{"$f":"IF(加入情報!Q10=0,\"\",加入情報!Q10)","v":""},{"$f":"IF(加入情報!R10=0,\"\",加入情報!R10)","v":""},{"$f":"IF(加入情報!S10=0,\"\",加入情報!S10)","v":""},{"$f":"IF(加入情報!T10=0,\"\",加入情報!T10)","v":""},{"$f":"IF(加入情報!U10=0,\"\",加入情報!U10)","v":""},{"$f":"IF(加入情報!V10=0,\"\",加入情報!V10)","v":""},{"$f":"COUNTIF(F24:Q24,1)+COUNTIF(F24:Q24,3)+COUNTIF(F24:Q24,8)","v":0},null,{"$f":"COUNTIF(F24:Q24,4)+COUNTIF(F24:Q24,5)","v":0},null,{"$f":"COUNTIF(F24:Q24,8)","v":0},null,{"$f":"IF($R24=0,0,($R24-$V24)/$R24*$X36*$R24/12)","v":0},null,null,{"$f":"SUM(F33:Q33)+SUM(F30:Q30)","v":0},null,null,{"$f":"IF($R24=0,0,($R24-$V24)/$R24*AD36*$R24/12)","v":0},null,null,{"$f":"SUM(F34:Q34)+SUM(F31:Q31)","v":0},null,null,{"$f":"AJ36*$R25/12","v":0},null,null,{"$f":"SUM(F35:Q35)","v":0}]
[null,null,null,null,"介護",{"$f":"IFERROR(IF(AND(F24=3,加入情報!K12<65,加入情報!K12>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(G24=3,加入情報!L12<65,加入情報!L12>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(H24=3,加入情報!M12<65,加入情報!M12>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(I24=3,加入情報!N12<65,加入情報!N12>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(J24=3,加入情報!O12<65,加入情報!O12>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(K24=3,加入情報!P12<65,加入情報!P12>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(L24=3,加入情報!Q12<65,加入情報!Q12>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(M24=3,加入情報!R12<65,加入情報!R12>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(N24=3,加入情報!S12<65,加入情報!S12>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(O24=3,加入情報!T12<65,加入情報!T12>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(P24=3,加入情報!U12<65,加入情報!U12>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(Q24=3,加入情報!V12<65,加入情報!V12>=40),1,\"\"),\"\")","v":""},{"$f":"SUBTOTAL(9,F25:Q25)","v":0},null,{"$f":"COUNTIF(F24:Q24,6)+COUNTIF(F24:Q24,7)","v":0},null,{"$f":"IF(加入情報!V12<7,1,0)","v":0}]
[null,null,null,null,"特定"]
[null,null,null,"予備","医療"]
[null,null,null,null,"後期"]
[null,null,null,null,"介護"]
[null,null,null,"未就学軽減","医療",{"$f":"IF($V25=1,IF(OR(F24=1,F24=3),-$N$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V25=1,IF(OR(G24=1,G24=3),-$N$3/12*(1-G$6/10)/2,0),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF($V25=1,IF(OR(F24=1,F24=3),-$Z$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V25=1,IF(OR(G24=1,G24=3),-$Z$3/12*(1-G$6/10)/2,0),0)","v":0},{"$f":"IF($V25=1,IF(OR(H24=1,H24=3),-$Z$3/12*(1-H$6/10)/2,0),0)","v":0},{"$f":"IF($V25=1,IF(OR(I24=1,I24=3),-$Z$3/12*(1-I$6/10)/2,0),0)","v":0},0,0,0,0,0,0,{"$f":"IF($V25=1,IF(OR(P24=1,P24=3),-$Z$3/12*(1-P$6/10)/2,0),0)","v":0},{"$f":"IF($V25=1,IF(OR(Q24=1,Q24=3),-$Z$3/12*(1-Q$6/10)/2,0),0)","v":0}]
[null,null,null,null,"介護"]
[null,null,null,"均等割用","医療",{"$f":"IF(OR(F24=1,F24=3),$N$3/12*(1-F$6/10),IF(AND(F24=8,F$6<5),$N$3/12*0.5,IF(F24=8,$N$3/12*(1-F$6/10),0)))","v":0},{"$f":"IF(OR(G24=1,G24=3),$N$3/12*(1-G$6/10),IF(AND(G24=8,G$6<5),$N$3/12*0.5,IF(G24=8,$N$3/12*(1-G$6/10),0)))","v":0},{"$f":"IF(OR(H24=1,H24=3),$N$3/12*(1-H$6/10),IF(AND(H24=8,H$6<5),$N$3/12*0.5,IF(H24=8,$N$3/12*(1-H$6/10),0)))","v":0},{"$f":"IF(OR(I24=1,I24=3),$N$3/12*(1-I$6/10),IF(AND(I24=8,I$6<5),$N$3/12*0.5,IF(I24=8,$N$3/12*(1-I$6/10),0)))","v":0},0,{"$f":"IF(OR(K24=1,K24=3),$N$3/12*(1-K$6/10),IF(AND(K24=8,K$6<5),$N$3/12*0.5,IF(K24=8,$N$3/12*(1-K$6/10),0)))","v":0},{"$f":"IF(OR(L24=1,L24=3),$N$3/12*(1-L$6/10),IF(AND(L24=8,L$6<5),$N$3/12*0.5,IF(L24=8,$N$3/12*(1-L$6/10),0)))","v":0},0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF(OR(F24=1,F24=3),$Z$3/12*(1-F$6/10),IF(AND(F24=8,F$6<5),$Z$3/12*0.5,IF(F24=8,$Z$3/12*(1-F$6/10),0)))","v":0},{"$f":"IF(OR(G24=1,G24=3),$Z$3/12*(1-G$6/10),IF(AND(G24=8,G$6<5),$Z$3/12*0.5,IF(G24=8,$Z$3/12*(1-G$6/10),0)))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"介護",{"$f":"IF(F25=1,$AL$3/12*(1-F$6/10),0)","v":0},{"$f":"IF(G25=1,$AL$3/12*(1-G$6/10),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"限度額用","医療",{"$f":"IF(OR(F24=1,F24=3,F24=8),$X36+$AA36,0)","v":0},{"$f":"IF(OR(G24=1,G24=3,G24=8),$X36+$AA36,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,"限度額判定用",null,{"$f":"IF(B24-$AU$2>0,ROUNDDOWN((B24-$AU$2)*$K$3,0),0)","v":0},null,null,{"$f":"IF(V25=0,$N$3*(1-0.1*$B$4),$N$3*(1-0.1*$B$4)/2)","v":8879.9999999999982},null,null,{"$f":"IF($B24-$AU$2>0,ROUNDDOWN(($B24-$AU$2)*$W$3,0),0)","v":0},null,null,{"$f":"IF(V25=0,$Z$3*(1-0.1*$B$4),$Z$3*(1-0.1*$B$4)/2)","v":2789.9999999999995},null,null,{"$f":"IF($B24-$AU$2>0,ROUNDDOWN(($B24-$AU$2)*$AI$3,0),0)","v":0},null,null,{"$f":"IF(V25=0,$AL$3*(1-0.1*$B$4),$AL$3*(1-0.1*$B$4)/2)","v":4469.9999999999991}]
[null,null,null,null,"後期",{"$f":"IF(OR(F24=1,F24=3,F24=8),$AD36+$AG36,0)","v":0},{"$f":"IF(OR(G24=1,G24=3,G24=8),$AD36+$AG36,0)","v":0},{"$f":"IF(OR(H24=1,H24=3,H24=8),$AD36+$AG36,0)","v":0},{"$f":"IF(OR(I24=1,I24=3,I24=8),$AD36+$AG36,0)","v":0},{"$f":"IF(OR(J24=1,J24=3,J24=8),$AD36+$AG36,0)","v":0},{"$f":"IF(OR(K24=1,K24=3,K24=8),$AD36+$AG36,0)","v":0},{"$f":"IF(OR(L24=1,L24=3,L24=8),$AD36+$AG36,0)","v":0},{"$f":"IF(OR(M24=1,M24=3,M24=8),$AD36+$AG36,0)","v":0},{"$f":"IF(OR(N24=1,N24=3,N24=8),$AD36+$AG36,0)","v":0},{"$f":"IF(OR(O24=1,O24=3,O24=8),$AD36+$AG36,0)","v":0},{"$f":"IF(OR(P24=1,P24=3,P24=8),$AD36+$AG36,0)","v":0},{"$f":"IF(OR(Q24=1,Q24=3,Q24=8),$AD36+$AG36,0)","v":0}]
[null,null,null,null,"介護",{"$f":"IF(F25=1,$AJ36+$AM36,0)","v":0},{"$f":"IF(G25=1,$AJ36+$AM36,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[3,{"$f":"給与所得計算!F28+年金所得計算!D76+試算!AV29","v":0},null,null,"医療",{"$f":"IF(加入情報!K13=0,\"\",加入情報!K13)","v":""},{"$f":"IF(加入情報!L13=0,\"\",加入情報!L13)","v":""},{"$f":"IF(加入情報!M13=0,\"\",加入情報!M13)","v":""},{"$f":"IF(加入情報!N13=0,\"\",加入情報!N13)","v":""},{"$f":"IF(加入情報!O13=0,\"\",加入情報!O13)","v":""},{"$f":"IF(加入情報!P13=0,\"\",加入情報!P13)","v":""},{"$f":"IF(加入情報!Q13=0,\"\",加入情報!Q13)","v":""},{"$f":"IF(加入情報!R13=0,\"\",加入情報!R13)","v":""},{"$f":"IF(加入情報!S13=0,\"\",加入情報!S13)","v":""},{"$f":"IF(加入情報!T13=0,\"\",加入情報!T13)","v":""},{"$f":"IF(加入情報!U13=0,\"\",加入情報!U13)","v":""},{"$f":"IF(加入情報!V13=0,\"\",加入情報!V13)","v":""},{"$f":"COUNTIF(F39:Q39,1)+COUNTIF(F39:Q39,3)+COUNTIF(F39:Q39,8)","v":0},null,{"$f":"COUNTIF(F39:Q39,4)+COUNTIF(F39:Q39,5)","v":0},null,{"$f":"COUNTIF(F39:Q39,8)","v":0},null,{"$f":"IF($R39=0,0,($R39-$V39)/$R39*$X51*$R39/12)","v":0},null,null,{"$f":"SUM(F48:Q48)+SUM(F45:Q45)","v":0},null,null,{"$f":"IF($R39=0,0,($R39-$V39)/$R39*AD51*$R39/12)","v":0},null,null,{"$f":"SUM(F49:Q49)+SUM(F46:Q46)","v":0},null,null,{"$f":"AJ51*$R40/12","v":0},null,null,{"$f":"SUM(F50:Q50)","v":0}]
[null,null,null,null,"介護",{"$f":"IFERROR(IF(AND(F39=3,加入情報!K15<65,加入情報!K15>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(G39=3,加入情報!L15<65,加入情報!L15>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(H39=3,加入情報!M15<65,加入情報!M15>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(I39=3,加入情報!N15<65,加入情報!N15>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(J39=3,加入情報!O15<65,加入情報!O15>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(K39=3,加入情報!P15<65,加入情報!P15>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(L39=3,加入情報!Q15<65,加入情報!Q15>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(M39=3,加入情報!R15<65,加入情報!R15>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(N39=3,加入情報!S15<65,加入情報!S15>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(O39=3,加入情報!T15<65,加入情報!T15>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(P39=3,加入情報!U15<65,加入情報!U15>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(Q39=3,加入情報!V15<65,加入情報!V15>=40),1,\"\"),\"\")","v":""},{"$f":"SUBTOTAL(9,F40:Q40)","v":0},null,{"$f":"COUNTIF(F39:Q39,6)+COUNTIF(F39:Q39,7)","v":0},null,{"$f":"IF(加入情報!V15<7,1,0)","v":0}]
[null,null,null,null,"特定"]
[null,null,null,"予備","医療"]
[null,null,null,null,"後期"]
[null,null,null,null,"介護"]
[null,null,null,"未就学軽減","医療",{"$f":"IF($V40=1,IF(OR(F39=1,F39=3),-$N$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V40=1,IF(OR(G39=1,G39=3),-$N$3/12*(1-G$6/10)/2,0),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF($V40=1,IF(OR(F39=1,F39=3),-$Z$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V40=1,IF(OR(G39=1,G39=3),-$Z$3/12*(1-G$6/10)/2,0),0)","v":0},{"$f":"IF($V40=1,IF(OR(H39=1,H39=3),-$Z$3/12*(1-H$6/10)/2,0),0)","v":0},{"$f":"IF($V40=1,IF(OR(I39=1,I39=3),-$Z$3/12*(1-I$6/10)/2,0),0)","v":0},0,0,0,0,0,0,{"$f":"IF($V40=1,IF(OR(P39=1,P39=3),-$Z$3/12*(1-P$6/10)/2,0),0)","v":0},{"$f":"IF($V40=1,IF(OR(Q39=1,Q39=3),-$Z$3/12*(1-Q$6/10)/2,0),0)","v":0}]
[null,null,null,null,"介護"]
[null,null,null,"均等割用","医療",{"$f":"IF(OR(F39=1,F39=3),$N$3/12*(1-F$6/10),IF(AND(F39=8,F$6<5),$N$3/12*0.5,IF(F39=8,$N$3/12*(1-F$6/10),0)))","v":0},0,{"$f":"IF(OR(H39=1,H39=3),$N$3/12*(1-H$6/10),IF(AND(H39=8,H$6<5),$N$3/12*0.5,IF(H39=8,$N$3/12*(1-H$6/10),0)))","v":0},{"$f":"IF(OR(I39=1,I39=3),$N$3/12*(1-I$6/10),IF(AND(I39=8,I$6<5),$N$3/12*0.5,IF(I39=8,$N$3/12*(1-I$6/10),0)))","v":0},0,{"$f":"IF(OR(K39=1,K39=3),$N$3/12*(1-K$6/10),IF(AND(K39=8,K$6<5),$N$3/12*0.5,IF(K39=8,$N$3/12*(1-K$6/10),0)))","v":0},{"$f":"IF(OR(L39=1,L39=3),$N$3/12*(1-L$6/10),IF(AND(L39=8,L$6<5),$N$3/12*0.5,IF(L39=8,$N$3/12*(1-L$6/10),0)))","v":0},0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF(OR(F39=1,F39=3),$Z$3/12*(1-F$6/10),IF(AND(F39=8,F$6<5),$Z$3/12*0.5,IF(F39=8,$Z$3/12*(1-F$6/10),0)))","v":0},{"$f":"IF(OR(G39=1,G39=3),$Z$3/12*(1-G$6/10),IF(AND(G39=8,G$6<5),$Z$3/12*0.5,IF(G39=8,$Z$3/12*(1-G$6/10),0)))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"介護",{"$f":"IF(F40=1,$AL$3/12*(1-F$6/10),0)","v":0},{"$f":"IF(G40=1,$AL$3/12*(1-G$6/10),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"限度額用","医療",{"$f":"IF(OR(F39=1,F39=3,F39=8),$X51+$AA51,0)","v":0},{"$f":"IF(OR(G39=1,G39=3,G39=8),$X51+$AA51,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,"限度額判定用",null,{"$f":"IF(B39-$AU$2>0,ROUNDDOWN((B39-$AU$2)*$K$3,0),0)","v":0},null,null,{"$f":"IF(V40=0,$N$3*(1-0.1*$B$4),$N$3*(1-0.1*$B$4)/2)","v":8879.9999999999982},null,null,{"$f":"IF($B39-$AU$2>0,ROUNDDOWN(($B39-$AU$2)*$W$3,0),0)","v":0},null,null,{"$f":"IF(V40=0,$Z$3*(1-0.1*$B$4),$Z$3*(1-0.1*$B$4)/2)","v":2789.9999999999995},null,null,{"$f":"IF($B39-$AU$2>0,ROUNDDOWN(($B39-$AU$2)*$AI$3,0),0)","v":0},null,null,{"$f":"IF(V40=0,$AL$3*(1-0.1*$B$4),$AL$3*(1-0.1*$B$4)/2)","v":4469.9999999999991}]
[null,null,null,null,"後期",{"$f":"IF(OR(F39=1,F39=3,F39=8),$AD51+$AG51,0)","v":0},{"$f":"IF(OR(G39=1,G39=3,G39=8),$AD51+$AG51,0)","v":0},{"$f":"IF(OR(H39=1,H39=3,H39=8),$AD51+$AG51,0)","v":0},{"$f":"IF(OR(I39=1,I39=3,I39=8),$AD51+$AG51,0)","v":0},{"$f":"IF(OR(J39=1,J39=3,J39=8),$AD51+$AG51,0)","v":0},{"$f":"IF(OR(K39=1,K39=3,K39=8),$AD51+$AG51,0)","v":0},{"$f":"IF(OR(L39=1,L39=3,L39=8),$AD51+$AG51,0)","v":0},{"$f":"IF(OR(M39=1,M39=3,M39=8),$AD51+$AG51,0)","v":0},{"$f":"IF(OR(N39=1,N39=3,N39=8),$AD51+$AG51,0)","v":0},{"$f":"IF(OR(O39=1,O39=3,O39=8),$AD51+$AG51,0)","v":0},{"$f":"IF(OR(P39=1,P39=3,P39=8),$AD51+$AG51,0)","v":0},{"$f":"IF(OR(Q39=1,Q39=3,Q39=8),$AD51+$AG51,0)","v":0}]
[null,null,null,null,"介護",{"$f":"IF(F40=1,$AJ51+$AM51,0)","v":0},{"$f":"IF(G40=1,$AJ51+$AM51,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[4,{"$f":"給与所得計算!F29+年金所得計算!D77+試算!AV31","v":0},null,null,"医療",{"$f":"IF(加入情報!K16=0,\"\",加入情報!K16)","v":""},{"$f":"IF(加入情報!L16=0,\"\",加入情報!L16)","v":""},{"$f":"IF(加入情報!M16=0,\"\",加入情報!M16)","v":""},{"$f":"IF(加入情報!N16=0,\"\",加入情報!N16)","v":""},{"$f":"IF(加入情報!O16=0,\"\",加入情報!O16)","v":""},{"$f":"IF(加入情報!P16=0,\"\",加入情報!P16)","v":""},{"$f":"IF(加入情報!Q16=0,\"\",加入情報!Q16)","v":""},{"$f":"IF(加入情報!R16=0,\"\",加入情報!R16)","v":""},{"$f":"IF(加入情報!S16=0,\"\",加入情報!S16)","v":""},{"$f":"IF(加入情報!T16=0,\"\",加入情報!T16)","v":""},{"$f":"IF(加入情報!U16=0,\"\",加入情報!U16)","v":""},{"$f":"IF(加入情報!V16=0,\"\",加入情報!V16)","v":""},{"$f":"COUNTIF(F54:Q54,1)+COUNTIF(F54:Q54,3)+COUNTIF(F54:Q54,8)","v":0},null,{"$f":"COUNTIF(F54:Q54,4)+COUNTIF(F54:Q54,5)","v":0},null,{"$f":"COUNTIF(F54:Q54,8)","v":0},null,{"$f":"IF($R54=0,0,($R54-$V54)/$R54*$X66*$R54/12)","v":0},null,null,{"$f":"SUM(F63:Q63)+SUM(F60:Q60)","v":0},null,null,{"$f":"IF($R54=0,0,($R54-$V54)/$R54*AD66*$R54/12)","v":0},null,null,{"$f":"SUM(F64:Q64)+SUM(F61:Q61)","v":0},null,null,{"$f":"AJ66*$R55/12","v":0},null,null,{"$f":"SUM(F65:Q65)","v":0}]
[null,null,null,null,"介護",{"$f":"IFERROR(IF(AND(F54=3,加入情報!K18<65,加入情報!K18>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(G54=3,加入情報!L18<65,加入情報!L18>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(H54=3,加入情報!M18<65,加入情報!M18>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(I54=3,加入情報!N18<65,加入情報!N18>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(J54=3,加入情報!O18<65,加入情報!O18>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(K54=3,加入情報!P18<65,加入情報!P18>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(L54=3,加入情報!Q18<65,加入情報!Q18>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(M54=3,加入情報!R18<65,加入情報!R18>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(N54=3,加入情報!S18<65,加入情報!S18>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(O54=3,加入情報!T18<65,加入情報!T18>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(P54=3,加入情報!U18<65,加入情報!U18>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(Q54=3,加入情報!V18<65,加入情報!V18>=40),1,\"\"),\"\")","v":""},{"$f":"SUBTOTAL(9,F55:Q55)","v":0},null,{"$f":"COUNTIF(F54:Q54,6)+COUNTIF(F54:Q54,7)","v":0},null,{"$f":"IF(加入情報!V18<7,1,0)","v":0}]
[null,null,null,null,"特定"]
[null,null,null,"予備","医療"]
[null,null,null,null,"後期"]
[null,null,null,null,"介護"]
[null,null,null,"未就学軽減","医療",{"$f":"IF($V55=1,IF(OR(F54=1,F54=3),-$N$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V55=1,IF(OR(G54=1,G54=3),-$N$3/12*(1-G$6/10)/2,0),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF($V55=1,IF(OR(F54=1,F54=3),-$Z$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V55=1,IF(OR(G54=1,G54=3),-$Z$3/12*(1-G$6/10)/2,0),0)","v":0},{"$f":"IF($V55=1,IF(OR(H54=1,H54=3),-$Z$3/12*(1-H$6/10)/2,0),0)","v":0},{"$f":"IF($V55=1,IF(OR(I54=1,I54=3),-$Z$3/12*(1-I$6/10)/2,0),0)","v":0},0,0,0,0,0,0,{"$f":"IF($V55=1,IF(OR(P54=1,P54=3),-$Z$3/12*(1-P$6/10)/2,0),0)","v":0},{"$f":"IF($V55=1,IF(OR(Q54=1,Q54=3),-$Z$3/12*(1-Q$6/10)/2,0),0)","v":0}]
[null,null,null,null,"介護"]
[null,null,null,"均等割用","医療",{"$f":"IF(OR(F54=1,F54=3),$N$3/12*(1-F$6/10),IF(AND(F54=8,F$6<5),$N$3/12*0.5,IF(F54=8,$N$3/12*(1-F$6/10),0)))","v":0},0,{"$f":"IF(OR(H54=1,H54=3),$N$3/12*(1-H$6/10),IF(AND(H54=8,H$6<5),$N$3/12*0.5,IF(H54=8,$N$3/12*(1-H$6/10),0)))","v":0},{"$f":"IF(OR(I54=1,I54=3),$N$3/12*(1-I$6/10),IF(AND(I54=8,I$6<5),$N$3/12*0.5,IF(I54=8,$N$3/12*(1-I$6/10),0)))","v":0},0,{"$f":"IF(OR(K54=1,K54=3),$N$3/12*(1-K$6/10),IF(AND(K54=8,K$6<5),$N$3/12*0.5,IF(K54=8,$N$3/12*(1-K$6/10),0)))","v":0},{"$f":"IF(OR(L54=1,L54=3),$N$3/12*(1-L$6/10),IF(AND(L54=8,L$6<5),$N$3/12*0.5,IF(L54=8,$N$3/12*(1-L$6/10),0)))","v":0},0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF(OR(F54=1,F54=3),$Z$3/12*(1-F$6/10),IF(AND(F54=8,F$6<5),$Z$3/12*0.5,IF(F54=8,$Z$3/12*(1-F$6/10),0)))","v":0},{"$f":"IF(OR(G54=1,G54=3),$Z$3/12*(1-G$6/10),IF(AND(G54=8,G$6<5),$Z$3/12*0.5,IF(G54=8,$Z$3/12*(1-G$6/10),0)))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"介護",{"$f":"IF(F55=1,$AL$3/12*(1-F$6/10),0)","v":0},{"$f":"IF(G55=1,$AL$3/12*(1-G$6/10),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"限度額用","医療",{"$f":"IF(OR(F54=1,F54=3,F54=8),$X66+$AA66,0)","v":0},{"$f":"IF(OR(G54=1,G54=3,G54=8),$X66+$AA66,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,"限度額判定用",null,{"$f":"IF(B54-$AU$2>0,ROUNDDOWN((B54-$AU$2)*$K$3,0),0)","v":0},null,null,{"$f":"IF(V55=0,$N$3*(1-0.1*$B$4),$N$3*(1-0.1*$B$4)/2)","v":8879.9999999999982},null,null,{"$f":"IF($B54-$AU$2>0,ROUNDDOWN(($B54-$AU$2)*$W$3,0),0)","v":0},null,null,{"$f":"IF(V55=0,$Z$3*(1-0.1*$B$4),$Z$3*(1-0.1*$B$4)/2)","v":2789.9999999999995},null,null,{"$f":"IF($B54-$AU$2>0,ROUNDDOWN(($B54-$AU$2)*$AI$3,0),0)","v":0},null,null,{"$f":"IF(V55=0,$AL$3*(1-0.1*$B$4),$AL$3*(1-0.1*$B$4)/2)","v":4469.9999999999991}]
[null,null,null,null,"後期",{"$f":"IF(OR(F54=1,F54=3,F54=8),$AD66+$AG66,0)","v":0},{"$f":"IF(OR(G54=1,G54=3,G54=8),$AD66+$AG66,0)","v":0},{"$f":"IF(OR(H54=1,H54=3,H54=8),$AD66+$AG66,0)","v":0},{"$f":"IF(OR(I54=1,I54=3,I54=8),$AD66+$AG66,0)","v":0},{"$f":"IF(OR(J54=1,J54=3,J54=8),$AD66+$AG66,0)","v":0},{"$f":"IF(OR(K54=1,K54=3,K54=8),$AD66+$AG66,0)","v":0},{"$f":"IF(OR(L54=1,L54=3,L54=8),$AD66+$AG66,0)","v":0},{"$f":"IF(OR(M54=1,M54=3,M54=8),$AD66+$AG66,0)","v":0},{"$f":"IF(OR(N54=1,N54=3,N54=8),$AD66+$AG66,0)","v":0},{"$f":"IF(OR(O54=1,O54=3,O54=8),$AD66+$AG66,0)","v":0},{"$f":"IF(OR(P54=1,P54=3,P54=8),$AD66+$AG66,0)","v":0},{"$f":"IF(OR(Q54=1,Q54=3,Q54=8),$AD66+$AG66,0)","v":0}]
[null,null,null,null,"介護",{"$f":"IF(F55=1,$AJ66+$AM66,0)","v":0},{"$f":"IF(G55=1,$AJ66+$AM66,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[5,{"$f":"給与所得計算!F30+年金所得計算!D78+試算!AV33","v":0},null,null,"医療",{"$f":"IF(加入情報!K19=0,\"\",加入情報!K19)","v":""},{"$f":"IF(加入情報!L19=0,\"\",加入情報!L19)","v":""},{"$f":"IF(加入情報!M19=0,\"\",加入情報!M19)","v":""},{"$f":"IF(加入情報!N19=0,\"\",加入情報!N19)","v":""},{"$f":"IF(加入情報!O19=0,\"\",加入情報!O19)","v":""},{"$f":"IF(加入情報!P19=0,\"\",加入情報!P19)","v":""},{"$f":"IF(加入情報!Q19=0,\"\",加入情報!Q19)","v":""},{"$f":"IF(加入情報!R19=0,\"\",加入情報!R19)","v":""},{"$f":"IF(加入情報!S19=0,\"\",加入情報!S19)","v":""},{"$f":"IF(加入情報!T19=0,\"\",加入情報!T19)","v":""},{"$f":"IF(加入情報!U19=0,\"\",加入情報!U19)","v":""},{"$f":"IF(加入情報!V19=0,\"\",加入情報!V19)","v":""},{"$f":"COUNTIF(F69:Q69,1)+COUNTIF(F69:Q69,3)+COUNTIF(F69:Q69,8)","v":0},null,{"$f":"COUNTIF(F69:Q69,4)+COUNTIF(F69:Q69,5)","v":0},null,{"$f":"COUNTIF(F69:Q69,8)","v":0},null,{"$f":"IF($R69=0,0,($R69-$V69)/$R69*$X81*$R69/12)","v":0},null,null,{"$f":"SUM(F78:Q78)+SUM(F75:Q75)","v":0},null,null,{"$f":"IF($R69=0,0,($R69-$V69)/$R69*AD81*$R69/12)","v":0},null,null,{"$f":"SUM(F79:Q79)+SUM(F76:Q76)","v":0},null,null,{"$f":"AJ81*$R70/12","v":0},null,null,{"$f":"SUM(F80:Q80)","v":0}]
[null,null,null,null,"介護",{"$f":"IFERROR(IF(AND(F69=3,加入情報!K21<65,加入情報!K21>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(G69=3,加入情報!L21<65,加入情報!L21>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(H69=3,加入情報!M21<65,加入情報!M21>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(I69=3,加入情報!N21<65,加入情報!N21>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(J69=3,加入情報!O21<65,加入情報!O21>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(K69=3,加入情報!P21<65,加入情報!P21>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(L69=3,加入情報!Q21<65,加入情報!Q21>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(M69=3,加入情報!R21<65,加入情報!R21>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(N69=3,加入情報!S21<65,加入情報!S21>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(O69=3,加入情報!T21<65,加入情報!T21>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(P69=3,加入情報!U21<65,加入情報!U21>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(Q69=3,加入情報!V21<65,加入情報!V21>=40),1,\"\"),\"\")","v":""},{"$f":"SUBTOTAL(9,F70:Q70)","v":0},null,{"$f":"COUNTIF(F69:Q69,6)+COUNTIF(F69:Q69,7)","v":0},null,{"$f":"IF(加入情報!V21<7,1,0)","v":0}]
[null,null,null,null,"特定"]
[null,null,null,"予備","医療"]
[null,null,null,null,"後期"]
[null,null,null,null,"介護"]
[null,null,null,"未就学軽減","医療",{"$f":"IF($V70=1,IF(OR(F69=1,F69=3),-$N$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V70=1,IF(OR(G69=1,G69=3),-$N$3/12*(1-G$6/10)/2,0),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF($V70=1,IF(OR(F69=1,F69=3),-$Z$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V70=1,IF(OR(G69=1,G69=3),-$Z$3/12*(1-G$6/10)/2,0),0)","v":0},{"$f":"IF($V70=1,IF(OR(H69=1,H69=3),-$Z$3/12*(1-H$6/10)/2,0),0)","v":0},{"$f":"IF($V70=1,IF(OR(I69=1,I69=3),-$Z$3/12*(1-I$6/10)/2,0),0)","v":0},0,0,0,0,0,0,{"$f":"IF($V70=1,IF(OR(P69=1,P69=3),-$Z$3/12*(1-P$6/10)/2,0),0)","v":0},{"$f":"IF($V70=1,IF(OR(Q69=1,Q69=3),-$Z$3/12*(1-Q$6/10)/2,0),0)","v":0}]
[null,null,null,null,"介護"]
[null,null,null,"均等割用","医療",{"$f":"IF(OR(F69=1,F69=3),$N$3/12*(1-F$6/10),IF(AND(F69=8,F$6<5),$N$3/12*0.5,IF(F69=8,$N$3/12*(1-F$6/10),0)))","v":0},0,{"$f":"IF(OR(H69=1,H69=3),$N$3/12*(1-H$6/10),IF(AND(H69=8,H$6<5),$N$3/12*0.5,IF(H69=8,$N$3/12*(1-H$6/10),0)))","v":0},{"$f":"IF(OR(I69=1,I69=3),$N$3/12*(1-I$6/10),IF(AND(I69=8,I$6<5),$N$3/12*0.5,IF(I69=8,$N$3/12*(1-I$6/10),0)))","v":0},0,{"$f":"IF(OR(K69=1,K69=3),$N$3/12*(1-K$6/10),IF(AND(K69=8,K$6<5),$N$3/12*0.5,IF(K69=8,$N$3/12*(1-K$6/10),0)))","v":0},{"$f":"IF(OR(L69=1,L69=3),$N$3/12*(1-L$6/10),IF(AND(L69=8,L$6<5),$N$3/12*0.5,IF(L69=8,$N$3/12*(1-L$6/10),0)))","v":0},0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF(OR(F69=1,F69=3),$Z$3/12*(1-F$6/10),IF(AND(F69=8,F$6<5),$Z$3/12*0.5,IF(F69=8,$Z$3/12*(1-F$6/10),0)))","v":0},{"$f":"IF(OR(G69=1,G69=3),$Z$3/12*(1-G$6/10),IF(AND(G69=8,G$6<5),$Z$3/12*0.5,IF(G69=8,$Z$3/12*(1-G$6/10),0)))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"介護",{"$f":"IF(F70=1,$AL$3/12*(1-F$6/10),0)","v":0},{"$f":"IF(G70=1,$AL$3/12*(1-G$6/10),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"限度額用","医療",{"$f":"IF(OR(F69=1,F69=3,F69=8),$X81+$AA81,0)","v":0},{"$f":"IF(OR(G69=1,G69=3,G69=8),$X81+$AA81,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,"限度額判定用",null,{"$f":"IF(B69-$AU$2>0,ROUNDDOWN((B69-$AU$2)*$K$3,0),0)","v":0},null,null,{"$f":"IF(V70=0,$N$3*(1-0.1*$B$4),$N$3*(1-0.1*$B$4)/2)","v":8879.9999999999982},null,null,{"$f":"IF($B69-$AU$2>0,ROUNDDOWN(($B69-$AU$2)*$W$3,0),0)","v":0},null,null,{"$f":"IF(V70=0,$Z$3*(1-0.1*$B$4),$Z$3*(1-0.1*$B$4)/2)","v":2789.9999999999995},null,null,{"$f":"IF($B69-$AU$2>0,ROUNDDOWN(($B69-$AU$2)*$AI$3,0),0)","v":0},null,null,{"$f":"IF(V70=0,$AL$3*(1-0.1*$B$4),$AL$3*(1-0.1*$B$4)/2)","v":4469.9999999999991}]
[null,null,null,null,"後期",{"$f":"IF(OR(F69=1,F69=3,F69=8),$AD81+$AG81,0)","v":0},{"$f":"IF(OR(G69=1,G69=3,G69=8),$AD81+$AG81,0)","v":0},{"$f":"IF(OR(H69=1,H69=3,H69=8),$AD81+$AG81,0)","v":0},{"$f":"IF(OR(I69=1,I69=3,I69=8),$AD81+$AG81,0)","v":0},{"$f":"IF(OR(J69=1,J69=3,J69=8),$AD81+$AG81,0)","v":0},{"$f":"IF(OR(K69=1,K69=3,K69=8),$AD81+$AG81,0)","v":0},{"$f":"IF(OR(L69=1,L69=3,L69=8),$AD81+$AG81,0)","v":0},{"$f":"IF(OR(M69=1,M69=3,M69=8),$AD81+$AG81,0)","v":0},{"$f":"IF(OR(N69=1,N69=3,N69=8),$AD81+$AG81,0)","v":0},{"$f":"IF(OR(O69=1,O69=3,O69=8),$AD81+$AG81,0)","v":0},{"$f":"IF(OR(P69=1,P69=3,P69=8),$AD81+$AG81,0)","v":0},{"$f":"IF(OR(Q69=1,Q69=3,Q69=8),$AD81+$AG81,0)","v":0}]
[null,null,null,null,"介護",{"$f":"IF(F70=1,$AJ81+$AM81,0)","v":0},{"$f":"IF(G70=1,$AJ81+$AM81,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[6,{"$f":"給与所得計算!F31+年金所得計算!D79+試算!AV35","v":0},null,null,"医療",{"$f":"IF(加入情報!K22=0,\"\",加入情報!K22)","v":""},{"$f":"IF(加入情報!L22=0,\"\",加入情報!L22)","v":""},{"$f":"IF(加入情報!M22=0,\"\",加入情報!M22)","v":""},{"$f":"IF(加入情報!N22=0,\"\",加入情報!N22)","v":""},{"$f":"IF(加入情報!O22=0,\"\",加入情報!O22)","v":""},{"$f":"IF(加入情報!P22=0,\"\",加入情報!P22)","v":""},{"$f":"IF(加入情報!Q22=0,\"\",加入情報!Q22)","v":""},{"$f":"IF(加入情報!R22=0,\"\",加入情報!R22)","v":""},{"$f":"IF(加入情報!S22=0,\"\",加入情報!S22)","v":""},{"$f":"IF(加入情報!T22=0,\"\",加入情報!T22)","v":""},{"$f":"IF(加入情報!U22=0,\"\",加入情報!U22)","v":""},{"$f":"IF(加入情報!V22=0,\"\",加入情報!V22)","v":""},{"$f":"COUNTIF(F84:Q84,1)+COUNTIF(F84:Q84,3)+COUNTIF(F84:Q84,8)","v":0},null,{"$f":"COUNTIF(F84:Q84,4)+COUNTIF(F84:Q84,5)","v":0},null,{"$f":"COUNTIF(F84:Q84,8)","v":0},null,{"$f":"IF($R84=0,0,($R84-$V84)/$R84*$X96*$R84/12)","v":0},null,null,{"$f":"SUM(F93:Q93)+SUM(F90:Q90)","v":0},null,null,{"$f":"IF($R84=0,0,($R84-$V84)/$R84*AD96*$R84/12)","v":0},null,null,{"$f":"SUM(F94:Q94)+SUM(F91:Q91)","v":0},null,null,{"$f":"AJ96*$R85/12","v":0},null,null,{"$f":"SUM(F95:Q95)","v":0}]
[null,null,null,null,"介護",{"$f":"IFERROR(IF(AND(F84=3,加入情報!K24<65,加入情報!K24>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(G84=3,加入情報!L24<65,加入情報!L24>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(H84=3,加入情報!M24<65,加入情報!M24>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(I84=3,加入情報!N24<65,加入情報!N24>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(J84=3,加入情報!O24<65,加入情報!O24>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(K84=3,加入情報!P24<65,加入情報!P24>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(L84=3,加入情報!Q24<65,加入情報!Q24>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(M84=3,加入情報!R24<65,加入情報!R24>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(N84=3,加入情報!S24<65,加入情報!S24>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(O84=3,加入情報!T24<65,加入情報!T24>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(P84=3,加入情報!U24<65,加入情報!U24>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(Q84=3,加入情報!V24<65,加入情報!V24>=40),1,\"\"),\"\")","v":""},{"$f":"SUBTOTAL(9,F85:Q85)","v":0},null,{"$f":"COUNTIF(F84:Q84,6)+COUNTIF(F84:Q84,7)","v":0},null,{"$f":"IF(加入情報!V24<7,1,0)","v":0}]
[null,null,null,null,"特定"]
[null,null,null,"予備","医療"]
[null,null,null,null,"後期"]
[null,null,null,null,"介護"]
[null,null,null,"未就学軽減","医療",{"$f":"IF($V85=1,IF(OR(F84=1,F84=3),-$N$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V85=1,IF(OR(G84=1,G84=3),-$N$3/12*(1-G$6/10)/2,0),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF($V85=1,IF(OR(F84=1,F84=3),-$Z$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V85=1,IF(OR(G84=1,G84=3),-$Z$3/12*(1-G$6/10)/2,0),0)","v":0},{"$f":"IF($V85=1,IF(OR(H84=1,H84=3),-$Z$3/12*(1-H$6/10)/2,0),0)","v":0},{"$f":"IF($V85=1,IF(OR(I84=1,I84=3),-$Z$3/12*(1-I$6/10)/2,0),0)","v":0},0,0,0,0,0,0,{"$f":"IF($V85=1,IF(OR(P84=1,P84=3),-$Z$3/12*(1-P$6/10)/2,0),0)","v":0},{"$f":"IF($V85=1,IF(OR(Q84=1,Q84=3),-$Z$3/12*(1-Q$6/10)/2,0),0)","v":0}]
[null,null,null,null,"介護"]
[null,null,null,"均等割用","医療",{"$f":"IF(OR(F84=1,F84=3),$N$3/12*(1-F$6/10),IF(AND(F84=8,F$6<5),$N$3/12*0.5,IF(F84=8,$N$3/12*(1-F$6/10),0)))","v":0},0,{"$f":"IF(OR(H84=1,H84=3),$N$3/12*(1-H$6/10),IF(AND(H84=8,H$6<5),$N$3/12*0.5,IF(H84=8,$N$3/12*(1-H$6/10),0)))","v":0},{"$f":"IF(OR(I84=1,I84=3),$N$3/12*(1-I$6/10),IF(AND(I84=8,I$6<5),$N$3/12*0.5,IF(I84=8,$N$3/12*(1-I$6/10),0)))","v":0},0,{"$f":"IF(OR(K84=1,K84=3),$N$3/12*(1-K$6/10),IF(AND(K84=8,K$6<5),$N$3/12*0.5,IF(K84=8,$N$3/12*(1-K$6/10),0)))","v":0},{"$f":"IF(OR(L84=1,L84=3),$N$3/12*(1-L$6/10),IF(AND(L84=8,L$6<5),$N$3/12*0.5,IF(L84=8,$N$3/12*(1-L$6/10),0)))","v":0},0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF(OR(F84=1,F84=3),$Z$3/12*(1-F$6/10),IF(AND(F84=8,F$6<5),$Z$3/12*0.5,IF(F84=8,$Z$3/12*(1-F$6/10),0)))","v":0},{"$f":"IF(OR(G84=1,G84=3),$Z$3/12*(1-G$6/10),IF(AND(G84=8,G$6<5),$Z$3/12*0.5,IF(G84=8,$Z$3/12*(1-G$6/10),0)))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"介護",{"$f":"IF(F85=1,$AL$3/12*(1-F$6/10),0)","v":0},{"$f":"IF(G85=1,$AL$3/12*(1-G$6/10),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"限度額用","医療",{"$f":"IF(OR(F84=1,F84=3,F84=8),$X96+$AA96,0)","v":0},{"$f":"IF(OR(G84=1,G84=3,G84=8),$X96+$AA96,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,"限度額判定用",null,{"$f":"IF(B84-$AU$2>0,ROUNDDOWN((B84-$AU$2)*$K$3,0),0)","v":0},null,null,{"$f":"IF(V85=0,$N$3*(1-0.1*$B$4),$N$3*(1-0.1*$B$4)/2)","v":8879.9999999999982},null,null,{"$f":"IF($B84-$AU$2>0,ROUNDDOWN(($B84-$AU$2)*$W$3,0),0)","v":0},null,null,{"$f":"IF(V85=0,$Z$3*(1-0.1*$B$4),$Z$3*(1-0.1*$B$4)/2)","v":2789.9999999999995},null,null,{"$f":"IF($B84-$AU$2>0,ROUNDDOWN(($B84-$AU$2)*$AI$3,0),0)","v":0},null,null,{"$f":"IF(V85=0,$AL$3*(1-0.1*$B$4),$AL$3*(1-0.1*$B$4)/2)","v":4469.9999999999991}]
[null,null,null,null,"後期",{"$f":"IF(OR(F84=1,F84=3,F84=8),$AD96+$AG96,0)","v":0},{"$f":"IF(OR(G84=1,G84=3,G84=8),$AD96+$AG96,0)","v":0},{"$f":"IF(OR(H84=1,H84=3,H84=8),$AD96+$AG96,0)","v":0},{"$f":"IF(OR(I84=1,I84=3,I84=8),$AD96+$AG96,0)","v":0},{"$f":"IF(OR(J84=1,J84=3,J84=8),$AD96+$AG96,0)","v":0},{"$f":"IF(OR(K84=1,K84=3,K84=8),$AD96+$AG96,0)","v":0},{"$f":"IF(OR(L84=1,L84=3,L84=8),$AD96+$AG96,0)","v":0},{"$f":"IF(OR(M84=1,M84=3,M84=8),$AD96+$AG96,0)","v":0},{"$f":"IF(OR(N84=1,N84=3,N84=8),$AD96+$AG96,0)","v":0},{"$f":"IF(OR(O84=1,O84=3,O84=8),$AD96+$AG96,0)","v":0},{"$f":"IF(OR(P84=1,P84=3,P84=8),$AD96+$AG96,0)","v":0},{"$f":"IF(OR(Q84=1,Q84=3,Q84=8),$AD96+$AG96,0)","v":0}]
[null,null,null,null,"介護",{"$f":"IF(F85=1,$AJ96+$AM96,0)","v":0},{"$f":"IF(G85=1,$AJ96+$AM96,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[7,{"$f":"給与所得計算!F32+年金所得計算!D80+試算!AV37","v":0},null,null,"医療",{"$f":"IF(加入情報!K25=0,\"\",加入情報!K25)","v":""},{"$f":"IF(加入情報!L25=0,\"\",加入情報!L25)","v":""},{"$f":"IF(加入情報!M25=0,\"\",加入情報!M25)","v":""},{"$f":"IF(加入情報!N25=0,\"\",加入情報!N25)","v":""},{"$f":"IF(加入情報!O25=0,\"\",加入情報!O25)","v":""},{"$f":"IF(加入情報!P25=0,\"\",加入情報!P25)","v":""},{"$f":"IF(加入情報!Q25=0,\"\",加入情報!Q25)","v":""},{"$f":"IF(加入情報!R25=0,\"\",加入情報!R25)","v":""},{"$f":"IF(加入情報!S25=0,\"\",加入情報!S25)","v":""},{"$f":"IF(加入情報!T25=0,\"\",加入情報!T25)","v":""},{"$f":"IF(加入情報!U25=0,\"\",加入情報!U25)","v":""},{"$f":"IF(加入情報!V25=0,\"\",加入情報!V25)","v":""},{"$f":"COUNTIF(F99:Q99,1)+COUNTIF(F99:Q99,3)+COUNTIF(F99:Q99,8)","v":0},null,{"$f":"COUNTIF(F99:Q99,4)+COUNTIF(F99:Q99,5)","v":0},null,{"$f":"COUNTIF(F99:Q99,8)","v":0},null,{"$f":"IF($R99=0,0,($R99-$V99)/$R99*$X111*$R99/12)","v":0},null,null,{"$f":"SUM(F108:Q108)+SUM(F105:Q105)","v":0},null,null,{"$f":"IF($R99=0,0,($R99-$V99)/$R99*AD111*$R99/12)","v":0},null,null,{"$f":"SUM(F109:Q109)+SUM(F106:Q106)","v":0},null,null,{"$f":"AJ111*$R100/12","v":0},null,null,{"$f":"SUM(F110:Q110)","v":0}]
[null,null,null,null,"介護",{"$f":"IFERROR(IF(AND(F99=3,加入情報!K27<65,加入情報!K27>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(G99=3,加入情報!L27<65,加入情報!L27>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(H99=3,加入情報!M27<65,加入情報!M27>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(I99=3,加入情報!N27<65,加入情報!N27>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(J99=3,加入情報!O27<65,加入情報!O27>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(K99=3,加入情報!P27<65,加入情報!P27>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(L99=3,加入情報!Q27<65,加入情報!Q27>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(M99=3,加入情報!R27<65,加入情報!R27>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(N99=3,加入情報!S27<65,加入情報!S27>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(O99=3,加入情報!T27<65,加入情報!T27>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(P99=3,加入情報!U27<65,加入情報!U27>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(Q99=3,加入情報!V27<65,加入情報!V27>=40),1,\"\"),\"\")","v":""},{"$f":"SUBTOTAL(9,F100:Q100)","v":0},null,{"$f":"COUNTIF(F99:Q99,6)+COUNTIF(F99:Q99,7)","v":0},null,{"$f":"IF(加入情報!V27<7,1,0)","v":0}]
[null,null,null,null,"特定"]
[null,null,null,"予備","医療"]
[null,null,null,null,"後期"]
[null,null,null,null,"介護"]
[null,null,null,"未就学軽減","医療",{"$f":"IF($V100=1,IF(OR(F99=1,F99=3),-$N$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V100=1,IF(OR(G99=1,G99=3),-$N$3/12*(1-G$6/10)/2,0),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF($V100=1,IF(OR(F99=1,F99=3),-$Z$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V100=1,IF(OR(G99=1,G99=3),-$Z$3/12*(1-G$6/10)/2,0),0)","v":0},{"$f":"IF($V100=1,IF(OR(H99=1,H99=3),-$Z$3/12*(1-H$6/10)/2,0),0)","v":0},{"$f":"IF($V100=1,IF(OR(I99=1,I99=3),-$Z$3/12*(1-I$6/10)/2,0),0)","v":0},0,0,0,0,0,0,{"$f":"IF($V100=1,IF(OR(P99=1,P99=3),-$Z$3/12*(1-P$6/10)/2,0),0)","v":0},{"$f":"IF($V100=1,IF(OR(Q99=1,Q99=3),-$Z$3/12*(1-Q$6/10)/2,0),0)","v":0}]
[null,null,null,null,"介護"]
[null,null,null,"均等割用","医療",{"$f":"IF(OR(F99=1,F99=3),$N$3/12*(1-F$6/10),IF(AND(F99=8,F$6<5),$N$3/12*0.5,IF(F99=8,$N$3/12*(1-F$6/10),0)))","v":0},0,{"$f":"IF(OR(H99=1,H99=3),$N$3/12*(1-H$6/10),IF(AND(H99=8,H$6<5),$N$3/12*0.5,IF(H99=8,$N$3/12*(1-H$6/10),0)))","v":0},{"$f":"IF(OR(I99=1,I99=3),$N$3/12*(1-I$6/10),IF(AND(I99=8,I$6<5),$N$3/12*0.5,IF(I99=8,$N$3/12*(1-I$6/10),0)))","v":0},0,{"$f":"IF(OR(K99=1,K99=3),$N$3/12*(1-K$6/10),IF(AND(K99=8,K$6<5),$N$3/12*0.5,IF(K99=8,$N$3/12*(1-K$6/10),0)))","v":0},{"$f":"IF(OR(L99=1,L99=3),$N$3/12*(1-L$6/10),IF(AND(L99=8,L$6<5),$N$3/12*0.5,IF(L99=8,$N$3/12*(1-L$6/10),0)))","v":0},0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF(OR(F99=1,F99=3),$Z$3/12*(1-F$6/10),IF(AND(F99=8,F$6<5),$Z$3/12*0.5,IF(F99=8,$Z$3/12*(1-F$6/10),0)))","v":0},{"$f":"IF(OR(G99=1,G99=3),$Z$3/12*(1-G$6/10),IF(AND(G99=8,G$6<5),$Z$3/12*0.5,IF(G99=8,$Z$3/12*(1-G$6/10),0)))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"介護",{"$f":"IF(F100=1,$AL$3/12*(1-F$6/10),0)","v":0},{"$f":"IF(G100=1,$AL$3/12*(1-G$6/10),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"限度額用","医療",{"$f":"IF(OR(F99=1,F99=3,F99=8),$X111+$AA111,0)","v":0},{"$f":"IF(OR(G99=1,G99=3,G99=8),$X111+$AA111,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,"限度額判定用",null,{"$f":"IF(B99-$AU$2>0,ROUNDDOWN((B99-$AU$2)*$K$3,0),0)","v":0},null,null,{"$f":"IF(V100=0,$N$3*(1-0.1*$B$4),$N$3*(1-0.1*$B$4)/2)","v":8879.9999999999982},null,null,{"$f":"IF($B99-$AU$2>0,ROUNDDOWN(($B99-$AU$2)*$W$3,0),0)","v":0},null,null,{"$f":"IF(V100=0,$Z$3*(1-0.1*$B$4),$Z$3*(1-0.1*$B$4)/2)","v":2789.9999999999995},null,null,{"$f":"IF($B99-$AU$2>0,ROUNDDOWN(($B99-$AU$2)*$AI$3,0),0)","v":0},null,null,{"$f":"IF(V100=0,$AL$3*(1-0.1*$B$4),$AL$3*(1-0.1*$B$4)/2)","v":4469.9999999999991}]
[null,null,null,null,"後期",{"$f":"IF(OR(F99=1,F99=3,F99=8),$AD111+$AG111,0)","v":0},{"$f":"IF(OR(G99=1,G99=3,G99=8),$AD111+$AG111,0)","v":0},{"$f":"IF(OR(H99=1,H99=3,H99=8),$AD111+$AG111,0)","v":0},{"$f":"IF(OR(I99=1,I99=3,I99=8),$AD111+$AG111,0)","v":0},{"$f":"IF(OR(J99=1,J99=3,J99=8),$AD111+$AG111,0)","v":0},{"$f":"IF(OR(K99=1,K99=3,K99=8),$AD111+$AG111,0)","v":0},{"$f":"IF(OR(L99=1,L99=3,L99=8),$AD111+$AG111,0)","v":0},{"$f":"IF(OR(M99=1,M99=3,M99=8),$AD111+$AG111,0)","v":0},{"$f":"IF(OR(N99=1,N99=3,N99=8),$AD111+$AG111,0)","v":0},{"$f":"IF(OR(O99=1,O99=3,O99=8),$AD111+$AG111,0)","v":0},{"$f":"IF(OR(P99=1,P99=3,P99=8),$AD111+$AG111,0)","v":0},{"$f":"IF(OR(Q99=1,Q99=3,Q99=8),$AD111+$AG111,0)","v":0}]
[null,null,null,null,"介護",{"$f":"IF(F100=1,$AJ111+$AM111,0)","v":0},{"$f":"IF(G100=1,$AJ111+$AM111,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[8,{"$f":"給与所得計算!F33+年金所得計算!D81+試算!AV39","v":0},null,null,"医療",{"$f":"IF(加入情報!K28=0,\"\",加入情報!K28)","v":""},{"$f":"IF(加入情報!L28=0,\"\",加入情報!L28)","v":""},{"$f":"IF(加入情報!M28=0,\"\",加入情報!M28)","v":""},{"$f":"IF(加入情報!N28=0,\"\",加入情報!N28)","v":""},{"$f":"IF(加入情報!O28=0,\"\",加入情報!O28)","v":""},{"$f":"IF(加入情報!P28=0,\"\",加入情報!P28)","v":""},{"$f":"IF(加入情報!Q28=0,\"\",加入情報!Q28)","v":""},{"$f":"IF(加入情報!R28=0,\"\",加入情報!R28)","v":""},{"$f":"IF(加入情報!S28=0,\"\",加入情報!S28)","v":""},{"$f":"IF(加入情報!T28=0,\"\",加入情報!T28)","v":""},{"$f":"IF(加入情報!U28=0,\"\",加入情報!U28)","v":""},{"$f":"IF(加入情報!V28=0,\"\",加入情報!V28)","v":""},{"$f":"COUNTIF(F114:Q114,1)+COUNTIF(F114:Q114,3)+COUNTIF(F114:Q114,8)","v":0},null,{"$f":"COUNTIF(F114:Q114,4)+COUNTIF(F114:Q114,5)","v":0},null,{"$f":"COUNTIF(F114:Q114,8)","v":0},null,{"$f":"IF($R114=0,0,($R114-$V114)/$R114*$X126*$R114/12)","v":0},null,null,{"$f":"SUM(F123:Q123)+SUM(F120:Q120)","v":0},null,null,{"$f":"IF($R114=0,0,($R114-$V114)/$R114*AD126*$R114/12)","v":0},null,null,{"$f":"SUM(F124:Q124)+SUM(F121:Q121)","v":0},null,null,{"$f":"AJ126*$R115/12","v":0},null,null,{"$f":"SUM(F125:Q125)","v":0}]
[null,null,null,null,"介護",{"$f":"IFERROR(IF(AND(F114=3,加入情報!K30<65,加入情報!K30>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(G114=3,加入情報!L30<65,加入情報!L30>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(H114=3,加入情報!M30<65,加入情報!M30>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(I114=3,加入情報!N30<65,加入情報!N30>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(J114=3,加入情報!O30<65,加入情報!O30>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(K114=3,加入情報!P30<65,加入情報!P30>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(L114=3,加入情報!Q30<65,加入情報!Q30>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(M114=3,加入情報!R30<65,加入情報!R30>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(N114=3,加入情報!S30<65,加入情報!S30>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(O114=3,加入情報!T30<65,加入情報!T30>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(P114=3,加入情報!U30<65,加入情報!U30>=40),1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(Q114=3,加入情報!V30<65,加入情報!V30>=40),1,\"\"),\"\")","v":""},{"$f":"SUBTOTAL(9,F115:Q115)","v":0},null,{"$f":"COUNTIF(F114:Q114,6)+COUNTIF(F114:Q114,7)","v":0},null,{"$f":"IF(加入情報!V30<7,1,0)","v":0}]
[null,null,null,null,"特定"]
[null,null,null,"予備","医療"]
[null,null,null,null,"後期"]
[null,null,null,null,"介護"]
[null,null,null,"未就学軽減","医療",{"$f":"IF($V115=1,IF(OR(F114=1,F114=3),-$N$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V115=1,IF(OR(G114=1,G114=3),-$N$3/12*(1-G$6/10)/2,0),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF($V115=1,IF(OR(F114=1,F114=3),-$Z$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V115=1,IF(OR(G114=1,G114=3),-$Z$3/12*(1-G$6/10)/2,0),0)","v":0},{"$f":"IF($V115=1,IF(OR(H114=1,H114=3),-$Z$3/12*(1-H$6/10)/2,0),0)","v":0},{"$f":"IF($V115=1,IF(OR(I114=1,I114=3),-$Z$3/12*(1-I$6/10)/2,0),0)","v":0},0,0,0,0,0,0,{"$f":"IF($V115=1,IF(OR(P114=1,P114=3),-$Z$3/12*(1-P$6/10)/2,0),0)","v":0},{"$f":"IF($V115=1,IF(OR(Q114=1,Q114=3),-$Z$3/12*(1-Q$6/10)/2,0),0)","v":0}]
[null,null,null,null,"介護"]
[null,null,null,"均等割用","医療",{"$f":"IF(OR(F114=1,F114=3),$N$3/12*(1-F$6/10),IF(AND(F114=8,F$6<5),$N$3/12*0.5,IF(F114=8,$N$3/12*(1-F$6/10),0)))","v":0},0,{"$f":"IF(OR(H114=1,H114=3),$N$3/12*(1-H$6/10),IF(AND(H114=8,H$6<5),$N$3/12*0.5,IF(H114=8,$N$3/12*(1-H$6/10),0)))","v":0},{"$f":"IF(OR(I114=1,I114=3),$N$3/12*(1-I$6/10),IF(AND(I114=8,I$6<5),$N$3/12*0.5,IF(I114=8,$N$3/12*(1-I$6/10),0)))","v":0},0,{"$f":"IF(OR(K114=1,K114=3),$N$3/12*(1-K$6/10),IF(AND(K114=8,K$6<5),$N$3/12*0.5,IF(K114=8,$N$3/12*(1-K$6/10),0)))","v":0},{"$f":"IF(OR(L114=1,L114=3),$N$3/12*(1-L$6/10),IF(AND(L114=8,L$6<5),$N$3/12*0.5,IF(L114=8,$N$3/12*(1-L$6/10),0)))","v":0},0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF(OR(F114=1,F114=3),$Z$3/12*(1-F$6/10),IF(AND(F114=8,F$6<5),$Z$3/12*0.5,IF(F114=8,$Z$3/12*(1-F$6/10),0)))","v":0},{"$f":"IF(OR(G114=1,G114=3),$Z$3/12*(1-G$6/10),IF(AND(G114=8,G$6<5),$Z$3/12*0.5,IF(G114=8,$Z$3/12*(1-G$6/10),0)))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"介護",{"$f":"IF(F115=1,$AL$3/12*(1-F$6/10),0)","v":0},{"$f":"IF(G115=1,$AL$3/12*(1-G$6/10),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"限度額用","医療",{"$f":"IF(OR(F114=1,F114=3,F114=8),$X126+$AA126,0)","v":0},{"$f":"IF(OR(G114=1,G114=3,G114=8),$X126+$AA126,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,"限度額判定用",null,{"$f":"IF(B114-$AU$2>0,ROUNDDOWN((B114-$AU$2)*$K$3,0),0)","v":0},null,null,{"$f":"IF(V115=0,$N$3*(1-0.1*$B$4),$N$3*(1-0.1*$B$4)/2)","v":8879.9999999999982},null,null,{"$f":"IF($B114-$AU$2>0,ROUNDDOWN(($B114-$AU$2)*$W$3,0),0)","v":0},null,null,{"$f":"IF(V115=0,$Z$3*(1-0.1*$B$4),$Z$3*(1-0.1*$B$4)/2)","v":2789.9999999999995},null,null,{"$f":"IF($B114-$AU$2>0,ROUNDDOWN(($B114-$AU$2)*$AI$3,0),0)","v":0},null,null,{"$f":"IF(V115=0,$AL$3*(1-0.1*$B$4),$AL$3*(1-0.1*$B$4)/2)","v":4469.9999999999991}]
[null,null,null,null,"後期",{"$f":"IF(OR(F114=1,F114=3,F114=8),$AD126+$AG126,0)","v":0},{"$f":"IF(OR(G114=1,G114=3,G114=8),$AD126+$AG126,0)","v":0},{"$f":"IF(OR(H114=1,H114=3,H114=8),$AD126+$AG126,0)","v":0},{"$f":"IF(OR(I114=1,I114=3,I114=8),$AD126+$AG126,0)","v":0},{"$f":"IF(OR(J114=1,J114=3,J114=8),$AD126+$AG126,0)","v":0},{"$f":"IF(OR(K114=1,K114=3,K114=8),$AD126+$AG126,0)","v":0},{"$f":"IF(OR(L114=1,L114=3,L114=8),$AD126+$AG126,0)","v":0},{"$f":"IF(OR(M114=1,M114=3,M114=8),$AD126+$AG126,0)","v":0},{"$f":"IF(OR(N114=1,N114=3,N114=8),$AD126+$AG126,0)","v":0},{"$f":"IF(OR(O114=1,O114=3,O114=8),$AD126+$AG126,0)","v":0},{"$f":"IF(OR(P114=1,P114=3,P114=8),$AD126+$AG126,0)","v":0},{"$f":"IF(OR(Q114=1,Q114=3,Q114=8),$AD126+$AG126,0)","v":0}]
[null,null,null,null,"介護",{"$f":"IF(F115=1,$AJ126+$AM126,0)","v":0},{"$f":"IF(G115=1,$AJ126+$AM126,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[9,null,null,null,"医療",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(F129:Q129,1)+COUNTIF(F129:Q129,3)+COUNTIF(F129:Q129,8)","v":0},null,{"$f":"COUNTIF(F129:Q129,4)+COUNTIF(F129:Q129,5)","v":0},null,{"$f":"COUNTIF(F129:Q129,8)","v":0},null,{"$f":"IF($R129=0,0,($R129-$V129)/$R129*$X141*$R129/12)","v":0},null,null,{"$f":"SUM(F138:Q138)+SUM(F135:Q135)","v":0},null,null,{"$f":"IF($R129=0,0,($R129-$V129)/$R129*AD141*$R129/12)","v":0},null,null,{"$f":"SUM(F139:Q139)+SUM(F136:Q136)","v":0},null,null,{"$f":"AJ141*$R130/12","v":0},null,null,{"$f":"SUM(F140:Q140)","v":0}]
[null,null,null,null,"介護",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,F130:Q130)","v":0},null,{"$f":"COUNTIF(F129:Q129,6)+COUNTIF(F129:Q129,7)","v":0}]
[null,null,null,null,"特定"]
[null,null,null,"予備","医療"]
[null,null,null,null,"後期"]
[null,null,null,null,"介護"]
[null,null,null,"未就学軽減","医療",{"$f":"IF($V130=1,IF(OR(F129=1,F129=3),-$N$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V130=1,IF(OR(G129=1,G129=3),-$N$3/12*(1-G$6/10)/2,0),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF($V130=1,IF(OR(F129=1,F129=3),-$Z$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V130=1,IF(OR(G129=1,G129=3),-$Z$3/12*(1-G$6/10)/2,0),0)","v":0},{"$f":"IF($V130=1,IF(OR(H129=1,H129=3),-$Z$3/12*(1-H$6/10)/2,0),0)","v":0},{"$f":"IF($V130=1,IF(OR(I129=1,I129=3),-$Z$3/12*(1-I$6/10)/2,0),0)","v":0},0,0,0,0,0,0,{"$f":"IF($V130=1,IF(OR(P129=1,P129=3),-$Z$3/12*(1-P$6/10)/2,0),0)","v":0},{"$f":"IF($V130=1,IF(OR(Q129=1,Q129=3),-$Z$3/12*(1-Q$6/10)/2,0),0)","v":0}]
[null,null,null,null,"介護"]
[null,null,null,"均等割用","医療",{"$f":"IF(OR(F129=1,F129=3),$N$3/12*(1-F$6/10),IF(AND(F129=8,F$6<5),$N$3/12*0.5,IF(F129=8,$N$3/12*(1-F$6/10),0)))","v":0},0,{"$f":"IF(OR(H129=1,H129=3),$N$3/12*(1-H$6/10),IF(AND(H129=8,H$6<5),$N$3/12*0.5,IF(H129=8,$N$3/12*(1-H$6/10),0)))","v":0},{"$f":"IF(OR(I129=1,I129=3),$N$3/12*(1-I$6/10),IF(AND(I129=8,I$6<5),$N$3/12*0.5,IF(I129=8,$N$3/12*(1-I$6/10),0)))","v":0},0,{"$f":"IF(OR(K129=1,K129=3),$N$3/12*(1-K$6/10),IF(AND(K129=8,K$6<5),$N$3/12*0.5,IF(K129=8,$N$3/12*(1-K$6/10),0)))","v":0},{"$f":"IF(OR(L129=1,L129=3),$N$3/12*(1-L$6/10),IF(AND(L129=8,L$6<5),$N$3/12*0.5,IF(L129=8,$N$3/12*(1-L$6/10),0)))","v":0},0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF(OR(F129=1,F129=3),$Z$3/12*(1-F$6/10),IF(AND(F129=8,F$6<5),$Z$3/12*0.5,IF(F129=8,$Z$3/12*(1-F$6/10),0)))","v":0},{"$f":"IF(OR(G129=1,G129=3),$Z$3/12*(1-G$6/10),IF(AND(G129=8,G$6<5),$Z$3/12*0.5,IF(G129=8,$Z$3/12*(1-G$6/10),0)))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"介護",{"$f":"IF(F130=1,$AL$3/12*(1-F$6/10),0)","v":0},{"$f":"IF(G130=1,$AL$3/12*(1-G$6/10),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"限度額用","医療",{"$f":"IF(OR(F129=1,F129=3,F129=8),$X141+$AA141,0)","v":0},{"$f":"IF(OR(G129=1,G129=3,G129=8),$X141+$AA141,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,"限度額判定用",null,{"$f":"IF(B129-$AU$2>0,ROUNDDOWN((B129-$AU$2)*$K$3,0),0)","v":0},null,null,{"$f":"IF(V130=0,$N$3*(1-0.1*$B$4),$N$3*(1-0.1*$B$4)/2)","v":8879.9999999999982},null,null,{"$f":"IF($B129-$AU$2>0,ROUNDDOWN(($B129-$AU$2)*$W$3,0),0)","v":0},null,null,{"$f":"IF(V130=0,$Z$3*(1-0.1*$B$4),$Z$3*(1-0.1*$B$4)/2)","v":2789.9999999999995},null,null,{"$f":"IF($B129-$AU$2>0,ROUNDDOWN(($B129-$AU$2)*$AI$3,0),0)","v":0},null,null,{"$f":"IF(V130=0,$AL$3*(1-0.1*$B$4),$AL$3*(1-0.1*$B$4)/2)","v":4469.9999999999991}]
[null,null,null,null,"後期",{"$f":"IF(OR(F129=1,F129=3,F129=8),$AD141+$AG141,0)","v":0},{"$f":"IF(OR(G129=1,G129=3,G129=8),$AD141+$AG141,0)","v":0},{"$f":"IF(OR(H129=1,H129=3,H129=8),$AD141+$AG141,0)","v":0},{"$f":"IF(OR(I129=1,I129=3,I129=8),$AD141+$AG141,0)","v":0},{"$f":"IF(OR(J129=1,J129=3,J129=8),$AD141+$AG141,0)","v":0},{"$f":"IF(OR(K129=1,K129=3,K129=8),$AD141+$AG141,0)","v":0},{"$f":"IF(OR(L129=1,L129=3,L129=8),$AD141+$AG141,0)","v":0},{"$f":"IF(OR(M129=1,M129=3,M129=8),$AD141+$AG141,0)","v":0},{"$f":"IF(OR(N129=1,N129=3,N129=8),$AD141+$AG141,0)","v":0},{"$f":"IF(OR(O129=1,O129=3,O129=8),$AD141+$AG141,0)","v":0},{"$f":"IF(OR(P129=1,P129=3,P129=8),$AD141+$AG141,0)","v":0},{"$f":"IF(OR(Q129=1,Q129=3,Q129=8),$AD141+$AG141,0)","v":0}]
[null,null,null,null,"介護",{"$f":"IF(F130=1,$AJ141+$AM141,0)","v":0},{"$f":"IF(G130=1,$AJ141+$AM141,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[10,null,null,null,"医療",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(F144:Q144,1)+COUNTIF(F144:Q144,3)+COUNTIF(F144:Q144,8)","v":0},null,{"$f":"COUNTIF(F144:Q144,4)+COUNTIF(F144:Q144,5)","v":0},null,{"$f":"COUNTIF(F144:Q144,8)","v":0},null,{"$f":"IF($R144=0,0,($R144-$V144)/$R144*$X156*$R144/12)","v":0},null,null,{"$f":"SUM(F153:Q153)+SUM(F150:Q150)","v":0},null,null,{"$f":"IF($R144=0,0,($R144-$V144)/$R144*AD156*$R144/12)","v":0},null,null,{"$f":"SUM(F154:Q154)+SUM(F151:Q151)","v":0},null,null,{"$f":"AJ156*$R145/12","v":0},null,null,{"$f":"SUM(F155:Q155)","v":0}]
[null,null,null,null,"介護",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,F145:Q145)","v":0},null,{"$f":"COUNTIF(F144:Q144,6)+COUNTIF(F144:Q144,7)","v":0}]
[null,null,null,null,"特定"]
[null,null,null,"予備","医療"]
[null,null,null,null,"後期"]
[null,null,null,null,"介護"]
[null,null,null,"未就学軽減","医療",{"$f":"IF($V145=1,IF(OR(F144=1,F144=3),-$N$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V145=1,IF(OR(G144=1,G144=3),-$N$3/12*(1-G$6/10)/2,0),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF($V145=1,IF(OR(F144=1,F144=3),-$Z$3/12*(1-F$6/10)/2,0),0)","v":0},{"$f":"IF($V145=1,IF(OR(G144=1,G144=3),-$Z$3/12*(1-G$6/10)/2,0),0)","v":0},{"$f":"IF($V145=1,IF(OR(H144=1,H144=3),-$Z$3/12*(1-H$6/10)/2,0),0)","v":0},{"$f":"IF($V145=1,IF(OR(I144=1,I144=3),-$Z$3/12*(1-I$6/10)/2,0),0)","v":0},0,0,0,0,0,0,{"$f":"IF($V145=1,IF(OR(P144=1,P144=3),-$Z$3/12*(1-P$6/10)/2,0),0)","v":0},{"$f":"IF($V145=1,IF(OR(Q144=1,Q144=3),-$Z$3/12*(1-Q$6/10)/2,0),0)","v":0}]
[null,null,null,null,"介護"]
[null,null,null,"均等割用","医療",{"$f":"IF(OR(F144=1,F144=3),$N$3/12*(1-F$6/10),IF(AND(F144=8,F$6<5),$N$3/12*0.5,IF(F144=8,$N$3/12*(1-F$6/10),0)))","v":0},0,{"$f":"IF(OR(H144=1,H144=3),$N$3/12*(1-H$6/10),IF(AND(H144=8,H$6<5),$N$3/12*0.5,IF(H144=8,$N$3/12*(1-H$6/10),0)))","v":0},{"$f":"IF(OR(I144=1,I144=3),$N$3/12*(1-I$6/10),IF(AND(I144=8,I$6<5),$N$3/12*0.5,IF(I144=8,$N$3/12*(1-I$6/10),0)))","v":0},0,{"$f":"IF(OR(K144=1,K144=3),$N$3/12*(1-K$6/10),IF(AND(K144=8,K$6<5),$N$3/12*0.5,IF(K144=8,$N$3/12*(1-K$6/10),0)))","v":0},{"$f":"IF(OR(L144=1,L144=3),$N$3/12*(1-L$6/10),IF(AND(L144=8,L$6<5),$N$3/12*0.5,IF(L144=8,$N$3/12*(1-L$6/10),0)))","v":0},0,0,0,0,0]
[null,null,null,null,"後期",{"$f":"IF(OR(F144=1,F144=3),$Z$3/12*(1-F$6/10),IF(AND(F144=8,F$6<5),$Z$3/12*0.5,IF(F144=8,$Z$3/12*(1-F$6/10),0)))","v":0},{"$f":"IF(OR(G144=1,G144=3),$Z$3/12*(1-G$6/10),IF(AND(G144=8,G$6<5),$Z$3/12*0.5,IF(G144=8,$Z$3/12*(1-G$6/10),0)))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"介護",{"$f":"IF(F145=1,$AL$3/12*(1-F$6/10),0)","v":0},{"$f":"IF(G145=1,$AL$3/12*(1-G$6/10),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"限度額用","医療",{"$f":"IF(OR(F144=1,F144=3,F144=8),$X156+$AA156,0)","v":0},{"$f":"IF(OR(G144=1,G144=3,G144=8),$X156+$AA156,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,"限度額判定用",null,{"$f":"IF(B144-$AU$2>0,ROUNDDOWN((B144-$AU$2)*$K$3,0),0)","v":0},null,null,{"$f":"IF(V145=0,$N$3*(1-0.1*$B$4),$N$3*(1-0.1*$B$4)/2)","v":8879.9999999999982},null,null,{"$f":"IF($B144-$AU$2>0,ROUNDDOWN(($B144-$AU$2)*$W$3,0),0)","v":0},null,null,{"$f":"IF(V145=0,$Z$3*(1-0.1*$B$4),$Z$3*(1-0.1*$B$4)/2)","v":2789.9999999999995},null,null,{"$f":"IF($B144-$AU$2>0,ROUNDDOWN(($B144-$AU$2)*$AI$3,0),0)","v":0},null,null,{"$f":"IF(V145=0,$AL$3*(1-0.1*$B$4),$AL$3*(1-0.1*$B$4)/2)","v":4469.9999999999991}]
[null,null,null,null,"後期",{"$f":"IF(OR(F144=1,F144=3,F144=8),$AD156+$AG156,0)","v":0},{"$f":"IF(OR(G144=1,G144=3,G144=8),$AD156+$AG156,0)","v":0},{"$f":"IF(OR(H144=1,H144=3,H144=8),$AD156+$AG156,0)","v":0},{"$f":"IF(OR(I144=1,I144=3,I144=8),$AD156+$AG156,0)","v":0},{"$f":"IF(OR(J144=1,J144=3,J144=8),$AD156+$AG156,0)","v":0},{"$f":"IF(OR(K144=1,K144=3,K144=8),$AD156+$AG156,0)","v":0},{"$f":"IF(OR(L144=1,L144=3,L144=8),$AD156+$AG156,0)","v":0},{"$f":"IF(OR(M144=1,M144=3,M144=8),$AD156+$AG156,0)","v":0},{"$f":"IF(OR(N144=1,N144=3,N144=8),$AD156+$AG156,0)","v":0},{"$f":"IF(OR(O144=1,O144=3,O144=8),$AD156+$AG156,0)","v":0},{"$f":"IF(OR(P144=1,P144=3,P144=8),$AD156+$AG156,0)","v":0},{"$f":"IF(OR(Q144=1,Q144=3,Q144=8),$AD156+$AG156,0)","v":0}]
[null,null,null,null,"介護",{"$f":"IF(F145=1,$AJ156+$AM156,0)","v":0},{"$f":"IF(G145=1,$AJ156+$AM156,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"平等割判定用",{"$f":"DMAX(F170:F180,F170,$E$171:$E$172)","v":2},{"$f":"DMAX(G170:G180,G170,$E$171:$E$172)","v":2},2,2,2,2,2,2,2,2,2,2,"加入",{"$f":"MAX(R9,R24,R39,R54,R69,R84,R99,R114,R129,R144)","v":0},"同一",{"$f":"MAX(T9,T24,T39,T54,T69,T84,T99,T114,T129,T144)","v":0}]
[null,null,null,null,"平等割（医療）",{"$f":"IF(F182>0,IF(F159<4,$Q$3*(1-0.1*F$6),IF(F159>5,$Q$3*3/4*(1-0.1*F$6),$Q$3/2*(1-0.1*F$6))),IF(AND(F181=8,F$6<5),$Q$3*0.5,IF(AND(F181=8,F$6>=5),$Q$3*(1-0.1*F$6),0)))","v":0},{"$f":"IF(G182>0,IF(G159<4,$Q$3*(1-0.1*G$6),IF(G159>5,$Q$3*3/4*(1-0.1*G$6),$Q$3/2*(1-0.1*G$6))),IF(AND(G181=8,G$6<5),$Q$3*0.5,IF(AND(G181=8,G$6>=5),$Q$3*(1-0.1*G$6),0)))","v":0},0,0,0,0,0,0,0,0,0,0,"介護",{"$f":"MAX(R10,R25,R40,R55,R70,R85,R100,R115,R130,R145)","v":0},"継続",{"$f":"MAX(T10,T25,T40,T55,T70,T85,T100,T115,T130,T145)","v":0}]
[null,null,null,null,"超過額（医療）",{"$f":"(F21+F36+F51+F66+F81+F96+F111+F126+F141+F156+F160)-$T$3","v":-650000},{"$f":"(G21+G36+G51+G66+G81+G96+G111+G126+G141+G156+G160)-$T$3","v":-650000},{"$f":"(H21+H36+H51+H66+H81+H96+H111+H126+H141+H156+H160)-$T$3","v":-650000},-650000,-650000,-650000,-650000,-650000,-650000,-650000,-650000,-650000]
[null,null,null,null,"限度額超計算用（医療）",{"$f":"IF(F161>0,F161/12,0)","v":0},{"$f":"IF(G161>0,G161/12,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"平等割（後期）",{"$f":"IF(F182>0,IF(F159<4,$AC$3*(1-0.1*F$6),IF(F159>5,$AC$3*3/4*(1-0.1*F$6),$AC$3/2*(1-0.1*F$6))),IF(AND(F181=8,F$6<5),$AC$3*0.5,IF(AND(F181=8,F$6>=5),$AC$3*(1-0.1*F$6),0)))","v":0},{"$f":"IF(G182>0,IF(G159<4,$AC$3*(1-0.1*G$6),IF(G159>5,$AC$3*3/4*(1-0.1*G$6),$AC$3/2*(1-0.1*G$6))),IF(AND(G181=8,G$6<5),$AC$3*0.5,IF(AND(G181=8,G$6>=5),$AC$3*(1-0.1*G$6),0)))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"超過額（後期）",{"$f":"(F22+F37+F52+F67+F82+F97+F112+F127+F142+F157+F163)-$AF$3","v":-220000},{"$f":"(G22+G37+G52+G67+G82+G97+G112+G127+G142+G157+G163)-$AF$3","v":-220000},-220000,-220000,-220000,-220000,-220000,-220000,-220000,-220000,-220000,-220000]
[null,null,null,null,"限度額超計算用（後期）",{"$f":"IF(F164>0,F164/12,0)","v":0},{"$f":"IF(G164>0,G164/12,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"平等割（介護）",{"$f":"IF(MAX(F10,F25,F40,F55,F70,F85,F100,F115,F130,F145)=0,0,$AO$3*(1-0.1*F$6)/12)","v":0},{"$f":"IF(MAX(G10,G25,G40,G55,G70,G85,G100,G115,G130,G145)=0,0,$AO$3*(1-0.1*G$6)/12)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"超過額（介護）",{"$f":"(F23+F38+F53+F68+F83+F98+F113+F128+F143+F158+F166)-$AR$3","v":-170000},{"$f":"(G23+G38+G53+G68+G83+G98+G113+G128+G143+G158+G166)-$AR$3","v":-170000},-170000,-170000,-170000,-170000,-170000,-170000,-170000,-170000,-170000,-170000]
[null,null,null,null,"限度額超計算用（介護）",{"$f":"IF(F167>0,F167/12,0)","v":0},{"$f":"IF(G167>0,G167/12,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(Q167>0,Q167/12,0)","v":0}]
[]
[null,null,null,null,"旧被扶判定用","資格","資格","資格","資格","資格","資格","資格","資格","資格","資格","資格","資格"]
[null,null,null,null,"資格",{"$f":"F9","v":2},{"$f":"G9","v":2},2,2,2,2,2,2,2,2,2,2]
[null,null,null,null,"<8",{"$f":"F24","v":""},{"$f":"G24","v":""},"","","","","","","","","",""]
[null,null,null,null,null,{"$f":"F39","v":""},{"$f":"G39","v":""},"","","","","","","","","",""]
[null,null,null,null,null,{"$f":"F54","v":""},{"$f":"G54","v":""},"","","","","","","","","",""]
[null,null,null,null,null,{"$f":"F69","v":""},{"$f":"G69","v":""},"","","","","","","","","",""]
[null,null,null,null,null,{"$f":"F84","v":""},{"$f":"G84","v":""},"","","","","","","","","",""]
[null,null,null,null,null,{"$f":"F99","v":""},{"$f":"G99","v":""},"","","","","","","","","",""]
[null,null,null,null,null,{"$f":"F114","v":""},{"$f":"G114","v":""},"","","","","","","","","",""]
[null,null,null,null,null,{"$f":"F129","v":0},{"$f":"G129","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"F144","v":0},{"$f":"G144","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"最大値",{"$f":"MAX(F171:F180)","v":2},{"$f":"MAX(G171:G180)","v":2},2,2,2,2,2,2,2,2,2,2]
[null,null,null,null,"旧被扶以外の加入者数",{"$f":"COUNTIF(F171:F180,1)+COUNTIF(F171:F180,3)","v":0},{"$f":"COUNTIF(G171:G180,1)+COUNTIF(G171:G180,3)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"合計",null,{"$f":"SUBTOTAL(9,X9,X24,X39,X54,X69,X84,X99,X114,X129,X144)","v":0},null,null,{"$f":"SUBTOTAL(9,AA9,AA24,AA39,AA54,AA69,AA84,AA99,AA114,AA129,AA144)","v":0},null,null,{"$f":"SUBTOTAL(9,AD9,AD24,AD39,AD54,AD69,AD84,AD99,AD114,AD129,AD144)","v":0},null,null,{"$f":"SUBTOTAL(9,AG9,AG24,AG39,AG54,AG69,AG84,AG99,AG114,AG129,AG144)","v":0},null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"平等割",null,{"$f":"SUM(F160:Q160)/12","v":0},null,null,null,null,null,{"$f":"SUM(F163:Q163)/12","v":0},null,null,null,null,null,{"$f":"SUM(F166:Q166)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"限度超過額",{"$f":"SUM(F162:Q162)","v":0},null,null,null,null,null,{"$f":"SUM(F165:Q165)","v":0},null,null,null,null,null,{"$f":"SUM(F168:Q168)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"賦課額",null,{"$f":"ROUNDDOWN(X184+AA184+X185-X186,-2)","v":0},null,null,null,null,null,{"$f":"ROUNDDOWN(AD184+AG184+AD185-AD186,-2)","v":0},null,null,null,null,null,{"$f":"ROUNDDOWN(AJ184+AM184+AJ185-AJ186,-2)","v":0}]

{"sheet":"軽減計算","index":4,"n_rows":18,"n_cols":17,"rows_kept":18,"cut":false,"hidden":true,"merged":[[17,6,17,8],[17,9,17,10],[15,2,15,3],[15,4,15,5],[15,6,15,8],[15,9,15,10],[16,9,16,10],[16,6,16,8],[13,2,13,3],[13,4,13,5],[13,6,13,8],[13,9,13,10],[14,2,14,3],[14,4,14,5],[14,6,14,8],[14,9,14,10],[11,2,11,3],[11,4,11,5],[11,6,11,8],[11,9,11,10],[12,2,12,3],[12,4,12,5],[12,6,12,8],[12,9,12,10],[9,2,9,3],[9,4,9,5],[9,6,9,8],[9,9,9,10],[10,2,10,3],[10,4,10,5],[10,6,10,8],[10,9,10,10],[7,2,7,3],[7,4,7,5],[7,6,7,8],[7,9,7,10],[8,2,8,3],[8,4,8,5],[8,6,8,8],[8,9,8,10]]}
[]
[null,null,"基準額",null,null,null,null,null,null,null,null,null,null,null,"基準額"]
["７割軽減",null,{"$f":"賦課試算!$AU$2","v":430000},"＋",100000,"×",{"$f":"IF(SUBTOTAL(9,$L$9:$L$16)=0,0,SUBTOTAL(9,$L$9:$L$16)-1)","v":0},"人",null,null,null,null,null,null,{"$f":"C3+E3*G3","v":430000}]
["５割軽減",null,{"$f":"賦課試算!$AU$2","v":430000},"＋",100000,"×",{"$f":"IF(SUBTOTAL(9,$L$9:$L$16)=0,0,SUBTOTAL(9,$L$9:$L$16)-1)","v":0},"人","＋",290000,"×",{"$f":"試算!$X$42","v":0},"人","＝",{"$f":"C4+J4*L4+E4*G4","v":430000}]
["２割軽減",null,{"$f":"賦課試算!$AU$2","v":430000},"＋",100000,"×",{"$f":"IF(SUBTOTAL(9,$L$9:$L$16)=0,0,SUBTOTAL(9,$L$9:$L$16)-1)","v":0},"人","＋",535000,"×",{"$f":"試算!$X$42","v":0},"人","＝",{"$f":"C5+J5*L5+E5*G5","v":430000}]
[]
[]
[null,"年齢","給与所得",null,"年金所得",null,"その他所得",null,null,"判定所得",null,null,null,null,"課税所得","前年度総所得","擬主"]
["世帯主",{"$f":"年金所得計算!B74","v":""},{"$f":"給与所得計算!D26","v":0},null,{"$f":"IF(B9<65,年金所得計算!D74,年金所得計算!D74-150000)","v":-150000},null,{"$f":"試算!AV25","v":0},null,null,{"$f":"C9+E9+G9","v":-150000},null,{"$f":"IF(試算!O20=\"いいえ\",0,IF(OR(C9>0,E9>0),1,0))","v":0},null,null,{"$f":"IF(P9-賦課試算!$AU$2<0,0,P9-賦課試算!$AU$2)","v":0},{"$f":"給与所得計算!D26+年金所得計算!D74+試算!AV25","v":0},{"$f":"IF(試算!O20=\"いいえ\",1,0)","v":0}]
["世帯員１",{"$f":"年金所得計算!B75","v":""},{"$f":"IF(試算!X27<75,給与所得計算!D27,0)","v":0},null,{"$f":"IF(試算!X27<75,\nIF(B10<65,年金所得計算!D75,\nIF(年金所得計算!D75-150000<0,0,年金所得計算!D75-150000)),0)","v":0},null,{"$f":"IF(試算!X27<75,試算!AV27,0)","v":0},null,null,0,null,{"$f":"IF(OR(C10>0,E10>0),1,0)","v":0},null,null,{"$f":"IF(P10-賦課試算!$AU$2<0,0,P10-賦課試算!$AU$2)","v":0},{"$f":"給与所得計算!D27+年金所得計算!D75+試算!AV27","v":0}]
["世帯員２",{"$f":"年金所得計算!B76","v":""},{"$f":"IF(試算!X29<75,給与所得計算!D28,0)","v":0},null,{"$f":"IF(試算!X29<75,\nIF(B11<65,年金所得計算!D76,\nIF(年金所得計算!D76-150000<0,0,年金所得計算!D76-150000)),0)","v":0},null,{"$f":"IF(試算!X29<75,試算!AV29,0)","v":0},null,null,0,null,0,null,null,{"$f":"IF(P11-賦課試算!$AU$2<0,0,P11-賦課試算!$AU$2)","v":0},{"$f":"給与所得計算!D28+年金所得計算!D76+試算!AV29","v":0}]
["世帯員３",{"$f":"年金所得計算!B77","v":""},{"$f":"IF(試算!X31<75,給与所得計算!D29,0)","v":0},null,{"$f":"IF(試算!X31<75,\nIF(B12<65,年金所得計算!D77,\nIF(年金所得計算!D77-150000<0,0,年金所得計算!D77-150000)),0)","v":0},null,{"$f":"IF(試算!X31<75,試算!AV31,0)","v":0},null,null,0,null,0,null,null,{"$f":"IF(P12-賦課試算!$AU$2<0,0,P12-賦課試算!$AU$2)","v":0},{"$f":"給与所得計算!D29+年金所得計算!D77+試算!AV31","v":0}]
["世帯員４",{"$f":"年金所得計算!B78","v":""},{"$f":"IF(試算!X33<75,給与所得計算!D30,0)","v":0},null,{"$f":"IF(試算!X33<75,\nIF(B13<65,年金所得計算!D78,\nIF(年金所得計算!D78-150000<0,0,年金所得計算!D78-150000)),0)","v":0},null,{"$f":"IF(試算!X33<75,試算!AV33,0)","v":0},null,null,0,null,0,null,null,{"$f":"IF(P13-賦課試算!$AU$2<0,0,P13-賦課試算!$AU$2)","v":0},{"$f":"給与所得計算!D30+年金所得計算!D78+試算!AV33","v":0}]
["世帯員５",{"$f":"年金所得計算!B79","v":""},{"$f":"IF(試算!X35<75,給与所得計算!D31,0)","v":0},null,{"$f":"IF(試算!X35<75,\nIF(B14<65,年金所得計算!D79,\nIF(年金所得計算!D79-150000<0,0,年金所得計算!D79-150000)),0)","v":0},null,{"$f":"IF(試算!X35<75,試算!AV35,0)","v":0},null,null,0,null,0,null,null,{"$f":"IF(P14-賦課試算!$AU$2<0,0,P14-賦課試算!$AU$2)","v":0},{"$f":"給与所得計算!D31+年金所得計算!D79+試算!AV35","v":0}]
["世帯員６",{"$f":"年金所得計算!B80","v":""},{"$f":"IF(試算!X37<75,給与所得計算!D32,0)","v":0},null,{"$f":"IF(試算!X37<75,\nIF(B15<65,年金所得計算!D80,\nIF(年金所得計算!D80-150000<0,0,年金所得計算!D80-150000)),0)","v":0},null,{"$f":"IF(試算!X37<75,試算!AV37,0)","v":0},null,null,0,null,0,null,null,{"$f":"IF(P15-賦課試算!$AU$2<0,0,P15-賦課試算!$AU$2)","v":0},{"$f":"給与所得計算!D32+年金所得計算!D80+試算!AV37","v":0}]
["世帯員７",{"$f":"年金所得計算!B81","v":""},{"$f":"IF(試算!X39<75,給与所得計算!D33,0)","v":0},null,{"$f":"IF(試算!X39<75,\nIF(B16<65,年金所得計算!D81,\nIF(年金所得計算!D81-150000<0,0,年金所得計算!D81-150000)),0)","v":0},null,{"$f":"IF(試算!X39<75,試算!AV39,0)","v":0},null,null,0,null,0,null,null,{"$f":"IF(P16-賦課試算!$AU$2<0,0,P16-賦課試算!$AU$2)","v":0},{"$f":"給与所得計算!D33+年金所得計算!D81+試算!AV39","v":0}]
[null,null,null,null,null,null,"判定所得",null,null,{"$f":"SUM(J9:K16)","v":-150000},null,null,null,"計",{"$f":"IF(Q9=1,SUM(O10:O16),SUM(O9:O16))","v":0}]
[null,null,null,null,null,null,"軽減判定",null,null,{"$f":"IF(J17<=O3,7,\nIF(J17<=O4,5,\nIF(J17<=O5,2,0)))","v":7}]

{"sheet":"加入情報","index":5,"n_rows":30,"n_cols":22,"rows_kept":30,"cut":false,"hidden":true,"merged":[[0,0,0,1],[0,2,0,3],[6,0,8,0],[6,1,8,3],[9,0,11,0],[9,1,11,3],[5,0,5,3],[12,0,14,0],[12,1,14,3],[15,0,17,0],[15,1,17,3],[18,0,20,0],[18,1,20,3],[21,0,23,0],[21,1,23,3],[24,0,26,0],[24,1,26,3],[27,0,29,0],[27,1,29,3],[21,4,23,8],[24,4,26,8],[27,4,29,8],[2,19,2,21],[3,19,3,21],[2,15,2,16],[5,4,5,8],[6,4,8,8],[9,4,11,8],[12,4,14,8],[15,4,17,8],[18,4,20,8]]}
["令和",null,{"$f":"試算!D1","v":5},null,"年度　国保加入情報"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"擬主適用",null,{"$f":"IF(試算!O20=\"はい\",0,1)","v":1},"加入月",{"$f":"T4+0","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"加入日",{"$f":"IF(試算!O18<4,\"R\"&$C$1+1&\".\"&試算!O18&\".1\",\"R\"&$C$1&\".\"&試算!O18&\".1\")","v":"R6..1"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"R\"&$C$1&\".5.1\"","v":"R5.5.1"},{"$f":"\"R\"&$C$1&\".6.1\"","v":"R5.6.1"},{"$f":"\"R\"&$C$1&\".7.1\"","v":"R5.7.1"},{"$f":"\"R\"&$C$1&\".8.1\"","v":"R5.8.1"},{"$f":"\"R\"&$C$1&\".9.1\"","v":"R5.9.1"},{"$f":"\"R\"&$C$1&\".10.1\"","v":"R5.10.1"},{"$f":"\"R\"&$C$1&\".11.1\"","v":"R5.11.1"},{"$f":"\"R\"&$C$1&\".12.1\"","v":"R5.12.1"},{"$f":"\"R\"&$C$1+1&\".1.1\"","v":"R6.1.1"},{"$f":"\"R\"&$C$1+1&\".2.1\"","v":"R6.2.1"},{"$f":"\"R\"&$C$1+1&\".3.1\"","v":"R6.3.1"},{"$f":"\"R\"&$C$1+1&\".4.1\"","v":"R6.4.1"}]
[null,null,null,null,"生年月日",null,null,null,null,null,{"$f":"K5-1","v":"2023-04-30"},{"$f":"L5-1","v":"2023-05-31"},"2023-06-30","2023-07-31","2023-08-31","2023-09-30","2023-10-31","2023-11-30","2023-12-31","2024-01-31","2024-02-29","2024-03-31"]
[1,"世帯主",null,null,{"$f":"試算!Q25","v":"年月日"},null,null,null,null,"資格",{"$f":"IF(K8<75,\nIF(K$6<$T$3,0,\nIF($R$3=0,1,2)),2)","v":2},{"$f":"IF(L8<75,\nIF(L$6<$T$3,0,\nIF($R$3=0,1,2)),2)","v":2},2,2,2,2,2,2,2,2,2,2]
[null,null,null,null,null,null,null,null,null,"年齢",{"$f":"IFERROR(DATEDIF($E$7,K$6,\"Y\"),\"\")","v":""},{"$f":"IFERROR(DATEDIF($E$7,L$6,\"Y\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,"年齢",{"$f":"IFERROR(DATEDIF($E$7,K$5,\"Y\"),\"\")","v":""},{"$f":"IFERROR(DATEDIF($E$7,L$5,\"Y\"),\"\")","v":""},"","","","","","","","","",""]
[2,"世帯員",null,null,{"$f":"試算!Q27","v":"年月日"},null,null,null,null,"資格",{"$f":"IF(OR(K11=\"\",K11>74),0,\nIF(K$6<$T$3,0,3))","v":0},{"$f":"IF(OR(L11=\"\",L11>74),0,\nIF(L$6<$T$3,0,3))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"年齢",{"$f":"IFERROR(DATEDIF($E$10,K$6,\"Y\"),\"\")","v":""},{"$f":"IFERROR(DATEDIF($E$10,L$6,\"Y\"),\"\")","v":""},"","","","","","","","","",{"$f":"IFERROR(DATEDIF($E$10,V$6,\"Y\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"年齢",{"$f":"IFERROR(DATEDIF($E$10,K$5,\"Y\"),\"\")","v":""},{"$f":"IFERROR(DATEDIF($E$10,L$5,\"Y\"),\"\")","v":""},"","","","","","","","","",{"$f":"IFERROR(DATEDIF($E$10,V$5,\"Y\"),\"\")","v":""}]
[3,"世帯員",null,null,{"$f":"試算!Q29","v":"年月日"},null,null,null,null,"資格",{"$f":"IF(OR(K14=\"\",K14>74),0,\nIF(K$6<$T$3,0,3))","v":0},{"$f":"IF(OR(L14=\"\",L14>74),0,\nIF(L$6<$T$3,0,3))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"年齢",{"$f":"IFERROR(DATEDIF($E$13,K$6,\"Y\"),\"\")","v":""},{"$f":"IFERROR(DATEDIF($E$13,L$6,\"Y\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,"年齢",{"$f":"IFERROR(DATEDIF($E$13,K$5,\"Y\"),\"\")","v":""},{"$f":"IFERROR(DATEDIF($E$13,L$5,\"Y\"),\"\")","v":""},"","","","","","","","","",""]
[4,"世帯員",null,null,{"$f":"試算!Q31","v":"年月日"},null,null,null,null,"資格",{"$f":"IF(OR(K17=\"\",K17>74),0,\nIF(K$6<$T$3,0,3))","v":0},{"$f":"IF(OR(L17=\"\",L17>74),0,\nIF(L$6<$T$3,0,3))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"年齢",{"$f":"IFERROR(DATEDIF($E$16,K$6,\"Y\"),\"\")","v":""},{"$f":"IFERROR(DATEDIF($E$16,L$6,\"Y\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,"年齢",{"$f":"IFERROR(DATEDIF($E$16,K$5,\"Y\"),\"\")","v":""},{"$f":"IFERROR(DATEDIF($E$16,L$5,\"Y\"),\"\")","v":""},"","","","","","","","","",""]
[5,"世帯員",null,null,{"$f":"試算!Q33","v":"年月日"},null,null,null,null,"資格",{"$f":"IF(OR(K20=\"\",K20>74),0,\nIF(K$6<$T$3,0,3))","v":0},{"$f":"IF(OR(L20=\"\",L20>74),0,\nIF(L$6<$T$3,0,3))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"年齢",{"$f":"IFERROR(DATEDIF($E$19,K$6,\"Y\"),\"\")","v":""},{"$f":"IFERROR(DATEDIF($E$19,L$6,\"Y\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,"年齢",{"$f":"IFERROR(DATEDIF($E$19,K$5,\"Y\"),\"\")","v":""},{"$f":"IFERROR(DATEDIF($E$19,L$5,\"Y\"),\"\")","v":""},"","","","","","","","","",""]
[6,"世帯員",null,null,{"$f":"試算!Q35","v":"年月日"},null,null,null,null,"資格",{"$f":"IF(OR(K23=\"\",K23>74),0,\nIF(K$6<$T$3,0,3))","v":0},{"$f":"IF(OR(L23=\"\",L23>74),0,\nIF(L$6<$T$3,0,3))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"年齢",{"$f":"IFERROR(DATEDIF($E$22,K$6,\"Y\"),\"\")","v":""},{"$f":"IFERROR(DATEDIF($E$22,L$6,\"Y\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,"年齢",{"$f":"IFERROR(DATEDIF($E$22,K$5,\"Y\"),\"\")","v":""},{"$f":"IFERROR(DATEDIF($E$22,L$5,\"Y\"),\"\")","v":""},"","","","","","","","","",""]
[7,"世帯員",null,null,{"$f":"試算!Q37","v":"年月日"},null,null,null,null,"資格",{"$f":"IF(OR(K26=\"\",K26>74),0,\nIF(K$6<$T$3,0,3))","v":0},{"$f":"IF(OR(L26=\"\",L26>74),0,\nIF(L$6<$T$3,0,3))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"年齢",{"$f":"IFERROR(DATEDIF($E$25,K$6,\"Y\"),\"\")","v":""},{"$f":"IFERROR(DATEDIF($E$25,L$6,\"Y\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,"年齢",{"$f":"IFERROR(DATEDIF($E$25,K$5,\"Y\"),\"\")","v":""},{"$f":"IFERROR(DATEDIF($E$25,L$5,\"Y\"),\"\")","v":""},"","","","","","","","","",""]
[8,"世帯員",null,null,{"$f":"試算!Q39","v":"年月日"},null,null,null,null,"資格",{"$f":"IF(OR(K29=\"\",K29>74),0,\nIF(K$6<$T$3,0,3))","v":0},{"$f":"IF(OR(L29=\"\",L29>74),0,\nIF(L$6<$T$3,0,3))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"年齢",{"$f":"IFERROR(DATEDIF($E$28,K$6,\"Y\"),\"\")","v":""},{"$f":"IFERROR(DATEDIF($E$28,L$6,\"Y\"),\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,"年齢",{"$f":"IFERROR(DATEDIF($E$28,K$5,\"Y\"),\"\")","v":""},{"$f":"IFERROR(DATEDIF($E$28,L$5,\"Y\"),\"\")","v":""},"","","","","","","","","",""]

{"sheet":"給与所得計算","index":6,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":true,"merged":[[30,0,30,1],[0,0,1,6],[3,0,3,2],[31,0,31,1],[32,0,32,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1]]}
["給与収入　→　給与所得"]
[]
[null,null,null,null,"世帯主","世帯員１","世帯員２","世帯員３","世帯員４","世帯員５","世帯員６","世帯員７"]
["Aの金額",null,null,"算出方法",{"$f":"C26","v":0},{"$f":"C27","v":0},{"$f":"C28","v":0},{"$f":"C29","v":0},{"$f":"C30","v":0},{"$f":"C31","v":0},{"$f":"C32","v":0},{"$f":"C33","v":0},"⇒給与収入"]
[0,"～",550999,"固定値(0)",{"$f":"IF(AND(E$4>=$A$5,E$4<=$C$5),0,\"\")","v":0},{"$f":"IF(AND(F$4>=$A$5,F$4<=$C$5),0,\"\")","v":0},0,0,0,0,0,0]
[{"$f":"C5+1","v":551000},"～",1618999,"A - 550,000",{"$f":"IF(AND(E$4>=$A$6,E$4<=$C$6),E$4-550000,\"\")","v":""},"","","","","","",""]
[{"$f":"C6+1","v":1619000},"～",{"$f":"C6+1000","v":1619999},"固定値(1,069,000)",{"$f":"IF(AND(E$4>=$A$7,E$4<=$C$7),1069000,\"\")","v":""},"","","","","","",""]
[1620000,"～",{"$f":"C7+2000","v":1621999},"固定値(1,070,000)",{"$f":"IF(AND(E$4>=$A$8,E$4<=$C$8),1070000,\"\")","v":""},"","","","","","",""]
[1622000,"～",{"$f":"C8+2000","v":1623999},"固定値(1,072,000)",{"$f":"IF(AND(E$4>=$A$9,E$4<=$C$9),1072000,\"\")","v":""},"","","","","","",""]
[1624000,"～",{"$f":"C9+4000","v":1627999},"固定値(1,074,000)",{"$f":"IF(AND(E$4>=$A$10,E$4<=$C$10),1074000,\"\")","v":""},"","","","","","",""]
[1628000,"～",1799999,"A' × 60％ ＋ 100,000",{"$f":"IF(AND(E$4>=$A$11,E$4<=$C$11),ROUNDDOWN(E$4/4000,0)*4000*0.6+100000,\"\")","v":""},{"$f":"IF(AND(F$4>=$A$11,F$4<=$C$11),ROUNDDOWN(F$4/4000,0)*4000*0.6+100000,\"\")","v":""},"","","","","","","A’＝A ÷ 4,000（小数点以下切り捨て）× 4,000"]
[1800000,"～",3599999,"A' × 70％ － 80,000",{"$f":"IF(AND(E$4>=$A$12,E$4<=$C$12),ROUNDDOWN(E$4/4000,0)*4000*0.7-80000,\"\")","v":""},{"$f":"IF(AND(F$4>=$A$12,F$4<=$C$12),ROUNDDOWN(F$4/4000,0)*4000*0.7-80000,\"\")","v":""},{"$f":"IF(AND(G$4>=$A$12,G$4<=$C$12),ROUNDDOWN(G$4/4000,0)*4000*0.7-80000,\"\")","v":""},{"$f":"IF(AND(H$4>=$A$12,H$4<=$C$12),ROUNDDOWN(H$4/4000,0)*4000*0.7-80000,\"\")","v":""},{"$f":"IF(AND(I$4>=$A$12,I$4<=$C$12),ROUNDDOWN(I$4/4000,0)*4000*0.7-80000,\"\")","v":""},"","","","A’＝A ÷ 4,000（小数点以下切り捨て）× 4,000"]
[3600000,"～",6599999,"A' × 80％ － 440,000",{"$f":"IF(AND(E$4>=$A$13,E$4<=$C$13),ROUNDDOWN(E$4/4000,0)*4000*0.8-440000,\"\")","v":""},{"$f":"IF(AND(F$4>=$A$13,F$4<=$C$13),ROUNDDOWN(F$4/4000,0)*4000*0.8-440000,\"\")","v":""},"","","","","","","A’＝A ÷ 4,000（小数点以下切り捨て）× 4,000"]
[6600000,"～",8499999,"A × 0.9 - 1,100,000",{"$f":"IF(AND(E$4>=$A$14,E$4<=$C$14),E$4*0.9-1100000,\"\")","v":""},"","","","","","",""]
[{"$f":"C14+1","v":8500000},"～",999999999,"A-1,950,000",{"$f":"IF(AND(E$4>=$A$15,E$4<=$C$15),E$4-1950000,\"\")","v":""},"","","","","","",""]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
[]
[null,null,"給与収入","給与所得","所得金額調整控除","調整後給与所得"]
["世帯主",null,{"$f":"試算!Z25","v":0},{"$f":"MAX(E5:E23)","v":0},{"$f":"所得金額調整控除計算!H4","v":0},{"$f":"D26-E26","v":0}]
["世帯員１",null,{"$f":"試算!Z27","v":0},{"$f":"MAX(F5:F23)","v":0},{"$f":"所得金額調整控除計算!H5","v":0},{"$f":"D27-E27","v":0}]
["世帯員２",null,{"$f":"試算!Z29","v":0},{"$f":"MAX(G5:G23)","v":0},{"$f":"所得金額調整控除計算!H6","v":0},0]
["世帯員３",null,{"$f":"試算!Z31","v":0},{"$f":"MAX(H5:H23)","v":0},{"$f":"所得金額調整控除計算!H7","v":0},0]
["世帯員４",null,{"$f":"試算!Z33","v":0},{"$f":"MAX(I5:I23)","v":0},{"$f":"所得金額調整控除計算!H8","v":0},0]
["世帯員５",null,{"$f":"試算!Z35","v":0},{"$f":"MAX(J5:J23)","v":0},{"$f":"所得金額調整控除計算!H9","v":0},0]
["世帯員６",null,{"$f":"試算!Z37","v":0},{"$f":"MAX(K5:K23)","v":0},{"$f":"所得金額調整控除計算!H10","v":0},0]
["世帯員７",null,{"$f":"試算!Z39","v":0},{"$f":"MAX(L5:L23)","v":0},{"$f":"所得金額調整控除計算!H11","v":0},0]

{"sheet":"賦課額表示","index":7,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[{"$f":"賦課試算!A1&\"年度\"","v":"R5年度"},"医　療","後　期","介　護","合　計"]
["賦 課 額",{"$f":"賦課試算!X187","v":0},{"$f":"賦課試算!AD187","v":0},{"$f":"賦課試算!AJ187","v":0},{"$f":"SUM(B2:D2)","v":0}]

{"sheet":"年金所得計算","index":8,"n_rows":81,"n_cols":13,"rows_kept":81,"cut":false,"hidden":true,"merged":[[50,0,50,2],[61,0,61,2],[71,4,71,7],[4,0,4,2],[0,0,1,3],[15,0,15,2],[27,0,27,2],[38,0,38,2]]}
["年金収入　→　年金所得"]
[]
["〇公的年金等雑所得以外の所得に係る合計所得金額　1,000万円以下"]
["65歳未満",null,null,null,"世帯主","世帯員１","世帯員２","世帯員３","世帯員４","世帯員５","世帯員６","世帯員７"]
["Aの金額",null,null,"算出方法",{"$f":"C$74","v":0},{"$f":"C$75","v":0},{"$f":"C$76","v":0},{"$f":"C$77","v":0},{"$f":"C$78","v":0},{"$f":"C$79","v":0},{"$f":"C$80","v":0},{"$f":"C$81","v":0},"⇒年金収入"]
[0,"～",1300000,"A - 600,000",{"$f":"IF(AND(E$5>=$A$6,E$5<=$C$6),\n    IF(E$5-600000<0,0,E$5-600000),\"\")","v":0},0,0,0,0,0,0,0]
[{"$f":"C6+1","v":1300001},"～",4100000,"A × 0.75－275,000",{"$f":"IF(AND(E$5>=$A$7,E$5<=$C$7),E$5*0.75-275000,\"\")","v":""},"","","","","","",""]
[{"$f":"C7+1","v":4100001},"～",7700000,"A × 0.85－685,000",{"$f":"IF(AND(E$5>=$A$8,E$5<=$C$8),E$5*0.85-685000,\"\")","v":""},"","","","","","",""]
[{"$f":"C8+1","v":7700001},"～",10000000,"A × 0.95－1,455,000",{"$f":"IF(AND(E$5>=$A$9,E$5<=$C$9),E$5*0.95-1455000,\"\")","v":""},"","","","","","",""]
[{"$f":"C9+1","v":10000001},null,999999999,"A - 1,955,000",{"$f":"IF(AND(E$5>=$A$10,E$5<=$C$10),E$5-1955000,\"\")","v":""},{"$f":"IF(AND(F$5>=$A$10,F$5<=$C$10),F$5-1955000,\"\")","v":""},{"$f":"IF(AND(G$5>=$A$10,G$5<=$C$10),G$5-1955000,\"\")","v":""},"","","","",{"$f":"IF(AND(L$5>=$A$10,L$5<=$C$10),L$5-1955000,\"\")","v":""}]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
[]
["65歳以上",null,null,null,"世帯主","世帯員１","世帯員２","世帯員３","世帯員４","世帯員５","世帯員６","世帯員７"]
["Aの金額",null,null,"算出方法",{"$f":"C$74","v":0},{"$f":"C$75","v":0},{"$f":"C$76","v":0},{"$f":"C$77","v":0},{"$f":"C$78","v":0},{"$f":"C$79","v":0},{"$f":"C$80","v":0},{"$f":"C$81","v":0},"⇒年金収入"]
[0,"～",3300000,"A - 1,100,000",{"$f":"IF(AND(E$16>=$A$17,E$16<=$C$17),\n    IF(E$16-1100000<0,0,E$16-1100000),\"\")","v":0},0,0,0,0,0,0,0]
[{"$f":"C17+1","v":3300001},"～",4100000,"A × 0.75－275,000",{"$f":"IF(AND(E$16>=$A$18,E$16<=$C$18),E$16*0.75-275000,\"\")","v":""},"","","","","","",""]
[{"$f":"C18+1","v":4100001},"～",7700000,"A × 0.85－685,000",{"$f":"IF(AND(E$16>=$A$19,E$16<=$C$19),E$16*0.85-685000,\"\")","v":""},"","","","","","",""]
[{"$f":"C19+1","v":7700001},"～",10000000,"A × 0.95－1,455,000",{"$f":"IF(AND(E$16>=$A$20,E$16<=$C$20),E$16*0.95-1455000,\"\")","v":""},"","","","","","",""]
[{"$f":"C20+1","v":10000001},null,999999999,"A - 1,955,000",{"$f":"IF(AND(E$16>=$A$21,E$16<=$C$21),E$16-1955000,\"\")","v":""},{"$f":"IF(AND(F$16>=$A$21,F$16<=$C$21),F$16-1955000,\"\")","v":""},"","","","","",""]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
[]
["〇公的年金等雑所得以外の所得に係る合計所得金額　1,000万円超　2,000万円以下"]
["65歳未満",null,null,null,"世帯主","世帯員１","世帯員２","世帯員３","世帯員４","世帯員５","世帯員６","世帯員７"]
["Aの金額",null,null,"算出方法",{"$f":"C$74","v":0},{"$f":"C$75","v":0},{"$f":"C$76","v":0},{"$f":"C$77","v":0},{"$f":"C$78","v":0},{"$f":"C$79","v":0},{"$f":"C$80","v":0},{"$f":"C$81","v":0},"⇒年金収入"]
[0,"～",1300000,"A - 500,000",{"$f":"IF(AND(E$28>=$A$29,E$28<=$C$29),\n    IF(E$28-500000<0,0,E$28-500000),\"\")","v":0},{"$f":"IF(AND(F$28>=$A$29,F$5<=$C$29),\n    IF(F$5-500000<0,0,F$5-500000),\"\")","v":0},0,0,0,0,0,{"$f":"IF(AND(L$28>=$A$29,L$5<=$C$29),\n    IF(L$5-500000<0,0,L$5-500000),\"\")","v":0}]
[{"$f":"C29+1","v":1300001},"～",4100000,"A × 0.75－175,000",{"$f":"IF(AND(E$28>=$A$30,E$28<=$C$30),E$28*0.75-175000,\"\")","v":""},{"$f":"IF(AND(F$28>=$A$30,F$5<=$C$30),F$5*0.75-175000,\"\")","v":""},"","","","","",""]
[{"$f":"C30+1","v":4100001},"～",7700000,"A × 0.85－585,000",{"$f":"IF(AND(E$28>=$A$31,E$28<=$C$31),E$28*0.85-585000,\"\")","v":""},{"$f":"IF(AND(F$5>=$A$8,F$5<=$C$8),F$5*0.85-585000,\"\")","v":""},"","","","","",""]
[{"$f":"C31+1","v":7700001},"～",10000000,"A × 0.95－1,355,000",{"$f":"IF(AND(E$28>=$A$32,E$28<=$C$32),E$28*0.95-1355000,\"\")","v":""},{"$f":"IF(AND(F$28>=$A$32,F$28<=$C$32),F$28*0.95-1355000,\"\")","v":""},"","","","","",""]
[{"$f":"C32+1","v":10000001},null,999999999,"A - 1,855,000",{"$f":"IF(AND(E$28>=$A$33,E$28<=$C$33),E$28-1855000,\"\")","v":""},{"$f":"IF(AND(F$28>=$A$33,F$28<=$C$33),F$28-1855000,\"\")","v":""},"","",{"$f":"IF(AND(I$28>=$A$33,I$28<=$C$33),I$28-1855000,\"\")","v":""},"","",""]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
[]
["65歳以上",null,null,null,"世帯主","世帯員１","世帯員２","世帯員３","世帯員４","世帯員５","世帯員６","世帯員７"]
["Aの金額",null,null,"算出方法",{"$f":"C$74","v":0},{"$f":"C$75","v":0},{"$f":"C$76","v":0},{"$f":"C$77","v":0},{"$f":"C$78","v":0},{"$f":"C$79","v":0},{"$f":"C$80","v":0},{"$f":"C$81","v":0},"⇒年金収入"]
[0,"～",3300000,"A - 1,000,000",{"$f":"IF(AND(E$39>=$A$40,E$39<=$C$40),\n    IF(E$39-1000000<0,0,E$39-1000000),\"\")","v":0},{"$f":"IF(AND(F$39>=$A$40,F$39<=$C$40),\n    IF(F$39-1000000<0,0,F$39-1000000),\"\")","v":0},0,0,0,0,0,0]
[{"$f":"C40+1","v":3300001},"～",4100000,"A × 0.75－175,000",{"$f":"IF(AND(E$39>=$A$41,E$39<=$C$41),E$39*0.75-175000,\"\")","v":""},{"$f":"IF(AND(F$39>=$A$41,F$39<=$C$41),F$39*0.75-175000,\"\")","v":""},"","","","","",""]
[{"$f":"C41+1","v":4100001},"～",7700000,"A × 0.85－585,000",{"$f":"IF(AND(E$39>=$A$42,E$39<=$C$42),E$39*0.85-585000,\"\")","v":""},{"$f":"IF(AND(F$39>=$A$42,F$39<=$C$42),F$39*0.85-585000,\"\")","v":""},"","","","","",""]
[{"$f":"C42+1","v":7700001},"～",10000000,"A × 0.95－1,355,000",{"$f":"IF(AND(E$39>=$A$43,E$39<=$C$43),E$39*0.95-1355000,\"\")","v":""},{"$f":"IF(AND(F$39>=$A$43,F$39<=$C$43),F$39*0.95-1355000,\"\")","v":""},"","","","","",""]
[{"$f":"C43+1","v":10000001},null,999999999,"A - 1,855,000",{"$f":"IF(AND(E$39>=$A$44,E$39<=$C$44),E$39-1855000,\"\")","v":""},{"$f":"IF(AND(F$39>=$A$44,F$39<=$C$44),F$39-1855000,\"\")","v":""},"","","","","",""]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
[]
["〇公的年金等雑所得以外の所得に係る合計所得金額　2,000万円超"]
["65歳未満",null,null,null,"世帯主","世帯員１","世帯員２","世帯員３","世帯員４","世帯員５","世帯員６","世帯員７"]
["Aの金額",null,null,"算出方法",{"$f":"C$74","v":0},{"$f":"C$75","v":0},{"$f":"C$76","v":0},{"$f":"C$77","v":0},{"$f":"C$78","v":0},{"$f":"C$79","v":0},{"$f":"C$80","v":0},{"$f":"C$81","v":0},"⇒年金収入"]
[0,"～",1300000,"A - 400,000",{"$f":"IF(AND(E$51>=$A$52,E$51<=$C$52),\n    IF(E$51-400000<0,0,E$51-400000),\"\")","v":0},{"$f":"IF(AND(F$51>=$A$52,F$51<=$C$52),\n    IF(F$51-400000<0,0,F$51-400000),\"\")","v":0},0,0,0,0,0,0]
[{"$f":"C52+1","v":1300001},"～",4100000,"A × 0.75－75,000",{"$f":"IF(AND(E$51>=$A$53,E$51<=$C$53),E$51*0.75-75000,\"\")","v":""},{"$f":"IF(AND(F$51>=$A$53,F$51<=$C$53),F$51*0.75-75000,\"\")","v":""},{"$f":"IF(AND(G$51>=$A$53,G$51<=$C$53),G$51*0.75-75000,\"\")","v":""},"","","","",""]
[{"$f":"C53+1","v":4100001},"～",7700000,"A × 0.85－485,000",{"$f":"IF(AND(E$51>=$A$54,E$51<=$C$54),E$51*0.85-485000,\"\")","v":""},{"$f":"IF(AND(F$51>=$A$54,F$51<=$C$54),F$51*0.85-485000,\"\")","v":""},"","","","","",""]
[{"$f":"C54+1","v":7700001},"～",10000000,"A × 0.95－1,255,000",{"$f":"IF(AND(E$51>=$A$55,E$51<=$C$55),E$51*0.95-1255000,\"\")","v":""},{"$f":"IF(AND(F$51>=$A$55,F$51<=$C$55),F$51*0.95-1255000,\"\")","v":""},"","","","","",""]
[{"$f":"C55+1","v":10000001},null,999999999,"A - 1,755,000",{"$f":"IF(AND(E$51>=$A$56,E$51<=$C$56),E$51-1755000,\"\")","v":""},{"$f":"IF(AND(F$51>=$A$56,F$51<=$C$56),F$51-1755000,\"\")","v":""},"","","","","",""]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
[]
["65歳以上",null,null,null,"世帯主","世帯員１","世帯員２","世帯員３","世帯員４","世帯員５","世帯員６","世帯員７"]
["Aの金額",null,null,"算出方法",{"$f":"C$74","v":0},{"$f":"C$75","v":0},{"$f":"C$76","v":0},{"$f":"C$77","v":0},{"$f":"C$78","v":0},{"$f":"C$79","v":0},{"$f":"C$80","v":0},{"$f":"C$81","v":0},"⇒年金収入"]
[0,"～",3300000,"A - 900,000",{"$f":"IF(AND(E$62>=$A$63,E$62<=$C$63),\n    IF(E$62-900000<0,0,E$62-900000),\"\")","v":0},{"$f":"IF(AND(F$62>=$A$63,F$62<=$C$63),\n    IF(F$62-900000<0,0,F$62-900000),\"\")","v":0},0,0,0,0,0,0]
[{"$f":"C63+1","v":3300001},"～",4100000,"A × 0.75－75,000",{"$f":"IF(AND(E$62>=$A$64,E$62<=$C$64),E$62*0.75-75000,\"\")","v":""},{"$f":"IF(AND(F$62>=$A$64,F$62<=$C$64),F$62*0.75-75000,\"\")","v":""},"","","","","",""]
[{"$f":"C64+1","v":4100001},"～",7700000,"A × 0.85－485,000",{"$f":"IF(AND(E$62>=$A$65,E$62<=$C$65),E$62*0.85-485000,\"\")","v":""},{"$f":"IF(AND(F$62>=$A$65,F$62<=$C$65),F$62*0.85-485000,\"\")","v":""},"","","","","",""]
[{"$f":"C65+1","v":7700001},"～",10000000,"A × 0.95－1,255,000",{"$f":"IF(AND(E$62>=$A$66,E$62<=$C$66),E$62*0.95-1255000,\"\")","v":""},{"$f":"IF(AND(F$62>=$A$66,F$62<=$C$66),F$62*0.95-1255000,\"\")","v":""},"","","","","",""]
[{"$f":"C66+1","v":10000001},null,999999999,"A - 1,755,000",{"$f":"IF(AND(E$62>=$A$67,E$62<=$C$67),E$62-1755000,\"\")","v":""},{"$f":"IF(AND(F$62>=$A$67,F$62<=$C$67),F$62-1755000,\"\")","v":""},"","","","","",""]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
["予備",null,"予備","予備","予備","予備","予備","予備","予備","予備","予備","予備"]
[]
[null,null,null,null,"公的年金以外の合計所得"]
[null,"年齢","年金収入","年金所得","1,000万以下","2,000万以下","2,000万超","所得額"]
["世帯主",{"$f":"試算!V25","v":""},{"$f":"試算!AK25","v":0},{"$f":"IF(H74<=10000000,E74,IF(H74>20000000,G74,F74))","v":0},{"$f":"IF($B$74<65,MAX($E6:$E13),MAX($E17:$E24))","v":0},{"$f":"IF($B$74<65,MAX($E29:$E36),MAX($E40:$E47))","v":0},{"$f":"IF($B$74<65,MAX($E52:$E59),MAX($E63:$E70))","v":0},{"$f":"給与所得計算!D26+試算!AV25","v":0}]
["世帯員１",{"$f":"試算!V27","v":""},{"$f":"試算!AK27","v":0},{"$f":"IF(H75<=10000000,E75,IF(H75>20000000,G75,F75))","v":0},{"$f":"IF($B$75<65,MAX($F6:$F13),MAX($F17:$F24))","v":0},{"$f":"IF($B$75<65,MAX($F29:$F36),MAX($F40:$F47))","v":0},{"$f":"IF($B$75<65,MAX($F52:$F59),MAX($F63:$F70))","v":0},{"$f":"給与所得計算!D27+試算!AV27","v":0}]
["世帯員２",{"$f":"試算!V29","v":""},{"$f":"試算!AK29","v":0},0,{"$f":"IF($B$76<65,MAX($G6:$G13),MAX($G17:$G24))","v":0},{"$f":"IF($B$76<65,MAX($G29:$G36),MAX($G40:$G47))","v":0},{"$f":"IF($B$76<65,MAX($G52:$G59),MAX($G63:$G70))","v":0},{"$f":"給与所得計算!D28+試算!AV29","v":0}]
["世帯員３",{"$f":"試算!V31","v":""},{"$f":"試算!AK31","v":0},0,{"$f":"IF($B77<65,MAX($H6:$H13),MAX($H17:$H24))","v":0},{"$f":"IF($B77<65,MAX($H29:$H36),MAX($H40:$H47))","v":0},{"$f":"IF($B77<65,MAX($H52:$H59),MAX($H63:$H70))","v":0},{"$f":"給与所得計算!D29+試算!AV31","v":0}]
["世帯員４",{"$f":"試算!V33","v":""},{"$f":"試算!AK33","v":0},0,{"$f":"IF($B$78<65,MAX($I6:$I13),MAX($I17:$I24))","v":0},{"$f":"IF($B$78<65,MAX($I29:$I36),MAX($I40:$I47))","v":0},{"$f":"IF($B$78<65,MAX($I52:$I59),MAX($I63:$I70))","v":0},{"$f":"給与所得計算!D30+試算!AV33","v":0}]
["世帯員５",{"$f":"試算!V35","v":""},{"$f":"試算!AK35","v":0},0,{"$f":"IF($B$79<65,MAX($J6:$J13),MAX($J17:$J24))","v":0},{"$f":"IF($B$79<65,MAX($J29:$J36),MAX($J40:$J47))","v":0},{"$f":"IF($B$79<65,MAX($J52:$J59),MAX($J63:$J70))","v":0},{"$f":"給与所得計算!D31+試算!AV35","v":0}]
["世帯員６",{"$f":"試算!V37","v":""},{"$f":"試算!AK37","v":0},0,{"$f":"IF($B$80<65,MAX($K6:$K13),MAX($K17:$K24))","v":0},{"$f":"IF($B$80<65,MAX($K29:$K36),MAX($K40:$K47))","v":0},{"$f":"IF($B$80<65,MAX($K52:$K59),MAX($K63:$K70))","v":0},{"$f":"給与所得計算!D32+試算!AV37","v":0}]
["世帯員７",{"$f":"試算!V39","v":""},{"$f":"試算!AK39","v":0},0,{"$f":"IF($B$81<65,MAX($L6:$L13),MAX($L17:$L24))","v":0},{"$f":"IF($B$81<65,MAX($L29:$L36),MAX($L40:$L47))","v":0},{"$f":"IF($B$81<65,MAX($L52:$L59),MAX($L63:$L70))","v":0},{"$f":"給与所得計算!D33+試算!AV39","v":0}]

{"sheet":"所得金額調整控除計算","index":9,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,4,1,7],[1,3,2,3],[3,0,3,1],[4,0,4,1],[5,0,5,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[1,0,2,1],[1,2,2,2],[6,0,6,1],[7,0,7,1]]}
["所得金額調整控除"]
[null,null,"給与所得","年金所得","所得金額調整控除計算"]
[null,null,null,null,"給与所得","年金所得","該当有無","所得金額調整控除額"]
["世帯主",null,{"$f":"給与所得計算!D26","v":0},{"$f":"年金所得計算!D74","v":0},{"$f":"IF(C4>=100000,100000,C4)","v":0},{"$f":"IF(D4>=100000,100000,D4)","v":0},{"$f":"IF(AND(E4>0,F4>0,E4+F4>=100000),\"有\",\"無\")","v":"無"},{"$f":"IF(G4=\"有\",E4+F4-100000,0)","v":0}]
["世帯員１",null,{"$f":"給与所得計算!D27","v":0},{"$f":"年金所得計算!D75","v":0},{"$f":"IF(C5>=100000,100000,C5)","v":0},{"$f":"IF(D5>=100000,100000,D5)","v":0},{"$f":"IF(AND(E5>0,F5>0,E5+F5>=100000),\"有\",\"無\")","v":"無"},{"$f":"IF(G5=\"有\",E5+F5-100000,0)","v":0}]
["世帯員２",null,{"$f":"給与所得計算!D28","v":0},{"$f":"年金所得計算!D76","v":0},0,0,"無",0]
["世帯員３",null,{"$f":"給与所得計算!D29","v":0},{"$f":"年金所得計算!D77","v":0},0,0,"無",0]
["世帯員４",null,{"$f":"給与所得計算!D30","v":0},{"$f":"年金所得計算!D78","v":0},0,0,"無",0]
["世帯員５",null,{"$f":"給与所得計算!D31","v":0},{"$f":"年金所得計算!D79","v":0},0,0,"無",0]
["世帯員６",null,{"$f":"給与所得計算!D32","v":0},{"$f":"年金所得計算!D80","v":0},0,0,"無",0]
["世帯員７",null,{"$f":"給与所得計算!D33","v":0},{"$f":"年金所得計算!D81","v":0},0,0,"無",0]