2010.02.04

Personal Kanban For A 12y Old – Improving Homework It Will?

After some discussion about how we could improve the weekly homework for our 12y old, I introduced the tool I use myself. Personal Kanban.

With a few adjustments from “Traditional Personal Kanban” (is there such a thing?) and much curiosity from the 12y old we started a few days ago.

12y Old Personal Kanban Setup:

12yold_personal_kanban

  • One “To Do” column with all weekly tasks.
    For now it includes homework and guitar practice tasks.
    All tasks were discussed and finally agreed by her to be a “normal school week”.
  • Three lanes for each day, “Afternoon”, “Evening” and “Done” (at the bottom).
    Needed since we have specific deadlines per subject, and it’s easy for her to plan a full week.
  • Some slots disqualified by planned tasks such as Scouting and Dance lessons.
    Good for showing the days that she will not be able to do any of the “weekly tasks” at all.

The 12y old have the freedom to choose days for her tasks. With very few restriction… like… it’s not “optimal” to do all five “15 minutes guitar  practice” tasks on the same day. She wanted to put all tasks up in the start of the week, but we alse talked about leaving them in the “To Do” column until started upon.

We noted if any specific subject have a “deadline day”. Math always to be completed until Monday for example. (Easy now when each week looks the same).

Any additional  “none weekly task” could be added if she need to keep track on it.

It’s still the first week, but the first impression from us and the 12y old are really positive. She finds it satisfying to move tasks to the “Done” slot, just like me ;)

On Sunday we will reset the Kanban and start all over again. Perhaps a small retrospective… nah… not this time ;)
This could really work!

2010.01.28

Spotify Flagged As Trojan By Symantec, Norton And More…

spotify_symantec_warning

But no changes have been made to Spotify according to Andres @ Spotify

“We've made no changes to Spotify and there is nothing infecting it. It's possible that it's a false positive which we've seen before from anti-virus programs.” (http://getsatisfaction.com/spotify/topics/spotify_defined_as_a_trojan_by_symantec)

Well… no music at work kind of sucks.

Technorati Tags: ,,,

2010.01.27

Google Docs Updates: Now Using My Extended Storage And The Wonderful Grid View

Perhaps I have missed it for a long time?

Yesterday, when I uploaded some images and PDF’s to my Google Docs account, I noticed that the available storage now included my additional 20GB.

Great stuff.

One step closer to “GDrive” i guess ;)

google docs using my extended storage

Last year I upgraded my Google Account with 20GB for $5 per year. A bargain.
https://www.google.com/accounts/PurchaseStorage

buy additional google storage storage_additional

Today Google also announced the new “Grid View”: Look nice.

googe_docs_grid_view

Keep up the good work Google!

2010.01.20

Here we go again.. twitter down. Over capacity.

twitter_down

Stop tweeting you fools!!! ;)

2010.01.19

I Am Entering The World Of Flash Game Programming

Finally!

More information to come… work before blogging you know…

2009.12.18

Personal Kanban 2 Go – Bus edition of my A3 Kanban at work.

I already use an A3 sheet for my Personal Kanban at work. Even if it’s portable it is not that handy to bring in on the bus every day.

Since a few days I have another Kanban for my private tasks. Still using The Pomodoro Technique to getting things done.

Ultra portable “Kanban 2 Go”

kanban_to_go
Fig 1. 147x295mm and the cute 51x51mm Post It

The Archive is on the next page…

Hey! Works for me!

HOWTO – Gather and present data from multiple lookup tables in Microsoft Excel using VLOOKUP

Ever been asked to extract data from different sources (excel sheets preferably) into one table/sheet in Excel?

I have.

Seen to many copy paste approaches, I finally looked for a better way myself. As long as you have one value that are unique per row and shared between the data sources , you can solve this problem with some Excel magic. Let’s take a look at VLOOKUP.

Learning By Example:

Sorry for the lame example data, no imagination at the moment, sorry ;)

Source A:

PersonId Shoe Size Age
1 36 15
2 42 26
3 33 14
4 45 23
5 39 23
6 38 27
7 38 43
8 37 38
9 43 18
10 38 16
11 40 17
12 27 5

Source B

Person Id Favourite Animal
1 Ape
23 Lion
2 Cobra
25 Lion
4 Fish
14 Ape
3 Lion
15 Cobra
6 Lion
16 Fish
7 Ape
17 Lion
9 Cobra
18 Lion
8 Fish
77 Ape
10 Lion
9 Cobra
12 Lion
5 Fish
34 Ape
11 Lion
56 Cobra
12 Lion

 

You would like a third table with all values per person, let’s add another column to Source A, using VLOOKUP.

We are looking for matched row in Source B, using the shared key “Person Id”.

excel_vlookup_example_001

Syntax Break Down

vlookup syntax

Or in English: Use the value in cell A4 and look for a exact match in the range G4:H27, if found, use the value in the second column.

Important! Since we can not specify which column the key is located in in the lookup range, it has to be in the first column. (In this case the G column).

What’s about all those $ in the formula?

A $ before a column or range reference in a formula makes it static, so when we drag or copy the formula those values remains the same. In this case it is very important that all rows looks in the full range, and then we add $ to the range. G4:H27 becomes $G$4:$H$27. Both the column and rows are locked, and we can drag the formula down and to columns to the right. And it will work.

If not: =VLOOKUP(A4;G4:H27;2;FALSE) will be =VLOOKUP(A5;G5:H28;2;FALSE) on the next row.
We lost the first value, we do need the $. Or you can update each rows formula manually….. guess not.

unlocked_formula_missing_values_vlookup 

Have fun!!

2009.12.10

My Initial Selection Of Google Chrome Extensions

Installed_Google_Chrome_Extensions A few days ago the Google Chrome Extensions were releases. Since I’m on the beta bandwagon I installed some of them straight away. Below are a list if my selection:

Google Wave Notifier

GMail Checker

IETab

Google Translate

AdThwart

FlashBlock

Edit: AdThwart and FlashBlock added since yesterday.

2009.12.09

Using Google Forms To Collect Information From Friends And Colleagues

Google Forms are quick and easy to use for questionnaires.

The forms looks good and you will the responses are presented to you in a clean overview. No more emails with questions that take more time compiling the answers than to come up with the questions.

Hare are some screenshot from a demo form I created yesterday.

Where  is the “Create Form Button”¨?

Create_New_For_In_Google_Docs

How does it look like when editing?

Demo_Google_Forms

What about themes?

Google_Forms_Theme_Selection

What type if questions can I add?

Add_Iterms_Google_Form

Can I show the form on my blog?

Embed_Google_Form

What about the confirmation page?

Edit_Confirmation_Google_Form

Finished… how do I invite people to answer my nifty form?

Send_Google_Form_To_Others

How does the result page look like?

Overview:

Google_Forms_Response_Overview

Or as a Spreadsheet

Google_Form_Response_Sheet

Have fun asking questions!!

2009.12.08

Google DNS Records For Custom Domain Using Google Apps And Blogger

Are you as small business or just a person who wants Google to host the services for you own domain?

Below are the DNS records needed for you to enable custom domains in Google Apps and Blogger.

The first one is just a record used for verifying the domain ownership. This is the first step you’ll have to pass before adding custom domains for there different services. The sub domains could of course be anything you like them to be.

Google DNS Records Example

Sub domain TTL Type Data
googleffffffffxxxxyyyyzzz 3600 CNAME google.com
@ 3600 MX 1 aspmx.l.google.com
@ 3600 MX 5 alt1.aspmx.l.google.com
@ 3600 MX 5 alt2.aspmx.l.google.com
@ 3600 MX 10 aspmx2.googlemail.com
@ 3600 MX 10 aspmx3.googlemail.com
@ 3600 MX 10 aspmx4.googlemail.com
@ 3600 MX 10 aspmx5.googlemail.com
mail 3600 CNAME ghs.google.com
docs 3600 CNAME ghs.google.com
sites 3600 CNAME ghs.google.com
calendar 3600 CNAME ghs.google.com
blogg 3600 CNAME ghs.google.com

Google Apps Domain Settings

Add your own domain for Google Apps

custom_domain_google_apps

Blogger Domain Settings

Add you own domain in Blogger.

blogger_custom_domain

Loading

Last Tweet

    Find out what I'm doing, Follow Me :)

Share this

Bookmark and Share

Subscribe

My Other Accounts

Facebook Flickr Google Talk MSN Messenger Twitter Twitter

Categories

Blog powered by TypePad
Member since 03/2009