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...

Mahjong table frame

Purpose: To make a collapsible frame for a portable table. Completion date: 2025-01-12 The main purpose of the frame: Provide raised step (~0.5cm height) for aligning the tiles in a straight line A place to put turned-over tiles along the frame Raised step design to prevent the tiles from falling off the table Portable table: 34” x 34” Mahjong mat: 31” x 31” Materials: Cardboard Adhesive wallpaper Double-sided tape 4 x L-shape brackets Paper Nano tape 8 x snap button bottom part Old ziploc bag Non-slip mat backing Steps Cut 8 strips of cardboard. 4 pieces: 1” x 34” 4 pieces: 0.75” x 34” Fit set of four strips (0.75”) on the table with the mat. Mark and cut two ends 45 degrees. Fit the strips around the mat snug with its inner edge against the mat's edge. To check if snug: push the frame strips and see if it moves the mat. If yes, good. If not, try to reduce the slack gap in between the frame and the mat rim (could swap the strips to find best fit). Mark the...

Gear investigation: Klutz Lego Blender

Completion Date: May 31, 2020 After I finished with Banbao gears collection, I search on web for other building instructions. I came across the Klutz Lego and saw the picture that I just built from looking at it. It was quite easy and fast, however, I would like to convert it to vertical winding, but I don’t know how yet. So here is the original one. Gear ratio is 40:8=40:24 = (40/8)*(40/24)=8.3 times faster then the hand-winding motion.

My invention stories

Search This Blog