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
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.
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 Related 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 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 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.
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))
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]
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.
Find latest delay Position of each number which is in the game
View 9 Replies View RelatedI'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
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.
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
Is there a code available that can be used to get the user's computer ID number (Not Computer Name)? I'm using a password generator to randomly generate a password and I would like to use this unique password with the user's Computer ID.
View 9 Replies View RelatedI have a problem running an excel macro on different laptops because the IP needs to be known (my program links to databases that are installed on a "server" laptop). The IP can be sourced by using the "Start, Run, cmd, ipconfig" but my users can have problems with process.
Does anyone know of a vb function that will display the ip of the computer that the code is run on?
a macro to get the computer ID of the computer where the excel file is opened?
View 9 Replies View Relatedi am experiencing runtime error '6': overflow on one computer but not on another computer when it is the exact same file running on two different computers.
Is there a code or formula to get the name of my Computer?
View 9 Replies View RelatedIs there any way to return the name of the computer in Excel using VB?
Does anyone have a macro that could assign a 16-digit number, seperated by dashes, to a computer? (i.e. Computer ID: xxxx-xxxx-xxxx-xxxx)
View 9 Replies View RelatedHere's the scenario. A co-worker and I access the same file from the same online database and download it in the same manner. We have the same version of excel. We then open these identical files, we run a formatting macro (identical), but when it comes time to set the page breaks in order to get the items to print on the same page I have to increase a columns width to make it fit on one page and yet it still doesn't match theirs. It appears to have a different scale but I'm not sure of the option difference between our machines. I don't know how it could be the printer since it physically gives her different page break option than what mine does.
View 1 Replies View RelatedI have a Age calculating formula in an excell cell, which calculates the age as on another date.
The forumala is =IF(E4="","",IF($C$1="","",ROUNDDOWN(($C$1-E4)/365,0))) where E4 is the date of birth and C1 is the date in which I want the age calculated to be.
The above formula works very well on my computer, but does not on any other computer. If I access it from my sent items or from a shared drive, it works perfectly on mine, but not on any other computer!!! I get a #value error message on all other computers.
I have tried the foll:
If i enter =ISNUMBER(C1) where the age has to be calculated, I get #Name?
If I enter =ISNUMBER(E4), i get TRUE
The above is on the sheet where it does not work ( on others computer ) and i get TRUE for both on mine. Also both have the same date formats and same time zones...
I am having trouble with transferring a Macros to another computer. I have saved and sent the file via e-mail as a .xls and .xlsm to no avail and tried other methods of transferring the macros to the other computer. Also No I cannot copy paste the coding information to the other computer since there are multiple macros buttons since they are add one item and subtract one item from separate rows for inventory at a warehouse (about 100+ rows x 2 = about 200+ macros buttons).
View 1 Replies View Related