I gang

Excel Graph / Metrics Macro Project - Relisted

Relisted project:

I'm in need of assistance in Excel to create graphs based on a metrics data dump. This is a two part project with the first part consisting of recreation/adjustment of the current worksheets and then a macro based formatting system to accommodate the metrics that get populated.

Sample [url removed, login to view] contains 11 worksheets that need data aggregated based on the Metrics [url removed, login to view] file.

I will run this report every Thursday for multiple departments which will have different information but will have the same layout to run against.

The graphs should all look the same and span through the entire date range. The best example is the Tickets Opened Per Week worksheet but it needs some minor work to expand the graph all the way to 2/5/15. I would like Open Support Ticket Avg Aging, Open Project Avg Aging, Average Turnaround Time, Week By Week Turn Time, Closed Tickets By Tech, & Turnaround Time By Tech to look the same. You could probably make one and copy it over to the other worksheets.

Avg Turn Time By Application, Tickets Opened By Application, Tickets Closed By Application should look similar.

SLA Breach By Tech looks fine and you can keep that graph format.

When the macro is finished running, please have it go to the first tab in the spreadsheet.

The first thing you’ll want to do is calculate the age of the ticket and put it in a column to the right. This will help for auditing and calculating other sections. The time should be based on the actual time the ticket has aged in minutes based on 1440 minutes in a day. If a ticket is opened and closed in an hour, it should reflect an hour but when calculated against the other figures in the week, it should reflect the time in days. *If you have questions or have a different way you would like to perform this action, please let me know before programming.

Keyword is located in one of the attachments. Please use it when bidding to ensure you have read and reviewed the requirements otherwise it will be ignored.

I have broken out each tab in a separate Word document to make it easier to troubleshoot and work on versus combining all of the specs in one document. If you have any questions, please let me know so no time is wasted.

Time is of the essence and I have assigned this to two other Freelancers already who could not accommodate so be sure to quote your time and price accurately. Coding should be kept clean and not contain any password protection so I can check the work and make modifications in the future if necessary.

Thanks,

Anthony

Færdigheder: Databehandling, Excel, Visual Basic, Visual Basic for Apps

Se mere: best calculate date metrics days excel, excel graphs metrics, which graph to use for data, use of graph, use graph, use a graph, the need for auditing, the graph, tech support freelancers, sla turnaround time, sample graph data, recreation programming, protection for freelancers, project quote sample, project is closed, programming project for freelancers, programming in excel, programming graphs, programming graph, part of graph, part of a graph, m format in excel, macro programming in excel, macro freelancers, in a graph

Om arbejdsgiveren:
( 15 bedømmelser ) Sarasota, United States

Projekt-ID: #5342638

Tildelt til:

deepbluetech

Hi Anthony, Had a few queries but they all got answered when I went through the Word files provided describing each Tab. The most important part as far this project is concerned is calculation of time since tick Mere

$222 USD in 7 dage
(136 bedømmelser)
5.8

14 freelancere byder i gennemsnit $183 for dette job

zExcel

Hi, My name is Jon and I will be happy to help you with the project. Please feel free to chat with me prior to accepting my bid

$177 USD på 1 dag
(45 bedømmelser)
5.7
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [url removed, login to view] Looking for further discussions in this matter. with than Mere

$147 USD in 6 dage
(34 bedømmelser)
5.5
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive Mere

$222 USD in 15 dage
(31 bedømmelser)
5.1
jaylancer43

Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche Mere

$222 USD in 7 dage
(45 bedømmelser)
5.1
magnussoft

I have just finished importing csv project, and the previous one was graph creation. The project is big and the ones that say hey will do this for less than 200$ - are the ones that will make you re-post it.

$277 USD in 15 dage
(28 bedømmelser)
4.6
AndroidAll

Dear Sir, I'm interesting in your job. I have much experience in the MS Excel and VBA. I can do this job. Regards. PS. In order to show my ability, I can send my sample files to you.

$200 USD in 3 dage
(7 bedømmelser)
3.8
samin59

Meet the perfect match for your project. Please contact for quality and result oriented services. Regards

$100 USD in 3 dage
(9 bedømmelser)
3.1
sibeng

I have 17 years development experience and have recently completed a reporting tool for a ticketing system based entirely in VBA excel, let me know how soon you require the software, and what version of excel you are u Mere

$222 USD in 15 dage
(1 bedømmelse)
2.1
XFastSolution

Dear sir, I've read your requirement, also checked the attached carefully. With expertise in Excel/VBA-Macro and much experience working with CSV parsing, filling excel..etc, I would be a good fit. (Please see my pr Mere

$80 USD in 5 dage
(4 bedømmelser)
1.9
abhinovpankaj

Hi, I am working as a Software Engineer from last 3 years. Currently I working on projects solely based on Windows platform and MS office applications specially Excel and VBScripting So,I am good option to go with. Mere

$177 USD in 3 dage
(1 bedømmelse)
1.4
jacobbs

A proposal has not yet been provided

$155 USD in 7 dage
(0 bedømmelser)
0.0
psikora90

Hello, I would like to work for you on this project. I'm a meticulous and hard working person who can deal with this task! Just give me a chance to prove you my skills. Hope to hear from you soon to discuss about det Mere

$150 USD in 3 dage
(0 bedømmelser)
0.0
asisdev

Your job is looking quite interesting. I work basically on macro, database, validation related to excel as well as SAP excel analysis, SCM analysis. financal reporting etc. I will provide you basic tools or macro or fu Mere

$211 USD in 3 dage
(0 bedømmelser)
0.0