Varying Assigned Values

dscheikey 

Below is a sample table of what part of my spreadsheet looks like. This is on the first tab and we will have a large number of people using this. It's going to be an actual form that they will fill out and print, so we want to make it as user-friendly and legible as possible. What I'd like to do is to have the users be able to put an "x" in each of the rating columns and then the section totals and rating areas to fill in automatically with the data from the values on a second or third tab.
The sample file you provided would help, I think, if it was on a different tab. I'm just not sure how to set up that first tab so that it doesn't have a lot of formulas pulling from other areas that are able to be edited or deleted by the end-users. Also on your sample file, if the points column were whole numbers, I think that would help (at least in my mind) to show the totals in the format that the supervisor wanted.
The rating column needs to be the percent of the section that particular line applies to and the section total as a percentage of the performance score should be the portion of the 100% total performance score that section applies to. If my supervisor wants to change the rating percent for the section, he wants the other values to auto-fill.  I believe that your sample was allowing column D to be altered, but we need the end percentage in column L to be what is alterable.  My supervisor is wanting to do this with an extra column titled "Discretionary Rating" and when he puts something different in there, he wants the other information to automatically fill in correctly.

Also, if there is an Inadequate or Below Standard rating for any question in a section, then that section is limited to no higher than a standard rating.  Is it possible to do that?