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
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].
36 freelancers are bidding on average £156 for this job
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
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
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.
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.
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!!