Here are the small tips or details I am using during work;
ANSI and UNICODE CODES
In order to write the following characters using ANSI codes; first open NUMLCK, while pressing ALT, push the numbers on the numpad .
° 0176, Ø 0216, ± 0177, × 0215, ² 0178, ³ 0179, A 65, a 97,
ç 231, ğ 287, ı 305, ö 246, ş 351, ü 252, ə 601, ý 253, ä 228, ň 328
In order to write the following characters using UNICODE codes; First write the given code without "U+" part, select it, then press ALT + X. The code will turn into the character. If the character is an accent mark, then first write the main character. For example: to write ǎ, write a030c.
‰ U+2030, ° U+00B0, Ø U+00D8, ± U+00B1, × U+00D7, ² U+00B2, ³ U+00B3
A U+0041, a U+0061 ç U+00E7, ğ U+011F, ı U+0131, ö U+00F6, ş U+015F, ü U+00FC
ə U+0259, ý U+00FD, ä U+00E4, ň U+0148
Pinyin tonnes;
Tone 1: ā ē ī ō ū (-) U+0304
Tone 2: á é í ó ú ( ́) U+0301
Tone 3: ǎ ě ǐ ǒ ǔ ( ̌) U+030c
Tone 4: à è ì ò ù ( ̀) U+0300
In order to write in HTML :
° ° , ± ± , × × , ² ² , ³ ³ , Ø Ø
To write ANSI or ASCII, add the code after &# characters. For example: to write Ø, write &# 0216 To write UNICODE, add the code after &#x characters. For example: to write Ø, write &#x 00D8MS EXCEL WORKING WITH ALT+ENTER CHARACTER
When you need to use Ms Excel's replace feature to replace ALT+ENTER (new line character in a cell), you should press CTRL+J on the replace textbox.
CANCEL THE PASSWORD OF AN EXCEL FILE
First open the excel file using a compressing software like Winzip, Winrar, 7-zip. In the "xl" file, open the "worksheets". You will see a file as "page....xml". Open it with a text editor like Notepad. Find "Protection" in the text. Delete the part with <sheetProtection .... />, then save everything. You should repeat all the steps for each protected pages
BENDING FACTORS FOR HRP STEEL SHEETS
Take the sheet metal's thickness as t. You should add material to the both sides of the bending line as " bf = 0,131 x t " . For example; if an L shaped bent part with 100mm x 100mm x 5mm dimensions flatten again, length of the flatten sheet will be = (100+0,131x5)+ (100+0,131x5) = 201,31 mm
THREE SIMPLE RULES OF LIFE AND ADDRESS OF THE MAGIC
- If you do not go after what you want, you will never have it.
- If you do not ask, the answer is always no.
- If you do not step forward, you will always be in the same place
The magic is at the work which you continuously avoid.
FINANCIAL CALCULATION TIPS
Rule of 72: Divide 72 to interest rate to find when to double the investment. T=72/r For example; if interest rate is 4%. Double time = 72/4= 18 (months, years etc.)
EMI: Equated monthly installment: around how much I will pay every month for an credit. EMI=P*r*[(r+1) ^n] / {[(r+1)^n]-1} where P=loan, r=interest rate, n=payment occasion. For example; 10.000$ loan with 4% monthly interest for 5 years with monthly payment: n=5*12=60. EMI=10000*0,04*(1,04^60)/((1,04^60)-1) = ~443$
Compound interest: Take P=capital, r=interest rate, n=payment occasion, all return including capital=GT. GT=P*[(r+1) ^n]. For example; 100$ investment with %4 monthly gain, at the end of 18th month GT=100*(1,04^18)= ~202$