{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["使い方","ここから開始","出力票"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["特定健診まだら受診等分析ツールVer.1.2"]
["（１）ＫＤＢの被保険者管理台帳の画面から、ＣＳＶファイルを出力・保存する。"]
["（２）「ここから開始」シートから（１）で保存したＣＳＶファイルを選択する。"]
["・医療機関受療状況を選ぶ。「医科全て」は医療機関からの健診受診勧奨について、「生活習慣病」は\"みなし健診\"について、検討するための資料としての活用などが想定されます。"]
["・分析年度を選ぶ。当該年度の特定健診が終わっていない時期の被保険者管理台帳を用いる場合は、まだ健診未受診者が多いので、「１年度前-２年度前-３年度前」を推奨。"]
["（３）「計算開始」をクリックすると、計算結果が表示される。"]
["３年度連続で通年の有資格者を集計対象としています。おおよその特徴を把握するためにお使いください。"]
["このツール内に個人単位のデータが残ることはありません。"]
["2GB(約350万人)を超えるCSVファイルは扱えません。"]
["見本データは全て仮想値です。"]
[]
["このエクセルファイルは、マクロを使っています。\nセキュリティの警告でマクロが無効にされた場合は、コンテンツの有効化を行って下さい。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["履歴"]
["Ver.1.2  2026/6/22　公開"]

{"sheet":"ここから開始","index":1,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
[{"$f":"使い方!A1","v":"特定健診まだら受診等分析ツールVer.1.2"},null,null,null,"受療状況",2,"←消さないでください"]
[null,"使い方：「参照」でＫＤＢの被保険者管理台帳（CSVファイル）を指定して「計算開始」",null,null,"分析年度",2,"←消さないでください"]

{"sheet":"出力票","index":2,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,1,24,16]]}
[null,"特定健診受診と医療機関通院（医科全て）の状況【999999 ＊＊市 R06年度（累計）】（１年度前-２年度前-３年度前の解析）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ここから開始!A1","v":"特定健診まだら受診等分析ツールVer.1.2"}]
[null,"該当人数"]
[null,null,"男性",null,null,null,null,"女性",null,null,null,null,"男女計"]
[null,"年齢階級","３年連続受診","まだら受診","未受診・未通院","未受診・通院","有資格計",{"$f":"C4","v":"３年連続受診"},{"$f":"D4","v":"まだら受診"},"未受診・未通院","未受診・通院","有資格計",{"$f":"C4","v":"３年連続受診"},{"$f":"D4","v":"まだら受診"},"未受診・未通院","未受診・通院","有資格計"]
[null,"42-44歳",75,213,560,244,1092,93,198,268,226,785,168,411,828,470,1877]
[null,"45-49歳",269,369,1071,508,2217,288,348,617,418,1671,557,717,1688,926,3888]
[null,"50-54歳",408,436,1118,798,2760,399,465,731,551,2146,807,901,1849,1349,4906]
[null,"55-59歳",458,412,938,694,2502,533,461,587,555,2136,991,873,1525,1249,4638]
[null,"60-64歳",431,361,605,687,2084,732,562,479,644,2417,1163,923,1084,1331,4501]
[null,"65-69歳",993,739,671,1094,3497,1955,1241,732,1263,5191,2948,1980,1403,2357,8688]
[null,"70-74歳",2587,1662,891,2177,7317,4304,2233,1057,2694,10288,6891,3895,1948,4871,17605]
[null,"計",5221,4192,5854,6202,21469,8304,5508,4471,6351,24634,13525,9700,10325,12553,46103]
[]
[null,"全体に占める割合"]
[null,null,"男性",null,null,null,null,"女性",null,null,null,null,"男女計"]
[null,"年齢階級",{"$f":"C4&CHAR(10)&\"計\"&FIXED(C24*100,1)&\"%\"","v":"３年連続受診\n計24.3%"},{"$f":"D4&CHAR(10)&\"計\"&FIXED(D24*100,1)&\"%\"","v":"まだら受診\n計19.5%"},"未受診・未通院\n計27.3%","未受診・通院\n計28.9%","有資格計",{"$f":"H4&CHAR(10)&\"計\"&FIXED(H24*100,1)&\"%\"","v":"３年連続受診\n計33.7%"},{"$f":"I4&CHAR(10)&\"計\"&FIXED(I24*100,1)&\"%\"","v":"まだら受診\n計22.4%"},"未受診・未通院\n計18.1%","未受診・通院\n計25.8%","有資格計",{"$f":"M4&CHAR(10)&\"計\"&FIXED(M24*100,1)&\"%\"","v":"３年連続受診\n計29.3%"},{"$f":"N4&CHAR(10)&\"計\"&FIXED(N24*100,1)&\"%\"","v":"まだら受診\n計21.0%"},"未受診・未通院\n計22.4%","未受診・通院\n計27.2%","有資格計"]
[null,"42-44歳",{"$f":"C5/$G$12","v":3.4934091014951793E-3},{"$f":"D5/$G$12","v":9.9212818482463088E-3},2.6084121291164004E-2,1.1365224276864316E-2,5.0864036517769808E-2,{"$f":"H5/$L$12","v":3.7752699520987253E-3},{"$f":"I5/$L$12","v":8.0376715109198669E-3},1.0879272550133962E-2,9.1743119266055051E-3,3.1866525939758056E-2,{"$f":"M5/$Q$12","v":3.6440144892957074E-3},{"$f":"N5/$Q$12","v":8.914821161312713E-3},1.795978569724313E-2,1.0194564345053466E-2,4.0713185692905017E-2]
[null,"45-49歳",{"$f":"C6/$G$12","v":1.252969397736271E-2},1.7187572779356283E-2,4.9885881969351155E-2,2.3662024314127346E-2,0.1032651730401975,{"$f":"H6/$L$12","v":1.1691158561337988E-2},1.4126816594950069E-2,2.504668344564423E-2,1.6968417634164162E-2,6.7833076236096454E-2,{"$f":"M6/$Q$12","v":1.2081643277010173E-2},1.5552133266815609E-2,3.6613669392447347E-2,2.0085460815998959E-2,8.4332906752272091E-2]
[null,"50-54歳",{"$f":"C7/$G$12","v":1.9004145512133773E-2},2.0308351576691974E-2,5.2075085006288137E-2,3.7169872839908705E-2,0.1285574549350226,{"$f":"H7/$L$12","v":1.6197125923520336E-2},1.8876349760493627E-2,2.9674433709507186E-2,2.2367459608670943E-2,8.7115369002192092E-2,{"$f":"M7/$Q$12","v":1.7504283886081166E-2},1.9543196755091859E-2,4.0105849944689069E-2,2.926056872654708E-2,0.10641389931240917]
[null,"55-59歳",{"$f":"C8/$G$12","v":2.1333084913130559E-2},1.9190460664213517E-2,4.3690903162699704E-2,3.2325678885835388E-2,0.11654012762587918,{"$f":"H8/$L$12","v":2.1636762198587317E-2},1.8713972558252821E-2,2.3828854428838191E-2,2.2529836810911748E-2,8.6709425996590081E-2,{"$f":"M8/$Q$12","v":2.1495347374357418E-2},1.8935861006875908E-2,3.3078107715333059E-2,2.7091512482918682E-2,0.10060082857948506]
[null,"60-64歳",{"$f":"C9/$G$12","v":2.0075457636592294E-2},1.6814942475196794E-2,2.8180166752061111E-2,3.1999627369695839E-2,9.7070194233546042E-2,{"$f":"H9/$L$12","v":2.9715028010067385E-2},2.2813996914833157E-2,1.9444669968336447E-2,2.6142729560769667E-2,9.8116424454006659E-2,{"$f":"M9/$Q$12","v":2.5226124113398262E-2},2.0020389128690107E-2,2.3512569680931825E-2,2.8870138602693968E-2,9.7629221525714155E-2]
[null,"65-69歳",{"$f":"C10/$G$12","v":4.6252736503796174E-2},3.4421724346732498E-2,3.125436676137687E-2,5.095719409380968E-2,0.16288602170571523,{"$f":"H10/$L$12","v":7.9361857595193638E-2},5.0377526995209872E-2,2.9715028010067385E-2,5.12706016075343E-2,0.21072501420800518,{"$f":"M10/$Q$12","v":6.3943778062165155E-2},4.2947313623842263E-2,3.0431859098106414E-2,5.1124655662321321E-2,0.18844760644643516]
[null,"70-74歳",{"$f":"C11/$G$12","v":0.1204993246075737},7.7413945689133165E-2,4.1501700125762729E-2,0.10140202151940006,0.34081699194186965,{"$f":"H11/$L$12","v":0.17471786961110661},9.0647073150929611E-2,4.2908175692132823E-2,0.10936104570918243,0.41763416416335147,{"$f":"M11/$Q$12","v":0.14946966574843285},8.4484740689326071E-2,4.2253215625881177E-2,0.10565472962713923,0.38186235169077937]
[null,"計",{"$f":"C12/$G$12","v":0.24318785225208439},0.19525827937957055,0.2726722250687037,0.28888164329964133,1,{"$f":"H12/$L$12","v":0.33709507185191201},0.22359340748558904,0.18149711780466021,0.25781440285783874,1,{"$f":"M12/$Q$12","v":0.29336485695074072},0.21039845563195453,0.22395505715463201,0.27228163026267271,1]
[null,"解析対象はタイトルに表示されている３年度継続（4/1～3/31通年）で有資格の者　年齢はうち最新年度の年齢　「通院」は同最新年度に医療のレセプトがある者　「まだら受診」は３年度間で特定健診を１～２回受診した者　"]