| Abbrev | Meaning | Additional information |
|---|---|---|
| SCOL | Sheet column | Refers to a column inside of the sheet. |
| TCOL | Table column | 1 Refers to a column inside of a table in the sheet. |
| FM | Formula | 2 A Google Sheets Formula. |
| DN | Domain name | 3 A domain name. |
| TLD | Top-level domain | 4 A domain "extension", e.g. COM or NET. |
| CUR | Currency | A monetary cost. |
| Int | Integer | A number, a.k.a. an integer value |
| Str | String | A sequence of characters, a.k.a. "plain text". |
Tip
For the sake of legibility, a number of abbreviations are used in this document.
Note
In table below briefly describes how to interpret the TCOL table. Less self-explanatory columns are emphasized.
| Col | Description |
|---|---|
| Col | Sheet column (SCOL) letter |
| Name | Table column (TCOL) name |
| Auto | Is TCOL populated for you (i.e. do you have to enter data) |
| Purpose | What is TCOL generally used for? |
| Type (⛔) | Type of data you have to enter |
| Type (✅) | Type of data the formula returns |
| Notes | Description of TCOL's purpose |
Important
This table describes how the data is entered manually (or created with a formula) inside each of the sheet's tables.
| Col | Name | Auto | Purpose | Type | Notes |
|---|---|---|---|---|---|
A |
Name | ⛔ | Data | String | DOMAIN.TLD |
B |
Months | ✅ | Info | FM: Date | How long until expiry? |
C |
Expiry | ⛔ | Renewal | Date | YYYY/MM/DD |
D |
Cost | ⛔ | Renewal | String | Cost to renew (annual) |
E |
Registrar | ⛔ | Renewal | Dropdown | Current registrar name? |
F |
Transfer? | ⛔ | Renewal | Dropdown | Do you want to transfer? |
G |
In use? | ⛔ | Renewal | Dropdown | What do you use it for? |
H |
Renewing? | ⛔ | Renewal | Dropdown | Do you want to renew it? |
I |
Details | ⛔ | Notes | String | Notes about domain |
| ━ | ━━━━━━━ | ━ | ━━━━ | ━━━━━ | ━━━━━━━━━━━━━━ |
L |
TLD | ✅ | Data | FM: Str | TLD |
M |
DN in TLD | ✅ | Info | FM: Int | Number of DN in TLD |
N |
Next Expiry | ✅ | Info | FM: Date | Closest expiry for any DN.TLD |
O |
Average Cost | ✅ | Info | FM: CUR | Average cost for DN in TLD |
| ━ | ━━━━━━━ | ━ | ━━━━ | ━━━━━ | ━━━━━━━━━━━━━━ |
P |
Renewal Month | ⁿ/ₐ | Data | String | List of months |
Q |
DN in Month | ✅ | Info | FM: Int | Number of DN in TLD |
R |
Any Year | ✅ | Cost | FM: CUR | Total / month |
S |
This Year | ✅ | Cost | FM: CUR | Unpaid / current year |
T |
Next 12mo | ✅ | Cost | FM: CUR | Unpaid / next 12mo |
U |
DN in Year | ✅ | Info | FM: Int | Number of DN in TLD |