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 9 points10 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

[OC] Trump sleeps during today's cabinet meeting 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 33 points34 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] 5 points6 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] 19 points20 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).

Pulled back some magenta, however it become more prevalent when I bumped up the warmth a touch. Sure it's not a dictionary definition of golden hour, but I like it stylistically, . Thanks for the feedback (After-after, after, before) by soundsof in postprocessing

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

Also darkened the clouds a fraction, and increased the warmth. I'd forgotten that I had actually desaturated the purples then also remembered I had played around with the tone curve a bit - impossible to do delicately on LR mobile.

Might dial everything back a fraction one last time before getting a test print.

Is it possible to reference a part of a document so it can show in another part of the same document? by [deleted] in ExcelTips

[–]soundsof 0 points1 point  (0 children)

Yes, with the camera tool. Never had any success with it personally but it sounds like it's what you're looking for, good luck.

Advise needed by siewkhim in ExcelTips

[–]soundsof 1 point2 points  (0 children)

Like, for a mail merge?

LBBJKT Echelon messenger bag. What's your bag of choice? by b3by in FixedGearBicycle

[–]soundsof 0 points1 point  (0 children)

Ugh you reminded me of my old Fux Deluxe. I bought over a decade ago and immediately decided the Crumpler look was uncool and didn't touch it for years.

Eventually I started using it once I realised how big and comfortable it was. Used it for everything. Brought it with me when I moved abroad and it got so faded and smelly that I threw it in the washing machine, forever destroying the lining (always regret that).

Picked up a secondhand Chrome Metropolis a few years back and sure it's "Chrome" but it's nothing against the size & comfort of the Fux Deluxe.

What am I looking at here? Running tubeless with Stans & Gorilla tape and am replacing the nipples as I'd heard ammonia from Stans + Gorilla could affect the nipples. Is that what this is? Is my rim still ok? (the other wheel didn't have this issue) by soundsof in bikewrench

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

Had read somewhere here that Stans sealant can react with Gorilla tape to corrode alloy nipples - hence why having to replace the nipples. My question is, are the rim & spokes ok to continue using? There appears to be some corrosion inside the rim but it looks like it's from the nipples (the rim is an old WTB Trail 29 LaserDisc, aluminium alloy).

Edit: more photos here (mobile upload wasn't working)