The project entails make a program to "dump" Raw Logs from the server and to be transferred into a Excel spreadsheet. The following Pages and Titles need to be made:
Download Stats .zip (Date, Time, IP Address, User Agent, Referral);
Daily Download & Views (Date, # of D/Ls (.zip), # of Views (.gif), click Percentage (DLs/Views)) this is a Chart with two line graphs one for Downloads the other for Views;
Hi/Lows this page has the top three and lowest three of views and downloads. The chart columns have the server time, and the respect days.
And exact same Excel sheet is also needed except this one removes duplicate IP address' within 15 minutes.
Thank you for reading this look forward to speaking with you!
Hi, I have very good experience with VB programming and MS Office Application Automation. I have done several similar Excel Automation projects in the past, please PM for details.