Skip to main content

Posts

Showing posts from December, 2018

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 not None):         #convert to date         next_update_date = next_updat

Storage idea for scooters

Completion date: December 17, 2018 The plastic sheet used last time lasted only for a week.  The plastic sheet was thin and "crispy".  It was torn down by my daughter.  I switched to the plastic material that I used for my laundry.  I think it should work as it can stand the rain and the sun for at least 2-3 years.  I also hammered "ring" around each of the punched holes. Completion date: December 8, 2018 I have 3 scooters at home, 2 of which are foldable. I found some space behind the door (entrance door) if I stood them up on the ha ndles. For safety reason I feel I should bar scooters from falling down. So I secured a piece of plastic sheet (HK$14, the kind for book cover wrapping) in front of the scooters. I attached the ends of the plastic sheet to nearby doorframes with flat washers and 1/8 screws (pointed tip). The binder clip are just to weight down the flap, such that the plastic sort of go over and covering the wheels. Let's see h