Tips

• To insert current date: Ctrl+;
• To insert current time: Ctrl+Shift+;
• To add today’s date in such a way that it updates when you recalculate or reopen your spreadsheet: =Today()

Usage

XLOOKUP

=XLOOKUP(lookup_value,lookup_array,return_array,if_not_found,match_mode,search_mode)

Models

What’s the difference between GK420d and GK420t?

GK420d = direct thermal (no printer ribbon facility), requires labels to be made from a direct thermal material in order to create print.

Netlify is a web developer platform that multiplies productivity.

Netlify provides continuous deployment services, global CDN, atomic deploys, instant cache invalidation, one-click SSL, a browser-based interface, and many other features for managing our Hugo website.

Startup

1. Open all PowerPoints
   • Worship PowerPoint
   • Message PowerPoint
   • Downloading the songs beforehand if any.
2. Start OBS and VirtualCam
3. Start VoiceMeter
4. Login to Zoom

Settings

PowerPoint Settings

NOTE:

1. Intro

Python Crash Course 2E Study Notes

Interpreter

C:\Users\Andrew>python
Python 3.8.2 (tags/v3.8.2:7b3ab59, Feb 25 2020, 23:03:10) [MSC v.1916 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>>

Tools

• https://repl.it/languages/python3
• https://www.jetbrains.com/pycharm/

Run Code

python hello.py

2. Variable and Simple Data Types

Naming and Variables

• Start with string or underscore
• Can use string, underscore, and number thereafter

String

# String literals in python are surrounded by either single quotation marks, 
# or double quotation marks.
"Hello"
'World'

String Methods

s="hello, World"
s.upper()
s.lower()
s.title()

f String

first_name = "ada"
last_name = "lovelace"
full_name = f"{first_name} {last_name}"
message = f"Hello, {full_name.title()}!"
print(message)

Tabs and Newlines

>>> Print("Hello, Eric's wife!")
Hello, Eric's wife!
>>> print("\tHello,\n\tWorld!")
    Hello,
    World!

Stripping Space

>> s=" Andrew "
>> s.rstrip()
' Andrew'
>> s.lstrip()
'Andrew '
>> s.strip()
'Andrew'

Number

Interger

1+2
3-1
4*5
7/8 # 0.875
9**3 # 729
(8+9)*3 # 51

Float

• Python defaults to a float in any operation that uses a float, even if the output is a whole number.
• you can group digits using underscores to make large numbers more readable

0.1*2 # 0.2
0.1+0.1 # 0.2

# arbitrary number of decimal may places in your result
3*0.1 # 0.30000000000000004
0.1+0.2 # 0.30000000000000004

# Divide any two integer get float
4/2 # 2.0
# Mix integer and float: get float
3+1.0 # 4.0

# Multiple assignment
x, y, z = 0, 0, 0

Constants

• No built-in constant types
• Convention: Use all capital letters

MAX_CONNECTS = 20

Comments

Use # to comment code. Anything after # are ignored.

In this COVID-19 pandemic season, to comply with new social distancing measures, churches around the world have sent their congregants home.

The COVID-19 will stir those churches to seize this unprecedented opportunity to embrace change. It is crucial for churches to lift up online giving not just as a convenience but as a theologically sound way to give.

How to change terminal PowerShell?

Download

Shotcut to fix the highlighted/underline code

Press Alt + Enter when your caret is at the underlined or highlighted text to see how GoLand suggests fixing it.

Git

How to remove Git submodule from a project?

I use go module

require github.com/McShelby/hugo-theme-relearn v0.0.0-20230328175528-8d474ed3b16b // indirect

# Remove the submodule entry from .git/config
git submodule deinit -f themes/hugo-theme-relearn

# Remove the entry in .gitmodules
git rm -f themes/hugo-theme-relearn

# Remove the submodule directory from the .git/modules directory
rd /s .git\modules\themes\hugo-theme-relearn

Git Branch

git branch // list all branches; = git branch --list
git branch new-branch // create a new branch
git checkout -b new-branch main
git checkout new-branch // switch to new-branch
git branch -d old-branch // delete old-branch; there'll be error if the branch hasn't been merged
git branch -D old-branch // force delete the old-branch

git push origin --delete old-branch // delete the old-branch in remote repos

Git Merge

• fast-forward merge

git checkout -b new-feature main
// add / modify / delete files in this new branch and commit them
git checkout main
git merge new-feature
git branch -d new-feature

Adding Files

// To stage all files(including all files in subdirectories) in your repository, 
// which includes all new, modified, and deleted files
git add -A

// To stages files in the current directory and not any subdirectories
// It also removes a file from your repository if it no longer exists in the project
git add .

// By adding the --ignore-removal option, which will only stage new and modified files:
git add --ignore-removal .

// To stage only the Modified and Deleted Files, but not any new files
git add -u

// Adding file by wildcard
git add *.html

// To add all JavaScript files, including those in subdirectories:
git add **/*.js

Tag

// lightweight tag
git tag v0.1

// create annotated tag
git tag -a v0.2 -m "my version 0.2"

// show tags
git tag

// show tag details
git show v1.0

How to rename a git tag

To rename git tag v0.2 to v1.0

FFmpeg is a free and open-source software. It’s a very fast video and audio converter that can also grab from a live audio/video source. It can also convert between arbitrary sample rates and resize video on the fly with a high quality polyphase filter.

There’re lots of free services that you can host your static website:

• GitHub Pages
• Netlify
• Gitlab

And many more. See Hugo Hosting & Deployment

I’ll show you how to deploy your website to Gitlab Pages. GitLab Pages is a feature that allows you to publish static websites directly from a repository in GitLab. It’s the easiest way to get your website up and running.