How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask The-PC-Guy Your Own Question

The-PC-Guy
The-PC-Guy, Software Engineer
Category: Programming
Satisfied Customers: 1842
Experience:  Extensive Knowledge in PHP, MYSQL, CSS & Javascript
62934938
Type Your Programming Question Here...
The-PC-Guy is online now

I have a list with associated values that I need to assign

Customer Question

I have a list with associated values that I need to assign percentages to. It's hard to explain without showing the data.
Submitted: 2 years ago.
Category: Programming
Expert:  The-PC-Guy replied 2 years ago.
My Name is Andrew, I will be helping you today. If I provide good service, you may ask for The-PC-Guy in your question title for your future needs.

you can upload your file by following these instructions

http://ww2.justanswer.com/how-do-i-send-photo-or-file-expert

Customer: replied 2 years ago.
Expert:  The-PC-Guy replied 2 years ago.
ok, i have the file,

what are you looking to do?
Customer: replied 2 years ago.

Each "RUG"(RUX, RUC,RUL....) has a rate associated with it. The first thing I need is a formula that can give me one blended rate. For example I want .75 of the rate to be from the RU category and .15 from RV etc. Next at the end of each rug is a letter A,B,C,V,X... I need to be able to say that of the .75 RU's .40 should be RUC and .15 should be RUB...


I need the formula to be dynamic so I can change the percentages. Hope this is clear enough

Expert:  The-PC-Guy replied 2 years ago.
so you want to know the totals?

So for example

if the leters in Column A start with RU you want the value in column E to be .75 of the value in column B? Then if it ends in C you want to have .40 of the .75 listed in column E, or if it ends in B, .15 of the .75 to be in column E?
Customer: replied 2 years ago.

correct

Expert:  The-PC-Guy replied 2 years ago.
here you go.

http://ge.tt/4LidJdk1/v/0?c

I changed your percentages for the first few rows as those are the only values you gave me.

The way this formula works, is you can put it in any cell that needs a percentage.

I added sheet 3.

I sheet 3 you will see a table of 4 columns

column A contains the start letters you want to look for

and B has its associated percentage

Same thing with columns C and D, but it is the End letter of the 3 letter combination you want to search for.

You can add as many rows as you need to that table, if a value is not found in that table the formula will assume 100% or 1 for that section, for example if you search for RUZ and there is no Z in the table in column C, it will just assume you want the RU percentage of .75

It is getting late where I am, if you need any changes, I will address it in the morning.

---------------------------------------------------------------------------------------------------------------

let me know if you have any questions, problems, or concerns

PLEASE DON'T FORGET TO RATE SO I AM PAID FOR MY TIME

IT WILL NOT COST ANYTHING ADDITIONAL BEYOND THE VALUE OF YOUR QUESTION

TO RATE, CLICK THE SMILEY FACES BENEATH THIS ANSWER


Do not rate negatively, instead continue the conversation with me so I can address any of your concerns

---------------------------------------------------------------------------------------------------------------

if you have any questions in the future you can visit my profile

http://www.justanswer.com/computer/expert-1expert-2rulethemall/

and ask a question right in my box,

also you can put "PC Guy only" in your question title if you want to get to me.


Expert:  The-PC-Guy replied 2 years ago.
you never told me if it worked or not.

I could correct any problems.

PLEASE DON'T FORGET TO RATE SO I AM PAID FOR MY TIME

REMEMBER IF YOU DO NOT RATE I GET ZERO

IF YOU ARE HAVING PROBLEMS WITH THE RATING SYSTEM LET ME KNOW
Expert:  The-PC-Guy replied 2 years ago.
are you seeing my messages?

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • ATLPROG

    ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7260
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
< Last | Next >
  • http://ww2.justanswer.com/uploads/SP/spatlanta2010/2011-6-23_12450_photo.64x64.gif ATLPROG's Avatar

    ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7260
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Computer Software Engineer

    Satisfied Customers:

    5514
    Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.
  • http://ww2.justanswer.com/uploads/lifesaver333/2010-10-17_191349_ls.jpeg lifesaver's Avatar

    lifesaver

    Computer Software Engineer

    Satisfied Customers:

    936
    Several years of intensive programming and application development experience in various platforms.
  • http://ww2.justanswer.com/uploads/EH/ehabtutor/2012-8-2_202016_1.64x64.jpg ehabtutor's Avatar

    ehabtutor

    Computer Software Engineer

    Satisfied Customers:

    766
    Bachelor of computer science, 5+ years experience in software development, software company owner
  • http://ww2.justanswer.com/uploads/eljonis/2010-01-06_130406_eljon2.jpg Eljon's Avatar

    Eljon

    Consultant

    Satisfied Customers:

    558
    Founder of StockCanvas.com
  • http://ww2.justanswer.com/uploads/FA/fael/2011-1-15_104041_profile500x500.64x64.jpg Rafael Martins's Avatar

    Rafael Martins

    Computer Software Engineer

    Satisfied Customers:

    446
    Desktop, Mobile and Web Developer. 7+ years of experience. Creative solutions provider.
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Software Engineer

    Satisfied Customers:

    320
    Extensive Knowledge in PHP, MYSQL, CSS & Javascript