Closed

Solution for a custom League System - Functions, Database, Front End, User Accounts

Hello experts,

we have a league that runs well with an excel sheet with extensive functions. However, we have to enter all data into the excel sheet every week from all the players who played their games. By hand. We have 31 Data points to enter and the sheet calculates 5 scores from those PER match. Each player plays at least 3 matches each week and we have 100+ players, with the ability to host unlimited players and matches.

The excel then calculates all the entries and spits out our new league table and match overview for the next week, along with some statistics, graphics etc.

The pairings (who plays against who) change during the league. Sometimes there are groups of 4 players, sometimes 7 or 8. Also, players leave and join the league during the season. We have automated most of that in excel.

However, we run several leagues and it becomes a lot of work to put everything in by hand and we need an extra excel file for each league.

We need a solution that automates everything.

We are open to suggestions. Simple, clean, fast, intuitive is what we are looking for. Players should be able to enter their data for each match themselves, so we don't have to do it. The data then needs to get into a form where we can put it into our excel file OR we need to build all of that as a standalone mobile or web app..

Our thoughts are:

Either a Front-End Data Entry, where our players can make an account on our existing wordpress website and enter the scores through contact form 7 and then into a database that is coined after our excel sheet... or the data is just saved in a way that we can copy it at the end of the week and paste it into the excel sheet. But we are looking for full automatization actually. As we grow and get more and more leagues.

So maybe a mobile APP or web based application where users make an account, sign up for the leagues they play (or we sign them up through an admin backend). When they finish a match against another user, they enter the scores - the opponent gets a notification to "confirm" or "deny" the scores entered. Once confirmed, the score goes into the database/excel coined data system where it then ends up in the right place and each week, the application automatically shows the new table and match overview to each user, as well as all the statistics and graphs.

If denied, the user has the option to enter a counter suggestion of the correct scores and the first user is asked to confirm. If confirmed... see above. If denied again, the match is put on hold and admins notified of the problem. We then ask the players what happened.

Our data sheet has several safety features. For example, if unusual scores are entered, it reminds us to manually review that match. If one player has better stats than the other but still lost (which happens), we get a reminder as well etc.

We would like this finished / first test Version ready by March. It should be fully operational by March 20th. 2022.

Obviously we answer questions, need regular updates from you and test this throughout the programming. We should have the option to design it with you (the outside look, as we have a branded look and feel).

Looking forward to your solutions!

cheers

Skills: MySQL, Software Architecture, Mobile App Development, Database Development, Datatables

About the Employer:
( 4 reviews ) Neusäß, Germany

Project ID: #32740676

78 freelancers are bidding on average €2490 for this job

(45 Reviews)
9.0
(80 Reviews)
8.9
(612 Reviews)
9.1
bsbrajmohan25

Hi, Hope you are doing well. We are much expertise group of iOS, Android, Website developers and Designers Please reviews my profile - https://www.freelancer.com/u/bsbrajmohan25 I understood the initial scope of you More

€3000 EUR in 45 days
(59 Reviews)
8.4
AwaisChaudhry

Hi there, I have read the brief details on the job listing. You can check my experience, customer feed backs and my portfolio here: https://www.freelancer.com/u/AwaisChaudhry?w=f I believe its a doable job I have grea More

€4500 EUR in 75 days
(105 Reviews)
8.4
promactinfo

Hello, We can create custom League System - Functions, Database, Front End, User Accounts as per your requirement. We as a team can also assist you with the development of E-Commerce, Web/Mobile App design, Customized More

€2250 EUR in 22 days
(94 Reviews)
8.3
(231 Reviews)
8.4
AzzkaNoor

Hello. Experienced Full Stack Software developer here with 8+ years of hands-on experience in Web and Mobile apps development. I would like to ask the following questions relevant to your project. 1- Can you provide m More

€3000 EUR in 30 days
(43 Reviews)
8.0
hemanshusondhi

NO UPFRONT PAYMENT REQUIRED! We very well understand that as soon as you have posted this project, you would be flooded with tons of bids and making it very hard to choose the right freelancer for you. Below is what More

€2250 EUR in 45 days
(67 Reviews)
8.4
(16 Reviews)
7.6
(113 Reviews)
7.8
(144 Reviews)
8.2
Julian29

Hi There! You need to develop a Solution for a Custom League System - Functions, Database, Front End, User Accounts, the excel then calculates all the entries and spits out our new league table and match overview for More

€1500 EUR in 15 days
(101 Reviews)
8.0
(134 Reviews)
7.2
(24 Reviews)
7.1
(26 Reviews)
6.8
(19 Reviews)
6.9
surabhirathi21

Hello , I've gone through your project Solution for a custom League System - Functions, Database, Front End, User Accounts. We are a Pvt. ltd. organization with a team of seasoned WordPress developer and have created n More

€2500 EUR in 14 days
(49 Reviews)
6.8
mmadi

Hi Simon! Hope you are doing well. I am very interested in your job (Solution for a custom League System - Functions, Database, Front End, User Accounts). You can review my profile to see my skill including Database More

€2400 EUR in 36 days
(23 Reviews)
6.6
DeveloperDaut

Hello, How are you? I've read your project description carefully. You want to replace current excel sheet work with web solutions. It is about custom League System. As a senior web developer, I also have experience of More

€3000 EUR in 30 days
(21 Reviews)
6.2