{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["入力","設定","年金条件式","給与所得","資格取得月","計算"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"入力","index":0,"n_rows":60,"n_cols":32,"rows_kept":60,"cut":false,"hidden":false,"merged":[[59,3,60,7],[59,8,60,30],[45,25,45,31],[41,2,41,6],[41,7,41,10],[41,11,41,16],[41,18,41,23],[41,25,41,30],[55,17,56,30],[50,29,50,30],[52,9,53,14],[50,3,50,15],[50,26,50,27],[50,16,50,21],[50,24,50,25],[52,7,53,7],[58,3,58,7],[58,8,58,15],[58,17,58,30],[52,16,53,16],[52,17,53,30],[54,3,54,7],[52,8,53,8],[52,15,53,15],[54,17,54,30],[54,8,54,15],[57,3,57,7],[57,8,57,15],[57,17,57,30],[55,3,56,7],[55,8,56,15],[55,16,56,16],[30,2,30,6],[31,2,31,6],[30,7,30,10],[31,7,31,10],[45,11,45,17],[52,3,53,3],[52,4,53,6],[49,21,49,28],[46,11,46,16],[46,18,46,23],[46,25,46,30],[48,4,48,15],[48,18,48,29],[46,2,46,6],[46,7,46,10],[45,18,45,24],[45,2,45,6],[45,7,45,10],[35,18,35,24],[35,25,35,31],[36,2,36,6],[36,7,36,10],[36,11,36,16],[36,18,36,23],[36,25,36,30],[35,2,35,6],[35,7,35,10],[35,11,35,17],[40,2,40,6],[40,7,40,10],[40,11,40,17],[40,18,40,24],[40,25,40,31],[30,18,30,24],[30,25,30,31],[31,11,31,16],[31,18,31,23],[31,25,31,30],[30,11,30,17]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"■試算する被保険者の情報"]
[]
[null,null,"被保険者となった月",null,null,null,null,"(令和4年1月1日時点)",null,null,null,"年金収入（年額）",null,null,null,null,null,null,"給与収入（年額）",null,null,null,null,null,null,"  その他の所得（年額）"]
[null,null,"(選択してください)",null,null,null,null,"(選択してください)",null,null,null,null,null,null,null,null,null,"円",null,null,null,null,null,null,"円",null,null,null,null,null,null,"円"]
[]
[null,null,"■同じ世帯の他の被保険者情報１"]
[]
[null,null,"同じ世帯に他の被保険者がいる\n場合はチェックし、右記を入力",null,null,null,null,"(令和4年1月1日時点)",null,null,null,"年金収入（年額）",null,null,null,null,null,null,"給与収入（年額）",null,null,null,null,null,null,"  その他の所得（年額）"]
[null,null,null,null,null,null,null,"(選択してください)",null,null,null,null,null,null,null,null,null,"円",null,null,null,null,null,null,"円",null,null,null,null,null,null,"円"]
[]
[null,null,"■同じ世帯の他の被保険者情報２"]
[]
[null,null,"同じ世帯に他の被保険者がいる\n場合はチェックし、右記を入力",null,null,null,null,"(令和4年1月1日時点)",null,null,null,"年金収入（年額）",null,null,null,null,null,null,"給与収入（年額）",null,null,null,null,null,null,"  その他の所得（年額）"]
[null,null,null,null,null,null,null,"(選択してください)",null,null,null,null,null,null,null,null,null,"円",null,null,null,null,null,null,"円",null,null,null,null,null,null,"円"]
[]
[null,null,"■世帯主情報"]
[]
[null,null,"世帯主が被保険者以外の場合はチェックし、右記を入力",null,null,null,null,"(令和4年1月1日時点)",null,null,null,"年金収入（年額）",null,null,null,null,null,null,"給与収入（年額）",null,null,null,null,null,null,"  その他の所得（年額）"]
[null,null,null,null,null,null,null,"(選択してください)",null,null,null,null,null,null,null,null,null,"円",null,null,null,null,null,null,"円",null,null,null,null,null,null,"円"]
[]
[null,null,null,null,"保険料試算",null,null,null,null,null,null,null,null,null,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":"\"(試算日:\"&TEXT(TODAY(),\"ggge年m月d日\"&\")\")","v":"(試算日:令和4年3月30日)"}]
[null,null,null,"あなたの令和４年度の保険料額の試算結果は",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"計算!N3","v":"資格取得月入力エラー"},null,null,null,null,null,"円","(",{"$f":"IF(I55=\"資格取得月入力エラー\",\"***\",I55)","v":"***"},null,"ヶ月分",null,")","です。"]
[]
[null,null,null,null,"軽減割合",null,null,null,{"$f":"計算!D17","v":"年齢選択エラー"},{"$f":"IF(I53=\"年齢選択エラー\",\"年齢選択エラー\",IF(I53=\"\",0,VLOOKUP(I53,設定!$A$32:$B$37,2,0)))","v":"年齢選択エラー"},null,null,null,null,null,null,"割","世帯の所得によって均等割額の軽減割合が判定\nされます(7割,5割,2割または軽減なし)。"]
[]
[null,null,null,"賦課月数➀",null,null,null,null,{"$f":"設定!C2","v":"資格取得月入力エラー"},null,null,null,null,null,null,null,"月","保険料試算の加入月数です（12月未満の場合\nは、月数に応じて、試算結果から減額されます）。"]
[null,null,null,"均等割額②",null,null,null,null,{"$f":"IF(計算!J3=\"年齢選択エラー\",\"年齢選択エラー\",計算!F3-計算!J3)","v":"年齢選択エラー"},null,null,null,null,null,null,null,"円","令和４年度の均等割額は44,170円です。\n※軽減に該当する場合は軽減後の金額です。"]
[]
[null,null,null,"所得割額③",null,null,null,null,{"$f":"計算!E3","v":0},null,null,null,null,null,null,null,"円","被保険者の所得に応じて負担いただく額です。"]
[null,null,null,"所得割率④",null,null,null,null,8.3800000000000008,null,null,null,null,null,null,null,"%","所得割率は埼玉県内で均一です。 "]
[null,null,null,"備考",null,null,null,null,"※②と③は、それぞれ10円未満の端数を切捨てます。\n※保険料額は、②と③を合計して、100円未満の端数を切捨てます。\n※令和4年度の保険料額の限度額は、年額66万円になります。"]

{"sheet":"設定","index":1,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[null,"資格取得月","月数","年金所得","給与所得","その他の所得","所得金額調整控除額","高齢者特別控除","所得金額調整控除(軽減判定所得用)","軽減判定所得1","年金給与所得者の数"]
["被保険者",{"$f":"IF(OR(入力!C32=\"(選択してください)\",ISBLANK(入力!C32)),\"資格取得月入力エラー\",入力!C32)","v":"資格取得月入力エラー"},{"$f":"IF(B2=\"資格取得月入力エラー\",\"資格取得月入力エラー\",VLOOKUP(B2,資格取得月!$A$2:$B$13,2,0))","v":"資格取得月入力エラー"},{"$f":"年金条件式!I3","v":0},{"$f":"VLOOKUP(入力!S32,給与所得!$B$3:$C$14,2)","v":0},{"$f":"入力!Z32","v":0},{"$f":"IF(MIN(100000,D2)+MIN(100000,E2)-100000<0,0,MIN(100000,D2)+MIN(100000,E2)-100000)","v":0},{"$f":"IF(入力!H32=\"65歳以上\",MIN(150000,D2),0)","v":0},{"$f":"IF(MIN(100000,D2-H2)+MIN(100000,E2)-100000<0,0,MIN(100000,D2-H2)+MIN(100000,E2)-100000)","v":0},{"$f":"IF(入力!C32=\"\",0,IF(入力!H32=\"(選択してください)\",\"年齢選択エラー\",IF(入力!H32=\"\",\"年齢選択エラー\",(MAX(SUM(D2-H2+E2-I2+F2),0)))))","v":"年齢選択エラー"},{"$f":"IF(入力!C32=\"\",0,IF(入力!H32=\"(選択してください)\",\"年齢選択エラー\",IF(入力!H32=\"\",\"年齢選択エラー\",IF(E2+D2-H2>0,1,IF(E2>0,0,IF(入力!S32>550000,1,0))))))","v":"年齢選択エラー"}]
[]
[null,"チェックボックス","年金所得","給与所得","その他の所得","所得金額調整控除額","高齢者特別控除","所得金額調整控除(軽減判定所得用)","軽減判定所得2","年金給与所得者の数"]
["家族１",{"$f":"IF(入力!C37=\"v\",1,0)","v":0},{"$f":"IF(入力!C37=\"v\",年金条件式!I4,0)","v":0},{"$f":"VLOOKUP(入力!S37,給与所得!$B$18:$C$29,2)","v":0},{"$f":"入力!Z37","v":0},{"$f":"IF(MIN(100000,C5)+MIN(100000,D5)-100000<0,0,MIN(100000,C5)+MIN(100000,D5)-100000)","v":0},{"$f":"IF(入力!H37=\"65歳以上\",MIN(150000,C5),0)","v":0},{"$f":"IF(MIN(100000,C5-G5)+MIN(100000,D5)-100000<0,0,MIN(100000,C5-G5)+MIN(100000,D5)-100000)","v":0},{"$f":"IF(入力!C37=\"\",0,IF(入力!H37=\"(選択してください)\",\"年齢選択エラー\",IF(入力!H37=\"\",\"年齢選択エラー\",(MAX(SUM(C5:E5)-H5-G5,0)))))","v":0},{"$f":"IF(入力!C37=\"\",0,IF(入力!H37=\"(選択してください)\",\"年齢選択エラー\",IF(入力!H37=\"\",\"年齢選択エラー\",IF(D5+C5-G5>0,1,IF(D5=0,IF(入力!S37>550000,1,0),0)))))","v":0}]
["家族２",{"$f":"IF(入力!C42=\"v\",1,0)","v":0},{"$f":"IF(入力!C42=\"v\",年金条件式!I5,0)","v":0},{"$f":"VLOOKUP(入力!S42,給与所得!$B$33:$C$44,2)","v":0},{"$f":"入力!Z42","v":0},{"$f":"IF(MIN(100000,C6)+MIN(100000,D6)-100000<0,0,MIN(100000,C6)+MIN(100000,D6)-100000)","v":0},{"$f":"IF(入力!H42=\"65歳以上\",MIN(150000,C6),0)","v":0},{"$f":"IF(MIN(100000,C6-G6)+MIN(100000,D6)-100000<0,0,MIN(100000,C6-G6)+MIN(100000,D6)-100000)","v":0},{"$f":"IF(入力!C42=\"\",0,IF(入力!H42=\"(選択してください)\",\"年齢選択エラー\",IF(入力!H42=\"\",\"年齢選択エラー\",(MAX(SUM(C6:E6)-H6-G6,0)))))","v":0},{"$f":"IF(入力!C42=\"\",0,IF(入力!C42=\"(選択してください)\",\"年齢選択エラー\",IF(入力!H42=\"\",\"年齢選択エラー\",IF(D6+C6-G6>0,1,IF(D6=0,IF(入力!S42>550000,1,0),0)))))","v":0}]
[]
[null,"年齢","年金所得","給与所得","その他の所得","所得金額調整控除額","高齢者特別控除","所得金額調整控除(軽減判定所得用)","軽減判定所得3","年金給与所得者の数"]
["世帯主",{"$f":"IF(ISBLANK(H47),0,入力!H47)","v":0},{"$f":"IF(入力!C47=\"v\",年金条件式!I6,0)","v":0},{"$f":"VLOOKUP(入力!S47,給与所得!$B$48:$C$59,2)","v":0},{"$f":"入力!Z47","v":0},{"$f":"IF(MIN(100000,C9)+MIN(100000,D9)-100000<0,0,MIN(100000,C9)+MIN(100000,D9)-100000)","v":0},{"$f":"IF(入力!H47=\"65歳以上\",MIN(150000,C9),0)","v":0},{"$f":"IF(MIN(100000,C9-G9)+MIN(100000,D9)-100000<0,0,MIN(100000,C9-G9)+MIN(100000,D9)-100000)","v":0},{"$f":"IF(入力!C47=\"\",0,IF(入力!H47=\"(選択してください)\",\"年齢選択エラー\",IF(入力!H47=\"\",\"年齢選択エラー\",(MAX(SUM(C9:E9)-H9-G9,0)))))","v":0},{"$f":"IF(入力!C47=\"\",0,IF(入力!C47=\"(選択してください)\",\"年齢選択エラー\",IF(入力!H47=\"\",\"年齢選択エラー\",IF(D9+C9-G9>0,1,IF(D9=0,IF(入力!S47>550000,1,0),0)))))","v":0}]
[]
["年度","賦課期日","所得割率","均等割額","賦課限度額",null,null,"軽減判定所得(計)","軽減基準額"]
["R2","2020-04-01",8.3799999999999999E-2,44170,660000,null,null,{"$f":"IF(OR(J2=\"年齢選択エラー\",I5=\"年齢選択エラー\",I6=\"年齢選択エラー\",I9=\"年齢選択エラー\"),\"年齢選択エラー\",J2+I5+I6+I9)","v":"年齢選択エラー"},"計算シートにて算出"]
["R3","2021-04-01",8.3799999999999999E-2,44170,660000]
["R4","2022-04-01","？%","？","？"]
["R5","2022-04-01","？%","？","？"]
[]
[null,"被保険者"]
["令和2年4月以前",12]
["令和2年5月",11]
["令和2年6月",10]
["令和2年7月",9]
["令和2年8月",8]
["令和2年9月",7]
["令和2年10月",6]
["令和2年11月",5]
["令和2年12月",4]
["令和3年1月",3]
["令和3年2月",2]
["令和3年3月",1]
[]
[null,"軽減割合"]
[0.7,"7"]
[0.77500000000000002,"7"]
[0.5,"5"]
[0.2,"2"]
[0,"―"]

{"sheet":"年金条件式","index":2,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":true,"merged":[[35,8,40,8],[35,9,35,10],[27,1,32,1],[27,2,27,3],[10,8,15,8],[10,9,10,10],[18,8,23,8],[18,9,18,10],[27,8,32,8],[27,9,27,10],[18,2,18,3],[10,1,15,1],[18,1,23,1],[10,2,10,3],[35,1,40,1],[35,2,35,3]]}
[null,null,"年齢65以上"]
[null,null,"所得（1,000～2000万円）","所得（2,000万円超）","６５歳以上","判定",null,null,"年金所得"]
[null,"被保険者",{"$f":"IF(SUM(設定!E2:F2)>=10000000,1,0)","v":0},{"$f":"IF(SUM(設定!E2:F2)>=20000000,1,0)","v":0},{"$f":"IF(入力!H32=\"65歳以上\",10,0)","v":0},{"$f":"SUM(C3:E3)","v":0},"入力!$I$32",null,{"$f":"IF(F3=10,VLOOKUP(入力!$L$32,$C$12:$F$16,2),IF(F3=11,VLOOKUP(入力!$L$32,$C$12:$F$16,3),IF(F3=12,VLOOKUP(入力!$L$32,$C$12:$F$16,4),IF(F3=0,VLOOKUP(入力!$L$32,J12:M16,2),IF(F3=1,VLOOKUP(入力!$L$32,J12:M16,3)*IF(F3=2,VLOOKUP(入力!$L$32,J12:M16,3)))))))","v":0}]
[null,"家族１",{"$f":"IF(SUM(設定!D5:E5)>=10000000,1,0)","v":0},{"$f":"IF(SUM(設定!D5:E5)>=20000000,1,0)","v":0},{"$f":"IF(入力!H37=\"65歳以上\",10,0)","v":0},{"$f":"SUM(C4:E4)","v":0},"入力!$I$37",null,{"$f":"IF(F4=10,VLOOKUP(入力!$L$37,C20:F24,2),IF(F4=11,VLOOKUP(入力!$L$37,C20:F24,3),IF(F4=12,VLOOKUP(入力!$L$37,C20:F24,4),IF(F4=0,VLOOKUP(入力!$L$37,J20:M24,2),IF(F4=1,VLOOKUP(入力!$L$37,J20:M24,3)*IF(F4=2,VLOOKUP(入力!$L$37,J20:M24,4)))))))","v":0}]
[null,"家族２",{"$f":"IF(SUM(設定!D6:E6)>=10000000,1,0)","v":0},{"$f":"IF(SUM(設定!D6:E6)>=20000000,1,0)","v":0},{"$f":"IF(入力!H42=\"65歳以上\",10,0)","v":0},{"$f":"SUM(C5:E5)","v":0},"入力!$I$42",null,{"$f":"IF(F5=10,VLOOKUP(入力!$L$42,C29:F33,2),IF(F5=11,VLOOKUP(入力!$L$42,C29:F33,3),IF(F5=12,VLOOKUP(入力!$L$42,C29:F33,4),IF(F5=0,VLOOKUP(入力!$L$42,J29:M33,2),IF(F5=1,VLOOKUP(入力!$L$42,J29:M33,3),IF(F5=2,VLOOKUP(入力!$L$42,J29:M33,4)))))))","v":0}]
[null,"世帯主",{"$f":"IF(SUM(設定!D9:E9)>=10000000,1,0)","v":0},{"$f":"IF(SUM(設定!D9:E9)>=20000000,1,0)","v":0},{"$f":"IF(入力!H47=\"65歳以上\",10,0)","v":0},{"$f":"SUM(C6:E6)","v":0},"入力!$L$47",null,{"$f":"IF(F6=0,VLOOKUP(入力!L47,J37:M41,2),IF(F6=1,VLOOKUP(入力!L47,J37:M41,3),IF(F6=2,VLOOKUP(入力!L47,J37:M41,4),IF(F6=10,VLOOKUP(入力!L47,C37:F41,2),IF(F6=11,VLOOKUP(入力!L47,C37:F41,3),IF(F6=12,VLOOKUP(入力!L47,C37:F41,4),\"\"))))))","v":0}]
[]
[]
[]
[]
[null,"被保険者","６５歳以上",null,"所得（1,000～2000万円）","所得（2,000万円超）",null,null,"世帯主","６５歳未満",null,"所得（1,000～2000万円）","所得（2,000万円超）"]
[null,null,0,{"$f":"IF(入力!$L$32<=1100000,0,入力!$L$32-1100000)","v":0},{"$f":"IF(入力!$L$32<=1000000,0,入力!$L$32-1000000)","v":0},{"$f":"IF(入力!$L$32<=1100000,0,入力!$L$32-900000)","v":0},null,null,null,0,{"$f":"IF(入力!$L$32<=600000,0,入力!$L$32-600000)","v":0},{"$f":"IF(入力!$L$32<=500000,0,入力!$L$32-500000)","v":0},{"$f":"IF(入力!$L$32<=400000,0,入力!$L$32-400000)","v":0}]
[null,null,3300000,{"$f":"ROUNDDOWN(入力!$L$32*0.75-275000,0)","v":-275000},{"$f":"ROUNDDOWN(入力!$L$32*0.75-175000,0)","v":-175000},{"$f":"ROUNDDOWN(入力!$L$32*0.75-75000,0)","v":-75000},null,null,null,1300000,{"$f":"ROUNDDOWN(入力!$L$32*0.75-275000,0)","v":-275000},{"$f":"ROUNDDOWN(入力!$L$32*0.75-175000,0)","v":-175000},{"$f":"ROUNDDOWN(入力!$L$32*0.75-75000,0)","v":-75000}]
[null,null,4100000,{"$f":"ROUNDDOWN(入力!$L$32*0.85-685000,0)","v":-685000},{"$f":"ROUNDDOWN(入力!$L$32*0.85-585000,0)","v":-585000},{"$f":"ROUNDDOWN(入力!$L$32*0.85-485000,0)","v":-485000},null,null,null,4100000,{"$f":"ROUNDDOWN(入力!$L$32*0.85-685000,0)","v":-685000},{"$f":"ROUNDDOWN(入力!$L$32*0.85-585000,0)","v":-585000},{"$f":"ROUNDDOWN(入力!$L$32*0.85-485000,0)","v":-485000}]
[null,null,7700000,{"$f":"ROUNDDOWN(入力!$L$32*0.95-1455000,0)","v":-1455000},{"$f":"ROUNDDOWN(入力!$L$32*0.95-1355000,0)","v":-1355000},{"$f":"ROUNDDOWN(入力!$L$32*0.95-1255000,0)","v":-1255000},null,null,null,7700000,{"$f":"ROUNDDOWN(入力!$L$32*0.95-1455000,0)","v":-1455000},{"$f":"ROUNDDOWN(入力!$L$32*0.95-1355000,0)","v":-1355000},{"$f":"ROUNDDOWN(入力!$L$32*0.95-1255000,0)","v":-1255000}]
[null,null,10000000,{"$f":"ROUNDDOWN(入力!$L$32*1-1955000,0)","v":-1955000},{"$f":"ROUNDDOWN(入力!$L$32*1-1855000,0)","v":-1855000},{"$f":"ROUNDDOWN(入力!$L$32*1-1755000,0)","v":-1755000},null,null,null,10000000,{"$f":"ROUNDDOWN(入力!$L$32*1-1955000,0)","v":-1955000},{"$f":"ROUNDDOWN(入力!$L$32*1-1855000,0)","v":-1855000},{"$f":"ROUNDDOWN(入力!$L$32*1-1755000,0)","v":-1755000}]
[]
[]
[null,"家族１","６５歳以上",null,"所得（1,000～2000万円）","所得（2,000万円超）",null,null,"世帯主","６５歳未満",null,"所得（1,000～2000万円）","所得（2,000万円超）"]
[null,null,0,{"$f":"IF(入力!$L$37<=1100000,0,入力!$L$37-1100000)","v":0},{"$f":"IF(入力!$L$37<=1000000,0,入力!$L$37-1000000)","v":0},{"$f":"IF(入力!$L$37<=1100000,0,入力!$L$37-900000)","v":0},null,null,null,0,{"$f":"IF(入力!$L$37<=600000,0,入力!$L$37-600000)","v":0},{"$f":"IF(入力!$L$37<=500000,0,入力!$L$37-500000)","v":0},{"$f":"IF(入力!$L$37<=400000,0,入力!$L$37-400000)","v":0}]
[null,null,3300000,{"$f":"ROUNDDOWN(入力!$L$37*0.75-275000,0)","v":-275000},{"$f":"ROUNDDOWN(入力!$L$37*0.75-175000,0)","v":-175000},{"$f":"ROUNDDOWN(入力!$L$37*0.75-75000,0)","v":-75000},null,null,null,1300000,{"$f":"ROUNDDOWN(入力!$L$37*0.75-275000,0)","v":-275000},{"$f":"ROUNDDOWN(入力!$L$37*0.75-175000,0)","v":-175000},{"$f":"ROUNDDOWN(入力!$L$37*0.75-75000,0)","v":-75000}]
[null,null,4100000,{"$f":"ROUNDDOWN(入力!$L$37*0.85-685000,0)","v":-685000},{"$f":"ROUNDDOWN(入力!$L$37*0.85-585000,0)","v":-585000},{"$f":"ROUNDDOWN(入力!$L$37*0.85-485000,0)","v":-485000},null,null,null,4100000,{"$f":"ROUNDDOWN(入力!$L$37*0.85-685000,0)","v":-685000},{"$f":"ROUNDDOWN(入力!$L$37*0.85-585000,0)","v":-585000},{"$f":"ROUNDDOWN(入力!$L$37*0.85-485000,0)","v":-485000}]
[null,null,7700000,{"$f":"ROUNDDOWN(入力!$L$37*0.95-1455000,0)","v":-1455000},{"$f":"ROUNDDOWN(入力!$L$37*0.95-1355000,0)","v":-1355000},{"$f":"ROUNDDOWN(入力!$L$37*0.95-1255000,0)","v":-1255000},null,null,null,7700000,{"$f":"ROUNDDOWN(入力!$L$37*0.95-1455000,0)","v":-1455000},{"$f":"ROUNDDOWN(入力!$L$37*0.95-1355000,0)","v":-1355000},{"$f":"ROUNDDOWN(入力!$L$37*0.95-1255000,0)","v":-1255000}]
[null,null,10000000,{"$f":"ROUNDDOWN(入力!$L$37*1-1955000,0)","v":-1955000},{"$f":"ROUNDDOWN(入力!$L$37*1-1855000,0)","v":-1855000},{"$f":"ROUNDDOWN(入力!$L$37*1-1755000,0)","v":-1755000},null,null,null,10000000,{"$f":"ROUNDDOWN(入力!$L$37*1-1955000,0)","v":-1955000},{"$f":"ROUNDDOWN(入力!$L$37*1-1855000,0)","v":-1855000},{"$f":"ROUNDDOWN(入力!$L$37*1-1755000,0)","v":-1755000}]
[]
[]
[]
[null,"家族２","６５歳以上",null,"所得（1,000～2000万円）","所得（2,000万円超）",null,null,"世帯主","６５歳未満",null,"所得（1,000～2000万円）","所得（2,000万円超）"]
[null,null,0,{"$f":"IF(入力!$L$42<=1100000,0,入力!$L$42-1100000)","v":0},{"$f":"IF(入力!$L$42<=1000000,0,入力!$L$42-1000000)","v":0},{"$f":"IF(入力!$L$42<=1100000,0,入力!$L$42-900000)","v":0},null,null,null,0,{"$f":"IF(入力!$L$42<=600000,0,入力!$L$42-600000)","v":0},{"$f":"IF(入力!$L$42<=500000,0,入力!$L$42-500000)","v":0},{"$f":"IF(入力!$L$42<=400000,0,入力!$L$42-400000)","v":0}]
[null,null,3300000,{"$f":"ROUNDDOWN(入力!$L$42*0.75-275000,0)","v":-275000},{"$f":"ROUNDDOWN(入力!$L$42*0.75-175000,0)","v":-175000},{"$f":"ROUNDDOWN(入力!$L$42*0.75-75000,0)","v":-75000},null,null,null,1300000,{"$f":"ROUNDDOWN(入力!$L$42*0.75-275000,0)","v":-275000},{"$f":"ROUNDDOWN(入力!$L$42*0.75-175000,0)","v":-175000},{"$f":"ROUNDDOWN(入力!$L$42*0.75-75000,0)","v":-75000}]
[null,null,4100000,{"$f":"ROUNDDOWN(入力!$L$42*0.85-685000,0)","v":-685000},{"$f":"ROUNDDOWN(入力!$L$42*0.85-585000,0)","v":-585000},{"$f":"ROUNDDOWN(入力!$L$42*0.85-485000,0)","v":-485000},null,null,null,4100000,{"$f":"ROUNDDOWN(入力!$L$42*0.85-685000,0)","v":-685000},{"$f":"ROUNDDOWN(入力!$L$42*0.85-585000,0)","v":-585000},{"$f":"ROUNDDOWN(入力!$L$42*0.85-485000,0)","v":-485000}]
[null,null,7700000,{"$f":"ROUNDDOWN(入力!$L$42*0.95-1455000,0)","v":-1455000},{"$f":"ROUNDDOWN(入力!$L$42*0.95-1355000,0)","v":-1355000},{"$f":"ROUNDDOWN(入力!$L$42*0.95-1255000,0)","v":-1255000},null,null,null,7700000,{"$f":"ROUNDDOWN(入力!$L$42*0.95-1455000,0)","v":-1455000},{"$f":"ROUNDDOWN(入力!$L$42*0.95-1355000,0)","v":-1355000},{"$f":"ROUNDDOWN(入力!$L$42*0.95-1255000,0)","v":-1255000}]
[null,null,10000000,{"$f":"ROUNDDOWN(入力!$L$42*1-1955000,0)","v":-1955000},{"$f":"ROUNDDOWN(入力!$L$42*1-1855000,0)","v":-1855000},{"$f":"ROUNDDOWN(入力!$L$42*1-1755000,0)","v":-1755000},null,null,null,10000000,{"$f":"ROUNDDOWN(入力!$L$42*1-1955000,0)","v":-1955000},{"$f":"ROUNDDOWN(入力!$L$42*1-1855000,0)","v":-1855000},{"$f":"ROUNDDOWN(入力!$L$42*1-1755000,0)","v":-1755000}]
[]
[]
[null,"世帯主","６５歳以上",null,"所得（1,000～2000万円）","所得（2,000万円超）",null,null,"世帯主","６５歳未満",null,"所得（1,000～2000万円）","所得（2,000万円超）"]
[null,null,0,{"$f":"IF(入力!$L$47<=1100000,0,入力!$L$47-1100000)","v":0},{"$f":"IF(入力!$L$47<=1000000,0,入力!$L$47-1000000)","v":0},{"$f":"IF(入力!$L$47<=1100000,0,入力!$L$47-900000)","v":0},null,null,null,0,{"$f":"IF(入力!$L$47<=600000,0,入力!$L$47-600000)","v":0},{"$f":"IF(入力!$L$47<=500000,0,入力!$L$47-500000)","v":0},{"$f":"IF(入力!$L$47<=400000,0,入力!$L$47-400000)","v":0}]
[null,null,3300000,{"$f":"ROUNDDOWN(入力!$L$47*0.75-275000,0)","v":-275000},{"$f":"ROUNDDOWN(入力!$L$47*0.75-175000,0)","v":-175000},{"$f":"ROUNDDOWN(入力!$L$47*0.75-75000,0)","v":-75000},null,null,null,1300000,{"$f":"ROUNDDOWN(入力!$L$47*0.75-275000,0)","v":-275000},{"$f":"ROUNDDOWN(入力!$L$47*0.75-175000,0)","v":-175000},{"$f":"ROUNDDOWN(入力!$L$47*0.75-75000,0)","v":-75000}]
[null,null,4100000,{"$f":"ROUNDDOWN(入力!$L$47*0.85-685000,0)","v":-685000},{"$f":"ROUNDDOWN(入力!$L$47*0.85-585000,0)","v":-585000},{"$f":"ROUNDDOWN(入力!$L$47*0.85-485000,0)","v":-485000},null,null,null,4100000,{"$f":"ROUNDDOWN(入力!$L$47*0.85-685000,0)","v":-685000},{"$f":"ROUNDDOWN(入力!$L$47*0.85-585000,0)","v":-585000},{"$f":"ROUNDDOWN(入力!$L$47*0.85-485000,0)","v":-485000}]
[null,null,7700000,{"$f":"ROUNDDOWN(入力!$L$47*0.95-1455000,0)","v":-1455000},{"$f":"ROUNDDOWN(入力!$L$47*0.95-1355000,0)","v":-1355000},{"$f":"ROUNDDOWN(入力!$L$47*0.95-1255000,0)","v":-1255000},null,null,null,7700000,{"$f":"ROUNDDOWN(入力!$L$47*0.95-1455000,0)","v":-1455000},{"$f":"ROUNDDOWN(入力!$L$47*0.95-1355000,0)","v":-1355000},{"$f":"ROUNDDOWN(入力!$L$47*0.95-1255000,0)","v":-1255000}]
[null,null,10000000,{"$f":"ROUNDDOWN(入力!$L$47*1-1955000,0)","v":-1955000},{"$f":"ROUNDDOWN(入力!$L$47*1-1855000,0)","v":-1855000},{"$f":"ROUNDDOWN(入力!$L$47*1-1755000,0)","v":-1755000},null,null,null,10000000,{"$f":"ROUNDDOWN(入力!$L$47*1-1955000,0)","v":-1955000},{"$f":"ROUNDDOWN(入力!$L$47*1-1855000,0)","v":-1855000},{"$f":"ROUNDDOWN(入力!$L$47*1-1755000,0)","v":-1755000}]

{"sheet":"給与所得","index":3,"n_rows":59,"n_cols":5,"rows_kept":59,"cut":false,"hidden":true,"merged":[[30,0,43,0],[30,1,30,2],[45,0,58,0],[45,1,45,2],[0,0,12,0],[0,1,0,2],[15,0,28,0],[15,1,15,2]]}
["被保険者","2020年分"]
[null,"給与収入","給与所得"]
[null,0,0,null,"Q32"]
[null,551000,{"$f":"入力!S32-550000","v":-550000}]
[null,1619000,1069000]
[null,1620000,1070000]
[null,1622000,1072000]
[null,1624000,1074000]
[null,1628000,{"$f":"ROUNDDOWN(ROUNDDOWN(入力!S32/4,-3)*2.4,0)+100000","v":100000}]
[null,1800000,{"$f":"ROUNDDOWN(ROUNDDOWN(入力!S32/4,-3)*2.8,0)-80000","v":-80000}]
[null,3600000,{"$f":"ROUNDDOWN(ROUNDDOWN(入力!S32/4,-3)*3.2,0)-440000","v":-440000}]
[null,6600000,{"$f":"ROUNDDOWN(入力!S32*0.9,0)-1100000","v":-1100000}]
[null,8500000,6550000]
[null,8500001,{"$f":"入力!S32-1950000","v":-1950000}]
[]
["家族１","2020年分"]
[null,"給与収入","給与所得"]
[null,0,0,null,"Q37"]
[null,551000,{"$f":"入力!S37-550000","v":-550000}]
[null,1619000,1069000]
[null,1620000,1070000]
[null,1622000,1072000]
[null,1624000,1074000]
[null,1628000,{"$f":"ROUNDDOWN(ROUNDDOWN(入力!S37/4,-3)*2.4,0)+100000","v":100000}]
[null,1800000,{"$f":"ROUNDDOWN(ROUNDDOWN(入力!S37/4,-3)*2.8,0)-80000","v":-80000}]
[null,3600000,{"$f":"ROUNDDOWN(ROUNDDOWN(入力!S37/4,-3)*3.2,0)-440000","v":-440000}]
[null,6600000,{"$f":"ROUNDDOWN(入力!S37*0.9,0)-1100000","v":-1100000}]
[null,8500000,6550000]
[null,8500001,{"$f":"入力!S37-1950000","v":-1950000}]
[]
["家族２","2020年分",null,null,"Q42"]
[null,"給与収入","給与所得"]
[null,0,0]
[null,551000,{"$f":"入力!S42-550000","v":-550000}]
[null,1619000,1069000]
[null,1620000,1070000]
[null,1622000,1072000]
[null,1624000,1074000]
[null,1628000,{"$f":"ROUNDDOWN(ROUNDDOWN(入力!S42/4,-3)*2.4,0)+100000","v":100000}]
[null,1800000,{"$f":"ROUNDDOWN(ROUNDDOWN(入力!S42/4,-3)*2.8,0)-80000","v":-80000}]
[null,3600000,{"$f":"ROUNDDOWN(ROUNDDOWN(入力!S42/4,-3)*3.2,0)-440000","v":-440000}]
[null,6600000,{"$f":"ROUNDDOWN(入力!S42*0.9,0)-1100000","v":-1100000}]
[null,8500000,6550000]
[null,8500001,{"$f":"入力!S42-1950000","v":-1950000}]
[]
["世帯主","2020年分",null,null,"S47"]
[null,"給与収入","給与所得"]
[null,0,0]
[null,551000,{"$f":"入力!S47-550000","v":-550000}]
[null,1619000,1069000]
[null,1620000,1070000]
[null,1622000,1072000]
[null,1624000,1074000]
[null,1628000,{"$f":"ROUNDDOWN(ROUNDDOWN(入力!S47/4,-3)*2.4,0)+100000","v":100000}]
[null,1800000,{"$f":"ROUNDDOWN(ROUNDDOWN(入力!S47/4,-3)*2.8,0)-80000","v":-80000}]
[null,3600000,{"$f":"ROUNDDOWN(ROUNDDOWN(入力!S47/4,-3)*3.2,0)-440000","v":-440000}]
[null,6600000,{"$f":"ROUNDDOWN(入力!S47*0.9,0)-1100000","v":-1100000}]
[null,8500000,6550000]
[null,8500001,{"$f":"入力!S47-1950000","v":-1950000}]

{"sheet":"資格取得月","index":4,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["資格取得月","月数"]
["令和4年4月以前",12]
["令和4年5月",11]
["令和4年6月",10]
["令和4年7月",9]
["令和4年8月",8]
["令和4年9月",7]
["令和4年10月",6]
["令和4年11月",5]
["令和4年12月",4]
["令和5年1月",3]
["令和5年2月",2]
["令和5年3月",1]

{"sheet":"計算","index":5,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":true,"merged":[[16,3,18,3]]}
["【保険料算定】"]
[null,"所得合計","賦課のもとと\nなる所得金額","所得割率","所得割額","均等割額","算出\n保険料額","賦課限度額","限度超過額","均等割\n軽減額","年　　　間\n保険料額","月数","月割減額","決　　　定\n保険料額"]
["被保険者",{"$f":"設定!D2+設定!E2+設定!F2-設定!G2","v":0},{"$f":"IF(B3>25000000,B3,IF(B3>24500000,B3-150000,IF(B3>24000000,B3-290000,IF(B3-430000<0,0,B3-430000))))","v":0},8.3799999999999999E-2,{"$f":"ROUNDDOWN(C3*D3,-1)","v":0},44170,{"$f":"E3+F3","v":44170},660000,{"$f":"IF(G3>H3,G3-H3,0)","v":0},{"$f":"IF(D17=\"年齢選択エラー\",\"年齢選択エラー\",ROUNDUP(F3*$D$17,-1))","v":"年齢選択エラー"},{"$f":"IF(J3=\"年齢選択エラー\",\"年齢選択エラー\",G3-I3-J3)","v":"年齢選択エラー"},{"$f":"設定!C2","v":"資格取得月入力エラー"},{"$f":"IF(OR(L3=\"資格取得月入力エラー\",ISBLANK(L3)),\"資格取得月入力エラー\",IF(K3=\"年齢選択エラー\",\"年齢選択エラー\",ROUNDUP(K3*(12-L3)/12,0)))","v":"資格取得月入力エラー"},{"$f":"IF(M3=\"資格取得月入力エラー\",\"資格取得月入力エラー\",IF(K3=\"年齢選択エラー\",\"年齢選択エラー\",ROUNDDOWN(K3-M3,-2)))","v":"資格取得月入力エラー"}]
[null,null,{"$f":"IF(B3>25000000,B3,IF(B3<=24000000,IF(B3<=430000,0,B3-430000),IF(AND(B3<=24500000,B3>24000000),B3-290000,IF(AND(B3<=25000000,B3>24500000),B3-150000,))))","v":0}]
["【軽減判定所得の計算】"]
[null,"軽減判定所得"]
["被保険者",{"$f":"設定!J2","v":"年齢選択エラー"}]
["家族１",{"$f":"設定!I5","v":0}]
["家族２",{"$f":"設定!I6","v":0}]
["世帯主",{"$f":"設定!I9","v":0}]
["合計",{"$f":"IF(OR(B7=\"年齢選択エラー\",B8=\"年齢選択エラー\",B9=\"年齢選択エラー\",B10=\"年齢選択エラー\"),\"年齢選択エラー\",SUM(B7:B10))","v":"年齢選択エラー"}]
[]
["世帯の\n被保険者数","年金・給与所得者の数"]
[{"$f":"COUNTA(設定!B2)+SUM(設定!B5:B6)","v":1},{"$f":"IF(OR(設定!K2=\"年齢選択エラー\",設定!J5=\"年齢選択エラー\",設定!J6=\"年齢選択エラー\",設定!J9=\"年齢選択エラー\"),\"年齢選択エラー\",設定!K2+設定!J5+設定!J6+設定!J9)","v":"年齢選択エラー"}]
[]
[null,"基準額","軽減の適用","軽減割合"]
["7割軽減",{"$f":"IF(B14=\"年齢選択エラー\",\"年齢選択エラー\",IF(B14=0,430000,430000+100000*(B14-1)))","v":"年齢選択エラー"},{"$f":"IF(B11=\"年齢選択エラー\",\"年齢選択エラー\",IF(B11<=B17,\"該当\",\"非該当\"))","v":"年齢選択エラー"},{"$f":"IF(B11=\"年齢選択エラー\",\"年齢選択エラー\",IF(C17=\"該当\",0.7,IF(C18=\"該当\",0.5,IF(C19=\"該当\",0.2,0))))","v":"年齢選択エラー"}]
["5割軽減",{"$f":"IF(B14=\"年齢選択エラー\",\"年齢選択エラー\",IF(B14=0,430000+(285000*A14),430000+(285000*A14)+100000*(B14-1)))","v":"年齢選択エラー"},{"$f":"IF(B11=\"年齢選択エラー\",\"年齢選択エラー\",IF(C17=\"該当\",\"\",IF(B11<=B18,\"該当\",\"非該当\")))","v":"年齢選択エラー"}]
["2割軽減",{"$f":"IF(B14=\"年齢選択エラー\",\"年齢選択エラー\",IF(B14=0,430000+(520000*A14),430000+(520000*A14)+100000*(B14-1)))","v":"年齢選択エラー"},{"$f":"IF(B11=\"年齢選択エラー\",\"年齢選択エラー\",IF(OR(C17=\"該当\",C18=\"該当\"),\"\",IF(B11<=B19,\"該当\",\"非該当\")))","v":"年齢選択エラー"}]