{"id":12985,"date":"2019-12-28T10:37:26","date_gmt":"2019-12-28T09:37:26","guid":{"rendered":"https:\/\/eudamed.eu\/?p=12985"},"modified":"2021-12-08T08:22:29","modified_gmt":"2021-12-08T07:22:29","slug":"mdr-eudamed-how-to-prepare-your-spreadsheet-templates","status":"publish","type":"post","link":"https:\/\/eudamed.com\/index.php\/2019\/12\/28\/mdr-eudamed-how-to-prepare-your-spreadsheet-templates\/","title":{"rendered":"MDR EUDAMED, how to prepare your spreadsheet templates."},"content":{"rendered":"\r\n<h1>MDR EUDAMED, how to prepare your spreadsheet templates.<\/h1>\r\n<p class=\"wp-block-paragraph\">The European Commission (EC) delayed the release of MDR EUDAMED until May 26<sup>th<\/sup> 2022, MDR now applies and IVDR will apply from May 26<sup>th<\/sup> 2023. This means that you now have to collate, maintain and keep up to date all of your UDI Device data. You have to find some way of collating your UDI data in preparation for EUDAMED and the XML data required for UDI data uploads.\u00a0<\/p>\r\n\r\n\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">The most common question we get asked at our EUDAMED <a href=\"https:\/\/eudamed.com\/index.php\/mdr-eudamed-training-schedule\/\" target=\"_blank\" rel=\"noopener noreferrer\">training<\/a> courses is how do we prepare a spreadsheet to collate the EUDAMED required data? Do you have any examples? Can you help us?<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">It is possible for your in-house team to put together a correctly formatted spreadsheet. This will keep your data in-house where you retain control of your data.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">There is some complexity involved with the proposed spreadsheet. First, there are a lot of fields within MDR Eudamed, a lot of mandatory fields, and some fields that can accept multiple entries, particularly language specific fields. If you do not wish to invest a lot of time in preparing the spreadsheets with the correct EUDAMED fields then you can <strong><a href=\"https:\/\/eudamed.eu\/index.php\/shop\/\" target=\"_blank\" rel=\"noopener\">purchase<\/a><\/strong> ours, they are split into two packages, <a href=\"https:\/\/eudamed.eu\/index.php\/product\/mdr-eudamed-data-templates\/\" target=\"_blank\" rel=\"noopener\">MDR<\/a> and <a href=\"https:\/\/eudamed.eu\/index.php\/product\/ivdr-template-package\/\" target=\"_blank\" rel=\"noopener\">IVDR<\/a>.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Tips for spreadsheet preparation<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li><strong>Avoid duplication<\/strong> of data.\r\n<ul>\r\n<li>Some elements allow you to add multiple entries e.g. Critical warnings, storage and handling etc. And place where multiple entries are possible, create a specific tab for this data.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n\r\n<ul>\r\n<li>Any element that allows for multiple languages is <strong>data<\/strong> that should be <strong>in its own tab<\/strong>.\r\n<ul>\r\n<li>For example, if you have one UDI DI on a single row, and needed to enter an \u2018additional description\u2019 in 10 languages, then you would need to duplicate the UDI DI row 10 times, thus making the overall management and maintainability virtually impossible.<\/li>\r\n<li>The main reason for separating the data elements into tabs is that it won\u2019t be necessary to repeat all the UDI DI data for each multi-language entry.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Use <strong>drop-down lists<\/strong> in your spreadsheet for each enum or value list <strong>to reduce errors<\/strong> during data entry.\r\n<ul>\r\n<li>Enum examples include issuing entities, storage and handling, critical warnings, languages, countries and many more.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li><strong>Highlight<\/strong> the <strong>mandatory fields<\/strong> to make data entry easier for the end-user.<\/li>\r\n<li>Where to find the information? Locating the information will require research the following are the three main sources of information for you:\r\n<ul>\r\n<li>Firstly, the data dictionary V8 was recently published (October 2021) and has an abundance of information, from occurrences (multiple entries) and data types to what enumerations are used.<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>To find the enumerations is a bit of work because the EC have yet to publish the full lists. For now, you need the XSD\u2019s. Inside the XSD\u2019s the enumerations are detailed. Locate the required entity name in the data dictionary and use this to search the XSD which will bring you to the enum or value list. These are the options you must include in your XML when you upload to EUDAMED.<\/li>\r\n<\/ul>\r\n<ul>\r\n<li>The UML diagrams are a great source of information including mandatory and multiple entry fields.\u00a0<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">The preparation of the spreadsheet takes a lot of time. For the Eudamed.com available spreadsheets, we estimated that we spent well in excess of <strong>175+ hours creating<\/strong> ours, and that is before we started on the business rules.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">To <strong>save you a lot of time<\/strong> and research, our spreadsheets are <strong>available for you to <a href=\"https:\/\/eudamed.eu\/index.php\/shop\/\" target=\"_blank\" rel=\"noopener\">purchase<\/a><\/strong>. They are split into two packages, <a href=\"https:\/\/eudamed.eu\/index.php\/product\/mdr-eudamed-data-templates\/\" target=\"_blank\" rel=\"noopener\">MDR<\/a> and <a href=\"https:\/\/eudamed.eu\/index.php\/product\/ivdr-template-package\/\" target=\"_blank\" rel=\"noopener\">IVDR<\/a>. Each spreadsheet has some legislation specific MDR EUDAMED rules built-in. The inclusion of the business rules is to help with the overall MDR EUDAMED data preparation and the long-term maintainability of the data.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Regardless of creating your own or purchasing our spreadsheets, you must start keeping collated device records, which will greatly reduce the level of work needed when MDR Eudamed goes live. If you need further assistance, training, or would like to <a href=\"https:\/\/eudamed.eu\/index.php\/shop\/\" target=\"_blank\" rel=\"noopener\">purchase<\/a> our spreadsheet templates please go to our website for further information, https:\/\/eudamed.com<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>MDR EUDAMED, how to prepare your spreadsheet templates. The European Commission (EC) delayed the release of MDR EUDAMED until May 26th 2022, MDR now applies and IVDR will apply from&#8230;<\/p>\n","protected":false},"author":2,"featured_media":11750,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","_exactmetrics_skip_tracking":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[6],"tags":[],"class_list":["post-12985","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mdreudamed"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/eudamed.com\/wp-content\/uploads\/2018\/05\/header-image-1.jpg","_links":{"self":[{"href":"https:\/\/eudamed.com\/index.php\/wp-json\/wp\/v2\/posts\/12985","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eudamed.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eudamed.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eudamed.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/eudamed.com\/index.php\/wp-json\/wp\/v2\/comments?post=12985"}],"version-history":[{"count":13,"href":"https:\/\/eudamed.com\/index.php\/wp-json\/wp\/v2\/posts\/12985\/revisions"}],"predecessor-version":[{"id":16527,"href":"https:\/\/eudamed.com\/index.php\/wp-json\/wp\/v2\/posts\/12985\/revisions\/16527"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eudamed.com\/index.php\/wp-json\/wp\/v2\/media\/11750"}],"wp:attachment":[{"href":"https:\/\/eudamed.com\/index.php\/wp-json\/wp\/v2\/media?parent=12985"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eudamed.com\/index.php\/wp-json\/wp\/v2\/categories?post=12985"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eudamed.com\/index.php\/wp-json\/wp\/v2\/tags?post=12985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}