consolidate ratings