Hemanth Boddapu
Hemanth Boddapu
  • Видео 11
  • Просмотров 329 421

Видео

Project planning on Excel with Gantt chart and Dependency arrows. Download template
Просмотров 38 тыс.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 тыс.2 года назад
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
Просмотров 27 тыс.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 тыс.3 года назад
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 тыс.3 года назад
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
Просмотров 10 тыс.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
Просмотров 98 тыс.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
Просмотров 126 тыс.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,7 тыс.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

Комментарии

  • @alexfernandes7629
    @alexfernandes7629 12 дней назад

    Loved watching the video❤

  • @lpaone01
    @lpaone01 18 дней назад

    Great work! Saved me many hour of study.

  • @lexiepan4257
    @lexiepan4257 25 дней назад

    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 28 дней назад

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

  • @rimadas5931
    @rimadas5931 28 дней назад

    Hi I m not able to download the file

  • @mindfulsphere
    @mindfulsphere Месяц назад

    For excel 2013

  • @mindfulsphere
    @mindfulsphere Месяц назад

    Can you show this in detail

  • @user-epslesvou
    @user-epslesvou Месяц назад

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

  • @Michael-zg5cx
    @Michael-zg5cx 2 месяца назад

    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?

  • @user-ns4tw5lw1r
    @user-ns4tw5lw1r 2 месяца назад

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

  • @mdtauhidalam9349
    @mdtauhidalam9349 2 месяца назад

    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 3 месяца назад

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

  • @kami_Shi_Shin
    @kami_Shi_Shin 3 месяца назад

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

  • @swagatakarmakar1688
    @swagatakarmakar1688 3 месяца назад

    Which can show the vehicle routing map

  • @jespinob
    @jespinob 3 месяца назад

    how do I download the template?

  • @josuem.yamadjako4133
    @josuem.yamadjako4133 3 месяца назад

    Very good template! Thanks

  • @vigneshkr9497
    @vigneshkr9497 4 месяца назад

    how to do this between pincodes within the city?

  • @flyer737
    @flyer737 4 месяца назад

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

  • @atigyadubey998
    @atigyadubey998 4 месяца назад

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

  • @alexandrasanchez2187
    @alexandrasanchez2187 4 месяца назад

    you are a God amongst men.

  • @ryans7940
    @ryans7940 4 месяца назад

    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 5 месяцев назад

    Thank You

  • @gethingeorge4140
    @gethingeorge4140 5 месяцев назад

    Thank you so much

  • @NMN797
    @NMN797 5 месяцев назад

    Thank you. Can this spreadsheet view in Monthly intervals?

  • @jenildesai5565
    @jenildesai5565 6 месяцев назад

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

  • @andrewereynolds5840
    @andrewereynolds5840 6 месяцев назад

    Great info video.👍👍👍

  • @13_pritamsanyal41
    @13_pritamsanyal41 6 месяцев назад

    Hey, why the marix is not symmetric ?

  • @alecd8534
    @alecd8534 6 месяцев назад

    😄

  • @thatgoanguy4427
    @thatgoanguy4427 6 месяцев назад

    Im getting #value error, idk why

  • @moealshaibani914
    @moealshaibani914 6 месяцев назад

    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 7 месяцев назад

    Great content. Clear and concise. Many Thanks.

  • @ursvipul
    @ursvipul 7 месяцев назад

    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 5 месяцев назад

      Airawat club class can accomodate. They charged 250 per cycle

  • @bravindranaidu
    @bravindranaidu 7 месяцев назад

    How can i get this simulation model

  • @mi59300
    @mi59300 7 месяцев назад

    TERRIFIC! just TERRIFIC!!!!

  • @bhargavagatla3583
    @bhargavagatla3583 7 месяцев назад

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

  • @CosmicVibrationEdna
    @CosmicVibrationEdna 7 месяцев назад

    Can you work with me on a personal file?

  • @SantoshDas-l2q
    @SantoshDas-l2q 7 месяцев назад

    Hello, how connect with you

  • @macroiu3778
    @macroiu3778 7 месяцев назад

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

  • @ijajbagwan8239
    @ijajbagwan8239 7 месяцев назад

    Thank you.. By far the best template for project planning and management.

  • @rahulprajapati4638
    @rahulprajapati4638 8 месяцев назад

    Dear sir, kind request to make more videos on tools and software tutorial related to industrial engineering.

  • @bharathharthikote9168
    @bharathharthikote9168 8 месяцев назад

    I have sales and purchases for different products from different stores(shops) as orders table in Table and now I want to do Inventory analysis. How to you get the current stock available and what is sku_id?

  • @shyammaddi1
    @shyammaddi1 8 месяцев назад

    how to add a percentage (%) of completion on each task along with status bars ?

  • @gokaykkaya
    @gokaykkaya 9 месяцев назад

    can this method be used for 80 locations?

  • @ngocnguyen4616
    @ngocnguyen4616 9 месяцев назад

    Thanks you for your sharing. Could I ask 1 question? I get driving distance on Power BI with Bing Maps API. The syntax is similar with you. However, when I checked some routes, the driving distance seems incorrect. For example : Route : Harald-Stender-Platz 1, 20359 Hamburg, Germany - Am Baumwall 11, 20459 Hamburg, Germany - Query result : Distance 2382 km, Travel duration is 665 minute - Resulted checked on Bing Maps: 2.6 km, Driving time: 7 minute So, did I make any mistake? = Xml.Tables(Web.Contents("dev.virtualearth.net/REST/v1/Routes/", [ RelativePath="DistanceMatrix", Query =[ origins="" & LatStart & "," & LonStart &"", destinations="" & LatDest & "," & LonDest & "", travelMode="driving", distanceUnit="kilometer", timeUnit="minute", o="xml", key=BingMapsKey ] ] ) )

  • @vivekupadhyay3978
    @vivekupadhyay3978 9 месяцев назад

    fully packed content in a very short video, thanks alot!

  • @rebirth_Nther
    @rebirth_Nther 9 месяцев назад

    Although there are some differences in the calculations, the simulations are relatively accurate. Your simulation excel is great, it helped me a lot.

  • @irenekocina9471
    @irenekocina9471 9 месяцев назад

    Hello! Thank you so much for this, i love it! Question, is it possible to change the colors? And if so, how do i do that

  • @daniellesutton6059
    @daniellesutton6059 9 месяцев назад

    hiya, the excel sheet and link doesnt seem to work, can you upload this again? thanks!

  • @rohitdadi7898
    @rohitdadi7898 9 месяцев назад

    Can you share the link....of the code pls......hyperlink is missing

  • @user-jm2gm8rs5z
    @user-jm2gm8rs5z 9 месяцев назад

    Inspiring❤