Points System Using Nested Ifs
Jun 12, 2006
I am trying to work out a point scoring system and have the following formula =IF(OR(C9="",F9="",'Winning Scores'!C7="",'Winning Scores'!F7=""),0,IF(C9+F9='Winning Scores'!C7+'Winning Scores'!F7,"3","0")+IF(OR(AND(C9>F9,'Winning Scores'!C7>'Winning Scores'!F7),AND(AM!C9<AM!F9,'Winning Scores'!C7<'Winning Scores'!F7)),1,0))
Which is basically saying that if C7 and F7 = C9 and F9 in the 'winning scores spreadsheet, to give 3 points but it is returning 3 points if C7=F9, and I only want it to relate to C7 - do you know how I would do this?
I also need to award 1 point if the highest score is chosen but not if the exact score, hence if the score was '3' '2' and the person chose these exact numbers 3 points would be awarded but it they chose '3' 1' only 1 point would be awarded as they chose the winning team
View 5 Replies
ADVERTISEMENT
Jun 27, 2007
Currently I'm working on a prediction game using excel. Can excel do the tabulation itself(Points awarded) if I just key in the result? Can anyone help me? Thanks in advance.
Examples below,
Result 3-1
Name Predicted Scored Points
Alex 3-1 5
Brian 4-1 4
Charlie 2-0 3
Derrick 3-3 1
Eric 0-2 0
Point System:
1 point for correct goals/no goal by either both teams
3 points for correct result ( Win, Lose, or Draw - say result is 3-1, 3 points if you predicted a Chelsea 2-0 win)
5 points for correct match results
No points for incorrect score and results.
View 14 Replies
View Related
Nov 15, 2009
I m trying make a spreadsheet up to fine the following i have also included a file
raymond ran 11 seconds so he gets 150 points which is .6 of a second better than his Personal best time (PB's) but matt ran 13.6 seconds but it is 1.1 seconds slower than his Personal best time so he is minus 275 for every .100 of a second they get 25 points added or taken off
View 2 Replies
View Related
Apr 23, 2007
Have used excel for a while but never the need to go past SUM or AVG, etc.
Im trying to set up a point scoring sytem for 3 teams in various events. the highest scoring team would get 2 points, 2nd place 1, 3rd place 0. If 2 teams tied for first they both get 2. If they tie for second they both get 1. I spent 30 minutes before I came up with
=IF(AND(B3>B4, B3>B5),2,0)
and
=IF(OR(B3=B4, B3=B5),1)
Spent another 15 trying to figure out how to put the 2 together. Finally realized a)Im missing a whole bunch of formula, b)There is a lot more to excel than I thought I knew.
B3,B4,B5 are the teams scores. Looking for any help at this point. Even a push in the right direction.
View 6 Replies
View Related
May 2, 2007
Is there a way of amending the following line of code so that it selects multiple data points in a data series in a chart (e.g points 14,15,16)?
ActiveChart.SeriesCollection(2).Points(14).Select
View 2 Replies
View Related
Mar 12, 2008
I'm trying to create a lesson booking system,
View 11 Replies
View Related
Nov 23, 2013
Im looking for a ELO rating. Its a system which they often use with Chess.
View 3 Replies
View Related
Oct 19, 2009
Wondering if there is a formula for Excel that could replicate a numbering format like in Word?
Example:
A1.1.
A1.1.1.
A1.1.2.
A1.2.
A1.2.1.
A1.2.2.
A1.3.
and so on...
Idealy I would like to go farther than the 3rd level.
View 6 Replies
View Related
Feb 20, 2007
Below is a formula that links other worksheets from other workbooks to cell B4. If I copied this to another computer system in My Documents that is named other than Tom would the links get updated to that system. If not is there a macro that can handle this to be updated to another computer system.
=('C:Documents and SettingsTomMy DocumentsHORSESHOE MASTER SCOREBOARD[2007 HORSESHOE SCOREBOARD TO 15 PTS. ANDREA & ROGER''S.xlsm] PAID UP '!B4)+('C:Documents and SettingsTomMy DocumentsHORSESHOE MASTER SCOREBOARD[2007 HORSESHOE SCOREBOARD TO 15 PTS. DAVE & PAULA''S.xlsm] PAID UP '!B4)+('C:Documents and SettingsTomMy DocumentsHORSESHOE MASTER SCOREBOARD[2007 HORSESHOE SCOREBOARD TO 15 PTS. DAVE DUVAL''S.xlsm] PAID UP '!B4)+('C:Documents and SettingsTomMy DocumentsHORSESHOE MASTER SCOREBOARD[2007 HORSESHOE SCOREBOARD TO 15 PTS. PHIL & YVETTE''S.xlsm] PAID UP '!B4)+('C:Documents and SettingsTomMy DocumentsHORSESHOE MASTER SCOREBOARD[2007 HORSESHOE SCOREBOARD TO 15 PTS.
View 9 Replies
View Related
Apr 19, 2007
how the Process to solve the following problem:
1A = 15x + 32y + 5z
1B = 6x + 2y + 8z
1C = 3x + 11y + 19z ...
View 9 Replies
View Related
Aug 26, 2013
We have 100+ clients. Each client has inventory in our warehouse. Every day we write down how many items went out to our client on a piece of paper and subtract that number to get a balance inventory. When we run low, we order more on a new FO number. What is the best approach for tracking this? I was thinking one way is to put our clients in a drop box at the top of the page and then the data will appear at the bottom, however I can't get that to work. I am trying filters to see, but I am unable to subtract the balance automatically from the last FO# and from the correct area.
Is there a way to choose a client and product at the top of the page and have the tracking below?
View 5 Replies
View Related
Jan 3, 2014
I am looking to create a system to measure KPI (key performance indicators). I need to include a weekly target and then measure performance for that week against the target. I want to create a form to make data entry simple, how best it would be to implement using excel. Would I have 2 tables, one for targets and one for performance and then use look ups.
View 9 Replies
View Related
Feb 28, 2007
Ive got an example below of how i'm sorting fixtures and how to determine winners/losers and draws.
******** ******************** ************************************************************************>Microsoft Excel - Book2___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutF1G1H1F2G2H2F3G3H3F4G4H4=
ABCDEFGH102/03/2007Team*A**Team*B000202/03/2007Team*C**Team*D000309/03/2007Team*A**Team*D000409/03/2007Team*B**TeamC000Sheet1*
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
What I'm struggling with is the ability to change dates and still be able to add the teams figures up.
When adding, for instance, Team A's wins I'm using
=f1+f3
and similar for defeats and draws.
But when I change dates, for instance game 3 to the 10th, Team A is still counting F1 and F3 yet its games now in row 1 and row 4.
How can i get it to change with the sorting.
Im sorting fixtures via the sort feature in data.
View 9 Replies
View Related
Oct 6, 2007
I have a button in a template file (.xlt) that will save the file as the customer name in cell C4. That template file feeds an Access database and when you save the template file you are prompted with the following system message:
If record DOES NOT exist in DB:
If record DOES exist in DB:
My code is as follows: ....
View 9 Replies
View Related
Jan 10, 2008
In MS Query:
Like '%ST%DF%'
Works fine.and returns:
DOCIDREVISION
31ST-9DF02007
40ST-9DF01006
73ST-9DF01016
74ST-9DF01011
74ST-9DF02004
I want to use the [Enter system] for the DF part.
When I try to use the following in MS Query:
Like '%ST' & [Enter Sys] & '%'
the pop up window appears but after entering DF
I receive an error: Missing Right parenthisis or illeagal variable?
View 9 Replies
View Related
Feb 25, 2009
How do I add the system time to a file name
My
ChDir "S:ProductionProduction Request Forms"
ActiveWorkbook.SaveAs Filename:= _
"S:ProductionProduction Request Forms" & SaveWorkbook & "_Request" & Time & ".xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
View 9 Replies
View Related
Mar 3, 2009
The macro below will generate a System Error '-2147417848 (80010108)' when executed as shown below but only when there is a value in the 6th column that ends in .0006(or .00061). It will however run if no empty cells are present after the cell with .0006 in the 6th column (i.e. J = 1 to 6). This can be avoided by using the "On Error Resume Next". What is strange is if the value ends in anything other than .0006(or.0061) in the 6th column it will work fine (i.e. .00062 or .0005).
In a new workbook I have the following values in A1:B6
1125924.4684333.2496895-1217.935514LOFT -1785884.895
2422123847.627 221.0003 -482.8184125LOFT -1698521.0006
The Macro:
Sub Macro1()
'
'
'On Error Resume Next
Application.Calculation = xlCalculationManual
Set OldWb = ActiveWorkbook
Set NewWb = Workbooks.Add
Application.ScreenUpdating = False
For I = 1 To 2
For J = 1 To 7
NewWb.Sheets("Sheet1").Cells(I, J) = OldWb.Sheets("Sheet1").Cells(I, J)
Next J
Next I
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub
View 9 Replies
View Related
Apr 17, 2009
I am trying to get the username from the system to display in A1 in a file in Excel. I got this code form internet and put it in the sheet by clicking right mouse on the sheet1 tab and view code and then pasted it there.
Function UserNameWindows() As String
UserNameWindows = Environ("USRNAME")
End Function
And then as per the instructions on the same page I inserted this formula in A1 : =UserNameWindows()
The person stated that by doing this, I should be able to get user name displayed in A1. BUt all it gives me is #NAME?.
View 9 Replies
View Related
Jul 27, 2006
I'm currently studying japanese and I need to make a flashcard system so that I can memorise words a lot faster. An old friend told me that it is possible to make a flashcard system in excel (or maybe Access due to its database system - I cant remember which sorry). I'm looking at a basic system that first shows me the japanese - then i click it and it reveals the english, click the english and it then moves onto the next japanese word etc etc. Though, I have no idea where to start in building such a system, my excel knowledge is not great but it I'll give anything a try
View 2 Replies
View Related
Feb 14, 2007
how the "File System object" works in Excel?
I have a various information in one log file, which need to import to excel. So it's i need to declare all fields i need?
View 8 Replies
View Related
Mar 27, 2007
I am trying to create a spreadsheet that will automatically create a ranking system after data is input manually.
If you look in the example, you'll see roughly 30 people will be ranked on various metrics, and on another sheet, I would like 1-30 to be displayed in each of the different metrics, thus creating a ranking.
I'm not sure how to go about doing this, and any help would be greatful. I've tried different excel tutorials and searched and searced the help features, but couldn't exactly find what i was looking for.
View 9 Replies
View Related
Jul 13, 2007
I've got this code that I use to open the active session of a program I use (EXTRA! 8.0). When I try to code it to open a specific new instance of the program, I get a run-time error 429. When I debug, it's stopping on the line where I get the new instance. I've searched on this issue, but I still don't understand what the problem is.
Sub log_in()
Dim Sys As Object
Dim Sess2 As Object
Dim lngOldSysTimeout As Long
Set Sys = CreateObject("EXTRA.System")
If Sys Is Nothing Then
MsgBox Prompt:="EXTRA! not properly installed on this PC." _
& " Terminating execution.", Buttons:=16, _
Title:="E!PC Not Properly Installed"
Exit Sub
End If
Set Sess2 = GetObject("C:Program FilesExtra!sessionsCCS2.edp")
If Sess2 Is Nothing Then
MsgBox Prompt:="DLC.edp not found. Terminating execution." _
, Buttons:=16, Title:="E!PC Not Properly Installed"
Exit Sub
End If
End Sub
View 2 Replies
View Related
Mar 8, 2008
how can I detect the OS of the computer a sheet is running on and launch a macro accordingly?
I have built a calculator that utilizes an embedded wave file but doesn't work correctly with Vista. With Vista it actually causes WMP to be launched instead of just playing the file. So I was hoping to be able to skip the sound on Vista machines but play for all other OS's.
View 3 Replies
View Related
Jul 1, 2014
I have a big system of data, me not knowing better i have it such that the categories is listed in the start of the row, and new data for periods are listed in the columns following. when i mark the data and click table, it puts the scroll down thing on top of the columns, which is of no use to me at all, i need them at the start of the row. is this possible, or do i need to reorganize all the data, and VBA code used to sort and collect it ?
View 7 Replies
View Related
May 8, 2014
I am making an Excel calculation system where I have two factors (weight and opening length), which is essential for which lift there is possible to use.
There are 8 models each of which may have some limitations in terms of weight, and the opening length:
ModelPushing/pulling Force (KG)Stroke Length (mm)
HCV 130 350
HCV 230 600
HCV 330 800
HCV 430 1000
HCV 550 350
HCV 650 600
HCV 750 800
HCV 850 1000
What I am looking for is a formula, that when you enter numbers in two cells "Weight" and "Opening distance" of what their platform is to meet, then all the models that have the potential to accomplish this task pops up.
Example: A client writing a weight of = 40 kg and opening length of = 450 mm. The formula should then show which model that meets the requirements.
In this case: Models that meet the requirements for the lift.
ModelPushing/pulling Force (KG)Stroke Length (mm)
HCV 650 600
HCV 750 800
HCV 850 1000
View 5 Replies
View Related
Feb 12, 2013
I have a system of 3 equations with 3 unknowns that I would like to solve in Excel.
The equations are
24.792 = A*e^(B/(100-C))
9.857 = A*e^(B/(70-C))
4.590 = A*e^(B/(40-C))
Where e is the exponential function.
View 7 Replies
View Related
Mar 22, 2014
I have a challenge in excel functions, I need to save a file as common folder but in that workbook have multiple sheets need to show the sheets as per the user name on system other sheets want to hide with password protect,
example,
file name:- Report
Sheets:- A,B,C,D
if now using system user name is A then need to show only "A" sheet, other sheets want to be hide and the same for all.....
View 2 Replies
View Related
Mar 18, 2007
Just starting to use excel and have a problem I hope someone can solve. Trying to set up handicap system for golf league. Column A is players. Column B shows average of last 5 rounds played and rounded to nearest whole number. column C shows the same without rounding. column D and beyond show scores with column D being the most recent. Have this all this working well with one problem. Each week I insert new column D, enter scores, and everything is recalculated. How do I deal with absent players? Is there a way to enter perhaps "A" for absent and excel will know to count the last 5 cells with numerical values only?
View 14 Replies
View Related
May 14, 2009
I have Given Name for Data Column as Below
[Data_Table=OFFSET(Data!$A$2,0,0,COUNTA(Data!$A$2:$A$28),COUNTA(Data!$1:$1))]
Now If I delete Raw 2 System is giving Error #Ref!
I may have to delete Raw-2 frequently
View 4 Replies
View Related
Dec 2, 2012
There are many software solutions for clinical information systems, but they all cost a lot. It occurred to me that a bespoke system could be build using excel.
View 1 Replies
View Related
