I'd draw the table more like this
Metric Weight Percent Score Weighted_score
Leadership 40 40% 2 0.8
Punctuality 20 20% 2 0.4
Cleanliness 30 30% 2 0.6
Responsiveness 10 10% 2 0.2
Total 100 100% 2.0
Then remove one item and you don't have to change any weights, just calculate the new percentages and weighted scores:
Metric Weight Percent Score Weighted_score
Leadership 40 50% 2 1.0
Punctuality -- --% N/A ---
Cleanliness 30 37.5% 2 0.75
Responsiveness 10 12.5% 2 0.25
Total 80 100% 2.0
A percentage is just a type of weight but weights don't have to add up to 100 while percentages do. So dealing in weights that aren't (necessarily) percentages is more flexible and easier to understand when you have a problem like this.
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|