DIY Keyboard drawer installation

Completion Date: May 24, 2020

Work from home has given me chance to use my DIY table (35cm*50cm) ever more than before. I feel great, but I realize the fact that I don’t have enough space if I want to work on my iPad at the same time. I bought this mini drawer tracks so I can create this space.

Material:

- 10 inch (25cm) keyboard drawer tracks, 1 pair (Taobao, RMB12.5)

- 24*36cm wooden board (left over I have at home)

Steps:

1. Stretch the keyboard tracks to full extent. Fit the wooden board to the end of the track and mark the holes with pencil.

2. This is 2.5mm drill bit. Drill pilot holes to the marked holes. Do the same for the other side.

3. Take my table top out and flip upside down. Fit the keyboard drawer and trace the outline and mark the holes with pencil. Re-verify the keyboard outer edge aligns in parallel with the table top’s outer edge.

4. Drill the holes and screws in to fix the keyboard drawer. The screws should be installed to keep the tracks from expanding outwards.

5. Put back the table and it’s done.

Remark: My choice of 10-inch track is perfect. Given that my table already has other installations underneath I could only install the tracks in the middle of the table, causing the table not able to pull out fully at 24cm. However, this is still good for my situation, because behind my drawer is my electric piano. My electric piano would push the drawer out a little, so that the drawer edge aligns with the table top.

I am glad this worked out. I was a bit skeptical if the tracks could install easily, and now end up I didn’t have to change any existing installations. Phew! I could prefer 38cm length, but the board I have is only 36 cm.

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

Super bag for women at work (All-in-one: shoulder bag, messenger bag, backpack)

Completion date: June 13, 2019 Shoulder bag (weight: 0.7kg) Messenger bag Knapsack (weight: 0.85kg) I had this idea of making a super bag for office ladies. For a long time, I was imagining a universal adaptor to convert tote bag to a backpack. (What I really want to say is, there could be a market out there for women who carries laptop everyday. Like me, as a salesperson. We go to places, and work outside. ) That is too far away from me. So, I finally was looking to transform my bag into a backpack instead. I bumped into a bag that was already designed for 2-way wearing (long shoulder bag, short shoulder/hand bag). I bought it. I did a number of transformations so they are in sections below. The transformation took me around 1 month's time. Original bag: Section 1: Umbrella slot Take a band and wrap it loosely around the umbrella. It should be big enough to allow the umbrella to...

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

My invention stories

Search This Blog