{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["令和5年度 保険料試算","年齢リスト"],"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":"令和5年度 保険料試算","index":0,"n_rows":78,"n_cols":89,"rows_kept":78,"cut":false,"hidden":false,"merged":[[72,0,72,1],[73,0,73,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[77,0,77,1],[78,0,78,1],[79,0,79,1],[79,2,79,101],[74,2,76,17],[77,2,78,17],[74,18,76,101],[77,18,78,101],[73,2,73,101],[63,0,63,1],[64,0,64,1],[65,0,65,1],[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[71,0,71,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[58,0,58,1],[59,0,59,1],[60,0,60,1],[61,0,61,1],[62,0,62,1],[45,0,45,1],[46,0,46,1],[47,0,47,1],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[53,0,53,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[71,94,71,101],[56,37,57,93],[59,37,59,93],[60,37,60,93],[61,37,61,93],[62,37,62,93],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[65,37,65,93],[66,37,66,93],[67,37,67,93],[68,37,68,93],[69,37,69,93],[58,10,58,93],[64,10,64,93],[72,2,72,101],[68,10,68,30],[69,10,69,30],[70,2,71,93],[58,94,58,101],[59,94,59,101],[60,94,60,101],[61,94,61,101],[62,94,62,101],[63,94,63,101],[64,94,64,101],[65,94,65,101],[66,94,66,101],[67,94,67,101],[68,94,68,101],[69,94,69,101],[70,94,70,101],[64,2,69,9],[65,31,65,36],[66,31,66,36],[67,31,67,36],[68,31,68,36],[69,31,69,36],[56,10,57,30],[59,10,59,30],[60,10,60,30],[61,10,61,30],[62,10,62,30],[63,10,63,30],[65,10,65,30],[66,10,66,30],[67,10,67,30],[53,2,53,101],[54,2,54,101],[56,2,57,9],[58,2,63,9],[46,2,47,17],[46,18,47,101],[48,2,49,17],[48,18,49,101],[50,2,51,17],[50,18,51,101],[52,2,52,101],[56,31,57,36],[59,31,59,36],[60,31,60,36],[61,31,61,36],[62,31,62,36],[63,31,63,36],[63,37,63,93],[55,2,55,93],[55,94,55,101],[56,94,56,101],[57,94,57,101],[37,2,37,101],[38,2,38,101],[39,2,39,101],[40,2,40,101],[41,2,41,101],[42,2,42,101],[43,2,43,101],[44,2,44,101],[45,2,45,101],[34,2,34,101],[35,2,35,101],[36,2,36,101],[0,90,0,101],[1,90,1,101],[2,90,2,101],[3,90,3,101],[4,90,4,101],[5,90,5,101],[6,90,6,101],[9,90,9,101],[10,90,10,101],[11,90,11,101],[27,69,27,72],[27,73,27,76],[31,6,31,10],[29,35,29,40],[30,61,30,64],[30,65,30,68],[30,69,30,72],[30,73,30,76],[31,50,31,53],[31,54,31,57],[31,58,31,60],[27,65,27,68],[28,65,28,68],[31,61,31,68],[0,2,0,60],[32,2,32,101],[33,2,33,101],[28,69,28,72],[28,73,28,76],[28,61,28,64],[29,69,29,72],[29,73,29,76],[30,46,30,49],[30,50,30,53],[28,58,28,60],[25,61,25,64],[29,54,29,57],[29,58,29,60],[26,61,26,64],[26,69,26,72],[26,73,26,76],[29,46,29,49],[29,50,29,53],[26,58,26,60],[29,61,29,64],[29,65,29,68],[30,11,30,16],[30,17,30,22],[30,23,30,28],[30,29,30,34],[30,35,30,40],[30,42,30,45],[25,65,25,68],[31,11,31,16],[31,17,31,22],[31,23,31,28],[31,35,31,40],[27,61,27,64],[26,65,26,68],[30,54,30,57],[30,58,30,60],[28,29,28,34],[28,35,28,40],[28,42,28,45],[28,46,28,49],[28,50,28,53],[28,54,28,57],[29,42,29,45],[31,42,31,45],[27,58,27,60],[24,61,24,64],[29,6,29,10],[29,11,29,16],[29,17,29,22],[29,23,29,28],[29,29,29,34],[25,58,25,60],[26,46,26,49],[26,50,26,53],[26,54,26,57],[24,58,24,60],[28,6,28,10],[28,11,28,16],[28,17,28,22],[28,23,28,28],[27,42,27,45],[24,65,24,68],[24,69,24,72],[24,73,24,76],[25,69,25,72],[25,73,25,76],[26,2,31,3],[26,4,27,5],[26,6,26,10],[26,11,26,16],[26,17,26,22],[26,23,26,28],[26,29,26,34],[26,35,26,40],[26,42,26,45],[27,6,27,10],[27,11,27,16],[27,17,27,22],[27,23,27,28],[27,29,27,34],[27,35,27,40],[31,29,31,34],[28,4,29,5],[31,46,31,49],[27,46,27,49],[30,4,31,5],[30,6,30,10],[25,42,25,45],[25,46,25,49],[24,42,24,43],[24,44,24,45],[24,46,24,57],[25,50,25,53],[25,54,25,57],[27,50,27,53],[27,54,27,57],[20,2,23,3],[24,2,24,10],[24,11,24,16],[24,17,24,22],[24,23,24,28],[24,29,24,34],[24,35,24,40],[25,2,25,10],[25,11,25,16],[25,17,25,22],[25,23,25,28],[25,29,25,34],[25,35,25,40],[23,4,23,10],[23,11,23,40],[20,61,20,64],[20,65,20,68],[20,69,20,72],[20,73,20,76],[20,4,20,10],[20,11,20,40],[20,41,20,60],[22,4,22,10],[22,11,22,16],[22,17,22,22],[22,23,22,28],[22,29,22,34],[22,35,22,40],[21,61,21,68],[21,69,21,76],[22,61,22,68],[22,69,22,76],[22,41,22,60],[23,69,23,72],[23,73,23,76],[21,4,21,10],[21,11,21,16],[21,17,21,22],[21,23,21,28],[21,29,21,34],[21,35,21,40],[21,41,21,60],[23,41,23,60],[23,61,23,64],[23,65,23,68],[18,79,18,89],[19,79,19,89],[16,88,16,89],[16,79,16,83],[16,84,16,87],[18,61,18,64],[18,65,18,68],[18,69,18,72],[18,73,18,76],[17,61,17,64],[17,65,17,68],[17,69,17,72],[17,73,17,76],[16,65,16,68],[16,69,16,72],[16,73,16,76],[19,61,19,64],[19,65,19,68],[19,69,19,72],[19,73,19,76],[19,2,19,10],[19,11,19,16],[19,17,19,22],[19,23,19,28],[19,29,19,34],[19,35,19,40],[19,41,19,60],[16,61,16,64],[15,61,15,64],[16,2,16,10],[16,11,16,16],[16,17,16,22],[15,2,15,10],[15,11,15,16],[15,17,15,22],[15,23,15,28],[15,29,15,34],[16,23,16,28],[16,29,16,34],[14,79,14,83],[14,84,14,87],[14,88,14,89],[18,2,18,10],[18,11,18,14],[18,17,18,20],[18,23,18,26],[18,29,18,32],[18,35,18,38],[18,41,18,60],[17,41,17,60],[14,61,14,64],[14,65,14,68],[14,69,14,72],[14,73,14,76],[15,84,15,87],[15,88,15,89],[15,65,15,68],[15,69,15,72],[14,2,14,10],[15,35,15,40],[15,79,15,83],[17,2,17,10],[17,79,17,89],[13,84,13,87],[13,88,13,89],[13,65,13,68],[13,69,13,72],[13,73,13,76],[11,61,11,68],[11,69,11,76],[17,11,17,16],[17,17,17,22],[17,23,17,28],[17,29,17,34],[17,35,17,40],[16,35,16,40],[16,41,16,60],[13,61,13,64],[14,11,14,12],[14,13,14,16],[14,17,14,18],[14,19,14,22],[14,23,14,24],[14,25,14,28],[14,29,14,30],[14,31,14,34],[13,79,13,83],[11,2,11,10],[11,11,11,16],[11,17,11,22],[11,23,11,28],[11,29,11,34],[11,35,11,40],[10,61,10,64],[10,65,10,68],[15,73,15,76],[12,2,12,10],[12,11,12,16],[12,17,12,22],[12,23,12,28],[13,2,13,10],[13,11,13,12],[13,13,13,16],[13,17,13,18],[13,19,13,22],[13,23,13,24],[13,25,13,28],[13,29,13,30],[13,31,13,34],[12,29,12,34],[12,35,12,40],[6,65,6,68],[6,69,6,72],[6,73,6,76],[7,61,7,64],[7,65,7,68],[7,69,7,72],[7,73,7,76],[14,35,14,36],[14,37,14,40],[8,61,8,64],[8,65,8,68],[8,69,8,72],[8,73,8,76],[9,69,9,72],[10,69,10,72],[10,73,10,76],[12,70,12,75],[13,35,13,36],[13,37,13,40],[13,41,15,60],[9,61,9,64],[9,65,9,68],[12,41,12,60],[12,61,12,68],[5,79,5,83],[5,84,5,89],[9,2,9,10],[9,11,9,16],[9,17,9,22],[9,23,9,28],[9,29,9,34],[9,35,9,40],[9,41,11,60],[6,61,6,64],[8,50,8,60],[5,61,5,64],[5,65,5,68],[5,69,5,72],[5,73,5,76],[10,2,10,10],[10,11,10,16],[10,17,10,22],[10,23,10,28],[10,29,10,34],[8,2,8,10],[8,11,8,16],[9,73,9,76],[10,35,10,40],[7,2,7,10],[7,11,7,16],[7,17,7,22],[7,23,7,28],[7,29,7,34],[7,35,7,40],[7,42,7,46],[7,47,7,49],[8,17,8,22],[8,23,8,28],[8,29,8,34],[8,35,8,40],[8,42,8,46],[8,47,8,49],[31,69,31,76],[2,14,2,15],[2,16,2,21],[2,22,2,27],[2,28,2,29],[4,84,4,89],[4,61,4,64],[4,65,4,68],[4,69,4,72],[4,73,4,76],[7,50,7,60],[3,79,3,83],[6,17,6,22],[6,23,6,28],[6,29,6,34],[6,35,6,40],[3,61,3,64],[3,65,3,68],[3,69,3,72],[3,73,3,76],[4,79,4,83],[6,41,6,60],[2,77,2,78],[6,77,6,78],[0,61,0,89],[1,2,1,60],[2,30,2,60],[3,2,3,60],[6,2,6,10],[6,11,6,16],[4,2,4,60],[1,61,1,89],[5,41,5,60],[2,61,2,76],[2,79,2,89],[2,2,2,7],[2,8,2,13],[5,2,5,10],[5,11,5,16],[5,17,5,22],[5,23,5,28],[5,29,5,34],[5,35,5,40],[3,84,3,89],[3,77,3,78],[4,77,4,78],[5,77,5,78],[6,79,6,83],[7,77,7,78],[8,77,8,78],[9,77,9,78],[10,77,10,78],[11,77,11,78],[12,77,12,78],[9,79,9,89],[10,79,10,89],[11,79,11,89],[12,79,12,89],[6,84,6,89],[7,79,8,89],[31,77,31,78],[20,79,20,89],[21,79,21,89],[22,79,22,89],[23,79,23,89],[24,79,24,89],[25,79,25,89],[26,79,26,89],[27,79,27,89],[28,79,28,89],[29,79,29,89],[30,79,30,89],[31,79,31,89],[13,77,13,78],[14,77,14,78],[15,77,15,78],[16,77,16,78],[17,77,17,78],[18,77,18,78],[19,77,19,78],[20,77,20,78],[21,77,21,78],[22,77,22,78],[23,77,23,78],[24,77,24,78],[25,77,25,78],[26,77,26,78],[27,77,27,78],[28,77,28,78],[29,77,29,78],[30,77,30,78]]}
[null,null,"令和５年度　国民健康保険料試算（交野市）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BR32","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"円",null,"月額保険料",null,null,null,null,null,{"$f":"I3/12","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"円",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"①当初保険料（軽減判定前）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※軽減判定"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"L21","v":0}]
[null,null,"※国民健康保険に加入される方の年齢と所得を入力してください。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"所 得 割",null,null,null,{"$f":"L27+R27+X27+AD27+AJ27","v":0},null,null,null,{"$f":"L29+R29+X29+AD29+AJ29","v":0},null,null,null,{"$f":"L31+R31+X31+AD31+AJ31","v":0},null,null,null,null,null,"世帯人数",null,null,null,null,{"$f":"COUNT(L7:AO7)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"加入者①",null,null,null,null,null,"加入者②",null,null,null,null,null,"加入者③",null,null,null,null,null,"加入者④",null,null,null,null,null,"加入者⑤",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"均 等 割",null,null,null,{"$f":"L28+R28+X28+AD28+AJ28","v":0},null,null,null,{"$f":"L30+R30+X30+AD30+AJ30","v":0},null,null,null,{"$f":"L32+R32+X32+AD32+AJ32","v":0},null,null,null,null,null,"給年所得者",null,null,null,null,{"$f":"L22+R22+X22+AD22+AJ22","v":0}]
[null,null,"年　　　齢",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　←　年齢を入力してください。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"平 等 割",null,null,null,{"$f":"AU29","v":29692},null,null,null,{"$f":"AY29","v":9195},null,null,null,{"$f":"BC29","v":0},null,null,null,null,null,"※上記調整",null,null,null,null,{"$f":"IF(CG6-1<0,0,CG6-1)","v":0}]
[null,null,"人数判定",null,null,null,null,null,null,null,null,{"$f":"COUNT(L7)","v":0},null,null,null,null,null,{"$f":"COUNT(R7)","v":0},null,null,null,null,null,{"$f":"COUNT(X7)","v":0},null,null,null,null,null,{"$f":"COUNT(AD7)","v":0},null,null,null,null,null,{"$f":"COUNT(AJ7)","v":0},null,null,null,null,null,null,"世帯人数",null,null,null,null,{"$f":"SUM(L8:AO8)","v":0},null,null,"　※自動入力されます。",null,null,null,null,null,null,null,null,null,null,"合　  計",null,null,null,{"$f":"SUM(BN5:BQ7)","v":29692},null,null,null,{"$f":"SUM(BR5:BU7)","v":9195},null,null,null,{"$f":"SUM(BV5:BY7)","v":0},null,null,null,null,null," ※給・年所得者ゼロのときに\n    マイナスにならない用"]
[null,null,"未就学児判定",null,null,null,null,null,null,null,null,{"$f":"IF(L7=\"\",\"\",IF(L7<7,L8*0.5,L8))","v":""},null,null,null,null,null,{"$f":"IF(R7=\"\",\"\",IF(R7<7,R8*0.5,R8))","v":""},null,null,null,null,null,{"$f":"IF(X7=\"\",\"\",IF(X7<7,X8*0.5,X8))","v":""},null,null,null,null,null,{"$f":"IF(AD7=\"\",\"\",IF(AD7<7,AD8*0.5,AD8))","v":""},null,null,null,null,null,{"$f":"IF(AJ7=\"\",\"\",IF(AJ7<7,AJ8*0.5,AJ8))","v":""},null,null,null,null,null,null,"未就学判定",null,null,null,null,{"$f":"SUM(L9:AO9)","v":0},null,null,"　※自動入力されます。",null,null,null,null,null,null,null,null,null,null,"限 度 額",null,null,null,{"$f":"AU30","v":650000},null,null,null,{"$f":"AY30","v":200000},null,null,null,{"$f":"BC30","v":170000}]
[null,null,"給 与 所 得",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(BN8>=BN9,BN9,BN8)","v":29692},null,null,null,{"$f":"IF(BR8>=BR9,BR9,BR8)","v":9195},null,null,null,{"$f":"IF(BV8>=BV9,BV9,BV8)","v":0}]
[null,null,"年 金 所 得",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"保険料",null,null,null,{"$f":"ROUNDDOWN(BN10,-2)","v":29600},null,null,null,{"$f":"ROUNDDOWN(BR10,-2)","v":9100},null,null,null,{"$f":"ROUNDDOWN(BV10,-2)","v":0}]
[null,null,"その他所得",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BN11+BR11+BV11","v":38700}]
[null,null,"所得合計(個人)",null,null,null,null,null,null,null,null,{"$f":"SUM(L10:Q12)","v":0},null,null,null,null,null,{"$f":"SUM(R10:W12)","v":0},null,null,null,null,null,{"$f":"SUM(X10:AC12)","v":0},null,null,null,null,null,{"$f":"SUM(AD10:AI12)","v":0},null,null,null,null,null,{"$f":"SUM(AJ10:AO12)","v":0},null,null,null,null,null,"　←　自動で計算されます。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"②軽減判定",null,null,null,null,null,null,null,"[",{"$f":"CG14","v":"７割軽減"},null,null,null,null,null,"]"]
[null,null,"給 与 控 除",null,null,null,null,null,null,null,null,{"$f":"IF(L10>=1,1,0)","v":0},null,{"$f":"IF(L10>100000,100000,L10)","v":0},null,null,null,{"$f":"IF(R10>=1,1,0)","v":0},null,{"$f":"IF(R10>100000,100000,R10)","v":0},null,null,null,{"$f":"IF(X10>=1,1,0)","v":0},null,{"$f":"IF(X10>100000,100000,X10)","v":0},null,null,null,{"$f":"IF(AD10>=1,1,0)","v":0},null,{"$f":"IF(AD10>100000,100000,AD10)","v":0},null,null,null,{"$f":"IF(AJ10>=1,1,0)","v":0},null,{"$f":"IF(AJ10>100000,100000,AJ10)","v":0},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,{"$f":"CG15","v":"７割軽減"},null,null,null,{"$f":"CK15","v":0.3}]
[null,null,"年 金 控 除",null,null,null,null,null,null,null,null,{"$f":"IF(L11>=1,1,0)","v":0},null,{"$f":"IF(L11>100000,100000,L11)","v":0},null,null,null,{"$f":"IF(R11>=1,1,0)","v":0},null,{"$f":"IF(R11>100000,100000,R11)","v":0},null,null,null,{"$f":"IF(X11>=1,1,0)","v":0},null,{"$f":"IF(X11>100000,100000,X11)","v":0},null,null,null,{"$f":"IF(AD11>=1,1,0)","v":0},null,{"$f":"IF(AD11>100000,100000,AD11)","v":0},null,null,null,{"$f":"IF(AJ11>=1,1,0)","v":0},null,{"$f":"IF(AJ11>100000,100000,AJ11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"所 得 割",null,null,null,{"$f":"INT(BN5)","v":0},null,null,null,{"$f":"INT(BR5)","v":0},null,null,null,{"$f":"INT(BV5)","v":0},null,null,null,null,null,"7 割",null,null,null,null,{"$f":"IF(L21+L24<=430000+100000*(CG6-1),\"７割軽減\",CG16)","v":"７割軽減"},null,null,null,{"$f":"IF(L21+L24<=430000+100000*CG7,0.3,CK16)","v":0.3}]
[null,null,"年 金 調 整",null,null,null,null,null,null,null,null,{"$f":"IF(L14+L15=2,-L17,0)","v":0},null,null,null,null,null,{"$f":"IF(R14+R15=2,-R17,0)","v":0},null,null,null,null,null,{"$f":"IF(X14+X15=2,-X17,0)","v":0},null,null,null,null,null,{"$f":"IF(AD14+AD15=2,-AD17,0)","v":0},null,null,null,null,null,{"$f":"IF(AJ14+AJ15=2,-AJ17,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"均 等 割",null,null,null,{"$f":"BN6*$CK$14","v":0},null,null,null,{"$f":"BR6*$CK$14","v":0},null,null,null,{"$f":"BV6*$CK$14","v":0},null,null,null,null,null,"5 割",null,null,null,null,{"$f":"IF(L21+L24<=430000+290000*CG5+100000*(CG6-1),\"５割軽減\",CG17)","v":"５割軽減"},null,null,null,{"$f":"IF(L21+L24<=430000+285000*CG5+100000*CG7,0.5,CK17)","v":0.5}]
[null,null,"調 整 控 除",null,null,null,null,null,null,null,null,{"$f":"IF(N14+N15-100000<0,0,N14+N15-100000)","v":0},null,null,null,null,null,{"$f":"IF(T14+T15-100000<0,0,T14+T15-100000)","v":0},null,null,null,null,null,{"$f":"IF(Z14+Z15-100000<0,0,Z14+Z15-100000)","v":0},null,null,null,null,null,{"$f":"IF(AF14+AF15-100000<0,0,AF14+AF15-100000)","v":0},null,null,null,null,null,{"$f":"IF(AL14+AL15-100000<0,0,AL14+AL15-100000)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"平 等 割",null,null,null,{"$f":"BN7*$CK$14","v":8907.6},null,null,null,{"$f":"BR7*$CK$14","v":2758.5},null,null,null,{"$f":"BV7*$CK$14","v":0},null,null,null,null,null,"2 割",null,null,null,null,{"$f":"IF(L21+L24<=430000+535000*CG5+100000*(CG7-1),\"２割軽減\",\"軽減なし\")","v":"２割軽減"},null,null,null,{"$f":"IF(L21+L24<=430000+520000*CG5+100000*CG7,0.8,1)","v":0.8}]
[null,null,"国保用所得",null,null,null,null,null,null,null,null,{"$f":"IF(L13+L16-430000<0,0,L13+L16-430000)","v":0},null,null,null,null,null,{"$f":"IF(R13+R16-430000<0,0,R13+R16-430000)","v":0},null,null,null,null,null,{"$f":"IF(X13+X16-430000<0,0,X13+X16-430000)","v":0},null,null,null,null,null,{"$f":"IF(AD13+AD16-430000<0,0,AD13+AD16-430000)","v":0},null,null,null,null,null,{"$f":"IF(AJ13+AJ16-430000<0,0,AJ13+AJ16-430000)","v":0},null,null,null,null,null,"　←　医療分・支援分の計算用所得です。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"合  　計",null,null,null,{"$f":"BN15+BN16+BN17","v":8907.6},null,null,null,{"$f":"BR15+BR16+BR17","v":2758.5},null,null,null,{"$f":"BV15+BV16+BV17","v":0}]
[null,null,"介護該当判定",null,null,null,null,null,null,null,null,{"$f":"IF(P19+Q19=0,\"該当\",\"非該当\")","v":"非該当"},null,null,null,{"$f":"IF(L7<40,1,0)","v":1},{"$f":"IF(L7>64,1,0)","v":0},{"$f":"IF(V19+W19=0,\"該当\",\"非該当\")","v":"非該当"},null,null,null,{"$f":"IF(R7<40,1,0)","v":1},{"$f":"IF(R7>64,1,0)","v":0},{"$f":"IF(AB19+AC19=0,\"該当\",\"非該当\")","v":"非該当"},null,null,null,{"$f":"IF(X7<40,1,0)","v":1},{"$f":"IF(X7>64,1,0)","v":0},{"$f":"IF(AH19+AI19=0,\"該当\",\"非該当\")","v":"非該当"},null,null,null,{"$f":"IF(AD7<40,1,0)","v":1},{"$f":"IF(AD7>64,1,0)","v":0},{"$f":"IF(AN19+AO19=0,\"該当\",\"非該当\")","v":"非該当"},null,null,null,{"$f":"IF(AJ7<40,1,0)","v":1},{"$f":"IF(AJ7>64,1,0)","v":0}," 　←　40～65歳は該当。左40歳未満、右65歳以上、",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"限 度 額",null,null,null,{"$f":"BN9","v":650000},null,null,null,{"$f":"BR9","v":200000},null,null,null,{"$f":"BV9","v":170000}]
[null,null,"介護用所得",null,null,null,null,null,null,null,null,{"$f":"IF(L19=\"該当\",L18,0)","v":0},null,null,null,null,null,{"$f":"IF(R19=\"該当\",R18,0)","v":0},null,null,null,null,null,{"$f":"IF(X19=\"該当\",X18,0)","v":0},null,null,null,null,null,{"$f":"IF(AD19=\"該当\",AD18,0)","v":0},null,null,null,null,null,{"$f":"IF(AJ19=\"該当\",AJ18,0)","v":0},null,null,null,null,null,"　←　介護分計算用の所得です。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"限度額判定",null,null,null,{"$f":"IF(BN18>=BN19,BN19,BN18)","v":8907.6},null,null,null,{"$f":"IF(BR18>=BR19,BR19,BR18)","v":2758.5},null,null,null,{"$f":"IF(BV18>=BV19,BV19,BV18)","v":0}]
[null,null,"軽減判定",null,"所得合計(世帯)",null,null,null,null,null,null,{"$f":"SUM(L13:AO13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"保険料",null,null,null,{"$f":"ROUNDDOWN(BN20,-2)","v":8900},null,null,null,{"$f":"ROUNDDOWN(BR20,-2)","v":2700},null,null,null,{"$f":"ROUNDDOWN(BV20,-2)","v":0}]
[null,null,null,null,"給・年軽減対象",null,null,null,null,null,null,{"$f":"IF(L14=L15=\"\",\"\",IF(L14+L15=0,0,1))","v":0},null,null,null,null,null,{"$f":"IF(R14=R15=\"\",\"\",IF(R14+R15=0,0,1))","v":0},null,null,null,null,null,{"$f":"IF(X14=X15=\"\",\"\",IF(X14+X15=0,0,1))","v":0},null,null,null,null,null,{"$f":"IF(AD14=AD15=\"\",\"\",IF(AD14+AD15=0,0,1))","v":0},null,null,null,null,null,{"$f":"IF(AJ14=AJ15=\"\",\"\",IF(AJ14+AJ15=0,0,1))","v":0},null,null,null,null,null,"　←　給与所得と年金所得の両方がある場合「１」",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"保険料総額",null,null,null,null,null,null,null,{"$f":"BN21+BR21+BV21","v":11600}]
[null,null,null,null,"65 年金軽減額",null,null,null,null,null,null,{"$f":"IF(L7>64,IF(L11>=150000,-150000,-L11),0)","v":0},null,null,null,null,null,{"$f":"IF(R7>64,IF(R11>=150000,-150000,-R11),0)","v":0},null,null,null,null,null,{"$f":"IF(X7>64,IF(X11>=150000,-150000,-X11),0)","v":0},null,null,null,null,null,{"$f":"IF(AD7>64,IF(AD11>=150000,-150000,-AD11),0)","v":0},null,null,null,null,null,{"$f":"IF(AJ7>64,IF(AJ11>=150000,-150000,-AJ11),0)","v":0},null,null,null,null,null,"　←　①65歳以上の年金所得者で、②150,000円を上限",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"③未就学軽減後",null,null,null,null,null,null,null,"※未就学児判定がある場合"]
[null,null,null,null,"65 年軽減合計",null,null,null,null,null,null,{"$f":"L23+R23+X23+AD23+AJ23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(L13+L16-430000<0,0,L13+L16-430000)","v":0},null,null,null,null,null,{"$f":"IF(R13+R16-430000<0,0,R13+R16-430000)","v":0},null,null,null,null,null,{"$f":"IF(X13+X16-430000<0,0,X13+X16-430000)","v":0},null,null,null,null,null,{"$f":"IF(AD13+AD16-430000<0,0,AD13+AD16-430000)","v":0},null,null,null,null,null,{"$f":"IF(AJ13+AJ16-430000<0,0,AJ13+AJ16-430000)","v":0},null,null,null,null,null,null,"令和",null,{"$f":"G1","v":0},null,"年度　保険料率等（交野市）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"所 得 割",null,null,null,{"$f":"BN15","v":0},null,null,null,{"$f":"BR15","v":0},null,null,null,{"$f":"BV15","v":0}]
[null,null,"介護用所得（再掲）",null,null,null,null,null,null,null,null,{"$f":"IF(L19=\"該当\",L18,0)","v":0},null,null,null,null,null,{"$f":"IF(R19=\"該当\",R18,0)","v":0},null,null,null,null,null,{"$f":"IF(X19=\"該当\",X18,0)","v":0},null,null,null,null,null,{"$f":"IF(AD19=\"該当\",AD18,0)","v":0},null,null,null,null,null,{"$f":"IF(AJ19=\"該当\",AJ18,0)","v":0},null,null,null,null,null,null,null,null,null,null,"医療分",null,null,null,"支援分",null,null,null,"介護分",null,null,null,null,null,null,"均 等 割",null,null,null,{"$f":"BN16/AV8*AV9","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"BR16/AV8*AV9","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"BV16","v":0}]
[null,null,"保険料計算（個別）",null,"医療",null,"所 得 割",null,null,null,null,{"$f":"IF(L7=\"\",0,$AU$27*L25)","v":0},null,null,null,null,null,{"$f":"IF(R7=\"\",0,$AU$27*R25)","v":0},null,null,null,null,null,{"$f":"IF(X7=\"\",0,$AU$27*X25)","v":0},null,null,null,null,null,{"$f":"IF(AD7=\"\",0,$AU$27*AD25)","v":0},null,null,null,null,null,{"$f":"IF(AJ7=\"\",0,$AU$27*AJ25)","v":0},null,null,null,null,null,null,"所 得 割",null,null,null,8.4699999999999998E-2,null,null,null,2.5700000000000001E-2,null,null,null,2.47E-2,null,null,null,null,null,null,"平 等 割",null,null,null,{"$f":"BN17","v":8907.6},null,null,null,{"$f":"BR17","v":2758.5},null,null,null,{"$f":"BV17","v":0}]
[null,null,null,null,null,null,"均 等 割",null,null,null,null,{"$f":"IF(L7=\"\",0,$AU$28)","v":0},null,null,null,null,null,{"$f":"IF(R7=\"\",0,$AU$28)","v":0},null,null,null,null,null,{"$f":"IF(X7=\"\",0,$AU$28)","v":0},null,null,null,null,null,{"$f":"IF(AD7=\"\",0,$AU$28)","v":0},null,null,null,null,null,{"$f":"IF(AJ7=\"\",0,$AU$28)","v":0},null,null,null,null,null,null,"均 等 割",null,null,null,30331,null,null,null,9314,null,null,null,17520,null,null,null,null,null,null,"合  　計",null,null,null,{"$f":"BN25+BN26+BN27","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"BR25+BR26+BR27","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"BV25+BV26+BV27","v":0}]
[null,null,null,null,"支援金",null,"所 得 割",null,null,null,null,{"$f":"IF(L7=\"\",0,$AY$27*L25)","v":0},null,null,null,null,null,{"$f":"IF(R7=\"\",0,$AY$27*R25)","v":0},null,null,null,null,null,{"$f":"IF(X7=\"\",0,$AY$27*X25)","v":0},null,null,null,null,null,{"$f":"IF(AD7=\"\",0,$AY$27*AD25)","v":0},null,null,null,null,null,{"$f":"IF(AJ7=\"\",0,$AY$27*AJ25)","v":0},null,null,null,null,null,null,"平 等 割",null,null,null,29692,null,null,null,9195,null,null,null,0,null,null,null,null,null,null,"限度額",null,null,null,{"$f":"BN19","v":650000},null,null,null,{"$f":"BR19","v":200000},null,null,null,{"$f":"BV19","v":170000}]
[null,null,null,null,null,null,"均 等 割",null,null,null,null,{"$f":"IF(L7=\"\",0,$AY$28)","v":0},null,null,null,null,null,{"$f":"IF(R7=\"\",0,$AY$28)","v":0},null,null,null,null,null,{"$f":"IF(X7=\"\",0,$AY$28)","v":0},null,null,null,null,null,{"$f":"IF(AD7=\"\",0,$AY$28)","v":0},null,null,null,null,null,{"$f":"IF(AJ7=\"\",0,$AY$28)","v":0},null,null,null,null,null,null,"限 度 額",null,null,null,650000,null,null,null,200000,null,null,null,170000,null,null,null,null,null,null,"限度額判定",null,null,null,{"$f":"IF(BN28>=BN29,BN29,BN28)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(BR28>=BR29,BR29,BR28)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(BV28>=BV29,BV29,BV28)","v":0}]
[null,null,null,null,"介護",null,"所 得 割",null,null,null,null,{"$f":"L26*$BC$27","v":0},null,null,null,null,null,{"$f":"R26*$BC$27","v":0},null,null,null,null,null,{"$f":"X26*$BC$27","v":0},null,null,null,null,null,{"$f":"AD26*$BC$27","v":0},null,null,null,null,null,{"$f":"AJ26*$BC$27","v":0},null,null,null,null,null,null,"軽減判定",null,null,null,"7割",null,null,null,"5割",null,null,null,"2割",null,null,null,null,null,null,"保険料",null,null,null,{"$f":"ROUNDDOWN(BN30,-2)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"ROUNDDOWN(BR30,-2)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"ROUNDDOWN(BV30,-2)","v":0}]
[null,null,null,null,null,null,"均 等 割",null,null,null,null,{"$f":"IF(L19=\"該当\",$BC$28,L20)","v":0},null,null,null,null,null,{"$f":"IF(R19=\"該当\",$BC$28,R20)","v":0},null,null,null,null,null,{"$f":"IF(X19=\"該当\",$BC$28,X20)","v":0},null,null,null,null,null,{"$f":"IF(AD19=\"該当\",$BC$28,AD20)","v":0},null,null,null,null,null,{"$f":"IF(AJ19=\"該当\",$BC$28,AJ20)","v":0},null,null,null,null,null,null,"基 準 額",null,null,null,430000,null,null,null,290000,null,null,null,535000,null,null,null,null,null,null,"保険料総額",null,null,null,null,null,null,null,{"$f":"BN31+BR31+BV31","v":{"$error":"#DIV/0!"}}]
[null,null,"【注意事項】"]
[null,null,"　※上記結果はあくまでも試算であり、実際の保険料額と異なる場合があります。"]
[null,null,"　※以下の場合の保険料計算に対応しておりませんのでご注意ください。"]
[null,null,"　　①年度途中に加入者の所得や人数が変わる場合"]
[null,null,"　　②年度途中に加入者が40歳に到達し、介護保険の第２号被保険者となる場合"]
[null,null,"　　③年度途中に加入者が65歳に到達し、介護保険の第１号被保険者となる場合"]
[null,null,"　　④年度途中に加入者が75歳に到達し、後期高齢者医療制度の加入者となる場合"]
[null,null,"　　⑤年度途中に加入者が後期高齢者医療制度に移行し、残った国民健康保険の加入者が１人となる場合"]
[null,null,"　　⑥世帯の中に特定同一世帯所属者がいる場合"]
[null,null,"　　⑦所得金額調整控除がある場合や、給与所得の特定支出控除がある場合等"]
[null,null,"　　⑧専従者給与がある場合、または専従者控除を必要経費として算入している場合"]
[null,null,"　　⑨分離課税所得（土地・株式等の譲渡所得等）がある場合"]
[]
[null,null,"●給与所得の入力方法　※「給与所得控除後の給与等の金額」については国税庁のホームページにてご確認ください。"]
[null,null,"令和4年度の源泉徴収票をお持ちの方\n（他に給与収入がない方）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"源泉徴収票に記載されている「給与所得控除後の金額」欄に記載されている金額を入力してください。"]
[]
[null,null,"令和4年度の源泉徴収票をお持ちの方\n（複数の源泉徴収票をお持ちの方）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"それぞれの源泉徴収票に記載されている「支払金額」の合計金額から給与所得控除の金額を差し引いた金額を入力してください。"]
[]
[null,null,"令和4年度の源泉徴収票をお持ちではない方（年収から保険料を計算する場合）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"令和4年1月から12月までの給与の支給額（額面）の合計額、もしくは年収の金額から給与所得控除の金額を差し引いた金額を入力してください。"]
[]
[]
[null,null,"●年金所得の入力方法"]
[null,null,"※公的年金等に係る雑所得以外の金額【 (A) × (B) － (C) 】を入力してください。"]
[null,null,"公的年金等に係る雑所得以外の所得に係る合計所得金額が1,000万円以下の方"]
[null,null,"年金を受け取る方の\n年齢",null,null,null,null,null,null,null,"(A)公的年金等の収入金額の合計額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(B)割合",null,null,null,null,null,"©控除額"]
[]
[null,null,"65歳未満",null,null,null,null,null,null,null,"(公的年金等の収入金額の合計額が600,000円までの場合は、所得はゼロとなります。)"]
[null,null,null,null,null,null,null,null,null,null,"600,001円から1,299,999円まで",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,"600,000円"]
[null,null,null,null,null,null,null,null,null,null,"1,300,000円から4,099,999円まで",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,null,null,null,null,null,"275,000円"]
[null,null,null,null,null,null,null,null,null,null,"4,100,000円から7,699,999円まで",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.85,null,null,null,null,null,"685,000円"]
[null,null,null,null,null,null,null,null,null,null,"7,700,000円から9,999,999円まで",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.95,null,null,null,null,null,"1,455,000円"]
[null,null,null,null,null,null,null,null,null,null,"10,000,000円以上",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,"1,955,000円"]
[null,null,"65歳以上",null,null,null,null,null,null,null,"(公的年金等の収入金額の合計額が1,100,000円までの場合は、所得はゼロとなります。)"]
[null,null,null,null,null,null,null,null,null,null,"1,100,001円から3,299,999円まで",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,"1,100,000円"]
[null,null,null,null,null,null,null,null,null,null,"3,300,000円から4,099,999円まで",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,null,null,null,null,null,"275,000円"]
[null,null,null,null,null,null,null,null,null,null,"4,100,000円から7,699,999円まで",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.85,null,null,null,null,null,"685,000円"]
[null,null,null,null,null,null,null,null,null,null,"7,700,000円から9,999,999円まで",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.95,null,null,null,null,null,"1,455,000円"]
[null,null,null,null,null,null,null,null,null,null,"10,000,000円以上",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,"1,955,000円"]
[null,null,"※公的年金等に係る雑所得以外の所得に係る合計所得金額が1,000万円を超える場合は、計算方法が異なりますので、医療保険課までお問い合わせください。"]
[]
[]
[null,null,"●営業・その他事業・不動産等の所得の入力方法"]
[null,null,"令和4年の確定申告をされた方\n（確定申告書の控えがある方）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"「所得金額等」の欄に記載されている所得金額の内、給与所得と公的年金等の所得を除いた金額の合計額を入力してください。※給与所得、公的年金等の所得がある場合は別途、給与所得、年金所得欄に金額を入力してください。"]
[]
[]
[null,null,"令和4年の確定申告をされていない方\n（見込所得にて計算をされる方）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"収入から必要経費を差し引いた金額を入力してください。複数の所得（給与所得、公的年金等の所得を除く）がある場合は、その合計額を入力してください。"]

{"sheet":"年齢リスト","index":1,"n_rows":76,"n_cols":1,"rows_kept":76,"cut":false,"hidden":true,"merged":[]}
[]
[0]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]