{"id":327,"date":"2016-01-13T16:53:54","date_gmt":"2016-01-14T00:53:54","guid":{"rendered":"http:\/\/faculty.business.wsu.edu\/munson\/?page_id=327"},"modified":"2017-01-10T10:09:15","modified_gmt":"2017-01-10T18:09:15","slug":"lecture-notes","status":"publish","type":"page","link":"https:\/\/faculty.business.wsu.edu\/munson\/mgtop-556-advanced-business-modeling\/lecture-notes\/","title":{"rendered":"Lecture Notes"},"content":{"rendered":"<br \/>\n<section id=\"builder-section-1452732643045\" class=\"row single gutter pad-top\">\n<div style=\"\" class=\"column one \">\n<header>\n<h2>MgtOp 556 Lecture Notes<\/h2>\n<\/header>\n<p>Topic 1\u2014VBA Programming in Excel for Decision Support Systems<\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/wsuwp-uploads.s3.amazonaws.com\/uploads\/sites\/936\/2017\/01\/MgtOp-556-Topic-1-Set-1.docx\">Set 1\u2014VBA Basics, Input\/Message Boxes, Interacting with the Spreadsheet, VBA Constants, Using Excel Functions in VBA, String Functions, and User-Defined Functions<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/wsuwp-uploads.s3.amazonaws.com\/uploads\/sites\/936\/2017\/01\/MgtOp-556-Topic-1-Set-2.docx\">Set 2\u2014Referencing Worksheets, &#8220;With&#8221; Construction, and Working with Ranges<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/wsuwp-uploads.s3.amazonaws.com\/uploads\/sites\/936\/2017\/01\/MgtOp-556-Topic-1-Set-3.docx\">Set 3\u2014Control Logic and Loops<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/wsuwp-uploads.s3.amazonaws.com\/uploads\/sites\/936\/2017\/01\/MgtOp-556-Topic-1-Set-4.docx\">Set 4\u2014Workbooks &amp; Worksheets, Arrays, Calling Subs &amp; Passing Arguments, Global vs. Local Variables<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/wsuwp-uploads.s3.amazonaws.com\/uploads\/sites\/936\/2017\/01\/MgtOp-556-Topic-1-Set-5.docx\">Set 5\u2014User Forms: Becoming a True &#8220;Windows Programmer&#8221;<\/a><\/p>\n<p>Topic 2\u2014The Craft of Modeling<\/p>\n<p style=\"padding-left: 30px\">Set 1\u2014Modeling and Heuristics<\/p>\n<p style=\"padding-left: 30px\">Set 2\u2014Excel Tools for Model Analysis<\/p>\n<p>Topic 3\u2014Monte Carlo Simulation<\/p>\n<p>Topic 4\u2014Waiting Lines and Queuing Theory<\/p>\n<p>Topic 5<span style=\"color: #0066cc\">\u2014<\/span>Mathematical Programming<\/p>\n<p>&nbsp;<\/p>\n<\/p><\/div>\n<\/section>\n","protected":false},"excerpt":{"rendered":"<p> <\/p>\n<h2>MgtOp 556 Lecture Notes<\/h2>\n<p>Topic 1\u2014VBA Programming in Excel for Decision Support Systems<\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/wsuwp-uploads.s3.amazonaws.com\/uploads\/sites\/936\/2017\/01\/MgtOp-556-Topic-1-Set-1.docx\">Set 1\u2014VBA Basics, Input\/Message Boxes, Interacting with the Spreadsheet, VBA Constants, Using Excel Functions in VBA, String Functions, and User-Defined Functions<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/wsuwp-uploads.s3.amazonaws.com\/uploads\/sites\/936\/2017\/01\/MgtOp-556-Topic-1-Set-2.docx\">Set 2\u2014Referencing Worksheets, &#8220;With&#8221; Construction, and Working with Ranges<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/wsuwp-uploads.s3.amazonaws.com\/uploads\/sites\/936\/2017\/01\/MgtOp-556-Topic-1-Set-3.docx\">Set 3\u2014Control Logic and Loops<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/wsuwp-uploads.s3.amazonaws.com\/uploads\/sites\/936\/2017\/01\/MgtOp-556-Topic-1-Set-4.docx\">Set 4\u2014Workbooks &amp; Worksheets, Arrays, Calling Subs &amp; Passing Arguments, Global vs. Local Variables<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/wsuwp-uploads.s3.amazonaws.com\/uploads\/sites\/936\/2017\/01\/MgtOp-556-Topic-1-Set-5.docx\">Set 5\u2014User Forms: Becoming a True &#8220;Windows Programmer&#8221;<\/a><\/p>\n<p>Topic 2\u2014The Craft of Modeling<\/p>\n<p style=\"padding-left: 30px\">Set 1\u2014Modeling and Heuristics<\/p>\n<p style=\"padding-left: 30px\">Set 2\u2014Excel Tools for Model &#8230; <a href=\"https:\/\/faculty.business.wsu.edu\/munson\/mgtop-556-advanced-business-modeling\/lecture-notes\/\" class=\"more-link\"><span class=\"more-default\">&raquo; More &#8230;<\/span><\/a><\/p>\n","protected":false},"author":1456,"featured_media":0,"parent":316,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"template-builder.php","meta":{"_wsuwp_accessibility_report":[]},"wsuwp_university_location":[],"wsuwp_university_org":[],"_links":{"self":[{"href":"https:\/\/faculty.business.wsu.edu\/munson\/wp-json\/wp\/v2\/pages\/327"}],"collection":[{"href":"https:\/\/faculty.business.wsu.edu\/munson\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/faculty.business.wsu.edu\/munson\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/faculty.business.wsu.edu\/munson\/wp-json\/wp\/v2\/users\/1456"}],"replies":[{"embeddable":true,"href":"https:\/\/faculty.business.wsu.edu\/munson\/wp-json\/wp\/v2\/comments?post=327"}],"version-history":[{"count":25,"href":"https:\/\/faculty.business.wsu.edu\/munson\/wp-json\/wp\/v2\/pages\/327\/revisions"}],"predecessor-version":[{"id":757,"href":"https:\/\/faculty.business.wsu.edu\/munson\/wp-json\/wp\/v2\/pages\/327\/revisions\/757"}],"up":[{"embeddable":true,"href":"https:\/\/faculty.business.wsu.edu\/munson\/wp-json\/wp\/v2\/pages\/316"}],"wp:attachment":[{"href":"https:\/\/faculty.business.wsu.edu\/munson\/wp-json\/wp\/v2\/media?parent=327"}],"wp:term":[{"taxonomy":"wsuwp_university_location","embeddable":true,"href":"https:\/\/faculty.business.wsu.edu\/munson\/wp-json\/wp\/v2\/wsuwp_university_location?post=327"},{"taxonomy":"wsuwp_university_org","embeddable":true,"href":"https:\/\/faculty.business.wsu.edu\/munson\/wp-json\/wp\/v2\/wsuwp_university_org?post=327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}