Tag Archives: download

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.

Downloadable content Excel Projects

Developers Diary: An Excel Timesheet – The Basics

Ok, so I’ve started.  The file is attached here.

There’s quite a lot to talk about but I’m feeling a bit poorly today and not looking at going too much into depth.  Have a look around the file and I’ll post again about what I’ve done so far.  If there’s anything you’d like to suggest or anything that doesn’t look quite right do let me know.

Interesting things to look out for:-

  • Added right-click code on the timesheet page to block highlight days as annual leave or sickness.
  • Some pretty cool stuff going on with conditional formatting using named ranges on the timesheet page.
  • Started work on a setup page which will define how the sheet is used.

More to come soon when I feel better… :-(

Downloadable content Excel Functions and Formulas

Answer to yesterday’s CONCATENATE project

Yesterday, in the tutorial about CONCATENATE I asked if you could put together a formula which might use both CONCATENATE and CHOOSE to output different text based on user input.  Here’s a way that this could work – I’ve uploaded an Excel file and it can be downloaded from here.

You can click on the image for a larger version so that you can see how it all fits together.

So, what have I done here?  I’ve set up a table in the range A1:D6 which contains various text items.  In cells E3, E4, and E6 you can type numbers 1 to 4 to change the output of the CONCATENATE function based on which item is chosen from the three CHOOSE functions in the formula.  I know the resulting formula is pretty chunky, but does it make sense?  Download it and have a try and you’ll see what I mean.

It’s not the best example out there, but it shows a way that two or more functions can be combined to make a spreadsheet more powerful.  You could use any other functions to do similar things.  You might, for example want the output to be defined by the result of a lookup function, or the result of a mathematical equation.  As I work through the A to Z I’ll start posting more examples of how they can be used together to give a greater edge to your work.

Download the file and have a play with it to see what you can do.  If you come up with anything really interesting, do let me know.

Downloadable content Excel

UDFs Add-in updated with new function

I’ve added a new UDF to the file I created earlier in the week.  Check out the downloads page for further details.