goals

I am busy making a Incident/Accident Report and i want to make a target 0, for example 0 incidents would be 100% and 2 incidents 80%. Can someone please show me how to create a formula for this.

I have a large sheet with soccer players & the number of goals they have scored each season (each column is 1999-2000, 2001-2002, etc. up to 2019-2020). The players names are often duplicated down about 3500 rows of data. How can I get a single row count of all their goals? For example...

Hi, i am trying to create a simple spreadsheet to track my team goalscorers, all i want is for the formula to notice a player name on one sheet and count the amount of goals he has scored on another sheet. The first sheet has the player name in column D and the amount of goals scored in that...

Hi gurus, I am trying to find out whether the below 5 goals, named A-E can be met by a specific date each. Based on priority (my company's), they will be ranked 1,2,3,4 and 5 respectively. Then, they will run through a set of database (can't reveal here due to confidential purposes) to...

Hi all, any reason why i would be getting a #Value error using the formula: =SUMPRODUCT(--(Season=$LU$2),--(home=$LV5),--(FTHomegoals+FTAwaygoals>MV3)) Season Lu2 is referencing the range of the data i wont to use Home = LV5 is pointing to the particular team & where it would be listed...

I have a column of minutes from goals scored 45' 5'67'89' 2'5'89' 15'67'79'78' is there a way of adding them all up please?

Hi, I have set of goals for each employee and I need to set 5 loops to include them, below is the macro that went through one goal. I need to set loop to go through all the 5 goals, how can I do that? Thank you!

I am wondering if I can get suggestions from the experts here how best to proceed. I am trying to take my companies 10 sales goals and turn the monthly data into a dashboard so that my boss can quickly view progress. Each goal has a production number, goal, and deficit/surplus to goal. The goals...

Hello, Its been a while and I hope someone can help. I have a fairly simple spreadsheet which is called Buster. It consists of various people who gamble on football teams scoring some goals or not each date they are playing. As soon as some one reaches 21 goals they win. However if they go over...

<tbody> Game Win Draw1 Draw2 Loss Win Goals Draw1 Goals Draw2 Goals Loss Goals 1 Calum Steve 3 3 1 Owen James 1 0 1 Jim Victoria 2 1 1 Peter 0 1 1 1 2 Calum Dan 4 5 2 James Steve 4 5 2 Phil Tom P 1 1 2 Tom G Dave 2 0...

Hi Everyone, I have a data set of sales reps and their sales (date of sale, amount, team, etc). I also have a separate sheet which has goals for these folks for the full year. I've setup a pivot table and a line chart on the sales file that shows total sales for the year broken down by months...

Good morning, I have a sales sheet that I use to calculate goals based on the seniority level of each salesperson. The formula checks the amount in column "D" against the appropriate goals in "D1-D15" and returns a rating. Currently I can't just drag the formula down the entire column as there...

https://docs.google.com/spreadsheets/d/1REi1NFguL-hD4O6_ZDJuel20Z2aybUJPUWA_ZLdJ0Rc/edit?usp=sharing i am really sorry to bother you. i dont understand why this if statement is not working looking to reward efficiency goals with scores of 1, 2, 3 etc etc. please help!

Sorry, if the title doesn't make sense. Here goes: I have Sales per labor goals tiered as 3 Star, 4 Star, and 5 Star labor goals. Sales per labor goals change based on the sales number. So, basically I want to say: If their actual sales is between these numbers (sales bracket start and...

Hello, I couldn't find this question in my searches, but I have added a week calendar worksheet to my year calendar workbook. Each month has a different worksheet and I wanted to set a formula where I can change hours worked on a certain day in the week worksheet and that will go through each...