Author: eguweb
-
Here are some basic concepts and features of JavaScript that you should remember
1. Variables Variables are used to store data values. let name = “Alice”;const age = 25;var isStudent = true; 2. Data Types JavaScript has several data types including: 3. Operators Operators are used to perform operations on variables and values. 4. Functions Functions are blocks of code designed to perform a particular task. function greet(name)…
-
Counting the number of days in a month by combining the DAY and EOMONTH functions (spreadsheet)
To count the days of a month using a combination of functions DAYin Google Sheets , follow these steps:EOMONTHtable of contents Using the EOMONTH function Using the EOMONTH function : EOMONTHThe function returns the date of the last day of a particular month. This function takes as arguments a specific date (e.g. “2024-02-01”) and a number to add or…
-
[SEO] What is the probability and percentage of clicks in the search ranking? ｜The most important results
“The click rate for the first place in the search ranking is 28.5%” Sistrix, a digital market research company, analyzed over 80 million keywords and billions of search results to study the click-through rate of search results, and found that there was a 10-fold difference in click-through rate between the 1st and 10th search results.…
-
[FILTER function] How to perform a “fuzzy search” in combination with the FIND function (Google Spreadsheet)
This is a method for fuzzy search (extraction) with the FILTER function. What is the FILTER function? You can use the FILTER function to extract the result of a specific condition from within a range. By using the FILTER function of Google Sheets, you can extract the result of the specified value from the table.…
-
Google Spreadsheet Compound Interest Calculation｜How to perform compound interest calculations (simple version)
In this article, we will introduce compound interest and compound interest calculations. What is compound interest? Compound interest (or compound interest) refers to interest calculated using the compound interest method, whereby interest generated by the principal is incorporated into the principal in the next period and interest is also earned on the interest. The gradual…
-
SEO Strategies from Google’s Mission｜Google’s Mission and 10 Facts
When it comes to SEO, measures in areas such as “title,” “description,” and “meta tag settings” are among the typical measures, but knowing Google’s thoughts on SEO will lead to one clue for the strategy. What is Google’s mission? Google’s mission is stated as follows Google’s mission is to organize the world’s information and make…
-
Google Spreadsheet What is the maximum number of rows? Verification of the maximum number of rows
Maximum number of rows in a Google Spreadsheet workbook How far can the maximum number of rows in a Google Spreadsheet workbook go? I have verified the following. So, let’s try to add 1,000,000 rows as a trial. Yes, … suddenly we have the answer: it seems to be that 5000000 cells is the upper…
-
What is NPV (Net Present Value)?
What is NPV (Net Present Value)? NPV (Net Present Value) is how much profit you can get from your investment. It is an index that shows It refers to the amount obtained by subtracting the initial cost (investment amount) from the total present value of the cash flow generated by the project of the investment target business .…
-
PremierePro How to Easily Replace Timeline Placed Images and Videos
Replace with clip If you want to replace an image that has already been placed with another image, you can use the “Replace with Clip” function. Show source monitor First, display the image you want to replace in the “Source Monitor” panel. Clip > Replace with Clip Select “Replace with Clip” from the top menu…
-
Windows 10 How to Extract a tgz File ｜Lhaplus
What is a tgz file? TAR archive (compressed) files compressed with Gnu Zip (tgz) software. Here is how to unzip this file. Lhaplus can defrost You can unzip files with Lhaplus, your go-to file unzip tool! You can download and install the software from the link below. https://forest.watch.impress.co.jp/library/software/lhaplus/ After downloading the installation file, install the…
-
How to put a password on a USB memory stick or external hard drive so that only you can see the files inside.
Recently, external USB memory sticks and external HDDs (SSDs) can be purchased inexpensively, but if they are lost or misplaced somewhere, it can be a big problem. Learn how to encrypt and password protect data on an external HDD (SSD). Windows 10 (Pro) or higher comes standard. BitLocker To Go A function that allows encryption…
-
Google Spreadsheet How to display sheet names by cell reference [Can also be used in Excel] INDIRECT function
You may often refer to data from other sheets in Google Spreadsheet or Excel. In such cases, here is how to reference the sheet name from the cell value. Normal other sheet references If you want to refer to data on another sheet, you can use input methods such as “‘sheet name’! cell number” or…
-
Fatal error: Maximum execution time of 30 seconds exceeded in…
Fatal error: Maximum execution time of 30 seconds exceeded in … is what to do if you get a… Fatal error. The maximum execution time of 30 seconds has been exceeded… What does that mean? Fatal error: Maximum execution time of 30 seconds exceeded in …” is an error that occurs when PHP processing has…
-
What is the type of business or occupation of a teacher? Type of business or occupation
What type of business or occupation does a teacher…? Teachers Industry: Education, Learning Support Major classification Medium Category education Learning Support Industry What is the occupation of the teacher(s)? Teachers Occupation: Teaching Major classification Medium Category Others (teachers, civil servants, etc.) education There may be discrepancies, so please be sure to check with the relevant…
-
Two ways to make a cell invisible (hidden) with its value still in it Excel
You want to keep a value in a cell in EXCEL (Excel) but hide it from the screen. This is a technique you can use in such a case. (1) Set the cell text color to “white” It is a simple idea, but if you set the text color of a cell to “white”, it…
-
GAS Using Slack’s Outgoing Webhook API to Write Posts in Google Spreadsheets｜Part2
Slack had a convenient API “Outgoing Webhook” that we can use when we want to “write messages posted to a Slack channel into a Google Spreadsheet. Previously, we have completed the preparation of “Outgoing Webhook”, so we will continue to make it. Create a new GAS Once the “Outgoing Webhook” in Slack is ready, the…
-
[Google Spreadsheet] Create parade charts and ABC analysis graphs from tables | Priority analysis
What is ABC Analysis? “ABC analysis” is the idea that “the top 20% of sales account for 80% of the total”, and is used when formulating strategies based on graphs. This ABC analysis, also known as ” priority analysis “, is a method of analyzing the financial importance of raw materials, products (merchandise), etc. in inventory management.…
-
[GAS] Write posts to Google Spreadsheet using Slack’s Outgoing Webhook API | Part2
Slack has a convenient API “Outgoing Webhook” that you can use when you want to write messages posted on Slack’s channel to Google Spreadsheet. Up to the last time, preparations for “Outgoing Webhook” have been completed, so let’s continue. Create a new gas Once Slack’s “Outgoing Webhook” is ready, we will prepare the GAS side.…
-
[GAS] Write posts to Google Spreadsheet using Slack’s Outgoing Webhook API | Part 1
Slack has a convenient API “Outgoing Webhook” that you can use when you want to write messages posted on Slack’s channel to Google Spreadsheet. What are Outgoing Webhooks? An API/service for sending Slack messages to external services in the Slack App directory. Outgoing WebhooksOutgoing webhooks was a quirky way to send your own server a…
-
[Google Spreadsheet] QUERY function | Query list/Summary
List of APIs that can be used with the QUERY function So far, we have practiced how to use and apply the QUERY function. The QUERY function uses the query language of the Google Visualization API to query the entire data. This time, I will summarize the “Query language of the Google Visualization API” as a…
-
[Google Spreadsheet] QUERY function | Query list Part 2 (WHERE clause)
You can extract data from a range with the QUERY function The QUERY function “uses the query language of the Google Visualization API to query the entire data”. I’ve introduced it before, but I would like to try it out by actually using it using a query. This time , I would like to extract data…
-
[Google Spreadsheet] QUERY function | Query list Part 1 (SELECT clause)
You can extract data from a range with the QUERY function The QUERY function “uses the query language of the Google Visualization API to query the entire data”. I’ve introduced it before, but I would like to try using other queries and actually using them. This time , I would like to extract data from the Tokyo…
-
What is “CSR”? About the SSL certificate (public key certificate) of the rental server
This time, we will introduce “CSR” when acquiring SSL. What is SSL? SSL is an abbreviation of “Secure Sockets Layer”, and is one of the mechanisms to encrypt the communication of the website and secure the password input and form communication. By having the rental server issue a certificate called “SSL server certificate”, you will…
-
[GAS] How to delete all labels created in Gmail | [Caution]
For example, it is a method that can be used when you want to delete the label created in Gmail at once. Function to delete Gmail label｜deleteLabel() GAS has a function for removing Gmail labels. You can use this to delete currently created labels. Get current labels (GmailApp.getUserLabels) First, get the current label. Labels can be…
-
[WordPress] Start a Blog Post (Post/Basics) Part 1
After installing WordPress and building the environment, let’s start posting! Blog posting is possible with just a smartphone. What is a “Post” in WordPress? “Post” in WordPress is a function that is mainly used to create web pages that are updated daily, such as “blogs”, “notices”, and “events”. When you open the “Posts” menu on the…
-
[GAS] How to create a label with Gmail [Basics]
How to create Gmail labels with GAS (GoogleAppsScript). GmailApp.createLabel(label name) You can create a label by using ‘GmailApp.createLabel(name)’. Just by executing this, the label name of the argument is newly created. Create a function that creates labels Create a function that creates labels. I’ll try it. At the time of execution, as usual, a confirmation…
-
[Mac] Shortcut key to select and delete characters and text at once
This is a convenient shortcut key for selecting or deleting characters in bulk on a Mac. remove everything from the textbox In this case, there are two ways (maybe there are others…?) ①Move the cursor position to the far right → “command + delete” Delete everything to the left of the selected cursor position ②…
-
CONCAT function”, “CONCATENATE function”, “TEXTJOIN function” functions to combine strings [Spreadsheet].
When you want to join cell data of columns and rows in Google Spreadsheet, you can use “& (Ambasand)” to join them, but this function can be used when you want to join multiple columns together. CONCAT Function The CONCAT function can be used to combine multiple ranges or strings of text. However, with the…
-
[MTS Simple Booking Plugin] A convenient plugin that allows you to introduce a reservation system to your WordPress site | Part2
Up to the last time, I was able to create a reservation item using the “MTS Simple Booking plug-in”. We will continue to set. * “MTS Simple Booking C Plugin” is plug-in software that adds a reservation system to WordPress. Setting schedule management After creating a reservation item, the next step is to set the schedule. After…
-
[MTS Simple Booking Plugin] A convenient plugin that allows you to introduce a reservation system to your WordPress site | Part 1
One of the convenient plugins that you can use when you want to introduce a reservation system in WordPress is the “MTS Simple Booking Plugin”. What is the MTS Simple Booking Plugin? “MTS Simple Booking C Plugin” is plugin software that adds a reservation system to WordPress. You can download the plug-in from the site below.…
![[SEO] What is the probability and percentage of clicks in the search ranking? ｜The most important results](https://en.eguweb.jp/wp-content/uploads/23611406_s.jpg)
![[FILTER function] How to perform a “fuzzy search” in combination with the FIND function (Google Spreadsheet)](https://en.eguweb.jp/wp-content/uploads/202210231841-01-1024x774-1.webp)
![Google Spreadsheet How to display sheet names by cell reference [Can also be used in Excel] INDIRECT function](https://en.eguweb.jp/wp-content/uploads/202203201546-01.jpg)
![[Google Spreadsheet] Create parade charts and ABC analysis graphs from tables | Priority analysis](https://en.eguweb.jp/wp-content/uploads/202010201112-00.jpg)
![[GAS] Write posts to Google Spreadsheet using Slack’s Outgoing Webhook API | Part2](https://en.eguweb.jp/wp-content/uploads/スクリーンショット-2022-10-14-8.51.12-1024x458-1.jpg)