Important pre-assignment works you need to do before you start solving the Assignment
a. Read Chapters 3 and 4 of the Glad manual supplied with this Assignment to learn more about Excel's IF function, logic functions and Text Functions.
b. Read more about Implicit intersection Operator @ and the #SPILL! Error. Check the following link.
a. Note: In case you get unexpected values or #SPILL! Error with formulas you use, add the implicit intersection operator (@) in front of range names. Example: range name pass_mark with the implicit operator is @pass_mark.
Feel free to find online resources on these and share them with your classmate on the discussion forum
Part One: Assignment Structure
Download the starter Excel file named "PatientVisit.xlsx" from the eClass course site
The file contains several worksheets as follows:
• PatientVisits: worksheet contains the data about patient visits. Check the header of the columns
Row_ID
Date of Admit
Date of Discharge
Doctor Full Name
Hospital Branch
Department Type
Department
Patient ID
Patient Name
Patient Risk Profile
Revenue
Minutes to Service
Number of Patient Visits
• Task1: worksheet where you have to implement Task1.
• Task2: worksheet where you have to implement Task2
• Task3: worksheet where you have to implement Task3
Part Two: Task1
Important note: All formulas must use range names
Step1. Go to the worksheet named "Task1".
Step2. Write a formula that yields the doctor's Hospital Branch, Department Type and Department from a given doctor's name. i.e., once you write the doctor's name in cell A3 the following cells, B3, C3, and D3, will be updated with the required information.
Note: You need to make sure that you return an exact match.
Step3. Write a formula that yields the Total number of patient visits the given doctor sees. You have to write the formula in cell B7.
Step4. Write a formula that yields the Total Revenue for the given doctor. You have to write the formula in cell C7.
Step5. Given the doctor's full name written by you in cell A3, you need to write a formula to create the doctor's email address according to the following rule, the first letter of the doctor's first name followed by the doctor's last name and then add @hospital branch.com to the end. Note: If the doctor's last name contains space, you need to replace the space with an underscore symbol.
Example1: if the doctor's full name is Jonas Salk, the email should be JSalk@South.com Example2: if the doctor's full name is Robert Reynolds Macintosh, the email should be RReynolds_Macintosh@Central.com
Hint: you probably need to use text functions LEFT, RIGHT, FIND, SUBSTITUTE, LEN etc. See ch 4 of glade manu for more information.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
