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.
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]
Im using xl2003.
I'm simply trying to divide column A by column B in column C. However in my field of data A and B are sometimes zero values that return a #DIV/0! answer in C.
Without introducing and more columns how can i eliminate this error value?
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 RelatedHas anyone created this game for Excel?
It's a game where you locate words in a 5 row by 5 column grid of letters where letters forming the words must be adjacent to each other.
Seems like an interesting project.
I am looking for interactive mathematical kid's game that can be created in Excel. Can someone please help me create one or direct me to a sample?
I saw one example below but this is not excel based. Can a similar one be created in Excel?
[url]
when I am trying to open them. they are not opening. When opening excel with flash game, there is big black square box. When opening power point with flash game, it is giving error "Some controls on this presentation can't be activated. They might mot be registered on this computer"
Flash objects on by browser when surfing site are working perfectly fine. i have also re-installed fresh flash from adobe site, but no success.
having trouble creating a function which does the following:
1. acknowledges the current server as a parameter (which has been randomly chosen by code i've already written)
2. generates the winner of a particular point according to pre-designated statistics
(pre designated stats are:
(a) prob of first serve being in
(b) prob of winning point on first serve
(c) prob of second serve being in
(d) prob of winning point on second serve
(if first and second serve are both out then the other player wins the pt)
3. simulates a whole game of tennis (player x serving throughout the game) and returns a winner (player x or player y)
4. then simulates a whole set
5. then simulates a match (first to 3 sets)
I would like to make a soccer game in excel, there are two divisions of eight teams, and 77 non league teams. I want to be able to enter the teams and then randomdly do the fixtures and when that is done i would like to be able to enter the scores and on another worksheet have the table.
View 3 Replies View RelatedI want to make a computer game database with excel, but do not know how to start..
i want to be able to enter the name, publisher, year, system and genre i.e.
Name ? A Game
Publisher ? Pub
Year ? i would like a drop down menu to choose the year
System ? as above
Genre as above
Also i would like to be able to add a screenshot of the game if that is possible
I am trying to use Excel to generate a game schedule for my fantasy football league. Right now I handle this task manually but I figured there has to be a way for Excel to work it out.
Let's say I have 16 teams playing 16 games. I have a table written out using numbers to represent the different teams. The x-axis has one team number per column while the y-axis has a week number in each row. The intersection of any column with each row shows the x-axis team's opponent for the week. What I want to do is substitute a team name or abbreviation for the team numbers in the body of the table and then generate a formula (or script? - I'm not sure of the correct terminology) to then produce a listing of the games each week. So the output would look something like this:
Week 1
BNS v ROC
NYL v NFB
WBB v TCF
etc...
Each 3 letter abbreviation represents a team name. This would significantly reduce the amount of manual work I have to do since Excel would generate the game schedule as above for each week and then I take that information and dump it into the software I use to run the League.
I have a Text List (about 40 rows of Commercial Names) in a column. On 10 seperate sheets I make a 5 row by 5 column range (the Bingo Game) and manually copy one item from the Text List into one of the cells in the 5 by 5 range as randomly as possible until the range is filled. I've manually counted each item from the Text List's use, but it very time consuming when I add more items to my list. I'm looking for two solutions.
1. Is there a way to automatic the random distribution from the Text List into the various sheets on an equal basis.
2. Is there a way to count the number of times an item from the Text List appears in the 5 by 5 range and sum that for all 10 sheets.
I'm trying to link three cells lets call them C7, E7, and G7 to an NBA schedule. I'd like to have C7 Display the visiting team, E7 to display the date, and G7 to display the time of the game. Ideally I'd like these cells to change after the date of the previous game has passed to the next game. Is this possible? Would I need to create a separate sheet with the Visiting team, date of game, and tiem of game?
View 3 Replies View RelatedI have been working on a spreadsheet to manage my players in a virtual sports game. I have worked out that the optimum skill scores for all the positions and want a way to compare a player to the optimum.
For example:
1st2nd3rd4th5th6th7th
Position 147.1737.6742.0533.8313.6711.3317.33
These are the averages for Position 1
How do I find the player who closest matches this optimum. Players have scores in the same 7 skill areas.
Find latest delay Position of each number which is in the game
View 9 Replies View RelatedI'm trying to create a bracket for video game tournaments and I'm having trouble with some of the functionality I want it to have.
Right now, I have cells B7 and B9 that will pull player names from another check in sheet. I have another cell, D8, that I would like to have a drop down list in containing the contents of B7 and B9. Everything I see online says to use Data Validation, but apparently that tool can't make a list using cells that aren't next to each other, so that won't work. How else can I tell excel how to populate this list? It is vital that the cells be apart from each other because the visual formatting is necessary for displaying the bracket on a projector so that the players can see their match assignments.
In addition, I would like to have another drop down menu in another cell with a list of valid bracket sizes (4, 8, 16, 32, etc.), and have the cells of the sheet either be visible or invisible depending on how many max players can enter. In other words, if columns B, D, F, and H correspond to the number of rounds it will take to finish the tournament (3, 2, 1, and 0, respectively), I would like the sheet to display only the cells necessary for the tournament, pull player names into the left most cells needed from another worksheet used for sign ups, and auto populate all of the columns to the right of the column for first round with drop down lists for the players who could have won that match in the previous round.
i need some code to be able to toggle design mode, i am creating embedded flash games in excel and i want to be able to change the game using a drop down and this code:
View 3 Replies View RelatedI was trying to create an autobingo game for my kids which randomized the 5 by 5 grid. To do that I did combined a Randbetween and VLOOKUP to a table on a separate sheet which had the name of the object (i.e. "cow") in column 2 and a picture in column 3. Well, the VLookup will return the name of the object but won't return the pictures. Is there a way to get those embedded objects to move into my autobingo form? I'm thinking this requires a Visual basic macro.
View 14 Replies View RelatedSheet6
RSTUVWX5Your PointsPoints Needed To Level UpCurrent LevelYour CreditWithdrawalDepositCredit67
80You Need 18,000 Pts.IntermediateYour Credit is 0 Pts
911,5006,500BeginnerYour Credit is 0 Pts25004000
1010,4547,546BeginnerYour Credit is 454 Pts
45411125005,500BeginnerYour Credit is 1000 Pts200035001000
Spreadsheet FormulasCellFormulaS8=IF($AB$6$Q$23,"You Are Credited With "&TEXT(X8-$Q$23,"#,##0")&" Pts","Your Credit is 0 Pts")
Excel tables to the web >> Excel Jeanie HTML 4
i have a "Game Points Bank Account" that keeps track of the points users earn or spend in the game...what i need help is creating a running total for the bank..ive tried everything nothing works..
(this is actually like a traditional bank account)
each player starts with 10,000 points
*Row 8 is the only row to have formulas*
*Rows 9-11 are typed in to show my desired results*
Here is the point value "Ranking System" for Column T
Sheet6
AGAH5Tier 16Beginner180007Beginner360008Beginner540009Intermediate7200010Intermediate9000011Intermediate10800012 13Tier 214Advanced12600015Advanced14400016Advanced16200017Expert18000018Expert19800019Expert21600020 21Tier 322Elite23400023Elite25200024Elite27000025Superior28800026Superior30600027Superior325000
Excel tables to the web >> Excel Jeanie HTML 4
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 Relatedi 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.
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
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).
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 RelatedI 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 RelatedI 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.
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.
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.
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 RelatedTrying 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.