I couldn't think of a better title so I do apologize if it is misleading, but my question is this:
Of all videos coming in daily,
100% is kept for 30 days
90% is kept for 180 days
50% is kept for 365 days
15% is kept for 1,825 days
5% is kept indefinitely
I'd like to get it all worked down into a 60/20/15/3/2 kind of breakdown where the percentages work out to 100% rather than 260%. The reason being for this is that I have a pre-built calculator for this kind of stuff, but it requires the percentages to be =100% for it to be accurate. Putting in the percentages provided would have given me completely blown up and useless results, hence the question. If there is a better way to go about figuring this out than that method, then I am open to all suggestions.
My Figuring:
How much video coming in daily is extraneous, I just need to figure out how much video is actually being retained at each of the retention policy intervals (lets call "indefinitely" 75 years or 27,375 days).
Giving the hours of video coming in daily an arbitrary number of 200, my thinking is that all videos last at least 30 days and then 10% of those are deleted so 180 hours per day is kept for at least 180 days. Then 50% of those videos are deleted at the 180 day mark which comes out to be 100 hours of video per day is kept for at least 365 days. Furthering that idea, 85% of those videos are deleted at the 365 day mark resulting in 30 hours of video per day is kept for at least 1,825 days. Lastly, 95% of those videos are deleted at the 1,825 day mark leaving a whole 10 hours of video per day being kept for at least indefinitely.
Using those numbers [daily intake x (number of days in the policy - previous policy length)], I can figure that there is a breakdown of:
6,000 hours of video is all that makes up the 30 days
27,000 hours of video makes up the following 150 days (180-30)
18,500 hours of video makes up the following 185 days (365-180)
43,800 hours of video makes up the following 1,460 days (1,825-365)
255,500 hours of video makes up the following 25,550 days (27,375-1,825)
And those work out to be 1.7%, 7.7%, 5.3%, 12.5%, and 72.8% (=100%).
Is my method to all this madness the best way to go about it? Am I even right? Are there any shortcuts that I could have taken to make this much easier such as find the percentage first and then work the other angles?
EDIT:
The percentages I am looking for and the percentages I calculated are completely different. I am fairly confident that I calculated the percentages incorrectly based upon incorrect number of hours of video at each step in the retention policy.
I am after the breakdown of videos on any given day, not the % each level makes up of the total retention policy as I have been trying to calculate.
I know my calculator works, I just need the right numbers to plug into it so I'm going to do some more work.