Need to itemize labor

Hello all- I am a lowly farmer trying to feed you all, and my excel skills are limited so be patient with me. My profession is composed of varying enterprises. Namely Potatoes, Grains, Forages, and Cattle. I created a table to more closely track the labor tied to each enterprise, and did a simple count function to add up all the days applied to each enterprise. I have them coded as P,G,F,C. At the end of each day I simply go down my list of employees and assign them a code pertaining to what the individual did for that day. My hangup is when someone for example works partly in potatoes, and then cattle on the same day. The code would need to be PC in this case, but I cannot differentiate between the time spent doing each job by the worker. Is there a way to do it? Help!!

I can build a quick example of what I want to do....but where do I upload?

My only thoughts on this would be if you could create an additional cells with the part days, such as (PG, PF, PC, GF, GC, FC) and then if necessary, even create a 3 part variable too with PGF, PGC, etc.

If that isn't what you're referring to, and you are needing to track actual hours, then I recommend the =sum(B1:B4) with A1:A4 being your categories. This way you could put "6" on P and 6 on C and then total it at the bottom for that employee.

Emp 1 Emp 2 Emp 3
P 4
G
F
C 4
=sum(B2:B6) =sum(C2:C6) =sum(C2:C6)
Hours Hours Hours

Originally Posted by Richard Buttrey

I've seen some references to users with a low post count not being able to upload until they'd reached a certain number. Must admit I wasn;t aware of that so need to check. However try clicking the Go Advanced button at the bottom rightb of a poset then immeditely under the posting window pick Manage attachments and take it from there.

This may be my problem too Richard. Do you know what the threshold is for posts? I dont think a file was uploaded for me on my own post.

Hi,

Edit your OP, or enter a new Reply, Lower right corner, "Go Advanced", scroll down, "Manage attachments", browse for your file to be uploaded, "upload", close the Manage attachments window, submit.

Thanks Jtakw, I figured out why on my post it wasn't working. didnt see the "upload" button under the URL choice

It’s on the Dec 18 tab

Originally Posted by Richard Buttrey

I can't help thinking that collecting the data in a normalised table of data and using a Pivot Table to analyse it is simpler and more efficient

On the Attached I've added a Data sheet. Enter new records in the 3 cells on row 3, two are drop downs for you to pick a name and entreprise then click the button to add to the database.

When you go to the Pivot Table sheet it will automatically refresh with the new data. Use the Slicers to filter as necessary.

Note it doesn't deal with the combined enterprise split mentioned in my earlier posts.

That looks really good Richard. I can see the answer being rooted in the VBA, but is there a non-coding answer to this? how do you employ the pivot chart without the code?

Here is my interpretation without the VBA coding. I imagine you have a much larger spreadsheet to work out of and it could potentially be undaunting trying to decipher the answers. please let me know if i can explain anything of what i created