Cancelled

Need Custom Excel Spreadsheet

I need a custom Excel spreadsheet to track stats for football (soccer) teams and their players in Italy (Serie A).

Basically, I need it to do the following:

1. On the first tab, I want the standings and ranking of the different teams stats (the stats I'd like) in Serie A.

2. On the second tab, I'd like rankings of some mainstream individual player stats. In addition I'd want a sheet or something where I could select whichever player from Serie A and look at more in-depth stats I've noted for all the games the actual player has been involved in. Here it'd been great to been able to filter from which competitions/dates etc.

3. On the third tab, I'd want the fixture/result list for Serie A with a shortcut to the actual match where I can note the different happenings and stats.

4. Going forward, each of the remaining tabs should be of all the Serie A teams. Here it should also be possible to add matches for the specific team if they're playing in a European competition.

5. Teams should automatically be in alphabetical order.

Further requirements:

- THE PLAYER LIST: Should both show team, player number, player name, birthplace and time, national team, position, age and room for potential notes. Going back to the second tab, I'd like all these facts to be shown when searching for any individual player's stats.

- THE INDIVIDUAL PLAYER STATS:

~ Should contain GOALS(penalty goals, free kick goals, corner goals, headed goals, right footed goals, left footed goals, chested goals, shoulder goals, back goals, heel goals, inside the 5 metre box/inside the penalty area/outside the penalty area, match decisive goals as if the goal made the team to draw or win)

~ Should contain TOTAL GOAL POINTS (goals, direct assists, hockey assists) in additon to amount of times the woodwork was hit as well as penalties a player has earned, conceded, scored and failed to convert.

~ Should include BOOKING STATS whether it was yellow, second yellow or direct red card. Also the stats should show the reasoning for booking (if it was duel with an opponent, off the ball, hand ball, verbal irregularity towards the referee or delay of play). There should also be possible to note when and which players provoke booking in-play of an opponent.

~ Moreover the player stats should show how many times (and in minutes) a player has featured for the team in each competition and whether it was as a starter, a substitute or if he sat on the bench all the game. It should also be able to see if the team won, draw or losed the matches the player featured in and how many goals the team scored and conceded.

- THE TEAM STATS:

~Should include all the mainstream categories as well as winning stats under certain conditions (when the team scores first, when the opponent scores first, when trailed in first half, when possession is less/more than 50, when they've managed more/less shots on target and in the woodwork than the opponent, formation used etc.).

~What time of the game the team has scored/conceded, the goal type (set-piece such as penalty, free-kick or corner, established play, counter attack or cross from left/right)

~I'd attach some screen shots from my excel sheets at the moment to give you a rough guidance of how I'd expect the sheet to sort of look like. But remember, I'm all for the efficiency so please don't use the screenshots as blue prints to how you'll think it'd best work out.

- THE FILTERING OF THE STATS: For the player stats I'd like to filters such as competition, home/away/neutral, starter/substitute, time of day the game was played and which weekday it was, which position the player played in. I'd also like, regarding the ranking of the specific categories such as goals and total goal points to see which players has performed best when it comes to those stats and their total playing time (amount of goals per game/minutes per goal and amount of goal points per game/minutes needed for a goal point).

Ok, ok. Heavy info. Contact me with questions

Skills: Excel

See more: excel spreadsheet development need require, custom excel spreadsheet maker, need custom excel work done, excel spreadsheet consultant, excel spreadsheet builder, buy excel spreadsheets, custom spreadsheet services, freelance excel spreadsheet design, excel spreadsheet design service, need an excel spreadsheet, excel spreadsheet designer, need someone convert excel spreadsheet web form, custom excel spreadsheet model jobs, need excel spreadsheet customized, need create excel spreadsheet, need excel spreadsheet created, excel spreadsheet custom design, need excel spreadsheet roster staff free, need excel spreadsheet written, need excel spreadsheet

About the Employer:
( 0 reviews ) Gravdal, Norway

Project ID: #17928261

15 freelancers are bidding on average €104 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Ex More

€200 EUR in 3 days
(619 Reviews)
8.3
schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Custom Excel Spreadsheet. I can assure you the quality job. I have good experience in Excel. We have worked on several similar projects befor More

€150 EUR in 3 days
(261 Reviews)
7.5
zekovicm

Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the ag More

€100 EUR in 1 day
(76 Reviews)
6.7
polarjin2017

Hello? How are you? I have good skills in Excel jobs... So I can complete your job in time. Hope to work with you. Thank you.

€155 EUR in 3 days
(51 Reviews)
6.1
RushService

Feel fee to contact me for Custom Excel [login to view URL] me message to discuss further more details .We provide the commments,images,videos,demos and live sessions in order to help the [login to view URL] payment only af More

€100 EUR in 5 days
(6 Reviews)
4.0
scorpionobaid01

Hi I am here to assist u inthis project I am an ACCA U.K member currently working in finance dept of a leading airline of the world I have more than 4 Years of accountancy and finance experience and have great skill More

€133 EUR in 3 days
(17 Reviews)
4.0
marudelavallaz

I am an excel expert. Can surely help you with the task and I am very interested and enthusiastic with it! Lets chat for further details! :)

€100 EUR in 10 days
(1 Review)
3.7
dataexplorer

"Hi I would love to inform you that I'll get the business name, address, phone, website, and email for you according to your stated requirements . By the way do you have any selected state or city ? and how many data More

€50 EUR in 3 days
(10 Reviews)
3.2
caprateekr

Hello there, I have gone through the requirements you have posted and I will provide you with the excel sheet enabling and ensuring all your requirements into the different tabs as required. Message me so that we More

€70 EUR in 2 days
(9 Reviews)
3.2
paulodayto08

Hi Good day! A serious freelancer here! I have a lots of available time to this work. I can help you to complete this work in 2-3 days, but need to know the full requirements to assess how long would it take to c More

€50 EUR in 3 days
(11 Reviews)
3.2
developerguru15

Sir/Madam, Good day! I'm a guru in excel/spreadsheet. I'm an Assistant Administrative for more than 8 years and I've been using excel since then including vb in excel, formulas, conditional formatting, macro, etc. I More

€111 EUR in 10 days
(2 Reviews)
3.0
mkreza91

Dear Client, I can do this project for you. Since I have previous experience of this type of project work. So, you can take a look of my portfolio. There I have done several types of work like data entry, data proces More

€90 EUR in 5 days
(10 Reviews)
1.7
ravik786

Hi, As i have 4+ Years of experience in Advance Excel. I can do this job. Also presently developed similar project. Looking forward to your reply. Thanks.

€111 EUR in 10 days
(1 Review)
0.4
Jordan3580

My potentialities, dynamism and my motivation allow me to contribute to the information system in your company or business because of my sense of organization, responsibility, rigor and team spirit. I am interested an More

€34 EUR in 1 day
(0 Reviews)
1.4
stewartjlogan1

Dear Sir / Madam, As an advanced excel user with valuable Financial / Analytical and Data Entry experience, I would be grateful if you would review my profile for the position advertised. Having worked at high levels More

€111 EUR in 3 days
(0 Reviews)
0.0