Cricket- Working On A Cricket Score Board
Oct 4, 2007
I am working on a cricket score board in Mircorsoft Excel. This is my first question. When I solve this, I will go ahead.
In the sport of cricket, an over is a set of six consecutive balls bowled in succession. An over is normally bowled by a single bowler.
An over is made up of six balls, each ball counts for 1/6 of an over for the purposes of calculating the net run rate, despite being normally written in cricket's notation as .1 of an over. if a bowler balls 6 consecutive balls. it is called an over and writting in cricket's notation as 1 over.
My question is that Team A played their two matches. In first match, Team A played 47.4 overs and in second match Team A played 49.5 overs. The total number of overs in two matches Team A Played 47.4 + 49.5 = 96.9. But in cricket sport we will sum up it like this 47.4 + 49.5 = 97.3. I mean that Team A played 47 overs and 4 balls in their first match and in the second match they played 49 overs and 5 balls.
How can I sum up it in Excel Worksheet?
View 9 Replies
ADVERTISEMENT
Apr 25, 2007
I am trying to work out a formula to determine the maximum score a player has had in one season.
Spreadsheet has a row with say 45, 56, 23, 67*, 43 .... ( the * means Not Out ). Using the maximum formula disregards the record with the asterisk.
My other option is to store the * in a separate field next to the runs.
View 14 Replies
View Related
Apr 24, 2007
I am trying to set up a cricket spreadsheet
I cannot work out how to set up the 'Overs Bowled' column.
I somehow need Excel to recognise a figure in another format other than decimal.
There are six balls in an over so when I enter '5.5', this means 'five overs and five balls' rather than '5 and a half overs'.
View 9 Replies
View Related
Aug 7, 2009
I am organizing a golf scoreboard for my golf tournaments. Basically, this is what I want to do:
I would like to rank the players that are entered by their score, in ascending order. Basically, I want to take the column for "total strokes" and organize the numbers so that it will rank the numbers that are entered. If there are no numbers entered in a specific row, I don't want that "zero" to be ranked in the list. So for example, if I have five golfers but they are spread out over 10 rows, I would still need to have five numbers in the rank: 1,2,3,4, and 5, not 1 to 10, as if it were ranking the rows that have nothing entered in them.
This is how it will look:
Johnson - Strokes : 70 - Rank :1
Williams - Strokes : 75 - Rank : 3
Patterson - Strokes : 72 - Rank : 2
View 9 Replies
View Related
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.
View 5 Replies
View Related
Oct 8, 2011
How do i share parts of my spreadsheet on the board?
View 1 Replies
View Related
Nov 5, 2007
I run the company office pool / lottery. A person selects 6 numbers 1-49. Twice a week the provincial draw is held. if your number matches the drawn number i would highlight your number on the spreadsheet. When all of your numbers are highlighted, you win. This usually takes 3-4 draws to cover all your numbers. Ideally i would like to simply enter the drawn numbers & have excel automatically highlight the number next to each persons name if they have selected that number.
View 9 Replies
View Related
Jul 15, 2007
I would like to create a new more effective quick staffing board for work.
Name Start Time Finish Time Break Allowance Break Time 8 (then time period from 6 till 2300
BUT when I enter say a shift of say 09:00 17:00 I need this time period to block out on the board, hard to explain ...
View 14 Replies
View Related
Dec 17, 2013
I am trying to create a simple dash board using only Excel and no VBA. What I am trying to do is I want to create dependent drop downs and link up drops downs that will pull out the required data individually or with combination of those two. For example, let's say
A column has Dates of transaction,
B column has Item name
C column has Units
D column has Month name
E column has Shifts (Morning or Evening)
I am trying to make a dash board that will pull total Sum of individual items based on
Only Date wise
Datewise + shift wise
Month wise
monthwise + shift wise
I managed to create drop down list for dates, months, and shifts but i dont know the way how to link the individual drop down lists together to pull the data based on the selection. which function i should use here and how?
View 5 Replies
View Related
Jun 3, 2007
i would like to write vba to fill a "chess Board" Matrix (8X8) With Powers Of 2...
starting with 2^0 and ending with 2^63...
(i suppose, click a button/icon and have the numbers fill in/populate...)
View 2 Replies
View Related
Dec 24, 2013
I am trying to create a form in excel that simulates a chess board, the code was quite extensive so I better separate it into modules, because the program suddenly began to close, how do I do that? being that I have all the pieces of a chess game and some strings and boolean variables with information on the positions of the pieces on the form?
VB:
Private Sub A1_Click()
If Turn_Player1 = True Then
If Active = "Pawn_pr1" Then
If Loc_Pawn_pr1 = "A2" Then
[Code] .....
View 1 Replies
View Related
Jun 3, 2013
I am looking to copy a simple board game in Excel
Basically it would be a simple race. Containing 4 counters (blue, green, red and Yellow) and 10 squares each.
There would be 40 cards 10 blue, 10 green, 10 red and 10 yellow. Cards would be draw randomly and the counters move respectively. I would be thinking about starting with =RANDBETWEEN(1,10).
I have no knowledge of VBA/ macro but would welcome ideas with what formulas/ commands to use.
I have added some snapshots to show what I would be looking for.
[URL]
View 4 Replies
View Related
Aug 25, 2013
I'm making a custom BINGO board in Excel 2010 for a family reunion, so it doesn't contain numbers; instead it has words (like "has brown eyes" or "served in the military"). the first sheet is the board and looks like a traditional BINGO board with the same number rows and columns with a center FREE space. On the second sheet is the list of all the phrases I'm going to use, one phrase per cell, all in Column A.
In BINGO cells, I want it to use one item (phrase) in each box but NOT repeat within the board. I have the following code in each cell and it works EXCEPT, there is no code telling it to make each cell unique, so sometimes it may repeat.
=UPPER(INDEX(ColumnA,((RAND()*(Data!A1-1))+1),0))
View 8 Replies
View Related
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.
View 11 Replies
View Related
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.
View 10 Replies
View Related
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
View 9 Replies
View Related
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).
View 9 Replies
View Related
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....
View 9 Replies
View Related
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.
View 2 Replies
View Related
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.
View 4 Replies
View Related
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.
View 11 Replies
View Related
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.
View 3 Replies
View Related
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
View 8 Replies
View Related
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.
View 3 Replies
View Related
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.
View 9 Replies
View Related
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.
View 4 Replies
View Related
Dec 27, 2011
Column A has an assement score which reads 1,2 or 3 Columb B should have a value statement based on what it sees in column A
For example
A1 reads "1" ( which is a pass ) , then B1 should auto-populate with the word Pass.
if A1 reads "2" ( neutral ) B1 should read "neutral"
if A1 reads "3" ( fail ) B1 should read "fail"
For the advanced class; I can foresee a situation in the near future whereby the system needs to look at a range numbers, rather then one specific number.
For example
A1 could read "1" which is a pass , or "2", "3" etc are also be a pass.
4,5,6 are neutral
7,8,9 are fail
View 6 Replies
View Related
May 7, 2014
i can calculate finish "molkky" game scores?
These are rules; you get points after falling sticks (if any falls). Points are 0-?. Goal is to get 50 points. If you get over 50 points, then points go back 25 points.
As you see (attachment) Matts points are 51, so he has now 25 points.
View 2 Replies
View Related
May 14, 2014
I am trying to distribute the total number of sessions (cell H1) across the groups in column A based on the score of each group (column D). The number of sessions a group receives cannot exceed the max (cell H2) or be less than the min (cell h3).
View 7 Replies
View Related
Jun 13, 2014
See attached.PMS 2.xlsx. I have a table with data on PMS sheet and would like to have something like the example on the Example sheet using data from the PMS sheet.
View 2 Replies
View Related
