• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Clock chart

R

reynoldsohio

New Member
Greetings,

I'm looking for something at already exists or how it can be made. I'd like to have a CLOCK chart that looks like a DONUT chart that overlaps to depict the various work periods of different members of my department. Can anyone assist? thx david
 
Hi Reynolds ,


Have you taken a look at this ? It may not be exactly what you want , but it may help.


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


Narayan
 
Thanks Narayan,

this looks like a normal pie chart (wedges). I'm looking to build something like a donut/ring chart with overlapping segments to depict overlapping workers shifts for each day of the schedule.


appreciate your feedback. open to more guidance.


David
 
Hi David,


Just Google this topic "Donuts chart for shift" and suggest a diagram that could explain the end result, or perhaps upload a sample file.


Regards,
 
@David... I think using a clock metaphor for this will make it hard to read for below reasons:

  • Clocks contain only 12 hours, where as a day contains 24
    Once you add more than a few members the chart looks very busy

That said, it is an interesting idea. So I made a small example.


http://img.chandoo.org/playground/shift-allocation-clock-chart.xlsx


You can see clock chart as well as suggested alternative (a stacked bar chart that looks like a gantt chart).
 
Very nice Chandoo. I agree with the idea of a stacked bar chart. Let's you very easily see when employees were working.
 
@Chandoo

Hi!

So you have series of two clocks at home & work, with one of each pair shifted 12 hours? Or are they sand clocks? If further information needed, please give a look at this:

http://en.wikipedia.org/wiki/24-hour_clock

Regards!
 
Chandoo,

thanks for the feedback. Nobody works more than 1 lap (12 hours) and therefore could still use a clock format. I want to use a clock image because that's what most people visualize when you talk about time and work schedules. I'm playing with the sample you provided to see if I can understand how it works.


I'm still looking for something that works with my original concept. I wish I could attached the spreadsheet with my sample data and a drawn image of my concept clock.


Thanks for any additional feedback/guidance.

David
 
Hi David ,


Can you say how many people would need to be monitored ? Would the time periods be regular or would they be arbitrarily sized periods ? What I mean is would the entire 12 hour period be divided into sections of 30 minutes each or 15 minutes each , or would the periods be irregular e.g. 9:10 to 10:25 , 9:40 to 10:15 etc. ?


Narayan
 
Narayan,

Currently 6-8 people on random (flex) shift work in half hour increments. 0800-2330 hours is the max window that I've seen over the past few months. Most days may only have 3-4 shift workers overlapping by a half hour (one opens and the other one closes the facility). I'm just wanting to build a better SCHEDULE tool, the office time clock/sheets calculate the actual time worked for pay purposes.

thx

david

reynoldsohio[at]aol[dot]com


https://www.dropbox.com/s/k9ic2echfckkxnu/sample%20work%20schedule%20with%20clock.xlsx
 
You must log in or register to reply here.
Back
Top