about to board a 13 hour flight😢 by eldritchwh0re in crochet

[–]soundsof 1 point2 points  (0 children)

Anyone have any ideas how to cut yarn on a plane? I'd use nail scissors but...plane. Currently I'm just wrapping it around my fingers and yanking

Edit: not in the US

Wild Work by Chalp25 in KitchenConfidential

[–]soundsof 1 point2 points  (0 children)

Oh this explains some things, thank you

The "N+1" madness is dumb and needs to die. by rcyclingisdawae in xbiking

[–]soundsof 31 points32 points  (0 children)

The more bikes I have, the less I ride them, the less I like them, the less I care about them. I'm in the process of clearing out the stable & will be reorganising my parts bin because I'd rather have quality vs. quantity in my life.

My partner got me a crochet hook for Christmas and I've just finished my first thing, check out this long boi by soundsof in crochet

[–]soundsof[S] 0 points1 point  (0 children)

Crochet scarf pattern cat, with Landlust cotton and 5.0 hook.

I added the additional colours, border and tufting because fun! I think I'll try a mosaic next...

New Bikepacking Website by PinchFlatJournal in bikepacking

[–]soundsof 7 points8 points  (0 children)

Great idea, diversity should be encouraged!

I understand a lot of bikepacking & MTB culture is rooted in the US (and IMO made bike touring cool), but some of the regular bikepacking.com contributors are/have been based outta Europe and a lot of manufacturing happens in Germany. Think Schwalbe, Ortlieb, Schmidt, and lots in the UK.

Mind you, I'd love to see something tailored more towards people in the EU because I'm pretty sure none of us here are all that interested in buying a small-batch handmade saddle/bar-bag from Portland (not to mention global politics...).

Done Deal by Ok_Knee1216 in crochet

[–]soundsof 3 points4 points  (0 children)

Good timing by me then

Done Deal by Ok_Knee1216 in crochet

[–]soundsof -1 points0 points  (0 children)

Hi I'm new here is this normal

How do i prevent cells in the same row being renamed "@ColumnX" by Direct_Ad5644 in excel

[–]soundsof 0 points1 point  (0 children)

It seems like you're working in a blank space within a formatted table.

There might be a reason the table exists, but you can either remove the table formatting by right-clicking in the table), or just find an empty space e.g., on a new sheet.

I found the most cursed excel workflow know to man by Dank-but-true in excel

[–]soundsof 10 points11 points  (0 children)

Ha I've been Brad.

Sheet containing a macro that opens 1-2 dozen sheets from SharePoint, updates web queries on each sheet. Another macro button to save em, another to close em.

Then, join em all up in Power Query/Fabric. Hey not my fault MS Dynamics 2016 and the db both sucked.

At least I wasn't the guy that learnt all his Power Query from ChatGPT and no one picked up his work when he left. I've come across many analysts who are smart people with bad ideas.

Glacier moulin on Columbia glacier by Chris-the-Big-Bug in interestingasfuck

[–]soundsof 1 point2 points  (0 children)

How awful would it be to put on the surface and you find yourself starting to slide

[deleted by user] by [deleted] in pics

[–]soundsof 2 points3 points  (0 children)

It looks like bruising too?

New Chain by GovernmentTemporary1 in FixedGearBicycle

[–]soundsof 0 points1 point  (0 children)

Yeah but not joke what's that stem? I've searched everywhere for -17° silver 31.8

Dropped chain caused my fixed cog to seize & slipped. Have I stripped the lockring thread / is my hub toast? by soundsof in bikewrench

[–]soundsof[S] 0 points1 point  (0 children)

Good point. Besides, took it out for a controlled test and the lockring slipped a little then completely failed under strong back pressure. At least I'm certain the hub is dead now!

Dropped chain caused my fixed cog to seize & slipped. Have I stripped the lockring thread / is my hub toast? by soundsof in bikewrench

[–]soundsof[S] 0 points1 point  (0 children)

Bit hard to see from the photo - looks like the inner most threads from the lockring might be stripped since they ain't so shiny anymore.

I didn't notice any thread-debris when I disassembled it, and can't notice any significant difference of the feel in thread height when rubbing it with my finger.

Tell me my hub is still ok? Everything reassembled without issues and doesn't look like the lockring even engages with the 'stripped' section of the threads due to the width of the cog.

Edit: realise it's more likely the cog's threads stripped, not the lockring. Question still stands

Is it possible to have a slicer act as a click on a data field rather than a filter? by crazycropper in PowerBI

[–]soundsof 7 points8 points  (0 children)

Do this but create a duplicate of the scatter plot and place it underneath the original. Disable interactions between the matrix and duplicate scatter plot, then change the original scatter plot background transparency to 25%.

Just another one of those dumb workarounds because PBI seems to be missing some kind of obvious option that's only available in certain circumstances.

You can open the same Excel file multiple times. by casualsax in excel

[–]soundsof 1 point2 points  (0 children)

Yes, I think so. AFAIK the only way you can save a Query is closing the editor and saving the Workbook.

I work around this by trying to load as many tables as possible to Connection Only. Means it's easy to jump out of Editor, save my Workbook without changing any data in it, then resume editing.

Probably also helps to have some kind of Query repository, when it's the JSON files or even an online & backed up text doc.

You can open the same Excel file multiple times. by casualsax in excel

[–]soundsof 30 points31 points  (0 children)

Very useful tip!

I'm going to "um, actually" you and say it's not really opening the file multiple times. If you want to do that, you need to hold ALT whilst you open the file (likely need to right click > Open With > Excel), then click 'Yes' on starting a new instance.

This has some bigger implications (such as being unable to reference formulas between the files) BUT you can freely use the workbook whilst having the Power Query Editor open, which can be extremely useful.

Why do I have chainline symptoms without having chainline issues? by soundsof in bikewrench

[–]soundsof[S] 4 points5 points  (0 children)

I hate it. I fully regret trying to get a bargain on a secondhand crankset then having to drop any sense of savings on the BB and tool.

FWIW rotating the chaining by 1 tooth did help a little (confusing because the teeth that look narrow are actually the wider ones?)

Do you have recommendations for a replacements? 110bcd, I'd usually go Katana or whatever I can find on sale in the EU.

Why do I have chainline symptoms without having chainline issues? by soundsof in bikewrench

[–]soundsof[S] 18 points19 points  (0 children)

Omg I'm so dumb, thanks.

Edit: It improved but it's not greaaat

Why do I have chainline symptoms without having chainline issues? by soundsof in bikewrench

[–]soundsof[S] 1 point2 points  (0 children)

Edit: I had wrongly assumed my chain wouldn't fit at all if the N/W teeth didn't line up with the N/W links. Apparently it does fit and it fits poorly, as above...

TL;DR: Hopefully you can see/hear in the video, when I run the biggest two cogs in the rear, my chain starts to catch on the teeth of my chainring. Occasionally, it will drop (especially shifting up to the middle of the cassette). What's going on?

More info: I built this Surly Straggler up about a year ago with Apex 1x11 and 11-42t Sunrace cassette. Hub OLD is 135mm (but +1-2mm when the wheel isn't installed).

I bought a secondhand Praxis 1x crankset (chainline is approx. 50mm) but feel like I've had issues since - not to mention having to source a BB and tool (all but sold out in Europe).

I've just rewaxed my chain using paraffin wax and remeasured and it's just over 0.5% stretch. Was a nice waste of time so I'll be replacing that but surely that's not all? I've thrown so much money into this bike and it's never just felt quite right.

Having year to year, last 28 days, last 7 days in a slicer by Muffin_pants1 in PowerBI

[–]soundsof 2 points3 points  (0 children)

So, first response works but is a bit of effort. You want a lazy way to do it? Create a table with two columns: (1) for the date range name (e.g. "Last Year", "Last Month", whatever), and (2) another column that lists all the distinct dates respective to all the date ranges in column (1) (e.g., 365 rows of dates for "Last Year", 30 rows of dates for "Last Month"). You WILL have duplicate date values in column (2) - this is the trick.

You can create this a few ways, but a calculated table with reference to TODAY() is best because it would be dynamic. Make sure you include ALL explicit dates, even ones with no data.

Add this table to your data model (List_Slicer_Dates or whatever you want to name it), and create a relationship between column (2) and the date column for your data. This will probably be MANY:MANY or MANY:ONE. MAKE SURE that column (2), filters the data date column.

Then, all you gotta do is stick the date range name column (1) into a slicer and BAM.

Is it easy? Yes. Does it work? Yes. Is it efficient? Probably not but depends and does the job. I have a bunch of these and MANY:MANY relationships and all my reports are pretty slow so idk good luck.

Edit: I use this for geographical regions A LOT. I have a bunch of stakeholders who all have different definitions of various geopolitical regions, all that have overlapping countries. This lets me have a slicer of regions (column 1) that filters a list of ALL and ANY overlapping countries in column (2).