Another relationship of variables

[eNathan]

Yet again, I am programming a software to align pictures on a 2D plane, kinda like they are in windows exploror. I need to find a relationship between these.

I C R
_______
1 1 1
2 1 2
3 1 3
4 1 4
5 1 5
6 1 1
7 2 2
8 2 3
9 2 4
10 2 5
11 3 1

I would be my for loop counter, C would be the colum of picture I, and R would be what row it belongs to.

I already know that
C = Ceil(i / 5);
And I have come close to finding the value of R, so far I have
R = i - (Floor(i/(5 + C))*5);
But I know the latter equation is wrong, I just can't seem to figure it out out.

Thanks in advanve

 

[VietDao29]

...6 1 1
7 2 2
8 2 3

Are you sure 6 1 1? I think it should read 6 2 1.
C = [(I - 1) / 5] + 1. Where [...] is a function that takes the integer part before the decimal point of a real number. Ex : [1.5] = 1.
In some programming languages, you can write it as : C = Int((I - 1) / 5) + 1.
R = I - (C - 1) * 5.
Viet Dao,

 

[eNathan]

Are you sure 6 1 1? I think it should read 6 2 1.
C = [(I - 1) / 5] + 1. Where [...] is a function that takes the integer part before the decimal point of a real number. Ex : [1.5] = 1.
In some programming languages, you can write it as : C = Int((I - 1) / 5) + 1.
R = I - (C - 1) * 5.
Viet Dao,

Oh my It was soooo simple! I am speechless. Of course, just subtract from I, 5 C abount of times (and add one of course).

Thank you very much.