I could give you my pricing technique if you like and you can adapt it to see how close you can get it to the PR$ prices and possibly use that? Or have you tried other pricing techniques to see if they work too? That way you could automate it off the NR value and not need to manually enter.

Note: I could only manage to get the 'Rating' tab to pull into excel. The neurals and work sheet tabs dont seem to work