Rating reports from Excel

[sagarkharpude]

Hi,

I have to develop some rating reports based on the raw data. I have attached sample excel for your info.

In excel Raw data is starting from Row 12. And i want to build tables which are just above to that Raw data.

(Tables highlighted in Yellow color).

I am calculating Trainer 1 Knowledge ratings from P column in Raw data and Trainer 1 Overall rating from Q column.  Likewise for Trainer 2 Knowledge ratings from V column in Raw data and Trainer 2 Overall rating from W column.

Other Challenge which i am facing is that Right now we have only 2 trainers, it may be possible that there will be addition of N trainers in future.

So i would be grateful if you could suggest me the optimized way to do that.

Thanks

Sagar

[Gysbert_Wassenaar]

Your data doesn't seem to contain any information about the trainers. You will probably want to use the CrossTable function to pivot the data. See this blog post: The Crosstable Load. You may also want to create a table that maps the scores to the rating labels.

[ThornOfCrowns]

What have you tried and what problems did you encounter?

[sagarkharpude]

Gysbert, Column P & Q is for Trainer 1 and V & W is for Trainer 2.

Please refer the calculation done in the output table (highlighted table) for details.

[sagarkharpude]

James, I am checking the possibility of Concatenation/generic load/cross table but want to know if any optimized way.

[sagarkharpude]

Hi Friends,

This is achieved by Cross table and transformation done using concatenation.

Thanks for your support