interesting journey familiar with google sheet


Submitted by riveryog on 周三, 09/13/2017 - 15:35

benzrad daily todo lists / agenda since his web log and old family brings world the biggest gift, woz 楚甲主, since the birth of the Son's 1st child, exported from remember the milk web site which defies csv export. here exported with pyrtm and sorted in google sheet. publish here for golden memories of zhone Royal China in hard times and spontaneous joyful life stream under saint shines. Now with settled museum of those innocent era, the Royal China archive more solidated and wonderful. let the life stream floats forever on berth of the Earth planet.

Get a copy of the archive.


after learned from its official site,, that its mainly a muslim supported family company, I felt need of my data portability. the client and site defied csv export, however, 2 days research online python tool, pyrtm, and a local converter, at, I got my python environment on ubuntu running and finally got txt or csv exported. last day and overnight spent on cleaning data which has date errors. I spent near 10 hours cramming google sheet function/formula, aiming convert format "Week Mon-day" into "yyyy-mm-dd" among which passed years missing. I want to verifying year according the week information, such a common problem but few online community knowledge touched. mounting problems with the converting let me gave up in dawn and search for alternative ways to retrieve my data from the unfriend website. and my search rewards on ubuntu, the todotxt_import tool, a local niche working like a charm. then again there small portion of task to reformat well exported text in google sheet spreads in cells of different columns and rows, all stripes via google sheet functions from sole import of exported. my newly learned skill in last 24 hours helps a lot, and soon I satisfied with final dataset almost intact maintains original source of import, and published at once online onto to zhone web, ie : or God, dad, isn't it a wonderful journey re-enliven me in escort of powerful google? help me settle my golden memories in the todolist archive, and reinforce my workspace with newly adopted todolist managemental, toodledo at in the new journey with toodledo, my data portable must be more promising!

last Friday water heat system started rolling. I also felt blackout with boring agenda and time to kill. hope this year end not so poor financially. I however, launched to prepare myself entertainment indoor: steam games.
this morning visited woz, dearest son earlier than usual, near 8am. in idle I started to browse steam store. I told myself if there are titles less than $2, I will buy interested ones. then I saw my long time regret not tried game, "Homefront". in minutes I enlist under my son's account. I also bought "Red nation", a zombies game which will drive my son away for the dirty bloodiness.
after luncheon and showered in public spa, I tried again a zombie game free gained during its promo. its not action packed, nor time sensitive, so I can play it like learning a multimedia works. after gaming I felt quite satisfying.
God, cold and merciless reality in nowadays PRC really speechless. we Chinese blame nobody but our redemption sooner over, esp in mercy of Christian God's salvage, upon the wrong road our last generations chose, and fake faith lasts thousands years & enslave the arid eastern Asian earth.

dreamt first being laid off and trying to relocate myself. then got up to release myself. then napped again, dreamed my son with his pals trying to learn Japanese. I told him aside just search google translation for solution. I'm dog tired these days non-stop to prepare redundant portable systems, even with alarm I overslept to lunch time. however, I managed preapred boiled dink water and personal washup before leaving for dorm lunch.

dreamed my hometown brothers and sisters led me to visit fortune-teller. near the end, there was a kid jumped in and let the wiseman busy with his fate. upon leaving the kid kissed and printed lips on the cheek of the man, let me wonder my fate contributing to my dad's deep love on me.

the canteen operative couples visited my dorm first time, trying holding me back. but I determined to hunt meals wilder for 2 years. later my younger brother joined to persuade, none change my mind.
now this late morning without any hustle, I enjoyed peaceful life. dreamed a female helping me in life stream. God, dad, grant me a stable life and supportive finance.