Closed

Write some Software

This project received 34 bids from talented freelancers with an average bid price of $21 AUD / hour.

Get free quotes for a project like this
Employer working
Project Budget
$2 - $50 AUD / hour
Total Bids
34
Project Description

We require some code to be written that will convert raw data contained with the attached CHR/CSV file into a standard report format in excel. Reporting is required weekly from raw data extracted. .

The report that we need to develop is Call Statistics Reporting for the calls made by a call centre.

The attached CHR/CSV file shows raw data that is directly exported from our phone system. Essentially we need to report on a few key statistics for each person making calls.

A person is identified in the phone system by an 'extension'. In the example CSV file, there are two extensions - 8511 (cell Q1) and 8514 (Cell Q16). The key columns of data that we need are Q (date), R (time of call). Y (duration).

The format I require the data to be transformed into is shown in the attachment - REPORT FORMAT. This is an example of the old report we used to use. There was an excel macro that would pull in the data to row 51 and 329.

I am making an assumption that Python is going to be the option to do, however, based on your expertise, their may be some other way around it.

Please let me know if more information is required.

Thanks

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online