{"id":7256,"date":"2018-12-04T09:39:06","date_gmt":"2018-12-04T17:39:06","guid":{"rendered":"https:\/\/blog-prod.qad.com\/blog\/?p=7256"},"modified":"2018-12-04T14:51:32","modified_gmt":"2018-12-04T22:51:32","slug":"avoiding-death-by-spreadsheet-life-sciences","status":"publish","type":"post","link":"https:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences","title":{"rendered":"Avoiding Death by Spreadsheet in the Life Sciences Industry"},"content":{"rendered":"<p>[vc_row][vc_column][vc_single_image image=&#8221;7259&#8243; img_size=&#8221;full&#8221;][vc_column_text]<span style=\"font-weight: 400;\">Contract management is a complicated business for medical device and pharmaceutical companies. Frequently, manufacturers rely on spreadsheets to help with the management process. This is often handled outside of the normal sales, accounts receivable (AR) and accounts payable (AP) processing functionality of their ERP system due to the indirect nature of their sales. While some manufacturers do sell directly to their customers, many rely on a complex sales process that has evolved over the years as a result of new legislation and cost-cutting initiatives. Furthermore, there are strict auditing and state Medicare reporting requirements to consider.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Pricing Lifecycles Have Changed<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Many manufacturers in these industries no longer negotiate prices directly with individual customers or hospitals. They often sell through distributors to members of one or more buying groups referred to as Group Purchasing Organizations (GPOs) or Pharmacy Benefits Managers (PBMs). Rather than a traditional business model where a distributor buys at a wholesale price and then sells to the customer at a higher price, life sciences companies participate in a complex lifecycle which includes negotiating prices with GPOs\/PBMs, selling to distributors at a high price, paying chargebacks or rebates after the sale, and paying service fees and administrative fees.<\/span>[\/vc_column_text][vc_single_image image=&#8221;7261&#8243; img_size=&#8221;full&#8221;][vc_column_text]<span style=\"font-weight: 400;\">Adding to the complexity, customers may belong to multiple groups at the same time or change groups. This happens frequently, often making the maintenance of buying group contract and membership details <\/span><span style=\"font-weight: 400;\">\u2013 <\/span><span style=\"font-weight: 400;\">and keeping up with changes <\/span><span style=\"font-weight: 400;\">\u2013<\/span><span style=\"font-weight: 400;\"> a time-consuming manual process. Accurate group membership is important to ensure the customer is getting the correct contract price. Group membership changes are often communicated by email or via a website or portal. Manufacturers may use spreadsheets to maintain this data, which can be prone to error, or they may simply rely on the distributor\u2019s records supplied through sales trace or chargeback files. Some <\/span><a href=\"https:\/\/www.genpact.com\/downloadable-content\/insight\/revenue-leakage-in-life-scienceswhos-plugging-the-holes-and-how-can-they-help.pdf\"><span style=\"font-weight: 400;\">statistics<\/span><\/a><span style=\"font-weight: 400;\"> estimate that 4-6% of revenue is lost due to incorrect management of groups and chargebacks in life sciences companies.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">The Chargeback Process<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">The chargeback process entails claim requests submitted from the distributor to the manufacturer with details of the indirect sales at the individual invoice line level. Due to the high volume of sales-related data necessary to prove out the claim process, these sales trace files are often electronic. Manufacturers need to generate claims in order to pay the chargeback or approve deductions taken from distributor payments with the assumed claim amount. Additionally, a service fee is usually paid to the distributor as a percentage of the sales. GPOs receive administrative fees from the manufacturer after a GPO member makes use of a GPO contract. Again, spreadsheets are often the go-to record-keeping tool for keeping track of this data.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">During the course of a month, the manufacturer\u2019s controller or CFO may want to know what their current outstanding liability is for these chargebacks and claims. This can result in many hours of work for the resident pivot-table guru in the company each time a request is made. Similarly, at the end of the month, an accrual must be made for these open claims that have not yet been paid. Without an integrated solution, this all happens outside of the other daily financial processes.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Avoiding Death by Spreadsheet<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Wouldn\u2019t it be great if there was a way to utilize your ERP system to manage all of this complexity and avoid death by spreadsheet? <\/span><a href=\"https:\/\/www.qad.com\/solutions\/customer-management-erp\/data-sheet\/qad-trade-management-data-sheet\"><span style=\"font-weight: 400;\">QAD Trade Activity Management (TAM)<\/span><\/a><span style=\"font-weight: 400;\"> has seamless integration with the operational and financial modules of QAD Cloud ERP and Enterprise Applications and helps manage all of this complexity. It allows for the definition of contract agreements as well as all the processing that goes along with them, including claims, deductions, indirect sales, accruals, and related General Ledger journal entries. QAD TAM supports Excel uploads for GPO members and indirect sales trace files (chargebacks). Claims and administrative fees can be automatically generated and approved or manually created. \u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">QAD TAM includes detailed transaction history and reporting. Documentation to support fraudulent charge refusal and financial regulatory compliance are integral parts of the solution. Additionally, there is robust functionality to support promotional trade spend on direct sales. The major solution components are listed below.<\/span>[\/vc_column_text][vc_single_image image=&#8221;7265&#8243; img_size=&#8221;full&#8221;][vc_column_text]<i><span style=\"font-weight: 400;\">What types of contract management challenges are you experiencing? Do you have an interesting use-case to share? Let us know your thoughts in the comments below and learn more on how QAD supports <\/span><\/i><a href=\"https:\/\/www.qad.com\/industries\/life-sciences\"><i><span style=\"font-weight: 400;\">Life Sciences<\/span><\/i><\/a><i><span style=\"font-weight: 400;\"> manufacturers.<\/span><\/i>[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[vc_row][vc_column][vc_single_image image=&#8221;7259&#8243; img_size=&#8221;full&#8221;][vc_column_text]Contract management is a complicated business for medical device and pharmaceutical companies. Frequently, manufacturers rely on spreadsheets to help with the management process. This is often handled outside of the normal sales, accounts receivable (AR) and accounts payable (AP) processing functionality of their ERP system due to the indirect nature of their sales. [&hellip;]<\/p>\n","protected":false},"author":73,"featured_media":7259,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[182,199],"tags":[618,616,511,617,30,619,209,170],"class_list":["post-7256","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-featured","category-manufacturing-trends","tag-chargeback-process","tag-contract-management","tag-life-sciences-erp","tag-pricing-lifecycle","tag-qad-cloud-erp","tag-qad-tam","tag-spreadsheets","tag-trade-activity-management"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Avoiding Death by Spreadsheet in the Life Sciences Industry | QAD Blog<\/title>\n<meta name=\"description\" content=\"Contract management is a complicated business for medical device and pharmaceutical companies. Frequently, manufacturers rely on spreadsheets to help with\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Avoiding Death by Spreadsheet in the Life Sciences Industry | QAD Blog\" \/>\n<meta property=\"og:description\" content=\"Contract management is a complicated business for medical device and pharmaceutical companies. Frequently, manufacturers rely on spreadsheets to help with\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences\" \/>\n<meta property=\"og:site_name\" content=\"QAD Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/QADerp\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-04T17:39:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-04T22:51:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.qad.com\/blog\/wp-content\/uploads\/2018\/12\/12.04.2018-min.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"901\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Kelly Andrews\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@QAD_Community\" \/>\n<meta name=\"twitter:site\" content=\"@QAD_Community\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kelly Andrews\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/2018\\\/12\\\/avoiding-death-by-spreadsheet-life-sciences#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/2018\\\/12\\\/avoiding-death-by-spreadsheet-life-sciences\"},\"author\":{\"name\":\"Kelly Andrews\",\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/#\\\/schema\\\/person\\\/b2f0f61d21e6dccd6397db0f03bffbe3\"},\"headline\":\"Avoiding Death by Spreadsheet in the Life Sciences Industry\",\"datePublished\":\"2018-12-04T17:39:06+00:00\",\"dateModified\":\"2018-12-04T22:51:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/2018\\\/12\\\/avoiding-death-by-spreadsheet-life-sciences\"},\"wordCount\":778,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/2018\\\/12\\\/avoiding-death-by-spreadsheet-life-sciences#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/12.04.2018-min.jpg\",\"keywords\":[\"Chargeback process\",\"Contract management\",\"Life Sciences ERP\",\"Pricing lifecycle\",\"qad cloud erp\",\"QAD TAM\",\"spreadsheets\",\"trade activity management\"],\"articleSection\":[\"Featured\",\"Manufacturing Trends\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.qad.com\\\/blog\\\/2018\\\/12\\\/avoiding-death-by-spreadsheet-life-sciences#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/2018\\\/12\\\/avoiding-death-by-spreadsheet-life-sciences\",\"url\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/2018\\\/12\\\/avoiding-death-by-spreadsheet-life-sciences\",\"name\":\"Avoiding Death by Spreadsheet in the Life Sciences Industry | QAD Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/2018\\\/12\\\/avoiding-death-by-spreadsheet-life-sciences#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/2018\\\/12\\\/avoiding-death-by-spreadsheet-life-sciences#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/12.04.2018-min.jpg\",\"datePublished\":\"2018-12-04T17:39:06+00:00\",\"dateModified\":\"2018-12-04T22:51:32+00:00\",\"description\":\"Contract management is a complicated business for medical device and pharmaceutical companies. Frequently, manufacturers rely on spreadsheets to help with\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/2018\\\/12\\\/avoiding-death-by-spreadsheet-life-sciences#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.qad.com\\\/blog\\\/2018\\\/12\\\/avoiding-death-by-spreadsheet-life-sciences\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/2018\\\/12\\\/avoiding-death-by-spreadsheet-life-sciences#primaryimage\",\"url\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/12.04.2018-min.jpg\",\"contentUrl\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/12.04.2018-min.jpg\",\"width\":901,\"height\":450,\"caption\":\"spreadsheets, life sciences, qad tam\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/2018\\\/12\\\/avoiding-death-by-spreadsheet-life-sciences#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Avoiding Death by Spreadsheet in the Life Sciences Industry\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/\",\"name\":\"QAD Blog\",\"description\":\"Next-Generation Manufacturing &amp; Supply Chain Solutions in the Cloud\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/#organization\",\"name\":\"QAD\",\"url\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"QAD\"},\"image\":{\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/QADerp\",\"https:\\\/\\\/x.com\\\/QAD_Community\",\"https:\\\/\\\/instagram.com\\\/qad_erp\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/qad\",\"https:\\\/\\\/www.pinterest.com\\\/QADInc\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/QADIncorporated\\\/\",\"https:\\\/\\\/en.wikipedia.org\\\/wiki\\\/QAD_Inc.\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/#\\\/schema\\\/person\\\/b2f0f61d21e6dccd6397db0f03bffbe3\",\"name\":\"Kelly Andrews\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/Kelly-Andrews_avatar-96x96.jpg\",\"url\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/Kelly-Andrews_avatar-96x96.jpg\",\"contentUrl\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/Kelly-Andrews_avatar-96x96.jpg\",\"caption\":\"Kelly Andrews\"},\"description\":\"Kelly Andrews is a product manager for Customer Management solutions at QAD, including Trade Activity Management, and has been at QAD for 20 years. She loves trying out all of the latest mobile apps to help keep her organized and entertained. An avid gardener and photographer, she spends as much time as possible outdoors. She loves living at the Jersey Shore and enjoys long walks shelling on the beach.\",\"url\":\"https:\\\/\\\/www.qad.com\\\/blog\\\/author\\\/kxa\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Avoiding Death by Spreadsheet in the Life Sciences Industry | QAD Blog","description":"Contract management is a complicated business for medical device and pharmaceutical companies. Frequently, manufacturers rely on spreadsheets to help with","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:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences","og_locale":"en_US","og_type":"article","og_title":"Avoiding Death by Spreadsheet in the Life Sciences Industry | QAD Blog","og_description":"Contract management is a complicated business for medical device and pharmaceutical companies. Frequently, manufacturers rely on spreadsheets to help with","og_url":"https:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences","og_site_name":"QAD Blog","article_publisher":"https:\/\/www.facebook.com\/QADerp","article_published_time":"2018-12-04T17:39:06+00:00","article_modified_time":"2018-12-04T22:51:32+00:00","og_image":[{"width":901,"height":450,"url":"https:\/\/www.qad.com\/blog\/wp-content\/uploads\/2018\/12\/12.04.2018-min.jpg","type":"image\/jpeg"}],"author":"Kelly Andrews","twitter_card":"summary_large_image","twitter_creator":"@QAD_Community","twitter_site":"@QAD_Community","twitter_misc":{"Written by":"Kelly Andrews","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences#article","isPartOf":{"@id":"https:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences"},"author":{"name":"Kelly Andrews","@id":"https:\/\/www.qad.com\/blog\/#\/schema\/person\/b2f0f61d21e6dccd6397db0f03bffbe3"},"headline":"Avoiding Death by Spreadsheet in the Life Sciences Industry","datePublished":"2018-12-04T17:39:06+00:00","dateModified":"2018-12-04T22:51:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences"},"wordCount":778,"commentCount":0,"publisher":{"@id":"https:\/\/www.qad.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences#primaryimage"},"thumbnailUrl":"https:\/\/www.qad.com\/blog\/wp-content\/uploads\/2018\/12\/12.04.2018-min.jpg","keywords":["Chargeback process","Contract management","Life Sciences ERP","Pricing lifecycle","qad cloud erp","QAD TAM","spreadsheets","trade activity management"],"articleSection":["Featured","Manufacturing Trends"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences","url":"https:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences","name":"Avoiding Death by Spreadsheet in the Life Sciences Industry | QAD Blog","isPartOf":{"@id":"https:\/\/www.qad.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences#primaryimage"},"image":{"@id":"https:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences#primaryimage"},"thumbnailUrl":"https:\/\/www.qad.com\/blog\/wp-content\/uploads\/2018\/12\/12.04.2018-min.jpg","datePublished":"2018-12-04T17:39:06+00:00","dateModified":"2018-12-04T22:51:32+00:00","description":"Contract management is a complicated business for medical device and pharmaceutical companies. Frequently, manufacturers rely on spreadsheets to help with","breadcrumb":{"@id":"https:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences#primaryimage","url":"https:\/\/www.qad.com\/blog\/wp-content\/uploads\/2018\/12\/12.04.2018-min.jpg","contentUrl":"https:\/\/www.qad.com\/blog\/wp-content\/uploads\/2018\/12\/12.04.2018-min.jpg","width":901,"height":450,"caption":"spreadsheets, life sciences, qad tam"},{"@type":"BreadcrumbList","@id":"https:\/\/www.qad.com\/blog\/2018\/12\/avoiding-death-by-spreadsheet-life-sciences#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.qad.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Avoiding Death by Spreadsheet in the Life Sciences Industry"}]},{"@type":"WebSite","@id":"https:\/\/www.qad.com\/blog\/#website","url":"https:\/\/www.qad.com\/blog\/","name":"QAD Blog","description":"Next-Generation Manufacturing &amp; Supply Chain Solutions in the Cloud","publisher":{"@id":"https:\/\/www.qad.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.qad.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.qad.com\/blog\/#organization","name":"QAD","url":"https:\/\/www.qad.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.qad.com\/blog\/#\/schema\/logo\/image\/","url":"","contentUrl":"","caption":"QAD"},"image":{"@id":"https:\/\/www.qad.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/QADerp","https:\/\/x.com\/QAD_Community","https:\/\/instagram.com\/qad_erp\/","https:\/\/www.linkedin.com\/company\/qad","https:\/\/www.pinterest.com\/QADInc\/","https:\/\/www.youtube.com\/user\/QADIncorporated\/","https:\/\/en.wikipedia.org\/wiki\/QAD_Inc."]},{"@type":"Person","@id":"https:\/\/www.qad.com\/blog\/#\/schema\/person\/b2f0f61d21e6dccd6397db0f03bffbe3","name":"Kelly Andrews","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.qad.com\/blog\/wp-content\/uploads\/2018\/11\/Kelly-Andrews_avatar-96x96.jpg","url":"https:\/\/www.qad.com\/blog\/wp-content\/uploads\/2018\/11\/Kelly-Andrews_avatar-96x96.jpg","contentUrl":"https:\/\/www.qad.com\/blog\/wp-content\/uploads\/2018\/11\/Kelly-Andrews_avatar-96x96.jpg","caption":"Kelly Andrews"},"description":"Kelly Andrews is a product manager for Customer Management solutions at QAD, including Trade Activity Management, and has been at QAD for 20 years. She loves trying out all of the latest mobile apps to help keep her organized and entertained. An avid gardener and photographer, she spends as much time as possible outdoors. She loves living at the Jersey Shore and enjoys long walks shelling on the beach.","url":"https:\/\/www.qad.com\/blog\/author\/kxa"}]}},"_links":{"self":[{"href":"https:\/\/www.qad.com\/blog\/wp-json\/wp\/v2\/posts\/7256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.qad.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.qad.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.qad.com\/blog\/wp-json\/wp\/v2\/users\/73"}],"replies":[{"embeddable":true,"href":"https:\/\/www.qad.com\/blog\/wp-json\/wp\/v2\/comments?post=7256"}],"version-history":[{"count":3,"href":"https:\/\/www.qad.com\/blog\/wp-json\/wp\/v2\/posts\/7256\/revisions"}],"predecessor-version":[{"id":7266,"href":"https:\/\/www.qad.com\/blog\/wp-json\/wp\/v2\/posts\/7256\/revisions\/7266"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.qad.com\/blog\/wp-json\/wp\/v2\/media\/7259"}],"wp:attachment":[{"href":"https:\/\/www.qad.com\/blog\/wp-json\/wp\/v2\/media?parent=7256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qad.com\/blog\/wp-json\/wp\/v2\/categories?post=7256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qad.com\/blog\/wp-json\/wp\/v2\/tags?post=7256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}