Find Jobs
Hire Freelancers

Plain-text file analysis in Excel VBA

£20-250 GBP

Concluído
Publicado há mais de 10 anos

£20-250 GBP

Pago na entrega
I have a bunch of text files to be analysed in Excel. Files contain sales information per day : [file header] cumulated values per product and [file footer] individual sale tickets. Each file must be analysed for consistency between header and footer. Data included in the files must be cumulated and made available for monthly and yearly statistics. The file is plain text, composed by a header and a footer. The header is about 50 lines long or less, the footer could go contain 10000 lines. HEADER EXAMPLE : DATE PREVIOUS RAZ: 13/11/2006 01:09:16 DATE RAZ: 16/11/2006 01:00:06 O2A20 4Z 4 RAZ NUMBER 8388224 17.056020 4T 3 COFFEE 1706 1706.002720 4T 4 WHITE COFFEE 189 283.50EE20 4T 5 LARGE COFFEE 11 19.808E20 4T 6 HOT CHOCOLATE 32 48.00C920 Column after the product name is the quantity, next column is total cost. The footer include hundreds of sale tickets as this one : FOOTER EXAMPLE: -D 1 17 17 12320 13-11-06 05:09000001/1 1.00 041850060015920 A 3 COFFEE 2 2.00 01B620 R 1 CASH 1 2.000C20 x 1 VAT 19.6% 1 0.33 1960E820 c 0 2 0.00C220 So, total sale tickets must match header figures. Controls must be set up, statistics must be produced [for header and footer].
ID do Projeto: 5099460

Sobre o projeto

34 propostas
Projeto remoto
Ativo há 10 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
Hi! I understand what needs to be done and can do it. I will write a VBA macro to fully automate the process of decomposing header and footer information into analyzable and comparable form. I have over 12 years of Excel experience.
£73 GBP em 3 dias
5,0 (66 avaliações)
5,5
5,5
34 freelancers estão ofertando em média £158 GBP for esse trabalho
Avatar do Usuário
Hello; your 5-star excel and vba coding expert is ready to help you here...kindly check my profile and feedbacks first, to have some idea about the quality of my work... I had many similar excel and vba tasks, all achieved with 5/5 rating...I read your project descriptions, ready to go ahead...kindly get back to me if you wish to proceed with a top-rated and reliable partner here...I bid a very competitive price for you... awaiting your (+) reply to go ahead...regards
£150 GBP em 5 dias
4,9 (288 avaliações)
7,9
7,9
Avatar do Usuário
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
£157 GBP em 0 dia
4,9 (335 avaliações)
7,7
7,7
Avatar do Usuário
Hi limm, I can provide an Excel macro based solution meeting your requirement within 3 days. In the Header part, I noticed alphabets forming part of total cost in some rows. Please clarify. Regards, Arul
£200 GBP em 3 dias
5,0 (202 avaliações)
7,4
7,4
Avatar do Usuário
Hi, I'd like to see one of the text files in order to make sure that is programmatically possible to automate this process -------------------------------------------------------------------------------------------------------------------------------------------
£83 GBP em 1 dia
4,9 (257 avaliações)
7,7
7,7
Avatar do Usuário
Hi Limm. I have read your project description and I am ready to kick off with it right away. Importing text files to Excel and analyzing them as you require is a pretty simple task for my expertise. Being highly proficient in VB and Excel, I would be able to deliver within a day. Lets begin and get the work done. Regards
£150 GBP em 1 dia
5,0 (89 avaliações)
7,0
7,0
Avatar do Usuário
Dear Sir/Madam I'm happy to help you on this Can you please send me a sample file to confirm You can refer my profile to see my reliability ;-)) Best regards Priyal
£200 GBP em 3 dias
5,0 (189 avaliações)
6,8
6,8
Avatar do Usuário
Hi, I am expert in this kind of work and already completed more than 200 projects. Please look at feedback left by my employer to know more about me and my work. Waiting for your positive reply. thanks.
£111 GBP em 5 dias
4,9 (120 avaliações)
6,3
6,3
Avatar do Usuário
Hello there. I have high Maths, Excel and Visual Basic skills with great professionalism. I study electronics and computer engineering at Oporto university and I'm looking for work to fill the blanks on my schedule. I'm very interested on your project and would like to help you on it. I'm experienced with importing data to excel, manipulating it in order to be processed and making statistical reports out of it. I would like to view one of your .txt files if possible, in order to better understand your project requirements. Also, if there's anything else you want to do with that data just let me know. Please note that I've set the deadline for 10 days because, right now, I'm with one project in hands which will consume me a bit of time, but let me know if you're not ok with this timeframe and we'll work it out. I would gladly appreciate this opportunity to work with you. Best regards, Bruno Martins
£150 GBP em 10 dias
5,0 (59 avaliações)
5,4
5,4
Avatar do Usuário
Hi I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% accuracy in minimum time . Pay me only if you are 100% satisfied with my work, after project delivery. Please see my private message(PM) for more details. I am interested to work for your project. Please give me a chance. I have handled many projects involving data manipulation handling, business solutions, Excel automated dashboards, Report Generation and Excel Applications. If you offer me your project, I can start immediately and deliver the job within 2 days after testing (QA) . I guarantee 100% accuracy for my deliverable. I do hope you'll give me the honorable chance to work with you and help me with making my mark on freelancer.com. I will take your project as the priority job and will complete your work in minimum time with 100% commitment. Thanks Fibin
£100 GBP em 2 dias
4,9 (53 avaliações)
5,4
5,4
Avatar do Usuário
Hello, I want to propose you another solution. Why don't you import those files into a database? You can keep in there a reference to the base files, but this way you will be able to produce better reports. I suggest to use SQL Server (or SQL Server Express for that), even Microsoft Access is ok. If you find this approach interesting, please contact me, I'm available on Skype. Best regards, Andrei Hetel
£150 GBP em 3 dias
5,0 (23 avaliações)
4,7
4,7
Avatar do Usuário
*******I've done Similar Projects********** Good Day!... I'm an Expert in Excel VBA Automation. Have developed & designed various excel based projects, dashboards,templates & trackers by using Excel VBA Macros and also with Advanced Excel Function as well. Please review my Portfolio to know about my Excel Programming skills. Please check the GPA Onhold Projects in my Portfolio. It extracts text files dump, format it & does analysis. I always provide consistent & quality service to my clients. Ready to give Ongoing support. Kindly award this project to me & share with me the details. Glad to assist you. Looking forward from you.
£100 GBP em 0 dia
4,7 (21 avaliações)
4,4
4,4
Avatar do Usuário
Hi my Dear, i am a statistician engineer working as a data manager and data analyst there is 4 years. I work with VBA there is 4 years. What you want it's what i master a lot. I am ready to start it for you.
£157 GBP em 3 dias
5,0 (3 avaliações)
3,3
3,3
Avatar do Usuário
Hello, I can fulfill your requirement. Kindly send across a sample file and I'll carry out some tests to do the needful. Best regards, AccuPro - Providing simple solutions to complex problems! At reasonable cost!!
£100 GBP em 3 dias
5,0 (5 avaliações)
3,0
3,0
Avatar do Usuário
VBA Programmer here. Got 6 years Experience in Web Programming, Software Programming and Database Design. Regards, mleo
£111 GBP em 4 dias
5,0 (9 avaliações)
3,2
3,2
Avatar do Usuário
excel vba expert. check my profile. please send me a sample to give you a first glance of what you want.
£77 GBP em 3 dias
4,6 (15 avaliações)
3,5
3,5
Avatar do Usuário
Good day, As I understood, you will need an excel spreadsheet that will allow you to parse lots of files, grab those files for sales data, verify data consistency and finally collect that information for future reporting I will develop such an excel based application for you. Best regards, Vitali
£111 GBP em 4 dias
4,8 (1 avaliação)
3,0
3,0
Avatar do Usuário
Hi, I have over 8 years of experience working with Excel VBA. My skills include: 1. Reading/writing data from/to excel and other files (text, word, access)-using VBA 2. Scraping websites from within Excel VBA 3. Automatically generating charts and pivot tables from VBA 4. Making macros that react to user actions 5. Combining different charts (Line, column, candlestick etc) on a single chart Please send me a sample of input data to be processed along with further instructions so we can start the work. thanks & regards
£150 GBP em 3 dias
4,5 (8 avaliações)
2,8
2,8
Avatar do Usuário
sir ready for work thnks
£150 GBP em 3 dias
5,0 (1 avaliação)
1,8
1,8
Avatar do Usuário
hii im interest in your project i have already doing such work in freelancer you can see the sample work in my portfolio
£90 GBP em 3 dias
4,3 (5 avaliações)
2,2
2,2
Avatar do Usuário
I have experience in Excel and using VB scripts for analysis. I believe I am capable of delivering upto quality expectations. Please revert back in case you want to discuss further. You may send a sample file for demo and test.
£172 GBP em 7 dias
5,0 (1 avaliação)
1,6
1,6

Sobre o cliente

Bandeira do(a) FRANCE
London, France
4,2
4
Método de pagamento verificado
Membro desde jun. 15, 2010

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.