Encerrado

Excel Reporting Macro on RealNetworks' log files

The goal is to transform RealNetworks' streaming server text-based log files into Microsoft Excel files with well defined columns. The resulting Excel files must then be used to produce audio/video file usage reports using the Pivot Table Chart feature.

The required Excel Macro must receive as input a variable number of individual log files, and produce one or more consolidated Excel files. Consolidation must be performed on the basis of the "mountpoint" field found embedded along the string of characters of the log data.

The description of RealNetworks's log file can be found in: [url removed, login to view]

Sample log files are provided.

A sample Excel Pivot Table is provided where all mountpoints reside in the same worksheet. The desired output is one Table per "customer". A customer is defined by each "mountpoint" except for the system-defined mountpoints:

* broadcast

* secure

* encoder

EXAMPLE 1:

original "filename":

broadcast/gartner/[url removed, login to view]

mountpoint= broadcast

customer= gartner

filename= gartner/[url removed, login to view]

fileextension= rm

EXAMPLE 2:

original "filename":

gartner/[url removed, login to view]

mountpoint= gartner

customer= mountpoint = gartner

filename= [url removed, login to view]

fileextension= rm

Only when the mountpoint value is system-defined ("broadcast", "secure" or "encoder") the expected output is the following:

* If the "filename" includes "esmas" (by far the largest customer) then a separate Excel file must be created. This workbook will be comprised of as many worksheets as days of the month are found in the input log files, one per day.

* If the filename does not include "esmas", a separate Excel file must be created. This workbook will be comprised of as many worksheets as customers are found, one worksheet per customer.

When the mountpoint represents a customer, a separate Excel file is expected per customer. The entire month's log data should fit in one worksheet.

In all cases, worksheet size can be reduced by discarding any log entry where either :

"bytes" = 0

"time sent" = 0

mountpoint = "admin"

There are two calculated fields that must be included in all Pivot Tables:

kbps = bytes * 8 / 1000 / 'Time Sent'

mins = 'Time Sent' / 60

## Deliverables

1) Complete and fully-functional working Macro in Excel format as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Complete ownership and distribution copyrights to all work purchased.

4) Pivot Table Charts including the following fields:

* date

* filename

* kbps

* mins

## Platform

Windows 2000

Windows XP

Office 2000

Office XP

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

Ver mais: video live streaming service, string library, rm chart, microsoft excel software, microsoft excel help, microsoft excel windows, log into, largest number, gartner, excel windows, microsoft macro, log time, customer data excel, admin data entry service, secure files, rm, pivot tables, pivot table excel, log files, live excel help, field reporting, excel service, excel reports, excel pivot, excel pivot table

Acerca do Empregador:
( 3 comentários ) Mexico

ID do Projeto: #2973545

4 freelancers estão ofertando em média $69 para este trabalho

icodeinvb

See private message.

$127.5 USD in 7 dias
(316 Comentários)
7.1
prasanna123

See private message.

$63.75 USD in 7 dias
(58 Comentários)
5.1
slavadvw

See private message.

$42.5 USD in 7 dias
(3 Comentários)
1.3
bigboabby

See private message.

$42.5 USD in 7 dias
(0 Comentários)
0.0