Forum Discussion
Solved
Seedling distribution
I am looking for some Excel help to help us organize a tree planting plan for a project we are doing. We have base data that includes farmers' names, the species of seedlings they want to plant and t...
ms_mit Great you could get it to work. And what's 15 minutes for a job that would otherwise take perhaps a whole day of copying and pasting. Now that I look back at the query, I see I was over-thinking the matter by adding the Grouped Running Total. We can do without and it will probably speed up the process. See attached.
- Hi Jitin, Thanks for the help. Pivot tables are a wonderful thing but I also tried using them and couldn't get it. The problem I am working on is finding a formula (or set, or some code), to parcel these gross amounts (i.e. 80 mahogany for a particular farmer) into individual bags of 25 seedlings, or some limit like that. So in other words, I'd end up with 3 bags of 25 mahogany each, with a remainder of 5 which would go in the next bag of 5 mahogany and 20 teak. Does that make sense?
- Hi Jitinm, Thanks for that. It calculates the full bags (of 25) and the remainder correctly. Do you have any idea how to enumerate a list with the individual line items? So for example Farmer1 + Mahogany = 3 bags of 35 seedlings each becomes:
Farmer1 | Mahogany | 25
Farmer1 | Mahogany | 25
Farmer1 | Mahogany | 25
.....?
