Tracking the premier league re****s in a legue table each week.

[MrPink1986]

Hi,

I have what seems to be a very complex ask however I will go ahead with what I would like to do. Each week I would like to import the Sat and Sunday games from English Prmier league from the internet. This data will be refreshed each week.
I would then like to apply 4 points if the score is correct in the predictions tab and 1 point if the result is correct. There will be 10 sets of predictions in the predictions tab easch week.

I cannot attach the file - I can email it if anyone is up for a challenge.

Any help greatly appreciated.

 

[MrPink1986]

have decided against importing the results from the web - for now, I will update the results in to excel each week manually. I have attached the latest template and would like some help with the formuals.

The results are in the first columns. The result A,B,C I would like a formula to decide if it is either of the outcomes on the spreadsheet, based on this result it should assign the correct number of pointd based on the predictions of the guys. These points should go in to Scores box.

Would love some help on this cheers.

																		Points
																	Correct Score Prediction	4	A
																	Correct Result Prediction	1	B
																	Incorrect Result	0	C
																	Total			0	0
								Sean			Stephen			Scores
	#	Home Team	Score		Score	Away Team	Result	H	-	A	Res			H	-	A	Res			Prediction 1	Prediction 2
	1	Everton	2	-	1	Liverpool	A	2		1
	2	Man Utd	4	-	3	Man City	B	2		0
	3	Arsenal	1	-	1	Chelsea	C	2		0
	4			-
	5			-
	6			-
	7			-
	8			-
	9			-
	10			-

<colgroup><col style="width: 19pt; mso-width-source: userset; mso-width-alt: 914;" width="25"> <col style="width: 16pt; mso-width-source: userset; mso-width-alt: 768;" width="21"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;" width="83"> <col style="width: 31pt; mso-width-source: userset; mso-width-alt: 1499;" width="41"> <col style="width: 9pt; mso-width-source: userset; mso-width-alt: 438;" width="12"> <col style="width: 31pt; mso-width-source: userset; mso-width-alt: 1499;" width="41"> <col style="width: 70pt; mso-width-source: userset; mso-width-alt: 3401;" width="93"> <col style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" width="53"> <col style="width: 29pt; mso-width-source: userset; mso-width-alt: 1389;" width="38"> <col style="width: 20pt; mso-width-source: userset; mso-width-alt: 987;" width="27"> <col style="width: 29pt; mso-width-source: userset; mso-width-alt: 1389;" width="38"> <col style="width: 39pt; mso-width-source: userset; mso-width-alt: 1901;" width="52"> <col style="width: 11pt; mso-width-source: userset; mso-width-alt: 512;" span="2" width="14"> <col style="width: 29pt; mso-width-source: userset; mso-width-alt: 1426;" width="39"> <col style="width: 22pt; mso-width-source: userset; mso-width-alt: 1060;" width="29"> <col style="width: 30pt; mso-width-source: userset; mso-width-alt: 1462;" width="40"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55"> <col style="width: 14pt; mso-width-source: userset; mso-width-alt: 694;" width="19"> <col style="width: 14pt; mso-width-source: userset; mso-width-alt: 658;" width="18"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;" width="83"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 48pt;" width="64"> <tbody>
</tbody>

																		Points
																	Correct Score Prediction	4	A
																	Correct Result Prediction	1	B
																	Incorrect Result	0	C
																	Total			0	0
								Sean			Stephen			Scores
	#	Home Team	Score		Score	Away Team	Result	H	-	A	Res			H	-	A	Res			Prediction 1	Prediction 2
	1	Everton	2	-	1	Liverpool	A	2		1
	2	Man Utd	4	-	3	Man City	B	2		0
	3	Arsenal	1	-	1	Chelsea	C	2		0
	4			-
	5			-
	6			-
	7			-
	8			-
	9			-
	10			-

<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col><col><col></colgroup>