{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["共通部分マスター","総括表","【記載例】市区町村別","【入力用】市区町村別 "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":2,"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":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
[]
[null,null,"医療機関入力欄"]
[null,null,"請求先","○○都道府県国民健康保険団体連合会　御中"]
[null,null,"施設等区分","1:医療機関"]
[null,null,"医療機関等コード",1234567890]
[null,null,"医療機関名","厚労病院○○○○○○○○○○○○"]
[null,null,"請求年月","2019年○○月分","←毎月更新"]
[null,null,"医院所在地","○○県○○市○○町○丁目○番○号"]
[null,null,"代表者氏名","労働次郎"]
[null,null,"電話番号","○○○ー○○○ー○○○○"]
[]
[null,null,"消費税率","10","←消費税率改正時に修正"]
[]
[null,null,"【入力時の注意事項】"]
[null,null,"・医療機関コードは、半角10桁の番号で入力してください。"]
[null,null,"・医療機関名及び医師名は、１行あたり全角16文字以内におさめてください。"]
[null,null,"・市町村別の各請求書の欄外にて計算いただくと総括表まで仕上がる仕様です。"]
[]
[null,null,"①健診・HI法",1290]
[null,null,"②健診・EIA法",2680]
[null,null,"③HI法",4930]
[null,null,"④EIA法",6320]
[null,null,"⑤夜間休日・HI法",5430]
[null,null,"⑥夜間休日・EIA法",6820]

{"sheet":"総括表","index":1,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[9,1,9,7],[27,2,27,3],[30,2,30,3],[31,1,31,3],[21,1,27,1],[28,1,30,1],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[28,2,28,3],[29,2,29,3],[13,4,13,5],[20,2,20,3]]}
[]
[]
[null,{"$f":"共通部分マスター!D3","v":"○○都道府県国民健康保険団体連合会　御中"}]
[]
[null,null,null,null,{"$f":"共通部分マスター!D8","v":"○○県○○市○○町○丁目○番○号"}]
[null,"　　　　",null,null,"代表者氏名",{"$f":"共通部分マスター!D9","v":"労働次郎"}]
[null,null,null,null,"電話番号",{"$f":"共通部分マスター!D10","v":"○○○ー○○○ー○○○○"}]
[]
[]
[null,"　風しん対策　請求総括書（実績報告書）"]
[]
[]
[null,"施設等区分",null,null,{"$f":"共通部分マスター!D4","v":"1:医療機関"}]
[null,"医療機関・健診機関番号",null,null,{"$f":"共通部分マスター!D5","v":1234567890}]
[null,"医療機関・健診機関名称",null,null,{"$f":"共通部分マスター!D6","v":"厚労病院○○○○○○○○○○○○"}]
[null,"請求年月",null,null,{"$f":"共通部分マスター!D7","v":"2019年○○月分"}]
[]
[]
[]
[]
[null,null,"区分",null,"請求件数","請求金額\n（税抜）","請求金額\n（税込）"]
[null,"抗体検査","①健診・HI法",null,0,0,0]
[null,null,"②健診・EIA法",null,0,0,0]
[null,null,"③HI法",null,0,0,0]
[null,null,"④EIA法",null,0,0,0]
[null,null,"⑤夜間休日・HI法",null,0,0,0]
[null,null,"⑥夜間休日・EIA法",null,0,0,0]
[null,null,"小計",null,{"$f":"SUM(E22:E27)","v":0},{"$f":"SUM(F22:F27)","v":0},{"$f":"SUM(G22:G27)","v":0}]
[null,"予防接種","通常",null,0,0,0]
[null,null,"予診のみ",null,0,0,0]
[null,null,"小計",null,{"$f":"SUM(E29:E30)","v":0},{"$f":"SUM(F29:F30)","v":0},{"$f":"SUM(G29:G30)","v":0}]
[null,"合計",null,null,{"$f":"E28+E31","v":0},{"$f":"F28+F31","v":0},{"$f":"G28+G31","v":0}]
[null,"※予診のみの費用を市区町村が設定していない場合（０円の場合）は、本総括書に"]
[null,"計上しないこと。その場合、予診票の原本を国民健康保険団体連合会に送付しない"]
[null,"こと。"]

{"sheet":"【記載例】市区町村別","index":2,"n_rows":38,"n_cols":23,"rows_kept":38,"cut":false,"hidden":false,"merged":[[25,4,25,7],[26,4,26,7],[27,4,27,7],[28,4,28,7],[29,4,29,7],[32,14,32,16],[29,15,29,16],[30,15,30,16],[31,15,31,16],[32,1,32,7],[29,1,31,3],[30,4,30,7],[31,4,31,7],[1,1,1,6],[10,1,10,11],[22,14,28,14],[22,15,22,16],[29,14,31,14],[13,8,13,9],[23,15,23,16],[24,15,24,16],[25,15,25,16],[26,15,26,16],[27,15,27,16],[28,15,28,16],[22,1,28,3],[22,4,22,7],[23,4,23,7],[24,4,24,7]]}
[]
[null,"○○○市区町村長様"]
[null,"市区町村番号"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"共通部分マスター!D8","v":"○○県○○市○○町○丁目○番○号"}]
[null,"　　　　",null,null,null,null,null,null,"代表者氏名",{"$f":"共通部分マスター!D9","v":"労働次郎"}]
[null,null,null,null,null,null,null,null,"電話番号",{"$f":"共通部分マスター!D10","v":"○○○ー○○○ー○○○○"}]
[]
[]
[null,"風しん対策　市区町村別請求書"]
[]
[]
[null,"医療機関・健診機関番号",null,null,null,null,null,null,{"$f":"共通部分マスター!D5","v":1234567890}]
[null,"医療機関・健診機関名称",null,null,null,null,null,null,{"$f":"共通部分マスター!D6","v":"厚労病院○○○○○○○○○○○○"}]
[null,"請求年月",null,null,null,null,null,null,{"$f":"共通部分マスター!D7","v":"2019年○○月分"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"【計算スペース】※こちらに件数を記入すると請求書が埋まっていきます"]
[null,null,null,null,null,null,null,null,"請求件数","請求金額\n（税抜）","請求金額\n（税込）",null,null,null,null,null,null,"請求件数","税抜き単価","税込み単価","請求総額（税抜き）\n※システムエラーのチェック用","請求総額（税込み）"]
[null,"抗体検査",null,null,"①健診・HI法",null,null,null,{"$f":"R23","v":0},{"$f":"U23","v":0},{"$f":"V23","v":0},null,null,null,"抗体検査","①健診・HI法",null,null,{"$f":"共通部分マスター!D19","v":1290},{"$f":"ROUNDDOWN(S23*(1+(共通部分マスター!$D$12)/100),0)","v":1419},{"$f":"S23*R23","v":0},{"$f":"T23*R23","v":0}]
[null,null,null,null,"②健診・EIA法",null,null,null,0,0,0,null,null,null,null,"②健診・EIA法",null,null,{"$f":"共通部分マスター!D20","v":2680},{"$f":"ROUNDDOWN(S24*(1+(共通部分マスター!$D$12)/100),0)","v":2948},0,0]
[null,null,null,null,"③HI法",null,null,null,0,0,0,null,null,null,null,"③HI法",null,null,{"$f":"共通部分マスター!D21","v":4930},{"$f":"ROUNDDOWN(S25*(1+(共通部分マスター!$D$12)/100),0)","v":5423},0,0]
[null,null,null,null,"④EIA法",null,null,null,0,0,0,null,null,null,null,"④EIA法",null,null,{"$f":"共通部分マスター!D22","v":6320},{"$f":"ROUNDDOWN(S26*(1+(共通部分マスター!$D$12)/100),0)","v":6952},0,0]
[null,null,null,null,"⑤夜間休日・HI法",null,null,null,0,0,0,null,null,null,null,"⑤夜間休日・HI法",null,null,{"$f":"共通部分マスター!D23","v":5430},{"$f":"ROUNDDOWN(S27*(1+(共通部分マスター!$D$12)/100),0)","v":5973},0,0]
[null,null,null,null,"⑥夜間休日・EIA法",null,null,null,0,0,0,null,null,null,null,"⑥夜間休日・EIA法",null,null,{"$f":"共通部分マスター!D24","v":6820},{"$f":"ROUNDDOWN(S28*(1+(共通部分マスター!$D$12)/100),0)","v":7502},0,0]
[null,null,null,null,"小計",null,null,null,0,0,0,null,null,null,null,"小計",null,{"$f":"SUM(R23:R28)","v":0},null,null,{"$f":"SUM(U23:U28)","v":0},{"$f":"SUM(V23:V28)","v":0}]
[null,"予防接種",null,null,"通常",null,null,null,0,0,0,null,null,null,"予防接種","通常",null,null,null,{"$f":"ROUNDDOWN(S30*(1+(共通部分マスター!$D$12)/100),0)","v":0},{"$f":"S30*R30","v":0},{"$f":"T30*R30","v":0},"←予防接種関係の価格は市区町村で決定いたします。クーポンの下５桁に記載の金額を記載ください。"]
[null,null,null,null,"予診のみ",null,null,null,0,0,0,null,null,null,null,"予診のみ",null,null,null,{"$f":"ROUNDDOWN(S31*(1+(共通部分マスター!$D$12)/100),0)","v":0},{"$f":"S31*R31","v":0},{"$f":"T31*R31","v":0},"  ※税込単価は、１円未満の端数は切り捨て"]
[null,null,null,null,"小計",null,null,null,0,{"$f":"SUM(J30:J31)","v":0},{"$f":"SUM(K30:K31)","v":0},null,null,null,null,"小計",null,{"$f":"SUM(R30:R31)","v":0},null,null,{"$f":"SUM(U30:U31)","v":0},{"$f":"SUM(V30:V31)","v":0},"　※予診のみの費用を市町村が設定していない場合（０円の場合）は、本請求書に計上しないこと。その場合、予診票の原本を国民健康保険団体連合会に送付しないこと。"]
[null,"合計",null,null,null,null,null,null,0,{"$f":"J32+J29","v":0},{"$f":"K32+K29","v":0},null,null,null,"合計",null,null,{"$f":"R32+R29","v":0},null,null,{"$f":"U32+U29","v":0},{"$f":"V32+V29","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"消費税率",{"$f":"共通部分マスター!D12","v":"10"},"％"]
[null,"※予診のみの費用を市区町村が設定していない場合（０円の場合）は、本請"]
[null,"求書に計上しないこと。その場合、予診票の原本を国民健康保険団体連合会"]
[null,"に送付しないこと。"]

{"sheet":"【入力用】市区町村別 ","index":3,"n_rows":38,"n_cols":23,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,6],[32,1,32,7],[32,14,32,16],[28,4,28,7],[28,15,28,16],[29,1,31,3],[29,4,29,7],[29,14,31,14],[29,15,29,16],[30,4,30,7],[30,15,30,16],[31,4,31,7],[31,15,31,16],[25,15,25,16],[26,4,26,7],[26,15,26,16],[27,4,27,7],[27,15,27,16],[10,1,10,11],[13,8,13,9],[22,1,28,3],[22,4,22,7],[22,14,28,14],[25,4,25,7],[22,15,22,16],[23,4,23,7],[23,15,23,16],[24,4,24,7],[24,15,24,16]]}
[]
[null,"○○○市区町村長様"]
[null,"市区町村番号"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"共通部分マスター!D8","v":"○○県○○市○○町○丁目○番○号"}]
[null,"　　　　",null,null,null,null,null,null,"代表者氏名",{"$f":"共通部分マスター!D9","v":"労働次郎"}]
[null,null,null,null,null,null,null,null,"電話番号",{"$f":"共通部分マスター!D10","v":"○○○ー○○○ー○○○○"}]
[]
[]
[null,"風しん対策　市区町村別請求書"]
[]
[]
[null,"医療機関・健診機関番号",null,null,null,null,null,null,{"$f":"共通部分マスター!D5","v":1234567890}]
[null,"医療機関・健診機関名称",null,null,null,null,null,null,{"$f":"共通部分マスター!D6","v":"厚労病院○○○○○○○○○○○○"}]
[null,"請求年月",null,null,null,null,null,null,{"$f":"共通部分マスター!D7","v":"2019年○○月分"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"【計算スペース】※こちらに件数を記入すると請求書が埋まっていきます"]
[null,null,null,null,null,null,null,null,"請求件数","請求金額\n（税抜）","請求金額\n（税込）",null,null,null,null,null,null,"請求件数","税抜き単価","税込み単価","請求総額（税抜き）\n※システムエラーのチェック用","請求総額（税込み）"]
[null,"抗体検査",null,null,"①健診・HI法",null,null,null,{"$f":"R23","v":0},{"$f":"U23","v":0},0,null,null,null,"抗体検査","①健診・HI法",null,null,{"$f":"共通部分マスター!D19","v":1290},{"$f":"ROUNDDOWN(S23*(1+(共通部分マスター!$D$12)/100),0)","v":1419},{"$f":"S23*R23","v":0},{"$f":"T23*R23","v":0}]
[null,null,null,null,"②健診・EIA法",null,null,null,0,0,0,null,null,null,null,"②健診・EIA法",null,null,{"$f":"共通部分マスター!D20","v":2680},{"$f":"ROUNDDOWN(S24*(1+(共通部分マスター!$D$12)/100),0)","v":2948},0,{"$f":"T24*R24","v":0}]
[null,null,null,null,"③HI法",null,null,null,0,0,0,null,null,null,null,"③HI法",null,null,{"$f":"共通部分マスター!D21","v":4930},{"$f":"ROUNDDOWN(S25*(1+(共通部分マスター!$D$12)/100),0)","v":5423},0,0]
[null,null,null,null,"④EIA法",null,null,null,0,0,0,null,null,null,null,"④EIA法",null,null,{"$f":"共通部分マスター!D22","v":6320},{"$f":"ROUNDDOWN(S26*(1+(共通部分マスター!$D$12)/100),0)","v":6952},0,0]
[null,null,null,null,"⑤夜間休日・HI法",null,null,null,0,0,0,null,null,null,null,"⑤夜間休日・HI法",null,null,{"$f":"共通部分マスター!D23","v":5430},{"$f":"ROUNDDOWN(S27*(1+(共通部分マスター!$D$12)/100),0)","v":5973},0,0]
[null,null,null,null,"⑥夜間休日・EIA法",null,null,null,0,0,0,null,null,null,null,"⑥夜間休日・EIA法",null,null,{"$f":"共通部分マスター!D24","v":6820},{"$f":"ROUNDDOWN(S28*(1+(共通部分マスター!$D$12)/100),0)","v":7502},0,0]
[null,null,null,null,"小計",null,null,null,0,0,0,null,null,null,null,"小計",null,{"$f":"SUM(R23:R28)","v":0},null,null,{"$f":"SUM(U23:U28)","v":0},{"$f":"SUM(V23:V28)","v":0}]
[null,"予防接種",null,null,"通常",null,null,null,0,0,0,null,null,null,"予防接種","通常",null,null,null,{"$f":"ROUNDDOWN(S30*(1+(共通部分マスター!$D$12)/100),0)","v":0},{"$f":"S30*R30","v":0},{"$f":"T30*R30","v":0},"←予防接種関係の価格は市区町村で決定いたします。クーポンの下５桁に記載の金額を記載ください。"]
[null,null,null,null,"予診のみ",null,null,null,0,0,0,null,null,null,null,"予診のみ",null,null,null,{"$f":"ROUNDDOWN(S31*(1+(共通部分マスター!$D$12)/100),0)","v":0},{"$f":"S31*R31","v":0},{"$f":"T31*R31","v":0},"  ※税込単価は、１円未満の端数は切り捨て"]
[null,null,null,null,"小計",null,null,null,0,{"$f":"SUM(J30:J31)","v":0},{"$f":"SUM(K30:K31)","v":0},null,null,null,null,"小計",null,{"$f":"SUM(R30:R31)","v":0},null,null,{"$f":"SUM(U30:U31)","v":0},{"$f":"SUM(V30:V31)","v":0},"　※予診のみの費用を市町村が設定していない場合（０円の場合）は、本請求書に計上しないこと。その場合、予診票の原本を国民健康保険団体連合会に送付しないこと。"]
[null,"合計",null,null,null,null,null,null,0,{"$f":"J32+J29","v":0},{"$f":"K32+K29","v":0},null,null,null,"合計",null,null,{"$f":"R32+R29","v":0},null,null,{"$f":"U32+U29","v":0},{"$f":"V32+V29","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"消費税率",{"$f":"共通部分マスター!D12","v":"10"},"％"]
[null,"※予診のみの費用を市区町村が設定していない場合（０円の場合）は、本請"]
[null,"求書に計上しないこと。その場合、予診票の原本を国民健康保険団体連合会"]
[null,"に送付しないこと。"]