In Progress

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)

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

Skills: Excel, Excel Macros

See more: excel spreadsheet designer, creating an excel template with formulas, excel spreadsheet design service, custom spreadsheet services, what is an excel template, buy excel spreadsheets, how to make custom excel spreadsheets, excel spreadsheet builder, convert excel spreadsheet label, convert excel spreadsheet standalone application, convert excel spreadsheet label format, custom excel spreadsheet maker, convert web page excel spreadsheet, convert excel spreadsheet standalone, convert excel spreadsheet application, need someone convert excel spreadsheet web form, convert excel spreadsheet work web page, convert excel spreadsheet software, convert excel spreadsheet datfile, convert data word excel spreadsheet

About the Employer:
( 0 reviews ) Gravdal, Norway

Project ID: #17999819

Awarded to:

MHaiciu

Hello! My name is Marian, and I want to help you with this job. I can create de Excel file, as per your specification, and I will be available to make any tweaks you deem necessary. I will need from a list with the t More

€50 EUR in 3 days
(3 Reviews)
1.4

30 freelancers are bidding on average €103 for this job

ponnarasiBabu

I am an excel expert and have completed many complicated excel related tasks. Can provide you sample if required of my past and current work. Read the project specs. Looks like this project is feasible. Just want to un More

€111 EUR in 7 days
(91 Reviews)
6.2
natalka503

Hello, I am working with Excel for over 5 years and I am sure I will be perfect fit to help you with your project. Contact me on chat to discuss details. Natalie

€111 EUR in 2 days
(45 Reviews)
4.5
€166 EUR in 15 days
(23 Reviews)
4.5
mango953

Hi. I offer you a database file that does what you want to be done in Excel and much more. Contact me so I can attach screenshot samples for you to review.

€166 EUR in 10 days
(1 Review)
3.2
dataexplorer

"Hi, I have just gone through your project description and reviewed everything. Yes, I’m able to work as per your instructions in your current project and able to provide accurate and quick service. You know! I’m eff More

€500 EUR in 5 days
(12 Reviews)
3.3
akritisood94

Hi The everything you want in your Excel sheet can be achieved by excel macros and vba.I have experience in [login to view URL] have a look on my profile and get back to me I can start right now. Relevant Skills and Experie More

€83 EUR in 10 days
(5 Reviews)
3.1
Logo199

I have total 7 years of working experience in process mapping , process documentation , data entry , data analysis and expert in MS office application including MS word , MS powerpoint , MS excel , Photoshop , Adob More

€83 EUR in 10 days
(7 Reviews)
3.0
miketan08

I almost understand

€100 EUR in 3 days
(0 Reviews)
0.0
musa78800814

Hello. I'm a professional user of Excel and also a programmer. I've all the expertise required in ur project. With my expertise and ur input, we will make a good Excel sheet.

€77 EUR in 3 days
(0 Reviews)
0.0
GashaG45

I am passionate and Hardworking freelancer and can put all my efforts into your project to make your project accurate and successful. I will Work in a professional way so that both of us don't have any trouble doing bu More

€111 EUR in 10 days
(0 Reviews)
0.0
segmudasir

I am Expert in Data Entry, Typing & Web Scrapping. I have 05+ Year experience in all types of online web services in the following fields: SPECIALTIES: * Data Entry * Data Processing * Spreadsheet More

€55 EUR in 10 days
(0 Reviews)
0.0
mustimansour

I'm a civil engineer and an expert with the excrll tracking and distributed data handrling . I guarantee you a good and clearly understood work. Relevant Skills and Experience civil engineer soccer fan and familier wi More

€55 EUR in 3 days
(0 Reviews)
0.0
€100 EUR in 1 day
(0 Reviews)
0.0
Manojnmys

Please share the video to be worked and will try to get in one day.

€83 EUR in 3 days
(0 Reviews)
0.0
€83 EUR in 2 days
(0 Reviews)
0.0
engraliabid

Electronice engineer

€83 EUR in 10 days
(0 Reviews)
0.0
abbaszaidi68

Hi, I have good experience and typing speed in excel, having large working experience in MNC before, now i am starting work as freelancer. I am new as freelancer but i am honest for work what i am doing. I will finis More

€83 EUR in 10 days
(0 Reviews)
0.0
€55 EUR in 10 days
(0 Reviews)
0.0
€83 EUR in 10 days
(0 Reviews)
0.0
malisreno

saya sering membuat laporan tentang hal tersebut

€83 EUR in 10 days
(0 Reviews)
0.0