# Compute The SCORE

Jan 20, 2009

i was assigned to make a computation for our individual scores using this:
EMPLOYEES A-N

inputs:
SURVEY(0-100)
LH(lost hour)
AHT(average handling time)

compute for:
SCORE
RANK

the SCORE has a total of 100%
so to get the SCORE, each input gets a percentage: SURVEY=40% LH=30% AHT=30% then added.

but the thing is LH and AHT has an equivalent.

LH
0 to 1=100
1.1 to 2=90
2.1 to 3=80
3.1 to 4=70
4.1 to 5=60
5.1 above=20......

eXAMPLE:
EMPLOYEE A
SURVEY(0-100) = 33.00
LH(lost hour) = 12.00
AHT(average handling time) = 14.20
SCORE = CODE
RANK = CODE

now for the rank i just use the code =RANK(SCORE A, SCORE A:SCORE N)

im lost on how to compute the SCORE though coz i can just use =((SURVEY*40%)+(LH*30%)+(AHT*30%))

but the one that needs to be on the LH and AHT are the equivalents and not the inputs.

and there is 1st 2nd and 3rd place. the name of the top 3 employees should be shown under the table.

## Formula To Work Out Score Based On Score System

Aug 10, 2009

I want to see if i can make a formula that works out how a player got a score based on a scoring system. See the attached file for more details. I want this to show that the player scored or didn't score, played a full match or was a substitute, was booked or wasn't booked and was sent off or wasn't sent off.

## How To Key A Formula To Compute The Due Date

May 14, 2009

I'd like to know how I go about to key a formula to compute the due date 30days after the invoice date and How to key a formula to determine hours worked.

## Formula To Compute Commissions Paid

Jun 9, 2014

I need to write a formula that will look at a number in a cell and compute an amount at 1% up to 55,000. Then anything above the 55,000 compute an amount at 3.25%. Then add the two together.

So a baseline of 55,000 at 1%. Then above the baseline 3.25%.

## Copy Cell To New Workbook & Compute Sum

Nov 29, 2007

I've attached a Screen Shot of the of 2 Workbook, named Installation Tailgate 2007v1.xlsm and new workbook and i've also attached the excel program itseff in zip.

Installation Tailgate 2007v1 workbook, have a 13 column and nth number of rows ( and will keep growing)

columns D & E are hidden
columns G, I, K, M are checkboxes
if the user clicks on the command button it will copy and paste the selected cells on new workbook

unchecked cells on Installation Tailgate 2007v1 workbook should have a "0.00" on Child workbook.
then compute the Sum of Columns C, D, E, F, G, the total should be on last of their row

## Compute And Display Result In Cell

Sep 26, 2009

I have 15*2,14*2,14.5 in cell A1 and would like this to be computed and its result (i.e 72.5) displayed in cell A2. See below for clearer picture:

A1 A2
15*2,14*2,14.5 72.5

## Macro To Compute Data Using SUMMIF

Oct 5, 2011

I have the following macro to compute data using SUMMIFS

Range("E" & finalrow + 9).Formula = "=SUM(SUMIFS(E8:E" & finalrow & ",F8:F" & finalrow & ",{""PSP101"",""PSP611"",""PSP140",""7*""}))"

The last line up code is mot working as I am tying to using a Wildcard for the last criteria
""7*""

Where text starting with a 7 appears in column F for eg 76601G, 75106K etc appears it must be included in the criteria

Full Code-below
Sub Totals()
finalrow = Range("A65536").End(xlUp).Row
Range("A" & finalrow + 3).Value = "Total Movement"
Range("E" & finalrow + 3).Formula = "=sum(E8:E" & finalrow & ")"

[Code]....

## Compute Value Based On Multiple Cell

Jul 16, 2013

I've been having a hard time with this i need a formula which will compute a value based on a multiple cell.

I have a cell (AQ) it contains the number of days a patient is in a center i need to countif the cell value is >=90 if it is it will then calculate the values in cell (AV) which is >- 1.4 and get the average of cells in AV.

## Macro To Match 2 Tables And Compute Values

Jan 9, 2013

I'm trying to make a macro that match table in sheet "Vocabulary" to the second table (columns Q,R,S,T) in sheet "Overview" and compute correct values in column U using weights from column F, sheet Vocabulary on values from a corresponding cell at column M, sheet Overview. The entries for every ISIN in the sheet Vocabulary are in no particular order and some positions from sheet Overview don't have to exist in Vocabulary at all (but I still need them to display in the table on the right to be able to make charts from summing these categories).

Portfolios.zip

How should the end result look like is displayed on the last sheet.

## Compute T-test With Unequal Sample Sizes?

Oct 24, 2007

using the ttest formula function

## Calculator Compute Automatically After Inputting The Date

Apr 29, 2009

i m making a very small calculator. It's a little hard to describe, but I need to look like the following
Let's say the individual got here on 1 Jan

Phase 1 is for days 1-14 last for 14 days
Phase 2 is for Day 15-35 last for 21 days
Phase 3 is day 36+

This is what I need it to look like: All the phase information will compute automatically after inputting the date arrived. In addition I would also like to be able to change one of the phase dates and the remainder of the phases compensate according to the newly entered date.

Date Arrived = 01 Jan 09
Phase 1 = 01jan09
Phase 2 = 04Feb09
Phase 3 = 05 Feb09

## Compute For Staffing Requirement With Turnaround Time?

Dec 13, 2012

how to compute for staffing requirement with turnaround time?

## How To Compute For Elapse Time Using Excel Formula

May 15, 2012

I have some question regarding elapse time using excel formula.. Just want to compute for the total hours consume by a person per task assign base on 5 days,8 hours per day working schedule(Saturday and sunday is not included since it is the restday of the agent. Working hours is 8am to 5pm. 12pm -1pm is the time agents take there lunch.

See below example and expected Result:

AGENTSStart timeEnd timeExpected Result(hour)RemarksCHARICE5/14/12 8:00 AM5/14/12 3:00 PM6.00Result subracted by 1 1hr breakALICE5/15/12 8:00 AM5/17/12 3:00 PM22.00Result subracted by 3 1hr breakJAKE5/16/12 8:00 AM5/21/12 3:00 PM30.00Result subracted by 3 1hr break(Saturday and Sunday is not included(may19-20))JOHNNY5/14/12 8:00 AM5/17/12 3:00 PM30.00Result minus 4 1hr break

## Compute Average Formula With Blank Cells

Jul 25, 2013

Is it possible to show "0" zero in the total average column without inputing zeros in the blank cells in row B3:E3 & B4:E4? There are months we receive no boat & RV orders, so those months wll be zero most of the time. Instead of having #DIV/0! it show 0, without having to input zero in cells to compute the average.

A
B
C
D
E
F

1

Jan
Feb
Mar
April
Total Average

[Code] .......

## Averagif/averageifs :: To Compute The Realised Profit Or Loss

Oct 25, 2008

How to compute the realised Profit or Loss for each of the shares transacted for the year ended 31 December 2008 based on average cost of each share.

using AVERAGEIF, if appropriate. [Pls refer to the attachment.]

## How To Use Countifs Function To Compute Month Of Year From Date Value

Aug 7, 2013

I have a problem where there are 4 arguments passed to my COUNTIFS function to give me a total count i.e. "KP","James Report","Completed","Month"

Here is the Formula I used;

=COUNTIFS(Master!\$B\$2:\$B\$29,Picklist!\$C\$8,Master!\$D\$2:\$D\$29,B3,Master!\$H\$2:\$H\$29,Picklist!\$C\$2,Master!K2:K57,Picklist!E9 )

The last part of my formula is throwing an error "K2:K57"

What I should get in plain English.... "The number of 'James Report' 'Completed by 'KP' in 'August'. (Any specified month based on what comes from my "dates field" on my Master sheet.

I have got a field in my Master sheet with dates which I have transposed into the right month of the year using Month().

## VBA- Write A Macro To Find The Similar Maturity, Compute The Returns

Feb 13, 2007

I am working with financial data and am exposed to a problem that excel formula cannot solve. I am very new to VBA and would like some assistance please. I have in one excel column the list of maturities in dates eg. EN02, EN03, EN04 etc (EN=January). I have in another column the corresponding prices for these maturities. What I would like to do is compute the returns on similar maturities and paste the returns in the returns column. I can use a formula for this when the consecutive maturities are the same. The problem arises when I want excel to find the previous similar maturity, which may be 5 cells or so before. How do I write a macro to find the similar maturity, compute the returns and place that returns value in the returns column.

## Calculate Time Elapsed And Compute Day Of Week Based On Date

May 27, 2014

1. Calculate the time that has elapsed between 2 times in both hours:min (hhmm) and total mins (mm)

2. Compute the day of the week (mon-fri) a particular date fell on. I really only need to know if the date fell on a weekday or weekend.
table { }td { padding: 0px; color: windowtext; font-size: 10pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Arial; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { font-size: 12pt; } 1= M-F

2=S-S

3. How to write an If statement that assign a value to time based off this chart:
table { }td { padding: 0px; color: windowtext; font-size: 10pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Arial; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { font-size: 12pt; } 1= AM (7-1459)

2=PM (15-2259)

3= MN (23-659)

## Tally Score

Mar 14, 2007

im using spreadsheet works which seems to be very similar to excel. i am making a table full of numbers and i want to count how many times the number 1 appears and for that amount to be displayed.

## Name And Score (rankings)

Nov 17, 2007

i have a list of names in column A and a corresponding score for each name in column S.
on a stats sheet B10:B15 was trying to make a top 5 list using =LARGE(Week1!S15:S46,1) ... with Large i am able to get my top 5 from the week1 sheet but how can i assign the corresponding top5 persons from column A15:A45 in week1 to the stats sheet in column A10:A15

## Score Sheet

Apr 27, 2009

I am currently working on a score sheet with list of question.

I have:
On Sheet 1 (will be hidden later)
List of 14 questions (e.g. question 1 = 6 possible answers, for answer 1 is score -2, for answer 2 is score 7... etc).
In column C are possible answers, in column D are the score values.

On Sheet 2 (will be visible for participants)
Drop-down list based on Sheet 1 questions (Sheet 1; Column C)
I have set Cell link for each question so when you choose the 3rd answer, there is number 3, but I need to set different values based on Sheet 1, could be that 3rd answer is score 12. I do not know which function to use (I tried IF, but to me it seems too long and difficoult).

## Bowling Score

Feb 22, 2004

I've seen a few bowling formulas within mr. excel but nothing in code. so i tried it and the only problem i have is when a player strikes.....then the code should add the next two balls thrown..... it works if the next two are strikes but not if there is no 'mark'. So basically its not adding the second ball. The code looks right unless I'm just missing something. heres the code....

## Score Using Data Validation?

Mar 16, 2005

I am using data validation for a drop down list e.g Good, Average, None. What i want is when a user selects for example "Good" i need a score to be automatically entered into another cell so that i can then do some calculations.

## Modify Score Sheet

Dec 27, 2008

I have one excel file with three sheets marked 1,2 & 4

Sheet 1. is the place we add the description and the member number. When a member number is entered it gets the member name from sheet 4.

Sheet 2 is the page I need to change. Currently we can enter any score number in each box between 1 to 5. If we try to enter other numbers we get an error message.

I need to change the form so we can enter 1 to 10. Any other number needs to generate the error message.

## Find The Score In Worksheet

Feb 5, 2009

Should be an easy fix for experts, but I'm not one of those...

I'm trying to create a "scoresheet" in Excel where a racer has a name and an ID number on the main tally worksheet, with columns relating to their scores for each race. Subsequent worksheets have results from each race (one race per sheet), with the individual referenced by their ID number.

How do I have the main tally sheet "find" that person's score for each event in separate columns so that it can add up their totals? I tried an IF formula to find each score in the subsequent sheets, but that didn't work.

Is there a simple formula to do this? I've been achieving the results by importing the worksheets into a Filemaker database (where the ID number "matches" and updates each score), but that's a pain, and I'd rather do it all in Excel.

## Nested IF (score Range)

Mar 11, 2009

If Average Score is:Then return:
Greater than 89A
From 80 to 89B
From 70 to 79C
From 60 to 69D
Less than 60F

Student's Average Score
90
52
75
88
82
53
46
72
99
100
42
53
69
79
84

=IF(A9:A23>89,"A",IF(A9:A23<=89,"B",IF(A9:A23<=79,"C",IF(A9:A23<=69,"D",IF(A9:A23<60,"F")))))

A9:A23 is student's score range

I am getting the correct answer for the first one only...all others are coming back incorrect. I have been working on this one problem for over 3 hours.

## Find The Name And Calculate It Score

Mar 30, 2009

i need the formula in colums (l) it needs to find the agents name and the calulate the scores for that agents name

## Hours Missed Gives A Score

Jan 20, 2009

Trying to get a result if I missed 0 hours, I will get a score of 5, if I missed 1 -4 hours, I get a score of 4, if I missed 5 hours, I get a score of 3, etc.

0 Hours Missed5
1 - 4 Hours Missed4
4 - 8 Hours Missed3
8 - 12 Hours Missed2
12 -16 Hours Missed1
>16 Hours Missed0

I have tried a couple of things, but the formulas get way to messy & start to lose cell references.

## Display Name Of Highest Score

Dec 20, 2006

I'm setting up a scoring system for my rounds of golf. I have four people competing, and i want to be able to put up a page where i can display the best golfer. I have the scores and i want a function that display f.ex "Thomas" if cell d28 is the lowest number of four cells.

## Rank Based On Score

Feb 23, 2010

I have a workbook with two tabs: Results (containing exam results) and Percentile (containing percentile rankings based on scores). There are different rankings for different exams.

I need the percentile ranking returned (on the Results tab) based on the exam result for each student. e.g. for exam M111 a score of 36 would return a ranking of 95, a score of 18 would return a ranking of 35, etc. I've attached a sample workbook.