Excel tools and VBA snippets for focused business tasks

This repository represents a comprehensive operations research case study at a steel production plant facility implementing aggregate production planning using Excel solver to minimise scrap generation across three specialised divisions.

Produire, prédire et décider grâce aux solveurs Python et Excel, aux lois de probabilité mathématiques et au Machine Learning (Recherche opérationnelle)

UNCW BAN 501 This course introduces students to the field of prescriptive analytics. Students will learn how to develop and use modeling techniques used extensively in the business world. Both mathematical and spreadsheet skills in MS Excel are utilized for performing optimization, simulation, and decision analysis techniques.

🏭 A linear programming project using Excel Solver to optimize rug production for "Beirafio". Minimizes total cost by balancing in-house manufacturing and external suppliers. Developed for the OCD course at ISCTE.

Attached in this repository are Excel projects that range from Data Analytics to Optimization Models.

Hong Kong hotspots closed route simulator using traveling salesman problem model

This project uses Global Firepower Index dataset to explore India's potential in becoming a dominant force in global military power using Excel's What-If Analysis and Solver.

Researching and using evidence-based data to find optimal cost for a brain-supporting diet using linear programming

Utilizing Linear Programming through Excel Solver to optimize business strategy for maximum profit

Comparing and solving transportation cost optimization problems using linear programming