Database, SQL or Excel Workbook
$250-750 AUD
Teslim sırasında ödenir
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
Proje NO: #6382049
Proje hakkında
Bu iş için 28 freelancer ortalamada $522 teklif veriyor
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
Hello sir i can develop an application using you excel as the basis and develop using .NET Framework (C# or VB.NET) as front-end and MySQL Database as back-end. i have worked on racing sites (Racingpost - UK and Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
Hi, So after reading all the files you need a database for this for sure, the Access database in my mind will have main interface which will have Input bottom that will open a data sheet same like excel one which u Daha Fazla
i have ample knowledge of database creation and the and know what should be the schema of the tables and what constraints should be used for the integrity and consistency of data. i have worked on several projects like Daha Fazla
hello!!! The best option for you is move that information to a real database and create stored procedures for the analysis part. Having the data in that form guarantees the processing should be faster. So, I propose Daha Fazla
Hi, I am a senior software developer with more than 15 years experience, I have worked on various types application(such as Client/Server, MVC, Intranet/Internet, Web service, ERP). My proposal is below, please revi Daha Fazla
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 Daha Fazla
After carefully reading your well explained project description, I have a proposal for you. It's called R. R is a free available statistical software much more powerful than excel. It's the number one statistical so Daha Fazla
