Author: eguweb
-
Google Spreadsheet How to calculate total operating hours (working hours) from the displayed time (hh:mm)
This method calculates work hours from the displayed time (hh:mm). Time clocked out – Time clocked in So, let’s subtract the time of leaving work – time of coming to work. I got a result that looks like that. Let’s continue. What is the total operating hours (working hours)…? If we add up the working…
-
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 is used to create strategies based on graphs. This ABC analysis, also known as “priority analysis,” is a method of analyzing the financial importance of raw materials, products (goods), etc. in…
-
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. What type of business is the hotel in? Hotel industry: lodging, food services, and accommodation Major classification Medium Category Lodging and food services lodging business What is the job title of the hotel? Hotel occupations: sales, marketing, and…
-
[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 create a state like this. For example, if you want to synchronize the state of two files (to make the data in the sheet the same state), it seems that such a function is not found in…
-
![[Google Spreadsheet] A convenient function to extract and display titles from the article list | IMPORTXML function](//en.eguweb.jp/wp-content/plugins/a3-lazy-load/assets/images/lazy_placeholder.gif)
[Google Spreadsheet] A convenient function to extract and display titles from the article list | IMPORTXML function
When you want to get all the page titles from the list of URLs at once, you can use the convenient function “IMPORTXML function” unique to Google Sheets. What is the IMPORTXML function? =IMPORTXML(“URL”, “XPath query”) A function that can extract specific data from a website page using specific conditions (XPath query). It is commonly called ” scraping “. *Scraping is prohibited on…
-
[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 email arrives in Gmail and marking it as read”. Use LINE Notify This time, I will try using “LINE Notify”, which has been indebted to me before. LINE NotifyLINE Notify is a convenient…
-
[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 be shifted to the left, and the position of the image may not match. deviate due to You can use CSS to center it. Adjust with additional CSS First, find the CSS class…
-
[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 specified date…? You can easily count down! DAYS function The DAYS function returns the number of days between two dates. Arguments of the DAYS function DAYS(終了日,開始日) [rml_read_more] argument explanation 終了日 Specifies the end of the…
-
[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, end date, [weekend], [holiday]) Returns the net number of workdays between two specified dates , excluding certain weekends and holidays . Only available in the new Google Sheets. function =NETWORKDAYS.INTL(B3,B4) result twenty three value 1 2019/01/01 value 2 2019/01/31 DATE =DATE(year, month,…
-
[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 think that’s what it feels like. The method is to use Google Form as a hub and create an inquiry form. Create Google Form First, create a Google Form that will serve…
-
[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 such a case. 1. Set the text color of the cell to “white” It’s a simple idea, but if you set the text color of the cell to “white”,…
-
[Google Sheets] How to use the Importrange function! Useful import functions
import range function It is useful when you want to pull out and display data from another Google Spreadsheet in Google Spreadsheet ! This is the “Importrange function”. How to use the importrange function =Importrange(“sheet key”,”sheet name!range”) spreadsheet key – Specify the URL of the spreadsheet from which to load data. spreadsheet key The value of must be enclosed…
-
GAS (Google ActionScript) “This application has not been verified” This application has not been verified by Google. This app has not been confirmed by Google.
This application has not been verified This app has not been verified.This app has not been verified by Google. Please continue only if you are a trusted developer with whom you are familiar. If you are a developer, please send a confirmation request to prevent this screen from appearing. This is what to do if…
-
[Introduction to Google Sheets] What is Google Sheets?
What is Google Sheets Google Sheets is “an online spreadsheet app that allows you to create, format, and collaborate with others at the same time on your spreadsheets.” It is a tool developed by Google, and anyone with a Google account can use it for free. The Biggest Benefits of Google Sheets The biggest advantage…
![[Google Spreadsheet] A convenient function to extract and display titles from the article list | IMPORTXML function](https://en.eguweb.jp/wp-content/uploads/202109252131-00-1024x701-1.jpg)
![[Google Spreadsheet] I want to count down the number of days left from a specified date! ｜DAYS function & NOW function](https://en.eguweb.jp/wp-content/uploads/202007301813-00-1.jpg)