Find Jobs
Hire Freelancers

Racing Excel 2007

$30-250 USD

Tamamlandı
İlan edilme: 13 yıldan fazla önce

$30-250 USD

Teslimde ödenir
I receive Australian horse racing data in zip files. Each file contains the data for one meeting and usually consists of around eight races. The data is in two sections. The first sections, which consists of the race details, the horse names, the riders etc., imports or exports into MS Excel 2007 into separate cells, and is satisfactory. The second sections which contain details of each horse's past five to ten performances, include items such as race times, weights carried, beaten distances, race class, race dates, jockeys etc., each appear on one line, with the data mostly separated by commas. I need these details to be broken up and entered into separate cells in Excel 2007. I then need the data to be sent to MS Access 2007 for storage. I have attached a Sample folder which includes a zip file for a Moonee Valley meeting and an Excel 2007 spreadsheet for race number 9 of that meeting. On the spreadsheet, I have notes which I hope explain what is required. The race files are in HTML format and the source data can be accessed by right clicking on the files. Hope this gives you what is needed. Regards, Barry Hiddins
Proje No: 805234

Proje hakkında

61 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 14 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
Seçilen:
Kullanıcı Avatarı
For your consideration... Thanks...
$75 USD 3 gün içinde
5,0 (9 değerlendirme)
3,4
3,4
Kullanıcı Avatarı
To start, I wanted to commend you on the excellent write-up which you have provided as this is critical to assess the level of effort involved. The fact that there’s a determined file layout used for this rows it can definitely be done through Macro’s.I have a few questions though: 1) You specified that the race data has to be sent to MS Access for storage. Will the records be stored in a single table or would the data need to be normalized before it is transferred. As you might know normalized data allows you to reduce data redundancies and perform excellent queries and comparisons between the horses, jockey’s etc. Also do you want that transfer of records to MS Access included in the project? Also, what data or fields would you use as a unique key to be used on the transfer i.e. what data records can be used to validate that there’s not a potential duplicate in the data being moved to MS Access. That is something that can be included in the code if the move is going to be automated, to ensure your data stays clean. 2) Do you need your own custom excel formula or would you want the code to be executed through a combination of keyboard keys like CTRL+M for example. 3) I also just want to confirm, that the layouts are pretty much fixed. You don’t expect any fields or layouts to be changed in the near future on the files that you receive. 4) Will you be responsible for moving the data to MS Access or is that part of the project. The move is a very simple task to include in the code. It all depends if you require any other slicing and dicing of the data prior to the data being transferred. I can complete this project in 2 days for you. I say 2 days as I work in the evenings, however I am fully committed to getting it done. I have worked with these type of projects for the last 10 years. Office automation and integration are areas I am very strong in. I also do not require an up front payment, or milestone payment. I would accept payment only on project completion and after you are satisfied with the results. Hope to hear from you soon.
$50 USD 2 gün içinde
4,9 (7 değerlendirme)
3,5
3,5
61 freelancer bu proje için ortalama $75 USD teklif veriyor
Kullanıcı Avatarı
Thank you for this wonderful project. Please see our PM and Reviews
$150 USD 3 gün içinde
4,9 (142 değerlendirme)
7,2
7,2
Kullanıcı Avatarı
Hi, Please check your PM For details. Thanks Dhruvika
$34 USD 2 gün içinde
4,5 (128 değerlendirme)
7,0
7,0
Kullanıcı Avatarı
Greetings! Thank you very much for giving us an opportunity to bid for your project. Please refer to PMB for our detailed bid.
$30 USD 5 gün içinde
4,9 (65 değerlendirme)
5,8
5,8
Kullanıcı Avatarı
READY TO START NOW
$120 USD 2 gün içinde
5,0 (101 değerlendirme)
5,6
5,6
Kullanıcı Avatarı
Hello, I have very good Knowles of Excel, Access and HTML. Kind regards.
$100 USD 3 gün içinde
4,8 (43 değerlendirme)
5,6
5,6
Kullanıcı Avatarı
Lets start. Please check PM.
$50 USD 2 gün içinde
4,6 (59 değerlendirme)
5,5
5,5
Kullanıcı Avatarı
Over ten years experience in developing automated Excel/Access/VBA solutions.
$120 USD 5 gün içinde
4,9 (26 değerlendirme)
5,4
5,4
Kullanıcı Avatarı
==========Dear sir/madam, Ready to start, Thanks. Anwar==========
$30 USD 5 gün içinde
5,0 (49 değerlendirme)
5,2
5,2
Kullanıcı Avatarı
chech my PM
$30 USD 3 gün içinde
5,0 (4 değerlendirme)
4,9
4,9
Kullanıcı Avatarı
Hi, I have more 10 years in MS Access and MS Office automation, so I'm reaaly guru in this. Alex
$100 USD 1 gün içinde
4,9 (16 değerlendirme)
4,6
4,6
Kullanıcı Avatarı
Hello, Please see pm and oblige. Regards
$78 USD 2 gün içinde
5,0 (29 değerlendirme)
4,5
4,5
Kullanıcı Avatarı
Hi This can be done. Thanks Al
$150 USD 5 gün içinde
5,0 (20 değerlendirme)
4,4
4,4
Kullanıcı Avatarı
Please view the PMB
$150 USD 7 gün içinde
5,0 (13 değerlendirme)
3,9
3,9
Kullanıcı Avatarı
Hello I can do this for you. I am an expert in Excel and Access. Please check my private message. Regards Faisal
$100 USD 2 gün içinde
5,0 (4 değerlendirme)
3,4
3,4
Kullanıcı Avatarı
Hi The specification is detailed enough. All rows one line below "This distance" would need to be split. I am proposing to keep the original set as sheet1 and the resulting sheet is in sheet2 so you can always look at the original, NOT overwritten.
$75 USD 3 gün içinde
5,0 (6 değerlendirme)
3,1
3,1
Kullanıcı Avatarı
Hi There I am an Excel expert and this seems very doable. I can do this for you under any of the 2 models: - US$100 per day, OR - US$ 50 per file (of similar style and size as shared by you) Cheers
$100 USD 1 gün içinde
5,0 (1 değerlendirme)
2,8
2,8
Kullanıcı Avatarı
I've sent you a PM
$160 USD 4 gün içinde
5,0 (1 değerlendirme)
2,1
2,1
Kullanıcı Avatarı
Hi You want to extract data from a file containing a horses recent history and have it cross reference with an upcoming race that the horse is in (to show how it compares to the other runners history). You've specified the position and breakdown of the data. The rest should be quite easy. regards, Neil
$100 USD 2 gün içinde
4,2 (2 değerlendirme)
2,2
2,2
Kullanıcı Avatarı
Hi, I have gone through the details and i can do it in few hours. Plz confirm when to start the same.
$30 USD 0 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Good day, I have 15 years experience in Excel and database design. Please see PM for detailed bid. Regards, Stephen
$100 USD 5 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   AUSTRALIA bayrağı
Maryborough, Australia
5,0
1
Eyl 22, 2010 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.