Forums: Climbing Information: Gear Heads:
Gear Spreadsheet
RSS FeedRSS Feeds for Gear Heads

Premier Sponsor:

 


BlackSteve


Oct 30, 2013, 5:38 PM
Post #1 of 22 (17178 views)
Shortcut

Registered: May 9, 2013
Posts: 4

Gear Spreadsheet
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

A couple of my friends and I have been working on a little spreadsheet to organize climbing gear. Let me know what you think or if you'd like to contribute Smile

https://docs.google.com/...id=0&output=html


lena_chita
Moderator

Oct 30, 2013, 6:39 PM
Post #2 of 22 (17163 views)
Shortcut

Registered: Jun 27, 2006
Posts: 6087

Re: [BlackSteve] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

What is the purpose of this spreadsheet?

This is the gear you and your friends have? The gear you want to have? ALL possible gear for sale at MEC?

I am confused about what contributions you expect from people...


BlackSteve


Oct 30, 2013, 6:45 PM
Post #3 of 22 (17154 views)
Shortcut

Registered: May 9, 2013
Posts: 4

Re: [lena_chita] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

It's simply a spreadsheet to organize gear in general. For instance you want to compare prices of shoes. You open the spreadsheet, filter out everything but the shoes. And there you go. Prices, rating, and where it is for sale. For contributions, all it would be is adding gear to the database, any gear at all. Therefore instead of needing to search multiple sites for the piece of gear you want, you have a ton of gear and gear info conveniently all in one place. I don't know, I just thought it was cool.


Partner epoch
Moderator

Oct 30, 2013, 8:12 PM
Post #4 of 22 (17124 views)
Shortcut

Registered: Apr 28, 2005
Posts: 32163

Re: [BlackSteve] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (1 rating)  
Can't Post

BlackSteve wrote:
It's simply a spreadsheet to organize gear in general. For instance you want to compare prices of shoes. You open the spreadsheet, filter out everything but the shoes. And there you go. Prices, rating, and where it is for sale. For contributions, all it would be is adding gear to the database, any gear at all. Therefore instead of needing to search multiple sites for the piece of gear you want, you have a ton of gear and gear info conveniently all in one place. I don't know, I just thought it was cool.
www.spadout.com

or, perhaps

www.google.com

At the rate that prices of goods change and the often occurrence of sales, you're better off using an aggregate search site such as google or spadout to do the heavy lifting. If you are concerned with MEC prices, use thier website and included search feature. This spreadsheet is too silly for what you are doing.

I have a spreadsheet, but it is for insurance purposes and details what gear I have down to the lot/serial number.


billcoe_


Nov 1, 2013, 3:50 PM
Post #5 of 22 (16948 views)
Shortcut

Registered: Jun 30, 2002
Posts: 4694

Re: [BlackSteve] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

Wheres the like button? LOL Steve, one of those sites had something similar where once you had entered the gear, it told you the rack weight. Changing 50 biners from this to that would have a big impact and was very interesting to overweight slugs trying to go light on gear.... like me. Wink

BlackSteve wrote:
A couple of my friends and I have been working on a little spreadsheet to organize climbing gear. Let me know what you think or if you'd like to contribute Smile

https://docs.google.com/...id=0&output=html


BlackSteve


Nov 1, 2013, 4:37 PM
Post #6 of 22 (16931 views)
Shortcut

Registered: May 9, 2013
Posts: 4

Re: [billcoe_] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

That sounds really, really cool. I was actually thinking about making a rack weight calculator. Maybe make it available for Android phones? Would anyone be interested in something like this?


Partner epoch
Moderator

Nov 1, 2013, 5:14 PM
Post #7 of 22 (16922 views)
Shortcut

Registered: Apr 28, 2005
Posts: 32163

Re: [BlackSteve] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (1 rating)  
Can't Post

BlackSteve wrote:
That sounds really, really cool. I was actually thinking about making a rack weight calculator. Maybe make it available for Android phones? Would anyone be interested in something like this?

Sorry to continually burst your bubble, man...

www.weighmygear.com


Partner epoch
Moderator

Nov 1, 2013, 5:19 PM
Post #8 of 22 (16920 views)
Shortcut

Registered: Apr 28, 2005
Posts: 32163

Re: [epoch] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

epoch wrote:
BlackSteve wrote:
That sounds really, really cool. I was actually thinking about making a rack weight calculator. Maybe make it available for Android phones? Would anyone be interested in something like this?

Sorry to continually burst your bubble, man...

www.weighmygear.com

Took me less than 1 minute on Google.


BlackSteve


Nov 1, 2013, 5:23 PM
Post #9 of 22 (16916 views)
Shortcut

Registered: May 9, 2013
Posts: 4

Re: [epoch] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

Awwww c'mon guys :( hahaha


acorneau


Nov 1, 2013, 8:52 PM
Post #10 of 22 (16879 views)
Shortcut

Registered: Feb 6, 2008
Posts: 2889

Re: [BlackSteve] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (1 rating)  
Can't Post

BlackSteve wrote:
That sounds really, really cool. I was actually thinking about making a rack weight calculator. Maybe make it available for Android phones? Would anyone be interested in something like this?


1. Place rack on scale.
2. Read weight.

Easy peasy.

Wink


marc801


Nov 2, 2013, 3:27 AM
Post #11 of 22 (16848 views)
Shortcut

Registered: Aug 1, 2005
Posts: 2806

Re: [acorneau] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

acorneau wrote:
BlackSteve wrote:
That sounds really, really cool. I was actually thinking about making a rack weight calculator. Maybe make it available for Android phones? Would anyone be interested in something like this?


1. Place rack on scale.
2. Read weight.

Easy peasy.
Yep. Took me about 10 seconds. Why on earth would I want an app to do this?


jt512


Nov 2, 2013, 6:57 AM
Post #12 of 22 (16832 views)
Shortcut

Registered: Apr 12, 2001
Posts: 21904

Re: [epoch] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

epoch wrote:
BlackSteve wrote:
That sounds really, really cool. I was actually thinking about making a rack weight calculator. Maybe make it available for Android phones? Would anyone be interested in something like this?

Sorry to continually burst your bubble, man...

www.weighmygear.com

Yes, someone else has already thought of this is idea, which is about as important to weighing gear as those machines that charger you a quarter are for taking your pulse.

On the other hand, apparently, there are people who actually put quarters into those pulse-taking machines.


(This post was edited by jt512 on Nov 2, 2013, 7:03 AM)


lena_chita
Moderator

Nov 4, 2013, 12:30 PM
Post #13 of 22 (16683 views)
Shortcut

Registered: Jun 27, 2006
Posts: 6087

Re: [marc801] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (1 rating)  
Can't Post

marc801 wrote:
acorneau wrote:
BlackSteve wrote:
That sounds really, really cool. I was actually thinking about making a rack weight calculator. Maybe make it available for Android phones? Would anyone be interested in something like this?


1. Place rack on scale.
2. Read weight.

Easy peasy.
Yep. Took me about 10 seconds. Why on earth would I want an app to do this?


You are dating yourself! There is an app for everything. And someone is out there using it.

I think a spreadsheet of the gear you own with price/date of purchase is a good idea for insurance purposes, especially if you climb (or live) in places where car break-ins are common.


marc801


Nov 4, 2013, 4:05 PM
Post #14 of 22 (16643 views)
Shortcut

Registered: Aug 1, 2005
Posts: 2806

Re: [lena_chita] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

lena_chita wrote:
I think a spreadsheet of the gear you own with price/date of purchase is a good idea for insurance purposes, especially if you climb (or live) in places where car break-ins are common.
That is the one good idea/use for that spreadsheet. Too bad the OP didn't mention that.


dac33


Dec 20, 2013, 9:57 AM
Post #15 of 22 (16079 views)
Shortcut

Registered: Feb 9, 2012
Posts: 44

Re: [BlackSteve] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

BlackSteve wrote:
A couple of my friends and I have been working on a little spreadsheet to organize climbing gear. Let me know what you think or if you'd like to contribute Smile

https://docs.google.com/...id=0&output=html

Hi,
one really good thing to do with a spreadsheet of your gear is to put the weight of everything in.

We did this for our book on multi pitch climbing http://www.amazon.com/...oley+and+kirkpatrick

just to see what it might tell us. The results were surprising (at least to us). For example:

• A slightly older trad rack might weigh in at over 4.3 kg, a state-of-the art one 2.7 kg.
• This difference is greater than an additional set of wires AND cams, i.e. you could take two sets and still be carrying less just by buying lighter gear.
• The snapgates weigh more than the cams and three times as much as the helmet.
• Lightweight versions of most things, from harnesses to cams commonly weigh 20 to 50% less.

We found equally interesting things about the weight of ropes.


marc801


Dec 20, 2013, 5:30 PM
Post #16 of 22 (16031 views)
Shortcut

Registered: Aug 1, 2005
Posts: 2806

Re: [dac33] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

dac33 wrote:
Hi,
one really good thing to do with a spreadsheet of your gear is to put the weight of everything in.

We did this for our book on multi pitch climbing http://www.amazon.com/...oley+and+kirkpatrick

just to see what it might tell us. The results were surprising (at least to us). For example:

• A slightly older trad rack might weigh in at over 4.3 kg, a state-of-the art one 2.7 kg.
• This difference is greater than an additional set of wires AND cams, i.e. you could take two sets and still be carrying less just by buying lighter gear.
• The snapgates weigh more than the cams and three times as much as the helmet.
• Lightweight versions of most things, from harnesses to cams commonly weigh 20 to 50% less.

We found equally interesting things about the weight of ropes.

"Snapgates"?
Yeah, I know what you mean, but I don't think I've ever heard this term for biners.


funk


Dec 20, 2013, 5:34 PM
Post #17 of 22 (16026 views)
Shortcut

Registered: Nov 9, 2008
Posts: 120

Re: [BlackSteve] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

could have you picked any worse crash pads? maybe throw in a Mad Rock pad while you're at it.


dac33


Dec 20, 2013, 5:37 PM
Post #18 of 22 (16026 views)
Shortcut

Registered: Feb 9, 2012
Posts: 44

Re: [marc801] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

 
In reply to:
"Snapgates"?
Yeah, I know what you mean, but I don't think I've ever heard this term for biners.

Sorry about that, we are both British.
We will get someone from North America to read it before the next edition.

If you have the time to read some more stuff and you can spot any incomprehensible terms on the supporting web pages http://people.bath.ac.uk/dac33/high/
please let me know. Thanks.


sbaclimber


Dec 22, 2013, 3:16 PM
Post #19 of 22 (15924 views)
Shortcut

Registered: Jan 22, 2004
Posts: 3118

Re: [dac33] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

dac33 wrote:
In reply to:
"Snapgates"?
Yeah, I know what you mean, but I don't think I've ever heard this term for biners.

Sorry about that, we are both British.
I thought the brits said "krabs"....


dac33


Dec 22, 2013, 6:44 PM
Post #20 of 22 (15901 views)
Shortcut

Registered: Feb 9, 2012
Posts: 44

Re: [sbaclimber] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

 
In reply to:
"Snapgates"?

I thought the brits said "krabs"....

Yeh, we say that too.


billcoe_


Feb 27, 2014, 6:42 PM
Post #21 of 22 (15082 views)
Shortcut

Registered: Jun 30, 2002
Posts: 4694

Re: [dac33] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

I think there is some real good info and in a short peruse I learned a lot, but note that I find it interesting that your site spends a lot of time discussing the use of the "American Death Triangle" which is in widespread use and as far as I know, never failed on anyone. So a quick sentence should have sufficed. Whereas you routinely find rapping off a single skinny sling (rope directly on sling, no biner) fine, which has lead to multiple failures and fatality's. I'd drill that into folks that is something reserved for remote, new routes and emergencies, and not to do it.

Link to e-book.

http://www.amazon.com/...oley+and+kirkpatrick

Thanks for sharing that.


dac33


Feb 28, 2014, 8:42 AM
Post #22 of 22 (14996 views)
Shortcut

Registered: Feb 9, 2012
Posts: 44

Re: [billcoe_] Gear Spreadsheet [In reply to]
Report this Post
Average: avg_1 avg_2 avg_3 avg_4 avg_5 (0 ratings)  
Can't Post

Thanks for that.
Yep, I went over the top on the death triangle. Sorry. I think I was on a long train journey. I'll try and add something on single old slings on the webpages when I can find a photo, although I do say something about it in the text of the main book.

PS. There is now a much easier to remember URL for it: http://www.multipitchclimbing.com/

Any more corrections and comments welcome. I kind of see it as a community thing.


Forums : Climbing Information : Gear Heads

 


Search for (options)

Log In:

Username:
Password: Remember me:

Go Register
Go Lost Password?



Follow us on Twiter Become a Fan on Facebook