Notes for running my macros:
- Set Excel
security to medium before running these (tools->macro->security)
- I have
endeavoured to make these totally harmless, however these programs are
loaded & run at your own risk
- Most of my
program create a toolbar. If you do
not have macros enabled, the toolbar will not be deleted when you exit
Excel. You can delete it either by
enabling the macros before closing Excel, or by deleting them yourself.
(view->toolbars->customise)
Virtual tiler
This is a great little utility for tiling images
together. I used it for planning the tiling
for my shower room, and for joining all the little maps you can get off the
internet, to make a bigger one!
Sudoku solver
This does the three stages of Sodoku solving – I call
them ‘Distill’, ‘Reduce possibles’ and ‘Recursive’ (recursive is only used in ‘Super
solver’ mode). I have tried to set the
recursion levels such that it doesn’t spend too much time on each ‘branch’, but
I occasionally come across the odd ‘Extreme diabolical bastard’ Soduko puzzle
which it fails on. If you know your way
around VBA, you can play with the recursion levels.
Maze
Creates a maze out of Excel cells. The ‘repeat’ creates a maze, and then solves
it. And repeats until you press ‘escape’. Just therapeutic. If you are interested in programming, this is
a great example of recursion for both the ‘create’ and the ‘solve’ parts. There is hardly anything to it!
Viz TV
Format-o-matic
Are you a TV executive? Need an idea for a new show? Viz came up with the ideal solution for
creating new and original TV shows. I’ve
coded it in Excel for you.