question on sorting multiple columns

[tsh73]

... and your question is?

[tsh73]

Sorry I cannot understand what are you going to do.

Put your data in Excel (or whatever you are using for tables), sort it how it should look then post here:
(source)
and
(how it should became after sorting)

[debluzz]

excel file:

NAME ES PTS= CLS PTS= LT PTS= ART PTS= POST PTS= O/O PTS= (H-TOTAL PTS= L-TOTAL PTS=)            FINAL TOTAL
#1     43  5        15    5       1    0     3070  2     10      0        41   2        82.5      2        82.5      0   =16 +2        =18

#2     19  0        15    5       6     2    3053  5     30      2        31    0       64.5      2        43.5      5    =21+2+2     =24

#3     14  0         0     0       7     2    3107  0     30      2        31    0       55.5      1        45.5      5    =10              =10

#4     35  5         2     0       7     2    3114  0       0      0        30    0       52         0       49.5        0    =7                =7

#5    16   0         4     0       5     0     3081 1      30     2        21     0      49.5      0        52          0    =3                 =3

#6    17   0       14     2       1     0     3089 0        0     0        29      0     45.5      0        55.5       0    =2                  =2

#7    26   0         5     0     10     5     3094 0        0     0        25      0     43.5      0        64.5       0   =10               =10

#8    18  0        5     0        3     0     3091 0      10     0        16       0     33         0        82.5       0   =0                 =0

on record #1. it has points in es and cls the record #1 gets 2-more points for that.

also on record #2 it has points in cls and Lt ,this also gets 2-more
also ON #2 Lt and art both have points,this also gets 2-more

 total needs to be done for the other #'s as well

At the end ,I'd like sort on TOTAL high's
\this should make lot more sence I hope

[Rod]

No, we cannot understand what you are asking us to do. Show us the starting table, then how it is sorted and summed first time. Set the table out sorted and show the summations, how many other times does it get sorted and summed.


Showing us a bunch of inexplicable numbers with no titles or meanings makes it very hard for us to understand what you want to do.

[debluzz]

Could sure use some help on this ?

the data is in( .txt format) or the starting table.

The starting table was my first post.

The field names are on the Excel File post.

Only (the total pts) at the end of each row are needed

an excel table was requested---

Below is a list of the values for the (elements) of each row

The excel file will show the points.

(CLOUMN VALUES)

column2 highest value=5
column2 2nd highest value=2
column2 3nd highest is in the (#1,#2,#3)=2
column2 all the rest are =0

column3 highest value=5

column3 2nd highest value=5

column3 3nd highest is in the (#1,#2,#3)=5

column3 all the rest are =0

column4 highest value=5
column4 2nd highest value=2
column4 3nd highest is in the (#1,#2,#3)=2
column4 all the rest are =0

column5 LOWEST value=5
column5 2nd LOWEST value=2
column5 3nd highest is in the (#1,#2,#3)=2
column5 all the rest are =0

column6 highest value=5
column6 all the rest are =0

column7 highest value=5
column7 all the rest are =0

column8 highest value=2
column8 2nd highest value=2
column8 3nd highest is in the (#1,#2,#3)=2

column8 LOWEST value=5
column8 2nd LOWEST value=5
column8 3nd LOWEST is in the (#1,#2,#3)=5

column8 all the rest are =0

[alincon]

One way to sort on more than one field in a table is to concatenate the fields into column zero and sort on column zero.

r.m.

[debluzz]

NAME ES PTS= CLS PTS= LT PTS= ART PTS= POST PTS= O/O PTS= (H-TOTAL PTS= L-TOTAL PTS=) FINAL TOTAL

#1 43 5 15 5 1 0 3070 2 10 0 41 2 82.5 2 82.5 0 =16 +2 =18

#2 19 0 15 5 6 2 3053 5 30 2 31 0 64.5 2 43.5 5 =21+2+2 =24

#3 14 0 0 0 7 2 3107 0 30 2 31 0 55.5 1 45.5 5 =10 =10

#4 35 5 2 0 7 2 3114 0 0 0 30 0 52 0 49.5 0 =7 =7

#5 16 0 4 0 5 0 3081 1 30 2 21 0 49.5 0 52 0 =3 =3

#6 17 0 14 2 1 0 3089 0 0 0 29 0 45.5 0 55.5 0 =2 =2

#7 26 0 5 0 10 5 3094 0 0 0 25 0 43.5 0 64.5 0 =10 =10

#8 18 0 5 0 3 0 3091 0 10 0 16 0 33 0 82.5 0 =0 =0



(these are the points to assign for the values)


column2 highest value=5
column2 2nd highest value=2
column2 3nd highest is in the (#1,#2,#3)=2
column2 all the rest are =0


column3 highest value=5
column3 2nd highest value=5
column3 3nd highest is in the (#1,#2,#3)=5
column3 all the rest are =0

column4 highest value=5
column4 2nd highest value=2
column4 3nd highest is in the (#1,#2,#3)=2
column4 all the rest are =0

column5 LOWEST value=5
column5 2nd LOWEST value=2
column5 3nd highest is in the (#1,#2,#3)=2
column5 all the rest are =0

column6 highest value=5
column6 all the rest are =0

column7 highest value=5
column7 all the rest are =0

column8 highest value=2
column8 2nd highest value=2
column8 3nd highest is in the (#1,#2,#3)=2

column8 LOWEST value=5
column8 2nd LOWEST value=5
column8 3nd LOWEST is in the (#1,#2,#3)=5

column8 all the rest are =0

[Rod]

Explain this more, what does #1 #2 #3 mean? The original order or the current order?


column2 3nd highest is in the (#1,#2,#3)=2

[debluzz]

Thanks,
The #1-8 is the original order. And should be the ending order. One could say the #'s are the names

I'm not even sure if I'm going about this the right way ?

The only reason I'm thinking "sorts" is to know which #'s gets the points to be totaled.

Yes, column2 The #1 and #2 are equal or(both =5 ea) the #6 is the 2nd high=2

if the  #1/2/3 has the 3rd highest score then yes, it gets 2points

thanks again Rod

[Rod]

I am a bit tied up in house moves right now so don't have much time to put into this. This sorta works, you will need to debug and see why it is not giving the same scores as your example, probably the #1 #2 #3 thing.


data 43,5,15,5,1,0,3070,2,10,0,41,2,82.5,2,82.5,0
data 19,0,15,5,6,2,3053,5,30,2,31,0,64.5,2,43.5,5
data 14,0,0,0,7,2,3107,0,30,2,31,0,55.5,1,45.5,5
data 35,5,2,0,7,2,3114,0,0,0,30,0,52,0,49.5,0
data 16,0,4,0,5,0,3081,1,30,2,21,0,49.5,0,52,0
data 17,0,14,2,1,0,3089,0,0,0,29,0,45.5,0,55.5,0
data 26,0,5,0,10,5,3094,0,0,0,25,0,43.5,0,64.5,0
data 18,0,5,0,3,0,3091,0,10,0,16,0,33,0,82.5,0

'there is a bug in the sort command where the col number
'cannot be greater than the row number so instead of 8,17
'I just dim it square as 17,17
dim score(17,17) 'row,col
for row=1 to 8
for col=1 to 16
read  s : score(row,col)=s
next
next
row=8


gosub [showarray]

'sort col 2 descending
sort score(,row,1,2
score(1,17)=score(1,17)+5
score(2,17)=score(2,17)+2
if score(3,2)=score(2,2) then score(3,17)=score(3,17)+2
'sort col 3 descending
sort score(,row,1,3
score(1,17)=score(1,17)+5
score(2,17)=score(2,17)+5
if score(3,3)=score(2,3) then score(3,17)=score(3,17)+5
'sort col 4 descending
sort score(,row,1,4
score(1,17)=score(1,17)+5
score(2,17)=score(2,17)+2
if score(3,4)=score(2,4) then score(3,17)=score(3,17)+2
'sort col 5 ascending
sort score(,1,row,5
score(1,17)=score(1,17)+5
score(2,17)=score(2,17)+2
if score(3,5)=score(2,5) then score(3,17)=score(3,17)+2
'sort col 6 descending
sort score(,1,row,6
score(1,17)=score(1,17)+5
'sort col 7 descending
sort score(,1,row,7
score(1,17)=score(1,17)+5
'sort col 8 descending
sort score(,1,row,8
score(1,17)=score(1,17)+2
score(2,17)=score(2,17)+2
if score(3,8)=score(2,8) then score(3,17)=score(3,17)+2
'sort col 8 ascending
sort score(,row,1,8
score(1,17)=score(1,17)+5
score(2,17)=score(2,17)+5
if score(3,8)=score(2,8) then score(3,17)=score(3,17)+5
sort score(,row,1,17
gosub [showarray]
wait


[showarray]
for r= 1 to 8
for c= 1 to 17
print using("####",score(r,c));" ";
next
print
next
print
return



[debluzz]

thanks Rod I'll mess with it.