Forum Discussion
Solved
Bundle Help
I'm looking for some help with bundles, currently using floor formula
The formula I am using is =FLOOR(total hours, hour interval)/hour interval
The problem I have is the higher intervals also include the lower intervals.
I'm trying to get a total number of each interval if the 6000 interval includes the 4000,2000,1000,500 or 4000 includes 2000,1000,500...
to sum up, at 7000 hours I would require 7x500, 4x1000, 1x2000, 1x4000, 1x6000
12000hrs requires 12x500, 6x1000, 2x2000, 2x4000, 2x6000
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.
