0

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.

  • 1
    Welcome to WebApps StackExchange. Forget the spreadsheet for a moment. How would you do it manually, like on a sheet of paper.? – Tedinoz Nov 8 at 10:08
  • I would check the difference between two dates (feeding and ending), check for how long the supp points will last and then combine it. @Tedinoz – Dirith Nov 8 at 20:21
  • So, you’ve got to calculate how many instances of feeding (at a cost of 44,000 points per instance) will be consumed until you run out of points? And sum those instances in order to calculate the date and time on which the last feeding can/will take place? – Tedinoz Nov 8 at 20:30
  • 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. – Tedinoz Nov 8 at 20:39
  • 1
    Well, I’m not trying to solve the problem. I’m trying to help you solve the problem. That’s why I suggested working it out longhand in the first instance; understand the variables, the sequence, what do you do with the non-standard time - such as, the feeding interval is 5 hours but the first reed is at 03:00. Or the points are 44,000 per feed, but what about the points left over after the pet dies? – Tedinoz Nov 8 at 21:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.