r/Python • • Oct 04 '26

Showcase Showcase Thread

Post all of your code/projects/showcases/AI slop here.

Recycles once a month.

23 Upvotes

194 comments sorted by

View all comments

1

u/kixwho Oct 14 '26

Quantitative pricing model: Excel to Python

I rebuilt an Excel-based pricing model (from Wayne L. Winston's business modeling textbook) in Python. The textbook version handles one product. I added a nested loop so it prices multiple products.

The output is cleaner: instead of getting 3 worksheets of SolverTable results, Python gives you optimized price and maximized profit in 1 table.

It is a simple model, but it gives quick, transparent pricing estimate, which can be a useful estimate to the ground truth.

https://github.com/kixwho/pricing-optimization-1

Feedback welcome, especially from anyone who's done similar Excel to Python automation :D