Do some data entry

Cerrado Publicado Mar 10, 2016 Pagado a la entrega
Cerrado Pagado a la entrega

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)

Excel

Nº del proyecto: #9905673

Sobre el proyecto

35 propuestas Proyecto remoto Activo hace 7 años

35 freelancers están ofertando un promedio de $99 por este trabajo

prameswara

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

$30 USD en 1 día
(413 comentarios)
7.6
TechNamrata09

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, Más

$210 USD en 5 días
(61 comentarios)
7.1
khushh07

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

$95 USD en 2 días
(330 comentarios)
7.3
cugamelover

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 Más

$100 USD en 3 días
(179 comentarios)
7.2
priyal1997

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 Más

$90 USD en 1 día
(192 comentarios)
6.7
watersev

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.

$35 USD en 1 día
(255 comentarios)
6.6
kevivu

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 Más

$54 USD en 2 días
(83 comentarios)
6.1
archanaoswal

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 Más

$150 USD en 5 días
(81 comentarios)
5.9
vladimirmefremov

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.

$155 USD en 3 días
(9 comentarios)
5.6
abdolah2014

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

$250 USD en 3 días
(37 comentarios)
5.3
mallikasomu87

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 Más

$83 USD en 1 día
(15 comentarios)
4.7
rajafaizan

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 Más

$174 USD en 3 días
(28 comentarios)
4.5
NSSumi

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. Más

$100 USD en 3 días
(13 comentarios)
3.7
mrfarhanzahid

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 Más

$30 USD en 1 día
(15 comentarios)
3.6
UsmanNasar87

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 Más

$39 USD en 3 días
(19 comentarios)
3.2
tanmoyspi

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 Más

$30 USD en 3 días
(5 comentarios)
1.9
sophiapearce5441

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 Más

$155 USD en 3 días
(0 comentarios)
0.0
rahulnegi004

I will do your work perfectly... contact me now

$40 USD en 1 día
(0 comentarios)
0.0
yousuf1987

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 Más

$102 USD en 3 días
(0 comentarios)
0.0
satishskv1212

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 Más

$155 USD en 3 días
(0 comentarios)
0.0