Forum Discussion
Bundle Help
See the attached version.
You write "at 7000 hours I would require 7x500, 4x1000, 1x2000, 1x4000, 1x6000"
Can you explain that in detail?
I'm trying to calculate how many services will be required over an amount of hours. I would require a service at every milestone (500, 1000, 2000, 4000, 6000hrs) But the intervals also include the lower intervals when performing. eg: a 4000 hour service includes a 2000, 1000, and 500hr service.
If a contract is for 7000 hours it will require 7 x 500 intervals (performed at every 500 but not including 1000, 2000, 4000, and 6000 intervals) 4 x 1000 (performed every 1000, excluding 2000, 4000, 6000) , 1 x 2000, 1 x 4000 and 1 x 6000, not just a straight division of interval times (7000/500=14, 7000/1000=7...)
Hope that makes sense
OK, I'm beginning to understand. See the attached demo.
one more quick question, is it possible to include a modifier for the amount of intervals needed based on a starting hours?
The current option assumes the starting hours is zero, but if a contract starts at say 3700hrs the first interval will be a 4000hr service, not a 500hr. Could this be adjusted to calculate the amount of services based on the starting hours?
term hrs interval hrs amount starting hrs 7000 500 7 3700 1000 4 2000 1 4000 1 6000 1 See the attached version.
Genius, that's exactly what I was looking for. Thanks so much