I’m trying to prepare a sheet to count fees based on cycles (specific hours) to know how many time I got to do some kind of action.
For example, I got a virtual pet which has maximum 1 500 000 support points. Every cycle (every 5 h) it consumes, for exampe, 44 000 points. When points will end and nobody will feed it again - in next cycle after last cycle pet will die.
I’m trying to prepare sheet which has cells with:
- full date with hour of last feeding,
- days remains to last cycle,
- full date with hour when pet will die,
- actual status of support points (which depends of dynamic actual time).
Pet consume points, for example, after this hours: 03:00:00, 08:00:00, 13:00:00, 18:00:00, 23:00:00.
I’m truly stuck and don’t know how to solve this problem. If you would help me I will be very grateful.
// 1ST PROPOSITION - by Tedinoz
"How about a spreadsheet that has four columns: start date&time, start points, next feeding date/time, points after next feeding. Then, in rows, enter the start date and start points, then add 5 hours to start date and deduct 44000 points from start points. Next row, start date = previous row feeding date, start points = previous row end points. Continue until you run out of time/points."
Main problem is the I want to make formula which will be able to count status of pet according to hours triggers. With for example 100 pets, this proposition will not work.