|This is going to take some time, so please be patient.|
First, let's get our sheet layouts correct so we are both working with the same data.
Sheet 1 looks like: ( I have abbreviated your headings)
A B C D
1) Analyst # cases rvwd # Admin errs Quality score
2) Linda Scott
Sheet 2 looks like:
A B C D E F
1) Analyst # cases rvwd # Admin errs # Prcdurl errs Dductn Max score
2) Linda Scott 5 7 0
3) Linda Scott 1 0 5
Are my sheets correct?
You included this data:
1.5 *5, .75*7 100*2 (Linda reviewed 2 cases) = 200
.75*5 (add together)
but I don't know where it goes or what it is supposed to represent.
Are they formulas of some type?
Where does the 1.5 and .75 come from?
then on sheet 2 column g:g
You do not have a column G listed.....
When using the < PRE > tags, I have found it easier to convert the TAB's in the data, to Spaces.
Excel uses TABs as it's delimiters.
To accomplish this use a Text Editor or Notepad, then do a Search and Replace.
For Notepad it is search for: ^T
and replace with an actual space.