Using Podio to calculate hours worked by the team.

Comments

7 comments

  • nealpatil

    Hi Hitesh,

    I would like to understand details of  output of your report.

    If Worker Joe works 8 hours a day, 5 days in a week (M-F) for whole month of Aug-2016 then what would your report look like related with

    Daily , name, hrs spent. Weekly, Name, hrs spent, bi weekly, Name, Hrs Spent. Monthly, Name, Hrs Spent ?

    Thanks,

    Neal

    NealPatil @ gmx.com

    1
    Comment actions Permalink
  • Hitesh Daudia

    Hi Neal,

    The details is to see if someone in the team is off sick I would be able to see at a glace how many hours they worked.

    Daily Hours Joe 8 hrs

    Weekly Hours Joe 40 hrs

    Bi Weekly Hours Joe 80 hrs

    Monthly Hours Joe 184 hrs (4 weeks & 3 days).

    Thanks

     

    0
    Comment actions Permalink
  • Rainer Grabowski

    Hi Hitesh,

    is: 
    daily hrs = hrs worked today or yesterday or an average of x days
    weekly hrs = for current calendar week only or current week and all previous week
    biweekly =  current week plus last week or last week plus lust but one week
    monthly = current month
    ?

    Do your team members enter their worked hours every day in a new timesheet for this day? Is this timesheet linked (via a relationship field) to a team member app item and/or to a project app item? 

    Rainer

    0
    Comment actions Permalink
  • Hitesh Daudia

    Hi Rainer,

    Daily hours is the hours worked today.

    Weekly hours= current week.

    Bi weekly = 1st-14th of the month, then the next 2 weeks.

    Monthly= current month.

    Yes team members log their hours worked in a timesheet for each day. The timesheet is not linked by a relationship field or project item.

    Thanks

    Hitesh

    0
    Comment actions Permalink
  • Rainer Grabowski

    Without a relationship you can't do what you want to achieve (or you have to develop a process via the API).

    I would recommend to create a team memebr app with items for each member. Then add a realtionship field in your timesheet app which points to the team member app. I would also add a relationship field to the project app. When the team members log their hours they select their name in team-relationship field and the procjet they worked for in the project-relationship field. In both apps (Team member and Projects) you then can count whatever you want in calculation fields which pull the data from the timesheets.

    If you would create another app "Team dashboard" with one item only and link this item to each team member (via a relationship field in the Team member App) you can create in this dasboard item a table like this:

    Name | Today | week | bi-weekly | month | to pay this week
    Joe    |    8      |  20   |    60          |   70    |   $60 
    Jim    |    8      |  24   |    70          |   80    |   $72

    Rainer 

    0
    Comment actions Permalink
  • nealpatil

    Thanks Hitesh !

     

    Neal

    NealPatil @ gmx.com

     

    0
    Comment actions Permalink
  • nealpatil

    Hi Hitesh,

    I have prepared two data sets for user=demo2 and user=user1.

    Daily, Weekly, Biweekly and Monthly totals can be used to pay the worker.

    CurrentDaily, CurrentWeekly, CurrentBiweekly and CurrentMonthly totals are the numbers you wanted in daily report.

    Please provide feedback regarding two different summary data and correct Totals.

    I have used decimal numbers for hours for testing quality of summary-totals.

    Thanks,

    Neal

    NealPatil @ gmx.com

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk