Travis Johnson
Member
- Messages
- 2,369
I have a quick excel question and not surprisingly it IS sheep related.
I have been trying to set up a spreadsheet that calculates how much feed I have on the farm, how much I bring to the farm and how much I feed out. I got the simple stuff figured out, like daily averages and stuff and so every day as I type in what I just fed the sheep, it deducts it from a list and makes a nice little chart that shows me how much I have left.
I want to take this a step farther though. I want to predict when the feed will run out based on what I have fed out. For example, I have 2200 pounds of hay here now, and feed out 20 pounds per day on average. At that rate I will run out in 110 days. Okay that is easy to do, but my question is, can Excel calculate this on a calendar? If it knows today is 11-16-08, can it tell me when 110 days from now is? Can it work in that format?
I can go to a separate date and time calendar and figure it in, (Friday, March 6, 2009) but its a one time use. I would like to have this constantly running so as I type every day what I feed to the sheep, I have an idea when it will run out. That way if I add to my flock, or feed more out for whatever reason, its automatically calculated for me.
I know Excel pretty well, but I am not sure if it can work between dates?
I have been trying to set up a spreadsheet that calculates how much feed I have on the farm, how much I bring to the farm and how much I feed out. I got the simple stuff figured out, like daily averages and stuff and so every day as I type in what I just fed the sheep, it deducts it from a list and makes a nice little chart that shows me how much I have left.
I want to take this a step farther though. I want to predict when the feed will run out based on what I have fed out. For example, I have 2200 pounds of hay here now, and feed out 20 pounds per day on average. At that rate I will run out in 110 days. Okay that is easy to do, but my question is, can Excel calculate this on a calendar? If it knows today is 11-16-08, can it tell me when 110 days from now is? Can it work in that format?
I can go to a separate date and time calendar and figure it in, (Friday, March 6, 2009) but its a one time use. I would like to have this constantly running so as I type every day what I feed to the sheep, I have an idea when it will run out. That way if I add to my flock, or feed more out for whatever reason, its automatically calculated for me.
I know Excel pretty well, but I am not sure if it can work between dates?