Loading .bas file in excel

* Ctrl + Break to stop Macro / Alt + F8 to run "stop function"

* Alt + F11 to open VBA editor

* Remove old bas and import new bas file

restart excel or Alt + F8 to run "start function"

claude code via Azure, in different profile

 In case you need to create a different profile, you can use following in bashrc:

alias azure_claude='

CLAUDE_CONFIG_DIR="$HOME/.azure_claude" \

CLAUDE_CODE_USE_FOUNDRY=1 \

ANTHROPIC_DEFAULT_SONNET_MODEL="claude-sonnet-4-6" \

ANTHROPIC_DEFAULT_HAIKU_MODEL="claude-haiku-4-5" \

ANTHROPIC_DEFAULT_OPUS_MODEL="claude-opus-4-6" \

ANTHROPIC_FOUNDRY_BASE_URL="https://<project>.services.ai.azure.com/anthropic" \

ANTHROPIC_FOUNDRY_API_KEY=<API_KEY> \

/home/qspcadmin/.local/bin/claude'

installing LineageOS, via Claude code

Asked Claude code to install LineageOS on my old phone. It installed it but had to give below finishing touches in order for Sim to work properly.

Your OnePlus 6T is now fully set up with LineageOS 22.2 + Google Apps, and the Tello SIM is connected to LTE. If the issue recurs after a reboot, just dial *#*#4636#*#* on the phone to open the Radio Info screen and turn the radio on again.

 1. Look for "Preferred Network Type" dropdown — set it to LTE/WCDMA/GSM auto

 2. Look for a "Turn on Radio" or "Radio Power" button — tap it to turn the radio ON

Linux comand line autocomplete

    INDICATORS_DIR=/projects/equities/simulation/indicators

   _daily_indicator_complete() {

       local cur prev words

       cur="${COMP_WORDS[COMP_CWORD]}"

       prev="${COMP_WORDS[COMP_CWORD-1]}"

       words="${COMP_WORDS[*]}"

       # Only activate when command line contains daily_*.py

       [[ "$words" == *daily_*.py* ]] || return

       if [[ "$prev" == "-i" || "$cur" == *,* ]]; then

           local indicators=$(ls "$INDICATORS_DIR"/*.py 2>/dev/null \

               | xargs -n1 basename | sed 's/\.py$//' | sort -u)

           if [[ "$cur" == *,* ]]; then

               local prefix="${cur%,*},"

               local last="${cur##*,}"

               COMPREPLY=( $(compgen -W "$indicators" -- "$last") )

               COMPREPLY=( "${COMPREPLY[@]/#/$prefix}" )

           else

               COMPREPLY=( $(compgen -W "$indicators" -- "$cur") )

           fi

       fi

   }

   complete -o nospace -o default -F _daily_indicator_complete /opt/envs/py38/bin/python

SSH port forwarding

following command will make server think 8194 port on the server is open and all requests will be forwarded to the machine FROM WHICH you are SSHing.

 ssh -R 8194:localhost:8194 username@server

Restrict Chrome profiles

 If you want to restrict chrome profiles to a specific profile only, you need to create following file:

harshal@HP-Desktop:~$ cat /etc/opt/chrome/policies/managed/temp.json 
{
	"BrowserAddPersonEnabled": false,
	"BrowserGuestModeEnabled": false,
	"IncognitoModeAvailability": false,
	"IPFSEnabled": false,
	"RestrictSigninToPattern": "*",
	"BrowserSignin": 2,
}
harshal@HP-Desktop:~$

dell inspiron WiFi adapter not detected in Ubuntu 24.04

 sudo apt-get remove bcmwl-kernel-source

sudo apt-get install firmware-b43-installer b43-fwcutter

cat /etc/modprobe.d/* | egrep 'bcm'
(You may want to copy this) and see if the term 'blacklist bcm43xx' is there.

If it is, type cd /etc/modprobe.d/ and then sudo gedit blacklist.conf

Put a # in front of the line: blacklist bcm43xx

clean csv columns

 pip install csvkit

csvcut -c <column1>,<column2> file.csv