Member of the Month

PartyBullshiit
March, 2024

Online

Welcome to the Newschoolers forums! You may read the forums as a guest, however you must be a registered member to post. Register to become a member today!

Ski Finder Excel Sheet

profile picture
POW-WOW
Posts: 1464 - Karma: 46
I made a thread on this a while back and now I've decided I'm going to try it. For those who don't know about it this is what Im going to do:
Using Excel I'm going to make a spreadsheet as many skis from different companies as I can make. It will have a section for dimensions (tip/underfoot/tails), a section for stiffness, length, and whatever else would be helpful. If you would like to help post here or send me a message, I might create a cult for it.
If you arent planning on helping I would still really like to know if you would want this though, so I'm not wasting a bunch of my time.
+K for bumps and feedback
Apr 1 2012 5:36PM
0 0
profile picture
~~~~~~~~
Posts: 2345 - Karma: 2,104
ski finder database? quite the endeavor hope some people can pitch in.
Apr 1 2012 5:39PM
0 0
profile picture
BrewskiJr
Posts: 5738 - Karma: 1,478
It might be cool if NS would end up putting it somewhere on their site. Maybe sticky it in the gear talk section. I feel like a few months ago someone was trying to do the same thing you were doing. Hopefully someone remembers.
Apr 1 2012 5:40PM
0 0
profile picture
bobs
Posts: 4801 - Karma: 869
this could be good, its getting hard to keep up with all the pow skis nowadays
Apr 1 2012 5:58PM
0 0
profile picture
Mag
Posts: 8155 - Karma: 14,809
I'd be down to help if you need any, love the idea
Apr 1 2012 6:02PM
0 0
profile picture
VD.
Posts: 4054 - Karma: 4,564
pm'd
Apr 2 2012 6:25AM
0 0
profile picture
Galaga
Posts: 409 - Karma: 15
This would be great
Apr 2 2012 10:08AM
0 0
profile picture
1337
Posts: 31038 - Karma: 29,003
use google documents so it can be read and even edited by different people!
Apr 2 2012 10:10AM
0 0
profile picture
Galaga
Posts: 409 - Karma: 15
I feel like that would get out of control and that OP should just control the spreadsheet IMO
Apr 2 2012 10:18AM
0 0
profile picture
1337
Posts: 31038 - Karma: 29,003
you can chose who can edit it I believe and set permissions, etc. So OP would have control, but he could let someone add to it if he felt confident with them
Apr 2 2012 10:21AM
0 0
profile picture
Barefootin_Fiend
Posts: 7618 - Karma: 4,727
Excel is my bitch. if you need help writing formulas/macros/etc., let me know.
Apr 2 2012 10:56AM
0 0
profile picture
Crankset
Posts: 1176 - Karma: 497
that's a great idea. have a different tab for each year's model.

I like the idea of a google document for everyone to add to. if this got big, ski companies themselves would unquestionably have a marketing rep upload the information themselves.

Open source is the future.
Apr 2 2012 11:35AM
0 0
profile picture
POW-WOW
Posts: 1464 - Karma: 46
I don't know much about Google Documents, but I'll try to look into that. I'm used to be good with excel but if Google is a lot better I would use it.
I think I will assign people each a different brand to get all of their ski info or maybe just like 5 skis a person.

Not like this will change the fact that I'm doing this, but could we get a sponsorship from the companies or something like that? That would be sweet.
Apr 2 2012 12:05PM
0 0
profile picture
Barefootin_Fiend
Posts: 7618 - Karma: 4,727
allowing anyone to edit a spreadsheet like this is a terrible idea if you want it to actually work. if you want this sheet to have any cool functionality like lookup features, etc., then you're going to want to protect it. otherwise someone will fuck up the formulas and it won't work at all. i see it happen all of the time. not with a ski spreadsheet, of course, but with other excel files that i work with on a daily basis.

i'm picturing something where you could open the spreadsheet and choose a set of variables such as pow ski, park ski, etc., flex pattern, enter your height, weight, price range, and the spreadsheet will pull up a list of skis that fit those parameters. this would have to be protected though because if someone went in and overwrote a formula, then the entire sheet becomes useless. guaranteed to happen. it's just too complex and too many people don't know dick about excel.

Apr 2 2012 12:20PM
0 0
profile picture
oil.
Posts: 2255 - Karma: 1,254
i said ill gladly help in the old thread, PM me for a job and ill get it done!
Apr 2 2012 12:28PM
0 0
profile picture
ABinThe603
Posts: 529 - Karma: 126
it would be awesome if you could then sort the categories high/low with the dimensions, prices, etc, and also set ranges, but I dont think you can do that in excel. Also, you should put in MSRP. +k for awesome idea
Apr 2 2012 7:42PM
0 0
profile picture
Barefootin_Fiend
Posts: 7618 - Karma: 4,727
this is totally possible. excel has some crazy capabilities if you know what youre doing. i dont have time to gather all of the data, but if someone can assemble the data, then i can design a spreadsheet that will basically do anything you want it to.
Apr 2 2012 8:38PM
0 0
profile picture
ABinThe603
Posts: 529 - Karma: 126
boss.
Apr 2 2012 8:52PM
0 0
All times are Eastern (-4)