{"id":927,"date":"2014-12-09T12:44:06","date_gmt":"2014-12-09T19:44:06","guid":{"rendered":"https:\/\/blogs.ubc.ca\/coetoolbox\/?p=927"},"modified":"2015-04-24T09:46:08","modified_gmt":"2015-04-24T16:46:08","slug":"processing-data-in-a-blood-inventory-simulation-model","status":"publish","type":"post","link":"https:\/\/blogs.ubc.ca\/coetoolbox\/2014\/12\/09\/processing-data-in-a-blood-inventory-simulation-model\/","title":{"rendered":"Processing blood inventory simulation data with VBA"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignright\" src=\"https:\/\/exceltutorcanada.files.wordpress.com\/2012\/08\/logo_excel2.png\" alt=\"\" width=\"81\" height=\"81\" \/>In the project <a href=\"http:\/\/www.sauder.ubc.ca\/Faculty\/Research_Centres\/Centre_for_Operations_Excellence\/Industry_Projects\/~\/media\/F647E073A31D454184BAEB1DF18D7DCA.ashx\" target=\"_blank\">Improving Blood Inventory Management through Simulation<\/a> the goal was to develop an inventory management model to explore new policies for hospitals in BC. The model developed simulates how blood inventory is managed in BC hospitals and is implemented in an excel workbook that uses VBA code to run a number of trials simulating the daily operations in a network of hospitals.<\/p>\n<p>One of the challenges faced was how to generate and handle inventory data from multiple hospitals, days and simulation replications. The approach was to structure the tool as a <a title=\"Decision Support Systems\" href=\"https:\/\/blogs.ubc.ca\/coetoolbox\/vba\/appdesign\/dss\/\">decision support system<\/a>, with the simulation model running separately from the user interface. Blood supply and demand distributions inputs we read values from an Excel spreadsheet. Daily values were generated using the built in <a title=\"Procedures and Functions\" href=\"https:\/\/blogs.ubc.ca\/coetoolbox\/vba\/procedures\/\">Excel functions<\/a>, and for a triangular distribution we created our own function. <span style=\"color: #0000ff;\">Global variables<\/span> were used to store parameters used across multiple hospitals and <a title=\"Working with Arrays\" href=\"https:\/\/blogs.ubc.ca\/coetoolbox\/vba\/arrays\/\">dynamic arrays<\/a> were used to record the hospital inventory levels, consolidate replication outputs and calculate network metrics.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the project Improving Blood Inventory Management through Simulation the goal was to develop an inventory management model to explore new policies for hospitals in BC. The model developed simulates how blood inventory is managed in BC hospitals and is implemented in an excel workbook that uses VBA code to run a number of trials [&hellip;]<\/p>\n","protected":false},"author":22982,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[3205,929821],"class_list":["post-927","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-simulation","tag-vba"],"_links":{"self":[{"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/posts\/927","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/users\/22982"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/comments?post=927"}],"version-history":[{"count":14,"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/posts\/927\/revisions"}],"predecessor-version":[{"id":972,"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/posts\/927\/revisions\/972"}],"wp:attachment":[{"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/media?parent=927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/categories?post=927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/tags?post=927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}