Hi all,
I'm looking for a solution to a problem with Calc similar to many
requests I read googling around.
Here the question:
I have an activity by month table and I want to write in every row the
hours employed by some people on that job.
I need a way to get a quick look to the entire table so I can visually
realize the people/day assignments and redistribute the next activities.
There are only few peoples, so I assign a color to everyone and set a
background color for the day that person made the job.
Example (only 9 days for briefness):
Anna: red
Marco: green
Laura: yellow
I need to have as a result the sums based on the background color:
Day
1
2
3
4
5
6
7
8
9
Anna
Marco
Laura
Jan
4
8
6
4
7
6
8
4
6
19
14
20
Feb
6
6
8
5
7
5
6
8
6
21
17
19
Mar
5
6
8
6
7
5
6
7
6
18
16
22
Any hint please?
Thank you all.
Franco
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
