Skip to main content

Google Sheets: Notes

"Google Sheets is a web-based application that enables users to create, update and modify spreadsheets and share the data online in real time." — TechTarget

>>> To create a new worksheet, access https://sheets.google.com/new

>>> Calculate number of days, months, or years between two dates

=DATEDIF(start_date; end_date; unit)

 DATE DIFFERENCE: Calculates the number of days, months, or years between two dates.
start_date: from date
end_date: to date
unit: DAY, MONTH, YEAR...

>>> Get value from "Price" sheet, 'N2' cell.

var cellValue = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Price").getRange('N2').getValue();
// Logger.log(cellValue);

>>> GOOGLEFINANCE function: https://spreadsheetpoint.com/googlefinance-function-guide/

>>> IMPORTHTML: Imports data from a table or list within an HTML page.

>>> CANNOT DIRECTLY insert special characters in Google Sheets, but CAN copy & paste special characters.

Labels:

Popular posts from this blog

RHEL: Install MySQL

[tuyendq@DangQuocTuyen ~]$ sudo yum list mysql Loaded plugins: product-id, search-disabled-repos, subscription-manager Error: No matching Packages to list [tuyendq@DangQuocTuyen ~]$ sudo yum install mysql Loaded plugins: product-id, search-disabled-repos, subscription-manager Resolving Dependencies --> Running transaction check ---> Package mariadb.x86_64 1:5.5.60-1.el7_5 will be installed --> Processing Dependency: mariadb-libs(x86-64) = 1:5.5.60-1.el7_5 for package: 1:mariadb-5.5.60-1.el7_5.x86_64 --> Running transaction check ---> Package mariadb-libs.x86_64 1:5.5.60-1.el7_5 will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================================= Package Arch Version Repository Size ================================...
Read more

American Accent Training Resources

American Accent Training Book and CDs American Accent Training by Ann Cook Rebecca Linquist https://www.youtube.com/user/rebeccalinquist LISA’S YOUTUBE VIDEOS http://www.accurateenglish.com/lisas-youtube-videos/ Rachel's English Youtube Channel https://www.youtube.com/user/rachelsenglish Accent Ace https://www.youtube.com/user/AccentAceConfidence Practice American English sounds with free video lessons by Cheryl A. Posey http://www.speakingyourbest.com/freevideolessons.html Shaw English Online https://www.youtube.com/user/ShawEducation Pronunciation Pro https://www.youtube.com/user/pronunciationpro Heather Hansen https://www.youtube.com/user/heatherhansen
Read more

IBM Domino: Exprired password

Your account is locked out if you do not change your expired password. IBM Notes: Password is expired Account is locked out when password is expired Example of password policy
Read more