Before you consider placing a bid please make sure you are fully capable of completing this 100%.
Due to two programmers running away after completing such a little then realizing they can't do it – Full payment will only be made once the project is 100% complete. This is a small project though and really shouldn't take too long.
This project is for personal use only and consists of two parts.
1. The streaks workbook.
- The main objective behind this work book is to work out statistics.
- The info will be pulled from each individuals team link such as [url removed, login to view]
- The table headed Year-to-date games is the one we are focusing on for now. You can see next to each match there is either a W for Win, D for Draw or L for Loss.
- Our aim is to pull that information into either excel or a file of sorts.
- We will then need a sheet to load all the stats into which needs to look something like this
- Team Name LSW HSL LAST 10
Man Utd 9 2 WWLLDWWDWW
- Team name is the list of names.
LWS - longest win streak, is the most amount of times W occurs in succession.
HLS - highest loss streak the most amount of times Lost in succession.
Last 10 - the last 10 results with the far left being the latest.
- I will then need a sheet where I can load any team I want and add them to this table. If you look at the link – every team has a teamid at the end – Man UTD is 10260. So if I could just add that number and the team is loaded into the table above.
- I'll then need another sheet where I can view only certain teams that pass certain criteria. The statistics sheet. Where I can chose to see a list of teams where the LWS is > 9 and the HLS < 2
- So basically that is the first part of the project.
2. The second part is the Schedule.
- I have literally completed this. I just need formulas for 2 columns.
- I will send this sheet when you are ready. It is to do with the same team links [url removed, login to view] but a different table. Further down that page there's another table upcoming matches.
- On the spreadsheet I'll send you – just need to add the name of the opponent and if they playing Home or Away.
Please read through this carefully and make sure you understand all the points and what I need from you. Also make sure you understand the terms at the top of this project description