Find Jobs
Hire Freelancers

Database, SQL or Excel Workbook

$250-750 AUD

Closed
Posted over 9 years ago

$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 proposals
Remote project
Active 10 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
28 freelancers are bidding on average $522 AUD for this job
User Avatar
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, including ones involving horse races database and prediction tools, all achieved with 5/5 rating...I read your project descriptions in word document, and checked your short excel template. I exactly got what you need and ready to go ahead if you wish to proceed with a 5-star reliable partner here...I intend to stick into your excel file, clean it out from formulas (using vba codes instead), automize populating of new data into your file and related calculations. I believe this would be the easiest solution for you to handle as well...awaiting your (+) reply to discuss further details...regards,
$526 AUD in 7 days
4.9 (282 reviews)
7.8
7.8
User Avatar
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
$463 AUD in 15 days
4.8 (220 reviews)
7.4
7.4
User Avatar
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..
$526 AUD in 10 days
4.9 (75 reviews)
6.4
6.4
User Avatar
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 and it will be a fast system then yours. This web application will also be very easy and simple to use. And also the various kinds of reports can be generated by this system such as - ratings,win%, etc. And many more features can be included into your system. You will have to just upload your raw excel sheet and your all work is over then. I have developed this kind of system earlier also. I have read your document and excel file both and I can solve your problem. I have 3+ years of experience in php and mysql. I am ready to start this work. And if you have any query or problem please question me. Thank you
$580 AUD in 12 days
4.7 (95 reviews)
6.3
6.3
User Avatar
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 (very simple to get an import to bring it all in to begin with). I can set up a simple couple pages to view the data (paginated etc) and then a page to allow input. The input page would take csv (as output from your excel) and add it into the mysql db. I can wrap that up in a wordpress site too, if you need it a bit secure (you log in etc). This is nice as if you'd like to delegate work to someone else in the future, wordpress would allow you to create another user to have them do uploads etc. Anyway, I speak perfect English and have a great track record and I would really enjoy chatting with you further about your project. Kind regards, Chris
$290 AUD in 10 days
5.0 (16 reviews)
5.5
5.5
User Avatar
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 regularly work on RISA Australia) Best regards vnb400
$722 AUD in 30 days
4.8 (90 reviews)
5.4
5.4
User Avatar
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/mssql. I am working with a Financial Company of France to achieve similar analysis things. Well at this time, I don't have any budget & timeline idea. But after having a fruitful discussion of requirements, I can tell you. Looking for positive response. Thnaks
$250 AUD in 10 days
5.0 (35 reviews)
5.3
5.3
User Avatar
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 development. Consider me for your this project. I will be waiting for your reply and can explain you each step in detail.
$556 AUD in 10 days
5.0 (11 reviews)
4.0
4.0
User Avatar
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 Engineering, therefore I speak/write Business level English. I am looking to migrate your data to a web hosted PHP & MySQL solution. You will be able to access your application from anywhere, including your phone or tablet. MySQL will easily hold millions of data rows. In my bid amount, I will setup [ I recommend AMAZON EC2 as they offer 1 year free hosting and we can manage the entire server ] an admin page, with login username & password that will give you access to a basic dashboard. There you can input your data, easier than in Excel and all the calculations that you are currently running in Excel will be reprogrammed in this application. In this amount I also offer 30 days, free support, shall you need anything changed. Thank you for your consideration, Radu PS. I also have some applications that try to predict Soccer results :)
$450 AUD in 14 days
4.2 (12 reviews)
4.4
4.4
User Avatar
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 reports in your desired format, as well as you must be capable to enter the latest data also into the system for future reports. as I need some more clarification from your side which are 1 - regarding accessibility of this application ( how many users going to access this application ) I can create both kind of solution for you desktop based / Web based but it should be decided based on your requirement. 2 - for data updating new data I suggest there must be an excel upload program which will update recent data into the software for future reports.
$333 AUD in 20 days
5.0 (1 review)
1.6
1.6
User Avatar
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 functionality in excel . It will help in easy sharing of data from a single database
$777 AUD in 10 days
5.0 (1 review)
1.7
1.7
User Avatar
A proposal has not yet been provided
$250 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$333 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 can paste or enter the raw data in it, after that process bottom to process and insert the data into the database tables, then there is a bottom for the analyse upcoming race where a form will open and u will choose the date/track/dogs then generating a printable reports and/or excel files containing same data. calculation will be done internally by VBA coding. the project will be a single access file containing everything, input will be paste or type or Import from excel file if there is any, output will be excel/word files and/or on screen printable reports. I'm working as Database administrator and dealing with excel/Access/MS SQL server daily. If interested I will provide a sample of the data tables, interface and reports within 48H and in case you like it and want me to do the project I will finish it within 7 days. Regards. Talal
$650 AUD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 online shopping, resume building, social networking, branch changer application, etc and created consistent and precise databases for them.
$305 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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: 1) A database in MsSql server, if you don't have much money to buy a license the version free will be an option now, but it can be in a hosting enviroment. 2) A web application, in that way you can use it on any web browser, you only need a computer with Windows 7 Pro to install IIS and deploy the application there. 3) Inside the application one form to upload the data from excel, and another form to make your calculations (we will discuss about the details as soon as the project begins). All of these component can be in the cloud or in a local computer, even in both, but that last solution will cost you more money (replicated data is the term for that). If you are interested in this solution contact me so I give you skype to talk more about it. greetings....
$600 AUD in 21 days
0.0 (1 review)
0.0
0.0
User Avatar
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 review if it is good to fit your requirement. The project mainly focus on data process. I prefer to give a database to keep all your data since it is increase dramatically. Database: MS SQL Server/MY SQL/Access(depending on your budget) Table: code tables(Variable for columns); Race, dog information; Front side(C#): Web application or desktop application(depending on your choice) for following feature: Code maintenance; Data entry; File import(if your data is from in excel/text file); Report list. Implementation: You can implement the application and database in Cloud if you prefer web solution. Microsoft or other company provide the service, or your local computer. Cloud solution is better for your access anyplace and anytime through internet, and you don't worry about your data lost, but you need pay service fee, or you implement to your local computer. Report: create specific reports for your requirement and calculation. Those reports could be exported as excel or PDF file. All those calculation logic rule and search will be put in database server which is faster than excel or front process. Future enhancement, please put a new report bid in the site, I will be glad to provide my professional service again thanks William
$450 AUD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$1,333 AUD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 front end. 3. Can access various report based on search criteria 4. Able to analysis with all history result. About my self I am the Dot Net Professional Developer/ SQL Server developer. My professional experience includes extensive hands on expertise on Microsoft technologies.I understand how to build project that directly meet user requirements end to end, user friendly and affordable. I also understand the importance of building strong projects that stand up to the high performance and high volume environment.
$555 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 software used in academia. With R you can store these data in database and keep it in you computer. You can query from it how you want and even export the data in excel, csv, or any other extension you wish. I can help you do that. I will show you how to install it on your computer (very easy). I can even share with you some documentation on how to use it that way you won't need me in the future. For now though, I will provide you some codes that will store the data for you and do anything you want. I will always be there to answer your questions once I submit the project over to you. Actually, I do a similar thing with the NBA (basketball) and MLB (baseball), I've created a database that is player specific using R. My goal is to eventually create predictive models with it. I'm working on it. In case you haven't guessed yet, I'm a statistician by profession and projects like these are my passion. The other solution is to find you a computer programmer that can program SQL. It's also great for database. I can't help you with that though. I know I don't have experience on this site but trust me, I can be a big help to you. I hope to hear from you soon.
$600 AUD in 8 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Miners Rest, Australia
5.0
15
Payment method verified
Member since Mar 15, 2014

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.