|
16-09-2008, 12:19
|
#1 |
|
Absinthe
Join Date: Jan 2007
Location: Chester
Posts: 2,345
|
How might I create a 4 week rota?
Afternoon,
I've got this rota that rotates on a 4 week basis - rota To make life easy i'd love to get it to automate throughout the year as to who is doing each day every week. I'm sure Excel could do this, but i've got no idea how. Any ideas? |
|
|
|
16-09-2008, 13:09
|
#2 |
|
The Stig
Join Date: Jul 2006
Location: Fightertown USA
Posts: 1,458
|
If you've got a date in A1 then =MOD(INT((A1+5)/7),4) will return a number from 0 to 3 corresponding to a week number within your rota. Allocating tasks based on a combination of this number and the weekday should then be pretty straightforward.
__________________
    |
|
|
|
|
16-09-2008, 13:25
|
#3 |
|
Absinthe
Join Date: Jan 2007
Location: Chester
Posts: 2,345
|
its been too long since i used excel 'properly'... used to make animations on graphs of perspective change n stuff, but now thats got me stumped... going to have to have a play around...
|
|
|
|
|
16-09-2008, 13:41
|
#4 |
|
The Stig
Join Date: Jul 2006
Location: Fightertown USA
Posts: 1,458
|
I'd probably have a second sheet with a copy of the 4 week rota on it then do lookups on that table on the live sheet. Will make changing the rota down the line easy too that way.
If I was at work I'd do the whole thing just to look busy but I'm not 
__________________
|
|
|
|
|
16-09-2008, 18:28
|
#5 |
|
Columbian Coffee
Join Date: Nov 2007
Location: Glesgae
Posts: 98
|
Recurring appointments in outlook? Then print it off in natty little calendar format?
__________________
You have come here because society has no further use for you. This place will now become your holding pen until our death. I am very good at this business because I make all the rules. But if you break any of my rules, you will find that there is life after death. |
|
|
|
|
16-09-2008, 19:14
|
#6 |
|
Absinthe
Join Date: Jan 2007
Location: Chester
Posts: 2,345
|
yeah i was about to do it in outlook but then it kept moaning about connecting to the exchange server and i've not got it setup.
its always nice to use excel though, exercise the brain and get a bit creative at the same time. |
|
|
|
|
18-09-2008, 11:39
|
#7 | |
|
Absinthe
Join Date: Jan 2007
Location: Chester
Posts: 2,345
|
Quote:
when it comes to allocating each day, is there a simpler method than a massive if statement? |
|
|
|
|
|
18-09-2008, 18:42
|
#8 |
|
Dubious
Join Date: Sep 2008
Location: Northampton
Posts: 1,571
|
I've also found this site better for getting serious replies
__________________
Look at your signature, now back to mine, now back to yours, now back to mine.
Sadly, yours isn't mine. But if you stopped writing about other things and made this your signature, yours could be like mine. Look down, back up. Where are you? You're on Boat Drinks, reading the signature your signature could be like. I'm on a computer. |
|
|
|
|
19-09-2008, 16:33
|
#9 | |
|
Absinthe
Join Date: Jan 2007
Location: Chester
Posts: 2,345
|
Quote:
|
|
|
|
|
|
20-09-2008, 00:40
|
#10 |
|
Dubious
Join Date: Sep 2008
Location: Northampton
Posts: 1,571
|
Thanks
__________________
Look at your signature, now back to mine, now back to yours, now back to mine.
Sadly, yours isn't mine. But if you stopped writing about other things and made this your signature, yours could be like mine. Look down, back up. Where are you? You're on Boat Drinks, reading the signature your signature could be like. I'm on a computer. |
|
|
|
Linear Mode
