Skip to content

Instantly share code, notes, and snippets.

View LaughDonor's full-sized avatar

Sunny Patel LaughDonor

  • Dallas, TX
  • 18:05 (UTC -05:00)
View GitHub Profile
@LaughDonor
LaughDonor / module1.bas
Created July 20, 2021 22:09
Excel VBA Function to count all distinct values across multiple tables (same column name)
Option Explicit
Function CountUnique(TableNames As Range, ColumnName As String) As Long
Dim TableName
Dim TempRange As Range
Dim Rng As Range
Dim List As Object
' Iterate through every range and push cell values to dictionary keys, and count the keys
With CreateObject("Scripting.Dictionary")
@LaughDonor
LaughDonor / youtubehistory-one-click.user.js
Last active October 20, 2020 22:45
YouTube History - One Click Delete
// ==UserScript==
// @name Youtube History - One Click Delete
// @namespace http://tampermonkey.net/
// @version 0.1
// @description Delete selectively from Youtube History without submenu.
// @author Sunny Patel <laughdonor@gmail.com>
// @homepage https://gist.github.com/LaughDonor/166c4d7ff51c2c70d23b57f7614ae63d
// @match https://myactivity.google.com/activitycontrols/youtube*
// @downloadURL https://gist.github.com/LaughDonor/166c4d7ff51c2c70d23b57f7614ae63d/raw/youtubehistory-one-click.user.js
// @updateURL https://gist.github.com/LaughDonor/166c4d7ff51c2c70d23b57f7614ae63d/raw/youtubehistory-one-click.user.js
@LaughDonor
LaughDonor / exp.py
Last active May 18, 2022 07:17
Solves Torus Puzzle on Exponential Idle on Android (no root)
#!/usr/bin/env python
# coding: utf-8
# In[1]:
"""Solves Torus Puzzle on Exponential Idle on Android (no root)"""
__author__ = "Sunny Patel <github.com/laughdonor>"
from __future__ import annotations
from dataclasses import dataclass, astuple
@LaughDonor
LaughDonor / jira-subtask-dev.user.js
Created October 8, 2018 16:19
Prefill JIRA Subtask Fields
// ==UserScript==
// @name Pre-fill SubTask Info
// @namespace https://jira.solutionstarit.com/
// @version 0.1
// @description Pre-fill JIRA Subtask information
// @author Sunny Patel
// @updateUrl https://gist.github.com/laughdonor/09cfe7691dbeb0f3a47fa38c049e8337/raw/jira-subtask-dev.user.js
// @match https://jira.solutionstarit.com/browse/*
// @grant none
// ==/UserScript==
# Your init script
#
# Atom will evaluate this file each time a new window is opened. It is run
# after packages are loaded/activated and after the previous editor state
# has been restored.
#
# An example hack to log to the console when each text editor is saved.
#
# atom.workspace.observeTextEditors (editor) ->
# editor.onDidSave ->