Hemanth Boddapu
Hemanth Boddapu
  • 11
  • 345 640

Відео

Project planning on Excel with Gantt chart and Dependency arrows. Download template
Переглядів 42 тис.2 роки тому
In this video, I have explained how to use an Excel Project planning tool which I have created using Excel VBA. It has functionalities like color coded Gantt chart, Dependency arrows with very simple and user friendly actions. Excel file: drive.google.com/file/d/1DIpIiH-bLXeIX0AkwYo4lh7UxQSIdnjS/view?usp=sharing Excel file with 137 weeks: drive.google.com/file/d/10Ht3aW3VzUqitd4xZrleOKk1Zo89GTE...
Google Finance reports of stock portfolio, Automated
Переглядів 1 тис.3 роки тому
I have explained here, on how to keep up with your stock portfolio changes and news related to them. It has helped me to reduce significant amount of time I spend in tracking the price movements and their drivers. Template Link: drive.google.com/file/d/1rQ5bSL183lkhk2MOXcOlGUkHL-WOvF3n/view?usp=sharing #automation #stocks #investing Intro: (0:00) Setting up: (3:20) Things to keep in mind: (12:02)
Manufacturing Simulation on Excel to Determine the lead time of Production batches
Переглядів 29 тис.3 роки тому
In this video, I have explained how to estimate the lead times for each product batch in a manufacturing setup, using an excel tool which i have built. Excel file: drive.google.com/file/d/1jjq80se2uoxSoe5dSCiya631QVuUPYIc/view?usp=sharing About me: I am a student at NITIE Mumbai, batch of 2019-2021. NITIE (National Institute of Industrial Engineering) is a leading academic institution in genera...
Capacitated K means Clustering on Python || Machine Learning Tutorial by Hemanth Boddapu
Переглядів 1,7 тис.3 роки тому
Related topics: 1. K equal sized clusters 2. Capacitated clustering using Genetic Algorithm 3. Modified K means Algorithm Python file on Jupiter Notebook: drive.google.com/file/d/1tBzRgSAFdMrcq_fFxKerhjBBOqWpaP5o/view?usp=sharing About me: I am a student at NITIE Mumbai, batch of 2019-2021. NITIE (National Institute of Industrial Engineering) is a leading academic institution in generating worl...
Vehicle Routing Simulation on Python for Mid Mile Distribution (Long haul) - Logistics / Milk Runs
Переглядів 15 тис.4 роки тому
Vehicle Routing Simulation will help logistic Managers to decide whether they should use vehicle routing concept or not in mid mile logistics Related Topics:- 1. Milkrun Logistics Simulation 2. Capacitated Vehicle Routing Simulation Jupiter file and sample datasets: drive.google.com/drive/folders/1m2OJaMpbKorByH7tIjkoh0wGAVph_syn?usp=sharing About me: I am a student at NITIE Mumbai, batch of 20...
Optimize Inventory with Stochastic Simulation and Genetic Algorithm
Переглядів 9 тис.4 роки тому
This is a video on how we can use Stochastic simulation with Genetic Algorithm to optimize our inventory levels on Python. Highly useful in FMCG, Pharma, Manufacturing and many more industries. Python code: bit.ly/36dwYGR About me: I am a student at NITIE Mumbai, batch of 2019-2021. NITIE (National Institute of Industrial Engineering) is a leading academic institution in generating world class ...
K-means Clustering Algorithm on Excel on Warehouse Inventory,Tutorial by Hemanth Boddapu
Переглядів 11 тис.4 роки тому
This video is a tutorial on clustering warehouse inventory using K-means clustering Algorithm, a very popular machine learning algorithm. This method will be very useful in Storage Zone optimization. Dataset: drive.google.com/file/d/1kjEc5PH67uA6BCspd5wzq-QbS5f8vSee/view?usp=sharing About me: I am a student at NITIE Mumbai, batch of 2019-2021. NITIE (National Institute of Industrial Engineering...
How to calculate Driving Distance Matrix on Excel using Bing Maps API
Переглядів 102 тис.4 роки тому
This is a small tutorial video on how to generate a distance matrix on excel using Bing Maps API. Everything is explained in detail. This video is extremely useful for a Supply chain professional who is trying to perform Vehicle routing / Network analysis / Logistic cost analysis / Location Planning / Logistics Planning. It provides the road distance along the best routes considering traffic. L...
Power BI Inventory Management Dashboard
Переглядів 131 тис.4 роки тому
Tutorial on Power BI, Learn How to build an Inventory Dashboard. It includes ABC Inventory Classification, XYZ Classification, Inventory Turnover Ratio, Calculation of Safety Stock & Reorder points, Stock Status Classification, ABC Pareto Chart & Demand Forecasting on Power BI. It is extremely useful for Warehouse/ In-plant Inventory Managers to effectively control the Inventory levels and also...
Vlookup, Pivot Table, IF statement on Excel
Переглядів 1,8 тис.4 роки тому
Hello !! This is a small tutorial on Excel Tricks. Three important things to learn on Excel are Vlookup, If Statements & Pivot Table. The example used is a simplistic model of Sales Data output from ERP Systems. you can find more material to practice here.. click on the link bit.ly/2GqHXyM

КОМЕНТАРІ

  • @HEMANTHHEMU86
    @HEMANTHHEMU86 3 дні тому

    Hi all, I have pushed latest macro file to drive today. Fixed few minor bugs and added status bar enhancements

  • @premk5080
    @premk5080 4 дні тому

    Thank You So much Bro....❤

  • @rajeshrajeshexperiments8350
    @rajeshrajeshexperiments8350 10 днів тому

    Hi Hemant, I am getting the memory error while performing this dash board. Could you recommend any solution for it.

  • @aryan0055
    @aryan0055 16 днів тому

    YOU ARE A GOOD MAN , GREAT WORK , HELPING PPL TO GROW . GOD BLESS YOU

  • @mrunicorn-p4x
    @mrunicorn-p4x 16 днів тому

    Thank you, it's a great job!

  • @AhmedElShafeey
    @AhmedElShafeey 27 днів тому

    Fantasctic, thanks alot 🙋‍♂

  • @vatsalverma4557
    @vatsalverma4557 Місяць тому

    Superb

  • @prspace
    @prspace Місяць тому

    youtube.com/@prspace?si=XM9cpTc033f50shr

  • @prspace
    @prspace Місяць тому

    Sir namaskar This is nagaraj Cyclis From uttar kakannda near karawar Gokarn

  • @rashinigam3176
    @rashinigam3176 2 місяці тому

    Doing any valid change, excel becomes Not Responding.

  • @natchakhoomsap6126
    @natchakhoomsap6126 2 місяці тому

    Love it

  • @atifaameen472
    @atifaameen472 2 місяці тому

    Unable to add more dates - shows there are no more cells..can anyone help urgently

  • @alexfernandes7629
    @alexfernandes7629 3 місяці тому

    Loved watching the video❤

  • @lpaone01
    @lpaone01 3 місяці тому

    Great work! Saved me many hour of study.

  • @lexiepan4257
    @lexiepan4257 3 місяці тому

    hi, why is y = A x^1-n? i don't understand this formula, could you explain the logic behind this formula a bit?

  • @rimadas5931
    @rimadas5931 3 місяці тому

    Can someone share me the excel file??? I m not able to download

  • @rimadas5931
    @rimadas5931 3 місяці тому

    Hi I m not able to download the file

  • @mindfulsphere
    @mindfulsphere 3 місяці тому

    For excel 2013

  • @mindfulsphere
    @mindfulsphere 3 місяці тому

    Can you show this in detail

  • @user-epslesvou
    @user-epslesvou 3 місяці тому

    Hi ... i cant create a bing key. It s not working anymore...any help?

  • @Michael-zg5cx
    @Michael-zg5cx 4 місяці тому

    Hey Great work! I used your code for two years now. But with the change to Azure Maps I don't get this think working anymore... can you make a new video where you explain how to use Azure Maps API instead of Bing Maps?

  • @WaliSAQAR
    @WaliSAQAR 4 місяці тому

    Why we used this all it's all available in map when we enter two cities distance in map it's showing

  • @mdtauhidalam9349
    @mdtauhidalam9349 4 місяці тому

    Hi Hemanth, great video illustrating Power BI use cases in the field of inventory management. I have one small question, how can we do a dynamic ABC and XYZ analysis such that the classes update based on selection on the date slicers? It'd be very helpful if you could make a video on the same. Thank you so much for such value content. Keep it Up!

  • @widhyawanjuliaris3939
    @widhyawanjuliaris3939 5 місяців тому

    thank you very much for the knowledge. you've helped me in many ways.

  • @kami_Shi_Shin
    @kami_Shi_Shin 5 місяців тому

    If you want the annual sales quantity to work used 43996 instead of today in the DAX formula.

  • @swagatakarmakar1688
    @swagatakarmakar1688 6 місяців тому

    Which can show the vehicle routing map

  • @jespinob
    @jespinob 6 місяців тому

    how do I download the template?

  • @josuem.yamadjako4133
    @josuem.yamadjako4133 6 місяців тому

    Very good template! Thanks

  • @vigneshkr9497
    @vigneshkr9497 6 місяців тому

    how to do this between pincodes within the city?

  • @flyer737
    @flyer737 7 місяців тому

    Hi hemant can you please let me know how to calculate cumulative forecast

  • @atigyadubey998
    @atigyadubey998 7 місяців тому

    Bro how is cardiac gunner pro? I am planning to buy to cycle in and around blr

  • @alexandrasanchez2187
    @alexandrasanchez2187 7 місяців тому

    you are a God amongst men.

  • @ryans7940
    @ryans7940 7 місяців тому

    Thank you, excellent Gantt chart and video, this is very helpful. Something happened when I was adding data and the project shrunk to 17 weeks - I was unable to figure out how to make it change back to 137. I see others have had the same issue. After I downloaded another copy, it is back to 137 weeks. Does anyone know why it changes from 137 weeks to 17 weeks? I don't want to make the same mistake again and lose any work.

  • @shehanwijeyawansa1372
    @shehanwijeyawansa1372 8 місяців тому

    Thank You

  • @gethingeorge4140
    @gethingeorge4140 8 місяців тому

    Thank you so much

  • @NMN797
    @NMN797 8 місяців тому

    Thank you. Can this spreadsheet view in Monthly intervals?

  • @jenildesai5565
    @jenildesai5565 8 місяців тому

    This code is working for India's coordinates. But it is not working for USA coordinates. Please help.

  • @andrewereynolds5840
    @andrewereynolds5840 8 місяців тому

    Great info video.👍👍👍

  • @13_pritamsanyal41
    @13_pritamsanyal41 8 місяців тому

    Hey, why the marix is not symmetric ?

  • @alecd8534
    @alecd8534 9 місяців тому

    😄

  • @thatgoanguy4427
    @thatgoanguy4427 9 місяців тому

    Im getting #value error, idk why

  • @moealshaibani914
    @moealshaibani914 9 місяців тому

    Hi, this is very very helpful. Thanks. But how can I make more columns to make it fit for one year plan. The template show 6 months only. Please help

  • @ShiveshThakur-mx9jq
    @ShiveshThakur-mx9jq 9 місяців тому

    Great content. Clear and concise. Many Thanks.

  • @ursvipul
    @ursvipul 9 місяців тому

    Its interesting to know that we can bring back cycle in Bus! Does all bus services allow to carry cycle like this? Did they charged additionally for cycle, if yes how much?

    • @HEMANTHHEMU86
      @HEMANTHHEMU86 8 місяців тому

      Airawat club class can accomodate. They charged 250 per cycle

    • @pvnh
      @pvnh 11 днів тому

      Do we need to book in advance?

  • @bravindranaidu
    @bravindranaidu 9 місяців тому

    How can i get this simulation model

  • @mi59300
    @mi59300 9 місяців тому

    TERRIFIC! just TERRIFIC!!!!

  • @bhargavagatla3583
    @bhargavagatla3583 9 місяців тому

    Hi.. Can we get the distances by pincode to pincode

  • @CosmicVibrationEdna
    @CosmicVibrationEdna 9 місяців тому

    Can you work with me on a personal file?

  • @SantoshDas-l2q
    @SantoshDas-l2q 9 місяців тому

    Hello, how connect with you

  • @macroiu3778
    @macroiu3778 10 місяців тому

    super unselfish deed done by you for the most unsmart person like me that I hope my further request for more functions such as automatic calculation of % completion in terms of whole project & the project variances between actual & planned comparison by means of adding more columns on the same table presented by you would not be too demanding & annoying to you....