Завершено

Excel Reporting Macro for RealNetworks' Log Files

The purpose of the required Macro is to read, convert and organize text-based RealNetworks’ server log files into MS Excel workbooks, which in turn should be manipulated into Pivot Tables and Charts.

I have created a starting point Excel Macro (ImportLog) where the text-based input files are converted into Excel format and columns are detected.

I now need the macro to create multiple worksheets based on the mountpoint value of each record retrieved from the log files. In particular, the “esmas?? mountpoint generates so many records that it is impossible to fit them all into one worksheet. The macro must therefore create a separate workbook for all records containing the "esmas" mountpoint value, and split them into multiple worksheets based on intervals, such as per day or per week worksheets, whatever fits better.

For all other mountpoint values, a single workbook should suffice, where each worksheet contains only records stamped with a unique mountpoint value.

Once the workbooks have been created, I need to automate the creation of PivotTables for each worksheet. For the shared workbook, the PivotTable layout should be as follows:

Data = Bytes

Rows = Fecha

Columns = blank

For the ESMAS worksheets, the PivotTable layout should be as follows:

Data = bytes

Rows = hora

Columns = blank

Once the PivotTables have been created, I need to automate the creation of all the corresponding PivotCharts.

Thnak you for considering this project.

Alejandro Calero

Mexico City, MEXICO

## Deliverables

An Excel Macro that takes text-based input files and produces separate workbooks as output, as per specifications.

No separate exe files, please. I will be sharing this Macro with my own customers and do not want to raise concerns about safety, or installation questions.

Well documented code.

User instructions.

Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

Windows 2000/XP

Office 2000/XP

preferably 2000

Квалификация: Техника, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Архитектура ПО, Тестирование ПО, Visual Basic, Word

Показать больше starting with visual basic, excel split columns, work on ms excel, pivot tables, office macro, log files, excel PIVOT, excel charts, excel automate, create excel worksheet, convert exe, layout per instructions, convert columns text files, macro pivot, excel contains, multiple excel, excel create input output, reporting site, server log, excel macro read data files

О работодателе:
( 3 отзыв(-а, -ов) ) Mexico

ID проекта: #2988246

Поручен:

VladSharkovK

See private message.

$51 USD за 7 дней(-я)
(7 отзывов(-а))
3.9

5 фрилансеров(-а) в среднем готовы выполнить эту работу за $79

aabudara

See private message.

$68 USD за 7 дней(-я)
(27 отзывов(-а))
4.9
rcollvw

See private message.

$63.75 USD за 7 дней(-я)
(11 отзывов(-а))
5.0
gabrielaizcorbe

See private message.

$42.5 USD за 7 дней(-я)
(13 отзывов(-а))
4.7
rolandanderson

See private message.

$170 USD за 7 дней(-я)
(5 отзывов(-а))
3.2