Page 1 of 1
Help making a exel sheet? for...
Posted: October 30th, 2006, 17:57
by northwesten
Hey guys i was woundering can someone make a sheet with 5 culums. This for Dutie list and its annoying to rewright them everytime we change it so i was wounding having it done on exel instead. This how i like it
Date / Days / Lates duty / Charger duty / Trumpet duty /
and 31 space downwords and a colum on a side to put name in and then when it comes to doing the list all i have to do click on the late or chargers colum etc and select name! U know what i mean?
So if u know what i mean could someone do it for me? i dont have a clue on how to do it!
thxs
Posted: October 30th, 2006, 19:14
by Lateralus
Do you mean a grid/template with 31 names printed down the side so you can then just put ticks in the boxes for who is doing which duty?
Or how about 31 names down the side, days/dates at the top and then just write in the duty in the relevant box?
If thats not it then I give up. I'm afraid I've read your post several times, but now my brain hurts and I need to lie down for a bit.
Re: Help making a exel sheet? for...
Posted: October 30th, 2006, 19:23
by Fear
Peter Armstrong wrote:Hey guys!
I was wondering can someone make me a spreadsheet with 5 columns. This is for a duty list and it's annoying to re-write them from scratch everytime they need changing. I was thinking about using Excel to achieve this. This how I'd like it:
<strike>From behind / </strike>Date / Days / Late duty / Charger duty / Trumpet duty /
and 31 rows and a column on the side to put names in. That way when it comes to doing the list all I need do is click on the late or chargers etc and select name! U know what I mean?
So if u know what I mean could someone do it for me? I don't know where to start.
Mucho gracias.
I think somebody translated something for me in the past so just repaying the favour... :-)
If you use something like Outlook this would be better suited as you could just merge each others calendars and Bob's your cross dressing grandmother. Excel would also do it. There are no formulas involved so can't you just type in the cells the names and the column titles etc?
Posted: October 30th, 2006, 22:41
by northwesten
Lateralus wrote:Do you mean a grid/template with 31 names printed down the side so you can then just put ticks in the boxes for who is doing which duty?
Or how about 31 names down the side, days/dates at the top and then just write in the duty in the relevant box?
If thats not it then I give up. I'm afraid I've read your post several times, but now my brain hurts and I need to lie down for a bit.
i copy a list we have atm 2moro and isorry my gramma suck bad egg!
Posted: October 31st, 2006, 8:41
by Woo Elephant Yeah
I'll do this for you later on today
Re: Help making a exel sheet? for...
Posted: November 8th, 2006, 22:13
by webclam
Peter Armstrong wrote:Hey guys i was woundering can someone make a sheet with 5 culums. This for Dutie list and its annoying to rewright them everytime we change it so i was wounding having it done on exel instead. This how i like it
Date / Days / Lates duty / Charger duty / Trumpet duty /
and 31 space downwords and a colum on a side to put name in and then when it comes to doing the list all i have to do click on the late or chargers colum etc and select name! U know what i mean?
So if u know what i mean could someone do it for me? i dont have a clue on how to do it!
thxs
given I spend all day on excel I can do this anytime you like.
even better, I can do it in google spreadsheets and you can share it live on line
Posted: November 9th, 2006, 11:52
by Woo Elephant Yeah
Woo Elephant Yeah wrote:I'll do this for you later on today
As most people know, my "later on"' can sometimes mean never, due to forgetting and moving onto other things.
Sorry I forgot to do this for you, but Lateralus idea looks a lot better anyway, as Google spreadsheets makes sense, so you can view the changes/file online
Posted: November 9th, 2006, 12:30
by webclam
ok, I have one partially built, but it's got excel-specific functionality that won't work in googlespreadsheets, sadly.
Do you have an email you'd like it sent to?
also, do you want it to automagically calculate the numbers of days/shifts each person has had assigned? (this will take longer to do, but with an array and some other formula, it's possible)
let me know.
Posted: November 9th, 2006, 12:38
by friznit
Posted: November 9th, 2006, 12:57
by webclam
ok, got a nice finished version available, but can't find where to put it.
Putfile seems to only take videos.
I can bung it on my ISP when I get home, or MSN groups now.
Try this:
http://uk.msnusers.com/webclamb3ta/Docu ... 20rota.xls
it might work. Hopefully
Posted: November 9th, 2006, 13:34
by fabyak
Now who did that then? Did someone Ambl
ine over it?
Posted: November 9th, 2006, 14:41
by friznit
Yeah, and if I ever find out who it was he's gonna need an Amb
linulance
Running low on pun fuel
Posted: November 9th, 2006, 14:53
by fabyak
friznit wrote:Yeah, and if I ever find out who it was he's gonna need an Amb
linulance
Running low on pun fuel
What's that I hear? It sounds like A
mblin pun barrel being scraped
Posted: November 9th, 2006, 14:58
by webclam
buggerit, I spent (minutes) Hours working on that excel sheet, and all you lot can do is start amblin pun competition
Posted: November 9th, 2006, 15:00
by fabyak
webclam wrote:buggerit, I spent (minutes) Hours working on that excel sheet, and all you lot can do is start amblin pun competition
Terribly sorry
Have an <strike>Amblins</strike> Terrys Chocolate Orange by way of apology
/tenuous
Posted: November 10th, 2006, 0:06
by Woo Elephant Yeah
webclam wrote:ok, got a nice finished version available, but can't find where to put it.
http://www.5punk.co.uk/uploads/
Posted: November 10th, 2006, 8:17
by webclam
...aaaaand done! Thanks WEY
Spreadsheet of Excell-entness
critique accepted
