Calculate Individual Contribution On Customer Satisfaction For Entire Team

Oct 23, 2012

I am planning to calculate the individual contribution on customer satisfaction % for the entire team.

Currently the layout looks roughly like this:

C2 - contains overall team Csat %
C4 - contains total number of surveys received

C9 -> C15 contains operator names
D9 -> D15 contains operator individual csat %
E9 -> E15 contains operatore number of csats received

Using the data above I thought I should be able to generate a number or % that would indicate the individual's contribution to the overall score.

View 1 Replies


ADVERTISEMENT

Deleting Entire Customer Entry If One Cell Is Blank?

Dec 24, 2008

I have a large database of customers. I would like to edit this database so that it only lists those customers that have an email address listed in that particular column. I can then save that as a separate list to upload to my marketing campaign.

Is there an easier way than just deleting entire rows at a time? About a 2,000 name list with maybe 30% having email addresses.

View 2 Replies View Related

Using Solver To Calculate The Optimal Fantasy Football Team?

Aug 30, 2013

Is it possible to calculate the current optimal fantasy football team from the attached data and constraints listed on the 'solver' tab?

View 2 Replies View Related

Individual Cell Formula Finder In Entire Excel Sheet?

Apr 18, 2014

In an excel sheet, i have columns as below:

Column: A B C D
Values assigned & Formula Used : 1 2 3 (A+B+C)

There are lots of cells, where i used various formulas that includes the value of Column D as specified above.

Example:

In Column E as "D*3" or Column Z as "D-E".

Now, i want to trace in the whole excel sheet, where i used column D in Formulas, i put through.

View 7 Replies View Related

Formula Does Not Calculate Numbered Customer Accounts

Feb 4, 2009

following calculation that someone created for me.

=LOOKUP(10^10,CHOOSE({1,2},0,AVERAGE(IF(Sheet1!$C2:$C13=$A2,IF(Sheet1!$B2:$B13-DAY(Sheet1!$B2:$B13)+1=B$1,Sheet1!$D2:$D13)))))

My problem is that I have some customer account numbers that are alpha/numeric (1B0012) and some that are just numeric (1675) . The above formula does not pick up the numeric accounts correctly.

Is there something that I need to add/remove from this formula so that it will pick up both? or is it a format issue?

I have attached an example of the spreadsheet with this problem. If you select either of the alpha numeric codes it works, but if you select the numeric code it doesn't.

View 9 Replies View Related

Calculate Averages Of Individual Months Over 40 Years

Jan 5, 2012

I have a large sheet of daily river flows and precipitation amounts, over 40+ years.

I want to calculate the average flows in each month of each year (ie 11/1968, 12/1968, 1/1969 etc). Dates are in Col A, flows in Col D.

How to average a particular month over all years like so:

{=AVERAGE(IF(MONTH(A2:A15282)=1,D2:D15282))}

But I don't know how to average per month of each year, or how to make a formula that will allow me to quickly calculate the averages of 100s of months.

View 6 Replies View Related

SUMIF Function: Calculate What Is The Total For An Individual For The Whole Month

Jul 3, 2006

I have the same data (but not necessarily on the same cell for everyday) for everyday of the month. Now I need to calculate what is the total for an individual for the whole month. Example,I need to total John's data for the month of January from the individual sheet for Region 1, Region 2 and region 3. I tried the sumif function as below but it does not seem to work. =SUMIF('Jan 1:Jan 3'!B5:B7,"John",'Jan 1:Jan 3'!C5:C7). I have simplified the file as an attachment below.Appreciate need as the original file is for 6 months and I need a way to compute the data.

View 4 Replies View Related

Calculate Percentage Of Individual Months Between 2 Dates And Populate Different Cells With Results

Dec 20, 2013

I want to display the percentage of occupancy for each month for condo rentals.

I have columns with dates that represent bookings throughout the year. check in and check out dates to be more precise. (A1 and B1 for example) and I have columns with months Jan, Feb, etc. (C1, D1, etc. for example)

The problem I run in to is that I can calculate the number of days between the dates and the fraction of the year (*12 to get a monthly value, but I fail to understand how I can break that up so that I can populate each month with a correct percentage of the total term.

E.g. A1=1-jan-2014 and B1=20-jan-2014 is an easy one because it only covers 1 month:
formula: =(YEARFRAC(A1,B1,3))*12 gives me 62,47% which I could just use as is for that month.

So far so good, but when the period covers more than one month or when the months overlaps, I don't know how to break the outcome up into the appropriate months to display the correct percentage for each month in its own column.

e.g. A1=1-jan-2014 and B1=20-Mar-2014 gives me a result of 253% with the same formula.
100% for November, 100% for December and 63% for January, which I could somehow formulate to break up over different Months.

But then it gets more tricky. What if the booking starts on a day other than the 1st of the Month?

e.g. A1=5-jan-2014 and B1=20-Mar-2014
The result of the formula (243%) is correct, but isn't sufficient to put the correct percentages for each month in their respective column.

What formula(s) should I use to break down the percentages to match the correct fraction of each individual month?

I attached an example of what I have so far for your review : test.xlsx‎

View 8 Replies View Related

EPF Employers Contribution 8.33%?

Dec 30, 2013

I AM CALCULATING EPF EMPLOYERS CONTRIBUTION 8.33%.

BASIC PAY : 6000
HRA : 2400
CONVEYANCE : 1000

EPF = 6000*8.33% = 499.8 OR 541 WHICHEVER IS LESS

THIS FORMULA HOW I CAN USE IN EXCEL

8.33% on basic pay or else 541, which ever is less

View 3 Replies View Related

Salary Bracket Returns Employees Corresponding Contribution For Health

Jun 17, 2013

I have this table which has employees names with basic pay and contribution.

I was tasked to create a excel sheet where in if the employees basic pay is input, the corresponding contribution for the employee will show depending on which salary bracket he/she is on.

I am not allowed to know what my workmates salaries are since im just an associate, so i just have to leave em blank and wait for my manager to input their salary.

See attached file for the workbook : PHEALTHWORKBOOK.xlsx‎

View 6 Replies View Related

Cumulative Staff Contribution Per Process Activity Cannot Exceed 100%

Oct 2, 2012

I have a spreadsheet whereby process activities can be attributed to the different staff members who complete the activity. Each activity is on a different row and up to three staff can be assigned to each activity, so for example if a level one employee sorts the mail on four out of five days per week I would attribute 80% contribution to the task to the level one employee. If a supervisor sorts the mail on a Friday I would allocated a 20% contribution to that staff group.

My question is how do I prevent someone filling in the spreadsheet from allocating a combined contribution above 100% to any task. This could be for example either putting a number in greater than 100% into one of the allocation columns or a total across up to three different columns above 100%.

The columns where I assign the percentage contribution are E,H and K. I would like to generate an error which says something like 'Cumulative staff contribution per process activity cannot exceed 100%.

View 6 Replies View Related

Calculate Who Appears In The Lowest 25% Of The Entire Ranking

May 11, 2009

What I am doing is taking the below info which is only a portion of what I am really using but I need to calculate who appears in the lowest 25% of the entire ranking but also if they were there for both months... is this possible cause I cant seem to figure this out?

View 9 Replies View Related

VBA Code To Get Individual Values In A List Placed Into Individual Cells

Apr 7, 2014

My current project involves sorting a spreadsheet, selecting specific qualifying data from the sheet, storing it into a variable, the pasting the individual values from the list into individual cells on a different sheet within the same workbook. Here is the code I have so far...

Code:
Sub Test()
'' freeze screen updating to remain on main worksheet
Application.ScreenUpdating = False
'' move to Avaliable worksheet
[Code] ..

When this code runs the first item in the list pastes into Sheet10 A1, but no other values from the list are placed into Sheet10. Previous to this I had been using a variation of this code to push the list into a combobox list within a userform. In that case instead of

Code:
ThisWorkbook.Worksheets("Sheet10").Range("A1") = x

I had

Code:
Combobox1.list = x

And this worked perfectly; creating a list within the combobox (in fact I can use this modification to interrogate my code to determine if the list is being properly generated, and it is).

View 2 Replies View Related

Converting Uneven Rows Of Data Per Customer Into 1 Row Of Data Per Customer

Aug 1, 2014

I have a list of Spid numbers and a service category identifying if it is a Water Spid or a Waste spid.

The Spid is split into 2 parts. The Core is the identifier and the Category states if it is a Water or a Waste spid.

If the 1st digit in the Category is a 1 = Water.

If the 1st digit in the Category is a 2 = Waste.

There may only be a water spid or a property may have a water and waste spid.

What I want to do is have the information on 1 row rather than 2 rows

I have data in this format

SPID
Core
Category
Service Category

100000000151
100000000
151
1

[code].....

and I need to convert it into this format.

Core spid
Water
Waste

100000020
100000020101
100000020251

I have tried IF(lookup) and it works for the 1st row but I can't get it to look at the 2nd row.My data consists of 400,000 plus rows

View 3 Replies View Related

Random Team Generator?

Jul 11, 2013

I am organizing a sports tournament and would like excel to randomly generate the teams for it.

We have 20 people who will be organized into 10 teams of two. how to setup the formula to have two people randomly paired together without duplication. The names will be further used in other formulas for points calculations.

So, I have the names as A1:A20 and then would like the teams generated from B1:B10 and C1:C10 with the team being the row and the team members in the B and C columns.

View 1 Replies View Related

Team Selection By Web Query

Mar 2, 2009

i have an idea that i will be able to select a team in sheet1 cell a1 via a dropdownlist and also c1 giving a home and away team

all teams have there own unique number which i would be able to list them all

it would then look at c1 compare it against the list and use that number

then on sheet two

it would return the results

web address is [url]

arsenals number is 142
aston villa are 154

View 14 Replies View Related

Sports Team W/L Counter.

Jan 8, 2010

i want columns T,U,V,W to continuously count wins and lost for the teams..if i

change the teams names i want T,U,V,W to read "0".

Any team can play any one.

also this is kinda a part 2 (really small part)

I'm trying to use Today function but cant get it to count every other day..

so for example tomorrow will also read "January 7th 2010"

Sheet14


MNOPQRSTUVWXY2

3

4

Team 1VSTeam 2W/L Count

5

LostWinTeam 1Team 2

6

WinLostWinLostWinLost

7 .......................

View 9 Replies View Related

Keep Tally Of Team Scores

Jan 19, 2008

I need to create a sheet probably involving macros where I enter a numerical value into a cell (say B5) I want the sheet to assign a score to the value I enter and then add the score it generates to a table of values. Once ths is done I need it to automatically clear the original value I entered ready for me to enter a new value - rinse repeat..

e.g.

into B5 I enter 15 - on the right in the results table there are headings v w x y and z

say 15 scores one point for w and one point for z I want the sheet to add 0 to the totals under v,x & y and add 1 to the totals under w and z.

Then I want the sheet to clear cell B5 so I can enter a new value without manually deleting the previous entry.

If I can also copy the value I enter into a "history" which simply lists all the values I enter as I go along so much thebetter.

View 3 Replies View Related

Catch An Error And Reset The Entire Code To The Very Beginning And Skip That Entire Entry

Jun 5, 2008

I want to catch an error and reset the entire code to the very beginning and skip that entire entry. When I use "Next fieldSheetName" I get "Next without For," error 1004. Searches tell me I have an open block somewhere, but that's not true. Removing that statement (and having the loop iterate as normal) has no error at all.

Dim employeeName As String
Dim fieldMax, x, y As Byte ' Counters mostly
Dim workedHours, fieldSheetName As Integer

fieldMax = 204 ' Row number to stop on in the field time sheet
row = 4 ' Row specification for field time sheet. Begin at row 4 to ignore headers
' and start on the first name. This should not be changed!
Col = 3 ' Start at column 3 then increase by one to start going to next time entry

' RESET HERE!
For fieldSheetName = 4 To fieldMax Step 8 ' This is our MAIN loop. It iterates from 0 to fieldMax, which is 204...........

View 9 Replies View Related

Taking Team Names Into Two Cells?

May 21, 2014

How i can take just team names in A column as home and away to B-C columns ?

View 4 Replies View Related

Drop Down Menu That Allows To Pick Any Team

Apr 11, 2009

Im trying to do now is I have a drop down menu that allows me to pick any team that we can face in the season. Once that is chosen what I want to show is the individual stats against that team. Now right now Im just trying to work out the formula to see if it works.

The formula itself is half working. For some reason some of the selections arent showing up like there suppose to do.

View 10 Replies View Related

Random 12 Team Schedule Generator?

Jun 17, 2013

I have 12 teams, 4 divisions of 3... they play each team in there division twice, and every other team once... What's the easiest way to make something to randomize this automatically? This is for a contest at work that starts over every 13 weeks.

Obviously there can't be any duplicates week to week.

WeekABCDEFGHIJKL
1BAAEDDHGGKJJ
2BAAEDDHGGKJJ
3CCBFFEIIHLLK
4CCBFFEIIHLLK
5DDDAAAAAAAAA
6EEEBBBBBBBBB

[code]....

View 5 Replies View Related

Create Team Fixtures Table

Jun 25, 2008

I need to create a full list of fixtures for a football (Soccer) league i am involved in.

i believe this is a multi stage project that i need to tackle in bite size chunks.

I have a list of teams, division that they play in and there home stadium name.

my spreadsheet has 2 sheets visible at the mo...

Rules:

I need to create a list of all games that require to be played.

All teams in the same division must play each other twice, once at the home stadium of each club.

Only division 1 clubs play against other division1 clubs

Only division 2 clubs play against other division2 clubs

I need a full list of matches to be generated in my worksheet called "required Matches"

View 4 Replies View Related

Random Pairs Of Numbers For Team Match-ups?

Jun 24, 2014

I have a spreadsheet with 14, or maybe 16, or maybe 40 names in column B.

A1 = 1 B1 = JOE CITIZEN
A2 = 2 B2 = JANE PERSON
...
A17 = 3 B17 = JACK DOE

and so on...

I want to randomly assign these names to pairs using a macro button, and basing it on the number of players (C1)

So if C1 is 12, I'd like the function behind the macro button to come up with 6 * 2 numbers (2 and 11, or 4 and 7,

all completely random, but within the 12 specified in C1) and write these random values in Range D1:E6
(if C1 is 18, then the range to write in would expand to D1:E9).

I don't know enough about writing code to be able to pull this off .

View 2 Replies View Related

Create Separate Sheets For Each Team By Year

Feb 27, 2014

I have a code that will create separate sheets from “SDL_Calendar” sheet for each team and its working fine. Modify the code to create sheets for each Team BY YEAR based on user selection in Cells “H6”, “H7” and “H8” in “P6_Report” sheet. For filtering BY YEAR Column "D" Can be Used in “SDL_Calendar” sheet.

I have attached the work book of what I am trying to accomplish :

[Code] ......

CreateSheetsByYear_new.xlsm‎

View 14 Replies View Related

Formula For 2 Low Net & 1 Low Gross Score In A 5 Man Golf Team

May 25, 2008

I am using Excel 2002 in Xp and also want to use the spreadsheet on my Pocket PC using Pocket Excel.

I have a column of 10 numbers with rows 1,3,5,7 & 9 representing the individual gross scores of the 5 team members. Rows 2,4,6,8 & 10 have either a 0 or -1 (calculated) in them representing the strokes (or discount) the player receives for that hole. So the net scores for each player will be row 1 + row 2 and so on.

I need a formula that will calculate the total of the 2 lowest net scores and 1 low gross score with the score for each player only being used once which will then represent the team score for that hole.

A sample column would have 4,0,3,0,4,0,3,0,5,-1 in it.

View 9 Replies View Related

Random Team Making From Database Of Player And Ratings

Dec 8, 2013

My friend and I have created a Wallyball league (volleyball played on a squash court). Every week we have more and more players and making the teams is more and more complicated and time consuming. I created this Excel file to try and generate random teams faster.

team selection.xlsx

The file consist of :Jersey no. and player (A and B)rating if playing (C)rating (D)playing on a given day 0 or 1 (E)wallyball courts to generate random teams with a team rating and differential rating.

The only thing it needs is a non-repeating function (as of now, one player can be selected many times)

Also, the players should not be selected if they are not playing on a given day (column E = 0)

I have to do this WITHOUT using macro (1. I'm not familiar with macros ; 2. I have a free starter version of Excel, I don't think macros are enabled).

View 2 Replies View Related

Rotate Squad For Darts Team Excel Generator

Apr 8, 2014

Problem: Have a squad of 8 players in my darts side. We have 12 games in our season and each game requires 4 players so each player will play 6 games. 6 of these games are at home and 6 are away.

I want to create an excel sheet whereby a team will be picked for each match. Each player will play at Home and Away 3 times each. And the same group of players will not play with the other players each time.

eg. Week 1- Team Players, 1, 2, 3, 4
Week 2 - Team Players 5,6,7,8
Week 3 - 1,3,5,7
Week 4 - 2, 4, 6, 8 etc.

Where to start. There are multiple variables.

View 2 Replies View Related

Display One Instance Of Each Team Name As The Page Header Upon Printing?

Jun 12, 2013

I'm working on a simple spreadsheet with individuals divided among teams. Each team is separated by a page break, so the column displaying Team Name repeats the same team name all down a page, and then another team name all down the next page, and so on. I've been searching for a way to display one instance of each Team Name as the Page Header (or just at the top of each page) upon printing. I've included an attachment for reference.

View 3 Replies View Related

Random Team Generator For Hockey With Two Sets Of Data?

Apr 24, 2014

I am trying to build an excel spreadsheet for a hockey program I'm coaching that will do the following:

Create 4 teamsThere will be a Team 1 White/Dark, and Team 2 White/DarkUse 2 lists to distribute players evenlyThere are a disproportionate amount of players on each list. There are 8 Majors, 12 Minors. 2 Majors maximum need to be on every team.Every week, the roster will be different (some don't show). I need to be able to hit 'randomize' and exclude certain people, and still have the lines 'relatively' similar This is an essence two 3 vs 3 games, with a white vs. dark on each side of the ice (2 half-ice games). If there are 3 majors on each side (6 in attendance), one side will have a white with 2 majors, the other side will have a dark with 2 majors.

I'd also like a way to keep track of who's played with/against who, so if I can export that data set to ensure I don't get a duplicate team...or a primarily duplicate team.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved