I'm in need of some help creating an excel spreadsheet (or something similar) that will have the ability to manipulate data that will be contained in my database (MySQL). The database will contain XML feeds that contain sports statistics.
There will need to be 4 similar spreadsheets created, one for each sport. There might be multiple tabs in each spreadsheet.
I will provide exact details to the winning bidder on specifics (I have a sample spreadsheet that I've created to show the flow of data and what data I'm looking to be able to manipulate). What I need help with is the design of a template that is easy to use, and the writing of formulas to take data from the different sheets and database).
As of now, I do not have the database built, and will not have the xml feeds for a few weeks. I will need a quick turnaround on this project, and will award today to the bidder.
I need to amend this project a bit. After many questions and discussions, I'm finding out that I am not really needing an excel spreadsheet build.
It's looking like I need some sort of PHP script or application built to provide computations between 2 or 3 different databases. I need the ability for this script or app to do some basic math functions between the databases, and then have the ability to show the results on my website. The results do not need to be saved into a database, as they only need to be temporarily displayed.
I do have the categories or data field names that will need to be computed, and will provide that data to the winning bidder. I will also be available via im chats or skype to discuss the project to the awarded bidder.
I do not need a database built, I don't need someone to build my site. Those things are already being built.
To give an example here is a scenario:
Database 1 - Player Names
Database 2 - Player Stats
Database 3 - User/Subscriber Info for Custom Leagues
A subscriber wants to find out about Player x, and types that name into an interface on my site (database 1) - it displays the statistics from the XML feeds which are contained in Database 2
The subscriber selects a league that they have customized the scoring functions for (database 3)
The output onto the website should make the computations that are stored in Database 3 with Database 2.
The statistical data that has been computed should be displayed.
This is a basic scenario and will be the key component of my project.
Please adjust the bid's accordingly and be sure to explain in your bid what kind of application you will suggest providing to do this function
21 freelancers are bidding on average $144 for this job
I'm a professional Accountant and experienced data entry operator.I can deliver the projects on time under budget and I believe my skills would be ideal for your project.