backlog

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...

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...

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...

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...

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...

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...

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...

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...

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...