Uploaded image for project: 'ONE'
  1. ONE
  2. ONE-7558

Exporting to Excel in Resources module contains tasks with workload

    XMLWordPrintable

Details

    • Resources
    • BigPicture
    • JIRA server, JIRA cloud
    • 54
    • 54
    • Hide
      TBC: Czy można by robić export we wskazanym przez użytkownika okresie czasu?
      Task workload tab: https://docs.google.com/spreadsheets/d/1fPCjDSssdR4qu1IVT0Guh4fDBU2vVHQRMkTvrhRpxBA/edit#gid=653050514
      Show
      TBC: Czy można by robić export we wskazanym przez użytkownika okresie czasu? Task workload tab: https://docs.google.com/spreadsheets/d/1fPCjDSssdR4qu1IVT0Guh4fDBU2vVHQRMkTvrhRpxBA/edit#gid=653050514
    • $i18n.getText("admin.common.words.hide")
      $i18n.getText("admin.common.words.show")
      var cfToHide1 = document.getElementById("rowForcustomfield_18501"); if(cfToHide1){cfToHide1.style.display="none";} var cfToHide2 = document.getElementById("rowForcustomfield_18502"); if(cfToHide2){cfToHide2.style.display="none";} var cfToHide3 = document.getElementById("rowForcustomfield_19700"); if(cfToHide3){cfToHide3.style.display="none";} var cfToHide4 = document.getElementById("rowForcustomfield_18400"); if(cfToHide4){cfToHide4.style.display="none";}
    • Business
    • Possibility to show e.g. comparison between original estimate and remaining estimate by generating a report with tasks workload in a defined period.
    • Sprint 2022/14, Sprint 2022/15, Sprint 2022/16 SIW, Sprint 2022/17, Sprint 2022/18, Sprint 2022/19, Sprint 2022/20
    • PI2022/04
    • 0
    • No
    • Important
    • Done
    • 148 weeks, 4 hours, 57 minutes, 10 seconds
    • 2 weeks, 2 days, 17 hours, 22 minutes, 27 seconds
    • 3 weeks, 1 day, 13 hours, 8 minutes, 53 seconds
    • 2 weeks, 15 hours, 19 minutes, 9 seconds
    • 1 minute, 46 seconds
    • 16 seconds
    • 6 weeks, 5 days, 57 minutes, 12 seconds
    • $i18n.getText("admin.common.words.hide")
      $i18n.getText("admin.common.words.show")
      var cfToHide1 = document.getElementById("rowForcustomfield_21302"); if(cfToHide1){cfToHide1.style.display="none";} var cfToHide2 = document.getElementById("rowForcustomfield_19201"); if(cfToHide2){cfToHide2.style.display="none";} var cfToHide3 = document.getElementById("rowForcustomfield_19300"); if(cfToHide3){cfToHide3.style.display="none";} var cfToHide4 = document.getElementById("rowForcustomfield_19301"); if(cfToHide4){cfToHide4.style.display="none";} var cfToHide5 = document.getElementById("rowForcustomfield_19302"); if(cfToHide5){cfToHide5.style.display="none";} var cfToHide6 = document.getElementById("rowForcustomfield_19303"); if(cfToHide6){cfToHide6.style.display="none";} var cfToHide7 = document.getElementById("rowForcustomfield_19204"); if(cfToHide7){cfToHide7.style.display="none";} var cfToHide8 = document.getElementById("rowForcustomfield_19205"); if(cfToHide8){cfToHide8.style.display="none";}

    Description

      Goal: Possibility to show e.g. comparison between original estimate and remaining estimate by generating a report with tasks workload in a defined period. 

      Before change:

      Export to Excel on Resources module only contains Workload, Capacity and Remaining capacity for each Resource (or Skill) in a given day.

      There is no possibility to download an excel file with detailed information about daily workload (or weekly / monthly) of each issue in the box.

      On the Resources module it is only possible to see the total daily workload per each swimlane (Individual or Teams) and total per whole box.

      After change:

      Export to Excel on Resources module contains Workload, Capacity and Remaining capacity for each Resource (or Skill) in a given day.
      In addition, there is information about tasks assigned to Resources and their duration, workload contour in a given day.

      User can download an excel file with detailed information about daily workload (or weekly/ monthly) of each issue in the box.

      • each issue has a Summary and Key visible
      • each issues has a daily value of workload contour taken from the Resources module

       

      Possible solution:

      A.C.

      • tasks workload tab in the exported file contains columns in the order: TaskKey,TaskSummary, Assignee 
      • tasks order is the same as on the resources grid: Unassigned on the top and then alphabetic order by assignee
      • Assignee in assignee column is visible in every row (next to each task)
      • if task has no assignee the 'Unassigned' appears next to the task in the row Assignee
      • columns with dates has the width adjusted, so the dates fit to them
      • summary row is separated from detailed tasks workload data

       

       

      ---------------------------------

      One of the reports that would be really valuable is a report of estimated hours, actual hrs, remaining hrs and forecasted final estimate.

      (...) project into the future to project where the project may end up. This will provide useful information and it means that we can be more proactive to get a project back on track.

       

      On Resources module - for each assignee, how can I export original estimate of all issues in detail per day? I would like to create bar chart to compare between original estimate and actual time spent of each assignee for a certain period of time - week, month, etc.

      I would like to export the resource tab of the bigpicture to a excel sheet including the separate tasks and capacities.

      We need export with assignees, tasks and assigned hours per day on specific day for that task for a assignee. How can we do that?

      Support helper

        Attachments

          Issue Links

            People

              kamil.koszarny Kamil Koszarny
              mateusz.wyzinski Mateusz Wyzinski
              Natalia Ciura Natalia Ciura
              system.jenkins Jenkins , natalia.ciura Natalia Ciura , monika.cecot Monika Cecot , kamila.kornatko Kamila Kornatko , system.gerrit Gerrit , kamil.koszarny Kamil Koszarny , bartosz.drazewski Bartosz Drążewski , maciej.glownia Maciej Głownia , robert.lichman Robert Lichman , magdalena.dereszewska Magdalena Dereszewska , patryk.paprota Patryk Paprota (Inactive) , marta.kucharska Marta Pastor (Kucharska) , maciej.bartylak Maciej Bartylak (Inactive) , tomasz.ruszel Tomasz Ruszel , mateusz.wyzinski Mateusz Wyzinski , anna.kicior Anna Kicior (Inactive) , jerzy.sekula Jerzy Sekula , alexey.chekel Alexey Chekel (Inactive) , grzegorz.duzy Grzegorz Duży , bartlomiej.janczak Bartłomiej Jańczak , michal.niwinski Michal Niwinski (Inactive) , tom.kucharski Tom Kucharski , dastin.kuwalek Dastin Kuwalek (Inactive) , mateusz.jagiello Matt Jagiello (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: