Oswaldus,
I am glad that those cells are "empty". They should not have any equations. Cells that represent pushbuttons or switches do not have equations, but simply contain a "1" (ON) or "0" (OFF).
Cells from A1 to O20 are the elevator "car", a simulation of the elevator as it moves up and down. It contains the Floor Call Pushbuttons and the Car Call Pushbuttons. The simulated "buttons" are cells that you set to "1" (type in a "1" and press enter) if you want the car to come to that floor. When the car arrives that floor, the "button" (cell location for button) will be reset to "0" to simulate that the button is no longer active (lighted).=
Here is the way that I set up the Elevator Simulator spreadsheet: pushbuttons, limit switches, door position switches, and car position switches are represented by cells, one cell for each physical switch oe pushbutton. When a specific switch should be ON (because of car or door position), then macro program sets that switch cell equal to "1". When a switch should be off the macro program sets the cell for that switch to "0" for OFF.
The floor and car pushbuttons are cells that you enter the button press maually by typing in a "1" if you want that button to be active or ON. The 6 Car Pushbuttons CPB1 to CPB6 serve two functions (multiplexed). While the car is stopped, the center horizontal row of cells in the "car" serve as Car Floor Pushbuttons, so that if someone"enters" the car and sets one of the buttons to "1", then the door will close and the car should move to the floor selected. After a button is pushed, the function of the horizontal row ofr 6 cells changes to be a door closing indicator. As the door closes (controlled by a timer), the buttons change to "X". When all 6 cells show " X X X X X X ", then the door is closed. By doing these two duties for these same 6 cells, I was able to keep the car two rows smaller, so that all of the elevator could be simulated and seen easily on ONE screen.
There is a Macro program in the spreadsheet that reads the buttons and moves the On/Off signal for each button to the proper relays.