Starting a Sidebar in Google Apps Script

Starting an Apps Script Sidebar

Starting a sidebar takes one HTML file, and a script file containing just two Apps Script functions. The Apps Script functions: function onOpen() { SpreadsheetApp.getUi()   .createMenu(“Example Menu”)   .addItem(“Menu Item”, “exampleSidebar”)   .addToUi(); } function exampleSidebar() { let sidebar =  HtmlService.createHtmlOutputFromFile(“ExampleHTML”); SpreadsheetApp.getUi().showSidebar(sidebar.setTitle(“The Sidebar Title”)); } The HTML file (exampleHTML.html): <!DOCTYPE html> <html> <head>   … Read more

Google Apps Script Code, My Commonly Used

Google Apps Script Sidebar

Some of my commonly used Google Apps Script code: Sidebar: function onOpen() {   SpreadsheetApp.getUi()   .createMenu(“OnTheMenuBar”)   .addItem(“The item on the drop down”, “CallTheHTMLfile”)   .addToUi(); } function CallTheHTMLfile() { let sidebar =  HtmlService.createHtmlOutputFromFile(“index”); SpreadsheetApp.getUi().showSidebar(sidebar.setTitle(“What shows on top of the sidebar”)); } Global Variables: By itself out of any function at the top of … Read more

BigQuery Backend, Google Sheets Frontend?

A collection of references: Real Time Google Sheets Data Exported to BigQuery, Displayed in Google Data Studio [YouTube] De’Lon Dixon [LinkedIn] Connect and transfer data from Google Sheets to BigQuery [OptimizeSmart.com] Himanshu Sharma [LinkedIn] How are you Loading data to BigQuery? [Reddit/r/bigquery]

Nevada Power dba NV Energy – Recent Tariffs

PUCN Example Tariff

Public Utilities Commission of Nevada (PUCN) approved tariffs for Nevada Power dba NV Energy (Southern Nevada). Effective Date: April 1, 2023 [PDF] January 1, 2023 [PDF] October 1, 2022 [PDF] July 1, 2022 [PDF] April 1, 2022 [PDF] January 1, 2022 [PDF] January 1, 2022 Sched. ESER [PDF] Source: PUCN Docket https://pucweb1.state.nv.us/puc2/Dktinfo.aspx?Util=All Search on page … Read more

Nevada Senate 21 – Assembly 12 and 14 – Voter Registration and Turnout

Map and data table of Nevada State Senate and Assembly District voter registration information

Nevada Senate 21 – Assembly 12 and 14 – Voter Registration and Turnout This post contains active voter registration and active voter turnout information for: Nevada Senate District 21 Assembly District 12 Assembly District 14 Data was sourced from the Nevada Clark County Election Department’s Voter List. https://www.clarkcountynv.gov/government/departments/elections/index.php Only data for registered voters that the … Read more

Nevada Senate 18 – Assembly 4 and 13 – Voter Registration and Turnout

Map and data table of Nevada State Senate and Assembly District voter registration information

Nevada Senate 18 – Assembly 4 and 13 – Voter Registration and Turnout   This post contains active voter registration and active voter turnout information for: Nevada Senate District 18 Assembly District 4 Assembly District 13 Data was sourced from the Nevada Clark County Election Department’s Voter List. https://www.clarkcountynv.gov/government/departments/elections/index.php Only data for registered voters that … Read more

Nevada Senate 12 – Assembly 21 and 41 – Voter Registration and Turnout

Map and data table of Nevada State Senate and Assembly District voter registration information

Nevada Senate 12 – Assembly 21 and 41 – Voter Registration and Turnout This post contains active voter registration and active voter turnout information for: Nevada Senate District 12 Assembly District 21 Assembly District 41 Data was sourced from the Nevada Clark County Election Department’s Voter List. https://www.clarkcountynv.gov/government/departments/elections/index.php Only data for registered voters that the … Read more