goal

I'm having a challenge in resolving an algebraic problem using excel and would really appreciate some help. Scenario: Call center has goal of answering 80% of calls offered within X time Sum of calls currently answered at goal is 369 Forecast remaining calls in day is 1854 Objective: How...

I am having a hell of an issue that i can not figure out. So I have 6 teams with three months of data I need to track. Each team has a goal they need to achieve each month based on how many people are on that team. This goal changes with the number of people on the team. This is at the bottom of...

I better explain this right, i would like to present in a cascade chart the participation of a category in the percentage fraction out of goal. Any guide will be highly appreciated. From the table below in PowerBI I have the following: On Goal = 8/18 = 44% What i would like to present is the...

I am using the multithread tool by Tomasz Kacprowicz at http://analystcave.com/excel-vba-multithreading-tool/ Usually this tool works great but is failing for a new model in which a Sheet_Change event is used to automate the goal seek function. When the model is run with only 1 instance of...

Hello Evryone I have a problem in my office 365, in using goal seek When I use it, it change the set value by the value i has entered without changing the cell that must be changed This is an exemple A1 = 1 / A2= 2/ A3= A1+A2=3 (My goal is to have 100 in cell A3 by changing A1=> The...

Say there is a value in cell E1, which has been calculated from the contents of cells in column D. With Goal Seek one can alter the number at E1 by changing one of the cells in column D. Rather than altering a single cell in that column, should I need to more than one to obtain the required...

WhatIfAnalysis Macro ' ' Keyboard Shortcut: Ctrl+g ' Public Sub GoalSeeker() For i = 3 To 187 cells(i, "AG").GoalSeek Goal:=0.15, ChangingCell:=cells(i, "AF") cells(i, "AF") = WorksheetFunction.Round(cells(i, "AF"), 2) cells(i, "AF") < 0 = 0 Next i End Sub

I am running goal seek on two different workbooks. WB1 has an interest rate that modifies the value of the other workbook via basic multiplication. I am goal seeking the sum of the products. When I step through the goal seek iterations, it lands precisely on the sum I want. But goal seek...

Scenario: I am trying to find the best way to search one row across ten non consecutive columns to see if criteria is met. This row is one of a thousand and the columns are ten of ninety-five. My goal is: If B3="V" AND AF3="B" AND Q3-AQ3 <=|2.25| OR AH3="B" AND Q3-AS3 <=|2.25| OR AJ3="B" AND...

Hello, I'm not sure if something like this is possible, but if "Indirect" is possible, I'm sure there is a way to achieve my goal. Here is my dilemma. There is a formula I need to use: (formula 1) =T:T&" "&IF(AA:AA<16,1,IF(AND(AA:AA>15,AA:AA<31),2,3)) Example output would be: AM DIY 3.2OZ...

Are there formulas that will add, subtract, multiply, and/or divide data from two-digit numbers in a single cell? I appreciate any help I can get. Thank you in advance.

Hello! In my day to day job, we have goals set (for each month) that can be either positive or negative "net adds", and I can reach negative or positive actual net adds by the end of the month. I am having issues getting excel to populate my percent to goal under the following parameters: My...

My data has multiple pairs of a "name column" and "hour column" that corresponds to third value in another "movie column." The names aren't always the same in each column and can sometimes be blank or repeat. I'm trying to match and sum across all of these columns. The end goal is to have a what...

I do a Financial Spreadsheet for my boss. Lets say A1 is our revenue. B1 is staff cost. C1 is a percentage of cost to revenue. D1 is the difference of C1 to our Goal of 22.5% Is there a way C1 can turn Red if the Percentage exceeds our Goal of 22.5? Is there a way D1 can be Red if the...

I have a macro that calculates a function. There re 3 inputs to the function Often I use the excel spreadsheet to do a goal seek to set the result of that faction by allowing one of the inputs to vary Is there a simple way to program this in vba or do I basically have to write a complete...

Below is a sample table i'm working on. We have an opening number for each member in B and a target closing number in C. Column D is the actual closing number. e.g. Mem5 target is 17,000 and closing is 17,000, Column E should show 100%. Mem4 target is 18,400, but opening and closing are same at...

Hi Guys, I have a table like this: <colgroup><col><col><col><col><col></colgroup><tbody> Current Attempts Current Average Time Goal Remaining Attempts Time I need to get to goal 50 250.00 210.00 25.00 > help here < </tbody> I'm looking for a formula on how much time I need to get to my...

Hi guys, Im looking for a sub goalseek that involves a loop making U8:U207 = 0 by changing the values in b2:q12 thank you

Hi, I can't seem to get this to work. Any assistance would be greatly appreciated. I am trying to use conditional formatting on sheet 1 to highlight green any sales months that the seller was over goal based on their goal data on sheet 2. Sheet two contains the seller's goal data. I need to...

Hi Folks. I'm looking to randomize some of the inputs to a goal seek calculation that I can run multiple times for different random values. This creates the problem of goal seeking on continually generating random values which doesn't work. is there a way to freeze the random values functions...