Simulating A Tennis Game?

Mar 18, 2014

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)

View 5 Replies


ADVERTISEMENT

Simulating A LIKE Or CONTAINS Function

Feb 9, 2009

If I have a column with records of text (approximately 15 words each record) and I want column B to display TRUE or FALSE (or a paramter of my choosing) if it contains a word of my choice how do I do this? Is their a way of simulating a LIKE or CONTAINS function in excel.

View 3 Replies View Related

Simulating The ALT+DOWN ARROW Shortcut

Mar 31, 2009

Simulating the ALT+DOWN ARROW shortcut. I came up with the hereunder code.

View 4 Replies View Related

Simulating CountIf With 2 Conditions?

Apr 23, 2013

I've come across this page around simulating a countif with two conditions. Instead of two 'equal to' statements though, one is a 'less than' statement, and something does not seem to be right - I am not sure if I am getting the syntax wrong but am currently just getting #VALUE! across all cells I try and use.

Currently I have;

Code:
=SUM(IF(Data!$T:$T=$E3,IF(Data!$V:$V&"

View 8 Replies View Related

Boggle Game

Jan 14, 2004

Has 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.

View 9 Replies View Related

Interactive Game

Apr 18, 2008

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]

View 9 Replies View Related

Flash Game Not Working

Apr 20, 2009

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.

View 4 Replies View Related

Make A Soccer Game

Feb 6, 2007

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 Related

Computer Game Database

Jun 30, 2007

I 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

View 3 Replies View Related

Simple Game Score Calculation?

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

Using Excel Data To Create A Game Schedule

Jul 11, 2013

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.

View 3 Replies View Related

Spreading Text List For Bingo Game

Feb 1, 2009

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.

View 9 Replies View Related

Lookup Next Game Based On Current Date

Apr 3, 2008

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 Related

How To Make Simple Card / Board Game In Excel

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

Spreadsheet To Manage My Players In A Virtual Sports Game

Dec 13, 2007

I 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.

View 9 Replies View Related

Find Latest Delay Position Of Each Number Which Is In The Game

Mar 31, 2009

Find latest delay Position of each number which is in the game

View 9 Replies View Related

Excel 2010 :: Creating Bracket For Video Game Tournament

Nov 11, 2013

I'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.

View 1 Replies View Related

Toggle Design Mode Code: Change The Game Using A Drop Down?

Jul 28, 2009

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 Related

To Create An Auto Bingo Game For My Kids Which Randomized The 5 By 5 Grid

Dec 8, 2006

I 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 Related

Game Points Bank Account (running Total For The Bank)

Nov 5, 2009

Sheet6

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

View 9 Replies View Related







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