{"id":747,"date":"2025-01-30T15:22:26","date_gmt":"2025-01-30T06:22:26","guid":{"rendered":"https:\/\/en.mdv.co.jp\/news\/?p=747"},"modified":"2025-08-05T15:40:53","modified_gmt":"2025-08-05T06:40:53","slug":"introducing-an-automated-tool-to-display-surgery-counts-and-help-hospital-staff-with-seasonal-challenges","status":"publish","type":"post","link":"https:\/\/en.mdv.co.jp\/news\/2025\/article-747.html","title":{"rendered":"Introducing an automated tool to display surgery counts and help hospital staff with seasonal challenges"},"content":{"rendered":"\n

Medical Data Vision Co., Ltd. (Chiyoda-ku, Tokyo, President: Hiroyuki Iwasaki), a company that develops and provides hospital management support systems, is pleased to announce the launch of an automated tool for aggregating “surgery counts,” which hospitals are required to display on their bulletin board.<\/p>\n\n\n\n

<\/div>\n\n\n\n

Medical institutions are obligated to display the number of surgeries from the previous year (from January to December) for surgeries listed in Chapter 2, Section 10, General Rules 5 and 6 of the Medical Fee Schedule (including Chapter 2, Section 9, General Rules 4 of the Dental Fee Schedule) on-site, categorized according to the facility standards, when calculating surgery points for applicable procedures.

Until now, many hospital staff have manually counted the surgery numbers based on claim data and other sources, which was time-consuming and became a burden during the period when the previous year’s data was finalized, putting additional pressure on normal operations.

To address this issue, we have developed an Excel tool, “Surgery Count Aggregation Tool for bulletin board in the hospital (Surgery Facility Standards),” which automatically aggregates surgery counts using DPC data and other sources. This tool will be provided for free on our community website “Chokotsuna” (*1).

With this tool, hospitals that previously took about a week to aggregate surgery counts will now be able to complete the process in approximately 2 minutes (*note: aggregation time may vary depending on computer specifications and data volume). Hospital staff are expected to benefit from improved operational efficiency.<\/p>\n\n\n\n

<\/div>\n\n\n\n
\n
\n

Image of the Aggregation Table<\/p>\n\n\n\n

\"\"<\/figure>\n<\/div>\n\n\n\n
\n

[Provision Location]
Community Website “Chokotsuna”<\/p>\n\n\n\n

[Operating Environment]
An environment where PowerQuery can be run in Excel<\/p>\n\n\n\n

[Required Data]
Hospital Data<\/p>\n\n\n\n

Inpatient EF Integrated File (mandatory)
Outpatient EF Integrated File
Other Data<\/p>\n\n\n\n

Medical Treatment Action Master
FY2022 Medical Fee Revision
FY2024 Medical Fee Revision
Note: These are included with the tool<\/p>\n<\/div>\n<\/div>\n\n\n\n

Note 1: About “Chokotsuna” <\/h4>\n\n\n\n

“Chokotsuna,” which was launched by our company in December 2023, is a community website with 326 hospital staff members (as of December 2024), primarily administrative personnel. On this platform, hospital staff can easily post questions and concerns they encounter in their work, and other members of the “Chokotsuna” community provide answers and support, fostering active online interaction. Membership registration (free) is required to access the site.<\/p>\n\n\n\n

URL: https:\/\/www.mdv.co.jp\/solution\/medical\/hospital\/emudebu-community\/<\/a><\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Medical Data Vision Co., Ltd. (Chiyoda-ku, Tokyo, President: Hiroyuki Iwasaki), a company that develops and pr […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[],"class_list":["post-747","post","type-post","status-publish","format-standard","hentry","category-news"],"acf":[],"yoast_head":"\nIntroducing an automated tool to display surgery counts and help hospital staff with seasonal challenges - News | Medical Data Vision Co., Ltd.<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/en.mdv.co.jp\/news\/2025\/article-747.html\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introducing an automated tool to display surgery counts and help hospital staff with seasonal challenges - News | Medical Data Vision Co., Ltd.\" \/>\n<meta property=\"og:description\" content=\"Medical Data Vision Co., Ltd. (Chiyoda-ku, Tokyo, President: Hiroyuki Iwasaki), a company that develops and pr […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/en.mdv.co.jp\/news\/2025\/article-747.html\" \/>\n<meta property=\"og:site_name\" content=\"News | Medical Data Vision Co., Ltd.\" \/>\n<meta property=\"article:published_time\" content=\"2025-01-30T06:22:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T06:40:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/en.mdv.co.jp\/news\/wp-content\/uploads\/2025\/01\/news-20250130-ogp_02.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"enmdvnews\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"enmdvnews\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"7\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/en.mdv.co.jp\/news\/2025\/article-747.html\",\"url\":\"https:\/\/en.mdv.co.jp\/news\/2025\/article-747.html\",\"name\":\"Introducing an automated tool to display surgery counts and help hospital staff with seasonal challenges - News | Medical Data Vision Co., Ltd.\",\"isPartOf\":{\"@id\":\"https:\/\/en.mdv.co.jp\/news\/#website\"},\"datePublished\":\"2025-01-30T06:22:26+00:00\",\"dateModified\":\"2025-08-05T06:40:53+00:00\",\"author\":{\"@id\":\"https:\/\/en.mdv.co.jp\/news\/#\/schema\/person\/1655e80e9946881eae9cb9fdd27a537f\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/en.mdv.co.jp\/news\/2025\/article-747.html\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/en.mdv.co.jp\/news\/#website\",\"url\":\"https:\/\/en.mdv.co.jp\/news\/\",\"name\":\"News | Medical Data Vision Co., Ltd.\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/en.mdv.co.jp\/news\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"ja\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/en.mdv.co.jp\/news\/#\/schema\/person\/1655e80e9946881eae9cb9fdd27a537f\",\"name\":\"enmdvnews\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/en.mdv.co.jp\/news\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4681cfdff3cda66fec1fd62cd3a4d86?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a4681cfdff3cda66fec1fd62cd3a4d86?s=96&d=mm&r=g\",\"caption\":\"enmdvnews\"},\"sameAs\":[\"https:\/\/en.mdv.co.jp\/news\"],\"url\":\"https:\/\/en.mdv.co.jp\/news\/author\/enmdvnews\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Introducing an automated tool to display surgery counts and help hospital staff with seasonal challenges - News | Medical Data Vision Co., Ltd.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/en.mdv.co.jp\/news\/2025\/article-747.html","og_locale":"ja_JP","og_type":"article","og_title":"Introducing an automated tool to display surgery counts and help hospital staff with seasonal challenges - News | Medical Data Vision Co., Ltd.","og_description":"Medical Data Vision Co., Ltd. (Chiyoda-ku, Tokyo, President: Hiroyuki Iwasaki), a company that develops and pr […]","og_url":"https:\/\/en.mdv.co.jp\/news\/2025\/article-747.html","og_site_name":"News | Medical Data Vision Co., Ltd.","article_published_time":"2025-01-30T06:22:26+00:00","article_modified_time":"2025-08-05T06:40:53+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/en.mdv.co.jp\/news\/wp-content\/uploads\/2025\/01\/news-20250130-ogp_02.jpg","type":"image\/jpeg"}],"author":"enmdvnews","twitter_card":"summary_large_image","twitter_misc":{"\u57f7\u7b46\u8005":"enmdvnews","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"7\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/en.mdv.co.jp\/news\/2025\/article-747.html","url":"https:\/\/en.mdv.co.jp\/news\/2025\/article-747.html","name":"Introducing an automated tool to display surgery counts and help hospital staff with seasonal challenges - News | Medical Data Vision Co., Ltd.","isPartOf":{"@id":"https:\/\/en.mdv.co.jp\/news\/#website"},"datePublished":"2025-01-30T06:22:26+00:00","dateModified":"2025-08-05T06:40:53+00:00","author":{"@id":"https:\/\/en.mdv.co.jp\/news\/#\/schema\/person\/1655e80e9946881eae9cb9fdd27a537f"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/en.mdv.co.jp\/news\/2025\/article-747.html"]}]},{"@type":"WebSite","@id":"https:\/\/en.mdv.co.jp\/news\/#website","url":"https:\/\/en.mdv.co.jp\/news\/","name":"News | Medical Data Vision Co., Ltd.","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/en.mdv.co.jp\/news\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"ja"},{"@type":"Person","@id":"https:\/\/en.mdv.co.jp\/news\/#\/schema\/person\/1655e80e9946881eae9cb9fdd27a537f","name":"enmdvnews","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/en.mdv.co.jp\/news\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a4681cfdff3cda66fec1fd62cd3a4d86?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a4681cfdff3cda66fec1fd62cd3a4d86?s=96&d=mm&r=g","caption":"enmdvnews"},"sameAs":["https:\/\/en.mdv.co.jp\/news"],"url":"https:\/\/en.mdv.co.jp\/news\/author\/enmdvnews"}]}},"_links":{"self":[{"href":"https:\/\/en.mdv.co.jp\/news\/wp-json\/wp\/v2\/posts\/747","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/en.mdv.co.jp\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/en.mdv.co.jp\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/en.mdv.co.jp\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/en.mdv.co.jp\/news\/wp-json\/wp\/v2\/comments?post=747"}],"version-history":[{"count":4,"href":"https:\/\/en.mdv.co.jp\/news\/wp-json\/wp\/v2\/posts\/747\/revisions"}],"predecessor-version":[{"id":752,"href":"https:\/\/en.mdv.co.jp\/news\/wp-json\/wp\/v2\/posts\/747\/revisions\/752"}],"wp:attachment":[{"href":"https:\/\/en.mdv.co.jp\/news\/wp-json\/wp\/v2\/media?parent=747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/en.mdv.co.jp\/news\/wp-json\/wp\/v2\/categories?post=747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/en.mdv.co.jp\/news\/wp-json\/wp\/v2\/tags?post=747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}