weighting votes calculation

While I have some general ideas for this, I'd like to develop an excel sheet to use repeatedly to weight a small group of highly detailed votes at 60% and a large group of basic votes at 40%. Any suggestions?
Sure, I am seeking the best approach to set this up. I just wondered if someone already had an idea of how to do this. I will take a few minutes and test one out soon.