Skip to main content

Posts

Showing posts from February, 2019

Mobile phone place in the kitchen

Completion date: February 27, 2019 There is no place for me to put my phone anywhere in the kitchen. If there was it wasn't a safe place. I bought a cutlery storage from Family House for $12. I cut the bottom middle part out (with a cutter) for the charging cable to come through.

Python script: Copy information from excel in one go

Completion date: March 15, 2019 This version 4 adds the try and except error.  Better coding, it should always work (hopefully).  The dimension of the application is set, and the position of the application (where to appear on the screen) is also set. ================================== #! python 3.6.4 -- Modified on Mar 15 2019 (by Bonnie Chan) import pyperclip import openpyxl import os from tkinter import * from tkinter import messagebox #Get the workbook, worksheet file = "AR.xlsx" wb = openpyxl.load_workbook(file) ws = wb['Sheet1'] #Customer name, salesman, Project name, Job no, PO no, Service amount #column_list_letter = ['I', 'G', 'H', 'Q', 'P', 'N'] column_list_for_content = [9, 7, 8, 17, 16, 14] column_list_for_subj = [[9, " - "], [8, " ("], [17, ")"]] root = Tk() root.title('Copycat v4.0') root.geometry("300x150+400+400") lbl = Labe

New recycling bin

Completion date: February 4, 2019 The old paper recycling bin has worn out and I found one of the Taobao parcel box was a very good candidate for it. I cut casually just by fitting a sample A4 paper on it. Then I took a ruler and cut along ruler's top and bottom edges in one go. The box was used for a week or so.  The printing on the box was making it looking really cheesy though.  I wanted to buy some nice wrapping paper and decorate it. However before that, I came across my sons' drawings. It was one of things that you can't throw away easily. (Of course, I had to ask for his permission to use it, haha...) So I used his drawings/colorings and just stuck them on the box.  Then, I had stickers (I bought them for photo album project few years ago; some of them even from my childhood!). Well, I put them in good use!

Wire organizer

Completion date: January 31, 2019 Taobao suggested this item to me, wire organizer costing at RMB2.2 each.  At home we own 3 pieces of very long wire and two of them has been coming out. I tried the smaller adhesive cable clips twice and still they are either falling off, or all crooked.  Now when I saw this I didn't think of the white wire organizer that I used to see in hardware stores. But the advantage of this is also because it houses up to 5 wires (though I only have 2 wires, haha). The organizer can be fixed by screws or adhesive tape. I thought, hey, I can reuse this on screws. So I bought it.  Enough for the stories. How I installed this: I took a book of around 1.5cm thick to get the proper and unified spacing leveled from the floor. 2.  The important note was to start from the corner!   (So then you won't end up with spaces when you get to the corner. I learnt it the hard way...my wall has triple number of holes.) 3. With