Blog: Python embedded in Excel: First impressions

Microsoft recently announced a new Excel feature, Python embedded within Excel. This is great news, as it combines our two favourite tools: Excel and Python.

Since our focus is on optimization modelling, we immediately wondered if it is possible to use a Python library to solve optimization models directly within Excel. Spoiler alert, it is!

In this article, we experiment with building and solving a linear program in Excel using the Python SciPy library.

#Excel #Python #SciPy #optimization #orms
https://www.solvermax.com/blog/python-embedded-in-excel-first-impressions

Test early, test often. There's no need to 🤞🙏😬 when you ship model changes to production. See 3 experiments on 3 decision models: https://www.nextmv.io/blog/to-change-my-decision-model-or-not-thats-not-a-question-its-a-test

→ What if I upgrade the entire fleet to be cold chain-ready?
→ What if I add an inventory cap to reduce food waste?
→ What if I increase shift break time?

#decisionOps #CICD #orms #foodlogistics #supplychain #foodtech

Heyo #orms people, we’re making mvs! Go from 0 to 60 in seconds using google #ortools, #python, and @nextmv. Stay tuned for more updates Real Soon Now™️...

Start of an inspiring week in Dagstuhl at the Seminar on Multiobjective Optimization on a Budget. #orms #multiobjective #optimization

@philbetts The point of #ORMs is more about making it easy to do persistent #CRUD operations on #Python data. They obfuscate #SQL, and can make badly-performing queries, but they don’t eliminate the need to know SQL to make them work well. Better to learn SQL first before diving into ORMs unless your database is really simple.

Great opening session at OR 2023... and the GOR Award goes to Anita Schöbel
#orms #or23

Learn how to perform acceptance and shadow tests on decision models, and see how they can fit into your #CICD workflows. Join us live (or get the recording later): https://www.nextmv.io/videos/determining-decision-model-readiness-using-shadow-tests-and-acceptance-tests

#orms #datascience #foodlogistics

New release! Shadow test decision models with Nextmv. Check out all the goodness in the release blog: https://www.nextmv.io/blog/release-shadow-testing-for-decision-models-in-nextmv

Let us know what you think!

#orms #datascience #MLops #DecisionOps

Manifesto for the Responsible Development of Mathematical Works - A Tool for Practitioners and for Management #orms https://arxiv.org/abs/2306.09131

Shadow testing is a useful way to de-risk algorithm rollout and build confidence in deploying changes to production systems. We take a look at the what, why, when, and how: https://www.nextmv.io/blog/what-is-shadow-testing-for-optimization-models-and-decision-algorithms

#orms #operationsresearch #datascience

Blog: Warehouse optimization: Assessing layouts (Part 2)

In this article we apply the model, as described in Part 1, to a variety of warehouse designs. As a result, we improve the efficiency of the picking process by 33%.
All the code is available, so if you think you can design a better warehouse layout, then please have a go. Let us know what you discover.

#Python #optimization #orms

https://www.solvermax.com/blog/warehouse-optimization-assessing-layouts

Anant Subramanian, the host of "subject to", is not (yet) in the #orms fediverse, so I take the opportunity to share one of his latest recordings, featuring Eduardo Uchoa's @eduardo_uchoa and Ruslan Sadykov's historical findings about the origins of column generation -- it is pure gold and a "must know" in many aspects

https://youtu.be/C5SpAWGn0dE?si=171mJckog6Rvd-MU

In 1952, #ORMS luminary Philip M. Morse wrote an article defining operations research (except that he refuses to give a precise definition). Is the OR of today similar to the OR of 1952? Surprisingly, yes. Read my latest post to find out more:

https://punkrockor.com/2023/07/31/operations-research-what-is-it/ #PunkRockOR

Are you teaching undergrad OR this fall or next spring? You are invited to use redistricting as a course project. Pre-register your class by sending me an email. I can share related course materials (e.g., project descriptions, grading rubrics, homework questions, data files) #orms

Is there any company who actually uses Jump (https://jump.dev/JuMP.jl/stable/) i.e. scalable MIPs in #julialang ?

I have mostly used #rstats for Mathematical Optimization. But might have to move over to #python sooner or later.

Though, the library I have used in R, was massively influenced by Jump Julia. But sadly, no one uses R for Operations Research.

#OperationsResearch #orms #foss

I needed Jacques to understand that convexification is the same as discretization and I think that Francois already knew it 20 years before us #orms

👀Acceptance testing preview for a vehicle routing decision algorithm: https://youtube.com/watch?v=nSMETS3GEkk

Exciting stuff is coming...

#datascience #orms #routeoptimization #foodtech

Starting a new newsletter for Data enthusiasts: The Data Voyage.

In this newsletter, I will share with you my insights and experiences on topics such as statistics, operations research, data analysis, and more. I will also showcase some of the cool projects that I am working on or learning from.

I hope you will join me on this journey of discovering the power and beauty of data.

Don’t miss the first post this Saturday. Subscribe for free now!

#data #analytics #operationsresearch #orms #rstats #python #datascience #newsletter #substack

https://thedatavoyage.substack.com/p/join-me-on-the-data-voyage?sd=pf

Javier is back, now including the demand for his art in the production planning. Sorry for the long video, I hope it will at least be watched by the #Julia enthusiasts or the #orms people out there. Maybe #microeconomics people will enjoy it too. Once more I use #pluto and #jump.

When planning the production, in our last video, we ignored the demand for the products. In this video, we will evaluate two strategies to include the demand into the model.
The first strategy is to have a sale of excess products. In this case, we have a piecewise revenue function, and we use some modeling tricks to model it into a mixed-integer linear program.
The second strategy is to consider the price at which we sell things to be a decision variable as well and to model the demand as a function that depends on the price linearly. This case leads to a very interesting conclusion about the nature of demand satisfaction.

https://youtu.be/0HRAYGYrkIc

You check a blog post and other links at https://abelsiqueira.com/youtube

#mathematicalmodeling #mip #optimization

Model testing and iteration matters across decision algorithms and teams. Join us for a tour of batch testing (a precursor to scenario and acceptance testing) on Thursday, June 29: https://www.nextmv.io/videos/decision-model-testing-for-routing-assignment-order-fulfillment-and-shift-scheduling

#datascience #orms #operationsresearch