bro I try to import an Excel file, it displays an 'invalid selection' error, even though I've selected the columns in Excel where the data is located. However, it's not working
Did you make sure to arrange the data in 3 columns and even though the third column is for remarks and can be left empty you need to select the third column too( you have to select exactly 3 columns I think thats how the application is programmed). Also make sure that you have your chainage in metres eg. 1200 instead of 1+200. Hope this helps 😊
when scale is changed the RL written over left side also get changed .... i want RL like 97,98,99,100 and then dimension between them 1 ... trying but not getting ir right ...kindly help
I don’t understand what you meant by order of excel file but if you are talking about excel data structure I have clearly mentioned it during 00:20 to 00:40 portion of video. Hope this helps
Thank you for this video but I tried using the SWDTM to execute the data from excel but it’s not responding. Please what’s the cause and what can I do?
Please make sure the datas in excel are arranged in the order that Swdtm recognizes and make sure you have selected the correct range in excel cells. If it doesn't work even after that I am not sure about the problem.
How can we change the scake of vertical on the same drawing without having to use Excel or swdtm again.. Is there a way like stretch command or something. And if we find out the area in the scaled drawing should we divide by 100 from the area we got.
I don't think you have any way to change scale only vertically of a drawing in AutoCAD ( But if you want to do it for a block, I believe you can do such thing). I am also not sure if the division would yield correct area measurements better to just replot with correct scale it doesn't take much time🙂
can we draw ls from coordinates without chaiange. I have cordinates and elevation in my exel data of the track but no chainage and the intervals are not uniform also.
@@civiler1439 sir I have to put chainage in the ls drawing at regular intervals. But I don't have it done in my excel sheet. Only x y coordinates and elevation in my excel sheet or gps data. The profile is made easily through gps visualiser online. But I want to know how I can get the data in regular intervals of chainage with elevation either in Excel or autocad directly after the profile is drawn. I haven't drawn the profile in AutoCAD either since I don't know the chainage at regular intervals and their elevation. The gps visualiser elevation profile data only provides coordinates and elevation. And I don't even know if they're at regular intervals or not.
Yes the software is integrated to work with AutoCAD Version but I don’t know if it works with civil 3D and since you mentioned it didn’t maybe they are Not integrated civil 3d
If you are concerned about how to order the data then just follow the format as shown in the example in video and you can just save in standard excel file type (.xlsx)
Its very simple. In a column you insert your chainages in metres ( for example chainage 1+240 shall be entered as 1240) in the adjacent column insert the Reduced level of each chainages. Then just follow as done in video.
The reduced level for this specific example was obtained using the total station and noted accordingly. If you are using auto-level you may need to do some computations to get them.
The error occurs if you do not kept the excel format in order exactly as in the video as this softwel programme has its own algorithm to read the datas. So the datas must be arranged as I explained in my video. Hope it helps 🙂
Well done SIR! Youve just gained a Subscriber like that.
bro
I try to import an Excel file, it displays an 'invalid selection' error, even though I've selected the columns in Excel where the data is located. However, it's not working
Did you make sure to arrange the data in 3 columns and even though the third column is for remarks and can be left empty you need to select the third column too( you have to select exactly 3 columns I think thats how the application is programmed). Also make sure that you have your chainage in metres eg. 1200 instead of 1+200. Hope this helps 😊
Very informative video. Thank you so much sir!☺️☺️
very nice Explanation. thank you very much
Very helpful video for me. Thanks Brother
This program is just used for autocad or can use for civil 3d?
Sir suppr explain 🙏🏿
when scale is changed the RL written over left side also get changed .... i want RL like 97,98,99,100 and then dimension between them 1 ... trying but not getting ir right ...kindly help
If I want a chainage system in 3 decimals in stead of 2. How it can be done?
Thank you brother
i have slope, of whose elevation profile is open in google earth. I want to draw it in auto-cad , how do I do it
kindly share the video in which details about the order of excel file mentioned.
I don’t understand what you meant by order of excel file but if you are talking about excel data structure I have clearly mentioned it during 00:20 to 00:40 portion of video. Hope this helps
i downloaded that sw dtm file but it doesn't work on civil 3d 2022.
Same problem
Thank you for this video but I tried using the SWDTM to execute the data from excel but it’s not responding. Please what’s the cause and what can I do?
Please make sure the datas in excel are arranged in the order that Swdtm recognizes and make sure you have selected the correct range in excel cells. If it doesn't work even after that I am not sure about the problem.
@@civiler1439 I just tried it now and it worked thanks alot
How to arrange data in excel and to excute in auto cad make a video
@@ashwarajkrishnappa444 Yes its needed
Legend!
How can we change the scake of vertical on the same drawing without having to use Excel or swdtm again.. Is there a way like stretch command or something. And if we find out the area in the scaled drawing should we divide by 100 from the area we got.
I don't think you have any way to change scale only vertically of a drawing in AutoCAD ( But if you want to do it for a block, I believe you can do such thing).
I am also not sure if the division would yield correct area measurements better to just replot with correct scale it doesn't take much time🙂
thanks broo
thanks
Pls what if the intervals are not equal, i do i do
You can just put your chainage and level respectively and plot them it will work even for irregular intervals
can we draw ls from coordinates without chaiange. I have cordinates and elevation in my exel data of the track but no chainage and the intervals are not uniform also.
Do you have z values of coordinates ?
@@civiler1439 yes. z is rl?
@@civiler1439 sir I have to put chainage in the ls drawing at regular intervals. But I don't have it done in my excel sheet. Only x y coordinates and elevation in my excel sheet or gps data. The profile is made easily through gps visualiser online. But I want to know how I can get the data in regular intervals of chainage with elevation either in Excel or autocad directly after the profile is drawn. I haven't drawn the profile in AutoCAD either since I don't know the chainage at regular intervals and their elevation. The gps visualiser elevation profile data only provides coordinates and elevation. And I don't even know if they're at regular intervals or not.
does this work with AutoCAD 2022?
Yes the software is integrated to work with AutoCAD Version but I don’t know if it works with civil 3D and since you mentioned it didn’t maybe they are Not integrated civil 3d
How to save in Excel in what type
If you are concerned about how to order the data then just follow the format as shown in the example in video and you can just save in standard excel file type (.xlsx)
Try to save as CSV(comma delimited)
Error! again what order are tou speaking about please reply
Its very simple. In a column you insert your chainages in metres ( for example chainage 1+240 shall be entered as 1240) in the adjacent column insert the Reduced level of each chainages. Then just follow as done in video.
How did u know where was ur reduced level ?
The reduced level for this specific example was obtained using the total station and noted accordingly. If you are using auto-level you may need to do some computations to get them.
Plz upload video for X section with initial level and FRL . With level difference & Quantity.
mine will get an error , how so
The error occurs if you do not kept the excel format in order exactly as in the video as this softwel programme has its own algorithm to read the datas. So the datas must be arranged as I explained in my video. Hope it helps 🙂
@@civiler1439 thank you
Hiii
Hello. Do you have something to ask?