Відео

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

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)

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

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

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

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

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

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

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