Entries by admin

Google Sheets Apps Script – Dynamic Dependent Dropdown Data Validation Lists

Learn how to assign data validation using Apps Scripts and create dynamic dependent dropdown lists for the whole column for Google Sheets.

Understand How This Script Works  

Google Sheets Apps Script – Combine Multiple Tabs to a Master Tab When Column Positions Don’t Match

Results of Apps Script tutorial to combine multiple worksheets to a master sheet. It will also work when column positions don’t match.

Understand How This Script Works

Google Sheets Get Distance & Time – GOOGLEMAPS Function

Add the following code to your Apps Script Editor first and then use the function.

How to Use GOOGLEMAPS Function? Understand How This Script Works

Google Sheets Import JSON – IMPORTJSON Function

Add the following code to your Apps Script Editor first and then use the function.

How to Use IMPORTJSON Function? Understand How This Script Works

Average Salaries – City of Chicago Fire Police Department Earnings

This data is compiled using public dataset released by the City of Chicago Date Created 2/28/2017 Position Average Salary # Employed FIRST DEPUTY SUPERINTENDENT $197,724 1 CHIEF $185,364 5 GENERAL COUNSEL $170,112 1 DEPUTY CHIEF $168,835 17 SUPERINTENDENT’S CHIEF OF STAFF $162,012 1 COMMANDER $161,324 40 DIR OF HUMAN RESOURCES $150,396 1 DIR OF CAPS $145,476 […]

Average Salaries – City of Chicago Fire Department Earnings

This data is compiled using public dataset released by the City of Chicago Date Created 2/24/2017 Position Average Salary # Employed FIRE COMMISSIONER $202,728 1 FIRST DEPUTY FIRE COMMISSIONER $197,736 1 DEPUTY FIRE COMMISSIONER $187,680 3 ASST DEPUTY FIRE COMMISSIONER $185,352 3 DISTRICT CHIEF $170,112 11 DEPUTY COMMISSIONER $161,886 2 COORD OF AIR MASK SERVICES $157,776 […]