View Single Post
  #6   Spotlight this post!  
Unread 31-01-2004, 18:30
WillyC's Avatar
WillyC WillyC is offline
"handy"
#1347
Team Role: Engineer
 
Join Date: Jan 2004
Location: Ottawa, Canada
Posts: 29
WillyC is on a distinguished road
Re: Lookup table generation tool

Quote:
Originally Posted by KevinB
Hey ... I like this!

Beware though ... you may need to manually remove decimal values from the generated tables.

Also, you need to ensure that the values that you generate are under 256 (unless you change how the array is defined.)

Thanks Kevin, hopefully it helps. I like excel because you can change formatting, copy formulas etc really easily. I have set both of the data columns to show 0 decimal places, so you shouldn't have to manually edit any numbers. You can also use the Round() worksheet function to specify how many decimal places to use.