Find Jobs
Hire Freelancers

Create a Dynamic Excel Sheet

$30-250 USD

Completed
Posted over 4 years ago

$30-250 USD

Paid on delivery
About the Excel Sheet:- The excel Sheet is created to track new system changes “CR” performed by IT department and check if there is any system issue which might impact business users ”Testers”. The sheet will be used by 3 team members who are responsible to update the project status. Scope Of Work:- Create Dynamic excel Sheet which can calculate any delay through various departments and the outcome of the Sheet should be PPT Slide by introducing the following. • Create 5 Input forms starting from Cell (AE till AI) once the user click on the cell input form to be opened with the below fields o Issue Type (TT/PDI) Drop Down menu. o Reference Number: If above field value = TT then the reference number should start with SD and then the user can enter 5-8 digits TT number on other hand if the user selected value PDI then the reference number should start with IM_ and 5-8 Digits to be manually filled. o Pending With: Drop Down menu (CO,PI,RA,BI, DSP and Channel Ops). o Creation Date: to be default value of Today Date however user should be able to edited and it should be a calendar. o Status: Drop Down Menu (In Progress, Pending with IT, Pending with Tester, Resolved, Escalated Blocking defect). o Ageing: Auto Calculated field (Creation date - Today date) o Closure Date: To Be selected from calendar manually by the user o Brief Comment: Free Text field o Detailed Comment o 2 extra Blank Fields Once the user fill the form all the information will be filled inside the Cell and the same should be applied for all above 5 cells on other hand user should be able to click anytime at the Cell and the same form will open with the same old values and users can update the values and save the data, it will be updated except for Detailed Comment each time the user fill it. it should capture today date and the new comment. Finally the SD# Should be Highlighted with Amber if the creation date is more than 2 Days from today date and should be Highlighted in Red if the creation date is more than 5 days from today Date. • Column AD : Should concatenate all the values from AE to AI. • Column L to P: Should accept only Percentage from 0-100 (if the value is less than 75% after 5 days from Actual RFS date “Column G” then the Cell Color Should be Amber and should be Red if the value is more than 7 days. o Exceptions: to the above rule that if there is any TT with status Blocking Defect from AE to AI Column the 7 days timer should stop for Column L to P until the TT Status is resolved. Please note that this should be only applied if the TT status is blocking defect any other status will remain business as usual. • Column A: must Start With ENT_ 4-7 Numbers. • The Sheet “PowerPoint is reading the values from ” Manually filled Sheet. • All Dates Fields on the Sheet must be selected from Calendar input • Column V: Should have Automatically the average value from Column L to P • Column W: Should have Automatically the average value from Column Q to U • Column H: Should have the number of days between Column F and G • At power Point Sheet once the user click on Generate PPT Template the attached Template should be Generated However please note that each GTM SPOC Column C should have one Separate slide • Each Slide Should not take more than 6 Rows and then a new slide to be generated for the same GTM spoc in case he have more than 6. • PowerPoint Sheet Comment Will have The TT’s Reference Created on the manually filled sheet from Column AE to AI along with the latest Status and creation Date, the user should have the option to click on any TT# on the PowerPoint and Map it to the excel File to check the Full details of the TT.
Project ID: 21391257

About the project

34 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi! I have downloaded your Files I can help you with your Work Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some samples for you there. Please send me a message so we can discuss further details of your project
$180 USD in 7 days
5.0 (62 reviews)
6.5
6.5
34 freelancers are bidding on average $174 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$180 USD in 3 days
4.9 (587 reviews)
8.5
8.5
User Avatar
Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$200 USD in 3 days
5.0 (508 reviews)
8.0
8.0
User Avatar
Dear Client I am an experienced VBA developer and have served the clients throughout the globe. Please review my profile to get an insight into the quality of my services. I have reviewed your job and ready to proceed and will wait for your response to discuss any leftover details. Regards Ali
$250 USD in 7 days
4.9 (189 reviews)
8.2
8.2
User Avatar
Hi there, My name is Mauricio I'm the MS Excel expert from Trascender Global Team, with 4 years of experience in developing VBA projects interacting Microsoft Office programs. I've read the details of your project and I'm highly interested in working with you to create the dynamic Excel spreadsheet you need that will help you to calculate any delay through various departments. The file will have the form to update the AE to Ai columns comments, leaving the date and time of the comment and will generate the PPT template based on the information received. It will also do all the tasks that are contained in the Word description attached to this project. Let's chat so we can talk about the details of this project. Looking forward to hearing from you.
$200 USD in 7 days
4.9 (188 reviews)
7.9
7.9
User Avatar
Excel expert!! I have read your project details, and understand most of it.. I have done similar projects before, and can create the dynamic sheet, as requested. ZERO ERROR GUARANTEED!! Please read my 400+ reviews, I am here to impress you with my work.
$350 USD in 5 days
4.9 (332 reviews)
7.8
7.8
User Avatar
Hi, I am interested in your project and like to handle it. Let us discuss the details in messages. Send to me a message.
$366 USD in 7 days
5.0 (66 reviews)
7.9
7.9
User Avatar
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$200 USD in 5 days
5.0 (333 reviews)
7.4
7.4
User Avatar
Hi, I have read all attachments about GTM. I can create automation in excel and also generate ppt as required. I have extensive skills and experience in VBA, and have done tons of projects. Let's have a chat for more detail discussion.
$100 USD in 3 days
4.9 (212 reviews)
6.6
6.6
User Avatar
Hi. Great app writer for your projects. I have writen scraping, excel, csv, database app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
$140 USD in 7 days
5.0 (256 reviews)
6.8
6.8
User Avatar
Hi there, I am an expert Visual basic developer. Since excel macro is written in vb, so I think I can perform this task in a more controlled way. I have helped my previous clients with custom dashboard building so that it can ease their day to day business. I will create you this excel dashboard which will help you and your team to process delays and other business tasks in a more controlled way. And at the end, I will place a button to generate ppt as well which will not contain more than 6 slides. Having 5 years of experience, Please reply if interested.
$350 USD in 5 days
5.0 (74 reviews)
6.3
6.3
User Avatar
Sir,      I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards
$177 USD in 3 days
4.7 (64 reviews)
5.9
5.9
User Avatar
Hi Myself expert in Dot net technologies with 14 yrs of experience in software development. Developed various web and desktop based projects in Finance, Insurance, Research, Education , Research and Retail Domains. Worked in technologies : Asp.net Mvc5.0/4.0/3.0 and Asp.net webforms 4.5/4/3.5/2.0 with c# as programming language, C#.net, wcf, webservices & web apis, Sql server, bootstrap, jquery, javascript, ajax, xml, json, linq, entity framework, ssrs & crystal reports, telerik & devexpress controls. Let me know your requirement in details. Payment terms: 1. 20% milestone release on awarding project. 2. 20% milestone release on phase1 Development 3. 20% milestone release on phase2 Development 4. 20% milestone release on Uat start. 5. 20% milestone release on UAT sign off , project closure and source code handover. Awaiting for positive response. Thanks and Regards..
$250 USD in 15 days
5.0 (7 reviews)
4.2
4.2
User Avatar
مرحبا سيدي Dear I read your description and I have found that your job very interesting And it would be easy to be done at a short time you can see in my profile that i'v done lot of works in Microsoft office and excel as well ---------------------------------------------------- it would be nice to work with you sir :-D Thanks
$195 USD in 5 days
5.0 (8 reviews)
3.3
3.3
User Avatar
I can create mini-app in Excel VBA for you. Please see my work in portfolio. "I have 10+ years of experience working with Microsoft Excel (+VBA Macros development), PowerPoint, Word. I am also very good at capturing data from internet and organizing it in a way which becomes very easy to retrieve for self as well as others. I also have proven experience of maintaining data privacy, business ethics, speed, and accuracy of parameters and English language. Data privacy, safety is one of my focus areas. I am willing to sign an NDA if required. Please see my creations in Excel workbooks. I deliver Excel, Reporting, dashboard, VBA Macros repairing, creating projects for Schools, University and Corporates. Most of my clients so far are from Denmark, Sweden, London & India. You can see my work on my Freelancer portfolio page." " Thanks & regards, Sameer Patole …"
$135 USD in 7 days
5.0 (6 reviews)
2.8
2.8
User Avatar
Hi: I am a BI Expert. I enable any organisations' data breathe.....Excel & Tableau are my forte....Im based out of Chandigarh & also have office in Duabi & Sharjah & working as freelancer as most of my projects are on auto pilot mode..... I have made some strong & interesting Dashboards for big corporates. If you would like to visualize your data in Tableau, Power BI, Qlik with handy filters which shall allow you to take quick decisions, I shall be happy to help. I can do the data connectivity & integration from a variety of data sources. I will help you create a single customized dashboard/report with all your data sources that can generate business insights and help you decide your next set of action steps to rapidly analyze and improve your business. Added Advantage: Being a Chartered Accountant, I understand the Financial impact of transactions Major clients I'm handling currently is HT Media & Toyota, Ford with huge data & variety sources. Im also a consultant to BCG, Infosys, Deloitte & KPMG I’d love to hear more about what would make this project a success for you, and explore if we’d be a good fit to work together. You can connect with me at 9872999467 Regards Ekta
$220 USD in 2 days
5.0 (1 review)
2.0
2.0
User Avatar
Hi, I can work with you on creating this workbook. I have more than 10 years experience in advanced excel and macros. Thanks Amer
$110 USD in 3 days
5.0 (1 review)
0.6
0.6
User Avatar
Hi There. I'm glad to say that I'm Able to do it in a very Better way. My Goal is 100% client satisfaction. I'm patient and willing to do whatever is necessary to provide excellent final results to my client. Please Hire me Kind regards Gilberth
$166 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am interested in this project. Years of experience in doing data entry and QC checking. If I get this work I will do it most sincerely Relevant Skills and Experience Studied computerized professional accounting, diploma in electronics engineering. Worked as a process associate
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Professional in Informatics, programming and Administration, great capacity analysis, responsible, efficient and effective in the assigned task, it will be a pleasure to successfully complete your project
$244 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Sir, I AMAL BABU K C, from kerala, india.. i am well experienced in online fields such as article writing, microsoft office works, ad posting works.. etc.. i will do ur project as soon as possible Relevant Skills and Experience EMAIL MARKETING MICROSOFT OFFICE Ad posting PROMO creating Logo design
$35 USD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED ARAB EMIRATES
Dubai, United Arab Emirates
5.0
69
Payment method verified
Member since May 12, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.