F1 prediction

N

NELG10

New Member
Joined
Sep 20, 2014
Messages
5
Hi, I would like to run a simple formula one prediction game next year and would like to use the last remaining races to trial what ever I get together.

setting the bar low I think, but I just what a top 8 prediction.
8 points for correct position then one point less for out of position, ie: predicted lewis hamilton 3rd and he finished 8th, so there for you would get 5 points.

have set the drivers names in a column (1-8) then the next column would just like to enter actual finished position and excel fill out points in separate cell.

have search for the formula with no success.
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Sort by date Sort by votes
NELG10,

Welcome to MrExcel.

Is this what you want....

Excel 2007
ABCD
1PredictionDriverFinishedPoints
21Snakehips10
32NELG1142
43Lewis Hamilton85
54Roadrunner51
65Ping G523
76Stirling Moss33
87My Daughter70
98My Wife62
Sheet6
Cell Formulas
RangeFormula
D2=ABS(C2-A2)
 
Upvote 0
Snakehips said:
NELG10,

Welcome to MrExcel.

Is this what you want....
Excel 2007
ABCD
1PredictionDriverFinishedPoints
21Snakehips10
32NELG1142
43Lewis Hamilton85
54Roadrunner51
65Ping G523
76Stirling Moss33
87My Daughter70
98My Wife62

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet6​

Worksheet Formulas
CellFormula
D2=ABS(C2-A2)

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>
Click to expand...

spot on, just for instance predicted 1st comes in first you would gets 8 points. but if predicted 1st and came 8th only 1 point. just to throw it in, if they finish outside the top 8 nill points.

Thanks for responding be trying to get this nailed all afternoon.
 
Upvote 0
NELG10 said:
spot on, just for instance predicted 1st comes in first you would gets 8 points. but if predicted 1st and came 8th only 1 point. just to throw it in, if they finish outside the top 8 nill points.
Click to expand...

So are you ok to formulate the above?
 
Upvote 0
Tony, I admire you for placing yourself 7 places above the wife (till she sees it anyway).
 
Upvote 0
Hi, if I have predicted snakehips 1st ,then it comes in 1st, it should be 8 points not 0.
When I said spot on was referring to the general look of the sheet.
 
Upvote 0
@MARK,

Yep, on reflection, a bad move!!!
She has seen it and as a consequence my right eye is closing fast.

I've asked her to finish off this post whilst I go to see if there's any steak in the fridge.....

*****
@ NELG10,

Is this it..
Excel 2007
ABCD
1PredictionDriverFinishedPoints
21My Wife*****18
32NELG1142
43Lewis Hamilton63
54Roadrunner51
65Ping G523
76Stirling Moss33
87My Daughter78
98Snakehips88
Sheet6
Cell Formulas
RangeFormula
D2=IF(A2=C2,8,ABS(C2-A2))


Hope that helps
Regards Mrs Snakehips ****
 
Upvote 0
Snakehips said:
@MARK,

Yep, on reflection, a bad move!!!
She has seen it and as a consequence my right eye is closing fast.

I've asked her to finish off this post whilst I go to see if there's any steak in the fridge.....

*****
@ NELG10,

Is this it..Excel 2007
ABCD
1PredictionDriverFinishedPoints
21My Wife*****18
32NELG1142
43Lewis Hamilton63
54Roadrunner51
65Ping G523
76Stirling Moss33
87My Daughter78
98Snakehips88

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet6​

Worksheet Formulas
CellFormula
D2=IF(A2=C2,8,ABS(C2-A2))

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>



Hope that helps
Regards Mrs Snakehips ****
Click to expand...

Hi think its getting there, still not fully working, as what I was after is, say you predict all 8, in the correct postion, you would get 64 points, and on the chart above for instance
NELG11 was predicted 2nd and result was 4 there for 2 places from correct position so should recieve 6 points
I appreciate you help on this

Glen
 
Upvote 0
I think this does what you are looking for:

Excel Workbook
ABCD
1PredictionDriverFinishedPoints
21Snakehips Wife18
32NELG1146
43Lewis Hamilton65
54Roadrunner57
65Ping G525
76Stirling Moss35
87Snakehips Daughter78
98Snakehips220
Sheet2
 
Upvote 0
Well done Form.

Looks like Mrs Snakehips stuffed that one up whilst I was incapacitated.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question
Use formula in sports analysis to check accuracy of predictions which involves if one negative number is more negative than another negative number
Replies
4
Views
438
Micron
M
H
  • Solved
Complex tiebreaker
Replies
7
Views
288
HorizonHunter
H
T
  • Question
Macro to quickly check compliance breaches.
Replies
0
Views
285
Tezzadactyl
T
H
  • Solved
Delete all rows including cells in column "A" that are identical to the values in cells "D1", "E1","F1" and "A6".
2
Replies
10
Views
251
Peter_SSs
Peter_SSs
G
  • Question
Embedded Range or Array Lookup
Replies
5
Views
348
Fluff
Fluff

Forum statistics

Threads
1,214,605
Messages
6,120,476
Members
448,967
Latest member
visheshkotha

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top