August 26th, 2018
Posted by pftq
Posted by pftq
Offkilted Tides (Piano)
Just something short I improvised a few days ago. Trying to warm myself back up before doing something longer. 
487 unique view(s)
July 22nd, 2018
Posted by pftq
Posted by pftq
VR Jetpack Game Website
Put together an official website for the VR Jetpack Game I've been making... Not too shabby for a day's work (or just three hrs really). Got to get back to working on the actual game!
----------------
----------------
574 unique view(s)
June 18th, 2018
Posted by pftq
Posted by pftq
Price Lookup via Cryptocurrency Screener
Extra benefit of the Cryptocurrency Screener sheet I shared earlier in the year is that you can use it to lookup prices without API limits (which @jbuty's plugin seems to hit).
Below are sample formulas you can use in Google Sheet to query my sheet for cryptocurrency prices:
1. Lookup via Cryptocurrency Screener sheet only (if you don't want to install any plugins):
2. Lookup via both Cryptocurrency Screener and CryptoFinance plugin (latter being backup to minimize quota use):
Below are sample formulas you can use in Google Sheet to query my sheet for cryptocurrency prices:
1. Lookup via Cryptocurrency Screener sheet only (if you don't want to install any plugins):
Quote
=IFERROR(INDEX(QUERY(IMPORTRANGE(
"https://docs.google.com/spreadsheets/d/12iLyLbSI2odBy4uAIXEm7bLCTds0SApKjsso9UKJ25Q/", "Screener!A:C"), "SELECT Col3 WHERE Col2='BTC'"), 2), 0)
"https://docs.google.com/spreadsheets/d/12iLyLbSI2odBy4uAIXEm7bLCTds0SApKjsso9UKJ25Q/", "Screener!A:C"), "SELECT Col3 WHERE Col2='BTC'"), 2), 0)
2. Lookup via both Cryptocurrency Screener and CryptoFinance plugin (latter being backup to minimize quota use):
Quote
=IFERROR(INDEX(QUERY(IMPORTRANGE(
"https://docs.google.com/spreadsheets/d/12iLyLbSI2odBy4uAIXEm7bLCTds0SApKjsso9UKJ25Q/", "Screener!A:C"), "SELECT Col3 WHERE Col2='BTC'"), 2), IFERROR(CRYPTOFINANCE( "BTC", "price") , 0))
"https://docs.google.com/spreadsheets/d/12iLyLbSI2odBy4uAIXEm7bLCTds0SApKjsso9UKJ25Q/", "Screener!A:C"), "SELECT Col3 WHERE Col2='BTC'"), 2), IFERROR(CRYPTOFINANCE( "BTC", "price") , 0))
522 unique view(s)
May 16th, 2018
Posted by pftq
Posted by pftq
Poststorm (Piano)
Short piano improvisation inspired by the lightning storm going on outside while it's still sunny.
673 unique view(s)
April 11th, 2018
Posted by pftq
Posted by pftq
Anuwera (Piano Solo vers.)
Short piano solo improvisation derived from the base melody in my earlier Anuwera piece. Played in parts and cleaned up in FL Studio. Can't escape the feeling that I've heard the melody before elsewhere, so if anyone's heard it before, let me know. It might also just be stereotypical fantasy/medieval motifs.
974 unique view(s)