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 [login to view URL] contains 11 worksheets that need data aggregated based on the Metrics [login to view URL] 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
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 ticket was opened / closed (1440 hours per day). Shall take care of this as specified in the description please.
Let me know and I shall deliver the completed work within a week.
Regards,
Arul
$222 USD en 7 días
5,0 (222 comentarios)
7,4
7,4
13 freelancers están ofertando un promedio de $182 USD por este trabajo
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 bidders who have zero failed projects since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Thanks, Jay
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 response. Thanks.
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.
Looking forward to hear from you.
We can start as soon as you award this project to me.
Thanks
Abhinov
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.
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 using.
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 profile/project complete)
I'll put my best effort to complete it within 5 days or less.
Kind regards,
LY
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 details of the work.
Regards!
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 functions or sets of all that to get your project completed. It will be designed as so flexible that you can also extent sheets, data area, charts parameters, dynamic criteria any things you want after completion of the job. Please note that I cant lower my bid any more.
Thanks.
Best regards,
Asis Dev