dimensioned rectangles from excel

[kim.dedeyne]

Hello, 
If I enter my list with dimensions and numbering in autocad, 
I get the following result. what is wrong in my formula that the horizontal dimension is wrong?

thank you in advance.
Kim

 

[hwalker]

If I remember rightly it's because the snaps are on. At the beginning of the information put OSNAP OFF

[kim.dedeyne]

I tried, it's still the same problem. Thanks for your reply.

[hwalker]

Can you post the script file that you are creating. I couldn't get your excel data to work

[kim.dedeyne]

rectangle 0,0 0,0 _dli 0,0 0,0 -50,0 _dli 0,0 0,0 50,0 -text non 100,50 0
rectangle 100,0 100,0 _dli 100,0 100,0 50,0 _dli 100,0 100,0 50,0 -text non 200,50 0
rectangle 200,0 200,0 _dli 200,0 200,0 150,0 _dli 200,0 200,0 50,0 -text non 300,50 0
rectangle 300,0 300,0 _dli 300,0 300,0 250,0 _dli 300,0 300,0 50,0 -text non 400,50 0

="rectangle "&N3&","&O3&" "&P3&","&Q3

="_dli " & N3 & "," & O3 & " " & N3 & "," & Q3 & " " & N3-50 & "," & (P3-N3)/2

="_dli " & N3 & "," & Q3 & " " & P3 & "," & Q3 & " " & Q3+50 & "," & (P3-N3)/2

="-text non " & X3 & "," & Y3 & " 0 " & J3

[kim.dedeyne]

Command: rectangle
Specify first corner point or [Chamfer/Elevation/Fillet/Thickness/Width]: 0,0
Specify other corner point or [Area/Dimensions/Rotation]: 0,0
Command: _dli DIMLINEAR
Specify first extension line origin or <select object>: 0,0
Specify second extension line origin: 0,0
Non-associative dimension created.
Specify dimension line location or
[Mtext/Text/Angle/Horizontal/Vertical/Rotated]: -50,0
Dimension text = 0
Command: _dli DIMLINEAR
Specify first extension line origin or <select object>: 0,0
Specify second extension line origin: 0,0
Non-associative dimension created.
Specify dimension line location or
[Mtext/Text/Angle/Horizontal/Vertical/Rotated]: 50,0
Dimension text = 0
Command: -text
Current text style: "Arial" Text height: 30.00 Annotative: No Justify: Left
Specify start point of text or [Justify/Style]: non 100,50
Specify rotation angle of text <0.00>: 0
Enter text:

[Washingtonn · Accepted solution]

Change the order of the last terms - you need the X portion THEN the Y portion of the location of the horizontal dimension.

[kim.dedeyne]

It works!! Thank you!!