How to make a Heat Map
Open Excel Spreadsheet
Make a key like this one:
This is the basic key I used to keep my parts of speech straight.
Open a plain text file program,
Type up the poem/text how it is (with line breaks/ any other spatial requirements)
Go back to excel,
from the file tab, click Import. Then click “Plain Text” bubble. Set your parameters (separate words into columns by space/comma/semicolon/other) Choose “space.” Then click “finish”.
Start filtering the text using your key. Once each word has an associated number, make sure your Macros are enabled. (blanks get zeroes within the poem field).
Once the Macros are enabled, click on “Visual Basic Editor,” and click on “sheet1.” Type in this code:
Then [x] out of the Visual Basic Editor.
Click on Macros, select the “sheet1” option, and click “Run.” It will then ask you to “select range of cells.” Only select the numbers within the field, the click “okay.”
The result should look something like this:
The goal of these heat maps is to use them as a visual tool to show the frequency of parts of speech, punctuation, line length, line breaks, any inconsistencies with the poetics. It could also be used to differentiate different rhythm and meter: all you’d have to do is make a different key, and separate by syllable rather than word.