How to plot LONG SECTION of road in AutoCAD by EXCEL

Поделиться
HTML-код
  • Опубликовано: 26 окт 2019
  • In this video I have shown how to plot / draw long section of any alignment like road, pipe line, tunnel, irrigation in autocad. I have prepared an formula based excel sheet by which you can plot l section in autocad within a couple of second. If I get 1000 likes in this video in youtube then I will upload the full version of this excel sheet and also upload how to create a cross section of road by excel and autocad. Aready I have started working on making road cross section with just a single cliclk in autocad. I hope you will support us and encourage us.
    I used a sample data like chainage ogl frl in three columns and generated a formula which includes combination of autocad commands sequencely and then pasted it in autocad. The L section will be plotted automatically.
    And please be sure the input data is correct otherwise excel file may not work.
    If you think this tutorial is helpful please Like & Share this video and Subscribe our channel to get free notifications.
    Your one comment is valuable for us!
    With best wishes
    L&E Team!

Комментарии • 1,1 тыс.

  • @LearnExplore
    @LearnExplore  4 года назад +75

    DOWNLOAD the program:
    Purchase Link:
    imojo.in/lsection
    www.learnnexplore.com/
    Thanks & Regards
    S. Samanta
    for L&E

    • @waseemtanha9978
      @waseemtanha9978 4 года назад +2

      Sir I need this software my mail I'd waseemtanha221@gmail.com

    • @nomanshow6859
      @nomanshow6859 4 года назад +1

      nomanshow14@gmail.com

    • @rajeshkumargiri3285
      @rajeshkumargiri3285 4 года назад +2

      Sir Send this software, mail id- rkgiri51984@gmail.com

    • @sportsfever9180
      @sportsfever9180 4 года назад +1

      saleemkhan0000065@gmail.com

    • @ariefwibowo8997
      @ariefwibowo8997 4 года назад +1

      arif.maps99@gmail.com , please gift for me 🙏 , thank you master

  • @chandanpanda2323
    @chandanpanda2323 4 года назад +8

    Sir really it will help us in our field. Salute to you. Thank you sir for your given valuable information. If you will give us cross section process. We will be glad to you.

  • @joyshreemondal7232
    @joyshreemondal7232 4 года назад +3

    I am so proud of you..... Keep it up..... Dear...

  • @MrAmit1981
    @MrAmit1981 4 года назад +1

    Helping people in there job is an ultimate service to your profession.
    Hats off to your job sprite, at some extant you have decided to help people without any cost.

    • @LearnExplore
      @LearnExplore  4 года назад

      Thank you sir for the valuable words!

  • @boyizhao499
    @boyizhao499 2 года назад

    This will be so helpful for drawing the driveway and pipe longsection for a Civil Engineer. Thanks for sharing

  • @surajperera953
    @surajperera953 3 года назад

    It's a very useful tool when plotting LS in Cad. Thanks so much Samanta for this video & all your time spent on this as well as generously sharing it with your subscribers

    • @LearnExplore
      @LearnExplore  3 года назад

      Thank You for your valuable feedback 😊

  • @anandrayanutala481
    @anandrayanutala481 4 года назад +1

    Greeting of the day Sir,
    I am R Anand Mechanical Engineer from Andhra Pradesh. I got AE job by watching your classes.
    Thank you so much.

    • @LearnExplore
      @LearnExplore  4 года назад

      It's a great pleasure for us...😇
      Thanks for your valuable comment....❤

    • @anandrayanutala481
      @anandrayanutala481 4 года назад +1

      @@LearnExplore Welcome sir,
      You helped me alot in my preparation.
      Thanks you so much.

    • @Bdhdbrhrhr
      @Bdhdbrhrhr 2 года назад

      Please send me Sir

  • @markgenesiscabalteja9168
    @markgenesiscabalteja9168 2 года назад

    THANK YOU SO MUCH! He gave me an access in just 1 minute! :)

  • @vineeshvp7730
    @vineeshvp7730 2 года назад

    Sir.. this is very useful for me..this video solve the big problem faced in my work. I need this for my civil / road project.kindly send me the full version Sir..

  • @tundeibrahim6953
    @tundeibrahim6953 3 года назад

    sir am very happy with this video, it will allow me to learn how to design my sections faster now.

    • @LearnExplore
      @LearnExplore  3 года назад

      Thank You for your valuable feedback 😊

  • @babulnath1333
    @babulnath1333 4 года назад +1

    Thanks for the information

  • @siddharthagrawal4313
    @siddharthagrawal4313 2 года назад

    Thank you sir for video
    It will help me for long section as I am an engineer

  • @omarsany4344
    @omarsany4344 3 года назад

    Sir This is a very good job, I hope I can learn a lot of unknown things by watching this video. I hope many more videos like this through you. Sir, I would be happy to give you apps.

  • @mehboobhussainshah9025
    @mehboobhussainshah9025 4 года назад

    Very Nice Excel sheet. Thank you so much

  • @jamesphilip339
    @jamesphilip339 4 года назад

    thank you for this @Learn & Explore

  • @sksamimaktar2452
    @sksamimaktar2452 4 года назад

    Very nice video, most important format

  • @martinchege8487
    @martinchege8487 4 года назад

    am training to do road leveling computations ad visualization i think this avenue will offer me nice skills

  • @shreeyashjagtap4949
    @shreeyashjagtap4949 2 года назад +1

    Excellent sir, appreciate your work .

  • @bhagwansahay8526
    @bhagwansahay8526 2 года назад +1

    Excellent sir, appreciate your work

  • @MegaKipkemoi
    @MegaKipkemoi 4 года назад

    Quite educative,i need a copy of your excel programme

  • @prashabansod5173
    @prashabansod5173 3 года назад

    Very Important problem you sloved sir
    Thank you !!💐👍

  • @backbacktom
    @backbacktom 3 года назад +1

    Subscribed and liked. Please keep the great videos coming. I am learning a lot

  • @hasanthadissanayake9948
    @hasanthadissanayake9948 2 года назад

    Thank you very much for your excellent explanation of this. i am a civil engineering undergraduate. I want this for completing an university project.

  • @martontapas1283
    @martontapas1283 4 года назад

    Im a GIS Technician. Please your excel spreadsheet formulas will greatly help me with my work. Sir help please

  • @christopherpadernal4347
    @christopherpadernal4347 4 года назад

    Good day Sir, I need this file for my job as a construction surveyor, This will be a great help for me specially in road works, Thanks in advance.

  • @kanchanmachhibal8727
    @kanchanmachhibal8727 4 года назад

    very helpful draw to longitudinal section

    • @LearnExplore
      @LearnExplore  4 года назад

      Thanks for the valuable feedback 😊

  • @abhishekanand2555
    @abhishekanand2555 3 года назад

    Thank you so much😊

  • @Arshman46GiftedStar
    @Arshman46GiftedStar 3 года назад

    Very nice you explain this video. Excellent sir

  • @mailojo2info
    @mailojo2info 4 года назад

    Nice one, pls I would like to have full excellent sheet thanks

  • @shahbazkhan-qz6kg
    @shahbazkhan-qz6kg 2 года назад

    Well I work in irrigation department and I have to draw lots of PDN l section wich took lots of time . With this method I think I can save lots of time.

  • @ZakirKhan-jb7cd
    @ZakirKhan-jb7cd 4 года назад

    Thanks Good job

  • @prakashrprakash6229
    @prakashrprakash6229 3 года назад

    sir , Good work. can you please include gradient proposed and difference in the cutting or filling details in autocad sheet please

  • @vinodjaiswal6373
    @vinodjaiswal6373 4 года назад

    a useful app for highway enginner

  • @sadanandamahanty4166
    @sadanandamahanty4166 4 года назад

    your video is very nice and knowledgeable

  • @donkumarsarme5228
    @donkumarsarme5228 4 года назад

    Good work sir ji..

  • @jitenkalita9866
    @jitenkalita9866 Год назад

    Very helpful and shortcut tools nice

  • @sivaramnama9375
    @sivaramnama9375 4 года назад

    Hello sir.. I am working in irrigation projects like canals and reservoirs this excel sheet is very useful to me will please send this excel sheet app to me this very helpful and need to me..

  • @singhbrajesh89
    @singhbrajesh89 4 года назад

    Nice keep it up.kindly also prepare sheet for cross section along with volume calculation.

    • @LearnExplore
      @LearnExplore  4 года назад

      We are already working on that..will prepare cross section with volume calculation table

  • @ahmadnazareeothman6114
    @ahmadnazareeothman6114 3 года назад

    Thank you for your video. Need this for my civil/road project. pls send me full version.

  • @duncansummerfield544
    @duncansummerfield544 4 года назад

    Hi, excellent video. I would like this long section sheet to help with my training. Thanks

    • @LearnExplore
      @LearnExplore  4 года назад

      Thanks for the valuable feedback 😊

  • @er_shubham_ragad3303
    @er_shubham_ragad3303 3 года назад

    Thank you for help brother

  • @subhadipmondal2198
    @subhadipmondal2198 3 года назад

    Thank you sir, I got this excel file
    Thank you so much sir 😊
    Full support sir 😊

  • @imtiazahmad9551
    @imtiazahmad9551 3 года назад +1

    Thank you sir gee real ma ak acha teacher Love you sir!!!

    • @LearnExplore
      @LearnExplore  3 года назад

      Thank you.
      Please subscribe us and share our videos to your friends of engineering fields 🙂

    • @imtiazahmad9551
      @imtiazahmad9551 3 года назад

      Zaror

  • @nawabazamshah6883
    @nawabazamshah6883 Год назад

    Such a nice video sir,
    I think It's really very helpful, I'm a student and i want to learn by you can you please share your sheet. It will help me alot. It's my humble request sir.

  • @sadreaalam9753
    @sadreaalam9753 4 года назад

    Thank you sir

  • @Vishwakarmadevnaresh1933
    @Vishwakarmadevnaresh1933 3 года назад

    Thanks sir.
    Very useful formula
    Please canal l section and x section with indicates pucca works
    Such as VRB,FALL,DRB ETC.
    Excel formula links in autocad

  • @ajitpanwar1190
    @ajitpanwar1190 3 года назад

    Very much helpful sheet

  • @sanjoyghosh9345
    @sanjoyghosh9345 2 года назад

    I really need this file it's easy to work.

  • @NewbiesHorizon
    @NewbiesHorizon 3 года назад

    I need this to have more knowledge on it

  • @vinodkumar-mn7ky
    @vinodkumar-mn7ky 4 года назад

    Thanks again sir please make a video same as cross-section in autocad.

  • @opsamant7724
    @opsamant7724 4 года назад

    Thank U sirs

  • @DK_4x4
    @DK_4x4 3 года назад

    Thank you so much sir, I am so proud of you. it's really really helpful. Could I have that excel file sir? Thank you for your video.

    • @LearnExplore
      @LearnExplore  3 года назад +1

      Thank You for your valuable feedback 😊
      Please download the file from the link given in pinned comment. Also Join us as RUclips membership for more premium excel files.
      Payment is not compulsory. Download it for free.

    • @DK_4x4
      @DK_4x4 3 года назад

      @@LearnExplore thank you so much for answering and kindness.

  • @RUBYKINGSLY
    @RUBYKINGSLY 3 года назад

    Thx got the file

    • @LearnExplore
      @LearnExplore  3 года назад

      You are welcome. Thnx for the feedback

  • @israelsafali3718
    @israelsafali3718 4 года назад +1

    I want to use in practicing excel and auto Cad because I’m on training

  • @rijusarma9053
    @rijusarma9053 4 года назад

    Seems to be very useful. Kindly share the lynk to download the file.

    • @LearnExplore
      @LearnExplore  4 года назад

      Link already given. Search in comment section

  • @ERSarowar
    @ERSarowar Год назад

    Very Excellent programming 👌

  • @vennapusapapireddy9361
    @vennapusapapireddy9361 2 года назад

    hi . good software . i used before

  • @michaelorourke2160
    @michaelorourke2160 3 года назад

    thanks! need for runway design

  • @parvej7892
    @parvej7892 4 года назад +1

    Good job

  • @XploreTechIndia
    @XploreTechIndia 3 года назад

    Good work boss

  • @mahendramasar4110
    @mahendramasar4110 4 года назад

    Good job sir

  • @vinodjaiswal6373
    @vinodjaiswal6373 4 года назад

    a very simple procedure

  • @mahendramasar4110
    @mahendramasar4110 4 года назад

    Sir good job sir

  • @manishbayas7626
    @manishbayas7626 4 года назад

    Exelent work sir.....plz sir send me this exel file .....which is very usefull in my work 🙏🙏🙏

    • @LearnExplore
      @LearnExplore  4 года назад

      Thank You for your valuable feedback 😊
      Download link in Pinned comment section

  • @anjanprasadshetty1226
    @anjanprasadshetty1226 4 года назад

    Hello sir this is Great work. can u please send me of your excel sheet please

  • @bishnushil8164
    @bishnushil8164 4 года назад +1

    Sir Please Upload How to Plot X-section base excel sheet to autocad

  • @manishtanwar9338
    @manishtanwar9338 4 года назад

    nice formula, i want to use in survey field. pls send me.

  • @eadmohammad4085
    @eadmohammad4085 2 года назад

    Amazing

  • @manoharsingh6421
    @manoharsingh6421 3 года назад

    Excellent ji

  • @shubhamkamde2257
    @shubhamkamde2257 4 года назад

    Complete road design project ke video banao from basics

  • @Barogtalaban
    @Barogtalaban 3 года назад

    Me also sir i need the full version of the excel file..few more likes away
    👍

  • @PraveenKumar-kg9ql
    @PraveenKumar-kg9ql 3 года назад

    If i want to draw canal which requires cbl,fsl,gl,tbm then how to draw?

  • @lakshithanuwan782
    @lakshithanuwan782 4 года назад +1

    Thanks for enabling access for the file. And im sorry for my attitude. Thanks again.

    • @shamanthkumar60
      @shamanthkumar60 4 года назад +1

      bro can u please give the file to me
      mail:- shamanthkumar19@gmail.com,whatsup:-8328042024

    • @danrayalu6262
      @danrayalu6262 4 года назад

      @@shamanthkumar60 Can i get the file as well mail to rayaludan@gmail.com

  • @manojmamgain3029
    @manojmamgain3029 2 года назад

    In MS Excel write Chainage,RL for example 0,100.23 & 25,99.69 and so on serially in one column. give poly line command in autocad copy from excel and paste in autocad. Wow!! L-Section is ready

    • @LearnExplore
      @LearnExplore  2 года назад

      Whatabout the other details like the table, text, datum, scale factor etc????

  • @just2vipi
    @just2vipi 2 года назад

    Please provide this excel file please. Video is awsome.

  • @zakriashalmani111
    @zakriashalmani111 3 года назад

    Nice work sir I need excel file for sewer network please mosty need

  • @sushantchadda5313
    @sushantchadda5313 4 года назад

    how to determine fgl or ogl in survey data i have L1, L2 C R1, R2 data plz help

  • @richardnlemchi3640
    @richardnlemchi3640 3 года назад

    Super

  • @mohdsohailkhan7519
    @mohdsohailkhan7519 2 года назад

    Hello sir. This is amazing video. Can you share the excel file also. ??

  • @danishansari1004
    @danishansari1004 4 года назад

    This is very helpful video please grant access to the drive request

  • @vivekpanchakati414
    @vivekpanchakati414 3 года назад

    Very good

  • @saleemsurvey291
    @saleemsurvey291 Год назад

    Excellent sir, it's very easy to plot LS, please send the Link, sir.

    • @LearnExplore
      @LearnExplore  Год назад

      Sir link given. Please visit our website. Digital store.

    • @LearnExplore
      @LearnExplore  Год назад

      www.learnnexplore.com

  • @lukeshsinghrajput8449
    @lukeshsinghrajput8449 2 года назад

    Sir im civil engineer
    Sir your info is great..
    Can you send me this formula

    • @LearnExplore
      @LearnExplore  2 года назад

      Please follow the link in the pinned comment

  • @romiktalo3790
    @romiktalo3790 3 года назад

    Nice

  • @alanalex8281
    @alanalex8281 3 года назад

    sir ..how to add more layers in input data...like road work different layers like quarry muck filling,gsb filling,wetmix,etc

    • @LearnExplore
      @LearnExplore  3 года назад

      Normally the layers u said is shown in cross section. But if you want to view it in L section then we can prepare custom excel sheet for you. For details and fees email us at contact@learnnexplore.com

  • @SibenduJena
    @SibenduJena 4 года назад

    Good work

    • @SibenduJena
      @SibenduJena 4 года назад

      Please upload the Cross section also

    • @LearnExplore
      @LearnExplore  4 года назад

      Thanks for your valuable comment. We r working on crosseciton. Need your support and Patience.

    • @SibenduJena
      @SibenduJena 4 года назад

      Can it be used for Canal Longitudinal Section Reply soon

  • @Pushkar_Gujarati
    @Pushkar_Gujarati 2 года назад

    Please provide this excel file please. Video is awesome, i am oil and gas pipeline draftsman.

  • @SunilKumar-vw9vt
    @SunilKumar-vw9vt 4 года назад

    its magic

  • @nbsinthang9832
    @nbsinthang9832 4 года назад

    Please sir i really need this

  • @mandeepgoswami2923
    @mandeepgoswami2923 4 года назад

    👍👍👍👍

  • @rahultrivedi1988
    @rahultrivedi1988 2 года назад

    i want to use this for canal, pls share excel sheet

  • @urgesageleta139
    @urgesageleta139 Год назад

    Thankyou

  • @ojingtaga4144
    @ojingtaga4144 2 года назад

    Sir it is very educative , how i can download your programme?

    • @LearnExplore
      @LearnExplore  2 года назад

      Contact me through WhatsApp +91 8910837292

  • @wryahadenadir5901
    @wryahadenadir5901 3 года назад

    I need programming course development in autocad civil 3D.online or video ?

  • @itspaulbro1994
    @itspaulbro1994 4 года назад

    Thank u sir....
    for this video

  • @vishnudina8945
    @vishnudina8945 2 года назад

    Sir, can u make one video for lisp...

  • @aryagoatfarm8708
    @aryagoatfarm8708 Год назад

    Good

  • @joshuagitau3149
    @joshuagitau3149 3 года назад

    i need an excel file for water network Project.

  • @abeebatadenike5857
    @abeebatadenike5857 Год назад

    Please is the excel program for complete road design? I mean, starting from plotting of horizontal allignment, profiles and cross sections, including volume too

    • @LearnExplore
      @LearnExplore  Год назад

      Sir, It is only for L section. When you have data with you this program can be used to plot the l section

    • @LearnExplore
      @LearnExplore  Год назад

      You can contact us for further details

  • @faizadathambawa9849
    @faizadathambawa9849 3 года назад +1

    I need my Road project