impact

I am trying to make an impact report that will quickly allow a customer to quickly understand the impact of set a weeks work and any delays in their schedule. What i would like to do is make a table with Column A being the project ID, Column B to BA represent a work week, and column BB be the...

Hi there I would love some help in figuring out how to report subtotals from an existing dataset that has been created by combining values from two separate lists. List 1 - Category: Adoption, Process, People, Technology, Tools, and Location List 2 - Impact: 0 - No impact, 1 - Extremely Low...

Hi all I have several spreadsheets with data relating to horse races; the sheets vary in size from a few columns to several hundred columns, and I want to be able to analyse the columns to find the ones that have the most impact on, or relevance to, the result. Is this something I can do...

So I am after some help with the table bellow, I'm trying to calculate how much time is lost per day due to incidents happening. The table on the top is the information we are given which includes start/finish times, duration and how much impact it had to business. What I am trying to make is a...

Hello all I need help with my Impact Effort Matrix. The records results in column C and D starting at row 5 is my Impact and Effort results. see the sample chart below. I would like to do 2 things How do I create a formula for my chart starting F5 where it will address all of the following...

I'm trying to generate a bubble quadrant chart, but need to further refine my data. The quadrant will have Impact along the X axis and Timing along the Y axis. The size of the bubble should be the quantity of the Category. My data looks like the below: Category Issue Description impact...

Hi. I am hoping someone can help me with an excel problem. I’ve added a screenshot which will hopefully help explain what I’m trying to do. I would like the 2 boxes in red to auto populate. Seems simple, but I’m sure it’s not. Impact rating - this should be the highest severity based on the...

Sub Clear() Application.DisplayAlerts = True Dim IA As Workbook: Dim ES As Worksheet Dim InputSheet As Worksheet Dim Competition As Worksheet Dim Demographics As Worksheet Dim AlteryxOutput As Worksheet Dim Impact As Range Set IA = ThisWorkbook Set ES = IA.Sheets("Executive Summary") Set...

I'll try to type this out first, will provide a spreadsheet later if needed. I'll have to build it in a sharable format. If I sell 100 items (100 line entries, multiple items per line) that have varying selling prices as well as costs and units sold I end up with varying gross profit per line...