If you are into geeking it out with projects of the electronical kind, then you have likely wanted to create a dot matrix display or a POV. To do this you will need to have a font file or table to read the characters from.
There are alot of ways to get this file. The common sizes of displays are 5x7 and 8x8. There's alot of places online where you can get ASCII 5x7 fonts, but I am making a scrolly display with 8x8's and I wanted to use the whole height of the matrix so I created this tool to easily format and create patterns and fonts and get them into the right format for C programming.
The attached file was created in excel and it has a couple of macros which make things easy. You will fill in the display area with 1's and 0's and then click a button and it will store your pattern in some cells below and convert everything to a hexadecimal string for popping into your C compiler or header file.
The attached file includes 5x8 fonts for A-Z, a-z, 0-9, some punctuation, and some awesome 8x8 patterns and graphics.
Not that it matters, but I am using the AVR ATtiny2313 and AVRStudio 4.16 with WinAVR GCC for controlling my scrolling display. I don't have it done yet but atleast making the font file was easy with this tool.
Check out the steps in this instructable to find out how to use the Matrix Font Generator
There are alot of ways to get this file. The common sizes of displays are 5x7 and 8x8. There's alot of places online where you can get ASCII 5x7 fonts, but I am making a scrolly display with 8x8's and I wanted to use the whole height of the matrix so I created this tool to easily format and create patterns and fonts and get them into the right format for C programming.
The attached file was created in excel and it has a couple of macros which make things easy. You will fill in the display area with 1's and 0's and then click a button and it will store your pattern in some cells below and convert everything to a hexadecimal string for popping into your C compiler or header file.
The attached file includes 5x8 fonts for A-Z, a-z, 0-9, some punctuation, and some awesome 8x8 patterns and graphics.
Not that it matters, but I am using the AVR ATtiny2313 and AVRStudio 4.16 with WinAVR GCC for controlling my scrolling display. I don't have it done yet but atleast making the font file was easy with this tool.
Check out the steps in this instructable to find out how to use the Matrix Font Generator
Remove these ads by
Signing UpStep 1: Open the Generator File - Get Excel Setup
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:
Tools>Options>Security or Tools>Macros>Security
Here's what Microsoft says about this
office.microsoft.com/en-us/excel/HP052356701033.aspx
***REQUIRED STEP***
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:
office.microsoft.com/en-us/excel/HP011277241033.aspx
If you don't have the Add-In turned on then the column total cells in row #10 will show a #NAME.
Anyways,
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 ## or #NUM in those cells if you put something other and 1 or 0 in there.
Tools>Options>Security or Tools>Macros>Security
Here's what Microsoft says about this
office.microsoft.com/en-us/excel/HP052356701033.aspx
***REQUIRED STEP***
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:
office.microsoft.com/en-us/excel/HP011277241033.aspx
If you don't have the Add-In turned on then the column total cells in row #10 will show a #NAME.
Anyways,
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 ## or #NUM in those cells if you put something other and 1 or 0 in there.
Visit Our Store »
Go Pro Today »
Each time I create a pattern , and press store pattern & clear display, the result in the Left side columns 1-8 is over written. Is this correct, or should it append to the list?
Check it out here http://box-fish.com/matrix-tool.php
Let me know if you want any features/changes/suggestions etc
can u give me the schematics of this project.. help is appreciated.. thx!
Luqman Rosley
very useful for me, thank you!
I make same minor changes (excel 2003) for better working with 8x8 displays. You can now convert hex codes to the pattern editor.
Thanks for your concern and all those nuggets and starter resources you furnished in your reply. I can't say how long before I do master the tech and art but I put it tentatively at the next 6 months. Thanks!
Then once you kind of get those concepts, you'll need to learn how to program a microcontroller to handle the display and do the actual work. There's alot of good platforms out there for microcontrollers (MCUs). A good beginning point is the Arduino which is based on the Atmel AVR family of MCU's. This is the site to look at for that: http://www.arduino.cc/ They are kind of pricy at $28, but they will serve as the brain for your project. they are programmed in some free software using a language that is bascially watered-down C code. If you want to get a little closer to the "real thing", then you get go striaght into working with Atmel AVR's. They are more powerful and are programmed in standard C code. A programmer will be about $30, but then the actual MCU's are only $1-$4 each. This is the route I went. Here's a good place to start reading: http://www.evilmadscientist.com/article.php/avrstuff
You'll have to understand that this instructable for the Scrolling LED Fonts is just an easy way to create the code for each letter. There's alot of other things going on to get those letters onto the display. Getting started into programming and playing with microcontrollers is the first step. Once you have the skills and review some other peoples code for Scrolling LED displays, you'll be able to make your own.
Here's a good site that shows how a scrolling LED sign works and how to build one (his code is in assembler tho, so its not super useful unless you learn assembler code which is old school)
http://www.attiny.com/dotmatrix.htm ( you might have to look at the cached version on google becuz the site seems to be down today)
It's a journey. There's about 10 key concepts you'll need to understand about the features of a MCU to get the dot matrix LEDs to do what you want. If you go with the Arduino, there's a ton of guys out there who have already done led displays, and you could probably grab their code and just modify it as you see fit. The save is true for the AVR, but there's not as many guys using them as the Arduino because the Arduino is a bit easier for beginners.
You have a lot of reading to do on line and get started with MCU's a simple stuff like flashing LEDs, using 74HC595 shift registers, make a little POV circuit (googe it), maybe play with multiplexing some 7 segment displays, then you will be about ready to build a led scrolling display, grasshopper. There's a good instructables based on an AVR Attiny2313 (very common AVR MCU) that's called "64 pixels" and it's a simple scrolling sign. Here's a link to it:
http://tinkerlog.com/howto/64pixels/
Look through the code. Anyway, I hope this is all helpful. I can't convey all of it in an email. You're going to have to take itfrom here and start reading and playing around with MCU's. There's lots of resources out there. Good luck - roznerd
Beautiful project. I remember doing font creation by hand back in the day (25 years ago).
~/Lee
You may have already worked around this but I caught it while programming my POV project. So here you go. The latest version is up here.
after fixing that it worked out fine. good lible
thank you.
I have uploaded the VBA code with comments if you'd like to check it out
www.filedropper.com/dotmatrixfontgeneratorvbacode
P.S. OpenOffice is a completely free open source office suite
Here's what Microsoft says about it:
http://office.microsoft.com/en-us/excel/HP052090031033.aspx
Doing this will solve your concatenate issue. I will edit the Instructable to make this clear. Hopefully it works for you. I don't see why it wouldn't.
Thanks for the feedback.
I'm building a pov and want to build my own fonts, etc. Arduino being really limited for memory I'm tempted to do as much of this procedurally as possible but why didn't I think to macro the crap out of excel?!
Beautiful, simply beautiful. Using good formulas, conditional formatting for error checking, and macros to assemble the rig. BEAUTIFUL!
I hate using functions that appear and disappear between versions of office. I would have opted to have a 128*D1+64*D2+32*D3...function to figure out the decimal, then display it as hex. Super complex? Yes, but guaranteed to work :D