{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["入力","設定","年金所得","給与所得","資格取得月","計算","7割軽減判定"],"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":[[49,21,49,28],[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],[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],[52,3,53,3],[52,4,53,6],[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],[41,2,41,7],[41,8,41,14],[41,16,41,22],[41,24,41,30],[45,11,45,17],[45,18,45,24],[45,2,45,6],[45,7,45,10],[45,25,45,31],[40,8,40,15],[40,16,40,23],[40,24,40,31],[36,8,36,14],[36,16,36,22],[36,24,36,30],[59,3,60,7],[59,8,60,30],[30,2,30,7],[30,8,30,15],[30,16,30,23],[30,24,30,31],[31,2,31,7],[35,2,35,7],[35,8,35,15],[35,16,35,23],[35,24,35,31],[31,8,31,14],[31,16,31,22],[31,24,31,30],[36,2,36,7],[40,2,40,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,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,null,null,"給与収入（年額）",null,null,null,null,null,null,null,"その他の所得（年額）"]
[null,null,null,null,null,null,null,null,null,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,null,null,"給与収入（年額）",null,null,null,null,null,null,null,"その他の所得（年額）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円"]
[]
[null,null,"■世帯主情報"]
[]
[null,null,"世帯主が被保険者以外の場合はチェックし、右記を入力",null,null,null,null,"(令和2年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":"(試算日:令和3年3月19日)"}]
[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":0.7},{"$f":"IF(I53=\"世帯主年齢選択エラー\",\"世帯主年齢選択エラー\",IF(I53=\"\",0,VLOOKUP(I53,設定!$A$32:$B$37,2,0)))","v":"7"},null,null,null,null,null,null,"割","世帯の所得によって均等割額の軽減割合が判定\nされます(7.75割,7割,5割,2割または軽減なし)。"]
[]
[null,null,null,"賦課月数➀",null,null,null,null,{"$f":"設定!C2","v":"資格取得月入力エラー"},null,null,null,null,null,null,null,"月","保険料試算の加入月数です（12月未満の場合は、月数に応じて、試算結果から減額されます）。"]
[null,null,null,"均等割額②",null,null,null,null,{"$f":"IF(計算!J3=\"世帯主年齢選択エラー\",\"世帯主年齢選択エラー\",計算!F3-計算!J3)","v":12510},null,null,null,null,null,null,null,"円","令和２年度の均等割額は41,700円です。\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,7.96,null,null,null,null,null,null,null,"%","所得割率は埼玉県内で均一です。 "]
[null,null,null,"備考",null,null,null,null,"※②と③は、それぞれ10円未満の端数を切捨てます。\n※保険料額は、②と③を合計して、100円未満の端数を切捨てます。\n※令和2年度の保険料額の限度額は、年額64万円です。"]

{"sheet":"設定","index":1,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[null,"資格取得月","月数","年金所得","給与所得","その他の所得"]
["被保険者",{"$f":"IF(OR(入力!C32=\"(選択してください)\",ISBLANK(入力!C32)),\"資格取得月入力エラー\",入力!C32)","v":"資格取得月入力エラー"},{"$f":"IF(B2=\"資格取得月入力エラー\",\"資格取得月入力エラー\",VLOOKUP(B2,資格取得月!$A$2:$B$13,2,0))","v":"資格取得月入力エラー"},{"$f":"VLOOKUP(入力!I32,年金所得!$B$2:$C$5,2)","v":0},{"$f":"VLOOKUP(入力!Q32,給与所得!$B$3:$C$13,2)","v":0},{"$f":"入力!Y32","v":0}]
[]
[null,"チェックボックス","年金所得","給与所得","その他の所得"]
["家族１",{"$f":"IF(入力!C37=\"v\",1,0)","v":0},{"$f":"VLOOKUP(IF(入力!I37=\"v\",1,0),年金所得!$B$8:$C$11,2)","v":0},{"$f":"VLOOKUP(入力!Q37,給与所得!$B$17:$C$27,2)","v":0},{"$f":"入力!Y37","v":0}]
["家族２",{"$f":"IF(入力!C42=\"v\",1,0)","v":0},{"$f":"VLOOKUP(IF(入力!I42=\"v\",1,0),年金所得!$B$14:$C$17,2)","v":0},{"$f":"VLOOKUP(入力!Q42,給与所得!$B$31:$C$41,2)","v":0},{"$f":"入力!Y42","v":0}]
[]
[null,"年齢","年金所得","給与所得","その他の所得"]
["世帯主",{"$f":"IF(ISBLANK(H47),0,入力!H47)","v":0},{"$f":"年金所得!I20","v":0},{"$f":"VLOOKUP(入力!S47,給与所得!$B$45:$C$55,2)","v":0},{"$f":"入力!Z47","v":0}]
[]
["年度","賦課期日","所得割率","均等割額","賦課限度額"]
["R2","2020-04-01",7.9600000000000004E-2,41700,640000]
["R3","2021-04-01",7.9600000000000004E-2,41700,640000]
["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.75"]
[0.5,"5"]
[0.2,"2"]
[0,"―"]

{"sheet":"年金所得","index":2,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":true,"merged":[[0,1,0,2],[0,3,0,4],[0,0,4,0],[12,0,16,0],[18,0,22,0],[6,1,6,2],[6,3,6,4],[12,1,12,2],[12,3,12,4],[18,1,18,2],[18,3,18,4],[6,0,10,0]]}
["被保険者","６５歳以上",null,"６５歳未満",null,null,null,"年金収入","年金所得","軽減判定所得"]
[null,0,{"$f":"IF(入力!$I32<=1200000,0,入力!$I32-1200000)","v":0},null,null,null,null,{"$f":"入力!I32","v":0},{"$f":"VLOOKUP(H2,B2:C5,2)","v":0},{"$f":"IF(I2<=149999,0,I2-150000)","v":0}]
[null,3300000,{"$f":"ROUNDDOWN(入力!$I32*0.75-375000,0)","v":-375000}]
[null,4100000,{"$f":"ROUNDDOWN(入力!$I32*0.85-785000,0)","v":-785000}]
[null,7700000,{"$f":"ROUNDDOWN(入力!$I32*0.95-1555000,0)","v":-1555000}]
[]
["家族１","６５歳以上",null,"６５歳未満",null,null,null,"年金収入","年金所得","軽減判定所得"]
[null,0,{"$f":"IF(入力!$I37<=1200000,0,入力!$I37-1200000)","v":0},null,null,null,null,{"$f":"入力!I37","v":0},{"$f":"VLOOKUP(H8,B8:C11,2)","v":0},{"$f":"IF(I8<=149999,0,I8-150000)","v":0}]
[null,3300000,{"$f":"ROUNDDOWN(入力!$I37*0.75-375000,0)","v":-375000}]
[null,4100000,{"$f":"ROUNDDOWN(入力!$I37*0.85-785000,0)","v":-785000}]
[null,7700000,{"$f":"ROUNDDOWN(入力!$I37*0.95-1555000,0)","v":-1555000}]
[]
["家族２","６５歳以上",null,"６５歳未満",null,null,null,"年金収入","年金所得","軽減判定所得"]
[null,0,{"$f":"IF(入力!$I42<=1200000,0,入力!$I42-1200000)","v":0},null,null,null,null,{"$f":"入力!I42","v":0},{"$f":"VLOOKUP(H14,B14:C17,2)","v":0},{"$f":"IF(I14<=149999,0,I14-150000)","v":0}]
[null,3300000,{"$f":"ROUNDDOWN(入力!$I42*0.75-375000,0)","v":-375000}]
[null,4100000,{"$f":"ROUNDDOWN(入力!$I42*0.85-785000,0)","v":-785000}]
[null,7700000,{"$f":"ROUNDDOWN(入力!$I42*0.95-1555000,0)","v":-1555000}]
[]
["世帯主","６５歳以上",null,"６５歳未満",null,null,"年齢","年金収入","年金所得","軽減判定所得"]
[null,0,{"$f":"IF(入力!$L47<=1200000,0,入力!$L47-1200000)","v":0},0,{"$f":"IF(入力!$L47<=700000,0,入力!$L47-700000)","v":0},null,{"$f":"入力!H47","v":"(選択してください)"},{"$f":"入力!L47","v":0},{"$f":"IF(入力!C47=\"\",0,IF(入力!H47=\"65歳以上\",VLOOKUP(H20,B20:C23,2),IF(入力!H47=\"65歳未満\",VLOOKUP(H20,D20:E23,2),\"世帯主年齢選択エラー\")))","v":0},{"$f":"IF(I20=\"世帯主年齢選択エラー\",\"世帯主年齢選択エラー\",IF(G20=\"65歳未満\",I20,IF(I20<=149999,0,I20-150000)))","v":0}]
[null,3300000,{"$f":"ROUNDDOWN(入力!$L47*0.75-375000,0)","v":-375000},1300000,{"$f":"ROUNDDOWN(入力!$L47*0.75-375000,0)","v":-375000}]
[null,4100000,{"$f":"ROUNDDOWN(入力!$L47*0.85-785000,0)","v":-785000},4100000,{"$f":"ROUNDDOWN(入力!$L47*0.85-785000,0)","v":-785000}]
[null,7700000,{"$f":"ROUNDDOWN(入力!$L47*0.95-1555000,0)","v":-1555000},7700000,{"$f":"ROUNDDOWN(入力!$L47*0.95-1555000,0)","v":-1555000}]

{"sheet":"給与所得","index":3,"n_rows":55,"n_cols":3,"rows_kept":55,"cut":false,"hidden":true,"merged":[[28,0,40,0],[28,1,28,2],[42,0,54,0],[42,1,42,2],[0,0,12,0],[0,1,0,2],[14,0,26,0],[14,1,14,2]]}
["被保険者","2019年分"]
[null,"給与収入","給与所得"]
[null,0,0]
[null,651000,{"$f":"入力!Q32-650000","v":-650000}]
[null,1619000,969000]
[null,1620000,970000]
[null,1622000,972000]
[null,1624000,974000]
[null,1628000,{"$f":"ROUNDDOWN(入力!Q32/4000,0)*4000*0.6","v":0}]
[null,1800000,{"$f":"ROUNDDOWN(入力!Q32/4000,0)*4000*0.7-180000","v":-180000}]
[null,3600000,{"$f":"ROUNDDOWN(入力!Q32/4000,0)*4000*0.8-540000","v":-540000}]
[null,6600000,{"$f":"ROUNDDOWN(入力!Q32/4000,0)*4000*0.9-1200000","v":-1200000}]
[null,10000000,{"$f":"入力!Q32-2200000","v":-2200000}]
[]
["家族１","2019年分"]
[null,"給与収入","給与所得"]
[null,0,0]
[null,651000,{"$f":"入力!Q37-650000","v":-650000}]
[null,1619000,969000]
[null,1620000,970000]
[null,1622000,972000]
[null,1624000,974000]
[null,1628000,{"$f":"ROUNDDOWN(入力!Q37/4000,0)*4000*0.6","v":0}]
[null,1800000,{"$f":"ROUNDDOWN(入力!Q37/4000,0)*4000*0.7-180000","v":-180000}]
[null,3600000,{"$f":"ROUNDDOWN(入力!Q37/4000,0)*4000*0.8-540000","v":-540000}]
[null,6600000,{"$f":"ROUNDDOWN(入力!Q37/4000,0)*4000*0.9-1200000","v":-1200000}]
[null,10000000,{"$f":"入力!Q37-2200000","v":-2200000}]
[]
["家族２","2019年分"]
[null,"給与収入","給与所得"]
[null,0,0]
[null,651000,{"$f":"入力!Q42-650000","v":-650000}]
[null,1619000,969000]
[null,1620000,970000]
[null,1622000,972000]
[null,1624000,974000]
[null,1628000,{"$f":"ROUNDDOWN(入力!Q42/4000,0)*4000*0.6","v":0}]
[null,1800000,{"$f":"ROUNDDOWN(入力!Q42/4000,0)*4000*0.7-180000","v":-180000}]
[null,3600000,{"$f":"ROUNDDOWN(入力!Q42/4000,0)*4000*0.8-540000","v":-540000}]
[null,6600000,{"$f":"ROUNDDOWN(入力!Q42/4000,0)*4000*0.9-1200000","v":-1200000}]
[null,10000000,{"$f":"入力!Q42-2200000","v":-2200000}]
[]
["世帯主","2019年分"]
[null,"給与収入","給与所得"]
[null,0,0]
[null,651000,{"$f":"入力!S47-650000","v":-650000}]
[null,1619000,969000]
[null,1620000,970000]
[null,1622000,972000]
[null,1624000,974000]
[null,1628000,{"$f":"ROUNDDOWN(入力!S47/4000,0)*4000*0.6","v":0}]
[null,1800000,{"$f":"ROUNDDOWN(入力!S47/4000,0)*4000*0.7-180000","v":-180000}]
[null,3600000,{"$f":"ROUNDDOWN(入力!S47/4000,0)*4000*0.8-540000","v":-540000}]
[null,6600000,{"$f":"ROUNDDOWN(入力!S47/4000,0)*4000*0.9-1200000","v":-1200000}]
[null,10000000,{"$f":"入力!S47-2200000","v":-2200000}]

{"sheet":"資格取得月","index":4,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["資格取得月","月数"]
["令和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]

{"sheet":"計算","index":5,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":true,"merged":[[16,3,19,3]]}
["【保険料算定】"]
[null,"所得合計","賦課のもとと\nなる所得金額","所得割率","所得割額","均等割額","算出\n保険料額","賦課限度額","限度超過額","均等割\n軽減額","年　　　間\n保険料額","月数","月割減額","決　　　定\n保険料額"]
["被保険者",{"$f":"設定!D2+設定!E2+設定!F2","v":0},{"$f":"IF(B3<=330000,0,B3-330000)","v":0},7.9600000000000004E-2,{"$f":"ROUNDDOWN(C3*D3,-1)","v":0},41700,{"$f":"E3+F3","v":41700},640000,{"$f":"IF(G3>H3,G3-H3,0)","v":0},{"$f":"IF(D17=\"世帯主年齢選択エラー\",\"世帯主年齢選択エラー\",ROUNDUP(F3*$D$17,-1))","v":29190},{"$f":"IF(J3=\"世帯主年齢選択エラー\",\"世帯主年齢選択エラー\",G3-I3-J3)","v":12510},{"$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,"軽減判定所得"]
["被保険者",{"$f":"'7割軽減判定'!I2","v":0}]
["家族１",{"$f":"'7割軽減判定'!I3","v":0}]
["家族２",{"$f":"'7割軽減判定'!I4","v":0}]
["世帯主",{"$f":"IF('7割軽減判定'!I5=\"世帯主年齢選択エラー\",\"世帯主年齢選択エラー\",'7割軽減判定'!I5)","v":0}]
["合計",{"$f":"IF(B10=\"世帯主年齢選択エラー\",\"世帯主年齢選択エラー\",SUM(B7:B10))","v":0}]
[]
["世帯の\n被保険者数"]
[{"$f":"COUNTA(設定!B2)+SUM(設定!B5:B6)","v":1}]
[]
[null,"基準額","軽減の適用","軽減割合"]
["7割軽減",330000,{"$f":"'7割軽減判定'!J9","v":"該当"},{"$f":"IF(B11=\"世帯主年齢選択エラー\",\"世帯主年齢選択エラー\",IF(AND(C17=\"該当\",C18=\"該当\"),0.7,IF(AND(C17=\"非該当\",C18=\"該当\"),0.775,IF(C19=\"該当\",0.5,IF(C20=\"該当\",0.2,0)))))","v":0.7}]
["7.75割軽減",330000,{"$f":"IF(B11=\"世帯主年齢選択エラー\",\"世帯主年齢選択エラー\",IF(B11<=330000,\"該当\",\"非該当\"))","v":"該当"}]
["5割軽減",{"$f":"330000+(285000*A14)","v":615000},{"$f":"IF(B11=\"世帯主年齢選択エラー\",\"世帯主年齢選択エラー\",IF(C18=\"該当\",\"\",IF(B11<=B19,\"該当\",\"非該当\")))","v":""}]
["2割軽減",{"$f":"330000+(520000*A14)","v":850000},{"$f":"IF(B11=\"世帯主年齢選択エラー\",\"世帯主年齢選択エラー\",IF(OR(C18=\"該当\",C19=\"該当\"),\"\",IF(B11<=B20,\"該当\",\"非該当\")))","v":""}]

{"sheet":"7割軽減判定","index":6,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":true,"merged":[[0,7,0,8]]}
[null,"年金収入","給与収入","その他の所得","給与所得","年金所得","(年金軽減     判定所得)","軽減判定所得\nその他の所得+給与所得+年金所得(年金軽減判定所得)",null,"７割軽減\n世帯判定"]
["被保険者",{"$f":"入力!I32","v":0},{"$f":"入力!Q32","v":0},{"$f":"入力!Y32","v":0},{"$f":"設定!E2","v":0},{"$f":"年金所得!I2","v":0},{"$f":"年金所得!J2","v":0},{"$f":"D2+E2+G2","v":0},{"$f":"IF(D2+E2+G2<0,\"0\",D2+E2+G2)","v":0},{"$f":"IF(SUM(D2:F2)>0,\"非該当\",IF(B2-800000+D2+E2<=0,\"該当\",\"非該当\"))","v":"該当"}]
["家族１",{"$f":"入力!I37","v":0},{"$f":"入力!Q37","v":0},{"$f":"入力!Y37","v":0},{"$f":"設定!D5","v":0},{"$f":"年金所得!I8","v":0},{"$f":"年金所得!J8","v":0},{"$f":"D3+E3+G3","v":0},{"$f":"IF(D3+E3+G3<0,\"0\",D3+E3+G3)","v":0},{"$f":"IF(SUM(D3:F3)>0,\"非該当\",IF(B3-800000+D3+E3<=0,\"該当\",\"非該当\"))","v":"該当"}]
["家族２",{"$f":"入力!I42","v":0},{"$f":"入力!Q42","v":0},{"$f":"入力!Y42","v":0},{"$f":"設定!D6","v":0},{"$f":"年金所得!I14","v":0},{"$f":"年金所得!J14","v":0},{"$f":"D4+E4+G4","v":0},{"$f":"IF(D4+E4+G4<0,\"0\",D4+E4+G4)","v":0},"該当"]
["世帯主",{"$f":"入力!L47","v":0},{"$f":"入力!S47","v":0},{"$f":"入力!Z47","v":0},{"$f":"設定!D9","v":0},{"$f":"年金所得!I20","v":0},{"$f":"年金所得!J20","v":0},{"$f":"IF(G5=\"世帯主年齢選択エラー\",\"世帯主年齢選択エラー\",D5+E5+G5)","v":0},{"$f":"IF(H5=\"世帯主年齢選択エラー\",\"世帯主年齢選択エラー\",IF(D5+E5+G5<0,\"0\",D5+E5+G5))","v":0},"―"]
["合計","―","―","―","―","―","―",{"$f":"SUM(H2:H5)","v":0},{"$f":"SUM(I2:I5)","v":0},"―"]
[]
[null,null,null,null,null,null,null,null,null,"７割軽減\n世帯判定"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I5=\"世帯主年齢選択エラー\",\"世帯主年齢選択エラー\",IF(AND(SUM(I2:I4)<=330000,J2=\"該当\",J3=\"該当\",J4=\"該当\"),\"該当\",\"非該当\"))","v":"該当"}]