How to add background colour to weekends in a vertical calendar
Apply to range: A2:D176
Custom formula: =OR(WEEKDAY($A:$A)=7, WEEKDAY($A:$A)=1)
(function(body) { | |
var text = [], | |
treewalker = document.createTreeWalker(body, NodeFilter.SHOW_TEXT, null, false); | |
while(treewalker.nextNode()) { | |
if (treewalker.currentNode.nodeValue.charAt(0) !== '\n') { | |
text.push(treewalker.currentNode); | |
} | |
}; |
# | |
# Acts as a nginx HTTPS proxy server | |
# enabling CORS only to domains matched by regex | |
# /https?://.*\.mckinsey\.com(:[0-9]+)?)/ | |
# | |
# Based on: | |
# * http://blog.themillhousegroup.com/2013/05/nginx-as-cors-enabled-https-proxy.html | |
# * http://enable-cors.org/server_nginx.html | |
# | |
server { |
cd ~/Library/Application\ Support/Sublime\ Text\ 3/Packages/ | |
git clone git://github.com/wbond/sublime_package_control.git Package\ Control | |
cd Package\ Control | |
git checkout python3 | |
# restart Sublime Text 3 and you should have Package Control working |
How to add background colour to weekends in a vertical calendar
Apply to range: A2:D176
Custom formula: =OR(WEEKDAY($A:$A)=7, WEEKDAY($A:$A)=1)
Navngi filer med samme konvensjon som brukes av DropBox i Camera Upload.
cd <photo-directory>
exiftool "-FileName<CreateDate" -d "%Y-%m-%d %H.%M.%S%%-c.%%le" .
'3 x 10 x 10 min 2kg '.match(/(\d+\s?[x|min|kg]+)/g).forEach(match => console.log(match.replace(/\s/,'').match(/(\d+)(\w+)/))) |
Tabletop.js is a fantastic, open-source JavaScript library that lets developers easily integrate data from Google Spreadsheets into their online projects. I've used it, even contributed a minor feature, and love it for prototyping. Non-programmers love being able to update a project via Google Spreadsheets' hyper-intuitive interface.
That said, I'm extraordinarily wary of using Tabletop in production. Instead, at the Wall Street Journal, we use a bit of middleware to "prune" our Google Spreadsheets-based data and then cache it on our own servers. A few brief reasons: