HI, I was trying to stay away from macros...my users are sometimes challenged by having to enable macros....

But I will take a look at the mapping potential.

Building on what was recommended earlier i.e. using table cells to pull/reference content controls. In my summary table I've linked to the content control value (text) which is B2 of the summary table. I'm trying to convert the text comment "Highly Accomplished" to a weighted value, however it doesn't seem to work unless I use the bookmark ref.

here is the formula I'm using:
{ IF { =B2 }="Unaccept*" "0" { IF { =B2 }="Develop*" ".25" { IF { =B2 }="Fully*" ".50" { IF { =B2 }="Commend*" ".75" { IF { =B2 }="Highly*" "1.0" "WTF" } } } } }