Hi, I was hoping that someone would have some good advice or maybe aware of a similar dashboard template that I could possibly start with.... I'm not sure if I should be trying to learn Power BI or staying in my excel lane for this project.
Each time we dump a truck of grain at our grain system, we log the time, farm that it came from, the moisture, quantity of bushels, which grain bin it's going into and maybe a free form note. I'd like to have the drop downs (form) at the top of the sheet and then every time the load is dumped, it populate in the excel list at the bottom of the sheet. I'm thinking that this should be run on a touchscreen tablet, as the dust can get pretty bad.... any suggestions on the best way to build this would be greatly appreciated.
It's be really cool if the drop down for the grain bins would include the % full for each bin as we go!
Thank you in advance for any advice,
Rob
Maryland
Each time we dump a truck of grain at our grain system, we log the time, farm that it came from, the moisture, quantity of bushels, which grain bin it's going into and maybe a free form note. I'd like to have the drop downs (form) at the top of the sheet and then every time the load is dumped, it populate in the excel list at the bottom of the sheet. I'm thinking that this should be run on a touchscreen tablet, as the dust can get pretty bad.... any suggestions on the best way to build this would be greatly appreciated.
It's be really cool if the drop down for the grain bins would include the % full for each bin as we go!
Thank you in advance for any advice,
Rob
Maryland