Skip to content

Instantly share code, notes, and snippets.

View arlm's full-sized avatar

Alexandre Rocha Lima e Marcondes arlm

View GitHub Profile

=AND(COUNTIF(indirect("R"&ROW()&"C"&(COLUMN()+1), FALSE),indirect(MID(FORMULATEXT(indirect("R"&ROW()&"C"&(COLUMN()), FALSE)),2,8)&"$F"&RIGHT(FORMULATEXT(indirect("R"&ROW()&"C"&(COLUMN()), FALSE)), LEN(FORMULATEXT(indirect("R"&ROW()&"C"&(COLUMN()), FALSE)))-11)))=0, COUNTIFS(indirect(MID(FORMULATEXT(indirect("R"&ROW()&"C"&(COLUMN()), FALSE)),2,8)&"$F"&RIGHT(FORMULATEXT(indirect("R"&ROW()&"C"&(COLUMN()), FALSE)), LEN(FORMULATEXT(indirect("R"&ROW()&"C"&(COLUMN()), FALSE)))-11)),"<>"&"", indirect(MID(FORMULATEXT(indirect("R"&ROW()&"C"&(COLUMN()), FALSE)),2,8)&"$F"&RIGHT(FORMULATEXT(indirect("R"&ROW()&"C"&(COLUMN()), FALSE)), LEN(FORMULATEXT(indirect("R"&ROW()&"C"&(COLUMN()), FALSE)))-11)),"<>"&"""""")>0)

Brackets

Colored assignmenmts

BK9:BK10,I9:I10,BK17:BK18,I17:I18,BK25:BK26,I25:I26,BK33:BK34,I33:I34,BK41:BK42,I41:I42,BK49:BK50,I49:I50,BK57:BK58,I57:I58,BK65:BK66,I65:I66,BK73:BK74,I73:I74,BK81:BK82,I81:I82,BK89:BK90,I89:I90,BK97:BK98,I97:I98,BK105:BK106,I105:I106,BK113:BK114,I113:I114,BK121:BK122,I121:I

youtube-dl --get-id PLErmOtDUq0Tg7Wx9F5YJUM2G1sJ4wwPWd | xargs -I '{}' -P 5 youtube-dl -f best 'https://youtube.com/watch?v={}'
@arlm
arlm / Find duplicate lines in a file
Created December 12, 2023 11:55
Shell command to find duplicate lines in a file
find . -name .gitignore -maxdepth 2 -exec sh -c "echo {} && sort {} | tr -s '\n' | uniq -cd" \;
@arlm
arlm / Grab vimeo links - optimized
Created December 12, 2023 11:54
Better algorithm to find all vimeo embedded links on a page
@arlm
arlm / Grab vimeo links
Created December 12, 2023 11:54
Find all embedded vimeo links on a page
Main view
Logged out
login -> Logged in
Please log in
Logged in
logout -> Logged out
home -> Welcome
Welcome
next -> Second page
Second page
# Poty
LoggedOut*
adminLogin -> AdminLoggedIn
privateLawyerLogin -> PrivateLawyerLoggedIn
privatePersonLogin -> PrivatePersonLoggedIn
companyCustomerLogin -> CompanyCustomerLoggedIn
companyAdminLogin -> CompanyAdminLoggedIn
companySalesLogin -> CompanySalesLoggedIn
companyLawyerLogin -> CompanyLawyerLoggedIn
// ==UserScript==
// @name Always show big map on vdip
// @namespace https://github.com/arlm
// @version 0.2
// @description Make vDip show big map by default on game board screen
// @author arlm
// @license MIT
// @match https://www.vdiplomacy.com/board.php*
// @match https://vdiplomacy.com/board.php*
// @icon https://www.google.com/s2/favicons?domain=vdiplomacy.com
@arlm
arlm / zsh-keyboard-shortucts.md
Created November 26, 2021 16:10 — forked from mkfares/zsh-keyboard-shortucts.md
Common zsh Keyboard Shortcuts on macOS Catalina

Common zsh Keyboard Shortcuts on macOS Catalina

Navigation

CTRL + A : Move the cursor to the beginning of the line
CTRL + E : Move the cursor to the end of the line
OPTION + Left Arrow : Move the cursor one word backward
OPTION + Right arrow : Move the cursor one word forward
Left Arrow : Move the cursor one character backward
Right Arrow : Move the cursor one character forward

@arlm
arlm / ANSI.md
Created September 9, 2021 09:23 — forked from fnky/ANSI.md
ANSI Escape Codes

ANSI Escape Sequences

Standard escape codes are prefixed with Escape:

  • Ctrl-Key: ^[
  • Octal: \033
  • Unicode: \u001b
  • Hexadecimal: \x1b
  • Decimal: 27