How much does your bass weigh?

Pilgrim · August 11, 2013, 11:40:17 AM

Friends, I've had a thread running on TalkBass for a few years in which I've been compiling reports of the weights of various basses. Just in case anyone here is interested in that info, I'm attaching the last spreadsheet update, finished just a few minutes ago. There are 587 entries.

The original thread can be found at http://www.talkbass.com/forum/f8/time-tell-truth-how-much-does-your-bass-weigh-409213/

tore00 · August 11, 2013, 11:56:35 AM

Very nice job. If you are going to go ahead I can send the weights of my basses when being back from my vacation. What about adding the weight in kg for us on the other side of the ocean?

Pilgrim · August 11, 2013, 01:06:51 PM

I'll be glad to add them to the list for the next update I do, which at this point will be at least 3-6 months away.

I don't have the time to convert more than 500 bass weights to KG, sorry. If you'd like to do the honors, feel free to download the spreadsheet and do so. All but about a half-dozen of the original posts were in US weight, and I have rounded in some cases, so the conversion would add a slight increase in rounding error.

I think it would be much easier for an individual user to use an online conversion tool to run the weights of the instruments they are interested in.

tore00 · August 11, 2013, 01:08:36 PM

I promise that I will do. Many thanks for your work

Pilgrim · August 11, 2013, 01:26:07 PM

It would be really easy to just use the column to the right of the pounds/ounces to add another weight. But as I say, it's going to take some work!

PS: thanks, Dave. I wasn't sure which forum to place this in.

Aussie Mark · August 11, 2013, 05:20:32 PM

Quote from: Pilgrim on August 11, 2013, 01:26:07 PM
It would be really easy to just use the column to the right of the pounds/ounces to add another weight. But as I say, it's going to take some work!

I haven't seen the spreadsheet, but assuming one column has the lbs/oz number, then it's just a matter of adding one formula to convert to kgs in a new column, and then copy the formula into every row in the column. 5 minutes effort, at the most.

Edit: I just noticed the spredsheet is actually attached to the OP. One question for Pilgrim - does a "9.75" mean 9lbs and 7 and one half oz, or 9 and three quarter pounds?

jumbodbassman · August 11, 2013, 05:32:53 PM

Good guestion

Pilgrim · August 11, 2013, 09:17:23 PM

Quote from: Aussie Mark on August 11, 2013, 05:20:32 PM
I haven't seen the spreadsheet, but assuming one column has the lbs/oz number, then it's just a matter of adding one formula to convert to kgs in a new column, and then copy the formula into every row in the column. 5 minutes effort, at the most.

Edit: I just noticed the spredsheet is actually attached to the OP. One question for Pilgrim - does a "9.75" mean 9lbs and 7 and one half oz, or 9 and three quarter pounds?

Good idea...will give that formula setup a try.

The info I have collected is quite variable, but the intent is to give pounds and ounces, so 9.7 = 9 pounds 7 ounces.

Pilgrim · August 11, 2013, 09:56:29 PM

Modifying is was a moderate pain in the ass because I'm not great at formulas in Excel and for some reason I couldn't re-format the pounds/oz column, so I had to modify the cells in batches....but I got the conversion done. I won't defend any number in the KG column because I just pasted an appropriate formula in all the cells. It's attached.

Denis · August 12, 2013, 07:01:31 AM

I use this conversion site almost every day at work!

http://www.onlineconversion.com/

Pilgrim · August 12, 2013, 09:17:02 AM

I pulled the conversion factor from an online conversion tool, but then had to apply it to the spreadsheet. There were formatting problems and I was not able to re-format about 400 cells without doing them in small groups.

As I commented earlier, anyone can pull a weight out of the list and convert it. Doing it for all 500+ weights took a bit more work. But perhaps I learned something from the process.

the mojo hobo · August 12, 2013, 05:52:39 PM

If I saw this earlier I could have saved you the trouble. Using Excel's text to columns feature I separated the pounds and ounces into columns, then added a column for the calculated conversion to kilograms, using the conversion site provided by Denis I created a formula to multiply the ounces field by 0.028349523125 and add the pounds field by 0.45359237.

The formula looks like this: =I5*0.45359237+J5*0.028349523125

It took less time that typing this reply. There are some that are wrong still; is 8.75 supposed to be eight and three quarter pounds or eight pounds seven and a half ounces, certainly not eight pounds and seventy-five ounces. In those cases I removed the 5 so they might be close, or they might be light.