|
Post by tsh73 on Oct 23, 2018 6:52:01 GMT -5
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
Junior Member
Thanks tsh73 I'll work with it.
Posts: 57
|
Post by debluzz on Oct 23, 2018 8:41:50 GMT -5
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
|
|
|
Post by Rod on Oct 23, 2018 10:47:43 GMT -5
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
Junior Member
Thanks tsh73 I'll work with it.
Posts: 57
|
Post by debluzz on Oct 23, 2018 11:01:36 GMT -5
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
|
|
debluzz
Junior Member
Thanks tsh73 I'll work with it.
Posts: 57
|
Post by debluzz on Oct 24, 2018 4:22:22 GMT -5
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
|
|
debluzz
Junior Member
Thanks tsh73 I'll work with it.
Posts: 57
|
Post by debluzz on Oct 25, 2018 9:28:37 GMT -5
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
|
|
|
Post by Rod on Oct 25, 2018 9:52:27 GMT -5
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
|
|