|
|
#3
07-12-2016, 11:19 AM
|
|||
|
|||
Formula to work out equipment hire based on a minimum hire period.
Hi gebobs, thanks for the reply.
In the spreadsheet attached you can see the number of equipment required by week. In week 27 I need to 1, and week 28 I need 10. However, once a piece of equipment is hired, then I need to keep it for 4 weeks. So the equipment I hire in week 27 I can only send it back in week 31, but in week 28 I have to hire another 9, which I need to keep for 4 weeks....and so on. I don't know how to do it or if it can be done with formulas without using a macro. Any help is much appreciated. Thanks 
|
|
|
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