##Date and Time
=TIMEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) + DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))
##Date
=DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))
##Time
##Date and Time
=TIMEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) + DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))
##Date
=DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))
##Time
| #!/usr/bin/python | |
| import os | |
| import socket | |
| import sys | |
| def encode_packet(data): | |
| output = bytearray() | |
| for i in range(0, len(data)): | |
| tmpoutput = bytearray([0, data[i]]) |
| Source: https://publish.obsidian.md/jrd/Globe+Key+QMK | |
| # Adding the Apple 🌐︎ key to QMK keyboards | |
| Apple keyboards have a funky `fn` key with a `🌐︎` globe symbol on them. In most ways this behaves as any other `fn` key, and I've never missed it using a third-party keyboard. Generally, you could just ignore it unless you really wanted quick access to the emoji picker. This changed with macOS Sequoia. The `🌐︎` key is now the default modifier for most | |
| window management shortcuts. | |
| These can be remapped using `Application Shortcuts` in `System Preferences`. However, you cannot add an `fn` modifier and, without it, you often clash with common shortcuts in other applications. There's no way to avoid this and macOS will give priority to the application shortcut. |
| import { line, curve, curveCatmullRom } from "d3-shape"; | |
| import { scaleTime, scaleLinear } from "d3-scale"; | |
| import { axisBottom, axisLeft } from 'd3-axis'; | |
| import { timeParse, isoFormat } from "d3-time-format"; | |
| import { select } from "d3-selection"; | |
| import { extent, max, min } from "d3-array"; | |
| export default { | |
| line: line, | |
| scaleTime: scaleTime, |
| <img src="img/missing-image.png" onerror="javascript:this.src='img/default.png'"> |
| var isbns = ['ISBN 0-330-28498-3', | |
| 'ISBN 1-58182-008-9', | |
| 'ISBN 2-226-05257-7', | |
| 'ISBN 3-7965-1900-8', | |
| 'ISBN 4-19-830127-1', | |
| 'ISBN 5-85270-001-0', | |
| 'ISBN 978-600-119-125-1', | |
| '978-601-7151-13-3', | |
| 'ISBN 978-602-8328-22-7', | |
| 'ISBN 978-603-500-045-1', |
| #blog.oscarmorrison.com | |
| #Cat feeder (open and close server) | |
| #change the pin, and port here. | |
| from flask import Flask, jsonify | |
| import RPi.GPIO as IO | |
| import time | |
| pinOutOne = 4 | |
| #set this two whatever your 2nd servo is in | |
| pinOutTwo = 5 |
| heroku config:set `cat .env` |
| export PS1="\e[44mogem@local:\e[m \w \[$txtcyn\]\$git_branch\[$txtrst\] \n$ " | |
| export CLICOLOR=1 | |
| export LSCOLORS=GxFxCxDxBxegedabagaced | |
| export GITAWAREPROMPT=~/.bash/git-aware-prompt | |
| export PATH=/opt/local/bin:/opt/local/sbin:$PATH | |
| export PATH=$PATH:~/.scripts/ | |
| export PATH=$PATH:/usr/local/bin | |
| export PATH="$HOME/.node/bin:$PATH" | |
| source $GITAWAREPROMPT/main.sh |
| echo "Opening git repo" | |
| giturl=$(git config --get remote.origin.url) | |
| giturl=$( tr '[A-Z]' '[a-z]' <<< $giturl) | |
| if [[ $giturl == *"https"* ]] | |
| then | |
| echo "Switching repo remote origin url from HTTPS to SSH" | |
| echo $giturl | |
| giturl=${giturl#https://github.com/} | |
| repo=${giturl/\.git} |