This is an extension of a Time of Day picker project ([url removed, login to view]).
I have data in a database table that I want to express in a time of day picker. The form of the heat map should be in the same format as the time of day picker (7 rows by 24 columns). One table with a list of inputs from the Time of Day picker is already created. A second table should be created that will have a calculated average of the information from the first table. There should also be another line of code to trigger a recalculation of the data when new data is entered into table 1 (Stored Procedure). The retrieval of information from the second table should be a stored procedure as well. The range of color for the heat map should be between green and red with green being the lowest value of the average and red being the highest value. The average values for the table 2 should range between 0 and 1. I am interested in using HeatColor([url removed, login to view]) and jQuery due to the fact that I am using jQuery for another project and it should speed the development time. Also check out this post ([url removed, login to view]) to get an idea on designing the grid.