excel work must include model formulas

Incandescent Space Heating

When energy is added to a fluid (liquid or gas), the temperature of the fluid increases. An equation

describing this phenomenon is:

𝑄 = 𝑀𝐶𝑝 △ 𝑇

Q is the amount of energy added (joules)

M is the mass of the fluid (kg)

Cp is the heat capacity of the fluid (joules/kg-°C)

ΔT is the change in temperature (°C)

A garage (24 ft x 24 ft x 10 ft) is illuminated by six 60-W incandescent bulbs. It is estimated that

90% of the energy consumed by an incandescent bulb is dissipated as heat. Question: If the bulbs

are on for 3 hours, how much would the temperature in the garage increase because of the light

bulbs? Assume that no energy is lost through the walls, floor, or ceiling of the garage.

Create a User Interface Worksheet like the one shown below, using the input/output units shown.

Wisely name the input/output cells so they can be easily referenced using the Range() method in

VBA.

Create a Sub procedure that does the following:

1. Declares all local variables using appropriate data types. 2. Reads the user inputs entered in the "Specified Information" input section of the worksheet,

using the cell range names that you defined, and stores the values in local variables.

3. Performs all necessary calculations. 4. Writes out the results to the "Calculated Information" section of the worksheet. Mind your

units!

Add user instructions and a printable "Run" button to the worksheet, for your user to use when

running your Sub procedure.