Categories
User Help

Excel calculations based on INDEX match

I would like to calculate the time differences from column A for each colored segment next to the corresponding action in column E. I have an Index created to generate all the timestamps related to rows with "Begin" Column F is a simple representation of what I would like to achieve. INDEX($A$2:$D$34,SMALL(IF($C:$C=$H$2,ROW($C:$C)),ROW(1:1))-1,1) This provides an […]

Categories
User Help

Tmux: Make vim command open buffer in the already running vim instance

I’m usually running one tmux session for all the work I do, with per-project tmux windows (tabs). Each tmux window has one big split running vim and one or more splits with shells/processes related to the project. E.g. for a django project, one shell always runs manage.py runserver, showing me logs and errors, and another […]

Categories
Apple User Help

On a macOS computer running Catalina, is it possible to have the /Developer/ folder that used to be present since Mac Os X was born?

I am running a macOS System with Catalina 10.15.6. I used to like the /Developer/ folder in the root of the startup disk a lot, and I tend to still miss it now that under Catalina it seems not possible to have it. I have created /Users//Developer, but I got used to the /Developer/ relative […]

Categories
User Help

Excel calculations based on INDEX match

I would like to calculate the time differences from column A for each colored segment next to the corresponding action in column E. I have an Index created to generate all the timestamps related to rows with "Begin" Column F is a simple representation of what I would like to achieve. INDEX($A$2:$D$34,SMALL(IF($C:$C=$H$2,ROW($C:$C)),ROW(1:1))-1,1) This provides an […]

Categories
User Help

Finding value based on range with specific criteria

As shown in image, I have a range, specific value for each range. I find a formula as {=INDEX($B$1:$B$7,MATCH($C$1,VALUE(LEFT($A$1:$A$7,FIND("-",$A$1:$A$7)-1))))} to find value of a number within range, but there is some problem.As seen in image the formula returns "a" in D1 with C1 as search criteria. As we can see 17 should return "b". And […]

Categories
User Help

Are there shortcut for text editors/processors to delete the rest of a line?

The cursor may stay in the middle of the line and there may be necessity to delete whatever stands from the right side of the cursor, but only till the end of current line. I don’t know how this called properly and if there is such function in text editors, but if there is such, […]

Categories
User Help

Is it safe to move unallocated space over boot partition in dual boot

I am trying to move unused space from my windows installation (/dev/nvme0n1p3) to my manjaro root partition (/dev/nvme0n1p8) using GParted. GParted image of my system’s partitions. To move the unallocated space there it must move past the manjaro boot partition. When trying to do so I get this warning informing me that moving the boot […]

Categories
Apple User Help

On a macOS computer running Catalina, is it possible to have the /Developer/ folder that used to be present since Mac Os X was born?

I am running a macOS System with Catalina 10.15.6. I used to like the /Developer/ folder in the root of the startup disk a lot, and I tend to still miss it now that under Catalina it seems not possible to have it. I have created /Users//Developer, but I got used to the /Developer/ relative […]

Categories
Apple User Help

Automator workflows fail to replace selected text with their actions’ output in Safari 14

After updating from Safari 13 to Safari 14 (on macOS 10.15.6), I have noticed that all of my text-filtering Automator workflows no longer work correctly when invoked from the updated Safari. For an example of such workflow, see the screenshot below. It shows a simple workflow that takes the current text selection from any app, pipes it […]

Categories
Apple User Help

Opening an email from Sent mailbox does not show the complete thread it belongs to in iOS Mail app

I have an email account configured via IMAP in iOS Mail app, with the Organize by Thread and Complete Threads toggles both turned on in Mail settings. Thanks to the latter, when I open an email from the Inbox or Archive mailboxes, it is shown in the context of its thread, with the preceding and […]