Pages

3.18.2014

Copying the content of a cell if compared values match


Useful Excel formula when you need to get the value of a column if it exists in another column.

For example, say I need to get the DescriptionA of an IdA and if the Id exists on another list (IdB), copy the descriptionA to the descriptionB. 

=IF(COUNTIF($C$2:$C$9,A2)=0,"",VLOOKUP(A2,$C$2:$D$9,2,FALSE))



The quickest way would be a SQL sentence and extract the information straight from the DB tables.. but if all you had was the spreadsheet, this works quite well.

2.18.2014

Simple Javascript

Change menu item text

Simple way of changing a list element without needing to find the nth child, element, relative, etc...

var item = $jq('.region_menus a[href="/hiya/home"]');
item.text("Find Food here");

And that is it!


IndexOf function Not valid on IE8

Array.prototype.indexOf = function(obj, start) {
     for (var i = (start || 0), j = this.length; i < j; i++) {
         if (this[i] === obj) { return i; }
     }
     return -1;
}

1.07.2014

2013 Scrum - Team's achievements after adopting Scrum


Really happy with the results of our team since adopting Scrum. This is the summary for 2013:


The team has already changed and many new development plans for 2014. Hopefully it will only get better and better!

12.02.2013

2014 New Year's Resolution


It's that time of the year again!


By definition, a New Year's resolution is a promise that you make yourself on the first day of the year to start/stop doing something during the rest of the year.


Unfortunately, promises to myself never seem to be working. So, I will try something different this time and post it on my blog. If I have any dignity or shame, then I should keep these public promises?



  1. Lose 18 kg.
  2. Get UK driver's license.
  3. Keep unhappy out and happy in.
  4. Career development.
  5. Join a club of professional (hoping to find like-minded people to learn from and teach some).
  6. Look more professional (trousers are falling, need new ones and is related with  3, 4 and 5).
  7. Learn something new (language, dance, something).


I won't have more then ten items on the list, 'cause I do have a life.

11.21.2013

Javascript is Sexy

I don't agree with the title of this blog post. I don't think JavaScript is sexy at all. Anyways... I have to learn Node.js for this unwanted child project at work. I have found a great site for learning JavaScript and it's relatives, and wanted to share it: JavaScriptIsSexy.

Enjoy!


10.14.2013

Software

I will keep this one short.
There is so much crappy software being used out there (in the world) it makes me sick! Why can't we build it so that the world is a better place?

There is good software out there too... I just don't get to work on it, cause maintaining horrible stuff takes all of my time!!!!!!!!!!!!!!!

10.01.2013

Chocolate Chip Cookie Cake in a Mug

Cakes in a mug are so easy and quick to bake microwave! Here goes another recipe as an entry to the Whittard of Chelsea Cake in a Mug Blogger Carnival.

Ingredients:
1     egg
3     tablespoons of brown sugar
1     tablespoon butter
1/3  cup flour
3     tablespoons chocolate chips

Steps:
1. Add egg and beat well.
2. Add sugar and flour.



3. Finally, add in chocolate chips.


4. Mix all ingredients well and microwave from 1.5 to 2 minutes.



5. Enjoy with caramel or chocolate syrup and/or ice cream!


I topped mine with condensed milk and vanilla ice cream!!!