Circle of 5ths

 Examples using Circle of 5ths https://www.youtube.com/watch?v=-DQJmicTFGQ

Most Elegant Key Change

Take Five

Import Vector Graphics image from Solidwords Drawing to Word

 Inside Solidworks, create the drawing. Print it to PDF. You may want to change the orientation to Portrait

Inside Adobe Acrobat Pro, clean whatever you don't want in the pdf.

Inside MS Word, open PDF and chose the option to convert to word document.

It will bring it in as an image on a page. Now you can add text to that page.

OneNote Math Operations

 

Supported arithmetic operators

Operator	Meaning	Example
+ (plus sign)	Addition	3+3
- (minus sign)	Subtraction Negation	3-1 -1
* (asterisk)	Multiplication	3*3
X (upper- or lowercase)	Multiplication	3x3
/ (forward slash)	Division	3/3
% (percent sign)	Percent	20%
^ (caret)	Exponentiation	3^2
! (exclamation)	Factorial computation	5!

Supported math and trigonometry functions

Function	Description	Syntax
ABS	Returns the absolute value of a number	ABS(number)
ACOS	Returns the arccosine of a number	ACOS(number)
ASIN	Returns the arcsine of a number	ASIN(number)
ATAN	Returns the arctangent of a number	ATAN(number)
COS	Returns the cosine of a number	COS(number)
DEG	Converts an angle (in radians) to degrees	DEG(angle)
LN	Returns the natural logarithm of a number	LN(number)
LOG	Returns the natural logarithm of a number	LOG(number)
LOG2	Returns the base-2 logarithm of a number	LOG2(number)
LOG10	Returns the base-10 logarithm of a number	LOG10(number)
MOD	Returns the remainder of a division operation	(number)MOD(number)
PI	Returns the value of π as a constant	PI
PHI	Returns the value of Φ (the golden ratio)	PHI
PMT	Calculates a loan payment based on a constant interest rate, a constant number of payments, and the present value of the total amount	PMT(rate;nper;pv)
RAD	Converts an angle (in degrees) to radians	RAD(angle)
SIN	Returns the sine of the given angle	SIN(angle)
SQRT	Returns a positive square root	SQRT(number)
TAN	Returns the tangent of a number	TAN(number)

For further details, see: Insert and calculate simple math equations in OneNote

OneNote Latex Math Support

Getting into Equation Mode use <alt> and = to get into the equation editor.

Radicals: $\sum_{i=0}^n i^2 = \frac{(n^2+n)(2n+1)}{6}$ 

$x = {-b \pm \sqrt{b^2-4ac} \over 2a}$ is generated from: x = {-b \pm \sqrt{b^2-4ac} \over 2a}

For example, to get the $\sqrt[6] {64}$ (6th root of 64), you would type: \sqrt(6&64)

    See MathJax support here: https://math.meta.stackexchange.com/questions/32647/how-to-write-roots-other-than-square-roots-in-mathjax

Note that the above is the UniCode Math notation. The Latex notation of \sqrt[6]{64} does not work in OneNote

Aligning to a character, using UniCode Math

\eqarray(x+1&=2@1+2+3+y&=z@3/x&=6)<space>

which resolves to:

This can be done using the MathJax as follows:

$$\begin{eqnarray} 

y &=& x^4 + 4      \nonumber \\

&=& (x^2+2)^2 -4x^2 \nonumber \\

&\le&(x^2+2)^2    \nonumber

\end{eqnarray}$$

See: Linear format equations using UnicodeMath and LaTeX in Word

For more details, see: Unicode Nearly Plain-Text Encoding of Mathematics

OneNote Files From Locally stored to Cloud, and Back to Local Storage

OneNote for Office 365 has the capacity to store the Notebook locally. 

For a locally stored notebook, to be shared one can do the following:

Open the locally stored notebook in OneNote for Windows 10. It will automatically sync up to OneNote on the web.

At some point, you may want to be able to create a backup of this: Open OneNote for Office 365, go to File | Open | Sign In, then Search for the Notebook. Once it is open, go to File | Export | Notebook, select OneNote Package (*.onepkg). Store that to a location. You can then open it with OneNote 365.

Creating a LAMP stack on AWS Free Tier

 https://shawn-shi.medium.com/how-to-host-a-lamp-web-application-server-on-aws-ec2-for-free-8f6fc61463ed#:~:text=Its%20free%20tier%20allows%20everyone,PHP)%20automatically%20pre%2Dinstalled.

Creating a Table in MySQL and Inserting some data

 MySqlCommand cmd = new MySqlCommand("CREATE TABLE MyTable (ID Integer, Data varchar(50))", conn);

cmd.ExecuteNonQuery();

cmd = new MySqlCommand("INSERT INTO MyTable (ID, Data) VALUES (1, 'May11 2021');", conn);
cmd.ExecuteNonQuery();

Visual Studio connecting to MySQL

 Video for installing the connector:

https://youtu.be/NLv8WV43TuA

Code Project example:

https://www.codeproject.com/Articles/43438/Connect-C-to-MySQL

Code Example:

Imports System

Imports System.Data
Imports MySql.Data.MySqlClient
 
 
Module Module1
 
    Sub Main()
        Dim connstring As String = "server=sql5.freemysqlhosting.net;userid=sql5485827;password=kGXeNyGig9;database=sql5485827"
 
        Dim conn As MySqlConnection = Nothing
        Dim COMMAND As MySqlCommand
        Dim READER As MySqlDataReader
 
        Try
            conn = New MySqlConnection(connstring)
            conn.Open()
            Console.WriteLine("Connected to the Database")
            Dim Query As String
 
            Query = "insert into users (id,name) values (2,'Rhonda Rosemary')"
            COMMAND = New MySqlCommand(Query, conn)
            READER = COMMAND.ExecuteReader
            Console.WriteLine("Data Saved")
            READER.Close()
 
 
            Console.ReadLine()
            Query = "SELECT * FROM users;"
            Dim da As New MySqlDataAdapter(query, conn)
            Dim ds As New DataSet()
            da.Fill(ds, "table_usesr")
            Dim dt As DataTable = ds.Tables("table_name")
            Console.WriteLine("The data in the table is:")
            For Each row As DataRow In dt.Rows
                For Each col As DataColumn In dt.Columns
                    Console.Write(row(col).ToString() + vbTab)
                Next
 
                Console.Write(vbNewLine)
            Next
 
        Catch e As Exception
            Console.WriteLine("Error: {0}", e.ToString())
        Finally
            If conn IsNot Nothing Then
                conn.Close()
            End If
        End Try
        Console.ReadLine()
    End Sub
 
End Module

Making Stairs with Landing Revit

 This is a really good video, super simple for making stairs in revit with a landing:

https://www.youtube.com/watch?v=mjY1uNw1G-0&ab_channel=JeffreyFuller

Excel: Split Word Into Separate Cells In Excel

 See https://www.extendoffice.com/documents/excel/1697-excel-split-word-into-letters.html

In a blank cell next to your data, C1 for instance, enter this formula:

     =MID($A1, COLUMNS($A$1:A$1), 1)

Renaming filenames, remove leading characters

This superuse post describes how a set of forward slashes (/) can be used to delete leading characters (except .) from a file name. One slash is required for each character to be deleted. I've confirmed the behavior on a Windows 10 machine.

ren "abc-*.txt" "////*.txt"
  abc-123.txt        --> 123.txt
  abc-HelloWorld.txt --> HelloWorld.txt

 ren "????*.*" "////*.*"