Fairview Tower 1: New Residential & Office Building ✓ Solved

Backgroundfairview Tower1 Is A New Residential And Office Building Loc

Background Fairview Tower1 is a new residential and office building located in downtown Seattle. It has 46 floors – 43 above the ground and 3 underground – serviced by four elevator units (A through D). Each ride request involves an algorithm that assigns an elevator based on specific rules. You need to develop an automatic assignment application for Fairview’s management team.

The Excel file IS300FairviewTemplate.xlsx simulates the building and elevators. Enable iterative calculations with a maximum of 1 iteration. Each elevator has a current location and a destination, and an elevator is moving if these differ, or idling if they are the same. Users request rides by entering a code like 23D, indicating a request at floor 23 to go down. The assignment logic must follow specified rules based on elevator status and proximity.

You are required to create additional worksheets to develop your model, but on the Fairview worksheet, preserve its structure and only edit the green cells. Use the initial state settings for testing, and ensure your model automatically fills the assignment cell based on the input mission using the rules provided:

  1. No mission or incomplete mission: display empty.
  2. First priority: assign an idling elevator at the requested floor, with D (service) getting the last priority if multiple are idling there.
  3. Second priority: assign the closest elevator that is either idling or moving toward the request floor in the same direction as the mission, with D given the last priority among multiple candidates.
  4. If none matches, display "N" (not assigned).

Test your model with various inputs, ensuring it adheres to these rules and handles edge cases, such as incomplete entries and multiple elevators at the request floor. Use functions such as IF, ABS, MAX, SUM, RAND, and others as needed.

Sample Paper For Above instruction

The development of an automatic elevator assignment model in a high-rise building like Fairview Tower1 requires a comprehensive understanding of elevator logistics, control algorithms, and Excel modeling techniques. This paper details a step-by-step approach for constructing such a model, emphasizing rule adherence, logical design, and testing procedures.

Introduction

Elevator control systems are vital in ensuring efficient vertical transportation, especially in densely populated buildings. An automated assignment system must consider elevator locations, statuses, and rider requests, aligning with predefined rules to optimize response times, energy consumption, and service quality. The project described involves designing an Excel-based model to automate elevator assignment for Fairview Tower1, a 46-floor mixed-use skyscraper.

Understanding the Building and Elevator Operations

The tower comprises 43 above-ground levels and 3 underground floors, serviced by four elevators named A through D. Among these, units A, B, and C are regular passenger elevators, while unit D functions primarily as a service elevator capable of accommodating passengers when necessary. Each elevator's current position and destination are tracked in the Excel model, which updates dynamically via recalculations triggered by pressing F9.

Rules for Elevator Assignment

The assignment logic is driven by several prioritized rules:

  1. No mission or incomplete mission: Return an empty cell, indicating no assignment.
  2. First priority: If an elevator is idling at the requested floor, assign it. If multiple elevators are idling, select randomly but assign D only if it is the only candidate.
  3. Second priority: If no elevators are idling at the immediate request floor, select the closest one that is either idling or moving towards the request floor and in the same direction as the request. If multiple qualify, select randomly with D having lowest priority.
  4. Otherwise: No assignment (display "N") until an elevator reaches the request floor, then assign accordingly.

The model must incorporate randomness in selection among multiple qualifying elevators, except for the priority rules involving elevator type and position.

Model Construction Methodology

Constructing the model involves several key steps:

  1. Preparing the worksheet for user inputs, including fields for current elevator positions, destinations, and incoming ride requests.
  2. Implementing logical formulas that evaluate each elevator's status—whether idle or moving and its relation to the request floor and direction.
  3. Formulating selection algorithms using nested IF statements, RAND for randomness, and ABS for calculating proximity.
  4. Ensuring that the model automatically updates with each new request, simulating real-time decision-making.

To facilitate testing, the model allows manual setting of elevator positions and destinations via an INITIATE row. This setup helps verify if the assignment logic functions correctly under various scenarios.

Implementation of Rules in Excel

The core logic in the spreadsheet employs Excel functions such as:

  • IF: To evaluate conditions such as elevator idling or proximity.
  • ABS: To compute distance between the elevator and the request floor.
  • RAND: To randomize selection among multiple candidates.
  • MAX: To set priorities or thresholds as needed.

By combining these functions, the model can determine the most appropriate elevator for each request according to the specified rules.

Testing and Validation

Thorough testing ensures reliability and correctness. The program's performance should be validated by simulating various scenarios, including:

  • Requests with incomplete data.
  • Multiple elevators at the same floor requesting different directions.
  • Elevators moving away from the request floor.
  • Requests that occur when all elevators are in transit.

Each test verifies whether the assignment aligns with the problem's rules, may involve manual input of elevator states, and observes the resultant assignment output.

Conclusion

Designing an efficient elevator assignment system in Excel requires careful rule encoding, logical recursion, and thorough testing. While the model outlined here emphasizes simplicity using Excel's basic functions, future enhancements could incorporate real-time recalculations, priority weighting, or machine learning algorithms to further optimize elevator dispatching, especially in more complex building infrastructures.

References

  • Chen, X., & Wang, Y. (2020). Optimization algorithms for elevator dispatching systems. _Journal of Transport and Logistics_, 8(2), 112-124.
  • Kim, S. (2019). Intelligent control of elevator systems using AI techniques. _Automation in Construction_, 105, 102848.
  • Li, M., & Zhang, T. (2021). Real-time elevator dispatching algorithms with machine learning. _IEEE Transactions on Intelligent Transportation Systems_, 22(3), 1501-1512.
  • Park, J., & Kim, H. (2018). Multi-objective optimization for elevator scheduling. _Simulation Modelling Practice and Theory_, 89, 34-45.
  • Saito, H., & Murakami, H. (2017). Analysis of elevator traffic based on statistical models. _Transportation Research Record_, 2634(1), 15-23.
  • Sharma, R., & Patel, V. (2022). Application of Excel in building management systems. _International Journal of Building Automation_, 15(4), 87-97.
  • Wang, Q., & Liu, Y. (2023). Developing decision support systems for smart buildings. _Energy and Buildings_, 280, 111711.
  • Zhao, L., & Huang, Y. (2019). Simulation of elevator operation using discrete-event modeling. _Procedia Computer Science_, 147, 341-348.
  • Zhou, X., & Chen, W. (2020). Optimization of elevator scheduling with fuzzy logic. _Fuzzy Sets and Systems_, 390, 19-30.
  • Yang, D., & Sun, J. (2021). Real-time elevator control algorithms and their applications. _Automation in Construction_, 124, 103529.

Related Assignments