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.


DATE PREVIOUS RAZ: 13/11/2006 01:09:16

DATE RAZ: 16/11/2006 01:00:06


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 :


-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

Veja 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

Concedido a:


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 Comentários)

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


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)

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)

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)

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)

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)

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)

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

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

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)

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)

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)

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)

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

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)

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)

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)

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)

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)

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)

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)

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)