Base on raw data prepare graph with following

Q.Base on raw data prepare graph with following
a. Production
b. Target
c. Utilization
d. Mandate FTE



Raw Date:

Emplye Process Month Prodtn QC Error
Emp1 ABCDE April-13 368 20 1
Emp11 ABCDE April-13 350 20 0
Emp12 EFGHI April-13 524 20 0
Emp13 JKLM April-13 236 20 0
Emp16 ABCDE April-13 398 20 0
Emp17 EFGHI April-13 536 20 0
Emp18 JKLM April-13 256 20 0
Emp2 EFGHI April-13 589 20 5
Emp21 ABCDE April-13 412 20 0
Emp22 EFGHI April-13 523 20 0
Emp23 JKLM April-13 245 20 0
Emp26 ABCDE April-13 433 20 0
Emp27 EFGHI April-13 512 20 0
Emp28 JKLM April-13 366 20 0
Emp3 JKLM April-13 254 20 0
Emp31 ABCDE April-13 369 20 0
Emp36 ABCDE April-13 356 20 0
Emp41 ABCDE April-13 425 20 1
Emp46 ABCDE April-13 356 20 2
Emp51 ABCDE April-13 425 20 2
Emp56 ABCDE April-13 350 20 2
Emp6 ABCDE April-13 425 20 2
Emp7 EFGHI April-13 526 20 5
Emp8 JKLM April-13 369 20 0
Emp1 ABCDE May-13 331 20 0
Emp11 ABCDE May-13 315 20 0
Emp12 EFGHI May-13 524 20 1
Emp13 JKLM May-13 266 20 0
Emp16 ABCDE May-13 358 20 0
Emp17 EFGHI May-13 536 20 1
Emp18 JKLM May-13 213 20 1
Emp2 EFGHI May-13 589 20 2
Emp21 ABCDE May-13 371 20 3
Emp22 EFGHI May-13 523 20 1
Emp23 JKLM May-13 256 20 1
Emp26 ABCDE May-13 390 20 0
Emp27 EFGHI May-13 512 20 1
Emp28 JKLM May-13 296 20 1
Emp3 JKLM May-13 256 20 1
Emp31 ABCDE May-13 332 20 1
Emp36 ABCDE May-13 320 20 2
Emp41 ABCDE May-13 383 20 2
Emp46 ABCDE May-13 320 20 2
Emp51 ABCDE May-13 383 20 2
Emp56 ABCDE May-13 315 20 2
Emp6 ABCDE May-13 383 20 0
Emp7 EFGHI May-13 526 20 1
Emp8 JKLM May-13 287 20 1
Emp1 ABCDE June-13 298 20 1
Emp11 ABCDE June-13 284 20 1
Emp12 EFGHI June-13 524 20 0
Emp13 JKLM June-13 348 20 0
Emp16 ABCDE June-13 322 20 1
Emp17 EFGHI June-13 536 20 0
Emp18 JKLM June-13 365 20 0
Emp2 EFGHI June-13 589 20 0
Emp21 ABCDE June-13 334 20 1
Emp22 EFGHI June-13 523 20 0
Emp23 JKLM June-13 369 20 0
Emp26 ABCDE June-13 351 20 1
Emp27 EFGHI June-13 512 20 0
Emp28 JKLM June-13 456 20 0
Emp3 JKLM June-13 359 20 0
Emp31 ABCDE June-13 299 20 1
Emp36 ABCDE June-13 288 20 0
Emp41 ABCDE June-13 344 20 0
Emp46 ABCDE June-13 288 20 0
Emp51 ABCDE June-13 344 20 0
Emp56 ABCDE June-13 284 20 0
Emp6 ABCDE June-13 344 20 1
Emp7 EFGHI June-13 526 20 0
Emp8 JKLM June-13 365 20 0

Hi Ram

Perhaps if you could get all that data into a spreadsheet and label it properly, we'd be better able to figure out just what you want.

HTH

Tony

Okay Tony. thanks here is the attachement.
Please assist me.

THanks!

YOu mention that you want to graph

b. Target
c. Utilization
d. Mandate FTE

and yet I don't see any numbers that immediately call these metrics to mind. Would you let us know how you calculate them?

THanks,

TOny

Hi Tony,

The attached excel sheet is the raw data, I just want to know how to calculate and find out the Production,Target,Utilisation, mandate FTE as I myself dont know the formula, Please use Pivot table in case it is required.

Hi Ram

THe people to ask are your clients/customers! Show them the data you have, and ask them to explain how they would derive these various figures. AFAIAA there is no 'standard' formula for the values you are seeking.

Iterative analysis and refinement of requirements is still much easier than fixing bad code after it has been released

Tony

Okay Tony. Thanks a lot.