capacity

Hello, Building a spreadsheet (Excel 2010) for a client that wants to track different levels of capacity based on location. All of the widgets are moving and I want the total capacity of new location to be dynamic based on the drop down that is chosen on the widget page. Details: I have two...

I have a ware house A its capacity = 100*50*20 = 100000 cft deduction 20% as pathways or walkway = 20000 cft Remaining capacity in cubic ft = 80000cft My bag dimension is 2.5*1.5*.67 = 2.5 cft I can not stack more than 8 bags. How many bags I can store in Warehouse if capacity left 21260 cft...

Dear all, I am working with a workbook, which enables me to 1. have a capacity overview (total, per team, etc) 2. have a demand overview (total, per project, per team, per role) 3. make simulation / what-if scenarios. The 3rd part is in order to make possible "movement" of projects from one...

I am looking to build a simple spreadsheet that takes an Excel Shape that resembles a tank and overlays it with a color to show how full it is. I was thinking the amount colored in would be based on the amount of capacity/amount in tank. I know there are ways to do this but cannot think of how...