Friday, September 13, 2013
Monday, May 11, 2009
find dup()
Sub FindDups()'' NOTE: You must select the first cell in the column and' make sure that the column is sorted before running this macro'ScreenUpdating = FalseFirstItem = ActiveCell.ValueSecondItem = ActiveCell.Offset(1, 0).ValueOffsetcount = 1Do While ActiveCell <> ""If FirstItem = SecondItem ThenActiveCell.Offset(Offsetcount, 0).Interior.Color = RGB(255, 0, 0)Offsetcount = Offsetcount + 1SecondItem = ActiveCell.Offset(Offsetcount, 0).ValueElseActiveCell.Offset(Offsetcount, 0).SelectFirstItem = ActiveCell.ValueSecondItem = ActiveCell.Offset(1, 0).ValueOffsetcount = 1End IfLoopScreenUpdating = TrueEnd Sub
/* remove trailing and leading white spaces */
Sub WhiteSpacer()Dim cel As Range, rg As RangeSet rg = SelectionIf rg.Cells.Count = 1 Then Set rg = ActiveSheet.UsedRangeSet rg = rg.SpecialCells(xlCellTypeConstants)If rg Is Nothing Then Exit SubApplication.ScreenUpdating = TrueFor Each cel In rg.Cells 'Replace requires Excel 2000 or later. For Excel 97, use Application.Substitute instead cel = Trim(Replace(cel, Chr(160), Chr(32))) 'VBA Trim removes leading and trailing spaces only 'cel = Application.Trim(Replace(cel, Chr(160), Chr(32))) 'TRIM function removes leading and trailing spaces, and converts multiple spaces in succession into a single oneNextApplication.ScreenUpdating = TrueEnd Sub
/* remove trailing and leading white spaces */
Sub WhiteSpacer()Dim cel As Range, rg As RangeSet rg = SelectionIf rg.Cells.Count = 1 Then Set rg = ActiveSheet.UsedRangeSet rg = rg.SpecialCells(xlCellTypeConstants)If rg Is Nothing Then Exit SubApplication.ScreenUpdating = TrueFor Each cel In rg.Cells 'Replace requires Excel 2000 or later. For Excel 97, use Application.Substitute instead cel = Trim(Replace(cel, Chr(160), Chr(32))) 'VBA Trim removes leading and trailing spaces only 'cel = Application.Trim(Replace(cel, Chr(160), Chr(32))) 'TRIM function removes leading and trailing spaces, and converts multiple spaces in succession into a single oneNextApplication.ScreenUpdating = TrueEnd Sub
Saturday, April 18, 2009
Two Choices ONLY !!
Two Choices
What would you do?....you make the choice. Don't look for a punch line, there isn't one. Read it anyway. My question is: Would you have made the same choice?
At a fundraising dinner for a school that serves children with learning disabilities, the father of one of the students delivered a speech that would never be forgotten by all who attended. After extolling the school and its dedicated staff, he offered a question:
'When not interfered with by outside influences, everything nature does, is done with perfection.
Yet my son, Shay, cannot learn things as other children do. He cannot understand things as other children do.
Where is the natural order of things in my son?'
The audience was stilled by the query.
The father continued. 'I believe that when a child like Shay, who was mentally and physically disabled comes into the world, an opportunity to realize true human nature presents itself, and it comes in the way other people treat that child.'
Then he told the following story:
Shay and I had walked past a park where some boys Shay knew were playing baseball. Shay asked, 'Do you think they'll let me play?' I knew that most of the boys would not want someone like Shay on their team, but as a father I also understood that if my son were allowed to play, it would give him a much-needed sense of belonging and some confidence to be accepted by others in spite of his handicaps.
I approached one of the boys on the field and asked (not expecting much) if Shay could play. The boy looked around for guidance and said, 'We're losing by six runs and the game is in the eighth inning. I guess he can be on our team and we'll try to put him in to bat in the ninth inning.'
Shay struggled over to the team's bench and, with a broad smile, put on a team shirt. I watched with a small tear in my eye and warmth in my heart. The boys saw my joy at my son being accepted.
In the bottom of the eighth inning, Shay's team scored a few runs but was still behind by three.
In the top of the ninth inning, Shay put on a glove and played in the right field. Even though no hits came his way, he was obviously ecstatic just to be in the game and on the field, grinning from ear to ear as I wav ed to him from the stands.
In the bottom of the ninth inning, Shay's team scored again.
Now, with two outs and the bases loaded, the potential winning run was on base and Shay was scheduled to be next at bat.
At this juncture, do they let Shay bat and give away their chance to win the game?
Surprisingly, Shay was given the bat. Everyone knew that a hit was all but impossible because Shay didn't even know how to hold the bat properly, much less connect with the ball.
However, as Shay stepped up to the
plate, the pitcher, recognizing that the other team was putting winning aside for this moment in Shay's life, moved in a few steps to lob the ball in softly so Shay could at least make contact.
The first pitch came and Shay swung clumsily and missed.
The pitcher again took a few steps forward to toss the ball softly towards Shay.
As the pitch came in, Shay swung at the ball and hit a slow ground ball right b ask to the pitcher.
The game would now be over.
The pitcher picked up the soft grounder and could have easily thrown the ball to the first baseman.
Shay would have been out and that would have been the end of the game.
Instead, the pitcher threw the ball right over the first baseman's head, out of reach of all team mates.
Everyone from the stands and both teams started yelling, 'Shay, run to first!
Run to first!'
Never in his life had Shay ever run that far, but he made it to first base.
He scampered down the baseline, wide-eyed and startled.
Everyone yelled, 'Run to second, run to second!'
Catching his breath, Shay awkwardly ran towards second, gleaming and struggling to make it to the base.
B y the time Shay rounded towards second base, the right fielder had the ball .. the smallest guy on their team who now had his first chance to be the hero for his team.
He could have thrown the ball to the second-baseman for the tag, but he understood the pitcher's intentions so he, too, intentionally threw the ball high and far over the third-baseman's head.
Shay ran toward third base deliriously as the runners ahead of him circled the bases toward home.
All were screaming, 'Shay, Shay, Shay, all the Way Shay'
Shay reached third base because the opposing shortstop ran to help him by turning him in the direction of third base, and shouted, 'Run to third!
Shay, run to third!'
As Shay rounded third, the boys from both teams, and the spectators, were on their feet screaming, 'Shay, run home! Run home!'
Shay ran to home, stepped on the plate, and was cheered as the hero who hit the grand slam and won the game for his team
'That day', said the father softly with tears now rolling down his face, 'the boys from both teams helped bring a piece of true love and humanity into this world'.
Shay didn't make it to another summer. He died that winter, having never forgotten being the hero and making me so happy, and coming home and seeing his Mother tearfully embrace her little hero of the day!
AND NOW A LITTLE FOOT NOTE TO THIS STORY:
We all send thousands of jokes through the e-mail without a second thought, but when it comes to sending messages about life choices, people hesitate.
The crude, vulgar, and often obscene pass freely through cyberspace, but public discussion about decency is too often suppressed in our schools and workplaces.
We all have thousands of opportunities every single day to help realize the 'natural order of things.'
So many seemingly trivial interactions between two people present us with a choice:
Do we pass along a little spark of love and humanity or do we pass up those opportunities and leave the world a little bit colder in the process?
A wise man once said every society is judged by how it treats it's least fortunate amongst them.
You now have two choices:
1. Pass the Love around
2. Ignore it and keep doing what you do
.. and regardless either choice.. May your day, be a Shay Day.
What would you do?....you make the choice. Don't look for a punch line, there isn't one. Read it anyway. My question is: Would you have made the same choice?
At a fundraising dinner for a school that serves children with learning disabilities, the father of one of the students delivered a speech that would never be forgotten by all who attended. After extolling the school and its dedicated staff, he offered a question:
'When not interfered with by outside influences, everything nature does, is done with perfection.
Yet my son, Shay, cannot learn things as other children do. He cannot understand things as other children do.
Where is the natural order of things in my son?'
The audience was stilled by the query.
The father continued. 'I believe that when a child like Shay, who was mentally and physically disabled comes into the world, an opportunity to realize true human nature presents itself, and it comes in the way other people treat that child.'
Then he told the following story:
Shay and I had walked past a park where some boys Shay knew were playing baseball. Shay asked, 'Do you think they'll let me play?' I knew that most of the boys would not want someone like Shay on their team, but as a father I also understood that if my son were allowed to play, it would give him a much-needed sense of belonging and some confidence to be accepted by others in spite of his handicaps.
I approached one of the boys on the field and asked (not expecting much) if Shay could play. The boy looked around for guidance and said, 'We're losing by six runs and the game is in the eighth inning. I guess he can be on our team and we'll try to put him in to bat in the ninth inning.'
Shay struggled over to the team's bench and, with a broad smile, put on a team shirt. I watched with a small tear in my eye and warmth in my heart. The boys saw my joy at my son being accepted.
In the bottom of the eighth inning, Shay's team scored a few runs but was still behind by three.
In the top of the ninth inning, Shay put on a glove and played in the right field. Even though no hits came his way, he was obviously ecstatic just to be in the game and on the field, grinning from ear to ear as I wav ed to him from the stands.
In the bottom of the ninth inning, Shay's team scored again.
Now, with two outs and the bases loaded, the potential winning run was on base and Shay was scheduled to be next at bat.
At this juncture, do they let Shay bat and give away their chance to win the game?
Surprisingly, Shay was given the bat. Everyone knew that a hit was all but impossible because Shay didn't even know how to hold the bat properly, much less connect with the ball.
However, as Shay stepped up to the
plate, the pitcher, recognizing that the other team was putting winning aside for this moment in Shay's life, moved in a few steps to lob the ball in softly so Shay could at least make contact.
The first pitch came and Shay swung clumsily and missed.
The pitcher again took a few steps forward to toss the ball softly towards Shay.
As the pitch came in, Shay swung at the ball and hit a slow ground ball right b ask to the pitcher.
The game would now be over.
The pitcher picked up the soft grounder and could have easily thrown the ball to the first baseman.
Shay would have been out and that would have been the end of the game.
Instead, the pitcher threw the ball right over the first baseman's head, out of reach of all team mates.
Everyone from the stands and both teams started yelling, 'Shay, run to first!
Run to first!'
Never in his life had Shay ever run that far, but he made it to first base.
He scampered down the baseline, wide-eyed and startled.
Everyone yelled, 'Run to second, run to second!'
Catching his breath, Shay awkwardly ran towards second, gleaming and struggling to make it to the base.
B y the time Shay rounded towards second base, the right fielder had the ball .. the smallest guy on their team who now had his first chance to be the hero for his team.
He could have thrown the ball to the second-baseman for the tag, but he understood the pitcher's intentions so he, too, intentionally threw the ball high and far over the third-baseman's head.
Shay ran toward third base deliriously as the runners ahead of him circled the bases toward home.
All were screaming, 'Shay, Shay, Shay, all the Way Shay'
Shay reached third base because the opposing shortstop ran to help him by turning him in the direction of third base, and shouted, 'Run to third!
Shay, run to third!'
As Shay rounded third, the boys from both teams, and the spectators, were on their feet screaming, 'Shay, run home! Run home!'
Shay ran to home, stepped on the plate, and was cheered as the hero who hit the grand slam and won the game for his team
'That day', said the father softly with tears now rolling down his face, 'the boys from both teams helped bring a piece of true love and humanity into this world'.
Shay didn't make it to another summer. He died that winter, having never forgotten being the hero and making me so happy, and coming home and seeing his Mother tearfully embrace her little hero of the day!
AND NOW A LITTLE FOOT NOTE TO THIS STORY:
We all send thousands of jokes through the e-mail without a second thought, but when it comes to sending messages about life choices, people hesitate.
The crude, vulgar, and often obscene pass freely through cyberspace, but public discussion about decency is too often suppressed in our schools and workplaces.
We all have thousands of opportunities every single day to help realize the 'natural order of things.'
So many seemingly trivial interactions between two people present us with a choice:
Do we pass along a little spark of love and humanity or do we pass up those opportunities and leave the world a little bit colder in the process?
A wise man once said every society is judged by how it treats it's least fortunate amongst them.
You now have two choices:
1. Pass the Love around
2. Ignore it and keep doing what you do
.. and regardless either choice.. May your day, be a Shay Day.
Friday, April 17, 2009
Prophet and Loss
Brooksley Born warned that unchecked trading in the credit market could lead to disaster, but power brokers in Washington ignored her. Now we're all paying the price.
[..]
As chairperson of the CFTC, Born advocated reining in the huge and growing market for financial derivatives. Derivatives get their name because the value is derived from fluctuations in, for example, interest rates or foreign exchange. They started out as ways for big corporations and banks to manage their risk across a range of investments. One type of derivative—known as a credit-default swap—has been a key contributor to the economy’s recent unraveling.
Monday, October 27, 2008
A subprime Primer
Heres a nice SubPrime Primer for all to understand the brokerage business.
Subprime Primer
View SlideShare presentation or Upload your own.
Tuesday, October 21, 2008
Conversational Blindness—Answering the Wrong Question the Right Way
When faced with unwanted queries, question-dodgers sometimes exploit conversational blindness—a phenomenon whereby listeners fail to notice when speakers respond to a different question than the one they are asked—by responding with answers that seem to address the question asked, but which in fact address an entirely different question. [..] A successful dodge occurs when a speaker's answer to the wrong question is so compelling that the listener both forgets the right one, and rates the dodger positively. In some cases, speakers end up better off by answering the wrong question well rather than the right question poorly.
This is an interesting paper to read. It reminds me of the mother asking the child -" have you done your homework ?" and where the child responds "mom , you know what I did in school today ? I wrote the whole equation on the black board , when nobody in the class knew how to solve the problem" !
Subject change - relevant to school , but not relevant to homework !
Whose Value Statement ?
Does anyone know which org's value statement this is ?
We lead by example | We work together | We respect the individual | We seek the facts and provide insight
We are open and honest in our communication | We are committed to our communities
Above all, we act with integrity
Monday, October 20, 2008
Due Dilgence prepardness checklist
Investor presentation prepared: Yes
OM/PPM prepared: No
Business plan prepared: Yes
Executive summary prepared: Yes
3 year projections prepared: Yes
3 year historical prepared: Yes
Financials externally reviewed: No
Financials externally audited: No
Financials prepared by: External CPA
Formal board in place: Yes
Willing to put in board if none: Yes
Option plan in place: No
Employee agreements: Yes
Board of directors agreements: No
Board of advisors agreements: No
Subscription agreements: No
Cap table shareholder list: No
Management directors: 2
Non-mgmt directors: 2
Non-mgmt non-shareholders: --
OM/PPM prepared: No
Business plan prepared: Yes
Executive summary prepared: Yes
3 year projections prepared: Yes
3 year historical prepared: Yes
Financials externally reviewed: No
Financials externally audited: No
Financials prepared by: External CPA
Formal board in place: Yes
Willing to put in board if none: Yes
Option plan in place: No
Employee agreements: Yes
Board of directors agreements: No
Board of advisors agreements: No
Subscription agreements: No
Cap table shareholder list: No
Management directors: 2
Non-mgmt directors: 2
Non-mgmt non-shareholders: --
Thursday, October 02, 2008
statements which make you go hmmmmmmmmmmm !!
This is a classic statement by Shivanand Velmurugan
"When a government asks 99% of the population who own less than half of the country's wealth to bail out the 1% of the population who own 51% of the wealth the population has to decide whether it wants bankruptcy before revolution or revolution before bankruptcy. It really is that simple.""
Thursday, August 28, 2008
Subscribe to:
Posts (Atom)
