I need an Excel Expert
$30-250 USD
Paiement à la livraison
I have an existing excel worksheet. I use it for monitoring work completed by our employees. The worksheet allows me to answer "y", "n" and "x" for each task (I select these from a dropdown list within each cell). I want to weight each of these answers differently and have them sum in a numerator and denominator that will yield a %.
The cells with the dropdown are color coded either red, yellow or white. Red are critical and count more points - yellow are of medium importance and count half of red and white do not count.
So...
Red cell y = 5
Yellow cell y = 2.5
Red cell n = 0
Yellow cell n = 0
Red cell x = 0
Yellow cell x = 0
White cell y - n - x = 0
I need a numerator and a denominator that yields a %. The denominator is the total points available if y was selected for all Red and Yellow cells (total possible points). The denominator is the total of all actual points.
The percent figure indicates what % of all possible points were attained.
Can you provide an estimate?
Nº du projet : #30899448
À propos du projet
Décerné à:
19 freelances font une offre moyenne de 93 $ pour ce travail
Note: I think, you meant "The numerator is the total points available if y was selected for all Red and Yellow cells (total possible points)" in the following paragraph - I need a numerator and a denominator that yiel Plus
Hi, I am an Excel Expert with Professional experience working with Excel. I believe I can do a great work for you and ensure your quality. I have more than 5 year experience with excel. Complete a lot of jobs on Freela Plus
Dear client, I have gone through your request and I would be able to complete the task within the requested timeline. I have a typing speed of more than 50wpm and I have expertise in Excel. My 3 main goals are to Plus
Hi! Thank you for the detailed description. I think I got the clue and the exact goal could be clarified quickly. I would be glad to discuss the details and complete that task for you. For my spreadsheet literacy pleas Plus
How are you? I am a software and write. I have also lot of experience in Designing. I have some rules and regulations before start of project: 1. Provide 100% work within deadline. 2. Provide unlimited revisions unti Plus
hi , I am excel expert who is creating advanced Mobil friendly complete work it's own your choice .iam first in this platform but customer services is my first priority. thank you
I will do it, i need to experience on this site so i will do it almost free. Please let me know if you'r interested on my offert.
Hello! I am a post graduate person. Having a experience of data analysis. Have good command on MS Excel as well as Word. I will complete your work in a given time bound with atmost quality. Would like to work for you.