Category: i-tech
07/11/11 04:44 - ID#54687
Using Gnumeric to eliminate duplicates
Simplified steps from
1. Say you have a column A with A1 to A100 rows with duplicate data that you want to eliminate
2. Go to Data > Advanced Filter. Under the input tab, choose list range as A1 to A100.
3. I don't understand why Gnumeric needs a criteria range for everything but it does... Even for duplicate-value-finding that involves no mathematical formulas. So choose a criteria range. Say B1 to B2. Make sure that the first cell of the criteria range has the same column header as the list range. So if, say your cell A1 was named "Numbers" then B1 should also be "Numbers". Leave B2 blank.
4. Check unique records only
5. Go to the Output tab. Choose an output range (longer than the input range, just to prevent any complaints from gnumeric). Click OK.
You should have the original list with no duplicates in the output range.
Permalink: Using_Gnumeric_to_eliminate_duplicates.html
Words: 175
Location: Buffalo, NY
Last Modified: 07/11/11 04:44
Category: eating in
07/11/11 12:32 - ID#54685
Biscoff Cookie CopyCat Recipe
Ingredients:
2 c. all-purpose flour
3 1/2 tsp. ground cinnamon
1/4 tsp. ground nutmeg
1/2 tsp. salt
1/2 tsp baker's ammonia
1 c. unsalted butter, softened
1/2 c. sugar
1/4 c. firmly packed light brown sugar
1 tsp. pure vanilla extract
Directions:
In a small bowl, whisk the flour, cinnamon, nutmeg, baker's ammonia and salt together; set aside. In a large bowl, with an electric mixer on low speed, cream the butter, sugar, and brown sugar together. Add the vanilla extract. Gradually blend the flour mixture into the butter mixture. Press the dough evenly into the bottom of a 9x13 greased pan. Decoratively score the dough with a fork or small knife, if you wish.
Bake in a 350-degree oven for about 20 to 25 minutes, or until golden brown around the edges. Let cool completely before cutting into bars. Store in an airtight container. Well-wrapped shortbread may also be frozen.
Source: The Art Of The Cookie
Baker's Ammonia? What in the world is that? Sounds so fishy... and sea-weedy.
Permalink: Biscoff_Cookie_CopyCat_Recipe.html
Words: 185
Location: Buffalo, NY
Last Modified: 07/11/11 12:32
Category: i-tech
07/10/11 10:39 - ID#54683
I don't need this Laptop replacement keyboard
BUT I am sure accumulation tax applies to such frivolous things. I can probably buy more heavy metal instead... Besides, I am sure the dead need all the extra exercise they can get. I am resisting this totally unreasonable impulse to buy this absolutely unnecessary keyboard.
Permalink: I_don_t_need_this_Laptop_replacement_keyboard.html
Words: 149
Location: Buffalo, NY
Last Modified: 07/10/11 11:08
Category: i-tech
07/10/11 10:30 - ID#54682
VLC and last.fm
They are under Tools > Preferences > (Show Settings: All) > Interface > Control Interfaces > Audioscrobbler.
I always notice that the features that are super-important to me are usually buried under countless sub-sub-headings. Maybe that says something about the completely trivial ways I use my music playing software.
Permalink: VLC_and_last_fm.html
Words: 82
Location: Buffalo, NY
Last Modified: 07/10/11 11:02
Category: eating out
07/10/11 10:06 - ID#54681
Coffee at the taste of Buffalo
But is the waste worth it? I know people have devised ways to reuse the single-serve coffee brewing Keurig cup more times than one... but still it is definitely way more plastic than I am comfortable just throwing away.
I felt guilty throwing away the small sample plastic cups they gave me. I also felt horrible looking at the trash cans around the event filled to the brim with plastic and more plastic. It was helplessness mixed with guilt because I was part of the problem. What are other ways to make such an event generate biodegradable waste instead? One alternative would be cups made of dried (or even fresh) leaves and bound by twigs (they use these back home).
(e:heidi), so what happened to your single coffee brewer in the end?
Permalink: Coffee_at_the_taste_of_Buffalo.html
Words: 182
Location: Buffalo, NY
Last Modified: 07/10/11 10:14
Category: i-tech
07/09/11 10:51 - ID#54669
Microsoft and Apple gang up to stall technology and Google.
And their combined evil solution? Well, just sue Google and its partner companies for every technological process ever patented by
- a) buying the companies that originally created these patents (who needs the brains to develop and innovate and actually apply for patents when you can conveniently buy the company that created and innovated, in the first place..) and
- b) by pouring money into nitpicky and downright grubby-paw litigation and
- c) using cunning backdoor strategies to win these ligitations.
In the end, these strategies make Microsoft's technologically PALEOLITHIC and appallingly poorly made software make money out of what Google slaved over creating.
I read the OS News website after a conversation with (e:Paul) yesterday and was completely blown away by the ever-expanding EVIL Apple and Microsoft are perpetrating against progress in technology, in general and more specifically, how they have both invested substantial amounts of influence and money to keep open source technologies like Linux stunted and shunned by a large proportion of the population. Worse, when one branch of linux, the Android OS, is honed into a commercial success for mobile platforms by the brains at Google, Microsoft and Apple make sure that they STILL fleece the unsuspecting population and make money out of Android by using underhand and totally loathesome unethical legal strategies.
All of this makes me loathe Microsoft and Apple even more. It cements my view that any self-respecting consumer who lives with technology and thus, has even remote interests in innovation in technology, should seriously think about means and ways to move away from the stifling monopoly that microshit and crapple have on the market. More importantly, it is time to take assertive steps to implement this move away from the technological cesspool that microsoft and apple have managed to create.
(e:Matthew) was telling me how he has walked and continues to walk with kids and a pram down Linwood and it remains one of the most positive things one can do for a neighbourhood. I couldn't have agreed more. In a weirdly analogous way, small individual actions to dispel general misconceptions about linux and opensource technologies (that are not bound down by the venal giants, Microsoft and Apple) make a world of difference to the neighbourhood of future technological innovation that are not geared to fleece people but empower them to be more productive and encourage independent thought.
I am glad that I have taken the first daunting step by embracing linux and at the very least, trying to learn to think for myself. If I can do it, anyone can. It's not that hard. It just requires the willingness to fight the cancer that hamper progress and thought.
Do it today, try out a linux OS, try out R for analysis, ditch SAS, move your office applications to a browser-based cloud, weed out microshit and crapple from your lives, try out some Google products. See how they change and rock your world. You would have done that small invisible favour to help take web technology and innovation a little bit further and away from the artificial and downright, atrocious restraints that it doesn't deserve.
Permalink: Microsoft_and_Apple_gang_up_to_stall_technology_and_Google_.html
Words: 621
Location: Buffalo, NY
Last Modified: 07/09/11 11:04
Category: the odes
07/08/11 07:10 - ID#54664
Dear diary...
Permalink: Dear_diary_.html
Words: 10
Location: Buffalo, NY
Last Modified: 07/08/11 07:10
Category: eating in
07/08/11 04:42 - ID#54663
Wo(r)k obsession
I am leaning towards the wok...
Permalink: Wo_r_k_obsession.html
Words: 78
Location: Buffalo, NY
Last Modified: 07/08/11 04:43
Category: the odes
07/08/11 12:27 - ID#54662
Buying restaurantware
The caption says:
Recently installed in my garage a used deep well stainless steel sink from a restaurant.
That made me wonder. What happens to cookware from commercial restaurants once they close? Do they hold an auction to get rid of cookware? Do they end up in trash? So many new-ish restaurants close in Buffalo every now and then. What do they do with the things they have had?
Permalink: Buying_restaurantware.html
Words: 107
Location: Buffalo, NY
Last Modified: 07/08/11 12:27
Category: i-tech
07/04/11 11:40 - ID#54642
Really random question.
What on earth is a REAPER in the context of recording or shopping? Since when did random questions become so tough?
Permalink: Really_random_question_.html
Words: 36
Location: Buffalo, NY
Last Modified: 07/04/11 11:40
Author Info
Date Cloud
- 12/21
- 12/15
- 02/15
- 01/15
- 11/14
- 08/14
- 04/14
- 02/14
- 11/13
- 07/13
- 09/12
- 08/12
- 07/12
- 04/12
- 03/12
- 02/12
- 01/12
- 12/11
- 11/11
- 10/11
- 09/11
- 08/11
- 07/11
- 06/11
- 05/11
- 04/11
- 03/11
- 02/11
- 01/11
- 12/10
- 11/10
- 10/10
- 09/10
- 08/10
- 07/10
- 06/10
- 05/10
- 04/10
- 03/10
- 02/10
- 01/10
- 12/09
- 11/09
- 10/09
- 09/09
- 08/09
- 07/09
- 06/09
- 05/09
- 04/09
- 03/09
- 02/09
- 01/09
- 12/08
- 11/08
- 10/08
- 09/08
- 08/08
- 07/08
- 06/08
- 05/08
- 04/08
- 12/07
- 11/07
- 10/07
- 09/07
- 08/07
- 07/07
- 06/07
- 05/07
- 04/07
Category Cloud
More Entries
After This
My Fav Posts
- Click the heart at the bottom of anyone's blog entry to add it here ;(