![crew hours spreadsheet crew hours spreadsheet](https://3.bp.blogspot.com/-diBH02Y1S_o/VMF2koIR80I/AAAAAAABjng/tcHGgtzgXW4/s1600/Screen%2BShot%2B2015-01-22%2Bat%2B5.05.31%2BPM.png)
For starters, let’s say we have £20,000,000 which we want to spend on a midfielder.įirst, let’s isolate all the midfielders. The best way to get to grips with the spreadsheet is to try an example. Country The country which the player is in.Team The name of the club the player is currently at – note you cannot scout players in your own league.Price How much you will pay for the player (Value multiplied by 1.9).Value How much the player is actually worth (Price divided by 1.9).Ovr Player’s overall rating (Att + Def divided by 2 and rounded down) – the higher the better for midfielders.Def Player’s defensive rating – the higher the better for defenders.Att Player’s attacking rating – the higher the better for attackers.Pos Player position : Att = attacker/striker Mid=midfielder Def=defender Goal=goalkeeper.Age player’s age at 9 April 2008 (important note – before sending the scout off always check the player’s age is right by selecting the club the player is at on the Teams and Goals page on OFM as players do have birthdays, so might have increased in age – we’ll try to upload a new spreadsheet every few months).The spreadsheet referred to in this guide is the one marked price – the age one is really for interest only.Īt the top of the spreadsheet are some column headings – these are fairly self-explanatory: Each age range then starts with the most expensive gradually working down to the cheapest. The tab marked age shows all players, with the youngest first. You will see how easy it is to isolate each player position in a moment. all attackers first, then all defenders, etc). Note that all of the players’ positions are included – the scoutlist webpage lists players by position, then price (i.e. The one marked price shows all players, with the most expensive first. You will note that there are two tabs at the bottom marked ‘price’ and ‘age’ :
CREW HOURS SPREADSHEET FREE
To open the spreadsheet you’ll need either Microsoft Office or, if you’re not loaded, the free open source program OpenOfficeįind the spreadsheet you downloaded and click on it. Alternatively (and much faster) just right click with your mouse here and then click on ‘save link as…’ or ‘save target as…’ depending on your browser.