Google Spreadsheets

Basic usage in Google Spreadsheets

This page shows you the basic usage of STURY’s Google Spreads template.

How to use “Annual record”

The “Annual record” sheet has almost the same function as the “Half yearly record” sheet, so please refer to the “Half yearly record” for details.

You can change the “sheet name” of each sheet to any name you like.

The sheet switching is located at the bottom of the screen!

The light green cells are the parts that you type in manually. The rest of the sheet contains formulas and is set up (sheet protection) so that you can’t accidentally delete them.
If you try to edit any other part of the sheet, you will get a message saying, “You’re trying to edit part of this sheet that shouldn’t be changed accidentally. Edit anyway?”
If you do, you will get a warning message. If you want to edit it, click “OK”. If you don’t want to edit it, click “Cancel”.

How to use “Half yearly record”

Make sure that the “○○” in the third line corresponds to the sheet name. If it does not correspond to the sheet name, it will not be reflected in the formula and an error will occur.

The total number of minutes you have studied on that day will be displayed in the data bar.

The color scale will be displayed. The more you have studied, the darker the orange color will be displayed.

Please use the memo fields as appropriate.

se the “~~ sheet”

This sheet will be the one that you will update manually on a daily basis.

List the units of study here. By default, it is 1-10 pages, 11-20 pages, …. Personally, I think it is easier to understand and feel a sense of accomplishment if the unit is small and easy to understand, such as every 5 pages or every 10 pages.

In column C, enter the date of the first study. Then, the date will be automatically entered in columns D, F, H, J, L, and N.
For example, when you finish studying in column D, write the date or “0” or whatever in column E right next to it, and it will change to blue.
It will turn yellow on the day you need to study, and red if you don’t study and it has passed.

By default, I made more than the day, 1 day, 3 days, 1 week, 2 weeks, and 4 weeks, but if you want to reduce the number, you can hide the whole column instead of deleting it.
If you want to reduce the number of columns, you can hide the whole column instead of deleting it. Personally, I think four is enough: same day, 1 day, 1 week, and 4 weeks.

How to use the “~~ sheet” Part 2

When scrolling, the AB column and up to the third row are fixed.
To remove the fixation, press [View] > [Freeze] > [No Rows] or [No Columns].
If you want to fix it again, with B3 cell selected, press [View]> [Freeze]> [Up to current row (3)] and [Up to current column (B)].

The expression is included until the 200th line.

That’s all for the basic usage, but for detailed customization, please see the following pages.