{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["メインメニュー","共通入力フォーム","入力フォーム","提出フォーム","チェック仕様","西暦和暦早見表"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"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":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,2,5,7],[6,4,6,5]]}
[]
[]
[null,null,"　社保福祉簡易入力ツール　"]
[]
[]
[]
[null,null,null,null,"Ver. 1.2"]

{"sheet":"共通入力フォーム","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,1,"医療機関番号","0000000010"]
[null,2,"医療機関等所在地","愛媛県松山市小坂○-○-○"]
[null,3,"医療機関等名称","愛媛整形外科"]
[null,4,"代表者氏名","愛媛　太郎"]
[null,5,"請求年月日",20220301]

{"sheet":"入力フォーム","index":2,"n_rows":49,"n_cols":21,"rows_kept":49,"cut":false,"hidden":true,"merged":[[3,10,3,12],[3,13,3,14],[3,6,4,8],[3,2,4,5],[6,3,7,9],[6,10,6,13],[7,10,7,13],[6,14,6,20],[7,14,7,20],[3,15,3,17],[3,18,3,20],[4,15,5,17],[4,18,5,19],[4,20,5,20],[4,13,5,14],[4,10,5,12],[9,0,9,2],[7,0,7,2],[8,0,8,2],[8,3,9,9],[6,0,6,2],[11,14,11,20],[12,1,13,1],[12,2,13,2],[12,3,13,4],[12,14,12,18],[12,19,12,20],[13,14,13,18],[13,19,13,20],[10,0,10,2],[10,11,10,12],[11,0,13,0],[11,1,11,4],[11,5,11,13],[13,8,13,13],[12,8,12,13],[13,5,13,7],[12,5,12,7],[14,1,14,4],[14,5,14,20],[14,0,18,0],[15,1,18,1],[15,3,18,4],[15,2,18,2],[34,0,38,0],[28,20,31,20],[22,20,24,20],[23,5,24,6],[23,7,24,8],[23,9,24,10],[25,5,25,6],[25,7,25,8],[25,9,25,10],[25,11,27,13],[25,14,27,19],[25,20,27,20],[22,1,27,4],[22,5,22,6],[22,7,22,8],[22,9,22,10],[40,17,40,19],[26,5,27,6],[26,7,27,8],[26,9,27,10],[28,1,31,10],[28,11,31,19],[34,17,35,20],[36,17,38,20],[34,1,38,16],[10,14,10,20],[8,14,9,20],[10,3,10,9],[8,10,8,13],[9,10,9,13],[19,1,21,10],[19,11,21,19],[19,20,21,20],[22,11,24,13],[22,14,24,19]]}
[]
[null,null,null,null,"福祉医療費支給申請・請求明細書"]
[]
[null,null,202202,null,null,null,"月診療分",null,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,null,"割"]
[null,null,"（年月を「YYYYMM」(西暦）で入力）"]
["保 険 者",null,null,null,null,null,null,null,null,null,"被保険者証記号",null,null,null,""]
["番  号",null,null,null,null,null,null,null,null,null,"被保険者証番号",null,null,null,""]
["公費負担者",true,null,null,null,null,null,null,null,null,"公費負担医療"]
["番  号",null,null,null,null,null,null,null,null,null,"受給者番号"]
["患 者 氏 名",true,null,"",null,null,null,null,null,null,"性別",null,null,"生年月日"]
["１入院","診療日数",null,null,null,"入院期間",null,null,null,null,null,null,null,null,"特記事項（下記注意事項参照）"]
[null,"（",{"$f":"入院診療日数計算(I13,I14)","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,""]
["2外来","診療日数",null,null,null,"診　　療　　日　（該当日に○）"]
[null,"（",{"$f":"診療日数計算(F17,G17,H17,I17,J17,K17,L17,M17,N17,O17,P17,Q17,R17,S17,T17,U17,F19,G19,H19,I19,J19,K19,L19,M19,N19,O19,P19,Q19,R19,S19,T19)","v":""},"）日間",null,1,"2",3,"4","5","6","7",8,"9","10","11","12","13","14","15","16"]
[null,null,null,null,null,"","","","","","","","","","","","","","","",""]
[null,null,null,null,null,"17","18","19","20","21","22","23","24","25","26","27","28","29","30","31"]
[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,"1精神",null,"2結核",null,"3更生",null,"自己負担月額",null,null,null,null,null,null,null,null,"円"]
["報",null,null,null,null,"",null,"",null,""]
["酬"]
["請",null,null,null,null,"4育成",null,"5特疾",null,"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,null,null,null,null,"円"]
["内"]
["訳"]
[]
[]
[]
["備\n考","",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,""]
[]
[]
[]
[]
[]
["＊ 年月日は「YYYYMMDD」(西暦）で入力して下さい。（例：令和3年8月26日は「20210826」と入力）"]
["＊ 特定疾病に該当する場合、「02長→02」または「16長→16」を選択してください。"]
["＊ 所得区分が適用され場合、「26区ア→26」「27区イ→27」「28区ウ→28」「29区エ→29」「30区オ→30」"]
["　　を選択してください。"]
["＊ 請求金額に少数点以下が発生する場合は、少数点第1位の位を切り上げて円単位で入力して下さい。"]
["＊ 多数該当の場合は、「31多ア→31」「32多イ→32」「33多ウ→33」「34多エ→34」「35多オ→35」"]
["　　を備考欄に入力してください。"]

{"sheet":"提出フォーム","index":3,"n_rows":7,"n_cols":72,"rows_kept":7,"cut":false,"hidden":true,"merged":[[5,70,6,70],[5,71,6,71],[5,16,6,16],[5,17,6,17],[5,18,6,18],[5,50,6,50],[5,61,6,61],[5,62,5,67],[5,51,5,60],[5,19,5,49],[5,8,6,8],[5,9,6,9],[5,10,6,10],[5,68,6,68],[5,69,6,69],[5,11,6,11],[5,12,6,12],[5,1,6,1],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,2,6,2],[5,3,6,3],[4,19,4,49],[4,51,4,60],[4,62,4,67],[5,13,6,13],[5,14,6,14],[5,15,6,15]]}
[]
[]
[]
[]
[null,"No",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,20,null,null,null,null,null,null,null,null,null,21,22,null,null,null,null,null,23,24,25,26]
[null,"項目","診療月","保険種別","保険区分","前期高齢者","一部負担割合","保険者番号","被保険者証記号","被保険者証番号","公費負担者番号","公費負担医療受給者番号","患者氏名","性別","生年月日","入院診療日数","入院診療開始日","入院診療終了日","外来診療日数","福祉医療日",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"傷病名および期間","特定疾病等",null,null,null,null,null,null,null,null,null,"総診療報酬点数","他公費",null,null,null,null,null,"自己負担月額","公費負担額","請求金額","備考"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,"02","16","17","18","19","26","27","28","29","30",null,"精神","結核","更生","育成","特疾","その他"]

{"sheet":"チェック仕様","index":4,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[[35,0,37,0],[35,1,37,1],[44,0,46,0],[44,1,46,1],[64,0,65,0],[64,1,65,1],[53,0,56,0],[53,1,56,1],[57,0,60,0],[57,1,60,1],[61,0,63,0],[61,1,63,1],[25,0,26,0],[25,1,26,1],[29,0,31,0],[29,1,31,1],[32,0,34,0],[32,1,34,1],[16,0,17,0],[16,1,17,1],[19,0,20,0],[19,1,20,1],[23,0,24,0],[23,1,24,1],[3,0,5,0],[3,1,5,1],[6,0,7,0],[6,1,7,1],[11,0,13,0],[11,1,13,1]]}
["【入力項目チェック仕様】"]
[]
["No","項目名","枝番","チェック内容","エラー発生条件"]
["01","診療月","01","桁数チェック","桁数が6桁以外の場合"]
[null,null,"02","日付チェック","正常な日付でない場合"]
[null,null,"03","年月値チェック","入力月より大きい値が指定された場合"]
["02","医療機関番号","01","桁数チェック","桁数が10桁以上の場合"]
[null,null,"02","数値チェック","数値でない場合"]
["03","医療機関等所在地","01","桁数チェック","入力されていない、もしくは全角50文字より大きい場合"]
["04","医療機関等名称","01","桁数チェック","入力されていない、もしくは全角15文字より大きい場合"]
["05","代表者氏名","01","桁数チェック","入力されていない、もしくは全角15文字より大きい場合"]
["06","請求年月日","01","桁数チェック","桁数が8桁以外の場合"]
[null,null,"02","日付チェック","正常な日付でない場合"]
[null,null,"03","年月値チェック","入力月の翌月より大きい値が指定された場合"]
["07","保険種別","01","値チェック","1，2，3以外が指定された場合"]
["08","区分","01","値チェック","1以外が指定された場合"]
["09","前期高齢者","01","値チェック","7、8、9以外が入力された場合（省略は可能）"]
[null,null,"02","関連チェック","入力された場合で一部負担割合と前期高齢者の合計が10以外"]
["10","一部負担割合","01","値チェック","1、2、3以外が入力された場合"]
["11","保険者番号","01","桁数チェック","入力されていない、もしくは8桁より大きい場合"]
[null,null,"02","数値チェック","数値でない場合"]
["12","被保険者証記号","01","桁数チェック","20桁より大きい場合"]
["13","被保険者証番号","01","桁数チェック","入力されていない、もしくは20桁より大きい場合"]
["14","公費負担者番号","01","桁数チェック","入力されていない、もしくは8桁より大きい場合"]
[null,null,"02","数値チェック","数値でない場合"]
["15","公費負担者受給者番号","01","桁数チェック","入力されていない、もしくは7桁より大きい場合"]
[null,null,"02","数値チェック","数値でない場合"]
["16","患者氏名","01","桁数チェック","入力されていない、もしくは全角25文字より大きい場合"]
["17","性別","01","値チェック","1、2以外が入力された場合"]
["18","生年月日","01","桁数チェック","桁数が8桁以外の場合"]
[null,null,"02","日付チェック","正常な日付でない場合"]
[null,null,"03","年月値チェック","診療年月より大きい値が指定された場合"]
["19","入院診療開始日","01","桁数チェック","桁数が8桁以外の場合（入力された場合）"]
[null,null,"02","日付チェック","正常な日付でない場合（入力された場合）"]
[null,null,"03","年月値チェック","診療年月と異なる値が指定された場合"]
["20","入院診療終了日","01","桁数チェック","桁数が8桁以外の場合（入力された場合）"]
[null,null,"02","日付チェック","正常な日付でない場合（入力された場合）"]
[null,null,"03","年月値チェック","診療年月と異なる値が指定された場合"]
["21","福祉医療日１～31","01","値チェック","〇以外が入力された場合（省略は可能）"]
["22","入院診療日数","01","範囲指定チェック","入院診療開始日が入院診療終了日よりも大きい場合"]
["23","診療日数","01","値チェック","入院診療日数と外来診療日数が両方とも指定されている場合"]
["24","外来診療日","01","日付チェック","正常な日付でない場合（入力された場合）"]
["25","特定疾病","01","値チェック","02、16以外が入力された場合（省略は可能）"]
["26","所得区分","01","値チェック","26、27、28、29、30以外が入力された場合（省略は可能）"]
["27","総診療報酬点数","01","桁数チェック","入力されていない、もしくは7桁より大きい場合"]
[null,null,"02","数値チェック","数値でない場合"]
[null,null,"03","値チェック","1以下の場合"]
["28","他公費精神","01","値チェック","〇以外が入力された場合（省略は可能）"]
["29","他公費結核","01","値チェック","〇以外が入力された場合（省略は可能）"]
["30","他公費更生","01","値チェック","〇以外が入力された場合（省略は可能）"]
["31","他公費育成","01","値チェック","〇以外が入力された場合（省略は可能）"]
["32","他公費特疾","01","値チェック","〇以外が入力された場合（省略は可能）"]
["33","他公費その他","01","値チェック","〇以外が入力された場合（省略は可能）"]
["34","自己負担月額","01","必須チェック","他公費のいずれかが入力された場合、省略不可"]
[null,null,"02","桁数チェック","7桁より大きい場合"]
[null,null,"03","数値チェック","数値でない場合"]
[null,null,"04","値チェック","0より小さい場合"]
["35","公費負担月額","01","必須チェック","他公費のいずれかが入力された場合、省略不可"]
[null,null,"02","桁数チェック","7桁より大きい場合"]
[null,null,"03","数値チェック","数値でない場合"]
[null,null,"04","値チェック","0より小さい場合"]
["36","請求金額","01","桁数チェック","入力されていない、もしくは8桁より大きい場合"]
[null,null,"02","数値チェック","数値でない場合"]
[null,null,"03","値チェック","1以下の場合"]
["37","備考","01","桁数チェック","多数該当でない場合、全角100文字より大きい場合"]
[null,null,"02","桁数チェック","多数該当の場合、全角97文字より大きい場合"]
["38","多数該当","01","値チェック","31、32、33、34、35以外が入力された場合（省略は可能）"]

{"sheet":"西暦和暦早見表","index":5,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["和暦","西暦","和暦","西暦","和暦","西暦"]
["明治 45\n大正 元年",1912,"昭和 26",1951,"平成 2",1990]
["大正 2",1913,"昭和 27",1952,"平成 3",1991]
["大正 3",1914,"昭和 28",1953,"平成 4",1992]
["大正 4",1915,"昭和 29",1954,"平成 5",1993]
["大正 5",1916,"昭和 30",1955,"平成 6",1994]
["大正 6",1917,"昭和 31",1956,"平成 7",1995]
["大正 7",1918,"昭和 32",1957,"平成 8",1996]
["大正 8",1919,"昭和 33",1958,"平成 9",1997]
["大正 9",1920,"昭和 34",1959,"平成 10",1998]
["大正 10",1921,"昭和 35",1960,"平成 11",1999]
["大正 11",1922,"昭和 36",1961,"平成 12",2000]
["大正 12",1923,"昭和 37",1962,"平成 13",2001]
["大正 13",1924,"昭和 38",1963,"平成 14",2002]
["大正 14",1925,"昭和 39",1964,"平成 15",2003]
["大正 15\n昭和 元年",1926,"昭和 40",1965,"平成 16",2004]
["昭和 2",1927,"昭和 41",1966,"平成 17",2005]
["昭和 3",1928,"昭和 42",1967,"平成 18",2006]
["昭和 4",1929,"昭和 43",1968,"平成 19",2007]
["昭和 5",1930,"昭和 44",1969,"平成 20",2008]
["昭和 6",1931,"昭和 45",1970,"平成 21",2009]
["昭和 7",1932,"昭和 46",1971,"平成 22",2010]
["昭和 8",1933,"昭和 47",1972,"平成 23",2011]
["昭和 9",1934,"昭和 48",1973,"平成 24",2012]
["昭和 10",1935,"昭和 49",1974,"平成 25",2013]
["昭和 11",1936,"昭和 50",1975,"平成 26",2014]
["昭和 12",1937,"昭和 51",1976,"平成 27",2015]
["昭和 13",1938,"昭和 52",1977,"平成 28",2016]
["昭和 14",1939,"昭和 53",1978,"平成 29",2017]
["昭和 15",1940,"昭和 54",1979,"平成 30",2018]
["昭和 16",1941,"昭和 55",1980,"平成 31\n令和 元年",2019]
["昭和 17",1942,"昭和 56",1981,"令和 2",2020]
["昭和 18",1943,"昭和 57",1982,"令和 3",2021]
["昭和 19",1944,"昭和 58",1983,"令和 4",2022]
["昭和 20",1945,"昭和 59",1984,"令和 5",2023]
["昭和 21",1946,"昭和 60",1985,"令和 6",2024]
["昭和 22",1947,"昭和 61",1986,"令和 7",2025]
["昭和 23",1948,"昭和 62",1987,"令和 8",2026]
["昭和 24",1949,"昭和 63",1988,"令和 9",2027]
["昭和 25",1950,"昭和 64\n平成 元年",1989,"令和 10",2028]