- #Crew hours spreadsheet download#
- #Crew hours spreadsheet free#
Under Column C there is the heading Pos and a little pull down arrow to the right of that. 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.
#Crew hours spreadsheet download#
Click here and you will be taken to a page containing the spreadsheet – you can then download the document you are taken to by clicking on the spreadsheet. First, we need to download the spreadsheet. Now let’s see how we use the spreadsheet in practice. the actual value of each player (this is the price you pay divided by 1.9). overall statistics of each player (att + def divided by 2, and then rounded down – particularly useful for midfield players). In addition, the spreadsheet provides two extra columns not included on the scoutlist page : 
The spreadsheet enables you to sort your options by price, age, player position, country or club. But the majority of us have a certain amount of money to spend and we’d like to see who we can buy for that cash – we may well end up scouting someone we’ve never heard of ! However, the drawback of the scoutlist in a webpage format is that it is very difficult to view your options – okay, some of us may have a specific player in mind, so it’s simply a case of pressing CTRL and F keys together in your browser program to find him. This feature is only available to season ticket holders, but it’s well worth the small amount of money you pay for a season ticket (less than 4p per day) for this extra feature alone, let alone the other extras you get. The scoutlist page contains a list of all 2,000 European, North & South American, Middle Eastern and Asian players who can be brought to your club by using the Scout feature.
What makes this spreadsheet better than the scoutlist page at OFM ? On this page you can download the Online Football Manager (OFM) scoutlist, correct at 8 September 2008, in Excel spreadsheet format, as well as find out what you can do with it.
0 kommentar(er)
