Download and open the "Dot_Matrix_Font_Generator.xls" file. It contains macros which means you may have trouble opening it depending on your security settings. I promise that it is safe. You will need to enable and/or allow the macros to load for this to work. If you aren't prompted upon opening then this will we under either:
Here's what Microsoft says about this
For the excel functions to work you have to turn on one of the technical Add-Ins.
Go to Tools> Add-Ins
and Check the "Analysis ToolPak"
. This will allow the functions to do their thing. If you don't have it installed follow Microsofts instructions here:
If you don't have the Add-In turned on then the column total cells in row #10 will show a #NAME
The design is pretty intuitive.
Type a 1
for an LED you want on, a 0
for those you want off. Numbers other than 1 and 0 will cause the cell to turn red which means you better fix it or you get weirdness later. You will likely see ##
in those cells if you put something other and 1 or 0 in there.