4 Replies Latest reply: Jul 30, 2012 8:23 AM by Jean-Paul Camelbeek RSS

    Consildating Table Data

      Hi All

       

      I need some help consolidating some data that is being loaded from an excel spreadsheet.

       

      The spreadsheet contains peoples time logging activitives.

       

      an example of the spreadsheet looks like:

       

       

      NameDateTask NameHours
      JP11/07/2012Process Project 16
      JP11/07/2012Process Project 21
      JP11/07/2012OOO1
      JP12/07/2012Process Project 14
      JP12/07/2012Process Project 23
      JP12/072012Admin2

       

      fields in the script are:

       

      Name

      Date

      Task

      TimeSpent

       

      The issue I need to solve is to be able to draw a graph of FTE equivalent for each project.

       

      So the formula should be for any specific task on any day: time spent on task / total time logged for the day, which will give me the portion of time someone spent on the particular task for the day.

       

      So I was thinking I would create a new table linked on name and date that looks like below

       

      Name

      Date

      TotalTimeLoggedForDay

       

      NameDateTotalTimeLogged
      JP11/07/20128
      JP12/07/20129

       

      If anyone can explain how I would create the new table from the existing table to produce a result as described above that would be much appreciated.

      Thanks

      JP