Do some data entry
$30-250 USD
Dibayar saat pengiriman
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)
ID Proyek: #9905673
Tentang proyek
35 freelancer rata-rata menawar $99 untuk pekerjaan ini
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, Lebih banyak
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 Lebih banyak
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 Lebih banyak
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.
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 65 projects, almost 55+ are complex VB/VBA projects, hence i can definitely deliv Lebih banyak
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 Lebih banyak
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 Lebih banyak
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 Lebih banyak
Hi, Greetings!!!! I am a Data Entry & Web Scraping specialist. I am very interested to see your job. Your job is very easy for me because I've deep experience in this type of work. I've confident in my ability. Lebih banyak
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 Lebih banyak
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 Lebih banyak
Hello, Thank you very much for this Do some data entry Project. I read through the job details extremely carefully and understand your required, for this I am absolutely sure that I can do the project very well. I can Lebih banyak
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 Lebih banyak
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 Lebih banyak
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 Lebih banyak
