The potential of harvesting heat energy from asphalt pavement using a piping network with fluid flowing through it needs to be evaluated before spending a significant amount of time on planning details of design and construction. The key factors involved in this evaluation include the temperature of the pavement at the depth at which the system is being considered, as well as the temperature of the fluid used for harvesting the heat energy. Costs include those required for the system such as pumps and pipes, and cost of energy required for pumping. Taking all of the factors into consideration, a macro-enabled spreadsheet has been developed that allows the user to input air temperature data as well as pipe location and cost parameters. The end results are data on flow rate versus yearly savings and payback period. From these data, a user can easily determine whether the payback period is reasonable or not and could also evaluate the effect of the different parameters on the payback period. Examples of the results of analysis for different cities in four different parts of the USA and Singapore and Chennai, India, are presented. The payback period shows a good relationship with the latitude of the location - the period increases with an increase in latitude. The public domain location from where the spreadsheet can be downloaded is provided. © 2011 Taylor & Francis.