PDA

View Full Version : Create and Draw Road Profile with Excel and Lisp



Salama
28th May 2012, 09:48 pm
Hi ..
this excel+lisp gives us the opportunity to draw road profile for bothe ground levels and design levels in two steps -- one for ground " natural "" and 2nd for design levels.

* either to insert level in terms of points with Easting, Nothing, Level.

* or station " acc distance " + level
* then insert the interval of station 10meter , 20 or 30 as u like .
* also spacial interval could be inserted .
* Copy fields of manual or special interval to " with lisp sheet " and paste special in fields of Profile DATA " . AUTOMATICLY Data in Draw profile filels shall appear ..

* Use the datum for AutoCad .
* Activate the lisp named " PO' .
* AND FOLLOW STEPS .

Salama
28th May 2012, 09:49 pm
mmmmmm ... sorry .. but how to upload Excel files to here !!!

BIGAL
29th May 2012, 03:37 am
Make it a ZIP sounds like you have done what many are asking for.

Salama
1st Jun 2012, 09:54 am
mmmm

i tried to upload the excel file in terms of rar , zip ... but it doesn't work because the size exceeds 500 kb.

but any way i uploaded the zipped file to mediafire , you can use it with the lisp " PO" .

http://www.mediafire.com/?7f6lqkw956wfrxw

Salama
1st Jun 2012, 10:27 am
I TRIED TO ZIP THE file .. nor even rar it .. but because of the sizw > 500kb it doesnt work . the file after zipping still 900 kb . :(

iamxyno
4th Oct 2013, 04:40 am
how to install this!! 1st timer here

Organic
4th Oct 2013, 05:21 am
how to install this!! 1st timer here

http://www.lee-mac.com/runlisp.html

eea123
20th Oct 2013, 04:09 pm
The excel file link appears to be dead. Anyone demo this.

Organic
20th Oct 2013, 10:38 pm
The Mediafire link still works for me.

eea123
26th Oct 2013, 12:00 pm
Must be my ISP then. Thanks for confirming it. Anyone able to post the XLS file at another link for review. Thanks.

Organic
26th Oct 2013, 02:21 pm
Must be my ISP then. Thanks for confirming it. Anyone able to post the XLS file at another link for review. Thanks.

Try https://dl.dropboxusercontent.com/u/106007244/CREATE%20%20%26%20%20DRAW%20PROFILE.zip

eea123
27th Oct 2013, 09:46 pm
Thanks. The dropbox links works. I'll have to dig in when I find some time.

shingir
7th Nov 2013, 11:10 am
mmmm

i tried to upload the excel file in terms of rar , zip ... but it doesn't work because the size exceeds 500 kb.

but any way i uploaded the zipped file to mediafire , you can use it with the lisp " PO" .

http://www.mediafire.com/?7f6lqkw956wfrxw

I think you have to mention from where you got it, try to do your work and then you have the right to publish it

ReMark
7th Nov 2013, 02:06 pm
OK, you've made your point. Who is the actual author of the lisp routine? Is it you Shingir?

I downloaded the PO.lsp and opened it with Notebook. At the beginning of the file is a line that reads.....

"This program is created by AAMER HAMEED AWAN."

Is this the true author of the code? Yes or no?

shingir
7th Nov 2013, 02:18 pm
OK, you've made your point. Who is the actual author of the lisp routine? Is it you Shingir?
Just open the excel file and you will know.
FYI, it is more than 20 Files not only this one by done by the same person.

ReMark
7th Nov 2013, 02:20 pm
45051
OK...are you Hisham?

I see one file with four tabs. That's it. Nothing close to 20 files.

Can anyone even verify that the lisp routine together with the spreadsheet even works?

Salama
8th Mar 2014, 10:40 am
I think you have to mention from where you got it, try to do your work and then you have the right to publish it

I found those files and lisps at a forum , Hisham Fawzi the author of excel file asked to share .. not only me but any one who can do .

by the way , Hisham and the Ameed have upgraded the lisp to draw both PROFILES at once with two different commands .
http://www.4shared.com/folder/lebOhDwp/___.html?detailView=true&sortAsc=true&sortsMode=NAME
the link of original files and lisps .

Salama
8th Mar 2014, 10:42 am
45051
OK...are you Hisham?

I see one file with four tabs. That's it. Nothing close to 20 files.

Can anyone even verify that the lisp routine together with the spreadsheet even works?

the whole excel + lisps files 4shared link .. http://www.4shared.com/folder/lebOhDwp/___.html?detailView=true&sortAsc=true&sortsMode=NAME .. hisham asked to share .. the is no sign to see that Shingir is the owner ?!!

eea123
8th Mar 2014, 01:19 pm
Salama,


One file, "the machine.rar", fails RAR uncompressing. I've re-downloaded with the same result. I'm working my way through the set, but 1-4 pass fine and contain an Excel file and MP4 instructional video.