airstrike

C:\projects\fundraiser fundraiser λ python manage.py shell
Python 3.8.1 (tags/v3.8.1:1b293b6, Dec 18 2019, 22:39:24) [MSC v.1916 32 bit (Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
(InteractiveConsole)
>>> from fundraising.models import *
>>> from django.db.models.sql.constants import LOUTER
>>> from django.db.models import *
>>> donations = Donation.objects.values('week').annotate(agg=Sum('amount')).filter(membership__group__id=OuterRef('membership__group_id'))
>>> groups = Group.objects.annotate(amounts=Subquery(donations, join=True, join_type=LOUTER))
>>> groups

airstrike

Option Explicit
Sub InterpolateFontColor()
    Dim rng As Range, lowpointColor As Long, highpointColor As Long, midpointColor As Long
    
    'Get A Cell Address From The User to Get Number Format From
    On Error Resume Next
    Set rng = Application.InputBox( _
        Title:="Interpolate Font Color in Cells", _
        Prompt:="Select cell range to interpolate", _
        Type:=8)

airstrike

-- What I have
-- >>> from django.db.models.expressions import *
-- >>> from foo.utils import GroupConcat 
-- GroupConcat is essentially just a string aggregator... code is here if you're curious https://dpaste.org/Twpu/slim#L15,20
-- >>> window = {'partition_by': [F('id'),], 'order_by': [F('workload__submission__employee__role__level').desc(),], 'frame': RowRange()}
-- >>> Project.objects.annotate(team=Window(expression=GroupConcat('workload__submission__employee__goes_by'), **window))

SELECT
    "staffing_project"."id",
    "staffing_project"."name",

airstrike

#SingleInstance
#Persistent

RAlt & z::
reload
return

DetectHiddenWindows, On
F1::return ;F1 does nothing

airstrike

// Uncompressed version of dungeon generator, backported for MS Visual Studio 2008
// Original work: https://gist.github.com/munificent/b1bcd969063da3e6c298be070a22b604
// Original uncompressed version: https://gist.github.com/Joker-vD/cc5372a349559b9d1a3b220d5eaf2b01
// Tested with Microsoft (R) C/C++ Optimizing Compiler Version 16.00.30319.01 for x64

#include <time.h>       // Robert Nystrom
#include <stdio.h>      // @munificentbob
#include <stdlib.h>     //      for Ginny
// #include <stdbool.h> //      2008-2019
typedef int bool;

airstrike

/*
From https://github.com/romainl/flattened
TERMCOL   HEX     RGB
-------   ------- -----------
black     #073642   7  54  66
red       #dc322f 220  50  47
green     #859900 133 153   0
yellow    #b58900 181 137   0
blue      #268bd2  38 139 210
magenta   #d33682 211  54 130

airstrike

" VIM user interface
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
set so=2 " Show at least 2 lines around cursors when moving vertically
set ruler "Always show current position
set cmdheight=1 "The commandbar height

" Set backspace config
set backspace=eol,start,indent
set whichwrap+=<,>,h,l

airstrike

#========================================================================
# Description: Tokenise an Excel formula using an implementation of
#              E. W. Bachtal's algorithm, found here:
#
#                  Blog post:                https://ewbi.blogs.com/develops/2004/12/excel_formula_p.html
#                  See also:                 https://ewbi.blogs.com/develops/popular/excelformulaparsing.html
#                  Direct link to this port: http://www.ewbi.com/ewbi.develop/samples/jsport_nonEAT.py 
#
#              Originally written for Python v2.5 (win32)
#      Author: Robin Macharg

airstrike

SetCapsLockState, AlwaysOff
; The above lets you use hotkeys at the bottom end of the file on keyboards other than Anne and emulate the Fn Caps behavior
Menu, Tray, Icon, %A_WorkingDir%\anne.ico,, 1

<+J::Send, +{Left}
<+K::Send, +{Down}
<+L::Send, +{Right}
<+I::Send, +{Up}

<+#J::Send, +#{Left}

airstrike

;
; AutoHotkey Version: 1.x
; Language:       English
; Platform:       Win9x/NT
; Author:         Matt Heath <matt@mattheath.com>
;
; Script Function:
;	Remaps keys when using an Apple Keyboard with a Windows PC
;