Youtube

Calculate the distance between two sets of latitude and longitude coordinates

by

The code defines a function called DISTANCE_BETWEEN that calculates the distance between two geographical coordinates on the Earth’s surface using the Haversine formula. Here’s a step-by-step breakdown of the code: Define a constant earthRadius with a value of 6371, representing the Earth’s radius in kilometers. Calculate the difference in latitude (dLat) and longitude (dLon) between … Read more

Add a new column before and after in sheets

by

function addColumn() {const ss = SpreadsheetApp.getActiveSpreadsheet();const sheet = ss.getSheets()[0];const sheetName = sheet.getName();sheet.insertColumnBefore(1);const lastCol = sheet.getMaxColumns();sheet.insertColumnAfter(lastCol);sheet.getRange(1,1).setValue(‘FIRST’);sheet.getRange(1,lastCol+1).setValue(‘LAST’);Logger.log(lastCol);} https://github.com/lsvekis/Google-Apps-Script/blob/main/2023Apr/Add%20a%20new%20column%20before%20and%20after%20in%20sheets

How to Grow Your YouTube Channel

by

How to Grow Your YouTube Channel Growing a YouTube channel requires a well-planned strategy that takes into account various factors such as content creation, audience engagement, promotion, and optimization. Here is an outline of a YouTube channel strategy that can help you grow your channel: By following these strategies, you can grow your YouTube channel … Read more

55 Google Apps Script Videos Playlist from YouTube Learn more about apps Script

by

Google Apps Script is a scripting language based on JavaScript that allows users to extend and automate the functionality of various Google services such as Sheets, Docs, Forms, and Gmail. It provides a wide range of services and methods for interacting with Google Apps and allows users to create custom scripts and applications that integrate … Read more