Advanced SUMPRODUCT function for multiple weighted averages

[gigglesxx]

Hi

I am an analyst and I need help with an advance use of the sum product function for weighted averages.

I am trying to calculate three different weighted averages within 1 of 50 groups of data. Each of the 50 groups of data have a different weighting score (different importance). I have tried to use the basic =sumproduct(A1:A16,B1:B16)/sum(B1:B16) however this only takes into account the weighting score of just group 1 (group 1 range is from A1:A16) however does not adjust the averages according to the weighting of the other 49 data groups.

PLEASE HELP ME

I am relatively new to excel.

 

[cunningAce]

Can you post sample data?

 

[gigglesxx]

Hi

Thank you for replying.

I am not sure how to attach a file on this forum, however i have copied and pasted my data into this reply to give you a rough idea.

Just to clarify, I would like to find out the weighted average of group 1 (1.1, 1.2 and 1.3) for each class, taking into account the weighting score of this group in relation to the other groups and their score of importance.

I have tried =sumproduct(F2:F4,D2:D4)/sum(D2:D4) however this only takes into account the weight score 5 and does not compare it to the other groups and their weighting scores.

Is there a way i can expand the formula to include the other scores?

Or is the =sumproduct function not the right function for this calculation and maybe i should use something else?

Any help would be much appreciated


[TABLE="width: 735"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]NUMBER[/TD]
[TD]ORIGIN [/TD]
[TD]DESTINATION[/TD]
[TD]WEIGHTING SCORE (0 - 5)[/TD]
[TD]CLASS[/TD]
[TD]COST[/TD]
[/TR]
[TR]
[TD="align: right"]1.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 1[/TD]
[TD]5[/TD]
[TD]FIRST[/TD]
[TD] $ 100.00[/TD]
[/TR]
[TR]
[TD="align: right"]1.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 1[/TD]
[TD]5[/TD]
[TD]BUSINESS [/TD]
[TD] $ 86.00[/TD]
[/TR]
[TR]
[TD="align: right"]1.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 1[/TD]
[TD]5[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 31.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]2.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 2[/TD]
[TD]2[/TD]
[TD]FIRST[/TD]
[TD] $ 234.00[/TD]
[/TR]
[TR]
[TD="align: right"]2.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 2[/TD]
[TD]2[/TD]
[TD]BUSINESS [/TD]
[TD]-$ 41.00[/TD]
[/TR]
[TR]
[TD="align: right"]2.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 2[/TD]
[TD]2[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 104.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]3.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 3[/TD]
[TD]3[/TD]
[TD]FIRST[/TD]
[TD] $ 2,016.00[/TD]
[/TR]
[TR]
[TD="align: right"]3.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 3[/TD]
[TD]3[/TD]
[TD]BUSINESS [/TD]
[TD] $ 1,056.00[/TD]
[/TR]
[TR]
[TD="align: right"]3.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 3[/TD]
[TD]3[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]4.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 4[/TD]
[TD]2[/TD]
[TD]FIRST[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD="align: right"]4.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 4[/TD]
[TD]2[/TD]
[TD]BUSINESS [/TD]
[TD] $ 2,991.00[/TD]
[/TR]
[TR]
[TD="align: right"]4.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 4[/TD]
[TD]2[/TD]
[TD]ECONOMY[/TD]
[TD] $ 2,116.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]5.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 5[/TD]
[TD]1[/TD]
[TD]FIRST[/TD]
[TD] $ 273.00[/TD]
[/TR]
[TR]
[TD="align: right"]5.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 5[/TD]
[TD]1[/TD]
[TD]BUSINESS [/TD]
[TD] $ 3.00[/TD]
[/TR]
[TR]
[TD="align: right"]5.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 5[/TD]
[TD]1[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 171.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]6.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 6[/TD]
[TD]2[/TD]
[TD]FIRST[/TD]
[TD] $ 2,766.00[/TD]
[/TR]
[TR]
[TD="align: right"]6.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 6[/TD]
[TD]2[/TD]
[TD]BUSINESS [/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD="align: right"]6.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 6[/TD]
[TD]2[/TD]
[TD]ECONOMY[/TD]
[TD] $ 1,991.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]7.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTIANTION 7[/TD]
[TD]4[/TD]
[TD]FIRST[/TD]
[TD] $ 7,877.00[/TD]
[/TR]
[TR]
[TD="align: right"]7.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTIANTION 7[/TD]
[TD]4[/TD]
[TD]BUSINESS [/TD]
[TD] $ 6,092.00[/TD]
[/TR]
[TR]
[TD="align: right"]7.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTIANTION 7[/TD]
[TD]4[/TD]
[TD]ECONOMY[/TD]
[TD] $ 4,065.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]8.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 8[/TD]
[TD]4[/TD]
[TD]FIRST[/TD]
[TD] $ 7,227.00[/TD]
[/TR]
[TR]
[TD="align: right"]8.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 8[/TD]
[TD]4[/TD]
[TD]BUSINESS [/TD]
[TD] $ 5,342.00[/TD]
[/TR]
[TR]
[TD="align: right"]8.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 8[/TD]
[TD]4[/TD]
[TD]ECONOMY[/TD]
[TD] $ 4,368.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]9.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 9[/TD]
[TD]4[/TD]
[TD]FIRST[/TD]
[TD] $ 8,127.00[/TD]
[/TR]
[TR]
[TD="align: right"]9.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 9[/TD]
[TD]4[/TD]
[TD]BUSINESS [/TD]
[TD] $ 6,192.00[/TD]
[/TR]
[TR]
[TD="align: right"]9.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 9[/TD]
[TD]4[/TD]
[TD]ECONOMY[/TD]
[TD] $ 4,142.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]10.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 10[/TD]
[TD]4[/TD]
[TD]FIRST[/TD]
[TD] $ 6,636.00[/TD]
[/TR]
[TR]
[TD="align: right"]10.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 10[/TD]
[TD]4[/TD]
[TD]BUSINESS [/TD]
[TD] $ 4,961.00[/TD]
[/TR]
[TR]
[TD="align: right"]10.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 10[/TD]
[TD]4[/TD]
[TD]ECONOMY[/TD]
[TD] $ 2,901.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]11.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 11[/TD]
[TD]4[/TD]
[TD]FIRST[/TD]
[TD] $ 7,627.00[/TD]
[/TR]
[TR]
[TD="align: right"]11.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 11[/TD]
[TD]4[/TD]
[TD]BUSINESS [/TD]
[TD] $ 5,842.00[/TD]
[/TR]
[TR]
[TD="align: right"]11.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 11[/TD]
[TD]4[/TD]
[TD]ECONOMY[/TD]
[TD] $ 3,792.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]12.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 12[/TD]
[TD]3[/TD]
[TD]FIRST[/TD]
[TD] $ 8,590.00[/TD]
[/TR]
[TR]
[TD="align: right"]12.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 12[/TD]
[TD]3[/TD]
[TD]BUSINESS [/TD]
[TD] $ 7,696.00[/TD]
[/TR]
[TR]
[TD="align: right"]12.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 12[/TD]
[TD]3[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]13.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 13[/TD]
[TD]4[/TD]
[TD]FIRST[/TD]
[TD] $ 7,220.00[/TD]
[/TR]
[TR]
[TD="align: right"]13.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 13[/TD]
[TD]4[/TD]
[TD]BUSINESS [/TD]
[TD] $ 5,210.00[/TD]
[/TR]
[TR]
[TD="align: right"]13.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 13[/TD]
[TD]4[/TD]
[TD]ECONOMY[/TD]
[TD] $ 3,160.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]14.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 14[/TD]
[TD]3[/TD]
[TD]FIRST[/TD]
[TD] $ 7,002.00[/TD]
[/TR]
[TR]
[TD="align: right"]14.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 14[/TD]
[TD]3[/TD]
[TD]BUSINESS [/TD]
[TD] $ 5,317.00[/TD]
[/TR]
[TR]
[TD="align: right"]14.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 14[/TD]
[TD]3[/TD]
[TD]ECONOMY[/TD]
[TD] $ 4,787.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]15.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 15[/TD]
[TD]3[/TD]
[TD]FIRST[/TD]
[TD] $ 8,820.00[/TD]
[/TR]
[TR]
[TD="align: right"]15.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 15[/TD]
[TD]3[/TD]
[TD]BUSINESS [/TD]
[TD] $ 7,646.00[/TD]
[/TR]
[TR]
[TD="align: right"]15.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 15[/TD]
[TD]3[/TD]
[TD]ECONOMY[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD="align: right"]16.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 16[/TD]
[TD]3[/TD]
[TD]FIRST[/TD]
[TD] $ 5,456.00[/TD]
[/TR]
[TR]
[TD="align: right"]16.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 16[/TD]
[TD]3[/TD]
[TD]BUSINESS [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]16.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 16[/TD]
[TD]3[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]17.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 17[/TD]
[TD]3[/TD]
[TD]FIRST[/TD]
[TD] $ 5,681.00[/TD]
[/TR]
[TR]
[TD="align: right"]17.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 17[/TD]
[TD]3[/TD]
[TD]BUSINESS [/TD]
[TD] $ 4,236.00[/TD]
[/TR]
[TR]
[TD="align: right"]17.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 17[/TD]
[TD]3[/TD]
[TD]ECONOMY[/TD]
[TD] $ 3,056.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]18.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 18[/TD]
[TD]1[/TD]
[TD]FIRST[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD="align: right"]18.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 18[/TD]
[TD]1[/TD]
[TD]BUSINESS [/TD]
[TD] $ 1,747.00[/TD]
[/TR]
[TR]
[TD="align: right"]18.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 18[/TD]
[TD]1[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]19.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 19[/TD]
[TD]3[/TD]
[TD]FIRST[/TD]
[TD] $ 6,520.00[/TD]
[/TR]
[TR]
[TD="align: right"]19.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 19[/TD]
[TD]3[/TD]
[TD]BUSINESS [/TD]
[TD] $ 4,135.00[/TD]
[/TR]
[TR]
[TD="align: right"]19.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 19[/TD]
[TD]3[/TD]
[TD]ECONOMY[/TD]
[TD] $ 3,735.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]20.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 20[/TD]
[TD]3[/TD]
[TD]FIRST[/TD]
[TD] $ 5,696.00[/TD]
[/TR]
[TR]
[TD="align: right"]20.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 20[/TD]
[TD]3[/TD]
[TD]BUSINESS [/TD]
[TD] $ 4,251.00[/TD]
[/TR]
[TR]
[TD="align: right"]20.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 20[/TD]
[TD]3[/TD]
[TD]ECONOMY[/TD]
[TD] $ 3,571.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]21.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 21[/TD]
[TD]3[/TD]
[TD]FIRST[/TD]
[TD] $ 8,590.00[/TD]
[/TR]
[TR]
[TD="align: right"]21.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 21[/TD]
[TD]3[/TD]
[TD]BUSINESS [/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD="align: right"]21.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 21[/TD]
[TD]3[/TD]
[TD]ECONOMY[/TD]
[TD] $ 6,535.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]22.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 22[/TD]
[TD]1[/TD]
[TD]FIRST[/TD]
[TD] $ 2,497.00[/TD]
[/TR]
[TR]
[TD="align: right"]22.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 22[/TD]
[TD]1[/TD]
[TD]BUSINESS [/TD]
[TD] $ 1,897.00[/TD]
[/TR]
[TR]
[TD="align: right"]22.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 22[/TD]
[TD]1[/TD]
[TD]ECONOMY[/TD]
[TD] $ 1,297.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]23.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 23[/TD]
[TD]3[/TD]
[TD]FIRST[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD="align: right"]23.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 23[/TD]
[TD]3[/TD]
[TD]BUSINESS [/TD]
[TD] $ 8,590.00[/TD]
[/TR]
[TR]
[TD="align: right"]23.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 23[/TD]
[TD]3[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]24.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 24[/TD]
[TD]0[/TD]
[TD]FIRST[/TD]
[TD] $ 1,135.00[/TD]
[/TR]
[TR]
[TD="align: right"]24.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 24[/TD]
[TD]0[/TD]
[TD]BUSINESS [/TD]
[TD] $ 860.00[/TD]
[/TR]
[TR]
[TD="align: right"]24.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 24[/TD]
[TD]0[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]25.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 25[/TD]
[TD]1[/TD]
[TD]FIRST[/TD]
[TD] $ 3,909.00[/TD]
[/TR]
[TR]
[TD="align: right"]25.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 25[/TD]
[TD]1[/TD]
[TD]BUSINESS [/TD]
[TD] $ 1,722.00[/TD]
[/TR]
[TR]
[TD="align: right"]25.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 25[/TD]
[TD]1[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]26.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 26[/TD]
[TD]0[/TD]
[TD]FIRST[/TD]
[TD] $ 2,191.00[/TD]
[/TR]
[TR]
[TD="align: right"]26.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 26[/TD]
[TD]0[/TD]
[TD]BUSINESS [/TD]
[TD] $ 1,591.00[/TD]
[/TR]
[TR]
[TD="align: right"]26.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 26[/TD]
[TD]0[/TD]
[TD]ECONOMY[/TD]
[TD] $ 1,141.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]27.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 27[/TD]
[TD]1[/TD]
[TD]FIRST[/TD]
[TD] $ 1,843.00[/TD]
[/TR]
[TR]
[TD="align: right"]27.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 27[/TD]
[TD]1[/TD]
[TD]BUSINESS [/TD]
[TD] $ 1,113.00[/TD]
[/TR]
[TR]
[TD="align: right"]27.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 27[/TD]
[TD]1[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]28.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 28[/TD]
[TD]1[/TD]
[TD]FIRST[/TD]
[TD] $ 2,022.00[/TD]
[/TR]
[TR]
[TD="align: right"]28.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 28[/TD]
[TD]1[/TD]
[TD]BUSINESS [/TD]
[TD] $ 1,062.00[/TD]
[/TR]
[TR]
[TD="align: right"]28.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 28[/TD]
[TD]1[/TD]
[TD]ECONOMY[/TD]
[TD] $ 735.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]29.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 29[/TD]
[TD]2[/TD]
[TD]FIRST[/TD]
[TD] $ 7,212.00[/TD]
[/TR]
[TR]
[TD="align: right"]29.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 29[/TD]
[TD]2[/TD]
[TD]BUSINESS [/TD]
[TD] $ 4,836.00[/TD]
[/TR]
[TR]
[TD="align: right"]29.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 29[/TD]
[TD]2[/TD]
[TD]ECONOMY[/TD]
[TD] $ 4,436.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]30.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 30[/TD]
[TD]2[/TD]
[TD]FIRST[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD="align: right"]30.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 30[/TD]
[TD]2[/TD]
[TD]BUSINESS [/TD]
[TD] $ 8,590.00[/TD]
[/TR]
[TR]
[TD="align: right"]30.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 30[/TD]
[TD]2[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]31.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 31[/TD]
[TD]0[/TD]
[TD]FIRST[/TD]
[TD] $ 1,060.00[/TD]
[/TR]
[TR]
[TD="align: right"]31.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 31[/TD]
[TD]0[/TD]
[TD]BUSINESS [/TD]
[TD] $ 667.00[/TD]
[/TR]
[TR]
[TD="align: right"]31.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 31[/TD]
[TD]0[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]32.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 32[/TD]
[TD]2[/TD]
[TD]FIRST[/TD]
[TD] $ 7,002.00[/TD]
[/TR]
[TR]
[TD="align: right"]32.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 32[/TD]
[TD]2[/TD]
[TD]BUSINESS [/TD]
[TD] $ 5,317.00[/TD]
[/TR]
[TR]
[TD="align: right"]32.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 32[/TD]
[TD]2[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]33.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 33[/TD]
[TD]1[/TD]
[TD]FIRST[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD="align: right"]33.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 33[/TD]
[TD]1[/TD]
[TD]BUSINESS [/TD]
[TD] $ 8,590.00[/TD]
[/TR]
[TR]
[TD="align: right"]33.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 33[/TD]
[TD]1[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]34.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 34[/TD]
[TD]1[/TD]
[TD]FIRST[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD="align: right"]34.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 34[/TD]
[TD]1[/TD]
[TD]BUSINESS [/TD]
[TD] $ 3,485.00[/TD]
[/TR]
[TR]
[TD="align: right"]34.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 34[/TD]
[TD]1[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]35.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 35[/TD]
[TD]3[/TD]
[TD]FIRST[/TD]
[TD] $ 7,627.00[/TD]
[/TR]
[TR]
[TD="align: right"]35.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 35[/TD]
[TD]3[/TD]
[TD]BUSINESS [/TD]
[TD] $ 5,942.00[/TD]
[/TR]
[TR]
[TD="align: right"]35.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 35[/TD]
[TD]3[/TD]
[TD]ECONOMY[/TD]
[TD] $ 3,892.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]36.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 36[/TD]
[TD]2[/TD]
[TD]FIRST[/TD]
[TD] $ 8,590.00[/TD]
[/TR]
[TR]
[TD="align: right"]36.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 36[/TD]
[TD]2[/TD]
[TD]BUSINESS [/TD]
[TD] $ 8,064.00[/TD]
[/TR]
[TR]
[TD="align: right"]36.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 36[/TD]
[TD]2[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]37.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 37[/TD]
[TD]0[/TD]
[TD]FIRST[/TD]
[TD] $ 2,364.00[/TD]
[/TR]
[TR]
[TD="align: right"]37.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 37[/TD]
[TD]0[/TD]
[TD]BUSINESS [/TD]
[TD] $ 1,927.00[/TD]
[/TR]
[TR]
[TD="align: right"]37.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 37[/TD]
[TD]0[/TD]
[TD]ECONOMY[/TD]
[TD] $ 912.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]38.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 38[/TD]
[TD]0[/TD]
[TD]FIRST[/TD]
[TD] $ 791.00[/TD]
[/TR]
[TR]
[TD="align: right"]38.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 38[/TD]
[TD]0[/TD]
[TD]BUSINESS [/TD]
[TD] $ 341.00[/TD]
[/TR]
[TR]
[TD="align: right"]38.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 38[/TD]
[TD]0[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]39.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 39[/TD]
[TD]0[/TD]
[TD]FIRST[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD="align: right"]39.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 39[/TD]
[TD]0[/TD]
[TD]BUSINESS [/TD]
[TD] $ 1,391.00[/TD]
[/TR]
[TR]
[TD="align: right"]39.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 39[/TD]
[TD]0[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]40.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 40[/TD]
[TD]2[/TD]
[TD]FIRST[/TD]
[TD] $ 7,877.00[/TD]
[/TR]
[TR]
[TD="align: right"]40.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 40[/TD]
[TD]2[/TD]
[TD]BUSINESS [/TD]
[TD] $ 6,192.00[/TD]
[/TR]
[TR]
[TD="align: right"]40.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 40[/TD]
[TD]2[/TD]
[TD]ECONOMY[/TD]
[TD] $ 4,142.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]41.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 41[/TD]
[TD]1[/TD]
[TD]FIRST[/TD]
[TD] $ 8,590.00[/TD]
[/TR]
[TR]
[TD="align: right"]41.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 41[/TD]
[TD]1[/TD]
[TD]BUSINESS [/TD]
[TD] $ 7,754.00[/TD]
[/TR]
[TR]
[TD="align: right"]41.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 41[/TD]
[TD]1[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]42.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 42[/TD]
[TD]2[/TD]
[TD]FIRST[/TD]
[TD] $ 8,590.00[/TD]
[/TR]
[TR]
[TD="align: right"]42.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 42[/TD]
[TD]2[/TD]
[TD]BUSINESS [/TD]
[TD] $ 7,668.00[/TD]
[/TR]
[TR]
[TD="align: right"]42.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 42[/TD]
[TD]2[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]43.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 43[/TD]
[TD]0[/TD]
[TD]FIRST[/TD]
[TD] $ 1,966.00[/TD]
[/TR]
[TR]
[TD="align: right"]43.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 43[/TD]
[TD]0[/TD]
[TD]BUSINESS [/TD]
[TD] $ 1,191.00[/TD]
[/TR]
[TR]
[TD="align: right"]43.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 43[/TD]
[TD]0[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]44.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 44[/TD]
[TD]1[/TD]
[TD]FIRST[/TD]
[TD] $ 4,752.00[/TD]
[/TR]
[TR]
[TD="align: right"]44.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 44[/TD]
[TD]1[/TD]
[TD]BUSINESS [/TD]
[TD] $ 3,202.00[/TD]
[/TR]
[TR]
[TD="align: right"]44.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 44[/TD]
[TD]1[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]45.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 45[/TD]
[TD]0[/TD]
[TD]FIRST[/TD]
[TD] $ 2,491.00[/TD]
[/TR]
[TR]
[TD="align: right"]45.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 45[/TD]
[TD]0[/TD]
[TD]BUSINESS [/TD]
[TD] $ 1,891.00[/TD]
[/TR]
[TR]
[TD="align: right"]45.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 45[/TD]
[TD]0[/TD]
[TD]ECONOMY[/TD]
[TD] $ 891.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]46.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 46[/TD]
[TD]0[/TD]
[TD]FIRST[/TD]
[TD] $ 211.00[/TD]
[/TR]
[TR]
[TD="align: right"]46.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 46[/TD]
[TD]0[/TD]
[TD]BUSINESS [/TD]
[TD]-$ 64.00[/TD]
[/TR]
[TR]
[TD="align: right"]46.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 46[/TD]
[TD]0[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 270.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]47.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 47[/TD]
[TD]2[/TD]
[TD]FIRST[/TD]
[TD] $ 7,627.00[/TD]
[/TR]
[TR]
[TD="align: right"]47.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 47[/TD]
[TD]2[/TD]
[TD]BUSINESS [/TD]
[TD] $ 5,692.00[/TD]
[/TR]
[TR]
[TD="align: right"]47.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 47[/TD]
[TD]2[/TD]
[TD]ECONOMY[/TD]
[TD] $ 3,642.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]48.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 48[/TD]
[TD]2[/TD]
[TD]FIRST[/TD]
[TD] $ 7,877.00[/TD]
[/TR]
[TR]
[TD="align: right"]48.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 48[/TD]
[TD]2[/TD]
[TD]BUSINESS [/TD]
[TD] $ 6,192.00[/TD]
[/TR]
[TR]
[TD="align: right"]48.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 48[/TD]
[TD]2[/TD]
[TD]ECONOMY[/TD]
[TD] $ 4,142.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]49.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 49[/TD]
[TD]0[/TD]
[TD]FIRST[/TD]
[TD] $ 7,086.00[/TD]
[/TR]
[TR]
[TD="align: right"]49.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 49[/TD]
[TD]0[/TD]
[TD]BUSINESS [/TD]
[TD] $ 5,996.00[/TD]
[/TR]
[TR]
[TD="align: right"]49.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 49[/TD]
[TD]0[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]50.1[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 50[/TD]
[TD]1[/TD]
[TD]FIRST[/TD]
[TD] $ 8,590.00[/TD]
[/TR]
[TR]
[TD="align: right"]50.2[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 50[/TD]
[TD]1[/TD]
[TD]BUSINESS [/TD]
[TD] $ 7,664.00[/TD]
[/TR]
[TR]
[TD="align: right"]50.3[/TD]
[TD]MELBOURNE[/TD]
[TD]DESTINATION 37[/TD]
[TD]1[/TD]
[TD]ECONOMY[/TD]
[TD]-$ 900.00[/TD]
[/TR]
</tbody>[/TABLE]

 

[cunningAce]

Hi,

Not sure I fully understand what it is you want to accomplish.
Can you show me an example of what the result would look like?

 

[gigglesxx]

Hi,

I realise I wasn't very clear on what i want. I have fixed up the data:

[TABLE="width: 1071"]
<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]WEIGHTING SCORE (0-5)[/TD]
[TD]ORIGIN [/TD]
[TD]DESTINATION[/TD]
[TD]CLASS[/TD]
[TD]COST[/TD]
[TD]AVERAGE[/TD]
[TD]WEIGHTED AVERAGE[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]MELBOURNE[/TD]
[TD]LONDON[/TD]
[TD]FIRST full flexi[/TD]
[TD] $ 3,000.00[/TD]
[TD] $ 2,500.00[/TD]
[TD] $ 3,300.00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]FIRST flexi[/TD]
[TD] $ 2,500.00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]FIRST restricted[/TD]
[TD] $ 2,000.00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]MELBOURNE[/TD]
[TD]LONDON[/TD]
[TD]BUSINESS full flexi[/TD]
[TD] $ 1,800.00[/TD]
[TD] $ 1,433.33[/TD]
[TD] $ 1,850.00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BUSINESS flexi[/TD]
[TD] $ 1,500.00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BUSINESS restricted[/TD]
[TD] $ 1,000.00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]MELBOURNE[/TD]
[TD]LONDON[/TD]
[TD]ECONOMY full flexi[/TD]
[TD] $ 900.00[/TD]
[TD] $ 700.00[/TD]
[TD] $ 950.00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]ECONOMY flexi[/TD]
[TD] $ 700.00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]ECONOMY restricted[/TD]
[TD] $ 500.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]MELBOURNE[/TD]
[TD]BERLIN[/TD]
[TD]FIRST full flexi[/TD]
[TD] $ 3,500.00[/TD]
[TD] $ 3,333.33[/TD]
[TD] $ 3,100.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]FIRST flexi[/TD]
[TD] $ 3,300.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]FIRST restricted[/TD]
[TD] $ 3,200.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]MELBOURNE[/TD]
[TD]BERLIN[/TD]
[TD]BUSINESS full flexi[/TD]
[TD] $ 3,000.00[/TD]
[TD] $ 2,733.33[/TD]
[TD] $ 1,650.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BUSINESS flexi[/TD]
[TD] $ 2,700.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BUSINESS restricted[/TD]
[TD] $ 2,500.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]MELBOURNE[/TD]
[TD]BERLIN[/TD]
[TD]ECONOMY full flexi[/TD]
[TD] $ 2,000.00[/TD]
[TD] $ 1,766.67[/TD]
[TD] $ 1,600.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]ECONOMY flexi[/TD]
[TD] $ 1,800.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]ECONOMY restricted[/TD]
[TD] $ 1,500.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]MELBOURNE[/TD]
[TD]SINGAPORE[/TD]
[TD]FIRST full flexi[/TD]
[TD] $ 1,500.00[/TD]
[TD] $ 1,400.00[/TD]
[TD] $ 1,450.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]FIRST flexi[/TD]
[TD] $ 1,400.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]FIRST restricted[/TD]
[TD] $ 1,300.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]MELBOURNE[/TD]
[TD]SINGAPORE[/TD]
[TD]BUSINESS full flexi[/TD]
[TD] $ 1,000.00[/TD]
[TD] $ 916.67[/TD]
[TD] $ 1,000.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BUSINESS flexi[/TD]
[TD] $ 900.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BUSINESS restricted[/TD]
[TD] $ 850.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]MELBOURNE[/TD]
[TD]SINGAPORE[/TD]
[TD]ECONOMY full flexi[/TD]
[TD] $ 700.00[/TD]
[TD] $ 583.33[/TD]
[TD] $ 700.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]ECONOMY flexi[/TD]
[TD] $ 600.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]ECONOMY restricted[/TD]
[TD] $ 450.00[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]MELBOURNE[/TD]
[TD]HONG KONG[/TD]
[TD]FIRST full flexi[/TD]
[TD] $ 4,000.00[/TD]
[TD] $ 3,800.00[/TD]
[TD] $ 3,400.00[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]FIRST flexi[/TD]
[TD] $ 3,900.00[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]FIRST restricted[/TD]
[TD] $ 3,500.00[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]MELBOURNE[/TD]
[TD]HONG KONG[/TD]
[TD]BUSINESS full flexi[/TD]
[TD] $ 3,000.00[/TD]
[TD] $ 2,500.00[/TD]
[TD] $ 2,450.00[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BUSINESS flexi[/TD]
[TD] $ 2,500.00[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BUSINESS restricted[/TD]
[TD] $ 2,000.00[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]MELBOURNE[/TD]
[TD]HONG KONG[/TD]
[TD]ECONOMY full flexi[/TD]
[TD] $ 1,900.00[/TD]
[TD] $ 1,466.67[/TD]
[TD] $ 1,300.00[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]ECONOMY flexi[/TD]
[TD] $ 1,500.00[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]ECONOMY restricted[/TD]
[TD] $ 1,000.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]MELBOURNE[/TD]
[TD]SYDNEY[/TD]
[TD]FIRST full flexi[/TD]
[TD] $ 1,000.00[/TD]
[TD] $ 1,566.67[/TD]
[TD] $ 1,700.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]FIRST flexi[/TD]
[TD] $ 1,900.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]FIRST restricted[/TD]
[TD] $ 1,800.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]MELBOURNE[/TD]
[TD]SYDNEY[/TD]
[TD]BUSINESS full flexi[/TD]
[TD] $ 1,600.00[/TD]
[TD] $ 1,466.67[/TD]
[TD] $ 1,600.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BUSINESS flexi[/TD]
[TD] $ 1,500.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]BUSINESS restricted[/TD]
[TD] $ 1,300.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]MELBOURNE[/TD]
[TD]SYDNEY[/TD]
[TD]ECONOMY full flexi[/TD]
[TD] $ 1,000.00[/TD]
[TD] $ 833.33[/TD]
[TD] $ 950.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]ECONOMY flexi[/TD]
[TD] $ 850.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]ECONOMY restricted[/TD]
[TD] $ 650.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]TOTAL[/TD]
[TD] $ 27,000.00[/TD]
[TD] $ 27,000.00
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

The figures I am trying to calculate are the bold ones. If you sum them up, they would equate to the same total as the normal average calculation, however they increase and decrease (per travel class) depending on the importance of the group. Does this make better sense?

Thank you so much for trying to help

 

[Aladin Akyurek]

How does the very first value of 3,300.00 obtain? That is, what is your manual calculation?