Grid Construction With numeric values & Dates

[writetoevv]

13 3/11/2016	14 4/11/2016	15 5/11/2016	16 6/11/2016	17 7/11/2016
12 2/11/2016	3 24/10/2016	4 25/10/2016	5 26/10/2016	18 8/1111/2016
11 1/11/2016	2 23/10/2016	1 22/10/2016	6 27/10/2016	19 9/11/2016
10 31/10/2016	9 30/10/2016	8 29/10/2016	7 28/10/2016	20 10/11/2016
25 15/11/2016	24 14/11/2016	23 13/11/2016	22 12/11/2016	21 11/11/2016

<tbody>
</tbody>

Hi Friends,

Could you help to create grid like above
In middle cell of 5 by 5 Grid , i will place a random number (ex: 1) along with random date(ex:22/10/2016)
It should Construct the remaining values (in clockwise direction) for other cells automatically using excel formulae..

Appreciate for the help..

 

[XOR LX]

Hi,

Is this limited to a 5x5 grid only?

Are the numbers and dates separated by a linebreak in each cell?

Regards

 

[writetoevv]

Hi XOR LX,

Appreciate for very quick turnaround time.
Please refer information..

1) Actually, Grid is dynamic as per below table. Please refer Levels table for more information.

Starting Number	<input name="startno" size="10">
Levels	<input name="levels" size="10">

<tbody>
</tbody>

Starting Date

<input name="startno" size="10">

<tbody>
</tbody>

----------------------------
|Create Square Button |
----------------------------

Levels Table:

Start	Levels	Maximum
1	10	441
1	15	961
1	20	1681
1	25	2601
1	30	3721
1	35	5041

<tbody>
</tbody>

2) Yes, numbers and dates separated by a linebreak in each cell

Thanks & Regards
Vishy

Hi,

Is this limited to a 5x5 grid only?

Are the numbers and dates separated by a linebreak in each cell?

Regards

 

[writetoevv]

3) Also, would it be possible in the grid construction.
Cardinal Cross( Row & Column Containing numerical 1) is marked in Red
Fixed Cross (45, 135,225, 325 Degree Angles/Lines) is marked in Blue
22.50-degree Lines are marked in Yellow
11.25-degree Lines are marked in Green

Hi XOR LX,

Appreciate for very quick turnaround time.
Please refer information..

1) Actually, Grid is dynamic as per below table. Please refer Levels table for more information.

Starting Number	<input name="startno" size="10">
Levels	<input name="levels" size="10">

<tbody>
</tbody>

Starting Date

<input name="startno" size="10">

<tbody>
</tbody>

----------------------------
|Create Square Button |
----------------------------

Levels Table:

Start	Levels	Maximum
1	10	441
1	15	961
1	20	1681
1	25	2601
1	30	3721
1	35	5041

<tbody>
</tbody>

2) Yes, numbers and dates separated by a linebreak in each cell

Thanks & Regards
Vishy

 

[writetoevv]

Hi XOR LX,

Any Help in below request?

3) Also, would it be possible in the grid construction.
Cardinal Cross( Row & Column Containing numerical 1) is marked in Red
Fixed Cross (45, 135,225, 325 Degree Angles/Lines) is marked in Blue
22.50-degree Lines are marked in Yellow
11.25-degree Lines are marked in Green

 

[XOR LX]

Apologies.

I meant to reply in light of the fact that you originally said:

It should Construct the remaining values (in clockwise direction) for other cells automatically using excel formulae..

though clearly your additional requests for colouring would require VBA.

Can you clarify?

Regards

 

[writetoevv]

Hi XOR LX, No Issues with VBA..Either excel formulas or VBA will be fine..Infact, No issue with Approach/language. Thanks & Regards Vish

Apologies. I meant to reply in light of the fact that you originally said: though clearly your additional requests for colouring would require VBA. Can you clarify? Regards

 

[XOR LX]

I'm afraid my VBA skills are most likely insufficient here.

Hopefully someone else will pick up on this thread shortly who can help you.

Regards

 

[writetoevv]

Hi XOR LX,

It would b of gr8 help to me even if you help to create whatever possible w/o VBA.. I mean static grid for Ex: 25 by 25 grid with above sequence..
No colors, no dynamic grid generation.. What ever simple grid possible..

Thank you so much for your guidance until now..

 

[writetoevv]

Hi Friends,

Any help on This problem of Grid Construction!!

Thanks & Regards
Vishy

Hi XOR LX,

Appreciate for very quick turnaround time.
Please refer information..

1) Actually, Grid is dynamic as per below table. Please refer Levels table for more information.

Starting Number	<input name="startno" size="10">
Levels	<input name="levels" size="10">

<tbody>
</tbody>

Starting Date

<input name="startno" size="10">

<tbody>
</tbody>

----------------------------
|Create Square Button |
----------------------------

Levels Table:

Start	Levels	Maximum
1	10	441
1	15	961
1	20	1681
1	25	2601
1	30	3721
1	35	5041

<tbody>
</tbody>

2) Yes, numbers and dates separated by a linebreak in each cell

Thanks & Regards
Vishy