Need Custom Excel Spreadsheet -- 3

Ditutup Dipasang 5 tahun yang lalu Dibayar saat pengiriman
Ditutup Dibayar saat pengiriman

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)

- 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).

REMEMBER: I just need the set-up of the Excel sheets. The data itself, I'll fill in manually myself.

Excel

ID Proyek: #17991319

Tentang proyek

10 proposal Proyek online Aktif 5 tahun yang lalu

10 freelancer rata-rata menawar €152 untuk pekerjaan ini

schoudhary1553

I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid Lebih banyak

€150 EUR dalam 3 hari
(359 Ulasan)
8.0
Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m Lebih banyak

€100 EUR dalam 1 hari
(260 Ulasan)
7.0
tiaratechies

Hello, we are a team of excel experts that can give you perfect excel application that is advanced and user friendly, hope you will talk to us reagarding this.

€500 EUR dalam 2 hari
(76 Ulasan)
7.0
polarjin2017

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

€155 EUR dalam 3 hari
(91 Ulasan)
6.7
bizwizz

I think I am a good fit for this project job because I have all the qualities that you are looking for. Experience is the golden factor with this type of project and I have a minimum of 5+ years of working experience i Lebih banyak

€100 EUR dalam 3 hari
(20 Ulasan)
5.8
mango953

Hello. Before talking you out of keeping your data in a spreadsheet where you spend more time scrolling up and down or sideways than appreciating the information in the file, I ask you to start a contact with me throug Lebih banyak

€200 EUR dalam 7 hari
(1 Ulasan)
3.2
krishnaagr89

Hi,I have read your requirements of Need Custom Excel Spreadsheet -- 3 and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very keen to discuss furth Lebih banyak

€58 EUR dalam 11 hari
(3 Ulasan)
2.9
mariatannir

Hello there, I have worked for 2 years in Data entry and Excel, I have excellent English reading, writing and speaking skills and a major Football fan and follower, I believe I am well suited for this project Thank y Lebih banyak

€111 EUR dalam 7 hari
(1 Ulasan)
1.0
Diyanm

I am excellent in preparing excel macros & vba & integration excel with system. I can automate your work in a very simple manner & make your business accurate & easy I am passionate about my work & I meet the deadli Lebih banyak

€100 EUR dalam 3 hari
(0 Ulasan)
0.0
rosechua100

Hi there. I'm interested to help you with this project. Please feel free to message directly so I can see how I may be able to help. Thank you very much.

€50 EUR dalam 10 hari
(0 Ulasan)
0.0