50:30:20 Rule
of Budgeting on Google Sheet of Ankur Warikoo
f(x)
: excel formula tutorial
for i in range(3, 12):
var = [f'=(A{i-1}+1)', f'=(D{i-1})', f'=(10%*B{i})',
f'=(B{i}+C{i})', f'=(E{i-1}+C{i}*$J$2/12)',
f'=(F{i-1}+C{i}*$I$2/12)',
f'=(G{i-1}+C{i}*$H$2/12)', f'=(E{i}*12/$D{i})',
f'=(F{i}*12/$D{i})', f'=(G{i}*12/$D{i})']
obj.mark(sheet_id, f'A{i}', [var])
API Calls in Google Sheets
function callNumbers() {
let url = "https://api.metalpriceapi.com/v1/latest?base=USD¤cies=XAU,XAG&api_key=Dxt3fx5NcET88EGsAtvrdJ";
let fact = UrlFetchApp.fetch(url);
let apiResponse = JSON.parse(fact.getContentText());
Logger.log(apiResponse);
const date = new Date(apiResponse.timestamp*1000);
let unixdate = date.toLocaleDateString("en-IN");
let unixtime = date.toLocaleTimeString("en-IN");
let price = apiResponse.rates.XAU*100000000;
console.log(unixdate, unixtime, price);
let sheet = SpreadsheetApp.getActiveSheet();
sheet.getRange(1,1).setValue("Unix Timestamp");
sheet.getRange(1,2).setValue("Rate of Gold");
sheet.getRange(sheet.getLastRow() + 1,1).setValue(unixdate + ' ' + unixtime);
sheet.getRange(sheet.getLastRow() + 0,2).setValue(price);
}