Skip to content

Instantly share code, notes, and snippets.

@ExcelRobot
ExcelRobot / ArrayManipulation.lambda
Last active May 4, 2024 08:25
Array Manipulation LAMBDA Functions
/*
Excel Array Manipulation LAMBDA functions
Courtesy of Excel Robot
The Microsoft Excel team recent released 11 new Excel functions for combining, shaping, and resizing arrays.
I had already created similar ones for myself using the amazing LAMBDA function. Since the new functions
are only available to users running Beta Channel, I've renamed my versions and given them the same function
names so anyone with LAMBDA and LAMBDA helper functions (like MAKEARRAY), and import these LAMBDAs into your
workbook and have nearly the same functionality.
@wojteklu
wojteklu / clean_code.md
Last active May 4, 2024 08:25
Summary of 'Clean code' by Robert C. Martin

Code is clean if it can be understood easily – by everyone on the team. Clean code can be read and enhanced by a developer other than its original author. With understandability comes readability, changeability, extensibility and maintainability.


General rules

  1. Follow standard conventions.
  2. Keep it simple stupid. Simpler is always better. Reduce complexity as much as possible.
  3. Boy scout rule. Leave the campground cleaner than you found it.
  4. Always find root cause. Always look for the root cause of a problem.

Design rules

@sadukie
sadukie / AuthenticatedPlaywrightDriver.cs
Created April 30, 2024 16:03
Using Shared State in Playwright for .NET
using Microsoft.Playwright;
using NimblePros.SuperSecretProject.FrontEndTests.PageObjects;
namespace NimblePros.SuperSecretProject.FrontEndTests;
internal class AuthenticatedPlaywrightDriver : IDisposable
{
private IPlaywright? _playwright;
private IBrowser? _browser;
private IBrowserContext? _context;
public AuthenticatedPlaywrightDriver()
#!/usr/bin/env bash
# Abort sign off on any error
set -e
# Start the benchmark timer
SECONDS=0
# Repository introspection
OWNER=$(gh repo view --json owner --jq .owner.login)
@aprilmintacpineda
aprilmintacpineda / Using Multiple SSH keys - Beginner Friendly.md
Last active May 4, 2024 08:23
Beginner Friendly: Using Multiple SSH keys

How to follow this guide

The problem

I have one computer and two different github accounts. One is for work, the other is for my personal stuff. I can't use the same ssh key twice, so I have to use different ssh key for each of my accounts. How do I do that? How do I switch between these ssh keys?

@CMCDragonkai
CMCDragonkai / ppi_and_dpi.sh
Last active May 4, 2024 08:22
CLI/X: Get the Real DPI/PPI of your Monitors/Display Devices on Linux
#!/usr/bin/env bash
# this will acquire the real PPI/DPI of the preferred/native mode of your monitors
# the DPI reported by `xdpyinfo` is not the real DPI, but your virtual DPI
# that may have been automatically calculated from the EDID information
# or manually set previously
# works in ZSH too
# requires xrandr, perl and bc
# in bc, only division respects scale, so we have to force a useless division
@kyo-takano
kyo-takano / making-the-most-of-local-llms.ipynb
Last active May 4, 2024 08:20
ローカルLLMはこーやって使うの💢
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@cseeman
cseeman / markdown_examples.md
Created September 15, 2023 16:48
Markdown for info panel/warning box

Examples for how to create your own info panel, warning box and other decent looking notification in GitHub markdown.

All the boxes are single/two cell tables or two row tables.

Warning box

❗ You have to read about this

FWIW: I (@rondy) am not the creator of the content shared here, which is an excerpt from Edmond Lau's book. I simply copied and pasted it from another location and saved it as a personal note, before it gained popularity on news.ycombinator.com. Unfortunately, I cannot recall the exact origin of the original source, nor was I able to find the author's name, so I am can't provide the appropriate credits.


Effective Engineer - Notes

What's an Effective Engineer?

@dfirfpi
dfirfpi / w10pfdecomp.py
Last active May 4, 2024 08:17
Windows 10 Prefetch (native) Decompress
#!/usr/bin/python
# -*- coding: utf-8 -*-
#
# Copyright 2015, Francesco "dfirfpi" Picasso <francesco.picasso@gmail.com>
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0