How to plot LONG SECTION of road in AutoCAD by EXCEL

แชร์
ฝัง
  • เผยแพร่เมื่อ 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.1K

  • @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...

  • @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 😊

  • @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

  • @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 😊

  • @martinchege8487
    @martinchege8487 4 ปีที่แล้ว

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

  • @markgenesiscabalteja9168
    @markgenesiscabalteja9168 2 ปีที่แล้ว

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

  • @omarsany4344
    @omarsany4344 2 ปีที่แล้ว

    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.

  • @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..

  • @mehboobhussainshah9025
    @mehboobhussainshah9025 4 ปีที่แล้ว

    Very Nice Excel sheet. Thank you so much

  • @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

  • @jamesphilip339
    @jamesphilip339 4 ปีที่แล้ว

    thank you for this @Learn & Explore

  • @babulnath1333
    @babulnath1333 4 ปีที่แล้ว +1

    Thanks for the information

  • @MegaKipkemoi
    @MegaKipkemoi 4 ปีที่แล้ว

    Quite educative,i need a copy of your excel programme

  • @sksamimaktar2452
    @sksamimaktar2452 4 ปีที่แล้ว

    Very nice video, most important format

  • @NuclearPhysix
    @NuclearPhysix 3 ปีที่แล้ว

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

  • @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 😊

  • @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.

  • @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.

    • @LearnExplore
      @LearnExplore  2 ปีที่แล้ว

      I have sent this. please share our videos

    • @usmanshan1589
      @usmanshan1589 2 ปีที่แล้ว

      Password kya h

  • @siddharthagrawal4313
    @siddharthagrawal4313 2 ปีที่แล้ว

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

  • @shreeyashjagtap4949
    @shreeyashjagtap4949 2 ปีที่แล้ว +1

    Excellent sir, appreciate your work .

  • @prashabansod5173
    @prashabansod5173 2 ปีที่แล้ว

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

  • @martontapas1283
    @martontapas1283 4 ปีที่แล้ว

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

  • @bhagwansahay8526
    @bhagwansahay8526 2 ปีที่แล้ว +1

    Excellent sir, appreciate your work

  • @ZakirKhan-jb7cd
    @ZakirKhan-jb7cd 4 ปีที่แล้ว

    Thanks Good job

  • @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.

  • @abhishekanand2555
    @abhishekanand2555 3 ปีที่แล้ว

    Thank you so much😊

  • @kanchanmachhibal8727
    @kanchanmachhibal8727 4 ปีที่แล้ว

    very helpful draw to longitudinal section

    • @LearnExplore
      @LearnExplore  4 ปีที่แล้ว

      Thanks for the valuable feedback 😊

  • @prakashrprakash6229
    @prakashrprakash6229 3 ปีที่แล้ว

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

  • @Arshman46GiftedStar
    @Arshman46GiftedStar 3 ปีที่แล้ว

    Very nice you explain this video. Excellent sir

  • @donkumarsarme5228
    @donkumarsarme5228 4 ปีที่แล้ว

    Good work sir ji..

  • @er_shubham_ragad3303
    @er_shubham_ragad3303 2 ปีที่แล้ว

    Thank you for help brother

  • @mailojo2info
    @mailojo2info 4 ปีที่แล้ว

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

  • @ahmadnazareeothman6114
    @ahmadnazareeothman6114 3 ปีที่แล้ว

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

  • @subhadipmondal2198
    @subhadipmondal2198 3 ปีที่แล้ว

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

    • @LearnExplore
      @LearnExplore  3 ปีที่แล้ว +1

      Thank You for your valuable feedback 😊

    • @subhadipmondal2198
      @subhadipmondal2198 3 ปีที่แล้ว

      @@LearnExplore WELCOME sir☺☺

  • @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

  • @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..

  • @NewbiesHorizon
    @NewbiesHorizon 3 ปีที่แล้ว

    I need this to have more knowledge on it

  • @vinodjaiswal6373
    @vinodjaiswal6373 4 ปีที่แล้ว

    a useful app for highway enginner

  • @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 TH-cam 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.

  • @sadreaalam9753
    @sadreaalam9753 4 ปีที่แล้ว

    Thank you sir

  • @vinodkumar-mn7ky
    @vinodkumar-mn7ky 4 ปีที่แล้ว

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

    • @LearnExplore
      @LearnExplore  4 ปีที่แล้ว

      We are working hard on it.

  • @israelsafali3718
    @israelsafali3718 4 ปีที่แล้ว +1

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

  • @sadanandamahanty4166
    @sadanandamahanty4166 4 ปีที่แล้ว

    your video is very nice and knowledgeable

  • @opsamant7724
    @opsamant7724 4 ปีที่แล้ว

    Thank U sirs

  • @nawabazamshah6883
    @nawabazamshah6883 11 หลายเดือนก่อน

    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.

  • @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

  • @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

  • @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

  • @sanjoyghosh9345
    @sanjoyghosh9345 2 ปีที่แล้ว

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

  • @jitenkalita9866
    @jitenkalita9866 ปีที่แล้ว

    Very helpful and shortcut tools nice

  • @ajitpanwar1190
    @ajitpanwar1190 2 ปีที่แล้ว

    Very much helpful sheet

  • @michaelorourke2160
    @michaelorourke2160 3 ปีที่แล้ว

    thanks! need for runway design

  • @vinodjaiswal6373
    @vinodjaiswal6373 4 ปีที่แล้ว

    a very simple procedure

  • @ERSarowar
    @ERSarowar ปีที่แล้ว

    Very Excellent programming 👌

  • @RUBYKINGSLY
    @RUBYKINGSLY 3 ปีที่แล้ว

    Thx got the file

    • @LearnExplore
      @LearnExplore  3 ปีที่แล้ว

      You are welcome. Thnx for the feedback

  • @XploreTechIndia
    @XploreTechIndia 3 ปีที่แล้ว

    Good work boss

  • @mahendramasar4110
    @mahendramasar4110 4 ปีที่แล้ว

    Good job sir

  • @parvej7892
    @parvej7892 4 ปีที่แล้ว +1

    Good job

  • @vennapusapapireddy9361
    @vennapusapapireddy9361 2 ปีที่แล้ว

    hi . good software . i used before

  • @eadmohammad4085
    @eadmohammad4085 2 ปีที่แล้ว

    Amazing

  • @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????

  • @mandeepgoswami2923
    @mandeepgoswami2923 4 ปีที่แล้ว

    👍👍👍👍

  • @mahendramasar4110
    @mahendramasar4110 4 ปีที่แล้ว

    Sir good job sir

  • @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

  • @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

  • @manishtanwar9338
    @manishtanwar9338 4 ปีที่แล้ว

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

  • @SunilKumar-vw9vt
    @SunilKumar-vw9vt 4 ปีที่แล้ว

    its magic

  • @manoharsingh6421
    @manoharsingh6421 3 ปีที่แล้ว

    Excellent ji

  • @bishnushil8164
    @bishnushil8164 4 ปีที่แล้ว +1

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

  • @anjanprasadshetty1226
    @anjanprasadshetty1226 4 ปีที่แล้ว

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

  • @manishbayas7626
    @manishbayas7626 3 ปีที่แล้ว

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

    • @LearnExplore
      @LearnExplore  3 ปีที่แล้ว

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

  • @nbsinthang9832
    @nbsinthang9832 4 ปีที่แล้ว

    Please sir i really need this

  • @just2vipi
    @just2vipi 2 ปีที่แล้ว

    Please provide this excel file please. Video is awsome.

  • @PraveenKumar-kg9ql
    @PraveenKumar-kg9ql 3 ปีที่แล้ว

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

  • @danishansari1004
    @danishansari1004 4 ปีที่แล้ว

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

    • @LearnExplore
      @LearnExplore  4 ปีที่แล้ว +1

      Sure. What is your mail id?

    • @danishansari1004
      @danishansari1004 4 ปีที่แล้ว

      I have sent a mail on ur email id

  • @Barogtalaban
    @Barogtalaban 3 ปีที่แล้ว

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

  • @vivekpanchakati414
    @vivekpanchakati414 3 ปีที่แล้ว

    Very good

    • @musiconn7044
      @musiconn7044 3 ปีที่แล้ว

      Please Send This Tool

  • @urgesageleta139
    @urgesageleta139 ปีที่แล้ว

    Thankyou

  • @shubhamkamde2257
    @shubhamkamde2257 4 ปีที่แล้ว

    Complete road design project ke video banao from basics

  • @zakriashalmani111
    @zakriashalmani111 3 ปีที่แล้ว

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

  • @hariprasadtaduru9876
    @hariprasadtaduru9876 ปีที่แล้ว

    i need irrigation canal cross sections through lisp by using excel data i will parchage longitudinal and cross section of canal

    • @LearnExplore
      @LearnExplore  ปีที่แล้ว

      Please contact us through whatsapp or email. And please see pinned comment

  • @md-mohammed8455
    @md-mohammed8455 4 ปีที่แล้ว +1

    Nice, do you have same for road cross section, sir

    • @LearnExplore
      @LearnExplore  4 ปีที่แล้ว +1

      We will upload it soon if possible. Because making cross section by a single paste in AutoCAD its very difficult. But we will prepare it .. Everything is possible with excel and AutoCAD
      Till then stay tuned with us. And share this video

    • @md-mohammed8455
      @md-mohammed8455 4 ปีที่แล้ว

      @@LearnExplore multiple cross section, make button based

    • @md-mohammed8455
      @md-mohammed8455 4 ปีที่แล้ว

      Add a button on first sheet for copy paste to excel rather than go to second sheet and copy paste.

    • @md-mohammed8455
      @md-mohammed8455 2 ปีที่แล้ว

      @@LearnExplore did you make excel sheet for cross section sir

  • @sushantchadda5313
    @sushantchadda5313 4 ปีที่แล้ว

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

  • @mohamedfirnas1432
    @mohamedfirnas1432 3 ปีที่แล้ว

    I need this excell file for my road work.

  • @bharathkumarcr4563
    @bharathkumarcr4563 3 ปีที่แล้ว

    i need to prepare bar charts. so i am trying with this

    • @LearnExplore
      @LearnExplore  3 ปีที่แล้ว

      We have sent the file access

  • @itspaulbro1994
    @itspaulbro1994 4 ปีที่แล้ว

    Thank u sir....
    for this video

  • @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

  • @ojingtaga4144
    @ojingtaga4144 2 ปีที่แล้ว

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

    • @LearnExplore
      @LearnExplore  2 ปีที่แล้ว

      Contact me through WhatsApp +91 8910837292

  • @mohdsohailkhan7519
    @mohdsohailkhan7519 2 ปีที่แล้ว

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

    • @LearnExplore
      @LearnExplore  2 ปีที่แล้ว

      Please follow the pinned link

  • @Pushkar_Gujarati
    @Pushkar_Gujarati 2 ปีที่แล้ว

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

    • @LearnExplore
      @LearnExplore  2 ปีที่แล้ว

      Please follow pinned comment

  • @aryagoatfarm8708
    @aryagoatfarm8708 ปีที่แล้ว

    Good

  • @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

  • @mesfinhailegiorgis7985
    @mesfinhailegiorgis7985 4 ปีที่แล้ว +1

    intelligent

  • @richardnlemchi3640
    @richardnlemchi3640 3 ปีที่แล้ว

    Super

  • @joshuagitau3149
    @joshuagitau3149 3 ปีที่แล้ว

    i need an excel file for water network Project.

  • @rahultrivedi1988
    @rahultrivedi1988 2 ปีที่แล้ว

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