Find Jobs
Hire Freelancers

Need Custom Excel Spreadsheet

€30-100 EUR

Cancelled
Posted over 5 years ago

€30-100 EUR

Paid on delivery
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
Project ID: 17928261

About the project

14 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
14 freelancers are bidding on average €109 EUR for this job
User Avatar
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 Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample file before you consider awarding me the project. Please initiate a chat so we can discuss on this. Thanks, Jay
€200 EUR in 3 days
5.0 (764 reviews)
8.6
8.6
User Avatar
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 before! We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
€150 EUR in 3 days
4.9 (335 reviews)
8.0
8.0
User Avatar
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 agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
€100 EUR in 1 day
4.9 (130 reviews)
7.4
7.4
User Avatar
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
4.8 (91 reviews)
6.7
6.7
User Avatar
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 complete this project. I am VBA Macro developer for 6 years now. I have a strong knowledge with Excel formulas and function that will help for this type of work. I am also a PMO Analyst that focused in Financial and Metrics Reports. My rate is negotiable because I'm still collecting good reviews and portfolio that I can show to my future clients, so please accept my bid. Feel free to message me to discuss more about the scope of this project. Thanks!
€50 EUR in 3 days
4.9 (43 reviews)
4.7
4.7
User Avatar
"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 do you expect ? Best Regards DataExplorer"
€50 EUR in 3 days
5.0 (18 reviews)
4.2
4.2
User Avatar
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 can discuss further in relation to the timeline. Thanks
€70 EUR in 2 days
4.8 (14 reviews)
3.8
3.8
User Avatar
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
5.0 (1 review)
3.7
3.7
User Avatar
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 within Finance, delivering accurate and timely reports to meet key deadlines has always been an essential part of the quality service I can offer. Also have vast experience in developing financial models via Excel (both basic and advanced).
€111 EUR in 3 days
5.0 (3 reviews)
3.3
3.3
User Avatar
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'm also a virtual assistant for more than 4 years and I have also tried working on google sheets. I'm highly motivated and hardworking. I always submit projects on time with minimal supervision. Please contact me now. Thank you!
€111 EUR in 10 days
4.9 (2 reviews)
3.3
3.3
User Avatar
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 processing and so on. Hope you will select me for your task. Best Regards Mahmud Reza Data Entry Specialist
€90 EUR in 5 days
2.7 (10 reviews)
1.7
1.7
User Avatar
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
5.0 (1 review)
0.4
0.4

About the client

Flag of NORWAY
Gravdal, Norway
1.0
1
Payment method verified
Member since Oct 9, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.