Hello everyone,
This is a very practical exercise that I am trying to do since a little while but without any success.
I defined 2 informations for light bulbs :
- The 1st time it is likely to burn and be replaced : For example after 2.5 years or after 0.3 year
- The life time of a bulb : For example : 4.5 years or 0.4 years
I would like to define for each coming year how many times the bulb will be replaced : 0, 1, 2, 3, ... times.
So I expect something like this :
<tbody>
</tbody>
The question is what formula can I use to calculate the values in Year 1, Year 2, etc ?
Many thanks in advance for your help !
Best regards from Brussels.
Gregory
This is a very practical exercise that I am trying to do since a little while but without any success.
I defined 2 informations for light bulbs :
- The 1st time it is likely to burn and be replaced : For example after 2.5 years or after 0.3 year
- The life time of a bulb : For example : 4.5 years or 0.4 years
I would like to define for each coming year how many times the bulb will be replaced : 0, 1, 2, 3, ... times.
So I expect something like this :
1st replacement | Life time | Year 1 | Year 2 | Year 3 | Year 4 | ... |
2.5 | 4.5 | 0 | 0 | 1 | 0 | ... |
0.3 | 0.4 | 2 | 3 | 2 | 3 | ... |
<tbody>
</tbody>
The question is what formula can I use to calculate the values in Year 1, Year 2, etc ?
Many thanks in advance for your help !
Best regards from Brussels.
Gregory