Posted 11/20/2020 05:58 (#8614450) Subject: Excel formula for grain bin
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.