Get Grid Number of each block in Model space with Viewport reference

[Anonymous]

Hello Everyone,

Could you please help me for the below query. 

I have several blocks in model space in different locations in different Map Numbers (Map number means 001,002,003). I need the Grid value by using X,Y coordinates from Viewport page such as A1, A2, B1,B2 like that. I have series in A-G & 1-12 Numbers. Please refer the attached snapshots, Test drawing and Data extraction spread sheet.

Could anyone please write a lisp to get these values. I really appreciate your help.

Please let me know for further queries.

Thank you,

Sai.

[Moshe-A]

@Anonymous  hi,

explore DATAEXTRACTION  command. it does exactly what you want

moshe

[Anonymous]

Could you please provide me the detailed process for solution. I have tried, but I'am unable to find solution.

Thanks,

Sai.

[Kent1Cooper]

---

@Anonymous wrote:

.... I need the Grid value by using X,Y coordinates from Viewport page such as A1, A2, B1,B2 like that. I have series in A-G & 1-12 Numbers. Please refer the attached snapshots, Test drawing and Data extraction spread sheet.

....

---

No spreadsheet attached.

Does the green rectanglular outline of the title-1000 Block in Model Space always correspond exactly to the shape of the Viewport in each Layout?

It would be a lot easier if the bottom of the Viewport and of the Block in model space aligned with the bottom of the G grid row  in the border Block, so that the row could be calculated by a simple division of the title-1000 Block's height.

Is it the Block insertion point  [upper left corner] that should be used to calculate its grid location, or the middle of its red rectangle, or the middle of its extents including the Attribute to the right [which would be affected by the value in that Attribute], or something else?

[Anonymous]

Hi Kent1Cooper,

I have forgot to attach the Data extraction spreadsheet. Now I have attached.

Please find the below colored text of my answers

Does the green rectanglular outline of the title-1000 Block in Model Space always correspond exactly to the shape of the Viewport in each Layout? - Yes the green color grid fits the same location for each layout and its a standard. in the test drawing I have given only 3 Grids, but actually I will get 600 sometimes and the blocks will be in thousands.

It would be a lot easier if the bottom of the Viewport and of the Block in model space aligned with the bottom of the G grid row  in the border Block, so that the row could be calculated by a simple division of the title-1000 Block's height. - That is a standard which i have to follow. I'm unable to change location.

Is it the Block insertion point  [upper left corner] that should be used to calculate its grid location, or the middle of its red rectangle, or the middle of its extents including the Attribute to the right [which would be affected by the value in that Attribute], or something else? - If the lisp will calculate by using the X, Y coordinates of the block, may be it is easier to get the Grid value like (A1,A2,B1...).

I hope i have answered all your queries. Could you please provide me lisp then it saves a lot of time for me.

Please let me know if I have to provide any other information.

Thank you,

Sai.

[maratovich]

You showed an example of Excel that you have.
Give an example - how you want.

[Anonymous]

Hi Maratovich,

I have provided the required details in the snapshot which I have attached.

Thanks you,

Sai.

[maratovich]

And then you tell me - I wanted differently.