Skip to content

Instantly share code, notes, and snippets.


Rogerio Prado de Jesus rogeriopradoj

View GitHub Profile
rogeriopradoj / DecompressZip.pqm
Created May 24, 2022
Power Query M Formula Language - DecompressZip - function (ZIPFile as any) as any
View DecompressZip.pqm
= (ZIPFile) =>
// expects full path to the ZIP file, only extracts the first data file after getting its size from the central directory
//read the entire ZIP file into memory - we'll use it often so this is worth it
Source = Binary.Buffer(File.Contents(ZIPFile)),
// get the full size of the ZIP file
Size = Binary.Length(Source),
//Find the start of the central directory at the sixth to last byte
rogeriopradoj /
Last active May 18, 2022
zerotier vpn raspberry pi nems
ip addr sh zt0 | grep 'inet'
ip a
ip addr sh zthnhjmvln | grep 'inet'
sudo nems-quickfix
sudo sysctl net.ipv4.ip_forward
sudo nano /etc/sysctl.conf
sudo sysctl -p
sudo sysctl net.ipv4.ip_forward
ip link show
rogeriopradoj / 1.Readme.MD
Created Feb 25, 2022 — forked from squeedee/1.Readme.MD
Adding your ssh key to lastpass
View 1.Readme.MD


  1. Install lpass, the last pass command line tool
brew install lastpass-cli --with-pinentry
  1. Create a passphrase encrypted key and make sure you put the public key where you need it, eg: github
rogeriopradoj /
Created Feb 11, 2022 — forked from ort163/
Route all traffic with a raspberry pi like a VPN
rogeriopradoj / stopwords.txt
Created Dec 29, 2021 — forked from alopes/stopwords.txt
Portuguese stop words
View stopwords.txt
rogeriopradoj /
Created May 22, 2021 — forked from yougg/
complete ways to set http/socks/ssh proxy environment variables

set http or socks proxy environment variables

# set http proxy
export http_proxy=http://PROXYHOST:PROXYPORT

# set http proxy with user and password

# set http proxy with user and password (with special characters)
rogeriopradoj /
Created May 12, 2021 — forked from tswaters/
Adding subdirectory of a remote repo to a subdirectory in local repo

This is way more complicated than it should be. The following conditions need to be met :

  1. need to be able to track and merge in upstream changes
  2. don't want remote commit messages in master
  3. only interested in sub-directory of another repo
  4. needs to go in a subdirectory in my repo.

In this particular case, I'm interested in bringing in the 'default' template of jsdoc as a sub-directory in my project so I could potentially make changes to the markup it genereates while also being able to update from upstream if there are changes. Ideally their template should be a separate repo added to jsdoc via a submodule -- this way I could fork it and things would be much easier.... but, it is what it is.

After much struggling with git, subtree and git-subtree, I ended up finding this -- it basically sets up separate branches from tracking remote, the particular sub-directory, and uses git subtree contrib module to pull it all togther. Following are

rogeriopradoj /
Last active Sep 30, 2020 — forked from tamsanh/
Generate and play a sound in Jupyter Notebook when then cell is run. Useful as notification when a long-running cell is done.
from IPython.lib.display import Audio
import numpy as np
framerate = 4410
play_time_seconds = 3
t = np.linspace(0, play_time_seconds, framerate*play_time_seconds)
audio_data = np.sin(2*np.pi*300*t) + np.sin(2*np.pi*240*t)
Audio(audio_data, rate=framerate, autoplay=True)
Microsoft office and Chrome not working on catalina patcher (Solution) (self.CatalinaPatcher)

submitted 4 months ago by jareza

Hi! mandatory introduction:

I have a mid 2009 Macbook Pro that has Catalina Installed using Dos dude patcher. Works Great

However trying to open Google Chrome gave me an error. That same error was given when trying to open microsoft office.
rogeriopradoj / PERSONAL.XLSB.bas
Last active Aug 14, 2020
Sub AutoFiltro()
' AutoFiltro Macro
' Atalho do teclado: Ctrl+Shift+F
End Sub