Skip to content

Instantly share code, notes, and snippets.

Discover gists

@Influexcel
Influexcel / funcionesInfluexcel
Last active May 1, 2024 19:11
Influexcel
DESVIACION = LAMBDA(Real;Presupuesto;TEXTO(SI.ERROR((Real / Presupuesto) - 1; "---"); "0,00%"));;
PIVOTANDO = LAMBDA(OrigenFilas;OrigenColumnas;Valor;LET(Filas;UNICOS(OrigenFilas);Columnas;TRANSPONER(UNICOS(OrigenColumnas));Importes;SUMAR.SI.CONJUNTO(Valor;OrigenFilas;Filas;OrigenColumnas;Columnas);Cabecera;APILARH("PIVOTANDO";Columnas);Resultado;APILARH(Filas;Importes);Output;APILARV(Cabecera;Resultado);Output));;
AGRUPANDO = LAMBDA(RangoLista;RangoAcumulados;LET(Lista;UNICOS(RangoLista);Acumulados;SUMAR.SI.CONJUNTO(RangoAcumulados;RangoLista;Lista);Cuadro;APILARH(Lista;Acumulados);CuadroOrdenado;ORDENAR(Cuadro;2;-1);CuadroOrdenado));;
TOPRANKING = LAMBDA(RangoLista;RangoValores;Top;[Resto];LET(Filas; RangoLista; Valores; RangoValores; Top; Top; ListaFilas; UNICOS(Filas); ListaValores; SUMAR.SI.CONJUNTO(Valores; Filas; ListaFilas); RangoResultado; APILARH(ListaFilas; ListaValores); RangoOrdenado; ORDENAR(RangoResultado; 2; -1); SumaTotal; SUMA(RangoValores); OutputRanking; TOMAR(RangoOrdenado; Top; ); SumaTo
@ner00
ner00 / viewimage.user.js
Last active May 1, 2024 19:08 — forked from bijij/viewimage.user.js
Userscript version of the View Image extension
// ==UserScript==
// @name View Image
// @namespace https://github.com/bijij/ViewImage
// @version 3.7.0.12
// @description Re-implements the Google Images' "View Image" and "Search by Image" buttons.
// @author Joshua B
// @icon data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAwCAYAAABXAvmHAAAFdElEQVRoge2YX2xTVRzHv7ejc8BGmuAYwQXHgxmEIDVqIiEmHULUxIcaffShE2YMgdjBgwRM4HHu5ZpofGDorfpAjA8j0ZjxZxbcwERZWOKTPhjGxv51W9vb293/5/hw1/Z299ze27WgJPs2be89f379/M45v3N+t8C61rWuJ1qcW0X6zIkIR8FTRQ5TVQUIASi1KgvfBa3c02J5qX7r1z+U/cZi7F2K1e2Kt7byognrIvHcCZw+f8TBu4EFr997K2L89U8yPwg2eBl/eR3LCbvI4gKj7yoHVtm42HkaI00HmPYCzEJD4jfs+BMbD00yO7nBVyd/fQY6T2Nk+xHXeuYMEGMpDACNezIAKB4O7ag4vaXRZ5fbtWiS8oKyWbVsb23gfMG7OgBTLkI07skgKAZ6Z29tG2c0dLdssItThHS5tevYtZNvyKTDyEsY2H0KI22V4QGXINZ/bbcNHQU4riv46tRNT2s1KP3RUYHMz8VINuuAL8AMfdzs4GXGgNWl8H70Ssd7LHhRxMBua9kQTSqSAO5h5uLA41M63iOQuVkLvvMURrYfBlGzMOVFxpJ1qoIDj34WrJGfjZGcBT+6Am9IM4kNLTt7/diosIQerYrwooiBzl6Mbj8McwV++NOXuv3aYe9CBRUWnumypaxRdvhLnacw2vYaE97
@plastic041
plastic041 / index.ts
Created February 20, 2023 07:19
hono + socket.io
import { serve } from "https://deno.land/std@0.162.0/http/server.ts";
import { Server } from "https://deno.land/x/socket_io@0.2.0/mod.ts";
import { Hono } from "https://deno.land/x/hono@v3.0.0/mod.ts";
import { logger, html } from "https://deno.land/x/hono@v3.0.0/middleware.ts";
const app = new Hono();
app.use("*", logger());
app.get("/", (c) => {
return c.html(
@johnhw
johnhw / df_resources.md
Last active May 1, 2024 19:07

A complete list of books, articles, blog posts, videos and neat pages that support Data Fundamentals (H), organised by Unit.

Formatting

If the resource is available online (legally) I have included a link to it. Each entry has symbols following it.

  • ⨕⨕⨕ indicates difficulty/depth, from ⨕ (easy to pick up intro, no background required) through ⨕⨕⨕⨕⨕ (graduate level textbook, maths heavy, expect equations)
  • ⭐ indicates a particularly recommended resource; 🌟 is a very strongly recommended resource and you should look at it.
@shihyu
shihyu / example.c
Created March 28, 2017 14:33 — forked from waveacme/example.c
linux list.h for userspace
#include <stdlib.h>
#include <stdio.h>
#include "list.h"
typedef struct episode {
int epid;
struct list_head list;
} episode_t;
@aamiaa
aamiaa / CompleteDiscordQuest.md
Last active May 1, 2024 19:05
Complete Recent Discord Quest

Complete Recent Discord Quest

Note

This no longer works in browser!

Note

This no longer works if you're alone in vc! Somebody else has to join you!

How to use this script:

  1. Accept the quest under User Settings -> Gift Inventory
@is
is / test_grader.py
Created October 9, 2016 16:04
http://www.pyimagesearch.com/2016/10/03/bubble-sheet-multiple-choice-scanner-and-test-grader-using-omr-python-and-opencv/
from imutils.perspective import four_point_transform
from imutils import contours
import numpy as np
import argparse
import imutils
import cv2
ap = argparse.ArgumentParser()
ap.add_argument("-i", "--image", required = True,
@nick-jiang
nick-jiang / captcha.py
Last active May 1, 2024 19:03
Create simple captcha image using PIL.
#!/usr/bin/env python
# _*_ encoding: utf-8 _*_
import random
import string
from PIL import Image, ImageDraw, ImageFont, ImageFilter
CHARS = string.digits + string.letters
def create_captcha(loc='media/fonts', size=(120, 30), chars=CHARS, amount=6, img_type='GIF', mode='RGB',
@utlandr
utlandr / biqu_microprobe.cfg
Last active May 1, 2024 19:02
Klipper probe config for the BIQU Microprobe (V1/V2)
## --- BIQU Microprobe Klipper configuration ---
# Not much different from a standard probe config. The
# main difference compared to most probes is to disable
# deactivating the probe (PROBE_UP) after each sample
#
# You can either copy pasta this directly or import
# into your config.yml using [include microprobe.cfg]
#
# Note: if you are changing from a bltouch or one of its
# clones, remove/comment out the [bltouch] config!
@Hakky54
Hakky54 / openssl_commands.md
Last active May 1, 2024 19:01 — forked from p3t3r67x0/openssl_commands.md
Some list of openssl commands for check and verify your keys

OpenSSL 🔐

Install

Install the OpenSSL on Debian based systems

sudo apt-get install openssl