ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Will an OLAP cube or Pivot Table (or something else) solve my prob (https://www.excelbanter.com/excel-discussion-misc-queries/27368-will-olap-cube-pivot-table-something-else-solve-my-prob.html)

Crimsonkng

Will an OLAP cube or Pivot Table (or something else) solve my prob
 
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.


All times are GMT +1. The time now is 04:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com