Author Topic: Clockwheel Maker for Excel  (Read 35523 times)

Cad

  • Regular
  • *
  • Posts: 2260
  • 'Old school' radio guy (and PC programmer)
    • View Profile
Clockwheel Maker for Excel
« on: February 24, 2011, 04:38:27 »
I'm sure someone else here mentioned recently that they could not find any software to do this, but I can't find their post to reply to, so this is a new post.

Anyway, if you want make some proper old-school Clockwheels to print out, I've attached an Excel spreadsheet which lets you create and print your own.  There's a sample screenshot below. 8)

It's basically a simple sheet with a pie chart on it, with a graphic of a clock face under it. ;)

There is also a Big Green Arrow button, the purpose of which is to set each pie slice to the colour of the corresponding data cell.  Or in other words: change the items in the list on the sheet (make sure they add up to 60 minutes!), then give each cell in the Item column a Fill Colour, then click the Big Green Button and the pie chart slices will match those colours.

Obviously as it's just an Excel Chart object, you can easily change the fonts and font colours of the slices if you need to.

Note that you DO need to Enable Macros in Excel to use this.  I wrote it in Excel 2003 so I presume (?) it will work with later versions (I don't have any later versions here).  I have no plans to write an OpenOffice Calc equivalent, but if someone fancies having a go at that, I've attached the clock face graphic for you in the ZIPfile.

IMPORTANT: If you add any sheets to the workbook, or copy/move the sheet into another workbook, the code will probably break. :D  Clone the original file and save it with new file names if you need several different clockwheels.

Hope others find this useful; it was more of a 'techie exercise' for yours truly. ;D
--
BFN
CAD

tony wilding

  • Regular
  • *
  • Posts: 805
    • View Profile
Re: Clockwheel Maker for Excel
« Reply #1 on: February 24, 2011, 09:01:39 »
Hi Cad, seems to work OK in Calc (OpenOffice) fine.

Kind Regards Tony

*edit* btw the software for this is HotClock but its not free.

http://www.hotclock.com/
« Last Edit: February 24, 2011, 17:41:27 by tony wilding »
I'm Tony Wilding, thanks for listening...

shorty.xs

  • Regular
  • *
  • Posts: 1296
  • 6.0.8 Home / PRO mit mAirListDB Serv. PostgreSQL
    • View Profile
    • BM-Events, DJ Mobildisco für Bünde, Herford, Bielefeld
Re: Clockwheel Maker for Excel
« Reply #2 on: February 24, 2011, 10:48:25 »
I'm sure someone else here mentioned recently that they could not find any software to do this, but I can't find their post to reply to, so this is a new post.

That was me in the german section. http://forum.mairlist.com/index.php/topic,5030.0.html

Your tool is great! Thank you so much. I tried to put together something like that, but I didn't succeed yet.

Cheers
/Malte
Software macht nicht das was Du möchtest, nur das was Du einstellst.

Cad

  • Regular
  • *
  • Posts: 2260
  • 'Old school' radio guy (and PC programmer)
    • View Profile
Re: Clockwheel Maker for Excel
« Reply #3 on: February 24, 2011, 23:30:39 »
seems to work OK in Calc (OpenOffice) fine

Well it didn't work so well here.  It does load, ture: but the slice names didn't convert properly, and clicking the button causes a fairly immediate crash in OO Basic (not a surprise, since it's trying to run VBA).  I daresay that changing the data list contents will work, but that's about it.   No 'auto' colouring of the slices, which was really the whole point of the Excel version. :-\

Quote from: tony wilding
the software for this is HotClock but its not free.

I can see that HotClock does have a few extra features, true, but my version IS free; and I daresay you could paste the chart which mine produces into a Word (or maybe Writer?) document to add the headings, boxes, etc.
--
BFN
CAD

tony wilding

  • Regular
  • *
  • Posts: 805
    • View Profile
Re: Clockwheel Maker for Excel
« Reply #4 on: February 25, 2011, 09:01:46 »
Cad, just checked. Works for me in version 3 of OpenOffice. Slices adjust when you type in a new time into the box. The names also adjust if you change ads to stopset for instance. Though not been able to get the colours to change.

Kind Regards Tony
I'm Tony Wilding, thanks for listening...

shorty.xs

  • Regular
  • *
  • Posts: 1296
  • 6.0.8 Home / PRO mit mAirListDB Serv. PostgreSQL
    • View Profile
    • BM-Events, DJ Mobildisco für Bünde, Herford, Bielefeld
Re: Clockwheel Maker for Excel
« Reply #5 on: February 25, 2011, 09:09:43 »
Hey cad,
didn't you construct something that could read mAirList Playlists to modify them in Excel than write back?
It would be great if your clock tool could read Playlist files to print the clock.

Just an idea, but maybe not that easy.

Never the less your tool helps me a lot.
Regards
Malte
Software macht nicht das was Du möchtest, nur das was Du einstellst.

Cad

  • Regular
  • *
  • Posts: 2260
  • 'Old school' radio guy (and PC programmer)
    • View Profile
Re: Clockwheel Maker for Excel
« Reply #6 on: February 25, 2011, 15:32:43 »
Cad, just checked. Works for me in version 3 of OpenOffice. Slices adjust when you type in a new time into the box. The names also adjust if you change ads to stopset for instance. Though not been able to get the colours to change.

Exactly: changing the names, times, etc. should work in both Excel and OO.  BUT: look at the screenshot from Excel.  Excel shows the NAMES on the slices as well as the TIMES: OO does not, probably due to different capabilities/ways of specifying the slice labels.  And the main 'clever' part of it—changing the slice colours to match the cell colours by clicking a button on the sheet—does NOT work in OO: again, this is due to differences between the two products which i personally simply don't have time to fix in OO.
--
BFN
CAD

streamer

  • Regular
  • *
  • Posts: 400
    • View Profile
Re: Clockwheel Maker for Excel
« Reply #7 on: February 25, 2011, 15:58:22 »
Works well in Office 2007. In fact, it's dynamic, make a change and the clock follows. If I click the big green button I get an error.

Nice work and thanks
Cheers, Richard

tony wilding

  • Regular
  • *
  • Posts: 805
    • View Profile
Re: Clockwheel Maker for Excel
« Reply #8 on: February 25, 2011, 17:11:01 »
The only part not working for me is the slices changing colours in the pie chart. Changing the duration or name of a cell is reflected in the pie chart.

Edit: In OpenOffice. I do not use Office itself.
« Last Edit: February 25, 2011, 20:18:07 by tony wilding »
I'm Tony Wilding, thanks for listening...

streamer

  • Regular
  • *
  • Posts: 400
    • View Profile
Re: Clockwheel Maker for Excel
« Reply #9 on: February 25, 2011, 17:42:03 »
The only part not working for me is the slices changing colours in the pie chart. Changing the duration or name of a cell is reflected in the pie chart.



Same issue here and Office 2007 is being a proverbial PITA for macros. I have 2003 at home.
Cheers, Richard

Cad

  • Regular
  • *
  • Posts: 2260
  • 'Old school' radio guy (and PC programmer)
    • View Profile
Re: Clockwheel Maker for Excel
« Reply #10 on: February 26, 2011, 03:39:28 »
OK, I've done some research on the Excel 2007 issues reported here, and it seems that MS decided to integrate charting into OfficeArt (?!!) in 2007; there fore, most of the previously accessible-from-VBA features went down the toilet, including the ability to change the colour of a pie chart slice. >:(

You should (?) be able to manually change the slice colours.  Perhaps.  Dunno: I've never done charts in Excel 2007!  I haven't looked at how this (might?) work in Excel 2010.
--
BFN
CAD

streamer

  • Regular
  • *
  • Posts: 400
    • View Profile
Re: Clockwheel Maker for Excel
« Reply #11 on: May 16, 2012, 03:57:57 »
Resurrecting an old thread, I've written a ClockWheel utility called ClockMaker. Beta 1 is available at the link below. It's released for both Windows and Mac OS. Still some work to be done including tidying up the Windows version and also printing/displaying legends etc.

http://www.2ngradio.com/index.php?option=com_content&view=article&id=112&Itemid=79

Feedback and bug reports welcome. (email address on page).
Cheers, Richard

tony wilding

  • Regular
  • *
  • Posts: 805
    • View Profile
Re: Clockwheel Maker for Excel
« Reply #12 on: May 16, 2012, 09:21:02 »
Thanks Richard, also on the same site is mediamon. Useful app for monitoring an online stream which sends an email alert should the stream fail.

http://www.2ngradio.com/index.php?option=com_content&view=article&id=66&Itemid=79
I'm Tony Wilding, thanks for listening...

Cad

  • Regular
  • *
  • Posts: 2260
  • 'Old school' radio guy (and PC programmer)
    • View Profile
Re: Clockwheel Maker for Excel
« Reply #13 on: May 16, 2012, 14:27:16 »
>cough<  I think Richard knows about mediamon: he wrote it, and 2NG is his site and his station!

Unless you were merely meaning to give mediamon some publicity. ;D
--
BFN
Cad

tony wilding

  • Regular
  • *
  • Posts: 805
    • View Profile
Re: Clockwheel Maker for Excel
« Reply #14 on: May 16, 2012, 14:35:00 »
A heads up was the general idea.

Richard very supportive in making sure the software works for you and accepting new ideas.

>cough<  I think Richard knows about mediamon: he wrote it, and 2NG is his site and his station!

Unless you were merely meaning to give mediamon some publicity. ;D
--
BFN
Cad
I'm Tony Wilding, thanks for listening...