I need to determine a price based on approximately 700 combinations of
choices. Basically, I have a list of 7 days of arrival (Mon-Sun), a list of
15 length-of-hours worked (from 8 hours over 1 day to 80 hours over 12 days),
and a list of 7 days of departure (Mon-Sun). The User chooses one from each
list in ANY combination (7 x 15 x 7) ... that's 735 combinations. I can (try
to) figure out how an OLAP cube or a Pivot Table works ... but I don't want
to waste my time if it's not going to solve my problem to begin with. So, do
you know if I can create some kind of cube/table/something so that I
determine a price, based on any combination of the three lists? (By the way,
I use the Data Validation List in each of the three cells.) Thanks a lot.