Soccer Pools Coupon

Gentle People,
It is the start of a new soccer season in the U.K. and a group of my friends want to do a weekly pools coupon. We will pick five games from the Premiership and predict four results; Home Win (HW) (3pts) , Away Win (4pts), No Score Draw (NSD) (1pt) and Score Draw (SD) (2pts). Additionally you get one point for every goal scored and you get deducted one point for every goal conceded. The competition would run for the entire season with one overall winner but there would be a monthly winner also. All would be based on points accumulated.

I thought I could do this, somehow, in Excel but my know how has limited me somewhat Would there be anyone out there who could guide me on the path of enlightenment
Regards,
Seamus

You can change the number of points if you need. Just fill in columns A-D with the appropriate information for each game and it will calculate. Right now I have fake data in as an example.

Enjoy!