In cell g8 in the summary worksheet, insert a date function to calculate the number of years between 1/1/2018 in cell h2 and the last remodel date in the last remodel column (cell f8). use relative and mixed references correctly. copy the function to the range g9: g57. unit 101 was last remodeled 13.75 years ago. ensure that the function you use displays that result.

Awall of 0.5m thickness is to be constructed from a material which has average thermal conductivity of 1.4 w/mk. the wall is to be insulated with a material having an average thermal conductivity of 0.35 w/mk so that heat loss per square meter shall not exceed 1450 w. assume inner wall surface temperature of 1200°c and outer surface temperature of the insulation to be 15°c. calculate the thickness of insulation required.