|
|
#1
07-08-2016, 02:40 AM
|
|||
|
|||
Formula to work out equipment hire based on a minimum hire period.
Hi there,
I working with equipment requirements and minimum time that one can hire, in this case on a 4-weekly cycle. For example in week 1 I need one piece and in weeks 2 to 4 I need 0, then I need 1 for the first 4 weeks. Then if I need 2 in week 5 and 1 in week 6, then I need 2 from week 5 to week 8. Is it possible to do a formula that works that out if my weeks are in columns and then my equipment types in rows like in the example below? Many thanks for the help. W1 W2 W3 W4 W5 W6 W7 W8 W9 W10 W11 equipment by week 0 1 0 0 0 1 2 3 0 0 1 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need formula to determine minimum quantity needed per price | mbking | Excel | 2 | 02-10-2015 01:46 PM |
| Count the common time period (month) between two date period of time | Barni | Excel | 6 | 08-15-2014 07:52 AM |
 Trying to create a formula to calc if I add x new accounts, I will have to hire y tech/support ppl
|
glen123 | Excel | 7 | 07-28-2014 07:29 AM |
|
How do I calculate planned work for a given time period
|
bumpui | Project | 1 | 06-04-2014 06:37 AM |
|
Managing equipment and person operating equipment
|
ProfessorGilligan1 | Project | 1 | 04-12-2012 12:29 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode