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?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.