Find Jobs
Hire Freelancers

CREATE DATABASE TO REPLACE EXISTING EXCEL DATABASE

$250-750 AUD

已关闭
已发布超过 8 年前

$250-750 AUD

货到付款
PLEASE DO NOT SUBMIT AUTOMATIC BIDS WITHOUT REVIEWING THE INFORMATION BELOW - I have not set a budget for this Project, will look at all submissions on merit. I am looking for a database solution, preferably from someone who understands racing or other sport data. I currently use Excel to store the results of greyhound races around the world. I use several Excel workbooks and sometimes several sheets within each workbook because of the row limitations in Excel and also the slowness of the calculations when editing or sorting data. If I were to put all my data in one workbook, I would probably have 1.5 – 2m rows of data. Basically my workbooks are all the same (except for the countries they contain data for), but the layout and formats are almost identical. What I want to know, is whether Access (or another database program) can replicate what I do in Excel and do it as fast. In each workbook I have a sheet that contains just the last 3 months or so of data. I use this to speed up search and calculations. I also have a sheet that contains all the data (including the last 3 months) so there is a duplication there. The other sheet that I have is a sheet that contains all the statistical information. I will try and explain. Each track (and there are probably about 200 that I save results from around the world), each track has races over multiple distances. On my DATA sheet I keep averages of all the results, so the average winning time for each track, over each distance, in each grade (there can be up to 20 different grades on different tracks). This DATA sheet also calculates the average time taken to the 1st turn at each distance on each track, the average distance from the winner from each box at each distance on each track, etc. I can provide all the formulas used in Excel if these can be replicated in the new database. I currently scrape a series of websites around the world to get my results. This scraping delivers me .csv files formatted in the same column order as my current Excel sheet, so I would like to continue using that as the input method for data each day, to be able to copy and paste these CSV files into the new database. Once the database is set up, I would need to replicate the workbook that I currently use to extract data for upcoming races. This uses a CSV file with upcoming fields and automatically creates a separate workbook for each race on each track for the upcoming day. Basically the process is this. It searches for the runners (from the upcoming fields) and extracts the last 6 performances (in date order) within the previous 90 days and within a distance range of + or – 50m from the upcoming race. It pastes that into a new workbook where a series of formulas are applied to allow for variables in the upcoming race. At present I have a series of macros and other small programs that automate most of this process in Excel and it works really well. My problem is the limitations with Excel as far as numbers of rows of data it can store and also the amount of time it takes if I edit any data. Can anyone suggest a standalone (or online) database solution that would store all my results, allow me to use the scraped CSV files as daily input, would be able to do all the statistical calculations that form the averages, etc and then have a function that would search, extract and run the formulas required for the upcoming races. I can provide links to samples of my current Excel files to those who demonstrate an understanding of what is required.
项目 ID: 8801080

关于此项目

42提案
远程项目
活跃8 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
42威客以平均价$499 AUD来参与此工作竞价
用户头像
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. We can move the database to Access. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. We can discuss the budget post discussing the complete requirements. Lets discuss more online on chat. Thanks, Abhinav
$555 AUD 在10天之内
4.9 (127条评论)
6.4
6.4
用户头像
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely prameswara
$250 AUD 在1天之内
5.0 (164条评论)
6.0
6.0
用户头像
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi
$545 AUD 在6天之内
5.0 (50条评论)
5.9
5.9
用户头像
Dear, we are Team of French + US. 11 years experience on Access/Excel/VBA automations. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$505 AUD 在8天之内
4.9 (47条评论)
6.3
6.3
用户头像
Hello Sr., how are you ? Jorge is my name and I have experience doing programs using VBA Code (with Excel for example). Also, I'm an experienced web data extractor with databases uses (MySQL, Access, SQL) You can visit my Portfolio to know my last jobs regarding these skills, the reviews received from clients and as you can see, a higher percentage of jobs completed. i'm interested to help you on this particular project. What I prefer is to discuss with you more in detail all your terms and I'll give you a better proposal. For example, to know how your excels are structured to think a good idea for you. No more Sr.; contact me if you'd like it and I will do the best, Regards. Jorge. P.S.: I will not accept any award before to discuss with you all the details needed.
$600 AUD 在10天之内
5.0 (46条评论)
5.7
5.7
用户头像
Предложение еще не подано
$555 AUD 在10天之内
4.9 (22条评论)
5.0
5.0
用户头像
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$250 AUD 在2天之内
4.9 (41条评论)
5.1
5.1
用户头像
Hi, I already bid on this project before, you had a chat with me, and now I see that you have posted the same exact project as a new project. My bid is now AU$1000.00 with delivery in 10 - 15 days. The deliverable is: A Windows application with a nice GUI that will allow you to import new data, store all old data, allow you to search, export, trim, and generate statistics, reports based of the data etc. Also included in my offer is long term and reliable support, free bug fixes if any reported, and enhancements/additions done at low rates. Professional quality work done. Thank you for considering my bid. Bests, Larry
$1,000 AUD 在15天之内
4.4 (33条评论)
5.5
5.5
用户头像
I have bet greyhounds in the past, but I bet thoroughbred horses more often. With my knowledge of handicapping horses and understanding of past performances I am definitely interested in doing this job. I feel that with my interest and my background (as you can see below) I would be a perfect fit. I hope to hear from you to discuss your project and my experience. Background: I am a software developer with 10+ years experience. I am currently consulting for a Fortune 50 company doing work primarily in Access and Excel with VBA. I have extensive experience in other aspects of software development as well. I am employed full-time, for the last 5 years, doing .NET development. I have built several large enterprise solutions during this time. I am very knowledgable in the following: .NET, VB, C#, HTML, javascript/jQuery, SQL, Access, Excel, VBA, Flash, Actionscript, PHP. I am new to Freelancer but am trying to build a solid profile. If you would like to talk before awarding this project let me know. Hope to hear from you.
$277 AUD 在14天之内
5.0 (9条评论)
4.7
4.7
用户头像
Dear client, I have a lot of experience with big data handling. The choice is between an Access database and SQL database. It depends what you are saving in one row.( the max size of one Access database is 2 GB) Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA
$500 AUD 在7天之内
5.0 (14条评论)
4.1
4.1
用户头像
A proposal has not yet been provided
$555 AUD 在10天之内
5.0 (3条评论)
3.8
3.8
用户头像
You can see that my bid is just outside the budget, but please read on (especially as you mentioned you don't have a budget for this project yet) I understand that using your historical data you are providing certain statistics using recent history's races and races over comparable distance. I would agree that using Excel as a data source only works to certain extent - which you have probably surpassed now. And knowing the data the way you suggested I agree we should move on to separating the data and operational/presentation layer. The data layer being Access as it works fine with Excel and the presentation being Excel. Processing can be split - with some simpler functions like summing / averaging / sorting etc. done on the SQL querying side and the rest of data manipulation can still be invoked in Excel. When it comes to presentation I understand you already have a preset way of producing results - we can keep it as it is or take the opportunity and improve it too. The data import would still work the way it is - using the CSV file format you already have. I have worked with data migration, data manipulation, reporting, data analysis and so on for the last 10 years - most of this time working in Finance and Healthcare Data in London, and since Dec last year I am now using my skills here on freelancer. Don't hesitate to ask any additional questions - this box has limited length so I can't fully describe the solution, but we can talk offline. Regards Morris
$650 AUD 在21天之内
4.8 (5条评论)
3.1
3.1
用户头像
A proposal has not yet been provided
$1,111 AUD 在15天之内
5.0 (1条评论)
2.1
2.1
用户头像
I am a senior software engineer with over 22 years of experience specifically with Excel, Access, Visual Basic, VBA and SQL Server. After reviewing your description, you might be suited to migrate your Excel sheet to SQL Server. SQL Server was built to handle this type of processing and is orders of magnitude faster than Excel or Access. You can take advantage of Advanced SQL queries and processing done by the SQL Server Engine instead of a desktop application like Access or Excel. You can also consider using MS Access but move the actual data to SQL Server but connect to it using ODBC Linked/Attached tables. This will let you leverage the best of both worlds...SQL Server power and the ease of use for queries and reports in Access. You can also create SQL stored procedures and scheduled tasks to pre-aggregate gaming data as it is imported. SQL Server lets you create INSERT and UPDATE triggers which is code that runs when a new row in inserted or updated. How I have used these in the past it to populate a separate table for reports which runs much faster when pre-aggregated as opposed to using complex formulas/VBA functions in real-time which can take a long time depending on the amount of data. I've done this type of programming for Fortune 100 companies with billions of rows, hundreds of tables, etc. VERY COMPLEX and CPU intensive. I've learned how to make things optimized for performance using lower end PC and servers because not all of us could afford $$ servers.
$526 AUD 在14天之内
5.0 (2条评论)
1.8
1.8
用户头像
Hello. I'm understand how to do this job. Skills in VBA, experiance of working in excel, access two years. Good luck and succeed in this project.
$250 AUD 在10天之内
5.0 (3条评论)
1.9
1.9
用户头像
Hello. More 20 years programming experience. Had done similar many times, but I need more details to set real time and price. Regards. ---------------------------------------------------------------------------------------------------------------------------------------------------
$250 AUD 在10天之内
5.0 (1条评论)
2.0
2.0
用户头像
Hi, I can create a database for storing all the information. I will do a simple standalone program in java which will pull the data from database and manipulate on the data like average and other calculations. For output, I can simply design a interface(like desktop interface) or can provide output in excel or CSV as required. If you want to host database online then also you can add it. For scrapping also, I can use my program to extract data from website. Thanks and regards, Vikash
$666 AUD 在10天之内
5.0 (1条评论)
1.4
1.4
用户头像
Hi, An Access database will cover everything you listed here. There is no limatation to the number of rows in access only the max size of 2 GB and if you're running that big then it can be split across several access DB e.g. one per year / per quarter. You could have a single front end to manage everything with multiple data stores. Running averages over any criteria can be easily done in access and there are not any calculations that can be performed in excell that cannot be done in access. I don't know about dogs by with horses you would need to factor in the going as well to determine the individual preferences. But without seeing the sheets your working with I am only guessing. You can import CSVs into access, I would need copies of the various CSVs to set up the imports but after that simply save them into a folder and run the import. As I understand it you want to be able to grab past race history for the runners in each new race. This is straight forward to do and will largely depend on the statistics being run. From what you have said the issues are the amount of data available and the amount of time it takes to manage the data that is the problem, with this I would expect you're work load to be reduced to scraping the sites and loading the CSVs for processing. Technically I have 15+ years developing VB and database applications and I have developed numerous access applications for various requirements. Regards, Simon
$500 AUD 在20天之内
4.7 (2条评论)
1.3
1.3
用户头像
A proposal has not yet been provided
$277 AUD 在10天之内
5.0 (1条评论)
0.8
0.8
用户头像
Hi. I am a Senior VB6, VBA and VB.NET and C# WPF and WINFORMS Developer living in Paris, I have read your specifications and i want to realize for you a standaone application with SQlserver as database. i have already developed several applications you can find in my folio. I need samples of the excel files so as to determine datamodel to validate with and after this steps, Mockups and Sketchflows based to the behaviours or businnes rules you defined as requirement. You can contact me for any questions else. Kind regards
$500 AUD 在20天之内
1.2 (2条评论)
1.0
1.0

关于客户

VENEZUELA的国旗
Venezuela
0.0
0
会员自9月 21, 2015起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。