backlog

  1. J

    Making a dynamic burn-up chart with a changing ideal story points line (Scrum/agile dev)

    Hi! I am trying to make a dynamic burn-up chart so that we can add story points in the middle of a sprint. If there is no change, the calculation is easy, it's just the total story points (say 100) divided by the number of days, and you add these per day down the rows. But if there is a need to...
  2. T

    Emergency 911 of Backlog

    Hi Guys ?, I have a question to you about which formula can help me to show and collect all backlog in my Register. I will add two Mini Sheets to describe everything in a simple way. Note about trigger: The trigger should be activated only in one condition when I have request Date only and No...
  3. T

    Backlog in DataBase.

    Hi guys, I need to create a short schedule about my backlog in my DB. As you can see I have 5 category ( PWHT ,MPI/PT, HT, RT, UT ) with a little backlog ( PWHT 4 , MPI/PT 0 , HT 7 , RT 16, UT 0 .) and I want to see only Backlog Lines from my DB. DB range in Sheet1 A2:CC367 and also after...
  4. R

    rename specific worksheets

    Hi - everyday i always have 3 sheet (sheet1, sheet2 and sheet3) and need to copy to new workbook. but before that, i need to rename it with - sheet1 = backlog approval - sheet2 = backlog release - sheet3 = backlog pr instead using manual effort, can you please help to create vba macro to run...
  5. Woodpile

    Delete Query Not Working because table not specified

    Hello, I am trying to write a delete query to remove records from a table based on records in another table. There is a common field and I want to delete records in table 80 that have no matching records in table 01 (Below). The query works just fine but when I switch it to a Delete Query, it...
  6. B

    Trend Chart

    I am trying to put together a chart to show a chart taking into account the amount of influx I have coming in each, the base/backlog I am starting with and how many i am completing each month. The goal is to have the chart show when I will zero out the backlog based on the number of completions...
  7. R

    Sort data list based on formula with interchanging signs (<,>,<=,>=) within the formula

    Hello Everyone, I am working with a large data set and and have a formula for generating a list (starting in D14) based on the highest value of Backlog $ within the set parameters starting in G14. The issue is that the parameters, largely the signs (<,>,<=,>=), are part of the formula, ie...
  8. E

    Calculating task reduction rate over time, accounting for task growth rate

    This seems like it should be easy, but I can't quite figure it out. Situation: there is a backlog of tasks, and new tasks continue to be added to the list at a steady rate. Assuming I know the starting number of tasks, the growth rate, and the number of hours that can be allocated to the...
  9. R

    Consolidate specific cells from all files, all sheets in specific directory

    Hello, I've been reading through the various codes for consolidating data from multiple files in a given directory, but nothing seems to be exactly what I'm trying to do. Here's the situation: I have a master consolidation workbook titled "Master Backlog", in a worksheet called "Backlog". I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top