Closed

Write some Software

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

Skills: .NET, Data Mining, Data Processing, Excel, Python

See more: it call centre, i need a call centre, statistics python, write some code, statistics R, some software, R software, python excel, old software, excel python, chr, python convert file csv, convert excel python, write macro, excel macro row, excel macro develop, excel macro csv, excel required csv, python convert csv, python convert file, excel 2014 macro, convert code excel, excel report macro, convert raw data excel, raw data csv

About the Employer:
( 0 reviews ) Australia

Project ID: #5405291

30 freelancers are bidding on average $20/hour for this job

sysx

Hi I am experienced Python developer, I worked with the big data project once, so I can help you with your project. I can do that for you in Python. I can do only bulk Excel file update like inserts. Macroses are More

$28 AUD / hour
(12 Reviews)
5.8
dvfabia

Hi! How are you today? I am interested in your project. My expertise is .NET so I will develop a Windows application for your project. I like to request a sample CSV file and the Report for my review. It seem More

$11 AUD / hour
(82 Reviews)
5.6
rohanjshah

Hello Calebadams, I can make you such tool or macro (for Libre Calc) in Python. I want to understand further in detail from you the requirement, as currently as you mentioned it is driven by Macro, but whether you More

$35 AUD / hour
(14 Reviews)
5.4
NTechcorporate

Hi, Hope you are doing well! We have gone through your requirement and we understand that you are looking for highly skilled, qualified, and experience Python development team for your project. Our developer More

$18 AUD / hour
(7 Reviews)
5.1
aoefmpes

Hello Sir, i have experience on text processing(csv, excel) i can help you write app convert raw data to report excel pl ping me and give me details thanks !!!!!!!!!!!!!!!!!!!!!!

$20 AUD / hour
(21 Reviews)
5.0
expertatwork

hey calebadams, please share the Excel report and input file, we can use Excel macro to achieve this, please reply, we can discuss further, thanks

$8 AUD / hour
(59 Reviews)
4.8
SiroosJafary

Good day, No attachment found. would you please send me your files? I will provide you some samples as well. please message me. I am expert. I teach excel. I can say there is no formula in excel that I cannot handle More

$22 AUD / hour
(22 Reviews)
4.7
bdprofessional1

Hello, We are an Ahmedabad (India) based software and mobility solutions provider company having the team of dynamic & highly technical developers. We are having developer having experience in the range of 2-12 yea More

$13 AUD / hour
(3 Reviews)
4.6
murtaza1981

Hi, An ASP.NET,c#,vb ,SqlServer,JQuery,Javascript expert here. Please feel free to discuss the project with me so that i can wrap it up in a timely manner as per your requirements. I would like to highlight following More

$12 AUD / hour
(8 Reviews)
4.3
gokulanand

Hello, I can get you a VBA code to generate the report in Excel. I had done similar kind of assignments in the past. You can check out my recent projects and reviews. I shall guarantee that the result will be of err More

$15 AUD / hour
(11 Reviews)
4.2
trustus

Hello, Attachment Missing ! Please come in chat to discuss. We work 9 hours daily, 5 days a week. Our timezone is GMT+5.30. You will be able to directly communicate with our technical expert. Please find More

$6 AUD / hour
(5 Reviews)
3.9
vaibhav585

Hi celebadams how are you ! I am vaibhav and i suppose this can be done using VBA ( Visual basic for application ) i will need to see the raw data and excel report that you want to be NO attachment in your post t More

$10 AUD / hour
(14 Reviews)
3.8
goswamiarpit475

Hi Sir, I am ready to work for you.I have 4 years of experience in C#/sql. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within time frame. Please v More

$11 AUD / hour
(11 Reviews)
3.7
BDtW

Hello, From your description I understand that data needs to be extracted from a CSV file based on something like Caller IDs or something, and properly grouped/calculated and presented in an excel format. I've do More

$7 AUD / hour
(7 Reviews)
3.3
nicu66pr

A proposal has not yet been provided

$20 AUD / hour
(1 Review)
3.1
nirandas

Hello, We'll use c#.net or node.js etc. What OS do you have? windows or Linux - Do you need database oto tore the extracted info or only a utility which extracts the report from given data and doesn't store anythin More

$46 AUD / hour
(4 Reviews)
3.1
xueming0723

A proposal has not yet been provided

$55 AUD / hour
(3 Reviews)
2.8
Vasilchenko

Предложение еще не подано

$16 AUD / hour
(2 Reviews)
2.9
designvin

Hello, I have a good experience in Python and Data processing. I wish to bid this project. Can you please send a sample data file. Ready to start immediately. Thanks Vinod

$16 AUD / hour
(2 Reviews)
2.0
UFours

I am expert C#, Asp.net, VB.net programmer. I have more than 5 years of experience. I also have skills in the Jquery, Json, Entity, MVC, Ajax, Javascript, CSS3, HTML and WPF. Please prefer me for this work. I am eag More

$25 AUD / hour
(2 Reviews)
2.0