This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
QuickBooks requires links for Terms of Service for productions apps. | |
So here they be. | |
End User License Agreement | |
You, as the user of this phenomenal product, can only use it to do what it does. | |
Since you can't make it do anything it doesn't do, you are required to refrain from | |
causing undue stress by asking it to do those things it can not do. | |
Privacy Policy | |
We don't much care about anything of yours but we do have to use the data in you account or why would we make this? |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
Sort sheets in a Google spreadsheet. | |
Allows specifying first/last sheets as arrays of sheet names | |
Requires Apps Script runtime powered by Chrome V8 (not Rhino) | |
*/ | |
function sortSheets(){sortSheets_(first=[config.indexSheetName], last=["log"]);} | |
function sortSheets_ (first=[],last=[]) { | |
if(!Array.isArray(first)) throw "Parameter 'first' must be an array"; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Running total of column B | |
=ArrayFormula( | |
IF(ISNUMBER(B2:B), | |
MMULT( | |
TRANSPOSE((ROW(B2:B)<=TRANSPOSE(ROW(B2:B)))*B2:B), | |
SIGN(B2:B) | |
), | |
IFERROR(1/0)) | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function splitObject_TEST(){Logger.log(splitObject({1:11,2:22,3:33,4:44,5:55,6:66,7:77}, 3))} | |
function splitObject(data, size){ | |
if(Object.keys(data).length <= size) | |
return [data]; | |
var count = 0; | |
var out = []; | |
for (var key in data) { | |
var bowl = Math.floor((count++)/size); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# check for swapfile | |
sudo swapon -s | |
# if there is one | |
# swapoff -a | |
sudo dd if=/dev/zero of=/swapfile bs=1024 count=1024k | |
sudo mkswap /swapfile | |
sudo swapon /swapfile | |
#swapfile should show now with | |
swapon -s | |
# set swappiness to keep the server happy |