Two Similar Data Sets Suggested Code Perform Following Commands Vba 1 Insert New Module Na Q26621675

PtName Last4 Mileage Diagnosis Procedure 2 Madelyn Carberry 3 Mallory Latz 4 Charles Brenman 5 Kelley Green 6 Alec Rhoney 7 Matthew Ma 8 Matthew Dilley 9 Clayton Brenman 10 Jackson Rouse 11 Nathan Rhoney 12 Nicholas Hill 13 Meghan Barnes 14 Hossam Ellis 15 Alec Thomas 16 Madeline Dilley 17 Chandler Sharma 18 Adam To 19 Katelyn Hanser 20 Joseph Ellis 21 Matthew Brown 22 Nathan Houser 23 Nicholas Trinkle 24 Maggie Drahuse 25 Casey Barnes 26 Charlene Murnick 27 Mikayla Patel 28 Joanne Arnold 29 Maggie Casabonne 8947 7662 5586 9639 8647 6575 7112 5479 1438 9740 6322 5505 4755 8214 24 Chronotropic incompetence atypical Aflutter RFA Sotalol load HIS bundle lead atypical Aflutter RFA atypical Aflutter RFA Lead extraction Amiodarone load Propafenone Flecainide load Amiodarone load 86 Chronotropic incompetence 107 AVNRT 26 AVNRT 23 CVA 118 Chronotropic incompetence 148 PVC 168 Afib 167 NICM 142 Bradycardia 174 Bradycardia 90 CVA 142 Atypical Afl 79 Chronotropic incompetence 120 AVNRT 160 Intraventricular conduction delay 118 CVA 46 Bradycardia 132 Chronotropic incompetence Amiodarone load atypical Aflutter RFA Amiodarone load CRT-D 3581 6687 4234 HIS bun Tikosyn load 1180 1328 7613 1200 1314 9289 3986 6137 1967 10 Chronotropic incompetence 180 CVA Leadless PPM Flecainide load atypical Aflutter RFA Amiodarone load 186 Bradycardia 60 Chronotropic incompetence 29 NICM 107 Chronotropic incompetence 110 CVA 59 AVNRTWith two similar data sets,what is some suggested code to perform the following commands inVBA:

1)   Insert a new module.Name it Part1. Insert a new procedure and name it “Length”. Namethe portion of the data set that includes patient name as“patient”, assuming the number of patients is not known.2)   Add code to select theworksheet “Proc Time”. Name the data set that includes procedureand their length of time as “ProcTime”, assuming the number ofprocedures is not known. 3)  Add code to sore the data in the “ProcTime” range into two arrays. 4)  Add code that first asks a user for apatient’s name – use “James Brenman” as default. Next, add code tofind patient and capture patient’s procedure. 5)   Add code to look up for the length ofpatient’s procedure from the arrays in Step 3. Next, display amessage, such as “ James Bremant’s procedure, IST RFA, will take 75minutes”. 6) Insert a new module. Name itPart2. Copy/Paste the procedure that you developed in Part1 andrename it as “StoreProcTimes”. Move the declaration of the arraysfor the procedure and the procedure times to Public declarationarea.   Simplify the procedure so that it only includesthe code for storing data into the two arrays [Steps 2 and Step 3of Part1]. 7)   Insert a newprocedure, named “DayLoad” that first names the range for the“Procedure Date” and then it calls procedure “StoreProcTimes” inStep 1.8)   Add code to findand accumulate the length of procedures scheduled for 9/1/2017,i.e., it computes the load for the given day. Display a message toannounce the load. [Hint: if x is a type DATE variable, then x =“9/1/2017”]  9)  Insert a new module. Name it Part3.Insert a new procedure and name it“DailyLoad”.  10)  Store the name of the days of the week inan array, using the Array Function, starting with Sunday, the firstday of the week. 11)   Add codethat that it names the range for the “Procedure Date” and callsprocedure “StoreProcTimes” to store procedure time data in anarray. 12) Add code so that itaccumulates total number of procedures for each day of the week aswell as the load for each day of the week in a two-dimension array.[Hint: utilize Excel Function WEEKDAY.] 13)  Add code that it asks for a day of theweek. It then displays a message such as “On average, the EP lab isutilized for 4.5 hours on Mondays”. 14)  Insert a new module. Name it Part4.Develop a function that returns TRUE if, for a given patient, boththe average of the INR reading is less than 1.5 and the standarddeviation of the INR readings is less than .5, otherwise it returnFALSE. [Hint test your function for a give case. Develop aprocedure that asks a user for a patient name. Then it calls thefunction is step 1. If the function return TRUE, display a messagesuch as “James Breman’s INR record is satisfactory for theprocedure”. If the function returns FALSE, display a message suchas “James Breman’s INR record is not satisfactory for theprocedure”.

PtName Last4 Mileage Diagnosis Procedure 2 Madelyn Carberry 3 Mallory Latz 4 Charles Brenman 5 Kelley Green 6 Alec Rhoney 7 Matthew Ma 8 Matthew Dilley 9 Clayton Brenman 10 Jackson Rouse 11 Nathan Rhoney 12 Nicholas Hill 13 Meghan Barnes 14 Hossam Ellis 15 Alec Thomas 16 Madeline Dilley 17 Chandler Sharma 18 Adam To 19 Katelyn Hanser 20 Joseph Ellis 21 Matthew Brown 22 Nathan Houser 23 Nicholas Trinkle 24 Maggie Drahuse 25 Casey Barnes 26 Charlene Murnick 27 Mikayla Patel 28 Joanne Arnold 29 Maggie Casabonne 8947 7662 5586 9639 8647 6575 7112 5479 1438 9740 6322 5505 4755 8214 24 Chronotropic incompetence atypical Aflutter RFA Sotalol load HIS bundle lead atypical Aflutter RFA atypical Aflutter RFA Lead extraction Amiodarone load Propafenone Flecainide load Amiodarone load 86 Chronotropic incompetence 107 AVNRT 26 AVNRT 23 CVA 118 Chronotropic incompetence 148 PVC 168 Afib 167 NICM 142 Bradycardia 174 Bradycardia 90 CVA 142 Atypical Afl 79 Chronotropic incompetence 120 AVNRT 160 Intraventricular conduction delay 118 CVA 46 Bradycardia 132 Chronotropic incompetence Amiodarone load atypical Aflutter RFA Amiodarone load CRT-D 3581 6687 4234 HIS bun Tikosyn load 1180 1328 7613 1200 1314 9289 3986 6137 1967 10 Chronotropic incompetence 180 CVA Leadless PPM Flecainide load atypical Aflutter RFA Amiodarone load 186 Bradycardia 60 Chronotropic incompetence 29 NICM 107 Chronotropic incompetence 110 CVA 59 AVNRT Show transcribed image text PtName Last4 Mileage Diagnosis Procedure 2 Madelyn Carberry 3 Mallory Latz 4 Charles Brenman 5 Kelley Green 6 Alec Rhoney 7 Matthew Ma 8 Matthew Dilley 9 Clayton Brenman 10 Jackson Rouse 11 Nathan Rhoney 12 Nicholas Hill 13 Meghan Barnes 14 Hossam Ellis 15 Alec Thomas 16 Madeline Dilley 17 Chandler Sharma 18 Adam To 19 Katelyn Hanser 20 Joseph Ellis 21 Matthew Brown 22 Nathan Houser 23 Nicholas Trinkle 24 Maggie Drahuse 25 Casey Barnes 26 Charlene Murnick 27 Mikayla Patel 28 Joanne Arnold 29 Maggie Casabonne 8947 7662 5586 9639 8647 6575 7112 5479 1438 9740 6322 5505 4755 8214 24 Chronotropic incompetence atypical Aflutter RFA Sotalol load HIS bundle lead atypical Aflutter RFA atypical Aflutter RFA Lead extraction Amiodarone load Propafenone Flecainide load Amiodarone load 86 Chronotropic incompetence 107 AVNRT 26 AVNRT 23 CVA 118 Chronotropic incompetence 148 PVC 168 Afib 167 NICM 142 Bradycardia 174 Bradycardia 90 CVA 142 Atypical Afl 79 Chronotropic incompetence 120 AVNRT 160 Intraventricular conduction delay 118 CVA 46 Bradycardia 132 Chronotropic incompetence Amiodarone load atypical Aflutter RFA Amiodarone load CRT-D 3581 6687 4234 HIS bun Tikosyn load 1180 1328 7613 1200 1314 9289 3986 6137 1967 10 Chronotropic incompetence 180 CVA Leadless PPM Flecainide load atypical Aflutter RFA Amiodarone load 186 Bradycardia 60 Chronotropic incompetence 29 NICM 107 Chronotropic incompetence 110 CVA 59 AVNRT

“We Offer Paper Writing Services on all Disciplines, Make an Order Now and we will be Glad to Help”

3 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published.