Create a auto fill table with unlimited length

[smahler]

I am trying to create a table that adds a fixed number to other number based on a final goal and return the total number of items need to complete a task.

EX: I have a box that holds 216 items, I have an order for 10,000 items. I need a chart to track the number of boxes complete. The 10,000 items changes constantly but the boxes always holds 216 items.


I have attached a spreadsheet of the goal. I need it to be dynamic and change in length to any final number.

[ben_hensel]

lemme see if I get this.

You've got the following variables:
1) number of units in order, n
2) units per box, b

then you need to figure out how many boxes you need to ship to fill the order (call it x), right?

Isn't that just primary-school arithmatic?
u = b * x
x = u/b

for example,
x = 10,000 / 216 = 46.296

and probably round up so you ship an integer number of boxes where the last one is a partial.
x = 47

partial box = 10,000 - 46 * 216 = 64 units

So what is it you're charting? Progress per box or something? I feel like I'm missing something.

[smahler]

Yes progress per box. I need a chart that can change size depending on the total boxes. It also needs to show the number of boxes.

1=216
2=432

So on. Right now I have by hand but it is a large spreadsheet. It takes a long time to get not very far on creating. Just looking for a way to create a chart that plugs and plays with only one number to enter. Yes rounding up is also necessary to ensure correct counts. EX: 47 boxes hold 10152 which is what we ship. No partial boxes.

[ben_hensel]

So what is it you need to chart, anyway?

Well, at any rate, see attached. It can handle order sizes up to 108,000 items. If you want more, just pull the formulas in A501:D501 down farther.

[smahler]

I do Hunger relief and we have volunteer package food. We have to track the boxes on a pallet.

Thanks for your help.

[smahler]

This works great. I am trying to make more the one column fit on a page and only generate what I need still, is that possible? I have included the modifications I made.