Bug-hunting spreadsheets [Sacha Chua]
There’s a certain delight in working on obscure problems. In my case, I was trying to debug an old spreadsheet that statistically analyzed survey responses in order to match them to innovation archetypes. It started when I noticed that a few chart labels were incorrect. In the process of trying to figure that out and make handling multiple survey responses easier, I ended up deep in Visual Basic code, untangling algorithms that didn’t make complete sense to me.
The spreadsheet had been created three years ago, and it was hard to track down people associated with the project. Documentation was practically non-existent. Working with the source code, sprinkled comments, and formula auditing tools, I figured out what was going on.
So I knew what the code did, but I wasn’t sure it did what it was supposed to do. I asked two team members and a third consultant to refer me to someone who could explain the manual procedure and provide the missing information. If I could figure out how to do the analysis by hand, I could find the bugs and update the spreadsheet.
Even if we end up discarding the tool, I had fun following the logic through the code. There’s something about understanding a small piece of the puzzle well, and then expanding your understanding until you can hold the program in your mind.
Post from: sacha chua :: enterprise 2.0 consultant, storyteller, geek.
Check out my blog for tips on managing virtual assistants, Drupal, and other topics!
Bug-hunting spreadsheets
ACM Hypertext conference in Toronto this June; paper deadline Feb 14 [Sacha Chua]
My research supervisor is chairing the ACM Hypertext conference that will be held in Toronto from June 13 to 16, 2010. The conference focuses on linking and interconnectivity, and will have sessions on Web 2.0, social computing, and the semantic web. Tracks:
The deadline for paper submissions is February 14.
Post from: sacha chua :: enterprise 2.0 consultant, storyteller, geek.
Check out my blog for tips on managing virtual assistants, Drupal, and other topics!
ACM Hypertext conference in Toronto this June; paper deadline Feb 14
Weekly review: Week ending February 7, 2010 [Sacha Chua]
Work
Relationships
Life
The week went by so quickly. I postponed a number of items on my task list so that I didn’t go crazy trying to fit everything in. At work, I prioritized supporting upcoming engagements and improving our process documentation. One of our new team members was impressed by the way we’d written down lots of stuff – hooray. Outside work, I focused on planning the wedding and on exploring crafts.
PLANS FOR NEXT WEEK:
Work
Relationships
Life
Post from: sacha chua :: enterprise 2.0 consultant, storyteller, geek.
Check out my blog for tips on managing virtual assistants, Drupal, and other topics!
Weekly review: Week ending February 7, 2010
Lessons learned from microblogging talk [Sacha Chua]
I gave a talk on microblogging to approximately 150 people at IBM. It was fantastic! There was so much energy and engagement, it was all I could do to keep up with the free-wheeling discussion.
What worked well:
What I’d like to improve further:
That was exhilarating!
Post from: sacha chua :: enterprise 2.0 consultant, storyteller, geek.
Check out my blog for tips on managing virtual assistants, Drupal, and other topics!
Lessons learned from microblogging talk
Why CDR King should talk to this Smart SWEEP team [Max Limpag]
When was the last time you were in CDR King in SM City? How much of your time was wasted waiting for your turn? The last time I was in that branch is precisely that—the last time. I spent close to an hour waiting for my turn that I ultimately gave up. Yes, their products are cheaper, but you waste an hour of your time just to save a few pesos? I’ll reserve masochism for bulk purchases.
Waiting in line has got to be the blight of modern man’s existence. In the offices of Pag-ibig, SSS, LTO, NSO, you see people waiting in line for so long you’d worry about the national productivity. In medical clinics, healthy people get sick—and murderous—by the time doctors finally attend to them.
I do not have proof, only strong suspicion, but I think your blood pressure is directly proportional to the amount of time you spend in line. Take a BP monitor the next time you transact with a government agency and find out for yourself.
A better queuing system would do wonders to our health, sanity and national productivity. Wouldn’t it be great to get a priority number for a transaction and be notified when it’s your turn?

STUDENT PROJECT. Ateneo de Zamboanga University mentor Eugene Kanindot (left) explains the TimeFree system to Atty. Jane Paredes, senior manager of Smart public affairs Vis-Min. (SUN.STAR FOTO/MAX LIMPAG)
Joselle Macrohon, a student of the Ateneo de Zamboanga, saw the long lines in the school’s finance office and, instead of ranting or writing a column about it, decided a technical solution to the problem would make a good school project and entry to the Smart Wireless Engineering Education Program (Sweep) Innovation and Excellence Award. The team came up with the TimeFree application to address that problem.
The system is simple and ingenious. You drop P5 into the TimeFree machine, enter your priority number, specify on which priority number you want to be alerted and then enter the phone number where you want alert text messages sent. After that, you can go somewhere else knowing that when it’s close to your turn, you’ll get a text message to alert you.
For example, you want to pay your utility bills and you get 235 as priority number. The tellers, however, are still attending to priority number 130. With TimeFree, you don’t have to wait inside the payment center until all the 104 people ahead of you are called. You can configure TimeFree to send you a text message when, for example, priority number 230 is called. When it’s your turn, the system will send you another text message.
TimeFree is customizable, said mentor Louie Gallardo. A company can, for example, deploy the system as an added customer service and do away with the coin slot so that its clients don’t have to pay for the alerts. TimeFree is also easy to deploy. Gallardo said they can easily connect it to existing ticketing systems.
The TimeFree protoype that the student group produced will be used by the Ateneo de Zamboanga’s finance office after the contest.
While TimeFree was not among the top three winners of the Sweep Innovation and Excellence Awards, I think the application has the most potential to be actually deployed and used. I’ve covered Smart Sweep for four years but I couldn’t recall being as excited and as giddy as I was during the demo of mentor Eugene Kanindot of Ateneo de Zamboanga.
Related posts:
Source Code Review According to COMELEC (Feb 08 10) [Pablo Manalastas]
Source Code Review According to COMELEC (Feb 08 10)
Recently, COMELEC announced that it will allow the review of the source codes of the computer programs for Election 2010 by programmers of interested political parties and groups, in conformity with the provision of Section 14 of the AES Law Revised (RA9369), which states,
"Once an AES technology is selected for implementation, the Commission shall promptly make the source code of that technology available and open to any interested political party or groups which may conduct their own review thereof."
We have to take this announcement with a grain of salt -- we can not truly believe in the truth of this announcement. If we ask COMELEC or Smartmatic exactly what the source code review is all about, we get three different answers, depending on which person in COMELEC or Smartmatic we are talking to.
Various Definitions of Source Code Review by COMELEC-SMartmatic
Version 1. Atty. Ferdinand Rafanan, Chief Legal Counsel of COMELEC, has one ver...
Will 1000 Ballots Fit in This Box? (Feb 08 10) [Pablo Manalastas]

This is the ballot box that will be used in the May 10, 2010 national and local elections. In this picture, we see the box with 50 ballots, after 50 teacher-voters cast their votes in the mock elections of Saturday, February 6, 2010, at New Era Elementary School in Quezon City. This box is almost one-fifth full with only 50 ballots. We are told that this box was designed to hold 1000 ballots. I showed this photo to a number of people, and asked them if they think 1000 ballots will fit in this box, and everyone said there is no way 1000 ballots will fit, unless the BEI members open the box from time to time to stack the ballots neatly inside. I think COMELEC-Smartmatic designed this box to hold 1000 ballots that are US letter size, not 1000 ballots that are size 8.5"x29", which is the current ballot size.
Good luck to COMELEC. I hope that it finds a way to solve is packing-stacking problem, which I believe will be a problem on election day.
UP Team Ranks 40 out of 103 in Programming Contest World Finals (Feb 06 10) [Pablo Manalastas]

The UP ACM Programming Team ranked 40 out of a total of 103 collegiate programming teams from universities all over the world, to produce the finest performance ever of any Philippine team in the World Finals of the ACM International Collegiate Programming Contest, held yesterday in Harbin, China. Each of the 103 participating teams are already champions of the programming contests in their respective regions. The UP team, code named "Mga SOGO in ET", has team members Marte Raphael Soliza, Kevin Charles Atienza, and John Eddie Ayson. Their faculty coaches are Dr. Fidel Nemenzo and Mr. Eric "E.T." Tambasacan. They were champion team from the Asia-Manila regional programming contest in October 2009, at which teams from China, Singapore, Vietnam, and other Asian countries participated.
Congratulations Marte, Kevin, and John, for A JOB WELL DONE!
Correction: The World Finals 2010 scoreboard lists the UP team at the new and higher rank of 36, not 40. Sorry for the error.
http://cm.b...
QOTD: Learning journalism [Ian Dexter R. Marquez]
He was doing journalism in order to eat, which is a very good way of learning journalism. Probably the only real way, come to think of it.
– Terry Pratchett on Neil Gaiman, in Good Omens
Posted on Coredump - Work, play, and everything in-between, under a Creative Commons BY-NC license. Original article: QOTD: Learning journalism by Ian Dexter R Marquez
Follow me on Twitter here. View the rest of my stream at public static void.
Read more:
| Feed | RSS | Last fetched | Next fetched after |
|---|---|---|---|
| (Obsolete Feed) | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| (Obsolete Feed) | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| :: Zorlac Domain :: | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| A Clockwork Durian | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| C++ Soup! | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Coredump | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Crimson Crux | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Ealden Escañan | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| F S 3 Consulting | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| foxpro.catalyst « | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| free.net.ph | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| godiane | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Guro | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Happy Geek's CodeX | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| http://jroller.com/jilagan/feed/entries/rss | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| http://premrara.com/blog/feed/ | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| http://www.haravata.com/blog/?cat=3/?feed=rss2 | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| InfoSec Philippines | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Insanity in a box | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| iRant | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| IT Girl | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| it is... | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| jared@darkstar | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| jijo.free.net.ph | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Jojo Paderes | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Kyo Suayan | personal site | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Leon Kilat ::: The Cybercafe Experiments | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Mental Blabberings | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| monicai tech-trospect | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Monotrematica | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| my Technology Blog | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Naked Interface | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| nox @ work! | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Pinoy Tech Blog - The Philippines' Premier Technology Blog | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| PMana's Sight | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| sacha chua :: enterprise 2.0 consultant, storyteller, geek | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Segovian Chronicles | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Stellify | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Technobiography.com (old location) | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Tek for the Pipol ? | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Teknolohiya | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| The Geekette Speaketh | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| the parser blog | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Third World Agility | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Third World Software... Development | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Thoughts Aloud | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| thoughts shared, rarely | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| UP ACM: Compute. Compile. Compete. | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| waaaaa | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |
| Zakame::Blog | XML | 12:15 AM, Wednesday, 10 February | 12:30 AM, Wednesday, 10 February |