Comfort Coil Sizing Calculator

We need a sizing calculator for one of our products called the Comfort Coil, The Comfort Coil is a hydronic heating and cooling appliance, we use water or glycol to transfer energy for the source to the Comfort Coil and then back to the source. The calculator will help contractors decide the amount of product required to heat and cool a project using a Comfort Coil. The calculator will need to take the number of BTU's required to heat a building and then divide by the amount of BTU's the comfort Coil will output. In order to calculate the output of a Comfort Coil, the program will need to reference a look up chart. We would also like the program to provide sizing to an individual room based on volume and BTU’s required. Ideally the user would only be able to enter information into boxes for example, total BTUs required, size of rooms, Temperature of circulation loop.