I am checking whether certain buildings need to be demolished and rebuilt ('rebuild'), or whether they should be renovated ('Recap').
The first key question I have to ask is "Is the building suitable for the occupants?" (The "yes" "no" answer is my first value).
If the answer is Yes, even thought it is suitable, I ask if the cost to fix it is greater than the cost to replace it, in which case the building is rebuilt, otherwise it is recapped.
If the answer is No, I ask if the cost to fix it is greater than 75% of the cost to replace it, in which case the building is rebuilt, otherwise it is recapped.
The chart is easy, but I don't know how to program getting the right answer.
Bookmarks