Book: 機巧裝置　機構設計應用圖典　從零開始也能實踐簡易自動化

Purchased date: February 23, 2020

Finally received the book yesterday in EF Locker! Actually this book was recommended to me in Taobao few months ago and I really wanted to read this! It's not in the library and ebook not available, so I ordered from Taiwan (I was too chicken to order it from Taobao China due to the outbreak now). The book and shipping costed HK$200. I think it's worth it. I consider buying this book for quite some time, because I don't like to stock up books at home, no space. But, What I truly feared was that I couldn't understand any of it.

We afraid because we are ignorant.

It's mechanics. I read some and it wasn't so bad of me. It is actually a really good book for looking up the common mechanics. So, I am quite happy I got this book.

Comments

Python script - pop-up reminder based on data from Excel

Completion date: December 17, 2018 Changes to the script (Dec 14 2018): 1. Used Date format to compare dates. 2. Show message for update AR if the date is overdue and due today. Changes to the script (Dec 17 2018): 1. Corrected the ws.max_row+1 to ws.max_row. 2. Changed to loop from bottom up (so the the newest records gets checked first) =========== The script =========== #! python3 -- Modified on Dec 17 2018 import openpyxl import tkinter.messagebox from datetime import date import os #Get the workbook, worksheet file = "AR.xlsx" wb = openpyxl.load_workbook(file) ws = wb['Sheet1'] #Iterate through the rows of column "Next update on" = Column D = 4, from bottom up (the newest record to oldest) for i in range(ws.max_row, 2, -1): next_update_datetime = ws.cell(row=i, column=4).value if (next_update_datetime is n...

Gear investigation: Banbao Lego crane

Completion date: May 16, 2020 1. Gear ratio: 8:24:40. The bottom wheel cranking the string at speed (8/24)*(24/40)=0.2x speed of the motor. 2. The top two wheels looks like pulley system to me, but I am not sure about the spinning speed of the top wheels, the first top wheel is slower than the bottom wheeler, that I observed. 3. The beginning of the bottom wheeling action is pulling less string because the circumference is small (less string winded). So it pulls the string faster gradually as more string is added to the circumference. 4. Note I added the rewind crank on the other side of the motor. This is the final instruction of the Banbao booklet. All the builds have been fun for me, I got to know more about gears now (though still primitive). My thoughts towards the gear mechanism is that it is not as efficient as I thought it would be. - requires many gears to do 1 simple thing - gear design has to match the many requirements of the space, dist...

Fixing of retractable badge holder

Completion date: October 2, 2021 My retractable badge holder’s string is thinning and would be broken soon. I cut it short. Pull the rotten part out with a tweezer. Insert the string from this end. Tie a knot. Reinstall the silver triangle back.

My invention stories

Search This Blog