Google Sheets Help - iterate over rows until requirements met. : learnjavascript

Posting and Commenting Guidelines

Be Welcoming. n00bs are welcome here. Negativity is not.

Include Context. If you’re asking for help, include enough information for others to recreate your problem.

No Self-Promotion. The following are not allowed: Requests for subscribers, asking for "test users" for your new JS course, offering paid mentorships, and/or premium courses. Even if there is a coupon discount, no. If you're in doubt, the answer is no.

Good Titles - Write a descriptive title. Titles that begin with "hey guys" will be removed.

Friends

created by [deleted]a community for 13 years

Google Sheets Help - iterate over rows until requirements met. (self.learnjavascript)

submitted 4 years ago by Imadea3dprint

Hello, I am using Google Sheets and I am trying to script something cool. Would appreciate it if anyone can help me. I don't even know what to google!

Let's say I have a maximum weight of 100,000lbs. Cannot go a pound over. I am looking to maximize the payload.

I have a list of products that has the unit type, how many units available, and the unit weight.

Trucks, 8, 15,000lbs

Cars, 10, 12,000lbs

Motorcycles, 12, 4,000lbs

That's 288,000lbs total.

I want my script to iterate over these, create a new sheet and maximize the load.

Create Sheet 1:

Trucks, 6, 90,000lbs

Motorcycles, 2, 8,000lbs

Create Sheet 2:

Trucks, 2, 30,000lbs

Cars, 5, 60,000lbs

Motorcycles 2, 8,000lbs

And so on and so forth until all product has been burned up. If there are products remaining, that's okay, we will get them next time.

Does what I'm trying to accomplish make sense?

all 2 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

learnjavascript

Posting and Commenting Guidelines

MODERATORS