Do some data entry
$30-250 USD
Paid on delivery
I have some work, in an Excel spreadsheet. Goal: To create a conditional spreadsheet that modifies the rating of other fills to show linkage and impact.
Details:
Attached is a spreadsheet with a X and Y pivots
The X row has the following information
Risk Management which has a rating from 1 to 5
Schedule Adherence which has a rating from 1 to 3
Decision Management which has a rating from 1 to 3
Operational Efficiency which has a rating from 1 to 3
Cost Management which has a rating from 1 to 3
The Y column has the following information
Milestone A
Milestone B
Milestone C
Milestone D
Milestone E
I need you to develop the algorithm that changes specific areas of the graph to red, yellow and green based on inputs to the above X row per Y column.
For example,
If Risk Management for Milestone A = risk level of 5
Schedule Adherence for milestone A = 3
Cost Management for Milestone A = 3
***(each number is aligned with a color red, yellow, green)
Now, if an user wants to change the X row for the same milestone A, for example
Operational Efficiency has been changed to 3
Risk Management will be reduced by 1 point but not less than its minimum value
Schedule Adherence will be reduced by 1 point but not less than its minimum value
Decision Management is not affected by Operational efficiency
Cost Management will be reduced by 1 point but not less than its minimum value
Here are the linkage:
Risk Management affects
Schedule, Cost
Schedule Adherence affects
Risk, Cost, Operational Efficiency
Decision Management affects
Schedule, Cost, Risk
Operational Efficiency
Schedule, Cost, Risk
Cost Management
Risk, Schedule, Decision
Here are the number schemes
Risk Management = 1, 2
Schedule and Cost = 1
Risk Management = 3, 4
Schedule and Cost = 2
Risk Management = 5
Schedule and Cost = 3
Vice versa for Schedule and Cost.
Decision Management = 1
Schedule, Cost, Risk = 1
Decision Management = 2
Schedule = 2; Cost = 1, Risk = 3
Decision Management = 3
Schedule = 2; Cost = 2; Risk = 4
Operational Efficiency = 1
Schedule, Cost, Risk = -1
Operational Efficiency = 2
Schedule and Cost = -1; Risk = -1
Operational Efficiency = 3
Schedule, Cost, Risk = -1
What does the numbers mean per X row
Risk Management = 1 (green) to 5 (red)
Schedule Adherence = 1 (green) to 3 (red)
Decision Management = 1 (green) to 3 (red)
Operational Efficiency = 1 (red) to 3(green)
Cost Mgmt = 1 (green) to 3 (red)
Project ID: #9905673
About the project
35 freelancers are bidding on average $99 for this job
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel Sir :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prameswara
Hi, We are extremely dedicated and professional freelancing team. We will complete all our project works within budget and time duration. We are expert in all types of Manual Data Entry and Data Processing Work, More
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I've done a lot of similar work. I could send you samples of my work if you wish. Please More
Dear Sir/Madam, I’m happy to help you on this task. I’ve read your brief and happy to discuss the project in more detailed. I am highly qualified for this project and have already done lots of similar excel dynamic te More
Hi there, I have a vast experience in Excel in VBA and would be happy to help you on the project. Best regards, Eugene PS. There is no worksheet attached but the task looks interesting.
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Build a reservation system - Build a complex shift allowance c More
I am experienced in VBA and can conduct event based routine that can change the color of specific fields based on the values of some areas in the excel.
hi i am an excel-vba Expert and I can help you with your project pm me I am ready to start now and I am the fastest
Hi, I have 7 years of experience in MS advanced excel data analysis, manipulation, reporting, dashboard, file linking, scenario managers, conditional formulation, formatting and VBA automation. I can connect your More
Hi, I can complete your project on time and within your budget. 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 More
Dear Sir, I am a MBA student with strong grip on MS Excel. Working in excel is part of our routine, I have handled data of more than 3000 entries, worked on stock analysis, developed operational model for a satellite More
Hello, I have very good knowledge of MS Excel such as formulas, pivot tables, layouts, formatting, charts, Macro. Work will be done accurately, efficiently and as per your requirement. Please contact with me regarding More
Hi, I am interested in your data entry job. I am a fast and accurate data entry personnel. I will get the job done on time in an efficient manner. I am a detailed oriented person and have several years experience in t More
Hello Sir, Hope you are doing well. Just bid on the project I read your Job description and I well understand the work you are looking to be done, I can surely assist you on the same. As far as my other experience is c More
Hi, I have 8+ years of experience. Can we discuss the project? Please initiate a chat with me so that we can discuss the project at a broader level. Why you should hire me- 1. I have a very good communicati More