skip to Main Content

Background Fairview Tower1 is a new residential and office building located in

Background Fairview Tower1 is a new residential and office building located in downtown Seattle. It has 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 regular passenger elevators while Unit D is a service elevator that can also be used to move passengers if needed “ more on that later. Each time a ride is requested an algorithm will decide which elevator unit is assigned to pick up the ride following a set of rules. You are asked to work out an automatic assignment application for Fairviews management team. The Excel file IS300FairviewTemplate.xlsx (available for download on Canvas) simulates the building and the elevator units. You must enable iterative calculation on the file and set the max iteration to 1 (the option can be found by going to File “ Options “ Formulas on a PC or Excel “ Preferences “ Calculation on a Mac). Each unit has a location number meaning the floor it is currently at and a destination number meaning the floor it is going to. A unit is moving when the destination number is different from its current location and a unit is idling if the two numbers are the same. In the Excel file you can see how they move floor-by-floor by pressing the 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 the letter U or D (e.g. 23D). The number means the floor where the ride is requested and the letter means the direction of the mission: U means going up and D means going down. For example mission 23D means a ride of going down is requested on the 23rd floor. Requirements Download and rename the template file. Create additional worksheets to build your model but on the Fairview worksheet you must preserve its structure and only edit the green 1 This is an imaginary building so dont bother to Google. 2 cells. 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 (the direction). The rules of assignment are: 1) No Mission: If no mission or an incomplete mission is entered (i.e. missing floor number or 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. If multiple elevators are idling at the request floor randomize which one to assign except that Unit D (the service elevator) should get the last priority i.e. D gets the mission if it is the only one idling. For example if mission 23U is requested when both Unit A and D are idling on 23rd assign A to the mission. 3) Second Priority: If no elevator is assigned after 2) find and assign the unit that is closest 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 missions direction. Do not assign units moving away from it or moving towards it in an opposite direction of the mission. If multiple units qualify randomize which one to assign but like in 2) Unit D (the service elevator) should get the last priority. For example if 23U is requested when A is idling on 19 B is on 21 going down C is on 0 going up and D is on 26 going down A should be assigned to the mission. Unit B or D are not in this case even though they are closer because they are traveling down not up. 4) Otherwise: If no elevator is assigned after 3) display N in cell B12. This means the mission is not picked up yet. If your model is built right it will eventually be picked up after other units reach their destinations and therefore become idle (i.e. eligible). Hints Start with No Mission and work your way up. Make sure you really understand the rules and requirements. You may find it helpful to create additional indicator labels for each elevator to show if it is busy moving in the same direction as the mission etc. These Excel functions are enough for the project: IF ABS MAX SUM and RAND. You are of course allowed to use other functions of your choice. The following steps are provided to test your model which will be graded 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 your ASSIGNMENT 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 20th floor. Then type 42 41 0 -3 in the INITIATE row to move units A and B up and C and D down. 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 25th floor. Then type -3 0 41 42 in the INITIATE row to move units A and B down and C and D up. Enter mission 25D. Your model should assign N i.e. the mission is not picked up before Unit C reaches 41st floor. After that your model should assign C.

Features You Can Count On

We have a quality check process in place for every assignment we complete for the students. This process assure that students receive nothing but THE BEST

Your Grades Soar

With our specific and personalized attention, you get the dual benefits of understanding the concepts and fundamentals of your subject and its nuances. And you can always keep up with class room teaching and get good grades too!

Trusted Experts

Our team of experts are drawn from group of academicians who hold doctorates in their chosen fields. They have been teachers all their lives. They understand your needs and can help you with exams, homework and assignments.

Delivery Guarantee

Our online tutors know the importance of handing in tasks on-time and in the format required by each college. Our discipline is reflected in our strict adherence to on-time delivery of your assignments and homework.

24X7 Availability

We draw the best talent in the form of lecturers, professors, online tutors and subject experts from all over the world. For this reason, when ever you may need help, it’s always there for you. Available, reliable and guaranteed.

Privacy Guaranteed

We respect your privacy. We never disclose your personal or contact details to anyone under any circumstances. So, you can communicate with our team confidently and always be 100{0afbfe2db91aa1d41f515ba8d9a3a5568a6417cbf60a0175c7628d43a1875498} assured of complete privacy of all your dealings with us.

Satisfaction Guaranteed

We have built a reputation of offering professional homework and assignment services. We assure you of our continued support for as long as you want it, each time to guarantee you 100{0afbfe2db91aa1d41f515ba8d9a3a5568a6417cbf60a0175c7628d43a1875498} satisfaction.

We're Here For You 24/7

We are known for our impressive quality of work. Students around the globe prefer our assignment writing services as we provide them the excellent features and benefits. Take a look at the alluring features.

Plagiarism-Free Affordable Papers
Money-Back Guarantee
Timely Delivery
Affordable
Zero-Plagiarism Guarantee
Find out More

Our Services

Exquisite Essay Writings specializes with preparation and writing of all your premium writing projects. We mainly deal with academic research and project writing services but offer a wide verity of additional writing services like coursework, dissertation and thesis essay writing. We have a team of highly trained and skilled professionals from every sector and profession thus insuring your projects are handled in the best possible manner. We have been in the academic assistance service since 2008 and managed to build a large network of clients from across the globe and covering practically every sector of business and education available today.

Custom Essay Writing Service

Looking for the best custom assignment writing service online? Relax! exquisiteessaywritings.com is a trustworthy affordable writing service that delivers clients with quality custom assignments.

Creative Essay Writing

Do you feel like you lack the skills to write creative essays? Then you need help. Exquisiteessaywritings.com is the only creative essay writing service that will deliver creativity with a magic touch

Term Paper Writing

Get an excellent grade on any custom term paper writing service. All of our customers remain anonymous throughout the entire ordering process. We guarantee that your education will not suffer.

Research Paper Writing

Looking for a legitimate and trustworthy High School/College custom research paper writing service? That exceeds your expectations to become that number website write papers for you! Well, here it is. Receive high-quality papers, 24/7 support

Annotated Bibliography

Are you looking for someone to write your MLA, APA, Chicago Style annotated bibliography? Good News! hire us, Our annotated bibliography writers are always ready to offer Custom annotated bibliography writing in all fields.

Thesis Writing Service

Are you searching for thesis writing service? Do not blame anyone. The professional PhD/ MA writers at exquisiteessaywritings.com are here to help. Contact support to find out more information about our writing service.

We're Obsessed with Your Privacy
1. Anonymous Chatting
At YourAssignmentHelpers.com, you can communicate directly with your writer on a no-name basis.

2. Secure Payment Methods

We accept only Visa, MasterCard, American Express and Discover for online orders.
3. Complete Confidentiality
Your personal details remain confidential and won’t be disclosed to the writer or other parties.

Testimonials

Have a look at some of the wonderful things people say about us.

Superb

“Believe it or not, but I’m fully satisfied with the essay you’ve written for me. I have got an excellent mark and I’m now convinced in the truth of your promises. Thanks”

Good Service

“Thanks for good service and high quality. The research paper was much more than I expected!Thanks”

Unbelievable

“Unbelievable. The writer followed all my instructions and created a brilliant essay, I would say. What I like most of all, no one suspects even that my essay wasn’t written by me. Thanks”

Thanks

“Thanks. Without you I would not have been a Master of Psychology.”

I’m so happy about it

“Just when I was about to give up on my dissertation, my friend advised me to use your service. It was timely advice because I was stuck and didn’t know what to do. Now I am a PhD degree-holder and I’m so happy about it”

Great

“I thought paper writing services are the fiction and rip-off for naïve students. But when it came to my research paper that was to be handed in in 72 hours , I had no variants. I made the right choice when I ordered my paper from you and I’ll definitely use your services in the future.”

We Are A Leader In The Academic Writing Industry.

Share via
Copy link
Powered by Social Snap