Bundle Help

[Nfria985]

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

[#2]

@Nfria985 

You write "at 7000 hours I would require 7x500, 4x1000, 1x2000, 1x4000, 1x6000"

Can you explain that in detail?

[#3]

@Hans Vogelaar 

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

[#4]

@Nfria985 

OK, I'm beginning to understand. See the attached demo.

[#5]

Genius, that's exactly what I was looking for. Thanks so much

[#6]

@Hans Vogelaar 

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

[#7 · Accepted solution]

@Nfria985 

See the attached version.

[#8]

That is perfect, thank you so much. I've been beating my head for days. Guess its above my skill level