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
ADVERTISEMENT
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
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
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
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
Feb 22, 2009
i m creating a formula that will automatically place players in the correct position based on the outcome and there rank.
I have created an example sheet and the results should be in cells E3:E15
View 6 Replies
View Related
Sep 22, 2013
How does one count the number of x and y values (occurring in same row) in this array?
Time1 x a b c d
Time2 b c x y a
Time3 x a y d b
Time4 a b c d e
Time5 y d a x d
Time6 c y a d b
Note all of the variables above are positive numbers.
View 7 Replies
View Related
Mar 23, 2009
I am trying to do some rating in excel.
This is what I am trying to do.
1- excellent
2- good
3- average
4- fair
5- poor
I have the in a validation all of the words as option; but I want once they pick the words, in the cell beside will come up the number instead, and that will be the rating.
View 6 Replies
View Related
Feb 6, 2014
I'm looking for a formula to use. I need to calculate ratings on variances in percentages:
Variance vs expected Rating
0% 3
1-5% 2.5
6-10% 2
10-15% 1.5
15%+ 1
The expected percentage is 5. In other words if a % below 5 is obtained the rating is 3. Between 6% and 10% the rating should be 2.5.
View 8 Replies
View Related
Jul 30, 2014
I have a number of rankings, all from different spreadsheets that I wish to combine and average out.
Thus far I have pulled all the relevant worksheets into 1 spreadsheet. The issue I'm having is that each worksheet contains slightly different names.
So as an example, Sheet1 may have 4 columns: Bob Hope | 4 | SE | PM |
Sheet 2 may have 2 columns: | Bob Hope, PM, SE | 8 |
Sheet 3 may have 3 columns: | Bob Hope, SE | PM | 9 |
What I need to do is have a master sheet which just pulls through the name and then the average of the scores, i.e.: | Bob Hope | 7 |
I have approximately 400 people that I need to do this with.
View 3 Replies
View Related
Mar 25, 2009
i am trying to make and age table to see if a player is too old by years, months and days all i can do is Years i need something like the following
1/10/2009 cut off date birthday is 8/5/1991
all i can do is the following
=YEAR(A3)-YEAR(A2)
View 2 Replies
View Related
Mar 13, 2007
I'm trying to set up a web query that gets the Player Roster from Indians.com and one column is giving me trouble.
On the web site, this column is the player's height, listed as, for example, 6-2.
When the web query import is complete, this column displays a date instead of the height.... so 6-2 comes in as 2-June.
How do I massage this column to display the height and not a date?
View 9 Replies
View Related
May 22, 2009
I need a formula for comparing the scores of 4 players from games won or tied.
I want to know for each game who won, tied or lost.
Below is how I compare 1 player to another.
=IF(P12
View 9 Replies
View Related
Oct 18, 2006
I run a small town pool league and use excell to track player handicaps, ect. we use a simple system for handicapping. Players can be from 2- to 7+ (2- 2 2+ 3- 3 3+ 4- 4 4+) and so on. if a player is a 2+ and wins they go to a 3- and so on. I want to be able to just type a W or an L and have it look up the players previous handicap and return a new handicap in the next field. I've allready figured out how to count the W's and L's and return the total for a teams weekly wins on another page, and give stats on a players wins and losses. I then print each sheet out weekly. Teams have 8 players but only play 5 each week so some players might not play for 2,3 or more weeks. I also use access to keep track of all the people that have played in the league. some players play a few sessions then quit for a few. this way i can keep track of their handicaps when not playing and havew a list of all the people that have played in the league. Can i get excel to transfer a players handicap to access each time it changes?
View 9 Replies
View Related
Jan 31, 2013
I am trying to create and calculate player statistics using Vlookup in Excel. This is what I am trying to do:
BCD
5PlayerGoalsAssists
6Jordan Eberle00=VLOOKUP(TEXT(B6,"@"),B13:G14,4) used in C6
7James Neal 00=VLOOKUP(B7,B13:G14,4) used in C7
cell format is "general" in B6 thru B14
Lookup TableCol ECol FCol G
Player NameTeamGPGAPts
13James NealPITT4325
14Jordan EberleEDM1404
Imported Data from Yahoo Sports and have sorted in ascending order a-b-c-d
(pasted as text and than changed to General in Excel formatting)
I have tried using 2 different vlookup formulas structures, but no success. I have tried using numeric reference (i.e using numeric 1 in for both in the lookup table and the original cell) and that works.
View 3 Replies
View Related
Jul 21, 2006
I'm having some trouble with some VBA code written for Excel (Office 2003). I have a video file (in .wmv format) and a list of time stamps in an excel file. When I click a timestamp, I want to pop open the WMV and play it at that given time.
I've made some headway thanks to a few others, but I'm getting this "Run-time '424': Object required" error that I can't seem to fix. I've attached the file, and it occurs at the line "frmPlayer.Show" and I have no idea why!
View 9 Replies
View Related
Apr 22, 2009
I have a sample spreadsheet (uploaded to this thread) in which I have 10 command buttons named 'Video 1' to 'Video 10'. Next to these buttons is a Windows Media Player Object.
I require the code that upon clicking any of the video command buttons, the relevant video is opened and shown in the windows media object within the same sheet (sheet1).
I'm sure the code for each button will be the same apart from the cmd button reference number/name and the link to the file to be played.
If we assume all the videos are called as per their buttons i.e. Video 1.wmv, Video 2.wmv ... Video 10.wmv; and the location of these files is under 'C:Films', can someone post up some code for button 'Video 1' making it clear which variables to change for linking to the different files.
View 6 Replies
View Related
Mar 31, 2004
I am currently trying to create a database of products for my company. For each product I would like to include an image associated with it. I then want to have on another sheet a place where the user will click an error and be able to cycle through the products. As tehy cycle the associated image will pop up.
What I need to understand is after importing the image into excel, how do I associate that image to a cell so I can reference it in another sheet of the database. I am not concerned with how large the database will get, my pictures are quite small.
View 4 Replies
View Related
Nov 7, 2008
I'm trying to lookup a database named database and return a time in column A, based on criteria in cells a1 and b1 on another sheet, A1 would contain a number and B1 would contain a day from mon-fri
eg of Database
A B C D E F G
10:00 5000 Mon Tues
11:00 5000 Wed Thur Fri
and so on
if a1= 5000 & b1=Wed
how can I return 11:00
I have tried index and match =index(a:a,match(a1&b1,b:b&e:e,0))
View 9 Replies
View Related
Oct 17, 2013
I've used a countifs, but I'm having trouble doing a sum in a similar way. I have 2 databases and I will try to explain below. I need the to sum the values of database 1 if the second database is >= 20. So the value I would expect on this example would be 900. I would also like to be able to highlight which ones are elliminated. Such as coloring the text red.
Database 1
Eric 100
Jenny 200
Gina 300
Doug 400
Database 2
Eric 18
Jenny 20
Gina 34
Doug 55
View 5 Replies
View Related
Sep 18, 2009
I am working on a Random Cycle Count Generator that provides random SKU#s based on 3 separate columns of SKU listings. The user clicks a button to generate the SKU#s to cycle count for that day. What I would like to see is a date stamp in the columns next(B,D,F) to the referenced SKU listing(A,C,E) based on which SKU#s are generated. This will let me see the last date that the SKU was generated. I would also like it to automatically save after generating.
View 2 Replies
View Related
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
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
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
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
Apr 11, 2009
I’m 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 I’m 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 aren’t showing up like there suppose to do.
View 10 Replies
View Related
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
Feb 15, 2013
I found this spreadsheet on here and I have been trying to customize it to what I need. I am trying to have scores from skins match highlighted. I want only the minimum score to be highlighted but if there is another duplicate minimum score I don't want it to highlight anything. I also need to find a way to count the skins won by each player and have it off to the side.
For those not familiar with golf a Skin is a game where you try to get the lowest amount of strokes on a specific hole. Ex- 4 people play the hole one. P1 scores 4, P2 gets a 3, P3 and P4 get 6. The skin would go to P2 who has the lowest score on that hole.
Highlight lowest number in each column not highlighting if there are duplicates starting at L6 down to L11 and for each column till AC. And the same for the group just to the right on attached file.
On row 13 and 14 it tells me who won a skin. I want to tally up the total skins won by each player. so if Joe's names shows up twice on R14 I want it to tell me somewhere in the sheet Joe = 2
View 6 Replies
View Related
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
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
