Measuring Volume in Real Time Formula

**DDM64** · 05-16-2013, 10:50 AM

Good morning,

I have the following criteria and need help with a formula to gage the volume of 3 Silos:

1) Weight is 24,000 kilograms per silo.
2) Rate of depleation is 1,500 kg per hour.
3) Depleated in 16 hours per silo.

Formula for above: 24000 / 1500 = 16 hours

I need this formula to work with system clock (PC), so I can gage approximate level/volume that any given silo is currently at.

Your resply as soon as possible, is greatly appreciated.

**DDM64** · 05-16-2013, 09:08 PM

Maybe I did not describe my dilema clearly. I need assistance with a formula that will provide me with the capacity level it is currently at anytime during the day using the Operating System clock.

Is there a nested function that can be created using Now() function with maybe an IF statement.

Can someone please assist me with this.

**FDibbins** · 05-16-2013, 11:49 PM

1st, according to the rules, please wait at least 24 hours before "bumping" your thread

2nd. you probably can use the now() function for what you want, but you will need to have a starting point, and then youi need to decide what to do once the "end" is reached?

**DBY** · 05-17-2013, 11:20 AM

Hello
Not sure if it's what you're looking for but take a look a the attached file. Do the formulas stack up with the correct answers? You will however, have to refresh the page to update the Now() function, so it's not completely automatic.

Hope this helps.
DBY

**DDM64** · 05-17-2013, 11:23 AM

Good morning. My apologies for not waiting.

Can you please assist me with this:

Column A (Previous Days' Activity):

Silo 1: 24,000 (Note: Capacity 24,000kg; In Use Rate: 1,500 kg; takes 16 hours to deplete)
Silo 2: 16,000 Need formula that uses the previous Days' Activity and the Operating System clock to produce a rough estimate of contents of silo.
Silo 3: 24,000

Silo 2: Change-Over Occurred at 13:20 hours.

I realize I could and probably should create a PI() function (width; height; diameter, etc.) but do not have all info. I need assistance putting together a formula that look above info and let me know approximate level of any given silo.

Thanks a bunch. Deanna