GoogleSpreadSheet Google Spreadsheet Create parade charts and ABC analysis graphs from tables｜Priority Analysis
What is ABC analysis? ABC analysis is based on the concept that the top 20% of sales account for 80% of total sales, and...
GoogleSpreadSheet Job What are the types of businesses and occupations in hotels? About the type of business and occupation
In this issue, we will discuss the industries and occupations of hotels, hoteliers, hotel receptionists, innkeepers, etc...
GAS [GAS] Operational efficiency! How to Synchronize Value Data in Two Google Spreadsheets in Two Ways [1/2]
It's a familiar and convenient Google Spreadsheet, but this time it's a synchronization script?I will show you how to cr...
GoogleSpreadSheet [Google Spreadsheet] A convenient function to extract and display titles from the article list | IMPORTXML function
When you want to getall the pagetitlesfrom the list ofURLs at once, you can use the convenient function "IMPORTXML funct...
GAS [GAS] [PART1] Create and run a bot with LINEnotify that notifies LINE when a specific email arrives at Gmail and marks it as read
Anyway, these days I want to automate various things, but this time it is a method of "notifying LINE when a specific em...
WordPress [Cocoon] How to center the image caption | WordPress caption position
Although it is not limited to Cocoon themes, depending on the theme, the position of the caption placed in the image may...
GoogleSpreadSheet [Google Spreadsheet] I want to count down the number of days left from a specified date! ｜DAYS function & NOW function
If you use Google Spreadsheet (commonly known as Google Sheet Spreadsheet), how many more days will it take to reach the...
GoogleSpreadSheet [Google Sheets] List of functions related to dates
We have compiled a list of functions related to "date" in Google Sheets! NETWORKDAYS.INTL =NETWORKDAYS.INTL(start date, ...
GAS [GAS] How to send data from your own inquiry form using Google Forms
Inquiry form creation Usually when you try to create a contact form 1.2. Set up a server.Build a contact form in PHP I t...
Excel [Introduction to EXCEL] Two methods to hide cells with values in them
I want to hide it from the screen while keeping the value in the cell with EXCEL. It is a technique that can be used in ...