Need help creating database \ excel thing?
I currently have a herd of cows that get fed a range of different feeds at different levels daily the amount of feed is calculated daily using excel.
What I would like to do is keep a record of how much was fed on what day. I would also like to be able to put in current inventory levels as well as deliveries.
The database would then take current levels minus the days feed to give me what's left.
Because there are a number of different cells in excel that I use I would like the majority of it to be automatic, obviously I could do this easily with just cut and paste but does anyone know how I could go about creating this. I have used excel a bit and know a few of the common formulas but I have never used access.
any help would be much appreciated.
Sorry for the novel. *
Database = Access or Excel
Hi Jezcullen,
Your question is very intriging as I know my friend is also dealing with the same situation.
Not having the data it is kind of hard to answer your question. Based on my experience, the ultimate database is Access but Excel can be manageable and more user friendly. One of my favorite formulas that should be useful in your file is SUMIFS. With the SUMIFS, I can foresee you being able to track your current inventory levels even at the different ranges of the feeds.
Hope it helps,
Raymond
Jez The good news is that you
Jez
The good news is that you definitely do not need to go out of Excel for this.
Your basic issue boils down to 3 things:
1. Data Input: You need an automated way to log today's feed quickly and efficiently
2. Data Store: You need a structured way of storing your data
3. Reporting: You need a way to calculate outstanding feed (Feed starting balance - what's been fed)
Someone might offer all of this for free on this forum, but If you would like us to provide a quote for this work, we'd be interested: Request a Quote