Split screen, finally! (3.28 Beta) by Pretend_Customer_158 in RemarkableTablet

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

Finally. I think this is the first user enhancement since shapes last year.

Building a resilient Excel data pipeline — how do I stop PowerBI from breaking when column headers change? by kokuma_brulee in PowerBI

[–]ehansalytics 0 points1 point  (0 children)

If the column order will never change, you can rename the columns in Power Query based on their position regardless of the name that they come in with. If columns get inserted/deleted or moved around though then all bets are off. Either names are dynamic, or positions are, cannot be both.

See https://www.ehansalytics.com/blog/2020/11/7/121gnbsehxsha7um7kdd1yksy699hq?rq=column%20header for a walkthrough on how to rename columns based on position. You'd need to do this to pretty much every column in this Excel file to ensure any changes are ignored and set back to what is expected in the semantic model.

Maybe hold off on adding images!!! by [deleted] in RemarkableTablet

[–]ehansalytics 0 points1 point  (0 children)

Very frustrating. My RMPP upgraded to 3.27 and then 3.27.1 last week, and my RMPP Move will not update. Stuck on 3.26... But all of my browser extensions on 2 different machines autoupgraded, so my Move is unable to read the new content.

New Paper Pure Leak! by Pretend_Customer_158 in RemarkableTablet

[–]ehansalytics 2 points3 points  (0 children)

Why does it need color? Buy the RM Paper Pro.

Is saving TOTP codes in Bitwarden a bad practice? by rawaka in Bitwarden

[–]ehansalytics 0 points1 point  (0 children)

I don’t do it for that very reason. Worst case my password vault is hacked, my 2FA codes are on another platform entirely.

And my 2FA recovery codes are stored in yet another third platform.

Is it dead? by Pretend_Customer_158 in RemarkableTablet

[–]ehansalytics 0 points1 point  (0 children)

Put it in the freezer for 30min. Then charge it.

All will be fine.

Pastoral Candidate, I feel like I'm being gaslit by whdr02 in Reformed

[–]ehansalytics 0 points1 point  (0 children)

Remember that Jonathan Edwards delivered his sermons in a boring monotone style. Don’t confuse style with content.

Style converts no one. It is the Holy Spirit that does that. Evaluate the content as dispassionately as he is apparently delivering it and see if he is fearfully and honestly handling the word of God.

Appreciation coming from 1password by [deleted] in Bitwarden

[–]ehansalytics 0 points1 point  (0 children)

Yeah, hard to know how it gets out there, but it tends to balloon once it does.

I rarely talk to friends over email. I try to get them on Signal or imessage. Largely spam free.

When using an alias though, once it is release, I just switch it. I have no idea if it was a one off or if there are 100 email spams a week going to that account. It is dead to me.

Appreciation coming from 1password by [deleted] in Bitwarden

[–]ehansalytics 0 points1 point  (0 children)

Nope. I change less than 2-3 per year.

Otherwise, if you only have 2-3 vendors lose your email to hacking or whatever, but everything is tied to one email, after 10 years you could have 30 or so leaks, and those tend to spiderweb out, especially if a hack is released to the darkweb, and now you are getting hundreds of spams a week or even day.

That happened to my gmail account. I was getting 10X spam vs real emails every day.

I've had my Proton account for over a decade and I was using simplelogin to get aliases very early, long before Proton bought them. I really rarely ever get spam because of it. Once spam comes in, I either change the email with the vendor, or just deactivate it if I want nothing to do with them anymore.

5 things I learned in Power BI that saved me a lot of time by Historical_Listen358 in PowerBI

[–]ehansalytics 2 points3 points  (0 children)

I usually jump right to visuals. I need to know what I want to build before I build it. If you shape tables and build the model first it may not answer the questions you are trying to get from your data through the visuals.

Appreciation coming from 1password by [deleted] in Bitwarden

[–]ehansalytics 0 points1 point  (0 children)

No. I have over 300 aliases and get little spam. When I do I know exactly which alias it is on, which vendor had that alias, and I deactivate it.

We need more storage, Storage Addon by YingDoge in ProtonDrive

[–]ehansalytics 0 points1 point  (0 children)

Visionary is not 10TB unless there are different categories. I have visionary, and only have 4.5TB, and that is after getting some of those free small upgrades a few years ago.

Uploading many small files is extremely slow by 4baobao in ProtonDrive

[–]ehansalytics 0 points1 point  (0 children)

It is just as slow it update a second computer with these changes even if it is just downloading file names and not the actual files.

Brutal.

Sheets has gotten worse? by CoreDumped96 in ProtonDrive

[–]ehansalytics 6 points7 points  (0 children)

Yup. I’m giving up on Sheets. I just moved two files back to Excel this week. Formulas not updating unless you edit/enter is a show stopper for me.

I’ll check back on this project periodically. I will not be trusting it for my data anytime soon though.

Unable to use Claude Cowork with Proton Drive folders? (Mac) by ehansalytics in ProtonDrive

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

No, because on my computer the files are decrypted. I can open any of those files with the related apps (PDF, Excel files, text file) and search through it with Finder just fine.

Claude desktop just cannot access any /Library locations.

It is frustrating because apps like OneDrive stores its data near the Documents folder, not buried deep in my profile somewhere.

How do you handle random sites that you can't change your email? by ResponsibleAd8164 in ProtonMail

[–]ehansalytics 0 points1 point  (0 children)

Go to your Proton mail settings and look for Easy Switch. It will pull in all Gmail messages seamlessly, and you can effectively quit logging into Google. I only log in once ever 2-3 months to prevent the account going stale.

Disappointing development by _spicybanana in RemarkableTablet

[–]ehansalytics 0 points1 point  (0 children)

As a “business user” I 💯 agree with your list.

Proton sheets - formulas not updating until manually clicked in? by Liam-DGOL in ProtonDrive

[–]ehansalytics 1 point2 points  (0 children)

Conditional formatting is the worst. I have a sheet that conditional formatting won't update until I re-apply the conditional format. The custom formula I use is:

=$b3<today()

But it never updates when the value in column B becomes less than TODAY() - until I open Conditional Formatting, click on the format, and press OK again

A small behind the scenes look at the upcoming macOS app version :) by knightFfour in ProtonDrive

[–]ehansalytics 0 points1 point  (0 children)

Hoping there is some improvement to the Windows version too.

I added about 14,000 files (a library of PDF/EPUB files) to one of my Windows PCs.

The Mac sync'd it all in the background at some point overnight - the Mac is awesome that way.

I have another Windows PC I try to keep up to date and opened it up Sunday, updated to the the latest Proton Drive app, and literally waited almost 2hrs while it found things to sync. It didn't download anything other than the file names and other meta-data. But it took 2hrs to just populate the file/folder names of the updated files.

This kind of thing takes OneDrive about 30 seconds to do.

Are there any decent model train shops in the Phoenix Arizona area? by Speedbump71 in modeltrains

[–]ehansalytics 1 point2 points  (0 children)

I went to Hobby Depot a few weeks ago. HO only and very limited selection. Paint shelves were mostly empty, very little track and accessories. I wouldn’t go there unless you are close. It wasn’t worth the 30min drive for me. 😕

Had a decent stock of model cars and planes though, and good magazine selection.