Em Andamento

Plain-text file analysis in Excel VBA

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 [url removed, login to view]

4T 5 LARGE COFFEE 11 [url removed, login to view]

4T 6 HOT CHOCOLATE 32 [url removed, login to view]

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 [url removed, login to view]

x 1 VAT 19.6% 1 0.33 1960E820

c 0 2 [url removed, login to view]

So, total sale tickets must match header figures.

Controls must be set up, statistics must be produced [for header and footer].

Habilidades: Excel, Visual Basic

Ver mais: tickets for less, match statistics, data analysis for excel, excel vba or, excel vba long, excel 2013 vba, statistics R, raz, plain, name coffee, Data analysis in excel , coffee name, analysis excel, analysis data excel, set analysis, vba analysis, 2013 excel visual basic, excel 2013 visual, date analysis excel, cost file, data analysis large excel data, column text, excel text column, file name excel, vba match excel

Acerca do Empregador:
( 4 comentários ) London, France

ID do Projeto: #5099460

Premiar a:

dviruki

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 Exc Mais

£73 GBP em 3 dias
(14 Avaliações)
3.5

36 freelancers estão ofertando em média £156 para este trabalho

Teloquence

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 in 0 dias
(155 Comentários)
6.5
seaanddream

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 achi Mais

£150 GBP in 5 dias
(53 Comentários)
5.9
priyal1997

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 in 3 dias
(71 Comentários)
5.7
deepbluetech

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 in 3 dias
(105 Comentários)
5.5
FIBIN

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% ac Mais

£100 GBP in 2 dias
(49 Comentários)
5.4
maverick44000

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 profic Mais

£150 GBP em 1 dia
(23 Comentários)
5.2
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [url removed, login to view] Looking for further discussions in this matter. with than Mais

£147 GBP in 3 dias
(24 Comentários)
5.2
dpune

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 in 5 dias
(16 Comentários)
4.7
elMancha

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 Mais

£150 GBP in 10 dias
(28 Comentários)
4.7
zExcel

Hi, I'd like to see one of the text files in order to make sure that is programmatically possible to automate this process ---------------------------------------------------------------------------------------------- Mais

£83 GBP em 1 dia
(15 Comentários)
4.5
ahetel

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 sugge Mais

£150 GBP in 3 dias
(20 Comentários)
4.2
Edison1983

*******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 Mais

£100 GBP in 0 dias
(11 Comentários)
3.7
inoussakabore

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 in 3 dias
(2 Comentários)
3.3
Aldo21

excel vba expert. check my profile. please send me a sample to give you a first glance of what you want.

£77 GBP in 3 dias
(8 Comentários)
2.9
hgk

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. A Mais

£150 GBP in 3 dias
(7 Comentários)
2.7
AccuPro

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 in 3 dias
(3 Comentários)
2.4
mleo1

VBA Programmer here. Got 6 years Experience in Web Programming, Software Programming and Database Design. Regards, mleo

£111 GBP in 4 dias
(2 Comentários)
2.1
NhatAnhIT

Hi limm. - I have read your requirement and understand it. With my experience in VBA excel, so i can complete your project withn 1 - 2 day (i will try my best to complete it soon for you.) . - After complete your pr Mais

£100 GBP in 2 dias
(1 Comentário)
1.5
vibink

Hi, I am an Excel VBA Programmer and an Excel designing expert with 5+ years of experience.I am very much interested in this project. But being a beginner in freelancer, I don’t have a high profile here. But I will Mais

£88 GBP in 2 dias
(1 Comentário)
1.4
dianagru80

HI, I am a 10 years proficient Excel users and I am sure I can deliver the expected results for your requirements. However I would need to understand why the header total costs contain letters? (eg 283.50EE20). What do Mais

£200 GBP in 3 dias
(1 Comentário)
1.4