Tarck Approved database

283 posts / 0 new
Last post
Endpoint
Endpoint's picture
(Reply to #51)

ergott wrote:
I separated brakes (wet) into mtb and road. Shouldn't they (and mechanical) be separated that way?

Are Sram calipers interchangeable with levers (road and mtb) like Shimano?

I would assume so.

Elixer levers work with wet road rim brakes which are interchangeable with wet road dicks. Given the caliper design is basically the same (excluding the 4 pot maybe?) I have a hunch they are mix and match.

Sat, 02/25/2017 - 21:28
Tail Hook Lengthener
Tail Hook Lengthener's picture

In a time before multiple companies producing fleets of SSCX bikes, the Cross Check was a cheap and viable option.

Sneaky Viking wrote:
when you look back at your life sometimes you see a set of hands on your keyboard and a set of paws, but sometimes there's only a set of paws and that's when Tarckbear was typing for you.

Sun, 02/26/2017 - 14:42
akasnowmaaan
akasnowmaaan's picture

Are we here to debate the merits of the crosscheck, or fill in data?
Anyway, I hope someone appreciates that entry now.

Should have said it was just a cross check with different geometry. - Todd

Sun, 02/26/2017 - 14:50
liquify
liquify's picture

<3

Sun, 02/26/2017 - 16:17
Rusty Piton
Rusty Piton's picture

Lol well done snowman.

emor wrote:
Bicycle commuting is the worst way to get anywhere except for all the other ways.

Sun, 02/26/2017 - 18:54
NOVELTYNAME
NOVELTYNAME's picture

on all new pages

"Folks want options!"

Mon, 02/27/2017 - 12:12
yummygooey

Has anyone tried this handlebar?

https://www.ahearnecycles.com/shop/ahearnemap-handlebar

Looking for a replacement to my Velo Orange Postino bars. The other bar I'm interested in is the SimWorks GETAROUND but I think it's too wide. The Ahearne looks good to me because it comes in 610mm (a little wider than the Postinos) and has some rise.

Mon, 02/27/2017 - 12:59
Falkor
Falkor's picture

The best thing about the database is that I can peruse at work without having to alt+tab every time a coworker walks by. I work in excel all day anyhow and regularly use red/yellow/green conditional formatting for deadline/threshold tracking.

Mon, 02/27/2017 - 15:29
imoscardotcom
imoscardotcom's picture

^ was thinking the same thing last week.

looks like I'm pluggin' away at something important to everyone that walks by my desk, little do they know i'm ditherin' the day away.

Mon, 02/27/2017 - 15:56
b-roll
b-roll's picture
(Reply to #60)

akasnowmaaan wrote:
Are we here to debate the merits of the crosscheck, or fill in data?
Anyway, I hope someone appreciates that entry now.

Nicely done. I would like to see other such Really Important Issues of Our Time handled in such an even handed way.

I recall seeing a guy in the Seattle CX scene back in 2008 or so with two identically set up Cross Checks as A and B bikes.

I personally raced CX exclusively on a SS CC until two years ago. Then I bought the oddball Cinelli with the 120mm rear spacing and I've never been happier.

I guess the short version is that I have no taste. Carry on...

"You know it's dumb. I know it's dumb. But fuck it, I still love it."

Mon, 02/27/2017 - 20:33
Larry Winget
Larry Winget's picture

Added a bunch of shit to the "off the bike" page. You can probably tell what's mine.

The Pitbull of Personal Development®

Tue, 02/28/2017 - 02:47
Rentable Faxmachine
Rentable Faxmachine's picture

Does anyone care about chain lube/s? If so, I'll add some info.

Tue, 02/28/2017 - 10:45
euclid
euclid's picture

I wanna make a "bike lube or sex lube?" internet quiz sometime.

Tue, 02/28/2017 - 11:45
Falkor
Falkor's picture
(Reply to #64)

Rentable Faxmachine wrote:
Does anyone care about chain lube/s? If so, I'll add some info.

I'm interested. Need to order a new bottle soon. It's really hard to judge which types are more effective vs. I just rode through more grit that week.

Tue, 02/28/2017 - 13:26
Andrew_Squirrel
Andrew_Squirrel's picture
(Reply to #65)

yummygooey wrote:
Has anyone tried this handlebar?

https://www.ahearnecycles.com/shop/ahearnemap-handlebar

Looking for a replacement to my Velo Orange Postino bars. The other bar I'm interested in is the SimWorks GETAROUND but I think it's too wide. The Ahearne looks good to me because it comes in 610mm (a little wider than the Postinos) and has some rise.

I have on my cycletruck, you can feel them up if you want

Tue, 02/28/2017 - 13:53
Rentable Faxmachine
Rentable Faxmachine's picture
(Reply to #66)

Falkor wrote:
Rentable Faxmachine wrote:
Does anyone care about chain lube/s? If so, I'll add some info.

I'm interested. Need to order a new bottle soon. It's really hard to judge which types are more effective vs. I just rode through more grit that week.

Done. I can add more detail if needed.

Tue, 02/28/2017 - 14:46
Rusty Piton
Rusty Piton's picture

In the vein of those MAP bars, has anyone used the FSA Metropolis?

Kinda looks like what I want for my Wolverine.

emor wrote:
Bicycle commuting is the worst way to get anywhere except for all the other ways.

Tue, 02/28/2017 - 15:52
NOVELTYNAME
NOVELTYNAME's picture
(Reply to #68)

Rusty Piton wrote:
In the vein of those MAP bars, has anyone used the FSA Metropolis?

Kinda looks like what I want for my Wolverine.

i have a brand new set im tryna get rid of

"Folks want options!"

Tue, 02/28/2017 - 16:08
Rusty Piton
Rusty Piton's picture

Oh yeah?

emor wrote:
Bicycle commuting is the worst way to get anywhere except for all the other ways.

Tue, 02/28/2017 - 22:37
emor
emor's picture

My fambike has those, they're good. The sweep is pretty spot on.

"my main life goal is to have a dirtbag camper van with a bunch of bikes on it, go camping every vacation forever" -- me

Tue, 02/28/2017 - 23:39
mdilthey
mdilthey's picture
(Reply to #71)

Fairdale makes a swept bar, too.

26/M/41t N/W

Tue, 02/28/2017 - 23:52
yummygooey
(Reply to #72)

Andrew_Squirrel wrote:
yummygooey wrote:
Has anyone tried this handlebar?

https://www.ahearnecycles.com/shop/ahearnemap-handlebar

Looking for a replacement to my Velo Orange Postino bars. The other bar I'm interested in is the SimWorks GETAROUND but I think it's too wide. The Ahearne looks good to me because it comes in 610mm (a little wider than the Postinos) and has some rise.

I have on my cycletruck, you can feel them up if you want

yasss

Wed, 03/01/2017 - 00:17
NOVELTYNAME
NOVELTYNAME's picture
(Reply to #73)

Rusty Piton wrote:
Oh yeah?

Yes
I will be near them on sunday

"Folks want options!"

Wed, 03/01/2017 - 00:21
Rusty Piton
Rusty Piton's picture

How do I get them near me, Mig?

emor wrote:
Bicycle commuting is the worst way to get anywhere except for all the other ways.

Wed, 03/01/2017 - 09:18
jr.early
jr.early's picture
(Reply to #75)

Rusty Piton wrote:
In the vein of those MAP bars, has anyone used the FSA Metropolis?

Kinda looks like what I want for my Wolverine.

Wife bike has these and she loves them. She did 16 days in Japan on them as her first tour and never had numb hands or any discomfort. Also the shop owner bought them from swears by them.

Wed, 03/01/2017 - 10:05
NOVELTYNAME
NOVELTYNAME's picture
(Reply to #76)

Rusty Piton wrote:
How do I get them near me, Mig?

$35+ship? They're black.

"Folks want options!"

Wed, 03/01/2017 - 10:13
Rusty Piton
Rusty Piton's picture

Deal.

emor wrote:
Bicycle commuting is the worst way to get anywhere except for all the other ways.

Wed, 03/01/2017 - 10:46
Tail Hook Lengthener
Tail Hook Lengthener's picture

I love watching this turn into a bicycle Talmud, with all the arguments in the margins.

Sneaky Viking wrote:
when you look back at your life sometimes you see a set of hands on your keyboard and a set of paws, but sometimes there's only a set of paws and that's when Tarckbear was typing for you.

Fri, 03/03/2017 - 00:07
heavymetal
heavymetal's picture
(Reply to #79)

Wintage Townie wrote:
I love watching this turn into a bicycle Talmud, with all the arguments in the margins.

I understand this because I read a lot of Chaim Potok in my early 20s. To a kid brought up as a Pentecostal chrizzo it was fascinating.

Fri, 03/03/2017 - 02:24
jawn doe
jawn doe's picture
(Reply to #80)

jr.early wrote:
Rusty Piton wrote:
In the vein of those MAP bars, has anyone used the FSA Metropolis?

Kinda looks like what I want for my Wolverine.

Wife bike has these and she loves them. She did 16 days in Japan on them as her first tour and never had numb hands or any discomfort. Also the shop owner bought them from swears by them.

i liked the origin 8 space bar more than these guys. salsa bend 2 is cool if you're looking for less than full townie sweep. i ride them on all my mtbs cuz shitty wrists and it helps a lot.

Fri, 03/03/2017 - 08:39
Blakey
Blakey's picture

Did a big rearrange on a bunch of tabs (cyan labels), added filters, conditional formatting for TarckApproval®, moved/added some fields and included a little input validation. marginalia arguments preserved

Sat, 03/04/2017 - 01:50
heavymetal
heavymetal's picture

#informationtarckitecture

Sat, 03/04/2017 - 02:42
akasnowmaaan
akasnowmaaan's picture
(Reply to #83)

Blakey wrote:
Did a big rearrange on a bunch of tabs (cyan labels), added filters, conditional formatting for TarckApproval®, moved/added some fields and included a little input validation. marginalia arguments preserved

Are you the one that added three columns of filtering fuckery that make it overwhelming to use now?

Just checking, because I just lost all desire to refer to it.

Should have said it was just a cross check with different geometry. - Todd

Sat, 03/04/2017 - 04:19
Shortpants
Shortpants's picture
(Reply to #84)

Blakey wrote:
Did a big rearrange on a bunch of tabs (cyan labels), added filters, conditional formatting for TarckApproval®, moved/added some fields and included a little input validation. marginalia arguments preserved

oh man I love it. btw how do you put the sort value thingy in a cell instead of using the column header?

also how do you make it so a cell can only be Y/N/Meh?

fuck I use spreadsheets all the time and I have no idea what I'm doing.

Sat, 03/04/2017 - 14:54
curiousincident
curiousincident's picture
(Reply to #85)

jawn doe wrote:
jr.early wrote:
Rusty Piton wrote:
In the vein of those MAP bars, has anyone used the FSA Metropolis?

Kinda looks like what I want for my Wolverine.

Wife bike has these and she loves them. She did 16 days in Japan on them as her first tour and never had numb hands or any discomfort. Also the shop owner bought them from swears by them.

i liked the origin 8 space bar more than these guys. salsa bend 2 is cool if you're looking for less than full townie sweep. i ride them on all my mtbs cuz shitty wrists and it helps a lot.

i really love the metropolis bars on my around town bike, perfect amount of sweep for me

Sat, 03/04/2017 - 17:18
Blakey
Blakey's picture
(Reply to #86)

akasnowmaaan wrote:
Are you the one that added three columns of filtering fuckery that make it overwhelming to use now?

Just checking, because I just lost all desire to refer to it.

I don't want to make it shitty to use, it's easy for me to go and reverse the changes if tarck doesn't like it. My intent was only to break out manufacturer from model and include a little more relevant info about the product so that as the TBD grows it could be filtered down quickly (as I understand it, each viewer of the sheet in gdocs gets their own unique filter view, so if anonymous moose filters tyres down to only show tubeless 29er, other users will see the unfiltered view or their own particular filter selection) to show all the items that matched the desired use and if they're good or bad. People can enter new items without filling in all the fields if they like, blanks aren't forced to be filled, and you can scroll through all the items just like before without using the filter.

Straws wrote:
oh man I love it. btw how do you put the sort value thingy in a cell instead of using the column header?

also how do you make it so a cell can only be Y/N/Meh?

Sort value = filter? Select the table range (eg b4:h100) and then click the filter icon (or if the icon doesn't show on your toolbar, go to data, then filter). Filter can then be used to sort the entire range (so it has to encompass all columns) or only show rows that match the selected options/ranges in the filtered columns. When a new row is added the autofilter range is extended to include it automatically, same if a column is inserted in the middle somewhere, but not if one is tacked on the extreme right end.

Input restriction: Select the range you want to restrict inputs, go to data, then data validation. Select your options in the dialogue box (for this case, I used select from a range, show drop down and reject invalid entries), for a range you then have to select the range of allowed inputs (they're kept on the input validation sheet at the very end tab, allowed input range can be extended/modified as required). You can start typing and it'll autocomplete, or hit the dropdown and select one. Then those cells also have conditional formatting (colour fill) on them matched to the allowed inputs

Sun, 03/05/2017 - 00:26
Shortpants
Shortpants's picture

Awesome. I don't know how exactly I'll use those things as I don't have a need for them in my normal work but always good to learn. I should take a class or read a book on excel. I'm entirely self taught from just fiddling with things.

Sun, 03/05/2017 - 13:14
mdilthey
mdilthey's picture
(Reply to #88)

Straws wrote:
Awesome. I don't know how exactly I'll use those things as I don't have a need for them in my normal work but always good to learn. I should take a class or read a book on excel. I'm entirely self taught from just fiddling with things.

I can't imagine how much better my career would be going if I did this.

26/M/41t N/W

Mon, 03/06/2017 - 10:25
imoscardotcom
imoscardotcom's picture

yeah...I don't know how to edit or add stuff anymore and just feel like I'm gonna fuck things up.

looks like I'm expanding my doc'n skills this week.

Mon, 03/06/2017 - 10:27
euclid
euclid's picture

Just go for it and let the spreadsheet nerds fix your mistakes.

Mon, 03/06/2017 - 15:04
akasnowmaaan
akasnowmaaan's picture
(Reply to #91)

Blakey wrote:
I don't want to make it shitty to use, it's easy for me to go and reverse the changes if tarck doesn't like it.

I admit, I kinda lose it quickly with stuff like this. Don't take my low frustration tolerance with too much weight. It's what makes me a good designer.

Thanks for the docs. I'll dig in, maybe I can figure it out without too much effort.

Should have said it was just a cross check with different geometry. - Todd

Mon, 03/06/2017 - 15:27
eric_ssucks
eric_ssucks's picture

loving the filters. I've already used them to shit up the paul components entries.

Mon, 03/06/2017 - 16:54
Blakey
Blakey's picture
(Reply to #93)

eric_ssucks wrote:
loving the filters. I've already used them to shit up the paul components entries.

And from this I see my info was wrong about every user getting unique filter views, as I can see brakes filtered down to Paul. I'll dig into that a little more later and see if there's a default 'on load' view.

akasnowmaaan wrote:
I admit, I kinda lose it quickly with stuff like this. Don't take my low frustration tolerance with too much weight. It's what makes me a good designer.

Thanks for the docs. I'll dig in, maybe I can figure it out without too much effort.

I was actually hoping your designer/ux chops might provide some tips on how to make it easier/friendlier to use. Fire away with any gripes and perhaps the approach to entry/sorting/display could be improved.

imoscardotcom wrote:
yeah...I don't know how to edit or add stuff anymore and just feel like I'm gonna fuck things up.

Naw, just edit/add stuff, and as euclid says:

euclid wrote:
Just go for it and let the spreadsheet nerds fix your mistakes.

But really, it's not too much different to add than before, you might just be selecting a drop down for a category as well as typing in some details in extra columns. And gdocs has a great revision history feature, so even if someone totally fucks something up (barring ctrl-a, delete, that's unlikely) it can be rolled back in time to before the edit easily if a few undo steps don't fix it.

====
To add new entries to the tarckDB sheets with autofiltered tables, it can be done two ways:
* just enter data into the row immediately under the last entry of the table under the green line, then the table will auto extend to include that entry
* in the middle of the table, insert a row (alt-i, r. or Insert, Row above/Row below) and then type into that row
* For validated/dropdown cells, either start typing and select as the matching options appear, or click the dropdown and select from all the options. Or leave it blank and let someone else fix it later.

If the table doesn't seem to be showing all the entries, look at the little icons in the header row. If one of them looks like a solid funnel, instead of an inverted triangle made of 3 horizontal lines, there's a filter on that column that you can turn off (click the icon, click select all, click OK).

Likewise, to filter, click the inverted triangle icon, and then you can:
*sort a->z / z->a
* filter by condition (blanks/nonblanks/text contains/value in a range between x & y...)
* filter by search or manual selection

Mon, 03/06/2017 - 18:19
Recumbentist
Recumbentist's picture

How do you prevent non-Tarckers from editing the spreadsheet? What's to prevent some malicious jackass from just deleting it all?

Just curious.

Tue, 03/07/2017 - 23:27
mdilthey
mdilthey's picture
(Reply to #95)

Recumbentist wrote:
How do you prevent non-Tarckers from editing the spreadsheet? What's to prevent some malicious jackass from just deleting it all?

Just curious.

Nothing? I pay for the 100 gig Google Drive already anyways and I have a version saved in there in case it gets deleted so I can be the hero of Tarck. Anyone can do that.

26/M/41t N/W

Tue, 03/07/2017 - 23:38
Blakey
Blakey's picture
(Reply to #96)

Recumbentist wrote:
How do you prevent non-Tarckers from editing the spreadsheet? What's to prevent some malicious jackass from just deleting it all?

Just curious.

Yeah, sooner or later the link will get out in the wild. One option is to revoke editing by all, and if you want edit privileges you have to request them from the sheet owner. The tyre width sheet is pretty well known and it doesn't appear to be overly full of bad data.

If someone does start maliciously editing entries, the revision history ought to allow a roll back to a good version, unless they make a bad edit every day over time.

Do we need a tab for lightweight 'bent parts?

Wed, 03/08/2017 - 00:12
Tail Hook Lengthener
Tail Hook Lengthener's picture

It's already in the wild.

No one cares, guys.

Sneaky Viking wrote:
when you look back at your life sometimes you see a set of hands on your keyboard and a set of paws, but sometimes there's only a set of paws and that's when Tarckbear was typing for you.

Wed, 03/08/2017 - 00:36
eric_ssucks
eric_ssucks's picture
(Reply to #98)

Wintage Townie wrote:
It's already in the wild.

No one cares, guys.

Wed, 03/08/2017 - 00:57
kmcdon
kmcdon's picture

who leaked it
i want answers
was it russia?

Wed, 03/08/2017 - 01:22
Tail Hook Lengthener
Tail Hook Lengthener's picture

Assange

Sneaky Viking wrote:
when you look back at your life sometimes you see a set of hands on your keyboard and a set of paws, but sometimes there's only a set of paws and that's when Tarckbear was typing for you.

Wed, 03/08/2017 - 02:37

Pages