Function
=COUNTIF(C:C,K4)
Where C:C contains one list and K4 is the value. Simply drag and drop this formula for all other values in the "K" column!
Showing posts with label general. Show all posts
Showing posts with label general. Show all posts
Tuesday, December 9, 2014
Thursday, January 2, 2014
IBM ThinkPad Laptop Keyboard not working
Problem: When you type "p" a "/" shows up, "U" becomes "4", etc.
Fix: Fn + ScrLk
http://en.kioskea.net/forum/affich-101274-laptop-keyboard-problem
Fix: Fn + ScrLk
http://en.kioskea.net/forum/affich-101274-laptop-keyboard-problem
Tuesday, August 20, 2013
9 Habits Of Productive People
http://www.forbes.com/sites/ilyapozin/2013/08/14/9-habits-of-productive-people/
“Many people feel that their brains function best in the morning, and that morning is when they are most creative and productive,”
http://www.forbes.com/pictures/eihm45eehlf/take-advantage-of-your-cleared-head/
“Many people feel that their brains function best in the morning, and that morning is when they are most creative and productive,”
http://www.forbes.com/pictures/eihm45eehlf/take-advantage-of-your-cleared-head/
Thursday, August 15, 2013
Cocoa, Coffee and Caffeine: How Helpful (or Harmful) is a Cup of Joe?
http://healthland.time.com/2013/08/15/cocoa-coffee-and-caffeine-how-helpful-or-harmful-is-a-cup-of-joe/#ixzz2c3v3WrPk
And if you aren’t a coffee drinker, there’s no need to pick up the habit in the hopes of reaping some of the benefits associated with coffee, since it’s not clear that those benefits outweigh the risks associated with drinking it — especially in large amounts.
Read more: http://healthland.time.com/2013/08/15/cocoa-coffee-and-caffeine-how-helpful-or-harmful-is-a-cup-of-joe/#ixzz2c4KwKkcy
And if you aren’t a coffee drinker, there’s no need to pick up the habit in the hopes of reaping some of the benefits associated with coffee, since it’s not clear that those benefits outweigh the risks associated with drinking it — especially in large amounts.
Read more: http://healthland.time.com/2013/08/15/cocoa-coffee-and-caffeine-how-helpful-or-harmful-is-a-cup-of-joe/#ixzz2c4KwKkcy
Wednesday, June 26, 2013
What does a starfish symbolize?
http://wiki.answers.com/Q/What_does_a_starfish_symbolize
It is a story of a old man on the beach who sees a young boy walking along throwing starfish back in the ocean. The man tells the boy there are miles of stranded starfish, he won't make a difference. The boy throws another one back in the ocean and tells the old man that it made a difference to that one.
http://wiki.answers.com/Q/What_is_the_symbolism_of_the_starfish
once read as a symbol of healing and regeneration
http://www.whats-your-sign.com/love-symbol-animal.html
It is a story of a old man on the beach who sees a young boy walking along throwing starfish back in the ocean. The man tells the boy there are miles of stranded starfish, he won't make a difference. The boy throws another one back in the ocean and tells the old man that it made a difference to that one.
http://wiki.answers.com/Q/What_is_the_symbolism_of_the_starfish
once read as a symbol of healing and regeneration
http://www.whats-your-sign.com/love-symbol-animal.html
Starfish: In Christian symbolism the Starfish represents the Virgin Mary (Stella Maris which means Star of the Sea) who lovingly creates safe travel over troubled waters and is also seen as an emblem of salvation during trying times. The star as well as the Starfish are seen as celestial symbols and as such, they represent infinite divine love. In addition to love, the Starfish also holds characteristics such as guidance, vigilance, inspiration, brilliance and intuition. |
Thursday, April 11, 2013
5 Ways To Be an Exceptional Leader
5 Ways To Be an Exceptional Leader
http://www.openforum.com/infographics/5-ways-to-be-an-exceptional-leader/
Thursday, February 7, 2013
Community-supported agriculture
http://en.wikipedia.org/wiki/Community-supported_agriculture
Community-supported agriculture (in North America sometimes known as community-shared agriculture)(CSA) is an alternative, locally-based socio-economic model of agriculture and food distribution. A CSA also refers to a particular network or association of individuals who have pledged to support one or more local farms, with growers and consumers sharing the risks and benefits of food production. CSA members or subscribers pay at the onset of the growing season for a share of the anticipated harvest; once harvesting begins, they receive weekly shares of vegetables and fruit, in a vegetable box scheme, and also sometimes herbs, cut flowers, honey, eggs, dairy products and meat, as well. Some CSAs provide for contributions of labor in lieu of a portion of subscription costs.
An example of a week's CSA share, includingbell peppers, okra, tomatoes, beans, potatoes,garlic, eggplant, and squash.
Community-supported agriculture (in North America sometimes known as community-shared agriculture)(CSA) is an alternative, locally-based socio-economic model of agriculture and food distribution. A CSA also refers to a particular network or association of individuals who have pledged to support one or more local farms, with growers and consumers sharing the risks and benefits of food production. CSA members or subscribers pay at the onset of the growing season for a share of the anticipated harvest; once harvesting begins, they receive weekly shares of vegetables and fruit, in a vegetable box scheme, and also sometimes herbs, cut flowers, honey, eggs, dairy products and meat, as well. Some CSAs provide for contributions of labor in lieu of a portion of subscription costs.
An example of a week's CSA share, includingbell peppers, okra, tomatoes, beans, potatoes,garlic, eggplant, and squash.
Friday, July 20, 2012
Good to Great
http://www.jimcollins.com/article_topics/articles/good-to-great.html
by Jim Collins
October 2001
Start with 1,435 good
companies. Examine their performance over 40 years. Find the 11
companies that became great. Now here's how you can do it too.
Lessons on eggs, flywheels, hedgehogs, buses, and other essentials
of business that can help you transform your company.
Monday, July 2, 2012
A small talk survival
"The key to small talk is to avoid in any way making conversation that has to do with business," says Daniel Menaker, author of A Good Talk,
about how conversations work. "By definition, small talk is not
goal-oriented. Or if it is goal-oriented, the goal is to make yourself
conversationally available to other people in a way that shows you are
not just single-mindedly entrepreneurial, but that you're a human being,
and that you can find common ground."
There's this thing psychologists call a "promotion orientation." It involves thinking of the conversation as a series of opportunities rather than a minefield of embarrassment (thinking of it that way is "prevention orientation"). The promotion orientation involves making eye contact and smiling. (Which are the two most powerful tools a person having a conversation has at his or her disposal. You can say, "I'm into string" to a total stranger, and if you say it with eye contact and a smile, it can seem brilliant.)
The second stage of small talk is all about promotion orientation. "Don't think, Don't say this, don't do something stupid, don't go on too long," says Sam Sommers, associate professor of psychology at Tufts University and author of Situations Matter: Understanding How Context Transforms Your World. "If you have all these don'ts and negatives in your head as you go into an interaction, you tend to come off looking like someone who had a bunch of negative thoughts in their head and distracted and not engaged."
At a party or a networking event (as opposed to a meeting, where the duration of small talk is somewhat fixed), there is a point at which you must decide if this is a conversation worth continuing or a conversation worth ending. The eyes are the deciding factor, not the conversation. If the other person's eyes wander, even a little bit, you should get out. If the eyes wander, you throw out your exit line. "I see a friend I need to speak to; it's been great talking to you." Or, more generously: "It's been great talking to you; I'll let you get to some other people now." Or, the best exit line ever developed: "I'm going to the bar. Can I get you something?" If the other person wants to continue the conversation, they will say yes. If they don't, they will say no. And so you act accordingly.
There's this thing psychologists call a "promotion orientation." It involves thinking of the conversation as a series of opportunities rather than a minefield of embarrassment (thinking of it that way is "prevention orientation"). The promotion orientation involves making eye contact and smiling. (Which are the two most powerful tools a person having a conversation has at his or her disposal. You can say, "I'm into string" to a total stranger, and if you say it with eye contact and a smile, it can seem brilliant.)
The second stage of small talk is all about promotion orientation. "Don't think, Don't say this, don't do something stupid, don't go on too long," says Sam Sommers, associate professor of psychology at Tufts University and author of Situations Matter: Understanding How Context Transforms Your World. "If you have all these don'ts and negatives in your head as you go into an interaction, you tend to come off looking like someone who had a bunch of negative thoughts in their head and distracted and not engaged."
At a party or a networking event (as opposed to a meeting, where the duration of small talk is somewhat fixed), there is a point at which you must decide if this is a conversation worth continuing or a conversation worth ending. The eyes are the deciding factor, not the conversation. If the other person's eyes wander, even a little bit, you should get out. If the eyes wander, you throw out your exit line. "I see a friend I need to speak to; it's been great talking to you." Or, more generously: "It's been great talking to you; I'll let you get to some other people now." Or, the best exit line ever developed: "I'm going to the bar. Can I get you something?" If the other person wants to continue the conversation, they will say yes. If they don't, they will say no. And so you act accordingly.
Saturday, June 23, 2012
Wet iPod
http://www.iphonebuzz.com/iphoneipod-touch-have-water-seals-on-them-171643.php
http://iphone.appstorm.net/how-to/phone/how-to-save-a-wet-iphone-or-ipod-touch/
http://www.ehow.com/how_5129870_fix-washed-ipod.html
http://www.ehow.com/info_12201355_can-short-circuited-ipod-fixed.html
http://www.lovelyish.com/743098910/how-to-save-your-ipod-if-it-gets-wet-do-nothing/
Forgot your iPod in the washing machine? Dropped it in the pool, tub or toilet? Here's some things to try before throwing it out:
http://iphone.appstorm.net/how-to/phone/how-to-save-a-wet-iphone-or-ipod-touch/
http://www.ehow.com/how_5129870_fix-washed-ipod.html
http://www.ehow.com/info_12201355_can-short-circuited-ipod-fixed.html
http://www.lovelyish.com/743098910/how-to-save-your-ipod-if-it-gets-wet-do-nothing/
Forgot your iPod in the washing machine? Dropped it in the pool, tub or toilet? Here's some things to try before throwing it out:
- Quickly pull it out from the water
- Don't turn it on (to avoid frying the circuits)
- Wipe off the liquids
- Don't heat it with a hair dryer
- Put the iPod inside a dry ziploc bag with rice grains (uncooked) (rice absorbs moisture) / silica packets
- Put the iPod in a warm dry place and leave it there for 1-2 days
- Charge it
- Cross your fingers and turn it on.
Sunday, May 27, 2012
sed subtitle fix
From (broken.srt)
00:00:14:267 --> 00:00:20:258
to (fixed.srt)
00:00:14,267 --> 00:00:20,258
cat broken.srt | sed -e 's/\([0-9]*\):\([0-9]*\):\([0-9]*\):\([0-9]*\)/\1:\2:\3,\4/g' > fixed.srt
00:00:14:267 --> 00:00:20:258
to (fixed.srt)
00:00:14,267 --> 00:00:20,258
cat broken.srt | sed -e 's/\([0-9]*\):\([0-9]*\):\([0-9]*\):\([0-9]*\)/\1:\2:\3,\4/g' > fixed.srt
Wednesday, May 23, 2012
Talks
1. This Monumental Shift - Exploring the Future of Behaviour, Technology, the Web and Canada's Place in it
Leonard Brody, Business and Technology Visionary
https://www.bc.net/atl-conf/display/BCNETCONF2012/This+Monumental+Shift+-+Exploring+the+Future+of+Behaviour%2C+Technology%2C+the+Web+and+Canada%27s+Place+in+it
2. The End of Wonder in the Age of Whatever
Michael Wesch, cultural anthropologist
https://www.bc.net/atl-conf/display/BCNETCONF2012/The+End+of+Wonder+in+the+Age+of+Whatever
To question is to:
- quest
- embrace our vulnerability
- invite connections
Media change - relationship change
http://en.wikipedia.org/wiki/Opsound
is a website which aggregates links to music released under Creative Commons licenses. Opsound aggregates links to music hosted on other servers, as well as providing discussion forums and organizing real-world events and concerts.
OpenStreetMaps
https://www.bc.net/atl-conf/display/BCNETCONF2012/Keynotes
Leonard Brody, Business and Technology Visionary
https://www.bc.net/atl-conf/
2. The End of Wonder in the Age of Whatever
Michael Wesch, cultural anthropologist
https://www.bc.net/atl-conf/
To question is to:
- quest
- embrace our vulnerability
- invite connections
Media change - relationship change
http://en.wikipedia.org/wiki/Opsound
is a website which aggregates links to music released under Creative Commons licenses. Opsound aggregates links to music hosted on other servers, as well as providing discussion forums and organizing real-world events and concerts.
OpenStreetMaps
https://www.bc.net/atl-conf/display/BCNETCONF2012/Keynotes
Tuesday, May 22, 2012
Saturday, May 5, 2012
NVidia GeForce 8400 GS Video Card
http://www.tomshardware.com/forum/652-63-window-monitor-1680x1050-1920x1080-resolution-here
http://forums.nvidia.com/index.php?showtopic=21993&st=20
1. NVIDIA Control Panel > Display > Manage custom timings.
2. Click both "Treat as HDTV" and "Allow modes not exposed by the display"
3. Click [Create...]
4. Under Custom display mode values:
Horizontal desktop pixels: 1440
Vertical desktop lines: 900
GDI Refresh rate: 60
Bits per pixel: 32
(don't have "Interlaced" checked)
5. Click [Advanced >>] (by the way this is where I didn't go when NVIDIA emailed me)
6. Under "Back-end parameters":
Timing standard: DMT
Desired refresh rate: 60
(the rest of the fields are grayed out)
7. Under "Front-end paramers"
Scaling type: Display (none)
8. Click [Test]
9. Click [OK]
Beta driver fix for not being able to save custom resolution
http://www.nvidia.com/object/win7-winvista-64bit-301.24-beta-driver.html
http://forums.nvidia.com/index.php?showtopic=189757
Use version 258.96?
http://www.tomshardware.com/forum/54194-3-resolution-higher-native
"LCDs cannot go beyond native resolution. It is phyiscally impossible since due to the specific number of pixel.
What might be happening is the resolution is being down converted back to native resolution or it sets the "usable" desktop space to 1920 x 1080 (or whatever), but only 1440 x 900 is displayed at a time. You would need to scroll to view the rest of the "usable" desktop space." -- works for CRTs though ...
http://answers.yahoo.com/question/index?qid=20070901023705AArlQAA
*Your monitor, Model : L196WTQ-BF is the finest 19" currently offered by LG and your NVidia does not even warm up to do this.
MONITOR:
The LG is a great 19" and 1440 x 900 is not stressing it at all. This is the "Native" resolution which means 1440 x 900 is the "optimum" or "perfect" resolution setting for this monitor. Contrary to popular belief, the maximum resolution can be configured considerably higher. With a bit of tweaking my 19" wide LCD and NVidia GeForce-256 displays 1920 x 1200 just fine. Also, using the 32bit color depth setting actually displays the monitor’s max of 24bit.
http://forums.nvidia.com/index.php?showtopic=21993&st=20
1. NVIDIA Control Panel > Display > Manage custom timings.
2. Click both "Treat as HDTV" and "Allow modes not exposed by the display"
3. Click [Create...]
4. Under Custom display mode values:
Horizontal desktop pixels: 1440
Vertical desktop lines: 900
GDI Refresh rate: 60
Bits per pixel: 32
(don't have "Interlaced" checked)
5. Click [Advanced >>] (by the way this is where I didn't go when NVIDIA emailed me)
6. Under "Back-end parameters":
Timing standard: DMT
Desired refresh rate: 60
(the rest of the fields are grayed out)
7. Under "Front-end paramers"
Scaling type: Display (none)
8. Click [Test]
9. Click [OK]
Beta driver fix for not being able to save custom resolution
http://www.nvidia.com/object/win7-winvista-64bit-301.24-beta-driver.html
http://forums.nvidia.com/index.php?showtopic=189757
Use version 258.96?
http://www.tomshardware.com/forum/54194-3-resolution-higher-native
"LCDs cannot go beyond native resolution. It is phyiscally impossible since due to the specific number of pixel.
What might be happening is the resolution is being down converted back to native resolution or it sets the "usable" desktop space to 1920 x 1080 (or whatever), but only 1440 x 900 is displayed at a time. You would need to scroll to view the rest of the "usable" desktop space." -- works for CRTs though ...
http://answers.yahoo.com/question/index?qid=20070901023705AArlQAA
*Your monitor, Model : L196WTQ-BF is the finest 19" currently offered by LG and your NVidia does not even warm up to do this.
MONITOR:
The LG is a great 19" and 1440 x 900 is not stressing it at all. This is the "Native" resolution which means 1440 x 900 is the "optimum" or "perfect" resolution setting for this monitor. Contrary to popular belief, the maximum resolution can be configured considerably higher. With a bit of tweaking my 19" wide LCD and NVidia GeForce-256 displays 1920 x 1200 just fine. Also, using the 32bit color depth setting actually displays the monitor’s max of 24bit.
Wednesday, April 25, 2012
Monday, April 23, 2012
Sunday, April 22, 2012
Squeaky Wheels of Debate
Squeaky Wheels. We often
talk about the importance of having a diverse network, one that includes
people who think differently than you, challenge your ideas or engage
you in debate. And though we may find these relationships uncomfortable
at times, research by Charlan Nemeth at the University of California
shows that this slight discomfort actually makes us more creative. When
teams were asked to solve a problem by brainstorming--where a safe
environment was created and no idea was criticized--the debaters (who
challenged each other) came up with twenty percent more ideas then the
brainstormers. And, when individual team members were later asked for
more ideas, the brainstormers produced an average of three ideas, the
debaters produced seven. According to Nemeth, "debate and criticism do
not inhibit ideas but, rather stimulate them." Best advice: don't
remove the squeaky wheels from you network, instead embrace them.
www.workthepond.com
www.workthepond.com
Thursday, April 19, 2012
Textfree Web for Free Unlimited Texting
http://pinger.com/textfree/
text message
SMS
http://www.mydigitallife.info/how-to-get-us-phone-number-virtual-number-for-free/
http://receive-sms-online.com/
text and talk free
Pinger lets you call any phone in the US and Canada, including landlines and non-smartphones. Plus get free unlimited texts to over 35 countries.text message
SMS
http://www.mydigitallife.info/how-to-get-us-phone-number-virtual-number-for-free/
http://receive-sms-online.com/
Subscribe to:
Posts (Atom)