Database, SQL or Excel Workbook
$250-750 AUD
Paid on delivery
I collect and store racing reseults and then use the data to analyse future races. I currently use Excel workbooks for this task. The files have become large and the process require a lot of manual adjustment of data. Looking for suggestions of how to improve this, either by conversion to a database or using different methods in Excel to achive better functionality with less manual adjustments than at present. Also, my current results data workbook is more than 110Mb and the upcoming analysis sheets are more than 20Mb each, so very slow and awkward.
The reason I chose to use excel initially was its availability on most computers. I have previously loked at Access but this is not available as standard on many machines. I want something that will be easy to access, easy to use and will automate most of the process. I am willing to look at suggestions for Access or similar, improvement of Excel or even online solution, although I worry that sometimes I may not have access or it will require large data bandwidth. Even a combination of a database to store the data and then do the calculations and analysis in Excel. Looking for someone who can make a workable suggestion and then create what I need to make this work better.
At present, in my workbooks I have about 500,000 rows of data, and this grows by about 1500 rows per day, 363 days per year. So, I require something that will cater into the future as well. I have attached a Word document that tries to explain what I need and shows screenshots of what I use now. I have also attached a sheet which shows how I get the raw data results that I add each day to my database. I add about 14 steets of results like this each day. Any solution will need to allow me add data each day by copy and paste from this format.
A Freelancer with some knowledge of racing or even sport would be an advantage. Please dont bid unless you have a solution in mind for the Project.
Many thanks
Project ID: #6382049
About the project
28 freelancers are bidding on average $522 for this job
Hi, my name is Sevinc. I am one of the top-rated excel & vba coding expert here. you may wish to check my profile and feedbacks first to have some idea about the quality of my work. I had many excel/vba tasks, includin More
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
hi we could do it perfectly with accuracy, please let us know if you want any clarification. if you want us to share our skill and previous work please initiate the chat by replying..
Hello, I have a solution for your problem - I can develop an web application for you in which you will upload your raw data excel sheet and all your data will get stored in database. This will reduce all your headache More
Hi, I often work with clients to move from excel into something a bit more online. You've got quite a lot of options here actually. I would actually say a good way to do this would be to have your data in mysql (ver More
Hello. I have an idea in my mind that why don't you develop a windows application for processing and analysis tasks. For front-end use a windows application and for backend you can keep excel only or go for access/m More
I can provide you the solution in the form of a desktop based application in C#. It will be able to read your excel files and store data into MySQL, MS SQL Server database system. I have done much work in application d More
Hello, I have over 10 years experience in advanced data processing via PHP & MySQL, mainly. I am great with Server administration, data mining etc. I have studied 7 years in US towards Computer Science Engineerin More
Dear Client, I have gone through the word and excel document submitted by you. Its better for you to have a small application wrapping around your data base migrated from excel , which has capability to serve you the More
I would probably want to develop this solution in SQL server , Using SSIS all the transformations can be applied and the end resultset can be presented through Excel by using refresh data from excel which is a built in More
As per my knowledge we can make a standalone application or web based application, which allow the following 1. Add new results through front end application. 2. Allow to access the existing xls result through fron More