Helen_Joan
New Member
Good morning everyone;
I am looking for a solution to figure out when the material in my silo will run out looking at each of the last 7 days consumption rates. (ie, if we use material at the same rate as the last 7 days, it will be empty on day dd/mm/yyyy, but if we use material at the same rate as the last 1 day, it will be empty on day dd/mm/yyyy).
One solution would be to plot my data on an X/Y chart with date being X, and then getting the trendline, finding out the equation, and then plug in 0 for my Y.
I would love to make this more automated as we have multiple silos.
Another problem I run into is that the silo measuring intervals are not consistent. They are usually read at midnight, 6 am and 6 pm, sometimes they are read at noon. Sometimes there is a glitch in the system and there is no reading. And then I need to account for times when the silo is filling with material.
I know this is not simple, (but maybe it is!) but from lurking on this forum I know there are many brilliant people out there! (am I laying it on too thick?)
I am looking for a solution to figure out when the material in my silo will run out looking at each of the last 7 days consumption rates. (ie, if we use material at the same rate as the last 7 days, it will be empty on day dd/mm/yyyy, but if we use material at the same rate as the last 1 day, it will be empty on day dd/mm/yyyy).
One solution would be to plot my data on an X/Y chart with date being X, and then getting the trendline, finding out the equation, and then plug in 0 for my Y.
I would love to make this more automated as we have multiple silos.
Another problem I run into is that the silo measuring intervals are not consistent. They are usually read at midnight, 6 am and 6 pm, sometimes they are read at noon. Sometimes there is a glitch in the system and there is no reading. And then I need to account for times when the silo is filling with material.
I know this is not simple, (but maybe it is!) but from lurking on this forum I know there are many brilliant people out there! (am I laying it on too thick?)