Create Heat Map
Selecting this option replaces the statistical summary section with the following:
Normally heat maps are used where you have a lot of compound data for example you want to visualise quickly how each compound behaved in inducing some sort of cellular response across the doses at which the compound was tested. Normally, we put the compounds in rows and doses in columns with each response colour coded from low to high. Likewise, the positive and negative control will be a single dose and so it is best to move these to the bottom of the heatmap table so they don’t break up its continuity. Therefore, when the heat map option is active the following fields are visible:
Negative Control: Allows the user to enter the name of the negative control as defined on Page 3 of the “Create New Data Entry Workbook” wizard. Note negative control labels you have used when naming controls on page 3 of the wizard will be available for selection from the dropdown list box.
Positive Control: Allows the user to enter the name of the positive control as defined on Page 3 of the “Create New Data Entry Workbook” wizard. Note the positive control labels you have used when naming controls on page 3 of the wizard will be available for selection from the dropdown list box.
Heat Map Colour: The two main options are “One way Red High” and “One way Red Low”. All heat maps are green in colour changing to red as values go from lowest to highest (One way Red High) or from highest to lowest (One way Red Low). If you specify the Negative Control name in the Negative Control field (see above) then a third option is available which is a two-way heat map (“Two Way”). In the two-way heat map the control value is set to green and all values less than the control value get progressively more blue as the values reach a minimum, while all values greater than the control value get progressively more red as the values reach a maximum. In summary:
1. One way Red High (below 51 percentile green to red above 97 percentile).
2. One way Red Low (above 49 percentile green to red below 3 percentile).
3. Two way (equals control: Green, moving to blue at below 3 percentile to red above 97 percentile).
Page Mag: Normally to fit the heat map into the viewable area of the workbook, you need to decrease Excel’s default page magnification from 100%. This little selection box allows you to easily select a suitable page magnification of either 30%, 40%, 50% or 60% of the original page size.