Need a Lisp for preparing column schedule.

[archana96]

Hi, I have an Excel file of data. In this data, I'm converting this to a CAD column schedule. For reference, I've attached the files.

[ec-cad]

"I'm converting this to a CAD column schedule"

Do you mean make a Table in the Drawing, with the data from the Excel file?

Or, are you trying to create the Excel file from the drawing by extracting the Drawing info ?

I'm not understanding what you want, could you show a sample with

the expected results ?

ECCAD

[Sea-Haven]

So you want it to draw the column objects, in some form of grid pattern ?  There does appear to be a pattern, the only real issue is the ligs. 

So you have not had a go at writing a draw column, just using values say preset for testing. 1st step draw 350x500 rectang, 

Last question do you need Excel ? Why not just make the column based on user input ? Can make a dcl for input, you have to type the Excel any way or is that generated from some software. 

[archana96]

i need cad drawing from excel 

[archana96]

can you show me  output 

[Sea-Haven]

Back to my Question. Is it generated by another program. 

"Do you have to type the Excel data any way"

[archana96]

yes its link with excel

[Sea-Haven]

The task is very much requires a  custom program and as such for me its not going to be free as I can see a lot of work and back and forth between coder and your self. In terms of time saved it would be massive. 

Why not have a go yourself just do bits one at a time based on say single cell of the excel say as a enter string. Draw rectang 1st task, next work out a algorithm for the 2 bars 16-Y20 & 2-Y16 so that would mean 1 bar in middle top & bot rest around it.  A 3 item answer a different algorithm. 

It requires lots of rules using a COND to decide, 1st row say 6-Y16 means 3 top 3 bot looking at the 6, then 12-Y12 but how do I know for size max is always 5 bars for top row ? 

The read excel is actually the simplest part of this request.

[archana96]

Actually, my office colleague did this in Excel. but he did not give it to me he prepared data in Excel he first which side how many bars would come (like if 500 length requires 5 bars on one side and the big size of the bar is always the corner part)  after finishing that data will come on AutoCAD..

[Sea-Haven]

I think you need more info in the Excel like how many bars in top row. A 6-Y20 could mean only 3 bars across top not 5, then 12-Y12. A narrow tall beam.