Create Excel Pivot Table and Chart

Completado Publicado hace 7 años Pagado a la entrega
Completado Pagado a la entrega

I have raw data that I get from our phone system. I would like to be able to display it to show the number of inbound calls we get each week. I think the correct way to do this is with a Pivot Table, but it doesn’t have to be done that way. The resulting Excel file will be one where I can use the “Change Data Source” and point it to any of the output files from our phone system and have it generate the table and chart shown as a sample screenshot attached. It does not have to be EXACTLY like my example, but this is the information I want to show.

NOTES ABOUT THE DESIRED EXCEL TABLE AND CHART (see [login to view URL]):

-The parts highlighted in Red must be included, I don’t care if the other columns are there or not.

-The data source may be one day or it may be a few years worth of data, the Excel table/chart that you build must be able to react properly to any quantity of data. You can set a limit of 3 years if that helps.

-For this purpose of this, weeks ENDS on Sunday. I have looked at the WEEKNUM function in Excel and this is possible.

-Even if a week has less than a full week’s of days, it should still be shown.

-Please use the week ending date on the chart’s X axis as I have shown in the screen shot (not week numbers).

-Weeks should be sorted Oldest to Newest (top to bottom in the table) and (Left to Right in the chart).

-Please include a trend line (shown in light blue on my sample).

NOTES ABOUT THE DATA FILES:

-FORMAT: They come from the phone system as CSV files. I would prefer to use them as CSV, but it doesn’t seem that Pivot Tables can use CSVs as a data source. If you can make it work with CSVs that is great, but if not, you can assume that I will open the CSV and save it as an XLSX. I will not make any other changes to the source data.

-FILTER: Only include records/rows that have they “Type” (column C) is equal to “Inbound Call”. If they are blank or say something else, do NOT include that row.

-FILTER: You should only include records/rows were the “Minutes” (column B) is greater than “1” (do not include 1).

-SAMPLES: I have attached 3 sample data files. One with 3 days of data, one with 2 months of data and one with 12 months of data. I have left these in the CSV format.

END.

Excel

Nº del proyecto: #13428483

Sobre el proyecto

38 propuestas Proyecto remoto Activo hace 7 años

Adjudicado a:

jmtamez2203

Hi there - My name is Manuel. I’ve read your brief and can see that you’d like to have an Excel file to analyze inbound calls. I am new in Freelancing, but I have more than 10 years designing Excel for data analysis on Más

$28 USD en 1 día
(1 comentario)
0.9

38 freelancers están ofertando un promedio de $37 por este trabajo

sandroshubladze

Hi I am Excel Expert and VBA Programmer (for macros) I can create for you desirable worksheet If interested, contact me Thanks & Regards

$100 USD en 1 día
(199 comentarios)
8.2
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Más

$50 USD en 1 día
(346 comentarios)
8.0
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 USD en 1 día
(401 comentarios)
7.6
ksriniravi

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporti Más

$35 USD en 1 día
(209 comentarios)
6.9
beltran0404

Hello, I am Luis from Venezuela and it will be my pleasure to assist you in this project. I handle microsoft excel very well and I can do this for you. I handle pivot tables and charts. Please contact me by chat Más

$25 USD en 3 días
(142 comentarios)
5.7
satishtl

- Went through the csv and the images.... - Can be done like this. You specify the folder where the csv files are, and have the duration entered ie start date and end date.... - Based on the period the chart can be p Más

$100 USD en 4 días
(49 comentarios)
6.0
prabakarm23

I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I ha Más

$50 USD en 3 días
(48 comentarios)
4.6
EngrShahidul

I am much experience in Excel and SPSS data analysis, power pivot table, regression (Trend line) & correlation analysis, statistical test, linear programming, formula creation, graph creation and report writing. I have Más

$55 USD en 1 día
(39 comentarios)
4.8
scorpionobaid01

Hi I am here to assist u inthis project I am an ACCA member currently working in finance dept of Qatar Airways Have great skill and experience in Ms excel can assist u with high regards Plz share more info to proceed Más

$20 USD en 0 días
(23 comentarios)
4.2
anachirilov7

Hello! Please send to me more details about this project and i'm ready to start work right now. Select me please.

$30 USD en 1 día
(14 comentarios)
4.4
Michashica29

My Pleasure to do your project. willing to start as soon as possible...i am a data encoder thats why i think i like working with sharp deadline but high quality data...

$15 USD en 3 días
(7 comentarios)
3.6
bluefox4ever

Dear Hiring Manager, I want to do your job/project now, let's start immediately. I have read the job description. I've been working in a BPO company for more than 13 years now. My job there honed my skills to be Más

$35 USD en 7 días
(9 comentarios)
3.4
fb57e1f6608abfb

I have 4+ years experience in data analytics, working on small excel reporting to big DWBI reporting work. I am an expert in developing user-friendly spreadsheets for data analysis and visualization, creating interacti Más

$30 USD en 0 días
(7 comentarios)
3.4
Moh6335

Hi, Greetings. We have read your project description and would love to extend our assistance. We are a team of professional Accounting & Finance specialist with working experience of different Accounting and Statis Más

$25 USD en 2 días
(2 comentarios)
3.1
JMMachado

Hi, I think I can help you in this project. I have 20 years in the development of Ms. Excel spreadsheets, including pivot tables, macros and VBA programming. I'll be glad to help. Best regards, José M.

$20 USD en 4 días
(2 comentarios)
3.0
anmolmathcs

-Expertise in Excel work. -High quality formating and 100% error free work can be expected. -Quick turn around time

$25 USD en 1 día
(4 comentarios)
2.8
financepro201

Hello, My name is Alex and I am an experienced user Excel. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I read through the job details extremely ca Más

$30 USD en 1 día
(2 comentarios)
1.5
melanciaa

I have worked with Pivot Tables for more than 10 years and have even taught others. I can complete your project within 1-2 days max.

$30 USD en 1 día
(0 comentarios)
0.0
athiqahmedindian

A proposal has not yet been provided

$15 USD en 1 día
(0 comentarios)
0.0
tabasam2222

Your proposal is your first (and perhaps only) chance to make a good first impression to the employer!

$15 USD en 1 día
(0 comentarios)
0.0