please !!, calculate the difference value of each * edge to center number, * but only

jack

Member
please !!, calculate the difference value of each
* edge to center number,
* but only the first of the yellow border9 to the center
goal = is to see a jump chart on each side of the matrix, only the 1st edge number will be seen
http://www.mediafire.com/file/cq8qcohnvy6teog/borda_para_centro.xlsx/file
 

Frank

Member
I dont think you will stand a chance of any help with this. You must be the only person on the planet who understands your spreadsheet. I have no idea what is going on in your head and your spreadsheet is useless in explaining anything. In particular you do not explain how you arrive at figures on row 7 and you do not explain what the table is for (cols AN to AT) or why certain numbers have squares round them. You do not explain what you mean by edge , edge of what ? Center, center of what ? You have been lazy, and other people don't have time to try and read your mind. When will you ever learn?
 

jack

Member
sorry frank ok ok let's go by parts.
*1st step = we have a 5 row and 5 column array
01 02 03 04 05
06 07 08 09 10
11 12 13 14 15
16 17 18 19 20
21 22 23 24 25
border are the two rows and two columns of the ends
01 02 03 04 05
06 10
11 15
16 20
21 22 23 24 25
center
07 08 09
12 13 14
17 18 19
you have to see on each draw line which numbers then on the edge and which ones are in the center
*add up your quantities
*example raffles x gave 9 numbers on the border and 6 on the total center 15 the sum always has to be 15 since 15 is the number of numbers drawn, my lottery (one of them) is 25/15,
frank, the distance is when the number is drawn a border number is not drawn the number of the border 22 and the center was 07, there is a distance of 3 because the 22 is sum together, is just an example
another example of edge-to-center distance
in the draw was not drawn 23 (edge ​​number)
in the center was 18, so we have only 1
goal = hit the edge numbers and have a perspective of the center numbers, can you put some edge filter? please
 

jack

Member
hello frank when I put
* 06 10 or 11 15 and leave the center space
* the forum program joins next
* but 06 10 11 15 16 20 must have 3 empty entries where is the center
in a draw will have example 10 at the edge and 5 at the center
* Is an example of sum you can do a statistics of the edges and the center?
 

jack

Member
https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQrT4gGkxquBcxgBApckN1ZhLGD5iBAeLXP9XXiQXCq7lHshIOZYH1G-Nn7&s
 
Top