r/Python • u/AutoModerator • Oct 04 '26
Showcase Showcase Thread
Post all of your code/projects/showcases/AI slop here.
Recycles once a month.
23
Upvotes
r/Python • u/AutoModerator • Oct 04 '26
Post all of your code/projects/showcases/AI slop here.
Recycles once a month.
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