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


ADVERTISEMENT

Excel 2010 :: Creating Bell Curve?

Jul 29, 2014

I want to create a bell curve for my team's annual appraisal. There are 12 people in my team. The scale is 1-5, where normally rating range from 2.9 to 4.0.

View 1 Replies View Related

Excel 2010 :: Creating VLookUp Function In VBA

Dec 28, 2011

Im trying to write a code in vba in Excel 2010 that would incorporate the vlookup function in excel.

My Data Looks like this:

List 1Weight 1List 2Weight 2List 3Weight 3List 4Weight 4a2.00%j20.00%a14.00%p2.00%b4.00%k32.00%d2.00%y3.00%
c7.50%e10.00%g14.00%u6.00%d8.00%d15.00%h20.00%h7.00%e9.00%q13.00%y45.00%f8.00%f20.00%r5.00%q5.00%
d9.00%g35.00%n5.00%t10.00%h10.00%r14.00%i4.50%w15.00%b0.18Z0.04S0.04Total100.00%Total100.00%Total100.00%100.00%

Where I have X number of Lists, each composed of two columns. The 1st column has the name of each item in each list, and the 2nd column has the value for that item.

What I'd like to do is create a function that would let me choose two lists, and tell me the amount of items in List X and what their values are in List Y, and then total them. Also, I would like it to work the opposite way, and tell me the amount of items in List Y and what their values are in List X, and then total them.

So for example, If I wanted to look at lists 1 and 2, the function would calculate that for List 1, Items D & E are found in List 2 and have a total value of 25%. For List 2, Items D&E are found in List 1 and have a total value of 17%. For all items not in both lists, it would return values of 0.

The code I came up with so far looks like this:

Function AK_Overlap_Go(x, y)
Dim Temp(1 To 2, 2 To 1)
Dim x As Integer

[Code]...

One of the problems I'm having is that the lists contain a different # of items, and so I think I need to loop the vlookup for each row. However, I'm not sure how to do that and get the cumulative values for each list.

View 3 Replies View Related

Excel 2010 :: Creating Sound Alert

Feb 23, 2012

I would like to create a sound alert if the answer to an "if" statement is false. I am using Excel 10. Can it be done, and if so, how?

View 5 Replies View Related

Excel 2010 :: Creating A Chart With More Than 2000 Dates (each Day)

Apr 26, 2014

I am creating a chart with more than 2000 dates (each day). How can I format the axis so it only displays the 1st day of each quarter (01/01/2010, 01/04/2010, 01/07/2010...).

At the moment I cannot format the axis and minor/major units remain numbers.

I am using Excel 2010 and European date format.

View 2 Replies View Related

Excel 2010 :: Creating Random Trending Data

Aug 11, 2014

Im looking to create random data for an athlete over about 4 months with daily tests, however when im using the =randbetween(*,*) function the data is too 'Random'. so im looking to create a trend in the data, like real athletes will have. is there a function in Excel 2010 that can do this?

The boundaries of the data are -336,416 (i know its quite a big range)

View 8 Replies View Related

Excel 2010 :: Creating Reports With Multiple Conditions

Jun 24, 2014

I am creating a report where there are multiple conditions and I am using MS Excel 2010.

Summary sheet will display
Date of Completion - If the exam has been taken already
In Progress - if the exam has been started but not yet completed
Not Started - if the exam has not yet been taken

Available data in Source sheet
Completion_Date - Date when the exam was taken or "Blank" if the exam is still In Progress
Completion_Status - Completed & In Progress only (all subjects that are not in the Source sheet shall be tagged as "Not Started"

View 4 Replies View Related

Excel 2010 :: Creating Charts With Average Line?

Apr 5, 2012

How I could create a chart (standard column) with an average line in Excel 2010?

View 4 Replies View Related

Excel 2010 :: Creating Extra Sheets With Macro?

Nov 7, 2012

I have headings across the sheet "Inventory" in cells E5:AA5 with further headings down the sheet D6:D40.Data Validation drop down list is in cells E6:AA40.I want to be able to place a number 1 or number 2 in any cell in the range C6:C40 in the "inventory" sheet and with a macro create 2 new sheets.Sheet 1 will contain all the headings which had a 1 in any of the cells in the range C6:C40 and sheet 2 will have all the headings which had the number 2 from the range C6:40.Both sheets 1 & 2 will contain all the headings from "Inventory" sheet in cells E5:AA5.The data validation drop down list is not required in sheets 1 and 2 but if "inventory" sheet does get updated that it also updates sheet 1 and sheet 2.... Version i am using is Excel 2010

View 1 Replies View Related

Excel 2010 :: Creating Scatter From Multiple Columns Using Ctrl

Jun 12, 2014

I am trying to create a scatterplot from some data I have. I attempt this by selecting multiple columns using Ctrl and clicking on the letters above. This results in it plotting only the first selected column on the Y axis with only 1 2 3... on the X axis.

When I however select multiple columns by clicking on a column and dragging to more columns it does plot as I would expect with the first column as X values and the rest Y values.

I know it is possible to create a graph and add data manually but this is way slower and I think that it should be able to be done differently.

I'm using excel 2010.

View 3 Replies View Related

Excel 2010 :: Creating A Simple Line Marker Graph?

Mar 2, 2014

I'd like to create a simple graph exactly like the one on the picture, but for the life of mehow to do this on Excel 2010.This is the data I have:

Seperation First target Second target
0 59.00% 0.00%
2 64.28% 40.62%
4 62.68% 48.99%
6 60.81% 65.83%
8 61.82% 70.21%

View 6 Replies View Related

Excel 2010 :: Creating Mandatory Field Before Saving A File?

Aug 22, 2013

coding mandatory field in Excel 2010.

This is a code that i have for having a master workbook, and saving it in different folder so my employee cant access it

Sub NextInvoice()
Range("J2").Value = Range("J2").Value + 1
Range("E6:E9,H9,J9,B14:K20,H4,B28:K32,B36:B39,D36:D39,F36:F39,B42:K43,B46:K47,B50:K51,B54:K55,B58:K59,B62:K63,B66:K67,B70:K71,B 74:K75,D78:E78").ClearContents
End Sub
Sub SaveInvWithNewName()
Dim NewFN As Variant
'Copy Invoice to a new workbook

[code].....

I have found a code for mandatory cell, but it creates a second macro and i was not able to link the two.The mandatory field has drop down of employee's and it is located in the cells D78:E78.

View 1 Replies View Related

Excel 2010 :: VBA / Creating Multiple Workbooks From A Template And List Of Names?

Aug 20, 2013

The easiest way I can describe the scenario I am trying to create, is to use a company list of personnel (my index) and to generate a time-sheet workbook per person based on a pre-populated template. This time-sheet is saved as the persons name and has the persons name entered into cell D:10

I have a workbook which contains two worksheets;

1) An Index sheet which contains a list of names that I wish to use in Q16 downwards (note the length of this list will vary each time I run this)

2) A "template" sheet which I wish to duplicate in new workbooks

3) A second "data" sheet that I wish to copy across in new workbooks

I need a macro that will take the "template" and "data" sheets and copy it into a new workbook, renaming each new workbook to each name in my Index sheet. I also want that same Name to be copied into cell reference D:10 of the "template" each time.

The end result is that I should have a series of new files generated and saved which are named the same as the Index list, with both the "Template" sheet and the "Data" sheet present, with the cell D:10 pre-populated with the Name provided in the "Template" sheet.

I'm using Excel 2010.

View 9 Replies View Related

Excel 2010 :: Creating Multiple / Repeatable Lists Of Random Numbers

May 19, 2014

I am trying to create challenge/response cards. Each card will have a 5-digit number in the upper-left and lower-right corner along with a series of rows containing a line number and 3 pairs of challenge/response words.

Rather than have have copies of these cards, I want the central office to have a macro-enabled workbook wherein they can enter the two numbers from the card and have the challenge/response matrix regenerate on a worksheet.

So, essentially, I want the challenges random number generator seeded from one of the 5-digit numbers and the responses random number generator seeded from the other 5-digit number.

I am trying to use

Code:
Randomize(Seed)
where Seed is one of the 5-digit numbers.

The problem appears to be that, no matter what I use for Seed, the RND(-1) function is not resulting in different numbers.

I am using Excel 2007 and Excel 2010.

View 1 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

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

Excel 2010 :: Creating Multiple Tables In VBA And Referring To Newly Created Tables?

Jul 1, 2013

Using Excel 2010. I'm writing a macro that sets up a workbook to be used for estimating at the beginning of a project. In the code I need to create multiple tables (formerly known as "lists") in the workbook. Then later in the code I need to refer back to those newly created tables. Currently, the code that creates the table is part of a loop that creates the table on many different worksheets. The problem of course, is that I have to name the Table, and then it won't create a table of the same name on the next sheet. Then, later in the code, I need to make adjustments to the table that was just created before looping to the next sheet.

Is there a way to create a table without giving it a constant name? Or by giving it a name that builds off of other info in the sheet? For example, I would be good with the naming the table after the sheet name: "Sheet1_Table" or such.

Code:
Sub Auto_Open()
'
Dim sht As Worksheet
If Range("A1") = 1 Then

[Code].....

View 2 Replies View Related

Excel 2010 :: User-Defined Type Not Defined Compile Error When Creating PowerPoint Using VBA

Jul 29, 2014

I am using Microsoft Excel 2010 and Microsoft VBA 7.0 on my system. I would like to eventually create a PowerPoint and insert charts generated in the Excel workbook. In the meantime, I cannot get the basic PowerPoint created.

The line in red is highlighted blue when the compile error "User-defined type not defined" message box appears.

Public Sub TryAgain() Dim myPowerPoint As PowerPoint.Application
'
' do nothing for now
'End Sub

I have set the references such that Microsoft Project 14.0 Object Library is indeed checked. The Excel file only contains this code in a module. All sheets are blank. Nothing else is written yet.

View 1 Replies View Related

Rankings Draw Sheet For A Tournament

Nov 22, 2006

I have a worksheet set up as a draw sheet for a tournament. I have a set of rankings showing all points collated from last tournament. What i want to do is set up a formula/macro so that a cell containing a player eg. the winner will be found on the ranking list and the points won will be added to the next cell on the ranking list.

View 14 Replies View Related

Sum Of Pounds And Ounces For Fishing Tournament

Jan 7, 2009

I need a spreadsheet to calculate the sum of pounds and ounces. Example
3 fish caught weighing 5lb 8oz plus 3lb 8oz plus 2lb 8 oz = 11lb 8Oz.

This calculation is when the weigher has a scale that measures in OZ.
I also need a spreadsheet that will take a scale that measures in 10ths to add lb and 10th and give a result in lb and oz?

View 9 Replies View Related

Adding Video To A Spreadsheet?

Aug 16, 2005

Ive been having trouble inserting an avi clip into one of my test spreadsheets i have no problem actually inserting it using< Insert-object-media clip then insert the clip and saving, plays on my computer no prob but when i email it the file is large so i figure its there, the other person cannot open the file when they click the picture present they get a menu as to what clip do you want to play and broswe to find it

View 1 Replies View Related

Macro VBA Code To Run Video File?

Nov 14, 2011

What line of code do you need to include in you macro vba code to run a video file?

View 4 Replies View Related

Insert Video Clips From Folder

Nov 9, 2008

I have been looking at the ShowFilePicsDemo.xls from www.contextures.com written by Ron Coderre. This spreadsheet and macros allows a user to choose from a list a picture by name, and the macro references it with the location of the file, the opens the file and the picture appears in a specified range of cells on the spreadsheet.

I was hoping to use it but with very short clips (2-3 secs) as I need to go through about 350 clips one by one to look at oddities on them. I have manually started a macro to insert the video clip in the sheet using the tip given on a thread in this forum called "Playing a video during the presentation" where all the steps are explained. When I reread the macro however, the clip is embedded as an object and loses its identity which means that the macro has no reference to the location of the file which could be used for the next clip.

View 7 Replies View Related

Tournament Spreadsheet (flexible Number Of Players And Payout Percentages)

May 10, 2014

I'm trying to figure out a simple spreadsheet that can spit out tournament payouts based on a flexible number of players (we might have 55, 60, 100) and flexible percentages based on the pot size (if we have 100 players, we would like to pay more players than if we had 50).

Something like [input number of players] [input pot size] [input # of payouts] [input percentage of each payout] it would just save a ton of time as we're trying to calculate payouts on the go.

View 5 Replies View Related

Bracket Tax Formula

Dec 12, 2007

I am working with a income statement in excel, and I need to calculate the tax rate on Net Income. I have to calculate this with both positive and negative net income, and insert this into the cell below net income. I also have to account for different tax rates.

$0$7,500 10.0%
7,500-30,650 15.0
30,650 74,200 25.0
74,200154,800 28.0
154,800336,500 33.0
336,500 and up 35.0

View 3 Replies View Related

Meaning Of Bracket Notation

Feb 9, 2007

The following code was posted in another thread:

Private Sub UserForm_Initialize()
Dim a, v, x, ws As Worksheet
Set ws = Sheets("Scheduled Courses")
a = ws. Range("a2", ws.[a65536].End(xlUp)).Value
With CreateObject("scripting.dictionary")
For Each v In a
If Not IsEmpty(v) And Not .exists(v) Then
.Add v, Nothing
End If
Next
x = .keys
End With
With Me.ComboBox1
.Clear ' clear the listbox content
.List = x
.ListIndex = 0 ' select the first item
End With
End Sub

How are the brackets used in the 4th line? I have not seen this notation before. Is this some kind of a shorthand for a Range("A65536") reference?

View 4 Replies View Related

Calculate Bracket Commission

Sep 5, 2007

I have been thinking about this for a few days and have no idea where to start.
The commission scheme pays like this:

upto $40,000 in sales pays 30%
$40,001 to $80,000 pays 40%
$80,001 + pays 50%

Also, the sales person will only earn commission once they have invoiced 1/3 of their basic salary. Example

$60,000 must invoice $20,000 per month, therefore commission is actually 30% of the remaining $20,000.

I want to create a spreadsheet that allows me to enter the basic salary for individual sales persons and their individual sales figures to calculate their gross commission and also their gross basic salary if I can.

View 3 Replies View Related

Determine Hours Per Time Bracket

Nov 3, 2013

I am trying to create a spreadsheet to determine hrs per time interval

i.e
06:00 - 14:00
14:00 - 22:00
22:00 - 06:00

So a start time of 06:00 and finish time of 14:00 would show 8hrs in first interval and 0 in the other 2 and a start time of 10:00 and a finish time of 18:00 would show 4hrs in first interval and 6 in second and 0 in last

I've currently got start time in A1 , finish time in B1 and want hours for interval 1 in D1 , interval 2 in E1 and interval 3 in F1.

View 2 Replies View Related

Remove All Bracket & Data.answer

Oct 26, 2009

i need to remove this all bracket & data.answer should like this.

ex-
column "A"
AS-18881(C-8567)
SP-25768(G-856)
AS-25687(C-687)

ex-
column "A"
AS-18881
SP-25768
AS-25687

View 9 Replies View Related

Cmd Button Code To Display Video In Windows Media Player Object In Spreadsheet

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







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