Excel VBA HW
das-_-
Chapter 11, Problem 12
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 K)
ΔT is the change in temperature (K or °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 to 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 (assuming no energy losses).
Create a User Interface Worksheet like the one shown below, and create a Sub procedure that reads
the specified user inputs, performs all necessary calculations, and then writes out the results under
"Calculated Information" section on your worksheet.