PDA

View Full Version : Sleeper: VBA Needed to extract from raw data and summarize employee data by project



aach2034
07-29-2011, 02:18 PM
Hello,
I have a large amount of data that I receive with timesheets each
week. I am currently using many, many vlookups and pivots to achieve
the results that I need. My goal is to get the resource data by hours and spend, by month and project. Please take a look and let me knowif you can help.

Bob Phillips
08-01-2011, 08:08 AM
I am struggling to see what you want here. You already have the first formula which seems fine, just carry on it that vein. How is variance calculated?

aach2034
08-01-2011, 09:38 AM
I 'm not concerned about the variance, however I need to calculate the data with an additional criteria of different projects under the projectinvestment column.

Bob Phillips
08-01-2011, 02:50 PM
Then don't you just change the value in G19?

aach2034
08-02-2011, 09:37 AM
I attached another file with the project codes. So for instance, I will need to have each resource, spend, month, and under project/investment, filter one bucket which consists of the following: IT Core Plan - Service Desk Incidents
IT Core Plan - Service Desk Problems
KTLO-E Content Management 2011 Q1 & Q2
KTLO-E Dev KTLO Non Production Environment Support Activities
KTLO-E Dev KTLO Service Desk Incidents
KTLO-E Dev KTLO Service Desk Problems

Bob Phillips
08-02-2011, 01:51 PM
You've lost me I am afraid.

aach2034
08-02-2011, 02:19 PM
I need to get the sum of each resources spend, by month, and project. A bucket may consist of several projects, as listed in the prior post.

For example:

Resource x Month X Project X Spend

Aussiebear
08-03-2011, 02:41 PM
once again we run into the same issue. There are now 116 unique entries in the Project Investment column. How do you plan to associate these with the expense buckets?