Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Eng-Tips
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

REDesigner09 (Aerospace)
7 Jul 11 14:14
Hi,

  I have multiple tables, all basically providing the same metrics, other than the person(s) assigned.

  I would like to chart this some how, extracting data from these multiple tables.  How can this be done in a "clean format"?

Thanks
 
MintJulep (Mechanical)
7 Jul 11 14:17
Combine the tables into a single table with a normalized structure.
REDesigner09 (Aerospace)
7 Jul 11 16:08
Hi MintJulep,

  This would be ideal, but I am extracting multiple data as follows:

I'm trying to track a dozen workers delivery statuses or Turn Around Time (TAT) on a week-to-week &/or month-to-month basis & determine if individuals are delivering "on-time", "late" or may be over-loaded with work.

My main criteria or parameters to track are:

Individuals - 12 - 15
Duration - Weekly &/or monthly
Task Deliverable status - "On-time", "Late" & perhaps, some others, but I'll keep it to these to begin with

Once defined, be able to chart it, which I should be able to do. This information will be extracted from a log sheet that I already created.

My issue is that I can define 2 parameters well, but struggling to get in the 3rd parameter into a "clean" table format & then be able to chart these results. Additionally, I would like to have all this defined simultaneously both in some type of table format & in a chart.


  In my data table, it's extracting data from my log worksheet, seeking:

Date Range Specified
Individuals
TAT Status - On-Time, Late, etc.

Just curious if anyone out here was trying or did something similar & how they defined or created their spreadsheets & charts. Examples would be appreciative.

  I attached an example file in which I have a chart started on the "Weekly Metrics" worksheet.

  If you have other suggestions to condense these tables &/or charts, feel free to do so.

Thanks
 
KiwiMace (Mechanical)
8 Jul 11 15:56
If you do this to your supervisors, i'd hate to see how you treat your grunts.  Why not whip one of your people into manually compiling it for you?

But we uphold to help the capitalists too, so I ask: You are using a scatter plot right?  Scatter plot should readily accept blocks of data like this, and the format seems standardised enough.
REDesigner09 (Aerospace)
8 Jul 11 18:22
Hi KiwiMace,

  This is not intended to be a scatter plot, other than trying to capture the percentages.

  I have the table format that I want to collect the data.  Now, I'm just trying to figure out on how to chart this, preferably on run-type chart or a chart that I don't have to update every week.

Any suggestions anyone?
chemebabak (Chemical)
19 Jul 11 16:53

http://www.youtube.com/watch?v=CuhQ9lSMmjg
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.timeatlas.com/5_minute_tips/chunkers/learn_to_use_pivot_tables_in_excel_2007_to_organize_data

REDesigner09, you need to do some research on pivot tables.  For data with multiple fields, pivot tables can make sense of it all.  Otherwise follow KiwiMace's suggestion to "whip one of your people into manually compiling it for you".

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close