BackgroundFairview Tower1 is a new residential and office building located in downtown Seattle. Ithas 46 floors – 43 above the ground (numbered 0 to 42) and 3 underground (numbered -1 to -3)– that are serviced by four elevator units (labeled A through D). Unit A, B, C are regularpassenger elevators while Unit D is a service elevator that can also be used to movepassengers if needed – more on that later. Each time a ride is requested, an algorithm willdecide which elevator unit is assigned to pick up the ride following a set of rules. You are askedto work out an automatic assignment application for Fairview’s management team.The Excel file IS300FairviewTemplate.xlsx (available for download on Canvas) simulatesthe building and the elevator units. You must enable iterative calculation on the file and set themax iteration to 1 (the option can be found by going to File – Options – Formulas on a PC, orExcel – Preferences – Calculation on a Mac). Each unit has a location number, meaning thefloor it is currently at, and a destination number, meaning the floor it is going to. A unit is movingwhen the destination number is different from its current location, and a unit is idling if the twonumbers are the same. In the Excel file, you can see how they move floor-by-floor by pressingthe F9 key to force recalculation of the functions (or Fn+F9 on a Mac).A ride (called a mission) can be requested by a code consisting of a number and theletter “U” or “D” (e.g., 23D). The number means the floor where the ride is requested, and theletter means the direction of the mission: “U” means going up and “D” means going down. Forexample, mission 23D means a ride of going down is requested on the 23rd floor.RequirementsDownload and rename the template file. Create additional worksheets to build yourmodel but on the Fairview worksheet you must preserve its structure and only edit the green1 This is an imaginary building so don’t bother to Google.2cells. The INITIATE row is used to initialize the elevators to a starting state for testing purpose.Your file should automatically fill the ASSIGNMENT cell (Cell B12) with the letters “A”, “B”, “C”,“D”, or “N” (meaning none) when a mission is entered in cell B10 (the floor) and D10 (thedirection). The rules of assignment are:1) No Mission: If no mission or an incomplete mission is entered (i.e. missing floor numberor direction), your model should display an empty cell (i.e., “”) in B12.2) First Priority: If an elevator is idling at the request floor, assign the mission to it. Ifmultiple elevators are idling at the request floor, randomize which one to assign exceptthat Unit D (the service elevator) should get the last priority, i.e., D gets the mission if it isthe only one idling. For example, if mission 23U is requested when both Unit A and Dare idling on 23rd, assign A to the mission.3) Second Priority: If no elevator is assigned after 2), find and assign the unit that isclosest to the request floor. Please only consider the ones that are either a) idling, or b)moving towards the request floor in the same direction as the mission’s direction. Do notassign units moving away from it or moving towards it in an opposite direction of themission. If multiple units qualify, randomize which one to assign but like in 2), Unit D (theservice elevator) should get the last priority. For example, if 23U is requested when A isidling on 19, B is on 21 going down, C is on 0 going up, and D is on 26 going down, Ashould be assigned to the mission. Unit B or D are not in this case even though they arecloser because they are traveling down not up.4) Otherwise: If no elevator is assigned after 3), display “N” in cell B12. This means themission is not picked up yet. If your model is built right, it will eventually be picked upafter other units reach their destinations and therefore become idle (i.e., eligible).HintsStart with No Mission and work your way up. Make sure you really understand the rulesand requirements. You may find it helpful to create additional indicator labels for each elevatorto show if it is busy, moving, in the same direction as the mission, etc. These Excel functionsare enough for the project: IF, ABS, MAX, SUM, and RAND. You are, of course, allowed to useother functions of your choice. The following steps are provided to test your model, which will begraded by 10 tests similar to these – 1 point will be awarded for passing each.1) Type an incomplete mission without the floor number or direction letter, e.g., 23, yourASSIGNMENT should show an empty cell.2) Type 1,1,1,1 in the INITIATE row and press F9 to move all the elevators to the first floor.Enter mission 1D. Your model should randomly assign unit A, B, or C to the mission.3) Type 20,20,20,20 in the INITIATE row and press F9 to move all the elevators to the 20thfloor. Then type 42,41,0,-3 in the INITIATE row to move units A and B up, and C and Ddown. Enter mission 10D. Your model should assignment unit C.4) Type 25,25,25,25 in the INITIATE row and press F9 to move all the elevators to the 25thfloor. Then type -3,0,41,42 in the INITIATE row to move units A and B down, and C andD up. Enter mission 25D. Your model should assign N, i.e., the mission is not picked upbefore Unit C reaches 41st floor. After that your model should assign C.

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.