Forum Discussion
Dynamic Pricing (increase or discount on prices based on Month/Day)
Did a good bit of searching before posting and cant seem to find anything; I have a special event business that is seasonal with high demand on weekends and trying to improve our way of charging for our good and services and by implementing "dynamic pricing".
we currently estimate event using a spread sheet and would like to just add in a couple cells that add to or discount based on a month or day drop down selection.
Cant figure out how to upload a file so here is a https://docs.google.com/spreadsheets/d/1JJ6_0UdlAsGMzsQDvhPZrwtOu1lTmokq/edit?usp=sharing&ouid=113168013346011042595&rtpof=true&sd=true with notes on what I am trying to acheive.
Just need to know how to:
1. get the two needed drop down selections for the cells
2. Associate a multiplier to those (Day/Month) values
3. Show the associated value for the selection
Thanks,
Michael
Here's another way to do what Hans has suggested:
https://docs.google.com/spreadsheets/d/1O_mBs7R3bzziZ0AbJ-4hofWohlOee87G5ciArGwfdWY/edit?usp=sharing
You may be able to understand the logic a little more easily.
Cells B7 and B8 have been equipped with Data Validation to help prevent entry spelling errors.
David
5 Replies
Here's another way to do what Hans has suggested:
https://docs.google.com/spreadsheets/d/1O_mBs7R3bzziZ0AbJ-4hofWohlOee87G5ciArGwfdWY/edit?usp=sharing
You may be able to understand the logic a little more easily.
Cells B7 and B8 have been equipped with Data Validation to help prevent entry spelling errors.
David
compassguy
This has got me real close, thankyou!
I will work with this and see how I can implement it into my actual spread sheet, thank you!- You're quite welcome. If there's anything else you need some help with, run it by me. I'll help if I can.
David
See the attached workbook.
- that is getting close, thank you!
I am still a little unclear as to how to do it myself
