Đang Thực Hiện

Create a Dynamic Excel Sheet

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.

Kĩ năng: Excel, Visual Basic, Microsoft Office, Kiến trúc phần mềm, Xử lí dữ liệu

Xem nhiều hơn: excel sheet marketing research survey data entry, data excel sheet macro, convert pdf data excel sheet, import excel sheet sql data base, getafreelancercom extract data website excel sheet, mysql data php create dynamic graphs, extracting data website excel sheet, search data excel sheet, sample data base excel sheet, create dynamic excel report visual basic, create worksheet excel sheet, excel sheet project status data sheet, powershell create user excel sheet, create thumbnail excel sheet, create view excel sheet, create script excel sheet, create stand excel sheet, excel sheet bse nse data, create product excel sheet magento, create standalone excel sheet

Về Bên Thuê:
( 17 nhận xét ) Dubai, United Arab Emirates

ID dự án: #21391257

Được trao cho:


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 a Thêm

$180 USD trong 7 ngày
(38 Đánh Giá)

39 freelancer đang chào giá trung bình $170 cho công việc này


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. Pl Thêm

$180 USD trong 3 ngày
(352 Nhận xét)

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 trong 7 ngày
(43 Nhận xét)

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 Thêm

$350 USD trong 5 ngày
(295 Nhận xét)
$250 USD trong 5 ngày
(293 Nhận xét)

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 procee Thêm

$250 USD trong 7 ngày
(141 Nhận xét)

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 trong 3 ngày
(326 Nhận xét)

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 proje Thêm

$200 USD trong 5 ngày
(234 Nhận xét)

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 a Thêm

$200 USD trong 7 ngày
(113 Nhận xét)

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 trong 3 ngày
(63 Nhận xét)

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 Thêm

$350 USD trong 5 ngày
(39 Nhận xét)

I have experience in web scraping and making scraping tool,automation tool Samples [login to view URL]://[login to view URL]!AjQ_3RyyWk98oAC-i0vgHzwU45Cg my recent Web scraping software which scrap data from [login to view URL] [login to view URL] hotfro Thêm

$140 USD trong 7 ngày
(19 Nhận xét)

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 trong 7 ngày
(16 Nhận xét)

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. Thêm

$250 USD trong 15 ngày
(4 Nhận xét)

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 d Thêm

$100 USD trong 3 ngày
(17 Nhận xét)

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 d Thêm

$135 USD trong 7 ngày
(5 Nhận xét)

Hello, How are you? I just saw your project description carefully. I am very interested in your project. I have rich experience in Python, PHP, Java, Data Entry, Web Search/Scraping, Excel, Word, VBA. I can help you Thêm

$140 USD trong 7 ngày
(7 Nhận xét)

مرحبا سيدي 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 e Thêm

$195 USD trong 5 ngày
(2 Nhận xét)

How are you doing today? I've just read your job description and now I am interested in your job. I gained a Master's Degree last year and I am good at computer handling. Besides, I've studied Marketing for 2 yrs. Thêm

$100 USD trong 3 ngày
(1 Nhận xét)

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 Thêm

$220 USD trong 2 ngày
(1 Nhận xét)

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 trong 3 ngày
(1 Nhận xét)