OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Clues please newbie simple(?)pivotal table creation..?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Dooper
Newbie
Newbie


Joined: 03 Mar 2011
Posts: 4

PostPosted: Thu Mar 03, 2011 4:12 am    Post subject: Clues please newbie simple(?)pivotal table creation..? Reply with quote

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
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Thu Mar 03, 2011 4:45 am    Post subject: Reply with quote

http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/DataPilot
http://user.services.openoffice.org/en/forum/download/file.php?id=8592
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Dooper
Newbie
Newbie


Joined: 03 Mar 2011
Posts: 4

PostPosted: Thu Mar 03, 2011 6:48 am    Post subject: Reply with quote

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
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Thu Mar 03, 2011 5:32 pm    Post subject: Reply with quote

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
View user's profile Send private message
Dooper
Newbie
Newbie


Joined: 03 Mar 2011
Posts: 4

PostPosted: Fri Mar 04, 2011 11:19 am    Post subject: Reply with quote

ken johnson wrote:
Layout can be controlled with very complex formulae such as here...
http://www.4shared.com/file/sl93HDLq/Another_roster.html
Ken Johnson


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
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Fri Mar 04, 2011 6:44 pm    Post subject: Reply with quote

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
View user's profile Send private message
Dooper
Newbie
Newbie


Joined: 03 Mar 2011
Posts: 4

PostPosted: Sun Mar 06, 2011 12:01 am    Post subject: Reply with quote

Thanks Ken...
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group