site banner
naraburns  nihil supernum  1yr ago (text post)   2620 thread views

Small-Scale Question Sunday for February 19, 2023

Do you have a dumb question that you're kind of embarrassed to ask in the main thread? Is there something you're just not sure about?

This is your opportunity to ask questions. No question too simple or too silly.

Culture war topics are accepted, and proposals for a better intro post are appreciated.

6
Top Bottom Old Controversial Comments
Jump in the discussion.

No email address required.

I backpack as a hobby. My packing list is a spreadsheet broken down into sections such as "worn clothing", "packed clothing", "shelter system", etc. Each line gets a function (shelter), a description (tent, tarp, bivy sack, etc), and a quantity (1x tent, 2x pairs of socks, etc). I think it would be neat to let the spreadsheet estimate a pack weight as well so I added another column for weight calculations. It also a little pie chart so I can see what sections of my pack are adding the most weight (food, clothing, whatever).

I have a second spreadsheet with the weights of various items I use but it's a little tedious to copy/paste the weight every time I want to generate a new packing list, especially since I like to swap out different pieces of kit to dial my pack in for various environments and seasons. I'm not much of a programmer so I'm wondering what the easiest way around this is. My first thought was to figure out how to create a drop-down menu for each cell with the item choices pre-loaded and have the spreadsheet call the appropriate weight. For example, for my "shelter" cell, I would create a drop-down that had my winter tent, my hammock, my bivy, etc and then the "weight" cell would auto-populated based on my selection. This seems like an inelegant solution that's going to require a lot of upkeep so I'm wondering if a simple data-base in something like OpenOffice Base or MS Access might be be more appropriate. From my amateur viewpoint it seems like the database might be more work upfront but would be less maintenance in terms of upkeep every time I add/remove a piece of kit from my stockpile. (I'm a bit of a gear-do, I'll admit). Or is it six of one, half-dozen of the other?

I think LighterPack has most of the functionality you mentioned. I'm not sure how stable it is, since it's been in beta for at least several years.

It used to be very popular for sharing load-outs in the ultra light and thru-hiking communities.Looks like the community around it is possibly not as active as a couple of years ago.

You can try it without registering, and it's open source if you really want to roll your own solution. Disclaimer, I have no affiliation with the people who run the site, and for all I know they could be stealing all your data. I've never gotten any spam from them though.

The other commenters have the right of it.

Excel/google have VLOOKUP(). You give it a sorted list and a value to compare. Then it tells you what was next to that in the table. So if you have a column for gear names and a column for weights, then you can look up weights by name.

I’ll break down an example based on @bleep. Say you have a single sheet with your packing list (column A), gear names (C), and gear weights (D).

To fill column B with packed weights, instead of putting in values, use something like

=VLOOKUP(A2, C$2:D$50, 2, false)

In space B2. Then it will look for something matching A2 in the cells from C2 to C50. It’ll take the 2nd value from whatever row it matched, and since we told it C2:D50, that means it’ll give a value from column D. Copy it to the rest of B. You can then sum and pie chart column B just as you do now.

Bleep’s example lets you move the gear info to different sheets and split up the list. That’s a matter of preference.

I think you could easily accomplish this with most spreadsheet programs with little upkeep. Have your data sheet with the list of all your items, have your "packing" sheet with drop downs, and then have a sum cell with a formula which sums added vlookups. The vlookups will use the drop down cell to find the weight in the data sheet and then add all the weights together, e.g., "=(vlookup(A1, Shelter!A1:D14, 4, false))+(vlookup(A1, Clothing!A10:D20, 4, false))" and repeat for however many categories with A being the item list and D being the weight. For quantities you could add another column with that number in between the dropdown boxes and then include that in sum formula cell.

The dropdown cells can autopopulate choices from your datasheet if you designate the list range. If you do it this way, the only "upkeep" would be to fill out the item and the weight in the appropriate range for that category of equipment and the dropdown selection should autopopulate from that sheet or list. You could use different sheets for each category and have that sheet be the designated range.

Excel (and most other sheet programs) has lookup functions (which require the lookup data be alpha sorted) and matchwhich do not. As long as your labels are the same you can pull the weights in with those.

Otherwise yes, that is the purpose of relational databases (letting you keep gear lists and combine them in different ways.

What is this place?

This website is a place for people who want to move past shady thinking and test their ideas in a court of people who don't all share the same biases. Our goal is to optimize for light, not heat; this is a group effort, and all commentators are asked to do their part.

The weekly Culture War threads host the most controversial topics and are the most visible aspect of The Motte. However, many other topics are appropriate here. We encourage people to post anything related to science, politics, or philosophy; if in doubt, post!

Check out The Vault for an archive of old quality posts. You are encouraged to crosspost these elsewhere.


Why are you called The Motte?

A motte is a stone keep on a raised earthwork common in early medieval fortifications. More pertinently, it's an element in a rhetorical move called a "Motte-and-Bailey", originally identified by philosopher Nicholas Shackel. It describes the tendency in discourse for people to move from a controversial but high value claim to a defensible but less exciting one upon any resistance to the former. He likens this to the medieval fortification, where a desirable land (the bailey) is abandoned when in danger for the more easily defended motte. In Shackel's words, "The Motte represents the defensible but undesired propositions to which one retreats when hard pressed."

On The Motte, always attempt to remain inside your defensible territory, even if you are not being pressed.


New post guidelines

If you're posting something that isn't related to the culture war, we encourage you to post a thread for it. A submission statement is highly appreciated, but isn't necessary for text posts or links to largely-text posts such as blogs or news articles; if we're unsure of the value of your post, we might remove it until you add a submission statement. A submission statement is required for non-text sources (videos, podcasts, images).

Culture war posts go in the culture war thread; all links must either include a submission statement or significant commentary. Bare links without those will be removed.

If in doubt, please post it!


Rules


Recommended Posts And Communities

Recommended Realtime Chats