AgTalk Home
AgTalk Home
Search Forums | Classifieds (1) | Skins | Language
You are logged in as a guest. ( logon | register )

Excel formula for grain bin
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
ajblair
Posted 11/20/2020 05:58 (#8614450)
Subject: Excel formula for grain bin


Dayton, IA
Our spreadsheets for harvest bring in the grain from each field, grain cart scale has delivery grain bin for each load dumped. The grain from the field sheet then goes to the grain bin sheet to show how much grain is in each bin. There is a cell for grain delivered to bin. Then a cell for bin capacity. Then when grain is hauled out those loads are subtracted from the bin and there is a cell for current grain in bin.

I always thought it would be cool to have a page with a "cylinder" representing each grain bin that would have the max bushels listed and current bushels listed and then fill each cylinder with a color up to the amount of grain in the bin. You could look quickly and see that bin 1 is full, bin 2 is partly full and bin 3 is empty. What kind of chart could I use to select the bin capacity cell from above, the current bin amount cell from above and have the picture of the bin fill up to that level?

Thinking like those thermometer deals everyone puts up for fundraisers that they keep filling in with red until the total donations are met.

A.J.
Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete all cookies set by this site)