2007年4月8日星期日

Use Excel Borders to Draw Timing Diagram

I need to demonstrate some signal timing information in timing diagrams this week. Not being a VHDL developer, I found an amateurish way to do that: use Excel's cell border to shape the signal.

Suppose I'm going to draw the following diagram,



  1. Create a new sheet and reduce the width of all columns to 20 pixels or less. The width of a column will be used as the minimum clock width in the whole diagram.
  2. In the Border Toolbar, click "Draw Borders" to open the "Draw Border Toolbar". Choose the line type if you like.
  3. Use the "pencil" to draw your diagram, use the "rubber" to erase.
  4. For signals of data bus type, use "Fill Color" or "Fill Pattern".
  5. Cut/Copy and Paste also works, so you just need to copy the same pattern a few times to create the whole diagram.
  6. Add text in cells as comments, and change cell size if needed. Now I'm finished:
  7. If you need to show the exact slope of rising/falling edge of a signal, you can merge some vertical cells and use a diagonal line.


Advantages
  • No additional software is needed to create or view the diagram. I believe everyone has Excel, or something equivalent such as Open Office Calc or Google Spreadsheets(which don't support drawing borders at the moment).
  • Easier and quicker comparing with general purpose drawers such as MS Paint.
  • Text-based(or rather vector-based) document type has smaller file size than pictures, especially when the diagram is very big.

Problems
  • Won't show up if directly pasted to Word or some online html editors(the blogger editor, for example). They seems to have different understandings about styles of form cell borders with Excel. My current workaround is to printscreen to a picture or print to a PDF(with PDFCreator).

Alternative solutions

3 条评论:

匿名 说...
此评论已被博客管理员删除。
匿名 说...

Who knows where to download XRumer 5.0 Palladium?
Help, please. All recommend this program to effectively advertise on the Internet, this is the best program!

Arjunane Denature 说...

It is your colourful blog that brings me a lot of knowledge about living.
Cara Instan Menyembuhkan Penyakit Kutil Kemaluan Tanpa Pembedahan