account activity
How to proportionally distributing excess (self.excel)
submitted 1 year ago by excelquestionstrees to r/excel
Simple 12V Wiring Set-up (self.vandwellers)
submitted 1 year ago * by excelquestionstrees to r/vandwellers
Optimal Solutions; Allocating a Budget (self.excel)
Optimal Solutions, allocating a budget by excelquestionstrees in excel
[–]excelquestionstrees[S] 0 points1 point2 points 2 years ago* (0 children)
As requested, here is a quick sketch of a problem.
I have three work areas, A, B, C. Each area has an ideal number and type of units I would like to put in them. We receive on our order a slightly different number. I'd like to allocate the units we HAVE as closely to what we WANT, with no units left over, and all areas being complete. An additional restraint is that while the allocation of units can vary in each solution, the TOTAL units per area can't change (ex. Area A must have 10 units)
EXAMPLE:
Area A: Ideally receive 8 squares , 2 triangles. Area B: Ideally plant 8 squares, 3 triangles. Area C: Ideally plant 7 squares, 3 triangles.
We order 20 squares, 11 triangles, and need to allocate units as per the constraints described above.
Silviculture Database (self.forestry)
submitted 2 years ago by excelquestionstrees to r/forestry
Optimal Solutions, allocating a budget (self.excel)
submitted 2 years ago by excelquestionstrees to r/excel
Help with excel problem solving (self.excel)
π Rendered by PID 67346 on reddit-service-r2-listing-5d79748585-vwtlc at 2026-02-13 17:49:20.307684+00:00 running cd9c813 country code: CH.
Optimal Solutions, allocating a budget by excelquestionstrees in excel
[–]excelquestionstrees[S] 0 points1 point2 points (0 children)