Need help in getting right average of data.

Please see attached file for exact data structure and sample data.

Help will be greatly appreciated.