How much does your bass weigh?

[Pilgrim]

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]

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]

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]

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

[Pilgrim]

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]

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]

Good guestion

[Pilgrim]

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]

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]

I use this conversion site almost every day at work!

http://www.onlineconversion.com/

[Pilgrim]

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]

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.