Category Archives: Downloadable content

Here you can find links to downloadable content I’ve created for the site.

2toria Downloadable content

The Amazing 2toria Task Shuffler!!!

New from 2toria.com!!  Beat procrastination simply and easily with the 2toria.com Task Shuffler!

Do you have a list of tasks, but don’t know which one to choose?   Just enter your task list into the intuitive, easy to use interface and click the Shuffle button to let the Shuffler pick one for you.  Its super-intelligent task-selection technology shuffles randomly and, after a few seconds, tells you which one to choose.

It’s AMAZING!!  SERIOUSLY!!

(Actually it’s not really amazing, it’s just something daft that I threw together today, but it does use a couple of useful techniques so why not download it and have a look?)

Downloadable content Excel Random

Collatz Conjecture – An Excel model

The other day I was leafing through ‘Professor Stewart’s Hoard of Mathematical Treasures‘ whilst waiting for the bath to run and started reading about the Collatz Conjecture, a theory which states that, if you start with any number and apply the following logic to it:-

If the number is even, divide it by 2

OR

If the number is odd, multiply it by 3 and add 1

…and continue to do this for each resulting number, you will eventually always get to number 1.  The theory, known also as The Ulam Conjecture, The Syracuse Problem and some others hasn’t as yet been proved, and still stumps mathematicians to this day.

I didn’t want to prove/disprove it, I just wanted to play with it a little, so I build this little plaything for fun.  Download it and have a go.  It takes any figure you enter and runs the process above on it and its results until it inevitably reaches one.  I put the sheet together using some pretty simple VBA, as well as using some conditional formatting and other tricks here and there.  The whole sheet is unprotected so you can have a look at how things work.  I added the chart for no reason other than showing the pattern of numbers – smoothing has been added to the line to make it look more pretty but other than that it’s no use other than to fill up some space on the sheet.

I find it really interesting that some initial ‘seeds’, if you like, can create some pretty wild reactions.  Look at what happens to 11, for example:-

This tool/model won’t solve the problem, by the way.  Every number you can possibly type into Excel will always return 1 – it’s still possible however that there is some huge number out here that doesn’t..

 

2toria Access Downloadable content Visual Basic For Applications (VBA)

A very basic chat program in MS-Access

I‘ve just come across this little plaything I developed a year or so ago and thought I’d share it with you guys.  It’s a very basic chat program that you can use with your colleagues if you all have access to a shared network.  If you all open the MDB file you can chat with each other.

The code uses your network log-in name to define who you are and saves the ‘chat’ to a table within the database.  I’ve left everything open so you can look at the code etc, although there isn’t a great deal really – I’m actually surprised in hindsight just how simple it really is!

You will need to clear ‘tblConversation’ each time you’re done with the application, otherwise it will show the whole previous conversation.

I might someday develop this further, but for now as I said just thought I’d share with you.  If you can think of any uses for it, or if you want to have a go at amending it yourself please do and let me know how you get on.

Downloadable content Excel

Minesweeper for Excel – Early version

I’ve uploaded another little creation of mine – Minesweeper for Excel.  It’s a fairly simple implementation of the game and pretty buggy in places but on the whole I’m happy with it.  It only works properly on the large grid at the moment as I broke the small one adding some functionality the other night and haven’t got round to fixing it.

Anyway, broken software aside it’s pretty good and I’m chuffed that it pretty much does the same as the Windows implementation using just worksheet cells and some VBA.  It’s yet another way of showing exactly how versatile the application is and what can be done with it.  It’s worth checking out some of the code, named ranges and the conditional formatting on the grid as there’s some pretty useful techniques to pick up there.

I invite you to have a go at fixing it/tidying it up and commenting/emailing back.   Send your responses to admin@2toria.com.

Download it here.