Em Andamento

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

Habilidades: Engenharia, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Arquitetura de software, Teste de Software, Visual Basic, Word

Ver mais: starting visual basic, excel split columns, pivot tables, 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, charts excel, excel unique, log excel visual basic, automate excel code, convert code excel, excel record, php workbook, php macro

Acerca do Empregador:
( 3 comentários ) Mexico

ID do Projeto: #2988246

Premiar a:

VladSharkovK

See private message.

$51 USD em 7 dias
(7 Avaliações)
3.9

5 freelancers estão ofertando em média $79 para este trabalho

aabudara

See private message.

$68 USD in 7 dias
(27 Comentários)
4.9
rcollvw

See private message.

$63.75 USD in 7 dias
(11 Comentários)
5.0
gabrielaizcorbe

See private message.

$42.5 USD in 7 dias
(13 Comentários)
4.7
rolandanderson

See private message.

$170 USD in 7 dias
(5 Comentários)
3.2