| View previous topic :: View next topic |
| Author |
Message |
Dooper
Newbie
Joined: 03 Mar 2011
Posts: 4
|
 Posted: Thu Mar 03, 2011 4:12 am Post subject: Clues please newbie simple(?)pivotal table creation..? |
 |
|
Hello..
I am a newbie to Excel/office calc and i want to do something which i think is probably pretty simply for those in the know !
What i am doing is using calc to organise work/shift patterns over a period of time.
So far i have created the following...
SHEET1
A matrix with a column consisting of cells A2-A25 containing employees names
A row B1-AC1 containing Week commencing dates and in cells B2-AC25 inclusive I have tabulated the names given to the various shift patterns eg shift A1/B1/C3 etc...obviously the names are not important.
SHEET2
A matrix with a column consisting of cells A2-A16 containing the name tags of the 15 different shift patters.
A row of cells B1-H1 each having the days of the week starting sunday
And the cells B2-H16 containing the individual hours to be worked on that day for that shift eg 0800-1700
What i would like to do is easily create an individual sheet for each employee showing week commencing dates in the first column and days of the week in the top row and the cells containing the hours worked on each individual day for that shift pattern..the data to be extracted from the two sheets 1 and two detailed above.
Is that a tall order or can it be automated..?
I'm sure it has something to do with data pilot/pivotal tables but im on the bottom of the learning curve with this and only a basic manual to consult..
Any clues very welcome
Thanks
jo |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
|
| Back to top |
|
|
Dooper
Newbie
Joined: 03 Mar 2011
Posts: 4
|
| Posted: Thu Mar 03, 2011 6:48 am Post subject: |
|
|
| Hmmm..maybe datapilot is what is needed since that seems concerned with producing SUM type data whereas mine is a layout kind of task....? |
|
| Back to top |
|
|
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1875
Location: Sydney, Australia
|
| Posted: Thu Mar 03, 2011 5:32 pm Post subject: |
|
|
Layout can be controlled with very complex formulae such as here (Another roster.ods)...
http://www.mediafire.com/view/?02t14uvb99x9743
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Last edited by ken johnson on Tue Oct 09, 2012 6:02 am; edited 1 time in total |
|
| Back to top |
|
|
Dooper
Newbie
Joined: 03 Mar 2011
Posts: 4
|
| Posted: Fri Mar 04, 2011 11:19 am Post subject: |
|
|
Hey Ken..thats great,,just what I'm looking for !!
Not quite sure about the instructions on the "emloyer" sheet as to how to make a new sheet for another employer..any chance of writing it in newbie frormat?
ta
jo |
|
| Back to top |
|
|
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1875
Location: Sydney, Australia
|
| Posted: Fri Mar 04, 2011 6:44 pm Post subject: |
|
|
Try this Writer doc (New Employee Sheet Step by Step.odt)...
http://www.mediafire.com/view/?l11kn21o31wr69n
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Last edited by ken johnson on Tue Oct 09, 2012 6:09 am; edited 1 time in total |
|
| Back to top |
|
|
Dooper
Newbie
Joined: 03 Mar 2011
Posts: 4
|
| Posted: Sun Mar 06, 2011 12:01 am Post subject: |
|
|
| Thanks Ken... |
|
| Back to top |
|
|
|
